ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where "date" is on date 2021-07-01 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1472490 | 1472490 | 2021-07-01 | Alameda | California | 6001 | 90300 | 1271 |
1472491 | 1472491 | 2021-07-01 | Alpine | California | 6003 | 89 | 0 |
1472492 | 1472492 | 2021-07-01 | Amador | California | 6005 | 3755 | 47 |
1472493 | 1472493 | 2021-07-01 | Butte | California | 6007 | 12676 | 201 |
1472494 | 1472494 | 2021-07-01 | Calaveras | California | 6009 | 2210 | 56 |
1472495 | 1472495 | 2021-07-01 | Colusa | California | 6011 | 2288 | 18 |
1472496 | 1472496 | 2021-07-01 | Contra Costa | California | 6013 | 71319 | 818 |
1472497 | 1472497 | 2021-07-01 | Del Norte | California | 6015 | 1485 | 8 |
1472498 | 1472498 | 2021-07-01 | El Dorado | California | 6017 | 10428 | 117 |
1472499 | 1472499 | 2021-07-01 | Fresno | California | 6019 | 102490 | 1727 |
1472500 | 1472500 | 2021-07-01 | Glenn | California | 6021 | 2967 | 27 |
1472501 | 1472501 | 2021-07-01 | Humboldt | California | 6023 | 4582 | 50 |
1472502 | 1472502 | 2021-07-01 | Imperial | California | 6025 | 28981 | 741 |
1472503 | 1472503 | 2021-07-01 | Inyo | California | 6027 | 1434 | 38 |
1472504 | 1472504 | 2021-07-01 | Kern | California | 6029 | 111060 | 1407 |
1472505 | 1472505 | 2021-07-01 | Kings | California | 6031 | 23107 | 247 |
1472506 | 1472506 | 2021-07-01 | Lake | California | 6033 | 3601 | 56 |
1472507 | 1472507 | 2021-07-01 | Lassen | California | 6035 | 5821 | 26 |
1472508 | 1472508 | 2021-07-01 | Los Angeles | California | 6037 | 1251383 | 24499 |
1472509 | 1472509 | 2021-07-01 | Madera | California | 6039 | 16688 | 245 |
1472510 | 1472510 | 2021-07-01 | Marin | California | 6041 | 14133 | 232 |
1472511 | 1472511 | 2021-07-01 | Mariposa | California | 6043 | 467 | 7 |
1472512 | 1472512 | 2021-07-01 | Mendocino | California | 6045 | 4387 | 50 |
1472513 | 1472513 | 2021-07-01 | Merced | California | 6047 | 32380 | 482 |
1472514 | 1472514 | 2021-07-01 | Modoc | California | 6049 | 566 | 5 |
1472515 | 1472515 | 2021-07-01 | Mono | California | 6051 | 1298 | 4 |
1472516 | 1472516 | 2021-07-01 | Monterey | California | 6053 | 43896 | 496 |
1472517 | 1472517 | 2021-07-01 | Napa | California | 6055 | 10040 | 81 |
1472518 | 1472518 | 2021-07-01 | Nevada | California | 6057 | 4958 | 75 |
1472519 | 1472519 | 2021-07-01 | Orange | California | 6059 | 273636 | 5125 |
1472520 | 1472520 | 2021-07-01 | Placer | California | 6061 | 23793 | 300 |
1472521 | 1472521 | 2021-07-01 | Plumas | California | 6063 | 742 | 6 |
1472522 | 1472522 | 2021-07-01 | Riverside | California | 6065 | 301774 | 4637 |
1472523 | 1472523 | 2021-07-01 | Sacramento | California | 6067 | 108687 | 1743 |
1472524 | 1472524 | 2021-07-01 | San Benito | California | 6069 | 6105 | 63 |
1472525 | 1472525 | 2021-07-01 | San Bernardino | California | 6071 | 299883 | 4975 |
1472526 | 1472526 | 2021-07-01 | San Diego | California | 6073 | 298015 | 3780 |
1472527 | 1472527 | 2021-07-01 | San Francisco | California | 6075 | 37068 | 558 |
1472528 | 1472528 | 2021-07-01 | San Joaquin | California | 6077 | 74900 | 1444 |
1472529 | 1472529 | 2021-07-01 | San Luis Obispo | California | 6079 | 21482 | 261 |
1472530 | 1472530 | 2021-07-01 | San Mateo | California | 6081 | 42599 | 581 |
1472531 | 1472531 | 2021-07-01 | Santa Barbara | California | 6083 | 34652 | 457 |
1472532 | 1472532 | 2021-07-01 | Santa Clara | California | 6085 | 119388 | 2202 |
1472533 | 1472533 | 2021-07-01 | Santa Cruz | California | 6087 | 16289 | 208 |
1472534 | 1472534 | 2021-07-01 | Shasta | California | 6089 | 12579 | 236 |
1472535 | 1472535 | 2021-07-01 | Sierra | California | 6091 | 60 | 0 |
1472536 | 1472536 | 2021-07-01 | Siskiyou | California | 6093 | 2405 | 39 |
1472537 | 1472537 | 2021-07-01 | Solano | California | 6095 | 33978 | 268 |
1472538 | 1472538 | 2021-07-01 | Sonoma | California | 6097 | 31026 | 318 |
1472539 | 1472539 | 2021-07-01 | Stanislaus | California | 6099 | 63745 | 1077 |
1472540 | 1472540 | 2021-07-01 | Sutter | California | 6101 | 9712 | 114 |
1472541 | 1472541 | 2021-07-01 | Tehama | California | 6103 | 5124 | 63 |
1472542 | 1472542 | 2021-07-01 | Trinity | California | 6105 | 342 | 3 |
1472543 | 1472543 | 2021-07-01 | Tulare | California | 6107 | 49896 | 853 |
1472544 | 1472544 | 2021-07-01 | Tuolumne | California | 6109 | 4243 | 71 |
1472545 | 1472545 | 2021-07-01 | Unknown | California | 33081 | 0 | |
1472546 | 1472546 | 2021-07-01 | Ventura | California | 6111 | 81884 | 1032 |
1472547 | 1472547 | 2021-07-01 | Yolo | California | 6113 | 14184 | 213 |
1472548 | 1472548 | 2021-07-01 | Yuba | California | 6115 | 6545 | 51 |
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);