ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 8971 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Georgia 5
- Louisiana 5
- New York 4
- Pennsylvania 3
- Arkansas 2
- Kentucky 2
- North Dakota 2
- Tennessee 2
- Alabama 1
- Arizona 1
- Florida 1
- Kansas 1
- Massachusetts 1
- Michigan 1
- Missouri 1
- New Hampshire 1
- New Mexico 1
- Ohio 1
- Oregon 1
- Puerto Rico 1
- South Carolina 1
- Texas 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2329344 | 2329344 | 2022-03-21 | Jefferson | Pennsylvania | 42065 | 8971 | 227 |
2324936 | 2324936 | 2022-03-20 | Iberville | Louisiana | 22047 | 8971 | 150 |
2321682 | 2321682 | 2022-03-19 | Iberville | Louisiana | 22047 | 8971 | 150 |
2318428 | 2318428 | 2022-03-18 | Iberville | Louisiana | 22047 | 8971 | 150 |
2315175 | 2315175 | 2022-03-17 | Iberville | Louisiana | 22047 | 8971 | 150 |
2311922 | 2311922 | 2022-03-16 | Iberville | Louisiana | 22047 | 8971 | 150 |
2261028 | 2261028 | 2022-02-28 | Clinton | Pennsylvania | 42035 | 8971 | 123 |
2247531 | 2247531 | 2022-02-24 | Sullivan | New Hampshire | 33019 | 8971 | 67 |
2140516 | 2140516 | 2022-01-22 | Madison | Ohio | 39097 | 8971 | 111 |
2137005 | 2137005 | 2022-01-21 | Columbia | New York | 36021 | 8971 | 131 |
2100948 | 2100948 | 2022-01-10 | Newton | Missouri | 29145 | 8971 | 169 |
2072438 | 2072438 | 2022-01-01 | Venango | Pennsylvania | 42121 | 8971 | 200 |
2066960 | 2066960 | 2021-12-31 | Graham | Arizona | 4009 | 8971 | 157 |
2016909 | 2016909 | 2021-12-15 | Stark | North Dakota | 38089 | 8971 | 78 |
2009415 | 2009415 | 2021-12-13 | Jessamine | Kentucky | 21113 | 8971 | 109 |
1960041 | 1960041 | 2021-11-28 | Effingham | Georgia | 13103 | 8971 | 175 |
1956790 | 1956790 | 2021-11-27 | Effingham | Georgia | 13103 | 8971 | 175 |
1953539 | 1953539 | 2021-11-26 | Effingham | Georgia | 13103 | 8971 | 175 |
1950288 | 1950288 | 2021-11-25 | Effingham | Georgia | 13103 | 8971 | 175 |
1947037 | 1947037 | 2021-11-24 | Effingham | Georgia | 13103 | 8971 | 175 |
1897868 | 1897868 | 2021-11-09 | Dale | Alabama | 1045 | 8971 | 186 |
1876218 | 1876218 | 2021-11-02 | Whitley | Kentucky | 21235 | 8971 | 88 |
1812698 | 1812698 | 2021-10-13 | Loudon | Tennessee | 47105 | 8971 | 93 |
1744621 | 1744621 | 2021-09-22 | Hood | Texas | 48221 | 8971 | 169 |
1702192 | 1702192 | 2021-09-09 | Carter | Tennessee | 47019 | 8971 | 188 |
1676573 | 1676573 | 2021-09-01 | Chittenden | Vermont | 50007 | 8971 | 114 |
1589374 | 1589374 | 2021-08-06 | Pope | Arkansas | 5115 | 8971 | 116 |
1573114 | 1573114 | 2021-08-01 | Lonoke | Arkansas | 5085 | 8971 | 135 |
1509865 | 1509865 | 2021-07-12 | Chautauqua | New York | 36013 | 8971 | 145 |
1506618 | 1506618 | 2021-07-11 | Chautauqua | New York | 36013 | 8971 | 145 |
1503372 | 1503372 | 2021-07-10 | Chautauqua | New York | 36013 | 8971 | 145 |
1206483 | 1206483 | 2021-04-10 | Sumter | Florida | 12119 | 8971 | 264 |
1190776 | 1190776 | 2021-04-05 | Douglas | Kansas | 20045 | 8971 | 86 |
1175439 | 1175439 | 2021-03-31 | Chaves | New Mexico | 35005 | 8971 | 164 |
997139 | 997139 | 2021-02-04 | Ward | North Dakota | 38101 | 8971 | 185 |
974606 | 974606 | 2021-01-28 | Lane | Oregon | 41039 | 8971 | 113 |
811372 | 811372 | 2020-12-09 | Jackson | Michigan | 26075 | 8971 | 132 |
636118 | 636118 | 2020-10-16 | Hampden | Massachusetts | 25013 | 8971 | 796 |
630786 | 630786 | 2020-10-14 | San Juan | Puerto Rico | 72127 | 8971 | |
343414 | 343414 | 2020-07-17 | Charleston | South Carolina | 45019 | 8971 | 80 |
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);