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
- California 675
- Washington 356
- Florida 353
- Georgia 323
- New York 320
- Texas 288
- Colorado 232
- Illinois 201
- Pennsylvania 192
- New Jersey 191
- North Carolina 190
- Indiana 186
- Virginia 182
- Wisconsin 182
- Massachusetts 172
- Oregon 170
- Ohio 165
- Louisiana 162
- Tennessee 161
- Michigan 158
- Minnesota 158
- South Carolina 150
- Mississippi 143
- Maryland 118
- Kentucky 117
- Utah 105
- Arizona 101
- Iowa 96
- Arkansas 91
- Alabama 84
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6161 | 6161 | 2020-03-21 | Nevada | California | 6057 | 1 | 0 |
6162 | 6162 | 2020-03-21 | Orange | California | 6059 | 78 | 0 |
6163 | 6163 | 2020-03-21 | Placer | California | 6061 | 12 | 1 |
6164 | 6164 | 2020-03-21 | Riverside | California | 6065 | 30 | 5 |
6165 | 6165 | 2020-03-21 | Sacramento | California | 6067 | 52 | 3 |
6166 | 6166 | 2020-03-21 | San Benito | California | 6069 | 5 | 1 |
6167 | 6167 | 2020-03-21 | San Bernardino | California | 6071 | 9 | 0 |
6168 | 6168 | 2020-03-21 | San Diego | California | 6073 | 159 | 0 |
6169 | 6169 | 2020-03-21 | San Francisco | California | 6075 | 84 | 0 |
6170 | 6170 | 2020-03-21 | San Joaquin | California | 6077 | 31 | 2 |
6171 | 6171 | 2020-03-21 | San Luis Obispo | California | 6079 | 27 | 0 |
6172 | 6172 | 2020-03-21 | San Mateo | California | 6081 | 110 | 1 |
6173 | 6173 | 2020-03-21 | Santa Barbara | California | 6083 | 17 | 0 |
6174 | 6174 | 2020-03-21 | Santa Clara | California | 6085 | 263 | 8 |
6175 | 6175 | 2020-03-21 | Santa Cruz | California | 6087 | 15 | 0 |
6176 | 6176 | 2020-03-21 | Shasta | California | 6089 | 2 | 0 |
6177 | 6177 | 2020-03-21 | Siskiyou | California | 6093 | 2 | 0 |
6178 | 6178 | 2020-03-21 | Solano | California | 6095 | 19 | 0 |
6179 | 6179 | 2020-03-21 | Sonoma | California | 6097 | 11 | 1 |
6180 | 6180 | 2020-03-21 | Stanislaus | California | 6099 | 5 | 0 |
6181 | 6181 | 2020-03-21 | Tulare | California | 6107 | 11 | 0 |
6182 | 6182 | 2020-03-21 | Ventura | California | 6111 | 26 | 0 |
6183 | 6183 | 2020-03-21 | Yolo | California | 6113 | 6 | 0 |
6184 | 6184 | 2020-03-21 | Yuba | California | 6115 | 2 | 0 |
6185 | 6185 | 2020-03-21 | Adams | Colorado | 8001 | 14 | 0 |
6186 | 6186 | 2020-03-21 | Arapahoe | Colorado | 8005 | 40 | 0 |
6187 | 6187 | 2020-03-21 | Boulder | Colorado | 8013 | 30 | 0 |
6188 | 6188 | 2020-03-21 | Broomfield | Colorado | 8014 | 1 | 0 |
6189 | 6189 | 2020-03-21 | Chaffee | Colorado | 8015 | 2 | 0 |
6190 | 6190 | 2020-03-21 | Clear Creek | Colorado | 8019 | 3 | 0 |
6191 | 6191 | 2020-03-21 | Crowley | Colorado | 8025 | 1 | 1 |
6192 | 6192 | 2020-03-21 | Denver | Colorado | 8031 | 98 | 0 |
6193 | 6193 | 2020-03-21 | Douglas | Colorado | 8035 | 27 | 0 |
6194 | 6194 | 2020-03-21 | Eagle | Colorado | 8037 | 74 | 1 |
6195 | 6195 | 2020-03-21 | El Paso | Colorado | 8041 | 37 | 3 |
6196 | 6196 | 2020-03-21 | Elbert | Colorado | 8039 | 3 | 0 |
6197 | 6197 | 2020-03-21 | Garfield | Colorado | 8045 | 7 | 0 |
6198 | 6198 | 2020-03-21 | Grand | Colorado | 8049 | 2 | 0 |
6199 | 6199 | 2020-03-21 | Gunnison | Colorado | 8051 | 18 | 0 |
6200 | 6200 | 2020-03-21 | Hinsdale | Colorado | 8053 | 1 | 0 |
6201 | 6201 | 2020-03-21 | Jefferson | Colorado | 8059 | 43 | 0 |
6202 | 6202 | 2020-03-21 | Larimer | Colorado | 8069 | 19 | 0 |
6203 | 6203 | 2020-03-21 | Mesa | Colorado | 8077 | 1 | 0 |
6204 | 6204 | 2020-03-21 | Montrose | Colorado | 8085 | 1 | 0 |
6205 | 6205 | 2020-03-21 | Morgan | Colorado | 8087 | 2 | 0 |
6206 | 6206 | 2020-03-21 | Park | Colorado | 8093 | 1 | 0 |
6207 | 6207 | 2020-03-21 | Pitkin | Colorado | 8097 | 15 | 0 |
6208 | 6208 | 2020-03-21 | Pueblo | Colorado | 8101 | 3 | 0 |
6209 | 6209 | 2020-03-21 | Routt | Colorado | 8107 | 2 | 0 |
6210 | 6210 | 2020-03-21 | San Miguel | Colorado | 8113 | 1 | 0 |
6211 | 6211 | 2020-03-21 | Summit | Colorado | 8117 | 7 | 0 |
6212 | 6212 | 2020-03-21 | Weld | Colorado | 8123 | 21 | 1 |
6213 | 6213 | 2020-03-21 | Yuma | Colorado | 8125 | 1 | 0 |
6214 | 6214 | 2020-03-21 | Fairfield | Connecticut | 9001 | 140 | 4 |
6215 | 6215 | 2020-03-21 | Hartford | Connecticut | 9003 | 35 | 0 |
6216 | 6216 | 2020-03-21 | Litchfield | Connecticut | 9005 | 11 | 0 |
6217 | 6217 | 2020-03-21 | Middlesex | Connecticut | 9007 | 6 | 0 |
6218 | 6218 | 2020-03-21 | New Haven | Connecticut | 9009 | 24 | 0 |
6219 | 6219 | 2020-03-21 | New London | Connecticut | 9011 | 1 | 0 |
6220 | 6220 | 2020-03-21 | Tolland | Connecticut | 9013 | 5 | 1 |
6221 | 6221 | 2020-03-21 | Windham | Connecticut | 9015 | 1 | 0 |
6222 | 6222 | 2020-03-21 | Kent | Delaware | 10001 | 5 | 0 |
6223 | 6223 | 2020-03-21 | New Castle | Delaware | 10003 | 32 | 0 |
6224 | 6224 | 2020-03-21 | Sussex | Delaware | 10005 | 8 | 0 |
6225 | 6225 | 2020-03-21 | District of Columbia | District of Columbia | 11001 | 77 | 1 |
6226 | 6226 | 2020-03-21 | Alachua | Florida | 12001 | 25 | 0 |
6227 | 6227 | 2020-03-21 | Baker | Florida | 12003 | 1 | 0 |
6228 | 6228 | 2020-03-21 | Bay | Florida | 12005 | 1 | 0 |
6229 | 6229 | 2020-03-21 | Brevard | Florida | 12009 | 5 | 0 |
6230 | 6230 | 2020-03-21 | Broward | Florida | 12011 | 164 | 3 |
6231 | 6231 | 2020-03-21 | Charlotte | Florida | 12015 | 2 | 0 |
6232 | 6232 | 2020-03-21 | Citrus | Florida | 12017 | 8 | 0 |
6233 | 6233 | 2020-03-21 | Clay | Florida | 12019 | 6 | 1 |
6234 | 6234 | 2020-03-21 | Collier | Florida | 12021 | 28 | 0 |
6235 | 6235 | 2020-03-21 | Duval | Florida | 12031 | 25 | 2 |
6236 | 6236 | 2020-03-21 | Escambia | Florida | 12033 | 1 | 0 |
6237 | 6237 | 2020-03-21 | Hernando | Florida | 12053 | 5 | 0 |
6238 | 6238 | 2020-03-21 | Highlands | Florida | 12055 | 1 | 0 |
6239 | 6239 | 2020-03-21 | Hillsborough | Florida | 12057 | 47 | 0 |
6240 | 6240 | 2020-03-21 | Indian River | Florida | 12061 | 5 | 0 |
6241 | 6241 | 2020-03-21 | Jackson | Florida | 12063 | 1 | 0 |
6242 | 6242 | 2020-03-21 | Lake | Florida | 12069 | 6 | 0 |
6243 | 6243 | 2020-03-21 | Lee | Florida | 12071 | 17 | 2 |
6244 | 6244 | 2020-03-21 | Leon | Florida | 12073 | 4 | 0 |
6245 | 6245 | 2020-03-21 | Manatee | Florida | 12081 | 13 | 1 |
6246 | 6246 | 2020-03-21 | Marion | Florida | 12083 | 2 | 0 |
6247 | 6247 | 2020-03-21 | Martin | Florida | 12085 | 1 | 0 |
6248 | 6248 | 2020-03-21 | Miami-Dade | Florida | 12086 | 170 | 0 |
6249 | 6249 | 2020-03-21 | Monroe | Florida | 12087 | 1 | 0 |
6250 | 6250 | 2020-03-21 | Nassau | Florida | 12089 | 1 | 0 |
6251 | 6251 | 2020-03-21 | Okaloosa | Florida | 12091 | 12 | 0 |
6252 | 6252 | 2020-03-21 | Orange | Florida | 12095 | 29 | 1 |
6253 | 6253 | 2020-03-21 | Osceola | Florida | 12097 | 21 | 0 |
6254 | 6254 | 2020-03-21 | Palm Beach | Florida | 12099 | 56 | 0 |
6255 | 6255 | 2020-03-21 | Pasco | Florida | 12101 | 8 | 0 |
6256 | 6256 | 2020-03-21 | Pinellas | Florida | 12103 | 29 | 0 |
6257 | 6257 | 2020-03-21 | Polk | Florida | 12105 | 10 | 0 |
6258 | 6258 | 2020-03-21 | Putnam | Florida | 12107 | 1 | 0 |
6259 | 6259 | 2020-03-21 | Santa Rosa | Florida | 12113 | 2 | 1 |
6260 | 6260 | 2020-03-21 | Sarasota | Florida | 12115 | 14 | 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);