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

Grano: A Python tool for investigating influence

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
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
440
Intro presentation for Naivasha
Avatar for Friedrich Lindenberg pudo
1
170

Featured

See All Featured
Thoughts on Productivity
Avatar for Jon Yablonski jonyablonski
74
5k
How To Stay Up To Date on Web Technology
Avatar for Chris Coyier chriscoyier
791
250k
DevOps and Value Stream Thinking: Enabling flow, efficiency and business value
Avatar for Helen Beal helenjbeal
1
94
Believing is Seeing
Avatar for Spiro Bolos oripsolob
1
54
Optimizing for Happiness
Avatar for Tom Preston-Werner mojombo
379
71k
Done Done
Avatar for chrislema chrislema
186
16k
How to make the Groovebox
Avatar for あそなす asonas
2
1.9k
Rebuilding a faster, lazier Slack
Avatar for samanthasiow samanthasiow
85
9.4k
AI Search:
Where Are We & What Can We Do About It?
Avatar for Aleyda Solis aleyda
0
6.9k
Hiding What from Whom? A Critical Review of the History of Programming languages for Music
Avatar for Tomoya Matsuura tomoyanonymous
2
420
brightonSEO & MeasureFest 2025 - Christian Goodrich - Winning strategies for Black Friday CRO & PPC
Avatar for Christian Goodrich cargoodrich
3
100
Music & Morning Musume
Avatar for Bryan Veloso bryan
47
7.1k

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!