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 2022-01-04 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2080053 | 2080053 | 2022-01-04 | Alameda | California | 6001 | 145735 | 1546 |
2080054 | 2080054 | 2022-01-04 | Alpine | California | 6003 | 113 | 0 |
2080055 | 2080055 | 2022-01-04 | Amador | California | 6005 | 6082 | 71 |
2080056 | 2080056 | 2022-01-04 | Butte | California | 6007 | 27062 | 345 |
2080057 | 2080057 | 2022-01-04 | Calaveras | California | 6009 | 4812 | 93 |
2080058 | 2080058 | 2022-01-04 | Colusa | California | 6011 | 3400 | 21 |
2080059 | 2080059 | 2022-01-04 | Contra Costa | California | 6013 | 117688 | 1073 |
2080060 | 2080060 | 2022-01-04 | Del Norte | California | 6015 | 4016 | 43 |
2080061 | 2080061 | 2022-01-04 | El Dorado | California | 6017 | 20118 | 172 |
2080062 | 2080062 | 2022-01-04 | Fresno | California | 6019 | 165814 | 2379 |
2080063 | 2080063 | 2022-01-04 | Glenn | California | 6021 | 4765 | 54 |
2080064 | 2080064 | 2022-01-04 | Humboldt | California | 6023 | 11600 | 123 |
2080065 | 2080065 | 2022-01-04 | Imperial | California | 6025 | 42815 | 799 |
2080066 | 2080066 | 2022-01-04 | Inyo | California | 6027 | 2885 | 49 |
2080067 | 2080067 | 2022-01-04 | Kern | California | 6029 | 166183 | 1918 |
2080068 | 2080068 | 2022-01-04 | Kings | California | 6031 | 37058 | 389 |
2080069 | 2080069 | 2022-01-04 | Lake | California | 6033 | 7313 | 117 |
2080070 | 2080070 | 2022-01-04 | Lassen | California | 6035 | 8110 | 61 |
2080071 | 2080071 | 2022-01-04 | Los Angeles | California | 6037 | 1780858 | 27671 |
2080072 | 2080072 | 2022-01-04 | Madera | California | 6039 | 27668 | 324 |
2080073 | 2080073 | 2022-01-04 | Marin | California | 6041 | 22268 | 251 |
2080074 | 2080074 | 2022-01-04 | Mariposa | California | 6043 | 1794 | 18 |
2080075 | 2080075 | 2022-01-04 | Mendocino | California | 6045 | 9272 | 105 |
2080076 | 2080076 | 2022-01-04 | Merced | California | 6047 | 48055 | 706 |
2080077 | 2080077 | 2022-01-04 | Modoc | California | 6049 | 1116 | 11 |
2080078 | 2080078 | 2022-01-04 | Mono | California | 6051 | 2193 | 4 |
2080079 | 2080079 | 2022-01-04 | Monterey | California | 6053 | 55957 | 649 |
2080080 | 2080080 | 2022-01-04 | Napa | California | 6055 | 15421 | 107 |
2080081 | 2080081 | 2022-01-04 | Nevada | California | 6057 | 10943 | 110 |
2080082 | 2080082 | 2022-01-04 | Orange | California | 6059 | 379073 | 5897 |
2080083 | 2080083 | 2022-01-04 | Placer | California | 6061 | 46280 | 489 |
2080084 | 2080084 | 2022-01-04 | Plumas | California | 6063 | 2065 | 12 |
2080085 | 2080085 | 2022-01-04 | Riverside | California | 6065 | 428055 | 5589 |
2080086 | 2080086 | 2022-01-04 | Sacramento | California | 6067 | 186018 | 2552 |
2080087 | 2080087 | 2022-01-04 | San Benito | California | 6069 | 8894 | 79 |
2080088 | 2080088 | 2022-01-04 | San Bernardino | California | 6071 | 414681 | 6056 |
2080089 | 2080089 | 2022-01-04 | San Diego | California | 6073 | 475149 | 4476 |
2080090 | 2080090 | 2022-01-04 | San Francisco | California | 6075 | 72743 | 686 |
2080091 | 2080091 | 2022-01-04 | San Joaquin | California | 6077 | 115858 | 1903 |
2080092 | 2080092 | 2022-01-04 | San Luis Obispo | California | 6079 | 35182 | 367 |
2080093 | 2080093 | 2022-01-04 | San Mateo | California | 6081 | 67040 | 636 |
2080094 | 2080094 | 2022-01-04 | Santa Barbara | California | 6083 | 53756 | 571 |
2080095 | 2080095 | 2022-01-04 | Santa Clara | California | 6085 | 176928 | 1964 |
2080096 | 2080096 | 2022-01-04 | Santa Cruz | California | 6087 | 24940 | 228 |
2080097 | 2080097 | 2022-01-04 | Shasta | California | 6089 | 27172 | 494 |
2080098 | 2080098 | 2022-01-04 | Sierra | California | 6091 | 236 | 0 |
2080099 | 2080099 | 2022-01-04 | Siskiyou | California | 6093 | 5182 | 80 |
2080100 | 2080100 | 2022-01-04 | Solano | California | 6095 | 52478 | 380 |
2080101 | 2080101 | 2022-01-04 | Sonoma | California | 6097 | 49030 | 418 |
2080102 | 2080102 | 2022-01-04 | Stanislaus | California | 6099 | 96951 | 1481 |
2080103 | 2080103 | 2022-01-04 | Sutter | California | 6101 | 15423 | 200 |
2080104 | 2080104 | 2022-01-04 | Tehama | California | 6103 | 10611 | 140 |
2080105 | 2080105 | 2022-01-04 | Trinity | California | 6105 | 1044 | 18 |
2080106 | 2080106 | 2022-01-04 | Tulare | California | 6107 | 90409 | 1167 |
2080107 | 2080107 | 2022-01-04 | Tuolumne | California | 6109 | 8512 | 149 |
2080108 | 2080108 | 2022-01-04 | Ventura | California | 6111 | 117641 | 1211 |
2080109 | 2080109 | 2022-01-04 | Yolo | California | 6113 | 24016 | 270 |
2080110 | 2080110 | 2022-01-04 | Yuba | California | 6115 | 11956 | 99 |
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);