ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
276 rows where cases = 2086 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 27
- Texas 20
- Virginia 19
- Arkansas 16
- Georgia 15
- Kentucky 13
- Puerto Rico 13
- South Carolina 11
- Illinois 10
- Iowa 9
- Oklahoma 9
- Tennessee 8
- Idaho 7
- Kansas 6
- Louisiana 6
- Missouri 6
- North Carolina 6
- Ohio 6
- Oregon 6
- Indiana 5
- Michigan 5
- California 4
- Minnesota 4
- Montana 4
- Nebraska 4
- Pennsylvania 4
- Wisconsin 4
- Mississippi 3
- South Dakota 3
- Utah 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466169 | 2466169 | 2022-05-02 | Allendale | South Carolina | 45005 | 2086 | 24 |
2462914 | 2462914 | 2022-05-01 | Allendale | South Carolina | 45005 | 2086 | 24 |
2459658 | 2459658 | 2022-04-30 | Allendale | South Carolina | 45005 | 2086 | 24 |
2456402 | 2456402 | 2022-04-29 | Allendale | South Carolina | 45005 | 2086 | 24 |
2452087 | 2452087 | 2022-04-28 | Lake | Minnesota | 27075 | 2086 | 28 |
2453146 | 2453146 | 2022-04-28 | Allendale | South Carolina | 45005 | 2086 | 24 |
2449837 | 2449837 | 2022-04-27 | Hormigueros | Puerto Rico | 72067 | 2086 | |
2443925 | 2443925 | 2022-04-25 | Falls Church city | Virginia | 51610 | 2086 | 17 |
2427066 | 2427066 | 2022-04-20 | Patillas | Puerto Rico | 72109 | 2086 | |
2383721 | 2383721 | 2022-04-07 | Marshall | Minnesota | 27089 | 2086 | 23 |
2369903 | 2369903 | 2022-04-03 | Boundary | Idaho | 16021 | 2086 | 59 |
2366650 | 2366650 | 2022-04-02 | Boundary | Idaho | 16021 | 2086 | 59 |
2363397 | 2363397 | 2022-04-01 | Boundary | Idaho | 16021 | 2086 | 59 |
2360143 | 2360143 | 2022-03-31 | Boundary | Idaho | 16021 | 2086 | 59 |
2356889 | 2356889 | 2022-03-30 | Boundary | Idaho | 16021 | 2086 | 59 |
2353636 | 2353636 | 2022-03-29 | Boundary | Idaho | 16021 | 2086 | 59 |
2291676 | 2291676 | 2022-03-10 | Candler | Georgia | 13043 | 2086 | 92 |
2288424 | 2288424 | 2022-03-09 | Candler | Georgia | 13043 | 2086 | 92 |
2271502 | 2271502 | 2022-03-03 | Madison | Virginia | 51113 | 2086 | 36 |
2258124 | 2258124 | 2022-02-27 | Archer | Texas | 48009 | 2086 | 28 |
2254873 | 2254873 | 2022-02-26 | Archer | Texas | 48009 | 2086 | 28 |
2233634 | 2233634 | 2022-02-20 | Anderson | Kansas | 20003 | 2086 | 26 |
2230383 | 2230383 | 2022-02-19 | Anderson | Kansas | 20003 | 2086 | 26 |
2232324 | 2232324 | 2022-02-19 | Somervell | Texas | 48425 | 2086 | 34 |
2227132 | 2227132 | 2022-02-18 | Anderson | Kansas | 20003 | 2086 | 26 |
2229073 | 2229073 | 2022-02-18 | Somervell | Texas | 48425 | 2086 | 33 |
2225822 | 2225822 | 2022-02-17 | Somervell | Texas | 48425 | 2086 | 33 |
2211637 | 2211637 | 2022-02-13 | Sanders | Montana | 30089 | 2086 | 44 |
2208384 | 2208384 | 2022-02-12 | Sanders | Montana | 30089 | 2086 | 44 |
2205131 | 2205131 | 2022-02-11 | Sanders | Montana | 30089 | 2086 | 44 |
2201381 | 2201381 | 2022-02-10 | Red River | Louisiana | 22081 | 2086 | 50 |
2203369 | 2203369 | 2022-02-10 | Tyler | West Virginia | 54095 | 2086 | 27 |
2193870 | 2193870 | 2022-02-08 | Nevada | Arkansas | 5099 | 2086 | 43 |
2193473 | 2193473 | 2022-02-07 | Northampton | Virginia | 51131 | 2086 | 53 |
2186726 | 2186726 | 2022-02-05 | Live Oak | Texas | 48297 | 2086 | 40 |
2149790 | 2149790 | 2022-01-25 | Dawson | Montana | 30021 | 2086 | 53 |
2134268 | 2134268 | 2022-01-20 | Lajas | Puerto Rico | 72079 | 2086 | |
2129130 | 2129130 | 2022-01-19 | McIntosh | Georgia | 13191 | 2086 | 35 |
2117985 | 2117985 | 2022-01-15 | Ciales | Puerto Rico | 72039 | 2086 | |
2110326 | 2110326 | 2022-01-13 | Piscataquis | Maine | 23021 | 2086 | 23 |
2079005 | 2079005 | 2022-01-03 | Quebradillas | Puerto Rico | 72115 | 2086 | |
2079305 | 2079305 | 2022-01-03 | Duval | Texas | 48131 | 2086 | 61 |
2039955 | 2039955 | 2021-12-22 | Barranquitas | Puerto Rico | 72019 | 2086 | |
1993693 | 1993693 | 2021-12-08 | Ripley | Missouri | 29181 | 2086 | 51 |
1981452 | 1981452 | 2021-12-04 | Cayey | Puerto Rico | 72035 | 2086 | |
1946236 | 1946236 | 2021-11-23 | Juab | Utah | 49023 | 2086 | 18 |
1939087 | 1939087 | 2021-11-21 | Hood River | Oregon | 41027 | 2086 | 37 |
1935837 | 1935837 | 2021-11-20 | Hood River | Oregon | 41027 | 2086 | 37 |
1932587 | 1932587 | 2021-11-19 | Hood River | Oregon | 41027 | 2086 | 37 |
1896719 | 1896719 | 2021-11-08 | Noble | Ohio | 39121 | 2086 | 47 |
1896826 | 1896826 | 2021-11-08 | Baker | Oregon | 41001 | 2086 | 30 |
1882941 | 1882941 | 2021-11-04 | Cottonwood | Minnesota | 27033 | 2086 | 29 |
1884601 | 1884601 | 2021-11-04 | Martinsville city | Virginia | 51690 | 2086 | 90 |
1872517 | 1872517 | 2021-11-01 | Mercer | Illinois | 17131 | 2086 | 37 |
1858452 | 1858452 | 2021-10-27 | Terry | Texas | 48445 | 2086 | 64 |
1855203 | 1855203 | 2021-10-26 | Terry | Texas | 48445 | 2086 | 64 |
1851954 | 1851954 | 2021-10-25 | Terry | Texas | 48445 | 2086 | 64 |
1848704 | 1848704 | 2021-10-24 | Terry | Texas | 48445 | 2086 | 64 |
1848892 | 1848892 | 2021-10-24 | Rockbridge | Virginia | 51163 | 2086 | 57 |
1845454 | 1845454 | 2021-10-23 | Terry | Texas | 48445 | 2086 | 64 |
1845642 | 1845642 | 2021-10-23 | Rockbridge | Virginia | 51163 | 2086 | 57 |
1842204 | 1842204 | 2021-10-22 | Terry | Texas | 48445 | 2086 | 64 |
1842392 | 1842392 | 2021-10-22 | Rockbridge | Virginia | 51163 | 2086 | 57 |
1838955 | 1838955 | 2021-10-21 | Terry | Texas | 48445 | 2086 | 64 |
1817804 | 1817804 | 2021-10-15 | Franklin | Maine | 23007 | 2086 | 20 |
1812410 | 1812410 | 2021-10-13 | Fulton | Pennsylvania | 42057 | 2086 | 26 |
1789793 | 1789793 | 2021-10-06 | Bamberg | South Carolina | 45009 | 2086 | 63 |
1771280 | 1771280 | 2021-10-01 | Marion | Arkansas | 5089 | 2086 | 55 |
1753192 | 1753192 | 2021-09-25 | Macon | Missouri | 29121 | 2086 | 20 |
1723034 | 1723034 | 2021-09-16 | Johnson | Illinois | 17087 | 2086 | 28 |
1706029 | 1706029 | 2021-09-10 | McDowell | West Virginia | 54047 | 2086 | 28 |
1694050 | 1694050 | 2021-09-07 | Winneshiek | Iowa | 19191 | 2086 | 37 |
1695001 | 1695001 | 2021-09-07 | Taos | New Mexico | 35055 | 2086 | 56 |
1690801 | 1690801 | 2021-09-06 | Winneshiek | Iowa | 19191 | 2086 | 37 |
1687551 | 1687551 | 2021-09-05 | Winneshiek | Iowa | 19191 | 2086 | 37 |
1684301 | 1684301 | 2021-09-04 | Winneshiek | Iowa | 19191 | 2086 | 37 |
1681050 | 1681050 | 2021-09-03 | Winneshiek | Iowa | 19191 | 2086 | 37 |
1677802 | 1677802 | 2021-09-02 | Winneshiek | Iowa | 19191 | 2086 | 37 |
1674555 | 1674555 | 2021-09-01 | Winneshiek | Iowa | 19191 | 2086 | 37 |
1674741 | 1674741 | 2021-09-01 | Mason | Kentucky | 21161 | 2086 | 44 |
1671437 | 1671437 | 2021-08-31 | Casey | Kentucky | 21045 | 2086 | 45 |
1649723 | 1649723 | 2021-08-24 | Richland | North Dakota | 38077 | 2086 | 17 |
1633691 | 1633691 | 2021-08-19 | Union | Oregon | 41061 | 2086 | 29 |
1629606 | 1629606 | 2021-08-18 | Calhoun | Mississippi | 28013 | 2086 | 34 |
1627474 | 1627474 | 2021-08-17 | Cannon | Tennessee | 47015 | 2086 | 32 |
1623582 | 1623582 | 2021-08-16 | Seneca | New York | 36099 | 2086 | 57 |
1615340 | 1615340 | 2021-08-14 | Izard | Arkansas | 5065 | 2086 | 47 |
1596380 | 1596380 | 2021-08-08 | Pike | Illinois | 17149 | 2086 | 56 |
1593131 | 1593131 | 2021-08-07 | Pike | Illinois | 17149 | 2086 | 56 |
1589882 | 1589882 | 2021-08-06 | Pike | Illinois | 17149 | 2086 | 56 |
1591912 | 1591912 | 2021-08-06 | Freestone | Texas | 48161 | 2086 | 51 |
1588355 | 1588355 | 2021-08-05 | San Lorenzo | Puerto Rico | 72129 | 2086 | |
1581645 | 1581645 | 2021-08-03 | Kingfisher | Oklahoma | 40073 | 2086 | 42 |
1582368 | 1582368 | 2021-08-03 | Bennington | Vermont | 50003 | 2086 | 15 |
1578396 | 1578396 | 2021-08-02 | Kingfisher | Oklahoma | 40073 | 2086 | 42 |
1575148 | 1575148 | 2021-08-01 | Kingfisher | Oklahoma | 40073 | 2086 | 42 |
1575959 | 1575959 | 2021-08-01 | Louisa | Virginia | 51109 | 2086 | 34 |
1571900 | 1571900 | 2021-07-31 | Kingfisher | Oklahoma | 40073 | 2086 | 42 |
1572711 | 1572711 | 2021-07-31 | Louisa | Virginia | 51109 | 2086 | 34 |
1568652 | 1568652 | 2021-07-30 | Kingfisher | Oklahoma | 40073 | 2086 | 42 |
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);