training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
19 rows where "qa:training_date_first_seen" is on date -4707-05-30 and "training:start_date" is on date 2013-04-02 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3d44b1da-72da-491f-8a56-9ce89716ca89 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Africa_fmtrpt.tsv | Ghana | GHA | PKO - Fiscal Year 2013 Department of State Training | PSO Soldier Skills Training - GPOI | N/A | UNIFIL-18 | 4/2/2013 | 2013-04-02 | 5/3/2013 | 2013-05-03 | Bundase, Ghana | 700 | 54718 | https://2009-2017.state.gov/documents/organization/230209.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
db9d6bcb-c8da-4f24-8847-b6c852dd0113 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Africa_fmtrpt.tsv | Liberia | LBR | IMET-1 - Fiscal Year 2013 Department of State Training | Engineer Basic Officer Leader-Branch | ENGINEER SCHOOL | ARMED FORCES OF LIBERIA | 4/2/2013 | 2013-04-02 | 8/16/2013 | 2013-08-16 | ENGINEER SCHOOL | 1 | 16972 | https://2009-2017.state.gov/documents/organization/230209.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
391d97ca-a746-45f7-bd38-c77496f0607b | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | IMET-1 - Fiscal Year 2013 Department of State Training | Engineer Basic Officer Leader-Branch | ENGINEER SCHOOL | Army /Engineering Corps | 4/2/2013 | 2013-04-02 | 8/16/2013 | 2013-08-16 | ENGINEER SCHOOL | 1 | 16892 | https://2009-2017.state.gov/documents/organization/230211.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
d288ccd1-d312-4c38-b367-d26c367de78c | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2013 Department of State Training | AV Safety OFF (ASO) | NAVAL SAFETY CENTER DETACHMENT PENSACOLA FL | PHRB / SPECIAL FORCES | 4/2/2013 | 2013-04-02 | 5/2/2013 | 2013-05-02 | CNATT NAVAL SCHOOL OF AVIATION SAFETY PENSACOLA FL | 1 | 12879 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
a5d7fc76-216d-4464-a14d-5c3bc51dbd62 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Jordan | JOR | IMET-1 - Fiscal Year 2013 Department of State Training | Spectrum Operations Apprentice | KEESLER AFB, MS | COMMUNICATION DIRECTORATE | 4/2/2013 | 2013-04-02 | 6/14/2013 | 2013-06-14 | KEESLER AFB, MS | 1 | 35886 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
c1680062-6560-4fea-9217-2c47f7043d7b | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2013 Department of State Training | Aviation Maintenance Officers | AVIATION SCHOOL | Rayak Air Base | 4/2/2013 | 2013-04-02 | 5/15/2013 | 2013-05-15 | AVIATION SCHOOL | 1 | 5981 | https://2009-2017.state.gov/documents/organization/230215.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
429ab693-b54c-464b-b464-51aac6e66227 | 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” | 4/2/2013 | 2013-04-02 | 5/2/2013 | 2013-05-02 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 64 | 90560 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
bb0f1672-8959-436b-b4ad-d270f37f0029 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Spanish Maintenance Manager | AVIATION SCHOOL | Air Combat Command No.5, Rionegro | 4/2/2013 | 2013-04-02 | 5/9/2013 | 2013-05-09 | AVIATION SCHOOL | 1 | 24386 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
22a6a5ac-f1c0-451e-b1d8-a0e6a93e0ed6 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Spanish Maintenance Manager | AVIATION SCHOOL | CARIBBEAN NAVAL AVIATION GROUP | 4/2/2013 | 2013-04-02 | 5/9/2013 | 2013-05-09 | AVIATION SCHOOL | 1 | 27352 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
2dec36c6-6bd7-4c2b-acbb-576257c8dd86 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Spanish Maintenance Manager | AVIATION SCHOOL | COLOMBIAN ARMY AVIATION DIVISION | 4/2/2013 | 2013-04-02 | 5/9/2013 | 2013-05-09 | AVIATION SCHOOL | 8 | 221035 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
34ce8794-50f7-4943-baa7-4616436b9fb2 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Spanish Maintenance Manager | AVIATION SCHOOL | NAVAL AVIATION PACIFIC GROUP | 4/2/2013 | 2013-04-02 | 5/9/2013 | 2013-05-09 | AVIATION SCHOOL | 1 | 27352 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
52762d14-0a90-47bf-b43e-e9ffacce449b | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | Spanish Maintenance Manager | AVIATION SCHOOL | NAVAL AVIATION SUPPORT GROUP | 4/2/2013 | 2013-04-02 | 5/9/2013 | 2013-05-09 | AVIATION SCHOOL | 1 | 30187 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
2a1ed2fc-4a92-47e8-a22c-26857e1332b8 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2013 Department of State Training | UH-60A/L Flight Simulator | EASTERN AVIATION TRAINING SITE | COLOMBIAN ARMY AVIATION DIVISION | 4/2/2013 | 2013-04-02 | 4/6/2013 | 2013-04-06 | EASTERN AVIATION TRAINING SITE | 6 | 28548 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
b88c9e11-791c-4dad-bb99-70ebd901a9c1 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | IMET-1 - Fiscal Year 2013 Department of State Training | Cadet Leadership Development | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | EJERCITO NACIONAL | 4/2/2013 | 2013-04-02 | 5/2/2013 | 2013-05-02 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 22 | 40590 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
ea707745-9758-48e5-9519-8c1ec61b668a | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Dominican Republic | DOM | IMET-1 - Fiscal Year 2013 Department of State Training | Cadet Leadership Development | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | EJERCITO NACIONAL DOMINICANO | 4/2/2013 | 2013-04-02 | 5/2/2013 | 2013-05-02 | WESTERN HEMIS INSTITUTE FOR SECURITY COOP | 14 | 25830 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
d542060a-9d3a-4dc7-a87c-0076264559e9 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Peru | PER | INL - Fiscal Year 2013 Department of State Training | Spanish Maintenance Manager | AVIATION SCHOOL | Peruvian National Air Police (DIRAVPOL) | 4/2/2013 | 2013-04-02 | 5/9/2013 | 2013-05-09 | AVIATION SCHOOL | 2 | 61618 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
39a63104-4546-4ee3-8fc7-70f5f7e6799e | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Peru | PER | Section 1004 - Fiscal Year 2013 Department of Defense Training | Spanish Maintenance Manager | AVIATION SCHOOL | AIR FORCE | 4/2/2013 | 2013-04-02 | 5/9/2013 | 2013-05-09 | AVIATION SCHOOL | 2 | 59310 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
fcbf7247-161f-4de3-9c43-f13c24d15256 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Peru | PER | Section 1004 - Fiscal Year 2013 Department of Defense Training | Spanish Maintenance Manager | AVIATION SCHOOL | ARMY | 4/2/2013 | 2013-04-02 | 5/9/2013 | 2013-05-09 | AVIATION SCHOOL | 2 | 55810 | https://2009-2017.state.gov/documents/organization/230219.pdf | Not checked against source; verify accuracy before use | 2014 | 2019-07-16 |
2828fd65-bea6-4de2-aa3f-28b6c4a336e3 | 5c5f3950-1925-417b-b333-fed3650d87ea | 2013_2014_Western_Hemisphere_fmtrpt.tsv | Peru | PER | Section 1004 - Fiscal Year 2013 Department of Defense Training | Spanish Maintenance Manager | AVIATION SCHOOL | NAVY | 4/2/2013 | 2013-04-02 | 5/9/2013 | 2013-05-09 | AVIATION SCHOOL | 1 | 29655 | 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]);