twitter_personalization_locations
3 rows sorted by personalization_record_id descending
This data as json, CSV (advanced)
Link | personalization_record_id ▲ | location_id |
---|---|---|
1,3 | 1 1 | Izhevsk, Russia 3 |
1,2 | 1 1 | Moscow, Russia 2 |
1,1 | 1 1 | İstanbul, Türkiye 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE `twitter_personalization_locations` (`personalization_record_id` integer,`location_id` integer,PRIMARY KEY (`personalization_record_id`,`location_id`),CONSTRAINT `fk_twitter_personalization_locations_personalization_record` FOREIGN KEY (`personalization_record_id`) REFERENCES `twitter_personalization_records`(`id`),CONSTRAINT `fk_twitter_personalization_locations_location` FOREIGN KEY (`location_id`) REFERENCES `twitter_locations`(`id`));