ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
118 rows where cases = 4611 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Kansas 12
- Indiana 11
- Georgia 10
- Texas 8
- Iowa 7
- Michigan 7
- Wyoming 7
- Minnesota 6
- Arkansas 5
- Illinois 5
- North Carolina 4
- Ohio 4
- Puerto Rico 4
- Mississippi 3
- Pennsylvania 3
- Utah 3
- Virginia 3
- Idaho 2
- Maryland 2
- New York 2
- Wisconsin 2
- Florida 1
- Hawaii 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Oregon 1
- Tennessee 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467845 | 2467845 | 2022-05-03 | Jackson | Iowa | 19097 | 4611 | 69 |
2464590 | 2464590 | 2022-05-02 | Jackson | Iowa | 19097 | 4611 | 69 |
2461334 | 2461334 | 2022-05-01 | Jackson | Iowa | 19097 | 4611 | 69 |
2458078 | 2458078 | 2022-04-30 | Jackson | Iowa | 19097 | 4611 | 69 |
2454822 | 2454822 | 2022-04-29 | Jackson | Iowa | 19097 | 4611 | 69 |
2451566 | 2451566 | 2022-04-28 | Jackson | Iowa | 19097 | 4611 | 69 |
2448310 | 2448310 | 2022-04-27 | Jackson | Iowa | 19097 | 4611 | 69 |
2405746 | 2405746 | 2022-04-14 | Cass | Illinois | 17017 | 4611 | 44 |
2400864 | 2400864 | 2022-04-12 | Clatsop | Oregon | 41007 | 4611 | 49 |
2377155 | 2377155 | 2022-04-05 | Roscommon | Michigan | 26143 | 4611 | 113 |
2378855 | 2378855 | 2022-04-05 | New Kent | Virginia | 51127 | 4611 | 32 |
2373903 | 2373903 | 2022-04-04 | Roscommon | Michigan | 26143 | 4611 | 113 |
2370650 | 2370650 | 2022-04-03 | Roscommon | Michigan | 26143 | 4611 | 113 |
2367397 | 2367397 | 2022-04-02 | Roscommon | Michigan | 26143 | 4611 | 113 |
2364144 | 2364144 | 2022-04-01 | Roscommon | Michigan | 26143 | 4611 | 113 |
2360890 | 2360890 | 2022-03-31 | Roscommon | Michigan | 26143 | 4611 | 113 |
2357636 | 2357636 | 2022-03-30 | Roscommon | Michigan | 26143 | 4611 | 113 |
2359145 | 2359145 | 2022-03-30 | Reeves | Texas | 48389 | 4611 | 74 |
2355891 | 2355891 | 2022-03-29 | Reeves | Texas | 48389 | 4611 | 74 |
2352638 | 2352638 | 2022-03-28 | Reeves | Texas | 48389 | 4611 | 74 |
2349386 | 2349386 | 2022-03-27 | Reeves | Texas | 48389 | 4611 | 74 |
2346133 | 2346133 | 2022-03-26 | Reeves | Texas | 48389 | 4611 | 74 |
2330276 | 2330276 | 2022-03-21 | Carbon | Wyoming | 56007 | 4611 | 52 |
2327024 | 2327024 | 2022-03-20 | Carbon | Wyoming | 56007 | 4611 | 52 |
2323771 | 2323771 | 2022-03-19 | Carbon | Wyoming | 56007 | 4611 | 52 |
2320517 | 2320517 | 2022-03-18 | Carbon | Wyoming | 56007 | 4611 | 52 |
2313935 | 2313935 | 2022-03-16 | Adams | Wisconsin | 55001 | 4611 | 55 |
2310682 | 2310682 | 2022-03-15 | Adams | Wisconsin | 55001 | 4611 | 55 |
2192758 | 2192758 | 2022-02-07 | Juniata | Pennsylvania | 42067 | 4611 | 169 |
2186666 | 2186666 | 2022-02-05 | Gonzales | Texas | 48177 | 4611 | 92 |
2174359 | 2174359 | 2022-02-02 | Phillips | Arkansas | 5107 | 4611 | 84 |
2170812 | 2170812 | 2022-01-31 | Lewis | West Virginia | 54041 | 4611 | 73 |
2099498 | 2099498 | 2022-01-10 | Cleburne | Arkansas | 5023 | 4611 | 104 |
2077777 | 2077777 | 2022-01-03 | Richland | Louisiana | 22083 | 4611 | 80 |
1997758 | 1997758 | 2021-12-09 | Trujillo Alto | Puerto Rico | 72139 | 4611 | |
1966824 | 1966824 | 2021-11-30 | Decatur | Indiana | 18031 | 4611 | 116 |
1961689 | 1961689 | 2021-11-28 | Gallia | Ohio | 39053 | 4611 | 78 |
1895182 | 1895182 | 2021-11-08 | Latah | Idaho | 16057 | 4611 | 37 |
1892725 | 1892725 | 2021-11-07 | Nicollet | Minnesota | 27103 | 4611 | 57 |
1889475 | 1889475 | 2021-11-06 | Nicollet | Minnesota | 27103 | 4611 | 57 |
1886225 | 1886225 | 2021-11-05 | Nicollet | Minnesota | 27103 | 4611 | 57 |
1869136 | 1869136 | 2021-10-31 | Unknown | Georgia | 4611 | 9 | |
1865887 | 1865887 | 2021-10-30 | Unknown | Georgia | 4611 | 9 | |
1862638 | 1862638 | 2021-10-29 | Unknown | Georgia | 4611 | 9 | |
1859000 | 1859000 | 2021-10-28 | Johnson | Arkansas | 5071 | 4611 | 57 |
1857943 | 1857943 | 2021-10-27 | Arecibo | Puerto Rico | 72013 | 4611 | |
1854694 | 1854694 | 2021-10-26 | Arecibo | Puerto Rico | 72013 | 4611 | |
1851445 | 1851445 | 2021-10-25 | Arecibo | Puerto Rico | 72013 | 4611 | |
1835178 | 1835178 | 2021-10-20 | Snyder | Pennsylvania | 42109 | 4611 | 100 |
1827345 | 1827345 | 2021-10-18 | Seward | Kansas | 20175 | 4611 | 46 |
1824096 | 1824096 | 2021-10-17 | Seward | Kansas | 20175 | 4611 | 46 |
1820847 | 1820847 | 2021-10-16 | Seward | Kansas | 20175 | 4611 | 46 |
1817598 | 1817598 | 2021-10-15 | Seward | Kansas | 20175 | 4611 | 46 |
1814350 | 1814350 | 2021-10-14 | Seward | Kansas | 20175 | 4611 | 45 |
1811101 | 1811101 | 2021-10-13 | Seward | Kansas | 20175 | 4611 | 45 |
1807852 | 1807852 | 2021-10-12 | Seward | Kansas | 20175 | 4611 | 45 |
1804601 | 1804601 | 2021-10-11 | Seward | Kansas | 20175 | 4611 | 45 |
1801352 | 1801352 | 2021-10-10 | Seward | Kansas | 20175 | 4611 | 45 |
1798103 | 1798103 | 2021-10-09 | Seward | Kansas | 20175 | 4611 | 45 |
1794854 | 1794854 | 2021-10-08 | Seward | Kansas | 20175 | 4611 | 45 |
1791606 | 1791606 | 2021-10-07 | Seward | Kansas | 20175 | 4611 | 45 |
1782976 | 1782976 | 2021-10-04 | Jackson | Ohio | 39079 | 4611 | 67 |
1778142 | 1778142 | 2021-10-03 | Stephens | Georgia | 13257 | 4611 | 95 |
1774892 | 1774892 | 2021-10-02 | Stephens | Georgia | 13257 | 4611 | 95 |
1776273 | 1776273 | 2021-10-02 | Tioga | New York | 36107 | 4611 | 68 |
1771642 | 1771642 | 2021-10-01 | Stephens | Georgia | 13257 | 4611 | 95 |
1712643 | 1712643 | 2021-09-12 | Teton | Wyoming | 56039 | 4611 | 11 |
1709396 | 1709396 | 2021-09-11 | Teton | Wyoming | 56039 | 4611 | 11 |
1706149 | 1706149 | 2021-09-10 | Teton | Wyoming | 56039 | 4611 | 11 |
1697035 | 1697035 | 2021-09-08 | Fulton | Illinois | 17057 | 4611 | 76 |
1696107 | 1696107 | 2021-09-07 | Charlottesville city | Virginia | 51540 | 4611 | 58 |
1690688 | 1690688 | 2021-09-06 | Steuben | Indiana | 18151 | 4611 | 66 |
1692968 | 1692968 | 2021-09-06 | York | Virginia | 51199 | 4611 | 60 |
1687438 | 1687438 | 2021-09-05 | Steuben | Indiana | 18151 | 4611 | 66 |
1684188 | 1684188 | 2021-09-04 | Steuben | Indiana | 18151 | 4611 | 66 |
1680937 | 1680937 | 2021-09-03 | Steuben | Indiana | 18151 | 4611 | 66 |
1579570 | 1579570 | 2021-08-03 | Baxter | Arkansas | 5005 | 4611 | 126 |
1576927 | 1576927 | 2021-08-02 | DeKalb | Indiana | 18033 | 4611 | 88 |
1550957 | 1550957 | 2021-07-25 | Gibson | Indiana | 18051 | 4611 | 99 |
1547710 | 1547710 | 2021-07-24 | Gibson | Indiana | 18051 | 4611 | 99 |
1544463 | 1544463 | 2021-07-23 | Gibson | Indiana | 18051 | 4611 | 99 |
1512721 | 1512721 | 2021-07-13 | Marshall | Mississippi | 28093 | 4611 | 106 |
1509474 | 1509474 | 2021-07-12 | Marshall | Mississippi | 28093 | 4611 | 105 |
1425033 | 1425033 | 2021-06-16 | Winona | Minnesota | 27169 | 4611 | 51 |
1421785 | 1421785 | 2021-06-15 | Winona | Minnesota | 27169 | 4611 | 51 |
1418540 | 1418540 | 2021-06-14 | Winona | Minnesota | 27169 | 4611 | 51 |
1413433 | 1413433 | 2021-06-12 | Nacogdoches | Texas | 48347 | 4611 | 172 |
1359265 | 1359265 | 2021-05-27 | Maui | Hawaii | 15009 | 4611 | 54 |
1291995 | 1291995 | 2021-05-06 | Oktibbeha | Mississippi | 28105 | 4611 | 98 |
1285959 | 1285959 | 2021-05-04 | Chatham | North Carolina | 37037 | 4611 | 88 |
1285987 | 1285987 | 2021-05-04 | Hoke | North Carolina | 37093 | 4611 | 55 |
1282741 | 1282741 | 2021-05-03 | Hoke | North Carolina | 37093 | 4611 | 55 |
1277200 | 1277200 | 2021-05-01 | Wasatch | Utah | 49051 | 4611 | 21 |
1250175 | 1250175 | 2021-04-23 | Clinton | New York | 36019 | 4611 | 33 |
1250455 | 1250455 | 2021-04-23 | Shelby | Ohio | 39149 | 4611 | 93 |
1245729 | 1245729 | 2021-04-22 | Macoupin | Illinois | 17117 | 4611 | 110 |
1247810 | 1247810 | 2021-04-22 | Howard | Texas | 48227 | 4611 | 101 |
1174048 | 1174048 | 2021-03-31 | Colquitt | Georgia | 13071 | 4611 | 113 |
1174819 | 1174819 | 2021-03-31 | Penobscot | Maine | 23019 | 4611 | 88 |
1076863 | 1076863 | 2021-03-01 | Jackson | Illinois | 17077 | 4611 | 71 |
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);