We are making so many new measures available through the Data Observatory that we just had to highlight some interesting ones.
The supply and demand ratio for PhDs has gone crazy in recent years. At the same time there are alternative voices that are doubting the utility of higher education for many types of people. We’re not sure what sort of effect these types of stories will have over the long-run. But for sure, we can identify populations worth keeping an eye on. Here’s one for example, the population count that holds a Master’s Degree.
Here we will grab an area around Baltimore defined by a custom bounding box and insert them into an empty table we created in our CARTO dashboard. We are using the nice clipped geometries released previously.
Next, we’ll add a numeric column called,
masters_degree and populate it with values from the Data Observatory. We can request the data in two ways, raw counts,
Or normalize it on the fly with Population over 25.
With the Brexit vote come and gone, a lot of people are digging into the data to better understand how it came to be and what impacts are coming. The Data Observatory is full of measures to help. Here is one that is particularly interesting, Population born in Europe but outside of the UK or Ireland.
Here, we are normalizing the value on the fly with the total population in each area.
This is an interesting Measure for a number of reasons. Age data in Spain is of particular interest. While the life expectancy grows the predominant age groups get younger. If you look at the map above, you find that cities are young, while the surrounding country is aging. We like to share this map so that we can remind the CARTO’ers in Madrid to go visit their parents. If we had to pick one Measure from Spain though, the 35 through 39 year old group has got to be it. It’s one of the most populous age bins, but is slowly losing the lead to the 30-34 group. Go find out where these people are.
For Data Observatory users, this is how you’ll add a column that counts the number of Spanish people from 35 through 35 in an area (or a rate for a point).
Again, normalizing on the fly with the total population of the area.
Happy data analyzing!
Our primary goal at CARTO is to be the world’s leading Location Intelligence platform, empowering our clients with the best data and the best spatial analysis. We frequentl...Core Tech
Please fill out the below form and we'll be in touch real soon.