ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
346 rows where cases = 1518 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 28
- Iowa 23
- Virginia 23
- Arkansas 19
- Montana 16
- Michigan 14
- Kentucky 13
- Wyoming 13
- Minnesota 12
- Illinois 11
- Louisiana 11
- Missouri 11
- Puerto Rico 11
- California 10
- Indiana 10
- Texas 10
- Alabama 9
- Mississippi 8
- South Dakota 8
- Florida 7
- Massachusetts 7
- Tennessee 7
- West Virginia 7
- New York 6
- Kansas 5
- Oregon 5
- South Carolina 5
- Nebraska 4
- North Carolina 4
- Maryland 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492551 | 2492551 | 2022-05-10 | Jack | Texas | 48237 | 1518 | 28 |
2467485 | 2467485 | 2022-05-03 | Marion | Georgia | 13197 | 1518 | 50 |
2464230 | 2464230 | 2022-05-02 | Marion | Georgia | 13197 | 1518 | 50 |
2464433 | 2464433 | 2022-05-02 | Stark | Illinois | 17175 | 1518 | 33 |
2460974 | 2460974 | 2022-05-01 | Marion | Georgia | 13197 | 1518 | 50 |
2461177 | 2461177 | 2022-05-01 | Stark | Illinois | 17175 | 1518 | 33 |
2457718 | 2457718 | 2022-04-30 | Marion | Georgia | 13197 | 1518 | 50 |
2457921 | 2457921 | 2022-04-30 | Stark | Illinois | 17175 | 1518 | 33 |
2454462 | 2454462 | 2022-04-29 | Marion | Georgia | 13197 | 1518 | 50 |
2454665 | 2454665 | 2022-04-29 | Stark | Illinois | 17175 | 1518 | 33 |
2451206 | 2451206 | 2022-04-28 | Marion | Georgia | 13197 | 1518 | 50 |
2447950 | 2447950 | 2022-04-27 | Marion | Georgia | 13197 | 1518 | 50 |
2375999 | 2375999 | 2022-04-05 | Montgomery | Arkansas | 5097 | 1518 | 57 |
2372747 | 2372747 | 2022-04-04 | Montgomery | Arkansas | 5097 | 1518 | 57 |
2369494 | 2369494 | 2022-04-03 | Montgomery | Arkansas | 5097 | 1518 | 57 |
2366241 | 2366241 | 2022-04-02 | Montgomery | Arkansas | 5097 | 1518 | 57 |
2362988 | 2362988 | 2022-04-01 | Montgomery | Arkansas | 5097 | 1518 | 57 |
2359734 | 2359734 | 2022-03-31 | Montgomery | Arkansas | 5097 | 1518 | 57 |
2356480 | 2356480 | 2022-03-30 | Montgomery | Arkansas | 5097 | 1518 | 57 |
2353227 | 2353227 | 2022-03-29 | Montgomery | Arkansas | 5097 | 1518 | 57 |
2337059 | 2337059 | 2022-03-24 | Clear Creek | Colorado | 8019 | 1518 | 12 |
2319945 | 2319945 | 2022-03-18 | Carson | Texas | 48065 | 1518 | 34 |
2314638 | 2314638 | 2022-03-17 | Calhoun | Illinois | 17013 | 1518 | 8 |
2311385 | 2311385 | 2022-03-16 | Calhoun | Illinois | 17013 | 1518 | 8 |
2308132 | 2308132 | 2022-03-15 | Calhoun | Illinois | 17013 | 1518 | 8 |
2239771 | 2239771 | 2022-02-22 | Twiggs | Georgia | 13289 | 1518 | 66 |
2236520 | 2236520 | 2022-02-21 | Twiggs | Georgia | 13289 | 1518 | 66 |
2188799 | 2188799 | 2022-02-06 | Shannon | Missouri | 29203 | 1518 | 32 |
2155150 | 2155150 | 2022-01-27 | Lincoln | Georgia | 13181 | 1518 | 35 |
2155665 | 2155665 | 2022-01-27 | Wabaunsee | Kansas | 20197 | 1518 | 21 |
2152412 | 2152412 | 2022-01-26 | Wabaunsee | Kansas | 20197 | 1518 | 21 |
2145443 | 2145443 | 2022-01-24 | Treutlen | Georgia | 13283 | 1518 | 55 |
2125284 | 2125284 | 2022-01-17 | Tucker | West Virginia | 54093 | 1518 | 32 |
2115793 | 2115793 | 2022-01-15 | Newton | Arkansas | 5101 | 1518 | 45 |
2118382 | 2118382 | 2022-01-15 | Jim Hogg | Texas | 48247 | 1518 | 20 |
2099550 | 2099550 | 2022-01-10 | Searcy | Arkansas | 5129 | 1518 | 33 |
2081708 | 2081708 | 2022-01-04 | Sierra | New Mexico | 35051 | 1518 | 64 |
2078456 | 2078456 | 2022-01-03 | Sierra | New Mexico | 35051 | 1518 | 64 |
2057533 | 2057533 | 2021-12-28 | Clinch | Georgia | 13065 | 1518 | 36 |
2058296 | 2058296 | 2021-12-28 | West Feliciana | Louisiana | 22125 | 1518 | 41 |
2037607 | 2037607 | 2021-12-21 | Sublette | Wyoming | 56035 | 1518 | 23 |
2034357 | 2034357 | 2021-12-20 | Sublette | Wyoming | 56035 | 1518 | 23 |
2031107 | 2031107 | 2021-12-19 | Sublette | Wyoming | 56035 | 1518 | 23 |
2027856 | 2027856 | 2021-12-18 | Sublette | Wyoming | 56035 | 1518 | 23 |
2024605 | 2024605 | 2021-12-17 | Sublette | Wyoming | 56035 | 1518 | 23 |
2013994 | 2013994 | 2021-12-14 | Naguabo | Puerto Rico | 72103 | 1518 | |
2010743 | 2010743 | 2021-12-13 | Naguabo | Puerto Rico | 72103 | 1518 | |
2007492 | 2007492 | 2021-12-12 | Naguabo | Puerto Rico | 72103 | 1518 | |
2007951 | 2007951 | 2021-12-12 | Swisher | Texas | 48437 | 1518 | 25 |
2004241 | 2004241 | 2021-12-11 | Naguabo | Puerto Rico | 72103 | 1518 | |
2000990 | 2000990 | 2021-12-10 | Naguabo | Puerto Rico | 72103 | 1518 | |
1997740 | 1997740 | 2021-12-09 | Naguabo | Puerto Rico | 72103 | 1518 | |
1989693 | 1989693 | 2021-12-07 | Howard | Iowa | 19089 | 1518 | 24 |
1986443 | 1986443 | 2021-12-06 | Howard | Iowa | 19089 | 1518 | 24 |
1983193 | 1983193 | 2021-12-05 | Howard | Iowa | 19089 | 1518 | 24 |
1979943 | 1979943 | 2021-12-04 | Howard | Iowa | 19089 | 1518 | 24 |
1976693 | 1976693 | 2021-12-03 | Howard | Iowa | 19089 | 1518 | 24 |
1973444 | 1973444 | 2021-12-02 | Howard | Iowa | 19089 | 1518 | 24 |
1970194 | 1970194 | 2021-12-01 | Howard | Iowa | 19089 | 1518 | 24 |
1970731 | 1970731 | 2021-12-01 | Murray | Minnesota | 27101 | 1518 | 11 |
1967481 | 1967481 | 2021-11-30 | Murray | Minnesota | 27101 | 1518 | 11 |
1961259 | 1961259 | 2021-11-28 | Sanders | Montana | 30089 | 1518 | 29 |
1962843 | 1962843 | 2021-11-28 | Platte | Wyoming | 56031 | 1518 | 26 |
1958008 | 1958008 | 2021-11-27 | Sanders | Montana | 30089 | 1518 | 29 |
1959592 | 1959592 | 2021-11-27 | Platte | Wyoming | 56031 | 1518 | 26 |
1954757 | 1954757 | 2021-11-26 | Sanders | Montana | 30089 | 1518 | 29 |
1956341 | 1956341 | 2021-11-26 | Platte | Wyoming | 56031 | 1518 | 26 |
1953090 | 1953090 | 2021-11-25 | Platte | Wyoming | 56031 | 1518 | 26 |
1949839 | 1949839 | 2021-11-24 | Platte | Wyoming | 56031 | 1518 | 26 |
1930025 | 1930025 | 2021-11-18 | Amelia | Virginia | 51007 | 1518 | 42 |
1930235 | 1930235 | 2021-11-18 | Ritchie | West Virginia | 54085 | 1518 | 21 |
1921908 | 1921908 | 2021-11-16 | Presque Isle | Michigan | 26141 | 1518 | 41 |
1918658 | 1918658 | 2021-11-15 | Presque Isle | Michigan | 26141 | 1518 | 41 |
1914643 | 1914643 | 2021-11-14 | Wilkinson | Georgia | 13319 | 1518 | 46 |
1915709 | 1915709 | 2021-11-14 | Beaverhead | Montana | 30001 | 1518 | 20 |
1911393 | 1911393 | 2021-11-13 | Wilkinson | Georgia | 13319 | 1518 | 46 |
1912459 | 1912459 | 2021-11-13 | Beaverhead | Montana | 30001 | 1518 | 20 |
1908144 | 1908144 | 2021-11-12 | Wilkinson | Georgia | 13319 | 1518 | 46 |
1909209 | 1909209 | 2021-11-12 | Beaverhead | Montana | 30001 | 1518 | 20 |
1882115 | 1882115 | 2021-11-04 | Stewart | Georgia | 13259 | 1518 | 28 |
1878866 | 1878866 | 2021-11-03 | Stewart | Georgia | 13259 | 1518 | 28 |
1875262 | 1875262 | 2021-11-02 | Perry | Arkansas | 5105 | 1518 | 21 |
1865245 | 1865245 | 2021-10-29 | Roane | West Virginia | 54087 | 1518 | 21 |
1861828 | 1861828 | 2021-10-28 | Galax city | Virginia | 51640 | 1518 | 62 |
1856313 | 1856313 | 2021-10-27 | Benton | Indiana | 18007 | 1518 | 17 |
1852361 | 1852361 | 2021-10-26 | Bullock | Alabama | 1011 | 1518 | 44 |
1846363 | 1846363 | 2021-10-24 | Pulaski | Georgia | 13235 | 1518 | 60 |
1843113 | 1843113 | 2021-10-23 | Pulaski | Georgia | 13235 | 1518 | 60 |
1839863 | 1839863 | 2021-10-22 | Pulaski | Georgia | 13235 | 1518 | 60 |
1836614 | 1836614 | 2021-10-21 | Pulaski | Georgia | 13235 | 1518 | 59 |
1830116 | 1830116 | 2021-10-19 | Pulaski | Georgia | 13235 | 1518 | 59 |
1826867 | 1826867 | 2021-10-18 | Pulaski | Georgia | 13235 | 1518 | 59 |
1828252 | 1828252 | 2021-10-18 | Schuyler | New York | 36097 | 1518 | 17 |
1813859 | 1813859 | 2021-10-14 | Montgomery | Georgia | 13209 | 1518 | 38 |
1810335 | 1810335 | 2021-10-13 | Plumas | California | 6063 | 1518 | 6 |
1811860 | 1811860 | 2021-10-13 | Red Willow | Nebraska | 31145 | 1518 | 15 |
1806578 | 1806578 | 2021-10-11 | Dickenson | Virginia | 51051 | 1518 | 24 |
1803328 | 1803328 | 2021-10-10 | Dickenson | Virginia | 51051 | 1518 | 24 |
1800079 | 1800079 | 2021-10-09 | Dickenson | Virginia | 51051 | 1518 | 24 |
1796830 | 1796830 | 2021-10-08 | Dickenson | Virginia | 51051 | 1518 | 24 |
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);