PHL Budget Data
Project description
phl-budget-data
Aggregating and cleaning City of Philadelphia budget-related data
Installation
pip install phl_budget_data
Examples
The subsections below list examples for loading various kinds of budget-related data sets for the City of Philadelphia.
Revenue Reports
Data is available from the City of Philadelphia's Revenue reports, as published to the City's website.
City Collections
Monthly PDF reports are available on the City of Philadelphia's website according to fiscal year (example: FY 2021).
Load the data:
from phl_budget_data.clean import load_monthly_tax_collections
data = load_monthly_tax_collections("city")
data.head()
Output:
name fiscal_year total month_name month fiscal_month year date
0 wage_earnings_net_profits_city 2021 112703449.0 dec 12 6 2020 2020-12-01
1 wage_earnings_net_profits 2021 149179593.0 dec 12 6 2020 2020-12-01
2 wage_city 2021 111383438.0 dec 12 6 2020 2020-12-01
3 wage_pica 2021 35437417.0 dec 12 6 2020 2020-12-01
4 wage 2021 146820855.0 dec 12 6 2020 2020-12-01
School District Collections
Monthly PDF reports are available on the City of Philadelphia's website according to fiscal year (example: FY 2021).
Load the data:
from phl_budget_data.clean import load_monthly_tax_collections
data = load_monthly_tax_collections("school")
data.head()
Output:
name fiscal_year total month_name month fiscal_month year date
0 real_estate 2021 30509964 dec 12 6 2020 2020-12-01
1 school_income 2021 163926 dec 12 6 2020 2020-12-01
2 use_and_occupancy 2021 15288162 dec 12 6 2020 2020-12-01
3 liquor 2021 2207352 dec 12 6 2020 2020-12-01
4 other_nontax 2021 45772 dec 12 6 2020 2020-12-01
Monthly Wage Tax Collections by Industry
Monthly PDF reports are available on the City of Philadelphia's website according to calendar year (example: 2020).
Load the data:
from phl_budget_data.clean import load_wage_collections_by_industry
data = load_wage_collections_by_industry()
data.head()
Output:
industry parent_industry total month_name month fiscal_month year fiscal_year date
0 Other Governments Government 177693.0 dec 12 6 2020 2021 2020-12-01
1 Social Services Health and Social Services 4631670.0 dec 12 6 2020 2021 2020-12-01
2 Outpatient Care Centers and Other Health Services Health and Social Services 5302884.0 dec 12 6 2020 2021 2020-12-01
3 Doctors, Dentists, and Other Health Practitioners Health and Social Services 3390537.0 dec 12 6 2020 2021 2020-12-01
4 Hospitals Health and Social Services 19327622.0 dec 12 6 2020 2021 2020-12-01
Quarterly City Manager's Report
PDF reports are available on the City of Philadelphia's website here.
Coming Soon
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for phl_budget_data-0.1.3-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 515653267b98636f0a1d0bf065d249c0455b4ed6275fda3413ae6fca9fec80d7 |
|
MD5 | 36735ca83922d00aee7838efeb6a2327 |
|
BLAKE2b-256 | 0a3b48d445a354ea0f2204bf404d3b23bcadc93b58942cfa53564bed90b770a5 |