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 2022-01-05 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2083305 | 2083305 | 2022-01-05 | Alameda | California | 6001 | 147005 | 1569 |
2083306 | 2083306 | 2022-01-05 | Alpine | California | 6003 | 113 | 0 |
2083307 | 2083307 | 2022-01-05 | Amador | California | 6005 | 6103 | 71 |
2083308 | 2083308 | 2022-01-05 | Butte | California | 6007 | 27232 | 346 |
2083309 | 2083309 | 2022-01-05 | Calaveras | California | 6009 | 4837 | 93 |
2083310 | 2083310 | 2022-01-05 | Colusa | California | 6011 | 3406 | 21 |
2083311 | 2083311 | 2022-01-05 | Contra Costa | California | 6013 | 118727 | 1075 |
2083312 | 2083312 | 2022-01-05 | Del Norte | California | 6015 | 4024 | 43 |
2083313 | 2083313 | 2022-01-05 | El Dorado | California | 6017 | 20274 | 172 |
2083314 | 2083314 | 2022-01-05 | Fresno | California | 6019 | 166384 | 2380 |
2083315 | 2083315 | 2022-01-05 | Glenn | California | 6021 | 4767 | 54 |
2083316 | 2083316 | 2022-01-05 | Humboldt | California | 6023 | 11681 | 124 |
2083317 | 2083317 | 2022-01-05 | Imperial | California | 6025 | 43000 | 799 |
2083318 | 2083318 | 2022-01-05 | Inyo | California | 6027 | 2910 | 49 |
2083319 | 2083319 | 2022-01-05 | Kern | California | 6029 | 166790 | 1918 |
2083320 | 2083320 | 2022-01-05 | Kings | California | 6031 | 37172 | 389 |
2083321 | 2083321 | 2022-01-05 | Lake | California | 6033 | 7331 | 117 |
2083322 | 2083322 | 2022-01-05 | Lassen | California | 6035 | 8114 | 61 |
2083323 | 2083323 | 2022-01-05 | Los Angeles | California | 6037 | 1807532 | 27698 |
2083324 | 2083324 | 2022-01-05 | Madera | California | 6039 | 27770 | 328 |
2083325 | 2083325 | 2022-01-05 | Marin | California | 6041 | 22411 | 251 |
2083326 | 2083326 | 2022-01-05 | Mariposa | California | 6043 | 1828 | 18 |
2083327 | 2083327 | 2022-01-05 | Mendocino | California | 6045 | 9335 | 105 |
2083328 | 2083328 | 2022-01-05 | Merced | California | 6047 | 48262 | 706 |
2083329 | 2083329 | 2022-01-05 | Modoc | California | 6049 | 1133 | 11 |
2083330 | 2083330 | 2022-01-05 | Mono | California | 6051 | 2211 | 4 |
2083331 | 2083331 | 2022-01-05 | Monterey | California | 6053 | 56086 | 649 |
2083332 | 2083332 | 2022-01-05 | Napa | California | 6055 | 15531 | 107 |
2083333 | 2083333 | 2022-01-05 | Nevada | California | 6057 | 10979 | 110 |
2083334 | 2083334 | 2022-01-05 | Orange | California | 6059 | 383719 | 5901 |
2083335 | 2083335 | 2022-01-05 | Placer | California | 6061 | 46511 | 494 |
2083336 | 2083336 | 2022-01-05 | Plumas | California | 6063 | 2074 | 12 |
2083337 | 2083337 | 2022-01-05 | Riverside | California | 6065 | 431266 | 5608 |
2083338 | 2083338 | 2022-01-05 | Sacramento | California | 6067 | 187297 | 2559 |
2083339 | 2083339 | 2022-01-05 | San Benito | California | 6069 | 8969 | 79 |
2083340 | 2083340 | 2022-01-05 | San Bernardino | California | 6071 | 417152 | 6060 |
2083341 | 2083341 | 2022-01-05 | San Diego | California | 6073 | 482494 | 4487 |
2083342 | 2083342 | 2022-01-05 | San Francisco | California | 6075 | 74094 | 688 |
2083343 | 2083343 | 2022-01-05 | San Joaquin | California | 6077 | 116475 | 1911 |
2083344 | 2083344 | 2022-01-05 | San Luis Obispo | California | 6079 | 35303 | 371 |
2083345 | 2083345 | 2022-01-05 | San Mateo | California | 6081 | 67727 | 636 |
2083346 | 2083346 | 2022-01-05 | Santa Barbara | California | 6083 | 54293 | 574 |
2083347 | 2083347 | 2022-01-05 | Santa Clara | California | 6085 | 178916 | 1965 |
2083348 | 2083348 | 2022-01-05 | Santa Cruz | California | 6087 | 25079 | 228 |
2083349 | 2083349 | 2022-01-05 | Shasta | California | 6089 | 27237 | 498 |
2083350 | 2083350 | 2022-01-05 | Sierra | California | 6091 | 237 | 0 |
2083351 | 2083351 | 2022-01-05 | Siskiyou | California | 6093 | 5201 | 81 |
2083352 | 2083352 | 2022-01-05 | Solano | California | 6095 | 52748 | 383 |
2083353 | 2083353 | 2022-01-05 | Sonoma | California | 6097 | 49292 | 418 |
2083354 | 2083354 | 2022-01-05 | Stanislaus | California | 6099 | 96951 | 1481 |
2083355 | 2083355 | 2022-01-05 | Sutter | California | 6101 | 15548 | 201 |
2083356 | 2083356 | 2022-01-05 | Tehama | California | 6103 | 10626 | 140 |
2083357 | 2083357 | 2022-01-05 | Trinity | California | 6105 | 1044 | 18 |
2083358 | 2083358 | 2022-01-05 | Tulare | California | 6107 | 90638 | 1173 |
2083359 | 2083359 | 2022-01-05 | Tuolumne | California | 6109 | 8512 | 149 |
2083360 | 2083360 | 2022-01-05 | Ventura | California | 6111 | 118958 | 1213 |
2083361 | 2083361 | 2022-01-05 | Yolo | California | 6113 | 24391 | 270 |
2083362 | 2083362 | 2022-01-05 | Yuba | California | 6115 | 12048 | 101 |
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);