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-11-05 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 |
---|---|---|---|---|---|---|---|
1885033 | 1885033 | 2021-11-05 | Alameda | California | 6001 | 122492 | 1440 |
1885034 | 1885034 | 2021-11-05 | Alpine | California | 6003 | 105 | 0 |
1885035 | 1885035 | 2021-11-05 | Amador | California | 6005 | 5620 | 66 |
1885036 | 1885036 | 2021-11-05 | Butte | California | 6007 | 24635 | 288 |
1885037 | 1885037 | 2021-11-05 | Calaveras | California | 6009 | 4164 | 82 |
1885038 | 1885038 | 2021-11-05 | Colusa | California | 6011 | 3149 | 19 |
1885039 | 1885039 | 2021-11-05 | Contra Costa | California | 6013 | 101547 | 1025 |
1885040 | 1885040 | 2021-11-05 | Del Norte | California | 6015 | 3750 | 42 |
1885041 | 1885041 | 2021-11-05 | El Dorado | California | 6017 | 17682 | 156 |
1885042 | 1885042 | 2021-11-05 | Fresno | California | 6019 | 151513 | 2170 |
1885043 | 1885043 | 2021-11-05 | Glenn | California | 6021 | 4485 | 46 |
1885044 | 1885044 | 2021-11-05 | Humboldt | California | 6023 | 9558 | 116 |
1885045 | 1885045 | 2021-11-05 | Imperial | California | 6025 | 36821 | 765 |
1885046 | 1885046 | 2021-11-05 | Inyo | California | 6027 | 2391 | 41 |
1885047 | 1885047 | 2021-11-05 | Kern | California | 6029 | 151432 | 1706 |
1885048 | 1885048 | 2021-11-05 | Kings | California | 6031 | 34104 | 344 |
1885049 | 1885049 | 2021-11-05 | Lake | California | 6033 | 6840 | 106 |
1885050 | 1885050 | 2021-11-05 | Lassen | California | 6035 | 7748 | 52 |
1885051 | 1885051 | 2021-11-05 | Los Angeles | California | 6037 | 1500615 | 26719 |
1885052 | 1885052 | 2021-11-05 | Madera | California | 6039 | 25022 | 291 |
1885053 | 1885053 | 2021-11-05 | Marin | California | 6041 | 17976 | 247 |
1885054 | 1885054 | 2021-11-05 | Mariposa | California | 6043 | 1455 | 17 |
1885055 | 1885055 | 2021-11-05 | Mendocino | California | 6045 | 8032 | 90 |
1885056 | 1885056 | 2021-11-05 | Merced | California | 6047 | 44060 | 606 |
1885057 | 1885057 | 2021-11-05 | Modoc | California | 6049 | 935 | 9 |
1885058 | 1885058 | 2021-11-05 | Mono | California | 6051 | 1744 | 4 |
1885059 | 1885059 | 2021-11-05 | Monterey | California | 6053 | 51482 | 606 |
1885060 | 1885060 | 2021-11-05 | Napa | California | 6055 | 13066 | 103 |
1885061 | 1885061 | 2021-11-05 | Nevada | California | 6057 | 9486 | 91 |
1885062 | 1885062 | 2021-11-05 | Orange | California | 6059 | 328210 | 5615 |
1885063 | 1885063 | 2021-11-05 | Placer | California | 6061 | 40716 | 438 |
1885064 | 1885064 | 2021-11-05 | Plumas | California | 6063 | 1796 | 7 |
1885065 | 1885065 | 2021-11-05 | Riverside | California | 6065 | 377743 | 5240 |
1885066 | 1885066 | 2021-11-05 | Sacramento | California | 6067 | 163644 | 2359 |
1885067 | 1885067 | 2021-11-05 | San Benito | California | 6069 | 7607 | 75 |
1885068 | 1885068 | 2021-11-05 | San Bernardino | California | 6071 | 364509 | 5815 |
1885069 | 1885069 | 2021-11-05 | San Diego | California | 6073 | 395126 | 4246 |
1885070 | 1885070 | 2021-11-05 | San Francisco | California | 6075 | 55266 | 666 |
1885071 | 1885071 | 2021-11-05 | San Joaquin | California | 6077 | 104857 | 1782 |
1885072 | 1885072 | 2021-11-05 | San Luis Obispo | California | 6079 | 30599 | 350 |
1885073 | 1885073 | 2021-11-05 | San Mateo | California | 6081 | 55023 | 626 |
1885074 | 1885074 | 2021-11-05 | Santa Barbara | California | 6083 | 45996 | 532 |
1885075 | 1885075 | 2021-11-05 | Santa Clara | California | 6085 | 147918 | 1895 |
1885076 | 1885076 | 2021-11-05 | Santa Cruz | California | 6087 | 21394 | 222 |
1885077 | 1885077 | 2021-11-05 | Shasta | California | 6089 | 25006 | 384 |
1885078 | 1885078 | 2021-11-05 | Sierra | California | 6091 | 203 | 0 |
1885079 | 1885079 | 2021-11-05 | Siskiyou | California | 6093 | 4765 | 66 |
1885080 | 1885080 | 2021-11-05 | Solano | California | 6095 | 46702 | 350 |
1885081 | 1885081 | 2021-11-05 | Sonoma | California | 6097 | 41931 | 408 |
1885082 | 1885082 | 2021-11-05 | Stanislaus | California | 6099 | 87998 | 1359 |
1885083 | 1885083 | 2021-11-05 | Sutter | California | 6101 | 14260 | 180 |
1885084 | 1885084 | 2021-11-05 | Tehama | California | 6103 | 10000 | 120 |
1885085 | 1885085 | 2021-11-05 | Trinity | California | 6105 | 928 | 11 |
1885086 | 1885086 | 2021-11-05 | Tulare | California | 6107 | 83440 | 1010 |
1885087 | 1885087 | 2021-11-05 | Tuolumne | California | 6109 | 7438 | 129 |
1885088 | 1885088 | 2021-11-05 | Ventura | California | 6111 | 102195 | 1180 |
1885089 | 1885089 | 2021-11-05 | Yolo | California | 6113 | 20989 | 255 |
1885090 | 1885090 | 2021-11-05 | Yuba | California | 6115 | 10842 | 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);