General Visit (PT Boulder API)

Total rows: 104,043
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
20398 3c505b9c4cf00bf80d079d284392c0efc65e2f60d0ddc166e6ac22e4e87b03bf 685067f103dd08c79cf0cd0a 67ced3807abf9f3ed8fe9b13 John Imig John Imig jackimig@aol.com 005658 79 2025-08-25 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Elizabeth Cousins - Sophia L. 2025-08-25 19:00:34 -0.2 hrs 685067f103dd08c79cf0cd09 000009481 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20397 fe777442ee6d4d14fa11a925ffacd77a2d378487c35a3e5716f8739093d28db6 682607a17d3a27c98a3ca2d9 67ced37e7abf9f3ed8fe9a80 Amelia Greacen Amelia Greacen mollygreacen@womanmedicine.com 005609 100 2025-08-25 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. - Michelle W. 2025-08-25 13:52:15 -5.4 hrs 682607a17d3a27c98a3ca2d8 000005714 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20396 86e23c9643875617b35fa47d7fb02c89b499f0a32e726a5e4e7f627f9e5f22d0 68a818eab625571f00455ce6 68a62edbe41064d554db0fac Yara Sawaged Yara Sawaged yarasawaged@gmail.com 017865 3 2025-08-25 New 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-08-22 07:14:49 -84.1 hrs 68a818eab625571f00455ce5 000161184 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20395 0e804f8a8eb1a712c9f1f19c7576358df807797cc09216ca827d16115f82d467 689ba97cd725f254b2d6ab77 68965fe800ab350851bb1313 Samuel Bercholz Samuel Bercholz ratnasam@mac.com 017772 5 2025-08-25 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Sophia L. 2025-08-25 19:44:27 -0.0 hrs 68acf08fee2c027f4a9d9315 000016058 3.00 77.56 77.56 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20394 a69e0e51c6a1ae3d577df9454ce4feaedc7bfc8e12902e5c06215da395ae9988 68780ec6a60d3bc9dedceb4b 67ced57d7abf9f3ed8fefd7d Brooke Underbrink Brooke Underbrink brooke@brookeandcompany.com 014053 10 2025-08-25 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. - Michelle W. 2025-08-25 21:49:14 2.1 hrs 68780ec6a60d3bc9dedceb4a 000013267 1.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20393 7fa445635db7e4a2f8697917adb0c31e565ea9fe7525756c034218fefb04ea4f 6888d748337f8b083fa8f559 687e75e40d5a13ac227d3ed0 Mary Kay Stewart Mary Kay Stewart mkwstew@gmail.com 017662 7 2025-08-25 Checked Out 68535c6303dd08c79c018795 John Reed 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Secondary - - Yes Michelle W. - Sonya C. 2025-08-25 20:01:19 0.0 hrs 68ae2f9765f152276963e846 000014558 4.00 171.76 136.86 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20392 fc901cdfa837240f56635f915a9ce6441ce866eb99c2594e7d6be209f373af34 687951798f9b7674d24520b6 67e1258854aaaa3a80096c12 Vicki Hergott Vicki Hergott v.hergott57@gmail.com 016718 20 2025-08-25 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a67ab091753108089752a5 RTM READY 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-08-25 13:37:05 -6.4 hrs 687951798f9b7674d24520b5 000013416 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20391 a6acfd4de9873ae3c2e1a1019a56d1f4537f3160001ea38727ee5ba1fb1640ed 6841d3db39bb100829b58799 67ced3d87abf9f3ed8feb2b9 Rebecca Kersey Rebecca Kersey doterrawillow@gmail.com 007676 73 2025-08-25 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-08-11 20:35:14 -335.4 hrs 6841d3db39bb100829b58794 000008448 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20390 4574b35fb08b7ea57a23fa6ee77286f8a603784341a0ab7289621031eb16338f 681bd7eb442ad0c127d9ddf4 67ced4d77abf9f3ed8fee3f1 Gail Promboin Gail Promboin burnboin@msn.com 011874 124 2025-08-25 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sophia L. 2025-08-25 19:46:13 -0.2 hrs 68acefd11df126e4c1d48586 000004724 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20389 127cc7ba8ac9b9c94cf0978e47cfac59036386a7b708b0c629908737a7a31a54 67febac15015520805a2c2e5 67ced47c7abf9f3ed8fed424 Victoria Parks Victoria Parks 23vparks@gmail.com 010526 437 2025-08-25 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. Pt is having trouble walking today- sc Sonya C. 2025-08-25 19:26:56 -0.6 hrs 67febac15015520805a2c2e1 000002350 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20388 f504d736fea4ef77bc70264482907689e86a92c7e3421a8aa0d54f48e1530116 688a9bc65710241c241b5e7e 688a9ae52c6e6b8dcceacf9f Kathleen Jacobs Kathleen Jacobs 4jacobsk@comcast.net 017728 6 2025-08-25 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Sophia L. 2025-08-25 20:17:36 0.0 hrs 688a9bc65710241c241b5e7b 000014893 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20387 fe03ac4f7084e649f866ba73d0d3583f789ebc23b873ef4e1be3b71d129493d8 68a39521d48cbd05b4892f2c 67ced5487abf9f3ed8fef5c2 Sheryl Runnells Sheryl Runnells sheryl.runnells@gmail.com 013394 49 2025-08-25 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sophia L. 2025-08-25 20:31:25 0.0 hrs 68acf0a1ee2c027f4a9d93fe 000016598 4.00 100.00 100.00 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20386 54e49f94ecaf52c188d72b5e1ae4f36f01bcfba0f0e29e5fc3a77c8f450059d9 681923e7ea1e1c59d64abc46 67ced5b07abf9f3ed8ff04b7 Kayla Smith Kayla Smith thekaylajsmith@gmail.com 014669 28 2025-08-25 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-25 23:27:00 3.0 hrs 681923e7ea1e1c59d64abc45 000004332 4.00 95.95 130.95 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20385 51de1958ba84b77f0d9c39b08444cb7b2bc99bc121787c48bd4dec60645a8426 6862f8a822010e077f9df280 67ced6617abf9f3ed8ff1b76 Emily Zora Emily Zora emilysartgrove@gmail.com 016609 147 2025-08-25 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Maia H. Eva gone Eva Tucker 2025-08-18 20:53:27 -167.9 hrs 6862f8a822010e077f9df27f 000011352 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20384 1a0f343163bad75af2764db501b7742c91d1166f11879c41abf81f8a99c47637 6823b95fd73355082b7a1efd 67ced2fc7abf9f3ed8fe67ba Debra Bond Debra Bond dbondo@comcast.net 001277 115 2025-08-25 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Sophia L. 2025-08-25 20:42:03 -0.0 hrs 68acefedc1c820085da1d02c 000005453 3.00 78.70 78.70 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20383 0f9c5b0118339a979fda429c20d8a221c514e470e2f8d9946ab8fdc11e3b4a8b 688baf1001c6150846c493ac 67ced3277abf9f3ed8fe7b70 Jeanne Bucci Jeanne Bucci jeanne@yovo.org 002959 66 2025-08-25 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-24 16:55:41 1435.9 hrs 688baf0f01c6150846c493ab 000014975 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20382 5c5562c29edc2674d7470b46575a91d1fda914deb03118d2d8584fb9acb19938 6880f81a0f811ac02eb71169 67ced4e67abf9f3ed8fee65b Justin Rauchwarg Justin Rauchwarg jlrauschwarg@gmail.com 012080 22 2025-08-25 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-25 21:31:49 0.5 hrs 68ae2fbab48b8b28a47369e7 000013946 3.00 85.00 31.69 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20381 a4129bee237fa9933be7bd226406c554cbbf0d44092ecd990cab5441c8fe42ec 689d03e30a037ce085c1664f 68715c28bd72dd080830c7a6 Carol McCool Carol McCool mccool23@gmail.com 017612 8 2025-08-25 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sophia L. 2025-08-25 21:10:49 -0.1 hrs 68acf0af0d1061117621b4f1 000016217 3.00 66.44 66.44 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20380 c0867790e0500baec844353ef248442a5ed446c78ab4e758736df77d0f5ded9d 6891289276b480bb64feae95 67ced33b7abf9f3ed8fe839b Jeannine Corey Jeannine Corey wrcjac60@gmail.com 003656 22 2025-08-25 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ doing home PT for a couple of weeks due to a fall- sc Sonya C. 2025-08-13 20:00:10 -289.2 hrs 6891289276b480bb64feae93 000015335 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20379 a1d51d05e69f0196226f7ed8813105ccfea3b7c95cf10176328ce46c5ac188ec 688a83c037f5b45dcdd2aec7 67ced2fa7abf9f3ed8fe6667 Richard Bolen Richard Bolen rbolen@centurylink.net 001164 166 2025-08-25 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-08-25 13:35:20 -7.7 hrs 688a83c037f5b45dcdd2aec0 000014852 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20378 7da38438567fed4b99fec456c0b5cc0be24fdd1ee26da92f87ec49ed1f9166b6 68814afa79fac6084443dac8 68814a67d3cdf9088b3e45c1 Jenna Forte Jenna Forte jefo8034@gmail.com 017691 6 2025-08-25 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. 24+ - pt states that her neck is "all better now"- sc Sonya C. 2025-07-31 17:52:42 -603.6 hrs 68814afa79fac6084443dac7 000014112 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:58 2026-06-10 23:48:26
20377 7d190ce7d1d333fa42a8be86e1cd0c0fa30a03a8d46d86e2010836578c133fdd 6819362c12ac5577f7886a12 67ced53c7abf9f3ed8fef3d9 Lauren Sessions Lauren Sessions sessions.lauren@gmail.com 013231 189 2025-08-25 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Michelle W. 2025-08-25 21:35:21 0.1 hrs 6819362c12ac5577f7886a11 000004363 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20376 05d2bb65eedbefebf9a63ef6273e716ed3eb2383b41f4fee035d92a8f459d359 6859770ddf6d2207f97aa361 67ced4f77abf9f3ed8fee916 Brigitte Richard Brigitte Richard brigitterichard@comcast.net 012313 19 2025-08-25 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Michelle W. 2025-08-22 17:29:22 -76.3 hrs 6859770ddf6d2207f97aa360 000010269 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20375 1e5faadc5ef20256ad6e0fa5c294fdf4468b54c19c5def0523e9da529b01e9af 689b76b8ddc26607e2d22c84 67ced4227abf9f3ed8fec2d0 Julie Miller Julie Miller julie.vanhelden@gmail.com 009048 10 2025-08-25 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-26 15:23:26 17.4 hrs 68add182148ed5082c29ad1f 000016010 4.00 307.00 80.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20374 81c410ab349836394952ff51aea9a73d3a2fc095034a40320e7616b139ac7cbf 685db3afbce7ac000f5410e0 67ced3047abf9f3ed8fe6c13 Michael Botwinski Michael Botwinski mikejbot2@gmail.com 001648 33 2025-08-25 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-08-25 14:44:52 -7.3 hrs 685db3afbce7ac000f5410d9 000010999 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26