General Visit (PT Boulder API)

Total rows: 101,693
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
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-05-14 23:39:56
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-05-14 23:39:56
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-05-14 23:39:56
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-05-14 23:39:56
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-05-14 23:39:56
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-05-14 23:39:56
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-05-14 23:39:56
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-05-14 23:39:56
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-05-14 23:39:56
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-05-14 23:39:56
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-05-14 23:39:56
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-05-14 23:39:56
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-05-14 23:39:56
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-05-14 23:39:56
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-05-14 23:39:56
18266 ae2854c39379a4c0dac135809978dd80b3b75dd848f2ad1c7e444210101d5781 685d5ede37e26aa9e5fa868b 67ced3a77abf9f3ed8fea5e1 Judith Hersh Judith Hersh judyhersh@msn.com 006580 93 2025-09-11 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Laura Shove 2025-09-11 23:32:50 0.3 hrs 685d5ede37e26aa9e5fa868a 000010881 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:14:04 2026-05-14 23:39:56
18265 0823fafc04d1ffcad8a886a81a3051998f7a9073d0a6af3feb5ba3fee0333a64 685acb0f5f0a5d130b29f63f 685ac9ef81553907e81f9307 Tracy Bugielski Tracy Bugielski tbugielski@gmail.com 017510 6 2025-09-11 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-08-28 13:03:20 -346.2 hrs 685acb0f5f0a5d130b29f63a 000010489 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:04 2026-05-14 23:39:56
18264 a66b3d92a04f5bbc1ef7ce04165fdde48cade5da4bf1f1793604572e4020d409 688cde6e39a8adfff6ed1c9e 67ced32f7abf9f3ed8fe7eee Alexandra Baris Alexandra Baris barisalex70@gmail.com 003257 221 2025-09-11 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Laura Shove 24+ pt conf cxl SL 9/9 Sophia L. 2025-09-09 19:22:09 -52.4 hrs 688cde6e39a8adfff6ed1c9d 000015091 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:14:04 2026-05-14 23:39:56
18618 39ffba41ae10fccdbd2f2ff5caa54c1e2fb3d9dced26a37a4420c8a390916993 68a5d588e1b3ce21f993baee 6862e20c8612670816f07eb2 Radu Popescu Radu Popescu radasca@gmail.com 017545 14 2025-09-10 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-10 13:30:51 0.5 hrs 68a5d588e1b3ce21f993bae9 000016836 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:14:55 2026-05-14 23:40:57
18617 3c449ae297da630ae027494e7c566211f3614fc0c5a4099b26b6248eb0719097 6871407e61f6d85fa36900ad 67ced30d7abf9f3ed8fe70d2 Loretta Cheng Loretta Cheng lcheng2828@yahoo.com 002053 39 2025-09-10 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Sophia L. - Stephanie Braun 2025-09-10 13:09:19 0.2 hrs 6871407e61f6d85fa36900ac 000012635 3.00 235.00 0.00 - - - - - - - - 2026-02-19 23:14:55 2026-05-14 23:40:57
18616 13074ed6f44f33b82f1a2b6dcc9d232d30b61d9b11cf68a3aa68c953a4209812 68a879d151edfe07c81fa802 68a878f1dbb256308f3d0560 Mercedes Giveans Mercedes Giveans Mercedes@ptboulder.com 019724 8 2025-09-10 Checked Out 68535c6303dd08c79c018795 John Reed 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-10 13:30:55 0.0 hrs 68a879d151edfe07c81fa801 000017191 5.00 100.00 100.00 - - - - - - - - 2026-02-19 23:14:55 2026-05-14 23:40:57
18615 341a1494f6ecf4264bb56a055428bc97af60eaebc137473e43427046aa071925 689bb6931a0dcf08933cb1ba 681e1b25ac9489866a5745fb Inge Mcclory Inge Mcclory irmcclory62@msn.com 017211 16 2025-09-10 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-16 15:56:14 866.4 hrs 69c48279d6c3b13c156a6168 000016072 5.00 390.00 55.00 - - - - - - - - 2026-02-19 23:14:55 2026-05-14 23:40:57
18614 ea23f8bd4541ffab143c740362edb15aa98ce53756152f3fe2591742811dff30 689a3f84c37723bb4abbb007 67ced5a77abf9f3ed8ff0368 Michelle Stoll Michelle Stoll michelle.stoll@gmail.com 014558 66 2025-09-10 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-21 21:30:32 992.0 hrs 689a3f84c37723bb4abbb006 000015960 2.00 85.00 93.50 - - - - - - - - 2026-02-19 23:14:55 2026-05-14 23:40:57
18613 931a0a20875d38a6fad3faca8673a9046127697f88966962f4f8460ae7e72467 689372ef77e87307dfc7abb4 67ced5b67abf9f3ed8ff0586 Robin Smith Robin Smith robins@gmx.us 014738 21 2025-09-10 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Anne Palma 2025-09-12 15:02:12 49.5 hrs 689372ef77e87307dfc7abb3 000015484 4.00 95.95 120.95 - - - - - - - - 2026-02-19 23:14:55 2026-05-14 23:40:57
18612 4b856ea4fd0f1f3c6be4e9f8551e135be6eae6f71e4468884b48dae363fe4fd3 688d1000d75f05b79ef9cacd 67ced3ee7abf9f3ed8feb7ab Nadiia Kovalenko Nadiia Kovalenko n_kovalenko@aol.co.uk 008098 14 2025-09-10 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-22 18:41:34 1013.2 hrs 688d1000d75f05b79ef9cacc 000015141 3.00 80.00 160.00 - - - - - - - - 2026-02-19 23:14:55 2026-05-14 23:40:57