Chess Player Federation Transfers

Transfers of Chess Players Between National Federations

@fivethirtyeight.chess_transfers

Chess Player Federation Transfers

@fivethirtyeight.chess_transfers.transfers

Column	Description
url	Source URL with details about the player's federation transfer
ID	Unique identifier for the player
Federation	Player's new (receiving) federation
Form.Fed	Player's previous (former) federation
Transfer Date	Date when the transfer was completed

url Url	id ID	federation Federation	form_fed Form.Fed	transfer_date Transfer Date
https://ratings.fide.com/fedchange.phtml?year=2000	2019221	USA	PHI	Fri Dec 15 2000 00:00:00 GMT+0000 (Coordinated Universal Time)
https://ratings.fide.com/fedchange.phtml?year=2000	14401754	BIH	CRO	Mon Jan 31 2000 00:00:00 GMT+0000 (Coordinated Universal Time)
https://ratings.fide.com/fedchange.phtml?year=2000	14401762	BIH	YUG	Mon Jan 31 2000 00:00:00 GMT+0000 (Coordinated Universal Time)
https://ratings.fide.com/fedchange.phtml?year=2000	2019221	USA	PHI	Fri Dec 15 2000 00:00:00 GMT+0000 (Coordinated Universal Time)
https://ratings.fide.com/fedchange.phtml?year=2000	14401754	BIH	CRO	Mon Jan 31 2000 00:00:00 GMT+0000 (Coordinated Universal Time)
https://ratings.fide.com/fedchange.phtml?year=2000	14401762	BIH	YUG	Mon Jan 31 2000 00:00:00 GMT+0000 (Coordinated Universal Time)
https://ratings.fide.com/fedchange.phtml?year=2001	6700284	ESA	HON	Thu Nov 15 2001 00:00:00 GMT+0000 (Coordinated Universal Time)
https://ratings.fide.com/fedchange.phtml?year=2001	1613782	AUT	ISR	Mon Jul 09 2001 00:00:00 GMT+0000 (Coordinated Universal Time)
https://ratings.fide.com/fedchange.phtml?year=2001	2600536	AUS	CAN	Fri Nov 09 2001 00:00:00 GMT+0000 (Coordinated Universal Time)
https://ratings.fide.com/fedchange.phtml?year=2001	2603977	CAN	YUG	Fri May 25 2001 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE transfers (
  "url" VARCHAR,
  "id" BIGINT,
  "federation" VARCHAR,
  "form_fed" VARCHAR,
  "transfer_date" TIMESTAMP
);

Anyone who has the link will be able to view this.