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
24186 a221fa9e2c11d34efe17c2d913f5deeabab7dc723ee4e1e7becb9cb4b0aa4ca6 687eae96942016ca79aecbce 67e6651cefbf2c53d8d5d688 Dorsey Deines Dorsey Deines dorseydeines@yahoo.com 016809 8 2025-07-24 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-24 15:04:13 -0.2 hrs 687eae96942016ca79aecbcd 000013717 3.00 80.00 55.00 - - - - - - - - 2026-02-19 23:31:07 2026-06-11 23:57:53
24185 6cf6e8071cd1ffa97af95a04891446d35d500b997841935cea4c5c6edb871357 6876736e5e37c3086a7ab22f 67e1258754aaaa3a80096beb Matthew Atkins Matthew Atkins matthew.atkins11@gmail.com 016705 42 2025-07-24 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. - Maia H. 2025-07-23 21:00:55 -18.2 hrs 6876736e5e37c3086a7ab22e 000012955 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:07 2026-06-11 23:57:53
24184 842afb07ae2b6ca16a08f88f2231ce6a01463dfec88deb5a87464b9c58835847 68703efb1fec0b6e3dd779d0 68599286ed08c1df3c5041eb Katherine Robertson - Mazur Katherine Robertson - Mazur katie.jay3@gmail.com 017504 43 2025-07-24 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-24 15:22:03 0.1 hrs 688bd57c0b984f07dca014a4 000012577 4.00 88.14 88.14 - - - - - - - - 2026-02-19 23:31:07 2026-06-11 23:57:53
24183 3539cb5cc69fe1b6183a933e56f93e56855e321e2e642b0614f11f68a85b2e14 685c1e66dea722abf0cdddfc 67e1258854aaaa3a80096c03 Nina Nilsen Nina Nilsen ninarae21@gmail.com 016713 47 2025-07-24 Cancel 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-07-10 16:25:41 -334.8 hrs 685c1e66dea722abf0cdddf4 000010713 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:07 2026-06-11 23:57:53
24182 59ef87d433e4a6bff50f0c3b8e51029d3c0fe22dc52f3e3499055299c3b833c3 685312fc212d560822febec2 67ced5227abf9f3ed8fef004 Karen Rosenlof Karen Rosenlof k.h.rosenlof@gmail.com 012904 22 2025-07-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a67ab091753108089752a5 RTM READY 67a2a18d0965a342e59d1264 Boulder Suite 205 Partially Paid - Primary - - Yes Sophia L. - Ranjini Ridgway 2025-07-24 20:13:56 5.0 hrs 6882a0158ab3740e35eb6f0b 000009795 4.00 160.00 95.00 - - - - - - - - 2026-02-19 23:31:07 2026-06-11 23:57:53
24181 188cdc5a4aa23b81ce51d7cfde62edb4e2132079c3dcefe5444e753cbae925d3 683dd17f6624df07b58d528f 67ced2f37abf9f3ed8fe61de Robert Craven Robert Craven robertjamescraven@gmail.com 000777 13 2025-07-24 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt does not need this appt Elizabeth Cousins 2025-07-08 14:23:18 -384.9 hrs 683dd17f6624df07b58d528e 000007749 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:07 2026-06-11 23:57:53
24180 193ac000f1fcdf0f79cb6e789af7033bb40dd406637e0242bab24b9d93c13cee 6838954f703dd308051ebc34 67ced3007abf9f3ed8fe69f7 Kelly Borden Kelly Borden bordenkelly460@gmail.com 001468 23 2025-07-24 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 6/20 Sophia L. 2025-06-20 15:28:43 -815.8 hrs 6838954f703dd308051ebc33 000007459 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:06 2026-06-11 23:57:53
24179 1c76e78e31c0b5de44cd9d99f35fc9eb187e06437fe4037b34be94bacdcc6da9 67e6721bceb9f104f028ea4e 67ced5cf7abf9f3ed8ff08ce Julie Volckens Julie Volckens volckens@gmail.com 015018 94 2025-07-24 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Dawn Singleton - Julie Volckens 2025-08-24 13:21:18 742.1 hrs 67e6721bceb9f104f028ea4d 000151911 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:31:06 2026-06-11 23:57:53
24178 3775be9a5a984d1430267baaaf1d67cbbc79fd793cd6f10949f1a487cf5fe5a0 685c1087131e7a089b07c949 6852d1395100c738c77ba4f5 Ashlar Byleckie Ashlar Byleckie ashlarb26@gmail.com 017468 8 2025-07-24 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-07-28 22:03:58 102.6 hrs 685c1087131e7a089b07c948 000010665 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:31:06 2026-06-11 23:57:53
24177 b8fbaf5b249f659f74c5dbd2ed829740e9deba2afda87f784de41f098ba513e3 6849b0f2c8a53a0775d944dc 67ced6267abf9f3ed8ff1434 Mary White Mary White bolles1@comcast.net 015990 50 2025-07-24 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-07-24 15:33:59 0.1 hrs 6849b0f2c8a53a0775d944db 000009002 3.00 59.50 59.50 - - - - - - - - 2026-02-19 23:31:06 2026-06-11 23:57:53
24176 79141ddec0a3d8ba32270b2d47acaa9fbda5f3b9d164797451d1df25329ab66e 683f0f7541546d0bc965e322 67ced4567abf9f3ed8feccf5 Margarita Delopez Margarita Delopez xelajuj@icloud.com 009913 124 2025-07-24 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-24 15:24:56 -0.1 hrs 683f0f7541546d0bc965e31c 000007875 3.00 80.00 85.00 - - - - - - - - 2026-02-19 23:31:06 2026-06-11 23:57:53
24175 f6a50b8a6081da318abea23ececaff1af424d5362e076b0a75d33c5bf092529d 67e67219ceb9f104f028e9ea 67ced3367abf9f3ed8fe8197 Barbara Dobbs Barbara Dobbs thebarbaradobbs@gmail.com 003484 80 2025-07-24 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Dawn Singleton - Ranjini Ridgway 2025-07-24 20:38:11 5.1 hrs 67e67219ceb9f104f028e9e9 000151908 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:31:06 2026-06-11 23:57:53
24174 1d86c6de20ac2fe97c3dd146a579b9b193cd413021f673bb50cb7f2185c3ad7c 68755bffa21295081fe6aed7 68712823a3242f8892b11b4b Patricia Kercher Patricia Kercher patty.kercher@yahoo.com 017607 11 2025-07-24 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-07-24 21:00:59 5.3 hrs 68755bffa21295081fe6aed6 000012839 3.00 80.00 90.00 - - - - - - - - 2026-02-19 23:31:06 2026-06-11 23:57:53
24173 4951da1b347bbfff341256dffc68cfdd9774d2155ef0fc32a6c20d44d80689a5 6866eddd09f80a08356273d0 67ced3327abf9f3ed8fe8029 Jennifer Dingman Jennifer Dingman devding@msn.com 003362 37 2025-07-24 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-09-11 19:34:41 1179.8 hrs 6866eddd09f80a08356273cf 000011823 5.00 95.00 95.00 - - - - - - - - 2026-02-19 23:31:06 2026-06-11 23:57:53
24172 e9528386dab439a83928021c91e59daf4ba150540a0e3b6dc2d0d5eea6e04e69 684b3f7cc96d4e0773bf091d 67ced2e97abf9f3ed8fe5a7f Susan Benson Susan Benson susan.benson52@yahoo.com 000148 116 2025-07-24 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-24 15:42:55 -0.0 hrs 684b3f7cc96d4e0773bf0915 000009203 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:31:06 2026-06-11 23:57:53
24171 8ad93702e079b2c7b9f982774fbc2d24865e7a3231011b3517b9a7f1c0b18850 683dc74511ecaaca3a21aaa8 683dc62ca4171a087459e080 Carol Burke Carol Burke carolb5099@gmail.com 017362 7 2025-07-24 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Gillian B. - Michelle W. 2025-07-24 13:18:14 -2.4 hrs 683dc74511ecaaca3a21aaa7 000007730 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:31:06 2026-06-11 23:57:53
24170 5f4c17c5b85d5a60855afd6930bd597054b62d8b5e7f8faa4943a38d47b0e04d 6838c2424476b407db1eaedd 67ced3b77abf9f3ed8feaa37 Melissa Jones Melissa Jones meljones324@gmail.com 006950 26 2025-07-24 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Gillian B. 24+ -will call to rxl after see other med prof first- sc Sonya C. 2025-07-21 14:33:36 -73.2 hrs 6838c2424476b407db1eaedc 000007502 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:53
24169 c9ee34f23a2bb9f15f3382df0d4b6e109cd8b1f7a586d40f3db0aa03bded3ad3 682cd7d6968e5c086d7b037c 67e66771efbf2c53d8d6097d David Wolfe David Wolfe davidnjewelwolfe@hotmail.com 016906 13 2025-07-24 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-07-24 16:20:32 0.6 hrs 688a8aaccbf35108987fb654 000006270 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:53
24168 35ca60d15a96ffa2e4727d0dd8d7889e5232a164eafcfd22afb8b57aff41ba5d 687163cc51b98607c3488b0d 686e8d28eb8422089b95f828 Hugh Pixler Hugh Pixler hugh@pixlerlaw.com 017594 5 2025-07-24 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Maia H. 2025-07-24 15:58:12 -0.0 hrs 687163cc51b98607c3488b0c 000012685 2.00 58.75 58.75 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:53
24167 78ff1bdd735db6f995cefea434844f81c009046785835705003264e2c9f872f1 684c8cff7f968c69509f95a3 684c8c4f070e2c50eb26f2e4 Rachel Gehr Rachel Gehr rachelfpgehr@gmail.com 017447 6 2025-07-24 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Ranjini Ridgway 2025-08-19 19:20:00 627.3 hrs 684c8cff7f968c69509f95a2 000009335 4.00 95.70 165.70 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:53
24166 a6cd3636a289e26242b92b1ecdafd9e8392d9a4b283d460eff653c962693e769 683742fbd4657507f0ed050c 67ced6217abf9f3ed8ff1380 David West David West lionfish@ionsky.com 015930 88 2025-07-24 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Gillian B. - Allison Reyes 2025-07-08 16:52:36 -383.1 hrs 683742fbd4657507f0ed050b 000007244 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:53
24165 42c91cdc76ddda50429c9ff23b7f0a5255eecd4c0a7e4da8ad6c3068bbb7ca85 682749521722d207ab712398 682747e77e4dce07d584ea87 Robert Shapiro Robert Shapiro robertlshapiro@gmail.com 017252 26 2025-07-24 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Maia H. duplicate with Emily Emily Pickner 2025-06-12 13:05:44 -1010.9 hrs 682749521722d207ab712397 000005918 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:53
24164 c9dd1f5dd936210e09729efb63b4f995a6fdddbeeed43e12840b48c2394b44d5 68091cb9b8bca29092098d99 67ced2e87abf9f3ed8fe59e0 Craig Bender Craig Bender cbender17@gmail.com 000095 84 2025-07-24 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sophia L. 24+ pt is ill- sc Sonya C. 2025-07-22 21:46:19 -42.2 hrs 68091cb9b8bca29092098d98 000003241 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:53
24163 f8faab5f0f8f876e50c984fda498a962577ae9505d05b9f99cda39ae3d5f2a46 67ef40f09c1558118e961004 67ced35a7abf9f3ed8fe8eb9 Kamala Ghimire Kamala Ghimire kamalaghimire96@gmail.com 004604 137 2025-07-24 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-07-24 19:44:27 3.7 hrs 67ef40f09c1558118e960ff6 000001123 2.00 80.00 80.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:53
24162 4de8d7092dde612ca30fd9166259eabc198a122703c6ecc066e68bee39fd01ff 68766de6603c4c087fb22b60 67ced5e57abf9f3ed8ff0bad Allen Taggart Allen Taggart ataggart22@gmail.com 015263 16 2025-07-24 No Show 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Peter Gagnon - Ranjini Ridgway 2025-07-24 16:25:04 0.2 hrs 68766de6603c4c087fb22b5f 000012942 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:30:50 2026-06-11 23:57:53