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-04-29 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1267989 | 1267989 | 2021-04-29 | Alameda | California | 6001 | 86411 | 1493 |
1267990 | 1267990 | 2021-04-29 | Alpine | California | 6003 | 88 | 0 |
1267991 | 1267991 | 2021-04-29 | Amador | California | 6005 | 3645 | 47 |
1267992 | 1267992 | 2021-04-29 | Butte | California | 6007 | 11762 | 196 |
1267993 | 1267993 | 2021-04-29 | Calaveras | California | 6009 | 2086 | 52 |
1267994 | 1267994 | 2021-04-29 | Colusa | California | 6011 | 2216 | 16 |
1267995 | 1267995 | 2021-04-29 | Contra Costa | California | 6013 | 67880 | 795 |
1267996 | 1267996 | 2021-04-29 | Del Norte | California | 6015 | 1315 | 7 |
1267997 | 1267997 | 2021-04-29 | El Dorado | California | 6017 | 9929 | 110 |
1267998 | 1267998 | 2021-04-29 | Fresno | California | 6019 | 101161 | 1666 |
1267999 | 1267999 | 2021-04-29 | Glenn | California | 6021 | 2881 | 25 |
1268000 | 1268000 | 2021-04-29 | Humboldt | California | 6023 | 3833 | 38 |
1268001 | 1268001 | 2021-04-29 | Imperial | California | 6025 | 28177 | 720 |
1268002 | 1268002 | 2021-04-29 | Inyo | California | 6027 | 1421 | 38 |
1268003 | 1268003 | 2021-04-29 | Kern | California | 6029 | 108479 | 1349 |
1268004 | 1268004 | 2021-04-29 | Kings | California | 6031 | 22870 | 246 |
1268005 | 1268005 | 2021-04-29 | Lake | California | 6033 | 3433 | 43 |
1268006 | 1268006 | 2021-04-29 | Lassen | California | 6035 | 5692 | 24 |
1268007 | 1268007 | 2021-04-29 | Los Angeles | California | 6037 | 1233036 | 23858 |
1268008 | 1268008 | 2021-04-29 | Madera | California | 6039 | 16372 | 240 |
1268009 | 1268009 | 2021-04-29 | Marin | California | 6041 | 13866 | 227 |
1268010 | 1268010 | 2021-04-29 | Mariposa | California | 6043 | 441 | 7 |
1268011 | 1268011 | 2021-04-29 | Mendocino | California | 6045 | 4024 | 48 |
1268012 | 1268012 | 2021-04-29 | Merced | California | 6047 | 31557 | 454 |
1268013 | 1268013 | 2021-04-29 | Modoc | California | 6049 | 492 | 4 |
1268014 | 1268014 | 2021-04-29 | Mono | California | 6051 | 1276 | 4 |
1268015 | 1268015 | 2021-04-29 | Monterey | California | 6053 | 43443 | 381 |
1268016 | 1268016 | 2021-04-29 | Napa | California | 6055 | 9778 | 81 |
1268017 | 1268017 | 2021-04-29 | Nevada | California | 6057 | 4570 | 75 |
1268018 | 1268018 | 2021-04-29 | Orange | California | 6059 | 270014 | 4948 |
1268019 | 1268019 | 2021-04-29 | Placer | California | 6061 | 22193 | 288 |
1268020 | 1268020 | 2021-04-29 | Plumas | California | 6063 | 700 | 6 |
1268021 | 1268021 | 2021-04-29 | Riverside | California | 6065 | 298366 | 4568 |
1268022 | 1268022 | 2021-04-29 | Sacramento | California | 6067 | 102792 | 1663 |
1268023 | 1268023 | 2021-04-29 | San Benito | California | 6069 | 6021 | 63 |
1268024 | 1268024 | 2021-04-29 | San Bernardino | California | 6071 | 295806 | 4582 |
1268025 | 1268025 | 2021-04-29 | San Diego | California | 6073 | 275884 | 3698 |
1268026 | 1268026 | 2021-04-29 | San Francisco | California | 6075 | 36385 | 534 |
1268027 | 1268027 | 2021-04-29 | San Joaquin | California | 6077 | 72395 | 1346 |
1268028 | 1268028 | 2021-04-29 | San Luis Obispo | California | 6079 | 21180 | 260 |
1268029 | 1268029 | 2021-04-29 | San Mateo | California | 6081 | 41498 | 564 |
1268030 | 1268030 | 2021-04-29 | Santa Barbara | California | 6083 | 34164 | 448 |
1268031 | 1268031 | 2021-04-29 | Santa Clara | California | 6085 | 118181 | 2061 |
1268032 | 1268032 | 2021-04-29 | Santa Cruz | California | 6087 | 15984 | 205 |
1268033 | 1268033 | 2021-04-29 | Shasta | California | 6089 | 11880 | 220 |
1268034 | 1268034 | 2021-04-29 | Sierra | California | 6091 | 51 | 0 |
1268035 | 1268035 | 2021-04-29 | Siskiyou | California | 6093 | 2060 | 21 |
1268036 | 1268036 | 2021-04-29 | Solano | California | 6095 | 32417 | 248 |
1268037 | 1268037 | 2021-04-29 | Sonoma | California | 6097 | 29818 | 318 |
1268038 | 1268038 | 2021-04-29 | Stanislaus | California | 6099 | 61251 | 1043 |
1268039 | 1268039 | 2021-04-29 | Sutter | California | 6101 | 9356 | 110 |
1268040 | 1268040 | 2021-04-29 | Tehama | California | 6103 | 4930 | 53 |
1268041 | 1268041 | 2021-04-29 | Trinity | California | 6105 | 327 | 3 |
1268042 | 1268042 | 2021-04-29 | Tulare | California | 6107 | 49510 | 834 |
1268043 | 1268043 | 2021-04-29 | Tuolumne | California | 6109 | 4104 | 65 |
1268044 | 1268044 | 2021-04-29 | Ventura | California | 6111 | 80597 | 1008 |
1268045 | 1268045 | 2021-04-29 | Yolo | California | 6113 | 13721 | 205 |
1268046 | 1268046 | 2021-04-29 | Yuba | California | 6115 | 6172 | 44 |
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);