latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
26 rows where county = "San Francisco", "date" is on date 2022-06-18 and fips = 75 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
243142 | 243142 | 94102 | 94102 | 2022-06-18 | San Francisco | 75 | 6564 | 31067 | |
243143 | 243143 | 94103 | 94103 | 2022-06-18 | San Francisco | 75 | 6711 | 28735 | |
243144 | 243144 | 94105 | 94105 | 2022-06-18 | San Francisco | 75 | 2158 | 9155 | |
243145 | 243145 | 94107 | 94107 | 2022-06-18 | San Francisco | 75 | 5376 | 29689 | |
243146 | 243146 | 94108 | 94108 | 2022-06-18 | San Francisco | 75 | 1623 | 14550 | |
243147 | 243147 | 94109 | 94109 | 2022-06-18 | San Francisco | 75 | 8390 | 56677 | |
243148 | 243148 | 94110 | 94110 | 2022-06-18 | San Francisco | 75 | 13438 | 94161 | |
243149 | 243149 | 94111 | 94111 | 2022-06-18 | San Francisco | 75 | 605 | 3620 | |
243150 | 243150 | 94112 | 94112 | 2022-06-18 | San Francisco | 75 | 16578 | 85166 | |
243151 | 243151 | 94114 | 94114 | 2022-06-18 | San Francisco | 75 | 4430 | 34754 | |
243152 | 243152 | 94115 | 94115 | 2022-06-18 | San Francisco | 75 | 5592 | 35004 | |
243153 | 243153 | 94116 | 94116 | 2022-06-18 | San Francisco | 75 | 5497 | 47823 | |
243154 | 243154 | 94117 | 94117 | 2022-06-18 | San Francisco | 75 | 5695 | 44239 | |
243155 | 243155 | 94118 | 94118 | 2022-06-18 | San Francisco | 75 | 5074 | 41468 | |
243156 | 243156 | 94121 | 94121 | 2022-06-18 | San Francisco | 75 | 5351 | 43795 | |
243157 | 243157 | 94122 | 94122 | 2022-06-18 | San Francisco | 75 | 7007 | 62131 | |
243158 | 243158 | 94123 | 94123 | 2022-06-18 | San Francisco | 75 | 3614 | 25941 | |
243159 | 243159 | 94124 | 94124 | 2022-06-18 | San Francisco | 75 | 11067 | 35363 | |
243160 | 243160 | 94127 | 94127 | 2022-06-18 | San Francisco | 75 | 2625 | 21423 | |
243161 | 243161 | 94129 | 94129 | 2022-06-18 | San Francisco | 75 | 468 | 3994 | |
243162 | 243162 | 94130 | 94130 | 2022-06-18 | San Francisco | 75 | 457 | 3064 | |
243163 | 243163 | 94131 | 94131 | 2022-06-18 | San Francisco | 75 | 3804 | 29902 | |
243164 | 243164 | 94132 | 94132 | 2022-06-18 | San Francisco | 75 | 3894 | 31488 | |
243165 | 243165 | 94133 | 94133 | 2022-06-18 | San Francisco | 75 | 3449 | 26527 | |
243166 | 243166 | 94134 | 94134 | 2022-06-18 | San Francisco | 75 | 8960 | 42471 | |
243167 | 243167 | 94158 | 94158 | 2022-06-18 | San Francisco | 75 | 1717 | 7291 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] TEXT );