General Visit (PT Boulder API)

Total rows: 104,153
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
42759 5af1695646622b30576b20d1d3570e272b8a7eba510b834e6855428ce58c972b 67d01375bb4a7c06144a7a0f 67ced3b57abf9f3ed8fea9e9 Marta Hamilton Marta Hamilton martahamilton@hamiltonboulder.com 006924 36 2025-02-25 Cancel 67b50520db7c513ce9d80dd3 Daphne Ryan 67cecf56790102035488b359 Pre-PtE Appt 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-02-25 18:15:00 0.0 hrs 67d01375bb4a7c06144a7a0e 000054212 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:52
42758 bf1bae9e71ca3ea5c495066eef1598c908b4fdb1b9aa1a45fe27271e0622f989 67d01374bb4a7c06144a788d 67ced3347abf9f3ed8fe80f5 William Conway William Conway perry@perryconway.com 003430 12 2025-02-25 Cancel 67ace27f67327b083edb451f Michelle Osgood 67cecf56790102035488b359 Pre-PtE Appt 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-02-25 18:15:00 0.0 hrs 67d01374bb4a7c06144a788c 000054211 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:52
42757 61ea1c6f1a033ae30e5a285d89e6c16ed38cdd999c25705b20e4cf2ed873ae81 67d01374bb4a7c06144a786f 67ced3f07abf9f3ed8feb83b Hazel Kroehl Hazel Kroehl lkroehl@hotmail.com 008146 10 2025-02-25 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-02-25 18:15:00 0.0 hrs 67d01374bb4a7c06144a786e 000054210 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:52
42756 2a467efeee42890d930dbb61fe6bcdf308309b6e4a9ffc63caf9e3e8a6f74dcf 67d01373bb4a7c06144a76ee 67ced3527abf9f3ed8fe8c28 Travis Garvin Travis Garvin travis@lcof.com 004385 7 2025-02-25 New 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:55 328.4 hrs 67d01373bb4a7c06144a76ed 000054209 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:52
42755 336308524252d88c7df63e4c03e8900be37c7bd846258880fd35932d307f8346 67d01372bb4a7c06144a76d0 67ced4907abf9f3ed8fed7a8 Portia Pearson Portia Pearson portia0217@yahoo.com 010826 13 2025-02-25 New 67accd974e54de07d58ca3ee Sophia Phillips 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:54 328.4 hrs 67d01372bb4a7c06144a76cf 000054208 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:52
42754 f5d101ca6361b8720cd2778e31bba88f241602f06f3eb12a37d57d499591570c 67d01372bb4a7c06144a76b1 67ced3f37abf9f3ed8feb8d5 Karen Kuk Nagle Karen Kuk Nagle karen@handsofspirit.com 008197 25 2025-02-25 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67cecf56790102035488b359 Pre-PtE Appt 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-02-25 18:15:00 0.0 hrs 67d01372bb4a7c06144a76b0 000054207 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:52
42753 6efac88705d6056b542e0ffffd0a4d8a5e5bb3472c0bc6aaa8fde4db19551e7c 67d01371bb4a7c06144a7693 67ced3917abf9f3ed8fea03b Evan Helmstetter Evan Helmstetter evhelmstetter@gmail.com 006098 31 2025-02-25 New 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:52 328.2 hrs 67d01371bb4a7c06144a7692 000054206 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:52
42752 eaf35d5028eed02ed3e8866408d8571097724930fb39663693ae1acc0d384087 67d01370bb4a7c06144a7674 67ced2ed7abf9f3ed8fe5d37 Patricia Beumer Patricia Beumer patty1@beumerfamily.com 000380 818 2025-02-25 New 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:52 328.2 hrs 67d01370bb4a7c06144a7673 000054205 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:52
42751 ea67936d8aa6c8ec047271e69144689dc39701c550ebecd32a09cf0874c062bc 67d0136fbb4a7c06144a7653 67ced46f7abf9f3ed8fed1c3 Carrie Luerssen Carrie Luerssen caluerssen@gmail.com 010323 36 2025-02-25 New 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:51 328.2 hrs 67d0136fbb4a7c06144a7652 000054204 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:52
42750 badf6b85cb97d2112ed61830ae6e3794c3649e6d4436eb6014589bd931ea3ea0 67d0136fbb4a7c06144a7634 67ced6507abf9f3ed8ff195a Craig Yager Craig Yager yagerc2002@gmail.com 016429 37 2025-02-25 New 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:50 328.2 hrs 67d0136fbb4a7c06144a7633 000054203 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:52
42749 bcf077acb654ef73e23a01e29b8cf1a15f73117db64f3bb184c1f62d605729a3 67d0136ebb4a7c06144a7615 67ced3bf7abf9f3ed8feac83 Cheryl Hogan Cheryl Hogan cherylahogan459@gmail.com 007146 182 2025-02-25 New 67a29daa5af9e907bbcd6f52 Eva Tucker 67cecf56790102035488b359 Pre-PtE Appt 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:50 328.2 hrs 67d0136ebb4a7c06144a7614 000054202 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:52
42748 c8a70f3805dd36f03437a4eec0dcf613f78b8b788518beef0fa5581a3357f0d5 67d0136dbb4a7c06144a75f6 67ced46a7abf9f3ed8fed0c7 Erris McCullough Erris McCullough errism@hotmail.com 010239 51 2025-02-25 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Dawn Singleton - Dawn Singleton 2025-03-11 10:41:49 328.2 hrs 67d0136dbb4a7c06144a75f5 000054201 4.00 24.34 19.39 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:52
42747 6d60cd0a50facb807e2a03131cae196322fde975bece6bf9a5548ea6e6438e39 67d0136dbb4a7c06144a75b5 67ced3857abf9f3ed8fe9cba Karen Ishibashi Karen Ishibashi karen.ishibashi@gmail.com 005799 71 2025-02-25 New 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:48 328.2 hrs 67d0136dbb4a7c06144a75b4 000054200 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:39
42746 7078493ee1fbcc714021efc6ab985e96a1af9a35a6246e82dcbb38ba9035c721 67d0136cbb4a7c06144a7592 67ced4297abf9f3ed8fec426 Asher Liles Asher Liles asherjliles@gmail.com 009162 51 2025-02-25 New 67b50520db7c513ce9d80dd3 Daphne Ryan 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:47 327.9 hrs 67d0136cbb4a7c06144a7591 000054199 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:39
42745 1ef99a2e0adc9da997a499c99f1db02d4f60ea21ade71849d60e003b86a5ef81 67d0136bbb4a7c06144a7574 67ced3af7abf9f3ed8fea830 Lisa Haley Lisa Haley blueflamefx150@gmail.com 006777 133 2025-02-25 New 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:46 327.9 hrs 67d0136bbb4a7c06144a7573 000054198 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:39
42744 78c5299bb94f4c79699a32108cc7dad46286392bebcade5ddd0ecd8a88bc97a4 67d0136abb4a7c06144a7555 67ced3c67abf9f3ed8feae18 Kevin Holtzclaw Kevin Holtzclaw holtzgard2@icloud.com 007281 46 2025-02-25 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-02-25 19:00:00 0.0 hrs 67d0136abb4a7c06144a7554 000054197 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:39
42743 fa3fd64f886bb4ee0d78efc85130f89ebf2800cada12c4c4d1de5f811a684b80 67d01369bb4a7c06144a7537 67ced4c17abf9f3ed8fee02e Mary O'Halloran Mary O'Halloran ohalloranms1@gmail.com 011553 92 2025-02-25 New 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:44 327.7 hrs 67d01369bb4a7c06144a7536 000054196 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:39
42742 7dc7c27659fdff18329120214b6fe36940428b1a58ca4dfef6beeb450bd10d45 67be15663b5e3188058736ae 67be154a57270707a5710f6b Patient Test Patient Test test@gmail.com 000007 1 2025-02-25 Checked In 67a29cf58d115152b3ecae94 Allison Reyes 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Allison Reyes - Allison Reyes 2025-02-25 19:10:31 0.2 hrs 67be15663b5e3188058736ad 000000030 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:39
42741 7bc6c4a8c89c6ebab3c8bceb0c21c3a3407f2cd923ca89e3d067bb6954d44488 67d01368bb4a7c06144a7519 67ced3027abf9f3ed8fe6b1d Kelly Cavill Kelly Cavill kellycavill@gmail.com 001566 15 2025-02-25 New 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:43 327.4 hrs 67d01368bb4a7c06144a7518 000054195 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:39
42740 730ab6e00b0e4dc03ae1d4f0deb52e2561183b4467925df1165eee626af215b6 67d01367bb4a7c06144a74fa 67ced5547abf9f3ed8fef77e Kate Shew Kate Shew kateshew28@gmail.com 013542 49 2025-02-25 New 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:42 327.4 hrs 67d01367bb4a7c06144a74f9 000054194 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:39
42739 c3b995d8dfdd94dccc9771a1b0cd6f32c6893316045825bc3ac75df1e0191d3f 67d01366bb4a7c06144a74db 67ced3fe7abf9f3ed8febb36 Marcia Larson Marcia Larson larson4045@gmail.com 008400 53 2025-02-25 New 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67cecf56790102035488b359 Pre-PtE Appt 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:41 327.4 hrs 67d01366bb4a7c06144a74da 000054193 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:39
42738 f7c3237e94e916682aa5450839b95160319e7b2facb8d8fb3916a93e2f95c43e 67d01365bb4a7c06144a74bc 67ced3e27abf9f3ed8feb4ff Adam Klagsbrun Adam Klagsbrun aklags@gmail.com 007870 97 2025-02-25 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-02-25 19:15:00 0.0 hrs 67d01365bb4a7c06144a74bb 000054192 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:39
42737 bfa9f30778c6800d15895642dbf4171f07536c9ca34444d7fb082e83c7526f55 67d01365bb4a7c06144a749e 67ced5c27abf9f3ed8ff072d Katerina Stubblefield Katerina Stubblefield katerina.stubblefield@gmail.com 014879 22 2025-02-25 New 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 10:41:40 327.2 hrs 67d01365bb4a7c06144a749d 000054191 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:39
42736 62d604e61278ae188b571c5e264c4cfb1f190671db0f775499b60bc836c865f9 67d01364bb4a7c06144a7480 67ced3a57abf9f3ed8fea584 Christa Gaines Christa Gaines acappella8@gmail.com 006549 27 2025-02-25 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-02-25 19:30:00 0.0 hrs 67d01364bb4a7c06144a747f 000054190 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:39
42735 e73498664630d56af19525125a0bbf823c567f54d2ff095fa8271b8bfc45b231 67d01364bb4a7c06144a7462 67ced2fe7abf9f3ed8fe68fb Trevor Cusworth Trevor Cusworth tcusworth@gmail.com 001384 49 2025-02-25 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-02-25 19:30:00 0.0 hrs 67d01364bb4a7c06144a7461 000054189 0.00 0.00 0.00 - - - - - - - - 2026-02-20 00:23:33 2026-06-12 00:44:39