ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where cases = 8126 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Tennessee 9
- Texas 6
- Alabama 5
- Georgia 4
- Ohio 4
- Kentucky 3
- Missouri 3
- Pennsylvania 3
- Illinois 2
- Minnesota 2
- New Hampshire 2
- North Carolina 2
- Virginia 2
- Arizona 1
- Arkansas 1
- Connecticut 1
- Hawaii 1
- Idaho 1
- Louisiana 1
- Maryland 1
- Mississippi 1
- New Jersey 1
- New Mexico 1
- Oklahoma 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2465125 | 2465125 | 2022-05-02 | Nicollet | Minnesota | 27103 | 8126 | 66 |
2437742 | 2437742 | 2022-04-24 | Marion | Alabama | 1093 | 8126 | 152 |
2434486 | 2434486 | 2022-04-23 | Marion | Alabama | 1093 | 8126 | 152 |
2431230 | 2431230 | 2022-04-22 | Marion | Alabama | 1093 | 8126 | 152 |
2348173 | 2348173 | 2022-03-27 | Warren | Missouri | 29219 | 8126 | 102 |
2344920 | 2344920 | 2022-03-26 | Warren | Missouri | 29219 | 8126 | 102 |
2341667 | 2341667 | 2022-03-25 | Warren | Missouri | 29219 | 8126 | 102 |
2264633 | 2264633 | 2022-03-01 | Bee | Texas | 48025 | 8126 | 149 |
2241365 | 2241365 | 2022-02-22 | Perry | Ohio | 39127 | 8126 | 119 |
2192249 | 2192249 | 2022-02-07 | Unknown | New Hampshire | 8126 | 27 | |
2176894 | 2176894 | 2022-02-02 | Erath | Texas | 48143 | 8126 | 114 |
2150767 | 2150767 | 2022-01-25 | Rhea | Tennessee | 47143 | 8126 | 134 |
2147515 | 2147515 | 2022-01-24 | Rhea | Tennessee | 47143 | 8126 | 134 |
2144261 | 2144261 | 2022-01-23 | Rhea | Tennessee | 47143 | 8126 | 134 |
2141006 | 2141006 | 2022-01-22 | Rhea | Tennessee | 47143 | 8126 | 134 |
2137750 | 2137750 | 2022-01-21 | Rhea | Tennessee | 47143 | 8126 | 134 |
2134496 | 2134496 | 2022-01-20 | Rhea | Tennessee | 47143 | 8126 | 134 |
2131244 | 2131244 | 2022-01-19 | Rhea | Tennessee | 47143 | 8126 | 134 |
2080492 | 2080492 | 2022-01-04 | Effingham | Illinois | 17049 | 8126 | 124 |
2020406 | 2020406 | 2021-12-16 | Huntingdon | Pennsylvania | 42061 | 8126 | 192 |
1994172 | 1994172 | 2021-12-08 | Auglaize | Ohio | 39011 | 8126 | 120 |
1988228 | 1988228 | 2021-12-06 | Anderson | Texas | 48001 | 8126 | 206 |
1907204 | 1907204 | 2021-11-11 | Van Zandt | Texas | 48467 | 8126 | 216 |
1903955 | 1903955 | 2021-11-10 | Van Zandt | Texas | 48467 | 8126 | 216 |
1900705 | 1900705 | 2021-11-09 | Van Zandt | Texas | 48467 | 8126 | 216 |
1893619 | 1893619 | 2021-11-07 | Bradford | Pennsylvania | 42015 | 8126 | 124 |
1852996 | 1852996 | 2021-10-26 | Jackson | Illinois | 17077 | 8126 | 106 |
1824218 | 1824218 | 2021-10-17 | Scott | Kentucky | 21209 | 8126 | 46 |
1820969 | 1820969 | 2021-10-16 | Scott | Kentucky | 21209 | 8126 | 46 |
1817720 | 1817720 | 2021-10-15 | Scott | Kentucky | 21209 | 8126 | 46 |
1806234 | 1806234 | 2021-10-11 | Unknown | Tennessee | 8126 | 117 | |
1755409 | 1755409 | 2021-09-26 | Tift | Georgia | 13277 | 8126 | 156 |
1752161 | 1752161 | 2021-09-25 | Tift | Georgia | 13277 | 8126 | 156 |
1748912 | 1748912 | 2021-09-24 | Tift | Georgia | 13277 | 8126 | 156 |
1739808 | 1739808 | 2021-09-21 | St. Martin | Louisiana | 22099 | 8126 | 154 |
1683960 | 1683960 | 2021-09-04 | Hawaii | Hawaii | 15001 | 8126 | 61 |
1633733 | 1633733 | 2021-08-19 | Lawrence | Pennsylvania | 42073 | 8126 | 226 |
1565205 | 1565205 | 2021-07-29 | Stanly | North Carolina | 37167 | 8126 | 138 |
1555557 | 1555557 | 2021-07-26 | Erie | Ohio | 39043 | 8126 | 166 |
1543044 | 1543044 | 2021-07-22 | Greene | Tennessee | 47059 | 8126 | 159 |
1511369 | 1511369 | 2021-07-13 | Santa Cruz | Arizona | 4023 | 8126 | 181 |
1494753 | 1494753 | 2021-07-07 | Frederick | Virginia | 51069 | 8126 | 103 |
1445081 | 1445081 | 2021-06-22 | Sampson | North Carolina | 37163 | 8126 | 114 |
1433526 | 1433526 | 2021-06-19 | Pope | Arkansas | 5115 | 8126 | 110 |
1347116 | 1347116 | 2021-05-23 | Rice | Minnesota | 27131 | 8126 | 108 |
1254875 | 1254875 | 2021-04-25 | Talladega | Alabama | 1121 | 8126 | 174 |
1232145 | 1232145 | 2021-04-18 | Talladega | Alabama | 1121 | 8126 | 173 |
1205887 | 1205887 | 2021-04-09 | Roanoke city | Virginia | 51770 | 8126 | 184 |
1125475 | 1125475 | 2021-03-16 | Bannock | Idaho | 16005 | 8126 | 97 |
1110822 | 1110822 | 2021-03-11 | Tuscarawas | Ohio | 39157 | 8126 | 233 |
1053493 | 1053493 | 2021-02-21 | Laramie | Wyoming | 56021 | 8126 | 105 |
1016765 | 1016765 | 2021-02-10 | Payne | Oklahoma | 40119 | 8126 | 43 |
898168 | 898168 | 2021-01-05 | Floyd | Georgia | 13115 | 8126 | 128 |
853731 | 853731 | 2020-12-22 | Jackson | Mississippi | 28059 | 8126 | 151 |
759956 | 759956 | 2020-11-23 | Hillsborough | New Hampshire | 33011 | 8126 | 331 |
630206 | 630206 | 2020-10-14 | Bernalillo | New Mexico | 35001 | 8126 | 184 |
407021 | 407021 | 2020-08-06 | Mercer | New Jersey | 34021 | 8126 | 618 |
294565 | 294565 | 2020-07-02 | Baltimore | Maryland | 24005 | 8126 | 474 |
145498 | 145498 | 2020-05-15 | Hartford | Connecticut | 9003 | 8126 | 1025 |
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);