ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

33 rows where "date" is on date 2021-03-08 and state = "New Mexico" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: deaths

state 1

  • New Mexico · 33 ✖
Link rowid date ▲ county state fips cases deaths
1100759 1100759 2021-03-08 Bernalillo New Mexico 35001 53149 879
1100760 1100760 2021-03-08 Catron New Mexico 35003 83 5
1100761 1100761 2021-03-08 Chaves New Mexico 35005 8895 154
1100762 1100762 2021-03-08 Cibola New Mexico 35006 3414 106
1100763 1100763 2021-03-08 Colfax New Mexico 35007 861 47
1100764 1100764 2021-03-08 Curry New Mexico 35009 4952 68
1100765 1100765 2021-03-08 De Baca New Mexico 35011 132 0
1100766 1100766 2021-03-08 Doña Ana New Mexico 35013 23286 403
1100767 1100767 2021-03-08 Eddy New Mexico 35015 6532 117
1100768 1100768 2021-03-08 Grant New Mexico 35017 1520 35
1100769 1100769 2021-03-08 Guadalupe New Mexico 35019 615 9
1100770 1100770 2021-03-08 Harding New Mexico 35021 8 0
1100771 1100771 2021-03-08 Hidalgo New Mexico 35023 350 9
1100772 1100772 2021-03-08 Lea New Mexico 35025 8843 150
1100773 1100773 2021-03-08 Lincoln New Mexico 35027 1557 16
1100774 1100774 2021-03-08 Los Alamos New Mexico 35028 486 5
1100775 1100775 2021-03-08 Luna New Mexico 35029 3121 80
1100776 1100776 2021-03-08 McKinley New Mexico 35031 12073 450
1100777 1100777 2021-03-08 Mora New Mexico 35033 162 6
1100778 1100778 2021-03-08 Otero New Mexico 35035 4508 64
1100779 1100779 2021-03-08 Quay New Mexico 35037 421 8
1100780 1100780 2021-03-08 Rio Arriba New Mexico 35039 3426 70
1100781 1100781 2021-03-08 Roosevelt New Mexico 35041 1843 50
1100782 1100782 2021-03-08 San Juan New Mexico 35045 13581 450
1100783 1100783 2021-03-08 San Miguel New Mexico 35047 1246 13
1100784 1100784 2021-03-08 Sandoval New Mexico 35043 10988 209
1100785 1100785 2021-03-08 Santa Fe New Mexico 35049 9870 140
1100786 1100786 2021-03-08 Sierra New Mexico 35051 704 45
1100787 1100787 2021-03-08 Socorro New Mexico 35053 1228 56
1100788 1100788 2021-03-08 Taos New Mexico 35055 1562 49
1100789 1100789 2021-03-08 Torrance New Mexico 35057 705 12
1100790 1100790 2021-03-08 Union New Mexico 35059 404 9
1100791 1100791 2021-03-08 Valencia New Mexico 35061 6515 99

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);