Docs 主页 → 启动和管理 MongoDB → MongoDB Atlas
AirBnB 列表数据集样本
sample_airbnb数据库是 Inside AirBnB 上提供的度假屋列表和评论的汇编 。
要了解如何将 Atlas 提供的样本数据加载到集群，请参阅加载样本数据。
集合
该数据库包含一个名为 listingsAndReviews 的集合。
sample_airbnb.listingsAndReviews 集合包含代表度假屋列表详细信息和客户对列表的评论的文档。这些文档反映了全球几个城市的原始公开资料的随机子集。
索引
该集合包含以下索引：
名称 | 索引 | 说明 | 属性 |
|---|---|---|---|
_id_ | { "_id": 1 } | _id 字段的主键索引。 | |
property_type_1_room_type_1_beds_1 | {"property_type": 1,"room_type": 1,"beds": 1} | property_type 、 room_type和beds字段上的复合索引。 | |
name_1 | { "name": 1 } | name 字段的单字段升序索引，用于查询列表名称。 | |
address.location_2dsphere | {"address.location": "2dsphere"} | address.location GeoJSON 格式字段上的地理空间2 dsphere索引。 |
文档样本
{ "_id": "10006546", "listing_url": "https://www.airbnb.com/rooms/10006546", "name": "Ribeira Charming Duplex", "summary": "Fantastic duplex apartment with three bedrooms, located in the historic area of Porto, Ribeira (Cube)...", "interaction": "Cot - 10 € / night Dog - € 7,5 / night", "house_rules": "Make the house your home...", "property_type": "House", "room_type": "Entire home/apt", "bed_type": "Real Bed", "minimum_nights": "2", "maximum_nights": "30", "cancellation_policy": "moderate", "last_scraped": { "$date": { "$numberLong": "1550293200000" } }, "calendar_last_scraped": { "$date": { "$numberLong": "1550293200000" } }, "first_review": { "$date": { "$numberLong": "1451797200000" } }, "last_review": { "$date": { "$numberLong": "1547960400000" } }, "accommodates": { "$numberInt": "8" }, "bedrooms": { "$numberInt": "3" }, "beds": { "$numberInt": "5" }, "number_of_reviews": { "$numberInt": "51" }, "bathrooms": { "$numberDecimal": "1.0" }, "amenities": [ "TV", "Cable TV", "Wifi", "Kitchen", "Paid parking off premises", "Smoking allowed", "Pets allowed", "Buzzer/wireless intercom", "Heating", "Family/kid friendly", "Washer", "First aid kit", "Fire extinguisher", "Essentials", "Hangers", "Hair dryer", "Iron", "Pack ’n Play/travel crib", "Room-darkening shades", "Hot water", "Bed linens", "Extra pillows and blankets", "Microwave", "Coffee maker", "Refrigerator", "Dishwasher", "Dishes and silverware", "Cooking basics", "Oven", "Stove", "Cleaning before checkout", "Waterfront" ], "price": { "$numberDecimal": "80.00" }, "security_deposit": { "$numberDecimal": "200.00" }, "cleaning_fee": { "$numberDecimal": "35.00" }, "extra_people": { "$numberDecimal": "15.00" }, "guests_included": { "$numberDecimal": "6" }, "images": { "thumbnail_url": "", "medium_url": "", "picture_url": "https://a0.muscache.com/im/pictures/e83e702f-ef49-40fb-8fa0-6512d7e26e9b.jpg?aki_policy=large", "xl_picture_url": "" }, "host": { "host_id": "51399391", "host_url": "https://www.airbnb.com/users/show/51399391", "host_name": "Ana&Gonçalo", "host_location": "Porto, Porto District, Portugal", "host_about": "Gostamos de passear, de viajar, de conhecer pessoas e locais novos, gostamos de desporto e animais! Vivemos na cidade mais linda do mundo!!!", "host_response_time": "within an hour", "host_thumbnail_url": "https://a0.muscache.com/im/pictures/fab79f25-2e10-4f0f-9711-663cb69dc7d8.jpg?aki_policy=profile_small", "host_picture_url": "https://a0.muscache.com/im/pictures/fab79f25-2e10-4f0f-9711-663cb69dc7d8.jpg?aki_policy=profile_x_medium", "host_neighbourhood": "", "host_response_rate": { "$numberInt": "100" }, "host_is_superhost": false, "host_has_profile_pic": true, "host_identity_verified": true, "host_listings_count": { "$numberInt": "3" }, "host_total_listings_count": { "$numberInt": "3" }, "host_verifications": [ "email", "phone", "reviews", "jumio", "offline_government_id", "government_id" ] }, "address": { "street": "Porto, Porto, Portugal", "suburb": "", "government_area": "Cedofeita, Ildefonso, Sé, Miragaia, Nicolau, Vitória", "market": "Porto", "country": "Portugal", "country_code": "PT", "location": { "type": "Point", "coordinates": [ { "$numberDouble": "-8.61308" }, { "$numberDouble": "41.1413" } ], "is_location_exact": false } }, "availability": { "availability_30": { "$numberInt": "28" }, "availability_60": { "$numberInt": "47" }, "availability_90": { "$numberInt": "74" }, "availability_365": { "$numberInt": "239" } }, "review_scores": { "review_scores_accuracy": { "$numberInt": "9" }, "review_scores_cleanliness": { "$numberInt": "9" }, "review_scores_checkin": { "$numberInt": "10" }, "review_scores_communication": { "$numberInt": "10" }, "review_scores_location": { "$numberInt": "10" }, "review_scores_value": { "$numberInt": "9" }, "review_scores_rating": { "$numberInt": "89" } }, "reviews": [ { "_id": "362865132", "date": { "$date": { "$numberLong": "1545886800000" } }, "listing_id": "10006546", "reviewer_id": "208880077", "reviewer_name": "Thomas", "comments": "Very helpful hosts. Cooked traditional..." }, { "_id": "364728730", "date": { "$date": { "$numberLong": "1546232400000" } }, "listing_id": "10006546", "reviewer_id": "91827533", "reviewer_name": "Mr", "comments": "Ana & Goncalo were great on communication..." }, { "_id": "403055315", "date": { "$date": { "$numberLong": "1547960400000" } }, "listing_id": "10006546", "reviewer_id": "15138940", "reviewer_name": "Milo", "comments": "The house was extremely well located..." } ] }