ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where "date" is on date 2020-04-26 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
89842 | 89842 | 2020-04-26 | Alameda | California | 6001 | 1489 | 52 |
89843 | 89843 | 2020-04-26 | Alpine | California | 6003 | 1 | 0 |
89844 | 89844 | 2020-04-26 | Amador | California | 6005 | 7 | 0 |
89845 | 89845 | 2020-04-26 | Butte | California | 6007 | 16 | 0 |
89846 | 89846 | 2020-04-26 | Calaveras | California | 6009 | 13 | 0 |
89847 | 89847 | 2020-04-26 | Colusa | California | 6011 | 3 | 0 |
89848 | 89848 | 2020-04-26 | Contra Costa | California | 6013 | 817 | 25 |
89849 | 89849 | 2020-04-26 | Del Norte | California | 6015 | 3 | 0 |
89850 | 89850 | 2020-04-26 | El Dorado | California | 6017 | 42 | 0 |
89851 | 89851 | 2020-04-26 | Fresno | California | 6019 | 458 | 7 |
89852 | 89852 | 2020-04-26 | Glenn | California | 6021 | 5 | 0 |
89853 | 89853 | 2020-04-26 | Humboldt | California | 6023 | 53 | 0 |
89854 | 89854 | 2020-04-26 | Imperial | California | 6025 | 251 | 7 |
89855 | 89855 | 2020-04-26 | Inyo | California | 6027 | 19 | 1 |
89856 | 89856 | 2020-04-26 | Kern | California | 6029 | 809 | 4 |
89857 | 89857 | 2020-04-26 | Kings | California | 6031 | 67 | 1 |
89858 | 89858 | 2020-04-26 | Lake | California | 6033 | 6 | 0 |
89859 | 89859 | 2020-04-26 | Los Angeles | California | 6037 | 19528 | 913 |
89860 | 89860 | 2020-04-26 | Madera | California | 6039 | 41 | 2 |
89861 | 89861 | 2020-04-26 | Marin | California | 6041 | 224 | 12 |
89862 | 89862 | 2020-04-26 | Mendocino | California | 6045 | 11 | 0 |
89863 | 89863 | 2020-04-26 | Merced | California | 6047 | 105 | 3 |
89864 | 89864 | 2020-04-26 | Mono | California | 6051 | 24 | 1 |
89865 | 89865 | 2020-04-26 | Monterey | California | 6053 | 183 | 4 |
89866 | 89866 | 2020-04-26 | Napa | California | 6055 | 61 | 2 |
89867 | 89867 | 2020-04-26 | Nevada | California | 6057 | 37 | 1 |
89868 | 89868 | 2020-04-26 | Orange | California | 6059 | 2074 | 39 |
89869 | 89869 | 2020-04-26 | Placer | California | 6061 | 141 | 8 |
89870 | 89870 | 2020-04-26 | Plumas | California | 6063 | 4 | 0 |
89871 | 89871 | 2020-04-26 | Riverside | California | 6065 | 3563 | 118 |
89872 | 89872 | 2020-04-26 | Sacramento | California | 6067 | 1037 | 41 |
89873 | 89873 | 2020-04-26 | San Benito | California | 6069 | 47 | 2 |
89874 | 89874 | 2020-04-26 | San Bernardino | California | 6071 | 1751 | 82 |
89875 | 89875 | 2020-04-26 | San Diego | California | 6073 | 3043 | 111 |
89876 | 89876 | 2020-04-26 | San Francisco | California | 6075 | 1411 | 22 |
89877 | 89877 | 2020-04-26 | San Joaquin | California | 6077 | 523 | 25 |
89878 | 89878 | 2020-04-26 | San Luis Obispo | California | 6079 | 166 | 1 |
89879 | 89879 | 2020-04-26 | San Mateo | California | 6081 | 1019 | 41 |
89880 | 89880 | 2020-04-26 | Santa Barbara | California | 6083 | 471 | 7 |
89881 | 89881 | 2020-04-26 | Santa Clara | California | 6085 | 2084 | 101 |
89882 | 89882 | 2020-04-26 | Santa Cruz | California | 6087 | 120 | 2 |
89883 | 89883 | 2020-04-26 | Shasta | California | 6089 | 30 | 4 |
89884 | 89884 | 2020-04-26 | Siskiyou | California | 6093 | 5 | 0 |
89885 | 89885 | 2020-04-26 | Solano | California | 6095 | 204 | 4 |
89886 | 89886 | 2020-04-26 | Sonoma | California | 6097 | 220 | 2 |
89887 | 89887 | 2020-04-26 | Stanislaus | California | 6099 | 294 | 5 |
89888 | 89888 | 2020-04-26 | Sutter | California | 6101 | 29 | 2 |
89889 | 89889 | 2020-04-26 | Tehama | California | 6103 | 1 | 0 |
89890 | 89890 | 2020-04-26 | Tulare | California | 6107 | 504 | 32 |
89891 | 89891 | 2020-04-26 | Tuolumne | California | 6109 | 3 | 0 |
89892 | 89892 | 2020-04-26 | Ventura | California | 6111 | 497 | 17 |
89893 | 89893 | 2020-04-26 | Yolo | California | 6113 | 161 | 14 |
89894 | 89894 | 2020-04-26 | Yuba | California | 6115 | 16 | 1 |
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);