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-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 |
---|---|---|---|---|---|---|---|
347613 | 347613 | 2020-07-19 | Alameda | California | 6001 | 9258 | 162 |
347614 | 347614 | 2020-07-19 | Alpine | California | 6003 | 2 | 0 |
347615 | 347615 | 2020-07-19 | Amador | California | 6005 | 52 | 0 |
347616 | 347616 | 2020-07-19 | Butte | California | 6007 | 551 | 4 |
347617 | 347617 | 2020-07-19 | Calaveras | California | 6009 | 89 | 0 |
347618 | 347618 | 2020-07-19 | Colusa | California | 6011 | 182 | 0 |
347619 | 347619 | 2020-07-19 | Contra Costa | California | 6013 | 5617 | 98 |
347620 | 347620 | 2020-07-19 | Del Norte | California | 6015 | 66 | 0 |
347621 | 347621 | 2020-07-19 | El Dorado | California | 6017 | 394 | 0 |
347622 | 347622 | 2020-07-19 | Fresno | California | 6019 | 10381 | 100 |
347623 | 347623 | 2020-07-19 | Glenn | California | 6021 | 212 | 0 |
347624 | 347624 | 2020-07-19 | Humboldt | California | 6023 | 189 | 4 |
347625 | 347625 | 2020-07-19 | Imperial | California | 6025 | 8531 | 160 |
347626 | 347626 | 2020-07-19 | Inyo | California | 6027 | 38 | 1 |
347627 | 347627 | 2020-07-19 | Kern | California | 6029 | 9250 | 105 |
347628 | 347628 | 2020-07-19 | Kings | California | 6031 | 3280 | 41 |
347629 | 347629 | 2020-07-19 | Lake | California | 6033 | 142 | 1 |
347630 | 347630 | 2020-07-19 | Lassen | California | 6035 | 508 | 0 |
347631 | 347631 | 2020-07-19 | Los Angeles | California | 6037 | 155887 | 4095 |
347632 | 347632 | 2020-07-19 | Madera | California | 6039 | 1260 | 11 |
347633 | 347633 | 2020-07-19 | Marin | California | 6041 | 4305 | 40 |
347634 | 347634 | 2020-07-19 | Mariposa | California | 6043 | 37 | 1 |
347635 | 347635 | 2020-07-19 | Mendocino | California | 6045 | 199 | 0 |
347636 | 347636 | 2020-07-19 | Merced | California | 6047 | 2424 | 15 |
347637 | 347637 | 2020-07-19 | Mono | California | 6051 | 79 | 1 |
347638 | 347638 | 2020-07-19 | Monterey | California | 6053 | 3228 | 18 |
347639 | 347639 | 2020-07-19 | Napa | California | 6055 | 610 | 5 |
347640 | 347640 | 2020-07-19 | Nevada | California | 6057 | 204 | 1 |
347641 | 347641 | 2020-07-19 | Orange | California | 6059 | 29603 | 494 |
347642 | 347642 | 2020-07-19 | Placer | California | 6061 | 1363 | 11 |
347643 | 347643 | 2020-07-19 | Plumas | California | 6063 | 17 | 0 |
347644 | 347644 | 2020-07-19 | Riverside | California | 6065 | 30245 | 587 |
347645 | 347645 | 2020-07-19 | Sacramento | California | 6067 | 6934 | 96 |
347646 | 347646 | 2020-07-19 | San Benito | California | 6069 | 448 | 2 |
347647 | 347647 | 2020-07-19 | San Bernardino | California | 6071 | 23772 | 328 |
347648 | 347648 | 2020-07-19 | San Diego | California | 6073 | 23745 | 478 |
347649 | 347649 | 2020-07-19 | San Francisco | California | 6075 | 5205 | 52 |
347650 | 347650 | 2020-07-19 | San Joaquin | California | 6077 | 8118 | 83 |
347651 | 347651 | 2020-07-19 | San Luis Obispo | California | 6079 | 1234 | 6 |
347652 | 347652 | 2020-07-19 | San Mateo | California | 6081 | 4488 | 114 |
347653 | 347653 | 2020-07-19 | Santa Barbara | California | 6083 | 5110 | 32 |
347654 | 347654 | 2020-07-19 | Santa Clara | California | 6085 | 7456 | 178 |
347655 | 347655 | 2020-07-19 | Santa Cruz | California | 6087 | 772 | 3 |
347656 | 347656 | 2020-07-19 | Shasta | California | 6089 | 242 | 7 |
347657 | 347657 | 2020-07-19 | Sierra | California | 6091 | 1 | 0 |
347658 | 347658 | 2020-07-19 | Siskiyou | California | 6093 | 44 | 0 |
347659 | 347659 | 2020-07-19 | Solano | California | 6095 | 2559 | 31 |
347660 | 347660 | 2020-07-19 | Sonoma | California | 6097 | 2169 | 20 |
347661 | 347661 | 2020-07-19 | Stanislaus | California | 6099 | 6344 | 63 |
347662 | 347662 | 2020-07-19 | Sutter | California | 6101 | 520 | 4 |
347663 | 347663 | 2020-07-19 | Tehama | California | 6103 | 136 | 1 |
347664 | 347664 | 2020-07-19 | Trinity | California | 6105 | 3 | 0 |
347665 | 347665 | 2020-07-19 | Tulare | California | 6107 | 6810 | 165 |
347666 | 347666 | 2020-07-19 | Tuolumne | California | 6109 | 85 | 0 |
347667 | 347667 | 2020-07-19 | Ventura | California | 6111 | 5630 | 57 |
347668 | 347668 | 2020-07-19 | Yolo | California | 6113 | 1162 | 32 |
347669 | 347669 | 2020-07-19 | Yuba | California | 6115 | 270 | 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);