Data acquisition project:  identifying a database to pursue

Ira Chinoy / JOUR 772 & 472

 

The resources page on the class Web site – http://jclass.umd.edu/cars/772/resources.htm – has a section at the bottom on “Potential sources for data in Maryland,” which has links to Web sites for local, county and state governments and their agencies.  You can scout these for ideas – based on the activities of these agencies – but remember that the databases you are seeking for this assignment are not on the Internet.

 

In recent years, students have pursued the databases below.  They are listed here to help you generate ideas.  I prefer, in most cases, that you do not seek the same databases from the same agencies that were approached in the past year or two, and in general I would like you to consider databases that students have obtained in the past. If you do want to pursue any of these, be sure in your initial memo to include some alternates not listed here.

 

An asterisk (*) by dates after 2004 indicates that a database was obtained (the categories also appear in boldface).  An “X” indicates databases sought in 2001-2003.

 

 

 

Public safety, courts

 

Database

Maryland

Montgomery County

PG County

Other

 

911 response records / EMS calls for service

Fall 05

Fall 04

Spring 12

Fall 07

Spring 10
x

 

 

Police dispatch records

 

Spring 04

 Spring 08

 

 

Fire and rescue dispatch logs

 

 

Fall 11

 

 

Crime reports

Summer 04

Summer 04

Summer04
Spring 05*
Spring 07

Mount Rainier (Spring 04);
U.Md. Police (Spring 04);
Ocean City (Fall 04*);
(various  - summer 04);

Baltimore (Fall 08*)

 

Sex Offender Registry

Fall 07*

Spring 11

 

 

 

 

Homicide cases

 

 

Fall 05

Fall 08

 

 

Bomb squad cases

Fall 09*

 

 

 

 

SWAT team deployments

Fall 09

 

 

 

 

Air Medical Operations

Fall 11*

 

 

 

 

Domestic violence cases

Fall 09

 

 

 

 

Car theft

 

 Fall 11

Spring 05*

 

 

Carjacking cases

Spring 05
Fall 07*

 

 

 

 

Gang incidents

 

 

 

Joint County Gang Prevention Task Force (Spring 06)

 

Gun permits

Spring 09

 

 

 

 

Concealed firearms permits

Spring 10

 

 

 

 

Application to purchase firearms

Fall 09

 

 

 

 

Body armor licenses

Fall 04

 

 

 

 

Prostitution-related arrests

 

x

x

 

 

Missing persons

 

 

Spring 04

 

 

Prison staffing

Fall 04

 

 

 

 

Prison incidents (violent)

Spring 07*

Spring 09*

Spring 10

 

 

 

 

Juvenile detention facility incidents

Spring 10

 

Pedestrian accidents

Spring 04

Fall 04

 

 

 

Traffic accidents

Spring 05;
Spring 06;

Spring 08;

Fall 08;

Spring 09;

Spring 10

Fall 10

Spring 11

Fall 11

Spring 05

 

Baltimore City (x)

 

Drunk-driving fatalities

Spring 10

 

 

 

 

Truck accidents

Spring 09

 

 

 

 

Traffic tickets

2001-2003

 

 Spring 09

 Anne Arundel Co. – Spring 09

 

Traffic stops

Spring 06

Spring 04;
Spring 06

Fall 04

 

 

Red-light camera citations

 

 

x

 

 

Parking tickets

 

 

Spring 04

College Park (Fall 04);
Baltimore (Spring 06)

 

Towed cars

 

 

Spring 04

Baltimore County (Fall 04)

 

Complaints against police

 

 

x

 

 

Oversight of police misconduct cases

Fall 10

 

Qualifications of court translators

2001-2003

 

 

 

 

Court translators and their languages

Fall 09

 

 

 

 

Metro-rider citations

 

 

 

WMATA (2001-2003)

 

Firefighter salaries

 

 

x

 

 

House fires

x

 

 

 

 

Arson

x

 

 

 

 

False alarms

 

 Fall 08

x

 

 

False fire alarms

 

 

 

 

 

Fire-safety inspections

 

 Summer 08

x

 

 

Missing children

Fall 04

 

 

 

 

Parole & probation cases

Spring 06

 

 

 

 

Prison cases

Fall 06

 

 

 

 

 

Education and child care

 

Database

