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

33,512 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 · 33,512 ✖
Link rowid date ▲ county state fips cases deaths
1816801 1816801 2021-10-15 Alameda California 6001 119908 1372
1816802 1816802 2021-10-15 Alpine California 6003 102 0
1816803 1816803 2021-10-15 Amador California 6005 5371 64
1816804 1816804 2021-10-15 Butte California 6007 23364 260
1816805 1816805 2021-10-15 Calaveras California 6009 3817 80
1816806 1816806 2021-10-15 Colusa California 6011 3017 18
1816807 1816807 2021-10-15 Contra Costa California 6013 99234 982
1816808 1816808 2021-10-15 Del Norte California 6015 3657 41
1816809 1816809 2021-10-15 El Dorado California 6017 16960 149
1816810 1816810 2021-10-15 Fresno California 6019 144123 2051
1816811 1816811 2021-10-15 Glenn California 6021 4303 41
1816812 1816812 2021-10-15 Humboldt California 6023 9102 108
1816813 1816813 2021-10-15 Imperial California 6025 35642 763
1816814 1816814 2021-10-15 Inyo California 6027 1967 39
1816815 1816815 2021-10-15 Kern California 6029 144146 1605
1816816 1816816 2021-10-15 Kings California 6031 32369 314
1816817 1816817 2021-10-15 Lake California 6033 6506 104
1816818 1816818 2021-10-15 Lassen California 6035 7463 48
1816819 1816819 2021-10-15 Los Angeles California 6037 1476398 26398
1816820 1816820 2021-10-15 Madera California 6039 23518 281
1816821 1816821 2021-10-15 Marin California 6041 17581 243
1816822 1816822 2021-10-15 Mariposa California 6043 1273 15
1816823 1816823 2021-10-15 Mendocino California 6045 7527 86
1816824 1816824 2021-10-15 Merced California 6047 42117 583
1816825 1816825 2021-10-15 Modoc California 6049 804 9
1816826 1816826 2021-10-15 Mono California 6051 1644 5
1816827 1816827 2021-10-15 Monterey California 6053 50696 586
1816828 1816828 2021-10-15 Napa California 6055 12809 100
1816829 1816829 2021-10-15 Nevada California 6057 9039 90
1816830 1816830 2021-10-15 Orange California 6059 322741 5518
1816831 1816831 2021-10-15 Placer California 6061 38902 415
1816832 1816832 2021-10-15 Plumas California 6063 1575 6
1816833 1816833 2021-10-15 Riverside California 6065 369344 5092
1816834 1816834 2021-10-15 Sacramento California 6067 157620 2279
1816835 1816835 2021-10-15 San Benito California 6069 7373 71
1816836 1816836 2021-10-15 San Bernardino California 6071 356315 5566
1816837 1816837 2021-10-15 San Diego California 6073 379944 4151
1816838 1816838 2021-10-15 San Francisco California 6075 54034 645
1816839 1816839 2021-10-15 San Joaquin California 6077 101807 1721
1816840 1816840 2021-10-15 San Luis Obispo California 6079 29653 335
1816841 1816841 2021-10-15 San Mateo California 6081 53828 622
1816842 1816842 2021-10-15 Santa Barbara California 6083 44836 521
1816843 1816843 2021-10-15 Santa Clara California 6085 144518 1891
1816844 1816844 2021-10-15 Santa Cruz California 6087 20861 218
1816845 1816845 2021-10-15 Shasta California 6089 23360 334
1816846 1816846 2021-10-15 Sierra California 6091 176 0
1816847 1816847 2021-10-15 Siskiyou California 6093 4581 59
1816848 1816848 2021-10-15 Solano California 6095 45766 334
1816849 1816849 2021-10-15 Sonoma California 6097 40711 402
1816850 1816850 2021-10-15 Stanislaus California 6099 85157 1315
1816851 1816851 2021-10-15 Sutter California 6101 13775 169
1816852 1816852 2021-10-15 Tehama California 6103 9298 104
1816853 1816853 2021-10-15 Trinity California 6105 861 11
1816854 1816854 2021-10-15 Tulare California 6107 78945 951
1816855 1816855 2021-10-15 Tuolumne California 6109 6891 108
1816856 1816856 2021-10-15 Ventura California 6111 100524 1164
1816857 1816857 2021-10-15 Yolo California 6113 20147 247
1816858 1816858 2021-10-15 Yuba California 6115 10318 82
1813553 1813553 2021-10-14 Alameda California 6001 119795 1365
1813554 1813554 2021-10-14 Alpine California 6003 102 0
1813555 1813555 2021-10-14 Amador California 6005 5366 63
1813556 1813556 2021-10-14 Butte California 6007 23298 257
1813557 1813557 2021-10-14 Calaveras California 6009 3802 79
1813558 1813558 2021-10-14 Colusa California 6011 3016 18
1813559 1813559 2021-10-14 Contra Costa California 6013 99102 969
1813560 1813560 2021-10-14 Del Norte California 6015 3652 40
1813561 1813561 2021-10-14 El Dorado California 6017 16947 149
1813562 1813562 2021-10-14 Fresno California 6019 143745 2048
1813563 1813563 2021-10-14 Glenn California 6021 4299 40
1813564 1813564 2021-10-14 Humboldt California 6023 9085 108
1813565 1813565 2021-10-14 Imperial California 6025 35591 761
1813566 1813566 2021-10-14 Inyo California 6027 1942 39
1813567 1813567 2021-10-14 Kern California 6029 143716 1600
1813568 1813568 2021-10-14 Kings California 6031 32197 312
1813569 1813569 2021-10-14 Lake California 6033 6499 103
1813570 1813570 2021-10-14 Lassen California 6035 7437 45
1813571 1813571 2021-10-14 Los Angeles California 6037 1475222 26379
1813572 1813572 2021-10-14 Madera California 6039 23420 281
1813573 1813573 2021-10-14 Marin California 6041 17570 243
1813574 1813574 2021-10-14 Mariposa California 6043 1262 15
1813575 1813575 2021-10-14 Mendocino California 6045 7516 86
1813576 1813576 2021-10-14 Merced California 6047 42035 582
1813577 1813577 2021-10-14 Modoc California 6049 794 8
1813578 1813578 2021-10-14 Mono California 6051 1628 5
1813579 1813579 2021-10-14 Monterey California 6053 50676 586
1813580 1813580 2021-10-14 Napa California 6055 12798 100
1813581 1813581 2021-10-14 Nevada California 6057 9025 90
1813582 1813582 2021-10-14 Orange California 6059 322497 5513
1813583 1813583 2021-10-14 Placer California 6061 38813 412
1813584 1813584 2021-10-14 Plumas California 6063 1547 6
1813585 1813585 2021-10-14 Riverside California 6065 368953 5080
1813586 1813586 2021-10-14 Sacramento California 6067 157497 2273
1813587 1813587 2021-10-14 San Benito California 6069 7359 71
1813588 1813588 2021-10-14 San Bernardino California 6071 355848 5562
1813589 1813589 2021-10-14 San Diego California 6073 379399 4141
1813590 1813590 2021-10-14 San Francisco California 6075 53977 644
1813591 1813591 2021-10-14 San Joaquin California 6077 101643 1702
1813592 1813592 2021-10-14 San Luis Obispo California 6079 29590 331
1813593 1813593 2021-10-14 San Mateo California 6081 53781 618
1813594 1813594 2021-10-14 Santa Barbara California 6083 44770 518

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