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: state, county, fips, date
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1988952 | 1988952 | 2021-12-07 | Graham | Arizona | 4009 | 8680 | 139 |
1988953 | 1988953 | 2021-12-07 | Greenlee | Arizona | 4011 | 1400 | 23 |
1988954 | 1988954 | 2021-12-07 | La Paz | Arizona | 4012 | 3456 | 105 |
1988955 | 1988955 | 2021-12-07 | Maricopa | Arizona | 4013 | 817303 | 12999 |
1988956 | 1988956 | 2021-12-07 | Mohave | Arizona | 4015 | 36779 | 1065 |
1988957 | 1988957 | 2021-12-07 | Navajo | Arizona | 4017 | 25200 | 694 |
1988958 | 1988958 | 2021-12-07 | Pima | Arizona | 4019 | 163219 | 2949 |
1988959 | 1988959 | 2021-12-07 | Pinal | Arizona | 4021 | 83382 | 1204 |
1988960 | 1988960 | 2021-12-07 | Santa Cruz | Arizona | 4023 | 10042 | 198 |
1988961 | 1988961 | 2021-12-07 | Yavapai | Arizona | 4025 | 33772 | 840 |
1988962 | 1988962 | 2021-12-07 | Yuma | Arizona | 4027 | 43107 | 938 |
1988963 | 1988963 | 2021-12-07 | Arkansas | Arkansas | 5001 | 3549 | 61 |
1988964 | 1988964 | 2021-12-07 | Ashley | Arkansas | 5003 | 3245 | 51 |
1988965 | 1988965 | 2021-12-07 | Baxter | Arkansas | 5005 | 6322 | 192 |
1988966 | 1988966 | 2021-12-07 | Benton | Arkansas | 5007 | 44431 | 644 |
1988967 | 1988967 | 2021-12-07 | Boone | Arkansas | 5009 | 6594 | 132 |
1988968 | 1988968 | 2021-12-07 | Bradley | Arkansas | 5011 | 2036 | 41 |
1988969 | 1988969 | 2021-12-07 | Calhoun | Arkansas | 5013 | 608 | 8 |
1988970 | 1988970 | 2021-12-07 | Carroll | Arkansas | 5015 | 4450 | 78 |
1988971 | 1988971 | 2021-12-07 | Chicot | Arkansas | 5017 | 2036 | 47 |
1988972 | 1988972 | 2021-12-07 | Clark | Arkansas | 5019 | 3402 | 63 |
1988973 | 1988973 | 2021-12-07 | Clay | Arkansas | 5021 | 2848 | 77 |
1988974 | 1988974 | 2021-12-07 | Cleburne | Arkansas | 5023 | 4057 | 95 |
1988975 | 1988975 | 2021-12-07 | Cleveland | Arkansas | 5025 | 1449 | 33 |
1988976 | 1988976 | 2021-12-07 | Columbia | Arkansas | 5027 | 3424 | 75 |
1988977 | 1988977 | 2021-12-07 | Conway | Arkansas | 5029 | 3311 | 46 |
1988978 | 1988978 | 2021-12-07 | Craighead | Arkansas | 5031 | 22515 | 251 |
1988979 | 1988979 | 2021-12-07 | Crawford | Arkansas | 5033 | 11138 | 181 |
1988980 | 1988980 | 2021-12-07 | Crittenden | Arkansas | 5035 | 9055 | 185 |
1988981 | 1988981 | 2021-12-07 | Cross | Arkansas | 5037 | 3063 | 68 |
1988982 | 1988982 | 2021-12-07 | Dallas | Arkansas | 5039 | 1151 | 19 |
1988983 | 1988983 | 2021-12-07 | Desha | Arkansas | 5041 | 1965 | 33 |
1988984 | 1988984 | 2021-12-07 | Drew | Arkansas | 5043 | 2971 | 56 |
1988985 | 1988985 | 2021-12-07 | Faulkner | Arkansas | 5045 | 20584 | 228 |
1988986 | 1988986 | 2021-12-07 | Franklin | Arkansas | 5047 | 2830 | 56 |
1988987 | 1988987 | 2021-12-07 | Fulton | Arkansas | 5049 | 1933 | 69 |
1988988 | 1988988 | 2021-12-07 | Garland | Arkansas | 5051 | 16238 | 405 |
1988989 | 1988989 | 2021-12-07 | Grant | Arkansas | 5053 | 2943 | 51 |
1988990 | 1988990 | 2021-12-07 | Greene | Arkansas | 5055 | 10547 | 128 |
1988991 | 1988991 | 2021-12-07 | Hempstead | Arkansas | 5057 | 3063 | 44 |
1988992 | 1988992 | 2021-12-07 | Hot Spring | Arkansas | 5059 | 7813 | 111 |
1988993 | 1988993 | 2021-12-07 | Howard | Arkansas | 5061 | 2565 | 39 |
1988994 | 1988994 | 2021-12-07 | Independence | Arkansas | 5063 | 7033 | 161 |
1988995 | 1988995 | 2021-12-07 | Izard | Arkansas | 5065 | 2759 | 55 |
1988996 | 1988996 | 2021-12-07 | Jackson | Arkansas | 5067 | 4606 | 47 |
1988997 | 1988997 | 2021-12-07 | Jefferson | Arkansas | 5069 | 12511 | 231 |
1988998 | 1988998 | 2021-12-07 | Johnson | Arkansas | 5071 | 4734 | 59 |
1988999 | 1988999 | 2021-12-07 | Lafayette | Arkansas | 5073 | 869 | 28 |
1989000 | 1989000 | 2021-12-07 | Lawrence | Arkansas | 5075 | 3508 | 62 |
1989001 | 1989001 | 2021-12-07 | Lee | Arkansas | 5077 | 2214 | 53 |
1989002 | 1989002 | 2021-12-07 | Lincoln | Arkansas | 5079 | 3729 | 58 |
1989003 | 1989003 | 2021-12-07 | Little River | Arkansas | 5081 | 2132 | 82 |
1989004 | 1989004 | 2021-12-07 | Logan | Arkansas | 5083 | 3750 | 52 |
1989005 | 1989005 | 2021-12-07 | Lonoke | Arkansas | 5085 | 12552 | 176 |
1989006 | 1989006 | 2021-12-07 | Madison | Arkansas | 5087 | 2712 | 40 |
1989007 | 1989007 | 2021-12-07 | Marion | Arkansas | 5089 | 2408 | 63 |
1989008 | 1989008 | 2021-12-07 | Miller | Arkansas | 5091 | 6712 | 151 |
1989009 | 1989009 | 2021-12-07 | Mississippi | Arkansas | 5093 | 8788 | 152 |
1989010 | 1989010 | 2021-12-07 | Monroe | Arkansas | 5095 | 1207 | 25 |
1989011 | 1989011 | 2021-12-07 | Montgomery | Arkansas | 5097 | 1162 | 47 |
1989012 | 1989012 | 2021-12-07 | Nevada | Arkansas | 5099 | 1419 | 41 |
1989013 | 1989013 | 2021-12-07 | Newton | Arkansas | 5101 | 1255 | 41 |
1989014 | 1989014 | 2021-12-07 | Ouachita | Arkansas | 5103 | 3490 | 86 |
1989015 | 1989015 | 2021-12-07 | Perry | Arkansas | 5105 | 1618 | 22 |
1989016 | 1989016 | 2021-12-07 | Phillips | Arkansas | 5107 | 3260 | 78 |
1989017 | 1989017 | 2021-12-07 | Pike | Arkansas | 5109 | 1768 | 37 |
1989018 | 1989018 | 2021-12-07 | Poinsett | Arkansas | 5111 | 5193 | 102 |
1989019 | 1989019 | 2021-12-07 | Polk | Arkansas | 5113 | 3017 | 112 |
1989020 | 1989020 | 2021-12-07 | Pope | Arkansas | 5115 | 12392 | 159 |
1989021 | 1989021 | 2021-12-07 | Prairie | Arkansas | 5117 | 1298 | 29 |
1989022 | 1989022 | 2021-12-07 | Pulaski | Arkansas | 5119 | 60701 | 940 |
1989023 | 1989023 | 2021-12-07 | Randolph | Arkansas | 5121 | 3508 | 64 |
1989024 | 1989024 | 2021-12-07 | Saline | Arkansas | 5125 | 19110 | 247 |
1989025 | 1989025 | 2021-12-07 | Scott | Arkansas | 5127 | 1771 | 32 |
1989026 | 1989026 | 2021-12-07 | Searcy | Arkansas | 5129 | 1344 | 26 |
1989027 | 1989027 | 2021-12-07 | Sebastian | Arkansas | 5131 | 23427 | 398 |
1989028 | 1989028 | 2021-12-07 | Sevier | Arkansas | 5133 | 4134 | 61 |
1989029 | 1989029 | 2021-12-07 | Sharp | Arkansas | 5135 | 3194 | 71 |
1989030 | 1989030 | 2021-12-07 | St. Francis | Arkansas | 5123 | 4908 | 70 |
1989031 | 1989031 | 2021-12-07 | Stone | Arkansas | 5137 | 1966 | 46 |
1989032 | 1989032 | 2021-12-07 | Union | Arkansas | 5139 | 6051 | 144 |
1989033 | 1989033 | 2021-12-07 | Unknown | Arkansas | 5766 | 0 | |
1989034 | 1989034 | 2021-12-07 | Van Buren | Arkansas | 5141 | 2343 | 44 |
1989035 | 1989035 | 2021-12-07 | Washington | Arkansas | 5143 | 46100 | 502 |
1989036 | 1989036 | 2021-12-07 | White | Arkansas | 5145 | 14075 | 207 |
1989037 | 1989037 | 2021-12-07 | Woodruff | Arkansas | 5147 | 1148 | 24 |
1989038 | 1989038 | 2021-12-07 | Yell | Arkansas | 5149 | 4812 | 84 |
1989039 | 1989039 | 2021-12-07 | Alameda | California | 6001 | 126368 | 1514 |
1989040 | 1989040 | 2021-12-07 | Alpine | California | 6003 | 108 | 0 |
1989041 | 1989041 | 2021-12-07 | Amador | California | 6005 | 5839 | 67 |
1989042 | 1989042 | 2021-12-07 | Butte | California | 6007 | 25702 | 321 |
1989043 | 1989043 | 2021-12-07 | Calaveras | California | 6009 | 4508 | 88 |
1989044 | 1989044 | 2021-12-07 | Colusa | California | 6011 | 3298 | 21 |
1989045 | 1989045 | 2021-12-07 | Contra Costa | California | 6013 | 104721 | 1058 |
1989046 | 1989046 | 2021-12-07 | Del Norte | California | 6015 | 3898 | 42 |
1989047 | 1989047 | 2021-12-07 | El Dorado | California | 6017 | 18553 | 168 |
1989048 | 1989048 | 2021-12-07 | Fresno | California | 6019 | 158274 | 2285 |
1989049 | 1989049 | 2021-12-07 | Glenn | California | 6021 | 4603 | 51 |
1989050 | 1989050 | 2021-12-07 | Humboldt | California | 6023 | 10369 | 119 |
1989051 | 1989051 | 2021-12-07 | Imperial | California | 6025 | 39179 | 777 |
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);