ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-12-14" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2011795 | 2011795 | 2021-12-14 | Alameda | California | 6001 | 127364 | 1523 |
2011796 | 2011796 | 2021-12-14 | Alpine | California | 6003 | 109 | 0 |
2011797 | 2011797 | 2021-12-14 | Amador | California | 6005 | 5868 | 69 |
2011798 | 2011798 | 2021-12-14 | Butte | California | 6007 | 25900 | 326 |
2011799 | 2011799 | 2021-12-14 | Calaveras | California | 6009 | 4577 | 89 |
2011800 | 2011800 | 2021-12-14 | Colusa | California | 6011 | 3322 | 21 |
2011801 | 2011801 | 2021-12-14 | Contra Costa | California | 6013 | 105497 | 1064 |
2011802 | 2011802 | 2021-12-14 | Del Norte | California | 6015 | 3919 | 42 |
2011803 | 2011803 | 2021-12-14 | El Dorado | California | 6017 | 18736 | 170 |
2011804 | 2011804 | 2021-12-14 | Fresno | California | 6019 | 159455 | 2312 |
2011805 | 2011805 | 2021-12-14 | Glenn | California | 6021 | 4626 | 53 |
2011806 | 2011806 | 2021-12-14 | Humboldt | California | 6023 | 10555 | 120 |
2011807 | 2011807 | 2021-12-14 | Imperial | California | 6025 | 39801 | 786 |
2011808 | 2011808 | 2021-12-14 | Inyo | California | 6027 | 2627 | 46 |
2011809 | 2011809 | 2021-12-14 | Kern | California | 6029 | 160477 | 1879 |
2011810 | 2011810 | 2021-12-14 | Kings | California | 6031 | 35883 | 374 |
2011811 | 2011811 | 2021-12-14 | Lake | California | 6033 | 7116 | 115 |
2011812 | 2011812 | 2021-12-14 | Lassen | California | 6035 | 8039 | 61 |
2011813 | 2011813 | 2021-12-14 | Los Angeles | California | 6037 | 1550000 | 27352 |
2011814 | 2011814 | 2021-12-14 | Madera | California | 6039 | 26776 | 315 |
2011815 | 2011815 | 2021-12-14 | Marin | California | 6041 | 19027 | 249 |
2011816 | 2011816 | 2021-12-14 | Mariposa | California | 6043 | 1658 | 18 |
2011817 | 2011817 | 2021-12-14 | Mendocino | California | 6045 | 8883 | 100 |
2011818 | 2011818 | 2021-12-14 | Merced | California | 6047 | 46234 | 687 |
2011819 | 2011819 | 2021-12-14 | Modoc | California | 6049 | 1086 | 10 |
2011820 | 2011820 | 2021-12-14 | Mono | California | 6051 | 1972 | 4 |
2011821 | 2011821 | 2021-12-14 | Monterey | California | 6053 | 53542 | 636 |
2011822 | 2011822 | 2021-12-14 | Napa | California | 6055 | 13642 | 107 |
2011823 | 2011823 | 2021-12-14 | Nevada | California | 6057 | 10304 | 106 |
2011824 | 2011824 | 2021-12-14 | Orange | California | 6059 | 339305 | 5829 |
2011825 | 2011825 | 2021-12-14 | Placer | California | 6061 | 43211 | 483 |
2011826 | 2011826 | 2021-12-14 | Plumas | California | 6063 | 1999 | 12 |
2011827 | 2011827 | 2021-12-14 | Riverside | California | 6065 | 395274 | 5514 |
2011828 | 2011828 | 2021-12-14 | Sacramento | California | 6067 | 171745 | 2490 |
2011829 | 2011829 | 2021-12-14 | San Benito | California | 6069 | 8052 | 79 |
2011830 | 2011830 | 2021-12-14 | San Bernardino | California | 6071 | 382514 | 6011 |
2011831 | 2011831 | 2021-12-14 | San Diego | California | 6073 | 418061 | 4389 |
2011832 | 2011832 | 2021-12-14 | San Francisco | California | 6075 | 58149 | 678 |
2011833 | 2011833 | 2021-12-14 | San Joaquin | California | 6077 | 109312 | 1846 |
2011834 | 2011834 | 2021-12-14 | San Luis Obispo | California | 6079 | 32119 | 367 |
2011835 | 2011835 | 2021-12-14 | San Mateo | California | 6081 | 57477 | 631 |
2011836 | 2011836 | 2021-12-14 | Santa Barbara | California | 6083 | 48389 | 560 |
2011837 | 2011837 | 2021-12-14 | Santa Clara | California | 6085 | 155362 | 1945 |
2011838 | 2011838 | 2021-12-14 | Santa Cruz | California | 6087 | 22825 | 225 |
2011839 | 2011839 | 2021-12-14 | Shasta | California | 6089 | 26543 | 476 |
2011840 | 2011840 | 2021-12-14 | Sierra | California | 6091 | 222 | 0 |
2011841 | 2011841 | 2021-12-14 | Siskiyou | California | 6093 | 4999 | 75 |
2011842 | 2011842 | 2021-12-14 | Solano | California | 6095 | 48370 | 365 |
2011843 | 2011843 | 2021-12-14 | Sonoma | California | 6097 | 44076 | 416 |
2011844 | 2011844 | 2021-12-14 | Stanislaus | California | 6099 | 93074 | 1455 |
2011845 | 2011845 | 2021-12-14 | Sutter | California | 6101 | 14825 | 188 |
2011846 | 2011846 | 2021-12-14 | Tehama | California | 6103 | 10387 | 134 |
2011847 | 2011847 | 2021-12-14 | Trinity | California | 6105 | 1029 | 17 |
2011848 | 2011848 | 2021-12-14 | Tulare | California | 6107 | 87756 | 1114 |
2011849 | 2011849 | 2021-12-14 | Tuolumne | California | 6109 | 8015 | 148 |
2011850 | 2011850 | 2021-12-14 | Ventura | California | 6111 | 105780 | 1197 |
2011851 | 2011851 | 2021-12-14 | Yolo | California | 6113 | 22012 | 267 |
2011852 | 2011852 | 2021-12-14 | Yuba | California | 6115 | 11421 | 92 |
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);