Chambers Needing Updates - Revision history

ILPTest: /* Duplicate submissions awaiting review */

2026-07-26T16:27:13Z

Duplicate submissions awaiting review

← Older revision		Revision as of 18:27, 26 July 2026
Line 67:		Line 67:
	''Multiple submissions exist for the same chamber; the most complete is live, these are held for merge-or-delete review.''		''Multiple submissions exist for the same chamber; the most complete is live, these are held for merge-or-delete review.''
	{{#cargo_query:tables=ILP_Answers		{{#cargo_query:tables=ILP_Answers
	\|fields=State,Chamber,Topic,COUNT(*)=Held_records~~,Respondent~~		\|fields=State,Chamber,Topic,COUNT(*)=Held_records
	\|where=Current_Status="Duplicate – Needs Review"		\|where=Current_Status="Duplicate – Needs Review"
	\|group by=State,Chamber,Topic~~,Respondent~~		\|group by=State,Chamber,Topic
	\|order by=State \|format=table \|default=''No duplicates pending.''}}		\|order by=State \|format=table \|default=''No duplicates pending.''}}

	== Due for Review (not checked in 2+ years) ==		== Due for Review (not checked in 2+ years) ==
	{{#cargo_query:tables=ILP_Answers		{{#cargo_query:tables=ILP_Answers

ILPTest: /* Due for Review (not checked in 2+ years) */

2026-07-26T16:21:14Z

Due for Review (not checked in 2+ years)

← Older revision		Revision as of 18:21, 26 July 2026
Line 76:		Line 76:
	\|where=Last_Checked < '{{#time:Y-m-d\|-2 years}}' AND Current_Status<>"Duplicate – Needs Review"		\|where=Last_Checked < '{{#time:Y-m-d\|-2 years}}' AND Current_Status<>"Duplicate – Needs Review"
	\|group by=State,Chamber,Topic		\|group by=State,Chamber,Topic
	\|order by=Last_Checked \|format=table \|default=''~~Nothing is older than the freshness horizon~~.''}}		\|order by=Last_Checked \|format=table \|default=''No records are flagged for review.''}}

	== Recently confirmed ==		== Recently confirmed ==

ILPTest: /* Stale records (not checked in 2+ years) */

2026-07-26T16:20:09Z

Stale records (not checked in 2+ years)

