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-05-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 |
---|---|---|---|---|---|---|---|---|---|
282345 | 282345 | 94102 | 94102 | 2022-05-18 | San Francisco | 75 | 6128 | 31067 | |
282346 | 282346 | 94103 | 94103 | 2022-05-18 | San Francisco | 75 | 6266 | 28735 | |
282347 | 282347 | 94105 | 94105 | 2022-05-18 | San Francisco | 75 | 1930 | 9155 | |
282348 | 282348 | 94107 | 94107 | 2022-05-18 | San Francisco | 75 | 4837 | 29689 | |
282349 | 282349 | 94108 | 94108 | 2022-05-18 | San Francisco | 75 | 1487 | 14550 | |
282350 | 282350 | 94109 | 94109 | 2022-05-18 | San Francisco | 75 | 7767 | 56677 | |
282351 | 282351 | 94110 | 94110 | 2022-05-18 | San Francisco | 75 | 12388 | 94161 | |
282352 | 282352 | 94111 | 94111 | 2022-05-18 | San Francisco | 75 | 547 | 3620 | |
282353 | 282353 | 94112 | 94112 | 2022-05-18 | San Francisco | 75 | 15050 | 85166 | |
282354 | 282354 | 94114 | 94114 | 2022-05-18 | San Francisco | 75 | 3988 | 34754 | |
282355 | 282355 | 94115 | 94115 | 2022-05-18 | San Francisco | 75 | 5053 | 35004 | |
282356 | 282356 | 94116 | 94116 | 2022-05-18 | San Francisco | 75 | 4777 | 47823 | |
282357 | 282357 | 94117 | 94117 | 2022-05-18 | San Francisco | 75 | 5118 | 44239 | |
282358 | 282358 | 94118 | 94118 | 2022-05-18 | San Francisco | 75 | 4421 | 41468 | |
282359 | 282359 | 94121 | 94121 | 2022-05-18 | San Francisco | 75 | 4618 | 43795 | |
282360 | 282360 | 94122 | 94122 | 2022-05-18 | San Francisco | 75 | 6022 | 62131 | |
282361 | 282361 | 94123 | 94123 | 2022-05-18 | San Francisco | 75 | 3358 | 25941 | |
282362 | 282362 | 94124 | 94124 | 2022-05-18 | San Francisco | 75 | 10275 | 35363 | |
282363 | 282363 | 94127 | 94127 | 2022-05-18 | San Francisco | 75 | 2283 | 21423 | |
282364 | 282364 | 94129 | 94129 | 2022-05-18 | San Francisco | 75 | 424 | 3994 | |
282365 | 282365 | 94130 | 94130 | 2022-05-18 | San Francisco | 75 | 436 | 3064 | |
282366 | 282366 | 94131 | 94131 | 2022-05-18 | San Francisco | 75 | 3267 | 29902 | |
282367 | 282367 | 94132 | 94132 | 2022-05-18 | San Francisco | 75 | 3453 | 31488 | |
282368 | 282368 | 94133 | 94133 | 2022-05-18 | San Francisco | 75 | 3127 | 26527 | |
282369 | 282369 | 94134 | 94134 | 2022-05-18 | San Francisco | 75 | 8215 | 42471 | |
282370 | 282370 | 94158 | 94158 | 2022-05-18 | San Francisco | 75 | 1538 | 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 );