Victoriano Izquierdo
@victoriano.bsky.social
Graphext co-founder.
Data Stuff 📊 & Product 📦
graphext.com - @graphext.bsky.social
victoriano.me
twitter.com/victorianoi
Data Stuff 📊 & Product 📦
graphext.com - @graphext.bsky.social
victoriano.me
twitter.com/victorianoi
Pinned
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...
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...
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.
March 29, 2025 at 11:03 AM
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
Also curious Zaragoza gets x3 more national tourism than international.
Data INE + analysis with @graphext.bsky.social
March 3, 2025 at 4:14 PM
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
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!
February 27, 2025 at 10:09 AM
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
February 12, 2025 at 5:18 PM
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.
They’re like mini-documentaries about everyday life in New York.
February 7, 2025 at 9:33 PM
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.
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’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!
January 21, 2025 at 11:13 AM
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’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!
January 13, 2025 at 8:29 AM
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!
Reposted by Victoriano Izquierdo
📣 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...
www.nature.com/articles/s41...
December 23, 2024 at 2:19 PM
📣 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...
www.nature.com/articles/s41...
Ah shit, here we go again
December 19, 2024 at 10:24 AM
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...
Underrated ways to change the world
How to get a good heart unstuck
www.experimental-history.com
December 15, 2024 at 6:22 AM
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…
December 9, 2024 at 10:23 AM
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.
December 7, 2024 at 8:35 AM
At what age did you learn that pineapples grow on the ground, on top of other pineapples? Traveling through northern Thailand.
Bangkok this morning
December 4, 2024 at 6:56 AM
Bangkok this morning
Just landed in Bangkok! The roads are full of spam!
December 4, 2024 at 12:38 AM
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
December 3, 2024 at 10:11 PM
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! 😂
December 1, 2024 at 8:54 PM
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...
@graphext.bsky.social with just one click. 😍
www.youtube.com/watch?v=0Awn...
Graphext new feature: % change with one click on charts
YouTube video by Graphext
www.youtube.com
November 28, 2024 at 5:22 PM
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...
@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 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
November 28, 2024 at 9:25 AM
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 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…
November 28, 2024 at 8:45 AM
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.
I’m sharing an internal team meeting from @graphext.bsky.social to respect the privacy of our clients.
November 25, 2024 at 6:09 PM
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.
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 👇
Trying something new:
A 🧵 on a topic I find many students struggle with: "why do their 📊 look more professional than my 📊?"
It's *lots* of tiny decisions that aren't the defaults in many libraries, so let's break down 1 simple graph by @jburnmurdoch.bsky.social
🔗 www.ft.com/content/73a1...
A 🧵 on a topic I find many students struggle with: "why do their 📊 look more professional than my 📊?"
It's *lots* of tiny decisions that aren't the defaults in many libraries, so let's break down 1 simple graph by @jburnmurdoch.bsky.social
🔗 www.ft.com/content/73a1...
November 23, 2024 at 8:23 AM
Great thread on how to create better data visualizations 👇
60% of jobs didn’t exits in 1940 academic.oup.com/qje/article/...
New Frontiers: The Origins and Content of New Work, 1940–2018*
Abstract. We answer three core questions about the hypothesized role of newly emerging job categories (“new work”) in counterbalancing the erosive effect o
academic.oup.com
November 21, 2024 at 6:44 PM
60% of jobs didn’t exits in 1940 academic.oup.com/qje/article/...
Pass clusters for each football team in Spain’s first division.
November 21, 2024 at 8:06 AM
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!
Bluesky is a PBC (public benefit corporation) with the mission “to develop and drive large-scale adoption of technologies for open and decentralized public conversation.”
From the start, our goal has been to build a decentralized social network that is usable by the mainstream.
From the start, our goal has been to build a decentralized social network that is usable by the mainstream.
November 17, 2024 at 11:44 PM
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!