ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-10-05" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
599399 | 599399 | 2020-10-05 | Alameda | California | 6001 | 21767 | 425 |
599400 | 599400 | 2020-10-05 | Alpine | California | 6003 | 2 | 0 |
599401 | 599401 | 2020-10-05 | Amador | California | 6005 | 296 | 16 |
599402 | 599402 | 2020-10-05 | Butte | California | 6007 | 2903 | 45 |
599403 | 599403 | 2020-10-05 | Calaveras | California | 6009 | 324 | 14 |
599404 | 599404 | 2020-10-05 | Colusa | California | 6011 | 539 | 6 |
599405 | 599405 | 2020-10-05 | Contra Costa | California | 6013 | 17322 | 213 |
599406 | 599406 | 2020-10-05 | Del Norte | California | 6015 | 152 | 1 |
599407 | 599407 | 2020-10-05 | El Dorado | California | 6017 | 1196 | 4 |
599408 | 599408 | 2020-10-05 | Fresno | California | 6019 | 29065 | 399 |
599409 | 599409 | 2020-10-05 | Glenn | California | 6021 | 601 | 3 |
599410 | 599410 | 2020-10-05 | Humboldt | California | 6023 | 522 | 8 |
599411 | 599411 | 2020-10-05 | Imperial | California | 6025 | 12076 | 325 |
599412 | 599412 | 2020-10-05 | Inyo | California | 6027 | 195 | 15 |
599413 | 599413 | 2020-10-05 | Kern | California | 6029 | 32522 | 386 |
599414 | 599414 | 2020-10-05 | Kings | California | 6031 | 7919 | 82 |
599415 | 599415 | 2020-10-05 | Lake | California | 6033 | 589 | 11 |
599416 | 599416 | 2020-10-05 | Lassen | California | 6035 | 744 | 0 |
599417 | 599417 | 2020-10-05 | Los Angeles | California | 6037 | 274942 | 6654 |
599418 | 599418 | 2020-10-05 | Madera | California | 6039 | 4706 | 70 |
599419 | 599419 | 2020-10-05 | Marin | California | 6041 | 6798 | 119 |
599420 | 599420 | 2020-10-05 | Mariposa | California | 6043 | 76 | 2 |
599421 | 599421 | 2020-10-05 | Mendocino | California | 6045 | 1010 | 20 |
599422 | 599422 | 2020-10-05 | Merced | California | 6047 | 9081 | 148 |
599423 | 599423 | 2020-10-05 | Modoc | California | 6049 | 28 | 0 |
599424 | 599424 | 2020-10-05 | Mono | California | 6051 | 169 | 2 |
599425 | 599425 | 2020-10-05 | Monterey | California | 6053 | 10402 | 75 |
599426 | 599426 | 2020-10-05 | Napa | California | 6055 | 1760 | 13 |
599427 | 599427 | 2020-10-05 | Nevada | California | 6057 | 550 | 7 |
599428 | 599428 | 2020-10-05 | Orange | California | 6059 | 56346 | 1287 |
599429 | 599429 | 2020-10-05 | Placer | California | 6061 | 3684 | 49 |
599430 | 599430 | 2020-10-05 | Plumas | California | 6063 | 49 | 0 |
599431 | 599431 | 2020-10-05 | Riverside | California | 6065 | 60738 | 1238 |
599432 | 599432 | 2020-10-05 | Sacramento | California | 6067 | 23244 | 432 |
599433 | 599433 | 2020-10-05 | San Benito | California | 6069 | 1367 | 12 |
599434 | 599434 | 2020-10-05 | San Bernardino | California | 6071 | 56400 | 962 |
599435 | 599435 | 2020-10-05 | San Diego | California | 6073 | 48723 | 803 |
599436 | 599436 | 2020-10-05 | San Francisco | California | 6075 | 11483 | 108 |
599437 | 599437 | 2020-10-05 | San Joaquin | California | 6077 | 20569 | 471 |
599438 | 599438 | 2020-10-05 | San Luis Obispo | California | 6079 | 3742 | 31 |
599439 | 599439 | 2020-10-05 | San Mateo | California | 6081 | 10275 | 152 |
599440 | 599440 | 2020-10-05 | Santa Barbara | California | 6083 | 9319 | 115 |
599441 | 599441 | 2020-10-05 | Santa Clara | California | 6085 | 21926 | 346 |
599442 | 599442 | 2020-10-05 | Santa Cruz | California | 6087 | 2519 | 12 |
599443 | 599443 | 2020-10-05 | Shasta | California | 6089 | 1158 | 22 |
599444 | 599444 | 2020-10-05 | Sierra | California | 6091 | 6 | 0 |
599445 | 599445 | 2020-10-05 | Siskiyou | California | 6093 | 171 | 0 |
599446 | 599446 | 2020-10-05 | Solano | California | 6095 | 6606 | 72 |
599447 | 599447 | 2020-10-05 | Sonoma | California | 6097 | 7940 | 122 |
599448 | 599448 | 2020-10-05 | Stanislaus | California | 6099 | 16759 | 374 |
599449 | 599449 | 2020-10-05 | Sutter | California | 6101 | 1763 | 12 |
599450 | 599450 | 2020-10-05 | Tehama | California | 6103 | 637 | 7 |
599451 | 599451 | 2020-10-05 | Trinity | California | 6105 | 22 | 0 |
599452 | 599452 | 2020-10-05 | Tulare | California | 6107 | 16490 | 265 |
599453 | 599453 | 2020-10-05 | Tuolumne | California | 6109 | 233 | 4 |
599454 | 599454 | 2020-10-05 | Ventura | California | 6111 | 13197 | 154 |
599455 | 599455 | 2020-10-05 | Yolo | California | 6113 | 2893 | 56 |
599456 | 599456 | 2020-10-05 | Yuba | California | 6115 | 1207 | 10 |
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);