ILP - User contributions [en]

Chambers Needing Updates

2026-07-26T16:27:13Z

ILPTest: /* Duplicate submissions awaiting review */

__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>
== 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
|where=Current_Status="Duplicate – Needs Review"
|group by=State,Chamber,Topic
|order by=State |format=table |default=''No duplicates pending.''}}

== Due for Review (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=''No records are flagged for review.''}}

== 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.''

Chambers Needing Updates

2026-07-26T16:21:14Z

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

__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>
== 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.''}}
== Due for Review (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=''No records are flagged for review.''}}

== 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.''

Chambers Needing Updates

2026-07-26T16:20:09Z

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

__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>
== 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.''}}
== Due for Review (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.''

Chambers Needing Updates

2026-07-26T16:19:10Z

ILPTest:

__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>
== 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.''

Chambers Needing Updates

2026-07-26T16:14:55Z

ILPTest: Update

__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>
== 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
|where=Current_Status="Duplicate â€“ Needs Review"
|group by=State,Chamber,Topic
|order by=State |format=table |default=''No duplicates pending.''}}
== Due for review (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=''All records have been checked within the last two years.''}}
== 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.''

Chambers Needing Updates

2026-07-26T15:29:07Z

ILPTest:

__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>
== 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.''

Chambers Needing Updates

2026-07-26T15:28:46Z

ILPTest:

__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>
== 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.''

ILP:About

2026-07-24T21:00:29Z

ILPTest: Bot: Automated import of articles

Inside the Legislative Process (ILP) is a comparative reference to legislative procedure across the states, maintained by legislative professionals. It converts ASLCS survey data into a searchable, continuously verified knowledge base: every answer preserves its historical survey record while carrying a current status and a last-checked date.

== Updating your chamber's information ==
If you work for a legislative chamber and see missing, outdated, or incorrect information — on your state's page or on [[Chambers Needing Updates]] — we welcome corrections and confirmations.

'''Contact:''' [ADD CONTACT NAME AND EMAIL HERE]

When writing, please include your chamber, the topic and question, and the current answer. Updates are recorded with the date of confirmation and your chamber's records are refreshed across the site automatically.

== About the data ==
Survey responses are stored as individual records identified by chamber, survey section, and answer (e.g., S002-U003-A020). Source survey responses are never altered; verification happens through the current-status fields. See each topic page for national comparisons and the chambers whose answers still need confirmation.

Template:State Topic Section

2026-07-24T21:00:27Z

ILPTest: Bot: Automated import of articles *** existing text overwritten ***

