telegram_messages

1 row

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ created_at updated_at deleted_at chat_id action actor actor_id address author contact_vcard date discard_reason duration duration_seconds edited file forwarded_from from from_id game_description game_link game_message_id game_title height inviter live_location_period_seconds media_type message_id mime_type performer photo place_name reply_to_message_id saved_from score self_destruct_period_seconds sticker_emoji thumbnail title type via_bot width text contact_information_first_name contact_information_last_name contact_information_phone_number location_information_latitude location_information_longitude poll_closed poll_question poll_total_voters
931882 2021-02-09 17:17:53.681673+03:00 2021-02-09 17:17:53.681673+03:00   Alexey 4369385118     0       2020-12-31 18:00:15+00:00   0 0       Alexey Shekhirin 4369385118     0   0   0   0         0   0 0       message   0 идеально.       0.0 0.0 0   0

Advanced export

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

CSV options: 

CREATE TABLE `telegram_messages` (`id` integer UNIQUE,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`chat_id` integer,`action` text,`actor` text,`actor_id` integer,`address` text,`author` text,`contact_vcard` text,`date` datetime,`discard_reason` text,`duration` integer,`duration_seconds` integer,`edited` text,`file` text,`forwarded_from` text,`from` text,`from_id` integer,`game_description` text,`game_link` text,`game_message_id` integer,`game_title` text,`height` integer,`inviter` text,`live_location_period_seconds` integer,`media_type` text,`message_id` integer,`mime_type` text,`performer` text,`photo` text,`place_name` text,`reply_to_message_id` integer,`saved_from` text,`score` integer,`self_destruct_period_seconds` integer,`sticker_emoji` text,`thumbnail` text,`title` text,`type` text,`via_bot` text,`width` integer,`text` text,`contact_information_first_name` text,`contact_information_last_name` text,`contact_information_phone_number` text,`location_information_latitude` real,`location_information_longitude` real,`poll_closed` numeric,`poll_question` text,`poll_total_voters` integer,PRIMARY KEY (`id`),CONSTRAINT `fk_telegram_messages_chat` FOREIGN KEY (`chat_id`) REFERENCES `telegram_chats`(`id`),CONSTRAINT `fk_telegram_chats_messages` FOREIGN KEY (`chat_id`) REFERENCES `telegram_chats`(`id`));
CREATE INDEX `idx_telegram_messages_deleted_at` ON `telegram_messages`(`deleted_at`);