Data Visualizations – Civic Parent

The “User Friendly Budget”, Part 4a: View Your Town’s Structural Spending with the “UFB-3 Appropriations Summary” Data

June 23, 2020May 8, 2021Brigid D'SouzaData Visualizations, NJ User Friendly Budgets, Public budgets

This is a post in a series about NJ's User Friendly Budget. My intent is to share basic analysis and insights with community as a way to encourage taxpayers to engage with this document and learn more about local public finance. Read the other posts in this series here including how to access your town's...

The “User Friendly Budget”, Part 3: the “Cover Page”, an Inventory of NJ’s 565 Municipalities, & An Overview of How UFB Data was Compiled

June 22, 2020May 8, 2021Brigid D'SouzaData Visualizations, NJ User Friendly Budgets, Public budgets

This is a post in a series about NJ’s User Friendly Budget. My intent is to share basic analysis and insights with community as a way to encourage taxpayers to engage with this document and learn more about local public finance. Read the other posts in this series here including how to access your town’s...

The “User Friendly Budget”, Part 1: Intro to the Series & How to Access the UFB

June 15, 2020May 8, 2021Brigid D'SouzaData Visualizations, NJ User Friendly Budgets, Public budgets

Five years ago, New Jersey began mandating that every municipality* in New Jersey file a “User Friendly Budget (UFB)” as part of the annual budgeting process. This file is “user friendly” for a few reasons: The data is aggregated in unique ways that help us see the structural nature of how the city both...

Jersey City School Tax Expense Calculator for 2020/21 School Funding Year

May 18, 2020September 29, 2020Brigid D'SouzaData Visualizations, Jersey City School Funding Crisis, Property Taxes

I am part of the education team with Jersey City Together and in May 2020 we created a school tax expense calculator to help Jersey City residents understand the personal investment for a $50 million increase to the school levy. Our aim was to the put the power of understand property taxes into taxpayers’...

Jersey City’s Proposed 2020 Budget (Tableau #DataViz)

February 13, 2020October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Property Taxes, Public budgets

In February 2020 the City Council introduced its 2020 budget (the city has typically approved the annual budget only in the summer / Quarter 3 timeframe — I don’t know the reason for the lag, only that the lag exists). Upon release of the budget, I converted the PDF into Excel and then uploaded...

Demystifying the City Budget (A Retro-Look at the 2019 Budget)

February 1, 2020June 7, 2020Brigid D'SouzaData Visualizations

To help taxpayers access the annual city budget, I've visualized it the 2019/20 proposed budget in Tableau, a data visualization software. Tableau puts the power of analysis in the user's hands; my hope is that YOU will dig into this budget data and feel empowered to engage, or perhaps more fully engage, the annual...

A Closer Look at Jersey City’s School Tax Rate. Part 2: Statewide Comparisons & the Role of the Tax Base

October 17, 2019October 18, 2019Brigid D'SouzaData Visualizations, Jersey City School Funding Crisis

This is the second in a 4-part series about 2018 school tax rates, with a focus on Jersey City. This series will use public data that I have visualized in Tableau here. To read the first post in the series, click here. “How does Jersey City’s school tax rate compare with the rest of...

A Closer Look at Jersey City’s School Tax Rate, Part 1: the Public Data

October 15, 2019October 17, 2019Brigid D'SouzaData Visualizations, Jersey City School Funding Crisis, Property Taxes, Public Schools

This is the first in a 4-part series about 2018 school tax rates, with a focus on Jersey City. This series will use public data that I have visualized in Tableau here. I was asked recently, “how does Jersey City’s school tax rate compare with other towns and cities in NJ?” We can answer...

Jersey City’s 2019/20 Proposed Budget: Visualized APPROPRIATIONS (Expenses)

May 5, 2019October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations

Every municipality must pay for services that are then consumed by its residents. These services include: Police force (eg the JCPD) Fire department Road maintenance for city roads (a note on roads...in Jersey City, Ocean Avenue, Eerie Street, and Manhattan Avenue are city roads, thus they are maintained with city funds...however JFK Boulevard is...

2019/20 Proposed Advertised Appropriations (JCPS Spending for 2019/20 School Year)

April 28, 2019October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Jersey City School Funding Crisis, Property Taxes, Public Schools

Check out prior visualizations here that I'm sharing as part of the 2019/20 budget cycle. This visualization shows multiple lenses into the proposed 2019/20 "advertised appropriations" within Jersey City's public schools, as reported by the Jersey City Board of Education here. This budget has been prepared by the district administration and a finalized version,...

How does Jersey City Spend Its Money? A Data Visualization of Budgets from 2015-2018

April 25, 2019October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Property Taxes, Public budgets

As we look towards the coming weeks and months, two local governing bodies are undergoing a public budgeting process: The Board of Education will be determining the 2019/20 schools budget. The city of Jersey City will be determining the 2019 municipal budget. A key question is: how can taxpayers engage? How can we peel...

2018/19 Advertised Appropriations (What JCPS Spends Money On)

April 15, 2019October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Jersey City School Funding Crisis, Public Schools

This "tree map" shows the 2018/19 appropriations (i.e. expenses) for Jersey City Public Schools. I downloaded the data from the NJ Department of Education website, created a subset of "Appropriations" showing total spending, and then removed subtotals and totals so that only detailed lined items are visualized. Jersey City will lose $27 million in...

Jersey City’s 2017 School Based Budgets: Learn what’s being funded in your school

April 15, 2019October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Jersey City School Funding Crisis, Public Schools

This bubble chart shows 2017 actual spending within Jersey City's public schools, as reported by the 2017 Comprehensive Annual Financial Report ("CAFR"); 2017 is the most recent year available for this report. The CAFR is an annual report detailing both qualitative and quantitative information about the district. It is prepared by the district, approved...

Jersey City Facing $27 Million State Aid Cut for 2019/20 School Year

March 7, 2019August 24, 2019Brigid D'SouzaAdvocacy, Data Visualizations, Jersey City School Funding Crisis, Public Schools

Governor Murphy released his proposed fiscal year (FY) 2019/20 budget for NJ and this week, and it included a re-allocation of state education aid. The impact to Jersey City was both expected and gut-wrenchingly sobering: a $27 million cut in “Adjustment Aid”, a type of excess state aid that Jersey City has been receiving...

NJ Property Tax Dashboard: Updated for 2018 w/ Jersey City Highlights

March 6, 2019October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Property Taxes, Public Schools

Every year, the state of NJ publishes property tax data on the Department of Community Affairs website. I have combined all the available data, for tax years 1998 through the most recently published data for 2018, into one tabulation and visualized it in Tableau. This dashboard is intended to provide taxpayers with a bird's...

Taxpayer Guide to Education Spending – Total Spending Per Pupil (#OpenData Visualization)

February 5, 2019October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Jersey City School Funding Crisis, Public Schools

An explanation of “Total Spending per Pupil”, from the NJ Department of Education: “The Taxpayers’ Guide to Education Spending (Taxpayers’ Guide) provides the public the opportunity to view and compare all dollars spent on students enrolled in the public school system. In 2010-11, the Department updated this publication (previously the “Comparative Spending Guide”) to...

NJ Public Schools – Diversity Dashboard Using Income, Race, & ESL Data

January 21, 2019October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Public Schools

I was prompted by this tweet by Alpha Sigma Nu to celebrate Martin Luther King, Jr. Day (Jan 21, 2019). When I saw the tweet, the first thought that popped into my head was “better understand and share about school diversity.” There is a dataset I’ve been dabbling with for quite some time now; it’s...

Demand Fair Property Taxation: Using the Equalization Ratio as a Civic Tool

January 20, 2019October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Property Revaluation, Property Taxes

How can taxpayers ensure that local municipal and county governments are keeping property taxes fair and balanced? One suggestion: make sure that assessed values, i.e. the value of properties on the tax rolls, fairly reflect market values. One way we can do that is to refer to the annual equalization ratio, also known as...

NJ School Funding Basics: NJ Department of Education Data & Reports

January 4, 2019October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Jersey City School Funding Crisis, Public Schools

This is a quick initial post to point taxpayers to an excellent resource for rich, official public data about our public schools here in NJ. The NJ Department of Education (NJ DOE) has, for at least the past 10 years, published a host of different datasets on its “DOE Data & Reports” page. The...

Jersey City & NJ: Student Group Data from NJ School Performance Reports (A Focus on ELL, At-Risk, and Special Education Students)

October 6, 2018October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Jersey City School Funding Crisis, Public Schools

The NJ Department of Education publishes annual data relating to certain “student groups”, per school. The table below focuses on three groups that, per state funding law, are entitled to more funding based on the level of need. These groups are: At-risk students, defined as lower income students who qualify for free or reduced...

NJ Property Tax Dashboard | #OpenData #DataViz

September 27, 2018October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Property Taxes, Public Schools

This is a property tax dashboard for NJ residents who may be interested in learning about the property tax profile of their municipality, including: 1) Latest available (Tax Year 2017) property tax metrics available from NJ’s Property Tax portal. 2) Tax base growth chart from 1988 to 2017 – how has your town’s tax...

NJ Special Education Statistics | #DataViz #OpenData

September 22, 2018October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Jersey City School Funding Crisis, Public Schools

In this post I’m sharing statewide special education data, with ability to drill into Jersey City special education data specifically, for both Jersey City Public Schools (the public school system) and charter schools attended by Jersey City students. I am sharing the statewide data because it’s informing to see the varying degrees of special...

Jersey City’s Taxpayer Funded Schools: Enrollment Overview with Focus on Income Diversity

September 15, 2018October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Jersey City School Funding Crisis, Public Schools

The charts below show enrollment data for Jersey City Public Schools. The Jersey City Public Schools system is the 39-school district under the purview of the Jersey City Board of Education (BOE) and is funded through taxpayer dollars. Public charter schools also receive taxpayer dollars, but they are operated and overseen independently of the...

Property Revaluation Update: 202 out of 206 Homes on Neptune Ave in Greenville #JerseyCity were Over-Taxed.

March 29, 2018August 24, 2019Brigid D'SouzaData Visualizations, Property Revaluation, Property Taxes

I've got another Revaluation update, this one focused on Neptune Avenue which is an East/West street that stretches pretty much across Jersey City's south Greenville neighborhood. Similar to other Greenville Revaluation-related updates, this is a story of systemic overtaxation that is being fixed with Revaluation. First, some high level details about the data. Appraisal...

Country Village Revaluation Update: $3+ Million Estimated Tax Expense Reduction (and counting…)

March 18, 2018August 24, 2019Brigid D'SouzaData Visualizations, Property Revaluation, Property Taxes

March 18 2018. Appraisal Systems released a new batch of assessments on March 16th - the same day Jersey City's public school teachers went on strike. So...this latest update wasn't covered in the news. It should be though; finally, Country Village homes are listed. Per estimates released by Jersey City in December 2017, Country...

JerseyCity Revaluation Update: Society Hill Highlighted

February 18, 2018August 24, 2019Brigid D'SouzaData Visualizations, Property Revaluation, Property Taxes

Updated: Feb 19, 2018. Appraisal Systems today published on its website an updated assessments file with about 1,950 new properties added (note: I won’t be updating this page with every single new release from Appraisal Systems…but I have a property tax workshop tonight at Our Lady of Mercy Church and I wanted to be...

Jersey City 2017 Sales for Class “2” (1-4 Family) Properties, Mapped

December 2, 2017October 23, 2020Brigid D'SouzaAdvocacy, Data Visualizations, Property Revaluation, Property Taxes

This post is part of my effort to share information about Jersey City’s Property Revaluation. I wrote a Revaluation series last year which you can read here. In a citywide revaluation, your new assessment should equal your market value. When establishing market value of your home, one set of data that can be useful...