General Visit (PT Boulder API)

Total rows: 100,569
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
10489 d07b116c8a9cefb6b714aa42e1deb3ef02fc5c5b0696cf8119b6096c8e49c9ca 68b8ba695dfa410455909a65 67ced34c7abf9f3ed8fe89d9 Heather Elzinga Heather Elzinga helzinga15@gmail.com 004188 62 2025-11-17 Cancel 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 10/15 Sophia L. 2025-10-15 22:25:19 -790.1 hrs 68b8ba695dfa410455909a63 000018635 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10488 9dd81a3f23070c427ec444f517d25450644b54259a98fd0c96f1ae3ad6600322 68a8b8fbaa868ee18597f4c3 67ced3b57abf9f3ed8fea9d4 Carrie Hillman Carrie Hillman carrietimhillman@gmail.com 006917 38 2025-11-17 No Show 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Rosey Reed 2025-11-17 21:17:55 0.8 hrs 68a8b8fbaa868ee18597f4c2 000017287 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10487 dfcb282e22ec54e39f661f8cbaf5c5b38a10ae247adbf6118891d3d6af5f4b55 68f7ea45449f0409ebe76227 68c32c9176aa2268b2fc29b5 Madeline Burns Madeline Burns maddiburns63@gmail.com 019843 14 2025-11-17 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Sonya C. 2025-11-17 20:47:00 0.0 hrs 68f7ea45449f0409ebe76226 000024287 3.00 94.80 94.80 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10486 17dea5aa53263573f55fcd5fc9fdb2f0c0656b7da9289f035bdcf75bdf10bce8 68e94a9a967404094b3280e0 68e94953fb957d093a4bf16e Dave Laub Dave Laub dlaub72@gmail.com 020046 11 2025-11-17 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-11-17 20:38:21 -0.1 hrs 68e94a9a967404094b3280db 000023083 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10485 4a7cc9ec582ebb77a8ff8da852136fe44073a9a522b71756157f271923ad09be 690246ac28c0ae8cca237b9e 67ede8c1260f06f8faa3f3b0 Teresa Baldwin Teresa Baldwin campdpg5619@gmail.com 016971 44 2025-11-17 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Rosey Reed 2025-11-17 21:10:39 0.2 hrs 691e3ba8f96f06dfa67b6a56 000025234 3.00 130.00 130.00 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10484 d618efd6a29e9ed007a9be2f93ae79f7fee76f73356944109c00dad3a40da84f 68e6d1192dc66d08b89c178e 67ced36d7abf9f3ed8fe953d Lorina Goodrich Lorina Goodrich lori.goodrich66@gmail.com 005160 28 2025-11-17 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-17 20:55:01 -0.1 hrs 68e6d1192dc66d08b89c1789 000022822 4.00 95.71 95.71 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10483 1d639df9d8cbaf4efd770bfc0663c6df803b98af4e6b7aee064592b740409340 68ddae107f9a1f8bdf26ad2b 6863f90f10b0f90876859428 Jennifer De Julio Jennifer De Julio jendejulio@msn.com 017553 14 2025-11-17 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-11-19 21:00:17 48.0 hrs 691e516cdda00b5c9e043857 000021960 4.00 99.69 89.69 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10482 afd01cc8c580c079081a8f2e83942eada5a2bd94f5acb59d8dd656cb9fc3a27e 68dd7840167a7afac63fc8e1 67ced2fa7abf9f3ed8fe6667 Richard Bolen Richard Bolen rbolen@centurylink.net 001164 166 2025-11-17 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-17 20:59:52 -0.0 hrs 68dd7840167a7afac63fc8d8 000021904 3.00 80.26 80.26 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10481 87ae73aa6cf890656282609a33aba8b5d5d289a3130e7665e0ed216157b9a6d8 685d6df47d774308254c3617 67ced6167abf9f3ed8ff1218 David Weiss David Weiss davidlinda_weiss@msn.com 015810 71 2025-11-17 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Sonya C. - Rosey Reed 2025-11-17 21:09:21 0.2 hrs 691e0b5b2978589494c710bf 000010904 3.00 83.09 66.20 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10480 b6cf47be9ed5896dc610bf0f77ac309d68a29a715dda6508ab4cbce37715589e 68f008e8afb0d3aea0024e53 68f00739f8d92b00e83a66c2 Wendy O'Connor Wendy O'Connor wendyohh54@aol.com 020079 18 2025-11-17 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sonya C. - Sophia L. 2025-11-17 21:08:06 -0.1 hrs 695e783682293c1594b88b68 000023663 3.00 83.24 78.24 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10479 7148c3c7517be237336c3cf4b93b46fd29cbc6ab403bd55830515cedbe16d8d4 68ed62892c60098c00f8b1d4 67ced5a37abf9f3ed8ff02d8 Aaron Stoddard Aaron Stoddard builderaaron@hotmail.com 014510 125 2025-11-17 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Kenneth Dave Francisco 2025-11-19 19:38:40 46.4 hrs 691b97c77a968dd28f3dabb3 000023230 3.00 85.00 105.00 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10478 bc1f8b1f14bf21908c0ad705ff4555fdb6c8e704c41fc0f06d72590928007db7 68912672fbdfc807c1b579da 67ced4f47abf9f3ed8fee8ad Carol Rhode Carol Rhode juneau1601@gmail.com 012278 172 2025-11-17 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-11-17 22:10:35 0.9 hrs 68912672fbdfc807c1b579d3 000015330 3.00 81.40 81.40 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10477 149dd446a86bdf80772bb394fc36b6371dacf46eca6640d3efb522af91aa0d27 68f11fe6dc4db909a24a309a 6896481e1d2a819c6a62a428 Katherine Lightfoot Katherine Lightfoot katie.lightfoot@colorado.edu 017771 44 2025-11-17 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Rosey Reed - Mark Jerome Para-ase 2026-03-09 18:09:20 2684.7 hrs 68f11fe6dc4db909a24a3099 000023750 3.00 237.00 30.00 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10476 737ce0fd363f7673a6a47308180807b1c8dbb02d61acac61a97ec8ed8efad457 68efd703dd7f56985c8d276d 67ced5f27abf9f3ed8ff0d51 Ralph Wappel Ralph Wappel rwappel@gmail.com 015403 38 2025-11-17 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-17 21:44:44 0.2 hrs 68efd703dd7f56985c8d2769 000023608 2.00 53.22 53.22 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10475 b346656d1121b0822a6aac968d39fc0528bfb8f3485ff52557b209a98539c41c 691b5c2dd7be2a8bc49e8ede 67ced50e7abf9f3ed8feece0 Amy Schlotthauer Amy Schlotthauer harmshauer@hotmail.com 012636 45 2025-11-17 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-17 21:40:59 -0.1 hrs 692a27a795ed1c500b5b15c2 000027377 3.00 77.82 77.82 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10474 75372d27c4a4aeb52b82ed80882e78106fad8ea6610e75b7c7a05fa7029e810f 6904d7f571ea290a50629042 67ced56f7abf9f3ed8fefb79 Mary Ellen Steele Mary Ellen Steele maryellen.steele@gmail.com 013881 236 2025-11-17 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 2:27pm, cxl'd appt due to car being in shop - sc Sonya C. 2025-11-17 21:28:08 -0.3 hrs 6904d7f571ea290a50629041 000025547 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10473 c289a5d53c4efdb3cc708b2ca3984650059fc2a01fd4035503faec40fecd30bd 68fba6d1df9ca66caf09e0d9 689fa80c4166f3085448cb86 August Allen August Allen augustallen4@gmail.com 017812 15 2025-11-17 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Kenneth Dave Francisco 2025-11-19 19:41:53 45.9 hrs 68fba6d1df9ca66caf09e0d8 000024723 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10472 53b91461327b3d03066dcf6f7bbd572d97fd9bb73cc0c349151f791ec0a6e114 68eebe447570dd04ec0a23ff 68eebcaa30f77d0ef9f08be6 Theresa Koch Theresa Koch theresa.koch@comcast.net 020068 7 2025-11-17 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-11-19 19:27:41 45.7 hrs 68eebe447570dd04ec0a23fa 000023460 4.00 95.64 95.64 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10471 4b2c6cf5ddeb7d300c05d8aef339afad106de5323ee1e78e9207840ae00933c9 68e595418b2be4cde2f7c644 68e593f3378657c7b3f7194e Penny Ann Carlisle Penny Ann Carlisle pennyacarlisle@hotmail.com 020012 8 2025-11-17 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Jayson Encarnacion 2025-11-19 21:20:30 47.6 hrs 68e595418b2be4cde2f7c641 000022687 1.00 130.00 130.00 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10470 d182db6e22a1d30bb94e726aa3dba278dfec4cf67afc7a2250ad6462afb8a881 68f7c85e5f5782f2c3497d08 68f7c62388ff4e8c9079da79 Griffin Maxwell Griffin Maxwell ashleybuck66@gmail.com 020113 48 2025-11-17 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-17 22:03:35 0.1 hrs 68f7c85e5f5782f2c3497d07 000024238 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10469 3bcc149c5286263300249284f423bffe2792781a3d046878267bcf272b4874ce 68d5570e50ec630905c80b7a 68752052c763f808867f129e Glenda Dye Glenda Dye gdye.1937@gmail.com 017622 12 2025-11-17 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. <24 pt sick - RAR 11/17 Rosey Reed 2025-11-17 15:53:22 -6.1 hrs 68d5570e50ec630905c80b76 000020967 1.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10468 c959741203644050a3cd3226b74586b2b4b2b29d055fa310e39bb394feec2f9b 68b7728d40f54d21c351f3be 67ced4587abf9f3ed8fecd4f Taylor Osgood Taylor Osgood tsosgood@gmail.com 009943 117 2025-11-17 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. pt conf cxl SL 11/17 - work conflict Sophia L. 2025-11-17 22:05:05 0.1 hrs 68b7728d40f54d21c351f3b2 000018453 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10467 0b2a1e0db46f36533ce92c066a2e4ba18ffe2406c7109a2a437c69ca2d773a94 68a3a286cdbe8b7ce82c214c 67ced3757abf9f3ed8fe97cb Janet Hart Janet Hart janethart80301@icloud.com 005378 167 2025-11-17 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Sonya C. - Rosey Reed 2025-11-17 22:00:21 0.0 hrs 68a3a286cdbe8b7ce82c2142 000016619 3.00 81.40 64.85 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10466 6e8811eb02cf6c96d04c7edd503c12ee1fac5fc79aee3136b8d1721752ce0f2e 68f80bd8c4d22c0a4a973272 68f80ab3b70131fb13ed89f4 Diane Main Diane Main di_main@yahoo.com 020119 7 2025-11-17 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Michelle Osgood 2025-11-17 22:41:50 0.4 hrs 691e3cd5594776904baa6d7b 000024329 3.00 63.83 63.83 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33
10465 a3aa73170134e0b90192adff3be816cacf9b35582bae14e24179539681f5920c 68f6b16c854d30096ad52faa 68a8153699c65c4a78a5fa31 Charles Izurieta Charles Izurieta charles.izurieta@gmail.com 018691 18 2025-11-17 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. - Sophia Phillips 2025-11-14 18:30:43 -75.7 hrs 68f6b16c854d30096ad52fa9 000024121 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:51:27 2026-05-05 23:17:33