ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
203 rows where deaths = 572 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Maryland 29
- Florida 23
- Pennsylvania 20
- Indiana 11
- New York 10
- Oregon 9
- Ohio 8
- Virginia 8
- Louisiana 7
- Missouri 7
- New Mexico 7
- Michigan 6
- North Carolina 6
- Texas 6
- Arizona 5
- California 5
- Georgia 5
- South Carolina 5
- New Jersey 4
- Arkansas 3
- Minnesota 3
- Illinois 2
- Iowa 2
- Massachusetts 2
- Mississippi 2
- Alabama 1
- Colorado 1
- Delaware 1
- Idaho 1
- Kansas 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467381 | 2467381 | 2022-05-03 | Sumter | Florida | 12119 | 21960 | 572 |
2464126 | 2464126 | 2022-05-02 | Sumter | Florida | 12119 | 21960 | 572 |
2460870 | 2460870 | 2022-05-01 | Sumter | Florida | 12119 | 21960 | 572 |
2457614 | 2457614 | 2022-04-30 | Sumter | Florida | 12119 | 21960 | 572 |
2454358 | 2454358 | 2022-04-29 | Sumter | Florida | 12119 | 21960 | 572 |
2451102 | 2451102 | 2022-04-28 | Sumter | Florida | 12119 | 21960 | 572 |
2447846 | 2447846 | 2022-04-27 | Sumter | Florida | 12119 | 21960 | 572 |
2444590 | 2444590 | 2022-04-26 | Sumter | Florida | 12119 | 21960 | 572 |
2441334 | 2441334 | 2022-04-25 | Sumter | Florida | 12119 | 21960 | 572 |
2438078 | 2438078 | 2022-04-24 | Sumter | Florida | 12119 | 21960 | 572 |
2434822 | 2434822 | 2022-04-23 | Sumter | Florida | 12119 | 21960 | 572 |
2431566 | 2431566 | 2022-04-22 | Sumter | Florida | 12119 | 21960 | 572 |
2428310 | 2428310 | 2022-04-21 | Sumter | Florida | 12119 | 21747 | 572 |
2425054 | 2425054 | 2022-04-20 | Sumter | Florida | 12119 | 21747 | 572 |
2421798 | 2421798 | 2022-04-19 | Sumter | Florida | 12119 | 21747 | 572 |
2418542 | 2418542 | 2022-04-18 | Sumter | Florida | 12119 | 21747 | 572 |
2415286 | 2415286 | 2022-04-17 | Sumter | Florida | 12119 | 21747 | 572 |
2412030 | 2412030 | 2022-04-16 | Sumter | Florida | 12119 | 21747 | 572 |
2408774 | 2408774 | 2022-04-15 | Sumter | Florida | 12119 | 21747 | 572 |
2405518 | 2405518 | 2022-04-14 | Sumter | Florida | 12119 | 21747 | 572 |
2407018 | 2407018 | 2022-04-14 | Niagara | New York | 36063 | 48277 | 572 |
2402263 | 2402263 | 2022-04-13 | Sumter | Florida | 12119 | 21747 | 572 |
2403762 | 2403762 | 2022-04-13 | Niagara | New York | 36063 | 48207 | 572 |
2400507 | 2400507 | 2022-04-12 | Niagara | New York | 36063 | 48157 | 572 |
2397252 | 2397252 | 2022-04-11 | Niagara | New York | 36063 | 48109 | 572 |
2393997 | 2393997 | 2022-04-10 | Niagara | New York | 36063 | 48061 | 572 |
2390741 | 2390741 | 2022-04-09 | Niagara | New York | 36063 | 48020 | 572 |
2370551 | 2370551 | 2022-04-03 | Harford | Maryland | 24025 | 38156 | 572 |
2367298 | 2367298 | 2022-04-02 | Harford | Maryland | 24025 | 38156 | 572 |
2364045 | 2364045 | 2022-04-01 | Harford | Maryland | 24025 | 38156 | 572 |
2360791 | 2360791 | 2022-03-31 | Harford | Maryland | 24025 | 38141 | 572 |
2357537 | 2357537 | 2022-03-30 | Harford | Maryland | 24025 | 38127 | 572 |
2354284 | 2354284 | 2022-03-29 | Harford | Maryland | 24025 | 38119 | 572 |
2351032 | 2351032 | 2022-03-28 | Harford | Maryland | 24025 | 38111 | 572 |
2347779 | 2347779 | 2022-03-27 | Harford | Maryland | 24025 | 38105 | 572 |
2348798 | 2348798 | 2022-03-27 | Clackamas | Oregon | 41005 | 59788 | 572 |
2344526 | 2344526 | 2022-03-26 | Harford | Maryland | 24025 | 38095 | 572 |
2345545 | 2345545 | 2022-03-26 | Clackamas | Oregon | 41005 | 59788 | 572 |
2341273 | 2341273 | 2022-03-25 | Harford | Maryland | 24025 | 38079 | 572 |
2342292 | 2342292 | 2022-03-25 | Clackamas | Oregon | 41005 | 59788 | 572 |
2337965 | 2337965 | 2022-03-24 | Rapides | Louisiana | 22079 | 32696 | 572 |
2338020 | 2338020 | 2022-03-24 | Harford | Maryland | 24025 | 38064 | 572 |
2339039 | 2339039 | 2022-03-24 | Clackamas | Oregon | 41005 | 59771 | 572 |
2334711 | 2334711 | 2022-03-23 | Rapides | Louisiana | 22079 | 32690 | 572 |
2334766 | 2334766 | 2022-03-23 | Harford | Maryland | 24025 | 38050 | 572 |
2331457 | 2331457 | 2022-03-22 | Rapides | Louisiana | 22079 | 32685 | 572 |
2331512 | 2331512 | 2022-03-22 | Harford | Maryland | 24025 | 38049 | 572 |
2328205 | 2328205 | 2022-03-21 | Rapides | Louisiana | 22079 | 32680 | 572 |
2328260 | 2328260 | 2022-03-21 | Harford | Maryland | 24025 | 38041 | 572 |
2325007 | 2325007 | 2022-03-20 | Harford | Maryland | 24025 | 38037 | 572 |
2325043 | 2325043 | 2022-03-20 | Bay | Michigan | 26017 | 26952 | 572 |
2321753 | 2321753 | 2022-03-19 | Harford | Maryland | 24025 | 38032 | 572 |
2321789 | 2321789 | 2022-03-19 | Bay | Michigan | 26017 | 26952 | 572 |
2318499 | 2318499 | 2022-03-18 | Harford | Maryland | 24025 | 38020 | 572 |
2318535 | 2318535 | 2022-03-18 | Bay | Michigan | 26017 | 26952 | 572 |
2315246 | 2315246 | 2022-03-17 | Harford | Maryland | 24025 | 37997 | 572 |
2311993 | 2311993 | 2022-03-16 | Harford | Maryland | 24025 | 37982 | 572 |
2308740 | 2308740 | 2022-03-15 | Harford | Maryland | 24025 | 37972 | 572 |
2305489 | 2305489 | 2022-03-14 | Harford | Maryland | 24025 | 37959 | 572 |
2306105 | 2306105 | 2022-03-14 | McKinley | New Mexico | 35031 | 25657 | 572 |
2302237 | 2302237 | 2022-03-13 | Harford | Maryland | 24025 | 37951 | 572 |
2302854 | 2302854 | 2022-03-13 | McKinley | New Mexico | 35031 | 25642 | 572 |
2298985 | 2298985 | 2022-03-12 | Harford | Maryland | 24025 | 37938 | 572 |
2299602 | 2299602 | 2022-03-12 | McKinley | New Mexico | 35031 | 25642 | 572 |
2296350 | 2296350 | 2022-03-11 | McKinley | New Mexico | 35031 | 25642 | 572 |
2293098 | 2293098 | 2022-03-10 | McKinley | New Mexico | 35031 | 25633 | 572 |
2282736 | 2282736 | 2022-03-07 | Washington | Maryland | 24043 | 34891 | 572 |
2284207 | 2284207 | 2022-03-07 | Ellis | Texas | 48139 | 48398 | 572 |
2279483 | 2279483 | 2022-03-06 | Washington | Maryland | 24043 | 34888 | 572 |
2280955 | 2280955 | 2022-03-06 | Ellis | Texas | 48139 | 48393 | 572 |
2276230 | 2276230 | 2022-03-05 | Washington | Maryland | 24043 | 34885 | 572 |
2242706 | 2242706 | 2022-02-23 | Placer | California | 6061 | 68800 | 572 |
2239455 | 2239455 | 2022-02-22 | Placer | California | 6061 | 68818 | 572 |
2194029 | 2194029 | 2022-02-08 | Kent | Delaware | 10001 | 48552 | 572 |
2196429 | 2196429 | 2022-02-08 | Grayson | Texas | 48181 | 26669 | 572 |
2190552 | 2190552 | 2022-02-07 | Apache | Arizona | 4001 | 21063 | 572 |
2187299 | 2187299 | 2022-02-06 | Apache | Arizona | 4001 | 21010 | 572 |
2184046 | 2184046 | 2022-02-05 | Apache | Arizona | 4001 | 20951 | 572 |
2179720 | 2179720 | 2022-02-03 | Blair | Pennsylvania | 42013 | 28085 | 572 |
2176469 | 2176469 | 2022-02-02 | Blair | Pennsylvania | 42013 | 27987 | 572 |
2171687 | 2171687 | 2022-02-01 | Johnson | Indiana | 18081 | 41133 | 572 |
2173215 | 2173215 | 2022-02-01 | Blair | Pennsylvania | 42013 | 27851 | 572 |
2153746 | 2153746 | 2022-01-26 | Washington | Pennsylvania | 42125 | 47006 | 572 |
2137440 | 2137440 | 2022-01-21 | Fayette | Pennsylvania | 42051 | 26961 | 572 |
2122869 | 2122869 | 2022-01-17 | Hamilton | Indiana | 18057 | 70766 | 572 |
2110568 | 2110568 | 2022-01-13 | Harrison | Mississippi | 28047 | 40700 | 572 |
2107317 | 2107317 | 2022-01-12 | Harrison | Mississippi | 28047 | 40147 | 572 |
2101669 | 2101669 | 2022-01-10 | Franklin | Pennsylvania | 42055 | 32689 | 572 |
2101695 | 2101695 | 2022-01-10 | Schuylkill | Pennsylvania | 42107 | 28294 | 572 |
2033382 | 2033382 | 2021-12-20 | Beaver | Pennsylvania | 42007 | 28558 | 572 |
2030132 | 2030132 | 2021-12-19 | Beaver | Pennsylvania | 42007 | 28516 | 572 |
2023661 | 2023661 | 2021-12-17 | Lackawanna | Pennsylvania | 42069 | 27529 | 572 |
2016681 | 2016681 | 2021-12-15 | Doña Ana | New Mexico | 35013 | 39295 | 572 |
2000880 | 2000880 | 2021-12-10 | Butler | Pennsylvania | 42019 | 30332 | 572 |
1989576 | 1989576 | 2021-12-07 | Elkhart | Indiana | 18039 | 40877 | 572 |
1987878 | 1987878 | 2021-12-06 | Cambria | Pennsylvania | 42021 | 23225 | 572 |
1973915 | 1973915 | 2021-12-02 | Ottawa | Michigan | 26139 | 50068 | 572 |
1975415 | 1975415 | 2021-12-02 | Potter | Texas | 48375 | 25231 | 572 |
1970666 | 1970666 | 2021-12-01 | Ottawa | Michigan | 26139 | 50068 | 572 |
1969056 | 1969056 | 2021-11-30 | Chesterfield | Virginia | 51041 | 41511 | 572 |
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);