Healthcare Bucket

[interglobalmedia]

I think that the quality of healthcare has decreased in NYC. With real time complaints or notifications of what's going on, we should be able to help better the quality of healthcare because it will be more transparent.

[interglobalmedia]

@dirkkelly check this out!

[fma2]

Great idea, @interglobalmedia! Take a look at the datasets on https://data.cityofnewyork.us/ to see if any would work for this.

Otherwise, re-sharing the 311 data we talked about tonight:

• 311 Service Requests
• 311 Complaint Types

[interglobalmedia]

Thanks @fma2! I bookmarked all relevant web pages tonight and will go back to the datasets on the city of new york to check out what has been submitted so far under the healthcare category (there is one). I really would like to pursue this.

[interglobalmedia]

@dirkkelly @fma2 I have been doing a lot more research on the issue that I really want to address, and so I want to bag this one. How do I do that? I then will submit a new issue to you. There is A LOT of open data out there. I felt like a kid in a candy store! I first made a long list of data sets, and now I'm going shorten it.

[dirkkelly]

@interglobalmedia add your long list to github so that others can see your thinking.

[interglobalmedia]

@fma2 Would be happy to do so. Would that be good in the form of a reply? Please advise.

[fma2]

@interglobalmedia yes, reply right here!

[interglobalmedia]

Great! I'll have it for you in a little while. It's already pretty much compiled.

[interglobalmedia]

Things I might find helpful that are in data.beta.nyc maintained data sets:

1. 90 day Publication of Properties Eligible for Lien Sale
2. Social vulnerability index: The index was created by using 8 variables that reflect people’s vulnerability to any kind of disaster. The Social Vulnerability Index is an average of 8 variables where 0 is least vulnerable and 1 is most vulnerable. These were categorized into three main themes: Age: The potential for child care and/or elder care needs + dependency on others -Dependent on others: Population under 18 [Prcnt_U18] -Need assistance: Population over 65 [Prcnt_65o] Income & Civic Structure: potential for civic capacity needs + language barriers + relative losses -Financial Restrictions: Households below median income (median income defined as 50,000 for the region) [Prcnt_HHBM] - Language Barriers: Population above 5 that speaks English not well or not at all [Prcnt_Lng] - Civic/Social Structure: Non-white population [Minority] Housing Composition: potential need for evacuation + concentration of housing units & overcrowding + loss of home & dependency on landlord + possible displacements -Density: Occupied housing units [Occ_HU] -Housing uncertainty: Persons in renter occupied housing units [Prcnt_Rent] -Evacuation aid: Housing units with no car [Prcnt_NoCa] • Shapefile: Social Vulnerability Index • Geojson: Social Vulnerability index, Census Tracts • Metadata: Median Household Income, Census Tract • CSV: Social Vulnerability Index, Census Tracts
3. Inside Airbnb Data: The data behind the Inside Airbnb site is sourced from publicly available information from the Airbnb site, accessed between January 1 and January 3, 2015. Sourced from the insideairbnb.com project by Murray Cox
4. Median Household Income, 2010, Counties: Median Household Income for counties in the RPA region including estimated breakdowns for transportation costs, housing costs, and income taxes.
5. Median Household Income, 2010, Census Tracts: Median Household Income for 2010 Census Tracts in the RPA region including estimated breakdowns for transportation costs, housing costs, and income taxes.
6. NYC Health Center Districts
7. NYC Health Area Districts
8. Hospitals, RPA Region

Things I might find helpful in the NYC Open Data data resources file:

1. Foursquare APIs: The Foursquare API gives you access to our world-class places database and the ability to interact with Foursquare users and merchants. Start using the only location API you'll ever need. - https://developer.foursquare.com/ On Open NY (.ny.gov): https://data.ny.gov/Economic-Development/Current-Employment-Statistics-Beginning-1990/6k74-dgkb: Current Employment Statistics: Beginning 1990 Current Employment by Industry (CES) data reflect jobs by "place of work." It does not include the self-employed, unpaid family workers, and private household employees. Jobs located in the county or the metropolitan area that pay wages and salaries are counted although workers may live outside the area. Jobs are counted regardless of the number of hours worked. Individuals who hold more than one job (i.e. multiple job holders) may be counted more than once. The employment figure is an estimate of the number of jobs in the area (regardless of the place of residence of the workers) rather than a count of jobs held by the residents of the area.
2. NY Times APIs
3. NYC.gov Open Data (of interest are health, housing, public safety, recreation, and transportation)
4. NYC.gov Open Data (catalogue of Data Sets)
5. NYC.ogv Open Data catalogue

NYC Open Data Resources "Tools":