<div class="ilp-card">
<div class="ilp-card-head"><span class="ilp-card-title">{{{topic|}}}</span> {{#ifexpr:{{#expr:0{{#cargo_query:tables=ILP_Answers|fields=COUNT(*)|where=State="{{{state|}}}" AND Topic="{{{topic|}}}" AND Current_Status<>"Duplicate – Needs Review"|format=list|no html}}}}>0|<span class="ilp-badge ilp-ok">✓ Available</span>|<span class="ilp-badge ilp-na">Not yet available</span>}}</div>
{{#cargo_query:tables=ILP_Answers
|fields=Chamber,Question,Answer,Answer_Detail=Detail
|where=State="{{{state|}}}" AND Topic="{{{topic|}}}" AND Current_Status<>"Duplicate – Needs Review"
|order by=Chamber,Question_Code,Answer_Code
|format=table
|default=''This topic has not yet been documented for {{{state|}}}. Survey responses will appear here as they are collected and confirmed.''}}
</div>

Template:ILP Topic Count

2026-07-24T21:00:25Z

ILPTest: Bot: Automated import of articles *** existing text overwritten ***

{{#cargo_query:tables=ILP_Answers
|fields=COUNT(DISTINCT Topic)
|where=State="{{{state|}}}" AND Current_Status<>"Duplicate – Needs Review"
|format=list|no html}}

Main Page

2026-07-23T22:31:22Z

ILPTest:

__NOTOC__
<div class="ilp-hero">
<div class="ilp-hero-title">Inside the Legislative Process</div>
<div class="ilp-hero-tag">A comparative reference to legislative procedure across the states — built by legislative professionals, for legislative professionals.</div>
<span class="ilp-btn">[[Main Page#Browse states|Browse States]]</span><span class="ilp-btn">[[Main Page#Explore legislative practice|Browse Topics]]</span>
</div>
<div class="ilp-stats">
<div class="ilp-stat"><span class="n">{{#cargo_query:tables=ILP_Answers|fields=COUNT(*)|where=Current_Status<>"Duplicate – Needs Review"|format=list}}</span><span class="l">Survey answers</span></div>
<div class="ilp-stat"><span class="n">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Current_Status<>"Duplicate – Needs Review"|format=list}}</span><span class="l">Chambers documented</span></div>
<div class="ilp-stat"><span class="n">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT State)|where=Current_Status<>"Duplicate – Needs Review"|format=list}}</span><span class="l">States covered</span></div>
<div class="ilp-stat"><span class="n">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Topic)|where=Current_Status<>"Duplicate – Needs Review"|format=list}}</span><span class="l">Topics</span></div>
</div>
== Explore legislative practice ==
''Select a state on the map to open its profile. Shading shows how many topics are documented.''
{{US Map}}
<div class="ilp-topics">
<div class="ilp-topic-card"><h3>[[Legislative Orientation]]</h3><p>How chambers onboard newly elected members.</p><div class="meta">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Topic="Legislative Orientation" AND Current_Status<>"Duplicate – Needs Review"|format=list}} chambers reporting</div></div>
<div class="ilp-topic-card"><h3>[[Leadership]]</h3><p>Positions, selection methods, and terms.</p><div class="meta">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Topic="Leadership" AND Current_Status<>"Duplicate – Needs Review"|format=list}} chambers reporting</div></div>
<div class="ilp-topic-card"><h3>[[Political Caucuses]]</h3><p>Organization and operation of party caucuses.</p><div class="meta">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Topic="Political Caucuses" AND Current_Status<>"Duplicate – Needs Review"|format=list}} chambers reporting</div></div>
<div class="ilp-topic-card"><h3>[[Enrolling Procedures]]</h3><p>Act number assignment before enrolling.</p><div class="meta">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Topic="Enrolling Procedures" AND Current_Status<>"Duplicate – Needs Review"|format=list}} chambers reporting</div></div>
</div>
== Featured research ==
<div class="ilp-card"><div class="ilp-card-head"><span class="ilp-card-title">Act number assignment before enrolling</span></div>
How do legislative chambers assign act or chapter numbers relative to the enrolling process? The answers split sharply:
{{Question Summary|unit=U001|q=Q01}}
[[Enrolling Procedures|Explore the data →]]</div>
== Browse states ==
<div class="ilp-index">
{{State Index Entry|state=Alabama}}
{{State Index Entry|state=Alaska}}
{{State Index Entry|state=Arizona}}
{{State Index Entry|state=Arkansas}}
{{State Index Entry|state=California}}
{{State Index Entry|state=Colorado}}
{{State Index Entry|state=Connecticut}}
{{State Index Entry|state=Delaware}}
{{State Index Entry|state=Florida}}
{{State Index Entry|state=Georgia}}
{{State Index Entry|state=Hawaii}}
{{State Index Entry|state=Idaho}}
{{State Index Entry|state=Illinois}}
{{State Index Entry|state=Indiana}}
{{State Index Entry|state=Iowa}}
{{State Index Entry|state=Kansas}}
{{State Index Entry|state=Kentucky}}
{{State Index Entry|state=Louisiana}}
{{State Index Entry|state=Maine}}
{{State Index Entry|state=Maryland}}
{{State Index Entry|state=Massachusetts}}
{{State Index Entry|state=Michigan}}
{{State Index Entry|state=Minnesota}}
{{State Index Entry|state=Mississippi}}
{{State Index Entry|state=Missouri}}
{{State Index Entry|state=Montana}}
{{State Index Entry|state=Nebraska}}
{{State Index Entry|state=Nevada}}
{{State Index Entry|state=New Hampshire}}
{{State Index Entry|state=New Jersey}}
{{State Index Entry|state=New Mexico}}
{{State Index Entry|state=New York}}
{{State Index Entry|state=North Carolina}}
{{State Index Entry|state=North Dakota}}
{{State Index Entry|state=Ohio}}
{{State Index Entry|state=Oklahoma}}
{{State Index Entry|state=Oregon}}
{{State Index Entry|state=Pennsylvania}}
{{State Index Entry|state=Rhode Island}}
{{State Index Entry|state=South Carolina}}
{{State Index Entry|state=South Dakota}}
{{State Index Entry|state=Tennessee}}
{{State Index Entry|state=Texas}}
{{State Index Entry|state=Utah}}
{{State Index Entry|state=Vermont}}
{{State Index Entry|state=Virginia}}
{{State Index Entry|state=Washington}}
{{State Index Entry|state=West Virginia}}
{{State Index Entry|state=Wisconsin}}
{{State Index Entry|state=Wyoming}}
{{State Index Entry|state=Puerto Rico}}
</div>
== About ILP ==
Inside the Legislative Process converts ASLCS survey data into a searchable, continuously maintained knowledge base of state legislative procedure. Survey responses are preserved as historical records and verified over time by legislative staff; each topic page lists the chambers whose answers still need confirmation. State pages are living institutional profiles — they grow as new surveys are added.

