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 324
- New Jersey 313
- Puerto Rico 312
- Guam 310
- Massachusetts 309
- Louisiana 307
- Arkansas 305
- Georgia 304
- Vermont 302
- Minnesota 299
- Michigan 298
- Connecticut 295
- Utah 295
- Florida 292
- Delaware 282
- Maryland 281
- Iowa 263
- New Hampshire 255
- Maine 254
- North Dakota 237
- Tennessee 231
- Alaska 224
- Illinois 198
- Washington 170
- Nebraska 161
- Oklahoma 161
- Northern Mariana Islands 146
- Wisconsin 133
- Virgin Islands 131
- Kansas 121
- …
fips 1
- - 7,920
county 1
- Unknown · 7,920 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
940089 | 940089 | 2021-01-18 | Unknown | Arkansas | 2781 | 0 | |
940224 | 940224 | 2021-01-18 | Unknown | Connecticut | 832 | 6 | |
940229 | 940229 | 2021-01-18 | Unknown | Delaware | 164 | 0 | |
940294 | 940294 | 2021-01-18 | Unknown | Florida | 3306 | 0 | |
940443 | 940443 | 2021-01-18 | Unknown | Georgia | 4278 | 14 | |
940459 | 940459 | 2021-01-18 | Unknown | Guam | 8454 | 129 | |
940791 | 940791 | 2021-01-18 | Unknown | Iowa | 923 | 0 | |
940901 | 940901 | 2021-01-18 | Unknown | Kansas | 0 | 720 | |
941085 | 941085 | 2021-01-18 | Unknown | Louisiana | 417 | 0 | |
941107 | 941107 | 2021-01-18 | Unknown | Maine | 3 | 0 | |
941132 | 941132 | 2021-01-18 | Unknown | Maryland | 0 | 61 | |
941149 | 941149 | 2021-01-18 | Unknown | Massachusetts | 23252 | 8 | |
941230 | 941230 | 2021-01-18 | Unknown | Michigan | 0 | 17 | |
941313 | 941313 | 2021-01-18 | Unknown | Minnesota | 509 | 68 | |
941698 | 941698 | 2021-01-18 | Unknown | New Hampshire | 1011 | 1 | |
941719 | 941719 | 2021-01-18 | Unknown | New Jersey | 1409 | 0 | |
941961 | 941961 | 2021-01-18 | Unknown | North Dakota | 22 | 22 | |
942128 | 942128 | 2021-01-18 | Unknown | Oklahoma | 146 | 0 | |
942308 | 942308 | 2021-01-18 | Unknown | Puerto Rico | 4143 | 1703 | |
942320 | 942320 | 2021-01-18 | Unknown | Rhode Island | 12765 | 84 | |
942521 | 942521 | 2021-01-18 | Unknown | Tennessee | 12961 | 107 | |
942808 | 942808 | 2021-01-18 | Unknown | Utah | 1487 | 8 | |
942825 | 942825 | 2021-01-18 | Unknown | Vermont | 8 | 0 | |
936754 | 936754 | 2021-01-17 | Unknown | Alaska | 225 | 0 | |
936844 | 936844 | 2021-01-17 | Unknown | Arkansas | 2792 | 0 | |
936979 | 936979 | 2021-01-17 | Unknown | Connecticut | 819 | 4 | |
936984 | 936984 | 2021-01-17 | Unknown | Delaware | 162 | 0 | |
937049 | 937049 | 2021-01-17 | Unknown | Florida | 3293 | 0 | |
937198 | 937198 | 2021-01-17 | Unknown | Georgia | 4228 | 14 | |
937214 | 937214 | 2021-01-17 | Unknown | Guam | 8453 | 128 | |
937546 | 937546 | 2021-01-17 | Unknown | Iowa | 916 | 0 | |
937656 | 937656 | 2021-01-17 | Unknown | Kansas | 0 | 713 | |
937840 | 937840 | 2021-01-17 | Unknown | Louisiana | 414 | 0 | |
937862 | 937862 | 2021-01-17 | Unknown | Maine | 3 | 0 | |
937887 | 937887 | 2021-01-17 | Unknown | Maryland | 0 | 76 | |
937904 | 937904 | 2021-01-17 | Unknown | Massachusetts | 23157 | 8 | |
937985 | 937985 | 2021-01-17 | Unknown | Michigan | 0 | 17 | |
938068 | 938068 | 2021-01-17 | Unknown | Minnesota | 504 | 68 | |
938453 | 938453 | 2021-01-17 | Unknown | New Hampshire | 992 | 1 | |
938474 | 938474 | 2021-01-17 | Unknown | New Jersey | 1376 | 0 | |
938716 | 938716 | 2021-01-17 | Unknown | North Dakota | 22 | 22 | |
938883 | 938883 | 2021-01-17 | Unknown | Oklahoma | 144 | 0 | |
939063 | 939063 | 2021-01-17 | Unknown | Puerto Rico | 4137 | 1703 | |
939075 | 939075 | 2021-01-17 | Unknown | Rhode Island | 12765 | 84 | |
939276 | 939276 | 2021-01-17 | Unknown | Tennessee | 13119 | 121 | |
939563 | 939563 | 2021-01-17 | Unknown | Utah | 1410 | 6 | |
939580 | 939580 | 2021-01-17 | Unknown | Vermont | 9 | 0 | |
933509 | 933509 | 2021-01-16 | Unknown | Alaska | 222 | 0 | |
933599 | 933599 | 2021-01-16 | Unknown | Arkansas | 2824 | 0 | |
933734 | 933734 | 2021-01-16 | Unknown | Connecticut | 819 | 4 | |
933739 | 933739 | 2021-01-16 | Unknown | Delaware | 160 | 0 | |
933804 | 933804 | 2021-01-16 | Unknown | Florida | 3287 | 0 | |
933953 | 933953 | 2021-01-16 | Unknown | Georgia | 4118 | 13 | |
933969 | 933969 | 2021-01-16 | Unknown | Guam | 8450 | 127 | |
934301 | 934301 | 2021-01-16 | Unknown | Iowa | 920 | 0 | |
934411 | 934411 | 2021-01-16 | Unknown | Kansas | 0 | 716 | |
934595 | 934595 | 2021-01-16 | Unknown | Louisiana | 417 | 0 | |
934617 | 934617 | 2021-01-16 | Unknown | Maine | 8 | 0 | |
934642 | 934642 | 2021-01-16 | Unknown | Maryland | 0 | 67 | |
934659 | 934659 | 2021-01-16 | Unknown | Massachusetts | 23020 | 8 | |
934740 | 934740 | 2021-01-16 | Unknown | Michigan | 0 | 17 | |
934823 | 934823 | 2021-01-16 | Unknown | Minnesota | 502 | 68 | |
935208 | 935208 | 2021-01-16 | Unknown | New Hampshire | 975 | 1 | |
935229 | 935229 | 2021-01-16 | Unknown | New Jersey | 1329 | 0 | |
935471 | 935471 | 2021-01-16 | Unknown | North Dakota | 22 | 22 | |
935638 | 935638 | 2021-01-16 | Unknown | Oklahoma | 143 | 0 | |
935818 | 935818 | 2021-01-16 | Unknown | Puerto Rico | 4099 | 1703 | |
935830 | 935830 | 2021-01-16 | Unknown | Rhode Island | 12765 | 84 | |
936031 | 936031 | 2021-01-16 | Unknown | Tennessee | 12888 | 121 | |
936318 | 936318 | 2021-01-16 | Unknown | Utah | 1177 | 2 | |
936335 | 936335 | 2021-01-16 | Unknown | Vermont | 8 | 0 | |
930264 | 930264 | 2021-01-15 | Unknown | Alaska | 221 | 0 | |
930354 | 930354 | 2021-01-15 | Unknown | Arkansas | 2846 | 0 | |
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 |
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);