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

This data as json, CSV (advanced)

Suggested facets: date (date)

fips

state

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