Template:State Topic Section

2026-07-23T19:59:55Z

ILPTest: Fix state topic availability expression

<div class="ilp-card">
<div class="ilp-card-head"><span class="ilp-card-title">{{{topic|}}}</span> {{#if:{{#cargo_query:
tables=ILP_Answers
|fields=Chamber_ID
|where=State="{{{state|}}}" AND Topic="{{{topic|}}}" AND Current_Status<>"Duplicate – Needs Review"
|limit=1
|format=list
}}|<span class="ilp-badge ilp-ok">✓ Available</span>|<span class="ilp-badge ilp-na">Not yet available</span>}}</div>

{{#cargo_query:tables=ILP_Answers
|fields=Chamber,Question,Answer,Answer_Detail=Detail
|where=State="{{{state|}}}" AND Topic="{{{topic|}}}" AND Current_Status<>"Duplicate – Needs Review"
|order by=Chamber,Question_Code,Answer_Code
|format=table
|default=''This topic has not yet been documented for {{{state|}}}. Survey responses will appear here as they are collected and confirmed.''}}
</div>

Main Page/Draft

2026-07-23T19:46:59Z

ILPTest: ILPTest moved page Main Page/Draft to Main Page

#REDIRECT [[Main Page]]

Main Page

2026-07-23T19:46:59Z

ILPTest: ILPTest moved page Main Page/Draft to Main Page

