ny_times_us_counties

Table actions
⚠️ 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

20,629 rows where state = "California" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

state

  • California · 20,629 ✖
Link rowid date ▲ county state fips cases deaths
1095885 1095885 2021-03-07 Alameda California 6001 81366 1292
1095886 1095886 2021-03-07 Alpine California 6003 78 0
1095887 1095887 2021-03-07 Amador California 6005 3486 41
1095888 1095888 2021-03-07 Butte California 6007 11065 169
1095889 1095889 2021-03-07 Calaveras California 6009 1904 49
1095890 1095890 2021-03-07 Colusa California 6011 2142 13
1095891 1095891 2021-03-07 Contra Costa California 6013 63400 708
1095892 1095892 2021-03-07 Del Norte California 6015 1027 5
1095893 1095893 2021-03-07 El Dorado California 6017 9166 100
1095894 1095894 2021-03-07 Fresno California 6019 96366 1488
1095895 1095895 2021-03-07 Glenn California 6021 2241 23
1095896 1095896 2021-03-07 Humboldt California 6023 3266 33
1095897 1095897 2021-03-07 Imperial California 6025 27009 638
1095898 1095898 2021-03-07 Inyo California 6027 1312 37
1095899 1095899 2021-03-07 Kern California 6029 104242 942
1095900 1095900 2021-03-07 Kings California 6031 22184 227
1095901 1095901 2021-03-07 Lake California 6033 3189 41
1095902 1095902 2021-03-07 Lassen California 6035 5623 24
1095903 1095903 2021-03-07 Los Angeles California 6037 1203799 22029
1095904 1095904 2021-03-07 Madera California 6039 15646 214
1095905 1095905 2021-03-07 Marin California 6041 13289 198
1095906 1095906 2021-03-07 Mariposa California 6043 395 7
1095907 1095907 2021-03-07 Mendocino California 6045 3842 44
1095908 1095908 2021-03-07 Merced California 6047 29376 413
1095909 1095909 2021-03-07 Modoc California 6049 338 4
1095910 1095910 2021-03-07 Mono California 6051 1198 4
1095911 1095911 2021-03-07 Monterey California 6053 42404 331
1095912 1095912 2021-03-07 Napa California 6055 9130 75
1095913 1095913 2021-03-07 Nevada California 6057 4044 74
1095914 1095914 2021-03-07 Orange California 6059 262674 4226
1095915 1095915 2021-03-07 Placer California 6061 20035 232
1095916 1095916 2021-03-07 Plumas California 6063 634 6
1095917 1095917 2021-03-07 Riverside California 6065 290904 3892
1095918 1095918 2021-03-07 Sacramento California 6067 94331 1510
1095919 1095919 2021-03-07 San Benito California 6069 5793 61
1095920 1095920 2021-03-07 San Bernardino California 6071 287867 3153
1095921 1095921 2021-03-07 San Diego California 6073 262844 3385
1095922 1095922 2021-03-07 San Francisco California 6075 34563 432
1095923 1095923 2021-03-07 San Joaquin California 6077 67284 1182
1095924 1095924 2021-03-07 San Luis Obispo California 6079 19835 246
1095925 1095925 2021-03-07 San Mateo California 6081 39384 525
1095926 1095926 2021-03-07 Santa Barbara California 6083 32347 423
1095927 1095927 2021-03-07 Santa Clara California 6085 111814 1823
1095928 1095928 2021-03-07 Santa Cruz California 6087 14790 187
1095929 1095929 2021-03-07 Shasta California 6089 11086 179
1095930 1095930 2021-03-07 Sierra California 6091 48 0
1095931 1095931 2021-03-07 Siskiyou California 6093 1790 14
1095932 1095932 2021-03-07 Solano California 6095 30310 167
1095933 1095933 2021-03-07 Sonoma California 6097 28484 303
1095934 1095934 2021-03-07 Stanislaus California 6099 56702 957
1095935 1095935 2021-03-07 Sutter California 6101 8923 98
1095936 1095936 2021-03-07 Tehama California 6103 4610 52
1095937 1095937 2021-03-07 Trinity California 6105 303 5
1095938 1095938 2021-03-07 Tulare California 6107 48203 770
1095939 1095939 2021-03-07 Tuolumne California 6109 3972 59
1095940 1095940 2021-03-07 Ventura California 6111 78439 883
1095941 1095941 2021-03-07 Yolo California 6113 12951 185
1095942 1095942 2021-03-07 Yuba California 6115 5795 39
1092639 1092639 2021-03-06 Alameda California 6001 81276 1289
1092640 1092640 2021-03-06 Alpine California 6003 78 0
1092641 1092641 2021-03-06 Amador California 6005 3483 41
1092642 1092642 2021-03-06 Butte California 6007 11050 169
1092643 1092643 2021-03-06 Calaveras California 6009 1902 49
1092644 1092644 2021-03-06 Colusa California 6011 2142 13
1092645 1092645 2021-03-06 Contra Costa California 6013 63297 708
1092646 1092646 2021-03-06 Del Norte California 6015 1027 5
1092647 1092647 2021-03-06 El Dorado California 6017 9150 100
1092648 1092648 2021-03-06 Fresno California 6019 96184 1488
1092649 1092649 2021-03-06 Glenn California 6021 2241 23
1092650 1092650 2021-03-06 Humboldt California 6023 3266 33
1092651 1092651 2021-03-06 Imperial California 6025 26970 638
1092652 1092652 2021-03-06 Inyo California 6027 1309 37
1092653 1092653 2021-03-06 Kern California 6029 104181 942
1092654 1092654 2021-03-06 Kings California 6031 22175 227
1092655 1092655 2021-03-06 Lake California 6033 3185 41
1092656 1092656 2021-03-06 Lassen California 6035 5623 24
1092657 1092657 2021-03-06 Los Angeles California 6037 1202513 22008
1092658 1092658 2021-03-06 Madera California 6039 15624 214
1092659 1092659 2021-03-06 Marin California 6041 13275 198
1092660 1092660 2021-03-06 Mariposa California 6043 395 7
1092661 1092661 2021-03-06 Mendocino California 6045 3839 44
1092662 1092662 2021-03-06 Merced California 6047 29376 413
1092663 1092663 2021-03-06 Modoc California 6049 337 4
1092664 1092664 2021-03-06 Mono California 6051 1197 4
1092665 1092665 2021-03-06 Monterey California 6053 42404 331
1092666 1092666 2021-03-06 Napa California 6055 9110 75
1092667 1092667 2021-03-06 Nevada California 6057 4033 74
1092668 1092668 2021-03-06 Orange California 6059 262550 4173
1092669 1092669 2021-03-06 Placer California 6061 20035 232
1092670 1092670 2021-03-06 Plumas California 6063 635 6
1092671 1092671 2021-03-06 Riverside California 6065 290904 3892
1092672 1092672 2021-03-06 Sacramento California 6067 94181 1510
1092673 1092673 2021-03-06 San Benito California 6069 5790 61
1092674 1092674 2021-03-06 San Bernardino California 6071 287782 3137
1092675 1092675 2021-03-06 San Diego California 6073 262844 3385
1092676 1092676 2021-03-06 San Francisco California 6075 34529 432
1092677 1092677 2021-03-06 San Joaquin California 6077 67284 1182
1092678 1092678 2021-03-06 San Luis Obispo California 6079 19835 246
1092679 1092679 2021-03-06 San Mateo California 6081 39305 525
1092680 1092680 2021-03-06 Santa Barbara California 6083 32301 423

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
);
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]);