ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-11-03" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1878535 | 1878535 | 2021-11-03 | Alameda | California | 6001 | 122172 | 1441 |
1878536 | 1878536 | 2021-11-03 | Alpine | California | 6003 | 105 | 0 |
1878537 | 1878537 | 2021-11-03 | Amador | California | 6005 | 5596 | 66 |
1878538 | 1878538 | 2021-11-03 | Butte | California | 6007 | 24526 | 282 |
1878539 | 1878539 | 2021-11-03 | Calaveras | California | 6009 | 4129 | 82 |
1878540 | 1878540 | 2021-11-03 | Colusa | California | 6011 | 3133 | 19 |
1878541 | 1878541 | 2021-11-03 | Contra Costa | California | 6013 | 101275 | 1025 |
1878542 | 1878542 | 2021-11-03 | Del Norte | California | 6015 | 3749 | 42 |
1878543 | 1878543 | 2021-11-03 | El Dorado | California | 6017 | 17592 | 154 |
1878544 | 1878544 | 2021-11-03 | Fresno | California | 6019 | 150681 | 2158 |
1878545 | 1878545 | 2021-11-03 | Glenn | California | 6021 | 4469 | 46 |
1878546 | 1878546 | 2021-11-03 | Humboldt | California | 6023 | 9490 | 116 |
1878547 | 1878547 | 2021-11-03 | Imperial | California | 6025 | 36676 | 765 |
1878548 | 1878548 | 2021-11-03 | Inyo | California | 6027 | 2360 | 41 |
1878549 | 1878549 | 2021-11-03 | Kern | California | 6029 | 150632 | 1694 |
1878550 | 1878550 | 2021-11-03 | Kings | California | 6031 | 33944 | 340 |
1878551 | 1878551 | 2021-11-03 | Lake | California | 6033 | 6827 | 106 |
1878552 | 1878552 | 2021-11-03 | Lassen | California | 6035 | 7716 | 52 |
1878553 | 1878553 | 2021-11-03 | Los Angeles | California | 6037 | 1497297 | 26683 |
1878554 | 1878554 | 2021-11-03 | Madera | California | 6039 | 24792 | 287 |
1878555 | 1878555 | 2021-11-03 | Marin | California | 6041 | 17929 | 247 |
1878556 | 1878556 | 2021-11-03 | Mariposa | California | 6043 | 1445 | 17 |
1878557 | 1878557 | 2021-11-03 | Mendocino | California | 6045 | 7933 | 89 |
1878558 | 1878558 | 2021-11-03 | Merced | California | 6047 | 43860 | 602 |
1878559 | 1878559 | 2021-11-03 | Modoc | California | 6049 | 922 | 9 |
1878560 | 1878560 | 2021-11-03 | Mono | California | 6051 | 1737 | 4 |
1878561 | 1878561 | 2021-11-03 | Monterey | California | 6053 | 51314 | 605 |
1878562 | 1878562 | 2021-11-03 | Napa | California | 6055 | 13039 | 104 |
1878563 | 1878563 | 2021-11-03 | Nevada | California | 6057 | 9432 | 91 |
1878564 | 1878564 | 2021-11-03 | Orange | California | 6059 | 327535 | 5609 |
1878565 | 1878565 | 2021-11-03 | Placer | California | 6061 | 40493 | 438 |
1878566 | 1878566 | 2021-11-03 | Plumas | California | 6063 | 1760 | 7 |
1878567 | 1878567 | 2021-11-03 | Riverside | California | 6065 | 376653 | 5219 |
1878568 | 1878568 | 2021-11-03 | Sacramento | California | 6067 | 162808 | 2348 |
1878569 | 1878569 | 2021-11-03 | San Benito | California | 6069 | 7582 | 75 |
1878570 | 1878570 | 2021-11-03 | San Bernardino | California | 6071 | 363025 | 5813 |
1878571 | 1878571 | 2021-11-03 | San Diego | California | 6073 | 393968 | 4232 |
1878572 | 1878572 | 2021-11-03 | San Francisco | California | 6075 | 55104 | 663 |
1878573 | 1878573 | 2021-11-03 | San Joaquin | California | 6077 | 104488 | 1779 |
1878574 | 1878574 | 2021-11-03 | San Luis Obispo | California | 6079 | 30462 | 349 |
1878575 | 1878575 | 2021-11-03 | San Mateo | California | 6081 | 54847 | 625 |
1878576 | 1878576 | 2021-11-03 | Santa Barbara | California | 6083 | 45855 | 531 |
1878577 | 1878577 | 2021-11-03 | Santa Clara | California | 6085 | 147412 | 1897 |
1878578 | 1878578 | 2021-11-03 | Santa Cruz | California | 6087 | 21343 | 222 |
1878579 | 1878579 | 2021-11-03 | Shasta | California | 6089 | 24772 | 374 |
1878580 | 1878580 | 2021-11-03 | Sierra | California | 6091 | 202 | 0 |
1878581 | 1878581 | 2021-11-03 | Siskiyou | California | 6093 | 4741 | 65 |
1878582 | 1878582 | 2021-11-03 | Solano | California | 6095 | 46597 | 350 |
1878583 | 1878583 | 2021-11-03 | Sonoma | California | 6097 | 41817 | 406 |
1878584 | 1878584 | 2021-11-03 | Stanislaus | California | 6099 | 87998 | 1359 |
1878585 | 1878585 | 2021-11-03 | Sutter | California | 6101 | 14203 | 179 |
1878586 | 1878586 | 2021-11-03 | Tehama | California | 6103 | 9915 | 116 |
1878587 | 1878587 | 2021-11-03 | Trinity | California | 6105 | 917 | 11 |
1878588 | 1878588 | 2021-11-03 | Tulare | California | 6107 | 82724 | 1002 |
1878589 | 1878589 | 2021-11-03 | Tuolumne | California | 6109 | 7428 | 124 |
1878590 | 1878590 | 2021-11-03 | Ventura | California | 6111 | 101968 | 1178 |
1878591 | 1878591 | 2021-11-03 | Yolo | California | 6113 | 20877 | 250 |
1878592 | 1878592 | 2021-11-03 | Yuba | California | 6115 | 10793 | 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);