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 2022-02-10 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2200406 | 2200406 | 2022-02-10 | Alameda | California | 6001 | 255990 | 1678 |
2200407 | 2200407 | 2022-02-10 | Alpine | California | 6003 | 125 | 0 |
2200408 | 2200408 | 2022-02-10 | Amador | California | 6005 | 8691 | 76 |
2200409 | 2200409 | 2022-02-10 | Butte | California | 6007 | 37734 | 359 |
2200410 | 2200410 | 2022-02-10 | Calaveras | California | 6009 | 7385 | 101 |
2200411 | 2200411 | 2022-02-10 | Colusa | California | 6011 | 4376 | 21 |
2200412 | 2200412 | 2022-02-10 | Contra Costa | California | 6013 | 192753 | 1132 |
2200413 | 2200413 | 2022-02-10 | Del Norte | California | 6015 | 5591 | 44 |
2200414 | 2200414 | 2022-02-10 | El Dorado | California | 6017 | 28664 | 186 |
2200415 | 2200415 | 2022-02-10 | Fresno | California | 6019 | 239589 | 2502 |
2200416 | 2200416 | 2022-02-10 | Glenn | California | 6021 | 6321 | 58 |
2200417 | 2200417 | 2022-02-10 | Humboldt | California | 6023 | 18698 | 135 |
2200418 | 2200418 | 2022-02-10 | Imperial | California | 6025 | 63472 | 854 |
2200419 | 2200419 | 2022-02-10 | Inyo | California | 6027 | 4437 | 52 |
2200420 | 2200420 | 2022-02-10 | Kern | California | 6029 | 225509 | 2051 |
2200421 | 2200421 | 2022-02-10 | Kings | California | 6031 | 51984 | 415 |
2200422 | 2200422 | 2022-02-10 | Lake | California | 6033 | 10623 | 125 |
2200423 | 2200423 | 2022-02-10 | Lassen | California | 6035 | 10355 | 64 |
2200424 | 2200424 | 2022-02-10 | Los Angeles | California | 6037 | 2747570 | 29690 |
2200425 | 2200425 | 2022-02-10 | Madera | California | 6039 | 41202 | 330 |
2200426 | 2200426 | 2022-02-10 | Marin | California | 6041 | 35401 | 255 |
2200427 | 2200427 | 2022-02-10 | Mariposa | California | 6043 | 2867 | 20 |
2200428 | 2200428 | 2022-02-10 | Mendocino | California | 6045 | 15071 | 109 |
2200429 | 2200429 | 2022-02-10 | Merced | California | 6047 | 68563 | 763 |
2200430 | 2200430 | 2022-02-10 | Modoc | California | 6049 | 927 | 6 |
2200431 | 2200431 | 2022-02-10 | Mono | California | 6051 | 3053 | 5 |
2200432 | 2200432 | 2022-02-10 | Monterey | California | 6053 | 87421 | 680 |
2200433 | 2200433 | 2022-02-10 | Napa | California | 6055 | 25369 | 121 |
2200434 | 2200434 | 2022-02-10 | Nevada | California | 6057 | 16665 | 117 |
2200435 | 2200435 | 2022-02-10 | Orange | California | 6059 | 574435 | 6308 |
2200436 | 2200436 | 2022-02-10 | Placer | California | 6061 | 67664 | 553 |
2200437 | 2200437 | 2022-02-10 | Plumas | California | 6063 | 2960 | 13 |
2200438 | 2200438 | 2022-02-10 | Riverside | California | 6065 | 601081 | 6030 |
2200439 | 2200439 | 2022-02-10 | Sacramento | California | 6067 | 292105 | 2802 |
2200440 | 2200440 | 2022-02-10 | San Benito | California | 6069 | 13012 | 91 |
2200441 | 2200441 | 2022-02-10 | San Bernardino | California | 6071 | 571655 | 6335 |
2200442 | 2200442 | 2022-02-10 | San Diego | California | 6073 | 764619 | 4832 |
2200443 | 2200443 | 2022-02-10 | San Francisco | California | 6075 | 127290 | 731 |
2200444 | 2200444 | 2022-02-10 | San Joaquin | California | 6077 | 170046 | 2005 |
2200445 | 2200445 | 2022-02-10 | San Luis Obispo | California | 6079 | 53668 | 410 |
2200446 | 2200446 | 2022-02-10 | San Mateo | California | 6081 | 122346 | 665 |
2200447 | 2200447 | 2022-02-10 | Santa Barbara | California | 6083 | 87363 | 629 |
2200448 | 2200448 | 2022-02-10 | Santa Clara | California | 6085 | 309945 | 2092 |
2200449 | 2200449 | 2022-02-10 | Santa Cruz | California | 6087 | 46241 | 239 |
2200450 | 2200450 | 2022-02-10 | Shasta | California | 6089 | 35384 | 537 |
2200451 | 2200451 | 2022-02-10 | Sierra | California | 6091 | 310 | 0 |
2200452 | 2200452 | 2022-02-10 | Siskiyou | California | 6093 | 7005 | 91 |
2200453 | 2200453 | 2022-02-10 | Solano | California | 6095 | 82547 | 421 |
2200454 | 2200454 | 2022-02-10 | Sonoma | California | 6097 | 81316 | 455 |
2200455 | 2200455 | 2022-02-10 | Stanislaus | California | 6099 | 131631 | 1587 |
2200456 | 2200456 | 2022-02-10 | Sutter | California | 6101 | 21524 | 217 |
2200457 | 2200457 | 2022-02-10 | Tehama | California | 6103 | 14076 | 149 |
2200458 | 2200458 | 2022-02-10 | Trinity | California | 6105 | 1384 | 20 |
2200459 | 2200459 | 2022-02-10 | Tulare | California | 6107 | 127156 | 1270 |
2200460 | 2200460 | 2022-02-10 | Tuolumne | California | 6109 | 12494 | 164 |
2200461 | 2200461 | 2022-02-10 | Ventura | California | 6111 | 177527 | 1338 |
2200462 | 2200462 | 2022-02-10 | Yolo | California | 6113 | 37689 | 281 |
2200463 | 2200463 | 2022-02-10 | Yuba | California | 6115 | 16831 | 107 |
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);