ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
394 rows where cases = 1468 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 55
- Texas 26
- Kentucky 20
- Virginia 20
- Georgia 18
- Wisconsin 18
- Iowa 17
- Indiana 15
- North Carolina 14
- Puerto Rico 14
- New Mexico 12
- Illinois 10
- Missouri 10
- West Virginia 10
- Tennessee 9
- California 8
- Michigan 8
- Mississippi 8
- North Dakota 8
- Oklahoma 8
- South Dakota 8
- Nebraska 7
- Alabama 6
- Colorado 6
- Louisiana 6
- Oregon 6
- Arkansas 5
- Montana 5
- Idaho 4
- New York 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2456363 | 2456363 | 2022-04-29 | Maunabo | Puerto Rico | 72095 | 1468 | |
2418090 | 2418090 | 2022-04-17 | Iron | Wisconsin | 55051 | 1468 | 47 |
2414834 | 2414834 | 2022-04-16 | Iron | Wisconsin | 55051 | 1468 | 47 |
2411578 | 2411578 | 2022-04-15 | Iron | Wisconsin | 55051 | 1468 | 47 |
2408322 | 2408322 | 2022-04-14 | Iron | Wisconsin | 55051 | 1468 | 47 |
2403235 | 2403235 | 2022-04-13 | Grant | Minnesota | 27051 | 1468 | 12 |
2405066 | 2405066 | 2022-04-13 | Iron | Wisconsin | 55051 | 1468 | 47 |
2399981 | 2399981 | 2022-04-12 | Grant | Minnesota | 27051 | 1468 | 12 |
2401811 | 2401811 | 2022-04-12 | Iron | Wisconsin | 55051 | 1468 | 47 |
2398556 | 2398556 | 2022-04-11 | Iron | Wisconsin | 55051 | 1468 | 47 |
2395301 | 2395301 | 2022-04-10 | Iron | Wisconsin | 55051 | 1468 | 47 |
2392045 | 2392045 | 2022-04-09 | Iron | Wisconsin | 55051 | 1468 | 47 |
2388789 | 2388789 | 2022-04-08 | Iron | Wisconsin | 55051 | 1468 | 47 |
2294059 | 2294059 | 2022-03-10 | Mills | Texas | 48333 | 1468 | 34 |
2289839 | 2289839 | 2022-03-09 | Guadalupe | New Mexico | 35019 | 1468 | 17 |
2290807 | 2290807 | 2022-03-09 | Mills | Texas | 48333 | 1468 | 34 |
2286587 | 2286587 | 2022-03-08 | Guadalupe | New Mexico | 35019 | 1468 | 17 |
2283335 | 2283335 | 2022-03-07 | Guadalupe | New Mexico | 35019 | 1468 | 17 |
2260125 | 2260125 | 2022-02-28 | Norman | Minnesota | 27107 | 1468 | 13 |
2248399 | 2248399 | 2022-02-24 | Carson | Texas | 48065 | 1468 | 34 |
2237721 | 2237721 | 2022-02-21 | Nemaha | Nebraska | 31127 | 1468 | 19 |
2228979 | 2228979 | 2022-02-18 | Jack | Texas | 48237 | 1468 | 27 |
2217053 | 2217053 | 2022-02-15 | Caribou | Idaho | 16029 | 1468 | 25 |
2217077 | 2217077 | 2022-02-15 | Power | Idaho | 16077 | 1468 | 18 |
2217304 | 2217304 | 2022-02-15 | Decatur | Iowa | 19053 | 1468 | 22 |
2218523 | 2218523 | 2022-02-15 | Ransom | North Dakota | 38073 | 1468 | 27 |
2214053 | 2214053 | 2022-02-14 | Decatur | Iowa | 19053 | 1468 | 22 |
2210667 | 2210667 | 2022-02-13 | Stark | Illinois | 17175 | 1468 | 32 |
2210801 | 2210801 | 2022-02-13 | Decatur | Iowa | 19053 | 1468 | 22 |
2207414 | 2207414 | 2022-02-12 | Stark | Illinois | 17175 | 1468 | 32 |
2207548 | 2207548 | 2022-02-12 | Decatur | Iowa | 19053 | 1468 | 22 |
2204161 | 2204161 | 2022-02-11 | Stark | Illinois | 17175 | 1468 | 32 |
2204295 | 2204295 | 2022-02-11 | Decatur | Iowa | 19053 | 1468 | 22 |
2200908 | 2200908 | 2022-02-10 | Stark | Illinois | 17175 | 1468 | 32 |
2201042 | 2201042 | 2022-02-10 | Decatur | Iowa | 19053 | 1468 | 22 |
2197654 | 2197654 | 2022-02-09 | Stark | Illinois | 17175 | 1468 | 32 |
2197788 | 2197788 | 2022-02-09 | Decatur | Iowa | 19053 | 1468 | 22 |
2190712 | 2190712 | 2022-02-07 | Clear Creek | Colorado | 8019 | 1468 | 10 |
2190943 | 2190943 | 2022-02-07 | Marion | Georgia | 13197 | 1468 | 43 |
2166445 | 2166445 | 2022-01-30 | Bottineau | North Dakota | 38009 | 1468 | 24 |
2139921 | 2139921 | 2022-01-22 | Chariton | Missouri | 29041 | 1468 | 32 |
2129320 | 2129320 | 2022-01-19 | Pulaski | Illinois | 17153 | 1468 | 15 |
2130218 | 2130218 | 2022-01-19 | Ozark | Missouri | 29153 | 1468 | 48 |
2121881 | 2121881 | 2022-01-16 | Lancaster | Virginia | 51103 | 1468 | 24 |
2118629 | 2118629 | 2022-01-15 | Lancaster | Virginia | 51103 | 1468 | 24 |
2115377 | 2115377 | 2022-01-14 | Lancaster | Virginia | 51103 | 1468 | 24 |
2108248 | 2108248 | 2022-01-12 | Jayuya | Puerto Rico | 72073 | 1468 | |
2104309 | 2104309 | 2022-01-11 | Butler | Nebraska | 31023 | 1468 | 12 |
2084808 | 2084808 | 2022-01-05 | Cuming | Nebraska | 31039 | 1468 | 15 |
2052454 | 2052454 | 2021-12-26 | Sierra | New Mexico | 35051 | 1468 | 63 |
2049204 | 2049204 | 2021-12-25 | Sierra | New Mexico | 35051 | 1468 | 63 |
2045954 | 2045954 | 2021-12-24 | Sierra | New Mexico | 35051 | 1468 | 63 |
2042704 | 2042704 | 2021-12-23 | Sierra | New Mexico | 35051 | 1468 | 63 |
2030808 | 2030808 | 2021-12-19 | Buena Vista city | Virginia | 51530 | 1468 | 31 |
2027557 | 2027557 | 2021-12-18 | Buena Vista city | Virginia | 51530 | 1468 | 31 |
2024306 | 2024306 | 2021-12-17 | Buena Vista city | Virginia | 51530 | 1468 | 31 |
2015889 | 2015889 | 2021-12-15 | Cumberland | Kentucky | 21057 | 1468 | 22 |
1995821 | 1995821 | 2021-12-09 | Irwin | Georgia | 13155 | 1468 | 42 |
1998463 | 1998463 | 2021-12-09 | Doddridge | West Virginia | 54017 | 1468 | 12 |
1994629 | 1994629 | 2021-12-08 | Turner | South Dakota | 46125 | 1468 | 61 |
1991332 | 1991332 | 2021-12-07 | Custer | South Dakota | 46033 | 1468 | 19 |
1991446 | 1991446 | 2021-12-07 | Moore | Tennessee | 47127 | 1468 | 25 |
1988749 | 1988749 | 2021-12-06 | Tyler | West Virginia | 54095 | 1468 | 25 |
1984747 | 1984747 | 2021-12-05 | Salinas | Puerto Rico | 72123 | 1468 | |
1984840 | 1984840 | 2021-12-05 | Grant | South Dakota | 46051 | 1468 | 46 |
1981590 | 1981590 | 2021-12-04 | Grant | South Dakota | 46051 | 1468 | 46 |
1978340 | 1978340 | 2021-12-03 | Grant | South Dakota | 46051 | 1468 | 46 |
1963413 | 1963413 | 2021-11-29 | Benewah | Idaho | 16009 | 1468 | 29 |
1960671 | 1960671 | 2021-11-28 | Livingston | Kentucky | 21139 | 1468 | 45 |
1957420 | 1957420 | 2021-11-27 | Livingston | Kentucky | 21139 | 1468 | 45 |
1954169 | 1954169 | 2021-11-26 | Livingston | Kentucky | 21139 | 1468 | 45 |
1950918 | 1950918 | 2021-11-25 | Livingston | Kentucky | 21139 | 1468 | 45 |
1947667 | 1947667 | 2021-11-24 | Livingston | Kentucky | 21139 | 1468 | 45 |
1930047 | 1930047 | 2021-11-18 | Clarke | Virginia | 51043 | 1468 | 28 |
1918963 | 1918963 | 2021-11-15 | Carbon | Montana | 30009 | 1468 | 21 |
1920586 | 1920586 | 2021-11-15 | Platte | Wyoming | 56031 | 1468 | 26 |
1915636 | 1915636 | 2021-11-14 | Howard | Missouri | 29089 | 1468 | 13 |
1905659 | 1905659 | 2021-11-11 | Presque Isle | Michigan | 26141 | 1468 | 41 |
1902410 | 1902410 | 2021-11-10 | Presque Isle | Michigan | 26141 | 1468 | 41 |
1899109 | 1899109 | 2021-11-09 | Crawford | Michigan | 26039 | 1468 | 17 |
1900815 | 1900815 | 2021-11-09 | Floyd | Virginia | 51063 | 1468 | 31 |
1895859 | 1895859 | 2021-11-08 | Crawford | Michigan | 26039 | 1468 | 17 |
1897740 | 1897740 | 2021-11-08 | Summers | West Virginia | 54089 | 1468 | 30 |
1894490 | 1894490 | 2021-11-07 | Summers | West Virginia | 54089 | 1468 | 30 |
1868493 | 1868493 | 2021-10-30 | Ritchie | West Virginia | 54085 | 1468 | 20 |
1853325 | 1853325 | 2021-10-26 | Pawnee | Kansas | 20145 | 1468 | 15 |
1853885 | 1853885 | 2021-10-26 | DeKalb | Missouri | 29063 | 1468 | 33 |
1850076 | 1850076 | 2021-10-25 | Pawnee | Kansas | 20145 | 1468 | 15 |
1846568 | 1846568 | 2021-10-24 | Brown | Indiana | 18013 | 1468 | 48 |
1843318 | 1843318 | 2021-10-23 | Brown | Indiana | 18013 | 1468 | 48 |
1840068 | 1840068 | 2021-10-22 | Brown | Indiana | 18013 | 1468 | 48 |
1836406 | 1836406 | 2021-10-21 | Rio Grande | Colorado | 8105 | 1468 | 21 |
1828038 | 1828038 | 2021-10-18 | Box Butte | Nebraska | 31013 | 1468 | 12 |
1809024 | 1809024 | 2021-10-12 | Blaine | Oklahoma | 40011 | 1468 | 26 |
1805037 | 1805037 | 2021-10-11 | Benton | Mississippi | 28009 | 1468 | 38 |
1805774 | 1805774 | 2021-10-11 | Blaine | Oklahoma | 40011 | 1468 | 26 |
1802524 | 1802524 | 2021-10-10 | Blaine | Oklahoma | 40011 | 1468 | 26 |
1799275 | 1799275 | 2021-10-09 | Blaine | Oklahoma | 40011 | 1468 | 26 |
1796026 | 1796026 | 2021-10-08 | Blaine | Oklahoma | 40011 | 1468 | 26 |
1792777 | 1792777 | 2021-10-07 | Blaine | Oklahoma | 40011 | 1468 | 26 |
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);