ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where "date" is on date 2020-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 |
---|---|---|---|---|---|---|---|
30906 | 30906 | 2020-04-04 | Alameda | California | 6001 | 464 | 12 |
30907 | 30907 | 2020-04-04 | Alpine | California | 6003 | 1 | 0 |
30908 | 30908 | 2020-04-04 | Amador | California | 6005 | 2 | 0 |
30909 | 30909 | 2020-04-04 | Butte | California | 6007 | 11 | 0 |
30910 | 30910 | 2020-04-04 | Calaveras | California | 6009 | 4 | 0 |
30911 | 30911 | 2020-04-04 | Colusa | California | 6011 | 2 | 0 |
30912 | 30912 | 2020-04-04 | Contra Costa | California | 6013 | 353 | 5 |
30913 | 30913 | 2020-04-04 | Del Norte | California | 6015 | 2 | 0 |
30914 | 30914 | 2020-04-04 | El Dorado | California | 6017 | 22 | 0 |
30915 | 30915 | 2020-04-04 | Fresno | California | 6019 | 103 | 1 |
30916 | 30916 | 2020-04-04 | Glenn | California | 6021 | 2 | 0 |
30917 | 30917 | 2020-04-04 | Humboldt | California | 6023 | 44 | 0 |
30918 | 30918 | 2020-04-04 | Imperial | California | 6025 | 55 | 0 |
30919 | 30919 | 2020-04-04 | Inyo | California | 6027 | 10 | 0 |
30920 | 30920 | 2020-04-04 | Kern | California | 6029 | 205 | 2 |
30921 | 30921 | 2020-04-04 | Kings | California | 6031 | 5 | 0 |
30922 | 30922 | 2020-04-04 | Los Angeles | California | 6037 | 5277 | 117 |
30923 | 30923 | 2020-04-04 | Madera | California | 6039 | 30 | 2 |
30924 | 30924 | 2020-04-04 | Marin | California | 6041 | 137 | 7 |
30925 | 30925 | 2020-04-04 | Mendocino | California | 6045 | 4 | 0 |
30926 | 30926 | 2020-04-04 | Merced | California | 6047 | 16 | 0 |
30927 | 30927 | 2020-04-04 | Mono | California | 6051 | 19 | 1 |
30928 | 30928 | 2020-04-04 | Monterey | California | 6053 | 62 | 2 |
30929 | 30929 | 2020-04-04 | Napa | California | 6055 | 21 | 2 |
30930 | 30930 | 2020-04-04 | Nevada | California | 6057 | 31 | 1 |
30931 | 30931 | 2020-04-04 | Orange | California | 6059 | 786 | 14 |
30932 | 30932 | 2020-04-04 | Placer | California | 6061 | 97 | 2 |
30933 | 30933 | 2020-04-04 | Plumas | California | 6063 | 3 | 0 |
30934 | 30934 | 2020-04-04 | Riverside | California | 6065 | 665 | 18 |
30935 | 30935 | 2020-04-04 | Sacramento | California | 6067 | 411 | 12 |
30936 | 30936 | 2020-04-04 | San Benito | California | 6069 | 23 | 2 |
30937 | 30937 | 2020-04-04 | San Bernardino | California | 6071 | 353 | 13 |
30938 | 30938 | 2020-04-04 | San Diego | California | 6073 | 1209 | 18 |
30939 | 30939 | 2020-04-04 | San Francisco | California | 6075 | 529 | 8 |
30940 | 30940 | 2020-04-04 | San Joaquin | California | 6077 | 191 | 11 |
30941 | 30941 | 2020-04-04 | San Luis Obispo | California | 6079 | 93 | 1 |
30942 | 30942 | 2020-04-04 | San Mateo | California | 6081 | 538 | 13 |
30943 | 30943 | 2020-04-04 | Santa Barbara | California | 6083 | 168 | 1 |
30944 | 30944 | 2020-04-04 | Santa Clara | California | 6085 | 1148 | 40 |
30945 | 30945 | 2020-04-04 | Santa Cruz | California | 6087 | 62 | 1 |
30946 | 30946 | 2020-04-04 | Shasta | California | 6089 | 17 | 2 |
30947 | 30947 | 2020-04-04 | Siskiyou | California | 6093 | 3 | 0 |
30948 | 30948 | 2020-04-04 | Solano | California | 6095 | 78 | 1 |
30949 | 30949 | 2020-04-04 | Sonoma | California | 6097 | 105 | 1 |
30950 | 30950 | 2020-04-04 | Stanislaus | California | 6099 | 65 | 0 |
30951 | 30951 | 2020-04-04 | Sutter | California | 6101 | 16 | 1 |
30952 | 30952 | 2020-04-04 | Tehama | California | 6103 | 1 | 0 |
30953 | 30953 | 2020-04-04 | Tulare | California | 6107 | 107 | 5 |
30954 | 30954 | 2020-04-04 | Tuolumne | California | 6109 | 1 | 0 |
30955 | 30955 | 2020-04-04 | Ventura | California | 6111 | 203 | 6 |
30956 | 30956 | 2020-04-04 | Yolo | California | 6113 | 33 | 1 |
30957 | 30957 | 2020-04-04 | Yuba | California | 6115 | 9 | 0 |
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);