• XSS.stack #1 – первый литературный журнал от юзеров форума

CSV All data on people living in the US(250,807,711 row)

Отслеживать

zhclgmfz

CD-диск
Пользователь
Регистрация
29.04.2020
Сообщения
19
Реакции
214
250,807,711 row
All data on people living in the US
magnet url
Скрытый контент для зарегистрированных пользователей.

magnet:?xt=urn:btih:
(delete this line)
DB37E82521500BEE7570F97479225D825B0598DB&dn=250807711.7z&tr=udp%3a%2f%2ftracker.openbittorrent.com%3a80%2fannounce&tr=udp%3a%2f%2ftracker.opentrackr.org%3a1337%2fannounce&ws=udp%3a%2f%2fpublic.popcorn-tracker.org%3a6969%2fannounce&ws=http%3a%2f%2f104.28.1.30%3a8080%2fannounce&ws=http%3a%2f%2f104.28.16.69%2fannounce&ws=http%3a%2f%2f107.150.14.110%3a6969%2fannounce&ws=http%3a%2f%2f109.121.134.121%3a1337%2fannounce&ws=http%3a%2f%2f114.55.113.60%3a6969%2fannounce&ws=http%3a%2f%2f125.227.35.196%3a6969%2fannounce&ws=http%3a%2f%2f128.199.70.66%3a5944%2fannounce&ws=http%3a%2f%2f157.7.202.64%3a8080%2fannounce&ws=http%3a%2f%2f158.69.146.212%3a7777%2fannounce&ws=http%3a%2f%2f173.254.204.71%3a1096%2fannounce&ws=http%3a%2f%2f178.175.143.27%2fannounce&ws=http%3a%2f%2f178.33.73.26%3a2710%2fannounce&ws=http%3a%2f%2f182.176.139.129%3a6969%2fannounce&ws=http%3a%2f%2f185.5.97.139%3a8089%2fannounce&ws=http%3a%2f%2f188.165.253.109%3a1337%2fannounce&ws=http%3a%2f%2f194.106.216.222%2fannounce&ws=http%3a%2f%2f195.123.209.37%3a1337%2fannounce&ws=http%3a%2f%2f210.244.71.25%3a6969%2fannounce&ws=http%3a%2f%2f210.244.71.26%3a6969%2fannounce&ws=http%3a%2f%2f213.159.215.198%3a6970%2fannounce&ws=http%3a%2f%2f213.163.67.56%3a1337%2fannounce&ws=http%3a%2f%2f37.19.5.139%3a6969%2fannounce&ws=http%3a%2f%2f37.19.5.155%3a6881%2fannounce&ws=http%3a%2f%2f46.4.109.148%3a6969%2fannounce&ws=http%3a%2f%2f5.79.249.77%3a6969%2fannounce&ws=http%3a%2f%2f5.79.83.193%3a2710%2fannounce&ws=http%3a%2f%2f51.254.244.161%3a6969%2fannounce&ws=http%3a%2f%2f59.36.96.77%3a6969%2fannounce&ws=http%3a%2f%2f74.82.52.209%3a6969%2fannounce&ws=http%3a%2f%2f80.246.243.18%3a6969%2fannounce&ws=http%3a%2f%2f81.200.2.231%2fannounce&ws=http%3a%2f%2f85.17.19.180%2fannounce&ws=http%3a%2f%2f87.248.186.252%3a8080%2fannounce&ws=http%3a%2f%2f87.253.152.137%2fannounce&ws=http%3a%2f%2f91.216.110.47%2fannounce&ws=http%3a%2f%2f91.217.91.21%3a3218%2fannounce&ws=http%3a%2f%2f91.218.230.81%3a6969%2fannounce&ws=http%3a%2f%2f93.92.64.5%2fannounce&ws=http%3a%2f%2fatrack.pow7.com%2
https://mega.nz/file/M0RH1KjT#BFruqz5nj-qPeelYg45Fel4eBkGfAtnKNQ1DxI07nso
 
