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

58 rows where cases = 6645 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
2469411 2469411 2022-05-03 Vega Alta Puerto Rico 72143 6645  
2417909 2417909 2022-04-17 Louisa Virginia 51109 6645 82
2414653 2414653 2022-04-16 Louisa Virginia 51109 6645 82
2411397 2411397 2022-04-15 Louisa Virginia 51109 6645 82
2408267 2408267 2022-04-14 Mason West Virginia 54053 6645 92
2374413 2374413 2022-04-04 Grant New Mexico 35017 6645 84
2265392 2265392 2022-03-02 Johnson Arkansas 5071 6645 70
2259330 2259330 2022-02-28 Latah Idaho 16057 6645 48
2257930 2257930 2022-02-27 Edgefield South Carolina 45037 6645 66
2254679 2254679 2022-02-26 Edgefield South Carolina 45037 6645 66
2251428 2251428 2022-02-25 Edgefield South Carolina 45037 6645 66
2219723 2219723 2022-02-15 Park Wyoming 56029 6645 131
2210164 2210164 2022-02-13 Yell Arkansas 5149 6645 100
2175575 2175575 2022-02-02 Nobles Minnesota 27105 6645 56
2098251 2098251 2022-01-09 Perry Ohio 39127 6645 95
2086171 2086171 2022-01-05 Warren Virginia 51187 6645 108
2057723 2057723 2021-12-28 Christian Illinois 17021 6645 104
2012174 2012174 2021-12-14 Bonner Idaho 16017 6645 139
1929000 1929000 2021-11-18 Alexander North Carolina 37003 6645 118
1921640 1921640 2021-11-16 Greenup Kentucky 21089 6645 84
1876255 1876255 2021-11-02 Natchitoches Louisiana 22069 6645 135
1845866 1845866 2021-10-24 Chilton Alabama 1021 6645 162
1831083 1831083 2021-10-19 Pontotoc Mississippi 28115 6645 102
1808932 1808932 2021-10-12 Ashland Ohio 39005 6645 124
1788835 1788835 2021-10-06 Monroe Mississippi 28095 6645 173
1779676 1779676 2021-10-03 Stark North Dakota 38089 6645 53
1730739 1730739 2021-09-18 Cattaraugus New York 36009 6645 96
1664639 1664639 2021-08-29 Dearborn Indiana 18029 6645 85
1661391 1661391 2021-08-28 Dearborn Indiana 18029 6645 85
1658143 1658143 2021-08-27 Dearborn Indiana 18029 6645 85
1648104 1648104 2021-08-24 Coffee Georgia 13069 6645 187
1599217 1599217 2021-08-09 Eagle Colorado 8037 6645 23
1601203 1601203 2021-08-09 Linn Oregon 41043 6645 82
1573228 1573228 2021-08-01 Fremont Colorado 8043 6645 64
1569980 1569980 2021-07-31 Fremont Colorado 8043 6645 64
1566732 1566732 2021-07-30 Fremont Colorado 8043 6645 64
1437705 1437705 2021-06-20 Pulaski Kentucky 21199 6645 118
1434458 1434458 2021-06-19 Pulaski Kentucky 21199 6645 117
1431212 1431212 2021-06-18 Pulaski Kentucky 21199 6645 117
1308761 1308761 2021-05-11 Wilkes North Carolina 37193 6645 112
1290534 1290534 2021-05-06 Blount Alabama 1009 6645 136
1260125 1260125 2021-04-26 Ashtabula Ohio 39007 6645 167
1243012 1243012 2021-04-21 Androscoggin Maine 23001 6645 63
1132426 1132426 2021-03-18 Bullitt Kentucky 21029 6645 64
1062314 1062314 2021-02-24 Somerset Pennsylvania 42111 6645 187
1028991 1028991 2021-02-14 Lauderdale Mississippi 28075 6645 219
1025528 1025528 2021-02-13 Hampshire Massachusetts 25015 6645 247
1023129 1023129 2021-02-12 Erie Ohio 39043 6645 168
976946 976946 2021-01-29 Clay Minnesota 27027 6645 84
824375 824375 2020-12-13 Monroe Michigan 26115 6645 116
821129 821129 2020-12-12 Monroe Michigan 26115 6645 116
808322 808322 2020-12-08 Rankin Mississippi 28121 6645 117
760075 760075 2020-11-23 Alamance North Carolina 37001 6645 96
752262 752262 2020-11-21 Kootenai Idaho 16055 6645 70
513558 513558 2020-09-08 Burlington New Jersey 34005 6645 483
204688 204688 2020-06-03 Camden New Jersey 34007 6645 346
154849 154849 2020-05-18 Lake Illinois 17097 6645 215
125348 125348 2020-05-08 Orleans Louisiana 22071 6645 463

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