ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-09-30" 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 |
---|---|---|---|---|---|---|---|
583193 | 583193 | 2020-09-30 | Alameda | California | 6001 | 21404 | 412 |
583194 | 583194 | 2020-09-30 | Alpine | California | 6003 | 2 | 0 |
583195 | 583195 | 2020-09-30 | Amador | California | 6005 | 293 | 16 |
583196 | 583196 | 2020-09-30 | Butte | California | 6007 | 2848 | 45 |
583197 | 583197 | 2020-09-30 | Calaveras | California | 6009 | 322 | 14 |
583198 | 583198 | 2020-09-30 | Colusa | California | 6011 | 536 | 6 |
583199 | 583199 | 2020-09-30 | Contra Costa | California | 6013 | 16896 | 209 |
583200 | 583200 | 2020-09-30 | Del Norte | California | 6015 | 144 | 1 |
583201 | 583201 | 2020-09-30 | El Dorado | California | 6017 | 1151 | 4 |
583202 | 583202 | 2020-09-30 | Fresno | California | 6019 | 28621 | 390 |
583203 | 583203 | 2020-09-30 | Glenn | California | 6021 | 589 | 3 |
583204 | 583204 | 2020-09-30 | Humboldt | California | 6023 | 512 | 8 |
583205 | 583205 | 2020-09-30 | Imperial | California | 6025 | 11908 | 319 |
583206 | 583206 | 2020-09-30 | Inyo | California | 6027 | 188 | 15 |
583207 | 583207 | 2020-09-30 | Kern | California | 6029 | 32128 | 370 |
583208 | 583208 | 2020-09-30 | Kings | California | 6031 | 7682 | 80 |
583209 | 583209 | 2020-09-30 | Lake | California | 6033 | 566 | 11 |
583210 | 583210 | 2020-09-30 | Lassen | California | 6035 | 741 | 0 |
583211 | 583211 | 2020-09-30 | Los Angeles | California | 6037 | 270299 | 6576 |
583212 | 583212 | 2020-09-30 | Madera | California | 6039 | 4557 | 65 |
583213 | 583213 | 2020-09-30 | Marin | California | 6041 | 6742 | 119 |
583214 | 583214 | 2020-09-30 | Mariposa | California | 6043 | 76 | 2 |
583215 | 583215 | 2020-09-30 | Mendocino | California | 6045 | 964 | 19 |
583216 | 583216 | 2020-09-30 | Merced | California | 6047 | 8993 | 145 |
583217 | 583217 | 2020-09-30 | Modoc | California | 6049 | 27 | 0 |
583218 | 583218 | 2020-09-30 | Mono | California | 6051 | 167 | 2 |
583219 | 583219 | 2020-09-30 | Monterey | California | 6053 | 10087 | 73 |
583220 | 583220 | 2020-09-30 | Napa | California | 6055 | 1728 | 13 |
583221 | 583221 | 2020-09-30 | Nevada | California | 6057 | 543 | 7 |
583222 | 583222 | 2020-09-30 | Orange | California | 6059 | 55239 | 1268 |
583223 | 583223 | 2020-09-30 | Placer | California | 6061 | 3604 | 48 |
583224 | 583224 | 2020-09-30 | Plumas | California | 6063 | 48 | 0 |
583225 | 583225 | 2020-09-30 | Riverside | California | 6065 | 59405 | 1226 |
583226 | 583226 | 2020-09-30 | Sacramento | California | 6067 | 22653 | 420 |
583227 | 583227 | 2020-09-30 | San Benito | California | 6069 | 1352 | 11 |
583228 | 583228 | 2020-09-30 | San Bernardino | California | 6071 | 55203 | 955 |
583229 | 583229 | 2020-09-30 | San Diego | California | 6073 | 47243 | 783 |
583230 | 583230 | 2020-09-30 | San Francisco | California | 6075 | 11278 | 104 |
583231 | 583231 | 2020-09-30 | San Joaquin | California | 6077 | 20411 | 456 |
583232 | 583232 | 2020-09-30 | San Luis Obispo | California | 6079 | 3629 | 31 |
583233 | 583233 | 2020-09-30 | San Mateo | California | 6081 | 9990 | 150 |
583234 | 583234 | 2020-09-30 | Santa Barbara | California | 6083 | 9197 | 114 |
583235 | 583235 | 2020-09-30 | Santa Clara | California | 6085 | 21379 | 323 |
583236 | 583236 | 2020-09-30 | Santa Cruz | California | 6087 | 2423 | 12 |
583237 | 583237 | 2020-09-30 | Shasta | California | 6089 | 943 | 20 |
583238 | 583238 | 2020-09-30 | Sierra | California | 6091 | 6 | 0 |
583239 | 583239 | 2020-09-30 | Siskiyou | California | 6093 | 166 | 0 |
583240 | 583240 | 2020-09-30 | Solano | California | 6095 | 6450 | 71 |
583241 | 583241 | 2020-09-30 | Sonoma | California | 6097 | 7578 | 122 |
583242 | 583242 | 2020-09-30 | Stanislaus | California | 6099 | 16512 | 362 |
583243 | 583243 | 2020-09-30 | Sutter | California | 6101 | 1726 | 11 |
583244 | 583244 | 2020-09-30 | Tehama | California | 6103 | 585 | 5 |
583245 | 583245 | 2020-09-30 | Trinity | California | 6105 | 17 | 0 |
583246 | 583246 | 2020-09-30 | Tulare | California | 6107 | 16267 | 263 |
583247 | 583247 | 2020-09-30 | Tuolumne | California | 6109 | 228 | 4 |
583248 | 583248 | 2020-09-30 | Ventura | California | 6111 | 12875 | 152 |
583249 | 583249 | 2020-09-30 | Yolo | California | 6113 | 2828 | 55 |
583250 | 583250 | 2020-09-30 | Yuba | California | 6115 | 1177 | 8 |
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);