training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
25 rows where "qa:training_date_first_seen" is on date 2022-03-16, "training:end_date" is on date 2020-03-13 and "training:start_date" is on date 2020-02-11 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
56e9e5db-76cb-49e6-8295-320409dc2b40 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | Air Combat Command No. 1, Puerto Salgar, Cundinamarca | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 17 | 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 |
2cbdae59-430b-4695-bf89-893c4f791696 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | Air Force | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | 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 |
32d42466-3aa4-4795-9cd2-a9f2d0894b48 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | Air Operations Command | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | 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 |
85e1d858-35a8-422d-9565-06a790f7f937 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | Air Transportation Command, Bogota | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 23 | 140000 | 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 |
16830dc6-8c66-46a7-ab4c-2f352f7aa253 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | ARC-DICOI | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 3 | 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 |
178e534b-a576-4e57-8c24-2574760a4ddc | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | ARC-DISAN | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | 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 |
2b7069c7-bcda-4cf4-bd13-9f957347c8d4 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | CGFM | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 3 | 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 |
cbf498b8-4896-4ed4-a974-bb49f1da0cf7 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | Colombian Air Force, Bogot? | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 11 | 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 |
9d91fc44-cd02-41e7-862d-a37062ecd918 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | Combat Command No. 3, Malambo, Atl?ntico | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 3 | 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 |
f879bf80-71a3-462f-bb13-8e861130ba3a | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | Combat Command No. 5, Rionegro, Antioquia | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | 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 |
b3dfdd99-a46d-4a5c-869f-9c8585cf50af | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | Combat Command No. 6, Solano, Caquet? | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | 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 |
1c64b478-6eb5-4117-a63e-0b738198dea6 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | East Air Group | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | 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 |
5608c552-8168-4f56-8c7c-07b1e313a927 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | EJC | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | 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 |
1901e98b-3fd0-4c7d-aa6b-35060a0d76d1 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | EJC-CEDOC | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 10 | 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 |
b6489912-f464-40f9-af08-66f6023ba506 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | Grupo A?reo del Casanare | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | 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 |
2309c7c3-6ebc-4ca9-8116-8aee00064ed7 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | Maintenance Air Command, Madrid, Cundinamarca | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | 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 |
c6f8b33a-e07c-4729-997c-b5f19d11dd88 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | 571st MSAS | Colombia (In Country Training) - 0 | Military Aviation School, Cali Academy | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | 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 |
b68d6bf7-34ae-4bbc-9563-76e085869818 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | C-130 Maintenance (Crew Chief Course) | SOUTHCOM - 571 MSAS - 84 | CATAM | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 4 | 4706 | 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 |
b5b6e5ec-29e0-4392-b293-c5697db8fbfb | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | C-130 Maintenance (Electrical Systems) | SOUTHCOM - 571 MSAS - 84 | CATAM | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 4 | 4712 | 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 |
90d960e6-7c9b-48c9-ac6d-bbf4a8dc4852 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | Fleet Management | SOUTHCOM - 571 MSAS - 231 | CATAM | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 11 | 12914 | 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 |
bcf731fa-338d-47d4-9aa1-a924dab48e02 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | Intelligence, Surveillance, Reconnaissance | SOUTHCOM - 571 MSAS - 441 | CATAM | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 21 | 24738 | 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 |
0a0245aa-a957-4c68-8199-3a42e59a085f | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | Medical Intelligence | SOUTHCOM - 571 MSAS - 357 | CATAM | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 17 | 20026 | 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 |
1b232f01-330e-484c-b852-36bf4c17425d | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | Modular Airborne Fire Fighting Systems | SOUTHCOM - 571 MSAS - 315 | CATAM | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 15 | 17670 | 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 |
89dcb714-bcc8-42d7-ac85-8a6a03007c03 | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | Search And Rescue | SOUTHCOM - 571 MSAS - 189 | CATAM | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 9 | 10602 | 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 |
d818ca4e-f108-45ee-a938-55b31b422f7f | 491fdf73-cf75-42bf-93e8-9aad65ed8762 | 2020_2021_Western_Hemisphere_fmtrpt.tsv | Colombia | COL | Section 333 - Fiscal Year 2020 Department of Defense Training | T-56 Engines | SOUTHCOM - 571 MSAS - 105 | CATAM | 2/11/2020 | 2020-02-11 | 3/13/2020 | 2020-03-13 | Bogota, CO | 5 | 5890 | 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]);