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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 54
- Rhode Island 804
- New Jersey 793
- Puerto Rico 792
- Guam 790
- Massachusetts 789
- Louisiana 786
- Arkansas 785
- Georgia 784
- Vermont 782
- Minnesota 779
- Michigan 778
- Connecticut 775
- Utah 775
- Florida 772
- Delaware 762
- Maryland 761
- Iowa 743
- New Hampshire 735
- North Dakota 717
- Tennessee 711
- Alaska 703
- Illinois 667
- Oklahoma 640
- Maine 599
- Nebraska 519
- Ohio 439
- Northern Mariana Islands 380
- Hawaii 294
- Kansas 246
- American Samoa 239
- Virgin Islands 188
- Washington 180
- New Mexico 164
- Wisconsin 135
- Nevada 117
- Arizona 99
- Mississippi 68
- Colorado 64
- Kentucky 42
- Indiana 40
- Virginia 39
- Missouri 38
- Texas 21
- California 17
- Idaho 12
- New York 10
- Oregon 7
- South Dakota 5
- West Virginia 4
- Wyoming 4
- South Carolina 3
- Montana 2
- Pennsylvania 2
- North Carolina 1
fips 1
- - 21,401
county 1
- Unknown · 21,401 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
419 | 419 | 2020-03-01 | Unknown | Rhode Island | 2 | 0 | |
451 | 451 | 2020-03-02 | Unknown | Rhode Island | 2 | 0 | |
486 | 486 | 2020-03-03 | Unknown | Rhode Island | 2 | 0 | |
523 | 523 | 2020-03-04 | Unknown | Rhode Island | 2 | 0 | |
570 | 570 | 2020-03-05 | Unknown | Rhode Island | 2 | 0 | |
637 | 637 | 2020-03-06 | Unknown | Rhode Island | 3 | 0 | |
729 | 729 | 2020-03-07 | Unknown | Rhode Island | 3 | 0 | |
838 | 838 | 2020-03-08 | Unknown | Rhode Island | 3 | 0 | |
967 | 967 | 2020-03-09 | Unknown | Rhode Island | 3 | 0 | |
1120 | 1120 | 2020-03-10 | Unknown | Rhode Island | 5 | 0 | |
1314 | 1314 | 2020-03-11 | Unknown | Rhode Island | 5 | 0 | |
1512 | 1512 | 2020-03-12 | Unknown | New Jersey | 1 | 0 | |
1560 | 1560 | 2020-03-12 | Unknown | Rhode Island | 5 | 0 | |
1805 | 1805 | 2020-03-13 | Unknown | New Jersey | 1 | 0 | |
1859 | 1859 | 2020-03-13 | Unknown | Puerto Rico | 3 | 0 | |
1860 | 1860 | 2020-03-13 | Unknown | Rhode Island | 20 | 0 | |
2152 | 2152 | 2020-03-14 | Unknown | New Jersey | 1 | 0 | |
2221 | 2221 | 2020-03-14 | Unknown | Puerto Rico | 4 | 0 | |
2222 | 2222 | 2020-03-14 | Unknown | Rhode Island | 20 | 0 | |
2268 | 2268 | 2020-03-14 | Unknown | Virgin Islands | 1 | 0 | |
2423 | 2423 | 2020-03-15 | Unknown | Guam | 3 | 0 | |
2560 | 2560 | 2020-03-15 | Unknown | New Jersey | 1 | 0 | |
2643 | 2643 | 2020-03-15 | Unknown | Puerto Rico | 5 | 0 | |
2644 | 2644 | 2020-03-15 | Unknown | Rhode Island | 20 | 0 | |
2695 | 2695 | 2020-03-15 | Unknown | Virgin Islands | 1 | 0 | |
2864 | 2864 | 2020-03-16 | Unknown | Guam | 3 | 0 | |
2930 | 2930 | 2020-03-16 | Unknown | Maine | 1 | 0 | |
2951 | 2951 | 2020-03-16 | Unknown | Massachusetts | 1 | 0 | |
3018 | 3018 | 2020-03-16 | Unknown | New Jersey | 1 | 0 | |
3108 | 3108 | 2020-03-16 | Unknown | Puerto Rico | 5 | 0 | |
3109 | 3109 | 2020-03-16 | Unknown | Rhode Island | 21 | 0 | |
3167 | 3167 | 2020-03-16 | Unknown | Virgin Islands | 2 | 0 | |
3351 | 3351 | 2020-03-17 | Unknown | Guam | 3 | 0 | |
3430 | 3430 | 2020-03-17 | Unknown | Maine | 3 | 0 | |
3452 | 3452 | 2020-03-17 | Unknown | Massachusetts | 1 | 0 | |
3531 | 3531 | 2020-03-17 | Unknown | New Jersey | 1 | 0 | |
3638 | 3638 | 2020-03-17 | Unknown | Puerto Rico | 5 | 0 | |
3639 | 3639 | 2020-03-17 | Unknown | Rhode Island | 23 | 0 | |
3703 | 3703 | 2020-03-17 | Unknown | Virgin Islands | 2 | 0 | |
3913 | 3913 | 2020-03-18 | Unknown | Guam | 8 | 0 | |
4004 | 4004 | 2020-03-18 | Unknown | Louisiana | 2 | 0 | |
4012 | 4012 | 2020-03-18 | Unknown | Maine | 3 | 0 | |
4035 | 4035 | 2020-03-18 | Unknown | Massachusetts | 4 | 0 | |
4127 | 4127 | 2020-03-18 | Unknown | New Jersey | 1 | 0 | |
4257 | 4257 | 2020-03-18 | Unknown | Puerto Rico | 5 | 0 | |
4258 | 4258 | 2020-03-18 | Unknown | Rhode Island | 33 | 0 | |
4335 | 4335 | 2020-03-18 | Unknown | Virgin Islands | 3 | 0 | |
4589 | 4589 | 2020-03-19 | Unknown | Guam | 12 | 0 | |
4681 | 4681 | 2020-03-19 | Unknown | Kentucky | 1 | 0 | |
4704 | 4704 | 2020-03-19 | Unknown | Louisiana | 3 | 0 | |
4714 | 4714 | 2020-03-19 | Unknown | Maine | 3 | 0 | |
4740 | 4740 | 2020-03-19 | Unknown | Massachusetts | 13 | 0 | |
4829 | 4829 | 2020-03-19 | Unknown | Nevada | 4 | 0 | |
4855 | 4855 | 2020-03-19 | Unknown | New Jersey | 1 | 0 | |
4999 | 4999 | 2020-03-19 | Unknown | Puerto Rico | 6 | 0 | |
5000 | 5000 | 2020-03-19 | Unknown | Rhode Island | 44 | 0 | |
5039 | 5039 | 2020-03-19 | Unknown | Tennessee | 2 | 0 | |
5091 | 5091 | 2020-03-19 | Unknown | Virgin Islands | 3 | 0 | |
5224 | 5224 | 2020-03-20 | Unknown | Arkansas | 19 | 0 | |
5386 | 5386 | 2020-03-20 | Unknown | Georgia | 6 | 0 | |
5389 | 5389 | 2020-03-20 | Unknown | Guam | 14 | 0 | |
5495 | 5495 | 2020-03-20 | Unknown | Kentucky | 1 | 0 | |
5522 | 5522 | 2020-03-20 | Unknown | Louisiana | 5 | 0 | |
5532 | 5532 | 2020-03-20 | Unknown | Maine | 3 | 0 | |
5559 | 5559 | 2020-03-20 | Unknown | Massachusetts | 18 | 0 | |
5648 | 5648 | 2020-03-20 | Unknown | Missouri | 1 | 0 | |
5671 | 5671 | 2020-03-20 | Unknown | Nevada | 11 | 0 | |
5699 | 5699 | 2020-03-20 | Unknown | New Jersey | 3 | 0 | |
5872 | 5872 | 2020-03-20 | Unknown | Puerto Rico | 14 | 0 | |
5873 | 5873 | 2020-03-20 | Unknown | Rhode Island | 44 | 0 | |
5928 | 5928 | 2020-03-20 | Unknown | Tennessee | 2 | 0 | |
5987 | 5987 | 2020-03-20 | Unknown | Virgin Islands | 6 | 0 | |
6143 | 6143 | 2020-03-21 | Unknown | Arkansas | 21 | 0 | |
6320 | 6320 | 2020-03-21 | Unknown | Georgia | 27 | 0 | |
6323 | 6323 | 2020-03-21 | Unknown | Guam | 15 | 0 | |
6443 | 6443 | 2020-03-21 | Unknown | Kentucky | 5 | 0 | |
6477 | 6477 | 2020-03-21 | Unknown | Louisiana | 9 | 0 | |
6488 | 6488 | 2020-03-21 | Unknown | Maine | 3 | 0 | |
6519 | 6519 | 2020-03-21 | Unknown | Massachusetts | 26 | 0 | |
6571 | 6571 | 2020-03-21 | Unknown | Minnesota | 1 | 0 | |
6638 | 6638 | 2020-03-21 | Unknown | Missouri | 1 | 0 | |
6663 | 6663 | 2020-03-21 | Unknown | Nevada | 11 | 0 | |
6692 | 6692 | 2020-03-21 | Unknown | New Jersey | 151 | 0 | |
6876 | 6876 | 2020-03-21 | Unknown | Puerto Rico | 21 | 1 | |
6877 | 6877 | 2020-03-21 | Unknown | Rhode Island | 66 | 0 | |
6945 | 6945 | 2020-03-21 | Unknown | Tennessee | 8 | 0 | |
7012 | 7012 | 2020-03-21 | Unknown | Virgin Islands | 6 | 0 | |
7177 | 7177 | 2020-03-22 | Unknown | Arkansas | 27 | 0 | |
7216 | 7216 | 2020-03-22 | Unknown | California | 1 | 0 | |
7247 | 7247 | 2020-03-22 | Unknown | Colorado | 1 | 0 | |
7305 | 7305 | 2020-03-22 | Unknown | Florida | 1 | 0 | |
7368 | 7368 | 2020-03-22 | Unknown | Georgia | 27 | 2 | |
7371 | 7371 | 2020-03-22 | Unknown | Guam | 27 | 1 | |
7517 | 7517 | 2020-03-22 | Unknown | Kentucky | 6 | 0 | |
7552 | 7552 | 2020-03-22 | Unknown | Louisiana | 11 | 0 | |
7563 | 7563 | 2020-03-22 | Unknown | Maine | 5 | 0 | |
7596 | 7596 | 2020-03-22 | Unknown | Massachusetts | 34 | 0 | |
7653 | 7653 | 2020-03-22 | Unknown | Minnesota | 1 | 0 | |
7727 | 7727 | 2020-03-22 | Unknown | Missouri | 1 | 0 | |
7753 | 7753 | 2020-03-22 | Unknown | Nevada | 33 | 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);