ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where date = "2020-06-10" 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 |
---|---|---|---|---|---|---|---|
224791 | 224791 | 2020-06-10 | Alameda | California | 6001 | 4054 | 110 |
224792 | 224792 | 2020-06-10 | Alpine | California | 6003 | 2 | 0 |
224793 | 224793 | 2020-06-10 | Amador | California | 6005 | 9 | 0 |
224794 | 224794 | 2020-06-10 | Butte | California | 6007 | 73 | 1 |
224795 | 224795 | 2020-06-10 | Calaveras | California | 6009 | 21 | 0 |
224796 | 224796 | 2020-06-10 | Colusa | California | 6011 | 7 | 0 |
224797 | 224797 | 2020-06-10 | Contra Costa | California | 6013 | 1798 | 43 |
224798 | 224798 | 2020-06-10 | Del Norte | California | 6015 | 47 | 0 |
224799 | 224799 | 2020-06-10 | El Dorado | California | 6017 | 111 | 0 |
224800 | 224800 | 2020-06-10 | Fresno | California | 6019 | 2318 | 49 |
224801 | 224801 | 2020-06-10 | Glenn | California | 6021 | 23 | 0 |
224802 | 224802 | 2020-06-10 | Humboldt | California | 6023 | 113 | 4 |
224803 | 224803 | 2020-06-10 | Imperial | California | 6025 | 3386 | 40 |
224804 | 224804 | 2020-06-10 | Inyo | California | 6027 | 22 | 1 |
224805 | 224805 | 2020-06-10 | Kern | California | 6029 | 2952 | 51 |
224806 | 224806 | 2020-06-10 | Kings | California | 6031 | 1688 | 6 |
224807 | 224807 | 2020-06-10 | Lake | California | 6033 | 30 | 0 |
224808 | 224808 | 2020-06-10 | Lassen | California | 6035 | 9 | 0 |
224809 | 224809 | 2020-06-10 | Los Angeles | California | 6037 | 67064 | 2768 |
224810 | 224810 | 2020-06-10 | Madera | California | 6039 | 178 | 3 |
224811 | 224811 | 2020-06-10 | Marin | California | 6041 | 651 | 17 |
224812 | 224812 | 2020-06-10 | Mariposa | California | 6043 | 16 | 1 |
224813 | 224813 | 2020-06-10 | Mendocino | California | 6045 | 36 | 0 |
224814 | 224814 | 2020-06-10 | Merced | California | 6047 | 387 | 7 |
224815 | 224815 | 2020-06-10 | Mono | California | 6051 | 37 | 1 |
224816 | 224816 | 2020-06-10 | Monterey | California | 6053 | 791 | 11 |
224817 | 224817 | 2020-06-10 | Napa | California | 6055 | 162 | 3 |
224818 | 224818 | 2020-06-10 | Nevada | California | 6057 | 50 | 1 |
224819 | 224819 | 2020-06-10 | Orange | California | 6059 | 7991 | 198 |
224820 | 224820 | 2020-06-10 | Placer | California | 6061 | 314 | 9 |
224821 | 224821 | 2020-06-10 | Plumas | California | 6063 | 4 | 0 |
224822 | 224822 | 2020-06-10 | Riverside | California | 6065 | 9911 | 372 |
224823 | 224823 | 2020-06-10 | Sacramento | California | 6067 | 1641 | 62 |
224824 | 224824 | 2020-06-10 | San Benito | California | 6069 | 109 | 2 |
224825 | 224825 | 2020-06-10 | San Bernardino | California | 6071 | 6593 | 225 |
224826 | 224826 | 2020-06-10 | San Diego | California | 6073 | 8900 | 312 |
224827 | 224827 | 2020-06-10 | San Francisco | California | 6075 | 2812 | 44 |
224828 | 224828 | 2020-06-10 | San Joaquin | California | 6077 | 1358 | 40 |
224829 | 224829 | 2020-06-10 | San Luis Obispo | California | 6079 | 306 | 1 |
224830 | 224830 | 2020-06-10 | San Mateo | California | 6081 | 2475 | 93 |
224831 | 224831 | 2020-06-10 | Santa Barbara | California | 6083 | 1855 | 15 |
224832 | 224832 | 2020-06-10 | Santa Clara | California | 6085 | 3032 | 150 |
224833 | 224833 | 2020-06-10 | Santa Cruz | California | 6087 | 239 | 3 |
224834 | 224834 | 2020-06-10 | Shasta | California | 6089 | 47 | 4 |
224835 | 224835 | 2020-06-10 | Sierra | California | 6091 | 1 | 0 |
224836 | 224836 | 2020-06-10 | Siskiyou | California | 6093 | 14 | 0 |
224837 | 224837 | 2020-06-10 | Solano | California | 6095 | 622 | 23 |
224838 | 224838 | 2020-06-10 | Sonoma | California | 6097 | 671 | 4 |
224839 | 224839 | 2020-06-10 | Stanislaus | California | 6099 | 1023 | 33 |
224840 | 224840 | 2020-06-10 | Sutter | California | 6101 | 67 | 2 |
224841 | 224841 | 2020-06-10 | Tehama | California | 6103 | 9 | 1 |
224842 | 224842 | 2020-06-10 | Trinity | California | 6105 | 3 | 0 |
224843 | 224843 | 2020-06-10 | Tulare | California | 6107 | 2432 | 96 |
224844 | 224844 | 2020-06-10 | Tuolumne | California | 6109 | 8 | 0 |
224845 | 224845 | 2020-06-10 | Ventura | California | 6111 | 1407 | 38 |
224846 | 224846 | 2020-06-10 | Yolo | California | 6113 | 227 | 24 |
224847 | 224847 | 2020-06-10 | Yuba | California | 6115 | 33 | 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);