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_scraped" is on date 2022-03-25 and "training:start_date" is on date 2020-03-01 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27eed6be-bd4f-4961-bec5-a8fbaddad053 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Africa_fmtrpt.tsv | Mozambique | MOZ | Exchange - Fiscal Year 2020 Department of Defense Training | FAEP - 10 Day Cultural Exchange | USMA - 0 | USMA | 3/1/2020 | 2020-03-01 | 4/1/2020 | 2020-04-01 | Mozambique Military Academy | 2 | 19400 | https://www.state.gov/wp-content/uploads/2022/03/10-Volume-I-Section-IV-Part-IV-I-Africa.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
04d369a4-06b8-47a9-b974-093612c93815 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Europe_fmtrpt.tsv | Ukraine | UKR | Exchange - Fiscal Year 2020 Department of Defense Training | FAEP - 10 Day Cultural Exchange | USMA - 0 | USMA | 3/1/2020 | 2020-03-01 | 4/1/2020 | 2020-04-01 | Ukraine Military Academy | 2 | 10800 | https://www.state.gov/wp-content/uploads/2022/03/12-Volume-I-Section-IV-Part-IV-III-Europe.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
f0eee618-18bf-471a-a205-fdc9529f6bf5 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2020 Department of State Training | COMM Training | Jordan (In Country Training) - 0 | JAF | 3/1/2020 | 2020-03-01 | 3/31/2020 | 2020-03-31 | Jordan (In Country Training) | 9 | 0 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
cf7a9eda-91ed-41cc-9de0-1fed53ca33c2 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2020 Department of State Training | COMM Training | Jordan (In Country Training) - 0 | MFA | 3/1/2020 | 2020-03-01 | 3/31/2020 | 2020-03-31 | Jordan (In Country Training) | 1 | 0 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
b4f6e12c-453d-4f4a-9808-4d9115e645ab | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Near_East_fmtrpt.tsv | Jordan | JOR | FMF - Fiscal Year 2020 Department of State Training | COMM Training | Jordan (In Country Training) - 0 | RJAF | 3/1/2020 | 2020-03-01 | 3/31/2020 | 2020-03-31 | Jordan (In Country Training) | 14 | 0 | https://www.state.gov/wp-content/uploads/2022/03/13-Volume-I-Section-IV-Part-IV-IV-Near-East.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
bb4a14f7-b796-490a-b59e-b7f6f44d7db5 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Argentina | ARG | Exchange - Fiscal Year 2020 Department of Defense Training | FAEP - 10 Day Cultural Exchange | USMA - 0 | USMA | 3/1/2020 | 2020-03-01 | 4/1/2020 | 2020-04-01 | Argentina Military Academy | 2 | 10800 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
33439d7b-ac9b-44ef-acac-eb451e73219a | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Brazil | BRA | Exchange - Fiscal Year 2020 Department of Defense Training | FAEP - 10 Day Cultural Exchange | USMA - 0 | USMA | 3/1/2020 | 2020-03-01 | 4/1/2020 | 2020-04-01 | Brazil Military Academy | 2 | 10800 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
32531104-800b-42e3-9768-13df3e088bf3 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Exchange - Fiscal Year 2020 Department of Defense Training | FAEP - 10 Day Cultural Exchange | USMA - 0 | USMA | 3/1/2020 | 2020-03-01 | 4/1/2020 | 2020-04-01 | Colombia Military Academy | 2 | 10800 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
386c7758-82da-437b-89d5-ad18ed7d6c13 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2020 Department of State Training | Fixed Wing | Colombia (In Country Training) - 0 | Air Combat Command No. 1, Puerto Salgar, Cundinamarca | 3/1/2020 | 2020-03-01 | 3/16/2020 | 2020-03-16 | Bogota, CO | 1 | 0 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
82e0e04f-828d-49a1-bd92-6370ca6fa008 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2020 Department of State Training | Fixed Wing | Colombia (In Country Training) - 0 | Air Combat Command No. 2, Apiay, Meta | 3/1/2020 | 2020-03-01 | 3/16/2020 | 2020-03-16 | Bogota, CO | 1 | 0 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
e0e029b6-553d-45d2-91af-8a19301d59db | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2020 Department of State Training | Fixed Wing | Colombia (In Country Training) - 0 | Air Force | 3/1/2020 | 2020-03-01 | 3/16/2020 | 2020-03-16 | Bogota, CO | 1 | 300 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
6af28b4b-d297-48e7-861e-7785604ef0c1 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2020 Department of State Training | Fixed Wing | Colombia (In Country Training) - 0 | Air Transportation Command, Bogota | 3/1/2020 | 2020-03-01 | 3/16/2020 | 2020-03-16 | Bogota, CO | 2 | 0 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
dec8cdcf-7bce-4289-abe6-b607fb13a8ef | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2020 Department of State Training | Fixed Wing | Colombia (In Country Training) - 0 | Colombian Air Force, Bogot? | 3/1/2020 | 2020-03-01 | 3/16/2020 | 2020-03-16 | Bogota, CO | 5 | 5000 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
566b26f2-5ea3-47dc-8039-11e75226a3ce | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | FMF - Fiscal Year 2020 Department of State Training | Fixed Wing | Colombia (In Country Training) - 0 | Combat Command No. 4, Melgar, Tolima | 3/1/2020 | 2020-03-01 | 3/16/2020 | 2020-03-16 | Bogota, CO | 1 | 0 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
c60e5604-c762-446d-b6ad-b81de49b744c | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Ecuador | ECU | Exchange - Fiscal Year 2020 Department of Defense Training | FAEP - 10 Day Cultural Exchange | USMA - 0 | USMA | 3/1/2020 | 2020-03-01 | 4/1/2020 | 2020-04-01 | Ecuador Military Academy | 2 | 10800 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
272a5a37-ee55-4491-bd44-06fa796a9796 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | El Salvador | SLV | Exchange - Fiscal Year 2020 Department of Defense Training | FAEP - 10 Day Cultural Exchange | USMA - 0 | USMA | 3/1/2020 | 2020-03-01 | 4/1/2020 | 2020-04-01 | El Salvador Military Academy | 2 | 10800 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
f6771a84-ca79-4d66-9f97-da79e7e52d74 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Exchange - Fiscal Year 2020 Department of Defense Training | FAEP - 10 Day Cultural Exchange | USMA - 0 | USMA | 3/1/2020 | 2020-03-01 | 4/1/2020 | 2020-04-01 | Mexico Military Academy | 2 | 10800 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
8fffbe10-0bf1-4c81-834a-31340a66c337 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Peru | PER | Exchange - Fiscal Year 2020 Department of Defense Training | FAEP - 10 Day Cultural Exchange | USMA - 0 | USMA | 3/1/2020 | 2020-03-01 | 4/1/2020 | 2020-04-01 | Peru Military Academy | 2 | 10800 | https://www.state.gov/wp-content/uploads/2022/03/15-Volume-I-Section-IV-Part-IV-VI-Western-Hemisphere.pdf | Not checked against source; verify accuracy before use | 2022-03-16 | 2022-03-25 |
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]);