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
310
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
450
Getting started with OCCRP Data
Avatar for Friedrich Lindenberg pudo
0
1.7k
#nr16: Recherche-Tools
Avatar for Friedrich Lindenberg pudo
1
130
data.occrp.org
Avatar for Friedrich Lindenberg pudo
0
180
Tools for Data Journalism | MediaLab Prado DDJ Workshop
Avatar for Friedrich Lindenberg pudo
0
260
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
300
Dr. Freezefile
Avatar for Friedrich Lindenberg pudo
2
470
Intro presentation for Naivasha
Avatar for Friedrich Lindenberg pudo
1
190

Featured

See All Featured
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
Avatar for panda_program panda_program
123
22k
The Pragmatic Product Professional
Avatar for Laura Van Doore lauravandoore
37
7.4k
Chasing Engaging Ingredients in Design
Avatar for Sebastian Deterding codingconduct
0
240
Art, The Web, and Tiny UX
Avatar for Lynn Fisher lynnandtonic
304
22k
The Success of Rails: Ensuring Growth for the Next 100 Years
Avatar for Eileen M. Uchitelle eileencodes
47
8.2k
The Straight Up "How To Draw Better" Workshop
Avatar for Dennis Kardys denniskardys
239
140k
The Web Performance Landscape in 2024 [PerfNow 2024]
Avatar for Tammy Everts tammyeverts
12
1.2k
The Limits of Empathy - UXLibs8
Avatar for Cassini Nazir cassininazir
1
560
The State of eCommerce SEO: How to Win in Today's Products SERPs - #SEOweek
Avatar for Aleyda Solis aleyda
2
11k
Optimizing for Happiness
Avatar for Tom Preston-Werner mojombo
378
71k
Gemini Prompt Engineering: Practical Techniques for Tangible AI Outcomes
Avatar for Mfonobong Umondia mfonobong
2
470
Practical Orchestrator
Avatar for Shlomi Noach shlominoach
191
11k

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!