Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@ice09
Created April 25, 2021 08:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ice09/7a5191e6fa545b822e2e65d53ca57912 to your computer and use it in GitHub Desktop.
Save ice09/7a5191e6fa545b822e2e65d53ca57912 to your computer and use it in GitHub Desktop.
Some CirclesUBI Numbers
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 1 column, instead of 2. in line 2.
# Users with most outgoing trusts
# MATCH (tr:User)-[r:TRUSTS]->(te:User)
# RETURN tr AS Truster, COUNT(r)
# ORDER BY COUNT(r) DESC
Truster,COUNT(r)
"{""name"":cuinima1,""address"":0xBFB9749A89376565C79e17050842413F3AB43821,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/285246319f75cbb68f35154d4fa019043ded41ea2ae6010b7156e7ea8c6c099e.jpg}",3297
"{""name"":cuinima3,""address"":0x674Ee4c8B66f54c91e62fe49EadFA1A70b5b8DA4,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/609392f19687b3f5c6454b467a539843258bff229fc270c8b7624b575034b850.jpg}",2843
"{""name"":cuinima,""address"":0xD5eFcB307623728989E0431277C6230c2666cA69,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/22072a6eafe63a2a10e6dbd7acf6ed72fa4d0d79e6ca4adbcb0c919626dcf8b4.jpg}",2330
"{""name"":f4az3zl8ek,""address"":0xCb5D036b9661D119003C487915b18F7118Cdb8eE}",967
"{""name"":cc115,""address"":0x4F1E89f4DA3f3Ad0ABB147679C6444f6CeAD9D13,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/b03bc29673c262c26d18e04006e31aa71ca7cc061ae8fcdaacdea09813cee2f6.jpg}",503
"{""name"":Slyalan,""address"":0x8978C2b3350AE4Ffa6473Bf4461071Cfcc656216,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/b25208d283c9ef5cc0be939a5c33f555d20607de765089920cb54413668404d2.jpg}",477
"{""name"":cuinimatest002,""address"":0xf9377384383FcD9de649500c693F45c9ffB254cB}",476
"{""name"":zhaoqinglan,""address"":0x6904A133C111C35Bb77eCb52d842907d70D136aa,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/9ed91813dd71075c236522cb16d41036bc7052ac6b7152bae35fd995146320bb.jpg}",453
"{""address"":0xaab94be862cfb924989fbf8ebad4500c60686e4a}",437
"{""name"":jecken,""address"":0x16DA28501F81923aA632658669E15cB41eD2e184,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/b347b7295a41e67c60a9d29c6ef447fe40439faf9d2cd8ad4145c680a3873e03.jpg}",429
"{""address"":0x7a037824649d76e84e3d7ece74574805469e6e90}",419
"{""name"":cgood,""address"":0x3b4b16a0e4838c62c68cb2080eD71397Be69E155}",400
"{""name"":aas,""address"":0x73387332Ed021Dae597c0A1cb805D36947dB23Ed,""image_url"":}",396
"{""name"":onlyou,""address"":0x63A71E9381dDe28C03b6b707D311e8FE2cC72709,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/5bf274acbaf1650389d1e99907b317ca096a6ad3d32ab4ee0020591c639d0ea3.jpg}",394
"{""address"":0x12c8588e2e0b9215f49761c2606c7505bd9a3b23}",375
"{""name"":whitelist857,""address"":0xb0cE698097ee459736F5b7A7d3119E9c11C2DcA1,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/0eecc0b58c541a4bf806ff10cb45d9f96e194c825c8ef4865e1305dd17ef0461.jpg}",357
"{""name"":jaxdeng0379,""address"":0x931e8cBEa2346209EC5ed2170e64a280432ffdc8,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/d35a02d63fec15d30112701d15bf0a743aff8e6682b040d4a74c4c907f8c9e74.jpg}",353
"{""name"":jax67626,""address"":0x9C5918154a4355A4Fc3C9cbB1DfA69A7e1349805,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/f7b47f331ae0fab51544b9bea18ec39daaf006baeea57be771b36634c957c857.jpg}",353
"{""name"":duke2020,""address"":0x8048Db6A23f6ae04B4a242b51cf99A38dDBfdCd5,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/f464abf45f9df06a6b8d4c4a76b3617558cedb4c221289992e51f723211e5f17.jpg}",328
# Users with mosts incoming trusts
# MATCH (tr:User)<-[r:TRUSTS]-(te:User)
# RETURN tr AS Trustee, COUNT(r)
# ORDER BY COUNT(r) DESC
Trustee,COUNT(r)
"{""address"":0xaab94be862cfb924989fbf8ebad4500c60686e4a}",426
"{""name"":13655134513,""address"":0x24598038EA864fcF3EFE18Ba3Acd2d4e5D91A1d5,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/c1e6abf997f800e8c5a415c305077763257c82efb3f2d65b660c733dd8eebb82.jpg}",425
"{""name"":cc115,""address"":0x4F1E89f4DA3f3Ad0ABB147679C6444f6CeAD9D13,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/b03bc29673c262c26d18e04006e31aa71ca7cc061ae8fcdaacdea09813cee2f6.jpg}",318
"{""name"":duke2020,""address"":0x8048Db6A23f6ae04B4a242b51cf99A38dDBfdCd5,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/f464abf45f9df06a6b8d4c4a76b3617558cedb4c221289992e51f723211e5f17.jpg}",303
"{""address"":0x7a037824649d76e84e3d7ece74574805469e6e90}",281
"{""address"":0x5b3c23b4caf0885f02181f391a7584e534d2d289}",280
"{""address"":0xd6b16f4c453ab7706b151cea446d71c81f9a75ce}",273
"{""name"":max20,""address"":0x27486E1353e2B48B1914C21178b2A08C9E2b427A,""image_url"":}",261
"{""name"":max21,""address"":0xB0f9fdBe526D81DF991fAEE4f8810Ea765BCF613,""image_url"":}",260
"{""name"":0a166cirlesUBlgarden,""address"":0x5d900915475A3EE597423273fB01Ec23bd7843C0,""image_url"":https://circles-ubi.s3.amazonaws.com/uploads/avatars/857c9dc57e6d41b8f8e44ac54c2af9a2e86d1b5e0e009cd56b3fee700820a6cb.jpg}",256
"{""name"":reaman,""address"":0x992Eb0aeB2635f8BFb4fA4F94d85AFCE19992602,""image_url"":}",253
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment