General Visit (PT Boulder API)

Total rows: 101,513
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
15699 34c22f50521749e237cc614fb04d57b654e1951edaed0f38ae014e0a2c490c9a 68bb1a4f47d16198052c2b01 68bb197733c19f088e50c95b Casey O'Connor Casey O'Connor caseyo.connor@yahoo.com 019807 10 2025-10-03 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. Jack out sick- sc Sonya C. 2025-10-03 12:00:43 -1.0 hrs 68bb1a4f47d16198052c2b00 000018914 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15698 bec7dfd8612c633674a117da8127666300434950168639cb9ff6bbc66c4495a4 68af5406a8a9e59c22a2c035 67ced36d7abf9f3ed8fe9564 Sean Fitzgerald Sean Fitzgerald sean.fitzgerald@colorado.edu 005173 37 2025-10-03 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Patient - - Yes Michelle W. - Jayson Encarnacion 2025-10-07 22:20:35 105.3 hrs 68af5406a8a9e59c22a2c034 000017861 3.00 80.00 56.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15697 36d4fbcb06ce62f9c576d667baa1555d737ba05cd485d248ba157cbfefc6a1d5 68a3977e9406c207aa9ab4d6 67ced30d7abf9f3ed8fe70d2 Loretta Cheng Loretta Cheng lcheng2828@yahoo.com 002053 39 2025-10-03 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Sophia L. - Sophia L. 2025-10-03 13:54:35 0.9 hrs 68a3977e9406c207aa9ab4d5 000016602 2.00 159.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15696 54b8851c0ae23eee7563d37d3d089b146573882b739916f33063aafeb21acf79 68c2f30552aff76bac0c4c7d 68ae120ff065ca9b12380486 Melinie Feldman Melinie Feldman melinie9@hotmail.com 019747 6 2025-10-03 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-03 14:52:54 1.4 hrs 68c2f30552aff76bac0c4c7c 000019521 4.00 95.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15695 7db17de497f182396b529ae9beb1f36a0d92902d62709fd89f20221381189bed 68c2d8c1aa869d08107976f3 67ea9760128d6a27c05dd70a Kerrie Lessway Kerrie Lessway klessway91@gmail.com 016917 15 2025-10-03 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Samantha Saunders 2025-10-03 13:34:05 0.1 hrs 68c2d8c1aa869d08107976f2 000019484 3.00 100.00 100.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15694 6b3fc8dd92c3b74b9fc3db655d7beaebf5eb8567c7edb06e4976539368b736d7 68bb1020f67804685fdca9c3 67ced3737abf9f3ed8fe96ff Ethan Goulet Ethan Goulet dondonnagoulet@ymail.com 005310 25 2025-10-03 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Secondary - - Yes Sonya C. - Sophia L. 2025-10-03 13:54:37 0.4 hrs 68bb1020f67804685fdca9c2 000018905 2.00 56.97 42.86 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15693 2d4140ab684074efb77a41036fd245751054c0b382852319dc6d9d5cdcce6bea 689c9f679a8cba51689c3b78 67ced3eb7abf9f3ed8feb6e8 Mary A Kolbeck Mary A Kolbeck mariakolbeck@gmail.com 008033 48 2025-10-03 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-03 13:33:36 0.1 hrs 689c9f679a8cba51689c3b77 000016119 2.00 59.50 59.50 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15692 7f0b7f91f8b4689ae7f9614edfd6e01b94f433cd311cfc1728c2989ad70edcbc 689cb2c5a9f4e007790cbd1b 689cb1d90a037ce085bec243 Erica Clarke Erica Clarke ericasandman@yahoo.com 017790 9 2025-10-03 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Mark Leo Guevarra 2025-10-10 19:13:07 173.5 hrs 689cb2c5a9f4e007790cbd1a 000016147 4.00 95.75 95.75 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15691 1b7045e5ef5fc6b613c9603facfe6e420e0c4196211f1aa695118730f774fc6e 68d18fbd5959b720c683bc63 67ced3cb7abf9f3ed8feaf53 Michael Kazanjian Michael Kazanjian mkazanj@gmail.com 007386 25 2025-10-03 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Laura Shove - Jayson Encarnacion 2025-10-07 22:06:43 104.1 hrs 68d18fbd5959b720c683bc62 000020493 3.00 85.00 85.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15690 cb9b2281a77c212705968d6ff9f83b395ec72f106cab2e70499cd4e9ef807ea4 68c43a9732b94e016882e9b0 68bb37eb07fdded14a2775c6 Jocelyn Brown-Saracino Jocelyn Brown-Saracino jocelynbrownsaracino@gmail.com 019812 8 2025-10-03 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Rosey Reed 24+ pt OOT - RAR 9/26 Rosey Reed 2025-09-26 17:29:16 -164.5 hrs 68c43a9732b94e016882e9af 000019635 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15689 f2a8a55fbac74b2c187f780360be92a6bfb8935f8f455368f8b373a4a50f0c3b 68a61aa86f38194b967af4c1 67ced57e7abf9f3ed8fefdb6 Jennifer Simpson Jennifer Simpson jlynphd@gmail.com 014072 16 2025-10-03 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Jayson Encarnacion 2025-10-07 19:07:04 101.1 hrs 68a61aa86f38194b967af4c0 000016947 3.00 82.00 82.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15688 cee80b859f351bd4c072003171ae5f7ed1e6021c5b7ac247758744e5738ed499 6893863fcf55ab080645066a 68938556431f72084b4993c3 Thomas Sheldon Thomas Sheldon tsheldond@aol.com 017762 26 2025-10-03 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Sophia L. 2025-10-03 14:00:48 0.0 hrs 6893863fcf55ab0806450662 000015502 1.00 32.39 32.39 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15687 5078884d689df2bae5620d3a6badbcb2befee910d89e5eb60b9840b0843ef5ec 68839392bbb6995d0377db4c 67ced4d87abf9f3ed8fee421 Richard Przywitowski Richard Przywitowski dick_lois@comcast.net 011890 83 2025-10-03 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Sonya C. 2025-10-03 13:55:48 -0.1 hrs 68839392bbb6995d0377db38 000014328 3.00 237.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15686 fb6afcfd3bf076bfe2638a293394b41ada8e64d1e0ca0dca3edd3519460523e4 68cb1656ef9149315e26d966 68c9ce4274eb7b5d25a89a76 Amanda Keim Amanda Keim mountainmak@earthlink.net 019879 28 2025-10-03 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Sophia Phillips - Jayson Encarnacion 2025-10-07 21:26:24 103.2 hrs 68cb1656ef9149315e26d965 000020071 1.00 130.00 124.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15685 872d96347fd43aefbf5732fcfa9368d98a5c3746bafbf137530c50a49146ebe6 689f5a1b58e5ae078f16cae0 67ced49f7abf9f3ed8feda3c Noel Nevers Noel Nevers noelsmiles@gmail.com 011046 27 2025-10-03 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ scheduling conflict -mw Sophia L. 2025-10-02 16:12:05 -22.0 hrs 689f5a1b58e5ae078f16cadf 000016404 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15684 346af8e715137524ceb3ac67531df0385bce5213b27cb842cb8671fad8211480 68cd77cdf451fa086145ef62 685c34ff931a5d07ed1883ac Lawrence Wilk Lawrence Wilk jcbrazilaw@gmail.com 017522 12 2025-10-03 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Elizabeth Cousins 24+ pt LVM to CXL all remaining appts - RAR 9/22 Rosey Reed 2025-09-22 16:36:37 -261.9 hrs 68cd77cdf451fa086145ef61 000020307 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15683 031829e0f9b4aefb9e7bf1302d7f0328d7af8682209888038e29951d677ef19b 68c1a937a84083220674bbde 6880f33f283f2e0843200752 Mandi Hutson Mandi Hutson mandihutson22@gmail.com 017678 13 2025-10-03 Cancel 68535c6303dd08c79c018795 John Reed 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. Jack out sick today - sc Sonya C. 2025-10-03 14:10:16 -0.3 hrs 68c1a937a84083220674bbdd 000019396 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15682 a7fe8977d87e4ef1dfa14ad8fc88fbd4ce06a7619b4c0f95241583d7a1342efc 68bb7315bace7707807052f4 6839d1cf8a9655086b33b87c Sandra Lombardi Sandra Lombardi sandyander2@comcast.net 017346 23 2025-10-03 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Emily Pickner - Rosey Reed 2025-10-03 14:54:39 0.4 hrs 68bb7315bace7707807052f3 000018981 3.00 82.00 82.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15681 c7e2d1f70748851ca3b1f9d2be0acd1aabece51fd5cc45e9787cb1473b26461a 68bb1baf9d5364f1eaf3a13b 6890f53513ad5d0869c69545 Carmen Chang Carmen Chang carmen.p.chang123@gmail.com 017747 9 2025-10-03 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Patient - - Yes Michelle W. - Samantha Saunders 2025-10-03 14:35:17 0.1 hrs 68bb1baf9d5364f1eaf3a13a 000018920 3.00 85.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15680 15e9237351aebcb7fccdd5392aff5d87fcb90d42f986623628a79e430740b1c0 689f87194166f30854483a56 67ced3f67abf9f3ed8feb968 Sherri Laber Sherri Laber sherri.laber@yahoo.com 008246 27 2025-10-03 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Secondary - - Yes Sophia L. - Rosey Reed 2025-10-03 14:49:15 0.3 hrs 689f87194166f30854483a55 000016464 2.00 -43.40 56.80 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15679 7b9b38fb12ae1d915645aafd05f3431575ace159e93248d1c48813269e470652 689123d474137e085eba9ed2 67ced4f47abf9f3ed8fee8ad Carol Rhode Carol Rhode juneau1601@gmail.com 012278 172 2025-10-03 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-10-03 14:49:32 0.3 hrs 689123d474137e085eba9ed1 000015316 2.00 56.80 56.80 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15678 fae9c84d44f5bbf9983d960dd361f42cf29b419b0e32284aad5b7739fb2e6d3d 6888e8828b095a07f9d18c5d 67ced3a07abf9f3ed8fea458 Laura Guy Laura Guy lauraannguy@gmail.com 006449 99 2025-10-03 Cancel 679aeda44d561307f6600a43 Dawn Singleton 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 8/13 Sophia L. 2025-08-13 22:21:22 -1216.1 hrs 6888e8828b095a07f9d18c5a 000014566 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15677 d5a906ef2dfd46f35efbd42694f2d66d93182cf2b2c25e2b5b977b3035b5d69c 687924687eb0dd58227716b7 6879237b6180b007ba2356eb Mitchell Goldman Mitchell Goldman mitchmhz@outlook.com 017643 6 2025-10-03 Cancel 67a3c1c3d8b9514e4335442c Miranda Samson 67fe758025fd260826e4f8b1 Pelvic Floor Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sophia L. 24+ Has broken shoulder, will call to rxl - sc Sonya C. 2025-10-02 15:26:00 -23.1 hrs 687924687eb0dd58227716b6 000013339 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15676 b7e48954fd2dfca929babb7ad8b152e3768948560955bdfa91643063c9c3fcc2 68d3f3ea3d387a08baecfe83 68a38e7aba796dc7de088f3a Kerstin Dickson Kerstin Dickson kl.dickson@comcast.net 017816 28 2025-10-03 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Jayson Encarnacion 2025-10-07 21:39:28 102.9 hrs 68d3f3ea3d387a08baecfe82 000020771 3.00 85.91 85.91 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00
15675 0f3eba54ba4e96201ad1c28f76d9b8ed54d645838310bc7b3b458ae26060fe24 68c44be526767b510e0bd90f 67ced2eb7abf9f3ed8fe5c9b William Abplanalp William Abplanalp bapple60@gmail.com 000328 23 2025-10-03 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ see contact log -mw Michelle W. 2025-10-02 17:25:33 -21.3 hrs 68c44be526767b510e0bd90b 000019662 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:06:48 2026-05-13 23:32:00