ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2021-04-15 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1222528 | 1222528 | 2021-04-15 | Alameda | California | 6001 | 85030 | 1475 |
1222529 | 1222529 | 2021-04-15 | Alpine | California | 6003 | 88 | 0 |
1222530 | 1222530 | 2021-04-15 | Amador | California | 6005 | 3612 | 46 |
1222531 | 1222531 | 2021-04-15 | Butte | California | 6007 | 11513 | 196 |
1222532 | 1222532 | 2021-04-15 | Calaveras | California | 6009 | 2037 | 51 |
1222533 | 1222533 | 2021-04-15 | Colusa | California | 6011 | 2192 | 16 |
1222534 | 1222534 | 2021-04-15 | Contra Costa | California | 6013 | 66750 | 781 |
1222535 | 1222535 | 2021-04-15 | Del Norte | California | 6015 | 1272 | 7 |
1222536 | 1222536 | 2021-04-15 | El Dorado | California | 6017 | 9625 | 108 |
1222537 | 1222537 | 2021-04-15 | Fresno | California | 6019 | 100376 | 1640 |
1222538 | 1222538 | 2021-04-15 | Glenn | California | 6021 | 2864 | 25 |
1222539 | 1222539 | 2021-04-15 | Humboldt | California | 6023 | 3579 | 37 |
1222540 | 1222540 | 2021-04-15 | Imperial | California | 6025 | 27907 | 717 |
1222541 | 1222541 | 2021-04-15 | Inyo | California | 6027 | 1392 | 36 |
1222542 | 1222542 | 2021-04-15 | Kern | California | 6029 | 107648 | 1311 |
1222543 | 1222543 | 2021-04-15 | Kings | California | 6031 | 22737 | 245 |
1222544 | 1222544 | 2021-04-15 | Lake | California | 6033 | 3396 | 43 |
1222545 | 1222545 | 2021-04-15 | Lassen | California | 6035 | 5666 | 24 |
1222546 | 1222546 | 2021-04-15 | Los Angeles | California | 6037 | 1228176 | 23579 |
1222547 | 1222547 | 2021-04-15 | Madera | California | 6039 | 16218 | 239 |
1222548 | 1222548 | 2021-04-15 | Marin | California | 6041 | 13768 | 226 |
1222549 | 1222549 | 2021-04-15 | Mariposa | California | 6043 | 419 | 7 |
1222550 | 1222550 | 2021-04-15 | Mendocino | California | 6045 | 3981 | 47 |
1222551 | 1222551 | 2021-04-15 | Merced | California | 6047 | 31151 | 452 |
1222552 | 1222552 | 2021-04-15 | Modoc | California | 6049 | 488 | 4 |
1222553 | 1222553 | 2021-04-15 | Mono | California | 6051 | 1252 | 4 |
1222554 | 1222554 | 2021-04-15 | Monterey | California | 6053 | 43245 | 348 |
1222555 | 1222555 | 2021-04-15 | Napa | California | 6055 | 9646 | 79 |
1222556 | 1222556 | 2021-04-15 | Nevada | California | 6057 | 4437 | 75 |
1222557 | 1222557 | 2021-04-15 | Orange | California | 6059 | 268622 | 4869 |
1222558 | 1222558 | 2021-04-15 | Placer | California | 6061 | 21686 | 282 |
1222559 | 1222559 | 2021-04-15 | Plumas | California | 6063 | 665 | 4 |
1222560 | 1222560 | 2021-04-15 | Riverside | California | 6065 | 297078 | 4519 |
1222561 | 1222561 | 2021-04-15 | Sacramento | California | 6067 | 100856 | 1645 |
1222562 | 1222562 | 2021-04-15 | San Benito | California | 6069 | 5960 | 63 |
1222563 | 1222563 | 2021-04-15 | San Bernardino | California | 6071 | 294262 | 4523 |
1222564 | 1222564 | 2021-04-15 | San Diego | California | 6073 | 274032 | 3653 |
1222565 | 1222565 | 2021-04-15 | San Francisco | California | 6075 | 35901 | 513 |
1222566 | 1222566 | 2021-04-15 | San Joaquin | California | 6077 | 71338 | 1334 |
1222567 | 1222567 | 2021-04-15 | San Luis Obispo | California | 6079 | 20878 | 256 |
1222568 | 1222568 | 2021-04-15 | San Mateo | California | 6081 | 41015 | 556 |
1222569 | 1222569 | 2021-04-15 | Santa Barbara | California | 6083 | 33796 | 445 |
1222570 | 1222570 | 2021-04-15 | Santa Clara | California | 6085 | 116678 | 2009 |
1222571 | 1222571 | 2021-04-15 | Santa Cruz | California | 6087 | 15495 | 203 |
1222572 | 1222572 | 2021-04-15 | Shasta | California | 6089 | 11651 | 216 |
1222573 | 1222573 | 2021-04-15 | Sierra | California | 6091 | 51 | 0 |
1222574 | 1222574 | 2021-04-15 | Siskiyou | California | 6093 | 1932 | 21 |
1222575 | 1222575 | 2021-04-15 | Solano | California | 6095 | 31809 | 239 |
1222576 | 1222576 | 2021-04-15 | Sonoma | California | 6097 | 29632 | 311 |
1222577 | 1222577 | 2021-04-15 | Stanislaus | California | 6099 | 60245 | 1026 |
1222578 | 1222578 | 2021-04-15 | Sutter | California | 6101 | 9262 | 106 |
1222579 | 1222579 | 2021-04-15 | Tehama | California | 6103 | 4853 | 52 |
1222580 | 1222580 | 2021-04-15 | Trinity | California | 6105 | 327 | 3 |
1222581 | 1222581 | 2021-04-15 | Tulare | California | 6107 | 49355 | 827 |
1222582 | 1222582 | 2021-04-15 | Tuolumne | California | 6109 | 4064 | 64 |
1222583 | 1222583 | 2021-04-15 | Ventura | California | 6111 | 80186 | 997 |
1222584 | 1222584 | 2021-04-15 | Yolo | California | 6113 | 13530 | 199 |
1222585 | 1222585 | 2021-04-15 | Yuba | California | 6115 | 6093 | 44 |
Advanced export
JSON shape: default, array, newline-delimited
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);