Skip to content

Instantly share code, notes, and snippets.

View sacundim's full-sized avatar

sacundim

20 followers · 2 following
View GitHub Profile
@sacundim
sacundim / foia_150k_plus_PR.csv
Created July 7, 2020 03:08
Recipientes en Puerto Rico de préstamos de más de $150,000 del Paycheck Protection Program (Small Business Administration)
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 16 columns, instead of 1. in line 5.
"loanrange","businessname","address","city","state","zip","naicscode","businesstype","raceethnicity","gender","veteran","nonprofit","jobsretained","dateapproved","lender","cd"
a $5-10 million,CARIBBEAN RESTAURANTS LLC,"5 Carr Km 6 Hm 2 Barrio Amelia",GUAYNABO,PR,"00968","722513",Limited Liability Company(LLC),Unanswered,Unanswered,Unanswered,,500,"04/08/2020",Banco Popular de Puerto Rico,PR - 00
a $5-10 million,CARIBBEAN TEMPORARY SERVICES LLC,PONCE DE LEON 1431 SUITE 701,SANTURCE,PR,"00907","561320",Corporation,Hispanic,Female Owned,Unanswered,,500,"04/28/2020",Oriental Bank,PR - 00
a $5-10 million,CENTRO MEDICO DEL TURABO INC.,"100 AVE. LUIS MUNOZ MARIN",CAGUAS,PR,"00725","622110",Corporation,Unanswered,Unanswered,Unanswered,,500,"04/27/2020",Banco Popular de Puerto Rico,PR - 00
a $5-10 million,ENCANTO RESTAURANTS INC,"9615 AVE LOS ROMEROS 200 Montehiedra Office Centre",SAN JUAN,PR,"00926","722513",Corporation,Unanswered,Unanswered,Unanswered,,500,"04/08/2020",Banco Popular de Puerto Rico,PR - 00
a $5-10 m
@sacundim
sacundim / spec.json
Created July 11, 2020 07:23
Casos nuevos COVID-19 Puerto Rico, datos hasta el 11 de Julio del 2020
{
"config": {
"axis": {"labelFontSize": 14, "titleFontSize": 14},
"header": {"labelFontSize": 14, "titleFontSize": 14},
"legend": {"labelFontSize": 14, "titleFontSize": 14},
"title": {"align": "center", "fontSize": 20, "offset": 15},
"concat": {"spacing": 40},
"view": {"strokeWidth": 0}
},
"repeat": {
@sacundim
sacundim / spec.json
Last active July 11, 2020 07:35
Casos nuevos COVID-19 Puerto Rico, datos hasta el 11 de Julio del 2020
{
"config": {
"axis": {"labelFontSize": 14, "titleFontSize": 14},
"header": {"labelFontSize": 14, "titleFontSize": 14},
"legend": {"labelFontSize": 14, "titleFontSize": 14},
"title": {"align": "center", "fontSize": 20, "offset": 15},
"concat": {"spacing": 40},
"view": {"strokeWidth": 0}
},
"repeat": {
@sacundim
sacundim / spec.json
Last active September 8, 2020 04:31
Casos y hospitalizaciones COVID-19
{
"config": {
"axis": {"labelFontSize": 14, "titleFontSize": 14},
"header": {"labelFontSize": 14, "titleFontSize": 14},
"legend": {"labelFontSize": 14, "titleFontSize": 14},
"title": {"align": "center", "fontSize": 32, "offset": 15, "subtitleFontSize": 18}
},
"title": {
"text": "Casos nuevos, muertes y hospitalizaciones por COVID-19 en Puerto Rico",
"subtitle": "Fuentes: Departamento de Salud de Puerto Rico; CovidTracking.com"
@sacundim
sacundim / prpht-levels-cases.json
Last active September 20, 2020 04:43
Indicadores Propuestos Grupo PRPHT
{
"config": {
"axis": {"labelFontSize": 14, "titleFontSize": 14},
"header": {"labelFontSize": 14, "titleFontSize": 14},
"legend": {"labelFontSize": 14, "titleFontSize": 14},
"title": {"align": "center", "fontSize": 20, "offset": 15, "subtitleFontSize": 16}
},
"title": {
"text": "Casos confirmados de COVID-19 en Puerto Rico y umbrales propuestos por PRPHT",
"subtitle": "Datos: Departamento de Salud (hasta 18 de septiembre del 2020)"
@sacundim
sacundim / lateness_7day_2020-09-18.csv
Created September 19, 2020 22:10
Cálculo de rezago de casos en Puerto Rico, con desviación estándar
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 7 columns, instead of 1. in line 8.
"bulletin_date","confirmed_cases_additions","confirmed_cases_additions_stdev","probable_cases_additions","probable_cases_additions_stdev","deaths_additions","deaths_additions_stdev"
2020-09-18,6.83547103051747,8.28518645302639,10.418001104362231,16.0563711061978,3.7857142857142856,3.290214309749691
2020-09-17,6.51575456053068,9.02841779065785,7.35587431693989,13.89022117105862,3.8289473684210527,3.1680483694088584
2020-09-16,6.624133148404993,9.977585148014404,8.029816513761467,15.159897937351689,3.6710526315789473,3.1969893645787932
2020-09-15,6.445972495088409,9.58193880338032,8.068917018284107,14.882834629834234,3.342857142857143,3.2155235711676404
2020-09-14,6.252221462747778,8.32121411991202,6.525297619047619,8.2422916676876,3.420289855072464,2.6670604624168037
2020-09-13,6.221391174270756,8.556139927009891,6.670618120237087,8.715605945744715,3.8923076923076922,2.7797237102498955
2020-09-12,6.231314432989691,7.451559985023958,6.2477570738440305,8.111628678262015,3.838709677419355,2.795119873862512
2020-0
@sacundim
sacundim / spec.json
Created September 27, 2020 06:46
Ill-formed JSON produced by Altair (NaN at line 111)
{
"config": {
"axis": {
"labelFontSize": 14,
"titleFontSize": 14
},
"header": {
"labelFontSize": 14,
"titleFontSize": 14
},
@sacundim
sacundim / Covímetro 2020-09-27.csv
Last active September 28, 2020 16:49
Búsqueda de SQL (Postgres) para calcular el Covímetro a partir de mi base de datos de COVID-19 en Puerto Rico.
bulletin_date datum_date confirmed_cases sum_a sum_b covimetro
2020-09-27 2020-09-23 77 15616.000000000000
2020-09-27 2020-09-22 138 15672.000000000000 15584.857142857143 0.00559150824059984045
2020-09-27 2020-09-21 209 15657.857142857143 15522.285714285714 0.00873398615815052107
2020-09-27 2020-09-20 30 15798.285714285714 15598.857142857143 0.01278481940068866755
2020-09-27 2020-09-19 79 15902.857142857143 15616.285714285714 0.01835080593519588558
2020-09-27 2020-09-18 359 15921.285714285714 15597.285714285714 0.02077284509209477878
2020-09-27 2020-09-17 504 15889.285714285714 15528.142857142857 0.02325731160933603525
2020-09-27 2020-09-16 687 15849.142857142857 15487.285714285714 0.02336478770604459923
2020-09-27 2020-09-15 400 15551.285714285714 15179.571428571429 0.02448779845092553833
@sacundim
sacundim / bad-spec.json
Last active November 8, 2020 05:41
Vega-Lite stroke dash legend issue example
{
"$schema": "https://vega.github.io/schema/vega-lite/v4.8.1.json",
"data": {
"name": "data-a58954460ff4479c7f925351d53a938d"
},
"mark": {
"type": "line",
"point": "transparent",
"tooltip": true
},
@sacundim
sacundim / reported_hospital_capacity_admissions_facility-level_weekly_average_timeseries_20201207_Puerto_Rico.csv
Created December 9, 2020 00:48
Informe de Salud Federal sobre hospitales en Puerto Rico
We can't make this file beautiful and searchable because it's too large.
hospital_pk,collection_week,state,ccn,hospital_name,address,city,zip,hospital_subtype,fips_code,is_metro_micro,total_beds_7_day_avg,all_adult_hospital_beds_7_day_avg,all_adult_hospital_inpatient_beds_7_day_avg,inpatient_beds_used_7_day_avg,all_adult_hospital_inpatient_bed_occupied_7_day_avg,total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg,total_adult_patients_hospitalized_confirmed_covid_7_day_avg,total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg,total_pediatric_patients_hospitalized_confirmed_covid_7_day_avg,inpatient_beds_7_day_avg,total_icu_beds_7_day_avg,total_staffed_adult_icu_beds_7_day_avg,icu_beds_used_7_day_avg,staffed_adult_icu_bed_occupancy_7_day_avg,staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg,staffed_icu_adult_patients_confirmed_covid_7_day_avg,total_patients_hospitalized_confirmed_influenza_7_day_avg,icu_patients_confirmed_influenza_7_day_avg,total_patients_hospitalized_confirmed_influenza_and_covid_7_day_avg,total_beds_7