120 rows sorted by active

View and edit SQL

Suggested facets: active

Link rowid franchID franchName active ▼ NAassoc
9 BLC Baltimore Canaries    
13 BNA Boston Red Stockings   ATL
15 BRA Brooklyn Atlantics    
24 CEN Philadelphia Centennials    
25 CFC Cleveland Forest Citys    
36 CNA Chicago White Stockings   CHC
43 ECK Brooklyn Eckfords    
46 HNA Hartford Dark Blues   HAR
56 KEK Fort Wayne Kekiongas    
60 MAN Middletown Mansfields    
61 MAR Baltimore Marylands    
67 NAT Washington Nationals    
69 NHV New Haven Elm Citys    
70 NNA New York Mutuals   NYU
77 OLY Washington Olympics    
85 PNA Philadelphia Athletics   ATH
87 PWS Philadelphia White Stockings    
88 RES Elizabeth Resolutes    
91 ROK Rockford Forest Citys    
98 SLR St. Louis Red Stockings    
99 SNA St. Louis Brown Stockings   SBS
109 TRO Troy Haymakers    
112 WBL Washington Blue Legs    
113 WES Keokuk Westerns    
117 WNT Washington Nationals    
1 ALT Altoona Mountain City N  
4 ATH Philadelphia Athletics N PNA
7 BFB Buffalo Bisons N  
8 BFL Buffalo Bisons N  
10 BLO Baltimore Orioles N  
11 BLT Baltimore Terrapins N  
12 BLU Baltimore Monumentals N  
16 BRD Boston Reds N  
17 BRG Brooklyn Gladiators N  
18 BRS Boston Reds N  
19 BTT Brooklyn Tip-Tops N  
20 BUF Buffalo Bisons N  
21 BWW Brooklyn Ward's Wonders N  
22 CBK Columbus Buckeyes N  
23 CBL Cleveland Blues N  
27 CHH Chicago Whales N  
28 CHP Chicago Pirates N  
31 CKK Cincinnati Kelly's Killers N  
33 CLI Cleveland Infants N  
34 CLS Columbus Solons N  
35 CLV Cleveland Spiders N  
37 CNR Cincinnati Reds N  
39 COR Cincinnati Outlaw Reds N  
40 CPI Chicago/Pittsburgh (Union League) N  
42 DTN Detroit Wolverines N  
45 HAR Hartford Dark Blues N HNA
48 IBL Indianapolis Blues N  
49 IHO Indianapolis Hoosiers N  
50 IND Indianapolis Hoosiers N  
51 KCC Kansas City Cowboys N  
52 KCN Kansas City Cowboys N  
53 KCP Kansas City Packers N  
55 KCU Kansas City Cowboys N  
58 LGR Louisville Grays N  
59 LOU Louisville Colonels N  
64 MLA Milwaukee Brewers N  
65 MLG Milwaukee Grays N  
66 MLU Milwaukee Brewers N  
68 NEW Newark Pepper N  
71 NYI New York Giants N  
73 NYP New York Metropolitans N  
74 NYU New York Mutuals N NNA
78 PBB Pittsburgh Burghers N  
79 PBS Pittsburgh Rebels N  
80 PHA Philadelphia Athletics N  
82 PHK Philadelphia Keystones N  
83 PHQ Philadelphia Athletics N  
86 PRO Providence Grays N  
89 RIC Richmond Virginians N  
90 ROC Rochester Broncos N  
92 SBS St. Louis Brown Stockings N SNA
96 SLI St. Louis Terriers N  
97 SLM St. Louis Maroons N  
101 STP St. Paul Apostles N  
102 SYR Syracuse Stars N  
103 SYS Syracuse Stars N  
106 TLM Toledo Maumees N  
107 TOL Toledo Blue Stockings N  
110 TRT Troy Trojans N  
111 WAS Washington Senators N  
114 WIL Wilmington Quicksteps N  
115 WNA Washington Nationals N  
116 WNL Washington Nationals N  
118 WOR Worcester Ruby Legs N  
120 WST Washington Statesmen N  
2 ANA Los Angeles Angels of Anaheim Y  
3 ARI Arizona Diamondbacks Y  
5 ATL Atlanta Braves Y BNA
6 BAL Baltimore Orioles Y  
14 BOS Boston Red Sox Y  
26 CHC Chicago Cubs Y CNA
29 CHW Chicago White Sox Y  
30 CIN Cincinnati Reds Y  
32 CLE Cleveland Indians Y  
38 COL Colorado Rockies Y  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "TeamsFranchises" (
"franchID" TEXT,
  "franchName" TEXT,
  "active" TEXT,
  "NAassoc" REAL
);