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
300
1

Grano: A Python tool for investigating influence

Avatar for Friedrich Lindenberg

Friedrich Lindenberg

September 13, 2014

More Decks by Friedrich Lindenberg

See All by Friedrich Lindenberg
Introducción a OCCRP Data
Avatar for Friedrich Lindenberg pudo
0
430
Getting started with OCCRP Data
Avatar for Friedrich Lindenberg pudo
0
1.7k
#nr16: Recherche-Tools
Avatar for Friedrich Lindenberg pudo
1
120
data.occrp.org
Avatar for Friedrich Lindenberg pudo
0
180
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
290
Dr. Freezefile
Avatar for Friedrich Lindenberg pudo
2
450
Intro presentation for Naivasha
Avatar for Friedrich Lindenberg pudo
1
180

Featured

See All Featured
Building Adaptive Systems
Avatar for Chris Keathley keathley
44
3k
Writing Fast Ruby
Avatar for Erik Berlin sferik
630
63k
How to build a perfect <img>
Avatar for Jono Alderson jonoalderson
1
5.4k
Navigating Algorithm Shifts & AI Overviews - #SMXNext
Avatar for Aleyda Solis aleyda
1
1.2k
My Coaching Mixtape
Avatar for mlcsv mlcsv
0
96
The Spectacular Lies of Maps
Avatar for Per Axbom axbom
PRO
1
680
Reality Check: Gamification 10 Years Later
Avatar for Sebastian Deterding codingconduct
0
2.1k
Visual Storytelling: How to be a Superhuman Communicator
Avatar for David Neal reverentgeek
2
500
Stewardship and Sustainability of Urban and Community Forests
Avatar for Eric Wiseman pwiseman
0
170
Done Done
Avatar for chrislema chrislema
186
16k
The B2B funnel & how to create a winning content strategy
Avatar for Katarina Dahlin katarinadahlin
PRO
1
330
A Guide to Academic Writing Using Generative AI - A Workshop
Avatar for Kenji Saito ks91
PRO
1
260

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!