training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
26 rows where "training:end_date" is on date 2007-04-21 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65f6b13f-5e8b-481f-aaa0-77db4387b418 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - FY 2007 DoS Training | UH-60 FLIGHT SIMULATOR | US unit not specified in 2007-2008 report | Army | 4/17/2007 | 2007-04-17 | 4/21/2007 | 2007-04-21 | XVIII AIRBORNE CORPS (& FORT BRAGG ?) | 6 | 2712 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 9b5fc151-7618-4c53-9cde-8a95b08dc7c8 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - FY 2007 DoS Training | HARRIS RADIOS ROCHESTER NY | US unit not specified in 2007-2008 report | Army | 4/16/2007 | 2007-04-16 | 4/21/2007 | 2007-04-21 | HARRIS | 2 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 52414486-238b-41f8-99c0-11f02340d3cc | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 98d98565-fd15-410b-bf0b-f2fe565d426d | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| b29b1bec-0662-4915-8b51-4f8e61db3864 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| d6819404-c1db-4d5b-8a9d-a5a4fffff3a8 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| eb44e205-3946-4d27-b71b-e6dae1ee62c5 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| d2037df5-d42b-4c14-bbf8-1131e3c57c32 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 2bac2d8b-1db3-4b38-a784-2d5febf87bec | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| ee6dd977-1826-4583-ac6f-738d31431a54 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 987e5986-bde0-42e8-a6c4-e671cf1dfc65 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 46864560-1585-442c-92b6-b23bc34d306b | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 75177dfe-3809-4484-9e2e-d82661334be4 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 05cc7c73-7606-415b-9336-0a85f55696a4 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| f7f397e0-8dce-4ac9-8691-d87c427b9530 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 3353e1f7-d5c0-46bb-81f3-589acbca00cb | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 187f5d33-cc64-4cbb-9baa-c4f53743981d | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| f1d1d3d5-74aa-4320-bd68-89216f22afd6 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 13200 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 7bafe2d4-2988-4cde-b85f-3539d5104042 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| dbcfec4c-0f13-4cfa-83de-35878e36fb13 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| ed8c3986-1686-4dca-9192-03915b6fd7ed | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 79d8eb01-d114-405d-8410-22824de293ea | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 075a8b58-6bbf-4508-8ae8-c89e0e779938 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 1aeaba27-cc43-42f4-a094-b9876ae84e89 | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 06f79961-46f6-4977-a66a-4718bb7caf4b | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | https://2009-2017.state.gov/documents/organization/126578.pdf | Not checked against source; verify accuracy before use | 2008-01-31 | 2019-07-16 |
| 70961fc3-3aee-4abf-a05c-03437df4666a | 258be1a1-a9e5-4d7f-b8b0-0500a2714580 | 2007_2008_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | IMET-1 - FY 2007 DoS Training | MET JOINT CTR NARC EIMET | US unit not specified in 2007-2008 report | Pacific Naval Base | 4/15/2007 | 2007-04-15 | 4/21/2007 | 2007-04-21 | COGARD INTL TRNG DET TRACEN YORKTOWN VA | 1 | 0 | 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]);