training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
12 rows where "training:end_date" is on date 2011-05-23 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ff78de0d-5647-40a9-bf74-72b1c2fc39db | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2011 Department of State Training | OJT CH-47D/F HELICOPTER REPAIRER | AVIATION LOGISTICS SCHOOL - N/A | KOM OSHEIN AIR BASE | 4/28/2011 | 2011-04-28 | 5/23/2011 | 2011-05-23 | AVIATION LOGISTICS SCHOOL | 1 | 3230 | https://2009-2017.state.gov/documents/organization/197613.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
8940a587-3c8e-4f1f-9873-9ba0f67e1fe4 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2011 Department of State Training | SPANISH UH-60 MAINTENANCE TEST PILOT | AVIATION SCHOOL - N/A | COLOMBIAN ARMY AVIATION DIVISION | 4/26/2011 | 2011-04-26 | 5/23/2011 | 2011-05-23 | AVIATION SCHOOL | 3 | 154002 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
96b7cf00-c30e-44f8-bede-2a225b804aed | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | INL - Fiscal Year 2011 Department of State Training | SPANISH UH-60 AIRCRAFT MAINTENANCE TECHNICIAN | AVIATION SCHOOL - N/A | Secretaría de Seguridad Pública | 4/26/2011 | 2011-04-26 | 5/23/2011 | 2011-05-23 | AVIATION SCHOOL | 1 | 8554 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
9f385f4e-4a82-4405-8748-38386a9f41dc | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Section 1004 - Fiscal Year 2011 Department of Defense Training | SPANISH UH-60 MAINTENANCE TEST PILOT | AVIATION SCHOOL - N/A | SEDENA | 4/26/2011 | 2011-04-26 | 5/23/2011 | 2011-05-23 | AVIATION SCHOOL | 1 | 51334 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
1ed9b544-1de6-4600-9e03-9197467bef35 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_East_Asia_And_Pacific_fmtrpt.tsv | Philippines | PHL | IMET-1 - Fiscal Year 2011 Department of State Training | INFORMATION TECHNOLOGY SPECIALIST | SIGNAL SCHOOL - N/A | PUBLIC AFFAIRS OFFICE, AFP | 2/22/2011 | 2011-02-22 | 5/23/2011 | 2011-05-23 | SIGNAL SCHOOL | 1 | 16721 | https://2009-2017.state.gov/documents/organization/197611.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
82fe7223-b534-40df-9bc6-abf8348d00c5 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2011 Department of State Training | AIRCRAFT STRUC RPR (SPANISH) | AVIATION LOGISTICS SCHOOL - N/A | COLOMBIAN ARMY AVIATION DIVISION | 2/14/2011 | 2011-02-14 | 5/23/2011 | 2011-05-23 | AVIATION LOGISTICS SCHOOL | 2 | 28472 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
1c0829c2-a3df-4f74-8b39-9bd7fc8c35c5 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2011 Department of State Training | AIRCRAFT STRUC RPR (SPANISH) | AVIATION LOGISTICS SCHOOL - N/A | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 2/14/2011 | 2011-02-14 | 5/23/2011 | 2011-05-23 | AVIATION LOGISTICS SCHOOL | 2 | 9390 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
423f0ebf-fb1a-40dc-ade7-8e042511093a | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2011 Department of State Training | AIRCRAFT STRUCTURAL RPR-SP | AVIATION LOGISTICS SCHOOL - N/A | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 2/14/2011 | 2011-02-14 | 5/23/2011 | 2011-05-23 | AVIATION LOGISTICS SCHOOL | 3 | 14085 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
0c867d30-bf79-4c39-ad86-3d4cab7bcce2 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Peru | PER | INL - Fiscal Year 2011 Department of State Training | AIRCRAFT STRUCTURAL RPR-SP | AVIATION LOGISTICS SCHOOL - N/A | Peruvian National Air Police (DIRAVPOL) | 2/14/2011 | 2011-02-14 | 5/23/2011 | 2011-05-23 | AVIATION LOGISTICS SCHOOL | 1 | 14606 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
d5fc487c-b757-4048-9a5b-e1974e238721 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Europe_fmtrpt.tsv | Kosovo | XKX | IMET-1 - Fiscal Year 2011 Department of State Training | SIGNAL BASIC OFFICER LEADER-BRANCH | SIGNAL SCHOOL - N/A | Kosovo Security Force | 1/31/2011 | 2011-01-31 | 5/23/2011 | 2011-05-23 | SIGNAL SCHOOL | 1 | 18886 | https://2009-2017.state.gov/documents/organization/197612.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
cd2d5e5a-d6cb-4311-92dd-5e7f5ae18f9f | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Near_East_fmtrpt.tsv | Lebanon | LBN | IMET-1 - Fiscal Year 2011 Department of State Training | SIGNAL BASIC OFFICER LEADER-BRANCH | SIGNAL SCHOOL - N/A | 1st Intervention Regiment | 1/31/2011 | 2011-01-31 | 5/23/2011 | 2011-05-23 | SIGNAL SCHOOL | 1 | 19864 | https://2009-2017.state.gov/documents/organization/197613.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
77fe0fe5-6abe-43ec-9124-56b9291551ed | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Africa_fmtrpt.tsv | Senegal | SEN | IMET-1 - Fiscal Year 2011 Department of State Training | INFORMATION SYSTEMS MANAGEMENT | SIGNAL SCHOOL - N/A | Transmission BN | 1/3/2011 | 2011-01-03 | 5/23/2011 | 2011-05-23 | SIGNAL SCHOOL | 1 | 15848 | https://2009-2017.state.gov/documents/organization/197610.pdf | Not checked against source; verify accuracy before use | 2012 | 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]);