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-06-27 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 |
---|---|---|---|---|---|---|---|---|---|
231775 | 231775 | 94102 | 94102 | 2022-06-27 | San Francisco | 75 | 6702 | 31067 | |
231776 | 231776 | 94103 | 94103 | 2022-06-27 | San Francisco | 75 | 6836 | 28735 | |
231777 | 231777 | 94105 | 94105 | 2022-06-27 | San Francisco | 75 | 2219 | 9155 | |
231778 | 231778 | 94107 | 94107 | 2022-06-27 | San Francisco | 75 | 5495 | 29689 | |
231779 | 231779 | 94108 | 94108 | 2022-06-27 | San Francisco | 75 | 1659 | 14550 | |
231780 | 231780 | 94109 | 94109 | 2022-06-27 | San Francisco | 75 | 8519 | 56677 | |
231781 | 231781 | 94110 | 94110 | 2022-06-27 | San Francisco | 75 | 13658 | 94161 | |
231782 | 231782 | 94111 | 94111 | 2022-06-27 | San Francisco | 75 | 622 | 3620 | |
231783 | 231783 | 94112 | 94112 | 2022-06-27 | San Francisco | 75 | 16943 | 85166 | |
231784 | 231784 | 94114 | 94114 | 2022-06-27 | San Francisco | 75 | 4541 | 34754 | |
231785 | 231785 | 94115 | 94115 | 2022-06-27 | San Francisco | 75 | 5702 | 35004 | |
231786 | 231786 | 94116 | 94116 | 2022-06-27 | San Francisco | 75 | 5685 | 47823 | |
231787 | 231787 | 94117 | 94117 | 2022-06-27 | San Francisco | 75 | 5825 | 44239 | |
231788 | 231788 | 94118 | 94118 | 2022-06-27 | San Francisco | 75 | 5215 | 41468 | |
231789 | 231789 | 94121 | 94121 | 2022-06-27 | San Francisco | 75 | 5548 | 43795 | |
231790 | 231790 | 94122 | 94122 | 2022-06-27 | San Francisco | 75 | 7263 | 62131 | |
231791 | 231791 | 94123 | 94123 | 2022-06-27 | San Francisco | 75 | 3668 | 25941 | |
231792 | 231792 | 94124 | 94124 | 2022-06-27 | San Francisco | 75 | 11251 | 35363 | |
231793 | 231793 | 94127 | 94127 | 2022-06-27 | San Francisco | 75 | 2692 | 21423 | |
231794 | 231794 | 94129 | 94129 | 2022-06-27 | San Francisco | 75 | 477 | 3994 | |
231795 | 231795 | 94130 | 94130 | 2022-06-27 | San Francisco | 75 | 470 | 3064 | |
231796 | 231796 | 94131 | 94131 | 2022-06-27 | San Francisco | 75 | 3910 | 29902 | |
231797 | 231797 | 94132 | 94132 | 2022-06-27 | San Francisco | 75 | 4023 | 31488 | |
231798 | 231798 | 94133 | 94133 | 2022-06-27 | San Francisco | 75 | 3520 | 26527 | |
231799 | 231799 | 94134 | 94134 | 2022-06-27 | San Francisco | 75 | 9142 | 42471 | |
231800 | 231800 | 94158 | 94158 | 2022-06-27 | San Francisco | 75 | 1776 | 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 );