Python Forum
Securing State Constitutions (USA) from University of Maryland > MariaDB .sql
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Securing State Constitutions (USA) from University of Maryland > MariaDB .sql
#1
Question 
Securing State Constitutions (USA) from University of Maryland > MariaDB .sql

I have downloaded all State Constitutions in .txt format by The University of Maryland (USA)

Site/Source: http://www.stateconstitutions.umd.edu/Methodology.aspx

The Methodology page outlines that they built an ASP database using 5 columns or as they say verbatim:

Although article and section numbers suffice for most constitutions, some states have taken the numbering of text to much more detailed levels.

We code individual pieces of text using five identifiers:

    1. Article
    2. Article.subnumber
    3. Section
    4. Section.subnumber
    5. Part
The fulltext breaks our State Constitution(s) into TEXT values which is wrapped around the following:

Washington State (My Home) Constitution Example:


Start of (Section 5):
*** SSTART 005.0 001.0 0 WA 1889 ***
End of (Section 5):
*** SEND ***
I have created a database called: stateconstitutions_umd_edu
I have created a table called: wash1889_final_parts_0 (which represents the contents of wash1889_final_parts_0.txt)

5 Columns to represent theirs:

I also added an AUTO_INCREMENT + Primary Key "id" column and a TIMESTAMP + CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP column called "state_constitutional_cite_entry_timestamp".

I have a total of 7 Columns in my newly created database (stateconstitution_umd_edu) and table (wash1889_final_parts_0):

id: INT / 11 + PRIMARY KEY + AUTO_INCREMENT
article / TEXT
article_subnumber / TEXT
section / TEXT
section_subnumber / TEXT
part / TEXT
state_constitutional_cite_entry_timestamp / TIMESTAMP + CURRENT_TIMESTAMP


Screenshot:

[Image: FINAL1-2022-01-16-16-34-17.png]
Let's take Washington State for example (My Home):

wash1889_final_parts_0.txt (Which is for Washington State Constitution - November 11, 1889)

Fulltext complete: wash1889_final_parts_0.txt (As downloaded from the University of Maryland):

What is the best way to achieve the following two steps:

1) Output from wash1889_final_parts_0.txt > all_ESTART_lines.txt ?

2) Use all_ESTART_lines.txt to build a python payload SQL INSERTER for TEXT wrapped between each and every ESTART & SEND lines in wash1889_final_parts_0.txt ?

Thank you everyone for this forum!

Snippet of wash1889_final_parts_0.txt:

*** ESTART WA 11/11/1889 ***
PROCLAMATION ANNOUNCING ADMISSION OF WASHINGTON - 1889

    BY THE PRESIDENT OF THE UNITED STATES OF AMERICA             
    A PROCLAMATION                           

Whereas the Congress of the United States did by an act approved on the twenty-second day of
February one thousand eight hundred and eighty-nine, provide that  the inhabitants of the
Territory of Washington might, upon the conditions prescribed in said act, become the State of
Washington; 
And whereas it was provided by said act that delegates elected as therein provided, to a
Constitutional convention in the Territory of Washington, should meet at the seat of government
of said Territory; and that, after they had met and organized they should declare on behalf of the
people of  Washington that they adopt the Constitution of the United States; whereupon the said
convention should be authorized to form a State Government for the proposed State of
Washington; 
And whereas it was provided by said act that the Constitution so adopted should be republican
in form and make no distinction in civil or political rights on account of race or color, except as
to Indians not taxed, and not be repugnant to the Constitution of the United States and the
principles of the Declaration of Independence; and that the Convention should by an ordinance
irrevocable without the consent of the United States and the people of said State make certain
provisions prescribed in said act; 
And whereas it was provided by said act that the Constitution thus formed for the people of
Washington should, by an ordinary of the Convention forming the same, be submitted to the
people of Washington at an election to be held therein on the first Tuesday in October, eighteen
hundred and eighty-nine, for ratification or rejection by the qualified voters of said proposed
State; and that the returns of said election should be made to the Secretary of said Territory, who,
with the Governor and Chief justice thereof, or any two of them, should canvass the same; and if
a majority of the legal votes cast should be for the Constitution, the Governor should certify the
result to the President of the United States, together with a statement of the votes cast thereon,
and upon separate articles or propositions and a copy of said Constitution, articles, propositions
and ordinances; 
And whereas it has been certified to me by the Governor of said Territory that within the time
prescribed by said act of Congress a Constitution for the proposed State of Washington has been
adopted and that the same, has been ratified by a majority of the qualified voters of said proposed
State in accordance with the conditions prescribed in said act; 
And whereas it is also certified to me by the said Governor that at the same time the body of
said Constitution was submitted to a vote of the people two separate articles entitled "Woman
Suffrage" and "Prohibition" were likewise submitted, which said separate articles did not receive
a majority of the votes cast thereon or upon the Constitution and were rejected; also that at the
same election the question of the location of a permanent seat of government was so submitted
and that no place receive a majority of all the votes cast upon said question; 
And whereas a duly authenticated copy of said Constitution and articles, as required by said
act, has been received by me: 
Now, therefore, I, Benjamin Harrison, President of the United States of America, do, in
accordance with the provisions of the act of Congress aforesaid, declare and proclaim the fact
that the conditions imposed by Congress on the State of Washington to entitle that State to
admission to the Union have been ratified and accepted and that the admission of the said State
into the Union is now complete.
In testimony whereof, I have hereunto set my hand and caused the seal of the United States to
be affixed.
 Done at the City of Washington this eleventh (11th) day of November in the year of our Lord
 one thousand eight hundred [SEAL.] and eighty-nine, and of the Independence of the United
 States of America the one hundred and fourteenth.
                                BENJ. HARRISON.
 By the President:
    JAMES G. BLAINE,
       Secretary of State.
*** EEND ***

*** CSTART WA 10/01/1889 99/99/9999 ***
  CONSTITUTION OF THE STATE OF WASHINGTON-1889
*** ASTART 9001.0 WA 1889 ***
PREAMBLE

We, the people of the State of Washington, grateful to the Supreme Ruler of the Universe for
our liberties, do ordain this constitution.
*** AEND ***
*** ASTART 001.0 WA 1889 ***
ARTICLE I

DECLARATION OF RIGHTS
*** SSTART 001.0 001.0 0 WA 1889 ***
SECTION 1. All political power is inherent in the people, and governments derive their just
powers from the consent of the governed, and are established to protect and maintain individual
rights.
*** SEND ***
*** SSTART 002.0 001.0 0 WA 1889 ***
SEC. 2. The Constitution of the United States is the supreme law of the land.
*** SEND ***
*** SSTART 003.0 001.0 0 WA 1889 ***
SEC. 3. No person shall be deprived of life, liberty or property without due process of law.
*** SEND ***
*** SSTART 004.0 001.0 0 WA 1889 ***
SEC. 4. The right of petition, and of the people peaceably to assemble for the common good,
shall never be abridged.
*** SEND ***
*** SSTART 005.0 001.0 0 WA 1889 ***
SEC. 5. Every person may freely speak, write and publish on all subjects, being responsible for
the abuse of that right.
*** SEND ***
*** SSTART 006.0 001.0 0 WA 1889 ***
SEC. 6. The mode of administering an oath, or affirmation, shall be such as may be most
consistent with and binding upon the conscience of the person to whom such oath, or affirmation,
may be administered.
*** SEND ***
*** SSTART 007.0 001.0 0 WA 1889 ***
SEC. 7. No person shall be disturbed in his private affairs, or his home invaded, without
authority of law.
*** SEND ***
*** SSTART 008.0 001.0 0 WA 1889 ***
SEC. 8. No law granting irrevocably any privilege, franchise or immunity shall be passed by
the legislature.
*** SEND***
*** SSTART 009.0 001.0 0 WA 1889 ***
SEC. 9. No person shall be compelled in any criminal case to give evidence against himself, or
be twice put in jeopardy for the same offense.
 *** SEND ***
*** SSTART 010.0 001.0 0 WA 1889 ***
SEC. 10. Justice in all cases shall be administered openly, and without unnecessary delay.
*** SEND ***
*** SSTART 011.0 001.0 0 WA 1889 ***
                                  SEC. 11. Absolute freedom of conscience in all matters of religious sentiment, belief, and
worship, shall be guaranteed to every individual, and no one shall be molested or disturbed in
person or property on account of religion, but the liberty of conscience hereby secured shall not
be so construed as to excuse acts of licentiousness, or justify practices inconsistent with the peace
and safety of the state. No public money or property shall be appropriated for or applied to any
religious worship, exercise or instruction, or the support, of any religious establishment.  No
religious qualification shall be required for any public office or employment, nor shall any person
be incompetent, as a witness or juror in consequence of his opinion on matters of religion, nor be
questioned in any court of justice touching his religious belief to affect the weight of his
testimony.
*** SEND ***
*** SSTART 012.0 001.0 0 WA 1889 ***
SEC. 12. No law shall be passed granting to any citizen, class of citizens, or corporation other
than municipal, privileges or immunities which upon the same terms shall not equally belong to
all citizens or corporations.
*** SEND ***
*** SSTART 013.0 001.0 0 WA 1889 ***
SEC. 13. The privilege of the writ of habeas corpus shall not be suspended unless in case of
rebellion or invasion the public safety requires it.
*** SEND ***
*** SSTART 014.0 001.0 0 WA 1889 ***
SEC. 14. Excessive bail shall not be required, excessive fines imposed, nor cruel punishment
inflicted.
*** SEND ***
*** SSTART 015.0 001.0 0 WA 1889 ***
SEC. 15. No conviction shall work corruption of blood, nor forfeiture of estate.
*** SEND ***
*** SSTART 016.0 001.0 0 WA 1889 ***
                                  SEC. 16. Private property shall not be taken for private use, except for private ways of
necessity, and for drains, flumes or ditches on or across the lands of others for agricultural,
domestic or sanitary purposes. No private property shall be taken or damaged for public or
private use without just compensation having been first made, or paid into court for the owner,
and no right-of-way shall be appropriated to the use of any corporation other than municipal,
until full compensation therefor be first made in money, or ascertained and paid into the court for
the owner, irrespective of any benefit from any improvement proposed by such corporation,
which compensation shall be ascertained by a jury, unless a jury be waived as in other civil cases
in courts of record, in the manner prescribed by law. Whenever an attempt is made to take private
property for a use alleged to be public, the question, whether the contemplated use be really
public shall be a judicial question, and determined as such without regard to any legislative
assertion that the use is public.
*** SEND ***
*** SSTART 017.0 001.0 0 WA 1889 ***
SEC. 17. There shall be no imprisonment for debt, except in cases of absconding debtors.
*** SEND ***
*** SSTART 018.0 001.0 0 WA 1889 ***
SEC. 18. The military shall be in strict subordination to the civil power.
*** SEND ***
*** SSTART 019.0 001.0 0 WA 1889 ***
SEC. 19. All elections shall be free and equal and no power, civil or military, shall at any time
interfere to prevent the free exercise of the right of suffrage.
*** SEND ***
*** SSTART 020.0 001.0 0 WA 1889 ***
SEC. 20. All persons charged with crime shall be bailable by sufficient sureties, except for
capital offenses, when the proof is evident, or the presumption great.
*** SEND ***
*** SSTART 021.0 001.0 0 WA 1889 ***
SEC. 21. The right of trial by jury shall remain inviolate, but the legislature may provide for a
jury of any number less than twelve in courts not of record, and for a verdict by nine or more
jurors in civil cases in any court of record, and for waiving of the jury in civil cases where the
consent of the parties interested is given thereto.
*** SEND ***
*** SSTART 022.0 001.0 0 WA 1889 ***
SEC. 22. In criminal prosecutions, the accused shall have the right to appear and defend in
person and by counsel, to demand the nature and cause of the accusation against him, to have a
copy thereof, to testify in his own behalf, to meet the witnesses against him face to face, to have
compulsory process to compel the attendance of witnesses in his own behalf, to have a speedy
public trial by an impartial jury of the county in which the offense is alleged to have been com-

mitted, and the right to appeal in all cases; and in no instance shall any accused person before
final judgment be compelled to advance money or fees to secure the rights herein guaranteed.
*** SEND ***
*** SSTART 023.0 001.0 0 WA 1889 ***
SEC. 23. No bill of attainder, ex post facto law, or law impairing the obligations of contracts
shall ever be passed.
*** SEND ***
*** SSTART 024.0 001.0 0 WA 1889 ***
SEC. 24. The right of the individual citizen to bear arms in defense of himself or the state shall
not be impaired, but nothing in this section shall be construed as authorizing individuals or
corporations to organize, maintain or employ an armed body of men.
*** SEND ***
*** SSTART 025.0 001.0 0 WA 1889 ***
SEC. 25. Offenses heretofore required to be prosecuted by indictment may be prosecuted by
information or by indictment, as shall be prescribed by law.
*** SEND ***
*** SSTART 026.0 001.0 0 WA 1889 ***
SEC. 26. No grand jury shall be drawn or summoned in any county, except the superior judge
thereof shall so order.
*** SEND ***
*** SSTART 027.0 001.0 0 WA 1889 ***
SEC. 27. Treason against the state shall consist only in levying war against the state, or
adhering to its enemies, or in giving them aid and comfort. No person shall be convicted of
treason unless on the testimony of two witnesses to the same overt act, or confession in open
court.
*** SEND ***
*** SSTART 028.0 001.0 0 WA 1889 ***
SEC. 28. No hereditary emoluments, privileges or powers shall be granted or conferred in this
state.
*** SEND ***
*** SSTART 029.0 001.0 0 WA 1889 ***
SEC. 29. The provisions of this constitution are mandatory, unless by express words they are
declared to be otherwise.
*** SEND ***
*** SSTART 030.0 001.0 0 WA 1889 ***
SEC. 30. The enumeration in this constitution of certain rights shall not be construed to deny
others retained by the people.
*** SEND ***
*** SSTART 031.0 001.0 0 WA 1889 ***
SEC. 31. No standing army shall be kept up by this state in time of peace, and no soldiers shall
in time of peace be quartered in any house without the consent of its owner, nor in time of war
except in the manner prescribed by law.
*** SEND ***
*** SSTART 032.0 001.0 0 WA 1889 ***
SEC. 32. A frequent recurrence to fundamental principles is essential to the security of
individual right and the perpetuity of free government.
*** SEND ***
*** AEND***

*** ASTART 002.0 WA 1889 ***
ARTICLE II
LEGISLATIVE DEPARTMENT
*** SSTART 001.0 002.0 0 WA 1889 ***
SECTION 1. The legislative powers shall be vested in a senate and house of representatives,
which shall be called the legislature of the State of Washington.
*** SEND ***
*** SSTART 002.0 002.0 0 WA 1889 ***
SEC. 2. The house of representatives shall be composed of not less than sixty-three nor more
than ninety-nine members. The number of senators shall not be more than one-half nor less than
one-third of the number of members of the house of representatives. The first legislature shall be
composed of seventy members of the house of representatives and thirty-five senators.
*** SEND ***
*** SSTART 003.0 002.0 0 WA 1889 *** 
                                  SEC. 3. The legislature shall provide by law for an enumeration of the inhabitants of the state