1. Open Corporates: The largest open database of companies in the world https://opencorporates.com/companies/jurisdictions Used by LinkedIn, The World Bank, Creditsafe, Avention, Stripe
2. Socrata Community Platform: if you're a community group organizing a hackathon, you get data hosting, foundry apis, branded socrata mini site = free https://community.socrata.com/
3. ***Census Reporter: Find facts: Populations and dollar figures are broken down by category: Demographics, Economics, Families, Housing and Social. Visualize: Our library of charts gives you insight into data from the places you research. Look for them on profile pages. You can even embed the charts on your own site. Get context: Pre-computed statistics are presented alongside each data point, so you can see how each place fits into a larger context. Explore: Census data is massive, and sometimes it’s hard to find the table you’re looking for. Search by table and column keywords.

Visualize: We want to help you tell great stories. Maps and distribution charts help uncover what’s interesting, so you can take it from there.

Download: From any comparison, save the data you’re viewing in CSV, Excel or a variety of geographic data formats. Topics: Learn more about the concepts and tables covered by the Census and American Community Survey. We’ll be adding more of these pages in the next few months, so let us know if there are topics you’d like to see us explain:

age and sex, employment, getting started, migration, race and hispanic origin, table codes, children, families, health insurance, poverty, same-sex couples, veterans and military, commute, geography, income, public assistance, seniors

Using the site: Census Reporter is a Knight News Challenge-funded project to make it easier for journalists to write stories using information from the U.S. Census bureau. Place profiles and comparison pages provide a friendly interface for navigating data, including visualizations for a more useful first look.

4. American Fact Finder: United States Census Bureau:

Find popular facts about your community by using Community Facts. Enter a state, county, city, town, or zip code in the Community Facts text box, then click GO. The Community Facts page displays, showing you the population of the geography that you entered. Click on the subjects listed on the left side of the page (Age, Business and Industry, Education, etc.) to see other interesting information about your geography. Click the links under "Popular tables for this Geography" to see tables containing other data for your community.

1. ***Yelp API: https://www.yelp.com/developers/:

Search over 50 million local businesses from 27 countries Enhance your app with Yelp ratings, reviews, photos and much more Simple and fast API with powerful category and geo search filters

6. Let Me Get That Data for You: http://lmgtdfy.usopendata.org/ Not sure what data is already provided on your website? We can find out! Enter your website’s domain name:
7. Developers Corner: great to check into because that's where they talk about anything and everything developers want to create.
8. NYC Open Data Categories:
9. Mapped in NY Companies (on Digital.nyc)
10. Demographic Statistics by Zip Code (sparse amount of data)

