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
19731 ac27e9a650e776fc3b0f462a6b4a66af3008f38c284b119c685628a6e0be245e 68ae3d4b509893336a36d8f7 686d56d85f7dbb089aef31cd Rose Lynch Rose Lynch roselynch@comcast.net 017588 37 2025-08-29 Cancel 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-08-27 20:02:11 -44.0 hrs 68ae3d4b509893336a36d8f6 000017675 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:17 2026-06-10 23:46:54
19730 10182abe56ef8114f06776a2393ee37d7f1528d1266a3de211f320fa3e539b76 68acef5247d44e2866cf344b 67ced3067abf9f3ed8fe6d15 Deborah Appel Deborah Appel debbie2175@me.com 001734 90 2025-08-29 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Laura Shove - Laura Shove 2025-08-29 16:37:55 0.6 hrs 68c6d91678b625e1c89aa6ae 000017495 3.00 78.70 78.70 - - - - - - - - 2026-02-19 23:18:17 2026-06-10 23:46:54
19729 1ddd994788da1e5be174264fb3de0257d232611f3f72015be0cd07b19a3fc66c 686da04c35ca3808b9c28558 67eea0549abea908576a38b9 Stephanie Arthur Stephanie Arthur 2arthurs@gmail.com 016974 14 2025-08-29 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ - pt feeling really well - sc Sonya C. 2025-08-27 17:43:58 -46.3 hrs 686da04c35ca3808b9c28557 000012195 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:17 2026-06-10 23:46:54
19728 479ea10273957e90148c107f8703bfa813b2167413b9783f20bd9b05da79d9e0 685c7b420c7ac50834c741be 67ced4de7abf9f3ed8fee517 Joan Raderman Joan Raderman joan@circleofcareproject.org 011972 42 2025-08-29 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Maia H. 2025-08-22 17:00:19 -167.0 hrs 685c7b420c7ac50834c741b6 000010849 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:17 2026-06-10 23:46:54
19727 91d893f16601799a82a0b6a59de819c8a2cc9dc23fa19ba0382b656178403fbf 68485c4314d26a0805c3c314 68485b30a7ca39fd8271cb93 Robert Edson Robert Edson capn.bob65@yahoo.com 017428 36 2025-08-29 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Gillian B. 24+ sc Sonya C. 2025-06-27 17:28:12 -1510.5 hrs 68485c4314d26a0805c3c313 000008844 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:17 2026-06-10 23:46:54
19726 92de39281dbdf839afcda9e4c7dc6ce3e8f95bcb934fba783c96c2cef00425df 68894f22407b132dfa70dbca 67f579485212fe07f7b2c032 Cindy Murphy-Becker Cindy Murphy-Becker cindybecker82@yahoo.com 017014 33 2025-08-29 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. - Maia H. 2025-08-08 21:09:10 -499.1 hrs 68894f22407b132dfa70dbc9 000014732 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:17 2026-06-10 23:46:54
19725 2c1247d37d82d9bc531cdc1258e7f6a0e88227cc1b7cd9692e29d96dddfe7475 687ffc80901f39403c425cdc 687ffb82b822540879a15319 Denise Austin Denise Austin shahe05@gmail.com 017674 12 2025-08-29 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-08-30 21:53:26 29.6 hrs 687ffc80901f39403c425cd7 000013905 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:18:17 2026-06-10 23:46:54
19724 360e574317d2ca2a5c6d949f674022a10d00bf372fd4b760978595b7ff2ce461 687a96a8bb6c8527a54afb37 687a95e9e9301707d8e07673 Dale Kishbaugh Dale Kishbaugh kishbaughdale@gmail.com 017655 8 2025-08-29 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-09-02 21:14:43 101.0 hrs 68b75e5030c785eff2f51f1a 000013566 2.00 80.00 80.00 - - - - - - - - 2026-02-19 23:18:17 2026-06-10 23:46:54
19723 bbb3e1427139815200193adc0eb3ac99056205a16c308b84c050ad939158c27d 687807435a6ac208858b5470 687805889eea90081b615649 Michael Hegarty Michael Hegarty mjhegarty@msn.com 017638 12 2025-08-29 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-08-05 17:10:20 -575.1 hrs 687807435a6ac208858b546d 000013246 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:17 2026-06-10 23:46:54
19722 611c858c2e29203de4825a1170213ce4929af20646fd109eda5811e443df8f8c 686e93daf039418b08a2e7b7 686e920f760b7408fb5e768e Paula Muir Paula Muir pmuir747@gmail.com 017595 24 2025-08-29 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a18d0965a342e59d1264 Boulder Suite 205 Partially Paid - Patient - - Yes Maia H. - Samantha Saunders 2025-08-29 16:23:16 0.1 hrs 686e93daf039418b08a2e7b1 000012277 3.00 80.00 60.00 - - - - - - - - 2026-02-19 23:18:17 2026-06-10 23:46:54
19721 84c037bb6692df3b6e9f13f7e39ca7aac69f7f7c3139eb74cd1fb2fafa09c782 681e596795b77ec73ca0762f 681e57763f770d07d1d1d9c0 Inez Buggs Inez Buggs boulderbuggs@aol.com 017214 12 2025-08-29 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Miranda Samson 2025-07-18 16:51:10 -1007.4 hrs 681e596795b77ec73ca0762c 000005077 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:17 2026-06-10 23:46:54
19720 92583a306784724b918e540f3929f2a6046ed1878df56dffd78b9d58b62245d7 68a818d4b625571f00455479 68a670f2b4976e04017c80d0 Jeffrey Peacock Jeffrey Peacock jeffrey@jdpeacock.com 017872 9 2025-08-29 New 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-08-22 07:14:27 -177.1 hrs 68a818d4b625571f00455478 000161153 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:17 2026-06-10 23:46:54
19719 f3cb821b1aafa01c77927a48294364c265c1df1b950246ab29811586a07f4a33 6887b6019b77f56834074789 67ced3487abf9f3ed8fe889d Megan Edwards Megan Edwards itsmeganedwards@gmail.com 004083 26 2025-08-29 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Maia H. - Elizabeth Cousins 2025-08-29 21:58:09 5.5 hrs 6887b6019b77f56834074788 000014486 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:18:01 2026-06-10 23:46:54
19718 b41e2f2a1bf2b45a454741a6bf6846754a74c0ffad904e75543614ca78c13419 68950d43d62c55b9fdc864ad 67ced45e7abf9f3ed8fece90 Samantha Otterness Samantha Otterness samotterness@gmail.com 010050 26 2025-08-29 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-09-03 18:19:40 121.6 hrs 68b886cad81a8ad848796932 000015749 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:18:01 2026-06-10 23:46:53
19717 dad099427adc8eeffb8417dfaf41987361f344232a840356eb6581cf5e371a2f 687976124db3c20e13df1e35 68797480fa0eead03c9ec4cb Claudia Bracken Claudia Bracken cabinzoya@msn.com 017650 7 2025-08-29 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-29 16:31:51 -0.2 hrs 687976124db3c20e13df1e31 000013464 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:18:01 2026-06-10 23:46:53
19716 39e8b5b88e712bd85855262ad69c6e6ccc6452c199917d3326cbf67e363034f3 6877d5e71db9a84d84b2bce3 6814fef62374dabd173ef740 Robert Macrae Robert Macrae macrae@colorado.edu 017170 13 2025-08-29 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Ranjini Ridgway - Samantha Saunders 2025-08-29 16:49:08 0.1 hrs 6877d5e71db9a84d84b2bce2 000013189 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:18:01 2026-06-10 23:46:39
19715 04df11f26a1a725a3e8cdbd1682787b4b9b463e22a4c38539104a6a0a12a5689 68547e9e7e785707c8695a44 67f00c9821f4ea11b3a88612 Hope Bartlett Hope Bartlett hope.bartlett05@outlook.com 016990 17 2025-08-29 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ sch conflict - RAR Sonya C. 2025-08-27 22:35:01 -42.2 hrs 68547e9e7e785707c8695a43 000010034 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:01 2026-06-10 23:46:39
19714 a6aef6ea5631e5a9bf8ba5d41fe38654514c698f84dd39b4c0591ba1f8819b71 68546f2b7fb0d6086f6da1c2 67ced43b7abf9f3ed8fec7cc Scott Mason Scott Mason scott.mason@partstrader.com 009473 19 2025-08-29 Cancel 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 8*28 LVM again that the appt is cxl'd- sc Sonya C. 2025-08-28 14:20:28 -26.4 hrs 68546f2b7fb0d6086f6da1c1 000009995 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:01 2026-06-10 23:46:39
19713 39155068d3b096c01f77a38a606f76c243564092d7b69286356a534c2ae295b5 684310a11fb1f507781cd8ae 67ced4257abf9f3ed8fec363 Maryann Miller Maryann Miller ms.schultz@comcast.net 009097 105 2025-08-29 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Stephanie Braun 2025-08-29 17:41:04 0.9 hrs 684310a11fb1f507781cd8ad 000008561 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:18:01 2026-06-10 23:46:39
19712 7cf98d55f26e9ddfed33058d14a7695539284c88fc504758939083d326e2f5b6 68a8191eb625571f0045683b 68a737b3b2718f28d2c7d759 Alexis Wang Alexis Wang awang@ball.com 017874 7 2025-08-29 New 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Frances Lawrence 2025-08-28 22:41:21 -18.3 hrs 68a8191eb625571f0045683a 000161233 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:01 2026-06-10 23:46:39
19711 b230668f7e22ca07bd80147b472cdca7e2fe3dc95fc7ebc62a43b8fee139358d 688935bd2657b207f70889ad 688934c28ddfd8b8e9b93d34 Catherine Ford Catherine Ford cathyfd13@gmail.com 017719 34 2025-08-29 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-29 17:07:53 0.1 hrs 68ff7c2f78dfdb097b194b62 000014686 3.00 75.12 75.12 - - - - - - - - 2026-02-19 23:18:01 2026-06-10 23:46:39
19710 ab75475077969bf1968cf94e33e7c09505242178b6c987d2c5db7fae87e09df2 687a7c65d43a4b07ff501304 67ced2ea7abf9f3ed8fe5bde Kristina Berquist Kristina Berquist kzberquist@aol.com 000265 200 2025-08-29 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Ranjini Ridgway 2025-08-30 21:24:06 28.4 hrs 68b36c06bb112e6d5d89be2a 000013523 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:18:01 2026-06-10 23:46:39
19709 e5ea7dff68e4a4ba957ed4128caf5d5ab6e7b6a0d4e514fd4ce26b47d2a7a8a3 6876af25ef366199e4a64387 67ced6327abf9f3ed8ff15ab Caroline Williams Caroline Williams caroline1119@hotmail.com 016115 48 2025-08-29 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 8/19 Sophia L. 2025-08-19 17:49:53 -239.2 hrs 6876af25ef366199e4a64386 000013044 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:18:01 2026-06-10 23:46:39
19708 11a624c2fb78f9a9dcb9845ca25cdfafd35df38b10ee38680d59d470cbced953 6849eb23494094ca1352a779 67ced3757abf9f3ed8fe97cb Janet Hart Janet Hart janethart80301@icloud.com 005378 167 2025-08-29 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sophia L. 2025-08-29 16:59:54 -0.0 hrs 6849eb23494094ca1352a778 000009076 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:18:01 2026-06-10 23:46:39
19707 3c6b485e49d81f6960e4798e1ccd762b30f12045fe408844bb4e9af5bf7d2a1d 68a72efdc967b8a269402e76 67ced3927abf9f3ed8fea065 Emily Friedberg Emily Friedberg friedberges@gmail.com 006112 23 2025-08-29 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-08-29 17:18:53 0.1 hrs 68b75e67d728be6077669b31 000017025 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:18:01 2026-06-10 23:46:39