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 2021-07-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 |
---|---|---|---|---|---|---|---|---|---|
669164 | 669164 | 94102 | 94102 | 2021-07-18 | San Francisco | 75 | 2047 | 31067 | |
669165 | 669165 | 94103 | 94103 | 2021-07-18 | San Francisco | 75 | 1937 | 28735 | |
669166 | 669166 | 94105 | 94105 | 2021-07-18 | San Francisco | 75 | 438 | 9155 | |
669167 | 669167 | 94107 | 94107 | 2021-07-18 | San Francisco | 75 | 1145 | 29689 | |
669168 | 669168 | 94108 | 94108 | 2021-07-18 | San Francisco | 75 | 341 | 14550 | |
669169 | 669169 | 94109 | 94109 | 2021-07-18 | San Francisco | 75 | 2240 | 56677 | |
669170 | 669170 | 94110 | 94110 | 2021-07-18 | San Francisco | 75 | 4529 | 94161 | |
669171 | 669171 | 94111 | 94111 | 2021-07-18 | San Francisco | 75 | 115 | 3620 | |
669172 | 669172 | 94112 | 94112 | 2021-07-18 | San Francisco | 75 | 5240 | 85166 | |
669173 | 669173 | 94114 | 94114 | 2021-07-18 | San Francisco | 75 | 861 | 34754 | |
669174 | 669174 | 94115 | 94115 | 2021-07-18 | San Francisco | 75 | 1405 | 35004 | |
669175 | 669175 | 94116 | 94116 | 2021-07-18 | San Francisco | 75 | 1023 | 47823 | |
669176 | 669176 | 94117 | 94117 | 2021-07-18 | San Francisco | 75 | 1007 | 44239 | |
669177 | 669177 | 94118 | 94118 | 2021-07-18 | San Francisco | 75 | 970 | 41468 | |
669178 | 669178 | 94121 | 94121 | 2021-07-18 | San Francisco | 75 | 985 | 43795 | |
669179 | 669179 | 94122 | 94122 | 2021-07-18 | San Francisco | 75 | 1151 | 62131 | |
669180 | 669180 | 94123 | 94123 | 2021-07-18 | San Francisco | 75 | 932 | 25941 | |
669181 | 669181 | 94124 | 94124 | 2021-07-18 | San Francisco | 75 | 3942 | 35363 | |
669182 | 669182 | 94127 | 94127 | 2021-07-18 | San Francisco | 75 | 509 | 21423 | |
669183 | 669183 | 94129 | 94129 | 2021-07-18 | San Francisco | 75 | 115 | 3994 | |
669184 | 669184 | 94130 | 94130 | 2021-07-18 | San Francisco | 75 | 144 | 3064 | |
669185 | 669185 | 94131 | 94131 | 2021-07-18 | San Francisco | 75 | 712 | 29902 | |
669186 | 669186 | 94132 | 94132 | 2021-07-18 | San Francisco | 75 | 892 | 31488 | |
669187 | 669187 | 94133 | 94133 | 2021-07-18 | San Francisco | 75 | 749 | 26527 | |
669188 | 669188 | 94134 | 94134 | 2021-07-18 | San Francisco | 75 | 2987 | 42471 | |
669189 | 669189 | 94158 | 94158 | 2021-07-18 | San Francisco | 75 | 358 | 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 );