ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
219 rows where cases = 2365 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 22
- Georgia 16
- Louisiana 14
- Virginia 14
- Tennessee 11
- Missouri 9
- Ohio 9
- Kentucky 8
- Puerto Rico 8
- Alabama 7
- Arkansas 7
- Idaho 6
- Illinois 6
- Indiana 6
- Minnesota 6
- Pennsylvania 6
- Texas 6
- Maryland 5
- Mississippi 5
- South Dakota 5
- West Virginia 5
- Wisconsin 5
- New York 4
- Wyoming 4
- North Carolina 3
- Florida 2
- Kansas 2
- Montana 2
- New Mexico 2
- Vermont 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500404 | 2500404 | 2022-05-13 | Emmet | Iowa | 19063 | 2365 | 52 |
2497146 | 2497146 | 2022-05-12 | Emmet | Iowa | 19063 | 2365 | 52 |
2493888 | 2493888 | 2022-05-11 | Emmet | Iowa | 19063 | 2365 | 52 |
2456370 | 2456370 | 2022-04-29 | Patillas | Puerto Rico | 72109 | 2365 | |
2440035 | 2440035 | 2022-04-24 | Adjuntas | Puerto Rico | 72001 | 2365 | |
2292877 | 2292877 | 2022-03-10 | Wayne | Missouri | 29223 | 2365 | 47 |
2258636 | 2258636 | 2022-02-27 | Ritchie | West Virginia | 54085 | 2365 | 30 |
2255385 | 2255385 | 2022-02-26 | Ritchie | West Virginia | 54085 | 2365 | 30 |
2252134 | 2252134 | 2022-02-25 | Ritchie | West Virginia | 54085 | 2365 | 30 |
2233224 | 2233224 | 2022-02-20 | McIntosh | Georgia | 13191 | 2365 | 35 |
2229973 | 2229973 | 2022-02-19 | McIntosh | Georgia | 13191 | 2365 | 35 |
2226722 | 2226722 | 2022-02-18 | McIntosh | Georgia | 13191 | 2365 | 35 |
2199937 | 2199937 | 2022-02-09 | Floyd | Virginia | 51063 | 2365 | 36 |
2174358 | 2174358 | 2022-02-02 | Perry | Arkansas | 5105 | 2365 | 27 |
2167371 | 2167371 | 2022-01-30 | Amelia | Virginia | 51007 | 2365 | 47 |
2164116 | 2164116 | 2022-01-29 | Amelia | Virginia | 51007 | 2365 | 47 |
2160861 | 2160861 | 2022-01-28 | Amelia | Virginia | 51007 | 2365 | 47 |
2150649 | 2150649 | 2022-01-25 | Dewey | South Dakota | 46041 | 2365 | 36 |
2151199 | 2151199 | 2022-01-25 | Richmond | Virginia | 51159 | 2365 | 17 |
2075953 | 2075953 | 2022-01-02 | Meigs | Tennessee | 47121 | 2365 | 46 |
2072702 | 2072702 | 2022-01-01 | Meigs | Tennessee | 47121 | 2365 | 46 |
2069451 | 2069451 | 2021-12-31 | Meigs | Tennessee | 47121 | 2365 | 46 |
2065576 | 2065576 | 2021-12-30 | Mitchell | North Carolina | 37121 | 2365 | 24 |
2066200 | 2066200 | 2021-12-30 | Meigs | Tennessee | 47121 | 2365 | 46 |
2062251 | 2062251 | 2021-12-29 | Schuyler | New York | 36097 | 2365 | 22 |
2055957 | 2055957 | 2021-12-27 | Harrison | Ohio | 39067 | 2365 | 58 |
2053843 | 2053843 | 2021-12-26 | Converse | Wyoming | 56009 | 2365 | 48 |
2050593 | 2050593 | 2021-12-25 | Converse | Wyoming | 56009 | 2365 | 48 |
2047343 | 2047343 | 2021-12-24 | Converse | Wyoming | 56009 | 2365 | 48 |
2044093 | 2044093 | 2021-12-23 | Converse | Wyoming | 56009 | 2365 | 48 |
2009424 | 2009424 | 2021-12-13 | Leslie | Kentucky | 21131 | 2365 | 34 |
2005508 | 2005508 | 2021-12-12 | Bleckley | Georgia | 13023 | 2365 | 85 |
2002257 | 2002257 | 2021-12-11 | Bleckley | Georgia | 13023 | 2365 | 85 |
1999007 | 1999007 | 2021-12-10 | Bleckley | Georgia | 13023 | 2365 | 85 |
1986264 | 1986264 | 2021-12-06 | Massac | Illinois | 17127 | 2365 | 57 |
1951470 | 1951470 | 2021-11-25 | Custer | Montana | 30017 | 2365 | 38 |
1948219 | 1948219 | 2021-11-24 | Custer | Montana | 30017 | 2365 | 38 |
1936706 | 1936706 | 2021-11-20 | Grant | West Virginia | 54023 | 2365 | 36 |
1898863 | 1898863 | 2021-11-09 | Butler | Kentucky | 21031 | 2365 | 39 |
1895613 | 1895613 | 2021-11-08 | Butler | Kentucky | 21031 | 2365 | 39 |
1886406 | 1886406 | 2021-11-05 | Madison | Missouri | 29123 | 2365 | 27 |
1875992 | 1875992 | 2021-11-02 | Winneshiek | Iowa | 19191 | 2365 | 39 |
1872743 | 1872743 | 2021-11-01 | Winneshiek | Iowa | 19191 | 2365 | 39 |
1869494 | 1869494 | 2021-10-31 | Winneshiek | Iowa | 19191 | 2365 | 39 |
1871523 | 1871523 | 2021-10-31 | Windham | Vermont | 50025 | 2365 | 25 |
1866245 | 1866245 | 2021-10-30 | Winneshiek | Iowa | 19191 | 2365 | 39 |
1862996 | 1862996 | 2021-10-29 | Winneshiek | Iowa | 19191 | 2365 | 39 |
1859747 | 1859747 | 2021-10-28 | Winneshiek | Iowa | 19191 | 2365 | 39 |
1856498 | 1856498 | 2021-10-27 | Winneshiek | Iowa | 19191 | 2365 | 39 |
1826619 | 1826619 | 2021-10-18 | Crowley | Colorado | 8025 | 2365 | 22 |
1815878 | 1815878 | 2021-10-14 | Oglala Lakota | South Dakota | 46102 | 2365 | 52 |
1800509 | 1800509 | 2021-10-10 | Howard | Arkansas | 5061 | 2365 | 35 |
1792665 | 1792665 | 2021-10-07 | Richland | North Dakota | 38077 | 2365 | 19 |
1776490 | 1776490 | 2021-10-02 | Meigs | Ohio | 39105 | 2365 | 44 |
1773768 | 1773768 | 2021-10-01 | Bosque | Texas | 48035 | 2365 | 52 |
1757835 | 1757835 | 2021-09-26 | Colonial Heights city | Virginia | 51570 | 2365 | 64 |
1754587 | 1754587 | 2021-09-25 | Colonial Heights city | Virginia | 51570 | 2365 | 64 |
1751339 | 1751339 | 2021-09-24 | Colonial Heights city | Virginia | 51570 | 2365 | 64 |
1739217 | 1739217 | 2021-09-21 | Gem | Idaho | 16045 | 2365 | 50 |
1736429 | 1736429 | 2021-09-20 | Garrard | Kentucky | 21079 | 2365 | 40 |
1734468 | 1734468 | 2021-09-19 | Wyoming | Pennsylvania | 42131 | 2365 | 55 |
1718225 | 1718225 | 2021-09-14 | Aguada | Puerto Rico | 72003 | 2365 | |
1714977 | 1714977 | 2021-09-13 | Aguada | Puerto Rico | 72003 | 2365 | |
1715175 | 1715175 | 2021-09-13 | Benton | Tennessee | 47005 | 2365 | 44 |
1698703 | 1698703 | 2021-09-08 | Juniata | Pennsylvania | 42067 | 2365 | 92 |
1694002 | 1694002 | 2021-09-07 | Jackson | Iowa | 19097 | 2365 | 43 |
1694771 | 1694771 | 2021-09-07 | Wright | Missouri | 29229 | 2365 | 43 |
1694986 | 1694986 | 2021-09-07 | Lincoln | New Mexico | 35027 | 2365 | 22 |
1690753 | 1690753 | 2021-09-06 | Jackson | Iowa | 19097 | 2365 | 43 |
1691522 | 1691522 | 2021-09-06 | Wright | Missouri | 29229 | 2365 | 43 |
1687503 | 1687503 | 2021-09-05 | Jackson | Iowa | 19097 | 2365 | 43 |
1684253 | 1684253 | 2021-09-04 | Jackson | Iowa | 19097 | 2365 | 43 |
1681002 | 1681002 | 2021-09-03 | Jackson | Iowa | 19097 | 2365 | 43 |
1677754 | 1677754 | 2021-09-02 | Jackson | Iowa | 19097 | 2365 | 43 |
1674507 | 1674507 | 2021-09-01 | Jackson | Iowa | 19097 | 2365 | 43 |
1667842 | 1667842 | 2021-08-30 | Pike | Illinois | 17149 | 2365 | 57 |
1622799 | 1622799 | 2021-08-16 | Simpson | Kentucky | 21213 | 2365 | 44 |
1610269 | 1610269 | 2021-08-12 | New Madrid | Missouri | 29143 | 2365 | 48 |
1581608 | 1581608 | 2021-08-03 | Wyandot | Ohio | 39175 | 2365 | 57 |
1576703 | 1576703 | 2021-08-02 | Morgan | Georgia | 13211 | 2365 | 31 |
1573495 | 1573495 | 2021-08-01 | Union | Georgia | 13291 | 2365 | 84 |
1570247 | 1570247 | 2021-07-31 | Union | Georgia | 13291 | 2365 | 84 |
1566999 | 1566999 | 2021-07-30 | Union | Georgia | 13291 | 2365 | 84 |
1564711 | 1564711 | 2021-07-29 | Winston | Mississippi | 28159 | 2365 | 84 |
1557929 | 1557929 | 2021-07-27 | Caroline | Maryland | 24011 | 2365 | 30 |
1553482 | 1553482 | 2021-07-26 | Butler | Alabama | 1013 | 2365 | 72 |
1554682 | 1554682 | 2021-07-26 | Caroline | Maryland | 24011 | 2365 | 30 |
1551370 | 1551370 | 2021-07-25 | Grant | Louisiana | 22043 | 2365 | 58 |
1551435 | 1551435 | 2021-07-25 | Caroline | Maryland | 24011 | 2365 | 30 |
1548123 | 1548123 | 2021-07-24 | Grant | Louisiana | 22043 | 2365 | 58 |
1544876 | 1544876 | 2021-07-23 | Grant | Louisiana | 22043 | 2365 | 58 |
1534382 | 1534382 | 2021-07-20 | Appling | Georgia | 13001 | 2365 | 72 |
1528087 | 1528087 | 2021-07-18 | Minidoka | Idaho | 16067 | 2365 | 33 |
1524840 | 1524840 | 2021-07-17 | Minidoka | Idaho | 16067 | 2365 | 33 |
1521592 | 1521592 | 2021-07-16 | Minidoka | Idaho | 16067 | 2365 | 33 |
1515198 | 1515198 | 2021-07-14 | Union | Illinois | 17181 | 2365 | 45 |
1511019 | 1511019 | 2021-07-12 | Mecklenburg | Virginia | 51117 | 2365 | 68 |
1504771 | 1504771 | 2021-07-11 | Barbour | Alabama | 1005 | 2365 | 60 |
1507772 | 1507772 | 2021-07-11 | Mecklenburg | Virginia | 51117 | 2365 | 68 |
1501525 | 1501525 | 2021-07-10 | Barbour | Alabama | 1005 | 2365 | 60 |
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);