Datasets for Graph Hack 2014.

## file.md

      
          Raw
        
        
              file.md
            
          
    Datasets for Graph Hack 2014.
All stores are Neo4j 2.1.3.
Transportation
Flights
What is related, and how?
Flight	ORIGIN        Airport
Flight	DESTINATION   Airport
Flight	CARRIER       Carrier
Flight	AIRCRAFT      Aircraft
Flight	DELAYED_BY    Reason
Flight	CANCELLED_BY  Reason
Airport	IN_CITY	      City
City    IN_STATE      State
Flight	DIVERTED_TO   Airport

Which cities have more than 1 airport?
Query
MATCH (:Airport)-[:IN_CITY]->(c:City)
WITH c, COUNT(*) AS Count
WHERE Count > 1
RETURN c.name AS City, Count
ORDER BY Count

Result


City
Count


WASHINGTON, DC
2


HOUSTON, TX
2


NEW YORK, NY
2


CHICAGO, IL
2


Which cities have more than 1 airport, and what are they?
Query
MATCH (a:Airport)-[:IN_CITY]->(c:City)
WITH c.name AS City, COLLECT(a.name) AS Airports
WHERE LENGTH(Airports) > 1
RETURN City, Airports
ORDER BY LENGTH(Airports)

Result


City
Airports


HOUSTON, TX
GEORGE BUSH INTERCONTINENTAL/HOUSTON, WILLIAM P HOBBY


WASHINGTON, DC
RONALD REAGAN WASHINGTON NATIONAL, WASHINGTON DULLES INTERNATIONAL


NEW YORK, NY
JOHN F. KENNEDY INTERNATIONAL, LAGUARDIA


CHICAGO, IL
CHICAGO O'HARE INTERNATIONAL, CHICAGO MIDWAY INTERNATIONAL


Of the flights that departed from SFO and were diverted, what are the top airports that they were diverted to?
Query
MATCH (f:Flight)-[:ORIGIN]->(:Airport {abbr:'SFO'}),
      (f)-[d:DIVERTED_TO]->(a:Airport)
WHERE d.step = 1
RETURN a.abbr + ' - ' + a.name AS Airport, COUNT(*) AS Count
ORDER BY Count DESC
LIMIT 10

Result


Airport
Count


SFO - SAN FRANCISCO INTERNATIONAL
13


TWF - JOSLIN FIELD - MAGIC VALLEY REGIONAL
6


RDM - ROBERTS FIELD
5


GJT - GRAND JUNCTION REGIONAL
3


RDD - REDDING MUNICIPAL
3


EUG - MAHLON SWEET FIELD
2


DTW - DETROIT METRO WAYNE COUNTY
2


LAX - LOS ANGELES INTERNATIONAL
2


BOS - LOGAN INTERNATIONAL
2


LMT - KLAMATH FALLS AIRPORT
2


Fleets
What is related, and how?
Airline   BASED_IN  Country
Series    MODEL     Model
Aircraft  SERIES    Series
Aircraft  OWNED_BY  Airline

Which airlines own the most active Boeing 747s? How many do they own? In which countries are these airlines based?
Query
MATCH (a:Airline)-[:BASED_IN]->(c:Country),
      (craft:Aircraft)-[:OWNED_BY]->(a),
      (craft)-[:SERIES]->(:Series)-[:MODEL]->(m:Model)
WHERE craft.status = 'Active' AND m.name = 'Boeing 747'
WITH a, COUNT(m) AS count, c
ORDER BY count DESC
RETURN a.name AS Airline, c.name AS Country, count AS `Number of Boeing 747 Owned`
LIMIT 10

Result


Airline
Country
Number of Boeing 747 Owned


British Airways
United Kingdom
48


Korean Air
South Korea
36


Cathay Pacific
Hong-Kong
33


Lufthansa
Germany
32


China Airlines
Taiwan
31


KLM
Netherlands
26


United Airlines
USA
24


Atlas Air
USA
22


Transaero Airlines
Russia
20


Cargolux
Luxembourg
19


Which Embraer models have the most series of planes? What are they?
Query
MATCH (s:Series)-[:MODEL]->(m:Model)
WHERE m.name =~ 'Embraer.*'
WITH m.name AS Model, COLLECT(s.name) AS Series
RETURN Model, Series
ORDER BY LENGTH(Series) DESC

Result


Model
Series


Embraer 135/145
145SM, 145RS, 145EW, 145MP, 145BJ, 135ER, 135EJ, 135LR, 135, 145MR, 145LI, 145XR, 145ER, 145EP, 145LR, 145LU, 145SA, 135BK, 145EU, 145EJ, 135BJ, 140LR


Embraer 190/195
195STD, 190SLR, 190ECJ, 190BJ, 195LR, 190IGW, 195AR, 195SR, 190ER, 190, 195IGW, 190AR, 190LR, 190STD, 190SR


Embraer 170/175
175SR, 175SU, 170SL, 170SE, 170STD, 175SD, 175LR, 170LR, 170SU, 175STD, 170ST, 175IGW, 170AR, 170SR


Embraer 120 Brasilia
120ER, 120QC, 120, 120RT


Dallas/Forth Worth International Airport
What is related, and how?
Gate   IN_TERMINAL  Terminal
Place  IN_CATEGORY  Category
Place  AT_GATE      Gate

