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,807
- 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,402
- 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,145
- Wyoming 15,538
- New Jersey 15,239
- Maine 11,398
- Nevada 11,124
- Arizona 10,419
- Massachusetts 10,414
- 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 |
---|---|---|---|---|---|---|---|
2178770 | 2178770 | 2022-02-03 | Unknown | Michigan | 10232 | 32 | |
2178771 | 2178771 | 2022-02-03 | Van Buren | Michigan | 26159 | 16297 | 244 |
2178772 | 2178772 | 2022-02-03 | Washtenaw | Michigan | 26161 | 69968 | 486 |
2178773 | 2178773 | 2022-02-03 | Wayne | Michigan | 26163 | 382633 | 7224 |
2178774 | 2178774 | 2022-02-03 | Wexford | Michigan | 26165 | 6586 | 96 |
2178775 | 2178775 | 2022-02-03 | Aitkin | Minnesota | 27001 | 2765 | 59 |
2178776 | 2178776 | 2022-02-03 | Anoka | Minnesota | 27003 | 93899 | 743 |
2178777 | 2178777 | 2022-02-03 | Becker | Minnesota | 27005 | 8045 | 86 |
2178778 | 2178778 | 2022-02-03 | Beltrami | Minnesota | 27007 | 10712 | 114 |
2178779 | 2178779 | 2022-02-03 | Benton | Minnesota | 27009 | 13047 | 162 |
2178780 | 2178780 | 2022-02-03 | Big Stone | Minnesota | 27011 | 1291 | 8 |
2178781 | 2178781 | 2022-02-03 | Blue Earth | Minnesota | 27013 | 16517 | 88 |
2178782 | 2178782 | 2022-02-03 | Brown | Minnesota | 27015 | 6219 | 71 |
2178783 | 2178783 | 2022-02-03 | Carlton | Minnesota | 27017 | 7998 | 84 |
2178784 | 2178784 | 2022-02-03 | Carver | Minnesota | 27019 | 25086 | 102 |
2178785 | 2178785 | 2022-02-03 | Cass | Minnesota | 27021 | 6385 | 70 |
2178786 | 2178786 | 2022-02-03 | Chippewa | Minnesota | 27023 | 2860 | 46 |
2178787 | 2178787 | 2022-02-03 | Chisago | Minnesota | 27025 | 13558 | 114 |
2178788 | 2178788 | 2022-02-03 | Clay | Minnesota | 27027 | 17804 | 117 |
2178789 | 2178789 | 2022-02-03 | Clearwater | Minnesota | 27029 | 2001 | 29 |
2178790 | 2178790 | 2022-02-03 | Cook | Minnesota | 27031 | 509 | 2 |
2178791 | 2178791 | 2022-02-03 | Cottonwood | Minnesota | 27033 | 3042 | 38 |
2178792 | 2178792 | 2022-02-03 | Crow Wing | Minnesota | 27035 | 14875 | 154 |
2178793 | 2178793 | 2022-02-03 | Dakota | Minnesota | 27037 | 103806 | 717 |
2178794 | 2178794 | 2022-02-03 | Dodge | Minnesota | 27039 | 5319 | 15 |
2178795 | 2178795 | 2022-02-03 | Douglas | Minnesota | 27041 | 10234 | 112 |
2178796 | 2178796 | 2022-02-03 | Faribault | Minnesota | 27043 | 3548 | 46 |
2178797 | 2178797 | 2022-02-03 | Fillmore | Minnesota | 27045 | 4353 | 21 |
2178798 | 2178798 | 2022-02-03 | Freeborn | Minnesota | 27047 | 8478 | 65 |
2178799 | 2178799 | 2022-02-03 | Goodhue | Minnesota | 27049 | 12123 | 116 |
2178800 | 2178800 | 2022-02-03 | Grant | Minnesota | 27051 | 1374 | 12 |
2178801 | 2178801 | 2022-02-03 | Hennepin | Minnesota | 27053 | 282382 | 2395 |
2178802 | 2178802 | 2022-02-03 | Houston | Minnesota | 27055 | 3937 | 18 |
2178803 | 2178803 | 2022-02-03 | Hubbard | Minnesota | 27057 | 4601 | 56 |
2178804 | 2178804 | 2022-02-03 | Isanti | Minnesota | 27059 | 9596 | 109 |
2178805 | 2178805 | 2022-02-03 | Itasca | Minnesota | 27061 | 10301 | 129 |
2178806 | 2178806 | 2022-02-03 | Jackson | Minnesota | 27063 | 2063 | 16 |
2178807 | 2178807 | 2022-02-03 | Kanabec | Minnesota | 27065 | 3313 | 53 |
2178808 | 2178808 | 2022-02-03 | Kandiyohi | Minnesota | 27067 | 12578 | 129 |
2178809 | 2178809 | 2022-02-03 | Kittson | Minnesota | 27069 | 983 | 26 |
2178810 | 2178810 | 2022-02-03 | Koochiching | Minnesota | 27071 | 2498 | 34 |
2178811 | 2178811 | 2022-02-03 | Lac qui Parle | Minnesota | 27073 | 1624 | 28 |
2178812 | 2178812 | 2022-02-03 | Lake | Minnesota | 27075 | 1905 | 26 |
2178813 | 2178813 | 2022-02-03 | Lake of the Woods | Minnesota | 27077 | 708 | 5 |
2178814 | 2178814 | 2022-02-03 | Le Sueur | Minnesota | 27079 | 6075 | 47 |
2178815 | 2178815 | 2022-02-03 | Lincoln | Minnesota | 27081 | 1167 | 5 |
2178816 | 2178816 | 2022-02-03 | Lyon | Minnesota | 27083 | 6805 | 70 |
2178817 | 2178817 | 2022-02-03 | Mahnomen | Minnesota | 27087 | 1450 | 17 |
2178818 | 2178818 | 2022-02-03 | Marshall | Minnesota | 27089 | 1905 | 23 |
2178819 | 2178819 | 2022-02-03 | Martin | Minnesota | 27091 | 5193 | 54 |
2178820 | 2178820 | 2022-02-03 | McLeod | Minnesota | 27085 | 9867 | 98 |
2178821 | 2178821 | 2022-02-03 | Meeker | Minnesota | 27093 | 5558 | 73 |
2178822 | 2178822 | 2022-02-03 | Mille Lacs | Minnesota | 27095 | 6830 | 103 |
2178823 | 2178823 | 2022-02-03 | Morrison | Minnesota | 27097 | 8542 | 94 |
2178824 | 2178824 | 2022-02-03 | Mower | Minnesota | 27099 | 11266 | 60 |
2178825 | 2178825 | 2022-02-03 | Murray | Minnesota | 27101 | 1947 | 15 |
2178826 | 2178826 | 2022-02-03 | Nicollet | Minnesota | 27103 | 7412 | 66 |
2178827 | 2178827 | 2022-02-03 | Nobles | Minnesota | 27105 | 6668 | 57 |
2178828 | 2178828 | 2022-02-03 | Norman | Minnesota | 27107 | 1389 | 13 |
2178829 | 2178829 | 2022-02-03 | Olmsted | Minnesota | 27109 | 37455 | 153 |
2178830 | 2178830 | 2022-02-03 | Otter Tail | Minnesota | 27111 | 12545 | 155 |
2178831 | 2178831 | 2022-02-03 | Pennington | Minnesota | 27113 | 3263 | 36 |
2178832 | 2178832 | 2022-02-03 | Pine | Minnesota | 27115 | 6593 | 59 |
2178833 | 2178833 | 2022-02-03 | Pipestone | Minnesota | 27117 | 1907 | 33 |
2178834 | 2178834 | 2022-02-03 | Polk | Minnesota | 27119 | 7853 | 95 |
2178835 | 2178835 | 2022-02-03 | Pope | Minnesota | 27121 | 2762 | 16 |
2178836 | 2178836 | 2022-02-03 | Ramsey | Minnesota | 27123 | 117123 | 1257 |
2178837 | 2178837 | 2022-02-03 | Red Lake | Minnesota | 27125 | 886 | 11 |
2178838 | 2178838 | 2022-02-03 | Redwood | Minnesota | 27127 | 3663 | 51 |
2178839 | 2178839 | 2022-02-03 | Renville | Minnesota | 27129 | 3403 | 53 |
2178840 | 2178840 | 2022-02-03 | Rice | Minnesota | 27131 | 16667 | 163 |
2178841 | 2178841 | 2022-02-03 | Rock | Minnesota | 27133 | 2257 | 32 |
2178842 | 2178842 | 2022-02-03 | Roseau | Minnesota | 27135 | 4228 | 41 |
2178843 | 2178843 | 2022-02-03 | Scott | Minnesota | 27139 | 38069 | 236 |
2178844 | 2178844 | 2022-02-03 | Sherburne | Minnesota | 27141 | 26109 | 168 |
2178845 | 2178845 | 2022-02-03 | Sibley | Minnesota | 27143 | 3288 | 23 |
2178846 | 2178846 | 2022-02-03 | St. Louis | Minnesota | 27137 | 42901 | 491 |
2178847 | 2178847 | 2022-02-03 | Stearns | Minnesota | 27145 | 47974 | 344 |
2178848 | 2178848 | 2022-02-03 | Steele | Minnesota | 27147 | 9719 | 50 |
2178849 | 2178849 | 2022-02-03 | Stevens | Minnesota | 27149 | 2454 | 12 |
2178850 | 2178850 | 2022-02-03 | Swift | Minnesota | 27151 | 2122 | 31 |
2178851 | 2178851 | 2022-02-03 | Todd | Minnesota | 27153 | 6263 | 54 |
2178852 | 2178852 | 2022-02-03 | Traverse | Minnesota | 27155 | 752 | 9 |
2178853 | 2178853 | 2022-02-03 | Unknown | Minnesota | 7666 | 150 | |
2178854 | 2178854 | 2022-02-03 | Wabasha | Minnesota | 27157 | 5159 | 15 |
2178855 | 2178855 | 2022-02-03 | Wadena | Minnesota | 27159 | 3892 | 48 |
2178856 | 2178856 | 2022-02-03 | Waseca | Minnesota | 27161 | 5209 | 38 |
2178857 | 2178857 | 2022-02-03 | Washington | Minnesota | 27163 | 63020 | 450 |
2178858 | 2178858 | 2022-02-03 | Watonwan | Minnesota | 27165 | 2707 | 22 |
2178859 | 2178859 | 2022-02-03 | Wilkin | Minnesota | 27167 | 1507 | 20 |
2178860 | 2178860 | 2022-02-03 | Winona | Minnesota | 27169 | 11580 | 67 |
2178861 | 2178861 | 2022-02-03 | Wright | Minnesota | 27171 | 34806 | 291 |
2178862 | 2178862 | 2022-02-03 | Yellow Medicine | Minnesota | 27173 | 2385 | 27 |
2178863 | 2178863 | 2022-02-03 | Adams | Mississippi | 28001 | 6554 | 133 |
2178864 | 2178864 | 2022-02-03 | Alcorn | Mississippi | 28003 | 9318 | 136 |
2178865 | 2178865 | 2022-02-03 | Amite | Mississippi | 28005 | 2999 | 61 |
2178866 | 2178866 | 2022-02-03 | Attala | Mississippi | 28007 | 4514 | 98 |
2178867 | 2178867 | 2022-02-03 | Benton | Mississippi | 28009 | 2142 | 46 |
2178868 | 2178868 | 2022-02-03 | Bolivar | Mississippi | 28011 | 8612 | 160 |
2178869 | 2178869 | 2022-02-03 | Calhoun | Mississippi | 28013 | 4367 | 56 |
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);