ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where county = "Unknown" and "date" is on date 2021-06-06 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 24
- Alaska 1
- Arkansas 1
- Connecticut 1
- Delaware 1
- Florida 1
- Georgia 1
- Guam 1
- Illinois 1
- Iowa 1
- Louisiana 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- New Hampshire 1
- New Jersey 1
- North Dakota 1
- Ohio 1
- Oklahoma 1
- Puerto Rico 1
- Rhode Island 1
- Tennessee 1
- Utah 1
- Vermont 1
fips 1
- - 24
county 1
- Unknown · 24 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1391256 | 1391256 | 2021-06-06 | Unknown | Alaska | 292 | 0 | |
1391346 | 1391346 | 2021-06-06 | Unknown | Arkansas | 2914 | 0 | |
1391481 | 1391481 | 2021-06-06 | Unknown | Connecticut | 1183 | 1 | |
1391486 | 1391486 | 2021-06-06 | Unknown | Delaware | 226 | 0 | |
1391551 | 1391551 | 2021-06-06 | Unknown | Florida | 56 | 13 | |
1391700 | 1391700 | 2021-06-06 | Unknown | Georgia | 3090 | 5 | |
1391716 | 1391716 | 2021-06-06 | Unknown | Guam | 9173 | 140 | |
1391857 | 1391857 | 2021-06-06 | Unknown | Illinois | 0 | 382 | |
1392049 | 1392049 | 2021-06-06 | Unknown | Iowa | 948 | 0 | |
1392342 | 1392342 | 2021-06-06 | Unknown | Louisiana | 396 | 0 | |
1392388 | 1392388 | 2021-06-06 | Unknown | Maryland | 1 | 38 | |
1392405 | 1392405 | 2021-06-06 | Unknown | Massachusetts | 47000 | 12 | |
1392486 | 1392486 | 2021-06-06 | Unknown | Michigan | 665 | 15 | |
1392569 | 1392569 | 2021-06-06 | Unknown | Minnesota | 585 | 93 | |
1392954 | 1392954 | 2021-06-06 | Unknown | New Hampshire | 420 | 1 | |
1392975 | 1392975 | 2021-06-06 | Unknown | New Jersey | 832 | 0 | |
1393217 | 1393217 | 2021-06-06 | Unknown | North Dakota | 31 | 31 | |
1393304 | 1393304 | 2021-06-06 | Unknown | Ohio | 0 | 3 | |
1393385 | 1393385 | 2021-06-06 | Unknown | Oklahoma | 366 | 0 | |
1393565 | 1393565 | 2021-06-06 | Unknown | Puerto Rico | 5585 | 2518 | |
1393577 | 1393577 | 2021-06-06 | Unknown | Rhode Island | 12069 | 11 | |
1393778 | 1393778 | 2021-06-06 | Unknown | Tennessee | 9610 | 125 | |
1394065 | 1394065 | 2021-06-06 | Unknown | Utah | 1222 | 22 | |
1394082 | 1394082 | 2021-06-06 | Unknown | Vermont | 22 | 0 |
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);