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
11980 1ff8cbbb1f0f34c92055dc6bc5f6ace38287d1e3645059dfaf124df97632be13 6824faf09e4bc9d0a4acaec0 67ced2ed7abf9f3ed8fe5d37 Patricia Beumer Patricia Beumer patty1@beumerfamily.com 000380 818 2025-11-04 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Sophia L. 2025-11-04 20:51:22 0.1 hrs 6824faf09e4bc9d0a4acaebf 000005573 3.00 80.26 80.26 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11979 f849f65f6ddc7e6b8c047dfee93bc039677f9a984b5e9ed1c8e2ad38d4e8bfac 68f80d1c79c5e13a672478a0 67e1258c54aaaa3a80096c90 Steve Atherton Steve Atherton stevea1962@gmail.com 016760 17 2025-11-04 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes John Phinney - Kenneth Dave Francisco 2025-11-14 16:38:05 235.6 hrs 68f80d1c79c5e13a6724789f 000024335 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11978 96684d2b631775b3f00e963482775b516b9ef141407a2a7e8f5d07be9667bdde 68dc04cec1e0fa097a517361 67ced4647abf9f3ed8fecfa7 Caroline McClurg Caroline McClurg mcclurg.caroline@gmail.com 010143 34 2025-11-04 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Rosey Reed 2025-11-04 21:13:25 0.2 hrs 68dc04cec1e0fa097a517360 000021619 3.00 80.26 80.26 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11977 9067721b118997fcaf8127727a219203284951e6fbdd0cbc127fcd99781bf7dd 68d6eca2c33e1b22df1a48b5 68d6ebf70e300c08a947e01b Lauren Castleberry Lauren Castleberry luminescence.castleberry@gmail.com 019942 6 2025-11-04 Cancel 67c8f28f945598c08d4245c7 John Phinney 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt graduating! - RAR 10/21 Rosey Reed 2025-10-21 20:35:15 -336.4 hrs 68d6eca2c33e1b22df1a48b0 000021250 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11976 ffb1e05edbb63f0d49a9b4b7c3a7871fdd5c93589eb93f1eae877cb1484bde9d 68bf23283e77990388a55265 68bf1ece4c373c9c32dc0a2d Benjamin Mcchesney Benjamin Mcchesney kmcchesn@gmail.com 019819 40 2025-11-04 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sonya C. 2026-04-07 17:24:02 3692.4 hrs 692e2a62821d12502a723a50 000019059 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11975 8c37ff3fe8d862d5318a1b1695c51bf1910cbef87784c93cc3f7a4201c29dd02 68a48ffdd0c51546d8df781f 67ced47c7abf9f3ed8fed424 Victoria Parks Victoria Parks 23vparks@gmail.com 010526 436 2025-11-04 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Primary - - Yes Sophia L. - Rosey Reed 2025-11-04 20:49:30 -0.2 hrs 691f8b47c874f1699aece259 000016653 4.00 104.99 83.65 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11974 91b90d0ddc4b76efb58b6e6070bb3369116c562c76b259007df583e85c2204b3 68951295279844dd7b623ee2 67ced50c7abf9f3ed8feec86 Lisa Schlarbaum Lisa Schlarbaum lisa.schlarbaum@hopehousecolorado.org 012606 18 2025-11-04 Checked Out 67a17394b9c187ec05aec2d3 Elizabeth Cousins 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Elizabeth Cousins - Kenneth Dave Francisco 2025-11-11 16:19:49 163.3 hrs 691362622c31e6af0d451e9e 000015760 3.00 111.52 111.52 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11973 76b9bfd4021dfb09e56485ecdf8b3e59bdeb93e1f9afdb7d32f133f88f86c5be 68ffb61a49243e474cf24eb9 68daf04bf54f52c823203a51 Vicki Griffin Vicki Griffin vickigriffin11@gmail.com 019956 4 2025-11-04 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a6796904d60ff63526f262 Medicare Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Amie Russell - Sara Thompson 2025-11-04 21:21:45 0.1 hrs 68ffb61a49243e474cf24eb8 000024920 3.00 80.26 80.26 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11972 1494c0ea105f5f43a53c2aa996bae6aabe5ab5571fa1a6a772a25d6d16696228 68fbe160e62c9bf98cc35d6a 67ced43c7abf9f3ed8fec7db Joseph Litwack Joseph Litwack josephlitwack@gmail.com 009478 15 2025-11-04 Cancel 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Sophia L. 24+ pt conf rxl to Sara on 11/6 SL 11/3 Sophia L. 2025-11-03 22:33:55 -22.7 hrs 68fbe160e62c9bf98cc35d69 000024798 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11971 acf0355281cc01f62d25486de2f09d123e5b741c2e9889173dbd62b4bfa0de08 68e57b6d6957fb71132eabd7 68e57af5c6de800a27aad5e0 Ronald Richter Ronald Richter ron.richter4353@gmail.com 020008 6 2025-11-04 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-11-11 18:32:46 165.3 hrs 68e57b6d6957fb71132eabd6 000022602 3.00 93.82 93.82 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11970 b6c4897d2549a215a86782c616b8607ab4fb8e86c9f113d691d4d6c27ac844b1 68db07ff85370d95d999d897 681e1b25ac9489866a5745fb Inge Mcclory Inge Mcclory irmcclory62@msn.com 017211 16 2025-11-04 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. schedule by accident- sc Sonya C. 2025-09-30 16:26:12 -844.8 hrs 68db07ff85370d95d999d896 000021581 3.00 0.00 0.00 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11969 149a774310ba5e0de2f058c478178536041904664437958f67f006f57b09bfc7 68b9f12eab242039becf72fc 67ced40c7abf9f3ed8febe36 Robert Lee Robert Lee rob.lee@gmail.com 008656 87 2025-11-04 Checked Out 67a29eb59b66fa59fd5c2663 Samantha Saunders 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Michelle W. - Rosey Reed 2025-11-04 21:14:57 -0.0 hrs 691b4d6d65fcdb657d20afac 000018771 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11968 e46e93afdd3c6ea79b03c56a8a5fbd2df8d5673ac738529b9daad022f0d2c51c 68b844ac8876a14e9392fd83 6894c8b39e34e408ba5ede59 Gayle Harms Gayle Harms gayleharms@gmail.com 017766 16 2025-11-04 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Michelle W. - Sophia L. 2025-11-04 22:21:59 1.1 hrs 68b844ac8876a14e9392fd82 000018469 2.00 53.11 53.11 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11967 554b9828199fc7804061dcaeac84a9d210d1a632d9253e125b1e2537dea4421e 68a6200ce41064d554da8b77 67ced4647abf9f3ed8fecfa7 Caroline McClurg Caroline McClurg mcclurg.caroline@gmail.com 010143 34 2025-11-04 Cancel 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. - Sonya C. 2025-09-29 22:26:25 -862.8 hrs 68a6200ce41064d554da8b76 000016960 2.00 0.00 0.00 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11966 cfe51ccfdca8a6887cbcabc28c6ed0eba3ec516668a7eb6e69149957be63955f 690236eb688fa18247038c0f 68a8150699c65c4a78a5f043 H Dennis Cohen H Dennis Cohen hdcohen33@gmail.com 018197 8 2025-11-04 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Paid - Patient - - Yes Julie Petersen-Hanson - Frances Lawrence 2025-11-04 22:32:31 1.0 hrs 690236eb688fa18247038c0e 000025207 3.00 81.40 81.40 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11965 777e034f00af32d40268ed03b18f54ade6ac5d190bfcaa077ac7cea277a2d96a 68fa65dcfd411308cc60506c 68f7cf22e617ede5f02b037d Kara Gendron Kara Gendron kara.m.gendron@gmail.com 020115 9 2025-11-04 Checked Out 6899858814e44ebdae34c0b7 Rayann Greer 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Emmie Gebhardt - Rayann Greer 2025-11-04 22:25:46 0.9 hrs 68fa65dcfd411308cc60506b 000024532 4.00 95.71 190.71 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11964 8d2b52d54bd1847575a7cc0e6be3be10d66604323805b038c5b31da914f6f150 68f7b659d3a45d09120a1325 68dc2d1d74d5c2b85eee42b5 Marianne Burnworth Marianne Burnworth larimer.2000@gmail.com 019959 10 2025-11-04 Checked Out 67ace27f67327b083edb451f Michelle Osgood 67a6796904d60ff63526f262 Medicare Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia L. - Sophia L. 2025-11-04 21:25:10 -0.1 hrs 68f7b659d3a45d09120a1324 000024211 3.00 80.26 80.26 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11963 4be0240009a1adc94785b52cbd044b49801531f05ba0d167b558cf715c3bd0de 68e7def484399a66c3ed4cbb 68a8156699c65c4a78a6037b Nellie M Parnell Nellie M Parnell robtandnell@comcast.net 019149 51 2025-11-04 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a6796904d60ff63526f262 Medicare Follow Up 68998453d9ae21be8001ca00 Boulder Julie Unpaid - Unidentified - - No Frances Lawrence waiting to meet with surgon JPH 11/3 Julie Petersen-Hanson 2025-11-03 15:31:52 -30.0 hrs 68e7def484399a66c3ed4cba 000022899 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11962 5974d256e12907275c8bd219a2d99c5ebda366ba3af01d2585c41dc9a903a300 68e531403b8833a7843ab936 68e530c819ff50090531a726 Barbara Harvey Barbara Harvey barbbenedepti51@gmail.com 020002 6 2025-11-04 Checked Out 67c8f28f945598c08d4245c7 John Phinney 67a677acc9d2cdd464577dc6 Initial Evaluation OT/PT 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sophia L. - Kenneth Dave Francisco 2025-11-11 19:38:19 166.1 hrs 68e531403b8833a7843ab935 000022491 6.00 259.81 259.81 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11961 7ac7c8a01827b6ed49e43ca203c607b06ff600f3215ab7eac7fe2ebac0b2332f 685eef9956c24e746f194261 685eec0ea88649740b79a68f Helen Andrews Helen Andrews alleycat@indra.com 017539 88 2025-11-04 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sophia L. - Rosey Reed 2025-11-04 21:38:36 0.1 hrs 685eef9956c24e746f19425d 000011177 3.00 232.00 0.00 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11960 962ebfc956d92d0cfd3da1ac615175d37ff817dcdbbad716b5c3edb1a7961e88 6903b21a0f2f0d097653eaaa 67ced3c77abf9f3ed8feae75 Martina Kastengren Martina Kastengren kastengrenm@gmail.com 007312 39 2025-11-04 Checked Out 67b5021bd1a98807ff4b70c3 Marguerite Barth 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Marguerite Barth - Kenneth Dave Francisco 2025-11-14 20:56:59 239.2 hrs 6903b21a0f2f0d097653eaa9 000025432 4.00 85.00 85.00 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11959 7d5b59a2d7f128ecf8a2779711c407137cbab2ca65cac4a3c56b9be72816ae98 68d2db1e2c0f1108380c2f5e 68d2da67386dc40801be2523 Jasmine Lee Jasmine Lee classyjassygirl@gmail.com 019918 9 2025-11-04 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Sophia L. - Rosey Reed 2025-11-04 21:45:55 0.0 hrs 69e926c9a428cfddbee6452c 000020652 2.00 157.00 0.00 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11958 7b5a44b138b6a1275b294678c2da128b81516b901778581adc12e6f3eb5e984c 690a38eb5d4fb4c20b347e1e 6853201fc4acfac7f74a804b Grete Weiss Grete Weiss gkweiss@comcast.net 017472 17 2025-11-04 Checked Out 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Rosey Reed 2025-11-04 21:58:57 -0.0 hrs 690a8a8385567516fcd9436d 000025912 2.00 56.79 56.79 - - - - - - - - 2026-02-19 22:55:40 2026-05-06 23:21:40
11957 1a6acc829d45cc981c2c2157e794ca63474f5c8795ef00b4fc8070714c23751f 68ffc58c83e071865425fb03 68dec5ef5e4e3908b63bdcb7 Leif Swenson Leif Swenson leifmswenson@gmail.com 019977 16 2025-11-04 Checked Out 689a30c929b2b7d86495c1c4 Amie Russell 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2025-11-10 20:18:49 142.3 hrs 68ffc58c83e071865425fb02 000024937 4.00 85.00 85.00 - - - - - - - - 2026-02-19 22:55:39 2026-05-06 23:21:40
11956 e055e234ac795eb1a22934676e1f158dd4e19cae8a8c00593343d44e6d035413 68faa2ef955a7f4fd764dd3b 67ced36c7abf9f3ed8fe94c5 Jean Goodall Jean Goodall jj.goodall54@gmail.com 005120 16 2025-11-04 Checked Out 67ace224d9ba6008ac94ea05 Stephanie Braun 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Stephanie Braun - Jayson Encarnacion 2025-11-17 16:57:02 307.0 hrs 68faa2ef955a7f4fd764dd3a 000024616 3.00 60.00 60.00 - - - - - - - - 2026-02-19 22:55:39 2026-05-06 23:21:40