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 / transmisión_comunitaria.csv
Created August 1, 2021 23:12
Datos de mi reproducción (modificada) del análisis del informe de transmisión comunitaria en Puerto Rico
Datos hasta Muestras desde Muestras hasta Municipio Población (2019) Color Casos Tasa de casos (ITC1) Positividad (ITC2)
2021-07-31 2021-07-18 2021-07-24 Aguada 36694 Rojo 115 313.40273614214857 18.181818181818183
2021-07-31 2021-07-18 2021-07-24 Isabela 40423 Rojo 95 235.01471934294833 16.08832807570978
2021-07-31 2021-07-18 2021-07-24 Mayagüez 71530 Rojo 163 227.8764154900042 13.503184713375797
2021-07-31 2021-07-18 2021-07-24 Cabo Rojo 47515 Rojo 108 227.29664316531623 20.307692307692307
2021-07-31 2021-07-18 2021-07-24 Aguadilla 50265 Rojo 114 226.79797075499852 22.916666666666668
2021-07-31 2021-07-18 2021-07-24 Añasco 26161 Rojo 48 183.4792248002752 15.873015873015873
2021-07-31 2021-07-18 2021-07-24 Moca 34891 Rojo 56 160.49984236622626 10.545454545454545
2021-07-31 2021-07-18 2021-07-24 Hormigueros 15518 Rojo 22 141.77084675860291 7.6923076923076925
2021-07-31 2021-07-18 2021-07-24 San Germán 30227 Rojo 42 138.9486220928309 11.515151515151516
@sacundim
sacundim / spec.json
Last active July 22, 2021 00:42
Visualización Vega-Lite de CoVariants.org para Puerto Rico
{
"config": {
"axis": {"labelFontSize": 14, "titleFontSize": 14},
"header": {"labelFontSize": 14, "titleFontSize": 14},
"legend": {"labelFontSize": 14, "titleFontSize": 14},
"title": {"align": "center", "fontSize": 20, "offset": 15}
},
"data": {
"url": "https://raw.githubusercontent.com/hodcroftlab/covariants/master/cluster_tables/USAClusters_data.json",
"format": {
@sacundim
sacundim / bioportal_pediatricos.csv
Last active July 11, 2021 19:40
Pruebas, casos y decesos pediátricos por COVID-19 en Puerto Rico, según Bioportal
Datos hasta Fecha muestra o deceso Edades Pruebas (molecular + antígeno) Pruebas (acumuladas) Casos (molecular + antígeno) Casos (acumulados) Muertes Muertes (acumuladas)
2021-07-10 2020-03-02 10 to 14 1 1 0 0 0 0
2021-07-10 2020-03-02 5 to 9 2 2 0 0 0 0
2021-07-10 2020-03-03 0 to 4 3 3 0 0 0 0
2021-07-10 2020-03-03 15 to 19 1 1 0 0 0 0
2021-07-10 2020-03-04 0 to 4 2 5 0 0 0 0
2021-07-10 2020-03-04 5 to 9 1 3 0 0 0 0
2021-07-10 2020-03-04 15 to 19 1 2 0 0 0 0
2021-07-10 2020-03-04 10 to 14 4 5 0 0 0 0
2021-07-10 2020-03-05 5 to 9 1 4 0 0 0 0
@sacundim
sacundim / municipal_vaccinations.csv
Last active June 3, 2021 18:41
Vacunaciones por municipio en Puerto Rico, capturado de covid19datos.salud.gov.pr y de https://covid.cdc.gov/covid-data-tracker/#vaccinations-county-view
bulletin_date municipio popest2019 total_dosis1 total_dosis1_pct total_dosis2 total_dosis2_pct
2021-03-24 Adjuntas 17363 2898 0.16690664055750734 1682 0.0968726602545643
2021-03-24 Aguada 36694 5228 0.14247560909140458 2628 0.07161933831144056
2021-03-24 Aguadilla 50265 7967 0.15849995026360292 3590 0.07142146622898637
2021-03-24 Aguas Buenas 24814 3614 0.14564358829692917 1898 0.07648907874586927
2021-03-24 Aibonito 22108 5825 0.26347928351727884 3482 0.15749954767504976
2021-03-24 Arecibo 81966 13337 0.16271380816436085 6790 0.08283922602054511
2021-03-24 Arroyo 17238 2115 0.12269404803341455 1100 0.06381250725142128
2021-03-24 Añasco 26161 3509 0.13413095829670119 1740 0.06651121899009976
2021-03-24 Barceloneta 23727 3392 0.14295949761874657 1822 0.07679015467610739
@sacundim
sacundim / rezago_muertes.csv
Created January 22, 2021 19:56
Rezago de anuncio de muertes en Puerto Rico, promedios de 7 días
Fecha datos Rezago muertes (promedio 7 días) Desviación estándar
2021-01-20 8.18867924528302 11.814696003360957
2021-01-19 10.983050847457626 18.008935188526088
2021-01-18 13.016949152542374 19.906128453678875
2021-01-17 12.5 19.55698868567482
2021-01-16 11.297297297297296 18.15453910163228
2021-01-15 12.613636363636363 18.97751769030793
2021-01-14 16.11881188118812 21.348725066258883
2021-01-13 16.054347826086957 21.169791916598058
2021-01-12 17.617977528089888 22.070115855770567
@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
@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 / 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 / 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 / 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)"