SELECT 'Person', address_id, COUNT (address_id) FROM person_addresses GROUP BY 1, address_id UNION SELECT 'Business', address_id, COUNT (address_id) FROM business_addresses GROUP BY 1, address_id /*UNION SELECT 'Employee Address', address_id, COUNT (address_id) FROM employee_addresses GROUP BY 1, address_id UNION SELECT 'Attorney Address', address_id, COUNT (address_id) FROM attorney_addresses GROUP BY 1, address_id UNION SELECT 'Citation Location', address_id, COUNT (address_id) FROM citation_addresses GROUP BY 1, address_id UNION SELECT 'Accident Location', address_id, COUNT (address_id) FROM accident_addresses GROUP BY 1, address_id UNION SELECT 'Incident Location', address_id, COUNT (address_id) FROM incident_addresses GROUP BY 1, address_id UNION SELECT 'Field Interview Location', address_id, COUNT (address_id) FROM fldint_addresses GROUP BY 1, address_id UNION SELECT 'Court Paper', addr_address_id, COUNT (addr_address_id) FROM cp_paper_parties GROUP BY 1, addr_address_id UNION SELECT 'Social History', address_id, COUNT (address_id) FROM social_history GROUP BY 1, address_id UNION SELECT 'Arrests', addr_address_id, COUNT (addr_address_id) FROM arrests GROUP BY 1, addr_address_id UNION SELECT 'Incident Vehicle', address_id, COUNT (address_id) FROM incident_vehicles GROUP BY 1, address_id UNION SELECT 'Offender Registration', address_id, COUNT (address_id) FROM offender_registrations GROUP BY 1, address_id UNION SELECT 'Warrant', addr_address_id, COUNT (addr_address_id) FROM e_warrants GROUP BY 1, addr_address_id UNION SELECT 'Impound Person', address_id, COUNT (address_id) FROM impound_people GROUP BY 1, address_id UNION SELECT 'Support Order Address History', address_id, COUNT (address_id) FROM support_order_addresses GROUP BY 1, address_id UNION SELECT 'Support Order Party Addresses', official_address_id, COUNT (official_address_id) FROM support_order_parties GROUP BY 1, official_address_id*/