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 2020-08-17 and state = "California" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
440876 | 440876 | 2020-08-17 | Alameda | California | 6001 | 15359 | 221 |
440877 | 440877 | 2020-08-17 | Alpine | California | 6003 | 2 | 0 |
440878 | 440878 | 2020-08-17 | Amador | California | 6005 | 214 | 11 |
440879 | 440879 | 2020-08-17 | Butte | California | 6007 | 1432 | 12 |
440880 | 440880 | 2020-08-17 | Calaveras | California | 6009 | 174 | 1 |
440881 | 440881 | 2020-08-17 | Colusa | California | 6011 | 415 | 5 |
440882 | 440882 | 2020-08-17 | Contra Costa | California | 6013 | 11408 | 157 |
440883 | 440883 | 2020-08-17 | Del Norte | California | 6015 | 108 | 1 |
440884 | 440884 | 2020-08-17 | El Dorado | California | 6017 | 849 | 2 |
440885 | 440885 | 2020-08-17 | Fresno | California | 6019 | 21010 | 203 |
440886 | 440886 | 2020-08-17 | Glenn | California | 6021 | 400 | 3 |
440887 | 440887 | 2020-08-17 | Humboldt | California | 6023 | 320 | 4 |
440888 | 440888 | 2020-08-17 | Imperial | California | 6025 | 10058 | 256 |
440889 | 440889 | 2020-08-17 | Inyo | California | 6027 | 125 | 3 |
440890 | 440890 | 2020-08-17 | Kern | California | 6029 | 26788 | 204 |
440891 | 440891 | 2020-08-17 | Kings | California | 6031 | 5543 | 66 |
440892 | 440892 | 2020-08-17 | Lake | California | 6033 | 269 | 2 |
440893 | 440893 | 2020-08-17 | Lassen | California | 6035 | 703 | 0 |
440894 | 440894 | 2020-08-17 | Los Angeles | California | 6037 | 223131 | 5273 |
440895 | 440895 | 2020-08-17 | Madera | California | 6039 | 3129 | 47 |
440896 | 440896 | 2020-08-17 | Marin | California | 6041 | 5788 | 82 |
440897 | 440897 | 2020-08-17 | Mariposa | California | 6043 | 64 | 2 |
440898 | 440898 | 2020-08-17 | Mendocino | California | 6045 | 556 | 10 |
440899 | 440899 | 2020-08-17 | Merced | California | 6047 | 7041 | 93 |
440900 | 440900 | 2020-08-17 | Modoc | California | 6049 | 5 | 0 |
440901 | 440901 | 2020-08-17 | Mono | California | 6051 | 160 | 1 |
440902 | 440902 | 2020-08-17 | Monterey | California | 6053 | 6548 | 46 |
440903 | 440903 | 2020-08-17 | Napa | California | 6055 | 1246 | 11 |
440904 | 440904 | 2020-08-17 | Nevada | California | 6057 | 385 | 2 |
440905 | 440905 | 2020-08-17 | Orange | California | 6059 | 43925 | 810 |
440906 | 440906 | 2020-08-17 | Placer | California | 6061 | 2625 | 28 |
440907 | 440907 | 2020-08-17 | Plumas | California | 6063 | 33 | 0 |
440908 | 440908 | 2020-08-17 | Riverside | California | 6065 | 47669 | 912 |
440909 | 440909 | 2020-08-17 | Sacramento | California | 6067 | 14325 | 218 |
440910 | 440910 | 2020-08-17 | San Benito | California | 6069 | 848 | 4 |
440911 | 440911 | 2020-08-17 | San Bernardino | California | 6071 | 41724 | 568 |
440912 | 440912 | 2020-08-17 | San Diego | California | 6073 | 35023 | 626 |
440913 | 440913 | 2020-08-17 | San Francisco | California | 6075 | 8349 | 70 |
440914 | 440914 | 2020-08-17 | San Joaquin | California | 6077 | 15288 | 269 |
440915 | 440915 | 2020-08-17 | San Luis Obispo | California | 6079 | 2562 | 19 |
440916 | 440916 | 2020-08-17 | San Mateo | California | 6081 | 7150 | 126 |
440917 | 440917 | 2020-08-17 | Santa Barbara | California | 6083 | 7454 | 80 |
440918 | 440918 | 2020-08-17 | Santa Clara | California | 6085 | 14429 | 210 |
440919 | 440919 | 2020-08-17 | Santa Cruz | California | 6087 | 1454 | 7 |
440920 | 440920 | 2020-08-17 | Shasta | California | 6089 | 508 | 11 |
440921 | 440921 | 2020-08-17 | Sierra | California | 6091 | 6 | 0 |
440922 | 440922 | 2020-08-17 | Siskiyou | California | 6093 | 114 | 0 |
440923 | 440923 | 2020-08-17 | Solano | California | 6095 | 4772 | 41 |
440924 | 440924 | 2020-08-17 | Sonoma | California | 6097 | 4465 | 57 |
440925 | 440925 | 2020-08-17 | Stanislaus | California | 6099 | 12668 | 198 |
440926 | 440926 | 2020-08-17 | Sutter | California | 6101 | 1157 | 7 |
440927 | 440927 | 2020-08-17 | Tehama | California | 6103 | 318 | 1 |
440928 | 440928 | 2020-08-17 | Trinity | California | 6105 | 9 | 0 |
440929 | 440929 | 2020-08-17 | Tulare | California | 6107 | 12451 | 206 |
440930 | 440930 | 2020-08-17 | Tuolumne | California | 6109 | 165 | 2 |
440931 | 440931 | 2020-08-17 | Ventura | California | 6111 | 9408 | 96 |
440932 | 440932 | 2020-08-17 | Yolo | California | 6113 | 2076 | 46 |
440933 | 440933 | 2020-08-17 | Yuba | California | 6115 | 786 | 4 |
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);