I need to match cities/postal codes from a large dataset with their regions (NUTS3 if available, otherwise administrative divisions as can be found here https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country). Cities can be all around the world and have all sizes.
I've come across that OSM provides regions for all(?) cities. Searching for a small village in Germany ('Unterkirnach'), I get the following result: Village Unterkirnach, Verwaltungsgemeinschaft Villingen-Schwenningen, Schwarzwald-Baar-Kreis, Regierungsbezirk Freiburg, Baden-Württemberg, Germany
That's all the information I need, namely administrative divisions on several levels, and it also seems to work for small towns, e.g., in China.
However, I would need to extract a list/table of towns and their assignment to regions worldwide in order to upload it to my database and to look up the regions of the cities in my dataset. At this point, I do not want to do any 'fancy' stuff I do not understand, I simply want to create a table with as many cities as possible and columns for their administrative regions on different levels.
Does anyone have an idea how to do this?