Airbnb Listing Data for New York City

Kan Nishida Updated 2/12/2021 6:47:43 PM UTC3k 3

Airbnb

Sample Data

Data Catalog

Numeric

Not NA: 100.00%

NA0 (0.00%)

Min5,441

Max40,570,168

Median21,537,724

Average21,398,713

Std Dev12,463,983.91

name

Character

Home away from home (6)

Home away from home: 6 (0.06%)

Hillside Hotel (5)

Hillside Hotel: 5 (0.05%)

AMAZING STUDIO AT THE TIME SQUARE AREA. (4)

AMAZING STUDIO AT THE TIME SQUARE AREA.: 4 (0.04%)

AMAZING ONE BEDROOM AT THE TIME SQUARE AREA. (3)

AMAZING ONE BEDROOM AT THE TIME SQUARE AREA.: 3 (0.03%)

Cozy Apartment (3)

Cozy Apartment: 3 (0.03%)

Cozy Brooklyn Apartment (3)

Cozy Brooklyn Apartment: 3 (0.03%)

(Others) (9,973)

(Others): 9,973 (99.73%)

Not NA: 99.97%

NA: 0.03%

NA3 (0.03%)

Unique Values9,935

Min Length1

Max Length161

host_id

Numeric

Not NA: 100.00%

NA0 (0.00%)

Min2,787

Max3.1436e+8

Median34,614,330

Average77,975,396

Std Dev91,052,075.31

host_name

Character

Michael (90)

Michael: 90 (0.90%)

David (66)

David: 66 (0.66%)

Blueground (62)

Blueground: 62 (0.62%)

Sonder (NYC) (57)

Sonder (NYC): 57 (0.57%)

Maria (48)

Maria: 48 (0.48%)

Alex (46)

Alex: 46 (0.46%)

(Others) (9,515)

(Others): 9,515 (95.15%)

Not NA: 98.84%

NA: 1.16%

NA116 (1.16%)

Unique Values4,204

Min Length1

Max Length35

host_since

Date

Not NA: 98.84%

NA: 1.16%

NA116 (1.16%)

Min2008-09-07

Max2019-12-03

Median2015-06-04

Average2015-06-27

host_location

Character

New York, New York, United States (6,368)

New York, New York, United States: 6,368 (63.68%)

US (1,109)

US: 1,109 (11.09%)

Brooklyn, New York, United States (800)

Brooklyn, New York, United States: 800 (8.00%)

Queens, New York, United States (263)

Queens, New York, United States: 263 (2.63%)

San Francisco, California, United States (69)

San Francisco, California, United States: 69 (0.69%)

Los Angeles, California, United States (48)

Los Angeles, California, United States: 48 (0.48%)

(Others) (1,193)

(Others): 1,193 (11.93%)

Not NA: 98.50%

NA: 1.50%

NA150 (1.50%)

Unique Values538

Min Length2

Max Length55

host_response_time

Character

within an hour (3,913)

within an hour: 3,913 (39.13%)

within a few hours (1,510)

within a few hours: 1,510 (15.10%)

within a day (919)

within a day: 919 (9.19%)

a few days or more (195)

a few days or more: 195 (1.95%)

Not NA: 65.37%

NA: 34.63%

NA3,463 (34.63%)

Unique Values4

Min Length12

Max Length18

host_response_rate

Character

100% (4,422)

100%: 4,422 (44.22%)

90% (344)

90%: 344 (3.44%)

80% (178)

80%: 178 (1.78%)

97% (159)

97%: 159 (1.59%)

99% (158)

99%: 158 (1.58%)

50% (97)

50%: 97 (0.97%)

(Others) (1,179)

(Others): 1,179 (11.79%)

Not NA: 65.37%

NA: 34.63%

NA3,463 (34.63%)

Unique Values65

Min Length2

Max Length4

host_is_superhost

Logical

TRUE (1,891)

TRUE : 1,891 (18.91%)

FALSE (7,993)

FALSE: 7,993 (79.93%)

Not NA: 98.84%

NA: 1.16%

