FundSvcs Community

Expand all | Collapse all

Updates to the Open Data Wealth Dashboard

  • 1.  Updates to the Open Data Wealth Dashboard

    Posted 10-14-2019 08:04 AM
    Edited by Steve Grimes 10-14-2019 08:05 AM
    Hey all! Reposting this here because I know many of you do not have an APRA account.
    Feel free to let me know if you have any questions!

    I've made updates to my open data wealth dashboard!

    Here are some of the changes:
    • Created a State Political Giving tab that includes NY, CA, TX, MA political contributions over $1k. More to come!
    • Created a Misc. Wealth tab that includes $1M+ NYC property valuations and Texas seacraft ownership. More to come!
    • Cleaned up names and zips for more efficient searching

    Going forward I will focus on adding state level data and then return to updating records more regularly.

    For those who are seeing this dashboard for the first time, it also includes:
    - the world's billionaires
    - those who have contributed over $5k to Fed political entities since 2016
    - SEC insiders
    - Individuals who have registered an aircraft with the FAA
    - links to the original data sets for your own use
    The hope is that I can keep adding to this dashboard so that it can serve as a true supplement to our screenings.


    Note on using the FEC contributions: there are some significant conversations around how we use that information. Given our history with using FEC data for our needs, there appears to be some grey area on how we should move forward with the FEC record(see APRA Ethics). Without getting into too much of my perspective, I am reading this new environment as we should not be using FEC information for research on individuals who are not already part of constituency (read: voluntarily engaged with our orgs). Your mileage will vary, and I suggest you contact your organization's legal team regarding FEC data going forward.


    ------------------------------
    Steve Grimes
    Director, Development Analytics and Strategy Development

    Jazz at Lincoln Center
    Venue / Frederick P. Rose Hall / Time Warner Center, 5th Floor
    Offices / 3 Columbus Circle, 12th Floor, New York, NY 10019
    sgrimes@jazz.org / jazz.org
    P 212 258 9985 F 212 258 9900





    ------------------------------


  • 2.  RE: Updates to the Open Data Wealth Dashboard

    Posted 12-02-2019 07:28 AM

    I've made more updates to my Wealth Dashboard! It now includes political giving from Florida, Illinois, Pennsylvania, and Canada.

    sgrimes.shinyapps.io/WealthDashboard/

    As per usual, you can get the entire data set here or from the links provided on the dashboard. However, because the data is starting to get a bit lengthy, I will eventually provide an option to download the entire data set as a database file.

    Additionally, I am currently working with Mike Pawlus to trudge through the 990 data to collect the names of foundation directors and officers. This may take a few months and I'm hoping to have it completed before Spring. Let me know if you have any questions!



    ------------------------------
    Steve Grimes
    grimessjr@GMAIL.COM
    ------------------------------



  • 3.  RE: Updates to the Open Data Wealth Dashboard

    Posted 02-04-2020 08:42 AM

    Hey again all, more updates!

    https://sgrimes.shinyapps.io/WealthDashboard/

    This time I've uploaded all doctors and dentists with a National Provider Identifier (NPI) certification. The dashboard now includes individuals with state political giving ($1k+), FEC political giving ($5k+), SEC insiders, world's billionaires, those who own an aircraft, those with NYC assessed property over $1M+, Texas sea craft owners, and now doctors and dentists.

    See the links in the dashboard for the full datasets if you would like to play around with the information outside of the dashboard. I'm working with John Connelly and Mike Pawlus to get foundation officers and directors in the next iteration.

    As per usual, feel free to contact me if you have any questions!



    ------------------------------
    Steve Grimes
    grimessjr@GMAIL.COM
    ------------------------------



  • 4.  RE: Updates to the Open Data Wealth Dashboard

    Posted 03-30-2020 07:31 AM

    Hey everyone, I made more updates to my #Wealth #Dashboard! In this update I've uploaded all individuals listed on an organization's form 990 who are designated as directors, officers, or employees. I was able to get a hold of this information via John Connelly (thanks John!), however it only includes up until 2016. In the coming months I will upload 2017 and later. I've also uploaded all #data in a #database file for ease of download and manipulation on your own end (see the link in the dashboard).

    The dashboard now includes individuals with state political giving ($1k+), FEC political giving ($5k+), SEC insiders, world's billionaires, those who own an aircraft, those with NYC assessed property over $1M+, Texas seacraft owners, doctors and dentists, and directors and the like listed in form 990 data from 2011-2016.

    As per usual, feel free to contact me if you have any questions!

    https://sgrimes.shinyapps.io/WealthDashboard/



    ------------------------------
    Steve Grimes
    grimessjr@GMAIL.COM
    ------------------------------