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-08-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 |
---|---|---|---|---|---|---|---|
1582894 | 1582894 | 2021-08-04 | Alameda | California | 6001 | 99641 | 1290 |
1582895 | 1582895 | 2021-08-04 | Alpine | California | 6003 | 91 | 0 |
1582896 | 1582896 | 2021-08-04 | Amador | California | 6005 | 3988 | 48 |
1582897 | 1582897 | 2021-08-04 | Butte | California | 6007 | 15558 | 205 |
1582898 | 1582898 | 2021-08-04 | Calaveras | California | 6009 | 2375 | 58 |
1582899 | 1582899 | 2021-08-04 | Colusa | California | 6011 | 2381 | 18 |
1582900 | 1582900 | 2021-08-04 | Contra Costa | California | 6013 | 79290 | 838 |
1582901 | 1582901 | 2021-08-04 | Del Norte | California | 6015 | 1747 | 10 |
1582902 | 1582902 | 2021-08-04 | El Dorado | California | 6017 | 12147 | 120 |
1582903 | 1582903 | 2021-08-04 | Fresno | California | 6019 | 115322 | 1746 |
1582904 | 1582904 | 2021-08-04 | Glenn | California | 6021 | 3081 | 27 |
1582905 | 1582905 | 2021-08-04 | Humboldt | California | 6023 | 5359 | 54 |
1582906 | 1582906 | 2021-08-04 | Imperial | California | 6025 | 32277 | 744 |
1582907 | 1582907 | 2021-08-04 | Inyo | California | 6027 | 1473 | 38 |
1582908 | 1582908 | 2021-08-04 | Kern | California | 6029 | 114342 | 1428 |
1582909 | 1582909 | 2021-08-04 | Kings | California | 6031 | 25050 | 252 |
1582910 | 1582910 | 2021-08-04 | Lake | California | 6033 | 4421 | 66 |
1582911 | 1582911 | 2021-08-04 | Lassen | California | 6035 | 5905 | 26 |
1582912 | 1582912 | 2021-08-04 | Los Angeles | California | 6037 | 1312352 | 24721 |
1582913 | 1582913 | 2021-08-04 | Madera | California | 6039 | 18248 | 249 |
1582914 | 1582914 | 2021-08-04 | Marin | California | 6041 | 15205 | 243 |
1582915 | 1582915 | 2021-08-04 | Mariposa | California | 6043 | 537 | 7 |
1582916 | 1582916 | 2021-08-04 | Mendocino | California | 6045 | 4830 | 52 |
1582917 | 1582917 | 2021-08-04 | Merced | California | 6047 | 33321 | 485 |
1582918 | 1582918 | 2021-08-04 | Modoc | California | 6049 | 576 | 7 |
1582919 | 1582919 | 2021-08-04 | Mono | California | 6051 | 1336 | 5 |
1582920 | 1582920 | 2021-08-04 | Monterey | California | 6053 | 45890 | 529 |
1582921 | 1582921 | 2021-08-04 | Napa | California | 6055 | 10574 | 82 |
1582922 | 1582922 | 2021-08-04 | Nevada | California | 6057 | 5899 | 75 |
1582923 | 1582923 | 2021-08-04 | Orange | California | 6059 | 285620 | 5146 |
1582924 | 1582924 | 2021-08-04 | Placer | California | 6061 | 27540 | 307 |
1582925 | 1582925 | 2021-08-04 | Plumas | California | 6063 | 795 | 6 |
1582926 | 1582926 | 2021-08-04 | Riverside | California | 6065 | 318968 | 4667 |
1582927 | 1582927 | 2021-08-04 | Sacramento | California | 6067 | 119980 | 1790 |
1582928 | 1582928 | 2021-08-04 | San Benito | California | 6069 | 6405 | 63 |
1582929 | 1582929 | 2021-08-04 | San Bernardino | California | 6071 | 313044 | 5265 |
1582930 | 1582930 | 2021-08-04 | San Diego | California | 6073 | 317024 | 3803 |
1582931 | 1582931 | 2021-08-04 | San Francisco | California | 6075 | 43361 | 562 |
1582932 | 1582932 | 2021-08-04 | San Joaquin | California | 6077 | 81736 | 1474 |
1582933 | 1582933 | 2021-08-04 | San Luis Obispo | California | 6079 | 23007 | 267 |
1582934 | 1582934 | 2021-08-04 | San Mateo | California | 6081 | 45827 | 588 |
1582935 | 1582935 | 2021-08-04 | Santa Barbara | California | 6083 | 37328 | 469 |
1582936 | 1582936 | 2021-08-04 | Santa Clara | California | 6085 | 124814 | 2184 |
1582937 | 1582937 | 2021-08-04 | Santa Cruz | California | 6087 | 17663 | 207 |
1582938 | 1582938 | 2021-08-04 | Shasta | California | 6089 | 15057 | 242 |
1582939 | 1582939 | 2021-08-04 | Sierra | California | 6091 | 86 | 0 |
1582940 | 1582940 | 2021-08-04 | Siskiyou | California | 6093 | 2605 | 40 |
1582941 | 1582941 | 2021-08-04 | Solano | California | 6095 | 36674 | 261 |
1582942 | 1582942 | 2021-08-04 | Sonoma | California | 6097 | 33639 | 331 |
1582943 | 1582943 | 2021-08-04 | Stanislaus | California | 6099 | 66619 | 1097 |
1582944 | 1582944 | 2021-08-04 | Sutter | California | 6101 | 10392 | 127 |
1582945 | 1582945 | 2021-08-04 | Tehama | California | 6103 | 5927 | 66 |
1582946 | 1582946 | 2021-08-04 | Trinity | California | 6105 | 433 | 3 |
1582947 | 1582947 | 2021-08-04 | Tulare | California | 6107 | 60807 | 854 |
1582948 | 1582948 | 2021-08-04 | Tuolumne | California | 6109 | 4757 | 73 |
1582949 | 1582949 | 2021-08-04 | Ventura | California | 6111 | 87901 | 1046 |
1582950 | 1582950 | 2021-08-04 | Yolo | California | 6113 | 15629 | 215 |
1582951 | 1582951 | 2021-08-04 | Yuba | California | 6115 | 7148 | 50 |
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);