ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
161 rows where cases = 3051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 15
- Mississippi 15
- Kentucky 13
- Texas 13
- Florida 11
- Georgia 8
- Indiana 8
- Tennessee 8
- Minnesota 7
- Illinois 6
- Maryland 6
- Arkansas 5
- Washington 5
- Missouri 4
- Ohio 4
- Wisconsin 4
- Colorado 3
- Michigan 3
- New York 3
- North Carolina 3
- Virginia 3
- Alabama 2
- Pennsylvania 2
- Utah 2
- California 1
- Kansas 1
- Louisiana 1
- Maine 1
- Montana 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461878 | 2461878 | 2022-05-01 | Pope | Minnesota | 27121 | 3051 | 17 |
2458622 | 2458622 | 2022-04-30 | Pope | Minnesota | 27121 | 3051 | 17 |
2455366 | 2455366 | 2022-04-29 | Pope | Minnesota | 27121 | 3051 | 17 |
2452110 | 2452110 | 2022-04-28 | Pope | Minnesota | 27121 | 3051 | 17 |
2406356 | 2406356 | 2022-04-14 | Kent | Maryland | 24029 | 3051 | 66 |
2403100 | 2403100 | 2022-04-13 | Kent | Maryland | 24029 | 3051 | 66 |
2399846 | 2399846 | 2022-04-12 | Kent | Maryland | 24029 | 3051 | 66 |
2396590 | 2396590 | 2022-04-11 | Kent | Maryland | 24029 | 3051 | 66 |
2303825 | 2303825 | 2022-03-13 | Nolan | Texas | 48353 | 3051 | 98 |
2300573 | 2300573 | 2022-03-12 | Nolan | Texas | 48353 | 3051 | 98 |
2297321 | 2297321 | 2022-03-11 | Nolan | Texas | 48353 | 3051 | 98 |
2294069 | 2294069 | 2022-03-10 | Nolan | Texas | 48353 | 3051 | 97 |
2268717 | 2268717 | 2022-03-03 | Plumas | California | 6063 | 3051 | 13 |
2199929 | 2199929 | 2022-02-09 | Dickenson | Virginia | 51051 | 3051 | 40 |
2164705 | 2164705 | 2022-01-30 | Gunnison | Colorado | 8051 | 3051 | 13 |
2158194 | 2158194 | 2022-01-28 | Gunnison | Colorado | 8051 | 3051 | 13 |
2155872 | 2155872 | 2022-01-27 | Washington | Maine | 23029 | 3051 | 45 |
2132288 | 2132288 | 2022-01-20 | Bacon | Georgia | 13005 | 3051 | 65 |
2126406 | 2126406 | 2022-01-18 | Caldwell | Kentucky | 21033 | 3051 | 55 |
2054886 | 2054886 | 2021-12-27 | Casey | Kentucky | 21045 | 3051 | 64 |
2054918 | 2054918 | 2021-12-27 | Jackson | Kentucky | 21109 | 3051 | 58 |
2051636 | 2051636 | 2021-12-26 | Casey | Kentucky | 21045 | 3051 | 64 |
2048386 | 2048386 | 2021-12-25 | Casey | Kentucky | 21045 | 3051 | 64 |
2045136 | 2045136 | 2021-12-24 | Casey | Kentucky | 21045 | 3051 | 64 |
2041030 | 2041030 | 2021-12-23 | Polk | Arkansas | 5113 | 3051 | 123 |
2041887 | 2041887 | 2021-12-23 | Casey | Kentucky | 21045 | 3051 | 64 |
2035180 | 2035180 | 2021-12-21 | Clay | Iowa | 19041 | 3051 | 38 |
2035192 | 2035192 | 2021-12-21 | Fayette | Iowa | 19065 | 3051 | 57 |
2031930 | 2031930 | 2021-12-20 | Clay | Iowa | 19041 | 3051 | 38 |
2031942 | 2031942 | 2021-12-20 | Fayette | Iowa | 19065 | 3051 | 57 |
2028679 | 2028679 | 2021-12-19 | Clay | Iowa | 19041 | 3051 | 38 |
2028691 | 2028691 | 2021-12-19 | Fayette | Iowa | 19065 | 3051 | 57 |
2025428 | 2025428 | 2021-12-18 | Clay | Iowa | 19041 | 3051 | 38 |
2025440 | 2025440 | 2021-12-18 | Fayette | Iowa | 19065 | 3051 | 57 |
2022177 | 2022177 | 2021-12-17 | Clay | Iowa | 19041 | 3051 | 38 |
2022189 | 2022189 | 2021-12-17 | Fayette | Iowa | 19065 | 3051 | 57 |
2018926 | 2018926 | 2021-12-16 | Clay | Iowa | 19041 | 3051 | 38 |
2018938 | 2018938 | 2021-12-16 | Fayette | Iowa | 19065 | 3051 | 57 |
2015676 | 2015676 | 2021-12-15 | Clay | Iowa | 19041 | 3051 | 38 |
2015688 | 2015688 | 2021-12-15 | Fayette | Iowa | 19065 | 3051 | 57 |
2017736 | 2017736 | 2021-12-15 | Young | Texas | 48503 | 3051 | 74 |
2005720 | 2005720 | 2021-12-12 | Clay | Illinois | 17025 | 3051 | 59 |
2002469 | 2002469 | 2021-12-11 | Clay | Illinois | 17025 | 3051 | 59 |
1999219 | 1999219 | 2021-12-10 | Clay | Illinois | 17025 | 3051 | 59 |
1995843 | 1995843 | 2021-12-09 | Meriwether | Georgia | 13199 | 3051 | 120 |
1996648 | 1996648 | 2021-12-09 | Manistee | Michigan | 26101 | 3051 | 52 |
1993397 | 1993397 | 2021-12-08 | Manistee | Michigan | 26101 | 3051 | 52 |
1986691 | 1986691 | 2021-12-06 | Morgan | Kentucky | 21175 | 3051 | 16 |
1985118 | 1985118 | 2021-12-05 | Lamb | Texas | 48279 | 3051 | 94 |
1985414 | 1985414 | 2021-12-05 | Asotin | Washington | 53003 | 3051 | 51 |
1982164 | 1982164 | 2021-12-04 | Asotin | Washington | 53003 | 3051 | 51 |
1975981 | 1975981 | 2021-12-03 | Cross | Arkansas | 5037 | 3051 | 68 |
1978914 | 1978914 | 2021-12-03 | Asotin | Washington | 53003 | 3051 | 51 |
1972732 | 1972732 | 2021-12-02 | Cross | Arkansas | 5037 | 3051 | 68 |
1941318 | 1941318 | 2021-11-22 | Talbot | Maryland | 24041 | 3051 | 56 |
1914836 | 1914836 | 2021-11-14 | Jay | Indiana | 18075 | 3051 | 52 |
1911586 | 1911586 | 2021-11-13 | Jay | Indiana | 18075 | 3051 | 52 |
1908337 | 1908337 | 2021-11-12 | Jay | Indiana | 18075 | 3051 | 52 |
1903982 | 1903982 | 2021-11-10 | Duchesne | Utah | 49013 | 3051 | 17 |
1900732 | 1900732 | 2021-11-09 | Duchesne | Utah | 49013 | 3051 | 17 |
1896020 | 1896020 | 2021-11-08 | Chickasaw | Mississippi | 28017 | 3051 | 67 |
1828976 | 1828976 | 2021-10-18 | Union | Tennessee | 47173 | 3051 | 45 |
1796020 | 1796020 | 2021-10-08 | Wyandot | Ohio | 39175 | 3051 | 61 |
1785174 | 1785174 | 2021-10-05 | Harrison | Kentucky | 21097 | 3051 | 30 |
1786470 | 1786470 | 2021-10-05 | Canovanas | Puerto Rico | 72029 | 3051 | |
1768218 | 1768218 | 2021-09-30 | Gilchrist | Florida | 12041 | 3051 | 54 |
1764969 | 1764969 | 2021-09-29 | Gilchrist | Florida | 12041 | 3051 | 54 |
1761720 | 1761720 | 2021-09-28 | Gilchrist | Florida | 12041 | 3051 | 54 |
1758472 | 1758472 | 2021-09-27 | Gilchrist | Florida | 12041 | 3051 | 54 |
1755224 | 1755224 | 2021-09-26 | Gilchrist | Florida | 12041 | 3051 | 54 |
1751976 | 1751976 | 2021-09-25 | Gilchrist | Florida | 12041 | 3051 | 54 |
1748497 | 1748497 | 2021-09-24 | Ashley | Arkansas | 5003 | 3051 | 42 |
1748727 | 1748727 | 2021-09-24 | Gilchrist | Florida | 12041 | 3051 | 49 |
1747233 | 1747233 | 2021-09-23 | Hocking | Ohio | 39073 | 3051 | 69 |
1748359 | 1748359 | 2021-09-23 | Waushara | Wisconsin | 55137 | 3051 | 46 |
1722214 | 1722214 | 2021-09-15 | Island | Washington | 53029 | 3051 | 37 |
1711938 | 1711938 | 2021-09-12 | Chester | Tennessee | 47023 | 3051 | 57 |
1708691 | 1708691 | 2021-09-11 | Chester | Tennessee | 47023 | 3051 | 57 |
1705444 | 1705444 | 2021-09-10 | Chester | Tennessee | 47023 | 3051 | 57 |
1691997 | 1691997 | 2021-09-06 | Gallia | Ohio | 39053 | 3051 | 53 |
1656887 | 1656887 | 2021-08-26 | Gonzales | Texas | 48177 | 3051 | 61 |
1632956 | 1632956 | 2021-08-19 | Crawford | Missouri | 29055 | 3051 | 42 |
1596792 | 1596792 | 2021-08-08 | Montgomery | Kentucky | 21173 | 3051 | 30 |
1593543 | 1593543 | 2021-08-07 | Montgomery | Kentucky | 21173 | 3051 | 30 |
1590294 | 1590294 | 2021-08-06 | Montgomery | Kentucky | 21173 | 3051 | 30 |
1583927 | 1583927 | 2021-08-04 | Queen Anne's | Maryland | 24035 | 3051 | 54 |
1565923 | 1565923 | 2021-07-29 | Frio | Texas | 48163 | 3051 | 53 |
1541021 | 1541021 | 2021-07-22 | Unknown | Georgia | 3051 | 5 | |
1519181 | 1519181 | 2021-07-15 | Coahoma | Mississippi | 28027 | 3051 | 84 |
1466530 | 1466530 | 2021-06-29 | Daviess | Indiana | 18027 | 3051 | 102 |
1463285 | 1463285 | 2021-06-28 | Daviess | Indiana | 18027 | 3051 | 102 |
1460765 | 1460765 | 2021-06-27 | Itawamba | Mississippi | 28057 | 3051 | 78 |
1457520 | 1457520 | 2021-06-26 | Itawamba | Mississippi | 28057 | 3051 | 78 |
1454275 | 1454275 | 2021-06-25 | Itawamba | Mississippi | 28057 | 3051 | 78 |
1451030 | 1451030 | 2021-06-24 | Itawamba | Mississippi | 28057 | 3051 | 78 |
1446825 | 1446825 | 2021-06-23 | Lumpkin | Georgia | 13187 | 3051 | 78 |
1447784 | 1447784 | 2021-06-23 | Itawamba | Mississippi | 28057 | 3051 | 78 |
1443580 | 1443580 | 2021-06-22 | Lumpkin | Georgia | 13187 | 3051 | 78 |
1444539 | 1444539 | 2021-06-22 | Itawamba | Mississippi | 28057 | 3051 | 78 |
1441294 | 1441294 | 2021-06-21 | Itawamba | Mississippi | 28057 | 3051 | 78 |
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);