ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2022-02-06" 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 |
---|---|---|---|---|---|---|---|
2187391 | 2187391 | 2022-02-06 | Alameda | California | 6001 | 250786 | 1652 |
2187392 | 2187392 | 2022-02-06 | Alpine | California | 6003 | 125 | 0 |
2187393 | 2187393 | 2022-02-06 | Amador | California | 6005 | 8448 | 73 |
2187394 | 2187394 | 2022-02-06 | Butte | California | 6007 | 36926 | 355 |
2187395 | 2187395 | 2022-02-06 | Calaveras | California | 6009 | 7155 | 99 |
2187396 | 2187396 | 2022-02-06 | Colusa | California | 6011 | 4199 | 21 |
2187397 | 2187397 | 2022-02-06 | Contra Costa | California | 6013 | 188700 | 1115 |
2187398 | 2187398 | 2022-02-06 | Del Norte | California | 6015 | 5312 | 44 |
2187399 | 2187399 | 2022-02-06 | El Dorado | California | 6017 | 27839 | 185 |
2187400 | 2187400 | 2022-02-06 | Fresno | California | 6019 | 233258 | 2477 |
2187401 | 2187401 | 2022-02-06 | Glenn | California | 6021 | 6161 | 58 |
2187402 | 2187402 | 2022-02-06 | Humboldt | California | 6023 | 18191 | 132 |
2187403 | 2187403 | 2022-02-06 | Imperial | California | 6025 | 61631 | 852 |
2187404 | 2187404 | 2022-02-06 | Inyo | California | 6027 | 4407 | 51 |
2187405 | 2187405 | 2022-02-06 | Kern | California | 6029 | 220089 | 2031 |
2187406 | 2187406 | 2022-02-06 | Kings | California | 6031 | 50719 | 402 |
2187407 | 2187407 | 2022-02-06 | Lake | California | 6033 | 10236 | 124 |
2187408 | 2187408 | 2022-02-06 | Lassen | California | 6035 | 9919 | 62 |
2187409 | 2187409 | 2022-02-06 | Los Angeles | California | 6037 | 2727863 | 29428 |
2187410 | 2187410 | 2022-02-06 | Madera | California | 6039 | 39854 | 339 |
2187411 | 2187411 | 2022-02-06 | Marin | California | 6041 | 34743 | 255 |
2187412 | 2187412 | 2022-02-06 | Mariposa | California | 6043 | 2728 | 20 |
2187413 | 2187413 | 2022-02-06 | Mendocino | California | 6045 | 14606 | 117 |
2187414 | 2187414 | 2022-02-06 | Merced | California | 6047 | 66051 | 752 |
2187415 | 2187415 | 2022-02-06 | Modoc | California | 6049 | 900 | 6 |
2187416 | 2187416 | 2022-02-06 | Mono | California | 6051 | 3019 | 5 |
2187417 | 2187417 | 2022-02-06 | Monterey | California | 6053 | 85075 | 676 |
2187418 | 2187418 | 2022-02-06 | Napa | California | 6055 | 23884 | 118 |
2187419 | 2187419 | 2022-02-06 | Nevada | California | 6057 | 16168 | 113 |
2187420 | 2187420 | 2022-02-06 | Orange | California | 6059 | 567058 | 6152 |
2187421 | 2187421 | 2022-02-06 | Placer | California | 6061 | 66066 | 536 |
2187422 | 2187422 | 2022-02-06 | Plumas | California | 6063 | 2891 | 13 |
2187423 | 2187423 | 2022-02-06 | Riverside | California | 6065 | 591645 | 5941 |
2187424 | 2187424 | 2022-02-06 | Sacramento | California | 6067 | 285282 | 2728 |
2187425 | 2187425 | 2022-02-06 | San Benito | California | 6069 | 12717 | 90 |
2187426 | 2187426 | 2022-02-06 | San Bernardino | California | 6071 | 563145 | 6322 |
2187427 | 2187427 | 2022-02-06 | San Diego | California | 6073 | 749616 | 4735 |
2187428 | 2187428 | 2022-02-06 | San Francisco | California | 6075 | 124593 | 720 |
2187429 | 2187429 | 2022-02-06 | San Joaquin | California | 6077 | 166949 | 1989 |
2187430 | 2187430 | 2022-02-06 | San Luis Obispo | California | 6079 | 52027 | 404 |
2187431 | 2187431 | 2022-02-06 | San Mateo | California | 6081 | 119836 | 665 |
2187432 | 2187432 | 2022-02-06 | Santa Barbara | California | 6083 | 84898 | 619 |
2187433 | 2187433 | 2022-02-06 | Santa Clara | California | 6085 | 302139 | 2068 |
2187434 | 2187434 | 2022-02-06 | Santa Cruz | California | 6087 | 44630 | 239 |
2187435 | 2187435 | 2022-02-06 | Shasta | California | 6089 | 34556 | 529 |
2187436 | 2187436 | 2022-02-06 | Sierra | California | 6091 | 306 | 0 |
2187437 | 2187437 | 2022-02-06 | Siskiyou | California | 6093 | 6867 | 90 |
2187438 | 2187438 | 2022-02-06 | Solano | California | 6095 | 78296 | 415 |
2187439 | 2187439 | 2022-02-06 | Sonoma | California | 6097 | 79358 | 448 |
2187440 | 2187440 | 2022-02-06 | Stanislaus | California | 6099 | 129167 | 1565 |
2187441 | 2187441 | 2022-02-06 | Sutter | California | 6101 | 21075 | 211 |
2187442 | 2187442 | 2022-02-06 | Tehama | California | 6103 | 13740 | 146 |
2187443 | 2187443 | 2022-02-06 | Trinity | California | 6105 | 1356 | 20 |
2187444 | 2187444 | 2022-02-06 | Tulare | California | 6107 | 123838 | 1256 |
2187445 | 2187445 | 2022-02-06 | Tuolumne | California | 6109 | 12202 | 163 |
2187446 | 2187446 | 2022-02-06 | Ventura | California | 6111 | 174788 | 1322 |
2187447 | 2187447 | 2022-02-06 | Yolo | California | 6113 | 36798 | 281 |
2187448 | 2187448 | 2022-02-06 | Yuba | California | 6115 | 16529 | 105 |
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);