Home Ask a Question Submit a Data Request Data Warehouse Tutorials

Mapping Tools Charting Tools Analyzing Data Programming Tools Other Data Tools



Data Warehouse


Welcome to the NJ Advance Media Data Warehouse. This page is very much under construction, but is designed to allow reporters easy access to any and all New Jersey data available. There's a lot out there, but it can often be hard to find.

Initially, this page will be a gateway to some of our favorite state data sources on virtually every topic a news reporter could want. We hope to soon be hosting cleaned data for reporter use and add some search functionality to make navigating even easier. We also hope to expand it to include more federal data.

Have a suggestion for how we can make it better? Notice something that's missing? Please e-mail Carla Astudillo or Stephen Stirling on the data desk or hit the "Ask a Question" button at the top of the page. This page can't grow without the help of the reporting community.



Jump to Topic

CensusEducationPolitics/ElectionsCrime
TransportationCorrectionsHealthFinancial
Human ServiesVeteransClimate/WeatherProperty Taxes
AgricultureReal EstateEnvironmentalLabor
DisasterCity Data PortalsInfrastructureMiscellaneous
SocrataN.J. Data BookNJAM DataLive Data Feeds






Census


Census data can help you in a world of ways, from deepening a local crime story to revealing sweeping changes in the state's demographics.




Datasets


Census Reporter

A terrific and easy-to-use tool for finding basic Census data about any geographical area in New Jersey and the country beyond. Harnesses the power of the Census beautifully and gives you the option of embedding ready-made graphics to boot.


American Fact Finder

This is the Census' primary data digging tool. It has a slight learning curve, but once you get your head around it you can find data going back to 2000 on virtually anything you want. Best for looking at regional data, rather than just one place.


IPUMS

If you really want to dig deep into the Census, IPUMS gives you highly localized data on a broader diversity of topics than any other product available. Has a pretty high learning curve, so best to only use if you want to spend some time tackling something substantial.


Topics Covered

• Population • Income• Race• Ethnicity• Immigration• Migration
• Housing• Commuting• Poverty• Marriage• Veteran Status• Education
• Age• Fertility• Households• Building Type• Language• Property Value



Education


The N.J. Department of Education is very good about keeping data organized and in one place.



 
Datasets


State Education Data
Your one-stop shop for K-12 education data.


Electronic Violence and Vandalism Reporting System
Contains school weapons, fights, assault, bomb threats, bullying incidents, etc.


College Campus Safety and Security Data
From U.S. Department of Education, has data on alleged criminal offenses reported to campus security authorities and/or local law enforcement agencies.


Topics Covered

• Enrollments • Dropouts• State Aid• Program Data• Salaries and Benefits• Taxpayer Spending Guide
• Local Budget Summaries• Violence and Substance Abuse Reports• School Directory• Staff List• Teacher Surveys






Politics/Elections


Political data is one of the most robust and interesting sectors of data available, and one of the topics that bears the closest scrutiny.



 
Datasets


NJ ELEC's Campaign Finance Databases
Downloads of reports for some races and PDF filings for local elections


Federal Election Commission
Same as above, but for federal campaign finance data.


FEC-Scraper
Python library for handling FEC data


Fech
Ruby library for doing the same.


NJ Election Information and Results Archive
Historical election returns mostly in PDF


State legislature FTP
Bills, laws, votes and bill tracking information from the current and past sessions.


Topics Covered

• Campaign Finance• Federal Elections• State Elections• Local Elections• Python Utilities• Ruby Utilities






Crime


State Police data is pretty well kept and up to date, but is often still stored in PDFs. If you need help getting this into Excel, e-mail the data team or check out the Analysis Tools page for ways to unlock it.


 
Datasets


State Crime Data
Goes down to the municipal level. Fatal accident data also available through this data portal.


NJ Registered sex offender database
Query-based search results.


FBI Uniform Crime Reports
Federal crime data reports. In some cases more detailed than local data. In others not.


Arrest-related deaths 2004-2014
From NJ Advance Media "Kenwin Garcia" project.


Juvenile Justice Commission Data
Weekly statistics since 2011 in PDFs


Topics Covered

• State Crime • County Crime•Municipal Crime• Bias Incidents• Fatal Accidents• Domestic Violence
• Gang Survey• Crime Index Reports• Sex Offenders• Arrrest-Related Deaths






Transportation


