General Visit (PT Boulder API)

Total rows: 101,785
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
19643 7a05a8c22dff6e142d8ddc524ad1e1a78eccfabc4632f2f024ac1dfa2b974a21 68961292d306ba7a104cdb9d 67ced52f7abf9f3ed8fef1ff Dismas Rotta Dismas Rotta dismasrotta@comcast.net 013073 105 2025-09-02 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Michelle W. 2025-08-26 16:31:48 -165.0 hrs 68961292d306ba7a104cdb9c 000015792 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19642 38b356a527371f09f222a026ee490590d2e58c0c9764858cc0e6d8a302883f38 6890c0cd331ec3bbec235dc5 688b9e50b561e730dbaffafc Nicole Burns Nicole Burns nicoleburns16@gmail.com 017731 7 2025-09-02 No Show 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-09-02 16:54:02 3.4 hrs 6890c0cd331ec3bbec235dc4 000015196 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19641 4c1b1d91a8e8d48ba60605f5533acc724fd406a1f970790cdf2e61b82c8c3546 68879ec0b8cfab083bdce1ec 67ced6267abf9f3ed8ff1434 Mary White Mary White bolles1@comcast.net 015990 50 2025-09-02 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-09-02 13:58:56 0.5 hrs 68879ec0b8cfab083bdce1eb 000014455 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19640 22ded05c514ca3532e88673eee3103458cd9651183f17c9aa75b42ca52e5f971 682f51f0bf1311e0c818cb67 682f4fb6e960150854c84153 Rene Brodeur Rene Brodeur rpbrodeur@gmail.com 017288 9 2025-09-02 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. - Maia H. 2025-07-29 16:48:32 -836.7 hrs 682f51f0bf1311e0c818cb66 000006600 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19639 6be7ee80a7810f96c2db1dcd962b2f96acb0b5d1d4452a621281fdf0d8770b20 68a5fd61cc00ec0894e75d5c 6887e0669b77f5683408a822 Jack Miller Jack Miller jack.merrill.miller@gmail.com 017713 15 2025-09-02 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Maia H. 24+ found PT that works w/his schedule- sc Sonya C. 2025-08-29 16:40:09 -93.1 hrs 68a5fd61cc00ec0894e75d5b 000016903 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19638 a3a48b4a4893ffd0e7208eb53925783deb08bc35ef4ca712e5453584a22666a7 689df4aa603056081c9b9633 67ced3d67abf9f3ed8feb244 Joseph Kent Joseph Kent j.mkent@comcast.net 007637 319 2025-09-02 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. - Sophia L. 2025-08-18 18:32:36 -355.2 hrs 689df4aa603056081c9b9632 000016256 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19637 df726e8c436db225219fc15c6c02ae845f17748b9aa7b6840a44fd4325aa6880 686d787fbabc7c081430042f 67f6911cb12c7b079be55ce1 Julie Ramirez Julie Ramirez oracle789@hotmail.com 017019 12 2025-09-02 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ LVM to cancel appointments due to work getting super busy - sc Sonya C. 2025-08-21 19:40:33 -282.1 hrs 686d787fbabc7c081430042e 000012145 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19636 efdd826945037e990568c9e4073d1e1cb436f4f7ee05b0a34f9538503fdaad77 685d67a1485088a8edfe5db6 685d66ca138ccaa932608843 Conchetta Robinson Conchetta Robinson chettafifty@gmail.com 017530 6 2025-09-02 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 7/7 Sophia L. 2025-07-07 17:54:07 -1363.8 hrs 685d67a1485088a8edfe5db1 000010894 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19635 21c9c4d46ce65e8623e08ab94f22944893b751d656ba36b8d7251781f4020fea 689cc55754678f07a1cba1c7 689cc42fc002b207a4eac1ec Kelly Siu Kelly Siu ksiusiu@yahoo.com 017791 13 2025-09-02 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-09-02 21:10:12 7.2 hrs 689cc55754678f07a1cba1c2 000016173 3.00 80.00 105.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19634 a2da0d16dc2b433730b7383a29e21b96434ce462fcef2eb73506c4a69675983d 6890db30424398086b12f030 67ced51d7abf9f3ed8feef47 Maravene Roscow Maravene Roscow mroscow@icloud.com 012841 50 2025-09-02 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Beth Roscow 8:14 AM (1 hour ago) to me Hello, I have a scheduled appointment with John Phinney tomorrow, September 2 at 8:00 a.m. I have a dental emergency that started yesterday and am waiting to hear back from my dentist’s emergency services. I need to cancel my PT appointment in case my dentist can fit me in tomorrow morning and also due to the severe tooth pain I am experiencing. I did leave this information in a voicemail just now , but I wanted to email as well. Thank you. Beth Roscow (officially Maravene Roscow) Sent from my iPhone Ranjini Ridgway 2025-09-01 16:07:56 -21.9 hrs 6890db30424398086b12f02e 000015224 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19633 a83c92dff0dab06b5ea4199fa522f353f63f5283904ea7cb8c2794389592dd75 6880f92965c89b07ad643d95 67ced2e87abf9f3ed8fe59a7 Christin Bellian Christin Bellian christinbellian@gmail.com 000076 140 2025-09-02 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ pt conf cxl SL 8/25 Sophia L. 2025-08-25 19:33:07 -186.4 hrs 6880f92965c89b07ad643d94 000013947 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19632 22ef79a573879c3fe64eab320b0d658a916aad0c50839a0ce1b3a00808ce1997 68765e755776f3085fe13d8b 67ced3d67abf9f3ed8feb244 Joseph Kent Joseph Kent j.mkent@comcast.net 007637 319 2025-09-02 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-07-17 14:02:41 -1128.0 hrs 68765e755776f3085fe13d8a 000012921 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19631 3c02f084d95180cde9fc410c2f5782687f01e43154d4a5a0bd66fbb1f9be86a3 687180cb11db0e33e935ac20 68717f53bf71e50794b717b6 Alison McGinty Alison McGinty alison.mcginty@gmail.com 017618 12 2025-09-02 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Ranjini Ridgway - Anne Majewski 2025-09-02 16:43:18 2.7 hrs 68c87ae2276f1826f7ffc522 000012730 3.00 233.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19630 6d9d31f914a0478a6ba9ccc67728bfffea3d201f22348c54bfe66f9eb2d6f2a8 68b71c09e6dd89ad34d3e1b8 68a6117be41064d554d9ff91 David Adams David Adams davidadams1975@gmail.com 017842 12 2025-09-02 Cancel 6899858814e44ebdae34c0b7 Rayann Greer 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 689983a679e412ce7c3dfcf6 Westminster Unpaid - Unidentified - - No Frances Lawrence duplicate appointment Ranjini Ridgway 2025-09-05 13:35:03 71.3 hrs 68b71c09e6dd89ad34d3e1b7 000018338 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19629 bdcf09f5169728c894434822e313844e7069091c24217856366500d0653cb357 68adbae76d69b10790ac80c5 68128cf6c88f4807e49ed4ec Karen Shepard Karen Shepard kshepardinco@msn.com 017163 21 2025-09-02 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Samantha Saunders 2025-09-02 14:18:19 0.1 hrs 68adbae76d69b10790ac80c4 000017498 2.00 58.75 58.75 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19628 82fee7de3ff3a6b0e74317c2cbd40896dfd654015f3b075f5ea1506693cb1b92 68a7bd3bc9fcb034297ff5da 68a6117be41064d554d9ff91 David Adams David Adams davidadams1975@gmail.com 017842 12 2025-09-02 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 689983a679e412ce7c3dfcf6 Westminster Paid - Patient - - Yes Frances Lawrence - Rayann Greer 2025-09-02 16:37:29 2.4 hrs 68a7bd3bc9fcb034297ff5d9 000017183 4.00 80.00 96.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19627 b54968e5ef7dbe695706552385924c6aa3047d2cf551c549a118b34b87ead6f8 68a4c1208b8a1c08908b72f7 687e5f366a5c8908779e8d59 Eileen Koch Eileen Koch es.koch@comcast.net 017659 14 2025-09-02 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. Pt texted to cancel yesterday. No fee. Michelle Osgood 2025-09-02 14:26:30 0.2 hrs 68a4c1208b8a1c08908b72f6 000016733 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19626 82a81e08135faa7f0316b23bb4a703732b14ea2de02b7789656297a18a2e7a7a 686c075a8caa05b3c18e3c5d 67ced3897abf9f3ed8fe9df8 Don Frasier Don Frasier dgaf76@gmail.com 005905 25 2025-09-02 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-09-02 20:57:27 6.7 hrs 686c075a8caa05b3c18e3c5c 000011914 5.00 95.00 95.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19625 4278a7c5bc8a22e4bb29585e9b508fd1836a4d84c20e6007eab38844167d4b80 685eb6e82dbc6408113626be 67ced6337abf9f3ed8ff15e4 Kristen Williams Kristen Williams knkendrick@gmail.com 016134 167 2025-09-02 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Marguerite Barth 2025-09-02 14:17:48 0.0 hrs 685eb6e82dbc6408113626bd 000011059 4.00 85.00 85.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19624 81b1a0ca816f56d861b866abba5c3aee594ef9fb6ee4b87f9ed132df40fbdfce 6826005d074e61c9635271a2 682226a029317aa10077bb60 Mary Graber Mary Graber lisagraber1@yahoo.com 017221 17 2025-09-02 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. Had dental emergency- sc Sonya C. 2025-09-02 14:27:27 0.2 hrs 6826005d074e61c9635271a1 000005681 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19623 88bb973eda9fff7a797866ba0f0a73892ea600b3e23753d807e100990e30a43b 682375dcb42f3051f008c458 67ced5b77abf9f3ed8ff059e Patrice Streicher Patrice Streicher patricestreicher1@gmail.com 014746 42 2025-09-02 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-05-13 16:40:47 -2685.6 hrs 682375dcb42f3051f008c457 000005371 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19622 4a2824a3d518ba0d9c9d08380623c2a482cef838156573d4756998b90a100545 681a45b8a0dd1e772d1c5f07 67ced5cf7abf9f3ed8ff08ce Julie Volckens Julie Volckens volckens@gmail.com 015018 94 2025-09-02 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - System 2025-09-15 06:00:04 303.8 hrs 681a45b8a0dd1e772d1c5f06 000004446 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19621 d67b993f08ddfd5f5803a304d687dce9fbdce2f43af5b14f8d561ab56b5fe338 68adb668536b9507b6195866 682f9fd7c26aefaa6d6877d8 James Lesch James Lesch jlesch@comcast.net 017297 14 2025-09-02 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. Mon 7:50am Jim 303.249.6782 has an apt tomorrow with Hope at 8:30am, won’t make it. His car died. Will come back once car is fixed. Ranjini Ridgway 2025-09-01 16:20:56 -22.2 hrs 68adb668536b9507b6195865 000017497 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19620 353066942faca0dc477da68a78137f97de0db1e36aea94aba2fea44b3fc8ec0f 68a792abe7875bf88ccb0360 68a79210787a59a3c10467de Tracy Brennan Tracy Brennan tracy.brennan@comcast.net 017899 16 2025-09-02 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-02 14:30:16 0.0 hrs 68a792abe7875bf88ccb035f 000017167 3.00 70.36 19.36 - - - - - - - - 2026-02-19 23:18:00 2026-05-15 23:41:30
19619 330456071c09b06326f1e41b4599d052ba525359fcae8e37ded872831317fc01 68a4d2c9e054fa08550699f9 68a4d1cbb7a2ac08140d2bce Chelsea Hackett Chelsea Hackett chelsea.hackett@gmail.com 017825 16 2025-09-02 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. nln AM 24+ Anne Majewski 2025-08-29 19:12:52 -91.3 hrs 68a4d2c9e054fa08550699f8 000016748 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:17:44 2026-05-15 23:41:30