LogoLogo
The Fundamentals of Data-driven Storytelling
The Fundamentals of Data-driven Storytelling
  • About this course
    • Course Introduction
  • Module 1 - Find
    • 1.1 How to Find Data for Storytelling and journalism
      • Starting with a question
      • Open data portals and platforms
      • Other sources of data
    • 1.2 How to get better data from a Goolge Search
      • Searching for filetypes and formats
      • More on Advanced Search operators
      • Other common Google Search operators
    • 1.3 Sourcing your own data
      • Creating a Google Form for Research
      • Creating a questionnaire with TypeForm
      • Using quizzes and comments as a sources of data
  • Module 2 - Get
    • 2.1 Turning websites and PDFs into machine readable data
      • Scraping data with Tabula
    • 2.2 An introduction to spreadsheet software
      • Google Sheets, Microsoft Excel and Libre Office Calc.
      • Finding your way around a spreadsheet
      • Simple web scraping with Google Sheets
  • Module 3 - Verify
    • 3.1 Can I use this data in my work?
      • Initial steps for verification
      • What do these column headings mean?
  • Module 4 - Clean
    • 4.1 What to do with disorganised data?
      • Why is clean data important?
      • Keep your data organised
      • Cleaning data cheatsheet
  • Module 5 - Analyse
    • 5.1 What is the story within the data?
      • Spreadsheet rows, columns, cells and tabs
        • Spreadsheet formats, forumlas and essential shortcuts
          • Using the VLOOKUP Function
            • Combine Data From Multiple Spreadsheets
    • 5.2 How to turn numbers into stories
  • Module 6 - Visualise
    • 6.1 Ways we visualise data
    • 6.2 Why we visualize Data
    • 6.3 How to visualise data
  • Course Testing & Feedback
    • ⏱️Quick course exam
    • 🎓Extended course exam
    • 📝Survey and feedback
Powered by GitBook
On this page
  • Focus search results on data types
  • Refine image searches
  1. Module 1 - Find
  2. 1.2 How to get better data from a Goolge Search

Searching for filetypes and formats

Previous1.2 How to get better data from a Goolge SearchNextMore on Advanced Search operators

Last updated 2 years ago

You can use similar parameters as the Advanced Search offers, by using search parameter shortcuts. These are text commands that you simply enter along with your search text.

For example, entering the text "sharks kwazulu natal" into Google will return information about two things: the rugby team based in Durban and the marine animal. You can use the minus sign to quickly filter out results containing the type of shark you don't want to know about.

  • sharks kwazulu natal -rugby should bring back results which only feature the animal.

  • sharks kwazulu natal -ocean will predominantly feature results about the rugby team.

Another powerful search operator everyone should know is the quotation mark. If you enclose text in quotation marks, Google will look for exact matches to the text, rather than results which are like it. This can be very useful if you know a sentence from a speech, for example, or the exact title of a report.

One of the most useful search operators allows you to restrict results to a specific web domain.

For example, searching for "matric results" will bring up a lot of news and comment websites, as well as social media and individual school pages, talking about high school exam results in South Africa.

Changing your search term to include the site: operator, however, will tell Google exactly where you want to look for the term. Try:

site:education.gov.za matric results

This should only return pages that are hosted by the Department of Education.

Focus search results on data types

Even more useful is the ability to refine your search to only include specific file types. Often, organisations publish data in PDF or Microsoft Excel formats, and upload these files to their website. You can use the filetype: operator to restrict searches to these files only. For example, you can look for spreadsheets of exam results using this search:

matric results filetype:xlsx

You can also combine search terms to hone in on what you are looking for. This search will only look for spreadsheets on the Department of Education's website that contain the words "matric results".

matric results filetype:xlsx site:education.gov.za

Refine image searches

Overall Advanced Search

  1. Use filters like region or file type to narrow your results.

  2. At the bottom, click Advanced Search.

Search for an exact image size

Right after the word you're looking for, add the text imagesize:widthxheight. Make sure to add the dimensions in pixels.

Example: imagesize:500x400

For example, "it is an ideal for which I am prepared to die" should take you straight to a transcript of .

Go to .

Nelson Mandela's speech at the Rivonia Trial
Advanced Image Search
Refine web searches - Google Search Help
Logo