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
24136 ae5cc4e8e3e0602efa606d2fe26a24ee558a824f615b3eacebcefbee2a8f6684 67e67216ceb9f104f028e944 67ced39a7abf9f3ed8fea2b4 Stacey Gurr Stacey Gurr sngurr@gmail.com 006309 217 2025-07-24 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Michelle W. 2025-07-23 13:35:20 -27.4 hrs 67e67216ceb9f104f028e943 000151903 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24135 106e9d62b5ad30b606f32e1ca4f8f5d83dda7dd7546f018db831bc5736cded48 67e67216ceb9f104f028e923 67ced41a7abf9f3ed8fec126 Betrah Mignerey Betrah Mignerey davidandbea2022@gmail.com 008906 230 2025-07-24 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Primary - - Yes Dawn Singleton - Maia H. 2025-07-24 17:00:39 0.0 hrs 67e67216ceb9f104f028e922 000151902 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24134 71ff04e410a12d19d02b22fff32944fe0ebe9d21d2d372c55d121d9951e73193 68771cfecf67020e3587fca0 67ced4be7abf9f3ed8fedfa1 Mary Pierce Mary Pierce pierce.mary@comcast.net 011506 11 2025-07-24 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Marguerite Barth 24+ patient cannot make it Ranjini Ridgway 2025-07-17 19:05:49 -166.2 hrs 68771cfecf67020e3587fc9f 000013133 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24133 51a7f3ad633adfd8e5120cb4f0e98addc7471923be01c737661da9a31bf51b49 6862dd74a05fdc610cc0c12c 67e1258b54aaaa3a80096c75 William Fischer William Fischer tbfischer5@yahoo.com 016751 24 2025-07-24 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes John Phinney - Ranjini Ridgway 2025-07-25 13:23:41 20.1 hrs 6862dd74a05fdc610cc0c12b 000011311 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24132 5d605022d0bdc350cc847f31a02e2ecbdc586eba08d33ee397cae78c355609f6 685d5d43befe2908093e7eed 685d5aff10240ca9c3528579 Robin Vaughan Robin Vaughan robinlv88@gmail.com 017528 71 2025-07-24 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-07-24 17:08:11 -0.1 hrs 688385d1fd935807afa4526c 000010879 3.00 77.82 77.82 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24131 d717e21e5f74a640ab1cd0129a15fd54b28ffeb868c4b535dad805350c5d106f 68599803c814d30854e1d124 68599286ed08c1df3c5041eb Katherine Robertson - Mazur Katherine Robertson - Mazur katie.jay3@gmail.com 017504 43 2025-07-24 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Gillian B. - Sonya C. 2025-07-24 17:11:03 -0.1 hrs 68828e882372fb07c81298b7 000010346 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24130 532a67ff58761c0501309f471bfdb5d7fd5c0460f181652b9f4105011ce42071 68559e048237d90840aee091 68559c5b2fcf7a07d52f8cc2 Patrick Walsh Patrick Walsh pawa1094@gmail.com 017489 32 2025-07-24 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. PTE Duplicated Sonya C. 2025-06-20 19:41:54 -813.6 hrs 68559e048237d90840aee085 000010171 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24129 b1d938060ad023c9e937d6f552dae703a6db4978c37e5d96f1c01663cd2e83f5 68559e02c5889107d989881a 68559c5b2fcf7a07d52f8cc2 Patrick Walsh Patrick Walsh pawa1094@gmail.com 017489 32 2025-07-24 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-07-24 13:24:21 -3.8 hrs 68559e02c5889107d989880e 000010159 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24128 ae801c518608afd47c5032f7b5d7345447ea310d06c54db1957deccb8fc508ed 685581cf56711b685095ae43 67ced4b87abf9f3ed8fedeb4 Andrew Novak Andrew Novak amynovak10@gmail.com 011427 13 2025-07-24 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Marguerite Barth - Maia H. 2025-07-15 22:34:37 -210.7 hrs 685581cf56711b685095ae42 000010116 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24127 9f562d34d73ab5c2c85119fc75d7706253a5e4eb62196a416814e3c66345fb05 6841b4edb6e038585dc7f666 681149bf14b3a0089af3b6b9 Maria Bradshaw Maria Bradshaw nenakat@msn.com 017153 17 2025-07-24 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-06-26 19:33:37 -669.7 hrs 6841b4edb6e038585dc7f665 000008400 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24126 54f07142286e088f9243643b79e1465222a8edecaa50c99e6072e67d45a02264 682f9c16e7fa90a37802cc46 682747e77e4dce07d584ea87 Robert Shapiro Robert Shapiro robertlshapiro@gmail.com 017252 26 2025-07-24 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. follow up in 1 month (7/14) Emily Pickner 2025-07-14 13:43:15 -243.5 hrs 682f9c16e7fa90a37802cc3f 000006719 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24125 c6abf4a22097eab5be307adb961b50df43d6525eccac31f05fa2134a38c23de1 682f43749dda5707899637a7 67ced3e47abf9f3ed8feb574 Sarah Kline Sarah Kline sarah.kline@tracegains.com 007909 37 2025-07-24 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Michelle W. - Sophia L. 2025-07-24 17:30:40 0.3 hrs 682f43749dda5707899637a6 000006578 4.00 95.71 72.01 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24124 1b04e15e7643d262e6189e9f465b99ff85cb17235b219e30e258c5caf75ac0ad 680be05657993d49943a57d4 67ed93364921cf049b750726 Colleen Dufresne Colleen Dufresne colleendufresneco@gmail.com 016966 60 2025-07-24 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Maia H. - Maia H. 2025-07-03 21:51:54 -499.4 hrs 680be05657993d49943a57d3 000003571 6.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24123 75757457164c3d83d9512a94f4ff7419a15a904ebab86568a79d25b0c2dd6c14 67e67210ceb9f104f028e75a 67ced4047abf9f3ed8febc6e Maxwell Lawler Maxwell Lawler lawler.maxwell@gmail.com 008504 199 2025-07-24 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Dawn Singleton - Ranjini Ridgway 2025-07-24 21:12:14 4.0 hrs 67e67210ceb9f104f028e759 000151894 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24122 bcb51ba96f9f7691d6f74b728c9142fe7fa5284fd01428f7178df6840b493032 6880082b76f4c60833f1f479 681ccbc03aa35bc149703fac Colleen Cimino Colleen Cimino colleencimino@comcast.net 017202 11 2025-07-24 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a67ab091753108089752a5 RTM READY 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-24 17:23:37 -0.1 hrs 6880082b76f4c60833f1f478 000013912 5.00 136.00 136.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24121 4d2b84554d963e1e131511e3ba77c783c95f60ccf571fc114aea50674c261f39 687a7fa43a9f4f0880d3eecc 686e7ecaac15020843003b48 Jason Cameron Jason Cameron Ltjasonrcameron@gmail.com 017592 18 2025-07-24 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Eva Tucker - Ranjini Ridgway 2025-09-13 00:18:33 1206.8 hrs 687a7fa43a9f4f0880d3eecb 000013532 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24120 0fb1185abb800ff905f83058d666bbb2c03ccc945a22e0d275ecbf566a37a390 686feb980a571efbe7978934 67e1258854aaaa3a80096c03 Nina Nilsen Nina Nilsen ninarae21@gmail.com 016713 47 2025-07-24 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-07-24 20:58:15 3.5 hrs 68829e860f3f5807c69f24c7 000012453 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24119 fdc32c9b01e9ce345955680c8df7c47cadc0e2f671bc8d36644ae92eb993f6c5 686ef5e449baba9102e1d7f1 68361eefabc8af3bfb0deda7 Taylor Mallett Taylor Mallett taylor.mallett05@gmail.com 017317 14 2025-07-24 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Hope Adair - Ranjini Ridgway 2025-07-30 16:11:04 142.7 hrs 688a4429a015c50e7439a1d3 000012381 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24118 4926428db3802f94d2c994f30ddd605ea40cebcf8c72395eccdfc59e385e1c45 685d7bf4ed891f08454bc811 67ced44c7abf9f3ed8fecb1a Jonathan Morales Jonathan Morales johnny11447@gmail.com 009755 74 2025-07-24 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 7/1 Sophia L. 2025-07-01 21:59:07 -547.5 hrs 685d7bf4ed891f08454bc810 000010932 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24117 19fea3c6d55aab80b3d50c87206dec31a7e0ba44e3633233661a1ad55d740a37 68503d4a0dce76d6d69c2ef6 67ced5597abf9f3ed8fef841 Rachel Trueblood Rachel Trueblood truebloodelf@gmail.com 013607 240 2025-07-24 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Ranjini Ridgway 2025-07-28 21:44:11 100.2 hrs 68503d4a0dce76d6d69c2ef5 000009424 2.00 60.00 60.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:52
24116 1950ce0a77ceb84a63314067e7472ef8c9c8683bfb83e59f70d8a2dbc9879c36 683f4b648c490b07c1840371 67ced3877abf9f3ed8fe9d26 Kathleen Iten Kathleen Iten dkitee@msn.com 005835 74 2025-07-24 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-07-22 20:22:19 -45.1 hrs 683f4b648c490b07c184036c 000007973 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:38
24115 93df156e47ee24e459ec9ea5f73521594a5120852457f3194eea956d67688679 6838779daec4ff75e03d6e48 683875e39c35ce07e0f71fc9 Julia Moritz Julia Moritz julia.moritz@gmail.com 017334 11 2025-07-24 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 7/9 Sophia L. 2025-07-09 15:04:30 -362.4 hrs 6838779daec4ff75e03d6e46 000007414 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:38
24114 194b628b386595682e1c896cbcec67885713a0b1dd59730ba941cf9eab21c754 6835dedb6160fb07ded062bd 67ced57c7abf9f3ed8fefd65 Barbara Stephens Barbara Stephens barbaramstephens@gmail.com 014045 133 2025-07-24 Cancel 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. - Maia H. 2025-07-17 15:18:04 -170.2 hrs 6835dedb6160fb07ded062bc 000006925 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:38
24113 3f4885403c5a76d8973121e3009dfc1006e76d29da02f249b69fcf09be5c7ac0 685ff7445cd081a90fbf4b39 67ced5327abf9f3ed8fef265 Brian Roux Brian Roux brianproux@gmail.com 013107 57 2025-07-24 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Marguerite Barth - Marguerite Barth 2025-07-24 18:14:05 0.5 hrs 685ff7445cd081a90fbf4b38 000011253 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:38
24112 1657cb123926c1db2de70275f6f9ebf0c41fc5e978bcbb2c23d9276eb5a34a56 68543257f7518f7fe3e80fb7 67ced4007abf9f3ed8febbba Anthony Laudisio Anthony Laudisio antonio@laudisiomobile.com 008444 102 2025-07-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Primary - - Yes Sonya C. - Ranjini Ridgway 2025-07-24 17:36:20 -0.1 hrs 68543257f7518f7fe3e80faf 000009914 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:38