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

SQL Linkedin 2021 full leak

barzifurze

RAID-массив
Пользователь
Регистрация
02.06.2020
Сообщения
94
Реакции
461
Repost

LINKEDIN 2021 FULL LEAK SQL

I just republished the content

Down File Telegram
 
Пожалуйста, обратите внимание, что пользователь заблокирован
прямой линк здесь

 
пароли или хеши паролей в сливе есть?
без пароля.
 
Каждый файл - отдельный архив с gz расширением, открывается в любом архиваторе.
После разархивации будет текстовый файл без расширения, я лично добавлял расширение .json к имени файла
и просматривал в текстовом редакторе, или импортировал в mongodb.
 
А что в базе? Какой формат?
Каждая строка - обьект JSON - спарсенный профиль с Линкедина.
{"id":"P3gdbqjnY9l6YJYYq9C-wQ_0000","full_name":"daniel morris","first_name":"daniel","middle_initial":null,"middle_name":null,"last_name":"morris","gender":"male","birth_year":null,"birth_date":null,"linkedin_url":"linkedin.com/in/danieljosephmorris","linkedin_username":"danieljosephmorris","linkedin_id":"176802030","facebook_url":null,"facebook_username":null,"facebook_id":null,"twitter_url":null,"twitter_username":null,"github_url":null,"github_username":null,"work_email":null,"mobile_phone":null,"industry":"law practice","job_title":"founder and sole director","job_title_role":null,"job_title_sub_role":null,"job_title_levels":["director","owner"],"job_company_id":null,"job_company_name":null,"job_company_website":null,"job_company_size":null,"job_company_founded":null,"job_company_industry":null,"job_company_linkedin_url":null,"job_company_linkedin_id":null,"job_company_facebook_url":null,"job_company_twitter_url":null,"job_company_location_name":null,"job_company_location_locality":null,"job_company_location_metro":null,"job_company_location_region":null,"job_company_location_geo":null,"job_company_location_street_address":null,"job_company_location_address_line_2":null,"job_company_location_postal_code":null,"job_company_location_country":null,"job_company_location_continent":null,"job_last_updated":"2020-09-01","job_start_date":null,"job_summary":null,"location_name":"perth, western australia, australia","location_locality":"perth","location_metro":null,"location_region":"western australia","location_country":"australia","location_continent":"oceania","location_street_address":null,"location_address_line_2":null,"location_postal_code":null,"location_geo":"-31.95,115.86","location_last_updated":"2020-03-01","linkedin_connections":1365,"inferred_salary":"150,000-250,000","inferred_years_experience":17,"summary":"January 2015 – Present (1 year 11 months)Perth, Australia .... who are entitled, under the Builders' Registration Act 1939 (now repealed), to be compensated for...","phone_numbers":[],"emails":[{"address":"dmorris@civilcontractors.com","type":"professional"}],"interests":["social services"],"skills":["litigation","commercial litigation","civil litigation","legal writing","legal research","dispute resolution","trials","construction law","alternative dispute resolution","legal advice","criminal law","debt settlement","trusts","property law","consumer credit law","forensic analysis","corporate law","dispute","mediation","legal assistance","corporate governance","building and construction law","trade regulation","leases","appeals","courts","arbitration","civil/commercial litigation","court advocacy","trials and appeals","professional regulation and discipline","competition and consumer law","trade practices law","property and trusts","commercial leases","debt recovery","commercial contracts","fiduciary breaches","corporate insolvency","franchising advice and agreements","successful trial counsel in anderson v mcpherson [2012] wasc 19","successful trial counsel in fitzpatrick v garvey [2012] wadc 42","successful trial counsel in mania v han"],"location_names":["san francisco, california, united states","perth, western australia, australia"],"regions":["california, united states","western australia, australia"],"countries":["united states","australia"],"street_addresses":[],"experience":[{"company":null,"start_date":null,"end_date":null,"title":{"name":"founder and sole director","role":null,"sub_role":null,"levels":["director","owner"]},"location_names":[],"is_primary":true,"summary":null},{"company":{"name":"department of mines, industry regulation and safety, western australia","size":"1001-5000","id":"dmirs","founded":null,"industry":"government administration","location":{"name":"east perth, western australia, australia","locality":"east perth","region":"western australia","metro":null,"country":"australia","continent":"oceania","street_address":"100 plain street","address_line_2":null,"postal_code":null,"geo":"-31.95,115.86"},"linkedin_url":"linkedin.com/company/dmirs","linkedin_id":"347812","facebook_url":null,"twitter_url":null,"website":"dmirs.wa.gov.au"},"start_date":"2018-12","end_date":"2018-12","title":{"name":"presenter, contractual time bars and variations","role":null,"sub_role":null,"levels":[]},"location_names":["perth, western australia, australia"],"is_primary":false,"summary":"This is the first in a three-part series initially presented to construction industry stakeholders in the first half of 2018. The point is to increase awareness amongst construction contractors, of how important it is to give timely notice of delay events and variations to contractual work scope, even where the notified event is obviously known to, or even caused by, the other party; and to make timely extension of time and contract price variation claims. The presentation focused on practical ways for contractors to systematise the communication of notices and claims, to try and minimise both the cost of compliance and the risk of non-compliance."},{"company":{"name":"civil contractors federation wa","size":"11-50","id":"civil-contractors-federation-wa","founded":null,"industry":"civil engineering","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/civil-contractors-federation-wa","linkedin_id":"10694395","facebook_url":null,"twitter_url":null,"website":"ccfwa.com.au"},"start_date":"2017-05","end_date":"2017-05","title":{"name":"associate member and workshop presenter","role":null,"sub_role":null,"levels":[]},"location_names":[],"is_primary":false,"summary":"Presented a business improvement workshop on construction contract variations."},{"company":{"name":"society of construction law australia","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":[],"end_date":"2014-05","start_date":"2014-05","title":{"name":"winner, brooking prize, 2014","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Reproduced from SOCLA website): The Society offers the Brooking Prize annually for the best essay submitted in the field of construction law. It is named after The Hon Robert Brooking AO QC in recognition of his Honour’s pioneering contribution to the study and practice of construction law in Australia."},{"company":{"name":"havilah legal","size":"1-10","id":"havilah-legal","founded":"1998","industry":"law practice","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/havilah-legal","linkedin_id":"3599988","facebook_url":"facebook.com/havilahlegal","twitter_url":"twitter.com/havilahlegalau","website":"havilahlegal.com.au"},"location_names":[],"end_date":"2013-03","start_date":"2007-12","title":{"name":"associate","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Developed a growing list of dedicated expansion clients and recurrent referral sources in relation to commercial and home building contract matters, appeared as trial counsel in civil matters and summary prosecutions, independently conducted civil and criminal matters as Solicitor and Counsel, from first instructions to trial/appeal, gave advice and opinions to clients and in-house on complex matters of law and evidence, monitored and updated office resources (precedents, research material, rules of court, practice directions, notices to practitioners) and circulated updates to professional colleagues, published articles in newsletter, on website and in Brief magazine, delivered presentations in-house and in Legalwise seminar on Litigation Skills (see seminar paper \"linked\" on company website), assisted colleagues with professional development, assisted with marketing/branding initiatives."},{"company":{"name":"society of construction lawyers australia","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":[],"end_date":"2013","start_date":"2012","title":{"name":"member","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":null},{"company":{"name":"the law society of western australia","size":"5001-10000","id":"the-law-society-of-western-australia","founded":"1927","industry":"legal services","location":{"name":"perth, western australia, australia","locality":"perth","region":"western australia","metro":null,"country":"australia","continent":"oceania","street_address":"160 st georges terrace","address_line_2":null,"postal_code":null,"geo":"-31.95,115.86"},"linkedin_url":"linkedin.com/company/the-law-society-of-western-australia","linkedin_id":"2817073","facebook_url":"facebook.com/ylc.wa","twitter_url":null,"website":"lawsocietywa.asn.au"},"location_names":[],"end_date":"2013","start_date":"2003","title":{"name":"member","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":null},{"company":{"name":"football west","size":"11-50","id":"football-west","founded":null,"industry":"sports","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/football-west","linkedin_id":"1156995","facebook_url":"facebook.com/footballwest","twitter_url":"twitter.com/footballwest","website":"footballwest.com.au"},"location_names":[],"end_date":"2012","start_date":"2010","title":{"name":"disciplinary and grievance tribunal","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Sat as a judicial member and later as chairman"},{"company":{"name":"society of construction law australia","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["perth, western australia, australia"],"end_date":"2017","start_date":"2017-10","title":{"name":"presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":null},{"company":{"name":"australian institute of architects","size":"51-200","id":"australian-institute-of-architects","founded":"1930","industry":"architecture & planning","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/australian-institute-of-architects","linkedin_id":"1117712","facebook_url":"facebook.com/ausinsarchitects","twitter_url":"twitter.com/ausinsarchitect","website":"architecture.com.au"},"location_names":["perth, western australia, australia"],"end_date":"2018-03","start_date":"2018-03","title":{"name":"presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"BIM: reduce risk, not reputation\"."},{"company":{"name":"international society of primerus law firms","size":"11-50","id":"international-society-of-primerus-law-firms","founded":"1992","industry":"law practice","location":{"name":"grand rapids, michigan, united states","locality":"grand rapids","region":"michigan","metro":"grand rapids, michigan","country":"united states","continent":"north america","street_address":"171 monroe northwest","address_line_2":"suite 750","postal_code":"49503","geo":"42.96,-85.66"},"linkedin_url":"linkedin.com/company/international-society-of-primerus-law-firms","linkedin_id":"2315107","facebook_url":null,"twitter_url":"twitter.com/primerus1992","website":"primerus.com"},"location_names":["perth, western australia, australia"],"end_date":"2017-12","start_date":"2017-12","title":{"name":"webinar presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Using Project Bank Accounts and Trust Structures to Protect Downstream Project Payments"},{"company":{"name":"the chartered institute of building (ciob)","size":"51-200","id":"the-chartered-institute-of-building-ciob","founded":"1834","industry":"construction","location":{"name":"berks, west berkshire, united kingdom","locality":"berks","region":"west berkshire","metro":null,"country":"united kingdom","continent":"europe","street_address":"1 arlington square","address_line_2":null,"postal_code":null,"geo":"51.5,-1.25"},"linkedin_url":"linkedin.com/company/the-chartered-institute-of-building-ciob","linkedin_id":"341257","facebook_url":"facebook.com/theciob","twitter_url":"twitter.com/theciob","website":"ciob.org"},"location_names":["perth, western australia, australia"],"end_date":"2017-10","start_date":"2017-10","title":{"name":"presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":null},{"company":{"name":"building commission","size":"11-50","id":"building-commission","founded":null,"industry":"government administration","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/building-commission","linkedin_id":"79670","facebook_url":null,"twitter_url":null,"website":null},"location_names":["perth, western australia, australia"],"end_date":"2017-01","start_date":"2017-01","title":{"name":"presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Presented on the topic: WA Construction Law: What Subcontractors Need to Know"},{"company":{"name":"hhg legal group","size":"51-200","id":"hhg-legal-group","founded":"1919","industry":"legal services","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/hhg-legal-group","linkedin_id":"439894","facebook_url":"facebook.com/hhglegalgroup","twitter_url":"twitter.com/hhg1919","website":"hhg.com.au"},"location_names":[],"end_date":"2013-12","start_date":"2013-06","title":{"name":"associate","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"I provide advice, representation and court advocacy (including as counsel in trials and arbitral hearings) in disputes regarding construction and engineering and other projects, private building certification, commercial leases, employment, service contracts, supply contracts, debts, securities and officers and directors' duties. I am also responsible for business development and mentoring and supervision of junior lawyers in the commercial litigation team of HHG Legal Group. I also present at question and answer sessions to construction and engineering industry participants every fortnight on various aspects of construction law."},{"company":{"name":"commonwealth director of public prosecutions","size":"51-200","id":"commonwealth-director-of-public-prosecutions","founded":null,"industry":"law practice","location":{"name":"canberra, act, australia","locality":"canberra","region":"act","metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":"-35.28,149.12"},"linkedin_url":"linkedin.com/company/commonwealth-director-of-public-prosecutions","linkedin_id":"3274637","facebook_url":null,"twitter_url":null,"website":"cdpp.gov.au"},"location_names":["perth, western australia, australia"],"end_date":"2007","start_date":"2004","title":{"name":"legal officer","role":"legal","sub_role":null,"levels":[]},"is_primary":false,"summary":"Prosecuted offenders for summary and indictable offences against Commonwealth law and gave advice to federal law enforcement agencies on the laws of the Commonwealth and the criminal justice system in WA."},{"company":{"name":"hhg legal group","size":"51-200","id":"hhg-legal-group","founded":"1919","industry":"legal services","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/hhg-legal-group","linkedin_id":"439894","facebook_url":"facebook.com/hhglegalgroup","twitter_url":"twitter.com/hhg1919","website":"hhg.com.au"},"location_names":[],"end_date":"2016-11","start_date":"2014-01","title":{"name":"senior associate","role":null,"sub_role":null,"levels":["senior"]},"is_primary":false,"summary":null},{"company":{"name":"master builders association of western australia","size":"11-50","id":"master-builders-association-of-western-australia","founded":"1898","industry":"construction","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/master-builders-association-of-western-australia","linkedin_id":"3310282","facebook_url":"facebook.com/masterbuilderswa","twitter_url":"twitter.com/mbawa_news","website":"mbawa.com"},"location_names":["perth, western australia, australia"],"end_date":"2016-10","start_date":"2016-10","title":{"name":"workshop presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Presented to contractor-members on the effective use of standard-form building and construction contracts."},{"company":{"name":"hhg legal group","size":"51-200","id":"hhg-legal-group","founded":"1919","industry":"legal services","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/hhg-legal-group","linkedin_id":"439894","facebook_url":"facebook.com/hhglegalgroup","twitter_url":"twitter.com/hhg1919","website":"hhg.com.au"},"location_names":["perth, western australia, australia"],"end_date":null,"start_date":"2016-11","title":{"name":"special counsel, commercial litigation construction and engineering","role":"engineering","sub_role":null,"levels":[]},"is_primary":false,"summary":null},{"company":{"name":"civil contractors federation wa","size":"11-50","id":"civil-contractors-federation-wa","founded":null,"industry":"civil engineering","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/civil-contractors-federation-wa","linkedin_id":"10694395","facebook_url":null,"twitter_url":null,"website":"ccfwa.com.au"},"location_names":["perth, western australia, australia"],"end_date":"2017-11","start_date":"2017-11","title":{"name":"author of the 2017 edition of the civil contractors' legal guide","role":"legal","sub_role":null,"levels":[]},"is_primary":false,"summary":"Presented the second edition of the Civil Contractors' Legal Guide."},{"company":{"name":"australian institute of quantity surveyors","size":"11-50","id":"australian-institute-of-quantity-surveyors","founded":null,"industry":"construction","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/australian-institute-of-quantity-surveyors","linkedin_id":"795603","facebook_url":null,"twitter_url":"twitter.com/aiqs","website":"aiqs.com.au"},"location_names":["perth, western australia, australia"],"end_date":null,"start_date":"2019-08","title":{"name":"presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Presented on lessons from the infamous Lacrosse combustible cladding case from the perspective of professional consultants as well as insurers, builders and developers with particular focus on what happens when consultancy agreements are novated by developers that don't have the ongoing relationship with consultants under them, to contractors that take no part in negotiating their terms."},{"company":{"name":"building commission of western australia","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["perth, western australia, australia"],"end_date":"2016-12","start_date":"2016-12","title":{"name":"presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Construction contracts: what subcontractors need to know. A 3 - hour presentation covering: Managing your contract Tender/pre-contract checklist: The basics: Labour needed: availability and cost Materials required: availability and cost Cash flow requirements (across the business Programming Pricing risks Time-related risks Pre-Contract risk mitigation Critical clauses Defects and warranties Taking advantage of your DLP Performance bonds and retentions: the price you pay for your DLP Checking manufacturers’ and subcontractors’ warranties against contractual requirements Implied warranties Liability in negligence Liability for latent defects Australian and international standards and building codes Remediation versus compensation Consumer/owner protections Australian Consumer Law Home Building Contracts Act Sale of Goods Act Dispute resolution"},{"company":{"name":"legalwise seminars","size":"11-50","id":"legalwise-seminars","founded":"2002","industry":"legal services","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/legalwise-seminars","linkedin_id":"144535","facebook_url":null,"twitter_url":null,"website":"legalwiseseminars.com.au"},"location_names":["perth, western australia, australia"],"end_date":"2016-03","start_date":"2016-03","title":{"name":"'restitution sans rescission: exposing the myth of a fallacy'","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Presented on same-titled paper written by me and published in Australian Law Journal at (2015) 89 ALJ 117"},{"company":{"name":"resolution institute","size":"11-50","id":"resolutioninstitute","founded":"1989","industry":"alternative dispute resolution","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/resolutioninstitute","linkedin_id":"2591707","facebook_url":"facebook.com/leadrnow","twitter_url":"twitter.com/leadrnow","website":"resolution.institute"},"location_names":["perth, western australia, australia"],"end_date":"2015-09","start_date":"2015-09","title":{"name":"presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"kon gres presentation on quantum meruit for alternative dispute resolution professionals."},{"company":{"name":"master builders australia","size":"11-50","id":"master-builders-australia","founded":"1890","industry":"construction","location":{"name":"act, australia","locality":null,"region":"act","metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/master-builders-australia","linkedin_id":"1552381","facebook_url":"facebook.com/masterbuildersaustralia","twitter_url":"twitter.com/mba_aust","website":"masterbuilders.com.au"},"location_names":[],"end_date":"2014-02","start_date":"2014-02","title":{"name":"presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Presented workshop to construction industry professionals on construction contracts."},{"company":{"name":"curtin university","size":"5001-10000","id":"curtinuniversity","founded":null,"industry":"higher education","location":{"name":"bentley, western australia, australia","locality":"bentley","region":"western australia","metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":"-32.0,115.91"},"linkedin_url":"linkedin.com/company/curtinuniversity","linkedin_id":"8788","facebook_url":"facebook.com/curtinalumni","twitter_url":"twitter.com/curtinuni","website":"curtin.edu.au"},"location_names":["perth, western australia, australia"],"end_date":"2015-01","start_date":"2014-01","title":{"name":"presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Presented tutorials with Lecturer, Paul Wellington, on construction law's statutory framework in WA."},{"company":{"name":"the law society of western australia","size":"5001-10000","id":"the-law-society-of-western-australia","founded":"1927","industry":"legal services","location":{"name":"perth, western australia, australia","locality":"perth","region":"western australia","metro":null,"country":"australia","continent":"oceania","street_address":"160 st georges terrace","address_line_2":null,"postal_code":null,"geo":"-31.95,115.86"},"linkedin_url":"linkedin.com/company/the-law-society-of-western-australia","linkedin_id":"2817073","facebook_url":"facebook.com/ylc.wa","twitter_url":null,"website":"lawsocietywa.asn.au"},"location_names":["perth, western australia, australia"],"end_date":"2014-12","start_date":"2014-06","title":{"name":"inter - school mock trial competition judge","role":"legal","sub_role":"judicial","levels":[]},"is_primary":false,"summary":null},{"company":{"name":"university of melbourne","size":"10001+","id":"university-of-melbourne","founded":null,"industry":"higher education","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/university-of-melbourne","linkedin_id":"5677","facebook_url":"facebook.com/melbuni","twitter_url":"twitter.com/unimelb","website":"unimelb.edu.au"},"location_names":["melbourne, victoria, australia"],"end_date":"2013-12","start_date":"2011-01","title":{"name":"master of laws student","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"I graduated on 20 December 2013. For my final paper on the future of restitutionary quantum meruit in Australian construction law, I was awarded an \"H1\" (First Class Honours)."},{"company":{"name":"civil contractors federation wa","size":"11-50","id":"civil-contractors-federation-wa","founded":null,"industry":"civil engineering","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/civil-contractors-federation-wa","linkedin_id":"10694395","facebook_url":null,"twitter_url":null,"website":"ccfwa.com.au"},"location_names":["perth, western australia, australia"],"end_date":"2016-11","start_date":"2016-11","title":{"name":"presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Launch of the Civil Contractor’s Legal Guide, a unique, plain language guide which meets the everyday legal needs of civil contractors: Know your rights and understand the legal issues affecting day to day business and operations."},{"company":{"name":"smbit professionals","size":"1-10","id":"smbit-professionals","founded":"2009","industry":"information technology and services","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/smbit-professionals","linkedin_id":"928800","facebook_url":null,"twitter_url":"twitter.com/smbitproanz","website":"smbitpro.org"},"location_names":["sydney, new south wales, australia","perth, western australia, australia"],"end_date":"2016-10","start_date":"2016-10","title":{"name":"presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Presented at the National Conference of SMBiT Professionals regarding maximising protections at minimal cost through effective registration on the Personal Property Securities Register."},{"company":{"name":"murdoch university","size":"1001-5000","id":"murdoch-university","founded":"1974","industry":"higher education","location":{"name":"murdoch, western australia, australia","locality":"murdoch","region":"western australia","metro":null,"country":"australia","continent":"oceania","street_address":"90 south street","address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/murdoch-university","linkedin_id":"165072","facebook_url":null,"twitter_url":"twitter.com/murdochuni","website":"murdoch.edu.au"},"location_names":["perth, western australia, australia"],"end_date":"2015-09","start_date":"2015-02","title":{"name":"guest lecturer","role":"education","sub_role":"professor","levels":[]},"is_primary":false,"summary":"* Lectured in Civil Procedure units on: (a) defective pleadings\n* b) conduct of trials\n* and (c) legal ethics"},{"company":{"name":"civil contractors federation","size":"51-200","id":"civil-contractors-federation","founded":null,"industry":"non-profit organization management","location":{"name":"act, australia","locality":null,"region":"act","metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/civil-contractors-federation","linkedin_id":"937734","facebook_url":null,"twitter_url":null,"website":"civilcontractors.com"},"location_names":["perth, western australia, australia"],"end_date":"2018-02","start_date":"2015-01","title":{"name":"associate member and workshop presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Regular participant in CCF events and presented in workshops on: (a) liquidated damages, the doctrine of penalties and the prevention principal; and (b) \"Getting Paid What Your Work is Worth: Know Your Rights in Restitution at CCF State Conference. Due to present on construction and insolvency later this year."},{"company":{"name":"legalwise seminars","size":"11-50","id":"legalwise-seminars","founded":"2002","industry":"legal services","location":{"name":"australia","locality":null,"region":null,"metro":null,"country":"australia","continent":"oceania","street_address":null,"address_line_2":null,"postal_code":null,"geo":null},"linkedin_url":"linkedin.com/company/legalwise-seminars","linkedin_id":"144535","facebook_url":null,"twitter_url":null,"website":"legalwiseseminars.com.au"},"location_names":["perth, western australia, australia"],"end_date":"2017-11","start_date":"2017-11","title":{"name":"presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"A brief look at the Personal Property Securities Act 2009, seven years on, with particular attention to Tottle J's and the WA Court of Appeal's treatment of relevant principles in Hammersley Iron v Forge. A modified version was presented to insolvency practitioners at the City Insolvency Discussion Group event hosted by HLB Mann Judd."},{"company":{"name":"department of mines, industry regulation and safety, western australia","size":"1001-5000","id":"dmirs","founded":null,"industry":"government administration","location":{"name":"east perth, western australia, australia","locality":"east perth","region":"western australia","metro":null,"country":"australia","continent":"oceania","street_address":"100 plain street","address_line_2":null,"postal_code":null,"geo":"-31.95,115.86"},"linkedin_url":"linkedin.com/company/dmirs","linkedin_id":"347812","facebook_url":null,"twitter_url":null,"website":"dmirs.wa.gov.au"},"location_names":["perth, western australia, australia"],"end_date":"2019-02","start_date":"2019-02","title":{"name":"presenter","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"If you have carried out construction work at the request of another, you are entitled to be paid for it. If a price has been agreed, you must be paid that price unless the agreement is unenforceable. Even without an enforceable price, you are virtually always entitled to be paid the fair value of the work that you do at someone else’s request. However, being entitled to payment is one thing; getting hold of your money is quite another. For example, as effective as rapid pay dispute adjudication can be under the Construction Contracts Act 2004, there are some cases where it doesn’t apply. If your right to be paid is not properly secured before you start work on site and your principal becomes insolvent, you may find there is nothing left once the banks and secured suppliers have taken their cut. Building and Energy Division invites you to join HHG Legal Group’s Daniel Morris, special counsel, to learn the best way to get paid in common construction scenarios; when adjudication may not work and why; and how to protect your payment rights if your principal becomes insolvent."}],"education":[{"school":{"name":"sydney boys' high school","type":"secondary school","id":null,"location":null,"linkedin_url":null,"facebook_url":null,"twitter_url":null,"linkedin_id":null,"website":null,"domain":null},"end_date":"1996","start_date":"1991","gpa":null,"degrees":[],"majors":[],"minors":[],"summary":null},{"school":{"name":"melbourne university","type":"post-secondary institution","id":null,"location":null,"linkedin_url":null,"facebook_url":null,"twitter_url":null,"linkedin_id":null,"website":null,"domain":null},"end_date":"2013","start_date":"2011","gpa":null,"degrees":["masters","master of laws"],"majors":["law","construction"],"minors":[],"summary":null},{"school":{"name":"macquarie university","type":"post-secondary institution","id":"92efCY698ew-3zFwlW4BEQ_0","location":{"name":"sydney, new south wales, australia","locality":"sydney","region":"new south wales","country":"australia","continent":"oceania"},"linkedin_url":"linkedin.com/school/macquarie-university","facebook_url":"facebook.com/macquarieuni","twitter_url":"twitter.com/macquarie_uni","linkedin_id":"10230","website":"mq.edu.au","domain":"mq.edu.au"},"end_date":"2001","start_date":"1997","gpa":null,"degrees":["bachelors","bachelor of arts","bachelor of law"],"majors":["law"],"minors":[],"summary":"Qualified for Honours (Class II – 1999; Class I – 2001). Did not commence Honours program due to work commitments in Perth.\n Activities and Societies: Golden Key National Honour Society – life membership"}],"profiles":[{"network":"linkedin","id":"176802030","url":"linkedin.com/in/danieljosephmorris","username":"danieljosephmorris"},{"network":"linkedin","id":"176802030","url":"linkedin.com/in/daniel-morris-ba62634b","username":"daniel-morris-ba62634b"}],"certifications":[{"organization":"society of construction law australia","start_date":null,"end_date":null,"name":"brooking prize - society of construction law australia"},{"organization":"society of construction law australia","start_date":"2019-08","end_date":null,"name":"high commendation, brooking prize competition"},{"organization":null,"start_date":null,"end_date":null,"name":"society of construction law australia"}],"languages":[{"name":"german","proficiency":null}],"version_status":{"status":"updated","contains":[],"previous_version":"12.0","current_version":"13.0"}}
{"id":"lTpMMwl74GVwuyOqgL0tdA_0000","full_name":"melanie sutherland","first_name":"melanie","middle_initial":null,"middle_name":null,"last_name":"sutherland","gender":"female","birth_year":null,"birth_date":null,"linkedin_url":"linkedin.com/in/melanie-sutherland-b4379b3","linkedin_username":"melanie-sutherland-b4379b3","linkedin_id":"10907043","facebook_url":"facebook.com/melanie.sutherland.12","facebook_username":"melanie.sutherland.12","facebook_id":"1014775433","twitter_url":null,"twitter_username":null,"github_url":null,"github_username":null,"work_email":null,"mobile_phone":null,"industry":"entertainment","job_title":"theatre director","job_title_role":null,"job_title_sub_role":null,"job_title_levels":["director"],"job_company_id":null,"job_company_name":"plays in development seeking producers or theatres","job_company_website":null,"job_company_size":null,"job_company_founded":null,"job_company_industry":null,"job_company_linkedin_url":null,"job_company_linkedin_id":null,"job_company_facebook_url":null,"job_company_twitter_url":null,"job_company_location_name":null,"job_company_location_locality":null,"job_company_location_metro":null,"job_company_location_region":null,"job_company_location_geo":null,"job_company_location_street_address":null,"job_company_location_address_line_2":null,"job_company_location_postal_code":null,"job_company_location_country":null,"job_company_location_continent":null,"job_last_updated":"2020-12-01","job_start_date":"2017-01","job_summary":"* I am a THEATRE DIRECTOR attached to following plays, looking for producers or theatres for workshop and production: A Quiet Snow by Paul Sambol With a blizzard raging outdoors and a family reunion raging indoors, how hard can it be to get your mother to the hospital? A dark comedy about reconnecting with family despite all those involved. Cast of Characters: Mildred (80)\n* Abby, her daughter (50's)\n* Jeffrey, her nephew (40's)\n* Stewart, somebody's date (30's)\n* Rachel, a cousin (20's). Silo Inferno by Kate McCamy In development - currently in 3 Parts (Limbo, Lust, Gluttony) - inspired by Dante's Inferno. Somewhere in the not-too-distant future, the elite, privileged few have escaped underground to their survival silo, only to become mired in a different kind of hell. Follow a merry band of unlikely allies on their journey to get home. Dante's Inferno meets Wizard of Oz. Cast of Characters: Kath (60's)\n* Dick (60's)\n* Carl, a servant/probably some congressman's son who couldn't afford the whole package (20's - 30's)\n* Dimitri (50's - 70's), an oligarch.","location_name":"moseley, virginia, united states","location_locality":"moseley","location_metro":null,"location_region":"virginia","location_country":"united states","location_continent":"north america","location_street_address":"5430 trail ride court","location_address_line_2":null,"location_postal_code":"23120","location_geo":"37.47,-77.77","location_last_updated":"2020-07-01","linkedin_connections":1690,"inferred_salary":"100,000-150,000","inferred_years_experience":41,"summary":"Director attached to following plays, in various stages of development, looking for producers: ... Selected for the 2012 New York International Fringe Festival.","phone_numbers":[],"emails":[{"address":"msuther766@aol.com","type":"personal"}],"interests":[],"skills":["theatre","stage","entertainment","plays","performing arts","acting","film","drama","comedy","fundraising","improvisation","dramaturgy","film production","musical theatre","television","stage management","arts administration","creative writing","public speaking","shakespeare","editing","art","playwriting","voice acting","dialects","event planning","casting","blogging","arts","nonprofits","press releases","facebook","dance","non profits","event management","screenwriting","directing","short films","feature films","directors","writing","special events","research"],"location_names":["fredericksburg, virginia, united states","atlanta, georgia, united states","dallas, texas, united states","east amherst, new york, united states","free union, virginia, united states","hearst, ontario, canada","warrenton, virginia, united states","london, london, united kingdom","chicago, illinois, united states","blackburn, blackburn with darwen, united kingdom","westford, massachusetts, united states","roswell, georgia, united states","new york, new york, united states","long beach, california, united states","boston, massachusetts, united states","richmond, virginia, united states","new city, new york, united states","san diego, california, united states","brooklyn, new york, united states","brookhaven, georgia, united states","fort collins, colorado, united states","oakland, california, united states","rochester, minnesota, united states","midlothian, virginia, united states","johannesburg, gauteng, south africa","charlotte, north carolina, united states","washington, district of columbia, united states","sydney, new south wales, australia","minneapolis, minnesota, united states","cleveland, ohio, united states","franklin, new hampshire, united states","greenville, south carolina, united states","regina, saskatchewan, canada","moseley, virginia, united states","eagle point, oregon, united states","springfield, virginia, united states","newark, delaware, united states","salem, oregon, united states","evanston, illinois, united states","los angeles, california, united states","fairfax, virginia, united states","marietta, georgia, united states","vancouver, british columbia, canada","bronx, new york, united states"],"regions":["delaware, united states","district of columbia, united states","colorado, united states","london, united kingdom","south carolina, united states","texas, united states","british columbia, canada","virginia, united states","blackburn with darwen, united kingdom","oregon, united states","california, united states","new hampshire, united states","north carolina, united states","illinois, united states","ontario, canada","new south wales, australia","ohio, united states","georgia, united states","saskatchewan, canada","gauteng, south africa","new york, united states","minnesota, united states","massachusetts, united states"],"countries":["united kingdom","australia","canada","singapore","united states","ireland","south africa"],"street_addresses":[{"name":"moseley, virginia, united states","locality":"moseley","region":"virginia","metro":null,"country":"united states","continent":"north america","street_address":"5430 trail ride court","address_line_2":null,"postal_code":"23120","geo":"37.47,-77.77"},{"name":"midlothian, virginia, united states","locality":"midlothian","region":"virginia","metro":null,"country":"united states","continent":"north america","street_address":"5701 grove forest road","address_line_2":null,"postal_code":"23112","geo":"37.50,-77.64"},{"name":"marietta, georgia, united states","locality":"marietta","region":"georgia","metro":"atlanta, georgia","country":"united states","continent":"north america","street_address":"4960 heritage trace court","address_line_2":null,"postal_code":"30062","geo":"33.95,-84.55"},{"name":"midlothian, virginia, united states","locality":"midlothian","region":"virginia","metro":null,"country":"united states","continent":"north america","street_address":"5701 grove forest court","address_line_2":null,"postal_code":"23112","geo":"37.50,-77.64"},{"name":"atlanta, georgia, united states","locality":"atlanta","region":"georgia","metro":"atlanta, georgia","country":"united states","continent":"north america","street_address":"232 colonial homes northwest drive","address_line_2":null,"postal_code":"30309","geo":"33.74,-84.38"},{"name":"fredericksburg, virginia, united states","locality":"fredericksburg","region":"virginia","metro":"district of columbia","country":"united states","continent":"north america","street_address":"10105 four iron court","address_line_2":null,"postal_code":"22408","geo":"38.30,-77.46"},{"name":"brookhaven, georgia, united states","locality":"brookhaven","region":"georgia","metro":"atlanta, georgia","country":"united states","continent":"north america","street_address":"2308 brookhaven northeast view","address_line_2":null,"postal_code":"30319","geo":"33.85,-84.34"},{"name":"roswell, georgia, united states","locality":"roswell","region":"georgia","metro":"atlanta, georgia","country":"united states","continent":"north america","street_address":"1623 hemingway lane","address_line_2":null,"postal_code":"30075","geo":"34.02,-84.36"},{"name":"fairfax, virginia, united states","locality":"fairfax","region":"virginia","metro":"district of columbia","country":"united states","continent":"north america","street_address":"10448 malone court","address_line_2":null,"postal_code":"22032","geo":"38.84,-77.30"},{"name":"newark, delaware, united states","locality":"newark","region":"delaware","metro":"philadelphia, pennsylvania","country":"united states","continent":"north america","street_address":"109 kershaw street","address_line_2":null,"postal_code":"19711","geo":"39.68,-75.75"},{"name":"springfield, virginia, united states","locality":"springfield","region":"virginia","metro":"district of columbia","country":"united states","continent":"north america","street_address":"8829 winding hollow way","address_line_2":null,"postal_code":"22152","geo":"38.78,-77.18"}],"experience":[{"company":{"name":"boutique fitness summit","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2019-04","start_date":"2019-04","title":{"name":"breakout session manager","role":null,"sub_role":null,"levels":["manager"]},"is_primary":false,"summary":"Managed set-up and run of Breakout Sessions for day-long conference, for event producer, Julie Carpenter."},{"company":{"name":"blackwell's bookshops","size":"201-500","id":"blackwell-limited-international-book-retail-and-distribution-","founded":"1879","industry":"retail","location":{"name":"oxford, oxfordshire, united kingdom","locality":"oxford","region":"oxfordshire","metro":null,"country":"united kingdom","continent":"europe","street_address":"48-51 broad street","address_line_2":null,"postal_code":null,"geo":"51.75,-1.25"},"linkedin_url":"linkedin.com/company/blackwell-limited-international-book-retail-and-distribution-","linkedin_id":"819471","facebook_url":null,"twitter_url":null,"website":"blackwells.co.uk"},"location_names":[],"end_date":"1989","start_date":"1984","title":{"name":"office support","role":"customer_service","sub_role":"support","levels":[]},"is_primary":false,"summary":null},{"company":{"name":"new york women in film & television","size":"1-10","id":"new-york-women-in-film-&-television","founded":"1977","industry":"motion pictures and film","location":{"name":"new york, new york, united states","locality":"new york","region":"new york","metro":"new york, new york","country":"united states","continent":"north america","street_address":"6 east 39 street","address_line_2":"suite 1200","postal_code":"10016","geo":"40.71,-74.00"},"linkedin_url":"linkedin.com/company/new-york-women-in-film-&-television","linkedin_id":"120498","facebook_url":"facebook.com/nywift","twitter_url":"twitter.com/nywift","website":"nywift.org"},"location_names":[],"end_date":"2014-12","start_date":"2014-11","title":{"name":"registration and foh captain","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Coordinated and ran Registration / Front of House for 11 December 2014 Muse Awards, a gala luncheon at the New York Hilton, honoring women in film and television, including Maggie Gyllenhaal, Wanda Sykes, Mary Bailey, Dawn Ostroff, and Abigail Disney."},{"company":{"name":"minor theater festival","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["clinton, new york, united states"],"end_date":"2014-06","start_date":"2014-02","title":{"name":"director","role":null,"sub_role":null,"levels":["director"]},"is_primary":false,"summary":"Directed Richard Nelson's WHAT I DID ON MY SUMMER VACATION, from Roots in Water, at Minor Theater Festival, on 7 June 2014, with Chelsea D'Aprile, Brad Fleischer, and Lisa Schreiner."},{"company":{"name":"kirkland echoes short plays on the kirkland experience","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["clinton, new york, united states"],"end_date":"2014-06","start_date":"2013-08","title":{"name":"director","role":null,"sub_role":null,"levels":["director"]},"is_primary":false,"summary":"Conceived, commissioned, and directed rehearsed readings of six short plays inspired by the Kirkland College experience, at the Minor Theater Festival, on 6 June 2014. Written by Susan Shopmaker, Constance Stellas, Gwynn O'Gara, Nancy Avery Dafoe, Nicole Dafoe, Zan Tewksbury, Elisabeth Horwitt, and Lars Nielsen. Four of the plays were published in LOST ORCHARD (2014 SUNY Press), a collection of Kirkland writings complied by Jo Pitkin."},{"company":{"name":"new jersey repertory","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["long branch, new jersey, united states"],"end_date":"2014-04","start_date":"2014-04","title":{"name":"director","role":null,"sub_role":null,"levels":["director"]},"is_primary":false,"summary":"Directed rehearsed reading of PROMISED LAND by Guillem Clua, translated by Marion Peter Holt, on 7 April 2014 at New Jersey Repertory Company - Gabor Barabas, Executive Producer, and SuzAnne Barabas, Artistic Director."},{"company":{"name":"new york women in film & television","size":"1-10","id":"new-york-women-in-film-&-television","founded":"1977","industry":"motion pictures and film","location":{"name":"new york, new york, united states","locality":"new york","region":"new york","metro":"new york, new york","country":"united states","continent":"north america","street_address":"6 east 39 street","address_line_2":"suite 1200","postal_code":"10016","geo":"40.71,-74.00"},"linkedin_url":"linkedin.com/company/new-york-women-in-film-&-television","linkedin_id":"120498","facebook_url":"facebook.com/nywift","twitter_url":"twitter.com/nywift","website":"nywift.org"},"location_names":[],"end_date":"2013-12","start_date":"2013-11","title":{"name":"co-captain, registration and foh","role":null,"sub_role":null,"levels":[]},"is_primary":false,"summary":"Coordinated and ran Registration / Front of House with co-captain, Bette Lawler, for 12 December 2013 Muse Awards, honoring women in film and television, including actors Ellen Barkin, Connie Britton and Robin Wright, actor and writer Sonia Manzano and Frances Berwick, President of Bravo and Oxygen Media."},{"company":{"name":"epcnyc 6th annual equal pay day nyc","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2012-04","start_date":"2012-03","title":{"name":"event producer","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"Produced Equal Pay Day event in NYC, 16 April 2012, co-sponsored by Equal Pay Coalition NYC, New York Women's Agenda, A Better Balance, NYU Law Women, and NYS & NYC Leaders, with special guest: The Honorable Senator Kirsten Gillibrand, interviewed by Maria Hinojosa (award-wining PBS journalist). Event included speakers, panelists (Galit Ben-Joseph, Serena Fong, C. Nicole Mason), and NYS & NYC elected officials, with photo ops."},{"company":{"name":"nywa coffee & conversation with nyc council speaker christine quinn","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2012-03","start_date":"2012-01","title":{"name":"event coordinator","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"Coordinated breakfast meeting event, 1 March 2012, with guest speaker, NYC Council Speaker Christine Quinn, co-sponsored by New York Women's Agenda and New York Women's Agenda. Invitation-only event for NYWA member organization presidents and 20th Anniversary Donors."},{"company":{"name":"epcnyc 5th annual equal pay day nyc","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2011-04","start_date":"2011-03","title":{"name":"event producer","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"Produced 5th Annual Equal Pay Day event, 12 April 2011, co-sponsored by EPCNYC and NYWA. Press event included NYC Comptroller John C. Liu's presentation of Analysis of Gender Equity study, and NYC Council Members. Panelists - Natatia Griffith, Grace Protos, Aditi Mohapatra, and Patricia Fitzpatrick. Beverly Neufeld, NYWA President and EPC Director."},{"company":{"name":"lptw networkingmondays","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2010-03","start_date":"2008-06","title":{"name":"event producer and founder","role":"public_relations","sub_role":"events","levels":["owner"]},"is_primary":false,"summary":"Created, managed, and produced monthly structured networking event for members of the League of Professional Theatre Women at mid-town bar/restaurant."},{"company":{"name":"theatre companies & producers off-bway off-off-bway regional university","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":[],"end_date":null,"start_date":"1979","title":{"name":"theatre director","role":null,"sub_role":null,"levels":["director"]},"is_primary":false,"summary":"Member of SDC - national union of stage directors and choreographers."},{"company":{"name":"women in the arts & media coalition, inc.","size":"5001-10000","id":"women-in-the-arts-&-media-coalition-inc-","founded":"1991","industry":"entertainment","location":{"name":"new york, new york, united states","locality":"new york","region":"new york","metro":"new york, new york","country":"united states","continent":"north america","street_address":"244 fifth avenue","address_line_2":"suite 2932","postal_code":"10001","geo":"40.71,-74.00"},"linkedin_url":"linkedin.com/company/women-in-the-arts-&-media-coalition-inc-","linkedin_id":"3348369","facebook_url":null,"twitter_url":null,"website":"womenartsmediacoalition.org"},"location_names":[],"end_date":"2014-10","start_date":"2014-09","title":{"name":"event producer","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"Day of Producer for the 18 October 2014 VintAGE Event, celebrating women artists over 40 – day-long program included short films, panel discussion, keynote speakers (Estelle Parsons, Gretchen Cyrer), and the 1st Elsa Rael VintAge Award presented to Morgan Jenness by Tisa Chang. Responsibilities included liaison with venue rep, venue tech, caterer, and VIP wranglers, as well as limited consulting in advance of event day with co-presidents, Shellen Lubin & Avis Boone; coordinated deliveries, load-in, and tasks with Point Persons – managed day's events from pre-show to load-out; created Run of Show (ROS) and Timeline documents."},{"company":{"name":"new york theatre workshop","size":"11-50","id":"new-york-theatre-workshop","founded":null,"industry":"performing arts","location":{"name":"new york, new york, united states","locality":"new york","region":"new york","metro":"new york, new york","country":"united states","continent":"north america","street_address":"79 east 4th street","address_line_2":null,"postal_code":"10003","geo":"40.71,-74.00"},"linkedin_url":"linkedin.com/company/new-york-theatre-workshop","linkedin_id":"505989","facebook_url":null,"twitter_url":"twitter.com/nytw79","website":"nytw.org"},"location_names":["new york, new york, united states"],"end_date":"2014-04","start_date":"2014-04","title":{"name":"director","role":null,"sub_role":null,"levels":["director"]},"is_primary":false,"summary":"Directed rehearsed reading of MARBURG by Guillem Clua, translated by Marion Peter Holt, on 14 April 2014, at New York Theatre Workshop - Jim Nicola, Artistic Director, and Linda Chapman, Associate Artistic Director."},{"company":{"name":"league of professional theatre women","size":"1-10","id":"league-of-professional-theatre-women","founded":"1980","industry":"entertainment","location":{"name":"new york, new york, united states","locality":"new york","region":"new york","metro":"new york, new york","country":"united states","continent":"north america","street_address":"520 8th avenue","address_line_2":null,"postal_code":"10018","geo":"40.71,-74.00"},"linkedin_url":"linkedin.com/company/league-of-professional-theatre-women","linkedin_id":"3481945","facebook_url":null,"twitter_url":"twitter.com/lptwomen","website":"theatrewomen.org"},"location_names":["new york, new york, united states"],"end_date":"2014-03","start_date":"2014-01","title":{"name":"event producer and consultant","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"As Day of Producer for the 10 March 2014 Awards Celebration & Big Mingle, honoring women in theatre, including Tamara Tunie (emcee), Zoe Caldwell, and Audra McDonald, my responsibilities included Liasion with Venue Rep, Venue Tech, and Caterer. I coordinated deliveries and load-in. I directed the onstage awards event. Designed overall structure with Event Producer / VP Programming, Susan Bernfield. Created Run of Show (ROS) document. Liaison with VIP Wranglers, Photographers, and Videographer. Coordinated tasks with Point Persons. Reviewed/Edited Budget, Timeline, Script. Additionally, consulted on all aspects of new event in 294-seat venue, from January through March."},{"company":{"name":"wamco sne event","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2005-12","start_date":"2005-09","title":{"name":"event producer","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"Created, managed, produced Speed Networking Event (SNE) for Women in Arts & Media Coalition. This event encouraged women across entertainment disciplines to network one-on-one in timed sessions."},{"company":{"name":"new york women in film & television","size":"1-10","id":"new-york-women-in-film-&-television","founded":"1977","industry":"motion pictures and film","location":{"name":"new york, new york, united states","locality":"new york","region":"new york","metro":"new york, new york","country":"united states","continent":"north america","street_address":"6 east 39 street","address_line_2":"suite 1200","postal_code":"10016","geo":"40.71,-74.00"},"linkedin_url":"linkedin.com/company/new-york-women-in-film-&-television","linkedin_id":"120498","facebook_url":"facebook.com/nywift","twitter_url":"twitter.com/nywift","website":"nywift.org"},"location_names":[],"end_date":"2015-12","start_date":"2015-11","title":{"name":"event producer","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"Day of Producer for 8 December 2016 Muse Awards, gala luncheon at New York Hilton – honoring Debi Mazar, Martha Plimpton, Jacki Kelley, Amy Goodman, Mary-Louise Parker, Marcia Smith; and Nancy Giles, emcee. Responsibilities included – coordinate logistics with executive director, Terry Lawler, and all department captains week in advance, liaison with hotel/catering mgr, manage deliveries, load-out/load-in/strike/load-out; day of – oversee venue staff and volunteer staffing, FOH/Registration (general and VIP), receptions (general and VIP), luncheon, coffee hour, and after party. Additional consulting six weeks in advance included meetings with venue, Board, committee, captains, pre-production + tech producers; created documents – ROS (all inclusive, all depts 6a to 6p), Producer's checklist, Department checklists, Dept supplies checklists for Go Bags, volunteer assignments + call times. Managed debriefing and follow-up notes for Event Bible."},{"company":{"name":"famous for 15 minutes theater festival","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2014-03","start_date":"2013-12","title":{"name":"director","role":null,"sub_role":null,"levels":["director"]},"is_primary":false,"summary":"* Directed two plays in festival of new plays, March 2014.\n* Clifford Lee Johnson III, Producer; Cynthia Jankowski, Production Mgr\n* ALL FOR ONE by Lori Goodman, with Alice King, Romy Nordlinger, Mickey Ryan, Keith Weber\n* BLIND DATE by Jane Kelley, with Alice King and Samantha Fontana"},{"company":{"name":"lptw blog30","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":[],"end_date":"2013-03","start_date":"2011-05","title":{"name":"founder","role":null,"sub_role":null,"levels":["owner"]},"is_primary":false,"summary":"Initiated, nurtured, and administered Blog30 - a daily blog celebrating the individual members of the League of Professional Theatre Women during its 30th Anniversary year - with Lanie Zipoy, Susan Bernfield, and Shaun Bennet Wilson. Blog30 launched on January 1, 2012. From the press release: \"As a long time member of the League of Professional Theatre Women, I am constantly astonished by the diversity and creative talents of its members,\" says Sutherland. \"We created Blog30 to showcase the individual members' achievements as well as their interests, and I'm thrilled that members have been eager to participate.\" Blog30 can be found at www.lptw30blog.wordpress.com"},{"company":{"name":"new york women's agenda","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2012-12","start_date":"2012-09","title":{"name":"event producer","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"* Produced 20th Anniversary Celebration event, 5 December 2012, which included full reception, awards ceremony, and 100th birthday tribute for founder, Elinor Guggenheimer, plus photo ops: STAR Award for Advocacy presented to Lilly Ledbetter by Kerry Kennedy\n* Roz Abrams - emcee\n* Carol Jenkins - Elly Tribute\n* other speakers: Beverly Neufeld, Gena Lovett, Terri D. Austin\n* Galaxy Awards. Responsibilities included concept, budget, venue + catering negotiations, staffing, liaison, timelines and ROS (run of show), co-wrote script, management of event, and post-event wrap-up; worked closely with NYWA's president."},{"company":{"name":"she's beautiful film project","size":"1-10","id":"she's-beautiful-film-project","founded":null,"industry":"media production","location":null,"linkedin_url":"linkedin.com/company/she's-beautiful-film-project","linkedin_id":"1573604","facebook_url":null,"twitter_url":null,"website":"shesbeautifulwhenshesangry.com"},"location_names":["new york, new york, united states"],"end_date":"2012-06","start_date":"2012-04","title":{"name":"event producer","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"* Produced fund-raising screening of documentary film - She's Beautiful When She's Angry, by filmmakers Mary Dore and Nancy Kennedy on 14 June 2012.\n* This event included screening of scenes from inspiring documentary about the early women's liberation movement, followed by reception.\n* Responsibilities included venue & catering negotiations, budget, event structure, staffing, running the event."},{"company":{"name":"carole hyatt leadership forum 18th annual alumnae dinner event","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2012-02","start_date":"2011-09","title":{"name":"event producer","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"* Produced dinner event\n* 1 February 2012\n* which included reception, speakers (Kathryn Mayer and Carole Murko), structured networking, raffles, gift bags for alumnae of the Carole Hyatt Leadership Forum workshops. Theme\n* The Joy of Bartering ~ The Art of Collaboration. Responsibilities included event structure, budget, venue & menu negotiations and liaison, staffing, managed donated goods and services, program ads, timelines and ROS (run of show), ran event."},{"company":{"name":"nywa star breakfast 2011","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2011-12","start_date":"2011-05","title":{"name":"talent coordinator","role":"human_resources","sub_role":"recruiting","levels":[]},"is_primary":false,"summary":"Served on STAR Breakfast committee, the annual fundraiser and awards ceremony for NYWA. Worked with Committee Chair, Beth-Ellen Keyes, and NYWA President, Bev Neufeld. Responsibilities included talent coordination before and during event, with performance by vocalist, Jeannette Bayardelle. Honorees included: Billie Jean King Winner of the Elinor Guggenheimer Lifetime Achievement Award, presented by Christiane Amanpour"},{"company":{"name":"wamco jan events","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2008-01","start_date":"2007-09","title":{"name":"event producer","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"* Initiated, created, managed, and produced structured networking events\n* The Just About Networking Event (JAN)\n* for Women in Arts & Media Coalition, for 100+ attendees. Events included 'icebreakers' during reception, followed by networking 'games' and one-on-one introductions."},{"company":{"name":"sutherland consultants","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":null,"start_date":"1986","title":{"name":"event producer","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"Scroll down to see details on recent events, and recommendations specific to those events."},{"company":{"name":"wrist art","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["brooklyn, new york, united states"],"end_date":null,"start_date":"1990-01","title":{"name":"owner and designer","role":"design","sub_role":null,"levels":["owner"]},"is_primary":false,"summary":"Wrist Art is handcrafted in Park Slope, Brooklyn. I design and build unique, one-of-a-kind, and custom-made multi-bead and glass-bead bracelets, for women and men. \"Like\" Wrist Art on Facebook."},{"company":{"name":"plays in development seeking producers or theatres","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":[],"end_date":null,"start_date":"2017-01","title":{"name":"theatre director","role":null,"sub_role":null,"levels":["director"]},"is_primary":true,"summary":"* I am a THEATRE DIRECTOR attached to following plays, looking for producers or theatres for workshop and production: A Quiet Snow by Paul Sambol With a blizzard raging outdoors and a family reunion raging indoors, how hard can it be to get your mother to the hospital? A dark comedy about reconnecting with family despite all those involved. Cast of Characters: Mildred (80)\n* Abby, her daughter (50's)\n* Jeffrey, her nephew (40's)\n* Stewart, somebody's date (30's)\n* Rachel, a cousin (20's). Silo Inferno by Kate McCamy In development - currently in 3 Parts (Limbo, Lust, Gluttony) - inspired by Dante's Inferno. Somewhere in the not-too-distant future, the elite, privileged few have escaped underground to their survival silo, only to become mired in a different kind of hell. Follow a merry band of unlikely allies on their journey to get home. Dante's Inferno meets Wizard of Oz. Cast of Characters: Kath (60's)\n* Dick (60's)\n* Carl, a servant/probably some congressman's son who couldn't afford the whole package (20's - 30's)\n* Dimitri (50's - 70's), an oligarch."},{"company":{"name":"new york women's agenda","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2012-12","start_date":"2008-09","title":{"name":"board member","role":null,"sub_role":null,"levels":["partner"]},"is_primary":false,"summary":"Board member on active volunteer board of directors; participated in committee work, including Equal Pay Coalition NYC, Government Affairs, STAR Breakfast. Worked as liaison between NYWA and LPTW. NYWA is a coalition of women professionals, organizations, and community activists who support the diversity and interests of New York women through collaboration, advocacy, and education"},{"company":{"name":"league of professional theatre women","size":"1-10","id":"league-of-professional-theatre-women","founded":"1980","industry":"entertainment","location":{"name":"new york, new york, united states","locality":"new york","region":"new york","metro":"new york, new york","country":"united states","continent":"north america","street_address":"520 8th avenue","address_line_2":null,"postal_code":"10018","geo":"40.71,-74.00"},"linkedin_url":"linkedin.com/company/league-of-professional-theatre-women","linkedin_id":"3481945","facebook_url":null,"twitter_url":"twitter.com/lptwomen","website":"theatrewomen.org"},"location_names":["new york, new york, united states"],"end_date":"2009-06","start_date":"2006-06","title":{"name":"board member","role":null,"sub_role":null,"levels":["partner"]},"is_primary":false,"summary":"Active board member on volunteer board of directors; participated in committees, including International, Programming, Networking, Membership, Nominations & Election, Advocacy, Short Play Festival. Created and produced NetworkingMondays - a monthly structured-networking event for League members, while on the board. The League of Professional Theatre Women is a not-for-profit organization which promotes visibility and increases opportunities for women in the Professional Theatre, through monthly programs and events."},{"company":{"name":"new york coalition of professional women in the arts & media","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2007-08","start_date":"2002-09","title":{"name":"past president","role":null,"sub_role":null,"levels":["cxo"]},"is_primary":false,"summary":"* Renamed as Women in Arts & Media Coalition (WAMCo).\n* Served as President of board of directors with dozen member organizations, with aggregate membership of 80,000 individuals.\n* Ran monthly board meetings, etc.\n* Produced various networking events."},{"company":{"name":"wamco bsine events","size":null,"id":null,"founded":null,"industry":null,"location":null,"linkedin_url":null,"linkedin_id":null,"facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2006-07","start_date":"1998-06","title":{"name":"event producer","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"Initiated, created, managed, and produced bi-annual networking events for 150 to 250 attendees (usually at The Players club on Gramercy Park in NYC). The Blatant Self-Interest Networking Event (BSINE) included reception, structured networking, and guest speakers. Speakers included: Daryl Roth, Marsha Norman, Barbara Feldon, Estelle Parsons, Hope Clarke, Roma Torre, Judith Crist, Harriet Slaughter, Mari Lyn Henry, Rhonda Schaffler, Emily Mann, and Roni Selig."},{"company":{"name":"new york coalition for women in the arts & media","size":"1-10","id":"new-york-coalition-for-women-in-the-arts-&-media","founded":null,"industry":"entertainment","location":null,"linkedin_url":"linkedin.com/company/new-york-coalition-for-women-in-the-arts-&-media","linkedin_id":"1470564","facebook_url":null,"twitter_url":null,"website":null},"location_names":["new york, new york, united states"],"end_date":"2007-08","start_date":"1993-01","title":{"name":"board member","role":null,"sub_role":null,"levels":["partner"]},"is_primary":false,"summary":"Board member on active volunteer board of directors. Served as liaison between Stage Directors & Choreographers union, and foundation. Initiated programming while on the board, including various networking events, including Blatant Self-Interest Networking Event (BSINE), Speed Networking Event (SNE), Just About Networking event (JAN), and Meet-and-Greets. Served on Executive Committee in various officer positions, including President."},{"company":{"name":"league of professional theatre women","size":"1-10","id":"league-of-professional-theatre-women","founded":"1980","industry":"entertainment","location":{"name":"new york, new york, united states","locality":"new york","region":"new york","metro":"new york, new york","country":"united states","continent":"north america","street_address":"520 8th avenue","address_line_2":null,"postal_code":"10018","geo":"40.71,-74.00"},"linkedin_url":"linkedin.com/company/league-of-professional-theatre-women","linkedin_id":"3481945","facebook_url":null,"twitter_url":"twitter.com/lptwomen","website":"theatrewomen.org"},"location_names":["new york, new york, united states"],"end_date":"2015-03","start_date":"2015-01","title":{"name":"event producer","role":"public_relations","sub_role":"events","levels":[]},"is_primary":false,"summary":"* Day of Producer for the 25 March 2019 Theatre Women Awards – honoring May Adrales, Mari Lyn Henry, Karen Zacarias, Natasha Sinha, Joanne Pottlitzer, Mimi Lien, The Klroys, Graciela Daniele\n* and Nancy Giles, host. Responsibilities included – plan and coordinate structure and logistics with Event Producers/VPs Programming\n* liaison with venue rep, venue coordinator, venue tech, caterer, and VIP wranglers\n* manage volunteer staffing for all depts\n* communicate with emcee, presenters, awardees, awards hostess, SM\n* assign and coordinate tasks with Dept Captains, volunteer staffing & LPTW staff\n* coordinated pick-ups, deliveries, load-in, set-up, tech, rehearsal – managed day's events from pre-show to load-out\n* created documents – Run of Show (ROS), Day of Checklist. Additional pre-production consulting included review of contracts, producer's checklist/timeline, and weekly production calls for two months."}],"education":[{"school":{"name":"vestal sr. high school","type":"secondary school","id":null,"location":null,"linkedin_url":null,"facebook_url":null,"twitter_url":null,"linkedin_id":null,"website":null,"domain":null},"degrees":[],"start_date":null,"end_date":null,"majors":[],"minors":[],"gpa":null,"summary":null},{"school":{"name":"swedish institute a college of health sciences","type":"post-secondary institution","id":"6kOQ6nKfrfxlA-mMWv4XYw_0","location":{"name":"new york, new york, united states","locality":"new york","region":"new york","country":"united states","continent":"north america"},"linkedin_url":"linkedin.com/school/swedish-institute-college-of-health-sciences","facebook_url":null,"twitter_url":null,"linkedin_id":"33679","website":"swedishinstitute.edu","domain":"swedishinstitute.edu"},"end_date":"1982","start_date":"1982","gpa":null,"degrees":[],"majors":[],"minors":[],"summary":null},{"school":{"name":"hamilton college","type":"post-secondary institution","id":"4ZaPcPGyPu5M6pRgHB0woQ_0","location":{"name":"clinton, new york, united states","locality":"clinton","region":"new york","country":"united states","continent":"north america"},"linkedin_url":"linkedin.com/school/hamilton-college","facebook_url":"facebook.com/hamiltoncollege","twitter_url":"twitter.com/hamiltoncollege","linkedin_id":"20051","website":"hamilton.edu","domain":"hamilton.edu"},"end_date":"1979","start_date":"1975","gpa":null,"degrees":[],"majors":["theatre"],"minors":[],"summary":null}],"profiles":[{"network":"linkedin","id":"10907043","url":"linkedin.com/in/melanie-sutherland-b4379b3","username":"melanie-sutherland-b4379b3"},{"network":"facebook","id":"1014775433","url":"facebook.com/melanie.sutherland.12","username":"melanie.sutherland.12"}],"certifications":[],"languages":[],"version_status":{"status":"updated","contains":[],"previous_version":"12.0","current_version":"13.0"}}
 
Какой вес базы?
Если брать только эти 699 архивов (70 процентов от версии 575М, отсутствует 98, 700 и выше .gz архивы) то их размер в сжатом виде виден в торренте - 187 Гб, в расжатом более 1,4 Тб, в mongodb каждая коллекция занимала по 700 Мб значит вышло бы в районе 490 Гб.
В прямом виде экспортировать через Studio3t со всеми полями в виде csv не имеет смысла, part-00414.csv будет весить 5,5 Гб и экспортироваться несколько часов, изза того что некоторые профили имеют до несколько тысяч полей, большинство пустые. Со временем может получится собрать более менее оптимизированную и полную версию.
Вторая часть из базы 700M - это около трех сотен текстовых файлов с расширением .txt, типа part-000 (189).txt , отсутствуют в торренте, некоторые присутствуют на гуглдиске, похожи по формату на присутствующую тут 412М People_Data_Labs, просмотреть и сравнить не смогу изза недостатка реакций, но видел польский кусочек этой базы, одно различие в формате, в текстовиках (a: это location_name), в 412M (a: location_country).
upd : Если кому надо набор мыл из полей emails.0.address,emails.1.address,emails.2.address,emails.3.address
125.527.872 email без проверки на дубликаты , пароль местный, 751 мб в архиве, 3 гб в расжатом,
 
Последнее редактирование:
скоро будут csv или тут или в новой теме, все зависит от времени и ресов ноутбука, и вообще это нужно вам?
сделаю 4 варианта csv от минималки до фулл
 
Последнее редактирование:
Прошу прошения а здесь только РФ?Где можно найти по странам?

Там все страны, приблизительное кол-во под спойлером, погрешность может около тысячи, RF это, как я полагаю форум
Total lines : 401214945

afghanistan_148457
aland_islands_7092
albania_189146
algeria_933540
american_samoa_13679
andorra_21762
angola_240816
anguilla_5898
antarctica_4600
antigua_and_barbuda_16375
argentina_4411323
armenia_98397
aruba_24267
australia_7161755
austria_764863
azerbaijan_193520
bahamas_73683
bahrain_144082
bangladesh_1201140
barbados_56509
belarus_146927
belgium_2528811
belize_29038
benin_108490
bermuda_36906
bhutan_32293
bolivia_415613
bosnia_and_herzegovina_140802
botswana_147268
bouvet_island_248
brazil_25609656
british_indian_ocean_territory_1524.c
british_virgin_islands_4807
brunei_40337
bulgaria_420548
burkina_faso_106795
burundi_26688
cambodia_171522
cameroon_333974
canada_11496136
cape_verde_29893
caribbean_netherlands_142
cayman_islands_22686
central_african_republic_12229
chad_22411
chile_3381843
china_4190023
christmas_island_1130
cocos_islands_549
colombia_4556855
comoros_7103
cook_islands_3081
costa_rica_600445
cote_d_ivoire_382888
croatia_409684
cuba_106225
curacao_2350
cyprus_169422
czechia_1023768
democratic_republic_of_the_congo_2097
denmark_1586427
djibouti_18169
dominica_9351
dominican_republic_435722
ecuador_1425315
egypt_1472609
el_salvador_292353
equatorial_guinea_11970
eritrea_4663
estonia_129265
ethiopia_252900
falkland_islands_727
faroe_islands_9554
fiji_77828
finland_845555
france_12382117
french_guiana_17289
french_polynesia_26113
french_southern_territories_720
gabon_67588
gambia_30864
georgia_2100
germany_6389734
ghana_747914
gibraltar_12191
greece_875931
greenland_9179
grenada_13934
guadeloupe_50241
guam_29462
guatemala_472823
guernsey_12745
guinea-bissau_6105
guinea_59713
guyana_34074
haiti_101719
heard_island_and_mcdonald_islands_247
honduras_251033
hong_kong_963417
hungary_658203
iceland_142975
india_31683435
indonesia_6309570
iran_1753306
iraq_275771
ireland_1325392
isle_of_man_16291
israel_971182
italy_7200470
jamaica_251902
japan_866330
jersey_23140
jordan_356854
kazakhstan_204156
kenya_1225222
kiribati_3975
kosovo_26668
kuwait_273461
kyrgyzstan_32261
laos_40882
latvia_194727
lebanon_334485
lesotho_30257
liberia_45508
libya_86786
liechtenstein_10024
lithuania_261912
luxembourg_158312
macau_43534
macedonia_134511
madagascar_109966
malawi_86750
malaysia_2652560
maldives_49729
mali_95020
malta_119331
marshall_islands_4160
martinique_42350
mauritania_29867
mauritius_129368
mayotte_7383
mexico_8477564
micronesia_5081
moldova_103695
monaco_22250
mongolia_75003
montenegro_67128
montserrat_1259
morocco_1166829
mozambique_168085
myanmar_191939
namibia_118612
nauru_1160
nepal_342264
netherlands_4993601
netherlands_antilles_37733
new_caledonia_32779
new_zealand_1288671
nicaragua_210666
niger_578761
nigeria_2179396
niue_954
no_country_40135098
norfolk_island_849
north_korea_738
northern_mariana_islands_6731
norway_1269609
oman_211135
pakistan_2662875
palau_2641
palestine_98456
panama_403921
papua_new_guinea_100549
paraguay_265280
peru_2761003
philippines_3732416
pitcairn_578
poland_1858196
portugal_1970750
puerto_rico_404406
qatar_358740
republic_of_the_congo_3884
reunion_68300
romania_1414833
russia_1289212
rwanda_106055
saint_barthelemy_93
saint_helena_1090
saint_kitts_and_nevis_8766
saint_lucia_20415
saint_martin_4
saint_pierre_and_miquelon_1201
saint_vincent_and_the_grenadines_1183
samoa_6162
san_marino_6091
sao_tome_and_principe_4078
saudi_arabia_1392694
senegal_313664
serbia_499966
seychelles_13782
sierra_leone_37536
singapore_1554536
sint_maarten_3
slovakia_379571
slovenia_224225
solomon_islands_7989
somalia_45749
south_africa_4659054
south_georgia_and_the_south_sandwich_
south_korea_207092
south_sudan_15174
spain_6989242
sri_lanka_626138
sudan_140841
suriname_38855
svalbard_and_jan_mayen_640
swaziland_33460
sweden_2120273
switzerland_1618675
syria_131039
taiwan_658192
tajikistan_16091
tanzania_375245
thailand_919584
timor-leste_5222
togo_75513
tokelau_599
tonga_5820
trinidad_and_tobago_215579
tunisia_591279
turkey_4420243
turkmenistan_14011
turks_and_caicos_islands_9165
tuvalu_7470
uganda_371317
ukraine_788786
united_arab_emirates_1929628
united_kingdom_18462536
united_states_107760830
uruguay_483043
us_minor_outlying_islands_2
us_virgin_islands_6172
uzbekistan_64470
vanuatu_7905
vatican_city_2166
venezuela_1918155
vietnam_1149979
wallis_and_futuna_1202
western_sahara_1045
yemen_70718
zambia_214448
zimbabwe_329494
Навернулся индекс от коллекции, куда закидывал mongodb, на внешнем харде, заново построить индекс не получалось изза странного отключения сервера каждые несколько минут, удалил этот 500 гиговый файлик, закидываю повторно, уже не в одну коллекцию
 
я имею ввиду както по отдельности нужные страны скачать можно?
Я выложу, не знаю зачем, в одном из файлов part-00231.gz есть какая то ошибка, mongodb закрывает сокет при экспорте из него, попробую разобраться, но главное нашел где проблема, сайт xss.pro не дает мне вставить все поля под спойлером, пишет много,
завтра отредактирую документ, где поставлю диапазоны, а вы напишите какие поля нужны, главное все загружено кроме одного 500 тыс документа, посколько все экспорты будут очень большие, подкиньте мне в лс премиум меги, анонфилес у меня только через тор доступен,гдето месяц мне потребуется
upd: попробую сегодня понять, что не так с документом 231, если кто то найдет в нем отличия, напишите
upd2: месяц назад создал по принципу PDL поля location_country,location_name,emails.0.address,emails.1.address,emails.2.address,emails.3.address,linkedin_username,linkedin_url,full_name
еще и emails.type там было,там плавало около 600 значений, я забраковал,теперь собираюсь это удалить, если это кому нужно, весит это 11 гб,нужен прем меги для залития, все разделено по странам
Fields : 13
01. location_country
02. location_name
03. emails.0.address
04. emails.0.type
05. emails.1.address
06. emails.1.type
07. emails.2.address
08. emails.2.type
09. emails.3.address
10. emails.3.type
11. linkedin_username
12. linkedin_url
13. full_name

Files : 252
Total lines : 401214945

49G .
17M afghanistan_148457.csv
848K aland_islands_7092.csv
19M albania_189146.csv
97M algeria_933540.csv
1,6M american_samoa_13679.csv
2,3M andorra_21762.csv
26M angola_240816.csv
652K anguilla_5898.csv
512K antarctica_4600.csv
2,1M antigua_and_barbuda_16375.csv
520M argentina_4411323.csv
11M armenia_98397.csv
2,6M aruba_24267.csv
949M australia_7161755.csv
85M austria_764863.csv
22M azerbaijan_193520.csv
8,0M bahamas_73683.csv
16M bahrain_144082.csv
130M bangladesh_1201140.csv
6,2M barbados_56509.csv
16M belarus_146927.csv
342M belgium_2528811.csv
3,0M belize_29038.csv
11M benin_108490.csv
4,2M bermuda_36906.csv
3,2M bhutan_32293.csv
47M bolivia_415613.csv
19M bosnia_and_herzegovina_140802.csv
17M botswana_147268.csv
32K bouvet_island_248.csv
3,2G brazil_25609656.csv
232K british_indian_ocean_territory_1524.csv
684K british_virgin_islands_4807.csv
4,1M brunei_40337.csv
48M bulgaria_420548.csv
13M burkina_faso_106795.csv
3,0M burundi_26688.csv
17M cambodia_171522.csv
37M cameroon_333974.csv
1,4G canada_11496136.csv
3,4M cape_verde_29893.csv
24K caribbean_netherlands_142.csv
2,8M cayman_islands_22686.csv
1,8M central_african_republic_12229.csv
2,4M chad_22411.csv
411M chile_3381843.csv
448M china_4190023.csv
140K christmas_island_1130.csv
80K cocos_islands_549.csv
565M colombia_4556855.csv
800K comoros_7103.csv
360K cook_islands_3081.csv
71M costa_rica_600445.csv
47M cote_d_ivoire_382888.csv
44M croatia_409684.csv
11M cuba_106225.csv
272K curacao_2350.csv
19M cyprus_169422.csv
118M czechia_1023768.csv
32M democratic_republic_of_the_congo_209746.csv
195M denmark_1586427.csv
1,9M djibouti_18169.csv
1,0M dominica_9351.csv
58M dominican_republic_435722.csv
160M ecuador_1425315.csv
148M egypt_1472609.csv
35M el_salvador_292353.csv
1,6M equatorial_guinea_11970.csv
512K eritrea_4663.csv
14M estonia_129265.csv
27M ethiopia_252900.csv
96K falkland_islands_727.csv
1,2M faroe_islands_9554.csv
7,7M fiji_77828.csv
105M finland_845555.csv
1,5G france_12382117.csv
2,1M french_guiana_17289.csv
3,2M french_polynesia_26113.csv
108K french_southern_territories_720.csv
7,1M gabon_67588.csv
3,1M gambia_30864.csv
304K georgia_2100.csv
766M germany_6389734.csv
77M ghana_747914.csv
1,4M gibraltar_12191.csv
98M greece_875931.csv
1,0M greenland_9179.csv
1,5M grenada_13934.csv
5,8M guadeloupe_50241.csv
2,9M guam_29462.csv
57M guatemala_472823.csv
1,4M guernsey_12745.csv
864K guinea-bissau_6105.csv
6,2M guinea_59713.csv
3,5M guyana_34074.csv
11M haiti_101719.csv
40K heard_island_and_mcdonald_islands_247.csv
28M honduras_251033.csv
102M hong_kong_963417.csv
73M hungary_658203.csv
17M iceland_142975.csv
3,8G india_31683435.csv
740M indonesia_6309570.csv
172M iran_1753306.csv
26M iraq_275771.csv
147M ireland_1325392.csv
1,8M isle_of_man_16291.csv
105M israel_971182.csv
892M italy_7200470.csv
27M jamaica_251902.csv
97M japan_866330.csv
2,4M jersey_23140.csv
38M jordan_356854.csv
24M kazakhstan_204156.csv
123M kenya_1225222.csv
448K kiribati_3975.csv
2,7M kosovo_26668.csv
29M kuwait_273461.csv
3,7M kyrgyzstan_32261.csv
4,2M laos_40882.csv
21M latvia_194727.csv
35M lebanon_334485.csv
3,3M lesotho_30257.csv
4,8M liberia_45508.csv
8,6M libya_86786.csv
1,2M liechtenstein_10024.csv
31M lithuania_261912.csv
19M luxembourg_158312.csv
4,2M macau_43534.csv
16M macedonia_134511.csv
14M madagascar_109966.csv
9,3M malawi_86750.csv
330M malaysia_2652560.csv
5,3M maldives_49729.csv
9,5M mali_95020.csv
13M malta_119331.csv
516K marshall_islands_4160.csv
4,9M martinique_42350.csv
3,3M mauritania_29867.csv
15M mauritius_129368.csv
812K mayotte_7383.csv
1,0G mexico_8477564.csv
576K micronesia_5081.csv
11M moldova_103695.csv
2,5M monaco_22250.csv
8,5M mongolia_75003.csv
7,9M montenegro_67128.csv
148K montserrat_1259.csv
132M morocco_1166829.csv
19M mozambique_168085.csv
18M myanmar_191939.csv
13M namibia_118612.csv
120K nauru_1160.csv
34M nepal_342264.csv
697M netherlands_4993601.csv
5,2M netherlands_antilles_37733.csv
3,9M new_caledonia_32779.csv
161M new_zealand_1288671.csv
25M nicaragua_210666.csv
61M niger_578761.csv
231M nigeria_2179396.csv
100K niue_954.csv
3,6G no_country_40135098.csv
104K norfolk_island_849.csv
88K north_korea_738.csv
952K northern_mariana_islands_6731.csv
160M norway_1269609.csv
22M oman_211135.csv
308M pakistan_2662875.csv
280K palau_2641.csv
10M palestine_98456.csv
45M panama_403921.csv
12M papua_new_guinea_100549.csv
30M paraguay_265280.csv
321M peru_2761003.csv
458M philippines_3732416.csv
64K pitcairn_578.csv
212M poland_1858196.csv
234M portugal_1970750.csv
48M puerto_rico_404406.csv
38M qatar_358740.csv
556K republic_of_the_congo_3884.csv
7,6M reunion_68300.csv
158M romania_1414833.csv
152M russia_1289212.csv
12M rwanda_106055.csv
16K saint_barthelemy_93.csv
136K saint_helena_1090.csv
1,2M saint_kitts_and_nevis_8766.csv
2,4M saint_lucia_20415.csv
4,0K saint_martin_4.csv
176K saint_pierre_and_miquelon_1201.csv
1,9M saint_vincent_and_the_grenadines_11830.csv
640K samoa_6162.csv
716K san_marino_6091.csv
608K sao_tome_and_principe_4078.csv
165M saudi_arabia_1392694.csv
32M senegal_313664.csv
53M serbia_499966.csv
1,6M seychelles_13782.csv
4,4M sierra_leone_37536.csv
167M singapore_1554536.csv
4,0K sint_maarten_3.csv
43M slovakia_379571.csv
24M slovenia_224225.csv
968K solomon_islands_7989.csv
4,8M somalia_45749.csv
636M south_africa_4659054.csv
4,0K south_georgia_and_the_south_sandwich_islands_16.csv
23M south_korea_207092.csv
1,7M south_sudan_15174.csv
893M spain_6989242.csv
73M sri_lanka_626138.csv
14M sudan_140841.csv
4,3M suriname_38855.csv
92K svalbard_and_jan_mayen_640.csv
3,8M swaziland_33460.csv
269M sweden_2120273.csv
210M switzerland_1618675.csv
13M syria_131039.csv
68M taiwan_658192.csv
1,9M tajikistan_16091.csv
40M tanzania_375245.csv
116M thailand_919584.csv
628K timor-leste_5222.csv
7,5M togo_75513.csv
64K tokelau_599.csv
600K tonga_5820.csv
28M trinidad_and_tobago_215579.csv
63M tunisia_591279.csv
492M turkey_4420243.csv
1,7M turkmenistan_14011.csv
1,3M turks_and_caicos_islands_9165.csv
904K tuvalu_7470.csv
39M uganda_371317.csv
85M ukraine_788786.csv
268M united_arab_emirates_1929628.csv
2,5G united_kingdom_18462536.csv
15G united_states_107760830.csv
54M uruguay_483043.csv
4,0K us_minor_outlying_islands_2.csv
852K us_virgin_islands_6172.csv
7,4M uzbekistan_64470.csv
836K vanuatu_7905.csv
260K vatican_city_2166.csv
234M venezuela_1918155.csv
113M vietnam_1149979.csv
156K wallis_and_futuna_1202.csv
140K western_sahara_1045.csv
7,1M yemen_70718.csv
22M zambia_214448.csv
37M zimbabwe_329494.csv
с моим гигабитным каналом могу залить хоть куда,накидайте в лс хоть мегу, можно гугл яндекс, будете сами распоряжаться

mongorestore выявил еще 2 документа которые не может экспортировать, в выходные попробую уже экспорт, извините,
старые данные с прошлого поста могу залить на вами предоставленный фо
 
Последнее редактирование:
Всем привет. Сделал первую выборку, самую маленькую, но даже при этом, весит она уже под 70 гб.
Попробую разные фо, поищу, на котором реже удаляют, у себя обычно удаляю, изза нехватки места.
Сейчас оптимизирую ее, поэтому появился вопрос. Помимо полей "work_email", и "mobile_phone",
есть 14 почтовых колонок и 8 телефонных, естественно, большинство из них очень слабо заполнены,
в каком варианте лучше их сделать ?
1. В массивах, будет поле "email_all" с значением типа ['первая почта','вторая почта']
2. В одном поле, но просто через запятую, в общих двойных кавычках "первая почта, вторая почта"
3. В разных полях, 22 поля в начале или конце.
 


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