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-08-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 |
---|---|---|---|---|---|---|---|---|---|
166099 | 166099 | 94102 | 94102 | 2022-08-18 | San Francisco | 75 | 7382 | 31067 | |
166100 | 166100 | 94103 | 94103 | 2022-08-18 | San Francisco | 75 | 7535 | 28735 | |
166101 | 166101 | 94105 | 94105 | 2022-08-18 | San Francisco | 75 | 2499 | 9155 | |
166102 | 166102 | 94107 | 94107 | 2022-08-18 | San Francisco | 75 | 6169 | 29689 | |
166103 | 166103 | 94108 | 94108 | 2022-08-18 | San Francisco | 75 | 1867 | 14550 | |
166104 | 166104 | 94109 | 94109 | 2022-08-18 | San Francisco | 75 | 9330 | 56677 | |
166105 | 166105 | 94110 | 94110 | 2022-08-18 | San Francisco | 75 | 15120 | 94161 | |
166106 | 166106 | 94111 | 94111 | 2022-08-18 | San Francisco | 75 | 689 | 3620 | |
166107 | 166107 | 94112 | 94112 | 2022-08-18 | San Francisco | 75 | 19188 | 85166 | |
166108 | 166108 | 94114 | 94114 | 2022-08-18 | San Francisco | 75 | 5053 | 34754 | |
166109 | 166109 | 94115 | 94115 | 2022-08-18 | San Francisco | 75 | 6363 | 35004 | |
166110 | 166110 | 94116 | 94116 | 2022-08-18 | San Francisco | 75 | 6656 | 47823 | |
166111 | 166111 | 94117 | 94117 | 2022-08-18 | San Francisco | 75 | 6514 | 44239 | |
166112 | 166112 | 94118 | 94118 | 2022-08-18 | San Francisco | 75 | 5845 | 41468 | |
166113 | 166113 | 94121 | 94121 | 2022-08-18 | San Francisco | 75 | 6561 | 43795 | |
166114 | 166114 | 94122 | 94122 | 2022-08-18 | San Francisco | 75 | 8404 | 62131 | |
166115 | 166115 | 94123 | 94123 | 2022-08-18 | San Francisco | 75 | 3954 | 25941 | |
166116 | 166116 | 94124 | 94124 | 2022-08-18 | San Francisco | 75 | 12516 | 35363 | |
166117 | 166117 | 94127 | 94127 | 2022-08-18 | San Francisco | 75 | 3093 | 21423 | |
166118 | 166118 | 94129 | 94129 | 2022-08-18 | San Francisco | 75 | 523 | 3994 | |
166119 | 166119 | 94130 | 94130 | 2022-08-18 | San Francisco | 75 | 509 | 3064 | |
166120 | 166120 | 94131 | 94131 | 2022-08-18 | San Francisco | 75 | 4502 | 29902 | |
166121 | 166121 | 94132 | 94132 | 2022-08-18 | San Francisco | 75 | 4609 | 31488 | |
166122 | 166122 | 94133 | 94133 | 2022-08-18 | San Francisco | 75 | 3891 | 26527 | |
166123 | 166123 | 94134 | 94134 | 2022-08-18 | San Francisco | 75 | 10318 | 42471 | |
166124 | 166124 | 94158 | 94158 | 2022-08-18 | San Francisco | 75 | 2007 | 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 );