ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2020-09-04" 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 |
---|---|---|---|---|---|---|---|
499027 | 499027 | 2020-09-04 | Alameda | California | 6001 | 18998 | 296 |
499028 | 499028 | 2020-09-04 | Alpine | California | 6003 | 2 | 0 |
499029 | 499029 | 2020-09-04 | Amador | California | 6005 | 273 | 15 |
499030 | 499030 | 2020-09-04 | Butte | California | 6007 | 2327 | 23 |
499031 | 499031 | 2020-09-04 | Calaveras | California | 6009 | 273 | 2 |
499032 | 499032 | 2020-09-04 | Colusa | California | 6011 | 470 | 6 |
499033 | 499033 | 2020-09-04 | Contra Costa | California | 6013 | 14411 | 186 |
499034 | 499034 | 2020-09-04 | Del Norte | California | 6015 | 124 | 1 |
499035 | 499035 | 2020-09-04 | El Dorado | California | 6017 | 1001 | 2 |
499036 | 499036 | 2020-09-04 | Fresno | California | 6019 | 25978 | 312 |
499037 | 499037 | 2020-09-04 | Glenn | California | 6021 | 460 | 3 |
499038 | 499038 | 2020-09-04 | Humboldt | California | 6023 | 409 | 4 |
499039 | 499039 | 2020-09-04 | Imperial | California | 6025 | 11001 | 295 |
499040 | 499040 | 2020-09-04 | Inyo | California | 6027 | 171 | 14 |
499041 | 499041 | 2020-09-04 | Kern | California | 6029 | 29858 | 296 |
499042 | 499042 | 2020-09-04 | Kings | California | 6031 | 6688 | 76 |
499043 | 499043 | 2020-09-04 | Lake | California | 6033 | 347 | 5 |
499044 | 499044 | 2020-09-04 | Lassen | California | 6035 | 720 | 0 |
499045 | 499045 | 2020-09-04 | Los Angeles | California | 6037 | 246407 | 5977 |
499046 | 499046 | 2020-09-04 | Madera | California | 6039 | 3953 | 58 |
499047 | 499047 | 2020-09-04 | Marin | California | 6041 | 6297 | 96 |
499048 | 499048 | 2020-09-04 | Mariposa | California | 6043 | 74 | 2 |
499049 | 499049 | 2020-09-04 | Mendocino | California | 6045 | 737 | 17 |
499050 | 499050 | 2020-09-04 | Merced | California | 6047 | 8277 | 120 |
499051 | 499051 | 2020-09-04 | Modoc | California | 6049 | 16 | 0 |
499052 | 499052 | 2020-09-04 | Mono | California | 6051 | 162 | 2 |
499053 | 499053 | 2020-09-04 | Monterey | California | 6053 | 8326 | 58 |
499054 | 499054 | 2020-09-04 | Napa | California | 6055 | 1467 | 13 |
499055 | 499055 | 2020-09-04 | Nevada | California | 6057 | 456 | 5 |
499056 | 499056 | 2020-09-04 | Orange | California | 6059 | 50135 | 1042 |
499057 | 499057 | 2020-09-04 | Placer | California | 6061 | 3115 | 35 |
499058 | 499058 | 2020-09-04 | Plumas | California | 6063 | 39 | 0 |
499059 | 499059 | 2020-09-04 | Riverside | California | 6065 | 53987 | 1067 |
499060 | 499060 | 2020-09-04 | Sacramento | California | 6067 | 18812 | 327 |
499061 | 499061 | 2020-09-04 | San Benito | California | 6069 | 1162 | 8 |
499062 | 499062 | 2020-09-04 | San Bernardino | California | 6071 | 48615 | 744 |
499063 | 499063 | 2020-09-04 | San Diego | California | 6073 | 39962 | 701 |
499064 | 499064 | 2020-09-04 | San Francisco | California | 6075 | 9758 | 84 |
499065 | 499065 | 2020-09-04 | San Joaquin | California | 6077 | 18331 | 368 |
499066 | 499066 | 2020-09-04 | San Luis Obispo | California | 6079 | 3074 | 22 |
499067 | 499067 | 2020-09-04 | San Mateo | California | 6081 | 8452 | 135 |
499068 | 499068 | 2020-09-04 | Santa Barbara | California | 6083 | 8361 | 97 |
499069 | 499069 | 2020-09-04 | Santa Clara | California | 6085 | 18190 | 255 |
499070 | 499070 | 2020-09-04 | Santa Cruz | California | 6087 | 1923 | 7 |
499071 | 499071 | 2020-09-04 | Shasta | California | 6089 | 581 | 12 |
499072 | 499072 | 2020-09-04 | Sierra | California | 6091 | 6 | 0 |
499073 | 499073 | 2020-09-04 | Siskiyou | California | 6093 | 144 | 0 |
499074 | 499074 | 2020-09-04 | Solano | California | 6095 | 5676 | 48 |
499075 | 499075 | 2020-09-04 | Sonoma | California | 6097 | 6142 | 93 |
499076 | 499076 | 2020-09-04 | Stanislaus | California | 6099 | 15162 | 282 |
499077 | 499077 | 2020-09-04 | Sutter | California | 6101 | 1465 | 10 |
499078 | 499078 | 2020-09-04 | Tehama | California | 6103 | 436 | 1 |
499079 | 499079 | 2020-09-04 | Trinity | California | 6105 | 14 | 0 |
499080 | 499080 | 2020-09-04 | Tulare | California | 6107 | 14677 | 243 |
499081 | 499081 | 2020-09-04 | Tuolumne | California | 6109 | 193 | 2 |
499082 | 499082 | 2020-09-04 | Ventura | California | 6111 | 11109 | 118 |
499083 | 499083 | 2020-09-04 | Yolo | California | 6113 | 2495 | 53 |
499084 | 499084 | 2020-09-04 | Yuba | California | 6115 | 994 | 6 |
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);