ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
270 rows where deaths = 536 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Texas 57
- Florida 45
- South Carolina 15
- Michigan 14
- Indiana 13
- New Hampshire 11
- Pennsylvania 11
- Georgia 10
- New Mexico 10
- Ohio 9
- Washington 9
- Arizona 8
- Illinois 8
- Louisiana 8
- California 7
- Colorado 7
- North Carolina 5
- Alabama 4
- Mississippi 3
- New York 3
- Wisconsin 3
- Delaware 2
- Missouri 2
- New Jersey 2
- Kentucky 1
- Maryland 1
- Nevada 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502335 | 2502335 | 2022-05-13 | Kaufman | Texas | 48257 | 35680 | 536 |
2499077 | 2499077 | 2022-05-12 | Kaufman | Texas | 48257 | 35668 | 536 |
2495819 | 2495819 | 2022-05-11 | Kaufman | Texas | 48257 | 35660 | 536 |
2492561 | 2492561 | 2022-05-10 | Kaufman | Texas | 48257 | 35651 | 536 |
2489303 | 2489303 | 2022-05-09 | Kaufman | Texas | 48257 | 35640 | 536 |
2486046 | 2486046 | 2022-05-08 | Kaufman | Texas | 48257 | 35635 | 536 |
2482788 | 2482788 | 2022-05-07 | Kaufman | Texas | 48257 | 35628 | 536 |
2479530 | 2479530 | 2022-05-06 | Kaufman | Texas | 48257 | 35617 | 536 |
2476272 | 2476272 | 2022-05-05 | Kaufman | Texas | 48257 | 35608 | 536 |
2473015 | 2473015 | 2022-05-04 | Kaufman | Texas | 48257 | 35602 | 536 |
2469759 | 2469759 | 2022-05-03 | Kaufman | Texas | 48257 | 35598 | 536 |
2465536 | 2465536 | 2022-05-02 | Rockingham | New Hampshire | 33015 | 68890 | 536 |
2466503 | 2466503 | 2022-05-02 | Kaufman | Texas | 48257 | 35584 | 536 |
2462281 | 2462281 | 2022-05-01 | Rockingham | New Hampshire | 33015 | 68632 | 536 |
2463248 | 2463248 | 2022-05-01 | Kaufman | Texas | 48257 | 35582 | 536 |
2459025 | 2459025 | 2022-04-30 | Rockingham | New Hampshire | 33015 | 68632 | 536 |
2459992 | 2459992 | 2022-04-30 | Kaufman | Texas | 48257 | 35578 | 536 |
2455769 | 2455769 | 2022-04-29 | Rockingham | New Hampshire | 33015 | 68632 | 536 |
2456736 | 2456736 | 2022-04-29 | Kaufman | Texas | 48257 | 35556 | 536 |
2452513 | 2452513 | 2022-04-28 | Rockingham | New Hampshire | 33015 | 68529 | 536 |
2453480 | 2453480 | 2022-04-28 | Kaufman | Texas | 48257 | 35532 | 536 |
2447748 | 2447748 | 2022-04-27 | Mesa | Colorado | 8077 | 42751 | 536 |
2449257 | 2449257 | 2022-04-27 | Rockingham | New Hampshire | 33015 | 68461 | 536 |
2450224 | 2450224 | 2022-04-27 | Kaufman | Texas | 48257 | 35517 | 536 |
2444492 | 2444492 | 2022-04-26 | Mesa | Colorado | 8077 | 42739 | 536 |
2446000 | 2446000 | 2022-04-26 | Rockingham | New Hampshire | 33015 | 68380 | 536 |
2446967 | 2446967 | 2022-04-26 | Kaufman | Texas | 48257 | 35478 | 536 |
2441236 | 2441236 | 2022-04-25 | Mesa | Colorado | 8077 | 42712 | 536 |
2442745 | 2442745 | 2022-04-25 | Rockingham | New Hampshire | 33015 | 68329 | 536 |
2443712 | 2443712 | 2022-04-25 | Kaufman | Texas | 48257 | 35469 | 536 |
2437980 | 2437980 | 2022-04-24 | Mesa | Colorado | 8077 | 42667 | 536 |
2439489 | 2439489 | 2022-04-24 | Rockingham | New Hampshire | 33015 | 67957 | 536 |
2440456 | 2440456 | 2022-04-24 | Kaufman | Texas | 48257 | 35465 | 536 |
2434724 | 2434724 | 2022-04-23 | Mesa | Colorado | 8077 | 42667 | 536 |
2436233 | 2436233 | 2022-04-23 | Rockingham | New Hampshire | 33015 | 67957 | 536 |
2437200 | 2437200 | 2022-04-23 | Kaufman | Texas | 48257 | 35461 | 536 |
2431468 | 2431468 | 2022-04-22 | Mesa | Colorado | 8077 | 42667 | 536 |
2432977 | 2432977 | 2022-04-22 | Rockingham | New Hampshire | 33015 | 67957 | 536 |
2433944 | 2433944 | 2022-04-22 | Kaufman | Texas | 48257 | 35454 | 536 |
2430688 | 2430688 | 2022-04-21 | Kaufman | Texas | 48257 | 35452 | 536 |
2427432 | 2427432 | 2022-04-20 | Kaufman | Texas | 48257 | 35450 | 536 |
2424176 | 2424176 | 2022-04-19 | Kaufman | Texas | 48257 | 35442 | 536 |
2420920 | 2420920 | 2022-04-18 | Kaufman | Texas | 48257 | 35433 | 536 |
2417664 | 2417664 | 2022-04-17 | Kaufman | Texas | 48257 | 35400 | 536 |
2414408 | 2414408 | 2022-04-16 | Kaufman | Texas | 48257 | 35400 | 536 |
2411152 | 2411152 | 2022-04-15 | Kaufman | Texas | 48257 | 35400 | 536 |
2407896 | 2407896 | 2022-04-14 | Kaufman | Texas | 48257 | 35400 | 536 |
2404640 | 2404640 | 2022-04-13 | Kaufman | Texas | 48257 | 35388 | 536 |
2401385 | 2401385 | 2022-04-12 | Kaufman | Texas | 48257 | 35379 | 536 |
2398130 | 2398130 | 2022-04-11 | Kaufman | Texas | 48257 | 35373 | 536 |
2394875 | 2394875 | 2022-04-10 | Kaufman | Texas | 48257 | 35372 | 536 |
2391619 | 2391619 | 2022-04-09 | Kaufman | Texas | 48257 | 35372 | 536 |
2388363 | 2388363 | 2022-04-08 | Kaufman | Texas | 48257 | 35358 | 536 |
2385108 | 2385108 | 2022-04-07 | Kaufman | Texas | 48257 | 35337 | 536 |
2353454 | 2353454 | 2022-03-29 | Unknown | Florida | 4773 | 536 | |
2308778 | 2308778 | 2022-03-15 | Berrien | Michigan | 26021 | 34497 | 536 |
2305527 | 2305527 | 2022-03-14 | Berrien | Michigan | 26021 | 34497 | 536 |
2256925 | 2256925 | 2022-02-27 | DeSoto | Mississippi | 28033 | 49772 | 536 |
2253674 | 2253674 | 2022-02-26 | DeSoto | Mississippi | 28033 | 49772 | 536 |
2250423 | 2250423 | 2022-02-25 | DeSoto | Mississippi | 28033 | 49772 | 536 |
2236084 | 2236084 | 2022-02-21 | Cochise | Arizona | 4003 | 30707 | 536 |
2238134 | 2238134 | 2022-02-21 | Warren | Ohio | 39165 | 56997 | 536 |
2232833 | 2232833 | 2022-02-20 | Cochise | Arizona | 4003 | 30707 | 536 |
2234883 | 2234883 | 2022-02-20 | Warren | Ohio | 39165 | 56983 | 536 |
2229582 | 2229582 | 2022-02-19 | Cochise | Arizona | 4003 | 30666 | 536 |
2231632 | 2231632 | 2022-02-19 | Warren | Ohio | 39165 | 56968 | 536 |
2228381 | 2228381 | 2022-02-18 | Warren | Ohio | 39165 | 56924 | 536 |
2224906 | 2224906 | 2022-02-17 | Catawba | North Carolina | 37035 | 46627 | 536 |
2225130 | 2225130 | 2022-02-17 | Warren | Ohio | 39165 | 56877 | 536 |
2221879 | 2221879 | 2022-02-16 | Warren | Ohio | 39165 | 56826 | 536 |
2217516 | 2217516 | 2022-02-15 | Fayette | Kentucky | 21067 | 90302 | 536 |
2218628 | 2218628 | 2022-02-15 | Warren | Ohio | 39165 | 56777 | 536 |
2210746 | 2210746 | 2022-02-13 | Porter | Indiana | 18127 | 36760 | 536 |
2207493 | 2207493 | 2022-02-12 | Porter | Indiana | 18127 | 36760 | 536 |
2204240 | 2204240 | 2022-02-11 | Porter | Indiana | 18127 | 36760 | 536 |
2187421 | 2187421 | 2022-02-06 | Placer | California | 6061 | 66066 | 536 |
2187622 | 2187622 | 2022-02-06 | Cherokee | Georgia | 13057 | 61628 | 536 |
2189189 | 2189189 | 2022-02-06 | Rowan | North Carolina | 37159 | 39226 | 536 |
2184168 | 2184168 | 2022-02-05 | Placer | California | 6061 | 66066 | 536 |
2184369 | 2184369 | 2022-02-05 | Cherokee | Georgia | 13057 | 61628 | 536 |
2185936 | 2185936 | 2022-02-05 | Rowan | North Carolina | 37159 | 39226 | 536 |
2180916 | 2180916 | 2022-02-04 | Placer | California | 6061 | 66066 | 536 |
2181117 | 2181117 | 2022-02-04 | Cherokee | Georgia | 13057 | 61628 | 536 |
2182684 | 2182684 | 2022-02-04 | Rowan | North Carolina | 37159 | 39226 | 536 |
2179432 | 2179432 | 2022-02-03 | Rowan | North Carolina | 37159 | 39070 | 536 |
2144847 | 2144847 | 2022-01-23 | Kenosha | Wisconsin | 55059 | 40951 | 536 |
2138721 | 2138721 | 2022-01-22 | Kent | Delaware | 10001 | 45510 | 536 |
2141592 | 2141592 | 2022-01-22 | Kenosha | Wisconsin | 55059 | 40951 | 536 |
2138336 | 2138336 | 2022-01-21 | Kenosha | Wisconsin | 55059 | 40951 | 536 |
2109874 | 2109874 | 2022-01-13 | Johnson | Indiana | 18081 | 35635 | 536 |
2100162 | 2100162 | 2022-01-10 | Vanderburgh | Indiana | 18163 | 41847 | 536 |
2097299 | 2097299 | 2022-01-09 | Tangipahoa | Louisiana | 22105 | 25959 | 536 |
2097957 | 2097957 | 2022-01-09 | McKinley | New Mexico | 35031 | 18340 | 536 |
2094047 | 2094047 | 2022-01-08 | Tangipahoa | Louisiana | 22105 | 25959 | 536 |
2094705 | 2094705 | 2022-01-08 | McKinley | New Mexico | 35031 | 18340 | 536 |
2090795 | 2090795 | 2022-01-07 | Tangipahoa | Louisiana | 22105 | 25959 | 536 |
2091453 | 2091453 | 2022-01-07 | McKinley | New Mexico | 35031 | 18340 | 536 |
2087544 | 2087544 | 2022-01-06 | Tangipahoa | Louisiana | 22105 | 25707 | 536 |
2087674 | 2087674 | 2022-01-06 | Muskegon | Michigan | 26121 | 33011 | 536 |
2088202 | 2088202 | 2022-01-06 | McKinley | New Mexico | 35031 | 18136 | 536 |
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);