ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 11232 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 17
- Illinois 3
- New York 3
- Wisconsin 3
- Georgia 2
- Pennsylvania 2
- Arizona 1
- Arkansas 1
- California 1
- Indiana 1
- Iowa 1
- Kentucky 1
- Louisiana 1
- Nebraska 1
- North Carolina 1
- Ohio 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2399793 | 2399793 | 2022-04-12 | St. Bernard | Louisiana | 22087 | 11232 | 111 |
2365158 | 2365158 | 2022-04-01 | Venango | Pennsylvania | 42121 | 11232 | 237 |
2361905 | 2361905 | 2022-03-31 | Venango | Pennsylvania | 42121 | 11232 | 236 |
2213949 | 2213949 | 2022-02-14 | DeKalb | Indiana | 18033 | 11232 | 145 |
2150147 | 2150147 | 2022-01-25 | Richmond | North Carolina | 37153 | 11232 | 159 |
2132552 | 2132552 | 2022-01-20 | Macoupin | Illinois | 17117 | 11232 | 156 |
1816337 | 1816337 | 2021-10-14 | Frederick | Virginia | 51069 | 11232 | 135 |
1738517 | 1738517 | 2021-09-20 | Monongalia | West Virginia | 54061 | 11232 | 108 |
1656059 | 1656059 | 2021-08-26 | Putnam | New York | 36079 | 11232 | 94 |
1431996 | 1431996 | 2021-06-18 | Rensselaer | New York | 36083 | 11232 | 143 |
1346544 | 1346544 | 2021-05-23 | Dallas | Iowa | 19049 | 11232 | 98 |
1339725 | 1339725 | 2021-05-21 | Newton | Georgia | 13217 | 11232 | 252 |
1164529 | 1164529 | 2021-03-28 | LaSalle | Illinois | 17099 | 11232 | 281 |
1079566 | 1079566 | 2021-03-02 | Cochise | Arizona | 4003 | 11232 | 265 |
1043938 | 1043938 | 2021-02-19 | Saline | Arkansas | 5125 | 11232 | 162 |
1029686 | 1029686 | 2021-02-14 | Wood | Ohio | 39173 | 11232 | 191 |
976034 | 976034 | 2021-01-29 | Coweta | Georgia | 13077 | 11232 | 116 |
927987 | 927987 | 2021-01-14 | Kenton | Kentucky | 21117 | 11232 | 90 |
907376 | 907376 | 2021-01-07 | Dodge | Wisconsin | 55027 | 11232 | 143 |
869176 | 869176 | 2020-12-27 | McLean | Illinois | 17113 | 11232 | 99 |
803538 | 803538 | 2020-12-06 | Kenosha | Wisconsin | 55059 | 11232 | 165 |
674048 | 674048 | 2020-10-28 | San Mateo | California | 6081 | 11232 | 159 |
432876 | 432876 | 2020-08-14 | Orange | New York | 36071 | 11232 | 408 |
413363 | 413363 | 2020-08-08 | Douglas | Nebraska | 31055 | 11232 | 137 |
287024 | 287024 | 2020-06-29 | Milwaukee | Wisconsin | 55079 | 11232 | 389 |
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);