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-09-03 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
495794 | 495794 | 2020-09-03 | Alameda | California | 6001 | 18873 | 295 |
495795 | 495795 | 2020-09-03 | Alpine | California | 6003 | 2 | 0 |
495796 | 495796 | 2020-09-03 | Amador | California | 6005 | 244 | 15 |
495797 | 495797 | 2020-09-03 | Butte | California | 6007 | 2254 | 23 |
495798 | 495798 | 2020-09-03 | Calaveras | California | 6009 | 257 | 2 |
495799 | 495799 | 2020-09-03 | Colusa | California | 6011 | 467 | 6 |
495800 | 495800 | 2020-09-03 | Contra Costa | California | 6013 | 14212 | 183 |
495801 | 495801 | 2020-09-03 | Del Norte | California | 6015 | 124 | 1 |
495802 | 495802 | 2020-09-03 | El Dorado | California | 6017 | 988 | 2 |
495803 | 495803 | 2020-09-03 | Fresno | California | 6019 | 25785 | 290 |
495804 | 495804 | 2020-09-03 | Glenn | California | 6021 | 457 | 3 |
495805 | 495805 | 2020-09-03 | Humboldt | California | 6023 | 403 | 4 |
495806 | 495806 | 2020-09-03 | Imperial | California | 6025 | 10773 | 295 |
495807 | 495807 | 2020-09-03 | Inyo | California | 6027 | 171 | 14 |
495808 | 495808 | 2020-09-03 | Kern | California | 6029 | 29763 | 296 |
495809 | 495809 | 2020-09-03 | Kings | California | 6031 | 6426 | 76 |
495810 | 495810 | 2020-09-03 | Lake | California | 6033 | 342 | 5 |
495811 | 495811 | 2020-09-03 | Lassen | California | 6035 | 715 | 0 |
495812 | 495812 | 2020-09-03 | Los Angeles | California | 6037 | 244999 | 5932 |
495813 | 495813 | 2020-09-03 | Madera | California | 6039 | 3889 | 57 |
495814 | 495814 | 2020-09-03 | Marin | California | 6041 | 6285 | 96 |
495815 | 495815 | 2020-09-03 | Mariposa | California | 6043 | 74 | 2 |
495816 | 495816 | 2020-09-03 | Mendocino | California | 6045 | 724 | 17 |
495817 | 495817 | 2020-09-03 | Merced | California | 6047 | 8202 | 120 |
495818 | 495818 | 2020-09-03 | Modoc | California | 6049 | 16 | 0 |
495819 | 495819 | 2020-09-03 | Mono | California | 6051 | 162 | 2 |
495820 | 495820 | 2020-09-03 | Monterey | California | 6053 | 8244 | 58 |
495821 | 495821 | 2020-09-03 | Napa | California | 6055 | 1457 | 13 |
495822 | 495822 | 2020-09-03 | Nevada | California | 6057 | 452 | 5 |
495823 | 495823 | 2020-09-03 | Orange | California | 6059 | 49767 | 1018 |
495824 | 495824 | 2020-09-03 | Placer | California | 6061 | 3083 | 34 |
495825 | 495825 | 2020-09-03 | Plumas | California | 6063 | 39 | 0 |
495826 | 495826 | 2020-09-03 | Riverside | California | 6065 | 53703 | 1053 |
495827 | 495827 | 2020-09-03 | Sacramento | California | 6067 | 18606 | 317 |
495828 | 495828 | 2020-09-03 | San Benito | California | 6069 | 1146 | 8 |
495829 | 495829 | 2020-09-03 | San Bernardino | California | 6071 | 48615 | 744 |
495830 | 495830 | 2020-09-03 | San Diego | California | 6073 | 39509 | 700 |
495831 | 495831 | 2020-09-03 | San Francisco | California | 6075 | 9699 | 84 |
495832 | 495832 | 2020-09-03 | San Joaquin | California | 6077 | 18194 | 361 |
495833 | 495833 | 2020-09-03 | San Luis Obispo | California | 6079 | 3047 | 20 |
495834 | 495834 | 2020-09-03 | San Mateo | California | 6081 | 8390 | 132 |
495835 | 495835 | 2020-09-03 | Santa Barbara | California | 6083 | 8300 | 97 |
495836 | 495836 | 2020-09-03 | Santa Clara | California | 6085 | 17993 | 254 |
495837 | 495837 | 2020-09-03 | Santa Cruz | California | 6087 | 1896 | 7 |
495838 | 495838 | 2020-09-03 | Shasta | California | 6089 | 578 | 12 |
495839 | 495839 | 2020-09-03 | Sierra | California | 6091 | 6 | 0 |
495840 | 495840 | 2020-09-03 | Siskiyou | California | 6093 | 143 | 0 |
495841 | 495841 | 2020-09-03 | Solano | California | 6095 | 5636 | 47 |
495842 | 495842 | 2020-09-03 | Sonoma | California | 6097 | 6142 | 93 |
495843 | 495843 | 2020-09-03 | Stanislaus | California | 6099 | 15021 | 273 |
495844 | 495844 | 2020-09-03 | Sutter | California | 6101 | 1461 | 10 |
495845 | 495845 | 2020-09-03 | Tehama | California | 6103 | 429 | 1 |
495846 | 495846 | 2020-09-03 | Trinity | California | 6105 | 14 | 0 |
495847 | 495847 | 2020-09-03 | Tulare | California | 6107 | 14552 | 243 |
495848 | 495848 | 2020-09-03 | Tuolumne | California | 6109 | 190 | 2 |
495849 | 495849 | 2020-09-03 | Ventura | California | 6111 | 11031 | 116 |
495850 | 495850 | 2020-09-03 | Yolo | California | 6113 | 2478 | 53 |
495851 | 495851 | 2020-09-03 | Yuba | California | 6115 | 975 | 6 |
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);