Последнее редактирование:
xss8080 сказал(а):
数据包含哪些信息可否截取个图，例如姓名电话地址之类的
Код: 
H_ID,ID,First_Name_01,alphafirstname_sort,Phonetic_First_Name,Middle_Name_01,Last_Name_01,alphalastname_sort,Phonetic_Last_Name,Address,alphaaddress_sort,City,CITY_PHRASE,alphacity_sort,Cities,State,alphastate_sort,ZIP,ZIP4,Carrier_Route,Delivery_Point,Mail_Score_Code,Geo_Level_Code,Latitude,Longitude,Time_Zone_Code,County_Code,County_Description,CBSA_Code,CBSA_Description,Scrubbed_Phoneable_Flag,Ind_Gender_Code,Ind_Date_Of_Birth_Year,Ind_Age,Ind_Occupation_Code,Ind_Household_Rank_Code,Ind_Ethnic_Code,Ind_Political_Party_Code,Home_Value_Code,Home_Value_Description,Home_Median_Value_Code,Home_Median_Value_Description,Home_Owner_Renter_Code,Home_Purchase_Date,Home_Purchase_Year,Length_Of_Residence_Code,Home_Built_Year,Home_Built_Year_Code,Home_Built_Year_Description,Home_Square_Footage,Home_Square_Footage_Code,Home_Dwelling_Type_Code,Median_Income_Code,Median_Income_Description,Income_Code,Income_Description,NetWorth_Code,Credit_Capacity,Credit_Capacity_Code,Credit_Capacity_Description,Donor_Capacity_Code,Number_Children_Code,Children_Present_Flag,Marital_Status_Code,Delivery_Point_CheckDigit,Address_Number,Street_Name,Street_Suffix,State_City,Address_ID,PO_Flag,Mailable_Flag,Location_Unique_Flag,Most_Recent_Home_Purchase_Date_Flag,Number_of_Bedrooms,Number_of_Bathrooms,ProductionDate,Ind_Age_Code,Lat_Long,Geo_Lat_Long,Marketing,Mailable,Phoneable,Mailable_Phoneable,ZIP9,Zip11,Zip4Exists,Address_Master,LS_Green_Living_Flag,_version_,Lat_Long_0_coordinate,Lat_Long_1_coordinate,Email_Present_Flag,Email,CC_User_Flag,Credit_Card_Mail_Order_Buyers,CC_Bank_Flag,CC_Gas_Dept_Retail_Flag,CC_Unknown_Flag,CC_Premium_Flag,CC_Upscale_Dept_Flag,Charitable_Flag,Donor,Political_Flag,Political_Affiliation_Donor,Hobbies_Auto_Work_Flag,Hobby_Interest,Home_Furnishings_Decorating_Flag,Home_Improvement,Mail_Order_Buyer_Flag,Mail_Order_Responder_Flag,PC_Owner_Flag,Computers_Electronics,Consumer_Electronics_Flag,Email_01_MD5,CellPhone,Ind_Date_Of_Birth_Month,Secondary_Name,Secondary_Number,Mail_Order_Donor_Flag,Veteran_Present_HH_Flag,Ent_Arts_Flag,Arts_History_Science,Ent_Sweepstakes_Contests_Flag,Investing_Finance,Reading_General_Flag,Reading,Reading_Magazines_Flag,Reading_Audio_Books_Flag,Investments_Personal_Flag,Investments_Stocks_Bonds_Flag,Cooking_General_Flag,Cooking_Food,Cooking_Gourmet_Flag,Collectibles_General_Flag,Collectibles_And_Antiques,Collectibles_Arts_Flag,Collectibles_Antiques_Flag,Hobbies_Sewing_Knitting_Needlework_Flag,Hobbies_Gardening_Flag,Beauty_Cosmetics_Flag,Beauty_Fashion,LS_Highbrow_Living_Flag,LS_Common_Living_Flag,Family_Religion_Politics,LS_Broader_Living_Flag,Area_Code,Phone,Home_Property_Type_Code_02,Home_Equity_Available_Code,Home_Equity_Available_Description,Foods_Natural_Flag,Travel_Domestic_Flag,Travel,Self_Exercise_Running_Jogging_Flag,Health_and_Fitness,Self_Exercise_Walking_Flag,Self_Health_Medical_Flag,Self_Dieting_Weight_Loss_Flag,Hobbies_Crafts_Flag,Outdoor_Fishing_Flag,Outdoor_Enthusiast,Outdoor_Camping_Hiking_Flag,Outdoor_Hunting_Shooting_Flag,Spectator_Sports_Football_Flag,Sports,Spectator_Sports_Basketball_Flag,Cat_Owner_Flag,Animals_Pets,Dog_Owner_Flag,DNC_Flag,City_2,State_City_2,Childrens_Interests_Flag,Animal_Welfare_Flag,Religious_Flag,Reading_Religious_Inspirational_Flag,Travel_RV_Flag,Travel_Cruises_Flag,Music_Listener_Flag,Movie_Music,Hobbies_Photography_Flag,Sports_Golf_Flag,Environmental_Issues_Flag,Religious_Inspirational_Flag,Vehicle_Owned_Code,Other_Pet_Owner_Flag,LS_Home_Living_Flag,LS_Upscale_Living_Flag,Arts_Cultural_Flag,Childrens_Flag,Health_Flag,Christian_Family_Flag,Ent_Theater_Performing_Arts_Flag,Reading_Science_Fiction_Flag,Music_Player_Flag,Self_Exercise_Aerobic_Flag,Self_Improvement_Flag,Career_Self_Improvement,Self_Career_Improvement_Flag,Collectibles_Coins_Flag,Collector_Avid_Flag,Hobbies_Woodworking_Flag,Spectator_Sports_Baseball_Flag,Spectator_Sports_TV_Sports_Flag,Parenting_Flag,LS_Professional_Living_Flag,Email_02,Email_03,Email_02_MD5,Email_03_MD5,Investments_Real_Estate_Flag,Music_Home_Stereo_Flag,Hobbies_History_Military_Flag,Current_Affairs_Politics_Flag,Recently_Moved_Year,Recently_Moved_Month,Pre_Direction,Spectator_Sports_Hockey_Flag,Smoking_Tobacco_Flag,Ailments,Food_Wines_Flag,Travel_International_Flag,Outdoor_Scuba_Diving_Flag,Sports_Collectibles_Memorabilia_Flag,Music_Collector_Flag,Hobbies_Science_Space_Flag,Outdoor_Boating_Sailing_Flag,Political_Conservative_Flag,Reading_Financial_Newsletter_Flag,Investments_Foreign_Flag,Collectibles_Stamps_Flag,Grandchildren_Flag,Veterans_Flag,Hobbies_Games_Board_Puzzles_Flag,Computer_And_Video_Games_Puzzles,Games_Video_Games_Flag,CC_Travel_Entertainment_Flag,Self_Education_Online_Flag,Spectator_Sports_NASCAR_Flag,Sports_Motorcycling_Flag,Recently_Moved_Flag,LS_Sporty_Living_Flag,Post_Direction,Ent_Gaming_Casino_Flag,Home_Improvement_DIY_Flag,Money_Seekers_Flag,TV_Satellite_Dish_Flag,Home_Loan_To_Value_Code,Hobbies_Aviation_Flag,Movie_Collector_Flag,LS_DIY_Living_Flag,Walk_Sequence,International_Aid_Flag,Spectator_Sports_Racing_Flag,Veteran_Present_Ind_Flag,Sports_Equestrian_Flag,Email_04,Email_05,Email_04_MD5,Email_05_MD5,Sports_Tennis_Flag,Sports_Skiing_Flag,Environment_Wildlife_Flag,Truck_Owner_Flag,Motor_Vehicles,Games_Computer_Games_Flag,Political_Liberal_Flag,Ailment_Diabetic_Flag,New_Home_Owner_Flag,Ailment_Orthopedic_Flag,Ailment_Arthritis_Flag,Spectator_Sports_Soccer_Flag,RV_Owner_Flag,Boat_Owner_Flag,Motorcycle_Owner_Flag,Ailment_Allergy_Flag,Ailment_Senior_Flag,Hobbies_House_Plant_Flag,Ailment_Disabled_Flag
 
