ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-09-14" 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 |
---|---|---|---|---|---|---|---|
1716079 | 1716079 | 2021-09-14 | Alameda | California | 6001 | 114898 | 1330 |
1716080 | 1716080 | 2021-09-14 | Alpine | California | 6003 | 98 | 0 |
1716081 | 1716081 | 2021-09-14 | Amador | California | 6005 | 4805 | 56 |
1716082 | 1716082 | 2021-09-14 | Butte | California | 6007 | 20397 | 225 |
1716083 | 1716083 | 2021-09-14 | Calaveras | California | 6009 | 3276 | 65 |
1716084 | 1716084 | 2021-09-14 | Colusa | California | 6011 | 2859 | 18 |
1716085 | 1716085 | 2021-09-14 | Contra Costa | California | 6013 | 94538 | 908 |
1716086 | 1716086 | 2021-09-14 | Del Norte | California | 6015 | 3347 | 34 |
1716087 | 1716087 | 2021-09-14 | El Dorado | California | 6017 | 15561 | 122 |
1716088 | 1716088 | 2021-09-14 | Fresno | California | 6019 | 133272 | 1853 |
1716089 | 1716089 | 2021-09-14 | Glenn | California | 6021 | 3842 | 31 |
1716090 | 1716090 | 2021-09-14 | Humboldt | California | 6023 | 7969 | 82 |
1716091 | 1716091 | 2021-09-14 | Imperial | California | 6025 | 33849 | 750 |
1716092 | 1716092 | 2021-09-14 | Inyo | California | 6027 | 1611 | 39 |
1716093 | 1716093 | 2021-09-14 | Kern | California | 6029 | 132607 | 1505 |
1716094 | 1716094 | 2021-09-14 | Kings | California | 6031 | 29463 | 278 |
1716095 | 1716095 | 2021-09-14 | Lake | California | 6033 | 5887 | 82 |
1716096 | 1716096 | 2021-09-14 | Lassen | California | 6035 | 6741 | 32 |
1716097 | 1716097 | 2021-09-14 | Los Angeles | California | 6037 | 1435872 | 25713 |
1716098 | 1716098 | 2021-09-14 | Madera | California | 6039 | 21209 | 254 |
1716099 | 1716099 | 2021-09-14 | Marin | California | 6041 | 16944 | 242 |
1716100 | 1716100 | 2021-09-14 | Mariposa | California | 6043 | 933 | 10 |
1716101 | 1716101 | 2021-09-14 | Mendocino | California | 6045 | 6599 | 69 |
1716102 | 1716102 | 2021-09-14 | Merced | California | 6047 | 38856 | 532 |
1716103 | 1716103 | 2021-09-14 | Modoc | California | 6049 | 647 | 8 |
1716104 | 1716104 | 2021-09-14 | Mono | California | 6051 | 1461 | 5 |
1716105 | 1716105 | 2021-09-14 | Monterey | California | 6053 | 48922 | 563 |
1716106 | 1716106 | 2021-09-14 | Napa | California | 6055 | 12117 | 91 |
1716107 | 1716107 | 2021-09-14 | Nevada | California | 6057 | 8283 | 85 |
1716108 | 1716108 | 2021-09-14 | Orange | California | 6059 | 312348 | 5316 |
1716109 | 1716109 | 2021-09-14 | Placer | California | 6061 | 35550 | 343 |
1716110 | 1716110 | 2021-09-14 | Plumas | California | 6063 | 1167 | 6 |
1716111 | 1716111 | 2021-09-14 | Riverside | California | 6065 | 354155 | 4851 |
1716112 | 1716112 | 2021-09-14 | Sacramento | California | 6067 | 147938 | 2038 |
1716113 | 1716113 | 2021-09-14 | San Benito | California | 6069 | 7009 | 64 |
1716114 | 1716114 | 2021-09-14 | San Bernardino | California | 6071 | 343967 | 5441 |
1716115 | 1716115 | 2021-09-14 | San Diego | California | 6073 | 362482 | 3961 |
1716116 | 1716116 | 2021-09-14 | San Francisco | California | 6075 | 51296 | 603 |
1716117 | 1716117 | 2021-09-14 | San Joaquin | California | 6077 | 95699 | 1581 |
1716118 | 1716118 | 2021-09-14 | San Luis Obispo | California | 6079 | 27864 | 301 |
1716119 | 1716119 | 2021-09-14 | San Mateo | California | 6081 | 51629 | 603 |
1716120 | 1716120 | 2021-09-14 | Santa Barbara | California | 6083 | 42212 | 494 |
1716121 | 1716121 | 2021-09-14 | Santa Clara | California | 6085 | 139229 | 1821 |
1716122 | 1716122 | 2021-09-14 | Santa Cruz | California | 6087 | 19951 | 210 |
1716123 | 1716123 | 2021-09-14 | Shasta | California | 6089 | 19575 | 266 |
1716124 | 1716124 | 2021-09-14 | Sierra | California | 6091 | 138 | 0 |
1716125 | 1716125 | 2021-09-14 | Siskiyou | California | 6093 | 3933 | 46 |
1716126 | 1716126 | 2021-09-14 | Solano | California | 6095 | 43575 | 306 |
1716127 | 1716127 | 2021-09-14 | Sonoma | California | 6097 | 38984 | 368 |
1716128 | 1716128 | 2021-09-14 | Stanislaus | California | 6099 | 79230 | 1197 |
1716129 | 1716129 | 2021-09-14 | Sutter | California | 6101 | 12812 | 145 |
1716130 | 1716130 | 2021-09-14 | Tehama | California | 6103 | 7839 | 79 |
1716131 | 1716131 | 2021-09-14 | Trinity | California | 6105 | 677 | 7 |
1716132 | 1716132 | 2021-09-14 | Tulare | California | 6107 | 70927 | 887 |
1716133 | 1716133 | 2021-09-14 | Tuolumne | California | 6109 | 6131 | 99 |
1716134 | 1716134 | 2021-09-14 | Ventura | California | 6111 | 96840 | 1107 |
1716135 | 1716135 | 2021-09-14 | Yolo | California | 6113 | 18823 | 239 |
1716136 | 1716136 | 2021-09-14 | Yuba | California | 6115 | 9251 | 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);