Loading video...

Video Failed to Load

There was a problem loading this video. This could be due to a temporary network issue or the video might be unavailable.

I wrote tidycensus for #rstats to simplify the process of acquiring US Census data. But - you still have to know R to use it! I wrote a rudimentary tidycensus #MCP to teach Claude to fetch Census data - watch the video for the results.

Kyle Walker

19,063 subscribers

10,855 views • 1 year ago •via X (Twitter)

Anya Rossi• Live Now

Private livecam show

4 Comments

Kyle Walker1 year ago

I prompt Claude, then it: 🌎 Searches available ACS variables; 🌎 Selects median household income (B19013_001) as the appropriate metric 🌎 Retrieves 2023 ACS 5-year estimates with margins of error 🌎 Formats everything into a clean table with key insights

Kyle Walker1 year ago

All using tidycensus and R under the hood - but the user just asks a question in plain English. This could make Census (and other!) data more accessible to practitioners who need flexible access to demographic data but don't code, as MCP handles the translation from English.

Kyle Walker1 year ago

Next steps: expanding to more complex queries, spatial operations, and time series comparisons. The video shows how powerful this could be!

Gabor Bekes1 year ago

This is great. Is there a way to share it? Thx

Related Videos

Somali region census nullified Court orders fresh census in Mandera, Wajir, Garissa Court declares 2019 census results null and void Court cites major irregularities in the data collection Government agencies asked to revert to 2009 census data #JKLive Jeff Koinange, MBS

Somali region census nullified Court orders fresh census in Mandera, Wajir, Garissa Court declares 2019 census results null and void Court cites major irregularities in the data collection Government agencies asked to revert to 2009 census data #JKLive Jeff Koinange, MBS

Citizen TV Kenya

487,235 views • 1 year ago

