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 2022-04-03 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2369522 | 2369522 | 2022-04-03 | Alameda | California | 6001 | 269551 | 1830 |
2369523 | 2369523 | 2022-04-03 | Alpine | California | 6003 | 125 | 0 |
2369524 | 2369524 | 2022-04-03 | Amador | California | 6005 | 9130 | 86 |
2369525 | 2369525 | 2022-04-03 | Butte | California | 6007 | 39643 | 396 |
2369526 | 2369526 | 2022-04-03 | Calaveras | California | 6009 | 7610 | 119 |
2369527 | 2369527 | 2022-04-03 | Colusa | California | 6011 | 4525 | 21 |
2369528 | 2369528 | 2022-04-03 | Contra Costa | California | 6013 | 201921 | 1291 |
2369529 | 2369529 | 2022-04-03 | Del Norte | California | 6015 | 6214 | 50 |
2369530 | 2369530 | 2022-04-03 | El Dorado | California | 6017 | 29944 | 200 |
2369531 | 2369531 | 2022-04-03 | Fresno | California | 6019 | 253293 | 2722 |
2369532 | 2369532 | 2022-04-03 | Glenn | California | 6021 | 6559 | 66 |
2369533 | 2369533 | 2022-04-03 | Humboldt | California | 6023 | 20002 | 140 |
2369534 | 2369534 | 2022-04-03 | Imperial | California | 6025 | 66394 | 907 |
2369535 | 2369535 | 2022-04-03 | Inyo | California | 6027 | 4547 | 56 |
2369536 | 2369536 | 2022-04-03 | Kern | California | 6029 | 242458 | 2294 |
2369537 | 2369537 | 2022-04-03 | Kings | California | 6031 | 55094 | 443 |
2369538 | 2369538 | 2022-04-03 | Lake | California | 6033 | 11572 | 136 |
2369539 | 2369539 | 2022-04-03 | Lassen | California | 6035 | 10713 | 69 |
2369540 | 2369540 | 2022-04-03 | Los Angeles | California | 6037 | 2835021 | 31683 |
2369541 | 2369541 | 2022-04-03 | Madera | California | 6039 | 43400 | 354 |
2369542 | 2369542 | 2022-04-03 | Marin | California | 6041 | 35743 | 287 |
2369543 | 2369543 | 2022-04-03 | Mariposa | California | 6043 | 3013 | 33 |
2369544 | 2369544 | 2022-04-03 | Mendocino | California | 6045 | 16052 | 119 |
2369545 | 2369545 | 2022-04-03 | Merced | California | 6047 | 71977 | 813 |
2369546 | 2369546 | 2022-04-03 | Modoc | California | 6049 | 993 | 8 |
2369547 | 2369547 | 2022-04-03 | Mono | California | 6051 | 3089 | 6 |
2369548 | 2369548 | 2022-04-03 | Monterey | California | 6053 | 92730 | 732 |
2369549 | 2369549 | 2022-04-03 | Napa | California | 6055 | 26726 | 143 |
2369550 | 2369550 | 2022-04-03 | Nevada | California | 6057 | 17176 | 123 |
2369551 | 2369551 | 2022-04-03 | Orange | California | 6059 | 587408 | 6886 |
2369552 | 2369552 | 2022-04-03 | Placer | California | 6061 | 70097 | 614 |
2369553 | 2369553 | 2022-04-03 | Plumas | California | 6063 | 3163 | 14 |
2369554 | 2369554 | 2022-04-03 | Riverside | California | 6065 | 618706 | 6474 |
2369555 | 2369555 | 2022-04-03 | Sacramento | California | 6067 | 303101 | 3080 |
2369556 | 2369556 | 2022-04-03 | San Benito | California | 6069 | 13421 | 98 |
2369557 | 2369557 | 2022-04-03 | San Bernardino | California | 6071 | 586037 | 6865 |
2369558 | 2369558 | 2022-04-03 | San Diego | California | 6073 | 803862 | 5178 |
2369559 | 2369559 | 2022-04-03 | San Francisco | California | 6075 | 133484 | 843 |
2369560 | 2369560 | 2022-04-03 | San Joaquin | California | 6077 | 175524 | 2202 |
2369561 | 2369561 | 2022-04-03 | San Luis Obispo | California | 6079 | 56292 | 475 |
2369562 | 2369562 | 2022-04-03 | San Mateo | California | 6081 | 127776 | 745 |
2369563 | 2369563 | 2022-04-03 | Santa Barbara | California | 6083 | 90453 | 678 |
2369564 | 2369564 | 2022-04-03 | Santa Clara | California | 6085 | 324974 | 2259 |
2369565 | 2369565 | 2022-04-03 | Santa Cruz | California | 6087 | 49458 | 259 |
2369566 | 2369566 | 2022-04-03 | Shasta | California | 6089 | 36737 | 610 |
2369567 | 2369567 | 2022-04-03 | Sierra | California | 6091 | 315 | 4 |
2369568 | 2369568 | 2022-04-03 | Siskiyou | California | 6093 | 7413 | 105 |
2369569 | 2369569 | 2022-04-03 | Solano | California | 6095 | 87401 | 446 |
2369570 | 2369570 | 2022-04-03 | Sonoma | California | 6097 | 85756 | 487 |
2369571 | 2369571 | 2022-04-03 | Stanislaus | California | 6099 | 136645 | 1694 |
2369572 | 2369572 | 2022-04-03 | Sutter | California | 6101 | 22672 | 231 |
2369573 | 2369573 | 2022-04-03 | Tehama | California | 6103 | 14652 | 198 |
2369574 | 2369574 | 2022-04-03 | Trinity | California | 6105 | 1466 | 20 |
2369575 | 2369575 | 2022-04-03 | Tulare | California | 6107 | 133169 | 1410 |
2369576 | 2369576 | 2022-04-03 | Tuolumne | California | 6109 | 13463 | 181 |
2369577 | 2369577 | 2022-04-03 | Ventura | California | 6111 | 182326 | 1462 |
2369578 | 2369578 | 2022-04-03 | Yolo | California | 6113 | 39542 | 313 |
2369579 | 2369579 | 2022-04-03 | Yuba | California | 6115 | 17674 | 120 |
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);