Data edit

I tried to see if the data to answer this question might already be in Wikidata.

SELECT ?personLabel  ?positionLabel ?DOB ?DOD

WHERE {

 ?person wdt:P106 wd:Q19204627.
 ?person wdt:P413 ?position.
  ?person wdt:P569 ?DOB .
 ?person wdt:P570 ?DOD .
 
 SERVICE wikibase:label {

bd:serviceParam wikibase:language "en" .

}

 }

It looks like we are missing the occupation data for many people. This data isn't in Wikidata yet, but it is in English Wikipedia.

We can use the PetScan tool to get pages that are in certain categories. There is a manual for the tool that explains how to use it.

We can find some useful categories here Category:National_Football_League_players_by_team

I used PetScan to find all players in the category Category:San_Diego_Chargers_players. I then used the page titles for each of the pages for the players from the category to create a column in a new Google Sheets sheet. There is an add-on for Google Sheets for Wikipedia. Using the formula from the Wikipedia Tools add on =WIKIDATAQID for each cell in the column for the page titles, the add on will fetch corresponding QID values.

I can then add additional columns in the spreadsheet to get ready to use the Quick Statements tool. The Quick Statements tool allows us to make many statements at once by copying a spreadsheet into the tool text box.

The columns for the spreadsheet are:

WikidataQID	occupation	American football player	imported from	English Wikipedia
Q	P106	Q19204627	S143	Q328

We also need to add data from https://en.wikipedia.org/wiki/Category:Players_of_American_football_by_position.

ENWP Category	Status	Editor	Date complete
San_Diego_Chargers_players	done	hweyl	Jan 16
New_Orleans_Saints_players	done	hweyl	Jan 21
New_England_Patriots_players	done	hweyl	Jan 21
San_Francisco_49ers_players	done	hweyl	Jan 21
Oakland_Raiders_players	done	hweyl	Jan 22
Kansas_City_Chiefs_players	done	hweyl	Jan 22
Arizona_Cardinals_players	done	hweyl	Jan 22
Denver_Broncos_players	done	hweyl	Jan 22
Green_Bay_Packers_players	done	hweyl	Jan 22
Chicago_Bears_players	done	hweyl	Jan 22
New York Giants players	done	hweyl	Jan 28
St Louis Rams players	done	hweyl	Jan 28
Pittsburgh Steelers players	done	hweyl	Jan 28
Potomac_Drainage_Basin_Indigenous_Persons_players	done	hweyl	Jan 28
Tennessee_Titans_players	done	hweyl	Jan 28
Tampa_Bay_Buccaneers_players	done	hweyl	Jan 29
Philadelphia_Eagles_players	done	hweyl	Jan 29
New_York_Jets_players	done	hweyl	Jan 29
Minnesota_Vikings_players	done	Hackfish	Jan 29
Miami_Dolphins_players	done	Hackfish	Jan 29
Jacksonville_Jaguars_players	done	Hackfish	Jan 29
Indianapolis_Colts_players	done	Hackfish	Jan 29
Detroit_Lions_players	done	Hackfish	Jan 29
Houston_Texans_players	done	Hackfish	Jan 29
Dallas_Cowboys_players	done	Hackfish	Jan 29
Cincinnati_Bengals_players	done	Hackfish	Jan 29
Carolina_Panthers_players	done	Hackfish	Jan 29
Cleveland_Browns_players	done	Hackfish	Jan 29
Buffalo_Bills_players	done	Hackfish	Jan 29
Baltimore_Ravens_players	done	Hackfish	Jan 29
Atlanta_Falcons_players	done	Hackfish	Jan 29
Seattle_Seahawks_players	done	Hackfish	Jan 20

User:Hweyl/football

Data edit