pokedics/original/SOURCES.md

Data Sources

For original / canon information, the following sources are used:

• Files pokedex_pokemon.${lang}.dic are fed from Bulbapedia's page of "List of Pokémon in other languages" and from a veekun schema-compatible database listing.
• Files moves.${lang}.dic are fed from Bulbapedia's page of "List of moves in other languages" and from a veekun schema-compatible database listing.
• Other files are fed from Bulbapedia's tabular data pages on internationalization, such as "List of locations in other languages"

The following SQL query, applied to a Veekun "pokedex" schema, extracts in its second column the names for Pokémon in a given ISO language code ("{lang}"):

select P.id, PN.name
FROM
pokemon P 
left join pokemon_species_names PN 
on PN.pokemon_species_id = P.id  
join languages L on PN.local_language_id=L.id
and L.identifier={lang}
where P.id is not null 
order by P.id, L.id