el-bid/idb-idb-invest-coronavirus-impact-dashboard

Follow the impact of COVID-19 outbreak in Latin America in real time

idb-idb-invest-coronavirus-impact-dashboard's Issues

Reimplement Sampling

Config file missing

missing athena.yaml is missing in the config folder

Congestion data for Brazil and Sao Paulo: dashboard chart not matching data in file.

This may be an issue with the IDB dashboard rather than with the actual data available in GitHub. Dashboard charts for Brazil and Sao Paulo metropolitan area do not seem to match numbers in the data file in GitHub (manually downloaded). They also do not seem to match the same graphs as they were available just a few days ago.

Add different aggregations

• Add Latin America
• Rest of the country
• Add weekday and weekend
• Do morning/afternoon/night
• Do day/night

[Region Request] Campina Grande and João Pessoa, Paraíba, Brasil

Request content

Regions spreadsheet link: https://docs.google.com/spreadsheets/d/1MD9GF9XnOBsvTJTw5-58KHlJcwJw3yTDxvv4PaDwduY/edit?usp=sharing

I need these regions because: I would like to study cause-effect relations with covid-19 cases in my region.

polygons in the new version of the dataset

Hi,
I noticed that in the new version of the dataset the variable that contained the polygons of each region_slug is missing. Would it be possible to add it again? This variable is really helpful when we try to merge the TCI dataset with others

Thanks

Data issues

Hi!, thank you for your work, i'm having troubles trying to reconstruct your data, i'm trying to build asimulation and i found your traffic congestion table very useful, i dont know if maybe you could let me de table or told me how to re construct it

[Brazilian municipalities] <municipalities with high numbers of confirmed cases not covered by the data set>

Request content

Regions spreadsheet link: https://docs.google.com/spreadsheets/d/1-C_K6LYD2Qv-TzK9UwnScmcnRKwKiAS2ZFN-7lwg-D4/edit?usp=sharing

I need these regions because:

I'm PhD student on public policy and government at Fundacao Getulio Vargas (Sao Paolo/Brazil) and I am currently working on analyzing the patterns of evolution of confirmed cases at the municipality level in Brazil and relating them to proxies of citizens circulation and economic activity shut down (traffic congestion, pollution satellite data, etc). The idea is to provide the public and policymakers some local evidence of how reducing circulation can help reduce COVID-19 spread. I intend to do this by uploading such an analysis on this website I am already working on.

The areas I am requesting are municipalities among the top 50 in Brazil when it comes to COVID-19 confirmed cases and are still not covered by the dataset. It would really improve the analysis increasing the cross-section dimension of the database.

ALSO, would it be possible to extend this data to days dating before the 8th of march? Ideally, to the 25th of February (day of the first confirmed case in Brazil) It would really help the analysis increasing the data panel time dimension.

Thanks in advance,
Michel Szklo

Change logging scheme to loguru

Add coefficient of variation measure

Basically, we need to run the coefficient of variation (std/mean) daily and weekly for all regions using 2019 data.

• Add append method for table with TCP for each day of the year in 2019
• Create table with coefficient of variation (daily and weekly)
• Merge table with final index table
• Add columns of 'approval' of city. i.e. CV < 0.5 (weekly and daily)
• Filter out cities not approved from public dataset
• Create weekly TCP index and its tables...

Reimplement RERUN

region_slug "natal" is receiving data from region_slug "fortaleza"

Hi,
I noticed that when importing data through R the columns population, ratio_20 and region_shapefile_wkt of the region_slug == 'natal' are receiving data from the region_slug == 'fortaleza'

Save data in sharepoint instead of google sheets

Run data tests between dev and prod

All Countries - Daily Data Access

Estimados:

¡Felicidades por el excelente trabajo y, sobre todo, por brindar acceso libre a estos datos!
Les escribo porque quisiera acceder a datos diarios de todas las regiones en todos los países. Intenté bajar los datos a través de Github en repetidas ocasiones, pero sin mayor éxito.

