General Visit (PT Boulder API)

Total rows: 100,569
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
9797 444014112547d5337148bf6665583cec3a1c6a82ec9529a5eb168f97655a61b9 68810d88b430e30821f61298 67ced5497abf9f3ed8fef5ef SuAnne Shayer SuAnne Shayer suanne15@yahoo.com 013409 106 2025-11-21 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ pt conf cxl SL 11/5 Sophia L. 2025-11-05 16:25:32 -384.8 hrs 68810d88b430e30821f6128e 000014009 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-05 23:15:55
9796 55f52087cf9b9079b51e13c8a6793241bb40f3a32508ad9e74a73283c43ac7b2 68542cfbc62ea107a3431c4c 67ced5287abf9f3ed8fef0ee Kelly Scott Kelly Scott kellygirlscott@gmail.com 012982 241 2025-11-21 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. 24+ pt conf - RAR 9/26 Rosey Reed 2025-09-26 17:35:43 -1343.7 hrs 68542cfbc62ea107a3431c46 000009901 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-05 23:15:55
9795 a704fdd7c6bb8f2b45b6935372d6a20a3ab03a779301cd756e4f16a263e14968 691b8ad6e200dc264c4b35f9 68a77dca461a24a1eb77cc10 Nancy Schlatter Nancy Schlatter mima88@icloud.com 017888 4 2025-11-21 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed Patient is not able to go up 3 flights of stairs, elevator not working in Boulder Elizabeth Cousins 2025-11-21 16:48:58 -0.7 hrs 691b8ad6e200dc264c4b35f8 000027466 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-05 23:15:55
9794 2e475997c453cb68a6ff1c99d535b90bba5302098263aa9151ee6cf53d786255 68eff07032f3a94e246e2ca8 68efef267bd5c400e3c64625 Judith Teisl Judith Teisl jateisl@gmail.com 020075 7 2025-11-21 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sophia L. - Sonya C. 2025-11-21 17:32:20 0.0 hrs 68eff07032f3a94e246e2ca7 000023628 3.00 81.40 74.53 - - - - - - - - 2026-02-19 22:49:31 2026-05-05 23:15:55
9793 7536fa1dea289db8a108862ad31d5f20016b4695be5ea24dee44be444d245f62 68daa39f8c30dfa2f9d9395d 68d5987de4b79f09d2a8f2d2 Sukru Ergin Sukru Ergin erginsukru@gmail.com 019933 24 2025-11-21 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Julie Petersen-Hanson 2025-11-21 22:08:17 4.6 hrs 68daa39f8c30dfa2f9d93958 000021305 3.00 94.40 94.40 - - - - - - - - 2026-02-19 22:49:31 2026-05-05 23:15:55
9792 09a1e9e54e7b1f41d66350634ed1ec50a3c4c8345df6c7a4fb70c3081d149ddb 68ac98650abdd8703de72e1d 680138c171b531fb47910f0b Ruth Sachnoff Ruth Sachnoff rrsachnoff@gmail.com 017076 23 2025-11-21 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Elizabeth Cousins 24+ trying acupuncture, will call back if she wants to book more appts - RAR 11/14 Rosey Reed 2025-11-14 20:53:58 -164.6 hrs 68ac98650abdd8703de72e1c 000017401 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-05 23:15:55
9791 a6443a5e7b938eb989ce902f454f0412981c0fe76ca410c0fc418b9304537467 690a83eb62fca9470895ac80 690a82d0c0603e710dd9382e Tina Legler Tina Legler tclegler@gmail.com 020201 6 2025-11-21 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-11-25 18:23:24 96.6 hrs 690a83eb62fca9470895ac7f 000026062 3.00 85.00 8.50 - - - - - - - - 2026-02-19 22:49:31 2026-05-05 23:15:55
9790 28b57cee822562b668db5207aab29bff60907593e5d1cc5205c3cdfccda9fef5 69092fa409b030d222350598 67ced3c57abf9f3ed8feaddc Roberta Holsclaw Roberta Holsclaw hrpparadine@gmail.com 007261 24 2025-11-21 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. Sophia out sick - sc Sonya C. 2025-11-21 15:18:02 -2.4 hrs 69092fa409b030d222350597 000025830 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-05 23:15:55
9789 3078f20aabb2e80c7b3cdc01f96902ec88be613b9ef1566869da964fe1ac6702 68e3e98c082e160a3666800f 687e6628566432084beb732f Patricia Pederson Patricia Pederson rpederson@comcast.net 017660 32 2025-11-21 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Sophia L. 2025-11-21 17:59:40 0.2 hrs 68e3e98c082e160a3666800e 000022322 3.00 83.09 83.09 - - - - - - - - 2026-02-19 22:49:31 2026-05-05 23:15:55
9788 aa1fefa3b9b11463a51d946d81a504d4cd9ecf3b889168f80a0ac301bfcdb53c 68d6c0211ae1fbc5e8da6a47 67ced4257abf9f3ed8fec363 Maryann Miller Maryann Miller ms.schultz@comcast.net 009097 104 2025-11-21 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Stephanie Braun 2025-11-21 17:38:33 -0.1 hrs 68d6c0211ae1fbc5e8da6a46 000021218 3.00 81.40 81.40 - - - - - - - - 2026-02-19 22:49:31 2026-05-05 23:15:55
9787 8c975f6854502caceb85056d3a8bd906a19c21df2a0ae0488ca341e287ec8632 68d1d67c1fb9ee4374c77002 67ced2eb7abf9f3ed8fe5c4d Kimberly Bertele Kimberly Bertele kkshore@msn.com 000302 15 2025-11-21 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 11/4 Sophia L. 2025-11-04 23:30:28 -402.2 hrs 68d1d67c1fb9ee4374c76ffd 000020566 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-05 23:15:55
9786 6330986ef4c5035039cb218225054de335ec1b018d94d7cf35fb478c1fb2e591 68efd0df9c4ebe0050a2031c 6851a78603dd08c79cf7942c Alexandra King Alexandra King alexandrawaterman@gmail.com 017463 37 2025-11-21 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Sophia L. 2025-11-21 17:59:05 -0.0 hrs 6945aff1302e398fb49f5932 000023576 4.00 95.71 95.71 - - - - - - - - 2026-02-19 22:49:31 2026-05-05 23:15:55
9785 6d667da288a0cbe97fcd01fae6267ba062cbed3e6045f8de042069c8fcfccee9 68e94506c5d8612b978ab172 68a390322dac430785c21ed1 Serena Randolph Serena Randolph serena.randolph@gmail.com 017817 16 2025-11-21 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. pt conf cxl SL 11/21 Sophia L. 2025-11-21 16:27:46 -1.5 hrs 68e94506c5d8612b978ab171 000023072 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-05 23:15:55
9784 a650d1d6a450d37d8869c31acf312dc8bbe71612e858bb5df220b609d81eec77 68dff06ce742cb08fd1a93d8 68dfef9bd6b3d008b62ba1ff Samuel Hynds Samuel Hynds shynds765@gmail.com 019985 8 2025-11-21 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-11-25 16:57:12 95.0 hrs 68dff06ce742cb08fd1a93d7 000022169 4.00 95.00 95.00 - - - - - - - - 2026-02-19 22:49:30 2026-05-05 23:15:55
9783 cc011c971074225fd7b5106455df075a671750b4c63973b9aad6efbffeb7c94b 68c0789c73d5088da968c259 68c077def1afc1f68ec1e0e1 Colman Kahn Colman Kahn nanakahn@gmail.com 019825 18 2025-11-21 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-11-25 16:29:14 94.5 hrs 68c0789c73d5088da968c258 000019214 3.00 60.00 60.00 - - - - - - - - 2026-02-19 22:49:30 2026-05-05 23:15:55
9782 94224bfb83e209233967fd8a2915fb1fefb0738d15f19393c1a291e0c65fd6d6 6893c390dc7aae36c5440b8e 67ced3487abf9f3ed8fe8867 Lois Edgar Lois Edgar edgar@colorado.edu 004065 236 2025-11-21 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Maia H. - Sophia L. 2025-11-21 18:45:16 0.8 hrs 69499dde253635771b14f523 000015604 3.00 80.65 64.26 - - - - - - - - 2026-02-19 22:49:30 2026-05-05 23:15:55
9781 2c3a31f847361089d1f9ad94c2f4a5e3e6be5deb934dfdc701c3f670fdf2f09d 6883e4bda0cefb0785e143d4 67ced4087abf9f3ed8febd70 Julianne Le Sueur Julianne Le Sueur jlengton@gmail.com 008590 21 2025-11-21 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-11-25 17:57:44 96.0 hrs 6925ff04aeb33f821a33af8d 000014413 4.00 82.00 107.00 - - - - - - - - 2026-02-19 22:49:30 2026-05-05 23:15:55
9780 24a2c5e1f29955a84ac586ae432a328af13c3a6701bc2daba52e1fe59e59cbb5 68e947f2bef9979f33fd9c87 68cc5bde765d230582e6f788 Jeana Brammer Jeana Brammer jeana.brammer@gmail.com 019891 11 2025-11-21 Checked Out 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-11-25 17:54:34 95.7 hrs 68e947f2bef9979f33fd9c85 000023080 4.00 95.41 150.41 - - - - - - - - 2026-02-19 22:49:30 2026-05-05 23:15:55
9779 8aaeecaa1764743f30c7a57603688fcdb23f18d13f479d2d54082efd79c9d1b1 6893aff7a7759e927ec7cf93 67ced5c67abf9f3ed8ff07a8 Sue Sobeck Sue Sobeck ssobeck123@aol.com 014920 75 2025-11-21 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-21 19:28:40 1.2 hrs 6893aff7a7759e927ec7cf8a 000015542 3.00 83.09 83.09 - - - - - - - - 2026-02-19 22:49:30 2026-05-05 23:15:55
9778 96ec346c7a510a38eb9c0fe146323aeb81f1e381fbd401cfc9d01a2d04ca409a 6920a0d2057643af29e3b0b7 68c1a0a5c5af856c39363fe6 Amanda Kremer Amanda Kremer amanda.kremer@protonmail.com 019830 9 2025-11-21 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-12-03 18:58:13 288.5 hrs 6920a0d2057643af29e3b0b6 000028042 3.00 82.00 80.00 - - - - - - - - 2026-02-19 22:49:30 2026-05-05 23:15:55
9777 9014bdb9662d5139b3f75bf07e5f09c154b88ad9f069ce118b514731f66e3a1e 691babdfc1a149f1b91619a2 67ced3f67abf9f3ed8feb968 Sherri Laber Sherri Laber sherri.laber@yahoo.com 008246 27 2025-11-21 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Secondary - - Yes Sonya C. - Sophia L. 2025-11-21 18:34:04 0.1 hrs 691babdfc1a149f1b91619a1 000027529 2.00 -40.00 59.50 - - - - - - - - 2026-02-19 22:49:30 2026-05-05 23:15:55
9776 ab455cda2ca201a09a4d829f5bc0a90ffc0e38fe78a55dc7a2b8fe1237d9b6fa 68fa49be97f70409af3d8c36 67ced64f7abf9f3ed8ff1945 Kao Xiong Kao Xiong kao_xiong38@yahoo.com 016422 9 2025-11-21 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ scheduling conflict -mw Michelle W. 2025-11-19 16:44:58 -49.8 hrs 68fa49be97f70409af3d8c35 000024469 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:30 2026-05-05 23:15:55
9775 f482256488c20c98b782244e1b088d158a0ba3a74f9bb022300b42d5dcc3cb9f 68e013860621200921f7f51d 68bb0ea1e8c97c07fdcbf408 Kimberly Hill Kimberly Hill kimberkyhill124@gmail.com 019803 9 2025-11-21 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Patient - - Yes Stephanie Braun - Stephanie Braun 2025-11-21 18:33:54 0.1 hrs 68e013860621200921f7f51c 000022208 3.00 85.00 0.00 - - - - - - - - 2026-02-19 22:49:30 2026-05-05 23:15:55
9774 544b62b0186ab597540ed0d25224d577414c901163c16a0f9e0b8acc84b989a3 68ded115089076f3107d987a 68decfefcfe5a39805d5d392 Jill Matthews Jill Matthews jill.peanasky@gmail.com 019978 11 2025-11-21 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. Sophia out sick - sc Sonya C. 2025-11-21 14:56:10 -3.6 hrs 68ded115089076f3107d9879 000022069 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:30 2026-05-05 23:15:55
9773 21dbd0393c2c7a8b074ada996c0850e8021b6da2307cd15b4df771fef5662b4d 68d6b999ad82baf28866bd3a 67ced5667abf9f3ed8fefa40 Juliana Statius Muller Juliana Statius Muller j.statius@gmail.com 013777 71 2025-11-21 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ scheduled with Emily instead - 11/14 RAR Rosey Reed 2025-11-14 19:04:24 -167.4 hrs 68d6b999ad82baf28866bd39 000021192 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:30 2026-05-05 23:15:55