ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where "date" is on date 2020-05-08 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
124439 | 124439 | 2020-05-08 | Alameda | California | 6001 | 1982 | 70 |
124440 | 124440 | 2020-05-08 | Alpine | California | 6003 | 2 | 0 |
124441 | 124441 | 2020-05-08 | Amador | California | 6005 | 7 | 0 |
124442 | 124442 | 2020-05-08 | Butte | California | 6007 | 19 | 0 |
124443 | 124443 | 2020-05-08 | Calaveras | California | 6009 | 13 | 0 |
124444 | 124444 | 2020-05-08 | Colusa | California | 6011 | 3 | 0 |
124445 | 124445 | 2020-05-08 | Contra Costa | California | 6013 | 1014 | 29 |
124446 | 124446 | 2020-05-08 | Del Norte | California | 6015 | 3 | 0 |
124447 | 124447 | 2020-05-08 | El Dorado | California | 6017 | 54 | 0 |
124448 | 124448 | 2020-05-08 | Fresno | California | 6019 | 841 | 9 |
124449 | 124449 | 2020-05-08 | Glenn | California | 6021 | 6 | 0 |
124450 | 124450 | 2020-05-08 | Humboldt | California | 6023 | 55 | 0 |
124451 | 124451 | 2020-05-08 | Imperial | California | 6025 | 512 | 11 |
124452 | 124452 | 2020-05-08 | Inyo | California | 6027 | 20 | 1 |
124453 | 124453 | 2020-05-08 | Kern | California | 6029 | 1176 | 15 |
124454 | 124454 | 2020-05-08 | Kings | California | 6031 | 265 | 1 |
124455 | 124455 | 2020-05-08 | Lake | California | 6033 | 8 | 0 |
124456 | 124456 | 2020-05-08 | Los Angeles | California | 6037 | 30296 | 1468 |
124457 | 124457 | 2020-05-08 | Madera | California | 6039 | 66 | 2 |
124458 | 124458 | 2020-05-08 | Marin | California | 6041 | 252 | 14 |
124459 | 124459 | 2020-05-08 | Mariposa | California | 6043 | 15 | 0 |
124460 | 124460 | 2020-05-08 | Mendocino | California | 6045 | 12 | 0 |
124461 | 124461 | 2020-05-08 | Merced | California | 6047 | 163 | 3 |
124462 | 124462 | 2020-05-08 | Mono | California | 6051 | 29 | 1 |
124463 | 124463 | 2020-05-08 | Monterey | California | 6053 | 249 | 6 |
124464 | 124464 | 2020-05-08 | Napa | California | 6055 | 79 | 2 |
124465 | 124465 | 2020-05-08 | Nevada | California | 6057 | 41 | 1 |
124466 | 124466 | 2020-05-08 | Orange | California | 6059 | 3283 | 71 |
124467 | 124467 | 2020-05-08 | Placer | California | 6061 | 165 | 8 |
124468 | 124468 | 2020-05-08 | Plumas | California | 6063 | 4 | 0 |
124469 | 124469 | 2020-05-08 | Riverside | California | 6065 | 4817 | 204 |
124470 | 124470 | 2020-05-08 | Sacramento | California | 6067 | 1159 | 50 |
124471 | 124471 | 2020-05-08 | San Benito | California | 6069 | 55 | 2 |
124472 | 124472 | 2020-05-08 | San Bernardino | California | 6071 | 2629 | 111 |
124473 | 124473 | 2020-05-08 | San Diego | California | 6073 | 4725 | 189 |
124474 | 124474 | 2020-05-08 | San Francisco | California | 6075 | 1856 | 33 |
124475 | 124475 | 2020-05-08 | San Joaquin | California | 6077 | 597 | 28 |
124476 | 124476 | 2020-05-08 | San Luis Obispo | California | 6079 | 212 | 1 |
124477 | 124477 | 2020-05-08 | San Mateo | California | 6081 | 1398 | 57 |
124478 | 124478 | 2020-05-08 | Santa Barbara | California | 6083 | 1032 | 11 |
124479 | 124479 | 2020-05-08 | Santa Clara | California | 6085 | 2290 | 129 |
124480 | 124480 | 2020-05-08 | Santa Cruz | California | 6087 | 140 | 2 |
124481 | 124481 | 2020-05-08 | Shasta | California | 6089 | 31 | 4 |
124482 | 124482 | 2020-05-08 | Siskiyou | California | 6093 | 5 | 0 |
124483 | 124483 | 2020-05-08 | Solano | California | 6095 | 356 | 7 |
124484 | 124484 | 2020-05-08 | Sonoma | California | 6097 | 300 | 4 |
124485 | 124485 | 2020-05-08 | Stanislaus | California | 6099 | 488 | 19 |
124486 | 124486 | 2020-05-08 | Sutter | California | 6101 | 32 | 2 |
124487 | 124487 | 2020-05-08 | Tehama | California | 6103 | 1 | 1 |
124488 | 124488 | 2020-05-08 | Tulare | California | 6107 | 1013 | 44 |
124489 | 124489 | 2020-05-08 | Tuolumne | California | 6109 | 2 | 0 |
124490 | 124490 | 2020-05-08 | Ventura | California | 6111 | 652 | 19 |
124491 | 124491 | 2020-05-08 | Yolo | California | 6113 | 172 | 20 |
124492 | 124492 | 2020-05-08 | Yuba | California | 6115 | 20 | 1 |
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);