ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-10-26" 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 |
---|---|---|---|---|---|---|---|
667523 | 667523 | 2020-10-26 | Alameda | California | 6001 | 23412 | 461 |
667524 | 667524 | 2020-10-26 | Alpine | California | 6003 | 3 | 0 |
667525 | 667525 | 2020-10-26 | Amador | California | 6005 | 329 | 16 |
667526 | 667526 | 2020-10-26 | Butte | California | 6007 | 3087 | 52 |
667527 | 667527 | 2020-10-26 | Calaveras | California | 6009 | 342 | 18 |
667528 | 667528 | 2020-10-26 | Colusa | California | 6011 | 551 | 6 |
667529 | 667529 | 2020-10-26 | Contra Costa | California | 6013 | 18640 | 242 |
667530 | 667530 | 2020-10-26 | Del Norte | California | 6015 | 180 | 1 |
667531 | 667531 | 2020-10-26 | El Dorado | California | 6017 | 1328 | 4 |
667532 | 667532 | 2020-10-26 | Fresno | California | 6019 | 30858 | 436 |
667533 | 667533 | 2020-10-26 | Glenn | California | 6021 | 652 | 3 |
667534 | 667534 | 2020-10-26 | Humboldt | California | 6023 | 567 | 10 |
667535 | 667535 | 2020-10-26 | Imperial | California | 6025 | 12882 | 335 |
667536 | 667536 | 2020-10-26 | Inyo | California | 6027 | 226 | 15 |
667537 | 667537 | 2020-10-26 | Kern | California | 6029 | 33928 | 416 |
667538 | 667538 | 2020-10-26 | Kings | California | 6031 | 8246 | 83 |
667539 | 667539 | 2020-10-26 | Lake | California | 6033 | 695 | 15 |
667540 | 667540 | 2020-10-26 | Lassen | California | 6035 | 766 | 1 |
667541 | 667541 | 2020-10-26 | Los Angeles | California | 6037 | 300614 | 7000 |
667542 | 667542 | 2020-10-26 | Madera | California | 6039 | 5020 | 74 |
667543 | 667543 | 2020-10-26 | Marin | California | 6041 | 7097 | 128 |
667544 | 667544 | 2020-10-26 | Mariposa | California | 6043 | 78 | 2 |
667545 | 667545 | 2020-10-26 | Mendocino | California | 6045 | 1136 | 21 |
667546 | 667546 | 2020-10-26 | Merced | California | 6047 | 9531 | 155 |
667547 | 667547 | 2020-10-26 | Modoc | California | 6049 | 36 | 0 |
667548 | 667548 | 2020-10-26 | Mono | California | 6051 | 180 | 2 |
667549 | 667549 | 2020-10-26 | Monterey | California | 6053 | 11419 | 91 |
667550 | 667550 | 2020-10-26 | Napa | California | 6055 | 1963 | 15 |
667551 | 667551 | 2020-10-26 | Nevada | California | 6057 | 623 | 8 |
667552 | 667552 | 2020-10-26 | Orange | California | 6059 | 60583 | 1447 |
667553 | 667553 | 2020-10-26 | Placer | California | 6061 | 4178 | 57 |
667554 | 667554 | 2020-10-26 | Plumas | California | 6063 | 63 | 0 |
667555 | 667555 | 2020-10-26 | Riverside | California | 6065 | 66732 | 1295 |
667556 | 667556 | 2020-10-26 | Sacramento | California | 6067 | 25600 | 491 |
667557 | 667557 | 2020-10-26 | San Benito | California | 6069 | 1442 | 15 |
667558 | 667558 | 2020-10-26 | San Bernardino | California | 6071 | 62774 | 1072 |
667559 | 667559 | 2020-10-26 | San Diego | California | 6073 | 55004 | 870 |
667560 | 667560 | 2020-10-26 | San Francisco | California | 6075 | 12155 | 140 |
667561 | 667561 | 2020-10-26 | San Joaquin | California | 6077 | 21729 | 489 |
667562 | 667562 | 2020-10-26 | San Luis Obispo | California | 6079 | 4174 | 32 |
667563 | 667563 | 2020-10-26 | San Mateo | California | 6081 | 11149 | 159 |
667564 | 667564 | 2020-10-26 | Santa Barbara | California | 6083 | 9820 | 122 |
667565 | 667565 | 2020-10-26 | Santa Clara | California | 6085 | 24313 | 389 |
667566 | 667566 | 2020-10-26 | Santa Cruz | California | 6087 | 2808 | 25 |
667567 | 667567 | 2020-10-26 | Shasta | California | 6089 | 1889 | 30 |
667568 | 667568 | 2020-10-26 | Sierra | California | 6091 | 6 | 0 |
667569 | 667569 | 2020-10-26 | Siskiyou | California | 6093 | 205 | 0 |
667570 | 667570 | 2020-10-26 | Solano | California | 6095 | 7389 | 76 |
667571 | 667571 | 2020-10-26 | Sonoma | California | 6097 | 9402 | 136 |
667572 | 667572 | 2020-10-26 | Stanislaus | California | 6099 | 18436 | 397 |
667573 | 667573 | 2020-10-26 | Sutter | California | 6101 | 1865 | 12 |
667574 | 667574 | 2020-10-26 | Tehama | California | 6103 | 880 | 8 |
667575 | 667575 | 2020-10-26 | Trinity | California | 6105 | 27 | 0 |
667576 | 667576 | 2020-10-26 | Tulare | California | 6107 | 17590 | 288 |
667577 | 667577 | 2020-10-26 | Tuolumne | California | 6109 | 275 | 4 |
667578 | 667578 | 2020-10-26 | Ventura | California | 6111 | 14300 | 165 |
667579 | 667579 | 2020-10-26 | Yolo | California | 6113 | 3207 | 59 |
667580 | 667580 | 2020-10-26 | Yuba | California | 6115 | 1323 | 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);