NA116 (1.16%)

TRUE1,891 (18.91%)

FALSE7,993 (79.93%)

host_total_listings_count

Numeric

Not NA: 98.84%

NA: 1.16%

NA116 (1.16%)

Min0

Max1,767

Median1

Average18.71

Std Dev116.37

neighbourhood

Character

Williamsburg (798)

Williamsburg: 798 (7.98%)

Bedford-Stuyvesant (791)

Bedford-Stuyvesant: 791 (7.91%)

Harlem (525)

Harlem: 525 (5.25%)

Bushwick (478)

Bushwick: 478 (4.78%)

Hell's Kitchen (416)

Hell's Kitchen: 416 (4.16%)

Upper West Side (372)

Upper West Side: 372 (3.72%)

(Others) (6,620)

(Others): 6,620 (66.20%)

Not NA: 100.00%

NA0 (0.00%)

Unique Values195

Min Length4

Max Length25

neighbourhood_group

Character

Manhattan (4,338)

Manhattan: 4,338 (43.38%)

Brooklyn (4,135)

Brooklyn: 4,135 (41.35%)

Queens (1,223)

Queens: 1,223 (12.23%)

Bronx (225)

Bronx: 225 (2.25%)

Staten Island (79)

Staten Island: 79 (0.79%)

Not NA: 100.00%

NA0 (0.00%)

Unique Values5

Min Length5

Max Length13

city

Character

New York (4,412)

New York: 4,412 (44.12%)

Brooklyn (4,031)

Brooklyn: 4,031 (40.31%)

Queens (963)

Queens: 963 (9.63%)

Bronx (146)

Bronx: 146 (1.46%)

Staten Island (76)

Staten Island: 76 (0.76%)

The Bronx (61)

The Bronx: 61 (0.61%)

(Others) (283)

(Others): 283 (2.83%)

Not NA: 99.72%

NA: 0.28%

NA28 (0.28%)

Unique Values105

Min Length2

Max Length29

state

Character

NY (9,998)

NY: 9,998 (99.98%)

Ny (1)

Ny: 1 (0.01%)

Not NA: 99.99%

NA: 0.01%

NA1 (0.01%)

Unique Values2

Min Length2

Max Length2

zipcode

Numeric

Not NA: 98.41%

NA: 1.59%

NA159 (1.59%)

Min10,001

Max11,694

Median11,106

Average10,691

Std Dev599.83

market

Character

New York (9,972)

New York: 9,972 (99.72%)

Other (Domestic) (3)

Other (Domestic): 3 (0.03%)

Agra (1)

Agra: 1 (0.01%)

D.C. (1)

D.C.: 1 (0.01%)

Kyoto (1)

Kyoto: 1 (0.01%)

Not NA: 99.78%

NA: 0.22%

NA22 (0.22%)

Unique Values5

Min Length4

Max Length16

latitude

Numeric

Not NA: 100.00%

NA0 (0.00%)

Min40.5

Max40.92

Median40.72

Average40.73

Std Dev0.05

longitude

Numeric

Not NA: 100.00%

NA0 (0.00%)

Min-74.25

Max-73.71

Median-73.96

Average-73.95

Std Dev0.05

property_type

Character

Apartment (7,862)

Apartment: 7,862 (78.62%)

House (845)

House: 845 (8.45%)

Townhouse (328)

Townhouse: 328 (3.28%)

Condominium (326)

Condominium: 326 (3.26%)

Loft (283)

Loft: 283 (2.83%)

Guest suite (88)

Guest suite: 88 (0.88%)

(Others) (268)

(Others): 268 (2.68%)

Not NA: 100.00%

NA0 (0.00%)

Unique Values27

Min Length4

Max Length18

room_type

Character

Entire home/apt (5,186)

Entire home/apt: 5,186 (51.86%)

Private room (4,473)

Private room: 4,473 (44.73%)

Shared room (267)

Shared room: 267 (2.67%)

Hotel room (74)

Hotel room: 74 (0.74%)

Not NA: 100.00%

NA0 (0.00%)

