{"shop":{"id":"demo","name":"Soundboard & Temperament RPT","timeZone":"America/New_York","isDemo":true,"accessCode":"","updatedAt":"2026-10-20T00:00:00.000Z"},"staff":[{"id":"298f61bc-936d-498a-97ae-b1343294f801","name":"Clara Vance, RPT","role":"technician"},{"id":"34e349c6-e906-4955-a056-afa006941b59","name":"Julian Mercer, RPT","role":"owner"}],"services":[{"id":"svc_regulation","name":"Action Regulation & Voicing","durationMin":120,"basePriceCents":24000,"priceMode":"piano_type"},{"id":"svc_pitch_raise","name":"Pitch Raise + Fine Tuning","durationMin":105,"basePriceCents":20500,"priceMode":"piano_type"},{"id":"svc_fine_tuning","name":"Fine Tuning (A440)","durationMin":75,"basePriceCents":16000,"priceMode":"piano_type"},{"id":"svc_dampp_chaser","name":"Dampp-Chaser Service","durationMin":30,"basePriceCents":6500,"priceMode":"flat"}],"clients":[{"id":"67c94184-5e3d-4d14-8404-90fa0d2d0a6c","name":"David Sterling","phone":"(212) 555-0144","email":"david.sterling@manhattanschool.test","address":"310 Riverside Dr, Apt 7B, New York, NY","zipCode":"10025","notes":"Piano faculty studio. Prefers morning tuning sessions between masterclasses.","createdAt":"2026-10-27T07:07:04.514Z"},{"id":"daab3946-c96c-4ded-a03b-4f650a8db3ad","name":"Miriam Chen","phone":"(212) 555-0182","email":"m.chen@columbia.test","address":"540 W 112th St, New York, NY","zipCode":"10025","notes":"Residential piano in living room parlor. Bench and key cover ready; ring bell on arrival.","createdAt":"2026-10-27T07:07:04.522Z"},{"id":"2b6215ef-7560-43cb-bdab-3c6415cd5e68","name":"St. Jude Lutheran Church","phone":"(212) 555-0199","email":"music@stjudelutheran.test","address":"145 E 86th St, New York, NY","zipCode":"10028","notes":"Sanctuary grand. High winter draft near chancel. Missed previous service without notice.","createdAt":"2026-10-27T07:07:04.526Z"}],"pianos":[{"id":"a14d5217-1293-487d-89c9-1047bcb7ed66","clientId":"daab3946-c96c-4ded-a03b-4f650a8db3ad","make":"Baldwin","model":"Hamilton","serialNumber":"412903","pianoType":"console","yearBuilt":1994,"hasHumidityControl":false,"lastCentsOffset":-18,"locationRoom":"Living Room","createdAt":"2026-10-27T07:07:04.524Z"},{"id":"169e8c29-72fe-4ffe-9d7c-a551adfd2742","clientId":"2b6215ef-7560-43cb-bdab-3c6415cd5e68","make":"Kawai","model":"KG-2D","serialNumber":"1834211","pianoType":"baby_grand","yearBuilt":1988,"hasHumidityControl":true,"lastCentsOffset":-28,"locationRoom":"Sanctuary","createdAt":"2026-10-27T07:07:04.529Z"},{"id":"6813ace3-470a-458c-b3e6-699f7d7cf8a6","clientId":"67c94184-5e3d-4d14-8404-90fa0d2d0a6c","make":"Steinway & Sons","model":"Model B","serialNumber":"582410","pianoType":"concert_grand","yearBuilt":2008,"hasHumidityControl":true,"lastCentsOffset":-4.5,"locationRoom":"Main Studio Room","createdAt":"2026-10-27T07:07:04.517Z"},{"id":"481417d4-48fd-4e07-a02c-564815f08747","clientId":"67c94184-5e3d-4d14-8404-90fa0d2d0a6c","make":"Yamaha","model":"U1","serialNumber":"H319842","pianoType":"studio_upright","yearBuilt":2015,"hasHumidityControl":false,"lastCentsOffset":-12,"locationRoom":"Practice Alcove","createdAt":"2026-10-27T07:07:04.519Z"}],"appointments":[{"id":"e6b0bf22-16bb-4cba-8ba1-d0f33e553e82","clientId":"67c94184-5e3d-4d14-8404-90fa0d2d0a6c","clientName":"David Sterling","phone":"(212) 555-0144","email":"david.sterling@manhattanschool.test","address":"310 Riverside Dr, Apt 7B, New York, NY","zipCode":"10025","clientNotes":"Piano faculty studio. Prefers morning tuning sessions between masterclasses.","pianoId":"6813ace3-470a-458c-b3e6-699f7d7cf8a6","make":"Steinway & Sons","model":"Model B","serialNumber":"582410","pianoType":"concert_grand","yearBuilt":2008,"hasHumidityControl":true,"lastCentsOffset":-4.5,"locationRoom":"Main Studio Room","staffId":"34e349c6-e906-4955-a056-afa006941b59","staffName":"Julian Mercer, RPT","serviceId":"svc_fine_tuning","serviceName":"Fine Tuning (A440)","startAt":"2026-03-01T14:30:00.000Z","durationMin":105,"priceCents":21600,"status":"completed","notes":"","risk":"low","createdAt":"2026-10-27T07:07:04.534Z"},{"id":"35ab2e91-bbc9-4195-9dc0-0cf9ee7c1ef7","clientId":"67c94184-5e3d-4d14-8404-90fa0d2d0a6c","clientName":"David Sterling","phone":"(212) 555-0144","email":"david.sterling@manhattanschool.test","address":"310 Riverside Dr, Apt 7B, New York, NY","zipCode":"10025","clientNotes":"Piano faculty studio. Prefers morning tuning sessions between masterclasses.","pianoId":"481417d4-48fd-4e07-a02c-564815f08747","make":"Yamaha","model":"U1","serialNumber":"H319842","pianoType":"studio_upright","yearBuilt":2015,"hasHumidityControl":false,"lastCentsOffset":-12,"locationRoom":"Practice Alcove","staffId":"34e349c6-e906-4955-a056-afa006941b59","staffName":"Julian Mercer, RPT","serviceId":"svc_fine_tuning","serviceName":"Fine Tuning (A440)","startAt":"2026-05-20T15:00:00.000Z","durationMin":85,"priceCents":16800,"status":"completed","notes":"Practice room U1 seasonal tuning.","risk":"low","createdAt":"2026-10-27T07:07:04.573Z"},{"id":"cd2f8d9d-5773-467a-8a9e-36df0408ee2c","clientId":"67c94184-5e3d-4d14-8404-90fa0d2d0a6c","clientName":"David Sterling","phone":"(212) 555-0144","email":"david.sterling@manhattanschool.test","address":"310 Riverside Dr, Apt 7B, New York, NY","zipCode":"10025","clientNotes":"Piano faculty studio. Prefers morning tuning sessions between masterclasses.","pianoId":"6813ace3-470a-458c-b3e6-699f7d7cf8a6","make":"Steinway & Sons","model":"Model B","serialNumber":"582410","pianoType":"concert_grand","yearBuilt":2008,"hasHumidityControl":true,"lastCentsOffset":-4.5,"locationRoom":"Main Studio Room","staffId":"34e349c6-e906-4955-a056-afa006941b59","staffName":"Julian Mercer, RPT","serviceId":"svc_fine_tuning","serviceName":"Fine Tuning (A440)","startAt":"2026-06-29T13:30:00.000Z","durationMin":105,"priceCents":21600,"status":"completed","notes":"","risk":"low","createdAt":"2026-10-27T07:07:04.555Z"},{"id":"650516a8-1c65-4be7-b718-365f1d20e5bb","clientId":"2b6215ef-7560-43cb-bdab-3c6415cd5e68","clientName":"St. Jude Lutheran Church","phone":"(212) 555-0199","email":"music@stjudelutheran.test","address":"145 E 86th St, New York, NY","zipCode":"10028","clientNotes":"Sanctuary grand. High winter draft near chancel. Missed previous service without notice.","pianoId":"169e8c29-72fe-4ffe-9d7c-a551adfd2742","make":"Kawai","model":"KG-2D","serialNumber":"1834211","pianoType":"baby_grand","yearBuilt":1988,"hasHumidityControl":true,"lastCentsOffset":-28,"locationRoom":"Sanctuary","staffId":"34e349c6-e906-4955-a056-afa006941b59","staffName":"Julian Mercer, RPT","serviceId":"svc_fine_tuning","serviceName":"Fine Tuning (A440)","startAt":"2026-10-06T18:00:00.000Z","durationMin":120,"priceCents":22900,"status":"no_show","notes":"Annual sanctuary tuning.","risk":"high","createdAt":"2026-10-27T07:07:04.588Z"},{"id":"831a4449-edc3-408e-a469-c772b3cd6f4f","clientId":"67c94184-5e3d-4d14-8404-90fa0d2d0a6c","clientName":"David Sterling","phone":"(212) 555-0144","email":"david.sterling@manhattanschool.test","address":"310 Riverside Dr, Apt 7B, New York, NY","zipCode":"10025","clientNotes":"Piano faculty studio. Prefers morning tuning sessions between masterclasses.","pianoId":"6813ace3-470a-458c-b3e6-699f7d7cf8a6","make":"Steinway & Sons","model":"Model B","serialNumber":"582410","pianoType":"concert_grand","yearBuilt":2008,"hasHumidityControl":true,"lastCentsOffset":-4.5,"locationRoom":"Main Studio Room","staffId":"34e349c6-e906-4955-a056-afa006941b59","staffName":"Julian Mercer, RPT","serviceId":"svc_fine_tuning","serviceName":"Fine Tuning (A440)","startAt":"2026-10-27T13:30:00.000Z","durationMin":105,"priceCents":21600,"status":"booked","notes":"Seasonal pre-recital fine tuning (A440).","risk":"low","createdAt":"2026-10-27T07:07:04.594Z"},{"id":"9e617818-b5f9-4ec2-8cea-1a30eeea450e","clientId":"daab3946-c96c-4ded-a03b-4f650a8db3ad","clientName":"Miriam Chen","phone":"(212) 555-0182","email":"m.chen@columbia.test","address":"540 W 112th St, New York, NY","zipCode":"10025","clientNotes":"Residential piano in living room parlor. Bench and key cover ready; ring bell on arrival.","pianoId":"a14d5217-1293-487d-89c9-1047bcb7ed66","make":"Baldwin","model":"Hamilton","serialNumber":"412903","pianoType":"console","yearBuilt":1994,"hasHumidityControl":false,"lastCentsOffset":-18,"locationRoom":"Living Room","staffId":"34e349c6-e906-4955-a056-afa006941b59","staffName":"Julian Mercer, RPT","serviceId":"svc_pitch_raise","serviceName":"Pitch Raise + Fine Tuning","startAt":"2026-10-27T17:00:00.000Z","durationMin":135,"priceCents":25000,"status":"booked","notes":"Pitch raise pull needed; instrument sitting flat since winter.","risk":"medium","createdAt":"2026-10-27T07:07:04.598Z"}],"reminders":[{"id":"fdc9be03-3a62-4985-a128-fe9bf605fdeb","appointmentId":"9e617818-b5f9-4ec2-8cea-1a30eeea450e","channel":"email","status":"sent","recipient":"m.chen@columbia.test","subject":"Upcoming Piano Tuning: Baldwin Hamilton","body":"Hi Miriam Chen,\n\nYour piano tuning for the Baldwin Hamilton is scheduled on 2026-10-27T17:00:00.000Z with Julian Mercer, RPT.\n\nUnsubscribe: https://tuningledger.com/unsubscribe","provider":"email-outbox","createdAt":"2026-10-27T08:08:46.192Z"},{"id":"077395d8-bc48-4542-b768-75fe860bacac","appointmentId":"9e617818-b5f9-4ec2-8cea-1a30eeea450e","channel":"sms","status":"stubbed","recipient":"(212) 555-0182","subject":"Upcoming Piano Tuning: Baldwin Hamilton","body":"Hi Miriam Chen,\n\nYour piano tuning for the Baldwin Hamilton is scheduled on 2026-10-27T17:00:00.000Z with Julian Mercer, RPT.\n\nUnsubscribe: https://tuningledger.com/unsubscribe","provider":"sms-stub","createdAt":"2026-10-27T08:08:46.192Z"},{"id":"7cc21b15-9c73-467f-8ba2-5d5948f1223e","appointmentId":"831a4449-edc3-408e-a469-c772b3cd6f4f","channel":"email","status":"sent","recipient":"david.sterling@manhattanschool.test","subject":"Upcoming Piano Tuning: Steinway & Sons Model B","body":"Hi David Sterling,\n\nYour piano tuning for the Steinway & Sons Model B is scheduled on 2026-10-27T13:30:00.000Z with Julian Mercer, RPT.\n\nUnsubscribe: https://tuningledger.com/unsubscribe","provider":"email-outbox","createdAt":"2026-10-27T08:08:46.191Z"},{"id":"ec81ecbd-c446-43cf-a5c0-6c97c619c4f1","appointmentId":"831a4449-edc3-408e-a469-c772b3cd6f4f","channel":"sms","status":"stubbed","recipient":"(212) 555-0144","subject":"Upcoming Piano Tuning: Steinway & Sons Model B","body":"Hi David Sterling,\n\nYour piano tuning for the Steinway & Sons Model B is scheduled on 2026-10-27T13:30:00.000Z with Julian Mercer, RPT.\n\nUnsubscribe: https://tuningledger.com/unsubscribe","provider":"sms-stub","createdAt":"2026-10-27T08:08:46.191Z"}],"payments":[{"id":"846318c6-3b95-4dd6-885a-4a0e3e59efd6","appointmentId":"e6b0bf22-16bb-4cba-8ba1-d0f33e553e82","amountCents":21600,"tipCents":0,"method":"card","note":"Paid by card on file","createdAt":"2026-10-27T07:07:04.538Z"},{"id":"56c2e46f-2835-49bb-9887-2c79d8edd757","appointmentId":"cd2f8d9d-5773-467a-8a9e-36df0408ee2c","amountCents":21600,"tipCents":0,"method":"card","note":"Paid by card on file","createdAt":"2026-10-27T07:07:04.557Z"},{"id":"bb06bfee-c2b1-48c4-bd38-578e853fd051","appointmentId":"35ab2e91-bbc9-4195-9dc0-0cf9ee7c1ef7","amountCents":16800,"tipCents":0,"method":"card","note":"Paid by card on file","createdAt":"2026-10-27T07:07:04.576Z"}],"notes":[{"id":"cfad6d65-c57a-4b55-9ac1-b54ef1b03a6d","appointmentId":"e6b0bf22-16bb-4cba-8ba1-d0f33e553e82","pianoId":"6813ace3-470a-458c-b3e6-699f7d7cf8a6","initialCentsOffset":-5,"finalTargetHz":440,"pitchRaiseRequired":false,"relativeHumidityPct":42,"pinblockCondition":"tight","summary":"Steinway & Sons Model B (concert_grand): Fine Tuning (A440). Initial pitch -5 cents, brought to A440Hz. Pitch was -5 cents flat after heating shutoff.","clientCareNote":"Maintain room humidity between 40% and 50% RH. Keep piano away from exterior drafts, heating radiators, and direct sunlight.","cautionsForNextVisit":"Standard semi-annual fine tuning maintenance.","observations":"Pitch was -5 cents flat after heating shutoff. Fine tuned to A440.","provider":"pitchledger-notes","createdAt":"2026-10-27T07:07:04.548Z"},{"id":"94224346-6429-41bc-ba0b-f0375fa57eda","appointmentId":"cd2f8d9d-5773-467a-8a9e-36df0408ee2c","pianoId":"6813ace3-470a-458c-b3e6-699f7d7cf8a6","initialCentsOffset":-4.5,"finalTargetHz":440,"pitchRaiseRequired":false,"relativeHumidityPct":44,"pinblockCondition":"tight","summary":"Steinway & Sons Model B (concert_grand): Fine Tuning (A440). Initial pitch -4.5 cents, brought to A440Hz. Dampp-Chaser functioning well.","clientCareNote":"Maintain room humidity between 40% and 50% RH. Keep piano away from exterior drafts, heating radiators, and direct sunlight.","cautionsForNextVisit":"Check Dampp-Chaser pads and clean humidistat sensor during next maintenance.","observations":"Dampp-Chaser functioning well. Pitch stable at -4.5 cents.","provider":"pitchledger-notes","createdAt":"2026-10-27T07:07:04.566Z"},{"id":"26d275f7-df18-4ebf-bc7a-58002a5e8c44","appointmentId":"35ab2e91-bbc9-4195-9dc0-0cf9ee7c1ef7","pianoId":"481417d4-48fd-4e07-a02c-564815f08747","initialCentsOffset":-12,"finalTargetHz":440,"pitchRaiseRequired":false,"relativeHumidityPct":42,"pinblockCondition":"normal","summary":"Yamaha U1 (studio_upright): Fine Tuning (A440). Initial pitch -12 cents, brought to A440Hz. Practice room U1 tuned to A440.","clientCareNote":"Maintain room humidity between 40% and 50% RH. Keep piano away from exterior drafts, heating radiators, and direct sunlight.","cautionsForNextVisit":"Standard semi-annual fine tuning maintenance.","observations":"Practice room U1 tuned to A440. Pinblock normal, RH 42%.","provider":"pitchledger-notes","createdAt":"2026-10-27T07:07:04.581Z"}],"suggestions":[{"id":"09050462-1ee6-43b3-82ba-c2e89d8b62cf","sourceAppointmentId":"e6b0bf22-16bb-4cba-8ba1-d0f33e553e82","pianoId":"6813ace3-470a-458c-b3e6-699f7d7cf8a6","staffId":"34e349c6-e906-4955-a056-afa006941b59","serviceId":"svc_fine_tuning","suggestedStartAt":"2026-06-29T13:30:00.000Z","durationMin":105,"priceCents":21600,"intervalDays":120,"pitchInstabilityRisk":"low","reason":"Next tuning in 120 days, based on concert_grand seasonal drift and stability defaults. Instrument pitch stability is good.","status":"dismissed","acceptedAppointmentId":null,"provider":"pitchledger-schedule","createdAt":"2026-10-27T07:07:04.548Z"},{"id":"0d08797e-5973-403b-b9ff-7531cf1d3a13","sourceAppointmentId":"cd2f8d9d-5773-467a-8a9e-36df0408ee2c","pianoId":"6813ace3-470a-458c-b3e6-699f7d7cf8a6","staffId":"34e349c6-e906-4955-a056-afa006941b59","serviceId":"svc_fine_tuning","suggestedStartAt":"2026-10-27T13:30:00.000Z","durationMin":105,"priceCents":21600,"intervalDays":120,"pitchInstabilityRisk":"low","reason":"Next tuning in 120 days, based on concert_grand seasonal drift and stability defaults. Instrument pitch stability is good.","status":"dismissed","acceptedAppointmentId":null,"provider":"pitchledger-schedule","createdAt":"2026-10-27T07:07:04.566Z"},{"id":"57d3c1ca-3b35-4b08-b95a-518abf40bed4","sourceAppointmentId":"35ab2e91-bbc9-4195-9dc0-0cf9ee7c1ef7","pianoId":"481417d4-48fd-4e07-a02c-564815f08747","staffId":"34e349c6-e906-4955-a056-afa006941b59","serviceId":"svc_fine_tuning","suggestedStartAt":"2026-10-17T15:00:00.000Z","durationMin":85,"priceCents":16800,"intervalDays":150,"pitchInstabilityRisk":"low","reason":"Next tuning in 150 days, based on studio_upright seasonal drift and stability defaults. Instrument pitch stability is good.","status":"dismissed","acceptedAppointmentId":null,"provider":"pitchledger-schedule","createdAt":"2026-10-27T07:07:04.581Z"}]}