ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 7190 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Texas 4
- Kansas 3
- North Carolina 3
- Pennsylvania 3
- Washington 3
- West Virginia 3
- Wisconsin 3
- Indiana 2
- Alabama 1
- Arizona 1
- Arkansas 1
- California 1
- Georgia 1
- Illinois 1
- Maryland 1
- Michigan 1
- Mississippi 1
- Missouri 1
- New York 1
- Oklahoma 1
- South Dakota 1
- Tennessee 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2305005 | 2305005 | 2022-03-14 | Greene | Indiana | 18055 | 7190 | 138 |
2281392 | 2281392 | 2022-03-06 | Nicholas | West Virginia | 54067 | 7190 | 90 |
2278139 | 2278139 | 2022-03-05 | Nicholas | West Virginia | 54067 | 7190 | 90 |
2274886 | 2274886 | 2022-03-04 | Nicholas | West Virginia | 54067 | 7190 | 90 |
2244817 | 2244817 | 2022-02-23 | Warren | Pennsylvania | 42123 | 7190 | 207 |
2245414 | 2245414 | 2022-02-23 | Windsor | Vermont | 50027 | 7190 | 49 |
2103370 | 2103370 | 2022-01-11 | Jefferson | Indiana | 18077 | 7190 | 127 |
2098423 | 2098423 | 2022-01-09 | Jefferson | Pennsylvania | 42065 | 7190 | 187 |
2099194 | 2099194 | 2022-01-09 | Douglas | Washington | 53017 | 7190 | 54 |
2095156 | 2095156 | 2022-01-08 | Clinton | Pennsylvania | 42035 | 7190 | 110 |
2095943 | 2095943 | 2022-01-08 | Douglas | Washington | 53017 | 7190 | 54 |
2092691 | 2092691 | 2022-01-07 | Douglas | Washington | 53017 | 7190 | 54 |
2000114 | 2000114 | 2021-12-10 | Butler | Missouri | 29023 | 7190 | 127 |
1994005 | 1994005 | 2021-12-08 | Washington | New York | 36115 | 7190 | 84 |
1968643 | 1968643 | 2021-11-30 | Cheatham | Tennessee | 47021 | 7190 | 77 |
1922062 | 1922062 | 2021-11-16 | Oktibbeha | Mississippi | 28105 | 7190 | 138 |
1910344 | 1910344 | 2021-11-12 | Jim Wells | Texas | 48249 | 7190 | 179 |
1907095 | 1907095 | 2021-11-11 | Jim Wells | Texas | 48249 | 7190 | 178 |
1882254 | 1882254 | 2021-11-04 | Macoupin | Illinois | 17117 | 7190 | 138 |
1855552 | 1855552 | 2021-10-26 | Oconto | Wisconsin | 55083 | 7190 | 76 |
1783526 | 1783526 | 2021-10-04 | Burnet | Texas | 48053 | 7190 | 107 |
1724333 | 1724333 | 2021-09-16 | Granville | North Carolina | 37077 | 7190 | 94 |
1718717 | 1718717 | 2021-09-14 | Rusk | Texas | 48401 | 7190 | 135 |
1603405 | 1603405 | 2021-08-10 | Allegany | Maryland | 24001 | 7190 | 214 |
1521101 | 1521101 | 2021-07-16 | Gila | Arizona | 4007 | 7190 | 231 |
1291826 | 1291826 | 2021-05-06 | Midland | Michigan | 26111 | 7190 | 82 |
1264619 | 1264619 | 2021-04-28 | Walker | Alabama | 1127 | 7190 | 278 |
1232039 | 1232039 | 2021-04-17 | Portage | Wisconsin | 55097 | 7190 | 70 |
1073881 | 1073881 | 2021-02-28 | Butler | Kansas | 20015 | 7190 | 69 |
1070635 | 1070635 | 2021-02-27 | Butler | Kansas | 20015 | 7190 | 69 |
1067390 | 1067390 | 2021-02-26 | Butler | Kansas | 20015 | 7190 | 69 |
1003747 | 1003747 | 2021-02-06 | Garfield | Oklahoma | 40047 | 7190 | 63 |
939873 | 939873 | 2021-01-17 | St. Croix | Wisconsin | 55109 | 7190 | 37 |
932673 | 932673 | 2021-01-15 | Lincoln | South Dakota | 46083 | 7190 | 68 |
917337 | 917337 | 2021-01-11 | Jefferson | Arkansas | 5069 | 7190 | 134 |
831539 | 831539 | 2020-12-15 | Onslow | North Carolina | 37133 | 7190 | 52 |
761913 | 761913 | 2020-11-24 | Muscogee | Georgia | 13215 | 7190 | 190 |
682235 | 682235 | 2020-10-30 | Cumberland | North Carolina | 37051 | 7190 | 99 |
306224 | 306224 | 2020-07-06 | Imperial | California | 6025 | 7190 | 116 |
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);