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-12-01 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1969540 | 1969540 | 2021-12-01 | Alameda | California | 6001 | 125257 | 1507 |
1969541 | 1969541 | 2021-12-01 | Alpine | California | 6003 | 108 | 0 |
1969542 | 1969542 | 2021-12-01 | Amador | California | 6005 | 5782 | 66 |
1969543 | 1969543 | 2021-12-01 | Butte | California | 6007 | 25476 | 318 |
1969544 | 1969544 | 2021-12-01 | Calaveras | California | 6009 | 4422 | 88 |
1969545 | 1969545 | 2021-12-01 | Colusa | California | 6011 | 3259 | 21 |
1969546 | 1969546 | 2021-12-01 | Contra Costa | California | 6013 | 103869 | 1046 |
1969547 | 1969547 | 2021-12-01 | Del Norte | California | 6015 | 3860 | 42 |
1969548 | 1969548 | 2021-12-01 | El Dorado | California | 6017 | 18325 | 166 |
1969549 | 1969549 | 2021-12-01 | Fresno | California | 6019 | 156897 | 2259 |
1969550 | 1969550 | 2021-12-01 | Glenn | California | 6021 | 4574 | 51 |
1969551 | 1969551 | 2021-12-01 | Humboldt | California | 6023 | 10183 | 119 |
1969552 | 1969552 | 2021-12-01 | Imperial | California | 6025 | 38516 | 772 |
1969553 | 1969553 | 2021-12-01 | Inyo | California | 6027 | 2568 | 46 |
1969554 | 1969554 | 2021-12-01 | Kern | California | 6029 | 157875 | 1804 |
1969555 | 1969555 | 2021-12-01 | Kings | California | 6031 | 35221 | 365 |
1969556 | 1969556 | 2021-12-01 | Lake | California | 6033 | 7046 | 110 |
1969557 | 1969557 | 2021-12-01 | Lassen | California | 6035 | 7967 | 58 |
1969558 | 1969558 | 2021-12-01 | Los Angeles | California | 6037 | 1529290 | 27184 |
1969559 | 1969559 | 2021-12-01 | Madera | California | 6039 | 26233 | 311 |
1969560 | 1969560 | 2021-12-01 | Marin | California | 6041 | 18495 | 249 |
1969561 | 1969561 | 2021-12-01 | Mariposa | California | 6043 | 1607 | 18 |
1969562 | 1969562 | 2021-12-01 | Mendocino | California | 6045 | 8577 | 99 |
1969563 | 1969563 | 2021-12-01 | Merced | California | 6047 | 45539 | 674 |
1969564 | 1969564 | 2021-12-01 | Modoc | California | 6049 | 1050 | 10 |
1969565 | 1969565 | 2021-12-01 | Mono | California | 6051 | 1892 | 4 |
1969566 | 1969566 | 2021-12-01 | Monterey | California | 6053 | 52521 | 632 |
1969567 | 1969567 | 2021-12-01 | Napa | California | 6055 | 13425 | 105 |
1969568 | 1969568 | 2021-12-01 | Nevada | California | 6057 | 10029 | 105 |
1969569 | 1969569 | 2021-12-01 | Orange | California | 6059 | 334626 | 5736 |
1969570 | 1969570 | 2021-12-01 | Placer | California | 6061 | 42204 | 470 |
1969571 | 1969571 | 2021-12-01 | Plumas | California | 6063 | 1939 | 7 |
1969572 | 1969572 | 2021-12-01 | Riverside | California | 6065 | 388083 | 5458 |
1969573 | 1969573 | 2021-12-01 | Sacramento | California | 6067 | 168491 | 2447 |
1969574 | 1969574 | 2021-12-01 | San Benito | California | 6069 | 7829 | 78 |
1969575 | 1969575 | 2021-12-01 | San Bernardino | California | 6071 | 374855 | 5967 |
1969576 | 1969576 | 2021-12-01 | San Diego | California | 6073 | 407542 | 4340 |
1969577 | 1969577 | 2021-12-01 | San Francisco | California | 6075 | 56934 | 672 |
1969578 | 1969578 | 2021-12-01 | San Joaquin | California | 6077 | 107604 | 1837 |
1969579 | 1969579 | 2021-12-01 | San Luis Obispo | California | 6079 | 31511 | 365 |
1969580 | 1969580 | 2021-12-01 | San Mateo | California | 6081 | 56354 | 629 |
1969581 | 1969581 | 2021-12-01 | Santa Barbara | California | 6083 | 47345 | 553 |
1969582 | 1969582 | 2021-12-01 | Santa Clara | California | 6085 | 152268 | 1930 |
1969583 | 1969583 | 2021-12-01 | Santa Cruz | California | 6087 | 22268 | 224 |
1969584 | 1969584 | 2021-12-01 | Shasta | California | 6089 | 26113 | 458 |
1969585 | 1969585 | 2021-12-01 | Sierra | California | 6091 | 218 | 0 |
1969586 | 1969586 | 2021-12-01 | Siskiyou | California | 6093 | 4933 | 73 |
1969587 | 1969587 | 2021-12-01 | Solano | California | 6095 | 47698 | 358 |
1969588 | 1969588 | 2021-12-01 | Sonoma | California | 6097 | 43207 | 412 |
1969589 | 1969589 | 2021-12-01 | Stanislaus | California | 6099 | 91620 | 1422 |
1969590 | 1969590 | 2021-12-01 | Sutter | California | 6101 | 14612 | 186 |
1969591 | 1969591 | 2021-12-01 | Tehama | California | 6103 | 10282 | 130 |
1969592 | 1969592 | 2021-12-01 | Trinity | California | 6105 | 999 | 17 |
1969593 | 1969593 | 2021-12-01 | Tulare | California | 6107 | 86137 | 1099 |
1969594 | 1969594 | 2021-12-01 | Tuolumne | California | 6109 | 7877 | 144 |
1969595 | 1969595 | 2021-12-01 | Ventura | California | 6111 | 104084 | 1191 |
1969596 | 1969596 | 2021-12-01 | Yolo | California | 6113 | 21590 | 260 |
1969597 | 1969597 | 2021-12-01 | Yuba | California | 6115 | 11214 | 89 |
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);