ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
118 rows where cases = 3578 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 11
- Iowa 9
- Virginia 8
- Rhode Island 7
- Texas 7
- New York 6
- Alabama 5
- Utah 5
- Georgia 4
- Nebraska 4
- North Carolina 4
- Ohio 4
- West Virginia 4
- Arkansas 3
- Illinois 3
- Mississippi 3
- Puerto Rico 3
- Wisconsin 3
- Florida 2
- Indiana 2
- Kansas 2
- Kentucky 2
- Minnesota 2
- New Mexico 2
- Tennessee 2
- Wyoming 2
- Arizona 1
- Colorado 1
- Maine 1
- Michigan 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2420561 | 2420561 | 2022-04-18 | Salinas | Puerto Rico | 72123 | 3578 | |
2335255 | 2335255 | 2022-03-23 | Gage | Nebraska | 31067 | 3578 | 40 |
2332001 | 2332001 | 2022-03-22 | Gage | Nebraska | 31067 | 3578 | 40 |
2325496 | 2325496 | 2022-03-20 | Gage | Nebraska | 31067 | 3578 | 40 |
2326814 | 2326814 | 2022-03-20 | Patrick | Virginia | 51141 | 3578 | 91 |
2322242 | 2322242 | 2022-03-19 | Gage | Nebraska | 31067 | 3578 | 40 |
2323561 | 2323561 | 2022-03-19 | Patrick | Virginia | 51141 | 3578 | 91 |
2320307 | 2320307 | 2022-03-18 | Patrick | Virginia | 51141 | 3578 | 91 |
2261979 | 2261979 | 2022-02-28 | Goshen | Wyoming | 56015 | 3578 | 54 |
2244748 | 2244748 | 2022-02-23 | Tillamook | Oregon | 41057 | 3578 | 57 |
2240134 | 2240134 | 2022-02-22 | Wright | Iowa | 19197 | 3578 | 60 |
2236883 | 2236883 | 2022-02-21 | Wright | Iowa | 19197 | 3578 | 60 |
2233632 | 2233632 | 2022-02-20 | Wright | Iowa | 19197 | 3578 | 60 |
2234777 | 2234777 | 2022-02-20 | Ramsey | North Dakota | 38071 | 3578 | 54 |
2230381 | 2230381 | 2022-02-19 | Wright | Iowa | 19197 | 3578 | 60 |
2227130 | 2227130 | 2022-02-18 | Wright | Iowa | 19197 | 3578 | 60 |
2223879 | 2223879 | 2022-02-17 | Wright | Iowa | 19197 | 3578 | 60 |
2220628 | 2220628 | 2022-02-16 | Wright | Iowa | 19197 | 3578 | 60 |
2172446 | 2172446 | 2022-02-01 | Bates | Missouri | 29013 | 3578 | 73 |
2167456 | 2167456 | 2022-01-30 | Nottoway | Virginia | 51135 | 3578 | 74 |
2164201 | 2164201 | 2022-01-29 | Nottoway | Virginia | 51135 | 3578 | 74 |
2160946 | 2160946 | 2022-01-28 | Nottoway | Virginia | 51135 | 3578 | 74 |
2157866 | 2157866 | 2022-01-27 | Marquette | Wisconsin | 55077 | 3578 | 46 |
2137485 | 2137485 | 2022-01-21 | Aguas Buenas | Puerto Rico | 72007 | 3578 | |
2103355 | 2103355 | 2022-01-11 | Franklin | Indiana | 18047 | 3578 | 55 |
2078221 | 2078221 | 2022-01-03 | Texas | Missouri | 29215 | 3578 | 73 |
2061882 | 2061882 | 2021-12-29 | Clinton | Missouri | 29049 | 3578 | 100 |
2042053 | 2042053 | 2021-12-23 | Franklin | Maine | 23007 | 3578 | 41 |
2004689 | 2004689 | 2021-12-11 | Scurry | Texas | 48415 | 3578 | 85 |
1989862 | 1989862 | 2021-12-07 | Bourbon | Kentucky | 21017 | 3578 | 40 |
1929804 | 1929804 | 2021-11-18 | Gillespie | Texas | 48171 | 3578 | 80 |
1926554 | 1926554 | 2021-11-17 | Gillespie | Texas | 48171 | 3578 | 80 |
1849108 | 1849108 | 2021-10-25 | Barbour | Alabama | 1005 | 3578 | 76 |
1845858 | 1845858 | 2021-10-24 | Barbour | Alabama | 1005 | 3578 | 76 |
1839232 | 1839232 | 2021-10-21 | Mason | West Virginia | 54053 | 3578 | 53 |
1827859 | 1827859 | 2021-10-18 | Adair | Missouri | 29001 | 3578 | 34 |
1827948 | 1827948 | 2021-10-18 | Randolph | Missouri | 29175 | 3578 | 36 |
1828457 | 1828457 | 2021-10-18 | Henry | Ohio | 39069 | 3578 | 71 |
1829260 | 1829260 | 2021-10-18 | Sevier | Utah | 49041 | 3578 | 16 |
1824610 | 1824610 | 2021-10-17 | Adair | Missouri | 29001 | 3578 | 34 |
1825075 | 1825075 | 2021-10-17 | Martin | North Carolina | 37117 | 3578 | 67 |
1826011 | 1826011 | 2021-10-17 | Sevier | Utah | 49041 | 3578 | 16 |
1821361 | 1821361 | 2021-10-16 | Adair | Missouri | 29001 | 3578 | 34 |
1821826 | 1821826 | 2021-10-16 | Martin | North Carolina | 37117 | 3578 | 67 |
1822762 | 1822762 | 2021-10-16 | Sevier | Utah | 49041 | 3578 | 16 |
1818112 | 1818112 | 2021-10-15 | Adair | Missouri | 29001 | 3578 | 34 |
1818577 | 1818577 | 2021-10-15 | Martin | North Carolina | 37117 | 3578 | 67 |
1819513 | 1819513 | 2021-10-15 | Sevier | Utah | 49041 | 3578 | 16 |
1813793 | 1813793 | 2021-10-14 | Cook | Georgia | 13075 | 3578 | 58 |
1811598 | 1811598 | 2021-10-13 | Stone | Mississippi | 28131 | 3578 | 64 |
1813112 | 1813112 | 2021-10-13 | Lee | Virginia | 51105 | 3578 | 57 |
1784121 | 1784121 | 2021-10-04 | Uinta | Wyoming | 56041 | 3578 | 25 |
1768944 | 1768944 | 2021-09-30 | Letcher | Kentucky | 21133 | 3578 | 58 |
1760217 | 1760217 | 2021-09-27 | Gallia | Ohio | 39053 | 3578 | 58 |
1760608 | 1760608 | 2021-09-27 | Davison | South Dakota | 46035 | 3578 | 69 |
1707761 | 1707761 | 2021-09-11 | Washington | Missouri | 29221 | 3578 | 57 |
1695714 | 1695714 | 2021-09-07 | Grainger | Tennessee | 47057 | 3578 | 52 |
1606947 | 1606947 | 2021-08-11 | Yazoo | Mississippi | 28163 | 3578 | 78 |
1584562 | 1584562 | 2021-08-04 | Chenango | New York | 36017 | 3578 | 77 |
1575367 | 1575367 | 2021-08-01 | Vega Baja | Puerto Rico | 72145 | 3578 | |
1565065 | 1565065 | 2021-07-29 | Allegany | New York | 36003 | 3578 | 87 |
1565971 | 1565971 | 2021-07-29 | Kendall | Texas | 48259 | 3578 | 73 |
1537099 | 1537099 | 2021-07-20 | Fayette | West Virginia | 54019 | 3578 | 80 |
1527103 | 1527103 | 2021-07-17 | Upshur | Texas | 48459 | 3578 | 77 |
1520203 | 1520203 | 2021-07-15 | Marion | South Carolina | 45067 | 3578 | 108 |
1431653 | 1431653 | 2021-06-18 | Howell | Missouri | 29091 | 3578 | 45 |
1406049 | 1406049 | 2021-06-10 | Wyoming | New York | 36121 | 3578 | 53 |
1402803 | 1402803 | 2021-06-09 | Wyoming | New York | 36121 | 3578 | 52 |
1381788 | 1381788 | 2021-06-03 | Levy | Florida | 12075 | 3578 | 56 |
1367296 | 1367296 | 2021-05-29 | Highland | Ohio | 39071 | 3578 | 63 |
1319356 | 1319356 | 2021-05-14 | Uvalde | Texas | 48463 | 3578 | 72 |
1313263 | 1313263 | 2021-05-13 | Chambers | Alabama | 1017 | 3578 | 123 |
1306077 | 1306077 | 2021-05-10 | Hardin | Tennessee | 47071 | 3578 | 68 |
1291896 | 1291896 | 2021-05-06 | Lyon | Minnesota | 27083 | 3578 | 50 |
1274838 | 1274838 | 2021-05-01 | Wayne | Georgia | 13305 | 3578 | 88 |
1276192 | 1276192 | 2021-05-01 | Tioga | New York | 36107 | 3578 | 61 |
1271227 | 1271227 | 2021-04-30 | St. Francis | Arkansas | 5123 | 3578 | 42 |
1268413 | 1268413 | 2021-04-29 | Christian | Illinois | 17021 | 3578 | 90 |
1269637 | 1269637 | 2021-04-29 | Rio Arriba | New Mexico | 35039 | 3578 | 75 |
1258667 | 1258667 | 2021-04-26 | Bureau | Illinois | 17011 | 3578 | 95 |
1254742 | 1254742 | 2021-04-24 | Green | Wisconsin | 55045 | 3578 | 23 |
1186997 | 1186997 | 2021-04-04 | Unknown | Florida | 3578 | 0 | |
1148295 | 1148295 | 2021-03-23 | Lee | Illinois | 17103 | 3578 | 84 |
1133273 | 1133273 | 2021-03-18 | Fulton | New York | 36035 | 3578 | 85 |
1111580 | 1111580 | 2021-03-11 | Sanpete | Utah | 49039 | 3578 | 19 |
1073733 | 1073733 | 2021-02-28 | Miami | Indiana | 18103 | 3578 | 64 |
1050143 | 1050143 | 2021-02-20 | Ohio | West Virginia | 54069 | 3578 | 67 |
1037686 | 1037686 | 2021-02-17 | Camden | Georgia | 13039 | 3578 | 29 |
1018724 | 1018724 | 2021-02-11 | Ellis | Kansas | 20051 | 3578 | 61 |
1020625 | 1020625 | 2021-02-11 | Rusk | Texas | 48401 | 3578 | 86 |
1015479 | 1015479 | 2021-02-10 | Ellis | Kansas | 20051 | 3578 | 61 |
1013260 | 1013260 | 2021-02-09 | Haywood | North Carolina | 37087 | 3578 | 81 |
987501 | 987501 | 2021-02-01 | Caddo | Oklahoma | 40015 | 3578 | 48 |
970585 | 970585 | 2021-01-27 | Pearl River | Mississippi | 28109 | 3578 | 107 |
968854 | 968854 | 2021-01-26 | Henry | Virginia | 51089 | 3578 | 68 |
951193 | 951193 | 2021-01-21 | Johnson | Missouri | 29101 | 3578 | 34 |
949536 | 949536 | 2021-01-20 | Putnam | West Virginia | 54079 | 3578 | 67 |
945565 | 945565 | 2021-01-19 | Newport | Rhode Island | 44005 | 3578 | 11 |
942318 | 942318 | 2021-01-18 | Newport | Rhode Island | 44005 | 3578 | 11 |
939073 | 939073 | 2021-01-17 | Newport | Rhode Island | 44005 | 3578 | 11 |
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);