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-05-18" 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
1329674 1329674 2021-05-18 Alameda California 6001 88228 1671
1329675 1329675 2021-05-18 Alpine California 6003 88 0
1329676 1329676 2021-05-18 Amador California 6005 3667 47
1329677 1329677 2021-05-18 Butte California 6007 12144 192
1329678 1329678 2021-05-18 Calaveras California 6009 2136 54
1329679 1329679 2021-05-18 Colusa California 6011 2236 16
1329680 1329680 2021-05-18 Contra Costa California 6013 69035 805
1329681 1329681 2021-05-18 Del Norte California 6015 1409 8
1329682 1329682 2021-05-18 El Dorado California 6017 10193 113
1329683 1329683 2021-05-18 Fresno California 6019 102013 1690
1329684 1329684 2021-05-18 Glenn California 6021 2924 25
1329685 1329685 2021-05-18 Humboldt California 6023 4152 42
1329686 1329686 2021-05-18 Imperial California 6025 28533 729
1329687 1329687 2021-05-18 Inyo California 6027 1428 38
1329688 1329688 2021-05-18 Kern California 6029 109351 1376
1329689 1329689 2021-05-18 Kings California 6031 23016 247
1329690 1329690 2021-05-18 Lake California 6033 3489 43
1329691 1329691 2021-05-18 Lassen California 6035 5716 24
1329692 1329692 2021-05-18 Los Angeles California 6037 1238345 24123
1329693 1329693 2021-05-18 Madera California 6039 16486 242
1329694 1329694 2021-05-18 Marin California 6041 14021 227
1329695 1329695 2021-05-18 Mariposa California 6043 450 7
1329696 1329696 2021-05-18 Mendocino California 6045 4137 49
1329697 1329697 2021-05-18 Merced California 6047 31950 463
1329698 1329698 2021-05-18 Modoc California 6049 501 4
1329699 1329699 2021-05-18 Mono California 6051 1284 4
1329700 1329700 2021-05-18 Monterey California 6053 43664 385
1329701 1329701 2021-05-18 Napa California 6055 9895 82
1329702 1329702 2021-05-18 Nevada California 6057 4761 75
1329703 1329703 2021-05-18 Orange California 6059 271352 5031
1329704 1329704 2021-05-18 Placer California 6061 22745 294
1329705 1329705 2021-05-18 Plumas California 6063 718 6
1329706 1329706 2021-05-18 Riverside California 6065 300039 4598
1329707 1329707 2021-05-18 Sacramento California 6067 105233 1693
1329708 1329708 2021-05-18 San Benito California 6069 6067 63
1329709 1329709 2021-05-18 San Bernardino California 6071 297300 4724
1329710 1329710 2021-05-18 San Diego California 6073 279209 3742
1329711 1329711 2021-05-18 San Francisco California 6075 36819 546
1329712 1329712 2021-05-18 San Joaquin California 6077 73401 1399
1329713 1329713 2021-05-18 San Luis Obispo California 6079 21232 261
1329714 1329714 2021-05-18 San Mateo California 6081 42083 570
1329715 1329715 2021-05-18 Santa Barbara California 6083 34404 459
1329716 1329716 2021-05-18 Santa Clara California 6085 119116 2098
1329717 1329717 2021-05-18 Santa Cruz California 6087 16275 206
1329718 1329718 2021-05-18 Shasta California 6089 12208 226
1329719 1329719 2021-05-18 Sierra California 6091 54 0
1329720 1329720 2021-05-18 Siskiyou California 6093 2282 26
1329721 1329721 2021-05-18 Solano California 6095 33031 253
1329722 1329722 2021-05-18 Sonoma California 6097 30071 321
1329723 1329723 2021-05-18 Stanislaus California 6099 62336 1062
1329724 1329724 2021-05-18 Sutter California 6101 9447 113
1329725 1329725 2021-05-18 Tehama California 6103 5016 63
1329726 1329726 2021-05-18 Trinity California 6105 329 3
1329727 1329727 2021-05-18 Tulare California 6107 49908 841
1329728 1329728 2021-05-18 Tuolumne California 6109 4151 67
1329729 1329729 2021-05-18 Ventura California 6111 81117 1017
1329730 1329730 2021-05-18 Yolo California 6113 13941 211
1329731 1329731 2021-05-18 Yuba California 6115 6285 49

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