API for Federal Poverty Level #49

benefitkitchen · 2015-09-30T20:32:13Z

The federal poverty level (FPL) is used to determine eligibility for a number of federal, state, and local social support benefits.

e.g. a benefit eligibility calculation might look something like:
if { [head-of-household-income] < 185% * FPL-for-[N-family-size] }
then
{eligible for .2 * FPL-for-[N-family-size] }
Return benefit amount.

and would translate in numbers to:
if { $2000/mo < 185% * $1647 }
TRUE
{eligible for .2 * 1647}
Benefit amount: $329.4

I develop these sorts of algorithms and I have to maintain a calculation that updates twice/year. Ideally, this is the sort of data that could be queried dynamically via an API and returned to webapps that use the FPL as a means test for these or other benefits or systems.

Is this something that ddod could do for us??

betshsu · 2015-09-30T20:56:56Z

We could certainly start looking into it and see what kind of headway we could make with the data owners. It would be up to the data owners whether to implement an API.

Quick clarification -- by federal poverty level are you referring to the Census poverty thresholds or HHS poverty guidelines?

dportnoy · 2015-10-01T01:29:08Z

@declan, @greggish, @lloydbrodsky, would you care to weigh in on this request?

Also seems it would be useful for many Code for America projects. So please ping your CfA friends.

benefitkitchen · 2015-10-01T01:40:05Z

Hello Elizabeth,

I'm looking forward to figuring out how DDOD works. This is my first
foray... I hope it's an appropriate, well-formed request.

Regarding your question: my primary interest is re: HHS poverty guidelines.

Best,
Dan

On Wed, Sep 30, 2015 at 4:56 PM, Elizabeth Hsu [email protected]
wrote:

We could certainly start looking into it and see what kind of headway we
could make with the data owners. It would be up to the data owners whether
to implement an API.

Quick clarification -- by federal poverty level are you referring to the
Census poverty thresholds or HHS poverty guidelines?

—
Reply to this email directly or view it on GitHub
#49 (comment)
.

Daniel Beeby • Technical Director • Self-Sufficiency Solutions •
http://benefitkitchen.com/

betshsu · 2015-10-01T13:18:28Z

@benefitkitchen welcome! I assume you found DDOD through the wiki http://ddod.us, but if not, that's the place to start to get oriented. Basically, DDOD is a platform for users to let HHS agencies know what data needs they have that aren't yet being met. DDOD acts as a moderator to try to help you find the right data and interact with the data owner; DDOD doesn't own any of the data, so if and how data improvements are made is up to the data owner. We try to make the process as transparent as possible -- so this conversation on GitHub is public, and you may see other users chime in agreeing with you on the need for the data or with suggestions for how to get the data. Everything eventually gets documented on the wiki as a knowledge base/reference for the public and other users down the line.

Your request is perfectly appropriate and well-formed -- and it's also fine to come to DDOD before you have a well-formed request and we can help you to better specify your request and turn it into a formal "use case." We'll often come back with clarifying questions (like the one I had) because the better we can specify the request and articulate the value to the data owner, the better case we can make to the data owner for data improvements and also to check in to see if what we've uncovered will meet your needs.

If you'd like to discuss further by phone, please drop me an email at elizabeth dot hsu at hhs dot gov and we can set up a call.

Back to your data... is this the data that you'd like to see delivered as an API or some other machine-readable format? http://aspe.hhs.gov/2015-poverty-guidelines

Thanks!

benefitkitchen · 2015-10-01T15:46:32Z

Thank you Elizabeth. Yes, those are the data.

Best
Dan

Sent from my cordless phone. Please excuse brevity and errors.
On Oct 1, 2015 9:18 AM, "Elizabeth Hsu" [email protected] wrote:

@benefitkitchen https://github.com/benefitkitchen welcome! I assume you
found DDOD through the wiki http://ddod.us, but if not, that's the place
to start to get oriented. Basically, DDOD is a platform for users to let
HHS agencies know what data needs they have that aren't yet being met. DDOD
acts as a moderator to try to help you find the right data and interact
with the data owner; DDOD doesn't own any of the data, so if and how data
improvements are made is up to the data owner. We try to make the process
as transparent as possible -- so this conversation on GitHub is public, and
you may see other users chime in agreeing with you on the need for the data
or with suggestions for how to get the data. Everything eventually gets
documented on the wiki as a knowledge base/reference for the public and
other users down the line.

