ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
338 rows where deaths = 421 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 43
- Texas 36
- Pennsylvania 27
- California 24
- Virginia 15
- Indiana 14
- South Carolina 14
- New York 13
- North Carolina 13
- Ohio 12
- Illinois 11
- Mississippi 11
- Tennessee 10
- Washington 10
- Iowa 9
- Kentucky 9
- Arizona 7
- Michigan 7
- Minnesota 6
- New Mexico 6
- Florida 5
- Louisiana 5
- Missouri 5
- Alabama 4
- Arkansas 4
- Maryland 3
- Wisconsin 3
- Kansas 2
- Massachusetts 2
- New Jersey 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500091 | 2500091 | 2022-05-13 | Spalding | Georgia | 13255 | 15968 | 421 |
2496833 | 2496833 | 2022-05-12 | Spalding | Georgia | 13255 | 15968 | 421 |
2493575 | 2493575 | 2022-05-11 | Spalding | Georgia | 13255 | 15968 | 421 |
2490317 | 2490317 | 2022-05-10 | Spalding | Georgia | 13255 | 15906 | 421 |
2486734 | 2486734 | 2022-05-09 | Butte | California | 6007 | 40010 | 421 |
2487060 | 2487060 | 2022-05-09 | Spalding | Georgia | 13255 | 15906 | 421 |
2483476 | 2483476 | 2022-05-08 | Butte | California | 6007 | 40010 | 421 |
2483802 | 2483802 | 2022-05-08 | Spalding | Georgia | 13255 | 15911 | 421 |
2480218 | 2480218 | 2022-05-07 | Butte | California | 6007 | 40010 | 421 |
2480544 | 2480544 | 2022-05-07 | Spalding | Georgia | 13255 | 15911 | 421 |
2476960 | 2476960 | 2022-05-06 | Butte | California | 6007 | 40010 | 421 |
2477286 | 2477286 | 2022-05-06 | Spalding | Georgia | 13255 | 15911 | 421 |
2474028 | 2474028 | 2022-05-05 | Spalding | Georgia | 13255 | 15911 | 421 |
2470771 | 2470771 | 2022-05-04 | Spalding | Georgia | 13255 | 15911 | 421 |
2416748 | 2416748 | 2022-04-17 | Sandoval | New Mexico | 35043 | 33551 | 421 |
2413492 | 2413492 | 2022-04-16 | Sandoval | New Mexico | 35043 | 33551 | 421 |
2410236 | 2410236 | 2022-04-15 | Sandoval | New Mexico | 35043 | 33551 | 421 |
2401215 | 2401215 | 2022-04-12 | Madison | Tennessee | 47113 | 29908 | 421 |
2397960 | 2397960 | 2022-04-11 | Madison | Tennessee | 47113 | 29908 | 421 |
2394705 | 2394705 | 2022-04-10 | Madison | Tennessee | 47113 | 29908 | 421 |
2391449 | 2391449 | 2022-04-09 | Madison | Tennessee | 47113 | 29908 | 421 |
2388193 | 2388193 | 2022-04-08 | Madison | Tennessee | 47113 | 29908 | 421 |
2384938 | 2384938 | 2022-04-07 | Madison | Tennessee | 47113 | 29908 | 421 |
2381683 | 2381683 | 2022-04-06 | Madison | Tennessee | 47113 | 29908 | 421 |
2370383 | 2370383 | 2022-04-03 | Hardin | Kentucky | 21093 | 32453 | 421 |
2367130 | 2367130 | 2022-04-02 | Hardin | Kentucky | 21093 | 32453 | 421 |
2363877 | 2363877 | 2022-04-01 | Hardin | Kentucky | 21093 | 32453 | 421 |
2365564 | 2365564 | 2022-04-01 | Henderson | Texas | 48213 | 15369 | 421 |
2360623 | 2360623 | 2022-03-31 | Hardin | Kentucky | 21093 | 32453 | 421 |
2362311 | 2362311 | 2022-03-31 | Henderson | Texas | 48213 | 15367 | 421 |
2357369 | 2357369 | 2022-03-30 | Hardin | Kentucky | 21093 | 32453 | 421 |
2359057 | 2359057 | 2022-03-30 | Henderson | Texas | 48213 | 15364 | 421 |
2354116 | 2354116 | 2022-03-29 | Hardin | Kentucky | 21093 | 32453 | 421 |
2355803 | 2355803 | 2022-03-29 | Henderson | Texas | 48213 | 15364 | 421 |
2350864 | 2350864 | 2022-03-28 | Hardin | Kentucky | 21093 | 32453 | 421 |
2352550 | 2352550 | 2022-03-28 | Henderson | Texas | 48213 | 15360 | 421 |
2349298 | 2349298 | 2022-03-27 | Henderson | Texas | 48213 | 15360 | 421 |
2346045 | 2346045 | 2022-03-26 | Henderson | Texas | 48213 | 15360 | 421 |
2342792 | 2342792 | 2022-03-25 | Henderson | Texas | 48213 | 15358 | 421 |
2339539 | 2339539 | 2022-03-24 | Henderson | Texas | 48213 | 15357 | 421 |
2336462 | 2336462 | 2022-03-23 | Weber | Utah | 49057 | 70784 | 421 |
2333031 | 2333031 | 2022-03-22 | Henderson | Texas | 48213 | 15356 | 421 |
2329778 | 2329778 | 2022-03-21 | Henderson | Texas | 48213 | 15356 | 421 |
2324291 | 2324291 | 2022-03-20 | Paulding | Georgia | 13223 | 37872 | 421 |
2321037 | 2321037 | 2022-03-19 | Paulding | Georgia | 13223 | 37872 | 421 |
2317783 | 2317783 | 2022-03-18 | Paulding | Georgia | 13223 | 37872 | 421 |
2314568 | 2314568 | 2022-03-17 | Walton | Georgia | 13297 | 21968 | 421 |
2311315 | 2311315 | 2022-03-16 | Walton | Georgia | 13297 | 21971 | 421 |
2312865 | 2312865 | 2022-03-16 | Fairfield | Ohio | 39045 | 38312 | 421 |
2313424 | 2313424 | 2022-03-16 | Bowie | Texas | 48037 | 20001 | 421 |
2309612 | 2309612 | 2022-03-15 | Fairfield | Ohio | 39045 | 38312 | 421 |
2310171 | 2310171 | 2022-03-15 | Bowie | Texas | 48037 | 19967 | 421 |
2306359 | 2306359 | 2022-03-14 | Fairfield | Ohio | 39045 | 38312 | 421 |
2303108 | 2303108 | 2022-03-13 | Fairfield | Ohio | 39045 | 38312 | 421 |
2299856 | 2299856 | 2022-03-12 | Fairfield | Ohio | 39045 | 38305 | 421 |
2296604 | 2296604 | 2022-03-11 | Fairfield | Ohio | 39045 | 38304 | 421 |
2284128 | 2284128 | 2022-03-07 | Unknown | Tennessee | 22492 | 421 | |
2268555 | 2268555 | 2022-03-03 | Shelby | Alabama | 1117 | 58888 | 421 |
2269183 | 2269183 | 2022-03-03 | Sangamon | Illinois | 17167 | 54277 | 421 |
2259156 | 2259156 | 2022-02-28 | Carroll | Georgia | 13045 | 23655 | 421 |
2255905 | 2255905 | 2022-02-27 | Carroll | Georgia | 13045 | 23642 | 421 |
2252654 | 2252654 | 2022-02-26 | Carroll | Georgia | 13045 | 23642 | 421 |
2249403 | 2249403 | 2022-02-25 | Carroll | Georgia | 13045 | 23642 | 421 |
2247889 | 2247889 | 2022-02-24 | Wayne | Ohio | 39169 | 22979 | 421 |
2244445 | 2244445 | 2022-02-23 | Johnston | North Carolina | 37101 | 57661 | 421 |
2244638 | 2244638 | 2022-02-23 | Wayne | Ohio | 39169 | 22971 | 421 |
2239960 | 2239960 | 2022-02-22 | Delaware | Indiana | 18035 | 24498 | 421 |
2241194 | 2241194 | 2022-02-22 | Johnston | North Carolina | 37101 | 57579 | 421 |
2241387 | 2241387 | 2022-02-22 | Wayne | Ohio | 39169 | 22961 | 421 |
2236189 | 2236189 | 2022-02-21 | Kings | California | 6031 | 53066 | 421 |
2236484 | 2236484 | 2022-02-21 | Newton | Georgia | 13217 | 24285 | 421 |
2236709 | 2236709 | 2022-02-21 | Delaware | Indiana | 18035 | 24478 | 421 |
2232938 | 2232938 | 2022-02-20 | Kings | California | 6031 | 53066 | 421 |
2229687 | 2229687 | 2022-02-19 | Kings | California | 6031 | 53066 | 421 |
2226436 | 2226436 | 2022-02-18 | Kings | California | 6031 | 53066 | 421 |
2223185 | 2223185 | 2022-02-17 | Kings | California | 6031 | 52917 | 421 |
2210716 | 2210716 | 2022-02-13 | Howard | Indiana | 18067 | 25020 | 421 |
2207463 | 2207463 | 2022-02-12 | Howard | Indiana | 18067 | 25020 | 421 |
2204210 | 2204210 | 2022-02-11 | Howard | Indiana | 18067 | 25020 | 421 |
2200453 | 2200453 | 2022-02-10 | Solano | California | 6095 | 82547 | 421 |
2197199 | 2197199 | 2022-02-09 | Solano | California | 6095 | 82215 | 421 |
2197615 | 2197615 | 2022-02-09 | LaSalle | Illinois | 17099 | 27986 | 421 |
2200001 | 2200001 | 2022-02-09 | Richmond city | Virginia | 51760 | 42702 | 421 |
2194109 | 2194109 | 2022-02-08 | Bartow | Georgia | 13015 | 28182 | 421 |
2195618 | 2195618 | 2022-02-08 | Alamance | North Carolina | 37001 | 44641 | 421 |
2190855 | 2190855 | 2022-02-07 | Bartow | Georgia | 13015 | 28162 | 421 |
2192364 | 2192364 | 2022-02-07 | Alamance | North Carolina | 37001 | 44572 | 421 |
2193310 | 2193310 | 2022-02-07 | Tom Green | Texas | 48451 | 40296 | 421 |
2190056 | 2190056 | 2022-02-06 | Tom Green | Texas | 48451 | 40255 | 421 |
2172861 | 2172861 | 2022-02-01 | Cabarrus | North Carolina | 37025 | 52499 | 421 |
2170851 | 2170851 | 2022-01-31 | Brown | Wisconsin | 55009 | 80903 | 421 |
2155098 | 2155098 | 2022-01-27 | Coweta | Georgia | 13077 | 31339 | 421 |
2148968 | 2148968 | 2022-01-25 | Black Hawk | Iowa | 19013 | 29243 | 421 |
2145716 | 2145716 | 2022-01-24 | Black Hawk | Iowa | 19013 | 29243 | 421 |
2142461 | 2142461 | 2022-01-23 | Black Hawk | Iowa | 19013 | 29243 | 421 |
2139206 | 2139206 | 2022-01-22 | Black Hawk | Iowa | 19013 | 29243 | 421 |
2135950 | 2135950 | 2022-01-21 | Black Hawk | Iowa | 19013 | 29243 | 421 |
2137933 | 2137933 | 2022-01-21 | Maverick | Texas | 48323 | 17293 | 421 |
2132698 | 2132698 | 2022-01-20 | Black Hawk | Iowa | 19013 | 29243 | 421 |
2134679 | 2134679 | 2022-01-20 | Maverick | Texas | 48323 | 16832 | 421 |
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);