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-26 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
370048 | 370048 | 2020-07-26 | Alameda | California | 6001 | 10391 | 178 |
370049 | 370049 | 2020-07-26 | Alpine | California | 6003 | 2 | 0 |
370050 | 370050 | 2020-07-26 | Amador | California | 6005 | 79 | 0 |
370051 | 370051 | 2020-07-26 | Butte | California | 6007 | 810 | 5 |
370052 | 370052 | 2020-07-26 | Calaveras | California | 6009 | 103 | 1 |
370053 | 370053 | 2020-07-26 | Colusa | California | 6011 | 265 | 2 |
370054 | 370054 | 2020-07-26 | Contra Costa | California | 6013 | 6933 | 104 |
370055 | 370055 | 2020-07-26 | Del Norte | California | 6015 | 87 | 0 |
370056 | 370056 | 2020-07-26 | El Dorado | California | 6017 | 528 | 1 |
370057 | 370057 | 2020-07-26 | Fresno | California | 6019 | 12866 | 112 |
370058 | 370058 | 2020-07-26 | Glenn | California | 6021 | 260 | 1 |
370059 | 370059 | 2020-07-26 | Humboldt | California | 6023 | 212 | 4 |
370060 | 370060 | 2020-07-26 | Imperial | California | 6025 | 9067 | 180 |
370061 | 370061 | 2020-07-26 | Inyo | California | 6027 | 43 | 1 |
370062 | 370062 | 2020-07-26 | Kern | California | 6029 | 16910 | 123 |
370063 | 370063 | 2020-07-26 | Kings | California | 6031 | 3838 | 47 |
370064 | 370064 | 2020-07-26 | Lake | California | 6033 | 173 | 1 |
370065 | 370065 | 2020-07-26 | Lassen | California | 6035 | 555 | 0 |
370066 | 370066 | 2020-07-26 | Los Angeles | California | 6037 | 173995 | 4360 |
370067 | 370067 | 2020-07-26 | Madera | California | 6039 | 1724 | 19 |
370068 | 370068 | 2020-07-26 | Marin | California | 6041 | 4649 | 54 |
370069 | 370069 | 2020-07-26 | Mariposa | California | 6043 | 46 | 2 |
370070 | 370070 | 2020-07-26 | Mendocino | California | 6045 | 265 | 6 |
370071 | 370071 | 2020-07-26 | Merced | California | 6047 | 3245 | 27 |
370072 | 370072 | 2020-07-26 | Mono | California | 6051 | 112 | 1 |
370073 | 370073 | 2020-07-26 | Monterey | California | 6053 | 4002 | 23 |
370074 | 370074 | 2020-07-26 | Napa | California | 6055 | 747 | 8 |
370075 | 370075 | 2020-07-26 | Nevada | California | 6057 | 257 | 1 |
370076 | 370076 | 2020-07-26 | Orange | California | 6059 | 34373 | 564 |
370077 | 370077 | 2020-07-26 | Placer | California | 6061 | 1648 | 14 |
370078 | 370078 | 2020-07-26 | Plumas | California | 6063 | 22 | 0 |
370079 | 370079 | 2020-07-26 | Riverside | California | 6065 | 34921 | 637 |
370080 | 370080 | 2020-07-26 | Sacramento | California | 6067 | 8902 | 108 |
370081 | 370081 | 2020-07-26 | San Benito | California | 6069 | 536 | 2 |
370082 | 370082 | 2020-07-26 | San Bernardino | California | 6071 | 29265 | 383 |
370083 | 370083 | 2020-07-26 | San Diego | California | 6073 | 27047 | 533 |
370084 | 370084 | 2020-07-26 | San Francisco | California | 6075 | 5935 | 56 |
370085 | 370085 | 2020-07-26 | San Joaquin | California | 6077 | 10347 | 110 |
370086 | 370086 | 2020-07-26 | San Luis Obispo | California | 6079 | 1530 | 8 |
370087 | 370087 | 2020-07-26 | San Mateo | California | 6081 | 5023 | 117 |
370088 | 370088 | 2020-07-26 | Santa Barbara | California | 6083 | 5880 | 32 |
370089 | 370089 | 2020-07-26 | Santa Clara | California | 6085 | 9041 | 185 |
370090 | 370090 | 2020-07-26 | Santa Cruz | California | 6087 | 939 | 4 |
370091 | 370091 | 2020-07-26 | Shasta | California | 6089 | 311 | 8 |
370092 | 370092 | 2020-07-26 | Sierra | California | 6091 | 1 | 0 |
370093 | 370093 | 2020-07-26 | Siskiyou | California | 6093 | 61 | 0 |
370094 | 370094 | 2020-07-26 | Solano | California | 6095 | 3134 | 35 |
370095 | 370095 | 2020-07-26 | Sonoma | California | 6097 | 2570 | 24 |
370096 | 370096 | 2020-07-26 | Stanislaus | California | 6099 | 7994 | 90 |
370097 | 370097 | 2020-07-26 | Sutter | California | 6101 | 647 | 4 |
370098 | 370098 | 2020-07-26 | Tehama | California | 6103 | 169 | 1 |
370099 | 370099 | 2020-07-26 | Trinity | California | 6105 | 4 | 0 |
370100 | 370100 | 2020-07-26 | Tulare | California | 6107 | 8310 | 168 |
370101 | 370101 | 2020-07-26 | Tuolumne | California | 6109 | 126 | 0 |
370102 | 370102 | 2020-07-26 | Ventura | California | 6111 | 6662 | 67 |
370103 | 370103 | 2020-07-26 | Yolo | California | 6113 | 1394 | 37 |
370104 | 370104 | 2020-07-26 | Yuba | California | 6115 | 382 | 3 |
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);