ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
196 rows where deaths = 580 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 23
- South Carolina 19
- Maryland 17
- Ohio 14
- Texas 11
- Illinois 8
- Arizona 7
- Iowa 7
- Kentucky 7
- New Jersey 7
- New York 7
- Pennsylvania 7
- Colorado 6
- Georgia 6
- Indiana 6
- Louisiana 6
- Arkansas 5
- Michigan 5
- Missouri 4
- Alabama 3
- Tennessee 3
- Virginia 3
- Washington 3
- California 2
- District of Columbia 2
- Kansas 1
- Massachusetts 1
- Nevada 1
- New Hampshire 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488425 | 2488425 | 2022-05-09 | Niagara | New York | 36063 | 50610 | 580 |
2484504 | 2484504 | 2022-05-08 | Harford | Maryland | 24025 | 39055 | 580 |
2485168 | 2485168 | 2022-05-08 | Niagara | New York | 36063 | 50521 | 580 |
2481246 | 2481246 | 2022-05-07 | Harford | Maryland | 24025 | 39055 | 580 |
2481910 | 2481910 | 2022-05-07 | Niagara | New York | 36063 | 50421 | 580 |
2477988 | 2477988 | 2022-05-06 | Harford | Maryland | 24025 | 39055 | 580 |
2478652 | 2478652 | 2022-05-06 | Niagara | New York | 36063 | 50288 | 580 |
2474730 | 2474730 | 2022-05-05 | Harford | Maryland | 24025 | 39000 | 580 |
2471473 | 2471473 | 2022-05-04 | Harford | Maryland | 24025 | 38933 | 580 |
2468217 | 2468217 | 2022-05-03 | Harford | Maryland | 24025 | 38886 | 580 |
2464962 | 2464962 | 2022-05-02 | Harford | Maryland | 24025 | 38815 | 580 |
2461706 | 2461706 | 2022-05-01 | Harford | Maryland | 24025 | 38772 | 580 |
2458450 | 2458450 | 2022-04-30 | Harford | Maryland | 24025 | 38772 | 580 |
2455194 | 2455194 | 2022-04-29 | Harford | Maryland | 24025 | 38772 | 580 |
2451938 | 2451938 | 2022-04-28 | Harford | Maryland | 24025 | 38726 | 580 |
2448682 | 2448682 | 2022-04-27 | Harford | Maryland | 24025 | 38681 | 580 |
2445062 | 2445062 | 2022-04-26 | Linn | Iowa | 19113 | 52302 | 580 |
2445426 | 2445426 | 2022-04-26 | Harford | Maryland | 24025 | 38654 | 580 |
2441806 | 2441806 | 2022-04-25 | Linn | Iowa | 19113 | 52302 | 580 |
2442170 | 2442170 | 2022-04-25 | Harford | Maryland | 24025 | 38580 | 580 |
2438550 | 2438550 | 2022-04-24 | Linn | Iowa | 19113 | 52302 | 580 |
2435294 | 2435294 | 2022-04-23 | Linn | Iowa | 19113 | 52302 | 580 |
2432038 | 2432038 | 2022-04-22 | Linn | Iowa | 19113 | 52302 | 580 |
2428782 | 2428782 | 2022-04-21 | Linn | Iowa | 19113 | 52302 | 580 |
2425526 | 2425526 | 2022-04-20 | Linn | Iowa | 19113 | 52302 | 580 |
2403960 | 2403960 | 2022-04-13 | Clark | Ohio | 39023 | 34938 | 580 |
2400705 | 2400705 | 2022-04-12 | Clark | Ohio | 39023 | 34938 | 580 |
2401327 | 2401327 | 2022-04-12 | Ellis | Texas | 48139 | 48782 | 580 |
2397450 | 2397450 | 2022-04-11 | Clark | Ohio | 39023 | 34938 | 580 |
2398072 | 2398072 | 2022-04-11 | Ellis | Texas | 48139 | 48777 | 580 |
2394195 | 2394195 | 2022-04-10 | Clark | Ohio | 39023 | 34938 | 580 |
2394817 | 2394817 | 2022-04-10 | Ellis | Texas | 48139 | 48774 | 580 |
2390939 | 2390939 | 2022-04-09 | Clark | Ohio | 39023 | 34938 | 580 |
2391561 | 2391561 | 2022-04-09 | Ellis | Texas | 48139 | 48772 | 580 |
2387683 | 2387683 | 2022-04-08 | Clark | Ohio | 39023 | 34938 | 580 |
2384428 | 2384428 | 2022-04-07 | Clark | Ohio | 39023 | 34938 | 580 |
2377121 | 2377121 | 2022-04-05 | Jackson | Michigan | 26075 | 44521 | 580 |
2373869 | 2373869 | 2022-04-04 | Jackson | Michigan | 26075 | 44521 | 580 |
2370370 | 2370370 | 2022-04-03 | Fayette | Kentucky | 21067 | 94442 | 580 |
2370616 | 2370616 | 2022-04-03 | Jackson | Michigan | 26075 | 44521 | 580 |
2367117 | 2367117 | 2022-04-02 | Fayette | Kentucky | 21067 | 94442 | 580 |
2367363 | 2367363 | 2022-04-02 | Jackson | Michigan | 26075 | 44521 | 580 |
2363864 | 2363864 | 2022-04-01 | Fayette | Kentucky | 21067 | 94442 | 580 |
2364110 | 2364110 | 2022-04-01 | Jackson | Michigan | 26075 | 44521 | 580 |
2360610 | 2360610 | 2022-03-31 | Fayette | Kentucky | 21067 | 94442 | 580 |
2357356 | 2357356 | 2022-03-30 | Fayette | Kentucky | 21067 | 94442 | 580 |
2358155 | 2358155 | 2022-03-30 | McKinley | New Mexico | 35031 | 25761 | 580 |
2354103 | 2354103 | 2022-03-29 | Fayette | Kentucky | 21067 | 94442 | 580 |
2350851 | 2350851 | 2022-03-28 | Fayette | Kentucky | 21067 | 94442 | 580 |
2351042 | 2351042 | 2022-03-28 | Washington | Maryland | 24043 | 35037 | 580 |
2286560 | 2286560 | 2022-03-08 | Cumberland | New Jersey | 34011 | 39027 | 580 |
2259162 | 2259162 | 2022-02-28 | Cherokee | Georgia | 13057 | 62920 | 580 |
2244946 | 2244946 | 2022-02-23 | Pickens | South Carolina | 45077 | 45495 | 580 |
2239602 | 2239602 | 2022-02-22 | Martin | Florida | 12085 | 30826 | 580 |
2241695 | 2241695 | 2022-02-22 | Pickens | South Carolina | 45077 | 45484 | 580 |
2236351 | 2236351 | 2022-02-21 | Martin | Florida | 12085 | 30826 | 580 |
2233100 | 2233100 | 2022-02-20 | Martin | Florida | 12085 | 30826 | 580 |
2229849 | 2229849 | 2022-02-19 | Martin | Florida | 12085 | 30826 | 580 |
2226598 | 2226598 | 2022-02-18 | Martin | Florida | 12085 | 30826 | 580 |
2223079 | 2223079 | 2022-02-17 | Apache | Arizona | 4001 | 21578 | 580 |
2223347 | 2223347 | 2022-02-17 | Martin | Florida | 12085 | 30639 | 580 |
2220096 | 2220096 | 2022-02-16 | Martin | Florida | 12085 | 30639 | 580 |
2222196 | 2222196 | 2022-02-16 | York | South Carolina | 45091 | 76224 | 580 |
2217226 | 2217226 | 2022-02-15 | Johnson | Indiana | 18081 | 41944 | 580 |
2206190 | 2206190 | 2022-02-11 | Grayson | Texas | 48181 | 26804 | 580 |
2195985 | 2195985 | 2022-02-08 | Blair | Pennsylvania | 42013 | 28496 | 580 |
2180632 | 2180632 | 2022-02-03 | Kenosha | Wisconsin | 55059 | 42780 | 580 |
2173381 | 2173381 | 2022-02-01 | Florence | South Carolina | 45041 | 39592 | 580 |
2164899 | 2164899 | 2022-01-30 | Henry | Georgia | 13151 | 55316 | 580 |
2161644 | 2161644 | 2022-01-29 | Henry | Georgia | 13151 | 55316 | 580 |
2158388 | 2158388 | 2022-01-28 | Henry | Georgia | 13151 | 55316 | 580 |
2157540 | 2157540 | 2022-01-27 | Wichita | Texas | 48485 | 30042 | 580 |
2153671 | 2153671 | 2022-01-26 | Marion | Oregon | 41047 | 59105 | 580 |
2148517 | 2148517 | 2022-01-25 | Indian River | Florida | 12061 | 28925 | 580 |
2145265 | 2145265 | 2022-01-24 | Indian River | Florida | 12061 | 28925 | 580 |
2142010 | 2142010 | 2022-01-23 | Indian River | Florida | 12061 | 28925 | 580 |
2138755 | 2138755 | 2022-01-22 | Indian River | Florida | 12061 | 28925 | 580 |
2135499 | 2135499 | 2022-01-21 | Indian River | Florida | 12061 | 28925 | 580 |
2132247 | 2132247 | 2022-01-20 | Indian River | Florida | 12061 | 27002 | 580 |
2128994 | 2128994 | 2022-01-19 | Indian River | Florida | 12061 | 27002 | 580 |
2129375 | 2129375 | 2022-01-19 | Hamilton | Indiana | 18057 | 72268 | 580 |
2057418 | 2057418 | 2021-12-28 | Weld | Colorado | 8123 | 56891 | 580 |
2057479 | 2057479 | 2021-12-28 | Okaloosa | Florida | 12091 | 35295 | 580 |
2054169 | 2054169 | 2021-12-27 | Weld | Colorado | 8123 | 56608 | 580 |
2054230 | 2054230 | 2021-12-27 | Okaloosa | Florida | 12091 | 35295 | 580 |
2050919 | 2050919 | 2021-12-26 | Weld | Colorado | 8123 | 56156 | 580 |
2050980 | 2050980 | 2021-12-26 | Okaloosa | Florida | 12091 | 35295 | 580 |
2047669 | 2047669 | 2021-12-25 | Weld | Colorado | 8123 | 56156 | 580 |
2047730 | 2047730 | 2021-12-25 | Okaloosa | Florida | 12091 | 35295 | 580 |
2044419 | 2044419 | 2021-12-24 | Weld | Colorado | 8123 | 56156 | 580 |
2044480 | 2044480 | 2021-12-24 | Okaloosa | Florida | 12091 | 35295 | 580 |
2041170 | 2041170 | 2021-12-23 | Weld | Colorado | 8123 | 55994 | 580 |
2041231 | 2041231 | 2021-12-23 | Okaloosa | Florida | 12091 | 35079 | 580 |
2037981 | 2037981 | 2021-12-22 | Okaloosa | Florida | 12091 | 35079 | 580 |
2036632 | 2036632 | 2021-12-21 | Beaver | Pennsylvania | 42007 | 28691 | 580 |
2005830 | 2005830 | 2021-12-12 | Elkhart | Indiana | 18039 | 41350 | 580 |
2002579 | 2002579 | 2021-12-11 | Elkhart | Indiana | 18039 | 41350 | 580 |
1999329 | 1999329 | 2021-12-10 | Elkhart | Indiana | 18039 | 41350 | 580 |
1998308 | 1998308 | 2021-12-09 | Chesterfield | Virginia | 51041 | 42376 | 580 |
1994380 | 1994380 | 2021-12-08 | Cambria | Pennsylvania | 42021 | 23461 | 580 |
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);