Open Street Map snippets
How to get a list bars around Colosseo
You can visit the
wiki page on Open Street Map about the tag amenity=bar.
CSV output
You just have to execute the following query to get a full list in CSV.
[out:csv( ::id,"name",::count,"addr:street","addr:housenumber",::lat,::lon;
true; "|"
)][timeout:30];
rel[name="Colosseo"][tourism="attraction"];
(nwr[amenity=bar](around:1000.0);
);
out center;
out count;
| @id | name | @count | addr:street | addr:housenumber | @lat | @lon |
|---|---|---|---|---|---|---|
| 962348457 | Ice Club | Via della Madonna dei Monti | 18/19 | 41.8940916 | 12.4885583 | |
| 1572583515 | The Public House | Via delle Tre Cannelle | 8 | 41.8966226 | 12.4860016 | |
| 1701218666 | Camden Town | 41.8885564 | 12.4950752 | |||
| 2092013187 | My Bar | Via di San Giovanni in Laterano | 12 | 41.8898973 | 12.4946166 | |
| 2128214065 | San Clemente | Via di San Giovanni in Laterano | 126 | 41.8889233 | 12.4979123 | |
| 2515010849 | Black Market | Via Panisperna | 101 | 41.8972361 | 12.4947481 | |
| 3217327590 | "0,75" | Via dei Cerchi | 65 | 41.8879519 | 12.4839357 | |
| 3320437843 | La Follia | Via Capo d'Africa | 26 | 41.8888415 | 12.4952573 | |
| 4192923989 | Anima Mundi | Via del Velabro | 1 | 41.8893924 | 12.4835302 | |
| 4260275091 | Nag's Head | Via Quattro Novembre | 138 | 41.8972902 | 12.4845518 | |
| 4367948894 | Brewdog Roma | Via delle Terme di Tito | 80 | 41.8917617 | 12.4929546 | |
| 4394361989 | Bar Circo Massimo | Viale Aventino | 41.8833093 | 12.4873351 | ||
| 4455036165 | 41.8964420 | 12.4965110 | ||||
| 4455036167 | 41.8968471 | 12.4989455 | ||||
| 4556016298 | Divin Ostilia | 41.8895287 | 12.4954434 | |||
| 4847967789 | 41.8897275 | 12.4953425 | ||||
| 4886058322 | Antico Caffe del Brasile - Torrefazione | Via dei Serpenti | 41.8957583 | 12.4902776 | ||
| 6296292485 | Shamrock Irish bar & restaurant | 41.8887547 | 12.4955163 | |||
| 6573371207 | Voodoo Bar | Via delle Terme di Traiano | 4 | 41.8934237 | 12.4980792 | |
| 6573379647 | The Sanctuary - Eco Retreat | Via delle Terme di Traiano | 4 | 41.8934297 | 12.4983340 | |
| 6695937286 | Antigallery | Piazza degli Zingari | 3 | 41.8955791 | 12.4929538 | |
| 6698598585 | Blackmarket Hall | Via dei Ciancaleoni | 31 | 41.8967525 | 12.4935707 | |
| 6775922386 | Voodoo Bar | 41.8934174 | 12.4980998 | |||
| 7896481085 | Coco Caffe | 41.8924968 | 12.4925672 | |||
| 8511677046 | sMa Bar | 41.8876254 | 12.5033537 | |||
| 8561505117 | 41.8901331 | 12.4955767 | ||||
| 0 | 26 |
JSON output
You just have to execute the following query to get a full list in JSON format.
[out:json][timeout:30];
el[name="Colosseo"][tourism="attraction"];
(nwr[amenity=bar](around:1000.0);
);
out center;
out count;
{
"version": 0.6,
"generator": "Overpass API 0.7.56.9 76e5016d",
"osm3s": {
"timestamp_osm_base": "2021-07-22T16:53:11Z",
"copyright": "The data included in this document is from www.openstreetmap.org. The data is made available under ODbL."
},
"elements": [
{
"type": "node",
"id": 962348457,
"lat": 41.8940916,
"lon": 12.4885583,
"tags": {
"addr:housenumber": "18/19",
"addr:street": "Via della Madonna dei Monti",
"amenity": "bar",
"email": "info@iceclubroma.it",
"name": "Ice Club",
"opening_hours": "Mo-Su 17:00-01:00",
"phone": "+39 06 97845581",
"website": "http://iceclubroma.it/"
}
},
{
"type": "node",
"id": 1572583515,
"lat": 41.8966226,
"lon": 12.4860016,
"tags": {
"addr:housenumber": "8",
"addr:postcode": "00187",
"addr:street": "Via delle Tre Cannelle",
"amenity": "bar",
"internet_access": "wlan",
"name": "The Public House",
"opening_hours": "Mo-Su 12:00-02:00",
"phone": "+39 06 679 7591",
"website": "http://www.thepublichouserome.com/"
}
},
{
"type": "node",
"id": 1701218666,
"lat": 41.8885564,
"lon": 12.4950752,
"tags": {
"amenity": "bar",
"name": "Camden Town"
}
},
{
"type": "node",
"id": 2092013187,
"lat": 41.8898973,
"lon": 12.4946166,
"tags": {
"addr:housenumber": "12",
"addr:street": "Via di San Giovanni in Laterano",
"amenity": "bar",
"name": "My Bar",
"operator": "Anfiteatro S.r.l.",
"phone": "+39 06 7004425",
"ref:vatin": "IT06747541008"
}
},
{
"type": "node",
"id": 2128214065,
"lat": 41.8889233,
"lon": 12.4979123,
"tags": {
"addr:city": "Roma",
"addr:country": "IT",
"addr:housenumber": "126",
"addr:postcode": "00184",
"addr:street": "Via di San Giovanni in Laterano",
"amenity": "bar",
"cuisine": "italian",
"name": "San Clemente",
"source": "GPS",
"website": "http://www.iclementini.it/"
}
},
{
"type": "node",
"id": 2515010849,
"lat": 41.8972361,
"lon": 12.4947481,
"tags": {
"addr:city": "Roma",
"addr:country": "IT",
"addr:housenumber": "101",
"addr:postcode": "00184",
"addr:street": "Via Panisperna",
"amenity": "bar",
"email": "blackmarketmonti@gmail.com",
"internet_access": "yes",
"internet_access:fee": "no",
"microbrewery": "no",
"name": "Black Market",
"opening_hours": "15:00-02:00",
"phone": "+39 3398227541",
"smoking": "no",
"website": "http://black-market.it"
}
},
{
"type": "node",
"id": 3217327590,
"lat": 41.8879519,
"lon": 12.4839357,
"tags": {
"addr:city": "Roma",
"addr:housenumber": "65",
"addr:street": "Via dei Cerchi",
"amenity": "bar",
"name": "0,75",
"opening_hours": "Mo-Su 11:00-02:00",
"phone": "+39 066875706"
}
},
{
"type": "node",
"id": 3320437843,
"lat": 41.8888415,
"lon": 12.4952573,
"tags": {
"addr:housenumber": "26",
"addr:street": "Via Capo d'Africa",
"amenity": "bar",
"name": "La Follia",
"operator": "Dolce Calabria SAS di Morello Alessandra & C.",
"phone": "+39 06 45477438",
"ref:vatin": "IT11279721002",
"restaurant:type:it": "wine_bar",
"shop": "pastry"
}
},
{
"type": "node",
"id": 4192923989,
"lat": 41.8893924,
"lon": 12.4835302,
"tags": {
"addr:housenumber": "1",
"addr:street": "Via del Velabro",
"amenity": "bar",
"cuisine": "italian",
"description": "Lounge, Bar, Lunch, Dinner",
"email": "animamundiroma@gmail.com",
"internet_access": "wlan",
"name": "Anima Mundi",
"opening_hours": "Mo-Su 10:00-02:00",
"phone": "+39 06 96030061",
"website": "animamundiroma.it"
}
},
{
"type": "node",
"id": 4260275091,
"lat": 41.8972902,
"lon": 12.4845518,
"tags": {
"addr:housenumber": "138",
"addr:street": "Via Quattro Novembre",
"amenity": "bar",
"name": "Nag's Head"
}
},
{
"type": "node",
"id": 4367948894,
"lat": 41.8917617,
"lon": 12.4929546,
"tags": {
"addr:housenumber": "80",
"addr:postcode": "00184",
"addr:street": "Via delle Terme di Tito",
"amenity": "bar",
"name": "Brewdog Roma",
"name:en": "Brewdog Rome",
"name:it": "Brew Dog Roma",
"opening_hours": "Su-Th 12:00-01:00 ; Fr-Sa 12 : 00-02 : 00"
}
},
{
"type": "node",
"id": 4394361989,
"lat": 41.8833093,
"lon": 12.4873351,
"tags": {
"addr:street": "Viale Aventino",
"amenity": "bar",
"cuisine": "italian",
"name": "Bar Circo Massimo",
"name:it": "Bar Circo Massimo"
}
},
{
"type": "node",
"id": 4455036165,
"lat": 41.8964420,
"lon": 12.4965110,
"tags": {
"amenity": "bar"
}
},
{
"type": "node",
"id": 4455036167,
"lat": 41.8968471,
"lon": 12.4989455,
"tags": {
"amenity": "bar"
}
},
{
"type": "node",
"id": 4556016298,
"lat": 41.8895287,
"lon": 12.4954434,
"tags": {
"amenity": "bar",
"name": "Divin Ostilia",
"name:it": "Divin Ostilia",
"opening_hours": "Mo-Su 12:00-01:00"
}
},
{
"type": "node",
"id": 4847967789,
"lat": 41.8897275,
"lon": 12.4953425,
"tags": {
"amenity": "bar"
}
},
{
"type": "node",
"id": 4886058322,
"lat": 41.8957583,
"lon": 12.4902776,
"tags": {
"addr:street": "Via dei Serpenti",
"amenity": "bar",
"cuisine": "sandwich;coffee_shop",
"internet_access": "wlan",
"name": "Antico Caffe del Brasile - Torrefazione",
"name:de": "Antico Caffe del Brasile - Torrefazione"
}
},
{
"type": "node",
"id": 6296292485,
"lat": 41.8887547,
"lon": 12.4955163,
"tags": {
"amenity": "bar",
"name": "Shamrock Irish bar & restaurant"
}
},
{
"type": "node",
"id": 6573371207,
"lat": 41.8934237,
"lon": 12.4980792,
"tags": {
"addr:housenumber": "4",
"addr:street": "Via delle Terme di Traiano",
"addr:unit": "a",
"amenity": "bar",
"name": "Voodoo Bar",
"opening_hours": "Mo-Th 18:00-02:00; Fr-Sa 18:00-03:00; Su 18:00-02:00",
"phone": "+39 06 8379 6815",
"website": "https://www.facebook.com/voodobar/"
}
},
{
"type": "node",
"id": 6573379647,
"lat": 41.8934297,
"lon": 12.4983340,
"tags": {
"addr:housenumber": "4",
"addr:street": "Via delle Terme di Traiano",
"addr:unit": "a",
"amenity": "bar",
"name": "The Sanctuary - Eco Retreat",
"opening_hours": "Tu-We 18:00-02:00; Th 18:00-03:00; Fr 18:00-04:00; Sa 11:00-04:00; Su 11:00-02:00",
"phone": "+39 06 8379 6820",
"website": "http://www.thesanctuaryroma.it/"
}
},
{
"type": "node",
"id": 6695937286,
"lat": 41.8955791,
"lon": 12.4929538,
"tags": {
"addr:housenumber": "3",
"addr:postcode": "00184",
"addr:street": "Piazza degli Zingari",
"amenity": "bar",
"name": "Antigallery"
}
},
{
"type": "node",
"id": 6698598585,
"lat": 41.8967525,
"lon": 12.4935707,
"tags": {
"addr:housenumber": "31",
"addr:postcode": "00184",
"addr:street": "Via dei Ciancaleoni",
"amenity": "bar",
"name": "Blackmarket Hall",
"website": "http://www.blackmarketartgallery.it"
}
},
{
"type": "node",
"id": 6775922386,
"lat": 41.8934174,
"lon": 12.4980998,
"tags": {
"amenity": "bar",
"name": "Voodoo Bar"
}
},
{
"type": "node",
"id": 7896481085,
"lat": 41.8924968,
"lon": 12.4925672,
"tags": {
"amenity": "bar",
"name": "Coco Caffe"
}
},
{
"type": "node",
"id": 8511677046,
"lat": 41.8876254,
"lon": 12.5033537,
"tags": {
"amenity": "bar",
"name": "sMa Bar",
"wheelchair": "limited"
}
},
{
"type": "node",
"id": 8561505117,
"lat": 41.8901331,
"lon": 12.4955767,
"tags": {
"amenity": "bar",
"name:en": "The Court Cocktail Bar"
}
},
{
"type": "count",
"id": 0,
"tags": {
"nodes": "26",
"ways": "0",
"relations": "0",
"total": "26"
}
}
]
}
XML output
You just have to execute the following query to get a full list in XML format.
[timeout:30];
rel[name="Colosseo"][tourism="attraction"];
(nwr[amenity=bar](around:1000.0);
);
out center;
out count;
<?xml version="1.0" encoding="UTF-8"?>
<osm version="0.6" generator="Overpass API 0.7.56.9 76e5016d">
<note>The data included in this document is from www.openstreetmap.org. The data is made available under ODbL.</note>
<meta osm_base="2021-07-22T16:58:28Z"/>
<node id="962348457" lat="41.8940916" lon="12.4885583">
<tag k="addr:housenumber" v="18/19"/>
<tag k="addr:street" v="Via della Madonna dei Monti"/>
<tag k="amenity" v="bar"/>
<tag k="email" v="info@iceclubroma.it"/>
<tag k="name" v="Ice Club"/>
<tag k="opening_hours" v="Mo-Su 17:00-01:00"/>
<tag k="phone" v="+39 06 97845581"/>
<tag k="website" v="http://iceclubroma.it/"/>
</node>
<node id="1572583515" lat="41.8966226" lon="12.4860016">
<tag k="addr:housenumber" v="8"/>
<tag k="addr:postcode" v="00187"/>
<tag k="addr:street" v="Via delle Tre Cannelle"/>
<tag k="amenity" v="bar"/>
<tag k="internet_access" v="wlan"/>
<tag k="name" v="The Public House"/>
<tag k="opening_hours" v="Mo-Su 12:00-02:00"/>
<tag k="phone" v="+39 06 679 7591"/>
<tag k="website" v="http://www.thepublichouserome.com/"/>
</node>
<node id="1701218666" lat="41.8885564" lon="12.4950752">
<tag k="amenity" v="bar"/>
<tag k="name" v="Camden Town"/>
</node>
<node id="2092013187" lat="41.8898973" lon="12.4946166">
<tag k="addr:housenumber" v="12"/>
<tag �o�-�s
>�~8 ���� �s
w C=k="addr:street" v="Via di San Giovanni in Laterano"/>
<tag k="amenity" v="bar"/>
<tag k="name" v="My Bar"/>
<tag k="operator" v="Anfiteatro S.r.l."/>
<tag k="phone" v="+39 06 7004425"/>
<tag k="ref:vatin" v="IT06747541008"/>
</node>
<node id="2128214065" lat="41.8889233" lon="12.4979123">
<tag k="addr:city" v="Roma"/>
<tag k="addr:country" v="IT"/>
<tag k="addr:housenumber" v="126"/>
<tag k="addr:postcode" v="00184"/>
<tag k="addr:street" v="Via di San Giovanni in Laterano"/>
<tag k="amenity" v="bar"/>
<tag k="cuisine" v="italian"/>
<tag k="name" v="San Clemente"/>
<tag k="source" v="GPS"/>
<tag k="website" v="http://www.iclementini.it/"/>
</node>
<node id="2515010849" lat="41.8972361" lon="12.4947481">
<tag k="addr:city" v="Roma"/>
<tag k="addr:country" v="IT"/>
<tag k="addr:housenumber" v="101"/>
<tag k="addr:postcode" v="00184"/>
<tag k="addr:street" v="Via Panisperna"/>
<tag k="amenity" v="bar"/>
<tag k="email" v="blackmarketmonti@gmail.com"/>
<tag k="internet_access" v="yes"/>
<tag k="internet_access:fee" v="no"/>
<tag k="microbrewery" v="no"/>
<tag k="name" v="Black Market"/>
<tag k="opening_hours" v="15:00-02:00"/>
<tag k="phone" v="+39 3398227541"/>
<tag k="smoking" v="no"/>
<tag k="website" v="http://black-market.it"/>
</node>
<node id="3217327590" lat="41.8879519" lon="12.4839357">
<tag k="addr:city" v="Roma"/>
<tag k="addr:housenumber" v="65"/>
<tag k="addr:street" v="Via dei Cerchi"/>
<tag k="amenity" v="bar"/>
<tag k="name" v="0,75"/>
<tag k="opening_hours" v="Mo-Su 11:00-02:00"/>
<tag k="phone" v="+39 066875706"/>
</node>
<node id="3320437843" lat="41.8888415" lon="12.4952573">
<tag k="addr:housenumber" v="26"/>
<tag k="addr:street" v="Via Capo d'Africa"/>
<tag k="amenity" v="bar"/>
<tag k="name" v="La Follia"/>
<tag k="operator" v="Dolce Calabria SAS di Morello Alessandra & C."/>
<tag k="phone" v="+39 06 45477438"/>
<tag k="ref:vatin" v="IT11279721002"/>
<tag k="restaurant:type:it" v="wine_bar"/>
<tag k="shop" v="pastry"/>
</node>
<node id="4192923989" lat="41.8893924" lon="12.4835302">
<tag k="addr:housenumber" v="1"/>
<tag k="addr:street" v="Via del Velabro"/>
<tag k="amenity" v="bar"/>
<tag k="cuisine" v="italian"/>
<tag k="description" v="Lounge, Bar, Lunch, Dinner"/>
<tag k="email" v="animamundiroma@gmail.com"/>
<tag k="internet_access" v="wlan"/>
<tag k="name" v="Anima Mundi"/>
<tag k="opening_hours" v="Mo-Su 10:00-02:00"/>
<tag k="phone" v="+39 06 96030061"/>
<tag k="website" v="animamundiroma.it"/>
</node>
<node id="4260275091" lat="41.8972902" lon="12.4845518">
<tag k="addr:housenumber" v="138"/>
<tag k="addr:street" v="Via Quattro Novembre"/>
<tag k="amenity" v="bar"/>
<tag k="name" v="Nag's Head"/>
</node>
<node id="4367948894" lat="41.8917617" lon="12.4929546">
<tag k="addr:housenumber" v="80"/>
<tag k="addr:postcode" v="00184"/>
<tag k="addr:street" v="Via delle Terme di Tito"/>
<tag k="amenity" v="bar"/>
<tag k="name" v="Brewdog Roma"/>
<tag k="name:en" v="Brewdog Rome"/>
<tag k="name:it" v="Brew Dog Roma"/>
<tag k="opening_hours" v="Su-Th 12:00-01:00 ; Fr-Sa 12 : 00-02 : 00"/>
</node>
<node id="4394361989" lat="41.8833093" lon="12.4873351">
<tag k="addr:street" v="Viale Aventino"/>
<tag k="amenity" v="bar"/>
<tag k="cuisine" v="italian"/>
<tag k="name" v="Bar Circo Massimo"/>
<tag k="name:it" v="Bar Circo Massimo"/>
</node>
<node id="4455036165" lat="41.8964420" lon="12.4965110">
<tag k="amenity" v="bar"/>
</node>
<node id="4455036167" lat="41.8968471" lon="12.4989455">
<tag k="amenity" v="bar"/>
</node>
<node id="4556016298" lat="41.8895287" lon="12.4954434">
<tag k="amenity" v="bar"/>
<tag k="name" v="Divin Ostilia"/>
<tag k="name:it" v="Divin Ostilia"/>
<tag k="opening_hours" v="Mo-Su 12:00-01:00"/>
</node>
<node id="4847967789" lat="41.8897275" lon="12.4953425">
<tag k="amenity" v="bar"/>
</node>
<node id="4886058322" lat="41.8957583" lon="12.4902776">
<tag k="addr:street" v="Via dei Serpenti"/>
<tag k="amenity" v="bar"/>
<tag k="cuisine" v="sandwich;coffee_shop"/>
<tag k="internet_access" v="wlan"/>
<tag k="name" v="Antico Caffe del Brasile - Torrefazione"/>
<tag k="name:de" v="Antico Caffe del Brasile - Torrefazione"/>
</node>
<node id="6296292485" lat="41.8887547" lon="12.4955163">
<tag k="amenity" v="bar"/>
<tag k="name" v="Shamrock Irish bar & restaurant"/>
</node>
<node id="6573371207" lat="41.8934237" lon="12.4980792">
<tag k="addr:housenumber" v="4"/>
<tag k="addr:street" v="Via delle Terme di Traiano"/>
<tag k="addr:unit" v="a"/>
<tag k="amenity" v="bar"/>
<tag k="name" v="Voodoo Bar"/>
<tag k="opening_hours" v="Mo-Th 18:00-02:00; Fr-Sa 18:00-03:00; Su 18:00-02:00"/>
<tag k="phone" v="+39 06 8379 6815"/>
<tag k="website" v="https://www.facebook.com/voodobar/"/>
</node>
<node id="6573379647" lat="41.8934297" lon="12.4983340">
<tag k="addr:housenumber" v="4"/>
<tag k="addr:street" v="Via delle Terme di Traiano"/>
<tag k="addr:unit" v="a"/>
<tag k="amenity" v="bar"/>
<tag k="name" v="The Sanctuary - Eco Retreat"/>
<tag k="opening_hours" v="Tu-We 18:00-02:00; Th 18:00-03:00; Fr 18:00-04:00; Sa 11:00-04:00; Su 11:00-02:00"/>
<tag k="phone" v="+39 06 8379 6820"/>
<tag k="website" v="http://www.thesanctuaryroma.it/"/>
</node>
<node id="6695937286" lat="41.8955791" lon="12.4929538">
<tag k="addr:housenumber" v="3"/>
<tag k="addr:postcode" v="00184"/>
<tag k="addr:street" v="Piazza degli Zingari"/>
<tag k="amenity" v="bar"/>
<tag k="name" v="Antigallery"/>
</node>
<node id="6698598585" lat="41.8967525" lon="12.4935707">
<tag k="addr:housenumber" v="31"/>
<tag k="addr:postcode" v="00184"/>
<tag k="addr:street" v="Via dei Ciancaleoni"/>
<tag k="amenity" v="bar"/>
<tag k="name" v="Blackmarket Hall"/>
<tag k="website" v="http://www.blackmarketartgallery.it"/>
</node>
<node id="6775922386" lat="41.8934174" lon="12.4980998">
<tag k="amenity" v="bar"/>
<tag k="name" v="Voodoo Bar"/>
</node>
<node id="7896481085" lat="41.8924968" lon="12.4925672">
<tag k="amenity" v="bar"/>
<tag k="name" v="Coco Caffe"/>
</node>
<node id="8511677046" lat="41.8876254" lon="12.5033537">
<tag k="amenity" v="bar"/>
<tag k="name" v="sMa Bar"/>
<tag k="wheelchair" v="limited"/>
</node>
<node id="8561505117" lat="41.8901331" lon="12.4955767">
<tag k="amenity" v="bar"/>
<tag k="name:en" v="The Court Cocktail Bar"/>
</node>
<count id="0">
<tag k="nodes" v="26"/>
<tag k="ways" v="0"/>
<tag k="relations" v="0"/>
<tag k="total" v="26"/>
</count>
</osm>