ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where cases = 4711 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alabama 12
- Georgia 8
- Tennessee 8
- Wisconsin 7
- Indiana 6
- Ohio 6
- Texas 6
- Kansas 5
- Michigan 4
- Arkansas 3
- California 3
- Mississippi 3
- Pennsylvania 3
- Puerto Rico 3
- West Virginia 3
- Iowa 2
- Kentucky 2
- Maryland 2
- Minnesota 2
- Missouri 2
- Montana 2
- New Mexico 2
- New York 2
- South Dakota 2
- Utah 2
- Virginia 2
- Arizona 1
- Colorado 1
- Massachusetts 1
- Washington 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2392147 | 2392147 | 2022-04-10 | Hale | Alabama | 1065 | 4711 | 105 |
2388891 | 2388891 | 2022-04-09 | Hale | Alabama | 1065 | 4711 | 105 |
2385636 | 2385636 | 2022-04-08 | Hale | Alabama | 1065 | 4711 | 105 |
2382381 | 2382381 | 2022-04-07 | Hale | Alabama | 1065 | 4711 | 105 |
2379126 | 2379126 | 2022-04-06 | Hale | Alabama | 1065 | 4711 | 105 |
2375872 | 2375872 | 2022-04-05 | Hale | Alabama | 1065 | 4711 | 105 |
2335192 | 2335192 | 2022-03-23 | Lincoln | Montana | 30053 | 4711 | 86 |
2331938 | 2331938 | 2022-03-22 | Lincoln | Montana | 30053 | 4711 | 86 |
2310126 | 2310126 | 2022-03-15 | Polk | Tennessee | 47139 | 4711 | 65 |
2306873 | 2306873 | 2022-03-14 | Polk | Tennessee | 47139 | 4711 | 65 |
2303622 | 2303622 | 2022-03-13 | Polk | Tennessee | 47139 | 4711 | 65 |
2300370 | 2300370 | 2022-03-12 | Polk | Tennessee | 47139 | 4711 | 65 |
2297118 | 2297118 | 2022-03-11 | Polk | Tennessee | 47139 | 4711 | 65 |
2293866 | 2293866 | 2022-03-10 | Polk | Tennessee | 47139 | 4711 | 65 |
2290614 | 2290614 | 2022-03-09 | Polk | Tennessee | 47139 | 4711 | 65 |
2282289 | 2282289 | 2022-03-07 | Starke | Indiana | 18149 | 4711 | 94 |
2265095 | 2265095 | 2022-03-01 | Barbour | West Virginia | 54001 | 4711 | 74 |
2246131 | 2246131 | 2022-02-24 | Appling | Georgia | 13001 | 4711 | 117 |
2240178 | 2240178 | 2022-02-22 | Jefferson | Kansas | 20087 | 4711 | 58 |
2236151 | 2236151 | 2022-02-21 | Phillips | Arkansas | 5107 | 4711 | 89 |
2236927 | 2236927 | 2022-02-21 | Jefferson | Kansas | 20087 | 4711 | 58 |
2157976 | 2157976 | 2022-01-28 | Pickens | Alabama | 1107 | 4711 | 92 |
2158025 | 2158025 | 2022-01-28 | La Paz | Arizona | 4012 | 4711 | 116 |
2154723 | 2154723 | 2022-01-27 | Pickens | Alabama | 1107 | 4711 | 92 |
2157851 | 2157851 | 2022-01-27 | Green Lake | Wisconsin | 55047 | 4711 | 54 |
2151470 | 2151470 | 2022-01-26 | Pickens | Alabama | 1107 | 4711 | 92 |
2154190 | 2154190 | 2022-01-26 | Limestone | Texas | 48293 | 4711 | 116 |
2148218 | 2148218 | 2022-01-25 | Pickens | Alabama | 1107 | 4711 | 92 |
2144966 | 2144966 | 2022-01-24 | Pickens | Alabama | 1107 | 4711 | 92 |
2146135 | 2146135 | 2022-01-24 | Somerset | Maryland | 24039 | 4711 | 64 |
2101775 | 2101775 | 2022-01-10 | San Sebastian | Puerto Rico | 72131 | 4711 | |
2037643 | 2037643 | 2021-12-22 | Geneva | Alabama | 1061 | 4711 | 137 |
2030996 | 2030996 | 2021-12-19 | Nicholas | West Virginia | 54067 | 4711 | 71 |
1993635 | 1993635 | 2021-12-08 | Dunklin | Missouri | 29069 | 4711 | 93 |
1994443 | 1994443 | 2021-12-08 | Arecibo | Puerto Rico | 72013 | 4711 | |
1995218 | 1995218 | 2021-12-08 | Hancock | West Virginia | 54029 | 4711 | 121 |
1989945 | 1989945 | 2021-12-07 | Ohio | Kentucky | 21183 | 4711 | 89 |
1983084 | 1983084 | 2021-12-05 | Greene | Indiana | 18055 | 4711 | 106 |
1979834 | 1979834 | 2021-12-04 | Greene | Indiana | 18055 | 4711 | 106 |
1976584 | 1976584 | 2021-12-03 | Greene | Indiana | 18055 | 4711 | 106 |
1906854 | 1906854 | 2021-11-11 | Meade | South Dakota | 46093 | 4711 | 49 |
1902475 | 1902475 | 2021-11-10 | Nicollet | Minnesota | 27103 | 4711 | 57 |
1903605 | 1903605 | 2021-11-10 | Meade | South Dakota | 46093 | 4711 | 49 |
1882029 | 1882029 | 2021-11-04 | Dawson | Georgia | 13085 | 4711 | 72 |
1859572 | 1859572 | 2021-10-28 | Daviess | Indiana | 18027 | 4711 | 118 |
1861660 | 1861660 | 2021-10-28 | Palo Pinto | Texas | 48363 | 4711 | 117 |
1852834 | 1852834 | 2021-10-26 | Lee | Georgia | 13177 | 4711 | 79 |
1844887 | 1844887 | 2021-10-23 | Clarion | Pennsylvania | 42031 | 4711 | 121 |
1837035 | 1837035 | 2021-10-21 | Geary | Kansas | 20061 | 4711 | 54 |
1833786 | 1833786 | 2021-10-20 | Geary | Kansas | 20061 | 4711 | 54 |
1826665 | 1826665 | 2021-10-18 | Summit | Colorado | 8117 | 4711 | 11 |
1827838 | 1827838 | 2021-10-18 | Scott | Mississippi | 28123 | 4711 | 98 |
1778108 | 1778108 | 2021-10-03 | Lumpkin | Georgia | 13187 | 4711 | 91 |
1774858 | 1774858 | 2021-10-02 | Lumpkin | Georgia | 13187 | 4711 | 91 |
1771608 | 1771608 | 2021-10-01 | Lumpkin | Georgia | 13187 | 4711 | 91 |
1701238 | 1701238 | 2021-09-09 | Pulaski | Missouri | 29169 | 4711 | 67 |
1665192 | 1665192 | 2021-08-29 | Hillsdale | Michigan | 26059 | 4711 | 98 |
1660853 | 1660853 | 2021-08-28 | Unknown | Arkansas | 4711 | 0 | |
1661944 | 1661944 | 2021-08-28 | Hillsdale | Michigan | 26059 | 4711 | 98 |
1658696 | 1658696 | 2021-08-27 | Hillsdale | Michigan | 26059 | 4711 | 98 |
1627801 | 1627801 | 2021-08-17 | Washington | Texas | 48477 | 4711 | 100 |
1599671 | 1599671 | 2021-08-09 | DeKalb | Indiana | 18033 | 4711 | 89 |
1588061 | 1588061 | 2021-08-05 | Knox | Ohio | 39083 | 4711 | 112 |
1539777 | 1539777 | 2021-07-21 | Cheatham | Tennessee | 47021 | 4711 | 56 |
1540464 | 1540464 | 2021-07-21 | Albany | Wyoming | 56001 | 4711 | 18 |
1504966 | 1504966 | 2021-07-11 | Humboldt | California | 6023 | 4711 | 51 |
1501720 | 1501720 | 2021-07-10 | Humboldt | California | 6023 | 4711 | 51 |
1498474 | 1498474 | 2021-07-09 | Humboldt | California | 6023 | 4711 | 51 |
1501012 | 1501012 | 2021-07-09 | Howard | Texas | 48227 | 4711 | 102 |
1452542 | 1452542 | 2021-06-24 | Culpeper | Virginia | 51047 | 4711 | 67 |
1449244 | 1449244 | 2021-06-23 | Wasatch | Utah | 49051 | 4711 | 22 |
1439795 | 1439795 | 2021-06-20 | Marinette | Wisconsin | 55075 | 4711 | 73 |
1436548 | 1436548 | 2021-06-19 | Marinette | Wisconsin | 55075 | 4711 | 73 |
1433301 | 1433301 | 2021-06-18 | Marinette | Wisconsin | 55075 | 4711 | 73 |
1430055 | 1430055 | 2021-06-17 | Marinette | Wisconsin | 55075 | 4711 | 73 |
1358428 | 1358428 | 2021-05-26 | Fauquier | Virginia | 51061 | 4711 | 70 |
1281655 | 1281655 | 2021-05-03 | Muscatine | Iowa | 19139 | 4711 | 99 |
1227703 | 1227703 | 2021-04-16 | Mercer | Ohio | 39107 | 4711 | 84 |
1214664 | 1214664 | 2021-04-12 | Auglaize | Ohio | 39011 | 4711 | 84 |
1211713 | 1211713 | 2021-04-11 | Guaynabo | Puerto Rico | 72061 | 4711 | |
1199082 | 1199082 | 2021-04-07 | Harrison | Texas | 48203 | 4711 | 105 |
1168961 | 1168961 | 2021-03-29 | Otero | New Mexico | 35035 | 4711 | 71 |
1144935 | 1144935 | 2021-03-22 | Ware | Georgia | 13299 | 4711 | 157 |
1145255 | 1145255 | 2021-03-22 | Marshall | Iowa | 19127 | 4711 | 74 |
1146263 | 1146263 | 2021-03-22 | Herkimer | New York | 36043 | 4711 | 107 |
1141688 | 1141688 | 2021-03-21 | Ware | Georgia | 13299 | 4711 | 157 |
1132742 | 1132742 | 2021-03-18 | Benton | Minnesota | 27009 | 4711 | 95 |
1123734 | 1123734 | 2021-03-15 | Athens | Ohio | 39009 | 4711 | 50 |
1104473 | 1104473 | 2021-03-09 | Columbia | Pennsylvania | 42037 | 4711 | 125 |
1047151 | 1047151 | 2021-02-20 | Hot Spring | Arkansas | 5059 | 4711 | 68 |
1025522 | 1025522 | 2021-02-13 | Berkshire | Massachusetts | 25003 | 4711 | 240 |
999428 | 999428 | 2021-02-05 | Pike | Kentucky | 21195 | 4711 | 51 |
976816 | 976816 | 2021-01-29 | Cecil | Maryland | 24015 | 4711 | 111 |
928379 | 928379 | 2021-01-14 | Lamar | Mississippi | 28073 | 4711 | 62 |
907384 | 907384 | 2021-01-07 | Grant | Wisconsin | 55043 | 4711 | 82 |
907420 | 907420 | 2021-01-07 | Shawano | Wisconsin | 55115 | 4711 | 69 |
792448 | 792448 | 2020-12-03 | Lea | New Mexico | 35025 | 4711 | 51 |
769366 | 769366 | 2020-11-26 | Madison | Mississippi | 28089 | 4711 | 106 |
734310 | 734310 | 2020-11-15 | Lorain | Ohio | 39093 | 4711 | 94 |
723751 | 723751 | 2020-11-12 | Jackson | Michigan | 26075 | 4711 | 103 |
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);