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-07-15 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
334823 | 334823 | 2020-07-15 | Alameda | California | 6001 | 8499 | 154 |
334824 | 334824 | 2020-07-15 | Alpine | California | 6003 | 1 | 0 |
334825 | 334825 | 2020-07-15 | Amador | California | 6005 | 46 | 0 |
334826 | 334826 | 2020-07-15 | Butte | California | 6007 | 437 | 4 |
334827 | 334827 | 2020-07-15 | Calaveras | California | 6009 | 75 | 0 |
334828 | 334828 | 2020-07-15 | Colusa | California | 6011 | 140 | 0 |
334829 | 334829 | 2020-07-15 | Contra Costa | California | 6013 | 5140 | 92 |
334830 | 334830 | 2020-07-15 | Del Norte | California | 6015 | 61 | 0 |
334831 | 334831 | 2020-07-15 | El Dorado | California | 6017 | 363 | 0 |
334832 | 334832 | 2020-07-15 | Fresno | California | 6019 | 8941 | 91 |
334833 | 334833 | 2020-07-15 | Glenn | California | 6021 | 177 | 0 |
334834 | 334834 | 2020-07-15 | Humboldt | California | 6023 | 175 | 4 |
334835 | 334835 | 2020-07-15 | Imperial | California | 6025 | 8145 | 147 |
334836 | 334836 | 2020-07-15 | Inyo | California | 6027 | 35 | 1 |
334837 | 334837 | 2020-07-15 | Kern | California | 6029 | 6979 | 98 |
334838 | 334838 | 2020-07-15 | Kings | California | 6031 | 3108 | 41 |
334839 | 334839 | 2020-07-15 | Lake | California | 6033 | 133 | 1 |
334840 | 334840 | 2020-07-15 | Lassen | California | 6035 | 473 | 0 |
334841 | 334841 | 2020-07-15 | Los Angeles | California | 6037 | 143009 | 3936 |
334842 | 334842 | 2020-07-15 | Madera | California | 6039 | 1118 | 10 |
334843 | 334843 | 2020-07-15 | Marin | California | 6041 | 3451 | 40 |
334844 | 334844 | 2020-07-15 | Mariposa | California | 6043 | 35 | 1 |
334845 | 334845 | 2020-07-15 | Mendocino | California | 6045 | 165 | 0 |
334846 | 334846 | 2020-07-15 | Merced | California | 6047 | 2260 | 15 |
334847 | 334847 | 2020-07-15 | Mono | California | 6051 | 54 | 1 |
334848 | 334848 | 2020-07-15 | Monterey | California | 6053 | 2913 | 18 |
334849 | 334849 | 2020-07-15 | Napa | California | 6055 | 558 | 5 |
334850 | 334850 | 2020-07-15 | Nevada | California | 6057 | 185 | 1 |
334851 | 334851 | 2020-07-15 | Orange | California | 6059 | 27031 | 455 |
334852 | 334852 | 2020-07-15 | Placer | California | 6061 | 1167 | 11 |
334853 | 334853 | 2020-07-15 | Plumas | California | 6063 | 14 | 0 |
334854 | 334854 | 2020-07-15 | Riverside | California | 6065 | 27850 | 577 |
334855 | 334855 | 2020-07-15 | Sacramento | California | 6067 | 6173 | 92 |
334856 | 334856 | 2020-07-15 | San Benito | California | 6069 | 408 | 2 |
334857 | 334857 | 2020-07-15 | San Bernardino | California | 6071 | 21468 | 310 |
334858 | 334858 | 2020-07-15 | San Diego | California | 6073 | 21509 | 448 |
334859 | 334859 | 2020-07-15 | San Francisco | California | 6075 | 4699 | 50 |
334860 | 334860 | 2020-07-15 | San Joaquin | California | 6077 | 7428 | 73 |
334861 | 334861 | 2020-07-15 | San Luis Obispo | California | 6079 | 1112 | 6 |
334862 | 334862 | 2020-07-15 | San Mateo | California | 6081 | 4254 | 114 |
334863 | 334863 | 2020-07-15 | Santa Barbara | California | 6083 | 4641 | 32 |
334864 | 334864 | 2020-07-15 | Santa Clara | California | 6085 | 6951 | 174 |
334865 | 334865 | 2020-07-15 | Santa Cruz | California | 6087 | 639 | 3 |
334866 | 334866 | 2020-07-15 | Shasta | California | 6089 | 215 | 6 |
334867 | 334867 | 2020-07-15 | Sierra | California | 6091 | 1 | 0 |
334868 | 334868 | 2020-07-15 | Siskiyou | California | 6093 | 43 | 0 |
334869 | 334869 | 2020-07-15 | Solano | California | 6095 | 2412 | 31 |
334870 | 334870 | 2020-07-15 | Sonoma | California | 6097 | 1979 | 16 |
334871 | 334871 | 2020-07-15 | Stanislaus | California | 6099 | 5631 | 61 |
334872 | 334872 | 2020-07-15 | Sutter | California | 6101 | 454 | 4 |
334873 | 334873 | 2020-07-15 | Tehama | California | 6103 | 123 | 1 |
334874 | 334874 | 2020-07-15 | Trinity | California | 6105 | 3 | 0 |
334875 | 334875 | 2020-07-15 | Tulare | California | 6107 | 6332 | 153 |
334876 | 334876 | 2020-07-15 | Tuolumne | California | 6109 | 80 | 0 |
334877 | 334877 | 2020-07-15 | Ventura | California | 6111 | 4950 | 56 |
334878 | 334878 | 2020-07-15 | Yolo | California | 6113 | 1023 | 30 |
334879 | 334879 | 2020-07-15 | Yuba | California | 6115 | 231 | 3 |
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);