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
23585 8417efc8bdbb22ee4463946747c2eda9b10eff19f8bf8acea955075115e74302 683765b7aaae2f07a2218664 67ced3e17abf9f3ed8feb4cc Jennifer Kirk Jennifer Kirk jenniferjkirk@comcast.net 007853 24 2025-07-29 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 7/21 Sophia L. 2025-07-21 22:37:23 -191.4 hrs 683765b7aaae2f07a221865f 000007284 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:29:26 2026-06-11 23:56:23
23584 8446663c886abe18e1b2b2b5d77192531e3f4d4bae37ddc4966e73e6e23bfbeb 687975b1d128f707b53dcbb7 685d98616b03f5494319de5e Francis Murphy Francis Murphy bob@bcmurphy.me 017533 4 2025-07-29 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Peter Gagnon 24+ pt conf cxl SL 7/28 Sophia L. 2025-07-28 22:28:10 -23.8 hrs 687975b1d128f707b53dcbb6 000013463 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:29:26 2026-06-11 23:56:23
23583 224f2e33dd370b188c2da2bd2011c0e7e894f74ee0ce0e5ed792a2322f997cc8 68236da6d73355082b76deb8 67ced4d67abf9f3ed8fee3a9 Benjamin Prieb Benjamin Prieb benprieb@gmail.com 011850 123 2025-07-29 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Michelle W. - Maia H. 2025-07-29 22:55:58 0.7 hrs 68236da6d73355082b76deb7 000005357 3.00 78.70 62.70 - - - - - - - - 2026-02-19 23:29:26 2026-06-11 23:56:23
23582 49c5093a249f46c9b115d988ca5a0410f2731d4d428e9760da68458a7118f18c 687f96450f2e1070ee04d14c 687f94fb009310085138df18 Samuel Lauer Samuel Lauer slauer0125@gmail.com 017668 4 2025-07-29 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Patient - - Yes Michelle W. - Maia H. 2025-07-29 22:28:05 -0.0 hrs 687f96450f2e1070ee04d14b 000013738 3.00 85.00 0.00 - - - - - - - - 2026-02-19 23:29:26 2026-06-11 23:56:23
23581 e4ca1922c9a3e278c700aaa713a36a47235eb28639f1ce957bead25704719ce7 686fef67179d30c8c7e2f696 67ced3ef7abf9f3ed8feb7d5 Megan Kram Megan Kram krammegan23@gmail.com 008112 43 2025-07-29 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Pt forgot that she scheduled back to back appts - and left phone at home this AM - sc Sonya C. 2025-07-29 23:05:27 0.6 hrs 686fef67179d30c8c7e2f691 000012457 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:29:26 2026-06-11 23:56:23
23580 87573de282fe4b21698c39017f905377110c550d4acb5d4d9f5370a35a6a28ae 6866f71994554f6ba2046cb6 67ced4587abf9f3ed8fecd4f Taylor Osgood Taylor Osgood tsosgood@gmail.com 009943 118 2025-07-29 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-19 18:41:14 500.2 hrs 68a4c559678a9f0838f89649 000011836 3.00 80.47 80.47 - - - - - - - - 2026-02-19 23:29:26 2026-06-11 23:56:23
23579 9be4cfd7a6a7c60244137e057cbd2c67fcc84d423b29df9295ce1d8ef8956cc1 6838e0a958eaf318441da3d3 67ced30b7abf9f3ed8fe6f7c Allen Chavez Allen Chavez allen.chavez@bvsd.org 001939 101 2025-07-29 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-07-29 22:26:02 -0.1 hrs 6838e0a958eaf318441da3d2 000007540 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:29:26 2026-06-11 23:56:23
23578 cb9e5287877e6eda2878775f4b3f58d41bbff7b5b30169a80ed031f08fb7c8f7 683622762a6dd40784d97402 67ced56d7abf9f3ed8fefb34 Brian Steege Brian Steege bsteege@gmail.com 013858 57 2025-07-29 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - John Phinney 2025-07-29 22:30:33 0.0 hrs 683622762a6dd40784d973fa 000007085 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:29:26 2026-06-11 23:56:23
23577 5bed6f8fad0e8a87bbd1a05caa7a39f018ffc085afa31828d1538b7446a6c8ff 683641d97dfd39d6d48b7307 68363eb7ac3067084a491c22 Katherine Le Bel Katherine Le Bel katehopelebel@gmail.com 017320 66 2025-07-29 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Sophia L. 2025-07-28 18:48:22 -27.9 hrs 683641d97dfd39d6d48b7306 000007146 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:29:26 2026-06-11 23:56:23
23576 86b046e7fea815ea0c9f76a621671a4ff930abab6ca2983fc0d9e688ec0967de 687eab448484e8fcb9f4f2dc 67e666ddefbf2c53d8d60102 Heather Staples Heather Staples staples_heather@svvsd.org 016886 7 2025-07-29 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Sonya C. 2025-07-29 23:03:38 0.1 hrs 687eab448484e8fcb9f4f2db 000013703 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:29:26 2026-06-11 23:56:23
23575 edc3f42b5ca12c9f1252ba9bd5feda1c67ff0352870d061e4d03ee6200004f08 6859c62c7ebc6e3972499b13 67ced3ef7abf9f3ed8feb7d5 Megan Kram Megan Kram krammegan23@gmail.com 008112 43 2025-07-29 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-07 15:35:02 1672.6 hrs 689216dbc6c516084df702c8 000010413 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:29:26 2026-06-11 23:56:23
23574 358aec2aa986e30a76669d2e4366a201f86f04726522c1a033cd4962376c1f89 683f235c58e4460aba300d50 67ced3007abf9f3ed8fe69f4 Neil Anderson Neil Anderson 1973noa@gmail.com 001467 41 2025-07-29 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - James Fowlkes 2025-07-29 23:40:34 0.7 hrs 683f235c58e4460aba300d4f 000007908 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:29:26 2026-06-11 23:56:23
23573 1b1391fdb1d760c69596196734e85f6e1f6e5f51882bfae09a54aa4fa7a9400d 6823934bc88c2d0794de35b2 67ced3247abf9f3ed8fe7a68 Carol Cogswell Carol Cogswell cogswell@colorado.edu 002871 146 2025-07-29 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Sonya C. 2025-09-26 21:02:45 1414.0 hrs 6823934bc88c2d0794de35b1 000005401 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:29:25 2026-06-11 23:56:23
23572 51e74aba5d494a8807a707f4bceb3d632abd8aec8009d10ac18511467dfb20e6 681aa4d6bfd2e977daeabf13 67ced3487abf9f3ed8fe887c Cheryl Edson Cheryl Edson capn.bob65@ptboulder.com 004072 174 2025-07-29 Cancel 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Eva Tucker Jack referred to home PT- sc Sonya C. 2025-07-18 20:40:16 -266.3 hrs 681aa4d6bfd2e977daeabf12 000004578 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:29:25 2026-06-11 23:56:23
23571 acab82bed48d378e36d497b96357cfc377ccb85820ee7e185f4ddd12048510d2 6877ffe570abfbbfdccb3e3f 67ced3c37abf9f3ed8fead61 Leah Kaplan Leah Kaplan leah@leahkaplan.com 007220 55 2025-07-29 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sarah Emrey 2025-07-30 00:16:49 0.8 hrs 6877ffe570abfbbfdccb3e3e 000013233 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:29:25 2026-06-11 23:56:23
23570 20265954b14225947e89ea52ab435593fa9f5a0501d470b63aa9a552effd961f 685eac066b89713deb8bc109 685c0d8e3951e70848198db3 Kimberly Varela Kimberly Varela kimberlys303@yahoo.com 017519 9 2025-07-29 Cancel 683aa08158eaf318442499e4 James Fowlkes 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-07-22 15:15:45 -176.2 hrs 685eac066b89713deb8bc108 000011039 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:29:09 2026-06-11 23:56:23
23569 044516ff4966a822036bd4e8a67f4ddfc6f5e1fed0e3113373df8b6faeecf1f1 683f067058e4460aba2ed0f1 6839bfee4bc12ac92a39b5c9 Donald Blunn Donald Blunn dablunn@yahoo.com 017343 12 2025-07-29 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. Mon 5:36pm Don Blunn apt tomorrow with Sarah - needs to cancel it. His mom passed away last week. Cancel the next three and when he can r/s, he’ll call us back. Ranjini Ridgway 2025-07-15 12:20:04 -347.2 hrs 683f067058e4460aba2ed0f0 000007865 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:29:09 2026-06-11 23:56:23
23568 ea36289384549fc29028ac52e14830deb822afa36dfef3c986bf9049249d614d 68374102147418c90394de70 68373ff77dfd39d6d490641b Laura Appelbaum Laura Appelbaum laurarappelbaum@gmail.com 017326 32 2025-07-29 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Sophia L. 2025-07-30 16:08:05 16.6 hrs 68374102147418c90394de6f 000007238 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:29:09 2026-06-11 23:56:23
23896 371949039b2342998ef3064c8a75900518aab2d52e7f0e3722b6b50f114fafb8 685995eb5e59ef08298f97fa 683894c42f21dae449a884bc Erin Giveans Erin Giveans ekgiveans@gmail.com 017340 37 2025-07-28 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-28 20:30:38 7.5 hrs 685995eb5e59ef08298f97f6 000010331 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:30:16 2026-06-11 23:57:08
23895 aea4fa9d35f988e936eb8003ab74da457e9ea3a76d8ca2fd5c094bb6feb87802 6846f54fbc73b607a712f837 6835d187c27824081ca6323e Jennifer Melius Jennifer Melius jenny.melius@gmail.com 017308 15 2025-07-28 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 7/21 Sophia L. 2025-07-21 19:50:18 -161.2 hrs 6846f54fbc73b607a712f835 000008678 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:16 2026-06-11 23:57:08
23894 c84f9d0d2191f6db766643e41ab97926d54188c9a439b9eb4d734274d506e282 68000f338e2b1c95e8fa6e5e 67ced3117abf9f3ed8fe72dc Evan Christenson Evan Christenson evancolorado@msn.com 002227 56 2025-07-28 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Primary - - Yes Sonya C. - Samantha Saunders 2025-07-28 13:01:51 0.0 hrs 68000f338e2b1c95e8fa6e57 000002503 3.00 237.00 0.00 - - - - - - - - 2026-02-19 23:30:16 2026-06-11 23:57:08
23893 073b2a6b263124806c169c31def940577eda1c506d683f5283672521a7f94d74 688245b9e745fd079e6255f1 67ced56e7abf9f3ed8fefb61 Josi Turner Josi Turner josisingleton@yahoo.com 013873 20 2025-07-28 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Emily Pickner 2025-07-28 13:15:48 0.0 hrs 688245b9e745fd079e6255f0 000014153 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:30:16 2026-06-11 23:57:08
23892 acdb8a0bc40164c868d0d41a54c854f33150cda562d25663b5236b9862a99f4d 687e4d353c0769ca17ff7f2c 687e4bd4566432084bea954a Carolene Younkin Carolene Younkin carolene@comcast.net 017658 10 2025-07-28 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Secondary - - Yes Michelle W. - Sonya C. 2025-07-28 13:53:48 0.4 hrs 687e4d353c0769ca17ff7f2b 000013624 3.00 231.00 0.00 - - - - - - - - 2026-02-19 23:30:16 2026-06-11 23:57:08
23891 b819205095295e68863d13f72f67a6dcc7bf6254d96a9990cce5751bffd88320 687182efe74565084d97913a 67ced5de7abf9f3ed8ff0ab4 Sandy Swegel Sandy Swegel swegel@hotmail.com 015180 63 2025-07-28 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Ranjini Ridgway - Michelle W. 2025-07-24 13:33:17 -95.9 hrs 687182efe74565084d979139 000012733 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:16 2026-06-11 23:57:08
23890 a8d3ebbb720f2533e5ee867f8ba7a81bea70caff33fdc8b171b6314810eaada2 686ecb58c59bf5ed90f17a3d 686bfeb00b871f888e59cf42 Tamsyn Waycott Tamsyn Waycott tamwayco@gmail.com 017578 10 2025-07-28 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Per pt request, cancelling all FU appts - sc Sonya C. 2025-07-18 14:15:17 -239.2 hrs 686ecb58c59bf5ed90f17a3b 000012343 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:16 2026-06-11 23:57:08