ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
416 rows where deaths = 426 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Carolina 37
- Georgia 33
- Pennsylvania 31
- Indiana 29
- Texas 28
- Michigan 27
- North Carolina 22
- Louisiana 18
- California 17
- Tennessee 17
- Alabama 16
- Illinois 13
- Florida 12
- Ohio 12
- Colorado 11
- Iowa 9
- New York 9
- Arizona 8
- Kentucky 8
- Minnesota 7
- Missouri 6
- Virginia 6
- Alaska 5
- Washington 5
- Connecticut 4
- New Jersey 4
- Arkansas 3
- Hawaii 3
- Utah 3
- Kansas 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469589 | 2469589 | 2022-05-03 | Madison | Tennessee | 47113 | 30095 | 426 |
2466333 | 2466333 | 2022-05-02 | Madison | Tennessee | 47113 | 30095 | 426 |
2463078 | 2463078 | 2022-05-01 | Madison | Tennessee | 47113 | 30095 | 426 |
2459822 | 2459822 | 2022-04-30 | Madison | Tennessee | 47113 | 30095 | 426 |
2456566 | 2456566 | 2022-04-29 | Madison | Tennessee | 47113 | 30095 | 426 |
2453310 | 2453310 | 2022-04-28 | Madison | Tennessee | 47113 | 30095 | 426 |
2450054 | 2450054 | 2022-04-27 | Madison | Tennessee | 47113 | 30095 | 426 |
2446797 | 2446797 | 2022-04-26 | Madison | Tennessee | 47113 | 30025 | 426 |
2443542 | 2443542 | 2022-04-25 | Madison | Tennessee | 47113 | 30025 | 426 |
2440286 | 2440286 | 2022-04-24 | Madison | Tennessee | 47113 | 30025 | 426 |
2437030 | 2437030 | 2022-04-23 | Madison | Tennessee | 47113 | 30025 | 426 |
2433774 | 2433774 | 2022-04-22 | Madison | Tennessee | 47113 | 30025 | 426 |
2430518 | 2430518 | 2022-04-21 | Madison | Tennessee | 47113 | 30025 | 426 |
2427262 | 2427262 | 2022-04-20 | Madison | Tennessee | 47113 | 30025 | 426 |
2415954 | 2415954 | 2022-04-17 | Hardin | Kentucky | 21093 | 32535 | 426 |
2412698 | 2412698 | 2022-04-16 | Hardin | Kentucky | 21093 | 32535 | 426 |
2409442 | 2409442 | 2022-04-15 | Hardin | Kentucky | 21093 | 32535 | 426 |
2406186 | 2406186 | 2022-04-14 | Hardin | Kentucky | 21093 | 32535 | 426 |
2402930 | 2402930 | 2022-04-13 | Hardin | Kentucky | 21093 | 32535 | 426 |
2399676 | 2399676 | 2022-04-12 | Hardin | Kentucky | 21093 | 32535 | 426 |
2396420 | 2396420 | 2022-04-11 | Hardin | Kentucky | 21093 | 32535 | 426 |
2382849 | 2382849 | 2022-04-07 | Paulding | Georgia | 13223 | 38062 | 426 |
2379594 | 2379594 | 2022-04-06 | Paulding | Georgia | 13223 | 38055 | 426 |
2377127 | 2377127 | 2022-04-05 | Lapeer | Michigan | 26087 | 20768 | 426 |
2373272 | 2373272 | 2022-04-04 | Sangamon | Illinois | 17167 | 54813 | 426 |
2373875 | 2373875 | 2022-04-04 | Lapeer | Michigan | 26087 | 20768 | 426 |
2370019 | 2370019 | 2022-04-03 | Sangamon | Illinois | 17167 | 54787 | 426 |
2370622 | 2370622 | 2022-04-03 | Lapeer | Michigan | 26087 | 20768 | 426 |
2366766 | 2366766 | 2022-04-02 | Sangamon | Illinois | 17167 | 54787 | 426 |
2367369 | 2367369 | 2022-04-02 | Lapeer | Michigan | 26087 | 20768 | 426 |
2363513 | 2363513 | 2022-04-01 | Sangamon | Illinois | 17167 | 54787 | 426 |
2364116 | 2364116 | 2022-04-01 | Lapeer | Michigan | 26087 | 20768 | 426 |
2360113 | 2360113 | 2022-03-31 | Walton | Georgia | 13297 | 21974 | 426 |
2360121 | 2360121 | 2022-03-31 | Whitfield | Georgia | 13313 | 34064 | 426 |
2360259 | 2360259 | 2022-03-31 | Sangamon | Illinois | 17167 | 54761 | 426 |
2360862 | 2360862 | 2022-03-31 | Lapeer | Michigan | 26087 | 20766 | 426 |
2356859 | 2356859 | 2022-03-30 | Walton | Georgia | 13297 | 21979 | 426 |
2356867 | 2356867 | 2022-03-30 | Whitfield | Georgia | 13313 | 34047 | 426 |
2357005 | 2357005 | 2022-03-30 | Sangamon | Illinois | 17167 | 54728 | 426 |
2357608 | 2357608 | 2022-03-30 | Lapeer | Michigan | 26087 | 20766 | 426 |
2358410 | 2358410 | 2022-03-30 | Fairfield | Ohio | 39045 | 38379 | 426 |
2353752 | 2353752 | 2022-03-29 | Sangamon | Illinois | 17167 | 54707 | 426 |
2354355 | 2354355 | 2022-03-29 | Lapeer | Michigan | 26087 | 20756 | 426 |
2355156 | 2355156 | 2022-03-29 | Fairfield | Ohio | 39045 | 38379 | 426 |
2351103 | 2351103 | 2022-03-28 | Lapeer | Michigan | 26087 | 20756 | 426 |
2351903 | 2351903 | 2022-03-28 | Fairfield | Ohio | 39045 | 38379 | 426 |
2348651 | 2348651 | 2022-03-27 | Fairfield | Ohio | 39045 | 38379 | 426 |
2345398 | 2345398 | 2022-03-26 | Fairfield | Ohio | 39045 | 38379 | 426 |
2342145 | 2342145 | 2022-03-25 | Fairfield | Ohio | 39045 | 38379 | 426 |
2338892 | 2338892 | 2022-03-24 | Fairfield | Ohio | 39045 | 38379 | 426 |
2304336 | 2304336 | 2022-03-14 | Walker | Alabama | 1127 | 18519 | 426 |
2301084 | 2301084 | 2022-03-13 | Walker | Alabama | 1127 | 18515 | 426 |
2297832 | 2297832 | 2022-03-12 | Walker | Alabama | 1127 | 18515 | 426 |
2294580 | 2294580 | 2022-03-11 | Walker | Alabama | 1127 | 18515 | 426 |
2291328 | 2291328 | 2022-03-10 | Walker | Alabama | 1127 | 18514 | 426 |
2284818 | 2284818 | 2022-03-08 | Shelby | Alabama | 1117 | 60006 | 426 |
2285259 | 2285259 | 2022-03-08 | Newton | Georgia | 13217 | 24399 | 426 |
2286718 | 2286718 | 2022-03-08 | Johnston | North Carolina | 37101 | 58421 | 426 |
2283466 | 2283466 | 2022-03-07 | Johnston | North Carolina | 37101 | 58398 | 426 |
2280214 | 2280214 | 2022-03-06 | Johnston | North Carolina | 37101 | 58286 | 426 |
2280684 | 2280684 | 2022-03-06 | Berkeley | South Carolina | 45015 | 51469 | 426 |
2276961 | 2276961 | 2022-03-05 | Johnston | North Carolina | 37101 | 58286 | 426 |
2277431 | 2277431 | 2022-03-05 | Berkeley | South Carolina | 45015 | 51469 | 426 |
2273708 | 2273708 | 2022-03-04 | Johnston | North Carolina | 37101 | 58286 | 426 |
2274178 | 2274178 | 2022-03-04 | Berkeley | South Carolina | 45015 | 51469 | 426 |
2268911 | 2268911 | 2022-03-03 | Carroll | Georgia | 13045 | 23668 | 426 |
2270455 | 2270455 | 2022-03-03 | Johnston | North Carolina | 37101 | 58166 | 426 |
2270925 | 2270925 | 2022-03-03 | Berkeley | South Carolina | 45015 | 51450 | 426 |
2267667 | 2267667 | 2022-03-02 | Aiken | South Carolina | 45003 | 41024 | 426 |
2267673 | 2267673 | 2022-03-02 | Berkeley | South Carolina | 45015 | 51436 | 426 |
2262717 | 2262717 | 2022-03-01 | Delaware | Indiana | 18035 | 24620 | 426 |
2263951 | 2263951 | 2022-03-01 | Johnston | North Carolina | 37101 | 58055 | 426 |
2264414 | 2264414 | 2022-03-01 | Aiken | South Carolina | 45003 | 41004 | 426 |
2264902 | 2264902 | 2022-03-01 | Washington | Utah | 49053 | 44506 | 426 |
2259466 | 2259466 | 2022-02-28 | Delaware | Indiana | 18035 | 24606 | 426 |
2255695 | 2255695 | 2022-02-27 | Kings | California | 6031 | 54023 | 426 |
2258303 | 2258303 | 2022-02-27 | Parker | Texas | 48367 | 33840 | 426 |
2252444 | 2252444 | 2022-02-26 | Kings | California | 6031 | 54023 | 426 |
2249193 | 2249193 | 2022-02-25 | Kings | California | 6031 | 54023 | 426 |
2219966 | 2219966 | 2022-02-16 | Solano | California | 6095 | 83874 | 426 |
2217219 | 2217219 | 2022-02-15 | Howard | Indiana | 18067 | 25111 | 426 |
2219434 | 2219434 | 2022-02-15 | Chesapeake city | Virginia | 51550 | 48650 | 426 |
2213464 | 2213464 | 2022-02-14 | Solano | California | 6095 | 83672 | 426 |
2214675 | 2214675 | 2022-02-14 | Jackson | Mississippi | 28059 | 36381 | 426 |
2200530 | 2200530 | 2022-02-10 | Litchfield | Connecticut | 9005 | 30525 | 426 |
2197276 | 2197276 | 2022-02-09 | Litchfield | Connecticut | 9005 | 30474 | 426 |
2199818 | 2199818 | 2022-02-09 | Tom Green | Texas | 48451 | 40484 | 426 |
2189199 | 2189199 | 2022-02-06 | Union | North Carolina | 37179 | 58635 | 426 |
2190269 | 2190269 | 2022-02-06 | Benton | Washington | 53005 | 49620 | 426 |
2185946 | 2185946 | 2022-02-05 | Union | North Carolina | 37179 | 58635 | 426 |
2187016 | 2187016 | 2022-02-05 | Benton | Washington | 53005 | 49620 | 426 |
2182694 | 2182694 | 2022-02-04 | Union | North Carolina | 37179 | 58635 | 426 |
2183763 | 2183763 | 2022-02-04 | Benton | Washington | 53005 | 49620 | 426 |
2179442 | 2179442 | 2022-02-03 | Union | North Carolina | 37179 | 58415 | 426 |
2174623 | 2174623 | 2022-02-02 | Coweta | Georgia | 13077 | 31965 | 426 |
2171745 | 2171745 | 2022-02-01 | Black Hawk | Iowa | 19013 | 30686 | 426 |
2168492 | 2168492 | 2022-01-31 | Black Hawk | Iowa | 19013 | 30686 | 426 |
2165237 | 2165237 | 2022-01-30 | Black Hawk | Iowa | 19013 | 30686 | 426 |
2165587 | 2165587 | 2022-01-30 | Livingston | Louisiana | 22063 | 34934 | 426 |
2161982 | 2161982 | 2022-01-29 | Black Hawk | Iowa | 19013 | 30686 | 426 |
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);