Identify constitutional amendments

[adamboche]

We've had a user question about how to find sponsors of a constitutional amendment. I don't think we have a way to do this right now, but we could.

[aaronrudkin]

I think probably the correct way to do this is as follows:

0. Identify all such votes (and, one presumes, failed constitutional amendments as well).
1. Create a metadata tag to highlight the votes and make the tag searchable.
2. Use the regular sponsor information to convey sponsors.

[aaronrudkin]

Constitutional amendments which passed

Amendment	Chamber	Rollcall	Notes
1-10,27	House	RH0010029	Not sure if this is exact
1-10,27	Senate	RS0010015	Not sure if this is exact
11	House	RH0030009
11	Senate	RS0030005
12	House	RH0080024
12	Senate	RS0080016
13	House	RH0380480
13	Senate	RS0380134
14	House	RH0390259
14	Senate	RS0390153
15	House	RH0400666	Not sure if this is exact
15	Senate	RS0400688
16	House	RH0610028
16	Senate	RS0610108	Not sure if this is exact
17	House	RH0620131
17	Senate	RS0620142	Not sure if this is exact
18	House	RH0650061
18	Senate	???	Don't see a vote on date of despite known 47-8 division
19	House	RH0660002
19	Senate	RS0660013
20	House	???
20	Senate	RS0720069 or RS0720035
21	House	RH0720112
21	Senate	RS0720272
22	House	RH0800003
22	Senate	RS0800019
23	House	NA	Voice vote
23	Senate	RS0860220
24	House	RH0870193
24	Senate	RS0870226
25	House	RH0890037
25	Senate	RS0890139
26	House	RH0920016
26	Senate	RS0920012

My proposal is the following:

• Someone who isn't me should verify this
• Tag all of these votes as key votes (many were not!)
• Add a db flag called const_amendment, set to 1
• Set up example searches and slides to highlight the feature