ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2022-03-24" 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 |
---|---|---|---|---|---|---|---|
2336991 | 2336991 | 2022-03-24 | Alameda | California | 6001 | 268342 | 1818 |
2336992 | 2336992 | 2022-03-24 | Alpine | California | 6003 | 125 | 0 |
2336993 | 2336993 | 2022-03-24 | Amador | California | 6005 | 9118 | 86 |
2336994 | 2336994 | 2022-03-24 | Butte | California | 6007 | 39566 | 387 |
2336995 | 2336995 | 2022-03-24 | Calaveras | California | 6009 | 7594 | 120 |
2336996 | 2336996 | 2022-03-24 | Colusa | California | 6011 | 4525 | 21 |
2336997 | 2336997 | 2022-03-24 | Contra Costa | California | 6013 | 201074 | 1279 |
2336998 | 2336998 | 2022-03-24 | Del Norte | California | 6015 | 6197 | 50 |
2336999 | 2336999 | 2022-03-24 | El Dorado | California | 6017 | 29877 | 200 |
2337000 | 2337000 | 2022-03-24 | Fresno | California | 6019 | 251910 | 2710 |
2337001 | 2337001 | 2022-03-24 | Glenn | California | 6021 | 6549 | 66 |
2337002 | 2337002 | 2022-03-24 | Humboldt | California | 6023 | 20002 | 139 |
2337003 | 2337003 | 2022-03-24 | Imperial | California | 6025 | 66343 | 908 |
2337004 | 2337004 | 2022-03-24 | Inyo | California | 6027 | 4543 | 56 |
2337005 | 2337005 | 2022-03-24 | Kern | California | 6029 | 242104 | 2244 |
2337006 | 2337006 | 2022-03-24 | Kings | California | 6031 | 55005 | 442 |
2337007 | 2337007 | 2022-03-24 | Lake | California | 6033 | 11553 | 135 |
2337008 | 2337008 | 2022-03-24 | Lassen | California | 6035 | 10696 | 68 |
2337009 | 2337009 | 2022-03-24 | Los Angeles | California | 6037 | 2828506 | 31561 |
2337010 | 2337010 | 2022-03-24 | Madera | California | 6039 | 43356 | 354 |
2337011 | 2337011 | 2022-03-24 | Marin | California | 6041 | 35486 | 287 |
2337012 | 2337012 | 2022-03-24 | Mariposa | California | 6043 | 3003 | 30 |
2337013 | 2337013 | 2022-03-24 | Mendocino | California | 6045 | 16022 | 118 |
2337014 | 2337014 | 2022-03-24 | Merced | California | 6047 | 71817 | 810 |
2337015 | 2337015 | 2022-03-24 | Modoc | California | 6049 | 986 | 7 |
2337016 | 2337016 | 2022-03-24 | Mono | California | 6051 | 3087 | 5 |
2337017 | 2337017 | 2022-03-24 | Monterey | California | 6053 | 92231 | 729 |
2337018 | 2337018 | 2022-03-24 | Napa | California | 6055 | 26655 | 139 |
2337019 | 2337019 | 2022-03-24 | Nevada | California | 6057 | 17171 | 123 |
2337020 | 2337020 | 2022-03-24 | Orange | California | 6059 | 586392 | 6857 |
2337021 | 2337021 | 2022-03-24 | Placer | California | 6061 | 69969 | 613 |
2337022 | 2337022 | 2022-03-24 | Plumas | California | 6063 | 3104 | 13 |
2337023 | 2337023 | 2022-03-24 | Riverside | California | 6065 | 618053 | 6445 |
2337024 | 2337024 | 2022-03-24 | Sacramento | California | 6067 | 302235 | 3043 |
2337025 | 2337025 | 2022-03-24 | San Benito | California | 6069 | 13400 | 97 |
2337026 | 2337026 | 2022-03-24 | San Bernardino | California | 6071 | 585021 | 6828 |
2337027 | 2337027 | 2022-03-24 | San Diego | California | 6073 | 800978 | 5143 |
2337028 | 2337028 | 2022-03-24 | San Francisco | California | 6075 | 132461 | 838 |
2337029 | 2337029 | 2022-03-24 | San Joaquin | California | 6077 | 175208 | 2187 |
2337030 | 2337030 | 2022-03-24 | San Luis Obispo | California | 6079 | 56111 | 469 |
2337031 | 2337031 | 2022-03-24 | San Mateo | California | 6081 | 127126 | 742 |
2337032 | 2337032 | 2022-03-24 | Santa Barbara | California | 6083 | 90291 | 673 |
2337033 | 2337033 | 2022-03-24 | Santa Clara | California | 6085 | 323294 | 2251 |
2337034 | 2337034 | 2022-03-24 | Santa Cruz | California | 6087 | 49312 | 259 |
2337035 | 2337035 | 2022-03-24 | Shasta | California | 6089 | 36705 | 587 |
2337036 | 2337036 | 2022-03-24 | Sierra | California | 6091 | 315 | 4 |
2337037 | 2337037 | 2022-03-24 | Siskiyou | California | 6093 | 7399 | 104 |
2337038 | 2337038 | 2022-03-24 | Solano | California | 6095 | 87159 | 441 |
2337039 | 2337039 | 2022-03-24 | Sonoma | California | 6097 | 85522 | 487 |
2337040 | 2337040 | 2022-03-24 | Stanislaus | California | 6099 | 136645 | 1694 |
2337041 | 2337041 | 2022-03-24 | Sutter | California | 6101 | 22619 | 230 |
2337042 | 2337042 | 2022-03-24 | Tehama | California | 6103 | 14642 | 195 |
2337043 | 2337043 | 2022-03-24 | Trinity | California | 6105 | 1467 | 20 |
2337044 | 2337044 | 2022-03-24 | Tulare | California | 6107 | 132786 | 1397 |
2337045 | 2337045 | 2022-03-24 | Tuolumne | California | 6109 | 13440 | 180 |
2337046 | 2337046 | 2022-03-24 | Ventura | California | 6111 | 181914 | 1457 |
2337047 | 2337047 | 2022-03-24 | Yolo | California | 6113 | 39374 | 308 |
2337048 | 2337048 | 2022-03-24 | Yuba | California | 6115 | 17628 | 117 |
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);