The Department of Transportation is the main source for this information. It is well-kept and fairly up to date.



 
Datasets


Crash Records
Massive trove of accident data, sliced in several different ways


DOT Reference
Reference guide to DOT data. Includes links to other data and reports.


PATH Ridership
Five months of turnstyle data.


Federal Rail Administration data
Includes railroad accident data, among other things.


DOT GIS Data
Includes road and highway mapping files.


NJ Transit Rail GIS data
Mapping files for NJ Transit train lines.


NJ Transit Bus GIS data
Mapping files for NJ Transit bus lines.


Topics Covered

• Crashes By County • Crashes By Municipality• Crashes by victim/vehicle type•Crashes by Road Type• Cell Phone Data• Crash Rates






Corrections


DOC data has a decent amount of data, but it's sometimes difficult to download en masse.



 
Datasets


Offender Statistics
General statistics about New Jersey's prison and jail populations


Inmate/Prisoner Search
People finder for anyone currently or formerly incarcerated in New Jersey's corrections system


Topics Covered

• Jail/Prison Population• Individual Offender Data• Crime committed• Race/Ethnicity of Inmates• Term of Incarceration• Release Outcomes






Health


The state keeps loads of healthcare information in different places. In some cases, though, you may need to fight for exactly what you want.



 
Datasets


Center for Health Statistics
The Department of Health's central portal for vital statistics. Demographic information on the health of New Jersey residents is found here.


Hospital Reports
Annual performance reports from state hospitals


State Inspection Report Cards
For hospitals, nursing homes and other facilities, may require some scraping.


ProPublica's Dollars for Docs
Contains data on money received by doctors from pharmaceutical companies. CMS Open Payments database also has this data.


Data.Medicare.gov
Has quality measure comparisons for nursing homes, hospitals, home health and physicians.


New Jersey Prescription Drug Price Registry
Department of Consumer Reports hasn't released much from this database yet, but what they have is here.


Affordable Care Act
Plan prices down to the county-level.


FDA API
Contains adverse reactions and recalls for drugs, devices and foods


Patient Data Breaches
Unfortunately, an increasingly prevalent topic of study.


Topics Covered

• Births• Mortality• Disease information• Hospital Performance• Immunization• Child Poverty
• Hospital Discharges• Violent Deaths• Infant/Fetal Deaths• Healthy NJ• Behavioral Risk Data• Health Indicator Reports






Financial


Several different agencies keep financial data in New Jersey, from budget data to details on the state's banks.



 
Datasets


State Data Portal
The state's main data portal has most of the financial and budgetary information released by the state


State Transparency Center
The Governor's Transparency Center is the most up-to-date place for searchable, downloadable budget data.


Financial Institution Statistics
The Treasury Department keeps data on the state's financial institutions.


Insurance and Licensing
The Division of Banking and Insurance keeps data on insurance and licensing issues in the Garden State.


List of Banks
Pretty simple -- A list of all the banks in New Jersey.


NJ Business Records Service
A form-based query that may require some scraping to access data


Topics Covered

• Budget• Pension data• Benefits Data• State Revenues• State Expenditures• State Contracts






Human Services


The Department of Human Services is sort of a catchall agency, and carries data on a number of topics, from substance abuse to family development.



 
Datasets


Family Development
This page carries data on several topics, such as food stamps, child services and the WorkFirst New Jersey Program.


FamilyCare Enrollment
Enrollment data on the state's FamilyCare Program.


Substance Abuse Statistics
The Division of Addiction Services releases annual data on substance abuse in New Jersey.


Substance Abuse Treatment Reports
The state issues annual performance reports from substance abuse treatment centers.


Intoxicated Driving Program Reports
Data on the state's Intoxicated Driving Program.


Epidemiological Reports
Epidemiological reports are issued annually and have a trove of information.


Topics Covered

• Food Stamps• Child Services• Employment• Families• Substance Abuse• Drunk Driving
• Substance Abuse Treatment Centers






Veterans


There isn't terribly much kept in-state regarding military and veterans issues but there's still some data to be had.


 
Datasets


Veterans Data
The federal repository for Veteran's data. You can dig down to state levels through this site.


Veterans Affairs Publications
All of the publicans and data issued by the state Department of Veteran's Affairs



Weather/Climate


The state climatologist has virtually everything needed in terms of basic New Jersey weather and climate information.



 
Datasets


Climate Data
The state climatologist's website hosts historical data on New Jersey's climate


