General Visit (PT Boulder API)

Total rows: 100,569
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
10031 89bee6da9895f5746fa5b0f7e60df7d397f1a0bfb2765dd449fc6d0263101c25 68efbdc5903d4b1d26adb048 680921d215096f08a29be2ba Emily Masi Emily Masi emasi88@gmail.com 017114 31 2025-11-20 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Jayvee Totanes 2025-11-27 15:24:51 166.9 hrs 68efbdc5903d4b1d26adb047 000023530 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:50:20 2026-05-05 23:16:23
10030 3efe94ebe56412f2b77079e9b42971d0fe3610260c22ed3e439fe0d1805e5439 68deba822accad08e4a32291 68a8156699c65c4a78a6037b Nellie M Parnell Nellie M Parnell robtandnell@comcast.net 019149 51 2025-11-20 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Unpaid - Unidentified - - No Julie Petersen-Hanson surgery 11/13 JPH Julie Petersen-Hanson 2025-11-13 17:17:03 -167.2 hrs 68deba822accad08e4a32290 000022023 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:20 2026-05-05 23:16:23
10029 1db292870669ec57aaedd7931929d61a1e155779b62601032503e5b6a232ca0e 68dbf8fa000ddcc73d0a9482 67ced3097abf9f3ed8fe6e98 Barbara Bradley Barbara Bradley ruebarb1@aol.com 001863 105 2025-11-20 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Sophia L. 2025-11-20 18:26:14 1.9 hrs 68dbf8fa000ddcc73d0a9481 000021609 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:50:20 2026-05-05 23:16:23
10028 076a1764a59786e0586921992f917ff47c123e3d81ff130e04d6ef0ffe2be35f 68af448fed830916f84d8b45 68af438dc4898d0790e48518 Brent Butler Brent Butler butlerbt.mg@gmail.com 019762 18 2025-11-20 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 11/6 Sophia L. 2025-11-06 15:53:12 -336.6 hrs 68af448fed830916f84d8b44 000017834 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:20 2026-05-05 23:16:23
10027 207797b3b5c14cee884e4c07287e364a167c40bb908db8dd533b535298aa2b04 687918cb5a1432089e43a681 67ced56b7abf9f3ed8fefae5 Arshebeth Turka Arshebeth Turka arshebeth@gmail.com 013832 130 2025-11-20 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Jayson Encarnacion 2025-11-24 22:03:44 101.6 hrs 687918cb5a1432089e43a680 000013325 2.00 60.00 60.00 - - - - - - - - 2026-02-19 22:50:20 2026-05-05 23:16:23
10026 1afb6dba2297ee6d683a34da1f581aaf0728344a36ee882223ec39b54d6432da 6818eac5ce5fe80830ef7275 67ced3367abf9f3ed8fe8197 Barbara Dobbs Barbara Dobbs thebarbaradobbs@gmail.com 003484 80 2025-11-20 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 8/25 Sophia L. 2025-08-25 17:57:43 -2086.5 hrs 6818eac5ce5fe80830ef7274 000004269 4.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:20 2026-05-05 23:16:23
10025 68db6b6433ae90a2adcd9d311dc96c3de8237b8b336824c6beff643f0a36711a 69139ce4d567bd83cd64227f 68a5f331cc00ec0894e708c3 Sandra Squires Sandra Squires ssquires2@comcast.net 017835 32 2025-11-20 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Emmie Gebhardt - Amie Russell 2025-11-20 16:55:30 0.2 hrs 69139ce4d567bd83cd64227e 000026851 3.00 81.40 81.40 - - - - - - - - 2026-02-19 22:50:20 2026-05-05 23:16:23
10024 97a9632a60a9e05e483d63b01eee05574b1edff09c89777ee816faac65f892bb 690d121975ccc5b297780b27 68cb0ef8c84d7307914f70a2 Bradley Pospeck Bradley Pospeck bpospeck@gmail.com 019884 11 2025-11-20 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Patient - - Yes Frances Lawrence - Jayvee Totanes 2025-11-27 19:20:53 170.6 hrs 690d121975ccc5b297780b26 000026329 3.00 82.00 81.70 - - - - - - - - 2026-02-19 22:50:20 2026-05-05 23:16:23
10023 23781d28450b479bfb0fe55d682c3e48119795e8f20fa949d06c8627204084f0 68fa62b861fd12670864ef64 68bc8214e8bd5ace48148121 Theodore Torrence Theodore Torrence ttorre22@icloud.com 019813 13 2025-11-20 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - Yes Sara Thompson - Sara Thompson 2025-11-20 16:15:16 -0.5 hrs 68fa62b861fd12670864ef63 000024523 3.00 236.00 0.00 - - - - - - - - 2026-02-19 22:50:20 2026-05-05 23:16:23
10022 f35e6d4c8881dcd1492d7eab29d500d626cd77835c02efc137d6b625eca5eeec 68e80afbea3c36b3b452586e 68a7811372582e634232a60a Lindsay Schneck Lindsay Schneck osteenli@gmail.com 017889 11 2025-11-20 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Sophia L. - Kenneth Dave Francisco 2025-12-02 18:41:21 289.9 hrs 69d553317bad4156b08b4bb6 000022966 3.00 450.00 25.00 - - - - - - - - 2026-02-19 22:50:20 2026-05-05 23:16:23
10021 057933b70ae76e674735f2b2933627711f74eecd3e3cb077012d4aab0a907f91 68e6d6f67f7c600948b16d82 67ced4ce7abf9f3ed8fee253 Andrea Poniers Andrea Poniers andrealeni@earthlink.net 011736 24 2025-11-20 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ sch conflict - sc Sonya C. 2025-11-05 22:49:36 -353.9 hrs 68e6d6f67f7c600948b16d81 000022845 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:20 2026-05-05 23:16:23
10020 a93839df6916b047eac6b7907ddc1ef6ee2bb22c98951aef0747888091ebbb43 68dee7a5ad976d08b3c5e1ee 67ced5177abf9f3ed8feee3c Stephen Roman Stephen Roman sa3roman@gmail.com 012752 48 2025-11-20 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia L. - Sonya C. 2025-11-20 16:58:20 0.2 hrs 68dee7a5ad976d08b3c5e1ed 000022098 4.00 95.34 45.34 - - - - - - - - 2026-02-19 22:50:20 2026-05-05 23:16:23
10019 2c687d63892fcc11408a4d401f667575d347e005327321219115847b4ee133dc 68dd89f944ed1c8009fedc9e 68dd8707b3b61d09d5c699e5 Olivia Stafford Olivia Stafford oliviastafford2006@gmail.com 019973 14 2025-11-20 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed Called at 9:32 - states that she woke up sick - sc Sonya C. 2025-11-20 16:32:58 -0.2 hrs 68dd89f944ed1c8009fedc9d 000021928 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10018 e590f167538aa223a933d37b7ad31c793cf06eeabcc09a8393329fcd1a8f17f2 68d44dc1a5c7e586abe0b1a8 67e1258854aaaa3a80096c18 Monica Palme Monica Palme monicapalme@gmail.com 016720 58 2025-11-20 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sophia L. 2025-11-20 22:11:34 5.4 hrs 68d44dc1a5c7e586abe0b1a4 000020878 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10017 c77f3923bb4d97a28df4cf094870f77e34a80c2a89155644457c2c63d6255196 691b60d7ac0e4cc089b5b92e 68a8154699c65c4a78a5fd70 Claire Lay Claire Lay bokomaru4@gmail.com 018852 4 2025-11-20 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - No Frances Lawrence - Abyssel Gobris 2026-01-05 16:36:47 1103.6 hrs 691b60d7ac0e4cc089b5b92d 000027397 0.00 0.00 80.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10016 db4526efd8b38e159e25ba82db4fcb7474cc0b9c6aeefc2f66c68deb4da29a12 68f926576838920ffbb3d0d6 67ced2ee7abf9f3ed8fe5e5d Caitlin Cottrill Caitlin Cottrill caco6467@colorado.edu 000478 58 2025-11-20 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sonya C. 2025-11-20 16:58:11 -0.0 hrs 692e288b4a5bdb9a75044e6d 000024423 3.00 77.32 77.32 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10015 5b870f4f60aa3ca72bc557b0fd14e9225ac6c54bf125e5ba24769d4ea5020c09 68ee88a8e3fc97c4ab85fd84 68e3ffc08be67162cd35622e Deborah Skelton Deborah Skelton twincranes@msn.com 019998 23 2025-11-20 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Michelle W. - Sonya C. 2025-11-20 16:58:29 -0.0 hrs 68ee88a8e3fc97c4ab85fd83 000023380 3.00 60.06 44.81 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10014 da8649c5014ec53d64cd2875bc23cb2f0a3f5d1048a2cb124a8d1775bdbd91bd 68cc2d0022226920976e1c3b 689f865f86088c9243dfeae8 Hollie Hardman Hollie Hardman holliehardman@gmail.com 017808 26 2025-11-20 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Jayvee Totanes 2025-11-27 16:40:40 167.7 hrs 68cc2d0022226920976e1c38 000020127 4.00 95.58 91.66 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10013 736a32de019a59b354a35728892e5d8a1cfa84d89629f4db9b77dbe594ebb7cd 68c2e298fd23ee70e4ca2f29 67ced35a7abf9f3ed8fe8eb9 Kamala Ghimire Kamala Ghimire kamalaghimire96@gmail.com 004604 137 2025-11-20 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Jayson Encarnacion 2025-11-24 22:09:37 101.2 hrs 68c2e298fd23ee70e4ca2f20 000019497 2.00 158.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10012 de7eb27c8621181f01b26253eeb615726431a969aae46d8e9e0159e548403131 68b9c8a3278903080564a08f 67ced2e87abf9f3ed8fe59e0 Craig Bender Craig Bender cbender17@gmail.com 000095 84 2025-11-20 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Jayvee Totanes 2025-11-27 18:18:02 169.3 hrs 68b9c8a3278903080564a08e 000018695 4.00 95.48 100.48 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10011 6878b8e0beb9ddfcb6d39534cf55474fc88cae022c5d026924f1e9aec8071922 68fbe9a7a2ff3e094e355b8c 67ced3837abf9f3ed8fe9c03 Charlotte Hayworth Charlotte Hayworth ccmh1025@gmail.com 005738 49 2025-11-20 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Emily Pickner 2025-11-20 18:00:26 0.8 hrs 68fbe9a7a2ff3e094e355b87 000024816 3.00 78.70 78.70 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10010 9bb52cf551af97bf25fb4fbe2e1a33aa6dafc6835b87e38833f188be2f326a1e 68d41241b97902e191c6b0e8 685c3896f0873207fda55cbe Crystine Margolis Crystine Margolis margolismom@aol.com 017524 17 2025-11-20 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Sophia L. 2025-11-20 17:10:01 -0.1 hrs 68d41241b97902e191c6b0e7 000020807 3.00 80.26 80.26 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10009 d19c789fff5fe278c023f4cb7c995887763d3d7bfb193f06466ca0d3a1648314 68acac00c6f963579f914084 67ced3177abf9f3ed8fe75ee Susan Brooks Susan Brooks 2sbrooks@gmail.com 002489 39 2025-11-20 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sophia L. - Sophia L. 2025-11-20 22:11:38 4.9 hrs 68acac00c6f963579f914082 000017431 2.00 159.00 0.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10008 c06eb6ae514b19ad2205f71bf4e0c664e192f273f0e40b9054278e9073196cf9 67e67152ceb9f104f028b430 67ced3787abf9f3ed8fe98ca Erika Grant Erika Grant erikagrant834@gmail.com 005463 75 2025-11-20 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Dawn Singleton - Jayvee Totanes 2025-11-27 21:54:44 172.7 hrs 6928c8c928408e411a75c06d 000151597 4.00 82.00 162.00 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23
10007 ceb96b0680e0e0c820f0203df248844673436dbec2e52cb8684c011ef99b3ab8 691e5b9b89035e6724459f16 691cdf5a47bb044fa657ca32 Marion Mallard Marion Mallard mallardmarion@aol.com 020265 23 2025-11-20 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Anne Majewski - Sophia L. 2025-11-20 17:29:32 -0.0 hrs 691e5b9b89035e6724459f15 000027857 3.00 83.09 83.09 - - - - - - - - 2026-02-19 22:50:04 2026-05-05 23:16:23