ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
127 rows where cases = 3038 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 19
- Georgia 14
- Texas 8
- Arkansas 6
- Tennessee 6
- Minnesota 5
- Virginia 5
- Missouri 4
- North Carolina 4
- Colorado 3
- Illinois 3
- Louisiana 3
- Maryland 3
- New Jersey 3
- New York 3
- Pennsylvania 3
- Puerto Rico 3
- Wisconsin 3
- Idaho 2
- Indiana 2
- Kentucky 2
- Maine 2
- Michigan 2
- Nebraska 2
- Ohio 2
- South Dakota 2
- West Virginia 2
- Alabama 1
- Florida 1
- Iowa 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461687 | 2461687 | 2022-05-01 | Piscataquis | Maine | 23021 | 3038 | 31 |
2458431 | 2458431 | 2022-04-30 | Piscataquis | Maine | 23021 | 3038 | 31 |
2370806 | 2370806 | 2022-04-03 | Perry | Mississippi | 28111 | 3038 | 64 |
2367553 | 2367553 | 2022-04-02 | Perry | Mississippi | 28111 | 3038 | 64 |
2364300 | 2364300 | 2022-04-01 | Perry | Mississippi | 28111 | 3038 | 64 |
2361046 | 2361046 | 2022-03-31 | Perry | Mississippi | 28111 | 3038 | 64 |
2357792 | 2357792 | 2022-03-30 | Perry | Mississippi | 28111 | 3038 | 64 |
2354539 | 2354539 | 2022-03-29 | Perry | Mississippi | 28111 | 3038 | 64 |
2351287 | 2351287 | 2022-03-28 | Perry | Mississippi | 28111 | 3038 | 64 |
2341275 | 2341275 | 2022-03-25 | Kent | Maryland | 24029 | 3038 | 66 |
2309148 | 2309148 | 2022-03-15 | Custer | Montana | 30017 | 3038 | 46 |
2243013 | 2243013 | 2022-02-23 | Telfair | Georgia | 13271 | 3038 | 79 |
2224733 | 2224733 | 2022-02-17 | Seward | Nebraska | 31159 | 3038 | 41 |
2178462 | 2178462 | 2022-02-03 | Breathitt | Kentucky | 21025 | 3038 | 50 |
2161450 | 2161450 | 2022-01-29 | Gunnison | Colorado | 8051 | 3038 | 13 |
2154941 | 2154941 | 2022-01-27 | Gunnison | Colorado | 8051 | 3038 | 13 |
2150424 | 2150424 | 2022-01-25 | Tillamook | Oregon | 41057 | 3038 | 54 |
2131119 | 2131119 | 2022-01-19 | Clay | South Dakota | 46027 | 3038 | 18 |
2125269 | 2125269 | 2022-01-17 | Monroe | West Virginia | 54063 | 3038 | 33 |
2066008 | 2066008 | 2021-12-30 | San Lorenzo | Puerto Rico | 72129 | 3038 | |
2057243 | 2057243 | 2021-12-28 | Drew | Arkansas | 5043 | 3038 | 56 |
2021527 | 2021527 | 2021-12-17 | Polk | Arkansas | 5113 | 3038 | 119 |
2016821 | 2016821 | 2021-12-15 | Madison | North Carolina | 37115 | 3038 | 66 |
1998325 | 1998325 | 2021-12-09 | Fluvanna | Virginia | 51065 | 3038 | 29 |
1971468 | 1971468 | 2021-12-01 | Meigs | Ohio | 39105 | 3038 | 59 |
1971725 | 1971725 | 2021-12-01 | Juncos | Puerto Rico | 72077 | 3038 | |
1966738 | 1966738 | 2021-11-30 | Hancock | Illinois | 17067 | 3038 | 45 |
1953003 | 1953003 | 2021-11-25 | Adams | Wisconsin | 55001 | 3038 | 35 |
1927383 | 1927383 | 2021-11-18 | Otero | Colorado | 8089 | 3038 | 89 |
1926449 | 1926449 | 2021-11-17 | Sequatchie | Tennessee | 47153 | 3038 | 33 |
1850715 | 1850715 | 2021-10-25 | Vernon | Missouri | 29217 | 3038 | 64 |
1847465 | 1847465 | 2021-10-24 | Vernon | Missouri | 29217 | 3038 | 64 |
1829400 | 1829400 | 2021-10-18 | Scott | Virginia | 51169 | 3038 | 75 |
1807418 | 1807418 | 2021-10-12 | Worth | Georgia | 13321 | 3038 | 87 |
1786488 | 1786488 | 2021-10-05 | Gurabo | Puerto Rico | 72063 | 3038 | |
1745260 | 1745260 | 2021-09-23 | Conway | Arkansas | 5029 | 3038 | 41 |
1742057 | 1742057 | 2021-09-22 | Randolph | Arkansas | 5121 | 3038 | 51 |
1738038 | 1738038 | 2021-09-20 | Burleson | Texas | 48051 | 3038 | 55 |
1732679 | 1732679 | 2021-09-19 | Washington | Georgia | 13303 | 3038 | 101 |
1734788 | 1734788 | 2021-09-19 | Burleson | Texas | 48051 | 3038 | 55 |
1729429 | 1729429 | 2021-09-18 | Washington | Georgia | 13303 | 3038 | 101 |
1731538 | 1731538 | 2021-09-18 | Burleson | Texas | 48051 | 3038 | 55 |
1726179 | 1726179 | 2021-09-17 | Washington | Georgia | 13303 | 3038 | 101 |
1710844 | 1710844 | 2021-09-12 | Jasper | Mississippi | 28061 | 3038 | 60 |
1707597 | 1707597 | 2021-09-11 | Jasper | Mississippi | 28061 | 3038 | 60 |
1704350 | 1704350 | 2021-09-10 | Jasper | Mississippi | 28061 | 3038 | 60 |
1690371 | 1690371 | 2021-09-06 | Hart | Georgia | 13147 | 3038 | 59 |
1687121 | 1687121 | 2021-09-05 | Hart | Georgia | 13147 | 3038 | 59 |
1683871 | 1683871 | 2021-09-04 | Hart | Georgia | 13147 | 3038 | 59 |
1686229 | 1686229 | 2021-09-04 | Reeves | Texas | 48389 | 3038 | 46 |
1680620 | 1680620 | 2021-09-03 | Hart | Georgia | 13147 | 3038 | 59 |
1646516 | 1646516 | 2021-08-23 | Fayette | Ohio | 39047 | 3038 | 50 |
1632517 | 1632517 | 2021-08-19 | Mercer | Kentucky | 21167 | 3038 | 52 |
1624443 | 1624443 | 2021-08-16 | Karnes | Texas | 48255 | 3038 | 37 |
1624828 | 1624828 | 2021-08-16 | Preston | West Virginia | 54077 | 3038 | 47 |
1597071 | 1597071 | 2021-08-08 | Le Sueur | Minnesota | 27079 | 3038 | 28 |
1593822 | 1593822 | 2021-08-07 | Le Sueur | Minnesota | 27079 | 3038 | 28 |
1590573 | 1590573 | 2021-08-06 | Le Sueur | Minnesota | 27079 | 3038 | 28 |
1569271 | 1569271 | 2021-07-30 | Palo Pinto | Texas | 48363 | 3038 | 78 |
1563051 | 1563051 | 2021-07-28 | Mason | Washington | 53045 | 3038 | 38 |
1559341 | 1559341 | 2021-07-27 | Wayne | Tennessee | 47181 | 3038 | 36 |
1506196 | 1506196 | 2021-07-11 | Copiah | Mississippi | 28029 | 3038 | 66 |
1502950 | 1502950 | 2021-07-10 | Copiah | Mississippi | 28029 | 3038 | 66 |
1499704 | 1499704 | 2021-07-09 | Copiah | Mississippi | 28029 | 3038 | 66 |
1496458 | 1496458 | 2021-07-08 | Copiah | Mississippi | 28029 | 3038 | 66 |
1404630 | 1404630 | 2021-06-10 | Lumpkin | Georgia | 13187 | 3038 | 77 |
1398108 | 1398108 | 2021-06-08 | Gilmer | Georgia | 13123 | 3038 | 87 |
1394213 | 1394213 | 2021-06-06 | Warren | Virginia | 51187 | 3038 | 59 |
1369890 | 1369890 | 2021-05-30 | Itawamba | Mississippi | 28057 | 3038 | 77 |
1366644 | 1366644 | 2021-05-29 | Itawamba | Mississippi | 28057 | 3038 | 77 |
1363398 | 1363398 | 2021-05-28 | Itawamba | Mississippi | 28057 | 3038 | 77 |
1358512 | 1358512 | 2021-05-26 | Warren | Virginia | 51187 | 3038 | 58 |
1298354 | 1298354 | 2021-05-08 | Brown | Minnesota | 27015 | 3038 | 40 |
1295108 | 1295108 | 2021-05-07 | Brown | Minnesota | 27015 | 3038 | 40 |
1266834 | 1266834 | 2021-04-28 | Clarion | Pennsylvania | 42031 | 3038 | 90 |
1248728 | 1248728 | 2021-04-23 | Butts | Georgia | 13035 | 3038 | 81 |
1243005 | 1243005 | 2021-04-21 | Vernon | Louisiana | 22115 | 3038 | 101 |
1218449 | 1218449 | 2021-04-13 | Scott | Tennessee | 47151 | 3038 | 45 |
1180911 | 1180911 | 2021-04-02 | White | Indiana | 18181 | 3038 | 55 |
1153473 | 1153473 | 2021-03-24 | Marion | Tennessee | 47115 | 3038 | 46 |
1150121 | 1150121 | 2021-03-23 | Davison | South Dakota | 46035 | 3038 | 67 |
1145873 | 1145873 | 2021-03-22 | Scott | Mississippi | 28123 | 3038 | 71 |
1128679 | 1128679 | 2021-03-17 | Stephens | Georgia | 13257 | 3038 | 74 |
1123582 | 1123582 | 2021-03-15 | Bladen | North Carolina | 37017 | 3038 | 41 |
1118988 | 1118988 | 2021-03-14 | Bonner | Idaho | 16017 | 3038 | 35 |
1119563 | 1119563 | 2021-03-14 | East Feliciana | Louisiana | 22037 | 3038 | 107 |
1115741 | 1115741 | 2021-03-13 | Bonner | Idaho | 16017 | 3038 | 35 |
1109824 | 1109824 | 2021-03-11 | East Feliciana | Louisiana | 22037 | 3038 | 106 |
1105432 | 1105432 | 2021-03-09 | Sheridan | Wyoming | 56033 | 3038 | 30 |
1097676 | 1097676 | 2021-03-07 | Person | North Carolina | 37145 | 3038 | 64 |
1094428 | 1094428 | 2021-03-06 | Person | North Carolina | 37145 | 3038 | 64 |
1056523 | 1056523 | 2021-02-22 | Petersburg city | Virginia | 51730 | 3038 | 41 |
1039132 | 1039132 | 2021-02-17 | Cortland | New York | 36023 | 3038 | 60 |
1029120 | 1029120 | 2021-02-14 | Platte | Missouri | 29165 | 3038 | 38 |
1025874 | 1025874 | 2021-02-13 | Platte | Missouri | 29165 | 3038 | 38 |
1017743 | 1017743 | 2021-02-10 | Lincoln | Wisconsin | 55069 | 3038 | 73 |
1013759 | 1013759 | 2021-02-09 | Marion | South Carolina | 45067 | 3038 | 91 |
996405 | 996405 | 2021-02-04 | Tuscola | Michigan | 26157 | 3038 | 128 |
984673 | 984673 | 2021-01-31 | Lauderdale | Tennessee | 47097 | 3038 | 36 |
976833 | 976833 | 2021-01-29 | Worcester | Maryland | 24047 | 3038 | 77 |
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);