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

172 rows where cases = 3386 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
2486452 2486452 2022-05-08 Bayfield Wisconsin 55007 3386 40
2483194 2483194 2022-05-07 Bayfield Wisconsin 55007 3386 40
2479936 2479936 2022-05-06 Bayfield Wisconsin 55007 3386 40
2453135 2453135 2022-04-28 Villalba Puerto Rico 72149 3386  
2453417 2453417 2022-04-28 Duval Texas 48131 3386 70
2424353 2424353 2022-04-19 Alleghany Virginia 51005 3386 98
2396866 2396866 2022-04-11 Webster Mississippi 28155 3386 70
2393611 2393611 2022-04-10 Webster Mississippi 28155 3386 70
2390355 2390355 2022-04-09 Webster Mississippi 28155 3386 70
2387099 2387099 2022-04-08 Webster Mississippi 28155 3386 70
2383844 2383844 2022-04-07 Webster Mississippi 28155 3386 70
2380589 2380589 2022-04-06 Webster Mississippi 28155 3386 70
2377334 2377334 2022-04-05 Webster Mississippi 28155 3386 70
2378698 2378698 2022-04-05 Tyler Texas 48457 3386 86
2374081 2374081 2022-04-04 Webster Mississippi 28155 3386 70
2375444 2375444 2022-04-04 Tyler Texas 48457 3386 86
2372192 2372192 2022-04-03 Tyler Texas 48457 3386 86
2368939 2368939 2022-04-02 Tyler Texas 48457 3386 86
2365686 2365686 2022-04-01 Tyler Texas 48457 3386 86
2309922 2309922 2022-03-15 Salinas Puerto Rico 72123 3386  
2266478 2266478 2022-03-02 Dukes Massachusetts 25007 3386 0
2259976 2259976 2022-02-28 Dukes Massachusetts 25007 3386 0
2241661 2241661 2022-02-22 Bamberg South Carolina 45009 3386 71
2223387 2223387 2022-02-17 Brooks Georgia 13027 3386 80
2224381 2224381 2022-02-17 Sibley Minnesota 27143 3386 23
2193328 2193328 2022-02-07 Wilbarger Texas 48487 3386 79
2178482 2178482 2022-02-03 Estill Kentucky 21065 3386 40
2180382 2180382 2022-02-03 Appomattox Virginia 51011 3386 44
2177431 2177431 2022-02-02 Goshen Wyoming 56015 3386 53
2148046 2148046 2022-01-24 Monroe West Virginia 54063 3386 33
2138060 2138060 2022-01-21 Addison Vermont 50001 3386 11
2134674 2134674 2022-01-20 Madison Texas 48313 3386 49
2128016 2128016 2022-01-18 Andrews Texas 48003 3386 67
2075962 2075962 2022-01-02 Polk Tennessee 47139 3386 50
2072711 2072711 2022-01-01 Polk Tennessee 47139 3386 50
2069460 2069460 2021-12-31 Polk Tennessee 47139 3386 50
2066209 2066209 2021-12-30 Polk Tennessee 47139 3386 50
2063011 2063011 2021-12-29 Burleson Texas 48051 3386 61
2037666 2037666 2021-12-22 Pickens Alabama 1107 3386 91
2034918 2034918 2021-12-21 Kauai Hawaii 15007 3386 14
2021485 2021485 2021-12-17 Conway Arkansas 5029 3386 48
2024482 2024482 2021-12-17 Lincoln West Virginia 54043 3386 54
2008406 2008406 2021-12-13 Monroe Alabama 1099 3386 66
2005155 2005155 2021-12-12 Monroe Alabama 1099 3386 66
2005798 2005798 2021-12-12 Union Illinois 17181 3386 56
2002547 2002547 2021-12-11 Union Illinois 17181 3386 56
1999297 1999297 2021-12-10 Union Illinois 17181 3386 56
2000212 2000212 2021-12-10 Texas Missouri 29215 3386 65
1997927 1997927 2021-12-09 Humphreys Tennessee 47085 3386 50
1992866 1992866 2021-12-08 Orange Indiana 18117 3386 79
1994676 1994676 2021-12-08 Humphreys Tennessee 47085 3386 50
1988901 1988901 2021-12-07 Monroe Alabama 1099 3386 66
1975097 1975097 2021-12-02 Hughes South Dakota 46065 3386 49
1967738 1967738 2021-11-30 Hill Montana 30041 3386 71
1964486 1964486 2021-11-29 Hill Montana 30041 3386 71
1965112 1965112 2021-11-29 Union Oregon 41061 3386 54
1959702 1959702 2021-11-28 La Paz Arizona 4012 3386 102
1920343 1920343 2021-11-15 Louisa Virginia 51109 3386 51
1915540 1915540 2021-11-14 Jasper Mississippi 28061 3386 66
1917056 1917056 2021-11-14 Dinwiddie Virginia 51053 3386 57
1911015 1911015 2021-11-13 Randolph Arkansas 5121 3386 61
1912290 1912290 2021-11-13 Jasper Mississippi 28061 3386 66
1913806 1913806 2021-11-13 Dinwiddie Virginia 51053 3386 57
1909040 1909040 2021-11-12 Jasper Mississippi 28061 3386 66
1910556 1910556 2021-11-12 Dinwiddie Virginia 51053 3386 57
1906703 1906703 2021-11-11 Dorado Puerto Rico 72051 3386  
1894261 1894261 2021-11-07 Franklin Vermont 50011 3386 51
1881721 1881721 2021-11-04 Columbia Arkansas 5027 3386 74
1878472 1878472 2021-11-03 Columbia Arkansas 5027 3386 74
1858899 1858899 2021-10-28 Marengo Alabama 1091 3386 90
1858978 1858978 2021-10-28 Columbia Arkansas 5027 3386 73
1858650 1858650 2021-10-27 Staunton city Virginia 51790 3386 81
1826836 1826836 2021-10-18 Lamar Georgia 13171 3386 89
1791673 1791673 2021-10-07 Hart Kentucky 21099 3386 61
1786656 1786656 2021-10-05 Bledsoe Tennessee 47007 3386 14
1783616 1783616 2021-10-04 Hutchinson Texas 48233 3386 83
1780367 1780367 2021-10-03 Hutchinson Texas 48233 3386 83
1776475 1776475 2021-10-02 Holmes Ohio 39075 3386 112
1777117 1777117 2021-10-02 Hutchinson Texas 48233 3386 83
1769972 1769972 2021-09-30 Henry Ohio 39069 3386 69
1765419 1765419 2021-09-29 Washington Indiana 18175 3386 47
1764144 1764144 2021-09-28 Lampasas Texas 48281 3386 56
1764373 1764373 2021-09-28 Lee Virginia 51105 3386 52
1755282 1755282 2021-09-26 Berrien Georgia 13019 3386 57
1752034 1752034 2021-09-25 Berrien Georgia 13019 3386 57
1748785 1748785 2021-09-24 Berrien Georgia 13019 3386 57
1738897 1738897 2021-09-21 Delta Colorado 8029 3386 79
1735648 1735648 2021-09-20 Delta Colorado 8029 3386 79
1736913 1736913 2021-09-20 Crawford Missouri 29055 3386 49
1699176 1699176 2021-09-08 Limestone Texas 48293 3386 91
1671436 1671436 2021-08-31 Carter Kentucky 21043 3386 42
1669872 1669872 2021-08-30 Frio Texas 48163 3386 57
1664640 1664640 2021-08-29 Decatur Indiana 18031 3386 98
1666625 1666625 2021-08-29 Frio Texas 48163 3386 57
1661392 1661392 2021-08-28 Decatur Indiana 18031 3386 98
1663377 1663377 2021-08-28 Frio Texas 48163 3386 57
1658144 1658144 2021-08-27 Decatur Indiana 18031 3386 98
1660129 1660129 2021-08-27 Frio Texas 48163 3386 57
1619586 1619586 2021-08-15 Franklin Louisiana 22041 3386 110
1616338 1616338 2021-08-14 Franklin Louisiana 22041 3386 110

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