ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where county = "Unknown" and "date" is on date 2022-01-25 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 30
- Alaska 1
- American Samoa 1
- Arkansas 1
- Connecticut 1
- Delaware 1
- Florida 1
- Georgia 1
- Guam 1
- Hawaii 1
- Illinois 1
- Iowa 1
- Louisiana 1
- Maine 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- Nebraska 1
- New Hampshire 1
- New Jersey 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Puerto Rico 1
- Rhode Island 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
fips 1
- - 30
county 1
- Unknown · 30 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2148255 | 2148255 | 2022-01-25 | Unknown | Alaska | 671 | 1 | |
2148260 | 2148260 | 2022-01-25 | Unknown | American Samoa | 18 | 0 | |
2148346 | 2148346 | 2022-01-25 | Unknown | Arkansas | 20786 | 0 | |
2148481 | 2148481 | 2022-01-25 | Unknown | Connecticut | 2627 | 0 | |
2148486 | 2148486 | 2022-01-25 | Unknown | Delaware | 879 | 0 | |
2148551 | 2148551 | 2022-01-25 | Unknown | Florida | 102192 | 847 | |
2148700 | 2148700 | 2022-01-25 | Unknown | Georgia | 11708 | 12 | |
2148716 | 2148716 | 2022-01-25 | Unknown | Guam | 28838 | 281 | |
2148722 | 2148722 | 2022-01-25 | Unknown | Hawaii | 0 | 8 | |
2148858 | 2148858 | 2022-01-25 | Unknown | Illinois | 0 | 1625 | |
2149050 | 2149050 | 2022-01-25 | Unknown | Iowa | 24298 | 0 | |
2149343 | 2149343 | 2022-01-25 | Unknown | Louisiana | 884 | 0 | |
2149365 | 2149365 | 2022-01-25 | Unknown | Maine | 5 | 0 | |
2149390 | 2149390 | 2022-01-25 | Unknown | Maryland | 1157 | 314 | |
2149407 | 2149407 | 2022-01-25 | Unknown | Massachusetts | 124284 | 20 | |
2149488 | 2149488 | 2022-01-25 | Unknown | Michigan | 7214 | 23 | |
2149571 | 2149571 | 2022-01-25 | Unknown | Minnesota | 15836 | 140 | |
2149923 | 2149923 | 2022-01-25 | Unknown | Nebraska | 2886 | 333 | |
2149957 | 2149957 | 2022-01-25 | Unknown | New Hampshire | 7990 | 21 | |
2149978 | 2149978 | 2022-01-25 | Unknown | New Jersey | 3242 | 0 | |
2150220 | 2150220 | 2022-01-25 | Unknown | North Dakota | 47 | 47 | |
2150228 | 2150228 | 2022-01-25 | Unknown | Northern Mariana Islands | 225 | 1 | |
2150309 | 2150309 | 2022-01-25 | Unknown | Ohio | 0 | 5 | |
2150390 | 2150390 | 2022-01-25 | Unknown | Oklahoma | 86217 | 3 | |
2150570 | 2150570 | 2022-01-25 | Unknown | Puerto Rico | 15711 | 3731 | |
2150582 | 2150582 | 2022-01-25 | Unknown | Rhode Island | 47693 | 82 | |
2150783 | 2150783 | 2022-01-25 | Unknown | Tennessee | 120934 | 586 | |
2151021 | 2151021 | 2022-01-25 | Unknown | Texas | 11858 | 0 | |
2151071 | 2151071 | 2022-01-25 | Unknown | Utah | 3317 | 58 | |
2151088 | 2151088 | 2022-01-25 | Unknown | Vermont | 11747 | 4 |
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);