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 2020-12-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 |
---|---|---|---|---|---|---|---|
813524 | 813524 | 2020-12-10 | Alameda | California | 6001 | 35068 | 533 |
813525 | 813525 | 2020-12-10 | Alpine | California | 6003 | 58 | 0 |
813526 | 813526 | 2020-12-10 | Amador | California | 6005 | 1120 | 18 |
813527 | 813527 | 2020-12-10 | Butte | California | 6007 | 4829 | 64 |
813528 | 813528 | 2020-12-10 | Calaveras | California | 6009 | 670 | 22 |
813529 | 813529 | 2020-12-10 | Colusa | California | 6011 | 908 | 7 |
813530 | 813530 | 2020-12-10 | Contra Costa | California | 6013 | 28487 | 273 |
813531 | 813531 | 2020-12-10 | Del Norte | California | 6015 | 489 | 1 |
813532 | 813532 | 2020-12-10 | El Dorado | California | 6017 | 3449 | 8 |
813533 | 813533 | 2020-12-10 | Fresno | California | 6019 | 41954 | 514 |
813534 | 813534 | 2020-12-10 | Glenn | California | 6021 | 1107 | 11 |
813535 | 813535 | 2020-12-10 | Humboldt | California | 6023 | 1195 | 10 |
813536 | 813536 | 2020-12-10 | Imperial | California | 6025 | 17913 | 370 |
813537 | 813537 | 2020-12-10 | Inyo | California | 6027 | 356 | 16 |
813538 | 813538 | 2020-12-10 | Kern | California | 6029 | 48401 | 463 |
813539 | 813539 | 2020-12-10 | Kings | California | 6031 | 12913 | 97 |
813540 | 813540 | 2020-12-10 | Lake | California | 6033 | 1158 | 22 |
813541 | 813541 | 2020-12-10 | Lassen | California | 6035 | 2972 | 5 |
813542 | 813542 | 2020-12-10 | Los Angeles | California | 6037 | 488055 | 8149 |
813543 | 813543 | 2020-12-10 | Madera | California | 6039 | 7468 | 107 |
813544 | 813544 | 2020-12-10 | Marin | California | 6041 | 8314 | 132 |
813545 | 813545 | 2020-12-10 | Mariposa | California | 6043 | 171 | 4 |
813546 | 813546 | 2020-12-10 | Mendocino | California | 6045 | 1911 | 24 |
813547 | 813547 | 2020-12-10 | Merced | California | 6047 | 14310 | 202 |
813548 | 813548 | 2020-12-10 | Modoc | California | 6049 | 225 | 0 |
813549 | 813549 | 2020-12-10 | Mono | California | 6051 | 601 | 3 |
813550 | 813550 | 2020-12-10 | Monterey | California | 6053 | 17891 | 148 |
813551 | 813551 | 2020-12-10 | Napa | California | 6055 | 3936 | 23 |
813552 | 813552 | 2020-12-10 | Nevada | California | 6057 | 1922 | 21 |
813553 | 813553 | 2020-12-10 | Orange | California | 6059 | 96948 | 1640 |
813554 | 813554 | 2020-12-10 | Placer | California | 6061 | 8860 | 89 |
813555 | 813555 | 2020-12-10 | Plumas | California | 6063 | 271 | 0 |
813556 | 813556 | 2020-12-10 | Riverside | California | 6065 | 111053 | 1551 |
813557 | 813557 | 2020-12-10 | Sacramento | California | 6067 | 46478 | 659 |
813558 | 813558 | 2020-12-10 | San Benito | California | 6069 | 2314 | 19 |
813559 | 813559 | 2020-12-10 | San Bernardino | California | 6071 | 115641 | 1209 |
813560 | 813560 | 2020-12-10 | San Diego | California | 6073 | 99662 | 1114 |
813561 | 813561 | 2020-12-10 | San Francisco | California | 6075 | 17631 | 165 |
813562 | 813562 | 2020-12-10 | San Joaquin | California | 6077 | 30816 | 535 |
813563 | 813563 | 2020-12-10 | San Luis Obispo | California | 6079 | 7267 | 45 |
813564 | 813564 | 2020-12-10 | San Mateo | California | 6081 | 16884 | 177 |
813565 | 813565 | 2020-12-10 | Santa Barbara | California | 6083 | 12808 | 140 |
813566 | 813566 | 2020-12-10 | Santa Clara | California | 6085 | 44039 | 520 |
813567 | 813567 | 2020-12-10 | Santa Cruz | California | 6087 | 5527 | 50 |
813568 | 813568 | 2020-12-10 | Shasta | California | 6089 | 6375 | 58 |
813569 | 813569 | 2020-12-10 | Sierra | California | 6091 | 18 | 0 |
813570 | 813570 | 2020-12-10 | Siskiyou | California | 6093 | 900 | 7 |
813571 | 813571 | 2020-12-10 | Solano | California | 6095 | 12538 | 91 |
813572 | 813572 | 2020-12-10 | Sonoma | California | 6097 | 14168 | 162 |
813573 | 813573 | 2020-12-10 | Stanislaus | California | 6099 | 27615 | 458 |
813574 | 813574 | 2020-12-10 | Sutter | California | 6101 | 4574 | 31 |
813575 | 813575 | 2020-12-10 | Tehama | California | 6103 | 2102 | 30 |
813576 | 813576 | 2020-12-10 | Trinity | California | 6105 | 200 | 1 |
813577 | 813577 | 2020-12-10 | Tulare | California | 6107 | 24624 | 326 |
813578 | 813578 | 2020-12-10 | Tuolumne | California | 6109 | 1517 | 16 |
813579 | 813579 | 2020-12-10 | Ventura | California | 6111 | 23897 | 197 |
813580 | 813580 | 2020-12-10 | Yolo | California | 6113 | 5774 | 89 |
813581 | 813581 | 2020-12-10 | Yuba | California | 6115 | 2780 | 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);