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-10-04 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 |
---|---|---|---|---|---|---|---|---|---|
569636 | 569636 | 94102 | 94102 | 2021-10-04 | San Francisco | 75 | 2594 | 31067 | |
569637 | 569637 | 94103 | 94103 | 2021-10-04 | San Francisco | 75 | 2608 | 28735 | |
569638 | 569638 | 94105 | 94105 | 2021-10-04 | San Francisco | 75 | 622 | 9155 | |
569639 | 569639 | 94107 | 94107 | 2021-10-04 | San Francisco | 75 | 1654 | 29689 | |
569640 | 569640 | 94108 | 94108 | 2021-10-04 | San Francisco | 75 | 454 | 14550 | |
569641 | 569641 | 94109 | 94109 | 2021-10-04 | San Francisco | 75 | 3009 | 56677 | |
569642 | 569642 | 94110 | 94110 | 2021-10-04 | San Francisco | 75 | 5579 | 94161 | |
569643 | 569643 | 94111 | 94111 | 2021-10-04 | San Francisco | 75 | 161 | 3620 | |
569644 | 569644 | 94112 | 94112 | 2021-10-04 | San Francisco | 75 | 6108 | 85166 | |
569645 | 569645 | 94114 | 94114 | 2021-10-04 | San Francisco | 75 | 1447 | 34754 | |
569646 | 569646 | 94115 | 94115 | 2021-10-04 | San Francisco | 75 | 1987 | 35004 | |
569647 | 569647 | 94116 | 94116 | 2021-10-04 | San Francisco | 75 | 1423 | 47823 | |
569648 | 569648 | 94117 | 94117 | 2021-10-04 | San Francisco | 75 | 1617 | 44239 | |
569649 | 569649 | 94118 | 94118 | 2021-10-04 | San Francisco | 75 | 1376 | 41468 | |
569650 | 569650 | 94121 | 94121 | 2021-10-04 | San Francisco | 75 | 1396 | 43795 | |
569651 | 569651 | 94122 | 94122 | 2021-10-04 | San Francisco | 75 | 1672 | 62131 | |
569652 | 569652 | 94123 | 94123 | 2021-10-04 | San Francisco | 75 | 1320 | 25941 | |
569653 | 569653 | 94124 | 94124 | 2021-10-04 | San Francisco | 75 | 4897 | 35363 | |
569654 | 569654 | 94127 | 94127 | 2021-10-04 | San Francisco | 75 | 688 | 21423 | |
569655 | 569655 | 94129 | 94129 | 2021-10-04 | San Francisco | 75 | 141 | 3994 | |
569656 | 569656 | 94130 | 94130 | 2021-10-04 | San Francisco | 75 | 182 | 3064 | |
569657 | 569657 | 94131 | 94131 | 2021-10-04 | San Francisco | 75 | 1025 | 29902 | |
569658 | 569658 | 94132 | 94132 | 2021-10-04 | San Francisco | 75 | 1203 | 31488 | |
569659 | 569659 | 94133 | 94133 | 2021-10-04 | San Francisco | 75 | 1099 | 26527 | |
569660 | 569660 | 94134 | 94134 | 2021-10-04 | San Francisco | 75 | 3462 | 42471 | |
569661 | 569661 | 94158 | 94158 | 2021-10-04 | San Francisco | 75 | 461 | 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 );