ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 7230 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Indiana 6
- Georgia 4
- Virginia 4
- Alabama 3
- Florida 3
- Illinois 3
- Pennsylvania 3
- Texas 3
- Kansas 2
- Kentucky 2
- Mississippi 2
- Missouri 2
- Ohio 2
- Puerto Rico 2
- South Carolina 2
- Idaho 1
- Louisiana 1
- Maryland 1
- Minnesota 1
- New Jersey 1
- New York 1
- North Carolina 1
- Oregon 1
- Virgin Islands 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2482381 | 2482381 | 2022-05-07 | Canovanas | Puerto Rico | 72029 | 7230 | |
2461127 | 2461127 | 2022-05-01 | Iroquois | Illinois | 17075 | 7230 | 117 |
2461220 | 2461220 | 2022-05-01 | Greene | Indiana | 18055 | 7230 | 139 |
2457871 | 2457871 | 2022-04-30 | Iroquois | Illinois | 17075 | 7230 | 117 |
2457964 | 2457964 | 2022-04-30 | Greene | Indiana | 18055 | 7230 | 139 |
2454615 | 2454615 | 2022-04-29 | Iroquois | Illinois | 17075 | 7230 | 117 |
2454708 | 2454708 | 2022-04-29 | Greene | Indiana | 18055 | 7230 | 139 |
2424184 | 2424184 | 2022-04-19 | Kleberg | Texas | 48273 | 7230 | 147 |
2407387 | 2407387 | 2022-04-14 | Jefferson | Oregon | 41031 | 7230 | 90 |
2408171 | 2408171 | 2022-04-14 | Pulaski | Virginia | 51155 | 7230 | 135 |
2401558 | 2401558 | 2022-04-12 | St. Thomas | Virgin Islands | 78030 | 7230 | 59 |
2379528 | 2379528 | 2022-04-06 | Decatur | Georgia | 13087 | 7230 | 128 |
2376274 | 2376274 | 2022-04-05 | Decatur | Georgia | 13087 | 7230 | 128 |
2373022 | 2373022 | 2022-04-04 | Decatur | Georgia | 13087 | 7230 | 128 |
2271490 | 2271490 | 2022-03-03 | Isle of Wight | Virginia | 51093 | 7230 | 106 |
2268238 | 2268238 | 2022-03-02 | Isle of Wight | Virginia | 51093 | 7230 | 106 |
2127839 | 2127839 | 2022-01-18 | Marion | South Carolina | 45067 | 7230 | 149 |
2112279 | 2112279 | 2022-01-13 | Wayne | West Virginia | 54099 | 7230 | 96 |
2098440 | 2098440 | 2022-01-09 | Perry | Pennsylvania | 42099 | 7230 | 158 |
1991611 | 1991611 | 2021-12-07 | Kerr | Texas | 48265 | 7230 | 140 |
1986165 | 1986165 | 2021-12-06 | Bingham | Idaho | 16011 | 7230 | 129 |
1978602 | 1978602 | 2021-12-03 | Jim Wells | Texas | 48249 | 7230 | 182 |
1919670 | 1919670 | 2021-11-15 | Venango | Pennsylvania | 42121 | 7230 | 152 |
1898884 | 1898884 | 2021-11-09 | Franklin | Kentucky | 21073 | 7230 | 81 |
1785635 | 1785635 | 2021-10-05 | Callaway | Missouri | 29027 | 7230 | 67 |
1746190 | 1746190 | 2021-09-23 | Hopkins | Kentucky | 21107 | 7230 | 181 |
1721061 | 1721061 | 2021-09-15 | Carteret | North Carolina | 37031 | 7230 | 58 |
1684619 | 1684619 | 2021-09-04 | Cecil | Maryland | 24015 | 7230 | 162 |
1649024 | 1649024 | 2021-08-24 | Crow Wing | Minnesota | 27035 | 7230 | 100 |
1643075 | 1643075 | 2021-08-22 | Steuben | New York | 36101 | 7230 | 148 |
1560678 | 1560678 | 2021-07-28 | Boone | Indiana | 18011 | 7230 | 109 |
1532291 | 1532291 | 2021-07-19 | Joplin | Missouri | 7230 | 117 | |
1506831 | 1506831 | 2021-07-11 | Ashtabula | Ohio | 39007 | 7230 | 179 |
1426868 | 1426868 | 2021-06-17 | Autauga | Alabama | 1001 | 7230 | 113 |
1423622 | 1423622 | 2021-06-16 | Autauga | Alabama | 1001 | 7230 | 113 |
1420375 | 1420375 | 2021-06-15 | Autauga | Alabama | 1001 | 7230 | 113 |
1314201 | 1314201 | 2021-05-13 | Leavenworth | Kansas | 20103 | 7230 | 91 |
1310954 | 1310954 | 2021-05-12 | Leavenworth | Kansas | 20103 | 7230 | 91 |
1277882 | 1277882 | 2021-05-02 | Flagler | Florida | 12035 | 7230 | 111 |
1269254 | 1269254 | 2021-04-29 | Lauderdale | Mississippi | 28075 | 7230 | 240 |
1209887 | 1209887 | 2021-04-11 | Walker | Georgia | 13295 | 7230 | 85 |
1206893 | 1206893 | 2021-04-10 | Wayne | Indiana | 18177 | 7230 | 200 |
1179150 | 1179150 | 2021-04-01 | Clearfield | Pennsylvania | 42033 | 7230 | 129 |
1176847 | 1176847 | 2021-03-31 | Wood | Wisconsin | 55141 | 7230 | 90 |
1150688 | 1150688 | 2021-03-23 | Suffolk city | Virginia | 51800 | 7230 | 174 |
1098138 | 1098138 | 2021-03-07 | Greenwood | South Carolina | 45047 | 7230 | 159 |
1073327 | 1073327 | 2021-02-28 | Highlands | Florida | 12055 | 7230 | 307 |
942252 | 942252 | 2021-01-18 | Carolina | Puerto Rico | 72031 | 7230 | |
878595 | 878595 | 2020-12-30 | Hernando | Florida | 12053 | 7230 | 275 |
869259 | 869259 | 2020-12-27 | LaPorte | Indiana | 18091 | 7230 | 130 |
863477 | 863477 | 2020-12-25 | Lee | Mississippi | 28081 | 7230 | 111 |
860573 | 860573 | 2020-12-24 | Cumberland | New Jersey | 34011 | 7230 | 208 |
565663 | 565663 | 2020-09-24 | Lucas | Ohio | 39095 | 7230 | 364 |
216445 | 216445 | 2020-06-07 | Orleans | Louisiana | 22071 | 7230 | 512 |
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);