ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
666 rows where deaths = 365 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 70
- Pennsylvania 63
- South Dakota 50
- California 45
- Alabama 42
- Georgia 30
- Indiana 29
- Colorado 28
- Michigan 27
- South Carolina 25
- Florida 21
- Virginia 17
- Rhode Island 16
- Tennessee 15
- Arizona 14
- Ohio 14
- New York 13
- Wisconsin 13
- Louisiana 12
- Illinois 10
- Maryland 10
- West Virginia 10
- Kansas 9
- North Carolina 9
- Utah 9
- Massachusetts 8
- Oklahoma 8
- Arkansas 7
- Minnesota 7
- New Mexico 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499781 | 2499781 | 2022-05-13 | Madera | California | 6039 | 43685 | 365 |
2501479 | 2501479 | 2022-05-13 | Ulster | New York | 36111 | 33856 | 365 |
2496523 | 2496523 | 2022-05-12 | Madera | California | 6039 | 43585 | 365 |
2493265 | 2493265 | 2022-05-11 | Madera | California | 6039 | 43585 | 365 |
2494250 | 2494250 | 2022-05-11 | Cumberland | Maine | 23005 | 52104 | 365 |
2490007 | 2490007 | 2022-05-10 | Madera | California | 6039 | 43585 | 365 |
2486750 | 2486750 | 2022-05-09 | Madera | California | 6039 | 43525 | 365 |
2483492 | 2483492 | 2022-05-08 | Madera | California | 6039 | 43525 | 365 |
2480234 | 2480234 | 2022-05-07 | Madera | California | 6039 | 43525 | 365 |
2476976 | 2476976 | 2022-05-06 | Madera | California | 6039 | 43525 | 365 |
2473718 | 2473718 | 2022-05-05 | Madera | California | 6039 | 43525 | 365 |
2476357 | 2476357 | 2022-05-05 | Starr | Texas | 48427 | 20037 | 365 |
2470461 | 2470461 | 2022-05-04 | Madera | California | 6039 | 43525 | 365 |
2473100 | 2473100 | 2022-05-04 | Starr | Texas | 48427 | 20031 | 365 |
2467205 | 2467205 | 2022-05-03 | Madera | California | 6039 | 43525 | 365 |
2469844 | 2469844 | 2022-05-03 | Starr | Texas | 48427 | 20020 | 365 |
2463950 | 2463950 | 2022-05-02 | Madera | California | 6039 | 43490 | 365 |
2466588 | 2466588 | 2022-05-02 | Starr | Texas | 48427 | 20014 | 365 |
2460694 | 2460694 | 2022-05-01 | Madera | California | 6039 | 43490 | 365 |
2463333 | 2463333 | 2022-05-01 | Starr | Texas | 48427 | 20011 | 365 |
2457438 | 2457438 | 2022-04-30 | Madera | California | 6039 | 43490 | 365 |
2460077 | 2460077 | 2022-04-30 | Starr | Texas | 48427 | 20009 | 365 |
2454182 | 2454182 | 2022-04-29 | Madera | California | 6039 | 43490 | 365 |
2456821 | 2456821 | 2022-04-29 | Starr | Texas | 48427 | 19993 | 365 |
2453565 | 2453565 | 2022-04-28 | Starr | Texas | 48427 | 19969 | 365 |
2450309 | 2450309 | 2022-04-27 | Starr | Texas | 48427 | 19955 | 365 |
2447052 | 2447052 | 2022-04-26 | Starr | Texas | 48427 | 19952 | 365 |
2443797 | 2443797 | 2022-04-25 | Starr | Texas | 48427 | 19941 | 365 |
2440541 | 2440541 | 2022-04-24 | Starr | Texas | 48427 | 19938 | 365 |
2437285 | 2437285 | 2022-04-23 | Starr | Texas | 48427 | 19938 | 365 |
2434029 | 2434029 | 2022-04-22 | Starr | Texas | 48427 | 19928 | 365 |
2427949 | 2427949 | 2022-04-21 | Cullman | Alabama | 1043 | 24556 | 365 |
2430773 | 2430773 | 2022-04-21 | Starr | Texas | 48427 | 19905 | 365 |
2424693 | 2424693 | 2022-04-20 | Cullman | Alabama | 1043 | 24554 | 365 |
2427517 | 2427517 | 2022-04-20 | Starr | Texas | 48427 | 19898 | 365 |
2421437 | 2421437 | 2022-04-19 | Cullman | Alabama | 1043 | 24547 | 365 |
2418181 | 2418181 | 2022-04-18 | Cullman | Alabama | 1043 | 24539 | 365 |
2414925 | 2414925 | 2022-04-17 | Cullman | Alabama | 1043 | 24539 | 365 |
2411669 | 2411669 | 2022-04-16 | Cullman | Alabama | 1043 | 24539 | 365 |
2408413 | 2408413 | 2022-04-15 | Cullman | Alabama | 1043 | 24539 | 365 |
2405157 | 2405157 | 2022-04-14 | Cullman | Alabama | 1043 | 24539 | 365 |
2401902 | 2401902 | 2022-04-13 | Cullman | Alabama | 1043 | 24521 | 365 |
2398647 | 2398647 | 2022-04-12 | Cullman | Alabama | 1043 | 24521 | 365 |
2398411 | 2398411 | 2022-04-11 | Roanoke city | Virginia | 51770 | 21234 | 365 |
2395156 | 2395156 | 2022-04-10 | Roanoke city | Virginia | 51770 | 21226 | 365 |
2391900 | 2391900 | 2022-04-09 | Roanoke city | Virginia | 51770 | 21226 | 365 |
2388644 | 2388644 | 2022-04-08 | Roanoke city | Virginia | 51770 | 21226 | 365 |
2377240 | 2377240 | 2022-04-05 | Stearns | Minnesota | 27145 | 50716 | 365 |
2373988 | 2373988 | 2022-04-04 | Stearns | Minnesota | 27145 | 50697 | 365 |
2370735 | 2370735 | 2022-04-03 | Stearns | Minnesota | 27145 | 50686 | 365 |
2367482 | 2367482 | 2022-04-02 | Stearns | Minnesota | 27145 | 50686 | 365 |
2364229 | 2364229 | 2022-04-01 | Stearns | Minnesota | 27145 | 50686 | 365 |
2360324 | 2360324 | 2022-03-31 | LaPorte | Indiana | 18091 | 25405 | 365 |
2357070 | 2357070 | 2022-03-30 | LaPorte | Indiana | 18091 | 25405 | 365 |
2353817 | 2353817 | 2022-03-29 | LaPorte | Indiana | 18091 | 25421 | 365 |
2350565 | 2350565 | 2022-03-28 | LaPorte | Indiana | 18091 | 25417 | 365 |
2347312 | 2347312 | 2022-03-27 | LaPorte | Indiana | 18091 | 25411 | 365 |
2344059 | 2344059 | 2022-03-26 | LaPorte | Indiana | 18091 | 25411 | 365 |
2340806 | 2340806 | 2022-03-25 | LaPorte | Indiana | 18091 | 25411 | 365 |
2337553 | 2337553 | 2022-03-24 | LaPorte | Indiana | 18091 | 25409 | 365 |
2328195 | 2328195 | 2022-03-21 | Lafourche | Louisiana | 22057 | 27691 | 365 |
2324942 | 2324942 | 2022-03-20 | Lafourche | Louisiana | 22057 | 27685 | 365 |
2325021 | 2325021 | 2022-03-20 | Berkshire | Massachusetts | 25003 | 22848 | 365 |
2321688 | 2321688 | 2022-03-19 | Lafourche | Louisiana | 22057 | 27685 | 365 |
2321767 | 2321767 | 2022-03-19 | Berkshire | Massachusetts | 25003 | 22848 | 365 |
2318434 | 2318434 | 2022-03-18 | Lafourche | Louisiana | 22057 | 27685 | 365 |
2318513 | 2318513 | 2022-03-18 | Berkshire | Massachusetts | 25003 | 22848 | 365 |
2315260 | 2315260 | 2022-03-17 | Berkshire | Massachusetts | 25003 | 22831 | 365 |
2310837 | 2310837 | 2022-03-16 | Talladega | Alabama | 1121 | 22249 | 365 |
2312007 | 2312007 | 2022-03-16 | Berkshire | Massachusetts | 25003 | 22818 | 365 |
2307584 | 2307584 | 2022-03-15 | Talladega | Alabama | 1121 | 22239 | 365 |
2307858 | 2307858 | 2022-03-15 | Columbia | Florida | 12023 | 21123 | 365 |
2308754 | 2308754 | 2022-03-15 | Berkshire | Massachusetts | 25003 | 22801 | 365 |
2304607 | 2304607 | 2022-03-14 | Columbia | Florida | 12023 | 21123 | 365 |
2307379 | 2307379 | 2022-03-14 | Cabell | West Virginia | 54011 | 27235 | 365 |
2301355 | 2301355 | 2022-03-13 | Columbia | Florida | 12023 | 21123 | 365 |
2298103 | 2298103 | 2022-03-12 | Columbia | Florida | 12023 | 21123 | 365 |
2294851 | 2294851 | 2022-03-11 | Columbia | Florida | 12023 | 21123 | 365 |
2291599 | 2291599 | 2022-03-10 | Columbia | Florida | 12023 | 21107 | 365 |
2288347 | 2288347 | 2022-03-09 | Columbia | Florida | 12023 | 21107 | 365 |
2290175 | 2290175 | 2022-03-09 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2286923 | 2286923 | 2022-03-08 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2281936 | 2281936 | 2022-03-07 | Columbia | Georgia | 13073 | 35490 | 365 |
2281958 | 2281958 | 2022-03-07 | Forsyth | Georgia | 13117 | 54951 | 365 |
2283671 | 2283671 | 2022-03-07 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2278683 | 2278683 | 2022-03-06 | Columbia | Georgia | 13073 | 35455 | 365 |
2280419 | 2280419 | 2022-03-06 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2275430 | 2275430 | 2022-03-05 | Columbia | Georgia | 13073 | 35455 | 365 |
2277166 | 2277166 | 2022-03-05 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2272177 | 2272177 | 2022-03-04 | Columbia | Georgia | 13073 | 35455 | 365 |
2273913 | 2273913 | 2022-03-04 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2268925 | 2268925 | 2022-03-03 | Columbia | Georgia | 13073 | 35413 | 365 |
2270660 | 2270660 | 2022-03-03 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2265777 | 2265777 | 2022-03-02 | Troup | Georgia | 13285 | 15374 | 365 |
2267408 | 2267408 | 2022-03-02 | Canadian | Oklahoma | 40017 | 38719 | 365 |
2262526 | 2262526 | 2022-03-01 | Troup | Georgia | 13285 | 15373 | 365 |
2258791 | 2258791 | 2022-02-28 | Marshall | Alabama | 1095 | 27102 | 365 |
2259275 | 2259275 | 2022-02-28 | Troup | Georgia | 13285 | 15371 | 365 |
2261169 | 2261169 | 2022-02-28 | Beaufort | South Carolina | 45013 | 42743 | 365 |
2255540 | 2255540 | 2022-02-27 | Marshall | Alabama | 1095 | 27099 | 365 |
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);