Airbnb Data Collection: City Maps

May 2017 Note: You probably want to go here instead. This page is largely archive now, because each map required some manual work. It will remain so unless I find an automated mapping solution. However, I now maintain a more regularly updated and much more extensive collection of data for download at this other page, and you can do your own mapping from there.

Sep 2016 Note: The comments section has become unwieldy: if you want me to collect data for a city not listed here, please do so here. Also note: I do know that Sri Lanka and some other areas are not “cities”, but I retain the name because that’s how it started.

Here are surveys of Airbnb cities converted to Google Fusion Tables. Fusion Tables include a map and a downloadable spreadsheet (Choose File > Download), and the ability to filter the data. For many maps the “neighbourhood” column holds the most useful spatial partitioning.

Data is obtained to the best of my ability, and for most surveys I believe it is statistically good enough for public policy discussions, but I can make no guarantees as to accuracy. Methodology details are here, and the source code is available here. From time to time, changes in Airbnb’s web site or operational problems in my code can make individual surveys inaccurate, so you should treat individual trends and detailed results with care.

Other Airbnb mapping pages can be found for Amsterdam here, for New York and Portland (and others) at the excellent Inside Airbnb, and for San Francisco at the Anti-Eviction Mapping Project.

Each link opens a new tab with a Google Fusion Table page, where you can download the data as well as filter the data in various ways. Please note that (for those spreadsheets reporting it) “income” is a very rough estimate obtained by multiplying the price by the number of reviews — it far underestimates actual income but should be proportionately reasonable over the city as a whole. The listings are colour-coded by price (red is over $300US, yellow is $200 – $300, green is $100 – $200, blue is $50 – $100, purple is under $50US).

The list here is not a complete set of the data sets I have. Contact me (tom at tomslee dot net) with requests for more cities or repeated surveys for a single city. Suggestions for improved data/presentation are always welcome.

I have put comments in [square brackets] after some of these. Those with [GIS] are broken into neighbourhoods using a Shapefile of the city boundaries and are more useful than those without, as searches can return listings well outside a given city and as the “neighbourhood” column for those without a Shapefile are not useful. If you have access to a Shapefile of city boundaries, it would be helpful if you could provide it with the request.

Asia

Australasia

Europe

North America

South America

