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

136 rows where cases = 3585 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
2416360 2416360 2022-04-17 Lawrence Mississippi 28077 3585 56
2413104 2413104 2022-04-16 Lawrence Mississippi 28077 3585 56
2409848 2409848 2022-04-15 Lawrence Mississippi 28077 3585 56
2406592 2406592 2022-04-14 Lawrence Mississippi 28077 3585 56
2403336 2403336 2022-04-13 Lawrence Mississippi 28077 3585 56
2400082 2400082 2022-04-12 Lawrence Mississippi 28077 3585 56
2263062 2263062 2022-03-01 Leslie Kentucky 21131 3585 39
2240274 2240274 2022-02-22 Fleming Kentucky 21069 3585 44
2167830 2167830 2022-01-31 Howard Arkansas 5061 3585 41
2167632 2167632 2022-01-30 Marquette Wisconsin 55077 3585 46
2164377 2164377 2022-01-29 Marquette Wisconsin 55077 3585 46
2161122 2161122 2022-01-28 Marquette Wisconsin 55077 3585 46
2155726 2155726 2022-01-27 Jackson Kentucky 21109 3585 61
2157549 2157549 2022-01-27 Young Texas 48503 3585 77
2132351 2132351 2022-01-20 Greene Georgia 13133 3585 74
2127023 2127023 2022-01-18 Hill Montana 30041 3585 71
2122756 2122756 2022-01-17 De Witt Illinois 17039 3585 40
2119504 2119504 2022-01-16 De Witt Illinois 17039 3585 40
2116252 2116252 2022-01-15 De Witt Illinois 17039 3585 40
2113001 2113001 2022-01-14 De Witt Illinois 17039 3585 40
2102406 2102406 2022-01-10 Radford city Virginia 51750 3585 39
2079991 2079991 2022-01-04 Conway Arkansas 5029 3585 49
2081365 2081365 2022-01-04 Andrew Missouri 29003 3585 42
2075858 2075858 2022-01-02 Hughes South Dakota 46065 3585 53
2072607 2072607 2022-01-01 Hughes South Dakota 46065 3585 53
2069356 2069356 2021-12-31 Hughes South Dakota 46065 3585 53
2066105 2066105 2021-12-30 Hughes South Dakota 46065 3585 53
2062222 2062222 2021-12-29 Essex New York 36031 3585 47
2053732 2053732 2021-12-26 Lewis West Virginia 54041 3585 64
2050482 2050482 2021-12-25 Lewis West Virginia 54041 3585 64
2047232 2047232 2021-12-24 Lewis West Virginia 54041 3585 64
2040965 2040965 2021-12-23 La Paz Arizona 4012 3585 105
2043982 2043982 2021-12-23 Lewis West Virginia 54041 3585 64
2020726 2020726 2021-12-16 Union Tennessee 47173 3585 52
2009465 2009465 2021-12-13 Simpson Kentucky 21213 3585 69
2007640 2007640 2021-12-12 Bledsoe Tennessee 47007 3585 26
2004389 2004389 2021-12-11 Bledsoe Tennessee 47007 3585 26
2001138 2001138 2021-12-10 Bledsoe Tennessee 47007 3585 26
1924306 1924306 2021-11-17 Hart Georgia 13147 3585 73
1854454 1854454 2021-10-26 Hocking Ohio 39073 3585 82
1844466 1844466 2021-10-23 Delaware New York 36025 3585 48
1830037 1830037 2021-10-19 Cook Georgia 13075 3585 58
1824806 1824806 2021-10-17 Dawson Nebraska 31047 3585 33
1821557 1821557 2021-10-16 Dawson Nebraska 31047 3585 33
1818308 1818308 2021-10-15 Dawson Nebraska 31047 3585 33
1792854 1792854 2021-10-07 Columbia Oregon 41009 3585 40
1793695 1793695 2021-10-07 Island Washington 53029 3585 43
1778087 1778087 2021-10-03 Harris Georgia 13145 3585 75
1774569 1774569 2021-10-02 Del Norte California 6015 3585 39
1774837 1774837 2021-10-02 Harris Georgia 13145 3585 75
1771319 1771319 2021-10-01 Del Norte California 6015 3585 39
1771587 1771587 2021-10-01 Harris Georgia 13145 3585 75
1768070 1768070 2021-09-30 Del Norte California 6015 3585 39
1766064 1766064 2021-09-29 Grenada Mississippi 28043 3585 106
1722204 1722204 2021-09-15 Clallam Washington 53009 3585 33
1713095 1713095 2021-09-13 Franklin Georgia 13119 3585 63
1676395 1676395 2021-09-01 Hockley Texas 48219 3585 116
1625474 1625474 2021-08-17 Unknown Georgia   3585 6
1609854 1609854 2021-08-12 Morehouse Louisiana 22067 3585 81
1600429 1600429 2021-08-09 Scott Mississippi 28123 3585 77
1584556 1584556 2021-08-04 Allegany New York 36003 3585 87
1555291 1555291 2021-07-26 Cibola New Mexico 35006 3585 128
1553038 1553038 2021-07-25 Polk Texas 48373 3585 121
1549791 1549791 2021-07-24 Polk Texas 48373 3585 121
1546544 1546544 2021-07-23 Polk Texas 48373 3585 121
1543594 1543594 2021-07-22 Fayette West Virginia 54019 3585 82
1463586 1463586 2021-06-28 Calloway Kentucky 21035 3585 49
1464469 1464469 2021-06-28 Wyoming New York 36121 3585 53
1461224 1461224 2021-06-27 Wyoming New York 36121 3585 53
1457979 1457979 2021-06-26 Wyoming New York 36121 3585 53
1454734 1454734 2021-06-25 Wyoming New York 36121 3585 53
1451489 1451489 2021-06-24 Wyoming New York 36121 3585 53
1448243 1448243 2021-06-23 Wyoming New York 36121 3585 53
1444023 1444023 2021-06-22 Geary Kansas 20061 3585 41
1444649 1444649 2021-06-22 Lawrence Missouri 29109 3585 87
1444998 1444998 2021-06-22 Wyoming New York 36121 3585 53
1440778 1440778 2021-06-21 Geary Kansas 20061 3585 41
1382623 1382623 2021-06-03 Oxford Maine 23017 3585 66
1328802 1328802 2021-05-17 Hardin Tennessee 47071 3585 68
1321646 1321646 2021-05-15 Warren New York 36113 3585 57
1294820 1294820 2021-05-07 Greenup Kentucky 21089 3585 59
1288509 1288509 2021-05-05 Worcester Maryland 24047 3585 98
1285647 1285647 2021-05-04 Webster Missouri 29225 3585 54
1278134 1278134 2021-05-02 Nez Perce Idaho 16069 3585 55
1274887 1274887 2021-05-01 Nez Perce Idaho 16069 3585 55
1271640 1271640 2021-04-30 Nez Perce Idaho 16069 3585 55
1240753 1240753 2021-04-20 Garvin Oklahoma 40049 3585 76
1237506 1237506 2021-04-19 Garvin Oklahoma 40049 3585 76
1234259 1234259 2021-04-18 Garvin Oklahoma 40049 3585 76
1231011 1231011 2021-04-17 Garvin Oklahoma 40049 3585 76
1227763 1227763 2021-04-16 Garvin Oklahoma 40049 3585 76
1224515 1224515 2021-04-15 Garvin Oklahoma 40049 3585 76
1221268 1221268 2021-04-14 Garvin Oklahoma 40049 3585 76
1222256 1222256 2021-04-14 Clark Wisconsin 55019 3585 62
1204240 1204240 2021-04-09 Polk Minnesota 27119 3585 66
1199572 1199572 2021-04-07 Trempealeau Wisconsin 55121 3585 41
1175496 1175496 2021-03-31 Montgomery New York 36057 3585 112
1155510 1155510 2021-03-25 McLeod Minnesota 27085 3585 54
1126061 1126061 2021-03-16 Iberville Louisiana 22047 3585 93
1116613 1116613 2021-03-13 Hancock Mississippi 28045 3585 79

Next page

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