Data and Code

Data from experiments and published papers

These repositories include survey instruments and code to clean/analyze the data when feasible.

Pollution reports for schools in Bogota

As part of the Air Filters and Student Learning project funded by J-PAL’s King Climate Action Initiative (K-CAI) and the Weiss Fund, we installed air quality monitors in 150 schools in Bogota, Colombia. Below are reports of the pollution readings by locality

Pharmaceutical Prices in Colombia: Usable SISMED information

Below you can find the information on pharmaceutical prices in Colombia reported by the SISMED system. I took the information from public information published by the government in PDF and Excel

Pharmaceuticals in Colombia: INVIMA information

I merged this information with general drug characteristics from the INVIMA (from March 2017) dataset found here. The CUM1 and CUM2 in the SISMED information jointly form the complete CUM that uniquely identifies each pharmaceutical (and its commercial form). The CUM1 identifies a pharmaceutical sold by a company (e.g., ibuprofen can have several CUM1, one for each company that sells it). If a company sells a pharmaceutical in different commercial forms CUM2 identifies such forms. So, for example, say ibuprofen sold by company X has CUM1 0175486578, and it sells it in packages of 10, 50, and 100 tablets, then those three different commercial forms would have CUM2 1,2 and 3. In the INVIMA information, CUM1 is called “EXPEDIENTE” and CUM2 is called “CONSECUTIVO”.

The INVIMA also has information on whether the drug is generic and if it can be sold over the counter without a prescription. However, this information is not published in a ready-to-use format. I webscrapped the information from their webpage and compiled it (before it required a captcha).

Pharmaceuticals in the public health benefit plan of Colombia

Several pieces of legislation define the benefit plan. The relevant pieces of legislation are:

 

List of all medical providers (e.g., hospitals, clinics, private practices) with GPS coordinates

Below you can find the information on all medical providers in Colombia with GPS coordinates. I used Geolocation using Bing and Google Maps to get GPS coordinates. The information comes from public information published by the government in https://prestadores.minsalud.gov.co/habilitacion/ For completeness I’m also posting complementary data sets. I downloaded these data sets on April 27 2016. Therefore more up-to-date information may be available. “codigo_habilitacion” identifies providers, and “numero_sede” identifies the branches within each provider.