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 318
- New Jersey 307
- Puerto Rico 306
- Guam 304
- Massachusetts 303
- Louisiana 301
- Arkansas 299
- Georgia 298
- Vermont 296
- Minnesota 293
- Michigan 292
- Connecticut 289
- Utah 289
- Florida 286
- Delaware 276
- Maryland 275
- Iowa 257
- New Hampshire 249
- Maine 248
- North Dakota 231
- Tennessee 225
- Alaska 218
- Illinois 198
- Washington 170
- Nebraska 161
- Oklahoma 155
- Northern Mariana Islands 146
- Wisconsin 133
- Virgin Islands 131
- Kansas 115
- …
fips 1
- - 7,775
county 1
- Unknown · 7,775 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 | |
917727 | 917727 | 2021-01-11 | Unknown | Georgia | 4371 | 8 | |
917743 | 917743 | 2021-01-11 | Unknown | Guam | 8392 | 125 | |
918075 | 918075 | 2021-01-11 | Unknown | Iowa | 857 | 0 | |
918185 | 918185 | 2021-01-11 | Unknown | Kansas | 0 | 628 | |
918369 | 918369 | 2021-01-11 | Unknown | Louisiana | 426 | 0 | |
918391 | 918391 | 2021-01-11 | Unknown | Maine | 13 | 1 | |
918416 | 918416 | 2021-01-11 | Unknown | Maryland | 0 | 51 | |
918433 | 918433 | 2021-01-11 | Unknown | Massachusetts | 20703 | 8 | |
918514 | 918514 | 2021-01-11 | Unknown | Michigan | 8770 | 46 | |
918597 | 918597 | 2021-01-11 | Unknown | Minnesota | 532 | 68 | |
918982 | 918982 | 2021-01-11 | Unknown | New Hampshire | 1020 | 0 | |
919003 | 919003 | 2021-01-11 | Unknown | New Jersey | 1514 | 0 | |
919245 | 919245 | 2021-01-11 | Unknown | North Dakota | 9 | 8 | |
919412 | 919412 | 2021-01-11 | Unknown | Oklahoma | 99 | 0 | |
919592 | 919592 | 2021-01-11 | Unknown | Puerto Rico | 4016 | 1642 | |
919604 | 919604 | 2021-01-11 | Unknown | Rhode Island | 16081 | 97 | |
919805 | 919805 | 2021-01-11 | Unknown | Tennessee | 12547 | 100 | |
920092 | 920092 | 2021-01-11 | Unknown | Utah | 635 | 2 | |
920109 | 920109 | 2021-01-11 | Unknown | Vermont | 8 | 0 | |
914038 | 914038 | 2021-01-10 | Unknown | Alaska | 253 | 0 | |
914128 | 914128 | 2021-01-10 | Unknown | Arkansas | 2766 | 0 | |
914263 | 914263 | 2021-01-10 | Unknown | Connecticut | 770 | 1 | |
914268 | 914268 | 2021-01-10 | Unknown | Delaware | 154 | 0 | |
914333 | 914333 | 2021-01-10 | Unknown | Florida | 3170 | 0 | |
914482 | 914482 | 2021-01-10 | Unknown | Georgia | 4372 | 9 | |
914498 | 914498 | 2021-01-10 | Unknown | Guam | 8381 | 125 | |
914830 | 914830 | 2021-01-10 | Unknown | Iowa | 848 | 0 | |
914940 | 914940 | 2021-01-10 | Unknown | Kansas | 0 | 550 | |
915124 | 915124 | 2021-01-10 | Unknown | Louisiana | 427 | 0 | |
915146 | 915146 | 2021-01-10 | Unknown | Maine | 2 | 0 | |
915171 | 915171 | 2021-01-10 | Unknown | Maryland | 0 | 44 | |
915188 | 915188 | 2021-01-10 | Unknown | Massachusetts | 20700 | 8 | |
915269 | 915269 | 2021-01-10 | Unknown | Michigan | 8663 | 45 | |
915352 | 915352 | 2021-01-10 | Unknown | Minnesota | 514 | 68 | |
915737 | 915737 | 2021-01-10 | Unknown | New Hampshire | 988 | 0 | |
915758 | 915758 | 2021-01-10 | Unknown | New Jersey | 1485 | 0 | |
916000 | 916000 | 2021-01-10 | Unknown | North Dakota | 8 | 8 | |
916167 | 916167 | 2021-01-10 | Unknown | Oklahoma | 100 | 0 | |
916347 | 916347 | 2021-01-10 | Unknown | Puerto Rico | 4016 | 1630 | |
916359 | 916359 | 2021-01-10 | Unknown | Rhode Island | 13088 | 66 | |
916560 | 916560 | 2021-01-10 | Unknown | Tennessee | 12618 | 99 | |
916847 | 916847 | 2021-01-10 | Unknown | Utah | 1177 | 2 | |
916864 | 916864 | 2021-01-10 | Unknown | Vermont | 8 | 0 | |
910793 | 910793 | 2021-01-09 | Unknown | Alaska | 248 | 0 | |
910883 | 910883 | 2021-01-09 | Unknown | Arkansas | 2765 | 0 | |
911018 | 911018 | 2021-01-09 | Unknown | Connecticut | 770 | 1 | |
911023 | 911023 | 2021-01-09 | Unknown | Delaware | 151 | 0 | |
911088 | 911088 | 2021-01-09 | Unknown | Florida | 3166 | 0 | |
911237 | 911237 | 2021-01-09 | Unknown | Georgia | 4264 | 9 | |
911253 | 911253 | 2021-01-09 | Unknown | Guam | 8373 | 125 | |
911585 | 911585 | 2021-01-09 | Unknown | Iowa | 843 | 0 | |
911695 | 911695 | 2021-01-09 | Unknown | Kansas | 0 | 552 | |
911879 | 911879 | 2021-01-09 | Unknown | Louisiana | 421 | 0 | |
911901 | 911901 | 2021-01-09 | Unknown | Maine | 11 | 0 | |
911926 | 911926 | 2021-01-09 | Unknown | Maryland | 1 | 44 | |
911943 | 911943 | 2021-01-09 | Unknown | Massachusetts | 20405 | 8 | |
912024 | 912024 | 2021-01-09 | Unknown | Michigan | 8663 | 45 | |
912107 | 912107 | 2021-01-09 | Unknown | Minnesota | 500 | 68 | |
912492 | 912492 | 2021-01-09 | Unknown | New Hampshire | 973 | 0 | |
912513 | 912513 | 2021-01-09 | Unknown | New Jersey | 1417 | 0 | |
912755 | 912755 | 2021-01-09 | Unknown | North Dakota | 8 | 8 | |
912922 | 912922 | 2021-01-09 | Unknown | Oklahoma | 101 | 0 | |
913102 | 913102 | 2021-01-09 | Unknown | Puerto Rico | 4019 | 1616 | |
913114 | 913114 | 2021-01-09 | Unknown | Rhode Island | 13088 | 66 | |
913315 | 913315 | 2021-01-09 | Unknown | Tennessee | 11506 | 89 | |
913602 | 913602 | 2021-01-09 | Unknown | Utah | 942 | 2 | |
913619 | 913619 | 2021-01-09 | Unknown | Vermont | 9 | 0 | |
907548 | 907548 | 2021-01-08 | Unknown | Alaska | 245 | 0 | |
907638 | 907638 | 2021-01-08 | Unknown | Arkansas | 2743 | 0 | |
907773 | 907773 | 2021-01-08 | Unknown | Connecticut | 770 | 1 | |
907778 | 907778 | 2021-01-08 | Unknown | Delaware | 148 | 0 | |
907843 | 907843 | 2021-01-08 | Unknown | Florida | 3157 | 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);