__NOTOC__
<div class="ilp-hero">
<div class="ilp-hero-title">Inside the Legislative Process</div>
<div class="ilp-hero-tag">A comparative reference to legislative procedure across the states — built by legislative professionals, for legislative professionals.</div>
<span class="ilp-btn">[[Main Page#Browse states|Browse States]]</span><span class="ilp-btn">[[Main Page#Explore legislative practice|Browse Topics]]</span>
</div>
<div class="ilp-stats">
<div class="ilp-stat"><span class="n">{{#cargo_query:tables=ILP_Answers|fields=COUNT(*)|where=Current_Status<>"Duplicate – Needs Review"|format=list}}</span><span class="l">Survey answers</span></div>
<div class="ilp-stat"><span class="n">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Current_Status<>"Duplicate – Needs Review"|format=list}}</span><span class="l">Chambers documented</span></div>
<div class="ilp-stat"><span class="n">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT State)|where=Current_Status<>"Duplicate – Needs Review"|format=list}}</span><span class="l">States covered</span></div>
<div class="ilp-stat"><span class="n">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Topic)|where=Current_Status<>"Duplicate – Needs Review"|format=list}}</span><span class="l">Topics</span></div>
</div>
== Explore legislative practice ==
''Select a state on the map to open its profile. Shading shows how many topics are documented.''
{{US Map}}
<div class="ilp-topics">
<div class="ilp-topic-card"><h3>[[Legislative Orientation]]</h3><p>How chambers onboard newly elected members.</p><div class="meta">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Topic="Legislative Orientation" AND Current_Status<>"Duplicate – Needs Review"|format=list}} chambers reporting</div></div>
<div class="ilp-topic-card"><h3>[[Leadership]]</h3><p>Positions, selection methods, and terms.</p><div class="meta">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Topic="Leadership" AND Current_Status<>"Duplicate – Needs Review"|format=list}} chambers reporting</div></div>
<div class="ilp-topic-card"><h3>[[Political Caucuses]]</h3><p>Organization and operation of party caucuses.</p><div class="meta">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Topic="Political Caucuses" AND Current_Status<>"Duplicate – Needs Review"|format=list}} chambers reporting</div></div>
<div class="ilp-topic-card"><h3>[[Enrolling Procedures]]</h3><p>Act number assignment before enrolling.</p><div class="meta">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Topic="Enrolling Procedures" AND Current_Status<>"Duplicate – Needs Review"|format=list}} chambers reporting</div></div>
</div>
== Featured research ==
<div class="ilp-card"><div class="ilp-card-head"><span class="ilp-card-title">Act number assignment before enrolling</span></div>
How do legislative chambers assign act or chapter numbers relative to the enrolling process? The answers split sharply:
{{Question Summary|unit=U001|q=Q01}}
[[Enrolling Procedures|Explore the data →]]</div>
== Browse states ==
<div class="ilp-index">
{{State Index Entry|state=Alabama}}
{{State Index Entry|state=Alaska}}
{{State Index Entry|state=Arizona}}
{{State Index Entry|state=Arkansas}}
{{State Index Entry|state=California}}
{{State Index Entry|state=Colorado}}
{{State Index Entry|state=Connecticut}}
{{State Index Entry|state=Delaware}}
{{State Index Entry|state=Florida}}
{{State Index Entry|state=Georgia}}
{{State Index Entry|state=Hawaii}}
{{State Index Entry|state=Idaho}}
{{State Index Entry|state=Illinois}}
{{State Index Entry|state=Indiana}}
{{State Index Entry|state=Iowa}}
{{State Index Entry|state=Kansas}}
{{State Index Entry|state=Kentucky}}
{{State Index Entry|state=Louisiana}}
{{State Index Entry|state=Maine}}
{{State Index Entry|state=Maryland}}
{{State Index Entry|state=Massachusetts}}
{{State Index Entry|state=Michigan}}
{{State Index Entry|state=Minnesota}}
{{State Index Entry|state=Mississippi}}
{{State Index Entry|state=Missouri}}
{{State Index Entry|state=Montana}}
{{State Index Entry|state=Nebraska}}
{{State Index Entry|state=Nevada}}
{{State Index Entry|state=New Hampshire}}
{{State Index Entry|state=New Jersey}}
{{State Index Entry|state=New Mexico}}
{{State Index Entry|state=New York}}
{{State Index Entry|state=North Carolina}}
{{State Index Entry|state=North Dakota}}
{{State Index Entry|state=Ohio}}
{{State Index Entry|state=Oklahoma}}
{{State Index Entry|state=Oregon}}
{{State Index Entry|state=Pennsylvania}}
{{State Index Entry|state=Rhode Island}}
{{State Index Entry|state=South Carolina}}
{{State Index Entry|state=South Dakota}}
{{State Index Entry|state=Tennessee}}
{{State Index Entry|state=Texas}}
{{State Index Entry|state=Utah}}
{{State Index Entry|state=Vermont}}
{{State Index Entry|state=Virginia}}
{{State Index Entry|state=Washington}}
{{State Index Entry|state=West Virginia}}
{{State Index Entry|state=Wisconsin}}
{{State Index Entry|state=Wyoming}}
{{State Index Entry|state=Puerto Rico}}
</div>
== About ILP ==
Inside the Legislative Process converts decades of ASLCS survey data into a searchable, continuously maintained knowledge base of state legislative procedure. Survey responses are preserved as historical records and verified over time by legislative staff; each topic page lists the chambers whose answers still need confirmation. State pages are living institutional profiles — they grow as new surveys are added, and no state needs to be complete to have a page.

Main Page/Archive

2026-07-23T19:46:38Z

ILPTest: ILPTest moved page Main Page to Main Page/Archive

==Inside the Legislative Process==

Welcome to the test page for the Inside the Legislative Process database! Currently this database consists of one table, which can be found below, as well as a sample breakdown of results by state.

== Featured Table==

'''[[Act Number Before Enrolling|Act Number Assignment Before Enrolling]]'''

A comparative dataset showing how state legislative chambers assign act or chapter numbers relative to the enrolling process.

== Browse by State ==

Select a state to view detailed results:

* [[State/Alabama|Alabama]]
* [[State/Arizona|Arizona]]
* [[State/Arkansas|Arkansas]]
* [[State/Colorado|Colorado]]
* [[State/Minnesota|Minnesota]]
* [[State/Nebraska|Nebraska]]
* [[State/Wyoming|Wyoming]]

</div>

Chambers Needing Updates

2026-07-22T20:59:06Z

ILPTest: Bot: Automated import of articles

__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.''

Main Page

2026-07-22T20:59:04Z

ILPTest: Bot: Automated import of articles

