ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
139 rows where cases = 3639 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 15
- Georgia 9
- Tennessee 9
- Texas 8
- Virginia 8
- Florida 7
- Idaho 7
- Wisconsin 7
- Iowa 6
- Louisiana 6
- Missouri 6
- Illinois 5
- Arkansas 4
- Mississippi 4
- Puerto Rico 4
- Indiana 3
- Kentucky 3
- New York 3
- Alabama 2
- Arizona 2
- Kansas 2
- Maryland 2
- Nebraska 2
- Ohio 2
- Pennsylvania 2
- California 1
- Colorado 1
- Maine 1
- Michigan 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474144 | 2474144 | 2022-05-05 | Greene | Illinois | 17061 | 3639 | 58 |
2430954 | 2430954 | 2022-04-21 | Patrick | Virginia | 51141 | 3639 | 94 |
2423760 | 2423760 | 2022-04-19 | Anasco | Puerto Rico | 72011 | 3639 | |
2420504 | 2420504 | 2022-04-18 | Anasco | Puerto Rico | 72011 | 3639 | |
2405716 | 2405716 | 2022-04-14 | Gem | Idaho | 16045 | 3639 | 79 |
2398563 | 2398563 | 2022-04-11 | Lafayette | Wisconsin | 55065 | 3639 | 22 |
2376420 | 2376420 | 2022-04-05 | Gem | Idaho | 16045 | 3639 | 79 |
2373168 | 2373168 | 2022-04-04 | Gem | Idaho | 16045 | 3639 | 79 |
2369915 | 2369915 | 2022-04-03 | Gem | Idaho | 16045 | 3639 | 79 |
2366662 | 2366662 | 2022-04-02 | Gem | Idaho | 16045 | 3639 | 79 |
2363409 | 2363409 | 2022-04-01 | Gem | Idaho | 16045 | 3639 | 79 |
2316424 | 2316424 | 2022-03-17 | Quebradillas | Puerto Rico | 72115 | 3639 | |
2286154 | 2286154 | 2022-03-08 | Renville | Minnesota | 27129 | 3639 | 56 |
2271378 | 2271378 | 2022-03-03 | Zapata | Texas | 48505 | 3639 | 52 |
2262466 | 2262466 | 2022-03-01 | Jefferson | Georgia | 13163 | 3639 | 105 |
2224046 | 2224046 | 2022-02-17 | Larue | Kentucky | 21123 | 3639 | 65 |
2209506 | 2209506 | 2022-02-12 | Madison | Texas | 48313 | 3639 | 50 |
2200810 | 2200810 | 2022-02-10 | Minidoka | Idaho | 16067 | 3639 | 55 |
2175586 | 2175586 | 2022-02-02 | Redwood | Minnesota | 27127 | 3639 | 51 |
2149573 | 2149573 | 2022-01-25 | Wadena | Minnesota | 27159 | 3639 | 47 |
2104471 | 2104471 | 2022-01-11 | Taos | New Mexico | 35055 | 3639 | 75 |
2104559 | 2104559 | 2022-01-11 | Currituck | North Carolina | 37053 | 3639 | 30 |
2083423 | 2083423 | 2022-01-05 | Teller | Colorado | 8119 | 3639 | 51 |
2077312 | 2077312 | 2022-01-03 | Wayne | Illinois | 17191 | 3639 | 68 |
2078659 | 2078659 | 2022-01-03 | Rolette | North Dakota | 38079 | 3639 | 36 |
2050774 | 2050774 | 2021-12-26 | Ouachita | Arkansas | 5103 | 3639 | 88 |
2004623 | 2004623 | 2021-12-11 | Lampasas | Texas | 48281 | 3639 | 70 |
1993459 | 1993459 | 2021-12-08 | Hubbard | Minnesota | 27057 | 3639 | 49 |
1985371 | 1985371 | 2021-12-05 | Page | Virginia | 51139 | 3639 | 89 |
1982121 | 1982121 | 2021-12-04 | Page | Virginia | 51139 | 3639 | 89 |
1978871 | 1978871 | 2021-12-03 | Page | Virginia | 51139 | 3639 | 89 |
1973030 | 1973030 | 2021-12-02 | Cook | Georgia | 13075 | 3639 | 65 |
1974674 | 1974674 | 2021-12-02 | Carroll | Ohio | 39019 | 3639 | 78 |
1968803 | 1968803 | 2021-11-30 | Fayette | Texas | 48149 | 3639 | 93 |
1965552 | 1965552 | 2021-11-29 | Fayette | Texas | 48149 | 3639 | 93 |
1927024 | 1927024 | 2021-11-17 | Jackson | Wisconsin | 55053 | 3639 | 34 |
1899327 | 1899327 | 2021-11-09 | Stone | Mississippi | 28131 | 3639 | 66 |
1839331 | 1839331 | 2021-10-21 | Waushara | Wisconsin | 55137 | 3639 | 50 |
1829356 | 1829356 | 2021-10-18 | Lee | Virginia | 51105 | 3639 | 57 |
1820013 | 1820013 | 2021-10-16 | Lincoln | Arkansas | 5079 | 3639 | 57 |
1788809 | 1788809 | 2021-10-06 | Grenada | Mississippi | 28043 | 3639 | 108 |
1782096 | 1782096 | 2021-10-04 | Queen Anne's | Maryland | 24035 | 3639 | 64 |
1775876 | 1775876 | 2021-10-02 | Audrain | Missouri | 29007 | 3639 | 64 |
1773414 | 1773414 | 2021-10-01 | Elk | Pennsylvania | 42047 | 3639 | 49 |
1762716 | 1762716 | 2021-09-28 | Cass | Minnesota | 27021 | 3639 | 38 |
1750479 | 1750479 | 2021-09-24 | Hardin | Ohio | 39065 | 3639 | 70 |
1730101 | 1730101 | 2021-09-18 | Dorchester | Maryland | 24019 | 3639 | 70 |
1722838 | 1722838 | 2021-09-16 | Franklin | Georgia | 13119 | 3639 | 64 |
1723532 | 1723532 | 2021-09-16 | Grant | Louisiana | 22043 | 3639 | 73 |
1721828 | 1721828 | 2021-09-15 | Dimmit | Texas | 48127 | 3639 | 41 |
1712018 | 1712018 | 2021-09-12 | Wayne | Tennessee | 47181 | 3639 | 37 |
1708771 | 1708771 | 2021-09-11 | Wayne | Tennessee | 47181 | 3639 | 37 |
1705524 | 1705524 | 2021-09-10 | Wayne | Tennessee | 47181 | 3639 | 37 |
1654566 | 1654566 | 2021-08-26 | Washington | Florida | 12133 | 3639 | 52 |
1651319 | 1651319 | 2021-08-25 | Washington | Florida | 12133 | 3639 | 52 |
1648070 | 1648070 | 2021-08-24 | Washington | Florida | 12133 | 3639 | 52 |
1644822 | 1644822 | 2021-08-23 | Washington | Florida | 12133 | 3639 | 52 |
1641572 | 1641572 | 2021-08-22 | Washington | Florida | 12133 | 3639 | 52 |
1638322 | 1638322 | 2021-08-21 | Washington | Florida | 12133 | 3639 | 52 |
1635072 | 1635072 | 2021-08-20 | Washington | Florida | 12133 | 3639 | 52 |
1636530 | 1636530 | 2021-08-20 | Allegany | New York | 36003 | 3639 | 87 |
1631968 | 1631968 | 2021-08-19 | Unknown | Georgia | 3639 | 6 | |
1625946 | 1625946 | 2021-08-17 | Bell | Kentucky | 21013 | 3639 | 58 |
1604105 | 1604105 | 2021-08-10 | Wyoming | New York | 36121 | 3639 | 53 |
1576745 | 1576745 | 2021-08-02 | Upson | Georgia | 13293 | 3639 | 133 |
1557250 | 1557250 | 2021-07-27 | Toombs | Georgia | 13279 | 3639 | 121 |
1532994 | 1532994 | 2021-07-19 | Malheur | Oregon | 41045 | 3639 | 67 |
1460690 | 1460690 | 2021-06-27 | Lyon | Minnesota | 27083 | 3639 | 54 |
1457445 | 1457445 | 2021-06-26 | Lyon | Minnesota | 27083 | 3639 | 54 |
1446520 | 1446520 | 2021-06-23 | St. Francis | Arkansas | 5123 | 3639 | 44 |
1447709 | 1447709 | 2021-06-23 | Lyon | Minnesota | 27083 | 3639 | 53 |
1443275 | 1443275 | 2021-06-22 | St. Francis | Arkansas | 5123 | 3639 | 44 |
1444291 | 1444291 | 2021-06-22 | Oxford | Maine | 23017 | 3639 | 67 |
1420152 | 1420152 | 2021-06-14 | Prince George | Virginia | 51149 | 3639 | 32 |
1411180 | 1411180 | 2021-06-12 | Wayne | Georgia | 13305 | 3639 | 91 |
1412005 | 1412005 | 2021-06-12 | Lyon | Minnesota | 27083 | 3639 | 53 |
1408760 | 1408760 | 2021-06-11 | Lyon | Minnesota | 27083 | 3639 | 52 |
1405515 | 1405515 | 2021-06-10 | Lyon | Minnesota | 27083 | 3639 | 52 |
1402269 | 1402269 | 2021-06-09 | Lyon | Minnesota | 27083 | 3639 | 52 |
1399024 | 1399024 | 2021-06-08 | Lyon | Minnesota | 27083 | 3639 | 52 |
1395778 | 1395778 | 2021-06-07 | Lyon | Minnesota | 27083 | 3639 | 52 |
1386235 | 1386235 | 2021-06-04 | Marion | Missouri | 29127 | 3639 | 52 |
1382990 | 1382990 | 2021-06-03 | Marion | Missouri | 29127 | 3639 | 52 |
1358043 | 1358043 | 2021-05-26 | Macon | Tennessee | 47111 | 3639 | 78 |
1353262 | 1353262 | 2021-05-25 | Greenup | Kentucky | 21089 | 3639 | 59 |
1354797 | 1354797 | 2021-05-25 | Macon | Tennessee | 47111 | 3639 | 78 |
1355391 | 1355391 | 2021-05-25 | Green | Wisconsin | 55045 | 3639 | 25 |
1349829 | 1349829 | 2021-05-24 | Marion | Iowa | 19125 | 3639 | 76 |
1351551 | 1351551 | 2021-05-24 | Macon | Tennessee | 47111 | 3639 | 78 |
1346582 | 1346582 | 2021-05-23 | Marion | Iowa | 19125 | 3639 | 76 |
1346864 | 1346864 | 2021-05-23 | Evangeline | Louisiana | 22039 | 3639 | 93 |
1343334 | 1343334 | 2021-05-22 | Marion | Iowa | 19125 | 3639 | 76 |
1343616 | 1343616 | 2021-05-22 | Evangeline | Louisiana | 22039 | 3639 | 93 |
1340086 | 1340086 | 2021-05-21 | Marion | Iowa | 19125 | 3639 | 76 |
1340368 | 1340368 | 2021-05-21 | Evangeline | Louisiana | 22039 | 3639 | 93 |
1336839 | 1336839 | 2021-05-20 | Marion | Iowa | 19125 | 3639 | 76 |
1337121 | 1337121 | 2021-05-20 | Evangeline | Louisiana | 22039 | 3639 | 93 |
1300673 | 1300673 | 2021-05-09 | Bryan | Georgia | 13029 | 3639 | 39 |
1293742 | 1293742 | 2021-05-06 | Trempealeau | Wisconsin | 55121 | 3639 | 44 |
1283952 | 1283952 | 2021-05-03 | Clark | Wisconsin | 55019 | 3639 | 62 |
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);