Maryland

Montgomery County

PG County

Other

 

Teacher turnover

 

 

x

 

 

Teacher salaries

 

X

Spring 09

Fall 05

Spring 10

Howard County (Spring 05)

 

School health services

 

Fall 08*

 

 

 

School health inspections

 

Spring 05 *

Fall 06

 

 

 

School bus accidents

Spring 10

 

 

School building safety inspections

Spring 10

 

 

School construction projects

x

 

 

 

 

Federal Title I funds to city schools

 

 

 

 Baltimore City (Fall 09)

 

School system budgets

 

 

 

Harford County (Spring 04)
Howard County (Spring 05 * )

 

School system database of serious incidents

 

Spring 04

 

 

 

Student truancy cases

 

 

Spring 12*

 

 

 

Student arrests

 

 

 

Baltimore City (Spring 11*)

 

Teacher injuries

 

Spring 05

 

 

 

Student demographics in gifted program

 

x

Spring 06

 

 

Homeless children in schools

Fall 04

 

 

 

 

Students in subsidized lunch program

 

 

Spring 12*

 

 

 

School discipline cases

 

 

 Spring 10

Somerset County (Fall 06)

 

School dropouts

 

 

 

Baltimore city (Fall 09)

 

Home schooling cases

 

Spring 12*

Fall 06*

 

 

Student demographics, lunch subsidies and achievement

 

Spring 09

 

 

 

Student race

 

 

 

Anne Arundel County (x)

 

Teacher performance evaluations

 

x

Spring 04

 

 

Teacher certification and qualifications

Spring 10

 

Teacher salaries, education, certification, school assignment

Baltimore City (Spring 10)

 

Teacher certification

 Spring 10*

 

Spring 04

Anne Arundel County (Fall 06)

 

Teacher qualifications

Spring 08

 

 

Howard County (Spring 08);

Anne Arundel County (Fall 09)

 

Complaints against school employees

 

Spring 08

 

 

 

Infants and toddlers programs

Spring 07

Spring 07

 

 

 

Licensed child-care providers

Spring 05

 

 Fall 08

 

 

Inspections of child-care facilities

Spring 06

 

 Fall 08

 

 

 

Complaints against child-care facilities

Spring 10

 

 

 

 

Foster parent applicants

Spring 09

 

 

 

 

Playground inspections

 

Spring 09

 

 

 

School cafeteria inspections

Fall 09

 

 

 

 

 

Health and food safety

 

 

 

 

 

 

 

Database

Maryland

Montgomery County

PG County

Other

 

Restaurant / food store / food truck inspections

 

Spring 04*
Fall 07

Spring 08

Summer 08

Fall 08

Fall 11

 Spring 08

Culpeper County, Va.;
St. Mary's County - Fall 04

Baltimore County – Spring 09

Anne Arundel Co. (Spring 11*)

Anne Arundel Co. (Spring 12*)

 

 

Restaurant compliance with controls for discharge of fats, oils & grease

 

Bar and restaurant fire inspections

 

 

Spring 05

 

 

Tobacco compliance (re: sales to minors)

Fall 05

 

 

 

 

Smoking ban inspections

 

Spring 06

Fall 06

 

 

Licensed restaurants

 

Spring 10*

x

 

 

Dining hall inspection records

 

 

x

 

 

Food processing plant inspections

Spring 05

 

 

 

 

Egg inspections

x

 

 

 

 

Milk plant inspections

Fall 07

 

 

 

 

 

Food-producing animals inspections

Spring 10

 

Organic farm certifications

Spring 12

 

 

 

 

 

Radon inspections

 

Spring 12*

 

 

 

 

Rabies tests

Spring 05

 

 

 

 

Lead inspections of housing

Spring 05 *

 

 

 

 

Blood lead tests of children

Spring 05 *

 

 

 

 

Pharmacy regulation

x

 

 

 

 

Pharmacy mistakes

Spring 05

 

 

 

 

Pharmacy & pharmacist registration

Fall 06*

 

 

 

 

Poison hotline call logs

Fall 11

 

 

 

 

Hospital inspections

Spring 04

 

 

 

 

Hospital discharge data

 

 

 

Metropolitan DC area (Fall 04)

 

Hospital complaints

Fall 11

 

 

 

 

