twitter_personalization_locations
3 rows sorted by location_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`));