in the year one thousand eight hundred and ninety-five, and every ten years thereafter ; and at the
first session after such enumeration, and also after each enumeration made by the authority of the
United States, the legislature shall apportion and district anew the members of the senate and
house of representatives, according to the number of inhabitants, excluding Indians not taxed,
soldiers, sailors and officers of the United States army and navy in active service.
*** SEND ***
*** SSTART 004.0 002.0 0 WA 1889 ***
                                  SEC. 4. Members of the house of representatives shall be elected in the year eighteen hundred
and eighty-nine, at the time and in the manner provided by this constitution, and shall hold their
offices for the term of one year and until their successors shall be elected.
*** SEND ***
*** SSTART 005.0 002.0 0 WA 1889 ***
                                  SEC. 5. The next election of the members of the house of representatives after the adoption of
this constitution shall be on the first Tuesday after the first Monday of November, eighteen
hundred and ninety, and thereafter, members of the house of representatives shall be elected
biennially, and their term of office shall be two years; and each election shall be on the first
Tuesday after the first Monday in November, unless otherwise changed by law.
*** SEND ***
*** SSTART 006.0 002.0 0 WA 1889 ***
                                  SEC. 6. After the first election the senators shall be elected by single districts of convenient
and contiguous territory at the same time and in the same manner as members of the house of
representatives are required to be elected, and no representative district shall be divided in the
formation of a senatorial district. They shall be elected for the term of four years, one-half of
their number retiring every two years. The senatorial districts shall be numbered consecutively,
and the senators chosen at the first election had by virtue of this constitution, in odd numbered
districts, shall go out of office at the end of the first year, and the senators elected in the even
numbered districts shall go out of office at the end of the third year.
*** SEND ***
*** SSTART 007.0 002.0 0 WA 1889 ***
SEC. 7. No person shall be eligible to the legislature who shall not be a citizen of the United
States and a qualified voter in the district for which he is chosen.
*** SEND ***
*** SSTART 008.0 002.0 0 WA 1889 ***
SEC. 8. Each house shall be the judge of the election, returns and qualifications of its own
members, and a majority of each house shall constitute a quorum to do business, but, a smaller
number may adjourn from day to day and may compel the attendance of absent members in such
manner and under such penalties as each house may provide.
 *** SEND ***
*** SSTART 009.0 002.0 0 WA 1889 ***
SEC. 9. Each house may determine the rules of its own proceedings, punish for contempt and
disorderly behavior and, with the concurrence of two-thirds of all the members elected, expel a
member, but no member shall be expelled a second time for the same offense.
*** SEND ***
*** SSTART 010.0 002.0 0 WA 1889 ***
SEC. 10. Each house shall elect its own officers, and when the lieutenant governor shall not
attend as president, or shall act as governor, the senate shall choose a temporary president. When
presiding, the lieutenant governor shall have the deciding vote in case of an equal division of the
senate.
*** SEND ***
*** SSTART 011.0 002.0 0 WA 1889 ***
SEC. 11. Each house shall keep a journal of its proceedings and publish the same, except such
parts as require secrecy. The doors of each house shall be kept open, except when the public
welfare shall require secrecy.  Neither house shall adjourn for more than three days, nor to any
place other than that in which they may be sitting, without the consent of the other.
*** SEND ***
*** SSTART 012.0 002.0 0 WA 1889 ***
SEC. 12. The first legislature shall meet on the first Wednesday after the first Monday in
November, A.D. 1889. The second legislature shall meet on the first Wednesday after the first
Monday in January, A.D. 1891, and sessions of the legislature will be held biennially thereafter,
unless specially convened by the governor, but the times of meeting of subsequent sessions may
be changed by the legislature. After the first legislature the sessions shall not be more than sixty
days.
*** SEND ***
*** SSTART 013.0 002.0 0 WA 1889 ***
SEC. 13. No member of the legislature, during the term for which he is elected, shall be
appointed or elected to any civil office in the state, which shall have been created, or the
emoluments of which shall have been increased, during the term for which he was elected.
*** SEND ***
*** SSTART 014.0 002.0 0 WA 1889 ***
SEC. 14. No person, being a member of congress, or holding any civil or military office under
the United States or any other power, shall be eligible to be a member of the legislature; and if
any person after his election as a member of the legislature shall be elected to congress or be
appointed to any other office, civil or military, under the government of the United States, or any
other power, his acceptance thereof shall vacate his seat: Provided, That officers in the militia of
the state who receive no annual salary, local officers and postmasters, whose compensation does
not exceed three hundred dollars per annum, shall not be ineligible.
*** SEND ***
*** SSTART 015.0 002.0 0 WA 1889 ***
SEC. 15. The governor shall issue writs of election to fill such vacancies as may occur in either
house of the legislature.
*** SEND ***
*** SSTART 016.0 002.0 0 WA 1889 ***
SEC. 16. Members of the legislature shall be privileged from arrest in all cases except treason,
felony and breach of the peace they shall not be subject to any civil process during the session of
the legislature, nor for fifteen days next before the commencement of each session.
*** SEND ***
*** SSTART 017.0 002.0 0 WA 1889 ***
SEC. 17. No member of the legislature shall be liable in any civil action or criminal
prosecution whatever for words spoken in debate.
*** SEND ***
*** SSTART 018.0 002.0 0 WA 1889 ***
SEC. 18. The style of the laws of the state shall be: " Be it enacted by the legislature of the
State of Washington." And no law shall be enacted except by bill.
*** SEND ***
*** SSTART 019.0 002.0 0 WA 1889 ***
SEC. 19. No bill shall embrace more than one subject, and that shall be expressed in the title.
*** SEND ***
*** SSTART 020.0 002.0 0 WA 1889 ***
SEC. 20. Any bill may originate in either house of the legislature, and a bill passed by one
house may be amended in the other.
*** SEND ***
***SSTART 021.0 002.0 0 WA 1889 ***
SEC. 21. The yeas and nays of the members of either house shall be entered on the journal on
the demand of one-sixth of the members present.
       *** SEND ***
*** SSTART 022.0 002.0 0 WA 1889 ***
SEC.22.  No bill shall become a law unless on its final passage the vote be taken by yeas and
nays, the names of the members voting for and against the same be entered on the journal of each
house, and a majority of the members elected to each house be recorded thereon as voting in its
favor.
*** SEND ***
*** SSTART 023.0 002.0 0 WA 1889 ***
SEC. 23. Each member of the legislature shall receive for his services five dollars for each
day's attendance during the session, and ten cents for every mile he shall travel in going to and
returning from of the place of meeting of the legislature, on the most usual route.
*** SEND ***
*** SSTART 024.0 002.0 0 WA 1889 ***
    SEC. 24. The legislature shall never authorize any lottery or grant any divorce.
*** SEND ***
*** SSTART 025.0 002.0 0 WA 1889 ***
    SEC. 25. The legislature shall never grant any extra compensation to any public officer,
agent, servant or contractor after the services shall have been rendered or the contract entered
into, nor shall the compensation of any public officer be increased or diminished during his term
of office. 
*** SEND ***
*** SSTART 026.0 002.0 0 WA 1889 ***
SEC. 26. The legislature shall direct by law in what manner and in what courts suits may be
brought against the state.
*** SEND ***
*** SSTART 027.0 002.0 0 WA 1889 ***
SEC. 27. In all elections by the legislature the members shall vote viva voce, and their votes
shall be entered on the journal.
*** SEND ***

