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
29229 3ce97f44edc974fb77b167db59a467ef5aaa437419cdb48039465609eb41af21 67f825866d54104fed03fbb8 67ced51d7abf9f3ed8feef26 Kaylin Root Kaylin Root xckaykay@gmail.com 012830 27 2025-06-17 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 6/3 Sophia L. 2025-06-03 17:13:55 -335.0 hrs 67f825866d54104fed03fbb7 000001806 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:11:00
29228 56d45c4679dbf982b2f067a1459a61fa2574507e3e1f61f0dfa573dc1b776462 6851796882c31567b7a04bc0 67ced2f87abf9f3ed8fe6502 Megan Carothers Megan Carothers megan@carothers.name 001045 39 2025-06-17 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Patient - - Yes Michelle W. - Maia H. 2025-06-17 16:23:30 -0.1 hrs 6851796882c31567b7a04bbf 000009539 3.00 80.00 0.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:11:00
29227 69a8f78adcf2cd175e7a57e1e283c3ff7df650cc9f692f2524c175f6cdabaf84 68516d617027c4085d43e53a 67ced2f87abf9f3ed8fe6502 Megan Carothers Megan Carothers megan@carothers.name 001045 39 2025-06-17 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Samantha Saunders accident Samantha Saunders 2025-06-17 13:28:15 -3.0 hrs 68516d617027c4085d43e539 000009534 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:11:00
29226 91798ae1d6281a8dfd053a795ba4d671fda5bddd494a4f83ef7e8d6c3a44b528 6840ba0743650607f625bf0c 67ced3ea7abf9f3ed8feb6c7 Laura Kohlerschmidt Laura Kohlerschmidt lkohlerschmidt@gmail.com 008022 73 2025-06-17 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-06-17 16:47:03 0.3 hrs 6840ba0743650607f625bf0b 000008225 3.00 80.00 64.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:11:00
29225 dc9a0441296872766a05e98d2b949ee3cb6ffff752e97cb7607b83ff26d0b999 683e0d2ef7890e585f2d1084 67ced3257abf9f3ed8fe7aaa Daniel Cohen Daniel Cohen dan@urbaninvestmentgroup.com 002893 8 2025-06-17 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-06-17 23:06:34 6.6 hrs 683e0d2ef7890e585f2d1083 000007819 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:11:00
29224 ea1529eb494b05201d81aacdc826e7b4117265ff6534a08f75cdf262aed32bea 68376e404acac49e157b7a7f 67f8174a7d103608033b63b1 Trisha Sarfaty Trisha Sarfaty sarfaty_trisha@svvsd.org 017031 20 2025-06-17 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Sophia L. 2025-06-17 16:33:45 0.1 hrs 68376e404acac49e157b7a7e 000007308 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:11:00
29223 fb4dff1036cd1983769c28522c4168d719464b452b2414ee1d2ae91dae653fad 681ce72d7a9079578facc3e4 67ced32f7abf9f3ed8fe7eb8 Patricia Burke Patricia Burke pburke@boulder.net 003239 41 2025-06-17 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-06-17 22:47:27 6.3 hrs 681ce72d7a9079578facc3e3 000004898 2.00 80.00 80.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:11:00
29222 c0a16cb02020f9a0f15f7a225c267056a312a64cf6a5fc4d82822af3b4a75f81 680023a37be5ac1fbe03c40a 67e66585efbf2c53d8d5e56d Aja Jimenez Aja Jimenez aringo13@gmail.com 016829 10 2025-06-17 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67fe758025fd260826e4f8b1 Pelvic Floor Initial Evaluation 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Ranjini Ridgway 2025-06-17 22:44:20 6.2 hrs 680023a37be5ac1fbe03c409 000002543 4.00 85.00 170.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:11:00
29221 70ecc79985265f77198783a4a0523f33dffc3d9966e68e4ca7d30f38e6f697ba 6800223f314cde07f63210f8 67ced3a57abf9f3ed8fea58a Aja Jimenez Aja Jimenez aringo13@gamil.com 006551 4 2025-06-17 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Maia H. 2025-04-16 21:39:33 -1482.8 hrs 6800223f314cde07f63210f7 000002537 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:11:00
29220 39cba2563c243e28cff03ea83abd993c6fb6fc5663fa056be85b8c98863e9343 67e67394ceb9f104f02951fe 67ced3d17abf9f3ed8feb10c Marianne Kellogg Marianne Kellogg kelloggmm@msn.com 007533 43 2025-06-17 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Michelle W. 2025-06-04 19:26:45 -309.1 hrs 67e67394ceb9f104f02951fd 000152484 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:11:00
29219 2b560b1cdf14ffc665c188eed50ae2a4f796e93e66d10a67787208eb026103dc 68505e0d1170c708656a7de8 682226a029317aa10077bb60 Mary Graber Mary Graber lisagraber1@yahoo.com 017221 17 2025-06-17 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-06-17 16:46:28 0.0 hrs 68505e0d1170c708656a7de7 000009470 2.00 55.44 55.44 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:11:00
29218 2c163cd8db106b5bf3951954eab9001765e39191cab23bd16f6adc89f6811a92 684324bebc178807f2ade916 68094b0a469d46f8d8d1ad8f Stephanie Shanahan Stephanie Shanahan st_shanahan@hotmail.com 017120 12 2025-06-17 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Ranjini Ridgway 2025-06-17 23:14:46 6.5 hrs 684324bebc178807f2ade915 000008579 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:11:00
29217 a21d9d12689c44a8de5c493982224f80d6db50e6fb4fb3952ad84f883c2a2e08 6840c02729616f07c4bdea2c 67ced3bd7abf9f3ed8feabe4 Andrew Juniper Andrew Juniper paul@pauljuniper.com 007093 43 2025-06-17 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Michelle W. - Maia H. 2025-06-16 19:31:18 -21.2 hrs 6840c02729616f07c4bdea2b 000008328 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:11:00
29216 397cdb325ddef4307c46b42c2cb2434dc2cccd2ce1d5a53daa259c3201b4f7e0 6810f53214b3a0089aefff27 67ced5987abf9f3ed8ff0161 Jenny Santucci Jenny Santucci gomezdbsj@yahoo.com 014385 297 2025-06-17 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-06-17 16:46:19 0.0 hrs 6810f53214b3a0089aefff23 000003776 2.00 72.69 72.69 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:10:44
29215 4e548cd37ff70d36c3403f6c1e62c53edcd647571a33d7817772c0b8709dafc4 67e67333ceb9f104f0293835 67ced2ee7abf9f3ed8fe5ddc Raquel Cagan Raquel Cagan raquelsfishing@yahoo.com 000435 220 2025-06-17 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Sonya C. 2025-04-15 17:20:34 -1511.4 hrs 67e67333ceb9f104f0293834 000152340 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:10:44
29214 631d0b3769376fc51167603c575f55e49b3f318ed7b9688afbd9a799acacc8ae 67e67333ceb9f104f0293812 67ced36b7abf9f3ed8fe9489 Kim Fisher Kim Fisher kfisher1776@gmail.com 005100 13 2025-06-17 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Michelle W. 2025-06-16 16:07:30 -24.6 hrs 67e67333ceb9f104f0293811 000152339 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:10:44
29213 27d174ccf08571b577736b5ed39493be5dcf7e3c6db45b5d4a720e73c9d8cb43 68509a038168f507a21cbce2 67ced6267abf9f3ed8ff1434 Mary White Mary White bolles1@comcast.net 015990 50 2025-06-17 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-06-17 17:03:18 0.1 hrs 68509a038168f507a21cbce1 000009527 4.00 135.57 135.57 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:10:44
29212 6d62e96b70071c9801d7602472ad83e80061abb917229a0b2f710873ed187013 684c4447ac9ab60772f080d2 67ced65e7abf9f3ed8ff1b2e Cathy Zimmerman Cathy Zimmerman cathyzimmerman9@gmail.com 016585 99 2025-06-17 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Sophia L. 2025-06-17 18:34:32 1.6 hrs 684c4447ac9ab60772f080d1 000009270 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:10:44
29211 31336bd0a50e8cf3adc1d8a3b37e18c43b6acbcc4979dffce3f72dc41f19b476 68473aaa29dcc561378b1b46 6847397e2896c91e9d65bce4 Ernest Merklein Ernest Merklein tripmerk@gmail.com 017422 7 2025-06-17 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Ranjini Ridgway 2025-06-26 15:14:14 214.2 hrs 685d641590fd6f08050c392d 000008765 5.00 80.00 45.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:10:44
29210 1c56c512e4024fa0c3d1e5b7c37696ce4aaff08e982a372130ce57f8d91fe325 68406474e73c5508183f5a2b 684063b54ad3b0077d359da8 Edward Odom Edward Odom ted@odomcs.com 017381 6 2025-06-17 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-06-17 23:07:18 6.1 hrs 68406474e73c5508183f5a26 000008106 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:10:44
29209 931942924d3a447fb6c76766eae6fc1de9c4076011d2a71e74faad7bac26a874 68220cc4cb08c5e9032aefc2 6802c5e4854d7f08aca8d7fb Susan Secord Susan Secord sasecord3@gmail.com 017094 11 2025-06-17 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Gillian B. - Ranjini Ridgway 2025-06-17 23:09:56 6.2 hrs 68220cc4cb08c5e9032aefc1 000005129 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:10:44
29208 c8c4944f3cc7b8c71a356deed7f56cf712b2cfe8ff1570cea2a358c6685c6eb5 6813ac0de04c78079637dbb5 67ced3ca7abf9f3ed8feaf35 Bruce Kawin Bruce Kawin bruce.kawin@colorado.edu 007376 153 2025-06-17 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Partially Paid - Patient - - Yes Maia H. - Maia H. 2025-06-17 17:01:25 0.0 hrs 6813ac0de04c78079637dbb4 000004055 3.00 81.40 74.53 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:10:44
29207 2327ade6539c00eb614a17b376af2e0ec48f8545a24f6de51ddeed3c11262fb6 67feb72c147d59392a644f2c 67ed591bd9abaf4bbed32780 Stefanie Selden Stefanie Selden stefanieselden@gmail.com 016961 12 2025-06-17 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Sophia L. 2025-06-17 17:05:00 0.1 hrs 67feb72c147d59392a644f2b 000002334 3.00 80.84 80.84 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:10:44
29206 b59f083742e5aa70f47843ef99f519347c0c7a6b6f79e7e3fb4d7c5e06f0eb4a 67e67332ceb9f104f02937f3 67ced39a7abf9f3ed8fea2b4 Stacey Gurr Stacey Gurr sngurr@gmail.com 006309 217 2025-06-17 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton Sat 9:25am Stacy Gurr, needs to cxl appointments the week of June 16th out of town. Ranjini Ridgway 2025-06-15 16:55:53 -48.1 hrs 67e67332ceb9f104f02937f2 000152338 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:10:44
29205 d415d824c6e2bad384f2fa4f59fd796bedc5e2881924a2f2d92057b0e246256d 67e67332ceb9f104f02937b3 67ced5ed7abf9f3ed8ff0cb2 Sherrie Walter Sherrie Walter sherrie.walter17@gmail.com 015350 66 2025-06-17 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Dawn Singleton - Sophia L. 2025-06-17 17:02:30 0.0 hrs 67e67332ceb9f104f02937b2 000152337 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:45:15 2026-06-12 00:10:44