ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where "date" is on date 2020-04-16 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
62051 | 62051 | 2020-04-16 | Alameda | California | 6001 | 1069 | 40 |
62052 | 62052 | 2020-04-16 | Alpine | California | 6003 | 2 | 0 |
62053 | 62053 | 2020-04-16 | Amador | California | 6005 | 6 | 0 |
62054 | 62054 | 2020-04-16 | Butte | California | 6007 | 16 | 0 |
62055 | 62055 | 2020-04-16 | Calaveras | California | 6009 | 11 | 0 |
62056 | 62056 | 2020-04-16 | Colusa | California | 6011 | 3 | 0 |
62057 | 62057 | 2020-04-16 | Contra Costa | California | 6013 | 631 | 16 |
62058 | 62058 | 2020-04-16 | Del Norte | California | 6015 | 2 | 0 |
62059 | 62059 | 2020-04-16 | El Dorado | California | 6017 | 35 | 0 |
62060 | 62060 | 2020-04-16 | Fresno | California | 6019 | 295 | 7 |
62061 | 62061 | 2020-04-16 | Glenn | California | 6021 | 4 | 0 |
62062 | 62062 | 2020-04-16 | Humboldt | California | 6023 | 52 | 0 |
62063 | 62063 | 2020-04-16 | Imperial | California | 6025 | 143 | 2 |
62064 | 62064 | 2020-04-16 | Inyo | California | 6027 | 17 | 0 |
62065 | 62065 | 2020-04-16 | Kern | California | 6029 | 553 | 3 |
62066 | 62066 | 2020-04-16 | Kings | California | 6031 | 18 | 1 |
62067 | 62067 | 2020-04-16 | Lake | California | 6033 | 6 | 0 |
62068 | 62068 | 2020-04-16 | Los Angeles | California | 6037 | 10854 | 455 |
62069 | 62069 | 2020-04-16 | Madera | California | 6039 | 33 | 2 |
62070 | 62070 | 2020-04-16 | Marin | California | 6041 | 187 | 10 |
62071 | 62071 | 2020-04-16 | Mendocino | California | 6045 | 4 | 0 |
62072 | 62072 | 2020-04-16 | Merced | California | 6047 | 82 | 3 |
62073 | 62073 | 2020-04-16 | Mono | California | 6051 | 23 | 1 |
62074 | 62074 | 2020-04-16 | Monterey | California | 6053 | 119 | 3 |
62075 | 62075 | 2020-04-16 | Napa | California | 6055 | 40 | 2 |
62076 | 62076 | 2020-04-16 | Nevada | California | 6057 | 34 | 1 |
62077 | 62077 | 2020-04-16 | Orange | California | 6059 | 1425 | 25 |
62078 | 62078 | 2020-04-16 | Placer | California | 6061 | 130 | 8 |
62079 | 62079 | 2020-04-16 | Plumas | California | 6063 | 4 | 0 |
62080 | 62080 | 2020-04-16 | Riverside | California | 6065 | 2264 | 59 |
62081 | 62081 | 2020-04-16 | Sacramento | California | 6067 | 879 | 32 |
62082 | 62082 | 2020-04-16 | San Benito | California | 6069 | 42 | 2 |
62083 | 62083 | 2020-04-16 | San Bernardino | California | 6071 | 1032 | 47 |
62084 | 62084 | 2020-04-16 | San Diego | California | 6073 | 2087 | 63 |
62085 | 62085 | 2020-04-16 | San Francisco | California | 6075 | 1022 | 17 |
62086 | 62086 | 2020-04-16 | San Joaquin | California | 6077 | 369 | 17 |
62087 | 62087 | 2020-04-16 | San Luis Obispo | California | 6079 | 125 | 1 |
62088 | 62088 | 2020-04-16 | San Mateo | California | 6081 | 767 | 28 |
62089 | 62089 | 2020-04-16 | Santa Barbara | California | 6083 | 354 | 3 |
62090 | 62090 | 2020-04-16 | Santa Clara | California | 6085 | 1833 | 70 |
62091 | 62091 | 2020-04-16 | Santa Cruz | California | 6087 | 96 | 2 |
62092 | 62092 | 2020-04-16 | Shasta | California | 6089 | 26 | 3 |
62093 | 62093 | 2020-04-16 | Siskiyou | California | 6093 | 5 | 0 |
62094 | 62094 | 2020-04-16 | Solano | California | 6095 | 161 | 2 |
62095 | 62095 | 2020-04-16 | Sonoma | California | 6097 | 172 | 2 |
62096 | 62096 | 2020-04-16 | Stanislaus | California | 6099 | 187 | 4 |
62097 | 62097 | 2020-04-16 | Sutter | California | 6101 | 24 | 2 |
62098 | 62098 | 2020-04-16 | Tehama | California | 6103 | 1 | 0 |
62099 | 62099 | 2020-04-16 | Tulare | California | 6107 | 372 | 17 |
62100 | 62100 | 2020-04-16 | Tuolumne | California | 6109 | 2 | 0 |
62101 | 62101 | 2020-04-16 | Ventura | California | 6111 | 384 | 13 |
62102 | 62102 | 2020-04-16 | Yolo | California | 6113 | 125 | 7 |
62103 | 62103 | 2020-04-16 | Yuba | California | 6115 | 15 | 1 |
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);