HomeGames
3,108 rows sorted by league.key
This data as json, CSV (advanced)
Suggested facets: league.key, span.first (date), span.last (date)
Link | rowid | year.key | league.key ▼ | team.key | park.key | span.first | span.last | games | openings | attendance |
---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 1871 | BS1 | BOS01 | 1871-05-16 | 1871-10-07 | 16 | 16 | 32600 | |
2 | 2 | 1871 | BS1 | NYC01 | 1871-05-27 | 1871-05-27 | 1 | 1 | 3000 | |
3 | 3 | 1871 | CH1 | CHI01 | 1871-05-08 | 1871-09-29 | 16 | 15 | 85500 | |
4 | 4 | 1871 | CH1 | NYC01 | 1871-10-30 | 1871-10-30 | 1 | 1 | 600 | |
5 | 5 | 1871 | CL1 | CIN01 | 1871-05-13 | 1871-07-22 | 2 | 2 | 2200 | |
6 | 6 | 1871 | CL1 | CLE01 | 1871-05-11 | 1871-09-27 | 11 | 6 | 9500 | |
7 | 7 | 1871 | FW1 | FOR01 | 1871-05-04 | 1871-08-29 | 9 | 4 | 2350 | |
8 | 8 | 1871 | NY2 | NYC01 | 1871-05-25 | 1871-09-22 | 19 | 18 | 42050 | |
9 | 9 | 1871 | PH1 | PHI01 | 1871-06-03 | 1871-10-18 | 14 | 14 | 52000 | |
10 | 10 | 1871 | RC1 | CHI01 | 1871-08-08 | 1871-08-08 | 1 | 1 | 1000 | |
11 | 11 | 1871 | RC1 | RCK01 | 1871-05-06 | 1871-08-03 | 6 | 5 | 5200 | |
12 | 12 | 1871 | TRO | TRO01 | 1871-05-09 | 1871-10-23 | 17 | 10 | 14050 | |
13 | 13 | 1871 | WS3 | BAL01 | 1871-07-08 | 1871-07-08 | 1 | 1 | 1000 | |
14 | 14 | 1871 | WS3 | CIN01 | 1871-07-04 | 1871-07-04 | 1 | 1 | 5500 | |
15 | 15 | 1871 | WS3 | NYC01 | 1871-07-28 | 1871-07-28 | 1 | 1 | 1500 | |
16 | 16 | 1871 | WS3 | WAS01 | 1871-05-05 | 1871-08-26 | 11 | 8 | 15950 | |
17 | 17 | 1872 | BL1 | BAL02 | 1872-04-22 | 1872-10-17 | 29 | 19 | 23100 | |
18 | 18 | 1872 | BR1 | NYC01 | 1872-05-07 | 1872-10-22 | 14 | 8 | 3400 | |
19 | 19 | 1872 | BR2 | NYC02 | 1872-05-06 | 1872-10-31 | 18 | 14 | 8350 | |
20 | 20 | 1872 | BS1 | BOS01 | 1872-05-11 | 1872-10-05 | 21 | 21 | 38400 | |
21 | 21 | 1872 | CL1 | CHI02 | 1872-05-29 | 1872-05-30 | 2 | 2 | 5000 | |
22 | 22 | 1872 | CL1 | CLE01 | 1872-06-01 | 1872-08-19 | 5 | 2 | 1500 | |
23 | 23 | 1872 | MID | HRT02 | 1872-06-21 | 1872-08-09 | 3 | 1 | 600 | |
24 | 24 | 1872 | MID | MID01 | 1872-05-02 | 1872-07-27 | 7 | 1 | 500 | |
25 | 25 | 1872 | MID | SPR01 | 1872-07-23 | 1872-07-23 | 1 | 1 | 1200 | |
26 | 26 | 1872 | NY2 | NYC01 | 1872-04-29 | 1872-10-30 | 29 | 28 | 46750 | |
27 | 27 | 1872 | PH1 | PHI01 | 1872-05-01 | 1872-10-07 | 28 | 28 | 66500 | |
28 | 28 | 1872 | TRO | CHI02 | 1872-06-17 | 1872-07-04 | 4 | 4 | 13100 | |
29 | 29 | 1872 | TRO | TRO01 | 1872-04-26 | 1872-06-06 | 8 | 7 | 9500 | |
30 | 30 | 1872 | WS3 | WAS01 | 1872-04-18 | 1872-05-24 | 7 | 2 | 700 | |
31 | 31 | 1872 | WS4 | WAS02 | 1872-04-20 | 1872-05-25 | 7 | 2 | 450 | |
32 | 32 | 1873 | BL1 | BAL02 | 1873-04-21 | 1873-10-21 | 27 | 0 | 0 | |
33 | 33 | 1873 | BL4 | BAL02 | 1873-04-14 | 1873-04-14 | 1 | 0 | 0 | |
34 | 34 | 1873 | BR2 | NYC01 | 1873-05-07 | 1873-11-01 | 29 | 0 | 0 | |
35 | 35 | 1873 | BS1 | BOS01 | 1873-04-23 | 1873-10-13 | 28 | 0 | 0 | |
36 | 36 | 1873 | BS1 | CHI02 | 1873-08-16 | 1873-08-16 | 1 | 0 | 0 | |
37 | 37 | 1873 | BS1 | SPR01 | 1873-07-16 | 1873-07-16 | 1 | 0 | 0 | |
38 | 38 | 1873 | ELI | NYC01 | 1873-06-12 | 1873-06-12 | 1 | 0 | 0 | |
39 | 39 | 1873 | ELI | WAV01 | 1873-04-28 | 1873-07-23 | 7 | 0 | 0 | |
40 | 40 | 1873 | NY2 | NYC01 | 1873-05-05 | 1873-10-21 | 31 | 0 | 0 | |
41 | 41 | 1873 | PH1 | PHI01 | 1873-04-21 | 1873-10-29 | 27 | 0 | 0 | |
42 | 42 | 1873 | PH2 | CHI02 | 1873-08-19 | 1873-08-19 | 1 | 0 | 0 | |
43 | 43 | 1873 | PH2 | PHI01 | 1873-05-01 | 1873-10-16 | 27 | 0 | 0 | |
44 | 44 | 1873 | WS5 | WAS01 | 1873-04-15 | 1873-10-23 | 18 | 0 | 0 | |
45 | 45 | 1874 | BL1 | BAL02 | 1874-04-22 | 1874-10-14 | 20 | 15 | 11100 | |
46 | 46 | 1874 | BR2 | NYC01 | 1874-05-05 | 1874-10-29 | 29 | 27 | 19800 | |
47 | 47 | 1874 | BS1 | BOS01 | 1874-05-02 | 1874-10-28 | 34 | 32 | 45300 | |
48 | 48 | 1874 | BS1 | WOR03 | 1874-10-30 | 1874-10-30 | 1 | 1 | 500 | |
49 | 49 | 1874 | CH2 | CHI02 | 1874-05-13 | 1874-10-10 | 28 | 28 | 75692 | |
50 | 50 | 1874 | HR1 | BOS01 | 1874-08-12 | 1874-08-12 | 1 | 1 | 500 | |
51 | 51 | 1874 | HR1 | HRT01 | 1874-05-01 | 1874-10-28 | 30 | 26 | 28355 | |
52 | 52 | 1874 | NY2 | NYC01 | 1874-05-06 | 1874-10-30 | 35 | 32 | 37600 | |
53 | 53 | 1874 | PH1 | PHI01 | 1874-04-16 | 1874-10-24 | 29 | 29 | 29600 | |
54 | 54 | 1874 | PH2 | PHI01 | 1874-05-04 | 1874-10-21 | 25 | 25 | 24050 | |
55 | 55 | 1875 | BR2 | NYC01 | 1875-05-05 | 1875-10-09 | 27 | 26 | 11324 | |
56 | 56 | 1875 | BS1 | BOS01 | 1875-04-19 | 1875-10-30 | 35 | 34 | 46030 | |
57 | 57 | 1875 | BS1 | PRO01 | 1875-06-22 | 1875-06-22 | 1 | 1 | 1400 | |
58 | 58 | 1875 | BS1 | SPR01 | 1875-05-14 | 1875-05-14 | 1 | 1 | 1600 | |
59 | 59 | 1875 | CH2 | CHI02 | 1875-05-15 | 1875-10-02 | 33 | 33 | 61155 | |
60 | 60 | 1875 | HR1 | HRT01 | 1875-04-24 | 1875-10-29 | 38 | 37 | 54524 | |
61 | 61 | 1875 | HR1 | PRO01 | 1875-06-12 | 1875-06-12 | 1 | 1 | 1200 | |
62 | 62 | 1875 | KEO | KEO01 | 1875-05-04 | 1875-06-14 | 8 | 8 | 4277 | |
63 | 63 | 1875 | NH1 | NEW01 | 1875-04-26 | 1875-10-28 | 26 | 23 | 14404 | |
64 | 64 | 1875 | NH1 | NEW02 | 1875-04-21 | 1875-04-21 | 1 | 1 | 700 | |
65 | 65 | 1875 | NY2 | NYC01 | 1875-04-30 | 1875-10-29 | 36 | 36 | 29202 | |
66 | 66 | 1875 | PH1 | DOV01 | 1875-06-24 | 1875-06-24 | 1 | 0 | 0 | |
67 | 67 | 1875 | PH1 | PHI01 | 1875-04-22 | 1875-10-28 | 36 | 35 | 45353 | |
68 | 68 | 1875 | PH1 | PHI02 | 1875-06-04 | 1875-06-04 | 1 | 1 | 300 | |
69 | 69 | 1875 | PH2 | COV01 | 1875-09-21 | 1875-09-21 | 1 | 1 | 800 | |
70 | 70 | 1875 | PH2 | LUD01 | 1875-09-22 | 1875-09-22 | 1 | 1 | 500 | |
71 | 71 | 1875 | PH2 | PHI01 | 1875-04-26 | 1875-10-25 | 31 | 29 | 25229 | |
72 | 72 | 1875 | PH3 | PHI02 | 1875-04-21 | 1875-05-24 | 7 | 5 | 3300 | |
73 | 73 | 1875 | SL1 | STL01 | 1875-05-04 | 1875-07-04 | 14 | 14 | 5700 | |
74 | 74 | 1875 | SL2 | STL02 | 1875-05-06 | 1875-10-08 | 34 | 34 | 81028 | |
75 | 75 | 1875 | WS6 | BAL02 | 1875-06-01 | 1875-06-09 | 2 | 1 | 200 | |
76 | 76 | 1875 | WS6 | RIC01 | 1875-04-29 | 1875-05-01 | 2 | 2 | 2000 | |
77 | 77 | 1875 | WS6 | WAS01 | 1875-04-26 | 1875-06-08 | 8 | 7 | 8350 | |
129 | 129 | 1882 | AA | BL2 | BAL02 | 1882-05-09 | 1882-09-30 | 33 | 0 | 0 |
133 | 133 | 1882 | AA | CN2 | CIN03 | 1882-05-02 | 1882-09-28 | 42 | 0 | 0 |
135 | 135 | 1882 | AA | LS2 | LOU02 | 1882-05-05 | 1882-09-25 | 39 | 0 | 0 |
136 | 136 | 1882 | AA | PH4 | PHI03 | 1882-05-02 | 1882-09-21 | 39 | 0 | 0 |
138 | 138 | 1882 | AA | PT1 | PIT02 | 1882-05-10 | 1882-09-23 | 37 | 0 | 0 |
139 | 139 | 1882 | AA | SL4 | STL03 | 1882-05-02 | 1882-10-01 | 44 | 0 | 0 |
144 | 144 | 1883 | AA | BL2 | BAL03 | 1883-05-01 | 1883-09-06 | 49 | 0 | 0 |
148 | 148 | 1883 | AA | CL5 | COL01 | 1883-05-01 | 1883-09-27 | 47 | 0 | 0 |
149 | 149 | 1883 | AA | CN2 | CIN03 | 1883-05-01 | 1883-09-29 | 51 | 0 | 0 |
151 | 151 | 1883 | AA | LS2 | LOU02 | 1883-05-11 | 1883-09-30 | 47 | 0 | 0 |
153 | 153 | 1883 | AA | NY4 | NYC03 | 1883-05-12 | 1883-09-06 | 34 | 0 | 0 |
154 | 154 | 1883 | AA | NY4 | NYC04 | 1883-05-30 | 1883-09-04 | 13 | 0 | 0 |
155 | 155 | 1883 | AA | PH4 | PHI01 | 1883-05-10 | 1883-09-07 | 51 | 0 | 0 |
158 | 158 | 1883 | AA | PT1 | PIT02 | 1883-06-12 | 1883-09-06 | 32 | 0 | 0 |
159 | 159 | 1883 | AA | PT1 | PIT03 | 1883-05-01 | 1883-06-09 | 17 | 0 | 0 |
160 | 160 | 1883 | AA | SL4 | STL03 | 1883-05-15 | 1883-09-30 | 49 | 0 | 0 |
163 | 163 | 1884 | AA | BL2 | BAL03 | 1884-05-01 | 1884-10-15 | 57 | 0 | 0 |
166 | 166 | 1884 | AA | BR3 | NYC05 | 1884-05-05 | 1884-10-15 | 52 | 0 | 0 |
174 | 174 | 1884 | AA | CL5 | COL01 | 1884-05-14 | 1884-09-22 | 55 | 0 | 0 |
175 | 175 | 1884 | AA | CN2 | CIN04 | 1884-05-01 | 1884-09-22 | 56 | 0 | 0 |
176 | 176 | 1884 | AA | CN2 | NYC05 | 1884-10-10 | 1884-10-10 | 1 | 0 | 0 |
179 | 179 | 1884 | AA | IN2 | IND02 | 1884-05-14 | 1884-09-20 | 44 | 0 | 0 |
180 | 180 | 1884 | AA | IN2 | IND03 | 1884-05-18 | 1884-09-21 | 11 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "HomeGames" ( "year.key" INTEGER, "league.key" REAL, "team.key" TEXT, "park.key" TEXT, "span.first" TEXT, "span.last" TEXT, "games" INTEGER, "openings" INTEGER, "attendance" INTEGER );