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 591
- New Jersey 580
- Puerto Rico 579
- Guam 576
- Massachusetts 575
- Louisiana 572
- Arkansas 571
- Georgia 570
- Vermont 569
- Minnesota 565
- Michigan 564
- Utah 562
- Connecticut 561
- Florida 558
- Delaware 548
- Maryland 547
- Iowa 529
- New Hampshire 522
- North Dakota 504
- Tennessee 498
- Alaska 491
- Illinois 453
- Oklahoma 427
- Maine 394
- Nebraska 306
- Ohio 226
- Kansas 210
- Northern Mariana Islands 201
- Washington 170
- Virgin Islands 149
- …
fips 1
- - 14,860
county 1
- Unknown · 14,860 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1808626 | 1808626 | 2021-10-12 | Unknown | Nebraska | 1666 | 108 | |
1808660 | 1808660 | 2021-10-12 | Unknown | New Hampshire | 928 | 1 | |
1808681 | 1808681 | 2021-10-12 | Unknown | New Jersey | 654 | 0 | |
1808923 | 1808923 | 2021-10-12 | Unknown | North Dakota | 34 | 34 | |
1809010 | 1809010 | 2021-10-12 | Unknown | Ohio | 0 | 5 | |
1809091 | 1809091 | 2021-10-12 | Unknown | Oklahoma | 9505 | 0 | |
1809271 | 1809271 | 2021-10-12 | Unknown | Puerto Rico | 5405 | 3193 | |
1809283 | 1809283 | 2021-10-12 | Unknown | Rhode Island | 14078 | 21 | |
1809484 | 1809484 | 2021-10-12 | Unknown | Tennessee | 8482 | 117 | |
1809771 | 1809771 | 2021-10-12 | Unknown | Utah | 1782 | 38 | |
1809788 | 1809788 | 2021-10-12 | Unknown | Vermont | 60 | 0 | |
1803707 | 1803707 | 2021-10-11 | Unknown | Alaska | 502 | 1 | |
1803712 | 1803712 | 2021-10-11 | Unknown | American Samoa | 3 | 0 | |
1803798 | 1803798 | 2021-10-11 | Unknown | Arkansas | 5108 | 0 | |
1803933 | 1803933 | 2021-10-11 | Unknown | Connecticut | 1340 | 11 | |
1803938 | 1803938 | 2021-10-11 | Unknown | Delaware | 371 | 0 | |
1804003 | 1804003 | 2021-10-11 | Unknown | Florida | 3092 | 1367 | |
1804152 | 1804152 | 2021-10-11 | Unknown | Georgia | 4615 | 8 | |
1804168 | 1804168 | 2021-10-11 | Unknown | Guam | 17245 | 215 | |
1804174 | 1804174 | 2021-10-11 | Unknown | Hawaii | 0 | 2 | |
1804310 | 1804310 | 2021-10-11 | Unknown | Illinois | 0 | 714 | |
1804502 | 1804502 | 2021-10-11 | Unknown | Iowa | 3085 | 0 | |
1804795 | 1804795 | 2021-10-11 | Unknown | Louisiana | 570 | 0 | |
1804817 | 1804817 | 2021-10-11 | Unknown | Maine | 2 | 0 | |
1804842 | 1804842 | 2021-10-11 | Unknown | Maryland | 0 | 76 | |
1804859 | 1804859 | 2021-10-11 | Unknown | Massachusetts | 55997 | 13 | |
1804940 | 1804940 | 2021-10-11 | Unknown | Michigan | 1032 | 14 | |
1805023 | 1805023 | 2021-10-11 | Unknown | Minnesota | 652 | 113 | |
1805375 | 1805375 | 2021-10-11 | Unknown | Nebraska | 2936 | 115 | |
1805409 | 1805409 | 2021-10-11 | Unknown | New Hampshire | 981 | 1 | |
1805430 | 1805430 | 2021-10-11 | Unknown | New Jersey | 632 | 0 | |
1805672 | 1805672 | 2021-10-11 | Unknown | North Dakota | 34 | 34 | |
1805679 | 1805679 | 2021-10-11 | Unknown | Northern Mariana Islands | 4 | 1 | |
1805760 | 1805760 | 2021-10-11 | Unknown | Ohio | 0 | 5 | |
1805841 | 1805841 | 2021-10-11 | Unknown | Oklahoma | 8880 | 0 | |
1806021 | 1806021 | 2021-10-11 | Unknown | Puerto Rico | 5405 | 3192 | |
1806033 | 1806033 | 2021-10-11 | Unknown | Rhode Island | 13161 | 19 | |
1806234 | 1806234 | 2021-10-11 | Unknown | Tennessee | 8126 | 117 | |
1806521 | 1806521 | 2021-10-11 | Unknown | Utah | 1695 | 35 | |
1806538 | 1806538 | 2021-10-11 | Unknown | Vermont | 25 | 0 | |
1806668 | 1806668 | 2021-10-11 | Unknown | Virginia | 5448 | 100 | |
1800458 | 1800458 | 2021-10-10 | Unknown | Alaska | 503 | 1 | |
1800463 | 1800463 | 2021-10-10 | Unknown | American Samoa | 3 | 0 | |
1800549 | 1800549 | 2021-10-10 | Unknown | Arkansas | 5100 | 0 | |
1800684 | 1800684 | 2021-10-10 | Unknown | Connecticut | 1340 | 11 | |
1800689 | 1800689 | 2021-10-10 | Unknown | Delaware | 368 | 0 | |
1800754 | 1800754 | 2021-10-10 | Unknown | Florida | 3092 | 1367 | |
1800903 | 1800903 | 2021-10-10 | Unknown | Georgia | 4615 | 8 | |
1800919 | 1800919 | 2021-10-10 | Unknown | Guam | 17027 | 213 | |
1800925 | 1800925 | 2021-10-10 | Unknown | Hawaii | 0 | 2 | |
1801061 | 1801061 | 2021-10-10 | Unknown | Illinois | 0 | 714 | |
1801253 | 1801253 | 2021-10-10 | Unknown | Iowa | 3085 | 0 | |
1801546 | 1801546 | 2021-10-10 | Unknown | Louisiana | 566 | 0 | |
1801568 | 1801568 | 2021-10-10 | Unknown | Maine | 2 | 0 | |
1801593 | 1801593 | 2021-10-10 | Unknown | Maryland | 0 | 72 | |
1801610 | 1801610 | 2021-10-10 | Unknown | Massachusetts | 55997 | 13 | |
1801691 | 1801691 | 2021-10-10 | Unknown | Michigan | 938 | 14 | |
1801774 | 1801774 | 2021-10-10 | Unknown | Minnesota | 648 | 113 | |
1802126 | 1802126 | 2021-10-10 | Unknown | Nebraska | 1697 | 116 | |
1802160 | 1802160 | 2021-10-10 | Unknown | New Hampshire | 898 | 1 | |
1802181 | 1802181 | 2021-10-10 | Unknown | New Jersey | 631 | 0 | |
1802423 | 1802423 | 2021-10-10 | Unknown | North Dakota | 34 | 34 | |
1802510 | 1802510 | 2021-10-10 | Unknown | Ohio | 0 | 5 | |
1802591 | 1802591 | 2021-10-10 | Unknown | Oklahoma | 3991 | 0 | |
1802771 | 1802771 | 2021-10-10 | Unknown | Puerto Rico | 5391 | 3191 | |
1802783 | 1802783 | 2021-10-10 | Unknown | Rhode Island | 13161 | 19 | |
1802984 | 1802984 | 2021-10-10 | Unknown | Tennessee | 8591 | 118 | |
1803271 | 1803271 | 2021-10-10 | Unknown | Utah | 1695 | 35 | |
1803288 | 1803288 | 2021-10-10 | Unknown | Vermont | 29 | 0 | |
1797209 | 1797209 | 2021-10-09 | Unknown | Alaska | 503 | 1 | |
1797214 | 1797214 | 2021-10-09 | Unknown | American Samoa | 3 | 0 | |
1797300 | 1797300 | 2021-10-09 | Unknown | Arkansas | 5114 | 0 | |
1797435 | 1797435 | 2021-10-09 | Unknown | Connecticut | 1340 | 11 | |
1797440 | 1797440 | 2021-10-09 | Unknown | Delaware | 364 | 0 | |
1797505 | 1797505 | 2021-10-09 | Unknown | Florida | 3092 | 1367 | |
1797654 | 1797654 | 2021-10-09 | Unknown | Georgia | 4615 | 8 | |
1797670 | 1797670 | 2021-10-09 | Unknown | Guam | 17027 | 213 | |
1797676 | 1797676 | 2021-10-09 | Unknown | Hawaii | 0 | 2 | |
1797812 | 1797812 | 2021-10-09 | Unknown | Illinois | 0 | 714 | |
1798004 | 1798004 | 2021-10-09 | Unknown | Iowa | 3085 | 0 | |
1798297 | 1798297 | 2021-10-09 | Unknown | Louisiana | 566 | 0 | |
1798319 | 1798319 | 2021-10-09 | Unknown | Maine | 2 | 0 | |
1798344 | 1798344 | 2021-10-09 | Unknown | Maryland | 0 | 68 | |
1798361 | 1798361 | 2021-10-09 | Unknown | Massachusetts | 55997 | 13 | |
1798442 | 1798442 | 2021-10-09 | Unknown | Michigan | 938 | 14 | |
1798525 | 1798525 | 2021-10-09 | Unknown | Minnesota | 648 | 113 | |
1798877 | 1798877 | 2021-10-09 | Unknown | Nebraska | 1697 | 116 | |
1798911 | 1798911 | 2021-10-09 | Unknown | New Hampshire | 898 | 1 | |
1798932 | 1798932 | 2021-10-09 | Unknown | New Jersey | 624 | 0 | |
1799174 | 1799174 | 2021-10-09 | Unknown | North Dakota | 34 | 34 | |
1799261 | 1799261 | 2021-10-09 | Unknown | Ohio | 0 | 5 | |
1799342 | 1799342 | 2021-10-09 | Unknown | Oklahoma | 3991 | 0 | |
1799522 | 1799522 | 2021-10-09 | Unknown | Puerto Rico | 5391 | 3189 | |
1799534 | 1799534 | 2021-10-09 | Unknown | Rhode Island | 13161 | 19 | |
1799735 | 1799735 | 2021-10-09 | Unknown | Tennessee | 8733 | 118 | |
1800022 | 1800022 | 2021-10-09 | Unknown | Utah | 1695 | 35 | |
1800039 | 1800039 | 2021-10-09 | Unknown | Vermont | 37 | 0 | |
1793960 | 1793960 | 2021-10-08 | Unknown | Alaska | 503 | 1 | |
1793965 | 1793965 | 2021-10-08 | Unknown | American Samoa | 3 | 0 | |
1794051 | 1794051 | 2021-10-08 | Unknown | Arkansas | 5092 | 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);