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 321
- New Jersey 310
- Puerto Rico 309
- Guam 307
- Massachusetts 306
- Louisiana 304
- Arkansas 301
- Georgia 301
- Vermont 299
- Minnesota 296
- Michigan 295
- Connecticut 292
- Utah 292
- Florida 289
- Delaware 279
- Maryland 278
- Iowa 260
- New Hampshire 252
- Maine 251
- North Dakota 234
- Tennessee 228
- Alaska 221
- Illinois 198
- Washington 170
- Nebraska 161
- Oklahoma 158
- Northern Mariana Islands 146
- Wisconsin 133
- Virgin Islands 131
- Kansas 118
- …
fips 1
- - 7,847
county 1
- Unknown · 7,847 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930489 | 930489 | 2021-01-15 | Unknown | Connecticut | 819 | 4 | |
930494 | 930494 | 2021-01-15 | Unknown | Delaware | 158 | 0 | |
930559 | 930559 | 2021-01-15 | Unknown | Florida | 3279 | 0 | |
930708 | 930708 | 2021-01-15 | Unknown | Georgia | 4057 | 12 | |
930724 | 930724 | 2021-01-15 | Unknown | Guam | 8443 | 126 | |
931056 | 931056 | 2021-01-15 | Unknown | Iowa | 918 | 0 | |
931166 | 931166 | 2021-01-15 | Unknown | Kansas | 0 | 734 | |
931350 | 931350 | 2021-01-15 | Unknown | Louisiana | 417 | 0 | |
931372 | 931372 | 2021-01-15 | Unknown | Maine | 20 | 0 | |
931397 | 931397 | 2021-01-15 | Unknown | Maryland | 0 | 56 | |
931414 | 931414 | 2021-01-15 | Unknown | Massachusetts | 22876 | 8 | |
931495 | 931495 | 2021-01-15 | Unknown | Michigan | 0 | 15 | |
931578 | 931578 | 2021-01-15 | Unknown | Minnesota | 562 | 68 | |
931963 | 931963 | 2021-01-15 | Unknown | New Hampshire | 1001 | 0 | |
931984 | 931984 | 2021-01-15 | Unknown | New Jersey | 1352 | 0 | |
932226 | 932226 | 2021-01-15 | Unknown | North Dakota | 22 | 22 | |
932393 | 932393 | 2021-01-15 | Unknown | Oklahoma | 133 | 0 | |
932573 | 932573 | 2021-01-15 | Unknown | Puerto Rico | 4096 | 1692 | |
932585 | 932585 | 2021-01-15 | Unknown | Rhode Island | 12765 | 84 | |
932786 | 932786 | 2021-01-15 | Unknown | Tennessee | 12414 | 112 | |
933073 | 933073 | 2021-01-15 | Unknown | Utah | 1221 | 2 | |
933090 | 933090 | 2021-01-15 | Unknown | Vermont | 8 | 0 | |
927019 | 927019 | 2021-01-14 | Unknown | Alaska | 217 | 0 | |
927109 | 927109 | 2021-01-14 | Unknown | Arkansas | 2806 | 0 | |
927244 | 927244 | 2021-01-14 | Unknown | Connecticut | 822 | 4 | |
927249 | 927249 | 2021-01-14 | Unknown | Delaware | 157 | 0 | |
927314 | 927314 | 2021-01-14 | Unknown | Florida | 3258 | 0 | |
927463 | 927463 | 2021-01-14 | Unknown | Georgia | 4017 | 11 | |
927479 | 927479 | 2021-01-14 | Unknown | Guam | 8426 | 125 | |
927811 | 927811 | 2021-01-14 | Unknown | Iowa | 937 | 0 | |
927921 | 927921 | 2021-01-14 | Unknown | Kansas | 0 | 620 | |
928105 | 928105 | 2021-01-14 | Unknown | Louisiana | 415 | 0 | |
928127 | 928127 | 2021-01-14 | Unknown | Maine | 13 | 0 | |
928152 | 928152 | 2021-01-14 | Unknown | Maryland | 0 | 59 | |
928169 | 928169 | 2021-01-14 | Unknown | Massachusetts | 22400 | 8 | |
928250 | 928250 | 2021-01-14 | Unknown | Michigan | 0 | 15 | |
928333 | 928333 | 2021-01-14 | Unknown | Minnesota | 503 | 68 | |
928718 | 928718 | 2021-01-14 | Unknown | New Hampshire | 1051 | 0 | |
928739 | 928739 | 2021-01-14 | Unknown | New Jersey | 1368 | 0 | |
928981 | 928981 | 2021-01-14 | Unknown | North Dakota | 7 | 7 | |
929148 | 929148 | 2021-01-14 | Unknown | Oklahoma | 117 | 0 | |
929328 | 929328 | 2021-01-14 | Unknown | Puerto Rico | 4051 | 1679 | |
929340 | 929340 | 2021-01-14 | Unknown | Rhode Island | 11708 | 75 | |
929541 | 929541 | 2021-01-14 | Unknown | Tennessee | 12347 | 110 | |
929828 | 929828 | 2021-01-14 | Unknown | Utah | 1086 | 2 | |
929845 | 929845 | 2021-01-14 | Unknown | Vermont | 8 | 0 | |
923773 | 923773 | 2021-01-13 | Unknown | Alaska | 212 | 0 | |
923863 | 923863 | 2021-01-13 | Unknown | Arkansas | 2681 | 0 | |
923998 | 923998 | 2021-01-13 | Unknown | Connecticut | 829 | 3 | |
924003 | 924003 | 2021-01-13 | Unknown | Delaware | 155 | 0 | |
924068 | 924068 | 2021-01-13 | Unknown | Florida | 3241 | 0 | |
924217 | 924217 | 2021-01-13 | Unknown | Georgia | 4098 | 9 | |
924233 | 924233 | 2021-01-13 | Unknown | Guam | 8413 | 125 | |
924565 | 924565 | 2021-01-13 | Unknown | Iowa | 920 | 0 | |
924675 | 924675 | 2021-01-13 | Unknown | Kansas | 0 | 638 | |
924859 | 924859 | 2021-01-13 | Unknown | Louisiana | 408 | 0 | |
924881 | 924881 | 2021-01-13 | Unknown | Maine | 26 | 0 | |
924906 | 924906 | 2021-01-13 | Unknown | Maryland | 0 | 56 | |
924923 | 924923 | 2021-01-13 | Unknown | Massachusetts | 22030 | 8 | |
925004 | 925004 | 2021-01-13 | Unknown | Michigan | 8855 | 46 | |
925087 | 925087 | 2021-01-13 | Unknown | Minnesota | 497 | 68 | |
925472 | 925472 | 2021-01-13 | Unknown | New Hampshire | 1066 | 0 | |
925493 | 925493 | 2021-01-13 | Unknown | New Jersey | 1413 | 0 | |
925527 | 925527 | 2021-01-13 | Unknown | New Mexico | 56 | 0 | |
925736 | 925736 | 2021-01-13 | Unknown | North Dakota | 7 | 7 | |
925903 | 925903 | 2021-01-13 | Unknown | Oklahoma | 115 | 0 | |
926083 | 926083 | 2021-01-13 | Unknown | Puerto Rico | 4055 | 1659 | |
926095 | 926095 | 2021-01-13 | Unknown | Rhode Island | 10807 | 66 | |
926296 | 926296 | 2021-01-13 | Unknown | Tennessee | 12742 | 119 | |
926583 | 926583 | 2021-01-13 | Unknown | Utah | 2379 | 16 | |
926600 | 926600 | 2021-01-13 | Unknown | Vermont | 8 | 0 | |
920528 | 920528 | 2021-01-12 | Unknown | Alaska | 343 | 0 | |
920618 | 920618 | 2021-01-12 | Unknown | Arkansas | 2705 | 0 | |
920753 | 920753 | 2021-01-12 | Unknown | Connecticut | 803 | 2 | |
920758 | 920758 | 2021-01-12 | Unknown | Delaware | 154 | 0 | |
920823 | 920823 | 2021-01-12 | Unknown | Florida | 3184 | 0 | |
920972 | 920972 | 2021-01-12 | Unknown | Georgia | 4049 | 9 | |
920988 | 920988 | 2021-01-12 | Unknown | Guam | 8398 | 125 | |
921320 | 921320 | 2021-01-12 | Unknown | Iowa | 861 | 0 | |
921430 | 921430 | 2021-01-12 | Unknown | Kansas | 0 | 584 | |
921614 | 921614 | 2021-01-12 | Unknown | Louisiana | 410 | 0 | |
921636 | 921636 | 2021-01-12 | Unknown | Maine | 16 | 0 | |
921661 | 921661 | 2021-01-12 | Unknown | Maryland | 0 | 70 | |
921678 | 921678 | 2021-01-12 | Unknown | Massachusetts | 21304 | 8 | |
921759 | 921759 | 2021-01-12 | Unknown | Michigan | 8830 | 46 | |
921842 | 921842 | 2021-01-12 | Unknown | Minnesota | 546 | 68 | |
922227 | 922227 | 2021-01-12 | Unknown | New Hampshire | 1053 | 0 | |
922248 | 922248 | 2021-01-12 | Unknown | New Jersey | 1421 | 0 | |
922490 | 922490 | 2021-01-12 | Unknown | North Dakota | 8 | 8 | |
922657 | 922657 | 2021-01-12 | Unknown | Oklahoma | 99 | 0 | |
922837 | 922837 | 2021-01-12 | Unknown | Puerto Rico | 4052 | 1645 | |
922849 | 922849 | 2021-01-12 | Unknown | Rhode Island | 16867 | 120 | |
923050 | 923050 | 2021-01-12 | Unknown | Tennessee | 12463 | 105 | |
923337 | 923337 | 2021-01-12 | Unknown | Utah | 822 | 2 | |
923354 | 923354 | 2021-01-12 | Unknown | Vermont | 8 | 0 | |
917283 | 917283 | 2021-01-11 | Unknown | Alaska | 211 | 0 | |
917373 | 917373 | 2021-01-11 | Unknown | Arkansas | 2829 | 0 | |
917508 | 917508 | 2021-01-11 | Unknown | Connecticut | 779 | 1 | |
917513 | 917513 | 2021-01-11 | Unknown | Delaware | 154 | 0 | |
917578 | 917578 | 2021-01-11 | Unknown | Florida | 3176 | 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);