ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 6972 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Florida 10
- Oklahoma 7
- Rhode Island 7
- Minnesota 4
- Oregon 4
- New York 3
- Ohio 3
- Pennsylvania 3
- Puerto Rico 3
- Tennessee 3
- Virginia 3
- Alabama 2
- South Carolina 2
- Wisconsin 2
- Idaho 1
- Maryland 1
- Missouri 1
- Nebraska 1
- North Carolina 1
- South Dakota 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485671 | 2485671 | 2022-05-08 | Manati | Puerto Rico | 72091 | 6972 | |
2482413 | 2482413 | 2022-05-07 | Manati | Puerto Rico | 72091 | 6972 | |
2468381 | 2468381 | 2022-05-03 | Nobles | Minnesota | 27105 | 6972 | 60 |
2443886 | 2443886 | 2022-04-25 | Accomack | Virginia | 51001 | 6972 | 106 |
2421335 | 2421335 | 2022-04-18 | Door | Wisconsin | 55029 | 6972 | 71 |
2359479 | 2359479 | 2022-03-30 | Wyoming | West Virginia | 54109 | 6972 | 112 |
2306524 | 2306524 | 2022-03-14 | Lincoln | Oregon | 41041 | 6972 | 78 |
2300106 | 2300106 | 2022-03-12 | Aguadilla | Puerto Rico | 72005 | 6972 | |
2284020 | 2284020 | 2022-03-07 | Meade | South Dakota | 46093 | 6972 | 62 |
2192548 | 2192548 | 2022-02-07 | Gallia | Ohio | 39053 | 6972 | 102 |
2110855 | 2110855 | 2022-01-13 | Lincoln | Nebraska | 31111 | 6972 | 87 |
1988878 | 1988878 | 2021-12-07 | Escambia | Alabama | 1053 | 6972 | 146 |
1982371 | 1982371 | 2021-12-05 | Covington | Alabama | 1039 | 6972 | 197 |
1881956 | 1881956 | 2021-11-04 | Levy | Florida | 12075 | 6972 | 82 |
1878707 | 1878707 | 2021-11-03 | Levy | Florida | 12075 | 6972 | 82 |
1875458 | 1875458 | 2021-11-02 | Levy | Florida | 12075 | 6972 | 82 |
1872209 | 1872209 | 2021-11-01 | Levy | Florida | 12075 | 6972 | 82 |
1868960 | 1868960 | 2021-10-31 | Levy | Florida | 12075 | 6972 | 82 |
1865711 | 1865711 | 2021-10-30 | Levy | Florida | 12075 | 6972 | 82 |
1862462 | 1862462 | 2021-10-29 | Levy | Florida | 12075 | 6972 | 82 |
1838647 | 1838647 | 2021-10-21 | Cheatham | Tennessee | 47021 | 6972 | 70 |
1802623 | 1802623 | 2021-10-10 | Polk | Oregon | 41053 | 6972 | 77 |
1799374 | 1799374 | 2021-10-09 | Polk | Oregon | 41053 | 6972 | 77 |
1796125 | 1796125 | 2021-10-08 | Polk | Oregon | 41053 | 6972 | 77 |
1766910 | 1766910 | 2021-09-29 | Columbia | Pennsylvania | 42037 | 6972 | 142 |
1730399 | 1730399 | 2021-09-18 | Callaway | Missouri | 29027 | 6972 | 61 |
1695101 | 1695101 | 2021-09-07 | Granville | North Carolina | 37077 | 6972 | 92 |
1695434 | 1695434 | 2021-09-07 | Carbon | Pennsylvania | 42025 | 6972 | 178 |
1624256 | 1624256 | 2021-08-16 | Hawkins | Tennessee | 47073 | 6972 | 124 |
1597049 | 1597049 | 2021-08-08 | Crow Wing | Minnesota | 27035 | 6972 | 99 |
1593800 | 1593800 | 2021-08-07 | Crow Wing | Minnesota | 27035 | 6972 | 99 |
1590551 | 1590551 | 2021-08-06 | Crow Wing | Minnesota | 27035 | 6972 | 99 |
1588895 | 1588895 | 2021-08-05 | Bedford | Virginia | 51019 | 6972 | 110 |
1513672 | 1513672 | 2021-07-13 | Newport | Rhode Island | 44005 | 6972 | 43 |
1510426 | 1510426 | 2021-07-12 | Newport | Rhode Island | 44005 | 6972 | 43 |
1507179 | 1507179 | 2021-07-11 | Newport | Rhode Island | 44005 | 6972 | 43 |
1503933 | 1503933 | 2021-07-10 | Newport | Rhode Island | 44005 | 6972 | 43 |
1500687 | 1500687 | 2021-07-09 | Newport | Rhode Island | 44005 | 6972 | 43 |
1497441 | 1497441 | 2021-07-08 | Newport | Rhode Island | 44005 | 6972 | 43 |
1494194 | 1494194 | 2021-07-07 | Newport | Rhode Island | 44005 | 6972 | 43 |
1480688 | 1480688 | 2021-07-03 | Steuben | New York | 36101 | 6972 | 146 |
1354384 | 1354384 | 2021-05-25 | Creek | Oklahoma | 40037 | 6972 | 157 |
1351138 | 1351138 | 2021-05-24 | Creek | Oklahoma | 40037 | 6972 | 157 |
1347892 | 1347892 | 2021-05-23 | Creek | Oklahoma | 40037 | 6972 | 157 |
1343679 | 1343679 | 2021-05-22 | Allegany | Maryland | 24001 | 6972 | 208 |
1344644 | 1344644 | 2021-05-22 | Creek | Oklahoma | 40037 | 6972 | 157 |
1341396 | 1341396 | 2021-05-21 | Creek | Oklahoma | 40037 | 6972 | 157 |
1338148 | 1338148 | 2021-05-20 | Creek | Oklahoma | 40037 | 6972 | 157 |
1334901 | 1334901 | 2021-05-19 | Creek | Oklahoma | 40037 | 6972 | 157 |
1297387 | 1297387 | 2021-05-08 | Monroe | Florida | 12087 | 6972 | 49 |
1257097 | 1257097 | 2021-04-25 | Crawford | Pennsylvania | 42039 | 6972 | 147 |
1230719 | 1230719 | 2021-04-17 | Oswego | New York | 36075 | 6972 | 90 |
1190447 | 1190447 | 2021-04-05 | Madison | Idaho | 16065 | 6972 | 23 |
1150086 | 1150086 | 2021-03-23 | Kershaw | South Carolina | 45055 | 6972 | 130 |
1118175 | 1118175 | 2021-03-13 | Lynchburg city | Virginia | 51680 | 6972 | 142 |
1097781 | 1097781 | 2021-03-07 | Erie | Ohio | 39043 | 6972 | 146 |
1091816 | 1091816 | 2021-03-05 | Tipton | Tennessee | 47167 | 6972 | 103 |
948843 | 948843 | 2021-01-20 | Lancaster | South Carolina | 45057 | 6972 | 105 |
861955 | 861955 | 2020-12-24 | Jefferson | Wisconsin | 55055 | 6972 | 60 |
850917 | 850917 | 2020-12-21 | Niagara | New York | 36063 | 6972 | 157 |
799192 | 799192 | 2020-12-05 | Delaware | Ohio | 39041 | 6972 | 42 |
521833 | 521833 | 2020-09-11 | Lake | Florida | 12069 | 6972 | 140 |
466837 | 466837 | 2020-08-25 | Brevard | Florida | 12009 | 6972 | 195 |
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);