training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
25 rows where "qa:training_date_first_seen" is on date -4707-05-30 and "training:end_date" is on date 2012-10-17 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 715b18a8-01f9-43f1-870b-5aefcd2c48d6 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2013 Department of State Training | Fuels Quality Control | QUARTERMASTER SCHOOL | MAINTENANCE DIRECTORATE | 10/17/2012 | 2012-10-17 | 10/17/2012 | 2012-10-17 | QUARTERMASTER SCHOOL | 1 | 242 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 78a45342-7758-44ba-811f-ec52478debaa | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Africa_fmtrpt.tsv | Rwanda | RWA | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | RWANDA DEFENSE FORCES/AIR FORCE DEPARTMENT | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 26234 | https://2009-2017.state.gov/documents/organization/230209.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 97bb4bbc-0aa6-4487-af52-a883d0bd47e7 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | Air Squadron 6, Wing 4, Atang Sendjaja AFB | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 26486 | https://2009-2017.state.gov/documents/organization/230211.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 64c12705-4e0f-47d7-8588-cf6246d86b7e | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | 17 ATTACK SQDN, 15 STRIKE WING, PHIL AIR FORCE | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 24134 | https://2009-2017.state.gov/documents/organization/230211.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 5497fab6-c346-412f-83aa-72459a46631f | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv | Thailand | THA | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | Royal Thair Air Force | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 20207 | https://2009-2017.state.gov/documents/organization/230211.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 75494629-2cf7-4960-b284-7e2421f1c1c3 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Europe_fmtrpt.tsv | Macedonia | MKD | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | Rotary Wing Squadron, Air Brigade, Joint Operations Command | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 24434 | https://2009-2017.state.gov/documents/organization/230213.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| c9f533f0-9fdd-4c38-817b-fb1cde1d2fd2 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Europe_fmtrpt.tsv | Ukraine | UKR | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | A1100 Naval Brigade | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 20082 | https://2009-2017.state.gov/documents/organization/230213.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| dc314e30-2ec7-46f8-a60c-7a541a1fb962 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Algeria | DZA | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | Algerian Air Force | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 25171 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 350a6132-8a25-4c25-a4ea-87e31d33eba4 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Bahrain | BHR | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | ROYAL BAHRAIN AIR FORCE | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 2 | 31160 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 36942211-11c1-49c7-a1f3-b445cfba6199 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Iraq | IRQ | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | MOD | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 20207 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| a63a0419-157d-4ed5-9b9e-9eca0fa7455b | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | Hamat Air Base | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 25684 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 5f8169c5-9268-434f-9731-e3391af0cfa8 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Morocco | MAR | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | BE/FRA | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 26088 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 697fa7bc-ec72-4ce8-aaf2-8be850ef672f | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Yemen | YEM | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | Yemen Air Force | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 26834 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 0e40d8d5-4237-4853-8fa1-7f3773e0b271 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | Air Combat Command No.1, Palanquero | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 15580 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 5901648e-c9d9-439e-81d7-e577f09642a4 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | Dominican Air Force | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 23151 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| a375ebb4-7005-4859-9ec6-9636f613ef94 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Panama | PAN | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | Air Operations / SENAN | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 21727 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| cf44d7a1-b44b-4ea3-a616-109023693dd3 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Trinidad and Tobago | TTO | IMET-1 - Fiscal Year 2013 Department of State Training | SOS International OFF School Course | MAXWELL AFB, AL | AIR GUARD | 9/4/2012 | 2012-09-04 | 10/17/2012 | 2012-10-17 | MAXWELL AFB, AL | 1 | 22534 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| e24ad1e3-b9fa-4987-ae4e-cb47d7761f42 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | IMET-1 - Fiscal Year 2013 Department of State Training | Field Medical Service Technician | CO MARINE CORPS COMBAT SERVICE SUPPORT SCH CAMP LEJEUNE NC | Air Combat Command No.5, Rionegro | 8/15/2012 | 2012-08-15 | 10/17/2012 | 2012-10-17 | CO MARINE CORPS COMBAT SERVICE SUPPORT SCH CAMP LEJEUNE NC | 1 | 6203 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 85b9d600-6035-44c2-86e4-4974122774c2 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv | Thailand | THA | FMF - Fiscal Year 2013 Department of State Training | ADA Basic Officer Leader-Branch | Air Defense Artillery School | Royal Thai Army | 8/13/2012 | 2012-08-13 | 10/17/2012 | 2012-10-17 | 441S | 1 | 12585 | https://2009-2017.state.gov/documents/organization/230211.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 4b0ac3fc-b51c-4ab6-bea2-55b550e5b885 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2013 Department of State Training | ADA Basic Officer Leader-Branch | Air Defense Artillery School | AIR DEFENCE DIRECTORATE | 8/13/2012 | 2012-08-13 | 10/17/2012 | 2012-10-17 | 441S | 1 | 16097 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| b0c9703a-86c5-4cc5-aac3-3e5c32056609 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2013 Department of State Training | ADA Basic Officer Leader-Branch | Air Defense Artillery School | DIRECTORATE OF AIR DEFENCE | 8/13/2012 | 2012-08-13 | 10/17/2012 | 2012-10-17 | 441S | 1 | 16097 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| a2c388ef-1a61-44dd-b791-865694f53108 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2013 Department of State Training | Information Systems Management | SIGNAL SCHOOL | COMMUNICATION COLLEGE | 8/7/2012 | 2012-08-07 | 10/17/2012 | 2012-10-17 | SIGNAL SCHOOL | 1 | 17548 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 6a11968d-64d3-4cc2-b9d0-24d81407eb5f | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Dominica | DMA | IMET-1 - Fiscal Year 2013 Department of State Training | Automotive Maintenance Technician Basic | CO MARINE CORPS COMBAT SERVICE SUPPORT SCH CAMP LEJEUNE NC | Dominica Special Services Unit | 7/27/2012 | 2012-07-27 | 10/17/2012 | 2012-10-17 | CO MARINE CORPS COMBAT SERVICE SUPPORT SCH CAMP LEJEUNE NC | 1 | 11847 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 1a85c736-02c6-4a7d-8a95-176afe9b1687 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | St Vincent and Grenadines | VCT | IMET-1 - Fiscal Year 2013 Department of State Training | Wheeled Vehicle Mechanic | U.S. ARMY TRAINING CENTER | St Vincent and the Grenadines Special Services Unit | 7/23/2012 | 2012-07-23 | 10/17/2012 | 2012-10-17 | U.S. ARMY TRAINING CENTER | 1 | 17532 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
| 5f587747-23a3-4f47-afb6-484b8dd4780c | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Guatemala | GTM | Service Academies - Fiscal Year 2013 Department of Defense Training | United States Air Force Academy | N/A | USAFA | 6/15/2012 | 2012-06-15 | 10/17/2012 | 2012-10-17 | USAFA Colorado Springs, CO | 1 | 26000 | 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]);