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
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- New Jersey 783
- Puerto Rico 783
- Rhode Island 783
- Arkansas 782
- Guam 782
- Massachusetts 782
- Vermont 782
- Georgia 781
- Louisiana 781
- Michigan 778
- Minnesota 777
- Connecticut 775
- Utah 775
- Florida 771
- Delaware 762
- Maryland 761
- Iowa 743
- New Hampshire 735
- North Dakota 717
- Tennessee 708
- Alaska 703
- Illinois 667
- Oklahoma 640
- Maine 592
- Nebraska 519
- Ohio 439
- Northern Mariana Islands 380
- Hawaii 294
- Kansas 246
- American Samoa 239
- …
fips 1
- - 21,301
county 1
- Unknown · 21,301 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7784 | 7784 | 2020-03-22 | Unknown | New Jersey | 221 | 0 | |
7996 | 7996 | 2020-03-22 | Unknown | Puerto Rico | 23 | 1 | |
7997 | 7997 | 2020-03-22 | Unknown | Rhode Island | 83 | 0 | |
8075 | 8075 | 2020-03-22 | Unknown | Tennessee | 28 | 0 | |
8142 | 8142 | 2020-03-22 | Unknown | Virgin Islands | 17 | 0 | |
8320 | 8320 | 2020-03-23 | Unknown | Arkansas | 61 | 0 | |
8359 | 8359 | 2020-03-23 | Unknown | California | 2 | 0 | |
8393 | 8393 | 2020-03-23 | Unknown | Colorado | 5 | 0 | |
8451 | 8451 | 2020-03-23 | Unknown | Florida | 1 | 0 | |
8521 | 8521 | 2020-03-23 | Unknown | Georgia | 46 | 2 | |
8525 | 8525 | 2020-03-23 | Unknown | Guam | 29 | 1 | |
8530 | 8530 | 2020-03-23 | Unknown | Hawaii | 5 | 0 | |
8565 | 8565 | 2020-03-23 | Unknown | Illinois | 58 | 0 | |
8680 | 8680 | 2020-03-23 | Unknown | Kentucky | 9 | 0 | |
8721 | 8721 | 2020-03-23 | Unknown | Louisiana | 12 | 0 | |
8733 | 8733 | 2020-03-23 | Unknown | Maine | 5 | 0 | |
8768 | 8768 | 2020-03-23 | Unknown | Massachusetts | 57 | 0 | |
8833 | 8833 | 2020-03-23 | Unknown | Minnesota | 1 | 0 | |
8920 | 8920 | 2020-03-23 | Unknown | Missouri | 1 | 0 | |
8949 | 8949 | 2020-03-23 | Unknown | Nevada | 82 | 0 | |
8980 | 8980 | 2020-03-23 | Unknown | New Jersey | 416 | 0 | |
9207 | 9207 | 2020-03-23 | Unknown | Puerto Rico | 31 | 2 | |
9208 | 9208 | 2020-03-23 | Unknown | Rhode Island | 106 | 0 | |
9293 | 9293 | 2020-03-23 | Unknown | Tennessee | 109 | 0 | |
9359 | 9359 | 2020-03-23 | Unknown | Vermont | 23 | 0 | |
9363 | 9363 | 2020-03-23 | Unknown | Virgin Islands | 17 | 0 | |
9522 | 9522 | 2020-03-24 | Unknown | Arizona | 0 | 3 | |
9558 | 9558 | 2020-03-24 | Unknown | Arkansas | 2 | 0 | |
9638 | 9638 | 2020-03-24 | Unknown | Colorado | 18 | 1 | |
9696 | 9696 | 2020-03-24 | Unknown | Florida | 10 | 0 | |
9782 | 9782 | 2020-03-24 | Unknown | Georgia | 78 | 5 | |
9786 | 9786 | 2020-03-24 | Unknown | Guam | 32 | 1 | |
9791 | 9791 | 2020-03-24 | Unknown | Hawaii | 13 | 0 | |
9829 | 9829 | 2020-03-24 | Unknown | Illinois | 2 | 0 | |
9968 | 9968 | 2020-03-24 | Unknown | Kentucky | 13 | 0 | |
10009 | 10009 | 2020-03-24 | Unknown | Louisiana | 10 | 1 | |
10057 | 10057 | 2020-03-24 | Unknown | Massachusetts | 90 | 0 | |
10097 | 10097 | 2020-03-24 | Unknown | Michigan | 8 | 0 | |
10128 | 10128 | 2020-03-24 | Unknown | Minnesota | 1 | 0 | |
10222 | 10222 | 2020-03-24 | Unknown | Missouri | 40 | 0 | |
10253 | 10253 | 2020-03-24 | Unknown | Nevada | 14 | 0 | |
10284 | 10284 | 2020-03-24 | Unknown | New Jersey | 645 | 0 | |
10532 | 10532 | 2020-03-24 | Unknown | Puerto Rico | 39 | 2 | |
10533 | 10533 | 2020-03-24 | Unknown | Rhode Island | 124 | 0 | |
10627 | 10627 | 2020-03-24 | Unknown | Tennessee | 34 | 0 | |
10679 | 10679 | 2020-03-24 | Unknown | Texas | 0 | 1 | |
10705 | 10705 | 2020-03-24 | Unknown | Vermont | 2 | 5 | |
10709 | 10709 | 2020-03-24 | Unknown | Virgin Islands | 17 | 0 | |
10749 | 10749 | 2020-03-24 | Unknown | Virginia | 0 | 1 | |
10780 | 10780 | 2020-03-24 | Unknown | Washington | 77 | 0 | |
10892 | 10892 | 2020-03-25 | Unknown | Arizona | 0 | 3 | |
10929 | 10929 | 2020-03-25 | Unknown | Arkansas | 2 | 0 | |
11012 | 11012 | 2020-03-25 | Unknown | Colorado | 18 | 0 | |
11071 | 11071 | 2020-03-25 | Unknown | Florida | 1 | 0 | |
11164 | 11164 | 2020-03-25 | Unknown | Georgia | 154 | 14 | |
11171 | 11171 | 2020-03-25 | Unknown | Guam | 32 | 1 | |
11176 | 11176 | 2020-03-25 | Unknown | Hawaii | 4 | 0 | |
11222 | 11222 | 2020-03-25 | Unknown | Illinois | 0 | 2 | |
11371 | 11371 | 2020-03-25 | Unknown | Kentucky | 31 | 0 | |
11417 | 11417 | 2020-03-25 | Unknown | Louisiana | 9 | 1 | |
11431 | 11431 | 2020-03-25 | Unknown | Maine | 2 | 0 | |
11469 | 11469 | 2020-03-25 | Unknown | Massachusetts | 159 | 0 | |
11513 | 11513 | 2020-03-25 | Unknown | Michigan | 8 | 0 | |
11546 | 11546 | 2020-03-25 | Unknown | Minnesota | 1 | 0 | |
11651 | 11651 | 2020-03-25 | Unknown | Missouri | 4 | 0 | |
11685 | 11685 | 2020-03-25 | Unknown | Nevada | 89 | 4 | |
11716 | 11716 | 2020-03-25 | Unknown | New Jersey | 933 | 0 | |
11998 | 11998 | 2020-03-25 | Unknown | Puerto Rico | 51 | 2 | |
12003 | 12003 | 2020-03-25 | Unknown | Rhode Island | 66 | 0 | |
12106 | 12106 | 2020-03-25 | Unknown | Tennessee | 78 | 1 | |
12203 | 12203 | 2020-03-25 | Unknown | Utah | 10 | 0 | |
12217 | 12217 | 2020-03-25 | Unknown | Vermont | 0 | 1 | |
12221 | 12221 | 2020-03-25 | Unknown | Virgin Islands | 17 | 0 | |
12271 | 12271 | 2020-03-25 | Unknown | Virginia | 0 | 1 | |
12433 | 12433 | 2020-03-26 | Unknown | Arizona | 0 | 2 | |
12474 | 12474 | 2020-03-26 | Unknown | Arkansas | 2 | 0 | |
12559 | 12559 | 2020-03-26 | Unknown | Colorado | 102 | 0 | |
12717 | 12717 | 2020-03-26 | Unknown | Georgia | 172 | 23 | |
12724 | 12724 | 2020-03-26 | Unknown | Guam | 49 | 1 | |
12729 | 12729 | 2020-03-26 | Unknown | Hawaii | 5 | 0 | |
12746 | 12746 | 2020-03-26 | Unknown | Idaho | 1 | 0 | |
12945 | 12945 | 2020-03-26 | Unknown | Kentucky | 38 | 0 | |
12996 | 12996 | 2020-03-26 | Unknown | Louisiana | 12 | 1 | |
13012 | 13012 | 2020-03-26 | Unknown | Maine | 1 | 0 | |
13050 | 13050 | 2020-03-26 | Unknown | Massachusetts | 267 | 0 | |
13101 | 13101 | 2020-03-26 | Unknown | Michigan | 13 | 0 | |
13136 | 13136 | 2020-03-26 | Unknown | Minnesota | 1 | 1 | |
13288 | 13288 | 2020-03-26 | Unknown | Nevada | 107 | 0 | |
13319 | 13319 | 2020-03-26 | Unknown | New Jersey | 1478 | 0 | |
13620 | 13620 | 2020-03-26 | Unknown | Puerto Rico | 64 | 2 | |
13625 | 13625 | 2020-03-26 | Unknown | Rhode Island | 94 | 0 | |
13733 | 13733 | 2020-03-26 | Unknown | Tennessee | 110 | 1 | |
13839 | 13839 | 2020-03-26 | Unknown | Utah | 5 | 0 | |
13853 | 13853 | 2020-03-26 | Unknown | Vermont | 8 | 2 | |
13857 | 13857 | 2020-03-26 | Unknown | Virgin Islands | 17 | 0 | |
13919 | 13919 | 2020-03-26 | Unknown | Virginia | 35 | 5 | |
13954 | 13954 | 2020-03-26 | Unknown | Washington | 65 | 0 | |
14096 | 14096 | 2020-03-27 | Unknown | Arizona | 0 | 4 | |
14138 | 14138 | 2020-03-27 | Unknown | Arkansas | 5 | 0 | |
14228 | 14228 | 2020-03-27 | Unknown | Colorado | 136 | 1 |
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);