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 799
- New Jersey 787
- Puerto Rico 787
- Guam 784
- Massachusetts 783
- Louisiana 780
- Arkansas 779
- Georgia 778
- Vermont 777
- Minnesota 773
- Michigan 772
- Utah 770
- Connecticut 769
- Florida 766
- Delaware 756
- Maryland 755
- Iowa 737
- New Hampshire 729
- North Dakota 711
- Tennessee 706
- Alaska 697
- Illinois 661
- Oklahoma 635
- Maine 593
- Nebraska 513
- Ohio 434
- Northern Mariana Islands 375
- Hawaii 288
- Kansas 240
- American Samoa 233
- …
fips 1
- - 21,201
county 1
- Unknown · 21,201 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485354 | 2485354 | 2022-05-08 | Unknown | Northern Mariana Islands | 128 | 1 | |
2485435 | 2485435 | 2022-05-08 | Unknown | Ohio | 0 | 7 | |
2485516 | 2485516 | 2022-05-08 | Unknown | Oklahoma | 1408 | 0 | |
2485696 | 2485696 | 2022-05-08 | Unknown | Puerto Rico | 19800 | 4232 | |
2485708 | 2485708 | 2022-05-08 | Unknown | Rhode Island | 30148 | 9 | |
2485909 | 2485909 | 2022-05-08 | Unknown | Tennessee | 19637 | 286 | |
2486196 | 2486196 | 2022-05-08 | Unknown | Utah | 4081 | 92 | |
2486213 | 2486213 | 2022-05-08 | Unknown | Vermont | 1382 | 2 | |
2486220 | 2486220 | 2022-05-08 | Unknown | Virgin Islands | 1 | 0 | |
2486388 | 2486388 | 2022-05-08 | Unknown | Washington | 3265 | 0 | |
2480118 | 2480118 | 2022-05-07 | Unknown | Alaska | 914 | 1 | |
2480123 | 2480123 | 2022-05-07 | Unknown | American Samoa | 5812 | 27 | |
2480209 | 2480209 | 2022-05-07 | Unknown | Arkansas | 26985 | 0 | |
2480344 | 2480344 | 2022-05-07 | Unknown | Connecticut | 2320 | 1 | |
2480349 | 2480349 | 2022-05-07 | Unknown | Delaware | 877 | 0 | |
2480414 | 2480414 | 2022-05-07 | Unknown | Florida | 5510 | 127 | |
2480563 | 2480563 | 2022-05-07 | Unknown | Georgia | 10770 | 6 | |
2480579 | 2480579 | 2022-05-07 | Unknown | Guam | 49292 | 356 | |
2480585 | 2480585 | 2022-05-07 | Unknown | Hawaii | 0 | 9 | |
2480721 | 2480721 | 2022-05-07 | Unknown | Illinois | 0 | 2267 | |
2480814 | 2480814 | 2022-05-07 | Unknown | Indiana | 1691 | 44 | |
2480914 | 2480914 | 2022-05-07 | Unknown | Iowa | 1409 | 0 | |
2481024 | 2481024 | 2022-05-07 | Unknown | Kansas | 0 | 146 | |
2481208 | 2481208 | 2022-05-07 | Unknown | Louisiana | 983 | 0 | |
2481230 | 2481230 | 2022-05-07 | Unknown | Maine | 48 | 0 | |
2481255 | 2481255 | 2022-05-07 | Unknown | Maryland | 0 | 26 | |
2481272 | 2481272 | 2022-05-07 | Unknown | Massachusetts | 143325 | 22 | |
2481353 | 2481353 | 2022-05-07 | Unknown | Michigan | 17408 | 79 | |
2481436 | 2481436 | 2022-05-07 | Unknown | Minnesota | 1092 | 280 | |
2481519 | 2481519 | 2022-05-07 | Unknown | Mississippi | 799 | 8 | |
2481789 | 2481789 | 2022-05-07 | Unknown | Nebraska | 2314 | 462 | |
2481811 | 2481811 | 2022-05-07 | Unknown | Nevada | 7418 | 7 | |
2481824 | 2481824 | 2022-05-07 | Unknown | New Hampshire | 5016 | 2 | |
2481845 | 2481845 | 2022-05-07 | Unknown | New Jersey | 3212 | 0 | |
2481879 | 2481879 | 2022-05-07 | Unknown | New Mexico | 53 | 7 | |
2482088 | 2482088 | 2022-05-07 | Unknown | North Dakota | 0 | 83 | |
2482096 | 2482096 | 2022-05-07 | Unknown | Northern Mariana Islands | 128 | 1 | |
2482177 | 2482177 | 2022-05-07 | Unknown | Ohio | 0 | 7 | |
2482258 | 2482258 | 2022-05-07 | Unknown | Oklahoma | 1408 | 0 | |
2482438 | 2482438 | 2022-05-07 | Unknown | Puerto Rico | 19830 | 4231 | |
2482450 | 2482450 | 2022-05-07 | Unknown | Rhode Island | 30148 | 9 | |
2482651 | 2482651 | 2022-05-07 | Unknown | Tennessee | 19808 | 286 | |
2482938 | 2482938 | 2022-05-07 | Unknown | Utah | 4084 | 92 | |
2482955 | 2482955 | 2022-05-07 | Unknown | Vermont | 1382 | 2 | |
2482962 | 2482962 | 2022-05-07 | Unknown | Virgin Islands | 1 | 0 | |
2483130 | 2483130 | 2022-05-07 | Unknown | Washington | 3265 | 0 | |
2476860 | 2476860 | 2022-05-06 | Unknown | Alaska | 914 | 1 | |
2476865 | 2476865 | 2022-05-06 | Unknown | American Samoa | 5812 | 27 | |
2476951 | 2476951 | 2022-05-06 | Unknown | Arkansas | 26983 | 0 | |
2477086 | 2477086 | 2022-05-06 | Unknown | Connecticut | 2320 | 1 | |
2477091 | 2477091 | 2022-05-06 | Unknown | Delaware | 877 | 0 | |
2477156 | 2477156 | 2022-05-06 | Unknown | Florida | 3 | 102 | |
2477305 | 2477305 | 2022-05-06 | Unknown | Georgia | 10770 | 6 | |
2477321 | 2477321 | 2022-05-06 | Unknown | Guam | 49292 | 356 | |
2477327 | 2477327 | 2022-05-06 | Unknown | Hawaii | 0 | 9 | |
2477463 | 2477463 | 2022-05-06 | Unknown | Illinois | 0 | 2267 | |
2477556 | 2477556 | 2022-05-06 | Unknown | Indiana | 0 | 21 | |
2477656 | 2477656 | 2022-05-06 | Unknown | Iowa | 306 | 0 | |
2477766 | 2477766 | 2022-05-06 | Unknown | Kansas | 0 | 146 | |
2477950 | 2477950 | 2022-05-06 | Unknown | Louisiana | 983 | 0 | |
2477972 | 2477972 | 2022-05-06 | Unknown | Maine | 26 | 0 | |
2477997 | 2477997 | 2022-05-06 | Unknown | Maryland | 0 | 26 | |
2478014 | 2478014 | 2022-05-06 | Unknown | Massachusetts | 143325 | 22 | |
2478095 | 2478095 | 2022-05-06 | Unknown | Michigan | 17408 | 79 | |
2478178 | 2478178 | 2022-05-06 | Unknown | Minnesota | 1092 | 280 | |
2478261 | 2478261 | 2022-05-06 | Unknown | Mississippi | 799 | 8 | |
2478531 | 2478531 | 2022-05-06 | Unknown | Nebraska | 2314 | 462 | |
2478553 | 2478553 | 2022-05-06 | Unknown | Nevada | 6836 | 6 | |
2478566 | 2478566 | 2022-05-06 | Unknown | New Hampshire | 5016 | 2 | |
2478587 | 2478587 | 2022-05-06 | Unknown | New Jersey | 3198 | 0 | |
2478621 | 2478621 | 2022-05-06 | Unknown | New Mexico | 53 | 7 | |
2478830 | 2478830 | 2022-05-06 | Unknown | North Dakota | 0 | 83 | |
2478838 | 2478838 | 2022-05-06 | Unknown | Northern Mariana Islands | 128 | 1 | |
2478919 | 2478919 | 2022-05-06 | Unknown | Ohio | 0 | 7 | |
2479000 | 2479000 | 2022-05-06 | Unknown | Oklahoma | 907 | 0 | |
2479180 | 2479180 | 2022-05-06 | Unknown | Puerto Rico | 19633 | 4227 | |
2479192 | 2479192 | 2022-05-06 | Unknown | Rhode Island | 30148 | 9 | |
2479393 | 2479393 | 2022-05-06 | Unknown | Tennessee | 19123 | 284 | |
2479680 | 2479680 | 2022-05-06 | Unknown | Utah | 4212 | 95 | |
2479697 | 2479697 | 2022-05-06 | Unknown | Vermont | 1382 | 2 | |
2479704 | 2479704 | 2022-05-06 | Unknown | Virgin Islands | 1 | 0 | |
2479872 | 2479872 | 2022-05-06 | Unknown | Washington | 3265 | 0 | |
2473602 | 2473602 | 2022-05-05 | Unknown | Alaska | 914 | 1 | |
2473607 | 2473607 | 2022-05-05 | Unknown | American Samoa | 5812 | 27 | |
2473693 | 2473693 | 2022-05-05 | Unknown | Arkansas | 26975 | 0 | |
2473828 | 2473828 | 2022-05-05 | Unknown | Connecticut | 2310 | 1 | |
2473833 | 2473833 | 2022-05-05 | Unknown | Delaware | 876 | 0 | |
2473898 | 2473898 | 2022-05-05 | Unknown | Florida | 53458 | 81 | |
2474047 | 2474047 | 2022-05-05 | Unknown | Georgia | 10770 | 6 | |
2474063 | 2474063 | 2022-05-05 | Unknown | Guam | 49271 | 356 | |
2474069 | 2474069 | 2022-05-05 | Unknown | Hawaii | 0 | 9 | |
2474205 | 2474205 | 2022-05-05 | Unknown | Illinois | 0 | 2267 | |
2474298 | 2474298 | 2022-05-05 | Unknown | Indiana | 0 | 21 | |
2474398 | 2474398 | 2022-05-05 | Unknown | Iowa | 306 | 0 | |
2474508 | 2474508 | 2022-05-05 | Unknown | Kansas | 0 | 90 | |
2474692 | 2474692 | 2022-05-05 | Unknown | Louisiana | 983 | 0 | |
2474714 | 2474714 | 2022-05-05 | Unknown | Maine | 20 | 0 | |
2474739 | 2474739 | 2022-05-05 | Unknown | Maryland | 0 | 28 | |
2474756 | 2474756 | 2022-05-05 | Unknown | Massachusetts | 142646 | 22 | |
2474837 | 2474837 | 2022-05-05 | Unknown | Michigan | 17825 | 79 |
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);