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-11 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
816770 | 816770 | 2020-12-11 | Alameda | California | 6001 | 35707 | 538 |
816771 | 816771 | 2020-12-11 | Alpine | California | 6003 | 63 | 0 |
816772 | 816772 | 2020-12-11 | Amador | California | 6005 | 1190 | 18 |
816773 | 816773 | 2020-12-11 | Butte | California | 6007 | 4912 | 67 |
816774 | 816774 | 2020-12-11 | Calaveras | California | 6009 | 684 | 22 |
816775 | 816775 | 2020-12-11 | Colusa | California | 6011 | 921 | 8 |
816776 | 816776 | 2020-12-11 | Contra Costa | California | 6013 | 29124 | 279 |
816777 | 816777 | 2020-12-11 | Del Norte | California | 6015 | 501 | 1 |
816778 | 816778 | 2020-12-11 | El Dorado | California | 6017 | 3557 | 8 |
816779 | 816779 | 2020-12-11 | Fresno | California | 6019 | 42788 | 542 |
816780 | 816780 | 2020-12-11 | Glenn | California | 6021 | 1126 | 12 |
816781 | 816781 | 2020-12-11 | Humboldt | California | 6023 | 1231 | 10 |
816782 | 816782 | 2020-12-11 | Imperial | California | 6025 | 18333 | 372 |
816783 | 816783 | 2020-12-11 | Inyo | California | 6027 | 365 | 17 |
816784 | 816784 | 2020-12-11 | Kern | California | 6029 | 49232 | 467 |
816785 | 816785 | 2020-12-11 | Kings | California | 6031 | 13045 | 98 |
816786 | 816786 | 2020-12-11 | Lake | California | 6033 | 1167 | 22 |
816787 | 816787 | 2020-12-11 | Lassen | California | 6035 | 3127 | 5 |
816788 | 816788 | 2020-12-11 | Los Angeles | California | 6037 | 501792 | 8199 |
816789 | 816789 | 2020-12-11 | Madera | California | 6039 | 7612 | 107 |
816790 | 816790 | 2020-12-11 | Marin | California | 6041 | 8362 | 132 |
816791 | 816791 | 2020-12-11 | Mariposa | California | 6043 | 171 | 4 |
816792 | 816792 | 2020-12-11 | Mendocino | California | 6045 | 1931 | 24 |
816793 | 816793 | 2020-12-11 | Merced | California | 6047 | 14483 | 207 |
816794 | 816794 | 2020-12-11 | Modoc | California | 6049 | 225 | 0 |
816795 | 816795 | 2020-12-11 | Mono | California | 6051 | 601 | 3 |
816796 | 816796 | 2020-12-11 | Monterey | California | 6053 | 18266 | 153 |
816797 | 816797 | 2020-12-11 | Napa | California | 6055 | 4014 | 23 |
816798 | 816798 | 2020-12-11 | Nevada | California | 6057 | 1962 | 21 |
816799 | 816799 | 2020-12-11 | Orange | California | 6059 | 99603 | 1662 |
816800 | 816800 | 2020-12-11 | Placer | California | 6061 | 8906 | 92 |
816801 | 816801 | 2020-12-11 | Plumas | California | 6063 | 281 | 0 |
816802 | 816802 | 2020-12-11 | Riverside | California | 6065 | 112950 | 1573 |
816803 | 816803 | 2020-12-11 | Sacramento | California | 6067 | 47472 | 670 |
816804 | 816804 | 2020-12-11 | San Benito | California | 6069 | 2348 | 19 |
816805 | 816805 | 2020-12-11 | San Bernardino | California | 6071 | 120186 | 1209 |
816806 | 816806 | 2020-12-11 | San Diego | California | 6073 | 102529 | 1137 |
816807 | 816807 | 2020-12-11 | San Francisco | California | 6075 | 17948 | 167 |
816808 | 816808 | 2020-12-11 | San Joaquin | California | 6077 | 31720 | 535 |
816809 | 816809 | 2020-12-11 | San Luis Obispo | California | 6079 | 7452 | 46 |
816810 | 816810 | 2020-12-11 | San Mateo | California | 6081 | 17176 | 179 |
816811 | 816811 | 2020-12-11 | Santa Barbara | California | 6083 | 12866 | 140 |
816812 | 816812 | 2020-12-11 | Santa Clara | California | 6085 | 45178 | 527 |
816813 | 816813 | 2020-12-11 | Santa Cruz | California | 6087 | 5645 | 53 |
816814 | 816814 | 2020-12-11 | Shasta | California | 6089 | 6853 | 58 |
816815 | 816815 | 2020-12-11 | Sierra | California | 6091 | 18 | 0 |
816816 | 816816 | 2020-12-11 | Siskiyou | California | 6093 | 914 | 7 |
816817 | 816817 | 2020-12-11 | Solano | California | 6095 | 12738 | 91 |
816818 | 816818 | 2020-12-11 | Sonoma | California | 6097 | 14282 | 162 |
816819 | 816819 | 2020-12-11 | Stanislaus | California | 6099 | 27966 | 463 |
816820 | 816820 | 2020-12-11 | Sutter | California | 6101 | 4657 | 33 |
816821 | 816821 | 2020-12-11 | Tehama | California | 6103 | 2190 | 30 |
816822 | 816822 | 2020-12-11 | Trinity | California | 6105 | 203 | 1 |
816823 | 816823 | 2020-12-11 | Tulare | California | 6107 | 25042 | 327 |
816824 | 816824 | 2020-12-11 | Tuolumne | California | 6109 | 1547 | 17 |
816825 | 816825 | 2020-12-11 | Ventura | California | 6111 | 24276 | 198 |
816826 | 816826 | 2020-12-11 | Yolo | California | 6113 | 5979 | 89 |
816827 | 816827 | 2020-12-11 | Yuba | California | 6115 | 2820 | 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);