training-data
Data license: CC BY 4.0 · Data source: Security Force Monitor · About: Read our launch blog post to find out more
2 rows where training:country_iso_3166_1 = "MEX" and "training:start_date" is on date 2004-03-08 sorted by training:start_date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
609963de-ae74-457e-922d-8887509df790 | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, International Military Education and Training (IMET), FY04 | SPEC ENG LANG TRNG (SET) | Mil Air Base (BAM) #1, Santa Lucia, Estado de Mexico | 3/8/2004 | 2004-03-08 | 5/7/2004 | 2004-05-07 | LACKLAND AFB, TX 78236-5259 | 1 | 3868 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 2019-07-16 | |
962c7769-75ad-41b8-a197-4f2b0c4db052 | 055ffb82-b20c-412e-a126-5addf71aa3b0 | 2004_2005_Western_Hemisphere_fmtrpt.tsv | Mexico | MEX | Western Hemisphere Region, Mexico, Regional Defense Counterterrorism Fellowship Program, FY04 | MET CT-RESP TO TERRORISM | A-3 OPS. EMFA. BASE AERONAVAL DE MEXICO BATALLON DE INFANTERIA DE MARINA FUSILEROS PARACAIDISTAS C.G. BGDA. FLROS. PRCDTS. C.G. CPO. FZAS. ESPLS. C.G. CPO. POL. MIL. CENTRO DE ESTUDIOS SUPERIORES NAVALES CENTRO MEDICO NAVAL CTO. ADTO. FF. EE. CUARTA REGION NAVAL DN-3 DN-40 ESTADO MAYOR GENERAL FUERZA NAVAL DEL GOLFO FUERZA NAVAL DEL PACIFICO G.A.F.E. A.M. G.A.F.E. BGDA. FLROS. PRCDTS. G.A.F.E. I CPO. EJTO. INSPECCION Y CONTRALORIA GENERAL DE MARINA O.I.A. EMDN. PRIMERA REGION NAVAL QUINTA REGION NAVAL REGION NAVAL CENTRAL S-2 INTEL EMDN. S-3 OPS EMDN. S-5 P.E. EMDN. S-6 E. Y D.M. EMDN. S-7 O.C.N. EMDN. SEGUNDA ZONA NAVAL SEGUNDO REGION NAVAL SEXTA REGION NAVAL TERCERA REGION NAVAL | 3/8/2004 | 2004-03-08 | 3/12/2004 | 2004-03-12 | 50 | 87884 | https://2009-2017.state.gov/documents/organization/45793.pdf | Not checked against source; verify accuracy before use | 2005-04 | 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]);