ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 7446 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499301 | 2499301 | 2022-05-12 | Gloucester | Virginia | 51073 | 7446 | 104 |
2492134 | 2492134 | 2022-05-10 | Warren | Pennsylvania | 42123 | 7446 | 210 |
2488876 | 2488876 | 2022-05-09 | Warren | Pennsylvania | 42123 | 7446 | 210 |
2485619 | 2485619 | 2022-05-08 | Warren | Pennsylvania | 42123 | 7446 | 210 |
2482361 | 2482361 | 2022-05-07 | Warren | Pennsylvania | 42123 | 7446 | 210 |
2479103 | 2479103 | 2022-05-06 | Warren | Pennsylvania | 42123 | 7446 | 210 |
2475845 | 2475845 | 2022-05-05 | Warren | Pennsylvania | 42123 | 7446 | 210 |
2472588 | 2472588 | 2022-05-04 | Warren | Pennsylvania | 42123 | 7446 | 210 |
2358453 | 2358453 | 2022-03-30 | Pike | Ohio | 39131 | 7446 | 116 |
2355199 | 2355199 | 2022-03-29 | Pike | Ohio | 39131 | 7446 | 116 |
2356011 | 2356011 | 2022-03-29 | Botetourt | Virginia | 51023 | 7446 | 95 |
2351946 | 2351946 | 2022-03-28 | Pike | Ohio | 39131 | 7446 | 116 |
2348694 | 2348694 | 2022-03-27 | Pike | Ohio | 39131 | 7446 | 116 |
2345441 | 2345441 | 2022-03-26 | Pike | Ohio | 39131 | 7446 | 116 |
2342188 | 2342188 | 2022-03-25 | Pike | Ohio | 39131 | 7446 | 116 |
2338935 | 2338935 | 2022-03-24 | Pike | Ohio | 39131 | 7446 | 116 |
2334224 | 2334224 | 2022-03-23 | Perry | Illinois | 17145 | 7446 | 107 |
2299860 | 2299860 | 2022-03-12 | Gallia | Ohio | 39053 | 7446 | 121 |
2259462 | 2259462 | 2022-02-28 | Daviess | Indiana | 18027 | 7446 | 149 |
2211838 | 2211838 | 2022-02-13 | Delaware | New York | 36025 | 7446 | 68 |
2198009 | 2198009 | 2022-02-09 | Grayson | Kentucky | 21085 | 7446 | 114 |
2193194 | 2193194 | 2022-02-07 | Hockley | Texas | 48219 | 7446 | 154 |
2175218 | 2175218 | 2022-02-02 | Carter | Kentucky | 21043 | 7446 | 91 |
2172065 | 2172065 | 2022-02-01 | Allen | Louisiana | 22003 | 7446 | 123 |
2026704 | 2026704 | 2021-12-18 | Guernsey | Ohio | 39059 | 7446 | 93 |
1964804 | 1964804 | 2021-11-29 | Hoke | North Carolina | 37093 | 7446 | 86 |
1926379 | 1926379 | 2021-11-17 | Campbell | Tennessee | 47013 | 7446 | 88 |
1876354 | 1876354 | 2021-11-02 | Branch | Michigan | 26023 | 7446 | 137 |
1876919 | 1876919 | 2021-11-02 | Curry | New Mexico | 35009 | 7446 | 120 |
1873105 | 1873105 | 2021-11-01 | Branch | Michigan | 26023 | 7446 | 137 |
1854491 | 1854491 | 2021-10-26 | Seneca | Ohio | 39147 | 7446 | 146 |
1810656 | 1810656 | 2021-10-13 | Ware | Georgia | 13299 | 7446 | 240 |
1762718 | 1762718 | 2021-09-28 | Chisago | Minnesota | 27025 | 7446 | 58 |
1700635 | 1700635 | 2021-09-09 | Saline | Kansas | 20169 | 7446 | 160 |
1697386 | 1697386 | 2021-09-08 | Saline | Kansas | 20169 | 7446 | 160 |
1607997 | 1607997 | 2021-08-11 | Cumberland | Tennessee | 47035 | 7446 | 145 |
1403511 | 1403511 | 2021-06-09 | Tipton | Tennessee | 47167 | 7446 | 104 |
1326941 | 1326941 | 2021-05-17 | Williamson | Illinois | 17199 | 7446 | 142 |
1324875 | 1324875 | 2021-05-16 | Oswego | New York | 36075 | 7446 | 90 |
1322047 | 1322047 | 2021-05-15 | Lawrence | Pennsylvania | 42073 | 7446 | 207 |
1286019 | 1286019 | 2021-05-04 | Rockingham | North Carolina | 37157 | 7446 | 106 |
1177595 | 1177595 | 2021-04-01 | Floyd | Indiana | 18043 | 7446 | 179 |
1176774 | 1176774 | 2021-03-31 | Wood | West Virginia | 54107 | 7446 | 164 |
1023269 | 1023269 | 2021-02-12 | Wagoner | Oklahoma | 40145 | 7446 | 76 |
1010278 | 1010278 | 2021-02-08 | Pottawatomie | Oklahoma | 40125 | 7446 | 59 |
987465 | 987465 | 2021-02-01 | Muskingum | Ohio | 39119 | 7446 | 42 |
975688 | 975688 | 2021-01-29 | Matanuska-Susitna Borough | Alaska | 2170 | 7446 | 27 |
919390 | 919390 | 2021-01-11 | Muskogee | Oklahoma | 40101 | 7446 | 56 |
919905 | 919905 | 2021-01-11 | Gregg | Texas | 48183 | 7446 | 199 |
916660 | 916660 | 2021-01-10 | Gregg | Texas | 48183 | 7446 | 197 |
913415 | 913415 | 2021-01-09 | Gregg | Texas | 48183 | 7446 | 193 |
910170 | 910170 | 2021-01-08 | Gregg | Texas | 48183 | 7446 | 188 |
900988 | 900988 | 2021-01-06 | Cullman | Alabama | 1043 | 7446 | 78 |
877116 | 877116 | 2020-12-29 | Miami | Ohio | 39109 | 7446 | 73 |
860652 | 860652 | 2020-12-24 | Niagara | New York | 36063 | 7446 | 166 |
834030 | 834030 | 2020-12-16 | Harford | Maryland | 24025 | 7446 | 126 |
835565 | 835565 | 2020-12-16 | Kaufman | Texas | 48257 | 7446 | 101 |
805230 | 805230 | 2020-12-07 | Flathead | Montana | 30029 | 7446 | 39 |
774496 | 774496 | 2020-11-28 | Coconino | Arizona | 4005 | 7446 | 170 |
747322 | 747322 | 2020-11-19 | Stark | Ohio | 39151 | 7446 | 195 |
711003 | 711003 | 2020-11-08 | Boone | Missouri | 29019 | 7446 | 18 |
653921 | 653921 | 2020-10-21 | Potter | Texas | 48375 | 7446 | 96 |
626322 | 626322 | 2020-10-13 | St. Tammany | Louisiana | 22103 | 7446 | 269 |
497377 | 497377 | 2020-09-03 | Washoe | Nevada | 32031 | 7446 | 142 |
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);