ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
297 rows where deaths = 511 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 42
- South Carolina 30
- Pennsylvania 29
- Illinois 24
- Georgia 19
- Florida 18
- Louisiana 16
- Michigan 14
- Texas 11
- New York 9
- Virginia 9
- Indiana 8
- Oregon 8
- Arizona 7
- Minnesota 7
- Alabama 6
- North Carolina 6
- California 5
- Arkansas 4
- New Jersey 4
- Tennessee 4
- Kentucky 3
- Wisconsin 3
- Maryland 2
- Washington 2
- Connecticut 1
- District of Columbia 1
- Hawaii 1
- Idaho 1
- Missouri 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500239 | 2500239 | 2022-05-13 | McHenry | Illinois | 17111 | 79189 | 511 |
2496981 | 2496981 | 2022-05-12 | McHenry | Illinois | 17111 | 78920 | 511 |
2493723 | 2493723 | 2022-05-11 | McHenry | Illinois | 17111 | 78779 | 511 |
2490465 | 2490465 | 2022-05-10 | McHenry | Illinois | 17111 | 78611 | 511 |
2487208 | 2487208 | 2022-05-09 | McHenry | Illinois | 17111 | 78452 | 511 |
2483950 | 2483950 | 2022-05-08 | McHenry | Illinois | 17111 | 78120 | 511 |
2480692 | 2480692 | 2022-05-07 | McHenry | Illinois | 17111 | 78120 | 511 |
2477434 | 2477434 | 2022-05-06 | McHenry | Illinois | 17111 | 78120 | 511 |
2476687 | 2476687 | 2022-05-05 | Dane | Wisconsin | 55025 | 131339 | 511 |
2472352 | 2472352 | 2022-05-04 | Greene | Ohio | 39057 | 37714 | 511 |
2473429 | 2473429 | 2022-05-04 | Dane | Wisconsin | 55025 | 130825 | 511 |
2469096 | 2469096 | 2022-05-03 | Greene | Ohio | 39057 | 37714 | 511 |
2465840 | 2465840 | 2022-05-02 | Greene | Ohio | 39057 | 37714 | 511 |
2462585 | 2462585 | 2022-05-01 | Greene | Ohio | 39057 | 37714 | 511 |
2463527 | 2463527 | 2022-05-01 | Richmond city | Virginia | 51760 | 45408 | 511 |
2459329 | 2459329 | 2022-04-30 | Greene | Ohio | 39057 | 37714 | 511 |
2460271 | 2460271 | 2022-04-30 | Richmond city | Virginia | 51760 | 45408 | 511 |
2456073 | 2456073 | 2022-04-29 | Greene | Ohio | 39057 | 37714 | 511 |
2457015 | 2457015 | 2022-04-29 | Richmond city | Virginia | 51760 | 45408 | 511 |
2452817 | 2452817 | 2022-04-28 | Greene | Ohio | 39057 | 37714 | 511 |
2453759 | 2453759 | 2022-04-28 | Richmond city | Virginia | 51760 | 45357 | 511 |
2449561 | 2449561 | 2022-04-27 | Greene | Ohio | 39057 | 37621 | 511 |
2450503 | 2450503 | 2022-04-27 | Richmond city | Virginia | 51760 | 45318 | 511 |
2446304 | 2446304 | 2022-04-26 | Greene | Ohio | 39057 | 37621 | 511 |
2443049 | 2443049 | 2022-04-25 | Greene | Ohio | 39057 | 37621 | 511 |
2439793 | 2439793 | 2022-04-24 | Greene | Ohio | 39057 | 37621 | 511 |
2436537 | 2436537 | 2022-04-23 | Greene | Ohio | 39057 | 37621 | 511 |
2433281 | 2433281 | 2022-04-22 | Greene | Ohio | 39057 | 37621 | 511 |
2430025 | 2430025 | 2022-04-21 | Greene | Ohio | 39057 | 37621 | 511 |
2426769 | 2426769 | 2022-04-20 | Greene | Ohio | 39057 | 37530 | 511 |
2423513 | 2423513 | 2022-04-19 | Greene | Ohio | 39057 | 37530 | 511 |
2420256 | 2420256 | 2022-04-18 | Greene | Ohio | 39057 | 37530 | 511 |
2417001 | 2417001 | 2022-04-17 | Greene | Ohio | 39057 | 37530 | 511 |
2413745 | 2413745 | 2022-04-16 | Greene | Ohio | 39057 | 37530 | 511 |
2410489 | 2410489 | 2022-04-15 | Greene | Ohio | 39057 | 37530 | 511 |
2407233 | 2407233 | 2022-04-14 | Greene | Ohio | 39057 | 37530 | 511 |
2403977 | 2403977 | 2022-04-13 | Greene | Ohio | 39057 | 37509 | 511 |
2400722 | 2400722 | 2022-04-12 | Greene | Ohio | 39057 | 37509 | 511 |
2397467 | 2397467 | 2022-04-11 | Greene | Ohio | 39057 | 37509 | 511 |
2394212 | 2394212 | 2022-04-10 | Greene | Ohio | 39057 | 37509 | 511 |
2390956 | 2390956 | 2022-04-09 | Greene | Ohio | 39057 | 37509 | 511 |
2387700 | 2387700 | 2022-04-08 | Greene | Ohio | 39057 | 37509 | 511 |
2384445 | 2384445 | 2022-04-07 | Greene | Ohio | 39057 | 37509 | 511 |
2378150 | 2378150 | 2022-04-05 | Lycoming | Pennsylvania | 42081 | 28384 | 511 |
2374896 | 2374896 | 2022-04-04 | Lycoming | Pennsylvania | 42081 | 28380 | 511 |
2371582 | 2371582 | 2022-04-03 | Jackson | Oregon | 41029 | 42608 | 511 |
2371644 | 2371644 | 2022-04-03 | Lycoming | Pennsylvania | 42081 | 28380 | 511 |
2368329 | 2368329 | 2022-04-02 | Jackson | Oregon | 41029 | 42608 | 511 |
2368391 | 2368391 | 2022-04-02 | Lycoming | Pennsylvania | 42081 | 28380 | 511 |
2364682 | 2364682 | 2022-04-01 | Broome | New York | 36007 | 45114 | 511 |
2365076 | 2365076 | 2022-04-01 | Jackson | Oregon | 41029 | 42608 | 511 |
2365138 | 2365138 | 2022-04-01 | Lycoming | Pennsylvania | 42081 | 28378 | 511 |
2361428 | 2361428 | 2022-03-31 | Broome | New York | 36007 | 45053 | 511 |
2361823 | 2361823 | 2022-03-31 | Jackson | Oregon | 41029 | 42603 | 511 |
2361882 | 2361882 | 2022-03-31 | Lebanon | Pennsylvania | 42075 | 36505 | 511 |
2358174 | 2358174 | 2022-03-30 | Broome | New York | 36007 | 45024 | 511 |
2347010 | 2347010 | 2022-03-27 | Floyd | Georgia | 13115 | 27198 | 511 |
2343757 | 2343757 | 2022-03-26 | Floyd | Georgia | 13115 | 27198 | 511 |
2340504 | 2340504 | 2022-03-25 | Floyd | Georgia | 13115 | 27198 | 511 |
2337251 | 2337251 | 2022-03-24 | Floyd | Georgia | 13115 | 27199 | 511 |
2308206 | 2308206 | 2022-03-15 | Rock Island | Illinois | 17161 | 32955 | 511 |
2304955 | 2304955 | 2022-03-14 | Rock Island | Illinois | 17161 | 32944 | 511 |
2306062 | 2306062 | 2022-03-14 | Rockingham | New Hampshire | 33015 | 66024 | 511 |
2301196 | 2301196 | 2022-03-13 | Sebastian | Arkansas | 5131 | 32530 | 511 |
2301703 | 2301703 | 2022-03-13 | Rock Island | Illinois | 17161 | 32935 | 511 |
2297944 | 2297944 | 2022-03-12 | Sebastian | Arkansas | 5131 | 32521 | 511 |
2298451 | 2298451 | 2022-03-12 | Rock Island | Illinois | 17161 | 32935 | 511 |
2295199 | 2295199 | 2022-03-11 | Rock Island | Illinois | 17161 | 32935 | 511 |
2291947 | 2291947 | 2022-03-10 | Rock Island | Illinois | 17161 | 32932 | 511 |
2292590 | 2292590 | 2022-03-10 | Washtenaw | Michigan | 26161 | 74104 | 511 |
2288695 | 2288695 | 2022-03-09 | Rock Island | Illinois | 17161 | 32914 | 511 |
2289338 | 2289338 | 2022-03-09 | Washtenaw | Michigan | 26161 | 73995 | 511 |
2285444 | 2285444 | 2022-03-08 | Rock Island | Illinois | 17161 | 32897 | 511 |
2283821 | 2283821 | 2022-03-07 | Monroe | Pennsylvania | 42089 | 36692 | 511 |
2280522 | 2280522 | 2022-03-06 | Washington | Oregon | 41067 | 84400 | 511 |
2280569 | 2280569 | 2022-03-06 | Monroe | Pennsylvania | 42089 | 36688 | 511 |
2277269 | 2277269 | 2022-03-05 | Washington | Oregon | 41067 | 84400 | 511 |
2274016 | 2274016 | 2022-03-04 | Washington | Oregon | 41067 | 84400 | 511 |
2270763 | 2270763 | 2022-03-03 | Washington | Oregon | 41067 | 84327 | 511 |
2247816 | 2247816 | 2022-02-24 | Clermont | Ohio | 39025 | 50801 | 511 |
2244565 | 2244565 | 2022-02-23 | Clermont | Ohio | 39025 | 50786 | 511 |
2240637 | 2240637 | 2022-02-22 | St. Louis | Minnesota | 27137 | 45388 | 511 |
2241314 | 2241314 | 2022-02-22 | Clermont | Ohio | 39025 | 50765 | 511 |
2237386 | 2237386 | 2022-02-21 | St. Louis | Minnesota | 27137 | 45288 | 511 |
2234135 | 2234135 | 2022-02-20 | St. Louis | Minnesota | 27137 | 45288 | 511 |
2230884 | 2230884 | 2022-02-19 | St. Louis | Minnesota | 27137 | 45288 | 511 |
2231800 | 2231800 | 2022-02-19 | Northumberland | Pennsylvania | 42097 | 22505 | 511 |
2227633 | 2227633 | 2022-02-18 | St. Louis | Minnesota | 27137 | 45288 | 511 |
2228549 | 2228549 | 2022-02-18 | Northumberland | Pennsylvania | 42097 | 22472 | 511 |
2178184 | 2178184 | 2022-02-03 | Hendricks | Indiana | 18063 | 39779 | 511 |
2174291 | 2174291 | 2022-02-02 | Cochise | Arizona | 4003 | 28713 | 511 |
2171977 | 2171977 | 2022-02-01 | Fayette | Kentucky | 21067 | 86113 | 511 |
2168724 | 2168724 | 2022-01-31 | Fayette | Kentucky | 21067 | 85597 | 511 |
2143536 | 2143536 | 2022-01-23 | Niagara | New York | 36063 | 44502 | 511 |
2140281 | 2140281 | 2022-01-22 | Niagara | New York | 36063 | 44279 | 511 |
2132112 | 2132112 | 2022-01-20 | Placer | California | 6061 | 57362 | 511 |
2133151 | 2133151 | 2022-01-20 | Calhoun | Michigan | 26025 | 29427 | 511 |
2129898 | 2129898 | 2022-01-19 | Calhoun | Michigan | 26025 | 29427 | 511 |
2081797 | 2081797 | 2022-01-04 | Cumberland | North Carolina | 37051 | 53901 | 511 |
2078545 | 2078545 | 2022-01-03 | Cumberland | North Carolina | 37051 | 53626 | 511 |
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);