Emortalos/New7 / README.md
Emortalos's picture
|
download
raw
871 Bytes
---
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
```python
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")
```

Xet Storage Details

Size:
871 Bytes
·
Xet hash:
5a38a8461bd2d121e70014fa29ac7b2e72ca3e32a9b8f46990296e7c6ecb49a8

Xet efficiently stores files, intelligently splitting them into unique chunks and accelerating uploads and downloads. More info.