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 72,336
- Georgia 48,409
- Virginia 39,679
- Kentucky 35,212
- Missouri 33,790
- Illinois 30,277
- North Carolina 30,109
- Iowa 29,270
- Kansas 28,981
- Tennessee 28,927
- Indiana 27,910
- Ohio 26,690
- Minnesota 25,907
- Michigan 25,134
- Mississippi 24,976
- Nebraska 24,536
- Oklahoma 22,718
- Arkansas 22,704
- Wisconsin 21,647
- Florida 20,858
- Puerto Rico 20,714
- Pennsylvania 20,482
- Alabama 20,286
- Louisiana 19,833
- Colorado 18,935
- South Dakota 18,070
- New York 18,026
- California 17,961
- West Virginia 16,001
- North Dakota 14,741
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
950882 | 950882 | 2021-01-21 | Middlesex | Massachusetts | 25017 | 95512 | 3004 |
950883 | 950883 | 2021-01-21 | Nantucket | Massachusetts | 25019 | 1013 | 2 |
950884 | 950884 | 2021-01-21 | Norfolk | Massachusetts | 25021 | 36599 | 1416 |
950885 | 950885 | 2021-01-21 | Plymouth | Massachusetts | 25023 | 32974 | 1118 |
950886 | 950886 | 2021-01-21 | Suffolk | Massachusetts | 25025 | 67004 | 1506 |
950887 | 950887 | 2021-01-21 | Unknown | Massachusetts | 24652 | 8 | |
950888 | 950888 | 2021-01-21 | Worcester | Massachusetts | 25027 | 55257 | 1744 |
950889 | 950889 | 2021-01-21 | Alcona | Michigan | 26001 | 391 | 22 |
950890 | 950890 | 2021-01-21 | Alger | Michigan | 26003 | 536 | 3 |
950891 | 950891 | 2021-01-21 | Allegan | Michigan | 26005 | 6671 | 97 |
950892 | 950892 | 2021-01-21 | Alpena | Michigan | 26007 | 1384 | 43 |
950893 | 950893 | 2021-01-21 | Antrim | Michigan | 26009 | 808 | 17 |
950894 | 950894 | 2021-01-21 | Arenac | Michigan | 26011 | 684 | 23 |
950895 | 950895 | 2021-01-21 | Baraga | Michigan | 26013 | 742 | 31 |
950896 | 950896 | 2021-01-21 | Barry | Michigan | 26015 | 3409 | 40 |
950897 | 950897 | 2021-01-21 | Bay | Michigan | 26017 | 6941 | 246 |
950898 | 950898 | 2021-01-21 | Benzie | Michigan | 26019 | 817 | 29 |
950899 | 950899 | 2021-01-21 | Berrien | Michigan | 26021 | 10501 | 217 |
950900 | 950900 | 2021-01-21 | Branch | Michigan | 26023 | 4345 | 102 |
950901 | 950901 | 2021-01-21 | Calhoun | Michigan | 26025 | 8609 | 208 |
950902 | 950902 | 2021-01-21 | Cass | Michigan | 26027 | 3603 | 56 |
950903 | 950903 | 2021-01-21 | Charlevoix | Michigan | 26029 | 952 | 11 |
950904 | 950904 | 2021-01-21 | Cheboygan | Michigan | 26031 | 844 | 34 |
950905 | 950905 | 2021-01-21 | Chippewa | Michigan | 26033 | 4542 | 34 |
950906 | 950906 | 2021-01-21 | Clare | Michigan | 26035 | 1420 | 64 |
950907 | 950907 | 2021-01-21 | Clinton | Michigan | 26037 | 4559 | 53 |
950908 | 950908 | 2021-01-21 | Crawford | Michigan | 26039 | 527 | 5 |
950909 | 950909 | 2021-01-21 | Delta | Michigan | 26041 | 3046 | 80 |
950910 | 950910 | 2021-01-21 | Dickinson | Michigan | 26043 | 2300 | 70 |
950911 | 950911 | 2021-01-21 | Eaton | Michigan | 26045 | 5547 | 122 |
950912 | 950912 | 2021-01-21 | Emmet | Michigan | 26047 | 1346 | 34 |
950913 | 950913 | 2021-01-21 | Genesee | Michigan | 26049 | 23839 | 689 |
950914 | 950914 | 2021-01-21 | Gladwin | Michigan | 26051 | 1367 | 38 |
950915 | 950915 | 2021-01-21 | Gogebic | Michigan | 26053 | 1106 | 39 |
950916 | 950916 | 2021-01-21 | Grand Traverse | Michigan | 26055 | 3792 | 54 |
950917 | 950917 | 2021-01-21 | Gratiot | Michigan | 26057 | 5511 | 95 |
950918 | 950918 | 2021-01-21 | Hillsdale | Michigan | 26059 | 3027 | 69 |
950919 | 950919 | 2021-01-21 | Houghton | Michigan | 26061 | 2380 | 36 |
950920 | 950920 | 2021-01-21 | Huron | Michigan | 26063 | 1900 | 53 |
950921 | 950921 | 2021-01-21 | Ingham | Michigan | 26065 | 14405 | 237 |
950922 | 950922 | 2021-01-21 | Ionia | Michigan | 26067 | 6004 | 62 |
950923 | 950923 | 2021-01-21 | Iosco | Michigan | 26069 | 1219 | 62 |
950924 | 950924 | 2021-01-21 | Iron | Michigan | 26071 | 897 | 41 |
950925 | 950925 | 2021-01-21 | Isabella | Michigan | 26073 | 3776 | 64 |
950926 | 950926 | 2021-01-21 | Jackson | Michigan | 26075 | 13036 | 223 |
950927 | 950927 | 2021-01-21 | Kalamazoo | Michigan | 26077 | 13787 | 292 |
950928 | 950928 | 2021-01-21 | Kalkaska | Michigan | 26079 | 532 | 14 |
950929 | 950929 | 2021-01-21 | Kent | Michigan | 26081 | 48035 | 626 |
950930 | 950930 | 2021-01-21 | Keweenaw | Michigan | 26083 | 122 | 2 |
950931 | 950931 | 2021-01-21 | Lake | Michigan | 26085 | 339 | 10 |
950932 | 950932 | 2021-01-21 | Lapeer | Michigan | 26087 | 4966 | 118 |
950933 | 950933 | 2021-01-21 | Leelanau | Michigan | 26089 | 790 | 10 |
950934 | 950934 | 2021-01-21 | Lenawee | Michigan | 26091 | 6811 | 92 |
950935 | 950935 | 2021-01-21 | Livingston | Michigan | 26093 | 9275 | 104 |
950936 | 950936 | 2021-01-21 | Luce | Michigan | 26095 | 1057 | 1 |
950937 | 950937 | 2021-01-21 | Mackinac | Michigan | 26097 | 412 | 3 |
950938 | 950938 | 2021-01-21 | Macomb | Michigan | 26099 | 54692 | 1795 |
950939 | 950939 | 2021-01-21 | Manistee | Michigan | 26101 | 948 | 20 |
950940 | 950940 | 2021-01-21 | Marquette | Michigan | 26103 | 4684 | 54 |
950941 | 950941 | 2021-01-21 | Mason | Michigan | 26105 | 1142 | 23 |
950942 | 950942 | 2021-01-21 | Mecosta | Michigan | 26107 | 1818 | 17 |
950943 | 950943 | 2021-01-21 | Menominee | Michigan | 26109 | 1819 | 36 |
950944 | 950944 | 2021-01-21 | Midland | Michigan | 26111 | 4569 | 53 |
950945 | 950945 | 2021-01-21 | Missaukee | Michigan | 26113 | 638 | 15 |
950946 | 950946 | 2021-01-21 | Monroe | Michigan | 26115 | 8825 | 171 |
950947 | 950947 | 2021-01-21 | Montcalm | Michigan | 26117 | 5403 | 84 |
950948 | 950948 | 2021-01-21 | Montmorency | Michigan | 26119 | 344 | 14 |
950949 | 950949 | 2021-01-21 | Muskegon | Michigan | 26121 | 12199 | 299 |
950950 | 950950 | 2021-01-21 | Newaygo | Michigan | 26123 | 2557 | 40 |
950951 | 950951 | 2021-01-21 | Oakland | Michigan | 26125 | 68496 | 1838 |
950952 | 950952 | 2021-01-21 | Oceana | Michigan | 26127 | 1772 | 45 |
950953 | 950953 | 2021-01-21 | Ogemaw | Michigan | 26129 | 1018 | 31 |
950954 | 950954 | 2021-01-21 | Ontonagon | Michigan | 26131 | 336 | 17 |
950955 | 950955 | 2021-01-21 | Osceola | Michigan | 26133 | 960 | 20 |
950956 | 950956 | 2021-01-21 | Oscoda | Michigan | 26135 | 345 | 19 |
950957 | 950957 | 2021-01-21 | Otsego | Michigan | 26137 | 1088 | 25 |
950958 | 950958 | 2021-01-21 | Ottawa | Michigan | 26139 | 20626 | 317 |
950959 | 950959 | 2021-01-21 | Presque Isle | Michigan | 26141 | 595 | 23 |
950960 | 950960 | 2021-01-21 | Roscommon | Michigan | 26143 | 1059 | 29 |
950961 | 950961 | 2021-01-21 | Saginaw | Michigan | 26145 | 14784 | 460 |
950962 | 950962 | 2021-01-21 | Sanilac | Michigan | 26151 | 1776 | 69 |
950963 | 950963 | 2021-01-21 | Schoolcraft | Michigan | 26153 | 248 | 5 |
950964 | 950964 | 2021-01-21 | Shiawassee | Michigan | 26155 | 3432 | 67 |
950965 | 950965 | 2021-01-21 | St. Clair | Michigan | 26147 | 8011 | 211 |
950966 | 950966 | 2021-01-21 | St. Joseph | Michigan | 26149 | 4226 | 70 |
950967 | 950967 | 2021-01-21 | Tuscola | Michigan | 26157 | 2961 | 120 |
950968 | 950968 | 2021-01-21 | Unknown | Michigan | 0 | 18 | |
950969 | 950969 | 2021-01-21 | Van Buren | Michigan | 26159 | 4591 | 92 |
950970 | 950970 | 2021-01-21 | Washtenaw | Michigan | 26161 | 16341 | 228 |
950971 | 950971 | 2021-01-21 | Wayne | Michigan | 26163 | 94118 | 3902 |
950972 | 950972 | 2021-01-21 | Wexford | Michigan | 26165 | 1216 | 20 |
950973 | 950973 | 2021-01-21 | Aitkin | Minnesota | 27001 | 1085 | 33 |
950974 | 950974 | 2021-01-21 | Anoka | Minnesota | 27003 | 31118 | 366 |
950975 | 950975 | 2021-01-21 | Becker | Minnesota | 27005 | 2869 | 39 |
950976 | 950976 | 2021-01-21 | Beltrami | Minnesota | 27007 | 3132 | 48 |
950977 | 950977 | 2021-01-21 | Benton | Minnesota | 27009 | 4215 | 87 |
950978 | 950978 | 2021-01-21 | Big Stone | Minnesota | 27011 | 466 | 3 |
950979 | 950979 | 2021-01-21 | Blue Earth | Minnesota | 27013 | 5448 | 33 |
950980 | 950980 | 2021-01-21 | Brown | Minnesota | 27015 | 2158 | 34 |
950981 | 950981 | 2021-01-21 | Carlton | Minnesota | 27017 | 2822 | 43 |
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);