ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2022-03-03" 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 |
---|---|---|---|---|---|---|---|
2268686 | 2268686 | 2022-03-03 | Alameda | California | 6001 | 265509 | 1768 |
2268687 | 2268687 | 2022-03-03 | Alpine | California | 6003 | 126 | 0 |
2268688 | 2268688 | 2022-03-03 | Amador | California | 6005 | 8994 | 83 |
2268689 | 2268689 | 2022-03-03 | Butte | California | 6007 | 39212 | 372 |
2268690 | 2268690 | 2022-03-03 | Calaveras | California | 6009 | 7579 | 116 |
2268691 | 2268691 | 2022-03-03 | Colusa | California | 6011 | 4503 | 21 |
2268692 | 2268692 | 2022-03-03 | Contra Costa | California | 6013 | 198469 | 1236 |
2268693 | 2268693 | 2022-03-03 | Del Norte | California | 6015 | 6063 | 47 |
2268694 | 2268694 | 2022-03-03 | El Dorado | California | 6017 | 29591 | 192 |
2268695 | 2268695 | 2022-03-03 | Fresno | California | 6019 | 248859 | 2629 |
2268696 | 2268696 | 2022-03-03 | Glenn | California | 6021 | 6459 | 63 |
2268697 | 2268697 | 2022-03-03 | Humboldt | California | 6023 | 19654 | 139 |
2268698 | 2268698 | 2022-03-03 | Imperial | California | 6025 | 65566 | 877 |
2268699 | 2268699 | 2022-03-03 | Inyo | California | 6027 | 4515 | 56 |
2268700 | 2268700 | 2022-03-03 | Kern | California | 6029 | 238866 | 2136 |
2268701 | 2268701 | 2022-03-03 | Kings | California | 6031 | 54397 | 431 |
2268702 | 2268702 | 2022-03-03 | Lake | California | 6033 | 11360 | 130 |
2268703 | 2268703 | 2022-03-03 | Lassen | California | 6035 | 10666 | 67 |
2268704 | 2268704 | 2022-03-03 | Los Angeles | California | 6037 | 2801445 | 30911 |
2268705 | 2268705 | 2022-03-03 | Madera | California | 6039 | 43052 | 354 |
2268706 | 2268706 | 2022-03-03 | Marin | California | 6041 | 34972 | 272 |
2268707 | 2268707 | 2022-03-03 | Mariposa | California | 6043 | 2971 | 26 |
2268708 | 2268708 | 2022-03-03 | Mendocino | California | 6045 | 15745 | 112 |
2268709 | 2268709 | 2022-03-03 | Merced | California | 6047 | 70963 | 794 |
2268710 | 2268710 | 2022-03-03 | Modoc | California | 6049 | 979 | 7 |
2268711 | 2268711 | 2022-03-03 | Mono | California | 6051 | 3080 | 5 |
2268712 | 2268712 | 2022-03-03 | Monterey | California | 6053 | 90986 | 708 |
2268713 | 2268713 | 2022-03-03 | Napa | California | 6055 | 26343 | 134 |
2268714 | 2268714 | 2022-03-03 | Nevada | California | 6057 | 17102 | 122 |
2268715 | 2268715 | 2022-03-03 | Orange | California | 6059 | 582034 | 6643 |
2268716 | 2268716 | 2022-03-03 | Placer | California | 6061 | 69344 | 589 |
2268717 | 2268717 | 2022-03-03 | Plumas | California | 6063 | 3051 | 13 |
2268718 | 2268718 | 2022-03-03 | Riverside | California | 6065 | 614421 | 6285 |
2268719 | 2268719 | 2022-03-03 | Sacramento | California | 6067 | 299984 | 2971 |
2268720 | 2268720 | 2022-03-03 | San Benito | California | 6069 | 13323 | 94 |
2268721 | 2268721 | 2022-03-03 | San Bernardino | California | 6071 | 581062 | 6619 |
2268722 | 2268722 | 2022-03-03 | San Diego | California | 6073 | 788931 | 5034 |
2268723 | 2268723 | 2022-03-03 | San Francisco | California | 6075 | 132028 | 792 |
2268724 | 2268724 | 2022-03-03 | San Joaquin | California | 6077 | 174000 | 2063 |
2268725 | 2268725 | 2022-03-03 | San Luis Obispo | California | 6079 | 55353 | 446 |
2268726 | 2268726 | 2022-03-03 | San Mateo | California | 6081 | 125440 | 711 |
2268727 | 2268727 | 2022-03-03 | Santa Barbara | California | 6083 | 89973 | 655 |
2268728 | 2268728 | 2022-03-03 | Santa Clara | California | 6085 | 319551 | 2185 |
2268729 | 2268729 | 2022-03-03 | Santa Cruz | California | 6087 | 48419 | 253 |
2268730 | 2268730 | 2022-03-03 | Shasta | California | 6089 | 36378 | 559 |
2268731 | 2268731 | 2022-03-03 | Sierra | California | 6091 | 314 | 4 |
2268732 | 2268732 | 2022-03-03 | Siskiyou | California | 6093 | 7319 | 98 |
2268733 | 2268733 | 2022-03-03 | Solano | California | 6095 | 86058 | 433 |
2268734 | 2268734 | 2022-03-03 | Sonoma | California | 6097 | 84275 | 475 |
2268735 | 2268735 | 2022-03-03 | Stanislaus | California | 6099 | 135804 | 1667 |
2268736 | 2268736 | 2022-03-03 | Sutter | California | 6101 | 22300 | 225 |
2268737 | 2268737 | 2022-03-03 | Tehama | California | 6103 | 14512 | 158 |
2268738 | 2268738 | 2022-03-03 | Trinity | California | 6105 | 1453 | 20 |
2268739 | 2268739 | 2022-03-03 | Tulare | California | 6107 | 131458 | 1302 |
2268740 | 2268740 | 2022-03-03 | Tuolumne | California | 6109 | 12963 | 179 |
2268741 | 2268741 | 2022-03-03 | Ventura | California | 6111 | 180962 | 1434 |
2268742 | 2268742 | 2022-03-03 | Yolo | California | 6113 | 38908 | 305 |
2268743 | 2268743 | 2022-03-03 | Yuba | California | 6115 | 17459 | 115 |
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);