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

45,693 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 >30

state 1

  • California · 45,693 ✖
Link rowid date ▲ county state fips cases deaths
2499762 2499762 2022-05-13 Alameda California 6001 284054 1868
2499763 2499763 2022-05-13 Alpine California 6003 126 0
2499764 2499764 2022-05-13 Amador California 6005 9242 86
2499765 2499765 2022-05-13 Butte California 6007 40181 424
2499766 2499766 2022-05-13 Calaveras California 6009 7754 120
2499767 2499767 2022-05-13 Colusa California 6011 4549 21
2499768 2499768 2022-05-13 Contra Costa California 6013 209958 1301
2499769 2499769 2022-05-13 Del Norte California 6015 6381 50
2499770 2499770 2022-05-13 El Dorado California 6017 30508 212
2499771 2499771 2022-05-13 Fresno California 6019 257611 2757
2499772 2499772 2022-05-13 Glenn California 6021 6631 67
2499773 2499773 2022-05-13 Humboldt California 6023 20952 146
2499774 2499774 2022-05-13 Imperial California 6025 66715 916
2499775 2499775 2022-05-13 Inyo California 6027 4636 56
2499776 2499776 2022-05-13 Kern California 6029 244681 2427
2499777 2499777 2022-05-13 Kings California 6031 55429 447
2499778 2499778 2022-05-13 Lake California 6033 11699 137
2499779 2499779 2022-05-13 Lassen California 6035 10751 69
2499780 2499780 2022-05-13 Los Angeles California 6037 2908425 32022
2499781 2499781 2022-05-13 Madera California 6039 43685 365
2499782 2499782 2022-05-13 Marin California 6041 38685 293
2499783 2499783 2022-05-13 Mariposa California 6043 3145 35
2499784 2499784 2022-05-13 Mendocino California 6045 16568 124
2499785 2499785 2022-05-13 Merced California 6047 72959 823
2499786 2499786 2022-05-13 Modoc California 6049 1000 8
2499787 2499787 2022-05-13 Mono California 6051 3144 6
2499788 2499788 2022-05-13 Monterey California 6053 95140 744
2499789 2499789 2022-05-13 Napa California 6055 27765 143
2499790 2499790 2022-05-13 Nevada California 6057 17503 127
2499791 2499791 2022-05-13 Orange California 6059 600384 7023
2499792 2499792 2022-05-13 Placer California 6061 71527 628
2499793 2499793 2022-05-13 Plumas California 6063 3379 13
2499794 2499794 2022-05-13 Riverside California 6065 626695 6527
2499795 2499795 2022-05-13 Sacramento California 6067 314407 3159
2499796 2499796 2022-05-13 San Benito California 6069 13636 98
2499797 2499797 2022-05-13 San Bernardino California 6071 597377 7423
2499798 2499798 2022-05-13 San Diego California 6073 824586 5271
2499799 2499799 2022-05-13 San Francisco California 6075 143959 866
2499800 2499800 2022-05-13 San Joaquin California 6077 178501 2236
2499801 2499801 2022-05-13 San Luis Obispo California 6079 57556 478
2499802 2499802 2022-05-13 San Mateo California 6081 137238 755
2499803 2499803 2022-05-13 Santa Barbara California 6083 92683 693
2499804 2499804 2022-05-13 Santa Clara California 6085 342015 2298
2499805 2499805 2022-05-13 Santa Cruz California 6087 52532 263
2499806 2499806 2022-05-13 Shasta California 6089 36988 648
2499807 2499807 2022-05-13 Sierra California 6091 324 4
2499808 2499808 2022-05-13 Siskiyou California 6093 7478 105
2499809 2499809 2022-05-13 Solano California 6095 89419 451
2499810 2499810 2022-05-13 Sonoma California 6097 90191 490
2499811 2499811 2022-05-13 Stanislaus California 6099 136645 1694
2499812 2499812 2022-05-13 Sutter California 6101 23045 234
2499813 2499813 2022-05-13 Tehama California 6103 14753 201
2499814 2499814 2022-05-13 Trinity California 6105 1485 20
2499815 2499815 2022-05-13 Tulare California 6107 136125 1469
2499816 2499816 2022-05-13 Tuolumne California 6109 13758 182
2499817 2499817 2022-05-13 Ventura California 6111 186062 1498
2499818 2499818 2022-05-13 Yolo California 6113 41061 316
2499819 2499819 2022-05-13 Yuba California 6115 17944 122
2496504 2496504 2022-05-12 Alameda California 6001 282539 1868
2496505 2496505 2022-05-12 Alpine California 6003 126 0
2496506 2496506 2022-05-12 Amador California 6005 9230 86
2496507 2496507 2022-05-12 Butte California 6007 40080 423
2496508 2496508 2022-05-12 Calaveras California 6009 7733 120
2496509 2496509 2022-05-12 Colusa California 6011 4542 21
2496510 2496510 2022-05-12 Contra Costa California 6013 208949 1302
2496511 2496511 2022-05-12 Del Norte California 6015 6381 50
2496512 2496512 2022-05-12 El Dorado California 6017 30428 212
2496513 2496513 2022-05-12 Fresno California 6019 257043 2754
2496514 2496514 2022-05-12 Glenn California 6021 6628 67
2496515 2496515 2022-05-12 Humboldt California 6023 20952 146
2496516 2496516 2022-05-12 Imperial California 6025 66692 916
2496517 2496517 2022-05-12 Inyo California 6027 4607 56
2496518 2496518 2022-05-12 Kern California 6029 244205 2396
2496519 2496519 2022-05-12 Kings California 6031 55391 447
2496520 2496520 2022-05-12 Lake California 6033 11693 137
2496521 2496521 2022-05-12 Lassen California 6035 10750 69
2496522 2496522 2022-05-12 Los Angeles California 6037 2904483 32016
2496523 2496523 2022-05-12 Madera California 6039 43585 365
2496524 2496524 2022-05-12 Marin California 6041 38274 292
2496525 2496525 2022-05-12 Mariposa California 6043 3142 35
2496526 2496526 2022-05-12 Mendocino California 6045 16466 124
2496527 2496527 2022-05-12 Merced California 6047 72907 823
2496528 2496528 2022-05-12 Modoc California 6049 1000 8
2496529 2496529 2022-05-12 Mono California 6051 3127 6
2496530 2496530 2022-05-12 Monterey California 6053 94867 744
2496531 2496531 2022-05-12 Napa California 6055 27708 143
2496532 2496532 2022-05-12 Nevada California 6057 17475 127
2496533 2496533 2022-05-12 Orange California 6059 598954 7019
2496534 2496534 2022-05-12 Placer California 6061 71325 628
2496535 2496535 2022-05-12 Plumas California 6063 3362 13
2496536 2496536 2022-05-12 Riverside California 6065 625875 6525
2496537 2496537 2022-05-12 Sacramento California 6067 313544 3159
2496538 2496538 2022-05-12 San Benito California 6069 13615 98
2496539 2496539 2022-05-12 San Bernardino California 6071 596557 7354
2496540 2496540 2022-05-12 San Diego California 6073 821757 5257
2496541 2496541 2022-05-12 San Francisco California 6075 142863 864
2496542 2496542 2022-05-12 San Joaquin California 6077 177919 2233
2496543 2496543 2022-05-12 San Luis Obispo California 6079 57393 478
2496544 2496544 2022-05-12 San Mateo California 6081 136379 755
2496545 2496545 2022-05-12 Santa Barbara California 6083 92466 693

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