ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
236 rows where deaths = 575 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Louisiana 32
- Michigan 31
- South Carolina 19
- Pennsylvania 16
- Texas 15
- Missouri 12
- Ohio 12
- Florida 11
- Illinois 10
- Alabama 8
- Georgia 8
- Indiana 7
- New Jersey 7
- Massachusetts 5
- New Hampshire 5
- New Mexico 5
- Maryland 4
- Mississippi 4
- Arizona 3
- California 3
- New York 3
- Oregon 3
- Colorado 2
- Delaware 2
- Idaho 2
- Washington 2
- Arkansas 1
- Iowa 1
- Tennessee 1
- Virginia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500833 | 2500833 | 2022-05-13 | Calhoun | Michigan | 26025 | 35011 | 575 |
2497575 | 2497575 | 2022-05-12 | Calhoun | Michigan | 26025 | 35011 | 575 |
2494317 | 2494317 | 2022-05-11 | Calhoun | Michigan | 26025 | 35011 | 575 |
2491059 | 2491059 | 2022-05-10 | Calhoun | Michigan | 26025 | 34687 | 575 |
2487802 | 2487802 | 2022-05-09 | Calhoun | Michigan | 26025 | 34687 | 575 |
2484544 | 2484544 | 2022-05-08 | Calhoun | Michigan | 26025 | 34687 | 575 |
2481286 | 2481286 | 2022-05-07 | Calhoun | Michigan | 26025 | 34687 | 575 |
2478028 | 2478028 | 2022-05-06 | Calhoun | Michigan | 26025 | 34687 | 575 |
2474770 | 2474770 | 2022-05-05 | Calhoun | Michigan | 26025 | 34687 | 575 |
2471513 | 2471513 | 2022-05-04 | Calhoun | Michigan | 26025 | 34687 | 575 |
2442115 | 2442115 | 2022-04-25 | Rapides | Louisiana | 22079 | 32734 | 575 |
2438859 | 2438859 | 2022-04-24 | Rapides | Louisiana | 22079 | 32730 | 575 |
2435603 | 2435603 | 2022-04-23 | Rapides | Louisiana | 22079 | 32730 | 575 |
2432347 | 2432347 | 2022-04-22 | Rapides | Louisiana | 22079 | 32730 | 575 |
2429091 | 2429091 | 2022-04-21 | Rapides | Louisiana | 22079 | 32730 | 575 |
2425835 | 2425835 | 2022-04-20 | Rapides | Louisiana | 22079 | 32730 | 575 |
2422579 | 2422579 | 2022-04-19 | Rapides | Louisiana | 22079 | 32727 | 575 |
2422674 | 2422674 | 2022-04-19 | Calhoun | Michigan | 26025 | 34219 | 575 |
2419323 | 2419323 | 2022-04-18 | Rapides | Louisiana | 22079 | 32724 | 575 |
2419418 | 2419418 | 2022-04-18 | Calhoun | Michigan | 26025 | 34219 | 575 |
2416067 | 2416067 | 2022-04-17 | Rapides | Louisiana | 22079 | 32724 | 575 |
2416162 | 2416162 | 2022-04-17 | Calhoun | Michigan | 26025 | 34219 | 575 |
2412811 | 2412811 | 2022-04-16 | Rapides | Louisiana | 22079 | 32724 | 575 |
2412906 | 2412906 | 2022-04-16 | Calhoun | Michigan | 26025 | 34219 | 575 |
2409555 | 2409555 | 2022-04-15 | Rapides | Louisiana | 22079 | 32724 | 575 |
2409650 | 2409650 | 2022-04-15 | Calhoun | Michigan | 26025 | 34219 | 575 |
2406299 | 2406299 | 2022-04-14 | Rapides | Louisiana | 22079 | 32724 | 575 |
2406354 | 2406354 | 2022-04-14 | Harford | Maryland | 24025 | 38333 | 575 |
2406394 | 2406394 | 2022-04-14 | Calhoun | Michigan | 26025 | 34219 | 575 |
2403043 | 2403043 | 2022-04-13 | Rapides | Louisiana | 22079 | 32723 | 575 |
2403098 | 2403098 | 2022-04-13 | Harford | Maryland | 24025 | 38313 | 575 |
2403138 | 2403138 | 2022-04-13 | Calhoun | Michigan | 26025 | 34219 | 575 |
2399789 | 2399789 | 2022-04-12 | Rapides | Louisiana | 22079 | 32719 | 575 |
2399884 | 2399884 | 2022-04-12 | Calhoun | Michigan | 26025 | 34155 | 575 |
2396533 | 2396533 | 2022-04-11 | Rapides | Louisiana | 22079 | 32719 | 575 |
2396628 | 2396628 | 2022-04-11 | Calhoun | Michigan | 26025 | 34155 | 575 |
2393278 | 2393278 | 2022-04-10 | Rapides | Louisiana | 22079 | 32718 | 575 |
2393373 | 2393373 | 2022-04-10 | Calhoun | Michigan | 26025 | 34155 | 575 |
2390022 | 2390022 | 2022-04-09 | Rapides | Louisiana | 22079 | 32718 | 575 |
2390117 | 2390117 | 2022-04-09 | Calhoun | Michigan | 26025 | 34155 | 575 |
2386766 | 2386766 | 2022-04-08 | Rapides | Louisiana | 22079 | 32718 | 575 |
2386861 | 2386861 | 2022-04-08 | Calhoun | Michigan | 26025 | 34155 | 575 |
2383511 | 2383511 | 2022-04-07 | Rapides | Louisiana | 22079 | 32716 | 575 |
2383606 | 2383606 | 2022-04-07 | Calhoun | Michigan | 26025 | 34155 | 575 |
2380256 | 2380256 | 2022-04-06 | Rapides | Louisiana | 22079 | 32715 | 575 |
2380324 | 2380324 | 2022-04-06 | Barnstable | Massachusetts | 25001 | 35000 | 575 |
2380351 | 2380351 | 2022-04-06 | Calhoun | Michigan | 26025 | 34155 | 575 |
2381173 | 2381173 | 2022-04-06 | Clark | Ohio | 39023 | 34930 | 575 |
2377001 | 2377001 | 2022-04-05 | Rapides | Louisiana | 22079 | 32713 | 575 |
2377918 | 2377918 | 2022-04-05 | Clark | Ohio | 39023 | 34930 | 575 |
2373749 | 2373749 | 2022-04-04 | Rapides | Louisiana | 22079 | 32710 | 575 |
2373817 | 2373817 | 2022-04-04 | Barnstable | Massachusetts | 25001 | 34940 | 575 |
2374664 | 2374664 | 2022-04-04 | Clark | Ohio | 39023 | 34930 | 575 |
2370496 | 2370496 | 2022-04-03 | Rapides | Louisiana | 22079 | 32710 | 575 |
2371412 | 2371412 | 2022-04-03 | Clark | Ohio | 39023 | 34930 | 575 |
2367243 | 2367243 | 2022-04-02 | Rapides | Louisiana | 22079 | 32710 | 575 |
2368159 | 2368159 | 2022-04-02 | Clark | Ohio | 39023 | 34930 | 575 |
2363990 | 2363990 | 2022-04-01 | Rapides | Louisiana | 22079 | 32710 | 575 |
2364906 | 2364906 | 2022-04-01 | Clark | Ohio | 39023 | 34930 | 575 |
2360736 | 2360736 | 2022-03-31 | Rapides | Louisiana | 22079 | 32708 | 575 |
2361653 | 2361653 | 2022-03-31 | Clark | Ohio | 39023 | 34930 | 575 |
2357482 | 2357482 | 2022-03-30 | Rapides | Louisiana | 22079 | 32708 | 575 |
2354229 | 2354229 | 2022-03-29 | Rapides | Louisiana | 22079 | 32704 | 575 |
2354320 | 2354320 | 2022-03-29 | Bay | Michigan | 26017 | 26970 | 575 |
2351068 | 2351068 | 2022-03-28 | Bay | Michigan | 26017 | 26970 | 575 |
2347815 | 2347815 | 2022-03-27 | Bay | Michigan | 26017 | 26963 | 575 |
2344562 | 2344562 | 2022-03-26 | Bay | Michigan | 26017 | 26963 | 575 |
2341309 | 2341309 | 2022-03-25 | Bay | Michigan | 26017 | 26963 | 575 |
2342756 | 2342756 | 2022-03-25 | Ellis | Texas | 48139 | 48636 | 575 |
2338056 | 2338056 | 2022-03-24 | Bay | Michigan | 26017 | 26959 | 575 |
2339503 | 2339503 | 2022-03-24 | Ellis | Texas | 48139 | 48631 | 575 |
2334802 | 2334802 | 2022-03-23 | Bay | Michigan | 26017 | 26959 | 575 |
2336249 | 2336249 | 2022-03-23 | Ellis | Texas | 48139 | 48617 | 575 |
2325625 | 2325625 | 2022-03-20 | McKinley | New Mexico | 35031 | 25692 | 575 |
2322371 | 2322371 | 2022-03-19 | McKinley | New Mexico | 35031 | 25680 | 575 |
2319117 | 2319117 | 2022-03-18 | McKinley | New Mexico | 35031 | 25680 | 575 |
2315864 | 2315864 | 2022-03-17 | McKinley | New Mexico | 35031 | 25680 | 575 |
2312611 | 2312611 | 2022-03-16 | McKinley | New Mexico | 35031 | 25669 | 575 |
2292491 | 2292491 | 2022-03-10 | Washington | Maryland | 24043 | 34907 | 575 |
2262580 | 2262580 | 2022-03-01 | Kootenai | Idaho | 16055 | 38851 | 575 |
2255911 | 2255911 | 2022-02-27 | Cherokee | Georgia | 13057 | 62873 | 575 |
2252660 | 2252660 | 2022-02-26 | Cherokee | Georgia | 13057 | 62873 | 575 |
2249409 | 2249409 | 2022-02-25 | Cherokee | Georgia | 13057 | 62873 | 575 |
2247538 | 2247538 | 2022-02-24 | Cumberland | New Jersey | 34011 | 38485 | 575 |
2226241 | 2226241 | 2022-02-18 | Calhoun | Alabama | 1015 | 31354 | 575 |
2218945 | 2218945 | 2022-02-15 | York | South Carolina | 45091 | 76129 | 575 |
2197060 | 2197060 | 2022-02-09 | Apache | Arizona | 4001 | 21151 | 575 |
2192731 | 2192731 | 2022-02-07 | Blair | Pennsylvania | 42013 | 28497 | 575 |
2189477 | 2189477 | 2022-02-06 | Blair | Pennsylvania | 42013 | 28415 | 575 |
2186224 | 2186224 | 2022-02-05 | Blair | Pennsylvania | 42013 | 28360 | 575 |
2153709 | 2153709 | 2022-01-26 | Fayette | Pennsylvania | 42051 | 27924 | 575 |
2150419 | 2150419 | 2022-01-25 | Marion | Oregon | 41047 | 58210 | 575 |
2145665 | 2145665 | 2022-01-24 | Madison | Indiana | 18095 | 30368 | 575 |
2142410 | 2142410 | 2022-01-23 | Madison | Indiana | 18095 | 29339 | 575 |
2139155 | 2139155 | 2022-01-22 | Madison | Indiana | 18095 | 29339 | 575 |
2135899 | 2135899 | 2022-01-21 | Madison | Indiana | 18095 | 29339 | 575 |
2126827 | 2126827 | 2022-01-18 | Harrison | Mississippi | 28047 | 42914 | 575 |
2102979 | 2102979 | 2022-01-11 | Indian River | Florida | 12061 | 24748 | 575 |
2099728 | 2099728 | 2022-01-10 | Indian River | Florida | 12061 | 24748 | 575 |
2096353 | 2096353 | 2022-01-09 | Santa Barbara | California | 6083 | 56574 | 575 |
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);