# Three Measures in the Data Observatory Worth Exploring

We are making so many new measures available through the Data Observatory that we just had to highlight some interesting ones.

## 1. US population with a Master’s Degree

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.

### Grab some geometries

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.

### Add some data

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.

## 2. London area European population born outside the UK and Ireland

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.

### Add some data

Here, we are normalizing the value on the fly with the total population in each area.

## 3. Spaniards age 35 through 39

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).

### Add some data

Again, normalizing on the fly with the total population of the area.

## More

Learn more about all the measures, boundaries, and discovery methods in the Data Observatory over on our documentation page or by watching our webinar!

Happy data analyzing!

###### About the author

Director of Business Architecture at CARTO.

• ## Upgrades improve CARTO platform performance by > 20%

Here at CARTO we are constantly updating our platform so that our customers gain in system performance, reliability and security.

• ## 10,000 Dutch Bridges: A Foray into Using BigQuery Connector

One of my favorite parts about working at CARTO is getting to test out the new features that our product team is constantly shipping. A month or so ago, it was our Kepler c...

• ## Inside CARTO Engineering: Configuration Management Makeover

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...