En el Banco Mundial venimos trabajando en evaluar el efecto de las políticas de distanciamiento social en los hábitos de movilidad de la población. La riqueza en los datos que ustedes han generado puede resultar muy valiosa para comparar patrones en las respuestas dentro de LAC y en comparación contras regiones. En todo momento, la fuente de los datos será citada.
Gracias dese ya por la gentil atención a este pedido. En caso de preguntas, pueden contactarme aquí: [email protected], [email protected].

Saludos cordiales,

Rodrigo

Request content

Regions spreadsheet link:

I need these regions because:

Reestructure env. to be independent of previous envs.

[Region Request] <add short description>

Hey!

To request new regions you have to generate a .csv with the format of this template.

You can just copy the spreadsheet, add your regions and share it back.

Also, let us know what are your plans with these regions! We might get you some extra help or connect you with similar projects.

We run the pipeline daily. So, after the regions are accepted, expect the output the next day at the same url with the region_slug that you set.

Request content

Regions spreadsheet link:

I need these regions because:

Requesting Data

Hi, my name is Raul and i work as data scientist, I'm from Venezuela, as you know we are suffering of gas shortage and that is forcing so many venezuelans to queue outside of gas stations waiting to refill , it there a way that you can share the data of this gatherings ???

Add year column to output table

We don't have a year variable. So far it was ok because it was all 2020 (or early 2021)... But now we're getting closer to have an overlap, so we need to add that variable.

Restructure backend to read from new prod table

Data needs update on github

Hi all,
I noticed that the data shown on IDB's dashboard goes up to Feb/2022. However, the data available through github stops in Dec/2020. See example below in R. Are you planning to update this downloadable dataset?

ps. Thank you for an amazing work!

library(data.table)

# download
cities <- fread("http://tiny.cc/idb-traffic-weekly", encoding = "UTF-8")

# check dates
unique(cities$last_updated_utc)
> "2020-12-13 13:50:21 UTC"

Workout better command structure to run grids and cities

Ibagué - Cartagena, Colombia <Es la capital del departamento de Tolima>

Hello,

Regions spreadsheet link: https://docs.google.com/spreadsheets/d/17RTSATFuHxI9cSxMZtKfRFnWJdQRrbgR/edit?usp=drive_web&ouid=102874325237891935495&rtpof=true

I want to know how transportation has behaved in these cities for the "COLOMBIAN CONGRESS OF TRANSIT AND TRANSPORTATION 2022"

Take out 2019 baseline

Baseline data and OSM length

Hi!

My name is Luis E. Olmos ([https://scholar.google.com/citations?user=deuYPEoAAAAJ&hl=es] , and I am conducting research analyzing multiple data sets on traffic congestion collected during the pandemic. In order to make some quantitative estimates, I would like to know if I can access the raw value of TCI used as baseline for each city (March 2020 (March 2–8, 2020)). And also the parameter of OSM length.

Thanks ins advance,

Luis

[São Paulo Metropolitan area] Traffic change within São Paulo metropolitan area

Regions spreadsheet link: https://docs.google.com/spreadsheets/d/1uaqthjNACWNdIiSm54AZnFI4n02yzhReWj2DnjtIX0M/edit#gid=0

I need these regions because:

I am part of the Observatório COVID-19 BR (https://covid19br.github.io/), more specifically on the group working with how flux in networks can influence the pandemic in different regions within Brazil. We have used transport networks (road networks and airport connections) to map vulnerability of different regions around the country. Our next goal with this dataset is to have enough resolution within the city of Sao Paulo (by municipalities and metropolitan areas) to map risk of hospitalization, by combining this data with number of confirmed cases and hospitalizations by municipality.

Best,
Paulinha

ST_Polygon not working

ERROR: pyathena.error.OperationalError: INVALID_FUNCTION_ARGUMENT: ST_Polygon only applies to POLYGON. Input type is: MULTI_POLYGON.

Weekly daily index fixes

In sql query:

• Add year
• Remove dow

Fix grid pipeline for new database

Add TCP to public dataset