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-11-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 |
---|---|---|---|---|---|---|---|
1891533 | 1891533 | 2021-11-07 | Alameda | California | 6001 | 122492 | 1457 |
1891534 | 1891534 | 2021-11-07 | Alpine | California | 6003 | 105 | 0 |
1891535 | 1891535 | 2021-11-07 | Amador | California | 6005 | 5620 | 66 |
1891536 | 1891536 | 2021-11-07 | Butte | California | 6007 | 24635 | 288 |
1891537 | 1891537 | 2021-11-07 | Calaveras | California | 6009 | 4164 | 82 |
1891538 | 1891538 | 2021-11-07 | Colusa | California | 6011 | 3149 | 19 |
1891539 | 1891539 | 2021-11-07 | Contra Costa | California | 6013 | 101547 | 1025 |
1891540 | 1891540 | 2021-11-07 | Del Norte | California | 6015 | 3750 | 42 |
1891541 | 1891541 | 2021-11-07 | El Dorado | California | 6017 | 17682 | 156 |
1891542 | 1891542 | 2021-11-07 | Fresno | California | 6019 | 151513 | 2170 |
1891543 | 1891543 | 2021-11-07 | Glenn | California | 6021 | 4485 | 46 |
1891544 | 1891544 | 2021-11-07 | Humboldt | California | 6023 | 9558 | 116 |
1891545 | 1891545 | 2021-11-07 | Imperial | California | 6025 | 36821 | 765 |
1891546 | 1891546 | 2021-11-07 | Inyo | California | 6027 | 2391 | 41 |
1891547 | 1891547 | 2021-11-07 | Kern | California | 6029 | 151432 | 1706 |
1891548 | 1891548 | 2021-11-07 | Kings | California | 6031 | 34104 | 344 |
1891549 | 1891549 | 2021-11-07 | Lake | California | 6033 | 6840 | 106 |
1891550 | 1891550 | 2021-11-07 | Lassen | California | 6035 | 7748 | 52 |
1891551 | 1891551 | 2021-11-07 | Los Angeles | California | 6037 | 1503380 | 26750 |
1891552 | 1891552 | 2021-11-07 | Madera | California | 6039 | 25022 | 291 |
1891553 | 1891553 | 2021-11-07 | Marin | California | 6041 | 17976 | 247 |
1891554 | 1891554 | 2021-11-07 | Mariposa | California | 6043 | 1462 | 17 |
1891555 | 1891555 | 2021-11-07 | Mendocino | California | 6045 | 8032 | 90 |
1891556 | 1891556 | 2021-11-07 | Merced | California | 6047 | 44060 | 606 |
1891557 | 1891557 | 2021-11-07 | Modoc | California | 6049 | 935 | 9 |
1891558 | 1891558 | 2021-11-07 | Mono | California | 6051 | 1744 | 4 |
1891559 | 1891559 | 2021-11-07 | Monterey | California | 6053 | 51482 | 606 |
1891560 | 1891560 | 2021-11-07 | Napa | California | 6055 | 13066 | 103 |
1891561 | 1891561 | 2021-11-07 | Nevada | California | 6057 | 9486 | 91 |
1891562 | 1891562 | 2021-11-07 | Orange | California | 6059 | 328210 | 5615 |
1891563 | 1891563 | 2021-11-07 | Placer | California | 6061 | 40716 | 438 |
1891564 | 1891564 | 2021-11-07 | Plumas | California | 6063 | 1796 | 7 |
1891565 | 1891565 | 2021-11-07 | Riverside | California | 6065 | 377743 | 5240 |
1891566 | 1891566 | 2021-11-07 | Sacramento | California | 6067 | 163644 | 2359 |
1891567 | 1891567 | 2021-11-07 | San Benito | California | 6069 | 7607 | 75 |
1891568 | 1891568 | 2021-11-07 | San Bernardino | California | 6071 | 364509 | 5815 |
1891569 | 1891569 | 2021-11-07 | San Diego | California | 6073 | 395126 | 4246 |
1891570 | 1891570 | 2021-11-07 | San Francisco | California | 6075 | 55266 | 666 |
1891571 | 1891571 | 2021-11-07 | San Joaquin | California | 6077 | 104857 | 1782 |
1891572 | 1891572 | 2021-11-07 | San Luis Obispo | California | 6079 | 30599 | 350 |
1891573 | 1891573 | 2021-11-07 | San Mateo | California | 6081 | 55023 | 626 |
1891574 | 1891574 | 2021-11-07 | Santa Barbara | California | 6083 | 45996 | 532 |
1891575 | 1891575 | 2021-11-07 | Santa Clara | California | 6085 | 147918 | 1895 |
1891576 | 1891576 | 2021-11-07 | Santa Cruz | California | 6087 | 21394 | 222 |
1891577 | 1891577 | 2021-11-07 | Shasta | California | 6089 | 25006 | 384 |
1891578 | 1891578 | 2021-11-07 | Sierra | California | 6091 | 203 | 0 |
1891579 | 1891579 | 2021-11-07 | Siskiyou | California | 6093 | 4765 | 66 |
1891580 | 1891580 | 2021-11-07 | Solano | California | 6095 | 46702 | 350 |
1891581 | 1891581 | 2021-11-07 | Sonoma | California | 6097 | 41931 | 408 |
1891582 | 1891582 | 2021-11-07 | Stanislaus | California | 6099 | 87998 | 1359 |
1891583 | 1891583 | 2021-11-07 | Sutter | California | 6101 | 14260 | 180 |
1891584 | 1891584 | 2021-11-07 | Tehama | California | 6103 | 10000 | 120 |
1891585 | 1891585 | 2021-11-07 | Trinity | California | 6105 | 928 | 11 |
1891586 | 1891586 | 2021-11-07 | Tulare | California | 6107 | 83440 | 1010 |
1891587 | 1891587 | 2021-11-07 | Tuolumne | California | 6109 | 7438 | 129 |
1891588 | 1891588 | 2021-11-07 | Ventura | California | 6111 | 102195 | 1180 |
1891589 | 1891589 | 2021-11-07 | Yolo | California | 6113 | 20989 | 255 |
1891590 | 1891590 | 2021-11-07 | Yuba | California | 6115 | 10842 | 83 |
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);