ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where cases = 5656 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Michigan 16
- Iowa 14
- Alabama 9
- Georgia 8
- North Carolina 6
- Tennessee 6
- Ohio 5
- Pennsylvania 5
- West Virginia 5
- Wisconsin 5
- Texas 4
- Indiana 3
- Puerto Rico 3
- Virginia 3
- Minnesota 2
- Mississippi 2
- California 1
- Delaware 1
- Illinois 1
- Massachusetts 1
- Missouri 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491101 | 2491101 | 2022-05-10 | Menominee | Michigan | 26109 | 5656 | 70 |
2487844 | 2487844 | 2022-05-09 | Menominee | Michigan | 26109 | 5656 | 70 |
2484586 | 2484586 | 2022-05-08 | Menominee | Michigan | 26109 | 5656 | 70 |
2481328 | 2481328 | 2022-05-07 | Menominee | Michigan | 26109 | 5656 | 70 |
2478070 | 2478070 | 2022-05-06 | Menominee | Michigan | 26109 | 5656 | 70 |
2474812 | 2474812 | 2022-05-05 | Menominee | Michigan | 26109 | 5656 | 70 |
2471555 | 2471555 | 2022-05-04 | Menominee | Michigan | 26109 | 5656 | 70 |
2445522 | 2445522 | 2022-04-26 | Otsego | Michigan | 26137 | 5656 | 100 |
2442266 | 2442266 | 2022-04-25 | Otsego | Michigan | 26137 | 5656 | 100 |
2439010 | 2439010 | 2022-04-24 | Otsego | Michigan | 26137 | 5656 | 100 |
2435754 | 2435754 | 2022-04-23 | Otsego | Michigan | 26137 | 5656 | 100 |
2432498 | 2432498 | 2022-04-22 | Otsego | Michigan | 26137 | 5656 | 100 |
2429242 | 2429242 | 2022-04-21 | Otsego | Michigan | 26137 | 5656 | 100 |
2405067 | 2405067 | 2022-04-13 | Jackson | Wisconsin | 55053 | 5656 | 43 |
2375842 | 2375842 | 2022-04-05 | Barbour | Alabama | 1005 | 5656 | 97 |
2372590 | 2372590 | 2022-04-04 | Barbour | Alabama | 1005 | 5656 | 97 |
2369337 | 2369337 | 2022-04-03 | Barbour | Alabama | 1005 | 5656 | 97 |
2366084 | 2366084 | 2022-04-02 | Barbour | Alabama | 1005 | 5656 | 97 |
2362831 | 2362831 | 2022-04-01 | Barbour | Alabama | 1005 | 5656 | 97 |
2359577 | 2359577 | 2022-03-31 | Barbour | Alabama | 1005 | 5656 | 97 |
2356323 | 2356323 | 2022-03-30 | Barbour | Alabama | 1005 | 5656 | 97 |
2357668 | 2357668 | 2022-03-30 | Dodge | Minnesota | 27039 | 5656 | 21 |
2353070 | 2353070 | 2022-03-29 | Barbour | Alabama | 1005 | 5656 | 97 |
2354415 | 2354415 | 2022-03-29 | Dodge | Minnesota | 27039 | 5656 | 21 |
2306624 | 2306624 | 2022-03-14 | Cayey | Puerto Rico | 72035 | 5656 | |
2197729 | 2197729 | 2022-02-09 | Owen | Indiana | 18119 | 5656 | 109 |
2194475 | 2194475 | 2022-02-08 | Owen | Indiana | 18119 | 5656 | 109 |
2169144 | 2169144 | 2022-01-31 | Leake | Mississippi | 28079 | 5656 | 96 |
2160673 | 2160673 | 2022-01-28 | Jasper | Texas | 48241 | 5656 | 169 |
2144016 | 2144016 | 2022-01-23 | Corozal | Puerto Rico | 72047 | 5656 | |
2119335 | 2119335 | 2022-01-16 | Gilmer | Georgia | 13123 | 5656 | 148 |
2116083 | 2116083 | 2022-01-15 | Gilmer | Georgia | 13123 | 5656 | 148 |
2112832 | 2112832 | 2022-01-14 | Gilmer | Georgia | 13123 | 5656 | 148 |
2098086 | 2098086 | 2022-01-09 | Macon | North Carolina | 37113 | 5656 | 87 |
2094834 | 2094834 | 2022-01-08 | Macon | North Carolina | 37113 | 5656 | 87 |
2091582 | 2091582 | 2022-01-07 | Macon | North Carolina | 37113 | 5656 | 87 |
2091716 | 2091716 | 2022-01-07 | Hardin | Ohio | 39065 | 5656 | 124 |
2083171 | 2083171 | 2022-01-05 | Pike | Alabama | 1109 | 5656 | 112 |
2013584 | 2013584 | 2021-12-14 | Pasquotank | North Carolina | 37139 | 5656 | 110 |
1965147 | 1965147 | 2021-11-29 | Greene | Pennsylvania | 42059 | 5656 | 65 |
1962723 | 1962723 | 2021-11-28 | Logan | West Virginia | 54045 | 5656 | 144 |
1959472 | 1959472 | 2021-11-27 | Logan | West Virginia | 54045 | 5656 | 144 |
1956221 | 1956221 | 2021-11-26 | Logan | West Virginia | 54045 | 5656 | 144 |
1952970 | 1952970 | 2021-11-25 | Logan | West Virginia | 54045 | 5656 | 144 |
1949719 | 1949719 | 2021-11-24 | Logan | West Virginia | 54045 | 5656 | 144 |
1877488 | 1877488 | 2021-11-02 | Ponce | Puerto Rico | 72113 | 5656 | |
1853208 | 1853208 | 2021-10-26 | Lee | Iowa | 19111 | 5656 | 89 |
1853236 | 1853236 | 2021-10-26 | Sioux | Iowa | 19167 | 5656 | 76 |
1854684 | 1854684 | 2021-10-26 | Wayne | Pennsylvania | 42127 | 5656 | 107 |
1849959 | 1849959 | 2021-10-25 | Lee | Iowa | 19111 | 5656 | 89 |
1849987 | 1849987 | 2021-10-25 | Sioux | Iowa | 19167 | 5656 | 76 |
1846709 | 1846709 | 2021-10-24 | Lee | Iowa | 19111 | 5656 | 89 |
1846737 | 1846737 | 2021-10-24 | Sioux | Iowa | 19167 | 5656 | 76 |
1843459 | 1843459 | 2021-10-23 | Lee | Iowa | 19111 | 5656 | 89 |
1843487 | 1843487 | 2021-10-23 | Sioux | Iowa | 19167 | 5656 | 76 |
1840209 | 1840209 | 2021-10-22 | Lee | Iowa | 19111 | 5656 | 89 |
1840237 | 1840237 | 2021-10-22 | Sioux | Iowa | 19167 | 5656 | 76 |
1836960 | 1836960 | 2021-10-21 | Lee | Iowa | 19111 | 5656 | 89 |
1836988 | 1836988 | 2021-10-21 | Sioux | Iowa | 19167 | 5656 | 76 |
1833711 | 1833711 | 2021-10-20 | Lee | Iowa | 19111 | 5656 | 89 |
1833739 | 1833739 | 2021-10-20 | Sioux | Iowa | 19167 | 5656 | 76 |
1815932 | 1815932 | 2021-10-14 | Henderson | Tennessee | 47077 | 5656 | 99 |
1796195 | 1796195 | 2021-10-08 | Venango | Pennsylvania | 42121 | 5656 | 118 |
1748337 | 1748337 | 2021-09-23 | Pierce | Wisconsin | 55093 | 5656 | 44 |
1625465 | 1625465 | 2021-08-17 | Thomas | Georgia | 13275 | 5656 | 130 |
1614599 | 1614599 | 2021-08-13 | Burnet | Texas | 48053 | 5656 | 76 |
1575512 | 1575512 | 2021-08-01 | Dyer | Tennessee | 47045 | 5656 | 108 |
1572264 | 1572264 | 2021-07-31 | Dyer | Tennessee | 47045 | 5656 | 108 |
1569016 | 1569016 | 2021-07-30 | Dyer | Tennessee | 47045 | 5656 | 108 |
1396511 | 1396511 | 2021-06-07 | Jefferson | Ohio | 39081 | 5656 | 156 |
1393264 | 1393264 | 2021-06-06 | Jefferson | Ohio | 39081 | 5656 | 156 |
1388397 | 1388397 | 2021-06-05 | Laurens | Georgia | 13175 | 5656 | 170 |
1385152 | 1385152 | 2021-06-04 | Laurens | Georgia | 13175 | 5656 | 170 |
1383374 | 1383374 | 2021-06-03 | Halifax | North Carolina | 37083 | 5656 | 112 |
1379504 | 1379504 | 2021-06-02 | Tuscola | Michigan | 26157 | 5656 | 175 |
1376874 | 1376874 | 2021-06-01 | Edgecombe | North Carolina | 37065 | 5656 | 113 |
1274801 | 1274801 | 2021-05-01 | Polk | Georgia | 13233 | 5656 | 94 |
1276567 | 1276567 | 2021-05-01 | Bradford | Pennsylvania | 42015 | 5656 | 88 |
1271785 | 1271785 | 2021-04-30 | Henry | Indiana | 18065 | 5656 | 103 |
1274223 | 1274223 | 2021-04-30 | Grant | Wisconsin | 55043 | 5656 | 90 |
1246628 | 1246628 | 2021-04-22 | Lincoln | Missouri | 29113 | 5656 | 40 |
1244760 | 1244760 | 2021-04-21 | Augusta | Virginia | 51015 | 5656 | 69 |
1222257 | 1222257 | 2021-04-14 | Columbia | Wisconsin | 55021 | 5656 | 69 |
1215187 | 1215187 | 2021-04-12 | Monroe | Tennessee | 47123 | 5656 | 95 |
1190062 | 1190062 | 2021-04-05 | Lassen | California | 6035 | 5656 | 24 |
1074249 | 1074249 | 2021-02-28 | Gratiot | Michigan | 26057 | 5656 | 107 |
1071003 | 1071003 | 2021-02-27 | Gratiot | Michigan | 26057 | 5656 | 107 |
1069706 | 1069706 | 2021-02-26 | Waupaca | Wisconsin | 55135 | 5656 | 157 |
1040210 | 1040210 | 2021-02-17 | Bedford | Virginia | 51019 | 5656 | 45 |
1010155 | 1010155 | 2021-02-08 | Geauga | Ohio | 39055 | 5656 | 56 |
972767 | 972767 | 2021-01-28 | Bulloch | Georgia | 13031 | 5656 | 76 |
959986 | 959986 | 2021-01-24 | Boone | Illinois | 17007 | 5656 | 79 |
945707 | 945707 | 2021-01-19 | Gibson | Tennessee | 47053 | 5656 | 111 |
919509 | 919509 | 2021-01-11 | Somerset | Pennsylvania | 42111 | 5656 | 111 |
910259 | 910259 | 2021-01-08 | Orange | Texas | 48361 | 5656 | 77 |
851180 | 851180 | 2020-12-21 | Tuscarawas | Ohio | 39157 | 5656 | 111 |
810083 | 810083 | 2020-12-08 | Natrona | Wyoming | 56025 | 5656 | 57 |
723712 | 723712 | 2020-11-12 | Unknown | Massachusetts | 5656 | 6 | |
543834 | 543834 | 2020-09-17 | Chesterfield | Virginia | 51041 | 5656 | 91 |
533904 | 533904 | 2020-09-14 | Hays | Texas | 48209 | 5656 | 60 |
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);