General Visit (PT Boulder API)

Total rows: 101,513
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
15463 4cb32fd2ec81afca78a82db09f031f7bcef6658518a9a28adc9ffec76a51217e 68a75a349eb9b3b30db3de93 67ced3bd7abf9f3ed8feabe4 Andrew Juniper Andrew Juniper paul@pauljuniper.com 007093 43 2025-10-06 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a53b646ef07bde7e210 ASH (CIGNA) AUTH NEEDED - GET OUTCOME 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Kenneth Dave Francisco 2025-10-16 19:14:23 239.7 hrs 68a75a349eb9b3b30db3de92 000017107 4.00 95.60 95.60 - - - - - - - - 2026-02-19 23:06:15 2026-05-13 23:31:29
15462 3b61bda0f0f2ada662affdf348cc29759a1616022db1e5451d3ef7124f49fe41 687a973dc69fad078ecf9a69 67ced61c7abf9f3ed8ff12de Debra Topping Debra Topping dbtopping@comcast.net 015876 152 2025-10-06 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Rosey Reed 2025-10-06 19:35:21 0.1 hrs 687a973dc69fad078ecf9a68 000013567 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15461 3e8b136e376608bf02c1de3c6de0b283b40c897ca483219e0ded01544293654a 68dae2759f8f7594d526ec5e 67ced3497abf9f3ed8fe88ac Berta Egan Berta Egan bertae999@gmail.com 004088 90 2025-10-06 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-06 19:38:55 -0.1 hrs 68dae2759f8f7594d526ec5a 000021479 3.00 82.00 62.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15460 377d35289cb276393caff35712f04e2a249e7789407113cc75f281969ea8d105 68d2ec3d1658d8fd07a4bfe6 68ae31c602a116dd897f1858 Lucia Karki Lucia Karki lucia.karki@hotmail.com 019749 13 2025-10-06 Cancel 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Emmie Gebhardt scheduling conflict Frances Lawrence 2025-10-03 18:57:29 -72.8 hrs 68d2ec3d1658d8fd07a4bfe5 000020675 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15459 a71bd52edaa343a680b5648e5b7999b00f05bb6a44427f82c419bcd90fa0b484 68d16bbb5959b720c6822bd0 68d16b5f5959b720c68227de Christopher Johnson Christopher Johnson cjohnson671@gmail.com 019910 34 2025-10-06 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-10-06 19:52:36 0.1 hrs 68d16bbb5959b720c6822bcf 000020397 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15458 d79522d42bd809afeafd54571480faf618b325e02def0f68fba02fca94f42ee0 68b8b87cfc529a47d1ffcfa9 67ced3617abf9f3ed8fe9138 Allie Winner Allie Winner allieferrey@gmail.com 004817 129 2025-10-06 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. pt is sick -mw Michelle W. 2025-10-06 17:24:39 -2.3 hrs 68b8b87cfc529a47d1ffcfa8 000018621 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15457 17fbb09eb1e2bd28655c8f19d3798140796d6b3f45217f872d6b783cffbe42a9 68b08d8b8b43b5ae05ffb816 67ced44f7abf9f3ed8fecbaa Wilma Ormsbee Wilma Ormsbee wormsbee@skybeam.com 009803 9 2025-10-06 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-08-28 17:13:31 -938.5 hrs 68b08d8b8b43b5ae05ffb813 000018028 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15456 2e0792f7ea5627c36a9258288275fc396f5b82efc55a62f091f49bfa619476e7 68b08d8aa4956d7145718dfb 67ced44f7abf9f3ed8fecbaa Wilma Ormsbee Wilma Ormsbee wormsbee@skybeam.com 009803 9 2025-10-06 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Sophia Phillips 2025-09-16 20:21:57 -479.4 hrs 68b08d8aa4956d7145718df8 000018025 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15455 027cf2962b4b175f61c6b1e27c245b65212fc012c3c59de57fc4cf92c2cbd15d 68a794295ecac95c5379cf80 68a79210787a59a3c10467de Tracy Brennan Tracy Brennan tracy.brennan@comcast.net 017899 16 2025-10-06 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia L. - Sophia L. 2025-10-06 19:33:53 -0.2 hrs 68a794295ecac95c5379cf7f 000017171 3.00 70.36 19.36 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15454 57e53d63f9c491274a8be84d876173d430d2b45a3ce946581484462e8c28d564 68cc6ba9ba30944fb16dad66 67ced5917abf9f3ed8ff005c Sally Sandusky Sally Sandusky sally@csico.net 014298 35 2025-10-06 Cancel 67c8f28f945598c08d4245c7 John Phinney 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. 24+ sch conflict w/ pediatrist - sc Sonya C. 2025-10-06 17:18:32 -2.7 hrs 68cc6ba9ba30944fb16dad65 000020189 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15453 8d383a69cd9ab6ab93190479a26bef0263d36e241526c3d3ec8d9e7f2cf5aeb4 68c084ad346696080b20990a 683e2243b8ecd2c9d651a06e Marshall Frech Marshall Frech mfrech@tec.org 017372 43 2025-10-06 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Per VM request - Cigna not paying for appts - sc Sonya C. 2025-10-06 12:42:30 -7.3 hrs 68c084ad346696080b209907 000019249 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15452 fe5a96a76b20dd8aabf6d0471c9110d6aaf5acdd7fd1810bd6664dbd25a2a2fd 68bb27d7842ce706c2fe9a09 689df1c5d4bed0085e0d7339 Kenton Younkin Kenton Younkin kent.younkin@gmail.com 017796 7 2025-10-06 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Michelle W. - Kenneth Dave Francisco 2025-10-10 15:13:19 91.2 hrs 68bb27d7842ce706c2fe9a08 000018940 3.00 85.00 75.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15451 8bd00f8dff7784ef6f2e404b518b11d8964957b036ac5a9974c8dc1a7e6d030e 68adf5fc15d4d207dafade8e 68adf51e15d4d207dafad28b Susan Anderson Susan Anderson andersonsusane@msn.com 019745 6 2025-10-06 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Michelle W. - Sonya C. 2025-10-06 19:58:41 -0.0 hrs 69827960bca44c5d10653ee3 000017584 4.00 314.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15450 311d774bb48cce04db5c23118b7e87e9d5f9449317c12341af6027916fdb11aa 685d6df47d774308254c3614 67ced6167abf9f3ed8ff1218 David Weiss David Weiss davidlinda_weiss@msn.com 015810 71 2025-10-06 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Sonya C. - Rosey Reed 2025-10-06 20:47:39 0.8 hrs 68e6e896d58429eb22dd9036 000010901 4.00 133.86 106.65 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15449 842102025facb1b472cbfaebad3ca97cf929ac18df10d1248013a50f3ec15646 68caf12943dc8a0758c994b9 67ced52e7abf9f3ed8fef1db Andrea Sedlmayr Andrea Sedlmayr andreasedlmayr@gmail.com 013061 92 2025-10-06 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Laura Shove - Laura Shove 2025-10-06 20:58:58 0.7 hrs 68caf12943dc8a0758c994b8 000020029 4.00 104.99 104.99 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15448 9f36d9f68062bc9ec101f9e4835707b4b562df8bb73454277275e022615e0c54 68b83f4f77fc5ebcf6beecd1 67ced34a7abf9f3ed8fe8928 Matthew Elam Matthew Elam matthew.p.elam@gmail.com 004129 24 2025-10-06 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Kenneth Dave Francisco 2025-10-09 15:03:13 66.8 hrs 68b83f4f77fc5ebcf6beecd0 000018463 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15447 7c3affb65bb41e369edac4f31b952816e25eff07685e71791fc006ab926c16cc 688920020f95600f74c84f2b 67ced4ce7abf9f3ed8fee253 Andrea Poniers Andrea Poniers andrealeni@earthlink.net 011736 24 2025-10-06 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 9/12 Sophia L. 2025-09-12 17:14:35 -579.0 hrs 688920020f95600f74c84f27 000014628 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15446 7a54182d94c53b6e340c55e49cbb3f146a525d9b9f2b60874e2ea70681addbf2 68e3df57753b0509a0a0986c 67ced6587abf9f3ed8ff1a62 Tracy Zaik Tracy Zaik tracyzaik@comcast.net 016517 55 2025-10-06 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed Spoke to pt at 1:24pm - PJ sick - RAR 10/6 Rosey Reed 2025-10-06 19:24:52 -1.1 hrs 68e3df57753b0509a0a0986b 000022282 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15445 6269f38137e5e760c3ae50fedf4f394a9e3a56b8cf0e43f6c1e78a7d4141f590 68d441619af4d01890fcf5c0 67ced5d97abf9f3ed8ff0a15 Virginia Wadsworth Virginia Wadsworth vawads@gmail.com 015127 188 2025-10-06 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+, per VM - Pt is in alot of pain and needs to go have Xrays- sc Sonya C. 2025-10-06 12:47:24 -7.7 hrs 68d441619af4d01890fcf5bf 000020866 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15444 b23ce327b8888d1631ecf03d05e5497affd41a9f2e3dae106eb6848868359f56 68c08396f284f5f7cbd76046 67ced5b07abf9f3ed8ff04b7 Kayla Smith Kayla Smith thekaylajsmith@gmail.com 014669 28 2025-10-06 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-10-09 16:41:06 68.2 hrs 68c08396f284f5f7cbd76045 000019230 3.00 80.48 115.48 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15443 68391e7ca1cab98b2156797861458d38734fe709c2631f4cbda89ea80a753596 68bf2ce0171f3f1c911a5ded 67ced40a7abf9f3ed8febdca Nicole LeBoeuf-Little Nicole LeBoeuf-Little ferdinand@littlebull.com 008620 38 2025-10-06 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Peter Gagnon 24+ pt conf cxl SL 10/3 (MD appt) Sophia L. 2025-10-03 15:24:03 -77.1 hrs 68bf2ce0171f3f1c911a5dec 000019076 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15442 0ade577412b34f5a9612b4914cdf0b4e8a2041040a1b6173c24ff7e32dfa6198 68bf21593238690fe639762f 68bf1ece4c373c9c32dc0a2d Benjamin Mcchesney Benjamin Mcchesney kmcchesn@gmail.com 019819 40 2025-10-06 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ schedule conflict - sc Sonya C. 2025-10-02 18:04:00 -98.4 hrs 68bf21593238690fe639762e 000019051 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15441 4fdda2f8e76b1b0ceca8d23a4f945e28a0c862aca443d1681a72c28b4eea6a94 68c8819223a386e1614ae6b9 68c880399ec5d41f375d6e58 Lynn Hildebrand Lynn Hildebrand lynn.hildebrand@colorado.edu 019861 17 2025-10-06 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Rosey Reed - Kenneth Dave Francisco 2025-10-10 14:25:14 89.7 hrs 68c8819223a386e1614ae6b8 000019829 3.00 235.00 20.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15440 04c21a0d76746510e0108a6c8ca1253578c504029927442c82d157784c9b5607 68c87eb3cc327823700d6183 67ced3777abf9f3ed8fe985e Colleen Grande Colleen Grande collgrande@gmail.com 005427 69 2025-10-06 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Kenneth Dave Francisco 2025-10-09 15:05:41 66.3 hrs 68c87eb3cc327823700d6182 000019822 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29
15439 19d78f26811a1854d95a30c88e3c16066647e87f1d2dec833d37e2ff02e88ad0 68b9d2a7fe5f00df0ba7effd 6890cded11a7af0803467727 Judy Hinks Judy Hinks hudy@ptboulder.com 017745 24 2025-10-06 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-06 20:42:52 -0.0 hrs 68f13da0b72986f10f16be90 000018717 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:06:14 2026-05-13 23:31:29