ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where "date" is on date 2020-07-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 |
---|---|---|---|---|---|---|---|
303048 | 303048 | 2020-07-05 | Alameda | California | 6001 | 6876 | 140 |
303049 | 303049 | 2020-07-05 | Alpine | California | 6003 | 1 | 0 |
303050 | 303050 | 2020-07-05 | Amador | California | 6005 | 31 | 0 |
303051 | 303051 | 2020-07-05 | Butte | California | 6007 | 224 | 3 |
303052 | 303052 | 2020-07-05 | Calaveras | California | 6009 | 53 | 0 |
303053 | 303053 | 2020-07-05 | Colusa | California | 6011 | 76 | 0 |
303054 | 303054 | 2020-07-05 | Contra Costa | California | 6013 | 3662 | 81 |
303055 | 303055 | 2020-07-05 | Del Norte | California | 6015 | 58 | 0 |
303056 | 303056 | 2020-07-05 | El Dorado | California | 6017 | 226 | 0 |
303057 | 303057 | 2020-07-05 | Fresno | California | 6019 | 6110 | 77 |
303058 | 303058 | 2020-07-05 | Glenn | California | 6021 | 128 | 0 |
303059 | 303059 | 2020-07-05 | Humboldt | California | 6023 | 144 | 4 |
303060 | 303060 | 2020-07-05 | Imperial | California | 6025 | 7039 | 113 |
303061 | 303061 | 2020-07-05 | Inyo | California | 6027 | 32 | 1 |
303062 | 303062 | 2020-07-05 | Kern | California | 6029 | 5255 | 82 |
303063 | 303063 | 2020-07-05 | Kings | California | 6031 | 2673 | 33 |
303064 | 303064 | 2020-07-05 | Lake | California | 6033 | 89 | 1 |
303065 | 303065 | 2020-07-05 | Lassen | California | 6035 | 242 | 0 |
303066 | 303066 | 2020-07-05 | Los Angeles | California | 6037 | 114993 | 3487 |
303067 | 303067 | 2020-07-05 | Madera | California | 6039 | 578 | 5 |
303068 | 303068 | 2020-07-05 | Marin | California | 6041 | 2656 | 19 |
303069 | 303069 | 2020-07-05 | Mariposa | California | 6043 | 28 | 1 |
303070 | 303070 | 2020-07-05 | Mendocino | California | 6045 | 85 | 0 |
303071 | 303071 | 2020-07-05 | Merced | California | 6047 | 1272 | 11 |
303072 | 303072 | 2020-07-05 | Mono | California | 6051 | 44 | 1 |
303073 | 303073 | 2020-07-05 | Monterey | California | 6053 | 2064 | 15 |
303074 | 303074 | 2020-07-05 | Napa | California | 6055 | 427 | 4 |
303075 | 303075 | 2020-07-05 | Nevada | California | 6057 | 129 | 1 |
303076 | 303076 | 2020-07-05 | Orange | California | 6059 | 19247 | 363 |
303077 | 303077 | 2020-07-05 | Placer | California | 6061 | 877 | 11 |
303078 | 303078 | 2020-07-05 | Plumas | California | 6063 | 11 | 0 |
303079 | 303079 | 2020-07-05 | Riverside | California | 6065 | 21508 | 479 |
303080 | 303080 | 2020-07-05 | Sacramento | California | 6067 | 4235 | 69 |
303081 | 303081 | 2020-07-05 | San Benito | California | 6069 | 273 | 2 |
303082 | 303082 | 2020-07-05 | San Bernardino | California | 6071 | 14922 | 269 |
303083 | 303083 | 2020-07-05 | San Diego | California | 6073 | 16789 | 387 |
303084 | 303084 | 2020-07-05 | San Francisco | California | 6075 | 3864 | 50 |
303085 | 303085 | 2020-07-05 | San Joaquin | California | 6077 | 4807 | 55 |
303086 | 303086 | 2020-07-05 | San Luis Obispo | California | 6079 | 699 | 2 |
303087 | 303087 | 2020-07-05 | San Mateo | California | 6081 | 3536 | 108 |
303088 | 303088 | 2020-07-05 | Santa Barbara | California | 6083 | 3520 | 29 |
303089 | 303089 | 2020-07-05 | Santa Clara | California | 6085 | 5273 | 162 |
303090 | 303090 | 2020-07-05 | Santa Cruz | California | 6087 | 466 | 3 |
303091 | 303091 | 2020-07-05 | Shasta | California | 6089 | 154 | 5 |
303092 | 303092 | 2020-07-05 | Sierra | California | 6091 | 1 | 0 |
303093 | 303093 | 2020-07-05 | Siskiyou | California | 6093 | 31 | 0 |
303094 | 303094 | 2020-07-05 | Solano | California | 6095 | 1553 | 25 |
303095 | 303095 | 2020-07-05 | Sonoma | California | 6097 | 1370 | 11 |
303096 | 303096 | 2020-07-05 | Stanislaus | California | 6099 | 3572 | 45 |
303097 | 303097 | 2020-07-05 | Sutter | California | 6101 | 252 | 3 |
303098 | 303098 | 2020-07-05 | Tehama | California | 6103 | 92 | 1 |
303099 | 303099 | 2020-07-05 | Trinity | California | 6105 | 3 | 0 |
303100 | 303100 | 2020-07-05 | Tulare | California | 6107 | 4802 | 136 |
303101 | 303101 | 2020-07-05 | Tuolumne | California | 6109 | 43 | 0 |
303102 | 303102 | 2020-07-05 | Ventura | California | 6111 | 3687 | 47 |
303103 | 303103 | 2020-07-05 | Yolo | California | 6113 | 677 | 26 |
303104 | 303104 | 2020-07-05 | Yuba | California | 6115 | 128 | 2 |
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);