I exported all the data that Google Maps and uploaded it to @graphext.bsky.social to answer a question I constantly ask myself: How much time have I spent in Madrid compared to Granada over the past seven years? It turns out I've spent roughly 30% of my time in Granada and 70% in Madrid.

Very interesting! Madrid now receives almost x3 as many national tourists as Barcelona, even though Barcelona gets over a million more international tourists each year than Madrid Also curious Zaragoza gets x3 more national tourism than international. Data INE + analysis with @graphext.bsky.social

Another great piece by Civio explaining how Spain’s prison permit algorithm works—and its biases. It hasn’t been updated since 1993!

I find it pretty amazing that almost every home in Madrid has a metro station within 300 meters on average, and only 25% are more than 500 meters away. Across the entire city! Data from Idealista on @graphext.bsky.social

If you’ve never heard of How To with John Wilson, do yourself a favor and put it on tonight or this weekend on HBO Max. One of the most underrated shows in history. They’re like mini-documentaries about everyday life in New York.

I love nonfiction books that are under 100 pages. I’ve downloaded over 2M books and reviews from Goodreads. What I’ve found is that less than 5% of nonfiction books published are under 100 pages. As you can see in this chart I created with @graphext.bsky.social , they tend to be much more popular!

I have salespeople chasing me all day trying to sell me B2B software through LinkedIn, cold calls while I spend my day chasing plumbers to get things fixed at home. Capitalism is sending a signal, AI writes code so well but robot hands still can’t quite manage to properly connect two pipes!

📣 New paper in Nature Human Behavior @natureportfolio.bsky.social! Using large-scale mobility data, we find how businesses, amenities, and other urban places depend on each other. It reveals connections that aren’t always visible but have substantial economic impacts. www.nature.com/articles/s41...

Ah shit, here we go again

Here’s a great Sunday long read with excellent ideas on how to change the world as an individual, without using the excuse of not being a powerful politician or a billionaire with lots of money: www.experimental-history.com/p/underrated...

Taking advantage of the honeymoon in Thailand to complete the final test for the official PostgreSQL certification…

At what age did you learn that pineapples grow on the ground, on top of other pineapples? Traveling through northern Thailand.

Bangkok this morning

Just landed in Bangkok! The roads are full of spam!

It’s pretty incredible how fast Qatar Airways’ free Wi-Fi with Starlink is. I can’t decide if it’s great or terrible news that the last refuge of disconnection—long-haul flights—is vanishing

Yesterday, @martasvm.bsky.social and I celebrated @bsky.app growth—and we also decided to get married! 😂

Look how quick and easy it is now to add a percentage change 📈 to a time series chart you’re viewing in @graphext.bsky.social with just one click. 😍 www.youtube.com/watch?v=0Awn...

November is the month when temperatures in Madrid change the most drastically. They dropped by 33% compared to October. The data comes from 100 years of temperature readings taken from the AEMET thermometer in El Retiro park, accessed via their API and visualized on @graphext.bsky.social

The thing about agents in the new version of Cursor is crazy. It created a medium-complex functional DBT model using BigQuery data from GA4 in just 3 minutes with a single prompt. It generated all the files, the code, installed packages, and even recovered from errors all on its own…

Am I the only one who takes screenshots during video calls and saves them in a Google Photos album as memories? For the first time ever, we can have photo memories of our work life! 😂 I’m sharing an internal team meeting from @graphext.bsky.social to respect the privacy of our clients.

Great thread on how to create better data visualizations 👇

60% of jobs didn’t exits in 1940 academic.oup.com/qje/article/...

Pass clusters for each football team in Spain’s first division.

So many people have tried this before and failed… What Bluesky is achieving is amazing and critical for the future of social media. Truly becoming an open protocol for social networks, like the internet or email itself and easy to use, is no easy task!

Just as starting axes above zero is often considered bad practice, it can also be a good idea to leave the empty space up to 100%, as in this example, to emphasize how far all the categorical values are from achieving something.

This visualization is awesome! It shows how nearly all forecasts on renewable energy production were way more pessimistic than reality. Such great news! 😄

The AT protocol is fascinating, and I dream of a future where we have a new Twitter with a super open API that can’t be shut down and tools like @graphext.bsky.social can be used to analyze this beautiful as fasciniting data :)

