search

Dallinger / Griduniverse

Welcome to the Griduniverse.
7 stars 3 forks source link

Participants ids are not sequential and skip numbers #93

Open suchow opened 7 years ago

suchow commented 7 years ago

In a recent 20-player game, the ids in the participant table were not numbered sequentially.

id,creation_time,property1,property2,property3,property4,property5,failed,time_of_death,type,worker_id,assignment_id,unique_id,hit_id,mode,end_time,base_pay,bonus,status
44,2017-07-07 19:57:40.182668,,,,,,f,,participant,44,30ZX6P7VF9OC3VPUN7C74W1MU0QJ29,44:30ZX6P7VF9OC3VPUN7C74W1MU0QJ29,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:25.359899,1,0.28,approved
10,2017-07-07 19:56:32.817041,,,,,,f,,participant,10,358010RM5FMMV6SLSLBJXA6C2WYVXH,10:358010RM5FMMV6SLSLBJXA6C2WYVXH,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:27.41347,1,0.21,approved
92,2017-07-07 19:59:40.509326,,,,,,f,,participant,92,382M9COHEI8DCRC4SQBMDZJM8JEUEI,92:382M9COHEI8DCRC4SQBMDZJM8JEUEI,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:29.396028,1,0,approved
314,2017-07-07 20:11:48.283108,,,,,,f,,participant,314,3PS7W85Z80VHHI6YKA5QGPW9Y8RT9G,314:3PS7W85Z80VHHI6YKA5QGPW9Y8RT9G,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:12:29.218236,1,0,approved
129,2017-07-07 20:01:22.825197,,,,,,f,,participant,129,33FBRBDW6PS0HWLDTW4MRJ1UQGAC8S,129:33FBRBDW6PS0HWLDTW4MRJ1UQGAC8S,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:31.242695,1,0.09,approved
29,2017-07-07 19:57:06.827949,,,,,,f,,participant,29,3TMFV4NEP979VURIAN4N3D8XIWRW8K,29:3TMFV4NEP979VURIAN4N3D8XIWRW8K,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:43.528566,1,0,approved
48,2017-07-07 19:57:44.985902,,,,,,f,,participant,48,39N5ACM9HFGJPQDR3TW6BFVC956P97,48:39N5ACM9HFGJPQDR3TW6BFVC956P97,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:33.443709,1,0.22,approved
36,2017-07-07 19:57:19.559659,,,,,,f,,participant,36,3M0BCWMB8WPSXSPPDZOXUFYYQ2CWBJ,36:3M0BCWMB8WPSXSPPDZOXUFYYQ2CWBJ,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:39.719236,1,0.12,approved
324,2017-07-07 20:13:18.381862,,,,,,f,,participant,324,3WLEIWSYHPAGCPU4Z79MSJL7H8MH22,324:3WLEIWSYHPAGCPU4Z79MSJL7H8MH22,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:13:43.449635,1,0,approved
61,2017-07-07 19:58:12.00623,,,,,,f,,participant,61,3NVC2EB65RSRJ2GCD7RFXTL2DI03YZ,61:3NVC2EB65RSRJ2GCD7RFXTL2DI03YZ,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:00:00.284721,,,returned
1,2017-07-07 19:55:23.221794,,,,,,f,,participant,1,3EF8EXOTT2O5EA7Y43CTZDRH2UCJ1S,1:3EF8EXOTT2O5EA7Y43CTZDRH2UCJ1S,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:06:56.608915,1,0.52,approved
46,2017-07-07 19:57:41.924212,,,,,,f,,participant,46,31LVTDXBL83Z25UF5I3LLJMMAHBRLY,46:31LVTDXBL83Z25UF5I3LLJMMAHBRLY,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:45.348658,1,0.11,approved
323,2017-07-07 20:13:16.562188,,,,,,f,,participant,323,36V4Q8R5ZLTJWMX0SFF0G6R6E0ZMQU,323:36V4Q8R5ZLTJWMX0SFF0G6R6E0ZMQU,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:13:47.134778,1,0,approved
12,2017-07-07 19:56:36.179345,,,,,,f,,participant,12,3MMN5BL1W0XRPLRYU4343YYV48LM3R,12:3MMN5BL1W0XRPLRYU4343YYV48LM3R,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:23.49331,1,0,approved
3,2017-07-07 19:55:51.920747,,,,,,f,,participant,3,3180JW2OT5542S8H5QE5234YEAHJ5A,3:3180JW2OT5542S8H5QE5234YEAHJ5A,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:13.425654,1,0.39,approved
322,2017-07-07 20:13:08.061326,,,,,,f,,participant,322,3YWRV122CTSW3Q2DFNPMLPN0XGH8UY,322:3YWRV122CTSW3Q2DFNPMLPN0XGH8UY,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:14:12.669554,1,0,approved
16,2017-07-07 19:56:47.923856,,,,,,f,,participant,16,3DR23U6WE67YCEXFSLLC83XKP57TEQ,16:3DR23U6WE67YCEXFSLLC83XKP57TEQ,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:06:58.739599,1,0.24,approved
55,2017-07-07 19:57:59.250076,,,,,,f,,participant,55,30BXRYBRP5Q2O5SBDRYTGQ1WLFHWHZ,55:30BXRYBRP5Q2O5SBDRYTGQ1WLFHWHZ,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:05:39.400967,1,0.06,approved
9,2017-07-07 19:56:27.61361,,,,,,f,,participant,9,3WI0P0II62LG4T6NS15X26EH189RDI,9:3WI0P0II62LG4T6NS15X26EH189RDI,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:09.297753,1,0.47,approved
7,2017-07-07 19:56:20.823782,,,,,,f,,participant,7,3ATPCQ38J93R3NFXMM6PK1Z8JSRYAP,7:3ATPCQ38J93R3NFXMM6PK1Z8JSRYAP,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:03.165056,1,0.48,approved
40,2017-07-07 19:57:28.348766,,,,,,f,,participant,40,3U088ZLJVLMRD5MFFJR8AY2FZYG0W2,40:3U088ZLJVLMRD5MFFJR8AY2FZYG0W2,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:17.613068,1,0.21,approved
328,2017-07-07 20:14:26.300954,,,,,,f,,participant,328,3U84XHCDID6C6O9L97YHL5MAXCZZ46,328:3U84XHCDID6C6O9L97YHL5MAXCZZ46,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:26:22.296456,1,0,approved
37,2017-07-07 19:57:22.399369,,,,,,f,,participant,37,3GDTJDAPVV4DQIX46LY0UF66KUDM8J,37:3GDTJDAPVV4DQIX46LY0UF66KUDM8J,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 19:57:26.195455,,,returned
18,2017-07-07 19:56:53.115775,,,,,,f,,participant,18,3WLEIWSYHPAGCPU4Z79MSJL7H8MH22,18:3WLEIWSYHPAGCPU4Z79MSJL7H8MH22,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 19:57:38.586301,,,returned
33,2017-07-07 19:57:15.495126,,,,,,f,,participant,33,35GCEFQ6I6HROSQH9TTYB0U4JC3Z3L,33:35GCEFQ6I6HROSQH9TTYB0U4JC3Z3L,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 19:57:46.54224,,,returned
4,2017-07-07 19:56:06.564826,,,,,,f,,participant,4,3H7Z272LX80EQSE0SQZWGOM79ZNLP0,4:3H7Z272LX80EQSE0SQZWGOM79ZNLP0,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:01.005661,1,0.32,approved
8,2017-07-07 19:56:24.978969,,,,,,f,,participant,8,38BQUHLA9XTGBAKKD2NWR1W6ZZHOMO,8:38BQUHLA9XTGBAKKD2NWR1W6ZZHOMO,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:07.335761,1,0.4,approved
2,2017-07-07 19:55:42.723128,,,,,,f,,participant,2,36AHBNMV1S5P1UI96WXRA27E4VOYDR,2:36AHBNMV1S5P1UI96WXRA27E4VOYDR,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:05.203009,1,0.28,approved
105,2017-07-07 20:00:07.212854,,,,,,f,,participant,105,3X4JMASXCN2ZP2O4KSVCNKPUPXY0BM,105:3X4JMASXCN2ZP2O4KSVCNKPUPXY0BM,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:21.422935,1,0.19,approved
5,2017-07-07 19:56:14.677914,,,,,,f,,participant,5,3ZAK8W07I57EL1XAKJC7SAHIEI50U3,5:3ZAK8W07I57EL1XAKJC7SAHIEI50U3,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:11.455273,1,0.52,approved
62,2017-07-07 19:58:14.913074,,,,,,f,,participant,62,3SPJ033422W24GI1GSJ2D02R9FLJYQ,62:3SPJ033422W24GI1GSJ2D02R9FLJYQ,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:15.432818,1,0.26,approved
42,2017-07-07 19:57:35.68789,,,,,,f,,participant,42,3RUIQRXJBCHOZ7Z20Y6PZ7DN4PMLL2,42:3RUIQRXJBCHOZ7Z20Y6PZ7DN4PMLL2,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:19.58578,1,0,approved
93,2017-07-07 19:59:41.109988,,,,,,f,,participant,93,3NPFYT4IZDX3D92Q3QCXX932FHAXGU,93:3NPFYT4IZDX3D92Q3QCXX932FHAXGU,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:35.528019,1,0.02,approved
321,2017-07-07 20:12:47.007952,,,,,,f,,participant,321,37Z929RLGA1ZMX2XTG5HXK1ZQWGTSR,321:37Z929RLGA1ZMX2XTG5HXK1ZQWGTSR,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:13:45.310939,1,0,approved
332,2017-07-07 20:15:20.557017,,,,,,f,,participant,332,3DY4FPOOA2H2YA69JM5R8SKO1FDRVH,332:3DY4FPOOA2H2YA69JM5R8SKO1FDRVH,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:16:20.661785,,,returned
333,2017-07-07 20:15:34.150522,,,,,,f,,participant,333,34PGFRQONP4YFBN11R1ES3HBY7LJWR,333:34PGFRQONP4YFBN11R1ES3HBY7LJWR,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:16:40.269692,,,returned
177,2017-07-07 20:04:47.016976,,,,,,f,,participant,177,37TRT2X24RK6R8PQ605I5P4QO64BJ4,177:37TRT2X24RK6R8PQ605I5P4QO64BJ4,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:41.709285,1,0,approved
26,2017-07-07 19:57:01.149477,,,,,,f,,participant,26,36ZN444YTSRUFRUTSNP4Z8PPIQXOI8,26:36ZN444YTSRUFRUTSNP4Z8PPIQXOI8,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:10:28.497351,1,0,approved
330,2017-07-07 20:14:55.969062,,,,,,f,,participant,330,3YOH7BII0A0GB6TET2WU7GYA6NJVKS,330:3YOH7BII0A0GB6TET2WU7GYA6NJVKS,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:17:27.259777,1,0,approved
211,2017-07-07 20:06:48.540448,,,,,,f,,participant,211,31EUONYN2WWZ1XETRUONEXFJQSTOV5,211:31EUONYN2WWZ1XETRUONEXFJQSTOV5,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:59.856461,1,0,approved
238,2017-07-07 20:07:44.275388,,,,,,f,,participant,238,3F0BG9B9MQG9KLHZFJU5AAXIIKMY7Z,238:3F0BG9B9MQG9KLHZFJU5AAXIIKMY7Z,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:10:30.393466,1,0,approved
338,2017-07-07 20:19:47.333393,,,,,,f,,participant,338,3HVVDCPGTFLWIJE6SMX6F6P07HCYTA,338:3HVVDCPGTFLWIJE6SMX6F6P07HCYTA,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:20:17.27576,1,0,approved
139,2017-07-07 20:02:03.243817,,,,,,f,,participant,139,340UGXU9DZUUE2YQNG0WD3788EHVUP,139:340UGXU9DZUUE2YQNG0WD3788EHVUP,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:02:41.511744,,,returned
232,2017-07-07 20:07:37.687427,,,,,,f,,participant,232,3R08VXYT7DO5VGMZ0ICHPDC27CLW7X,232:3R08VXYT7DO5VGMZ0ICHPDC27CLW7X,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:08:02.782477,,,returned
340,2017-07-07 20:22:41.900634,,,,,,f,,participant,340,340UGXU9DZUUE2YQNG0WD3788EIVUQ,340:340UGXU9DZUUE2YQNG0WD3788EIVUQ,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:24:17.153433,,,returned
312,2017-07-07 20:11:30.818486,,,,,,f,,participant,312,3WT783CTPCAJJUJKW8OWILRVYMVCBR,312:3WT783CTPCAJJUJKW8OWILRVYMVCBR,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:12:31.145859,1,0,approved
316,2017-07-07 20:12:04.700871,,,,,,f,,participant,316,3ZV9H2YQQE0NUXLCY69RCW0M2AZW3S,316:3ZV9H2YQQE0NUXLCY69RCW0M2AZW3S,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:13:04.981343,1,0,approved
174,2017-07-07 20:04:21.271829,,,,,,f,,participant,174,33CID57105M7J39DUS2P3LJ643W3L7,174:33CID57105M7J39DUS2P3LJ643W3L7,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:14:15.646056,,,returned
304,2017-07-07 20:10:28.007105,,,,,,f,,participant,304,3YDTZAI2WY9FBSOD1WPPTB2YKXN14K,304:3YDTZAI2WY9FBSOD1WPPTB2YKXN14K,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:11:43.095967,1,0,approved
331,2017-07-07 20:15:09.803071,,,,,,f,,participant,331,3OJSZ2ATDTPBIX7F4HP8ZDZPNFI75S,331:3OJSZ2ATDTPBIX7F4HP8ZDZPNFI75S,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:17:29.090146,1,0,approved
327,2017-07-07 20:14:18.473408,,,,,,f,,participant,327,340UGXU9DZUUE2YQNG0WD3788EHVUP,327:340UGXU9DZUUE2YQNG0WD3788EHVUP,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:17:30.89377,,,returned
336,2017-07-07 20:18:08.517595,,,,,,f,,participant,336,3MMN5BL1W0XRPLRYU4343YYV48M3M9,336:3MMN5BL1W0XRPLRYU4343YYV48M3M9,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:19:36.411766,1,0,approved
334,2017-07-07 20:15:49.391978,,,,,,f,,participant,334,3LRLIPTPER2WJIQGI75YBTKXLDJAK7,334:3LRLIPTPER2WJIQGI75YBTKXLDJAK7,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:19:50.957785,,,returned
339,2017-07-07 20:20:04.09843,,,,,,f,,participant,339,3TS1AR6UQR73KU04AT2HLPQ2C9WF7J,339:3TS1AR6UQR73KU04AT2HLPQ2C9WF7J,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:21:10.377163,1,0,approved
170,2017-07-07 20:04:13.567073,,,,,,f,,participant,170,3JZQSN0I3R3MDNB53W6BR23VBCEGFM,170:3JZQSN0I3R3MDNB53W6BR23VBCEGFM,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:37.583375,1,0.02,approved
318,2017-07-07 20:12:20.358354,,,,,,f,,participant,318,3HMIGG0U4MZDKZMIPOMBOATDT4RY8L,318:3HMIGG0U4MZDKZMIPOMBOATDT4RY8L,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:13:06.872413,1,0,approved
299,2017-07-07 20:10:05.53203,,,,,,f,,participant,299,3TYCR1GOTDC84WG6FZXY7MOLJYULZL,299:3TYCR1GOTDC84WG6FZXY7MOLJYULZL,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:10:47.725884,,,returned
326,2017-07-07 20:13:58.479939,,,,,,f,,participant,326,3907X2AHF1Y8P6SSIKHR1SNY3ZWP2F,326:3907X2AHF1Y8P6SSIKHR1SNY3ZWP2F,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:15:09.24937,1,0,approved
341,2017-07-07 20:27:54.642401,,,,,,f,,participant,341,3QY7M81QH8FE0GSIB4TE12I7K5D7KD,341:3QY7M81QH8FE0GSIB4TE12I7K5D7KD,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:29:24.316362,1,0,approved
85,2017-07-07 19:59:21.728207,,,,,,f,,participant,85,3DH6GAKTYZIS4VN5YEMO1UQHSDYZYR,85:3DH6GAKTYZIS4VN5YEMO1UQHSDYZYR,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:01:57.341602,1,0,approved
183,2017-07-07 20:05:41.04347,,,,,,f,,participant,183,3GDTJDAPVV4DQIX46LY0UF66KUEM8K,183:3GDTJDAPVV4DQIX46LY0UF66KUEM8K,3KA7IJSNW6YZQZUUBB50E1UID8XBP1,live,2017-07-07 20:07:49.506597,,,returned

Full dataset attached.

7b4c3811-e4d2-4faa-bc8a-47558ece4e7d-data.zip

suchow commented 7 years ago

Here's a smaller game where it didn't happen:

1290e53b-4d85-4944-aa78-7f50b02e6d16-data.zip