*** SSTART 028.0 002.0 0 WA 1889 *** 
SPECIAL LEGISLATION


SEC. 28. The legislature is prohibited from enacting any private or special law in the following
cases:
1. For changing the names of persons, or constituting one person the heir at law of another.
2. For laying out, opening or altering highways, except in cases of state roads extending into
more than one county, and military roads to aid in the construction of which lands shall have
been or may be granted by congress.
 3. For authorizing persons to keep ferries wholly within this state.
                                   4. For authorizing the sale or mortgage of real or personal property of minors, or others under
disabilities.
5. For assessment or collection of taxes, or for extending the time for collection thereof.
 6. For granting corporate powers or privileges.
7. For authorizing the apportionment of any part of the school fund.
8. For incorporating any town or village, or to amend the charter thereof.
 9. [From] giving effect to invalid deeds, wills or other instruments.
10. Releasing or extinguishing, in whole or in part, the indebtedness, liability or other
obligation of any person or corporation to the state, or to any municipal corporation therein.
11. Declaring any person of age or authorizing any minor to sell, lease or encumber his or her
property.
12. Legalizing, except as against the state, the unauthorized or invalid act of any officer.
 13. Regulating the rates of interest on money.
 14. Remitting fines, penalties or forfeitures.
 15. Providing for the management of common schools.
 16. Authorizing the adoption of children.
 17. For limitation of civil or criminal action.
 18. Changing county lines, locating or changing county seats: Provided, This shall not be
 construed to apply to the creation of new counties.
 *** SEND ***
 *** SSTART 029.0 002.0 0 WA 1889 ***
 SEC. 29. After the first day of January, eighteen hundred and ninety, the labor of convicts of
 this state shall not be let out by contract to any person, copartnership, company or corporation,
 and the legislature shall by law provide for the working of convicts for the benefit of the state.
 *** SEND ***
 *** SSTART 030.0 002.0 0 WA 1889 ***
 SEC. 30. The offense of corrupt solicitation of members of the legislature, or of public
 officers of the state or any municipal division thereof, and any occupation or practice of
 solicitation of such members or officers to influence their official action, shall be defined by
 law, and shall be punished by fine and imprisonment. Any person may be compelled to testify
 in any lawful investigation or judicial proceeding against any person who may be charged with
 having committed the offense of bribery or corrupt solicitation, or practice of solicitation, and
 shall not be permitted to withhold his testimony on the ground that it may criminate himself or
 subject him to public infamy, but such testimony shall not afterwards be used against him in
 any judicial proceeding except for perjury in giving such testimony and any person convicted
 of either of the offenses aforesaid, shall as part of the punishment therefor, be disqualified from
 ever holding any position of honor, trust or profit in this state. A member who has a private
 interest in any bill or measure proposed or pending before the legislature shall disclose the fact
 to the house of which he is a member, and shall not vote thereon.
 *** SEND ***
 *** SSTART 031.0 002.0 0 WA 1889 ***
 SEC. 31. No law, except appropriation bills, shall take effect until ninety days after the
 adjournment of the session at which it was enacted, unless in case of an emergency (which
 emergency must be expressed in the preamble or in the body of the act) the legislature shall
 otherwise by a vote of two-thirds of all the members elected to each house; said vote to be
 taken by yeas and nays and entered on the journals.
 *** SEND ***
 *** SSTART 032.0 002.0 0 WA 1889 ***
 SEC. 32. No bill shall become a law until the same shall have been signed by , the presiding
 officer of each of the two houses in open session, an under such rules as the legislature shall
 prescribe.
 SEC. 33. The ownership of lands by aliens, other than those who in good faith have declared
 their intention to become citizens of the United States, is prohibited in this state, except where
 acquired by inheritance, under mortgage or in good faith in the ordinary course of justice in the
 collection of debts; and all conveyances of lands hereafter made to any alien directly, or in trust
 for such alien, shall be void: Provided, That, the provisions of this section shall not apply to
 lands containing valuable deposits of minerals, metals, iron, coal or fire clay, and the necessary
 land for mills and machinery to be used in the development thereof and the manufacture of the
 products therefrom. Every corporation, the majority of the capital stock of which is owned by
 aliens, shall be considered an alien for the purposes of this prohibition.
 *** SEND ***
 *** SSTART 034.0 002.0 0 WA 1889 ***
 SEC. 34. There shall be established in the office of the secretary of state, a bureau of
 statistics, agriculture and immigration, under such regulations as the legislature may provide.
 *** SEND ***
 *** SSTART 035.0 002.0 0 WA 1889 ***
 SEC. 35. The legislature shall pass necessary laws for the protection of persons working in
 mines, factories and other employments dangerous to life and deleterious to health; and fix
 pains and penalties for the enforcement of same.
 *** SEND ***
 *** SSTART 036.0 002.0 0 WA 1889 ***
 SEC. 36. No bill shall be considered in either house unless the time of its introduction shall
 have been at least ten days before the final adjournment of the legislature, unless the legislature
 shall otherwise direct by a vote of two-thirds of all the members elected to each house, said
 vote to be taken by yeas and nays and entered upon the journal, or unless the same be at special
 session.
 *** SEND ***
 *** SSTART 037.0 002.0 0 WA 1889 ***
 SEC. 37. No act shall ever be revised or amended by mere reference to its title, but the act
 revised or the section amended shall be set forth at full length.
 *** SEND ***
 *** SSTART 038.0 002.0 0 WA 1889 ***
 SEC. 38. No amendment to any bill shall be allowed which shall change the scope and object
 of the bill.
 *** SEND ***
 *** SSTART 039.0 002.0 0 WA 1889 ***
 SEC. 39. It shall not be lawful for any person holding public office in this state to accept or
 use a pass or to purchase transportation from any railroad or other corporation, other than as the
 same may be purchased by the general public, and the legislature shall pass laws to enforce this
 provision. 
 *** SEND ***
 *** AEND ***
 *** ASTART 003.0 WA 1889 ***
 
                 ARTICLE III

                 THE EXECUTIVE
*** SSTART 001.0 003.0 0 WA 1889 ***
SECTION 1. The executive department shall consist of a governor, lieutenant governor,
secretary of state, treasurer, auditor  attorney general, superintendent of public instruction, and a
commissioner of public lands, who shall be severally chosen by the qualified electors of the state
at the same time and place of voting as for the members of the legislature.
*** SEND ***
*** SSTART 002.0 003.0 0 WA 1889 ***
SEC. 2. The supreme executive power of this state shall be vested in a governor, who shall
hold his office for a term of four years and until his successor is elected and qualified.
*** SEND ***
*** SSTART 003.0 003.0 0 WA 1889 ***
SEC. 3. The lieutenant governor, secretary of state, treasurer, auditor, attorney general,
superintendent of public instruction and commissioner of public lands, shall hold their offices for
four years, respectively, and until their successors are elected and qualified.
*** SEND ***
*** SSTART 004.0 003.0 0 WA 1889 ***
SEC. 4. The returns of every election for the officers named in the first section of this article
shall be sealed up and transmitted to the seat of government by the returning officers, directed to
the secretary of state, who shall deliver the same to the speaker of the house of representatives at
the first meeting of the house thereafter who shall open, publish and declare the results thereof in
the presence of a majority of the members of both houses. The person having the. highest number
of votes shall be declared duly elected, and a certificate thereof shall be given to such person,
signed by the presiding officers of both houses; but if any two or more shall be highest an equal
in votes for the same office, one of them shall be chosen by the joint vote of both houses.
Contested elections for such officers shall be decided by the legislature in such manner as shall
be decided by law. The terms of all officers named in section one of this article shall commence
on the second Monday in January after their election, until otherwise provided by law.
*** SEND ***
*** SSTART 005.0 003.0 0 WA 1889 ***
SEC. 5. The governor may require information in writing, from the officers of the state upon
any subject relating to the duties of their respective offices, and shall see that the laws are
faithfully executed.
*** SEND ***
*** SSTART 006.0 003.0 0 WA 1889 ***
 SEC. 6. He, shall communicate at every session by message to the legislature the condition of
 the affairs of the state, and recommend such measures as he shall deem expedient for their
 action.
