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-07 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 |
---|---|---|---|---|---|---|---|---|---|
683200 | 683200 | 94102 | 94102 | 2021-07-07 | San Francisco | 75 | 2015 | 31067 | |
683201 | 683201 | 94103 | 94103 | 2021-07-07 | San Francisco | 75 | 1895 | 28735 | |
683202 | 683202 | 94105 | 94105 | 2021-07-07 | San Francisco | 75 | 430 | 9155 | |
683203 | 683203 | 94107 | 94107 | 2021-07-07 | San Francisco | 75 | 1109 | 29689 | |
683204 | 683204 | 94108 | 94108 | 2021-07-07 | San Francisco | 75 | 331 | 14550 | |
683205 | 683205 | 94109 | 94109 | 2021-07-07 | San Francisco | 75 | 2200 | 56677 | |
683206 | 683206 | 94110 | 94110 | 2021-07-07 | San Francisco | 75 | 4467 | 94161 | |
683207 | 683207 | 94111 | 94111 | 2021-07-07 | San Francisco | 75 | 108 | 3620 | |
683208 | 683208 | 94112 | 94112 | 2021-07-07 | San Francisco | 75 | 5162 | 85166 | |
683209 | 683209 | 94114 | 94114 | 2021-07-07 | San Francisco | 75 | 834 | 34754 | |
683210 | 683210 | 94115 | 94115 | 2021-07-07 | San Francisco | 75 | 1355 | 35004 | |
683211 | 683211 | 94116 | 94116 | 2021-07-07 | San Francisco | 75 | 1007 | 47823 | |
683212 | 683212 | 94117 | 94117 | 2021-07-07 | San Francisco | 75 | 982 | 44239 | |
683213 | 683213 | 94118 | 94118 | 2021-07-07 | San Francisco | 75 | 954 | 41468 | |
683214 | 683214 | 94121 | 94121 | 2021-07-07 | San Francisco | 75 | 960 | 43795 | |
683215 | 683215 | 94122 | 94122 | 2021-07-07 | San Francisco | 75 | 1137 | 62131 | |
683216 | 683216 | 94123 | 94123 | 2021-07-07 | San Francisco | 75 | 916 | 25941 | |
683217 | 683217 | 94124 | 94124 | 2021-07-07 | San Francisco | 75 | 3866 | 35363 | |
683218 | 683218 | 94127 | 94127 | 2021-07-07 | San Francisco | 75 | 496 | 21423 | |
683219 | 683219 | 94129 | 94129 | 2021-07-07 | San Francisco | 75 | 113 | 3994 | |
683220 | 683220 | 94130 | 94130 | 2021-07-07 | San Francisco | 75 | 142 | 3064 | |
683221 | 683221 | 94131 | 94131 | 2021-07-07 | San Francisco | 75 | 692 | 29902 | |
683222 | 683222 | 94132 | 94132 | 2021-07-07 | San Francisco | 75 | 869 | 31488 | |
683223 | 683223 | 94133 | 94133 | 2021-07-07 | San Francisco | 75 | 723 | 26527 | |
683224 | 683224 | 94134 | 94134 | 2021-07-07 | San Francisco | 75 | 2947 | 42471 | |
683225 | 683225 | 94158 | 94158 | 2021-07-07 | San Francisco | 75 | 343 | 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 );