GraphGists

NOTE: We branched the initialization blocks because graph is huge and we got http 500 twenty four seven. Now we have 1k queries! It’s slow, it takes like ten minutes. If you don’t want wait, yo can download it and test it locally.

NBA Sneakers

Motivation

Nowadays everyone agrees that hip-hop culture and basketball have deep relationships. Since “My Adidas” of RUN DMC, going through 1985 and Michael Jordan’s debut until now, the importance of sneakers has become greater and greater. There is a widespread attitude that considers them to be a status symbol.

Our main goal is to study the influence of different brands of sneakers upon the NBA basketball league. It is easy enough to make broad generalizations about the topic, but actually the issue is an extremely complex one. We have create a graph which is used to visualize the relationships between the players and their own footwear. In addition, it also gives information about teams, conferences and divisions.

Data model

Cp4Qsq6

Let’s begin by trying to understand more of the graph. We use this labels which represent:

  • Player: basketball player. In addition, one player can be:

    • Rookie: freshman.

    • AllStar: really good player.

  • Team: professional basketball team who plays in the NBA.

  • Model: a sneaker model.

  • Brand: a company that manufactures sneakers.

  • Division: one of the six divisions of the NBA.

  • Conference: East or West, where a given division belongs.

Gettin' started

This query creates the graph!

