General Visit (PT Boulder API)

Total rows: 100,380
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
9593 7a519afbc709d3149f8099d2a113e6fc3fe3b7413dc4ece4b44348d096f7a6a5 6893c3394b76da5b183eb35d 67ced3487abf9f3ed8fe8867 Lois Edgar Lois Edgar edgar@colorado.edu 004065 236 2025-11-24 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Partially Paid - Secondary - - Yes Maia H. - Sophia L. 2025-11-24 22:11:30 0.2 hrs 69499cec2fe58128fb05c327 000015594 3.00 80.65 64.26 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9592 71e617631d3963e3b9d0e5695148382ea7d31c2be0f0489a1c58d98c58f4fc9b 690d28fa949883b791eea5d7 68af4ba0023471867510ced6 Braedi Tagart Braedi Tagart tagarts@comcast.net 019764 17 2025-11-24 Checked Out 689a313a77dba4d845e313cf Sara Thompson 67a678d8c9d2cdd4645788f0 Follow Up 6899826579e412ce7c3dfae1 Broomfield Paid - Patient - - Yes Frances Lawrence - Sara Thompson 2025-11-23 22:24:08 -23.8 hrs 690d28fa949883b791eea5d6 000026361 3.00 82.00 82.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9591 a5f46f0768f6a4988ebd95fc6062736808cea47d5b415093b0cfeadecdba3491 68f107f1406551e167932d28 68d6b6dd81f7d675e614c847 Stephanie Maltarich Stephanie Maltarich smaltarich@gmail.com 019940 17 2025-11-24 Checked Out 67accd974e54de07d58ca3ee Sophia Phillips 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a12995018ea3fd2c5731 Lafayette Paid - Patient - - Yes Sophia Phillips - Jayson Encarnacion 2025-11-26 21:37:12 47.4 hrs 68f107f1406551e167932d27 000023731 4.00 85.00 85.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9590 794b98e84920d4dab618cdc3d8d69f8d3bca8cd2569093f9840a0f015f53ad38 68eeaf8b2c60098c0000a8e4 67ced3737abf9f3ed8fe972c Anne Harris-Cross Anne Harris-Cross aharriscross30@gmail.com 005325 36 2025-11-24 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Partially Paid - Patient - - Yes Rosey Reed - Kenneth Dave Francisco 2025-11-26 16:34:32 42.3 hrs 68eeaf8b2c60098c0000a8e3 000023436 3.00 82.00 52.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9589 d1d91cb011126ed534506cbc9bfaef45da14ab006a234a01d53d3bd6ff9b5307 691260e7f4dc2cfafbda5432 68e96b0678a5da0a09c42b09 Deborah Cusa Deborah Cusa debcusa@gmail.com 020049 2 2025-11-24 Checked Out 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Partially Paid - Patient - - Yes Julie Petersen-Hanson - Kenneth Dave Francisco 2025-12-03 18:41:49 211.9 hrs 691260e7f4dc2cfafbda5431 000026615 3.00 85.00 35.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9588 a64a9185ba2c1ffe3069ba14f06cc5d346888726ca68fcf81c3dab18f61b3768 68f67bcfcc243d5953849ea8 68363eb7ac3067084a491c22 Katherine Le Bel Katherine Le Bel katehopelebel@gmail.com 017320 66 2025-11-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Primary - - Yes Rosey Reed - Sophia L. 2025-11-24 22:48:31 0.1 hrs 69c5cd3165b49a253967c85e 000024051 3.00 237.00 0.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9587 c3c2c1f4a7f22e10d018a116a98ab14a484337103e71dfa2334737a65509cb9f 68df0092f60dfe34406e2fb5 68deffbf040cf06246ab7301 Abby Howard Abby Howard howard.abby@gmail.com 019984 7 2025-11-24 Cancel 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ pt doesn't need weekly appts - RAR 10/15 Rosey Reed 2025-10-15 21:54:52 -960.8 hrs 68df0092f60dfe34406e2fb0 000022129 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9586 c12b946fb0ee4b32808847b28584bd2ad9434e6a21706dde741aeba90caa76ad 68def062fd11d9d469938a1f 67ced49e7abf9f3ed8feda36 Elizabeth Nevers Elizabeth Nevers eileenlistens@gmail.com 011044 128 2025-11-24 Checked Out 67a3c1c3d8b9514e4335442c Miranda Samson 68badb44ddf8174376b86bb9 Pelvic Floor Follow up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Emmie Gebhardt - Sonya C. 2025-11-24 22:32:48 -0.2 hrs 68def062fd11d9d469938a1e 000022112 1.00 32.46 32.46 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9585 55cd13b70a206c858fbbe9ca20db797e38c1d03a586ed5f0bea24234cba52ce0 68f79a14ee2e3f08e5e09aa7 67ced5f77abf9f3ed8ff0dff Molly Teas Molly Teas mmteas@gmail.com 015461 121 2025-11-24 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt conf cxl SL 11/20 - can't make it from Denver in time Sophia L. 2025-11-20 16:15:50 -102.7 hrs 68f79a14ee2e3f08e5e09aa6 000024137 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9584 f288f60fcf161e92a2a9af2ecceef8790ec2bc8fee07aa972fe4c340d4d4ea17 68ed80b5d91182f959804684 67ced2f77abf9f3ed8fe647b Patricia Carmichael Patricia Carmichael carmichael_patricia@svvsd.org 001000 32 2025-11-24 Cancel 68279a04a8986a07d3dc3495 Emily Pickner 67a67a90213226f6552a9bea KAISER FOLLOW UP 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. - Sonya C. 2025-10-13 22:44:27 -1008.3 hrs 68ed80b5d91182f959804682 000023268 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9583 3e657f35cbea8385ca9e6262447ec32724baf5f1b96293487e0048bfabb797af 68cc5c0f8a4df7d262e17db7 67ced3017abf9f3ed8fe6a63 Dundeen Catlin Dundeen Catlin dundeen.catlin@gmail.com 001504 239 2025-11-24 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Laura Shove - Sophia L. 2025-11-25 22:19:33 23.3 hrs 68cc5c0f8a4df7d262e17db6 000020173 3.00 83.09 83.09 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9582 229ecc615989e644c41a417cc59eacab729e10d5e6b9aa45d4e6d40f43bb3b0d 6888eb8949ea90083c5d5678 68373ff77dfd39d6d490641b Laura Appelbaum Laura Appelbaum laurarappelbaum@gmail.com 017326 32 2025-11-24 Cancel 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ OOT - sc Sonya C. 2025-09-09 20:57:07 -1826.0 hrs 6888eb8949ea90083c5d5674 000014578 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9581 0a71f5a673a59b0146d62bcc13af374659a1728fa5db2b2b8d8e995cffe02eef 691d4f5039767258525cdee9 68c96968fde2a18396e28210 Erin Johnson Erin Johnson erinhjohnson@gmail.com 019865 9 2025-11-24 Cancel 68997fb447d07b4ee3a1ca88 Julie Petersen-Hanson 67a678d8c9d2cdd4645788f0 Follow Up 67a2a12995018ea3fd2c5731 Lafayette Unpaid - Unidentified - - No Julie Petersen-Hanson scheduling conflict Julie Petersen-Hanson 2025-11-24 02:06:53 -21.1 hrs 691d4f5039767258525cdee8 000027703 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9580 f1007f6e1ee5e88b693be6b80d29959496ad418953c23fc9a6580a6a0ea8f042 68f8f2104673fb0a4ef2b5ec 67ced3b27abf9f3ed8fea908 Veronica Johnston Veronica Johnston veronica.johnston@bvsd.org 006849 30 2025-11-24 Checked Out 67ace2f78cd4840786a476a8 Peter Gagnon 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Rosey Reed - Sophia L. 2025-11-26 15:40:07 40.4 hrs 68f8f2104673fb0a4ef2b5eb 000024360 2.00 100.00 100.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9579 a5f30326c631092a9c889fc9e131e2400e2d0af618b4f5f4caac284bf35afe9c 68e555c7147c7897cc8b1613 68e554179957ee09f0cc7118 Kristen Brohm Kristen Brohm kristenbrohm@gmail.com 020005 35 2025-11-24 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-24 23:10:43 -0.1 hrs 68e555c7147c7897cc8b1610 000022544 3.00 85.00 85.00 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9578 9471c26a75a228b6da99f7fcd622ae9967462de65a8e8c177f8bb91d0ea06ba1 68c9d7bfddc57d0670f5eb50 68c9d69fb1980b077ac77995 Philip Griffin Philip Griffin Phil.griffiin99@gmail.com 019880 9 2025-11-24 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a6796904d60ff63526f262 Medicare Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sonya C. 2025-11-24 23:30:40 -0.2 hrs 68c9d7bfddc57d0670f5eb4f 000019976 3.00 78.70 78.70 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9577 faaaa4be7a9e472449a04f6185e0f0dd186c2ffcddb85b8838331af2b4537ab3 68a8afd8845721aac9667390 67ced2fc7abf9f3ed8fe67ba Debra Bond Debra Bond dbondo@comcast.net 001277 111 2025-11-24 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Sonya C. - Sophia L. 2025-11-25 22:19:36 22.6 hrs 68a8afd8845721aac966738f 000017270 3.00 78.70 78.70 - - - - - - - - 2026-02-19 22:48:45 2026-05-04 23:14:06
9866 cc90b3330a7ecc39def0078a6c5e0beeb94ab38914b65e38a2d0fba29b71d3e1 690defa5d1cfe8938bf0de8a 67ced3c17abf9f3ed8feacd4 Katherine Kaminski Katherine Kaminski khkaminski@gmail.com 007173 133 2025-11-21 Checked Out 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Sophia L. 2025-11-21 18:29:10 18.5 hrs 690defa5d1cfe8938bf0de89 000026386 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:49:47 2026-05-04 23:14:48
9865 c84b467b66c30311f6d7e7bfad09f786e13b13c1d27e1e97ccafa161baf8acc8 68fbce190d0fe80d96229cac 67ced30a7abf9f3ed8fe6f28 Garrett Arendt Garrett Arendt gaarendt@gmail.com 001911 5 2025-11-21 Cancel 68535c6303dd08c79c018795 John Reed 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Unpaid - Unidentified - - No Sonya C. 24+ pt called and requested that we cancel appts- did not state a reason- sc Sonya C. 2025-10-29 19:47:51 -532.2 hrs 68fbce190d0fe80d96229cab 000024772 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:47 2026-05-04 23:14:48
9864 a4187345025eed8aed41bb3d5a8fe502e7e75441ce3d731a184748243399b35a 68f262ffae502f08ad734605 68f2621eb72986f10f1c33e8 Sina Anderson Sina Anderson neil.anderson@bvsd.org 020096 11 2025-11-21 Checked Out 68279a04a8986a07d3dc3495 Emily Pickner 67a678d8c9d2cdd4645788f0 Follow Up 67a2a0045c4b0cd527adf872 Longmont Paid - Patient - - Yes Sonya C. - Emily Pickner 2025-11-21 00:37:06 0.6 hrs 68f262ffae502f08ad7345fc 000023870 3.00 100.00 100.00 - - - - - - - - 2026-02-19 22:49:47 2026-05-04 23:14:48
9863 08c7ae30f9ac045fa41dcbbd341ae78a700fe5103d02b1c902554e49650c381f 68e9166be581cd08aa77060e 68a3ad1fba7b930889ba494a Saturnino Arellano Saturnino Arellano arellano.salas07@gmail.com 017820 10 2025-11-21 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:43 -747.1 hrs 68e9166be581cd08aa77060b 000023020 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:47 2026-05-04 23:14:48
9862 882794360ccb8aa0d6c952c55e7f062ff4055f83883dd05e420db07281899426 68911502e6efb17aca6d6fc9 67ced37e7abf9f3ed8fe9a80 Amelia Greacen Amelia Greacen mollygreacen@womanmedicine.com 005609 94 2025-11-21 Checked Out 67ace2bb7bc1a911a084fa01 Laura Shove 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Paid - Patient - - Yes Maia H. - Sophia L. 2025-11-21 14:46:56 14.8 hrs 68911502e6efb17aca6d6fc6 000015291 3.00 78.70 78.70 - - - - - - - - 2026-02-19 22:49:47 2026-05-04 23:14:48
9861 c989e796d0a118569cf5f9872337bfc01d5728e0ea0ad525481acc097675192b 68eee3a2c22a9e2d63bcfa48 68a5e4d825566307d108fe49 William Lucca William Lucca cblucca@msn.com 017831 23 2025-11-21 Cancel 689a30c929b2b7d86495c1c4 Amie Russell 67a67a76b7ce97078f5c5436 ASH (CIGNA) FOLLOW UP 6899826579e412ce7c3dfae1 Broomfield Unpaid - Unidentified - - No Amie Russell getting manipulation 11/25 so saving apts for after. Amie Russell 2025-11-21 01:19:57 1.1 hrs 68eee3a2c22a9e2d63bcfa41 000023509 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:47 2026-05-04 23:14:48
9860 8ab465669188f0ed7e9b39221b2718d3bd4b79703f25293a9998d2f3403e2cb7 68eeb50684f436099ed4fec3 67ced38e7abf9f3ed8fe9f72 Gale Held Gale Held gale.held@gmail.com 006031 4 2025-11-21 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a6796904d60ff63526f262 Medicare Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sophia L. 24+ she fell and tore her MCL - sc Sonya C. 2025-11-12 19:35:49 -196.7 hrs 68eeb50684f436099ed4fec2 000023443 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:47 2026-05-04 23:14:48
9859 40eee11a2f180a0dc7ae288e2ef7ef0cb0954c15f767ab8f49db9aaf7d4547be 68d6b4895005cc097b696c65 68d6b100d9e678751d4db377 Aiden Hanley Aiden Hanley lessleyc@gmail.com 019939 17 2025-11-21 Cancel 67acc4530db5de07addc9873 Anne Majewski 67a678d8c9d2cdd4645788f0 Follow Up 679aeda44d561307f6600a72 Boulder Suite 330 Unpaid - Unidentified - - No Sonya C. 24+ wants to stay w/ Jack- sc Sonya C. 2025-10-14 19:37:59 -892.6 hrs 68d6b4895005cc097b696c64 000021178 0.00 0.00 0.00 - - - - - - - - 2026-02-19 22:49:47 2026-05-04 23:14:48