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-06-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
1430299 1430299 2021-06-18 Alameda California 6001 89613 1273
1430300 1430300 2021-06-18 Alpine California 6003 89 0
1430301 1430301 2021-06-18 Amador California 6005 3730 47
1430302 1430302 2021-06-18 Butte California 6007 12644 194
1430303 1430303 2021-06-18 Calaveras California 6009 2201 56
1430304 1430304 2021-06-18 Colusa California 6011 2284 18
1430305 1430305 2021-06-18 Contra Costa California 6013 70561 811
1430306 1430306 2021-06-18 Del Norte California 6015 1456 8
1430307 1430307 2021-06-18 El Dorado California 6017 10353 116
1430308 1430308 2021-06-18 Fresno California 6019 102867 1722
1430309 1430309 2021-06-18 Glenn California 6021 2954 27
1430310 1430310 2021-06-18 Humboldt California 6023 4462 48
1430311 1430311 2021-06-18 Imperial California 6025 28801 740
1430312 1430312 2021-06-18 Inyo California 6027 1434 38
1430313 1430313 2021-06-18 Kern California 6029 110734 1402
1430314 1430314 2021-06-18 Kings California 6031 23189 247
1430315 1430315 2021-06-18 Lake California 6033 3563 45
1430316 1430316 2021-06-18 Lassen California 6035 5784 24
1430317 1430317 2021-06-18 Los Angeles California 6037 1247883 24444
1430318 1430318 2021-06-18 Madera California 6039 16618 245
1430319 1430319 2021-06-18 Marin California 6041 14141 229
1430320 1430320 2021-06-18 Mariposa California 6043 465 7
1430321 1430321 2021-06-18 Mendocino California 6045 4321 50
1430322 1430322 2021-06-18 Merced California 6047 32291 478
1430323 1430323 2021-06-18 Modoc California 6049 558 5
1430324 1430324 2021-06-18 Mono California 6051 1295 4
1430325 1430325 2021-06-18 Monterey California 6053 43819 432
1430326 1430326 2021-06-18 Napa California 6055 10015 80
1430327 1430327 2021-06-18 Nevada California 6057 4898 75
1430328 1430328 2021-06-18 Orange California 6059 272922 5109
1430329 1430329 2021-06-18 Placer California 6061 23518 299
1430330 1430330 2021-06-18 Plumas California 6063 736 6
1430331 1430331 2021-06-18 Riverside California 6065 301603 4627
1430332 1430332 2021-06-18 Sacramento California 6067 107637 1731
1430333 1430333 2021-06-18 San Benito California 6069 6097 63
1430334 1430334 2021-06-18 San Bernardino California 6071 299186 4811
1430335 1430335 2021-06-18 San Diego California 6073 281594 3771
1430336 1430336 2021-06-18 San Francisco California 6075 37246 556
1430337 1430337 2021-06-18 San Joaquin California 6077 74686 1438
1430338 1430338 2021-06-18 San Luis Obispo California 6079 21421 261
1430339 1430339 2021-06-18 San Mateo California 6081 42615 581
1430340 1430340 2021-06-18 Santa Barbara California 6083 34596 455
1430341 1430341 2021-06-18 Santa Clara California 6085 120032 2189
1430342 1430342 2021-06-18 Santa Cruz California 6087 16235 208
1430343 1430343 2021-06-18 Shasta California 6089 12630 233
1430344 1430344 2021-06-18 Sierra California 6091 56 0
1430345 1430345 2021-06-18 Siskiyou California 6093 2394 37
1430346 1430346 2021-06-18 Solano California 6095 33712 266
1430347 1430347 2021-06-18 Sonoma California 6097 30825 323
1430348 1430348 2021-06-18 Stanislaus California 6099 63387 1069
1430349 1430349 2021-06-18 Sutter California 6101 9656 113
1430350 1430350 2021-06-18 Tehama California 6103 5112 63
1430351 1430351 2021-06-18 Trinity California 6105 338 3
1430352 1430352 2021-06-18 Tulare California 6107 49814 849
1430353 1430353 2021-06-18 Tuolumne California 6109 4207 71
1430354 1430354 2021-06-18 Ventura California 6111 81638 1030
1430355 1430355 2021-06-18 Yolo California 6113 14141 212
1430356 1430356 2021-06-18 Yuba California 6115 6485 51

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