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 399
- New Jersey 387
- Puerto Rico 387
- Guam 384
- Massachusetts 383
- Louisiana 381
- Arkansas 379
- Georgia 378
- Vermont 377
- Minnesota 373
- Michigan 372
- Utah 370
- Connecticut 369
- Florida 366
- Delaware 356
- Maryland 355
- Iowa 337
- New Hampshire 329
- North Dakota 312
- Tennessee 306
- Alaska 299
- Maine 297
- Illinois 261
- Oklahoma 235
- Kansas 195
- Washington 170
- Nebraska 161
- Northern Mariana Islands 146
- Wisconsin 133
- Virgin Islands 132
- …
fips 1
- - 9,786
county 1
- Unknown · 9,786 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1185418 | 1185418 | 2021-04-03 | Unknown | North Dakota | 32 | 32 | |
1185505 | 1185505 | 2021-04-03 | Unknown | Ohio | 0 | 1 | |
1185586 | 1185586 | 2021-04-03 | Unknown | Oklahoma | 1296 | 0 | |
1185766 | 1185766 | 2021-04-03 | Unknown | Puerto Rico | 4649 | 2126 | |
1185778 | 1185778 | 2021-04-03 | Unknown | Rhode Island | 13326 | 31 | |
1185979 | 1185979 | 2021-04-03 | Unknown | Tennessee | 8692 | 116 | |
1186266 | 1186266 | 2021-04-03 | Unknown | Utah | 1269 | 1 | |
1186283 | 1186283 | 2021-04-03 | Unknown | Vermont | 12 | 0 | |
1180208 | 1180208 | 2021-04-02 | Unknown | Alaska | 277 | 0 | |
1180298 | 1180298 | 2021-04-02 | Unknown | Arkansas | 2803 | 0 | |
1180433 | 1180433 | 2021-04-02 | Unknown | Connecticut | 1103 | 11 | |
1180438 | 1180438 | 2021-04-02 | Unknown | Delaware | 205 | 0 | |
1180503 | 1180503 | 2021-04-02 | Unknown | Florida | 3569 | 0 | |
1180652 | 1180652 | 2021-04-02 | Unknown | Georgia | 3237 | 11 | |
1180668 | 1180668 | 2021-04-02 | Unknown | Guam | 8781 | 137 | |
1180809 | 1180809 | 2021-04-02 | Unknown | Illinois | 0 | 265 | |
1181001 | 1181001 | 2021-04-02 | Unknown | Iowa | 1016 | 0 | |
1181111 | 1181111 | 2021-04-02 | Unknown | Kansas | 0 | 1022 | |
1181295 | 1181295 | 2021-04-02 | Unknown | Louisiana | 422 | 0 | |
1181317 | 1181317 | 2021-04-02 | Unknown | Maine | 2 | 0 | |
1181342 | 1181342 | 2021-04-02 | Unknown | Maryland | 0 | 58 | |
1181359 | 1181359 | 2021-04-02 | Unknown | Massachusetts | 39220 | 12 | |
1181440 | 1181440 | 2021-04-02 | Unknown | Michigan | 0 | 12 | |
1181523 | 1181523 | 2021-04-02 | Unknown | Minnesota | 576 | 78 | |
1181908 | 1181908 | 2021-04-02 | Unknown | New Hampshire | 1181 | 6 | |
1181929 | 1181929 | 2021-04-02 | Unknown | New Jersey | 1081 | 0 | |
1182171 | 1182171 | 2021-04-02 | Unknown | North Dakota | 32 | 32 | |
1182258 | 1182258 | 2021-04-02 | Unknown | Ohio | 0 | 1 | |
1182339 | 1182339 | 2021-04-02 | Unknown | Oklahoma | 1296 | 0 | |
1182519 | 1182519 | 2021-04-02 | Unknown | Puerto Rico | 4629 | 2121 | |
1182531 | 1182531 | 2021-04-02 | Unknown | Rhode Island | 13326 | 31 | |
1182732 | 1182732 | 2021-04-02 | Unknown | Tennessee | 8776 | 120 | |
1183019 | 1183019 | 2021-04-02 | Unknown | Utah | 1158 | 1 | |
1183036 | 1183036 | 2021-04-02 | Unknown | Vermont | 11 | 0 | |
1176961 | 1176961 | 2021-04-01 | Unknown | Alaska | 275 | 0 | |
1177051 | 1177051 | 2021-04-01 | Unknown | Arkansas | 2796 | 0 | |
1177186 | 1177186 | 2021-04-01 | Unknown | Connecticut | 1099 | 11 | |
1177191 | 1177191 | 2021-04-01 | Unknown | Delaware | 206 | 0 | |
1177256 | 1177256 | 2021-04-01 | Unknown | Florida | 3568 | 0 | |
1177405 | 1177405 | 2021-04-01 | Unknown | Georgia | 3268 | 11 | |
1177421 | 1177421 | 2021-04-01 | Unknown | Guam | 8779 | 135 | |
1177562 | 1177562 | 2021-04-01 | Unknown | Illinois | 0 | 263 | |
1177754 | 1177754 | 2021-04-01 | Unknown | Iowa | 1015 | 0 | |
1177864 | 1177864 | 2021-04-01 | Unknown | Kansas | 0 | 1013 | |
1178048 | 1178048 | 2021-04-01 | Unknown | Louisiana | 422 | 0 | |
1178070 | 1178070 | 2021-04-01 | Unknown | Maine | 1 | 0 | |
1178095 | 1178095 | 2021-04-01 | Unknown | Maryland | 0 | 57 | |
1178112 | 1178112 | 2021-04-01 | Unknown | Massachusetts | 38934 | 12 | |
1178193 | 1178193 | 2021-04-01 | Unknown | Michigan | 0 | 12 | |
1178276 | 1178276 | 2021-04-01 | Unknown | Minnesota | 584 | 78 | |
1178661 | 1178661 | 2021-04-01 | Unknown | New Hampshire | 1106 | 6 | |
1178682 | 1178682 | 2021-04-01 | Unknown | New Jersey | 1099 | 0 | |
1178924 | 1178924 | 2021-04-01 | Unknown | North Dakota | 32 | 32 | |
1179011 | 1179011 | 2021-04-01 | Unknown | Ohio | 0 | 1 | |
1179092 | 1179092 | 2021-04-01 | Unknown | Oklahoma | 924 | 0 | |
1179272 | 1179272 | 2021-04-01 | Unknown | Puerto Rico | 4614 | 2118 | |
1179284 | 1179284 | 2021-04-01 | Unknown | Rhode Island | 12919 | 25 | |
1179485 | 1179485 | 2021-04-01 | Unknown | Tennessee | 8916 | 120 | |
1179772 | 1179772 | 2021-04-01 | Unknown | Utah | 1185 | 0 | |
1179789 | 1179789 | 2021-04-01 | Unknown | Vermont | 11 | 0 | |
1173714 | 1173714 | 2021-03-31 | Unknown | Alaska | 440 | 0 | |
1173804 | 1173804 | 2021-03-31 | Unknown | Arkansas | 2791 | 0 | |
1173939 | 1173939 | 2021-03-31 | Unknown | Connecticut | 1089 | 11 | |
1173944 | 1173944 | 2021-03-31 | Unknown | Delaware | 204 | 0 | |
1174009 | 1174009 | 2021-03-31 | Unknown | Florida | 3561 | 0 | |
1174158 | 1174158 | 2021-03-31 | Unknown | Georgia | 3322 | 11 | |
1174174 | 1174174 | 2021-03-31 | Unknown | Guam | 8776 | 135 | |
1174315 | 1174315 | 2021-03-31 | Unknown | Illinois | 0 | 266 | |
1174507 | 1174507 | 2021-03-31 | Unknown | Iowa | 1013 | 0 | |
1174617 | 1174617 | 2021-03-31 | Unknown | Kansas | 0 | 1017 | |
1174801 | 1174801 | 2021-03-31 | Unknown | Louisiana | 418 | 0 | |
1174823 | 1174823 | 2021-03-31 | Unknown | Maine | 1 | 0 | |
1174848 | 1174848 | 2021-03-31 | Unknown | Maryland | 0 | 59 | |
1174865 | 1174865 | 2021-03-31 | Unknown | Massachusetts | 38639 | 12 | |
1174946 | 1174946 | 2021-03-31 | Unknown | Michigan | 0 | 12 | |
1175029 | 1175029 | 2021-03-31 | Unknown | Minnesota | 562 | 78 | |
1175414 | 1175414 | 2021-03-31 | Unknown | New Hampshire | 1165 | 5 | |
1175435 | 1175435 | 2021-03-31 | Unknown | New Jersey | 1052 | 0 | |
1175677 | 1175677 | 2021-03-31 | Unknown | North Dakota | 32 | 32 | |
1175764 | 1175764 | 2021-03-31 | Unknown | Ohio | 0 | 1 | |
1175845 | 1175845 | 2021-03-31 | Unknown | Oklahoma | 511 | 0 | |
1176025 | 1176025 | 2021-03-31 | Unknown | Puerto Rico | 4610 | 2113 | |
1176037 | 1176037 | 2021-03-31 | Unknown | Rhode Island | 12400 | 20 | |
1176238 | 1176238 | 2021-03-31 | Unknown | Tennessee | 8839 | 121 | |
1176525 | 1176525 | 2021-03-31 | Unknown | Utah | 1178 | 0 | |
1176542 | 1176542 | 2021-03-31 | Unknown | Vermont | 12 | 0 | |
1170467 | 1170467 | 2021-03-30 | Unknown | Alaska | 276 | 0 | |
1170557 | 1170557 | 2021-03-30 | Unknown | Arkansas | 2787 | 0 | |
1170692 | 1170692 | 2021-03-30 | Unknown | Connecticut | 1079 | 11 | |
1170697 | 1170697 | 2021-03-30 | Unknown | Delaware | 203 | 0 | |
1170762 | 1170762 | 2021-03-30 | Unknown | Florida | 3552 | 0 | |
1170911 | 1170911 | 2021-03-30 | Unknown | Georgia | 3358 | 12 | |
1170927 | 1170927 | 2021-03-30 | Unknown | Guam | 8774 | 135 | |
1171068 | 1171068 | 2021-03-30 | Unknown | Illinois | 0 | 257 | |
1171260 | 1171260 | 2021-03-30 | Unknown | Iowa | 1017 | 0 | |
1171370 | 1171370 | 2021-03-30 | Unknown | Kansas | 0 | 1014 | |
1171554 | 1171554 | 2021-03-30 | Unknown | Louisiana | 417 | 0 | |
1171576 | 1171576 | 2021-03-30 | Unknown | Maine | 2 | 0 | |
1171601 | 1171601 | 2021-03-30 | Unknown | Maryland | 0 | 59 | |
1171618 | 1171618 | 2021-03-30 | Unknown | Massachusetts | 38389 | 12 |
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);