Spreadsheet: 212341d1360097637-merging-documents-with-similar-data-copy-of-cameras
Sheet: Sheet1

[NAME] | Location Name | Username | [NAME] | Location ID
11 | Spancky's | spanckys | Main
13 | Friar Tucks Pub | friars | [NAME]
15 | Cotati Yacht Club | cyc | Main
125 | Space Bar | nebar | Main
50 | Gravity | gravitysf | Main
17 | Stir Cocktail Lounge | stirsr | Main
18 | Maguire's Irish Pub | maguires | Main
19 | [NAME] | tex_wasabis | Main
21 | The Cantina | thecantina | Main Bar
197 | Trudy's Lounge | trudys | Main
152 | Space Bar | nebar | 3g Test
111 | [NAME] | vinylroom | Main
27 | The Vin Club | vinnostro | Main
29 | Siberia | siberia | Main Cam
30 | Rapture Nights | thevine | Main Cam
31 | [NAME] | kodiakjacks | [NAME]'s Corner
32 | [NAME] | kodiakjacks | Dance Floor
33 | The Rocks Bar and Lounge | therocks | Main Cam
34 | Pisco Latin Lounge | pisco | Main Cam
35 | [NAME] Brewery | dtjs | Stage Cam
37 | The Flamingo Lounge | flamingolounge | The Lounge
49 | [NAME] | jasperofarrells | Main
39 | [NAME] | kellerbier | Tavern Cam
40 | [NAME] | kellerbier | [NAME]
41 | MIST | mistsf | Down Stairs
42 | MIST | mistsf | Up Stairs
43 | The Blue Light | bluelight | Main
44 | Bar None | barnonesf | Main
63 | Murphy's Irish Pub | sonomapub | The Alley
45 | [NAME] Rock-n-Roll Sushi-BBQ | texwasabis | Main
46 | Irelands 32 | irelands32 | Main
51 | Ana's Cantina | anascantina | Main
52 | Farrington's Bar | farringtonsbar | Main
53 | [NAME]'s Pub | pattersonspub | Main
131 | Bella's Sports Pub | bellassportspub | Main
55 | 33 [NAME] Jazz | 33steaksboozejazz | Main
56 | Normal Street Bar | normalstreetbar | Main
57 | INK eats and drinks | ink | Main
61 | Mayes Oyster House &amp; [NAME] | mayes | Main
59 | Atmosphere | atmosphere | [NAME]
153 | Valley Tavern | valleytavern | Main
62 | [NAME] | mcteagues | Main
64 | Atmosphere | atmosphere | Main
65 | Bus Stop | busstop | Main
66 | Dive Bar | divebar | Main
67 | [NAME] | blowfishsr | Main
68 | O'Reillys Public House | oreillyspub | Main
69 | Molly Magees | mollymagees | Main
70 | Zen Lounge | zenlounge | Main
73 | Fibbar Magees | fibbarmagees | Main
74 | Suite 181 | suite181 | Main
75 | Horizon Lounge | horizonsf | Main
76 | SF Oyster Fest | oreillys | Main
77 | BASIC | basic | Main
252 | Old Town Tavern | ott | Main
194 | Mi [NAME] | mipueblito | Main
126 | Battle Of The Badges Block Party | specialevent | Stage Cam
81 | Fahrenheit Ultra Lounge | fahrenheit | Main
82 | Vessel | vesselsf | Main
83 | Vessel | vesselsf | DJ Booth
84 | Holy Cow | holycow | Main
85 | Blue Bar | bluebar | Main
88 | Mystic Theatre | mystictheatre | Stage Cam
87 | McNear's [NAME] | mcnears | Main
90 | Sanctuary Ultra Lounge | sanctuary | Main
91 | Sanctuary Ultra Lounge | sanctuary | Stage
224 | TRiP | tripsantamonica | stage
98 | The James Joyce | thejamesjoyce | Main
95 | Livermore Saloon | livermoresaloon | main
96 | Harmony Festival | harmonyfest | Main Stage
97 | Impala Lounge | impalasf | Main
99 | Velvet Jones | velvetjones | Main
100 | Statemynt | statemynt | Main
101 | Sandbar SB | sandbar | Main
102 | O'Malley's | omalleys | Main
103 | Sharkeez SB | sharkeezsb | Main
108 | [NAME] | neighborhood | Main
105 | Union Ale Brew Co. | unionale | Main Bar
106 | Union Ale Brew Co. | unionale | [NAME]
107 | EOS LOUNGE | eoslounge | Main
193 | [NAME] | telegraphhill | Main
110 | The Plough and Stars | ploughandstars | Main
113 | BAY ROADHOUSE | bayroadhouse | Main
114 | Club 101 | club101 | Main
116 | [NAME] | [NAME] | Main
250 | Battle Of The Brews | battleofthebrews | [NAME]
130 | Hennessey's Tavern | hennesyspb | Main
120 | Gaslamp Tavern | gaslamptavern | Main
121 | Sandbar Sports Grill | sandbarsd | Main
122 | Tavern at the Beach | tavernpb | Main
123 | Brewley's Pint | brewleys | Main
124 | Offshore Tavern | offshoretavern | Main
135 | True North Tavern | truenorthtavern | Main
129 | West Coast Tavern | westcoasttavern | Main
132 | Hennessey's Tavern Gaslamp | hennesseyssd | Main
133 | Bare Back Bar And Grill | bareback | Main
134 | Taste and Thirst on Fourth | tasteandthirstonfourth | Main
136 | [NAME] | clubcocomo | Main
137 | [NAME] | pandorakaraoke | Main
138 | Rockit Room | [NAME] | Main
139 | Rockit Room | [NAME] | Upstairs Stage
140 | The Stage Bar &amp; Grill | thestage | Main
141 | Wave House | wavehouse | Main
142 | Powerhouse Pub | powerhousepub | Stage
143 | Scarlet's [NAME] | scarlets | Main
253 | [NAME]'s Tavern | petestavern | Main
145 | Stout Brothers Irish Pub | stoutbros | Main
146 | Make Out Room | makeoutroom | Main
147 | [NAME] Brewery | dtjs | [NAME]
149 | Yager's | yagers | Main
150 | Test CAm | 3gvibe | LIVE
154 | The [NAME] | dubliner | Main
155 | La Verdad | laverdad | Main
156 | [NAME] | tommydoyles | The [NAME]
158 | SomaR Bar | somarbar | Main
159 | [NAME] | hopmonksonoma | Beer Garden
160 | All Asia | allasia | main
161 | Om Restaurant | Lounge | omlounge | Lounge
162 | ClubDon | [NAME] | Main Floor
163 | [NAME] | tommydoyleskendall | Main
164 | San Francisco Kickball Championship | kickballsf | KickBall Cam
165 | Nice Rack Billiards | nicerack | Main
166 | On The Hill Tavern | onthehilltavern | On The Hill Tavern
167 | [NAME] | kaamalounge | Main
168 | Mantra | mantra | Main
169 | [NAME] Sports Bar &amp; [NAME] | robjacks | Main
170 | [NAME] and Grill | samba | Main
171 | Darryls Corner Bar and Kitchen | darryls | [NAME]
174 | The Tap | thetap | Main
248 | [NAME]'s Tavern | davestavern | main
177 | Space Bar | nebar | Main
176 | Battery Park Bar &amp; Lounge | batterypark | Main
178 | Bar None NYC | barnone | Main
179 | a Verve Lounge @ Rudi's [NAME] | verve | Main
180 | [NAME] | goodyglovers | [NAME]
181 | [NAME] | paddyos | Main
5 | [NAME] | hopmonksonoma | Main
196 | Mr. [NAME]amp; Grill | mrbiggs | Main
185 | The Point | thepoint | The Point
186 | Bar None NYC | barnone | Back Room
188 | Bar 13 | bar13 | Main
189 | [NAME] | plumpizzeria | main
191 | Boss Tweeds | bosstweeds | Main
198 | EN Restuarant and Bar | enbarnyc | Main
199 | 1 Republik | 1republik | Main
200 | Whiskey's | whiskeys | Main
201 | Double Down Saloon | doubledown | Main
202 | Cadaques Tapas Bar | cadaques | Main
203 | Hennessy's | hennessys | Main
204 | Hooley House | hooleyhouse | Main
205 | Kelly's Sports Bar | [NAME] | Main
206 | The Pan American | thepanamerican | Main
207 | [NAME] | [NAME] | Main
208 | Vice Ultra Lounge | viceultralounge | Main
209 | Think Tank | thinktank | main
210 | [NAME] | kittyosheas | Main
251 | Blondie's Bar &amp; No Grill | blondies | Main
212 | NYE Countdown Ball 2010 | [NAME] | Main Room
214 | Vintage Lounge | vintagelounge | Main
215 | SOUTH | south | Main
216 | Cock n Bull British Pub | cocknbull | Main
217 | The Parkside Lounge | parksidegrill | Main
218 | Renee's Courtyard Cafe | renees | courtyard
219 | Field of Champions Sports Bar &amp; Grill | fieldofchamps | Main
220 | Tonic East | toniceast | main
221 | The Study Hall | studyhall | Main
222 | The Brooklyneer | brooklyneer | main
223 | The Mint Karaoke Lounge | themint | [NAME]
226 | [NAME] | wickedwillys | main
227 | Port 41 Bikini Bar | port41bikinibar | main
228 | The Hudson | thehudson | main lounge
229 | Beyond The Glory Sports Bar and Grill | 404 | Main
230 | [NAME]'s Nut House | antoniosnuthouse | Main
231 | Park Ave Pub | parkavepub | Main
232 | [NAME] | abbeytavern | Main
233 | Silver Cloud Bar &amp; Restaurant | silverclouds | Main
234 | La Casa Restaurant and Bar | lacasa | Main
235 | The Other Bar | theotherbar | Main
236 | [NAME] And Grill | tres | Main
238 | The Shannon | theshannon | main
239 | Tope | topesf | Main
240 | The Boardroom | boardroom | Main
241 | Frontier Room | frontierroom | Main
242 | Belltown Billiards &amp; Lounge | belltownbilliards | Main
243 | Queen City Grill | queencitygrill | Main
244 | [NAME] | belltownpub | Main
245 | Harvelle's | harvelles | Main
246 | The Office Bar &amp; Grill | theoffice | Main
247 | [NAME] | carlosclub | Main
249 | [NAME] | patrickryans | main
254 | [NAME]'s Cantina | pedroscantina | Main
255 | MoMo's | [NAME] | Main