{"data":[{"id":"043c1828-2fb1-4067-a598-632a556f4c2e","pdf_url":null,"version":1,"pdf_path":"generated://redfish/estimate/761fa914-7bd6-4b2c-9548-e4b2c4a08fa3/v1","created_at":"2026-08-31T23:14:14.731873+00:00","estimate_id":"761fa914-7bd6-4b2c-9548-e4b2c4a08fa3","report_data":{"demo":true,"status":"approved","squares":24.2,"roof_type":"Architectural Shingles","line_items":[{"unit":"SQ","total":3146,"quantity":24.2,"item_code":"SHG_ARCH","unit_price":130,"description":"Architectural shingles"},{"unit":"SQ","total":1089,"quantity":24.2,"item_code":"UND_SYNTH","unit_price":45,"description":"Synthetic underlayment"},{"unit":"SQ","total":340,"quantity":4,"item_code":"ICE_SHIELD","unit_price":85,"description":"Ice and water shield"},{"unit":"SQ","total":193.6,"quantity":24.2,"item_code":"NAILS","unit_price":8,"description":"Roofing fasteners"},{"unit":"SQ","total":1815,"quantity":24.2,"item_code":"LAB_INSTALL","unit_price":75,"description":"Shingle installation"},{"unit":"SQ","total":1210,"quantity":24.2,"item_code":"LAB_TEAROFF","unit_price":50,"description":"Single-layer tear-off"},{"unit":"SQ","total":605,"quantity":24.2,"item_code":"DUMP_FEE","unit_price":25,"description":"Disposal and dump fee"},{"unit":"EA","total":350,"quantity":1,"item_code":"PERMIT","unit_price":350,"description":"Building permit allowance"}],"estimate_id":"761fa914-7bd6-4b2c-9548-e4b2c4a08fa3","approval_status":"approved","total_job_price":12239.06,"property_address":"100 Redfish Demo Way"},"report_type":"estimate_summary","generated_at":"2026-08-31T23:14:14.731873+00:00","generated_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","tenant_org_id":"de8369b6-a78f-40bb-ae1f-28ffca62bc7e","file_size_bytes":null},{"id":"f0a18899-0aae-4d55-971c-5c492972816a","pdf_url":null,"version":1,"pdf_path":"generated://redfish/estimate/34a5f107-b5b1-4d4c-8e24-9e983517a5de/v1","created_at":"2026-08-31T23:14:14.731873+00:00","estimate_id":"34a5f107-b5b1-4d4c-8e24-9e983517a5de","report_data":{"demo":false,"status":"draft","squares":44.9,"roof_type":"Architectural Shingles","line_items":[{"unit":"SQ","total":5837,"source":"redfish_price_book","category":"material","quantity":44.9,"item_code":"SHG_ARCH","unit_price":130,"description":"Architectural shingles"},{"unit":"SQ","total":2020.5,"source":"redfish_price_book","category":"material","quantity":44.9,"item_code":"UND_SYNTH","unit_price":45,"description":"Synthetic underlayment"},{"unit":"SQ","total":595,"source":"redfish_price_book","category":"material","quantity":7,"item_code":"ICE_SHIELD","unit_price":85,"description":"Ice and water shield"},{"unit":"SQ","total":359.2,"source":"redfish_price_book","category":"material","quantity":44.9,"item_code":"NAILS","unit_price":8,"description":"Roofing fasteners"},{"unit":"SQ","total":3367.5,"source":"redfish_price_book","category":"labor","quantity":44.9,"item_code":"LAB_INSTALL","unit_price":75,"description":"Shingle installation"},{"unit":"SQ","total":2245,"source":"redfish_price_book","category":"labor","quantity":44.9,"item_code":"LAB_TEAROFF","unit_price":50,"description":"Single-layer tear-off"},{"unit":"SQ","total":1122.5,"source":"redfish_price_book","category":"disposal","quantity":44.9,"item_code":"DUMP_FEE","unit_price":25,"description":"Disposal and dump fee"},{"unit":"EA","total":350,"source":"redfish_price_book","category":"permit","quantity":1,"item_code":"PERMIT","unit_price":350,"description":"Building permit allowance"}],"estimate_id":"34a5f107-b5b1-4d4c-8e24-9e983517a5de","approval_status":"draft","total_job_price":21261.84,"property_address":"3241 Wideman Avenue"},"report_type":"estimate_summary","generated_at":"2026-08-31T23:14:14.731873+00:00","generated_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","tenant_org_id":"de8369b6-a78f-40bb-ae1f-28ffca62bc7e","file_size_bytes":null},{"id":"faca3518-e7e4-435b-b989-4772e2963859","pdf_url":null,"version":1,"pdf_path":"generated://redfish/estimate/d2d9a504-8312-4a37-a643-e7a1a5d2c311/v1","created_at":"2026-08-31T23:14:14.731873+00:00","estimate_id":"d2d9a504-8312-4a37-a643-e7a1a5d2c311","report_data":{"demo":false,"status":"draft","squares":22,"roof_type":"Architectural Shingles","line_items":[{"id":"li_1775238426854_3","unit":"SQ","total":2535,"source":"auto","category":"material","quantity":19.5,"is_custom":false,"item_code":"SHG_ARCH","unit_price":130,"description":"Architectural Shingles","is_override":false},{"id":"li_1775238426854_4","unit":"SQ","total":877.5,"source":"auto","category":"material","quantity":19.5,"is_custom":false,"item_code":"UND_SYNTH","unit_price":45,"description":"Synthetic Underlayment","is_override":false},{"id":"li_1775238426854_5","unit":"SQ","total":246.5,"source":"auto","category":"material","quantity":2.9,"is_custom":false,"item_code":"ICE_SHIELD","unit_price":85,"description":"Ice & Water Shield","is_override":false},{"id":"li_1775238426854_6","unit":"SQ","total":156,"source":"auto","category":"material","quantity":19.5,"is_custom":false,"item_code":"NAILS","unit_price":8,"description":"Roofing Nails","is_override":false},{"id":"li_1775238426854_7","unit":"EA","total":75,"source":"auto","category":"material","quantity":3,"is_custom":false,"item_code":"PIPE_BOOT","unit_price":25,"description":"Pipe Boot/Jack","is_override":false},{"id":"li_1775238426854_8","unit":"SQ","total":1462.5,"source":"auto","category":"labor","quantity":19.5,"is_custom":false,"item_code":"LAB_INSTALL","unit_price":75,"description":"Shingle Installation Labor","is_override":false},{"id":"li_1775238426854_9","unit":"SQ","total":975,"source":"auto","category":"labor","quantity":19.5,"is_custom":false,"item_code":"LAB_TEAROFF","unit_price":50,"description":"Tear-Off Labor (1 layer)","is_override":false},{"id":"li_1775238426854_10","unit":"SQ","total":487.5,"source":"auto","category":"disposal","quantity":19.5,"is_custom":false,"item_code":"DUMP_FEE","unit_price":25,"description":"Dumpster / Dump Fees","is_override":false},{"id":"li_1775238426854_11","unit":"EA","total":350,"source":"auto","category":"disposal","quantity":1,"is_custom":false,"item_code":"PERMIT","unit_price":350,"description":"Building Permit","is_override":false}],"estimate_id":"d2d9a504-8312-4a37-a643-e7a1a5d2c311","approval_status":"draft","total_job_price":9935.848800000002,"property_address":"2171 Pelham St NE"},"report_type":"estimate_summary","generated_at":"2026-08-31T23:14:14.731873+00:00","generated_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","tenant_org_id":"de8369b6-a78f-40bb-ae1f-28ffca62bc7e","file_size_bytes":null},{"id":"49843259-67da-41fb-adcb-ea51c7575fef","pdf_url":null,"version":1,"pdf_path":"generated://redfish/estimate/0f277991-f7ee-4e1d-a00a-8968095a48fb/v1","created_at":"2026-08-31T23:14:14.731873+00:00","estimate_id":"0f277991-f7ee-4e1d-a00a-8968095a48fb","report_data":{"demo":true,"status":"sent","squares":26.4,"roof_type":"Architectural Shingles","line_items":[{"unit":"SQ","total":3432,"quantity":26.4,"item_code":"SHG_ARCH","unit_price":130,"description":"Architectural shingles"},{"unit":"SQ","total":1188,"quantity":26.4,"item_code":"UND_SYNTH","unit_price":45,"description":"Synthetic underlayment"},{"unit":"SQ","total":1980,"quantity":26.4,"item_code":"LAB_INSTALL","unit_price":75,"description":"Shingle installation"},{"unit":"SQ","total":1320,"quantity":26.4,"item_code":"LAB_TEAROFF","unit_price":50,"description":"Single-layer tear-off"},{"unit":"SQ","total":660,"quantity":26.4,"item_code":"DUMP_FEE","unit_price":25,"description":"Disposal and dump fee"},{"unit":"EA","total":350,"quantity":1,"item_code":"PERMIT","unit_price":350,"description":"Building permit allowance"}],"estimate_id":"0f277991-f7ee-4e1d-a00a-8968095a48fb","approval_status":"pending","total_job_price":13260.33,"property_address":"130 Redfish Demo Way"},"report_type":"estimate_summary","generated_at":"2026-08-31T23:14:14.731873+00:00","generated_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","tenant_org_id":"de8369b6-a78f-40bb-ae1f-28ffca62bc7e","file_size_bytes":null},{"id":"d876cbb8-c418-4211-a367-195e46ebad91","pdf_url":null,"version":1,"pdf_path":"generated://redfish/estimate/8e14c17a-ae80-4ccd-968d-86aab57f736e/v1","created_at":"2026-08-31T23:14:14.731873+00:00","estimate_id":"8e14c17a-ae80-4ccd-968d-86aab57f736e","report_data":{"demo":false,"status":"draft","squares":35.5,"roof_type":"Architectural Shingles","line_items":[{"unit":"SQ","total":4615,"source":"redfish_price_book","category":"material","quantity":35.5,"item_code":"SHG_ARCH","unit_price":130,"description":"Architectural shingles"},{"unit":"SQ","total":1597.5,"source":"redfish_price_book","category":"material","quantity":35.5,"item_code":"UND_SYNTH","unit_price":45,"description":"Synthetic underlayment"},{"unit":"SQ","total":510,"source":"redfish_price_book","category":"material","quantity":6,"item_code":"ICE_SHIELD","unit_price":85,"description":"Ice and water shield"},{"unit":"SQ","total":284,"source":"redfish_price_book","category":"material","quantity":35.5,"item_code":"NAILS","unit_price":8,"description":"Roofing fasteners"},{"unit":"SQ","total":2662.5,"source":"redfish_price_book","category":"labor","quantity":35.5,"item_code":"LAB_INSTALL","unit_price":75,"description":"Shingle installation"},{"unit":"SQ","total":1775,"source":"redfish_price_book","category":"labor","quantity":35.5,"item_code":"LAB_TEAROFF","unit_price":50,"description":"Single-layer tear-off"},{"unit":"SQ","total":887.5,"source":"redfish_price_book","category":"disposal","quantity":35.5,"item_code":"DUMP_FEE","unit_price":25,"description":"Disposal and dump fee"},{"unit":"EA","total":350,"source":"redfish_price_book","category":"permit","quantity":1,"item_code":"PERMIT","unit_price":350,"description":"Building permit allowance"}],"estimate_id":"8e14c17a-ae80-4ccd-968d-86aab57f736e","approval_status":"draft","total_job_price":16961.51,"property_address":"334 San Filippo Drive Southeast"},"report_type":"estimate_summary","generated_at":"2026-08-31T23:14:14.731873+00:00","generated_by":"4bca0c38-89b6-45f7-9d14-a8650cb794ca","tenant_org_id":"de8369b6-a78f-40bb-ae1f-28ffca62bc7e","file_size_bytes":null}],"rows":5,"limit":200,"table":"roof_estimate_reports","format":"knocklaunch-table-chunk-v1","offset":0,"schema":"public"}