*** SEND ***
*** SSTART 007.0 003.0 0 WA 1889 ***
SEC. 7. He may, on extraordinary occasions, convene the legislature by proclamation, in which
shall be stated the purposes for which the legislature is convened.
*** SEND ***
*** SSTART 008.0 003.0 0 WA 1889 ***
SEC. 8. He shall be commander-in-chief of the military in the state except when they shall be
called into the service of the United States.
*** SEND ***
*** SSTART 009.0 003.0 0 WA 1889 ***
SEC. 9. The pardoning power shall be vested in the governor under such regulations and
restrictions as may be prescribed by law.
*** SEND ***
*** SSTART 010.0 003.0 0 WA 1889 ***
SEC. 10. In case of the removal, resignation, death or disability of the governor, the duties of
the office shall devolve upon the lieutenant governor, and in case of a vacancy in both the offices
of governor and lieutenant governor, the duties of governor shall devolve upon the secretary of
state, who shall act as governor until the disability be removed or a governor be elected.

*** SEND ***
*** SSTART 011.0 003.0 0 WA 1889 ***
SEC. 11. The governor shall have power to remit fines and forfeitures, under such regulations
as may be prescribed by law, and shall report to the legislature at its next meeting each case of
reprieve, commutation, or pardon granted, and the reasons for granting the same, and also the
names of  all persons in whose favor remission of fines and forfeitures shall have been made, and
the several amounts remitted and the reasons for the remission.
*** SEND ***
*** SSTART 012.0 003.0 0 WA 1889 ***
SEC. 12. Every act which shall have passed the legislature shall be, before it becomes a law,
presented to the governor. If he approves, he shall sign it; but if not, he shall return it, with his
objections, to that house in which it shall have originated, which house shall enter the objections
at large upon the journal and proceed to reconsider. If, after such reconsideration, two-thirds of
the members present shall agree to pass the bill, it shall be sent, together with the objections, to
the other house, by which it shall likewise be reconsidered, and if approved by two-thirds of the
members present, it shall become a law; but in all such cases the vote of both houses shall be
determined by the yeas and nays, and the names of the members voting for or against the bill
shall be entered upon the journal of each house respectively. If any bill shall not be returned by
the governor within five days, Sunday excepted, after it shall be presented to him, it shall become
a law without his signature, unless the general adjournment shall prevent its return, in which case
it shall become a law unless the governor, within ten days next after the adjournment, Sundays
excepted, shall file such bill, with his objections thereto, in the office of secretary of state, who
shall lay the same before the legislature at its next session in like manner as if it had been
returned by the governor. If any bill presented to the governor contain several sections or items,
he may object to one or more sections or items while approving other portions of the bill. In such
case he shall append to the bill, at the time of signing it, a statement of the section or sections,
item or items to which he objects, and the reasons therefor, and the section or sections, item or
items so objected to shall not take effect unless passed over the governor's objection, as
hereinbefore provided.
*** SEND ***
*** SSTART 013.0 003.0 0 WA 1889 *** 
SEC. 13. When, during a recess of the legislature, a vacancy shall happen in any office, the
appointment to which is vested in the legislature, or when at any time a vacancy shall have
occurred in any other state office, for the filling of which vacancy no provision is, made
elsewhere in this constitution, the governor shall fill such vacancy by appointment, which shall
expire when a successor shall have been elected and qualified. *** SEND ***
*** SSTART 014.0 003.0 0 WA 1889 ***
      SEC. 14. The governor shall receive an annual salary  of four thousand dollars, which may
be increased by law, but shall never exceed six thousand dollars per annum. 
*** SEND ***
*** SSTART 015.0 003.0 0 WA 1889 ***
    SEC. 15. All commissions shall issue in the name of the state, shall be signed by the
governor, sealed with the seal of the state, and attested by the secretary of state.
*** SEND ***
*** SSTART 016.0 003.0 0 WA 1889 ***
 SEC. 16. The lieutenant governor shall be presiding officer of tile state senate, and shall
discharge such other duties as may be prescribed by law. He shall receive an annual salary of one
thousand dollars, which may be increased by the legislature, but shall never exceed three
thousand dollars per annum.
*** SEND ***
*** SSTART 017.0 003.0 0 WA 1889 ***
SEC. 17. The secretary of state shall keep a record of the official acts of the legislature and
executive department of the state, and shall, when required, lay the same and all matters relative
thereto, before either branch of the legislature, and shall perform such other duties as shall be
assigned him by law. He shall receive an annual salary of twenty-five hundred dollars, which
may be increased by the legislature, but shall never exceed three thousand dollars per annum.
*** SEND ***
*** SSTART 018.0 003.0 0 WA 1889 ***
SEC. 18. There shall be a seal of the state kept by the secretary of state for official purposes,
which shall be called " 'The Seal of the State of Washington."
*** SEND ***
*** SSTART 019.0 003.0 0 WA 1889 ***
SEC. 19. The treasurer shall perform such duties as shall be prescribed by law. He shall receive
an annual salary of two thousand dollars, which may be increased by the legislature, but shall
never exceed four thousand dollars per annum.
 *** SEND ***
*** SSTART 020.0 003.0 0 WA 1889 *** 
SEC. 20. The auditor shall be auditor of public accounts, and shall have such powers and
perform such duties in connection therewith as may be prescribed by law. He shall receive all
annual salary of two thousand dollars  which may be increased by the legislature, but shall never
exceed three thousand dollars per annum.
*** SEND ***
*** SSTART 021.0 003.0 0 WA 1889 ***
SEC. 21. The attorney general shall be the legal adviser of the state officers, and shall perform
such other duties as may be prescribed by law. He shall receive an annual salary of two thousand
dollars, which may be increased by the legislature, but shall never exceed thirty-five hundred
dollars per annum.
*** SEND ***
*** SSTART 022.0 003.0 0 WA 1889 ***
SEC. 22. The superintendent of public instruction shall have supervision over all matters
pertaining to public schools, and shall perform such specific duties as may be prescribed by law.
He shall receive an annual salary of twenty-five hundred dollars, which may be increased by law,
but shall never exceed four thousand dollars per annum.
*** SEND ***
*** SSTART 023.0 003.0 0 WA 1889 ***
SEC. 23. The commissioner of public lands shall perform such duties and receive such
compensation as the legislature may direct.
*** SEND ***
*** SSTART 024.0 003.0 0 WA 1889 ***
SEC. 24. The governor, secretary of state, treasurer, auditor. superintendent of public
instruction, commissioner of public lands, and attorney general shall severally keep the public
records, books and papers relating to their respective offices, at the seat of government, at which
place also the governor, secretary of state, treasurer and auditor shall reside.
*** SEND ***
*** SSTART 025.0 003.0 0 WA 1889 ***
SEC. 25. No person, except, a citizen of the United States and a qualified elector of this state,
shall be eligible to hold any state office, and the state treasurer shall be ineligible for the term
succeeding that for which he was elected. The compensation for state officers shall not be
increased or diminished during the term for which they shall have been elected. The legislature
may, in its discretion, abolish the offices of the lieutenant governor, auditor, and commissioner of
public lands.
*** SEND ***
*** AEND ***

