ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
211 rows where cases = 3133 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 28
- Oklahoma 22
- Mississippi 13
- Puerto Rico 10
- Arkansas 9
- Texas 9
- Kentucky 8
- Illinois 7
- Indiana 7
- New Mexico 7
- Wyoming 7
- Alabama 6
- Missouri 6
- North Carolina 6
- Kansas 5
- Michigan 5
- South Dakota 5
- Wisconsin 5
- Idaho 4
- Minnesota 4
- Tennessee 4
- Virginia 4
- California 3
- New York 3
- Pennsylvania 3
- South Carolina 3
- Colorado 2
- Iowa 2
- Louisiana 2
- Maryland 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2479176 | 2479176 | 2022-05-06 | Santa Isabel | Puerto Rico | 72133 | 3133 | |
2444677 | 2444677 | 2022-04-26 | Jasper | Georgia | 13159 | 3133 | 72 |
2441421 | 2441421 | 2022-04-25 | Jasper | Georgia | 13159 | 3133 | 72 |
2439545 | 2439545 | 2022-04-24 | Torrance | New Mexico | 35057 | 3133 | 54 |
2436289 | 2436289 | 2022-04-23 | Torrance | New Mexico | 35057 | 3133 | 54 |
2433033 | 2433033 | 2022-04-22 | Torrance | New Mexico | 35057 | 3133 | 54 |
2429777 | 2429777 | 2022-04-21 | Torrance | New Mexico | 35057 | 3133 | 54 |
2426521 | 2426521 | 2022-04-20 | Torrance | New Mexico | 35057 | 3133 | 54 |
2423265 | 2423265 | 2022-04-19 | Torrance | New Mexico | 35057 | 3133 | 54 |
2353049 | 2353049 | 2022-03-28 | Converse | Wyoming | 56009 | 3133 | 55 |
2349797 | 2349797 | 2022-03-27 | Converse | Wyoming | 56009 | 3133 | 55 |
2346544 | 2346544 | 2022-03-26 | Converse | Wyoming | 56009 | 3133 | 55 |
2343291 | 2343291 | 2022-03-25 | Converse | Wyoming | 56009 | 3133 | 55 |
2340038 | 2340038 | 2022-03-24 | Converse | Wyoming | 56009 | 3133 | 55 |
2336785 | 2336785 | 2022-03-23 | Converse | Wyoming | 56009 | 3133 | 55 |
2333531 | 2333531 | 2022-03-22 | Converse | Wyoming | 56009 | 3133 | 55 |
2317176 | 2317176 | 2022-03-17 | Roane | West Virginia | 54087 | 3133 | 37 |
2313157 | 2313157 | 2022-03-16 | Loiza | Puerto Rico | 72087 | 3133 | |
2309904 | 2309904 | 2022-03-15 | Loiza | Puerto Rico | 72087 | 3133 | |
2306757 | 2306757 | 2022-03-14 | Dewey | South Dakota | 46041 | 3133 | 40 |
2294209 | 2294209 | 2022-03-10 | Brunswick | Virginia | 51025 | 3133 | 45 |
2280600 | 2280600 | 2022-03-06 | Barceloneta | Puerto Rico | 72017 | 3133 | |
2277347 | 2277347 | 2022-03-05 | Barceloneta | Puerto Rico | 72017 | 3133 | |
2214805 | 2214805 | 2022-02-14 | Osage | Missouri | 29151 | 3133 | 39 |
2194725 | 2194725 | 2022-02-08 | Breathitt | Kentucky | 21025 | 3133 | 50 |
2195194 | 2195194 | 2022-02-08 | Tallahatchie | Mississippi | 28135 | 3133 | 56 |
2193664 | 2193664 | 2022-02-07 | Price | Wisconsin | 55099 | 3133 | 28 |
2189950 | 2189950 | 2022-02-06 | Jackson | Texas | 48239 | 3133 | 55 |
2186697 | 2186697 | 2022-02-05 | Jackson | Texas | 48239 | 3133 | 55 |
2168801 | 2168801 | 2022-01-31 | Trigg | Kentucky | 21221 | 3133 | 35 |
2154580 | 2154580 | 2022-01-26 | Buffalo | Wisconsin | 55011 | 3133 | 11 |
2146305 | 2146305 | 2022-01-24 | Renville | Minnesota | 27129 | 3133 | 52 |
2127599 | 2127599 | 2022-01-18 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2124347 | 2124347 | 2022-01-17 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2121095 | 2121095 | 2022-01-16 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2117843 | 2117843 | 2022-01-15 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2114592 | 2114592 | 2022-01-14 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2111340 | 2111340 | 2022-01-13 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2108088 | 2108088 | 2022-01-12 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2074062 | 2074062 | 2022-01-02 | White | Illinois | 17193 | 3133 | 44 |
2070811 | 2070811 | 2022-01-01 | White | Illinois | 17193 | 3133 | 44 |
2067560 | 2067560 | 2021-12-31 | White | Illinois | 17193 | 3133 | 44 |
2064309 | 2064309 | 2021-12-30 | White | Illinois | 17193 | 3133 | 44 |
2041352 | 2041352 | 2021-12-23 | Meriwether | Georgia | 13199 | 3133 | 121 |
2033719 | 2033719 | 2021-12-20 | Sequatchie | Tennessee | 47153 | 3133 | 44 |
2023696 | 2023696 | 2021-12-17 | Aguadilla | Puerto Rico | 72005 | 3133 | |
2018375 | 2018375 | 2021-12-16 | Elbert | Colorado | 8039 | 3133 | 30 |
1995259 | 1995259 | 2021-12-08 | Adams | Wisconsin | 55001 | 3133 | 37 |
1986152 | 1986152 | 2021-12-06 | Worth | Georgia | 13321 | 3133 | 95 |
1982902 | 1982902 | 2021-12-05 | Worth | Georgia | 13321 | 3133 | 95 |
1979652 | 1979652 | 2021-12-04 | Worth | Georgia | 13321 | 3133 | 95 |
1976402 | 1976402 | 2021-12-03 | Worth | Georgia | 13321 | 3133 | 95 |
1975044 | 1975044 | 2021-12-02 | Hampton | South Carolina | 45049 | 3133 | 74 |
1967875 | 1967875 | 2021-11-30 | Humboldt | Nevada | 32013 | 3133 | 39 |
1963401 | 1963401 | 2021-11-29 | Worth | Georgia | 13321 | 3133 | 95 |
1961024 | 1961024 | 2021-11-28 | Chickasaw | Mississippi | 28017 | 3133 | 67 |
1961965 | 1961965 | 2021-11-28 | Gurabo | Puerto Rico | 72063 | 3133 | |
1957773 | 1957773 | 2021-11-27 | Chickasaw | Mississippi | 28017 | 3133 | 67 |
1958714 | 1958714 | 2021-11-27 | Gurabo | Puerto Rico | 72063 | 3133 | |
1954522 | 1954522 | 2021-11-26 | Chickasaw | Mississippi | 28017 | 3133 | 67 |
1951271 | 1951271 | 2021-11-25 | Chickasaw | Mississippi | 28017 | 3133 | 67 |
1948020 | 1948020 | 2021-11-24 | Chickasaw | Mississippi | 28017 | 3133 | 67 |
1948964 | 1948964 | 2021-11-24 | Humacao | Puerto Rico | 72069 | 3133 | |
1930352 | 1930352 | 2021-11-19 | Cherokee | Alabama | 1019 | 3133 | 62 |
1924606 | 1924606 | 2021-11-17 | Orange | Indiana | 18117 | 3133 | 74 |
1926637 | 1926637 | 2021-11-17 | Montague | Texas | 48337 | 3133 | 95 |
1920997 | 1920997 | 2021-11-16 | Brantley | Georgia | 13025 | 3133 | 87 |
1917747 | 1917747 | 2021-11-15 | Brantley | Georgia | 13025 | 3133 | 87 |
1914497 | 1914497 | 2021-11-14 | Brantley | Georgia | 13025 | 3133 | 87 |
1911247 | 1911247 | 2021-11-13 | Brantley | Georgia | 13025 | 3133 | 87 |
1907998 | 1907998 | 2021-11-12 | Brantley | Georgia | 13025 | 3133 | 87 |
1904749 | 1904749 | 2021-11-11 | Brantley | Georgia | 13025 | 3133 | 87 |
1901499 | 1901499 | 2021-11-10 | Brantley | Georgia | 13025 | 3133 | 87 |
1899454 | 1899454 | 2021-11-09 | Vernon | Missouri | 29217 | 3133 | 67 |
1878540 | 1878540 | 2021-11-03 | Colusa | California | 6011 | 3133 | 19 |
1880419 | 1880419 | 2021-11-03 | Carroll | Ohio | 39019 | 3133 | 66 |
1837317 | 1837317 | 2021-10-21 | Caroline | Maryland | 24011 | 3133 | 47 |
1832984 | 1832984 | 2021-10-20 | Conway | Arkansas | 5029 | 3133 | 43 |
1833869 | 1833869 | 2021-10-20 | Bourbon | Kentucky | 21017 | 3133 | 33 |
1828610 | 1828610 | 2021-10-18 | Lincoln | Oregon | 41041 | 3133 | 38 |
1814358 | 1814358 | 2021-10-14 | Sumner | Kansas | 20191 | 3133 | 59 |
1811109 | 1811109 | 2021-10-13 | Sumner | Kansas | 20191 | 3133 | 59 |
1807918 | 1807918 | 2021-10-12 | Harrison | Kentucky | 21097 | 3133 | 33 |
1797231 | 1797231 | 2021-10-09 | Ashley | Arkansas | 5003 | 3133 | 45 |
1787537 | 1787537 | 2021-10-06 | Phillips | Arkansas | 5107 | 3133 | 71 |
1780995 | 1780995 | 2021-10-04 | Clark | Arkansas | 5019 | 3133 | 51 |
1777745 | 1777745 | 2021-10-03 | Clark | Arkansas | 5019 | 3133 | 51 |
1762380 | 1762380 | 2021-09-28 | Adair | Kentucky | 21001 | 3133 | 70 |
1759132 | 1759132 | 2021-09-27 | Adair | Kentucky | 21001 | 3133 | 70 |
1757345 | 1757345 | 2021-09-26 | Beadle | South Dakota | 46005 | 3133 | 43 |
1753492 | 1753492 | 2021-09-25 | Delaware | New York | 36025 | 3133 | 42 |
1754097 | 1754097 | 2021-09-25 | Beadle | South Dakota | 46005 | 3133 | 43 |
1750849 | 1750849 | 2021-09-24 | Beadle | South Dakota | 46005 | 3133 | 43 |
1722863 | 1722863 | 2021-09-16 | Jones | Georgia | 13169 | 3133 | 71 |
1696892 | 1696892 | 2021-09-08 | McDuffie | Georgia | 13189 | 3133 | 58 |
1697000 | 1697000 | 2021-09-08 | Payette | Idaho | 16075 | 3133 | 41 |
1654637 | 1654637 | 2021-08-26 | Haralson | Georgia | 13143 | 3133 | 93 |
1651391 | 1651391 | 2021-08-25 | Harris | Georgia | 13145 | 3133 | 66 |
1645797 | 1645797 | 2021-08-23 | Le Sueur | Minnesota | 27079 | 3133 | 28 |
1632157 | 1632157 | 2021-08-19 | Fayette | Indiana | 18041 | 3133 | 68 |
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);