twitter_screen_name_changes

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date), changed_at (date)

id ▼ created_at updated_at deleted_at changed_at changed_from changed_to
1 2021-02-22 22:06:08.817289+03:00 2021-02-22 22:06:08.817289+03:00   2015-09-08 14:37:51+00:00 shamoiseva sevazhidkov

Advanced export

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

CSV options: 

CREATE TABLE `twitter_screen_name_changes` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`account_id` integer,`changed_at` datetime,`changed_from` text,`changed_to` text,PRIMARY KEY (`id`),CONSTRAINT `fk_twitter_accounts_screen_name_changes` FOREIGN KEY (`account_id`) REFERENCES `twitter_accounts`(`id`));
CREATE UNIQUE INDEX `twitter_screen_name_changes_key` ON `twitter_screen_name_changes`(`account_id`,`changed_at`,`changed_from`,`changed_to`);
CREATE INDEX `idx_twitter_screen_name_changes_deleted_at` ON `twitter_screen_name_changes`(`deleted_at`);