query
a pythonic query language
Sign in or create a new account.


City = 'Portland' and State = 'OR'
Name Date COD OD SOMI
James Lamberson 20000512 Gunshot Justified Unknown
George Waldum 20000823 Gunshot Justified Unknown
Ollie B. Russell 20001010 Asphyxiated/Restrained Unreported No
Michael Ray Jaquith 20001218 Gunshot Justified Unknown
Nancy Lee Logan-Morgan 20010127 Vehicle Unreported No
Colby Lee Diller 20010127 Vehicle Unreported No
Jos? Santos Victor Mej?a Poot 20010401 Gunshot Justified Yes
Raymond Leonard Youngberg Jr. 20010709 Gunshot Justified Yes
Daniel Cromb 20011209 Gunshot Justified Unknown
Byron Hammick 20020222 Gunshot Justified Unknown
Anthony Utah-Zona Beck 20020421 Gunshot Justified Unknown
Kendra James 20030505 Gunshot Justified Yes
Eddie Homsombath 20031021 Gunshot Justified No
Shane Eric Clements 20031224 Gunshot Justified No
Jose Angel Padilla 20040103 Gunshot Justified Unknown
James Jahar Perez 20040328 Gunshot Justified Yes
Bruce Perison Clark 20041122 Gunshot Justified No
Willie Thomas Grigsby 20041202 Gunshot Justified No
Ronald Richard Riebling Jr. 20050320 Gunshot Justified No
Vernon Allen 20050519 Gunshot Justified Unknown
Raymond Dwayne Gwerder 20051104 Gunshot The city of Portland has agreed to pay a $500,000 settlement, but the grand jury said the killing was Justified. yes
Dennis Lamar Young 20060104 Gunshot Justified No
Timothy Grant 20060320 Tasered Justified Unknown
Marino Sanchez-Sanchez 20060701 Vehicle Excusable No
Jerry Goins 20060719 Gunshot Suicide Yes
Lukus Glenn 20060916 Gunshot Justified No
James Philip Chasse Jr. 20060917 Beaten/Bludgeoned with instrument The city of Portland and the family of James P. Chasse Jr. have reached a $1.6 million settlement in the familys federal wrongful death lawsuit. Grand jury found the homicide Justified. Yes
David Earl Hughes 20061112 Gunshot Unknown Unknown
Steven Richard Bolen 20070522 Gunshot Justified Yes
Jason Spoor 20080513 Gunshot Justified Unknown
Derek J. Coady 20080515 Gunshot suicide No
Aaron Marcell Campbell 20100129 Gunshot Justified Yes
Jack Dale Collins 20100322 Gunshot Justified Unknown
Keaton Dupree Otis 20100512 Gunshot Justified Yes
Bryan Guerrero 20100620 Gunshot Justified No
Craig Boehler 20101123 Asphyxiated/Restrained Justified No
Darryel Dwayne Ferguson 20101217 Gunshot Justified No
Thomas Higginbotham 20110102 Gunshot Justified Yes
Darris Eugene Johnson 20110709 Medical emergency Justified no
Bradley Lee Morgan 20120125 Gunshot Justified Unknown
Ervin Jeff Dirnbaugh 20120416 Gunshot suicide Unknown
Christopher Karl Bullert 20120425 Gunshot suicide Yes
John Wimberly Smith 20120429 Gunshot suicide Yes
Billy Wayne Simms 20120728 Gunshot Justified No
Merle Mikal Hatch 20130217 Gunshot Justified Unknown
Santiago A. Cisneros III 20130304 Gunshot Justified Unknown
Kelly Vern Mark Swoboda 20140312 Gunshot Justified Yes
Nicholas Glendon Davis 20140612 Gunshot Justified Yes
Christopher R. Healy 20150322 Gunshot Pending investigation Unknown
Alan Lee Bellew 20150628 Gunshot Pending investigation Drug or alcohol use
Michael Johnson 20151106 Gunshot Pending Investigation Yes

Parameters:
Address, Age, CauseOfDeath, City, County, Date, DayOfMillenium, DayOfWeek, Description, ImageURL, LawEnforcementAgency, Month, Name, NewsURL, OfficialDisposition, Prace, Sex, State, SymptomsOfMentalIllness, Year, Zip

The PyQL query format is: fields @ conditions.
  fields is a field or a comma delimited list of fields.
 conditions is a condition or an and delimited list of conditions.

Both fields and conditions are made up of terms.
A term is a valid Python expression in a name space made up of: database parameters; any imported python modules; PyQL Aggregators such as Average (A), Sum (S), and Replace (R); and other domain specific terms.

About the Fatal Encounter DatabaseSample Queries
The Data

This database was download as a spreadsheet from FatalEncounters.org. Brian Burghart maintains this spreadsheet and welcomes your support. You can e-mail Brian d.brian [at] fatalencounters.org.

The first step in importing Brian's spreadsheet into a PyQL database involved taking non-alpha numberic characters out of headers and using them in CamelCase. For example, the spreadsheet header of 'law enforcement agency' becomes the database parameter 'LawEnforcementAgency'.

Agile Access to Database Parameters

The CamelCaseFormatting of database parameters is logical, readable, and verbose. With domain specific query languages you get to make the rules for parameter reference. And here we like: Access parameters by their capitalized letters and fill in lower case letters as needed to remove ambiguity. Like this for getting the the Date,Name,CauseOfDeath,OfficialDisposition, and the Prace (perceived race) for fatal encounters with law enforcement in Multnomah County:
Date,Name,COD,OD,Prace@Co='Multnomah'

To see the number of fatal encounters with law enforcement for each city in the database, use the PyQL: S(1),R(City)@City

This query form is handy for breakdown by any parameter. To see fatal encounters by state, use the PyQL: S(1),R(St)@St

And likewise for CauseOfDeath, use the PyQL: S(1),R(COD)@COD

And for Prace (perceived race), use the PyQL: S(1),R(P)@P

To see details of all fatal encounters in Portland, Oregon, use the PyQL: Name,Date,COD,OD,SOMI@City='Portland' and State='OR' s.