ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where cases = 6874 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Florida 8
- New Hampshire 8
- Oklahoma 8
- Tennessee 6
- Texas 6
- West Virginia 6
- Minnesota 4
- Wisconsin 4
- Mississippi 3
- Virginia 3
- Washington 3
- California 2
- Georgia 2
- Ohio 2
- Wyoming 2
- Arizona 1
- Colorado 1
- Illinois 1
- Kentucky 1
- Maryland 1
- Missouri 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Oregon 1
- South Carolina 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495804 | 2495804 | 2022-05-11 | Howard | Texas | 48227 | 6874 | 184 |
2384137 | 2384137 | 2022-04-07 | Coos | New Hampshire | 33007 | 6874 | 110 |
2380882 | 2380882 | 2022-04-06 | Coos | New Hampshire | 33007 | 6874 | 110 |
2377627 | 2377627 | 2022-04-05 | Coos | New Hampshire | 33007 | 6874 | 110 |
2374374 | 2374374 | 2022-04-04 | Coos | New Hampshire | 33007 | 6874 | 110 |
2371122 | 2371122 | 2022-04-03 | Coos | New Hampshire | 33007 | 6874 | 110 |
2372455 | 2372455 | 2022-04-03 | Jackson | West Virginia | 54035 | 6874 | 135 |
2367869 | 2367869 | 2022-04-02 | Coos | New Hampshire | 33007 | 6874 | 110 |
2369202 | 2369202 | 2022-04-02 | Jackson | West Virginia | 54035 | 6874 | 135 |
2364616 | 2364616 | 2022-04-01 | Coos | New Hampshire | 33007 | 6874 | 110 |
2365949 | 2365949 | 2022-04-01 | Jackson | West Virginia | 54035 | 6874 | 135 |
2361362 | 2361362 | 2022-03-31 | Coos | New Hampshire | 33007 | 6874 | 110 |
2268950 | 2268950 | 2022-03-03 | Gilmer | Georgia | 13123 | 6874 | 164 |
2219651 | 2219651 | 2022-02-15 | Door | Wisconsin | 55029 | 6874 | 57 |
2219671 | 2219671 | 2022-02-15 | Lincoln | Wisconsin | 55069 | 6874 | 134 |
2214691 | 2214691 | 2022-02-14 | Marion | Mississippi | 28091 | 6874 | 129 |
2195958 | 2195958 | 2022-02-08 | Jefferson | Oregon | 41031 | 6874 | 73 |
2174673 | 2174673 | 2022-02-02 | Lee | Georgia | 13177 | 6874 | 92 |
2152796 | 2152796 | 2022-01-26 | Nicollet | Minnesota | 27103 | 6874 | 64 |
2112252 | 2112252 | 2022-01-13 | Logan | West Virginia | 54045 | 6874 | 155 |
2058209 | 2058209 | 2021-12-28 | Perry | Kentucky | 21193 | 6874 | 131 |
2026761 | 2026761 | 2021-12-18 | Williams | Ohio | 39171 | 6874 | 106 |
1995238 | 1995238 | 2021-12-08 | Ohio | West Virginia | 54069 | 6874 | 119 |
1992080 | 1992080 | 2021-12-07 | Albany | Wyoming | 56001 | 6874 | 40 |
1968698 | 1968698 | 2021-11-30 | Obion | Tennessee | 47131 | 6874 | 111 |
1922805 | 1922805 | 2021-11-16 | Pittsburg | Oklahoma | 40121 | 6874 | 158 |
1919556 | 1919556 | 2021-11-15 | Pittsburg | Oklahoma | 40121 | 6874 | 158 |
1916306 | 1916306 | 2021-11-14 | Pittsburg | Oklahoma | 40121 | 6874 | 158 |
1913056 | 1913056 | 2021-11-13 | Pittsburg | Oklahoma | 40121 | 6874 | 158 |
1909806 | 1909806 | 2021-11-12 | Pittsburg | Oklahoma | 40121 | 6874 | 158 |
1905808 | 1905808 | 2021-11-11 | Monroe | Mississippi | 28095 | 6874 | 179 |
1906557 | 1906557 | 2021-11-11 | Pittsburg | Oklahoma | 40121 | 6874 | 158 |
1902559 | 1902559 | 2021-11-10 | Monroe | Mississippi | 28095 | 6874 | 179 |
1903308 | 1903308 | 2021-11-10 | Pittsburg | Oklahoma | 40121 | 6874 | 158 |
1874750 | 1874750 | 2021-11-01 | Summit | Utah | 49043 | 6874 | 18 |
1864162 | 1864162 | 2021-10-29 | Williams | North Dakota | 38105 | 6874 | 51 |
1834923 | 1834923 | 2021-10-20 | Ashland | Ohio | 39005 | 6874 | 126 |
1809468 | 1809468 | 2021-10-12 | Rhea | Tennessee | 47143 | 6874 | 90 |
1778957 | 1778957 | 2021-10-03 | Benton | Minnesota | 27009 | 6874 | 102 |
1775707 | 1775707 | 2021-10-02 | Benton | Minnesota | 27009 | 6874 | 102 |
1772457 | 1772457 | 2021-10-01 | Benton | Minnesota | 27009 | 6874 | 102 |
1741508 | 1741508 | 2021-09-21 | Wilson | Texas | 48493 | 6874 | 107 |
1721938 | 1721938 | 2021-09-15 | Nacogdoches | Texas | 48347 | 6874 | 191 |
1696673 | 1696673 | 2021-09-08 | Garfield | Colorado | 8045 | 6874 | 57 |
1670150 | 1670150 | 2021-08-30 | Harrisonburg city | Virginia | 51660 | 6874 | 95 |
1660187 | 1660187 | 2021-08-27 | Lamar | Texas | 48277 | 6874 | 165 |
1656938 | 1656938 | 2021-08-26 | Lamar | Texas | 48277 | 6874 | 165 |
1657255 | 1657255 | 2021-08-26 | Lewis | Washington | 53041 | 6874 | 86 |
1621009 | 1621009 | 2021-08-15 | Hawkins | Tennessee | 47073 | 6874 | 124 |
1617761 | 1617761 | 2021-08-14 | Hawkins | Tennessee | 47073 | 6874 | 124 |
1614513 | 1614513 | 2021-08-13 | Hawkins | Tennessee | 47073 | 6874 | 124 |
1495405 | 1495405 | 2021-07-08 | Putnam | Florida | 12107 | 6874 | 160 |
1492159 | 1492159 | 2021-07-07 | Putnam | Florida | 12107 | 6874 | 160 |
1488912 | 1488912 | 2021-07-06 | Putnam | Florida | 12107 | 6874 | 160 |
1485665 | 1485665 | 2021-07-05 | Putnam | Florida | 12107 | 6874 | 160 |
1482419 | 1482419 | 2021-07-04 | Putnam | Florida | 12107 | 6874 | 160 |
1479172 | 1479172 | 2021-07-03 | Putnam | Florida | 12107 | 6874 | 160 |
1475926 | 1475926 | 2021-07-02 | Putnam | Florida | 12107 | 6874 | 160 |
1462356 | 1462356 | 2021-06-27 | Rockingham | Virginia | 51165 | 6874 | 112 |
1360530 | 1360530 | 2021-05-27 | Eddy | New Mexico | 35015 | 6874 | 139 |
1313069 | 1313069 | 2021-05-12 | Chelan | Washington | 53007 | 6874 | 67 |
1309822 | 1309822 | 2021-05-11 | Chelan | Washington | 53007 | 6874 | 67 |
1263851 | 1263851 | 2021-04-27 | Coffee | Tennessee | 47031 | 6874 | 121 |
1221736 | 1221736 | 2021-04-14 | Bowie | Texas | 48037 | 6874 | 209 |
1084701 | 1084701 | 2021-03-03 | Sampson | North Carolina | 37163 | 6874 | 91 |
1066239 | 1066239 | 2021-02-25 | Lynchburg city | Virginia | 51680 | 6874 | 109 |
1037180 | 1037180 | 2021-02-16 | Wood | West Virginia | 54107 | 6874 | 125 |
1037231 | 1037231 | 2021-02-16 | Portage | Wisconsin | 55097 | 6874 | 66 |
983613 | 983613 | 2021-01-31 | Cass | Missouri | 29037 | 6874 | 69 |
945038 | 945038 | 2021-01-19 | Rensselaer | New York | 36083 | 6874 | 104 |
899919 | 899919 | 2021-01-05 | Muskogee | Oklahoma | 40101 | 6874 | 53 |
871745 | 871745 | 2020-12-27 | Laramie | Wyoming | 56021 | 6874 | 51 |
794522 | 794522 | 2020-12-04 | Macon | Illinois | 17115 | 6874 | 145 |
780859 | 780859 | 2020-11-29 | Walworth | Wisconsin | 55127 | 6874 | 50 |
754100 | 754100 | 2020-11-21 | Berkeley | South Carolina | 45015 | 6874 | 103 |
612389 | 612389 | 2020-10-09 | Marin | California | 6041 | 6874 | 124 |
541130 | 541130 | 2020-09-17 | Sonoma | California | 6097 | 6874 | 114 |
495964 | 495964 | 2020-09-03 | Leon | Florida | 12073 | 6874 | 38 |
353936 | 353936 | 2020-07-21 | Pinal | Arizona | 4021 | 6874 | 109 |
247529 | 247529 | 2020-06-17 | Baltimore city | Maryland | 24510 | 6874 | 307 |
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);