training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
9 rows where "training:end_date" is on date 2019-08-27 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0bfddce9-af92-404d-8e16-6a4573b69f70 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | DOHS/USCG - Fiscal Year 2019 Department of Homeland Security Training | On-Line Pre-requisite | COGARD Training Center Yorktown, VA | SEMAR | 8/22/2019 | 2019-08-22 | 8/27/2019 | 2019-08-27 | Yorktown, VA, US | 1 | 2733 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
| 95fc3653-1c88-4916-886c-a9d9957aa113 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2019 Department of State Training | International EOD Specialized Missile | Naval School Explosive Ordnance Disposal | MILITARY ENGINEERS | 8/15/2019 | 2019-08-15 | 8/27/2019 | 2019-08-27 | Eglin AFB, FL, US | 1 | 1397 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
| 270c0be2-ba30-489b-84b6-ba07ef1448c6 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2019 Department of State Training | International EOD Specialized Missile | Naval School Explosive Ordnance Disposal | NAVAL FORCES | 8/15/2019 | 2019-08-15 | 8/27/2019 | 2019-08-27 | Eglin AFB, FL, US | 1 | 1397 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
| ca63755f-325e-4927-8060-e077bceba293 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | Section 333 - Fiscal Year 2019 Department of Defense Training | USCAP - UH-1H Basic Maintenance Course | USCAP | Multiple | 8/4/2019 | 2019-08-04 | 8/27/2019 | 2019-08-27 | Santo Domingo, Dominican Republic | 6 | 33960 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
| db3d61f3-7df2-4af4-9ce7-00e075614c9a | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2019 Department of State Training | International EOD Specialized Missile | Naval School Explosive Ordnance Disposal | CAIRO WEST SIR BASE | 6/11/2019 | 2019-06-11 | 8/27/2019 | 2019-08-27 | Eglin AFB, FL, US | 1 | 9517 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
| 5880a8ae-be53-4fd7-8973-e0c1e9e55201 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | FMF - Fiscal Year 2019 Department of State Training | Basic Public Affairs Specialist | Defense Information School | COAST GUARD PUBLIC AFFAIRS OFFICE, PHIL COAST GUARD | 6/3/2019 | 2019-06-03 | 8/27/2019 | 2019-08-27 | Ft. Meade, MD, US | 1 | 30412 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
| 7eb3e45d-2dc9-4fee-8b40-3919394210de | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2019 Department of State Training | Air Traffic Control Apprentice | Keesler AFB, MS | AIR OPERATIONS DIRECTORATE | 5/20/2019 | 2019-05-20 | 8/27/2019 | 2019-08-27 | Keesler AFB, MS, US | 1 | 10499 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
| c0ba5166-2985-4d99-820f-68c8467c3a47 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Europe_fmtrpt.tsv | Kosovo | XKX | IMET-1 - Fiscal Year 2019 Department of State Training | Adjutant General Captains Career | Adjutant General School | KSF, Land Forces Command, HQ | 4/8/2019 | 2019-04-08 | 8/27/2019 | 2019-08-27 | Ft. Jackson, SC, US | 1 | 36269 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
| 90292627-38f1-4d38-9c53-81ecbe0d2740 | 730b2c0f-4eb6-4dbb-af57-2be9eb32031a | 2019_2020_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2019 Department of State Training | Weather Forecaster Apprentice | Keesler AFB, MS | SOUTHERN MILITARY ZONE | 1/14/2019 | 2019-01-14 | 8/27/2019 | 2019-08-27 | Keesler AFB, MS, US | 1 | 26347 | https://www.state.gov/wp-content/uploads/2021/08/Volume-I-508-Compliant.pdf | Not checked against source; verify accuracy before use | 2021-08-04 | 2021-08-06 |
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]);