ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
269 rows where cases = 1960 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 29
- Georgia 17
- Kansas 17
- Oklahoma 17
- Kentucky 16
- Iowa 13
- Virginia 13
- Florida 11
- Minnesota 10
- Puerto Rico 10
- Mississippi 9
- Missouri 9
- Arkansas 8
- Illinois 8
- Indiana 8
- Tennessee 7
- Nebraska 5
- North Dakota 5
- South Dakota 5
- Wisconsin 5
- Michigan 4
- Ohio 4
- West Virginia 4
- Colorado 3
- Montana 3
- North Carolina 3
- Oregon 3
- Pennsylvania 3
- Utah 3
- Wyoming 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492509 | 2492509 | 2022-05-10 | Floyd | Texas | 48153 | 1960 | 48 |
2489251 | 2489251 | 2022-05-09 | Floyd | Texas | 48153 | 1960 | 48 |
2485994 | 2485994 | 2022-05-08 | Floyd | Texas | 48153 | 1960 | 48 |
2420888 | 2420888 | 2022-04-18 | Hamilton | Texas | 48193 | 1960 | 33 |
2417632 | 2417632 | 2022-04-17 | Hamilton | Texas | 48193 | 1960 | 33 |
2414376 | 2414376 | 2022-04-16 | Hamilton | Texas | 48193 | 1960 | 33 |
2411120 | 2411120 | 2022-04-15 | Hamilton | Texas | 48193 | 1960 | 33 |
2407864 | 2407864 | 2022-04-14 | Hamilton | Texas | 48193 | 1960 | 33 |
2404608 | 2404608 | 2022-04-13 | Hamilton | Texas | 48193 | 1960 | 33 |
2401353 | 2401353 | 2022-04-12 | Hamilton | Texas | 48193 | 1960 | 33 |
2398098 | 2398098 | 2022-04-11 | Hamilton | Texas | 48193 | 1960 | 32 |
2394843 | 2394843 | 2022-04-10 | Hamilton | Texas | 48193 | 1960 | 32 |
2391587 | 2391587 | 2022-04-09 | Hamilton | Texas | 48193 | 1960 | 32 |
2388331 | 2388331 | 2022-04-08 | Hamilton | Texas | 48193 | 1960 | 32 |
2385076 | 2385076 | 2022-04-07 | Hamilton | Texas | 48193 | 1960 | 32 |
2381821 | 2381821 | 2022-04-06 | Hamilton | Texas | 48193 | 1960 | 32 |
2359291 | 2359291 | 2022-03-30 | Fairfax city | Virginia | 51600 | 1960 | 42 |
2337748 | 2337748 | 2022-03-24 | Kingman | Kansas | 20095 | 1960 | 27 |
2334494 | 2334494 | 2022-03-23 | Kingman | Kansas | 20095 | 1960 | 27 |
2324735 | 2324735 | 2022-03-20 | Kingman | Kansas | 20095 | 1960 | 27 |
2321481 | 2321481 | 2022-03-19 | Kingman | Kansas | 20095 | 1960 | 27 |
2318227 | 2318227 | 2022-03-18 | Kingman | Kansas | 20095 | 1960 | 27 |
2294413 | 2294413 | 2022-03-10 | Tucker | West Virginia | 54093 | 1960 | 34 |
2286801 | 2286801 | 2022-03-08 | Pembina | North Dakota | 38067 | 1960 | 16 |
2233646 | 2233646 | 2022-02-20 | Clay | Kansas | 20027 | 1960 | 33 |
2230395 | 2230395 | 2022-02-19 | Clay | Kansas | 20027 | 1960 | 33 |
2227144 | 2227144 | 2022-02-18 | Clay | Kansas | 20027 | 1960 | 33 |
2224369 | 2224369 | 2022-02-17 | Pipestone | Minnesota | 27117 | 1960 | 34 |
2190739 | 2190739 | 2022-02-07 | Lincoln | Colorado | 8073 | 1960 | 9 |
2193461 | 2193461 | 2022-02-07 | Madison | Virginia | 51113 | 1960 | 29 |
2168702 | 2168702 | 2022-01-31 | Bracken | Kentucky | 21023 | 1960 | 23 |
2149130 | 2149130 | 2022-01-25 | Norton | Kansas | 20137 | 1960 | 35 |
2145878 | 2145878 | 2022-01-24 | Norton | Kansas | 20137 | 1960 | 35 |
2140797 | 2140797 | 2022-01-22 | Rincon | Puerto Rico | 72117 | 1960 | |
2138294 | 2138294 | 2022-01-21 | Ritchie | West Virginia | 54085 | 1960 | 26 |
2104809 | 2104809 | 2022-01-11 | Haskell | Oklahoma | 40061 | 1960 | 33 |
2101558 | 2101558 | 2022-01-10 | Haskell | Oklahoma | 40061 | 1960 | 33 |
2098307 | 2098307 | 2022-01-09 | Haskell | Oklahoma | 40061 | 1960 | 33 |
2095055 | 2095055 | 2022-01-08 | Haskell | Oklahoma | 40061 | 1960 | 33 |
2091803 | 2091803 | 2022-01-07 | Haskell | Oklahoma | 40061 | 1960 | 33 |
2087078 | 2087078 | 2022-01-06 | Benton | Indiana | 18007 | 1960 | 21 |
2088551 | 2088551 | 2022-01-06 | Haskell | Oklahoma | 40061 | 1960 | 33 |
2085300 | 2085300 | 2022-01-05 | Haskell | Oklahoma | 40061 | 1960 | 33 |
2072450 | 2072450 | 2022-01-01 | Anasco | Puerto Rico | 72011 | 1960 | |
2069199 | 2069199 | 2021-12-31 | Anasco | Puerto Rico | 72011 | 1960 | |
2057128 | 2057128 | 2021-12-28 | Conecuh | Alabama | 1035 | 1960 | 62 |
2057973 | 2057973 | 2021-12-28 | Mitchell | Iowa | 19131 | 1960 | 46 |
2054724 | 2054724 | 2021-12-27 | Mitchell | Iowa | 19131 | 1960 | 46 |
2051474 | 2051474 | 2021-12-26 | Mitchell | Iowa | 19131 | 1960 | 46 |
2052646 | 2052646 | 2021-12-26 | Mercer | North Dakota | 38057 | 1960 | 22 |
2048224 | 2048224 | 2021-12-25 | Mitchell | Iowa | 19131 | 1960 | 46 |
2049396 | 2049396 | 2021-12-25 | Mercer | North Dakota | 38057 | 1960 | 22 |
2044974 | 2044974 | 2021-12-24 | Mitchell | Iowa | 19131 | 1960 | 46 |
2041725 | 2041725 | 2021-12-23 | Mitchell | Iowa | 19131 | 1960 | 46 |
2038475 | 2038475 | 2021-12-22 | Mitchell | Iowa | 19131 | 1960 | 46 |
2016274 | 2016274 | 2021-12-15 | Yellow Medicine | Minnesota | 27173 | 1960 | 25 |
1952196 | 1952196 | 2021-11-25 | Catano | Puerto Rico | 72033 | 1960 | |
1939748 | 1939748 | 2021-11-21 | Unknown | Utah | 1960 | 39 | |
1936498 | 1936498 | 2021-11-20 | Unknown | Utah | 1960 | 39 | |
1926326 | 1926326 | 2021-11-17 | Dewey | South Dakota | 46041 | 1960 | 32 |
1903132 | 1903132 | 2021-11-10 | Mountrail | North Dakota | 38061 | 1960 | 27 |
1886376 | 1886376 | 2021-11-05 | Dent | Missouri | 29065 | 1960 | 42 |
1862219 | 1862219 | 2021-10-29 | Bradley | Arkansas | 5011 | 1960 | 41 |
1837074 | 1837074 | 2021-10-21 | Osage | Kansas | 20139 | 1960 | 34 |
1833825 | 1833825 | 2021-10-20 | Osage | Kansas | 20139 | 1960 | 34 |
1812083 | 1812083 | 2021-10-13 | Mitchell | North Carolina | 37121 | 1960 | 18 |
1784275 | 1784275 | 2021-10-05 | Little River | Arkansas | 5081 | 1960 | 47 |
1767662 | 1767662 | 2021-09-29 | Rockbridge | Virginia | 51163 | 1960 | 51 |
1755918 | 1755918 | 2021-09-26 | Fleming | Kentucky | 21069 | 1960 | 27 |
1756265 | 1756265 | 2021-09-26 | Pennington | Minnesota | 27113 | 1960 | 22 |
1752670 | 1752670 | 2021-09-25 | Fleming | Kentucky | 21069 | 1960 | 27 |
1753017 | 1753017 | 2021-09-25 | Pennington | Minnesota | 27113 | 1960 | 22 |
1749421 | 1749421 | 2021-09-24 | Fleming | Kentucky | 21069 | 1960 | 27 |
1749769 | 1749769 | 2021-09-24 | Pennington | Minnesota | 27113 | 1960 | 22 |
1743463 | 1743463 | 2021-09-22 | Pemiscot | Missouri | 29155 | 1960 | 41 |
1736406 | 1736406 | 2021-09-20 | Caldwell | Kentucky | 21033 | 1960 | 43 |
1724978 | 1724978 | 2021-09-16 | Meigs | Tennessee | 47121 | 1960 | 24 |
1725554 | 1725554 | 2021-09-16 | Crawford | Wisconsin | 55023 | 1960 | 22 |
1709868 | 1709868 | 2021-09-12 | Jasper | Georgia | 13159 | 1960 | 46 |
1706621 | 1706621 | 2021-09-11 | Jasper | Georgia | 13159 | 1960 | 46 |
1703373 | 1703373 | 2021-09-10 | Jasper | Georgia | 13159 | 1960 | 46 |
1699803 | 1699803 | 2021-09-09 | Lee | Arkansas | 5077 | 1960 | 40 |
1697841 | 1697841 | 2021-09-08 | Greene | Mississippi | 28041 | 1960 | 42 |
1699643 | 1699643 | 2021-09-08 | Lincoln | Wyoming | 56023 | 1960 | 14 |
1690552 | 1690552 | 2021-09-06 | Jo Daviess | Illinois | 17085 | 1960 | 27 |
1687302 | 1687302 | 2021-09-05 | Jo Daviess | Illinois | 17085 | 1960 | 27 |
1684052 | 1684052 | 2021-09-04 | Jo Daviess | Illinois | 17085 | 1960 | 27 |
1680801 | 1680801 | 2021-09-03 | Jo Daviess | Illinois | 17085 | 1960 | 27 |
1647010 | 1647010 | 2021-08-23 | Lewis | Tennessee | 47101 | 1960 | 29 |
1600379 | 1600379 | 2021-08-09 | Clarke | Mississippi | 28023 | 1960 | 80 |
1585678 | 1585678 | 2021-08-04 | Fluvanna | Virginia | 51065 | 1960 | 21 |
1534155 | 1534155 | 2021-07-20 | Phillips | Arkansas | 5107 | 1960 | 45 |
1518889 | 1518889 | 2021-07-15 | Concordia | Louisiana | 22029 | 1960 | 62 |
1512740 | 1512740 | 2021-07-13 | Stone | Mississippi | 28131 | 1960 | 36 |
1509493 | 1509493 | 2021-07-12 | Stone | Mississippi | 28131 | 1960 | 35 |
1490767 | 1490767 | 2021-07-06 | Columbia | Oregon | 41009 | 1960 | 30 |
1473305 | 1473305 | 2021-07-01 | Adair | Kentucky | 21001 | 1960 | 54 |
1470059 | 1470059 | 2021-06-30 | Adair | Kentucky | 21001 | 1960 | 54 |
1466814 | 1466814 | 2021-06-29 | Adair | Kentucky | 21001 | 1960 | 54 |
1463569 | 1463569 | 2021-06-28 | Adair | Kentucky | 21001 | 1960 | 54 |
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);