ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-02-18" 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 |
---|---|---|---|---|---|---|---|
1040708 | 1040708 | 2021-02-18 | Alameda | California | 6001 | 79113 | 1126 |
1040709 | 1040709 | 2021-02-18 | Alpine | California | 6003 | 77 | 0 |
1040710 | 1040710 | 2021-02-18 | Amador | California | 6005 | 3414 | 38 |
1040711 | 1040711 | 2021-02-18 | Butte | California | 6007 | 10770 | 153 |
1040712 | 1040712 | 2021-02-18 | Calaveras | California | 6009 | 1876 | 25 |
1040713 | 1040713 | 2021-02-18 | Colusa | California | 6011 | 2116 | 13 |
1040714 | 1040714 | 2021-02-18 | Contra Costa | California | 6013 | 61134 | 631 |
1040715 | 1040715 | 2021-02-18 | Del Norte | California | 6015 | 954 | 5 |
1040716 | 1040716 | 2021-02-18 | El Dorado | California | 6017 | 8847 | 91 |
1040717 | 1040717 | 2021-02-18 | Fresno | California | 6019 | 93555 | 1349 |
1040718 | 1040718 | 2021-02-18 | Glenn | California | 6021 | 2647 | 23 |
1040719 | 1040719 | 2021-02-18 | Humboldt | California | 6023 | 3053 | 32 |
1040720 | 1040720 | 2021-02-18 | Imperial | California | 6025 | 26817 | 583 |
1040721 | 1040721 | 2021-02-18 | Inyo | California | 6027 | 1197 | 34 |
1040722 | 1040722 | 2021-02-18 | Kern | California | 6029 | 101157 | 727 |
1040723 | 1040723 | 2021-02-18 | Kings | California | 6031 | 21720 | 213 |
1040724 | 1040724 | 2021-02-18 | Lake | California | 6033 | 3057 | 39 |
1040725 | 1040725 | 2021-02-18 | Lassen | California | 6035 | 5558 | 19 |
1040726 | 1040726 | 2021-02-18 | Los Angeles | California | 6037 | 1174897 | 19514 |
1040727 | 1040727 | 2021-02-18 | Madera | California | 6039 | 15135 | 201 |
1040728 | 1040728 | 2021-02-18 | Marin | California | 6041 | 12881 | 192 |
1040729 | 1040729 | 2021-02-18 | Mariposa | California | 6043 | 389 | 7 |
1040730 | 1040730 | 2021-02-18 | Mendocino | California | 6045 | 3750 | 41 |
1040731 | 1040731 | 2021-02-18 | Merced | California | 6047 | 28385 | 384 |
1040732 | 1040732 | 2021-02-18 | Modoc | California | 6049 | 446 | 4 |
1040733 | 1040733 | 2021-02-18 | Mono | California | 6051 | 1180 | 4 |
1040734 | 1040734 | 2021-02-18 | Monterey | California | 6053 | 41675 | 313 |
1040735 | 1040735 | 2021-02-18 | Napa | California | 6055 | 8866 | 65 |
1040736 | 1040736 | 2021-02-18 | Nevada | California | 6057 | 3832 | 74 |
1040737 | 1040737 | 2021-02-18 | Orange | California | 6059 | 258182 | 3685 |
1040738 | 1040738 | 2021-02-18 | Placer | California | 6061 | 19462 | 229 |
1040739 | 1040739 | 2021-02-18 | Plumas | California | 6063 | 623 | 6 |
1040740 | 1040740 | 2021-02-18 | Riverside | California | 6065 | 287200 | 3599 |
1040741 | 1040741 | 2021-02-18 | Sacramento | California | 6067 | 91392 | 1412 |
1040742 | 1040742 | 2021-02-18 | San Benito | California | 6069 | 5661 | 57 |
1040743 | 1040743 | 2021-02-18 | San Bernardino | California | 6071 | 283356 | 2492 |
1040744 | 1040744 | 2021-02-18 | San Diego | California | 6073 | 255053 | 3135 |
1040745 | 1040745 | 2021-02-18 | San Francisco | California | 6075 | 33561 | 376 |
1040746 | 1040746 | 2021-02-18 | San Joaquin | California | 6077 | 65705 | 1021 |
1040747 | 1040747 | 2021-02-18 | San Luis Obispo | California | 6079 | 19283 | 210 |
1040748 | 1040748 | 2021-02-18 | San Mateo | California | 6081 | 38124 | 481 |
1040749 | 1040749 | 2021-02-18 | Santa Barbara | California | 6083 | 31185 | 388 |
1040750 | 1040750 | 2021-02-18 | Santa Clara | California | 6085 | 108255 | 1709 |
1040751 | 1040751 | 2021-02-18 | Santa Cruz | California | 6087 | 14394 | 172 |
1040752 | 1040752 | 2021-02-18 | Shasta | California | 6089 | 10834 | 171 |
1040753 | 1040753 | 2021-02-18 | Sierra | California | 6091 | 47 | 0 |
1040754 | 1040754 | 2021-02-18 | Siskiyou | California | 6093 | 1695 | 13 |
1040755 | 1040755 | 2021-02-18 | Solano | California | 6095 | 29695 | 156 |
1040756 | 1040756 | 2021-02-18 | Sonoma | California | 6097 | 27414 | 291 |
1040757 | 1040757 | 2021-02-18 | Stanislaus | California | 6099 | 54728 | 916 |
1040758 | 1040758 | 2021-02-18 | Sutter | California | 6101 | 8744 | 94 |
1040759 | 1040759 | 2021-02-18 | Tehama | California | 6103 | 4511 | 51 |
1040760 | 1040760 | 2021-02-18 | Trinity | California | 6105 | 278 | 5 |
1040761 | 1040761 | 2021-02-18 | Tulare | California | 6107 | 47311 | 717 |
1040762 | 1040762 | 2021-02-18 | Tuolumne | California | 6109 | 3866 | 56 |
1040763 | 1040763 | 2021-02-18 | Ventura | California | 6111 | 76234 | 775 |
1040764 | 1040764 | 2021-02-18 | Yolo | California | 6113 | 12506 | 181 |
1040765 | 1040765 | 2021-02-18 | Yuba | California | 6115 | 5661 | 36 |
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);