ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-08-30" 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 |
---|---|---|---|---|---|---|---|
1667354 | 1667354 | 2021-08-30 | Alameda | California | 6001 | 110119 | 1312 |
1667355 | 1667355 | 2021-08-30 | Alpine | California | 6003 | 92 | 0 |
1667356 | 1667356 | 2021-08-30 | Amador | California | 6005 | 4540 | 53 |
1667357 | 1667357 | 2021-08-30 | Butte | California | 6007 | 18237 | 214 |
1667358 | 1667358 | 2021-08-30 | Calaveras | California | 6009 | 2991 | 61 |
1667359 | 1667359 | 2021-08-30 | Colusa | California | 6011 | 2718 | 18 |
1667360 | 1667360 | 2021-08-30 | Contra Costa | California | 6013 | 89256 | 872 |
1667361 | 1667361 | 2021-08-30 | Del Norte | California | 6015 | 2890 | 23 |
1667362 | 1667362 | 2021-08-30 | El Dorado | California | 6017 | 14384 | 122 |
1667363 | 1667363 | 2021-08-30 | Fresno | California | 6019 | 125743 | 1790 |
1667364 | 1667364 | 2021-08-30 | Glenn | California | 6021 | 3483 | 28 |
1667365 | 1667365 | 2021-08-30 | Humboldt | California | 6023 | 7189 | 76 |
1667366 | 1667366 | 2021-08-30 | Imperial | California | 6025 | 33300 | 749 |
1667367 | 1667367 | 2021-08-30 | Inyo | California | 6027 | 1555 | 39 |
1667368 | 1667368 | 2021-08-30 | Kern | California | 6029 | 124432 | 1462 |
1667369 | 1667369 | 2021-08-30 | Kings | California | 6031 | 27652 | 264 |
1667370 | 1667370 | 2021-08-30 | Lake | California | 6033 | 5343 | 74 |
1667371 | 1667371 | 2021-08-30 | Lassen | California | 6035 | 6265 | 27 |
1667372 | 1667372 | 2021-08-30 | Los Angeles | California | 6037 | 1406094 | 25263 |
1667373 | 1667373 | 2021-08-30 | Madera | California | 6039 | 19875 | 250 |
1667374 | 1667374 | 2021-08-30 | Marin | California | 6041 | 16479 | 240 |
1667375 | 1667375 | 2021-08-30 | Mariposa | California | 6043 | 803 | 10 |
1667376 | 1667376 | 2021-08-30 | Mendocino | California | 6045 | 5927 | 61 |
1667377 | 1667377 | 2021-08-30 | Merced | California | 6047 | 36740 | 508 |
1667378 | 1667378 | 2021-08-30 | Modoc | California | 6049 | 606 | 7 |
1667379 | 1667379 | 2021-08-30 | Mono | California | 6051 | 1433 | 5 |
1667380 | 1667380 | 2021-08-30 | Monterey | California | 6053 | 47879 | 542 |
1667381 | 1667381 | 2021-08-30 | Napa | California | 6055 | 11621 | 87 |
1667382 | 1667382 | 2021-08-30 | Nevada | California | 6057 | 7534 | 85 |
1667383 | 1667383 | 2021-08-30 | Orange | California | 6059 | 305019 | 5223 |
1667384 | 1667384 | 2021-08-30 | Placer | California | 6061 | 32230 | 319 |
1667385 | 1667385 | 2021-08-30 | Plumas | California | 6063 | 1014 | 6 |
1667386 | 1667386 | 2021-08-30 | Riverside | California | 6065 | 343027 | 4727 |
1667387 | 1667387 | 2021-08-30 | Sacramento | California | 6067 | 136979 | 1907 |
1667388 | 1667388 | 2021-08-30 | San Benito | California | 6069 | 6782 | 64 |
1667389 | 1667389 | 2021-08-30 | San Bernardino | California | 6071 | 334404 | 5348 |
1667390 | 1667390 | 2021-08-30 | San Diego | California | 6073 | 348849 | 3880 |
1667391 | 1667391 | 2021-08-30 | San Francisco | California | 6075 | 49081 | 581 |
1667392 | 1667392 | 2021-08-30 | San Joaquin | California | 6077 | 90511 | 1528 |
1667393 | 1667393 | 2021-08-30 | San Luis Obispo | California | 6079 | 26286 | 281 |
1667394 | 1667394 | 2021-08-30 | San Mateo | California | 6081 | 49677 | 595 |
1667395 | 1667395 | 2021-08-30 | Santa Barbara | California | 6083 | 40488 | 481 |
1667396 | 1667396 | 2021-08-30 | Santa Clara | California | 6085 | 134026 | 1790 |
1667397 | 1667397 | 2021-08-30 | Santa Cruz | California | 6087 | 19264 | 210 |
1667398 | 1667398 | 2021-08-30 | Shasta | California | 6089 | 17564 | 254 |
1667399 | 1667399 | 2021-08-30 | Sierra | California | 6091 | 106 | 0 |
1667400 | 1667400 | 2021-08-30 | Siskiyou | California | 6093 | 3203 | 40 |
1667401 | 1667401 | 2021-08-30 | Solano | California | 6095 | 40855 | 290 |
1667402 | 1667402 | 2021-08-30 | Sonoma | California | 6097 | 37098 | 353 |
1667403 | 1667403 | 2021-08-30 | Stanislaus | California | 6099 | 74163 | 1139 |
1667404 | 1667404 | 2021-08-30 | Sutter | California | 6101 | 11961 | 136 |
1667405 | 1667405 | 2021-08-30 | Tehama | California | 6103 | 6860 | 71 |
1667406 | 1667406 | 2021-08-30 | Trinity | California | 6105 | 573 | 3 |
1667407 | 1667407 | 2021-08-30 | Tulare | California | 6107 | 66371 | 870 |
1667408 | 1667408 | 2021-08-30 | Tuolumne | California | 6109 | 5661 | 88 |
1667409 | 1667409 | 2021-08-30 | Ventura | California | 6111 | 94175 | 1082 |
1667410 | 1667410 | 2021-08-30 | Yolo | California | 6113 | 17745 | 231 |
1667411 | 1667411 | 2021-08-30 | Yuba | California | 6115 | 8551 | 54 |
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);