At which gates in terminal A can I find a Starbucks?
Query
MATCH (p:Place)-[:AT_GATE]->(g:Gate),
      (g)-[:IN_TERMINAL]->(t:Terminal)
WHERE p.name = 'Starbucks Coffee' AND t.name = 'A'
RETURN g.gate AS Gate, t.name AS Terminal
ORDER BY Gate

Result


Gate
Terminal


29
A


33
A


37
A


Where are places in terminal D in categories 'Bar' or 'Barbecue'?
Query
MATCH (p:Place)-[:IN_CATEGORY]->(c:Category)
WHERE c.name IN ['Bar', 'Barbecue']
WITH p
MATCH (p)-[:AT_GATE]->(g:Gate),
      (g)-[:IN_TERMINAL]->(t:Terminal)
WHERE t.name = 'D'
RETURN p.name AS Place, g.gate AS Gate
ORDER BY Gate

Result


Place
Gate


Railhead BBQ
18


Tigin Irish Pub & Restaurant
20


Cousin's Bar-B-Q
28


Gas Monkey Bar & Grill
31


Caltrain
What is related, and how?
Stop  IN        Zone
Stop  NEXT      Stop
Train STOPS_AT  Stop

Which consecutive stops are furthest apart?
Query
MATCH (s1:Stop)-[r:NEXT]->(s2:Stop)
WITH s1, s2, r.distance AS Distance
ORDER BY Distance DESC
LIMIT 1
RETURN s1.name AS Stop1, s2.name AS Stop2, Distance

Result


Stop1
Stop2
Distance


BLOSSOM HILL
MORGAN HILL
11.8


Which trains can I take home to San Mateo from San Francisco after the hackathon tonight?
Query
MATCH (t:Train)
WHERE t.direction = 'Southbound' AND t.type = 'Weekday'
WITH t

MATCH (t)-[leave:STOPS_AT]->(begin:Stop),
      (t)-[:STOPS_AT]->(end:Stop)
WHERE begin.name = 'SAN FRANCISCO' AND
      end.name = 'SAN MATEO'
WITH t, leave.hour*100 + leave.minute AS minutes, leave.hour_s AS Hour, leave.minute_s AS Minute
WHERE minutes > 2100 OR minutes < 100
RETURN t.id AS Train, Hour + ':' + Minute AS `Departure Time`

Result


Train
Departure Time


194
21:40


196
22:40


198
00:01


Music
Last.fm
What is related, and how?
Scrobble  PLAYED     Track
Scrobble  NEXT       Scrobble
User      SCROBBLED  Scrobble
Artist    MEMBER_OF  Genre
Track     SUNG_BY    Artist

Which artists do users 'nmwhite0131' and 'smooligans' mutually listen to most often?
Query
MATCH (u1:User {username:'nmwhite0131'}), (u2:User {username:'smooligans'})
WITH u1, u2
MATCH (u1)-[:SCROBBLED]->(:Scrobble)-[:PLAYED]->(:Track)-[:SUNG_BY]->(a:Artist),
      (u2)-[:SCROBBLED]->(:Scrobble)-[:PLAYED]->(:Track)-[:SUNG_BY]->(a)
RETURN a.name AS Artist, COUNT(*) AS Count
ORDER BY Count DESC
LIMIT 10

Result


Artist
Count


Drake
15019


Beyoncé
6869


Lana Del Rey
3723


Jay-Z
2967


Nicki Minaj
2624


Lil' Wayne
2242


Rihanna
1911


Daft Punk
1560


Explosions in the Sky
1165


Tyga
663


User nmwhite0131's last five scrobbles.
Query
MATCH (:User {username:'nmwhite0131'})-[:SCROBBLED]->(last:Scrobble),
      recent = (:Scrobble)-[:NEXT*4]->(last)
WHERE NOT ((last)-[:NEXT]->(:Scrobble))
WITH NODES(recent) AS scrobbles
UNWIND scrobbles AS s
MATCH (s)-[:PLAYED]->(t:Track)-[:SUNG_BY]->(a:Artist)
RETURN s.date AS Date, t.name AS Track, a.name AS Artist

Result


Date
Track
Artist


2014-09-24
Easy
Saycet


2014-09-24
Bruyère
Saycet


2014-09-24
Opal
Saycet


2014-09-24
Her Movie
Saycet


2014-09-24
We Walk Fast
Saycet


Social
Twitter
What is related, and how?
Tweet    USING     Source
Tweet    CONTAINS  Link
Tweet    MENTIONS  User
Tweet    RETWEETS  Tweet
User     POSTS     Tweet
Tweet    REPLY_TO  Tweet
Hashtag  TAGS      Tweet

How are hashtags 'java' and 'graph' related?
Query
MATCH (java:Hashtag {name:'java'}), (graph:Hashtag {name:'graph'})
WITH java, graph
MATCH p = shortestPath((java)-[:TAGS*]-(graph))
RETURN p

Result

What is the most retweeted tweet, who posted it, and what did it say?
Query
MATCH (:Tweet)-[:RETWEETS]->(t:Tweet)
WITH t, COUNT(*) AS count
ORDER BY count DESC
LIMIT 1

MATCH (u:User)-[:POSTS]->(t)
RETURN u.screen_name AS User, t.text AS Tweet, count AS Retweets

Result


User
Tweet
Retweets


println_ts
A twist on how to do login & registration form on #Neo4J's website. #ux #ui http://t.co/CmDIfkSDT3 http://t.co/fjtSik59Qa
5