General Visit (PT Boulder API)

Total rows: 101,008
id row_key pte_visit_id pte_patient_id patient_full_name patient_first_name patient_last_name patient_email patient_code patient_total_appointment_visit date_of_service appointment_status provider_id provider_name service_id service_name location_id location_name invoice_status invoice_number current_responsibility package_invoice_number package_invoice_name claim_created_info created_by reason last_update_by last_update_date cancellation_notice treatment_note_id treatment_note_number units charges payments summary_total_appointments summary_total_charges summary_total_payments summary_total_units summary_total_patients summary_average_charges summary_average_payments summary_average_units created_at updated_at
14565 977d0db14ed24b6fd63083344a31b9de00673b01940cc229b1101aed5c4ab7de 68dac617da42ee49b9a29810 68d4c110a702ae6e138613c7 Gerald Dewlen Gerald Dewlen j.dewlen@gmail.com 019930 3 2025-10-14 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sophia L. - Jayvee Totanes 2025-10-22 16:11:42 191.9 hrs 68dac617da42ee49b9a2980f 000021370 3.00 234.00 20.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:28:03
14564 a9b04ecae1f9f16b3195790b5aa552a2a9af3895430e4ce684f6ad39db079363 68c830730a60a66cd30278f2 688b939d7cd0650800dda926 Donna Colville Donna Colville draye@comcast.net 017730 13 2025-10-14 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2025-10-21 16:23:44 168.1 hrs 68ee804a5cd6e70a12ec0334 000019745 3.00 60.00 50.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:28:03
14563 566185bd3591e9df586ba67be323e16262c51cfed7ad8a9e8409f178041acb13 68b9c55809a34b8b62d15336 67ced47b7abf9f3ed8fed3f4 Mary McHugh Mary McHugh maryemchugh@gmail.com 010510 31 2025-10-14 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-17 18:12:22 74.0 hrs 68b9c55809a34b8b62d15332 000018693 2.00 60.00 60.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:28:03
14562 4e6e0a59f189b5c9d6e9da125e4d773ce503be4136a92de10ed34cd227f0eeb1 68b1d76a85438d08932e9d4a 68a8152599c65c4a78a5f6b1 Mary Griffin Mary Griffin marymgriffin@comcast.net 018517 38 2025-10-14 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Frances Lawrence - Frances Lawrence 2025-10-14 16:41:38 0.4 hrs 68b1d76a85438d08932e9d49 000018182 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:28:03
14561 88055b69057ca976a4f289f7d9895da1c8db989b54b715c30899225d8304f607 68acaa9f36f64d573d624cfd 67ced3177abf9f3ed8fe75ee Susan Brooks Susan Brooks 2sbrooks@gmail.com 002489 39 2025-10-14 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sophia L. - Sonya C. 2025-10-14 16:16:09 0.0 hrs 68acaa9f36f64d573d624cfc 000017420 2.00 159.00 0.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:28:03
14560 6d476d26bd4f20b76598ce163ae4544e314bbcdffaecea8b3be01060735df79a 68a73a0ebcb12004627d5bb6 68a739508e89f80859aa44f3 Susan Brandes Susan Brandes susanb@canyonsage.com 017876 7 2025-10-14 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Jayvee Totanes 2025-10-22 17:52:42 193.6 hrs 68a73a0ebcb12004627d5bb2 000017041 4.00 60.00 60.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:28:03
14559 ced2fe0c29574a2f657dbefebeb06b814a1da6da86eeda2f68bd8b774c741154 686d50b05f7dbb089aeefd0b 67ced2ee7abf9f3ed8fe5ddc Raquel Cagan Raquel Cagan raquelsfishing@yahoo.com 000435 220 2025-10-14 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-07-16 23:29:28 -2152.8 hrs 686d50b05f7dbb089aeefd03 000012077 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:28:03
14558 16324f025d42e3e9215371112c5db5981f58c05038063e0bafa28fb83563c482 68ed35201378121586478275 67ced30a7abf9f3ed8fe6f5e Mia Davies Mia Davies miadavies2705@gmail.com 001929 25 2025-10-14 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-22 17:06:19 192.6 hrs 68f95ef8fa1adb09cfe0f2e0 000023188 3.00 0.00 180.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:28:03
14557 5b89ffa23d464c4755463a51c4c1733d659403a0577e62bd646ea8397795969c 68e828f2ea3c36b3b4534b7e 68c5941c5d39d86603721b8d Kathleen Candelaria Kathleen Candelaria kathleencandelaria@ptboulder.com 019850 18 2025-10-14 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Primary - - Yes Emmie Gebhardt - Mark Leo Guevarra 2025-10-21 17:34:46 169.1 hrs 68e828f2ea3c36b3b4534b7d 000022992 3.00 235.00 35.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:28:03
14556 93b9b17ff4e9ea383b36f6f110d6484b0ae89354de4c7020a244bc26cd4b42c9 68e40006082e160a36677782 68e3ffc08be67162cd35622e Deborah Skelton Deborah Skelton twincranes@msn.com 019998 23 2025-10-14 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a679be05de5fabb1c08f2d ASH (CIGNA) OT/PT Initial Evaluation - GET OUTCOME 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Patient - - No Rosey Reed - Sophia L. 2025-10-14 16:31:22 0.0 hrs 68e40006082e160a36677781 000022378 4.00 378.00 0.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:28:03
14555 566674cf35940ac6e75d90c4541b687989a14a853dcad1ea812d38fdb9b7901f 68e04971017b27929c6b954c 68c43db7eafe21d357ba5fdd Veena Krishnamoorthy Veena Krishnamoorthy veena.krishnamoorthy@gmail.com 019845 18 2025-10-14 Cancel 67acc4530db5de07addc9873 Anne Majewski 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Anne Majewski move from sophia Anne Majewski 2025-10-03 22:10:09 -258.3 hrs 68e04971017b27929c6b954b 000022251 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14554 731c3be854ac676eaa3bbb268553adb6b0b581cd8e22d5b4f5b83923059af158 68db1d56556f35eaeec9578a 68a6105eb5433bb09ed475ba Laura Ortiz Laura Ortiz ortizlaura0808@gmail.com 017841 10 2025-10-14 Cancel 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Frances Lawrence at doctor with 18 month old Frances Lawrence 2025-10-14 15:57:29 -0.5 hrs 68db1d56556f35eaeec95789 000021594 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14553 13f56d280973ecb64908a95293f6874033d0f2c0b00461d3f000d3f6033826ec 68c9c30644769f09bf0e5f9f 68c9b8d1695a51cf377dc5a5 Benjamin Luber Benjamin Luber ben10luber@gmail.com 019875 12 2025-10-14 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a678d8c9d2cdd4645788f0 Follow Up 689983a679e412ce7c3dfcf6 Westminster Paid - Patient - - Yes Sonya C. - Sophia L. 2025-10-15 20:36:35 28.1 hrs 68c9c30644769f09bf0e5f9a 000019946 4.00 124.40 124.40 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14552 7f03da089a3d776dab5a79d4052125b2847858c0aed84780ab93c739551d278d 68c43f708ddde062ad6882f8 68c43db7eafe21d357ba5fdd Veena Krishnamoorthy Veena Krishnamoorthy veena.krishnamoorthy@gmail.com 019845 18 2025-10-14 Cancel 67acc4530db5de07addc9873 Anne Majewski 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 10/10 Sophia L. 2025-10-10 15:10:29 -97.3 hrs 68c43f708ddde062ad6882f7 000019646 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14551 edeb3950fbdb2e331ec9c05d485a68dea1b0dbd33f3c1cdcfff01bba6f18b710 689b6cb1ddc26607e2d1d43c 68487cdf27cadf645f7d21f6 Deborah Zucker Deborah Zucker dzucker3@gmail.com 017432 13 2025-10-14 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ pt conf - RAR 10/3 Rosey Reed 2025-10-03 19:23:33 -261.1 hrs 689b6cb1ddc26607e2d1d43b 000015996 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14550 56a6d811db3bc418677458ee9fdbcfc3578ad5d9ed669e5ddc7d1c526f17beb8 68ed22a1cff19209a3d5ac20 682f73dae7fa90a378015476 Emmile Lindemann Emmile Lindemann emmile.b.ohara@gmail.com 017292 29 2025-10-14 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed pt called at 9am to cxl appt - sc Sonya C. 2025-10-14 15:03:52 -1.7 hrs 68ed22a1cff19209a3d5ac1f 000023164 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14549 ec18bb75271cb17c85c98e6d90448d5525f0b430ed0053a6e2d6290892c10f16 68ed0d33c2e8bdd9c2184df4 6839e79640240408880e5edb Brian Adler Brian Adler adler8192@gmail.com 017351 16 2025-10-14 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sarah Patterson - Sonya C. 2025-10-14 16:38:58 -0.1 hrs 68ed0d33c2e8bdd9c2184df3 000023141 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14548 6f5f7b8e5bdd64b0f1729ab1ecad1f613d452b4b906560469a1cf3cc0cf4b72a 68e3e3f875c9fd18cb3a50a0 686bdc662237934714373a11 Darryl Hobson Darryl Hobson darryl@ihcclinic.com 017575 39 2025-10-14 Cancel 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. <24 car broke down (no fee) - RAR 10/14 Rosey Reed 2025-10-14 15:29:56 -1.3 hrs 68e3e3f875c9fd18cb3a509f 000022296 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14547 dd84215dbc910b383e7cf93bf1592ba5d308bb838d0b53a626e4d868cee1e2d7 68cdaf0cb5053cafe40663db 68702d98ba2ff3b0f5bf6d28 Susan Rewinkel Susan Rewinkel susan.rewinkel@colorado.edu 017604 9 2025-10-14 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-21 15:30:15 166.8 hrs 68cdaf0cb5053cafe40663da 000020349 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14546 954e7dbb3d25ddc7f03024d24dcf6daf83c3e8dd53355da7a47bb50ab973483e 68c999c559a5589573794e89 68c998ea02a01e077f53910a Danette Anderson Danette Anderson danette@cdgga.com 019868 6 2025-10-14 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-10-14 16:44:04 -0.0 hrs 68c999c559a5589573794e88 000019890 2.00 59.50 59.50 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14545 123b67ae062f0b34229c9a32fd31509dbab19fa0aa6161d5d6b380d986d1f91f 68c2ddb5c75365580770c458 67ced5477abf9f3ed8fef598 Laura Rulon Laura Rulon lrulon@yahoo.com 013380 322 2025-10-14 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 10/10 Sophia L. 2025-10-10 15:45:00 -97.0 hrs 68c2ddb5c75365580770c457 000019488 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14544 59899fb93cffd35519616b94cd9c7d505461321c2316ca12eaadd6de6628da38 689f6acf99dcd978be27fde9 67ced56c7abf9f3ed8fefb06 Janet Turnburke Janet Turnburke janet.turnburke@gmail.com 013843 52 2025-10-14 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-14 16:42:50 -0.0 hrs 68fb93d5f028f3de2d7f0d57 000016422 3.00 82.00 62.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14543 2e57b3764cb998ddb9add989f8f49083ec060ac5da9e1c49ae712e01b079ff0a 687fbb9b00931008513a2b94 67ced57c7abf9f3ed8fefd65 Barbara Stephens Barbara Stephens barbaramstephens@gmail.com 014045 133 2025-10-14 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Ranjini Ridgway - Mark Leo Guevarra 2025-10-21 19:30:55 170.8 hrs 687fbb9b00931008513a2b93 000013820 4.00 105.23 105.23 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14542 32da6807e73fb400ed955a1d38c9ada29122de5bdc9a4fd824692d76ab7e265b 686d5307a1c42408a3b9c1a9 67ced2ee7abf9f3ed8fe5ddc Raquel Cagan Raquel Cagan raquelsfishing@yahoo.com 000435 220 2025-10-14 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-07-16 23:29:36 -2153.3 hrs 686d5307a1c42408a3b9c1a8 000012089 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49
14541 4c3bc6bc1acf5fdaf2af013d90576a90c6b9fa9b6be63d79cae226c914c1435f 68ee5e1905d2027b0c4e0f79 68a8155e99c65c4a78a601fd Cian Nagle Cian Nagle maireadnagle@hotmail.com 019075 17 2025-10-14 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 68998453d9ae21be8001ca00 Boulder Julie Unpaid - Unidentified - - No Frances Lawrence scheduling conflict Frances Lawrence 2025-10-14 15:35:23 -1.4 hrs 68ee5e1905d2027b0c4e0f78 000023279 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:02:58 2026-05-08 23:27:49