ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
480 rows where deaths = 359 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 72
- Georgia 29
- Virginia 29
- Alabama 26
- Indiana 23
- New York 22
- North Carolina 22
- Michigan 21
- Florida 20
- Colorado 18
- Pennsylvania 17
- Maryland 15
- South Carolina 14
- California 13
- Ohio 12
- Illinois 11
- Mississippi 11
- Tennessee 11
- Arizona 8
- Kentucky 8
- New Jersey 8
- Wisconsin 8
- Iowa 7
- Kansas 7
- Hawaii 6
- Utah 6
- West Virginia 6
- Connecticut 5
- Arkansas 4
- Oregon 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499914 | 2499914 | 2022-05-13 | Flagler | Florida | 12035 | 22651 | 359 |
2496656 | 2496656 | 2022-05-12 | Flagler | Florida | 12035 | 22651 | 359 |
2496868 | 2496868 | 2022-05-12 | Unknown | Guam | 49438 | 359 | |
2493398 | 2493398 | 2022-05-11 | Flagler | Florida | 12035 | 22651 | 359 |
2493610 | 2493610 | 2022-05-11 | Unknown | Guam | 49400 | 359 | |
2490352 | 2490352 | 2022-05-10 | Unknown | Guam | 49370 | 359 | |
2464935 | 2464935 | 2022-05-02 | Cumberland | Maine | 23005 | 50428 | 359 |
2422622 | 2422622 | 2022-04-19 | Allegany | Maryland | 24001 | 17149 | 359 |
2419366 | 2419366 | 2022-04-18 | Allegany | Maryland | 24001 | 17145 | 359 |
2416110 | 2416110 | 2022-04-17 | Allegany | Maryland | 24001 | 17141 | 359 |
2412854 | 2412854 | 2022-04-16 | Allegany | Maryland | 24001 | 17141 | 359 |
2409598 | 2409598 | 2022-04-15 | Allegany | Maryland | 24001 | 17141 | 359 |
2406342 | 2406342 | 2022-04-14 | Allegany | Maryland | 24001 | 17138 | 359 |
2403086 | 2403086 | 2022-04-13 | Allegany | Maryland | 24001 | 17133 | 359 |
2374856 | 2374856 | 2022-04-04 | Adams | Pennsylvania | 42001 | 24709 | 359 |
2352853 | 2352853 | 2022-03-28 | Roanoke city | Virginia | 51770 | 21111 | 359 |
2349601 | 2349601 | 2022-03-27 | Roanoke city | Virginia | 51770 | 21099 | 359 |
2346348 | 2346348 | 2022-03-26 | Roanoke city | Virginia | 51770 | 21099 | 359 |
2342801 | 2342801 | 2022-03-25 | Hunt | Texas | 48231 | 15730 | 359 |
2343095 | 2343095 | 2022-03-25 | Roanoke city | Virginia | 51770 | 21099 | 359 |
2339548 | 2339548 | 2022-03-24 | Hunt | Texas | 48231 | 15729 | 359 |
2336294 | 2336294 | 2022-03-23 | Hunt | Texas | 48231 | 15727 | 359 |
2333040 | 2333040 | 2022-03-22 | Hunt | Texas | 48231 | 15723 | 359 |
2329787 | 2329787 | 2022-03-21 | Hunt | Texas | 48231 | 15723 | 359 |
2326535 | 2326535 | 2022-03-20 | Hunt | Texas | 48231 | 15722 | 359 |
2323282 | 2323282 | 2022-03-19 | Hunt | Texas | 48231 | 15713 | 359 |
2320028 | 2320028 | 2022-03-18 | Hunt | Texas | 48231 | 15712 | 359 |
2314051 | 2314051 | 2022-03-17 | Cullman | Alabama | 1043 | 24479 | 359 |
2310798 | 2310798 | 2022-03-16 | Cullman | Alabama | 1043 | 24477 | 359 |
2307545 | 2307545 | 2022-03-15 | Cullman | Alabama | 1043 | 24477 | 359 |
2307623 | 2307623 | 2022-03-15 | Gila | Arizona | 4007 | 16889 | 359 |
2304372 | 2304372 | 2022-03-14 | Gila | Arizona | 4007 | 16889 | 359 |
2301120 | 2301120 | 2022-03-13 | Gila | Arizona | 4007 | 16889 | 359 |
2302474 | 2302474 | 2022-03-13 | Lauderdale | Mississippi | 28075 | 18719 | 359 |
2297868 | 2297868 | 2022-03-12 | Gila | Arizona | 4007 | 16889 | 359 |
2299222 | 2299222 | 2022-03-12 | Lauderdale | Mississippi | 28075 | 18719 | 359 |
2294616 | 2294616 | 2022-03-11 | Gila | Arizona | 4007 | 16889 | 359 |
2295970 | 2295970 | 2022-03-11 | Lauderdale | Mississippi | 28075 | 18719 | 359 |
2291364 | 2291364 | 2022-03-10 | Gila | Arizona | 4007 | 16889 | 359 |
2292718 | 2292718 | 2022-03-10 | Lauderdale | Mississippi | 28075 | 18719 | 359 |
2288112 | 2288112 | 2022-03-09 | Gila | Arizona | 4007 | 16889 | 359 |
2289466 | 2289466 | 2022-03-09 | Lauderdale | Mississippi | 28075 | 18719 | 359 |
2291120 | 2291120 | 2022-03-09 | Cabell | West Virginia | 54011 | 27185 | 359 |
2286215 | 2286215 | 2022-03-08 | Lauderdale | Mississippi | 28075 | 18719 | 359 |
2282963 | 2282963 | 2022-03-07 | Lauderdale | Mississippi | 28075 | 18717 | 359 |
2279288 | 2279288 | 2022-03-06 | Daviess | Kentucky | 21059 | 30831 | 359 |
2279710 | 2279710 | 2022-03-06 | Lauderdale | Mississippi | 28075 | 18712 | 359 |
2276035 | 2276035 | 2022-03-05 | Daviess | Kentucky | 21059 | 30831 | 359 |
2276457 | 2276457 | 2022-03-05 | Lauderdale | Mississippi | 28075 | 18712 | 359 |
2272782 | 2272782 | 2022-03-04 | Daviess | Kentucky | 21059 | 30831 | 359 |
2273204 | 2273204 | 2022-03-04 | Lauderdale | Mississippi | 28075 | 18712 | 359 |
2273651 | 2273651 | 2022-03-04 | Ulster | New York | 36111 | 30874 | 359 |
2269650 | 2269650 | 2022-03-03 | Lafourche | Louisiana | 22057 | 27630 | 359 |
2270398 | 2270398 | 2022-03-03 | Ulster | New York | 36111 | 30874 | 359 |
2271725 | 2271725 | 2022-03-03 | Winnebago | Wisconsin | 55139 | 51128 | 359 |
2266397 | 2266397 | 2022-03-02 | Lafourche | Louisiana | 22057 | 27618 | 359 |
2267146 | 2267146 | 2022-03-02 | Ulster | New York | 36111 | 30839 | 359 |
2263894 | 2263894 | 2022-03-01 | Ulster | New York | 36111 | 30826 | 359 |
2260643 | 2260643 | 2022-02-28 | Ulster | New York | 36111 | 30812 | 359 |
2261743 | 2261743 | 2022-02-28 | Loudoun | Virginia | 51107 | 65331 | 359 |
2257392 | 2257392 | 2022-02-27 | Ulster | New York | 36111 | 30799 | 359 |
2254141 | 2254141 | 2022-02-26 | Ulster | New York | 36111 | 30780 | 359 |
2250890 | 2250890 | 2022-02-25 | Ulster | New York | 36111 | 30750 | 359 |
2247639 | 2247639 | 2022-02-24 | Ulster | New York | 36111 | 30718 | 359 |
2248201 | 2248201 | 2022-02-24 | Sumter | South Carolina | 45085 | 27461 | 359 |
2244388 | 2244388 | 2022-02-23 | Ulster | New York | 36111 | 30684 | 359 |
2244950 | 2244950 | 2022-02-23 | Sumter | South Carolina | 45085 | 27417 | 359 |
2239285 | 2239285 | 2022-02-22 | Marshall | Alabama | 1095 | 27053 | 359 |
2240455 | 2240455 | 2022-02-22 | Howard | Maryland | 24027 | 42775 | 359 |
2241137 | 2241137 | 2022-02-22 | Ulster | New York | 36111 | 30663 | 359 |
2241699 | 2241699 | 2022-02-22 | Sumter | South Carolina | 45085 | 27408 | 359 |
2242251 | 2242251 | 2022-02-22 | Newport News city | Virginia | 51700 | 35720 | 359 |
2236034 | 2236034 | 2022-02-21 | Marshall | Alabama | 1095 | 27047 | 359 |
2238227 | 2238227 | 2022-02-21 | Douglas | Oregon | 41019 | 19137 | 359 |
2232783 | 2232783 | 2022-02-20 | Marshall | Alabama | 1095 | 27039 | 359 |
2234976 | 2234976 | 2022-02-20 | Douglas | Oregon | 41019 | 19137 | 359 |
2229532 | 2229532 | 2022-02-19 | Marshall | Alabama | 1095 | 27029 | 359 |
2231725 | 2231725 | 2022-02-19 | Douglas | Oregon | 41019 | 19137 | 359 |
2226272 | 2226272 | 2022-02-18 | Lauderdale | Alabama | 1077 | 23722 | 359 |
2228474 | 2228474 | 2022-02-18 | Douglas | Oregon | 41019 | 19137 | 359 |
2223514 | 2223514 | 2022-02-17 | Troup | Georgia | 13285 | 15307 | 359 |
2217128 | 2217128 | 2022-02-15 | Kankakee | Illinois | 17091 | 28407 | 359 |
2213877 | 2213877 | 2022-02-14 | Kankakee | Illinois | 17091 | 28387 | 359 |
2200409 | 2200409 | 2022-02-10 | Butte | California | 6007 | 37734 | 359 |
2197155 | 2197155 | 2022-02-09 | Butte | California | 6007 | 37546 | 359 |
2194589 | 2194589 | 2022-02-08 | Scott | Iowa | 19163 | 39182 | 359 |
2191335 | 2191335 | 2022-02-07 | Scott | Iowa | 19163 | 39182 | 359 |
2188082 | 2188082 | 2022-02-06 | Scott | Iowa | 19163 | 39182 | 359 |
2189205 | 2189205 | 2022-02-06 | Wayne | North Carolina | 37191 | 26471 | 359 |
2184829 | 2184829 | 2022-02-05 | Scott | Iowa | 19163 | 39182 | 359 |
2185952 | 2185952 | 2022-02-05 | Wayne | North Carolina | 37191 | 26471 | 359 |
2181577 | 2181577 | 2022-02-04 | Scott | Iowa | 19163 | 39182 | 359 |
2182700 | 2182700 | 2022-02-04 | Wayne | North Carolina | 37191 | 26471 | 359 |
2178326 | 2178326 | 2022-02-03 | Scott | Iowa | 19163 | 39182 | 359 |
2179448 | 2179448 | 2022-02-03 | Wayne | North Carolina | 37191 | 26360 | 359 |
2175073 | 2175073 | 2022-02-02 | Scott | Iowa | 19163 | 39182 | 359 |
2176916 | 2176916 | 2022-02-02 | Guadalupe | Texas | 48187 | 34510 | 359 |
2171656 | 2171656 | 2022-02-01 | Clark | Indiana | 18019 | 29016 | 359 |
2173662 | 2173662 | 2022-02-01 | Guadalupe | Texas | 48187 | 34378 | 359 |
2164950 | 2164950 | 2022-01-30 | Spalding | Georgia | 13255 | 15115 | 359 |
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);