Ryan (ryan@themedialab.agency)
2025-04-09 12:32:58

Be right on, give me about five minutes

👍 Zekarias Haile
Ryan (ryan@themedialab.agency)
2025-04-30 11:33:47

- Verticals to ldpverticals table in AWS_ - Cost Per Intakes Month Roll Forward

Ryan (ryan@themedialab.agency)
2025-04-30 11:34:59

SELECT ** FROM public.casetypecccosts WHERE monthend BETWEEN '2025-04-01' AND '2025-05-01' --AND casetype ILIKE '%Polin%' ORDER BY casetype, monthend ASC;

Ryan (ryan@themedialab.agency)
2025-04-30 11:40:03

('2025-05-01' , '3M' , '153.345425'), ('2025-05-01' , 'Adult Survivors Act' , '9.83792304'), ('2025-05-01' , 'Adventist School Sexual Abuse' , '0'), ('2025-05-01' , 'Apple Cider Vinegar Class Action' , '0'), ('2025-05-01' , 'Arizona Juvenile Hall Abuse' , '25'), ('2025-05-01' , 'Arizona Youth Treatment Abuse' , '25'), ('2025-05-01' , 'Asbestos' , '70.5909523809524'), ('2025-05-01' , 'Aunt Marthas Integrated Care Abuse' , '25'), ('2025-05-01' , 'Baltimore MD Clergy Sex Abuse' , '144.590303'), ('2025-05-01' , 'Bard Powerport Catheter' , '115.99414634146'), ('2025-05-01' , 'Bayview Sexual Abuse' , '169.366667'), ('2025-05-01' , 'Birth Injury' , '58.76923076923'), ('2025-05-01' , 'Black Owned Business Justice' , '158.844444'), ('2025-05-01' , 'Button Batteries' , '1.57016780046667'), ('2025-05-01' , 'CA Juvenile Hall Detention' , '41.3998050066667'), ('2025-05-01' , 'California Institute for Women' , '74.3468827'), ('2025-05-01' , 'California Life Insurance Lapse' , '25'), ('2025-05-01' , 'California School Sexual Abuse' , '25'), ('2025-05-01' , 'Camp Lejeune' , '0'), ('2025-05-01' , 'Camp Lejeune BP' , '0'), ('2025-05-01' , 'Camp Lejeune DLG/TC' , '0'), ('2025-05-01' , 'Camp Lejeune DLG/TC/BCL' , '0'), ('2025-05-01' , 'Chowchilla Womens Prison Abuse' , '65.84630461923'), ('2025-05-01' , 'Clergy Abuse' , '17.1496296'), ('2025-05-01' , 'Colorado Center For Blind Sexual' , '25'), ('2025-05-01' , 'CPAP Ventilator Recall' , '45.4651558220455'), ('2025-05-01' , 'Cumberland Hospital Abuse' , '86.26166666667'), ('2025-05-01' , 'Dacthal' , '21.3551336898396'), ('2025-05-01' , 'Depo Provera' , '23.94'), ('2025-05-01' , 'Dr Barry Brock Abuse' , '29.14191489362'), ('2025-05-01' , 'Dr Scott Lee Abuse' , ''), ('2025-05-01' , 'Dublin Correctional Institute Abuse' , '57.63334415584'), ('2025-05-01' , 'Ethylene Oxide' , '208.515229356'), ('2025-05-01' , 'Eye Drop infection' , '37.8130915'), ('2025-05-01' , 'Female NY Correctional Abuse' , '26.5454545'), ('2025-05-01' , 'Firefighting Foam' , ''), ('2025-05-01' , 'First Responder Accidents' , '63.4551724'), ('2025-05-01' , 'Gaming Addiction' , '106.94186138614'), ('2025-05-01' , 'Group Homes Children Centers Abuse' , '137.016667'), ('2025-05-01' , 'Hair Relaxer Uterine Cancer' , '47.05063291139'), ('2025-05-01' , 'Healthcare Data Breach' , '25'), ('2025-05-01' , 'Human Sex Trafficking' , '11.95654315'), ('2025-05-01' , 'Hurricane Damage' , '25'), ('2025-05-01' , 'Illinois Catholic Clergy Abuse' , '10.8916535675556'), ('2025-05-01' , 'Illinois Foster Care Abuse' , '74.05'), ('2025-05-01' , 'Illinois Juvenile Hall Abuse' , '89.51587692308'), ('2025-05-01' , 'Illinois Youth Treatment Abuse' , '70.17734177215'), ('2025-05-01' , 'Instant Soup Cup Child Burns' , ''), ('2025-05-01' , 'Intuit Privacy Lawsuit' , '0'), ('2025-05-01' , 'JROTC Abuse' , '25.2087277'), ('2025-05-01' , 'LA County Foster Care Abuse' , '76.4'), ('2025-05-01' , 'LA Juvenile Hall Abuse TV' , '80.06275395'), ('2025-05-01' , 'LA Wildfires' , ''), ('2025-05-01' , 'Liquid Destroyed Embryo' , '11.8961402359211'), ('2025-05-01' , 'Los Padrinos Juv Hall Abuse' , '29.91147398844'), ('2025-05-01' , 'Maryland Juvenile Hall Abuse' , '163.16017441861'), ('2025-05-01' , 'Maryland School Sex Abuse' , '26.5204522'), ('2025-05-01' , 'MD Juvenile Hall Abuse BG TV' , '159.345070422535'), ('2025-05-01' , 'MD Juvenile Hall Abuse DL TV' , '159.345070422535'), ('2025-05-01' , 'MD Juvenile Hall Abuse SSS TV' , '159.345070422535'), ('2025-05-01' , 'Michigan Juvenile Hall Abuse' , '102.00625'), ('2025-05-01' , 'Michigan Pollution' , ''), ('2025-05-01' , 'Michigan Youth Treatment Abuse' , '26.81280701754'), ('2025-05-01' , 'Mortgage Race Lawsuit' , '20.1428463476071'), ('2025-05-01' , 'NEC Baby Formula' , '63.61164473684'), ('2025-05-01' , 'Nevada Juvenile Hall Abuse' , '20.15631578947'), ('2025-05-01' , 'New Jersey Juvenile Detention Abuse' , '164.30679012346'), ('2025-05-01' , 'NH Youth Center Abuse' , '96.62061538462'), ('2025-05-01' , 'Nursing Home Abuse Litigation' , '119.742824667564'), ('2025-05-01' , 'NYC Private School Abuse' , '25'), ('2025-05-01' , 'Ohio Inspection Lawsuit' , '25'), ('2025-05-01' , 'Oxbryta' , '11.2154842890476'), ('2025-05-01' , 'Ozempic' , '50.375'), ('2025-05-01' , 'Paraquat' , '163.47625'), ('2025-05-01' , 'Patient Portal Data Privacy' , '30.2602564'), ('2025-05-01' , 'Pennsylvania Juvenile Hall Abuse' , '66.33440677966'), ('2025-05-01' , 'PFAS Water Contamination' , '47.814641957811'), ('2025-05-01' , 'Polinsky Childrens Center Abuse' , '22.8144444444444'), ('2025-05-01' , 'Psychiatric Facility Abuse' , '25'), ('2025-05-01' , 'Round Up' , '0'), ('2025-05-01' , 'Tough Mudder Illness' , ''), ('2025-05-01' , 'Toxic Baby Food' , '57.03614'), ('2025-05-01' , 'Tylenol Autism Link' , '28.3335526'), ('2025-05-01' , 'Type 2 Child Diabetes' , '175.50142857143'), ('2025-05-01' , 'Video Gaming Sextortion' , '71.7721428571429'), ('2025-05-01' , 'Wood Pellet Lawsuits' , '98.75626865672'), ('2025-05-01' , 'Youth Treatment Center Abuse' , '0'),