← Older revision		Revision as of 18:20, 26 July 2026
Line 71:		Line 71:
	\|group by=State,Chamber,Topic,Respondent		\|group by=State,Chamber,Topic,Respondent
	\|order by=State \|format=table \|default=''No duplicates pending.''}}		\|order by=State \|format=table \|default=''No duplicates pending.''}}
	== ~~Stale records~~ (not checked in 2+ years) ==		== Due for Review (not checked in 2+ years) ==
	{{#cargo_query:tables=ILP_Answers		{{#cargo_query:tables=ILP_Answers
	\|fields=State,Chamber,Topic,Last_Checked		\|fields=State,Chamber,Topic,Last_Checked
Line 77:		Line 77:
	\|group by=State,Chamber,Topic		\|group by=State,Chamber,Topic
	\|order by=Last_Checked \|format=table \|default=''Nothing is older than the freshness horizon.''}}		\|order by=Last_Checked \|format=table \|default=''Nothing is older than the freshness horizon.''}}

	== Recently confirmed ==		== Recently confirmed ==
	{{#cargo_query:tables=ILP_Answers		{{#cargo_query:tables=ILP_Answers

ILPTest at 16:19, 26 July 2026

2026-07-26T16:19:10Z

← Older revision		Revision as of 18:19, 26 July 2026
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	<div class="ilp-maint-note">This page shows, for every legislative chamber, which information is missing, unverified, or out of date ~~â€”~~ generated from the ILP database. '''If you work for a chamber listed here''', your updates are welcome: contact the ILP editors through the [[ILP:About\|About]] page and we will record your ~~chamberâ€™s~~ current practice.</div>		<div class="ilp-maint-note">This page shows, for every legislative chamber, which information is missing, unverified, or out of date — generated from the ILP database. '''If you work for a chamber listed here''', your updates are welcome: contact the ILP editors through the [[ILP:About\|About]] page and we will record your chamber’s current practice.</div>
	== Coverage by topic ==		== Coverage by topic ==
	<div class="ilp-stats">		<div class="ilp-stats">
	<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Legislative Orientation" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Legislative Orientation ~~â€”~~ responded</span></div>		<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Legislative Orientation" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Legislative Orientation — responded</span></div>
	<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Legislative Orientation" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Legislative Orientation ~~â€”~~ needing attention</span></div>		<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Legislative Orientation" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Legislative Orientation — needing attention</span></div>
	<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Leadership" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Leadership ~~â€”~~ responded</span></div>		<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Leadership" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Leadership — responded</span></div>
	<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Leadership" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Leadership ~~â€”~~ needing attention</span></div>		<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Leadership" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Leadership — needing attention</span></div>
	<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Political Caucuses" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Political Caucuses ~~â€”~~ responded</span></div>		<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Political Caucuses" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Political Caucuses — responded</span></div>
	<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Political Caucuses" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Political Caucuses ~~â€”~~ needing attention</span></div>		<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Political Caucuses" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Political Caucuses — needing attention</span></div>
	<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Enrolling Procedures" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Enrolling Procedures ~~â€”~~ responded</span></div>		<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Enrolling Procedures" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Enrolling Procedures — responded</span></div>
	<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Enrolling Procedures" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Enrolling Procedures ~~â€”~~ needing attention</span></div>		<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Enrolling Procedures" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Enrolling Procedures — needing attention</span></div>
	</div>		</div>
	== Find your chamber ==		== Find your chamber ==
Line 54:		Line 54:
	</div></div>		</div></div>
	== Responded in source, nothing imported ==		== Responded in source, nothing imported ==
	''The survey shows a response but no answers made it into ILP ~~â€”~~ the source document needs review.''		''The survey shows a response but no answers made it into ILP — the source document needs review.''
	{{#cargo_query:tables=ILP_Participation		{{#cargo_query:tables=ILP_Participation
	\|fields=Topic,State,Chamber		\|fields=Topic,State,Chamber
	\|where=Source_Survey_Status="Responded (blank)"		\|where=Source_Survey_Status="Responded (blank)"
	\|order by=Topic,State \|format=table \|default=''None ~~â€”~~ every source response has been imported.''}}		\|order by=Topic,State \|format=table \|default=''None — every source response has been imported.''}}
	== Records flagged Needs Update ==		== Records flagged Needs Update ==
	{{#cargo_query:tables=ILP_Answers		{{#cargo_query:tables=ILP_Answers
Line 67:		Line 67:
	''Multiple submissions exist for the same chamber; the most complete is live, these are held for merge-or-delete review.''		''Multiple submissions exist for the same chamber; the most complete is live, these are held for merge-or-delete review.''
	{{#cargo_query:tables=ILP_Answers		{{#cargo_query:tables=ILP_Answers
	\|fields=State,Chamber,Topic,COUNT(*)=Held_records		\|fields=State,Chamber,Topic,COUNT(*)=Held_records,Respondent
	\|where=Current_Status="Duplicate ~~â€“~~ Needs Review"		\|where=Current_Status="Duplicate – Needs Review"
	\|group by=State,Chamber,Topic		\|group by=State,Chamber,Topic,Respondent
	\|order by=State \|format=table \|default=''No duplicates pending.''}}		\|order by=State \|format=table \|default=''No duplicates pending.''}}
	== ~~Due for review~~ (not checked in 2+ years) ==		== Stale records (not checked in 2+ years) ==
	{{#cargo_query:tables=ILP_Answers		{{#cargo_query:tables=ILP_Answers
	\|fields=State,Chamber,Topic,Last_Checked		\|fields=State,Chamber,Topic,Last_Checked
	\|where=Last_Checked < '{{#time:Y-m-d\|-2 years}}' AND Current_Status<>"Duplicate ~~â€“~~ Needs Review"		\|where=Last_Checked < '{{#time:Y-m-d\|-2 years}}' AND Current_Status<>"Duplicate – Needs Review"
	\|group by=State,Chamber,Topic		\|group by=State,Chamber,Topic
	\|order by=Last_Checked \|format=table \|default=''~~All records have been checked within~~ the ~~last two years~~.''}}		\|order by=Last_Checked \|format=table \|default=''Nothing is older than the freshness horizon.''}}
	== Recently confirmed ==		== Recently confirmed ==
	{{#cargo_query:tables=ILP_Answers		{{#cargo_query:tables=ILP_Answers
Line 82:		Line 82:
	\|where=Current_Status="Confirmed Current"		\|where=Current_Status="Confirmed Current"
	\|group by=State,Chamber,Topic		\|group by=State,Chamber,Topic
	\|order by=Last_Checked DESC \|limit=25 \|format=table \|default=''No chamber has been through the confirmation workflow yet ~~â€”~~ all records carry their import status.''}}		\|order by=Last_Checked DESC \|limit=25 \|format=table \|default=''No chamber has been through the confirmation workflow yet — all records carry their import status.''}}
	== Status vocabulary ==		== Status vocabulary ==
	{\| class="wikitable"		{\| class="wikitable"
Line 101:		Line 101:
	\| Current_Status \|\| Needs Update \|\| Known or suspected to be outdated; appears in the work queue above		\| Current_Status \|\| Needs Update \|\| Known or suspected to be outdated; appears in the work queue above
	\|-		\|-
	\| Current_Status \|\| Duplicate ~~â€“~~ Needs Review \|\| Held submission superseded by a more complete one		\| Current_Status \|\| Duplicate – Needs Review \|\| Held submission superseded by a more complete one
	\|}		\|}

	''This report is the first version of the ILP data-maintenance layer. The confirmation workflow (Page Forms) will write status changes that these queries pick up automatically.''		''This report is the first version of the ILP data-maintenance layer. The confirmation workflow (Page Forms) will write status changes that these queries pick up automatically.''

