Chess Transfers: transfers.csv

Table actions

This table contains data behind the story American Chess Is Great Again.

Headers Description
url Source Data
ID Player ID
Federation Player's new federation
Form.Fed Player's former federation
Transfer Date Date of transfer

Data was collected from FIDE.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

932 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ url ID Federation Form.Fed Transfer Date
101 101 https://ratings.fide.com/fedchange.phtml?year=2002 14103826 USA UKR 5/15/02
102 102 https://ratings.fide.com/fedchange.phtml?year=2002 13900145 FRA MDA 1/5/02
103 103 https://ratings.fide.com/fedchange.phtml?year=2002 11800097 AUT SMR 3/5/02
104 104 https://ratings.fide.com/fedchange.phtml?year=2002 2803089 CAN ISR 9/15/02
105 105 https://ratings.fide.com/fedchange.phtml?year=2002 1100025 USA POL 8/28/02
106 106 https://ratings.fide.com/fedchange.phtml?year=2002 4109902 ISR RUS 2/21/02
107 107 https://ratings.fide.com/fedchange.phtml?year=2003 8100977 MAR JOR 4/3/03
108 108 https://ratings.fide.com/fedchange.phtml?year=2003 14100878 FRA UKR 3/15/03
109 109 https://ratings.fide.com/fedchange.phtml?year=2003 3501728 USA CUB 5/7/03
110 110 https://ratings.fide.com/fedchange.phtml?year=2003 12802212 USA LTU 9/6/03
111 111 https://ratings.fide.com/fedchange.phtml?year=2003 401374 JAP ENG 6/9/03
112 112 https://ratings.fide.com/fedchange.phtml?year=2003 1902334 ECU POR 2/3/03
113 113 https://ratings.fide.com/fedchange.phtml?year=2003 3501868 ESP CUB 8/25/03
114 114 https://ratings.fide.com/fedchange.phtml?year=2003 2222345 AND ESP 7/23/03
115 115 https://ratings.fide.com/fedchange.phtml?year=2003 2900262 AUT BUL 9/29/03
116 116 https://ratings.fide.com/fedchange.phtml?year=2003 2900106 PLE BUL 10/3/03
117 117 https://ratings.fide.com/fedchange.phtml?year=2003 14501570 YUG CRO 5/28/03
118 118 https://ratings.fide.com/fedchange.phtml?year=2003 14109042 GER RUS 3/15/03
119 119 https://ratings.fide.com/fedchange.phtml?year=2003 1404679 ISL DEN 12/6/03
120 120 https://ratings.fide.com/fedchange.phtml?year=2003 4629400 AUT GER 10/16/03
121 121 https://ratings.fide.com/fedchange.phtml?year=2003 13300512 USA ARM 2/19/03
122 122 https://ratings.fide.com/fedchange.phtml?year=2003 4142217 CZE RUS 9/3/03
123 123 https://ratings.fide.com/fedchange.phtml?year=2003 4183150 ITA RUS 3/18/03
124 124 https://ratings.fide.com/fedchange.phtml?year=2003 1212290 CAN ROM 2/3/03
125 125 https://ratings.fide.com/fedchange.phtml?year=2003 11600098 BAN LAT 2/11/03
126 126 https://ratings.fide.com/fedchange.phtml?year=2003 910775 AUS YUG 4/29/03
127 127 https://ratings.fide.com/fedchange.phtml?year=2003 4300475 AUS NZL 3/20/03
128 128 https://ratings.fide.com/fedchange.phtml?year=2003 14400596 GER BIH 8/25/03
129 129 https://ratings.fide.com/fedchange.phtml?year=2003 13501151 AUS BLR 9/19/03
130 130 https://ratings.fide.com/fedchange.phtml?year=2003 13601040 GER GEO 12/6/03
131 131 https://ratings.fide.com/fedchange.phtml?year=2003 900060 ESP YUG 11/28/03
132 132 https://ratings.fide.com/fedchange.phtml?year=2003 1902237 ECU POR 2/3/03
133 133 https://ratings.fide.com/fedchange.phtml?year=2003 14508630 AUT CRO 12/26/03
134 134 https://ratings.fide.com/fedchange.phtml?year=2003 724351 RUS ISR 9/25/03
135 135 https://ratings.fide.com/fedchange.phtml?year=2003 8100977 MAR JOR 4/3/03
136 136 https://ratings.fide.com/fedchange.phtml?year=2003 14100878 FRA UKR 3/15/03
137 137 https://ratings.fide.com/fedchange.phtml?year=2003 3501728 USA CUB 5/7/03
138 138 https://ratings.fide.com/fedchange.phtml?year=2003 12802212 USA LTU 9/6/03
139 139 https://ratings.fide.com/fedchange.phtml?year=2003 401374 JAP ENG 6/9/03
140 140 https://ratings.fide.com/fedchange.phtml?year=2003 1902334 ECU POR 2/3/03
141 141 https://ratings.fide.com/fedchange.phtml?year=2003 3501868 ESP CUB 8/25/03
142 142 https://ratings.fide.com/fedchange.phtml?year=2003 2222345 AND ESP 7/23/03
143 143 https://ratings.fide.com/fedchange.phtml?year=2003 2900262 AUT BUL 9/29/03
144 144 https://ratings.fide.com/fedchange.phtml?year=2003 2900106 PLE BUL 10/3/03
145 145 https://ratings.fide.com/fedchange.phtml?year=2003 14501570 YUG CRO 5/28/03
146 146 https://ratings.fide.com/fedchange.phtml?year=2003 14109042 GER RUS 3/15/03
147 147 https://ratings.fide.com/fedchange.phtml?year=2003 1404679 ISL DEN 12/6/03
148 148 https://ratings.fide.com/fedchange.phtml?year=2003 4629400 AUT GER 10/16/03
149 149 https://ratings.fide.com/fedchange.phtml?year=2003 13300512 USA ARM 2/19/03
150 150 https://ratings.fide.com/fedchange.phtml?year=2003 4142217 CZE RUS 9/3/03
151 151 https://ratings.fide.com/fedchange.phtml?year=2003 4183150 ITA RUS 3/18/03
152 152 https://ratings.fide.com/fedchange.phtml?year=2003 1212290 CAN ROM 2/3/03
153 153 https://ratings.fide.com/fedchange.phtml?year=2003 11600098 BAN LAT 2/11/03
154 154 https://ratings.fide.com/fedchange.phtml?year=2003 910775 AUS YUG 4/29/03
155 155 https://ratings.fide.com/fedchange.phtml?year=2003 4300475 AUS NZL 3/20/03
156 156 https://ratings.fide.com/fedchange.phtml?year=2003 14400596 GER BIH 8/25/03
157 157 https://ratings.fide.com/fedchange.phtml?year=2003 13501151 AUS BLR 9/19/03
158 158 https://ratings.fide.com/fedchange.phtml?year=2003 13601040 GER GEO 12/6/03
159 159 https://ratings.fide.com/fedchange.phtml?year=2003 900060 ESP YUG 11/28/03
160 160 https://ratings.fide.com/fedchange.phtml?year=2003 1902237 ECU POR 2/3/03
161 161 https://ratings.fide.com/fedchange.phtml?year=2003 14508630 AUT CRO 12/26/03
162 162 https://ratings.fide.com/fedchange.phtml?year=2003 724351 RUS ISR 9/25/03
163 163 https://ratings.fide.com/fedchange.phtml?year=2004 11601230 RUS LAT 6/29/04
164 164 https://ratings.fide.com/fedchange.phtml?year=2004 13300474 ARM GER 5/14/04
165 165 https://ratings.fide.com/fedchange.phtml?year=2004 2806770 CAN ISR 6/26/04
166 166 https://ratings.fide.com/fedchange.phtml?year=2004 5201179 AUS PHI 6/27/04
167 167 https://ratings.fide.com/fedchange.phtml?year=2004 726916 GRE HUN 7/22/04
168 168 https://ratings.fide.com/fedchange.phtml?year=2004 4695330 LIE GER 7/28/04
169 169 https://ratings.fide.com/fedchange.phtml?year=2004 2900017 BUL MKD 9/30/04
170 170 https://ratings.fide.com/fedchange.phtml?year=2004 1310364 FRA SUI 11/15/04
171 171 https://ratings.fide.com/fedchange.phtml?year=2004 5300363 PLE LBN 4/14/04
172 172 https://ratings.fide.com/fedchange.phtml?year=2004 2022656 JPN USA 2/9/04
173 173 https://ratings.fide.com/fedchange.phtml?year=2004 4127390 GER RUS 8/31/04
174 174 https://ratings.fide.com/fedchange.phtml?year=2004 14901510 BER SVK 6/29/04
175 175 https://ratings.fide.com/fedchange.phtml?year=2004 4109562 GER RUS 3/23/04
176 176 https://ratings.fide.com/fedchange.phtml?year=2004 13300610 RUS ARM 1/6/04
177 177 https://ratings.fide.com/fedchange.phtml?year=2004 14111330 SLO UKR 6/30/04
178 178 https://ratings.fide.com/fedchange.phtml?year=2004 14100657 GER UKR 8/31/04
179 179 https://ratings.fide.com/fedchange.phtml?year=2004 3501841 USA CUB 3/17/04
180 180 https://ratings.fide.com/fedchange.phtml?year=2004 5300363 USA   4/14/04
181 181 https://ratings.fide.com/fedchange.phtml?year=2004 13500996 SWE BLR 2/17/04
182 182 https://ratings.fide.com/fedchange.phtml?year=2004 13400584 RUS AZE 1/22/04
183 183 https://ratings.fide.com/fedchange.phtml?year=2004 11601230 RUS LAT 6/29/04
184 184 https://ratings.fide.com/fedchange.phtml?year=2004 13300474 ARM GER 5/14/04
185 185 https://ratings.fide.com/fedchange.phtml?year=2004 2806770 CAN ISR 6/26/04
186 186 https://ratings.fide.com/fedchange.phtml?year=2004 5201179 AUS PHI 6/27/04
187 187 https://ratings.fide.com/fedchange.phtml?year=2004 726916 GRE HUN 7/22/04
188 188 https://ratings.fide.com/fedchange.phtml?year=2004 4695330 LIE GER 7/28/04
189 189 https://ratings.fide.com/fedchange.phtml?year=2004 2900017 BUL MKD 9/30/04
190 190 https://ratings.fide.com/fedchange.phtml?year=2004 1310364 FRA SUI 11/15/04
191 191 https://ratings.fide.com/fedchange.phtml?year=2004 5300363 PLE LBN 4/14/04
192 192 https://ratings.fide.com/fedchange.phtml?year=2004 2022656 JPN USA 2/9/04
193 193 https://ratings.fide.com/fedchange.phtml?year=2004 4127390 GER RUS 8/31/04
194 194 https://ratings.fide.com/fedchange.phtml?year=2004 14901510 BER SVK 6/29/04
195 195 https://ratings.fide.com/fedchange.phtml?year=2004 4109562 GER RUS 3/23/04
196 196 https://ratings.fide.com/fedchange.phtml?year=2004 13300610 RUS ARM 1/6/04
197 197 https://ratings.fide.com/fedchange.phtml?year=2004 14111330 SLO UKR 6/30/04
198 198 https://ratings.fide.com/fedchange.phtml?year=2004 14100657 GER UKR 8/31/04
199 199 https://ratings.fide.com/fedchange.phtml?year=2004 3501841 USA CUB 3/17/04
200 200 https://ratings.fide.com/fedchange.phtml?year=2004 5300363 USA   4/14/04

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "chess-transfers/transfers" (
"url" TEXT,
  "ID" INTEGER,
  "Federation" TEXT,
  "Form.Fed" TEXT,
  "Transfer Date" TEXT
);