Ryan (ryan@themedialab.agency)
2025-04-30 11:42:16
image.png
Ryan (ryan@themedialab.agency)
2025-04-30 11:43:47

San Bernardino Juv Detention Abuse

Ryan (ryan@themedialab.agency)
2025-04-30 11:44:55

Transvaginal Mesh

Ryan (ryan@themedialab.agency)
2025-04-30 11:45:29

@Zekarias Haile

image.png
Ryan (ryan@themedialab.agency)
2025-04-30 11:46:27

Mormon Victim Abuse

Ryan (ryan@themedialab.agency)
2025-04-30 11:46:38

San Diego Juv Detention YRTC Abuse

Ryan (ryan@themedialab.agency)
2025-04-30 11:46:54

Conyers Biolab Explosion

Ryan (ryan@themedialab.agency)
2025-04-30 11:47:17

Hair Salon Bladder Cancer

Zekarias Haile (zhaile@shield-legal.com)
2025-04-30 12:00:17

@Ryan the video is not opening

Ryan (ryan@themedialab.agency)
2025-04-30 12:25:36

https://app.fireflies.ai/view/01JT1E51Q3MH845YZXN6RWNMRK

Fireflies.ai
SL Database Maintenance - Meeting recording by Fireflies.ai
The meeting focused on database maintenance and updates for financial reporting accuracy, including new verticals and error correction.
Original URL: https://app.fireflies.ai/view/01JT1E51Q3MH845YZXN6RWNMRK
Ryan (ryan@themedialab.agency)
2025-05-07 14:45:58

