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

34 rows where "date" is on date 2022-03-05 and state = "New Mexico" sorted by date descending

✎ View and edit SQL

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

state 1

  • New Mexico · 34 ✖
Link rowid date ▲ county state fips cases deaths
2276819 2276819 2022-03-05 Bernalillo New Mexico 35001 145179 1656
2276820 2276820 2022-03-05 Catron New Mexico 35003 409 13
2276821 2276821 2022-03-05 Chaves New Mexico 35005 21648 297
2276822 2276822 2022-03-05 Cibola New Mexico 35006 7679 178
2276823 2276823 2022-03-05 Colfax New Mexico 35007 2667 65
2276824 2276824 2022-03-05 Curry New Mexico 35009 12492 177
2276825 2276825 2022-03-05 De Baca New Mexico 35011 568 5
2276826 2276826 2022-03-05 Doña Ana New Mexico 35013 62672 710
2276827 2276827 2022-03-05 Eddy New Mexico 35015 16950 261
2276828 2276828 2022-03-05 Grant New Mexico 35017 6548 77
2276829 2276829 2022-03-05 Guadalupe New Mexico 35019 1435 17
2276830 2276830 2022-03-05 Harding New Mexico 35021 78 4
2276831 2276831 2022-03-05 Hidalgo New Mexico 35023 1076 13
2276832 2276832 2022-03-05 Lea New Mexico 35025 20058 315
2276833 2276833 2022-03-05 Lincoln New Mexico 35027 5150 64
2276834 2276834 2022-03-05 Los Alamos New Mexico 35028 2671 13
2276835 2276835 2022-03-05 Luna New Mexico 35029 6667 117
2276836 2276836 2022-03-05 McKinley New Mexico 35031 25553 569
2276837 2276837 2022-03-05 Mora New Mexico 35033 752 16
2276838 2276838 2022-03-05 Otero New Mexico 35035 15371 179
2276839 2276839 2022-03-05 Quay New Mexico 35037 1973 49
2276840 2276840 2022-03-05 Rio Arriba New Mexico 35039 9660 123
2276841 2276841 2022-03-05 Roosevelt New Mexico 35041 4964 92
2276842 2276842 2022-03-05 San Juan New Mexico 35045 40313 723
2276843 2276843 2022-03-05 San Miguel New Mexico 35047 5703 50
2276844 2276844 2022-03-05 Sandoval New Mexico 35043 33049 384
2276845 2276845 2022-03-05 Santa Fe New Mexico 35049 28065 248
2276846 2276846 2022-03-05 Sierra New Mexico 35051 2013 70
2276847 2276847 2022-03-05 Socorro New Mexico 35053 3776 85
2276848 2276848 2022-03-05 Taos New Mexico 35055 5254 89
2276849 2276849 2022-03-05 Torrance New Mexico 35057 3079 51
2276850 2276850 2022-03-05 Union New Mexico 35059 997 14
2276851 2276851 2022-03-05 Unknown New Mexico   14 0
2276852 2276852 2022-03-05 Valencia New Mexico 35061 18828 250

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);