ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 7720 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Maryland 5
- Georgia 4
- New York 3
- Ohio 3
- Wisconsin 3
- Kansas 2
- Kentucky 2
- Oklahoma 2
- Arizona 1
- California 1
- Indiana 1
- Louisiana 1
- Minnesota 1
- Mississippi 1
- New Jersey 1
- Tennessee 1
- Texas 1
- Utah 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337761 | 2337761 | 2022-03-24 | Miami | Kansas | 20121 | 7720 | 90 |
2334507 | 2334507 | 2022-03-23 | Miami | Kansas | 20121 | 7720 | 90 |
2320142 | 2320142 | 2022-03-18 | Upshur | Texas | 48459 | 7720 | 180 |
2197984 | 2197984 | 2022-02-09 | Calloway | Kentucky | 21035 | 7720 | 73 |
2129732 | 2129732 | 2022-01-19 | Muhlenberg | Kentucky | 21177 | 7720 | 104 |
2038970 | 2038970 | 2021-12-22 | Isanti | Minnesota | 27059 | 7720 | 94 |
1924084 | 1924084 | 2021-11-17 | Tuolumne | California | 6109 | 7720 | 138 |
1790252 | 1790252 | 2021-10-06 | Box Elder | Utah | 49003 | 7720 | 72 |
1695250 | 1695250 | 2021-09-07 | Hancock | Ohio | 39063 | 7720 | 139 |
1674865 | 1674865 | 2021-09-01 | Allegany | Maryland | 24001 | 7720 | 217 |
1627484 | 1627484 | 2021-08-17 | Cumberland | Tennessee | 47035 | 7720 | 147 |
1587079 | 1587079 | 2021-08-05 | Acadia | Louisiana | 22001 | 7720 | 202 |
1574843 | 1574843 | 2021-08-01 | Oswego | New York | 36075 | 7720 | 93 |
1511175 | 1511175 | 2021-07-12 | Chippewa | Wisconsin | 55017 | 7720 | 97 |
1472280 | 1472280 | 2021-06-30 | Wood | Wisconsin | 55141 | 7720 | 106 |
1450813 | 1450813 | 2021-06-24 | Wicomico | Maryland | 24045 | 7720 | 173 |
1447567 | 1447567 | 2021-06-23 | Wicomico | Maryland | 24045 | 7720 | 173 |
1443534 | 1443534 | 2021-06-22 | Dougherty | Georgia | 13095 | 7720 | 311 |
1444322 | 1444322 | 2021-06-22 | Wicomico | Maryland | 24045 | 7720 | 173 |
1437042 | 1437042 | 2021-06-20 | Dougherty | Georgia | 13095 | 7720 | 311 |
1430549 | 1430549 | 2021-06-18 | Dougherty | Georgia | 13095 | 7720 | 311 |
1352942 | 1352942 | 2021-05-25 | Floyd | Indiana | 18043 | 7720 | 184 |
1293679 | 1293679 | 2021-05-06 | Wood | West Virginia | 54107 | 7720 | 168 |
1256896 | 1256896 | 2021-04-25 | Erie | Ohio | 39043 | 7720 | 154 |
1146248 | 1146248 | 2021-03-22 | Chautauqua | New York | 36013 | 7720 | 130 |
1088182 | 1088182 | 2021-03-04 | Wagoner | Oklahoma | 40145 | 7720 | 83 |
1050704 | 1050704 | 2021-02-21 | Fayette | Georgia | 13113 | 7720 | 137 |
1049223 | 1049223 | 2021-02-20 | Pottawatomie | Oklahoma | 40125 | 7720 | 72 |
1035479 | 1035479 | 2021-02-16 | Jones | Mississippi | 28067 | 7720 | 140 |
1010192 | 1010192 | 2021-02-08 | Pickaway | Ohio | 39129 | 7720 | 51 |
1007801 | 1007801 | 2021-02-07 | Hampton city | Virginia | 51650 | 7720 | 69 |
974245 | 974245 | 2021-01-28 | Rensselaer | New York | 36083 | 7720 | 116 |
967082 | 967082 | 2021-01-26 | Charles | Maryland | 24017 | 7720 | 142 |
670536 | 670536 | 2020-10-26 | Racine | Wisconsin | 55101 | 7720 | 109 |
379610 | 379610 | 2020-07-29 | Pinal | Arizona | 4021 | 7720 | 124 |
171045 | 171045 | 2020-05-23 | Monmouth | New Jersey | 34025 | 7720 | 551 |
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);