Your request is perfectly appropriate and well-formed -- and it's also
fine to come to DDOD before you have a well-formed request and we can help
you to better specify your request and turn it into a formal "use case."
We'll often come back with clarifying questions (like the one I had)
because the better we can specify the request and articulate the value to
the data owner, the better case we can make to the data owner for data
improvements and also to check in to see if what we've uncovered will meet
your needs.

If you'd like to discuss further by phone, please drop me an email at
elizabeth dot hsu at hhs dot gov and we can set up a call.

Back to your data... is this the data that you'd like to see delivered as
an API or some other machine-readable format?
http://aspe.hhs.gov/2015-poverty-guidelines

Thanks!

—
Reply to this email directly or view it on GitHub
#49 (comment)
.

betshsu · 2015-10-01T17:27:49Z

Thanks -- will start looking into it.

greggish · 2015-10-01T18:10:07Z

I know that calculating eligibility is a serious challenge for many people in many contexts -- from service referral to benefits enrollment to affordable housing etc -- and income is one of the harder components of eligibility. This would be a small but significant piece of a hugely important puzzle.

benefitkitchen · 2015-10-01T18:25:45Z

Thanks for the endorsement, Greg.

greggish · 2015-10-01T18:26:23Z

cc @Noah-T @lomaxrx @sariyie @daguar

betshsu · 2015-10-01T19:43:20Z

Looks like ASPE already has the data in CSV, XML, and JSON (see links just above the html table): http://aspe.hhs.gov/dataset/2015-poverty-guidelines

Is there anything else beyond what is published here that would be useful (e.g. historical information)?

daguar · 2015-10-01T20:21:50Z

We've actually prototyped this already over at CFA: https://github.com/codeforamerica/fplapi cc @mapsam who has led that work.

mapsam · 2015-10-01T22:30:17Z

Indeed! Project idea began here: codeforamerica/project-ideas#70 and has been implemented as a really crude Flask API that just uses a JSON file as the datasource, instead of a database. You can query the API like

http://localhost:5000/api?size=3&income=2000&income_type=monthly

and it returns

{
    amount: 20090,
    amount_nice: "$20,090",
    fpl_percentage: 119.46,
    info: {
        year_base: 11770,
        year_rate: 4160
    },
    request: {
        household_size: "3",
        income: 2000,
        year: "2015"
    }
}

I liked this suggestion, which seems to fit what you all have been talking about.

One thing you might consider, though, is putting the data into a standard format (e.g. JSON, YAML, CSV, etc.) and separating it into its own repo, which can then be included as a submodule in your API project

The next step, other than hoping for @daguar to write all of the tests for me, is to deploy on to heroku or something comparable and figuring out how to properly update the percentages on a yearly basis as CPI updates nationally.

benefitkitchen · 2015-10-02T14:26:41Z

This is great progress everyone. Thank you for locating the file. The annual upkeep is an important element of that. Since we'll be utilizing the data, I'd be happy to be on the team helping keep it fresh. There are also "two kinds" of federal poverty level... there are "fall" and "spring" numbers (some benefits use the most up-to-date numbers and some use the older version for an additional period). I'll talk with our numbers mavens to ensure when/how/why we use the other numbers... but my point is this: It might make sense to keep historical numbers for folks who want to do comparisons or use these different datasets for other reasons. So we might wan to have a current_year variable so that we can do current_year - n to get old data.

mapsam · 2015-10-02T17:23:04Z

Historical numbers are definitely important. They already exist as JSON in the API and you can add year to the query. If no year is added, it defaults to the current year.

mapsam · 2015-10-02T17:23:53Z

Also, feeling inspired yesterday I pushed the FPL API up to Heroku and it works at a real URL now!

http://fplapi.herokuapp.com/api?size=3&income=2000&income_type=monthly

betshsu · 2015-10-02T18:45:06Z

