ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-09-12" 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 |
---|---|---|---|---|---|---|---|
1709586 | 1709586 | 2021-09-12 | Alameda | California | 6001 | 114454 | 1321 |
1709587 | 1709587 | 2021-09-12 | Alpine | California | 6003 | 98 | 0 |
1709588 | 1709588 | 2021-09-12 | Amador | California | 6005 | 4772 | 56 |
1709589 | 1709589 | 2021-09-12 | Butte | California | 6007 | 20222 | 221 |
1709590 | 1709590 | 2021-09-12 | Calaveras | California | 6009 | 3231 | 65 |
1709591 | 1709591 | 2021-09-12 | Colusa | California | 6011 | 2851 | 18 |
1709592 | 1709592 | 2021-09-12 | Contra Costa | California | 6013 | 94149 | 908 |
1709593 | 1709593 | 2021-09-12 | Del Norte | California | 6015 | 3201 | 31 |
1709594 | 1709594 | 2021-09-12 | El Dorado | California | 6017 | 15484 | 122 |
1709595 | 1709595 | 2021-09-12 | Fresno | California | 6019 | 132846 | 1853 |
1709596 | 1709596 | 2021-09-12 | Glenn | California | 6021 | 3823 | 31 |
1709597 | 1709597 | 2021-09-12 | Humboldt | California | 6023 | 7925 | 81 |
1709598 | 1709598 | 2021-09-12 | Imperial | California | 6025 | 33807 | 750 |
1709599 | 1709599 | 2021-09-12 | Inyo | California | 6027 | 1599 | 39 |
1709600 | 1709600 | 2021-09-12 | Kern | California | 6029 | 130375 | 1496 |
1709601 | 1709601 | 2021-09-12 | Kings | California | 6031 | 29236 | 275 |
1709602 | 1709602 | 2021-09-12 | Lake | California | 6033 | 5839 | 82 |
1709603 | 1709603 | 2021-09-12 | Lassen | California | 6035 | 6577 | 31 |
1709604 | 1709604 | 2021-09-12 | Los Angeles | California | 6037 | 1428526 | 25630 |
1709605 | 1709605 | 2021-09-12 | Madera | California | 6039 | 21122 | 254 |
1709606 | 1709606 | 2021-09-12 | Marin | California | 6041 | 16883 | 242 |
1709607 | 1709607 | 2021-09-12 | Mariposa | California | 6043 | 889 | 10 |
1709608 | 1709608 | 2021-09-12 | Mendocino | California | 6045 | 6495 | 67 |
1709609 | 1709609 | 2021-09-12 | Merced | California | 6047 | 38307 | 527 |
1709610 | 1709610 | 2021-09-12 | Modoc | California | 6049 | 647 | 8 |
1709611 | 1709611 | 2021-09-12 | Mono | California | 6051 | 1461 | 5 |
1709612 | 1709612 | 2021-09-12 | Monterey | California | 6053 | 48874 | 562 |
1709613 | 1709613 | 2021-09-12 | Napa | California | 6055 | 12069 | 91 |
1709614 | 1709614 | 2021-09-12 | Nevada | California | 6057 | 8229 | 85 |
1709615 | 1709615 | 2021-09-12 | Orange | California | 6059 | 310195 | 5306 |
1709616 | 1709616 | 2021-09-12 | Placer | California | 6061 | 35347 | 344 |
1709617 | 1709617 | 2021-09-12 | Plumas | California | 6063 | 1137 | 6 |
1709618 | 1709618 | 2021-09-12 | Riverside | California | 6065 | 352864 | 4826 |
1709619 | 1709619 | 2021-09-12 | Sacramento | California | 6067 | 146958 | 2010 |
1709620 | 1709620 | 2021-09-12 | San Benito | California | 6069 | 6986 | 64 |
1709621 | 1709621 | 2021-09-12 | San Bernardino | California | 6071 | 342866 | 5430 |
1709622 | 1709622 | 2021-09-12 | San Diego | California | 6073 | 361190 | 3942 |
1709623 | 1709623 | 2021-09-12 | San Francisco | California | 6075 | 51042 | 603 |
1709624 | 1709624 | 2021-09-12 | San Joaquin | California | 6077 | 95215 | 1581 |
1709625 | 1709625 | 2021-09-12 | San Luis Obispo | California | 6079 | 27710 | 299 |
1709626 | 1709626 | 2021-09-12 | San Mateo | California | 6081 | 51445 | 603 |
1709627 | 1709627 | 2021-09-12 | Santa Barbara | California | 6083 | 42002 | 494 |
1709628 | 1709628 | 2021-09-12 | Santa Clara | California | 6085 | 138736 | 1821 |
1709629 | 1709629 | 2021-09-12 | Santa Cruz | California | 6087 | 19899 | 210 |
1709630 | 1709630 | 2021-09-12 | Shasta | California | 6089 | 19419 | 265 |
1709631 | 1709631 | 2021-09-12 | Sierra | California | 6091 | 138 | 0 |
1709632 | 1709632 | 2021-09-12 | Siskiyou | California | 6093 | 3766 | 43 |
1709633 | 1709633 | 2021-09-12 | Solano | California | 6095 | 43418 | 306 |
1709634 | 1709634 | 2021-09-12 | Sonoma | California | 6097 | 38870 | 368 |
1709635 | 1709635 | 2021-09-12 | Stanislaus | California | 6099 | 78021 | 1194 |
1709636 | 1709636 | 2021-09-12 | Sutter | California | 6101 | 12726 | 145 |
1709637 | 1709637 | 2021-09-12 | Tehama | California | 6103 | 7739 | 79 |
1709638 | 1709638 | 2021-09-12 | Trinity | California | 6105 | 670 | 7 |
1709639 | 1709639 | 2021-09-12 | Tulare | California | 6107 | 70480 | 889 |
1709640 | 1709640 | 2021-09-12 | Tuolumne | California | 6109 | 5996 | 96 |
1709641 | 1709641 | 2021-09-12 | Ventura | California | 6111 | 96489 | 1107 |
1709642 | 1709642 | 2021-09-12 | Yolo | California | 6113 | 18755 | 239 |
1709643 | 1709643 | 2021-09-12 | Yuba | California | 6115 | 9222 | 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);