State Parcel: Shortname, Longname, FIPS

insert.sql

INSERT into parcel_state values 
(1, 'AL', 'Alabama', 1),
(2, 'AK', 'Alaska', 2),
(3, 'AZ', 'Arizona', 4),
(4, 'AR', 'Arkansas', 5),
(5, 'CA', 'California', 6),
(6, 'CO', 'Colorado', 8),
(7, 'CT', 'Connecticut', 9),
(8, 'DE', 'Delaware', 10),
(9, 'DC', 'District of Columbia', 11),
(10, 'FL', 'Florida', 12),
(11, 'GA', 'Georgia', 13),
(12, 'HI', 'Hawaii', 15),
(13, 'ID', 'Idaho', 16),
(14, 'IL', 'Illinois', 17),
(15, 'IN', 'Indiana', 18),
(16, 'IA', 'Iowa', 19),
(17, 'KS', 'Kansas', 20),
(18, 'KY', 'Kentucky', 20),
(19, 'LA', 'Louisiana', 22),
(20, 'ME', 'Maine', 23),
(21, 'MD', 'Maryland', 24),
(22, 'MA', 'Massachusetts', 25),
(23, 'MI', 'Michigan', 26),
(24, 'MN', 'Minnesota', 27),
(25, 'MS', 'Mississippi', 28),
(26, 'MO', 'Missouri', 29),
(27, 'MT', 'Montana', 30),
(28, 'NE', 'Nebraska', 31),
(29, 'NV', 'Nevada', 32),
(30, 'NH', 'New Hampshire', 33),
(31, 'NJ', 'New Jersey', 34),
(32, 'NM', 'New Mexico', 35),
(33, 'NY', 'New York', 36),
(34, 'NC', 'North Carolina', 37),
(35, 'ND', 'North Dakota', 38),
(36, 'OH', 'Ohio', 39),
(37, 'OK', 'Oklahoma', 40),
(38, 'OR', 'Oregon', 41),
(39, 'PA', 'Pennsylvania', 42),
(40, 'PR', 'Puerto Rico', 72),
(41, 'RI', 'Rhode Island', 44),
(42, 'SC', 'South Carolina', 45),
(43, 'SD', 'South Dakota', 46),
(44, 'TN', 'Tennessee', 47),
(45, 'TX', 'Texas', 48),
(46, 'UT', 'Utah', 49),
(47, 'VT', 'Vermont', 50),
(48, 'VA', 'Virginia', 51),
(49, 'WA', 'Washington', 53),
(50, 'WV', 'West Virginia', 54),
(51, 'WI', 'Wisconsin', 55),
(52, 'WY', 'Wyoming', 56);