ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23,678 rows where fips = "" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Missouri 758
- New York 438
- 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
- …
county 4
- Unknown 10,574
- New York City 428
- Kansas City 409
- Joplin 312
fips 1
- - · 11,723 ✖
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 | |
1279091 | 1279091 | 2021-05-02 | Joplin | Missouri | 6019 | 106 | |
1279092 | 1279092 | 2021-05-02 | Kansas City | Missouri | 43441 | 572 | |
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 | |
1279418 | 1279418 | 2021-05-02 | New York City | New York | 930132 | 32626 | |
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 | |
1275844 | 1275844 | 2021-05-01 | Joplin | Missouri | 6010 | 106 | |
1275845 | 1275845 | 2021-05-01 | Kansas City | Missouri | 43383 | 572 | |
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 | |
1276171 | 1276171 | 2021-05-01 | New York City | New York | 928840 | 32596 | |
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 | |
1272597 | 1272597 | 2021-04-30 | Joplin | Missouri | 6001 | 106 | |
1272598 | 1272598 | 2021-04-30 | Kansas City | Missouri | 43316 | 572 | |
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 | |
1272924 | 1272924 | 2021-04-30 | New York City | New York | 927141 | 32545 | |
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 |
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);