ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-11-10" 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 |
---|---|---|---|---|---|---|---|
716173 | 716173 | 2020-11-10 | Alameda | California | 6001 | 25131 | 475 |
716174 | 716174 | 2020-11-10 | Alpine | California | 6003 | 6 | 0 |
716175 | 716175 | 2020-11-10 | Amador | California | 6005 | 379 | 16 |
716176 | 716176 | 2020-11-10 | Butte | California | 6007 | 3318 | 56 |
716177 | 716177 | 2020-11-10 | Calaveras | California | 6009 | 373 | 21 |
716178 | 716178 | 2020-11-10 | Colusa | California | 6011 | 591 | 6 |
716179 | 716179 | 2020-11-10 | Contra Costa | California | 6013 | 20193 | 253 |
716180 | 716180 | 2020-11-10 | Del Norte | California | 6015 | 204 | 1 |
716181 | 716181 | 2020-11-10 | El Dorado | California | 6017 | 1515 | 4 |
716182 | 716182 | 2020-11-10 | Fresno | California | 6019 | 33162 | 456 |
716183 | 716183 | 2020-11-10 | Glenn | California | 6021 | 714 | 4 |
716184 | 716184 | 2020-11-10 | Humboldt | California | 6023 | 624 | 10 |
716185 | 716185 | 2020-11-10 | Imperial | California | 6025 | 13697 | 340 |
716186 | 716186 | 2020-11-10 | Inyo | California | 6027 | 252 | 15 |
716187 | 716187 | 2020-11-10 | Kern | California | 6029 | 35610 | 429 |
716188 | 716188 | 2020-11-10 | Kings | California | 6031 | 9141 | 87 |
716189 | 716189 | 2020-11-10 | Lake | California | 6033 | 755 | 17 |
716190 | 716190 | 2020-11-10 | Lassen | California | 6035 | 841 | 1 |
716191 | 716191 | 2020-11-10 | Los Angeles | California | 6037 | 325951 | 7200 |
716192 | 716192 | 2020-11-10 | Madera | California | 6039 | 5330 | 76 |
716193 | 716193 | 2020-11-10 | Marin | California | 6041 | 7284 | 127 |
716194 | 716194 | 2020-11-10 | Mariposa | California | 6043 | 88 | 2 |
716195 | 716195 | 2020-11-10 | Mendocino | California | 6045 | 1242 | 22 |
716196 | 716196 | 2020-11-10 | Merced | California | 6047 | 10193 | 164 |
716197 | 716197 | 2020-11-10 | Modoc | California | 6049 | 79 | 0 |
716198 | 716198 | 2020-11-10 | Mono | California | 6051 | 352 | 2 |
716199 | 716199 | 2020-11-10 | Monterey | California | 6053 | 12463 | 102 |
716200 | 716200 | 2020-11-10 | Napa | California | 6055 | 2332 | 16 |
716201 | 716201 | 2020-11-10 | Nevada | California | 6057 | 733 | 9 |
716202 | 716202 | 2020-11-10 | Orange | California | 6059 | 64891 | 1512 |
716203 | 716203 | 2020-11-10 | Placer | California | 6061 | 4912 | 60 |
716204 | 716204 | 2020-11-10 | Plumas | California | 6063 | 102 | 0 |
716205 | 716205 | 2020-11-10 | Riverside | California | 6065 | 72341 | 1352 |
716206 | 716206 | 2020-11-10 | Sacramento | California | 6067 | 28720 | 514 |
716207 | 716207 | 2020-11-10 | San Benito | California | 6069 | 1525 | 15 |
716208 | 716208 | 2020-11-10 | San Bernardino | California | 6071 | 70347 | 1096 |
716209 | 716209 | 2020-11-10 | San Diego | California | 6073 | 61116 | 915 |
716210 | 716210 | 2020-11-10 | San Francisco | California | 6075 | 13142 | 151 |
716211 | 716211 | 2020-11-10 | San Joaquin | California | 6077 | 22993 | 500 |
716212 | 716212 | 2020-11-10 | San Luis Obispo | California | 6079 | 4846 | 33 |
716213 | 716213 | 2020-11-10 | San Mateo | California | 6081 | 12049 | 165 |
716214 | 716214 | 2020-11-10 | Santa Barbara | California | 6083 | 10260 | 131 |
716215 | 716215 | 2020-11-10 | Santa Clara | California | 6085 | 26972 | 437 |
716216 | 716216 | 2020-11-10 | Santa Cruz | California | 6087 | 3227 | 26 |
716217 | 716217 | 2020-11-10 | Shasta | California | 6089 | 2741 | 34 |
716218 | 716218 | 2020-11-10 | Sierra | California | 6091 | 10 | 0 |
716219 | 716219 | 2020-11-10 | Siskiyou | California | 6093 | 321 | 1 |
716220 | 716220 | 2020-11-10 | Solano | California | 6095 | 8435 | 79 |
716221 | 716221 | 2020-11-10 | Sonoma | California | 6097 | 10505 | 149 |
716222 | 716222 | 2020-11-10 | Stanislaus | California | 6099 | 19538 | 409 |
716223 | 716223 | 2020-11-10 | Sutter | California | 6101 | 2089 | 12 |
716224 | 716224 | 2020-11-10 | Tehama | California | 6103 | 1071 | 19 |
716225 | 716225 | 2020-11-10 | Trinity | California | 6105 | 47 | 0 |
716226 | 716226 | 2020-11-10 | Tulare | California | 6107 | 18610 | 299 |
716227 | 716227 | 2020-11-10 | Tuolumne | California | 6109 | 364 | 8 |
716228 | 716228 | 2020-11-10 | Ventura | California | 6111 | 15568 | 171 |
716229 | 716229 | 2020-11-10 | Yolo | California | 6113 | 3577 | 64 |
716230 | 716230 | 2020-11-10 | Yuba | California | 6115 | 1494 | 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);