README.md

metadata

license: other
task_categories:
  - text-classification
language:
  - en
  - ru
  - hi
tags:
  - telegram
  - osint
  - parquet

Telegram

Parquet conversion of two Telegram user datasets.

Contents

• master/users/ — 146 parts, 72,601,073 rows
• master/telegram_users/ — 55 parts, 274,824,074 rows

Schema — master/users

column	type
user_id	TEXT
phone	TEXT
username	TEXT
first_name	TEXT
last_name	TEXT
email	TEXT

Schema — master/telegram_users

column	type
user_id	TEXT
phone	TEXT
username	TEXT
full_name	TEXT
source_file	TEXT

Usage

import duckdb
duckdb.sql("INSTALL httpfs; LOAD httpfs;")

duckdb.sql("SELECT * FROM 'https://huggingface.co/datasets/greyexploiter/Telegram/resolve/main/master/users/users_part0000.parquet' LIMIT 10")