ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2020-09-19 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
547556 | 547556 | 2020-09-19 | Alameda | California | 6001 | 20515 | 374 |
547557 | 547557 | 2020-09-19 | Alpine | California | 6003 | 2 | 0 |
547558 | 547558 | 2020-09-19 | Amador | California | 6005 | 284 | 16 |
547559 | 547559 | 2020-09-19 | Butte | California | 6007 | 2738 | 35 |
547560 | 547560 | 2020-09-19 | Calaveras | California | 6009 | 311 | 14 |
547561 | 547561 | 2020-09-19 | Colusa | California | 6011 | 509 | 6 |
547562 | 547562 | 2020-09-19 | Contra Costa | California | 6013 | 15835 | 199 |
547563 | 547563 | 2020-09-19 | Del Norte | California | 6015 | 136 | 1 |
547564 | 547564 | 2020-09-19 | El Dorado | California | 6017 | 1064 | 4 |
547565 | 547565 | 2020-09-19 | Fresno | California | 6019 | 27560 | 355 |
547566 | 547566 | 2020-09-19 | Glenn | California | 6021 | 541 | 3 |
547567 | 547567 | 2020-09-19 | Humboldt | California | 6023 | 482 | 6 |
547568 | 547568 | 2020-09-19 | Imperial | California | 6025 | 11558 | 313 |
547569 | 547569 | 2020-09-19 | Inyo | California | 6027 | 177 | 14 |
547570 | 547570 | 2020-09-19 | Kern | California | 6029 | 31379 | 354 |
547571 | 547571 | 2020-09-19 | Kings | California | 6031 | 7284 | 77 |
547572 | 547572 | 2020-09-19 | Lake | California | 6033 | 458 | 10 |
547573 | 547573 | 2020-09-19 | Lassen | California | 6035 | 731 | 0 |
547574 | 547574 | 2020-09-19 | Los Angeles | California | 6037 | 259817 | 6330 |
547575 | 547575 | 2020-09-19 | Madera | California | 6039 | 4296 | 58 |
547576 | 547576 | 2020-09-19 | Marin | California | 6041 | 6576 | 112 |
547577 | 547577 | 2020-09-19 | Mariposa | California | 6043 | 75 | 2 |
547578 | 547578 | 2020-09-19 | Mendocino | California | 6045 | 849 | 18 |
547579 | 547579 | 2020-09-19 | Merced | California | 6047 | 8750 | 134 |
547580 | 547580 | 2020-09-19 | Modoc | California | 6049 | 23 | 0 |
547581 | 547581 | 2020-09-19 | Mono | California | 6051 | 165 | 2 |
547582 | 547582 | 2020-09-19 | Monterey | California | 6053 | 9467 | 67 |
547583 | 547583 | 2020-09-19 | Napa | California | 6055 | 1605 | 13 |
547584 | 547584 | 2020-09-19 | Nevada | California | 6057 | 506 | 6 |
547585 | 547585 | 2020-09-19 | Orange | California | 6059 | 53163 | 1127 |
547586 | 547586 | 2020-09-19 | Placer | California | 6061 | 3428 | 41 |
547587 | 547587 | 2020-09-19 | Plumas | California | 6063 | 45 | 0 |
547588 | 547588 | 2020-09-19 | Riverside | California | 6065 | 56681 | 1153 |
547589 | 547589 | 2020-09-19 | Sacramento | California | 6067 | 21170 | 375 |
547590 | 547590 | 2020-09-19 | San Benito | California | 6069 | 1290 | 11 |
547591 | 547591 | 2020-09-19 | San Bernardino | California | 6071 | 52287 | 908 |
547592 | 547592 | 2020-09-19 | San Diego | California | 6073 | 44356 | 796 |
547593 | 547593 | 2020-09-19 | San Francisco | California | 6075 | 10699 | 97 |
547594 | 547594 | 2020-09-19 | San Joaquin | California | 6077 | 19793 | 414 |
547595 | 547595 | 2020-09-19 | San Luis Obispo | California | 6079 | 3360 | 27 |
547596 | 547596 | 2020-09-19 | San Mateo | California | 6081 | 9522 | 143 |
547597 | 547597 | 2020-09-19 | Santa Barbara | California | 6083 | 8846 | 110 |
547598 | 547598 | 2020-09-19 | Santa Clara | California | 6085 | 20252 | 297 |
547599 | 547599 | 2020-09-19 | Santa Cruz | California | 6087 | 2218 | 8 |
547600 | 547600 | 2020-09-19 | Shasta | California | 6089 | 668 | 14 |
547601 | 547601 | 2020-09-19 | Sierra | California | 6091 | 6 | 0 |
547602 | 547602 | 2020-09-19 | Siskiyou | California | 6093 | 161 | 0 |
547603 | 547603 | 2020-09-19 | Solano | California | 6095 | 6090 | 55 |
547604 | 547604 | 2020-09-19 | Sonoma | California | 6097 | 6998 | 114 |
547605 | 547605 | 2020-09-19 | Stanislaus | California | 6099 | 16289 | 332 |
547606 | 547606 | 2020-09-19 | Sutter | California | 6101 | 1642 | 10 |
547607 | 547607 | 2020-09-19 | Tehama | California | 6103 | 490 | 4 |
547608 | 547608 | 2020-09-19 | Trinity | California | 6105 | 16 | 0 |
547609 | 547609 | 2020-09-19 | Tulare | California | 6107 | 15599 | 256 |
547610 | 547610 | 2020-09-19 | Tuolumne | California | 6109 | 221 | 4 |
547611 | 547611 | 2020-09-19 | Ventura | California | 6111 | 12236 | 143 |
547612 | 547612 | 2020-09-19 | Yolo | California | 6113 | 2740 | 54 |
547613 | 547613 | 2020-09-19 | Yuba | California | 6115 | 1118 | 7 |
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);