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
28266 f502e5fb071ea5ec0bd3b4c3fb17373afa74b66e04e62bf717b2fae43c98fe30 6838b4c0c26a4f078dc1a819 67ced2f17abf9f3ed8fe6094 Leonard Aitken Leonard Aitken laitken16@gmail.com 000667 23 2025-06-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Gillian B. - Rosey Reed 2025-09-30 17:24:34 2351.9 hrs 6838b4c0c26a4f078dc1a817 000007492 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28265 9021a598e83640c507b7a48e8819155d7464721f20c0e59b0215adcbfdeb6bbe 68387712aec4ff75e03d635f 683875e39c35ce07e0f71fc9 Julia Moritz Julia Moritz julia.moritz@gmail.com 017334 11 2025-06-24 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Secondary - - Yes Sonya C. - Ranjini Ridgway 2025-07-01 00:11:26 150.7 hrs 686327b935a086ae7fc9d43b 000007403 3.00 60.00 60.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28264 5b028168200c74904859c25a1ded362010f2ff87a295f6f74ab4e7b931acb19a 682663fa674289079c7447f0 67e66523efbf2c53d8d5d814 Christina Dubois Christina Dubois chrisnosa@gmail.com 016812 41 2025-06-24 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-06-24 20:42:26 3.2 hrs 682663fa674289079c7447ef 000005881 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28263 57a755061bde52fc9385e090fac5fe770fa6c1d918aa4cdb0eb63e57b77ed0d0 6813c1d9fd232ad3b1119395 67ced6407abf9f3ed8ff176a Kit Wise Kit Wise kitwise@comcast.net 016264 63 2025-06-24 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Maia H. - Maia H. 2025-05-15 18:37:19 -958.9 hrs 6813c1d9fd232ad3b1119394 000004071 6.00 0.00 0.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28262 3f6611488ee7ae4fc705700f9e6d1a0715e5bc2b6ab7d0579ded5850fb31c24a 68127e7f4353985b26b99c3d 68127d6a537775e74c908b1a Lionel Wynn Lionel Wynn lionel.wynn@gmail.com 017161 6 2025-06-24 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-06-24 20:53:50 3.4 hrs 68127e7f4353985b26b99c3a 000003994 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28261 d34604a8cb2c1ee45e0abef2afd4c1eedf4a1247fb39e5744c91eaf0e254ecc0 6806c213aae19e0809e07ce9 67ced4547abf9f3ed8fecc8b Johnny Morgan Johnny Morgan johnnymorgan1@mac.com 009878 31 2025-06-24 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. patient has a conflict with time SB Stephanie Braun 2025-06-03 18:53:20 -502.6 hrs 6806c213aae19e0809e07ce8 000003000 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28260 c479fea0c6b253203914de88ba5fe0cf19ab6aca4f1aa9d564aa2698898669a9 67e672ddceb9f104f02920c5 67e66588efbf2c53d8d5e5d0 Christopher Jonaitis Christopher Jonaitis chrisj152@gmail.com 016830 4 2025-06-24 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Dawn Singleton - Michelle W. 2025-05-29 16:47:42 -624.7 hrs 67e672ddceb9f104f02920c4 000152209 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28259 c985297f5c3f0f965d860bc05815f35e427098129fb2943d91539d2848e95c99 67e672ddceb9f104f02920a6 67ced2ed7abf9f3ed8fe5d37 Patricia Beumer Patricia Beumer patty1@beumerfamily.com 000380 818 2025-06-24 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Dawn Singleton - Sonya C. 2025-06-24 17:27:45 -0.0 hrs 67e672ddceb9f104f02920a5 000152208 2.00 59.50 59.50 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28258 763a2b4ab15b1c149b7b55cfe5bc35c20cce65eff8908815bcd4d45a08cfb887 67e672dcceb9f104f0292084 67ced2f97abf9f3ed8fe659b Barbara Boettcher Barbara Boettcher barbaralettieri1@gmail.com 001096 40 2025-06-24 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Gillian B. 2025-06-24 13:55:35 -3.6 hrs 67e672dcceb9f104f0292083 000152207 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28257 d482ee16cc330969678db3fe265fdf2c7489e0494e41a6f4f457738603ff2035 67e672dbceb9f104f0292062 67ced4a37abf9f3ed8fedaf3 Margaret Melville Margaret Melville garetmelville@gmail.com 011107 77 2025-06-24 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton 24 + see note on log- sc Sonya C. 2025-06-09 20:37:48 -356.9 hrs 67e672dbceb9f104f0292061 000152206 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28256 f46bd59932d5ec9da90f489afbc1e5795cd919bdd8028b095c603a9bbe4a3c1e 68193539e6e2681a9e43cf66 67ced53c7abf9f3ed8fef3d9 Lauren Sessions Lauren Sessions sessions.lauren@gmail.com 013231 189 2025-06-24 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia Phillips 2025-06-24 17:59:05 0.2 hrs 68193539e6e2681a9e43cf65 000004357 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28255 a6ad7f48ce99013dfe12ed52012403c4605bfd1b20ddae570b3ff7de9f26f0bd 67eade46d9abaf4bbec47532 67ced37e7abf9f3ed8fe9a80 Amelia Greacen Amelia Greacen mollygreacen@womanmedicine.com 005609 100 2025-06-24 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Gillian B. 2025-06-24 17:45:07 0.0 hrs 67eade46d9abaf4bbec47531 000000490 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28254 2eefa2078a2b6abff8049b0b7599b13324f478e9e0d1be6286c084f6d68d50d8 6813b1a8ea38b7081b84d12e 67ced6627abf9f3ed8ff1baf William Zuromski William Zuromski bjzuromski@yahoo.com 016628 37 2025-06-24 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Elizabeth Cousins 2025-06-26 04:10:04 34.2 hrs 6813b1a8ea38b7081b84d12d 000004067 3.00 235.00 45.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28253 1107dda1b1ef52f4fdb6e966676464aec72643a8fc84f58f3ad88342c6b0bc14 68111cb648baf90789954e18 67f5832cf7a3096c7860ce3e Barbara Bock Barbara Bock barbarabock8@gmail.com 017015 57 2025-06-24 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Ranjini Ridgway 2025-06-24 20:58:05 2.7 hrs 68111cb648baf90789954e17 000003822 2.00 60.00 60.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28252 3bb8e9b00f38769a5c5e2a57c7e3a72fb0cacaca791eb0ebc0fc1b28de676c0a 67e672dbceb9f104f0292040 67ced3fe7abf9f3ed8febb36 Marcia Larson Marcia Larson larson4045@gmail.com 008400 53 2025-06-24 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton 24+ pt conf cxl SL 6/10 OOT Sophia L. 2025-06-10 19:18:10 -334.9 hrs 67e672dbceb9f104f029203f 000152205 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28251 8d8e86c1fcf76266056eed840f4f17512a4ff7b2491fe72c3c593e1b67aa8a9f 67e672daceb9f104f029201e 67ced5547abf9f3ed8fef77e Kate Shew Kate Shew kateshew28@gmail.com 013542 49 2025-06-24 No Show 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Terri Nishimoto 2025-07-02 05:08:38 178.9 hrs 67e672daceb9f104f029201d 000152204 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28250 3ef14f8bc11842aeff9983bb73d45f8f5bbcd9b26fea26e8ce7a1235957cd008 685af0d6ed8e540800918c71 67ced6087abf9f3ed8ff102e Kathleen Thomasson Kathleen Thomasson kathykthomasson@yahoo.com 015647 28 2025-06-24 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Elizabeth Cousins - Sophia L. 2025-06-24 19:05:12 0.6 hrs 685af0d6ed8e540800918c70 000010545 3.00 81.40 81.40 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28249 da7facef8871514f10017c156e79c9853787411c24d0ebe839f5624e662866cb 685ad9015f0a5d130b2a67ca 67ced2fa7abf9f3ed8fe6667 Richard Bolen Richard Bolen rbolen@centurylink.net 001164 166 2025-06-24 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-06-24 19:33:07 1.1 hrs 685ad9015f0a5d130b2a67c9 000010515 2.00 57.06 57.06 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28248 e9d523c6f648f4808b1259028b8a35e1ba7896e568762cd64639aa2e65998a1e 685ad820df2ecadef1208f5a 67ced32c7abf9f3ed8fe7d92 Shaun Diaz Shaun Diaz info@shaunpaul.com 003141 38 2025-06-24 Cancel 683aa08158eaf318442499e4 James Fowlkes 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Gillian B. 2025-06-24 18:11:14 -0.3 hrs 685ad820df2ecadef1208f59 000010514 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28247 0eb65a1e1d691315384f424cd388f17476e9c8386ea124474bdc75bebe0476e2 685432dbe49033788d9a3810 67ced2f67abf9f3ed8fe6406 Charlene Bloom Charlene Bloom cbloom11@gmail.com 000961 97 2025-06-24 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Samantha Saunders - Maia H. 2025-06-24 18:57:10 0.5 hrs 686c61fb7aaf902c11835855 000009918 4.00 165.31 165.31 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28246 d3e57a47d9cb25f7dd49250693ac90189366018cf1d260342f631dc1032c7141 6847027cadfc6289e4425060 6847020a81e9a72d58089713 Maria Maldonado Maria Maldonado mjm80504@gmail.com 017415 5 2025-06-24 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. - Gillian B. 2025-06-17 17:01:07 -169.5 hrs 6847027cadfc6289e442505f 000008691 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28245 8edb2400059caf50ce63dfe3d68d3e6d599ba1a862365ad3ee82286b34a17708 6841b4d741546d0bc9743ba6 67ced3867abf9f3ed8fe9ce4 Jennifer Franka Jennifer Franka jenny.franka@comcast.net 005813 28 2025-06-24 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Elizabeth Cousins 2025-06-26 03:36:25 33.1 hrs 685cc059ae6bf5863c3b3074 000008399 4.00 95.00 150.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28244 3cd449e5e80fa7e70984b244ce6fb3115996a965742d9e4d58f2492092260fa4 683f2cb5901a6124dfe767af 683f275d1f7f130770edaf40 Michael Andrews Michael Andrews mikeandrews0802@gmail.com 017374 8 2025-06-24 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Gillian B. - Ranjini Ridgway 2025-06-26 15:03:57 44.6 hrs 683f2cb5901a6124dfe767ae 000007927 2.00 80.00 80.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28243 b1a865c62929aef7d42ffd4e8eea9059270b5929ea6d8e33f16df950d67ffca7 681e44bf28eb5fff267a927c 67ced2f47abf9f3ed8fe62a4 David Alessi David Alessi dalessi1011@gmail.com 000843 79 2025-06-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sophia L. - Maia H. 2025-06-24 19:16:40 0.8 hrs 681e44bf28eb5fff267a927b 000005053 3.00 83.09 83.09 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22
28242 a91b1a81e9540ee8547b66cc4323ccf3ff5dcdbb662ad19457206aceeafb2359 681cc106fe6c436d06f285f7 67ced4287abf9f3ed8fec402 Fay Marshall Fay Marshall fmarshall27@gmail.com 009150 9 2025-06-24 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sophia L. 2025-10-06 21:32:48 2499.0 hrs 681cc106fe6c436d06f285f6 000004746 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:42:25 2026-06-12 00:08:22