ILPTest: Update

2026-07-26T16:14:55Z

Update

← Older revision		Revision as of 18:14, 26 July 2026
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	<div class="ilp-maint-note">This page shows, for every legislative chamber, which information is missing, unverified, or out of date — generated from the ILP database. '''If you work for a chamber listed here''', your updates are welcome: contact the ILP editors through the [[ILP:About\|About]] page and we will record your ~~chamber’s~~ current practice.</div>		<div class="ilp-maint-note">This page shows, for every legislative chamber, which information is missing, unverified, or out of date â€” generated from the ILP database. '''If you work for a chamber listed here''', your updates are welcome: contact the ILP editors through the [[ILP:About\|About]] page and we will record your chamberâ€™s current practice.</div>
	== Coverage by topic ==		== Coverage by topic ==
	<div class="ilp-stats">		<div class="ilp-stats">
	<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Legislative Orientation" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Legislative Orientation — responded</span></div>		<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Legislative Orientation" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Legislative Orientation â€” responded</span></div>
	<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Legislative Orientation" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Legislative Orientation — needing attention</span></div>		<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Legislative Orientation" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Legislative Orientation â€” needing attention</span></div>
	<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Leadership" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Leadership — responded</span></div>		<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Leadership" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Leadership â€” responded</span></div>
	<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Leadership" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Leadership — needing attention</span></div>		<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Leadership" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Leadership â€” needing attention</span></div>
	<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Political Caucuses" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Political Caucuses — responded</span></div>		<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Political Caucuses" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Political Caucuses â€” responded</span></div>
	<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Political Caucuses" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Political Caucuses — needing attention</span></div>		<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Political Caucuses" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Political Caucuses â€” needing attention</span></div>
	<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Enrolling Procedures" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Enrolling Procedures — responded</span></div>		<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Enrolling Procedures" AND Source_Survey_Status="Responded"\|format=list}}</span><span class="l">Enrolling Procedures â€” responded</span></div>
	<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Enrolling Procedures" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Enrolling Procedures — needing attention</span></div>		<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation\|fields=COUNT(*)\|where=Topic="Enrolling Procedures" AND Source_Survey_Status<>"Responded"\|format=list}}</span><span class="l">Enrolling Procedures â€” needing attention</span></div>
	</div>		</div>
	== Find your chamber ==		== Find your chamber ==
