ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 8050 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Tennessee 7
- Virginia 5
- Pennsylvania 4
- South Dakota 4
- California 3
- New York 3
- South Carolina 3
- West Virginia 3
- Wyoming 3
- Georgia 2
- Indiana 2
- Ohio 2
- Texas 2
- Arkansas 1
- Florida 1
- Iowa 1
- Kansas 1
- Louisiana 1
- Michigan 1
- Mississippi 1
- Missouri 1
- Puerto Rico 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489967 | 2489967 | 2022-05-10 | Poinsett | Arkansas | 5111 | 8050 | 127 |
2466652 | 2466652 | 2022-05-02 | Uintah | Utah | 49047 | 8050 | 71 |
2362822 | 2362822 | 2022-03-31 | Sheridan | Wyoming | 56033 | 8050 | 78 |
2359568 | 2359568 | 2022-03-30 | Sheridan | Wyoming | 56033 | 8050 | 78 |
2356314 | 2356314 | 2022-03-29 | Sheridan | Wyoming | 56033 | 8050 | 78 |
2264564 | 2264564 | 2022-03-01 | Henry | Tennessee | 47079 | 8050 | 140 |
2261314 | 2261314 | 2022-02-28 | Henry | Tennessee | 47079 | 8050 | 140 |
2258063 | 2258063 | 2022-02-27 | Henry | Tennessee | 47079 | 8050 | 140 |
2258521 | 2258521 | 2022-02-27 | Prince George | Virginia | 51149 | 8050 | 62 |
2254812 | 2254812 | 2022-02-26 | Henry | Tennessee | 47079 | 8050 | 140 |
2255270 | 2255270 | 2022-02-26 | Prince George | Virginia | 51149 | 8050 | 62 |
2251561 | 2251561 | 2022-02-25 | Henry | Tennessee | 47079 | 8050 | 140 |
2252019 | 2252019 | 2022-02-25 | Prince George | Virginia | 51149 | 8050 | 62 |
2248048 | 2248048 | 2022-02-24 | McKean | Pennsylvania | 42083 | 8050 | 132 |
2248310 | 2248310 | 2022-02-24 | Henry | Tennessee | 47079 | 8050 | 140 |
2245059 | 2245059 | 2022-02-23 | Henry | Tennessee | 47079 | 8050 | 140 |
2238456 | 2238456 | 2022-02-21 | Brookings | South Dakota | 46011 | 8050 | 48 |
2235205 | 2235205 | 2022-02-20 | Brookings | South Dakota | 46011 | 8050 | 48 |
2231954 | 2231954 | 2022-02-19 | Brookings | South Dakota | 46011 | 8050 | 48 |
2232269 | 2232269 | 2022-02-19 | Matagorda | Texas | 48321 | 8050 | 173 |
2228703 | 2228703 | 2022-02-18 | Brookings | South Dakota | 46011 | 8050 | 48 |
2228873 | 2228873 | 2022-02-18 | Bee | Texas | 48025 | 8050 | 149 |
2212261 | 2212261 | 2022-02-13 | Clarion | Pennsylvania | 42031 | 8050 | 193 |
2021601 | 2021601 | 2021-12-17 | Tuolumne | California | 6109 | 8050 | 148 |
2018350 | 2018350 | 2021-12-16 | Tuolumne | California | 6109 | 8050 | 148 |
2003434 | 2003434 | 2021-12-11 | Pettis | Missouri | 29159 | 8050 | 128 |
1779522 | 1779522 | 2021-10-03 | Sullivan | New York | 36105 | 8050 | 82 |
1722627 | 1722627 | 2021-09-16 | Tehama | California | 6103 | 8050 | 79 |
1717063 | 1717063 | 2021-09-14 | St. Martin | Louisiana | 22099 | 8050 | 152 |
1659557 | 1659557 | 2021-08-27 | Scioto | Ohio | 39145 | 8050 | 112 |
1576113 | 1576113 | 2021-08-01 | Wood | West Virginia | 54107 | 8050 | 177 |
1572865 | 1572865 | 2021-07-31 | Wood | West Virginia | 54107 | 8050 | 177 |
1569617 | 1569617 | 2021-07-30 | Wood | West Virginia | 54107 | 8050 | 177 |
1422692 | 1422692 | 2021-06-15 | Somerset | Pennsylvania | 42111 | 8050 | 217 |
1361679 | 1361679 | 2021-05-27 | Frederick | Virginia | 51069 | 8050 | 102 |
1281496 | 1281496 | 2021-05-03 | Bartholomew | Indiana | 18005 | 8050 | 160 |
1273488 | 1273488 | 2021-04-30 | Greenwood | South Carolina | 45047 | 8050 | 172 |
1245526 | 1245526 | 2021-04-22 | Glynn | Georgia | 13127 | 8050 | 171 |
1244858 | 1244858 | 2021-04-21 | Roanoke | Virginia | 51161 | 8050 | 134 |
1191712 | 1191712 | 2021-04-05 | Chautauqua | New York | 36013 | 8050 | 131 |
1133841 | 1133841 | 2021-03-18 | Darlington | South Carolina | 45031 | 8050 | 169 |
1123815 | 1123815 | 2021-03-15 | Wayne | Ohio | 39169 | 8050 | 203 |
1117522 | 1117522 | 2021-03-13 | Carolina | Puerto Rico | 72031 | 8050 | |
1078528 | 1078528 | 2021-03-01 | Mercer | Pennsylvania | 42085 | 8050 | 240 |
953636 | 953636 | 2021-01-22 | Kosciusko | Indiana | 18085 | 8050 | 85 |
878675 | 878675 | 2020-12-30 | Coweta | Georgia | 13077 | 8050 | 84 |
828168 | 828168 | 2020-12-14 | Albany | New York | 36001 | 8050 | 169 |
703861 | 703861 | 2020-11-06 | Linn | Iowa | 19113 | 8050 | 139 |
675260 | 675260 | 2020-10-28 | Hinds | Mississippi | 28049 | 8050 | 179 |
534748 | 534748 | 2020-09-15 | Brevard | Florida | 12009 | 8050 | 263 |
483611 | 483611 | 2020-08-30 | Johnson | Kansas | 20091 | 8050 | 116 |
391571 | 391571 | 2020-08-01 | Horry | South Carolina | 45051 | 8050 | 129 |
155471 | 155471 | 2020-05-18 | Oakland | Michigan | 26125 | 8050 | 913 |
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);