Here is the Meeitng notes @Nicholas McFadden and @Zekarias Haile https://app.fireflies.ai/view/01JTGXZF8MJYAQXJNHPDY7XCYJ

Fireflies.ai
SL BI Sprint Priorites - Meeting recording by Fireflies.ai
The meeting focused on addressing technical integration challenges and financial modeling requirements for the SHIELD project.
Original URL: https://app.fireflies.ai/view/01JTGXZF8MJYAQXJNHPDY7XCYJ
👍:skin_tone_3: Zekarias Haile
🙏 Nicholas McFadden
Ryan (ryan@themedialab.agency)
2025-05-30 09:52:32

Morning, here is the Step 1 of updating Shield old system EOM to fill up new verticals from LP to the table with default $25.00 cost per sold lead to call center: https://www.loom.com/share/30e2f8a7bba945f0bdbf3afa88044856

Ryan (ryan@themedialab.agency)
2025-05-30 09:52:34

Morning, here is the Step 1 of updating Shield old system EOM to fill up new verticals from LP to the table with default $25.00 cost per sold lead to call center: https://www.loom.com/share/30e2f8a7bba945f0bdbf3afa88044856

Zekarias Haile (zhaile@shield-legal.com)
2025-05-30 09:57:02

Thanks Ryan!

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-05-30 09:59:37

Thanks

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-05-30 09:59:57

Are we still hoping on the call or no?

Ryan (ryan@themedialab.agency)
2025-05-30 10:01:15

Step 2: Bulk Inserts for June 2025: https://www.loom.com/share/381b61cbfb2b44a5bac4a7b1bf730950

Ryan (ryan@themedialab.agency)
2025-05-30 10:01:18

Step 2: Bulk Inserts for June 2025: https://www.loom.com/share/381b61cbfb2b44a5bac4a7b1bf730950

Ryan (ryan@themedialab.agency)
2025-05-30 10:08:57

And you can see we have June 2025 ready:

SELECT ** FROM public.casetype_cc_costs WHERE month_end BETWEEN '2025-05-01' AND '2025-06-01' ORDER BY case_type, month_end ASC;

🙏:skin_tone_3: Zekarias Haile