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
27242 bf3efedd9b135037b1ad5a15719f553a745d7da36674f76cc394b9fa175a55ad 6852f284a7ebe634b710214e 682f6105852a87b392a60c33 Michael Hays Michael Hays quetip86@gmail.com 017289 2 2025-07-01 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Maia H. - Gillian B. 2025-07-01 20:32:49 0.3 hrs 6852f284a7ebe634b710214d 000009755 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:39:36 2026-06-12 00:05:49
27241 d27afa9abc7c9c2c11876b6d64dc33c2f344e8668c626618fce3bc1d82992e03 6852df8bf7518f7fe3e13f48 6852df46a7ebe634b70f65a1 Elijah Cooper Elijah Cooper ejcooper31@gmail.com 017469 2 2025-07-01 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 6/23 Sophia L. 2025-06-23 19:22:34 -192.9 hrs 6852df8bf7518f7fe3e13f47 000009738 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:39:36 2026-06-12 00:05:49
27240 3c0c046732e08181e08f7c107d96f96c8af66b61ed5c89921ba9cbfc4382fb89 683f1e500317fd08319181db 683f1d7e8dc54353317a8730 Elise Wobus Elise Wobus Elisa@ptboulder.com 017373 6 2025-07-01 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-06-17 20:22:34 -335.9 hrs 683f1e500317fd08319181d8 000007897 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:39:36 2026-06-12 00:05:49
27239 149d99b11a743168a7fb4498ce2e739b0ab2287a0b23af2cf0423fd0b63fd6ec 682603e9db64200815287108 67ced4287abf9f3ed8fec40e Erica Ligon Erica Ligon ericahope11@gmail.com 009154 36 2025-07-01 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Primary - - Yes Maia H. - Maia H. 2025-07-01 20:15:56 0.0 hrs 682603e9db64200815287107 000005697 3.00 237.00 0.00 - - - - - - - - 2026-02-19 23:39:36 2026-06-12 00:05:49
27238 c3f4f8c3adfc6cb43dcecc7e2389d04f85af310956049dde9614f4090350614e 67ec33eac4d96507c309538a 67ced5177abf9f3ed8feee3c Stephen Roman Stephen Roman sa3roman@gmail.com 012752 48 2025-07-01 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Elizabeth Cousins 24+ pt conf cxl SL 6/30 Sophia L. 2025-06-30 20:36:40 -23.6 hrs 67ec33eac4d96507c3095389 000000665 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:39:36 2026-06-12 00:05:49
27237 7b54578ab470937b765e0b5162305c733bc3673d5c689d92c233fd6745039b96 685ec833bd870707ae2dc786 67ced3657abf9f3ed8fe92c7 Hayley Hanes Hayley Hanes hanes.hayley@gmail.com 004950 78 2025-07-01 Checked Out 67a29cf58d115152b3ecae94 Allison Reyes 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Maia H. - Ranjini Ridgway 2025-07-02 16:58:39 20.5 hrs 685ec833bd870707ae2dc785 000011090 3.00 83.53 83.53 - - - - - - - - 2026-02-19 23:39:36 2026-06-12 00:05:49
27236 bbbc7c0b182731691d26ef665364052ee4637ed4e442aca4d31906c3d6093fd3 685d771b37e26aa9e5fb71f2 6859760e989978116ee22372 Kenyon Perkins Kenyon Perkins kenyonc.perkins@gmail.com 017498 5 2025-07-01 Checked Out 67a3d6954acb3d23d6a7e703 Hope Adair 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-07-01 20:37:52 0.1 hrs 685d771b37e26aa9e5fb71ee 000010911 2.00 54.57 54.57 - - - - - - - - 2026-02-19 23:39:36 2026-06-12 00:05:49
27235 884c8ca35d145768644fbb49193c9ca9498b8d7daffa3374c40aaf655fbd8863 685b01d61038dc0787cbfdf5 67ced3f07abf9f3ed8feb817 Kelsey Kretzschmar Kelsey Kretzschmar outsiderkk@gmail.com 008134 17 2025-07-01 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Sophia L. - Sophia L. 2025-07-01 20:30:51 0.0 hrs 6864576256b97d7d9eb3f479 000010560 3.00 230.00 0.00 - - - - - - - - 2026-02-19 23:39:36 2026-06-12 00:05:49
27234 8b99acac2827ac86945d6b413101d51109c869ba4e2274222fc446b62ef49744 682f9d0ddc2f1207e8b09908 67e1258b54aaaa3a80096c78 Paula Kehoe Paula Kehoe paulavolkin@hotmail.com 016752 12 2025-07-01 Cancel 67a29cf58d115152b3ecae94 Allison Reyes 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Maia H. - Maia H. 2025-06-26 18:14:59 -122.3 hrs 682f9d0ddc2f1207e8b09907 000006722 4.00 0.00 0.00 - - - - - - - - 2026-02-19 23:39:36 2026-06-12 00:05:49
27233 b4c65df6d4f142e5df6e319ecfd29d0aa11aaadb5aa27df2ea869022f7dfbf48 681a3ae463501b9672663a56 67e6653fefbf2c53d8d5dc6f Anne Gallagher Anne Gallagher galljams@comcast.net 016817 21 2025-07-01 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a67a90213226f6552a9bea KAISER FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ pt conf cxl SL 6/11 Sophia L. 2025-06-11 14:49:40 -485.7 hrs 681a3ae463501b9672663a55 000004432 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:39:36 2026-06-12 00:05:49
27232 51483beba7ecff9d13063da88b23fd1ec9ab2b99dee8e3a30b71e61537aeecba 681a36fd2cf5a60877bf4c9c 67ced32b7abf9f3ed8fe7cd8 Lynne Buhlig Lynne Buhlig lynnbuhlig@yahoo.com 003079 54 2025-07-01 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Maia H. - Maia H. 2025-07-01 20:35:43 0.1 hrs 681a36fd2cf5a60877bf4c9b 000004425 3.00 80.26 80.26 - - - - - - - - 2026-02-19 23:39:36 2026-06-12 00:05:49
27231 aa95df1da70735fd983b662aa6a1d7edff8dc0c0a525e869162faa961607cfad 67f68bacae20070807135971 67ced32f7abf9f3ed8fe7eee Alexandra Baris Alexandra Baris barisalex70@gmail.com 003257 221 2025-07-01 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Gillian B. 2025-07-01 20:44:03 0.2 hrs 67f68bacae20070807135970 000001566 3.00 78.70 78.70 - - - - - - - - 2026-02-19 23:39:36 2026-06-12 00:05:49
27230 19a7f9183de6423128d4f39db7852abb30ca2380842508105152b31111adbb10 6862cb98a4197507f9b3450d 6854681dfa5bb5088f5c7a6d Jaden Malerba-Sholders Jaden Malerba-Sholders mmtgjg@gmail.com 017479 8 2025-07-01 Checked Out 682ca33c115b6e82fb427e49 Sarah Emrey 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Sophia L. - Gillian B. 2025-07-01 21:02:33 0.3 hrs 6862cb98a4197507f9b3450c 000011303 5.00 159.00 139.00 - - - - - - - - 2026-02-19 23:39:36 2026-06-12 00:05:49
27229 caa8c576c62f34650f6e50071644f423cb9ff53df4878ba310e140b1be0aa0d5 685d988d52cdb10825f51d46 685d98616b03f5494319de5e Francis Murphy Francis Murphy bob@bcmurphy.me 017533 4 2025-07-01 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 6811317edf49090786459798 Medicare OT/PT Initial Evaluation 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Gillian B. - Maia H. 2025-07-01 21:16:05 0.5 hrs 685d988d52cdb10825f51d45 000010959 4.00 171.76 171.76 - - - - - - - - 2026-02-19 23:39:35 2026-06-12 00:05:49
27228 54c5123d1d51ec7ee77159a4d88354c0709565f355108ce579ba40361f9e6279 68547e303720bdde5d9dfc01 68222f38b1e3380854c5a48d Marjorie Freedman Marjorie Freedman freedcolbe2303@comcast.net 017222 6 2025-07-01 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 67a2a18d0965a342e59d1264 Boulder Suite 205 Partially Paid - Primary - - Yes Samantha Saunders - Ranjini Ridgway 2025-07-01 21:47:57 1.0 hrs 68547e303720bdde5d9dfc00 000010028 3.00 237.00 20.00 - - - - - - - - 2026-02-19 23:39:35 2026-06-12 00:05:49
27227 c9a7abc1167db7b344621889863a4cc0c5173a21598d71913d20d63e1fa0d4df 6849d4e718ec7a087e031337 67ced4637abf9f3ed8fecf83 Karla McClure Karla McClure mkmcclure@gmail.com 010131 55 2025-07-01 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Gillian B. 2025-07-01 20:51:02 0.1 hrs 6849d4e718ec7a087e031336 000009042 2.00 85.00 85.00 - - - - - - - - 2026-02-19 23:39:35 2026-06-12 00:05:49
27226 6ba3d6e80c9635e6da54ec9a97289a6f135806dccc4e7aaa5dcc2ec16f41e43f 684356583f23370857be82c3 68264666b6126f07f71fbd27 Patrick Kruse Patrick Kruse patrick@ptob.com 017242 7 2025-07-01 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Gillian B. 2025-07-01 20:19:07 -0.4 hrs 684356583f23370857be82c2 000008655 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:39:35 2026-06-12 00:05:49
27225 17d949d85e1b8bc2915650147271a140d28dc77bf8a717fa1ef71642058760a5 682cdaace8e09507af8fdbd9 682cd8daefd2f4085286fe14 Kathleen Haddock Kathleen Haddock kathy@kathyhaddocklaw.com 017270 6 2025-07-01 Cancel 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. - Gillian B. 2025-06-16 13:53:44 -366.9 hrs 682cdaace8e09507af8fdbd8 000006276 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:39:35 2026-06-12 00:05:49
27224 d273697f5ca5fce2deac47b528124f50f22eadc4a4256ccc5f16186daa0f8f95 68386e2c6b7fccb96b79ddf0 67ced54c7abf9f3ed8fef658 Ruchi Shekhar Ruchi Shekhar ruchi.shekhar@gmail.com 013444 34 2025-07-01 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a18d0965a342e59d1264 Boulder Suite 205 Unpaid - Unidentified - - No Gillian B. - Maia H. 2025-06-24 22:34:32 -166.4 hrs 68386e2c6b7fccb96b79ddef 000007388 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:39:35 2026-06-12 00:05:49
27223 615956d7ad41ef26caaff2f5b6acb965e44fd24b4863ab6fd695f5bc8b7accf3 6859bdb3ccf3b2076312c89c 6859bcd35c30cc078856fb22 Jeffrey Fenton Jeffrey Fenton jeffwf@comcast.net 017506 12 2025-07-01 Checked Out 683aa08158eaf318442499e4 James Fowlkes 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sonya C. 2025-09-25 19:45:49 2062.5 hrs 6859bdb3ccf3b2076312c89b 000010396 3.00 -84.54 114.46 - - - - - - - - 2026-02-19 23:39:35 2026-06-12 00:05:49
27222 33926f362a206723bb59ce5d02ec1a6aa1fa43aa7bfa6b65bf802a370c159fd0 6851a317c7f0e6f784ec04ce 6851a127a7ebe634b70909f1 Susan Cousins Susan Cousins susancousins@hotmail.com 017461 7 2025-07-01 Cancel 682ca33c115b6e82fb427e49 Sarah Emrey 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ LVM for us and followed up w/ a text confirming cxl of 7/1 appt Sonya C. 2025-06-30 16:00:20 -29.2 hrs 6851a317c7f0e6f784ec04cb 000009615 2.00 0.00 0.00 - - - - - - - - 2026-02-19 23:39:35 2026-06-12 00:05:49
27221 45a45689c4cc2caba4ea58e1d50318ed9894f6f2f7bf427b37f61d8dfc506f57 68266fa8c895c9c9d7b84bcb 68266ef7f0e468c9b193f9d1 Karla Waltman Karla Waltman karlawaltman215@gmail.com 017251 11 2025-07-01 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Ranjini Ridgway 2025-07-02 17:06:17 19.9 hrs 68266fa8c895c9c9d7b84bc6 000005904 3.00 235.00 0.00 - - - - - - - - 2026-02-19 23:39:35 2026-06-12 00:05:49
27220 19bffaffbf42229f3e5a5bb4777954f1ccf808662610128ab15f6b1db65c86a1 680bcc0b9fc93449b8c21d84 67ced3067abf9f3ed8fe6d30 Fong P Chan Fong P Chan coreina.chan@gmail.com 001743 13 2025-07-01 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. - Gillian B. 2025-07-01 21:45:53 0.5 hrs 680bcc0b9fc93449b8c21d83 000003548 0.00 0.00 0.00 - - - - - - - - 2026-02-19 23:39:35 2026-06-12 00:05:49
27219 880518f535b255698c217fec5d333eb6e958a308cd35d782055b7ef0915eac54 6806c8f9341fb620423e93e9 67ced3757abf9f3ed8fe97cb Janet Hart Janet Hart janethart80301@icloud.com 005378 167 2025-07-01 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Gillian B. 2025-07-01 21:03:53 -0.2 hrs 6806c8f9341fb620423e93e8 000003010 3.00 78.70 78.70 - - - - - - - - 2026-02-19 23:39:35 2026-06-12 00:05:49
27218 74e9ed48f3cf0168239fed75902dc4396afb1c6fd26a160596fd4e360f135319 6806a84ea91ba707eed8ee1f 67ced3b87abf9f3ed8feaaa9 Midori Hironaka Midori Hironaka tfitz52@comcast.net 006988 121 2025-07-01 Checked Out 67a29cf58d115152b3ecae94 Allison Reyes 67a67993bef93ba255afee13 ACN AUTH NEEDED - GET OUTCOME AND FORM 67a2a18d0965a342e59d1264 Boulder Suite 205 Paid - Patient - - Yes Sophia L. - Maia H. 2025-07-01 21:07:34 -0.1 hrs 6806a84ea91ba707eed8ee1e 000002955 3.00 80.00 80.00 - - - - - - - - 2026-02-19 23:39:35 2026-06-12 00:05:49