I CAPTURE PUBLIC
DATA / EVIDENCE

My goal is not to do depositions, or trials. I use visual aids to quickly convey complex topics through publicly accessible data and make opposing counsel abandon the attack/defense.

As such I run my business and expertise on undeniable statistics, I create the best planning and strategy to help win your case.

By the numbers:

2.5 years of expert witness

19 total cases

6 cases are pending

58% of my cases are the plaintiff

42% of my cases are defense

3 of my case I have been deposed in

4 cases have required reports

77% have positive outcomes

2 I have withdrawn from

Passionate and Committed Security Expert Witness - Ahrens Security Consulting

Let me show you how to win foreseeability cases with demonstrative data

Macro crime trends

Census tract comparison

Local Crime

Parking Garage

Resident Reviews

Other Public Data

Microsoft Power BI - Google Chrome 3_1_2022 6_24_39 PM.png

Census Tract Comparison

I analyze data and metrics such as population, unemployment and poverty. From different ages and specifics in population.

What I look at:

Incident type

Date and time breakdown

Individual incidents map

Violent crime heat map

Microsoft Power BI - Google Chrome 3_3_2022 9_44_36 AM.png

Census Overview

Macro Crime Trends

I use violent crime data gathered from the FBI's Uniform Crime Reporting (UCR) Database. I compare different crime rates at different cities and breakdown different sets of data that cover violence and property crimes.

What I look at:

Population

Education

Unemployment

Microsoft Power BI - Google Chrome 3_3_2022 9_43_34 AM.png

Violent Crime Comparison

Violent crime rates at a city level have been compared to those at a national and state level over time. The comparison takes Philadelphia's violent crime rate and divides it by the respective national or state violent crime rate. A value exceeding 1 means Philadelphia's rate is higher than the basis of comparison. For example in 2017, the violent crime rate for Philadelphia was 3.95 compared to the national average of 9.44 crimes per 1,000 residents.

This means Philadelphia's violent crime rate was 2.47 times (9.44/3.95) the national average (or nearly 2.5 times the national average). The data shows
Philadelphia's violent crime rate has remained well above national and state averages. The key takeaway, as evidenced by the nearly horizontal dotted trend lines, is that Philadelphia's violent crime rate has remained around 2.5 to 3 times higher than state and national violent crime rates.

Click on the images below to learn more...

Census Tract Comparison

I analyze data and metrics such as population, unemployment and poverty. From different ages and specifics in population.

What I look at:

Incident type

Date and time breakdown

Individual incidents map

Violent crime heat map

Census Overview

Macro Crime Trends

I use violent crime data gathered from the FBI's Uniform Crime Reporting (UCR) Database. I compare different crime rates at different cities and breakdown different sets of data that cover violence and property crimes.

What I look at:

● Population

● Education

● Unemployment

Violent Crime Comparison

Violent crime rates at a city level have been compared to those at a national and state level over time. The comparison takes Philadelphia's violent crime rate and divides it by the respective national or state violent crime rate. A value exceeding 1 means Philadelphia's rate is higher than the basis of comparison. For example in 2017, the violent crime rate for Philadelphia was 3.95 compared to the national average of 9.44 crimes per 1,000 residents.

This means Philadelphia's violent crime rate was 2.47 times (9.44/3.95) the national average (or nearly 2.5 times the national average). The data shows
Philadelphia's violent crime rate has remained well above national and state averages. The key takeaway, as evidenced by the nearly horizontal dotted trend lines, is that Philadelphia's violent crime rate has remained around 2.5 to 3 times higher than state and national violent crime rates.

Microsoft Power BI - Google Chrome 3_3_2022 9_46_32 AM.png

Local Crime

I look for raw data and a list of incidents from which I can analyze different factors in categories like Violence and Property crime.

What I look at:

● Incident type

● Date and time breakdown

● Individual incidents map

● Violent crime heat map

Microsoft Power BI - Google Chrome 3_3_2022 9_45_43 AM.png

Decomposition Tree

Below is a visual called a decomposition tree which breaks down the number of incidents by Crime Designation as identified in the previous Section 3.2, as well as by the specific crime. This visual helps to better understand how crimes are categorized as well as what portion of the overall number of crimes each subset represents. For example, selecting "Violent Crime" reveals the breakdown of violent crimes. Selecting "Homicide - Criminal" reveals that there were 2,363 criminal homicides during the analyzed time period between 2011-2018.

Microsoft Power BI - Google Chrome 3_1_2022 6_25_02 PM.png

Resident Reviews

I utilize a select group of reviews and keywords related to security such as crime, threat, danger, etc... This way I can effectively determine a building ability to provide safety for its residents.

What I look at:

● Overall ratings

● Sentiment analysis

● Summary

● Parking garage sentiment

● Parking garage security

Microsoft Power BI - Google Chrome 3_3_2022 9_46_55 AM.png

Summary

The graphs at the bottom of the page plots security related review sentiment over time. The lower left shows annual totals by sentiment category. The lower right plots cumulative positive and negative sentiment over time. In this graph, reviews with positive security sentiment add a point, while conversely, reviews with negative security sentiment remove a point from the running total. For example, when looking at all review sources, the net total is -14. This means that throughout the timeframe, there are 14 more negative sentiment reviews than positive sentiment reviews. The net security sentiment is negative for all review sources.

Microsoft Power BI - Google Chrome 3_1_2022 6_25_15 PM.png

Parking Garage: Specific Location Type

I analyze different crime reports from which several locations are being used, in this matter "Parking Garage / Lot"

What I look at:

● Specific location type

● Crime type

● Location

● Temporal analysis

● Comparative analysis

Microsoft Power BI - Google Chrome 3_3_2022 9_47_18 AM.png

Parking Garage / Lot Portion of Violent Crimes Over Time

Each violent crime reported is assigned to one of 46 possible location types, with one of these location types being "Parking Garage/Lot. As the data shows this location type is the third most common of all location types. Between the years of 2010-2018, a full 6.1% of all violent crimes took place in a parking garages or lots. This percentage is more than double the percentage that occurred in convenience stores or bar/nightclubs.