ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
236 rows where deaths = 620 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 35
- Virginia 23
- Missouri 17
- Texas 15
- South Carolina 13
- Arkansas 12
- Indiana 12
- Alabama 10
- California 10
- Oregon 9
- New York 8
- Ohio 8
- Wisconsin 8
- Pennsylvania 6
- Colorado 5
- Louisiana 5
- New Jersey 5
- Washington 5
- Georgia 4
- Michigan 4
- Tennessee 4
- Delaware 3
- Maryland 3
- Illinois 2
- Arizona 1
- District of Columbia 1
- Hawaii 1
- Idaho 1
- Kansas 1
- Massachusetts 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499758 | 2499758 | 2022-05-13 | Washington | Arkansas | 5143 | 68841 | 620 |
2496500 | 2496500 | 2022-05-12 | Washington | Arkansas | 5143 | 68783 | 620 |
2493242 | 2493242 | 2022-05-11 | Washington | Arkansas | 5143 | 68746 | 620 |
2489984 | 2489984 | 2022-05-10 | Washington | Arkansas | 5143 | 68729 | 620 |
2490178 | 2490178 | 2022-05-10 | Santa Rosa | Florida | 12113 | 48592 | 620 |
2486727 | 2486727 | 2022-05-09 | Washington | Arkansas | 5143 | 68693 | 620 |
2486921 | 2486921 | 2022-05-09 | Santa Rosa | Florida | 12113 | 48592 | 620 |
2483469 | 2483469 | 2022-05-08 | Washington | Arkansas | 5143 | 68687 | 620 |
2483663 | 2483663 | 2022-05-08 | Santa Rosa | Florida | 12113 | 48592 | 620 |
2480211 | 2480211 | 2022-05-07 | Washington | Arkansas | 5143 | 68669 | 620 |
2480405 | 2480405 | 2022-05-07 | Santa Rosa | Florida | 12113 | 48592 | 620 |
2476953 | 2476953 | 2022-05-06 | Washington | Arkansas | 5143 | 68643 | 620 |
2477147 | 2477147 | 2022-05-06 | Santa Rosa | Florida | 12113 | 48592 | 620 |
2473695 | 2473695 | 2022-05-05 | Washington | Arkansas | 5143 | 68619 | 620 |
2473889 | 2473889 | 2022-05-05 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2470632 | 2470632 | 2022-05-04 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2467376 | 2467376 | 2022-05-03 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2464121 | 2464121 | 2022-05-02 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2460671 | 2460671 | 2022-05-01 | Washington | Arkansas | 5143 | 68526 | 620 |
2460865 | 2460865 | 2022-05-01 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2457609 | 2457609 | 2022-04-30 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2454353 | 2454353 | 2022-04-29 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2451097 | 2451097 | 2022-04-28 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2447841 | 2447841 | 2022-04-27 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2424889 | 2424889 | 2022-04-20 | Placer | California | 6061 | 70301 | 620 |
2421633 | 2421633 | 2022-04-19 | Placer | California | 6061 | 70301 | 620 |
2418377 | 2418377 | 2022-04-18 | Placer | California | 6061 | 70255 | 620 |
2420397 | 2420397 | 2022-04-18 | Clackamas | Oregon | 41005 | 60494 | 620 |
2415121 | 2415121 | 2022-04-17 | Placer | California | 6061 | 70255 | 620 |
2417142 | 2417142 | 2022-04-17 | Clackamas | Oregon | 41005 | 60494 | 620 |
2411865 | 2411865 | 2022-04-16 | Placer | California | 6061 | 70255 | 620 |
2413886 | 2413886 | 2022-04-16 | Clackamas | Oregon | 41005 | 60494 | 620 |
2408609 | 2408609 | 2022-04-15 | Placer | California | 6061 | 70255 | 620 |
2410630 | 2410630 | 2022-04-15 | Clackamas | Oregon | 41005 | 60494 | 620 |
2405353 | 2405353 | 2022-04-14 | Placer | California | 6061 | 70224 | 620 |
2405554 | 2405554 | 2022-04-14 | Cherokee | Georgia | 13057 | 63318 | 620 |
2402098 | 2402098 | 2022-04-13 | Placer | California | 6061 | 70188 | 620 |
2398633 | 2398633 | 2022-04-12 | Calhoun | Alabama | 1015 | 32360 | 620 |
2399044 | 2399044 | 2022-04-12 | Cherokee | Georgia | 13057 | 63285 | 620 |
2395378 | 2395378 | 2022-04-11 | Calhoun | Alabama | 1015 | 32359 | 620 |
2392122 | 2392122 | 2022-04-10 | Calhoun | Alabama | 1015 | 32355 | 620 |
2388866 | 2388866 | 2022-04-09 | Calhoun | Alabama | 1015 | 32355 | 620 |
2385611 | 2385611 | 2022-04-08 | Calhoun | Alabama | 1015 | 32355 | 620 |
2382356 | 2382356 | 2022-04-07 | Calhoun | Alabama | 1015 | 32355 | 620 |
2379101 | 2379101 | 2022-04-06 | Calhoun | Alabama | 1015 | 32358 | 620 |
2352256 | 2352256 | 2022-03-28 | Florence | South Carolina | 45041 | 41676 | 620 |
2349004 | 2349004 | 2022-03-27 | Florence | South Carolina | 45041 | 41676 | 620 |
2345751 | 2345751 | 2022-03-26 | Florence | South Carolina | 45041 | 41676 | 620 |
2342498 | 2342498 | 2022-03-25 | Florence | South Carolina | 45041 | 41676 | 620 |
2339245 | 2339245 | 2022-03-24 | Florence | South Carolina | 45041 | 41676 | 620 |
2335991 | 2335991 | 2022-03-23 | Florence | South Carolina | 45041 | 41676 | 620 |
2336738 | 2336738 | 2022-03-23 | Kenosha | Wisconsin | 55059 | 43852 | 620 |
2332737 | 2332737 | 2022-03-22 | Florence | South Carolina | 45041 | 41676 | 620 |
2333015 | 2333015 | 2022-03-22 | Grayson | Texas | 48181 | 27066 | 620 |
2333484 | 2333484 | 2022-03-22 | Kenosha | Wisconsin | 55059 | 43842 | 620 |
2329762 | 2329762 | 2022-03-21 | Grayson | Texas | 48181 | 27064 | 620 |
2326510 | 2326510 | 2022-03-20 | Grayson | Texas | 48181 | 27063 | 620 |
2323257 | 2323257 | 2022-03-19 | Grayson | Texas | 48181 | 27053 | 620 |
2320003 | 2320003 | 2022-03-18 | Grayson | Texas | 48181 | 27052 | 620 |
2316749 | 2316749 | 2022-03-17 | Grayson | Texas | 48181 | 27050 | 620 |
2307882 | 2307882 | 2022-03-15 | Leon | Florida | 12073 | 84655 | 620 |
2304631 | 2304631 | 2022-03-14 | Leon | Florida | 12073 | 84655 | 620 |
2306712 | 2306712 | 2022-03-14 | Florence | South Carolina | 45041 | 41630 | 620 |
2301379 | 2301379 | 2022-03-13 | Leon | Florida | 12073 | 84655 | 620 |
2303461 | 2303461 | 2022-03-13 | Florence | South Carolina | 45041 | 41630 | 620 |
2298127 | 2298127 | 2022-03-12 | Leon | Florida | 12073 | 84655 | 620 |
2300209 | 2300209 | 2022-03-12 | Florence | South Carolina | 45041 | 41630 | 620 |
2294875 | 2294875 | 2022-03-11 | Leon | Florida | 12073 | 84655 | 620 |
2296957 | 2296957 | 2022-03-11 | Florence | South Carolina | 45041 | 41630 | 620 |
2297235 | 2297235 | 2022-03-11 | Grayson | Texas | 48181 | 27037 | 620 |
2291623 | 2291623 | 2022-03-10 | Leon | Florida | 12073 | 84539 | 620 |
2292051 | 2292051 | 2022-03-10 | Vanderburgh | Indiana | 18163 | 57121 | 620 |
2293705 | 2293705 | 2022-03-10 | Florence | South Carolina | 45041 | 41626 | 620 |
2293730 | 2293730 | 2022-03-10 | York | South Carolina | 45091 | 77305 | 620 |
2293983 | 2293983 | 2022-03-10 | Grayson | Texas | 48181 | 27029 | 620 |
2288371 | 2288371 | 2022-03-09 | Leon | Florida | 12073 | 84539 | 620 |
2288799 | 2288799 | 2022-03-09 | Vanderburgh | Indiana | 18163 | 57108 | 620 |
2247044 | 2247044 | 2022-02-24 | Muskegon | Michigan | 26121 | 41219 | 620 |
2243793 | 2243793 | 2022-02-23 | Muskegon | Michigan | 26121 | 41219 | 620 |
2213982 | 2213982 | 2022-02-14 | Madison | Indiana | 18095 | 32255 | 620 |
2210711 | 2210711 | 2022-02-13 | Hamilton | Indiana | 18057 | 80297 | 620 |
2207458 | 2207458 | 2022-02-12 | Hamilton | Indiana | 18057 | 80297 | 620 |
2204205 | 2204205 | 2022-02-11 | Hamilton | Indiana | 18057 | 80297 | 620 |
2189064 | 2189064 | 2022-02-06 | Dutchess | New York | 36027 | 62229 | 620 |
2185811 | 2185811 | 2022-02-05 | Dutchess | New York | 36027 | 62194 | 620 |
2182559 | 2182559 | 2022-02-04 | Dutchess | New York | 36027 | 62088 | 620 |
2173236 | 2173236 | 2022-02-01 | Franklin | Pennsylvania | 42055 | 38730 | 620 |
2151988 | 2151988 | 2022-01-26 | Canyon | Idaho | 16027 | 51541 | 620 |
2145220 | 2145220 | 2022-01-24 | Weld | Colorado | 8123 | 73945 | 620 |
2144690 | 2144690 | 2022-01-23 | Prince William | Virginia | 51153 | 87400 | 620 |
2141435 | 2141435 | 2022-01-22 | Prince William | Virginia | 51153 | 87400 | 620 |
2138179 | 2138179 | 2022-01-21 | Prince William | Virginia | 51153 | 87400 | 620 |
2134925 | 2134925 | 2022-01-20 | Prince William | Virginia | 51153 | 86761 | 620 |
2131673 | 2131673 | 2022-01-19 | Prince William | Virginia | 51153 | 86275 | 620 |
2128419 | 2128419 | 2022-01-18 | Prince William | Virginia | 51153 | 85354 | 620 |
2124888 | 2124888 | 2022-01-17 | Johnson | Texas | 48251 | 36294 | 620 |
2125166 | 2125166 | 2022-01-17 | Prince William | Virginia | 51153 | 84476 | 620 |
2121636 | 2121636 | 2022-01-16 | Johnson | Texas | 48251 | 35798 | 620 |
2121914 | 2121914 | 2022-01-16 | Prince William | Virginia | 51153 | 82684 | 620 |
2118662 | 2118662 | 2022-01-15 | Prince William | Virginia | 51153 | 82684 | 620 |
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);