Grano: A Python tool for investigating influence

Transcript

1. PYTHON TOOLS FOR Investigating Influence
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 friedrich@pudo.org http://granoproject.org LOOKING FOR FRONT-END JS DEVS!