@mapsam Thanks -- I'm going to link to this on the wiki entry for this use case, which I started here: http://hhs.ddod.us/wiki/Use_Case_49:_API_for_Federal_Poverty_Guidelines

Looks like you are using the HHS ASPE data and are storing the data within the API as you linked above. I noticed that ASPE has different guidelines for contiguous 48 vs Alaska and Hawaii: http://aspe.hhs.gov/2015-poverty-guidelines and http://aspe.hhs.gov/dataset/2015-poverty-guidelines. Is this not something most folks worry about or because there is no adjustments for Alaska and Hawaii in the poverty thresholds?

@benefitkitchen Regarding the "fall" and "spring" numbers -- is this just a matter of using current year vs prior year numbers? I believe the government only updates the poverty guidelines once a year, but correct me if I'm mistaken.

betshsu · 2015-10-02T19:17:11Z

@mapsam -- I added info re: your API here: http://hhs.ddod.us/wiki/Use_Case_49:_API_for_Federal_Poverty_Guidelines#Long_term_implementation

Please feel free to edit if I missed anything or got anything wrong. Thanks!

benefitkitchen · 2015-10-02T20:00:10Z

Last year's numbers will do the trick.

dportnoy · 2015-10-06T21:18:56Z

I updated specifications section of http://hhs.ddod.us/wiki/Use_Case_49. @mapsam, @daguar, feel free to suggest changes.

benefitkitchen · 2016-09-09T15:27:32Z

Hello Folks,

Can someone tell me if there are plans to update this for 2016?

Best,
Dan

On Tue, Dec 8, 2015 at 11:24 AM, Elizabeth Hsu [email protected]
wrote:

Closed #49
#49.

—
Reply to this email directly or view it on GitHub
#49 (comment)
.

Daniel Beeby • CTO • http://benefitkitchen.com/ • 212-849-2773

dportnoy · 2016-09-09T19:42:31Z

@mapsam Did you want to update your Heroku hosted app? @benefitkitchen, there's a chance I could find a home for this tool as well. (Disclaimer: I'm referring from the standpoint of the DDOD initiative. I don't represent HHS.)

benefitkitchen · 2016-09-09T20:03:22Z

Thank you, David.

This is pretty simple to update, we just need to be sure that somebody's
going to do it in order to switch our code over to use the API.

This would need to be added for 2016
"2016": {
"base": 11880,
"rate": 4160
},
The "rate" remains the same for 2016 (at $4160). The 2017 numbers come out
Jan 20.

Best,
Dan

On Fri, Sep 9, 2016 at 3:42 PM, David X Portnoy [email protected]
wrote:

@mapsam https://github.com/mapsam Did you want to update your Heroku
hosted app? @benefitkitchen https://github.com/benefitkitchen, there's
a chance I could find a home for this tool as well. (Disclaimer: I'm
referring from the standpoint of the DDOD initiative. I don't represent
HHS.)

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#49 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AKKcg0bwbmW_m8NucbX7MhSZjtVINRuQks5qobapgaJpZM4GGzk-
.

Daniel Beeby • CTO • http://benefitkitchen.com/ • 212-849-2773

mapsam · 2016-09-09T20:15:16Z

👋 hi all

I've made a pull request adding the 2016 numbers provided by @benefitkitchen above. I'll deploy to heroku once things look good.

Did you want to update your Heroku hosted app? @benefitkitchen, there's a chance I could find a home for this tool as well.

Worth noting the current free tier this heroku app is on should not be relied upon. Code for American can't guarantee it being up 100% of the time, and I can't guarantee it will be updated promptly.

I'll comment back here once the updates have been deployed!

mapsam · 2016-09-09T20:19:41Z

Successfully deployed!

http://fplapi.herokuapp.com/api?size=3&income=2000&income_type=monthly

dportnoy · 2016-09-09T20:53:14Z

Thanks @mapsam! Way to rock the spirit of community provided solutions! 👍

BTW, one day this would be the perfect service to move to Chalice, which is AWS's way to implement serverless functions in Python: http://david.portnoy.us/python-serverless-microframework/

greggish · 2016-09-09T21:50:07Z

