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 (hide)

select [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] from [training-data] where "training:country_iso_3166_1" = :p0 and rowid in (select rowid from [training-data_fts] where [training-data_fts] match escape_fts(:search)) order by [qa:training_source_url] limit 101

Query parameters

admin

country

training_country_iso_3166_1

program

course_title

delivery_unit

recipient_unit

start_date_raw

training_start_date_clean

end_date_raw

training_end_date_clean

location

quantity

total_cost

page_number

date_first_seen

data_scraped

status

source_at_publication_level

source_at_volume_section_level

training_group

training_source_url

citation_id

source_title_with_volume_section

0 results