__NOTOC__
<div class="ilp-hero">
<div class="ilp-hero-title">Inside the Legislative Process</div>
<div class="ilp-hero-tag">A comparative reference to legislative procedure across the states — built by legislative professionals, for legislative professionals.</div>
<span class="ilp-btn">[[Main Page#Browse states|Browse States]]</span><span class="ilp-btn">[[Main Page#Explore legislative practice|Browse Topics]]</span>
</div>
<div class="ilp-stats">
<div class="ilp-stat"><span class="n">{{#cargo_query:tables=ILP_Answers|fields=COUNT(*)|where=Current_Status<>"Duplicate – Needs Review"|format=list}}</span><span class="l">Survey answers</span></div>
<div class="ilp-stat"><span class="n">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Current_Status<>"Duplicate – Needs Review"|format=list}}</span><span class="l">Chambers documented</span></div>
<div class="ilp-stat"><span class="n">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT State)|where=Current_Status<>"Duplicate – Needs Review"|format=list}}</span><span class="l">States covered</span></div>
<div class="ilp-stat"><span class="n">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Topic)|where=Current_Status<>"Duplicate – Needs Review"|format=list}}</span><span class="l">Topics</span></div>
</div>
== Explore legislative practice ==
''Select a state on the map to open its profile. Shading shows how many topics are documented.''
{{US Map}}
<div class="ilp-topics">
<div class="ilp-topic-card"><h3>[[Legislative Orientation]]</h3><p>How chambers onboard newly elected members.</p><div class="meta">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Topic="Legislative Orientation" AND Current_Status<>"Duplicate – Needs Review"|format=list}} chambers reporting</div></div>
<div class="ilp-topic-card"><h3>[[Leadership]]</h3><p>Positions, selection methods, and terms.</p><div class="meta">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Topic="Leadership" AND Current_Status<>"Duplicate – Needs Review"|format=list}} chambers reporting</div></div>
<div class="ilp-topic-card"><h3>[[Political Caucuses]]</h3><p>Organization and operation of party caucuses.</p><div class="meta">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Topic="Political Caucuses" AND Current_Status<>"Duplicate – Needs Review"|format=list}} chambers reporting</div></div>
<div class="ilp-topic-card"><h3>[[Enrolling Procedures]]</h3><p>Act number assignment before enrolling.</p><div class="meta">{{#cargo_query:tables=ILP_Answers|fields=COUNT(DISTINCT Chamber_ID)|where=Topic="Enrolling Procedures" AND Current_Status<>"Duplicate – Needs Review"|format=list}} chambers reporting</div></div>
</div>
== Featured research ==
<div class="ilp-card"><div class="ilp-card-head"><span class="ilp-card-title">Act number assignment before enrolling</span></div>
How do legislative chambers assign act or chapter numbers relative to the enrolling process? The answers split sharply:
{{Question Summary|unit=U001|q=Q01}}
[[Enrolling Procedures|Explore the data →]]</div>
== Browse states ==
<div class="ilp-index">
{{State Index Entry|state=Alabama}}
{{State Index Entry|state=Alaska}}
{{State Index Entry|state=Arizona}}
{{State Index Entry|state=Arkansas}}
{{State Index Entry|state=California}}
{{State Index Entry|state=Colorado}}
{{State Index Entry|state=Connecticut}}
{{State Index Entry|state=Delaware}}
{{State Index Entry|state=Florida}}
{{State Index Entry|state=Georgia}}
{{State Index Entry|state=Hawaii}}
{{State Index Entry|state=Idaho}}
{{State Index Entry|state=Illinois}}
{{State Index Entry|state=Indiana}}
{{State Index Entry|state=Iowa}}
{{State Index Entry|state=Kansas}}
{{State Index Entry|state=Kentucky}}
{{State Index Entry|state=Louisiana}}
{{State Index Entry|state=Maine}}
{{State Index Entry|state=Maryland}}
{{State Index Entry|state=Massachusetts}}
{{State Index Entry|state=Michigan}}
{{State Index Entry|state=Minnesota}}
{{State Index Entry|state=Mississippi}}
{{State Index Entry|state=Missouri}}
{{State Index Entry|state=Montana}}
{{State Index Entry|state=Nebraska}}
{{State Index Entry|state=Nevada}}
{{State Index Entry|state=New Hampshire}}
{{State Index Entry|state=New Jersey}}
{{State Index Entry|state=New Mexico}}
{{State Index Entry|state=New York}}
{{State Index Entry|state=North Carolina}}
{{State Index Entry|state=North Dakota}}
{{State Index Entry|state=Ohio}}
{{State Index Entry|state=Oklahoma}}
{{State Index Entry|state=Oregon}}
{{State Index Entry|state=Pennsylvania}}
{{State Index Entry|state=Rhode Island}}
{{State Index Entry|state=South Carolina}}
{{State Index Entry|state=South Dakota}}
{{State Index Entry|state=Tennessee}}
{{State Index Entry|state=Texas}}
{{State Index Entry|state=Utah}}
{{State Index Entry|state=Vermont}}
{{State Index Entry|state=Virginia}}
{{State Index Entry|state=Washington}}
{{State Index Entry|state=West Virginia}}
{{State Index Entry|state=Wisconsin}}
{{State Index Entry|state=Wyoming}}
{{State Index Entry|state=Puerto Rico}}
</div>
== About ILP ==
Inside the Legislative Process converts decades of ASLCS survey data into a searchable, continuously maintained knowledge base of state legislative procedure. Survey responses are preserved as historical records and verified over time by legislative staff; each topic page lists the chambers whose answers still need confirmation. State pages are living institutional profiles — they grow as new surveys are added, and no state needs to be complete to have a page.

State/Puerto Rico

2026-07-22T20:59:02Z

ILPTest: Bot: Automated import of articles

State/Wyoming

2026-07-22T20:59:00Z

ILPTest: Bot: Automated import of articles *** existing text overwritten ***

State/Wisconsin

2026-07-22T20:58:58Z

ILPTest: Bot: Automated import of articles

State/West Virginia

2026-07-22T20:58:56Z

ILPTest: Bot: Automated import of articles

State/Washington

2026-07-22T20:58:54Z

ILPTest: Bot: Automated import of articles

State/Virginia

2026-07-22T20:58:52Z

ILPTest: Bot: Automated import of articles

State/Vermont

2026-07-22T20:58:50Z

ILPTest: Bot: Automated import of articles

State/Utah

2026-07-22T20:58:48Z

ILPTest: Bot: Automated import of articles

State/Texas

2026-07-22T20:58:46Z

ILPTest: Bot: Automated import of articles

State/Tennessee

2026-07-22T20:58:44Z

ILPTest: Bot: Automated import of articles

State/South Dakota

2026-07-22T20:58:42Z

ILPTest: Bot: Automated import of articles

State/South Carolina

2026-07-22T20:58:40Z

ILPTest: Bot: Automated import of articles

State/Rhode Island

2026-07-22T20:58:38Z

ILPTest: Bot: Automated import of articles

State/Pennsylvania

2026-07-22T20:58:36Z

ILPTest: Bot: Automated import of articles

State/Oregon

2026-07-22T20:58:34Z

ILPTest: Bot: Automated import of articles

State/Oklahoma

2026-07-22T20:58:32Z

ILPTest: Bot: Automated import of articles

State/Ohio

2026-07-22T20:58:30Z

ILPTest: Bot: Automated import of articles

State/North Dakota

2026-07-22T20:58:28Z

ILPTest: Bot: Automated import of articles

State/North Carolina

2026-07-22T20:58:26Z

ILPTest: Bot: Automated import of articles

State/New York

2026-07-22T20:58:24Z

ILPTest: Bot: Automated import of articles

State/New Mexico

2026-07-22T20:58:22Z

ILPTest: Bot: Automated import of articles

State/New Jersey

2026-07-22T20:58:20Z

ILPTest: Bot: Automated import of articles

State/New Hampshire

2026-07-22T20:58:18Z

ILPTest: Bot: Automated import of articles

State/Nevada

2026-07-22T20:58:16Z

ILPTest: Bot: Automated import of articles

State/Nebraska

2026-07-22T20:58:14Z

ILPTest: Bot: Automated import of articles *** existing text overwritten ***

State/Montana

2026-07-22T20:58:12Z

ILPTest: Bot: Automated import of articles

State/Missouri

2026-07-22T20:58:10Z

ILPTest: Bot: Automated import of articles

State/Mississippi

2026-07-22T20:58:08Z

ILPTest: Bot: Automated import of articles

State/Minnesota

2026-07-22T20:58:06Z

ILPTest: Bot: Automated import of articles *** existing text overwritten ***

State/Michigan

2026-07-22T20:58:04Z

ILPTest: Bot: Automated import of articles

State/Massachusetts

2026-07-22T20:58:02Z

ILPTest: Bot: Automated import of articles

State/Maryland

2026-07-22T20:58:00Z

ILPTest: Bot: Automated import of articles

State/Maine

2026-07-22T20:57:58Z

ILPTest: Bot: Automated import of articles