ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-12-25" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2047549 | 2047549 | 2021-12-25 | Alameda | California | 6001 | 130526 | 1540 |
2047550 | 2047550 | 2021-12-25 | Alpine | California | 6003 | 113 | 0 |
2047551 | 2047551 | 2021-12-25 | Amador | California | 6005 | 5937 | 70 |
2047552 | 2047552 | 2021-12-25 | Butte | California | 6007 | 26123 | 330 |
2047553 | 2047553 | 2021-12-25 | Calaveras | California | 6009 | 4663 | 91 |
2047554 | 2047554 | 2021-12-25 | Colusa | California | 6011 | 3354 | 21 |
2047555 | 2047555 | 2021-12-25 | Contra Costa | California | 6013 | 107555 | 1071 |
2047556 | 2047556 | 2021-12-25 | Del Norte | California | 6015 | 3936 | 43 |
2047557 | 2047557 | 2021-12-25 | El Dorado | California | 6017 | 19064 | 172 |
2047558 | 2047558 | 2021-12-25 | Fresno | California | 6019 | 161033 | 2358 |
2047559 | 2047559 | 2021-12-25 | Glenn | California | 6021 | 4656 | 53 |
2047560 | 2047560 | 2021-12-25 | Humboldt | California | 6023 | 10832 | 122 |
2047561 | 2047561 | 2021-12-25 | Imperial | California | 6025 | 41099 | 799 |
2047562 | 2047562 | 2021-12-25 | Inyo | California | 6027 | 2674 | 47 |
2047563 | 2047563 | 2021-12-25 | Kern | California | 6029 | 161987 | 1908 |
2047564 | 2047564 | 2021-12-25 | Kings | California | 6031 | 36244 | 382 |
2047565 | 2047565 | 2021-12-25 | Lake | California | 6033 | 7191 | 116 |
2047566 | 2047566 | 2021-12-25 | Lassen | California | 6035 | 8061 | 61 |
2047567 | 2047567 | 2021-12-25 | Los Angeles | California | 6037 | 1595943 | 27533 |
2047568 | 2047568 | 2021-12-25 | Madera | California | 6039 | 27054 | 324 |
2047569 | 2047569 | 2021-12-25 | Marin | California | 6041 | 19686 | 249 |
2047570 | 2047570 | 2021-12-25 | Mariposa | California | 6043 | 1689 | 18 |
2047571 | 2047571 | 2021-12-25 | Mendocino | California | 6045 | 9010 | 105 |
2047572 | 2047572 | 2021-12-25 | Merced | California | 6047 | 46630 | 695 |
2047573 | 2047573 | 2021-12-25 | Modoc | California | 6049 | 1106 | 11 |
2047574 | 2047574 | 2021-12-25 | Mono | California | 6051 | 2020 | 4 |
2047575 | 2047575 | 2021-12-25 | Monterey | California | 6053 | 54331 | 644 |
2047576 | 2047576 | 2021-12-25 | Napa | California | 6055 | 13947 | 107 |
2047577 | 2047577 | 2021-12-25 | Nevada | California | 6057 | 10522 | 110 |
2047578 | 2047578 | 2021-12-25 | Orange | California | 6059 | 344103 | 5864 |
2047579 | 2047579 | 2021-12-25 | Placer | California | 6061 | 43973 | 489 |
2047580 | 2047580 | 2021-12-25 | Plumas | California | 6063 | 2047 | 13 |
2047581 | 2047581 | 2021-12-25 | Riverside | California | 6065 | 402286 | 5554 |
2047582 | 2047582 | 2021-12-25 | Sacramento | California | 6067 | 174652 | 2512 |
2047583 | 2047583 | 2021-12-25 | San Benito | California | 6069 | 8191 | 79 |
2047584 | 2047584 | 2021-12-25 | San Bernardino | California | 6071 | 388559 | 6043 |
2047585 | 2047585 | 2021-12-25 | San Diego | California | 6073 | 430039 | 4442 |
2047586 | 2047586 | 2021-12-25 | San Francisco | California | 6075 | 61317 | 682 |
2047587 | 2047587 | 2021-12-25 | San Joaquin | California | 6077 | 110610 | 1872 |
2047588 | 2047588 | 2021-12-25 | San Luis Obispo | California | 6079 | 32732 | 367 |
2047589 | 2047589 | 2021-12-25 | San Mateo | California | 6081 | 59051 | 635 |
2047590 | 2047590 | 2021-12-25 | Santa Barbara | California | 6083 | 49369 | 567 |
2047591 | 2047591 | 2021-12-25 | Santa Clara | California | 6085 | 158727 | 1968 |
2047592 | 2047592 | 2021-12-25 | Santa Cruz | California | 6087 | 23326 | 228 |
2047593 | 2047593 | 2021-12-25 | Shasta | California | 6089 | 26805 | 481 |
2047594 | 2047594 | 2021-12-25 | Sierra | California | 6091 | 225 | 0 |
2047595 | 2047595 | 2021-12-25 | Siskiyou | California | 6093 | 5041 | 77 |
2047596 | 2047596 | 2021-12-25 | Solano | California | 6095 | 49012 | 377 |
2047597 | 2047597 | 2021-12-25 | Sonoma | California | 6097 | 44981 | 418 |
2047598 | 2047598 | 2021-12-25 | Stanislaus | California | 6099 | 94009 | 1464 |
2047599 | 2047599 | 2021-12-25 | Sutter | California | 6101 | 14959 | 191 |
2047600 | 2047600 | 2021-12-25 | Tehama | California | 6103 | 10463 | 136 |
2047601 | 2047601 | 2021-12-25 | Trinity | California | 6105 | 1035 | 17 |
2047602 | 2047602 | 2021-12-25 | Tulare | California | 6107 | 88736 | 1137 |
2047603 | 2047603 | 2021-12-25 | Tuolumne | California | 6109 | 8154 | 148 |
2047604 | 2047604 | 2021-12-25 | Ventura | California | 6111 | 108201 | 1206 |
2047605 | 2047605 | 2021-12-25 | Yolo | California | 6113 | 22460 | 270 |
2047606 | 2047606 | 2021-12-25 | Yuba | California | 6115 | 11556 | 98 |
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);