CnOpenData用户信息表

最新推荐文章于 2025-11-28 00:30:06 发布

原创最新推荐文章于 2025-11-28 00:30:06 发布 · 387 阅读

5 ·

CC 4.0 BY-SA版权

文章标签：

#big data

时间区间

2022年

字段展示

用户信息表	参考释意
user_id	用户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	点赞量_照片

样本数据

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-rj8NQcQjOI8KP3UEA, alRMgPcngYSCJ5naFRBz5g, ajcnq75Z5xxkvUSmmJ1bCg, BSMAmp2-...	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		kEBTgDvFX754S68FllfCaA, aB2DynOxNOJK9st2ZeGTPg, h_n5JP28sI3u7ye8og7JvQ, TMSrplMA...	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_T32hLENLntsNKNBg, pSY2vwWLgWfGVAAiKQzMng, lwhksSpgIyeYZor_HlN93w, v281gE-n...	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		RZ6wS38wnlXyj-OOdTzBxA, l5jxZh1KsgI8rMunm-GN6A, vfXxkFKENdjKm4skT40qGQ, vd0p-zAX...	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-RS76V1HoJ0bF_Geg, g64lOV39xSLRZO0aQQ6DeQ, QYmi0elzFWBjtMyLRdWiuw, fhYiakI7...	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		d1z7Xc9RG5TVBkdUPhSbAw, IgsbGFEN8NWshPNOBiNGmg, _x1H6SC86MVb6O_vrZuKaw, MXFPXCT-...	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_BlCf3Ogny-vLs8E9tQ, c6HT44PKCaXqzN_BdgKPCw, 2S8XdZxXjCP9-01ZzJCocQ, JJT1UByO...	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-xeG3U6rUkjVtQ0o-5YZA, wnO99pBbGqwqOoTQM25iCw, pxzs-Dy2hXTis-PuNCV37Q, 6LF5SeEn...	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	CfGCj80EdA-xS-mTWlAn4Q, JgD2Rk9K07MkZgG7Nb9YzA, XNbrAATnVNAg1eTjMjn-pA, NZZcXBz2...	9	3.6	1	0	0	0	0	4	11	5	5	4	3
_DaFdmq0gtXf1spn1qC_1Q	Edie	77	2009/10/26 1:00	71	16	22		tYyOnNs7tBfqAT9ICKDfhA, 8lOmKlym2HovbxtCpim0tw, BlZcvUBTrmhULgDFFRltmw, 1JOxGfBG...	3	3.48	0	1	0	0	0	2	2	1	1	0	0
FTWKZZeLb_0ZJRXQg8WADw	Gabriella	11	2012/11/13 0:23	12	4	3		Dg8_xYNvjVC6KGNRcWhYjA, ejsfCWW7k0kP63qmYl-uzw, tXrpvxigQRtBLOscErtV6Q, D8rJ-60T...	2	3.5	0	0	0	0	0	0	1	0	0	1	0
US0VOSMFs9U0Nkl5Vx1EzA	Emily	22	2010/1/23 4:55	31	17	12		_5p_nO7OczVP7czj_7T-RA, vux89VHowK-AlTpw_0J-wQ, _tWsCv3Hh0MZcy1qSv-Xog, rZQCd47n...	0	3.95	0	1	0	0	0	2	1	4	4	1	1
fktnDzpjYBUG5a-w_xq01A	Victoria	143	2009/4/9 1:05	483	285	342		mFwRTTDW0Yr-rFkTF2cFsw, swDSHRvZ4FBC-8db8o1BDg, jHYoWVPVQHNFZSMu7ECEvQ, IDl8QswI...	42	3.9	45	7	4	11	0	25	29	49	49	13	29
iPJAN6rJHv92WE2h9b3lAA	Richard	9	2013/9/30 23:58	11	6	5		xVv_pVxAcOfY_xBjBhF4Vw, wxwcXI6UicVMUvfS4tJLYQ, D4J0X3XTTnGNozHFJFPHlg, _kALQcAV...	1	4.5	3	0	0	0	0	0	1	0	0	0	1
AWCY8laHjH0-3HMT0LGpUA	Jin	732	2010/7/9 15:53	1104	417	586	201,120,122,013,201,000,000,000	Xqo1ru1F7srvbUJaCNHkvQ, v5LvxWrscDM7XKpD6f0WxQ, YttDgOC9AlM4HcAlDsbB2A, mB40W972...	71	3.79	89	8	11	18	8	83	196	185	185	56	42
CXi7I5J-ItLGJNyKPkI5gA	Cyndi	57	2011/6/27 5:24	72	22	34		9ljCrn-qgfAMRS5wLmMKrQ, hXl-ISD3YDCPMVBkny8m2w, kYAHL38KXAnj5vrkYHhdYg, GgckLj5B...	4	4.1	2	1	0	0	0	2	1	1	1	2	1
hQ98T_hy1CoSWw55zA49VQ	Jamey	44	2015/11/2 23:41	16	3	2		a4kpoV3nrxRPUHR6z1PBQw, mNQGnFf22YStvg5lW-E6-Q, RGdAqutD3LxWPey8-0m4QA, SHH804ab...	0	3.1	0	0	0	0	0	0	0	0	0	0	0
zzpgpo54-_P-4rzzBtOuLQ	Aurélie	1563	2013/10/23 9:21	4172	1661	3246	20,132,014,201,620,100,000	8pzdMS8Mbppx9Xuf4ekCTA, Fcw-Rza7kEtavc_88t-BSg, Kxo2GaMqLkGf9q9F5FXFZQ, HkpVEH3-...	99	3.89	628	9	16	29	8	354	776	559	559	75	119
pU6GoRTcl1rIOi6zMynjog	Javier	470	2011/12/16 16:13	1655	1007	974	2,015,201,620,172,010	tRC9YLo4LHquMVXZ9VO4Ag, -YpfTgz88rsPwsOvlfKn7w, j3PO-TKGow27ZM4DisCfsg, Bb-MoFUN...	71	3.45	16	8	1	0	0	42	32	64	64	35	10
Ps_zkoSnuv2Gy-QIt0jEJg	Lea	127	2010/1/29 2:39	193	52	53		c6VYt2qajpt-etcKrH93Jg, GIMg62Ga_YBstQUX_B1h2g, -khmOANLfdLNrBDaQV5ISw, 6QVmu1Fb...	5	4.05	2	1	0	1	0	0	6	1	1	1	3
_ICqwy7SW8J6OJBab1HkwA	allison	391	2007/10/6 2:42	708	316	399	20,082,009	o8H8CioXzL4ZR_zxZYcv3Q, yJB1hHDIq18Qvmo3yo9_KA, vMlOudKPchCsElhRMawhwg, hhIYp_VD...	13	4.31	10	6	3	5	4	21	39	23	23	8	1
J9HamWsxKorlPGUAXy-M9Q	Ronald	336	2010/5/17 22:59	431	189	228	201,220,132,014,201,000,000,000	FL99HPJNDVQ2Yeha_4dI_w, HfElShp8sy4QXY60ox9_eg, OtbooagsCGPM00ZbDOyPgw, SWssGoA7...	19	3.81	11	2	3	0	0	12	15	19	19	8	4
t8Whyn2ZWS34TxHsr2mpbg	Erica	48	2007/10/5 16:05	108	39	33		Tk2DscrRA0sXPXKb0ZzBCg, DpEEWf_8mYsYPilGu4nrgA, pOsSRzm0ZOXE9FcJ5pWxYg, 6DC0wkly...	7	3.57	14	4	1	2	0	1	10	13	13	12	2
nRagjGVuSALgQ4KfGLn8Ig	Christene	9	2013/5/14 20:57	5	0	3		V1KtmSHupcPCjDsDD_mU2A, fUAGZlTJs9mB4mY0f7qvrw, UJrV2A4zaut_rVrs3Kk14A, FOcejl9n...	0	4.44	0	0	0	0	0	0	0	0	0	0	0
djQLJTLA4Tx7TpzYCKIqJQ	Kris	167	2011/8/10 22:57	423	212	213	20,162,017	2hvNa7B9N-9ByZBpVMioZQ, 4aCF363Weu2RNAtl3mJ2eg, I18qYv1reJOyebO5EaFf-A, xwmIPSho...	9	4.16	11	1	1	0	0	13	25	7	7	12	1
xxhjX14h8cQyKSuTQFy1Lg	Sharon	443	2011/3/12 2:30	907	532	573		UGU7tw4NkiqGlOt77_o5mQ, yFzYyM5T8LX5vKbA3wiimQ, RYa7nOQi8z4sNr0STMjYQQ, xwBv9j6S...	13	3.59	16	2	1	3	0	24	33	57	57	18	8
a643pisN3QSjofk1Jmlo_Q	Amber	4	2014/8/23 3:49	10	1	3		FDuoN8cpcI8y2DBIUoMn4A, If62OVbZRyqgqpAkYw6y5w, 163jsyZgK4Y5Puu9aVumdw, bpU86HIm...	1	2	0	0	0	0	0	0	0	0	0	0	0
z5y4ejvC8uaUg5fGEJHbRA	A	19	2013/5/28 17:49	33	4	3		5fvybUMH9N9Gx1zKw8UbBQ, I0HBD2I7uT_LU_gA9Gb9HA, IHMaibH35Ca6nRMh1-JSCw, c1nkrtpO...	1	2.64	0	0	0	0	0	0	1	0	0	0	0
DvIlmSleoauEoR3fY0Kf5w	Desiree	108	2016/1/14 9:00	88	9	32	2018	kVrdgzczxM7TvPy6nFAZ_Q, Wn0aDFnS4Fln2bcbWUluVg, ZoWJFRb_03t-OFParZdrbA, TdSnC-Mz...	2	4.25	1	1	1	0	0	0	1	0	0	0	0
t-nB38eHbeFuabXBdJMwvg	Katharine	412	2008/6/13 14:48	1816	463	1341	20,112,012,201,320,100,000,000,000,000,000	2Y1pwMu2pZJDGQ7moD-2gQ, Qlys2g0R3PfNAuMOhagwLA, gP20yP4taj8EKLdV-P-fzw, JPkQte1g...	77	4.02	106	3	4	1	1	60	64	140	140	120	65
3gniF5P3L_WcoR8zx7wXxA	Jamison	4	2017/3/13 19:50	2	0	0		yU3dWsL_PrIeYDdJ3OodXg, iIzwr1J92eiFIP816pWX1g, 9WtOe19yo9y5Qnc2e-D3SQ, A23EG_vU...	0	4.2	0	0	0	0	0	0	0	0	0	0	0
27wlLX7e52vVEvNA4Ksccw	Sara	207	2012/12/10 4:55	289	72	133	201,320,142,015,201,000,000,000	_mxu2H5yk6GJsSkyrhjfSA, vCI_708ovsifM4I5hWMJqg, CazMh1-W0D4_stJ4kL_u8A, qdY_Tk-S...	33	3.82	13	6	2	2	0	27	29	16	16	11	11
QiDtS54JwTGeH81c-a84WQ	Maria	100	2010/1/26 15:36	363	90	203	201,120,122,013	dct1ykKd4WaQrI2rs0YaaQ, s-591-mtIyP7F1Lffw98jw, Nh-ztLj1IxS8ROHQqDFSiQ, emG2DzHA...	21	4.39	33	6	2	6	0	36	61	75	75	19	18
rnU1EFMSnVJGrQxrnjaODg	Fred	431	2010/12/28 1:37	3157	1338	2158	20,142,015,201,620,100,000	HHmX2L4Gg6L0WJNcxs4Ptw, 8DEyKVyplnOcSKx39vatbg, HbtDu8f3fxT6A3xubLYfGQ, B0ONf3Dj...	58	3.95	146	22	3	1	0	163	118	201	201	58	112
AsYMm_O4H-mwmWbmeACDHw	Christopher	318	2015/1/17 17:04	400	175	223	201,620,172,018	4I_AqfW1E_OLDskrgxxU0Q, 0hm1__RgRWYvHXxWfUJMyA, S7DokrWaR4T1TOnXC2J0lA, Ddkzj3sF...	24	3.64	9	4	1	0	0	2	4	4	4	2	5
PktqNN4YpEzkxsuLwiGkSw	Christy	1	2015/12/29 20:26	0	0	0		JwAv-ZqMamWNxfmPz3Zk2g, 7sr9QjhdaApsd4KbhvQAAw, WzKm49VGgloJ04VJbG44ww, xEtU4z-X...	0	5	0	0	0	0	0	0	0	0	0	0	0
tj_j9-8YwYZ7ohOsQD5H_w	Jenna	17	2012/7/28 1:19	64	6	50		Ybc8ytcSZrNZ1x3Widy2cg, GieL1eE0PVRvAG-wpF6OYA, Oehc9pHqbIUF4pY1kZM5pA, 4uJXindo...	3	4.95	2	0	0	0	0	1	4	0	0	0	0
NmC_ZemjAQ6TvzgeaAuTmA	Lindsay	87	2008/4/12 14:29	240	78	101	20,102,011,201,220,100,000	u6wFKvEPzWIwc1Rbr639Qw, sYO1-RTkfE0-tba1HbvTRQ, _P3H8y_XDJvgVbvTRvgx5g, fTj_u689...	4	3.24	20	6	2	0	0	17	9	22	22	12	1
NcUMNz6tAahD6mDmuKwYIA	Karen	85	2008/7/13 17:51	63	25	45	20,172,018	b6JabuZ8sNh91ZGqBJ-JHw, sKL3W6Yy1OJbSrNw7griiQ, c122juxNV2hdUYqbwB2Duw, AJqODXUB...	4	4.4	1	0	0	0	0	1	3	1	1	3	0
gvKlBHFA6VXb9AksWcPMjw	Kenny	130	2009/9/25 17:13	137	62	69		z-wrVixfyfxp45Jp4Cn9og, 0nAwegrk0MGZan7H0mfyFw, 75COHfu_drTAx1G9rtZnAA, iVxxImR1...	20	3.95	1	0	0	0	0	5	8	3	3	2	1
WnwpWcNcJhHi39gdIUfJuQ	Larry	81	2010/7/5 17:03	336	131	160		mJjxrTHfAxQMzEJdxqX5Rw, yrGIgk5eaWy-eewLNv4KHQ, 4iI8_Ow7hec9JOENzNgLhQ, QtIYPhvY...	8	3.21	3	1	0	0	0	10	15	15	15	4	4
2Bcq1i1ndSyvYDS8Zn2Oew	Adrianna	231	2011/3/19 1:40	475	190	187	201,420,152,016	0WNqDD7uc89GCVU8qiKqfw, vyYzjxcSqJ0VQpG_Qydwzg, yBfGAPKXjtqr9cU5gnU6vA, PeyABy6c...	31	3.6	38	4	6	1	0	13	15	6	6	4	5