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 >30
- Texas 18,024
- Georgia 14,009
- Virginia 10,969
- Kentucky 9,423
- Missouri 8,538
- North Carolina 8,508
- Tennessee 8,230
- Illinois 8,220
- Indiana 8,130
- Iowa 7,773
- Ohio 7,679
- Mississippi 7,262
- Michigan 7,004
- Minnesota 6,934
- Kansas 6,596
- Arkansas 6,376
- Florida 6,238
- Pennsylvania 6,010
- Wisconsin 5,972
- Oklahoma 5,959
- Louisiana 5,858
- Alabama 5,852
- California 5,530
- New York 5,498
- Colorado 5,327
- Nebraska 5,117
- South Carolina 4,210
- West Virginia 4,172
- South Dakota 3,985
- Washington 3,732
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
252616 | 252616 | 2020-06-19 | Franklin | Alabama | 1059 | 773 | 10 |
252617 | 252617 | 2020-06-19 | Geneva | Alabama | 1061 | 49 | 0 |
252618 | 252618 | 2020-06-19 | Greene | Alabama | 1063 | 151 | 5 |
252619 | 252619 | 2020-06-19 | Hale | Alabama | 1065 | 261 | 16 |
252620 | 252620 | 2020-06-19 | Henry | Alabama | 1067 | 111 | 2 |
252621 | 252621 | 2020-06-19 | Houston | Alabama | 1069 | 352 | 5 |
252622 | 252622 | 2020-06-19 | Jackson | Alabama | 1071 | 150 | 3 |
252623 | 252623 | 2020-06-19 | Jefferson | Alabama | 1073 | 2835 | 124 |
252624 | 252624 | 2020-06-19 | Lamar | Alabama | 1075 | 55 | 0 |
252625 | 252625 | 2020-06-19 | Lauderdale | Alabama | 1077 | 290 | 4 |
252626 | 252626 | 2020-06-19 | Lawrence | Alabama | 1079 | 74 | 0 |
252627 | 252627 | 2020-06-19 | Lee | Alabama | 1081 | 827 | 35 |
252628 | 252628 | 2020-06-19 | Limestone | Alabama | 1083 | 262 | 0 |
252629 | 252629 | 2020-06-19 | Lowndes | Alabama | 1085 | 414 | 15 |
252630 | 252630 | 2020-06-19 | Macon | Alabama | 1087 | 140 | 6 |
252631 | 252631 | 2020-06-19 | Madison | Alabama | 1089 | 671 | 6 |
252632 | 252632 | 2020-06-19 | Marengo | Alabama | 1091 | 238 | 10 |
252633 | 252633 | 2020-06-19 | Marion | Alabama | 1093 | 170 | 12 |
252634 | 252634 | 2020-06-19 | Marshall | Alabama | 1095 | 1038 | 9 |
252635 | 252635 | 2020-06-19 | Mobile | Alabama | 1097 | 2921 | 132 |
252636 | 252636 | 2020-06-19 | Monroe | Alabama | 1099 | 154 | 2 |
252637 | 252637 | 2020-06-19 | Montgomery | Alabama | 1101 | 3149 | 77 |
252638 | 252638 | 2020-06-19 | Morgan | Alabama | 1103 | 717 | 2 |
252639 | 252639 | 2020-06-19 | Perry | Alabama | 1105 | 86 | 0 |
252640 | 252640 | 2020-06-19 | Pickens | Alabama | 1107 | 154 | 6 |
252641 | 252641 | 2020-06-19 | Pike | Alabama | 1109 | 356 | 3 |
252642 | 252642 | 2020-06-19 | Randolph | Alabama | 1111 | 144 | 8 |
252643 | 252643 | 2020-06-19 | Russell | Alabama | 1113 | 349 | 0 |
252644 | 252644 | 2020-06-19 | Shelby | Alabama | 1117 | 759 | 21 |
252645 | 252645 | 2020-06-19 | St. Clair | Alabama | 1115 | 201 | 2 |
252646 | 252646 | 2020-06-19 | Sumter | Alabama | 1119 | 268 | 12 |
252647 | 252647 | 2020-06-19 | Talladega | Alabama | 1121 | 177 | 6 |
252648 | 252648 | 2020-06-19 | Tallapoosa | Alabama | 1123 | 513 | 69 |
252649 | 252649 | 2020-06-19 | Tuscaloosa | Alabama | 1125 | 1541 | 29 |
252650 | 252650 | 2020-06-19 | Walker | Alabama | 1127 | 674 | 8 |
252651 | 252651 | 2020-06-19 | Washington | Alabama | 1129 | 94 | 6 |
252652 | 252652 | 2020-06-19 | Wilcox | Alabama | 1131 | 242 | 8 |
252653 | 252653 | 2020-06-19 | Winston | Alabama | 1133 | 173 | 1 |
252654 | 252654 | 2020-06-19 | Aleutians East Borough | Alaska | 2013 | 2 | 0 |
252655 | 252655 | 2020-06-19 | Aleutians West Census Area | Alaska | 2016 | 4 | 0 |
252656 | 252656 | 2020-06-19 | Anchorage | Alaska | 2020 | 370 | 6 |
252657 | 252657 | 2020-06-19 | Bethel Census Area | Alaska | 2050 | 7 | 0 |
252658 | 252658 | 2020-06-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 7 | 0 |
252659 | 252659 | 2020-06-19 | Dillingham Census Area | Alaska | 2070 | 1 | 0 |
252660 | 252660 | 2020-06-19 | Fairbanks North Star Borough | Alaska | 2090 | 111 | 2 |
252661 | 252661 | 2020-06-19 | Haines Borough | Alaska | 2100 | 2 | 0 |
252662 | 252662 | 2020-06-19 | Juneau City and Borough | Alaska | 2110 | 42 | 0 |
252663 | 252663 | 2020-06-19 | Kenai Peninsula Borough | Alaska | 2122 | 124 | 1 |
252664 | 252664 | 2020-06-19 | Ketchikan Gateway Borough | Alaska | 2130 | 25 | 0 |
252665 | 252665 | 2020-06-19 | Kodiak Island Borough | Alaska | 2150 | 5 | 0 |
252666 | 252666 | 2020-06-19 | Matanuska-Susitna Borough | Alaska | 2170 | 54 | 1 |
252667 | 252667 | 2020-06-19 | Nome Census Area | Alaska | 2180 | 6 | 0 |
252668 | 252668 | 2020-06-19 | North Slope Borough | Alaska | 2185 | 3 | 0 |
252669 | 252669 | 2020-06-19 | Northwest Arctic Borough | Alaska | 2188 | 4 | 0 |
252670 | 252670 | 2020-06-19 | Petersburg Borough | Alaska | 2195 | 3 | 0 |
252671 | 252671 | 2020-06-19 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 2 | 0 |
252672 | 252672 | 2020-06-19 | Sitka City and Borough | Alaska | 2220 | 12 | 0 |
252673 | 252673 | 2020-06-19 | Southeast Fairbanks Census Area | Alaska | 2240 | 7 | 0 |
252674 | 252674 | 2020-06-19 | Unknown | Alaska | 12 | 0 | |
252675 | 252675 | 2020-06-19 | Valdez-Cordova Census Area | Alaska | 2261 | 14 | 0 |
252676 | 252676 | 2020-06-19 | Wrangell City and Borough | Alaska | 2275 | 3 | 0 |
252677 | 252677 | 2020-06-19 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1 | 0 |
252678 | 252678 | 2020-06-19 | Apache | Arizona | 4001 | 2103 | 63 |
252679 | 252679 | 2020-06-19 | Cochise | Arizona | 4003 | 332 | 6 |
252680 | 252680 | 2020-06-19 | Coconino | Arizona | 4005 | 1470 | 90 |
252681 | 252681 | 2020-06-19 | Gila | Arizona | 4007 | 125 | 3 |
252682 | 252682 | 2020-06-19 | Graham | Arizona | 4009 | 59 | 2 |
252683 | 252683 | 2020-06-19 | Greenlee | Arizona | 4011 | 14 | 1 |
252684 | 252684 | 2020-06-19 | La Paz | Arizona | 4012 | 257 | 4 |
252685 | 252685 | 2020-06-19 | Maricopa | Arizona | 4013 | 25999 | 615 |
252686 | 252686 | 2020-06-19 | Mohave | Arizona | 4015 | 686 | 72 |
252687 | 252687 | 2020-06-19 | Navajo | Arizona | 4017 | 2928 | 95 |
252688 | 252688 | 2020-06-19 | Pima | Arizona | 4019 | 5019 | 240 |
252689 | 252689 | 2020-06-19 | Pinal | Arizona | 4021 | 2130 | 49 |
252690 | 252690 | 2020-06-19 | Santa Cruz | Arizona | 4023 | 1297 | 14 |
252691 | 252691 | 2020-06-19 | Yavapai | Arizona | 4025 | 417 | 7 |
252692 | 252692 | 2020-06-19 | Yuma | Arizona | 4027 | 4078 | 61 |
252693 | 252693 | 2020-06-19 | Arkansas | Arkansas | 5001 | 18 | 0 |
252694 | 252694 | 2020-06-19 | Ashley | Arkansas | 5003 | 51 | 1 |
252695 | 252695 | 2020-06-19 | Baxter | Arkansas | 5005 | 14 | 0 |
252696 | 252696 | 2020-06-19 | Benton | Arkansas | 5007 | 1841 | 11 |
252697 | 252697 | 2020-06-19 | Boone | Arkansas | 5009 | 10 | 0 |
252698 | 252698 | 2020-06-19 | Bradley | Arkansas | 5011 | 35 | 2 |
252699 | 252699 | 2020-06-19 | Carroll | Arkansas | 5015 | 102 | 3 |
252700 | 252700 | 2020-06-19 | Chicot | Arkansas | 5017 | 67 | 2 |
252701 | 252701 | 2020-06-19 | Clark | Arkansas | 5019 | 50 | 0 |
252702 | 252702 | 2020-06-19 | Clay | Arkansas | 5021 | 31 | 0 |
252703 | 252703 | 2020-06-19 | Cleburne | Arkansas | 5023 | 76 | 4 |
252704 | 252704 | 2020-06-19 | Cleveland | Arkansas | 5025 | 22 | 0 |
252705 | 252705 | 2020-06-19 | Columbia | Arkansas | 5027 | 31 | 2 |
252706 | 252706 | 2020-06-19 | Conway | Arkansas | 5029 | 26 | 3 |
252707 | 252707 | 2020-06-19 | Craighead | Arkansas | 5031 | 385 | 5 |
252708 | 252708 | 2020-06-19 | Crawford | Arkansas | 5033 | 83 | 0 |
252709 | 252709 | 2020-06-19 | Crittenden | Arkansas | 5035 | 573 | 10 |
252710 | 252710 | 2020-06-19 | Cross | Arkansas | 5037 | 82 | 1 |
252711 | 252711 | 2020-06-19 | Dallas | Arkansas | 5039 | 4 | 0 |
252712 | 252712 | 2020-06-19 | Desha | Arkansas | 5041 | 26 | 0 |
252713 | 252713 | 2020-06-19 | Drew | Arkansas | 5043 | 32 | 1 |
252714 | 252714 | 2020-06-19 | Faulkner | Arkansas | 5045 | 227 | 3 |
252715 | 252715 | 2020-06-19 | Franklin | Arkansas | 5047 | 10 | 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);