secret_santa_participants

4 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: password_issued_at (date), message_read_at (date)

id ▼ slug name secret_message_encrypted password_issued_at public_key private_key message_read_at
1 Demo group with 4 participants demo Participant one <Binary: 256 bytes> 2022-12-11 01:44:32 -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA7W/fOgUVu4k5QN+sgJ+e mbT3y4xFYFVaMSNFtjiNtUJzgunVQWXqq/sa5SpT5z1M4BY2qFUp/E9pS1K35OSW 8Kz0paz/qWUjEBXjxaHCGy/UFkk2qQMDAGcWzJFsE+toe4pnnQh7dZvlHlg8jZKn GgRxnkhTm7mIae1dx+mTrx7SZE6JCd263pPPJVdVET1FEFfTulaI72RTxeJW4Lwp 1hyC/7VIp0/58k/4fAMZMEwee7V2lYqozAUJ8zaCmuClySkrLtOHkH+bsKeuTdNK goWnc4qhmAiGbbqKIltKkRpbd0WChVNjWtcka5V2Sc2mzagGeHK9ACKukUr8hRi4 SwIDAQAB -----END PUBLIC KEY----- -----BEGIN ENCRYPTED PRIVATE KEY----- MIIFLTBXBgkqhkiG9w0BBQ0wSjApBgkqhkiG9w0BBQwwHAQIG45MhOjFaiACAggA MAwGCCqGSIb3DQIJBQAwHQYJYIZIAWUDBAEqBBDmg5/WfWqCaG4ZvpibSrGTBIIE 0PQ758lHUNqcfnHLYm8Ee0v6xnDnl466zacyIeAeeW/qukKczzEE++EFccudJLGk k6Whqx2uvAGP1OaF9LXTrLDLrK+D0Ldqavno0OGhcwms8vuO0+a31B7u5yaRgX03 oehXE9kDRrIx4vpvdCKp01sq406EldoVt6OtgeyuSWV7DSkMmPYLq7307peqkFkm oCdjTOY/D/ywrPg37PeIMxChuPuuAq/Udq8drGUT7MpMCC3agWqIWSTosymcHyTL DvwzrPv7LyADADPrKhB/FLGKKtM/KQu1EdvriOAbHwfPfS4dA6XrtVXGVzQnHUnO PXllc4VB1ceg9a1bPdCxEG81wI5JzkeKx44Fy5rWS7CXCnhj3tmBwEIlf2zqsVBf kzYYHcCkv+oxjWsBKZNIvkmy/Ky05d1JC9fTArlBAe1x4pRWXHVtM91GAmdF+Vyk zi1SxJUEol2JAKLSITDPIg/W4QjJ8kQP8w75suk8JjnTPsyVPtzBLT+NsCbavTiB TqD8IaaieOy3bQmSIl6Ey9rFnS0XyitgvvF3StD4BUgIk9nIY79ZIWSztRjwfHAV mMxUxdpx8hZLWOlUDVwfj/VG+7cXyHT2HJ7FjkkCUZsYNq/net3XM7YG/E4moQk8 FfokqIEEZx0E7uTeyxzPmF6SCjMwZkPwVU4qCO1tpQqSsUislev7mgcE2M4wv9rD Yvxrsgl/jFGnIYlSIuEda9GrJN7Fd+k+v1GoqSUxTWumCSw/1CN4HcXRVAlxecl/ 71/p6IhKRW52ivTj/EDLIPsIuwZf0QNULi90uJvm1BRK/0a0AyxatoyNj19xlE6n davNWFG0yyj8GBQk2ZhhBrG0Zi9/aob4AE/TJbNyQUd7nGJqeMJdPHyAK7/PVUTS /+BJALddCIJ5cYc0F5nc9aPXtk9mpwydjw6gK6nD3vWqAKgRahRx2ruAeyrIkZsq eOt4sRmPVAqPiNI3wEA6t/kwj3kpFmoTy5ARIBRMtaO9Wrx++L14Rer8eYm/GpHI jb9MmEFGGHlWHW8GabXZfNUwIzVEgAen7aXZNK+/RPrl7WbOGQbB7dcT4e6HOqzv ddjH4GQNfPeYgaI8HoVWckaUZPMtFBTqNFdSUeY5CykpIMSmd5GAcogHP5rFNIOU R97GN5GN2Roa5H06wxmqCVjeFOBJjSzNDmLwQ2k7eX1HLq4WZznYgFBCk+CVUZLE V8kFs5eaw6HXnZi2ujNs+I/jJ1YoyJwhj8dOiG+yFYZPi/Egu2uZocBtdkUy2Ywd aZv294Az3gNeAb62LvkQop9q+dcrP0UwjHLAAZJLweYUnCh2Z5xGsAj9M9vsGs4X AQP3Nolxb0olEe4yKN4oE8+mcdHxmGpiNA9BwEEW8OqZUxsZ16jitzhyvk7NQ6vX QqZX9WzfYa4bWbrC22/ovYoQvC+sIfbnGH9AK1OLyfwZHyFA0ECnUY9Pcz8Rksp0 IEMXswh6YoA/FHjZUIumdfB4HswSOgHWWztpw0vg1YRJAsz3AhrFMqA8cfLJCD6D urOHCAh9A3FY9f37GeOIeK7K6sXbGgwn2Z+BGe6bnz1wy+kPmKUDyOKkmIvPxfX7 fEfiIDkLuS+AUc442GFSrT7nHkuHXamaOGO8Am/fH/fm -----END ENCRYPTED PRIVATE KEY-----  
2 Demo group with 4 participants demo Participant two <Binary: 256 bytes> 2022-12-11 01:44:37 -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvKpsomv8keOawQVM1wmy BK+6/b4OLYKdJ8N+V+6uGnJ3NGuz+Vmbm2jRM/PaRkjY5YlKuPqsQJC956OAlGTB QwIKALof/Zsz+cR8ne0rF6NeHdSQgXxT9XJ5y18RDCX2lNg5E4jwhUb7GhrOcTV0 YANZqajT2aC2qiMEFOgWbXULInpiS7OkDqD/AB5eXWTLMIjPZxHtxV9yea9s//ah ujIlM5xXyxsaceO6td8gNIJSD+fxAHFaBVinHS8YGuytsMr4GEwIxFGNNS8P8J9B WQzZz8fT7jKJVBKN56M1txQJ5z9p664jOo3EQunrwl0C9Npv5UMl9yP7CEz1RYaU gwIDAQAB -----END PUBLIC KEY----- -----BEGIN ENCRYPTED PRIVATE KEY----- MIIFLTBXBgkqhkiG9w0BBQ0wSjApBgkqhkiG9w0BBQwwHAQI/8tVCN2koXcCAggA MAwGCCqGSIb3DQIJBQAwHQYJYIZIAWUDBAEqBBBEsBb1guA00AWRD5ZQtiOiBIIE 0E/IpqfGweBj4uFHKOKT+qUctuQle8yOY6kLVKhCJxwZ7iwLOI3Pe5JCmTIj42wl qksAsgHcCZ3LqZaUyK7a/zwl5LpPgzg5iaKXtHFcdSjuLrAMYvIbEOPVox1XP35G okYN0EwDjpv9P9/LLgl8LmtFhVg5/tkKaZ82kQ8GDRcLG6L6lziUxdeEUjl/LEVa AjURWyr1cbetWMDKOZ6Bv1O4/DCvOTYz1yL2esbBWvgRQI2sWJ0G1yGvm7BTQQt1 OhMFjwjlkWyEZb3Fy9wE4P/vau380Q2Bl06+O/NCnvuGXKIP+P1FxV2ngeM4k4w0 q9fURuNFwyKZLuozNkfVXTkL/2us90oF6iXEd9AzB6rnT3B/1e5CjD7WlrUWsy2X nC4mkQkP7S9rxHlF6D41nitYuaORCl0vbhpNuXBZmKjeK9VeqlTly8dd94Afkaih 3EJ0I16oRmkxCFAKWWu/vaeMb6ngWJzsF4oYjr3p4CPKa3Wx3bqj+N9ARdX2tqPQ v44l1ixI5hPVsmopTlV0wuyhfFRXefUPPd/qDplBZw9EALSIFX0zovlA9/1jE7Oy 2AaiT1d9M4H3Rwkc8RJCy7j7pGQlb7/+Fo5otTFgLVB7C52yXM4LnVozRah3wJ2u DMgj1rQGaEJ37ZKAVL44p+mAiebZuTGpNMSbX3MnOwulArafpa+Tnl+kgRGmCTfU 3KpCnG3MUewpdrDHX39gSZlFi0bTkuaWckMbJKxttUVq9C7a8RU69wcSGt4c4oV3 ROZQhIZjzRngP84QNqTiG1nrVVWYl1Ku4tznI5B05DhkHjuBhtIjt/R5U73/UmFs kQsn1saLVjVcqunlKCY1hzyvMNpEeH8bIYVunkfLEUYWnVJi0czYF2UlvEqvVauf 9q621YucwjBugpNZIf3/2NgLg9KFZBiMj69VAYjeg5bm3XKWXjHF9C6rp6y5NOl1 1JTY7KFqCpxYsibYIhARixpO3TFYTnDPo/JU4pRUXdJ3zJHGUCGHb0m2HL96carD QVq2scpsG5Qbzp4Yc6WcfMFhx49UqJ39dd+NQ7LHKVjo2S4FW1cCHc7LDqNPqN7P 4DnefmCzyEDAuW68XBnxvaL7qBtw0KzVqav85vMU1UQawTJeM6VrxVOxP7du5fYH wHoNfJkLHJ25bZuIYxYWDC5VnkL4tmn/tXfltRmKW04wly33pF/eoybzhowlbq4c 3aHGPZneNIe+Bcxm1vEuaEBPu/8xVXpsR0CtH4S2zdcklZHuLtXclu7Aic3yXy/X blxFKsPa5hh9VcXt2CZiDzL/XvFsgs8GyLjBkxj6V4IducUD8nIwpRBZT58yYHgz Nw4ecykA9eMt5lAcyGzI6Rbkwo81v4NoqyWM8mTvUFx6DbowOHvzUH5O+WeJ0A4C 4SBLhieHYtRNvQOmA6V5agvrnVjuve/r8/5Sy2tBltmDh0iPWGb/V9diZSrqiqO1 UtgUg8n9hrc0aoNbbYGQYoQAmONsnFciykMbi/U1aSarDqsZ9n4cL8BKtbk3pqzK G39zr2mftdnY2qsRLuTj+L4zrwmyxI/dyH5iwBz9pEvfYJTlNKGHhi9yVXM6q6RX NMpWOVLQNjKYqmZpa9F26S3Cei3umXj8KJpn5DJC7o3/ -----END ENCRYPTED PRIVATE KEY-----  
3 Demo group with 4 participants demo Participant three <Binary: 256 bytes> 2022-12-11 01:44:43 -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtGuEK70qGWdQ5CRFlQ0g ZkiR94AH7vGK/7JJPsnQPf5ehuW2KaqaeW1PvzA2I+hKu7bIn1J3hjGnWvqpADGv Ohr5QJQ8H2ttQnWKBSWgh5h0FLq/hgFUrGeUr+3H/SY0R6kOHKlUO6retSDpaN4V 6Q/d4aNmM58aTnXCIYeujF066Upht5EITIZk1L+JXExWWFJDYbkXdff9QfeGoeLL j2qsOjqmrYzHdWjbDeXJwy40m0KPIs65r9ncCDB4xA6cylAI8D85sc66Zkj5Gp9x 48KulU5+i5s4CwgNMkrnK7+hvf4CQTgZwWWJwh8ty3B3DcEX+WfTRGe414ez2e5l owIDAQAB -----END PUBLIC KEY----- -----BEGIN ENCRYPTED PRIVATE KEY----- MIIFLTBXBgkqhkiG9w0BBQ0wSjApBgkqhkiG9w0BBQwwHAQIS18Xj2zPSXICAggA MAwGCCqGSIb3DQIJBQAwHQYJYIZIAWUDBAEqBBBJ9djWWRVQvCCZzzSb+BFGBIIE 0Ll4rWuAejHBTdDXk/2EzdO/0ol4WiEyaanlpQCuc1K3LVi/JSCcJ3kKGAEaomIV P4NFmgefldsg91DdAC+0fsRu2WwamnD8Ftl8GPzrvq9Rl2HQ7wnuefIh3eSX+x8H HFWnY6tLzSm0rcdjVPvhuJc27Y52Nu7AsjqwUBsIrauomQ3Rtm/hHaKD0mYwjUm8 uwyu3OiyxWwaOWJZmfMgK+FsAm1ySaRKcefzzYr5LRgRin8ASkCFn7AcznBj3U1h 3Wni96ezAbZTqU+F3qguI0SLc817ZERONGEKQbNpCeBA593p4GPrLyS+Apl9I/0c sbf8LkFXFcoL3/u2mR+BiuYhXyC1IqmybnHSD35ps2AehmV24HqukZ2e7xKGoDpg 7DyshdZ32GbXK08JGk4E/GyXdY4+ucKg5sC/Fvy44nTnZIYXi0Ro1izc5A5aoleI wP9u4Nvokpdq0wbOPAGDTeYRaJbXH+2xuKUsxTlxsqFIjpiU6eS8ujPqjIUJvuWx qtsJ0L989BheLS06oDO8A4SnGuoSWCZAWN6q4QRptCG09Xd1jz22t01FdcihOfAF D2PBylSrZgNkF+pezADnr1PBq7f0Tks4F8c5d9uyNZcoCO3tKuipHXy2vu6WSyDd k11UYeQWfhMYuDP7rpgk7ykiV7C5a+SrEVfVqcVLjTVMaAn1A8n8XhZtLSe9KtSy opvsSDeQvAcnzvZTKNZrsyuJN5wlf/oA2QkyzwAaKkJoWDPEvI1jpQwjIfdvEGZB sjGj7FmkBsjzqoU6/dl5nNFehN60BPg5uCb5EclfQiOC42BKIMH5ijJw7eza9KJ1 xLAsB6QcMVUPg1hWnwVbLeMAgofsBVmoCjY4i95v0gpREUGhZty2YJYTDqK/xYov HpguDJLeMW6MsP50L1ZOl3qQqFOsc35lWcOzt4gXgnAcX3REsjOslHMsOlqmYnOY bOuoEtR7msovOjrltSpVVd4j8hx/4AYQJegQGEIKmfUmpY9Bs3AztdAhIgAOcyt7 gq9HpI5QAGiKZtwBUoudONEM9zeT+rzxux1AJi1mSKfvZMbrY/xSeX+856+vmexP w3T5WxFyDIAL9imiNiBzEKsMV0LObolcdMGONquHc42tYsZmxeuAA/EDdEcuFVjB lkOQg4EkkGTbo8BF0KswwkKP8FbClxhdpEkeiyUPftjwu5GChnK8BNzVmZlaU+zq 7dY5cqao5UXpCjU/BSyeObPhgRXwTRW12PkQG97HVrjLCwSnPWAVACWamYFUjuoS K8VXsveWLi0+Ca2gzL+Qlv7iqCmeuFbOfxFA1AKLzVTDFUr3AeBT1jMNX92vdGLk 3jUM7H6Qd9LKq5phmMDJFUlz2E/QM4vVJDfiNUKj/V7egbCT2N2WL6ggZJRp83K5 4XVKoW2CdRsQsEXm4TbpVWYUvFtT2sf6BdjHConH7ywj8YxfBfIz8w0DoASXaWV0 YOpyyI7VOMNmDo81k2zak4zEtGooLCBz2HU3u5QRjlfDB6fjzRW76Ifbyk817w1d 75VxcYoNSxFxv2RsBhscbpfw5oh2eLHaM2Usxy540ha4avLdXbumorgnCilEOYcW GOn1uO1wDSJ3+sAiyTBHqIZfUmoUK1W06efsxzRvsDKb -----END ENCRYPTED PRIVATE KEY----- 2022-12-11 01:44:57
4 Demo group with 4 participants demo Participant four <Binary: 256 bytes> 2022-12-11 01:44:26 -----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEApACaY97LvMqEG+O9uXG/ aLtULv+MAK7qMGb1O6BUX/4/rAm2zu9Puoxh+57/y02me79uJWU/+nJVnOnX60XO WUGgg6LFeCcfQjWxAgkJCBVmw2q59MxEgW594O8egD522/vdKwrpkyIaIhCI+epA Q7g3vMp5Sf2kx/ruRSxq9rsFTB5Bb1MoyX3cvpr6pBxDYL9ek611aUcQcFo4JntJ waU2mSb8fBvcyr7wrArLiTuXIGJ2u3Cch+Hd2F9rwP+3Q/YYYkhPC5LkK2vrGj1O 2nDcQrXh9JXUbzG9+imibYBcM5OgSFUOxoXD4WMlfgI6jftfTtVES3QTMatLzBLL mQIDAQAB -----END PUBLIC KEY----- -----BEGIN ENCRYPTED PRIVATE KEY----- MIIFLTBXBgkqhkiG9w0BBQ0wSjApBgkqhkiG9w0BBQwwHAQICTyTLwufoOQCAggA MAwGCCqGSIb3DQIJBQAwHQYJYIZIAWUDBAEqBBCVJfA1QstVI92O2FjSwI+MBIIE 0E02B6l5iYIti/GqDbEnVOuxBLXXU3lA6u4mGpx2C9FnNclR+OTvHbqr5eK28mF3 2z+gHhJzXy+z8Lmp+vDsK4RCoxjSKTqWRiZ5f60764S5kmpPi3t7cnytM253TP+B 0SIHgZuZveRZLmnlhbMtmbHjMwSMSaHQR15WcTItH4ALsoq2BwHalu3xx17NcUE6 KxJWbW5+3BC3oiiDDbiw10JhfFRxurBMzxPTUV5t6S5FbcaR7GZ/kmIQc5KUibRG US1es0tA6bG7Wk6rCrnJb2/HUBY5RD99i0cHdxGkLNQ3t/yIrwnVEKFS47l0jtkW R9XzjnmFY/xLsPEWpPt2sOR4fk//Si8zL6I/Ov/7g+bhbuUwJttZctPJINj/kDSG fM1QO8jBO0gDy+ShvdROf/R33brYCgBLo2GN5783Vxw2iIg0P3x8FRfbFP+QT1CW we+WFzDCWcxXepndjp8hV0r+keY6zDm9VLzBtf/CSR8ps9LxL0ibumcNMcP2sMPK H5Bv8SQLzmSbuveV5Yjb8vFjqr6PLdumj4BKiXy+chEr+vYNv6jT4d2NCFwncPLL yfmaiN/b5hexuNL+gjiVK+5iCZb6XOMJi4o6mxKsfEmApZ82/rv95en/DTQbqhPC 2zzUiZh92OetWY99bg/tdPLJbuPqQd4511jw744XZ3qTdorv/I9sA6lJfNUn4n/N 3CEN98vnMWwf2ZaYGliXw+wuZX5n+bNqQlydg3NVUQ0lGXPm9OFD1Cm75HcTq/DZ 2yO6EKdshC3i5CrKGVHq1YUKSL0SnB+zDU9lXsocj9Kbx+Pu22W5s9f4wpp4K0yj Mca0dgiGGULqa8dHFqauOurP8dng5Oo2ejEcPcwUYZEK7W0U03Dt3vL9oUcF0Wnp wlS7eJoSq28MNUSRWOwDxEhFe8JKFb/ctKUrHyHYp/7qqnrGu1rLexBzO0CeWv5u LdXETD01MlGEX8A4ADr071k1X+gbUR0vl52i5zZ/EhyafXFlic+SVk/Wcu2/ZHw4 f2RpV+uoLJEpvMa8JICVDeYKhcPej3+2wDVRcMavgTBP0mIcZbYBNCWWcPruwxvJ jCZbFxlEN8P4TEUd7z5KTiNcMXShmh6pIjfo/g9UvoPbWTDHKY14yYWwtYggoveu OYZDmEg4fAqIFiMZGkEl2px57wqSG367bE6/J9p1RfFzApYrEIQYApzz5/tgy8IK e2A+IqGAXg+ryNapA5OQDh4KuCeVGebRmCKMV0BKmpMdICAHZ/bU2pqJPAGuyv5h ZoB6PmMCPUmzqeNS7RbM8IvgiDLRcS6IvtKUmIbhU6rhJFrBc83JdZ6jo2GNn2Je tocRRE1gOq+mgKoZe+WPxJDZuq//esP+bu32RfYgjmdV/ox+AkWAi5L6avT5Y8ba CNtz1XqwnN2BpDzpBKWdBhyj2xUNuptC+EOUiYVOWspD6eTYYh1hv4TC6aJrT4cD 72BwTRPBJK2vcmJE8fzjvPIAGVE6sRPSfQg+WuIApNfHKDZVj65TB21YYtjAlPGT qAavdlTvQ44cK9HPyfl5N4KIDpI8IHBeK57GDNkj65QH3hZFGbpgB3zxxXCHXzt0 8YvscGlsMGpUDxyL/XyzgMNBjMPec9WJbiX71SiBO/VP -----END ENCRYPTED PRIVATE KEY-----  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE secret_santa_participants (
    id integer primary key,
    slug text references secret_santa(slug),
    name text,
    secret_message_encrypted bytes,
    password_issued_at text,
    public_key text,
    private_key text,
    message_read_at text
);