training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
20 rows where "qa:training_date_first_seen" is on date -4707-05-27, "training:end_date" is on date 2009-12-10 and "training:start_date" is on date 2009-11-29 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
68432722-5254-4188-9da2-f3fc5a2bf1a5 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_East_Asia_and_Pacific_fmtrpt.tsv | Cambodia | KHM | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | ARMY | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171510.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
abecaa9c-4c47-46f6-937c-f50ac5aa38bd | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_East_Asia_and_Pacific_fmtrpt.tsv | Indonesia | IDN | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | TNI PKO TRAINING CTR | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171510.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
379d3cc1-8303-49c2-b588-ec055b141bf4 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_East_Asia_and_Pacific_fmtrpt.tsv | Mongolia | MNG | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | ARMY MAINTEANCE | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171510.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
6346e158-0138-4279-927a-d55f9909d0af | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_East_Asia_and_Pacific_fmtrpt.tsv | Philippines | PHL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | ARMY FINANCE CTR | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171510.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
0dd9859a-26e1-4fc4-90a5-ddc1ac9e9eb7 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_East_Asia_and_Pacific_fmtrpt.tsv | Thailand | THA | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | PKO TRAINING CTR | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171510.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
d9d2fb32-097e-407d-8d9f-381724647a04 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | BPOTC COMMANDANT | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
f3c002d8-19d3-4f52-b79d-821c47a4bebe | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | STAFF OFFICER | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
68a2ad51-cab1-4d00-85a1-dfe3b9204735 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | NO. 3 RAJDAL BATTALION | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 2 | 8858 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
51598cf6-c68f-43ed-bfcf-471c18d384d1 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | INFANTRY COMPANY CO | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 2 | 8857 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
34d7101d-1a7a-431a-a810-50ca9dd32664 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | INFANTRY BRIGADE OFFICER | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
66680965-9f38-45df-bf00-f59c1fd6fecf | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | FAR WEST DIVISON HQ | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
062ecc49-c57c-4d1e-8d3c-7a769921bf80 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | ADJUTANT | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
705f143b-eb57-417e-8b7d-aa1e02593110 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | BPOTC INSTRUCTOR | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 3 | 13286 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
af71f99b-b02b-417e-a67b-fc70033c2d0b | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | BATTALION XO | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
146ac1bf-3e68-4961-b473-4ad403ecb6f5 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | BATTALION TRAINING O | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
10215153-4b55-4e95-8924-b16752b6301b | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | BATTALION OPS OFFICER | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 3 | 13286 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
0c0e3b89-5513-45c8-b652-726d17dfb7d0 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | BATTALION COMMANDER | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
74a1d53b-08fb-4d4f-ac29-2652f4444583 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | ARMY SIGNALS | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
8712502a-bbf9-449c-928f-b41539c52631 | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | ARMY ENGINEERS | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 3 | 13286 | https://2009-2017.state.gov/documents/organization/171513.pdf | Not checked against source; verify accuracy before use | 2011 | 2019-07-16 |
84582f18-af1e-4363-8ae6-71a94ec3ab1e | 4189374e-437e-49a6-a769-023b2b22de02 | 2010_2011_South_Central_Asia_fmtrpt.tsv | Nepal | NPL | GPOI - Fiscal Year 2010 Department of State Training | UN LOGISTICS OFFICER COURSE | US unit not specified in 2010-2011 report | BRIGADE OPERATIONS O | 11/29/2009 | 2009-11-29 | 12/10/2009 | 2009-12-10 | Birendra POTC, Panchkhal, Nepal | 1 | 4429 | 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]);