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
15706 aa2da82d85931be183fb13dc3c4bcc5f4b0ec7ba3f84658c22a5cb85558ce289 68d1ce57fdf047afde51f4b9 686d56d85f7dbb089aef31cd Rose Lynch Rose Lynch roselynch@comcast.net 017588 37 2025-10-02 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-07 20:56:42 118.2 hrs 68d1ce57fdf047afde51f4b8 000020541 3.00 79.31 69.31 - - - - - - - - 2026-02-19 23:06:48 2026-06-11 23:36:36
15705 c8c3ad2fcb6f2b34bca73a7f0adc72adab7a4bf63a08d276c7e90bc75d2a2628 68d5c8aa80fd915b51526a2a 67ced3bc7abf9f3ed8feab9c Lucy Judson Lucy Judson lucyjudson1951@gmail.com 007069 82 2025-10-02 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2025-10-07 14:50:15 111.8 hrs 68f803a0dbc3e4b3b19da18f 000021144 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:06:48 2026-06-11 23:36:36
15704 d74fb75d179f79ea8d32c2eed25cf2de5a820a91be31310d0bb4a9b8e65413b9 68a392d448583f3464c84ed7 684862a948ba666f6303f7f1 Summer Nicks Summer Nicks nickssummer@gmail.com 017430 16 2025-10-02 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ pt lvm at 5:03 on 10/01 -mw Michelle W. 2025-10-02 13:11:07 -9.8 hrs 68a392d448583f3464c84ed6 000016592 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-06-11 23:36:36
15703 872bbac5c7e201a91eeac5e9a2c2c6e2dc42668b268460cebae7102a851159bf 68928dd470a29c086bd1c2c0 67ced4be7abf9f3ed8fedfb3 Kiersten Pierpoint Kiersten Pierpoint pierpoint_kiersten@svvsd.org 011512 33 2025-10-02 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-02 22:58:19 -0.0 hrs 68928dd470a29c086bd1c2bf 000015459 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:06:48 2026-06-11 23:36:36
15702 5b0eb277b685ebc09b53e1ceca2cf8059add8cbc3cc26446fa86a5ffe5255cfd 68a5e6d2588ab8083e09db25 68a5e4d825566307d108fe49 William Lucca William Lucca cblucca@msn.com 017831 23 2025-10-02 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Primary - - Yes Frances Lawrence - Kenneth Dave Francisco 2025-10-08 15:56:18 136.7 hrs 69ba0141133b3077a44607d6 000016863 4.00 314.00 50.00 - - - - - - - - 2026-02-19 23:06:48 2026-06-11 23:36:36
15701 4cf8f678ccf13bdd879a3a6cee838cf1921453144b99982efa06ba67da4bba9b 686d8d1ce16b3d0893291d33 67ced4727abf9f3ed8fed268 Nancy McGann Nancy McGann nancymcgann@imail.org 010378 45 2025-10-02 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Patient - - Yes Maia H. - Laura Shove 2025-10-03 00:10:07 0.7 hrs 686d8d1ce16b3d0893291d32 000012177 3.00 85.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-06-11 23:36:22
16061 89a5c04aeff4152da8c467fbf9c49b0fbfc9050c535fb1d982558a7950200bc9 68dadb924b25c09147840adc 6896481e1d2a819c6a62a428 Katherine Lightfoot Katherine Lightfoot katie.lightfoot@colorado.edu 017771 44 2025-10-01 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Samantha Saunders 2025-10-01 13:05:21 0.1 hrs 68e67abc76c2ba08a0ac7ab8 000021442 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16060 a0864e9974b097bd985716d93c0c1b69328e13705000b941d09cfab16366177f 68b76e10219ffa1fde4159a6 6875137f036b57078846c4ce Amber Mault Amber Mault amber.mault@gmail.com 017620 17 2025-10-01 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-01 13:47:48 0.8 hrs 68e0118642c8ce0984016db8 000018441 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16059 57aaf95ae3283eee845442087efa9ccf0563f646b3c523daf00f4c7cd7ff77df 68653db38b9d12931f047d63 67e6661befbf2c53d8d5f340 Zaira Nevarez Zaira Nevarez zaira_0102@hotmail.com 016860 33 2025-10-01 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. Patient texted that she woke up late/won't make it in. SB Stephanie Braun 2025-10-01 13:05:27 0.1 hrs 68653db38b9d12931f047d62 000011554 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16058 38da3d0734e8184ad47284c5b9f5ba47b11299cb1255ee4ca018900c6ebd2ff1 68c18239e8e1ef08ee3ff78a 67ced3ee7abf9f3ed8feb7ab Nadiia Kovalenko Nadiia Kovalenko n_kovalenko@aol.co.uk 008098 14 2025-10-01 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Kenneth Dave Francisco 2025-10-02 14:57:00 25.5 hrs 68c18239e8e1ef08ee3ff789 000019345 4.00 101.00 181.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16057 2e02fd5ccbb3357c2410ab911807fe74e5f69d49de79b5bad839b5920a350bf5 68b852229a04b20823dbb03f 6888e114dc80142d6a2c2097 TM Frey Morris TM Frey Morris drpiefrey@mac.com 017716 29 2025-10-01 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Michelle W. - Michelle Osgood 2025-10-01 13:37:40 0.1 hrs 68f25bd432f3a94e247a6bb2 000018482 3.00 232.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16056 9b2ddaadf9d1cc7c0b3569e20f91eced9b1df8b12d805201542762d759d0a43d 68a61f98d47fc4e5fa44c515 67ced4647abf9f3ed8fecfa7 Caroline McClurg Caroline McClurg mcclurg.caroline@gmail.com 010143 34 2025-10-01 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Rosey Reed 2025-10-01 14:43:26 1.2 hrs 68a61f98d47fc4e5fa44c514 000016958 5.00 125.29 125.29 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16055 bac96d07d7088ac6e1f9e565fba6def312b2dc16459f18cce96cdd5e78eaa298 6893735a77e87307dfc7af3f 67ced5b67abf9f3ed8ff0586 Robin Smith Robin Smith robins@gmx.us 014738 21 2025-10-01 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-10-02 17:21:53 27.9 hrs 6893735a77e87307dfc7af3e 000015486 4.00 25.00 25.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16054 3161ca437f64ceafa594514d5aeb7d54f4c78d41ab7f3bd4e9d143552a5d0e69 68653f4c2b42a957c231647b 67ced43a7abf9f3ed8fec7a4 Marie Molinary Marie Molinary memolinary@gmail.com 009460 31 2025-10-01 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Michelle W. - Michelle W. 2025-10-01 13:33:23 0.1 hrs 697cb163628a06ab17ca03d5 000011566 2.00 156.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16053 aad73b15ba67a0c8969660ca6dfa3739fb5313a6151c37fde9b298ef164dfee9 683080b3297bbfda698d518d 67ced3c77abf9f3ed8feae75 Martina Kastengren Martina Kastengren kastengrenm@gmail.com 007312 39 2025-10-01 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Marguerite Barth 24+ due to work schedule - sc Sonya C. 2025-08-12 15:48:41 -1197.7 hrs 683080b3297bbfda698d518c 000006757 3.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16052 3d96530a8ab1f569466d78fd05fc6a0816674d163bd34e5f8f88230cfd2c4cb8 68a8ccbf842b8a12a058e59e 67ced3cc7abf9f3ed8feafc8 Brigid Keating Brigid Keating brigid.keat@gmail.com 007425 30 2025-10-01 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. pt conf cxl- sophia sick SL 9/30 Sophia L. 2025-09-30 22:38:12 -15.1 hrs 68a8ccbf842b8a12a058e59d 000017318 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16051 04e3847c48fca5a41f79b44be98b86d5668f0e5eb3615eb27939f467a0b97e45 686d78d3c68b4f6dd73435a6 67f6911cb12c7b079be55ce1 Julie Ramirez Julie Ramirez oracle789@hotmail.com 017019 12 2025-10-01 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ LVM to cancel appointments due to work getting super busy - sc Sonya C. 2025-08-21 19:40:50 -978.1 hrs 686d78d3c68b4f6dd73435a5 000012148 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16050 8ab057494cbedea7ed039d108994c6d93685ef89787f1e31b56a2a1cd934c6dd 68d2b7ed2ebf3a085dd1829a 67ced32d7abf9f3ed8fe7df5 Jennifer Burak Jennifer Burak jenburak20@gmail.com 003174 101 2025-10-01 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ scheduling conflict -mw Michelle W. 2025-09-30 14:18:39 -23.7 hrs 68d2b7ed2ebf3a085dd18299 000020583 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16049 11879e4f520b2faf3eb1ef08cbd9f1741ddc335c4a8886bb656b1b6ebbeff685 68bf345327ef9abe0e9ff8db 67eab3a06cfbde087431910a Jeniffer Grodberg Jeniffer Grodberg jeniffer@jeniffergrodberg.com 016934 15 2025-10-01 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2025-10-02 22:07:55 32.1 hrs 68bf345327ef9abe0e9ff8da 000019086 3.00 79.29 119.29 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16048 505ec092f31d9163373f943c80a432403ec9ee22c6558f0c2686e1110ddda75c 68ba132d2ac01bb1d5aa4110 67ced6127abf9f3ed8ff1190 Jesseca Tighe Jesseca Tighe jessecamcd@gmail.com 015765 5 2025-10-01 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-09-04 22:31:25 -639.5 hrs 68ba132d2ac01bb1d5aa410c 000018823 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16047 6cf17164ee76fe3497c146c65b3bbd8d0690ce832c84b1ac1df44d7a9ac3a0c8 68af160da23675335b1d0ba3 683894c42f21dae449a884bc Erin Giveans Erin Giveans ekgiveans@gmail.com 017340 37 2025-10-01 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-01 14:31:53 0.5 hrs 68af160da23675335b1d0b9f 000017703 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16046 67dfaf5965424933ab2994c15167a8c1f94a2b89a7570f448b2e48987b715ed7 68a61a8c6f38194b967af225 67ced57e7abf9f3ed8fefdb6 Jennifer Simpson Jennifer Simpson jlynphd@gmail.com 014072 16 2025-10-01 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Kenneth Dave Francisco 2025-10-02 15:00:04 25.0 hrs 68a61a8c6f38194b967af224 000016946 3.00 82.00 82.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16045 c27ee56397e14b571370b72b124f3f1a9f3cde786dc66299c6463b0ee97c2e3f 68a5fe03085907081abfb04d 6887e0669b77f5683408a822 Jack Miller Jack Miller jack.merrill.miller@gmail.com 017713 15 2025-10-01 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. 24+ found PT that works w/his schedule- sc Sonya C. 2025-08-29 16:40:47 -789.3 hrs 68a5fe03085907081abfb04c 000016905 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16044 f8d3df32aed1d0c68e2d701217703be73b393f9756c047a71b57656d303d2039 6893863fcf55ab0806450669 68938556431f72084b4993c3 Thomas Sheldon Thomas Sheldon tsheldond@aol.com 017762 26 2025-10-01 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Michelle W. 2025-10-01 13:56:34 -0.1 hrs 6893863fcf55ab0806450661 000015501 2.00 53.15 53.15 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20
16043 58b8af30e09560fbf6083c5ddf55f20a3dabdfdb0066cc27ca3b2fe32495bdb0 68dc3ef09d6ee530582cdf70 68dc3ead31ec81b07464b536 Cynthia Ferrer Cynthia Ferrer cynthiaferrer@gmail.com 019960 3 2025-10-01 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67fe758025fd260826e4f8b1 Pelvic Floor Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Sonya C. 2025-10-01 14:14:53 -0.0 hrs 68dc3ef09d6ee530582cdf6f 000021707 4.00 383.00 0.00 - - - - - - - - 2026-02-19 23:07:54 2026-06-11 23:37:20