Application for Systemic Partiality Assessment (ASPA)

About ASPA Data Query Functionality

I developed this app to aid me in visualizing and analyzing data concerning various spiritual, political, and socio-economic factors and elements in our society.

One should keep in mind that statistics are not meant to be precise but do provide a good picture of what probably is going on, what needs to be celebrated, and what needs stronger more focused attention. Also, the data is constantly being fine tuned at various sources and different sources use different statistical methods. Therefore, the data may not be exactly the same across platforms/sources; however, they should approximate and do provide awareness as to proportionality/partiality issues.

Major data sources are the Census and FBI National Incidents Based Reporting System. Other data sources are also utilized as available and deemed useful. Census and FBI Applications Programming Interface (API) data runs 1 to 2 years behind the current year as they need time to maximize the integrity of the data.

The databases are large so at times it may take some time for the queries to run. When the query is done, a pop up will notify you as to its completion and success or failure. A failure will usually be due to no data being available that meets the entered query criteria.

Data for small racial/ethnicity categories are not listed by this App for some functionality at this time though they are valued as well. Plans are to include all race/ethnicity categories in all functionality.

Entry of Year is required. Data retrieval is hierarchical. To retrieve for a higher level, leave the lower level blank. For example to retrieve for the nation, leave all fields blank except the year. To retrieve for an entire state leave the county, city, and in the case of a crime data the Originating Agency Identifier (ORI) fields blank. To retrieve for a city complete the state and city and optionally the county field. To retrieve for a law enforcement agency complete the ORI field. Statistics are cleared when you make a change to some query parameters.

Census

This App where possible uses the Census Data APIs to maximize use of the latest Census Bureau updates rather than using static periodic downloads.

General Census Data Sources are given below:

Specific Census tables data sources are below:

The above data tables can be accessed here at the Census Bureau site. This will require you to select various parameter criteria to configure the Census site to yield the data universe you seek. This App aims to make it easier to retrieve the data sought. This App uses the 5 Year ACS rather than the 1 Year. So in comparing App results to the data tables make sure you look at the 5 Year ACS table rather than the 1 year ACS Table as the data may differ between the 5 Year and 1 Year Tables.

Clicking the Census Quick Facts i-icon may also reveal various data sets that may be useful. e.g., the Population and Housing estimates.

For information on how Census data sets differ in numbers see Fact Sheet: Differences Between the American Community Survey (ACS) and the Annual Social and Economic Supplement to the Current Population Survey (CPS ASEC).

For information on how the Census Bureau measures poverty see How the Census Bureau Measures Poverty

Some data queries will show population data smaller than the actual population. Yet, the relative statistical relationship between the various population groups are still interesting and useful for analytical purposes.

Some data retrieved will be for the actual year queried. Other will be the average over a 5 yeara period. For example the ACS 5 Year is an average over the 5 years.

The population data for the poverty retrieval will show numbers smaller than the annual population estimate by race, sex, and ethnicity such that the poverty data uses a smaller statistical population sample than the annual population estimates by race, sex, and ethnicity.

Sometimes you will see extremely large negative numbers. Census policy is to generate such values for example when "The estimate or margin of error cannot be displayed because there were an insufficient number of sample cases in the selected geographic area." This App retains those values though considering is being given to replace them with blanks or NA for Not Applicable in the future.

For Race Tables for 2022 see Race Data Tables.

FBI

The FBI does not currently provide a stable Data API like the Census so this App is not able to reasonably reliably retrieve and display data in format similar to Census data.

However the FBI does provide an NIBRS Data Website where data can be ascertained at its Crime Data Explorer.

Work in Process

I am retired and work on this app between other things. It is a work in process and not all desired functionality has been implemented.

Implemented algorithms have been tested. But even Microsoft has to periodically issue corrections. It is the nature of computer software technology. Therefore, if anyone detects any data retrieval where the numbers seem to fall outside reasonable statistical margin of error, please send a notice using the Contact menu on the main ASPA Home Page.

App Usage

App is currently offered free of charge for use by the public. However, it does take time, talent, and treasures to acquire tools and research the data and develop the app, therefore non-tax-deductible donations are accepted, if desired, here.