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
28733 f943c0f859936f7adb71f078d4f53c4ed157cef2095796260518360781c5b46d 6824dded6dd5f9b711bbd334 67ced5497abf9f3ed8fef5da Holly Sprenkle Holly Sprenkle hollysprenkle@comcast.net 013402 9 2025-06-19 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-06-19 20:11:00 2.7 hrs 6824dded6dd5f9b711bbd333 000005552 4.00 95.55 95.55 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28732 096ae96950bc27fa0dd81160e37643df31a015efbcab0c13a874a9bbad357af9 681ccccbdf368a080575ac29 681ccbc03aa35bc149703fac Colleen Cimino Colleen Cimino colleencimino@comcast.net 017202 11 2025-06-19 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-06-19 17:56:32 0.4 hrs 681ccccbdf368a080575ac26 000004776 4.00 155.00 155.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28731 1386a5504a23e0698bf41f9dffded85c3728b90e029991743e8114d3d2219b86 67e67364ceb9f104f029443a 67ced3347abf9f3ed8fe8119 Audrey Cook Audrey Cook stevecook92@gmail.com 003442 87 2025-06-19 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Dawn Singleton - Ranjini Ridgway 2025-06-20 18:19:32 24.8 hrs 6855a642f1f61f0578f5fc5b 000152413 5.00 85.00 45.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28730 edc0df8a8c8ced2756ca42400355b4d2c4bb823165c2162b9b315d1773279d68 67e6730cceb9f104f0292d35 67ced3527abf9f3ed8fe8c1f Jennifer Espinoza Jennifer Espinoza jenn.espinoza@yahoo.com 004382 7 2025-06-19 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Michelle W. 2025-06-18 20:25:32 -21.1 hrs 67e6730cceb9f104f0292d34 000152280 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28729 5b43fe9d1b25955337e54fb850e1568c76fa8354f653666d52abb34bd6ed4398 682e53a3c7538b2dfe9982a1 682e527e9dd8abe05a5d2036 Charles Richards Charles Richards cdrichards2@yahoo.com 017283 7 2025-06-19 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a679a3294b1b37ef18c48c AIM AUTH NEEDED - GET OUTCOME 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-06-19 17:44:54 -0.0 hrs 682e53a3c7538b2dfe9982a0 000006518 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28728 6fbe25a4b2725ce0e7a8a59777be89d6898ae45dc6e878f9f2557164cd0563d3 682d067047dfa71e3101dab7 67ced2ed7abf9f3ed8fe5d8b Sriya Bhattacharyya Sriya Bhattacharyya sriya.bhattacharyya@gmail.com 000408 32 2025-06-19 No Show 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. - Sophia L. 2025-06-19 17:57:22 0.2 hrs 682d067047dfa71e3101dab6 000006345 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28727 911812bd28a93090096c417a9052a8ef7ef4f31e5861dd33127f4c542c99bc82 682cac1ed035d808913b3876 682cac0bbd74b0078dac4e15 Heidi Young Heidi Young heidi.e.young@gmail.com 017268 13 2025-06-19 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67fea39d8c6bf607d763e7ee Kaiser Pelvic Floor Initial Eval 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Heidi Young 2025-09-30 15:37:44 2469.9 hrs 682cac1ed035d808913b3875 000006231 1.00 150.00 150.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28726 547174e4e90fa57d4cb29c834c8509d2d9ec4df78fe8e326575f35718c98e6f5 681a8b4c41326b54d95064a1 680908e6dc968f594897748f Peggy Moore Peggy Moore pjmoore46@msn.com 017113 70 2025-06-19 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24 + see note on log- sc Sonya C. 2025-05-19 20:01:12 -741.7 hrs 681a8b4c41326b54d950649d 000004562 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28725 81cc9e1e6cfa754259e9d8bce49eb68bf8259c4ca419bf7458cd3be18d948644 68113c22f12927df51d120d8 67e1258654aaaa3a80096bca Doreen Davis Doreen Davis doreen.davis00@gmail.com 016694 12 2025-06-19 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. - Sophia Phillips 2025-05-19 20:38:03 -741.1 hrs 68113c22f12927df51d120d7 000003862 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28724 f16b15cf68bcd86c50d4696d80f47d22f81014bc6a7003c8e388f936d4a00dc5 685053e17ec9fc08095f3be2 68470d0aeb7d482d9c8ba56d Cynnamon Kiser Cynnamon Kiser alpineteacup@gmail.com 017418 23 2025-06-19 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Pt called and LVM cancelling appt - sc Sonya C. 2025-06-19 15:59:58 -2.0 hrs 685053e17ec9fc08095f3be1 000009463 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28723 f59476c393e57249b1f0f8b52b772fe5dbffec469ecdf8335c2d9f5408eb9eee 684884feb55a51088561ce97 67ced4547abf9f3ed8fecc8b Johnny Morgan Johnny Morgan johnnymorgan1@mac.com 009878 31 2025-06-19 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Sophia L. 2025-06-19 18:51:09 0.6 hrs 684884feb55a51088561ce96 000008907 2.00 54.89 54.89 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28722 ee42eb07f63896591934cbced3354a236ee9b08281aeaee9e96ae94873b7bcc3 682df4be9dd8abe05a59619b 67ced4397abf9f3ed8fec747 Judith Litsey Judith Litsey judith.litsey@ptofboulder.com 009429 23 2025-06-19 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf rxl SL 6/9 Sophia L. 2025-06-09 19:21:34 -238.9 hrs 682df4be9dd8abe05a59619a 000006395 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28721 05dedd14747a75d2762ea8f3a1ac5981fcf7d4019c792ced3285231eb492645b 683f516bcd8566787091649c 67ced3287abf9f3ed8fe7bb8 Rae Buchanan Rae Buchanan raebuch66@gmail.com 002983 42 2025-06-19 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Gillian B. Doesn't need Eva Tucker 2025-06-18 14:07:00 -28.4 hrs 683f516bcd8566787091649b 000007990 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28720 81b6e798ac6679c2b27b9f8a847c34d95c71450f7494fc0ccced12ac8bb1ee28 683f0707a406d9e361695496 6839bfee4bc12ac92a39b5c9 Donald Blunn Donald Blunn dablunn@yahoo.com 017343 12 2025-06-19 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. - Michelle W. 2025-06-18 22:03:05 -20.4 hrs 683f0707a406d9e361695495 000007868 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28719 01b126b70fac377a88864d30c5d3b5d65dec674f9f32a45c00f15a6579495521 6836207a0e89b202ea9d501b 68361eefabc8af3bfb0deda7 Taylor Mallett Taylor Mallett taylor.mallett05@gmail.com 017317 14 2025-06-19 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. sc Sonya C. 2025-06-16 15:59:57 -74.5 hrs 6836207a0e89b202ea9d501a 000007073 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28718 3d22f9c5c7085ac599b72bdabd159c66db27547f4abab83c372b28fe5cac8fbf 682f356d6ad6c8aafcc43d21 682f3490b0657308319913c9 Clifton Lines Clifton Lines lines@colorado.edu 017285 8 2025-06-19 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Sonya C. 2025-06-19 19:29:24 1.0 hrs 682f356d6ad6c8aafcc43d20 000006543 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28717 d084b27d1c3fe4027a5ce35e3ccc8aa5b77ae30ae823f9289fd36cdd453f1948 681d0f847a9079578faeb8d1 67f8352a25a7b49f229bf9aa Susan Jensen Susan Jensen suejensen12@outlook.com 017033 7 2025-06-19 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Samantha Saunders - Ranjini Ridgway 2025-07-23 17:09:29 814.7 hrs 681d0f847a9079578faeb8d0 000004943 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:40
28716 6544c5033d8d5f0869e9b78e1a563b2bd79f90d4b4580620478547352df7d1bd 6802ad1ab9ce060791b43a88 67ced3267abf9f3ed8fe7b01 Julie Cohen Julie Cohen goteamcohen@gmail.com 002922 5 2025-06-19 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Maia H. - Maia H. 2025-06-16 22:07:24 -68.4 hrs 6802ad1ab9ce060791b43a85 000002836 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:24
28715 656dc7c7f3d414876a84581b5b8f6bf26595b4150a21ee93e1e4f465c286db77 6801363eec72000817b3f123 6801356f496d2e085b67fdcd Tyson Fox Tyson Fox foxshox182@yahoo.com 017075 8 2025-06-19 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. Pt is ill - sc Sonya C. 2025-06-19 15:14:31 -3.3 hrs 6801363eec72000817b3f122 000002622 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:24
28714 8bba19f433ab7c43765b1676fb84f2e2316e053547f5eba14af353baba636e45 6800079523ae4615536cb148 67ced5667abf9f3ed8fefa40 Juliana Statius Muller Juliana Statius Muller j.statius@gmail.com 013777 71 2025-06-19 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-06-22 22:29:26 76.0 hrs 6800079523ae4615536cb147 000002482 3.00 56.00 56.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:24
28713 64134a178d3d738c8ad412492f72ca7606d152f81526683982527522eb85ca1e 67fd415ecd6b53086f60a35e 67ced3437abf9f3ed8fe86c9 Kristin Dugger Kristin Dugger kristindugger7@gmail.com 003927 55 2025-06-19 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-05-06 19:31:52 -1055.0 hrs 67fd415ecd6b53086f60a359 000002079 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:24
28712 7df3bc25348e03c59c6af4c18062d904ae1d07b44ea51da0576f93cafc47429f 67f955ae1a0104ec60106d6a 67ced32e7abf9f3ed8fe7e70 Carole Collom Carole Collom carolebob1960@gmail.com 003215 93 2025-06-19 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-05-15 21:01:00 -837.5 hrs 67f955ae1a0104ec60106d66 000001961 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:24
28711 dee6e00d779a9398938a374ef7deddcc0c43183c92394edc4505fa4beb9613df 67e6730bceb9f104f0292d13 67ced30d7abf9f3ed8fe7102 Kathie Davis Kathie Davis heather.stauter@gmail.com 002069 78 2025-06-19 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Dawn Singleton - Maia H. 2025-06-19 18:31:58 0.0 hrs 67e6730bceb9f104f0292d12 000152279 3.00 75.65 75.65 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:24
28710 b45c9a8ce28dfc7ca83491e0ce8ed7c430cb324e199c13283f16d5201c9f8777 67e6730bceb9f104f0292cf2 67ced3a77abf9f3ed8fea5e1 Judith Hersh Judith Hersh judyhersh@msn.com 006580 93 2025-06-19 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Dawn Singleton - Maia H. 2025-06-19 19:45:00 1.3 hrs 67e6730bceb9f104f0292cf1 000152278 2.00 80.00 80.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:24
28709 1c63cc68d36e41e675701ee7f32c07b71a426d8b8cbac7c673614b9e6b6402c1 6847063feed7a10755213783 6806972243b7fe84d4f9f04c Glenda Russell Glenda Russell gmrussell5@hotmail.com 017099 48 2025-06-19 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Ranjini Ridgway 2025-06-20 18:41:10 23.7 hrs 6847063feed7a10755213782 000008707 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:43:50 2026-06-12 00:09:24