latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
26,520 rows where county = "San Francisco" 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 |
---|---|---|---|---|---|---|---|---|---|
906500 | 906500 | 94102 | 94102 | 2021-01-13 | San Francisco | 75 | 1392 | 31067 | |
906501 | 906501 | 94103 | 94103 | 2021-01-13 | San Francisco | 75 | 1383 | 28735 | |
906502 | 906502 | 94105 | 94105 | 2021-01-13 | San Francisco | 75 | 298 | 9155 | |
906503 | 906503 | 94107 | 94107 | 2021-01-13 | San Francisco | 75 | 803 | 29689 | |
906504 | 906504 | 94108 | 94108 | 2021-01-13 | San Francisco | 75 | 203 | 14550 | |
906505 | 906505 | 94109 | 94109 | 2021-01-13 | San Francisco | 75 | 1581 | 56677 | |
906506 | 906506 | 94110 | 94110 | 2021-01-13 | San Francisco | 75 | 3470 | 94161 | |
906507 | 906507 | 94111 | 94111 | 2021-01-13 | San Francisco | 75 | 60 | 3620 | |
906508 | 906508 | 94112 | 94112 | 2021-01-13 | San Francisco | 75 | 3973 | 85166 | |
906509 | 906509 | 94114 | 94114 | 2021-01-13 | San Francisco | 75 | 625 | 34754 | |
906510 | 906510 | 94115 | 94115 | 2021-01-13 | San Francisco | 75 | 962 | 35004 | |
906511 | 906511 | 94116 | 94116 | 2021-01-13 | San Francisco | 75 | 712 | 47823 | |
906512 | 906512 | 94117 | 94117 | 2021-01-13 | San Francisco | 75 | 672 | 44239 | |
906513 | 906513 | 94118 | 94118 | 2021-01-13 | San Francisco | 75 | 681 | 41468 | |
906514 | 906514 | 94121 | 94121 | 2021-01-13 | San Francisco | 75 | 656 | 43795 | |
906515 | 906515 | 94122 | 94122 | 2021-01-13 | San Francisco | 75 | 766 | 62131 | |
906516 | 906516 | 94123 | 94123 | 2021-01-13 | San Francisco | 75 | 595 | 25941 | |
906517 | 906517 | 94124 | 94124 | 2021-01-13 | San Francisco | 75 | 2924 | 35363 | |
906518 | 906518 | 94127 | 94127 | 2021-01-13 | San Francisco | 75 | 335 | 21423 | |
906519 | 906519 | 94129 | 94129 | 2021-01-13 | San Francisco | 75 | 75 | 3994 | |
906520 | 906520 | 94130 | 94130 | 2021-01-13 | San Francisco | 75 | 84 | 3064 | |
906521 | 906521 | 94131 | 94131 | 2021-01-13 | San Francisco | 75 | 510 | 29902 | |
906522 | 906522 | 94132 | 94132 | 2021-01-13 | San Francisco | 75 | 619 | 31488 | |
906523 | 906523 | 94133 | 94133 | 2021-01-13 | San Francisco | 75 | 452 | 26527 | |
906524 | 906524 | 94134 | 94134 | 2021-01-13 | San Francisco | 75 | 2163 | 42471 | |
906525 | 906525 | 94158 | 94158 | 2021-01-13 | San Francisco | 75 | 254 | 7291 | |
907776 | 907776 | 94102 | 94102 | 2021-01-12 | San Francisco | 75 | 1378 | 31067 | |
907777 | 907777 | 94103 | 94103 | 2021-01-12 | San Francisco | 75 | 1369 | 28735 | |
907778 | 907778 | 94105 | 94105 | 2021-01-12 | San Francisco | 75 | 292 | 9155 | |
907779 | 907779 | 94107 | 94107 | 2021-01-12 | San Francisco | 75 | 800 | 29689 | |
907780 | 907780 | 94108 | 94108 | 2021-01-12 | San Francisco | 75 | 200 | 14550 | |
907781 | 907781 | 94109 | 94109 | 2021-01-12 | San Francisco | 75 | 1561 | 56677 | |
907782 | 907782 | 94110 | 94110 | 2021-01-12 | San Francisco | 75 | 3449 | 94161 | |
907783 | 907783 | 94111 | 94111 | 2021-01-12 | San Francisco | 75 | 60 | 3620 | |
907784 | 907784 | 94112 | 94112 | 2021-01-12 | San Francisco | 75 | 3951 | 85166 | |
907785 | 907785 | 94114 | 94114 | 2021-01-12 | San Francisco | 75 | 619 | 34754 | |
907786 | 907786 | 94115 | 94115 | 2021-01-12 | San Francisco | 75 | 958 | 35004 | |
907787 | 907787 | 94116 | 94116 | 2021-01-12 | San Francisco | 75 | 698 | 47823 | |
907788 | 907788 | 94117 | 94117 | 2021-01-12 | San Francisco | 75 | 663 | 44239 | |
907789 | 907789 | 94118 | 94118 | 2021-01-12 | San Francisco | 75 | 669 | 41468 | |
907790 | 907790 | 94121 | 94121 | 2021-01-12 | San Francisco | 75 | 650 | 43795 | |
907791 | 907791 | 94122 | 94122 | 2021-01-12 | San Francisco | 75 | 752 | 62131 | |
907792 | 907792 | 94123 | 94123 | 2021-01-12 | San Francisco | 75 | 585 | 25941 | |
907793 | 907793 | 94124 | 94124 | 2021-01-12 | San Francisco | 75 | 2895 | 35363 | |
907794 | 907794 | 94127 | 94127 | 2021-01-12 | San Francisco | 75 | 332 | 21423 | |
907795 | 907795 | 94129 | 94129 | 2021-01-12 | San Francisco | 75 | 73 | 3994 | |
907796 | 907796 | 94130 | 94130 | 2021-01-12 | San Francisco | 75 | 82 | 3064 | |
907797 | 907797 | 94131 | 94131 | 2021-01-12 | San Francisco | 75 | 506 | 29902 | |
907798 | 907798 | 94132 | 94132 | 2021-01-12 | San Francisco | 75 | 608 | 31488 | |
907799 | 907799 | 94133 | 94133 | 2021-01-12 | San Francisco | 75 | 446 | 26527 | |
907800 | 907800 | 94134 | 94134 | 2021-01-12 | San Francisco | 75 | 2148 | 42471 | |
907801 | 907801 | 94158 | 94158 | 2021-01-12 | San Francisco | 75 | 251 | 7291 | |
909052 | 909052 | 94102 | 94102 | 2021-01-11 | San Francisco | 75 | 1365 | 31067 | |
909053 | 909053 | 94103 | 94103 | 2021-01-11 | San Francisco | 75 | 1359 | 28735 | |
909054 | 909054 | 94105 | 94105 | 2021-01-11 | San Francisco | 75 | 289 | 9155 | |
909055 | 909055 | 94107 | 94107 | 2021-01-11 | San Francisco | 75 | 795 | 29689 | |
909056 | 909056 | 94108 | 94108 | 2021-01-11 | San Francisco | 75 | 197 | 14550 | |
909057 | 909057 | 94109 | 94109 | 2021-01-11 | San Francisco | 75 | 1548 | 56677 | |
909058 | 909058 | 94110 | 94110 | 2021-01-11 | San Francisco | 75 | 3429 | 94161 | |
909059 | 909059 | 94111 | 94111 | 2021-01-11 | San Francisco | 75 | 60 | 3620 | |
909060 | 909060 | 94112 | 94112 | 2021-01-11 | San Francisco | 75 | 3922 | 85166 | |
909061 | 909061 | 94114 | 94114 | 2021-01-11 | San Francisco | 75 | 613 | 34754 | |
909062 | 909062 | 94115 | 94115 | 2021-01-11 | San Francisco | 75 | 949 | 35004 | |
909063 | 909063 | 94116 | 94116 | 2021-01-11 | San Francisco | 75 | 691 | 47823 | |
909064 | 909064 | 94117 | 94117 | 2021-01-11 | San Francisco | 75 | 653 | 44239 | |
909065 | 909065 | 94118 | 94118 | 2021-01-11 | San Francisco | 75 | 665 | 41468 | |
909066 | 909066 | 94121 | 94121 | 2021-01-11 | San Francisco | 75 | 638 | 43795 | |
909067 | 909067 | 94122 | 94122 | 2021-01-11 | San Francisco | 75 | 745 | 62131 | |
909068 | 909068 | 94123 | 94123 | 2021-01-11 | San Francisco | 75 | 576 | 25941 | |
909069 | 909069 | 94124 | 94124 | 2021-01-11 | San Francisco | 75 | 2867 | 35363 | |
909070 | 909070 | 94127 | 94127 | 2021-01-11 | San Francisco | 75 | 331 | 21423 | |
909071 | 909071 | 94129 | 94129 | 2021-01-11 | San Francisco | 75 | 73 | 3994 | |
909072 | 909072 | 94130 | 94130 | 2021-01-11 | San Francisco | 75 | 81 | 3064 | |
909073 | 909073 | 94131 | 94131 | 2021-01-11 | San Francisco | 75 | 504 | 29902 | |
909074 | 909074 | 94132 | 94132 | 2021-01-11 | San Francisco | 75 | 604 | 31488 | |
909075 | 909075 | 94133 | 94133 | 2021-01-11 | San Francisco | 75 | 438 | 26527 | |
909076 | 909076 | 94134 | 94134 | 2021-01-11 | San Francisco | 75 | 2120 | 42471 | |
909077 | 909077 | 94158 | 94158 | 2021-01-11 | San Francisco | 75 | 247 | 7291 | |
910328 | 910328 | 94102 | 94102 | 2021-01-10 | San Francisco | 75 | 1354 | 31067 | |
910329 | 910329 | 94103 | 94103 | 2021-01-10 | San Francisco | 75 | 1330 | 28735 | |
910330 | 910330 | 94105 | 94105 | 2021-01-10 | San Francisco | 75 | 280 | 9155 | |
910331 | 910331 | 94107 | 94107 | 2021-01-10 | San Francisco | 75 | 788 | 29689 | |
910332 | 910332 | 94108 | 94108 | 2021-01-10 | San Francisco | 75 | 196 | 14550 | |
910333 | 910333 | 94109 | 94109 | 2021-01-10 | San Francisco | 75 | 1529 | 56677 | |
910334 | 910334 | 94110 | 94110 | 2021-01-10 | San Francisco | 75 | 3384 | 94161 | |
910335 | 910335 | 94111 | 94111 | 2021-01-10 | San Francisco | 75 | 59 | 3620 | |
910336 | 910336 | 94112 | 94112 | 2021-01-10 | San Francisco | 75 | 3868 | 85166 | |
910337 | 910337 | 94114 | 94114 | 2021-01-10 | San Francisco | 75 | 598 | 34754 | |
910338 | 910338 | 94115 | 94115 | 2021-01-10 | San Francisco | 75 | 923 | 35004 | |
910339 | 910339 | 94116 | 94116 | 2021-01-10 | San Francisco | 75 | 678 | 47823 | |
910340 | 910340 | 94117 | 94117 | 2021-01-10 | San Francisco | 75 | 635 | 44239 | |
910341 | 910341 | 94118 | 94118 | 2021-01-10 | San Francisco | 75 | 647 | 41468 | |
910342 | 910342 | 94121 | 94121 | 2021-01-10 | San Francisco | 75 | 626 | 43795 | |
910343 | 910343 | 94122 | 94122 | 2021-01-10 | San Francisco | 75 | 736 | 62131 | |
910344 | 910344 | 94123 | 94123 | 2021-01-10 | San Francisco | 75 | 560 | 25941 | |
910345 | 910345 | 94124 | 94124 | 2021-01-10 | San Francisco | 75 | 2819 | 35363 | |
910346 | 910346 | 94127 | 94127 | 2021-01-10 | San Francisco | 75 | 325 | 21423 | |
910347 | 910347 | 94129 | 94129 | 2021-01-10 | San Francisco | 75 | 71 | 3994 | |
910348 | 910348 | 94130 | 94130 | 2021-01-10 | San Francisco | 75 | 81 | 3064 | |
910349 | 910349 | 94131 | 94131 | 2021-01-10 | San Francisco | 75 | 488 | 29902 |
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 );