ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
205 rows where cases = 2466 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 19
- Virginia 16
- Missouri 14
- Indiana 13
- Kentucky 13
- Georgia 12
- Ohio 8
- Puerto Rico 8
- Utah 8
- Colorado 7
- Louisiana 7
- Mississippi 7
- Arkansas 6
- Tennessee 5
- Alabama 4
- Illinois 4
- North Carolina 4
- Pennsylvania 4
- Wisconsin 4
- Florida 3
- Iowa 3
- Kansas 3
- Michigan 3
- New York 3
- West Virginia 3
- Arizona 2
- California 2
- Maryland 2
- Minnesota 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2415977 | 2415977 | 2022-04-17 | Livingston | Kentucky | 21139 | 2466 | 59 |
2417882 | 2417882 | 2022-04-17 | Franklin city | Virginia | 51620 | 2466 | 54 |
2412721 | 2412721 | 2022-04-16 | Livingston | Kentucky | 21139 | 2466 | 59 |
2414626 | 2414626 | 2022-04-16 | Franklin city | Virginia | 51620 | 2466 | 54 |
2409465 | 2409465 | 2022-04-15 | Livingston | Kentucky | 21139 | 2466 | 59 |
2411370 | 2411370 | 2022-04-15 | Franklin city | Virginia | 51620 | 2466 | 54 |
2406209 | 2406209 | 2022-04-14 | Livingston | Kentucky | 21139 | 2466 | 59 |
2402953 | 2402953 | 2022-04-13 | Livingston | Kentucky | 21139 | 2466 | 59 |
2399699 | 2399699 | 2022-04-12 | Livingston | Kentucky | 21139 | 2466 | 59 |
2401603 | 2401603 | 2022-04-12 | Franklin city | Virginia | 51620 | 2466 | 53 |
2396443 | 2396443 | 2022-04-11 | Livingston | Kentucky | 21139 | 2466 | 59 |
2398348 | 2398348 | 2022-04-11 | Franklin city | Virginia | 51620 | 2466 | 52 |
2395093 | 2395093 | 2022-04-10 | Franklin city | Virginia | 51620 | 2466 | 52 |
2391837 | 2391837 | 2022-04-09 | Franklin city | Virginia | 51620 | 2466 | 52 |
2388581 | 2388581 | 2022-04-08 | Franklin city | Virginia | 51620 | 2466 | 52 |
2381986 | 2381986 | 2022-04-06 | Emery | Utah | 49015 | 2466 | 28 |
2378731 | 2378731 | 2022-04-05 | Emery | Utah | 49015 | 2466 | 28 |
2378794 | 2378794 | 2022-04-05 | Charlotte | Virginia | 51037 | 2466 | 45 |
2345691 | 2345691 | 2022-03-26 | Luquillo | Puerto Rico | 72089 | 2466 | |
2335088 | 2335088 | 2022-03-23 | Grundy | Missouri | 29079 | 2466 | 67 |
2285470 | 2285470 | 2022-03-08 | Benton | Indiana | 18007 | 2466 | 21 |
2245377 | 2245377 | 2022-02-23 | Emery | Utah | 49015 | 2466 | 27 |
2242126 | 2242126 | 2022-02-22 | Emery | Utah | 49015 | 2466 | 27 |
2238875 | 2238875 | 2022-02-21 | Emery | Utah | 49015 | 2466 | 27 |
2235624 | 2235624 | 2022-02-20 | Emery | Utah | 49015 | 2466 | 27 |
2217678 | 2217678 | 2022-02-15 | Piscataquis | Maine | 23021 | 2466 | 26 |
2218544 | 2218544 | 2022-02-15 | Unknown | Northern Mariana Islands | 2466 | 2 | |
2182733 | 2182733 | 2022-02-04 | Mercer | North Dakota | 38057 | 2466 | 23 |
2180676 | 2180676 | 2022-02-03 | Big Horn | Wyoming | 56003 | 2466 | 60 |
2156647 | 2156647 | 2022-01-27 | Perquimans | North Carolina | 37143 | 2466 | 17 |
2082714 | 2082714 | 2022-01-04 | Terry | Texas | 48445 | 2466 | 73 |
2075459 | 2075459 | 2022-01-02 | Harrison | Ohio | 39067 | 2466 | 58 |
2054266 | 2054266 | 2021-12-27 | Brooks | Georgia | 13027 | 2466 | 75 |
1998487 | 1998487 | 2021-12-09 | Morgan | West Virginia | 54065 | 2466 | 50 |
1988895 | 1988895 | 2021-12-07 | Macon | Alabama | 1087 | 2466 | 67 |
1984995 | 1984995 | 2021-12-05 | Bosque | Texas | 48035 | 2466 | 57 |
1978186 | 1978186 | 2021-12-03 | Aguada | Puerto Rico | 72003 | 2466 | |
1971351 | 1971351 | 2021-12-01 | Warren | North Carolina | 37185 | 2466 | 33 |
1959858 | 1959858 | 2021-11-28 | Crowley | Colorado | 8025 | 2466 | 26 |
1956607 | 1956607 | 2021-11-27 | Crowley | Colorado | 8025 | 2466 | 26 |
1953356 | 1953356 | 2021-11-26 | Crowley | Colorado | 8025 | 2466 | 26 |
1950105 | 1950105 | 2021-11-25 | Crowley | Colorado | 8025 | 2466 | 26 |
1929643 | 1929643 | 2021-11-18 | Decatur | Tennessee | 47039 | 2466 | 44 |
1917314 | 1917314 | 2021-11-14 | Washburn | Wisconsin | 55129 | 2466 | 28 |
1914064 | 1914064 | 2021-11-13 | Washburn | Wisconsin | 55129 | 2466 | 28 |
1910814 | 1910814 | 2021-11-12 | Washburn | Wisconsin | 55129 | 2466 | 28 |
1861209 | 1861209 | 2021-10-28 | Corozal | Puerto Rico | 72047 | 2466 | |
1856723 | 1856723 | 2021-10-27 | Webster | Kentucky | 21233 | 2466 | 35 |
1835637 | 1835637 | 2021-10-20 | Madison | Texas | 48313 | 2466 | 43 |
1790326 | 1790326 | 2021-10-06 | Colonial Heights city | Virginia | 51570 | 2466 | 64 |
1782456 | 1782456 | 2021-10-04 | Pike | Missouri | 29163 | 2466 | 33 |
1777045 | 1777045 | 2021-10-02 | Colorado | Texas | 48089 | 2466 | 51 |
1765241 | 1765241 | 2021-09-29 | Clay | Illinois | 17025 | 2466 | 54 |
1758858 | 1758858 | 2021-09-27 | Franklin | Indiana | 18047 | 2466 | 39 |
1760757 | 1760757 | 2021-09-27 | Aransas | Texas | 48007 | 2466 | 56 |
1760903 | 1760903 | 2021-09-27 | Llano | Texas | 48299 | 2466 | 66 |
1757509 | 1757509 | 2021-09-26 | Aransas | Texas | 48007 | 2466 | 56 |
1750783 | 1750783 | 2021-09-24 | San Sebastian | Puerto Rico | 72131 | 2466 | |
1736955 | 1736955 | 2021-09-20 | Moniteau | Missouri | 29135 | 2466 | 38 |
1733705 | 1733705 | 2021-09-19 | Moniteau | Missouri | 29135 | 2466 | 38 |
1717001 | 1717001 | 2021-09-14 | Spencer | Kentucky | 21215 | 2466 | 26 |
1715558 | 1715558 | 2021-09-13 | Franklin | Vermont | 50011 | 2466 | 40 |
1710585 | 1710585 | 2021-09-12 | Winn | Louisiana | 22127 | 2466 | 54 |
1712142 | 1712142 | 2021-09-12 | Jackson | Texas | 48239 | 2466 | 38 |
1707338 | 1707338 | 2021-09-11 | Winn | Louisiana | 22127 | 2466 | 54 |
1708895 | 1708895 | 2021-09-11 | Jackson | Texas | 48239 | 2466 | 38 |
1704090 | 1704090 | 2021-09-10 | Winn | Louisiana | 22127 | 2466 | 54 |
1704462 | 1704462 | 2021-09-10 | Livingston | Missouri | 29117 | 2466 | 61 |
1705648 | 1705648 | 2021-09-10 | Jackson | Texas | 48239 | 2466 | 38 |
1679716 | 1679716 | 2021-09-02 | Panola | Texas | 48365 | 2466 | 88 |
1654343 | 1654343 | 2021-08-26 | Polk | Arkansas | 5113 | 2466 | 85 |
1638071 | 1638071 | 2021-08-21 | Hempstead | Arkansas | 5057 | 2466 | 20 |
1628727 | 1628727 | 2021-08-18 | Washington | Georgia | 13303 | 2466 | 91 |
1627706 | 1627706 | 2021-08-17 | Lee | Texas | 48287 | 2466 | 40 |
1618616 | 1618616 | 2021-08-15 | Randolph | Arkansas | 5121 | 2466 | 49 |
1618936 | 1618936 | 2021-08-15 | Mitchell | Georgia | 13205 | 2466 | 85 |
1619171 | 1619171 | 2021-08-15 | Fountain | Indiana | 18045 | 2466 | 51 |
1615688 | 1615688 | 2021-08-14 | Mitchell | Georgia | 13205 | 2466 | 85 |
1615923 | 1615923 | 2021-08-14 | Fountain | Indiana | 18045 | 2466 | 51 |
1612439 | 1612439 | 2021-08-13 | Mitchell | Georgia | 13205 | 2466 | 85 |
1612674 | 1612674 | 2021-08-13 | Fountain | Indiana | 18045 | 2466 | 51 |
1599996 | 1599996 | 2021-08-09 | Grayson | Kentucky | 21085 | 2466 | 58 |
1594314 | 1594314 | 2021-08-07 | Delaware | New York | 36025 | 2466 | 39 |
1586701 | 1586701 | 2021-08-05 | Jennings | Indiana | 18079 | 2466 | 51 |
1582465 | 1582465 | 2021-08-03 | Mecklenburg | Virginia | 51117 | 2466 | 68 |
1553586 | 1553586 | 2021-07-26 | Arkansas | Arkansas | 5001 | 2466 | 40 |
1539681 | 1539681 | 2021-07-21 | Jasper | South Carolina | 45053 | 2466 | 49 |
1536565 | 1536565 | 2021-07-20 | Johnson | Tennessee | 47091 | 2466 | 39 |
1533317 | 1533317 | 2021-07-19 | Johnson | Tennessee | 47091 | 2466 | 39 |
1514740 | 1514740 | 2021-07-14 | Siskiyou | California | 6093 | 2466 | 40 |
1511385 | 1511385 | 2021-07-13 | Columbia | Arkansas | 5027 | 2466 | 58 |
1510765 | 1510765 | 2021-07-12 | Karnes | Texas | 48255 | 2466 | 37 |
1473095 | 1473095 | 2021-07-01 | Washington | Indiana | 18175 | 2466 | 37 |
1469849 | 1469849 | 2021-06-30 | Washington | Indiana | 18175 | 2466 | 37 |
1450032 | 1450032 | 2021-06-24 | Fannin | Georgia | 13111 | 2466 | 73 |
1428126 | 1428126 | 2021-06-17 | Clare | Michigan | 26035 | 2466 | 83 |
1396552 | 1396552 | 2021-06-07 | Van Wert | Ohio | 39161 | 2466 | 64 |
1393305 | 1393305 | 2021-06-06 | Van Wert | Ohio | 39161 | 2466 | 64 |
1390060 | 1390060 | 2021-06-05 | Van Wert | Ohio | 39161 | 2466 | 64 |
1386815 | 1386815 | 2021-06-04 | Van Wert | Ohio | 39161 | 2466 | 64 |
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);