ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where date = "2020-05-29" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
187826 | 187826 | 2020-05-29 | Alameda | California | 6001 | 3216 | 102 |
187827 | 187827 | 2020-05-29 | Alpine | California | 6003 | 2 | 0 |
187828 | 187828 | 2020-05-29 | Amador | California | 6005 | 10 | 0 |
187829 | 187829 | 2020-05-29 | Butte | California | 6007 | 44 | 0 |
187830 | 187830 | 2020-05-29 | Calaveras | California | 6009 | 15 | 0 |
187831 | 187831 | 2020-05-29 | Colusa | California | 6011 | 5 | 0 |
187832 | 187832 | 2020-05-29 | Contra Costa | California | 6013 | 1404 | 37 |
187833 | 187833 | 2020-05-29 | Del Norte | California | 6015 | 45 | 0 |
187834 | 187834 | 2020-05-29 | El Dorado | California | 6017 | 90 | 0 |
187835 | 187835 | 2020-05-29 | Fresno | California | 6019 | 1714 | 35 |
187836 | 187836 | 2020-05-29 | Glenn | California | 6021 | 16 | 0 |
187837 | 187837 | 2020-05-29 | Humboldt | California | 6023 | 99 | 3 |
187838 | 187838 | 2020-05-29 | Imperial | California | 6025 | 1634 | 26 |
187839 | 187839 | 2020-05-29 | Inyo | California | 6027 | 20 | 1 |
187840 | 187840 | 2020-05-29 | Kern | California | 6029 | 2086 | 37 |
187841 | 187841 | 2020-05-29 | Kings | California | 6031 | 714 | 3 |
187842 | 187842 | 2020-05-29 | Lake | California | 6033 | 23 | 0 |
187843 | 187843 | 2020-05-29 | Lassen | California | 6035 | 5 | 0 |
187844 | 187844 | 2020-05-29 | Los Angeles | California | 6037 | 51562 | 2290 |
187845 | 187845 | 2020-05-29 | Madera | California | 6039 | 104 | 2 |
187846 | 187846 | 2020-05-29 | Marin | California | 6041 | 450 | 14 |
187847 | 187847 | 2020-05-29 | Mariposa | California | 6043 | 16 | 1 |
187848 | 187848 | 2020-05-29 | Mendocino | California | 6045 | 30 | 0 |
187849 | 187849 | 2020-05-29 | Merced | California | 6047 | 283 | 7 |
187850 | 187850 | 2020-05-29 | Mono | California | 6051 | 35 | 1 |
187851 | 187851 | 2020-05-29 | Monterey | California | 6053 | 477 | 10 |
187852 | 187852 | 2020-05-29 | Napa | California | 6055 | 114 | 3 |
187853 | 187853 | 2020-05-29 | Nevada | California | 6057 | 41 | 1 |
187854 | 187854 | 2020-05-29 | Orange | California | 6059 | 6045 | 145 |
187855 | 187855 | 2020-05-29 | Placer | California | 6061 | 199 | 9 |
187856 | 187856 | 2020-05-29 | Plumas | California | 6063 | 4 | 0 |
187857 | 187857 | 2020-05-29 | Riverside | California | 6065 | 7486 | 331 |
187858 | 187858 | 2020-05-29 | Sacramento | California | 6067 | 1372 | 57 |
187859 | 187859 | 2020-05-29 | San Benito | California | 6069 | 87 | 2 |
187860 | 187860 | 2020-05-29 | San Bernardino | California | 6071 | 5034 | 199 |
187861 | 187861 | 2020-05-29 | San Diego | California | 6073 | 7303 | 307 |
187862 | 187862 | 2020-05-29 | San Francisco | California | 6075 | 2476 | 41 |
187863 | 187863 | 2020-05-29 | San Joaquin | California | 6077 | 858 | 35 |
187864 | 187864 | 2020-05-29 | San Luis Obispo | California | 6079 | 269 | 1 |
187865 | 187865 | 2020-05-29 | San Mateo | California | 6081 | 2070 | 84 |
187866 | 187866 | 2020-05-29 | Santa Barbara | California | 6083 | 1642 | 12 |
187867 | 187867 | 2020-05-29 | Santa Clara | California | 6085 | 2707 | 142 |
187868 | 187868 | 2020-05-29 | Santa Cruz | California | 6087 | 205 | 3 |
187869 | 187869 | 2020-05-29 | Shasta | California | 6089 | 37 | 4 |
187870 | 187870 | 2020-05-29 | Sierra | California | 6091 | 1 | 0 |
187871 | 187871 | 2020-05-29 | Siskiyou | California | 6093 | 7 | 0 |
187872 | 187872 | 2020-05-29 | Solano | California | 6095 | 522 | 22 |
187873 | 187873 | 2020-05-29 | Sonoma | California | 6097 | 548 | 4 |
187874 | 187874 | 2020-05-29 | Stanislaus | California | 6099 | 699 | 28 |
187875 | 187875 | 2020-05-29 | Sutter | California | 6101 | 42 | 2 |
187876 | 187876 | 2020-05-29 | Tehama | California | 6103 | 4 | 1 |
187877 | 187877 | 2020-05-29 | Trinity | California | 6105 | 2 | 0 |
187878 | 187878 | 2020-05-29 | Tulare | California | 6107 | 1844 | 84 |
187879 | 187879 | 2020-05-29 | Tuolumne | California | 6109 | 4 | 0 |
187880 | 187880 | 2020-05-29 | Ventura | California | 6111 | 1083 | 33 |
187881 | 187881 | 2020-05-29 | Yolo | California | 6113 | 210 | 24 |
187882 | 187882 | 2020-05-29 | Yuba | California | 6115 | 29 | 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);