Mental health hospitalizations

Fall 04
Spring 07

Spring 11

 

 

 

 

Mental health services

 

 

 

Anne Arundel (Spring 08)

 

Outpatient facility inspections and complaints

Spring 04

 

 

 

 

 

HIV/AIDS cases

Spring 10

 

Reportable diseases

Fall 10

 

Institutional inspections

 

 

Fall 07

 

 

Inspection of radiological devices

x

 

 

 

 

Methadone clinic inspections

Fall 04

 

 

 

 

Licensed Assisted-Living Places

x

 Summer 08

 

 

 

Nursing home inspections

x

 

 

 

 

Indigent maternity care cases

 

 

Spring 04

 

 

Construction site accidents

Spring 07*

 

 

 

 

Accidental deaths

Spring 04

 

 

 

 

Cervical cancer deaths

Spring 07

 

 

 

 

Health claims arbitration

Spring 04

 

 

 

 

Licensed physicians

Spring 04

 

 

 

 

Disciplinary actions against physicians

Spring 04,

Fall 05

 

 

 

 

Dialysis facility regulation

x

 

 

 

 

Health-related consumer complaints

Spring 04

 

 

 

 

Poison center calls

Fall 05

 

 

 

 

Reports of communicable diseases

Spring 08

 

 

 

 

Child health insurance cases

Spring 08

 

 

 

 

Medicaid cases

Spring 08

 

 

 

 

 

Business and Workplace Regulation

 

 

 

 

 

 

 

Database

Maryland

Montgomery County

PG County

Other

 

Workers compensation court cases

Spring 05;

Fall 09

 

 

 

 

Workplace injuries
 & regulatory activities

Spring 05 *
Fall 06

Fall 09

 

 

 

 

Workplace accidents

Fall 10

Spring 12*

 

Liquor licenses

 

x

x
Spring 07*

Summer 08

 Baltimore County (Fall 08)

 

Liquor license violations

 

 

Spring 03*,

Fall 05*

Summer 08

 

Anne Arundel Co. (Spring 12)

 

Business licenses

Spring 11

 

 

 

 

Minority business bidders database

 

 

Spring 12*

 

 

 

Licensed charities

x

 

 

 

 

Licensed collection agencies

Spring 04

 

 

 

 

Pawn shop transactions

 

 

x

 

 

Licensed morticians and complaints

Spring 04

 

 

 

 

Cemetery complaints

Spring 08

 

 

 

 

Swimming pool inspections

 

Fall 01*

Spring 11

Spring 11

 

 

Elevator inspections

pre-2004*;
Spring 06

 

 

 

 

Elevator accidents

Spring 04

 

 

 

 

Consumer complaints

Spring 05 *
Spring 07*

Spring 10

Spring 11*

 Fall 08*

 

 

 

Cable service complaints

 

Fall 07*

 

 

 

 

Consumer complaints against health clubs

Spring 10

 

Complaints about morticians

Fall 05

 

 

 

 

Complaints about cemeteries

Fall 10

 

 

 

 

Complaints about home inspectors

Spring 09

 

 

 

 

Complaints against insurance companies

Fall 09

Fall 11

 

 

 

 

Complaints against utility companies

Fall 09

 

 

 

 

Licensed utilities, outages

x, Fall 2005

 

 

 

 

Taxi cab complaints

x

 

 

 

 

Human Relations Commission complaints

 

 

x

 

 

Amusement ride inspections

Fall 05*

 

 

 

 

Amusement ride accidents

x

 

 

 

 

Prevailing wage reports and enforcement

Spring 07

 

 

 

 

Wage/hour law complaints

Fall 04

 

 

 

 

Complaints of unpaid wages

Spring 05*

Spring 12*

 

 

 

 

Migrant worker camp licenses / inspections

Spring 05
Fall 06*

 

 

 

 

Assisted living places - licenses

Spring 05

 

 

 

 

Assisted living places - complaints

Spring 05

 

 

 

 

Vendor licenses

 

 

 Fall 09

Baltimore County (Fall 05)

 

Cosmetology inspections

Spring 12*

 

 

 

 

 

Cosmetology licenses / complaints

Fall 06

Summer 08

 

 

 

 

 

Animal care and regulation

 

 

 

 

 

 

 

Database

Maryland

