General Visit (PT Boulder API)

Total rows: 100,908
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
14093 67129ceea7172ebe91975b74f17c94b125a730630ad87c11db3b8557bd3ab172 6882a12593cce3c237eac3c5 67ced4d17abf9f3ed8fee2dd Nancy Pottoff Nancy Pottoff npottoff@hotmail.com 011782 533 2025-10-16 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-10-16 21:46:49 0.0 hrs 68f2441538ae5b0a0739c3d7 000014296 2.00 80.00 80.00 - - - - - - - - 2026-02-19 23:01:34 2026-05-07 23:27:41
14092 9ac9c0b606257c2a2a35c29e72640ce132d7bac882269076d81156c2ab13ff19 68e680ecbafbaf6d32d83331 6839e68faec4ff75e0455e02 Kurt Blickenstaff Kurt Blickenstaff kblickenstaff@gmail.com 017350 11 2025-10-16 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. delete Sophia L. 2025-10-08 15:21:30 -198.6 hrs 68e680ecbafbaf6d32d83330 000022712 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:34 2026-05-07 23:27:41
14091 3dc4b3ed614d9ea45f8d1888d66aee3ec3b803d2e1c2737972075989a0fc3208 68de93434e8d3209be855df7 68b0af4ce11201520200e21d Erin Bornemann Erin Bornemann eebornemann@gmail.com 019774 3 2025-10-16 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 689983a679e412ce7c3dfcf6 Westminster Paid - Patient - - Yes Rayann Greer - Mark Leo Guevarra 2025-10-22 18:37:28 140.6 hrs 68de93434e8d3209be855df6 000021985 3.00 78.69 78.69 - - - - - - - - 2026-02-19 23:01:34 2026-05-07 23:27:41
14090 e4f358f21d9c6460976576d7e3007ab2fcf212f22dfe6d1a81282ba7e5c73178 68d5c29de7cb52d6fa87fafa 6839e68faec4ff75e0455e02 Kurt Blickenstaff Kurt Blickenstaff kblickenstaff@gmail.com 017350 11 2025-10-16 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Jayvee Totanes 2025-10-22 18:22:07 140.4 hrs 68d5c29de7cb52d6fa87faf8 000021139 3.00 81.15 61.15 - - - - - - - - 2026-02-19 23:01:34 2026-05-07 23:27:41
14089 c089c0428ca6c4c54439ddff982938618d18621ecc1bb3488ac1c9634238c86e 68c34ee79a3ce232ec0db888 68bf2f2982ab1df8538e1ba7 Donna King Donna King ilyaking@gmail.com 019820 17 2025-10-16 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2025-10-22 17:57:32 140.0 hrs 68c34ee79a3ce232ec0db887 000019615 3.00 83.55 83.55 - - - - - - - - 2026-02-19 23:01:34 2026-05-07 23:27:41
14088 78707ef965b74c45b2b9d0b7ce0d89045f6529aac79d27a1b809e7045242a69a 6894b7aaeca2db086be93924 67ced56e7abf9f3ed8fefb61 Josi Turner Josi Turner josisingleton@yahoo.com 013873 20 2025-10-16 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 10/6 Sophia L. 2025-10-06 17:31:11 -244.5 hrs 6894b7aaeca2db086be93923 000015687 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:34 2026-05-07 23:27:41
14087 a2414449eda3004bbaaee870058350d8de02ce5aa2ece9ce54491f8bc5aa1e9e 68658a021b3870d0858f930d 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-10-16 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Gillian B. - Kenneth Dave Francisco 2025-11-05 18:39:42 476.7 hrs 690291ed4a797e62055d27c1 000011672 5.00 390.00 0.00 - - - - - - - - 2026-02-19 23:01:34 2026-05-07 23:27:41
14086 54370ad8595e34f240dbd8c6496e1704cd0194ec8e6fc24bf9dd6e85042dd774 68b9cc8c83a4e3d02532c7fa 67ced36c7abf9f3ed8fe94c5 Jean Goodall Jean Goodall jj.goodall54@gmail.com 005120 16 2025-10-16 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-21 15:54:40 113.7 hrs 68b9cc8c83a4e3d02532c7f9 000018707 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:01:34 2026-05-07 23:27:41
14085 0f59b8f1f1d729e81ba6a9b9bac7eecd7c2ca2467d2394f0e342c4947eea022a 68af28436d5d6587269b92cd 68af26869840478ac34147ca Karlota Estevan Karlota Estevan karlesbee@gmail.com 019755 19 2025-10-16 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Sophia Phillips 2025-09-17 22:19:00 -695.9 hrs 68af28436d5d6587269b92c9 000017749 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:34 2026-05-07 23:27:41
14084 1ebbeda60cff9294056bbd388a9c40edbab0fd9d5d70ed51bb1daa74187d281a 68f6987b034fe7acc4540e96 68a6289e3dd18cf367999e24 Stacie Tureson Stacie Tureson stacietureson5@gmail.com 017857 10 2025-10-16 Cancel 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Frances Lawrence wants next week Frances Lawrence 2025-10-20 20:17:16 93.8 hrs 68f6987b034fe7acc4540e95 000024064 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:34 2026-05-07 23:27:41
14083 e61406f15cde68619f935f45657bf51d445bc10a2909d152d391c34ba8fed1cd 68ee907d96e8262e7988dcbf 680908e6dc968f594897748f Peggy Moore Peggy Moore pjmoore46@msn.com 017113 70 2025-10-16 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - John Phinney 2025-10-16 22:31:51 0.0 hrs 68f18bd486869fdb1f35e062 000023403 2.00 55.92 55.92 - - - - - - - - 2026-02-19 23:01:34 2026-05-07 23:27:41
14082 c75a738394237f135fa5da44f78e7cf4ab7a08dbc11c371660ce3919a982e853 68e3e45ee70335dc2e896a9b 686bdc662237934714373a11 Darryl Hobson Darryl Hobson darryl@ihcclinic.com 017575 39 2025-10-16 Cancel 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. Per VM - Pt states that he's too tired to make it in- sc Sonya C. 2025-10-16 21:01:15 -1.5 hrs 68e3e45ee70335dc2e896a9a 000022297 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:34 2026-05-07 23:27:41
14081 170ba676ec1f15c2537934aa4aef5f7440416fc4b83c306ee0583949d2b270ab 68d2f836c0b23033ad312c2b 68a8154c99c65c4a78a5fe9a Jane Lofthouse Whitehead Jane Lofthouse Whitehead permutjl@gmail.com 018910 4 2025-10-16 Cancel 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Emmie Gebhardt needs to drive son to swim class Frances Lawrence 2025-10-14 02:01:30 -68.5 hrs 68d2f836c0b23033ad312c2a 000020693 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:33 2026-05-07 23:27:41
14080 a625951d9727cf3287f33361e1cf18b4eab6cc7f14638a8c90e1442db1da545e 68d2f6d5af9491fda6e6c177 68d2f69599b6f3219a989487 Samuel Sweeny Samuel Sweeny sweendoc11@gmail.com 019921 5 2025-10-16 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt woke up sick Michelle W. 2025-10-16 13:06:24 -9.4 hrs 68d2f6d5af9491fda6e6c176 000020688 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:33 2026-05-07 23:27:41
14079 626286b00536160af64778540d9b82c460df4c6ae61ffdd5f22d9b6e779fc1a6 68c1d6ec9c003b3ecf18f013 68c1d59dbf83f0d7ca3d3603 Eric Schaetzel Eric Schaetzel evschaetzel@gmail.com 019834 11 2025-10-16 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayvee Totanes 2025-10-22 18:26:06 139.9 hrs 68c1d6ec9c003b3ecf18f00b 000019431 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:01:33 2026-05-07 23:27:41
14078 8b696000f60894a51246762bb900cac556e5a335dfc2a2420bfb64b968b8d80a 68b0639ba7cfa3764c3353fd 68b06228db82a82b395da9b7 Renee Knutson Renee Knutson rjk3k@msn.com 019769 5 2025-10-16 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 10/10 Sophia L. 2025-10-10 16:19:56 -150.2 hrs 68b0639ba7cfa3764c3353fc 000017935 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:33 2026-05-07 23:27:41
14077 c62bf6176c5436330cdcf6dc866b5a2c070c65e859770dc00423374890849970 68a753e345d2d5cf96fc1fa0 68a752540dc9debdec764d99 Katherine Bewley Katherine Bewley katbewley@gmail.com 017885 17 2025-10-16 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. Called and stated "Pt. won't be in Boulder today" - sc Sonya C. 2025-10-16 14:33:21 -7.9 hrs 68a753e345d2d5cf96fc1f97 000017094 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:33 2026-05-07 23:27:41
14076 d30f31919cdf1fcec282f5af7009a1ceaafcbf5129ee1ee20237bc6d713a411b 68d320a989c970d76ee5ab57 67ced3137abf9f3ed8fe73b4 Jennifer Brinker Jennifer Brinker jenrosebrinker@gmail.com 002299 40 2025-10-16 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Sophia L. 2025-10-16 22:43:25 -0.0 hrs 68d320a989c970d76ee5ab56 000020761 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:01:33 2026-05-07 23:27:41
14075 904bb4023dcaa4d3bc251ef9f94c89c93aa8f887068c9d75dcd94afcbfd8df2d 68dbfe83ae378b0a226f8d42 67ced5997abf9f3ed8ff0170 Wendi Stewart Wendi Stewart stewart.wendi@gmail.com 014390 43 2025-10-16 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Emily Pickner 2025-10-16 23:25:31 0.4 hrs 68dbfe83ae378b0a226f8d41 000021612 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:01:33 2026-05-07 23:27:41
14074 a4683c9922e1e0121c694686bac086a0e866fc495d19d9f56ea6ddefde6e9b98 68bb3ef59d5364f1eaf48d9d 67ced4be7abf9f3ed8fedfb3 Kiersten Pierpoint Kiersten Pierpoint pierpoint_kiersten@svvsd.org 011512 33 2025-10-16 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ Pick is I'll - sc Sonya C. 2025-10-16 11:51:49 -11.1 hrs 68bb3ef59d5364f1eaf48d99 000018960 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:01:33 2026-05-07 23:27:41
14073 4953c5a4bbbbff02576b6b0f0d8493fed268de057af8e2320ba8efc64564f164 6893c2b54b76da5b183ea9e0 67ced3487abf9f3ed8fe8867 Lois Edgar Lois Edgar edgar@colorado.edu 004065 236 2025-10-16 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Maia H. - Rosey Reed 2025-10-16 22:57:41 -0.0 hrs 6949a4f50b310f2a2f64b414 000015585 3.00 81.40 64.85 - - - - - - - - 2026-02-19 23:01:33 2026-05-07 23:27:41
14072 560d629b2882179be58f6bdbb72f2f750b6fad910f608d6bb2e6a59661c64e4a 68a5e6d2588ab8083e09db29 68a5e4d825566307d108fe49 William Lucca William Lucca cblucca@msn.com 017831 23 2025-10-16 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Frances Lawrence - Mark Leo Guevarra 2025-10-22 18:31:20 139.3 hrs 68a5e6d2588ab8083e09db20 000016867 4.00 95.48 145.48 - - - - - - - - 2026-02-19 23:01:33 2026-05-07 23:27:41
14071 fe98793d0b04e0e7afdb41869bfb7314ece0d1b0aa57282394488ad5b4868baa 68a39366900d21b67b67ca3e 684862a948ba666f6303f7f1 Summer Nicks Summer Nicks nickssummer@gmail.com 017430 16 2025-10-16 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Patient - - Yes Sophia L. - Anne Majewski 2025-10-17 19:04:41 19.8 hrs 68fc0450802adbd0c2280d48 000016595 4.00 313.00 0.00 - - - - - - - - 2026-02-19 23:01:33 2026-05-07 23:27:41
14418 0fe1eda6298b313f37d8f9e7604fb2aebda9b8422c85363cc67fd83fff0dc719 68dd4b9fda3d300956f2596d 68dd4ad85586a80982267801 Deborah Correll Deborah Correll dbcorrell@yahoo.com 019966 21 2025-10-15 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Sonya C. 2025-10-15 13:08:56 0.1 hrs 68dd4b9fda3d300956f2596c 000021829 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:02:24 2026-05-07 23:28:27
14417 143083f789aa83b88c2b53e1f6477bb9549bac7d7a4f364889c913219d49e772 68653dcd5a8c3507ff09fb2c 67e6661befbf2c53d8d5f340 Zaira Nevarez Zaira Nevarez zaira_0102@hotmail.com 016860 33 2025-10-15 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Michelle W. 2025-10-15 13:07:21 0.1 hrs 68653dcd5a8c3507ff09fb2b 000011555 2.00 100.00 100.00 - - - - - - - - 2026-02-19 23:02:24 2026-05-07 23:28:27