ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 13949 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Tennessee 7
- South Dakota 5
- Maine 3
- North Carolina 2
- Texas 2
- California 1
- Colorado 1
- Florida 1
- Missouri 1
- New York 1
- Ohio 1
- Oregon 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496569 | 2496569 | 2022-05-12 | Broomfield | Colorado | 8014 | 13949 | 116 |
2222386 | 2222386 | 2022-02-16 | Caldwell | Texas | 48055 | 13949 | 168 |
2219073 | 2219073 | 2022-02-15 | Monroe | Tennessee | 47123 | 13949 | 206 |
2215822 | 2215822 | 2022-02-14 | Monroe | Tennessee | 47123 | 13949 | 206 |
2212571 | 2212571 | 2022-02-13 | Monroe | Tennessee | 47123 | 13949 | 206 |
2209318 | 2209318 | 2022-02-12 | Monroe | Tennessee | 47123 | 13949 | 206 |
2206065 | 2206065 | 2022-02-11 | Monroe | Tennessee | 47123 | 13949 | 206 |
2202812 | 2202812 | 2022-02-10 | Monroe | Tennessee | 47123 | 13949 | 206 |
2199558 | 2199558 | 2022-02-09 | Monroe | Tennessee | 47123 | 13949 | 206 |
2195944 | 2195944 | 2022-02-08 | Benton | Oregon | 41003 | 13949 | 56 |
2167898 | 2167898 | 2022-01-31 | Mendocino | California | 6045 | 13949 | 113 |
2024167 | 2024167 | 2021-12-17 | Orange | Texas | 48361 | 13949 | 306 |
1968022 | 1968022 | 2021-11-30 | Caldwell | North Carolina | 37027 | 13949 | 227 |
1920474 | 1920474 | 2021-11-15 | Monongalia | West Virginia | 54061 | 13949 | 145 |
1785657 | 1785657 | 2021-10-05 | Franklin | Missouri | 29071 | 13949 | 213 |
1659572 | 1659572 | 2021-08-27 | Wood | Ohio | 39173 | 13949 | 206 |
1600155 | 1600155 | 2021-08-09 | York | Maine | 23031 | 13949 | 139 |
1596907 | 1596907 | 2021-08-08 | York | Maine | 23031 | 13949 | 139 |
1593658 | 1593658 | 2021-08-07 | York | Maine | 23031 | 13949 | 139 |
1491048 | 1491048 | 2021-07-06 | Pennington | South Dakota | 46103 | 13949 | 204 |
1487801 | 1487801 | 2021-07-05 | Pennington | South Dakota | 46103 | 13949 | 204 |
1484554 | 1484554 | 2021-07-04 | Pennington | South Dakota | 46103 | 13949 | 204 |
1481308 | 1481308 | 2021-07-03 | Pennington | South Dakota | 46103 | 13949 | 204 |
1478061 | 1478061 | 2021-07-02 | Pennington | South Dakota | 46103 | 13949 | 204 |
1022980 | 1022980 | 2021-02-12 | Davidson | North Carolina | 37057 | 13949 | 146 |
933743 | 933743 | 2021-01-16 | Bay | Florida | 12005 | 13949 | 255 |
663869 | 663869 | 2020-10-24 | Prince William | Virginia | 51153 | 13949 | 223 |
419985 | 419985 | 2020-08-10 | Rockland | New York | 36087 | 13949 | 507 |
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);