ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 9437 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Ohio 9
- Illinois 7
- Alabama 4
- Virginia 3
- Wisconsin 3
- Arkansas 2
- New Jersey 2
- North Carolina 2
- West Virginia 2
- California 1
- Georgia 1
- Kentucky 1
- Louisiana 1
- Mississippi 1
- Missouri 1
- Nevada 1
- South Carolina 1
- South Dakota 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444099 | 2444099 | 2022-04-25 | Randolph | West Virginia | 54083 | 9437 | 88 |
2431299 | 2431299 | 2022-04-22 | Boone | Arkansas | 5009 | 9437 | 180 |
2347233 | 2347233 | 2022-03-27 | Morgan | Illinois | 17137 | 9437 | 144 |
2343980 | 2343980 | 2022-03-26 | Morgan | Illinois | 17137 | 9437 | 144 |
2340727 | 2340727 | 2022-03-25 | Morgan | Illinois | 17137 | 9437 | 144 |
2335683 | 2335683 | 2022-03-23 | Preble | Ohio | 39135 | 9437 | 194 |
2332429 | 2332429 | 2022-03-22 | Preble | Ohio | 39135 | 9437 | 194 |
2329176 | 2329176 | 2022-03-21 | Preble | Ohio | 39135 | 9437 | 194 |
2324446 | 2324446 | 2022-03-20 | Logan | Illinois | 17107 | 9437 | 98 |
2325924 | 2325924 | 2022-03-20 | Preble | Ohio | 39135 | 9437 | 194 |
2321192 | 2321192 | 2022-03-19 | Logan | Illinois | 17107 | 9437 | 98 |
2322671 | 2322671 | 2022-03-19 | Preble | Ohio | 39135 | 9437 | 194 |
2317938 | 2317938 | 2022-03-18 | Logan | Illinois | 17107 | 9437 | 98 |
2319417 | 2319417 | 2022-03-18 | Preble | Ohio | 39135 | 9437 | 194 |
2316163 | 2316163 | 2022-03-17 | Preble | Ohio | 39135 | 9437 | 194 |
2291933 | 2291933 | 2022-03-10 | Monroe | Illinois | 17133 | 9437 | 129 |
2266718 | 2266718 | 2022-03-02 | Pike | Mississippi | 28113 | 9437 | 182 |
2216876 | 2216876 | 2022-02-15 | Baldwin | Georgia | 13009 | 9437 | 217 |
2156577 | 2156577 | 2022-01-27 | Alexander | North Carolina | 37003 | 9437 | 121 |
2054917 | 2054917 | 2021-12-27 | Hopkins | Kentucky | 21107 | 9437 | 220 |
2020086 | 2020086 | 2021-12-16 | Pender | North Carolina | 37141 | 9437 | 102 |
1971118 | 1971118 | 2021-12-01 | Carson City | Nevada | 32510 | 9437 | 172 |
1849060 | 1849060 | 2021-10-24 | Portage | Wisconsin | 55097 | 9437 | 96 |
1845810 | 1845810 | 2021-10-23 | Portage | Wisconsin | 55097 | 9437 | 96 |
1842560 | 1842560 | 2021-10-22 | Portage | Wisconsin | 55097 | 9437 | 96 |
1697584 | 1697584 | 2021-09-08 | Vermilion | Louisiana | 22113 | 9437 | 162 |
1669292 | 1669292 | 2021-08-30 | Pickaway | Ohio | 39129 | 9437 | 125 |
1566490 | 1566490 | 2021-07-30 | DeKalb | Alabama | 1049 | 9437 | 192 |
1563242 | 1563242 | 2021-07-29 | DeKalb | Alabama | 1049 | 9437 | 192 |
1530504 | 1530504 | 2021-07-18 | Montgomery | Virginia | 51121 | 9437 | 95 |
1527257 | 1527257 | 2021-07-17 | Montgomery | Virginia | 51121 | 9437 | 95 |
1524010 | 1524010 | 2021-07-16 | Montgomery | Virginia | 51121 | 9437 | 95 |
1483564 | 1483564 | 2021-07-04 | Cole | Missouri | 29051 | 9437 | 130 |
1310046 | 1310046 | 2021-05-12 | Lauderdale | Alabama | 1077 | 9437 | 241 |
1256615 | 1256615 | 2021-04-25 | Hunterdon | New Jersey | 34019 | 9437 | 171 |
1196378 | 1196378 | 2021-04-07 | Cullman | Alabama | 1043 | 9437 | 188 |
1183559 | 1183559 | 2021-04-03 | El Dorado | California | 6017 | 9437 | 108 |
1037412 | 1037412 | 2021-02-17 | Garland | Arkansas | 5051 | 9437 | 229 |
1033883 | 1033883 | 2021-02-15 | Berkeley | West Virginia | 54003 | 9437 | 95 |
851146 | 851146 | 2020-12-21 | Licking | Ohio | 39089 | 9437 | 103 |
653621 | 653621 | 2020-10-21 | Minnehaha | South Dakota | 46099 | 9437 | 97 |
516793 | 516793 | 2020-09-09 | Camden | New Jersey | 34007 | 9437 | 595 |
349814 | 349814 | 2020-07-19 | Charleston | South Carolina | 45019 | 9437 | 87 |
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);