ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where cases = 8579 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Texas 7
- Alabama 5
- North Carolina 5
- Wisconsin 5
- Indiana 4
- Pennsylvania 3
- Arkansas 2
- Louisiana 2
- Minnesota 2
- Nebraska 2
- Arizona 1
- California 1
- Florida 1
- Guam 1
- Idaho 1
- Maryland 1
- Michigan 1
- Missouri 1
- New Jersey 1
- Ohio 1
- Oregon 1
- South Carolina 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498061 | 2498061 | 2022-05-12 | Platte | Nebraska | 31141 | 8579 | 75 |
2494803 | 2494803 | 2022-05-11 | Platte | Nebraska | 31141 | 8579 | 75 |
2365682 | 2365682 | 2022-04-01 | Titus | Texas | 48449 | 8579 | 128 |
2291831 | 2291831 | 2022-03-10 | Bonner | Idaho | 16017 | 8579 | 176 |
2281623 | 2281623 | 2022-03-07 | Baxter | Arkansas | 5005 | 8579 | 235 |
2189520 | 2189520 | 2022-02-06 | Perry | Pennsylvania | 42099 | 8579 | 174 |
2157942 | 2157942 | 2022-01-28 | Covington | Alabama | 1039 | 8579 | 203 |
2154689 | 2154689 | 2022-01-27 | Covington | Alabama | 1039 | 8579 | 203 |
2151436 | 2151436 | 2022-01-26 | Covington | Alabama | 1039 | 8579 | 203 |
2152929 | 2152929 | 2022-01-26 | Camden | Missouri | 29029 | 8579 | 162 |
2148184 | 2148184 | 2022-01-25 | Covington | Alabama | 1039 | 8579 | 203 |
2144932 | 2144932 | 2022-01-24 | Covington | Alabama | 1039 | 8579 | 203 |
2119026 | 2119026 | 2022-01-16 | Independence | Arkansas | 5063 | 8579 | 181 |
2089089 | 2089089 | 2022-01-06 | Hale | Texas | 48189 | 8579 | 206 |
2084466 | 2084466 | 2022-01-05 | Douglas | Minnesota | 27041 | 8579 | 107 |
2078910 | 2078910 | 2022-01-03 | Huntingdon | Pennsylvania | 42061 | 8579 | 203 |
2079473 | 2079473 | 2022-01-03 | Van Zandt | Texas | 48467 | 8579 | 236 |
2028575 | 2028575 | 2021-12-19 | Cass | Indiana | 18017 | 8579 | 138 |
2025324 | 2025324 | 2021-12-18 | Cass | Indiana | 18017 | 8579 | 138 |
2026677 | 2026677 | 2021-12-18 | Ashland | Ohio | 39005 | 8579 | 160 |
2022073 | 2022073 | 2021-12-17 | Cass | Indiana | 18017 | 8579 | 138 |
1944517 | 1944517 | 2021-11-23 | St. Mary | Louisiana | 22101 | 8579 | 226 |
1918105 | 1918105 | 2021-11-15 | Noble | Indiana | 18113 | 8579 | 118 |
1887463 | 1887463 | 2021-11-05 | Unknown | Tennessee | 8579 | 123 | |
1875059 | 1875059 | 2021-11-01 | Sauk | Wisconsin | 55111 | 8579 | 70 |
1720474 | 1720474 | 2021-09-15 | Blue Earth | Minnesota | 27013 | 8579 | 47 |
1699762 | 1699762 | 2021-09-09 | Santa Cruz | Arizona | 4023 | 8579 | 187 |
1675911 | 1675911 | 2021-09-01 | Linn | Oregon | 41043 | 8579 | 83 |
1620432 | 1620432 | 2021-08-15 | Stanly | North Carolina | 37167 | 8579 | 141 |
1617184 | 1617184 | 2021-08-14 | Stanly | North Carolina | 37167 | 8579 | 141 |
1613936 | 1613936 | 2021-08-13 | Stanly | North Carolina | 37167 | 8579 | 141 |
1422345 | 1422345 | 2021-06-15 | Orange | North Carolina | 37135 | 8579 | 101 |
1402872 | 1402872 | 2021-06-09 | Orange | North Carolina | 37135 | 8579 | 101 |
1297370 | 1297370 | 2021-05-08 | Highlands | Florida | 12055 | 8579 | 357 |
1221358 | 1221358 | 2021-04-14 | Adams | Pennsylvania | 42001 | 8579 | 163 |
1215786 | 1215786 | 2021-04-12 | Manitowoc | Wisconsin | 55071 | 8579 | 87 |
1212539 | 1212539 | 2021-04-11 | Manitowoc | Wisconsin | 55071 | 8579 | 87 |
1209290 | 1209290 | 2021-04-10 | Manitowoc | Wisconsin | 55071 | 8579 | 87 |
1200775 | 1200775 | 2021-04-08 | St. Landry | Louisiana | 22097 | 8579 | 250 |
1098897 | 1098897 | 2021-03-07 | Ozaukee | Wisconsin | 55089 | 8579 | 86 |
989142 | 989142 | 2021-02-02 | Unknown | Guam | 8579 | 130 | |
947655 | 947655 | 2021-01-20 | Calhoun | Michigan | 26025 | 8579 | 207 |
553467 | 553467 | 2020-09-20 | Williamson | Texas | 48491 | 8579 | 142 |
550228 | 550228 | 2020-09-19 | Williamson | Texas | 48491 | 8579 | 142 |
546989 | 546989 | 2020-09-18 | Williamson | Texas | 48491 | 8579 | 140 |
518469 | 518469 | 2020-09-10 | Santa Barbara | California | 6083 | 8579 | 103 |
410890 | 410890 | 2020-08-07 | Richland | South Carolina | 45079 | 8579 | 148 |
350185 | 350185 | 2020-07-19 | Nueces | Texas | 48355 | 8579 | 95 |
329452 | 329452 | 2020-07-13 | Baltimore city | Maryland | 24510 | 8579 | 366 |
60701 | 60701 | 2020-04-15 | Essex | New Jersey | 34013 | 8579 | 590 |
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);