General Visit (PT Boulder API)

Total rows: 100,380
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
9808 8d2c45b8cabef78a35daf7b46243a37505a1d2d615763229d46d336a25a3aa08 68d4553cf85a8109e6d9dfc9 68d452ede8715c912c5919a1 Joseph Owen Joseph Owen joseph_owen@q.com 019928 35 2025-11-21 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Secondary - - Yes Sonya C. - Sonya C. 2025-11-21 16:45:28 0.0 hrs 68d4553cf85a8109e6d9dfc5 000020888 3.00 -70.82 83.09 - - - - - - - - 2026-02-19 22:49:31 2026-05-04 23:14:34
9807 e0a789fef68a3ad431cc7b25cb2d658986174f4023b3704648f247e91fcc4ff2 68d405538adfc36de35c1eb2 68d404ab702b09089b886b23 Marion Mackay Marion Mackay mackaydesignllc@gmail.com 019925 21 2025-11-21 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-12-02 19:22:15 266.6 hrs 68d405538adfc36de35c1eb1 000020786 1.00 130.00 130.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-04 23:14:34
9806 e49ed83563d3108a3b7cabf2b868dda29250c8aec28937b56ab32768f1e64781 69010301eba41865eca3af65 68cd8c7944260a08a862447a Violet Helsing Violet Helsing nielsentina@yahoo.com 019898 9 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:16:23 -1.7 hrs 69010301eba41865eca3af64 000025062 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-04 23:14:34
9805 f8621d9d0920559914c9eaa8ec19aa956b4c4f0d98e15978af6e6a6a75342812 68f8ed125c5ecba5ac388a5c 67ced43a7abf9f3ed8fec7a4 Marie Molinary Marie Molinary memolinary@gmail.com 009460 31 2025-11-21 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Stephanie Braun 2025-11-21 17:07:08 0.1 hrs 692744da76ce12427d150801 000024356 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-04 23:14:34
9804 269214018e66c0e2644de8dfed883fa4247bbc24111e566894d1b7ef8f19ae52 68e3d0cda569351e482fc04b 68d2b51907213e079588f54d Christopher Walzer Christopher Walzer chriswalzer@comcast.net 019916 28 2025-11-21 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-21 16:58:09 -0.0 hrs 68e3d0cda569351e482fc046 000022265 3.00 77.82 77.82 - - - - - - - - 2026-02-19 22:49:31 2026-05-04 23:14:34
9803 236eb94948501dfe26ad6434ac05a7778c8040e500dc38a3cf4bd7a99825633d 68d175316e7ece072ec8f99f 67ced2f97abf9f3ed8fe65b0 Harry Carr Harry Carr ezcarrh@gmail.com 001103 17 2025-11-21 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 24+ pt passed away :( RAR 10/20 Rosey Reed 2025-10-20 15:44:32 -769.3 hrs 68d175316e7ece072ec8f99c 000020436 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-04 23:14:34
9802 a3a40065f50b57ad8d324b05681f93e84443d9d37178b63a532dba686c72eca1 68a88ec1c27c1a07a341ac66 67ced5c17abf9f3ed8ff06f7 Kathy Snow Kathy Snow kathytsnow@gmail.com 014861 37 2025-11-21 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sophia L. 2025-11-21 17:08:20 0.1 hrs 68a88ec1c27c1a07a341ac63 000017223 3.00 80.65 80.65 - - - - - - - - 2026-02-19 22:49:31 2026-05-04 23:14:34
9801 f3a3c251de0a2c428a694f70e56db4f2631c34bcc3124f0f1e6af12a49cd7d01 690e148e57820c9968061749 68a88a5f5cdf9b882ecfa948 Erin Hartnett Erin Hartnett erinohartnett@gmail.com 019725 12 2025-11-21 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Dawn Singleton - Abyssel Gobris 2025-12-23 18:54:38 769.7 hrs 690e148e57820c9968061748 000026396 3.00 84.09 84.35 - - - - - - - - 2026-02-19 22:49:31 2026-05-04 23:14:34
9800 a511dd439c5f526ea1c743b25196715d06d2c1c53e674b59196d6a6f9fc0fc06 68f799d2327c770900189d26 67ced5f77abf9f3ed8ff0dff Molly Teas Molly Teas mmteas@gmail.com 015461 121 2025-11-21 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 11/20 - double booked herself Sophia L. 2025-11-20 16:15:25 -25.0 hrs 68f799d2327c770900189d25 000024136 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-04 23:14:34
9799 61a30862e03b1bbd195ca86eaf5b8c7db76956cbc5c3a8dacf323916c86636e2 68eea5956cd29e08afdab1e8 67ced5d37abf9f3ed8ff0955 Rachel Voogt-Clayborn Rachel Voogt-Clayborn clayborn571@gmail.com 015063 35 2025-11-21 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sophia L. - Jayson Encarnacion 2025-11-26 19:55:27 122.7 hrs 68eea5956cd29e08afdab1e7 000023417 1.00 150.00 20.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-04 23:14:34
9798 7d01d9315f59de9ec3ca8ef8428d990196b5860fe656c18669179999a44fc181 68cd97ca870003b67cc9fddc 689b7487d5e35daf6d4beb8f Ryan Muela Ryan Muela rymu2503@colorado.edu 017783 21 2025-11-21 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Jayson Encarnacion 2025-11-25 18:18:17 97.1 hrs 69260fe5ccba193762be9d00 000020336 3.00 85.00 115.00 - - - - - - - - 2026-02-19 22:49:31 2026-05-04 23:14:34
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-04 23:14:34
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-04 23:14:34
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-04 23:14:34
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-04 23:14:34
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-04 23:14:34
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-04 23:14:34
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-04 23:14:34
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-04 23:14:34
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-04 23:14:34
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-04 23:14:34
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-04 23:14:34
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-04 23:14:34
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-04 23:14:34
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-04 23:14:34