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 2021-05-14 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1316688 | 1316688 | 2021-05-14 | Alameda | California | 6001 | 88048 | 1667 |
1316689 | 1316689 | 2021-05-14 | Alpine | California | 6003 | 88 | 0 |
1316690 | 1316690 | 2021-05-14 | Amador | California | 6005 | 3661 | 47 |
1316691 | 1316691 | 2021-05-14 | Butte | California | 6007 | 12051 | 196 |
1316692 | 1316692 | 2021-05-14 | Calaveras | California | 6009 | 2129 | 54 |
1316693 | 1316693 | 2021-05-14 | Colusa | California | 6011 | 2234 | 16 |
1316694 | 1316694 | 2021-05-14 | Contra Costa | California | 6013 | 68871 | 806 |
1316695 | 1316695 | 2021-05-14 | Del Norte | California | 6015 | 1398 | 8 |
1316696 | 1316696 | 2021-05-14 | El Dorado | California | 6017 | 10168 | 113 |
1316697 | 1316697 | 2021-05-14 | Fresno | California | 6019 | 101862 | 1687 |
1316698 | 1316698 | 2021-05-14 | Glenn | California | 6021 | 2923 | 25 |
1316699 | 1316699 | 2021-05-14 | Humboldt | California | 6023 | 4072 | 42 |
1316700 | 1316700 | 2021-05-14 | Imperial | California | 6025 | 28468 | 728 |
1316701 | 1316701 | 2021-05-14 | Inyo | California | 6027 | 1428 | 38 |
1316702 | 1316702 | 2021-05-14 | Kern | California | 6029 | 109186 | 1374 |
1316703 | 1316703 | 2021-05-14 | Kings | California | 6031 | 23008 | 246 |
1316704 | 1316704 | 2021-05-14 | Lake | California | 6033 | 3479 | 43 |
1316705 | 1316705 | 2021-05-14 | Lassen | California | 6035 | 5706 | 24 |
1316706 | 1316706 | 2021-05-14 | Los Angeles | California | 6037 | 1237652 | 24083 |
1316707 | 1316707 | 2021-05-14 | Madera | California | 6039 | 16467 | 242 |
1316708 | 1316708 | 2021-05-14 | Marin | California | 6041 | 14004 | 227 |
1316709 | 1316709 | 2021-05-14 | Mariposa | California | 6043 | 450 | 7 |
1316710 | 1316710 | 2021-05-14 | Mendocino | California | 6045 | 4101 | 49 |
1316711 | 1316711 | 2021-05-14 | Merced | California | 6047 | 31919 | 461 |
1316712 | 1316712 | 2021-05-14 | Modoc | California | 6049 | 501 | 4 |
1316713 | 1316713 | 2021-05-14 | Mono | California | 6051 | 1284 | 4 |
1316714 | 1316714 | 2021-05-14 | Monterey | California | 6053 | 43662 | 383 |
1316715 | 1316715 | 2021-05-14 | Napa | California | 6055 | 9878 | 82 |
1316716 | 1316716 | 2021-05-14 | Nevada | California | 6057 | 4743 | 75 |
1316717 | 1316717 | 2021-05-14 | Orange | California | 6059 | 271134 | 5028 |
1316718 | 1316718 | 2021-05-14 | Placer | California | 6061 | 22679 | 292 |
1316719 | 1316719 | 2021-05-14 | Plumas | California | 6063 | 710 | 6 |
1316720 | 1316720 | 2021-05-14 | Riverside | California | 6065 | 299793 | 4594 |
1316721 | 1316721 | 2021-05-14 | Sacramento | California | 6067 | 104957 | 1691 |
1316722 | 1316722 | 2021-05-14 | San Benito | California | 6069 | 6062 | 63 |
1316723 | 1316723 | 2021-05-14 | San Bernardino | California | 6071 | 296903 | 4722 |
1316724 | 1316724 | 2021-05-14 | San Diego | California | 6073 | 278655 | 3729 |
1316725 | 1316725 | 2021-05-14 | San Francisco | California | 6075 | 36744 | 544 |
1316726 | 1316726 | 2021-05-14 | San Joaquin | California | 6077 | 73310 | 1394 |
1316727 | 1316727 | 2021-05-14 | San Luis Obispo | California | 6079 | 21308 | 260 |
1316728 | 1316728 | 2021-05-14 | San Mateo | California | 6081 | 42059 | 568 |
1316729 | 1316729 | 2021-05-14 | Santa Barbara | California | 6083 | 34365 | 456 |
1316730 | 1316730 | 2021-05-14 | Santa Clara | California | 6085 | 118952 | 2097 |
1316731 | 1316731 | 2021-05-14 | Santa Cruz | California | 6087 | 16264 | 208 |
1316732 | 1316732 | 2021-05-14 | Shasta | California | 6089 | 12152 | 226 |
1316733 | 1316733 | 2021-05-14 | Sierra | California | 6091 | 54 | 0 |
1316734 | 1316734 | 2021-05-14 | Siskiyou | California | 6093 | 2255 | 25 |
1316735 | 1316735 | 2021-05-14 | Solano | California | 6095 | 32979 | 252 |
1316736 | 1316736 | 2021-05-14 | Sonoma | California | 6097 | 30035 | 321 |
1316737 | 1316737 | 2021-05-14 | Stanislaus | California | 6099 | 62188 | 1061 |
1316738 | 1316738 | 2021-05-14 | Sutter | California | 6101 | 9433 | 112 |
1316739 | 1316739 | 2021-05-14 | Tehama | California | 6103 | 4997 | 63 |
1316740 | 1316740 | 2021-05-14 | Trinity | California | 6105 | 328 | 3 |
1316741 | 1316741 | 2021-05-14 | Tulare | California | 6107 | 49830 | 840 |
1316742 | 1316742 | 2021-05-14 | Tuolumne | California | 6109 | 4139 | 67 |
1316743 | 1316743 | 2021-05-14 | Ventura | California | 6111 | 81033 | 1016 |
1316744 | 1316744 | 2021-05-14 | Yolo | California | 6113 | 13914 | 210 |
1316745 | 1316745 | 2021-05-14 | Yuba | California | 6115 | 6268 | 47 |
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);