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-03-02 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1079656 | 1079656 | 2021-03-02 | Alameda | California | 6001 | 80894 | 1244 |
1079657 | 1079657 | 2021-03-02 | Alpine | California | 6003 | 77 | 0 |
1079658 | 1079658 | 2021-03-02 | Amador | California | 6005 | 3468 | 41 |
1079659 | 1079659 | 2021-03-02 | Butte | California | 6007 | 10981 | 167 |
1079660 | 1079660 | 2021-03-02 | Calaveras | California | 6009 | 1885 | 47 |
1079661 | 1079661 | 2021-03-02 | Colusa | California | 6011 | 2139 | 13 |
1079662 | 1079662 | 2021-03-02 | Contra Costa | California | 6013 | 62818 | 681 |
1079663 | 1079663 | 2021-03-02 | Del Norte | California | 6015 | 1007 | 5 |
1079664 | 1079664 | 2021-03-02 | El Dorado | California | 6017 | 9085 | 100 |
1079665 | 1079665 | 2021-03-02 | Fresno | California | 6019 | 95677 | 1451 |
1079666 | 1079666 | 2021-03-02 | Glenn | California | 6021 | 2708 | 23 |
1079667 | 1079667 | 2021-03-02 | Humboldt | California | 6023 | 3219 | 33 |
1079668 | 1079668 | 2021-03-02 | Imperial | California | 6025 | 26913 | 635 |
1079669 | 1079669 | 2021-03-02 | Inyo | California | 6027 | 1285 | 37 |
1079670 | 1079670 | 2021-03-02 | Kern | California | 6029 | 103622 | 902 |
1079671 | 1079671 | 2021-03-02 | Kings | California | 6031 | 22091 | 220 |
1079672 | 1079672 | 2021-03-02 | Lake | California | 6033 | 3164 | 41 |
1079673 | 1079673 | 2021-03-02 | Lassen | California | 6035 | 5601 | 19 |
1079674 | 1079674 | 2021-03-02 | Los Angeles | California | 6037 | 1194878 | 21554 |
1079675 | 1079675 | 2021-03-02 | Madera | California | 6039 | 15505 | 214 |
1079676 | 1079676 | 2021-03-02 | Marin | California | 6041 | 13161 | 197 |
1079677 | 1079677 | 2021-03-02 | Mariposa | California | 6043 | 395 | 7 |
1079678 | 1079678 | 2021-03-02 | Mendocino | California | 6045 | 3821 | 43 |
1079679 | 1079679 | 2021-03-02 | Merced | California | 6047 | 29195 | 405 |
1079680 | 1079680 | 2021-03-02 | Modoc | California | 6049 | 450 | 4 |
1079681 | 1079681 | 2021-03-02 | Mono | California | 6051 | 1192 | 4 |
1079682 | 1079682 | 2021-03-02 | Monterey | California | 6053 | 42316 | 329 |
1079683 | 1079683 | 2021-03-02 | Napa | California | 6055 | 9057 | 71 |
1079684 | 1079684 | 2021-03-02 | Nevada | California | 6057 | 3979 | 74 |
1079685 | 1079685 | 2021-03-02 | Orange | California | 6059 | 261608 | 3952 |
1079686 | 1079686 | 2021-03-02 | Placer | California | 6061 | 19882 | 232 |
1079687 | 1079687 | 2021-03-02 | Plumas | California | 6063 | 628 | 6 |
1079688 | 1079688 | 2021-03-02 | Riverside | California | 6065 | 290325 | 3829 |
1079689 | 1079689 | 2021-03-02 | Sacramento | California | 6067 | 93677 | 1488 |
1079690 | 1079690 | 2021-03-02 | San Benito | California | 6069 | 5772 | 61 |
1079691 | 1079691 | 2021-03-02 | San Bernardino | California | 6071 | 286814 | 2952 |
1079692 | 1079692 | 2021-03-02 | San Diego | California | 6073 | 261064 | 3317 |
1079693 | 1079693 | 2021-03-02 | San Francisco | California | 6075 | 34321 | 422 |
1079694 | 1079694 | 2021-03-02 | San Joaquin | California | 6077 | 67040 | 1140 |
1079695 | 1079695 | 2021-03-02 | San Luis Obispo | California | 6079 | 19724 | 236 |
1079696 | 1079696 | 2021-03-02 | San Mateo | California | 6081 | 39096 | 521 |
1079697 | 1079697 | 2021-03-02 | Santa Barbara | California | 6083 | 32087 | 416 |
1079698 | 1079698 | 2021-03-02 | Santa Clara | California | 6085 | 110911 | 1798 |
1079699 | 1079699 | 2021-03-02 | Santa Cruz | California | 6087 | 14700 | 183 |
1079700 | 1079700 | 2021-03-02 | Shasta | California | 6089 | 11017 | 174 |
1079701 | 1079701 | 2021-03-02 | Sierra | California | 6091 | 48 | 0 |
1079702 | 1079702 | 2021-03-02 | Siskiyou | California | 6093 | 1779 | 14 |
1079703 | 1079703 | 2021-03-02 | Solano | California | 6095 | 30168 | 164 |
1079704 | 1079704 | 2021-03-02 | Sonoma | California | 6097 | 28222 | 298 |
1079705 | 1079705 | 2021-03-02 | Stanislaus | California | 6099 | 56323 | 950 |
1079706 | 1079706 | 2021-03-02 | Sutter | California | 6101 | 8886 | 98 |
1079707 | 1079707 | 2021-03-02 | Tehama | California | 6103 | 4595 | 52 |
1079708 | 1079708 | 2021-03-02 | Trinity | California | 6105 | 299 | 5 |
1079709 | 1079709 | 2021-03-02 | Tulare | California | 6107 | 48086 | 766 |
1079710 | 1079710 | 2021-03-02 | Tuolumne | California | 6109 | 3963 | 59 |
1079711 | 1079711 | 2021-03-02 | Ventura | California | 6111 | 77849 | 858 |
1079712 | 1079712 | 2021-03-02 | Yolo | California | 6113 | 12854 | 185 |
1079713 | 1079713 | 2021-03-02 | Yuba | California | 6115 | 5771 | 37 |
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);