RUTAS DEL CONFLICTO: STORYTELLING FROM DATA H T T P : / / R U T A S - - PowerPoint PPT Presentation
RUTAS DEL CONFLICTO: STORYTELLING FROM DATA H T T P : / / R U T A S D E L C O N F L I C T O . C O M / Os Oscar Parra (oparra06@gmail.com) Universidad del Rosario Bogota (Colombia) Iv Ivonne Ro Rodrguez (ivonne.rodriguezg@upb.edu.co)
H T T P : / / R U T A S D E L C O N F L I C T O . C O M /
Os Oscar Parra (oparra06@gmail.com) Universidad del Rosario – Bogota (Colombia) Iv Ivonne Ro Rodríguez (ivonne.rodriguezg@upb.edu.co) Universidad Pontificia Bolivariana – Santander (Colombia) October 9, 2015 / Lillehammer, Norway Global Investigative Journalism Network
Col Colomb
is a a country th that is is cu currently und undergoing ng a a pr process of
peace. Th The pa paramilitary gr groups we were de demobilized be between 2005 2005 and 2006 2006 and is is no now ve very li likely ly th that th the FA FARC guerrillas de demobilize be before Ma March 23, 23, 20 2016. 6. Th The co conflict ct ha has le left vi victims uno unofficially 10 10 mi million
and 2 mi million
hectares we were ro robbed by by ar armed ac actors.
Mo More th than 300 300 th thousand pe peopl ple ha has de dead in in Colombia ia du during th the la last 50 50 ye years, i , in a wa war be between co communist gu guerrillas, th the Co Colombian ar army an and pa paramilitary gr groups. Th The la last on
, a bi big cr criminal band su supported fi financially by by tr traffic de dealers th that ki killed th thousands of
le leftist le leaders, , si signed a a tr treaty ty wi with th the Co Colombian go government in in 2005 to to pa pay ju just ei eight ye years of
jail il in in ex exchange to to ac accept th their cr crimes, , to to te tell th the tr true and to to co compensate te th their vi victims. Photos: archive Semana magazine
Th This pr process of
transiti tional ju justic ice we were do documented by by me media th through tr traditi tional fo formats li like ne news an and sp special re reports. . Ve Verdadabierta.com, , an an in independent jo journalis istic ic pr project th that co covered th the pr process, , wr writing mo more th than fi five th thousand te texts ts sh showing th the te testi timonies of th the cr criminal gr groups, , de decide ded to to cr create te a a pu public da database wi with th the in informatio ion re related wi with ma massacres, , gi given by by fo formers me memb mbers of
pa paramilitary gr groups. .
To To or
the in informatio ion, , th the te team of
the pr project us use a me method
from th the de design of
st structures of
databases of
computer en engineer eering: : to to id identif ify, , to to cl classify an and to to te tell. . In In th the fi first st step of
the pr process, , it it wa was ne necessary to to id identif ify wh which we were th the ba basic re register of
da database: : * * pe peopl ple (a (a li list of
victims of
massacres) * * places (wh where th these cr crimes we were co committed) ) *or
even ents (th the ma massacres th their se selves). ).
Ac According to to th the th theory of
the de design of
databases fr from th the co computer en engineer eering, , as th the re relationship be between ma massacres and c criminal gr groups is is ma many to to ma many (a (a gr group co could co committed se several ma massacres and a a ma massacre co could be be pe perpe petrated by by se several gr groups), , a sc scheme wi with th three ta tables wa was us used: : th the fi first on
to re register th the ma massacres, , an another to to re register th the gr groups, a , and th the ot
to bu build a a re relation be between th the fi first tw two. Fi Finally, , it it wa was ve very im important fo for th the pr project, , to to ha have a a fi field to to te tell de details ab about th the ev even ents. . It It is is ve very im important in in th this me methodology to to co consider th that th the in informatio ion in in th this fi field, , co could no not us use to to cl classify in informatio ion, a , and it its ma main pu purpo pose is is de describe wi with jo journalis istic ic cr criteria de details of
the re register.
Óscar, incluir aquí foto original de la base de datos que construiste para mostrar los campos.
To To te tell th the st storie ies, , jo journalist ist fo focus th their jo job to to se search in informatio ion re related to to th the ev even ents of
the ma massacres (wh when, , wh where an and ho how), ), th the na name an and pr profession of
the vi victims, , th the co context of
the co conflict ct in in th the re region wh where th the cr crimes we were pe perpe petrated an and th the co confirmed da data of th the cr criminal gr groups th that co committed th the cr crimes. Th The pr project pu published th the in informatio ion in in a web sit site (Ru Rutasdelconflicto.com) ) and in an an ap app fo for mob mobile de devices in in Ma March of
using ng se several to tools to to sh show data li like, , ma maps an and time li lines. . Du During th the fi first we weeks, R , Rutas del C Conflicto re received mor more th than 10 100 me messages wi with pe petitions to to ed edit an and to to ad add in informatio ion, a , and wi with te testi timonies of su surviv ivors
the ma massacres.
In In th these ci circu cumsta tance ces, , th the pr project st started a a se second ph phase in in Ja January
searching wa ways to to ta take th the in informatio ion in in th the we web to to pe peopl ple re related wi with th the ev even ents do documented, , fi first of
all to to co conti tinue wi with a a pr process of
facts ch check cking an and al also to to te tell st stories fr from su survivors th that su suffer in in so some wa way th the ef effec ects of
the ma massacres. http://rutasdelconflicto.com/interna.php?ma sacre=679
Si Since th the be beginning of
the pr project in 2013, , Rutas d del Co Conflicto wo worked wi with uni university st students of
journalis ism fr from Universidad d del R Rosario in th the pr process of
do documentation of
the in informatio ion. . Fo For th the se second pa part, , st students of
the Universidad P Pontificia B Bolivariana o
Bucaramanga, , in Santander, , a pr province of C Colombia, , jo join ined to to Rutas d del C Conflicto, , le leaded by by Pr Professor Iv Ivonne Ma Marcela Ro Rodriguez. . Th The di direction of
the de develop of
the se second pa part of
the pr project co continued in in ha hands of
the au author of
the or
idea, O , Oscar Parra, , as Pr Professor of U Universidad d del Rosario in B Bogotá, a , and a as director of th the fo foundation Co Con Lupa, , an an or
associat ated to to VerdadAbierta.c .com an and th the Na National Center o
Historical Me Memory.
https://www.indiegogo.com/projects/unete- al-proyecto-yo-sobrevivi#/story
In In th these tr trips, , th the jo journalis ists al also cr create al allian ances wi with tr traditi tional lo local l media to to br broadcast th the in informatio ion. . TV ch channels an and ra radio st station of
music ma made sp special pr programs in in wh which re reporters rs te tell th the st stories an and gi give to to pe peopl ple ph phone num numbers to to re receive th their te testi timonies.
Th The se second pa part of
the pr process fo focuses in in th the co collect ction of
in informatio ion fr from th the pe peopl ple. . Th The in interactio ion wi with th the vi victims ha has al allowed to to th the pr project tw two th things: : fa facts ch check cking of
the da data base and d on
the ot
hand, , ge get in invaluable st stories th that sh show ho how li life of
peopl ple ch changed wi with th the pa painful ev even ents an and ho how th they ha have su survived to to th the so social in indif ifference. Mo Most of
the in informatio ion in in ac acad ademic an and judicial al re researc rchers rs wa was to told by by me memb mbers of
groups th that, , fo for di different re reasons, , co could be be in inexact. . Al Also, , ma many of
these cr crimes we were co committed in in ve very re remote places, , wh where th the pr presence of
the ag agency of
the go government an and me memb mbers of
the ju judic icia ial sy syst stem we were pr practically no non-ex exist. . Fo For th this re reason it it ha has be been ve very im important fo for th the pr project to to cr create ch channels wi with di direct so sources.
In In c case of f th the vi victim give ves info formation th that en endanger er th their live ves, , be because th they ar are st still livi ving in p places wh where th the ac actors of f wa war ke keep co committing cr crimes, , or
that affe fects th their di dignity, , th the id identit ity ar are no not pu published. . In In c case th there is is so some me info formation co correct cted by by th the vi victims an and confi firmed by by th the jo journal alis ists of f th the pr project, , it it is is ch changed in in th the we web and th the ap app fo for mo mobile devi vices, , sh showi wing in in bo bold th the te text ed edited ed in in th the pr process.
Th The th third pa part of
the pr process se searches to to gi give th the pe peopl ple so some to tools to to he help th them to to pr produce th their self’s ’s jo journalis istic ic co content fr from th this ex exper erien ence an and kn knowledge. . A A fe few mo months af after th the fi first tr trip, , re reporters rs re return rn to to th the pl place to to sh show th the videos, , te texts ts or
audios pr produced an and wi with a a sp special re report wi with th the hi history of
the wa war in in th the to town an and in invit itin ing th the co community to to ke keep cr creating th their ow
co content. Du During th the mo months be between th the tr trips, , th the jo journalis ists re researc rch in informatio ion ab about th the hi historical de develop an and th the ac actor of th the wa war, , to to cr create a w web p page wi with ex exclusive e in informatio ion of
the to town wh where th they wo worked in in th the tw two fi first st step of
the pr process. . Th This we web si site has a a series of in interactiv ive to tool li like in infografie ies, , ti timelines, a , and ma maps to to ex explain th the re reports in in th the ea easies est wa way to to th the co community.
At At th the en end of
September of 2 2015, , th there ar are fi five si sites in in co construct ction of
the to towns vi visited pr previously, a , and th they wi will be be pu public on
the web a at th the be beginning of
October. . Rutas d del C Conflicto h has vi visited mo more th than 20 20 to towns in in di different re regions of C Colombia and i in ea each of
these ca cases ar are pl planned to to us use th the sa same pr process, , to to cr create si sites to to sh show th the jo job wi with th the co communities. Th The jo journalis ists in involved in in al all th the pr process ar are st students of
la last ye years of
the uni universities of R Rosario in Bo Bogota, , and Universidad P Pontificia B Bolivariana i in B Bucaramanga, , di directed by by pr professors Iv Ivonne Ro Rodriguez and O Oscar Parra, , wh who ha have mo more th than fi five ye years of
exper erien ences es do documented th the wa war in C Colombia. . Bo Both uni universities al also br bring te technological eq equipmen ent to to re record rd and ed edit th the au audiovisual al co content pr produced in Rutas d del C Conflicto. At At th the sa same time, , th the da data jo journalis ism ex exer ercise co continues wi with th the do documentation of
the re rest of
the ab about 1.2 .200 ma massacres to to ad add in in th the data b base.
Os Oscar Parra (oparra06@gmail.com) Universidad del Rosario – Bogota (Colombia) Iv Ivonne R Rodríguez (ivonne.rodriguezg@upb.edu.co) Universidad Pontificia Bolivariana – Santander (Colombia) October 9, 2015 / Lillehammer, Norway Global Investigative Journalism Network