Where do the world's wealthiest individuals live? Well, it depends if you're talking millionaires, multi-millionaires or billionaires, according to a new list of the global rich.

Tokyo may contain the most millionaires (US$), however London is the city with the highest number of multi-millionaires - defined as individuals with over $30m each. For the fattest of the fat cats, though, look to New York where 70 billionaires have made their home - or maybe one of their many global homes.

The ranking of top global cities for millionaires, multi-millionaires and billionaires has been compiled by London based wealth consultancy WealthInsight using five years of data analysed by their team. So what insights can we glean from this latest rich list?

Tokyo tops the list with 461,000 millionaires at the end of 2012, followed by New York City with 389,000. London and Paris take third and fourth place respectively with Frankfurt, Beijing, Osaka, Hong Kong and Shanghai making up the the remainder of the top ten. Interestingly the second highest city for billionaires, Moscow, comes in 20th for its number of millionaires.

The report also looks at the proportion of each country's millionaires in each city. Tokyo accounts for 21% of Japan's millionaires whereas New York City accounts for only 7% of US millionaires. Cities with much higher proportions include Seoul (83%), Rome (49%) and London (42%).

Now for the big players, those individuals with over $30m each. London is top of the list as the city with the most multi-millionaires (4,224) but Tokyo and Singapore follow in second and third place respectively.

New York makes an appearance at fourth place on the rankings – but if you're surprised by the Big Apple's slip down the rich list, WealthInsight do point out that 'many wealthy New Yorkers live off the Island in cities such as Greenwich which has over 350 multi-millionaires on its own'.

New York (Manhattan) contains the most billionaires according to the release with 70 in the city. Moscow has 64 billionaires and London boasts 54.

Moscow, Mumbai and Istanbul are significantly higher on the billionaire list than they are on the millionaire rankings. Moscow which is ranked 20th for millionaires and is absent from the top 20 cities for multi-millionaires, comes in at third place on the billionaires list.

Hong Kong, Beijing, Mumbai, Istanbul, Shanghai, Paris and Los Angeles all make it into the top ten.

Despite Tokyo topping the list as the city with the highest total of millionaires, when it comes to country level the US boasts the most with 5,231 in 2012 – a figure WealthInsight expects to jump to 7,318 by 2020.

But the country to watch according to the wealth consultancy is China. They predict that it will overtake Japan and Germany to become the second largest wealth market in the world by 2020. India is also expected to rise up the rankings, from 11th place in 2012 to 5th place in 2020.

The tables below show the top ten cities for millionaires, multi-millionaires and billionaires. The downloadable spreadsheet contains data at country level and the proportion of country's millionaires in each city. What can you do with this?

Data summary

Cities ranked by millionaires Click heading to sort table. Download this data Rank City Number of millionaires 1 Tokyo 461000 2 New York City (Manhattan) 389000 3 London 281000 4 Paris 219000 5 Frankfurt 217000 6 Beijing 213000 7 Osaka 190000 8 Hong Kong 187000 9 Shanghai 166000 10 Singapore 157000 11 Seoul 131000 12 Munich 130000 13 Rome 127000 14 Los Angeles 126000 15 Toronto 118000 16 Chicago 107000 17 Sydney 104000 18 Houston 103000 19 Mexico City 102000 20 Moscow 101000

Cities ranked by multi-millionaires Click heading to sort table. Download this data Rank City Number of multi-millionaires 1 London 4224 2 Tokyo 3525 3 Singapore 3154 4 New York City (Manhattan) 2929 5 Hong Kong 2560 6 Frankfurt 1868 7 Mexico City 1850 8 Paris 1500 9 Osaka 1450 10 Beijing 1318 11 Zurich 1314 12 Sao Paulo 1310 13 Seoul 1302 14 Taipei 1255 15 Toronto 1184 16 Geneva 1156 17 Munich 1113 18 Shanghai 1028 19 Los Angeles 950 20 Rome 945

Cities ranked by billionaires Click heading to sort table. Download this data Rank City Number of billionaires 1 New York (Manhattan) 70 2 Moscow 64 3 London 54 4 Hong Kong 40 5 Beijing 29 6 Mumbai 26 7 Istanbul 24 8 Shanghai 23 9 Paris 22 10 Los Angeles 19 11 Shenzhen 19 12 Chicago 15 13 Singapore 13 14 Tokyo 12 15 Guangzhou 12 16 San Francisco 11 17 Dallas 11 18 Dubai 11 19 Houston 10 20 Sao Paulo 10

• DATA: download the full spreadsheet

More data

More data journalism and data visualisations from the Guardian

• Follow us on Twitter

• Like us on Facebook