training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
14 rows where "qa:training_date_first_seen" is on date 2008-01-31, "training:end_date" is on date 2007-08-07 and "training:start_date" is on date 2007-05-07 sorted by training:start_date descending
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ec74f495-6ce4-4f70-90f9-6ca34a72343c | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Bolivia | BOL | Section 1004 - FY 2007 DoD Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 4 | 47928 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
41fcd1eb-04bd-48b5-b191-24c928b8c239 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | Section 1004 - FY 2007 DoD Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 12862 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
c678fefd-a872-4f31-ae29-48ad4a6c6049 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2007 DoS Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 3 | 7863 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
4d78b2a9-f159-49f9-b275-562a3d15b0ed | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Costa Rica | CRI | IMET-X - FY 2007 DoS Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 11182 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
4242ac30-c96c-41f1-8564-4c28dc3b3536 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | Section 1004 - FY 2007 DoD Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 4 | 48425 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
ac5ec0a3-80c3-4a91-b554-1cbc93ccef33 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | IMET-X - FY 2007 DoS Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 12134 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
946d030e-710c-4d67-88f8-cb99ece11e93 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - FY 2007 DoD Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 2 | 24768 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
e6f6823c-67bb-48c8-8c43-c88fd0cd178d | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | El Salvador | SLV | Section 1004 - FY 2007 DoD Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 17611 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
44209cc8-f51c-4bad-aecb-a482bfcb3c39 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | IMET-1 - FY 2007 DoS Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 11632 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
98ec095f-ccd8-422f-bc2c-a6d84f3fce21 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Honduras | HND | Section 1004 - FY 2007 DoD Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 3 | 34896 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
02223be2-5dd4-4b40-b3a9-28d50c16c140 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | CTFP - FY 2007 DoD Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 2 | 22492 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
6739d737-4d2f-47af-86c5-a86a35686000 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Nicaragua | NIC | Section 1004 - FY 2007 DoD Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 11546 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
c5fe3f84-cb60-4964-aece-597b6e537a0e | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | IMET-1 - FY 2007 DoS Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 2 | 23364 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
07791344-b576-439e-8fe5-7ea68674fab1 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Peru | PER | IMET-X - FY 2007 DoS Training | INTELLIGENCE OFFICER BASIC | US unit not specified in 2007-2008 report | Army | 5/7/2007 | 2007-05-07 | 8/7/2007 | 2007-08-07 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 1 | 11782 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "training-data" ( [training:id:admin] TEXT PRIMARY KEY, [training:source] TEXT, [qa:training_group] TEXT, [training:country] TEXT, [training:country_iso_3166_1] TEXT, [training:program] TEXT, [training:course_title] TEXT, [training:delivery_unit] TEXT, [training:recipient_unit] TEXT, [qa:training_start_date] TEXT, [training:start_date] TEXT, [qa:training_end_date] TEXT, [training:end_date] TEXT, [training:location] TEXT, [training:quantity] INTEGER, [training:total_cost] INTEGER, [qa:training_source_url] TEXT, [training:status:admin] TEXT, [qa:training_date_first_seen] TEXT, [qa:training_date_scraped] TEXT ); CREATE INDEX [idx_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] ON [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]);