Basic data tools for journalists
data
information
knowledge
insight
wisdom
conspiracy
00100011100011011110001101100001100111100101001101001111001101010100001100111110010101110101010010111010101011110100001011010101110101010110111011101110101011011010101110110101011010110100000101010101011111101010101011011111010001010101101101101010101010101010101010011011011010101010111010101011100101010101111101001000101000101001001010101101010111010101000010101111010101011001011011010101010110111010101000101000001010101110101101011010101000010101010110111010110101010000010101010100100101010110111110101010100000101010101011010100000101010111110101001010101010101010100101011010101010101011010110111101001010101010101000001010100000000101010100110111010101101010000
user friendly data
xls
xlsx
csv
tsv
sps
json
xml
kml
geojson
shp
geotiff
pdf
jpeg
date | year, H, Q, month, days, hours to seconds |
geolocation | continent, country, region, county, city, lines, polygons, coordinates |
string | description - names, qualities, categories |
measure | whole, fraction, decimal |
boolean | true/false, yes/no |
types of data
-
search
-
download
-
conversion
-
storage and preparation
-
analysis
-
presentation
-
What is useful/usable/free today, may not be useful/usable/free tomorrow
-
Criminal organizations and state agencies are constantly learning
-
This is only a collection, there are other tools which can be used for the same purposes
-
There is no Swiss knife tool, and this is good!
-
Many times you have to use different tools for every little step
-
Google is your friend, and you are not alone - there are hundreds of forums where experts discuss the solutions for specific questions and problems
some remarks
search
-
Google advanced search, Google search operators
-
DuckDuckGo
-
Facebook Graph Search / Facebook ID
-
Whois https://whois.domaintools.com/
-
-
Databases
-
Google Dataset Search
-
OCCRP Aleph
-
OCCRP ID
-
Vesselfinder
-
Flightradar24
-
Radarbox
-
Local databases (public procurement datasets, company registry database)
processed data
META | GLOBAL | SPECIAL | MARKET RESEARCH | NATIONAL |
---|---|---|---|---|
Google Data | UN | Global Terrorism DB | Kantar | Public Procurements |
Ourworldindata | Worldbank | Freedom House | Gemius | Central Statistical Bureau |
Nasdaq Data | Eurostat | RSF | Ipsos | MET |
Eur Data Portal | UNESCO | TI | TNS | Tax Bureau |
IMF | Company Reg | Land ownership | ||
NASA | OCCRP ALEPH | National funds | ||
OECD | Átlátszó | |||
FB, Twitter |
download
-
Google Spreadsheet Importhtml=
-
Google Scraper
-
Import.io
conversion
-
PDFTables https://pdftables.com/
-
Tabula https://tabula.technology/
-
Aconvert https://www.aconvert.com/
-
Zamzar https://www.zamzar.com/
-
Mygeodata https://mygeodata.cloud/
storage and preparation
-
Excel
-
Numbers
-
Openrefine https://openrefine.org/download.html
-
Tableau Prep https://www.tableau.com/products/prep/download
analysis
-
Excel
-
Numbers
-
Mysql
-
Tableau Public https://public.tableau.com/en-us/s/
-
Power BI
-
IBM Watson
presentation
-
Google Data Studio
-
Flourish, Datawrapper, RAWGraphs, PlotDB, Plotly, Highcharts
-
Unfolded, QGIS, Mapbox / Google/Google Earth/Timelapse https://earthengine.google.com/timelapse/
-
VIS https://github.com/alephdata/datadesktop, Gephi, Cytoscape, Cosmograph
-
Chrono
-
Knightlab Tools https://knightlab.northwestern.edu/projects/
Mapping information - diagrammatic thinking
- table = visual representation
- Canva
- Lucid
- Gephi
- Cytoscape
- VIS Dashboard
Mapping information - chronologic order
- Chronoflo
- Sutori
- Knightlab Timeline
Mapping information - spatial order
- Google My Maps
- Google Earth
- Carto
- Flourish
- Kepler/Unfolded
- ArcGIS Storymap
- Knightlab Storymap
OSINT
By Attila Bátorfy
OSINT
- 697