General Visit (PT Boulder API)

Total rows: 101,513
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
16811 f58d3adc6d6de6265331262a728ae20ab046c02f0492e055e66445b84992e059 68a88854b1492f3d7b8839e7 682f73dae7fa90a378015476 Emmile Lindemann Emmile Lindemann emmile.b.ohara@gmail.com 017292 29 2025-09-24 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Mark Leo Guevarra 2025-09-25 16:57:05 24.0 hrs 68a88854b1492f3d7b8839e6 000017207 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:35:02
16810 7dc50a3a64eb9557278d95872a9da082fd7bee2bcdefb7637935410c95ee11fb 68a630b4af93783b9d5d3dc0 682750e4e1d78f96208ec404 Siri Cavanna Siri Cavanna siriloe2@gmail.com 017253 14 2025-09-24 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia L. - Sophia L. 2025-09-24 17:31:52 0.5 hrs 68a630b4af93783b9d5d3dbf 000016986 1.00 95.00 76.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:35:02
16809 05512c991af682f73cde9cfed0cab7506425989fd33ee1220d5d9b321fef1ddb 68a4eb933547c7f87936f32f 67ced5597abf9f3ed8fef841 Rachel Trueblood Rachel Trueblood truebloodelf@gmail.com 013607 240 2025-09-24 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-06 17:21:14 288.4 hrs 68a4eb933547c7f87936f32d 000016801 2.00 60.00 60.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:35:02
16808 031abbb5895a0d4ea82029ead0e172c37a9e598beca1c79a60433c5f80516801 68a4855b65a3bb0825b15de9 67ced4647abf9f3ed8fecfa7 Caroline McClurg Caroline McClurg mcclurg.caroline@gmail.com 010143 34 2025-09-24 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Michelle W. 24+ pt conf cxl SL 8/20 Sophia L. 2025-08-20 19:21:30 -837.6 hrs 68a4855b65a3bb0825b15de8 000016644 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:35:02
16807 8116c9257941384569ddbac4bdcf9fa3884669303163f534da8d5cad37a4696c 6866933dbf205e0775c2aa76 6827b20625d7295ca3be3cfa Ronald Wodehouse Ronald Wodehouse ron.wodehouse@gmail.com 017257 9 2025-09-24 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Mark Leo Guevarra 2025-09-25 18:22:37 25.4 hrs 68d43c6fece7946d6d87799c 000011721 3.00 81.87 81.87 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16806 b83f7d946f5eb5cac45d821d372f49bc2d719061a280e108b9c91fcab62f5b81 686576993d3d9107ae11f5c0 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2025-09-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Gillian B. - Rosey Reed 2025-09-24 16:53:44 -0.1 hrs 686576993d3d9107ae11f5b4 000011638 4.00 314.00 0.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16805 768ec6bd2fa68dcd9eedeac358130ecfbb8bac512ff63a11e70a6dd44dbdebc4 68654db36a815107e43464de 68654cf5f52fec1ae7e5a0a4 Selene Luna Selene Luna selenelh@gmail.com 017561 9 2025-09-24 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-24 17:04:33 0.1 hrs 68654db36a815107e43464d9 000011581 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16804 cfd03f297c2c120b825347802de28049ede74293c9ca44fcd686f75c18d9a6f3 68bb047f6934e2f9849bfc39 68388ff20c8650b262bb624b Jenifer Fischer Jenifer Fischer miamiu1981@aol.com 017339 22 2025-09-24 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. Wanting to wait until after her appt w/ Orth- sc Sonya C. 2025-09-24 15:06:02 -2.1 hrs 68bb047f6934e2f9849bfc38 000018883 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16803 f59419c501dcf3b77ca56c36802210129b3c5e2e34ae77908d1337ac9f0b1b26 68af45896d5d6587269ca23e 67ced37d7abf9f3ed8fe9a50 Eileen Graziani Eileen Graziani emg4294@gmail.com 005593 28 2025-09-24 Checked Out 68535c6303dd08c79c018795 John Reed 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-24 17:13:11 -0.0 hrs 68af45896d5d6587269ca23d 000017839 2.00 54.29 43.26 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16802 7ea98c5e807c0da4e4d90b65ae66f362f42b8d8230a420d25a8fd4e896fbbd77 68702f46c15eed8b1305ea1e 67ced47d7abf9f3ed8fed460 Kathleen Parrish Kathleen Parrish kmcgparrish@gmail.com 010546 37 2025-09-24 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Mark Leo Guevarra 2025-09-25 20:59:41 27.7 hrs 68702f46c15eed8b1305ea1d 000012548 4.00 129.55 129.55 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16801 d7ea2b4880211fb8ad86c3e0ca90b6f62f389d2222f1184eda5858bc3fc70399 68cc8990f9e6edd69d7aa62f 67ef0233bbf8e49115a4c312 Cindy Knaisch Cindy Knaisch cmknaisch@gmail.com 016983 56 2025-09-24 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2025-09-25 18:23:49 24.9 hrs 68cc8990f9e6edd69d7aa62e 000020261 3.00 89.70 119.70 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16800 9c150ddcb7af3298c291624541ef240c74042db0f6e4c41c7ecf56046f4a5e02 68af48f5b3461907e3ab5efd 682b4b4e58a15d07739d2f13 Jessica Rothman-Church Jessica Rothman-Church Jessie.rothman@gmail.com 017259 31 2025-09-24 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Anne Majewski 24+ sch conflict - sc Sonya C. 2025-09-18 20:14:36 -141.3 hrs 68af48f5b3461907e3ab5efc 000017849 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16799 5d7b5a7d76e5986db050379d24c69d636e88bef20d59cf0069a011049c512b95 68acbe43b5336a80a6e0fe91 687fbddf5e228bca59ccf349 James Macintosh James Macintosh jmacintosh01@gmail.com 017671 17 2025-09-24 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Michelle Osgood 2025-09-24 18:27:29 1.0 hrs 68acbe43b5336a80a6e0fe90 000017451 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16798 b888063af4ee897113e7e17ffeedebdfe3dc83d0c65c9f273f7cc7d7173cb3c0 68a391252db0500861e6d493 68a390322dac430785c21ed1 Serena Randolph Serena Randolph serena.randolph@gmail.com 017817 16 2025-09-24 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-08-19 20:15:47 -861.2 hrs 68a391252db0500861e6d48f 000016589 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16797 6d77a116583a59cebed20f78a0f5b826a006aa556608784e15c9402993feeb56 689a060fb45bd407f9bdc330 6890d6a0424398086b12d143 Whitney Flynn Whitney Flynn whitneyflynn@gmail.com 017746 6 2025-09-24 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. Moved appt out further Samantha Saunders 2025-09-23 14:40:19 -26.8 hrs 689a060fb45bd407f9bdc32f 000015894 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16796 f1014444ee9401fb171a68dbd0a8688efc5fd473f0a5494e3d67e42906a4f842 68a498a6482471cb585cf749 689f74cc6a0ec0080e404aa2 Gordon Laurens Gordon Laurens laurens_gordon@svvsd.org 017806 28 2025-09-24 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-24 18:00:28 0.3 hrs 68a498a6482471cb585cf744 000016686 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16795 27421fea5f170b7cf7d1703646c53aec5a321fd56199d81480f7f725e1defdce 689f7a3278e25cfc4eee0a3a 68795a5ffee8dab7b5b8263d Reba Kahlon Reba Kahlon rebaKahlon@hotmail.com 017648 11 2025-09-24 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-09-25 19:50:45 26.1 hrs 689f7a3278e25cfc4eee0a39 000016438 1.00 130.00 130.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16794 b56740b6cdee402d93285f3703ff347b68f9fdec28b4ee6073fb62d16c01362b 68acc7c942bd5f3bec1f409e 67ced3af7abf9f3ed8fea830 Lisa Haley Lisa Haley blueflamefx150@gmail.com 006777 133 2025-09-24 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Sophia L. 2025-09-24 18:01:19 0.0 hrs 68acc7c942bd5f3bec1f409d 000017465 3.00 -156.00 80.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16793 6b11ebea0343706e3a34cf55f4ac1d96937797a2106e7217af23a7f000532a82 68826ea3c10260083b1db91a 67e1258754aaaa3a80096bf7 Donna Leard Donna Leard djleard1@gmail.com 016709 21 2025-09-24 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Maia H. - Sophia L. 2025-09-24 18:01:13 0.0 hrs 68826ea3c10260083b1db919 000014244 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16792 793bfefc87b20834e00e48c3a831b84948c00168d57c240dc043f4ee4327ea2f 688a83c037f5b45dcdd2aecb 67ced2fa7abf9f3ed8fe6667 Richard Bolen Richard Bolen rbolen@centurylink.net 001164 166 2025-09-24 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-24 19:07:08 0.9 hrs 688a83c037f5b45dcdd2aec4 000014856 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16791 aa430a157b7e58da797b7859111ddaf4beabbc7c0afb108034635a142b5527f4 68c8516b4a4953cf9b9f77c2 67ced5d97abf9f3ed8ff0a15 Virginia Wadsworth Virginia Wadsworth vawads@gmail.com 015127 188 2025-09-24 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle Osgood - Rosey Reed 2025-09-24 18:14:27 -0.3 hrs 68f9035504292b09b3ac832e 000019788 2.00 55.92 55.92 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16790 63e491c4bed4eafff38663507f21ff28870802676b436aa4b2d4f5544324dab9 68c19f9ba8408322067459a9 67ced3a17abf9f3ed8fea497 Daniela Gaal Daniela Gaal dsg@boulder50.us 006470 54 2025-09-24 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Samantha Saunders 2025-09-24 18:35:34 0.1 hrs 68c19f9ba8408322067459a8 000019377 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16789 265d7b80412eb21b41c27c4a3fd3e48f9f2ae6ee695b8b6a53a812ae71297007 68af22a3fd4e04080d6eaf94 67e6654befbf2c53d8d5de52 Lindsay Goodrich Lindsay Goodrich lindsbg@gmail.com 016819 52 2025-09-24 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-08-27 15:23:54 -675.1 hrs 68af22a3fd4e04080d6eaf8f 000017732 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:09:51 2026-05-13 23:34:47
16788 aa639cf6f5a6b9bf2893a0bcd57176e110b5096ed1797982b47aa99aed6f2396 689f84d8b32aa320fc398897 67ced4767abf9f3ed8fed2fb Scott McGonigal Scott McGonigal mrscottmcgonigal@gmail.com 010427 41 2025-09-24 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-24 19:44:34 1.2 hrs 689f84d8b32aa320fc398891 000016453 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47
16787 9f6ff6fe6009d81388fb388607fb31c9ffc550adbf8ec95f66b0195a4cbd1fb6 689f45cb309d014c35019187 67ced5797abf9f3ed8fefd02 Theresa Simmons-Smith Theresa Simmons-Smith smithtess444@aol.com 014012 102 2025-09-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-09-24 19:01:40 0.5 hrs 6913c5868d8eaeaa924a5c4d 000016382 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:09:50 2026-05-13 23:34:47