ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
216 rows where deaths = 557 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Michigan 22
- Indiana 19
- Arizona 18
- Ohio 17
- Texas 17
- Pennsylvania 15
- Virginia 11
- Missouri 10
- Georgia 9
- North Carolina 8
- California 7
- Maryland 7
- Louisiana 6
- Mississippi 6
- Florida 5
- Illinois 5
- Wisconsin 5
- Minnesota 4
- New Jersey 4
- Alabama 3
- New York 3
- Oregon 3
- Tennessee 3
- Arkansas 2
- New Mexico 2
- South Carolina 2
- Delaware 1
- District of Columbia 1
- Oklahoma 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502742 | 2502742 | 2022-05-13 | Brown | Wisconsin | 55009 | 85688 | 557 |
2499484 | 2499484 | 2022-05-12 | Brown | Wisconsin | 55009 | 85571 | 557 |
2491057 | 2491057 | 2022-05-10 | Berrien | Michigan | 26021 | 35114 | 557 |
2487800 | 2487800 | 2022-05-09 | Berrien | Michigan | 26021 | 35114 | 557 |
2484542 | 2484542 | 2022-05-08 | Berrien | Michigan | 26021 | 35114 | 557 |
2481284 | 2481284 | 2022-05-07 | Berrien | Michigan | 26021 | 35114 | 557 |
2478026 | 2478026 | 2022-05-06 | Berrien | Michigan | 26021 | 35114 | 557 |
2474768 | 2474768 | 2022-05-05 | Berrien | Michigan | 26021 | 35114 | 557 |
2471511 | 2471511 | 2022-05-04 | Berrien | Michigan | 26021 | 35114 | 557 |
2472336 | 2472336 | 2022-05-04 | Clermont | Ohio | 39025 | 51582 | 557 |
2469080 | 2469080 | 2022-05-03 | Clermont | Ohio | 39025 | 51582 | 557 |
2465824 | 2465824 | 2022-05-02 | Clermont | Ohio | 39025 | 51582 | 557 |
2462569 | 2462569 | 2022-05-01 | Clermont | Ohio | 39025 | 51582 | 557 |
2459313 | 2459313 | 2022-04-30 | Clermont | Ohio | 39025 | 51582 | 557 |
2456057 | 2456057 | 2022-04-29 | Clermont | Ohio | 39025 | 51582 | 557 |
2452801 | 2452801 | 2022-04-28 | Clermont | Ohio | 39025 | 51582 | 557 |
2353165 | 2353165 | 2022-03-29 | Cochise | Arizona | 4003 | 31254 | 557 |
2349913 | 2349913 | 2022-03-28 | Cochise | Arizona | 4003 | 31254 | 557 |
2350584 | 2350584 | 2022-03-28 | Porter | Indiana | 18127 | 37571 | 557 |
2346660 | 2346660 | 2022-03-27 | Cochise | Arizona | 4003 | 31254 | 557 |
2347331 | 2347331 | 2022-03-27 | Porter | Indiana | 18127 | 37563 | 557 |
2343407 | 2343407 | 2022-03-26 | Cochise | Arizona | 4003 | 31254 | 557 |
2344078 | 2344078 | 2022-03-26 | Porter | Indiana | 18127 | 37563 | 557 |
2340154 | 2340154 | 2022-03-25 | Cochise | Arizona | 4003 | 31254 | 557 |
2340825 | 2340825 | 2022-03-25 | Porter | Indiana | 18127 | 37563 | 557 |
2336901 | 2336901 | 2022-03-24 | Cochise | Arizona | 4003 | 31254 | 557 |
2337572 | 2337572 | 2022-03-24 | Porter | Indiana | 18127 | 37553 | 557 |
2333647 | 2333647 | 2022-03-23 | Cochise | Arizona | 4003 | 31254 | 557 |
2334318 | 2334318 | 2022-03-23 | Porter | Indiana | 18127 | 37530 | 557 |
2335468 | 2335468 | 2022-03-23 | Buncombe | North Carolina | 37021 | 52069 | 557 |
2331064 | 2331064 | 2022-03-22 | Porter | Indiana | 18127 | 37510 | 557 |
2327812 | 2327812 | 2022-03-21 | Porter | Indiana | 18127 | 37504 | 557 |
2324559 | 2324559 | 2022-03-20 | Porter | Indiana | 18127 | 37487 | 557 |
2321305 | 2321305 | 2022-03-19 | Porter | Indiana | 18127 | 37487 | 557 |
2318051 | 2318051 | 2022-03-18 | Porter | Indiana | 18127 | 37487 | 557 |
2306196 | 2306196 | 2022-03-14 | Catawba | North Carolina | 37035 | 47414 | 557 |
2293197 | 2293197 | 2022-03-10 | Cumberland | North Carolina | 37051 | 82270 | 557 |
2289945 | 2289945 | 2022-03-09 | Cumberland | North Carolina | 37051 | 82172 | 557 |
2286018 | 2286018 | 2022-03-08 | Calhoun | Michigan | 26025 | 33776 | 557 |
2286693 | 2286693 | 2022-03-08 | Cumberland | North Carolina | 37051 | 82102 | 557 |
2282671 | 2282671 | 2022-03-07 | Rapides | Louisiana | 22079 | 32623 | 557 |
2282766 | 2282766 | 2022-03-07 | Calhoun | Michigan | 26025 | 33776 | 557 |
2283441 | 2283441 | 2022-03-07 | Cumberland | North Carolina | 37051 | 82042 | 557 |
2279418 | 2279418 | 2022-03-06 | Rapides | Louisiana | 22079 | 32613 | 557 |
2276165 | 2276165 | 2022-03-05 | Rapides | Louisiana | 22079 | 32613 | 557 |
2272912 | 2272912 | 2022-03-04 | Rapides | Louisiana | 22079 | 32613 | 557 |
2269780 | 2269780 | 2022-03-03 | Jackson | Michigan | 26075 | 44268 | 557 |
2266527 | 2266527 | 2022-03-02 | Jackson | Michigan | 26075 | 44268 | 557 |
2251609 | 2251609 | 2022-02-25 | Unknown | Tennessee | 23465 | 557 | |
2241115 | 2241115 | 2022-02-22 | Niagara | New York | 36063 | 47036 | 557 |
2237213 | 2237213 | 2022-02-21 | Washington | Maryland | 24043 | 34670 | 557 |
2237864 | 2237864 | 2022-02-21 | Niagara | New York | 36063 | 47011 | 557 |
2233962 | 2233962 | 2022-02-20 | Washington | Maryland | 24043 | 34670 | 557 |
2230711 | 2230711 | 2022-02-19 | Washington | Maryland | 24043 | 34655 | 557 |
2232182 | 2232182 | 2022-02-19 | Ellis | Texas | 48139 | 47862 | 557 |
2227450 | 2227450 | 2022-02-18 | Harford | Maryland | 24025 | 37526 | 557 |
2227460 | 2227460 | 2022-02-18 | Washington | Maryland | 24043 | 34613 | 557 |
2224199 | 2224199 | 2022-02-17 | Harford | Maryland | 24025 | 37495 | 557 |
2203655 | 2203655 | 2022-02-11 | Washington | Arkansas | 5143 | 66176 | 557 |
2200402 | 2200402 | 2022-02-10 | Washington | Arkansas | 5143 | 66053 | 557 |
2195258 | 2195258 | 2022-02-08 | Jefferson | Missouri | 29099 | 52584 | 557 |
2178622 | 2178622 | 2022-02-03 | Tangipahoa | Louisiana | 22105 | 33330 | 557 |
2179279 | 2179279 | 2022-02-03 | McKinley | New Mexico | 35031 | 24304 | 557 |
2171728 | 2171728 | 2022-02-01 | Vanderburgh | Indiana | 18163 | 54373 | 557 |
2168475 | 2168475 | 2022-01-31 | Vanderburgh | Indiana | 18163 | 54082 | 557 |
2154134 | 2154134 | 2022-01-26 | Grayson | Texas | 48181 | 24452 | 557 |
2149963 | 2149963 | 2022-01-25 | Cumberland | New Jersey | 34011 | 35818 | 557 |
2134223 | 2134223 | 2022-01-20 | Washington | Pennsylvania | 42125 | 45065 | 557 |
2122092 | 2122092 | 2022-01-16 | Racine | Wisconsin | 55101 | 49602 | 557 |
2115728 | 2115728 | 2022-01-15 | Apache | Arizona | 4001 | 17858 | 557 |
2118840 | 2118840 | 2022-01-15 | Racine | Wisconsin | 55101 | 49602 | 557 |
2115588 | 2115588 | 2022-01-14 | Racine | Wisconsin | 55101 | 49602 | 557 |
2111998 | 2111998 | 2022-01-13 | Wichita | Texas | 48485 | 25406 | 557 |
2108746 | 2108746 | 2022-01-12 | Wichita | Texas | 48485 | 25049 | 557 |
2105495 | 2105495 | 2022-01-11 | Wichita | Texas | 48485 | 25042 | 557 |
2097407 | 2097407 | 2022-01-09 | Kalamazoo | Michigan | 26077 | 44209 | 557 |
2094155 | 2094155 | 2022-01-08 | Kalamazoo | Michigan | 26077 | 44209 | 557 |
2090903 | 2090903 | 2022-01-07 | Kalamazoo | Michigan | 26077 | 44209 | 557 |
2088474 | 2088474 | 2022-01-06 | Lake | Ohio | 39085 | 43655 | 557 |
2085223 | 2085223 | 2022-01-05 | Lake | Ohio | 39085 | 43293 | 557 |
2081971 | 2081971 | 2022-01-04 | Lake | Ohio | 39085 | 42971 | 557 |
2082185 | 2082185 | 2022-01-04 | Schuylkill | Pennsylvania | 42107 | 26749 | 557 |
1991153 | 1991153 | 2021-12-07 | Lackawanna | Pennsylvania | 42069 | 26157 | 557 |
1974041 | 1974041 | 2021-12-02 | Harrison | Mississippi | 28047 | 34981 | 557 |
1970792 | 1970792 | 2021-12-01 | Harrison | Mississippi | 28047 | 34949 | 557 |
1967542 | 1967542 | 2021-11-30 | Harrison | Mississippi | 28047 | 34920 | 557 |
1960324 | 1960324 | 2021-11-28 | Elkhart | Indiana | 18039 | 39118 | 557 |
1960913 | 1960913 | 2021-11-28 | Ottawa | Michigan | 26139 | 48398 | 557 |
1957073 | 1957073 | 2021-11-27 | Elkhart | Indiana | 18039 | 39118 | 557 |
1957662 | 1957662 | 2021-11-27 | Ottawa | Michigan | 26139 | 48398 | 557 |
1958625 | 1958625 | 2021-11-27 | Cambria | Pennsylvania | 42021 | 22398 | 557 |
1953822 | 1953822 | 2021-11-26 | Elkhart | Indiana | 18039 | 39118 | 557 |
1954411 | 1954411 | 2021-11-26 | Ottawa | Michigan | 26139 | 48398 | 557 |
1955374 | 1955374 | 2021-11-26 | Cambria | Pennsylvania | 42021 | 22287 | 557 |
1950571 | 1950571 | 2021-11-25 | Elkhart | Indiana | 18039 | 39118 | 557 |
1951160 | 1951160 | 2021-11-25 | Ottawa | Michigan | 26139 | 48398 | 557 |
1952123 | 1952123 | 2021-11-25 | Cambria | Pennsylvania | 42021 | 22209 | 557 |
1947320 | 1947320 | 2021-11-24 | Elkhart | Indiana | 18039 | 39118 | 557 |
1947909 | 1947909 | 2021-11-24 | Ottawa | Michigan | 26139 | 48398 | 557 |
1944069 | 1944069 | 2021-11-23 | Elkhart | Indiana | 18039 | 38949 | 557 |
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);