General Visit (PT Boulder API)

Total rows: 100,726
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
12398 4efe9944b0a5431c9a53e96bd3310ee1c9832298df84478d58227a3d1c01fd18 69014129d0cb7677b37e63b9 68599286ed08c1df3c5041eb Katherine Robertson - Mazur Katherine Robertson - Mazur katie.jay3@gmail.com 017504 43 2025-10-30 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Patient - - Yes Sonya C. - Emily Pickner 2025-10-31 12:52:27 14.4 hrs 69387d3cd9bbc52b4b46f5f2 000025163 3.00 82.00 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:42
12397 52ca583c51dd9956eb71226500d514ba251e0d616c2f6b53d8bf6f4fbfeb372f 68f7c2601ece9009eb472579 67ced6137abf9f3ed8ff11ba Jason Ting Jason Ting jtingpm5@gmail.com 015779 31 2025-10-30 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Patient - - Yes Sophia L. - Sonya C. 2025-10-31 13:19:57 14.8 hrs 68f7c2601ece9009eb472578 000024224 3.00 79.67 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:42
12396 3d0e0ced877aa6249fdf066e3cd058bd201d40d6d9edff2f482bab00a1979c5d 68e91608af0c7dedfbe4e17a 68a3ad1fba7b930889ba494a Saturnino Arellano Saturnino Arellano arellano.salas07@gmail.com 017820 10 2025-10-30 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ Liberty has stopped paying -mw Michelle W. 2025-10-20 20:51:22 -241.6 hrs 68e91608af0c7dedfbe4e179 000023017 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:42
12395 04cdc9794b2aa3239f415a081590c3f9565aa1e3c01a56df3c30eb919914be2b 68e6bb3b331a96099a82731c 68e6ba677fe660097b92ecac Tucker Mills Tucker Mills tuckermills573@gmail.com 020020 21 2025-10-30 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-11-04 21:18:19 118.8 hrs 68e6bb3b331a96099a82731b 000022781 3.00 85.00 102.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12394 b96f2bc6ddeb42e243edd8abe0f01810ec2e4b87892a75407da06290b1ae7744 68d2f6fca8cdcde5579ba959 68d2f69599b6f3219a989487 Samuel Sweeny Samuel Sweeny sweendoc11@gmail.com 019921 5 2025-10-30 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 10/3 Sophia L. 2025-10-03 14:45:02 -655.7 hrs 68d2f6fca8cdcde5579ba958 000020690 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12393 90b65de13d7e23f093eb8543e4e5fa034f090ae1b251207bb9c79c24870ea97c 68c1d6ec9c003b3ecf18f017 68c1d59dbf83f0d7ca3d3603 Eric Schaetzel Eric Schaetzel evschaetzel@gmail.com 019834 11 2025-10-30 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ Schedule conflict Emmie Gebhardt 2025-10-27 22:13:06 -72.3 hrs 68c1d6ec9c003b3ecf18f00f 000019435 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12392 a55664ce2fbbc315d093587452ef2bd6bf3cbfec039e91febac1cb5945a5cd18 68a753e345d2d5cf96fc1fa2 68a752540dc9debdec764d99 Katherine Bewley Katherine Bewley katbewley@gmail.com 017885 17 2025-10-30 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-11-04 22:39:34 120.2 hrs 68a753e345d2d5cf96fc1f99 000017096 4.00 95.38 95.38 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12391 4d97d00890bd8b9483e6f3bd46c6e7bcd45e85b146d9b192d8ba5e3f79d5b857 68d326cf175f3b10f13d6c0b 68407dc4cf918e087b7eab3e Nancy McKenna Nancy McKenna 3@9.com 017385 17 2025-10-30 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Emmie Gebhardt Insurance not covering -EP Emily Pickner 2025-10-30 18:05:43 -4.9 hrs 68d326cf175f3b10f13d6c0a 000020768 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12390 fdfaa5ee10edbf7f9e9bdb4257f3fd7b3a2670a31d2a8fb48903f36080a28c84 68bb3ef59d5364f1eaf48d9f 67ced4be7abf9f3ed8fedfb3 Kiersten Pierpoint Kiersten Pierpoint pierpoint_kiersten@svvsd.org 011512 33 2025-10-30 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-31 13:20:08 14.3 hrs 68bb3ef59d5364f1eaf48d9b 000018962 2.00 100.00 100.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12389 98c5572a6216bc9d3522cf821deef0d2157b37ed753665b3d32abd71f525a8b8 689114c3424398086b14b71a 67ced37e7abf9f3ed8fe9a80 Amelia Greacen Amelia Greacen mollygreacen@womanmedicine.com 005609 100 2025-10-30 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Laura Shove 2025-10-31 12:21:45 13.4 hrs 689114c3424398086b14b719 000015288 3.00 78.70 78.70 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12388 f53657cfdd00437ae5e677435f31683fa2896ea8523783e565d5a0b1593adfb6 68a5e6d2588ab8083e09db2d 68a5e4d825566307d108fe49 William Lucca William Lucca cblucca@msn.com 017831 23 2025-10-30 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Frances Lawrence - Kenneth Dave Francisco 2025-11-04 19:31:43 116.3 hrs 68a5e6d2588ab8083e09db24 000016871 4.00 95.48 145.48 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12387 dbdee35fb9fb5c09dc5a486b715b60c41a0e99c51b8ba084446e6018a79a340d 68a39366900d21b67b67ca40 684862a948ba666f6303f7f1 Summer Nicks Summer Nicks nickssummer@gmail.com 017430 16 2025-10-30 Checked Out 67acc4530db5de07addc9873 Anne Majewski 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sophia L. - Anne Majewski 2025-10-30 21:04:56 -2.2 hrs 690e72af73765f60c0405b02 000016597 4.00 312.00 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12386 a775cd058d95bcff49c857e9a582f1a60259c933f847f62827c73fbbfc6cfa80 68c9f6c690e81717f08490ce 67ced4727abf9f3ed8fed268 Nancy McGann Nancy McGann nancymcgann@imail.org 010378 45 2025-10-30 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Patient - - Yes Laura Shove - Laura Shove 2025-10-31 00:07:02 0.4 hrs 68c9f6c690e81717f08490cd 000019989 3.00 85.00 0.00 - - - - - - - - 2026-02-19 22:56:47 2026-05-06 23:22:41
12732 52f53edd9477991b6c30661bef5d5732f5e1ed8cbfb5205f6ab56c48600e2c1f 68dd4be5635e040a103bf5c7 68dd4ad85586a80982267801 Deborah Correll Deborah Correll dbcorrell@yahoo.com 019966 21 2025-10-29 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Michelle W. - Sonya C. 2025-10-29 14:00:35 1.0 hrs 68dd4be5635e040a103bf5c6 000021831 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:57:53 2026-05-06 23:23:28
12731 bbe22fdadef3090774c35b91d27b46e56e60c05c69d3b08e439cb996710a4c37 68653ddf018f70088cab09ee 67e6661befbf2c53d8d5f340 Zaira Nevarez Zaira Nevarez zaira_0102@hotmail.com 016860 33 2025-10-29 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Sophia L. 2025-10-29 14:41:25 1.7 hrs 68653ddf018f70088cab09ed 000011556 2.00 100.00 100.00 - - - - - - - - 2026-02-19 22:57:53 2026-05-06 23:23:28
12730 143f3384ff889d9b38db34ed1358c27e4fc216c39e074d270f1dc83120b1e677 68af739c3b353a3c82628c29 68768f6512dec008227b82b5 Annie Burgos-Buenfil Annie Burgos-Buenfil aburgosbuenfil@gmail.com 017632 9 2025-10-29 Cancel 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. SL 10/16 24+ pt conf cxl ( having surgery) Sophia L. 2025-10-16 19:24:13 -305.8 hrs 68af739c3b353a3c82628c28 000017908 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:57:53 2026-05-06 23:23:28
12729 aac6d825793b77755a1b16557abf3a86bdad3a2b0420754225d3f0debec66a13 68ffd3ddc9fd81098a49ca57 68ffd3c83a5099793b1a6a05 Diane Fear Diane Fear djfear96@gmail.com 020152 13 2025-10-29 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67fe758025fd260826e4f8b1 Pelvic Floor Initial Evaluation 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Sonya C. 2025-10-29 14:00:51 0.5 hrs 68ffd3ddc9fd81098a49ca56 000024951 4.00 148.41 148.41 - - - - - - - - 2026-02-19 22:57:53 2026-05-06 23:23:28
12728 0d5b9fab31dab91d3ebfb49fb1e7a1ed81c566a97911861f7ad39fcfb2c9a98f 68ed6635cb205bfd76bf30fa 68a8bf075260c9e13f76eb8b Marlene Redman Marlene Redman marlenesredman@gmail.com 019732 11 2025-10-29 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sonya C. - Mark Leo Guevarra 2025-10-30 18:29:13 29.0 hrs 68ed6635cb205bfd76bf30f9 000023239 1.00 130.00 130.00 - - - - - - - - 2026-02-19 22:57:53 2026-05-06 23:23:28
12727 4be8054a26e19206fa973507958831203c2423836ae1dc69f83ead30a97b0053 68e3ec019b623609e288602b 68d1694a41a4eec04383b5fe Riki Frea Riki Frea freafamily@mac.com 019908 6 2025-10-29 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-10-29 14:00:18 0.5 hrs 68e3ec019b623609e2886027 000022334 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:57:53 2026-05-06 23:23:28
12726 67ceadb2ceb5d0b22e9a01727bf15ae1e0eeed47c773bad950a30f70d9903a14 68e3d7bcab83a708b61ee864 68e3d746a0128ea37f9a5425 Patricia Badeaux Patricia Badeaux badeauxpatricia@gmail.com 019992 11 2025-10-29 Cancel 67accd974e54de07d58ca3ee Sophia Phillips 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ pt in hospital - RAR 10/27 Rosey Reed 2025-10-27 15:34:29 -45.9 hrs 68e3d7bcab83a708b61ee863 000022272 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:57:53 2026-05-06 23:23:28
12725 0989bddb41ddf2af1b67387f47644dd03fe6aead13469a53ffe831df41da9556 68daa6672102d799ad67a5a5 6888e114dc80142d6a2c2097 TM Frey Morris TM Frey Morris drpiefrey@mac.com 017716 29 2025-10-29 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sonya C. - Michelle Osgood 2025-10-29 14:21:21 0.9 hrs 68daa6672102d799ad67a5a4 000021313 3.00 232.00 0.00 - - - - - - - - 2026-02-19 22:57:53 2026-05-06 23:23:28
12724 dc75c57af729b06a821e71d27b12d5109168ec404e51552dbe0d4ded1b153298 689c9fa9bb26ab0882075093 67ced3eb7abf9f3ed8feb6e8 Mary A Kolbeck Mary A Kolbeck mariakolbeck@gmail.com 008033 48 2025-10-29 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67ab091753108089752a5 RTM READY 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 8:05am For Sonya - Maria - calling to cancel her apt with Annie on 10/29 at 7:30am - her husband had a car accident and she has a house guest coming, cannot make that appointment on 10/29. Thank you. Ranjini Ridgway 2025-10-27 14:12:26 -47.3 hrs 689c9fa9bb26ab088207508f 000016123 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:57:53 2026-05-06 23:23:28
12723 230c3e41acd8836e7c1f495e83b9ab137149723c6f85e58ae192d7db1d75c377 6882aae3663fb8089ce616aa 67ced3d97abf9f3ed8feb2c5 Robert Hunnes Robert Hunnes bob@hunnes.com 007680 28 2025-10-29 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Mark Leo Guevarra 2025-10-31 14:59:14 49.5 hrs 6882aae3663fb8089ce616a9 000014303 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:57:53 2026-05-06 23:23:28
12722 611fb1139ba123e789571c3e0356c8181bac85d40013e61d87a5adee8a0d34cb 68653fabb86acb572aec62a3 67ced43a7abf9f3ed8fec7a4 Marie Molinary Marie Molinary memolinary@gmail.com 009460 31 2025-10-29 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Michelle W. 24+ sch conflict- sc Sonya C. 2025-10-28 17:39:24 -19.8 hrs 68653fabb86acb572aec62a2 000011571 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:57:53 2026-05-06 23:23:28
12721 51a9354a27772292274324ac9e66c1ac45cc4fea0ead7b88910b0165a0a80bea 6900e0d73ae514b8a854dfae 67ced3777abf9f3ed8fe985e Colleen Grande Colleen Grande collgrande@gmail.com 005427 69 2025-10-29 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Samantha Saunders - Samantha Saunders 2025-10-29 13:50:36 0.1 hrs 6900e0d73ae514b8a854dfad 000025008 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:57:53 2026-05-06 23:23:28