179 Comments

  1. Robert
    September 26, 2014 at 9:17 pm

    Hi Tom,
    That is pretty impressive work. Would you be able to do one for Sydney for me?
    Thanks
    Robert

  2. am4pper
    October 4, 2014 at 4:07 pm

    I’m really interested in how you acquired this data. Did you directly query the database or did you use a scraper? Could you share your method/code? Very cool stuff 🙂

  3. Michael
    October 22, 2014 at 1:39 am

    Hi Tom, this is amazing! I have been trying to figure how to grab the code (assuming that is OK?). Would you mind doing Brisbane (Aus)?

  4. Michael
    October 24, 2014 at 1:47 am

    Hi Again Tom, you work has attracted a lot of interest and some questions. Further to my previous request is it possible to do all of Australia and add into the data the host profile number?

    • Tom Slee
      October 24, 2014 at 3:18 pm

      Hi Michael,

      You are welcome to grab the code, although I did have to make a couple of fixes to get it work for Brisbane (and other places that don’t have “neighborhoods” listed on the search page) and I haven’t uploaded that yet.

      But here is a map and KML file as a Google Fusion Table. The host_id is in the data but not in the caption above each icon. You are free to take it and change it however you want, and I can send you a spreadsheet with a few more columns if you want — just send me an email with your address (tslee at web dot ca).

      I think Brisbane looks pretty accurate. My map has 17 shared rooms, 407 entire homes, and 600 private rooms. Looking at the Airbnb search page for Brisbane claims 6 shared rooms, 397 entire homes, 605 private rooms. There’s probably a little fuzziness in which listings show up so it looks like I have almost all.

      Finally – I thought it would not work for the whole of Australia, but as you can do a search on the whole country with the same filters, maybe it will work. I’m running it now — it takes a couple of days — and I’ll post an update when it’s done.

      • Michael
        October 29, 2014 at 6:20 pm

        Thanks Tom, this is much appreciated. Your work has generated a lot of interest locally.

        • Tom Slee
          October 29, 2014 at 9:17 pm

          Happy to be of use Michael. My script won’t manage Australia as a whole, unfortunately. I hope to do a round of enhancements and I’ll try to get that in, but it may be the new year before I can get to it.

  5. Ryan
    October 27, 2014 at 5:17 pm

    Wow this is pretty incredible stuff! I would love to see a map like this for the city of Portland, OR. I wish I had the know-how to follow your code and whip something up but alas, I come to you for help.

    Thanks!!

    • Tom Slee
      October 29, 2014 at 9:18 pm

      Sorry to take so long to approve your comment. here is Portland, done over the weekend. I could send you a spreadsheet with more detail if you’re interested. Send me an email.

  6. Michael
    October 30, 2014 at 12:05 am

    Thanks again Tom, have looked at Brisbane and some of the fuzziness is likely around the geography. the map is capturing some surrounding areas which are not really Brisbane but not impacting to any significant degree.

    If you are inclined to do all of Australia, great, and naturally whenever you are ready. If you could extend the fields to include the states that would be very useful.

    I am not sure what your interest or motivation in this is but for mine the inclusion of the host details is very useful and would be terrific is we could do the same for Sydney’s if you are inclined to do so.

    Similarly if you wish to have a look at Melbourne and the other state capitals there are lot of individuals who would be interested in the results.

    My own skills are not sufficient to do this.

    • Linda
      January 6, 2016 at 12:44 am

      HI Michael,
      I only just stumbled across this data! I’m interested to know if you got anywhere, so it would be good to hear from you!

  7. Sebastian
    November 18, 2014 at 12:03 pm

    This is impressive.

    Could you do Berlin, Germany? I heard it is one of the most popular airbnb cities?

    Thank you!

  8. Yann
    November 28, 2014 at 7:40 am

    Hi Tom –
    Great work, can you confirm the currency used for the prices, USD across all cities?
    Thanks,
    Yann

  9. ester
    December 2, 2014 at 11:25 am

    Hi Tom, i’m an italian student of Tourism at the Univerity Bicocca of Milan. Could you explain me the meaning of the points colors? The different points colors are random or have a specific meaning?
    Thank you and good job.
    Ester

    • Tom Slee
      December 2, 2014 at 3:39 pm

      Hi Ester,

      The colours show the price of the listing per night. I see the prices in $Canadian: Red is over $300, Yellow is $200-300, Green is $100-200, Blue is $50-100, and Purple is $0-50.

  10. Sven
    December 15, 2014 at 11:40 am

    Hi Tom,
    Your site is amazing, very valuable information! I am trying to size the Airbnb market share, but as you know much better than me, they are not very open about their data… Especially I am interested in guests per city per year. Do you know of any data on this?
    Thank you!
    Sven

  11. Albert
    January 9, 2015 at 2:23 pm

    Hi Tom,

    your maps are just AMAZING. Really shoking.

    I don’t know whether it is easy to you to do the maps but it would be really interesting to have the one from Barcelona since it is becoming a crucial political issue.

    The fact is that Airbnb are telling they have major presence in the peripheral areas but the dataset I have made at the neighbourhood points to the concentration to the Old City Area (the most overcrowded in the city).

    Just saying that it would e very useful for the political discussion if we could visualize the Airbnb listings for all the city.

    Thanks a lot.

    Regards!

    Albert Arias

    • Tom Slee
      January 11, 2015 at 8:57 pm

      Thanks Albert!

      I have added a link to a map for Barcelona, which I retrieved in September 2014. I can run a new one soon if you want.

      I have seen this kind of thing before: in Montreal they claim to have listings all over the place, but half of all visits are in just two neighbourhoods, which are ones with a big tourist presence.

      If you are interested I can send you a spreadsheet with more attributes (number of reviews, etc). Just let me know by email (tslee at web dot ca)

      The detailed counts per neighbourhood are not always reliable, but if you have a way of getting a file of Barcelona district boundaries then I could get fairly accurate counts. An ESRI shapefile perhaps from an open data site? I tried going through the Barcelona Open Data portal but my complete lack of Spanish stopped me 🙁

  12. Jennifer F
    January 23, 2015 at 8:13 pm

    Hi Tom,

    I’ve been aware of and admired your airbnb data crunching for while now (in print) and I just found that you have this blog!

    I’ve also been following new york’s battle with airbnb (i used to live there). We have our own nightmare at ground zero in San Francisco, however most of our politicians are bought and sold thanks to curry favor with the disruptors.

    We have been doing similar analysis in my little collective. Yours is more thorough though. May I suggest you try the map product CartoDB for prettier maps? You can also use your coding skills to animate and stuff if you are so inclined. (No I dont work for them. )It’s free and here is a sample: http://www.antievictionmappingproject.net/airbnbmap.html

    • Tom Slee
      January 24, 2015 at 9:42 am

      I’ve been looking for a better mapping interface. I’ll definitely give it a go. The anti-eviction work looks great: congratulations on it. Happy to collaborate if there are ways to do so.

      • Jennifer F
        January 25, 2015 at 9:15 pm

        It would be really great to collaborate. I will email you soon.

        Are you assisting the folks in NY’s Share Better campaign? Cuz I’m in Share Better SF and I hear we share information with each other.

  13. Jennifer F
    January 23, 2015 at 8:17 pm

    I am looking at your tables for this map and wondering what “income” means exactly? Did you calculate that based on the number of bookings in the future? Is it an estimate?

    Also what does rank mean? If I missed the explanation somewhere, I apologize…

    • Tom Slee
      January 24, 2015 at 9:44 am

      Yes, income is an estimate. The absolute value does not have any meaning, but relative values might. It’s just the nightly price times the number of reviews, so if there is a pretty constant average visit length and a pretty constant ratio of reviews to actual visits then it would give a useful relative idea of which properties are being rented. Ranking is just the order of the incomes.

  14. PB
    January 25, 2015 at 2:14 pm

    Hi Tom
    I’m thinking of joining the herd and trying out AirBnB mostly because of I’m nervous about the inflexibility of having fulltime tenants, especially with the potential legal issues that come with 30-day tenancy in Ca. I have some questions for you : )

    How did you come up with the total income for these individual listings? Where does one find that?

    Will you be doing an extension of the SF map to include Marin soon? And did you do/will you please do one for Palm Beach Island FL?

    Finally, the stories on AirBnb Confessions almost made me gag. Do you think they’re really true? Or do you think most hosts and guests participating in this are more decent that that?

  15. Selim
    February 11, 2015 at 4:49 am

    Hi Tom,

    The maps and studies are amazing. Could also preapare for Istanbul? Thank you in advance.

    Selim

    • Tom Slee
      February 17, 2015 at 10:16 pm

      Hi Selim,

      You’ll see the map listed above now. I was surprised how many listings Istanbul has — over 7,000. A lot of multiple-listing owners too. I can send you a spreadsheet with more fields if you are interested.

  16. Boston Dave
    February 12, 2015 at 1:26 am

    Hi Tom,

    The stuff you have shared here is awesome! I dont understand the “scraper” or how to code but might do a little learning and give it a shot. Any chance you could help me out with Dallas? I am working on a project and it would be a great help!

    Best, Dave

    • Tom Slee
      February 17, 2015 at 10:18 pm

      Hi Dave,

      You’ll see the map listed above now. Dallas has surprisingly few listings: only 539. I can send you a spreadsheet with more fields if you are interested.

  17. Thomas
    February 18, 2015 at 10:05 am

    Hi Tom!

    The maps look amazing again. I was wondering if you are willing to share spreadsheets of data of European cities that I want to use for research. It would really help me out! How many years of observations have you been collecting?

    Kind Regards,

    Thomas Mutsaerts

  18. Tom Slee
    February 18, 2015 at 10:29 am

    I’ve given Istanbul its own page here, accessible from the front page of the blog on the “Airbnb resources” menu. I am hoping to post a bunch of city pages with the same kind of basic information. I’d be happy to add to the reports if there are requests.

  19. Alex
    February 18, 2015 at 6:13 pm

    Hi Tom,
    Amazing stuff you’ve done here, well done!

    I’m trying to put together more of a time series look at airbnb data for San Francisco. I was wondering if you had happened to save more detailed output from your August 2014 scrape? Also, were you able to de-duplicate multiple listings? (I’ve noticed that some hosts will put the same pictures/descriptions up with different listing IDs).

    Best,
    Alex

    • Tom Slee
      February 18, 2015 at 9:25 pm

      Hi Alex, and thank you.

      I have three surveys of San Francisco details, from November 2013, May 2014, and August 2014. I’d be happy to send you spreadsheets of each if you want.

      I haven’t made any effort to de-duplicate. I do see that some people offer a “private room” and then also offer the “entire home or apartment” as a separate listing, but for some purposes it makes sense to keep them separate. The spreadsheet does have latitude and longitude.

      I’ll send you a separate email over the weekend.

    • Jennifer F
      February 19, 2015 at 1:26 pm

      Hi Alex,

      I have a colleague in SF, Guss, who was also scraping the website over the last couple years. If you contact him, he might have more snapshots in time, as well as Tom’s to fill out your picture. Email him at his blog: http://darkanddifficult.com/wordpress/?p=5004

      Also please send me an email of your finished product if you want it publicized. (iamthefieb@gmail.com) I’m part of the ShareBetter SF coalition. We love data viz!

      • Tom Slee
        February 19, 2015 at 1:36 pm

        Guss gollects more detail than I do as well, so definitely worth reaching out to him.

        • Alex
          February 19, 2015 at 4:29 pm

          Jenn and Tom, you all are lifesavers, thanks again. I’ll certainly follow up with whatever I end up with (this is part of a capstone project for a masters degree) hopefully has some cool data vis stuff as well but is mostly focused on critiquing the regulation.

  20. Bruno
    March 9, 2015 at 9:14 am

    Hi Tom,
    As many readers already mentioned, congratulations for a truly remarkable work!
    I am interested myself in understanding the footprint of Airbnb, and was trying to gather information online when I landed on your Github page, which is very cool thanks for sharing.
    In your opinion, would there be a way to have a global overview of the geographical footprint of Airbnb? that is getting a high-level view of how many listings per country (they mention ~200 countries), and largest cities in these countries (without necessarily getting the details of each listing). I’m trying to assess the size of Airbnb in countries other than the ones they usually talk about (France/paris, UK/london, ..), and also the penetration in each country beyond Capital cities
    Do you think your code can be twisted to do that?
    Many thanks in advance for your input!
    Best

    • Tom Slee
      March 9, 2015 at 7:06 pm

      Hi Bruno,

      Good idea. It turns out I can, but it will take a little while. The room_ids are integers with a maximum value of about 6 million, so I can just pick random numbers from that range, go to the site, and if the room exists save the information about it.

      It will take a little while – I figure I can get about 150 or so listings an hour while staying within Airbnb’s query limits (like many sites, they shut you down if you throw too much traffic at them, which is fair enough). So I should be able to get about 3,000 a day. It may take the best part of a month to get a really good data set, but maybe by the weekend I’ll have something to show. Watch this space and thanks for the suggestion.

      • Bruno
        May 7, 2015 at 10:33 am

        Hello again Tom,
        I’ve been following on this thread’s activity for the past few weeks and it seems there is a lot of traction going around your work, congrats!
        I was wondering whether your attempt to “map the entire Airbnb” supply had been successful, or it was a bit too ambitious after all?
        Thanks and good luck on your book (if you find time to write it!)
        Cheers

  21. Lauritz Fischer
    March 23, 2015 at 8:32 pm

    Hi Tom!
    Thank you for the great work, I really appreciate it!
    Is there any chance to have insights about the number of AirBnB listings in each of the approx. 300 biggest cities in the world?
    I figure Bruno has already asked kind of the same question.. do you already have results?
    Thank you in advance!

  22. Viktor
    April 9, 2015 at 2:29 pm

    Hi Tom,

    Really nice work I must say! I’m currently writing my bachelor thesis on the sharing economy and how AirBnB affects the hotel market in Copenhagen, is it possible to extract the data from that city as well?

    Regards,
    Viktor

  23. Antonio Sforna
    April 13, 2015 at 9:48 am

    Congratulations, your work is awesome! I am a student in Data Journalism and since I have been living in Brussels for some time I did notice how the Airbnb phenomenon is most probably bound up with the ongoing gentrification is some areas of the city. It would be great to actually double check this feeling with actual data…would be possible for you to get data for Brussels as well?

    Thank you in advance for your time

    bests
    Antonio

  24. Monyka
    April 16, 2015 at 7:01 pm

    Hello Tom,
    Congratulations, this is amazing. I am currently a student and working on a research project about Airbnb in the city of Vancouver. Do you mind to help me with that info?
    Thank you in advance!!
    Monyka

  25. Antonio
    April 20, 2015 at 10:16 am

    Many many thanks Tom for the Brussels dataset,wonderful!

  26. Monyka
    April 28, 2015 at 7:57 pm

    Tom, Thank you for sharing your knowledge and helping everybody. This is a real example of the Sharing Economy!!! 8o)

  27. Tyler
    May 2, 2015 at 5:55 pm

    Hi Tom, great job on putting together this scraper! I’m definitely going to give a whirl on some more rural areas in Canada, might yield some interesting data there.

    I was wondering if this scraper grabs bookings data as well? Like x/365 days are booked on their calendar? And if so, is there any chance that data for Vancouver could be posted or sent over email? It would be very much appreciated.

    I’m very interested in mapping just booking data and perhaps using an interpolated heatmap to show which areas have airbnb businesses that are more packed. Ideally, I’d like to pinpoint areas with an overflow of bookings in certain times of the year.

    Anyway, great job! Keep it up. Thanks for taking the time to read this too. Cheers!

  28. Romulo Manzano
    May 3, 2015 at 3:48 pm

    Tom! This is truly incredible, I’m a data scientist myself but haven’t mastered scraping websites the way you have!. I’m very interested in researching Barcelona (SPAIN) prices by neighborhoods. Does your code extract the neighborhood associated with each property? I got hold of Barcelona’s neighborhood boundaries (KML), which I guess I could use to isolate the coordinates on the spreadsheet you provided. But I wonder if your code is able to do that automatically!

    Your work is amazing!

    Thanks.

    Rom

    • Murray
      May 4, 2015 at 11:57 am

      Hi Rom,

      I also work with Airbnb maps and data (http://insideairbnb.com). I’m working on a map for Barcelona, and need a neighbourhood Shape File for the city – are you able to share yours (or let me know where you got it)? In exchange, I could help you use the shape file with Tom’s data, or provide you with some alternate data coded to the neighbourhoods.

      Feel free to e-mail me directly: murray [at] murraycox [dot] com

      • Tom Slee
        May 4, 2015 at 1:39 pm

        Hi Rom and Murray,

        I have a shapefile of Barcelona neighborhoods that I got from Albert (search his name in the comments above). I have uploaded it for convenience: I hope this link works. I do have a breakdown by neighbourhood, so if you are interested in comparing notes, email me and we can compare queries/results. tom at tomslee dot net.

        Rom: you may want to contact Albert – his interests were similar. It’s always interesting to find out what people who actually know a city see, so please keep in touch.

        • Murray
          May 4, 2015 at 3:28 pm

          Thanks Tom, much appreciated.

          I also tried trawling through some Barcelona and Catalonia government Open Data web-sites, but could only find shape files of districts, not Barrios – so thank you.

          Is there a source on the shape file so I know who to credit when I use it?

  29. Mia Carbajal
    May 7, 2015 at 4:52 pm

    Hi Tom,

    I recently learned of your work through an Airbnb study published by LAANE in Los Angeles. Your work is truly remarkable, and I appreciate the accessibility of this information.

    My organization is currently working on a similar study about Airbnb in Oakland, CA. Would it be possible for you to get the data for Oakland, as well?

    Thank you in advance!!

    Mia

  30. Monyka
    May 9, 2015 at 1:14 pm

    Hi Tom,
    I have been using the data from Vancouver, BC. I am trying to limit my analysis of Airbnb to certain areas of the city. I would like to know if you could share with me neighbourhoods and any other field in which I can have more information about hosts and reviews.
    Regards,
    Monyka

  31. Cesar
    May 27, 2015 at 6:15 am

    Hello Tom,
    I´m impressed by your great job. I´m very interested in LISBON, MADRID, SEVILLE.
    Are these ones in your plans?

    thanks
    cesar

  32. Katherine Harr
    May 29, 2015 at 6:45 pm

    Can’t find anyone local to help with data right now – legalization of STRs proposal comes to Berkeley Council on June 9 but then will have a few weeks / months of Planning Commissionn etc.
    Any chance you can help with stats on whole units, absentee owners, multiple whole units listed, here in Berkeley?

  33. Jennifer F
    May 29, 2015 at 8:52 pm

    Hi Tom,
    Thanks for the shoutout to the mapping project, but I’m afraid I sent Katherine to you. Our Guss is on vacation right now… I know that his scrapes are different than yours; are yours just lat and lon? Are can you do “entire unit” counts and lists by the same host ID?

  34. Safak Celik
    June 15, 2015 at 3:09 am

    Hi Tom,
    Amazing stuff you are doing, keep up the great work.
    Can you do one for Singapore?

  35. Cesar
    June 22, 2015 at 7:12 am

    Hello, impressive work!

    Are you planning to get another spanish cities? Madrid?

  36. Tom Slee
    July 2, 2015 at 4:50 pm

    So the praise is nice and appreciated, but from here on I will delete it, so don’t bother. Keep on asking for cities though.

    • Mia Carbajal
      July 2, 2015 at 6:01 pm

      Hi Tom,
      Would love to see some data on Oakland, CA. The city recently entered negotiations with Airbnb to collect transient occupancy taxes. Information about the amount of “entire” units listed, impacted neighborhoods, and generated revenue would greatly help with a campaign to get some of those funds for affordable housing development in Oakland.

  37. Cesar
    July 3, 2015 at 2:41 am

    Wonderfull, thanks so much.

    Cesar

  38. Matt
    July 6, 2015 at 10:32 pm

    Hi Tom,

    I pulled the data for Boston (July 2015), and I’m showing that listings doubled since your pull in September, 2014. Did the geographies change? If not, this is huge. I wonder how much they’ll increase, and if you’ve seen huge increases in any other cities.

    Thanks

  39. lauren
    July 8, 2015 at 1:52 pm

    Hey I would love to see Toronto listing as well!

  40. Guille
    July 9, 2015 at 11:04 am

    Hello Tom,
    I’m a guy from Mallorca, Spain. Here tourism it’s very important. For these reason I would like to analyse a turistic resort called PLAYA DE PALMA. Could you do this work? I will use in a college project. Thank you verey much. I admire your maps.

  41. Justin T
    July 10, 2015 at 2:21 pm

    I’m from Chattanooga, Tennessee and we’ve been seeing a lot more of these go up in the city. I’d love to see a map of where in the city they are all happening! Thanks!

  42. Nina M
    July 13, 2015 at 7:46 am

    Dear Tom,
    as all the previous commenters, I wanted to thank you for this great work. I am currently working on a paper on the impacts of AirBNB on the Viennese housing market. I was wondering, if you could add Vienna in Austria. I would be very interested in the data!!
    Best wishes,
    Nina.

  43. Tracy
    July 19, 2015 at 4:39 pm

    Any data on Austin Texas ?
    We could use your help

  44. Tom Slee
    July 19, 2015 at 4:46 pm

    Sorry for the slow response on these requests. I hope to post a few in the next couple of days.

  45. Tracy
    July 31, 2015 at 10:16 pm

    Can someone do Austin Texas? 78702 and other zip codes?

  46. HT
    August 1, 2015 at 9:18 pm

    Hi Tom – not sure if you’re aware but it seems like your “airbnb” project has disappeared off Github?
    Only the superceded “airbnbpy” remains

    • Tom Slee
      August 1, 2015 at 9:38 pm

      Yes. There are a few reasons. One is that I’ve been moving to PostgreSQL running on Amazon Web Services RDS, and so there will be some changes soon. Along with that I posted a version that had a password in, which I have now changed but it gave me the creeps. But mainly, Airbnb is getting more aggressive about blocking scrapes — my home IP has been blocked from the site for weeks now. So posting things on GitHub seemed maybe too friendly. I am happy to share what I have and may well post it up on GitHub again once it is in a clean state. Email me if it’s a problem for you.

      • HT
        August 16, 2015 at 7:01 pm

        Aha – yes I noticed I’ve been getting repeated 503 errors too after a while, assuming these are Airbnb blocking the scrapers?
        I was using a free basic AWS instance and figured they would probably block anything coming from there pretty quickly.
        I’ve kept a working copy too and have been modifying it to for instance randomise User Agent headers and building in more delays. Not sure if it’s helping much… Time to look at incorporating an IP randomising service maybe.

  47. hug
    August 6, 2015 at 4:13 am

    Hi. Thanks for your work. I also noticed the disappearance of the airbnb folder but I kept a working copy of the main script which I am modifying to work with psycopg and Postgres. Could it be possible to get the doc to use this script (the use of -asa, -asv and the right order) please ?

  48. Hart Williams
    August 12, 2015 at 5:56 pm

    Tom,
    This is fantastic. Would you be willing to help me out with a Denver, CO map? We have some issues coming to light in the local city council and that would be helpful.

    Thanks!

    • Tom Slee
      August 17, 2015 at 7:18 am

      It is taking some time now to accumulate listings. I hope to have this by the end of the week.

      • Tom Slee
        August 19, 2015 at 9:53 pm

        Denver is now in the list. Only 1500 listings, which surprised me. I wonder if something in the search led to me missing some? Please do let me know if you come across obvious discrepancies (like many listings you find on the site that are not included in the data set here).

  49. Nina M
    August 17, 2015 at 6:13 am

    Hey Tom! I really don’t wanna be annoying, I just wanted to ask whether you think it would be possible to get the data for Vienna, Austria in the next time. Otherwise I guess I have to find another way,
    Really appreciate your work! Thank you! Best,
    Nina.

    • Tom Slee
      August 17, 2015 at 7:17 am

      Hi Nina, sorry it’s taken so long. I do have a dataset for Vienna completed, and will post it this evening.

      • Tom Slee
        August 18, 2015 at 10:48 pm

        Vienna is finally posted. Sorry again for the delay. The format is slightly changed – there should be more columns if you download – but otherwise it should be the same.

        • Nina
          August 20, 2015 at 8:37 am

          Dear Tom,
          Thank you very much!!
          I was also looking at the insideairbnb website and the available data there – and noticed a difference in the number of listings. Could it be that in the file above also includes some of Vienna’s sourroundings? I guess, I should just check with a shape-file of the city.

          One more question, I would like to ask: It is not possible, to travel back in time and to get the data from a year ago, is it?
          Thanks again, the data will be so very helpful for my analysis.

          • Tom Slee
            August 20, 2015 at 10:53 am

            Dear Nina,

            It’s interesting that they differ, and not easy to tell what the reasons are. I would say that a 10% difference is not too bad. Both Murray (who runs insideairbnb) and myself have seen that a lot of listings appear and disappear in a short time — often listings with very few visits. So there is an inherent noisiness to the data, I think. (Is a host with no guests really a host?)

            Unfortunately it’s not possible to look back in time. At least, I have not thought of a way to do that.

  50. Achille
    August 17, 2015 at 8:18 am

    Hi Tom,

    i am really impressed by your work! may i can ask you the data of Lucca (Italy) ?

    Thank you very much !

  51. Ken
    August 24, 2015 at 11:51 pm

    Dear Tom,

    Your Airbnb analysis has helped me very much and saved tons of time. I found a website call elance to try hiring an Indian programmer but I found your blog instead and half of the problem is solved!

    I know nothing about programming and IT but you are a highly skilled / most importantly passionate IT professional. I want to make a small token of appreciation for your work if you dont mind. It would be great if us readers can donate to keep this blog running. My internet skill is extremely poor and couldn’t find your email address. Hope you can contact me via email.

    Best Regards

    Ken

  52. Wallace
    August 27, 2015 at 1:17 am

    Dear Tom,

    this is very impressive work.

    Is it possible to work on map in any China cities, like Hong Kong, Shanghai, Beijing?

    thanks.

    Wallace

  53. carlos
    September 8, 2015 at 11:17 pm

    Hi Tom! Your work is absolutly amazing, thanks for the extensive analisis, i was wondering if you could do Buenos Aires.
    Saludos!

  54. Arturo
    October 4, 2015 at 3:51 am

    Hi Tom, sorry for asking for one more city. Could you please list Moscow? I would appreciate it so much. Thanks for the nice job.

  55. Silvia
    October 5, 2015 at 12:04 am

    Dear Tom,
    this work is remarkable!
    Please can you add a map of Florence, Italy?
    Here the city center is almost empty of inhabitants who were substituted by touristic rentals (much more lucrative than normal rentals).
    I read an article in which it is said that Italy represents quite the 10% of the total AirBnB offer.
    Thank you very much.
    Silvia

    • Tom Slee
      November 16, 2015 at 10:56 pm

      Wow – Florence is certainly very full of listings for a small city. Thanks for suggesting it. The 10% figure sounds quite possible. You can find the spreadsheet and map above.

      Tom

  56. Dan Cookson
    October 21, 2015 at 5:17 am

    Hello

    I’ll add my voice to all those impressed by your service. I am very keen to understand how the impact of holiday/short let business on the city – particularly the loss of accommodation for regular residents who might want to rent longer term. Am particularly interested in Scottish cities – especially Edinburgh. Would be willing to make a contribution for your time/effort.

    Thanks
    Dan

  57. Demian
    October 28, 2015 at 7:44 am

    Hi Tom, really nice work! I’m working on a project about Antwerpen, could you help me make on for this city?

    With kind regards

    Demian

  58. Venere
    November 3, 2015 at 12:10 pm

    Dear Tom,

    Your work is great and really useful!

    I am working on Rome, Italy.
    I see that you updated the data for 2014… would it be possible for you to add some more data for 2015 as well?

    Thanks a lot for your great great and valuable contribution.

    Venere

    • Tom Slee
      November 16, 2015 at 10:42 pm

      Hi Venere,

      I’ve added an update of Rome. You’ll see it includes some listings a long way away (northern Italy). I can fix that, but need a shapefile of Rome boundaries. If you can find one, I’ll update. I’m at tom at tomslee dot net.

  59. Drew
    November 3, 2015 at 9:32 pm

    This info is great, it is very helpful for a school project I am working on. Would you be able to do a map for Santa Fe or Albuquerque?

    Thanks!

  60. Tom Slee
    November 4, 2015 at 8:45 am

    I have a few software problems at the moment – hope to get to the most recent requests in the next week.

  61. Soo
    November 14, 2015 at 8:37 pm

    Hi Tom,
    Sorry to add more requests but would you have any data for Whistler, BC, Canada? Love your work on this 🙂

  62. Murray
    November 17, 2015 at 1:50 am

    Tom, try this:

    http://www.istat.it/it/archivio/124086

    You want the Comune geography – there should be one labelled “Roma”…

    —
    Murray

  63. Carlos
    November 23, 2015 at 2:03 pm

    Hi Tom,
    I follow all your posts and was wondering if you could add Buenos Aires to your data set too.
    Saludos!

  64. Baz
    December 13, 2015 at 7:13 pm

    If you’re still working on this, I had a peek at the airbnb site where it allows you to select your currency.

    It seems to be set with a cookie – here are the request ‘Cookie:’ headers for EUR and CAD:

    _user_attributes=%7B%22curr%22%3A%22EUR%22%2C%22guest_exchange%22%3A0.91012%2C%22device_profiling_session_id%22%3A%221450051038–729f4a3864519714b2cb7ed6%22%7D;

    _user_attributes=%7B%22curr%22%3A%22CAD%22%2C%22guest_exchange%22%3A1.37582%2C%22device_profiling_session_id%22%3A%221450051038–729f4a3864519714b2cb7ed6%22%7D;

    This looks like JSON but URLencoded:

    _user_attributes={“curr”:”EUR”,”guest_exchange”:0.91012,”device_profiling_session_id”:”1450051038–729f4a3864519714b2cb7ed6″};

    _user_attributes={“curr”:”CAD”,”guest_exchange”:1.37582,”device_profiling_session_id”:”1450051038–729f4a3864519714b2cb7ed6″};

    The “guest_exchange” value is presumably a conversion rate. I was looking at St Petersburg, FL
    Changing the currency to USD gives this value:

    _user_attributes={“curr”:”USD”,”guest_exchange”:1.0,”device_profiling_session_id”:”1450051038–729f4a3864519714b2cb7ed6″};

  65. Jan Rudzik
    December 18, 2015 at 5:52 am

    Hello Tom,
    first of all i like to join the numerous compliments for your great work ! I am doing research for my thesis about air BNB in Germany right now.

    Could you help me out with Hamburg and/or Bremen?
    Thanks in advance

    • Tom Slee
      January 5, 2016 at 9:17 pm

      Done. If you feel like telling me more about your research I’d be interested.

      • Jan Rudzik
        January 10, 2016 at 5:44 pm

        Thank you very much Tom, just saw your work on Germany!
        The thesis is about the disruptive effect off airbnb on the accomodation sector and the strategic implications for traditional hotels etc., yet i am in the research and conception stage but i am happy to tell you more, if you are interested 🙂 just let me know

  66. John Paul
    January 4, 2016 at 9:06 am

    Thanks for all your work Tom. Would you mind having a go at Valencia for me? Muchly appreciated.

  67. Filipe
    January 6, 2016 at 4:54 am

    Hi Tom,

    Very nice work!! Would it be possible to have the data on Zurich please?

    Best!

  68. Nick
    January 8, 2016 at 4:13 am

    Hi Tom,

    I’d like to access the data from London you posted, however, when clicking on the link there’s only the map for London but no option to open the fusion table. Could you provide me with the data in table format please?

    Thanks!

  69. liz
    January 9, 2016 at 10:08 pm

    Hi Tom
    WOW. Thank you for all this amazing work. I was hoping for two things 1) Brisbane to be updated as it is 18 months old now and I believe has changed significantly in that time and 2) Do you have any data for Melbourne?
    Thanks so much again for all your work.
    Liz

  70. Susan
    January 12, 2016 at 4:40 pm

    Hi Tom,

    This is amazing work!!!
    I’d like to access the data from London you posted for my architectural research , however, when clicking on the link there’s only the map for London but no option to open the fusion table. Could you provide me with the data in table format please?

    Many Thanks!

  71. Walter
    January 13, 2016 at 1:31 pm

    Hi Tom,
    it is a great an impressive work. I’m an Italian guy and i’d really like if you could help me with the data from Bologna – Italy

    Bests
    Walter

  72. Dan Ungaretti
    January 25, 2016 at 2:19 pm

    Hello and great work, Is it possible to get a link to the London data table please?

  73. Olivier
    February 7, 2016 at 6:42 am

    Hi Tom, very impressive and helpful work. When you have time, would it be possible to add Marseille city in France?
    Thanks,
    Olivier

        • Tom Slee
          March 4, 2016 at 3:33 pm

          Marseille finally added.

          • Olivier
            March 4, 2016 at 6:27 pm

            Thanks Tom, really appreciated. Will work on it and share the results of my analysis.

          • Olivier
            March 5, 2016 at 9:06 am

            Hi Tom,

            Have started to look at the data and see that many rooms are missing in some areas. Can send you exemples but if you look at “L’Estaque” part north of Marseille, your file displays 2 rooms_id when Airbnb has 4 pages with a total of 61 rooms_id.
            Have selected some randomly and they are indeed missing so not a question of mapping.
            Trying to understand where the difference could come from, was wondering if you extract only rooms that are not booked the day of the extract? (But probably will not be enough to explain the difference).

            If you think that altogether, Marseille has 7635 hotel and residence bedrooms and your file gives 5581 bedrooms from Airbnb, we can understood the level of impact it might have on the industry.

            Another peace of analysis is that we have clearly hotels having closed as such and switch to an Airbnb bedrooms model.

            Will continue to dig into it and provide feed-back.

          • Tom Slee
            March 5, 2016 at 9:36 am

            Hi Olivier,

            I think L’Estaque is too far from the city to have been caught by my search. The search goes through the neighbourhoods listed on the Airbnb web site for Marseille, and L’Estaque is not included. That said, occasionally listings far from the city do get mixed in with other Airbnb search results.

            I have two kinds of map here (and should point this out at the heading of the post): one is simply “listings that show up when you search through Airbnb for listings in a given city, no matter where they actually are” and the second (better) type is listings combined with a GIS map of the city, so that neighbourhoods are better represented. I will try to mark the maps.

            If you want to go beyond Marseille proper, we will have to look for ways to configure the search so that L’Estaque is included.

  74. Tom Slee
    February 7, 2016 at 11:49 am

    New maps for Bergen, Oslo, Bologna, and Melbourne

  75. David
    February 7, 2016 at 7:10 pm

    Curious question… What about Rural Areas? I am located in the US (Vermont) and am curious if there is a measurable impact on rural housing? Rent in the Montpelier area is high by my standards ($500/room or $1200/house) and many people live in sub-standard mobile home trailers or other decrepit conditions.

    I’m not asking for a survey of a rural area yet, just trying to spark a conversation about AirBnB impacts beyond the cities.

    One other piece of context, a friend recently rented another house for the winter to try to pay the heat and cover part of the mortgage while it languishes on our sluggish housing market. Instead he had to spend $25,000 fixing damage done to the basement foundation by the tenants (insulation that led to failure of a wall). Had he had Air BnB as the broker it would’ve presumably covered it.

    It is a platform, can it be used for good too?

  76. Dora
    February 9, 2016 at 10:33 pm

    Hi Tom,

    Great work, very impressive.:) Could you please add Prague (Czech Republic) and also Budapest (Hungary)?
    Thanks very much.
    All the best,
    Dora

  77. Andrew
    February 16, 2016 at 12:52 am

    Hi Tom, very impressive work! When you have time, would it be possible to add Victoria, BC?
    Thanks,
    Andrew

  78. Ge DE
    February 22, 2016 at 10:42 am

    Wow….. good work Tom!

    What about Munich, Germany? I would be interested now and later of the year (in Oktober is the Oktoberfest – prices increase up to 500% in some accommodations).

    Also a new file for Berlin, Germany would be interesting e.g. in next month as airbnb deleted several multihosts in February 2016 (they not visible anymore after 02 March 2016 as far as I know).

    Thanks very much.
    All the best,
    Ge DE

    • Tom Slee
      March 4, 2016 at 3:27 pm

      The most recent data I have is from November 2015, which I have now posted. I will get to the others ASAP, including a new survey of Berlin.

  79. Shabrina
    February 26, 2016 at 10:37 am

    Hi Tom,

    This is impressive! I’m doing a study about this, is it possible if you can do Bali, Indonesia for me? I would really appreciate it.

    Thanks!
    ZS

  80. tommaso
    March 4, 2016 at 6:48 am

    Hi Tom, really impressive. If you’re still working on this, i cannot find the code on github, I’m doing a research on Torino,italy about gentrification, house price rising and tourism. it would be amazing if you could add the data for me. Thank you very match, tommaso

  81. Tom Slee
    March 4, 2016 at 3:18 pm

    New maps for Hong Kong, Spoleto (Italy), and Mallorca

    • Veronica
      March 8, 2016 at 9:31 am

      Thank you very much Tom! I am really impressed, do you think you could try to download more info about the listings in Mallorca?
      Cheers

      • Tom Slee
        March 15, 2016 at 9:45 pm

        Hi Veronica,

        It looks to me like the data for Mallorca is incomplete. You may wish to look at http://insideairbnb.com/mallorca/, which reports many more listings.

        • veronica
          March 17, 2016 at 8:58 am

          Hi Tom thank you very much for your prompt answer!
          Yes, from the dataset I can see there is only few available variable compared to the other european cities.

          Sorry for asking you again but I would be really interested in having data about Rímini (Italy). Do you thing is it posible to have for Rímini a complete dataset as for, for example, Barcelona?

          Thanks again for the all the work you have been doing.

          Cheers

          V

  82. Olivier
    March 5, 2016 at 9:48 am

    Tom,

    Understood the logic.
    l’Estaque is within the border of Marseille (16th quarter), not a subburn or a neighborhood but true that the city is quite large.
    Would you have a listing with all the Marseille city available as when you search Marseille on Airbnb and I can adjust the geographical impact to filter and send back the result?

  83. Federico
    March 5, 2016 at 10:00 am

    Thank you so much, Tom; i just received the data I needed for Spoleto. Let me know how to help your project.

  84. Bruce
    March 6, 2016 at 5:08 pm

    Hey Tom impressive work. Would you consider adding Orlando Florida to your site? I think we really have two markets here. One is in the downtown area (32801) while another clusters around the Disney attractions to the southwest of the city.

    Thanks for your consideration!

  85. Uni
    March 7, 2016 at 1:27 pm

    great work, I would appreciate a map of Reykjavík, Iceland
    thank you
    -uni

  86. Isaia
    March 18, 2016 at 6:34 am

    Hi Tom,

    Great work! Could you please add Bergamo (Italy)?
    Thanks very much.
    All the best,
    Isaia

  87. Quang
    March 20, 2016 at 7:29 pm

    Hi Tom,

    Really awesome work and how many people you´ve helped 🙂

    I would Like to ask you if you could add Prague (Czech Republic)

    Currently I am writing my bachelor thesis on rising shadow economy and its impact on Czech Tourism by screening the Airbnb

    I have growth listings from May(2014) to February(2015) so 10months from (http://home-for-prague.com/) and here is the question if it is possible to find the total number of listings Before May(2014)? like Jan,Feb,Ap (2014) it would really helped me to have more roboust econometric model.

    Thank you for your work Quang.

  88. Tom Slee
    March 20, 2016 at 10:26 pm

    New maps and data sets for Lisbon, Bordeaux, Miami, Stockholm, and Philadelphia.

  89. Makis
    March 22, 2016 at 9:26 am

    Hello Tom!
    Your work is great and very helpful. I come from Athens, Greece so I want to ask you to publish dataset and map(if possible).
    I used to work with GIS so I know there are very interesting things to do with the data.

  90. Tom Slee
    March 22, 2016 at 9:43 pm

    A note to anyone subscribed to this page. I have found that for cities with few (or no) neighbourhoods listed in Airbnb filters, I am regularly missing listings (see Groningen and Mallorca above for examples). This affects some requests like Phoenix, Torino, Frankfurt and Orlando. I would like to implement a different search algorithm than “loop over neighborhoods” but it will probably take a few weeks. Thanks for your patience.

Comments are closed