twitter_targeting_criteria
10 rows where targeting_type = "Keywords" sorted by created_at
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
| id | created_at ▼ | updated_at | deleted_at | targeting_type | targeting_value |
|---|---|---|---|---|---|
| 10 | 2021-02-22 22:06:08.834264+03:00 | 2021-02-22 22:06:08.834264+03:00 | Keywords | finance | |
| 11 | 2021-02-22 22:06:08.834732+03:00 | 2021-02-22 22:06:08.834732+03:00 | Keywords | #investor | |
| 12 | 2021-02-22 22:06:08.835358+03:00 | 2021-02-22 22:06:08.835358+03:00 | Keywords | investors | |
| 13 | 2021-02-22 22:06:08.835704+03:00 | 2021-02-22 22:06:08.835704+03:00 | Keywords | investment | |
| 14 | 2021-02-22 22:06:08.836422+03:00 | 2021-02-22 22:06:08.836422+03:00 | Keywords | #investment | |
| 15 | 2021-02-22 22:06:08.837671+03:00 | 2021-02-22 22:06:08.837671+03:00 | Keywords | #finance | |
| 16 | 2021-02-22 22:06:08.838834+03:00 | 2021-02-22 22:06:08.838834+03:00 | Keywords | investments | |
| 17 | 2021-02-22 22:06:08.839561+03:00 | 2021-02-22 22:06:08.839561+03:00 | Keywords | #investors | |
| 18 | 2021-02-22 22:06:08.839811+03:00 | 2021-02-22 22:06:08.839811+03:00 | Keywords | banking | |
| 19 | 2021-02-22 22:06:08.840299+03:00 | 2021-02-22 22:06:08.840299+03:00 | Keywords | #investments |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE `twitter_targeting_criteria` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`targeting_type` text,`targeting_value` text,PRIMARY KEY (`id`)); CREATE UNIQUE INDEX `twitter_targeting_criterion_key` ON `twitter_targeting_criteria`(`targeting_type`,`targeting_value`); CREATE INDEX `idx_twitter_targeting_criteria_deleted_at` ON `twitter_targeting_criteria`(`deleted_at`);