ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where cases = 5248 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Tennessee 8
- Kentucky 6
- Michigan 6
- North Carolina 6
- Virginia 6
- Indiana 4
- New York 4
- Texas 4
- West Virginia 4
- Alabama 3
- Illinois 3
- Louisiana 3
- Maryland 3
- New Mexico 3
- Pennsylvania 3
- Washington 3
- Wisconsin 3
- Colorado 2
- Georgia 2
- Idaho 2
- Missouri 2
- Arkansas 1
- California 1
- Florida 1
- Minnesota 1
- Mississippi 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497094 | 2497094 | 2022-05-12 | Spencer | Indiana | 18147 | 5248 | 61 |
2493836 | 2493836 | 2022-05-11 | Spencer | Indiana | 18147 | 5248 | 61 |
2496245 | 2496245 | 2022-05-11 | Green Lake | Wisconsin | 55047 | 5248 | 64 |
2349869 | 2349869 | 2022-03-28 | Pickens | Alabama | 1107 | 5248 | 101 |
2267090 | 2267090 | 2022-03-02 | Taos | New Mexico | 35055 | 5248 | 89 |
2236036 | 2236036 | 2022-02-21 | Monroe | Alabama | 1099 | 5248 | 75 |
2178694 | 2178694 | 2022-02-03 | Alpena | Michigan | 26007 | 5248 | 123 |
2175442 | 2175442 | 2022-02-02 | Alpena | Michigan | 26007 | 5248 | 123 |
2165559 | 2165559 | 2022-01-30 | Assumption | Louisiana | 22007 | 5248 | 62 |
2162304 | 2162304 | 2022-01-29 | Assumption | Louisiana | 22007 | 5248 | 62 |
2159049 | 2159049 | 2022-01-28 | Assumption | Louisiana | 22007 | 5248 | 62 |
2148929 | 2148929 | 2022-01-25 | Owen | Indiana | 18119 | 5248 | 104 |
2028904 | 2028904 | 2021-12-19 | Grant | Kentucky | 21081 | 5248 | 46 |
2025653 | 2025653 | 2021-12-18 | Grant | Kentucky | 21081 | 5248 | 46 |
2022402 | 2022402 | 2021-12-17 | Grant | Kentucky | 21081 | 5248 | 46 |
2007781 | 2007781 | 2021-12-12 | Cooke | Texas | 48097 | 5248 | 105 |
1986679 | 1986679 | 2021-12-06 | Marshall | Kentucky | 21157 | 5248 | 83 |
1970581 | 1970581 | 2021-12-01 | Worcester | Maryland | 24047 | 5248 | 125 |
1972465 | 1972465 | 2021-12-01 | Greenbrier | West Virginia | 54025 | 5248 | 107 |
1944014 | 1944014 | 2021-11-23 | Montgomery | Illinois | 17135 | 5248 | 90 |
1943099 | 1943099 | 2021-11-22 | Manassas city | Virginia | 51683 | 5248 | 54 |
1939422 | 1939422 | 2021-11-21 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1936172 | 1936172 | 2021-11-20 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1932922 | 1932922 | 2021-11-19 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1929671 | 1929671 | 2021-11-18 | Lauderdale | Tennessee | 47097 | 5248 | 69 |
1930257 | 1930257 | 2021-11-18 | Clark | Wisconsin | 55019 | 5248 | 85 |
1922817 | 1922817 | 2021-11-16 | Unknown | Oklahoma | 5248 | 0 | |
1909875 | 1909875 | 2021-11-12 | Clarion | Pennsylvania | 42031 | 5248 | 130 |
1906202 | 1906202 | 2021-11-11 | Columbia | New York | 36021 | 5248 | 113 |
1880582 | 1880582 | 2021-11-03 | Coos | Oregon | 41011 | 5248 | 96 |
1868647 | 1868647 | 2021-10-31 | Marion | Alabama | 1093 | 5248 | 127 |
1861874 | 1861874 | 2021-10-28 | Petersburg city | Virginia | 51730 | 5248 | 108 |
1857502 | 1857502 | 2021-10-27 | Tioga | New York | 36107 | 5248 | 72 |
1826062 | 1826062 | 2021-10-17 | Charlottesville city | Virginia | 51540 | 5248 | 59 |
1822813 | 1822813 | 2021-10-16 | Charlottesville city | Virginia | 51540 | 5248 | 59 |
1819564 | 1819564 | 2021-10-15 | Charlottesville city | Virginia | 51540 | 5248 | 59 |
1811166 | 1811166 | 2021-10-13 | Harlan | Kentucky | 21095 | 5248 | 122 |
1786761 | 1786761 | 2021-10-05 | Bee | Texas | 48025 | 5248 | 118 |
1710703 | 1710703 | 2021-09-12 | Newaygo | Michigan | 26123 | 5248 | 72 |
1707456 | 1707456 | 2021-09-11 | Newaygo | Michigan | 26123 | 5248 | 72 |
1704209 | 1704209 | 2021-09-10 | Newaygo | Michigan | 26123 | 5248 | 72 |
1645073 | 1645073 | 2021-08-23 | Jefferson | Illinois | 17081 | 5248 | 127 |
1553353 | 1553353 | 2021-07-25 | Mercer | West Virginia | 54055 | 5248 | 129 |
1550106 | 1550106 | 2021-07-24 | Mercer | West Virginia | 54055 | 5248 | 129 |
1546531 | 1546531 | 2021-07-23 | Nacogdoches | Texas | 48347 | 5248 | 175 |
1546859 | 1546859 | 2021-07-23 | Mercer | West Virginia | 54055 | 5248 | 129 |
1507320 | 1507320 | 2021-07-11 | Franklin | Tennessee | 47051 | 5248 | 92 |
1504074 | 1504074 | 2021-07-10 | Franklin | Tennessee | 47051 | 5248 | 92 |
1500828 | 1500828 | 2021-07-09 | Franklin | Tennessee | 47051 | 5248 | 92 |
1451506 | 1451506 | 2021-06-24 | Carteret | North Carolina | 37031 | 5248 | 55 |
1439684 | 1439684 | 2021-06-20 | Lewis | Washington | 53041 | 5248 | 73 |
1436437 | 1436437 | 2021-06-19 | Lewis | Washington | 53041 | 5248 | 73 |
1423762 | 1423762 | 2021-06-16 | Hot Spring | Arkansas | 5059 | 5248 | 75 |
1378168 | 1378168 | 2021-06-01 | Fremont | Wyoming | 56013 | 5248 | 84 |
1354035 | 1354035 | 2021-05-25 | Curry | New Mexico | 35009 | 5248 | 83 |
1350789 | 1350789 | 2021-05-24 | Curry | New Mexico | 35009 | 5248 | 83 |
1347687 | 1347687 | 2021-05-23 | McDowell | North Carolina | 37111 | 5248 | 63 |
1344439 | 1344439 | 2021-05-22 | McDowell | North Carolina | 37111 | 5248 | 63 |
1341191 | 1341191 | 2021-05-21 | McDowell | North Carolina | 37111 | 5248 | 63 |
1285900 | 1285900 | 2021-05-04 | Genesee | New York | 36037 | 5248 | 121 |
1286170 | 1286170 | 2021-05-04 | Seneca | Ohio | 39147 | 5248 | 121 |
1269373 | 1269373 | 2021-04-29 | Newton | Missouri | 29145 | 5248 | 75 |
1222160 | 1222160 | 2021-04-14 | Cowlitz | Washington | 53015 | 5248 | 78 |
1203236 | 1203236 | 2021-04-09 | Suwannee | Florida | 12121 | 5248 | 136 |
1181457 | 1181457 | 2021-04-02 | Chisago | Minnesota | 27025 | 5248 | 48 |
1153910 | 1153910 | 2021-03-24 | Pittsylvania | Virginia | 51143 | 5248 | 75 |
1143444 | 1143444 | 2021-03-21 | Indiana | Pennsylvania | 42063 | 5248 | 160 |
1138574 | 1138574 | 2021-03-20 | Ogle | Illinois | 17141 | 5248 | 86 |
1129461 | 1129461 | 2021-03-17 | Midland | Michigan | 26111 | 5248 | 66 |
1125340 | 1125340 | 2021-03-16 | Coffee | Georgia | 13069 | 5248 | 159 |
1109906 | 1109906 | 2021-03-11 | St. Mary's | Maryland | 24037 | 5248 | 116 |
1095001 | 1095001 | 2021-03-06 | Dyer | Tennessee | 47045 | 5248 | 101 |
1018070 | 1018070 | 2021-02-11 | Fremont | Colorado | 8043 | 5248 | 41 |
972322 | 972322 | 2021-01-27 | Sauk | Wisconsin | 55111 | 5248 | 41 |
885326 | 885326 | 2021-01-01 | Madison | Idaho | 16065 | 5248 | 18 |
882081 | 882081 | 2020-12-31 | Madison | Idaho | 16065 | 5248 | 18 |
867154 | 867154 | 2020-12-26 | Schenectady | New York | 36093 | 5248 | 76 |
863225 | 863225 | 2020-12-25 | Allegany | Maryland | 24001 | 5248 | 151 |
830615 | 830615 | 2020-12-15 | Hardin | Kentucky | 21093 | 5248 | 38 |
792220 | 792220 | 2020-12-03 | St. Francois | Missouri | 29187 | 5248 | 47 |
768619 | 768619 | 2020-11-26 | Clark | Indiana | 18019 | 5248 | 84 |
769859 | 769859 | 2020-11-26 | Iredell | North Carolina | 37097 | 5248 | 47 |
766613 | 766613 | 2020-11-25 | Iredell | North Carolina | 37097 | 5248 | 47 |
704454 | 704454 | 2020-11-06 | Jackson | Mississippi | 28059 | 5248 | 101 |
580232 | 580232 | 2020-09-29 | Henry | Georgia | 13151 | 5248 | 102 |
430549 | 430549 | 2020-08-13 | McLennan | Texas | 48309 | 5248 | 70 |
401047 | 401047 | 2020-08-04 | Berks | Pennsylvania | 42011 | 5248 | 367 |
357276 | 357276 | 2020-07-22 | Adams | Colorado | 8001 | 5248 | 164 |
136424 | 136424 | 2020-05-12 | Riverside | California | 6065 | 5248 | 228 |
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);