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
18291 e68740d1bd23f1f2b74c687a709f68e636f44961f6849b77584c299fbf98c62a 6806a8e447db43d648206379 67ced3b87abf9f3ed8feaaa9 Midori Hironaka Midori Hironaka tfitz52@comcast.net 006988 121 2025-09-11 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sophia L. - Allison Reyes 2025-07-01 21:23:39 -1727.9 hrs 6806a8e447db43d648206378 000002960 5.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18290 2158f9af882c1f80b62858b4cb27ae7b8ed9039ddc3d13db7ee5f5200601470f 68c2f5a327a117ae0125e428 68bf2f2982ab1df8538e1ba7 Donna King Donna King ilyaking@gmail.com 019820 17 2025-09-11 Checked Out 67acc4530db5de07addc9873 Anne Majewski 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2025-10-16 22:16:04 840.8 hrs 68c2f5a327a117ae0125e427 000019523 5.00 83.55 83.55 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18289 879bd4dce65489dd4af648e938aba7f50764d3af8b83f9554b20f4cffc86fd84 6876d5f91db9a84d84ae8b66 67ced2f57abf9f3ed8fe639d Christopher Crisman-McQuarrie Christopher Crisman-McQuarrie cammcq86@gmail.com 000926 14 2025-09-11 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-22 20:55:59 983.4 hrs 6876d5f91db9a84d84ae8b65 000013129 3.00 85.00 157.25 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18288 96f4e0b24c221c35341d47abfc1e407e3d6d7fa38d0fdd5f9fe1108e4e4ba9ba 68ba0c842ac01bb1d5aa225c 67eab3a06cfbde087431910a Jeniffer Grodberg Jeniffer Grodberg jeniffer@jeniffergrodberg.com 016934 15 2025-09-11 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a679be05de5fabb1c08f2d ASH (CIGNA) OT/PT Initial Evaluation - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-16 18:10:38 836.4 hrs 68ba0c842ac01bb1d5aa225b 000018813 5.00 159.73 199.73 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18287 d49c74eb4e7104bf8c639d98bdaa6f9eb5495d240e605ca8896a9bb84069ca4d 68b86821f77c39bfde1cc6e7 68a737b3b2718f28d2c7d759 Alexis Wang Alexis Wang awang@ball.com 017874 7 2025-09-11 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 68998453d9ae21be8001ca00 Boulder Julie Paid - Primary - - Yes Frances Lawrence - Kenneth Dave Francisco 2025-10-17 21:27:54 863.7 hrs 68b86821f77c39bfde1cc6e6 000018494 4.00 0.00 19.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18286 6b65ce318e1017c25873029bbe1cc862914aaaebaedb6ed6736336d2695e46a6 68892f7290fc89088675b2d0 67ced3d37abf9f3ed8feb184 Christine Kemp Christine Kemp christywkemp@gmail.com 007573 138 2025-09-11 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67875c9d2cdd464578564 ACN OT/PT Initial Evaluation - GET FORM AND OUTCOME 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - No Sonya C. - Kenneth Dave Francisco 2025-10-21 21:43:26 960.0 hrs 68892f7290fc89088675b2cf 000014658 0.00 0.00 80.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18285 1462e5e07a001fdb7caa112767a2dae60dda0479bc5991cfccb98b713eebf497 68703d61399a63a52eca3820 67ced4d17abf9f3ed8fee2dd Nancy Pottoff Nancy Pottoff npottoff@hotmail.com 011782 539 2025-09-11 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-11 21:43:46 -0.0 hrs 69174b64523df4042be09d5e 000012572 2.00 80.00 80.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18284 9da47795a4beecb9d364735fbb086310e9617cb5b76c29184bc9462dea16e2e7 68658c640de6e60804e805d2 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-09-11 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. 24+ sc Sonya C. 2025-09-10 20:14:51 -25.5 hrs 68658c640de6e60804e805d1 000011683 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18283 5c1d9eb0e2729d1aa2be6404a8cb23559a96b78dedcc7a7500506fc0cfc34f92 68b74985c5d023b55adb3f37 68a62e2e870ed4ee268fdc29 Julia Jaeke Julia Jaeke juliajaeke@gmail.com 017864 7 2025-09-11 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a678d8c9d2cdd4645788f0 Follow Up 689983a679e412ce7c3dfcf6 Westminster Paid - Patient - - Yes Rayann Greer - Kenneth Dave Francisco 2025-11-13 18:46:05 1508.8 hrs 691627c0bb52bf3331ed071e 000018376 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18282 8456f6282ec01037705a13413d8e3e0c208574f47fbabbebc3f06b6da84785ed 6887ef39a015c50e742f34de 67ced5997abf9f3ed8ff0170 Wendi Stewart Wendi Stewart stewart.wendi@gmail.com 014390 43 2025-09-11 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-11 21:59:35 -0.0 hrs 6887ef39a015c50e742f34dd 000014535 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18281 1eb776aabf4d8f3f060aff3e26b7b2cd59b00feb96f3a3108e8e7d26775d8178 685db5568b7ff6a8b9bef901 67ced3047abf9f3ed8fe6c13 Michael Botwinski Michael Botwinski mikejbot2@gmail.com 001648 33 2025-09-11 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-11 21:58:52 -0.0 hrs 685db5568b7ff6a8b9bef8ff 000011004 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18280 9174950d0e5e63c4fe5ce0b5c7be610f2ee54d9be41e49252a112576f3717e60 685ae47201495bb6a4f73777 67ced3487abf9f3ed8fe8867 Lois Edgar Lois Edgar edgar@colorado.edu 004065 236 2025-09-11 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. surgery Laura Shove 2025-08-21 21:13:39 -504.8 hrs 685ae47201495bb6a4f73771 000010523 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18279 31e9aa66bc602dae99a42484db319c5f8f04c9565e4c320aa47ba5a8ed5e078d 68a74d72374972367f8ebeef 68a613fa8d204e08519a4c3c Chandra Beck Chandra Beck chandra.beck22@gmail.com 017845 30 2025-09-11 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Primary - - Yes Sara Thompson - Kenneth Dave Francisco 2025-10-17 17:47:54 859.5 hrs 68a74d72374972367f8ebeee 000017068 3.00 234.00 25.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18278 3e80c60b1fb773c96fa1d49f1d1330f7b88f2c3c7094abdd5bb0cd7877055a55 689a1eca2c38bca8279f6c86 689a1dcde56be0bae2de4312 Alexa Vanderhoff Alexa Vanderhoff akvanderhoff@gmail.com 017775 10 2025-09-11 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Sophia Phillips 2025-09-04 22:57:37 -167.3 hrs 689a1eca2c38bca8279f6c82 000015920 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18277 c894e6344bdbb0f85184b4e5e8bd1bcfbe4f1e6c289d127e0fc47da3c98257f9 6893b5c07f3e617ebd5307f1 67ced42e7abf9f3ed8fec51c John Miranda John Miranda flymiranda@gmail.com 009244 113 2025-09-11 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-09-11 22:13:44 -0.0 hrs 6893b5c07f3e617ebd5307ed 000015553 3.00 77.56 77.56 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18276 45de8e310a70951e14963435b4b7e687805d13883e9b20cb50d210ba19005b35 687fc82ba895c9080fae5f57 687fc387fc35fe079a7fcc66 Kate Spradling Kate Spradling kate.spradling4@gmail.com 017672 20 2025-09-11 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-09-11 22:11:48 -0.1 hrs 687fc82ba895c9080fae5f54 000013843 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18275 2eb1e0a7ddb0de3dd34537cc5df6cc8fa384d094316a636941787aa80f3fcad2 68c06cc9a74610d0fd3c3cde 67ced3a37abf9f3ed8fea4fa Sarah Hernandez Sarah Hernandez hernandez_sarah@svvsd.org 006503 90 2025-09-11 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-11 22:27:39 -0.0 hrs 68c06cc9a74610d0fd3c3cdd 000019211 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18274 9c074d76b475b4a40aa847399e1c0f93b8a49edbc4fda8b3218ac304a8f6b748 68b06bf3f7fa61087a16e76f 67ced5677abf9f3ed8fefa67 Sara Ruwitch Sara Ruwitch sruwitch@gmail.com 013790 31 2025-09-11 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Anne Majewski - Kenneth Dave Francisco 2025-10-17 18:58:20 860.5 hrs 68fa4d2546b02141639b327c 000017943 5.00 159.65 214.65 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18273 62a4a98fb0fd18720a669a4013d611a4f182db3b0f7b551d74ecdb101ae8d6a4 68accf86c1c820085da11a36 687e75e40d5a13ac227d3ed0 Mary Kay Stewart Mary Kay Stewart mkwstew@gmail.com 017662 7 2025-09-11 Cancel 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Pt came in the office and the incorrect time, couldn't rxl - sc Sonya C. 2025-09-11 21:16:38 -1.2 hrs 68accf86c1c820085da11a35 000017478 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18272 a1661860b8d2dc7f6fd26b95b52afc2f06e6329f70f4a8f1b02bdac214b0c278 68894b650f49f01f911b5096 67ced56d7abf9f3ed8fefb34 Brian Steege Brian Steege bsteege@gmail.com 013858 57 2025-09-11 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 8/18 Sophia L. 2025-08-18 15:05:12 -583.4 hrs 68894b650f49f01f911b5092 000014721 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18271 c127ce618f32760bd06ad72d0d899665eb7c18ba9431d9c691634b81e58520f2 68b0b874282bd73c1aaaae4b 68af1e5ded4ab7088d7ec5df Asher Echery Asher Echery echeryaa@gmail.com 019754 8 2025-09-11 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Patient - - Yes Stephanie Braun - Sophia L. 2025-09-11 22:46:27 0.0 hrs 68b0b874282bd73c1aaaae4a 000018076 2.00 85.00 0.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18270 84c77839c8cf904ed38eecb2b12b0f25ebeb726a54f6c2f6539c3acad9d402cb 688b988801c6150846c3b9c3 6848895be76ec2076829f880 Britt Alstad Britt Alstad alstadb@proton.me 017433 21 2025-09-11 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ Incident in Boulder -eg Sonya C. 2025-09-11 20:56:08 -1.8 hrs 688b988801c6150846c3b9bf 000014938 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18269 e78a6f312db5e8f922c9cc06dbc1cba09559d308d5a66bc4972827ac2a299aa8 685eed5f87e5939a460530a0 685eec0ea88649740b79a68f Helen Andrews Helen Andrews alleycat@indra.com 017539 88 2025-09-11 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sophia L. - Rosey Reed 2025-09-11 22:42:30 -0.0 hrs 685eed5f87e5939a4605309f 000011157 3.00 232.00 0.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18268 b745b08f43a3e0ad1c0bd1e9031222383b3ab8de658a3d26f652c1e7d887ee6a 68ae06f0320097251af259c7 68a6318f43c9afe848883835 Alexandria Henderson Alexandria Henderson skysailer001@gmail.com 017868 4 2025-09-11 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a679be05de5fabb1c08f2d ASH (CIGNA) OT/PT Initial Evaluation - GET OUTCOME 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - No Sara Thompson - Amie Russell 2025-09-10 22:39:20 -24.3 hrs 68ae06f0320097251af259c6 000017605 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02
18267 6862dcab3c997ac2f0a1d8d76f8ad4c6fa1d1100c5e299830be76a6d5327739a 688a588f3b68350808c9cfec 67ced4be7abf9f3ed8fedfb3 Kiersten Pierpoint Kiersten Pierpoint pierpoint_kiersten@svvsd.org 011512 33 2025-09-11 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-09-09 23:13:45 -47.8 hrs 688a588f3b68350808c9cfe4 000014792 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:04 2026-06-11 23:43:02