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

58 rows where date = "2021-03-26" and 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 · 58 ✖
Link rowid date ▲ county state fips cases deaths
1157571 1157571 2021-03-26 Alameda California 6001 82966 1395
1157572 1157572 2021-03-26 Alpine California 6003 84 0
1157573 1157573 2021-03-26 Amador California 6005 3529 45
1157574 1157574 2021-03-26 Butte California 6007 11270 188
1157575 1157575 2021-03-26 Calaveras California 6009 1982 51
1157576 1157576 2021-03-26 Colusa California 6011 2164 16
1157577 1157577 2021-03-26 Contra Costa California 6013 64961 757
1157578 1157578 2021-03-26 Del Norte California 6015 1125 6
1157579 1157579 2021-03-26 El Dorado California 6017 9331 107
1157580 1157580 2021-03-26 Fresno California 6019 98602 1593
1157581 1157581 2021-03-26 Glenn California 6021 2803 25
1157582 1157582 2021-03-26 Humboldt California 6023 3448 35
1157583 1157583 2021-03-26 Imperial California 6025 27352 711
1157584 1157584 2021-03-26 Inyo California 6027 1369 35
1157585 1157585 2021-03-26 Kern California 6029 105912 1206
1157586 1157586 2021-03-26 Kings California 6031 22578 241
1157587 1157587 2021-03-26 Lake California 6033 3312 43
1157588 1157588 2021-03-26 Lassen California 6035 5649 24
1157589 1157589 2021-03-26 Los Angeles California 6037 1217686 23055
1157590 1157590 2021-03-26 Madera California 6039 15937 231
1157591 1157591 2021-03-26 Marin California 6041 13538 219
1157592 1157592 2021-03-26 Mariposa California 6043 408 7
1157593 1157593 2021-03-26 Mendocino California 6045 3935 46
1157594 1157594 2021-03-26 Merced California 6047 30419 434
1157595 1157595 2021-03-26 Modoc California 6049 472 4
1157596 1157596 2021-03-26 Mono California 6051 1235 4
1157597 1157597 2021-03-26 Monterey California 6053 42868 340
1157598 1157598 2021-03-26 Napa California 6055 9337 78
1157599 1157599 2021-03-26 Nevada California 6057 4219 84
1157600 1157600 2021-03-26 Orange California 6059 265536 4684
1157601 1157601 2021-03-26 Placer California 6061 20736 263
1157602 1157602 2021-03-26 Plumas California 6063 654 4
1157603 1157603 2021-03-26 Riverside California 6065 293831 4248
1157604 1157604 2021-03-26 Sacramento California 6067 96989 1599
1157605 1157605 2021-03-26 San Benito California 6069 5850 61
1157606 1157606 2021-03-26 San Bernardino California 6071 290315 4222
1157607 1157607 2021-03-26 San Diego California 6073 269112 3525
1157608 1157608 2021-03-26 San Francisco California 6075 35157 468
1157609 1157609 2021-03-26 San Joaquin California 6077 69448 1250
1157610 1157610 2021-03-26 San Luis Obispo California 6079 20402 255
1157611 1157611 2021-03-26 San Mateo California 6081 40147 547
1157612 1157612 2021-03-26 Santa Barbara California 6083 33020 439
1157613 1157613 2021-03-26 Santa Clara California 6085 114015 1935
1157614 1157614 2021-03-26 Santa Cruz California 6087 15306 201
1157615 1157615 2021-03-26 Shasta California 6089 11319 200
1157616 1157616 2021-03-26 Sierra California 6091 50 0
1157617 1157617 2021-03-26 Siskiyou California 6093 1870 15
1157618 1157618 2021-03-26 Solano California 6095 31014 193
1157619 1157619 2021-03-26 Sonoma California 6097 29122 310
1157620 1157620 2021-03-26 Stanislaus California 6099 58602 992
1157621 1157621 2021-03-26 Sutter California 6101 9110 104
1157622 1157622 2021-03-26 Tehama California 6103 4719 52
1157623 1157623 2021-03-26 Trinity California 6105 311 3
1157624 1157624 2021-03-26 Tulare California 6107 48960 811
1157625 1157625 2021-03-26 Tuolumne California 6109 4024 62
1157626 1157626 2021-03-26 Ventura California 6111 79472 969
1157627 1157627 2021-03-26 Yolo California 6113 13287 196
1157628 1157628 2021-03-26 Yuba California 6115 5953 42

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