Temp/Precip Records
This page contains data for daily temperature and precipitation records for dozens of towns in New Jersey.


Weather Data
NJWeather.org has current and recent historical data on weather in New Jersey from more than 50 stations. Includes data in table, chart and map form.


CoCoRaHS
Daily rain/snow reports from more than 200 locations around New Jersey


National Climatic Data Center
The National Weather Service's most popular data products.


National Climatic Data Center
The National Weather Service's central repository for historical weather and climate data.


METAR Observation Data
METAR station observations.


U.S. Geological Survey Water Resources
Good source of river flooding and drought data.


Topics Covered

• Temperature• Records• Historical Data• Precipitation• Radar• Humidity
• Heat Index• Wind Chill• Wind Speed• Wind Gusts






Property Taxes


Property Taxes are one of the chief sources of agita among state Residents. The state puts out annual data on rates as well as municipal aid.



 
Datasets


All Property Tax Data
The Department of Treasury has most of the nitty gritty property tax information you may need.


Simplified Property Tax Data
If that is above and beyond what you need, the DCA has simplified versions of this data available for easy download.


Municipal Aid
Municipal Aid has a big impact on local taxes. The DCA issues annual data on this.


Property Ownership
Property ownership records from the Department of Treasury.


Topics Covered

• Average Taxes• Tax Rates• Municipal Aid• Abstract of Ratables• Assessments• Home Sales
• Tax Appeals• Sales by Use• Equalized Values






Agriculture


Agricultural issues are a surprisingly big deal in New Jersey, and there's a bevy of data available on both the state and federal level.



 
Datasets


Agriculture Statistics
The state's main portal for agricultural statistics


Farmland preservation
Data on farmland preservation in New Jersey.


Topics Covered

• Demographics• Crop Yields• Crop Prices• Environmental Issues• Livestock






Real Estate


Real Estate is one of the most robust data subjects around, and the aftermath of the Great Recession makes it a great topic for research.



 
Datasets


Construction Reporter
The Construction Reporter contains monthly data on all construction and demolition in New Jersey. The data lags a bit but is in good shape. The data custodian, whose contact info is listed on the site, is very helpful.


Foreclosure Statistics
The state Division of Banking releases data on foreclosures in New Jersey.


Zillow Real Estate Data
Zillow is a terrific resource for state and local real estate information. Their data team is incredibly helpful and if you can't find what you need, they'll grab it for you.


Property Assessment records


Topics Covered

• Foreclosure• Building Permits• Demolition Permits• Certificates of Occupancy• Home Sales• Median Pricing Information
• Estimated Values•Renter Data• Individual Home Pricing






Environment


The Department of Environmental Protection likely keeps more data than every other agency in the state. It's often a bit clunky to deal with. This section will likely grow with time.



 
Datasets


DEP Data Miner
The DEP's data tool is the best way to get at all the information on their site. It's clunky, but with a little work you can get what you're looking for.


Air Pollution
Air Pollution data collected daily by the DEP.


Drought
Drought and reservoir data collected weekly.


Bear Data
Data on the annual black bear hunt.


Delaware River Fishing Data
Data on freshwater fishing along the Delaware River.


Contaminated Brownfield Remediation
There's more than a few of these sites in New Jersey.


Wildlife, Fishing and Hnting Information
Various data and reports on wildlife and hunting in New Jersey.


Energy Emissions
Profile of New Jersey's energy emissions, consumptions and alternative fuel use, from US Energy Information Administration


Toxics Release Inventory
TRI data from the Environmental Protection Agency


DEP GIS Data
Mapping data from the Department of Environmental Protection.


Topics Covered

• Wildlife• Contamination• Environmental Reviews• Licenses and Permits• Regulated Sites• Hunting
• Fishing•Air Pollution• Drought






Labor


The Department of Labor keeps some of the most up to date and well-formated data in New Jersey.



 
Datasets


Employment Statistics
The state labor data portal has virtually everything you need to grab data on jobs and unemployment in New Jersey. Some databases updated weekly, others monthly.


OSHA Enforcement Inspections
Reports and data from the workforce safety agency.


Topics Covered

• Jobs• Unemployment• Labor Force Demographics• Workforce by Industry• Inflation• Employment Projections
• Historical Data• Workforce Injuries• Labor Calculators• Pay and Benefits• Spending and Time Use




Disaster


