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-24 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2437883 | 2437883 | 2022-04-24 | Alameda | California | 6001 | 274059 | 1871 |
2437884 | 2437884 | 2022-04-24 | Alpine | California | 6003 | 125 | 0 |
2437885 | 2437885 | 2022-04-24 | Amador | California | 6005 | 9164 | 86 |
2437886 | 2437886 | 2022-04-24 | Butte | California | 6007 | 39809 | 411 |
2437887 | 2437887 | 2022-04-24 | Calaveras | California | 6009 | 7655 | 119 |
2437888 | 2437888 | 2022-04-24 | Colusa | California | 6011 | 4534 | 21 |
2437889 | 2437889 | 2022-04-24 | Contra Costa | California | 6013 | 204140 | 1298 |
2437890 | 2437890 | 2022-04-24 | Del Norte | California | 6015 | 6258 | 50 |
2437891 | 2437891 | 2022-04-24 | El Dorado | California | 6017 | 30062 | 209 |
2437892 | 2437892 | 2022-04-24 | Fresno | California | 6019 | 255391 | 2744 |
2437893 | 2437893 | 2022-04-24 | Glenn | California | 6021 | 6571 | 67 |
2437894 | 2437894 | 2022-04-24 | Humboldt | California | 6023 | 20214 | 145 |
2437895 | 2437895 | 2022-04-24 | Imperial | California | 6025 | 66879 | 909 |
2437896 | 2437896 | 2022-04-24 | Inyo | California | 6027 | 4584 | 56 |
2437897 | 2437897 | 2022-04-24 | Kern | California | 6029 | 243186 | 2356 |
2437898 | 2437898 | 2022-04-24 | Kings | California | 6031 | 55220 | 444 |
2437899 | 2437899 | 2022-04-24 | Lake | California | 6033 | 11626 | 134 |
2437900 | 2437900 | 2022-04-24 | Lassen | California | 6035 | 10725 | 69 |
2437901 | 2437901 | 2022-04-24 | Los Angeles | California | 6037 | 2860503 | 31924 |
2437902 | 2437902 | 2022-04-24 | Madera | California | 6039 | 43445 | 354 |
2437903 | 2437903 | 2022-04-24 | Marin | California | 6041 | 36787 | 288 |
2437904 | 2437904 | 2022-04-24 | Mariposa | California | 6043 | 3060 | 34 |
2437905 | 2437905 | 2022-04-24 | Mendocino | California | 6045 | 16228 | 122 |
2437906 | 2437906 | 2022-04-24 | Merced | California | 6047 | 72359 | 820 |
2437907 | 2437907 | 2022-04-24 | Modoc | California | 6049 | 998 | 8 |
2437908 | 2437908 | 2022-04-24 | Mono | California | 6051 | 3113 | 6 |
2437909 | 2437909 | 2022-04-24 | Monterey | California | 6053 | 93574 | 737 |
2437910 | 2437910 | 2022-04-24 | Napa | California | 6055 | 27098 | 143 |
2437911 | 2437911 | 2022-04-24 | Nevada | California | 6057 | 17273 | 127 |
2437912 | 2437912 | 2022-04-24 | Orange | California | 6059 | 591778 | 6990 |
2437913 | 2437913 | 2022-04-24 | Placer | California | 6061 | 70490 | 625 |
2437914 | 2437914 | 2022-04-24 | Plumas | California | 6063 | 3299 | 13 |
2437915 | 2437915 | 2022-04-24 | Riverside | California | 6065 | 620999 | 6507 |
2437916 | 2437916 | 2022-04-24 | Sacramento | California | 6067 | 307868 | 3129 |
2437917 | 2437917 | 2022-04-24 | San Benito | California | 6069 | 13488 | 98 |
2437918 | 2437918 | 2022-04-24 | San Bernardino | California | 6071 | 591785 | 7047 |
2437919 | 2437919 | 2022-04-24 | San Diego | California | 6073 | 810904 | 5233 |
2437920 | 2437920 | 2022-04-24 | San Francisco | California | 6075 | 136855 | 857 |
2437921 | 2437921 | 2022-04-24 | San Joaquin | California | 6077 | 176137 | 2224 |
2437922 | 2437922 | 2022-04-24 | San Luis Obispo | California | 6079 | 56663 | 476 |
2437923 | 2437923 | 2022-04-24 | San Mateo | California | 6081 | 131329 | 754 |
2437924 | 2437924 | 2022-04-24 | Santa Barbara | California | 6083 | 91261 | 685 |
2437925 | 2437925 | 2022-04-24 | Santa Clara | California | 6085 | 330184 | 2278 |
2437926 | 2437926 | 2022-04-24 | Santa Cruz | California | 6087 | 50442 | 261 |
2437927 | 2437927 | 2022-04-24 | Shasta | California | 6089 | 36776 | 626 |
2437928 | 2437928 | 2022-04-24 | Sierra | California | 6091 | 324 | 4 |
2437929 | 2437929 | 2022-04-24 | Siskiyou | California | 6093 | 7441 | 105 |
2437930 | 2437930 | 2022-04-24 | Solano | California | 6095 | 87580 | 448 |
2437931 | 2437931 | 2022-04-24 | Sonoma | California | 6097 | 87282 | 489 |
2437932 | 2437932 | 2022-04-24 | Stanislaus | California | 6099 | 136645 | 1694 |
2437933 | 2437933 | 2022-04-24 | Sutter | California | 6101 | 22854 | 233 |
2437934 | 2437934 | 2022-04-24 | Tehama | California | 6103 | 14696 | 201 |
2437935 | 2437935 | 2022-04-24 | Trinity | California | 6105 | 1473 | 20 |
2437936 | 2437936 | 2022-04-24 | Tulare | California | 6107 | 135110 | 1446 |
2437937 | 2437937 | 2022-04-24 | Tuolumne | California | 6109 | 13520 | 181 |
2437938 | 2437938 | 2022-04-24 | Ventura | California | 6111 | 183430 | 1482 |
2437939 | 2437939 | 2022-04-24 | Yolo | California | 6113 | 40225 | 314 |
2437940 | 2437940 | 2022-04-24 | Yuba | California | 6115 | 17754 | 121 |
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);