DiamondNFLAD Playoff Competition - Rookie Leaderboard (Divisional Round)
    Updated 2024-02-14
    WITH ppr_data AS (
    SELECT
    livequery.live.udf_api (
    'https://flipsidecrypto.xyz/api/v1/queries/67f04177-e529-47b2-b3f5-c9c117ea0792/data/latest' -- ROOKIE SCORING (DIVISIONAL ROUND)
    ) :data AS json_data
    ),
    select_data AS (
    SELECT
    DISTINCT f.value:"Wallet" AS "Wallet",
    value:"Wallet Score" :: DOUBLE AS "Score"
    FROM
    ppr_data,
    LATERAL FLATTEN(input => json_data) AS f
    )
    SELECT
    select_data."Score" as "SCORE",
    dim_nflad_playoff_rosters.WALLET AS "WALLET",
    CASE
    WHEN dim_nflad_playoff_rosters.WALLET = '0x9b879eee67d839cc' THEN 'Diamond'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x3376758a5e4ebe6c' THEN 'Draxthedestroyer'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x8b6a462c281aadfb' THEN 'AndrewHallFF'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xc5f2b68d7bf3fadb' THEN 'jaykappa'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x7b70673057616601' THEN 'GRWRIGHT8787'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x31007f0d4dc6f5fc' THEN 'Yolodawg'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xb0c3cea14d23d224' THEN 'BRothrock'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xccad7ebbc155c12e' THEN 'RebelRy09'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xce609693f76f1467' THEN 'Gloade666'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x42e1c4c3843ca7d1' THEN 'hueskie'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x31aaf244670ceb9d' THEN 'Nitsuj_J'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xbee776009d396a51' THEN 'Jaydeegee'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x760e5312752dc4ae' THEN 'ElJefe604'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x2252abfb10fe4ee3' THEN 'ricsquad'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xa4838affeea62764' THEN 'Endless_Winter_2016'
    WHEN dim_nflad_playoff_rosters.WALLET = '0x4e2c842cb5d154ee' THEN 'KGBeast'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xe5d6e4db7b16dd40' THEN 'Hoopahollic'
    WHEN dim_nflad_playoff_rosters.WALLET = '0xf90cc1a4c029c83c' THEN 'Chapstick'
    Last run: 12 months ago
    SCORE
    WALLET
    ACCOUNT
    QB
    RB#1
    RB#2
    RB#3
    WR#1
    WR#2
    WR#3
    TE
    FLEX#1
    FLEX#2
    1
    167.9250x9b879eee67d839ccDiamondJosh Allen - UNCOMMONChristian McCaffrey - UNCOMMONJahmyr Gibbs - UNCOMMONKyren Williams - UNCOMMONCeeDee Lamb - UNCOMMONTyreek Hill - UNCOMMONA.J. Brown - UNCOMMONTravis Kelce - COMMONNico Collins - UNCOMMONRachaad White - UNCOMMON
    2
    161.4250xc5f2b68d7bf3fadbjaykappaJosh Allen - UNCOMMONJahmyr Gibbs - UNCOMMONChristian McCaffrey - UNCOMMONIsiah Pacheco - UNCOMMONTyreek Hill - UNCOMMONPuka Nacua - UNCOMMONCeeDee Lamb - UNCOMMONDallas Goedert - UNCOMMONRachaad White - UNCOMMONZay Flowers - UNCOMMON
    3
    159.9550x31007f0d4dc6f5fcYolodawgLamar Jackson - COMMONChristian McCaffrey - COMMONJerome Ford - UNCOMMONKyren Williams - COMMONAmon-Ra St. Brown - COMMONCeeDee Lamb - UNCOMMONStefon Diggs - UNCOMMONTravis Kelce - COMMONNico Collins - UNCOMMONRachaad White - UNCOMMON
    4
    156.3750xcfd9bad75352b43bJunglerulesJosh Allen - UNCOMMONChristian McCaffrey - UNCOMMONKyren Williams - UNCOMMONIsiah Pacheco - UNCOMMONAmon-Ra St. Brown - COMMONZay Flowers - UNCOMMONCeeDee Lamb - UNCOMMONDavid Njoku - COMMONRaheem Mostert - UNCOMMONRachaad White - UNCOMMON
    5
    148.1750x3376758a5e4ebe6cDraxthedestroyerJosh Allen - UNCOMMONChristian McCaffrey - COMMONDe'Von Achane - UNCOMMONJerome Ford - UNCOMMONCeeDee Lamb - UNCOMMONNico Collins - UNCOMMONZay Flowers - UNCOMMONTravis Kelce - COMMONPuka Nacua - UNCOMMONMike Evans - COMMON
    6
    144.6250xf897de380cb49b64AllDayCostanzaJosh Allen - UNCOMMONDe'Von Achane - UNCOMMONRachaad White - UNCOMMONChristian McCaffrey - UNCOMMONZay Flowers - UNCOMMONRashee Rice - UNCOMMONCeeDee Lamb - UNCOMMONDallas Goedert - UNCOMMONAmon-Ra St. Brown - COMMONAmari Cooper - COMMON
    7
    143.330xddece960930dea52beexLamar Jackson - COMMONChristian McCaffrey - COMMONJahmyr Gibbs - COMMONIsiah Pacheco - COMMONTyreek Hill - UNCOMMONCeeDee Lamb - UNCOMMONStefon Diggs - UNCOMMONDavid Njoku - COMMONMike Evans - COMMONPuka Nacua - UNCOMMON
    8
    142.880x7d8f08954f51d0a7Dharma_GardenerLamar Jackson - COMMONChristian McCaffrey - COMMOND'Andre Swift - COMMONJames Cook - COMMONJaylen Waddle - UNCOMMONCeeDee Lamb - COMMONAmon-Ra St. Brown - COMMONTravis Kelce - COMMONKyren Williams - COMMONAaron Jones - COMMON
    9
    140.430x25c3ed8f6c194beeMrKicker23Lamar Jackson - COMMONRachaad White - COMMONJaylen Warren - UNCOMMONChristian McCaffrey - COMMONTyreek Hill - COMMONCeeDee Lamb - COMMONDeVonta Smith - COMMONTravis Kelce - COMMONAmon-Ra St. Brown - COMMONStefon Diggs - UNCOMMON
    10
    137.50x5bd5385a428ef5b2BuffaloSpaceJosh Allen - UNCOMMONChristian McCaffrey - COMMONKyren Williams - COMMONJahmyr Gibbs - COMMONCeeDee Lamb - COMMONTyreek Hill - COMMONA.J. Brown - COMMONTravis Kelce - COMMONAaron Jones - COMMONGus Edwards - COMMON
    11
    136.4250x4f768fbfc061a5b6chinnypicsJosh Allen - UNCOMMONIsiah Pacheco - UNCOMMONJerome Ford - UNCOMMONJahmyr Gibbs - UNCOMMONCeeDee Lamb - UNCOMMONZay Flowers - UNCOMMONPuka Nacua - UNCOMMONDallas Goedert - UNCOMMONNico Collins - UNCOMMONRachaad White - UNCOMMON
    12
    136.380xfe5007fe4ddf8f1fAlexEnglishLamar Jackson - COMMONChristian McCaffrey - COMMONIsiah Pacheco - RAREDevin Singletary - COMMONA.J. Brown - COMMONCeeDee Lamb - COMMONStefon Diggs - COMMONDavid Njoku - COMMONMike Evans - COMMONAmon-Ra St. Brown - COMMON
    13
    135.4650x813eecae0ea74db8MonkimanmonkJosh Allen - COMMONChristian McCaffrey - COMMONIsiah Pacheco - UNCOMMOND'Andre Swift - COMMONPuka Nacua - UNCOMMONCeeDee Lamb - COMMONTyreek Hill - COMMONDavid Njoku - COMMONAmon-Ra St. Brown - COMMONMike Evans - COMMON
    14
    134.580xd0a5910478602d19ChewieWoolfLamar Jackson - COMMONChristian McCaffrey - COMMONDavid Montgomery - COMMONTony Pollard - COMMONTyreek Hill - COMMONStefon Diggs - COMMONA.J. Brown - COMMONTravis Kelce - COMMONCooper Kupp - COMMONMike Evans - COMMON
    15
    134.280xed67ca1072a41242Bure10Lamar Jackson - COMMONChristian McCaffrey - COMMONKyren Williams - COMMONJames Cook - RARECeeDee Lamb - COMMONAmon-Ra St. Brown - COMMONTyreek Hill - COMMONTravis Kelce - COMMONDeVonta Smith - RAREChris Godwin - COMMON
    16
    132.9750xc8bbd22a88b8b467bumzhabumJoe Flacco - UNCOMMONChristian McCaffrey - UNCOMMONKyren Williams - UNCOMMONIsiah Pacheco - UNCOMMONCeeDee Lamb - UNCOMMONZay Flowers - COMMONTyreek Hill - UNCOMMONDalton Kincaid - UNCOMMONRachaad White - UNCOMMONJahmyr Gibbs - UNCOMMON
    17
    129.6750x9f74f9896e1df5f1CaseythewormJosh Allen - UNCOMMONChristian McCaffrey - UNCOMMONDe'Von Achane - UNCOMMONJahmyr Gibbs - UNCOMMONCeeDee Lamb - UNCOMMONNico Collins - UNCOMMONPuka Nacua - UNCOMMONDavid Njoku - COMMONZay Flowers - UNCOMMONA.J. Brown - UNCOMMON
    18
    127.7750x760e5312752dc4aeElJefe604Josh Allen - UNCOMMONKyren Williams - UNCOMMONRachaad White - UNCOMMONDe'Von Achane - UNCOMMONZay Flowers - UNCOMMONCeeDee Lamb - UNCOMMONNico Collins - UNCOMMONGeorge Kittle - COMMONIsiah Pacheco - UNCOMMONA.J. Brown - UNCOMMON
    19
    125.680x33fb80905088b044ajmasselinkLamar Jackson - COMMONIsiah Pacheco - COMMONChristian McCaffrey - COMMONAaron Jones - COMMONTyreek Hill - COMMONCooper Kupp - COMMONCeeDee Lamb - COMMONDawson Knox - COMMONA.J. Brown - COMMONAmon-Ra St. Brown - COMMON
    20
    124.780xcc2563b2fe07f312balooLamar Jackson - COMMONTony Pollard - COMMONIsiah Pacheco - COMMOND'Andre Swift - COMMONAmon-Ra St. Brown - COMMONMike Evans - COMMONGabe Davis - COMMONGeorge Kittle - COMMONChristian Watson - COMMONBrandin Cooks - COMMON
    59
    17KB
    36s