Hacker News Reader

Comment by Sayrus | Hacker News Reader

To people interested in archiving this, it's still in the 7 days time history in BigQuery Public Dataset:

For instance:

SELECT country FROM `bigquery-public-data.google_political_ads.geo_spend` FOR SYSTEM_TIME AS OF TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 6 DAY) GROUP BY country;

View on HN

Could someone get Archive Team on this? https://archiveteam.org

I dumped the all active tables (advertiser_declared_stats, advertiser_geo_spend, advertiser_stats, advertiser_weekly_spend, geo_spend, creative_stats) in CSV format. I'd prefer if someone did an archive where they are confident in the integrity of the dumped data but at least that version exists.

Please upload those to archive.org.

https://archive.org/details/bigquery-public-data.google_poli...

/r/DataHoarder as well

https://www.reddit.com/r/DataHoarder/

Ohh, Google’s BQ query bills are about to go through the roof!

What does "7 days time" mean in this context?

https://cloud.google.com/bigquery/docs/access-historical-dat...

BigQuery supports a sort of "time travel" / point-in-time querying. By default and for those datasets it's enabled for 7 days which means you can query data as it was up-to 7 days ago.

If someone can post instructions, I’d be happy to follow them and make a copy as well.

For what it's worth, my own procedure:

1. Create a GCS bucket

2. Open https://console.cloud.google.com/bigquery?ws=!1m4!1m3!3m2!1s...

3. For each table under google_political_ads, run the following query: SELECT * FROM `bigquery-public-data.google_political_ads.<TABLE>` FOR SYSTEM_TIME AS OF TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 6 DAY) GROUP BY country;

3. Export as CSV in GCS

Another procedure that is probably better but requires BigTable is:

1. Open https://console.cloud.google.com/bigquery?ws=!1m4!1m3!3m2!1s...

2. For each table, click Snapshot and set Snapshot time to Sep 23 (Sep 24 works as well)

Reply on news.ycombinator.com