Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Grano: A Python tool for investigating influence

Avatar for Friedrich Lindenberg Friedrich Lindenberg
September 13, 2014
1
290

Grano: A Python tool for investigating influence

Avatar for Friedrich Lindenberg

Friedrich Lindenberg

September 13, 2014
Tweet

More Decks by Friedrich Lindenberg

See All by Friedrich Lindenberg
Introducción a OCCRP Data
Avatar for Friedrich Lindenberg pudo
0
420
Getting started with OCCRP Data
Avatar for Friedrich Lindenberg pudo
0
1.6k
#nr16: Recherche-Tools
Avatar for Friedrich Lindenberg pudo
1
110
data.occrp.org
Avatar for Friedrich Lindenberg pudo
0
170
Tools for Data Journalism | MediaLab Prado DDJ Workshop
Avatar for Friedrich Lindenberg pudo
0
250
Digitial Research Tools for Investigative Reporters
Avatar for Friedrich Lindenberg pudo
0
11k
Data doesn't grow in tables
Avatar for Friedrich Lindenberg pudo
2
280
Dr. Freezefile
Avatar for Friedrich Lindenberg pudo
2
430
Intro presentation for Naivasha
Avatar for Friedrich Lindenberg pudo
1
170

Featured

See All Featured
The Hidden Cost of Media on the Web [PixelPalooza 2025]
Avatar for Tammy Everts tammyeverts
2
140
Tell your own story through comics
Avatar for letsgokoyo letsgokoyo
1
780
A Modern Web Designer's Workflow
Avatar for Chris Coyier chriscoyier
698
190k
My Coaching Mixtape
Avatar for mlcsv mlcsv
0
23
Public Speaking Without Barfing On Your Shoes - THAT 2023
Avatar for David Neal reverentgeek
1
290
Are puppies a ranking factor?
Avatar for Jono Alderson jonoalderson
0
2.6k
The SEO Collaboration Effect
Avatar for Kristina Bergwall kristinabergwall1
0
330
The Success of Rails: Ensuring Growth for the Next 100 Years
Avatar for Eileen M. Uchitelle eileencodes
47
7.9k
AI Search:
Where Are We & What Can We Do About It?
Avatar for Aleyda Solis aleyda
0
6.8k
Build The Right Thing And Hit Your Dates
Avatar for Maggie C. maggiecrowley
38
3k
The #1 spot is gone: here's how to win anyway
Avatar for Tamara Novitovic tamaranovitovic
1
890
Build your cross-platform service in a week with App Engine
Avatar for Jose L jlugia
234
18k

Transcript

  1. PYTHON TOOLS FOR Investigating Influence

  2. None

  3. BACKBONE SERVICES for JOURNALISTS and ACTIVISTS Open AFRICA SOURCE AFRICA

    AFRI LEAKS AFRICAN SPENDING CONNECTED AFRICA

  4. INVESTIGATIVE JOURNALISTS

  5. WHAT DO THEY DO? HOW DO THEY DO IT?

  6. INVESTIGATIVE ACTIVITIES MINE DOCS AND DATA MAP OUT NETWORKS CONSTRAINTS

    LEGALLY ACTIONABLE PROTECT SOURCES

  7. BIOS/FAMILY COMPANY DIRECTORS NGO DIRECTORS COURT CASES PARTY MEMBERSHIP COMMITTEES

    FINANCIAL INTERESTS GOV CONTRACTS STRUCTURAL TRANSACTIONAL

  8. JOURNALISTIC QUERIES PERSON COMPANY PUBLIC BODY PERSON

  9. INFLUENCE MAPPING

  10. HTTP://GRANOPROJECT.oRG

  11. Network analysis tool Integrate messy data Full provenance REQUIREMENTS

  12. BACKENDS

  13. DETOUR: LINKED DATA https://github.com/uf6/design/issues

  14. SQL: STILL PRETTY AWESOME

  15. DATA MODEL I’LL BUY A COPY OF OMNIGRAfFLE SOON. PROMISE.

  16. DATA LOADING SCRAPERS CSV FILES SCRAPERS GRANO LOADER GRANO API

    PROFIT! GOOGLE DOCS YAML MAPPINGS ALIAS MAPPINGS REFINE SCHEMA

  17. DATA LOADING SCRAPERS CSV FILES SCRAPERS GRANO LOADER GRANO API

    PROFIT! GOOGLE DOCS YAML MAPPINGS ALIAS MAPPINGS REFINE SCHEMA

  18. DE-DUPE IS HELL

  19. EXTERNAL INTERFACES (FROZEN) FLASK REST API CLIENTS

  20. ANALYTICAL INTERFACES FIND STORIES MANAGE EVIDENCE

  21. QUERY LANGUAGE GRANO QL = STUPID MQL MQL (FREEBASE/GOOGLE) -

    QUERY BY JSON EXAMPLE CYPHER (NEO4J) - SQL FOR GRAPHS SPARQL (RDF/LINKED DATA) - SQL FOR LINKED DATA

  22. QUERY TOOL (WIP!) ANGULAR.JS D3 + DUCT TAPE

  23. Great query tool FEDERATED Data enrichment “Soup (docs) to sense

    (relations)” Roll out to other countries THE FUTURE

  24. THANKS [email protected] http://granoproject.org LOOKING FOR FRONT-END JS DEVS!