ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-11-30" 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 |
---|---|---|---|---|---|---|---|
781076 | 781076 | 2020-11-30 | Alameda | California | 6001 | 29939 | 512 |
781077 | 781077 | 2020-11-30 | Alpine | California | 6003 | 41 | 0 |
781078 | 781078 | 2020-11-30 | Amador | California | 6005 | 547 | 16 |
781079 | 781079 | 2020-11-30 | Butte | California | 6007 | 4131 | 60 |
781080 | 781080 | 2020-11-30 | Calaveras | California | 6009 | 478 | 22 |
781081 | 781081 | 2020-11-30 | Colusa | California | 6011 | 737 | 6 |
781082 | 781082 | 2020-11-30 | Contra Costa | California | 6013 | 24475 | 261 |
781083 | 781083 | 2020-11-30 | Del Norte | California | 6015 | 339 | 1 |
781084 | 781084 | 2020-11-30 | El Dorado | California | 6017 | 2447 | 4 |
781085 | 781085 | 2020-11-30 | Fresno | California | 6019 | 38568 | 481 |
781086 | 781086 | 2020-11-30 | Glenn | California | 6021 | 951 | 8 |
781087 | 781087 | 2020-11-30 | Humboldt | California | 6023 | 898 | 9 |
781088 | 781088 | 2020-11-30 | Imperial | California | 6025 | 16272 | 355 |
781089 | 781089 | 2020-11-30 | Inyo | California | 6027 | 289 | 16 |
781090 | 781090 | 2020-11-30 | Kern | California | 6029 | 41957 | 448 |
781091 | 781091 | 2020-11-30 | Kings | California | 6031 | 11366 | 87 |
781092 | 781092 | 2020-11-30 | Lake | California | 6033 | 927 | 19 |
781093 | 781093 | 2020-11-30 | Lassen | California | 6035 | 2159 | 2 |
781094 | 781094 | 2020-11-30 | Los Angeles | California | 6037 | 401034 | 7655 |
781095 | 781095 | 2020-11-30 | Madera | California | 6039 | 6290 | 85 |
781096 | 781096 | 2020-11-30 | Marin | California | 6041 | 7808 | 129 |
781097 | 781097 | 2020-11-30 | Mariposa | California | 6043 | 139 | 2 |
781098 | 781098 | 2020-11-30 | Mendocino | California | 6045 | 1594 | 23 |
781099 | 781099 | 2020-11-30 | Merced | California | 6047 | 12175 | 181 |
781100 | 781100 | 2020-11-30 | Modoc | California | 6049 | 151 | 0 |
781101 | 781101 | 2020-11-30 | Mono | California | 6051 | 548 | 3 |
781102 | 781102 | 2020-11-30 | Monterey | California | 6053 | 15621 | 122 |
781103 | 781103 | 2020-11-30 | Napa | California | 6055 | 3091 | 17 |
781104 | 781104 | 2020-11-30 | Nevada | California | 6057 | 1348 | 9 |
781105 | 781105 | 2020-11-30 | Orange | California | 6059 | 80841 | 1577 |
781106 | 781106 | 2020-11-30 | Placer | California | 6061 | 6622 | 70 |
781107 | 781107 | 2020-11-30 | Plumas | California | 6063 | 191 | 0 |
781108 | 781108 | 2020-11-30 | Riverside | California | 6065 | 87383 | 1442 |
781109 | 781109 | 2020-11-30 | Sacramento | California | 6067 | 37883 | 581 |
781110 | 781110 | 2020-11-30 | San Benito | California | 6069 | 1893 | 16 |
781111 | 781111 | 2020-11-30 | San Bernardino | California | 6071 | 93671 | 1129 |
781112 | 781112 | 2020-11-30 | San Diego | California | 6073 | 82106 | 997 |
781113 | 781113 | 2020-11-30 | San Francisco | California | 6075 | 15574 | 160 |
781114 | 781114 | 2020-11-30 | San Joaquin | California | 6077 | 25920 | 509 |
781115 | 781115 | 2020-11-30 | San Luis Obispo | California | 6079 | 6311 | 38 |
781116 | 781116 | 2020-11-30 | San Mateo | California | 6081 | 14458 | 170 |
781117 | 781117 | 2020-11-30 | Santa Barbara | California | 6083 | 11602 | 136 |
781118 | 781118 | 2020-11-30 | Santa Clara | California | 6085 | 35085 | 477 |
781119 | 781119 | 2020-11-30 | Santa Cruz | California | 6087 | 4529 | 28 |
781120 | 781120 | 2020-11-30 | Shasta | California | 6089 | 4963 | 47 |
781121 | 781121 | 2020-11-30 | Sierra | California | 6091 | 16 | 0 |
781122 | 781122 | 2020-11-30 | Siskiyou | California | 6093 | 722 | 3 |
781123 | 781123 | 2020-11-30 | Solano | California | 6095 | 10653 | 81 |
781124 | 781124 | 2020-11-30 | Sonoma | California | 6097 | 12319 | 157 |
781125 | 781125 | 2020-11-30 | Stanislaus | California | 6099 | 23656 | 426 |
781126 | 781126 | 2020-11-30 | Sutter | California | 6101 | 3565 | 17 |
781127 | 781127 | 2020-11-30 | Tehama | California | 6103 | 1710 | 25 |
781128 | 781128 | 2020-11-30 | Trinity | California | 6105 | 160 | 0 |
781129 | 781129 | 2020-11-30 | Tulare | California | 6107 | 20913 | 312 |
781130 | 781130 | 2020-11-30 | Tuolumne | California | 6109 | 1055 | 8 |
781131 | 781131 | 2020-11-30 | Ventura | California | 6111 | 20066 | 183 |
781132 | 781132 | 2020-11-30 | Yolo | California | 6113 | 4893 | 77 |
781133 | 781133 | 2020-11-30 | Yuba | California | 6115 | 2158 | 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);