*** ASTART 004.0 WA 1889 ***

                  ARTICLE IV

                 THE JUDICIARY
*** SSTART 001.0 004.0 0 WA 1889 ***
SECTION 1. The judicial power of the state shall be vested in a supreme court, superior courts,
justices of the peace, and such inferior courts as the legislature may provide.
*** SEND ***
*** SSTART 002.0 004.0 0 WA 1889 ***
SEC. 2. The supreme court shall consist of five judges, a majority of whom shall be necessary
to form a quorum and pronounce a decision. The said court shall always be open for the
transaction of business except on non-judicial days. In the determination of causes, all decisions
of the court shall be given in writing, and the grounds of the decision shall be stated. The
legislature may increase the number of judges of the supreme court from time to time, and may
provide for separate departments of said court.
*** SEND ***
*** SSTART 003.0 004.0 0 WA 1889 ***
SEC. 3. The judges of the supreme court shall be elected by the qualified electors of the state at
large, at the general state election, at the times and places at which state officers are elected,
unless some other time be provided by the legislature. The first election of judges of the supreme
court shall be at the election which shall be held upon the adoption of this constitution, and the
judges elected thereat shall be classified, by lot, so that two shall hold their office for the term of
three years, two for a term of five years, and one for the term of seven years. The lot shall be
drawn by the judges, who shall for that purpose assemble at the seat of government, and they
shall cause the result thereof to be certified to the secretary of state, and filed in his office. The
judge having the shortest term to serve, not holding his office by appointment or election to fill a
vacancy, shall be the chief justice, and shall preside at all sessions of the supreme court, and in
case there shall be two judges having in like manner the same short term, the other judges of the
supreme court shall determine which of them shall be chief justice. In case of the absence of the
chief justice, the judge having in like manner the shortest or next shortest term to serve shall
preside. After the first election the terms of judges elected shall be six years from and after the
second Monday in January next succeeding their election. If a vacancy occur in the office of a
judge of the supreme court, the governor shall appoint a person to hold the office until the
election and qualification o a judge to fill the vacancy, which election shall take place at the next
succeeding general election, and the judge so elected shall hold the office for the remainder of
the unexpired term. The term of office of the judges of the supreme court, first elected, shall
commence as soon as the state shall have been admitted into the Union, and continue for the term
herein provided, and until their successors are
elected and qualified. The sessions of the supreme court shall be held at the seat of government
until otherwise provided by law.
*** SEND ***
*** SSTART 004.0 004.0 0 WA 1889 ***
SEC. 4. The supreme court shall have original jurisdiction in habeas corpus, and quo warranto
and mandamus as to all state officers and appellate jurisdiction in all actions and proceedings,
excepting that, its appellate jurisdiction shall not extend to civil actions at law for the recovery of
money or personal property when the original amount in controversy, or the value of the
property, does not exceed the sum of two hundred dollars ($200), unless the action involves the
legality of a tax, impost, assessment, toll, municipal fine, or the validity of a statute. The supreme
court shall also have power to issue writs of mandamus, review, prohibition, habeas corpus,
certiorari and all other writs necessary and proper to the complete exercise of its appellate and
revisory jurisdiction. Each of the judges shall have power to issue writs of habeas corpus to any
part of the state upon petition by or on behalf of any person held in actual custody, and may make
such writs returnable before himself, or before the supreme court, or before any superior court of
the state, or any judge thereof.
*** SEND ***
*** SSTART 005.0 004.0 0 WA 1889 ***
SEC. 5. There shall be in each of the organized counties of this state a superior court for which
at least one judge shall be elected by the qualified electors of the county at the general state,
election: Provided, That until otherwise directed by the legislature one judge only shall be elected
for the counties of Spokane and Stevens; one judge for the county of Whitman; one judge for the
counties of Lincoln, Okanogan, Douglas and Adams; one judge for the counties of Walla Walla
and Franklin; one judge for the counties of Columbia, Garfield and Asotin; one judge for the
counties of Kittitas, Yakinia and Klickitat; one judge for the counties of Clark, Skamania,
Pacific, Cowlitz and Wahkiakum; one judge for the counties of Thurston. Chehalis, Mason and
Lewis; one judge for the county of Pierce; one for the county of King; one judge for the counties
of Jefferson, Island, Kitsap, San Juan and Clallam; and one judge for the counties of Whatcom,
Skagit and Snohomish. In any county where there shall be more than one superior judge, there
may be as many sessions of the superior court at the same time as there are judges thereof, and
whenever the governor shall direct, a superior judge to hold court in  any county other than that
for which he has been elected, there may be as many sessions of the superior court in said county
at the same time as there are judges therein, or assigned to duty therein by the governor, and the
business of the court shall be so distributed and assigned by law, or, in the absence of legislation
therefor, by such rules and orders of court, as shall best promote and secure the convenient and
expeditious transaction thereof. The judgments, decrees, orders and proceedings of any session of
the superior court held by any one or more of the judges of such court shall be equally effectual
as if all the judges of said court presided at such session. The first superior judges elected under
this constitution shall hold their offices for the period of three years, and until their successors
shall be elected and qualified, and thereafter the term of office of all superior judges in this state
shall be for four years from the second Monday in January next succeeding their election, and
until their successors are elected and qualified.  The first election of judges of the Superior court
shall be at the election held for the adoption of this constitution   If a vacancy occurs in the,
office of judge of the superior court, governor shall appoint a person to hold the office until the
election and qualification of a judge to fill the vacancy, which election shall be at the next
succeeding general election, and the judge so elected shall hold office for the remainder of the
unexpired term.
*** SEND ***
*** SSTART 006.0 004.0 0 WA 1889 ***
SEC. 6. The superior court shall have original jurisdiction in all cases in equity, and in all
cases at law which involve the title or possession of real property, or the legality of any tax,
impost, assessment, toll or municipal fine, and in all other cases in which the demand, or the
value of the property in controversy amounts to one hundred dollars, and in all criminal cases
amounting to felony, and in all cases of misdemeanor not otherwise provided for by law; of
actions of forcible entry and detainer; of proceedings in insolvency; of actions to prevent or abate
a nuisance; of all matters of probate, of divorce, and for annulment of marriage; and for such
special cases and proceedings as are not otherwise provided for. The superior court shall also
have original jurisdiction in all cases and of all proceedings in which jurisdiction shall not have
been by law vested exclusively in some other court; and said court shall have the power of
naturalization, and to issue papers therefor. They shall have such appellate jurisdiction in cases
arising in justice's and other inferior courts in their respective counties as may be prescribed by
law. They shall be always open except on non-judicial days, and their process shall extend to all
parts of the state. Said courts and their judges shall have power to issue writs of mandamus, quo
warranto, review, certiorari, prohibition and writs of habeas corpus, on petition by or on behalf of
any person in actual custody in their respective counties.  Injunctions and writs of prohibition and
of habeas corpus may be issued and served on legal holidays and non-judicial days.
*** SEND ***
*** SSTART 007.0 004.0 0 WA 1889 ***
SEC. 7. The judge of any superior court may hold a superior court in any county at the request
of the judge of the superior court thereof, and upon the request of the governor it shall be his duty
to do so. A case in the superior court may be tried by a judge pro tempore, who must be a
member of the bar, agreed upon in writing by the parties litigant, or their attorneys of record,
approved by the court, and sworn to try the case.
*** SEND ***

