ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

6,330 rows where state = "California" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

state

  • California · 6,330
Link rowid date ▲ county state fips cases deaths
291945 2020-07-03 Alameda California 6001 6493 140
291946 2020-07-03 Alpine California 6003 1 0
291947 2020-07-03 Amador California 6005 29 0
291948 2020-07-03 Butte California 6007 206 3
291949 2020-07-03 Calaveras California 6009 53 0
291950 2020-07-03 Colusa California 6011 70 0
291951 2020-07-03 Contra Costa California 6013 3432 79
291952 2020-07-03 Del Norte California 6015 55 0
291953 2020-07-03 El Dorado California 6017 226 0
291954 2020-07-03 Fresno California 6019 5851 77
291955 2020-07-03 Glenn California 6021 122 0
291956 2020-07-03 Humboldt California 6023 138 4
291957 2020-07-03 Imperial California 6025 6979 104
291958 2020-07-03 Inyo California 6027 29 1
291959 2020-07-03 Kern California 6029 5110 80
291960 2020-07-03 Kings California 6031 2600 33
291961 2020-07-03 Lake California 6033 88 0
291962 2020-07-03 Lassen California 6035 234 0
291963 2020-07-03 Los Angeles California 6037 107667 3454
291964 2020-07-03 Madera California 6039 578 5
291965 2020-07-03 Marin California 6041 2656 19
291966 2020-07-03 Mariposa California 6043 28 1
291967 2020-07-03 Mendocino California 6045 85 0
291968 2020-07-03 Merced California 6047 1272 11
291969 2020-07-03 Mono California 6051 42 1
291970 2020-07-03 Monterey California 6053 1796 15
291971 2020-07-03 Napa California 6055 377 4
291972 2020-07-03 Nevada California 6057 129 1
291973 2020-07-03 Orange California 6059 17056 360
291974 2020-07-03 Placer California 6061 786 11
291975 2020-07-03 Plumas California 6063 8 0
291976 2020-07-03 Riverside California 6065 20253 479
291977 2020-07-03 Sacramento California 6067 3670 69
291978 2020-07-03 San Benito California 6069 260 2
291979 2020-07-03 San Bernardino California 6071 13676 269
291980 2020-07-03 San Diego California 6073 15759 387
291981 2020-07-03 San Francisco California 6075 3722 50
291982 2020-07-03 San Joaquin California 6077 4474 55
291983 2020-07-03 San Luis Obispo California 6079 675 2
291984 2020-07-03 San Mateo California 6081 3441 108
291985 2020-07-03 Santa Barbara California 6083 3385 29
291986 2020-07-03 Santa Clara California 6085 4849 161
291987 2020-07-03 Santa Cruz California 6087 417 3
291988 2020-07-03 Shasta California 6089 148 5
291989 2020-07-03 Sierra California 6091 1 0
291990 2020-07-03 Siskiyou California 6093 31 0
291991 2020-07-03 Solano California 6095 1481 25
291992 2020-07-03 Sonoma California 6097 1267 11
291993 2020-07-03 Stanislaus California 6099 2850 44
291994 2020-07-03 Sutter California 6101 228 3
291995 2020-07-03 Tehama California 6103 86 1
291996 2020-07-03 Trinity California 6105 3 0
291997 2020-07-03 Tulare California 6107 4627 136
291998 2020-07-03 Tuolumne California 6109 43 0
291999 2020-07-03 Ventura California 6111 3394 47
292000 2020-07-03 Yolo California 6113 613 25
292001 2020-07-03 Yuba California 6115 106 1
288868 2020-07-02 Alameda California 6001 6405 138
288869 2020-07-02 Alpine California 6003 1 0
288870 2020-07-02 Amador California 6005 24 0
288871 2020-07-02 Butte California 6007 206 3
288872 2020-07-02 Calaveras California 6009 53 0
288873 2020-07-02 Colusa California 6011 70 0
288874 2020-07-02 Contra Costa California 6013 3326 78
288875 2020-07-02 Del Norte California 6015 51 0
288876 2020-07-02 El Dorado California 6017 198 0
288877 2020-07-02 Fresno California 6019 5626 77
288878 2020-07-02 Glenn California 6021 122 0
288879 2020-07-02 Humboldt California 6023 138 4
288880 2020-07-02 Imperial California 6025 6824 99
288881 2020-07-02 Inyo California 6027 30 1
288882 2020-07-02 Kern California 6029 4949 77
288883 2020-07-02 Kings California 6031 2583 32
288884 2020-07-02 Lake California 6033 87 0
288885 2020-07-02 Lassen California 6035 234 0
288886 2020-07-02 Los Angeles California 6037 107667 3454
288887 2020-07-02 Madera California 6039 566 5
288888 2020-07-02 Marin California 6041 2446 19
288889 2020-07-02 Mariposa California 6043 29 1
288890 2020-07-02 Mendocino California 6045 85 0
288891 2020-07-02 Merced California 6047 1208 11
288892 2020-07-02 Mono California 6051 41 1
288893 2020-07-02 Monterey California 6053 1748 15
288894 2020-07-02 Napa California 6055 348 4
288895 2020-07-02 Nevada California 6057 123 1
288896 2020-07-02 Orange California 6059 15662 354
288897 2020-07-02 Placer California 6061 754 11
288898 2020-07-02 Plumas California 6063 8 0
288899 2020-07-02 Riverside California 6065 19537 465
288900 2020-07-02 Sacramento California 6067 3558 69
288901 2020-07-02 San Benito California 6069 257 2
288902 2020-07-02 San Bernardino California 6071 13152 265
288903 2020-07-02 San Diego California 6073 15270 377
288904 2020-07-02 San Francisco California 6075 3722 50
288905 2020-07-02 San Joaquin California 6077 4298 55
288906 2020-07-02 San Luis Obispo California 6079 675 2
288907 2020-07-02 San Mateo California 6081 3376 108
288908 2020-07-02 Santa Barbara California 6083 3268 29
288909 2020-07-02 Santa Clara California 6085 4750 160
288910 2020-07-02 Santa Cruz California 6087 410 3

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1010.463ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette