3,108 rows sorted by openings

View and edit SQL

Suggested facets: league.key, span.last (date)

Link rowid year.key league.key team.key park.key span.first span.last games openings ▼ attendance
32 1873   BL1 BAL02 1873-04-21 1873-10-21 27 0 0
33 1873   BL4 BAL02 1873-04-14 1873-04-14 1 0 0
34 1873   BR2 NYC01 1873-05-07 1873-11-01 29 0 0
35 1873   BS1 BOS01 1873-04-23 1873-10-13 28 0 0
36 1873   BS1 CHI02 1873-08-16 1873-08-16 1 0 0
37 1873   BS1 SPR01 1873-07-16 1873-07-16 1 0 0
38 1873   ELI NYC01 1873-06-12 1873-06-12 1 0 0
39 1873   ELI WAV01 1873-04-28 1873-07-23 7 0 0
40 1873   NY2 NYC01 1873-05-05 1873-10-21 31 0 0
41 1873   PH1 PHI01 1873-04-21 1873-10-29 27 0 0
42 1873   PH2 CHI02 1873-08-19 1873-08-19 1 0 0
43 1873   PH2 PHI01 1873-05-01 1873-10-16 27 0 0
44 1873   WS5 WAS01 1873-04-15 1873-10-23 18 0 0
66 1875   PH1 DOV01 1875-06-24 1875-06-24 1 0 0
78 1876 NL BSN BOS01 1876-04-29 1876-10-21 36 0 0
79 1876 NL CHN CHI02 1876-05-10 1876-09-27 31 0 0
80 1876 NL CN1 CIN02 1876-04-25 1876-10-09 30 0 0
81 1876 NL HAR HRT01 1876-05-01 1876-09-16 32 0 0
82 1876 NL LS1 LOU01 1876-04-25 1876-10-05 33 0 0
83 1876 NL NY3 NYC01 1876-04-25 1876-10-17 33 0 0
84 1876 NL PHN PHI01 1876-04-22 1876-09-16 35 0 0
85 1876 NL SL3 STL02 1876-05-05 1876-10-04 30 0 0
86 1877 NL BSN BOS01 1877-06-02 1877-09-29 32 0 0
87 1877 NL CHN CHI02 1877-05-08 1877-10-06 29 0 0
88 1877 NL CN1 CIN02 1877-05-14 1877-09-29 31 0 0
89 1877 NL HAR NEW01 1877-09-22 1877-09-22 1 0 0
90 1877 NL HAR NYC01 1877-04-30 1877-09-21 28 0 0
91 1877 NL LS1 LOU01 1877-05-10 1877-09-29 29 0 0
92 1877 NL SL3 STL02 1877-05-08 1877-10-06 30 0 0
93 1878 NL BSN BOS01 1878-05-04 1878-09-28 30 0 0
94 1878 NL CHN CHI03 1878-05-14 1878-09-14 35 0 0
95 1878 NL CN1 CIN02 1878-05-01 1878-09-07 34 0 0
96 1878 NL IN1 IND01 1878-05-01 1878-09-13 22 0 0
97 1878 NL IN1 PIT01 1878-08-22 1878-08-24 3 0 0
98 1878 NL IN1 STL02 1878-07-09 1878-07-13 3 0 0
99 1878 NL ML2 MIL01 1878-05-14 1878-09-14 25 0 0
100 1878 NL PRO NYC01 1878-07-26 1878-07-26 1 0 0
101 1878 NL PRO PRO02 1878-05-01 1878-09-30 31 0 0
102 1879 NL BFN BUF01 1879-05-01 1879-09-30 40 0 0
103 1879 NL BSN BOS01 1879-05-28 1879-09-27 42 0 0
104 1879 NL CHN CHI03 1879-05-01 1879-08-26 43 0 0
105 1879 NL CL2 CLE02 1879-05-01 1879-09-30 42 0 0
106 1879 NL CN1 CIN02 1879-05-01 1879-08-27 37 0 0
107 1879 NL PRO PRO02 1879-05-28 1879-09-30 42 0 0
108 1879 NL SR1 SYR01 1879-05-28 1879-09-10 34 0 0
109 1879 NL TRN TRO02 1879-05-28 1879-09-20 41 0 0
110 1880 NL BFN BUF01 1880-05-07 1880-09-16 43 0 0
111 1880 NL BSN BOS01 1880-05-04 1880-09-30 43 0 0
112 1880 NL CHN CHI03 1880-05-07 1880-09-30 43 0 0
113 1880 NL CL2 CLE02 1880-05-01 1880-09-22 44 0 0
114 1880 NL CN1 CIN03 1880-05-01 1880-09-30 40 0 0
115 1880 NL PRO PRO02 1880-05-01 1880-09-27 44 0 0
116 1880 NL TRN ALB01 1880-09-11 1880-09-11 1 0 0
117 1880 NL TRN TRO01 1880-05-18 1880-09-17 40 0 0
118 1880 NL WOR WOR01 1880-05-01 1880-10-01 42 0 0
119 1881 NL BFN BUF01 1881-05-05 1881-09-10 41 0 0
120 1881 NL BSN BOS01 1881-05-03 1881-09-30 41 0 0
121 1881 NL CHN CHI03 1881-04-30 1881-08-25 42 0 0
122 1881 NL CL2 CLE02 1881-05-06 1881-09-05 42 0 0
123 1881 NL DTN DET01 1881-05-02 1881-09-09 42 0 0
124 1881 NL PRO PRO02 1881-05-02 1881-09-30 43 0 0
125 1881 NL TRN ALB01 1881-06-15 1881-09-10 2 0 0
126 1881 NL TRN TRO01 1881-05-05 1881-09-30 41 0 0
127 1881 NL WOR WOR01 1881-04-30 1881-09-30 42 0 0
128 1882 NL BFN BUF01 1882-05-01 1882-09-26 39 0 0
129 1882 AA BL2 BAL02 1882-05-09 1882-09-30 33 0 0
130 1882 NL BSN BOS01 1882-05-01 1882-09-30 43 0 0
131 1882 NL CHN CHI03 1882-05-10 1882-09-30 45 0 0
132 1882 NL CL2 CLE02 1882-05-01 1882-09-30 42 0 0
133 1882 AA CN2 CIN03 1882-05-02 1882-09-28 42 0 0
134 1882 NL DTN DET01 1882-05-15 1882-09-20 43 0 0
135 1882 AA LS2 LOU02 1882-05-05 1882-09-25 39 0 0
136 1882 AA PH4 PHI03 1882-05-02 1882-09-21 39 0 0
137 1882 NL PRO PRO02 1882-05-01 1882-10-02 42 0 0
138 1882 AA PT1 PIT02 1882-05-10 1882-09-23 37 0 0
139 1882 AA SL4 STL03 1882-05-02 1882-10-01 44 0 0
140 1882 NL TRN ALB01 1882-05-16 1882-05-30 4 0 0
141 1882 NL TRN WAT01 1882-05-20 1882-08-26 38 0 0
142 1882 NL WOR WOR01 1882-05-02 1882-09-29 42 0 0
143 1883 NL BFN BUF01 1883-05-05 1883-09-08 49 0 0
144 1883 AA BL2 BAL03 1883-05-01 1883-09-06 49 0 0
145 1883 NL BSN BOS01 1883-05-30 1883-09-29 49 0 0
146 1883 NL CHN CHI03 1883-05-05 1883-09-08 49 0 0
147 1883 NL CL2 CLE02 1883-05-01 1883-08-22 49 0 0
148 1883 AA CL5 COL01 1883-05-01 1883-09-27 47 0 0
149 1883 AA CN2 CIN03 1883-05-01 1883-09-29 51 0 0
150 1883 NL DTN DET01 1883-05-01 1883-09-03 51 0 0
151 1883 AA LS2 LOU02 1883-05-11 1883-09-30 47 0 0
152 1883 NL NY1 NYC03 1883-05-01 1883-09-29 49 0 0
153 1883 AA NY4 NYC03 1883-05-12 1883-09-06 34 0 0
154 1883 AA NY4 NYC04 1883-05-30 1883-09-04 13 0 0
155 1883 AA PH4 PHI01 1883-05-10 1883-09-07 51 0 0
156 1883 NL PHI PHI04 1883-05-01 1883-09-29 50 0 0
157 1883 NL PRO PRO02 1883-05-30 1883-09-29 49 0 0
158 1883 AA PT1 PIT02 1883-06-12 1883-09-06 32 0 0
159 1883 AA PT1 PIT03 1883-05-01 1883-06-09 17 0 0
160 1883 AA SL4 STL03 1883-05-15 1883-09-30 49 0 0
161 1884 UA ALT ALT01 1884-04-30 1884-05-31 18 0 0
162 1884 NL BFN BUF02 1884-05-21 1884-10-15 58 0 0
163 1884 AA BL2 BAL03 1884-05-01 1884-10-15 57 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);