Skip to content

Instantly share code, notes, and snippets.

@tucotuco

tucotuco/gist:2aa2a7c57c53d565ef5b

Created July 17, 2014 21:05
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tucotuco/2aa2a7c57c53d565ef5b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tucotuco/2aa2a7c57c53d565ef5b to your computer and use it in GitHub Desktop.
Download ZIP
BigQuery example
Raw
gistfile1.sql
SELECT institutioncode, basisofrecord, count(institutioncode) as reps
FROM [dumps.full]
WHERE basisofrecord not in ('PreservedSpecimen', 'FossilSpecimen')
GROUP BY institutioncode, basisofrecord
ORDER BY reps DESC
LIMIT 1000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment