{"rows":[{"practiceId":1,"practiceName":"Westwood Animal Hospital","practiceCity":"New Orville","practiceState":"PA","referralCount":745,"completedCount":559,"lostCount":119,"noShowCount":37,"declinedCount":30,"leakagePct":0.1597315436241611,"estLostRevenueCents":26180000},{"practiceId":31,"practiceName":"Goyette  Bartell Animal Hospital","practiceCity":"West Madilyn","practiceState":"PA","referralCount":46,"completedCount":31,"lostCount":6,"noShowCount":7,"declinedCount":2,"leakagePct":0.13043478260869565,"estLostRevenueCents":1320000},{"practiceId":109,"practiceName":"Adams  Lowe Animal Hospital","practiceCity":"West Vanessacester","practiceState":"PA","referralCount":46,"completedCount":34,"lostCount":6,"noShowCount":6,"declinedCount":0,"leakagePct":0.13043478260869565,"estLostRevenueCents":1320000},{"practiceId":15,"practiceName":"Little Thompson and Nitzsche Animal Hospital","practiceCity":"West Jacey","practiceState":"PA","referralCount":33,"completedCount":28,"lostCount":5,"noShowCount":0,"declinedCount":0,"leakagePct":0.15151515151515152,"estLostRevenueCents":1100000},{"practiceId":37,"practiceName":"Ziemann Champlin and Flatley Animal Hospital","practiceCity":"Greenwood","practiceState":"OH","referralCount":28,"completedCount":22,"lostCount":5,"noShowCount":1,"declinedCount":0,"leakagePct":0.17857142857142858,"estLostRevenueCents":1100000},{"practiceId":42,"practiceName":"Keeling and Sons Animal Hospital","practiceCity":"Bayerstead","practiceState":"PA","referralCount":42,"completedCount":32,"lostCount":5,"noShowCount":4,"declinedCount":1,"leakagePct":0.11904761904761904,"estLostRevenueCents":1100000},{"practiceId":43,"practiceName":"Predovic  Fritsch Animal Hospital","practiceCity":"Andreastead","practiceState":"PA","referralCount":26,"completedCount":19,"lostCount":5,"noShowCount":2,"declinedCount":0,"leakagePct":0.19230769230769232,"estLostRevenueCents":1100000},{"practiceId":58,"practiceName":"Conroy Collier and Dibbert Animal Hospital","practiceCity":"Port Harold","practiceState":"PA","referralCount":25,"completedCount":17,"lostCount":5,"noShowCount":3,"declinedCount":0,"leakagePct":0.2,"estLostRevenueCents":1100000},{"practiceId":80,"practiceName":"HoppeBosco VonRueden and Goldner Animal Hospital","practiceCity":"New Malika","practiceState":"OH","referralCount":39,"completedCount":27,"lostCount":5,"noShowCount":6,"declinedCount":1,"leakagePct":0.1282051282051282,"estLostRevenueCents":1100000},{"practiceId":82,"practiceName":"Howell Kunde and Jakubowski Animal Hospital","practiceCity":"Boca Raton","practiceState":"PA","referralCount":32,"completedCount":21,"lostCount":5,"noShowCount":6,"declinedCount":0,"leakagePct":0.15625,"estLostRevenueCents":1100000},{"practiceId":96,"practiceName":"Marvin LLC Animal Hospital","practiceCity":"Clarktown","practiceState":"PA","referralCount":48,"completedCount":36,"lostCount":5,"noShowCount":6,"declinedCount":1,"leakagePct":0.10416666666666667,"estLostRevenueCents":1100000},{"practiceId":98,"practiceName":"Greenfelder  Marquardt Animal Hospital","practiceCity":"North Diannaland","practiceState":"PA","referralCount":39,"completedCount":29,"lostCount":5,"noShowCount":3,"declinedCount":2,"leakagePct":0.1282051282051282,"estLostRevenueCents":1100000},{"practiceId":102,"practiceName":"CrooksGleichner LLC Animal Hospital","practiceCity":"New Marioboro","practiceState":"OH","referralCount":35,"completedCount":27,"lostCount":5,"noShowCount":3,"declinedCount":0,"leakagePct":0.14285714285714285,"estLostRevenueCents":1100000},{"practiceId":104,"practiceName":"Schmeler  Larkin Animal Hospital","practiceCity":"Stammchester","practiceState":"OH","referralCount":31,"completedCount":23,"lostCount":5,"noShowCount":3,"declinedCount":0,"leakagePct":0.16129032258064516,"estLostRevenueCents":1100000},{"practiceId":4,"practiceName":"Lang Greenholt and Terry Animal Hospital","practiceCity":"Rancho Palos Verdes","practiceState":"OH","referralCount":35,"completedCount":25,"lostCount":4,"noShowCount":3,"declinedCount":3,"leakagePct":0.11428571428571428,"estLostRevenueCents":880000},{"practiceId":7,"practiceName":"OConner Howe and Renner Animal Hospital","practiceCity":"Chadport","practiceState":"OH","referralCount":35,"completedCount":25,"lostCount":4,"noShowCount":5,"declinedCount":1,"leakagePct":0.11428571428571428,"estLostRevenueCents":880000},{"practiceId":9,"practiceName":"Mueller  Friesen Animal Hospital","practiceCity":"South Domingoview","practiceState":"PA","referralCount":36,"completedCount":25,"lostCount":4,"noShowCount":5,"declinedCount":2,"leakagePct":0.1111111111111111,"estLostRevenueCents":880000},{"practiceId":20,"practiceName":"Waters Cummings and WalkerKris Animal Hospital","practiceCity":"Turnerfurt","practiceState":"OH","referralCount":39,"completedCount":30,"lostCount":4,"noShowCount":4,"declinedCount":1,"leakagePct":0.10256410256410256,"estLostRevenueCents":880000},{"practiceId":40,"practiceName":"Jacobs Group Animal Hospital","practiceCity":"Fort Judd","practiceState":"OH","referralCount":41,"completedCount":34,"lostCount":4,"noShowCount":2,"declinedCount":1,"leakagePct":0.0975609756097561,"estLostRevenueCents":880000},{"practiceId":47,"practiceName":"Champlin Ondricka and Corkery Animal Hospital","practiceCity":"Kelsiehaven","practiceState":"OH","referralCount":28,"completedCount":20,"lostCount":4,"noShowCount":4,"declinedCount":0,"leakagePct":0.14285714285714285,"estLostRevenueCents":880000},{"practiceId":66,"practiceName":"Beahan LLC Animal Hospital","practiceCity":"Wunschbury","practiceState":"PA","referralCount":30,"completedCount":20,"lostCount":4,"noShowCount":4,"declinedCount":2,"leakagePct":0.13333333333333333,"estLostRevenueCents":880000},{"practiceId":78,"practiceName":"Lubowitz Group Animal Hospital","practiceCity":"West Vito","practiceState":"OH","referralCount":50,"completedCount":39,"lostCount":4,"noShowCount":5,"declinedCount":2,"leakagePct":0.08,"estLostRevenueCents":880000},{"practiceId":84,"practiceName":"LittelStrosin Inc Animal Hospital","practiceCity":"North Philipbury","practiceState":"OH","referralCount":32,"completedCount":26,"lostCount":4,"noShowCount":2,"declinedCount":0,"leakagePct":0.125,"estLostRevenueCents":880000},{"practiceId":85,"practiceName":"Marquardt Group Animal Hospital","practiceCity":"Santa Clarita","practiceState":"OH","referralCount":29,"completedCount":20,"lostCount":4,"noShowCount":2,"declinedCount":3,"leakagePct":0.13793103448275862,"estLostRevenueCents":880000},{"practiceId":92,"practiceName":"Doyle Inc Animal Hospital","practiceCity":"Littelmouth","practiceState":"PA","referralCount":31,"completedCount":21,"lostCount":4,"noShowCount":2,"declinedCount":4,"leakagePct":0.12903225806451613,"estLostRevenueCents":880000},{"practiceId":100,"practiceName":"Schaden  Parisian Animal Hospital","practiceCity":"Josefachester","practiceState":"OH","referralCount":35,"completedCount":26,"lostCount":4,"noShowCount":5,"declinedCount":0,"leakagePct":0.11428571428571428,"estLostRevenueCents":880000},{"practiceId":103,"practiceName":"Thompson Hirthe and Rohan Animal Hospital","practiceCity":"Montebello","practiceState":"PA","referralCount":29,"completedCount":23,"lostCount":4,"noShowCount":1,"declinedCount":1,"leakagePct":0.13793103448275862,"estLostRevenueCents":880000},{"practiceId":105,"practiceName":"Walter OReilly and SchroederAuer Animal Hospital","practiceCity":"Marciastad","practiceState":"PA","referralCount":41,"completedCount":25,"lostCount":4,"noShowCount":10,"declinedCount":2,"leakagePct":0.0975609756097561,"estLostRevenueCents":880000},{"practiceId":6,"practiceName":"Hauck Zemlak and Nader Animal Hospital","practiceCity":"Tuckahoe","practiceState":"OH","referralCount":43,"completedCount":34,"lostCount":3,"noShowCount":3,"declinedCount":3,"leakagePct":0.06976744186046512,"estLostRevenueCents":660000},{"practiceId":18,"practiceName":"HintzPollich Tromp and Little Animal Hospital","practiceCity":"Aliyaview","practiceState":"OH","referralCount":26,"completedCount":20,"lostCount":3,"noShowCount":3,"declinedCount":0,"leakagePct":0.11538461538461539,"estLostRevenueCents":660000},{"practiceId":21,"practiceName":"OReilly LLC Animal Hospital","practiceCity":"Gardena","practiceState":"PA","referralCount":42,"completedCount":34,"lostCount":3,"noShowCount":4,"declinedCount":1,"leakagePct":0.07142857142857142,"estLostRevenueCents":660000},{"practiceId":23,"practiceName":"Huel Inc Animal Hospital","practiceCity":"North Noetown","practiceState":"OH","referralCount":32,"completedCount":26,"lostCount":3,"noShowCount":2,"declinedCount":1,"leakagePct":0.09375,"estLostRevenueCents":660000},{"practiceId":25,"practiceName":"Murazik  Lowe Animal Hospital","practiceCity":"Ullrichview","practiceState":"PA","referralCount":29,"completedCount":23,"lostCount":3,"noShowCount":1,"declinedCount":2,"leakagePct":0.10344827586206896,"estLostRevenueCents":660000},{"practiceId":33,"practiceName":"Kunde  Parisian Animal Hospital","practiceCity":"Braunton","practiceState":"OH","referralCount":27,"completedCount":21,"lostCount":3,"noShowCount":2,"declinedCount":1,"leakagePct":0.1111111111111111,"estLostRevenueCents":660000},{"practiceId":41,"practiceName":"Cummings Group Animal Hospital","practiceCity":"West Jeremybury","practiceState":"OH","referralCount":24,"completedCount":19,"lostCount":3,"noShowCount":2,"declinedCount":0,"leakagePct":0.125,"estLostRevenueCents":660000},{"practiceId":45,"practiceName":"Stamm Kris and Howell Animal Hospital","practiceCity":"Belindatown","practiceState":"PA","referralCount":38,"completedCount":25,"lostCount":3,"noShowCount":9,"declinedCount":1,"leakagePct":0.07894736842105263,"estLostRevenueCents":660000},{"practiceId":61,"practiceName":"Hagenes  McLaughlin Animal Hospital","practiceCity":"Diamond Bar","practiceState":"OH","referralCount":29,"completedCount":23,"lostCount":3,"noShowCount":2,"declinedCount":1,"leakagePct":0.10344827586206896,"estLostRevenueCents":660000},{"practiceId":62,"practiceName":"OHara Kassulke and Weissnat Animal Hospital","practiceCity":"Concord","practiceState":"PA","referralCount":36,"completedCount":29,"lostCount":3,"noShowCount":4,"declinedCount":0,"leakagePct":0.08333333333333333,"estLostRevenueCents":660000},{"practiceId":64,"practiceName":"UllrichHirthe and Sons Animal Hospital","practiceCity":"Noahport","practiceState":"OH","referralCount":33,"completedCount":26,"lostCount":3,"noShowCount":4,"declinedCount":0,"leakagePct":0.09090909090909091,"estLostRevenueCents":660000},{"practiceId":68,"practiceName":"Towne  Klein Animal Hospital","practiceCity":"Rancho Cucamonga","practiceState":"PA","referralCount":31,"completedCount":22,"lostCount":3,"noShowCount":6,"declinedCount":0,"leakagePct":0.0967741935483871,"estLostRevenueCents":660000},{"practiceId":69,"practiceName":"HayesErnser  Macejkovic Animal Hospital","practiceCity":"Jacestad","practiceState":"OH","referralCount":31,"completedCount":26,"lostCount":3,"noShowCount":2,"declinedCount":0,"leakagePct":0.0967741935483871,"estLostRevenueCents":660000},{"practiceId":70,"practiceName":"Hauck Berge and Brakus Animal Hospital","practiceCity":"Jaydenbury","practiceState":"OH","referralCount":37,"completedCount":26,"lostCount":3,"noShowCount":5,"declinedCount":3,"leakagePct":0.08108108108108109,"estLostRevenueCents":660000},{"practiceId":72,"practiceName":"Hermiston LLC Animal Hospital","practiceCity":"Hoover","practiceState":"OH","referralCount":35,"completedCount":26,"lostCount":3,"noShowCount":4,"declinedCount":2,"leakagePct":0.08571428571428572,"estLostRevenueCents":660000},{"practiceId":75,"practiceName":"GrantWard and Sons Animal Hospital","practiceCity":"Kirstinport","practiceState":"OH","referralCount":37,"completedCount":31,"lostCount":3,"noShowCount":3,"declinedCount":0,"leakagePct":0.08108108108108109,"estLostRevenueCents":660000},{"practiceId":90,"practiceName":"Lehner Oberbrunner and Schaefer Animal Hospital","practiceCity":"South Amina","practiceState":"OH","referralCount":30,"completedCount":21,"lostCount":3,"noShowCount":6,"declinedCount":0,"leakagePct":0.1,"estLostRevenueCents":660000},{"practiceId":91,"practiceName":"Cormier Inc Animal Hospital","practiceCity":"South Enrico","practiceState":"OH","referralCount":31,"completedCount":23,"lostCount":3,"noShowCount":3,"declinedCount":2,"leakagePct":0.0967741935483871,"estLostRevenueCents":660000},{"practiceId":93,"practiceName":"Huel Weissnat and Kozey Animal Hospital","practiceCity":"Lake Johan","practiceState":"OH","referralCount":34,"completedCount":21,"lostCount":3,"noShowCount":9,"declinedCount":1,"leakagePct":0.08823529411764706,"estLostRevenueCents":660000},{"practiceId":97,"practiceName":"Franey  Hettinger Animal Hospital","practiceCity":"East Peggy","practiceState":"OH","referralCount":29,"completedCount":21,"lostCount":3,"noShowCount":5,"declinedCount":0,"leakagePct":0.10344827586206896,"estLostRevenueCents":660000},{"practiceId":99,"practiceName":"MurphyTurcotte  Bartoletti Animal Hospital","practiceCity":"Wilkinsonstad","practiceState":"OH","referralCount":39,"completedCount":32,"lostCount":3,"noShowCount":4,"declinedCount":0,"leakagePct":0.07692307692307693,"estLostRevenueCents":660000},{"practiceId":101,"practiceName":"Hilll LLC Animal Hospital","practiceCity":"Fort Myers","practiceState":"OH","referralCount":31,"completedCount":23,"lostCount":3,"noShowCount":5,"declinedCount":0,"leakagePct":0.0967741935483871,"estLostRevenueCents":660000},{"practiceId":107,"practiceName":"Hartmann Stehr and Waters Animal Hospital","practiceCity":"Eraborough","practiceState":"OH","referralCount":29,"completedCount":24,"lostCount":3,"noShowCount":1,"declinedCount":1,"leakagePct":0.10344827586206896,"estLostRevenueCents":660000},{"practiceId":110,"practiceName":"Connelly  Beier Animal Hospital","practiceCity":"North Dustin","practiceState":"PA","referralCount":31,"completedCount":23,"lostCount":3,"noShowCount":5,"declinedCount":0,"leakagePct":0.0967741935483871,"estLostRevenueCents":660000},{"practiceId":2,"practiceName":"Hand Bernier and Witting Animal Hospital","practiceCity":"Port Louvenia","practiceState":"PA","referralCount":34,"completedCount":28,"lostCount":2,"noShowCount":2,"declinedCount":2,"leakagePct":0.058823529411764705,"estLostRevenueCents":440000},{"practiceId":3,"practiceName":"Herzog Group Animal Hospital","practiceCity":"Blakeberg","practiceState":"PA","referralCount":36,"completedCount":28,"lostCount":2,"noShowCount":5,"declinedCount":1,"leakagePct":0.05555555555555555,"estLostRevenueCents":440000},{"practiceId":26,"practiceName":"Yundt and Sons Animal Hospital","practiceCity":"West Dorothy","practiceState":"PA","referralCount":26,"completedCount":21,"lostCount":2,"noShowCount":3,"declinedCount":0,"leakagePct":0.07692307692307693,"estLostRevenueCents":440000},{"practiceId":28,"practiceName":"Kautzer Johns and Streich Animal Hospital","practiceCity":"Stromanville","practiceState":"OH","referralCount":22,"completedCount":14,"lostCount":2,"noShowCount":6,"declinedCount":0,"leakagePct":0.09090909090909091,"estLostRevenueCents":440000},{"practiceId":29,"practiceName":"Crist Inc Animal Hospital","practiceCity":"Tommyberg","practiceState":"PA","referralCount":38,"completedCount":29,"lostCount":2,"noShowCount":6,"declinedCount":1,"leakagePct":0.05263157894736842,"estLostRevenueCents":440000},{"practiceId":35,"practiceName":"Marquardt LLC Animal Hospital","practiceCity":"Chasityville","practiceState":"PA","referralCount":37,"completedCount":31,"lostCount":2,"noShowCount":4,"declinedCount":0,"leakagePct":0.05405405405405406,"estLostRevenueCents":440000},{"practiceId":38,"practiceName":"Purdy and Sons Animal Hospital","practiceCity":"Johannaview","practiceState":"PA","referralCount":38,"completedCount":26,"lostCount":2,"noShowCount":9,"declinedCount":1,"leakagePct":0.05263157894736842,"estLostRevenueCents":440000},{"practiceId":44,"practiceName":"Labadie  Wisozk Animal Hospital","practiceCity":"Lake Adell","practiceState":"OH","referralCount":39,"completedCount":28,"lostCount":2,"noShowCount":6,"declinedCount":3,"leakagePct":0.05128205128205128,"estLostRevenueCents":440000},{"practiceId":50,"practiceName":"BreitenbergRoob Group Animal Hospital","practiceCity":"South Maxineshire","practiceState":"OH","referralCount":35,"completedCount":26,"lostCount":2,"noShowCount":7,"declinedCount":0,"leakagePct":0.05714285714285714,"estLostRevenueCents":440000},{"practiceId":51,"practiceName":"Toy  Schumm Animal Hospital","practiceCity":"South Haydenchester","practiceState":"OH","referralCount":33,"completedCount":24,"lostCount":2,"noShowCount":5,"declinedCount":2,"leakagePct":0.06060606060606061,"estLostRevenueCents":440000},{"practiceId":52,"practiceName":"Kassulke and Sons Animal Hospital","practiceCity":"West Gabetown","practiceState":"PA","referralCount":28,"completedCount":23,"lostCount":2,"noShowCount":3,"declinedCount":0,"leakagePct":0.07142857142857142,"estLostRevenueCents":440000},{"practiceId":57,"practiceName":"Marks LLC Animal Hospital","practiceCity":"Port Edward","practiceState":"OH","referralCount":32,"completedCount":24,"lostCount":2,"noShowCount":6,"declinedCount":0,"leakagePct":0.0625,"estLostRevenueCents":440000},{"practiceId":65,"practiceName":"Kshlerin Douglas and Bernier Animal Hospital","practiceCity":"East Sherylburgh","practiceState":"PA","referralCount":32,"completedCount":21,"lostCount":2,"noShowCount":5,"declinedCount":4,"leakagePct":0.0625,"estLostRevenueCents":440000},{"practiceId":74,"practiceName":"Schroeder Bartoletti and CristLebsack Animal Hospital","practiceCity":"College Station","practiceState":"OH","referralCount":40,"completedCount":34,"lostCount":2,"noShowCount":3,"declinedCount":1,"leakagePct":0.05,"estLostRevenueCents":440000},{"practiceId":76,"practiceName":"Rogahn LLC Animal Hospital","practiceCity":"Port Alden","practiceState":"OH","referralCount":37,"completedCount":31,"lostCount":2,"noShowCount":4,"declinedCount":0,"leakagePct":0.05405405405405406,"estLostRevenueCents":440000},{"practiceId":77,"practiceName":"Thompson Berge and Gleason Animal Hospital","practiceCity":"National City","practiceState":"OH","referralCount":34,"completedCount":25,"lostCount":2,"noShowCount":6,"declinedCount":1,"leakagePct":0.058823529411764705,"estLostRevenueCents":440000},{"practiceId":81,"practiceName":"Weber Group Animal Hospital","practiceCity":"West Allen","practiceState":"OH","referralCount":26,"completedCount":19,"lostCount":2,"noShowCount":4,"declinedCount":1,"leakagePct":0.07692307692307693,"estLostRevenueCents":440000},{"practiceId":86,"practiceName":"Abernathy Inc Animal Hospital","practiceCity":"Lowell","practiceState":"OH","referralCount":35,"completedCount":26,"lostCount":2,"noShowCount":6,"declinedCount":1,"leakagePct":0.05714285714285714,"estLostRevenueCents":440000},{"practiceId":87,"practiceName":"Zboncak  Pfeffer Animal Hospital","practiceCity":"North Kentberg","practiceState":"OH","referralCount":29,"completedCount":21,"lostCount":2,"noShowCount":5,"declinedCount":1,"leakagePct":0.06896551724137931,"estLostRevenueCents":440000},{"practiceId":95,"practiceName":"Baumbach Gusikowski and Pouros Animal Hospital","practiceCity":"West Patriciafield","practiceState":"PA","referralCount":29,"completedCount":22,"lostCount":2,"noShowCount":4,"declinedCount":1,"leakagePct":0.06896551724137931,"estLostRevenueCents":440000},{"practiceId":108,"practiceName":"McCullough  Olson Animal Hospital","practiceCity":"Rauworth","practiceState":"PA","referralCount":40,"completedCount":33,"lostCount":2,"noShowCount":4,"declinedCount":1,"leakagePct":0.05,"estLostRevenueCents":440000},{"practiceId":8,"practiceName":"Lindgren  Waters Animal Hospital","practiceCity":"North Troystead","practiceState":"PA","referralCount":31,"completedCount":26,"lostCount":1,"noShowCount":4,"declinedCount":0,"leakagePct":0.03225806451612903,"estLostRevenueCents":220000},{"practiceId":10,"practiceName":"Weissnat Turner and Bartoletti Animal Hospital","practiceCity":"West Constantin","practiceState":"PA","referralCount":40,"completedCount":32,"lostCount":1,"noShowCount":7,"declinedCount":0,"leakagePct":0.025,"estLostRevenueCents":220000},{"practiceId":11,"practiceName":"Pagac Group Animal Hospital","practiceCity":"East Salvatorestad","practiceState":"OH","referralCount":29,"completedCount":23,"lostCount":1,"noShowCount":4,"declinedCount":1,"leakagePct":0.034482758620689655,"estLostRevenueCents":220000},{"practiceId":12,"practiceName":"Pagac Inc Animal Hospital","practiceCity":"Baldwin Park","practiceState":"PA","referralCount":27,"completedCount":19,"lostCount":1,"noShowCount":6,"declinedCount":1,"leakagePct":0.037037037037037035,"estLostRevenueCents":220000},{"practiceId":14,"practiceName":"Yost Group Animal Hospital","practiceCity":"Karenport","practiceState":"PA","referralCount":33,"completedCount":27,"lostCount":1,"noShowCount":3,"declinedCount":2,"leakagePct":0.030303030303030304,"estLostRevenueCents":220000},{"practiceId":16,"practiceName":"Howe  Muller Animal Hospital","practiceCity":"Lake Simeon","practiceState":"OH","referralCount":29,"completedCount":24,"lostCount":1,"noShowCount":3,"declinedCount":1,"leakagePct":0.034482758620689655,"estLostRevenueCents":220000},{"practiceId":17,"practiceName":"Hyatt Labadie and Berge Animal Hospital","practiceCity":"Passaic","practiceState":"PA","referralCount":34,"completedCount":26,"lostCount":1,"noShowCount":4,"declinedCount":3,"leakagePct":0.029411764705882353,"estLostRevenueCents":220000},{"practiceId":27,"practiceName":"Kshlerin  Bartoletti Animal Hospital","practiceCity":"South Enoch","practiceState":"PA","referralCount":30,"completedCount":27,"lostCount":1,"noShowCount":2,"declinedCount":0,"leakagePct":0.03333333333333333,"estLostRevenueCents":220000},{"practiceId":30,"practiceName":"Schultz and Sons Animal Hospital","practiceCity":"Frankiefield","practiceState":"PA","referralCount":43,"completedCount":35,"lostCount":1,"noShowCount":5,"declinedCount":2,"leakagePct":0.023255813953488372,"estLostRevenueCents":220000},{"practiceId":32,"practiceName":"Crona  Wuckert Animal Hospital","practiceCity":"Sonyacester","practiceState":"OH","referralCount":25,"completedCount":16,"lostCount":1,"noShowCount":5,"declinedCount":3,"leakagePct":0.04,"estLostRevenueCents":220000},{"practiceId":36,"practiceName":"Johnston  Hudson Animal Hospital","practiceCity":"San Leandro","practiceState":"PA","referralCount":34,"completedCount":33,"lostCount":1,"noShowCount":0,"declinedCount":0,"leakagePct":0.029411764705882353,"estLostRevenueCents":220000},{"practiceId":39,"practiceName":"Roob and Sons Animal Hospital","practiceCity":"Quigleyside","practiceState":"PA","referralCount":37,"completedCount":29,"lostCount":1,"noShowCount":6,"declinedCount":1,"leakagePct":0.02702702702702703,"estLostRevenueCents":220000},{"practiceId":48,"practiceName":"Rohan Padberg and Krajcik Animal Hospital","practiceCity":"Ratkestad","practiceState":"OH","referralCount":40,"completedCount":31,"lostCount":1,"noShowCount":6,"declinedCount":2,"leakagePct":0.025,"estLostRevenueCents":220000},{"practiceId":49,"practiceName":"Ankunding and Sons Animal Hospital","practiceCity":"Millerhaven","practiceState":"OH","referralCount":34,"completedCount":32,"lostCount":1,"noShowCount":1,"declinedCount":0,"leakagePct":0.029411764705882353,"estLostRevenueCents":220000},{"practiceId":54,"practiceName":"Murazik Beahan and Bruen Animal Hospital","practiceCity":"Urbandale","practiceState":"OH","referralCount":39,"completedCount":30,"lostCount":1,"noShowCount":8,"declinedCount":0,"leakagePct":0.02564102564102564,"estLostRevenueCents":220000},{"practiceId":55,"practiceName":"WolffSchowalter Lowe and Keebler Animal Hospital","practiceCity":"High Point","practiceState":"OH","referralCount":30,"completedCount":26,"lostCount":1,"noShowCount":3,"declinedCount":0,"leakagePct":0.03333333333333333,"estLostRevenueCents":220000},{"practiceId":56,"practiceName":"Schuppe Group Animal Hospital","practiceCity":"Idaburgh","practiceState":"PA","referralCount":31,"completedCount":27,"lostCount":1,"noShowCount":3,"declinedCount":0,"leakagePct":0.03225806451612903,"estLostRevenueCents":220000},{"practiceId":63,"practiceName":"Hoeger Group Animal Hospital","practiceCity":"Smithamview","practiceState":"OH","referralCount":32,"completedCount":29,"lostCount":1,"noShowCount":2,"declinedCount":0,"leakagePct":0.03125,"estLostRevenueCents":220000},{"practiceId":71,"practiceName":"Bayer Harber and Glover Animal Hospital","practiceCity":"Hutchinson","practiceState":"OH","referralCount":40,"completedCount":33,"lostCount":1,"noShowCount":6,"declinedCount":0,"leakagePct":0.025,"estLostRevenueCents":220000},{"practiceId":73,"practiceName":"Grady Watsica and Jaskolski Animal Hospital","practiceCity":"Gradyberg","practiceState":"OH","referralCount":30,"completedCount":25,"lostCount":1,"noShowCount":4,"declinedCount":0,"leakagePct":0.03333333333333333,"estLostRevenueCents":220000},{"practiceId":79,"practiceName":"Spencer Gleason and Leuschke Animal Hospital","practiceCity":"New Sueland","practiceState":"OH","referralCount":27,"completedCount":24,"lostCount":1,"noShowCount":2,"declinedCount":0,"leakagePct":0.037037037037037035,"estLostRevenueCents":220000},{"practiceId":83,"practiceName":"Fadel Bailey and Marks Animal Hospital","practiceCity":"North Jackelinestead","practiceState":"PA","referralCount":29,"completedCount":24,"lostCount":1,"noShowCount":4,"declinedCount":0,"leakagePct":0.034482758620689655,"estLostRevenueCents":220000},{"practiceId":94,"practiceName":"Beer Waters and Steuber Animal Hospital","practiceCity":"Port Candelario","practiceState":"OH","referralCount":32,"completedCount":27,"lostCount":1,"noShowCount":4,"declinedCount":0,"leakagePct":0.03125,"estLostRevenueCents":220000},{"practiceId":106,"practiceName":"Graham Rohan and Hane Animal Hospital","practiceCity":"Sterling Heights","practiceState":"OH","referralCount":32,"completedCount":24,"lostCount":1,"noShowCount":6,"declinedCount":1,"leakagePct":0.03125,"estLostRevenueCents":220000},{"practiceId":5,"practiceName":"Wunsch Group Animal Hospital","practiceCity":"Lake Danielle","practiceState":"PA","referralCount":29,"completedCount":22,"lostCount":0,"noShowCount":6,"declinedCount":1,"leakagePct":0,"estLostRevenueCents":0},{"practiceId":13,"practiceName":"Christiansen  Stoltenberg Animal Hospital","practiceCity":"Friesenport","practiceState":"OH","referralCount":27,"completedCount":24,"lostCount":0,"noShowCount":3,"declinedCount":0,"leakagePct":0,"estLostRevenueCents":0},{"practiceId":19,"practiceName":"Nitzsche Torp and Spencer Animal Hospital","practiceCity":"Port Colemanmouth","practiceState":"PA","referralCount":35,"completedCount":31,"lostCount":0,"noShowCount":3,"declinedCount":1,"leakagePct":0,"estLostRevenueCents":0},{"practiceId":22,"practiceName":"Rowe  Boehm Animal Hospital","practiceCity":"Luettgenstead","practiceState":"OH","referralCount":32,"completedCount":26,"lostCount":0,"noShowCount":5,"declinedCount":1,"leakagePct":0,"estLostRevenueCents":0},{"practiceId":24,"practiceName":"Hintz  Lindgren Animal Hospital","practiceCity":"Fort Sam","practiceState":"OH","referralCount":30,"completedCount":27,"lostCount":0,"noShowCount":3,"declinedCount":0,"leakagePct":0,"estLostRevenueCents":0},{"practiceId":34,"practiceName":"Carter Collins and Dickens Animal Hospital","practiceCity":"Erikton","practiceState":"OH","referralCount":31,"completedCount":28,"lostCount":0,"noShowCount":3,"declinedCount":0,"leakagePct":0,"estLostRevenueCents":0},{"practiceId":46,"practiceName":"Mayer Inc Animal Hospital","practiceCity":"Patriciatown","practiceState":"PA","referralCount":35,"completedCount":32,"lostCount":0,"noShowCount":3,"declinedCount":0,"leakagePct":0,"estLostRevenueCents":0},{"practiceId":53,"practiceName":"Auer  Bednar Animal Hospital","practiceCity":"South Caroleview","practiceState":"PA","referralCount":24,"completedCount":18,"lostCount":0,"noShowCount":4,"declinedCount":2,"leakagePct":0,"estLostRevenueCents":0},{"practiceId":59,"practiceName":"Russel and Sons Animal Hospital","practiceCity":"Christiansenside","practiceState":"OH","referralCount":35,"completedCount":28,"lostCount":0,"noShowCount":7,"declinedCount":0,"leakagePct":0,"estLostRevenueCents":0},{"practiceId":60,"practiceName":"Wolf Group Animal Hospital","practiceCity":"Ferryview","practiceState":"OH","referralCount":34,"completedCount":27,"lostCount":0,"noShowCount":7,"declinedCount":0,"leakagePct":0,"estLostRevenueCents":0},{"practiceId":67,"practiceName":"Balistreri  Leannon Animal Hospital","practiceCity":"Edgarborough","practiceState":"OH","referralCount":42,"completedCount":35,"lostCount":0,"noShowCount":7,"declinedCount":0,"leakagePct":0,"estLostRevenueCents":0},{"practiceId":88,"practiceName":"Torp Group Animal Hospital","practiceCity":"Fort Maiyashire","practiceState":"OH","referralCount":31,"completedCount":23,"lostCount":0,"noShowCount":8,"declinedCount":0,"leakagePct":0,"estLostRevenueCents":0},{"practiceId":89,"practiceName":"Gerlach Gislason and Barrows Animal Hospital","practiceCity":"Wuckertmouth","practiceState":"OH","referralCount":42,"completedCount":40,"lostCount":0,"noShowCount":1,"declinedCount":1,"leakagePct":0,"estLostRevenueCents":0}],"total":{"referrals":4405,"lost":380,"estLostRevenueCents":83600000},"_sql":"\n    SELECT rp.id, rp.name, rp.city, rp.state,\n      COUNT(r.id) AS referral_count,\n      SUM(CASE WHEN r.status='completed' THEN 1 ELSE 0 END) AS completed,\n      SUM(CASE WHEN r.status='lost_to_competitor' THEN 1 ELSE 0 END) AS lost,\n      SUM(CASE WHEN r.status='no_show' THEN 1 ELSE 0 END) AS no_show,\n      SUM(CASE WHEN r.status='patient_declined' THEN 1 ELSE 0 END) AS declined\n    FROM referring_practices rp\n    LEFT JOIN referrals r ON r.originating_practice_id = rp.id AND r.referred_date >= ?\n    GROUP BY rp.id\n    HAVING COUNT(r.id) > 0\n    ORDER BY lost DESC"}