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:country, qa:training_country_iso_3166_1, training:program, training:course_title, training:delivery_unit, training:recipient_unit, training:start_date_raw, qa:training_start_date_clean, training:end_date_raw, qa:training_end_date_clean, training:location, training:quantity, training:total_cost, training:page_number, training:date_first_seen:admin, training:data_scraped:admin, training:status:admin, training:source_at_publication_level:admin, training:source_at_volume_section_level:admin, qa:training_group, qa:training_source_url, training:citation_id:admin, training:source_title_with_volume_section:admin

255,007 rows

training-data_fts (hidden)

training:id:admin, training:country, qa:training_country_iso_3166_1, training:program, training:course_title, training:delivery_unit, training:recipient_unit, training:start_date_raw, qa:training_start_date_clean, training:end_date_raw, qa:training_end_date_clean, training:location, training:quantity, training:total_cost, training:page_number, training:date_first_seen:admin, training:data_scraped:admin, training:status:admin, training:source_at_publication_level:admin, training:source_at_volume_section_level:admin, qa:training_group, qa:training_source_url, training:citation_id:admin, training:source_title_with_volume_section:admin, training-data_fts, rank

255,007 rows

training-data_fts_config (hidden)

k, v

1 row

training-data_fts_data (hidden)

id, block

35,451 rows

training-data_fts_docsize (hidden)

id, sz

255,007 rows

training-data_fts_idx (hidden)

segid, term, pgno

12,266 rows

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