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-15 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1030972 | 1030972 | 2021-02-15 | Alameda | California | 6001 | 78735 | 1121 |
1030973 | 1030973 | 2021-02-15 | Alpine | California | 6003 | 76 | 0 |
1030974 | 1030974 | 2021-02-15 | Amador | California | 6005 | 3397 | 38 |
1030975 | 1030975 | 2021-02-15 | Butte | California | 6007 | 10717 | 149 |
1030976 | 1030976 | 2021-02-15 | Calaveras | California | 6009 | 1866 | 25 |
1030977 | 1030977 | 2021-02-15 | Colusa | California | 6011 | 2069 | 11 |
1030978 | 1030978 | 2021-02-15 | Contra Costa | California | 6013 | 60710 | 622 |
1030979 | 1030979 | 2021-02-15 | Del Norte | California | 6015 | 931 | 4 |
1030980 | 1030980 | 2021-02-15 | El Dorado | California | 6017 | 8790 | 90 |
1030981 | 1030981 | 2021-02-15 | Fresno | California | 6019 | 93065 | 1291 |
1030982 | 1030982 | 2021-02-15 | Glenn | California | 6021 | 2615 | 23 |
1030983 | 1030983 | 2021-02-15 | Humboldt | California | 6023 | 3025 | 32 |
1030984 | 1030984 | 2021-02-15 | Imperial | California | 6025 | 26696 | 583 |
1030985 | 1030985 | 2021-02-15 | Inyo | California | 6027 | 1177 | 34 |
1030986 | 1030986 | 2021-02-15 | Kern | California | 6029 | 100434 | 687 |
1030987 | 1030987 | 2021-02-15 | Kings | California | 6031 | 21647 | 208 |
1030988 | 1030988 | 2021-02-15 | Lake | California | 6033 | 3030 | 37 |
1030989 | 1030989 | 2021-02-15 | Lassen | California | 6035 | 5498 | 19 |
1030990 | 1030990 | 2021-02-15 | Los Angeles | California | 6037 | 1168904 | 19095 |
1030991 | 1030991 | 2021-02-15 | Madera | California | 6039 | 15089 | 189 |
1030992 | 1030992 | 2021-02-15 | Marin | California | 6041 | 12784 | 184 |
1030993 | 1030993 | 2021-02-15 | Mariposa | California | 6043 | 388 | 7 |
1030994 | 1030994 | 2021-02-15 | Mendocino | California | 6045 | 3723 | 40 |
1030995 | 1030995 | 2021-02-15 | Merced | California | 6047 | 27701 | 375 |
1030996 | 1030996 | 2021-02-15 | Modoc | California | 6049 | 441 | 4 |
1030997 | 1030997 | 2021-02-15 | Mono | California | 6051 | 1180 | 4 |
1030998 | 1030998 | 2021-02-15 | Monterey | California | 6053 | 41341 | 307 |
1030999 | 1030999 | 2021-02-15 | Napa | California | 6055 | 8827 | 62 |
1031000 | 1031000 | 2021-02-15 | Nevada | California | 6057 | 3761 | 74 |
1031001 | 1031001 | 2021-02-15 | Orange | California | 6059 | 256889 | 3577 |
1031002 | 1031002 | 2021-02-15 | Placer | California | 6061 | 19313 | 222 |
1031003 | 1031003 | 2021-02-15 | Plumas | California | 6063 | 620 | 6 |
1031004 | 1031004 | 2021-02-15 | Riverside | California | 6065 | 285414 | 3524 |
1031005 | 1031005 | 2021-02-15 | Sacramento | California | 6067 | 90855 | 1372 |
1031006 | 1031006 | 2021-02-15 | San Benito | California | 6069 | 5641 | 57 |
1031007 | 1031007 | 2021-02-15 | San Bernardino | California | 6071 | 282494 | 2418 |
1031008 | 1031008 | 2021-02-15 | San Diego | California | 6073 | 252313 | 3037 |
1031009 | 1031009 | 2021-02-15 | San Francisco | California | 6075 | 33377 | 366 |
1031010 | 1031010 | 2021-02-15 | San Joaquin | California | 6077 | 64969 | 992 |
1031011 | 1031011 | 2021-02-15 | San Luis Obispo | California | 6079 | 18889 | 205 |
1031012 | 1031012 | 2021-02-15 | San Mateo | California | 6081 | 37859 | 474 |
1031013 | 1031013 | 2021-02-15 | Santa Barbara | California | 6083 | 30862 | 372 |
1031014 | 1031014 | 2021-02-15 | Santa Clara | California | 6085 | 107619 | 1669 |
1031015 | 1031015 | 2021-02-15 | Santa Cruz | California | 6087 | 14232 | 168 |
1031016 | 1031016 | 2021-02-15 | Shasta | California | 6089 | 10720 | 170 |
1031017 | 1031017 | 2021-02-15 | Sierra | California | 6091 | 47 | 0 |
1031018 | 1031018 | 2021-02-15 | Siskiyou | California | 6093 | 1664 | 13 |
1031019 | 1031019 | 2021-02-15 | Solano | California | 6095 | 29256 | 140 |
1031020 | 1031020 | 2021-02-15 | Sonoma | California | 6097 | 27361 | 287 |
1031021 | 1031021 | 2021-02-15 | Stanislaus | California | 6099 | 54325 | 899 |
1031022 | 1031022 | 2021-02-15 | Sutter | California | 6101 | 8656 | 93 |
1031023 | 1031023 | 2021-02-15 | Tehama | California | 6103 | 4490 | 51 |
1031024 | 1031024 | 2021-02-15 | Trinity | California | 6105 | 273 | 5 |
1031025 | 1031025 | 2021-02-15 | Tulare | California | 6107 | 46263 | 691 |
1031026 | 1031026 | 2021-02-15 | Tuolumne | California | 6109 | 3800 | 52 |
1031027 | 1031027 | 2021-02-15 | Ventura | California | 6111 | 75742 | 732 |
1031028 | 1031028 | 2021-02-15 | Yolo | California | 6113 | 12399 | 172 |
1031029 | 1031029 | 2021-02-15 | 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);