Combat Patrol - Dynamic Data Site

TextAnswerID	c28e1805-b2f1-4044-86d5-4fef47c0fe0f
Answer	‘term’; DROP TABLE Cases GO -- * * *
OrderIndex	* * * * *
CaseSection	* *
Question	Check all that apply Provide a name for the family event Explain the violent media/entertainment or writing Was the suspect known to the criminal justice system? (As an offender or victim) Please explain Was the suspect involved with an unusual level of violent media/entertainment or written materials? What recommendations would you make so that an attack or planned attack can be avoided in the future? How many people were injured during the attack? Was the suspect teased or bullied? Select all that apply from School Administration Was the suspect employed at the school? How far along in the stages did the planned attack progress? If the attack was averted, how was it averted? Explain Grade Level: If this suspect was a student, were there any significant changes in academic performance prior to the discovery of the plot or attack? Suspect's age (years) at the time of the plot discovery or attack: Explain Please describe Please describe Select the type of bullying Please describe the reasons the suspect gave for the planned attack (or attack) in more detail: Select the type of bullying Were the weapons obtained? Phone Number Did the suspect tell anyone about his/her plans prior to the discovery of the attack or the attack itself(other than co-conspirators)? State in which the school is located: How many students are currently enrolled in the school? If the plot was discovered prior to the attack: Please describe: How many individuals were involved in the attack? Explain the psychological issue Describe the lessons learned from this attack or planned attack: Select all gun types that were going to be used in attack: How many fatalities were there from the attack? How was law enforcement notified of (or how did they discover) the plot? What was the information source? What changes to school procedure would you recommend to avoid attacks or planned attacks in the future? Describe Please describe Who is inputting this information? Check all that apply Explain the security measure Who notified law enforcement of the plot? Select all that apply from Law Enforcement Did the suspect experience a life changing family event? Information Source Describe the faculty: The suspect was: What best describes the area where the school is located? Select all that apply Please describe the school-administered consequences to this suspect for the plot? Please explain How many suspects were involved with the plot? Who was it? Describe the selected stage in as much detail as appropriate: Suspect's Sex What kind of bullying did he/she experience? If suspect was a current student, what grade was he/she in at the time of the plot discovery or attack? Describe Select all that apply Explain the other reason the suspect gave for the attack or planned attack What was the plan to gain access to the school? Date of Planned Attack (if known) Explain: What reasons did the the suspect give for the planned attack or attack? Outline the details of the attack: Describe Does the school have a counselor? Select the Stage you wish to discuss Race/Ethnicity How? Date of Attack: Please describe Weapons Was this event: Please tell us about any other formally documented warning signs you may have noticed Explain the bullying or teasing the suspect received Describe in as much detail as appropriate: Please explain Describe any other details on how the plot was discovered Date of Plot Discovery Please explain Select all gun types that were used in the attack: Describe the security system at the school Outline the history of the planned attack Was this weapon used during the attack? Check all other weapons that were going to be used in the attack: Type of school: Select all that apply Please describe Please describe Was the suspect a student or affiliated with the school in an other way? Please explain Please describe: Select the affiliation Please describe the legal consequences to this suspect for the plot Select all that apply from Mental Health Title this case Email Was the suspect involved in bullying to the point of formal school documentation? (Either as suspect or victim) Was the suspect a bully? At the time of incident or incident discovery, did the suspect show signs of depression or other psychological problems? Please explain In hindsight, were there any formally documented warning signs prior to the discovery of the plot or attack? How did the attacker(s) gain access to the school? Suspect Who did they tell? Check all other weapons that were used in the attack: * *
CaseSelectedOption	[Not Set] 7/3/13 Police pursuit ensues, Jasper later arrested Police arrive at scene Coon starts shooting Kenneth Bartley Hancock starts shooting students. James Hancock Hill exchanges fire with officers Carpenter becomes obsessed with Columbine shooting Police search LaDue's room Terry engages staff members in conversation Zawahri hospitalized for mental illness 3/2/14 Carpenter talks about guns and shootings January 2005 Suicide attempt Brazill does well in school Youshock detonates pipe bombs Castillo visits Columbine Nicco Tatum 10/ 27/2015 Steven creates insulting Instagram post Brendan Tarwater adsfasdf Castillo obsesses over Columbine. Suspect 2 Chen enters director’s office Castillo shoots and injures two people Suspect 4 Mental health deteriorating Police find Chen and Director dead Two days before shooting Grant Acord details plan for school bombing in a notebook 2010 911 call suspect 1 Butler commits suicide. xxx Chen is terminated Bishop fires shots Butler obtains gun and returns to school 2013 Alcohol Abuse Treatment 2012 incident yh Suspect 1 Police arrive on scene and arrest Terry 2/11/16. Dutiel asks friend for gun Bush continues to get bullied 9:51AM Rescue begins Williams learns to shoot Foo Castillo joins National Guard 111 Youshock tries to start chainsaw Hill threatens brother's life on FB 111 Hill asks bookkeeper to call police and local news station Elizabeth Bush Officers search Acord’s house Jacob Dwight Hill Coon charged with domestic violence Attack description April 2009 Youshock records disturbing video, writes diary entries Suspect’s behavior becomes threatening July/August 2007 Cossey attempts to recruit Bennett Jakob E. Wagner Bomb and shooting threat via social media chat room Juvenile 1 Apprehension Douglas Chanthabouly xxx Police search Acord's home Hill tells other students about his plot 2012-2014 Terry purchases shotgun and ammunition Youshock's mother buys bomb making materials The event lasts 13 minutes Brazill returns to school Brazill shoots teacher 2004 Chanthabouly has problems in school 12/1/14 Suspect is arrested 9AM-9.30AM. Cho mails package to NBC News 2005 Two females complain about Cho Police uncover students' plans to kill Allegedly, Campbell tells of plot months in advance 01/14/14 Campbell open fires in gymnasium Jakob purchases gun Zawahri randomly shoots from intersection 5/23/13 Police receive info that Acord made bomb threats Ybarra scouts out Seattle Pacific campus Peter Thulin Three male students talk about plans for mass shooting Zawahri carjacks driver John David LaDue Leader 10/8/15 17 year old suspect creates threatening tweets Subject 1 Averted Rampage Principal finds gun in backpack Police find Howard's car at Walmart, with gun in back seat, and arrest him. Officers search grounds and Hill's car for bombs 9.40AM. Cho begins shooting PT Bartley shoots school officials Robert Butler Jr. Dutiel brings gun to school Zhu and Yang meet at campus café Suspect 4 (Name not released) ff Howard buys a .22 rifle at other gun store in Athens. Ybarra purchases ammo Brazill obtains gun bbb 1993 Bomb threat 01/12/14 Campbell posts online 2006 Zawahri has contact with police Castillo buys a shotgun and attempts suicide Hill barricades himself in front office Day of attack 12/1/14 Student sees suspect with handgun Bartley goes to principal’s office Coon makes suicidal statements. Bush takes gun to school sdaf Suspect 3 (Name not released) Weapon 1 3/2/14 Carpenter tries to buy a gun at different store Suspect 111 Officers search school grounds and Hill’s car for bombs Flores shoots himself 7/3/13 Police search Jasper's car 8/20/13 Hill shows up armed to elementary school Storage of explosives and weapons Police arrest and question suspect Steven, Brewer, and Dukes threaten girl via cell phone 2000 Juvenile court neglect case 01/10/14 Campbell details plot in notebook 04/28/14 Parents wake up and find their son not home Abuse from Castillo’s father x Bishop denied tenure Jaylen Fryberg 2005-2007 Chanthabouly attends Foss High aaa aaa 2004 Chanthabouly hears voices 8/20/13 Hill shows up armed to elementary school 4/29/14 Woman calls police about suspicious activity aa 111 10:15 AM James Madison High put on lockdown Hill exchanges fire with officers IED Dutiel acts strangely Mason Campbell Ybarra packs shotgun, writes journal of his plans, and heads to Seattle Pacific University dafasdfsdf Student is put under psychiatric observation for 2 weeks Months before shooting 7:25 AM Police notified of shooting 2 Dutiel’s girlfriend tells her she no longer loves her 10/27/2015 Steven formulates shooting plot Kody Brewer Dutiel writes suicide notes Ybarra enters Otto Miller Hall Nathaniel Brazill Castillo’s two life changing events Zahrani stabs professor 4 times 7/2/13 Police find Jasper sleeping in stolen truck 2/27/14 Carpenter makes shooting comment Zhu purchases the knife Grant Acord Suspect found and apprehended testsetes Suspect 1 Suspect 1 (Name not released) Assistant principal learns that Bartley might have gun Castillo buys another shotgun Castillo enters school grounds Unnamed suspect James Howard Suspects create plan to shoot drt James Hancock enters cafeteria during school. Aaron Ybarra Ybarra shoots female student Cho is interested in writing Ryan Steven Dillon Cossey Zahrani exhibits erratic behavior Security officer and teacher apprehend subject 1 3/5/2001 Day of shooting Night before stabbing Suspect 2 (Name not released) School staff is concerned about Flores Brazill flees scene Attacker 1 4/27/15 Suspect brings .357 magnum to school Cho orders a gun 9/11/14 Terry posts rant on Facebook Castillo shows recognition of wrongdoing Security officer arrests Castillo Zahrani complains of financial troubles Flores failing course 1/4/2011 Butler makes contradictory statements Ybarra arrives at the campus and shoots first victim 111 10/24/2014 Fryberg meets with friends at school April 2006 Castillo attempts suicide. Bartley writes note Grant Acord Hill barricades himself in front office Youshock is arrested 2011 Zawahri fails to buy gun 4/29/14 Police interview LaDue Getting weapons Bush shoots a 13-year-old girl in the shoulder Chen shoots multiple times 9th Grade: LaDue has homicidal thoughts Police arrest Bishop Coon is frequently bullied in school Hill writes shooting plot in journal Juvenile 2 10/8/15 17 year old suspects displays dissatisfaction with school 6/7/13 Zawahri kills father and brother 2/12/10 Faculty meeting Fryberg shoots himself. Hancock runs out of school. Natalie Carpenter Shooting occurs on bus Suspect 1 1999 exhibits suicidal and homicidal ideas Chen speaks of buying gun Officers keep students inside building until 2:00 A.M. Sunday morning Howard tries to buy a rifle at Bait and Guns, owner refuses to sell him a gun. Day before attack Dorothy Dutiel Officer finds Brazill New Years Day 2011 10/10/2007 Coon brings gun to school ADSADadsA Butler's hidden troubles Administrators and teacher disarm Bartley Roommate tells school official of erratic behavior Deputies determine boys had access to firearms Chanthabouly is arrested 2013 Fryberg’s father illegally purchases pistol 2000 Juvenile court neglect case Coon charged with domestic violence 2006 Cho writes violent paper Classes start normally. Early May 2013 Acord talks about bombs at school Officer patrolling parking lot quickly shot Wagner July 2013 LaDue writes plan for shooting June 2013 Jasper leaves note and leaves with stolen weapons title Chanthabouly leaves school Unnamed suspect Student persuades Bush to drop gun Amy Bishop Bush takes antidepressants 1986 Bishop accidentally shoots brother Police arrive and kill Zawahri 2 students are shot 222 Brazill’s unstable upbringing Bartley tells friends of plan Bartley steals gun and pills 3/1/14 Carpenter tries to buy a shotgun dfdrf a Howard allegedly assaults assistant hockey coach at OU 5/23/13 Police receive tip of student bomb threat Robert Flores Teachers describe him as kind Williams’ history of misconduct June 2013 Jasper steals car and firearms Fryberg punches another student Howard returns to Bait and Guns; owner locks door and customer calls 911. 03/2015 Children named in online book report it to parents Teacher tackles suspect sd Student brings loaded gun to school 1/5/2011 Butler gets suspended Police find a note on Zawahri Zhu becomes obsessed with Yang Arrest warrant issued; Howard speaks with his mother again. 10/8/2007 Coon is suspended Michael Brandon Hill 9/12/14 Suspect points gun at mother 3/4/14 Carpenter is arrested Castillo’s parents find rifle Asa Coon Zhu and victim become acquainted Police apprehend Zahrani 2008 Alexander Youshock drops out of school 2002 Chathabouly suspended Shooting threat to school district in days prior 10/28/2015 Girl notifies law enforcement of threats Virginia Tech officer arrives 333 Williams is calm while killing Law enforcement searches Antigo High Hill's behavior becomes threatening Jian Chen Cossey describes attack Hancock arrested. 8/30/16 Castillo shoots his father Hill asks bookkeeper to call police and local news station Castillo writes about sacrifice 08/2014- 01/2015 Boy posts online novel titled “Killing Children” Officers arrive on scene Bishop’s gun jams Acord brings up bombs in conversation Cho exhibits signs of mental health problems during childhood Suspect 3 Carpenter is bullied Butler fires at staff member Zawahri shoots at students Hill takes steps to obtain a firearm 222 Continued violence at home 10 days before stabbing Abdulsalam al-Zahrani Howard withdraws from OU classes, speaks with mother, says some "crazy things". Youshock is tackled by teachers Suspects run Brazill tells friends of shooting idea Hill threatens brother’s life on Facebook 111 Officers arrest Tarwater Police find weapons and bombs in Cossey's house We found the plan Zawahri arrives at Santa Monica College 10/12/2015 Students inform school officials of social media threats Teacher talks Campbell into putting the gun down Fryberg sends out texts. TEST Haiyang Zhu 911 Call Shotgun Preparation Stage 2 Fryberg shoots friends. Getting more weapons Ybarra buys shotgun used in attack 7 years prior Charles Andrew Williams Flores starts shooting Youshock is tackled Peter Thulin a July 2013-March 2014 LaDue sets off "practice bombs" 10/29/2002 Flores enters nursing school building Meis tackles and stops Ybarra bbb Subject A purchased weapons in April 2015 8:07 am 8/24 Police called to school Two groups fight before shooting 2005 Cho writes disturbing paper Seung Hui Cho Justin Miles Jasper 111 Intended Weapons Jakob Wagner (shooter) open fires on two people leaving prom Chanthabouly shoots student in hallway John Zawahri f April 16th, 2007. Shooting starts Dr. M attempts to stop Bishop Item 1 Fantasy Stage Bishop calls husband Chanthabouly brings gun to school Bush moves schools Suspect becomes upset with ex girlfriend Zawahri fires at neighbors 10/30/15 Steven arrested Ryan A. Terry Alvaro Rafael Castillo Subject A and Subject B conceived of the attack in January 2015 Officers arrive to the hall Cossey meets Auvinen 10/10/2007 Bennett informs police of Cossey's plan Police called to school at 8:11 am 222 Police arrive at scene Butler’s seemingly positive history Bartley brings gun to school x ddd Bishop pulls out gun from purse Lamarr Dukes Carpenter writes notes about the Columbine shooters 1 Campbell is tried 2009 paranoia More officers arrive on scene Suspect steals gun Suspect #1 Alexander Youshock 5/26/00 Brazill sent home from school Student tries to flee principal's office Suspect brought to principal's office 3/3/14 Hope House staff calls police Acord composes list of items needed to perform school attack Suspect One * *
Update Cancel