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
16278 8ab0fdd08137fd4ea3f0a0bfdcf8a6ecd49c5a992059160dffd68c67bd2f9828 68952b53683ad835983acb05 689529ed1d2a819c6a5e57c6 Brittany Enterkin Brittany Enterkin enterkin@google.com 017769 6 2025-09-29 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ OOT- sc Sonya C. 2025-09-11 21:46:45 -431.2 hrs 68952b53683ad835983acb04 000015780 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16277 b271638bb0e0dad975efe33c7e6f9cd2325202992a2b8a5be5e3f04be54f854b 6893d5ce7549556799e8a92e 68363eb7ac3067084a491c22 Katherine Le Bel Katherine Le Bel katehopelebel@gmail.com 017320 66 2025-09-29 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-09-29 20:58:40 -0.0 hrs 6893d5ce7549556799e8a92d 000015660 2.00 73.74 73.74 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16276 e705594cdb5036c80a961b32bd3bc39408c4e7c8002f01846ade1642e5c6b206 688108747a52071948c6dbb4 67ced5857abf9f3ed8fefeaf Deborah Usrey Deborah Usrey dusrey2@msn.com 014155 14 2025-09-29 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-09-30 16:03:24 19.1 hrs 688108747a52071948c6dbaf 000013983 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16275 c76681cc0df9186395f0c20bd7d6c908ce1570894d97f74424149832911f11b4 6877d62f03b3760782913946 67ced42c7abf9f3ed8fec4c2 Deborah Martin Deborah Martin dmartin0811@gmail.com 009214 67 2025-09-29 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-09-29 20:45:23 -0.2 hrs 68dc31bd700fb4f61bc18026 000013192 4.00 101.70 101.70 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16274 5c5fb12db585665b2cd8e07e011d47cbe5ff9a074077b1f1dc2b05fedcf3b050 68b9bf76a6d7956c46f4f4d3 67ced38d7abf9f3ed8fe9f00 Julie Heins Julie Heins itnotpa@comcast.net 005993 68 2025-09-29 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Rosey Reed 2025-09-29 21:18:27 0.1 hrs 68b9bf76a6d7956c46f4f4d2 000018679 3.00 77.56 77.56 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16273 2be2e6de4062aea14bb456d4b219c8e6149b17f17cd3d89b1f8099f4771fef6d 68c47fbffc7646cf06b572f7 68c47e778ddde062ad6a73c8 Jeanne Visvader Jeanne Visvader jpvisvader@gmail.com 019849 22 2025-09-29 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-09-30 16:16:22 18.8 hrs 68c47fbffc7646cf06b572f4 000019725 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16272 7deb0c3636ad5342e6b42b7a0f89689dfc83a23caf15557c28e5900fd3662bd1 68adcfaaf4b3235fa0e87726 685c605620456edf6d427bd3 Walraven Ketellapper Walraven Ketellapper walraven@stillwaterresources.com 017525 17 2025-09-29 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Joella Grace Salazar 2025-10-16 18:58:18 405.5 hrs 68adcfaaf4b3235fa0e87725 000017528 5.00 99.00 104.00 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16271 fb2c5ccf301b57e85c79669daa08b41757f3d81376e472a70e8ae61a2df5a1df 68b7728d40f54d21c351f3b7 67ced4587abf9f3ed8fecd4f Taylor Osgood Taylor Osgood tsosgood@gmail.com 009943 118 2025-09-29 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-09-30 18:31:18 20.8 hrs 68b7728d40f54d21c351f3ab 000018446 4.00 95.65 95.65 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16270 f9d2c8c00c04f90f190ce667df6a22af54835bd8e9501f854031aac413d9352b 68b7551040f54d21c350ece3 67ced4857abf9f3ed8fed5ce Clark Myers Clark Myers myers.clark712@gmail.com 010668 97 2025-09-29 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-29 21:40:18 -0.1 hrs 68b7551040f54d21c350ecd7 000018395 4.00 103.85 103.85 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16269 737ed2095e5caf56c36ae935d3bd281ef90a336a51356c6e76b95df227719f14 68796e39cf7d36a70c8b7559 67ced2f77abf9f3ed8fe647b Patricia Carmichael Patricia Carmichael carmichael_patricia@svvsd.org 001000 32 2025-09-29 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-09-30 16:07:49 18.4 hrs 68796e39cf7d36a70c8b7554 000013455 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16268 bc737ab1a1b4d8ab5d5c6f19f7b2ebc630bbbd02dbefe34c3a248765b727ee68 68adf0f064dc40080748d620 67ced3b27abf9f3ed8fea908 Veronica Johnston Veronica Johnston veronica.johnston@bvsd.org 006849 30 2025-09-29 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sonya C. - Rosey Reed 2025-09-29 22:06:45 0.1 hrs 68adf0f064dc40080748d61f 000017571 2.00 157.00 0.00 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16267 33d1ff370e5e44606ba530712b0e13624609151c87040b67121bfe61246183d8 68a35b5c366f8507f94c0907 67ced57f7abf9f3ed8fefddd Madelyn Simpson Madelyn Simpson mgsimpson@outlook.com 014085 26 2025-09-29 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sophia L. - Sonya C. 2025-09-23 22:02:31 -144.0 hrs 698115209949cd7e25ef8ed5 000016544 4.00 314.00 0.00 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16266 54b7112a069352e550eab671ec099bd267c99ae8c169603404512f3b2acd6eb9 689b77519e759bcd431789e7 67ced4227abf9f3ed8fec2d0 Julie Miller Julie Miller julie.vanhelden@gmail.com 009048 10 2025-09-29 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-22 14:33:03 544.6 hrs 689b77519e759bcd431789e5 000016016 3.00 78.33 78.33 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16265 9626cf0a4046a52f2741adfc630d9215f36148d2c5afa55dc72b7a64b4433745 687a916309d959af944a460b 67ced61c7abf9f3ed8ff12de Debra Topping Debra Topping dbtopping@comcast.net 015876 152 2025-09-29 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-09-29 22:06:41 0.1 hrs 687a916309d959af944a460a 000013553 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16264 771b26e9f38d485b9932a9e74ac040d96aa200a640325af996679a4b557042ca 68d2dd33175f3b10f13a939d 68c84981fcdd9c82695f24b0 Michele Gerra Michele Gerra mike@mikegerra.com 019853 6 2025-09-29 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-22 15:51:01 545.4 hrs 68d2dd33175f3b10f13a939c 000020657 4.00 60.76 60.76 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16263 36c223ba1f93df12e3ed384b9392dceb56a838651006add3176fa4e1bc67076f 68c8a052b824708ae64501b9 6893957feff6e30874fe94cf Sierra Lastine Sierra Lastine lastksierra@gmail.com 017763 6 2025-09-29 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Patient - - Yes Peter Gagnon - Rosey Reed 2025-09-29 22:24:35 -0.1 hrs 68c8a052b824708ae64501b8 000019856 3.00 85.00 0.00 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16262 d6dcd9637ea54bcb2d11c92ca9049c79059d23bcd93841bc7550c31ccf328762 68c1caad5f2984c80cf0fa01 689272e47f3e617ebd4cfbfe Bryce Miller Bryce Miller bryce@hatchboulder.com 017756 7 2025-09-29 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle Osgood Discharged Michelle Osgood 2025-09-17 18:34:24 -291.9 hrs 68c1caad5f2984c80cf0fa00 000019417 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16261 378b9426dceed151be166d8622605a947a04fbac93bf8fa870511c959e74169f 68b9cbce5c1242bc4aa0a20b 67ced36c7abf9f3ed8fe94c5 Jean Goodall Jean Goodall jj.goodall54@gmail.com 005120 16 2025-09-29 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Sonya C. - Jayson Encarnacion 2025-09-30 17:58:11 19.5 hrs 68b9cbce5c1242bc4aa0a20a 000018699 3.00 233.00 10.00 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16260 1896544337ad49cb871608050e00fed1e3d9ab138fb7f1654118fc566295b627 68af331d05575547df2f5c13 68a6220c6f38194b967b3f81 Louise Taylor Louise Taylor adair80302@yahoo.com 017850 42 2025-09-29 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 9/2 Sophia L. 2025-09-02 16:19:29 -654.2 hrs 68af331d05575547df2f5c12 000017781 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16259 c1d1d3496000094266979f0c4528956db3030cf0ce587f009ecd6082415887e0 6888eaf280e08d0885e07142 68373ff77dfd39d6d490641b Laura Appelbaum Laura Appelbaum laurarappelbaum@gmail.com 017326 32 2025-09-29 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Laura Shove 2025-09-29 22:51:09 0.1 hrs 6888eaf280e08d0885e07141 000014570 3.00 78.70 78.70 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16258 c648956ce18d03ff34f8bc331e7ef05945b5b2e587605297f0b95dc2d68192a4 68c34fd139f3ff70addaf607 67ced5997abf9f3ed8ff0170 Wendi Stewart Wendi Stewart stewart.wendi@gmail.com 014390 43 2025-09-29 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-29 22:42:22 -0.3 hrs 68c34fd139f3ff70addaf606 000019617 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16257 e4d044a46efbe7813dce7b6aa7d600aced929da7e655fb05034845b271b33ca6 6876bb1c6fd3104c8004144e 67ced5117abf9f3ed8feed40 Amy Schmidthuber Amy Schmidthuber aschmidty17@comcast.net 012668 133 2025-09-29 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Kenneth Dave Francisco 2025-09-30 19:36:38 20.1 hrs 6876bb1c6fd3104c8004144d 000013083 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:08:27 2026-06-11 23:37:50
16538 45619ac2057337215437957e2027a3d0353e4f8e4cd04a17618559a9dc94db04 68c0ac9da6d1eabe12edc4cd 67ced3017abf9f3ed8fe6ae1 David Cavanaugh-Keyek David Cavanaugh-Keyek david.keyek@gmail.com 001546 60 2025-09-26 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2025-09-29 14:53:12 73.9 hrs 68c0ac9da6d1eabe12edc4cc 000019332 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16537 4a76e8fd02dbbcfeb684a83ebe047e06c4ddb71d74163001d152707b6c2fd166 68a8993378b59aaf6b1e9389 686e9ea42f735407e832c269 Jiayin Wang Jiayin Wang janejiayin16@gmail.com 017597 21 2025-09-26 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - John Reed 2025-09-26 15:25:05 2.4 hrs 697c092779fbdf85b5000548 000017238 3.00 231.00 0.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35
16536 1560b1df4a4b499880c7a3b692cdba6ade6b4ecd5a680eb11027a10f3b4ac5b4 686e80bd49baba9102de18ef 67ced3407abf9f3ed8fe85b8 Kimberly Becker Kimberly Becker kimberly.beckr@gmail.com 003836 55 2025-09-26 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-26 14:07:12 1.1 hrs 686e80bd49baba9102de18ee 000012232 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:09:17 2026-06-11 23:38:35