Unique Values4

Min Length10

Max Length15

accommodates

Numeric

Not NA: 100.00%

NA0 (0.00%)

Min1

Max19

Median2

Average2.861

Std Dev1.93

bathrooms

Numeric

Not NA: 99.90%

NA: 0.10%

NA10 (0.10%)

Min0

Max7.5

Median1

Average1.151

Std Dev0.44

bedrooms

Numeric

Not NA: 99.85%

NA: 0.15%

NA15 (0.15%)

Min0

Max21

Median1

Average1.191

Std Dev0.81

beds

Numeric

Not NA: 99.70%

NA: 0.30%

NA30 (0.30%)

Min0

Max21

Median1

Average1.558

Std Dev1.16

bed_type

Character

Real Bed (9,857)

Real Bed: 9,857 (98.57%)

Futon (57)

Futon: 57 (0.57%)

Pull-out Sofa (42)

Pull-out Sofa: 42 (0.42%)

Airbed (29)

Airbed: 29 (0.29%)

Couch (15)

Couch: 15 (0.15%)

Not NA: 100.00%

NA0 (0.00%)

Unique Values5

Min Length5

Max Length13

square_feet

Numeric

Not NA: 0.76%

NA: 99.24%

NA9,924 (99.24%)

Min0

Max2,400

Median700

Average647.1

Std Dev498.00

price

Character

$150.00 (411)

$150.00: 411 (4.11%)

$100.00 (409)

$100.00: 409 (4.09%)

$50.00 (310)

$50.00: 310 (3.10%)

$200.00 (292)

$200.00: 292 (2.92%)

$60.00 (279)

$60.00: 279 (2.79%)

$75.00 (275)

$75.00: 275 (2.75%)

(Others) (8,024)

(Others): 8,024 (80.24%)

Not NA: 100.00%

NA0 (0.00%)

Unique Values446

Min Length5

Max Length10

weekly_price

Character

$600.00 (52)

$600.00: 52 (0.52%)

$500.00 (50)

$500.00: 50 (0.50%)

$1,000.00 (41)

$1,000.00: 41 (0.41%)

$800.00 (38)

$800.00: 38 (0.38%)

$350.00 (35)

$350.00: 35 (0.35%)

$450.00 (35)

$450.00: 35 (0.35%)

(Others) (866)

(Others): 866 (8.66%)

Not NA: 11.17%

NA: 88.83%

NA8,883 (88.83%)

Unique Values294

Min Length7

Max Length10

monthly_price

Character

$3,000.00 (49)

$3,000.00: 49 (0.49%)

$2,000.00 (45)

$2,000.00: 45 (0.45%)

$2,500.00 (34)

$2,500.00: 34 (0.34%)

$1,500.00 (28)

$1,500.00: 28 (0.28%)

$1,400.00 (26)

$1,400.00: 26 (0.26%)

$2,700.00 (26)

$2,700.00: 26 (0.26%)

(Others) (768)

(Others): 768 (7.68%)

Not NA: 9.76%

NA: 90.24%

NA9,024 (90.24%)

Unique Values252

Min Length7

Max Length10

security_deposit

Character

$0.00 (2,508)

$0.00: 2,508 (25.08%)

$100.00 (787)

$100.00: 787 (7.87%)

$500.00 (719)

$500.00: 719 (7.19%)

$200.00 (518)

$200.00: 518 (5.18%)

$300.00 (382)

$300.00: 382 (3.82%)

$250.00 (321)

$250.00: 321 (3.21%)

(Others) (1,243)

(Others): 1,243 (12.43%)

Not NA: 64.78%

NA: 35.22%

NA3,522 (35.22%)

Unique Values100

Min Length5

Max Length9

cleaning_fee

Character

$50.00 (830)

$50.00: 830 (8.30%)

$100.00 (768)

$100.00: 768 (7.68%)

$30.00 (487)

$30.00: 487 (4.87%)

$0.00 (450)

$0.00: 450 (4.50%)

$25.00 (450)

$25.00: 450 (4.50%)