Line 54:		Line 54:
	</div></div>		</div></div>
	== Responded in source, nothing imported ==		== Responded in source, nothing imported ==
	''The survey shows a response but no answers made it into ILP — the source document needs review.''		''The survey shows a response but no answers made it into ILP â€” the source document needs review.''
	{{#cargo_query:tables=ILP_Participation		{{#cargo_query:tables=ILP_Participation
	\|fields=Topic,State,Chamber		\|fields=Topic,State,Chamber
	\|where=Source_Survey_Status="Responded (blank)"		\|where=Source_Survey_Status="Responded (blank)"
	\|order by=Topic,State \|format=table \|default=''None — every source response has been imported.''}}		\|order by=Topic,State \|format=table \|default=''None â€” every source response has been imported.''}}
	== Records flagged Needs Update ==		== Records flagged Needs Update ==
	{{#cargo_query:tables=ILP_Answers		{{#cargo_query:tables=ILP_Answers
Line 67:		Line 67:
	''Multiple submissions exist for the same chamber; the most complete is live, these are held for merge-or-delete review.''		''Multiple submissions exist for the same chamber; the most complete is live, these are held for merge-or-delete review.''
	{{#cargo_query:tables=ILP_Answers		{{#cargo_query:tables=ILP_Answers
	\|fields=State,Chamber,Topic,COUNT(*)=Held_records~~,Respondent~~		\|fields=State,Chamber,Topic,COUNT(*)=Held_records
	\|where=Current_Status="Duplicate – Needs Review"		\|where=Current_Status="Duplicate â€“ Needs Review"
	\|group by=State,Chamber,Topic~~,Respondent~~		\|group by=State,Chamber,Topic
	\|order by=State \|format=table \|default=''No duplicates pending.''}}		\|order by=State \|format=table \|default=''No duplicates pending.''}}
	== ~~Stale records~~ (not checked in 2+ years) ==		== Due for review (not checked in 2+ years) ==
	{{#cargo_query:tables=ILP_Answers		{{#cargo_query:tables=ILP_Answers
	\|fields=State,Chamber,Topic,Last_Checked		\|fields=State,Chamber,Topic,Last_Checked
	\|where=Last_Checked < '{{#time:Y-m-d\|-2 years}}' AND Current_Status<>"Duplicate – Needs Review"		\|where=Last_Checked < '{{#time:Y-m-d\|-2 years}}' AND Current_Status<>"Duplicate â€“ Needs Review"
	\|group by=State,Chamber,Topic		\|group by=State,Chamber,Topic
	\|order by=Last_Checked \|format=table \|default=''~~Nothing is older than~~ the ~~freshness horizon~~.''}}		\|order by=Last_Checked \|format=table \|default=''All records have been checked within the last two years.''}}
	== Recently confirmed ==		== Recently confirmed ==
	{{#cargo_query:tables=ILP_Answers		{{#cargo_query:tables=ILP_Answers
Line 82:		Line 82:
	\|where=Current_Status="Confirmed Current"		\|where=Current_Status="Confirmed Current"
	\|group by=State,Chamber,Topic		\|group by=State,Chamber,Topic
	\|order by=Last_Checked DESC \|limit=25 \|format=table \|default=''No chamber has been through the confirmation workflow yet — all records carry their import status.''}}		\|order by=Last_Checked DESC \|limit=25 \|format=table \|default=''No chamber has been through the confirmation workflow yet â€” all records carry their import status.''}}
	== Status vocabulary ==		== Status vocabulary ==
	{\| class="wikitable"		{\| class="wikitable"
Line 101:		Line 101:
	\| Current_Status \|\| Needs Update \|\| Known or suspected to be outdated; appears in the work queue above		\| Current_Status \|\| Needs Update \|\| Known or suspected to be outdated; appears in the work queue above
	\|-		\|-
	\| Current_Status \|\| Duplicate – Needs Review \|\| Held submission superseded by a more complete one		\| Current_Status \|\| Duplicate â€“ Needs Review \|\| Held submission superseded by a more complete one
	\|}		\|}

	''This report is the first version of the ILP data-maintenance layer. The confirmation workflow (Page Forms) will write status changes that these queries pick up automatically.''		''This report is the first version of the ILP data-maintenance layer. The confirmation workflow (Page Forms) will write status changes that these queries pick up automatically.''

ILPTest at 15:29, 26 July 2026

2026-07-26T15:29:07Z

← Older revision		Revision as of 17:29, 26 July 2026
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	<div class="ilp-maint-note">This page shows, for every legislative chamber, which information is missing, unverified, or out of date — generated ~~live~~ from the ILP database. '''If you work for a chamber listed here''', your updates are welcome: contact the ILP editors through the [[ILP:About\|About]] page and we will record your chamber’s current practice.</div>		<div class="ilp-maint-note">This page shows, for every legislative chamber, which information is missing, unverified, or out of date — generated from the ILP database. '''If you work for a chamber listed here''', your updates are welcome: contact the ILP editors through the [[ILP:About\|About]] page and we will record your chamber’s current practice.</div>
	== Coverage by topic ==		== Coverage by topic ==
	<div class="ilp-stats">		<div class="ilp-stats">

ILPTest at 15:28, 26 July 2026

2026-07-26T15:28:46Z

← Older revision		Revision as of 17:28, 26 July 2026
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	<div class="ilp-maint-note">This page shows, for every legislative chamber, which information is missing, unverified, or out of date — generated live from the ILP database. '''If you work for a chamber listed here''', your updates are welcome: contact the ILP editors through the [[ILP:About\|About]] page and we will record your chamber’s current practice~~. A record leaves these lists the moment it is updated~~.</div>		<div class="ilp-maint-note">This page shows, for every legislative chamber, which information is missing, unverified, or out of date — generated live from the ILP database. '''If you work for a chamber listed here''', your updates are welcome: contact the ILP editors through the [[ILP:About\|About]] page and we will record your chamber’s current practice.</div>
	== Coverage by topic ==		== Coverage by topic ==
	<div class="ilp-stats">		<div class="ilp-stats">

ILPTest: Bot: Automated import of articles

2026-07-22T20:59:06Z

Bot: Automated import of articles

New page

__NOTOC__
<div class="ilp-maint-note">This page shows, for every legislative chamber, which information is missing, unverified, or out of date — generated live from the ILP database. '''If you work for a chamber listed here''', your updates are welcome: contact the ILP editors through the [[ILP:About|About]] page and we will record your chamber’s current practice. A record leaves these lists the moment it is updated.</div>
== Coverage by topic ==
<div class="ilp-stats">
<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation|fields=COUNT(*)|where=Topic="Legislative Orientation" AND Source_Survey_Status="Responded"|format=list}}</span><span class="l">Legislative Orientation — responded</span></div>
<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation|fields=COUNT(*)|where=Topic="Legislative Orientation" AND Source_Survey_Status<>"Responded"|format=list}}</span><span class="l">Legislative Orientation — needing attention</span></div>
<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation|fields=COUNT(*)|where=Topic="Leadership" AND Source_Survey_Status="Responded"|format=list}}</span><span class="l">Leadership — responded</span></div>
<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation|fields=COUNT(*)|where=Topic="Leadership" AND Source_Survey_Status<>"Responded"|format=list}}</span><span class="l">Leadership — needing attention</span></div>
<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation|fields=COUNT(*)|where=Topic="Political Caucuses" AND Source_Survey_Status="Responded"|format=list}}</span><span class="l">Political Caucuses — responded</span></div>
<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation|fields=COUNT(*)|where=Topic="Political Caucuses" AND Source_Survey_Status<>"Responded"|format=list}}</span><span class="l">Political Caucuses — needing attention</span></div>
<div class="ilp-stat ok"><span class="n">{{#cargo_query:tables=ILP_Participation|fields=COUNT(*)|where=Topic="Enrolling Procedures" AND Source_Survey_Status="Responded"|format=list}}</span><span class="l">Enrolling Procedures — responded</span></div>
<div class="ilp-stat bad"><span class="n">{{#cargo_query:tables=ILP_Participation|fields=COUNT(*)|where=Topic="Enrolling Procedures" AND Source_Survey_Status<>"Responded"|format=list}}</span><span class="l">Enrolling Procedures — needing attention</span></div>
</div>
== Find your chamber ==
''Every chamber with at least one topic missing, and which topics those are. If your chamber is listed, those are the areas where ILP has no current answer on file.''
{{#cargo_query:tables=ILP_Participation
|fields=State,Chamber,GROUP_CONCAT(Topic)=Topics with no answer on file
|where=Source_Survey_Status<>"Responded"
|group by=State,Chamber
|order by=State,Chamber |format=table |default=''Every chamber has answers on file for every topic.''}}
== Chambers with no answer on file, by topic ==
''The outreach list. A chamber leaves this queue when answers are imported for it and its participation status is updated.''
<div class="ilp-qbox mw-collapsible mw-collapsed">
'''Legislative Orientation'''
<div class="mw-collapsible-content">
{{#cargo_query:tables=ILP_Participation
|fields=State,Chamber,Source_Survey_Status=Status
|where=Topic="Legislative Orientation" AND Source_Survey_Status<>"Responded"
|order by=State |format=table |default=''All chambers have responses on file.''}}
</div></div>
<div class="ilp-qbox mw-collapsible mw-collapsed">
'''Leadership'''
<div class="mw-collapsible-content">
{{#cargo_query:tables=ILP_Participation
|fields=State,Chamber,Source_Survey_Status=Status
|where=Topic="Leadership" AND Source_Survey_Status<>"Responded"
|order by=State |format=table |default=''All chambers have responses on file.''}}
</div></div>
<div class="ilp-qbox mw-collapsible mw-collapsed">
'''Political Caucuses'''
<div class="mw-collapsible-content">
{{#cargo_query:tables=ILP_Participation
|fields=State,Chamber,Source_Survey_Status=Status
|where=Topic="Political Caucuses" AND Source_Survey_Status<>"Responded"
|order by=State |format=table |default=''All chambers have responses on file.''}}
</div></div>
<div class="ilp-qbox mw-collapsible mw-collapsed">
'''Enrolling Procedures'''
<div class="mw-collapsible-content">
{{#cargo_query:tables=ILP_Participation
|fields=State,Chamber,Source_Survey_Status=Status
|where=Topic="Enrolling Procedures" AND Source_Survey_Status<>"Responded"
|order by=State |format=table |default=''All chambers have responses on file.''}}
</div></div>
== Responded in source, nothing imported ==
''The survey shows a response but no answers made it into ILP — the source document needs review.''
{{#cargo_query:tables=ILP_Participation
|fields=Topic,State,Chamber
|where=Source_Survey_Status="Responded (blank)"
|order by=Topic,State |format=table |default=''None — every source response has been imported.''}}
== Records flagged Needs Update ==
{{#cargo_query:tables=ILP_Answers
|fields=State,Chamber,Topic,Question,Answer,Last_Checked
|where=Current_Status="Needs Update"
|order by=State,Chamber |format=table |default=''No records are currently flagged.''}}
== Duplicate submissions awaiting review ==
''Multiple submissions exist for the same chamber; the most complete is live, these are held for merge-or-delete review.''
{{#cargo_query:tables=ILP_Answers
|fields=State,Chamber,Topic,COUNT(*)=Held_records,Respondent
|where=Current_Status="Duplicate – Needs Review"
|group by=State,Chamber,Topic,Respondent
|order by=State |format=table |default=''No duplicates pending.''}}
== Stale records (not checked in 2+ years) ==
{{#cargo_query:tables=ILP_Answers
|fields=State,Chamber,Topic,Last_Checked
|where=Last_Checked < '{{#time:Y-m-d|-2 years}}' AND Current_Status<>"Duplicate – Needs Review"
|group by=State,Chamber,Topic
|order by=Last_Checked |format=table |default=''Nothing is older than the freshness horizon.''}}
== Recently confirmed ==
{{#cargo_query:tables=ILP_Answers
|fields=State,Chamber,Topic,Last_Checked
|where=Current_Status="Confirmed Current"
|group by=State,Chamber,Topic
|order by=Last_Checked DESC |limit=25 |format=table |default=''No chamber has been through the confirmation workflow yet — all records carry their import status.''}}
== Status vocabulary ==
{| class="wikitable"
! Field !! Value !! Meaning
|-
| Source_Survey_Status || Responded || The original survey contains an answer from this chamber (historical record; never edited)
|-
| Source_Survey_Status || Responded (blank) || The chamber appears in the source with no usable answer
|-
| Source_Survey_Status || Did not respond || The chamber is absent from the source survey
|-
| Current_Status || Imported || Answer transferred from the source survey; not yet independently verified
|-
| Current_Status || Not yet imported || A source response exists but has not been entered into ILP (reserved for future intake)
|-
| Current_Status || Confirmed Current || A staff member verified the answer with the chamber; Last_Checked records when
|-
| Current_Status || Needs Update || Known or suspected to be outdated; appears in the work queue above
|-
| Current_Status || Duplicate – Needs Review || Held submission superseded by a more complete one
|}

''This report is the first version of the ILP data-maintenance layer. The confirmation workflow (Page Forms) will write status changes that these queries pick up automatically.''