ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 9099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2362756 | 2362756 | 2022-03-31 | Green | Wisconsin | 55045 | 9099 | 53 |
2350221 | 2350221 | 2022-03-28 | Bryan | Georgia | 13029 | 9099 | 90 |
2310966 | 2310966 | 2022-03-16 | Amador | California | 6005 | 9099 | 85 |
2307713 | 2307713 | 2022-03-15 | Amador | California | 6005 | 9099 | 85 |
2263973 | 2263973 | 2022-03-01 | Person | North Carolina | 37145 | 9099 | 104 |
2147030 | 2147030 | 2022-01-24 | Mercer | Ohio | 39107 | 9099 | 112 |
2087551 | 2087551 | 2022-01-06 | Washington | Louisiana | 22117 | 9099 | 222 |
2066632 | 2066632 | 2021-12-30 | Pittsylvania | Virginia | 51143 | 9099 | 141 |
2037163 | 2037163 | 2021-12-21 | Navarro | Texas | 48349 | 9099 | 193 |
1966864 | 1966864 | 2021-11-30 | Noble | Indiana | 18113 | 9099 | 126 |
1961576 | 1961576 | 2021-11-28 | Pender | North Carolina | 37141 | 9099 | 101 |
1958325 | 1958325 | 2021-11-27 | Pender | North Carolina | 37141 | 9099 | 101 |
1955074 | 1955074 | 2021-11-26 | Pender | North Carolina | 37141 | 9099 | 101 |
1951823 | 1951823 | 2021-11-25 | Pender | North Carolina | 37141 | 9099 | 101 |
1948572 | 1948572 | 2021-11-24 | Pender | North Carolina | 37141 | 9099 | 101 |
1808213 | 1808213 | 2021-10-12 | Crow Wing | Minnesota | 27035 | 9099 | 104 |
1676562 | 1676562 | 2021-09-01 | Tooele | Utah | 49045 | 9099 | 51 |
1602142 | 1602142 | 2021-08-09 | Manitowoc | Wisconsin | 55071 | 9099 | 96 |
1439997 | 1439997 | 2021-06-21 | Jefferson | Arkansas | 5069 | 9099 | 170 |
1391611 | 1391611 | 2021-06-06 | Fayette | Georgia | 13113 | 9099 | 176 |
1318146 | 1318146 | 2021-05-14 | Missoula | Montana | 30063 | 9099 | 94 |
1314775 | 1314775 | 2021-05-13 | Cole | Missouri | 29051 | 9099 | 124 |
1302182 | 1302182 | 2021-05-09 | Brunswick | North Carolina | 37019 | 9099 | 152 |
1298934 | 1298934 | 2021-05-08 | Brunswick | North Carolina | 37019 | 9099 | 152 |
1295688 | 1295688 | 2021-05-07 | Brunswick | North Carolina | 37019 | 9099 | 152 |
1124740 | 1124740 | 2021-03-15 | Grant | Washington | 53025 | 9099 | 114 |
1121024 | 1121024 | 2021-03-14 | Robertson | Tennessee | 47147 | 9099 | 123 |
1121494 | 1121494 | 2021-03-14 | Grant | Washington | 53025 | 9099 | 114 |
1117777 | 1117777 | 2021-03-13 | Robertson | Tennessee | 47147 | 9099 | 123 |
1118247 | 1118247 | 2021-03-13 | Grant | Washington | 53025 | 9099 | 114 |
1114530 | 1114530 | 2021-03-12 | Robertson | Tennessee | 47147 | 9099 | 123 |
1115000 | 1115000 | 2021-03-12 | Grant | Washington | 53025 | 9099 | 114 |
955054 | 955054 | 2021-01-22 | Comanche | Oklahoma | 40031 | 9099 | 95 |
939243 | 939243 | 2021-01-17 | Madison | Tennessee | 47113 | 9099 | 178 |
794531 | 794531 | 2020-12-04 | McLean | Illinois | 17113 | 9099 | 59 |
680688 | 680688 | 2020-10-30 | St. Lucie | Florida | 12111 | 9099 | 335 |
663933 | 663933 | 2020-10-24 | Spokane | Washington | 53063 | 9099 | 198 |
660689 | 660689 | 2020-10-23 | Spokane | Washington | 53063 | 9099 | 198 |
654593 | 654593 | 2020-10-22 | Sonoma | California | 6097 | 9099 | 134 |
589551 | 589551 | 2020-10-02 | Tuscaloosa | Alabama | 1125 | 9099 | 119 |
324527 | 324527 | 2020-07-11 | El Paso | Texas | 48141 | 9099 | 150 |
210466 | 210466 | 2020-06-05 | Hennepin | Minnesota | 27053 | 9099 | 657 |
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);