Skip to content

Instantly share code, notes, and snippets.

@RyanTG

RyanTG/pbm-top20.txt

Created January 17, 2020 22:33
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 RyanTG/11b4f4442c6efc4cc58ca8eaaa8c5eaf to your computer and use it in GitHub Desktop.
Save RyanTG/11b4f4442c6efc4cc58ca8eaaa8c5eaf to your computer and use it in GitHub Desktop.
Download ZIP
01/17/20 - Places on Pinball Map with the most machines. Top 20
Raw
pbm-top20.txt
select name,street,city,state,country,count(distinct x.machine_id) from locations l inner join location_machine_xrefs x on x.location_id=l.id group by 1,2,3,4,5 order by 6 desc limit 20;
name | street | city | state | country | count
----------------------------------------------------------------------+---------------------------------------------------------+-------------------+------------------+---------+-------
Pinball Perfection | 231 Perry Highway | Westview | PA | US | 284
Pinball Hall of Fame | 1610 E Tropicana Ave | Las Vegas | NV | US | 204
Pinball PA/Pennsylvania Coin Operated Gaming Hall of Fame and Museum | 2284 Brodhead Road, Suite 10b | Hopewell Township | PA | US | 187
Freddy's Pinball Paradise | 44 Bisseser Stra▀e | Echzell | HE | DE | 169
Game Galaxy | 3 S Lowry St | Smyrna | TN | US | 136
Flipper- und Arcademuseum Seligenstadt | 6 Wilhelm-Leuschner-Stra▀e | Seligenstadt | HE | DE | 126
Next Level Pinball Museum | 1458 Northeast 25th Avenue | Hillsboro | OR | US | 119
The SILVER BALL PLANET | BIG STEP 3rd Floor, 1-6-14, Nishi Shinsaibashi, Chuo-ku | Osaka | Osaka Prefecture | JP | 112
Silverball Museum | 1000 Ocean Ave | Asbury Park | NJ | US | 111
Clubhouse NFV | 5 Turbinestraat | Veenendaal | UT | NL | 110
The Pinball Palace | 3303 Hopkins Avenue | Brunswick | GA | US | 95
Dutch Pinball Museum | Paul Nijghkade 19-K | Rotterdam | ZH | NL | 92
Silverball Museum Delray Beach | 19 NE 3rd Ave | Delray Beach | FL | US | 87
Pacific Pinball Museum | 1510 Webster St | Alameda | CA | US | 86
Wizard's World | 14613 Lima Rd. | Fort Wayne | IN | US | 82
Pinballz Arcade | 8940 Research Blvd | Austin | TX | US | 78
Pocketeer Billiards and Bar | 2444 Clinton St | Buffalo | NY | US | 78
TitleTown Pinball | 800 O Keefe Road | De Pere | WI | US | 77
Recbar | 10301 Taylorsville Road | Louisville | KY | US | 73
Pinball Gallery | 81 Lancaster Ave | Malvern | PA | US | 70
(20 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment