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-07-29 and state = "California" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
379690 | 379690 | 2020-07-29 | Alameda | California | 6001 | 10896 | 181 |
379691 | 379691 | 2020-07-29 | Alpine | California | 6003 | 2 | 0 |
379692 | 379692 | 2020-07-29 | Amador | California | 6005 | 108 | 0 |
379693 | 379693 | 2020-07-29 | Butte | California | 6007 | 883 | 7 |
379694 | 379694 | 2020-07-29 | Calaveras | California | 6009 | 108 | 1 |
379695 | 379695 | 2020-07-29 | Colusa | California | 6011 | 304 | 3 |
379696 | 379696 | 2020-07-29 | Contra Costa | California | 6013 | 7714 | 109 |
379697 | 379697 | 2020-07-29 | Del Norte | California | 6015 | 88 | 0 |
379698 | 379698 | 2020-07-29 | El Dorado | California | 6017 | 589 | 1 |
379699 | 379699 | 2020-07-29 | Fresno | California | 6019 | 13933 | 120 |
379700 | 379700 | 2020-07-29 | Glenn | California | 6021 | 289 | 1 |
379701 | 379701 | 2020-07-29 | Humboldt | California | 6023 | 228 | 4 |
379702 | 379702 | 2020-07-29 | Imperial | California | 6025 | 9241 | 187 |
379703 | 379703 | 2020-07-29 | Inyo | California | 6027 | 43 | 1 |
379704 | 379704 | 2020-07-29 | Kern | California | 6029 | 18834 | 136 |
379705 | 379705 | 2020-07-29 | Kings | California | 6031 | 4106 | 51 |
379706 | 379706 | 2020-07-29 | Lake | California | 6033 | 179 | 1 |
379707 | 379707 | 2020-07-29 | Lassen | California | 6035 | 631 | 0 |
379708 | 379708 | 2020-07-29 | Los Angeles | California | 6037 | 183383 | 4516 |
379709 | 379709 | 2020-07-29 | Madera | California | 6039 | 1889 | 28 |
379710 | 379710 | 2020-07-29 | Marin | California | 6041 | 4874 | 61 |
379711 | 379711 | 2020-07-29 | Mariposa | California | 6043 | 51 | 2 |
379712 | 379712 | 2020-07-29 | Mendocino | California | 6045 | 293 | 6 |
379713 | 379713 | 2020-07-29 | Merced | California | 6047 | 3906 | 35 |
379714 | 379714 | 2020-07-29 | Modoc | California | 6049 | 2 | 0 |
379715 | 379715 | 2020-07-29 | Mono | California | 6051 | 125 | 1 |
379716 | 379716 | 2020-07-29 | Monterey | California | 6053 | 4288 | 26 |
379717 | 379717 | 2020-07-29 | Napa | California | 6055 | 860 | 8 |
379718 | 379718 | 2020-07-29 | Nevada | California | 6057 | 288 | 1 |
379719 | 379719 | 2020-07-29 | Orange | California | 6059 | 35272 | 587 |
379720 | 379720 | 2020-07-29 | Placer | California | 6061 | 1790 | 15 |
379721 | 379721 | 2020-07-29 | Plumas | California | 6063 | 22 | 0 |
379722 | 379722 | 2020-07-29 | Riverside | California | 6065 | 36458 | 682 |
379723 | 379723 | 2020-07-29 | Sacramento | California | 6067 | 9513 | 126 |
379724 | 379724 | 2020-07-29 | San Benito | California | 6069 | 601 | 4 |
379725 | 379725 | 2020-07-29 | San Bernardino | California | 6071 | 30493 | 395 |
379726 | 379726 | 2020-07-29 | San Diego | California | 6073 | 28350 | 552 |
379727 | 379727 | 2020-07-29 | San Francisco | California | 6075 | 6200 | 57 |
379728 | 379728 | 2020-07-29 | San Joaquin | California | 6077 | 11209 | 146 |
379729 | 379729 | 2020-07-29 | San Luis Obispo | California | 6079 | 1710 | 12 |
379730 | 379730 | 2020-07-29 | San Mateo | California | 6081 | 5306 | 118 |
379731 | 379731 | 2020-07-29 | Santa Barbara | California | 6083 | 6110 | 32 |
379732 | 379732 | 2020-07-29 | Santa Clara | California | 6085 | 9612 | 188 |
379733 | 379733 | 2020-07-29 | Santa Cruz | California | 6087 | 1030 | 4 |
379734 | 379734 | 2020-07-29 | Shasta | California | 6089 | 348 | 8 |
379735 | 379735 | 2020-07-29 | Sierra | California | 6091 | 1 | 0 |
379736 | 379736 | 2020-07-29 | Siskiyou | California | 6093 | 67 | 0 |
379737 | 379737 | 2020-07-29 | Solano | California | 6095 | 3467 | 37 |
379738 | 379738 | 2020-07-29 | Sonoma | California | 6097 | 2748 | 31 |
379739 | 379739 | 2020-07-29 | Stanislaus | California | 6099 | 8492 | 103 |
379740 | 379740 | 2020-07-29 | Sutter | California | 6101 | 731 | 6 |
379741 | 379741 | 2020-07-29 | Tehama | California | 6103 | 199 | 1 |
379742 | 379742 | 2020-07-29 | Trinity | California | 6105 | 4 | 0 |
379743 | 379743 | 2020-07-29 | Tulare | California | 6107 | 9076 | 173 |
379744 | 379744 | 2020-07-29 | Tuolumne | California | 6109 | 132 | 2 |
379745 | 379745 | 2020-07-29 | Ventura | California | 6111 | 7045 | 73 |
379746 | 379746 | 2020-07-29 | Yolo | California | 6113 | 1477 | 41 |
379747 | 379747 | 2020-07-29 | Yuba | California | 6115 | 441 | 4 |
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);