home

state-department-data

Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more

Custom SQL query

Tables

training-data

training:id:admin, training:source, qa:training_group, training:country, training:country_iso_3166_1, training:program, training:course_title, training:delivery_unit, training:recipient_unit, qa:training_start_date, training:start_date, qa:training_end_date, training:end_date, training:location, training:quantity, training:total_cost, qa:training_source_url, training:status:admin, qa:training_date_first_seen, qa:training_date_scraped

237,603 rows

training-data_fts (hidden)

training:id:admin, training:source, qa:training_group, training:country, training:country_iso_3166_1, training:program, training:course_title, training:delivery_unit, training:recipient_unit, qa:training_start_date, training:start_date, qa:training_end_date, training:end_date, training:location, training:quantity, training:total_cost, qa:training_source_url, training:status:admin, qa:training_date_first_seen, qa:training_date_scraped, training-data_fts, rank

237,603 rows

training-data_fts_config (hidden)

k, v

1 row

training-data_fts_data (hidden)

id, block

24,004 rows

training-data_fts_docsize (hidden)

id, sz

237,603 rows

training-data_fts_idx (hidden)

segid, term, pgno

7,723 rows

Download SQLite DB: state-department-data.db 343.3 MB

Powered by Datasette · Queries took 6.596ms · Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more