ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
217 rows where deaths = 655 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- New York 34
- Florida 25
- Georgia 17
- Washington 16
- California 14
- Texas 13
- New Hampshire 12
- Indiana 8
- Louisiana 8
- Alabama 7
- Iowa 7
- Oklahoma 7
- Pennsylvania 7
- Delaware 4
- Minnesota 4
- Ohio 4
- Massachusetts 3
- Michigan 3
- Nevada 3
- New Jersey 3
- Arkansas 2
- Colorado 2
- Missouri 2
- Arizona 1
- Connecticut 1
- District of Columbia 1
- Illinois 1
- Maryland 1
- North Carolina 1
- Oregon 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421774 | 2421774 | 2022-04-19 | Leon | Florida | 12073 | 84927 | 655 |
2418518 | 2418518 | 2022-04-18 | Leon | Florida | 12073 | 84927 | 655 |
2420024 | 2420024 | 2022-04-18 | Dutchess | New York | 36027 | 64672 | 655 |
2415262 | 2415262 | 2022-04-17 | Leon | Florida | 12073 | 84927 | 655 |
2416769 | 2416769 | 2022-04-17 | Dutchess | New York | 36027 | 64620 | 655 |
2412006 | 2412006 | 2022-04-16 | Leon | Florida | 12073 | 84927 | 655 |
2413513 | 2413513 | 2022-04-16 | Dutchess | New York | 36027 | 64574 | 655 |
2408750 | 2408750 | 2022-04-15 | Leon | Florida | 12073 | 84927 | 655 |
2410257 | 2410257 | 2022-04-15 | Dutchess | New York | 36027 | 64519 | 655 |
2405494 | 2405494 | 2022-04-14 | Leon | Florida | 12073 | 84927 | 655 |
2407001 | 2407001 | 2022-04-14 | Dutchess | New York | 36027 | 64454 | 655 |
2402239 | 2402239 | 2022-04-13 | Leon | Florida | 12073 | 84927 | 655 |
2403745 | 2403745 | 2022-04-13 | Dutchess | New York | 36027 | 64381 | 655 |
2400490 | 2400490 | 2022-04-12 | Dutchess | New York | 36027 | 64320 | 655 |
2397235 | 2397235 | 2022-04-11 | Dutchess | New York | 36027 | 64288 | 655 |
2393980 | 2393980 | 2022-04-10 | Dutchess | New York | 36027 | 64250 | 655 |
2390724 | 2390724 | 2022-04-09 | Dutchess | New York | 36027 | 64215 | 655 |
2387468 | 2387468 | 2022-04-08 | Dutchess | New York | 36027 | 64152 | 655 |
2384213 | 2384213 | 2022-04-07 | Dutchess | New York | 36027 | 64095 | 655 |
2380958 | 2380958 | 2022-04-06 | Dutchess | New York | 36027 | 64040 | 655 |
2376154 | 2376154 | 2022-04-05 | New London | Connecticut | 9011 | 54725 | 655 |
2377703 | 2377703 | 2022-04-05 | Dutchess | New York | 36027 | 63983 | 655 |
2374450 | 2374450 | 2022-04-04 | Dutchess | New York | 36027 | 63960 | 655 |
2371198 | 2371198 | 2022-04-03 | Dutchess | New York | 36027 | 63946 | 655 |
2367945 | 2367945 | 2022-04-02 | Dutchess | New York | 36027 | 63897 | 655 |
2364692 | 2364692 | 2022-04-01 | Dutchess | New York | 36027 | 63856 | 655 |
2361438 | 2361438 | 2022-03-31 | Dutchess | New York | 36027 | 63811 | 655 |
2358184 | 2358184 | 2022-03-30 | Dutchess | New York | 36027 | 63785 | 655 |
2354930 | 2354930 | 2022-03-29 | Dutchess | New York | 36027 | 63766 | 655 |
2351677 | 2351677 | 2022-03-28 | Dutchess | New York | 36027 | 63747 | 655 |
2348425 | 2348425 | 2022-03-27 | Dutchess | New York | 36027 | 63726 | 655 |
2345172 | 2345172 | 2022-03-26 | Dutchess | New York | 36027 | 63707 | 655 |
2341919 | 2341919 | 2022-03-25 | Dutchess | New York | 36027 | 63669 | 655 |
2338666 | 2338666 | 2022-03-24 | Dutchess | New York | 36027 | 63651 | 655 |
2335412 | 2335412 | 2022-03-23 | Dutchess | New York | 36027 | 63628 | 655 |
2332158 | 2332158 | 2022-03-22 | Dutchess | New York | 36027 | 63593 | 655 |
2328905 | 2328905 | 2022-03-21 | Dutchess | New York | 36027 | 63584 | 655 |
2325653 | 2325653 | 2022-03-20 | Dutchess | New York | 36027 | 63577 | 655 |
2304738 | 2304738 | 2022-03-14 | Henry | Georgia | 13151 | 57506 | 655 |
2301486 | 2301486 | 2022-03-13 | Henry | Georgia | 13151 | 57484 | 655 |
2298234 | 2298234 | 2022-03-12 | Henry | Georgia | 13151 | 57484 | 655 |
2294982 | 2294982 | 2022-03-11 | Henry | Georgia | 13151 | 57484 | 655 |
2291730 | 2291730 | 2022-03-10 | Henry | Georgia | 13151 | 57468 | 655 |
2278485 | 2278485 | 2022-03-06 | Santa Barbara | California | 6083 | 90039 | 655 |
2279539 | 2279539 | 2022-03-06 | Kalamazoo | Michigan | 26077 | 58435 | 655 |
2275232 | 2275232 | 2022-03-05 | Santa Barbara | California | 6083 | 90039 | 655 |
2276286 | 2276286 | 2022-03-05 | Kalamazoo | Michigan | 26077 | 58435 | 655 |
2271979 | 2271979 | 2022-03-04 | Santa Barbara | California | 6083 | 90039 | 655 |
2273033 | 2273033 | 2022-03-04 | Kalamazoo | Michigan | 26077 | 58435 | 655 |
2274470 | 2274470 | 2022-03-04 | Gregg | Texas | 48183 | 23040 | 655 |
2268727 | 2268727 | 2022-03-03 | Santa Barbara | California | 6083 | 89973 | 655 |
2261951 | 2261951 | 2022-02-28 | Racine | Wisconsin | 55101 | 55835 | 655 |
2244809 | 2244809 | 2022-02-23 | Schuylkill | Pennsylvania | 42107 | 34017 | 655 |
2241532 | 2241532 | 2022-02-22 | Franklin | Pennsylvania | 42055 | 39876 | 655 |
2238281 | 2238281 | 2022-02-21 | Franklin | Pennsylvania | 42055 | 39827 | 655 |
2235030 | 2235030 | 2022-02-20 | Franklin | Pennsylvania | 42055 | 39827 | 655 |
2219295 | 2219295 | 2022-02-15 | Potter | Texas | 48375 | 35028 | 655 |
2216044 | 2216044 | 2022-02-14 | Potter | Texas | 48375 | 34948 | 655 |
2197272 | 2197272 | 2022-02-09 | Weld | Colorado | 8123 | 78796 | 655 |
2196464 | 2196464 | 2022-02-08 | Johnson | Texas | 48251 | 40833 | 655 |
2177675 | 2177675 | 2022-02-03 | San Mateo | California | 6081 | 119227 | 655 |
2178606 | 2178606 | 2022-02-03 | Ouachita | Louisiana | 22073 | 48538 | 655 |
2174422 | 2174422 | 2022-02-02 | San Mateo | California | 6081 | 117617 | 655 |
2175353 | 2175353 | 2022-02-02 | Ouachita | Louisiana | 22073 | 48320 | 655 |
2171169 | 2171169 | 2022-02-01 | San Mateo | California | 6081 | 117062 | 655 |
2173995 | 2173995 | 2022-02-01 | Virginia Beach city | Virginia | 51810 | 85642 | 655 |
2167916 | 2167916 | 2022-01-31 | San Mateo | California | 6081 | 116728 | 655 |
2168820 | 2168820 | 2022-01-31 | Calcasieu | Louisiana | 22019 | 50378 | 655 |
2164661 | 2164661 | 2022-01-30 | San Mateo | California | 6081 | 114055 | 655 |
2165565 | 2165565 | 2022-01-30 | Calcasieu | Louisiana | 22019 | 50008 | 655 |
2161406 | 2161406 | 2022-01-29 | San Mateo | California | 6081 | 114055 | 655 |
2162310 | 2162310 | 2022-01-29 | Calcasieu | Louisiana | 22019 | 50008 | 655 |
2158150 | 2158150 | 2022-01-28 | San Mateo | California | 6081 | 114055 | 655 |
2159055 | 2159055 | 2022-01-28 | Calcasieu | Louisiana | 22019 | 50008 | 655 |
2147189 | 2147189 | 2022-01-24 | Butler | Pennsylvania | 42019 | 41094 | 655 |
2143935 | 2143935 | 2022-01-23 | Butler | Pennsylvania | 42019 | 40889 | 655 |
2140680 | 2140680 | 2022-01-22 | Butler | Pennsylvania | 42019 | 40712 | 655 |
2119608 | 2119608 | 2022-01-16 | Elkhart | Indiana | 18039 | 47414 | 655 |
2116356 | 2116356 | 2022-01-15 | Elkhart | Indiana | 18039 | 47414 | 655 |
2113105 | 2113105 | 2022-01-14 | Elkhart | Indiana | 18039 | 47414 | 655 |
2109853 | 2109853 | 2022-01-13 | Elkhart | Indiana | 18039 | 47050 | 655 |
2104792 | 2104792 | 2022-01-11 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2101541 | 2101541 | 2022-01-10 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2098290 | 2098290 | 2022-01-09 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2095038 | 2095038 | 2022-01-08 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2091786 | 2091786 | 2022-01-07 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2088534 | 2088534 | 2022-01-06 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2085283 | 2085283 | 2022-01-05 | Cleveland | Oklahoma | 40027 | 51360 | 655 |
2076675 | 2076675 | 2022-01-03 | Tuscaloosa | Alabama | 1125 | 38349 | 655 |
2073424 | 2073424 | 2022-01-02 | Tuscaloosa | Alabama | 1125 | 38186 | 655 |
2074709 | 2074709 | 2022-01-02 | Dakota | Minnesota | 27037 | 76390 | 655 |
2070173 | 2070173 | 2022-01-01 | Tuscaloosa | Alabama | 1125 | 37677 | 655 |
2071458 | 2071458 | 2022-01-01 | Dakota | Minnesota | 27037 | 76390 | 655 |
2066922 | 2066922 | 2021-12-31 | Tuscaloosa | Alabama | 1125 | 37677 | 655 |
2068207 | 2068207 | 2021-12-31 | Dakota | Minnesota | 27037 | 76390 | 655 |
2063672 | 2063672 | 2021-12-30 | Tuscaloosa | Alabama | 1125 | 37476 | 655 |
2064956 | 2064956 | 2021-12-30 | Dakota | Minnesota | 27037 | 76390 | 655 |
2060422 | 2060422 | 2021-12-29 | Tuscaloosa | Alabama | 1125 | 37227 | 655 |
2063265 | 2063265 | 2021-12-29 | Utah | Utah | 49049 | 143886 | 655 |
2063459 | 2063459 | 2021-12-29 | Yakima | Washington | 53077 | 48164 | 655 |
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);