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 428
- New Jersey 417
- Puerto Rico 416
- Guam 414
- Massachusetts 413
- Louisiana 411
- Arkansas 409
- Georgia 408
- Vermont 406
- Minnesota 403
- Michigan 402
- Connecticut 399
- Utah 399
- Florida 396
- Delaware 386
- Maryland 385
- Iowa 367
- New Hampshire 359
- North Dakota 341
- Tennessee 335
- Alaska 329
- Maine 323
- Illinois 291
- Oklahoma 264
- Kansas 210
- Nebraska 190
- Washington 170
- Northern Mariana Islands 146
- Virgin Islands 135
- Wisconsin 133
- …
fips 1
- - 10,574
county 1
- Unknown · 10,574 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277634 | 1277634 | 2021-05-02 | Unknown | Alaska | 288 | 0 | |
1277724 | 1277724 | 2021-05-02 | Unknown | Arkansas | 2836 | 0 | |
1277859 | 1277859 | 2021-05-02 | Unknown | Connecticut | 1167 | 0 | |
1277864 | 1277864 | 2021-05-02 | Unknown | Delaware | 218 | 0 | |
1277929 | 1277929 | 2021-05-02 | Unknown | Florida | 3393 | 0 | |
1278078 | 1278078 | 2021-05-02 | Unknown | Georgia | 3214 | 14 | |
1278094 | 1278094 | 2021-05-02 | Unknown | Guam | 8944 | 137 | |
1278235 | 1278235 | 2021-05-02 | Unknown | Illinois | 0 | 318 | |
1278427 | 1278427 | 2021-05-02 | Unknown | Iowa | 1000 | 0 | |
1278720 | 1278720 | 2021-05-02 | Unknown | Louisiana | 411 | 0 | |
1278742 | 1278742 | 2021-05-02 | Unknown | Maine | 14 | 0 | |
1278767 | 1278767 | 2021-05-02 | Unknown | Maryland | 1 | 78 | |
1278784 | 1278784 | 2021-05-02 | Unknown | Massachusetts | 44525 | 12 | |
1278865 | 1278865 | 2021-05-02 | Unknown | Michigan | 352 | 17 | |
1278948 | 1278948 | 2021-05-02 | Unknown | Minnesota | 594 | 93 | |
1279300 | 1279300 | 2021-05-02 | Unknown | Nebraska | 877 | 0 | |
1279334 | 1279334 | 2021-05-02 | Unknown | New Hampshire | 1122 | 5 | |
1279355 | 1279355 | 2021-05-02 | Unknown | New Jersey | 852 | 0 | |
1279597 | 1279597 | 2021-05-02 | Unknown | North Dakota | 31 | 31 | |
1279684 | 1279684 | 2021-05-02 | Unknown | Ohio | 0 | 2 | |
1279765 | 1279765 | 2021-05-02 | Unknown | Oklahoma | 1026 | 0 | |
1279945 | 1279945 | 2021-05-02 | Unknown | Puerto Rico | 5416 | 2313 | |
1279957 | 1279957 | 2021-05-02 | Unknown | Rhode Island | 13086 | 15 | |
1280158 | 1280158 | 2021-05-02 | Unknown | Tennessee | 9010 | 124 | |
1280445 | 1280445 | 2021-05-02 | Unknown | Utah | 1186 | 11 | |
1280462 | 1280462 | 2021-05-02 | Unknown | Vermont | 12 | 0 | |
1274387 | 1274387 | 2021-05-01 | Unknown | Alaska | 288 | 0 | |
1274477 | 1274477 | 2021-05-01 | Unknown | Arkansas | 2827 | 0 | |
1274612 | 1274612 | 2021-05-01 | Unknown | Connecticut | 1167 | 0 | |
1274617 | 1274617 | 2021-05-01 | Unknown | Delaware | 216 | 0 | |
1274682 | 1274682 | 2021-05-01 | Unknown | Florida | 3454 | 0 | |
1274831 | 1274831 | 2021-05-01 | Unknown | Georgia | 3206 | 14 | |
1274847 | 1274847 | 2021-05-01 | Unknown | Guam | 8944 | 137 | |
1274988 | 1274988 | 2021-05-01 | Unknown | Illinois | 0 | 317 | |
1275180 | 1275180 | 2021-05-01 | Unknown | Iowa | 1001 | 0 | |
1275473 | 1275473 | 2021-05-01 | Unknown | Louisiana | 411 | 0 | |
1275495 | 1275495 | 2021-05-01 | Unknown | Maine | 2 | 0 | |
1275520 | 1275520 | 2021-05-01 | Unknown | Maryland | 0 | 75 | |
1275537 | 1275537 | 2021-05-01 | Unknown | Massachusetts | 44422 | 12 | |
1275618 | 1275618 | 2021-05-01 | Unknown | Michigan | 405 | 17 | |
1275701 | 1275701 | 2021-05-01 | Unknown | Minnesota | 581 | 93 | |
1276053 | 1276053 | 2021-05-01 | Unknown | Nebraska | 869 | 0 | |
1276087 | 1276087 | 2021-05-01 | Unknown | New Hampshire | 1116 | 5 | |
1276108 | 1276108 | 2021-05-01 | Unknown | New Jersey | 842 | 0 | |
1276350 | 1276350 | 2021-05-01 | Unknown | North Dakota | 31 | 31 | |
1276437 | 1276437 | 2021-05-01 | Unknown | Ohio | 0 | 2 | |
1276518 | 1276518 | 2021-05-01 | Unknown | Oklahoma | 1026 | 0 | |
1276698 | 1276698 | 2021-05-01 | Unknown | Puerto Rico | 5400 | 2310 | |
1276710 | 1276710 | 2021-05-01 | Unknown | Rhode Island | 13086 | 15 | |
1276911 | 1276911 | 2021-05-01 | Unknown | Tennessee | 9141 | 124 | |
1277198 | 1277198 | 2021-05-01 | Unknown | Utah | 1165 | 11 | |
1277215 | 1277215 | 2021-05-01 | Unknown | Vermont | 12 | 0 | |
1271140 | 1271140 | 2021-04-30 | Unknown | Alaska | 288 | 0 | |
1271230 | 1271230 | 2021-04-30 | Unknown | Arkansas | 2827 | 0 | |
1271365 | 1271365 | 2021-04-30 | Unknown | Connecticut | 1167 | 0 | |
1271370 | 1271370 | 2021-04-30 | Unknown | Delaware | 215 | 0 | |
1271435 | 1271435 | 2021-04-30 | Unknown | Florida | 3497 | 0 | |
1271584 | 1271584 | 2021-04-30 | Unknown | Georgia | 3196 | 14 | |
1271600 | 1271600 | 2021-04-30 | Unknown | Guam | 8933 | 137 | |
1271741 | 1271741 | 2021-04-30 | Unknown | Illinois | 0 | 310 | |
1271933 | 1271933 | 2021-04-30 | Unknown | Iowa | 991 | 0 | |
1272226 | 1272226 | 2021-04-30 | Unknown | Louisiana | 411 | 0 | |
1272248 | 1272248 | 2021-04-30 | Unknown | Maine | 1 | 0 | |
1272273 | 1272273 | 2021-04-30 | Unknown | Maryland | 0 | 71 | |
1272290 | 1272290 | 2021-04-30 | Unknown | Massachusetts | 44228 | 12 | |
1272371 | 1272371 | 2021-04-30 | Unknown | Michigan | 259 | 17 | |
1272454 | 1272454 | 2021-04-30 | Unknown | Minnesota | 607 | 93 | |
1272806 | 1272806 | 2021-04-30 | Unknown | Nebraska | 770 | 0 | |
1272840 | 1272840 | 2021-04-30 | Unknown | New Hampshire | 1107 | 5 | |
1272861 | 1272861 | 2021-04-30 | Unknown | New Jersey | 850 | 0 | |
1273103 | 1273103 | 2021-04-30 | Unknown | North Dakota | 31 | 31 | |
1273190 | 1273190 | 2021-04-30 | Unknown | Ohio | 0 | 2 | |
1273271 | 1273271 | 2021-04-30 | Unknown | Oklahoma | 1026 | 0 | |
1273451 | 1273451 | 2021-04-30 | Unknown | Puerto Rico | 5397 | 2303 | |
1273463 | 1273463 | 2021-04-30 | Unknown | Rhode Island | 13086 | 15 | |
1273664 | 1273664 | 2021-04-30 | Unknown | Tennessee | 9280 | 125 | |
1273951 | 1273951 | 2021-04-30 | Unknown | Utah | 1147 | 11 | |
1273968 | 1273968 | 2021-04-30 | Unknown | Vermont | 12 | 0 | |
1267893 | 1267893 | 2021-04-29 | Unknown | Alaska | 288 | 0 | |
1267983 | 1267983 | 2021-04-29 | Unknown | Arkansas | 2825 | 0 | |
1268118 | 1268118 | 2021-04-29 | Unknown | Connecticut | 1166 | 0 | |
1268123 | 1268123 | 2021-04-29 | Unknown | Delaware | 213 | 0 | |
1268188 | 1268188 | 2021-04-29 | Unknown | Florida | 3500 | 0 | |
1268337 | 1268337 | 2021-04-29 | Unknown | Georgia | 3189 | 12 | |
1268353 | 1268353 | 2021-04-29 | Unknown | Guam | 8928 | 137 | |
1268494 | 1268494 | 2021-04-29 | Unknown | Illinois | 0 | 306 | |
1268686 | 1268686 | 2021-04-29 | Unknown | Iowa | 991 | 0 | |
1268979 | 1268979 | 2021-04-29 | Unknown | Louisiana | 408 | 0 | |
1269001 | 1269001 | 2021-04-29 | Unknown | Maine | 5 | 0 | |
1269026 | 1269026 | 2021-04-29 | Unknown | Maryland | 0 | 62 | |
1269043 | 1269043 | 2021-04-29 | Unknown | Massachusetts | 44080 | 12 | |
1269124 | 1269124 | 2021-04-29 | Unknown | Michigan | 195 | 17 | |
1269207 | 1269207 | 2021-04-29 | Unknown | Minnesota | 583 | 93 | |
1269559 | 1269559 | 2021-04-29 | Unknown | Nebraska | 747 | 0 | |
1269593 | 1269593 | 2021-04-29 | Unknown | New Hampshire | 1151 | 5 | |
1269614 | 1269614 | 2021-04-29 | Unknown | New Jersey | 849 | 0 | |
1269856 | 1269856 | 2021-04-29 | Unknown | North Dakota | 31 | 31 | |
1269943 | 1269943 | 2021-04-29 | Unknown | Ohio | 0 | 2 | |
1270024 | 1270024 | 2021-04-29 | Unknown | Oklahoma | 652 | 0 | |
1270204 | 1270204 | 2021-04-29 | Unknown | Puerto Rico | 5405 | 2296 |
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);