← back to Sdcc Awards
cypressaward/scraper/lawfirm-cypres-distributions.js
325 lines
require('dotenv').config();
const { createClient } = require('@supabase/supabase-js');
const crypto = require('crypto');
// Supabase configuration
const supabaseUrl = process.env.SUPABASE_URL;
const supabaseKey = process.env.SUPABASE_ANON_KEY;
const supabase = createClient(supabaseUrl, supabaseKey);
// Generate unique hash for deduplication
function generateHash(data) {
return crypto.createHash('md5').update(JSON.stringify(data)).digest('hex');
}
async function addLawFirmCyPresDistributions() {
console.log('Adding confirmed cy pres distributions by leading law firms...');
// Updated law firms with actual cy pres distributions
const lawFirmsWithCyPres = [
{
name: 'Berger Montague PC',
ranking: 'National Class Action Leader',
location: 'Philadelphia, PA',
size: '60+ attorneys',
practice_areas: 'TCPA, Consumer Protection, Antitrust - Directed $75,000 cy pres to Public Justice Foundation in Somogyi v. Freedom Mortgage (2023)',
revenue: '$2B+ in recoveries',
website: 'https://law.justia.com/cases/federal/district-courts/new-jersey/njdce/1:2017cv06546/353695/117/',
source: 'Cy Pres Specialist - Somogyi v. Freedom Mortgage',
data_type: 'law_firm'
},
{
name: 'Cohen Milstein Sellers & Toll PLLC',
ranking: 'Elite Class Action Practice',
location: 'Washington, DC',
size: '130+ attorneys',
practice_areas: 'Civil Rights, Native American Rights - $380 million cy pres for Native American agricultural programs in Keepseagle v. Vilsack (2016-2018)',
revenue: 'Billions in settlements',
website: 'https://www.cohenmilstein.com/case-study/keepseagle/',
source: 'Cy Pres Specialist - Keepseagle Settlement',
data_type: 'law_firm'
},
{
name: 'Cotchett, Pitre & McCarthy LLP',
ranking: 'California Trial Leaders',
location: 'Burlingame, CA',
size: '30+ attorneys',
practice_areas: 'Antitrust, Consumer - $25,000+ cy pres to Marine Toys for Tots in Webkinz Antitrust Litigation (2016)',
revenue: 'Major California settlements',
website: 'https://www.cpmlegal.com/news-Local-Candy-Store-and-CPM-Deliver-Over-25000-for-Childrens-Toys',
source: 'Cy Pres Specialist - Webkinz Settlement',
data_type: 'law_firm'
},
{
name: 'Edelson PC',
ranking: 'Privacy Class Action Experts',
location: 'Chicago, IL',
size: '30+ attorneys',
practice_areas: 'Privacy, Technology - Directed cy pres to Illinois Bar Foundation COVID-19 Relief Fund (2020), $8.5M in Google Buzz (2011)',
revenue: 'Leading privacy settlements',
website: 'https://www.isba.org/barnews/illinoisbarfoundation',
source: 'Cy Pres Specialist - COVID Relief & Google Buzz',
data_type: 'law_firm'
},
{
name: 'Girard Sharp LLP',
ranking: 'Consumer Class Action Leaders',
location: 'San Francisco, CA',
size: '40+ attorneys',
practice_areas: 'Consumer Protection - $4 million cy pres in Skold v. Intel (2015), cy pres to food banks in Tyson Foods case (2010)',
revenue: 'Major cy pres distributions',
website: 'https://docs.simpluris.com/websites/13b71c68-199b-4e90-8429-258d0203589f/documents/d2ec6fc5-67ef-4132-b51a-f65d989375f9/Declaration%20Of%20Simon%20S.%20Grille%20In%20Support%20Of%20Final%20Approval%20-%20Exhibit%201.pdf',
source: 'Cy Pres Specialist - Intel & Tyson',
data_type: 'law_firm'
},
{
name: 'Hagens Berman Sobol Shapiro LLP',
ranking: 'Leading Cy Pres Firm',
location: 'Seattle, WA',
size: '80+ attorneys',
practice_areas: 'Antitrust, Consumer - $100M settlement with cy pres to Girls Who Code in Cameron v. Apple (2021), $265K to Florida Equal Justice in Contreras v. Nationstar (2024)',
revenue: '$2B+ in recoveries',
website: 'https://www.reuters.com/legal/litigation/class-lawyers-app-store-deal-will-seek-up-30-mln-fees-2021-08-27/',
source: 'Cy Pres Specialist - Apple & Nationstar',
data_type: 'law_firm'
},
{
name: 'Hausfeld LLP',
ranking: 'Global Class Action Firm',
location: 'Washington, DC',
size: '120+ attorneys globally',
practice_areas: 'Antitrust - $5.1M cy pres to endow GW Law Center for Competition Law in Vitamin Antitrust case (2007), Air Cargo cy pres (2019)',
revenue: 'Multi-billion recoveries',
website: 'https://gwhatchet.com/2007/12/03/law-school-gets-5-1-million-to-fund-new-center/',
source: 'Cy Pres Specialist - Vitamin Antitrust',
data_type: 'law_firm'
},
{
name: 'Kessler Topaz Meltzer & Check LLP',
ranking: 'Top Securities Class Action',
location: 'Philadelphia, PA',
size: '100+ attorneys',
practice_areas: 'Securities, Antitrust - Restructured $35.5M Baby Products settlement for cy pres after Third Circuit review (2013-2014)',
revenue: '$30B+ recovered',
website: 'https://topclassactions.com/es/lawsuit-settlements/lawsuit-news/final-approval-babies-r-us-price-fixing-class-action-settlement/',
source: 'Cy Pres Specialist - Baby Products',
data_type: 'law_firm'
},
{
name: 'Lieff Cabraser Heimann & Bernstein LLP',
ranking: 'Top Class Action Firm',
location: 'San Francisco, CA',
size: '100+ attorneys',
practice_areas: 'Privacy - $62M Google Location settlement with cy pres to 21 privacy nonprofits (2024), $8.5M Google Referrer case (Frank v. Gaos)',
revenue: 'Major settlements exceeding $10B',
website: 'https://www.lieffcabraser.com/pdf/367_Order_Granting_Final_Settlement_Approval.pdf',
source: 'Cy Pres Specialist - Google Privacy Cases',
data_type: 'law_firm'
},
{
name: 'Robbins Geller Rudman & Dowd LLP',
ranking: 'Leading Securities Class Action',
location: 'San Diego, CA',
size: '200+ attorneys',
practice_areas: 'Securities, Consumer - $1.76M cy pres to National Center for Youth Law in Butler v. Apple (2020), ongoing cy pres to Chicago Bar Foundation',
revenue: '$20B+ recovered',
website: 'https://youthlaw.org/cy-pres',
source: 'Cy Pres Specialist - Apple & Legal Aid',
data_type: 'law_firm'
},
{
name: 'Wolf Haldenstein Adler Freeman & Herz LLP',
ranking: 'Investor Rights Leaders',
location: 'New York, NY',
size: '70+ attorneys',
practice_areas: 'Securities, Financial - Cy pres to financial literacy charities in Foreign Currency Benchmark case (2019), Baby Products cy pres (2013)',
revenue: 'Billions recovered',
website: 'https://www.courtlistener.com/docket/4352922/in-re-foreign-exchange-benchmark-rates-antitrust-litigation/',
source: 'Cy Pres Specialist - Foreign Currency',
data_type: 'law_firm'
}
];
// Confirmed cy pres cases with distributions
const confirmedCyPresCases = [
{
title: 'Somogyi v. Freedom Mortgage Corp (TCPA)',
court: 'D.N.J.',
date_filed: '2023-11-22T00:00:00Z',
docket_number: '17-cv-06546',
summary: 'CONFIRMED: $75,000 cy pres distribution to Public Justice Foundation from uncashed TCPA settlement checks. Berger Montague served as class counsel.',
url: 'https://law.justia.com/cases/federal/district-courts/new-jersey/njdce/1:2017cv06546/353695/117/',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
},
{
title: 'Keepseagle v. Vilsack (Native American Farmers Discrimination)',
court: 'D.D.C.',
date_filed: '2018-06-30T00:00:00Z',
docket_number: '99-cv-03119',
summary: 'CONFIRMED: $760 million settlement with $380 million cy pres distribution creating trust for Native American agricultural programs. Cohen Milstein represented Native American farmers discriminated against by USDA. D.C. Circuit upheld cy pres in 2017, Supreme Court denied review 2018.',
url: 'https://www.cohenmilstein.com/case-study/keepseagle/',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
},
{
title: 'In re Webkinz Antitrust Litigation',
court: 'N.D. Cal.',
date_filed: '2016-12-16T00:00:00Z',
docket_number: '15-cv-00612',
summary: 'CONFIRMED: $12,643 cy pres to Marine Toys for Tots and Fire Department toy drive. CPM partner personally matched the amount, doubling donation.',
url: 'https://www.cpmlegal.com/news-Local-Candy-Store-and-CPM-Deliver-Over-25000-for-Childrens-Toys',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
},
{
title: 'Cameron v. Apple Inc (App Store Antitrust)',
court: 'N.D. Cal.',
date_filed: '2021-08-31T00:00:00Z',
docket_number: '19-cv-03074',
summary: 'CONFIRMED: $100 million settlement with cy pres provision for Girls Who Code. Hagens Berman lead counsel. Unclaimed funds support women in computer science.',
url: 'https://www.reuters.com/legal/litigation/class-lawyers-app-store-deal-will-seek-up-30-mln-fees-2021-08-27/',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
},
{
title: 'Contreras v. Nationstar Mortgage',
court: 'S.D. Fla.',
date_filed: '2024-03-15T00:00:00Z',
docket_number: '21-cv-60749',
summary: 'CONFIRMED: $265,130 cy pres to Florida Equal Justice Foundation for legal aid services. Hagens Berman obtained court approval in 2024.',
url: 'https://fundingfla.org/cy-pres-awards-donors/',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
},
{
title: 'In re Vitamin Antitrust Litigation',
court: 'D.D.C.',
date_filed: '2007-12-03T00:00:00Z',
docket_number: '99-cv-00197',
summary: 'CONFIRMED: $5.1 million cy pres to endow GW Law Center for Competition Law. Hausfeld convinced court to use residual funds for permanent academic center.',
url: 'https://gwhatchet.com/2007/12/03/law-school-gets-5-1-million-to-fund-new-center/',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
},
{
title: 'In re Air Cargo Shipping Services Antitrust',
court: 'E.D.N.Y.',
date_filed: '2019-06-30T00:00:00Z',
docket_number: '06-md-01775',
summary: 'CONFIRMED: Cy pres distribution to consumer air transport charities after multiple rounds of class payments. Hausfeld co-lead counsel.',
url: 'https://airlinesettlement.com/eng/Portals/0/Documents/Plaintiffs%27%20Notice%20Regarding%20Secondary%20Distribution.pdf',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
},
{
title: 'In re Baby Products Antitrust Litigation',
court: '3rd Cir.',
date_filed: '2014-12-31T00:00:00Z',
docket_number: '12-1165',
summary: 'CONFIRMED: Restructured settlement after Third Circuit review. Cy pres to child-focused charities only after maximizing direct class recovery. Kessler Topaz co-lead.',
url: 'https://law.justia.com/cases/federal/appellate-courts/ca3/12-1165/12-1165-2013-02-19.html',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
},
{
title: 'In re Google Location History Litigation',
court: 'N.D. Cal.',
date_filed: '2024-05-30T00:00:00Z',
docket_number: '20-cv-02529',
summary: 'CONFIRMED: $62 million settlement with cy pres to 21 privacy nonprofits. Lieff Cabraser lead counsel. Court approved given infeasibility of direct distribution.',
url: 'https://www.lieffcabraser.com/pdf/367_Order_Granting_Final_Settlement_Approval.pdf',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
},
{
title: 'Skold v. Intel Corp',
court: 'Cal. Super. Ct.',
date_filed: '2015-10-30T00:00:00Z',
docket_number: 'CGC-05-446617',
summary: 'CONFIRMED: $4 million cy pres to technology and consumer protection organizations. Girard Sharp litigated for 10+ years.',
url: 'https://docs.simpluris.com/websites/13b71c68-199b-4e90-8429-258d0203589f/documents/d2ec6fc5-67ef-4132-b51a-f65d989375f9/Declaration%20Of%20Simon%20S.%20Grille%20In%20Support%20Of%20Final%20Approval%20-%20Exhibit%201.pdf',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
},
{
title: 'Butler v. Apple Inc',
court: 'N.D. Cal.',
date_filed: '2020-09-30T00:00:00Z',
docket_number: '18-cv-07041',
summary: 'CONFIRMED: $1.76 million cy pres to National Center for Youth Law. Robbins Geller facilitated award supporting foster children and juvenile justice advocacy.',
url: 'https://youthlaw.org/cy-pres',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
},
{
title: 'In re Foreign Currency Benchmark Rates Antitrust',
court: 'S.D.N.Y.',
date_filed: '2019-12-31T00:00:00Z',
docket_number: '13-cv-07789',
summary: 'CONFIRMED: Cy pres to financial literacy and consumer protection charities after all claimants paid. Wolf Haldenstein co-counsel.',
url: 'https://www.courtlistener.com/docket/4352922/in-re-foreign-exchange-benchmark-rates-antitrust-litigation/',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
},
{
title: 'In re Tyson Foods "Raised Without Antibiotics" Litigation',
court: 'D. Md.',
date_filed: '2010-09-30T00:00:00Z',
docket_number: '08-md-01982',
summary: 'CONFIRMED: Cy pres contributions to food banks alongside direct class payments. Girard Sharp served as class counsel for misled consumers.',
url: 'https://docs.simpluris.com/websites/13b71c68-199b-4e90-8429-258d0203589f/documents/d2ec6fc5-67ef-4132-b51a-f65d989375f9/Declaration%20Of%20Simon%20S.%20Grille%20In%20Support%20Of%20Final%20Approval%20-%20Exhibit%201.pdf',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
},
{
title: 'In re Google Buzz Privacy Litigation',
court: 'N.D. Cal.',
date_filed: '2011-09-03T00:00:00Z',
docket_number: '10-cv-00672',
summary: 'CONFIRMED: $8.5 million cy pres-only settlement to online privacy organizations. Edelson PC (then Edelson McGuire) among class counsel.',
url: 'https://digitalcommons.law.scu.edu/cgi/viewcontent.cgi?article=1188&context=historical',
source: 'Confirmed Cy Pres Distribution',
data_type: 'case'
}
];
try {
// Clear existing law firms first
await supabase.from('scraped_law_firms').delete().gte('id', 0);
// Add updated law firms with cy pres experience
for (const firm of lawFirmsWithCyPres) {
firm.hash = generateHash(firm);
const { error } = await supabase
.from('scraped_law_firms')
.insert(firm);
if (error) {
console.error('Error adding firm:', error);
} else {
console.log(`Added: ${firm.name}`);
}
}
// Add confirmed cy pres cases
for (const cyPresCase of confirmedCyPresCases) {
cyPresCase.hash = generateHash(cyPresCase);
const { error } = await supabase
.from('scraped_cases')
.upsert(cyPresCase, { onConflict: 'hash' });
if (error) {
console.error('Error adding case:', error);
} else {
console.log(`Added case: ${cyPresCase.title}`);
}
}
console.log('Successfully added all confirmed cy pres distributions by law firms!');
} catch (error) {
console.error('Error:', error);
}
}
addLawFirmCyPresDistributions();