ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2021-01-07 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
904398 | 904398 | 2021-01-07 | Alameda | California | 6001 | 57102 | 713 |
904399 | 904399 | 2021-01-07 | Alpine | California | 6003 | 70 | 0 |
904400 | 904400 | 2021-01-07 | Amador | California | 6005 | 2716 | 26 |
904401 | 904401 | 2021-01-07 | Butte | California | 6007 | 8217 | 102 |
904402 | 904402 | 2021-01-07 | Calaveras | California | 6009 | 1321 | 22 |
904403 | 904403 | 2021-01-07 | Colusa | California | 6011 | 1529 | 9 |
904404 | 904404 | 2021-01-07 | Contra Costa | California | 6013 | 44967 | 371 |
904405 | 904405 | 2021-01-07 | Del Norte | California | 6015 | 799 | 2 |
904406 | 904406 | 2021-01-07 | El Dorado | California | 6017 | 6397 | 31 |
904407 | 904407 | 2021-01-07 | Fresno | California | 6019 | 71404 | 711 |
904408 | 904408 | 2021-01-07 | Glenn | California | 6021 | 1887 | 16 |
904409 | 904409 | 2021-01-07 | Humboldt | California | 6023 | 1998 | 23 |
904410 | 904410 | 2021-01-07 | Imperial | California | 6025 | 23400 | 443 |
904411 | 904411 | 2021-01-07 | Inyo | California | 6027 | 630 | 27 |
904412 | 904412 | 2021-01-07 | Kern | California | 6029 | 74732 | 523 |
904413 | 904413 | 2021-01-07 | Kings | California | 6031 | 17086 | 110 |
904414 | 904414 | 2021-01-07 | Lake | California | 6033 | 2033 | 25 |
904415 | 904415 | 2021-01-07 | Lassen | California | 6035 | 4947 | 11 |
904416 | 904416 | 2021-01-07 | Los Angeles | California | 6037 | 871749 | 11545 |
904417 | 904417 | 2021-01-07 | Madera | California | 6039 | 11532 | 126 |
904418 | 904418 | 2021-01-07 | Marin | California | 6041 | 10468 | 143 |
904419 | 904419 | 2021-01-07 | Mariposa | California | 6043 | 296 | 4 |
904420 | 904420 | 2021-01-07 | Mendocino | California | 6045 | 2801 | 31 |
904421 | 904421 | 2021-01-07 | Merced | California | 6047 | 21139 | 275 |
904422 | 904422 | 2021-01-07 | Modoc | California | 6049 | 357 | 3 |
904423 | 904423 | 2021-01-07 | Mono | California | 6051 | 905 | 4 |
904424 | 904424 | 2021-01-07 | Monterey | California | 6053 | 30706 | 229 |
904425 | 904425 | 2021-01-07 | Napa | California | 6055 | 6343 | 33 |
904426 | 904426 | 2021-01-07 | Nevada | California | 6057 | 2854 | 50 |
904427 | 904427 | 2021-01-07 | Orange | California | 6059 | 188013 | 1972 |
904428 | 904428 | 2021-01-07 | Placer | California | 6061 | 15233 | 142 |
904429 | 904429 | 2021-01-07 | Plumas | California | 6063 | 445 | 5 |
904430 | 904430 | 2021-01-07 | Riverside | California | 6065 | 204327 | 2189 |
904431 | 904431 | 2021-01-07 | Sacramento | California | 6067 | 71571 | 955 |
904432 | 904432 | 2021-01-07 | San Benito | California | 6069 | 4127 | 35 |
904433 | 904433 | 2021-01-07 | San Bernardino | California | 6071 | 216394 | 1454 |
904434 | 904434 | 2021-01-07 | San Diego | California | 6073 | 180575 | 1738 |
904435 | 904435 | 2021-01-07 | San Francisco | California | 6075 | 25427 | 205 |
904436 | 904436 | 2021-01-07 | San Joaquin | California | 6077 | 50104 | 696 |
904437 | 904437 | 2021-01-07 | San Luis Obispo | California | 6079 | 12597 | 95 |
904438 | 904438 | 2021-01-07 | San Mateo | California | 6081 | 27050 | 234 |
904439 | 904439 | 2021-01-07 | Santa Barbara | California | 6083 | 19953 | 185 |
904440 | 904440 | 2021-01-07 | Santa Clara | California | 6085 | 78683 | 816 |
904441 | 904441 | 2021-01-07 | Santa Cruz | California | 6087 | 10108 | 104 |
904442 | 904442 | 2021-01-07 | Shasta | California | 6089 | 8741 | 95 |
904443 | 904443 | 2021-01-07 | Sierra | California | 6091 | 31 | 0 |
904444 | 904444 | 2021-01-07 | Siskiyou | California | 6093 | 1280 | 12 |
904445 | 904445 | 2021-01-07 | Solano | California | 6095 | 21860 | 102 |
904446 | 904446 | 2021-01-07 | Sonoma | California | 6097 | 20752 | 214 |
904447 | 904447 | 2021-01-07 | Stanislaus | California | 6099 | 40854 | 657 |
904448 | 904448 | 2021-01-07 | Sutter | California | 6101 | 6921 | 69 |
904449 | 904449 | 2021-01-07 | Tehama | California | 6103 | 3306 | 39 |
904450 | 904450 | 2021-01-07 | Trinity | California | 6105 | 247 | 4 |
904451 | 904451 | 2021-01-07 | Tulare | California | 6107 | 36214 | 442 |
904452 | 904452 | 2021-01-07 | Tuolumne | California | 6109 | 3158 | 23 |
904453 | 904453 | 2021-01-07 | Ventura | California | 6111 | 47428 | 313 |
904454 | 904454 | 2021-01-07 | Yolo | California | 6113 | 9083 | 126 |
904455 | 904455 | 2021-01-07 | Yuba | California | 6115 | 4383 | 25 |
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);