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-02-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 |
---|---|---|---|---|---|---|---|
1027725 | 1027725 | 2021-02-14 | Alameda | California | 6001 | 78377 | 1120 |
1027726 | 1027726 | 2021-02-14 | Alpine | California | 6003 | 76 | 0 |
1027727 | 1027727 | 2021-02-14 | Amador | California | 6005 | 3386 | 38 |
1027728 | 1027728 | 2021-02-14 | Butte | California | 6007 | 10699 | 149 |
1027729 | 1027729 | 2021-02-14 | Calaveras | California | 6009 | 1863 | 25 |
1027730 | 1027730 | 2021-02-14 | Colusa | California | 6011 | 2069 | 11 |
1027731 | 1027731 | 2021-02-14 | Contra Costa | California | 6013 | 60537 | 622 |
1027732 | 1027732 | 2021-02-14 | Del Norte | California | 6015 | 929 | 4 |
1027733 | 1027733 | 2021-02-14 | El Dorado | California | 6017 | 8758 | 90 |
1027734 | 1027734 | 2021-02-14 | Fresno | California | 6019 | 92807 | 1291 |
1027735 | 1027735 | 2021-02-14 | Glenn | California | 6021 | 2615 | 23 |
1027736 | 1027736 | 2021-02-14 | Humboldt | California | 6023 | 3009 | 32 |
1027737 | 1027737 | 2021-02-14 | Imperial | California | 6025 | 26680 | 583 |
1027738 | 1027738 | 2021-02-14 | Inyo | California | 6027 | 1168 | 34 |
1027739 | 1027739 | 2021-02-14 | Kern | California | 6029 | 100290 | 687 |
1027740 | 1027740 | 2021-02-14 | Kings | California | 6031 | 21610 | 208 |
1027741 | 1027741 | 2021-02-14 | Lake | California | 6033 | 3025 | 37 |
1027742 | 1027742 | 2021-02-14 | Lassen | California | 6035 | 5498 | 19 |
1027743 | 1027743 | 2021-02-14 | Los Angeles | California | 6037 | 1167074 | 19066 |
1027744 | 1027744 | 2021-02-14 | Madera | California | 6039 | 15053 | 189 |
1027745 | 1027745 | 2021-02-14 | Marin | California | 6041 | 12757 | 184 |
1027746 | 1027746 | 2021-02-14 | Mariposa | California | 6043 | 388 | 5 |
1027747 | 1027747 | 2021-02-14 | Mendocino | California | 6045 | 3723 | 40 |
1027748 | 1027748 | 2021-02-14 | Merced | California | 6047 | 27701 | 375 |
1027749 | 1027749 | 2021-02-14 | Modoc | California | 6049 | 441 | 4 |
1027750 | 1027750 | 2021-02-14 | Mono | California | 6051 | 1176 | 4 |
1027751 | 1027751 | 2021-02-14 | Monterey | California | 6053 | 41341 | 307 |
1027752 | 1027752 | 2021-02-14 | Napa | California | 6055 | 8810 | 62 |
1027753 | 1027753 | 2021-02-14 | Nevada | California | 6057 | 3742 | 74 |
1027754 | 1027754 | 2021-02-14 | Orange | California | 6059 | 256889 | 3577 |
1027755 | 1027755 | 2021-02-14 | Placer | California | 6061 | 19214 | 222 |
1027756 | 1027756 | 2021-02-14 | Plumas | California | 6063 | 616 | 6 |
1027757 | 1027757 | 2021-02-14 | Riverside | California | 6065 | 285414 | 3524 |
1027758 | 1027758 | 2021-02-14 | Sacramento | California | 6067 | 90400 | 1372 |
1027759 | 1027759 | 2021-02-14 | San Benito | California | 6069 | 5633 | 57 |
1027760 | 1027760 | 2021-02-14 | San Bernardino | California | 6071 | 282169 | 2392 |
1027761 | 1027761 | 2021-02-14 | San Diego | California | 6073 | 252313 | 3037 |
1027762 | 1027762 | 2021-02-14 | San Francisco | California | 6075 | 33294 | 366 |
1027763 | 1027763 | 2021-02-14 | San Joaquin | California | 6077 | 64969 | 992 |
1027764 | 1027764 | 2021-02-14 | San Luis Obispo | California | 6079 | 18889 | 205 |
1027765 | 1027765 | 2021-02-14 | San Mateo | California | 6081 | 37745 | 474 |
1027766 | 1027766 | 2021-02-14 | Santa Barbara | California | 6083 | 30862 | 372 |
1027767 | 1027767 | 2021-02-14 | Santa Clara | California | 6085 | 107397 | 1667 |
1027768 | 1027768 | 2021-02-14 | Santa Cruz | California | 6087 | 14232 | 168 |
1027769 | 1027769 | 2021-02-14 | Shasta | California | 6089 | 10718 | 170 |
1027770 | 1027770 | 2021-02-14 | Sierra | California | 6091 | 47 | 0 |
1027771 | 1027771 | 2021-02-14 | Siskiyou | California | 6093 | 1664 | 13 |
1027772 | 1027772 | 2021-02-14 | Solano | California | 6095 | 29256 | 140 |
1027773 | 1027773 | 2021-02-14 | Sonoma | California | 6097 | 27249 | 287 |
1027774 | 1027774 | 2021-02-14 | Stanislaus | California | 6099 | 54148 | 899 |
1027775 | 1027775 | 2021-02-14 | Sutter | California | 6101 | 8656 | 93 |
1027776 | 1027776 | 2021-02-14 | Tehama | California | 6103 | 4484 | 51 |
1027777 | 1027777 | 2021-02-14 | Trinity | California | 6105 | 273 | 5 |
1027778 | 1027778 | 2021-02-14 | Tulare | California | 6107 | 46162 | 691 |
1027779 | 1027779 | 2021-02-14 | Tuolumne | California | 6109 | 3800 | 52 |
1027780 | 1027780 | 2021-02-14 | Ventura | California | 6111 | 75481 | 732 |
1027781 | 1027781 | 2021-02-14 | Yolo | California | 6113 | 12374 | 172 |
1027782 | 1027782 | 2021-02-14 | Yuba | California | 6115 | 5583 | 36 |
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);