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 108,889
- Virginia 89,958
- Kentucky 80,572
- Missouri 78,017
- Illinois 69,202
- Kansas 68,758
- North Carolina 67,909
- Iowa 67,070
- Tennessee 65,215
- Indiana 62,686
- Ohio 60,290
- Nebraska 59,949
- Minnesota 59,171
- Michigan 56,886
- Mississippi 55,972
- Oklahoma 52,201
- Arkansas 51,432
- Puerto Rico 50,576
- Wisconsin 48,865
- Florida 46,562
- Pennsylvania 45,808
- Alabama 45,612
- Louisiana 44,438
- Colorado 43,127
- South Dakota 43,018
- New York 39,950
- California 39,892
- West Virginia 36,793
- North Dakota 35,153
- Montana 35,112
- South Carolina 31,537
- Idaho 28,784
- Washington 27,022
- Oregon 24,219
- New Mexico 22,120
- Utah 19,949
- Alaska 17,770
- Maryland 17,170
- Wyoming 15,538
- New Jersey 15,239
- Maine 11,414
- Nevada 11,124
- Massachusetts 10,429
- Arizona 10,419
- Vermont 10,273
- New Hampshire 7,523
- Connecticut 6,191
- Rhode Island 4,110
- Hawaii 3,382
- Delaware 2,731
- Virgin Islands 2,184
- Northern Mariana Islands 1,441
- District of Columbia 698
- Guam 690
- American Samoa 139
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2178599 | 2178599 | 2022-02-03 | Lafourche | Louisiana | 22057 | 26695 | 334 |
2178600 | 2178600 | 2022-02-03 | Lincoln | Louisiana | 22061 | 11684 | 126 |
2178601 | 2178601 | 2022-02-03 | Livingston | Louisiana | 22063 | 35555 | 430 |
2178602 | 2178602 | 2022-02-03 | Madison | Louisiana | 22065 | 3181 | 57 |
2178603 | 2178603 | 2022-02-03 | Morehouse | Louisiana | 22067 | 6616 | 125 |
2178604 | 2178604 | 2022-02-03 | Natchitoches | Louisiana | 22069 | 9665 | 152 |
2178605 | 2178605 | 2022-02-03 | Orleans | Louisiana | 22071 | 83800 | 1064 |
2178606 | 2178606 | 2022-02-03 | Ouachita | Louisiana | 22073 | 48538 | 655 |
2178607 | 2178607 | 2022-02-03 | Plaquemines | Louisiana | 22075 | 6262 | 42 |
2178608 | 2178608 | 2022-02-03 | Pointe Coupee | Louisiana | 22077 | 5647 | 86 |
2178609 | 2178609 | 2022-02-03 | Rapides | Louisiana | 22079 | 31595 | 516 |
2178610 | 2178610 | 2022-02-03 | Red River | Louisiana | 22081 | 2051 | 50 |
2178611 | 2178611 | 2022-02-03 | Richland | Louisiana | 22083 | 6209 | 84 |
2178612 | 2178612 | 2022-02-03 | Sabine | Louisiana | 22085 | 6133 | 105 |
2178613 | 2178613 | 2022-02-03 | St. Bernard | Louisiana | 22087 | 10888 | 105 |
2178614 | 2178614 | 2022-02-03 | St. Charles | Louisiana | 22089 | 13451 | 135 |
2178615 | 2178615 | 2022-02-03 | St. Helena | Louisiana | 22091 | 1842 | 21 |
2178616 | 2178616 | 2022-02-03 | St. James | Louisiana | 22093 | 5447 | 74 |
2178617 | 2178617 | 2022-02-03 | St. John the Baptist | Louisiana | 22095 | 10218 | 179 |
2178618 | 2178618 | 2022-02-03 | St. Landry | Louisiana | 22097 | 21180 | 367 |
2178619 | 2178619 | 2022-02-03 | St. Martin | Louisiana | 22099 | 12255 | 173 |
2178620 | 2178620 | 2022-02-03 | St. Mary | Louisiana | 22101 | 12059 | 250 |
2178621 | 2178621 | 2022-02-03 | St. Tammany | Louisiana | 22103 | 69712 | 778 |
2178622 | 2178622 | 2022-02-03 | Tangipahoa | Louisiana | 22105 | 33330 | 557 |
2178623 | 2178623 | 2022-02-03 | Tensas | Louisiana | 22107 | 944 | 10 |
2178624 | 2178624 | 2022-02-03 | Terrebonne | Louisiana | 22109 | 29701 | 381 |
2178625 | 2178625 | 2022-02-03 | Union | Louisiana | 22111 | 6599 | 119 |
2178626 | 2178626 | 2022-02-03 | Unknown | Louisiana | 955 | 0 | |
2178627 | 2178627 | 2022-02-03 | Vermilion | Louisiana | 22113 | 14610 | 205 |
2178628 | 2178628 | 2022-02-03 | Vernon | Louisiana | 22115 | 9372 | 173 |
2178629 | 2178629 | 2022-02-03 | Washington | Louisiana | 22117 | 12432 | 232 |
2178630 | 2178630 | 2022-02-03 | Webster | Louisiana | 22119 | 10692 | 158 |
2178631 | 2178631 | 2022-02-03 | West Baton Rouge | Louisiana | 22121 | 7026 | 82 |
2178632 | 2178632 | 2022-02-03 | West Carroll | Louisiana | 22123 | 3414 | 53 |
2178633 | 2178633 | 2022-02-03 | West Feliciana | Louisiana | 22125 | 2735 | 42 |
2178634 | 2178634 | 2022-02-03 | Winn | Louisiana | 22127 | 4182 | 58 |
2178635 | 2178635 | 2022-02-03 | Androscoggin | Maine | 23001 | 17967 | 192 |
2178636 | 2178636 | 2022-02-03 | Aroostook | Maine | 23003 | 8525 | 116 |
2178637 | 2178637 | 2022-02-03 | Cumberland | Maine | 23005 | 37075 | 300 |
2178638 | 2178638 | 2022-02-03 | Franklin | Maine | 23007 | 4416 | 49 |
2178639 | 2178639 | 2022-02-03 | Hancock | Maine | 23009 | 5206 | 71 |
2178640 | 2178640 | 2022-02-03 | Kennebec | Maine | 23011 | 17185 | 186 |
2178641 | 2178641 | 2022-02-03 | Knox | Maine | 23013 | 4251 | 22 |
2178642 | 2178642 | 2022-02-03 | Lincoln | Maine | 23015 | 3771 | 20 |
2178643 | 2178643 | 2022-02-03 | Oxford | Maine | 23017 | 8817 | 118 |
2178644 | 2178644 | 2022-02-03 | Penobscot | Maine | 23019 | 20090 | 261 |
2178645 | 2178645 | 2022-02-03 | Piscataquis | Maine | 23021 | 2254 | 25 |
2178646 | 2178646 | 2022-02-03 | Sagadahoc | Maine | 23023 | 3718 | 25 |
2178647 | 2178647 | 2022-02-03 | Somerset | Maine | 23025 | 7503 | 84 |
2178648 | 2178648 | 2022-02-03 | Waldo | Maine | 23027 | 4415 | 50 |
2178649 | 2178649 | 2022-02-03 | Washington | Maine | 23029 | 3139 | 45 |
2178650 | 2178650 | 2022-02-03 | York | Maine | 23031 | 30169 | 213 |
2178651 | 2178651 | 2022-02-03 | Allegany | Maryland | 24001 | 15765 | 332 |
2178652 | 2178652 | 2022-02-03 | Anne Arundel | Maryland | 24003 | 84804 | 982 |
2178653 | 2178653 | 2022-02-03 | Baltimore | Maryland | 24005 | 125423 | 2310 |
2178654 | 2178654 | 2022-02-03 | Baltimore city | Maryland | 24510 | 105584 | 1656 |
2178655 | 2178655 | 2022-02-03 | Calvert | Maryland | 24009 | 10512 | 131 |
2178656 | 2178656 | 2022-02-03 | Caroline | Maryland | 24011 | 5728 | 66 |
2178657 | 2178657 | 2022-02-03 | Carroll | Maryland | 24013 | 20127 | 371 |
2178658 | 2178658 | 2022-02-03 | Cecil | Maryland | 24015 | 14451 | 244 |
2178659 | 2178659 | 2022-02-03 | Charles | Maryland | 24017 | 26408 | 324 |
2178660 | 2178660 | 2022-02-03 | Dorchester | Maryland | 24019 | 7258 | 101 |
2178661 | 2178661 | 2022-02-03 | Frederick | Maryland | 24021 | 43018 | 486 |
2178662 | 2178662 | 2022-02-03 | Garrett | Maryland | 24023 | 5230 | 109 |
2178663 | 2178663 | 2022-02-03 | Harford | Maryland | 24025 | 36212 | 537 |
2178664 | 2178664 | 2022-02-03 | Howard | Maryland | 24027 | 41018 | 340 |
2178665 | 2178665 | 2022-02-03 | Kent | Maryland | 24029 | 2900 | 64 |
2178666 | 2178666 | 2022-02-03 | Montgomery | Maryland | 24031 | 158281 | 1927 |
2178667 | 2178667 | 2022-02-03 | Prince George's | Maryland | 24033 | 162277 | 2019 |
2178668 | 2178668 | 2022-02-03 | Queen Anne's | Maryland | 24035 | 6744 | 106 |
2178669 | 2178669 | 2022-02-03 | Somerset | Maryland | 24039 | 4897 | 67 |
2178670 | 2178670 | 2022-02-03 | St. Mary's | Maryland | 24037 | 17733 | 199 |
2178671 | 2178671 | 2022-02-03 | Talbot | Maryland | 24041 | 5230 | 74 |
2178672 | 2178672 | 2022-02-03 | Unknown | Maryland | 1221 | 189 | |
2178673 | 2178673 | 2022-02-03 | Washington | Maryland | 24043 | 32979 | 532 |
2178674 | 2178674 | 2022-02-03 | Wicomico | Maryland | 24045 | 18464 | 298 |
2178675 | 2178675 | 2022-02-03 | Worcester | Maryland | 24047 | 8195 | 147 |
2178676 | 2178676 | 2022-02-03 | Barnstable | Massachusetts | 25001 | 33321 | 632 |
2178677 | 2178677 | 2022-02-03 | Berkshire | Massachusetts | 25003 | 21021 | 381 |
2178678 | 2178678 | 2022-02-03 | Bristol | Massachusetts | 25005 | 144865 | 2316 |
2178679 | 2178679 | 2022-02-03 | Dukes | Massachusetts | 25007 | 3316 | 0 |
2178680 | 2178680 | 2022-02-03 | Essex | Massachusetts | 25009 | 199114 | 2991 |
2178681 | 2178681 | 2022-02-03 | Franklin | Massachusetts | 25011 | 9609 | 153 |
2178682 | 2178682 | 2022-02-03 | Hampden | Massachusetts | 25013 | 127425 | 1951 |
2178683 | 2178683 | 2022-02-03 | Hampshire | Massachusetts | 25015 | 24552 | 381 |
2178684 | 2178684 | 2022-02-03 | Middlesex | Massachusetts | 25017 | 308084 | 4495 |
2178685 | 2178685 | 2022-02-03 | Nantucket | Massachusetts | 25019 | 3274 | 0 |
2178686 | 2178686 | 2022-02-03 | Norfolk | Massachusetts | 25021 | 125418 | 2120 |
2178687 | 2178687 | 2022-02-03 | Plymouth | Massachusetts | 25023 | 111794 | 1866 |
2178688 | 2178688 | 2022-02-03 | Suffolk | Massachusetts | 25025 | 200068 | 2178 |
2178689 | 2178689 | 2022-02-03 | Unknown | Massachusetts | 129879 | 19 | |
2178690 | 2178690 | 2022-02-03 | Worcester | Massachusetts | 25027 | 183964 | 2833 |
2178691 | 2178691 | 2022-02-03 | Alcona | Michigan | 26001 | 1632 | 67 |
2178692 | 2178692 | 2022-02-03 | Alger | Michigan | 26003 | 1789 | 12 |
2178693 | 2178693 | 2022-02-03 | Allegan | Michigan | 26005 | 25878 | 313 |
2178694 | 2178694 | 2022-02-03 | Alpena | Michigan | 26007 | 5248 | 123 |
2178695 | 2178695 | 2022-02-03 | Antrim | Michigan | 26009 | 4078 | 54 |
2178696 | 2178696 | 2022-02-03 | Arenac | Michigan | 26011 | 3029 | 60 |
2178697 | 2178697 | 2022-02-03 | Baraga | Michigan | 26013 | 2110 | 53 |
2178698 | 2178698 | 2022-02-03 | Barry | Michigan | 26015 | 13696 | 148 |
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);