Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Grano: A Python tool for investigating influence
Search
Friedrich Lindenberg
September 13, 2014
1
270
Grano: A Python tool for investigating influence
Friedrich Lindenberg
September 13, 2014
Tweet
Share
More Decks by Friedrich Lindenberg
See All by Friedrich Lindenberg
Introducción a OCCRP Data
pudo
0
400
Getting started with OCCRP Data
pudo
0
1.5k
#nr16: Recherche-Tools
pudo
1
94
data.occrp.org
pudo
0
140
Tools for Data Journalism | MediaLab Prado DDJ Workshop
pudo
0
240
Digitial Research Tools for Investigative Reporters
pudo
0
11k
Data doesn't grow in tables
pudo
2
260
Dr. Freezefile
pudo
2
380
Intro presentation for Naivasha
pudo
1
160
Featured
See All Featured
Fontdeck: Realign not Redesign
paulrobertlloyd
82
5.3k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
132
33k
Practical Tips for Bootstrapping Information Extraction Pipelines
honnibal
PRO
10
860
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
98
18k
Code Review Best Practice
trishagee
65
17k
How To Stay Up To Date on Web Technology
chriscoyier
790
250k
The Invisible Side of Design
smashingmag
299
50k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
33
2k
What's in a price? How to price your products and services
michaelherold
244
12k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
226
22k
Designing for humans not robots
tammielis
250
25k
Done Done
chrislema
182
16k
Transcript
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!