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
20366 26ebfe722c8c4573b2597ba5878f7182acda134d8057f39037cd00d2508fa0a3 68a487b7564a3ec7538b4329 67e66735efbf2c53d8d60621 Helen Virene Helen Virene chanipaul@proton.me 016899 28 2025-08-26 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Peter Gagnon - Ranjini Ridgway 2025-08-26 15:26:09 1.9 hrs 68a487b7564a3ec7538b4328 000016650 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20365 9a60229983b8032db3da4f8b739eedb6fa004e038da558680965e813d7e085fc 688a2d58700989078b69b52c 67ced3d97abf9f3ed8feb2c5 Robert Hunnes Robert Hunnes bob@hunnes.com 007680 29 2025-08-26 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Marguerite Barth - Michelle W. 2025-08-25 12:58:24 -24.5 hrs 688a2d58700989078b69b52b 000014752 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20364 1f5496b67b8a28a12527a3228312a6a918e94dcf78aa46792dd8840668106d8d 6866a00035dcbc087efdb02f 67ced5af7abf9f3ed8ff0484 Ellen Stothard Ellen Stothard erstothard@gmail.com 014652 28 2025-08-26 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Primary - - Yes Ranjini Ridgway - Sophia L. 2025-08-26 14:40:24 1.2 hrs 68add129c7870c078febdfe5 000011728 5.00 80.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20363 2cc5831b7e07e98d92742ba55e36c37335a3ffb8575f9210a65b647b6da15f4f 6848655257105c0812fa6f71 684862a948ba666f6303f7f1 Summer Nicks Summer Nicks nickssummer@gmail.com 017430 16 2025-08-26 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sonya C. - Anne Majewski 2025-08-26 03:58:49 -9.5 hrs 6848655257105c0812fa6f70 000008870 3.00 234.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20362 d45e7fe10528ebf550ff550a5e21c9b53fa4a4f9a04f858e3e226c1ecea74e37 682f51c28df562d524f558c0 682f4fb6e960150854c84153 Rene Brodeur Rene Brodeur rpbrodeur@gmail.com 017288 9 2025-08-26 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-07-29 17:23:22 -668.1 hrs 682f51c28df562d524f558bf 000006599 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20361 345f8263471786be596d8d9abd126bd4bf8bf0ea92aaea484a21017b42c09004 68a640a792ca5eff7dcfffbf 67ced3797abf9f3ed8fe98f4 William Grant William Grant wkgrant@comcast.net 005477 37 2025-08-26 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. cxl Sophia L. 2025-08-20 21:41:24 -136.1 hrs 68a640a792ca5eff7dcfffbe 000017016 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20360 d2cb8beb2b26e3f764f888f38e4d9b8c5085b223330081238feef4e86273603b 689df48541057e07794d4c52 67ced3d67abf9f3ed8feb244 Joseph Kent Joseph Kent j.mkent@comcast.net 007637 319 2025-08-26 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. - Sophia L. 2025-08-18 18:31:51 -187.2 hrs 689df48541057e07794d4c51 000016255 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20359 349660ad8ca7d07dc58525033f7de0529cd569d4b6e5705bd4956460171bd526 6883b23f1b09f4087c19edc1 6883b17496ddc907fc3d98be Owen Abila Owen Abila abilaowen@gmail.com 017706 6 2025-08-26 No Show 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. - Ranjini Ridgway 2025-08-27 12:20:45 22.6 hrs 6883b23f1b09f4087c19edbc 000014370 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20358 d62a224ff85106a2d1870b789c3802ed4671c6ba619fff3441a72a77bc7d3047 686c06cedf2ca508249d2fff 67ced3897abf9f3ed8fe9df8 Don Frasier Don Frasier dgaf76@gmail.com 005905 25 2025-08-26 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-26 15:16:59 1.5 hrs 686c06cedf2ca508249d2ffe 000011911 4.00 95.00 95.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20357 e61f11641695206f6d2892041f30cbd6f3bd289d451c13de498716fbedff5cbe 685d67a1485088a8edfe5db5 685d66ca138ccaa932608843 Conchetta Robinson Conchetta Robinson chettafifty@gmail.com 017530 6 2025-08-26 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 7/7 Sophia L. 2025-07-07 17:54:07 -1195.8 hrs 685d67a1485088a8edfe5db0 000010893 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20356 aad9a2c9a00ce6b4a4d7f42f8848cead6b1abf1a597f33050ce99d3f1c88c497 68431d28f46d860850439d86 67ced3797abf9f3ed8fe98f4 William Grant William Grant wkgrant@comcast.net 005477 37 2025-08-26 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Michelle W. 2025-08-26 13:44:45 -0.0 hrs 68431d28f46d860850439d82 000008577 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20355 4d7ee6533a24038d69b466d58bd59f2e01ae3e20738fbac1ce1569d587836c06 682e98ab5730c041a33e18f9 67ced3717abf9f3ed8fe967b Sheila Harrington Sheila Harrington harrington.sheila30@gmail.com 005266 123 2025-08-26 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Elizabeth Cousins - Elizabeth Cousins 2025-08-26 16:28:35 2.7 hrs 682e98ab5730c041a33e18f8 000006535 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20354 05aacff35f2ca8e774b233fd0a19d5035dece3e1f08f2c38d464bee71487f510 689b6c41405475aec0182708 68489a57f839a307c1be27be Rita McCurry Rita McCurry mccurryrita@gmail.com 017434 18 2025-08-26 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes John Phinney - Sonya C. 2025-08-26 13:48:11 -0.2 hrs 689b6c41405475aec0182707 000015994 3.00 235.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20353 d721a8f4b46e2bce9b331bdb1455afa81adb7a2faf26b5caef7ed6f745538d67 689b500a66190e078a387687 683a0420c892ac65d5f92e16 Clara Draper Clara Draper clara.draper@gmail.com 017355 13 2025-08-26 No Show 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Peter Gagnon - Ranjini Ridgway 2025-08-26 21:37:34 7.6 hrs 689b500a66190e078a387686 000015978 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20352 6316f2bd0c2e2750471e4aa79321c849ffe7a9882beef7a96859a7d6925cb0e6 68765e443bd4c807fc2a86a9 67ced3d67abf9f3ed8feb244 Joseph Kent Joseph Kent j.mkent@comcast.net 007637 319 2025-08-26 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. - Michelle W. 2025-07-17 14:02:19 -960.0 hrs 68765e443bd4c807fc2a86a8 000012919 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20351 98b1db41881bf4a97378c1fe06bdd3cdbe59d01e0530f1859b2484888c67d75d 68a81922b625571f004569a3 68a626ead47fc4e5fa4505b0 Erin Watson Erin Watson erin.reed.watson@gmail.com 017855 8 2025-08-26 New 6899858814e44ebdae34c0b7 Rayann Greer 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-08-22 07:15:46 -103.0 hrs 68a81922b625571f004569a2 000161240 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20350 1c90460ac6ac65631ae96382c161611a41b6fcebd6b52218e7b639320b15c547 687180a3bd72dd0808318c1e 68717f53bf71e50794b717b6 Alison McGinty Alison McGinty alison.mcginty@gmail.com 017618 12 2025-08-26 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Ranjini Ridgway - Anne Majewski 2025-08-26 03:58:45 -10.3 hrs 68c888fc7459679ef1938cdd 000012729 3.00 233.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20349 9baaf3b27360a35d261330d1c3ce496222aca5d072c9b4a91578092413d633f1 682b3f721844fe70763264de 67ced55d7abf9f3ed8fef8d7 Lorrie Trussell Lorrie Trussell ldtrussell@gmail.com 013657 16 2025-08-26 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-26 15:22:57 1.1 hrs 682b3f721844fe70763264dd 000006038 3.00 85.00 90.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20348 49e7980470c31d84751ba083632235072e6335e08c7bef2b21709f1ca46773cc 68112de06b7c2b08435a1e69 67ced59f7abf9f3ed8ff0257 Stanley Stjernholm Stanley Stjernholm bestjernholm@msn.com 014467 174 2025-08-26 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Michelle W. 2025-08-26 14:11:07 -0.1 hrs 68ae2f11c51a1c2389481d19 000003840 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20347 40b3b994c7f1be027f1b5ef4f6ad087a37c6a0dee95af2f398b515da6ca16f61 6894c00b29793a07c7ada73d 685c605620456edf6d427bd3 Walraven Ketellapper Walraven Ketellapper walraven@stillwaterresources.com 017525 17 2025-08-26 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a67ab091753108089752a5 RTM READY 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Maia H. - Ranjini Ridgway 2025-09-11 18:57:42 388.5 hrs 6894c00b29793a07c7ada73c 000015694 5.00 99.00 104.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20346 981dd0b6f91a2d4db9035f0892f527005d34b4cd429d79fcff3fb31366ec38da 68911c45a2232cbb86830c4d 68911a2f2428ed081aef794f Manuel Garcia Ferrari Manuel Garcia Ferrari garciaferrarim@gmail.com 017748 13 2025-08-26 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Primary - - Yes Sonya C. - Samantha Saunders 2025-08-26 14:31:21 0.0 hrs 68911c45a2232cbb86830c4c 000015302 3.00 230.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20345 ba382c750faf3342056145bc0ab9820a64ad7d1b40b5ad38f0a11b71b3d10b1a 688ce9628622a89a23fd6042 688cd1f121922c08310374f4 Rickey Nobori Rickey Nobori rickeynobori@gmail.com 017737 16 2025-08-26 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-08-26 16:34:16 2.1 hrs 688ce9628622a89a23fd6037 000015112 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20344 0ec445dd9097cb6e1dec705201f0eb44114644e3042d1d215777cc75fa469f9f 686d3df61837b24f7c2d5077 67ced3ea7abf9f3ed8feb6e5 Andrew Kolbeck Andrew Kolbeck kolbeckag@gmail.com 008032 23 2025-08-26 Cancel 683aa08158eaf318442499e4 James Fowlkes 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Maia H. 2025-08-22 17:12:40 -93.3 hrs 686d3df61837b24f7c2d5076 000012025 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20343 e0d43f28dd6961d77f5a6fc99d22db17ac9ad632ce0ed7e9c33b6904d23487eb 685ad9c0aa563d08758a2319 68533e0219295c07de06e63d Mariah Caba Mariah Caba mariahcaba@gmail.com 017474 25 2025-08-26 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Ranjini Ridgway 2025-08-26 15:27:44 1.0 hrs 685ad9c0aa563d08758a2318 000010517 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26
20342 197bc061f2bb7c6f3d3e98d42da890f06d82ef7600bcff36bff5860ad6fd6520 68541ef01fa26d07c88d0f5a 67ced47b7abf9f3ed8fed3f4 Mary McHugh Mary McHugh maryemchugh@gmail.com 010510 31 2025-08-26 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Secondary - - Yes Sonya C. - Ranjini Ridgway 2025-08-26 15:17:25 0.8 hrs 68541ef01fa26d07c88d0f56 000009875 2.00 60.00 60.00 - - - - - - - - 2026-02-19 23:19:57 2026-06-10 23:48:26