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

61 rows where cases = 5222 sorted by date descending

✎ View and edit SQL

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

These facets timed out: county, fips

Link rowid date ▲ county state fips cases deaths
2461712 2461712 2022-05-01 Somerset Maryland 24039 5222 74
2463682 2463682 2022-05-01 Langlade Wisconsin 55067 5222 90
2458456 2458456 2022-04-30 Somerset Maryland 24039 5222 74
2460426 2460426 2022-04-30 Langlade Wisconsin 55067 5222 90
2455200 2455200 2022-04-29 Somerset Maryland 24039 5222 74
2457170 2457170 2022-04-29 Langlade Wisconsin 55067 5222 90
2428705 2428705 2022-04-21 Spencer Indiana 18147 5222 61
2431152 2431152 2022-04-21 Vilas Wisconsin 55125 5222 89
2425449 2425449 2022-04-20 Spencer Indiana 18147 5222 61
2401849 2401849 2022-04-12 Vilas Wisconsin 55125 5222 89
2291756 2291756 2022-03-10 Mitchell Georgia 13205 5222 112
2281630 2281630 2022-03-07 Clark Arkansas 5019 5222 76
2278692 2278692 2022-03-06 Dodge Georgia 13091 5222 146
2275439 2275439 2022-03-05 Dodge Georgia 13091 5222 146
2272186 2272186 2022-03-04 Dodge Georgia 13091 5222 146
2265681 2265681 2022-03-02 Dodge Georgia 13091 5222 145
2246849 2246849 2022-02-24 Spencer Kentucky 21215 5222 50
2243598 2243598 2022-02-23 Spencer Kentucky 21215 5222 50
2216531 2216531 2022-02-15 Monroe Alabama 1099 5222 71
2196754 2196754 2022-02-08 Scott Virginia 51169 5222 95
2182224 2182224 2022-02-04 Crawford Missouri 29055 5222 91
2157920 2157920 2022-01-27 Uinta Wyoming 56041 5222 34
2063275 2063275 2021-12-29 Franklin Vermont 50011 5222 56
2044166 2044166 2021-12-24 Pike Alabama 1109 5222 111
2019153 2019153 2021-12-16 Grayson Kentucky 21085 5222 100
1915113 1915113 2021-11-14 Calloway Kentucky 21035 5222 61
1911863 1911863 2021-11-13 Calloway Kentucky 21035 5222 61
1908614 1908614 2021-11-12 Calloway Kentucky 21035 5222 61
1877333 1877333 2021-11-02 Coos Oregon 41011 5222 96
1744508 1744508 2021-09-22 White Tennessee 47185 5222 85
1643240 1643240 2021-08-22 Williams North Dakota 38105 5222 41
1643582 1643582 2021-08-22 Toa Alta Puerto Rico 72135 5222  
1631429 1631429 2021-08-18 Sweetwater Wyoming 56037 5222 46
1601248 1601248 2021-08-09 Huntingdon Pennsylvania 42061 5222 136
1523800 1523800 2021-07-16 Nacogdoches Texas 48347 5222 174
1472762 1472762 2021-07-01 Habersham Georgia 13137 5222 164
1464145 1464145 2021-06-28 Pettis Missouri 29159 5222 77
1450045 1450045 2021-06-24 Habersham Georgia 13137 5222 164
1446800 1446800 2021-06-23 Habersham Georgia 13137 5222 164
1443555 1443555 2021-06-22 Habersham Georgia 13137 5222 164
1358693 1358693 2021-05-26 Fremont Wyoming 56013 5222 84
1339117 1339117 2021-05-20 Putnam West Virginia 54079 5222 93
1253172 1253172 2021-04-24 Taney Missouri 29213 5222 92
1177253 1177253 2021-04-01 Suwannee Florida 12121 5222 135
1177688 1177688 2021-04-01 Clinton Iowa 19045 5222 87
1172184 1172184 2021-03-30 Salem New Jersey 34033 5222 169
1154897 1154897 2021-03-25 Noble Indiana 18113 5222 82
1099578 1099578 2021-03-08 Grundy Illinois 17063 5222 67
1062545 1062545 2021-02-24 Dyer Tennessee 47045 5222 101
1056767 1056767 2021-02-23 Coffee Alabama 1031 5222 99
1029496 1029496 2021-02-14 Lee North Carolina 37105 5222 65
982833 982833 2021-01-31 Henry Indiana 18065 5222 68
926945 926945 2021-01-14 Colbert Alabama 1033 5222 70
924390 924390 2021-01-13 Boone Indiana 18011 5222 71
841513 841513 2020-12-18 Payne Oklahoma 40119 5222 24
774078 774078 2020-11-27 Alexandria city Virginia 51510 5222 77
659479 659479 2020-10-23 Onondaga New York 36067 5222 184
618029 618029 2020-10-10 Sumner Tennessee 47165 5222 105
610797 610797 2020-10-08 Dutchess New York 36027 5222 161
533599 533599 2020-09-14 Beaufort South Carolina 45013 5222 75
405408 405408 2020-08-06 Pulaski Arkansas 5119 5222 81

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