vk.com
Mar 22, 2011
840,514
Records
1
Files
Jul 10, 2026
Added
SQL database dump from VKontakte (VK), the Russian social network founded by Pavel Durov. The dump is dated 2011-03-22 and contains the 'members2' table with extensive user profile data including names, email addresses, hashed passwords, IP addresses, phone numbers, birthdates, location data, university information, and privacy settings. The source database is named 'durov_live', referencing Pavel Durov, the founder of VK.
Data found in this dataset
First nameLast nameUsernameAddressCityCountryGenderskipzip
Source files
Expand any file to inspect its column headers and the LLM's field-mapping reasoning, recorded during ingestion.
part_03.sql104 columns840,514 rows
File structure
| Source column | Mapped field | Confidence | LLM assessment |
|---|---|---|---|
| 0 | skip | high | internal auto-increment ID column |
| 1 | firstName | high | column named 'first_name', contains first names in Cyrillic and Latin characters |
| 2 | skip | high | column named 'nick_name', appears to be empty/unused in sample data |
| 3 | lastName | high | column named 'last_name', contains surnames in Cyrillic and Latin characters |
| 4 | skip | high | column named 'maiden_name', appears empty in sample data; generational context unclear |
| 5 | skip | high | column named 'email', values contain @ symbol and email domains |
| 6 | password | high | column named 'password', values appear to be MD5 hashes |
| 7 | skip | high | column named 'password2', appears to be alternative/backup password hash field, empty in samples |
| 8 | skip | high | column named 'ip', contains numeric IP addresses converted to integers |
| 9 | skip | high | column named 'joined', contains Unix timestamps (join dates) |
| 10 | skip | high | internal field, numeric flag |
| 11 | skip | high | internal field, numeric port indicator |
| 12 | skip | high | internal field, user_agent reference ID |
| 13 | skip | high | internal field, is_banned flag |
| 14 | skip | high | birthday day component (part of DOB, but fragmented; combined with month/year fields for dob) |
| 15 | skip | high | birthday month component (part of DOB, but fragmented) |
| 16 | skip | high | birthday year component (part of DOB, but fragmented) |
| 17 | skip | high | birthday visibility privacy setting, not PII itself |
| 18 | gender | high | column named 'sex', numeric codes for gender/sex |
| 19 | skip | high | internal field, 'cute' rating flag |
| 20 | skip | high | internal field, user rating |
| 21 | skip | high | internal field, bonus_rate |
| 22 | skip | high | internal field, network identifier |
| 23 | skip | high | internal field, partner user ID |
| 24 | skip | high | internal field, additional_edu flag |
| 25 | skip | high | internal field, time_offset setting |
| 26 | skip | high | e_privacy setting, privacy flag not PII |
| 27 | skip | high | m_privacy setting, privacy flag not PII |
| 28 | skip | high | h_privacy setting, privacy flag not PII |
| 29 | skip | high | i_privacy setting, privacy flag not PII |
| 30 | skip | high | a_privacy setting, privacy flag not PII |
| 31 | skip | high | pm_privacy setting, privacy flag not PII |
| 32 | skip | high | wall_privacy setting, privacy flag not PII |
| 33 | skip | high | notes_privacy setting, privacy flag not PII |
| 34 | skip | high | event_privacy setting, privacy flag not PII |
| 35 | skip | high | friends_privacy setting, privacy flag not PII |
| 36 | skip | high | profile_privacy setting, privacy flag not PII |
| 37 | skip | high | photo_privacy setting, privacy flag not PII |
| 38 | skip | high | pm_notify setting, notification flag not PII |
| 39 | skip | high | tag_notify setting, notification flag not PII |
| 40 | skip | high | friend_notify setting, notification flag not PII |
| 41 | skip | high | wall_notify setting, notification flag not PII |
| 42 | skip | high | photo_notify setting, notification flag not PII |
| 43 | skip | high | notify_mail setting, notification flag not PII |
| 44 | skip | high | group_notify setting, notification flag not PII |
| 45 | skip | high | contest_notify setting, notification flag not PII |
| 46 | skip | high | internal field, server identifier |
| 47 | skip | high | internal field, server2 identifier |
| 48 | skip | high | internal field, upload_server identifier |
| 49 | skip | high | internal field, language code |
| 50 | skip | high | internal field, lang_str language string |
| 51 | skip | high | internal field, photo identifier/path |
| 52 | skip | high | internal field, photo_ext file extension |
| 53 | skip | high | internal field, status flag |
| 54 | skip | high | internal field, site_id |
| 55 | skip | high | internal field, site_list |
| 56 | city | high | column named 'home_town', contains city names |
| 57 | skip | high | internal field, political view code |
| 58 | skip | high | internal field, religion text |
| 59 | skip | high | column named 'cmail', appears to be contact/alternate email address |
| 60 | skip | high | column named 'mobile_phone', contains phone numbers |
| 61 | skip | high | column named 'home_phone', contains phone numbers |
| 62 | username | high | column named 'icq', ICQ is a social messaging platform handle per exclusion rules |
| 63 | city | high | column named 'city', contains city names |
| 64 | address1 | high | column named 'address', contains street address data |
| 65 | zip | high | column named 'postal_index', contains postal/zip codes |
| 66 | skip | high | internal field, website URL |
| 67 | skip | high | internal field, university ID |
| 68 | skip | high | internal field, university_name educational institution |
| 69 | skip | high | internal field, faculty ID |
| 70 | skip | high | internal field, faculty_name |
| 71 | skip | high | internal field, chair department name |
| 72 | skip | high | internal field, graduation year |
| 73 | skip | high | internal field, new_messages count |
| 74 | skip | high | internal field, religion_id |
| 75 | skip | high | internal field, friends count |
| 76 | skip | high | internal field, albums count |
| 77 | skip | high | internal field, new_photos count |
| 78 | skip | high | internal field, fave_word user's favorite word |
| 79 | skip | high | internal field, uni_city university city ID |
| 80 | skip | high | internal field, who_invited referrer user ID |
| 81 | skip | high | internal field, edu_form education form code |
| 82 | skip | high | internal field, edu_status education status code |
| 83 | skip | high | timestamp field 'logged', last login Unix timestamp |
| 84 | skip | high | internal field, chair_id department ID |
| 85 | country | high | column named 'uni_country', country code for university location |
| 86 | skip | high | internal field, groups count |
| 87 | skip | high | internal field, group_invitations count |
| 88 | skip | high | internal field, schools educational history |
| 89 | skip | high | internal field, work employment history |
| 90 | skip | high | internal field, forum forum username/handle |
| 91 | skip | high | internal field, forum_nick forum nickname |
| 92 | skip | high | internal field, blog_posts count |
| 93 | username | high | column named 'domain', VK profile domain/username identifier |
| 94 | skip | high | internal field, captchas_passed count |
| 95 | skip | high | internal field, captchas_to_pass count |
| 96 | skip | high | column named 'reg_phone', registration phone number |
| 97 | skip | high | internal field, reg_phone_status phone verification status |
| 98 | skip | high | internal field, reg_step registration step |
| 99 | skip | high | internal field, services_bits1 service flags |
| 100 | skip | high | internal field, services_bits2 service flags |
| 101 | skip | high | internal field, services_bits3 service flags |
| 102 | skip | high | internal field, services_bits4 service flags |
| 103 | skip | high | internal field, profile_type account type flag |
Notes: VKontakte 2011 breach: members2 table from durov_live database. Birthday fields (bday_day, bday_month, bday_year) are fragmented and do not form a complete DOB in standard format; mapped as skip. Maiden_name column appears unused in samples. Multiple privacy and notification settings are flags, not PII. Phone fields include mobile_phone, home_phone, and reg_phone. Email addresses include primary email, cmail (contact email). Address data includes city (home_town and city columns), address (street), postal_index (zip). Domain column serves as VK profile username/identifier. Gender encoded numerically in sex column.