SELECT S.*, COUNT(Z.city), AVG(Z.lat) AS ApproxLat, AVG(Z.lng) AS ApproxLng FROM vizsagedb_rsnew.Sites S LEFT JOIN vizsagedb_foo.ZipCodes Z ON (S.state = Z.state) AND (UPPER(S.city) = Z.city) WHERE 1 GROUP BY siteID ORDER BY ApproxLat,ApproxLng

siteID	name	aka	city	state	start	end	leagueID	comment	COUNT(Z.city)	ApproxLat	ApproxLng
WAV01	Waverly Fairgrounds	(null)	Waverly	NJ	1873-04-28	1873-07-23	NA	ELI	0
IRO01	Windsor Beach	(null)	Irondequoit	NY	1890-05-11	1890-07-20	AA	RC2: Sundays	0
TOR02	SkyDome	(null)	Toronto	ON	1989-06-05		AL	(null)	0
PEN01	Pendleton Park	(null)	Pendleton	OH	1891-04-25	1891-08-13	AA	CN3	0
MIN02	Metropolitan Stadium	(null)	Bloomington	MN	1961-04-21	1981-09-30	AL	(null)	0
WAT01	Troy Ball Club Grounds	(null)	West Troy	NY	1882-05-20	1882-08-26	NL	TRN	0
TOR01	Exhibition Stadium	(null)	Toronto	ON	1977-04-07	1989-05-28	AL	first game: snow covering outfield	0
TOK01	Tokyo Dome	(null)	Tokyo	JA	2000-03-29	2000-03-30		NYN&CHN:3/29&3/30/2000	0
MON02	Stade Olympique	Olympic Stadium	Montreal	QU	1977-04-15	2004-09-29	NL	(null)	0
LUD01	Ludlow Baseball Park	(null)	Ludlow	KY	1875-09-22	1875-09-22	NA	PH2	0
THR01	Three Rivers Park	(null)	Three Rivers	NY	1890-05-18	1890-07-20	AA	SR2: Sundays	0
MON01	Parc Jarry	Jarry Park	Montreal	QU	1969-04-14	1976-09-29	NL	(null)	0
CLL01	Euclid Beach Park	(null)	Collinwood	OH	1898-06-12	1898-06-19	NL	CL4:6/12&6/19/1898	0
GEA01	Geagua Lake Grounds	(null)	Geauga Lake	OH	1888-07-22	1888-09-02	AA	CL3:7/22&7/29&8/26&9/2/1888	0
MNT01	Estadio de Beisbol Monterrey	(null)	Monterrey	MX	1996-08-16	1999-04-04	NL	SDN:8/16&8/17&8/18/1996; 4/4/1999	0
SAI01	St. George Cricket Grounds	(null)	Saint George	NY	1886-04-22	1889-06-14		NY4:1886-87; NY1:4/29 to 6/14/1889	0
LBV01	The Ballpark at Disney's Wide World of Sports	(null)	Lake Buena Vista	FL	2007-05-15	2007-05-17	AL	TBA: 3 games	0
WEE01	Monitor Park	(null)	Weehawken	NJ	1887-09-11	1887-09-11	AA	NY4	1	0	0
SJU01	Estadio Hiram Bithorn	(null)	San Juan	PR	2001-04-01	2003-09-11	NL	TOR: 4/1/2001; MON:4/11-20,6/3-8,9/5-11/2003	37	18.415280110127	-66.060342324747
HON01	Aloha Stadium	(null)	Honolulu	HI	1997-04-19	1997-04-20	NL	SDN:4/19&4/19&4/20/1997	45	24.491277694702	-166.90040724013
MIA01	Pro Player Stadium	Joe Robbie Stadium	Miami	FL	1993-04-05		NL	(null)	97	25.404727365553	-79.53378130726
STP01	Tropicana Field	(null)	Saint Petersburg	FL	1998-03-31		AL	(null)	32	27.839184820652	-82.705296754837
HOU03	Minute Maid Park	Enron Field; Astros Field	Houston	TX	2000-04-07		NL	(null)	181	29.80868586124	-95.411953119942
HOU02	Astrodome	(null)	Houston	TX	1965-04-12	1999-10-03	NL	(null)	181	29.80868586124	-95.411953119942
HOU01	Colt Stadium	(null)	Houston	TX	1962-04-10	1964-09-27	NL	(null)	181	29.80868586124	-95.411953119942
DOV01	Fairview Park Fair Grounds	(null)	Dover	DE	1875-06-24	1875-06-24	NA	PH1	5	31.306855773926	-60.397782897949
ANA01	Angel Stadium of Anaheim	Edison Field; Anaheim Stadium	Anaheim	CA	1966-04-19		AL	(null)	17	31.661459530101	-110.84182559743
ARL02	Ameriquest Field	The Ballpark in Arlington	Arlington	TX	1994-04-11		AL	(null)	19	32.768182051809	-97.24645955939
ARL01	Arlington Stadium	(null)	Arlington	TX	1972-04-21	1993-10-03	AL	(null)	19	32.768182051809	-97.24645955939
PHO01	Bank One Ballpark	BOB	Phoenix	AZ	1998-03-31		NL	(null)	78	32.874329297971	-110.71562429575
SAN02	PetCo Park	(null)	San Diego	CA	2004-04-08		NL	(null)	81	32.894151004744	-116.99433898926
SAN01	Qualcomm Stadium	San Diego Stadium; Jack Murphy Stadium	San Diego	CA	1969-04-08	2003-09-28	NL	(null)	81	32.894151004744	-116.99433898926
LOS03	Dodger Stadium	Chavez Ravine	Los Angeles	CA	1962-04-10		NL	LAN:1962-prsnt; LAA:1962-9/2/65; CAL:9/2to9/22/65	99	33.807944249625	-118.29062120842
LOS02	Wrigley Field	(null)	Los Angeles	CA	1961-04-27	1961-10-01	AL	(null)	99	33.807944249625	-118.29062120842
LOS01	Los Angeles Memorial Coliseum	(null)	Los Angeles	CA	1958-04-18	1961-09-20	NL	(null)	99	33.807944249625	-118.29062120842
ATL02	Turner Field	(null)	Atlanta	GA	1997-04-04		NL	(null)	103	33.830716253484	-84.400102707946
ATL01	Atlanta-Fulton County Stadium	(null)	Atlanta	GA	1966-04-12	1996-09-23	NL	(null)	103	33.830716253484	-84.400102707946
LAS01	Cashman Field	(null)	Las Vegas	NV	1996-04-01	1996-04-07	AL	OAK: 6 games	64	36.062588274479	-115.11513376236
OAK01	Network Associates Coliseum	Oakland-Alameda County Stadium	Oakland	CA	1968-04-17		AL	(null)	30	36.497609329224	-118.05752182007
RIC02	Virginia Base-Ball Park	(null)	Richmond	VA	1884-08-05	1884-10-15	AA	(null)	54	36.840680652195	-76.052512274848
RIC01	Richmond Fair Grounds	(null)	Richmond	VA	1875-04-29	1875-05-01	NA	WS6: 2 games	54	36.840680652195	-76.052512274848
SFO03	SBC Park	Pacific Bell Park; AT&T Park	San Francisco	CA	2000-04-11		NL	(null)	71	37.776269670943	-122.61050737408
SFO02	Candlestick Park	3Com Park	San Francisco	CA	1960-04-12	1999-09-30	NL	(null)	71	37.776269670943	-122.61050737408
SFO01	Seals Stadium	(null)	San Francisco	CA	1958-04-15	1959-09-20	NL	(null)	71	37.776269670943	-122.61050737408
STL08	Handlan's Park	Federal League Park	Saint Louis	MO	1914-04-16	1915-10-03	FL	(null)	71	38.097773269868	-89.020549398073
STL03	Sportsman's Park I	(null)	Saint Louis	MO	1882-05-02	1892-10-13		SL4:1882-1891; SLN:1892	71	38.097773269868	-89.020549398073
STL07	Sportsman's Park III	Busch Stadium I	Saint Louis	MO	1909-04-14	1966-05-08		SLA:1909-1953; SLN:7/1/1920 to 5/8/1966	71	38.097773269868	-89.020549398073
STL02	Grand Avenue Park	(null)	Saint Louis	MO	1875-05-06	1877-10-06		SL2:1875; SL3:1876-1877	71	38.097773269868	-89.020549398073
STL06	Sportsman's Park II	(null)	Saint Louis	MO	1902-04-23	1908-10-06	AL	(null)	71	38.097773269868	-89.020549398073
STL01	Red Stocking Base Ball Park	(null)	Saint Louis	MO	1875-05-04	1875-07-04	NA	SL1	71	38.097773269868	-89.020549398073
STL10	Busch Stadium III	(null)	Saint Louis	MO	2006-04-10		NL	(null)	71	38.097773269868	-89.020549398073
STL05	Robison Field	(null)	Saint Louis	MO	1893-04-27	1920-06-06	NL	(null)	71	38.097773269868	-89.020549398073
STL09	Busch Stadium II	(null)	Saint Louis	MO	1966-05-12	2005-10-02	NL	(null)	71	38.097773269868	-89.020549398073
STL04	Union Grounds	(null)	Saint Louis	MO	1884-04-20	1886-09-23		SLU:1884; SL5:1885-86	71	38.097773269868	-89.020549398073
LOU01	Louisville Baseball Park	(null)	Louisville	KY	1876-04-25	1877-09-29	NL	(null)	66	38.199744947029	-85.684070471561
LOU03	Eclipse Park II	(null)	Louisville	KY	1893-05-22	1899-10-07	NL	(null)	66	38.199744947029	-85.684070471561
LOU02	Eclipse Park I	(null)	Louisville	KY	1882-05-05	1893-05-04		LS2:1882-91; LS3:1892-93	66	38.199744947029	-85.684070471561
WAS07	American League Park I	(null)	Washington	DC	1901-04-29	1903-09-29	AL	first PA announcer (1902)	277	38.474137729686	-76.185400621986
WAS02	National Grounds	(null)	Washington	DC	1872-04-20	1872-05-25	NA	WS4	277	38.474137729686	-76.185400621986
WAS06	Boundary Field	(null)	Washington	DC	1891-04-13	1899-10-14		WS9:1891; WSN: 1892-1899	277	38.474137729686	-76.185400621986
WAS01	Olympic Grounds	(null)	Washington	DC	1871-05-04	1875-06-08	NA	WS3:1871-1872; WS5:1873; WS6:1875	277	38.474137729686	-76.185400621986
WAS10	Robert F. Kennedy Stadium	D.C. Stadium	Washington	DC	1962-04-09			AL:1962-71; NL:2005	277	38.474137729686	-76.185400621986
WAS05	Swampoodle Grounds	(null)	Washington	DC	1886-04-29	1889-09-21	NL	(null)	277	38.474137729686	-76.185400621986
WAS09	Griffith Stadium	(null)	Washington	DC	1911-04-12	1961-09-21	AL	WS1:1911-60; WS2:1961	277	38.474137729686	-76.185400621986
WAS04	Athletic Park	(null)	Washington	DC	1884-05-01	1884-08-05	AA	(null)	277	38.474137729686	-76.185400621986
WAS08	American League Park II	(null)	Washington	DC	1904-04-14	1910-10-06	AL	(null)	277	38.474137729686	-76.185400621986
WAS03	Capitol Grounds	(null)	Washington	DC	1884-04-18	1884-09-25	UA	(null)	277	38.474137729686	-76.185400621986
CIN07	Crosley Field	Redland Field	Cincinnati	OH	1912-04-11	1970-06-24	NL	(null)	74	38.63692835215	-83.354545180862
CIN02	Avenue Grounds	(null)	Cincinnati	OH	1876-04-25	1879-08-27	NL	first Ladies Day (1876)	74	38.63692835215	-83.354545180862
CIN06	Palace of the Fans	League Park III	Cincinnati	OH	1902-04-17	1911-10-06	NL	(null)	74	38.63692835215	-83.354545180862
CIN01	Lincoln Park Grounds	Union Cricket Club Grounds	Cincinnati	OH	1871-05-13	1871-07-22	NA	WS3:5/13&7/4/1871; CL1:7/22/1871	74	38.63692835215	-83.354545180862
CIN05	League Park II	(null)	Cincinnati	OH	1894-04-20	1901-10-02	NL	(null)	74	38.63692835215	-83.354545180862
CIN09	Great American Ballpark	(null)	Cincinnati	OH	2003-03-31		NL	(null)	74	38.63692835215	-83.354545180862
CIN04	League Park I	(null)	Cincinnati	OH	1884-05-01	1893-09-29		CN2:1884-89; CIN:1890-93	74	38.63692835215	-83.354545180862
CIN08	Cinergy Field	Riverfront Stadium	Cincinnati	OH	1970-06-30	2002-09-22	NL	(null)	74	38.63692835215	-83.354545180862
CIN03	Bank Street Grounds	(null)	Cincinnati	OH	1880-05-01	1884-10-15		CN1:1880; CN2:1882-83; CNU:1884	74	38.63692835215	-83.354545180862
COV01	Star Baseball Park	(null)	Covington	KY	1875-09-21	1875-09-21	NA	PH2	5	39.019087982178	-84.534059143066
KAN03	Exposition Park	(null)	Kansas City	MO	1888-09-30	1889-09-30	AA	(null)	81	39.094124169997	-94.497583083165
KAN02	Association Park	(null)	Kansas City	MO	1886-04-30	1888-10-15		KCN:1886; KC2:1888	81	39.094124169997	-94.497583083165
KAN06	Kauffman Stadium	Royals Stadium	Kansas City	MO	1973-04-10		AL	(null)	81	39.094124169997	-94.497583083165
KAN01	Athletic Park	(null)	Kansas City	MO	1884-06-07	1884-10-19	UA	(null)	81	39.094124169997	-94.497583083165
KAN05	Municipal Stadium	(null)	Kansas City	MO	1955-04-12	1972-10-04	AL	KC1:1955-67; KCA:1969-1972	81	39.094124169997	-94.497583083165
KAN04	Gordon and Koppel Field	(null)	Kansas City	MO	1914-04-16	1915-09-28	FL	(null)	81	39.094124169997	-94.497583083165
IND03	Bruce Grounds	(null)	Indianapolis	IN	1884-05-18	1884-09-21	AA	Sundays	61	39.144386416576	-84.726398780698
IND07	Federal League Park	Washington Park	Indianapolis	IN	1914-04-23	1914-10-08	FL	(null)	61	39.144386416576	-84.726398780698
IND02	Seventh Street Park I	(null)	Indianapolis	IN	1884-05-14	1884-09-20	AA	(null)	61	39.144386416576	-84.726398780698
IND06	Indianapolis Park	(null)	Indianapolis	IN	1890-07-28	1890-08-02	NL	CL4	61	39.144386416576	-84.726398780698
IND01	South Street Park	(null)	Indianapolis	IN	1878-05-01	1878-09-14	NL	(null)	61	39.144386416576	-84.726398780698
IND05	Seventh Street Park III	(null)	Indianapolis	IN	1888-04-20	1889-10-05	NL	(null)	61	39.144386416576	-84.726398780698
IND04	Seventh Street Park II	(null)	Indianapolis	IN	1887-04-28	1887-10-08	NL	(null)	61	39.144386416576	-84.726398780698
DEN01	Mile High Stadium	(null)	Denver	CO	1993-04-09	1994-08-11	NL	(null)	75	39.21290318807	-103.43421081543
DEN02	Coors Field	(null)	Denver	CO	1995-04-26		NL	(null)	75	39.21290318807	-103.43421081543
BAL09	Oriole Park IV	American League Park	Baltimore	MD	1901-04-26	1902-09-29	AL	(null)	50	39.308814086914	-76.618368835449
BAL03	Oriole Park I	(null)	Baltimore	MD	1883-05-01	1889-10-10	AA	(null)	50	39.308814086914	-76.618368835449
BAL07	Oriole Park III	(null)	Baltimore	MD	1891-05-11	1899-10-10		BL3:1891; BLN:1892-99	50	39.308814086914	-76.618368835449
BAL02	Newington Park	(null)	Baltimore	MD	1872-04-22	1882-09-30		BL1:1872-74; BL4:1873; BL2: 1882	50	39.308814086914	-76.618368835449
BAL12	Oriole Park at Camden Yards	(null)	Baltimore	MD	1992-04-06		AL	(null)	50	39.308814086914	-76.618368835449
BAL06	Oriole Park II	(null)	Baltimore	MD	1890-08-27	1891-05-09	AA	(null)	50	39.308814086914	-76.618368835449
BAL01	Madison Avenue Grounds	(null)	Baltimore	MD	1871-07-08	1871-07-08	NA	WS3	50	39.308814086914	-76.618368835449
BAL11	Memorial Stadium	(null)	Baltimore	MD	1954-04-15	1991-09-30	AL	(null)	50	39.308814086914	-76.618368835449
BAL05	Monumental Park	(null)	Baltimore	MD	1884-08-25	1884-08-25	UA	BLU	50	39.308814086914	-76.618368835449
BAL10	Terrapin Park	Oriole Park V	Baltimore	MD	1914-04-13	1915-10-02	FL	(null)	50	39.308814086914	-76.618368835449
BAL04	Belair Lot	(null)	Baltimore	MD	1884-04-17	1884-09-24	UA	BLU:not 8/25	50	39.308814086914	-76.618368835449
WIL01	Wilmington Grounds	(null)	Wilmington	DE	1884-09-02	1884-09-15	UA	9/15 forfeit	27	39.641996030454	-75.59056854248
DAY01	Fairview Park	(null)	Dayton	OH	1902-06-08	1902-06-08	AL	CLE	49	39.745930496527	-84.215962779765
GLO01	Gloucester Point Grounds	(null)	Gloucester City	NJ	1888-08-05	1890-10-12	AA	Sundays; PH4 6/10/1888	1	39.890411376953	-75.112617492676
COL03	Neil Park I	(null)	Columbus	OH	1902-08-03	1903-05-17	AL	CLE:2 games	47	39.977498480614	-82.978755382781
COL02	Recreation Park II	(null)	Columbus	OH	1889-04-28	1891-09-22	AA	(null)	47	39.977498480614	-82.978755382781
COL01	Recreation Park I	(null)	Columbus	OH	1883-05-01	1884-09-22	AA	(null)	47	39.977498480614	-82.978755382781
COL04	Neil Park II	(null)	Columbus	OH	1905-07-23	1905-07-24	AL	DET:2 games	47	39.977498480614	-82.978755382781
PHI10	Columbia Park	(null)	Philadelphia	PA	1901-04-26	1908-10-03		PHA; PHI:8/20 to 9/10/1903	84	39.998406682696	-75.135279337565
PHI05	Keystone Park	(null)	Philadelphia	PA	1884-04-17	1884-08-07	UA	(null)	84	39.998406682696	-75.135279337565
PHI09	Baker Bowl	(null)	Philadelphia	PA	1895-05-02	1938-06-30	NL	PHI:not 8/20 to 9/10/1903	84	39.998406682696	-75.135279337565
PHI04	Recreation Park	(null)	Philadelphia	PA	1883-05-01	1886-10-09	NL	(null)	84	39.998406682696	-75.135279337565
PHI13	Citizens Bank Park	(null)	Philadelphia	PA	2004-04-12		NL	(null)	84	39.998406682696	-75.135279337565
PHI08	University of Penn. Athletic Field	(null)	Philadelphia	PA	1894-08-11	1894-08-17	NL	PHI:8/11&8/14 to 8/17/1894	84	39.998406682696	-75.135279337565
PHI03	Oakdale Park	(null)	Philadelphia	PA	1882-05-02	1882-09-21	AA	PH4	84	39.998406682696	-75.135279337565
PHI12	Veterans Stadium	(null)	Philadelphia	PA	1971-04-10	2003-09-28	NL	(null)	84	39.998406682696	-75.135279337565
PHI07	Forepaugh Park	(null)	Philadelphia	PA	1890-04-30	1891-10-05		PHP:1890; PH4:1891	84	39.998406682696	-75.135279337565
PHI02	Centennial Park	(null)	Philadelphia	PA	1875-04-21	1875-05-24	NA	PH3	84	39.998406682696	-75.135279337565
PHI11	Shibe Park	Connie Mack Stadium	Philadelphia	PA	1909-04-12	1970-10-01		PHA:1909-1954; PHI:5/16to5/28/1927;7/4/1938to1970	84	39.998406682696	-75.135279337565
PHI06	Philadelphia Baseball Grounds	(null)	Philadelphia	PA	1887-04-30	1894-09-06	NL	no games 8/7 to 8/17/1894; fire 8/6/1894	84	39.998406682696	-75.135279337565
PHI01	Jefferson Street Grounds	Athletics Park	Philadelphia	PA	1871-05-15	1890-10-11		PH1:1871-75; PH2:1873-75; PHN:1876; PH4:1883-1890	84	39.998406682696	-75.135279337565
WHE01	Island Grounds	(null)	Wheeling	WV	1890-09-22	1890-09-22	NL	PIT	1	40.102703094482	-80.647598266602
PIT06	Forbes Field	(null)	Pittsburgh	PA	1909-06-30	1970-06-28	NL	(null)	77	40.423079007632	-80.030739325982
PIT01	Union Park	(null)	Pittsburgh	PA	1878-08-22	1878-08-24	NL	PRO: 3 games	77	40.423079007632	-80.030739325982
PIT05	Exposition Park III	(null)	Pittsburgh	PA	1890-04-19	1915-10-02		PTP:1890; PIT:1891-6/29/1909; PTF:1914-15	77	40.423079007632	-80.030739325982
PIT04	Recreation Park	(null)	Pittsburgh	PA	1884-05-01	1890-09-30		PT1:1884-1886; PIT:1887-1890	77	40.423079007632	-80.030739325982
PIT08	PNC Park	(null)	Pittsburgh	PA	2001-04-09		NL	(null)	77	40.423079007632	-80.030739325982
PIT03	Exposition Park II	Upper Field	Pittsburgh	PA	1883-05-01	1883-06-09	AA	PT1	77	40.423079007632	-80.030739325982
PIT07	Three Rivers Stadium	(null)	Pittsburgh	PA	1970-07-16	2000-10-01	NL	(null)	77	40.423079007632	-80.030739325982
PIT02	Exposition Park I	Lower Field	Pittsburgh	PA	1882-05-09	1884-08-30		PT1:1882-1883; PTU: 8/25 to 8/30/1884	77	40.423079007632	-80.030739325982
ALT01	Columbia Park	(null)	Altoona	PA	1884-04-30	1884-05-31	UA	(null)	3	40.499807993571	-78.380849202474
KEO01	Perry Park	Walte's Pasture	Keokuk	IA	1875-05-04	1875-06-14	NA	(null)	1	40.584716796875	-91.4716796875
NYC08	Washington Park II	(null)	Brooklyn	NY	1889-05-30	1890-10-03		BR3:1889; BRO:1890	52	40.652983885545	-73.952164429885
NYC12	Washington Park III	(null)	Brooklyn	NY	1898-04-30	1915-09-30		BRO:1898-1912; BRF:1914-15	52	40.652983885545	-73.952164429885
NYC07	Ridgewood Park	(null)	Brooklyn	NY	1886-05-02	1890-06-08	AA	BR3: Sundays (1886-1889); BR4: 1980	52	40.652983885545	-73.952164429885
NYC02	Capitoline Grounds	(null)	Brooklyn	NY	1872-05-06	1872-10-09	NA	BR2	52	40.652983885545	-73.952164429885
NYC11	Eastern Park	(null)	Brooklyn	NY	1890-04-28	1897-10-02		BRP:1890; BRO:1891-97	52	40.652983885545	-73.952164429885
NYC01	Union Grounds	(null)	Brooklyn	NY	1871-05-09	1877-09-21		NY2:1871-75;BR1:1872;BR2:1873-75;NY3:1876;HAR:1877	52	40.652983885545	-73.952164429885
NYC15	Ebbets Field	(null)	Brooklyn	NY	1913-04-09	1957-09-24	NL	(null)	52	40.652983885545	-73.952164429885
NYC05	Washington Park I	(null)	Brooklyn	NY	1884-05-05	1889-05-04	AA	BR3	52	40.652983885545	-73.952164429885
MAS01	Long Island Grounds	(null)	Maspeth	NY	1890-07-27	1890-08-03	AA	BR4: 2 games	1	40.722846984863	-73.908416748047
JER02	Roosevelt Stadium	(null)	Jersey City	NJ	1956-04-19	1957-09-03	NL	BRO: 7 gms (1956) & 8 gms (1957)	12	40.729332605998	-74.067237218221
JER01	Oakdale Park	(null)	Jersey City	NJ	1889-04-24	1889-04-25	NL	NY1: 2 games	12	40.729332605998	-74.067237218221
HAR01	Harrison Field	(null)	Harrison	NJ	1915-04-16	1915-10-03	FL	NEW	1	40.744499206543	-74.150787353516
HOB01	Elysian Field	(null)	Hoboken	NJ	1873-07-04	1873-07-04	NA	NY2	1	40.746852874756	-74.033935546875
NWK01	Wiedenmeyer's Park	(null)	Newark	NJ	1904-07-17	1904-07-17	AL	NYA	23	40.766902591871	-74.220946602199
NYC14	Polo Grounds V	(null)	New York	NY	1911-06-28	1963-09-18		NY1:1911-1957;NYA:1913-1922;NYN:1962-63	162	40.767756214848	-73.978839921363
NYC09	Polo Grounds III	(null)	New York	NY	1889-07-08	1890-09-13	NL	(null)	162	40.767756214848	-73.978839921363
NYC04	Polo Grounds II (Southwest Diamond)	(null)	New York	NY	1883-05-30	1883-10-25	AA	(null)	162	40.767756214848	-73.978839921363
NYC13	Hilltop Park	(null)	New York	NY	1903-04-30	1912-10-05		NYA:1903-1912; NY1: 4/15 to 5/30/1911	162	40.767756214848	-73.978839921363
NYC03	Polo Grounds I (Southeast Diamond)	(null)	New York	NY	1883-05-01	1888-10-13		NY1:1883-88; NY4:7/17/1884-1885	162	40.767756214848	-73.978839921363
NYC17	Shea Stadium	William A. Shea Stadium	New York	NY	1964-04-17		NL	NYN:1964-date; NYA:1974-75	162	40.767756214848	-73.978839921363
NYC16	Yankee Stadium	(null)	New York	NY	1923-04-18		AL	no games 1974-75	162	40.767756214848	-73.978839921363
NYC06	Metropolitan Park	(null)	New York	NY	1884-05-13	1884-08-23	AA	(null)	162	40.767756214848	-73.978839921363
NYC10	Polo Grounds IV	(null)	New York	NY	1890-04-19	1911-04-13		NYP:1890; NY1:1891-1911	162	40.767756214848	-73.978839921363
WNY01	West New York Field Club Grounds	(null)	West New York	NJ	1898-09-11	1899-09-17	NL	BRO:9/18&10/2/1898; NY1:9/11/98, 6/4&7/16&8/13&9/17/99	1	40.788799285889	-74.011535644531
CAN01	Mahaffey Park	(null)	Canton	OH	1890-09-18	1903-06-21		PIT 9/18/1890; CLE 6/15/02, 5/10/03 & 6/21/03	23	40.816265935483	-81.381342017132
CHI09	South Side Park III	(null)	Chicago	IL	1901-04-24	1910-06-27	AL	(null)	85	40.848091933307	-85.633022353228
CHI04	Lake Front Park II	(null)	Chicago	IL	1883-05-05	1884-10-11	NL	(null)	85	40.848091933307	-85.633022353228
CHI08	West Side Grounds	(null)	Chicago	IL	1893-05-13	1915-10-03	NL	CHN:1893(Sun);1894-1915	85	40.848091933307	-85.633022353228
CHI03	Lake Front Park I	(null)	Chicago	IL	1878-05-14	1882-09-30	NL	(null)	85	40.848091933307	-85.633022353228
CHI12	Comiskey Park II	White Sox Park; U.S. Cellular Field	Chicago	IL	1991-04-18		AL	(null)	85	40.848091933307	-85.633022353228
CHI07	South Side Park II	(null)	Chicago	IL	1890-04-30	1893-09-27		CHP:1890;CHN:1891(Tu/Th/Sa);1892-93	85	40.848091933307	-85.633022353228
CHI02	23rd Street Park	(null)	Chicago	IL	1872-05-29	1877-10-06		CH2:1874-75; CHN:1876-77	85	40.848091933307	-85.633022353228
CHI11	Wrigley Field	Weeghman Park; Cubs Park	Chicago	IL	1914-04-23		NL	CHF:1914-15; CHN:1916-date	85	40.848091933307	-85.633022353228
CHI06	West Side Park I	(null)	Chicago	IL	1885-06-06	1891-10-03	NL	CHN:1891(M/W/F)	85	40.848091933307	-85.633022353228
CHI01	Union Base-ball Grounds	Lake Park	Chicago	IL	1871-05-08	1871-09-29	NA	(null)	85	40.848091933307	-85.633022353228
CHI10	Comiskey Park I	White Sox Park	Chicago	IL	1910-07-01	1990-09-30	AL	(null)	85	40.848091933307	-85.633022353228
CHI05	South Side Park I	Cricket Club Grounds; Union Grounds	Chicago	IL	1884-05-02	1884-08-01	UA	(null)	85	40.848091933307	-85.633022353228
FOR02	Swinney Park	(null)	Fort Wayne	IN	1882-10-24	1882-10-24	NL	Last game of playoffs (CHN & PRO)	43	41.086782144946	-85.095231167106
FOR01	Hamilton Field	(null)	Fort Wayne	IN	1871-05-04	1871-08-29	NA	First ML game	43	41.086782144946	-85.095231167106
FOR03	Jailhouse Flats	(null)	Fort Wayne	IN	1902-06-22	1902-08-31	AL	CLE:2 games	43	41.086782144946	-85.095231167106
NEW01	Howard Avenue Grounds	Brewster Park	New Haven	CT	1875-04-21	1875-10-28	NA	(null)	26	41.35026711684	-72.92068862915
MID01	Mansfield Club Grounds	(null)	Middletown	CT	1872-05-02	1872-07-04	NA	(null)	2	41.553300857544	-72.656768798828
SYR02	Star Park II	(null)	Syracuse	NY	1890-04-28	1890-10-06	AA	(null)	29	41.559511250463	-73.539077495706
SYR01	Star Park I	Newell Park	Syracuse	NY	1879-05-28	1879-09-10	NL	(null)	29	41.559511250463	-73.539077495706
SYR04	Lakeside Park	(null)	Syracuse	NY	1879-05-31	1879-08-09	NL	SR1: Sundays	29	41.559511250463	-73.539077495706
SYR03	Iron Pier	(null)	Syracuse	NY	1890-08-03	1890-08-03	AA	Forfeit by LS2 to SR2; no game ever played here	29	41.559511250463	-73.539077495706
CLE08	Jacobs Field	(null)	Cleveland	OH	1994-04-04		AL	(null)	47	41.561032559009	-81.649713719145
CLE03	National League Park II	American Association Park	Cleveland	OH	1887-05-04	1890-10-04		CL3:1887-88; CL4:1889-90	47	41.561032559009	-81.649713719145
CLE07	Cleveland Stadium	Municipal Stadium	Cleveland	OH	1932-07-31	1993-10-03	AL	CLE:7/31/1932-9/24/1933; 1947-1993	47	41.561032559009	-81.649713719145
CLE02	National League Park I	Kennard Street Park	Cleveland	OH	1879-05-01	1884-10-11	NL	(null)	47	41.561032559009	-81.649713719145
CLE06	League Park II	Dunn Field	Cleveland	OH	1910-04-21	1946-09-21	AL	CLE:1910-7/30/1932;1934-46	47	41.561032559009	-81.649713719145
CLE01	National Association Grounds	(null)	Cleveland	OH	1871-05-11	1872-08-19	NA	(null)	47	41.561032559009	-81.649713719145
CLE05	League Park I	National League Park III	Cleveland	OH	1891-05-01	1909-09-06		CL4:1891-99; CLE:1901-09	47	41.561032559009	-81.649713719145
CLE09	Cedar Avenue Driving Park	(null)	Cleveland	OH	1887-08-21	1887-08-21	AA	CL3: 1 game	47	41.561032559009	-81.649713719145
CLE04	Brotherhood Park	Players League Park	Cleveland	OH	1890-04-30	1890-10-04	PL	(null)	47	41.561032559009	-81.649713719145
TOL01	League Park	(null)	Toledo	OH	1884-05-14	1884-09-23	AA	(null)	35	41.674528285435	-83.524956839425
TOL04	Armory Park	(null)	Toledo	OH	1903-06-28	1903-08-16	AL	DET: 2 games	35	41.674528285435	-83.524956839425
TOL03	Speranza Park	(null)	Toledo	OH	1890-05-01	1890-10-02	AA	(null)	35	41.674528285435	-83.524956839425
TOL02	Tri-State Fair Grounds	(null)	Toledo	OH	1884-09-13	1884-09-13	AA	(null)	35	41.674528285435	-83.524956839425
WAR01	Rocky Point Park	(null)	Warwick	RI	1903-09-06	1903-09-06	NL	BSN; outfield surrounded by ocean	4	41.705350875854	-71.485971450806
HRT02	Hartford Trotting Park	(null)	Hartford	CT	1872-06-21	1872-08-09	NA	MID: 6/21, 7/3, 8/9	36	41.786356714037	-72.703691906399
HRT01	Hartford Ball Club Grounds	(null)	Hartford	CT	1874-05-01	1876-09-30		HR1:1874-75; HAR:1876	36	41.786356714037	-72.703691906399
PRO02	Messer Street Grounds	(null)	Providence	RI	1878-05-01	1885-09-09	NL	(null)	12	41.829246838888	-71.434340794881
PRO01	Adelaide Avenue Grounds	(null)	Providence	RI	1875-06-12	1875-06-22	NA	NH1: 6/12/1875; BS1: 6/22/1875	12	41.829246838888	-71.434340794881
ELM01	Maple Avenue Driving Park	(null)	Elmira	NY	1885-10-10	1885-10-10	NL	BFN	6	42.108729680379	-76.79600016276
SPR01	Hampden Park Race Track	Springfield Track	Springfield	MA	1872-07-23	1875-05-14	NA	TRO:7/23/1872; BS1:7/16/1873,5/14/1875	21	42.132665543329	-72.575417654855
DET04	Tiger Stadium	Navin Field; Briggs Stadium	Detroit	MI	1912-04-20	1999-09-27	AL	(null)	46	42.253931294317	-83.162715911865
DET03	Burns Park	West End Park	Detroit	MI	1901-04-28	1902-09-07	AL	Sundays only	46	42.253931294317	-83.162715911865
DET02	Bennett Park	(null)	Detroit	MI	1901-04-25	1911-09-10	AL	(null)	46	42.253931294317	-83.162715911865
DET01	Recreation Park	(null)	Detroit	MI	1881-05-02	1888-09-22	NL	(null)	46	42.253931294317	-83.162715911865
DET05	Comerica Park	(null)	Detroit	MI	2000-04-11		AL	(null)	46	42.253931294317	-83.162715911865
RCK01	Agricultural Society Fair Grounds	(null)	Rockford	IL	1871-05-05	1871-09-26	NA	(null)	14	42.291084289551	-89.098484039307
WOR01	Agricultural County Fair Grounds I	(null)	Worcester	MA	1880-05-01	1882-09-29	NL	(null)	16	42.300015211105	-71.84775686264
WOR02	Agricultural County Fair Grounds II	(null)	Worcester	MA	1887-08-17	1887-08-17	NL	1 BSN game	16	42.300015211105	-71.84775686264
BOS07	Fenway Park	(null)	Boston	MA	1912-04-20		AL	BOS:1912-date; BSN:9/7 to 9/29/1914; 4/14 to 7/26/15	54	42.342797032109	-71.002905669036
BOS02	Dartmouth Grounds	Union Park	Boston	MA	1884-04-30	1884-09-24		BSU; BSN:5/16 to 6/20/1894	54	42.342797032109	-71.002905669036
BOS06	Huntington Avenue Baseball Grounds	(null)	Boston	MA	1901-05-08	1911-10-07	AL	(null)	54	42.342797032109	-71.002905669036
BOS01	South End Grounds I	Walpole Street Grounds	Boston	MA	1871-05-16	1887-09-10		BS1:1871-75; HR1: 8/12/1874; BSN:1876-1887	54	42.342797032109	-71.002905669036
BOS05	South End Grounds III	(null)	Boston	MA	1894-07-20	1914-08-11	NL	(null)	54	42.342797032109	-71.002905669036
BOS04	Congress Street Grounds	(null)	Boston	MA	1890-04-19	1894-06-20		BSP:1891; BS2:1891; BSN:5/16 to 6/20/1894	54	42.342797032109	-71.002905669036
BOS08	Braves Field	Bee Hive	Boston	MA	1915-08-18	1952-09-21		(null)	54	42.342797032109	-71.002905669036
BOS03	South End Grounds II	(null)	Boston	MA	1888-05-25	1894-05-15	NL	(null)	54	42.342797032109	-71.002905669036
ALB01	Riverside Park	(null)	Albany	NY	1880-09-11	1882-05-30	NL	TRN:9/11/80;6/15&9/10/1881;5/16-5/18&5/30/1882	51	42.631787019617	-73.927329418706
TRO02	Putnam Grounds	(null)	Troy	NY	1879-05-28	1879-09-20	NL	(null)	5	42.711121368408	-73.630969238281
TRO01	Haymakers' Grounds	(null)	Troy	NY	1871-05-09	1881-09-30		TRO:1871-72; TRN: 1880-81	5	42.711121368408	-73.630969238281
BUF04	Federal League Park	(null)	Buffalo	NY	1914-05-11	1915-09-29	FL	(null)	44	42.859902555292	-78.843484531749
BUF03	Olympic Park II	(null)	Buffalo	NY	1890-04-19	1890-10-04	PL	(null)	44	42.859902555292	-78.843484531749
BUF02	Olympic Park I	(null)	Buffalo	NY	1884-05-21	1885-10-07	NL	(null)	44	42.859902555292	-78.843484531749
BUF01	Riverside Grounds	(null)	Buffalo	NY	1879-05-01	1883-09-08	NL	(null)	44	42.859902555292	-78.843484531749
GRA01	Ramona Park	(null)	Grand Rapids	MI	1903-05-24	1903-05-24	AL	DET	26	42.988454965445	-85.590966444749
MIL04	Lloyd Street Grounds	(null)	Milwaukee	WI	1901-05-03	1901-09-12	AL	(null)	48	43.044513940811	-87.907215118408
MIL03	Borchert Field	(null)	Milwaukee	WI	1891-09-10	1891-10-04	AA	(null)	48	43.044513940811	-87.907215118408
MIL02	Wright Street Grounds	(null)	Milwaukee	WI	1884-09-27	1885-09-25		UA:1884; BFN:9/4/1885; PRO: 9/25/1885	48	43.044513940811	-87.907215118408
MIL06	Miller Park	(null)	Milwaukee	WI	2001-04-06		NL	(null)	48	43.044513940811	-87.907215118408
MIL01	Milwaukee Base-Ball Grounds	(null)	Milwaukee	WI	1878-05-14	1878-09-14	NL	(null)	48	43.044513940811	-87.907215118408
MIL05	County Stadium	(null)	Milwaukee	WI	1953-04-14	2000-09-28		MLN:1953-65; CHA:9gms(1968)&11gms(1969);MIL:70-00	48	43.044513940811	-87.907215118408
ROC03	Ontario Beach Grounds	(null)	Rochester	NY	1898-08-28	1898-08-28	NL	CL4	46	43.217474481334	-77.645312433657
ROC02	Culver Field II	(null)	Rochester	NY	1898-08-27	1898-08-29	NL	CL4: 2 games	46	43.217474481334	-77.645312433657
ROC01	Culver Field I	(null)	Rochester	NY	1890-04-28	1890-10-06	AA	(null)	46	43.217474481334	-77.645312433657
MIN03	Hubert H. Humphrey Metrodome	(null)	Minneapolis	MN	1982-04-06		AL	(null)	69	44.988757147305	-93.357812300972
MIN01	Athletic Park	(null)	Minneapolis	MN	1891-10-02	1891-10-02	AA	ML2	69	44.988757147305	-93.357812300972
SEA02	Kingdome	(null)	Seattle	WA	1977-04-06	1999-06-27	AL	(null)	56	46.601162433624	-119.65687670027
SEA01	Sick's Stadium	(null)	Seattle	WA	1969-04-11	1969-10-02	AL	(null)	56	46.601162433624	-119.65687670027
SEA03	Safeco Field	(null)	Seattle	WA	1999-07-15		AL	(null)	56	46.601162433624	-119.65687670027