ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 56
- Texas 168,366
- Georgia 109,049
- Virginia 89,958
- Kentucky 80,692
- Missouri 78,017
- Illinois 69,305
- Kansas 68,863
- North Carolina 67,909
- Iowa 67,170
- Tennessee 65,215
- Indiana 62,778
- Ohio 60,290
- Nebraska 59,949
- Minnesota 59,171
- Michigan 56,886
- Mississippi 55,972
- Oklahoma 52,201
- Arkansas 51,508
- Puerto Rico 50,576
- Wisconsin 48,865
- Florida 46,630
- Pennsylvania 45,808
- Alabama 45,614
- Louisiana 44,467
- Colorado 43,191
- South Dakota 43,018
- California 39,950
- New York 39,950
- West Virginia 36,793
- North Dakota 35,153
- Montana 35,112
- South Carolina 31,537
- Idaho 28,828
- Washington 27,022
- Oregon 24,219
- New Mexico 22,120
- Utah 19,949
- Alaska 17,798
- Maryland 17,170
- Wyoming 15,538
- New Jersey 15,239
- Maine 11,414
- Nevada 11,124
- Arizona 10,435
- Massachusetts 10,429
- Vermont 10,273
- New Hampshire 7,523
- Connecticut 6,200
- Rhode Island 4,110
- Hawaii 3,388
- Delaware 2,735
- Virgin Islands 2,184
- Northern Mariana Islands 1,441
- District of Columbia 699
- Guam 691
- American Samoa 140
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177512 | 2177512 | 2022-02-03 | Wilcox | Alabama | 1131 | 2711 | 39 |
2177513 | 2177513 | 2022-02-03 | Winston | Alabama | 1133 | 7057 | 115 |
2177514 | 2177514 | 2022-02-03 | Aleutians East Borough | Alaska | 2013 | 938 | 3 |
2177515 | 2177515 | 2022-02-03 | Aleutians West Census Area | Alaska | 2016 | 1614 | 1 |
2177516 | 2177516 | 2022-02-03 | Anchorage | Alaska | 2020 | 93825 | 462 |
2177517 | 2177517 | 2022-02-03 | Bethel Census Area | Alaska | 2050 | 8274 | 37 |
2177518 | 2177518 | 2022-02-03 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 743 | 1 |
2177519 | 2177519 | 2022-02-03 | Denali Borough | Alaska | 2068 | 353 | 1 |
2177520 | 2177520 | 2022-02-03 | Dillingham Census Area | Alaska | 2070 | 1341 | 11 |
2177521 | 2177521 | 2022-02-03 | Fairbanks North Star Borough | Alaska | 2090 | 24998 | 124 |
2177522 | 2177522 | 2022-02-03 | Haines Borough | Alaska | 2100 | 432 | 1 |
2177523 | 2177523 | 2022-02-03 | Juneau City and Borough | Alaska | 2110 | 7166 | 16 |
2177524 | 2177524 | 2022-02-03 | Kenai Peninsula Borough | Alaska | 2122 | 15358 | 89 |
2177525 | 2177525 | 2022-02-03 | Ketchikan Gateway Borough | Alaska | 2130 | 3391 | 15 |
2177526 | 2177526 | 2022-02-03 | Kodiak Island Borough | Alaska | 2150 | 4397 | 10 |
2177527 | 2177527 | 2022-02-03 | Kusilvak Census Area | Alaska | 2158 | 3334 | 9 |
2177528 | 2177528 | 2022-02-03 | Matanuska-Susitna Borough | Alaska | 2170 | 31567 | 201 |
2177529 | 2177529 | 2022-02-03 | Nome Census Area | Alaska | 2180 | 3975 | 3 |
2177530 | 2177530 | 2022-02-03 | North Slope Borough | Alaska | 2185 | 3783 | 10 |
2177531 | 2177531 | 2022-02-03 | Northwest Arctic Borough | Alaska | 2188 | 3409 | 11 |
2177532 | 2177532 | 2022-02-03 | Petersburg Borough | Alaska | 2195 | 611 | 2 |
2177533 | 2177533 | 2022-02-03 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 1068 | 6 |
2177534 | 2177534 | 2022-02-03 | Sitka City and Borough | Alaska | 2220 | 2002 | 5 |
2177535 | 2177535 | 2022-02-03 | Skagway Municipality | Alaska | 2230 | 110 | 0 |
2177536 | 2177536 | 2022-02-03 | Southeast Fairbanks Census Area | Alaska | 2240 | 1779 | 16 |
2177537 | 2177537 | 2022-02-03 | Unknown | Alaska | 788 | 1 | |
2177538 | 2177538 | 2022-02-03 | Valdez-Cordova Census Area | Alaska | 2261 | 2503 | 15 |
2177539 | 2177539 | 2022-02-03 | Wrangell City and Borough | Alaska | 2275 | 424 | 1 |
2177540 | 2177540 | 2022-02-03 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 435 | 5 |
2177541 | 2177541 | 2022-02-03 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1149 | 8 |
2177542 | 2177542 | 2022-02-03 | Unknown | American Samoa | 18 | 0 | |
2177543 | 2177543 | 2022-02-03 | Apache | Arizona | 4001 | 20764 | 571 |
2177544 | 2177544 | 2022-02-03 | Cochise | Arizona | 4003 | 28860 | 513 |
2177545 | 2177545 | 2022-02-03 | Coconino | Arizona | 4005 | 41046 | 441 |
2177546 | 2177546 | 2022-02-03 | Gila | Arizona | 4007 | 15966 | 341 |
2177547 | 2177547 | 2022-02-03 | Graham | Arizona | 4009 | 11345 | 164 |
2177548 | 2177548 | 2022-02-03 | Greenlee | Arizona | 4011 | 2100 | 30 |
2177549 | 2177549 | 2022-02-03 | La Paz | Arizona | 4012 | 4865 | 117 |
2177550 | 2177550 | 2022-02-03 | Maricopa | Arizona | 4013 | 1198179 | 14872 |
2177551 | 2177551 | 2022-02-03 | Mohave | Arizona | 4015 | 54024 | 1290 |
2177552 | 2177552 | 2022-02-03 | Navajo | Arizona | 4017 | 35832 | 815 |
2177553 | 2177553 | 2022-02-03 | Pima | Arizona | 4019 | 237193 | 3473 |
2177554 | 2177554 | 2022-02-03 | Pinal | Arizona | 4021 | 123035 | 1453 |
2177555 | 2177555 | 2022-02-03 | Santa Cruz | Arizona | 4023 | 15905 | 214 |
2177556 | 2177556 | 2022-02-03 | Unknown | Arizona | 1 | 0 | |
2177557 | 2177557 | 2022-02-03 | Yavapai | Arizona | 4025 | 45423 | 1074 |
2177558 | 2177558 | 2022-02-03 | Yuma | Arizona | 4027 | 59797 | 1062 |
2177559 | 2177559 | 2022-02-03 | Arkansas | Arkansas | 5001 | 5478 | 69 |
2177560 | 2177560 | 2022-02-03 | Ashley | Arkansas | 5003 | 4841 | 56 |
2177561 | 2177561 | 2022-02-03 | Baxter | Arkansas | 5005 | 8248 | 219 |
2177562 | 2177562 | 2022-02-03 | Benton | Arkansas | 5007 | 63610 | 729 |
2177563 | 2177563 | 2022-02-03 | Boone | Arkansas | 5009 | 9032 | 146 |
2177564 | 2177564 | 2022-02-03 | Bradley | Arkansas | 5011 | 2899 | 43 |
2177565 | 2177565 | 2022-02-03 | Calhoun | Arkansas | 5013 | 862 | 9 |
2177566 | 2177566 | 2022-02-03 | Carroll | Arkansas | 5015 | 5822 | 87 |
2177567 | 2177567 | 2022-02-03 | Chicot | Arkansas | 5017 | 2682 | 50 |
2177568 | 2177568 | 2022-02-03 | Clark | Arkansas | 5019 | 4971 | 71 |
2177569 | 2177569 | 2022-02-03 | Clay | Arkansas | 5021 | 3880 | 79 |
2177570 | 2177570 | 2022-02-03 | Cleburne | Arkansas | 5023 | 6103 | 109 |
2177571 | 2177571 | 2022-02-03 | Cleveland | Arkansas | 5025 | 2186 | 33 |
2177572 | 2177572 | 2022-02-03 | Columbia | Arkansas | 5027 | 5004 | 77 |
2177573 | 2177573 | 2022-02-03 | Conway | Arkansas | 5029 | 5203 | 51 |
2177574 | 2177574 | 2022-02-03 | Craighead | Arkansas | 5031 | 35099 | 277 |
2177575 | 2177575 | 2022-02-03 | Crawford | Arkansas | 5033 | 15243 | 212 |
2177576 | 2177576 | 2022-02-03 | Crittenden | Arkansas | 5035 | 13410 | 201 |
2177577 | 2177577 | 2022-02-03 | Cross | Arkansas | 5037 | 4560 | 75 |
2177578 | 2177578 | 2022-02-03 | Dallas | Arkansas | 5039 | 1659 | 22 |
2177579 | 2177579 | 2022-02-03 | Desha | Arkansas | 5041 | 2921 | 35 |
2177580 | 2177580 | 2022-02-03 | Drew | Arkansas | 5043 | 4431 | 58 |
2177581 | 2177581 | 2022-02-03 | Faulkner | Arkansas | 5045 | 33595 | 269 |
2177582 | 2177582 | 2022-02-03 | Franklin | Arkansas | 5047 | 3668 | 66 |
2177583 | 2177583 | 2022-02-03 | Fulton | Arkansas | 5049 | 2583 | 81 |
2177584 | 2177584 | 2022-02-03 | Garland | Arkansas | 5051 | 21849 | 443 |
2177585 | 2177585 | 2022-02-03 | Grant | Arkansas | 5053 | 4180 | 54 |
2177586 | 2177586 | 2022-02-03 | Greene | Arkansas | 5055 | 15186 | 146 |
2177587 | 2177587 | 2022-02-03 | Hempstead | Arkansas | 5057 | 4316 | 52 |
2177588 | 2177588 | 2022-02-03 | Hot Spring | Arkansas | 5059 | 10569 | 116 |
2177589 | 2177589 | 2022-02-03 | Howard | Arkansas | 5061 | 3619 | 42 |
2177590 | 2177590 | 2022-02-03 | Independence | Arkansas | 5063 | 9945 | 184 |
2177591 | 2177591 | 2022-02-03 | Izard | Arkansas | 5065 | 3741 | 62 |
2177592 | 2177592 | 2022-02-03 | Jackson | Arkansas | 5067 | 5761 | 50 |
2177593 | 2177593 | 2022-02-03 | Jefferson | Arkansas | 5069 | 18057 | 247 |
2177594 | 2177594 | 2022-02-03 | Johnson | Arkansas | 5071 | 6371 | 65 |
2177595 | 2177595 | 2022-02-03 | Lafayette | Arkansas | 5073 | 1215 | 28 |
2177596 | 2177596 | 2022-02-03 | Lawrence | Arkansas | 5075 | 4807 | 66 |
2177597 | 2177597 | 2022-02-03 | Lee | Arkansas | 5077 | 2811 | 54 |
2177598 | 2177598 | 2022-02-03 | Lincoln | Arkansas | 5079 | 4782 | 60 |
2177599 | 2177599 | 2022-02-03 | Little River | Arkansas | 5081 | 3098 | 85 |
2177600 | 2177600 | 2022-02-03 | Logan | Arkansas | 5083 | 4821 | 59 |
2177601 | 2177601 | 2022-02-03 | Lonoke | Arkansas | 5085 | 18979 | 203 |
2177602 | 2177602 | 2022-02-03 | Madison | Arkansas | 5087 | 3713 | 48 |
2177603 | 2177603 | 2022-02-03 | Marion | Arkansas | 5089 | 3161 | 76 |
2177604 | 2177604 | 2022-02-03 | Miller | Arkansas | 5091 | 8841 | 158 |
2177605 | 2177605 | 2022-02-03 | Mississippi | Arkansas | 5093 | 12671 | 169 |
2177606 | 2177606 | 2022-02-03 | Monroe | Arkansas | 5095 | 1871 | 28 |
2177607 | 2177607 | 2022-02-03 | Montgomery | Arkansas | 5097 | 1454 | 53 |
2177608 | 2177608 | 2022-02-03 | Nevada | Arkansas | 5099 | 2068 | 42 |
2177609 | 2177609 | 2022-02-03 | Newton | Arkansas | 5101 | 1667 | 45 |
2177610 | 2177610 | 2022-02-03 | Ouachita | Arkansas | 5103 | 5165 | 92 |
2177611 | 2177611 | 2022-02-03 | Perry | Arkansas | 5105 | 2379 | 28 |
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);