Created
February 17, 2015 14:39
-
-
Save talos/da10ca658312613c01a4 to your computer and use it in GitHub Desktop.
5+ airbnb unit buildings in nyc
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| COUNT(*) | host_id | street | avg(latitude) | avg(longitude) | neighbourhood_cleansed | |
|---|---|---|---|---|---|---|
| 28 | 1329986 | Covert Street, Brooklyn, NY 11207, United States | 40.6897709856896 | -73.9099505334989 | Bushwick | |
| 25 | 20780082 | 45th Street, Brooklyn, NY 11220, United States | 40.6408982219979 | -74.0054280464033 | Sunset Park | |
| 21 | 417504 | Box St, Brooklyn, NY 11222, United States | 40.7375268363829 | -73.9533337391861 | Greenpoint | |
| 13 | 577199 | A Patchen Avenue, Brooklyn, NY 11221, United States | 40.688390328439 | -73.9269561652776 | Bedford-Stuyvesant | |
| 12 | 469713 | Taaffe Place, Brooklyn, NY 11205, United States | 40.6914523965438 | -73.9593211900759 | Clinton Hill | |
| 11 | 5219616 | A Jefferson Avenue, Brooklyn, NY 11221, United States | 40.6852469923265 | -73.9289235404313 | Bedford-Stuyvesant | |
| 11 | 6885157 | Jefferson Avenue, Brooklyn, NY 11216, United States | 40.6830812633974 | -73.9507476222691 | Bedford-Stuyvesant | |
| 10 | 2156913 | 30th Ave, Astoria , NY 11103, United States | 40.7649092318874 | -73.9176678069283 | Astoria | |
| 10 | 3968794 | 60th Street, Brooklyn, NY 11219, United States | 40.6343721405506 | -74.0072623321732 | Sunset Park | |
| 9 | 1100494 | Broadway, New York, NY 10031, United States | 40.8221921240769 | -73.9541339301218 | Hamilton Heights | |
| 9 | 1177497 | Washington Ave, Brooklyn, NY 11205, United States | 40.6902837625491 | -73.9670284961616 | Clinton Hill | |
| 9 | 23034412 | Evergreen Avenue, Brooklyn, NY 11207, United States | 40.6886210166008 | -73.912731263304 | Bushwick | |
| 8 | 7414 | Fort Greene Place, Brooklyn, NY 11217, United States | 40.6862673957407 | -73.976675051135 | Fort Greene | |
| 8 | 3892871 | Westervelt Avenue, Staten Island, NY 10301, United States | 40.6450203016903 | -74.0853168074978 | St. George | |
| 8 | 4087416 | South 4th Street, Brooklyn, NY 11249, United States | 40.7124302739034 | -73.9632003202479 | Williamsburg | |
| 8 | 5573965 | McKibbin Street, Brooklyn, NY 11206, United States | 40.7053983536901 | -73.9372707278753 | Williamsburg | |
| 8 | 10384906 | 54th Street, Brooklyn, NY 11220, United States | 40.6385984520383 | -74.0099588518627 | Sunset Park | |
| 8 | 10781617 | Nugent Avenue, Staten Island, NY 10306, United States | 40.5740417579374 | -74.0950126499178 | Midland Beach | |
| 8 | 21022694 | South 4th Street, Brooklyn, NY 11249, United States | 40.7117886852611 | -73.96343469333 | Williamsburg | |
| 7 | 27848 | 140th Ave, Jamaica, NY 11434, United States | 40.6718529457207 | -73.7658858208359 | Jamaica | |
| 7 | 311286 | Park Place, Brooklyn, NY 11213, United States | 40.673712379594 | -73.9405425396888 | Crown Heights | |
| 7 | 319077 | Lexington Ave, Brooklyn, NY 11238, United States | 40.6866881331687 | -73.9615622299287 | Clinton Hill | |
| 7 | 417504 | Box Street, Brooklyn, NY 11222, United States | 40.7380208216454 | -73.9542650333317 | Greenpoint | |
| 7 | 972866 | Farragut Rd, Brooklyn, NY 11210, United States | 40.6366937955376 | -73.946465829524 | Flatbush | |
| 7 | 1559494 | Lorimer Street, Brooklyn, NY 11211, United States | 40.7127922046556 | -73.9493507872977 | Williamsburg | |
| 7 | 1745187 | Madison Street, Brooklyn, NY 11216, United States | 40.68663162241 | -73.9524476307309 | Bedford-Stuyvesant | |
| 7 | 1789655 | Evergreen Avenue, Brooklyn, NY 11221, United States | 40.6910968187487 | -73.9182293966242 | Bushwick | |
| 7 | 4313868 | Melrose St, Brooklyn, NY 11206, United States | 40.6976923253781 | -73.9355538344935 | Bushwick | |
| 7 | 5986733 | Quincy Street, Brooklyn, NY 11216, United States | 40.6865076399424 | -73.9527962975148 | Bedford-Stuyvesant | |
| 7 | 6874740 | 33rd Street, Astoria, NY 11105, United States | 40.7768473495059 | -73.90752799208 | Ditmars / Steinway | |
| 7 | 7291745 | East 35th Street, New York, NY 10016, United States | 40.744829767066 | -73.9748030036372 | Murray Hill | |
| 7 | 9834421 | Patchen Avenue, Brooklyn, NY 11233, United States | 40.6797857467091 | -73.926092051796 | Bedford-Stuyvesant | |
| 7 | 10027131 | Ocean Avenue, Brooklyn, NY 11230, United States | 40.6309588614493 | -73.9570101604233 | Flatbush | |
| 7 | 16621164 | East 47th Street, New York, NY 10017, United States | 40.7546751321128 | -73.9731948177294 | Midtown East | |
| 7 | 20219201 | Jefferson Avenue, Brooklyn, NY 11216, United States | 40.6826024641626 | -73.9532022811317 | Bedford-Stuyvesant | |
| 7 | 21382866 | Queens Boulevard, Queens, NY 11377, United States | 40.7409553584524 | -73.9019606005546 | Woodside | |
| 7 | 22064657 | West 36th Street, New York, NY 10018, United States | 40.750548445741 | -73.9853918126993 | Midtown | |
| 7 | 24154971 | West 173rd Street, New York, NY 10032, United States | 40.8454310298315 | -73.9409641425546 | Washington Heights | |
| 6 | 22486 | Park Pl, Brooklyn, NY 11217, United States | 40.6799441749608 | -73.977763258994 | Park Slope | |
| 6 | 29762 | A Hull St, Brooklyn, NY 11233, United States | 40.6792408489821 | -73.910792359786 | Bedford-Stuyvesant | |
| 6 | 605463 | Bleecker St, New York, NY 10014, United States | 40.7323244193427 | -74.0035456565936 | West Village | |
| 6 | 742817 | 9th Avenue, New York, NY 10036, United States | 40.7578116219509 | -73.9926654739159 | Hell's Kitchen | |
| 6 | 1217923 | Lefferts Pl, Brooklyn, NY 11238, United States | 40.6815147806287 | -73.9607119453131 | Clinton Hill | |
| 6 | 1258469 | Rutland Road, Brooklyn, NY 11225, United States | 40.6588870072813 | -73.9575334370495 | Lefferts Garden | |
| 6 | 1283252 | Catherine Street, New York, NY 10038, United States | 40.7121977590992 | -73.9973402465562 | Chinatown | |
| 6 | 1354796 | Midwood St, Brooklyn, NY 11225, United States | 40.6602472584337 | -73.9507711968966 | Lefferts Garden | |
| 6 | 2120259 | Empire Boulevard, Brooklyn, NY 11213, United States | 40.6641617611212 | -73.933586617727 | Crown Heights | |
| 6 | 2472305 | Rugby Rd, Brooklyn, NY 11226, United States | 40.6400893693333 | -73.964879215457 | Flatbush | |
| 6 | 3364967 | 14th street, Queens, NY 11106, United States | 40.7673323897595 | -73.9326150257431 | Astoria | |
| 6 | 3364967 | 33rd Street, Queens, NY 11105, United States | 40.7760362546235 | -73.9082610292145 | Ditmars / Steinway | |
| 6 | 3550417 | West 34th Street, New York, NY 10001, United States | 40.7554068876708 | -73.9986089055239 | Hell's Kitchen | |
| 6 | 3625735 | Columbus Avenue, Staten Island, NY 10304, United States | 40.6006372817907 | -74.0904580213897 | Concord | |
| 6 | 3864301 | 49th Street, Queens, NY 11104, United States | 40.7446479917628 | -73.9158641517648 | Sunnyside | |
| 6 | 4014688 | 3rd Ave, New York, NY 10003, United States | 40.7314183328974 | -73.9892786804737 | East Village | |
| 6 | 4116544 | Greene Avenue, Brooklyn, NY 11237, United States | 40.702796605082 | -73.9128633201932 | Bushwick | |
| 6 | 5164854 | West 143rd Street, New York, NY 10030, United States | 40.8207248712548 | -73.9377961289965 | Harlem | |
| 6 | 6079166 | 147th Street, Flushing, NY 11355, United States | 40.757024463123 | -73.8159369410341 | Flushing | |
| 6 | 6158233 | W 151st st, New York, NY 10031, United States | 40.8307581874742 | -73.9479879293708 | Hamilton Heights | |
| 6 | 7557833 | Kosciuszko Street, Brooklyn, NY 11216, United States | 40.6913330945317 | -73.9459186334439 | Bedford-Stuyvesant | |
| 6 | 9113389 | Eastern Parkway, Brooklyn, NY 11233, United States | 40.6773360775311 | -73.9072604723908 | Bedford-Stuyvesant | |
| 6 | 9614926 | Chauncey Street, Brooklyn, NY 11207, United States | 40.6846852977973 | -73.9087061557131 | Bushwick | |
| 6 | 14061862 | South 2nd Street, Brooklyn, NY 11249, United States | 40.7139471598473 | -73.9622453361601 | Williamsburg | |
| 6 | 14103991 | Smart Street, Flushing, NY 11355, United States | 40.7555701113459 | -73.8193058320107 | Flushing | |
| 6 | 14951748 | South 2nd Street, Brooklyn, NY 11249, United States | 40.7135950321617 | -73.9627922839386 | Williamsburg | |
| 6 | 15718962 | West 40th Street, New York, NY 10018, United States | 40.7581682690528 | -73.9935191745065 | Hell's Kitchen | |
| 6 | 16299045 | Locust Street, Brooklyn, NY 11206, United States | 40.6991339061181 | -73.9382553277813 | Bushwick | |
| 6 | 17982907 | New York, NY 10036, United States | 40.7605530316965 | -73.9896550246334 | Hell's Kitchen | |
| 6 | 20611287 | South 4th Street, Brooklyn, NY 11249, United States | 40.7117458015524 | -73.9634904192241 | Williamsburg | |
| 6 | 23847934 | Catherine Street, New York, NY 10038, United States | 40.7118400827077 | -73.9969556663479 | Chinatown | |
| 5 | 7549 | Madison Street, New York, NY 10002, United States | 40.7135650858486 | -73.9897715799905 | Lower East Side | |
| 5 | 61414 | Putnam Avenue, Brooklyn, NY 11238, United States | 40.6829020738655 | -73.9593020514064 | Clinton Hill | |
| 5 | 72808 | Mermaid Avenue, Brooklyn, NY, United States | 40.5771185664027 | -73.9861104426094 | Coney Island | |
| 5 | 97797 | 4th St, Brooklyn, NY 11215, United States | 40.6707112358662 | -73.982085560703 | Park Slope | |
| 5 | 149430 | 2nd Ave, New York, NY 10029, United States | 40.7879307981727 | -73.9443307741736 | East Harlem | |
| 5 | 172137 | Parkside Ave, Brooklyn, NY 11225, United States | 40.6555186344676 | -73.9569740201284 | Lefferts Garden | |
| 5 | 256161 | W 129th St, New York, NY 10027, United States | 40.811844257133 | -73.9451095602015 | Harlem | |
| 5 | 568103 | Pearl St, New York, NY 10004, United States | 40.703036377345 | -74.0109505420642 | Financial District | |
| 5 | 575440 | Hudson Street, New York, NY 10013, United States | 40.7333650674561 | -74.0057617541692 | West Village | |
| 5 | 592967 | St Andrews Pl, Brooklyn, NY 11216, United States | 40.6785793207524 | -73.9431256804116 | Bedford-Stuyvesant | |
| 5 | 622855 | MacDonough Street, Brooklyn, NY 11233, United States | 40.6837593578141 | -73.9298068296044 | Bedford-Stuyvesant | |
| 5 | 652642 | Kent Ave, Brooklyn, NY 11211, United States | 40.7184367778204 | -73.9633624261805 | Williamsburg | |
| 5 | 652642 | West End Avenue, New York, NY 10023, United States | 40.7722463816511 | -73.9904036181188 | Upper West Side | |
| 5 | 739544 | Hancock Street, Brooklyn, NY 11216, United States | 40.6833748562169 | -73.9418743857493 | Bedford-Stuyvesant | |
| 5 | 942109 | Decatur Street, Brooklyn, NY 11216, United States | 40.6807327261326 | -73.9427837732066 | Bedford-Stuyvesant | |
| 5 | 1267021 | 73rd St, Queens, NY 11372, United States | 40.7502833652362 | -73.8907137485546 | Jackson Heights | |
| 5 | 1450351 | A Dekalb Ave, Brooklyn, NY 11221, United States | 40.6931758606771 | -73.931604922311 | Bedford-Stuyvesant | |
| 5 | 1709216 | New York Avenue, Brooklyn, NY 11210, United States | 40.6368126373279 | -73.9453241127882 | Flatbush | |
| 5 | 2313878 | Christopher Street, New York, NY 10014, United States | 40.7327783582193 | -74.0059439252764 | West Village | |
| 5 | 2347924 | Allen Street, New York, NY 10002, United States | 40.7155253628381 | -73.9893629866132 | Lower East Side | |
| 5 | 2604838 | South 4th Street, Brooklyn, NY 11211, United States | 40.7111721155157 | -73.9601936821703 | Williamsburg | |
| 5 | 2675644 | Clinton Ave, Staten Island , NY 10301, United States | 40.6463178705714 | -74.0834226408902 | St. George | |
| 5 | 2773081 | Clinton St, New York, NY 10002, United States | 40.7112410236623 | -73.9872307015323 | Lower East Side | |
| 5 | 3044041 | Shepherd Avenue, Brooklyn, NY 11208, United States | 40.670903746987 | -73.879813677533 | East New York | |
| 5 | 3388950 | Hart Street, Brooklyn, NY 11221, United States | 40.6948066715837 | -73.9339485002371 | Bedford-Stuyvesant | |
| 5 | 3531317 | Granite St, Brooklyn, NY 11207, United States | 40.6828159791959 | -73.9072990383677 | Bushwick | |
| 5 | 3814458 | West 39th Street, New York, NY 10018, United States | 40.7520648417359 | -73.9853693666819 | Midtown | |
| 5 | 4241953 | Beech Ave, Queens, NY 11355, United States | 40.7597619597936 | -73.8108102460168 | Flushing | |
| 5 | 4371099 | West 107th Street, New York, NY 10025, United States | 40.8006616427104 | -73.9616627711489 | Upper West Side | |
| 5 | 5238263 | North 7th Street, Brooklyn, NY 11211, United States | 40.7155165330945 | -73.9534831937479 | Williamsburg | |
| 5 | 7831209 | East 127th Street, New York, NY 10035, United States | 40.8066418281631 | -73.9393320856479 | East Harlem | |
| 5 | 7853251 | 175th Street, Queens, NY 11434, United States | 40.6897917659911 | -73.7738977235861 | Jamaica | |
| 5 | 7875402 | West 143rd Street, New York, NY 10030, United States | 40.8244259533634 | -73.9505178414631 | Hamilton Heights | |
| 5 | 8092574 | Adam Clayton Powell Junior Boulevard, New York, NY 10026, United States | 40.7996229326546 | -73.9551547137182 | Harlem | |
| 5 | 8288419 | 41st Street, Brooklyn, NY 11232, United States | 40.6449226220117 | -73.9961715847752 | Sunset Park | |
| 5 | 8775389 | Stanton Street, New York, NY 10002, United States | 40.7209543161681 | -73.9861907610448 | Lower East Side | |
| 5 | 9243259 | East 115th Street, New York, NY 10029, United States | 40.7978851626008 | -73.9405491347557 | East Harlem | |
| 5 | 9743617 | West 136th Street, New York, NY 10030, United States | 40.8153000876796 | -73.9418456334331 | Harlem | |
| 5 | 9828303 | West 43rd Street, New York, NY 10036, United States | 40.7599647992756 | -73.9941188842644 | Hell's Kitchen | |
| 5 | 10027131 | East 22nd Street, Brooklyn, NY 11226, United States | 40.6408525123223 | -73.9578431855617 | Flatbush | |
| 5 | 11494286 | Thompson Street, Manhattan, NY 10012, United States | 40.7280345421457 | -73.9999292212329 | Greenwich Village | |
| 5 | 14337935 | Park Avenue, Brooklyn, NY 11206, United States | 40.6981975628738 | -73.9477659864426 | Bedford-Stuyvesant | |
| 5 | 15241601 | Prospect Place, Brooklyn, NY 11238, United States | 40.6757806438648 | -73.9583411405359 | Crown Heights | |
| 5 | 15423843 | West 46th Street, New York, NY 10036, United States | 40.7624539068198 | -73.9908982899033 | Hell's Kitchen | |
| 5 | 17462748 | Bushwick Avenue, Brooklyn, NY 11207, United States | 40.6875326922551 | -73.9142469680172 | Bushwick | |
| 5 | 18397763 | Madison Street, Brooklyn, NY 11221, United States | 40.6867464682174 | -73.9315527823967 | Bedford-Stuyvesant | |
| 5 | 19354588 | West 40th Street, New York, NY 10018, United States | 40.7572246003159 | -73.9931656440042 | Hell's Kitchen | |
| 5 | 19513109 | Jefferson Ave, brooklyn, NY 11221, United States | 40.6907422537715 | -73.9140604670283 | Bushwick | |
| 5 | 21228368 | Kessel Street, Queens, NY 11375, United States | 40.7125661105404 | -73.8480395013543 | Forest Hills | |
| 5 | 23156574 | East 108th Street, New York, NY 10029, United States | 40.7927396899427 | -73.9437576957484 | East Harlem | |
| 5 | 23188519 | Vernon Avenue, Brooklyn, NY 11206, United States | 40.6938857428618 | -73.9505286185427 | Bedford-Stuyvesant |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment