lobbyist_registry: unclean_data_registrant_not_poh_unclear

Shows registrants with previous_public_office_holder as no but there is data about the office that they held

Custom SQL query returning 8 rows (hide)

select
  *
from
  registrants
where
  (
    "previous_public_office_hold_position" is not null
    and "previous_public_office_hold_position" != ""
  )
  and "previous_public_office_holder" = "No"
order by
  registration_number desc
limit
  101

Edit SQL

This data as json, CSV

id	registration_number	status	effective_date	type	prefix	first_name	last_name	position_title	previous_public_office_holder	previous_public_office_hold_position	previous_public_office_position_program_name	previous_public_office_hold_last_date
6202	27037S	Superseded		In-house	Mr.	Pasquale	Di Donato	Vice President	No	Commissioner TTC.	Public Office	2015-05-01
1858	26407S	Active	2024-01-29	In-house		John	Poulos	President & CEO	No	President & CEO	Dominion Voting Systems	2019-02-25
10642	26179S	Superseded		In-house	Mr	Dominic	Amicone	President	No	Councillor , City of Toronto	Frances Nunziata	2015-06-24
11946	26179S	Active	2023-01-18	In-house	Mr	Dominic	Amicone	President	No	Councillor , City of Toronto	Frances Nunziata	2015-06-24
3593	19288C	Superseded	2020-05-01	Consultant	Mr.	Howard	Moscoe	Owner	No	Councillor	City of Toronto	2010-12-31
5552	19288C	Superseded	2020-05-01	Consultant	Mr.	Howard	Moscoe	Owner	No	Councillor	City of Toronto	2010-12-31
7370	11210C	Superseded	2020-05-15	Consultant	Ms.	Betty	Disero	President	No	City Councillor	City of Toronto	2003-03-14
4372	10162C	Superseded	2013-10-22	Consultant		Bernie	Morton	Vice President	No	Executive Assistant	Councillor John Adams	2000-09-02