Caffè Latte Prices Across Singapore

Shows the current price of Caffè Latte at all Starbucks locations in Singapore

Custom SQL query returning 144 rows (hide) 

SELECT s.id AS store_id, s.store_name, s.longitude, s.latitude, m.name AS item_name, p.base_price / 100.0 AS price_sgd FROM stores s JOIN menu_items m ON s.id = m.store_id JOIN item_prices p ON m.id = p.item_id AND s.id = p.store_id WHERE m.name = 'Caffè Latte' AND p.effective_date = (SELECT MAX(effective_date) FROM item_prices WHERE item_id = m.id AND store_id = s.id) ORDER BY s.store_name

Edit SQL

This data as json, CSV

store_idstore_namelongitudelatitudeitem_nameprice_sgd
95 100 AM 103.84336004841293 1.2744762533133427 Caffè Latte 6.8
91 20 Anson Road 103.84576837425175 1.2754698267694589 Caffè Latte 6.8
123 25 North Bridge Road (Formerly EFG Building) 103.84973662031356 1.290176151201081 Caffè Latte 6.8
92 313@Somerset 103.83827288057047 1.3009614225037176 Caffè Latte 6.8
76 6 Battery Road 103.8515953391642 1.2855279675015479 Caffè Latte 6.8
93 78 Shenton Way 103.84499177146368 1.2732563942427133 Caffè Latte 6.8
80 Active Garden 103.86217820692866 1.285597976695167 Caffè Latte 7.4
94 Anchorpoint 103.80526334038882 1.288806695942928 Caffè Latte 6.8
96 Ang Mo Kio Hub 103.84817393716195 1.3695477009462065 Caffè Latte 6.8
97 Aperia Mall 103.86390722682079 1.3098816817003787 Caffè Latte 6.8
98 Asia Square Tower 2 103.85039468743703 1.2781797171626241 Caffè Latte 6.8
99 Bedok Mall 103.9298294816494 1.3249418185613588 Caffè Latte 6.8
102 Biopolis 103.79211394755855 1.3032225724864084 Caffè Latte 6.8
85 Bird Paradise 103.7832165441795 1.4070052772406347 Caffè Latte 7.4
104 Bishan Community Club 103.85070501123317 1.3497090871585333 Caffè Latte 6.8
100 Bugis Junction 103.85595780359935 1.2994718657988176 Caffè Latte 6.8
101 Bugis+ 103.85423610304878 1.2998834688602505 Caffè Latte 6.8
103 Bukit Panjang Plaza 103.76420145920065 1.3800363058326912 Caffè Latte 6.8
106 Canberra Plaza 103.8305502570709 1.4433378287670704 Caffè Latte 6.8
117 Capital Tower 103.84741328481394 1.2778093374598514 Caffè Latte 6.8
114 Centrepoint 103.83974511960265 1.301837532059199 Caffè Latte 6.8
87 Century Square 103.94373 1.35335 Caffè Latte 6.8
108 Changi City Point (near Expo MRT) 103.96274593606412 1.3341132101031397 Caffè Latte 6.8
109 Changi General Hospital 103.94938047531704 1.3411069163917604 Caffè Latte 6.8
118 Chinatown Point 103.84461034260012 1.284867097126435 Caffè Latte 6.8
113 Cintech IV 103.79011891320613 1.2895713937986395 Caffè Latte 6.8
119 City House 103.84962759420686 1.2815510237690966 Caffè Latte 6.8
116 City Square Mall 103.85629751574002 1.3113218743508066 Caffè Latte 6.8
111 CityLink Mall 103.8557999814162 1.2920292851775692 Caffè Latte 6.8
110 Clementi Mall 103.76455158883797 1.3153525854422063 Caffè Latte 6.8
112 Compass One 103.89492177953133 1.3924116664664496 Caffè Latte 6.8
115 Concourse 103.86261130157742 1.3011253541619427 Caffè Latte 6.8
105 Coronation Shopping Plaza 103.81030139080181 1.323724631853954 Caffè Latte 6.8
121 Delfi Orchard 103.8287946411045 1.3071017634212199 Caffè Latte 6.8
122 Downtown East 103.95492003454677 1.3774098922229518 Caffè Latte 6.8
124 East Point Mall 103.95317219999983 1.3425228592028438 Caffè Latte 6.8
125 Far East Square 103.848542 1.283438 Caffè Latte 6.8
150 Frasers Tower 103.84691740793842 1.2801037730240543 Caffè Latte 6.8
126 Fusionopolis (Connexis) 103.78757794662616 1.2987668068940275 Caffè Latte 6.8
127 Gardens by the Bay 103.86542571226353 1.282403798393352 Caffè Latte 7.4
129 Gateway 103.85854868175127 1.2986340796420446 Caffè Latte 6.8
81 Gleneagles Hospital 103.82024999979852 1.3075061943712722 Caffè Latte 6.8
128 Great World City 103.83196467590743 1.2935487114950235 Caffè Latte 6.8
50 Guoco Tower (Formerly Tanjong Pagar Centre) 103.845018385909 1.2767241682033998 Caffè Latte 6.8
66 Harbourfront Centre 103.82006400674719 1.264792288443552 Caffè Latte 6.8
133 HillV2 103.7645253794577 1.363107827128155 Caffè Latte 6.8
132 Hillion Mall 103.76300499419207 1.3783119982110605 Caffè Latte 6.8
135 HomeTeamNS 103.74978335108104 1.366017815689397 Caffè Latte 6.8
131 Hong Leong Building 103.85106281012152 1.2813115056091926 Caffè Latte 6.8
130 Hougang 1 (Street 91) 103.87991965061194 1.3754156690568171 Caffè Latte 6.8
134 Hougang Mall (Near Hougang MRT station) 103.89381539157877 1.372562868038263 Caffè Latte 6.8
136 ION Orchard 103.83160077927374 1.3040916696552682 Caffè Latte 7.1
139 JEM 103.74301641156798 1.3332725019054268 Caffè Latte 6.8
138 Jalan Jamal (Siglap) 103.92549628616887 1.3129672090756541 Caffè Latte 6.8
137 Jelita 103.78607245473991 1.3175332620454525 Caffè Latte 6.8
69 Jewel Changi Airport 103.990252 1.360062 Caffè Latte 6.8
70 Jurong Lake Gardens (Lakeside House) 103.72203345568569 1.3436477462019298 Caffè Latte 6.8
140 Jurong Point 103.70561066041748 1.3389640282245534 Caffè Latte 6.8
142 Kallang Wave Mall 103.87334381318998 1.3025862066370928 Caffè Latte 6.8
143 Kampung Admiralty 103.80063742317084 1.4398808390931939 Caffè Latte 6.8
144 Katong Square 103.90437341229216 1.3051943866054023 Caffè Latte 6.8
141 Keat Hong Community Club 103.74471518459058 1.3842517409900505 Caffè Latte 6.8
90 Kinex (Formerly OneKM Shopping Mall) 103.89444224214722 1.3151902213349609 Caffè Latte 6.8
83 Kopitiam City 103.89374346485192 1.3832946878327095 Caffè Latte 6.8
78 Lazada One 103.85005736252644 1.2977677225309534 Caffè Latte 6.8
145 Liat Towers 103.83089110504557 1.3052172453040718 Caffè Latte 6.8
10 Maple Tree Business City 2 103.799603 1.275837 Caffè Latte 6.8
9 Mapletree Business City (Mapletree @ 20) 103.8002305633266 1.274459289493281 Caffè Latte 6.8
147 Marina Bay Link Mall 103.85400908051018 1.2806785391302193 Caffè Latte 6.8
148 Marina Bay Sands 103.8600215664893 1.2858193235938349 Caffè Latte 7.4
146 Marina Square 103.85798844135212 1.291016691052238 Caffè Latte 6.8
149 Micron 103.79464068978261 1.4557035883823544 Caffè Latte 6.2
11 Millenia Walk 103.85964822654933 1.2937495431642239 Caffè Latte 6.8
14 Mt Elizabeth Novena Hospital 103.84410210313885 1.3220256011083584 Caffè Latte 6.8
21 NEX 103.8722375136421 1.350645230403476 Caffè Latte 6.8
15 NTU North Spine 103.67979288228467 1.3470570922503566 Caffè Latte 6.2
45 NUS Techno Edge 103.77123131346745 1.2982424291128967 Caffè Latte 6.2
57 NUS University Town 103.77310800858356 1.3054573350983387 Caffè Latte 6.2
20 NUS Wet Science Building 103.7800522351932 1.2960289817071604 Caffè Latte 6.2
18 Ng Teng Fong General Hsptl 103.744171 1.334791 Caffè Latte 6.8
16 Northpoint City 103.83563269554595 1.4294804213691765 Caffè Latte 6.8
17 Novena Square (Office Tower) 103.84402476858293 1.3197669231252953 Caffè Latte 6.8
23 OCBC Centre 103.84984117295645 1.2852082033992118 Caffè Latte 6.8
22 Oasis Terraces 103.91307526475802 1.4023905203899267 Caffè Latte 6.8
24 One Fullerton 103.85383566289575 1.2857998525962435 Caffè Latte 7.4
89 One George 103.84796697136352 1.286044033553302 Caffè Latte 6.8
88 One Holland Village 103.79366403445347 1.3116395213287633 Caffè Latte 6.8
19 One@KentRidge 103.78475103373614 1.2941093858517232 Caffè Latte 6.8
25 Orchard Cineleisure 103.83679924304961 1.3013579136986093 Caffè Latte 6.8
26 Orchard Gateway 103.83903803561407 1.300599587933889 Caffè Latte 6.8
48 Our Tampines Hub 103.9410406550365 1.3539834314643702 Caffè Latte 6.8
5 Pacific Plaza 103.83235999612769 1.3064559727541363 Caffè Latte 6.8
27 Paragon 103.83562282328074 1.3034968684935992 Caffè Latte 6.8
28 Parkland Green 103.9066947712167 1.299120896713439 Caffè Latte 6.8
7 Parkway Parade 103.90510764088063 1.3020488971267967 Caffè Latte 6.8
3 Paya Lebar Quarter 103.89297634073242 1.3174697650877074 Caffè Latte 6.8
8 Plaza 8 103.96541920489143 1.3336620479021386 Caffè Latte 6.8
6 Plaza Singapura 103.8450932509819 1.2999737336232093 Caffè Latte 6.8
77 Raffles City (Level 2) 103.85355852507783 1.2936158207631172 Caffè Latte 6.8
72 Raffles Hospital 103.85709769168228 1.3014324906162043 Caffè Latte 6.8
29 Republic Plaza 103.85051454057226 1.283542273963993 Caffè Latte 6.8
31 Resorts World Sentosa 103.81995055921236 1.2563162987945744 Caffè Latte 7.4
30 River Wonders 103.79018571225885 1.404122251367382 Caffè Latte 7.4
2 Rochester Park 103.787771 1.305575 Caffè Latte 6.8
34 SIM 103.77575927517859 1.3291942323469619 Caffè Latte 6.8
38 Science Park II 103.78271597247394 1.2875997598501423 Caffè Latte 6.8
36 Seletar Mall 103.87592021716392 1.3913306483723507 Caffè Latte 6.8
33 SingHealth Tower 103.83549225809509 1.278160948553767 Caffè Latte 6.8
35 Singapore Land Tower 103.85207562378218 1.284304052232448 Caffè Latte 6.8
37 Singapore Management University 103.84948188142786 1.2977165955146643 Caffè Latte 6.8
32 Singapore Polytechnic 103.77710274548849 1.309735951939243 Caffè Latte 6.2
73 Starbucks Sentosa Sensoryscape 103.81920467498594 1.2543227232260383 Caffè Latte 7.4
41 Sun Plaza 103.81964989636464 1.4481300505226495 Caffè Latte 6.8
39 Suntec City Tower 3 (Level 2) 103.85945247994971 1.2955532014082505 Caffè Latte 6.8
40 Suntec City Tower 5 (Level 1) 103.85785121323164 1.2948830725074016 Caffè Latte 6.8
79 Takashimaya 103.83470946148468 1.3024522449933018 Caffè Latte 6.8
52 Tampines Mall #01-00 103.944352 1.352038 Caffè Latte 6.8
53 Tampines West Community Club 103.9357675726027 1.3489228400981055 Caffè Latte 6.8
46 Tanglin Mall 103.82341598273729 1.30495881632794 Caffè Latte 6.8
47 Tekka Place 103.85117856471287 1.3049764187014896 Caffè Latte 6.8
107 The Central 103.84690356661282 1.288887648969878 Caffè Latte 6.8
1 The Metropolis 103.79130178222705 1.3058152595075494 Caffè Latte 6.8
4 The Poiz Centre 103.868562 1.331172 Caffè Latte 6.8
75 The Rail Mall 103.7681092640099 1.357687029789692 Caffè Latte 6.8
86 The Woodleigh Mall 103.87129579504177 1.3386580600531135 Caffè Latte 6.8
84 Thomson Plaza 2 103.83093531399999 1.3548362099078486 Caffè Latte 6.8
44 Tiong Bahru Plaza 103.82731128418924 1.2862303901832601 Caffè Latte 6.8
51 Toa Payoh HDB Hub 103.84886385753722 1.3325995725284963 Caffè Latte 6.8
54 UE Square 103.84284557936303 1.2929571712139238 Caffè Latte 6.8
55 United Square 103.84391611172119 1.3176407540341748 Caffè Latte 6.8
56 Universal Studios Singapore 103.82189288014406 1.2559177344714965 Caffè Latte 7.4
59 Valley Point 103.82652109567414 1.292911075924222 Caffè Latte 6.8
58 VivoCity 103.82291216151958 1.264179213584204 Caffè Latte 6.8
67 Waterway Point 103.90172468118433 1.4064968020004636 Caffè Latte 6.8
64 West Coast Plaza 103.7655724954522 1.3033050933723684 Caffè Latte 6.8
63 West Mall 103.74916898157232 1.3500076890078427 Caffè Latte 6.8
61 Westgate 103.74244647455853 1.3337458129608375 Caffè Latte 6.8
65 White Sands 103.94956165275947 1.3723443293558875 Caffè Latte 6.8
60 Wilkie Edge 103.84985208097936 1.301922829500378 Caffè Latte 6.8
74 Wisma Atria 103.83326260532785 1.3037369170500155 Caffè Latte 6.8
120 Woodlands Civic Centre 103.78671968353004 1.4351083279891235 Caffè Latte 6.8
62 Woodlands Xchange (Woodlands MRT) 103.78697913137697 1.4368565958477197 Caffè Latte 6.8
71 YewTee Point 103.74649984732062 1.3968877277759426 Caffè Latte 6.8
68 Zhongshan Mall 103.84685441934342 1.3268912859835464 Caffè Latte 6.8