ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
210 rows where cases = 2429 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 34
- Virginia 14
- Kansas 12
- Oklahoma 12
- Tennessee 9
- Wisconsin 9
- Mississippi 8
- Ohio 8
- Puerto Rico 8
- Alabama 7
- Colorado 7
- Louisiana 7
- Georgia 6
- Indiana 6
- Arkansas 5
- Idaho 5
- Kentucky 5
- South Carolina 5
- West Virginia 5
- Illinois 4
- Missouri 4
- Iowa 3
- Nebraska 3
- Florida 2
- Massachusetts 2
- Michigan 2
- Minnesota 2
- New York 2
- North Carolina 2
- North Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476521 | 2476521 | 2022-05-05 | Madison | Virginia | 51113 | 2429 | 41 |
2453726 | 2453726 | 2022-04-28 | Lunenburg | Virginia | 51111 | 2429 | 37 |
2285680 | 2285680 | 2022-03-08 | Doniphan | Kansas | 20043 | 2429 | 32 |
2282428 | 2282428 | 2022-03-07 | Doniphan | Kansas | 20043 | 2429 | 32 |
2279175 | 2279175 | 2022-03-06 | Doniphan | Kansas | 20043 | 2429 | 32 |
2275922 | 2275922 | 2022-03-05 | Doniphan | Kansas | 20043 | 2429 | 32 |
2272669 | 2272669 | 2022-03-04 | Doniphan | Kansas | 20043 | 2429 | 32 |
2269417 | 2269417 | 2022-03-03 | Doniphan | Kansas | 20043 | 2429 | 32 |
2266164 | 2266164 | 2022-03-02 | Doniphan | Kansas | 20043 | 2429 | 32 |
2264190 | 2264190 | 2022-03-01 | Major | Oklahoma | 40093 | 2429 | 36 |
2260940 | 2260940 | 2022-02-28 | Major | Oklahoma | 40093 | 2429 | 36 |
2257689 | 2257689 | 2022-02-27 | Major | Oklahoma | 40093 | 2429 | 36 |
2254438 | 2254438 | 2022-02-26 | Major | Oklahoma | 40093 | 2429 | 36 |
2251187 | 2251187 | 2022-02-25 | Major | Oklahoma | 40093 | 2429 | 36 |
2247366 | 2247366 | 2022-02-24 | Deer Lodge | Montana | 30023 | 2429 | 29 |
2247936 | 2247936 | 2022-02-24 | Major | Oklahoma | 40093 | 2429 | 36 |
2244685 | 2244685 | 2022-02-23 | Major | Oklahoma | 40093 | 2429 | 36 |
2245343 | 2245343 | 2022-02-23 | Trinity | Texas | 48455 | 2429 | 71 |
2225362 | 2225362 | 2022-02-17 | Luquillo | Puerto Rico | 72089 | 2429 | |
2220332 | 2220332 | 2022-02-16 | Valley | Idaho | 16085 | 2429 | 16 |
2221238 | 2221238 | 2022-02-16 | Bollinger | Missouri | 29017 | 2429 | 35 |
2217081 | 2217081 | 2022-02-15 | Valley | Idaho | 16085 | 2429 | 16 |
2201358 | 2201358 | 2022-02-10 | East Carroll | Louisiana | 22035 | 2429 | 35 |
2194974 | 2194974 | 2022-02-08 | Crawford | Michigan | 26039 | 2429 | 24 |
2191720 | 2191720 | 2022-02-07 | Crawford | Michigan | 26039 | 2429 | 24 |
2174792 | 2174792 | 2022-02-02 | Shoshone | Idaho | 16079 | 2429 | 71 |
2149984 | 2149984 | 2022-01-25 | Colfax | New Mexico | 35007 | 2429 | 58 |
2126466 | 2126466 | 2022-01-18 | Martin | Kentucky | 21159 | 2429 | 43 |
2110264 | 2110264 | 2022-01-13 | Claiborne | Louisiana | 22027 | 2429 | 67 |
2107013 | 2107013 | 2022-01-12 | Claiborne | Louisiana | 22027 | 2429 | 67 |
2103762 | 2103762 | 2022-01-11 | Claiborne | Louisiana | 22027 | 2429 | 66 |
2098817 | 2098817 | 2022-01-09 | Eastland | Texas | 48133 | 2429 | 91 |
2075268 | 2075268 | 2022-01-02 | Yates | New York | 36123 | 2429 | 36 |
1989791 | 1989791 | 2021-12-07 | Jackson | Kansas | 20085 | 2429 | 20 |
1986541 | 1986541 | 2021-12-06 | Jackson | Kansas | 20085 | 2429 | 20 |
1948652 | 1948652 | 2021-11-24 | Walsh | North Dakota | 38099 | 2429 | 29 |
1924608 | 1924608 | 2021-11-17 | Parke | Indiana | 18121 | 2429 | 31 |
1922626 | 1922626 | 2021-11-16 | McKenzie | North Dakota | 38053 | 2429 | 21 |
1901139 | 1901139 | 2021-11-10 | Macon | Alabama | 1087 | 2429 | 64 |
1889986 | 1889986 | 2021-11-06 | Schoharie | New York | 36095 | 2429 | 24 |
1890479 | 1890479 | 2021-11-06 | Moca | Puerto Rico | 72099 | 2429 | |
1871543 | 1871543 | 2021-10-31 | Buchanan | Virginia | 51027 | 2429 | 60 |
1867098 | 1867098 | 2021-10-30 | Saline | Nebraska | 31151 | 2429 | 6 |
1868294 | 1868294 | 2021-10-30 | Buchanan | Virginia | 51027 | 2429 | 60 |
1863849 | 1863849 | 2021-10-29 | Saline | Nebraska | 31151 | 2429 | 6 |
1865045 | 1865045 | 2021-10-29 | Buchanan | Virginia | 51027 | 2429 | 60 |
1858995 | 1858995 | 2021-10-28 | Howard | Arkansas | 5061 | 2429 | 35 |
1861403 | 1861403 | 2021-10-28 | Decatur | Tennessee | 47039 | 2429 | 44 |
1861496 | 1861496 | 2021-10-28 | Bosque | Texas | 48035 | 2429 | 55 |
1857938 | 1857938 | 2021-10-27 | Aguada | Puerto Rico | 72003 | 2429 | |
1858247 | 1858247 | 2021-10-27 | Bosque | Texas | 48035 | 2429 | 55 |
1854689 | 1854689 | 2021-10-26 | Aguada | Puerto Rico | 72003 | 2429 | |
1854998 | 1854998 | 2021-10-26 | Bosque | Texas | 48035 | 2429 | 55 |
1851440 | 1851440 | 2021-10-25 | Aguada | Puerto Rico | 72003 | 2429 | |
1851749 | 1851749 | 2021-10-25 | Bosque | Texas | 48035 | 2429 | 55 |
1838961 | 1838961 | 2021-10-21 | Tyler | Texas | 48457 | 2429 | 70 |
1835712 | 1835712 | 2021-10-20 | Tyler | Texas | 48457 | 2429 | 69 |
1830655 | 1830655 | 2021-10-19 | Green | Kentucky | 21087 | 2429 | 33 |
1832463 | 1832463 | 2021-10-19 | Tyler | Texas | 48457 | 2429 | 69 |
1829214 | 1829214 | 2021-10-18 | Tyler | Texas | 48457 | 2429 | 68 |
1825965 | 1825965 | 2021-10-17 | Tyler | Texas | 48457 | 2429 | 68 |
1822716 | 1822716 | 2021-10-16 | Tyler | Texas | 48457 | 2429 | 68 |
1819467 | 1819467 | 2021-10-15 | Tyler | Texas | 48457 | 2429 | 68 |
1815720 | 1815720 | 2021-10-14 | Corozal | Puerto Rico | 72047 | 2429 | |
1812472 | 1812472 | 2021-10-13 | Corozal | Puerto Rico | 72047 | 2429 | |
1812886 | 1812886 | 2021-10-13 | Leon | Texas | 48289 | 2429 | 63 |
1803907 | 1803907 | 2021-10-11 | Otero | Colorado | 8089 | 2429 | 76 |
1790765 | 1790765 | 2021-10-07 | Izard | Arkansas | 5065 | 2429 | 55 |
1770996 | 1770996 | 2021-09-30 | Lincoln | West Virginia | 54043 | 2429 | 34 |
1764932 | 1764932 | 2021-09-29 | Teller | Colorado | 8119 | 2429 | 24 |
1758710 | 1758710 | 2021-09-27 | Gem | Idaho | 16045 | 2429 | 50 |
1759710 | 1759710 | 2021-09-27 | Pike | Missouri | 29163 | 2429 | 33 |
1723002 | 1723002 | 2021-09-16 | Clark | Illinois | 17023 | 2429 | 46 |
1721438 | 1721438 | 2021-09-15 | Juniata | Pennsylvania | 42067 | 2429 | 100 |
1718589 | 1718589 | 2021-09-14 | Falls | Texas | 48145 | 2429 | 36 |
1706273 | 1706273 | 2021-09-11 | Clay | Arkansas | 5021 | 2429 | 53 |
1699831 | 1699831 | 2021-09-09 | Sharp | Arkansas | 5135 | 2429 | 59 |
1690042 | 1690042 | 2021-09-06 | Franklin | Arkansas | 5047 | 2429 | 46 |
1690195 | 1690195 | 2021-09-06 | Montezuma | Colorado | 8083 | 2429 | 30 |
1656615 | 1656615 | 2021-08-26 | Hampton | South Carolina | 45049 | 2429 | 56 |
1636180 | 1636180 | 2021-08-20 | Andrew | Missouri | 29003 | 2429 | 23 |
1636832 | 1636832 | 2021-08-20 | Wyandot | Ohio | 39175 | 2429 | 57 |
1632009 | 1632009 | 2021-08-19 | Elmore | Idaho | 16039 | 2429 | 20 |
1634471 | 1634471 | 2021-08-19 | Salem city | Virginia | 51775 | 2429 | 50 |
1624513 | 1624513 | 2021-08-16 | Robertson | Texas | 48395 | 2429 | 49 |
1624728 | 1624728 | 2021-08-16 | Russell | Virginia | 51167 | 2429 | 40 |
1619652 | 1619652 | 2021-08-15 | Caroline | Maryland | 24011 | 2429 | 31 |
1573260 | 1573260 | 2021-08-01 | Routt | Colorado | 8107 | 2429 | 21 |
1570012 | 1570012 | 2021-07-31 | Routt | Colorado | 8107 | 2429 | 21 |
1566764 | 1566764 | 2021-07-30 | Routt | Colorado | 8107 | 2429 | 21 |
1511066 | 1511066 | 2021-07-12 | Waynesboro city | Virginia | 51820 | 2429 | 38 |
1494217 | 1494217 | 2021-07-07 | Fairfield | South Carolina | 45039 | 2429 | 83 |
1487414 | 1487414 | 2021-07-05 | Pike | Ohio | 39131 | 2429 | 36 |
1484167 | 1484167 | 2021-07-04 | Pike | Ohio | 39131 | 2429 | 36 |
1480921 | 1480921 | 2021-07-03 | Pike | Ohio | 39131 | 2429 | 36 |
1475133 | 1475133 | 2021-07-01 | Scurry | Texas | 48415 | 2429 | 62 |
1471498 | 1471498 | 2021-06-30 | Jasper | South Carolina | 45053 | 2429 | 50 |
1471887 | 1471887 | 2021-06-30 | Scurry | Texas | 48415 | 2429 | 62 |
1430575 | 1430575 | 2021-06-18 | Hart | Georgia | 13147 | 2429 | 58 |
1432942 | 1432942 | 2021-06-18 | Scurry | Texas | 48415 | 2429 | 62 |
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);