ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-09-15" 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 |
---|---|---|---|---|---|---|---|
1719327 | 1719327 | 2021-09-15 | Alameda | California | 6001 | 115068 | 1330 |
1719328 | 1719328 | 2021-09-15 | Alpine | California | 6003 | 98 | 0 |
1719329 | 1719329 | 2021-09-15 | Amador | California | 6005 | 4834 | 57 |
1719330 | 1719330 | 2021-09-15 | Butte | California | 6007 | 20520 | 226 |
1719331 | 1719331 | 2021-09-15 | Calaveras | California | 6009 | 3303 | 66 |
1719332 | 1719332 | 2021-09-15 | Colusa | California | 6011 | 2857 | 18 |
1719333 | 1719333 | 2021-09-15 | Contra Costa | California | 6013 | 94702 | 911 |
1719334 | 1719334 | 2021-09-15 | Del Norte | California | 6015 | 3365 | 34 |
1719335 | 1719335 | 2021-09-15 | El Dorado | California | 6017 | 15614 | 123 |
1719336 | 1719336 | 2021-09-15 | Fresno | California | 6019 | 133773 | 1856 |
1719337 | 1719337 | 2021-09-15 | Glenn | California | 6021 | 3861 | 31 |
1719338 | 1719338 | 2021-09-15 | Humboldt | California | 6023 | 8027 | 82 |
1719339 | 1719339 | 2021-09-15 | Imperial | California | 6025 | 33892 | 751 |
1719340 | 1719340 | 2021-09-15 | Inyo | California | 6027 | 1614 | 39 |
1719341 | 1719341 | 2021-09-15 | Kern | California | 6029 | 133282 | 1510 |
1719342 | 1719342 | 2021-09-15 | Kings | California | 6031 | 29560 | 278 |
1719343 | 1719343 | 2021-09-15 | Lake | California | 6033 | 5923 | 83 |
1719344 | 1719344 | 2021-09-15 | Lassen | California | 6035 | 6765 | 32 |
1719345 | 1719345 | 2021-09-15 | Los Angeles | California | 6037 | 1437782 | 25748 |
1719346 | 1719346 | 2021-09-15 | Madera | California | 6039 | 21274 | 254 |
1719347 | 1719347 | 2021-09-15 | Marin | California | 6041 | 16971 | 242 |
1719348 | 1719348 | 2021-09-15 | Mariposa | California | 6043 | 942 | 12 |
1719349 | 1719349 | 2021-09-15 | Mendocino | California | 6045 | 6664 | 71 |
1719350 | 1719350 | 2021-09-15 | Merced | California | 6047 | 38983 | 535 |
1719351 | 1719351 | 2021-09-15 | Modoc | California | 6049 | 668 | 8 |
1719352 | 1719352 | 2021-09-15 | Mono | California | 6051 | 1461 | 5 |
1719353 | 1719353 | 2021-09-15 | Monterey | California | 6053 | 48958 | 566 |
1719354 | 1719354 | 2021-09-15 | Napa | California | 6055 | 12148 | 91 |
1719355 | 1719355 | 2021-09-15 | Nevada | California | 6057 | 8318 | 85 |
1719356 | 1719356 | 2021-09-15 | Orange | California | 6059 | 312736 | 5326 |
1719357 | 1719357 | 2021-09-15 | Placer | California | 6061 | 35668 | 350 |
1719358 | 1719358 | 2021-09-15 | Plumas | California | 6063 | 1173 | 6 |
1719359 | 1719359 | 2021-09-15 | Riverside | California | 6065 | 354813 | 4872 |
1719360 | 1719360 | 2021-09-15 | Sacramento | California | 6067 | 148452 | 2052 |
1719361 | 1719361 | 2021-09-15 | San Benito | California | 6069 | 7029 | 64 |
1719362 | 1719362 | 2021-09-15 | San Bernardino | California | 6071 | 344322 | 5465 |
1719363 | 1719363 | 2021-09-15 | San Diego | California | 6073 | 363039 | 3966 |
1719364 | 1719364 | 2021-09-15 | San Francisco | California | 6075 | 51380 | 603 |
1719365 | 1719365 | 2021-09-15 | San Joaquin | California | 6077 | 95861 | 1619 |
1719366 | 1719366 | 2021-09-15 | San Luis Obispo | California | 6079 | 27904 | 304 |
1719367 | 1719367 | 2021-09-15 | San Mateo | California | 6081 | 51706 | 603 |
1719368 | 1719368 | 2021-09-15 | Santa Barbara | California | 6083 | 42334 | 495 |
1719369 | 1719369 | 2021-09-15 | Santa Clara | California | 6085 | 139398 | 1829 |
1719370 | 1719370 | 2021-09-15 | Santa Cruz | California | 6087 | 19999 | 210 |
1719371 | 1719371 | 2021-09-15 | Shasta | California | 6089 | 19694 | 274 |
1719372 | 1719372 | 2021-09-15 | Sierra | California | 6091 | 138 | 0 |
1719373 | 1719373 | 2021-09-15 | Siskiyou | California | 6093 | 3963 | 46 |
1719374 | 1719374 | 2021-09-15 | Solano | California | 6095 | 43673 | 307 |
1719375 | 1719375 | 2021-09-15 | Sonoma | California | 6097 | 39066 | 372 |
1719376 | 1719376 | 2021-09-15 | Stanislaus | California | 6099 | 79420 | 1210 |
1719377 | 1719377 | 2021-09-15 | Sutter | California | 6101 | 12858 | 149 |
1719378 | 1719378 | 2021-09-15 | Tehama | California | 6103 | 7895 | 80 |
1719379 | 1719379 | 2021-09-15 | Trinity | California | 6105 | 682 | 7 |
1719380 | 1719380 | 2021-09-15 | Tulare | California | 6107 | 71120 | 888 |
1719381 | 1719381 | 2021-09-15 | Tuolumne | California | 6109 | 6163 | 99 |
1719382 | 1719382 | 2021-09-15 | Ventura | California | 6111 | 97002 | 1107 |
1719383 | 1719383 | 2021-09-15 | Yolo | California | 6113 | 18888 | 239 |
1719384 | 1719384 | 2021-09-15 | 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);