latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
110 rows where county = "San Diego" and "date" is on date 2022-06-23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
236717 | 236717 | 91910 | 91910: Chula Vista | 2022-06-23 | San Diego | 73 | 24583 | 83834 | |
236718 | 236718 | 91911 | 91911: Chula Vista | 2022-06-23 | San Diego | 73 | 28365 | 84819 | |
236719 | 236719 | 91913 | 91913: Chula Vista | 2022-06-23 | San Diego | 73 | 15875 | 51077 | |
236720 | 236720 | 91914 | 91914: Chula Vista | 2022-06-23 | San Diego | 73 | 4625 | 16781 | |
236721 | 236721 | 91915 | 91915: Chula Vista | 2022-06-23 | San Diego | 73 | 9158 | 31120 | |
236722 | 236722 | 91916 | 91916: Descanso | 2022-06-23 | San Diego | 73 | 316 | 0 | |
236723 | 236723 | 91917 | 91917: Dulzura | 2022-06-23 | San Diego | 73 | 285 | 0 | |
236724 | 236724 | 91931 | 91931: Guatay | 2022-06-23 | San Diego | 73 | 42 | 0 | |
236725 | 236725 | 91932 | 91932: Imperial Beach | 2022-06-23 | San Diego | 73 | 7347 | 27448 | |
236726 | 236726 | 91934 | 91934: Jacumba | 2022-06-23 | San Diego | 73 | 102 | 0 | |
236727 | 236727 | 91935 | 91935: Jamul | 2022-06-23 | San Diego | 73 | 1849 | 0 | |
236728 | 236728 | 91941 | 91941: La Mesa | 2022-06-23 | San Diego | 73 | 7724 | 34226 | |
236729 | 236729 | 91942 | 91942: La Mesa | 2022-06-23 | San Diego | 73 | 8493 | 40025 | |
236730 | 236730 | 91945 | 91945: Lemon Grove | 2022-06-23 | San Diego | 73 | 8704 | 27208 | |
236731 | 236731 | 91950 | 91950: National City | 2022-06-23 | San Diego | 73 | 18985 | 58536 | |
236732 | 236732 | 91962 | 91962: Pine Valley | 2022-06-23 | San Diego | 73 | 319 | 0 | |
236733 | 236733 | 91963 | 91963: Potrero | 2022-06-23 | San Diego | 73 | 349 | 0 | |
236734 | 236734 | 91977 | 91977: Spring Valley | 2022-06-23 | San Diego | 73 | 17735 | 60995 | |
236735 | 236735 | 91978 | 91978: Spring Valley | 2022-06-23 | San Diego | 73 | 2404 | 0 | |
236736 | 236736 | 91980 | 91980: Tecate | 2022-06-23 | San Diego | 73 | 263 | 0 | |
236737 | 236737 | 92003 | 92003: Bonsall | 2022-06-23 | San Diego | 73 | 917 | 0 | |
236738 | 236738 | 92004 | 92004: Borrego Springs | 2022-06-23 | San Diego | 73 | 343 | 0 | |
236739 | 236739 | 92007 | 92007: Cardiff by the Sea | 2022-06-23 | San Diego | 73 | 1649 | 11483 | |
236740 | 236740 | 92008 | 92008: Carlsbad | 2022-06-23 | San Diego | 73 | 5065 | 29652 | |
236741 | 236741 | 92009 | 92009: Carlsbad | 2022-06-23 | San Diego | 73 | 7030 | 43338 | |
236742 | 236742 | 92010 | 92010: Carlsbad | 2022-06-23 | San Diego | 73 | 3282 | 16681 | |
236743 | 236743 | 92011 | 92011: Carlsbad | 2022-06-23 | San Diego | 73 | 3624 | 23963 | |
236744 | 236744 | 92014 | 92014: Del Mar | 2022-06-23 | San Diego | 73 | 1781 | 14139 | |
236745 | 236745 | 92019 | 92019: El Cajon | 2022-06-23 | San Diego | 73 | 11264 | 45094 | |
236746 | 236746 | 92020 | 92020: El Cajon | 2022-06-23 | San Diego | 73 | 16696 | 61896 | |
236747 | 236747 | 92021 | 92021: El Cajon | 2022-06-23 | San Diego | 73 | 18265 | 68655 | |
236748 | 236748 | 92024 | 92024: Encinitas | 2022-06-23 | San Diego | 73 | 8975 | 56390 | |
236749 | 236749 | 92025 | 92025: Escondido | 2022-06-23 | San Diego | 73 | 13360 | 51820 | |
236750 | 236750 | 92026 | 92026: Escondido | 2022-06-23 | San Diego | 73 | 13070 | 56272 | |
236751 | 236751 | 92027 | 92027: Escondido | 2022-06-23 | San Diego | 73 | 15327 | 54202 | |
236752 | 236752 | 92028 | 92028: Fallbrook | 2022-06-23 | San Diego | 73 | 9790 | 49009 | |
236753 | 236753 | 92029 | 92029: Escondido | 2022-06-23 | San Diego | 73 | 4264 | 21201 | |
236754 | 236754 | 92036 | 92036: Julian | 2022-06-23 | San Diego | 73 | 423 | 0 | |
236755 | 236755 | 92037 | 92037: La Jolla | 2022-06-23 | San Diego | 73 | 6602 | 43283 | |
236756 | 236756 | 92040 | 92040: Lakeside | 2022-06-23 | San Diego | 73 | 10179 | 44105 | |
236757 | 236757 | 92054 | 92054: Oceanside | 2022-06-23 | San Diego | 73 | 8330 | 42441 | |
236758 | 236758 | 92055 | 92055: Camp Pendleton | 2022-06-23 | San Diego | 73 | 1681 | 36726 | |
236759 | 236759 | 92056 | 92056: Oceanside | 2022-06-23 | San Diego | 73 | 11604 | 55369 | |
236760 | 236760 | 92057 | 92057: Oceanside | 2022-06-23 | San Diego | 73 | 13605 | 55753 | |
236761 | 236761 | 92058 | 92058: Oceanside | 2022-06-23 | San Diego | 73 | 8512 | 24170 | |
236762 | 236762 | 92059 | 92059: Pala | 2022-06-23 | San Diego | 73 | 549 | 0 | |
236763 | 236763 | 92060 | 92060: Palomar Mountain | 2022-06-23 | San Diego | 73 | 88 | 0 | |
236764 | 236764 | 92061 | 92061: Pauma Valley | 2022-06-23 | San Diego | 73 | 610 | 0 | |
236765 | 236765 | 92064 | 92064: Poway | 2022-06-23 | San Diego | 73 | 9033 | 50435 | |
236766 | 236766 | 92065 | 92065: Ramona | 2022-06-23 | San Diego | 73 | 7453 | 36256 | |
236767 | 236767 | 92066 | 92066: Ranchita | 2022-06-23 | San Diego | 73 | 41 | 0 | |
236768 | 236768 | 92067 | 92067: Rancho Santa Fe | 2022-06-23 | San Diego | 73 | 1563 | 0 | |
236769 | 236769 | 92069 | 92069: San Marcos | 2022-06-23 | San Diego | 73 | 12830 | 51172 | |
236770 | 236770 | 92070 | 92070: Santa Ysabel | 2022-06-23 | San Diego | 73 | 312 | 0 | |
236771 | 236771 | 92071 | 92071: Santee | 2022-06-23 | San Diego | 73 | 12898 | 58213 | |
236772 | 236772 | 92075 | 92075: Solana Beach | 2022-06-23 | San Diego | 73 | 1722 | 12976 | |
236773 | 236773 | 92078 | 92078: San Marcos | 2022-06-23 | San Diego | 73 | 10201 | 50973 | |
236774 | 236774 | 92081 | 92081: Vista | 2022-06-23 | San Diego | 73 | 6177 | 32889 | |
236775 | 236775 | 92082 | 92082: Valley Center | 2022-06-23 | San Diego | 73 | 4470 | 17680 | |
236776 | 236776 | 92083 | 92083: Vista | 2022-06-23 | San Diego | 73 | 12296 | 39155 | |
236777 | 236777 | 92084 | 92084: Vista | 2022-06-23 | San Diego | 73 | 13190 | 49040 | |
236778 | 236778 | 92086 | 92086: Warner Springs | 2022-06-23 | San Diego | 73 | 147 | 0 | |
236779 | 236779 | 92091 | 92091: Rancho Santa Fe | 2022-06-23 | San Diego | 73 | 142 | 0 | |
236780 | 236780 | 92093 | 92093: La Jolla | 2022-06-23 | San Diego | 73 | 3276 | 11299 | |
236781 | 236781 | 92096 | 92096: San Marcos | 2022-06-23 | San Diego | 73 | 34 | 0 | |
236782 | 236782 | 92101 | 92101: San Diego | 2022-06-23 | San Diego | 73 | 11766 | 60694 | |
236783 | 236783 | 92102 | 92102: San Diego | 2022-06-23 | San Diego | 73 | 12290 | 42331 | |
236784 | 236784 | 92103 | 92103: San Diego | 2022-06-23 | San Diego | 73 | 6640 | 39687 | |
236785 | 236785 | 92104 | 92104: San Diego | 2022-06-23 | San Diego | 73 | 9760 | 52095 | |
236786 | 236786 | 92105 | 92105: San Diego | 2022-06-23 | San Diego | 73 | 18983 | 67077 | |
236787 | 236787 | 92106 | 92106: San Diego | 2022-06-23 | San Diego | 73 | 3348 | 22209 | |
236788 | 236788 | 92107 | 92107: San Diego | 2022-06-23 | San Diego | 73 | 4758 | 30971 | |
236789 | 236789 | 92108 | 92108: San Diego | 2022-06-23 | San Diego | 73 | 5786 | 27342 | |
236790 | 236790 | 92109 | 92109: San Diego | 2022-06-23 | San Diego | 73 | 9596 | 54115 | |
236791 | 236791 | 92110 | 92110: San Diego | 2022-06-23 | San Diego | 73 | 6782 | 29878 | |
236792 | 236792 | 92111 | 92111: San Diego | 2022-06-23 | San Diego | 73 | 9910 | 47943 | |
236793 | 236793 | 92113 | 92113: San Diego | 2022-06-23 | San Diego | 73 | 18013 | 48550 | |
236794 | 236794 | 92114 | 92114: San Diego | 2022-06-23 | San Diego | 73 | 21141 | 58032 | |
236795 | 236795 | 92115 | 92115: San Diego | 2022-06-23 | San Diego | 73 | 15618 | 61463 | |
236796 | 236796 | 92116 | 92116: San Diego | 2022-06-23 | San Diego | 73 | 5977 | 36946 | |
236797 | 236797 | 92117 | 92117: San Diego | 2022-06-23 | San Diego | 73 | 9994 | 52122 | |
236798 | 236798 | 92118 | 92118: Coronado | 2022-06-23 | San Diego | 73 | 2676 | 17956 | |
236799 | 236799 | 92119 | 92119: San Diego | 2022-06-23 | San Diego | 73 | 4549 | 23730 | |
236800 | 236800 | 92120 | 92120: San Diego | 2022-06-23 | San Diego | 73 | 6197 | 29448 | |
236801 | 236801 | 92121 | 92121: San Diego | 2022-06-23 | San Diego | 73 | 893 | 0 | |
236802 | 236802 | 92122 | 92122: San Diego | 2022-06-23 | San Diego | 73 | 6848 | 48952 | |
236803 | 236803 | 92123 | 92123: San Diego | 2022-06-23 | San Diego | 73 | 6960 | 33643 | |
236804 | 236804 | 92124 | 92124: San Diego | 2022-06-23 | San Diego | 73 | 5421 | 31705 | |
236805 | 236805 | 92126 | 92126: San Diego | 2022-06-23 | San Diego | 73 | 15570 | 76748 | |
236806 | 236806 | 92127 | 92127: San Diego | 2022-06-23 | San Diego | 73 | 8865 | 49508 | |
236807 | 236807 | 92128 | 92128: San Diego | 2022-06-23 | San Diego | 73 | 8345 | 51732 | |
236808 | 236808 | 92129 | 92129: San Diego | 2022-06-23 | San Diego | 73 | 9527 | 52624 | |
236809 | 236809 | 92130 | 92130: San Diego | 2022-06-23 | San Diego | 73 | 8687 | 59593 | |
236810 | 236810 | 92131 | 92131: San Diego | 2022-06-23 | San Diego | 73 | 5523 | 36090 | |
236811 | 236811 | 92134 | 92134: San Diego | 2022-06-23 | San Diego | 73 | 108 | 0 | |
236812 | 236812 | 92135 | 92135: Coronado | 2022-06-23 | San Diego | 73 | 143 | 0 | |
236813 | 236813 | 92136 | 92136: San Diego | 2022-06-23 | San Diego | 73 | 386 | 12492 | |
236814 | 236814 | 92139 | 92139: San Diego | 2022-06-23 | San Diego | 73 | 10232 | 33271 | |
236815 | 236815 | 92140 | 92140: San Diego | 2022-06-23 | San Diego | 73 | 187 | 0 | |
236816 | 236816 | 92145 | 92145: San Diego | 2022-06-23 | San Diego | 73 | 36 | 0 |
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 );