ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
213 rows where cases = 2404 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 20
- Georgia 17
- Ohio 13
- Puerto Rico 13
- Iowa 12
- Kentucky 11
- Illinois 10
- Minnesota 9
- Texas 9
- Michigan 7
- Vermont 7
- Idaho 6
- Missouri 6
- Arkansas 5
- Louisiana 5
- New York 5
- North Carolina 5
- South Dakota 5
- Indiana 4
- Kansas 4
- Maryland 4
- Tennessee 4
- Washington 4
- Colorado 3
- New Hampshire 3
- California 2
- Mississippi 2
- North Dakota 2
- Oklahoma 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445086 | 2445086 | 2022-04-26 | Sac | Iowa | 19161 | 2404 | 33 |
2441830 | 2441830 | 2022-04-25 | Sac | Iowa | 19161 | 2404 | 33 |
2438574 | 2438574 | 2022-04-24 | Sac | Iowa | 19161 | 2404 | 33 |
2440704 | 2440704 | 2022-04-24 | Madison | Virginia | 51113 | 2404 | 41 |
2435318 | 2435318 | 2022-04-23 | Sac | Iowa | 19161 | 2404 | 33 |
2437448 | 2437448 | 2022-04-23 | Madison | Virginia | 51113 | 2404 | 41 |
2432062 | 2432062 | 2022-04-22 | Sac | Iowa | 19161 | 2404 | 33 |
2434192 | 2434192 | 2022-04-22 | Madison | Virginia | 51113 | 2404 | 41 |
2428806 | 2428806 | 2022-04-21 | Sac | Iowa | 19161 | 2404 | 33 |
2425550 | 2425550 | 2022-04-20 | Sac | Iowa | 19161 | 2404 | 33 |
2313140 | 2313140 | 2022-03-16 | Florida | Puerto Rico | 72054 | 2404 | |
2291064 | 2291064 | 2022-03-09 | Sussex | Virginia | 51183 | 2404 | 39 |
2287812 | 2287812 | 2022-03-08 | Sussex | Virginia | 51183 | 2404 | 39 |
2196091 | 2196091 | 2022-02-08 | Luquillo | Puerto Rico | 72089 | 2404 | |
2191872 | 2191872 | 2022-02-07 | Yellow Medicine | Minnesota | 27173 | 2404 | 28 |
2192837 | 2192837 | 2022-02-07 | Luquillo | Puerto Rico | 72089 | 2404 | |
2186352 | 2186352 | 2022-02-05 | Santa Isabel | Puerto Rico | 72133 | 2404 | |
2179931 | 2179931 | 2022-02-03 | Dewey | South Dakota | 46041 | 2404 | 38 |
2175726 | 2175726 | 2022-02-02 | Douglas | Missouri | 29067 | 2404 | 69 |
2171650 | 2171650 | 2022-02-01 | Benton | Indiana | 18007 | 2404 | 21 |
2170624 | 2170624 | 2022-01-31 | Amelia | Virginia | 51007 | 2404 | 47 |
2163214 | 2163214 | 2022-01-29 | Mercer | North Dakota | 38057 | 2404 | 23 |
2163865 | 2163865 | 2022-01-29 | Dawson | Texas | 48115 | 2404 | 90 |
2132798 | 2132798 | 2022-01-20 | Brown | Kansas | 20013 | 2404 | 44 |
2129545 | 2129545 | 2022-01-19 | Brown | Kansas | 20013 | 2404 | 44 |
2127744 | 2127744 | 2022-01-18 | Comerio | Puerto Rico | 72045 | 2404 | |
2089770 | 2089770 | 2022-01-07 | Lee | Arkansas | 5077 | 2404 | 55 |
2059921 | 2059921 | 2021-12-28 | Pecos | Texas | 48371 | 2404 | 58 |
2053522 | 2053522 | 2021-12-26 | Addison | Vermont | 50001 | 2404 | 10 |
2050272 | 2050272 | 2021-12-25 | Addison | Vermont | 50001 | 2404 | 10 |
2047022 | 2047022 | 2021-12-24 | Addison | Vermont | 50001 | 2404 | 10 |
2043772 | 2043772 | 2021-12-23 | Addison | Vermont | 50001 | 2404 | 10 |
2038194 | 2038194 | 2021-12-22 | Gooding | Idaho | 16047 | 2404 | 43 |
2038941 | 2038941 | 2021-12-22 | Aitkin | Minnesota | 27001 | 2404 | 53 |
2024033 | 2024033 | 2021-12-17 | Comanche | Texas | 48093 | 2404 | 67 |
2011337 | 2011337 | 2021-12-13 | Grayson | Virginia | 51077 | 2404 | 54 |
1929479 | 1929479 | 2021-11-18 | Naranjito | Puerto Rico | 72105 | 2404 | |
1925347 | 1925347 | 2021-11-17 | Bates | Missouri | 29013 | 2404 | 43 |
1918693 | 1918693 | 2021-11-15 | Faribault | Minnesota | 27043 | 2404 | 31 |
1900889 | 1900889 | 2021-11-09 | Southampton | Virginia | 51175 | 2404 | 67 |
1897639 | 1897639 | 2021-11-08 | Southampton | Virginia | 51175 | 2404 | 67 |
1894389 | 1894389 | 2021-11-07 | Southampton | Virginia | 51175 | 2404 | 67 |
1891139 | 1891139 | 2021-11-06 | Southampton | Virginia | 51175 | 2404 | 67 |
1887889 | 1887889 | 2021-11-05 | Southampton | Virginia | 51175 | 2404 | 67 |
1884519 | 1884519 | 2021-11-04 | Windham | Vermont | 50025 | 2404 | 25 |
1880346 | 1880346 | 2021-11-03 | Warren | North Carolina | 37185 | 2404 | 31 |
1856666 | 1856666 | 2021-10-27 | Knott | Kentucky | 21119 | 2404 | 36 |
1853417 | 1853417 | 2021-10-26 | Knott | Kentucky | 21119 | 2404 | 36 |
1851620 | 1851620 | 2021-10-25 | Oglala Lakota | South Dakota | 46102 | 2404 | 53 |
1847248 | 1847248 | 2021-10-24 | Redwood | Minnesota | 27127 | 2404 | 43 |
1843998 | 1843998 | 2021-10-23 | Redwood | Minnesota | 27127 | 2404 | 43 |
1845004 | 1845004 | 2021-10-23 | San Lorenzo | Puerto Rico | 72129 | 2404 | |
1840748 | 1840748 | 2021-10-22 | Redwood | Minnesota | 27127 | 2404 | 43 |
1841754 | 1841754 | 2021-10-22 | San Lorenzo | Puerto Rico | 72129 | 2404 | |
1823516 | 1823516 | 2021-10-17 | Brooks | Georgia | 13027 | 2404 | 67 |
1820267 | 1820267 | 2021-10-16 | Brooks | Georgia | 13027 | 2404 | 67 |
1817018 | 1817018 | 2021-10-15 | Brooks | Georgia | 13027 | 2404 | 67 |
1810521 | 1810521 | 2021-10-13 | Brooks | Georgia | 13027 | 2404 | 66 |
1807272 | 1807272 | 2021-10-12 | Brooks | Georgia | 13027 | 2404 | 65 |
1804735 | 1804735 | 2021-10-11 | Webster | Kentucky | 21233 | 2404 | 34 |
1780008 | 1780008 | 2021-10-03 | Moca | Puerto Rico | 72099 | 2404 | |
1773904 | 1773904 | 2021-10-01 | Madison | Texas | 48313 | 2404 | 42 |
1770209 | 1770209 | 2021-09-30 | Aguada | Puerto Rico | 72003 | 2404 | |
1765136 | 1765136 | 2021-09-29 | Rabun | Georgia | 13241 | 2404 | 56 |
1765683 | 1765683 | 2021-09-29 | Jackson | Kentucky | 21109 | 2404 | 46 |
1766960 | 1766960 | 2021-09-29 | Aguada | Puerto Rico | 72003 | 2404 | |
1746491 | 1746491 | 2021-09-23 | Hubbard | Minnesota | 27057 | 2404 | 41 |
1743467 | 1743467 | 2021-09-22 | Pike | Missouri | 29163 | 2404 | 33 |
1737743 | 1737743 | 2021-09-20 | Corozal | Puerto Rico | 72047 | 2404 | |
1733923 | 1733923 | 2021-09-19 | Coos | New Hampshire | 33007 | 2404 | 46 |
1730673 | 1730673 | 2021-09-18 | Coos | New Hampshire | 33007 | 2404 | 46 |
1727423 | 1727423 | 2021-09-17 | Coos | New Hampshire | 33007 | 2404 | 46 |
1716496 | 1716496 | 2021-09-14 | Bond | Illinois | 17005 | 2404 | 29 |
1699319 | 1699319 | 2021-09-08 | Franklin | Vermont | 50011 | 2404 | 40 |
1696067 | 1696067 | 2021-09-07 | Bennington | Vermont | 50003 | 2404 | 16 |
1631301 | 1631301 | 2021-08-18 | Jackson | West Virginia | 54035 | 2404 | 63 |
1627976 | 1627976 | 2021-08-17 | Salem city | Virginia | 51775 | 2404 | 50 |
1620594 | 1620594 | 2021-08-15 | Wyandot | Ohio | 39175 | 2404 | 57 |
1621481 | 1621481 | 2021-08-15 | Russell | Virginia | 51167 | 2404 | 40 |
1618233 | 1618233 | 2021-08-14 | Russell | Virginia | 51167 | 2404 | 40 |
1612080 | 1612080 | 2021-08-13 | Drew | Arkansas | 5043 | 2404 | 49 |
1614985 | 1614985 | 2021-08-13 | Russell | Virginia | 51167 | 2404 | 40 |
1609945 | 1609945 | 2021-08-12 | Alpena | Michigan | 26007 | 2404 | 66 |
1606697 | 1606697 | 2021-08-11 | Alpena | Michigan | 26007 | 2404 | 66 |
1603410 | 1603410 | 2021-08-10 | Caroline | Maryland | 24011 | 2404 | 30 |
1600161 | 1600161 | 2021-08-09 | Caroline | Maryland | 24011 | 2404 | 30 |
1596391 | 1596391 | 2021-08-08 | Shelby | Illinois | 17173 | 2404 | 41 |
1593142 | 1593142 | 2021-08-07 | Shelby | Illinois | 17173 | 2404 | 41 |
1589893 | 1589893 | 2021-08-06 | Shelby | Illinois | 17173 | 2404 | 41 |
1576985 | 1576985 | 2021-08-02 | Spencer | Indiana | 18147 | 2404 | 31 |
1560091 | 1560091 | 2021-07-28 | Cleburne | Arkansas | 5023 | 2404 | 74 |
1540990 | 1540990 | 2021-07-22 | Pike | Georgia | 13231 | 2404 | 44 |
1538646 | 1538646 | 2021-07-21 | Waseca | Minnesota | 27161 | 2404 | 23 |
1535849 | 1535849 | 2021-07-20 | Delaware | New York | 36025 | 2404 | 39 |
1532601 | 1532601 | 2021-07-19 | Delaware | New York | 36025 | 2404 | 39 |
1518829 | 1518829 | 2021-07-15 | Marion | Kentucky | 21155 | 2404 | 38 |
1507858 | 1507858 | 2021-07-11 | Stevens | Washington | 53065 | 2404 | 32 |
1504612 | 1504612 | 2021-07-10 | Stevens | Washington | 53065 | 2404 | 32 |
1501366 | 1501366 | 2021-07-09 | Stevens | Washington | 53065 | 2404 | 32 |
1496051 | 1496051 | 2021-07-08 | Carter | Kentucky | 21043 | 2404 | 35 |
Advanced export
JSON shape: default, array, newline-delimited
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);