create (_0:`Conference` {`name`:"East"})
 create (_1:`Conference` {`name`:"West"})
 create (_2:`Division` {`name`:"Atlantic"})
 create (_3:`Division` {`name`:"Southeast"})
 create (_4:`Division` {`name`:"Central"})
 create (_5:`Division` {`name`:"Northwest"})
 create (_6:`Division` {`name`:"Southwest"})
 create (_7:`Division` {`name`:"Pacific"})
 create (_34152:`Team` {`abbreviation`:"ATL", `city`:"Atlanta", `full_name`:"Atlanta Hawks"})
 create (_34153:`Player` {`age`:31, `birthplace`:"Skopje, Macedonia", `first_name`:"Pero", `height_formatted`:"6'11\"", `last_name`:"Antic", `shoe_size`:19.5})
 create (_34154:`Player` {`age`:28, `birthplace`:"Tepic, Mexico", `first_name`:"Gustavo", `height_formatted`:"6'10\"", `last_name`:"Ayon", `shoe_size`:17})
 create (_34155:`Player` {`age`:34, `birthplace`:"Peekskill, New York, USA", `first_name`:"Elton", `height_formatted`:"6'8\"", `last_name`:"Brand", `shoe_size`:17})
 create (_34156:`Player` {`age`:27, `birthplace`:"Birmingham, Alabama, USA", `first_name`:"DeMarre", `height_formatted`:"6'8\"", `last_name`:"Carroll", `shoe_size`:14})
 create (_34157:`Player` {`age`:22, `birthplace`:"Oakland, California, USA", `first_name`:"Jared", `height_formatted`:"6'4\"", `last_name`:"Cunningham", `shoe_size`:13})
 create (_34158:`Player` {`age`:27, `birthplace`:"Puerto Plata, Dominican Republic", `first_name`:"Al", `height_formatted`:"6'10\"", `last_name`:"Horford", `shoe_size`:17})
 create (_34159:`Player` {`age`:22, `birthplace`:"Hendersonville, Tennessee, USA", `first_name`:"John", `height_formatted`:"6'4\"", `last_name`:"Jenkins", `shoe_size`:15})
 create (_34160:`Player` {`age`:32, `birthplace`:"Lakewood, California, USA", `first_name`:"Kyle", `height_formatted`:"6'7\"", `last_name`:"Korver", `shoe_size`:14})
 create (_34161:`Player` {`age`:23, `birthplace`:"Lexington, Kentucky, USA", `first_name`:"Shelvin", `height_formatted`:"6'3\"", `last_name`:"Mack", `shoe_size`:14})
 create (_34162:`Player` {`age`:29, `birthplace`:"Crockett, Texas, USA", `first_name`:"Cartier", `height_formatted`:"6'7\"", `last_name`:"Martin", `shoe_size`:13.5})
 create (_34163:`Player` {`age`:28, `birthplace`:"Monroe, Louisiana, USA", `first_name`:"Paul", `height_formatted`:"6'8\"", `last_name`:"Millsap", `shoe_size`:16})
 create (_34164:`Player` {`age`:25, `birthplace`:"Chesapeake, Virginia, USA", `first_name`:"Mike", `height_formatted`:"6'8\"", `last_name`:"Scott", `shoe_size`:16})
 create (_34165:`Player` {`age`:25, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Jeff", `height_formatted`:"6'2\"", `last_name`:"Teague", `shoe_size`:12})
 create (_34166:`Player` {`age`:27, `birthplace`:"Lithonia, Georgia, USA", `first_name`:"Louis", `height_formatted`:"6'2\"", `last_name`:"Williams", `shoe_size`:12})
 create (_34167:`Team` {`abbreviation`:"BOS", `city`:"Boston", `full_name`:"Boston Celtics"})
 create (_34168:`Player` {`age`:28, `birthplace`:"Baton Rouge, Louisiana, USA", `first_name`:"Brandon", `height_formatted`:"6'8\"", `last_name`:"Bass", `shoe_size`:15.5})
 create (_34169:`Player` {`age`:33, `birthplace`:"Alexandria, Virginia, USA", `first_name`:"Keith", `height_formatted`:"6'5\"", `last_name`:"Bogans", `shoe_size`:13.5})
 create (_34170:`Player` {`age`:23, `birthplace`:"Tacoma, Washington, USA", `first_name`:"Avery", `height_formatted`:"6'2\"", `last_name`:"Bradley", `shoe_size`:13})
 create (_34171:`Player` {`age`:24, `birthplace`:"Stone Mountain, Georgia, USA", `first_name`:"MarShon", `height_formatted`:"6'5\"", `last_name`:"Brooks", `shoe_size`:12})
 create (_34172:`Player` {`age`:25, `birthplace`:"Detroit, Michigan, USA", `first_name`:"Jordan", `height_formatted`:"6'4\"", `last_name`:"Crawford", `shoe_size`:12.5})
 create (_34173:`Player` {`age`:25, `birthplace`:"Porto Alegre, Brazil", `first_name`:"Vitor", `height_formatted`:"6'11\"", `last_name`:"Faverani", `shoe_size`:16.5})
 create (_34174:`Player` {`age`:27, `birthplace`:"Cheverly, Maryland, USA", `first_name`:"Jeff", `height_formatted`:"6'9\"", `last_name`:"Green", `shoe_size`:15})
 create (_34175:`Player` {`age`:28, `birthplace`:"Minneapolis, Minnesota, USA", `first_name`:"Kris", `height_formatted`:"6'9\"", `last_name`:"Humphries", `shoe_size`:14.5})
 create (_34176:`Player` {`age`:28, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Courtney", `height_formatted`:"6'5\"", `last_name`:"Lee", `shoe_size`:13})
 create (_34177:`Player`:`Rookie` {`age`:22, `birthplace`:"Toronto, Canada", `first_name`:"Kelly", `height_formatted`:"7'0\"", `last_name`:"Olynyk", `shoe_size`:17})
 create (_34178:`Player` {`age`:22, `birthplace`:"Dallas, Texas, USA", `first_name`:"Phil", `height_formatted`:"5'11\"", `last_name`:"Pressey", `shoe_size`:11})
 create (_34179:`Player`:`AllStar` {`age`:27, `birthplace`:"Louisville, Kentucky, USA", `first_name`:"Rajon", `height_formatted`:"6'1\"", `last_name`:"Rondo", `shoe_size`:13})
 create (_34180:`Player` {`age`:21, `birthplace`:"Columbus, Ohio, USA", `first_name`:"Jared", `height_formatted`:"6'9\"", `last_name`:"Sullinger", `shoe_size`:18})
 create (_34181:`Player` {`age`:31, `birthplace`:"Sylacauga, Alabama, USA", `first_name`:"Gerald", `height_formatted`:"6'7\"", `last_name`:"Wallace", `shoe_size`:14})
 create (_34182:`Team` {`abbreviation`:"BKN", `city`:"Brooklyn", `full_name`:"Brooklyn Nets"})
 create (_34183:`Player` {`age`:31, `birthplace`:"Minneapolis, Minnesota, USA", `first_name`:"Alan", `height_formatted`:"6'6\"", `last_name`:"Anderson", `shoe_size`:15})
 create (_34184:`Player` {`age`:27, `birthplace`:"Syracuse, New York, USA", `first_name`:"Andray", `height_formatted`:"6'11\"", `last_name`:"Blatche", `shoe_size`:16})
 create (_34185:`Player` {`age`:33, `birthplace`:"Pensacola, Florida, USA", `first_name`:"Reggie", `height_formatted`:"6'8\"", `last_name`:"Evans", `shoe_size`:15.5})
 create (_34186:`Player`:`AllStar` {`age`:37, `birthplace`:"Mauldin, South Carolina, USA", `first_name`:"Kevin", `height_formatted`:"6'11\"", `last_name`:"Garnett", `shoe_size`:15})
 create (_34187:`Player` {`age`:32, `birthplace`:"Little Rock, Arkansas, USA", `first_name`:"Joe", `height_formatted`:"6'8\"", `last_name`:"Johnson", `shoe_size`:16})
 create (_34188:`Player` {`age`:32, `birthplace`:"Moscow, Russian Federation", `first_name`:"Andrei", `height_formatted`:"6'9\"", `last_name`:"Kirilenko", `shoe_size`:17})
 create (_34189:`Player` {`age`:28, `birthplace`:"Peoria, Illinois, USA", `first_name`:"Shaun", `height_formatted`:"6'7\"", `last_name`:"Livingston", `shoe_size`:14})
 create (_34190:`Player`:`AllStar` {`age`:25, `birthplace`:"North Hollywood, California, USA", `first_name`:"Brook", `height_formatted`:"7'0\"", `last_name`:"Lopez", `shoe_size`:20})
 create (_34191:`Player`:`AllStar` {`age`:36, `birthplace`:"Oakland, California, USA", `first_name`:"Paul", `height_formatted`:"6'7\"", `last_name`:"Pierce", `shoe_size`:15})
 create (_34192:`Player`:`Rookie` {`age`:23, `birthplace`:"Fort Wayne, Indiana, USA", `first_name`:"Mason", `height_formatted`:"6'10\"", `last_name`:"Plumlee", `shoe_size`:17})
 create (_34193:`Player` {`age`:22, `birthplace`:"Tbilisi, Georgia", `first_name`:"Tornike", `height_formatted`:"6'8\"", `last_name`:"Shengelia", `shoe_size`:14.5})
 create (_34194:`Player` {`age`:23, `birthplace`:"Hoboken, New Jersey, USA", `first_name`:"Tyshawn", `height_formatted`:"6'3\"", `last_name`:"Taylor", `shoe_size`:13.5})
 create (_34195:`Player` {`age`:28, `birthplace`:"Mostar, Bosnia and Herzegovina", `first_name`:"Mirza", `height_formatted`:"6'9\"", `last_name`:"Teletović", `shoe_size`:15.5})
 create (_34196:`Player` {`age`:36, `birthplace`:"Seattle, Washington, USA", `first_name`:"Jason", `height_formatted`:"6'2\"", `last_name`:"Terry", `shoe_size`:12})
 create (_34197:`Player` {`age`:29, `birthplace`:"Parkersburg, West Virginia, USA", `first_name`:"Deron", `height_formatted`:"6'3\"", `last_name`:"Williams", `shoe_size`:10.5})
 create (_34198:`Team` {`abbreviation`:"CHA", `city`:"Charlotte", `full_name`:"Charlotte Bobcats"})
 create (_34199:`Player` {`age`:27, `birthplace`:"Brookline, Massachusetts, USA", `first_name`:"Jeff", `height_formatted`:"6'7\"", `last_name`:"Adrien", `shoe_size`:16})
 create (_34200:`Player` {`age`:21, `birthplace`:"Lubumbashi, Congo", `first_name`:"Bismack", `height_formatted`:"6'9\"", `last_name`:"Biyombo", `shoe_size`:16})
 create (_34201:`Player` {`age`:26, `birthplace`:"Detroit, Michigan, USA", `first_name`:"Chris", `height_formatted`:"6'7\"", `last_name`:"Douglas-Roberts", `shoe_size`:12.5})
 create (_34202:`Player` {`age`:30, `birthplace`:"London, United Kingdom", `first_name`:"Ben", `height_formatted`:"6'3\"", `last_name`:"Gordon", `shoe_size`:12})
 create (_34203:`Player` {`age`:34, `birthplace`:"New York, New York, USA", `first_name`:"Brendan", `height_formatted`:"7'0\"", `last_name`:"Haywood", `shoe_size`:18})
 create (_34204:`Player` {`age`:26, `birthplace`:"Caldwell, New Jersey, USA", `first_name`:"Gerald", `height_formatted`:"6'4\"", `last_name`:"Henderson", `shoe_size`:15})
 create (_34205:`Player` {`age`:28, `birthplace`:"Monticello, Mississippi, USA", `first_name`:"Al", `height_formatted`:"6'10\"", `last_name`:"Jefferson", `shoe_size`:18})
 create (_34206:`Player` {`age`:20, `birthplace`:"Somerdale, New Jersey, USA", `first_name`:"Michael", `height_formatted`:"6'7\"", `last_name`:"Kidd-Gilchrist", `shoe_size`:16})
 create (_34207:`Player` {`age`:26, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Josh", `height_formatted`:"6'10\"", `last_name`:"McRoberts", `shoe_size`:18})
 create (_34208:`Player` {`age`:34, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Jannero", `height_formatted`:"6'1\"", `last_name`:"Pargo", `shoe_size`:12})
 create (_34209:`Player` {`age`:27, `birthplace`:"Myrtle Beach, South Carolina, USA", `first_name`:"Ramon", `height_formatted`:"6'3\"", `last_name`:"Sessions", `shoe_size`:12})
 create (_34210:`Player` {`age`:24, `birthplace`:"Norrköping, Sweden", `first_name`:"Jeffery", `height_formatted`:"6'7\"", `last_name`:"Taylor", `shoe_size`:13.5})
 create (_34211:`Player` {`age`:28, `birthplace`:"Springfield, Missouri, USA", `first_name`:"Anthony", `height_formatted`:"6'9\"", `last_name`:"Tolliver", `shoe_size`:14.5})
 create (_34212:`Player` {`age`:23, `birthplace`:"Bronx, New York, USA", `first_name`:"Kemba", `height_formatted`:"6'1\"", `last_name`:"Walker", `shoe_size`:11.5})
 create (_34213:`Player`:`Rookie` {`age`:21, `birthplace`:"Washington, Indiana, USA", `first_name`:"Cody", `height_formatted`:"7'0\"", `last_name`:"Zeller", `shoe_size`:16.5})
 create (_34214:`Team` {`abbreviation`:"CHI", `city`:"Chicago", `full_name`:"Chicago Bulls"})
 create (_34215:`Player` {`age`:26, `birthplace`:"New Orleans, Louisiana, USA", `first_name`:"D.J.", `height_formatted`:"6'0\"", `last_name`:"Augustin", `shoe_size`:12})
 create (_34216:`Player` {`age`:32, `birthplace`:"Aschaffenburg, Germany", `first_name`:"Carlos", `height_formatted`:"6'9\"", `last_name`:"Boozer", `shoe_size`:17})
 create (_34217:`Player` {`age`:24, `birthplace`:"Houston, Texas, USA", `first_name`:"Jimmy", `height_formatted`:"6'7\"", `last_name`:"Butler", `shoe_size`:14})
 create (_34218:`Player`:`AllStar` {`age`:28, `birthplace`:"Wau, Sudan", `first_name`:"Luol", `height_formatted`:"6'8\"", `last_name`:"Deng", `shoe_size`:15})
 create (_34219:`Player` {`age`:33, `birthplace`:"Fort Worth, Texas, USA", `first_name`:"Mike", `height_formatted`:"6'9\"", `last_name`:"Dunleavy", `shoe_size`:15})
 create (_34220:`Player` {`age`:28, `birthplace`:"San Fernando, California, USA", `first_name`:"Taj", `height_formatted`:"6'9\"", `last_name`:"Gibson", `shoe_size`:16})
 create (_34221:`Player` {`age`:32, `birthplace`:"Sioux City, Iowa, USA", `first_name`:"Kirk", `height_formatted`:"6'4\"", `last_name`:"Hinrich", `shoe_size`:13})
 create (_34222:`Player` {`age`:38, `birthplace`:"Amityville, New York, USA", `first_name`:"Mike", `height_formatted`:"6'2\"", `last_name`:"James", `shoe_size`:10.5})
 create (_34223:`Player` {`age`:36, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Nazr", `height_formatted`:"6'10\"", `last_name`:"Mohammed", `shoe_size`:17})
 create (_34224:`Player`:`Rookie` {`age`:23, `birthplace`:"Lyon, France", `first_name`:"Erik", `height_formatted`:"6'10\"", `last_name`:"Murphy", `shoe_size`:14})
 create (_34225:`Player`:`AllStar` {`age`:28, `birthplace`:"New York, New York, USA", `first_name`:"Joakim", `height_formatted`:"6'11\"", `last_name`:"Noah", `shoe_size`:15})
 create (_34226:`Player` {`age`:25, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Derrick", `height_formatted`:"6'3\"", `last_name`:"Rose", `shoe_size`:12.5})
 create (_34227:`Player`:`Rookie` {`age`:22, `birthplace`:"Los Angeles, California, USA", `first_name`:"Tony", `height_formatted`:"6'7\"", `last_name`:"Snell", `shoe_size`:12.5})
 create (_34228:`Player` {`age`:20, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Marquis", `height_formatted`:"6'2\"", `last_name`:"Teague", `shoe_size`:12})
 create (_34229:`Team` {`abbreviation`:"CLE", `city`:"Cleveland", `full_name`:"Cleveland Cavaliers"})
 create (_34230:`Player`:`Rookie` {`age`:20, `birthplace`:"Toronto, Canada", `first_name`:"Anthony", `height_formatted`:"6'8\"", `last_name`:"Bennett", `shoe_size`:15.5})
 create (_34231:`Player` {`age`:26, `birthplace`:"Plainsboro, New Jersey, USA", `first_name`:"Andrew", `height_formatted`:"7'0\"", `last_name`:"Bynum", `shoe_size`:18})
 create (_34232:`Player` {`age`:25, `birthplace`:"Plainfield, New Jersey, USA", `first_name`:"Earl", `height_formatted`:"6'9\"", `last_name`:"Clark", `shoe_size`:14})
 create (_34233:`Player` {`age`:23, `birthplace`:"Maryborough, Australia", `first_name`:"Matthew", `height_formatted`:"6'4\"", `last_name`:"Dellavedova", `shoe_size`:12.5})
 create (_34234:`Player`:`Rookie` {`age`:23, `birthplace`:"Las Vegas, Nevada, USA", `first_name`:"Carrick", `height_formatted`:"6'6\"", `last_name`:"Felix", `shoe_size`:14.5})
 create (_34235:`Player` {`age`:26, `birthplace`:"Riviera Beach, Florida, USA", `first_name`:"Alonzo", `height_formatted`:"6'6\"", `last_name`:"Gee", `shoe_size`:14})
 create (_34236:`Player`:`AllStar` {`age`:21, `birthplace`:"West Orange, New Jersey, USA", `first_name`:"Kyrie", `height_formatted`:"6'3\"", `last_name`:"Irving", `shoe_size`:12.5})
 create (_34237:`Player` {`age`:30, `birthplace`:"Fort Washington, Maryland, USA", `first_name`:"Jarrett", `height_formatted`:"6'3\"", `last_name`:"Jack", `shoe_size`:12})
 create (_34238:`Player` {`age`:20, `birthplace`:"Saint Petersburg, Russian Federation", `first_name`:"Sergey", `height_formatted`:"6'7\"", `last_name`:"Karasev", `shoe_size`:14.5})
 create (_34239:`Player` {`age`:26, `birthplace`:"Dallas, Texas, USA", `first_name`:"C.J.", `height_formatted`:"6'6\"", `last_name`:"Miles", `shoe_size`:14})
 create (_34240:`Player` {`age`:23, `birthplace`:"Baltimore, Maryland, USA", `first_name`:"Henry", `height_formatted`:"6'10\"", `last_name`:"Sims", `shoe_size`:15.5})
 create (_34241:`Player` {`age`:22, `birthplace`:"Brampton, Canada", `first_name`:"Tristan", `height_formatted`:"6'8\"", `last_name`:"Thompson", `shoe_size`:15})
 create (_34242:`Player` {`age`:31, `birthplace`:"Santa Teresa, Brazil", `first_name`:"Anderson", `height_formatted`:"6'10\"", `last_name`:"Varejao", `shoe_size`:16})
 create (_34243:`Player` {`age`:22, `birthplace`:"Philadelphia, Pennsylvania, USA", `first_name`:"Dion", `height_formatted`:"6'4\"", `last_name`:"Waiters", `shoe_size`:13})
create (_34244:`Player` {`age`:23, `birthplace`:"Washington, Indiana, USA", `first_name`:"Tyler", `height_formatted`:"7'0\"", `last_name`:"Zeller", `shoe_size`:18})
 create (_34245:`Team` {`abbreviation`:"DAL", `city`:"Dallas", `full_name`:"Dallas Mavericks"})
 create (_34246:`Player` {`age`:24, `birthplace`:"Pittsburgh, Pennsylvania, USA", `first_name`:"DeJuan", `height_formatted`:"6'7\"", `last_name`:"Blair", `shoe_size`:14})
 create (_34247:`Player` {`age`:32, `birthplace`:"Villanueva de la Serena, Spain", `first_name`:"Jose", `height_formatted`:"6'3\"", `last_name`:"Calderon", `shoe_size`:13})
 create (_34248:`Player` {`age`:36, `birthplace`:"Daytona Beach, Florida, USA", `first_name`:"Vince", `height_formatted`:"6'6\"", `last_name`:"Carter", `shoe_size`:16.5})
 create (_34249:`Player` {`age`:23, `birthplace`:"Villa Rica, Georgia, USA", `first_name`:"Jae", `height_formatted`:"6'6\"", `last_name`:"Crowder", `shoe_size`:15})
 create (_34250:`Player` {`age`:32, `birthplace`:"Port-au-Prince, Haiti", `first_name`:"Samuel", `height_formatted`:"6'11\"", `last_name`:"Dalembert", `shoe_size`:16})
 create (_34251:`Player` {`age`:26, `birthplace`:"Wynnewood, Pennsylvania, USA", `first_name`:"Wayne", `height_formatted`:"6'4\"", `last_name`:"Ellington", `shoe_size`:13})
 create (_34252:`Player` {`age`:28, `birthplace`:"Jackson, Mississippi, USA", `first_name`:"Monta", `height_formatted`:"6'3\"", `last_name`:"Ellis", `shoe_size`:13})
 create (_34253:`Player` {`age`:30, `birthplace`:"Milwaukee, Wisconsin, USA", `first_name`:"Devin", `height_formatted`:"6'3\"", `last_name`:"Harris", `shoe_size`:12.5})
 create (_34254:`Player` {`age`:28, `birthplace`:"Savannah, Georgia, USA", `first_name`:"Bernard", `height_formatted`:"6'10\"", `last_name`:"James", `shoe_size`:16})
 create (_34255:`Player`:`Rookie` {`age`:21, `birthplace`:"Cincinnati, Ohio, USA", `first_name`:"DeShane", `height_formatted`:"5'11\"", `last_name`:"Larkin", `shoe_size`:11.5})
 create (_34256:`Player`:`Rookie` {`age`:21, `birthplace`:"Providence, Rhode Island, USA", `first_name`:"Ricardo", `height_formatted`:"6'7\"", `last_name`:"Ledo", `shoe_size`:13.5})
 create (_34257:`Player` {`age`:35, `birthplace`:"Waukegan, Illinois, USA", `first_name`:"Shawn", `height_formatted`:"6'7\"", `last_name`:"Marion", `shoe_size`:14})
 create (_34258:`Player` {`age`:25, `birthplace`:"Hasharon, Israel", `first_name`:"Gal", `height_formatted`:"6'3\"", `last_name`:"Mekel", `shoe_size`:14.5})
 create (_34259:`Player` {`age`:35, `birthplace`:"Würzburg, Germany", `first_name`:"Dirk", `height_formatted`:"6'11\"", `last_name`:"Nowitzki", `shoe_size`:16})
 create (_34260:`Player` {`age`:26, `birthplace`:"Nashville, Tennessee, USA", `first_name`:"Brandan", `height_formatted`:"6'9\"", `last_name`:"Wright", `shoe_size`:15})
 create (_34261:`Team` {`abbreviation`:"DEN", `city`:"Denver", `full_name`:"Denver Nuggets"})
 create (_34262:`Player` {`age`:25, `birthplace`:"Dallas, Texas, USA", `first_name`:"Darrell", `height_formatted`:"6'9\"", `last_name`:"Arthur", `shoe_size`:14.5})
 create (_34263:`Player` {`age`:26, `birthplace`:"Benton Harbor, Michigan, USA", `first_name`:"Wilson", `height_formatted`:"6'8\"", `last_name`:"Chandler",`shoe_size`:15.5})
 create (_34264:`Player` {`age`:24, `birthplace`:"Newark, New Jersey, USA", `first_name`:"Kenneth", `height_formatted`:"6'8\"", `last_name`:"Faried", `shoe_size`:16})
 create (_34265:`Player` {`age`:21, `birthplace`:"Saint-Maurice, France", `first_name`:"Evan", `height_formatted`:"6'7\"", `last_name`:"Fournier",`shoe_size`:13.5})
 create (_34266:`Player` {`age`:30, `birthplace`:"Newark, New Jersey, USA", `first_name`:"Randy", `height_formatted`:"6'4\"", `last_name`:"Foye", `shoe_size`:13})
 create (_34267:`Player` {`age`:25, `birthplace`:"Sant'Angelo Lodigiano, Italy", `first_name`:"Danilo", `height_formatted`:"6'8\"", `last_name`:"Gallinari", `shoe_size`:16})
 create (_34268:`Player` {`age`:23, `birthplace`:"Los Angeles, California, USA", `first_name`:"Jordan", `height_formatted`:"6'7\"", `last_name`:"Hamilton", `shoe_size`:14})
 create (_34269:`Player` {`age`:25, `birthplace`:"Atlanta, Georgia, USA", `first_name`:"J.J.", `height_formatted`:"6'9\"", `last_name`:"Hickson", `shoe_size`:14})
 create (_34270:`Player` {`age`:26, `birthplace`:"Clinton, Maryland, USA", `first_name`:"Ty", `height_formatted`:"5'11\"", `last_name`:"Lawson", `shoe_size`:12})
 create (_34271:`Player` {`age`:25, `birthplace`:"Flint, Michigan, USA", `first_name`:"JaVale", `height_formatted`:"7'0\"", `last_name`:"McGee", `shoe_size`:20})
 create (_34272:`Player` {`age`:37, `birthplace`:"Los Angeles, California, USA", `first_name`:"Andre", `height_formatted`:"6'2\"", `last_name`:"Miller", `shoe_size`:13.5})
 create (_34273:`Player` {`age`:21, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Quincy", `height_formatted`:"6'10\"", `last_name`:"Miller",`shoe_size`:16.5})
 create (_34274:`Player` {`age`:27, `birthplace`:"Saint Petersburg, Russian Federation", `first_name`:"Timofey", `height_formatted`:"7'1\"", `last_name`:"Mozgov", `shoe_size`:18})
 create (_34275:`Player` {`age`:24, `birthplace`:"Wurzbach, Germany", `first_name`:"Anthony", `height_formatted`:"6'10\"", `last_name`:"Randolph", `shoe_size`:14})
 create (_34276:`Player` {`age`:29, `birthplace`:"Seattle, Washington, USA", `first_name`:"Nate", `height_formatted`:"5'9\"", `last_name`:"Robinson", `shoe_size`:10.5})
 create (_34277:`Team` {`abbreviation`:"DET", `city`:"Auburn Hills", `full_name`:"Detroit Pistons"})
 create (_34278:`Player` {`age`:37, `birthplace`:"Denver, Colorado, USA", `first_name`:"Chauncey", `height_formatted`:"6'3\"", `last_name`:"Billups", `shoe_size`:14})
 create (_34279:`Player` {`age`:30, `birthplace`:"Chicago, Illinois, USA", `first_name`:"William", `height_formatted`:"6'0\"", `last_name`:"Bynum", `shoe_size`:12})
 create (_34280:`Player`:`Rookie` {`age`:20, `birthplace`:"Thomaston, Georgia, USA", `first_name`:"Kentavious", `height_formatted`:"6'6\"", `last_name`:"Caldwell-Pope", `shoe_size`:12})
 create (_34281:`Player` {`age`:26, `birthplace`:"Montebelluna, Italy", `first_name`:"Luigi", `height_formatted`:"6'8\"", `last_name`:"Datome", `shoe_size`:17.5})
 create (_34282:`Player` {`age`:20, `birthplace`:"Middletown, Connecticut, USA", `first_name`:"Andre", `height_formatted`:"6'11\"", `last_name`:"Drummond", `shoe_size`:18})
 create (_34283:`Player` {`age`:24, `birthplace`:"Saint Charles, Missouri, USA", `first_name`:"Josh", `height_formatted`:"6'10\"", `last_name`:"Harrellson", `shoe_size`:16.5})
 create (_34284:`Player` {`age`:24, `birthplace`:"Los Angeles, California, USA", `first_name`:"Brandon", `height_formatted`:"6'1\"", `last_name`:"Jennings", `shoe_size`:11.5})
 create (_34285:`Player` {`age`:26, `birthplace`:"Kinna, Sweden", `first_name`:"Jonas", `height_formatted`:"6'9\"", `last_name`:"Jerebko", `shoe_size`:15})
 create (_34286:`Player`:`Rookie` {`age`:21, `birthplace`:"Milwaukee, Wisconsin, USA", `first_name`:"Tony", `height_formatted`:"6'9\"", `last_name`:"Mitchell", `shoe_size`:17})
 create (_34287:`Player` {`age`:23, `birthplace`:"Harvey, Louisiana, USA", `first_name`:"Greg", `height_formatted`:"6'11\"", `last_name`:"Monroe", `shoe_size`:14})
 create (_34288:`Player` {`age`:25, `birthplace`:"Medford, Oregon, USA", `first_name`:"Kyle", `height_formatted`:"6'8\"", `last_name`:"Singler", `shoe_size`:14.5})
 create (_34289:`Player`:`Rookie` {`age`:23, `birthplace`:"Seattle, Washington, USA", `first_name`:"Peyton", `height_formatted`:"6'0\"", `last_name`:"Siva", `shoe_size`:11.5})
 create (_34290:`Player` {`age`:28, `birthplace`:"College Park, Georgia, USA", `first_name`:"Josh", `height_formatted`:"6'9\"", `last_name`:"Smith", `shoe_size`:13.5})
 create (_34291:`Player` {`age`:27, `birthplace`:"Seattle, Washington, USA", `first_name`:"Rodney", `height_formatted`:"6'5\"", `last_name`:"Stuckey", `shoe_size`:13})
 create (_34292:`Player` {`age`:29, `birthplace`:"Queens, New York, USA", `first_name`:"Charlie", `height_formatted`:"6'11\"", `last_name`:"Villanueva", `shoe_size`:13})
 create (_34293:`Team` {`abbreviation`:"GS", `city`:"Oakland", `full_name`:"Golden State Warriors"})
 create (_34294:`Player` {`age`:29, `birthplace`:"Peekskill, New York, USA", `first_name`:"Hilton", `height_formatted`:"6'11\"", `last_name`:"Armstrong", `shoe_size`:16.5})
 create (_34295:`Player` {`age`:21, `birthplace`:"Ames, Iowa, USA", `first_name`:"Harrison", `height_formatted`:"6'8\"", `last_name`:"Barnes", `shoe_size`:14})
 create (_34296:`Player` {`age`:24, `birthplace`:"Kelford, North Carolina, USA", `first_name`:"Kent", `height_formatted`:"6'5\"", `last_name`:"Bazemore", `shoe_size`:13})
 create (_34297:`Player` {`age`:29, `birthplace`:"Melbourne, Australia", `first_name`:"Andrew", `height_formatted`:"7'0\"", `last_name`:"Bogut", `shoe_size`:18})
 create (_34298:`Player` {`age`:25, `birthplace`:"Akron, Ohio, USA", `first_name`:"Stephen", `height_formatted`:"6'3\"", `last_name`:"Curry", `shoe_size`:13})
 create (_34299:`Player` {`age`:27, `birthplace`:"Jonesboro, Georgia, USA", `first_name`:"Toney", `height_formatted`:"6'2\"", `last_name`:"Douglas", `shoe_size`:13})
 create (_34300:`Player` {`age`:24, `birthplace`:"Benin-City, Nigeria", `first_name`:"Ifeanyi", `height_formatted`:"6'11\"", `last_name`:"Ezeli", `shoe_size`:18})
 create (_34301:`Player` {`age`:23, `birthplace`:"Saginaw, Michigan, USA", `first_name`:"Draymond", `height_formatted`:"6'7\"", `last_name`:"Green", `shoe_size`:15})
 create (_34302:`Player` {`age`:29, `birthplace`:"Springfield, Illinois, USA", `first_name`:"Andre", `height_formatted`:"6'6\"", `last_name`:"Iguodala", `shoe_size`:17})
 create (_34303:`Player` {`age`:23, `birthplace`:"Doboj, Bosnia and Herzegovina", `first_name`:"Ognjen", `height_formatted`:"7'1\"", `last_name`:"Kuzmifa", `shoe_size`:16.5})
 create (_34304:`Player`:`AllStar` {`age`:30, `birthplace`:"Saint Louis, Missouri, USA", `first_name`:"David", `height_formatted`:"6'9\"", `last_name`:"Lee", `shoe_size`:15})
 create (_34305:`Player`:`Rookie` {`age`:22, `birthplace`:"Nova Varo≈°, Serbia and Montenegro", `first_name`:"Nemanja", `height_formatted`:"6'3\"", `last_name`:"Nedović", `shoe_size`:14.5})
 create (_34306:`Player` {`age`:35, `birthplace`:"Columbia, South Carolina, USA", `first_name`:"Jermaine", `height_formatted`:"6'11\"", `last_name`:"O'Neal", `shoe_size`:15})
 create (_34307:`Player` {`age`:26, `birthplace`:"Saint Petersburg, Florida, USA", `first_name`:"Marreese", `height_formatted`:"6'10\"", `last_name`:"Speights", `shoe_size`:16.5})
 create (_34308:`Player` {`age`:23, `birthplace`:"Los Angeles, California, USA", `first_name`:"Klay", `height_formatted`:"6'7\"", `last_name`:"Thompson", `shoe_size`:15})
 create (_34309:`Team` {`abbreviation`:"HOU", `city`:"Houston", `full_name`:"Houston Rockets"})
 create (_34310:`Player` {`age`:27, `birthplace`:"Bursa, Turkey", `first_name`:"Omer", `height_formatted`:"7'0\"", `last_name`:"Asik", `shoe_size`:17})
 create (_34311:`Player` {`age`:25, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Patrick", `height_formatted`:"6'1\"", `last_name`:"Beverley", `shoe_size`:13})
 create (_34312:`Player` {`age`:28, `birthplace`:"Portland, Oregon, USA", `first_name`:"Ronnie", `height_formatted`:"6'7\"", `last_name`:"Brewer", `shoe_size`:14})
 create (_34313:`Player` {`age`:28, `birthplace`:"Seattle, Washington, USA", `first_name`:"Aaron", `height_formatted`:"6'0\"", `last_name`:"Brooks", `shoe_size`:12})
 create (_34314:`Player`:`Rookie` {`age`:22, `birthplace`:"Biloxi, Mississippi, USA", `first_name`:"Isaiah", `height_formatted`:"6'1\"", `last_name`:"Canaan", `shoe_size`:9.5})
 create (_34315:`Player` {`age`:25, `birthplace`:"Yavne, Israel", `first_name`:"Omri", `height_formatted`:"6'7\"", `last_name`:"Casspi", `shoe_size`:13})
 create (_34316:`Player` {`age`:23, `birthplace`:"Bellwood, Illinois, USA", `first_name`:"Robert", `height_formatted`:"6'9\"", `last_name`:"Covington", `shoe_size`:14.5})
 create (_34317:`Player` {`age`:31, `birthplace`:"Santo Domingo, Dominican Republic", `first_name`:"Francisco", `height_formatted`:"6'7\"", `last_name`:"Garcia", `shoe_size`:15})
 create (_34318:`Player`:`AllStar` {`age`:24, `birthplace`:"Los Angeles, California, USA", `first_name`:"James", `height_formatted`:"6'5\"", `last_name`:"Harden", `shoe_size`:14})
 create (_34319:`Player`:`AllStar` {`age`:28, `birthplace`:"Atlanta, Georgia, USA", `first_name`:"Dwight", `height_formatted`:"6'11\"", `last_name`:"Howard", `shoe_size`:18})
 create (_34320:`Player` {`age`:21, `birthplace`:"Portland, Oregon, USA", `first_name`:"Terrence", `height_formatted`:"6'9\"", `last_name`:"Jones", `shoe_size`:15})
 create (_34321:`Player` {`age`:25, `birthplace`:"Palo Alto, California, USA", `first_name`:"Jeremy", `height_formatted`:"6'3\"", `last_name`:"Lin", `shoe_size`:12})
 create (_34322:`Player` {`age`:23, `birthplace`:"Kaunas, Lithuania", `first_name`:"Donatas", `height_formatted`:"7'0\"", `last_name`:"Motiejunas", `shoe_size`:17})
 create (_34323:`Player` {`age`:25, `birthplace`:"Casselberry, Florida, USA", `first_name`:"Chandler", `height_formatted`:"6'9\"", `last_name`:"Parsons", `shoe_size`:15})
 create (_34324:`Player` {`age`:22, `birthplace`:"Fresno, California, USA", `first_name`:"Greg", `height_formatted`:"6'10\"", `last_name`:"Smith", `shoe_size`:17})
 create (_34325:`Team` {`abbreviation`:"IND", `city`:"Indianapolis", `full_name`:"Indiana Pacers"})
 create (_34326:`Player` {`age`:34, `birthplace`:"Philadelphia, Pennsylvania, USA", `first_name`:"Rasual", `height_formatted`:"6'7\"", `last_name`:"Butler", `shoe_size`:14.5})
 create (_34327:`Player` {`age`:29, `birthplace`:"Richmond, Virginia, USA", `first_name`:"Chris", `height_formatted`:"6'8\"", `last_name`:"Copeland", `shoe_size`:14})
 create (_34328:`Player`:`AllStar` {`age`:33, `birthplace`:"Palmdale, California, USA", `first_name`:"Paul", `height_formatted`:"6'8\"", `last_name`:"George", `shoe_size`:13})
 create (_34329:`Player` {`age`:30, `birthplace`:"New Orleans, Louisiana, USA", `first_name`:"Danny", `height_formatted`:"6'8\"", `last_name`:"Granger", `shoe_size`:15.5})
 create (_34330:`Player` {`age`:27, `birthplace`:"Queens, New York, USA", `first_name`:"Roy", `height_formatted`:"7'2\"", `last_name`:"Hibbert", `shoe_size`:17})
 create (_34331:`Player` {`age`:27, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"George", `height_formatted`:"6'2\"", `last_name`:"Hill", `shoe_size`:13.5})
 create (_34332:`Player`:`Rookie` {`age`:22, `birthplace`:"Los Angeles, California, USA", `first_name`:"Solomon", `height_formatted`:"6'7\"", `last_name`:"Hill", `shoe_size`:16})
 create (_34333:`Player` {`age`:24, `birthplace`:"Seaside, California, USA", `first_name`:"Orlando", `height_formatted`:"6'5\"", `last_name`:"Johnson", `shoe_size`:16})
 create (_34334:`Player` {`age`:27, `birthplace`:"Rouen, France", `first_name`:"Ian", `height_formatted`:"6'10\"", `last_name`:"Mahinmi", `shoe_size`:16})
 create (_34335:`Player` {`age`:33, `birthplace`:"Buenos Aires, Argentina", `first_name`:"Luis", `height_formatted`:"6'9\"", `last_name`:"Scola", `shoe_size`:17})
 create (_34336:`Player` {`age`:25, `birthplace`:"Shreveport, Louisiana, USA", `first_name`:"Donald", `height_formatted`:"6'3\"", `last_name`:"Sloan", `shoe_size`:12.5})
 create (_34337:`Player` {`age`:23, `birthplace`:"Brooklyn, New York, USA", `first_name`:"Lance", `height_formatted`:"6'5\"", `last_name`:"Stephenson", `shoe_size`:14})
 create (_34338:`Player` {`age`:29, `birthplace`:"Las Vegas, Nevada, USA", `first_name`:"Charles", `height_formatted`:"6'2\"", `last_name`:"Watson", `shoe_size`:10.5})
 create (_34339:`Player` {`age`:33, `birthplace`:"Teaneck, New Jersey, USA", `first_name`:"David", `height_formatted`:"6'9\"", `last_name`:"West", `shoe_size`:17})
 create (_34340:`Team` {`abbreviation`:"LAC", `city`:"Los Angeles", `full_name`:"Los Angeles Clippers"})
 create (_34341:`Player` {`age`:33, `birthplace`:"Citrus Heights, California, USA", `first_name`:"Matt", `height_formatted`:"6'7\"", `last_name`:"Barnes", `shoe_size`:15})
 create (_34342:`Player`:`Rookie` {`age`:22, `birthplace`:"Kinston, North Carolina, USA", `first_name`:"Reginald", `height_formatted`:"6'7\"", `last_name`:"Bullock", `shoe_size`:13.5})
create (_34343:`Player` {`age`:26, `birthplace`:"Rancho Cucamonga, California, USA", `first_name`:"Darren", `height_formatted`:"6'0\"", `last_name`:"Collison", `shoe_size`:11.5})
 create (_34344:`Player` {`age`:33, `birthplace`:"Seattle, Washington, USA", `first_name`:"Jamal", `height_formatted`:"6'6\"", `last_name`:"Crawford", `shoe_size`:14})
 create (_34345:`Player` {`age`:28, `birthplace`:"San Diego, California, USA", `first_name`:"Jared", `height_formatted`:"6'7\"", `last_name`:"Dudley", `shoe_size`:16})
 create (_34346:`Player` {`age`:32, `birthplace`:"Detroit, Michigan, USA", `first_name`:"Willie", `height_formatted`:"6'3\"", `last_name`:"Green", `shoe_size`:13.5})
 create (_34347:`Player`:`AllStar` {`age`:24, `birthplace`:"Oklahoma City, Oklahoma, USA", `first_name`:"Blake", `height_formatted`:"6'10\"", `last_name`:"Griffin", `shoe_size`:17})
 create (_34348:`Player` {`age`:29, `birthplace`:"Pasadena, California, USA", `first_name`:"Ryan", `height_formatted`:"7'0\"", `last_name`:"Hollins", `shoe_size`:17})
 create (_34349:`Player` {`age`:35, `birthplace`:"Houston, Texas, USA", `first_name`:"Stephen", `height_formatted`:"6'8\"", `last_name`:"Jackson", `shoe_size`:14})
 create (_34350:`Player` {`age`:37, `birthplace`:"Shreveport, Louisiana, USA", `first_name`:"Antawn", `height_formatted`:"6'8\"", `last_name`:"Jamison", `shoe_size`:16})
 create (_34351:`Player` {`age`:25, `birthplace`:"Houston, Texas, USA", `first_name`:"DeAndre", `height_formatted`:"7'0\"", `last_name`:"Jordan", `shoe_size`:17})
 create (_34352:`Player` {`age`:24, `birthplace`:"Canal Winchester, Ohio, USA", `first_name`:"Byron", `height_formatted`:"7'0\"", `last_name`:"Mullens", `shoe_size`:16})
 create (_34353:`Player`:`AllStar` {`age`:28, `birthplace`:"Winston-Salem, North Carolina, USA", `first_name`:"Chris", `height_formatted`:"6'0\"", `last_name`:"Paul", `shoe_size`:12.5})
 create (_34354:`Player` {`age`:29, `birthplace`:"Cookeville, Tennessee, USA", `first_name`:"J.J.", `height_formatted`:"6'4\"", `last_name`:"Redick", `shoe_size`:13.5})
 create (_34355:`Player` {`age`:22, `birthplace`:"Philadelphia, Pennsylvania, USA", `first_name`:"Maalik", `height_formatted`:"6'1\"", `last_name`:"Wayns", `shoe_size`:12.5})
 create (_34356:`Team` {`abbreviation`:"LAL", `city`:"Los Angeles", `full_name`:"Los Angeles Lakers"})
 create (_34357:`Player` {`age`:33, `birthplace`:"Hollywood, Florida, USA", `first_name`:"Steve", `height_formatted`:"6'3\"", `last_name`:"Blake", `shoe_size`:13})
 create (_34358:`Player`:`AllStar` {`age`:35, `birthplace`:"Philadelphia, Pennsylvania, USA", `first_name`:"Kobe", `height_formatted`:"6'6\"", `last_name`:"Bryant", `shoe_size`:14})
 create (_34359:`Player` {`age`:27, `birthplace`:"Los Angeles, California, USA", `first_name`:"Jordan", `height_formatted`:"6'2\"", `last_name`:"Farmar", `shoe_size`:11})
 create (_34360:`Player` {`age`:33, `birthplace`:"Barcelona, Spain", `first_name`:"Pau", `height_formatted`:"7'0\"", `last_name`:"Gasol", `shoe_size`:17})
 create (_34361:`Player` {`age`:22, `birthplace`:"Ghent, Belgium", `first_name`:"Xavier", `height_formatted`:"6'6\"", `last_name`:"Henry", `shoe_size`:16})
 create (_34362:`Player` {`age`:26, `birthplace`:"Atlanta, Georgia, USA", `first_name`:"Jordan", `height_formatted`:"6'10\"", `last_name`:"Hill", `shoe_size`:15})
 create (_34363:`Player` {`age`:26, `birthplace`:"Corsicana, Texas, USA", `first_name`:"Wesley", `height_formatted`:"6'7\"", `last_name`:"Johnson", `shoe_size`:14.5})
 create (_34364:`Player` {`age`:31, `birthplace`:"Wyoming, Michigan, USA", `first_name`:"Chris", `height_formatted`:"7'0\"", `last_name`:"Kaman", `shoe_size`:17})
 create (_34365:`Player`:`Rookie` {`age`:22, `birthplace`:"Carmel, New York, USA", `first_name`:"Ryan", `height_formatted`:"6'11\"", `last_name`:"Kelly", `shoe_size`:12})
 create (_34366:`Player` {`age`:26, `birthplace`:"Norcross, Georgia, USA", `first_name`:"Jodie", `height_formatted`:"6'4\"", `last_name`:"Meeks", `shoe_size`:13})
 create (_34367:`Player` {`age`:39, `birthplace`:"Johannesburg, South Africa", `first_name`:"Steve", `height_formatted`:"6'3\"", `last_name`:"Nash", `shoe_size`:11.5})
 create (_34368:`Player` {`age`:24, `birthplace`:"North Vancouver, Canada", `first_name`:"Robert", `height_formatted`:"7'0\"", `last_name`:"Sacre", `shoe_size`:16})
 create (_34369:`Player` {`age`:27, `birthplace`:"Memphis, Tennessee, USA", `first_name`:"Shawne", `height_formatted`:"6'9\"", `last_name`:"Williams", `shoe_size`:15.5})
 create (_34370:`Player` {`age`:28, `birthplace`:"Reseda, California, USA", `first_name`:"Nick", `height_formatted`:"6'7\"", `last_name`:"Young", `shoe_size`:13})
 create (_34371:`Team` {`abbreviation`:"MEM", `city`:"Memphis", `full_name`:"Memphis Grizzlies"})
 create (_34372:`Player` {`age`:31, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Tony", `height_formatted`:"6'4\"", `last_name`:"Allen", `shoe_size`:13})
 create (_34373:`Player` {`age`:25, `birthplace`:"Phoenix, Arizona, USA", `first_name`:"Jerryd", `height_formatted`:"6'3\"", `last_name`:"Bayless", `shoe_size`:13.5})
 create (_34374:`Player` {`age`:24, `birthplace`:"Casselberry, Florida, USA", `first_name`:"Nick", `height_formatted`:"6'6\"", `last_name`:"Calathes", `shoe_size`:14})
 create (_34375:`Player` {`age`:26, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Mike", `height_formatted`:"6'1\"", `last_name`:"Conley", `shoe_size`:12})
 create (_34376:`Player` {`age`:24, `birthplace`:"Washington, District of Columbia, USA", `first_name`:"Ed", `height_formatted`:"6'10\"", `last_name`:"Davis", `shoe_size`:14.5})
 create (_34377:`Player`:`Rookie` {`age`:22, `birthplace`:"Moreno Valley, California, USA", `first_name`:"Jamaal", `height_formatted`:"6'5\"", `last_name`:"Franklin", `shoe_size`:15})
 create (_34378:`Player` {`age`:28, `birthplace`:"Barcelona, Spain", `first_name`:"Marc", `height_formatted`:"7'0\"", `last_name`:"Gasol", `shoe_size`:17})
 create (_34379:`Player` {`age`:24, `birthplace`:"Canton, Ohio, USA", `first_name`:"Konstantine", `height_formatted`:"7'0\"", `last_name`:"Koufos", `shoe_size`:19.5})
 create (_34380:`Player` {`age`:24, `birthplace`:"Long Lake, Minnesota, USA", `first_name`:"Jon", `height_formatted`:"6'10\"", `last_name`:"Leuer", `shoe_size`:16})
 create (_34381:`Player` {`age`:33, `birthplace`:"Mitchell, South Dakota, USA", `first_name`:"Mike", `height_formatted`:"6'8\"", `last_name`:"Miller", `shoe_size`:14})
 create (_34382:`Player` {`age`:25, `birthplace`:"Fresno, California, USA", `first_name`:"Quincy", `height_formatted`:"6'6\"", `last_name`:"Pondexter", `shoe_size`:15})
 create (_34383:`Player` {`age`:33, `birthplace`:"Compton, California, USA", `first_name`:"Tayshaun", `height_formatted`:"6'9\"", `last_name`:"Prince", `shoe_size`:15})
 create (_34384:`Player`:`AllStar` {`age`:32, `birthplace`:"Marion, Indiana, USA", `first_name`:"Zach", `height_formatted`:"6'9\"", `last_name`:"Randolph", `shoe_size`:15.5})
 create (_34385:`Team` {`abbreviation`:"MIA", `city`:"Miami", `full_name`:"Miami Heat"})
 create (_34386:`Player` {`age`:38, `birthplace`:"Merced, California, USA", `first_name`:"Ray", `height_formatted`:"6'5\"", `last_name`:"Allen", `shoe_size`:15})
 create (_34387:`Player` {`age`:35, `birthplace`:"Long Beach, California, USA", `first_name`:"Chris", `height_formatted`:"6'10\"", `last_name`:"Andersen", `shoe_size`:15.5})
 create (_34388:`Player` {`age`:31, `birthplace`:"Montreal, Canada", `first_name`:"Joel", `height_formatted`:"6'9\"", `last_name`:"Anthony", `shoe_size`:17})
 create (_34389:`Player` {`age`:35, `birthplace`:"Birmingham, Michigan, USA", `first_name`:"Shane", `height_formatted`:"6'8\"", `last_name`:"Battier", `shoe_size`:15})
 create (_34390:`Player` {`age`:24, `birthplace`:"Frederick, Maryland, USA", `first_name`:"Michael", `height_formatted`:"6'10\"", `last_name`:"Beasley",`shoe_size`:15.5})
 create (_34391:`Player`:`AllStar` {`age`:29, `birthplace`:"Dallas, Texas, USA", `first_name`:"Chris", `height_formatted`:"6'10\"", `last_name`:"Bosh", `shoe_size`:14.5})
 create (_34392:`Player` {`age`:27, `birthplace`:"Anchorage, Alaska, USA", `first_name`:"Mario", `height_formatted`:"6'1\"", `last_name`:"Chalmers", `shoe_size`:13})
 create (_34393:`Player` {`age`:25, `birthplace`:"Dayton, Ohio, USA", `first_name`:"Norris", `height_formatted`:"6'2\"", `last_name`:"Cole", `shoe_size`:12})
 create (_34394:`Player` {`age`:33, `birthplace`:"Miami, Florida, USA", `first_name`:"Udonis", `height_formatted`:"6'8\"", `last_name`:"Haslem", `shoe_size`:18})
 create (_34395:`Player`:`AllStar` {`age`:28, `birthplace`:"Akron, Ohio, USA", `first_name`:"LeBron", `height_formatted`:"6'8\"", `last_name`:"James", `shoe_size`:16})
 create (_34396:`Player` {`age`:33, `birthplace`:"Miami, Florida, USA", `first_name`:"James", `height_formatted`:"6'8\"", `last_name`:"Jones", `shoe_size`:18})
 create (_34397:`Player` {`age`:34, `birthplace`:"Pineville, Louisiana, USA", `first_name`:"Rashard", `height_formatted`:"6'10\"", `last_name`:"Lewis", `shoe_size`:14})
 create (_34398:`Player` {`age`:33, `birthplace`:"Washington, District of Columbia, USA", `first_name`:"Roger", `height_formatted`:"6'5\"", `last_name`:"Mason", `shoe_size`:14})
 create (_34399:`Player` {`age`:25, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Greg", `height_formatted`:"7'0\"", `last_name`:"Oden", `shoe_size`:20})
 create (_34400:`Player`:`AllStar` {`age`:31, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Dwyane", `height_formatted`:"6'4\"", `last_name`:"Wade", `shoe_size`:15.5})
 create (_34401:`Team` {`abbreviation`:"MIL", `city`:"Milwaukee", `full_name`:"Milwaukee Bucks"})
 create (_34402:`Player`:`Rookie` {`age`:18, `birthplace`:"Athens, Greece", `first_name`:"Giannis", `height_formatted`:"6'10\"", `last_name`:"Antetokounmpo", `shoe_size`:15.5})
 create (_34403:`Player` {`age`:33, `birthplace`:"Racine, Wisconsin, USA", `first_name`:"Caron", `height_formatted`:"6'7\"", `last_name`:"Butler", `shoe_size`:14})
 create (_34404:`Player` {`age`:31, `birthplace`:"Santa Fe, Argentina", `first_name`:"Carlos", `height_formatted`:"6'6\"", `last_name`:"Delfino", `shoe_size`:16})
 create (_34405:`Player` {`age`:22, `birthplace`:"Tampa, Florida, USA", `first_name`:"John", `height_formatted`:"6'11\"", `last_name`:"Henson", `shoe_size`:18})
 create (_34406:`Player` {`age`:26, `birthplace`:"Eskişehir, Turkey", `first_name`:"Ersan", `height_formatted`:"6'9\"", `last_name`:"Ilyasova", `shoe_size`:16})
 create (_34407:`Player` {`age`:22, `birthplace`:"East Orange, New Jersey, USA", `first_name`:"Brandon", `height_formatted`:"6'3\"", `last_name`:"Knight", `shoe_size`:12.5})
 create (_34408:`Player` {`age`:26, `birthplace`:"Huntington, West Virginia, USA", `first_name`:"O.J.", `height_formatted`:"6'5\"", `last_name`:"Mayo", `shoe_size`:14})
 create (_34409:`Player` {`age`:22, `birthplace`:"North Charleston, South Carolina, USA", `first_name`:"Khris", `height_formatted`:"6'7\"", `last_name`:"Middleton", `shoe_size`:16})
 create (_34410:`Player` {`age`:29, `birthplace`:"Baltimore, Maryland, USA", `first_name`:"Gary", `height_formatted`:"6'4\"", `last_name`:"Neal", `shoe_size`:13})
 create (_34411:`Player` {`age`:29, `birthplace`:"Tbilisi, Georgia", `first_name`:"Zaza", `height_formatted`:"6'11\"", `last_name`:"Pachulia", `shoe_size`:17})
 create (_34412:`Player` {`age`:25, `birthplace`:"Belgrade, Serbia and Montenegro", `first_name`:"Miroslav", `height_formatted`:"7'0\"", `last_name`:"Raduljica", `shoe_size`:19})
 create (_34413:`Player` {`age`:32, `birthplace`:"Coeur d'Alene, Idaho, USA", `first_name`:"Luke", `height_formatted`:"6'2\"", `last_name`:"Ridnour", `shoe_size`:11.5})
 create (_34414:`Player` {`age`:25, `birthplace`:"Fort Pierce, Florida, USA", `first_name`:"Larry", `height_formatted`:"6'11\"", `last_name`:"Sanders", `shoe_size`:18})
 create (_34415:`Player` {`age`:26, `birthplace`:"Edmond, Oklahoma, USA", `first_name`:"Ekpe", `height_formatted`:"6'10\"", `last_name`:"Udoh", `shoe_size`:16})
 create (_34416:`Player`:`Rookie` {`age`:22, `birthplace`:"Saint Cloud, Minnesota, USA", `first_name`:"Nate", `height_formatted`:"6'4\"", `last_name`:"Wolters", `shoe_size`:11})
 create (_34417:`Team` {`abbreviation`:"MIN", `city`:"Minneapolis", `full_name`:"Minnesota Timberwolves"})
 create (_34418:`Player` {`age`:29, `birthplace`:"Mayaguez, Puerto Rico", `first_name`:"J.J.", `height_formatted`:"6'0\"", `last_name`:"Barea", `shoe_size`:12})
 create (_34419:`Player` {`age`:27, `birthplace`:"Portland, Tennessee, USA", `first_name`:"Corey", `height_formatted`:"6'9\"", `last_name`:"Brewer", `shoe_size`:13.5})
 create (_34420:`Player` {`age`:25, `birthplace`:"Encinitas, California, USA", `first_name`:"Chase", `height_formatted`:"6'7\"", `last_name`:"Budinger", `shoe_size`:14})
 create (_34421:`Player` {`age`:26, `birthplace`:"Clinton, Maryland, USA", `first_name`:"Dante", `height_formatted`:"6'8\"", `last_name`:"Cunningham", `shoe_size`:18})
 create (_34422:`Player`:`Rookie` {`age`:23, `birthplace`:"Kébémèr, Senegal", `first_name`:"Gorgui", `height_formatted`:"6'11\"", `last_name`:"Dieng", `shoe_size`:12.5})
 create (_34423:`Player` {`age`:24, `birthplace`:"Valparaiso, Indiana, USA", `first_name`:"Robert", `height_formatted`:"6'8\"", `last_name`:"Hummel", `shoe_size`:16.5})
 create (_34424:`Player` {`age`:25, `birthplace`:"Santa Monica, California, USA", `first_name`:"Kevin", `height_formatted`:"6'10\"", `last_name`:"Love", `shoe_size`:18})
 create (_34425:`Player` {`age`:30, `birthplace`:"Zanesville, Ohio, USA", `first_name`:"Kevin", `height_formatted`:"6'7\"", `last_name`:"Martin", `shoe_size`:12})
 create (_34426:`Player` {`age`:27, `birthplace`:"Yaoundé, Cameroon", `first_name`:"Luc Richard", `height_formatted`:"6'8\"", `last_name`:"Mbah a Moute", `shoe_size`:14})
 create (_34427:`Player`:`Rookie` {`age`:21, `birthplace`:"Long Beach, California, USA", `first_name`:"Shabazz", `height_formatted`:"6'6\"", `last_name`:"Muhammad", `shoe_size`:13.5})
 create (_34428:`Player` {`age`:27, `birthplace`:"Bijelo Polje, Serbia and Montenegro", `first_name`:"Nikola", `height_formatted`:"6'11\"", `last_name`:"Pekovic", `shoe_size`:15.5})
 create (_34429:`Player` {`age`:27, `birthplace`:"Orange, New Jersey, USA", `first_name`:"A.J.", `height_formatted`:"6'2\"", `last_name`:"Price", `shoe_size`:10.5})
 create (_34430:`Player` {`age`:23, `birthplace`:"Barcelona, Spain", `first_name`:"Ricky", `height_formatted`:"6'4\"", `last_name`:"Rubio", `shoe_size`:12.5})
 create (_34431:`Player` {`age`:24, `birthplace`:"Belgorod, Russian Federation", `first_name`:"Alexey", `height_formatted`:"6'6\"", `last_name`:"Shved", `shoe_size`:12.5})
 create (_34432:`Player` {`age`:30, `birthplace`:"Le Robert, Martinique", `first_name`:"Ronny", `height_formatted`:"6'10\"", `last_name`:"Turiaf", `shoe_size`:14})
 create (_34433:`Team` {`abbreviation`:"NO", `city`:"New Orleans", `full_name`:"New Orleans Pelicans"})
 create (_34434:`Player` {`age`:23, `birthplace`:"Atlanta, Georgia, USA", `first_name`:"Al-Farouq", `height_formatted`:"6'9\"", `last_name`:"Aminu", `shoe_size`:15})
 create (_34435:`Player` {`age`:31, `birthplace`:"Ventura, California, USA", `first_name`:"Louis", `height_formatted`:"6'9\"", `last_name`:"Amundson", `shoe_size`:16.5})
 create (_34436:`Player` {`age`:25, `birthplace`:"Sacramento, California, USA", `first_name`:"Ryan", `height_formatted`:"6'10\"", `last_name`:"Anderson", `shoe_size`:17.5})
 create (_34437:`Player` {`age`:20, `birthplace`:"Chicago, Illinois, USA", `first_name`:"Anthony", `height_formatted`:"6'10\"", `last_name`:"Davis", `shoe_size`:17})
 create (_34438:`Player` {`age`:24, `birthplace`:"Chester, Pennsylvania, USA", `first_name`:"Tyreke", `height_formatted`:"6'6\"", `last_name`:"Evans", `shoe_size`:15})
 create (_34439:`Player` {`age`:24, `birthplace`:"Indianapolis, Indiana, USA", `first_name`:"Eric", `height_formatted`:"6'3\"", `last_name`:"Gordon", `shoe_size`:13.5})
 create (_34440:`Player`:`AllStar` {`age`:23, `birthplace`:"Chatsworth, California, USA", `first_name`:"Jrue", `height_formatted`:"6'3\"", `last_name`:"Holiday", `shoe_size`:13})
 create (_34441:`Player` {`age`:23, `birthplace`:"Maysville, Kentucky, USA", `first_name`:"Darius", `height_formatted`:"6'8\"", `last_name`:"Miller", `shoe_size`:14})
 create (_34442:`Player` {`age`:28, `birthplace`:"Charlotte, North Carolina, USA", `first_name`:"Anthony", `height_formatted`:"6'5\"", `last_name`:"Morrow", `shoe_size`:14})
 create (_34443:`Player` {`age`:21, `birthplace`:"Santa Monica, California, USA", `first_name`:"Austin", `height_formatted`:"6'4\"", `last_name`:"Rivers", `shoe_size`:14})

Size of the graph

This query returns the number of nodes and relationships in the graph.

match n-[w]-()
with count(distinct n) as numberOfNodes, count(distinct w) as numberOfRelationships
return numberOfNodes, numberOfRelationships;

Sample stadistics about the players

This query returns some statistics about the players (average, min and max age, and max and min height).

match (p:Player)
return avg(p.age) as averageAge, min(p.age) as minAge, max(p.age) as maxAge, max(p.height_formatted) as maxHeight, min (p.height_formatted) as minHeight;

Top five of most used brands

This query returns the name of the five most used brands by the NBA’s players.

match (n:Brand)-[*2]-(p:Player)
with n.name as brand, count(distinct p) as numberOfPlayers
return brand, numberOfPlayers
order by numberOfPlayers desc limit 5;

Top five of most used models

This query returns the name of the five most used sneakers.

match (m:Model)-[:WEARS]-(p:Player)
with m.name as model, count(distinct p) as numberOfPlayers
return model, numberOfPlayers
order by numberOfPlayers desc limit 5;

Top five biggest shoe sizes

This query returns the name of the five players with the biggest shoe sizes.

MATCH (n:Player)
RETURN str(n.first_name + " " + n.last_name) AS player, max(n.shoe_size) AS shoeSize
ORDER BY shoeSize DESC
LIMIT 5

Number of teammates of Kobe, LeBron and Kevin Durant who wear their signature shoes

This query returns the number of teammates of Kobe Bryant, LeBron James and Kevin Durant who wears Kobe’s, LeBron’s or KD’s.

match (n:AllStar)-[:PLAYS_FOR]->(t:Team)<-[:PLAYS_FOR]-(x:Player)-[:WEARS]->(m:Model)
where (n.first_name ="Kobe" and m.name=~".*Kobe.*")
or (n.first_name="LeBron" and m.name=~".*LeBron.*")
or (n.first_name="Kevin" and n.last_name="Durant" and m.name=~".*KD.*")
return distinct n.last_name as name, count (DISTINCT x.last_name) as numberOfTeammates;

What sneakers wears players are from Compton?

This query returns the name of players who are from Compton, and sneakers they use.

match (n:Player)-[w:WEARS]-(m:Model)
where n.birthplace=~".*Compton.*"
return str(n.first_name + " " + n.last_name) as player, collect(m.name) as sneakers;

Sneakers used by players who play for the team of his hometown

This query returns the name of players who play for the team of his hometown and their sneakers.

match (t:Team)<-[:PLAYS_FOR]-(n:Player)-[w:WEARS]-(m:Model)
where t.city= substring(n.birthplace, 0, length(t.city))
return str(n.first_name + " " + n.last_name) as player, t.full_name as teamName, collect(m.name) as sneakers;

Which models have been only used by seven footers?

This query returns the name of sneakers only used by players who are seven foot or more.

match (player:Player)-[:WEARS]->(model:Model)-[:MADE_BY]->(brand:Brand)
with model as model, brand as brand, collect(player) as players
where all(x in players where x.height_formatted =~ "7.*")
return brand.name as brandName, model.name as modelName, extract(player in players| str(player.first_name + " " + player.last_name)) as playerName
order by brandName;

What is the rookies average shoe size?

This query returns the rookies average shoe size.

MATCH (p:Player:Rookie) return avg(p.shoe_size) as averageRookiesShoeSize

Who are the players that don’t use brand-name shoes?

This query returns the name of players that don’t use brand-name shoes.

match (p:Player) where not (p-[:WEARS]->()) return str(p.first_name + " " + p.last_name) as playerWithoutBrandNameSneakers

Who are the players that use more than one sneaker model?

This query returns the name of players that use more than one sneaker model, the number of models they use and their names.

match (p:Player)-[:WEARS]->(m:Model)
with collect(m) as models, p as p
where reduce(count = 0, model in models | count +1) > 1
return p.first_name as name, p.last_name as surname, reduce(count = 0, model in models | count +1) as numberOfModels, extract(m in models| m.name) as sneakers
order by numberOfModels desc;

Cost of all sneakers

This query sets a random price for all sneakers and return the total cost of them.

MATCH (m:Model)
SET m.price=RAND()*30+50
RETURN reduce(total_amount = 0, x IN collect(m) | total_amount + x.price) as costOfAllSneakers

Random draft cost price lottery

This query returns the price of all the sneakers. The price is random.

match (m:Model)
return m.name as name, m.price as price
order by m.price desc;

About us

Our names are Luis Ángel and Sergio G. We study software engineering at the University of Oviedo. We got the assignment to do some work with Neo4j, and we have done this. We hope you’ll enjoy this gist as much as we did developing it.