de-data-lab / WRK

Repository for the WRK Group Dashboard
https://techimpact.shinyapps.io/WRK-dashboard
GNU Affero General Public License v3.0
1 stars 0 forks source link

Check if we can use the historic business license data for the number of businesses in the WRK region #31

Closed nsunami closed 2 years ago

nsunami commented 2 years ago

The Delaware Open Data portal has a historic dataset about business licenses (link).

Check if we can use the data to estimate the number of businesses in the WRK region over time.

nsunami commented 2 years ago

The dataset turns to only have data until 2018.

Here's a sample query to get the number of businesses per year. It only has data until 2018.

[
    {
        "month": "2007-01-01T00:00:00.000",
        "total": "78560"
    },
    {
        "month": "2008-01-01T00:00:00.000",
        "total": "78795"
    },
    {
        "month": "2009-01-01T00:00:00.000",
        "total": "76799"
    },
    {
        "month": "2010-01-01T00:00:00.000",
        "total": "84077"
    },
    {
        "month": "2011-01-01T00:00:00.000",
        "total": "81129"
    },
    {
        "month": "2012-01-01T00:00:00.000",
        "total": "81660"
    },
    {
        "month": "2013-01-01T00:00:00.000",
        "total": "82772"
    },
    {
        "month": "2014-01-01T00:00:00.000",
        "total": "82605"
    },
    {
        "month": "2015-01-01T00:00:00.000",
        "total": "88267"
    },
    {
        "month": "2016-01-01T00:00:00.000",
        "total": "87536"
    },
    {
        "month": "2017-01-01T00:00:00.000",
        "total": "102149"
    },
    {
        "month": "2018-01-01T00:00:00.000",
        "total": "85281"
    }

I think we need data 2018 and onwards for our purpose. (hopefully it will be updated sometime…) I'm closing this issue for now.