Skip to content

Instantly share code, notes, and snippets.

@lambdamusic

lambdamusic/covid19-tutorial-1.sql

Last active April 4, 2024 21:59
Show Gist options
  • Save lambdamusic/7882b3e97b5a7898f18d3589b32c120d to your computer and use it in GitHub Desktop.
Save lambdamusic/7882b3e97b5a7898f18d3589b32c120d to your computer and use it in GitHub Desktop.
Download ZIP
GBQ COVID-19 dataset sample query #sql
Raw
covid19-tutorial-1.sql
SELECT
p.id,
p.title.preferred AS title,
p.doi,
p.year,
p.journal.title,
p.type,
p.date AS date_publication,
p.date_inserted,
FROM
`covid-19-dimensions-ai.data.publications` p
WHERE
EXTRACT(YEAR
FROM
date_inserted) >= 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment