Fairfax County Tax Assessments

Fairfax County’s Open Data GIS system makes several large datasets covering parcels within the county available to the public. The datasets must be combined using statistical software before they can be analyzed. For this project the relevant data are included in two datasets: Legal data:¬†https://data-fairfaxcountygis.opendata.arcgis.com/maps/tax-administrations-real-estate-legal-data/about Assessed Values:¬†https://data-fairfaxcountygis.opendata.arcgis.com/datasets/Fairfaxcountygis::tax-administrations-real-estate-assessed-values/ These datasets are imported with irrelevant columns being… Continue reading Fairfax County Tax Assessments

Analyzing S&P 500 Returns

Today, September 13, 2022, was a bad day for stocks. The Bureau of Labor Statistics published their monthly Consumer Price Index. It came in at a rise of 0.1% for the month of August compared with the month of July 2022. Compared to August of last year, CPI has risen 8.3%. Economists the Journal surveyed… Continue reading Analyzing S&P 500 Returns

Linear Regression

The multiple linear regression estimator grabs COVID case loads from several surrounding jurisdictions from the New York Times GitHub page for their COVID tracker. Population estimates were gathered manually from the Census Bureau: Fairfax, Virginia: 1,150,309 Montgomery, Maryland: 1,051,000 Prince George’s, Maryland: 909,327 Falls Church city, Virginia: 14,658 Arlington, Virginia: 232,965 Prince William, Virginia: 470,335… Continue reading Linear Regression

Gender Map Regression Analysis

Given the distribution of gender ratio by race, and documented social determinants of female bias in gender ratios amongst Black populations, can this effect be quantified in the DC data? The ACS data includes columns for Black population. We can engineer a ‘% Black’ column by dividing by Total Population. Looking at the percentage of… Continue reading Gender Map Regression Analysis

Gender Map Racial demographics

Social scientists refer to the gender ratio of male adults to female adults as the Adult Sex Ratio (ASR) and racial disparities of the ASR are well-documented in research literature. For both Whites and Blacks, more males tend to be born than females, although blacks (ASR at birth: 102.9) have a lower prevalence than whites… Continue reading Gender Map Racial demographics

DC Gender Ratio Map

With the combination of two Python frameworks (Geopandas and Folium [which is itself a wrapper for the leaflet.js library]) we can create a custom choropleth map of gender ratio for each census tract in DC: Since the data is strictly binary, this map is trad-coded with majority-male tracts in blue hues and majority female tracts… Continue reading DC Gender Ratio Map

DC Gender Map Part II

The ACS is geographically organized by hierarchy–block groups at the most granular level, followed by census tracts, counties, states, regions and the nation as a whole. Census tracts are a common grouping used in geographic analysis since they are specifically designed for this purpose. Tracts are small, relatively permanent statistical subdivisions of a given geographic… Continue reading DC Gender Map Part II

The Great Termination

The #greatresignation is turning into the #greattermination. Increasing borrowing costs and cooling of consumer sentiment in the face of rising inflation are driving down revenues and putting pressure on margins for companies. It seems like the job market is turning back against workers in favor of managers and owners. Recessions provide managers with ample opportunities… Continue reading The Great Termination

DC Gender Map

Dating in DC is notoriously difficult; and (depending on who you ask), it’s especially difficult for straight (cishet) women. According to Census Bureau data gathered in the American Community Survey (ACS) the city’s demographics make a strong argument for this case. The overall male-to-female gender ratio (number of males divided by number of females) is… Continue reading DC Gender Map