ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
210 rows where deaths = 649 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Michigan 18
- New Jersey 18
- Alabama 17
- California 14
- Texas 11
- Pennsylvania 10
- Georgia 8
- Illinois 8
- Tennessee 8
- Iowa 7
- Florida 6
- Mississippi 6
- New York 6
- North Carolina 6
- Washington 6
- Colorado 5
- Indiana 5
- Louisiana 5
- Nevada 5
- New Hampshire 5
- Ohio 5
- Oregon 5
- Delaware 4
- Virginia 4
- Maryland 3
- Massachusetts 2
- Minnesota 2
- Missouri 2
- South Carolina 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491107 | 2491107 | 2022-05-10 | Muskegon | Michigan | 26121 | 42236 | 649 |
2487850 | 2487850 | 2022-05-09 | Muskegon | Michigan | 26121 | 42236 | 649 |
2484592 | 2484592 | 2022-05-08 | Muskegon | Michigan | 26121 | 42236 | 649 |
2481334 | 2481334 | 2022-05-07 | Muskegon | Michigan | 26121 | 42236 | 649 |
2478076 | 2478076 | 2022-05-06 | Muskegon | Michigan | 26121 | 42236 | 649 |
2473830 | 2473830 | 2022-05-05 | Kent | Delaware | 10001 | 51201 | 649 |
2474818 | 2474818 | 2022-05-05 | Muskegon | Michigan | 26121 | 42236 | 649 |
2470573 | 2470573 | 2022-05-04 | Kent | Delaware | 10001 | 51102 | 649 |
2471561 | 2471561 | 2022-05-04 | Muskegon | Michigan | 26121 | 42236 | 649 |
2467317 | 2467317 | 2022-05-03 | Kent | Delaware | 10001 | 51055 | 649 |
2468305 | 2468305 | 2022-05-03 | Muskegon | Michigan | 26121 | 42067 | 649 |
2463771 | 2463771 | 2022-05-02 | Etowah | Alabama | 1055 | 28771 | 649 |
2464062 | 2464062 | 2022-05-02 | Kent | Delaware | 10001 | 51041 | 649 |
2465050 | 2465050 | 2022-05-02 | Muskegon | Michigan | 26121 | 42067 | 649 |
2460515 | 2460515 | 2022-05-01 | Etowah | Alabama | 1055 | 28761 | 649 |
2461794 | 2461794 | 2022-05-01 | Muskegon | Michigan | 26121 | 42067 | 649 |
2457259 | 2457259 | 2022-04-30 | Etowah | Alabama | 1055 | 28761 | 649 |
2458538 | 2458538 | 2022-04-30 | Muskegon | Michigan | 26121 | 42067 | 649 |
2454003 | 2454003 | 2022-04-29 | Etowah | Alabama | 1055 | 28761 | 649 |
2455282 | 2455282 | 2022-04-29 | Muskegon | Michigan | 26121 | 42067 | 649 |
2450747 | 2450747 | 2022-04-28 | Etowah | Alabama | 1055 | 28759 | 649 |
2452026 | 2452026 | 2022-04-28 | Muskegon | Michigan | 26121 | 42067 | 649 |
2447491 | 2447491 | 2022-04-27 | Etowah | Alabama | 1055 | 28757 | 649 |
2448770 | 2448770 | 2022-04-27 | Muskegon | Michigan | 26121 | 42067 | 649 |
2428680 | 2428680 | 2022-04-21 | Madison | Indiana | 18095 | 32707 | 649 |
2425424 | 2425424 | 2022-04-20 | Madison | Indiana | 18095 | 32707 | 649 |
2422168 | 2422168 | 2022-04-19 | Madison | Indiana | 18095 | 32700 | 649 |
2418912 | 2418912 | 2022-04-18 | Madison | Indiana | 18095 | 32700 | 649 |
2374918 | 2374918 | 2022-04-04 | Washington | Pennsylvania | 42125 | 50769 | 649 |
2371666 | 2371666 | 2022-04-03 | Washington | Pennsylvania | 42125 | 50762 | 649 |
2368413 | 2368413 | 2022-04-02 | Washington | Pennsylvania | 42125 | 50762 | 649 |
2365160 | 2365160 | 2022-04-01 | Washington | Pennsylvania | 42125 | 50752 | 649 |
2361907 | 2361907 | 2022-03-31 | Washington | Pennsylvania | 42125 | 50735 | 649 |
2287054 | 2287054 | 2022-03-08 | Fayette | Pennsylvania | 42051 | 30774 | 649 |
2278722 | 2278722 | 2022-03-06 | Henry | Georgia | 13151 | 57387 | 649 |
2275469 | 2275469 | 2022-03-05 | Henry | Georgia | 13151 | 57387 | 649 |
2272216 | 2272216 | 2022-03-04 | Henry | Georgia | 13151 | 57387 | 649 |
2273612 | 2273612 | 2022-03-04 | Dutchess | New York | 36027 | 63256 | 649 |
2270359 | 2270359 | 2022-03-03 | Dutchess | New York | 36027 | 63256 | 649 |
2271368 | 2271368 | 2022-03-03 | Wichita | Texas | 48485 | 33864 | 649 |
2267107 | 2267107 | 2022-03-02 | Dutchess | New York | 36027 | 63209 | 649 |
2268116 | 2268116 | 2022-03-02 | Wichita | Texas | 48485 | 33864 | 649 |
2264863 | 2264863 | 2022-03-01 | Wichita | Texas | 48485 | 33864 | 649 |
2257747 | 2257747 | 2022-02-27 | Marion | Oregon | 41047 | 68088 | 649 |
2254496 | 2254496 | 2022-02-26 | Marion | Oregon | 41047 | 68088 | 649 |
2254960 | 2254960 | 2022-02-26 | Gregg | Texas | 48183 | 22980 | 649 |
2251245 | 2251245 | 2022-02-25 | Marion | Oregon | 41047 | 68088 | 649 |
2247994 | 2247994 | 2022-02-24 | Marion | Oregon | 41047 | 68004 | 649 |
2215524 | 2215524 | 2022-02-14 | Franklin | Pennsylvania | 42055 | 39620 | 649 |
2193272 | 2193272 | 2022-02-07 | Potter | Texas | 48375 | 34537 | 649 |
2183451 | 2183451 | 2022-02-04 | Johnson | Texas | 48251 | 40582 | 649 |
2149441 | 2149441 | 2022-01-25 | Ingham | Michigan | 26065 | 57398 | 649 |
2146189 | 2146189 | 2022-01-24 | Ingham | Michigan | 26065 | 57398 | 649 |
2134171 | 2134171 | 2022-01-20 | Cambria | Pennsylvania | 42021 | 30431 | 649 |
2083331 | 2083331 | 2022-01-05 | Monterey | California | 6053 | 56086 | 649 |
2080079 | 2080079 | 2022-01-04 | Monterey | California | 6053 | 55957 | 649 |
2073576 | 2073576 | 2022-01-02 | Monterey | California | 6053 | 55161 | 649 |
2070325 | 2070325 | 2022-01-01 | Monterey | California | 6053 | 55161 | 649 |
2067074 | 2067074 | 2021-12-31 | Monterey | California | 6053 | 55161 | 649 |
2063823 | 2063823 | 2021-12-30 | Monterey | California | 6053 | 55007 | 649 |
2062198 | 2062198 | 2021-12-29 | San Juan | New Mexico | 35045 | 28338 | 649 |
2055803 | 2055803 | 2021-12-27 | Gaston | North Carolina | 37071 | 43817 | 649 |
2052553 | 2052553 | 2021-12-26 | Gaston | North Carolina | 37071 | 43817 | 649 |
2049303 | 2049303 | 2021-12-25 | Gaston | North Carolina | 37071 | 43817 | 649 |
2046053 | 2046053 | 2021-12-24 | Gaston | North Carolina | 37071 | 43817 | 649 |
2042803 | 2042803 | 2021-12-23 | Gaston | North Carolina | 37071 | 43817 | 649 |
2037675 | 2037675 | 2021-12-22 | Tuscaloosa | Alabama | 1125 | 36637 | 649 |
2037909 | 2037909 | 2021-12-22 | Pueblo | Colorado | 8101 | 30863 | 649 |
2038942 | 2038942 | 2021-12-22 | Anoka | Minnesota | 27003 | 69778 | 649 |
2039554 | 2039554 | 2021-12-22 | Gaston | North Carolina | 37071 | 43817 | 649 |
2034425 | 2034425 | 2021-12-21 | Tuscaloosa | Alabama | 1125 | 36591 | 649 |
2031175 | 2031175 | 2021-12-20 | Tuscaloosa | Alabama | 1125 | 36553 | 649 |
2032553 | 2032553 | 2021-12-20 | Hinds | Mississippi | 28049 | 33421 | 649 |
2027924 | 2027924 | 2021-12-19 | Tuscaloosa | Alabama | 1125 | 36542 | 649 |
2029302 | 2029302 | 2021-12-19 | Hinds | Mississippi | 28049 | 33208 | 649 |
2024673 | 2024673 | 2021-12-18 | Tuscaloosa | Alabama | 1125 | 36535 | 649 |
2026051 | 2026051 | 2021-12-18 | Hinds | Mississippi | 28049 | 33208 | 649 |
2021422 | 2021422 | 2021-12-17 | Tuscaloosa | Alabama | 1125 | 36515 | 649 |
2022800 | 2022800 | 2021-12-17 | Hinds | Mississippi | 28049 | 33208 | 649 |
2018171 | 2018171 | 2021-12-16 | Tuscaloosa | Alabama | 1125 | 36492 | 649 |
2019549 | 2019549 | 2021-12-16 | Hinds | Mississippi | 28049 | 33100 | 649 |
2021209 | 2021209 | 2021-12-16 | Yakima | Washington | 53077 | 47526 | 649 |
2016299 | 2016299 | 2021-12-15 | Hinds | Mississippi | 28049 | 33044 | 649 |
2017958 | 2017958 | 2021-12-15 | Yakima | Washington | 53077 | 47477 | 649 |
1998719 | 1998719 | 2021-12-10 | Benton | Arkansas | 5007 | 44667 | 649 |
1948882 | 1948882 | 2021-11-24 | Cumberland | Pennsylvania | 42041 | 30896 | 649 |
1917554 | 1917554 | 2021-11-15 | Merced | California | 6047 | 44703 | 649 |
1917840 | 1917840 | 2021-11-15 | Muscogee | Georgia | 13215 | 24402 | 649 |
1914590 | 1914590 | 2021-11-14 | Muscogee | Georgia | 13215 | 24364 | 649 |
1911340 | 1911340 | 2021-11-13 | Muscogee | Georgia | 13215 | 24364 | 649 |
1908091 | 1908091 | 2021-11-12 | Muscogee | Georgia | 13215 | 24364 | 649 |
1875787 | 1875787 | 2021-11-02 | St. Clair | Illinois | 17163 | 40633 | 649 |
1872538 | 1872538 | 2021-11-01 | St. Clair | Illinois | 17163 | 40603 | 649 |
1869289 | 1869289 | 2021-10-31 | St. Clair | Illinois | 17163 | 40499 | 649 |
1866040 | 1866040 | 2021-10-30 | St. Clair | Illinois | 17163 | 40499 | 649 |
1862791 | 1862791 | 2021-10-29 | St. Clair | Illinois | 17163 | 40499 | 649 |
1859542 | 1859542 | 2021-10-28 | St. Clair | Illinois | 17163 | 40461 | 649 |
1858166 | 1858166 | 2021-10-27 | Hamilton | Tennessee | 47065 | 63933 | 649 |
1852580 | 1852580 | 2021-10-26 | San Francisco | California | 6075 | 54664 | 649 |
1849331 | 1849331 | 2021-10-25 | San Francisco | California | 6075 | 54443 | 649 |
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);