-- Check current state of liabilities data
SELECT 
    'wills' as table_name,
    COUNT(*) as total_records,
    COUNT(CASE WHEN liabilities IS NOT NULL AND liabilities != '[]' AND liabilities != '' THEN 1 END) as has_liabilities_json
FROM wills

UNION ALL

SELECT 
    'will_liabilities' as table_name,
    COUNT(*) as total_records,
    COUNT(*) as has_liabilities_json
FROM will_liabilities

UNION ALL

SELECT 
    'liabilities' as table_name,
    COUNT(*) as total_records,
    COUNT(*) as has_liabilities_json
FROM liabilities;

-- Sample data from wills with liabilities
SELECT id, client_id, liabilities 
FROM wills 
WHERE liabilities IS NOT NULL AND liabilities != '[]' AND liabilities != '' 
LIMIT 3;

-- Sample data from will_liabilities
SELECT * FROM will_liabilities LIMIT 3;