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 2021-07-29 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1563404 | 1563404 | 2021-07-29 | Alameda | California | 6001 | 97331 | 1282 |
1563405 | 1563405 | 2021-07-29 | Alpine | California | 6003 | 89 | 0 |
1563406 | 1563406 | 2021-07-29 | Amador | California | 6005 | 3905 | 48 |
1563407 | 1563407 | 2021-07-29 | Butte | California | 6007 | 15274 | 205 |
1563408 | 1563408 | 2021-07-29 | Calaveras | California | 6009 | 2308 | 58 |
1563409 | 1563409 | 2021-07-29 | Colusa | California | 6011 | 2353 | 18 |
1563410 | 1563410 | 2021-07-29 | Contra Costa | California | 6013 | 77038 | 832 |
1563411 | 1563411 | 2021-07-29 | Del Norte | California | 6015 | 1643 | 8 |
1563412 | 1563412 | 2021-07-29 | El Dorado | California | 6017 | 11859 | 120 |
1563413 | 1563413 | 2021-07-29 | Fresno | California | 6019 | 114048 | 1744 |
1563414 | 1563414 | 2021-07-29 | Glenn | California | 6021 | 3064 | 27 |
1563415 | 1563415 | 2021-07-29 | Humboldt | California | 6023 | 5106 | 53 |
1563416 | 1563416 | 2021-07-29 | Imperial | California | 6025 | 32040 | 742 |
1563417 | 1563417 | 2021-07-29 | Inyo | California | 6027 | 1453 | 38 |
1563418 | 1563418 | 2021-07-29 | Kern | California | 6029 | 113071 | 1425 |
1563419 | 1563419 | 2021-07-29 | Kings | California | 6031 | 24773 | 250 |
1563420 | 1563420 | 2021-07-29 | Lake | California | 6033 | 4204 | 65 |
1563421 | 1563421 | 2021-07-29 | Lassen | California | 6035 | 5876 | 26 |
1563422 | 1563422 | 2021-07-29 | Los Angeles | California | 6037 | 1294135 | 24675 |
1563423 | 1563423 | 2021-07-29 | Madera | California | 6039 | 18052 | 249 |
1563424 | 1563424 | 2021-07-29 | Marin | California | 6041 | 14951 | 239 |
1563425 | 1563425 | 2021-07-29 | Mariposa | California | 6043 | 498 | 7 |
1563426 | 1563426 | 2021-07-29 | Mendocino | California | 6045 | 4683 | 51 |
1563427 | 1563427 | 2021-07-29 | Merced | California | 6047 | 32961 | 484 |
1563428 | 1563428 | 2021-07-29 | Modoc | California | 6049 | 573 | 7 |
1563429 | 1563429 | 2021-07-29 | Mono | California | 6051 | 1314 | 5 |
1563430 | 1563430 | 2021-07-29 | Monterey | California | 6053 | 45686 | 528 |
1563431 | 1563431 | 2021-07-29 | Napa | California | 6055 | 10423 | 82 |
1563432 | 1563432 | 2021-07-29 | Nevada | California | 6057 | 5534 | 75 |
1563433 | 1563433 | 2021-07-29 | Orange | California | 6059 | 281790 | 5143 |
1563434 | 1563434 | 2021-07-29 | Placer | California | 6061 | 26894 | 307 |
1563435 | 1563435 | 2021-07-29 | Plumas | California | 6063 | 770 | 6 |
1563436 | 1563436 | 2021-07-29 | Riverside | California | 6065 | 315080 | 4659 |
1563437 | 1563437 | 2021-07-29 | Sacramento | California | 6067 | 117054 | 1777 |
1563438 | 1563438 | 2021-07-29 | San Benito | California | 6069 | 6357 | 63 |
1563439 | 1563439 | 2021-07-29 | San Bernardino | California | 6071 | 309779 | 5236 |
1563440 | 1563440 | 2021-07-29 | San Diego | California | 6073 | 311011 | 3798 |
1563441 | 1563441 | 2021-07-29 | San Francisco | California | 6075 | 41747 | 561 |
1563442 | 1563442 | 2021-07-29 | San Joaquin | California | 6077 | 80433 | 1460 |
1563443 | 1563443 | 2021-07-29 | San Luis Obispo | California | 6079 | 22706 | 265 |
1563444 | 1563444 | 2021-07-29 | San Mateo | California | 6081 | 45049 | 588 |
1563445 | 1563445 | 2021-07-29 | Santa Barbara | California | 6083 | 36847 | 467 |
1563446 | 1563446 | 2021-07-29 | Santa Clara | California | 6085 | 123245 | 2100 |
1563447 | 1563447 | 2021-07-29 | Santa Cruz | California | 6087 | 17436 | 207 |
1563448 | 1563448 | 2021-07-29 | Shasta | California | 6089 | 14848 | 242 |
1563449 | 1563449 | 2021-07-29 | Sierra | California | 6091 | 81 | 0 |
1563450 | 1563450 | 2021-07-29 | Siskiyou | California | 6093 | 2561 | 40 |
1563451 | 1563451 | 2021-07-29 | Solano | California | 6095 | 35925 | 262 |
1563452 | 1563452 | 2021-07-29 | Sonoma | California | 6097 | 32830 | 329 |
1563453 | 1563453 | 2021-07-29 | Stanislaus | California | 6099 | 65537 | 1088 |
1563454 | 1563454 | 2021-07-29 | Sutter | California | 6101 | 10159 | 126 |
1563455 | 1563455 | 2021-07-29 | Tehama | California | 6103 | 5867 | 66 |
1563456 | 1563456 | 2021-07-29 | Trinity | California | 6105 | 424 | 3 |
1563457 | 1563457 | 2021-07-29 | Tulare | California | 6107 | 60441 | 854 |
1563458 | 1563458 | 2021-07-29 | Tuolumne | California | 6109 | 4507 | 73 |
1563459 | 1563459 | 2021-07-29 | Ventura | California | 6111 | 86991 | 1043 |
1563460 | 1563460 | 2021-07-29 | Yolo | California | 6113 | 15281 | 215 |
1563461 | 1563461 | 2021-07-29 | Yuba | California | 6115 | 6985 | 51 |
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);