ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where "date" is on date 2020-06-11 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips 57
- 6001 1
- 6003 1
- 6005 1
- 6007 1
- 6009 1
- 6011 1
- 6013 1
- 6015 1
- 6017 1
- 6019 1
- 6021 1
- 6023 1
- 6025 1
- 6027 1
- 6029 1
- 6031 1
- 6033 1
- 6035 1
- 6037 1
- 6039 1
- 6041 1
- 6043 1
- 6045 1
- 6047 1
- 6051 1
- 6053 1
- 6055 1
- 6057 1
- 6059 1
- 6061 1
- 6063 1
- 6065 1
- 6067 1
- 6069 1
- 6071 1
- 6073 1
- 6075 1
- 6077 1
- 6079 1
- 6081 1
- 6083 1
- 6085 1
- 6087 1
- 6089 1
- 6091 1
- 6093 1
- 6095 1
- 6097 1
- 6099 1
- 6101 1
- 6103 1
- 6105 1
- 6107 1
- 6109 1
- 6111 1
- 6113 1
- 6115 1
county 57
- Alameda 1
- Alpine 1
- Amador 1
- Butte 1
- Calaveras 1
- Colusa 1
- Contra Costa 1
- Del Norte 1
- El Dorado 1
- Fresno 1
- Glenn 1
- Humboldt 1
- Imperial 1
- Inyo 1
- Kern 1
- Kings 1
- Lake 1
- Lassen 1
- Los Angeles 1
- Madera 1
- Marin 1
- Mariposa 1
- Mendocino 1
- Merced 1
- Mono 1
- Monterey 1
- Napa 1
- Nevada 1
- Orange 1
- Placer 1
- Plumas 1
- Riverside 1
- Sacramento 1
- San Benito 1
- San Bernardino 1
- San Diego 1
- San Francisco 1
- San Joaquin 1
- San Luis Obispo 1
- San Mateo 1
- Santa Barbara 1
- Santa Clara 1
- Santa Cruz 1
- Shasta 1
- Sierra 1
- Siskiyou 1
- Solano 1
- Sonoma 1
- Stanislaus 1
- Sutter 1
- Tehama 1
- Trinity 1
- Tulare 1
- Tuolumne 1
- Ventura 1
- Yolo 1
- Yuba 1
state 1
- California · 57 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
227893 | 227893 | 2020-06-11 | Alameda | California | 6001 | 4140 | 110 |
227894 | 227894 | 2020-06-11 | Alpine | California | 6003 | 2 | 0 |
227895 | 227895 | 2020-06-11 | Amador | California | 6005 | 9 | 0 |
227896 | 227896 | 2020-06-11 | Butte | California | 6007 | 73 | 1 |
227897 | 227897 | 2020-06-11 | Calaveras | California | 6009 | 25 | 0 |
227898 | 227898 | 2020-06-11 | Colusa | California | 6011 | 7 | 0 |
227899 | 227899 | 2020-06-11 | Contra Costa | California | 6013 | 1829 | 44 |
227900 | 227900 | 2020-06-11 | Del Norte | California | 6015 | 47 | 0 |
227901 | 227901 | 2020-06-11 | El Dorado | California | 6017 | 111 | 0 |
227902 | 227902 | 2020-06-11 | Fresno | California | 6019 | 2395 | 51 |
227903 | 227903 | 2020-06-11 | Glenn | California | 6021 | 24 | 0 |
227904 | 227904 | 2020-06-11 | Humboldt | California | 6023 | 112 | 4 |
227905 | 227905 | 2020-06-11 | Imperial | California | 6025 | 3454 | 42 |
227906 | 227906 | 2020-06-11 | Inyo | California | 6027 | 23 | 1 |
227907 | 227907 | 2020-06-11 | Kern | California | 6029 | 3026 | 53 |
227908 | 227908 | 2020-06-11 | Kings | California | 6031 | 1688 | 6 |
227909 | 227909 | 2020-06-11 | Lake | California | 6033 | 30 | 0 |
227910 | 227910 | 2020-06-11 | Lassen | California | 6035 | 9 | 0 |
227911 | 227911 | 2020-06-11 | Los Angeles | California | 6037 | 68875 | 2813 |
227912 | 227912 | 2020-06-11 | Madera | California | 6039 | 188 | 3 |
227913 | 227913 | 2020-06-11 | Marin | California | 6041 | 664 | 17 |
227914 | 227914 | 2020-06-11 | Mariposa | California | 6043 | 16 | 1 |
227915 | 227915 | 2020-06-11 | Mendocino | California | 6045 | 36 | 0 |
227916 | 227916 | 2020-06-11 | Merced | California | 6047 | 391 | 7 |
227917 | 227917 | 2020-06-11 | Mono | California | 6051 | 37 | 1 |
227918 | 227918 | 2020-06-11 | Monterey | California | 6053 | 814 | 11 |
227919 | 227919 | 2020-06-11 | Napa | California | 6055 | 164 | 3 |
227920 | 227920 | 2020-06-11 | Nevada | California | 6057 | 52 | 1 |
227921 | 227921 | 2020-06-11 | Orange | California | 6059 | 8222 | 202 |
227922 | 227922 | 2020-06-11 | Placer | California | 6061 | 327 | 9 |
227923 | 227923 | 2020-06-11 | Plumas | California | 6063 | 4 | 0 |
227924 | 227924 | 2020-06-11 | Riverside | California | 6065 | 10240 | 380 |
227925 | 227925 | 2020-06-11 | Sacramento | California | 6067 | 1669 | 63 |
227926 | 227926 | 2020-06-11 | San Benito | California | 6069 | 112 | 2 |
227927 | 227927 | 2020-06-11 | San Bernardino | California | 6071 | 6742 | 227 |
227928 | 227928 | 2020-06-11 | San Diego | California | 6073 | 9061 | 312 |
227929 | 227929 | 2020-06-11 | San Francisco | California | 6075 | 2843 | 44 |
227930 | 227930 | 2020-06-11 | San Joaquin | California | 6077 | 1437 | 42 |
227931 | 227931 | 2020-06-11 | San Luis Obispo | California | 6079 | 317 | 1 |
227932 | 227932 | 2020-06-11 | San Mateo | California | 6081 | 2494 | 93 |
227933 | 227933 | 2020-06-11 | Santa Barbara | California | 6083 | 1899 | 16 |
227934 | 227934 | 2020-06-11 | Santa Clara | California | 6085 | 3063 | 150 |
227935 | 227935 | 2020-06-11 | Santa Cruz | California | 6087 | 249 | 3 |
227936 | 227936 | 2020-06-11 | Shasta | California | 6089 | 48 | 4 |
227937 | 227937 | 2020-06-11 | Sierra | California | 6091 | 1 | 0 |
227938 | 227938 | 2020-06-11 | Siskiyou | California | 6093 | 14 | 0 |
227939 | 227939 | 2020-06-11 | Solano | California | 6095 | 648 | 23 |
227940 | 227940 | 2020-06-11 | Sonoma | California | 6097 | 701 | 4 |
227941 | 227941 | 2020-06-11 | Stanislaus | California | 6099 | 1072 | 33 |
227942 | 227942 | 2020-06-11 | Sutter | California | 6101 | 69 | 2 |
227943 | 227943 | 2020-06-11 | Tehama | California | 6103 | 10 | 1 |
227944 | 227944 | 2020-06-11 | Trinity | California | 6105 | 3 | 0 |
227945 | 227945 | 2020-06-11 | Tulare | California | 6107 | 2475 | 98 |
227946 | 227946 | 2020-06-11 | Tuolumne | California | 6109 | 8 | 0 |
227947 | 227947 | 2020-06-11 | Ventura | California | 6111 | 1466 | 38 |
227948 | 227948 | 2020-06-11 | Yolo | California | 6113 | 240 | 24 |
227949 | 227949 | 2020-06-11 | Yuba | California | 6115 | 34 | 1 |
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);