一、数据简介
互联网的迅猛发展深刻地改变着人们的生活方式,其中尤为显著的就是对消费者行为的影响。消费者不再仅仅依赖于个人经验和店家的介绍作出选择,而是通过互联网平台获取大量的第三方评价和信息。一家店的好评与否,往往不是取决于店家的自我宣传,而是来自于消费者的真实反馈。由此,互联网的评价体系成为了一种新的、具有广泛影响力的消费指南。
CnOpenData整理了美国商户的线上点评数据,包含商户信息表、用户评论表、用户信息表、用户签到表、小费信息表,各表之间以商户id、用户id作为串联项,建立起丰富的互联网消费信息网络,为相关研究助力。
二、时间区间
2022年
三、字段展示
商户信息表 | 参考释意 | 用户评论表 | 参考释意 | 用户信息表 | 参考释意 | 用户签到表 | 参考释意 | 小费信息表 | 参考释意 |
---|---|---|---|---|---|---|---|---|---|
business_id | 商家id | review_id | 评论id | user_id | 用户id | business_id | 商家id | user_id | 用户id |
name | 商家名称 | user_id | 用户id | name | 用户昵称 | date | 日期 | business_id | 商家id |
address | 商家地址 | business_id | 商家id | review_count | 评论数量 | text | 小费内容 | ||
city | 商家所在城市 | stars | 星级评分 | yelping_since | 注册时间 | date | 消费时间 | ||
state | 商家所在州 | useful | (认为)该评论有用数 | useful | (认为)有用数 | ||||
postal_code | 邮编 | funny | (认为)该评论有趣数 | funny | (认为)有趣数 | ||||
latitude | 纬度 | cool | (认为)该评论很酷数 | cool | (认为)很酷数 | ||||
longitude | 经度 | text | 评论内容 | elite | - | ||||
stars | 星级评分 | date | 评论日期 | friends | 朋友 | ||||
review_count | 评论个数 | fans | 粉丝 | ||||||
is_open | 商家是否营业 | average_stars | 平均星级 | ||||||
categories | 所属类别 | compliment_hot | 热门点赞 | ||||||
compliment_more | 点赞更多 | ||||||||
compliment_profile | - | ||||||||
compliment_cute | 点赞量_可爱 | ||||||||
compliment_list | 点赞量_列表 | ||||||||
compliment_note | 点赞量_注释 | ||||||||
compliment_plain | 点赞量_简易 | ||||||||
compliment_cool | 点赞量_酷 | ||||||||
compliment_funny | 点赞量_有趣 | ||||||||
compliment_writer | 点赞量_作者 | ||||||||
compliment_photos | 点赞量_照片 |
四、样本数据
商户信息表
business_id | name | address | city | state | postal_code | latitude | longitude | stars | review_count | is_open | categories |
---|---|---|---|---|---|---|---|---|---|---|---|
Pns2l4eNsfO8kk83dixA6A | Abby Rappoport, LAC, CMQ | 1616 Chapala St, Ste 2 | Santa Barbara | CA | 93101 | 34.4266787 | -119.7111968 | 5 | 7 | 0 | Doctors, Traditional Chinese Medicine, Naturopathic/Holistic, Acupuncture, Health & Medical, Nutritionists |
mpf3x-BjTdTEA3yCZrAYPw | The UPS Store | 87 Grasso Plaza Shopping Center | Affton | MO | 63123 | 38.551126 | -90.335695 | 3 | 15 | 1 | Shipping Centers, Local Services, Notaries, Mailbox Centers, Printing Services |
tUFrWirKiKi_TAnsVWINQQ | Target | 5255 E Broadway Blvd | Tucson | AZ | 85711 | 32.223236 | -110.880452 | 3 | 22 | 0 | Department Stores, Shopping, Fashion, Home & Garden, Electronics, Furniture Stores |
MTSW4McQd7CbVtyjqoe9mw | St Honore Pastries | 935 Race St | Philadelphia | PA | 19107 | 39.9555052 | -75.1555641 | 4 | 80 | 1 | Restaurants, Food, Bubble Tea, Coffee & Tea, Bakeries |
mWMc6_wTdE0EUBKIGXDVfA | Perkiomen Valley Brewery | 101 Walnut St | Green Lane | PA | 18054 | 40.3381827 | -75.4716585 | 4 | 13 | 1 | Brewpubs, Breweries, Food |
CF33F8-E6oudUQ46HnavjQ | Sonic Drive-In | 615 S Main St | Ashland City | TN | 37015 | 36.269593 | -87.058943 | 2 | 6 | 1 | Burgers, Fast Food, Sandwiches, Food, Ice Cream & Frozen Yogurt, Restaurants |
n_0UpQx1hsNbnPUSlodU8w | Famous Footwear | 8522 Eager Road, Dierbergs Brentwood Point | Brentwood | MO | 63144 | 38.627695 | -90.340465 | 2 | 13 | 1 | Sporting Goods, Fashion, Shoe Stores, Shopping, Sports Wear, Accessories |
qkRM_2X51Yqxk3btlwAQIg | Temple Beth-El | 400 Pasadena Ave S | St. Petersburg | FL | 33707 | 27.76659 | -82.732983 | 3 | 5 | 1 | Synagogues, Religious Organizations |
k0hlBqXX-Bt0vf1op7Jr1w | Tsevi's Pub And Grill | 8025 Mackenzie Rd | Affton | MO | 63123 | 38.5651648 | -90.3210868 | 3 | 19 | 0 | Pubs, Restaurants, Italian, Bars, American (Traditional), Nightlife, Greek |
用户评论表
review_id | user_id | business_id | stars | useful | funny | cool | text | date |
---|---|---|---|---|---|---|---|---|
Q1sbwvVQXV2734tPgoKj4Q | hG7b0MtEbXx5QzbzE6C_VA | ujmEBvifdJM6h6RLv4wQIg | 1 | 6 | 1 | 0 | Total bill for this horrible service? Over 8𝐺𝑠.𝑇ℎ𝑒𝑠𝑒𝑐𝑟𝑜𝑜𝑘𝑠𝑎𝑐𝑡𝑢𝑎𝑙𝑙𝑦ℎ𝑎𝑑𝑡ℎ𝑒𝑛𝑒𝑟𝑣𝑒𝑡𝑜𝑐ℎ𝑎𝑟𝑔𝑒𝑢𝑠69 for 3 pills. I checked online the pills can be had for 19 cents EACH! Avoid Hospital ERs at all costs. | 2013/5/7 4:34 |
GJXCdrto3ASJOqKeVWPi6Q | yXQM5uF2jS6es16SJzNHfg | NZnhc2sEQy3RmzKTZnqtwQ | 5 | 0 | 0 | 0 | I adore ... | |
2TzJjDVDEuAW6MR5Vuc1ug | n6-Gk65cPZL6Uz8qRm3NYw | WTqjgwHlXbSFevF32_DJVw | 5 | 3 | 0 | 0 | I have to say that... | 2016/11/9 20:09 |
yi0R0Ugj_xUx_Nek0-_Qig | dacAIZ6fTM6mqwW5uxkskg | ikCg8xy5JIg_NGPx-MSIDA | 5 | 0 | 0 | 0 | Went in for a lunch... | 2018/1/30 23:07 |
fdiNeiN_hoCxCMy2wTRW9g | w31MKYsNFMrjhWxxAb5wIw | eU_713ec6fTGNO4BegRaww | 4 | 0 | 0 | 0 | I'll be the first... | 2013/1/20 13:25 |
G7XHMxG0bx9oBJNECG4IFg | jlu4CztcSxrKx56ba1a5AQ | 3fw2X5bZYeW9xCz_zGhOHg | 3 | 5 | 4 | 5 | Tracy dessert had a ... | |
8e9HxxLjjqc9ez5ezzN7iQ | d6xvYpyzcfbF_AZ8vMB7QA | zvO-PJCpNk4fgAVUnExYAA | 1 | 3 | 1 | 1 | This place has... | 2010/10/5 19:12 |
qrffudO73zsslZbe8B9D3Q | sG_h0dIzTKWa3Q6fmb4u-g | b2jN2mm9Wf3RcrZCgfo1cg | 2 | 1 | 0 | 0 | I was really looking... | 2015/1/18 14:04 |
RS_GTIT6836bCaPy637kNQ | nMeCE5-xsdleyxYuNZ_7rA | oxwGyA17NL6c5t1Etg5WgQ | 3 | 1 | 0 | 1 | It's a giant Best Buy with 66 registers. I don't get it. What's the big deal about this place?? | 2012/2/29 21:52 |
kbtscdyz6lvrtGjD1quQTg | FIk4lQQu1eTe2EpzQ4xhBA | 8mIrX_LrOnAqWsB5JrOojQ | 4 | 0 | 0 | 0 | Like walking back in time... | 2011/11/30 2:11 |
用户信息表
user_id | name | review_count | yelping_since | useful | funny | cool | elite | friends | fans | average_stars | compliment_hot | compliment_more | compliment_profile | compliment_cute | compliment_list | compliment_note | compliment_plain | compliment_cool | compliment_funny | compliment_writer | compliment_photos |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
l6BmjZMeQD3rDxWUbiAiow | Rashmi | 95 | 2013/10/8 23:11 | 84 | 17 | 25 | 201,520,162,017 | c78V-~k5g6Q | 5 | 4.03 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 2 | 0 |
4XChL029mKr5hydo79Ljxg | Jenna | 33 | 2013/2/21 22:29 | 48 | 22 | 16 | kEBTg~BUI9g | 4 | 3.63 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | |
bc8C_eETBWL0olvFSJJd0w | David | 16 | 2013/10/4 0:16 | 28 | 8 | 10 | 4N-HU~siRKA | 0 | 3.71 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | |
dD0gZpBctWGdWo9WlGuhlA | Angela | 17 | 2014/5/22 15:57 | 30 | 4 | 14 | RZ6wS~En62A | 5 | 4.85 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0 | |
MM4RJAeH6yuaN8oZDSt0RA | Nancy | 361 | 2013/10/23 7:02 | 1114 | 279 | 665 | 2,015,201,620,172,010 | mbwrZ~0w18g | 39 | 4.08 | 28 | 1 | 0 | 0 | 1 | 16 | 57 | 80 | 80 | 25 | 5 |
KGuqerdeNhxzXZEyBaqqSw | Andre | 6 | 2014/6/7 1:50 | 1 | 0 | 1 | d1z7X~BCwdw | 0 | 4.33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
T0gWkTHWRChVUe_Dn1F8nw | Tanya | 859 | 2005/7/20 22:38 | 1630 | 693 | 1244 | 2,006,200,720,082,000,000,000,000,000 | ctr_B~h9Dqg | 57 | 4.21 | 60 | 16 | 7 | 7 | 3 | 31 | 72 | 95 | 95 | 34 | 2 |
NQffx45eJaeqhFcMadKUQA | Trace | 124 | 2008/12/10 22:59 | 202 | 70 | 185 | N-xeG~XJFFg | 15 | 4.53 | 13 | 3 | 0 | 2 | 0 | 12 | 8 | 14 | 14 | 3 | 5 | |
gvXtMj3XuPr0xHjgmlmtng | Peter | 47 | 2014/1/5 20:45 | 57 | 26 | 34 | 20,172,018 | CfGCj~UnITA | 9 | 3.6 | 1 | 0 | 0 | 0 | 0 | 4 | 11 | 5 | 5 | 4 | 3 |
五、相关文献
-
Luca, Michael, Reviews, Reputation, and Revenue: The Case of Yelp.Com (March 15, 2016). Harvard Business School NOM Unit Working Paper No. 12-016, Available at SSRN: https://ssrn.com/abstract=1928601 or http://dx.doi.org/10.2139/ssrn.1928601
六、数据更新频率
不更新(https://www.cnopendata.com/data/m/third/us-storeonline.html)