ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where cases = 7255 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Kansas 7
- North Carolina 6
- Virginia 6
- Indiana 4
- Louisiana 4
- New Mexico 3
- Alabama 2
- Georgia 2
- Illinois 2
- Mississippi 2
- New York 2
- Ohio 2
- Texas 2
- Arizona 1
- Arkansas 1
- California 1
- Michigan 1
- Missouri 1
- New Hampshire 1
- North Dakota 1
- Pennsylvania 1
- Puerto Rico 1
- Utah 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338773 | 2338773 | 2022-03-24 | Montgomery | North Carolina | 37123 | 7255 | 126 |
2332692 | 2332692 | 2022-03-22 | Rio Grande | Puerto Rico | 72119 | 7255 | |
2281199 | 2281199 | 2022-03-06 | Botetourt | Virginia | 51023 | 7255 | 93 |
2277946 | 2277946 | 2022-03-05 | Botetourt | Virginia | 51023 | 7255 | 93 |
2274693 | 2274693 | 2022-03-04 | Botetourt | Virginia | 51023 | 7255 | 93 |
2159477 | 2159477 | 2022-01-28 | Lafayette | Missouri | 29107 | 7255 | 109 |
2156144 | 2156144 | 2022-01-27 | Prentiss | Mississippi | 28117 | 7255 | 89 |
2143984 | 2143984 | 2022-01-23 | Tioga | Pennsylvania | 42117 | 7255 | 179 |
2108930 | 2108930 | 2022-01-12 | Warren | Virginia | 51187 | 7255 | 110 |
2063331 | 2063331 | 2021-12-29 | Franklin | Virginia | 51067 | 7255 | 128 |
2051777 | 2051777 | 2021-12-26 | St. Bernard | Louisiana | 22087 | 7255 | 98 |
2048527 | 2048527 | 2021-12-25 | St. Bernard | Louisiana | 22087 | 7255 | 98 |
2045277 | 2045277 | 2021-12-24 | St. Bernard | Louisiana | 22087 | 7255 | 98 |
2042028 | 2042028 | 2021-12-23 | St. Bernard | Louisiana | 22087 | 7255 | 98 |
1991603 | 1991603 | 2021-12-07 | Jim Wells | Texas | 48249 | 7255 | 182 |
1964752 | 1964752 | 2021-11-29 | Warren | New York | 36113 | 7255 | 96 |
1959661 | 1959661 | 2021-11-28 | Tallapoosa | Alabama | 1123 | 7255 | 201 |
1951984 | 1951984 | 2021-11-25 | Shelby | Ohio | 39149 | 7255 | 132 |
1948733 | 1948733 | 2021-11-24 | Shelby | Ohio | 39149 | 7255 | 132 |
1946464 | 1946464 | 2021-11-23 | Jefferson | West Virginia | 54037 | 7255 | 89 |
1919403 | 1919403 | 2021-11-15 | Williams | North Dakota | 38105 | 7255 | 54 |
1898461 | 1898461 | 2021-11-09 | Clinton | Illinois | 17027 | 7255 | 113 |
1784345 | 1784345 | 2021-10-05 | San Benito | California | 6069 | 7255 | 69 |
1676756 | 1676756 | 2021-09-01 | Walla Walla | Washington | 53071 | 7255 | 78 |
1651456 | 1651456 | 2021-08-25 | Tift | Georgia | 13277 | 7255 | 138 |
1652820 | 1652820 | 2021-08-25 | St. Lawrence | New York | 36089 | 7255 | 97 |
1628203 | 1628203 | 2021-08-18 | Colbert | Alabama | 1033 | 7255 | 145 |
1573670 | 1573670 | 2021-08-01 | Boone | Indiana | 18011 | 7255 | 109 |
1570422 | 1570422 | 2021-07-31 | Boone | Indiana | 18011 | 7255 | 109 |
1567174 | 1567174 | 2021-07-30 | Boone | Indiana | 18011 | 7255 | 109 |
1506612 | 1506612 | 2021-07-11 | Valencia | New Mexico | 35061 | 7255 | 119 |
1503366 | 1503366 | 2021-07-10 | Valencia | New Mexico | 35061 | 7255 | 119 |
1500120 | 1500120 | 2021-07-09 | Valencia | New Mexico | 35061 | 7255 | 119 |
1472430 | 1472430 | 2021-07-01 | Crawford | Arkansas | 5033 | 7255 | 120 |
1375885 | 1375885 | 2021-06-01 | Leavenworth | Kansas | 20103 | 7255 | 92 |
1372640 | 1372640 | 2021-05-31 | Leavenworth | Kansas | 20103 | 7255 | 92 |
1369395 | 1369395 | 2021-05-30 | Leavenworth | Kansas | 20103 | 7255 | 92 |
1366149 | 1366149 | 2021-05-29 | Leavenworth | Kansas | 20103 | 7255 | 92 |
1362903 | 1362903 | 2021-05-28 | Leavenworth | Kansas | 20103 | 7255 | 92 |
1336680 | 1336680 | 2021-05-20 | Whiteside | Illinois | 17195 | 7255 | 214 |
1306187 | 1306187 | 2021-05-10 | Coryell | Texas | 48099 | 7255 | 86 |
1306414 | 1306414 | 2021-05-10 | Tooele | Utah | 49045 | 7255 | 41 |
1289267 | 1289267 | 2021-05-05 | Rutherford | North Carolina | 37161 | 7255 | 206 |
1271004 | 1271004 | 2021-04-29 | Portage | Wisconsin | 55097 | 7255 | 72 |
1243278 | 1243278 | 2021-04-21 | Lauderdale | Mississippi | 28075 | 7255 | 238 |
1219885 | 1219885 | 2021-04-14 | Wayne | Indiana | 18177 | 7255 | 202 |
1109587 | 1109587 | 2021-03-11 | Butler | Kansas | 20015 | 7255 | 78 |
1106341 | 1106341 | 2021-03-10 | Butler | Kansas | 20015 | 7255 | 78 |
1107226 | 1107226 | 2021-03-10 | Strafford | New Hampshire | 33017 | 7255 | 76 |
1033806 | 1033806 | 2021-02-15 | Portsmouth city | Virginia | 51740 | 7255 | 108 |
941825 | 941825 | 2021-01-18 | Caldwell | North Carolina | 37027 | 7255 | 31 |
938580 | 938580 | 2021-01-17 | Caldwell | North Carolina | 37027 | 7255 | 31 |
871853 | 871853 | 2020-12-28 | Apache | Arizona | 4001 | 7255 | 225 |
792543 | 792543 | 2020-12-03 | Catawba | North Carolina | 37035 | 7255 | 97 |
756918 | 756918 | 2020-11-22 | Union | North Carolina | 37179 | 7255 | 72 |
700233 | 700233 | 2020-11-05 | Henry | Georgia | 13151 | 7255 | 124 |
232070 | 232070 | 2020-06-12 | Macomb | Michigan | 26099 | 7255 | 886 |
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);