*** SSTART 008.0 004.0 0 WA 1889 ***
SEC. 8. Any judicial officer who shall absent himself from the state for more than sixty
consecutive days shall be deemed to have forfeited his office: Provided, That in cases of extreme
necessity the governor may extend the leave of absence such time as the necessity therefor shall
exist.
*** SEND ***
*** SSTART 009.0 004.0 0 WA 1889 ***
SEC. 9. Any judge of any court of record, the attorney general, or any prosecuting attorney may
be removed from office by joint resolution of the legislature, in which three-fourths of the
members elected to each house shall concur, for incompetency, corruption, malfeasance, or
delinquency in office, or other sufficient cause stated in such resolution. But no removal shall be
made unless the officer complained of shall have been served with a copy of the charges against
him as the ground of removal, and shall have an opportunity of being heard in his defense. Such
resolution shall be entered at length on the journal of both houses, and on the question of removal
the ayes and nays shall also be entered on the journal.
*** SEND ***

*** SSTART 010.0 004.0 0 WA 1889 ***
SEC. 10. The legislature shall determine the number of justices of the peace to be elected in
incorporated cities or towns and in precincts, and shall prescribe by law the powers, duties and
jurisdiction of justices of the peace: Provided, That such jurisdiction granted by the legislature
shall not trench upon the jurisdiction of superior or other courts of record, except that, justices of
the peace may be made police justices of incorporated cities and towns. In incorporated cities or
towns having more than five thousand inhabitants the justices of the peace shall receive such
salary as may be provided by law, and shall receive no fees for their own use.
*** SEND ***
*** SSTART 011.0 004.0 0 WA 1889 ***
    SEC. 11. The supreme court and the superior courts shall be courts of record, and the
legislature shall have power to provide that any of the courts of this state, excepting justices of
the peace, shall be courts of record.
*** SEND ***
*** SSTART 012.0 004.0 0 WA 1889 *** 
    SEC. 12. The legislature shall prescribe by law the jurisdiction and powers of any of the
inferior courts which may be established in pursuance of this constitution.
*** SEND ***
*** SSTART 013.0 004.0 0 WA 1889 ***
    SEC. 13. No judicial officer, except court commissioners and unsalaried justices of the peace,
shall receive to his own use any fees or perquisites of office. The judges of the supreme court and
judges of the superior courts shall severally, at stated times, during their continuance in office,
receive for their services the salaries prescribed by law therefor, which shall not be increased
after their election, nor during the term for which they shall have been elected. The salaries of the
judges of the supreme court shall be paid by the state. One-half of the salary of each of the
superior court judges shall be paid by the state, and the other one-half by the county or counties
for which he is elected. Incases where a judge is provided for more than one county, that portion
of his salary which is to be paid by the counties shall be apportioned between among them
according to the assessed value of their taxable property, to be determined by the assessment
next, preceding the time which such salary is to be paid.
*** SEND ***

*** SSTART 014.0 004.0 0 WA 1889 ***
    SEC. 14. Each of the judges of the supreme court shall receive in annual salary of four
thousand dollars ($4,000); each of the superior court judges shall receive an annual salary of
three thousand dollars ($3,000), which said salaries shall be payable quarterly. The legislature
may increase the salaries of the judges herein provided.
*** SEND ***
*** SSTART 015.0 004.0 0 WA 1889 ***
    SEC. 15. The judges of the supreme court and the judges of the superior court shall be
ineligible to all other office or public employment than a judicial office or employment during
the term for which they shall have been elected.
*** SEND *** 
*** SSTART 016.0 004.0 0 WA 1889 ***
SEC. 16. Judges shall not charge juries with respect, to matters of fact, nor comment thereon, but
shall declare the law.
*** SEND ***
*** SSTART 017.0 004.0 0 WA 1889 ***
    SEC. 17. No person shall be eligible to the office of judge of the supreme court or judge of a
superior court unless he shall have been admitted to practice in the courts of record of this state
or of the Territory of Washington.
*** SEND ***
*** SSTART 018.0 004.0 0 WA 1889 ***
    SEC. 18. The judges of the supreme court shall appoint a reporter for the decisions of that
court, who shall be removable at their pleasure. He shall receive such annual salary as shall be
prescribed by law.
*** SEND ***
*** SSTART 019.0 004.0 0 WA 1889 ***
    SEC. 19. No judge of a court of record shall practice law in any court of this state during his
continuance in office.
*** SEND ***
*** SSTART 020.0 004.0 0 WA 1889 ***
    SEC. 20. Every cause submitted to a judge of a superior court, for his decision shall be decided
by him within ninety days from the, submission thereof: Provided, That if, within said period of
ninety days a rehearing shall have been ordered , then the period within which he is to decide
shall commence at the time the cause is submitted upon such a rehearing.
*** SEND ***
*** SSTART 021.0 004.0 0 WA 1889 ***
SEC. 21. The legislature shall provide for the speedy publication of opinions of the supreme
court, and all opinions shall be free for publication by any person.
*** SEND ***
*** SSTART 022.0 004.0 0 WA 1889 ***
SEC. 22. The judges of the supreme court shall appoint a clerk of that court, who shall be
removable at their pleasure, but the legislature may provide for the election of the clerk of the
supreme court, and prescribe the term of his office. The clerk of the supreme court shall receive
such compensation, by salary only, as shall be provided by law.
*** SEND ***
*** SSTART 023.0 004.0 0 WA 1889 ***
SEC. 23. There may be appointed in each county, by the judge of the superior court having
jurisdiction therein, one or more court commissioners, not exceeding three in number, who shall
have authority to perform like duties as a judge of the superior court at chambers, subject to
revision by such judge, to take depositions and to perform such other business connected with the
administration of justice as may be prescribed by law.
*** SEND ***
*** SSTART 024.0 004.0 0 WA 1889 ***
SEC. 24. The judges of the superior courts shall, from time to time, establish uniform rules for
the government of the superior courts.
*** SEND ***
*** SSTART 025.0 004.0 0 WA 1889 ***
SEC. 25. Superior judges shall, on or before the first day of November in each year, report in
writing to the judges of the supreme court such defects and omissions in the laws as their
experience may suggest, and the judges of the supreme court shall, on or before the first day of
January in each year, report in writing to the governor such defects and omissions in the laws
they may believe to exist.
*** SEND ***
*** SSTART 026.0 004.0 0 WA 1889 ***
SEC. 26. The county clerk shall be, by virtue of his office, clerk of the superior court.
*** SEND ***
*** SSTART 027.0 004.0 0 WA 1889 ***
SEC. 27. The style of all process shall be, "The State of Washington," and all prosecutions
shall be conducted in its name and by its authority.
*** SEND ***
*** SSTART 028.0 004.0 0 WA 1889 ***
SEC. 28. Every judge of the supreme court and. every judge of a superior court shall, before
entering upon the duties of his office, take and subscribe an oath that he will support the
constitution of the United States and the constitution of the State of Washington, and will
faithfully and impartially discharge the duties of judge to the best of his ability, which oath shall
be filed in the office of the secretary of state.
*** SEND ***
*** AEND ***
*** ASTART 005.0 WA 1889 ***
                  ARTICLE V

                 IMPEACHMENT