Montgomery County

PG County

Other

 

Animal attacks/bites

 

Fall 05
Fall 07

 

Baltimore City (x)

 

Animal control cases

 

Spring 05; Spring 10

pre-2004;
Spring 06;

Fall 09

 

 

Animal abuse cases

 Spring 09

 

x

 

 

Animals picked up by county agency

 

Spring 04

Spring 10

 

 

 

Pit bull cases brought by police

 

 

Spring 04

 

 

Pet registration

 

Fall 07

Spring 09

 

 

 

Dog, cat and ferret licenses

 

 

x

 

 

Poultry flocks (non-commercial)

Spring 07*

 

 

 

 

Injured and dead race horses

Fall 09

 

 

 

 

Horse farm licenses

Spring 07*

 

 

 

 

Exotic animal permits

Fall 04
Fall 07

Fall 11

 

 

 

 

Registered veterinarians

Spring 04

 

 

 

 

Animal nuisance calls

Fall 05

 

 

USDA (Fall 05)

 

Bear complaints

Fall 04

 

 

 

 

Large animal deaths from traffic collisions

Spring 07

 

 

 

 

 

Environmental regulation

 

 

 

 

 

 

 

Database

Maryland

Montgomery County

PG County

Other

 

Environmental complaints

 

Fall 04

 

 

 

Fish contamination

Fall 10*

 

Hazard mitigation grants

Spring 07

 

 

 

 

Pesticide incidents

Fall 08

 

 

 

 

Pesticide levels

Spring 09

 

 

 

 

 

Chesapeake Bay spending / restoration

Spring 10

Fall 11*

 

Auto emissions testing

2001;

Fall 05*

 

 

 

 

Solid waste disposal

x

 

 

 

 

Water system usage audits

x

 

 

 

 

Impaired waterways

Spring 07*

 

 

 

 

Sewage system leaks

 

 

 

WSSC (x)

WSSC (Spring 10)

 

Water main breaks

 

 

 

Baltimore City (Spring 05)

WSSC Spring 09*

 

Nutrient runoff

Fall 2005

 

 

 

 

 

Water pollution tests

Spring 10*

 

Water quality

Spring 11*

 

 

 

 

Fish and shellfish contamination

x

 

 

 

 

Fish population studies

Fall 08*

 

 

 

 

Fish kills

Spring 12*

 

 

 

 

 

Leaking underground storage tanks

Fall 04

 

 

 

 

Landfill records

 

 

Spring 06

 

 

Crabbing / poaching violations

Spring 05 *

Spring 10*

 

 

 

 

Natural resources police citations

Spring 08

Summer 08

 

 

 

 

Public agency recycling reports

Spring 08

 

 

 

 

Water well inspections

Fall 06*

 

 

 

 

Pollution control permits

Fall 09

 

 

 

 

Pollution discharges into Chesapeake Bay

Spring 08

 

 

 

 

 

Transportation and infrastructure

 

 

 

 

 

 

Database

Maryland

Montgomery County

PG County

Other

 

Real estate purchases for road projects

x

 

 

 

 

Potholes, road complaints

 

 

 Spring 10

Bowie;
College Park (Spring 04); Baltimore County (Spring 08)

 

Government vehicle fleet management

 

 

Spring 2012*

 

 

 

Road repair projects

 

Spring 07*

Fall 04

Howard Co. (Fall04); Baltimore County (Fall 05*)

 

Bridge inspections

Fall 05*
Fall 07*

 

 

 

 

Railroad inspections

Spring 05 *

 

 

 

 

MARC train on-time performance

Fall 08*

 

 

 

 

Taxi cab inspections

Fall 07

 

 

 

 

Hybrid car registrations

Spring 05

 

 

 

 

Traffic sign replacement

x

 

 

 

 

E-Z Pass usage

x

 

 

 

 

Shipping logs, Port of Baltimore

Spring 12*

 

 

 

 

 

Boating accidents

Summer 08

 

 

 

 

Port of Baltimore shipping

 

 

 

MD Port Authority  - Spring 09

 

Motor fuel inspections

Fall 08

 

 

 

 

Pipeline inspections

Fall 10

 

 

 

 

Gas stations

Fall 08*

 

 

 

 

Gas station inspections

Fall 08

Spring 09 *

 

 

 

 

