ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
546 rows where "date" is on date 2020-03-17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- California 32
- Florida 28
- New York 28
- Georgia 25
- Washington 23
- Texas 21
- Colorado 18
- Virginia 18
- New Jersey 17
- North Carolina 16
- Ohio 16
- Indiana 15
- Michigan 15
- Minnesota 15
- Pennsylvania 15
- Illinois 14
- Oregon 14
- Louisiana 13
- South Carolina 13
- Maryland 11
- Massachusetts 11
- Wisconsin 11
- Alabama 10
- Tennessee 10
- Iowa 9
- Mississippi 9
- Arkansas 8
- Kentucky 8
- Oklahoma 8
- Utah 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3215 | 3215 | 2020-03-17 | Baldwin | Alabama | 1003 | 1 | 0 |
3216 | 3216 | 2020-03-17 | Elmore | Alabama | 1051 | 2 | 0 |
3217 | 3217 | 2020-03-17 | Jefferson | Alabama | 1073 | 21 | 0 |
3218 | 3218 | 2020-03-17 | Lee | Alabama | 1081 | 3 | 0 |
3219 | 3219 | 2020-03-17 | Limestone | Alabama | 1083 | 1 | 0 |
3220 | 3220 | 2020-03-17 | Madison | Alabama | 1089 | 1 | 0 |
3221 | 3221 | 2020-03-17 | Montgomery | Alabama | 1101 | 2 | 0 |
3222 | 3222 | 2020-03-17 | Shelby | Alabama | 1117 | 4 | 0 |
3223 | 3223 | 2020-03-17 | St. Clair | Alabama | 1115 | 1 | 0 |
3224 | 3224 | 2020-03-17 | Tuscaloosa | Alabama | 1125 | 3 | 0 |
3225 | 3225 | 2020-03-17 | Anchorage | Alaska | 2020 | 2 | 0 |
3226 | 3226 | 2020-03-17 | Fairbanks North Star Borough | Alaska | 2090 | 3 | 0 |
3227 | 3227 | 2020-03-17 | Ketchikan Gateway Borough | Alaska | 2130 | 1 | 0 |
3228 | 3228 | 2020-03-17 | Graham | Arizona | 4009 | 1 | 0 |
3229 | 3229 | 2020-03-17 | Maricopa | Arizona | 4013 | 9 | 0 |
3230 | 3230 | 2020-03-17 | Navajo | Arizona | 4017 | 1 | 0 |
3231 | 3231 | 2020-03-17 | Pima | Arizona | 4019 | 4 | 0 |
3232 | 3232 | 2020-03-17 | Pinal | Arizona | 4021 | 5 | 0 |
3233 | 3233 | 2020-03-17 | Cleburne | Arkansas | 5023 | 1 | 0 |
3234 | 3234 | 2020-03-17 | Cleveland | Arkansas | 5025 | 1 | 0 |
3235 | 3235 | 2020-03-17 | Desha | Arkansas | 5041 | 1 | 0 |
3236 | 3236 | 2020-03-17 | Garland | Arkansas | 5051 | 2 | 0 |
3237 | 3237 | 2020-03-17 | Jefferson | Arkansas | 5069 | 5 | 0 |
3238 | 3238 | 2020-03-17 | Lincoln | Arkansas | 5079 | 1 | 0 |
3239 | 3239 | 2020-03-17 | Pulaski | Arkansas | 5119 | 10 | 0 |
3240 | 3240 | 2020-03-17 | Saline | Arkansas | 5125 | 1 | 0 |
3241 | 3241 | 2020-03-17 | Alameda | California | 6001 | 49 | 0 |
3242 | 3242 | 2020-03-17 | Contra Costa | California | 6013 | 34 | 0 |
3243 | 3243 | 2020-03-17 | Fresno | California | 6019 | 2 | 0 |
3244 | 3244 | 2020-03-17 | Humboldt | California | 6023 | 1 | 0 |
3245 | 3245 | 2020-03-17 | Kern | California | 6029 | 1 | 0 |
3246 | 3246 | 2020-03-17 | Los Angeles | California | 6037 | 144 | 1 |
3247 | 3247 | 2020-03-17 | Madera | California | 6039 | 1 | 0 |
3248 | 3248 | 2020-03-17 | Marin | California | 6041 | 4 | 0 |
3249 | 3249 | 2020-03-17 | Monterey | California | 6053 | 2 | 0 |
3250 | 3250 | 2020-03-17 | Napa | California | 6055 | 1 | 0 |
3251 | 3251 | 2020-03-17 | Nevada | California | 6057 | 1 | 0 |
3252 | 3252 | 2020-03-17 | Orange | California | 6059 | 29 | 0 |
3253 | 3253 | 2020-03-17 | Placer | California | 6061 | 8 | 1 |
3254 | 3254 | 2020-03-17 | Riverside | California | 6065 | 16 | 3 |
3255 | 3255 | 2020-03-17 | Sacramento | California | 6067 | 39 | 2 |
3256 | 3256 | 2020-03-17 | San Benito | California | 6069 | 2 | 1 |
3257 | 3257 | 2020-03-17 | San Bernardino | California | 6071 | 3 | 0 |
3258 | 3258 | 2020-03-17 | San Diego | California | 6073 | 61 | 0 |
3259 | 3259 | 2020-03-17 | San Francisco | California | 6075 | 46 | 0 |
3260 | 3260 | 2020-03-17 | San Joaquin | California | 6077 | 13 | 0 |
3261 | 3261 | 2020-03-17 | San Luis Obispo | California | 6079 | 6 | 0 |
3262 | 3262 | 2020-03-17 | San Mateo | California | 6081 | 64 | 1 |
3263 | 3263 | 2020-03-17 | Santa Barbara | California | 6083 | 2 | 0 |
3264 | 3264 | 2020-03-17 | Santa Clara | California | 6085 | 155 | 5 |
3265 | 3265 | 2020-03-17 | Santa Cruz | California | 6087 | 2 | 0 |
3266 | 3266 | 2020-03-17 | Shasta | California | 6089 | 1 | 0 |
3267 | 3267 | 2020-03-17 | Solano | California | 6095 | 15 | 0 |
3268 | 3268 | 2020-03-17 | Sonoma | California | 6097 | 9 | 0 |
3269 | 3269 | 2020-03-17 | Stanislaus | California | 6099 | 4 | 0 |
3270 | 3270 | 2020-03-17 | Tulare | California | 6107 | 3 | 0 |
3271 | 3271 | 2020-03-17 | Ventura | California | 6111 | 10 | 0 |
3272 | 3272 | 2020-03-17 | Yolo | California | 6113 | 4 | 0 |
3273 | 3273 | 2020-03-17 | Adams | Colorado | 8001 | 10 | 0 |
3274 | 3274 | 2020-03-17 | Arapahoe | Colorado | 8005 | 18 | 0 |
3275 | 3275 | 2020-03-17 | Boulder | Colorado | 8013 | 8 | 0 |
3276 | 3276 | 2020-03-17 | Clear Creek | Colorado | 8019 | 2 | 0 |
3277 | 3277 | 2020-03-17 | Denver | Colorado | 8031 | 41 | 0 |
3278 | 3278 | 2020-03-17 | Douglas | Colorado | 8035 | 9 | 0 |
3279 | 3279 | 2020-03-17 | Eagle | Colorado | 8037 | 34 | 0 |
3280 | 3280 | 2020-03-17 | El Paso | Colorado | 8041 | 6 | 2 |
3281 | 3281 | 2020-03-17 | Garfield | Colorado | 8045 | 2 | 0 |
3282 | 3282 | 2020-03-17 | Gunnison | Colorado | 8051 | 11 | 0 |
3283 | 3283 | 2020-03-17 | Jefferson | Colorado | 8059 | 17 | 0 |
3284 | 3284 | 2020-03-17 | Larimer | Colorado | 8069 | 2 | 0 |
3285 | 3285 | 2020-03-17 | Mesa | Colorado | 8077 | 1 | 0 |
3286 | 3286 | 2020-03-17 | Pitkin | Colorado | 8097 | 11 | 0 |
3287 | 3287 | 2020-03-17 | Pueblo | Colorado | 8101 | 1 | 0 |
3288 | 3288 | 2020-03-17 | Routt | Colorado | 8107 | 2 | 0 |
3289 | 3289 | 2020-03-17 | Summit | Colorado | 8117 | 3 | 0 |
3290 | 3290 | 2020-03-17 | Weld | Colorado | 8123 | 5 | 1 |
3291 | 3291 | 2020-03-17 | Fairfield | Connecticut | 9001 | 48 | 0 |
3292 | 3292 | 2020-03-17 | Hartford | Connecticut | 9003 | 7 | 0 |
3293 | 3293 | 2020-03-17 | Litchfield | Connecticut | 9005 | 5 | 0 |
3294 | 3294 | 2020-03-17 | New Haven | Connecticut | 9009 | 8 | 0 |
3295 | 3295 | 2020-03-17 | New Castle | Delaware | 10003 | 15 | 0 |
3296 | 3296 | 2020-03-17 | Sussex | Delaware | 10005 | 1 | 0 |
3297 | 3297 | 2020-03-17 | District of Columbia | District of Columbia | 11001 | 31 | 0 |
3298 | 3298 | 2020-03-17 | Alachua | Florida | 12001 | 6 | 0 |
3299 | 3299 | 2020-03-17 | Baker | Florida | 12003 | 1 | 0 |
3300 | 3300 | 2020-03-17 | Brevard | Florida | 12009 | 1 | 0 |
3301 | 3301 | 2020-03-17 | Broward | Florida | 12011 | 55 | 1 |
3302 | 3302 | 2020-03-17 | Charlotte | Florida | 12015 | 1 | 0 |
3303 | 3303 | 2020-03-17 | Citrus | Florida | 12017 | 2 | 0 |
3304 | 3304 | 2020-03-17 | Clay | Florida | 12019 | 4 | 0 |
3305 | 3305 | 2020-03-17 | Collier | Florida | 12021 | 7 | 0 |
3306 | 3306 | 2020-03-17 | Duval | Florida | 12031 | 10 | 0 |
3307 | 3307 | 2020-03-17 | Escambia | Florida | 12033 | 1 | 0 |
3308 | 3308 | 2020-03-17 | Hillsborough | Florida | 12057 | 9 | 0 |
3309 | 3309 | 2020-03-17 | Lake | Florida | 12069 | 1 | 0 |
3310 | 3310 | 2020-03-17 | Lee | Florida | 12071 | 7 | 2 |
3311 | 3311 | 2020-03-17 | Manatee | Florida | 12081 | 7 | 1 |
3312 | 3312 | 2020-03-17 | Miami-Dade | Florida | 12086 | 43 | 0 |
3313 | 3313 | 2020-03-17 | Nassau | Florida | 12089 | 1 | 0 |
3314 | 3314 | 2020-03-17 | Okaloosa | Florida | 12091 | 2 | 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);