Query editor
SELECTaccount AS address,CASEWHEN account = 0x67090d86e110fb3974e3d3bd7e2999f58d009de8 THEN 'Blockchain at UCLA'WHEN account = 0x13bdae8c5f0fc40231f0e6a4ad70196f59138548 THEN 'Blockchain at Michigan'WHEN account = 0xdd1ecae49312f5a2fef65d13327e92d32864fdee THEN 'mxdydx.eth'WHEN account = 0x2c5320f40305ffc933385c6dcec5493fba7b98b8 THEN 'WOO DAO'WHEN account = 0xdc1f98682f4f8a5c6d54f345f448437b83f5e432 THEN 'Blockchain@Columbia'WHEN account = 0xdf71878436e521e430facf36ee5e3d74fa519f2c THEN 'Xenophon Labs'WHEN account = 0x389e3d1c46595af7335f8c6d3e403ce2e8a9cf8a THEN 'Dartmouth Blockchain'WHEN account = 0x7ae109a63ff4dc852e063a673b40bed85d22e585 THEN 'Blockchain at Berkeley'WHEN account = 0x2345f4e0cdf00d427d773413dd4617d0156c29a9 THEN 'BoilerBlockchain @ Purdue University'WHEN account = 0xfc3cb09934f2d25bcb493f0c67bd4802b0037cee THEN 'Dale Satre | Stanford Blockchain Club'WHEN account = 0xd4fc1974bfb6721785ca25828711d76a0fc2fea3 THEN 'AX07'WHEN account = 0xb55a948763e0d386b6defcd8070a522216ae42b1 THEN 'Reverie'WHEN account = 0x0898796cf9de9ff5bca0e9e8007fca959b63eeab THEN 'Moe_L'WHEN account = 0x1112c9c86aba7edcc60c15a8616ad9c164b25b33 THEN 'Vitalii'WHEN account = 0xca513bed287d83958cd140fd074cd66b4d988b99 THEN 'NTInc'WHEN account = 0x1982ac6974d8722779120204036b1b951d551bd6 THEN 'XiaoLou'WHEN account = 0x7d05f9d2e2498d47eb880d9ff64b02075db0c9a6 THEN 'Upload'WHEN account = 0x070341aa5ed571f0fb2c4a5641409b1a46b4961b THEN 'Penn Blockchain'WHEN account = 0x4ddfbc022a413a79401baec4947b04a0c0572c17 THEN '0xCLR'WHEN account = 0xa85e7767b5daffea56d3cddcda9c88ecfec500eb THEN 'chrizzo'WHEN account = 0x8ae9e39a644EcA92a70636B5F10FA4B72dac8B6B THEN '0xcchan'WHEN account = 0x0cd28e7813a60812684f53ed2102ad6afcf964ea THEN 'Micah'WHEN account = 0x0887360965511b7cb918db24c7ed9af5eacbecb2 THEN 'AndyGG'WHEN account = 0xe95f1a55C567A33dcc2f102E01243EE45e6dC5Fc THEN 'poppi'WHEN account = 0x169302787177a2A97067f3415b27df4Abf6c9fa6 THEN 'ARIA'WHEN account IN (0xB933AEe47C438f22DE0747D57fc239FE37878Dd1,0xd85E4Cb61841f0CA7676170E0ca81E913DC57778) THEN 'Wintermute'WHEN account = 0xea172676E4105e92Cc52DBf45fD93b274eC96676 THEN 'StableLab'WHEN account = 0xE93D59CC0bcECFD4ac204827eF67c5266079E2b5 THEN '404 DAO'WHEN account = 0xBEC643BD5b7F5e9190617CA4187ef0455950C51C THEN 'ITU Blockchain'WHEN account = 0x5cA3894616b2Ebb89e5079e341c142Bf9E3a78E4 THEN 'Nagoya Blockchain'WHEN account = 0x43D3938Ebd74106e2d177f9A304C1E9f914f2b52 THEN 'Bristol Blockchain'WHEN account = 0x213e1AB7aF73AC4b2856fD8BDfdB7c9037F60fa9 THEN 'MURPHY@BITCOIN'WHEN account = 0x62a43123FE71f9764f26554b3F5017627996816a THEN 'Flipside Crypto'WHEN account = 0xc598b55970352dBE3D123D6eFbd434f307804b5C THEN 'Foxlabs'WHEN account = 0x17296956b4E07Ff8931E4ff4eA06709FaB70b879 THEN 'Curia'--WHEN account = 0x377AB213B032Ce3879db52D62159fBA178272124 THEN 'RealVovochka'WHEN account = 0xf90B86fDbb194a703eA6709B1cB108079A5F9396 THEN 'Node-Guardians'WHEN account = 0x56b975C687cA3591F20F1A4e3cB948321314aD84 THEN 'Cipher Labs'WHEN account = 0x2E17BbdeE9110967497BEb99fC5Ae964861FA825 THEN 'Tane'WHEN account = 0xeFA1a4Bb4888e55B91b6dbe70be33cff1BB77ddd THEN 'NoblePeter2000'END AS endorsed_delegate,COALESCE(ethDYDX_balance, 0) AS "ethDYDX Balance",COALESCE(wethDYDX_balance, 0) AS "wethDYDX Balance",COALESCE(stkDYDX_balance, 0) AS "stkDYDX Balance",COALESCE(ethDYDX_balance, 0) + COALESCE(wethDYDX_balance, 0) + COALESCE(stkDYDX_balance, 0) AS "all_balance",COALESCE(Count_of_DIPs_Voted, 0) AS "Number of DIPs voted",COALESCE(ethDYDX_Proposal_Current_Power, 0) AS "ethDYDX_Proposal_Current_Power",COALESCE(ethDYDX_Voting_Current_Power, 0) AS "ethDYDX_Voting_Current_Power",COALESCE(ethDYDX_Proposal_Current_Power_delegator, 0) AS "ethDYDX_Proposal_Current_Power_Delegator",COALESCE(ethDYDX_Voting_Current_Power_delegator, 0) AS "ethDYDX_Voting_Current_Power_Delegator",COALESCE(wethDYDX_Proposal_Current_Power, 0) AS "wethDYDX_Proposal_Current_Power",COALESCE(wethDYDX_Voting_Current_Power, 0) AS "wethDYDX_Voting_Current_Power",COALESCE(wethDYDX_Proposal_Current_Power_delegator, 0) AS "wethDYDX_Proposal_Current_Power_Delegator",COALESCE(wethDYDX_Voting_Current_Power_delegator, 0) AS "wethDYDX_Voting_Current_Power_Delegator",COALESCE(stkDYDX_Proposal_Current_Power, 0) AS "stkDYDX_Proposal_Current_Power",