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 2020-11-04 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
696711 | 696711 | 2020-11-04 | Alameda | California | 6001 | 24254 | 466 |
696712 | 696712 | 2020-11-04 | Alpine | California | 6003 | 4 | 0 |
696713 | 696713 | 2020-11-04 | Amador | California | 6005 | 360 | 16 |
696714 | 696714 | 2020-11-04 | Butte | California | 6007 | 3211 | 54 |
696715 | 696715 | 2020-11-04 | Calaveras | California | 6009 | 361 | 21 |
696716 | 696716 | 2020-11-04 | Colusa | California | 6011 | 576 | 6 |
696717 | 696717 | 2020-11-04 | Contra Costa | California | 6013 | 19416 | 247 |
696718 | 696718 | 2020-11-04 | Del Norte | California | 6015 | 198 | 1 |
696719 | 696719 | 2020-11-04 | El Dorado | California | 6017 | 1445 | 4 |
696720 | 696720 | 2020-11-04 | Fresno | California | 6019 | 32022 | 447 |
696721 | 696721 | 2020-11-04 | Glenn | California | 6021 | 698 | 3 |
696722 | 696722 | 2020-11-04 | Humboldt | California | 6023 | 592 | 10 |
696723 | 696723 | 2020-11-04 | Imperial | California | 6025 | 13284 | 337 |
696724 | 696724 | 2020-11-04 | Inyo | California | 6027 | 244 | 15 |
696725 | 696725 | 2020-11-04 | Kern | California | 6029 | 34779 | 426 |
696726 | 696726 | 2020-11-04 | Kings | California | 6031 | 8783 | 84 |
696727 | 696727 | 2020-11-04 | Lake | California | 6033 | 732 | 17 |
696728 | 696728 | 2020-11-04 | Lassen | California | 6035 | 782 | 1 |
696729 | 696729 | 2020-11-04 | Los Angeles | California | 6037 | 313526 | 7117 |
696730 | 696730 | 2020-11-04 | Madera | California | 6039 | 5094 | 76 |
696731 | 696731 | 2020-11-04 | Marin | California | 6041 | 7197 | 127 |
696732 | 696732 | 2020-11-04 | Mariposa | California | 6043 | 81 | 2 |
696733 | 696733 | 2020-11-04 | Mendocino | California | 6045 | 1193 | 21 |
696734 | 696734 | 2020-11-04 | Merced | California | 6047 | 9880 | 161 |
696735 | 696735 | 2020-11-04 | Modoc | California | 6049 | 52 | 0 |
696736 | 696736 | 2020-11-04 | Mono | California | 6051 | 268 | 2 |
696737 | 696737 | 2020-11-04 | Monterey | California | 6053 | 11956 | 99 |
696738 | 696738 | 2020-11-04 | Napa | California | 6055 | 2131 | 16 |
696739 | 696739 | 2020-11-04 | Nevada | California | 6057 | 681 | 9 |
696740 | 696740 | 2020-11-04 | Orange | California | 6059 | 62838 | 1491 |
696741 | 696741 | 2020-11-04 | Placer | California | 6061 | 4542 | 60 |
696742 | 696742 | 2020-11-04 | Plumas | California | 6063 | 86 | 0 |
696743 | 696743 | 2020-11-04 | Riverside | California | 6065 | 69827 | 1329 |
696744 | 696744 | 2020-11-04 | Sacramento | California | 6067 | 27042 | 506 |
696745 | 696745 | 2020-11-04 | San Benito | California | 6069 | 1483 | 15 |
696746 | 696746 | 2020-11-04 | San Bernardino | California | 6071 | 66656 | 1088 |
696747 | 696747 | 2020-11-04 | San Diego | California | 6073 | 58169 | 904 |
696748 | 696748 | 2020-11-04 | San Francisco | California | 6075 | 12602 | 149 |
696749 | 696749 | 2020-11-04 | San Joaquin | California | 6077 | 22450 | 494 |
696750 | 696750 | 2020-11-04 | San Luis Obispo | California | 6079 | 4422 | 33 |
696751 | 696751 | 2020-11-04 | San Mateo | California | 6081 | 11564 | 161 |
696752 | 696752 | 2020-11-04 | Santa Barbara | California | 6083 | 10042 | 130 |
696753 | 696753 | 2020-11-04 | Santa Clara | California | 6085 | 25543 | 422 |
696754 | 696754 | 2020-11-04 | Santa Cruz | California | 6087 | 3007 | 26 |
696755 | 696755 | 2020-11-04 | Shasta | California | 6089 | 2288 | 33 |
696756 | 696756 | 2020-11-04 | Sierra | California | 6091 | 6 | 0 |
696757 | 696757 | 2020-11-04 | Siskiyou | California | 6093 | 278 | 0 |
696758 | 696758 | 2020-11-04 | Solano | California | 6095 | 7945 | 76 |
696759 | 696759 | 2020-11-04 | Sonoma | California | 6097 | 10041 | 142 |
696760 | 696760 | 2020-11-04 | Stanislaus | California | 6099 | 18990 | 404 |
696761 | 696761 | 2020-11-04 | Sutter | California | 6101 | 1964 | 12 |
696762 | 696762 | 2020-11-04 | Tehama | California | 6103 | 988 | 15 |
696763 | 696763 | 2020-11-04 | Trinity | California | 6105 | 37 | 0 |
696764 | 696764 | 2020-11-04 | Tulare | California | 6107 | 18117 | 297 |
696765 | 696765 | 2020-11-04 | Tuolumne | California | 6109 | 312 | 7 |
696766 | 696766 | 2020-11-04 | Ventura | California | 6111 | 14816 | 167 |
696767 | 696767 | 2020-11-04 | Yolo | California | 6113 | 3363 | 62 |
696768 | 696768 | 2020-11-04 | Yuba | California | 6115 | 1411 | 10 |
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);