training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
18 rows where "qa:training_date_first_seen" is on date -4707-05-27 and "training:end_date" is on date 2010-05-25 sorted by training:id:admin
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1659c47c-f7f7-4d78-8776-aba5a6321272 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | Section 1004 - Fiscal Year 2010 Department of Defense Training | IERW OH-58A/C TRACK - ALL | US unit not specified in 2010-2011 report | MOI COUNTER NARCOTICS UNIT | 3/3/2010 | 2010-03-03 | 5/25/2010 | 2010-05-25 | AVIATION SCHOOL | 1 | 178933 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
1feba218-6365-4b8f-9b42-f9517535196b | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2010 Department of State Training | AIRCRAFT STRUCTURAL RPR-SP | US unit not specified in 2010-2011 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 2/17/2010 | 2010-02-17 | 5/25/2010 | 2010-05-25 | AVIATION LOGISTICS SCHOOL | 1 | 2478 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
26372a72-b187-41ff-bbd0-970c90a1f4f9 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Morocco | MAR | IMET-1 - Fiscal Year 2010 Department of State Training | INTL AIR WEAPONS DIR TRNG | US unit not specified in 2010-2011 report | 1 BASE - SALE | 3/29/2010 | 2010-03-29 | 5/25/2010 | 2010-05-25 | TYNDALL AFB, FL | 1 | 18967 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
2640ff72-e802-4a5a-909d-b9de25825d5c | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2010 Department of State Training | AIRCRAFT STRUCTURAL RPR-SP | US unit not specified in 2010-2011 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 2/17/2010 | 2010-02-17 | 5/25/2010 | 2010-05-25 | AVIATION LOGISTICS SCHOOL | 1 | 2478 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
2e9651ff-95fd-48b2-9acf-fccb2b7e527f | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2010 Department of State Training | AIRCRAFT STRUCTURAL RPR-SP | US unit not specified in 2010-2011 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 2/17/2010 | 2010-02-17 | 5/25/2010 | 2010-05-25 | AVIATION LOGISTICS SCHOOL | 1 | 2478 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
420b7cf1-71d2-4824-85d7-ead1cd15aef3 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2010 Department of State Training | AIRCRAFT STRUCTURAL RPR-SP | US unit not specified in 2010-2011 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 2/17/2010 | 2010-02-17 | 5/25/2010 | 2010-05-25 | AVIATION LOGISTICS SCHOOL | 1 | 2478 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
443baa2d-ac3a-4d46-92f2-5b1bb890bcf4 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Egypt | EGY | FMF - Fiscal Year 2010 Department of State Training | ADJUTANT GENERAL CAPTAINS CAREER | US unit not specified in 2010-2011 report | ARMOR DEPT. | 1/4/2010 | 2010-01-04 | 5/25/2010 | 2010-05-25 | ADJUTANT GENERAL SCHOOL | 1 | 29216 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
5238c019-b6ec-46c6-8209-10349dc4877d | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2010 Department of State Training | AIRCRAFT STRUCTURAL RPR-SP | US unit not specified in 2010-2011 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 2/17/2010 | 2010-02-17 | 5/25/2010 | 2010-05-25 | AVIATION LOGISTICS SCHOOL | 1 | 2478 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
58661782-91a5-4aa9-bc43-f9846e990107 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 1004 - Fiscal Year 2010 Department of Defense Training | INTL AIR WEAPONS DIR TRNG | US unit not specified in 2010-2011 report | AIR COMBAT COMMAND NO. 1 | 3/29/2010 | 2010-03-29 | 5/25/2010 | 2010-05-25 | TYNDALL AFB, FL | 1 | 19397 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
7bc0a3c6-27e2-46cb-8681-cfb6f0198fc0 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | INL - Fiscal Year 2010 Department of State Training | AIRCRAFT STRUCTURAL RPR-SP | US unit not specified in 2010-2011 report | COLOMBIAN NATIONAL POLICE, AIR SERVICE | 2/17/2010 | 2010-02-17 | 5/25/2010 | 2010-05-25 | AVIATION LOGISTICS SCHOOL | 1 | 2478 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
7c4a8cff-17a9-4396-9754-fbebe8d4c465 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 1004 - Fiscal Year 2010 Department of Defense Training | INTL AIR WEAPONS DIR TRNG | US unit not specified in 2010-2011 report | AIR COMBAT COMMAND NO. 2 | 3/29/2010 | 2010-03-29 | 5/25/2010 | 2010-05-25 | TYNDALL AFB, FL | 1 | 19397 | https://2009-2017.state.gov/documents/organization/171514.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
9d398bd8-2845-4346-b53d-d9d6c0d2cba3 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Africa_fmtrpt.tsv | Liberia | LBR | IMET-1 - Fiscal Year 2010 Department of State Training | WARRIOR LEADER (MOD) | US unit not specified in 2010-2011 report | ARMED FORCES OF LIBERIA | 5/5/2010 | 2010-05-05 | 5/25/2010 | 2010-05-25 | NCO ACADEMY - INFANTRY | 1 | 7508 | https://2009-2017.state.gov/documents/organization/171509.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
a2f51bfe-2d4c-49f7-838d-12383dddcc43 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_East_Asia_and_Pacific_fmtrpt.tsv | Malaysia | MYS | IMET-1 - Fiscal Year 2010 Department of State Training | INTL AIR WEAPONS DIR TRNG | US unit not specified in 2010-2011 report | AIR OPERATION, AIR FORCE HQ, KUALA LUMPUR | 3/29/2010 | 2010-03-29 | 5/25/2010 | 2010-05-25 | TYNDALL AFB, FL | 1 | 16626 | https://2009-2017.state.gov/documents/organization/171510.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
cbcddc73-4248-46a8-ae01-8c0b120e9146 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2010 Department of State Training | ADJUTANT GENERAL CAPTAINS CAREER | US unit not specified in 2010-2011 report | DIRECTORATE OF PERSONNEL AFFAIRS | 1/4/2010 | 2010-01-04 | 5/25/2010 | 2010-05-25 | ADJUTANT GENERAL SCHOOL | 1 | 32180 | https://2009-2017.state.gov/documents/organization/171512.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
eab78f99-902a-4c37-aed1-3aae6d38f7f2 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | Section 1004 - Fiscal Year 2010 Department of Defense Training | IERW OH-58A/C TRACK - ALL | US unit not specified in 2010-2011 report | MOI COUNTER NARCOTICS UNIT | 3/3/2010 | 2010-03-03 | 5/25/2010 | 2010-05-25 | AVIATION SCHOOL | 1 | 174011 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
f2d9f598-d467-42d6-b2bb-ec2a04b5307c | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_Africa_fmtrpt.tsv | Liberia | LBR | IMET-1 - Fiscal Year 2010 Department of State Training | WARRIOR LEADER (MOD) | US unit not specified in 2010-2011 report | 23RD INFANTRY BRIGADE | 5/5/2010 | 2010-05-05 | 5/25/2010 | 2010-05-25 | NCO ACADEMY - INFANTRY | 1 | 1758 | https://2009-2017.state.gov/documents/organization/171509.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
fc102a00-cff6-44e3-82ff-94ec80647b1e | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Afghanistan | AFG | Section 1004 - Fiscal Year 2010 Department of Defense Training | IERW OH-58A/C TRACK - ALL | US unit not specified in 2010-2011 report | MINISTRY OF INTERIOR | 3/3/2010 | 2010-03-03 | 5/25/2010 | 2010-05-25 | AVIATION SCHOOL | 1 | 180238 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
fedfa70c-142f-4dcc-b270-bbae3f38dbf0 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Pakistan | PAK | IMET-X - Fiscal Year 2010 Department of State Training | INTL AIR WEAPONS DIR TRNG | US unit not specified in 2010-2011 report | AIR DEFENSE, AIR HEADQUARTERS | 3/29/2010 | 2010-03-29 | 5/25/2010 | 2010-05-25 | TYNDALL AFB, FL | 1 | 17205 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 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]);