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 2022-04-04 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2372775 | 2372775 | 2022-04-04 | Alameda | California | 6001 | 269551 | 1830 |
2372776 | 2372776 | 2022-04-04 | Alpine | California | 6003 | 125 | 0 |
2372777 | 2372777 | 2022-04-04 | Amador | California | 6005 | 9131 | 86 |
2372778 | 2372778 | 2022-04-04 | Butte | California | 6007 | 39643 | 396 |
2372779 | 2372779 | 2022-04-04 | Calaveras | California | 6009 | 7610 | 119 |
2372780 | 2372780 | 2022-04-04 | Colusa | California | 6011 | 4525 | 21 |
2372781 | 2372781 | 2022-04-04 | Contra Costa | California | 6013 | 201921 | 1291 |
2372782 | 2372782 | 2022-04-04 | Del Norte | California | 6015 | 6214 | 50 |
2372783 | 2372783 | 2022-04-04 | El Dorado | California | 6017 | 29944 | 200 |
2372784 | 2372784 | 2022-04-04 | Fresno | California | 6019 | 253293 | 2722 |
2372785 | 2372785 | 2022-04-04 | Glenn | California | 6021 | 6559 | 66 |
2372786 | 2372786 | 2022-04-04 | Humboldt | California | 6023 | 20002 | 140 |
2372787 | 2372787 | 2022-04-04 | Imperial | California | 6025 | 66394 | 907 |
2372788 | 2372788 | 2022-04-04 | Inyo | California | 6027 | 4547 | 56 |
2372789 | 2372789 | 2022-04-04 | Kern | California | 6029 | 242458 | 2294 |
2372790 | 2372790 | 2022-04-04 | Kings | California | 6031 | 55094 | 443 |
2372791 | 2372791 | 2022-04-04 | Lake | California | 6033 | 11572 | 136 |
2372792 | 2372792 | 2022-04-04 | Lassen | California | 6035 | 10714 | 69 |
2372793 | 2372793 | 2022-04-04 | Los Angeles | California | 6037 | 2837309 | 31710 |
2372794 | 2372794 | 2022-04-04 | Madera | California | 6039 | 43400 | 354 |
2372795 | 2372795 | 2022-04-04 | Marin | California | 6041 | 35743 | 287 |
2372796 | 2372796 | 2022-04-04 | Mariposa | California | 6043 | 3015 | 33 |
2372797 | 2372797 | 2022-04-04 | Mendocino | California | 6045 | 16052 | 119 |
2372798 | 2372798 | 2022-04-04 | Merced | California | 6047 | 72027 | 813 |
2372799 | 2372799 | 2022-04-04 | Modoc | California | 6049 | 993 | 8 |
2372800 | 2372800 | 2022-04-04 | Mono | California | 6051 | 3089 | 6 |
2372801 | 2372801 | 2022-04-04 | Monterey | California | 6053 | 92730 | 733 |
2372802 | 2372802 | 2022-04-04 | Napa | California | 6055 | 26726 | 143 |
2372803 | 2372803 | 2022-04-04 | Nevada | California | 6057 | 17176 | 123 |
2372804 | 2372804 | 2022-04-04 | Orange | California | 6059 | 587408 | 6891 |
2372805 | 2372805 | 2022-04-04 | Placer | California | 6061 | 70097 | 614 |
2372806 | 2372806 | 2022-04-04 | Plumas | California | 6063 | 3163 | 14 |
2372807 | 2372807 | 2022-04-04 | Riverside | California | 6065 | 618706 | 6474 |
2372808 | 2372808 | 2022-04-04 | Sacramento | California | 6067 | 303101 | 3080 |
2372809 | 2372809 | 2022-04-04 | San Benito | California | 6069 | 13421 | 98 |
2372810 | 2372810 | 2022-04-04 | San Bernardino | California | 6071 | 586037 | 6865 |
2372811 | 2372811 | 2022-04-04 | San Diego | California | 6073 | 803862 | 5178 |
2372812 | 2372812 | 2022-04-04 | San Francisco | California | 6075 | 133484 | 843 |
2372813 | 2372813 | 2022-04-04 | San Joaquin | California | 6077 | 175524 | 2202 |
2372814 | 2372814 | 2022-04-04 | San Luis Obispo | California | 6079 | 56292 | 475 |
2372815 | 2372815 | 2022-04-04 | San Mateo | California | 6081 | 127776 | 745 |
2372816 | 2372816 | 2022-04-04 | Santa Barbara | California | 6083 | 90453 | 678 |
2372817 | 2372817 | 2022-04-04 | Santa Clara | California | 6085 | 324974 | 2259 |
2372818 | 2372818 | 2022-04-04 | Santa Cruz | California | 6087 | 49458 | 259 |
2372819 | 2372819 | 2022-04-04 | Shasta | California | 6089 | 36737 | 610 |
2372820 | 2372820 | 2022-04-04 | Sierra | California | 6091 | 315 | 4 |
2372821 | 2372821 | 2022-04-04 | Siskiyou | California | 6093 | 7413 | 105 |
2372822 | 2372822 | 2022-04-04 | Solano | California | 6095 | 87401 | 446 |
2372823 | 2372823 | 2022-04-04 | Sonoma | California | 6097 | 85756 | 487 |
2372824 | 2372824 | 2022-04-04 | Stanislaus | California | 6099 | 136645 | 1694 |
2372825 | 2372825 | 2022-04-04 | Sutter | California | 6101 | 22672 | 231 |
2372826 | 2372826 | 2022-04-04 | Tehama | California | 6103 | 14652 | 198 |
2372827 | 2372827 | 2022-04-04 | Trinity | California | 6105 | 1466 | 20 |
2372828 | 2372828 | 2022-04-04 | Tulare | California | 6107 | 133169 | 1412 |
2372829 | 2372829 | 2022-04-04 | Tuolumne | California | 6109 | 13463 | 181 |
2372830 | 2372830 | 2022-04-04 | Ventura | California | 6111 | 182326 | 1469 |
2372831 | 2372831 | 2022-04-04 | Yolo | California | 6113 | 39542 | 313 |
2372832 | 2372832 | 2022-04-04 | Yuba | California | 6115 | 17674 | 120 |
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);