General Visit (PT Boulder API)

Total rows: 100,227
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
7466 a4b033e607b099f8340be15171d18c9f129061e5b8d6764b96898f4efaefed22 68fab15fe7f4b10d42aba484 68faafab657cca0941b2eed2 Javier Becerra Javier Becerra javierbecerra0323@gmail.com 020139 23 2025-12-15 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Sophia L. 2025-12-15 22:23:57 0.4 hrs 68fab15fe7f4b10d42aba480 000024648 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7465 e231eb3e0bcd9e1b3b2f595b361226b81797e3d9e117b6791444c333022f2a29 68b772db6ab8bdc7b060c96a 67ced4587abf9f3ed8fecd4f Taylor Osgood Taylor Osgood tsosgood@gmail.com 009943 117 2025-12-15 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-12-19 21:57:39 96.0 hrs 68b772db6ab8bdc7b060c966 000018457 4.00 95.49 95.49 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7464 c04eb56e4b882d618247a24bd501947e126d1ae81193973740fd3c00680c267f 68a3a286cdbe8b7ce82c2150 67ced3757abf9f3ed8fe97cb Janet Hart Janet Hart janethart80301@icloud.com 005378 166 2025-12-15 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Unidentified - - No Sonya C. - Renee Carr 2025-12-15 21:56:18 -0.1 hrs 695be316780dcf5f2ed093ba 000016623 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7463 c8a93dfb5de37006c9d761883e9043ef52e1b72db701e7ca73bebb506a566da5 6937135d4d0d4bea2a34eea2 690ba0d8985e554429beb073 Christopher Basten Christopher Basten cpb62@comcast.net 020209 13 2025-12-15 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Michelle W. 2025-12-15 22:18:59 0.1 hrs 6937135d4d0d4bea2a34eea1 000029920 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7462 fcda8b9e0bd379795ad6473eb6c95f801202473c4e622b853365f29696f80ae5 69247a9e4c21a12444ef873f 69247a24ef5d509a4b3cb407 Joan Berman Joan Berman jody@bermaneditorial.com 020292 8 2025-12-15 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Renee Carr 2025-12-15 22:13:57 -0.0 hrs 69247a9e4c21a12444ef873e 000028143 3.00 80.26 80.26 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7461 d4fbffd13cc04cab871e4fceaa4a0669a6b9e37005a97ff334b03968e9e63b95 68f80bd8c4d22c0a4a973276 68f80ab3b70131fb13ed89f4 Diane Main Diane Main di_main@yahoo.com 020119 7 2025-12-15 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ per VM, she is dealing w/a family matter and can't come to PT consistently - sc Sonya C. 2025-11-24 13:06:22 -513.1 hrs 68f80bd8c4d22c0a4a973270 000024333 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7460 fbc0f0b53adb70c0590ffeab5f93fc78bcccb199c92f9f59c334ac48db4f11ea 6916688135f1cb2d615bfc2b 67ced3e57abf9f3ed8feb59e Yekaterina Klopp Yekaterina Klopp katya.klopp@gmail.com 007923 52 2025-12-15 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sophia L. 2025-12-15 22:38:21 0.1 hrs 6916688135f1cb2d615bfc2a 000027225 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7459 7952540d88ae4b8cb8956050929ce4fa9e78511b3f5bc65229b6e52be9662c85 68f94763df9ca66caffd065a 68cc204ce7ec5007a1fb3341 Sytera Field Sytera Field syterafield@gmail.com 019887 12 2025-12-15 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Haley Paull 2026-02-10 22:34:03 1368.1 hrs 68f94763df9ca66caffd0659 000024443 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7458 91700108d59e61eb7a8b1f1491040993813b6ab494967c5b7029ea25efa32607 69407c0c85f04de71fb97de0 67ced3147abf9f3ed8fe7405 Monika Atkinson Monika Atkinson mazabkop@gmail.com 002326 80 2025-12-15 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sophia L. 2025-12-15 22:45:24 0.0 hrs 69407c0c85f04de71fb97ddf 000030809 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7457 9f498d6c2c926a8ae8bd4cfea73899d80a89683095a1a08012246578b058570c 690a3fb87f8ae127e13dda10 67ced50e7abf9f3ed8feece0 Amy Schlotthauer Amy Schlotthauer harmshauer@hotmail.com 012636 45 2025-12-15 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Rosey Reed pt is sick -mw Michelle W. 2025-12-15 15:53:18 -6.9 hrs 690a3fb87f8ae127e13dda0f 000025938 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7456 cb6c34c0b76f4991efbdf53c395c9d860ac398fdbb1b0472ae6a8f6cf240d2c6 69401f56e40f19585faa8309 68c96968fde2a18396e28210 Erin Johnson Erin Johnson erinhjohnson@gmail.com 019865 9 2025-12-15 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Julie Petersen-Hanson - Kenneth Dave Francisco 2026-01-05 15:59:01 497.0 hrs 69401f56e40f19585faa8308 000030694 3.00 234.00 30.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7455 97be6151c1a6663e94e17a2ae5d1dc2de2331aace2126daef77d3b2c7c595d3b 69376e25362f229ad9f4e5e7 69160f6351c428d308c9ac08 Norman Chapin Norman Chapin machisapin@gmail.com 020240 20 2025-12-15 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Michelle Osgood - Mark Jerome Para-ase 2026-04-10 18:17:42 2779.3 hrs 69d93f46e87f476741e21174 000030042 2.00 152.00 10.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7454 cbf7cfb2e888d19348184ca6e76ff4af96561366f6346c457d4145c1a77eb520 690b8bb337d9808b1a0fca21 68f7c62388ff4e8c9079da79 Griffin Maxwell Griffin Maxwell ashleybuck66@gmail.com 020113 48 2025-12-15 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Renee Carr 2025-12-15 22:54:57 -0.1 hrs 690b8bb337d9808b1a0fca20 000026129 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7453 8df5be7b66d635ed9315e9519ecd530a4cc509fc170089b165adc90bbb898844 690266ec6561fb3183a2e33b 67ced32d7abf9f3ed8fe7df5 Jennifer Burak Jennifer Burak jenburak20@gmail.com 003174 101 2025-12-15 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ pt conf cxl SL 12/5 - OOT in LA Sophia L. 2025-12-05 16:02:52 -247.0 hrs 690266ec6561fb3183a2e33a 000025297 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7452 dcbbb4ae8158fc5daf23b118ec8883a247710165dad7cca616d6ea200b91ee5a 68c9c7214526e153249fbda0 67ced5837abf9f3ed8fefe64 Amala Singh Amala Singh Amala.Singh24@gmail.com 014130 47 2025-12-15 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sophia L. - Renee Carr 2025-12-15 23:01:19 0.0 hrs 69c7131d1ff25dc6394919b2 000019958 3.00 233.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7451 b1ae04fe77c5386496dc0b9b518f3023b3085dd3bd32ffea20ed10a345d974fe 692f9cc8faf7be9c7ddc7502 67ced4dd7abf9f3ed8fee4db Adam Quire Adam Quire awquire@gmail.com 011952 21 2025-12-15 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Peter Gagnon - Renee Carr 2025-12-15 23:07:29 -0.4 hrs 6965213836abab068d86ad5b 000029482 3.00 -23.00 35.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7450 d6177549b684cdedfa1fcc61ccb64420e2c3b97a51c648b25cfa4c2100b000ca 691b60c0e7b8136728dc2857 67ced5df7abf9f3ed8ff0ad5 Aaron Walker Aaron Walker rattpower@msn.com 015191 46 2025-12-15 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Elizabeth Cousins pt conf cxl SL 12/15- family emergency Sophia L. 2025-12-15 20:17:31 -3.2 hrs 691b60c0e7b8136728dc2856 000027396 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7449 4f846359082d8d2b89dbeb7456a2ac3a63643c45c610c3578368cefa48252000 690b72cdc6eca3fbefce9f34 690b71faeaea3dc6970e7947 Andrew Wan Andrew Wan andrewwan1@gmail.com 020203 5 2025-12-15 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ found PT that can see him sooner - sc Sonya C. 2025-11-05 23:00:05 -960.5 hrs 690b72cdc6eca3fbefce9f31 000026097 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7448 1a7af9b12fec319c9939268a52e2dd53c135c1ca0d86b5866866498ec8bce8dd 6909425d843b7e897ff53416 68f2621eb72986f10f1c33e8 Sina Anderson Sina Anderson neil.anderson@bvsd.org 020096 11 2025-12-15 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Per VM, Dad had work emergency and unable to bring her - sc Sonya C. 2025-12-15 20:12:26 -3.3 hrs 6909425d843b7e897ff53415 000025840 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7447 056f758c678b00ddc77a3d71a008eea2c4e0d764377f57ebe13bdffd14543927 68c9c72f65c1bfa3165dc98f 68c9c6695ae04e8dfc6677bd Safia Singh Safia Singh singhfam@msn.com 019877 17 2025-12-15 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ pt needs to see Michelle instead - RAR 12/8 Rosey Reed 2025-12-08 16:54:39 -174.6 hrs 68c9c72f65c1bfa3165dc98e 000019959 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7446 8eaf1aae6c82e23f2be36b4d14fcd0f89717c9d636657c15e71493c4772b7e8c 68c45cfa26767b510e0c7618 67ced61c7abf9f3ed8ff12de Debra Topping Debra Topping dbtopping@comcast.net 015876 152 2025-12-15 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sonya C. - Renee Carr 2025-12-15 23:34:29 0.1 hrs 6940a73fb169017d160a19de 000019703 4.00 125.91 100.31 - - - - - - - - 2026-02-19 22:43:30 2026-05-03 23:09:07
7755 cfb1dc2a67fdf5b945286bac4e1328261193046fbf0f8c72608633d4550a04b6 691f9ae45d90570e7b9e11c3 67ced34b7abf9f3ed8fe898b Avery Ellis Avery Ellis averyecological@gmail.com 004162 21 2025-12-12 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Mark Jerome Para-ase 2026-03-27 17:04:17 2537.1 hrs 69c6b8c0c15454b1995d5145 000027966 3.00 233.00 24.00 - - - - - - - - 2026-02-19 22:44:15 2026-05-03 23:09:48
7754 2ee5a602e761b08810c1747a0f8a148f5e15a5d61c0c3b94c4479ac9ec2474b5 68c9da12816adf0415ce0fef 67ced47d7abf9f3ed8fed460 Kathleen Parrish Kathleen Parrish kmcgparrish@gmail.com 010546 37 2025-12-12 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 2:56pm called to cancel because she wasn't feeling well -RC Sonya C. 2025-12-11 22:31:28 -1.5 hrs 68c9da12816adf0415ce0fee 000019977 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:44:15 2026-05-03 23:09:48
7753 d61c0680610227b3b20aa800b1995dac23a9f77092a3c848b087cb30a8233ea5 6903fb9e4d6d839d533ccf7f 684862a948ba666f6303f7f1 Summer Nicks Summer Nicks nickssummer@gmail.com 017430 16 2025-12-12 Checked Out 67acc4530db5de07addc9873 Anne Majewski 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Anne Majewski - Rosey Reed 2025-12-12 00:10:54 -0.1 hrs 694491c7164ef91a45b01e70 000025519 3.00 472.00 0.00 - - - - - - - - 2026-02-19 22:44:15 2026-05-03 23:09:48
7752 19b12356ffeee6dcba9f5c4a60b76ea68870193fdd44d59c6bb309adfc4ae56b 68df15d26770480c157f056d 67ced4727abf9f3ed8fed268 Nancy McGann Nancy McGann nancymcgann@imail.org 010378 45 2025-12-12 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Laura Shove conflict Laura Shove 2025-11-20 23:15:37 -505.2 hrs 68df15d26770480c157f056c 000022133 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:44:15 2026-05-03 23:09:48