(
(

cat $DILIB_IMPORT/Wicri/Data/Europe/RegionForCountryEuropeFr.wiki
cat $DILIB_IMPORT/Wicri/Data/Amerique/regionsAmeriqueFr.wiki
cat $DILIB_IMPORT/Wicri/Data/Asie/regionsAsieFr.wiki

) |  MediaWikiCleanTable                                        \
  |  MediaWikiTable2SxmlRowCol                                   \
  |  MediaWikiTableTransformCol -T1 -E2             \
  | SxmlSelect -s r/c1/i/1 -g r/c2/country -g r/c2/region -p @s1 -p "<place>@g1<placeName>@g2</placeName></place>"


cat $DILIB_IMPORT/Wicri/Data/Amerique/UsaEtatsFr.wiki       \
  | MediaWikiCleanTable                                     \
  |  MediaWikiTable2SxmlRowCol                              \
  |  MediaWikiTableTransformCol -k3 -V1                     \
  | SxmlSelect -p "@1 USA" -p "<place><country>États-Unis</country><placeName><region type=\"state\">@2</region></placeName></place>"  \
) | sort