methaqualon сказал(а):
thank for that
could you at least suggest the relevance of the database? maybe this year or 2019
There are 59 Million unique emails in this. All data on people living in the US.
Thats all of i know
 
On other places posts some suggest that this could be the SolarWinds (NSA) Database.
There was 2 threads on RF seems related but both removed (nothing surprising ...).
On first thread the number of files on the archive are the same, (1255), and almost size and number of records (on thread 230mil but here 250mil)

see archive.org pages

230mil SolarWinds Database (NSA) DEC 2020 | RaidForums

I was given this by a friend on here. Nice guy, has a large cock. Anyway, here's a sample of the data: Spoiler978494031,978494031,Current,Current,Current,R...
web.archive.org

and

SolarWinds DB Leak | RaidForums

Here's the solarwind db leak Data leaked: Full names Home Addresses Income/Salary House cost Amount of children Phone Numbers Email Addresses (Some people...
web.archive.org

If true, this archive is not "one advertising company", this is THE breach that everybody talked about ...? :rolleyes:
With pleasure to read your comments on it ...
 
Код с оформлением (BB-коды): 
magnet:?xt=urn:btih:DB37E82521500BEE7570F97479225D825B0598DB&dn=250807711.7z&tr=udp://tracker.cyberia.is:6969/announce&tr=udp://tracker.port443.xyz:6969/announce&tr=http://tracker3.itzmx.com:6961/announce&tr=udp://tracker.moeking.me:6969/announce&tr=http://vps02.net.orel.ru:80/announce&tr=http://tracker.openzim.org:80/announce&tr=udp://tracker.skynetcloud.tk:6969/announce&tr=https://1.tracker.eu.org:443/announce&tr=https://3.tracker.eu.org:443/announce&tr=http://re-tracker.uz:80/announce&tr=https://tracker.parrotsec.org:443/announce&tr=udp://explodie.org:6969/announce&tr=udp://tracker.filemail.com:6969/announce&tr=udp://tracker.nyaa.uk:6969/announce&tr=udp://retracker.netbynet.ru:2710/announce&tr=http://tracker.gbitt.info:80/announce&tr=http://tracker2.dler.org:80/announce
 