I’ve read a lot recently about how Kamala Harris strongly supports data-driven policies, and has really pushed for creating new databases to better understand crime. I hope this is true and more politicians focus less on being tough or soft on issues and more on being smart about them…

Excited about more people knowing about tools / ideas I've been working with in the last few years. - Content addressed storage - Fun data structures - Non blockchain decentralized networks - Local first approaches - Open protocols towards common digital infrastructure

Today’s photo of the day on Superhuman is one I took of the Alhambra. It’s so cool to see it in a product I use so many times a day and love it ! Photography as a core part of its UX. It encourages you to reach Inbox Zero every day to unlock beautiful photos superhuman.com/iz/victorian...

I’ve created a small Python script to extract the social graph of followers and followings for any public Bluesky account. You can upload the output CSV to a free @graphext.bsky.social account and create an interactive project like this one of my followings public.graphext.com/c8f47a5e19c3...

User 15732 of Bluesky out of the 10 million users currently! I was here before it was cool (at least among Brazilians) :P

If you use a Mac, try flowvoice.ai . It transcribes speech almost instantly and perfectly in both English and Spanish, correctly writes any person’s or company’s name, automatically adds perfect punctuation, and even corrects some errors 🤯 It’s free and runs locally on your computer

I am creating a scraper that extracts tweets from all Spanish media outlets and dumps them into @graphext.bsky.social every day for analysis. Lunchtime in Spain is at 2 pm, and the peak of news activity is at 12 pm and 4 pm. Also, people write many more replies after 10 p.m. when they finish dinner.

And they also released and shared a pretty interesting dataset to play with using @graphext.bsky.social :)

Just published, w/ Fana, M, Bisello, M & Fdez-Macías, E. 🥂 A new database to know the tasks that are more prevalent among EU workers (also by sector & occupation); how different tasks correlate and much more. "What workers do and how: a EU database of tasks indices" | oa.inapp.org/jspui/bitstr...

If you study on a California campus like Berkeley or Stanford, your life can only go downhill from there…

Walking around Los Angeles

Great first day at DBT Conf. Tons of interesting data engineers, analytics engineers, and data scientists to meet, and some really good talks. Lovely venue, terrible wifi

Every time I come to the USA and turn on the TV, I feel glad that in Europe it's forbidden to advertise prescription medications. Watching those ads takes away your will to live.

In NY for the week 👋 Meeting people in the data science/analytics space :)

Lately, with all the developments in AI, I've been thinking a lot about this idea: predicting the future of a country's economy by the complexity of the software it is able to produce www.linkedin.com/pulse/predic...

Almost two years ago, I installed the One Sec on my iPhone, making me wait 20 seconds every time I try to open Twitter or Instagram. They allow you to export data of all the times you end up opening them and I analyze it with @graphext.bsky.social and is working!

We built a free course that teaches data/business analysts how to build the foundations for a modern data stack (for startups and enterprises). Focused on capturing the right type of data and transforming it to create dashboards, advanced analytics, to create predictive models and reverse ETL

For some reason when you are young, you highly undervalue feeling that what you do in your job matters versus the salary you earn. But as I get older, I keep meeting people who would give up a lot of money to be in a position where they feel truly useful.

I have tried tons of tools for scheduling meetings with calendar links. From Calendly to Zcal, including the one natively launched by Google Calendar itself. And the best by far I use now is Cal.com . It includes the best features that others lack. And it has a very generous freemium plan!

Swiss, British, Austrian, and Australian universities have the highest number of international students, around ~30%. While North American universities and Spanish ones, at 10%. Analyzed with @graphext.bsky.social + data from World University Ranking 2023

Oh many more people in Bluesky now than a few weeks ago! Happy to see so many familiar faces over here

Our paper in NatComms! Changes of behavior during (lockdowns) and after (working from home, less exploration, etc.) pandemic decreased by 15-30% the diversity of encounters in cities. It is probably the most impactful event to affect experienced segregation in years. www.nature.com/articles/s41...

TLDR: We are excited to share that @graphext.bsky.social has just closed a $4.6M seed round, lead from Hoxton Ventures and 80 angels, bringing our total seed funding to $7M 🎉 https://www.graphext.com/post/graphext-raised-4M-seed-round