Open vishnuvemuru opened 6 years ago
Hey, thank you for this PR! I'm sorry I haven't gotten to it for the past couple of days, been busy with other stuff. I have a favor I would like to ask of you:
Thank you in advance 😃
100117,10-01-2017,Nevada,Las Vegas,3950 Las Vegas Blvd S,59,441,http://www.gunviolencearchive.org/download/las-vegas-shooting.pdf,http://abcnews.go.com/US/guns-loaded-high-capacity-magazines-found-vegas-shooters/story?id=50228093,False,1.0,0::Unknown||1::Unknown||2::Unknown||3::Unknown||4::Unknown||5::Unknown||6::Unknown||7::Unknown||8::Unknown||9::Unknown||10::Unknown||11::Unknown||12::Unknown||13::Unknown||14::Unknown||15::Unknown||16::Unknown||17::Unknown||18::Unknown||19::Unknown||20::Unknown||21::Unknown||22::Unknown||23::Unknown||24::Unknown||25::Unknown||26::Unknown||27::Unknown||28::Unknown||29::Unknown||30::Unknown||31::Unknown||32::Unknown||33::Unknown||34::Unknown||35::Unknown||36::Unknown||37::Unknown||38::Unknown||39::Unknown||40::Unknown||41::Unknown||42::Unknown||43::Unknown||44::Unknown||45::Unknown||46::Unknown,0::Unknown||1::Unknown||2::Unknown||3::Unknown||4::Unknown||5::Unknown||6::Unknown||7::Unknown||8::Unknown||9::Unknown||10::Unknown||11::Unknown||12::Unknown||13::Unknown||14::Unknown||15::Unknown||16::Unknown||17::Unknown||18::Unknown||19::Unknown||20::Unknown||21::Unknown||22::Unknown||23::Unknown||24::Unknown||25::Unknown||26::Unknown||27::Unknown||28::Unknown||29::Unknown||30::Unknown||31::Unknown||32::Unknown||33::Unknown||34::Unknown||35::Unknown||36::Unknown||37::Unknown||38::Unknown||39::Unknown||40::Unknown||41::Unknown||42::Unknown||43::Unknown||44::Unknown||45::Unknown||46::Unknown,"Shot-injured||Shot-killed||Suicide||Institution/Business||Officer Involved Incident||Officer Involved Incident - Officer Shot||Officer Involved Incident - Officer Killed||Officer Involved Shooting - subject/suspect/perpetrator killed||Officer Involved Shooting - subject/suspect/perpetrator suicide at standoff||Mass Murder (4+ deceased victims excluding the subject/suspect/perpetrator, one location)||Mass Shooting (4+ victims injured or killed excluding the subject/suspect/perpetrator, one location)||LOCKDOWN/ALERT ONLY: No GV Incident Occured Onsite||ATF/LE Confiscation/Raid/Arrest||Assault weapon (AR-15, AK-47, and ALL variants defined by law enforcement)",36.095,,-115.1717,47.0,"Route 91 Harvest Festival concert, open fire from 32nd floor. 47 guns seized; TOTAL: 59 kills, 489 inj, number shot TBD, girlfriend Marilou Danley POI",0::34.0||1::35.0||2::49.0||3::34.0||4::54.0||5::44.0||6::40.0||7::50.0||8::34.0||9::28.0||10::58.0||11::29.0||12::55.0||13::22.0||14::50.0||15::39.0||16::31.0||17::52.0||18::20.0||19::40.0||20::34.0||21::44.0||22::42.0||23::38.0||24::34.0||25::33.0||26::42.0||27::55.0||28::23.0||29::28.0||30::28.0||31::29.0||32::67.0||33::24.0||34::35.0||35::33.0||36::36.0||37::31.0||38::46.0||39::56.0||40::26.0||41::21.0||42::20.0||43::28.0||44::34.0||45::48.0||46::28.0||47::61.0||48::20.0||49::50.0||50::21.0||51::53.0||52::30.0||53::56.0||54::46.0||55::32.0||56::55.0||57::42.0||58::nan||59::nan||60::21.0||61::nan||62::nan||63::36.0||64::nan||65::17.0||66::17.0||67::nan||68::nan||69::nan||70::nan||71::nan||72::nan||73::nan||74::nan||75::nan||76::50.0||77::nan||78::16.0||79::nan||80::nan||81::nan||82::20.0||83::25.0||84::nan||85::nan||86::22.0||87::nan||88::nan||89::nan||90::37.0||91::nan||92::nan||93::nan||94::nan||95::nan||96::nan||97::27.0||98::nan||99::21.0||100::nan||101::23.0||102::18.0||103::24.0||104::nan||105::nan||106::nan||107::28.0||108::nan||109::nan||110::nan||111::18.0||112::nan||113::29.0||114::nan||115::nan||116::nan||117::30.0||118::25.0||119::nan||120::nan||121::nan||122::50.0||123::52.0||124::nan||125::nan||126::nan||127::nan||128::nan||129::nan||130::52.0||131::nan||132::nan||133::nan||134::nan||135::22.0||136::nan||137::nan||138::29.0||139::nan||140::39.0||141::22.0||142::33.0||143::nan||144::19.0||145::nan||146::nan||147::nan||148::30.0||149::nan||150::nan||151::23.0||152::28.0||153::45.0||154::22.0||155::nan||156::nan||157::nan||158::nan||159::nan||160::18.0||161::47.0||162::30.0||163::nan||164::34.0||165::31.0||166::nan||167::nan||168::nan||169::43.0||170::nan||171::nan||172::53.0||173::33.0||174::nan||175::nan||176::nan||177::nan||178::nan||179::nan||180::nan||181::nan||182::nan||183::nan||184::nan||185::nan||186::nan||187::nan||188::nan||189::nan||190::nan||191::nan||192::nan||193::28.0||194::nan||195::64.0,0::Adult 18+||1::Adult 18+||2::Adult 18+||3::Adult 18+||4::Adult 18+||5::Adult 18+||6::Adult 18+||7::Adult 18+||8::Adult 18+||9::Adult 18+||10::Adult 18+||11::Adult 18+||12::Adult 18+||13::Adult 18+||14::Adult 18+||15::Adult 18+||16::Adult 18+||17::Adult 18+||18::Adult 18+||19::Adult 18+||20::Adult 18+||21::Adult 18+||22::Adult 18+||23::Adult 18+||24::Adult 18+||25::Adult 18+||26::Adult 18+||27::Adult 18+||28::Adult 18+||29::Adult 18+||30::Adult 18+||31::Adult 18+||32::Adult 18+||33::Adult 18+||34::Adult 18+||35::Adult 18+||36::Adult 18+||37::Adult 18+||38::Adult 18+||39::Adult 18+||40::Adult 18+||41::Adult 18+||42::Adult 18+||43::Adult 18+||44::Adult 18+||45::Adult 18+||46::Adult 18+||47::Adult 18+||48::Adult 18+||49::Adult 18+||50::Adult 18+||51::Adult 18+||52::Adult 18+||53::Adult 18+||54::Adult 18+||55::Adult 18+||56::Adult 18+||57::Adult 18+||58::Adult 18+||59::Adult 18+||60::Adult 18+||61::Adult 18+||62::Adult 18+||63::Adult 18+||64::Adult 18+||65::Teen (12-17)||66::Teen (12-17)||67::Adult 18+||68::Adult 18+||69::Adult 18+||70::Adult 18+||71::Adult 18+||72::Adult 18+||73::Adult 18+||74::Adult 18+||75::Adult 18+||76::Adult 18+||77::Adult 18+||78::Teen (12-17)||79::Adult 18+||80::Adult 18+||81::Adult 18+||82::Adult 18+||83::Adult 18+||84::Adult 18+||85::Adult 18+||86::Adult 18+||87::Adult 18+||88::Adult 18+||89::Adult 18+||90::Adult 18+||91::Adult 18+||92::Adult 18+||93::Adult 18+||94::Adult 18+||95::Adult 18+||96::Adult 18+||97::Adult 18+||98::Adult 18+||99::Adult 18+||100::Adult 18+||101::Adult 18+||102::Adult 18+||103::Adult 18+||104::Adult 18+||105::Adult 18+||106::Adult 18+||107::Adult 18+||108::Adult 18+||109::Adult 18+||110::Adult 18+||111::Adult 18+||112::Adult 18+||113::Adult 18+||114::Adult 18+||115::Adult 18+||116::Adult 18+||117::Adult 18+||118::Adult 18+||119::Adult 18+||120::Adult 18+||121::Adult 18+||122::Adult 18+||123::Adult 18+||124::Adult 18+||125::Adult 18+||126::Adult 18+||127::Adult 18+||128::Adult 18+||129::Adult 18+||130::Adult 18+||131::Adult 18+||132::Adult 18+||133::Adult 18+||134::Adult 18+||135::Adult 18+||136::Adult 18+||137::Adult 18+||138::Adult 18+||139::Adult 18+||140::Adult 18+||141::Adult 18+||142::Adult 18+||143::Adult 18+||144::Adult 18+||145::Adult 18+||146::Adult 18+||147::Adult 18+||148::Adult 18+||149::Adult 18+||150::Adult 18+||151::Adult 18+||152::Adult 18+||153::Adult 18+||154::Adult 18+||155::Adult 18+||156::Adult 18+||157::Adult 18+||158::Adult 18+||159::Adult 18+||160::Adult 18+||161::Adult 18+||162::Adult 18+||163::Adult 18+||164::Adult 18+||165::Adult 18+||166::Adult 18+||167::Adult 18+||168::Adult 18+||169::Adult 18+||170::Adult 18+||171::Adult 18+||172::Adult 18+||173::Adult 18+||174::Adult 18+||175::Adult 18+||176::Adult 18+||177::Adult 18+||178::Adult 18+||179::Adult 18+||180::Adult 18+||181::Adult 18+||182::Adult 18+||183::Adult 18+||184::Adult 18+||185::Adult 18+||186::Adult 18+||187::Adult 18+||188::Adult 18+||189::Adult 18+||190::Adult 18+||191::Adult 18+||192::Adult 18+||193::Adult 18+||194::Teen (12-17)||195::Adult 18+,0::Female||1::Female||2::Female||3::Female||4::Male||5::Male||6::Female||7::Female||8::Female||9::Female||10::Female||11::Male||12::Male||13::Female||14::Female||15::Male||16::Female||17::Female||18::Female||19::Female||20::Male||21::Male||22::Female||23::Female||24::Female||25::Female||26::Female||27::Male||28::Male||29::Female||30::Female||31::Male||32::Female||33::Male||34::Male||35::Female||36::Female||37::Female||38::Female||39::Male||40::Female||41::Female||42::Male||43::Male||44::Female||45::Female||46::Male||47::Male||48::Female||49::Female||50::Male||51::Female||52::Male||53::Male||54::Female||55::Female||56::Male||57::Male||58::Female||59::Male||60::Male||61::Female||62::Female||63::Male||64::Female||65::Female||66::Female||67::Female||68::Female||69::Male||70::Female||71::Female||72::Male||73::Male||74::Male||75::Female||76::Male||77::Male||78::Male||79::Male||80::Female||81::Male||82::Female||83::Male||84::Female||85::Male||86::Female||87::Female||88::Male||89::Female||90::Male||91::Male||92::Male||93::Male||94::Female||95::Male||96::Female||97::Female||98::Female||99::Female||100::Female||101::Female||102::Female||103::Male||104::Male||105::Female||106::Male||107::Male||108::Male||109::Male||110::Male||111::Female||112::Male||113::Female||114::Male||115::Male||116::Male||117::Female||118::Male||119::Male||120::Female||121::Female||122::Male||123::Male||124::Female||125::Male||126::Male||127::Female||128::Male||129::Male||130::Male||131::Male||132::Male||133::Female||134::Female||135::Male||136::Female||137::Male||138::Male||139::Male||140::Male||141::Female||142::Female||143::Male||144::Female||145::Male||146::Female||147::Female||148::Female||149::Male||150::Male||151::Female||152::Female||153::Male||154::Female||155::Female||156::Male||157::Female||158::Male||159::Female||160::Female||161::Female||162::Male||163::Female||164::Female||165::Male||166::Male||167::Male||168::Male||169::Female||170::Female||171::Male||172::Female||173::Female||174::nan||175::nan||176::Female||177::nan||178::nan||179::nan||180::nan||181::nan||182::nan||183::nan||184::nan||185::nan||186::nan||187::nan||188::Male||189::Female||190::Female||191::Female||192::Female||193::Female||194::Male||195::Male,"0::Hannah Ahlers||1::Heather Warino Alvarado||2::Dorene Anderson||3::Carrie Barnette||4::Jack Beaton||5::Stephen Berger||6::Candice Bowers||7::Denise Salmon Burditus||8::Sandy Casey||9::Andrea Castilla||10::Denise Cohen||11::Austin Davis||12::Thomas Day Jr||13::Christiana Duarte||14::Stacee Etcheber||15::Brian Fraser||16::Keri Galvan||17::Dana Gardner||18::Angela ""Angie"" Gomez||19::Rocio Guillen Rocha||20::Officer Charleston Hartfield||21::Christopher Hazencomb||22::Jennifer Topaz Irvine||23::Teresa Nicol Kimura||24::Jessica Klymchuk||25::Carly Kriebaum||26::Rhonda LeRocque||27::Victor Link||28::Jordan McIldoon||29::Kelsey Brianne Meadows||30::Calla Marie Medig||31::James Sonny Melton||32::Patricia Mestas||33::Austin Meyer||34::Adrian Murfitt||35::Rachael Parker||36::Jennifer Parks||37::Carolyn Lee ""Carrie"" Parsons||38::Lisa Patterson||39::John Phippen||40::Melissa Ramirez||41::Jordyn Rivera||42::Quinton Robbins||43::Cameron Robinson||44::Tara Ann Roe||45::Lisa Romero Muniz||46::Christopher Roybal||47::Brett Schwanbeck||48::Bailey Schweitzer||49::Laura Shipp||50::Erick Silva||51::Susan Smith||52::Brennan Stewart||53::Derrick ""Bo"" Taylor||54::Neysa Tonks||55::Michelle Vo||56::Kurt Von Tillow||57::William ""Bill"" Wolfe Jr||58::Carmen Alegria||59::Jake Andersen||60::Arthur ""Arty"" Andrade Jr||61::Jody Ansell||62::Alexis Arias||63::Philip Aurich||64::Kristin Babik||65::Gianna Baca||66::Natalia Baca||67::Malinda Bainbridge||68::Jordanne Barr||69::Donny Barthal||70::Nikki Barthal||71::Autumn Bignami||72::Frank Bignami||73::Mike Blair||74::John Blumeyer||75::Melinda ""Mia"" Brockie||76::Clint Burton||77::Dustin Burkhardt||78::Nick Campbell||79::Jesus Campos||80::Angel Carmona||81::Mike Caster||82::Savanna Chasco||83::Jeff Christerson||84::Michaela Clark||85::Officer Casey Clarkson||86::Summer Clyburn||87::Allison Crute||88::Craig Cunneen||89::Debbie Cunneen||90::Lee Dorchak||91::Bobby Eardley||92::Al Etcheber||93::Chris Eyer||94::Samantha Faranda||95::Kurt Fowler||96::Melissa Fiero||97::Tina Frost||98::Elle Gargano||99::Paige Gasper||100::Kim Gervais||101::Danae Dawn Gibbs||102::Rylie Golgart||103::Officer Michael Gracia||104::Jimmy Grovom||105::Natalie Grumet||106::Andrew Gudmonson||107::Thomas Gunderson||108::Jason Hammond||109::Lt Derek Harp||110::Michael Hesselton||111::Tiffaini Huizar||112::Luca Iclodean||113::Alicia Johnston||114::Andrew Kampe||115::Steve Keys||116::Billy King||117::Christina Kitcat||118::Jeffrey Koishor||119::Mike Kordich||120::Jan Lambourne||121::Mykenzie Lane||122::Scott Lee||123::Det Curtis Leoni||124::Lisa Lewan||125::Matt Lewan||126::Sheldon Mack||127::Jovanna Martinez Calzadillas||128::Billy Bob Mason||129::Braden Matejka||130::Rob McIntosh||131::Tom McIntosh||132::Jason McMillan||133::Paige Melanson||134::Rosemarie Trautman Melanson||135::Zack Mesker||136::Jessica Milam||137::Officer Aaron Mundhenke||138::Officer Joseph Owen||139::Rocky Palermo||140::Bobby Parks||141::Shelby Perry||142::Amanda Peterson||143::Officer Tyler Peterson||144::Alexandra Pettis||145::Sgt Brad Powers||146::Jessi Preston||147::Ashley Quidocho||148::Olga Ramirez||149::Bill Robinson Jr||150::Nick Robone||151::Ariel Romero||152::Chelsea Romo||153::Agent Fred Rowbotham||154::Karessa Royce||155::Jeanine Ruggiero||156::George Sanchez||157::Savannah Nicole Sanchez||158::Ryan Sarrazin||159::Rachel Sheppard||160::Addison Short||161::Karen Smerber||162::Jonathan Smith||163::Angelica Soto||164::Kristina Staples||165::Jeff Steffens||166::Officer Chad Swanson||167::Steve Treskes||168::Dep Chief Bruce Ure||169::Natalie Vanderstay||170::April Vasquez||171::Stephen Vicelja||172::Wanda Weinreich||173::Officer1||174::Officer2||175::Officer3||176::OC Officer wife||177::Firefighter1||178::Firefighter2||179::Firefighter3||180::Firefighter4||181::Firefighter5||182::Firefighter6||183::Firefighter7||184::Civ1||185::Civ2||186::Civ3||187::Civ4||188::Civ5||189::Civ6||190::Civ7||191::Civ8||192::Civ9||193::Civ10||194::Civ11||195::Stephen Paddock",,0::Killed||1::Killed||2::Killed||3::Killed||4::Killed||5::Killed||6::Killed||7::Killed||8::Killed||9::Killed||10::Killed||11::Killed||12::Killed||13::Killed||14::Killed||15::Killed||16::Killed||17::Killed||18::Killed||19::Killed||20::Killed||21::Killed||22::Killed||23::Killed||24::Killed||25::Killed||26::Killed||27::Killed||28::Killed||29::Killed||30::Killed||31::Killed||32::Killed||33::Killed||34::Killed||35::Killed||36::Killed||37::Killed||38::Killed||39::Killed||40::Killed||41::Killed||42::Killed||43::Killed||44::Killed||45::Killed||46::Killed||47::Killed||48::Killed||49::Killed||50::Killed||51::Killed||52::Killed||53::Killed||54::Killed||55::Killed||56::Killed||57::Killed||58::Injured||59::Injured||60::Injured||61::Injured||62::Injured||63::Injured||64::Injured||65::Injured||66::Injured||67::Injured||68::Injured||69::Injured||70::Injured||71::Injured||72::Injured||73::Injured||74::Injured||75::Injured||76::Injured||77::Injured||78::Injured||79::Injured||80::Injured||81::Injured||82::Injured||83::Injured||84::Injured||85::Injured||86::Injured||87::Injured||88::Injured||89::Injured||90::Injured||91::Injured||92::Injured||93::Injured||94::Injured||95::Injured||96::Injured||97::Injured||98::Injured||99::Injured||100::Injured||101::Injured||102::Injured||103::Injured||104::Injured||105::Injured||106::Injured||107::Injured||108::Injured||109::Injured||110::Injured||111::Injured||112::Injured||113::Injured||114::Injured||115::Injured||116::Injured||117::Injured||118::Injured||119::Injured||120::Injured||121::Injured||122::Injured||123::Injured||124::Injured||125::Injured||126::Injured||127::Injured||128::Injured||129::Injured||130::Injured||131::Injured||132::Injured||133::Injured||134::Injured||135::Injured||136::Injured||137::Injured||138::Injured||139::Injured||140::Injured||141::Injured||142::Injured||143::Injured||144::Injured||145::Injured||146::Injured||147::Injured||148::Injured||149::Injured||150::Injured||151::Injured||152::Injured||153::Injured||154::Injured||155::Injured||156::Injured||157::Injured||158::Injured||159::Injured||160::Injured||161::Injured||162::Injured||163::Injured||164::Injured||165::Injured||166::Injured||167::Injured||168::Injured||169::Injured||170::Injured||171::Injured||172::Injured||173::Injured||174::Injured||175::Injured||176::Injured||177::Injured||178::Injured||179::Injured||180::Injured||181::Injured||182::Injured||183::Injured||184::Injured||185::Injured||186::Injured||187::Injured||188::Injured||189::Injured||190::Injured||191::Injured||192::Injured||193::Injured||194::Injured||195::Killed,0::VICTIM||1::VICTIM||2::VICTIM||3::VICTIM||4::VICTIM||5::VICTIM||6::VICTIM||7::VICTIM||8::VICTIM||9::VICTIM||10::VICTIM||11::VICTIM||12::VICTIM||13::VICTIM||14::VICTIM||15::VICTIM||16::VICTIM||17::VICTIM||18::VICTIM||19::VICTIM||20::VICTIM||21::VICTIM||22::VICTIM||23::VICTIM||24::VICTIM||25::VICTIM||26::VICTIM||27::VICTIM||28::VICTIM||29::VICTIM||30::VICTIM||31::VICTIM||32::VICTIM||33::VICTIM||34::VICTIM||35::VICTIM||36::VICTIM||37::VICTIM||38::VICTIM||39::VICTIM||40::VICTIM||41::VICTIM||42::VICTIM||43::VICTIM||44::VICTIM||45::VICTIM||46::VICTIM||47::VICTIM||48::VICTIM||49::VICTIM||50::VICTIM||51::VICTIM||52::VICTIM||53::VICTIM||54::VICTIM||55::VICTIM||56::VICTIM||57::VICTIM||58::VICTIM||59::VICTIM||60::VICTIM||61::VICTIM||62::VICTIM||63::VICTIM||64::VICTIM||65::VICTIM||66::VICTIM||67::VICTIM||68::VICTIM||69::VICTIM||70::VICTIM||71::VICTIM||72::VICTIM||73::VICTIM||74::VICTIM||75::VICTIM||76::VICTIM||77::VICTIM||78::VICTIM||79::VICTIM||80::VICTIM||81::VICTIM||82::VICTIM||83::VICTIM||84::VICTIM||85::VICTIM||86::VICTIM||87::VICTIM||88::VICTIM||89::VICTIM||90::VICTIM||91::VICTIM||92::VICTIM||93::VICTIM||94::VICTIM||95::VICTIM||96::VICTIM||97::VICTIM||98::VICTIM||99::VICTIM||100::VICTIM||101::VICTIM||102::VICTIM||103::VICTIM||104::VICTIM||105::VICTIM||106::VICTIM||107::VICTIM||108::VICTIM||109::VICTIM||110::VICTIM||111::VICTIM||112::VICTIM||113::VICTIM||114::VICTIM||115::VICTIM||116::VICTIM||117::VICTIM||118::VICTIM||119::VICTIM||120::VICTIM||121::VICTIM||122::VICTIM||123::VICTIM||124::VICTIM||125::VICTIM||126::VICTIM||127::VICTIM||128::VICTIM||129::VICTIM||130::VICTIM||131::VICTIM||132::VICTIM||133::VICTIM||134::VICTIM||135::VICTIM||136::VICTIM||137::VICTIM||138::VICTIM||139::VICTIM||140::VICTIM||141::VICTIM||142::VICTIM||143::VICTIM||144::VICTIM||145::VICTIM||146::VICTIM||147::VICTIM||148::VICTIM||149::VICTIM||150::VICTIM||151::VICTIM||152::VICTIM||153::VICTIM||154::VICTIM||155::VICTIM||156::VICTIM||157::VICTIM||158::VICTIM||159::VICTIM||160::VICTIM||161::VICTIM||162::VICTIM||163::VICTIM||164::VICTIM||165::VICTIM||166::VICTIM||167::VICTIM||168::VICTIM||169::VICTIM||170::VICTIM||171::VICTIM||172::VICTIM||173::VICTIM||174::VICTIM||175::VICTIM||176::VICTIM||177::VICTIM||178::VICTIM||179::VICTIM||180::VICTIM||181::VICTIM||182::VICTIM||183::VICTIM||184::VICTIM||185::VICTIM||186::VICTIM||187::VICTIM||188::VICTIM||189::VICTIM||190::VICTIM||191::VICTIM||192::VICTIM||193::VICTIM||194::VICTIM||195::SUSPECT,https://www.usatoday.com/story/news/2017/10/03/heres-timeline-how-las-vegas-shooting-unfolded/729034001/||https://www.nbcnews.com/storyline/las-vegas-shooting/las-vegas-shooting-59-killed-more-500-hurt-near-mandalay-n806461||http://www.clarkcountynv.gov/public-communications/Pages/Clark-County-Coroner-Releases-Names-of-Deceased-from-Oct--1-Mass-Shooting.aspx,16.0,10.0
There you go James.
@vishnuvemuru Question, did you type it by hand or did you manage to somehow automatically extract it from the PDF? If you wrote it by hand I'll have to do some manual review to ensure it's correct.
Hi James,
Here goes answers to your questions. I extracted the data from PDF using free tool Tabula (http://tabula.technology/).
Yes there was available data for only 195 people in the PDF. The PDF has a note, "only victims who have been confirmed to be shot, and not injured in other ways are included on the gun violence archive record."
"VICTIM" word is how it was in the PDF, I now realize it. I have changed it now. I am posting the data again below.
I have used the same incident ID as the one you used in your stage1 file, thanks for bringing it to my notice. I am going to paste the new data in another comment.
946496,10-01-2017,Nevada,Las Vegas,3950 Las Vegas Blvd S,59,441,http://www.gunviolencearchive.org/download/las-vegas-shooting.pdf,http://abcnews.go.com/US/guns-loaded-high-capacity-magazines-found-vegas-shooters/story?id=50228093,False,1.0,0::Unknown||1::Unknown||2::Unknown||3::Unknown||4::Unknown||5::Unknown||6::Unknown||7::Unknown||8::Unknown||9::Unknown||10::Unknown||11::Unknown||12::Unknown||13::Unknown||14::Unknown||15::Unknown||16::Unknown||17::Unknown||18::Unknown||19::Unknown||20::Unknown||21::Unknown||22::Unknown||23::Unknown||24::Unknown||25::Unknown||26::Unknown||27::Unknown||28::Unknown||29::Unknown||30::Unknown||31::Unknown||32::Unknown||33::Unknown||34::Unknown||35::Unknown||36::Unknown||37::Unknown||38::Unknown||39::Unknown||40::Unknown||41::Unknown||42::Unknown||43::Unknown||44::Unknown||45::Unknown||46::Unknown,0::Unknown||1::Unknown||2::Unknown||3::Unknown||4::Unknown||5::Unknown||6::Unknown||7::Unknown||8::Unknown||9::Unknown||10::Unknown||11::Unknown||12::Unknown||13::Unknown||14::Unknown||15::Unknown||16::Unknown||17::Unknown||18::Unknown||19::Unknown||20::Unknown||21::Unknown||22::Unknown||23::Unknown||24::Unknown||25::Unknown||26::Unknown||27::Unknown||28::Unknown||29::Unknown||30::Unknown||31::Unknown||32::Unknown||33::Unknown||34::Unknown||35::Unknown||36::Unknown||37::Unknown||38::Unknown||39::Unknown||40::Unknown||41::Unknown||42::Unknown||43::Unknown||44::Unknown||45::Unknown||46::Unknown,"Shot-injured||Shot-killed||Suicide||Institution/Business||Officer Involved Incident||Officer Involved Incident - Officer Shot||Officer Involved Incident - Officer Killed||Officer Involved Shooting - subject/suspect/perpetrator killed||Officer Involved Shooting - subject/suspect/perpetrator suicide at standoff||Mass Murder (4+ deceased victims excluding the subject/suspect/perpetrator, one location)||Mass Shooting (4+ victims injured or killed excluding the subject/suspect/perpetrator, one location)||LOCKDOWN/ALERT ONLY: No GV Incident Occured Onsite||ATF/LE Confiscation/Raid/Arrest||Assault weapon (AR-15, AK-47, and ALL variants defined by law enforcement)",36.095,,-115.1717,47.0,"Route 91 Harvest Festival concert, open fire from 32nd floor. 47 guns seized; TOTAL: 59 kills, 489 inj, number shot TBD, girlfriend Marilou Danley POI",0::34.0||1::35.0||2::49.0||3::34.0||4::54.0||5::44.0||6::40.0||7::50.0||8::34.0||9::28.0||10::58.0||11::29.0||12::55.0||13::22.0||14::50.0||15::39.0||16::31.0||17::52.0||18::20.0||19::40.0||20::34.0||21::44.0||22::42.0||23::38.0||24::34.0||25::33.0||26::42.0||27::55.0||28::23.0||29::28.0||30::28.0||31::29.0||32::67.0||33::24.0||34::35.0||35::33.0||36::36.0||37::31.0||38::46.0||39::56.0||40::26.0||41::21.0||42::20.0||43::28.0||44::34.0||45::48.0||46::28.0||47::61.0||48::20.0||49::50.0||50::21.0||51::53.0||52::30.0||53::56.0||54::46.0||55::32.0||56::55.0||57::42.0||58::nan||59::nan||60::21.0||61::nan||62::nan||63::36.0||64::nan||65::17.0||66::17.0||67::nan||68::nan||69::nan||70::nan||71::nan||72::nan||73::nan||74::nan||75::nan||76::50.0||77::nan||78::16.0||79::nan||80::nan||81::nan||82::20.0||83::25.0||84::nan||85::nan||86::22.0||87::nan||88::nan||89::nan||90::37.0||91::nan||92::nan||93::nan||94::nan||95::nan||96::nan||97::27.0||98::nan||99::21.0||100::nan||101::23.0||102::18.0||103::24.0||104::nan||105::nan||106::nan||107::28.0||108::nan||109::nan||110::nan||111::18.0||112::nan||113::29.0||114::nan||115::nan||116::nan||117::30.0||118::25.0||119::nan||120::nan||121::nan||122::50.0||123::52.0||124::nan||125::nan||126::nan||127::nan||128::nan||129::nan||130::52.0||131::nan||132::nan||133::nan||134::nan||135::22.0||136::nan||137::nan||138::29.0||139::nan||140::39.0||141::22.0||142::33.0||143::nan||144::19.0||145::nan||146::nan||147::nan||148::30.0||149::nan||150::nan||151::23.0||152::28.0||153::45.0||154::22.0||155::nan||156::nan||157::nan||158::nan||159::nan||160::18.0||161::47.0||162::30.0||163::nan||164::34.0||165::31.0||166::nan||167::nan||168::nan||169::43.0||170::nan||171::nan||172::53.0||173::33.0||174::nan||175::nan||176::nan||177::nan||178::nan||179::nan||180::nan||181::nan||182::nan||183::nan||184::nan||185::nan||186::nan||187::nan||188::nan||189::nan||190::nan||191::nan||192::nan||193::28.0||194::nan||195::64.0,0::Adult 18+||1::Adult 18+||2::Adult 18+||3::Adult 18+||4::Adult 18+||5::Adult 18+||6::Adult 18+||7::Adult 18+||8::Adult 18+||9::Adult 18+||10::Adult 18+||11::Adult 18+||12::Adult 18+||13::Adult 18+||14::Adult 18+||15::Adult 18+||16::Adult 18+||17::Adult 18+||18::Adult 18+||19::Adult 18+||20::Adult 18+||21::Adult 18+||22::Adult 18+||23::Adult 18+||24::Adult 18+||25::Adult 18+||26::Adult 18+||27::Adult 18+||28::Adult 18+||29::Adult 18+||30::Adult 18+||31::Adult 18+||32::Adult 18+||33::Adult 18+||34::Adult 18+||35::Adult 18+||36::Adult 18+||37::Adult 18+||38::Adult 18+||39::Adult 18+||40::Adult 18+||41::Adult 18+||42::Adult 18+||43::Adult 18+||44::Adult 18+||45::Adult 18+||46::Adult 18+||47::Adult 18+||48::Adult 18+||49::Adult 18+||50::Adult 18+||51::Adult 18+||52::Adult 18+||53::Adult 18+||54::Adult 18+||55::Adult 18+||56::Adult 18+||57::Adult 18+||58::Adult 18+||59::Adult 18+||60::Adult 18+||61::Adult 18+||62::Adult 18+||63::Adult 18+||64::Adult 18+||65::Teen (12-17)||66::Teen (12-17)||67::Adult 18+||68::Adult 18+||69::Adult 18+||70::Adult 18+||71::Adult 18+||72::Adult 18+||73::Adult 18+||74::Adult 18+||75::Adult 18+||76::Adult 18+||77::Adult 18+||78::Teen (12-17)||79::Adult 18+||80::Adult 18+||81::Adult 18+||82::Adult 18+||83::Adult 18+||84::Adult 18+||85::Adult 18+||86::Adult 18+||87::Adult 18+||88::Adult 18+||89::Adult 18+||90::Adult 18+||91::Adult 18+||92::Adult 18+||93::Adult 18+||94::Adult 18+||95::Adult 18+||96::Adult 18+||97::Adult 18+||98::Adult 18+||99::Adult 18+||100::Adult 18+||101::Adult 18+||102::Adult 18+||103::Adult 18+||104::Adult 18+||105::Adult 18+||106::Adult 18+||107::Adult 18+||108::Adult 18+||109::Adult 18+||110::Adult 18+||111::Adult 18+||112::Adult 18+||113::Adult 18+||114::Adult 18+||115::Adult 18+||116::Adult 18+||117::Adult 18+||118::Adult 18+||119::Adult 18+||120::Adult 18+||121::Adult 18+||122::Adult 18+||123::Adult 18+||124::Adult 18+||125::Adult 18+||126::Adult 18+||127::Adult 18+||128::Adult 18+||129::Adult 18+||130::Adult 18+||131::Adult 18+||132::Adult 18+||133::Adult 18+||134::Adult 18+||135::Adult 18+||136::Adult 18+||137::Adult 18+||138::Adult 18+||139::Adult 18+||140::Adult 18+||141::Adult 18+||142::Adult 18+||143::Adult 18+||144::Adult 18+||145::Adult 18+||146::Adult 18+||147::Adult 18+||148::Adult 18+||149::Adult 18+||150::Adult 18+||151::Adult 18+||152::Adult 18+||153::Adult 18+||154::Adult 18+||155::Adult 18+||156::Adult 18+||157::Adult 18+||158::Adult 18+||159::Adult 18+||160::Adult 18+||161::Adult 18+||162::Adult 18+||163::Adult 18+||164::Adult 18+||165::Adult 18+||166::Adult 18+||167::Adult 18+||168::Adult 18+||169::Adult 18+||170::Adult 18+||171::Adult 18+||172::Adult 18+||173::Adult 18+||174::Adult 18+||175::Adult 18+||176::Adult 18+||177::Adult 18+||178::Adult 18+||179::Adult 18+||180::Adult 18+||181::Adult 18+||182::Adult 18+||183::Adult 18+||184::Adult 18+||185::Adult 18+||186::Adult 18+||187::Adult 18+||188::Adult 18+||189::Adult 18+||190::Adult 18+||191::Adult 18+||192::Adult 18+||193::Adult 18+||194::Teen (12-17)||195::Adult 18+,0::Female||1::Female||2::Female||3::Female||4::Male||5::Male||6::Female||7::Female||8::Female||9::Female||10::Female||11::Male||12::Male||13::Female||14::Female||15::Male||16::Female||17::Female||18::Female||19::Female||20::Male||21::Male||22::Female||23::Female||24::Female||25::Female||26::Female||27::Male||28::Male||29::Female||30::Female||31::Male||32::Female||33::Male||34::Male||35::Female||36::Female||37::Female||38::Female||39::Male||40::Female||41::Female||42::Male||43::Male||44::Female||45::Female||46::Male||47::Male||48::Female||49::Female||50::Male||51::Female||52::Male||53::Male||54::Female||55::Female||56::Male||57::Male||58::Female||59::Male||60::Male||61::Female||62::Female||63::Male||64::Female||65::Female||66::Female||67::Female||68::Female||69::Male||70::Female||71::Female||72::Male||73::Male||74::Male||75::Female||76::Male||77::Male||78::Male||79::Male||80::Female||81::Male||82::Female||83::Male||84::Female||85::Male||86::Female||87::Female||88::Male||89::Female||90::Male||91::Male||92::Male||93::Male||94::Female||95::Male||96::Female||97::Female||98::Female||99::Female||100::Female||101::Female||102::Female||103::Male||104::Male||105::Female||106::Male||107::Male||108::Male||109::Male||110::Male||111::Female||112::Male||113::Female||114::Male||115::Male||116::Male||117::Female||118::Male||119::Male||120::Female||121::Female||122::Male||123::Male||124::Female||125::Male||126::Male||127::Female||128::Male||129::Male||130::Male||131::Male||132::Male||133::Female||134::Female||135::Male||136::Female||137::Male||138::Male||139::Male||140::Male||141::Female||142::Female||143::Male||144::Female||145::Male||146::Female||147::Female||148::Female||149::Male||150::Male||151::Female||152::Female||153::Male||154::Female||155::Female||156::Male||157::Female||158::Male||159::Female||160::Female||161::Female||162::Male||163::Female||164::Female||165::Male||166::Male||167::Male||168::Male||169::Female||170::Female||171::Male||172::Female||173::Female||174::nan||175::nan||176::Female||177::nan||178::nan||179::nan||180::nan||181::nan||182::nan||183::nan||184::nan||185::nan||186::nan||187::nan||188::Male||189::Female||190::Female||191::Female||192::Female||193::Female||194::Male||195::Male,"0::Hannah Ahlers||1::Heather Warino Alvarado||2::Dorene Anderson||3::Carrie Barnette||4::Jack Beaton||5::Stephen Berger||6::Candice Bowers||7::Denise Salmon Burditus||8::Sandy Casey||9::Andrea Castilla||10::Denise Cohen||11::Austin Davis||12::Thomas Day Jr||13::Christiana Duarte||14::Stacee Etcheber||15::Brian Fraser||16::Keri Galvan||17::Dana Gardner||18::Angela ""Angie"" Gomez||19::Rocio Guillen Rocha||20::Officer Charleston Hartfield||21::Christopher Hazencomb||22::Jennifer Topaz Irvine||23::Teresa Nicol Kimura||24::Jessica Klymchuk||25::Carly Kriebaum||26::Rhonda LeRocque||27::Victor Link||28::Jordan McIldoon||29::Kelsey Brianne Meadows||30::Calla Marie Medig||31::James Sonny Melton||32::Patricia Mestas||33::Austin Meyer||34::Adrian Murfitt||35::Rachael Parker||36::Jennifer Parks||37::Carolyn Lee ""Carrie"" Parsons||38::Lisa Patterson||39::John Phippen||40::Melissa Ramirez||41::Jordyn Rivera||42::Quinton Robbins||43::Cameron Robinson||44::Tara Ann Roe||45::Lisa Romero Muniz||46::Christopher Roybal||47::Brett Schwanbeck||48::Bailey Schweitzer||49::Laura Shipp||50::Erick Silva||51::Susan Smith||52::Brennan Stewart||53::Derrick ""Bo"" Taylor||54::Neysa Tonks||55::Michelle Vo||56::Kurt Von Tillow||57::William ""Bill"" Wolfe Jr||58::Carmen Alegria||59::Jake Andersen||60::Arthur ""Arty"" Andrade Jr||61::Jody Ansell||62::Alexis Arias||63::Philip Aurich||64::Kristin Babik||65::Gianna Baca||66::Natalia Baca||67::Malinda Bainbridge||68::Jordanne Barr||69::Donny Barthal||70::Nikki Barthal||71::Autumn Bignami||72::Frank Bignami||73::Mike Blair||74::John Blumeyer||75::Melinda ""Mia"" Brockie||76::Clint Burton||77::Dustin Burkhardt||78::Nick Campbell||79::Jesus Campos||80::Angel Carmona||81::Mike Caster||82::Savanna Chasco||83::Jeff Christerson||84::Michaela Clark||85::Officer Casey Clarkson||86::Summer Clyburn||87::Allison Crute||88::Craig Cunneen||89::Debbie Cunneen||90::Lee Dorchak||91::Bobby Eardley||92::Al Etcheber||93::Chris Eyer||94::Samantha Faranda||95::Kurt Fowler||96::Melissa Fiero||97::Tina Frost||98::Elle Gargano||99::Paige Gasper||100::Kim Gervais||101::Danae Dawn Gibbs||102::Rylie Golgart||103::Officer Michael Gracia||104::Jimmy Grovom||105::Natalie Grumet||106::Andrew Gudmonson||107::Thomas Gunderson||108::Jason Hammond||109::Lt Derek Harp||110::Michael Hesselton||111::Tiffaini Huizar||112::Luca Iclodean||113::Alicia Johnston||114::Andrew Kampe||115::Steve Keys||116::Billy King||117::Christina Kitcat||118::Jeffrey Koishor||119::Mike Kordich||120::Jan Lambourne||121::Mykenzie Lane||122::Scott Lee||123::Det Curtis Leoni||124::Lisa Lewan||125::Matt Lewan||126::Sheldon Mack||127::Jovanna Martinez Calzadillas||128::Billy Bob Mason||129::Braden Matejka||130::Rob McIntosh||131::Tom McIntosh||132::Jason McMillan||133::Paige Melanson||134::Rosemarie Trautman Melanson||135::Zack Mesker||136::Jessica Milam||137::Officer Aaron Mundhenke||138::Officer Joseph Owen||139::Rocky Palermo||140::Bobby Parks||141::Shelby Perry||142::Amanda Peterson||143::Officer Tyler Peterson||144::Alexandra Pettis||145::Sgt Brad Powers||146::Jessi Preston||147::Ashley Quidocho||148::Olga Ramirez||149::Bill Robinson Jr||150::Nick Robone||151::Ariel Romero||152::Chelsea Romo||153::Agent Fred Rowbotham||154::Karessa Royce||155::Jeanine Ruggiero||156::George Sanchez||157::Savannah Nicole Sanchez||158::Ryan Sarrazin||159::Rachel Sheppard||160::Addison Short||161::Karen Smerber||162::Jonathan Smith||163::Angelica Soto||164::Kristina Staples||165::Jeff Steffens||166::Officer Chad Swanson||167::Steve Treskes||168::Dep Chief Bruce Ure||169::Natalie Vanderstay||170::April Vasquez||171::Stephen Vicelja||172::Wanda Weinreich||173::Officer1||174::Officer2||175::Officer3||176::OC Officer wife||177::Firefighter1||178::Firefighter2||179::Firefighter3||180::Firefighter4||181::Firefighter5||182::Firefighter6||183::Firefighter7||184::Civ1||185::Civ2||186::Civ3||187::Civ4||188::Civ5||189::Civ6||190::Civ7||191::Civ8||192::Civ9||193::Civ10||194::Civ11||195::Stephen Paddock",,0::Killed||1::Killed||2::Killed||3::Killed||4::Killed||5::Killed||6::Killed||7::Killed||8::Killed||9::Killed||10::Killed||11::Killed||12::Killed||13::Killed||14::Killed||15::Killed||16::Killed||17::Killed||18::Killed||19::Killed||20::Killed||21::Killed||22::Killed||23::Killed||24::Killed||25::Killed||26::Killed||27::Killed||28::Killed||29::Killed||30::Killed||31::Killed||32::Killed||33::Killed||34::Killed||35::Killed||36::Killed||37::Killed||38::Killed||39::Killed||40::Killed||41::Killed||42::Killed||43::Killed||44::Killed||45::Killed||46::Killed||47::Killed||48::Killed||49::Killed||50::Killed||51::Killed||52::Killed||53::Killed||54::Killed||55::Killed||56::Killed||57::Killed||58::Injured||59::Injured||60::Injured||61::Injured||62::Injured||63::Injured||64::Injured||65::Injured||66::Injured||67::Injured||68::Injured||69::Injured||70::Injured||71::Injured||72::Injured||73::Injured||74::Injured||75::Injured||76::Injured||77::Injured||78::Injured||79::Injured||80::Injured||81::Injured||82::Injured||83::Injured||84::Injured||85::Injured||86::Injured||87::Injured||88::Injured||89::Injured||90::Injured||91::Injured||92::Injured||93::Injured||94::Injured||95::Injured||96::Injured||97::Injured||98::Injured||99::Injured||100::Injured||101::Injured||102::Injured||103::Injured||104::Injured||105::Injured||106::Injured||107::Injured||108::Injured||109::Injured||110::Injured||111::Injured||112::Injured||113::Injured||114::Injured||115::Injured||116::Injured||117::Injured||118::Injured||119::Injured||120::Injured||121::Injured||122::Injured||123::Injured||124::Injured||125::Injured||126::Injured||127::Injured||128::Injured||129::Injured||130::Injured||131::Injured||132::Injured||133::Injured||134::Injured||135::Injured||136::Injured||137::Injured||138::Injured||139::Injured||140::Injured||141::Injured||142::Injured||143::Injured||144::Injured||145::Injured||146::Injured||147::Injured||148::Injured||149::Injured||150::Injured||151::Injured||152::Injured||153::Injured||154::Injured||155::Injured||156::Injured||157::Injured||158::Injured||159::Injured||160::Injured||161::Injured||162::Injured||163::Injured||164::Injured||165::Injured||166::Injured||167::Injured||168::Injured||169::Injured||170::Injured||171::Injured||172::Injured||173::Injured||174::Injured||175::Injured||176::Injured||177::Injured||178::Injured||179::Injured||180::Injured||181::Injured||182::Injured||183::Injured||184::Injured||185::Injured||186::Injured||187::Injured||188::Injured||189::Injured||190::Injured||191::Injured||192::Injured||193::Injured||194::Injured||195::Killed,0::Victim||1::Victim||2::Victim||3::Victim||4::Victim||5::Victim||6::Victim||7::Victim||8::Victim||9::Victim||10::Victim||11::Victim||12::Victim||13::Victim||14::Victim||15::Victim||16::Victim||17::Victim||18::Victim||19::Victim||20::Victim||21::Victim||22::Victim||23::Victim||24::Victim||25::Victim||26::Victim||27::Victim||28::Victim||29::Victim||30::Victim||31::Victim||32::Victim||33::Victim||34::Victim||35::Victim||36::Victim||37::Victim||38::Victim||39::Victim||40::Victim||41::Victim||42::Victim||43::Victim||44::Victim||45::Victim||46::Victim||47::Victim||48::Victim||49::Victim||50::Victim||51::Victim||52::Victim||53::Victim||54::Victim||55::Victim||56::Victim||57::Victim||58::Victim||59::Victim||60::Victim||61::Victim||62::Victim||63::Victim||64::Victim||65::Victim||66::Victim||67::Victim||68::Victim||69::Victim||70::Victim||71::Victim||72::Victim||73::Victim||74::Victim||75::Victim||76::Victim||77::Victim||78::Victim||79::Victim||80::Victim||81::Victim||82::Victim||83::Victim||84::Victim||85::Victim||86::Victim||87::Victim||88::Victim||89::Victim||90::Victim||91::Victim||92::Victim||93::Victim||94::Victim||95::Victim||96::Victim||97::Victim||98::Victim||99::Victim||100::Victim||101::Victim||102::Victim||103::Victim||104::Victim||105::Victim||106::Victim||107::Victim||108::Victim||109::Victim||110::Victim||111::Victim||112::Victim||113::Victim||114::Victim||115::Victim||116::Victim||117::Victim||118::Victim||119::Victim||120::Victim||121::Victim||122::Victim||123::Victim||124::Victim||125::Victim||126::Victim||127::Victim||128::Victim||129::Victim||130::Victim||131::Victim||132::Victim||133::Victim||134::Victim||135::Victim||136::Victim||137::Victim||138::Victim||139::Victim||140::Victim||141::Victim||142::Victim||143::Victim||144::Victim||145::Victim||146::Victim||147::Victim||148::Victim||149::Victim||150::Victim||151::Victim||152::Victim||153::Victim||154::Victim||155::Victim||156::Victim||157::Victim||158::Victim||159::Victim||160::Victim||161::Victim||162::Victim||163::Victim||164::Victim||165::Victim||166::Victim||167::Victim||168::Victim||169::Victim||170::Victim||171::Victim||172::Victim||173::Victim||174::Victim||175::Victim||176::Victim||177::Victim||178::Victim||179::Victim||180::Victim||181::Victim||182::Victim||183::Victim||184::Victim||185::Victim||186::Victim||187::Victim||188::Victim||189::Victim||190::Victim||191::Victim||192::Victim||193::Victim||194::Victim||195::Subject-Suspect,https://www.usatoday.com/story/news/2017/10/03/heres-timeline-how-las-vegas-shooting-unfolded/729034001/||https://www.nbcnews.com/storyline/las-vegas-shooting/las-vegas-shooting-59-killed-more-500-hurt-near-mandalay-n806461||http://www.clarkcountynv.gov/public-communications/Pages/Clark-County-Coroner-Releases-Names-of-Deceased-from-Oct--1-Mass-Shooting.aspx,16.0,10.0
I'm so sorry for the delay on this! It's just that I've been busy lately. I'll try getting to it first thing tomorrow.
Hi James, No issues. Just please let me know if you need any help in any manner.
@vishnuvemuru I made a markdown table of your data here: https://gist.github.com/jamesqo/ce720813b4a41672e3fb3a53abcf62c8. There are a couple of problems:
participant_age
column is decimal when it should be int / has some nan
entries that should be left out entirely. (e.g. instead of 0::0.0||1::nan||2::2.0
you want to generate 0::0||2::2
.participant_gender
column also has some nan valuessources
columnWould be super if this could get added, was going to make a start but looks like it's 90% done here....
I have modified both files 'stage1.10.2017.csv' and 'stage2.10.2017.csv' and added the Las Vegas record at the top.