Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
Grano: A Python tool for investigating influence
Search
Friedrich Lindenberg
September 13, 2014
330
1
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
Grano: A Python tool for investigating influence
Friedrich Lindenberg
September 13, 2014
Transcript
24 slides
PYTHON TOOLS FOR Investigating Influence
None
BACKBONE SERVICES for JOURNALISTS and ACTIVISTS Open AFRICA SOURCE AFRICA
AFRI LEAKS AFRICAN SPENDING CONNECTED AFRICA
INVESTIGATIVE JOURNALISTS
WHAT DO THEY DO? HOW DO THEY DO IT?
INVESTIGATIVE ACTIVITIES MINE DOCS AND DATA MAP OUT NETWORKS CONSTRAINTS
LEGALLY ACTIONABLE PROTECT SOURCES
BIOS/FAMILY COMPANY DIRECTORS NGO DIRECTORS COURT CASES PARTY MEMBERSHIP COMMITTEES
FINANCIAL INTERESTS GOV CONTRACTS STRUCTURAL TRANSACTIONAL
JOURNALISTIC QUERIES PERSON COMPANY PUBLIC BODY PERSON
INFLUENCE MAPPING
HTTP://GRANOPROJECT.oRG
Network analysis tool Integrate messy data Full provenance REQUIREMENTS
BACKENDS
DETOUR: LINKED DATA https://github.com/uf6/design/issues
SQL: STILL PRETTY AWESOME
DATA MODEL I’LL BUY A COPY OF OMNIGRAfFLE SOON. PROMISE.
DATA LOADING SCRAPERS CSV FILES SCRAPERS GRANO LOADER GRANO API
PROFIT! GOOGLE DOCS YAML MAPPINGS ALIAS MAPPINGS REFINE SCHEMA
DATA LOADING SCRAPERS CSV FILES SCRAPERS GRANO LOADER GRANO API
PROFIT! GOOGLE DOCS YAML MAPPINGS ALIAS MAPPINGS REFINE SCHEMA
DE-DUPE IS HELL
EXTERNAL INTERFACES (FROZEN) FLASK REST API CLIENTS
ANALYTICAL INTERFACES FIND STORIES MANAGE EVIDENCE
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
QUERY TOOL (WIP!) ANGULAR.JS D3 + DUCT TAPE
Great query tool FEDERATED Data enrichment “Soup (docs) to sense
(relations)” Roll out to other countries THE FUTURE
THANKS
[email protected]
http://granoproject.org LOOKING FOR FRONT-END JS DEVS!
More Decks by Friedrich Lindenberg
See All by Friedrich Lindenberg
Introducción a OCCRP Data
pudo
0
470
Getting started with OCCRP Data
pudo
0
1.8k
#nr16: Recherche-Tools
pudo
1
150
data.occrp.org
pudo
0
190
Tools for Data Journalism | MediaLab Prado DDJ Workshop
pudo
0
270
Digitial Research Tools for Investigative Reporters
pudo
0
11k
Data doesn't grow in tables
pudo
2
310
Dr. Freezefile
pudo
2
490
Intro presentation for Naivasha
pudo
1
210
Featured
See All Featured
The Web Performance Landscape in 2024 [PerfNow 2024]
tammyeverts
12
1.4k
Gemini Prompt Engineering: Practical Techniques for Tangible AI Outcomes
mfonobong
2
630
Put a Button on it: Removing Barriers to Going Fast.
kastner
60
4.6k
Redefining SEO in the New Era of Traffic Generation
szymonslowik
1
530
brightonSEO & MeasureFest 2025 - Winning Strategies for Black Friday CRO & PPC - Christian Goodrich
cargoodrich
3
900
How to Talk to Developers About Accessibility
jct
2
620
Self-Hosted WebAssembly Runtime for Runtime-Neutral Checkpoint/Restore in Edge–Cloud Continuum
chikuwait
0
940
How to optimise 3,500 product descriptions for ecommerce in one day using ChatGPT
katarinadahlin
PRO
3
3.9k
Test your architecture with Archunit
thirion
2
2.5k
Side Projects
sachag
456
43k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
eileencodes
28
3.8k
Agile Leadership in an Agile Organization
kimpetersen
PRO
0
310