ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 9082 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Oklahoma 7
- Georgia 3
- Kansas 3
- Maine 3
- Kentucky 2
- Puerto Rico 2
- Texas 2
- Alabama 1
- Arkansas 1
- California 1
- Florida 1
- Idaho 1
- Illinois 1
- Indiana 1
- Louisiana 1
- Massachusetts 1
- Missouri 1
- New Jersey 1
- New York 1
- North Carolina 1
- Ohio 1
- Oregon 1
- South Carolina 1
- Washington 1
- West Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2314435 | 2314435 | 2022-03-17 | Bryan | Georgia | 13029 | 9082 | 89 |
2278437 | 2278437 | 2022-03-06 | Union | Arkansas | 5139 | 9082 | 164 |
2259943 | 2259943 | 2022-02-28 | Somerset | Maine | 23025 | 9082 | 99 |
2256692 | 2256692 | 2022-02-27 | Somerset | Maine | 23025 | 9082 | 99 |
2233663 | 2233663 | 2022-02-20 | Geary | Kansas | 20061 | 9082 | 73 |
2230412 | 2230412 | 2022-02-19 | Geary | Kansas | 20061 | 9082 | 73 |
2227161 | 2227161 | 2022-02-18 | Geary | Kansas | 20061 | 9082 | 73 |
2128636 | 2128636 | 2022-01-18 | Sweetwater | Wyoming | 56037 | 9082 | 114 |
1961945 | 1961945 | 2021-11-28 | Caguas | Puerto Rico | 72025 | 9082 | |
1958694 | 1958694 | 2021-11-27 | Caguas | Puerto Rico | 72025 | 9082 | |
1907472 | 1907472 | 2021-11-11 | Mercer | West Virginia | 54055 | 9082 | 180 |
1900007 | 1900007 | 2021-11-09 | Carter | Oklahoma | 40019 | 9082 | 193 |
1896757 | 1896757 | 2021-11-08 | Carter | Oklahoma | 40019 | 9082 | 193 |
1893507 | 1893507 | 2021-11-07 | Carter | Oklahoma | 40019 | 9082 | 193 |
1890257 | 1890257 | 2021-11-06 | Carter | Oklahoma | 40019 | 9082 | 193 |
1887007 | 1887007 | 2021-11-05 | Carter | Oklahoma | 40019 | 9082 | 193 |
1883757 | 1883757 | 2021-11-04 | Carter | Oklahoma | 40019 | 9082 | 193 |
1880508 | 1880508 | 2021-11-03 | Carter | Oklahoma | 40019 | 9082 | 193 |
1609433 | 1609433 | 2021-08-12 | Hancock | Indiana | 18059 | 9082 | 156 |
1597557 | 1597557 | 2021-08-08 | Chautauqua | New York | 36013 | 9082 | 146 |
1557741 | 1557741 | 2021-07-27 | Campbell | Kentucky | 21037 | 9082 | 84 |
1514532 | 1514532 | 2021-07-14 | DeKalb | Alabama | 1049 | 9082 | 191 |
1378630 | 1378630 | 2021-06-02 | Fayette | Georgia | 13113 | 9082 | 175 |
1311803 | 1311803 | 2021-05-12 | Cape May | New Jersey | 34009 | 9082 | 202 |
1239272 | 1239272 | 2021-04-20 | Vermilion | Illinois | 17183 | 9082 | 144 |
1207175 | 1207175 | 2021-04-10 | Madison | Kentucky | 21151 | 9082 | 108 |
1207624 | 1207624 | 2021-04-10 | Cole | Missouri | 29051 | 9082 | 122 |
1125514 | 1125514 | 2021-03-16 | Twin Falls | Idaho | 16083 | 9082 | 125 |
1076419 | 1076419 | 2021-03-01 | El Dorado | California | 6017 | 9082 | 100 |
1073446 | 1073446 | 2021-02-28 | Jackson | Georgia | 13157 | 9082 | 131 |
1046208 | 1046208 | 2021-02-19 | Lancaster | South Carolina | 45057 | 9082 | 132 |
1031988 | 1031988 | 2021-02-15 | York | Maine | 23031 | 9082 | 109 |
1011644 | 1011644 | 2021-02-09 | Citrus | Florida | 12017 | 9082 | 365 |
971936 | 971936 | 2021-01-27 | Rockwall | Texas | 48397 | 9082 | 91 |
904033 | 904033 | 2021-01-06 | Franklin | Washington | 53021 | 9082 | 86 |
841210 | 841210 | 2020-12-18 | Alamance | North Carolina | 37001 | 9082 | 114 |
776646 | 776646 | 2020-11-28 | Marion | Oregon | 41047 | 9082 | 139 |
679131 | 679131 | 2020-10-29 | Butler | Ohio | 39017 | 9082 | 133 |
611803 | 611803 | 2020-10-08 | Williamson | Texas | 48491 | 9082 | 145 |
603604 | 603604 | 2020-10-06 | Lafayette | Louisiana | 22055 | 9082 | 135 |
272559 | 272559 | 2020-06-25 | Norfolk | Massachusetts | 25021 | 9082 | 924 |
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);