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)

Suggested facets: url

Link rowid ▼ url ID Federation Form.Fed Transfer Date
1 1 https://ratings.fide.com/fedchange.phtml?year=2000 2019221 USA PHI 12/15/00
2 2 https://ratings.fide.com/fedchange.phtml?year=2000 14401754 BIH CRO 1/31/00
3 3 https://ratings.fide.com/fedchange.phtml?year=2000 14401762 BIH YUG 1/31/00
4 4 https://ratings.fide.com/fedchange.phtml?year=2000 2019221 USA PHI 12/15/00
5 5 https://ratings.fide.com/fedchange.phtml?year=2000 14401754 BIH CRO 1/31/00
6 6 https://ratings.fide.com/fedchange.phtml?year=2000 14401762 BIH YUG 1/31/00
7 7 https://ratings.fide.com/fedchange.phtml?year=2001 6700284 ESA HON 11/15/01
8 8 https://ratings.fide.com/fedchange.phtml?year=2001 1613782 AUT ISR 7/9/01
9 9 https://ratings.fide.com/fedchange.phtml?year=2001 2600536 AUS CAN 11/9/01
10 10 https://ratings.fide.com/fedchange.phtml?year=2001 2603977 CAN YUG 5/25/01
11 11 https://ratings.fide.com/fedchange.phtml?year=2001 2019523 USA AZE 3/30/01
12 12 https://ratings.fide.com/fedchange.phtml?year=2001 2603985 CAN ENG 5/25/01
13 13 https://ratings.fide.com/fedchange.phtml?year=2001 4682084 ITA GER 9/12/01
14 14 https://ratings.fide.com/fedchange.phtml?year=2001 2209381 PAR ESP 12/10/01
15 15 https://ratings.fide.com/fedchange.phtml?year=2001 13601105 USA GEO 2/13/01
16 16 https://ratings.fide.com/fedchange.phtml?year=2001 4613424 SUI GER 12/1/01
17 17 https://ratings.fide.com/fedchange.phtml?year=2001 2604019 CAN YUG 6/9/01
18 18 https://ratings.fide.com/fedchange.phtml?year=2001 933511 YUG BEL 2/7/01
19 19 https://ratings.fide.com/fedchange.phtml?year=2001 3405400 CHI CRO 6/13/01
20 20 https://ratings.fide.com/fedchange.phtml?year=2001 4154142 UKR RUS 1/23/01
21 21 https://ratings.fide.com/fedchange.phtml?year=2001 14900440 SVK LBN 7/5/01
22 22 https://ratings.fide.com/fedchange.phtml?year=2001 4168267 RUS UZB 2/3/01
23 23 https://ratings.fide.com/fedchange.phtml?year=2001 4148932 UKR RUS 10/25/01
24 24 https://ratings.fide.com/fedchange.phtml?year=2001 2019574 USA RUS 4/2/01
25 25 https://ratings.fide.com/fedchange.phtml?year=2001 1308181 SUI AUT 5/20/01
26 26 https://ratings.fide.com/fedchange.phtml?year=2001 6700284 ESA HON 11/15/01
27 27 https://ratings.fide.com/fedchange.phtml?year=2001 1613782 AUT ISR 7/9/01
28 28 https://ratings.fide.com/fedchange.phtml?year=2001 2600536 AUS CAN 11/9/01
29 29 https://ratings.fide.com/fedchange.phtml?year=2001 2603977 CAN YUG 5/25/01
30 30 https://ratings.fide.com/fedchange.phtml?year=2001 2019523 USA AZE 3/30/01
31 31 https://ratings.fide.com/fedchange.phtml?year=2001 2603985 CAN ENG 5/25/01
32 32 https://ratings.fide.com/fedchange.phtml?year=2001 4682084 ITA GER 9/12/01
33 33 https://ratings.fide.com/fedchange.phtml?year=2001 2209381 PAR ESP 12/10/01
34 34 https://ratings.fide.com/fedchange.phtml?year=2001 13601105 USA GEO 2/13/01
35 35 https://ratings.fide.com/fedchange.phtml?year=2001 4613424 SUI GER 12/1/01
36 36 https://ratings.fide.com/fedchange.phtml?year=2001 2604019 CAN YUG 6/9/01
37 37 https://ratings.fide.com/fedchange.phtml?year=2001 933511 YUG BEL 2/7/01
38 38 https://ratings.fide.com/fedchange.phtml?year=2001 3405400 CHI CRO 6/13/01
39 39 https://ratings.fide.com/fedchange.phtml?year=2001 4154142 UKR RUS 1/23/01
40 40 https://ratings.fide.com/fedchange.phtml?year=2001 14900440 SVK LBN 7/5/01
41 41 https://ratings.fide.com/fedchange.phtml?year=2001 4168267 RUS UZB 2/3/01
42 42 https://ratings.fide.com/fedchange.phtml?year=2001 4148932 UKR RUS 10/25/01
43 43 https://ratings.fide.com/fedchange.phtml?year=2001 2019574 USA RUS 4/2/01
44 44 https://ratings.fide.com/fedchange.phtml?year=2001 1308181 SUI AUT 5/20/01
45 45 https://ratings.fide.com/fedchange.phtml?year=2002 13301918 USA ARM 3/5/02
46 46 https://ratings.fide.com/fedchange.phtml?year=2002 13300580 USA ARM 3/7/02
47 47 https://ratings.fide.com/fedchange.phtml?year=2002 14102463 BUL UKR 3/4/02
48 48 https://ratings.fide.com/fedchange.phtml?year=2002 13300105 USA ARM 3/5/02
49 49 https://ratings.fide.com/fedchange.phtml?year=2002 4121138 USA RUS 3/5/02
50 50 https://ratings.fide.com/fedchange.phtml?year=2002 5400082 FRA MNC 3/4/02
51 51 https://ratings.fide.com/fedchange.phtml?year=2002 621790 ESP FRA 8/7/02
52 52 https://ratings.fide.com/fedchange.phtml?year=2002 4149610 GER RUS 6/15/02
53 53 https://ratings.fide.com/fedchange.phtml?year=2002 919101 YUG CAN 3/4/02
54 54 https://ratings.fide.com/fedchange.phtml?year=2002 4110706 GER RUS 11/10/02
55 55 https://ratings.fide.com/fedchange.phtml?year=2002 1206508 ESP ROM 5/17/02
56 56 https://ratings.fide.com/fedchange.phtml?year=2002 406457 JCI ENG 7/24/02
57 57 https://ratings.fide.com/fedchange.phtml?year=2002 1206303 ROM CAN 3/4/02
58 58 https://ratings.fide.com/fedchange.phtml?year=2002 2904276 MKD BUL 4/23/02
59 59 https://ratings.fide.com/fedchange.phtml?year=2002 2212552 HON ESP 8/26/02
60 60 https://ratings.fide.com/fedchange.phtml?year=2002 933953 YUG CAN 3/4/02
61 61 https://ratings.fide.com/fedchange.phtml?year=2002 4143973 UKR RUS 8/10/02
62 62 https://ratings.fide.com/fedchange.phtml?year=2002 14905361 CAN SVK 5/25/02
63 63 https://ratings.fide.com/fedchange.phtml?year=2002 2501031 ENG IRL 1/18/02
64 64 https://ratings.fide.com/fedchange.phtml?year=2002 310204 SVK YUG 6/15/02
65 65 https://ratings.fide.com/fedchange.phtml?year=2002 4152417 UKR RUS 6/10/02
66 66 https://ratings.fide.com/fedchange.phtml?year=2002 4105745 USA RUS 6/7/02
67 67 https://ratings.fide.com/fedchange.phtml?year=2002 14400375 GER BIH 6/7/02
68 68 https://ratings.fide.com/fedchange.phtml?year=2002 8601640 CAN USA 5/20/02
69 69 https://ratings.fide.com/fedchange.phtml?year=2002 5200156 USA PHI 3/5/02
70 70 https://ratings.fide.com/fedchange.phtml?year=2002 14103826 USA UKR 5/15/02
71 71 https://ratings.fide.com/fedchange.phtml?year=2002 13900145 FRA MDA 1/5/02
72 72 https://ratings.fide.com/fedchange.phtml?year=2002 11800097 AUT SMR 3/5/02
73 73 https://ratings.fide.com/fedchange.phtml?year=2002 2803089 CAN ISR 9/15/02
74 74 https://ratings.fide.com/fedchange.phtml?year=2002 1100025 USA POL 8/28/02
75 75 https://ratings.fide.com/fedchange.phtml?year=2002 4109902 ISR RUS 2/21/02
76 76 https://ratings.fide.com/fedchange.phtml?year=2002 13301918 USA ARM 3/5/02
77 77 https://ratings.fide.com/fedchange.phtml?year=2002 13300580 USA ARM 3/7/02
78 78 https://ratings.fide.com/fedchange.phtml?year=2002 14102463 BUL UKR 3/4/02
79 79 https://ratings.fide.com/fedchange.phtml?year=2002 13300105 USA ARM 3/5/02
80 80 https://ratings.fide.com/fedchange.phtml?year=2002 4121138 USA RUS 3/5/02
81 81 https://ratings.fide.com/fedchange.phtml?year=2002 5400082 FRA MNC 3/4/02
82 82 https://ratings.fide.com/fedchange.phtml?year=2002 621790 ESP FRA 8/7/02
83 83 https://ratings.fide.com/fedchange.phtml?year=2002 4149610 GER RUS 6/15/02
84 84 https://ratings.fide.com/fedchange.phtml?year=2002 919101 YUG CAN 3/4/02
85 85 https://ratings.fide.com/fedchange.phtml?year=2002 4110706 GER RUS 11/10/02
86 86 https://ratings.fide.com/fedchange.phtml?year=2002 1206508 ESP ROM 5/17/02
87 87 https://ratings.fide.com/fedchange.phtml?year=2002 406457 JCI ENG 7/24/02
88 88 https://ratings.fide.com/fedchange.phtml?year=2002 1206303 ROM CAN 3/4/02
89 89 https://ratings.fide.com/fedchange.phtml?year=2002 2904276 MKD BUL 4/23/02
90 90 https://ratings.fide.com/fedchange.phtml?year=2002 2212552 HON ESP 8/26/02
91 91 https://ratings.fide.com/fedchange.phtml?year=2002 933953 YUG CAN 3/4/02
92 92 https://ratings.fide.com/fedchange.phtml?year=2002 4143973 UKR RUS 8/10/02
93 93 https://ratings.fide.com/fedchange.phtml?year=2002 14905361 CAN SVK 5/25/02
94 94 https://ratings.fide.com/fedchange.phtml?year=2002 2501031 ENG IRL 1/18/02
95 95 https://ratings.fide.com/fedchange.phtml?year=2002 310204 SVK YUG 6/15/02
96 96 https://ratings.fide.com/fedchange.phtml?year=2002 4152417 UKR RUS 6/10/02
97 97 https://ratings.fide.com/fedchange.phtml?year=2002 4105745 USA RUS 6/7/02
98 98 https://ratings.fide.com/fedchange.phtml?year=2002 14400375 GER BIH 6/7/02
99 99 https://ratings.fide.com/fedchange.phtml?year=2002 8601640 CAN USA 5/20/02
100 100 https://ratings.fide.com/fedchange.phtml?year=2002 5200156 USA PHI 3/5/02

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