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
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:32:28
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-06-11 23:33:26
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-06-11 23:33:26
14416 f1578da9f77437b6887240aee038eb6ba023446db514eb2c763e74e8ed3bb013 68e8119dfbf1fa7116968845 68a8152c99c65c4a78a5f805 Suzanne Harper Suzanne Harper sharper01@aol.com 018583 18 2025-10-15 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Mark Leo Guevarra 2025-10-21 15:31:44 146.0 hrs 68e8119dfbf1fa7116968844 000022971 4.00 85.00 85.01 - - - - - - - - 2026-02-19 23:02:24 2026-06-11 23:33:26
14415 d7afa1a065d210f3fcc159c2a0dd7a8ec6d4f335e8da4459ec9cac4e30008b73 68e3ebb6e8f70d0a0a208880 68d1694a41a4eec04383b5fe Riki Frea Riki Frea freafamily@mac.com 019908 6 2025-10-15 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-15 13:31:15 0.0 hrs 68e3ebb6e8f70d0a0a20887f 000022330 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:02:24 2026-06-11 23:33:26
14414 02e239cde913c7682e29a13475bbcdaa9f16f94ddea906eae6cfddf90d56c701 68d40805e8a8f56d9d2ce381 68d4071dc246f80892fb42fd Charles Cullop Charles Cullop pcullop1982@gmail.com 019927 4 2025-10-15 Checked Out 67ace27f67327b083edb451f Michelle Osgood 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Michelle Osgood 2025-10-15 13:41:02 0.2 hrs 69c5cfc81a854a70377f52dd 000020793 4.00 160.63 160.63 - - - - - - - - 2026-02-19 23:02:24 2026-06-11 23:33:26
14413 971a5ad129901d0688450073b2da8aadf3c44ee42698e4f6df43db601ea42f6f 68c97fdaa608d207f8195b17 689a14ec3c8b1c07d05717cf Brittany Schaefer Brittany Schaefer brittschaefer01@gmail.com 017774 9 2025-10-15 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ scheduling conflict -mw Michelle W. 2025-10-09 19:35:24 -137.9 hrs 68c97fdaa608d207f8195b16 000019869 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:02:24 2026-06-11 23:33:26
14412 a3a1a6be546e965b5be95bc9e724ba285612fb7d1ac67c90ec6209bb93b1718e 68c974bbc5f6da085a8dfa5f 67ced58d7abf9f3ed8feffcc Kathryn Sanderson Kathryn Sanderson sandersonk98@gmail.com 014250 16 2025-10-15 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Mark Leo Guevarra 2025-10-21 16:27:11 147.0 hrs 68c974bbc5f6da085a8dfa5e 000019861 3.00 82.00 153.80 - - - - - - - - 2026-02-19 23:02:24 2026-06-11 23:33:26