11. Quality of Life Indicators (there are 29, and many of them are lame: downtown commercial vacancy rates, hotel occupancy rates, Operation Scorecard - % of acceptably clean streets, Operation Scorecard - % of acceptably clean sidewalks, visitors to downtown attractions, average # of homeless encountered in weekly 1 hour, # of homeless encountered by Outreach Workers, Services Accepted, Services Declined, Public Contacts, Tons of Litter Collected, Daily Average - Crimes Against Person, Daily Average - Crimes Against Property, Kiosk information booth contacts - City Hall, Kiosk information booth contacts, WTC, Kiosk information booth contacts, WFC, Alliance website visits, Website Visits to Mr. office space, Downtaown Connection Ridership, Average Weekday Subway Ridership, Commercial Leasing Activity Measured in Sq Ft, Total Residential Housing Unit Inventory South of Chambers, Conversion Starts Since 1995, New Development Starts since 1995, Future and Options Internship Participants Cumulative, Technical Assistance Inquiries from Small Businesses, Wireless Network Usage Totals, Bike Around Downtown, The WiFi network underwent an extensive upgrade in technology, bandwidth, and coverage area in November 2014 resulting in all sites being down for several weeks.)

    NYC Jobs (what kind?) - note: there are approximately 100,000 job openings that can't be filled because people don't have the skills to fill them. What are these skills? How many unemployed self employed, or part timers are there in NYC and would they want to fill these jobs if they had the skills?

    Federal Stimulus Data: Data on the usage of stimulus/recovery funds provided through the American Recovery and Reinvestment Act of 2009 (ARRA) Zip Code breakdowns: Demographic statistics broken down by zip code Updated Schedule: as required

    NYC Women's Resource Network Database Real Estate Market indicators?

DOF: Condominium comparable rental income Manhattan FY 2010-2011

DOB Job Application filings (what kinds of jobs?)

NYC Health and Hospitals Corporation (HCC): HHC Options (common fees) Through HHC Options, low and moderate income HHC patients can get affordable healthcare. Based on the Level determined by family size and income, this table shows some of the most common fees paid for healthcare services through HHC options. Update Frequency: As needed

NYC Health and Hospitals Corporation (HHC): HHC Options (family level) Through HHC Options, low and moderate income HHC patients can get affordable healthcare. If a patient is not eligible for public insurance, we reduce the patient's fee to an affordable amount, based on the family size and income. This data shows the minimum and maximum income at each level. Update frequency: as needed

DOF: Cooperative Comparable Rental Income: Manhattan: FY 2011-2012 DYCD after-school programs: Jobs and Internships: Facilities in New York City, by agency and site, that offer the following after-school job and internship programs: Summer Youth Employment, In School Youth Employment (ISY), Out-of-School Youth Employment (OSY), Youth Employment, and Adult Employment Programs for children in age groups 14 to 24, 16 to 21, children in all grades, and adults. Update Schedule: Annually

DOF: Cooperative Comparable Rental Income: Manhattan: FY 2009-2010 Projected Median Age By Borough 2000-2030: Median Age of the population of New York City in total and by Borough: unadjusted decennial census data from 1950-2000 and projected figures from 2010-2030.

DYCD after school programs: health stat: Facilities in New York City, by agency and site, that offer Neighborhood Development Area (NDA) “Health Stat” after-school Family Support Programs. - Department of Youth and Community Development (DYCD). Update Frequency: Annually Minority and Women Owned Business Enterprise Statistics

Daily Report of Single Adult and Family Intake (2013) - Daily report of how many Single Adults and Families are served Cash Assistance Recipients in NYC (should have by gender, age, education level, employment status, and marital status as well) DRA Monthly Job Placements (what is ODRA?): statistics on monthly job placements 1996-2013. Should also have female or male, single, married, kids Cash assistance Head of Household: Statistics on head's of a household between 16 and 24 years of age receiving cash assistance. Cash Assistance Heads Of Household By Engagement (16-24 years old) Statistics on heads of a household receiving cash assistance between 16 and 24 years old by engagement category. Directory Of Child Care and Day Care Information Offices List of Child Care and Day Care administrative offices by Borough

Adult family health plus levels This table represents details of Family Health Plus insurance program. Family Health Plus is a public health insurance program for adults between the ages of 19 and 64 who do not have health insurance - either on their own or through their employers - but have incomes too high to qualify for Medicaid. The Family Health Plus Premium Assistance Program is available to help eligible lower-income employees and their families participate in their employer’s health insurance plan. Personal Income By AGI Range Number of tax filers/payers and total income by income ranges

Income By Type Of Income And AGI Range Number of tax filers/payers and income from various types of income by income ranges

Tax Liability By AGI Range Number of tax filers/payers and total city tax liability by income ranges Tax Credits By Age Range Number of tax filers/payers using various tax credits and amount of credit, by income ranges

New York City’s School-Age and 65 and Over Populations by Borough, 1950 – 2040 Unadjusted decennial census data from 1950-2000 and projected figures from 2010-2040: summary table of New York City population numbers and percentage share by Borough, including school-age (5 to 17), 65 and Over, and total population. New York City Population by Borough, 1950 - 2040 Unadjusted decennial census data from 1950-2000 and projected figures from 2010-2040: summary table of New York City population numbers and percentage share by Borough, including school-age (5 to 17), 65 and Over, and total population.

This is what I have so far.

[interglobalmedia]

@fma2 from you: Current 311 buckets in progress --

Housing/Quality of Life Bucket (Issue #6) - https://github.com/BetaNYC/citygram-services-nyc/issues/6

That's great. I'll check this out. That's actually a very important data set for my project. Thanks! I now have somewhere to start. Can I work on that? I would also like to create other issues that are on this list. What do you think?

[fma2]

@interglobalmedia, I believe @jmcole6539 is working on https://github.com/BetaNYC/citygram-services-nyc/issues/6.

And, wow! That's an extensive list of datasets! I'm wondering which provide information about which NYC residents would want notifications. Also, what do you imagine a healthcare notification looks like?

And, fyi - when scraping the 311 "Make a Notification" page, I found that, within the backend, there are categories beyond the topics/subtopics one sees. I grouped topics/subtopics by category and made it available in a json here. Notably, there's 'Health' category--below, I copied and pasted it with the topics and subtopics that reference it.

    "Health": [{
        "topic": "Your Home",
        "subtopic": "Mold",
        "complaint_types": ["Unsanitary Condition"]
    }, {
        "topic": "Public Health/Safety",
        "subtopic": "Rodents",
        "complaint_types": []
    }, {
        "topic": "Public Health/Safety",
        "subtopic": "Dog or Animal Waste",
        "complaint_types": []
    }, {
        "topic": "Public Health/Safety",
        "subtopic": "Food Safety",
        "complaint_types": []
    }, {
        "topic": "Public Health/Safety",
        "subtopic": "Food Poisoning",
        "complaint_types": []
    }],

Do you want to work on a "Health" bucket using 311 complaints data until we get a better handle on how notifications would work for "healthcare"?

[interglobalmedia]

I could do that. But just to put this out there before I forget it:

I am a big user of apps, big fan of information in general, and I am picking apps and their user experience apart all the time. One thing I know for sure: most people want to be notified. Otherwise, they might never revisit the app!

I think having a healthcare app would be great. I actually have Obamacare, and underwent quite a process with them before finally getting coverage. I learned a lot in the process. Having that kind of information at one's fingertips set up in the form of an app would be tremendous. Obviously there would have to be data, and even a "blog" based on the data information, changes in policies, law, or anything else related to Obamacare within the app, as well as one's own account. For instance, when one has to renew one's policy every year, one form of notification could be letting the insured know about what else is necessary to submit in the renewal process. Tax papers, income related information, etc. There also could be a marketplace area, or perhaps that would be a separate sister app. Personal healthcare app vs. marketplace with a blog also with notifications/updates about Obamacare. Just an initial idea. Is that what you were thinking, or am I going absolutely down the wrong path?

Managing one's healthcare account within an app and following the changes in the marketplace in another might make many people's lives a bit less complicated and increase their knowledge concerning their (choices about) coverage. As you know that is a HUGE issue. Some doctors don't even bother to get to know what it's all about, because so many of them still refuse to accept it.

[jmcole6539]

Wow - this is a ton of great information. I'll look over this tonight - as of now I'm only focusing on a Quality of Life "button" to add to the NYC Citygram page (just so that our work doesn't become duplicative). I envision starting with our "bucket" from 311 of categories that fit within this ID and then branching into some of these other datasets that you mention.

[interglobalmedia]

@jmcole6539 I won't be able to attend the one out in Queens. It is a bit far for me, but I actually have something else that evening. But I will be attending the next one on the 25th again. I'm attending whichever ones are in Manhattan unless something conflicts. I really want to get git down (pun intended)! @fma2 yes, thanks so much for the code, and I know I will have so many more questions about this process. Thanks for your patience in advance!

[interglobalmedia]

ok. so quality of life is out as far as my citygram contributions go. I went on 311 last night, and honestly couldn't find the health complaints data you were talking about @fma2.

[fma2]

@interglobalmedia perhaps look through the 311 complaint types on the open data list: https://data.cityofnewyork.us/Social-Services/311-Complaint-Types/h4xh-jcuz (the same data in json form is here: https://data.cityofnewyork.us/api/views/h4xh-jcuz/rows.json -- I find this one a little easier to search with cmd-F or ctrl-F)

Cross check it with the complaint types (1)here & with (2) the list above.

For example, in (2), a complaint type you find on the open data list that has to do with health is "Unsanitary Condition".

Here's how to look at complaint types on (1): https://github.com/BetaNYC/citygram-services-nyc/issues/4#issuecomment-77966777

[interglobalmedia]

@fma2 I clicked on both links you shared above, and the fields were empty. Just a title and nothing else.

I went through some more information, and this is what I've narrowed down to so far regarding healthcare in some way (I got it off 311):

All_Payer_Inpatient_Quality_IndicatorsIQIVolume_Measures_by_Hospital__SPARCS___Beginning_2009.csv

Health_Care_Coverage_Status__BRFSS___Beginning_2011

Hospital-Acquired_Infections__Beginning_2008.csv

Percent_of_Residents_Age_18_and_Over_that_Do_Not_Have_Health_Care_Coverage_by_Gender_Trend_Chart__BRFSS__2007-2010 (1)

QARR__Satisfaction_with_Access_to_Care_and_Health_Plan_By_Payer.csv

[fma2]

@interglobalmedia hmm I wonder why the fields are empty. Which links did you select?

Do all of the datasets you found provide real-time information?

With a quick Google search, I found the Health Care Coverage Status one, and it seems like its only updated annually, yes?

[interglobalmedia]

@fma2 I can't tell you why they are empty, but all that you gave me to check out were empty. I will be at the civic tonight and can show you what I'm talking about, but there is nothing there. Just the field headers.

Some things are only updated annually. I haven't been able to narrow it down to the 1 that I would want to use, and also would want it to be more frequently updated. I'll check it out when I get downtown. Those areas are of interest to me, but as far as for you guys (and preferably for me), I know it would really only make sense for something to be in real time as with what goes on in the 311 map. However, there, specifics don't seem to be given. requests seem vague, except in the case of rodent sitings! I think I might be looking for something that doesn't exist yet. I am starting to see however, what it is that you mean by "real time".

[dirkkelly]

@interglobalmedia do you have javascript enabled? I have a feeling this is an issue with you being able to view the open data portal at all.

@fma2 links working fine for me

[interglobalmedia]

@dirkkelly so then you see everything in those particular links that @fma2 sent me? I do have javascript enabled. I should. I write javascript on this computer and have no problem. I'll check this out in FireFox tonight just in case. Chrome for Mac hasn't been updated in 2.5 years.

[interglobalmedia]

@dirkkelly however, it only happened with those few links. Not any other.