Data Design on Identical Columns

[Djtimestamp]

I have 5 tables that have the same columns (8 columns) with different columns.

Different demographic information for different places.. 

From my understanding, it's not an efficient design to append all the tables to 1 large dataset. This is how I have it setup currently to get the data cards I wanted.

what's the way to design the relationships so that I can put data cards that calculate off all of the data? Is it just a ton of many to many relationships and create some sort of unique id in the queries? 

[Idrissshatila · Accepted solution]

Hello @Djtimestamp ,

it's better to append them all in one table.