This dataset contains two tables: creative_stats and removed_creative_stats. The creative_stats table contains information about advertisers that served ads in the European Economic Area or Turkey: their legal name, verification status, disclosed name, and location. It also includes ad specific information: impression ranges per region (including aggregate impressions for the European Economic Area), first shown and last shown dates, which criteria were used in audience selection, the format of the ad, the ad topic and whether the ad is funded by Google Ad Grants program. A link to the ad in the Google Ads Transparency Center is also provided. The removed_creative_stats table contains information about ads that served in the European Economic Area that Google removed: where and why they were removed and per-region information on when they served. The removed_creative_stats table also contains a link to the Google Ads Transparency Center for the removed ad. Data for both tables updates periodically and may be delayed from what appears on the Google Ads Transparency Center website. About BigQuery This data is hosted in Google BigQuery for users to easily query using SQL. Note that to use BigQuery, users must have a Google account and create a GCP project. This public dataset is included in BigQuery's 1TB/mo of free tier processing. Each user receives 1TB of free BigQuery processing every month, which can be used to run queries on this public dataset. Watch this short video to learn how to get started quickly using BigQuery to access public datasets. What is BigQuery . Download Dataset This public dataset is also hosted in Google Cloud Storage here and available free to use. Use this quick start guide to quickly learn how to access public datasets on Google Cloud Storage. We provide the raw data in JSON format, sharded across multiple files to support easier download of the large dataset. A README file which describes the data structure and our Terms of Service (also listed below) is included with the dataset. You can also download the results from a custom query. See here for options and instructions. Signed out users can download the full dataset by using the gCloud CLI. Follow the instructions here to download and install the gCloud CLI. To remove the login requirement, run "$ gcloud config set auth/disable_credentials True" To download the dataset, run "$ gcloud storage cp gs://ads-transparency-center/* . -R" This public dataset is hosted in Google BigQuery and is included in BigQuery's 1TB/mo of free tier processing. This means that each user receives 1TB of free BigQuery processing every month, which can be used to run queries on this public dataset. Watch this short video to learn how to get started quickly using BigQuery to access public datasets. What is BigQuery .

NEAR is a user-friendly and carbon-neutral blockchain, built from the ground up to be performant, secure, and infinitely scalable. In technical terms, NEAR is a layer one , sharded , proof-of-stake blockchain built with usability in mind. In simple terms, NEAR is blockchain for everyone. NEAR Crypto Public Dataset on Google Cloud This dataset for NEAR blockchain contains the source code for ingesting NEAR Protocol data stored as OLAP-formatted text on Google Cloud BigQuery. The source data is streamed and transformed into cleaned and enriched tables. Who is this for? Blockchain data indexing is for anyone who wants to make sense of blockchain data. This includes: Users: create queries to track NEAR assets,monitor transactions, or analyze onchain events at massive scale Researchers: use indexed for data science tasks including onchain activities, identifying trends, or feed AI/ML pipelines for predective analysis Startups: can use NEAR's indexed data for deep insights on user engagement, smart contract utilization, or insights across tokens and NFT adoption Benefits Near instant insights: Historical onchain data queried at scale Cost-effective:eliminate the need to store and process bulk NEAR protocol data; query as little or as much data as preferred Easy to use: no prior experience with blockchain technology required; bring a general knowledge of SQL to unlock insights. Extract to powerful collaborative services such as Google Connected Sheets , Looker Data Studio , or integrate to third party tools like Tableau