General Visit (PT Boulder API)

Total rows: 104,043
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
101319 80f8658b30dc9874a5fd806e16c41de47bbe97b2a7786f6e3b618dacf6b20a1c 69e8e8df6982dfab87f13c07 69d683893de480fac03c862b Evelyn Johnson Evelyn Johnson laurenannj924@gmail.com 021064 9 2026-05-12 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - Yes Michelle W. - Michelle W. 2026-05-12 14:13:34 -0.0 hrs 69e8e8df6982dfab87f13c06 000045659 3.00 236.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101318 28c5a18d72fb396f60898a171d11bd4ac8cfc1b8bf4193acfdab88c4360185de 69c6fb6f856c793fac023881 69c6fa80752c6b9834c22a68 David Clemans David Clemans d.clemans@icloud.com 020996 13 2026-05-12 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a67ab091753108089752a5 RTM READY 6899826579e412ce7c3dfae1 Broomfield Unpaid - Primary - - Yes Haley Paull - Michelle W. 2026-05-12 14:14:21 -0.0 hrs 69c6fb6f856c793fac023876 000042940 4.00 310.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101317 db36cbd7613fbaf836b7f6eaa953e79fbaa5f8220023aba348e472a35e0656c8 692f15f4ed548a898299de9f 67ced5a17abf9f3ed8ff02a2 Sarah Elizabeth Stockman Sarah Elizabeth Stockman sarahelizabethstockman@gmail.com 014492 45 2026-05-12 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Mark Jerome Para-ase 2026-05-15 17:19:03 75.1 hrs 692f15f4ed548a898299de9b 000029297 3.00 85.00 85.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101316 c102e4d49352f314b051279766a63cd864ef0db4cf1c6649ce26ee708bb33926 69f8fd15dd2cebf3478fc82a 6967cd72d3ce9da5c3e6b826 Michael Mook Michael Mook michaelmook66@gmail.com 020546 12 2026-05-12 Checked Out 679aeda44d561307f6600a43 Dawn Singleton 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Haley Paull - Laura Sage 2026-05-12 14:34:54 0.1 hrs 69f8fd15dd2cebf3478fc829 000047009 4.00 95.95 95.95 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101315 4c3e4e1c31aaf86b7da5d0fb081809a1d4326a1bba458ae1e7cd03c8bd9fc286 69f8adf733dcd5e935b34831 6977e7fa0e2a9af113e89fae Patricia Hartzell Patricia Hartzell patsahartzell@gmail.com 020635 8 2026-05-12 Checked Out 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Michelle W. - Laura Sage 2026-05-12 14:21:17 -0.1 hrs 69f8adf733dcd5e935b34830 000046911 2.00 159.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101314 1bf8ec04ef315806aa79daff9b693e69dafd046b2f15e18bb474b40fe97ad4e8 69f239816f3ff4ddec732304 684c77d17f968c69509f1b91 Chris Tanner Chris Tanner chris2249@gmail.com 017446 28 2026-05-12 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No John Phinney 24+ pt conf cxl sl 5/11 Sophia L. 2026-05-11 14:16:31 -24.2 hrs 69f239816f3ff4ddec732303 000046541 0.00 0.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101313 07d5452090df81c2e50cfaa9fdc672a9552b0f052d99aefa204ad3a753f4cea7 69cad9a5b737af4dd245827b 69cad7eadc1cd88901da4656 Bradley Barnett Bradley Barnett brad@mountainhighappliace.com 021004 9 2026-05-12 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Michelle W. 4/13 - PT was able to get in sooner at another office - HP Sophia L. 2026-04-13 18:35:08 -691.9 hrs 69cad9a5b737af4dd245827a 000043089 0.00 0.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101312 170d0dc06a62be33543b38c4e94b76178b28c5a4204d439bfa35f2aa51eb6b7d 69f3f4d9f39bc33121afd6d1 67ced5287abf9f3ed8fef0df John Scott John Scott jmscottdc1@yahoo.com 012977 33 2026-05-12 Checked Out 67b5043946dc800b97a38de3 Terri Nishimoto 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Primary - - Yes Terri Nishimoto - Sophia L. 2026-05-12 15:26:57 0.7 hrs 69f3f4d9f39bc33121afd6d0 000046840 2.00 155.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101311 850a7a3da665259027d8288f968e15c50e076465699ef1db0ec7158db7e5bb7b 69f382f05772c4552ab1a415 69d7fcd0404dc9d380c336fd William Sturtz William Sturtz julie@sturtz.org 021075 7 2026-05-12 Cancel 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sara Thompson mom forgot and he went to school Sara Thompson 2026-05-12 15:01:22 0.3 hrs 69f382f05772c4552ab1a414 000046699 3.00 0.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101310 f207e8821bea1c3a90800971740c81dd3aa4ea51486a0e7a91fbdd968b7c3c14 69f2619507ca260c158433ba 67ced3717abf9f3ed8fe967b Sheila Harrington Sheila Harrington harrington.sheila30@gmail.com 005266 123 2026-05-12 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Elizabeth Cousins Patient is sick and doesn’t want to share germs Elizabeth Cousins 2026-05-12 01:17:19 -13.5 hrs 69f2619507ca260c158433b9 000046601 1.00 0.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101309 6db0cfe82067245bfa325940c7b0dff97dafd5abf693da4e2711af3abd06d6da 69de93cd9de606fb5b231f55 69d7f12952f6102b0f495040 Andrew Lawrence Andrew Lawrence LAURA_LAWRENCE@MSN.COM 021073 8 2026-05-12 Cancel 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Haley Paull Doing DN with Eva Eva Tucker 2026-04-28 15:37:27 -335.1 hrs 69de93cd9de606fb5b231f54 000044743 0.00 0.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101308 8402e545571f1c37b05e96d76b8af243afd813a827fa9a9f2b2743292311f7d6 69b2e5406c15ee661c4e4c15 67ced3717abf9f3ed8fe969c Tony Flippo Tony Flippo tony.flippo21@yahoo.com 005277 11 2026-05-12 Cancel 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Laura Sage 24+ "feeling pt better" - sc Sonya C. 2026-04-28 17:17:05 -333.5 hrs 69b2e5406c15ee661c4e4c14 000041022 1.00 0.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101307 4bf368d7296291f09d8690c37ffd1441e5b06dbebaf0d6867bf15f06fdc0437d 69a9b067905935534b43ebff 67ced52f7abf9f3ed8fef1ff Dismas Rotta Dismas Rotta dismasrotta@comcast.net 013073 105 2026-05-12 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Haley Paull - Haley Paull 2026-05-12 15:11:04 0.4 hrs 69a9b067905935534b43ebfe 000040170 3.00 237.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101306 61ac00349864f0050fbae0cd9438b9564693a434a3cf19de6f0751cafa9f9fb2 696e9fa27748f49c8e0e3fd3 6939f4a07e4745ac22a0d394 Lynn Ramondo Lynn Ramondo ramondo29@msn.com 020365 8 2026-05-12 Cancel 67b5043946dc800b97a38de3 Terri Nishimoto 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sophia L. 24+ VM Req - cxl all upcoming appts - did not give a reason - sc Sonya C. 2026-04-27 18:17:51 -356.5 hrs 696e9fa27748f49c8e0e3fd2 000034307 0.00 0.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101305 10bc0a689991218df29f644e77395f0b534616f07bdd5fea5ca2189e7414b6c9 69efd77cae6f81dd6435d696 69efd758184be08e640909cd Jayden Kazantsev Jayden Kazantsev jaydenkaz2021@gmail.com 021167 8 2026-05-12 Cancel 6899858814e44ebdae34c0b7 Rayann Greer 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sonya C. 24+ pt missed the IE Michelle W. 2026-05-12 15:52:47 0.9 hrs 69efd77cae6f81dd6435d695 000046251 0.00 0.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101304 ab104fa616457e5a8c8c4c6c42785b638caf80afacd16b20dfb0417b2d00743a 69e7c885ad299015fec2d4a5 69b0403ebbb49392620b92f4 Ronald Plusk Ronald Plusk theplusks@gmail.com 020884 8 2026-05-12 Cancel 67a29daa5af9e907bbcd6f52 Eva Tucker 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Michelle W. 24+ scheduling conflict -mw Michelle W. 2026-05-06 20:34:32 -138.4 hrs 69e7c885ad299015fec2d4a4 000045565 0.00 0.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101303 3377c7db97f0fe149ce017efca4bed1a985ff4f720fe3dec7bb1653282f03bc8 69e1068f71673e0b761a6a23 69e1056d5feee4901f7ec161 Timmothy Marvin Timmothy Marvin timmymarvin8@gmail.com 021122 7 2026-05-12 Cancel 67ace27f67327b083edb451f Michelle Osgood 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Sonya C. 4/28 - pt will call back to rxl if he can do self-pay for IE - HP Haley Paull 2026-04-28 22:03:20 -328.9 hrs 69e1068f71673e0b761a6a1e 000045076 2.00 0.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101302 dd71938bc360c4878407ce7cde756db4388836358fcb42dbb2b6a9a0fcee37b8 69d7de7d60589845ceaae9d3 6977867ea3c8ff736e3c83dc Caroline Stevens Caroline Stevens carolinehstevens2@gmail.com 020625 32 2026-05-12 Checked Out 695ee4e12d8d53da864fc6f6 Veronica Rasmussen 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Christian Kenneth Abungan 2026-05-15 16:24:54 73.4 hrs 69d7de7d60589845ceaae9d2 000044321 4.00 85.00 85.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101301 2a3315751ae4e718d53ec788519a14fc8e99f432adb89bf8afef60d100816f2a 69d6943df1947e3fd72fd44a 69d691b8d87ad2cb09b6aab3 Florence Seaman Florence Seaman florence.seaman@gmail.com 021066 4 2026-05-12 Cancel 6899858814e44ebdae34c0b7 Rayann Greer 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Laura Sage 24+ Eva Tucker 2026-04-24 01:36:31 -445.4 hrs 69d6943df1947e3fd72fd449 000044200 0.00 0.00 0.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:43
101300 07422ae5c5de82db8728f9efb26dddd84d58d99deb3db1bf3eda180a6487807a 69d562671e023c636cf2a23b 67ced46c7abf9f3ed8fed124 Mary Moulton Mary Moulton mgmoulton@gmail.com 010270 57 2026-05-12 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Primary - - Yes Sophia L. - Christian Kenneth Abungan 2026-05-15 16:37:43 73.6 hrs 6a0759cec8c442905179460b 000044062 3.00 235.00 20.00 - - - - - - - - 2026-05-12 22:32:17 2026-06-10 22:37:42
101299 c9bed663c784df14aa4cc91178c23ce43eabbf0a1d1e12c58642df5e8ef056e1 69c55260437bc2677fb6d6cd 67ced5ee7abf9f3ed8ff0cd0 Patricia Walters Patricia Walters pat3walters@gmail.com 015360 17 2026-05-12 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Primary - - Yes Sonya C. - Laura Sage 2026-05-12 14:53:09 -0.1 hrs 69c55260437bc2677fb6d6ca 000042702 3.00 235.00 0.00 - - - - - - - - 2026-05-12 22:32:16 2026-06-10 22:37:42
101298 4bb88456447e412d73fc75beccd70158fe5f3d560efca5ff2694093d762ebcc8 69b18a2aaae98ed7dd31cdbd 69a7485d156ae90905c5ee52 Hannah Wheaton Hannah Wheaton hnwheaton07@gmail.com 020857 24 2026-05-12 Checked Out 68535c6303dd08c79c018795 John Reed 67a67ab091753108089752a5 RTM READY 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Laura Sage - Sonya C. 2026-05-12 14:56:58 -0.1 hrs 69b18a2aaae98ed7dd31cdbc 000040793 4.00 85.00 76.50 - - - - - - - - 2026-05-12 22:32:16 2026-06-10 22:37:42
101297 0dd8197bc1f9dc84b0cac16e65d1f53b9b89edfb47cfc4310ca8ab52e2d731c4 69a863dc71c5bb2b3c819f30 67ced4a77abf9f3ed8fedbb6 Anne Peters Anne Peters annep@indra.com 011172 36 2026-05-12 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67ab091753108089752a5 RTM READY 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Laura Sage - Haley Paull 2026-05-12 15:02:20 0.0 hrs 69a863dc71c5bb2b3c819f2f 000040046 4.00 312.00 0.00 - - - - - - - - 2026-05-12 22:32:16 2026-06-10 22:37:42
101296 aca48088370ec8e19889fabe79e1638c3e6809c7d3ce486a6aef80b810f6bd7e 69fa018e48b902e825871516 69cbd83483684e57b1f9e9e6 Jose Castillo Macias Jose Castillo Macias raucastillo211@gmail.com 021008 4 2026-05-12 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Samantha Saunders - Haley Paull 2026-05-12 15:08:18 -0.1 hrs 69fa018e48b902e825871515 000047070 4.00 317.00 0.00 - - - - - - - - 2026-05-12 22:32:16 2026-06-10 22:37:42
101295 a8417b66e0c2d81d54d8bf1304c36264be9bfb928c24cc6d6f78d8e2a6c02160 69f0c819489c27a3d2eb1a75 69d424dd4006b9c48309f75c Cody Commander Cody Commander drcodycommander@gmail.com 021049 13 2026-05-12 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Partially Paid - Primary - - Yes Sara Thompson - Mark Jerome Para-ase 2026-05-21 15:48:39 216.6 hrs 69f0c819489c27a3d2eb1a74 000046301 2.00 156.00 50.00 - - - - - - - - 2026-05-12 22:32:16 2026-06-10 22:37:42