$20.00 (436)

$20.00: 436 (4.36%)

(Others) (4,495)

(Others): 4,495 (44.95%)

Not NA: 79.16%

NA: 20.84%

NA2,084 (20.84%)

Unique Values148

Min Length5

Max Length9

guests_included

Numeric

Not NA: 100.00%

NA0 (0.00%)

Min1

Max16

Median1

Average1.53

Std Dev1.18

extra_people

Character

$0.00 (5,283)

$0.00: 5,283 (52.83%)

$25.00 (798)

$25.00: 798 (7.98%)

$20.00 (708)

$20.00: 708 (7.08%)

$10.00 (582)

$10.00: 582 (5.82%)

$50.00 (520)

$50.00: 520 (5.20%)

$15.00 (497)

$15.00: 497 (4.97%)

(Others) (1,612)

(Others): 1,612 (16.12%)

Not NA: 100.00%

NA0 (0.00%)

Unique Values78

Min Length5

Max Length7

minimum_nights

Numeric

Not NA: 100.00%

NA0 (0.00%)

Min1

Max1,250

Median3

Average8.008

Std Dev26.71

maximum_nights

Numeric

Not NA: 100.00%

NA0 (0.00%)

Min1

Max11,111

Median1,124

Average603.4

Std Dev560.14

availability_365

Numeric

Not NA: 100.00%

NA0 (0.00%)

Min0

Max365

Median45

Average113.4

Std Dev135.77

number_of_reviews

Numeric

Not NA: 100.00%

NA0 (0.00%)

Min0

Max630

Median6

Average24.36

Std Dev46.13

review_scores_rating

Numeric

Not NA: 77.96%

NA: 22.04%

NA2,204 (22.04%)

Min20

Max100

Median96

Average93.81

Std Dev8.61

instant_bookable

Logical

TRUE (3,788)

TRUE : 3,788 (37.88%)

FALSE (6,212)

FALSE: 6,212 (62.12%)

Not NA: 100.00%

NA0 (0.00%)

TRUE3,788 (37.88%)

FALSE6,212 (62.12%)

is_business_travel_ready

Logical

TRUE (0)

TRUE : 0 (0.00%)

FALSE (10,000)

FALSE: 10,000 (100.00%)

Not NA: 100.00%

NA0 (0.00%)

TRUE0 (0.00%)

FALSE10,000 (100.00%)

cancellation_policy

Character

strict_14_with_grace_period (4,535)

strict_14_with_grace_period: 4,535 (45.35%)

flexible (3,104)

flexible: 3,104 (31.04%)

moderate (2,319)

moderate: 2,319 (23.19%)

super_strict_60 (27)

super_strict_60: 27 (0.27%)

strict (10)

strict: 10 (0.10%)

super_strict_30 (5)

super_strict_30: 5 (0.05%)

Not NA: 100.00%

NA0 (0.00%)

Unique Values6

Min Length6

Max Length27

reviews_per_month

Numeric

Not NA: 79.81%

NA: 20.19%

NA2,019 (20.19%)

Min0.01

Max16.89

Median0.73

Average1.382

Std Dev1.66

42 Columns 10,000 Rows

Description

Data Source:

http://insideairbnb.com/new-york-city/

Data Dictionary

Column Name

Description

name

host_id

host_name

host_since

host_location

host_response_time

host_response_rate

host_is_superhost

host_total_listings_count

neighbourhood

neighbourhood_group

city

state

zipcode

market

latitude

longitude

property_type

room_type

accommodates

bathrooms

bedrooms

beds

bed_type

square_feet

price

weekly_price

monthly_price

security_deposit

cleaning_fee

guests_included

extra_people

minimum_nights

maximum_nights

availability_365

number_of_reviews

review_scores_rating

instant_bookable

is_business_travel_ready

cancellation_policy

reviews_per_month

Other Information

Size

3M bytes

Type

CSV - Local

Details

Parameter

Value

File

nyc_listings.csv

Folder

/Users/kannishida/Dropbox/Data

Treat These As NA

N/A