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
58221 1de4f8a31f8c8922a1bccca85b0841dcc77ca0738279e9a64ff45f6d21253164 67d045b7bb4a7c061457f0f4 67ced5597abf9f3ed8fef84a George Shoning George Shoning shoning@gmail.com 013610 31 2024-10-23 New 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:16:22 3332.8 hrs 67d045b7bb4a7c061457f0f3 000069647 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:11 2026-06-11 01:23:26
58220 ca8d5f67ed5ffc380ae4fd95da55e1ffd19211cac152bfae0915a54898a1dbc3 67d045b6bb4a7c061457f0d5 67ced2ff7abf9f3ed8fe6985 Joyce Boothby Joyce Boothby joyceboothby@yahoo.com 001430 30 2024-10-23 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67cecf56790102035488b359 Pre-PtE Appt 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2024-10-23 17:30:00 0.0 hrs 67d045b6bb4a7c061457f0d4 000069646 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58219 23792be46705f0f51e19790ef91f904747c07383fc357210067da3d557df3380 67d045b5bb4a7c061457f0b6 67ced35f7abf9f3ed8fe9084 Sandra (Sandy) Gilmore Sandra (Sandy) Gilmore ddgilmore8@gmail.com 004757 18 2024-10-23 New 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:16:20 3332.5 hrs 67d045b5bb4a7c061457f0b5 000069645 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58218 5bf157916f957150fc354ac60bae08e2f0a83ec263be5e83f7c18aa324fb7913 67d045b4bb4a7c061457f098 67ced5527abf9f3ed8fef73c Lauren Sherman Lauren Sherman lauren.sherman@icloud.com 013520 47 2024-10-23 Cancel 67b50609f116540873418998 Carrie Schneider 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2024-10-23 17:45:00 0.0 hrs 67d045b4bb4a7c061457f097 000069644 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58217 96f4cafefc78a4a54f7833d70f78d0948dc2029bc9f585791b44abb8aed3bbc9 67d045b2bb4a7c061457f079 67ced59c7abf9f3ed8ff01ee Gregory Van Kempen Gregory Van Kempen gregrv@msn.com 014432 12 2024-10-23 New 67b50520db7c513ce9d80dd3 Daphne Ryan 67cecf56790102035488b359 Pre-PtE Appt 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:16:18 3332.5 hrs 67d045b2bb4a7c061457f078 000069643 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58216 f71ebb90fb129153da6f885184ac9f6dd8ce2cb62f662fc682593ba8dce69e67 67d045b1bb4a7c061457f05a 67ced59f7abf9f3ed8ff0257 Stanley Stjernholm Stanley Stjernholm bestjernholm@msn.com 014467 174 2024-10-23 New 67b50609f116540873418998 Carrie Schneider 67cecf56790102035488b359 Pre-PtE Appt 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:16:16 3332.5 hrs 67d045b1bb4a7c061457f059 000069642 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58215 2169c56074c16e2c5d1ea3acea814a1bde87629f97e8bc387da4ad9b03aff0d8 67d045b0bb4a7c061457f03b 67ced3c67abf9f3ed8feae18 Kevin Holtzclaw Kevin Holtzclaw holtzgard2@icloud.com 007281 46 2024-10-23 New 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:16:15 3332.3 hrs 67d045b0bb4a7c061457f03a 000069641 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58214 1ec3f4935e3410dbda4b46c5feb0d3b8a3e70255ecc7251bd96ef423fe662619 67d045afbb4a7c061457eeb9 67ced49e7abf9f3ed8feda33 Margaret Perez Margaret Perez perezmargaretlee@gmail.com 011043 131 2024-10-23 New 67ace27f67327b083edb451f Michelle Osgood 67cecf56790102035488b359 Pre-PtE Appt 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:16:14 3332.3 hrs 67d045afbb4a7c061457eeb8 000069640 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58213 ddb64949b3d8e86094aaa04eadd5331909c98618b734bba67bd5652a6b1e92f4 67d045aebb4a7c061457ee9a 67ced4927abf9f3ed8fed80e Constance Pechota Constance Pechota cbluep50@yahoo.com 010860 125 2024-10-23 New 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67cecf56790102035488b359 Pre-PtE Appt 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:16:13 3332.0 hrs 67d045aebb4a7c061457ee99 000069639 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58212 748fad43563a43cff99d834560f4ab634923adc7d51b65d3cc223b3edd25915d 67d045acbb4a7c061457ee7c 67ced4137abf9f3ed8febfa3 Jennifer Malm Jennifer Malm jen_s_malm@yahoo.com 008777 29 2024-10-23 New 679aeda44d561307f6600a43 Dawn Singleton 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:16:12 3332.0 hrs 67d045acbb4a7c061457ee7b 000069638 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58211 65def5c981572c2b29423f58b1a4d25e82874ab1ef4f79dfcb0962237710d750 67d045abbb4a7c061457ee5e 67ced4177abf9f3ed8fec075 Jane Manning Jane Manning jhmanning5@gmail.com 008847 90 2024-10-23 New 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:16:11 3332.0 hrs 67d045abbb4a7c061457ee5d 000069637 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58210 0c70afb0ecd780e7b7161ee6ed319c97d0f6832db3e4d47f039db4e123b26779 67d045aabb4a7c061457ee40 67ced2f97abf9f3ed8fe65e9 Mary Ann Bogner Mary Ann Bogner maryann.bogner@gmail.com 001122 11 2024-10-23 Cancel 67b50520db7c513ce9d80dd3 Daphne Ryan 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2024-10-23 18:30:00 0.0 hrs 67d045aabb4a7c061457ee3f 000069636 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58209 99f1669a48cdca605f890beccba35efae1ffba4b3018e5c72d7a3b137cc3113d 67d045a9bb4a7c061457ee21 67ced42e7abf9f3ed8fec51c John Miranda John Miranda flymiranda@gmail.com 009244 113 2024-10-23 New 67b50609f116540873418998 Carrie Schneider 67cecf56790102035488b359 Pre-PtE Appt 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:16:08 3331.8 hrs 67d045a9bb4a7c061457ee20 000069635 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58208 d52810339f16385a744fb158aa4c71a0e6dd69b14a61c54248ee29ffdfac5f2f 67d045a8bb4a7c061457ee03 67ced3397abf9f3ed8fe82f0 Jonah Bastow Jonah Bastow bastow.jonah@gmail.com 003599 9 2024-10-23 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2024-10-23 18:30:00 0.0 hrs 67d045a8bb4a7c061457ee02 000069634 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58207 920b58a238ef3d9e3543b6a8fc04174f849b22a62032d2d7385e937d6b78dab0 67d045a7bb4a7c061457ec82 67ced3a47abf9f3ed8fea52d Judith Herr Judith Herr judithjherr@gmail.com 006520 5 2024-10-23 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2024-10-23 18:30:00 0.0 hrs 67d045a7bb4a7c061457ec81 000069633 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58206 c7d22d85a1e111b9398f74d344aedad43c9ca582dd19d8554ba3801ecb9eb3e7 67d045a6bb4a7c061457ec64 67ced3517abf9f3ed8fe8bfb Johnny Esparza Johnny Esparza johnnyesparza24@gmail.com 004370 41 2024-10-23 New 67a29eb59b66fa59fd5c2663 Samantha Saunders 67cecf56790102035488b359 Pre-PtE Appt 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:16:05 3331.8 hrs 67d045a6bb4a7c061457ec63 000069632 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58205 245aef7245a4fb361477c0088c64b0be331337eb092ce0901337feb850183588 67d045a5bb4a7c061457ec45 67ced2e77abf9f3ed8fe5974 Inger Bell Inger Bell ingerbell13@gmail.com 000059 8 2024-10-23 New 67a3c1c3d8b9514e4335442c Miranda Samson 67cecf56790102035488b359 Pre-PtE Appt 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:16:04 3331.8 hrs 67d045a5bb4a7c061457ec44 000069631 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58204 489ba07c07a55459506ecf65dc12fedf0865e9a467dd7dcdcd291620373d8c8a 67d045a3bb4a7c061457ec27 67ced5107abf9f3ed8feed28 Judylynn Schmidt Judylynn Schmidt hellojudylynn@gmail.com 012660 12 2024-10-23 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2024-10-23 18:30:00 0.0 hrs 67d045a3bb4a7c061457ec26 000069630 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58203 7d10f99b6df4929b46596554322e0efc2fda8eb25ebfee9aba4a8fb707593b26 67d045a2bb4a7c061457ec09 67ced4ad7abf9f3ed8fedcd3 Nancy Peterson Nancy Peterson nancyp100@msn.com 011267 12 2024-10-23 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2024-10-23 18:30:00 0.0 hrs 67d045a2bb4a7c061457ec08 000069629 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:26
58202 f1b3a52e2b82121b87f508135d39c69711cde84d814a0dc8998e03ef49d84c11 67d045a1bb4a7c061457ebeb 67ced31b7abf9f3ed8fe7765 Brett Bader Brett Bader brettwbader@gmail.com 002614 31 2024-10-23 New 679aeda44d561307f6600a43 Dawn Singleton 67cecf56790102035488b359 Pre-PtE Appt 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:16:00 3331.8 hrs 67d045a1bb4a7c061457ebea 000069628 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:12
58201 8223410870bd5b97b1f68dc062aadf072d7606ef6c20203e4761b118319e5ad5 67d045a0bb4a7c061457ebcd 67ced57d7abf9f3ed8fefd9b Carol Simonson Carol Simonson robair1026@gmail.com 014063 59 2024-10-23 Cancel 67b50609f116540873418998 Carrie Schneider 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2024-10-23 18:30:00 0.0 hrs 67d045a0bb4a7c061457ebcc 000069627 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:12
58200 b887fad365c359cf5060412356c8d09c7bf245e900cc1fa3a3d9ed000e818c99 67d0459fbb4a7c061457ebae 67ced49e7abf9f3ed8feda33 Margaret Perez Margaret Perez perezmargaretlee@gmail.com 011043 131 2024-10-23 New 679aeda44d561307f6600a43 Dawn Singleton 67cecf56790102035488b359 Pre-PtE Appt 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:15:58 3331.5 hrs 67d0459fbb4a7c061457ebad 000069626 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:12
58199 bccc84de537312e7fd29f45d5672c874e7d2574a1751a47e717dd19209a42435 67d0459ebb4a7c061457eb8f 67ced4547abf9f3ed8fecc8b Johnny Morgan Johnny Morgan johnnymorgan1@mac.com 009878 31 2024-10-23 New 67ace224d9ba6008ac94ea05 Stephanie Braun 67cecf56790102035488b359 Pre-PtE Appt 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-03-11 14:15:57 3331.5 hrs 67d0459ebb4a7c061457eb8e 000069625 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:12
58198 469bb65a8bf1685392bd6093f2e178d861439e30d9c478c5c7f04de8fc77089a 67d0459dbb4a7c061457eb70 67ced3487abf9f3ed8fe8867 Lois Edgar Lois Edgar edgar@colorado.edu 004065 236 2024-10-23 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67cecf56790102035488b359 Pre-PtE Appt 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2024-10-23 19:00:00 0.0 hrs 67d0459dbb4a7c061457eb6f 000069624 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:12
58197 8f13169b4e425cf6267ae2990dd15e887d9f9ec41a025183ffbd296e73808096 67d0459bbb4a7c061457eb51 67ced4f47abf9f3ed8fee8ad Carol Rhode Carol Rhode juneau1601@gmail.com 012278 172 2024-10-23 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67cecf56790102035488b359 Pre-PtE Appt 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2024-10-23 19:00:00 0.0 hrs 67d0459bbb4a7c061457eb50 000069623 0.00 0.00 0.00 - - - - - - - - 2026-02-20 01:04:10 2026-06-11 01:23:12