Скрытый контент для зарегистрированных пользователей.
Свой вариант. 51 файл, один файл - один штат. Кодировка UTF-8, разделитель поля - запятая, конец строки CRLF (Windows).
Суммарный размер 123 Гб (в сжатом 7z - 10 Гб). Удалены дублирующиеся поля и кое-что по мелочи удалил.
Отсортировано по алфавиту в порядке - город, улица, дом, апартамент, фамилия.
Список полей "First_Name,Middle_Name,Last_Name,Age,Gender,Ethnic_Code,Date_Of_Birth_Month,Date_Of_Birth_Year,Address,City,County,State,ZIP,Lat_Long,Phone,CellPhone,Email,Email_2,Email_3,Email_4,Email_5,Ind_Occupation_Code,Marriedarital_Singletatus,Number_Children_Code,Home_Ownerwner_Renterenter,Home_Dwelling_Type,Home_Built_Year,Home_Value,Home_Purchase_Date,Home_Square_Footage,Credit_Capacity,Income_Description,Vehicle_Owned_Code,Ailments,Animals_Pets,Arts_History_Science,Beauty_Fashion,Career_Self_Improvement,Collectibles_And_Antiques,Computer_And_Video_Games_Puzzles,Computers_Electronics,Cooking_Food,Credit_Card_Mail_Order_Buyers,Donor,Family_Religion_Politics,Health_and_Fitness,Hobby_Interest,Home_Improvement,Investing_Finance,Motor_Vehicles,Movie_Music,Outdoor_Enthusiast,Political_Affiliation_Donor,Reading,Sports,Travel"
Пароль для всех файлов местный (в нижнем регистре) - xss.pro
Заметил 2 ошибки в названии полей Marriedarital_Singletatus - это marital_status, и в Home_Ownerwner_Renterenter - это home_owner_renter.
Но переделывать смысла нет, посколько уже залито на anonfiles
AK, AL, AR, AZ, CA, CO, CT, DC, DE, FL, GA, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MI, MN, MO, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VA, VT, WA, WI, WV, WY, Одним архивом все файлы.

В течение месяца использовал более сотни скриптов, было очень интересно
 
Последнее редактирование:
Приведу скрипт как извлечь или переопределить столбцы на python под macos
import csv

with open('input.csv', 'r') as infile, open('output.csv', 'a') as outfile:
# output dict needs a list for new column ordering
fieldnames = ['мое первое поле', 'мое второе поле']
writer = csv.DictWriter(outfile, fieldnames=fieldnames, extrasaction='ignore')
# reorder the header first
writer.writeheader()
for row in csv.DictReader(infile):
# writes the reordered rows to the new file
writer.writerow(row)

Вставляйте все поля (хоть все) или просто измените их порядок
 
Последнее редактирование:
admin


Напишите ответ...
  • Вставить:
Прикрепить файлы
Верх