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
29279 5efc905be5324058b9d3ff01790a7552d74a53a1f72bd3a1c8bdf7fb2ed7da9e 6838880d02af86fd2a961a93 67ced2f37abf9f3ed8fe61a5 Jennifer Cantrell Jennifer Cantrell jcantre@umich.edu 000758 46 2025-06-17 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Maia H. - Michelle W. 2025-06-17 13:30:05 -1.0 hrs 6838880d02af86fd2a961a92 000007434 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:32 2026-06-12 00:11:01
29278 31d898db10776b5ec822ef626e05ee5ffd3ab8fe6b960de38dfbc90f6174bd0c 68238144e3bc201d4a15d6aa 68237d1353b37f07b151f1a1 Rachel Zivony Rachel Zivony rachelczivony@gmail.com 017230 14 2025-06-17 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-06-09 20:42:36 -185.8 hrs 68238144e3bc201d4a15d6a9 000005390 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:32 2026-06-12 00:11:01
29277 78058cef46c95b710bc7bcd5b040d4b34ec0268ec64280c2e21c30d06db6e03c 6818d7867eb4175a1a31f65a 6818d53912928a77b3e5c37e James Stewart James Stewart scottincolorado@gmail.com 017175 5 2025-06-17 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Primary - - Yes Sonya C. - Ranjini Ridgway 2025-06-17 22:58:41 8.5 hrs 6818d7867eb4175a1a31f659 000004245 4.00 314.00 130.00 - - - - - - - - 2026-02-19 23:45:32 2026-06-12 00:11:01
29276 d526d366fa7c686d4f8b8ca436d126243dbcd3c6515284ec6403df19a1eeb6f7 6818d2f911f19177d56316de 67ced5967abf9f3ed8ff0104 James Stewart James Stewart iangecko26@gmail.com 014354 10 2025-06-17 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-05-05 15:20:18 -1031.2 hrs 6818d2f911f19177d56316dc 000004240 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:32 2026-06-12 00:11:01
29275 b11b316f887eecf76c0bd1a15375e7fab3599ed71a86d4d5699f0572e7ffada3 6807c5b6c1903c08921fda36 67ced4567abf9f3ed8feccf5 Margarita Delopez Margarita Delopez xelajuj@icloud.com 009913 124 2025-06-17 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Ranjini Ridgway 2025-06-17 16:34:59 2.1 hrs 6807c5b6c1903c08921fda2e 000003095 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:45:32 2026-06-12 00:11:00
29274 f98a9202d74fe9d948195ea5d5f04843e21dfc54f04331d692e28c183dfbc6f9 67e67339ceb9f104f029393f 67ced4547abf9f3ed8fecc88 Tandy Ortiz Tandy Ortiz tandyortiz@gmail.com 009877 11 2025-06-17 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Dawn Singleton 2025-06-17 14:30:00 0.0 hrs 67e67339ceb9f104f029393e 000152348 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:32 2026-06-12 00:11:00
29273 64951a2857a527684ae1d1f460043121c6d67b423df6899c68f0aa631841b476 67e67338ceb9f104f0293920 67ced5477abf9f3ed8fef598 Laura Rulon Laura Rulon lrulon@yahoo.com 013380 322 2025-06-17 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Gillian B. 2025-06-16 19:31:34 -19.0 hrs 67e67338ceb9f104f029391f 000152347 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:32 2026-06-12 00:11:00
29272 6e2a2631b2064e056c1433db451066d974b99560521772d2760b6571b0bd2dd4 67e67337ceb9f104f02938fc 67e6654befbf2c53d8d5de52 Lindsay Goodrich Lindsay Goodrich lindsbg@gmail.com 016819 52 2025-06-17 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Dawn Singleton - Sonya C. 2025-06-06 18:09:36 -260.3 hrs 67e67337ceb9f104f02938fb 000152346 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:32 2026-06-12 00:11:00
29271 d310066e97fa06c7f4a074b73b3fd9e2ea7e84fa7f3e288b62b9ea2548402616 684704ef2896c91e9d63d8f2 6847042a871ca6080763f8ec Jamie Pruett Jamie Pruett jamiepruett1@gmail.com 017416 6 2025-06-17 Cancel 683aa08158eaf318442499e4 James Fowlkes 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 6/16 Sophia L. 2025-06-16 15:50:21 -22.9 hrs 684704ef2896c91e9d63d8f1 000008702 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:32 2026-06-12 00:11:00
29270 68e9cb14d799c6668c837eefb5ecf76abc9329d03bc3355d72243a3624fffc64 6835e526abd9a6d722e77205 67ced4577abf9f3ed8fecd22 Frank Moritz Frank Moritz frank.moritz@comcast.net 009928 26 2025-06-17 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Michelle W. - Sophia L. 2025-06-17 14:41:30 -0.1 hrs 68546f7b91be1b07cdcacdab 000006940 3.00 235.00 0.00 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29269 583d8c199dc992d3e9768814cf4733b8e6c262716b74560b7040b6d3f7464559 681ccdefc65995082d877b00 67ced3407abf9f3ed8fe85c4 Jeffrey Beckerman Jeffrey Beckerman jeffmbeck@mac.com 003840 7 2025-06-17 Cancel 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24 + see note on log- sc Sonya C. 2025-06-09 15:51:37 -190.9 hrs 681ccdefc65995082d877aff 000004782 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29268 d19c441a3d7e3ccdeb91ae26fd61cf9d36b5d9709c2e1f479f7d5caa135ca7d1 681ccbb15ca61f926039584b 67ced3207abf9f3ed8fe78dc Susan Brown Susan Brown susanzvi@gmail.com 002739 85 2025-06-17 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67ab091753108089752a5 RTM READY 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Maia H. - Marguerite Barth 2025-06-17 14:48:22 0.1 hrs 6851933a0dce76d6d6a434d3 000004770 4.00 92.26 92.26 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29267 fa3f5594008a510e142ca03ec9a91b33877e37837fcbee0875efbf478b9961f6 68192f32cec4fd596eb1cb02 681924f2b2c8fc7022464a1f Michael Livesay Michael Livesay michaellivesay2@gmail.com 017179 44 2025-06-17 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-06-17 16:58:52 2.2 hrs 685ae98c79fdcb6ce0b16658 000004344 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29266 8285df87433e83da259440a15c41c4f18ece164df231e91c2d1366425489a484 67f579d14fa375f7c21167af 67f577e63ee87407ec781fd2 Donna McConnell Donna McConnell dgmac5950@gmail.com 017013 3 2025-06-17 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. 24 + see note on log- sc Sonya C. 2025-05-27 15:54:06 -502.8 hrs 67f579d14fa375f7c21167ae 000001505 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29265 248f7ff3a9c8afbc04a6670a211e26ddb16162af54559319ea1b2a272aafdfc8 6849eed3230f6807e32005ee 67ced33a7abf9f3ed8fe832c Jennifer Donahue Jennifer Donahue jenniferdonahue8@gmail.com 003619 30 2025-06-17 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. - Michelle W. 2025-06-17 13:55:59 -1.1 hrs 6849eed3230f6807e32005ed 000009080 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29264 07a4b4cdd4501fae1cf9b7ed06543638333ce3432e6fe7240d2fb26137dbee4f 682224afedea5208ade0d21d 67ced37e7abf9f3ed8fe9a92 Nathan Hawkins Nathan Hawkins fourhawkins@gmail.com 005615 32 2025-06-17 Checked Out 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Gillian B. - Sonya C. 2025-06-17 14:59:41 -0.0 hrs 682224afedea5208ade0d21c 000005193 4.00 95.95 95.95 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29263 86146efb3f8ed93a919cc80e69a951defa7a275ef7ee36e1b4eb71f218c93186 680131849259403d7282b51d 67ced49f7abf9f3ed8feda42 Rodolfo Perez Rodolfo Perez rudy.perez97@gmail.com 011048 115 2025-06-17 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Gillian B. 2025-06-17 15:10:30 0.2 hrs 680131849259403d7282b51c 000002604 3.00 81.96 81.96 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29262 faa4d5324aaee31a82ea570b3d0e1a52581f8f375fd5e9e276deadf5ab44877d 680121a69259403d72821f67 67ced3047abf9f3ed8fe6c13 Michael Botwinski Michael Botwinski mikejbot2@gmail.com 001648 33 2025-06-17 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Maia H. 2025-06-16 16:42:11 -22.3 hrs 680121a69259403d72821f63 000002592 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29261 aadd7f2ec178e0cfe32fd0a1610d13714c5342eaacff986379fe424387c04521 67fd2bb55b67e307ad220c58 67ced33a7abf9f3ed8fe832c Jennifer Donahue Jennifer Donahue jenniferdonahue8@gmail.com 003619 30 2025-06-17 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sophia L. - Michelle W. 2025-06-11 14:32:57 -144.5 hrs 67fd2bb55b67e307ad220c57 000002046 5.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29260 939a46343e7c593642ab3105cfccc6498ba87e80ba28d4d93cd249e45cbb3a6e 67e67337ceb9f104f02938dc 67ced3e67abf9f3ed8feb601 Nancy Knipe Nancy Knipe nknipe44@gmail.com 007956 201 2025-06-17 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Dawn Singleton Pt is ill today Sonya C. 2025-06-17 14:35:46 -0.4 hrs 67e67337ceb9f104f02938db 000152345 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29259 cded63d54232c89e9b07978e5032506929e2c1ef661771333c997376c90ea675 68507300a06e9707d1202907 67ced5057abf9f3ed8feeb78 Scott Schaefle Scott Schaefle sschaefle@hotmail.com 012516 22 2025-06-17 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Maia H. - Ranjini Ridgway 2025-06-20 18:50:40 75.6 hrs 68507300a06e9707d1202906 000009485 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29258 d334a200d5f72fff1bb42e10b04205e81e71bfb82e5402e4b9ac2584770bb862 68474483b76cee08235b0154 67f930bb1efdbe082144ceef Wendy Sewell Wendy Sewell wendysewell30@hotmail.com 017035 12 2025-06-17 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Ranjini Ridgway 2025-06-17 16:48:14 1.6 hrs 68474483b76cee08235b0153 000008770 4.00 95.55 95.55 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29257 ba0afdf15a05239e1a3f8c098232d56c8d1468ff51713c73b63e336d3813af56 682e106d632a440758379661 67ced4ca7abf9f3ed8fee1ba Suzanne Olin Suzanne Olin solin305@aol.com 011685 50 2025-06-17 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Samantha Saunders - Maia H. 2025-06-16 20:19:08 -18.9 hrs 682e106d632a440758379660 000006441 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29256 515fc2c12b0a32b914d53bca5f9d2bc64c6a886f64dc681ff4aa748042a1be4e 6827ad30ceddb607fc89cab6 67ced3ea7abf9f3ed8feb6e5 Andrew Kolbeck Andrew Kolbeck kolbeckag@gmail.com 008032 23 2025-06-17 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Gillian B. 2025-06-17 15:08:46 -0.1 hrs 6827ad30ceddb607fc89cab1 000005996 3.00 83.21 83.21 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00
29255 3dc79965aadb2b9d5c3f3bfb2fbf10116fc46d9ecff8bec5a5c95a9c4ed3740e 6807b71957843c07f79231b2 67ced3077abf9f3ed8fe6dd2 Joseph Dascomb Joseph Dascomb jdascomb89@gmail.com 001797 58 2025-06-17 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL6/2 Sophia L. 2025-06-02 16:21:49 -358.9 hrs 6807b71957843c07f79231b0 000003042 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:45:16 2026-06-12 00:11:00