ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where cases = 8270 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Florida 9
- Virginia 7
- Georgia 6
- Indiana 4
- Minnesota 4
- North Carolina 4
- Ohio 4
- Illinois 3
- Kansas 3
- Kentucky 3
- Pennsylvania 3
- Texas 2
- California 1
- Iowa 1
- Louisiana 1
- Michigan 1
- Mississippi 1
- Missouri 1
- New Jersey 1
- North Dakota 1
- Tennessee 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501905 | 2501905 | 2022-05-13 | Tioga | Pennsylvania | 42117 | 8270 | 193 |
2498647 | 2498647 | 2022-05-12 | Tioga | Pennsylvania | 42117 | 8270 | 193 |
2495389 | 2495389 | 2022-05-11 | Tioga | Pennsylvania | 42117 | 8270 | 193 |
2443979 | 2443979 | 2022-04-25 | Petersburg city | Virginia | 51730 | 8270 | 139 |
2430955 | 2430955 | 2022-04-21 | Petersburg city | Virginia | 51730 | 8270 | 139 |
2427699 | 2427699 | 2022-04-20 | Petersburg city | Virginia | 51730 | 8270 | 139 |
2305046 | 2305046 | 2022-03-14 | Ripley | Indiana | 18137 | 8270 | 137 |
2266318 | 2266318 | 2022-03-02 | Logan | Kentucky | 21141 | 8270 | 112 |
2219534 | 2219534 | 2022-02-15 | Warren | Virginia | 51187 | 8270 | 134 |
2159467 | 2159467 | 2022-01-28 | Howell | Missouri | 29091 | 8270 | 184 |
2152838 | 2152838 | 2022-01-26 | Bolivar | Mississippi | 28011 | 8270 | 157 |
2088282 | 2088282 | 2022-01-06 | Beaufort | North Carolina | 37013 | 8270 | 140 |
2009076 | 2009076 | 2021-12-13 | DeKalb | Indiana | 18033 | 8270 | 115 |
1964933 | 1964933 | 2021-11-29 | Darke | Ohio | 39037 | 8270 | 179 |
1878221 | 1878221 | 2021-11-02 | Marion | West Virginia | 54049 | 8270 | 106 |
1849844 | 1849844 | 2021-10-25 | Henry | Indiana | 18065 | 8270 | 158 |
1830621 | 1830621 | 2021-10-19 | Boyd | Kentucky | 21019 | 8270 | 101 |
1807395 | 1807395 | 2021-10-12 | Tift | Georgia | 13277 | 8270 | 168 |
1793273 | 1793273 | 2021-10-07 | Caldwell | Texas | 48055 | 8270 | 141 |
1788492 | 1788492 | 2021-10-06 | Whitley | Kentucky | 21235 | 8270 | 79 |
1623676 | 1623676 | 2021-08-16 | Rutherford | North Carolina | 37161 | 8270 | 225 |
1594539 | 1594539 | 2021-08-07 | Erie | Ohio | 39043 | 8270 | 166 |
1561361 | 1561361 | 2021-07-28 | Rice | Minnesota | 27131 | 8270 | 111 |
1478530 | 1478530 | 2021-07-02 | Hanover | Virginia | 51085 | 8270 | 167 |
1463907 | 1463907 | 2021-06-28 | Clay | Minnesota | 27027 | 8270 | 92 |
1460662 | 1460662 | 2021-06-27 | Clay | Minnesota | 27027 | 8270 | 92 |
1457417 | 1457417 | 2021-06-26 | Clay | Minnesota | 27027 | 8270 | 92 |
1427201 | 1427201 | 2021-06-17 | Columbia | Florida | 12023 | 8270 | 170 |
1423956 | 1423956 | 2021-06-16 | Columbia | Florida | 12023 | 8270 | 170 |
1420708 | 1420708 | 2021-06-15 | Columbia | Florida | 12023 | 8270 | 170 |
1417463 | 1417463 | 2021-06-14 | Columbia | Florida | 12023 | 8270 | 170 |
1414217 | 1414217 | 2021-06-13 | Columbia | Florida | 12023 | 8270 | 170 |
1410972 | 1410972 | 2021-06-12 | Columbia | Florida | 12023 | 8270 | 170 |
1407727 | 1407727 | 2021-06-11 | Columbia | Florida | 12023 | 8270 | 170 |
1378518 | 1378518 | 2021-06-02 | Columbia | Florida | 12023 | 8270 | 170 |
1362410 | 1362410 | 2021-05-28 | Gordon | Georgia | 13129 | 8270 | 117 |
1359162 | 1359162 | 2021-05-27 | Glynn | Georgia | 13127 | 8270 | 177 |
1359163 | 1359163 | 2021-05-27 | Gordon | Georgia | 13129 | 8270 | 118 |
1255415 | 1255415 | 2021-04-25 | Adams | Illinois | 17001 | 8270 | 148 |
1252168 | 1252168 | 2021-04-24 | Adams | Illinois | 17001 | 8270 | 146 |
1172177 | 1172177 | 2021-03-30 | Hunterdon | New Jersey | 34019 | 8270 | 169 |
1166006 | 1166006 | 2021-03-28 | Pickaway | Ohio | 39129 | 8270 | 118 |
1133485 | 1133485 | 2021-03-18 | Columbiana | Ohio | 39029 | 8270 | 214 |
1074907 | 1074907 | 2021-02-28 | Craven | North Carolina | 37049 | 8270 | 114 |
1071661 | 1071661 | 2021-02-27 | Craven | North Carolina | 37049 | 8270 | 114 |
1072773 | 1072773 | 2021-02-27 | Spotsylvania | Virginia | 51177 | 8270 | 98 |
882364 | 882364 | 2020-12-31 | Pottawattamie | Iowa | 19155 | 8270 | 95 |
845500 | 845500 | 2020-12-19 | Chesapeake city | Virginia | 51550 | 8270 | 94 |
809539 | 809539 | 2020-12-08 | Ellis | Texas | 48139 | 8270 | 127 |
792643 | 792643 | 2020-12-03 | Grand Forks | North Dakota | 38035 | 8270 | 48 |
758952 | 758952 | 2020-11-23 | Tippecanoe | Indiana | 18157 | 8270 | 28 |
752144 | 752144 | 2020-11-21 | Henry | Georgia | 13151 | 8270 | 132 |
700424 | 700424 | 2020-11-05 | Madison | Illinois | 17119 | 8270 | 164 |
674332 | 674332 | 2020-10-28 | Richmond | Georgia | 13245 | 8270 | 183 |
612417 | 612417 | 2020-10-09 | Sonoma | California | 6097 | 8270 | 126 |
589865 | 589865 | 2020-10-02 | Sarasota | Florida | 12115 | 8270 | 263 |
554974 | 554974 | 2020-09-21 | Caddo | Louisiana | 22017 | 8270 | 348 |
551588 | 551588 | 2020-09-20 | Sedgwick | Kansas | 20173 | 8270 | 81 |
548349 | 548349 | 2020-09-19 | Sedgwick | Kansas | 20173 | 8270 | 81 |
545111 | 545111 | 2020-09-18 | Sedgwick | Kansas | 20173 | 8270 | 81 |
517599 | 517599 | 2020-09-09 | Rutherford | Tennessee | 47149 | 8270 | 81 |
36700 | 36700 | 2020-04-06 | Wayne | Michigan | 26163 | 8270 | 346 |
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);