Ausländer in Deutschland

Ich habe Daten über in Deutschland ansässige Ausländer gefunden. Solche Daten gibt es schon seit langer Zeit, denn Deutschland hat mindestens seit dem Mittelalter das „Meldewesen“:  alle müssen sich in der Stadt, in der sie wohnen, melden, auch die Deutschen – einfach so vor sich hin leben geht nicht!

Aus diesen Daten habe ich eine Visualisierung gebastelt. Vieles daran kann man sich durch anklicken genauer anschauen.

Was ihr jetzt sehen könnt:

  - Migration früher und heute. Ihr müsst dabei aber vorsichtig sein, denn das alte Deutsche Reich, die Bundesrepublik bis 1990 und die Bundesrepublik nach 1990 sind  hinsichtlich ihres Staatsgebiets und hinsichtlich ihrer Bevölkerung sehr unterschiedlich. Ich mag aber alte Daten und wollte euch die vom Deutschen Reich nicht vorenthalten.

  -  Ausländeranteil je 1000 Einwohner.

  - Anteil der (ausländischen) Frauen je 1000 männliche Ausländer. Das zeigt die Genderstruktur der Einwanderung.

  - Ausländer nach Staatsangehörigkeit und Bundesländern. Italiener zum Beispiel werden im Norden Deutschlands immer seltener. Und: Berlin ist klar eine  „Ausländerstadt“, das benachbarte Brandenburg hingegen ….

  - Ausländer nach Staatsangehörigkeit und Geschlecht.

Energy from renewable sources in the EU

Eurostat has published statistics on renewable energy sources in the European Union.

Below my data visualization showing how countries are dealing with their energy targets.

Велодорожки Москвы / Cycle lanes of Moscow

Портал открытых данных правительства Москвы опубликовал географические координаты московских велодорожек.
Общая длина велодорожек состоит 111 км. Самая длинная велодорожка находится в парке «Лосиный Остров».

Я хотела сделать карту поинтереснее и добавить другие данные к велосипедным геоданным, но не нашла ничего подходящего.

На моей карте можно включить Street View чтобы увидеть фотографии.
========================================================

English version :)

Something old, something new

I'm totally addicted to archaeological documentaries. My favourite archaeological site is Göbekli Tepe, google it, it's just WOW. In July 2014 Klaus Schmidt, who headed the excavations at the site, passed away. I started to thinking about doing something in this field. I wanted to analyse some data devoted to Göbekli Tepe, but I couldn't find anything. Archaeological data published in the internet are rarity.

How the world has changed from 1960, population comparator

I was playing with population data but I wanted to do something different so I took into account data for a long period.

I prepared population comparator, a tool to compare how the growth of population proceed in countries. Don't get wild and don't select too many countries as it will be impossible to see anything.

Cycling in London

I've done a cycling map of London.
Not everything was as I planned. I was searching for a line shape file of the London's cycle lanes, as logical would be adding length of cycle lanes per ward or any data set saying about an average commuting distance to work. I asked Transport for London and a few cycling organizations based in London for the shape file but nobody was able to help me.

Ethnic minorities in Russia

I've found the old census data from 1926 and decided to give them a new life by comparing to the newest census.

I haven't included all ethnic minorities in Russia as there're some mistakes in the old censuses, I've checked all censuses between 1926 and 2010, some ethnic groups're in a few first censuses then they just disappeared and appeared again. Of course it made me crazy but life is like this. As a result of this predictable problem with the old censuses, I decide to use in my visualization only the biggest ethnic groups.

Ethnic groups in Russia

Russia is home to over 185 ethnic groups, population of these groups vary from millions to few thousands. In some regions Russians are in the minority.

This topic is rich in data so later I will post more works.

Top 30 countries with the highest military expenditure in 2013

Stockholm International Peace Research Institute (SIPRI) has published military expenditure for 2013. Global military expenditure totalled $1.75 trillion.

Just two states, USA and China, made nearly half of all military spending.