Gas pump inspections

Spring 10

 

 

 

 

 

Government spending, benefits, services

 

 

 

 

 

 

 

 

Database

Maryland

Montgomery County

PG County

Other

 

Government contracts (state, stadium  authority, homeland security, etc.)

x
Fall 05;

Fall 09

 

 

 Md. Stadium Authority (Fall 09)

 

Government expenditures (check registry)

 

 

Spring 11

 

 

 

Capital Improvement Projects

Spring 11

 

 

 

 

 

Fire hydrant inspections

 

 

 

WSSC (Fall 09)

 

Energy assistance grants

Fall 10*

 

 

 

 

Homeland security grants

Fall 08

 

 

 

 

Municipal and state liability claims

Spring 09

 

 

Baltimore city (Spring 07)

 

Live Near Your Work grants

 

 

 

College Park (x)

 

Public employee salaries

x

 

Spring 05

 

 

 

City/County complaints and service requests

Baltimore (Spring 10)

 

Rat complaints

Baltimore (Fall 10)

 

Adult literacy training

 

 

 

Howard Co. (Spring 11)

 

 

Food stamp cases

 Fall 08

 

Fall 07

 

 

 

Food assistance fraud

Spring 10

 

Unemployment compensation

x

 

 

 

 

Government pension cases

Fall 08

 

 

 

 

Government construction contracts

Spring 09

 

 

 

 

New business incubators

Fall 04

 

 

 

 

Tobacco farmer buyouts

Fall 04

Spring 09

 

 

 

 

National Guard equipment inventory

Spring 09

 

 

 

 

Arts grants

Fall 08; Spring 10

 

 

 

 

Film production rebates

Spring 08

 

 

 

 

 

 

Housing and real estate issues

 

 

 

 

 

 

 

Database

Maryland

Montgomery County

PG County

Other

 

Property tax assessments

Fall 08

 

Spring 11*

 

 

Housing code inspections

 

 

Spring 07

 

 

Rental housing inspections

 

 

Spring 09

 

 

Housing complaints

 

 

 

Baltimore (Spring 07*)

 

 

Housing code complaints

 

 

Baltimore (Fall 10)

 

Housing code enforcement

 

 

Spring 10

 

Noise code violations

 

 

 

College Park (Spring 08)

 

Building defect complaints

 

 

Spring 07

 

 

Housing, lending discrimination complaints

x
Spring 07

 

 Fall 08

 

 

Rental property occupancy violations

 

 

Fall 05

 

 

Foreclosures

 

 

Fall 09

Spring 11*

 

 

 

Lead contamination inspections

Fall 09*

 

 

 

 

Rental housing inspections

 

Fall 07

 

 

 

Real estate transactions

Spring 07*

 

 

 

 

 

Historic properties

Spring 11

 

 

 

 

 

 

Public housing tenant complaints

Baltimore (Spring 10)

 

Public housing resident characteristics

 

Spring 04

 

 Baltimore (Fall 08)

 

Public housing waiting list

 

Spring 06*

 

 

 

Urban renewal relocation of public housing tenants

 

 

 

Baltimore (Fall 08)

 

Housing improvement grants

Spring 06

 

 

 

 

Energy assistance subsidies

Spring 06

 

 

 

 

Homeless hotline calls

 

 

x

 

 

Homeless case tracking

 

 

Fall 06

 

 

 

Other

 

 

 

 

 

 

 

Database

Maryland

Montgomery County

PG County

Other

 

Lottery agents and sales

Spring 11*

 

 

 

 

 

Attorney grievance cases

Fall 06

 

 

 

 

Attorney sanctions

Fall 06*

 

 

 

 

Human rights complaints

Fall 06

Fall 08

Fall 04
Spring 07

Fall 10

 

 

 

Elder abuse complaints

Fall 10*

 

International refugees

Spring 06*
Fall 06
Spring 07*

Fall 09*

Fall 10*

 

 

 

 

Artworks owned by the government

Fall 10*

 

State income tax audits

Spring 04

 

 

 

 

Maryland Film Office registered sites, spending.

Fall 04

Fall 11*

 

 

 

 

Information technology companies & investment

 

Spring 06

 

 

 

 

Voter registration

 Fall 11

 

Spring 06

Baltimore City (x)