Isn't this the kind of thing that should be adopted by the gov? It's great that members of the community have engineered a solution, but this is a matter of public service.

dportnoy · 2016-09-09T22:01:25Z

Hi @greggish, I think you hit upon the right world: "should". Often well meaning program owners in government simply don't have the resources, sufficient procurement flexibility or regulatory authority to make important services happen. This is the primary driver for spinning DDOD off into a nonprofit initiative outside of government.

greggish · 2016-09-09T22:24:17Z

I get the challenge. It's a problem. But when a non-profit takes on responsibility that should be assumed by a government: now we have two problems.

dportnoy added the STATE: Admin researching label Oct 1, 2015

betshsu added STATE: Admin documenting and removed STATE: Admin researching labels Oct 2, 2015

dportnoy added Owner: HHS-ASPE VAL: 1: Catalog VAL: 3: Transform and removed VAL: 4: Improve labels Oct 19, 2015

dportnoy added VAL: 4: Improve VAL: 2: Document labels Nov 25, 2015

betshsu added STATE: Closed — Solution and removed STATE: Admin documenting labels Dec 8, 2015

betshsu closed this as completed Dec 8, 2015

mapsam mentioned this issue Sep 9, 2016

add 2016 numbers codeforamerica/fplapi#19

Merged

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

API for Federal Poverty Level #49

API for Federal Poverty Level #49

benefitkitchen commented Sep 30, 2015

betshsu commented Sep 30, 2015

dportnoy commented Oct 1, 2015

benefitkitchen commented Oct 1, 2015

betshsu commented Oct 1, 2015

benefitkitchen commented Oct 1, 2015

betshsu commented Oct 1, 2015

greggish commented Oct 1, 2015

benefitkitchen commented Oct 1, 2015 via email

greggish commented Oct 1, 2015

betshsu commented Oct 1, 2015

daguar commented Oct 1, 2015

mapsam commented Oct 1, 2015

benefitkitchen commented Oct 2, 2015 via email

mapsam commented Oct 2, 2015

mapsam commented Oct 2, 2015

betshsu commented Oct 2, 2015

betshsu commented Oct 2, 2015

benefitkitchen commented Oct 2, 2015 via email

dportnoy commented Oct 6, 2015

benefitkitchen commented Sep 9, 2016

dportnoy commented Sep 9, 2016

benefitkitchen commented Sep 9, 2016

mapsam commented Sep 9, 2016

mapsam commented Sep 9, 2016

dportnoy commented Sep 9, 2016

greggish commented Sep 9, 2016 •

edited

Loading

dportnoy commented Sep 9, 2016

greggish commented Sep 9, 2016 •

edited

Loading

API for Federal Poverty Level #49

API for Federal Poverty Level #49

Comments

benefitkitchen commented Sep 30, 2015

betshsu commented Sep 30, 2015

dportnoy commented Oct 1, 2015

benefitkitchen commented Oct 1, 2015

betshsu commented Oct 1, 2015

benefitkitchen commented Oct 1, 2015

betshsu commented Oct 1, 2015

greggish commented Oct 1, 2015

benefitkitchen commented Oct 1, 2015 via email

greggish commented Oct 1, 2015

betshsu commented Oct 1, 2015

daguar commented Oct 1, 2015

mapsam commented Oct 1, 2015

benefitkitchen commented Oct 2, 2015 via email

mapsam commented Oct 2, 2015

mapsam commented Oct 2, 2015

betshsu commented Oct 2, 2015

betshsu commented Oct 2, 2015

benefitkitchen commented Oct 2, 2015 via email

dportnoy commented Oct 6, 2015

benefitkitchen commented Sep 9, 2016

dportnoy commented Sep 9, 2016

benefitkitchen commented Sep 9, 2016

mapsam commented Sep 9, 2016

mapsam commented Sep 9, 2016

dportnoy commented Sep 9, 2016

greggish commented Sep 9, 2016 • edited Loading

dportnoy commented Sep 9, 2016

greggish commented Sep 9, 2016 • edited Loading

greggish commented Sep 9, 2016 •

edited

Loading

greggish commented Sep 9, 2016 •

edited

Loading