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 2021-03-24 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 |
---|---|---|---|---|---|---|---|
1151077 | 1151077 | 2021-03-24 | Alameda | California | 6001 | 82839 | 1377 |
1151078 | 1151078 | 2021-03-24 | Alpine | California | 6003 | 84 | 0 |
1151079 | 1151079 | 2021-03-24 | Amador | California | 6005 | 3523 | 45 |
1151080 | 1151080 | 2021-03-24 | Butte | California | 6007 | 11227 | 187 |
1151081 | 1151081 | 2021-03-24 | Calaveras | California | 6009 | 1971 | 51 |
1151082 | 1151082 | 2021-03-24 | Colusa | California | 6011 | 2158 | 16 |
1151083 | 1151083 | 2021-03-24 | Contra Costa | California | 6013 | 64801 | 750 |
1151084 | 1151084 | 2021-03-24 | Del Norte | California | 6015 | 1113 | 6 |
1151085 | 1151085 | 2021-03-24 | El Dorado | California | 6017 | 9318 | 107 |
1151086 | 1151086 | 2021-03-24 | Fresno | California | 6019 | 98362 | 1575 |
1151087 | 1151087 | 2021-03-24 | Glenn | California | 6021 | 2790 | 24 |
1151088 | 1151088 | 2021-03-24 | Humboldt | California | 6023 | 3432 | 34 |
1151089 | 1151089 | 2021-03-24 | Imperial | California | 6025 | 27320 | 711 |
1151090 | 1151090 | 2021-03-24 | Inyo | California | 6027 | 1364 | 35 |
1151091 | 1151091 | 2021-03-24 | Kern | California | 6029 | 105810 | 1191 |
1151092 | 1151092 | 2021-03-24 | Kings | California | 6031 | 22546 | 239 |
1151093 | 1151093 | 2021-03-24 | Lake | California | 6033 | 3294 | 43 |
1151094 | 1151094 | 2021-03-24 | Lassen | California | 6035 | 5637 | 24 |
1151095 | 1151095 | 2021-03-24 | Los Angeles | California | 6037 | 1216386 | 22960 |
1151096 | 1151096 | 2021-03-24 | Madera | California | 6039 | 15908 | 231 |
1151097 | 1151097 | 2021-03-24 | Marin | California | 6041 | 13514 | 221 |
1151098 | 1151098 | 2021-03-24 | Mariposa | California | 6043 | 406 | 7 |
1151099 | 1151099 | 2021-03-24 | Mendocino | California | 6045 | 3928 | 46 |
1151100 | 1151100 | 2021-03-24 | Merced | California | 6047 | 30340 | 431 |
1151101 | 1151101 | 2021-03-24 | Modoc | California | 6049 | 467 | 4 |
1151102 | 1151102 | 2021-03-24 | Mono | California | 6051 | 1263 | 4 |
1151103 | 1151103 | 2021-03-24 | Monterey | California | 6053 | 42817 | 338 |
1151104 | 1151104 | 2021-03-24 | Napa | California | 6055 | 9306 | 78 |
1151105 | 1151105 | 2021-03-24 | Nevada | California | 6057 | 4197 | 89 |
1151106 | 1151106 | 2021-03-24 | Orange | California | 6059 | 265219 | 4646 |
1151107 | 1151107 | 2021-03-24 | Placer | California | 6061 | 20665 | 251 |
1151108 | 1151108 | 2021-03-24 | Plumas | California | 6063 | 652 | 4 |
1151109 | 1151109 | 2021-03-24 | Riverside | California | 6065 | 293600 | 4190 |
1151110 | 1151110 | 2021-03-24 | Sacramento | California | 6067 | 96615 | 1590 |
1151111 | 1151111 | 2021-03-24 | San Benito | California | 6069 | 5845 | 61 |
1151112 | 1151112 | 2021-03-24 | San Bernardino | California | 6071 | 290030 | 4134 |
1151113 | 1151113 | 2021-03-24 | San Diego | California | 6073 | 268480 | 3509 |
1151114 | 1151114 | 2021-03-24 | San Francisco | California | 6075 | 35074 | 462 |
1151115 | 1151115 | 2021-03-24 | San Joaquin | California | 6077 | 69187 | 1244 |
1151116 | 1151116 | 2021-03-24 | San Luis Obispo | California | 6079 | 20309 | 253 |
1151117 | 1151117 | 2021-03-24 | San Mateo | California | 6081 | 40032 | 544 |
1151118 | 1151118 | 2021-03-24 | Santa Barbara | California | 6083 | 32933 | 438 |
1151119 | 1151119 | 2021-03-24 | Santa Clara | California | 6085 | 113814 | 1917 |
1151120 | 1151120 | 2021-03-24 | Santa Cruz | California | 6087 | 15258 | 201 |
1151121 | 1151121 | 2021-03-24 | Shasta | California | 6089 | 11307 | 200 |
1151122 | 1151122 | 2021-03-24 | Sierra | California | 6091 | 50 | 0 |
1151123 | 1151123 | 2021-03-24 | Siskiyou | California | 6093 | 1863 | 15 |
1151124 | 1151124 | 2021-03-24 | Solano | California | 6095 | 30912 | 187 |
1151125 | 1151125 | 2021-03-24 | Sonoma | California | 6097 | 29059 | 310 |
1151126 | 1151126 | 2021-03-24 | Stanislaus | California | 6099 | 58425 | 985 |
1151127 | 1151127 | 2021-03-24 | Sutter | California | 6101 | 9079 | 104 |
1151128 | 1151128 | 2021-03-24 | Tehama | California | 6103 | 4707 | 46 |
1151129 | 1151129 | 2021-03-24 | Trinity | California | 6105 | 311 | 3 |
1151130 | 1151130 | 2021-03-24 | Tulare | California | 6107 | 48901 | 808 |
1151131 | 1151131 | 2021-03-24 | Tuolumne | California | 6109 | 4020 | 62 |
1151132 | 1151132 | 2021-03-24 | Ventura | California | 6111 | 79309 | 961 |
1151133 | 1151133 | 2021-03-24 | Yolo | California | 6113 | 13255 | 196 |
1151134 | 1151134 | 2021-03-24 | Yuba | California | 6115 | 5926 | 42 |
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);