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 "qa:training_date_first_seen" is on date -4707-05-28 and "training:end_date" is on date 2010-10-13 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
a1b49f48-df04-41ba-9ade-759d172d037c | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Near_East_fmtrpt.tsv | Israel | ISR | FMF - Fiscal Year 2011 Department of State Training | WESTWIND/WILMINGTON DE | FLIGHT SAFETY INTERNATIONAL - NEW CASTLE, DE - N/A | IAF-AIR WING 28 | 10/11/2010 | 2010-10-11 | 10/13/2010 | 2010-10-13 | FLIGHT SAFETY INTERNATIONAL - NEW CASTLE, DE | 2 | https://2009-2017.state.gov/documents/organization/197613.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 | |
39aeb8cd-dbeb-4287-8305-9cada48e73b0 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | Antigua and Barbuda | ATG | IMET-1 - Fiscal Year 2011 Department of State Training | HORIZONTAL CONSTRUCTION ENGINEER | ENGINEER SCHOOL - N/A | Antigua and Barbuda Defence Force | 10/5/2010 | 2010-10-05 | 10/13/2010 | 2010-10-13 | ENGINEER SCHOOL | 1 | 4535 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
67d7d5c3-e4c7-47c2-a33a-8083dc2e603a | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | St Lucia | LCA | IMET-1 - Fiscal Year 2011 Department of State Training | OJT OPERATIONS TNG-CONUS | ARMOR SCHOOL - N/A | ST LUCIA POLICE | 9/30/2010 | 2010-09-30 | 10/13/2010 | 2010-10-13 | ARMOR SCHOOL | 1 | 1826 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
60a3a692-b1b3-48e0-b4f3-71b327ee9d6c | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | St Vincent and Grenadines | VCT | IMET-1 - Fiscal Year 2011 Department of State Training | OJT CONUS-USMC | MARINE CORPS ENGINEER SCHOOL CAMP LEJEUNE NC - N/A | ST VINCENT COAST GUARD | 9/28/2010 | 2010-09-28 | 10/13/2010 | 2010-10-13 | MARINE CORPS ENGINEER SCHOOL CAMP LEJEUNE NC | 1 | 1788 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
f1069969-a1bc-4cae-82a6-07e91d181fdf | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Western_Hemisphere_fmtrpt.tsv | St Vincent and Grenadines | VCT | IMET-1 - Fiscal Year 2011 Department of State Training | OJT TRAINING | MARINE CORPS ENGINEER SCHOOL CAMP LEJEUNE NC - N/A | ST VINCENT COAST GUARD | 9/28/2010 | 2010-09-28 | 10/13/2010 | 2010-10-13 | MARINE CORPS ENGINEER SCHOOL CAMP LEJEUNE NC | 1 | 1859 | https://2009-2017.state.gov/documents/organization/197615.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
08713198-0ba3-4a52-9a97-cb6e08dd6144 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Africa_fmtrpt.tsv | Burundi | BDI | IMET-1 - Fiscal Year 2011 Department of State Training | SERGEANTS COURSE (MLT III) | COMMANDING GENERAL, EDUCATION COMMAND QUANTICO VA - N/A | UGL | 8/25/2010 | 2010-08-25 | 10/13/2010 | 2010-10-13 | COMMANDING GENERAL, EDUCATION COMMAND QUANTICO VA | 1 | 5014 | https://2009-2017.state.gov/documents/organization/197610.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
123b0314-afb4-4aea-9cd4-ec98e085414d | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Africa_fmtrpt.tsv | Zambia | ZMB | IMET-1 - Fiscal Year 2011 Department of State Training | SERGEANTS COURSE (MLT III) | COMMANDING GENERAL, EDUCATION COMMAND QUANTICO VA - N/A | ZAMBIA AIR FORCE | 8/25/2010 | 2010-08-25 | 10/13/2010 | 2010-10-13 | COMMANDING GENERAL, EDUCATION COMMAND QUANTICO VA | 1 | 8820 | https://2009-2017.state.gov/documents/organization/197610.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
c73ccd70-dea3-4abe-bda9-4548e0c007ef | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_South_Central_Asia_fmtrpt.tsv | Maldives | MDV | IMET-1 - Fiscal Year 2011 Department of State Training | SERGEANTS COURSE (MLT III) | STAFF NON-COMMISSIONED OFFICERS ACADEMY - N/A | MARINE CORPS | 8/25/2010 | 2010-08-25 | 10/13/2010 | 2010-10-13 | STAFF NON-COMMISSIONED OFFICERS ACADEMY | 1 | 9384 | https://2009-2017.state.gov/documents/organization/197614.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
10ffacf6-579a-4b01-9f2f-a73b5feced98 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Africa_fmtrpt.tsv | Sudan, Republic of Southern | SSD | IMET-1 - Fiscal Year 2011 Department of State Training | FA BASIC OFFICER LEADER-BRANCH | FIELD ARTILLERY SCHOOL - N/A | SPLA GENERAL HEADQUARTERS | 6/1/2010 | 2010-06-01 | 10/13/2010 | 2010-10-13 | FIELD ARTILLERY SCHOOL | 2 | 33264 | https://2009-2017.state.gov/documents/organization/197610.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
e9de6f58-a8ea-4cb8-aad0-f35cd11975f2 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_East_Asia_And_Pacific_fmtrpt.tsv | Thailand | THA | IMET-1 - Fiscal Year 2011 Department of State Training | FA BASIC OFFICER LEADER-BRANCH | FIELD ARTILLERY SCHOOL - N/A | Target Acquisition Battery, Artillery Div., Ft. Phiboonsongkram, Lopburi 15160 | 6/1/2010 | 2010-06-01 | 10/13/2010 | 2010-10-13 | FIELD ARTILLERY SCHOOL | 1 | 21757 | https://2009-2017.state.gov/documents/organization/197611.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
a8413904-c2db-46ce-abee-de3021267c88 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Near_East_fmtrpt.tsv | Lebanon | LBN | FMF - Fiscal Year 2011 Department of State Training | FA BASIC OFFICER LEADER-BRANCH | FIELD ARTILLERY SCHOOL - N/A | Airport Security | 6/1/2010 | 2010-06-01 | 10/13/2010 | 2010-10-13 | FIELD ARTILLERY SCHOOL | 1 | 22090 | https://2009-2017.state.gov/documents/organization/197613.pdf | Not checked against source; verify accuracy before use | 2012 | 2019-07-16 |
492dc076-fcf3-47ef-8183-d87205951fc3 | 4bb42ad2-5ae2-4d21-b512-23eef531daaa | 2011_2012_Near_East_fmtrpt.tsv | Yemen | YEM | IMET-1 - Fiscal Year 2011 Department of State Training | FA BASIC OFFICER LEADER-BRANCH | FIELD ARTILLERY SCHOOL - N/A | DEPARTMENT OF THE INFANTRY | 6/1/2010 | 2010-06-01 | 10/13/2010 | 2010-10-13 | FIELD ARTILLERY SCHOOL | 1 | 16757 | https://2009-2017.state.gov/documents/organization/197613.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]);