ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where "date" is on date 2020-04-17 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
64784 | 64784 | 2020-04-17 | Alameda | California | 6001 | 1084 | 40 |
64785 | 64785 | 2020-04-17 | Alpine | California | 6003 | 1 | 0 |
64786 | 64786 | 2020-04-17 | Amador | California | 6005 | 6 | 0 |
64787 | 64787 | 2020-04-17 | Butte | California | 6007 | 16 | 0 |
64788 | 64788 | 2020-04-17 | Calaveras | California | 6009 | 12 | 0 |
64789 | 64789 | 2020-04-17 | Colusa | California | 6011 | 3 | 0 |
64790 | 64790 | 2020-04-17 | Contra Costa | California | 6013 | 648 | 19 |
64791 | 64791 | 2020-04-17 | Del Norte | California | 6015 | 2 | 0 |
64792 | 64792 | 2020-04-17 | El Dorado | California | 6017 | 36 | 0 |
64793 | 64793 | 2020-04-17 | Fresno | California | 6019 | 311 | 7 |
64794 | 64794 | 2020-04-17 | Glenn | California | 6021 | 4 | 0 |
64795 | 64795 | 2020-04-17 | Humboldt | California | 6023 | 52 | 0 |
64796 | 64796 | 2020-04-17 | Imperial | California | 6025 | 155 | 2 |
64797 | 64797 | 2020-04-17 | Inyo | California | 6027 | 18 | 0 |
64798 | 64798 | 2020-04-17 | Kern | California | 6029 | 553 | 3 |
64799 | 64799 | 2020-04-17 | Kings | California | 6031 | 20 | 1 |
64800 | 64800 | 2020-04-17 | Lake | California | 6033 | 6 | 0 |
64801 | 64801 | 2020-04-17 | Los Angeles | California | 6037 | 11391 | 495 |
64802 | 64802 | 2020-04-17 | Madera | California | 6039 | 33 | 2 |
64803 | 64803 | 2020-04-17 | Marin | California | 6041 | 187 | 10 |
64804 | 64804 | 2020-04-17 | Mendocino | California | 6045 | 4 | 0 |
64805 | 64805 | 2020-04-17 | Merced | California | 6047 | 85 | 3 |
64806 | 64806 | 2020-04-17 | Mono | California | 6051 | 23 | 1 |
64807 | 64807 | 2020-04-17 | Monterey | California | 6053 | 119 | 3 |
64808 | 64808 | 2020-04-17 | Napa | California | 6055 | 45 | 2 |
64809 | 64809 | 2020-04-17 | Nevada | California | 6057 | 36 | 1 |
64810 | 64810 | 2020-04-17 | Orange | California | 6059 | 1501 | 28 |
64811 | 64811 | 2020-04-17 | Placer | California | 6061 | 130 | 8 |
64812 | 64812 | 2020-04-17 | Plumas | California | 6063 | 4 | 0 |
64813 | 64813 | 2020-04-17 | Riverside | California | 6065 | 2457 | 69 |
64814 | 64814 | 2020-04-17 | Sacramento | California | 6067 | 896 | 32 |
64815 | 64815 | 2020-04-17 | San Benito | California | 6069 | 44 | 2 |
64816 | 64816 | 2020-04-17 | San Bernardino | California | 6071 | 1096 | 55 |
64817 | 64817 | 2020-04-17 | San Diego | California | 6073 | 2158 | 70 |
64818 | 64818 | 2020-04-17 | San Francisco | California | 6075 | 1061 | 20 |
64819 | 64819 | 2020-04-17 | San Joaquin | California | 6077 | 398 | 17 |
64820 | 64820 | 2020-04-17 | San Luis Obispo | California | 6079 | 127 | 1 |
64821 | 64821 | 2020-04-17 | San Mateo | California | 6081 | 797 | 28 |
64822 | 64822 | 2020-04-17 | Santa Barbara | California | 6083 | 373 | 3 |
64823 | 64823 | 2020-04-17 | Santa Clara | California | 6085 | 1870 | 74 |
64824 | 64824 | 2020-04-17 | Santa Cruz | California | 6087 | 98 | 2 |
64825 | 64825 | 2020-04-17 | Shasta | California | 6089 | 26 | 3 |
64826 | 64826 | 2020-04-17 | Siskiyou | California | 6093 | 5 | 0 |
64827 | 64827 | 2020-04-17 | Solano | California | 6095 | 174 | 2 |
64828 | 64828 | 2020-04-17 | Sonoma | California | 6097 | 180 | 2 |
64829 | 64829 | 2020-04-17 | Stanislaus | California | 6099 | 206 | 4 |
64830 | 64830 | 2020-04-17 | Sutter | California | 6101 | 25 | 2 |
64831 | 64831 | 2020-04-17 | Tehama | California | 6103 | 1 | 0 |
64832 | 64832 | 2020-04-17 | Tulare | California | 6107 | 382 | 17 |
64833 | 64833 | 2020-04-17 | Tuolumne | California | 6109 | 2 | 0 |
64834 | 64834 | 2020-04-17 | Ventura | California | 6111 | 396 | 13 |
64835 | 64835 | 2020-04-17 | Yolo | California | 6113 | 126 | 8 |
64836 | 64836 | 2020-04-17 | Yuba | California | 6115 | 15 | 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);