ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 13152 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- West Virginia 5
- Texas 4
- Minnesota 3
- California 2
- New York 2
- Pennsylvania 2
- Wisconsin 2
- Arkansas 1
- Illinois 1
- New Mexico 1
- North Carolina 1
- Ohio 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486403 | 2486403 | 2022-05-08 | Fayette | West Virginia | 54019 | 13152 | 204 |
2483145 | 2483145 | 2022-05-07 | Fayette | West Virginia | 54019 | 13152 | 204 |
2479887 | 2479887 | 2022-05-06 | Fayette | West Virginia | 54019 | 13152 | 204 |
2416258 | 2416258 | 2022-04-17 | Goodhue | Minnesota | 27049 | 13152 | 131 |
2413002 | 2413002 | 2022-04-16 | Goodhue | Minnesota | 27049 | 13152 | 131 |
2409746 | 2409746 | 2022-04-15 | Goodhue | Minnesota | 27049 | 13152 | 131 |
2278414 | 2278414 | 2022-03-06 | Mississippi | Arkansas | 5093 | 13152 | 194 |
2123988 | 2123988 | 2022-01-17 | Cattaraugus | New York | 36009 | 13152 | 197 |
2053396 | 2053396 | 2021-12-26 | Maverick | Texas | 48323 | 13152 | 413 |
2050146 | 2050146 | 2021-12-25 | Maverick | Texas | 48323 | 13152 | 413 |
2046896 | 2046896 | 2021-12-24 | Maverick | Texas | 48323 | 13152 | 413 |
2043646 | 2043646 | 2021-12-23 | Maverick | Texas | 48323 | 13152 | 413 |
1868504 | 1868504 | 2021-10-30 | Wood | West Virginia | 54107 | 13152 | 246 |
1825419 | 1825419 | 2021-10-17 | Mercer | Pennsylvania | 42085 | 13152 | 311 |
1585876 | 1585876 | 2021-08-04 | Dodge | Wisconsin | 55027 | 13152 | 201 |
1582559 | 1582559 | 2021-08-03 | Berkeley | West Virginia | 54003 | 13152 | 138 |
1370334 | 1370334 | 2021-05-30 | Schenectady | New York | 36093 | 13152 | 202 |
1360997 | 1360997 | 2021-05-27 | Fayette | Pennsylvania | 42051 | 13152 | 320 |
1076431 | 1076431 | 2021-03-01 | Marin | California | 6041 | 13152 | 197 |
1028228 | 1028228 | 2021-02-14 | Tazewell | Illinois | 17179 | 13152 | 269 |
1003411 | 1003411 | 2021-02-06 | San Juan | New Mexico | 35045 | 13152 | 396 |
990562 | 990562 | 2021-02-02 | Onslow | North Carolina | 37133 | 13152 | 115 |
991801 | 991801 | 2021-02-02 | Sheboygan | Wisconsin | 55117 | 13152 | 129 |
903038 | 903038 | 2021-01-06 | Clermont | Ohio | 39025 | 13152 | 86 |
293600 | 293600 | 2020-07-02 | San Bernardino | California | 6071 | 13152 | 265 |
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);