ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
362 rows where cases = 1378 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 43
- Texas 35
- Iowa 21
- Georgia 16
- Missouri 16
- Virginia 16
- North Carolina 13
- Puerto Rico 13
- Kentucky 12
- West Virginia 12
- Minnesota 11
- Alabama 10
- Oklahoma 9
- Maine 8
- Ohio 8
- Washington 8
- Colorado 7
- Indiana 7
- Louisiana 7
- Arkansas 6
- Kansas 6
- Mississippi 6
- Tennessee 6
- Wisconsin 6
- New Mexico 5
- Alaska 4
- Idaho 4
- Michigan 4
- Montana 4
- Pennsylvania 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446726 | 2446726 | 2022-04-26 | Moody | South Dakota | 46101 | 1378 | 28 |
2443471 | 2443471 | 2022-04-25 | Moody | South Dakota | 46101 | 1378 | 28 |
2440215 | 2440215 | 2022-04-24 | Moody | South Dakota | 46101 | 1378 | 28 |
2436959 | 2436959 | 2022-04-23 | Moody | South Dakota | 46101 | 1378 | 28 |
2433703 | 2433703 | 2022-04-22 | Moody | South Dakota | 46101 | 1378 | 28 |
2430447 | 2430447 | 2022-04-21 | Moody | South Dakota | 46101 | 1378 | 28 |
2427191 | 2427191 | 2022-04-20 | Moody | South Dakota | 46101 | 1378 | 28 |
2331182 | 2331182 | 2022-03-22 | Van Buren | Iowa | 19177 | 1378 | 27 |
2327930 | 2327930 | 2022-03-21 | Van Buren | Iowa | 19177 | 1378 | 27 |
2324677 | 2324677 | 2022-03-20 | Van Buren | Iowa | 19177 | 1378 | 27 |
2321423 | 2321423 | 2022-03-19 | Van Buren | Iowa | 19177 | 1378 | 27 |
2318169 | 2318169 | 2022-03-18 | Van Buren | Iowa | 19177 | 1378 | 27 |
2314916 | 2314916 | 2022-03-17 | Van Buren | Iowa | 19177 | 1378 | 27 |
2311663 | 2311663 | 2022-03-16 | Van Buren | Iowa | 19177 | 1378 | 27 |
2287287 | 2287287 | 2022-03-08 | Tripp | South Dakota | 46123 | 1378 | 24 |
2284035 | 2284035 | 2022-03-07 | Tripp | South Dakota | 46123 | 1378 | 24 |
2280783 | 2280783 | 2022-03-06 | Tripp | South Dakota | 46123 | 1378 | 24 |
2277530 | 2277530 | 2022-03-05 | Tripp | South Dakota | 46123 | 1378 | 24 |
2274277 | 2274277 | 2022-03-04 | Tripp | South Dakota | 46123 | 1378 | 24 |
2271024 | 2271024 | 2022-03-03 | Tripp | South Dakota | 46123 | 1378 | 24 |
2267772 | 2267772 | 2022-03-02 | Tripp | South Dakota | 46123 | 1378 | 24 |
2264519 | 2264519 | 2022-03-01 | Tripp | South Dakota | 46123 | 1378 | 23 |
2248519 | 2248519 | 2022-02-24 | Lynn | Texas | 48305 | 1378 | 37 |
2245268 | 2245268 | 2022-02-23 | Lynn | Texas | 48305 | 1378 | 37 |
2242017 | 2242017 | 2022-02-22 | Lynn | Texas | 48305 | 1378 | 37 |
2242309 | 2242309 | 2022-02-22 | Ferry | Washington | 53019 | 1378 | 27 |
2238766 | 2238766 | 2022-02-21 | Lynn | Texas | 48305 | 1378 | 37 |
2239058 | 2239058 | 2022-02-21 | Ferry | Washington | 53019 | 1378 | 27 |
2235515 | 2235515 | 2022-02-20 | Lynn | Texas | 48305 | 1378 | 37 |
2235807 | 2235807 | 2022-02-20 | Ferry | Washington | 53019 | 1378 | 27 |
2232264 | 2232264 | 2022-02-19 | Lynn | Texas | 48305 | 1378 | 37 |
2232556 | 2232556 | 2022-02-19 | Ferry | Washington | 53019 | 1378 | 27 |
2229305 | 2229305 | 2022-02-18 | Ferry | Washington | 53019 | 1378 | 27 |
2220005 | 2220005 | 2022-02-16 | Huerfano | Colorado | 8055 | 1378 | 29 |
2196183 | 2196183 | 2022-02-08 | Brule | South Dakota | 46015 | 1378 | 18 |
2196866 | 2196866 | 2022-02-08 | Wirt | West Virginia | 54105 | 1378 | 19 |
2178406 | 2178406 | 2022-02-03 | Mitchell | Kansas | 20123 | 1378 | 18 |
2179809 | 2179809 | 2022-02-03 | Guanica | Puerto Rico | 72055 | 1378 | |
2175153 | 2175153 | 2022-02-02 | Mitchell | Kansas | 20123 | 1378 | 18 |
2168451 | 2168451 | 2022-01-31 | Ohio | Indiana | 18115 | 1378 | 17 |
2125685 | 2125685 | 2022-01-18 | Rio Blanco | Colorado | 8103 | 1378 | 13 |
2084694 | 2084694 | 2022-01-05 | Ozark | Missouri | 29153 | 1378 | 47 |
2064133 | 2064133 | 2021-12-30 | Taylor | Georgia | 13269 | 1378 | 42 |
2037044 | 2037044 | 2021-12-21 | Dallam | Texas | 48111 | 1378 | 31 |
2030827 | 2030827 | 2021-12-19 | Essex | Virginia | 51057 | 1378 | 20 |
2027576 | 2027576 | 2021-12-18 | Essex | Virginia | 51057 | 1378 | 20 |
2024325 | 2024325 | 2021-12-17 | Essex | Virginia | 51057 | 1378 | 20 |
2021074 | 2021074 | 2021-12-16 | Essex | Virginia | 51057 | 1378 | 20 |
1991006 | 1991006 | 2021-12-07 | Alfalfa | Oklahoma | 40003 | 1378 | 9 |
1987027 | 1987027 | 2021-12-06 | Choctaw | Mississippi | 28019 | 1378 | 27 |
1987755 | 1987755 | 2021-12-06 | Alfalfa | Oklahoma | 40003 | 1378 | 9 |
1982441 | 1982441 | 2021-12-05 | Southeast Fairbanks Census Area | Alaska | 2240 | 1378 | 12 |
1984505 | 1984505 | 2021-12-05 | Alfalfa | Oklahoma | 40003 | 1378 | 9 |
1979191 | 1979191 | 2021-12-04 | Southeast Fairbanks Census Area | Alaska | 2240 | 1378 | 12 |
1981255 | 1981255 | 2021-12-04 | Alfalfa | Oklahoma | 40003 | 1378 | 9 |
1975941 | 1975941 | 2021-12-03 | Southeast Fairbanks Census Area | Alaska | 2240 | 1378 | 12 |
1978005 | 1978005 | 2021-12-03 | Alfalfa | Oklahoma | 40003 | 1378 | 9 |
1972692 | 1972692 | 2021-12-02 | Southeast Fairbanks Census Area | Alaska | 2240 | 1378 | 12 |
1972704 | 1972704 | 2021-12-02 | Greenlee | Arizona | 4011 | 1378 | 22 |
1974269 | 1974269 | 2021-12-02 | Valley | Montana | 30105 | 1378 | 29 |
1974755 | 1974755 | 2021-12-02 | Alfalfa | Oklahoma | 40003 | 1378 | 9 |
1971506 | 1971506 | 2021-12-01 | Alfalfa | Oklahoma | 40003 | 1378 | 9 |
1972303 | 1972303 | 2021-12-01 | Charlotte | Virginia | 51037 | 1378 | 28 |
1965243 | 1965243 | 2021-11-29 | Quebradillas | Puerto Rico | 72115 | 1378 | |
1955137 | 1955137 | 2021-11-26 | Pembina | North Dakota | 38067 | 1378 | 14 |
1942051 | 1942051 | 2021-11-22 | Jones | North Carolina | 37103 | 1378 | 35 |
1904204 | 1904204 | 2021-11-10 | Doddridge | West Virginia | 54017 | 1378 | 11 |
1899043 | 1899043 | 2021-11-09 | Piscataquis | Maine | 23021 | 1378 | 12 |
1893825 | 1893825 | 2021-11-07 | Custer | South Dakota | 46033 | 1378 | 17 |
1890575 | 1890575 | 2021-11-06 | Custer | South Dakota | 46033 | 1378 | 17 |
1887325 | 1887325 | 2021-11-05 | Custer | South Dakota | 46033 | 1378 | 17 |
1881591 | 1881591 | 2021-11-03 | Sublette | Wyoming | 56035 | 1378 | 20 |
1878108 | 1878108 | 2021-11-02 | Nelson | Virginia | 51125 | 1378 | 18 |
1873221 | 1873221 | 2021-11-01 | Marshall | Minnesota | 27089 | 1378 | 21 |
1859949 | 1859949 | 2021-10-28 | Owen | Kentucky | 21187 | 1378 | 25 |
1855813 | 1855813 | 2021-10-27 | Mariposa | California | 6043 | 1378 | 17 |
1856983 | 1856983 | 2021-10-27 | Murray | Minnesota | 27101 | 1378 | 11 |
1851925 | 1851925 | 2021-10-25 | Red River | Texas | 48387 | 1378 | 49 |
1848675 | 1848675 | 2021-10-24 | Red River | Texas | 48387 | 1378 | 49 |
1845425 | 1845425 | 2021-10-23 | Red River | Texas | 48387 | 1378 | 49 |
1842175 | 1842175 | 2021-10-22 | Red River | Texas | 48387 | 1378 | 49 |
1807468 | 1807468 | 2021-10-12 | Valley | Idaho | 16085 | 1378 | 10 |
1781123 | 1781123 | 2021-10-04 | Archuleta | Colorado | 8007 | 1378 | 4 |
1781957 | 1781957 | 2021-10-04 | McLean | Kentucky | 21149 | 1378 | 35 |
1783784 | 1783784 | 2021-10-04 | Addison | Vermont | 50001 | 1378 | 8 |
1746089 | 1746089 | 2021-09-23 | Marshall | Kansas | 20117 | 1378 | 28 |
1742840 | 1742840 | 2021-09-22 | Marshall | Kansas | 20117 | 1378 | 28 |
1741179 | 1741179 | 2021-09-21 | Clay | Tennessee | 47027 | 1378 | 33 |
1737930 | 1737930 | 2021-09-20 | Clay | Tennessee | 47027 | 1378 | 33 |
1733766 | 1733766 | 2021-09-19 | Fergus | Montana | 30027 | 1378 | 32 |
1730417 | 1730417 | 2021-09-18 | DeKalb | Missouri | 29063 | 1378 | 33 |
1730516 | 1730516 | 2021-09-18 | Fergus | Montana | 30027 | 1378 | 32 |
1727266 | 1727266 | 2021-09-17 | Fergus | Montana | 30027 | 1378 | 32 |
1722188 | 1722188 | 2021-09-15 | Sussex | Virginia | 51183 | 1378 | 23 |
1716652 | 1716652 | 2021-09-14 | Newton | Indiana | 18111 | 1378 | 43 |
1716776 | 1716776 | 2021-09-14 | Union | Iowa | 19175 | 1378 | 37 |
1713530 | 1713530 | 2021-09-13 | Union | Iowa | 19175 | 1378 | 37 |
1710283 | 1710283 | 2021-09-12 | Union | Iowa | 19175 | 1378 | 37 |
1707036 | 1707036 | 2021-09-11 | Union | Iowa | 19175 | 1378 | 37 |
1703788 | 1703788 | 2021-09-10 | Union | Iowa | 19175 | 1378 | 37 |
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);