training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
21 rows where "qa:training_date_first_seen" is on date -4707-05-30 and "training:end_date" is on date 2013-08-08 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| b5b0d461-ea68-4f34-a1a6-a43f5d8a1266 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv | Thailand | THA | DOHS/USCG - Fiscal Year 2013 Department of Homeland Security Training | CONUS - Post Assessment Seminar and Site Visit | COGARD TRAINING CENTER YORKTOWN VA | Marine Police Division, Royal Thai Police | 8/5/2013 | 2013-08-05 | 8/8/2013 | 2013-08-08 | COGARD TRAINING CENTER YORKTOWN VA | 1 | 4138 | https://2009-2017.state.gov/documents/organization/230211.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 2d9832cf-f281-4cf7-9670-7c52f680507a | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2013 Department of State Training | AH-64 Flight Simulator | WESTERN ARMY AVIATION TRAINING SITE | 190TH SQUADRON | 8/5/2013 | 2013-08-05 | 8/8/2013 | 2013-08-08 | WESTERN ARMY AVIATION TRAINING SITE | 6 | 15372 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| c3d8ac63-3902-4a99-b8d0-c2308487708a | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2013 Department of Defense Training | FMV MTT | N/A | SEDENA | 8/5/2013 | 2013-08-05 | 8/8/2013 | 2013-08-08 | Mexico City, Mexico | 5 | 0 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| a932f016-9bbf-47c7-90ad-594c33a445f4 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2013 Department of Defense Training | FMV MTT | N/A - 5 | SEDENA | 8/5/2013 | 2013-08-05 | 8/8/2013 | 2013-08-08 | Mexico City, Mexico | 1 | 21000 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| defbdbe2-68e9-4b38-b8bd-89815b782f24 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2013 Department of Defense Training | FMV MTT | N/A | SEMAR | 8/5/2013 | 2013-08-05 | 8/8/2013 | 2013-08-08 | Mexico City, Mexico | 2 | 0 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| cabe7a15-24ac-4135-b1fa-69ce63f77b00 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | IMET-1 - Fiscal Year 2013 Department of State Training | MET Regional Civil-Military RELS | SRI LANKA (IN COUNTRY TRAINING) | Navy | 7/26/2013 | 2013-07-26 | 8/8/2013 | 2013-08-08 | SRI LANKA (IN COUNTRY TRAINING) | 1 | 7080 | https://2009-2017.state.gov/documents/organization/230217.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| a390cdee-7168-421b-9de2-cce799617bbb | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2013 Department of State Training | Instructor Development Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | CARIBBEAN COAST GUARD STATION | 7/26/2013 | 2013-07-26 | 8/8/2013 | 2013-08-08 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 5711 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 48257fa9-0c96-4101-b044-8e44ff676560 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2013 Department of State Training | Instructor Development Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | PACIFIC COAST GUARD STATION | 7/26/2013 | 2013-07-26 | 8/8/2013 | 2013-08-08 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 5711 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| b4f0d9d4-1adb-423b-a9a1-fbc55785fb45 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Costa Rica | CRI | Section 1004 - Fiscal Year 2013 Department of Defense Training | Combat Life Saver Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | COSTA RICA COAST GUARD | 7/26/2013 | 2013-07-26 | 8/8/2013 | 2013-08-08 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 3973 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 4c9a6c42-021c-44e3-9b37-498b0fafc2e1 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - Fiscal Year 2013 Department of Defense Training | Instructor Development Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | ``Atahualpa`` Vessel | 7/26/2013 | 2013-07-26 | 8/8/2013 | 2013-08-08 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 3973 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 2d40f5e6-8a45-460a-b37c-ca46229d8c0e | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - Fiscal Year 2013 Department of Defense Training | Instructor Development Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | ``San Eduardo`` Marines Base | 7/26/2013 | 2013-07-26 | 8/8/2013 | 2013-08-08 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 3973 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 685f10bc-3657-4e18-95f4-d2a3f8428c6b | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Section 1004 - Fiscal Year 2013 Department of Defense Training | Instructor Development Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Acuatic Spaces National Directorate | 7/26/2013 | 2013-07-26 | 8/8/2013 | 2013-08-08 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 3973 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| facf3222-b4e3-4ca3-b26c-ffa709f60f59 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2013 Department of Defense Training | Instructor Development Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | SEMAR | 7/26/2013 | 2013-07-26 | 8/8/2013 | 2013-08-08 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 6 | 40686 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 1258bed5-a3e8-4cca-a491-c8350607eede | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | IMET-1 - Fiscal Year 2013 Department of State Training | Instructor Development Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | Directorate of Telematics / PNP | 7/26/2013 | 2013-07-26 | 8/8/2013 | 2013-08-08 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 6881 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 7c8687d2-bb3f-42bf-9fbd-8c9bc3415efb | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Peru | PER | Section 1004 - Fiscal Year 2013 Department of Defense Training | Instructor Development Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | NAVY | 7/26/2013 | 2013-07-26 | 8/8/2013 | 2013-08-08 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 2 | 7946 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| c90a34c2-4da8-478c-b66c-06c67e310d8b | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Uruguay | URY | IMET-1 - Fiscal Year 2013 Department of State Training | Combat Life Saver Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | AIR BRIGADE III | 7/26/2013 | 2013-07-26 | 8/8/2013 | 2013-08-08 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 7131 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 734f5ba0-e8e1-44da-8db6-d029a90f82e4 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Uruguay | URY | IMET-1 - Fiscal Year 2013 Department of State Training | Combat Life Saver Course | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | INFANTRY BATALLION I | 7/26/2013 | 2013-07-26 | 8/8/2013 | 2013-08-08 | U S NAV SMALL CRAFT INSTR AND TECH TRNG SCH STENNIS SPACE CTR MS | 1 | 7631 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 4eefddf3-261d-4f2d-9327-be4204416b5c | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Cadet Leadership Development | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | ARMY MILITARY ACADEMY “ GRAL JOSE MARIA COLOMBIAN CORDOVA” | 7/9/2013 | 2013-07-09 | 8/8/2013 | 2013-08-08 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 62 | 87730 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| e87ba563-89c0-4941-b3c4-b5e1dda9b83e | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2013 Department of State Training | Aviation Basic Officer Leader-Branch | AVIATION SCHOOL | Beirut Air Base | 6/24/2013 | 2013-06-24 | 8/8/2013 | 2013-08-08 | AVIATION SCHOOL | 1 | 11728 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 3b851579-1abb-4f98-97ee-88913ba734a6 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2013 Department of State Training | Damage Controlman A | COGARD TRAINING CENTER YORKTOWN VA | Beirut Naval Base | 4/29/2013 | 2013-04-29 | 8/8/2013 | 2013-08-08 | COGARD TRAINING CENTER YORKTOWN VA | 1 | 11143 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 9d4b8598-f0af-4909-91a1-8b946925d5f8 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Bahamas | BHS | Section 1004 - Fiscal Year 2013 Department of Defense Training | Damage Controlman A | COGARD TRAINING CENTER YORKTOWN VA | RBDF | 4/29/2013 | 2013-04-29 | 8/8/2013 | 2013-08-08 | COGARD TRAINING CENTER YORKTOWN VA | 1 | 6893 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 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]);