Using the US Census Plugin

Options
tgb417
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron

Has anyone out there worked out how to use the Census USA plugin?

For example, I've got a dataset that contains fips codes at the state and county levels. I want to add population, say 2019 or 2020, maybe just released.

I've read the plugin page

http://localhost:11000/plugins/census-us/summary/

I've gone to the dataiku.com page

https://www.dataiku.com/product/plugins/census-us/

I've gone to what I think is the git repo.

https://github.com/dataiku/dss-plugin-census-us

However, I'm left with very little idea of how to make practical use of this tool.

Thoughts? I'm doing this for two reasons

  • To enrich data in a project I'm working on
  • To learn something about the census plugin.

For now I'm going to default to downloading the data from here and importing.

https://www.census.gov/data/datasets/time-series/demo/popest/2010s-counties-total.html#par_textimage_70769902

Tagged:

Answers

  • CoreyS
    CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭
    Options

    Hey @tgb417
    it's like opening a gift on your birthday with some brand new US Census data to play with!

    While you wait for a more complete response, I wanted to use this opportunity to plug (no pun intended) some resources from the Knowledge Base:

    I hope this helps!

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
    Options

    Thanks @CoreyS

    the shape file one is interesting.

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
    Options

    I'm jumping back into looking at the Census Plugin.

    It appears to use the annual American Community Survey data. However the drop down only shows data from 2013-2017. I believe that the US Census Bureau has released ACS data for as recent as 2020. And it would be helpful to me to have data going back to 2005. Image showing that the Census support years 2013 - 2017

    Does anyone know if this plugin will be updated? Or if it is easily hackable to support a broader time period?

    If not anyone have a good prebuilt Python or R Library for getting this type of data? Or do you know a cleaver use of the REST API plugin to do the same kind of thing.

    Thanks for any help.

    cc: @nicog

Setup Info
    Tags
      Help me…