ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21,401 rows where county = "Unknown" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Rhode Island 199
- New Jersey 188
- Puerto Rico 187
- Guam 185
- Massachusetts 184
- Louisiana 182
- Arkansas 180
- Georgia 179
- Vermont 177
- Minnesota 174
- Michigan 173
- Connecticut 170
- Utah 170
- Florida 167
- Delaware 157
- Maryland 156
- Illinois 146
- Maine 141
- Iowa 138
- New Hampshire 131
- Virgin Islands 131
- Northern Mariana Islands 126
- Tennessee 123
- Nebraska 114
- North Dakota 113
- Alaska 99
- Wisconsin 98
- Washington 78
- Colorado 64
- Nevada 57
- …
fips 1
- - 4,695
county 1
- Unknown · 4,695 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534603 | 534603 | 2020-09-15 | Unknown | Arkansas | 1595 | 0 | |
534737 | 534737 | 2020-09-15 | Unknown | Connecticut | 126 | 0 | |
534742 | 534742 | 2020-09-15 | Unknown | Delaware | 493 | 0 | |
534807 | 534807 | 2020-09-15 | Unknown | Florida | 1556 | 0 | |
534956 | 534956 | 2020-09-15 | Unknown | Georgia | 2415 | 3 | |
534972 | 534972 | 2020-09-15 | Unknown | Guam | 2935 | 29 | |
535112 | 535112 | 2020-09-15 | Unknown | Illinois | 2027 | 230 | |
535304 | 535304 | 2020-09-15 | Unknown | Iowa | 19 | 0 | |
535597 | 535597 | 2020-09-15 | Unknown | Louisiana | 1129 | 170 | |
535643 | 535643 | 2020-09-15 | Unknown | Maryland | 0 | 15 | |
535660 | 535660 | 2020-09-15 | Unknown | Massachusetts | 2311 | 5 | |
535741 | 535741 | 2020-09-15 | Unknown | Michigan | 288 | 4 | |
535824 | 535824 | 2020-09-15 | Unknown | Minnesota | 205 | 52 | |
536171 | 536171 | 2020-09-15 | Unknown | Nebraska | 94 | 0 | |
536204 | 536204 | 2020-09-15 | Unknown | New Hampshire | 1 | 0 | |
536225 | 536225 | 2020-09-15 | Unknown | New Jersey | 301 | 0 | |
536259 | 536259 | 2020-09-15 | Unknown | New Mexico | 4 | 0 | |
536468 | 536468 | 2020-09-15 | Unknown | North Dakota | 3 | 3 | |
536475 | 536475 | 2020-09-15 | Unknown | Northern Mariana Islands | 7 | 0 | |
536636 | 536636 | 2020-09-15 | Unknown | Oklahoma | 56 | 0 | |
536815 | 536815 | 2020-09-15 | Unknown | Puerto Rico | 1277 | 551 | |
536827 | 536827 | 2020-09-15 | Unknown | Rhode Island | 2426 | 29 | |
537028 | 537028 | 2020-09-15 | Unknown | Tennessee | 0 | 5 | |
537312 | 537312 | 2020-09-15 | Unknown | Utah | 19 | 1 | |
537329 | 537329 | 2020-09-15 | Unknown | Vermont | 8 | 0 | |
537503 | 537503 | 2020-09-15 | Unknown | Washington | 2 | 2 | |
537626 | 537626 | 2020-09-15 | Unknown | Wisconsin | 0 | 9 | |
531278 | 531278 | 2020-09-14 | Unknown | Alaska | 43 | 0 | |
531368 | 531368 | 2020-09-14 | Unknown | Arkansas | 1628 | 0 | |
531502 | 531502 | 2020-09-14 | Unknown | Connecticut | 126 | 0 | |
531507 | 531507 | 2020-09-14 | Unknown | Delaware | 470 | 0 | |
531572 | 531572 | 2020-09-14 | Unknown | Florida | 1038 | 0 | |
531721 | 531721 | 2020-09-14 | Unknown | Georgia | 2414 | 3 | |
531737 | 531737 | 2020-09-14 | Unknown | Guam | 2896 | 27 | |
531877 | 531877 | 2020-09-14 | Unknown | Illinois | 2028 | 232 | |
532069 | 532069 | 2020-09-14 | Unknown | Iowa | 13 | 0 | |
532362 | 532362 | 2020-09-14 | Unknown | Louisiana | 1131 | 170 | |
532408 | 532408 | 2020-09-14 | Unknown | Maryland | 0 | 8 | |
532425 | 532425 | 2020-09-14 | Unknown | Massachusetts | 2281 | 5 | |
532506 | 532506 | 2020-09-14 | Unknown | Michigan | 283 | 4 | |
532589 | 532589 | 2020-09-14 | Unknown | Minnesota | 208 | 52 | |
532936 | 532936 | 2020-09-14 | Unknown | Nebraska | 132 | 0 | |
532969 | 532969 | 2020-09-14 | Unknown | New Hampshire | 3 | 0 | |
532990 | 532990 | 2020-09-14 | Unknown | New Jersey | 313 | 0 | |
533232 | 533232 | 2020-09-14 | Unknown | North Dakota | 3 | 3 | |
533239 | 533239 | 2020-09-14 | Unknown | Northern Mariana Islands | 7 | 0 | |
533400 | 533400 | 2020-09-14 | Unknown | Oklahoma | 47 | 0 | |
533579 | 533579 | 2020-09-14 | Unknown | Puerto Rico | 1270 | 542 | |
533591 | 533591 | 2020-09-14 | Unknown | Rhode Island | 2306 | 26 | |
533792 | 533792 | 2020-09-14 | Unknown | Tennessee | 135 | 5 | |
534076 | 534076 | 2020-09-14 | Unknown | Utah | 18 | 1 | |
534093 | 534093 | 2020-09-14 | Unknown | Vermont | 8 | 0 | |
534267 | 534267 | 2020-09-14 | Unknown | Washington | 2 | 2 | |
534390 | 534390 | 2020-09-14 | Unknown | Wisconsin | 0 | 8 | |
528041 | 528041 | 2020-09-13 | Unknown | Alaska | 41 | 0 | |
528131 | 528131 | 2020-09-13 | Unknown | Arkansas | 1641 | 0 | |
528265 | 528265 | 2020-09-13 | Unknown | Connecticut | 107 | 0 | |
528270 | 528270 | 2020-09-13 | Unknown | Delaware | 465 | 0 | |
528335 | 528335 | 2020-09-13 | Unknown | Florida | 1035 | 0 | |
528484 | 528484 | 2020-09-13 | Unknown | Georgia | 2459 | 3 | |
528500 | 528500 | 2020-09-13 | Unknown | Guam | 2832 | 24 | |
528640 | 528640 | 2020-09-13 | Unknown | Illinois | 2027 | 232 | |
528832 | 528832 | 2020-09-13 | Unknown | Iowa | 12 | 0 | |
529125 | 529125 | 2020-09-13 | Unknown | Louisiana | 1131 | 170 | |
529147 | 529147 | 2020-09-13 | Unknown | Maine | 1 | 0 | |
529172 | 529172 | 2020-09-13 | Unknown | Maryland | 0 | 8 | |
529189 | 529189 | 2020-09-13 | Unknown | Massachusetts | 2262 | 5 | |
529270 | 529270 | 2020-09-13 | Unknown | Michigan | 258 | 3 | |
529353 | 529353 | 2020-09-13 | Unknown | Minnesota | 199 | 52 | |
529700 | 529700 | 2020-09-13 | Unknown | Nebraska | 15 | 0 | |
529733 | 529733 | 2020-09-13 | Unknown | New Hampshire | 3 | 0 | |
529754 | 529754 | 2020-09-13 | Unknown | New Jersey | 311 | 0 | |
529788 | 529788 | 2020-09-13 | Unknown | New Mexico | 2 | 0 | |
529997 | 529997 | 2020-09-13 | Unknown | North Dakota | 3 | 3 | |
530004 | 530004 | 2020-09-13 | Unknown | Northern Mariana Islands | 6 | 0 | |
530165 | 530165 | 2020-09-13 | Unknown | Oklahoma | 47 | 0 | |
530344 | 530344 | 2020-09-13 | Unknown | Puerto Rico | 1266 | 539 | |
530356 | 530356 | 2020-09-13 | Unknown | Rhode Island | 2081 | 22 | |
530557 | 530557 | 2020-09-13 | Unknown | Tennessee | 0 | 4 | |
530841 | 530841 | 2020-09-13 | Unknown | Utah | 18 | 1 | |
530858 | 530858 | 2020-09-13 | Unknown | Vermont | 8 | 0 | |
531032 | 531032 | 2020-09-13 | Unknown | Washington | 2 | 2 | |
531155 | 531155 | 2020-09-13 | Unknown | Wisconsin | 0 | 8 | |
524805 | 524805 | 2020-09-12 | Unknown | Alaska | 41 | 0 | |
524895 | 524895 | 2020-09-12 | Unknown | Arkansas | 1544 | 0 | |
525029 | 525029 | 2020-09-12 | Unknown | Connecticut | 107 | 0 | |
525034 | 525034 | 2020-09-12 | Unknown | Delaware | 464 | 0 | |
525099 | 525099 | 2020-09-12 | Unknown | Florida | 1033 | 0 | |
525248 | 525248 | 2020-09-12 | Unknown | Georgia | 2467 | 3 | |
525264 | 525264 | 2020-09-12 | Unknown | Guam | 2832 | 24 | |
525404 | 525404 | 2020-09-12 | Unknown | Illinois | 2027 | 232 | |
525596 | 525596 | 2020-09-12 | Unknown | Iowa | 34 | 0 | |
525889 | 525889 | 2020-09-12 | Unknown | Louisiana | 1125 | 170 | |
525911 | 525911 | 2020-09-12 | Unknown | Maine | 5 | 0 | |
525936 | 525936 | 2020-09-12 | Unknown | Maryland | 0 | 11 | |
525953 | 525953 | 2020-09-12 | Unknown | Massachusetts | 2238 | 5 | |
526034 | 526034 | 2020-09-12 | Unknown | Michigan | 258 | 3 | |
526117 | 526117 | 2020-09-12 | Unknown | Minnesota | 211 | 52 | |
526464 | 526464 | 2020-09-12 | Unknown | Nebraska | 85 | 0 | |
526497 | 526497 | 2020-09-12 | Unknown | New Hampshire | 1 | 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);