DATABASE QUERY PAGE Maryland's Finest

Select which report you would like to generate.

Report entire database
Report of all stops by selected trooper
      Trooper's Name:
      (examples: D.Blake )
Report of all stops where drugs were found
Report or all stops where money was found
Retrieve report by case number
      Enter Case Number:
      (examples: A-62-01740)

Enter e-mail to get comma de-limited query resultsvia e-mail.

Your E-mail:

List of queries used

ALL: SELECT * FROM final
TROOPER: SELECT * FROM $databaseName WHERE trooper_name LIKE '$trooperName'
DRUGS: SELECT * FROM $databaseName WHERE drugs_recovered = 'y'
MONEY: SELECT * FROM $databaseName WHERE money_recovered = 'y'
CASE: SELECT * FROM $databaseName WHERE case_no LIKE '$caseNum'

Source for dataset -- under drugs.xls

Select which report you would like to generate.

Enter e-mail to get comma de-limited query resultsvia e-mail.

List of queries used

Source for dataset -- under drugs.xls

You are visitor number: