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 53
- Rhode Island 402
- New Jersey 391
- Puerto Rico 390
- Guam 388
- Massachusetts 387
- Louisiana 385
- Arkansas 383
- Georgia 382
- Vermont 380
- Minnesota 377
- Michigan 376
- Connecticut 373
- Utah 373
- Florida 370
- Delaware 360
- Maryland 359
- Iowa 341
- New Hampshire 333
- North Dakota 315
- Tennessee 309
- Alaska 303
- Maine 298
- Illinois 265
- Oklahoma 238
- Kansas 199
- Washington 170
- Nebraska 165
- Northern Mariana Islands 146
- Virgin Islands 134
- Wisconsin 133
- Colorado 64
- New Mexico 61
- Nevada 57
- Kentucky 42
- Missouri 37
- Ohio 37
- Arizona 36
- Virginia 31
- Hawaii 30
- Mississippi 11
- Idaho 10
- New York 10
- California 9
- Indiana 5
- South Dakota 5
- Wyoming 4
- South Carolina 3
- Montana 2
- Pennsylvania 2
- West Virginia 2
- North Carolina 1
- Oregon 1
- Texas 1
fips 1
- - 9,886
county 1
- Unknown · 9,886 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193199 | 1193199 | 2021-04-06 | Unknown | Alaska | 284 | 0 | |
1193289 | 1193289 | 2021-04-06 | Unknown | Arkansas | 2795 | 0 | |
1193424 | 1193424 | 2021-04-06 | Unknown | Connecticut | 1118 | 12 | |
1193429 | 1193429 | 2021-04-06 | Unknown | Delaware | 203 | 0 | |
1193494 | 1193494 | 2021-04-06 | Unknown | Florida | 3588 | 0 | |
1193643 | 1193643 | 2021-04-06 | Unknown | Georgia | 3222 | 12 | |
1193659 | 1193659 | 2021-04-06 | Unknown | Guam | 8794 | 137 | |
1193800 | 1193800 | 2021-04-06 | Unknown | Illinois | 0 | 262 | |
1193992 | 1193992 | 2021-04-06 | Unknown | Iowa | 998 | 0 | |
1194102 | 1194102 | 2021-04-06 | Unknown | Kansas | 0 | 1016 | |
1194286 | 1194286 | 2021-04-06 | Unknown | Louisiana | 419 | 0 | |
1194332 | 1194332 | 2021-04-06 | Unknown | Maryland | 1 | 75 | |
1194349 | 1194349 | 2021-04-06 | Unknown | Massachusetts | 39707 | 12 | |
1194430 | 1194430 | 2021-04-06 | Unknown | Michigan | 0 | 15 | |
1194513 | 1194513 | 2021-04-06 | Unknown | Minnesota | 554 | 78 | |
1194865 | 1194865 | 2021-04-06 | Unknown | Nebraska | 3 | 0 | |
1194899 | 1194899 | 2021-04-06 | Unknown | New Hampshire | 1149 | 6 | |
1194920 | 1194920 | 2021-04-06 | Unknown | New Jersey | 1030 | 0 | |
1195162 | 1195162 | 2021-04-06 | Unknown | North Dakota | 31 | 31 | |
1195249 | 1195249 | 2021-04-06 | Unknown | Ohio | 0 | 1 | |
1195330 | 1195330 | 2021-04-06 | Unknown | Oklahoma | 2289 | 0 | |
1195510 | 1195510 | 2021-04-06 | Unknown | Puerto Rico | 4691 | 2136 | |
1195522 | 1195522 | 2021-04-06 | Unknown | Rhode Island | 14620 | 33 | |
1195723 | 1195723 | 2021-04-06 | Unknown | Tennessee | 8812 | 122 | |
1196010 | 1196010 | 2021-04-06 | Unknown | Utah | 1157 | 1 | |
1196027 | 1196027 | 2021-04-06 | Unknown | Vermont | 12 | 0 | |
1196034 | 1196034 | 2021-04-06 | Unknown | Virgin Islands | 1 | 0 | |
1189949 | 1189949 | 2021-04-05 | Unknown | Alaska | 284 | 0 | |
1190039 | 1190039 | 2021-04-05 | Unknown | Arkansas | 2791 | 0 | |
1190174 | 1190174 | 2021-04-05 | Unknown | Connecticut | 1113 | 11 | |
1190179 | 1190179 | 2021-04-05 | Unknown | Delaware | 204 | 0 | |
1190244 | 1190244 | 2021-04-05 | Unknown | Florida | 3577 | 0 | |
1190393 | 1190393 | 2021-04-05 | Unknown | Georgia | 3219 | 11 | |
1190409 | 1190409 | 2021-04-05 | Unknown | Guam | 8792 | 137 | |
1190550 | 1190550 | 2021-04-05 | Unknown | Illinois | 0 | 265 | |
1190742 | 1190742 | 2021-04-05 | Unknown | Iowa | 1001 | 0 | |
1190852 | 1190852 | 2021-04-05 | Unknown | Kansas | 0 | 1020 | |
1191036 | 1191036 | 2021-04-05 | Unknown | Louisiana | 422 | 0 | |
1191058 | 1191058 | 2021-04-05 | Unknown | Maine | 1 | 0 | |
1191083 | 1191083 | 2021-04-05 | Unknown | Maryland | 1 | 75 | |
1191100 | 1191100 | 2021-04-05 | Unknown | Massachusetts | 39465 | 12 | |
1191181 | 1191181 | 2021-04-05 | Unknown | Michigan | 0 | 13 | |
1191264 | 1191264 | 2021-04-05 | Unknown | Minnesota | 558 | 78 | |
1191616 | 1191616 | 2021-04-05 | Unknown | Nebraska | 3 | 0 | |
1191650 | 1191650 | 2021-04-05 | Unknown | New Hampshire | 1160 | 6 | |
1191671 | 1191671 | 2021-04-05 | Unknown | New Jersey | 1076 | 0 | |
1191705 | 1191705 | 2021-04-05 | Unknown | New Mexico | 1 | 0 | |
1191914 | 1191914 | 2021-04-05 | Unknown | North Dakota | 31 | 31 | |
1192001 | 1192001 | 2021-04-05 | Unknown | Ohio | 0 | 1 | |
1192082 | 1192082 | 2021-04-05 | Unknown | Oklahoma | 2169 | 0 | |
1192262 | 1192262 | 2021-04-05 | Unknown | Puerto Rico | 4691 | 2131 | |
1192274 | 1192274 | 2021-04-05 | Unknown | Rhode Island | 14244 | 30 | |
1192475 | 1192475 | 2021-04-05 | Unknown | Tennessee | 8791 | 121 | |
1192762 | 1192762 | 2021-04-05 | Unknown | Utah | 1214 | 1 | |
1192779 | 1192779 | 2021-04-05 | Unknown | Vermont | 12 | 0 | |
1192786 | 1192786 | 2021-04-05 | Unknown | Virgin Islands | 1 | 0 | |
1186702 | 1186702 | 2021-04-04 | Unknown | Alaska | 277 | 0 | |
1186792 | 1186792 | 2021-04-04 | Unknown | Arkansas | 2798 | 0 | |
1186927 | 1186927 | 2021-04-04 | Unknown | Connecticut | 1103 | 11 | |
1186932 | 1186932 | 2021-04-04 | Unknown | Delaware | 204 | 0 | |
1186997 | 1186997 | 2021-04-04 | Unknown | Florida | 3578 | 0 | |
1187146 | 1187146 | 2021-04-04 | Unknown | Georgia | 3218 | 11 | |
1187162 | 1187162 | 2021-04-04 | Unknown | Guam | 8785 | 137 | |
1187303 | 1187303 | 2021-04-04 | Unknown | Illinois | 0 | 269 | |
1187495 | 1187495 | 2021-04-04 | Unknown | Iowa | 1021 | 0 | |
1187605 | 1187605 | 2021-04-04 | Unknown | Kansas | 0 | 1022 | |
1187789 | 1187789 | 2021-04-04 | Unknown | Louisiana | 422 | 0 | |
1187835 | 1187835 | 2021-04-04 | Unknown | Maryland | 0 | 64 | |
1187852 | 1187852 | 2021-04-04 | Unknown | Massachusetts | 39383 | 12 | |
1187933 | 1187933 | 2021-04-04 | Unknown | Michigan | 0 | 13 | |
1188016 | 1188016 | 2021-04-04 | Unknown | Minnesota | 557 | 78 | |
1188368 | 1188368 | 2021-04-04 | Unknown | Nebraska | 128 | 0 | |
1188402 | 1188402 | 2021-04-04 | Unknown | New Hampshire | 1154 | 6 | |
1188423 | 1188423 | 2021-04-04 | Unknown | New Jersey | 1073 | 0 | |
1188665 | 1188665 | 2021-04-04 | Unknown | North Dakota | 32 | 32 | |
1188752 | 1188752 | 2021-04-04 | Unknown | Ohio | 0 | 1 | |
1188833 | 1188833 | 2021-04-04 | Unknown | Oklahoma | 1296 | 0 | |
1189013 | 1189013 | 2021-04-04 | Unknown | Puerto Rico | 4675 | 2126 | |
1189025 | 1189025 | 2021-04-04 | Unknown | Rhode Island | 13326 | 31 | |
1189226 | 1189226 | 2021-04-04 | Unknown | Tennessee | 8602 | 116 | |
1189513 | 1189513 | 2021-04-04 | Unknown | Utah | 1269 | 1 | |
1189530 | 1189530 | 2021-04-04 | Unknown | Vermont | 12 | 0 | |
1183455 | 1183455 | 2021-04-03 | Unknown | Alaska | 277 | 0 | |
1183545 | 1183545 | 2021-04-03 | Unknown | Arkansas | 2799 | 0 | |
1183680 | 1183680 | 2021-04-03 | Unknown | Connecticut | 1103 | 11 | |
1183685 | 1183685 | 2021-04-03 | Unknown | Delaware | 204 | 0 | |
1183750 | 1183750 | 2021-04-03 | Unknown | Florida | 3577 | 0 | |
1183899 | 1183899 | 2021-04-03 | Unknown | Georgia | 3214 | 11 | |
1183915 | 1183915 | 2021-04-03 | Unknown | Guam | 8785 | 137 | |
1184056 | 1184056 | 2021-04-03 | Unknown | Illinois | 0 | 262 | |
1184248 | 1184248 | 2021-04-03 | Unknown | Iowa | 1020 | 0 | |
1184358 | 1184358 | 2021-04-03 | Unknown | Kansas | 0 | 1022 | |
1184542 | 1184542 | 2021-04-03 | Unknown | Louisiana | 422 | 0 | |
1184588 | 1184588 | 2021-04-03 | Unknown | Maryland | 0 | 63 | |
1184605 | 1184605 | 2021-04-03 | Unknown | Massachusetts | 39383 | 12 | |
1184686 | 1184686 | 2021-04-03 | Unknown | Michigan | 0 | 13 | |
1184769 | 1184769 | 2021-04-03 | Unknown | Minnesota | 557 | 78 | |
1185121 | 1185121 | 2021-04-03 | Unknown | Nebraska | 124 | 0 | |
1185155 | 1185155 | 2021-04-03 | Unknown | New Hampshire | 1133 | 6 | |
1185176 | 1185176 | 2021-04-03 | Unknown | New Jersey | 1071 | 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);