*** SSTART 001.0 005.0 0 WA 1889 ***
SECTION 1. The house of representatives shall have the sole power of impeachment. The
concurrence of a majority of all the members shall be necessary to an impeachment. All
impeachments shall be tried by the senate, and when sitting for that purpose the senators shall be
upon oath or affirmation to due justice according to law and evidence. When the governor or
lieutenant governor is, on trial. the chief justice of the supreme court shall preside. No person
shall be convicted without a concurrence of two-thirds of the senators elected.
*** SEND ***
*** SSTART 002.0 005.0 0 WA 1889 ***
SEC. 2. The governor and other state and judicial officers, except judges and justices of courts
not of record, shall be liable to impeachment for high crimes or misdemeanors, or malfeasance in
office, but
judgment in such cases shall extend only to removal from office and disqualification to hold any
office of honor, trust or profit, in the state. The party, whether convicted or acquitted, shall,
nevertheless be liable to prosecution, trial, judgment and punishment according to law.
*** SEND ***
*** SSTART 003.0 005.0 0 WA 1889 *** 
SEC. 3. All officers not liable to impeachment shall be subject to removal for misconduct or
malfeasance in office, in such manner as may be provided by law.
*** SEND ***
*** AEND ***
*** ASTART 006.0 WA 1889 *** 
                  ARTICLE VI

            ELECTIONS AND ELECTIVE RIGHTS
*** SSTART 001.0 006.0 0 WA 1889 ***
SECTION 1. All male persons of the age of twenty-one years or over, possessing the following
qualifications, shall be entitled to vote at all elections: They shall be citizens of the United States:
they shall have lived in the state one year, and in the county ninety days, and in the city, town,
ward or precinct thirty days immediately preceding the election at which they offer to vote:
Provided, That Indians not taxed shall never be allowed the elective franchise: Provided farther,
That all male persons who at the time of the adoption of this constitution are qualified electors of
the territory shall be electors.
*** SEND ***
Best Regards,

Brandon Kastning
“And one of the elders saith unto me, Weep not: behold, the Lion of the tribe of Juda, the Root of David, hath prevailed to open the book,...” - Revelation 5:5 (KJV)

“And oppress not the widow, nor the fatherless, the stranger, nor the poor; and ...” - Zechariah 7:10 (KJV)

#LetHISPeopleGo

Reply
#2
Admins/Moderators: I attempted to edit my OP and I received a message too long error as included in below screenshots! I was forced to post a reply. Please understand!

**** Update: 01/21/2022 @ Approx. 10:35 ****

Without knowing the best way to approach this; I decided to use LibreCalc and create a 5 column CSV and use copy and paste from .TXT (in BlueFish using the line numbers to keep track).

Then using the CSV to MariaDB/MySQL Payload Python Script Below (This one I have specified column "fulltext_contents" to be datatype[dtype] "LONGTEXT"; I was receiving errors after row 1 on LibreCalc CSV when testing:

import pandas as pd
import mysql.connector
from sqlalchemy import create_engine
from sqlalchemy.dialects.mysql import LONGTEXT
dtype = { "fulltext_contents": LONGTEXT }


myd = pd.read_csv('UMD_WA_1889_CSV2.csv')

engine = create_engine('mysql+mysqlconnector://brandon:[email protected]/Exodus_J3x_Dev_Bronson')

myd.to_sql(name='UMD_WA_1889_CSV2', con=engine, if_exists='replace', index=False, dtype=dtype)
What you will notice is a comparison between CSV -> SQL (And the Text *Formatting* being wrong). Row 1 worked perfect. Then the rest was failing. And then once I viewed it using HeidiSQL it alters somehow and scrolls (i.e without wordwrap persay). ?

Then I was frustrated and decided to start manually copy and pasting directly into SQL using HeidiSQL again.

While it's *keeping* proper formatting if I open the HeidiSQL cell dialog box and paste and then click check/okay/save. All seems fine.

Then I compared row #1 (the one that worked before needing to specify LONGTEXT on fulltext_contents column) from CSV -> SQL using Python and SQL Alchemy vs. Manual Data Entry (Copy and Paste) from .TXT using BlueFish and the following screenshots is what happened.

I'm confused at how to proceed properly. It seems row 1 entries from LibreCalc, saved as a CSV and then imported using Python and SQL Alchemy created a "perfect entry". Perfect, meaning it kept formatting exactly like in Text, UTF-8 (.TXT).

However, that perfect formatting didn't continue as I continued with entries below row 1 on LibreCalc (CSV) file.

You can see how it doesn't keep the formatting on the entire text file in row 2 and requires me to "scroll endlessly to the right with zero maintained text formatting". -- So... virtually pointless.

My manual Data Entry directly into SQL using HeidiSQL seems fruitful; however, there are spacing issues between lines that are *not* there on LibreCalc CSV row 1 (as seen in screenshots). Comparing the both leaves me scratching my head.

Moving forward with manual entry into SQL vs. LibreCalc CSV is providing me with gapped formatting in spacing.

And continuing with what I was doing with Entries pasted into LibreCalc CSV stopped working as seen on row 2.

Does anyone know what's happening here and what's the best practices to achieve LibreCalc CSV -> SQL (row 1) 's perfect formatting for *ALL* entries? And is there a way to do this without pasting into LibreCalc (perhaps a different way of loading my paste's into a CSV a different method perhaps that wouldn't fail by unknown reasons to me).

Thank you all for this forum!

Here are the screen shots:

[Image: Libre-Calc-1-2022-01-21-10-04-01.png]
free picture upload

Perfect Formatting:
[Image: UMD-WA-1889-4-CSV-SQL-1-2022-01-21-10-05-22.png]
share picture

[Image: UMD-WA-1889-4-CSV-SQL-2-2022-01-21-10-06-27.png]

Not Perfect Formatting (Almost -- Double Spaces?):
[Image: UMD-WA-1889-DE-SQL-1-2022-01-21-10-07-08.png]

[Image: Blue-Fish-Wash-1889-Copy-and-Paste-1-202...-08-16.png]

Failed Editing Message (Too Long):

[Image: FAIL-EDIT-2022-01-21-10-26-59.png]
picture to url
“And one of the elders saith unto me, Weep not: behold, the Lion of the tribe of Juda, the Root of David, hath prevailed to open the book,...” - Revelation 5:5 (KJV)

“And oppress not the widow, nor the fatherless, the stranger, nor the poor; and ...” - Zechariah 7:10 (KJV)

#LetHISPeopleGo

Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
Question Python Obstacles | Jeet-Kune-Do | BS4 (Tags > MariaDB) [URL/Local HTML] BrandonKastning 0 1,400 Feb-08-2022, 08:55 PM
Last Post: BrandonKastning
Question Securing King James Bible (KJV) + King James Bible 1611 (KJV1611) in MariaDB/MySQL BrandonKastning 4 2,643 Jan-18-2022, 03:42 PM
Last Post: BrandonKastning
Exclamation Debian 10 Buster Environment - Python 3.x (MariaDB 10.4.21) | Working Connector? BrandonKastning 9 4,117 Jan-04-2022, 08:27 PM
Last Post: BrandonKastning
  Python Obstacles | Karate | HTML/Scrape Specific Tag and Store it in MariaDB BrandonKastning 8 3,090 Nov-22-2021, 01:38 AM
Last Post: BrandonKastning
  Build a simple Webapp with Python Flask and mariaDB newbie1 3 3,317 Jun-04-2020, 09:34 PM
Last Post: lmolter54
  Python3 + BeautifulSoup4 + lxml (HTML -> CSV) - How to write 3 Columns to MariaDB? BrandonKastning 21 6,710 Mar-23-2020, 05:51 PM
Last Post: ndc85430

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020