Gazprom's natural gas export structure to European and FSU countries in 2012

The largest buyers of the Russian gas were Germany (16% of Gazprom's export), Ukraine (15%), Turkey (12%) and Belarus (9%).

Gazprom Group in 2012 sold in total 151 bcm of natural gas to European countries and 66 bcm to FSU countries.

The data have been published by Gazprom in Gazprom in Figures 2008-2012. 

Terrorist attacks in Russia since 1991

The researchers at the University of Maryland have created the world's largest database of terrorists attacks.
Between 1991 and 2012, there were 1,895 attacks in Russia.

In my dataviz I used data published by the Guardian.
I would like to add the data for 2013, hope to get them somewhere...

Migration between prefectures of Japan in 2012

You can check flows of the three streams:

1. In-migration: the Japanese moving into one prefecture from another place within the country.
2. Out-migration: the Japanese moving out of one prefecture to another place within the country.
3. Net internal migration: the difference between in-migration and out-migration.

The most cycle friendly European countries

The Netherlands and Denmark have been named the most cycle friendly countries in Europe by the European Cyclist Federation (ECF).

Countries were judge on five criteria:

1. market (bicycle sales per 1000 inhabitants)
2. modal share (cycling as main mode of transport % of population)
3. activists (ECF individual members per million inhabitants)
4. safety (number of death per 100,000 cyclists)
5. tourism (total trips per head)

Points were awarded based on a country's ranking in each category and added to give the overall scores.

Crime in London

This post was created thanks to London's Metropolitan Police, that published crime data for London's boroughs. Their data base consists even such details like number of stolen bicycles.

Crime rates (Rates per thousand population) were calculated according to: (crime / the resident population)*1000. Many boroughs have very high daytime population, so the resident population is only a fraction of the daytime population and that makes the crime rate so high in some boroughs.

Hope to see such data for other cities.

New York City Population by Boroughs

New York is the most populous city in the United States, more than twice the size of the second largest city, Los Angeles.

In the period from 2000 to 2010 all five of New York's boroughs saw growth:

• Staten Island 5.6%
• The Bronx 3.9%
• Manhattan 3.2%
• Brooklyn 1.6%
• Queens 0.1%

Differences in price levels for food, beverages and tobacco across Europe

Eurostat published Comparative price levels for food, beverages and tobacco.

Denmark had the highest price level for food in the EU27 in 2012, at 139% of the EU27 average, followed by Sweden (124%). The lowest price levels were observed in Poland (60%) and Romania.


Abbreviations:
HFCE - total household final consumption expenditure
EA17 - the euro area
EU27 - the European Union

Mysterious Lake Baikal

The Lake Baikal is not so mysterious anymore, one riddle has been solved, how infrastructure for eco-tourism was created.

The Great Baikal Trail was created to develop system of environmental trails around Lake Baikal. The projects are based on work done by volunteers from all over the world; Russia, Australia, Germany, Spain, Italy, France, the Netherlands, United States, Canada, Mongolia, and many more places.

To show the amount of work done in different areas of the lake I used:

• number of volunteers involved,
• man-days (=number of volunteers*number of projects' days).

I encourage you to interact with my visualization and take part in the Baikal's projects.

This data visualization is truly international:
- The data are from The Great Baikal Trail, a Russian interregional community organization.
- I am taking part in Tableau Software contest, which is open to residents of few countries so I am representing Germany :)
- The viz was done with use of American software and Russian Yandex maps :)

Suicide in Turkey

The latest statistics recorded in 2011 show that 1,876 males and 801 females committed suicide in Turkey.

The suicide rate for every 100,000 citizens is 3.58.

Half of females who commit suicide in the country are under the age of 30, half of males are under 40.

Source of data: TurkStat.

The development of the St. Petersburg underground

The St. Petersburg underground has been opened since 1955. The underground system is one of the deepest in the world, the deepest station is Admiralteyskay (86 metres below ground).

Internet users by country

Internet time machine showing the percentage of internet users from 1997 to 2011.