1 row where targeting_type = "Device models" sorted by id descending

View and edit SQL

Suggested facets: created_at (date)

id ▲ created_at updated_at deleted_at targeting_type targeting_value
4 2021-02-22 22:06:08.825564+03:00 2021-02-22 22:06:08.825564+03:00   Device models iPhone XR

Advanced export

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

CSV options:

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`);