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
4226 27903dea44a7009673fd0078e05ffe85a0ff0d2a320c87253e658b21073648a7 69553f356ee7d1ebd0538b0e 67ced3747abf9f3ed8fe9777 Lynn Flynn Lynn Flynn lynnflynn@aol.com 005350 35 2026-01-15 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. eye surgery Emily Pickner 2026-01-08 14:32:00 -175.7 hrs 69553f356ee7d1ebd0538b0d 000032169 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:35:33 2026-06-11 23:08:16
4225 65a7b815a150164f478dd84c154b4a2d91606870e503290dd9b9960d9c96b7eb 6931fcd7273edc93ae761bae 67ced4137abf9f3ed8febfa3 Jennifer Malm Jennifer Malm jen_s_malm@yahoo.com 008777 29 2026-01-15 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2026-01-19 19:09:38 92.9 hrs 696fa03ed5b87eb6de1c6cf5 000029721 2.00 56.25 95.00 - - - - - - - - 2026-02-19 22:35:33 2026-06-11 23:08:16
4224 a6eb48c0b9438ca773998c17a61527632ded97f64ea12a45af7fa683c9dd45aa 69248c47c3170eebeed806bf 69248aea0027299caf552f3b Dmitry Duplyakin Dmitry Duplyakin dmitry.duplyakin@gmail.com 020294 11 2026-01-15 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-11-24 16:53:49 -1253.4 hrs 69248c47c3170eebeed806bc 000028167 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:35:33 2026-06-11 23:08:16
4223 f948526c0df3eaddefb9d6919d61747fa832acc08a6acb9b7667f7d6a344eb8d 691f9ff29103d279d2bb77f0 67ced53a7abf9f3ed8fef39d Alana Rubinsky Alana Rubinsky rubinskyalana@gmail.com 013211 28 2026-01-15 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2026-01-19 19:03:23 92.8 hrs 691f9ff29103d279d2bb77ef 000027970 1.00 130.00 240.00 - - - - - - - - 2026-02-19 22:35:33 2026-06-11 23:08:16
4222 f958c7b7b433b40e2a68dfbbf8621d59133ae5dea2791ba7c5c55539d7197cd9 690d198f8a823a0e05d5a784 686bf16e1e0d1308a320eb1b Joan Simon Joan Simon jsphoto2020@comcast.net 017576 18 2026-01-15 Cancel 67acc4530db5de07addc9873 Anne Majewski 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ Wanted to schedule for March instead. -RC Renee Carr 2026-01-09 22:30:03 -143.7 hrs 690d198f8a823a0e05d5a783 000026350 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:35:33 2026-06-11 23:08:16
4221 2754b3e885c18b4114122cb484b7af931cca8ccc303544d2a1f5dddacf98348f 690bbd2b38e93021b370f221 68c305022f90278f35c47313 Glenn Lieberman Glenn Lieberman glennlieberman@gmail.com 019841 17 2026-01-15 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ per email request work conflict - LS Laura Sage 2026-01-14 20:31:59 -25.7 hrs 690bbd2b38e93021b370f220 000026182 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:35:33 2026-06-11 23:08:16
4220 b6950e71a841690d8fcc3dc023d7635f5bb67bd43b9af6680dec55910b7b4f42 690113ca458ab9097f383505 67ced4d17abf9f3ed8fee2dd Nancy Pottoff Nancy Pottoff npottoff@hotmail.com 011782 539 2026-01-15 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Rosey Reed - Sophia L. 2026-01-15 22:22:10 0.1 hrs 696e68b76e7ea615648738fa 000025084 2.00 153.00 0.00 - - - - - - - - 2026-02-19 22:35:33 2026-06-11 23:08:16
4219 48005f4e8f1b164d5087a5396ef8376bfb347f8e0ac363e37c7f6c4d62dacaa3 6952cc2e84cce62f46a7ecc4 67ced3957abf9f3ed8fea13a Patti Guilford Patti Guilford pguilf@comcast.net 006183 98 2026-01-15 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Mark Jerome Para-ase 2026-02-06 17:44:12 523.2 hrs 6986288ed891fb9d4cb010ea 000031865 4.00 171.81 241.81 - - - - - - - - 2026-02-19 22:35:33 2026-06-11 23:08:16
4218 ca1a66a70c3ac6a60cda2da808da5d9d2d607fdefaadcca5e027d5d5ced6ec33 69583a5bf45363fa445d7fe3 6841aa31b8acb3e79c1936ed Michael Spratt Michael Spratt mspratt911@gmail.com 017393 40 2026-01-15 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Laura Sage 2026-01-15 22:40:00 -0.1 hrs 69583a5bf45363fa445d7fe2 000032359 3.00 82.36 82.36 - - - - - - - - 2026-02-19 22:35:33 2026-06-11 23:08:16
4217 0e41898514a4e0573cf652c12ce595e2e003bb17465e96c5a4f12793c7e3722e 69496f5922b29a4babd8c04c 69496f4cc314e107b632f3bf Sara Castellano Sara Castellano secastellano@gmail.com 020401 7 2026-01-15 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia L. - Sophia L. 2026-01-15 22:38:13 -0.1 hrs 696e6ae1d7b509c3c9bb835d 000031457 2.00 63.96 58.96 - - - - - - - - 2026-02-19 22:35:33 2026-06-11 23:08:16
4216 a4f280d04b29cd9e85ef836aec007b16a78a0107f099d1b063d6c1bed99bbe0e 690cd41ba3b3df9f37b95e28 68a89a2b8f892d07ede2fd3b Sean Kemp Sean Kemp jskemp7602@gmail.com 019727 36 2026-01-15 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Laura Sage 2026-01-15 22:34:37 -0.2 hrs 690cd41ba3b3df9f37b95e25 000026259 2.00 100.00 100.00 - - - - - - - - 2026-02-19 22:35:33 2026-06-11 23:08:16
4215 7ceab754d923df8cf311dce2dfc23ad804e2a531b23a5fa6eb879b09f8b3c3a1 690113fa671e385036a98297 67ced4d17abf9f3ed8fee2dd Nancy Pottoff Nancy Pottoff npottoff@hotmail.com 011782 539 2026-01-15 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Rosey Reed - Sophia L. 2026-01-15 22:17:25 -0.5 hrs 696e810ddee90dafb63b9376 000025088 2.00 156.00 80.00 - - - - - - - - 2026-02-19 22:35:33 2026-06-11 23:08:16
4214 b291c08500c9aa83d2bd815d67202d80c7eabed364b5c0d47ff0ee1b81baf291 69544de63c5aaea865afc815 68af4ba0023471867510ced6 Braedi Tagart Braedi Tagart tagarts@comcast.net 019764 17 2026-01-15 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Patient - - Yes Michelle W. - Michelle W. 2026-01-15 22:58:46 -0.0 hrs 69544de63c5aaea865afc814 000032131 4.00 82.00 37.00 - - - - - - - - 2026-02-19 22:35:33 2026-06-11 23:08:16
4213 3e3ade781120ccaec5d841e7571e6fd86d11cbfd9683ec22a956507ced7eb5a6 692f5af296b00a361fb29a3d 68a8158299c65c4a78a608a2 Hannah Simons Hannah Simons hannahjlsimons@gmail.com 019400 10 2026-01-15 Cancel 6899858814e44ebdae34c0b7 Rayann Greer 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Frances Lawrence found closer clinic Frances Lawrence 2025-12-19 22:29:04 -648.5 hrs 692f5af296b00a361fb29a3c 000029450 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:35:32 2026-06-11 23:08:16
4212 de95462f30228cef062eeb71b3c4565ceeab2eb21e3501bc1ff78c35ed4a0609 6924eecb9a22987984eba57e 67ced3d57abf9f3ed8feb1f6 Gordon Kennedy Gordon Kennedy knodrog@msn.com 007611 797 2026-01-15 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Ranjini Ridgway - Renee Carr 2026-01-15 22:55:15 -0.1 hrs 6924eecb9a22987984eba57d 000028343 5.00 390.00 0.00 - - - - - - - - 2026-02-19 22:35:32 2026-06-11 23:08:16
4211 1aa5fbc81f838ab8a758c5fb3c739a60e662310512d2445b16616b9ca0da44a1 691dea60ce931f7c63329528 67ced5997abf9f3ed8ff0170 Wendi Stewart Wendi Stewart stewart.wendi@gmail.com 014390 43 2026-01-15 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2026-01-15 22:57:00 -0.0 hrs 691dea60ce931f7c63329527 000027736 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:35:32 2026-06-11 23:08:15
4210 d828791cf2a3b54b445915c19ab32bbaed4f03894ffd8788305dd7de1c9bae51 68ffe717f80f8c62adb71835 67ced4f47abf9f3ed8fee8ad Carol Rhode Carol Rhode juneau1601@gmail.com 012278 172 2026-01-15 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ Patient is sick. - RC Renee Carr 2026-01-14 22:01:01 -25.0 hrs 68ffe717f80f8c62adb71834 000024976 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:35:32 2026-06-11 23:08:15
4209 c62094cf7dccd23068b0a417dfe04e734517dcc1310c66daa962295ba864af2d 6927580ce7a4d29a24b2b68b 68def7ccf6dc0196720ccae7 Maria del Carmen Marquez'Vargas Maria del Carmen Marquez'Vargas marquez2569@gmail.com 019983 21 2026-01-15 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Sophia L. 2026-01-16 15:11:15 15.9 hrs 6927580ce7a4d29a24b2b68a 000029055 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:35:32 2026-06-11 23:08:15
4208 1bfca20e013717ea0b60d571a92a1e4574e7b0a8880c7c5bd762e6307da354b0 69650eff4d4a1505a1a10331 67ced5807abf9f3ed8fefdec Tammy Salazar Tammy Salazar tsalazar@cochlear.com 014090 18 2026-01-15 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Mark Jerome Para-ase 2026-02-20 22:51:17 863.4 hrs 69650eff4d4a1505a1a10330 000033259 3.00 19.00 19.00 - - - - - - - - 2026-02-19 22:35:32 2026-06-11 23:08:15
4207 977044dc8f80fa174c559d69c157b7c110c6c2f7cea1f822e12e73af7147fabc 69399b35c395e3a7fe2850fc 69399a834dfa08b17a38908f Mark Babas Mark Babas markbabas@gmail.com 020357 29 2026-01-15 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Rosey Reed - Mark Leo Guevarra 2026-01-19 16:00:19 88.5 hrs 69399b35c395e3a7fe2850fb 000030273 3.00 127.94 127.94 - - - - - - - - 2026-02-19 22:35:32 2026-06-11 23:08:15
4206 056ee4148dfa46482c983c4487504c0dfe768d9056add02ed2767f0217be0390 693850520bde83be85bd422e 69384fd7f2aae9d8342742b9 Angie Doyle Angie Doyle angiedoyle75@gmail.com 020352 9 2026-01-15 Checked Out 68535c6303dd08c79c018795 John Reed 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Sonya C. 2026-01-15 23:25:29 -0.1 hrs 693850520bde83be85bd422d 000030073 4.00 100.00 100.00 - - - - - - - - 2026-02-19 22:35:32 2026-06-11 23:08:15
4205 1f22b02c89792181a9b65fc9be89b17f3d6bf66bc96ae4a97dbbf6259fa019b2 69373a899fb5ae948e472597 67ced32d7abf9f3ed8fe7df5 Jennifer Burak Jennifer Burak jenburak20@gmail.com 003174 101 2026-01-15 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. Pt had a MD appt that ran late Michelle Osgood 2026-01-16 00:00:41 0.5 hrs 69373a899fb5ae948e472596 000029986 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:35:32 2026-06-11 23:08:15
4204 a2b296b83d55251efcaa44fa7b1ad5080eb087d901628a875511ae213afde635 6942e23b4a3bc068e983976b 6895234dd7634722d0f894e3 Julian Alexander Julian Alexander alexandrianlibrary1@msn.com 017768 16 2026-01-15 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Stephanie Braun cxl per voicemail request Michelle W. 2026-01-15 14:45:36 -9.0 hrs 6942e23b4a3bc068e983976a 000031051 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:35:32 2026-06-11 23:08:15
4203 a38bdeddca88d714f618f40c4ebdf60a19dcad3a1d972b24e8996a68b0d36c98 6909405a1670a40d4f41ec14 68373ff77dfd39d6d490641b Laura Appelbaum Laura Appelbaum laurarappelbaum@gmail.com 017326 32 2026-01-15 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Secondary - - Yes Rosey Reed - Renee Carr 2026-01-15 23:39:46 -0.1 hrs 6909405a1670a40d4f41ec13 000025837 3.00 84.73 0.00 - - - - - - - - 2026-02-19 22:35:32 2026-06-11 23:08:15
4569 e9e4d8e112b9c90e1121703b7e48daa6d51194f3db28c7f589c131d89afe576a 6933407784ad0b0fcc76043f 68a752540dc9debdec764d99 Katherine Bewley Katherine Bewley katbewley@gmail.com 017885 17 2026-01-14 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ Patient had gallbladder removed and is still recovering. RC Renee Carr 2026-01-12 19:11:00 -28.8 hrs 6933407784ad0b0fcc76043e 000029828 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:36:17 2026-06-11 23:08:59