In the wake of Hurricanes Sandy and Irene, federal disaster data has become paramount in New Jersey.



 
Datasets


FEMA Data
The federal agency's main data feed hub and API.


FEMA flood maps
Updated in 2013. An embeddable map of these is also available on the Data Viz Embeds page.


Federal Procurement Data System
Database of federal contracts.


N.J. Sandy Info
Data on state programs and disbursement of funding in the wake of Hurricane Sandy.


Topics Covered

• Flood Maps• Contracts• Disaster Spending• State Programs• Housing Assistance• Disaster Assistance






City Data Portals


New Jersey municipalities have been slow to go digital, but a few of the state's larger cities are embracing open data.



 
Datasets


Newark Open Data
Newark recently opened a data portal, with new databases and apps being added fairly frequently


Jersey City Data Page
Jersey City is probably the best city thus far in terms of open data in New Jersey


Jersey City Open Data Portal
A searchable data portal for Jersey City


Hoboken's Open Data
Open data site for the city of Hoboken


Topics Covered

• Budget• Expenditures• Plow Tracker!• City Program Spending• GIS Data• Department/Agency Spending






Infrastructure


Infrastructure is becoming an increasingly important issue. Much of the state's infrastructure is more than a century old, underfunded and decaying.



 
Datasets


National Bridges inventory
Updated annually by the federal government.


National Dams Directory
Similarly, dam data is updated annually. Channel your inner Steve Buscemi -- "I am the best dam inspector in the business, and I am here to inspect this dam."


Jersey City Open Data Portal
A searchable data portal for Jersey City


Hoboken's Open Data
Open data site for the city of Hoboken


Topics Covered

• Year Built• Structural Integrity• Last inspection Date• Seriousness of flaws found• Action taken• Construction Details






Miscellaneous


These are all open datasets that didn't quite fit under a major category.



 
Datasets


Professional Dicensing Data
Form-based data retrieval queries.


Asbury Park Press' Data Universe
The APP has been keeping this searchable database of databases for years.


SPJ Toolbox
Society of Professional Journalist Toolbox with data resources.


N.J. Charities
List of licensed state charities from the Department of Consumer Affairs.


IRS Tax Exempt Group Database
A database kept by the IRS of all tax-exempt groups.


Religious Census
Reading the documentation is a must because there are many limitations, but the best count of religious data available in the United States.


Topics Covered

• Licensing• Searchable Data Portal• Charities• Non-Profits• Not-For-Profits• Religious Institutions






Socrata


Socrata is a data portal that provides a platform for many municipal, county and state data. Great for building apps. New Jersey has bought in at the state level and Socrata now powers data.nj.gov.


 
Datasets


Socrata
Find out how to pull data en masse and create apps using third party programs like Silk.co




N.J. Data Book


The N.J. Data Book, funded by Rutgers, is a great resource of information on a myriad of topics.



 
Datasets


N.J. Data Book

Data portal that combines Census, political, crime, poverty, housing and school data.


Topics Covered


• Population• Poverty• Crime• Population Density
• Employment• Housing• Financial• State Expenditures
• Property Tax Burden• Voters and Turnout• School Data• Election Results




NJAM Internal Data


This list contains live data feeds and publicly available APIs for development
Live Data Feeds/APIs


APIs and Live Data feeds for app development from around the web.



 
Datasets


Transcom
Live data feeds from 16 transit agencies including NJ Transit, the state DOT, the state police and the Port Authority of New York and New Jersey.


National Weather Service API
Public API for gathering graphical and text forecasts from the NWS


Dark Sky API
API for graphical and text forecasts used to power Dark Sky and Forecast.io.


Sunlight Foundation APIs
The Sunlight Foundation has seven APIs, including campaign finances and voting records [editor's note: Sunlight's APIs power these apps, so don't replicate anything already here, http://sunlightfoundation.com/projects/ ].


New Jersey Boundary Service API
Public API for gathering graphical and text forecasts from the NWS


U.S. Census API
Tap into the power of the U.S. Census. Probably unncessary unless working on a large project.


Facebook API
Limited due to privacy issues, but a public API for the massive social network.


Foursquare API
Could be some uses here for entertainment apps.


Twitter API
Robust API for accessing the abbreviated social network.


Untappd API
Beer data. Not much more to say.


Yelp API
Great for producing entertainment apps.


FDA API
Contains info on dangerous foods, recalls.