MCP is mind-blowing. Here is a genius setup that will earn you a promotion with your manager. I have multiple data sources: data in S3, MySQL, and local files. Using Spice (an open-source project), I can co-locate all of that data behind a single SQL endpoint and augment it using MCP. Before, accessing data was slow, and I had to make multiple requests to get anything. After using Spice, I can query the data much faster (since it's mirrored locally), and I don't have to worry about where the data is coming from. Spice acts as an MCP server, so I can connect to it from my IDE or the Claude Desktop app and have access to all the data. But even more cool than that: Spice also acts as an MCP client, so it can connect to other MCP servers. This is where things get really interesting! Watch the video. I'm querying multiple data sources from my IDE and using the Google Maps MCP server for driving directions.

MCP is mind-blowing. Here is a genius setup that will earn you a promotion with your manager. I have multiple data sources: data in S3, MySQL, and local files. Using Spice (an open-source project), I can co-locate all of that data behind a single SQL endpoint and augment it using MCP. Before, accessing data was slow, and I had to make multiple requests to get anything. After using Spice, I can query the data much faster (since it's mirrored locally), and I don't have to worry about where the data is coming from. Spice acts as an MCP server, so I can connect to it from my IDE or the Claude Desktop app and have access to all the data. But even more cool than that: Spice also acts as an MCP client, so it can connect to other MCP servers. This is where things get really interesting! Watch the video. I'm querying multiple data sources from my IDE and using the Google Maps MCP server for driving directions.

Santiago

142,696 views • 1 year ago

JUST IN: President Trump is backing Rep. Marjorie Taylor Greene’s (R-GA) new bill that would EXCLUDE illegal immigrants from the census. Once it’s law, the U.S. Census Bureau will be REQUIRED to conduct a new census “immediately.” Democrats would be poised to lose House seats and electoral college votes if passed. Greene wrote on 𝕏: “I just got off the phone with President Trump!! I told [Trump] about my new bill I am introducing that will save America’s elections from ever being stolen again!” “My bill will require the U.S. Census Bureau to conduct a new census immediately upon enactment of the bill. In conducting the new census of the U.S. population, it shall require questions determining the citizenship of each individual, and count US citizens only.” “Upon completion of the census, the bill will direct states to immediately begin a redistricting of all U.S. House seats process using only the population of United States citizens.”

JUST IN: President Trump is backing Rep. Marjorie Taylor Greene’s (R-GA) new bill that would EXCLUDE illegal immigrants from the census. Once it’s law, the U.S. Census Bureau will be REQUIRED to conduct a new census “immediately.” Democrats would be poised to lose House seats and electoral college votes if passed. Greene wrote on 𝕏: “I just got off the phone with President Trump!! I told [Trump] about my new bill I am introducing that will save America’s elections from ever being stolen again!” “My bill will require the U.S. Census Bureau to conduct a new census immediately upon enactment of the bill. In conducting the new census of the U.S. population, it shall require questions determining the citizenship of each individual, and count US citizens only.” “Upon completion of the census, the bill will direct states to immediately begin a redistricting of all U.S. House seats process using only the population of United States citizens.”

RedWave Press

1,770,695 views • 1 year ago

JUST IN: President Trump is backing Rep. Marjorie Taylor Greene’s (R-GA) new bill that would EXCLUDE illegal immigrants from the census. Once it’s law, the U.S. Census Bureau will be REQUIRED to conduct a new census “immediately.” Democrats would be poised to lose House seats and electoral college votes if passed. Greene wrote on 𝕏: “I just got off the phone with President Trump!! I told [Trump] about my new bill I am introducing that will save America’s elections from ever being stolen again!” “My bill will require the U.S. Census Bureau to conduct a new census immediately upon enactment of the bill. In conducting the new census of the U.S. population, it shall require questions determining the citizenship of each individual, and count US citizens only.” “Upon completion of the census, the bill will direct states to immediately begin a redistricting of all U.S. House seats process using only the population of United States citizens.”

JUST IN: President Trump is backing Rep. Marjorie Taylor Greene’s (R-GA) new bill that would EXCLUDE illegal immigrants from the census. Once it’s law, the U.S. Census Bureau will be REQUIRED to conduct a new census “immediately.” Democrats would be poised to lose House seats and electoral college votes if passed. Greene wrote on 𝕏: “I just got off the phone with President Trump!! I told [Trump] about my new bill I am introducing that will save America’s elections from ever being stolen again!” “My bill will require the U.S. Census Bureau to conduct a new census immediately upon enactment of the bill. In conducting the new census of the U.S. population, it shall require questions determining the citizenship of each individual, and count US citizens only.” “Upon completion of the census, the bill will direct states to immediately begin a redistricting of all U.S. House seats process using only the population of United States citizens.”

Dralone&_DR145

65,563 views • 2 months ago

Today we're launching Amplitude MCP MCP was made for data analytics. Ask a vague question and have an AI model iteratively query Amplitude to find you insights. Amplitude MCP exposes all of Amplitude's functionality so an agent can interact with it directly. It allows you to use Amplitude without having to know anything about Amplitude's user interface or your data taxonomy. It uses the intelligence of off the shelf AI agents, including Claude, Gemini, and Cursor, to query Amplitude data you already have to find answers. It leverages all of your existing Amplitude data and how it's used to navigate through large complex behavioral datasets. You can have conversations about your product data directly inside any AI model with MCP. It can create Amplitude dashboards and notebooks with what it finds and even make recommendations. This is the best MCP use case I've ever seen. Watching an AI agent think, reason, query Amplitude, and then repeat that process iteratively is magical. See it in action:

Today we're launching Amplitude MCP MCP was made for data analytics. Ask a vague question and have an AI model iteratively query Amplitude to find you insights. Amplitude MCP exposes all of Amplitude's functionality so an agent can interact with it directly. It allows you to use Amplitude without having to know anything about Amplitude's user interface or your data taxonomy. It uses the intelligence of off the shelf AI agents, including Claude, Gemini, and Cursor, to query Amplitude data you already have to find answers. It leverages all of your existing Amplitude data and how it's used to navigate through large complex behavioral datasets. You can have conversations about your product data directly inside any AI model with MCP. It can create Amplitude dashboards and notebooks with what it finds and even make recommendations. This is the best MCP use case I've ever seen. Watching an AI agent think, reason, query Amplitude, and then repeat that process iteratively is magical. See it in action:

Spenser Skates

32,307 views • 8 months ago

Jim Banks calls for Indiana to have a 9-0 Republican congressional map and alleges that "the Democrats manipulated the census data when Joe Biden came into office." (The 2020 census happened in 2020, when believe it or not Trump was president)

Jim Banks calls for Indiana to have a 9-0 Republican congressional map and alleges that "the Democrats manipulated the census data when Joe Biden came into office." (The 2020 census happened in 2020, when believe it or not Trump was president)

Aaron Rupar

166,796 views • 8 months ago

Holiday surprise! 😝🎅🏾 I wrote a new #schoolforgoodandevil story, featuring Agatha and Tedros… Now you have to find it. Watch the video for details.

Holiday surprise! 😝🎅🏾 I wrote a new #schoolforgoodandevil story, featuring Agatha and Tedros… Now you have to find it. Watch the video for details.

Soman Chainani

19,288 views • 3 years ago

How Claude helped US strike Iran. Very Good Explanation by Palki Sharma - Claude AI models gather all intelligence data and model gave the Time & Location to attack on Iran. - It took 6-10 months to process such Data but Claude AI Models gave the precise output in few mins. - US Army CANNOT replace Claude Models for next 6 months. Still they have huge dependency.

How Claude helped US strike Iran. Very Good Explanation by Palki Sharma - Claude AI models gather all intelligence data and model gave the Time & Location to attack on Iran. - It took 6-10 months to process such Data but Claude AI Models gave the precise output in few mins. - US Army CANNOT replace Claude Models for next 6 months. Still they have huge dependency.

Farrago Abdullah Parody

12,497 views • 4 months ago

Bihar has always shown the way forward to the country. #Bihar has become the first state to have scientific data about its population. The census will produce scientific methods for welfare schemes.

Bihar has always shown the way forward to the country. #Bihar has become the first state to have scientific data about its population. The census will produce scientific methods for welfare schemes.

Tejashwi Yadav

104,531 views • 2 years ago

I wrote this song over a year ago when I was first struggling to process the whirlwind of SUCCESS. A year later and i’m still struggling. So much to learn & have so many thoughts…but for now i’ll let the song speak for itself. Feels like the right time to share it with y’all.

I wrote this song over a year ago when I was first struggling to process the whirlwind of SUCCESS. A year later and i’m still struggling. So much to learn & have so many thoughts…but for now i’ll let the song speak for itself. Feels like the right time to share it with y’all.

I AM FOR JESUS

32,945 views • 8 months ago

Is the census data being manipulated? Now when the census is finally being conducted with a 5-year delay, enumerators in Delhi, Rajasthan & UP are reportedly being told to avoid options that paint the govt in a poor light. This completely erodes public trust - census is the most important data set for public policy & planning in the country. Watch Jaanne Bhi Do Yaaro with Dipa Sinha

Is the census data being manipulated? Now when the census is finally being conducted with a 5-year delay, enumerators in Delhi, Rajasthan & UP are reportedly being told to avoid options that paint the govt in a poor light. This completely erodes public trust - census is the most important data set for public policy & planning in the country. Watch Jaanne Bhi Do Yaaro with Dipa Sinha

Anjali Bhardwaj

21,405 views • 12 days ago

Call us names, call us childish; it is fine… I understand, but anyone that says anything false about me and I have evidence, then I have a right to defend myself. Let’s stay WINNING. You claimed you wrote the song and you didn’t know any Calypso60music. Then how come Calypso60music and I are now telling you what to sing? JUST FOR THE RECORD, GUYS! JUDE and PAUL wrote through a lawyer and are doing everything possible to take the song down from all music platforms. But I will fight till the end. 🙅‍♂️ With my full chest! Calypso60music and I wrote “WINNING.”

Call us names, call us childish; it is fine… I understand, but anyone that says anything false about me and I have evidence, then I have a right to defend myself. Let’s stay WINNING. You claimed you wrote the song and you didn’t know any Calypso60music. Then how come Calypso60music and I are now telling you what to sing? JUST FOR THE RECORD, GUYS! JUDE and PAUL wrote through a lawyer and are doing everything possible to take the song down from all music platforms. But I will fight till the end. 🙅‍♂️ With my full chest! Calypso60music and I wrote “WINNING.”

Mr Psquare

46,128 views • 1 year ago

Claude can now build you a personal YouTube Database! - Monitor ALL your channels competitors - Research & Store the results for you into a swipefile - Pull data from the folder to learn from Try it using the nexlev MCP

Claude can now build you a personal YouTube Database! - Monitor ALL your channels competitors - Research & Store the results for you into a swipefile - Pull data from the folder to learn from Try it using the nexlev MCP

NexLev

15,689 views • 2 months ago

I got sick of waiting for BOM to publish the 2025 multidecadal rainfall update, so I pulled the data and wrote my own script. Wet tropics still moving south. Hyper Australia manifestation intensifies.

I got sick of waiting for BOM to publish the 2025 multidecadal rainfall update, so I pulled the data and wrote my own script. Wet tropics still moving south. Hyper Australia manifestation intensifies.

Hot Rails — oz/acc

108,794 views • 2 months ago

Stephen Miller: Democrats have stolen 20 to 30 House seats by counting illegal aliens in the census. They opened our borders for 4 years, bringing millions of illegals to rig the results of the census to gain congressional seats. This is the Democrat machine at work.

Stephen Miller: Democrats have stolen 20 to 30 House seats by counting illegal aliens in the census. They opened our borders for 4 years, bringing millions of illegals to rig the results of the census to gain congressional seats. This is the Democrat machine at work.

🇺🇸 Pecan 🇺🇸

10,518 views • 11 months ago

🛑 BREAKING: India’s First Digital Census to Enable Citizens to Self-Ennumerate ~ Census data to be available faster with Full DIGITAL Rollout ~ Citizens can fill details directly through a secure government Web Portal ~ Data to be transmitted electronically to central servers, NO PAPER, NO MIDDLEMEN 👉🏼 Marks first-ever citizen-driven enumeration in Indian history Major leap in Modi govt’s push for real-time governance and data transparency. Congress mocked the vision of Digital Bharat. Today, India’s Census tech leads the world👏🏼

🛑 BREAKING: India’s First Digital Census to Enable Citizens to Self-Ennumerate ~ Census data to be available faster with Full DIGITAL Rollout ~ Citizens can fill details directly through a secure government Web Portal ~ Data to be transmitted electronically to central servers, NO PAPER, NO MIDDLEMEN 👉🏼 Marks first-ever citizen-driven enumeration in Indian history Major leap in Modi govt’s push for real-time governance and data transparency. Congress mocked the vision of Digital Bharat. Today, India’s Census tech leads the world👏🏼

The Analyzer (News Updates🗞️)

66,582 views • 1 year ago