4 rows

View and edit SQL

Suggested facets: updated_at (date), impression_time (date)

id ▼ created_at updated_at deleted_at device_info_id display_location promoted_tweet_id advertiser_id impression_time
1 2021-02-22 22:06:08.842931+03:00 2021-02-22 22:06:08.842931+03:00   1 1 TimelineHome 1324737045659553793 1324737045659553793 @aliexpress 1 2020-11-09 08:42:16+00:00
2 2021-02-22 22:06:08.842931+03:00 2021-02-22 22:06:08.842931+03:00   1 1 TimelineHome 1320729353219616769 1320729353219616769 6 2020-11-09 08:43:47+00:00
3 2021-02-22 22:06:08.842931+03:00 2021-02-22 22:06:08.842931+03:00   1 1 TimelineHome 1318971783182225414 1318971783182225414 18 2020-11-09 08:42:41+00:00
4 2021-02-22 22:06:08.842931+03:00 2021-02-22 22:06:08.842931+03:00   1 1 TimelineHome 1302968378961858560 1302968378961858560 30 2020-11-09 08:42:33+00:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE `twitter_ad_impressions` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`device_info_id` integer,`display_location` text,`promoted_tweet_id` integer,`advertiser_id` integer,`impression_time` datetime UNIQUE,PRIMARY KEY (`id`),CONSTRAINT `fk_twitter_ad_impressions_device_info` FOREIGN KEY (`device_info_id`) REFERENCES `twitter_device_infos`(`id`),CONSTRAINT `fk_twitter_ad_impressions_promoted_tweet` FOREIGN KEY (`promoted_tweet_id`) REFERENCES `twitter_tweets`(`id`),CONSTRAINT `fk_twitter_ad_impressions_advertiser` FOREIGN KEY (`advertiser_id`) REFERENCES `twitter_advertisers`(`id`));
CREATE INDEX `idx_twitter_ad_impressions_deleted_at` ON `twitter_ad_impressions`(`deleted_at`);