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-09-20 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1735575 | 1735575 | 2021-09-20 | Alameda | California | 6001 | 116235 | 1330 |
1735576 | 1735576 | 2021-09-20 | Alpine | California | 6003 | 100 | 0 |
1735577 | 1735577 | 2021-09-20 | Amador | California | 6005 | 4921 | 59 |
1735578 | 1735578 | 2021-09-20 | Butte | California | 6007 | 21307 | 230 |
1735579 | 1735579 | 2021-09-20 | Calaveras | California | 6009 | 3422 | 66 |
1735580 | 1735580 | 2021-09-20 | Colusa | California | 6011 | 2909 | 18 |
1735581 | 1735581 | 2021-09-20 | Contra Costa | California | 6013 | 95727 | 924 |
1735582 | 1735582 | 2021-09-20 | Del Norte | California | 6015 | 3463 | 35 |
1735583 | 1735583 | 2021-09-20 | El Dorado | California | 6017 | 16004 | 127 |
1735584 | 1735584 | 2021-09-20 | Fresno | California | 6019 | 135861 | 1888 |
1735585 | 1735585 | 2021-09-20 | Glenn | California | 6021 | 3980 | 33 |
1735586 | 1735586 | 2021-09-20 | Humboldt | California | 6023 | 8295 | 87 |
1735587 | 1735587 | 2021-09-20 | Imperial | California | 6025 | 34261 | 754 |
1735588 | 1735588 | 2021-09-20 | Inyo | California | 6027 | 1665 | 39 |
1735589 | 1735589 | 2021-09-20 | Kern | California | 6029 | 135842 | 1515 |
1735590 | 1735590 | 2021-09-20 | Kings | California | 6031 | 30124 | 284 |
1735591 | 1735591 | 2021-09-20 | Lake | California | 6033 | 6036 | 87 |
1735592 | 1735592 | 2021-09-20 | Lassen | California | 6035 | 6914 | 32 |
1735593 | 1735593 | 2021-09-20 | Los Angeles | California | 6037 | 1445830 | 25852 |
1735594 | 1735594 | 2021-09-20 | Madera | California | 6039 | 21707 | 258 |
1735595 | 1735595 | 2021-09-20 | Marin | California | 6041 | 17106 | 242 |
1735596 | 1735596 | 2021-09-20 | Mariposa | California | 6043 | 997 | 12 |
1735597 | 1735597 | 2021-09-20 | Mendocino | California | 6045 | 6834 | 71 |
1735598 | 1735598 | 2021-09-20 | Merced | California | 6047 | 39643 | 541 |
1735599 | 1735599 | 2021-09-20 | Modoc | California | 6049 | 668 | 8 |
1735600 | 1735600 | 2021-09-20 | Mono | California | 6051 | 1493 | 5 |
1735601 | 1735601 | 2021-09-20 | Monterey | California | 6053 | 49465 | 569 |
1735602 | 1735602 | 2021-09-20 | Napa | California | 6055 | 12269 | 95 |
1735603 | 1735603 | 2021-09-20 | Nevada | California | 6057 | 8476 | 85 |
1735604 | 1735604 | 2021-09-20 | Orange | California | 6059 | 314622 | 5354 |
1735605 | 1735605 | 2021-09-20 | Placer | California | 6061 | 36487 | 364 |
1735606 | 1735606 | 2021-09-20 | Plumas | California | 6063 | 1240 | 6 |
1735607 | 1735607 | 2021-09-20 | Riverside | California | 6065 | 357988 | 4906 |
1735608 | 1735608 | 2021-09-20 | Sacramento | California | 6067 | 150306 | 2089 |
1735609 | 1735609 | 2021-09-20 | San Benito | California | 6069 | 7090 | 67 |
1735610 | 1735610 | 2021-09-20 | San Bernardino | California | 6071 | 347203 | 5506 |
1735611 | 1735611 | 2021-09-20 | San Diego | California | 6073 | 366060 | 4006 |
1735612 | 1735612 | 2021-09-20 | San Francisco | California | 6075 | 51910 | 605 |
1735613 | 1735613 | 2021-09-20 | San Joaquin | California | 6077 | 97387 | 1629 |
1735614 | 1735614 | 2021-09-20 | San Luis Obispo | California | 6079 | 28300 | 313 |
1735615 | 1735615 | 2021-09-20 | San Mateo | California | 6081 | 52239 | 607 |
1735616 | 1735616 | 2021-09-20 | Santa Barbara | California | 6083 | 43112 | 500 |
1735617 | 1735617 | 2021-09-20 | Santa Clara | California | 6085 | 140564 | 1842 |
1735618 | 1735618 | 2021-09-20 | Santa Cruz | California | 6087 | 20151 | 211 |
1735619 | 1735619 | 2021-09-20 | Shasta | California | 6089 | 20683 | 276 |
1735620 | 1735620 | 2021-09-20 | Sierra | California | 6091 | 141 | 0 |
1735621 | 1735621 | 2021-09-20 | Siskiyou | California | 6093 | 4134 | 50 |
1735622 | 1735622 | 2021-09-20 | Solano | California | 6095 | 44156 | 312 |
1735623 | 1735623 | 2021-09-20 | Sonoma | California | 6097 | 39441 | 376 |
1735624 | 1735624 | 2021-09-20 | Stanislaus | California | 6099 | 80699 | 1234 |
1735625 | 1735625 | 2021-09-20 | Sutter | California | 6101 | 13094 | 153 |
1735626 | 1735626 | 2021-09-20 | Tehama | California | 6103 | 8237 | 84 |
1735627 | 1735627 | 2021-09-20 | Trinity | California | 6105 | 721 | 7 |
1735628 | 1735628 | 2021-09-20 | Tulare | California | 6107 | 72969 | 896 |
1735629 | 1735629 | 2021-09-20 | Tuolumne | California | 6109 | 6287 | 99 |
1735630 | 1735630 | 2021-09-20 | Ventura | California | 6111 | 97690 | 1120 |
1735631 | 1735631 | 2021-09-20 | Yolo | California | 6113 | 19143 | 239 |
1735632 | 1735632 | 2021-09-20 | Yuba | California | 6115 | 9618 | 61 |
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);