ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where cases = 8002 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Virginia 7
- Kentucky 6
- Pennsylvania 5
- Alaska 4
- Michigan 4
- Tennessee 4
- Ohio 3
- Wisconsin 3
- Arkansas 2
- Indiana 2
- Massachusetts 2
- Texas 2
- Vermont 2
- Wyoming 2
- Alabama 1
- Louisiana 1
- Missouri 1
- Nebraska 1
- New Jersey 1
- New Mexico 1
- North Carolina 1
- Oklahoma 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401506 | 2401506 | 2022-04-12 | Wood | Texas | 48499 | 8002 | 288 |
2378168 | 2378168 | 2022-04-05 | Tioga | Pennsylvania | 42117 | 8002 | 192 |
2360850 | 2360850 | 2022-03-31 | Huron | Michigan | 26063 | 8002 | 145 |
2357596 | 2357596 | 2022-03-30 | Huron | Michigan | 26063 | 8002 | 145 |
2336970 | 2336970 | 2022-03-24 | Poinsett | Arkansas | 5111 | 8002 | 126 |
2259788 | 2259788 | 2022-02-28 | Grayson | Kentucky | 21085 | 8002 | 121 |
2182995 | 2182995 | 2022-02-04 | Greene | Pennsylvania | 42059 | 8002 | 92 |
2175921 | 2175921 | 2022-02-02 | Lincoln | Nebraska | 31111 | 8002 | 102 |
2170603 | 2170603 | 2022-01-31 | Bennington | Vermont | 50003 | 8002 | 56 |
2124267 | 2124267 | 2022-01-17 | Preble | Ohio | 39135 | 8002 | 160 |
2105377 | 2105377 | 2022-01-11 | Jim Wells | Texas | 48249 | 8002 | 184 |
2074425 | 2074425 | 2022-01-02 | Knox | Kentucky | 21121 | 8002 | 107 |
2071174 | 2071174 | 2022-01-01 | Knox | Kentucky | 21121 | 8002 | 107 |
2067923 | 2067923 | 2021-12-31 | Knox | Kentucky | 21121 | 8002 | 107 |
2064672 | 2064672 | 2021-12-30 | Knox | Kentucky | 21121 | 8002 | 107 |
2061422 | 2061422 | 2021-12-29 | Knox | Kentucky | 21121 | 8002 | 107 |
2044032 | 2044032 | 2021-12-23 | Douglas | Wisconsin | 55031 | 8002 | 71 |
2021078 | 2021078 | 2021-12-16 | Fauquier | Virginia | 51061 | 8002 | 92 |
1990400 | 1990400 | 2021-12-07 | Johnson | Missouri | 29101 | 8002 | 109 |
1899655 | 1899655 | 2021-11-09 | Salem | New Jersey | 34033 | 8002 | 213 |
1853110 | 1853110 | 2021-10-26 | Marshall | Indiana | 18099 | 8002 | 140 |
1828584 | 1828584 | 2021-10-18 | Unknown | Oklahoma | 8002 | 0 | |
1810077 | 1810077 | 2021-10-12 | Sauk | Wisconsin | 55111 | 8002 | 64 |
1670369 | 1670369 | 2021-08-30 | Portage | Wisconsin | 55097 | 8002 | 81 |
1611000 | 1611000 | 2021-08-12 | Lawrence | Pennsylvania | 42073 | 8002 | 223 |
1601865 | 1601865 | 2021-08-09 | Chittenden | Vermont | 50007 | 8002 | 108 |
1539226 | 1539226 | 2021-07-21 | Stanly | North Carolina | 37167 | 8002 | 138 |
1472378 | 1472378 | 2021-07-01 | Fairbanks North Star Borough | Alaska | 2090 | 8002 | 44 |
1469133 | 1469133 | 2021-06-30 | Fairbanks North Star Borough | Alaska | 2090 | 8002 | 44 |
1465888 | 1465888 | 2021-06-29 | Fairbanks North Star Borough | Alaska | 2090 | 8002 | 44 |
1462643 | 1462643 | 2021-06-28 | Fairbanks North Star Borough | Alaska | 2090 | 8002 | 44 |
1455876 | 1455876 | 2021-06-25 | Suffolk city | Virginia | 51800 | 8002 | 191 |
1442895 | 1442895 | 2021-06-21 | Suffolk city | Virginia | 51800 | 8002 | 191 |
1429910 | 1429910 | 2021-06-17 | Suffolk city | Virginia | 51800 | 8002 | 191 |
1426665 | 1426665 | 2021-06-16 | Suffolk city | Virginia | 51800 | 8002 | 191 |
1419684 | 1419684 | 2021-06-14 | Greene | Tennessee | 47059 | 8002 | 159 |
1416439 | 1416439 | 2021-06-13 | Greene | Tennessee | 47059 | 8002 | 159 |
1413193 | 1413193 | 2021-06-12 | Greene | Tennessee | 47059 | 8002 | 159 |
1409948 | 1409948 | 2021-06-11 | Greene | Tennessee | 47059 | 8002 | 159 |
1380501 | 1380501 | 2021-06-02 | Somerset | Pennsylvania | 42111 | 8002 | 213 |
1344558 | 1344558 | 2021-05-22 | Erie | Ohio | 39043 | 8002 | 158 |
1265261 | 1265261 | 2021-04-28 | Bartholomew | Indiana | 18005 | 8002 | 160 |
1231869 | 1231869 | 2021-04-17 | Roanoke | Virginia | 51161 | 8002 | 132 |
1139138 | 1139138 | 2021-03-20 | Hampshire | Massachusetts | 25015 | 8002 | 277 |
1124691 | 1124691 | 2021-03-15 | Portsmouth city | Virginia | 51740 | 8002 | 159 |
1110829 | 1110829 | 2021-03-11 | Wayne | Ohio | 39169 | 8002 | 199 |
991825 | 991825 | 2021-02-02 | Laramie | Wyoming | 56021 | 8002 | 93 |
988579 | 988579 | 2021-02-01 | Laramie | Wyoming | 56021 | 8002 | 87 |
962763 | 962763 | 2021-01-25 | Garland | Arkansas | 5051 | 8002 | 196 |
964453 | 964453 | 2021-01-25 | Lea | New Mexico | 35025 | 8002 | 114 |
936705 | 936705 | 2021-01-17 | Limestone | Alabama | 1083 | 8002 | 74 |
892551 | 892551 | 2021-01-03 | Unknown | Michigan | 8002 | 39 | |
889305 | 889305 | 2021-01-02 | Unknown | Michigan | 8002 | 39 | |
857831 | 857831 | 2020-12-23 | Lebanon | Pennsylvania | 42075 | 8002 | 144 |
825510 | 825510 | 2020-12-13 | Florence | South Carolina | 45041 | 8002 | 224 |
713913 | 713913 | 2020-11-09 | St. Tammany | Louisiana | 22103 | 8002 | 277 |
253780 | 253780 | 2020-06-19 | Bristol | Massachusetts | 25005 | 8002 | 537 |
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);