ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
398 rows where deaths = 399 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 33
- Wisconsin 31
- Tennessee 29
- Pennsylvania 25
- Arkansas 22
- Ohio 22
- Indiana 20
- California 18
- Georgia 18
- Louisiana 14
- Colorado 12
- Florida 12
- North Carolina 12
- Illinois 11
- Oregon 11
- New York 10
- South Carolina 10
- New Jersey 8
- Iowa 7
- Maryland 7
- Mississippi 7
- Alabama 6
- Michigan 6
- Utah 6
- Virginia 5
- Connecticut 4
- Hawaii 4
- Minnesota 4
- Massachusetts 3
- Nebraska 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430946 | 2430946 | 2022-04-21 | Newport News city | Virginia | 51700 | 36453 | 399 |
2425884 | 2425884 | 2022-04-20 | Carroll | Maryland | 24013 | 21552 | 399 |
2422628 | 2422628 | 2022-04-19 | Carroll | Maryland | 24013 | 21544 | 399 |
2419372 | 2419372 | 2022-04-18 | Carroll | Maryland | 24013 | 21508 | 399 |
2416116 | 2416116 | 2022-04-17 | Carroll | Maryland | 24013 | 21487 | 399 |
2412860 | 2412860 | 2022-04-16 | Carroll | Maryland | 24013 | 21487 | 399 |
2409604 | 2409604 | 2022-04-15 | Carroll | Maryland | 24013 | 21487 | 399 |
2406348 | 2406348 | 2022-04-14 | Carroll | Maryland | 24013 | 21470 | 399 |
2402071 | 2402071 | 2022-04-13 | Butte | California | 6007 | 39693 | 399 |
2398816 | 2398816 | 2022-04-12 | Butte | California | 6007 | 39693 | 399 |
2401255 | 2401255 | 2022-04-12 | Williamson | Tennessee | 47187 | 61958 | 399 |
2395561 | 2395561 | 2022-04-11 | Butte | California | 6007 | 39693 | 399 |
2398000 | 2398000 | 2022-04-11 | Williamson | Tennessee | 47187 | 61958 | 399 |
2392305 | 2392305 | 2022-04-10 | Butte | California | 6007 | 39693 | 399 |
2394745 | 2394745 | 2022-04-10 | Williamson | Tennessee | 47187 | 61958 | 399 |
2389049 | 2389049 | 2022-04-09 | Butte | California | 6007 | 39693 | 399 |
2391489 | 2391489 | 2022-04-09 | Williamson | Tennessee | 47187 | 61958 | 399 |
2385794 | 2385794 | 2022-04-08 | Butte | California | 6007 | 39693 | 399 |
2388233 | 2388233 | 2022-04-08 | Williamson | Tennessee | 47187 | 61958 | 399 |
2384978 | 2384978 | 2022-04-07 | Williamson | Tennessee | 47187 | 61958 | 399 |
2381723 | 2381723 | 2022-04-06 | Williamson | Tennessee | 47187 | 61958 | 399 |
2342381 | 2342381 | 2022-03-25 | Somerset | Pennsylvania | 42111 | 18661 | 399 |
2339128 | 2339128 | 2022-03-24 | Somerset | Pennsylvania | 42111 | 18660 | 399 |
2339692 | 2339692 | 2022-03-24 | Davis | Utah | 49011 | 100025 | 399 |
2340006 | 2340006 | 2022-03-24 | Outagamie | Wisconsin | 55087 | 54133 | 399 |
2335874 | 2335874 | 2022-03-23 | Somerset | Pennsylvania | 42111 | 18659 | 399 |
2332620 | 2332620 | 2022-03-22 | Somerset | Pennsylvania | 42111 | 18659 | 399 |
2332834 | 2332834 | 2022-03-22 | Bradley | Tennessee | 47011 | 33047 | 399 |
2333394 | 2333394 | 2022-03-22 | Thurston | Washington | 53067 | 46227 | 399 |
2329581 | 2329581 | 2022-03-21 | Bradley | Tennessee | 47011 | 33047 | 399 |
2330140 | 2330140 | 2022-03-21 | Thurston | Washington | 53067 | 46227 | 399 |
2324307 | 2324307 | 2022-03-20 | Spalding | Georgia | 13255 | 15793 | 399 |
2326329 | 2326329 | 2022-03-20 | Bradley | Tennessee | 47011 | 33047 | 399 |
2321053 | 2321053 | 2022-03-19 | Spalding | Georgia | 13255 | 15793 | 399 |
2323076 | 2323076 | 2022-03-19 | Bradley | Tennessee | 47011 | 33047 | 399 |
2317799 | 2317799 | 2022-03-18 | Spalding | Georgia | 13255 | 15793 | 399 |
2319822 | 2319822 | 2022-03-18 | Bradley | Tennessee | 47011 | 33047 | 399 |
2314546 | 2314546 | 2022-03-17 | Spalding | Georgia | 13255 | 15793 | 399 |
2316013 | 2316013 | 2022-03-17 | Randolph | North Carolina | 37151 | 35349 | 399 |
2316568 | 2316568 | 2022-03-17 | Bradley | Tennessee | 47011 | 33047 | 399 |
2316804 | 2316804 | 2022-03-17 | Liberty | Texas | 48291 | 17669 | 399 |
2312760 | 2312760 | 2022-03-16 | Randolph | North Carolina | 37151 | 35342 | 399 |
2313315 | 2313315 | 2022-03-16 | Bradley | Tennessee | 47011 | 33047 | 399 |
2313551 | 2313551 | 2022-03-16 | Liberty | Texas | 48291 | 17640 | 399 |
2310061 | 2310061 | 2022-03-15 | Blount | Tennessee | 47009 | 38940 | 399 |
2306808 | 2306808 | 2022-03-14 | Blount | Tennessee | 47009 | 38940 | 399 |
2303557 | 2303557 | 2022-03-13 | Blount | Tennessee | 47009 | 38940 | 399 |
2300305 | 2300305 | 2022-03-12 | Blount | Tennessee | 47009 | 38940 | 399 |
2297053 | 2297053 | 2022-03-11 | Blount | Tennessee | 47009 | 38940 | 399 |
2293801 | 2293801 | 2022-03-10 | Blount | Tennessee | 47009 | 38940 | 399 |
2290549 | 2290549 | 2022-03-09 | Blount | Tennessee | 47009 | 38940 | 399 |
2266416 | 2266416 | 2022-03-02 | St. Landry | Louisiana | 22097 | 22089 | 399 |
2251638 | 2251638 | 2022-02-25 | Brazos | Texas | 48041 | 59587 | 399 |
2251852 | 2251852 | 2022-02-25 | Victoria | Texas | 48469 | 18365 | 399 |
2248601 | 2248601 | 2022-02-24 | Victoria | Texas | 48469 | 18350 | 399 |
2243719 | 2243719 | 2022-02-23 | Berkshire | Massachusetts | 25003 | 22364 | 399 |
2241883 | 2241883 | 2022-02-22 | Bowie | Texas | 48037 | 19296 | 399 |
2237163 | 2237163 | 2022-02-21 | Terrebonne | Louisiana | 22109 | 30568 | 399 |
2238897 | 2238897 | 2022-02-21 | Weber | Utah | 49057 | 70220 | 399 |
2235646 | 2235646 | 2022-02-20 | Weber | Utah | 49057 | 70220 | 399 |
2232395 | 2232395 | 2022-02-19 | Weber | Utah | 49057 | 70220 | 399 |
2229144 | 2229144 | 2022-02-18 | Weber | Utah | 49057 | 70220 | 399 |
2223483 | 2223483 | 2022-02-17 | Paulding | Georgia | 13223 | 37545 | 399 |
2217717 | 2217717 | 2022-02-15 | Hampshire | Massachusetts | 25015 | 25845 | 399 |
2211935 | 2211935 | 2022-02-13 | Johnston | North Carolina | 37101 | 56259 | 399 |
2208682 | 2208682 | 2022-02-12 | Johnston | North Carolina | 37101 | 56259 | 399 |
2205429 | 2205429 | 2022-02-11 | Johnston | North Carolina | 37101 | 56259 | 399 |
2193772 | 2193772 | 2022-02-08 | Walker | Alabama | 1127 | 17974 | 399 |
2190519 | 2190519 | 2022-02-07 | Walker | Alabama | 1127 | 17865 | 399 |
2190869 | 2190869 | 2022-02-07 | Carroll | Georgia | 13045 | 23267 | 399 |
2187266 | 2187266 | 2022-02-06 | Walker | Alabama | 1127 | 17819 | 399 |
2188929 | 2188929 | 2022-02-06 | Lancaster | Nebraska | 31109 | 71694 | 399 |
2184013 | 2184013 | 2022-02-05 | Walker | Alabama | 1127 | 17819 | 399 |
2185676 | 2185676 | 2022-02-05 | Lancaster | Nebraska | 31109 | 71694 | 399 |
2180761 | 2180761 | 2022-02-04 | Walker | Alabama | 1127 | 17800 | 399 |
2182424 | 2182424 | 2022-02-04 | Lancaster | Nebraska | 31109 | 71694 | 399 |
2179873 | 2179873 | 2022-02-03 | Berkeley | South Carolina | 45015 | 49277 | 399 |
2174692 | 2174692 | 2022-02-02 | Newton | Georgia | 13217 | 23693 | 399 |
2171439 | 2171439 | 2022-02-01 | Newton | Georgia | 13217 | 23654 | 399 |
2173851 | 2173851 | 2022-02-01 | Washington | Utah | 49053 | 42699 | 399 |
2164697 | 2164697 | 2022-01-30 | Douglas | Colorado | 8035 | 72417 | 399 |
2165156 | 2165156 | 2022-01-30 | Delaware | Indiana | 18035 | 23088 | 399 |
2161442 | 2161442 | 2022-01-29 | Douglas | Colorado | 8035 | 72417 | 399 |
2161901 | 2161901 | 2022-01-29 | Delaware | Indiana | 18035 | 23088 | 399 |
2158186 | 2158186 | 2022-01-28 | Douglas | Colorado | 8035 | 72417 | 399 |
2158646 | 2158646 | 2022-01-28 | Delaware | Indiana | 18035 | 23088 | 399 |
2154933 | 2154933 | 2022-01-27 | Douglas | Colorado | 8035 | 71574 | 399 |
2156115 | 2156115 | 2022-01-27 | Jackson | Mississippi | 28059 | 33567 | 399 |
2151651 | 2151651 | 2022-01-26 | Solano | California | 6095 | 72107 | 399 |
2151680 | 2151680 | 2022-01-26 | Douglas | Colorado | 8035 | 71574 | 399 |
2152155 | 2152155 | 2022-01-26 | Howard | Indiana | 18067 | 23568 | 399 |
2148563 | 2148563 | 2022-01-25 | Bartow | Georgia | 13015 | 27104 | 399 |
2145311 | 2145311 | 2022-01-24 | Bartow | Georgia | 13015 | 26997 | 399 |
2144822 | 2144822 | 2022-01-23 | Brown | Wisconsin | 55009 | 76905 | 399 |
2141567 | 2141567 | 2022-01-22 | Brown | Wisconsin | 55009 | 76905 | 399 |
2138311 | 2138311 | 2022-01-21 | Brown | Wisconsin | 55009 | 76905 | 399 |
2124214 | 2124214 | 2022-01-17 | Columbiana | Ohio | 39029 | 22095 | 399 |
2120962 | 2120962 | 2022-01-16 | Columbiana | Ohio | 39029 | 21919 | 399 |
2117710 | 2117710 | 2022-01-15 | Columbiana | Ohio | 39029 | 21711 | 399 |
2114459 | 2114459 | 2022-01-14 | Columbiana | Ohio | 39029 | 21198 | 399 |
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);