ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-11-27" 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 |
---|---|---|---|---|---|---|---|
771340 | 771340 | 2020-11-27 | Alameda | California | 6001 | 28878 | 505 |
771341 | 771341 | 2020-11-27 | Alpine | California | 6003 | 41 | 0 |
771342 | 771342 | 2020-11-27 | Amador | California | 6005 | 487 | 16 |
771343 | 771343 | 2020-11-27 | Butte | California | 6007 | 3894 | 59 |
771344 | 771344 | 2020-11-27 | Calaveras | California | 6009 | 478 | 22 |
771345 | 771345 | 2020-11-27 | Colusa | California | 6011 | 694 | 6 |
771346 | 771346 | 2020-11-27 | Contra Costa | California | 6013 | 23571 | 261 |
771347 | 771347 | 2020-11-27 | Del Norte | California | 6015 | 313 | 1 |
771348 | 771348 | 2020-11-27 | El Dorado | California | 6017 | 2217 | 4 |
771349 | 771349 | 2020-11-27 | Fresno | California | 6019 | 37947 | 481 |
771350 | 771350 | 2020-11-27 | Glenn | California | 6021 | 892 | 8 |
771351 | 771351 | 2020-11-27 | Humboldt | California | 6023 | 850 | 9 |
771352 | 771352 | 2020-11-27 | Imperial | California | 6025 | 15862 | 355 |
771353 | 771353 | 2020-11-27 | Inyo | California | 6027 | 289 | 16 |
771354 | 771354 | 2020-11-27 | Kern | California | 6029 | 40632 | 448 |
771355 | 771355 | 2020-11-27 | Kings | California | 6031 | 10687 | 87 |
771356 | 771356 | 2020-11-27 | Lake | California | 6033 | 890 | 19 |
771357 | 771357 | 2020-11-27 | Lassen | California | 6035 | 1773 | 2 |
771358 | 771358 | 2020-11-27 | Los Angeles | California | 6037 | 387793 | 7604 |
771359 | 771359 | 2020-11-27 | Madera | California | 6039 | 6047 | 85 |
771360 | 771360 | 2020-11-27 | Marin | California | 6041 | 7702 | 129 |
771361 | 771361 | 2020-11-27 | Mariposa | California | 6043 | 128 | 2 |
771362 | 771362 | 2020-11-27 | Mendocino | California | 6045 | 1559 | 23 |
771363 | 771363 | 2020-11-27 | Merced | California | 6047 | 11537 | 179 |
771364 | 771364 | 2020-11-27 | Modoc | California | 6049 | 118 | 0 |
771365 | 771365 | 2020-11-27 | Mono | California | 6051 | 542 | 3 |
771366 | 771366 | 2020-11-27 | Monterey | California | 6053 | 14750 | 116 |
771367 | 771367 | 2020-11-27 | Napa | California | 6055 | 2989 | 17 |
771368 | 771368 | 2020-11-27 | Nevada | California | 6057 | 1184 | 9 |
771369 | 771369 | 2020-11-27 | Orange | California | 6059 | 77380 | 1577 |
771370 | 771370 | 2020-11-27 | Placer | California | 6061 | 6354 | 68 |
771371 | 771371 | 2020-11-27 | Plumas | California | 6063 | 188 | 0 |
771372 | 771372 | 2020-11-27 | Riverside | California | 6065 | 85774 | 1437 |
771373 | 771373 | 2020-11-27 | Sacramento | California | 6067 | 36629 | 576 |
771374 | 771374 | 2020-11-27 | San Benito | California | 6069 | 1837 | 16 |
771375 | 771375 | 2020-11-27 | San Bernardino | California | 6071 | 90222 | 1129 |
771376 | 771376 | 2020-11-27 | San Diego | California | 6073 | 78222 | 996 |
771377 | 771377 | 2020-11-27 | San Francisco | California | 6075 | 15159 | 160 |
771378 | 771378 | 2020-11-27 | San Joaquin | California | 6077 | 25738 | 502 |
771379 | 771379 | 2020-11-27 | San Luis Obispo | California | 6079 | 6129 | 36 |
771380 | 771380 | 2020-11-27 | San Mateo | California | 6081 | 13715 | 170 |
771381 | 771381 | 2020-11-27 | Santa Barbara | California | 6083 | 11277 | 135 |
771382 | 771382 | 2020-11-27 | Santa Clara | California | 6085 | 32985 | 477 |
771383 | 771383 | 2020-11-27 | Santa Cruz | California | 6087 | 4269 | 28 |
771384 | 771384 | 2020-11-27 | Shasta | California | 6089 | 4718 | 47 |
771385 | 771385 | 2020-11-27 | Sierra | California | 6091 | 15 | 0 |
771386 | 771386 | 2020-11-27 | Siskiyou | California | 6093 | 624 | 2 |
771387 | 771387 | 2020-11-27 | Solano | California | 6095 | 10041 | 81 |
771388 | 771388 | 2020-11-27 | Sonoma | California | 6097 | 12049 | 157 |
771389 | 771389 | 2020-11-27 | Stanislaus | California | 6099 | 22829 | 424 |
771390 | 771390 | 2020-11-27 | Sutter | California | 6101 | 3144 | 15 |
771391 | 771391 | 2020-11-27 | Tehama | California | 6103 | 1612 | 25 |
771392 | 771392 | 2020-11-27 | Trinity | California | 6105 | 140 | 0 |
771393 | 771393 | 2020-11-27 | Tulare | California | 6107 | 20649 | 308 |
771394 | 771394 | 2020-11-27 | Tuolumne | California | 6109 | 981 | 8 |
771395 | 771395 | 2020-11-27 | Ventura | California | 6111 | 19058 | 175 |
771396 | 771396 | 2020-11-27 | Yolo | California | 6113 | 4626 | 75 |
771397 | 771397 | 2020-11-27 | Yuba | California | 6115 | 1981 | 10 |
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);