Museum Schema

-- run this script as the administrator. It will create a user account named MUSEUM and build the tables in that schema -- these statements may fail the first time you run this script because the tables do not yet exist drop TABLE MUSEUM.item_medium; drop TABLE MUSEUM.medium; drop TABLE MUSEUM.item; drop TABLE MUSEUM.policy_peril; drop TABLE MUSEUM.peril; drop table MUSEUM.policy; drop table MUSEUM.INSURER; drop table MUSEUM.OWNER; -- Drop USER MUSEUM DROP USER MUSEUM CASCADE; -- USER SQL CREATE USER MUSEUM IDENTIFIED BY Anti_Theft_Device22; -- ADD ROLES GRANT CONNECT TO MUSEUM; GRANT RESOURCE TO MUSEUM; GRANT CREATE VIEW TO MUSEUM; ALTER USER MUSEUM DEFAULT ROLE CONNECT,RESOURCE; ALTER USER MUSEUM QUOTA UNLIMITED on DATA; -- ENABLE REST BEGIN ORDS.ENABLE_SCHEMA( p_enabled => TRUE, p_schema => 'MUSEUM', p_url_mapping_type => 'BASE_PATH', p_url_mapping_pattern => 'museum', p_auto_rest_auth=> TRUE ); commit; END; / CREATE TABLE MUSEUM.OWNER( owner_id int GENERATED ALWAYS as IDENTITY(START with 100 INCREMENT by 1) primary key, name varCHAR(60), address VARCHAR(50), CITY VARCHAR(25), STATE CHAR(2), ZIP CHAR(5), EMAIL VARCHAR(21), phone VARCHAR(14) ); CREATE TABLE MUSEUM.insurer( insurer_id int GENERATED ALWAYS as IDENTITY(START with 200 INCREMENT by 1) primary key, name varCHAR(60), address VARCHAR(50), address2 VARCHAR(50), CITY VARCHAR(25), STATE CHAR(2), ZIP CHAR(5), EMAIL VARCHAR(21), phone VARCHAR(14) ); CREATE TABLE MUSEUM.policy( policy_id int GENERATED ALWAYS as IDENTITY(START with 300 INCREMENT by 1) primary key, policy_number varCHAR(20), limit int, deductible number(6,0), insurer_id int references museum.insurer ); CREATE TABLE MUSEUM.peril( peril_id int GENERATED ALWAYS as IDENTITY(START with 1 INCREMENT by 1) primary key, peril varCHAR(20) ); CREATE TABLE MUSEUM.policy_peril( policy_id int references museum.policy, peril_id int references museum.peril, primary key (policy_id, peril_id) ); create table MUSEUM.item( item_id int GENERATED ALWAYS as IDENTITY(START with 1000 INCREMENT by 1) primary key, item_number varchar(50), borrowed_date date, due_date date, title varchar(60), type varchar(10), name varchar(100), creator varchar(600), city varchar(30), state varchar(15), state_assoication varchar(5), date_made varchar(20), description varchar(1500), image_url varchar(65), image blob, owner_id int references museum.owner, policy_id int references museum.policy ); CREATE TABLE MUSEUM.medium( medium_id int GENERATED ALWAYS as IDENTITY(START with 20 INCREMENT by 1) primary key, medium varCHAR(25), modifier varchar(10) ); CREATE TABLE MUSEUM.item_medium( item_id int references museum.item, medium_id int references museum.medium, primary key (item_id, medium_id) ); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('American Antiquarian Society','185 Salisbury St','Worcester','MA','01609','(508) 755-5221'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('American Revolution Institute','2118 Massachusetts Avenue, NW','Washington','DC','20008','(202) 785-2040'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('American Revolution Museum at Yorktown','200 Water St','Yorktown','VA','23690','(757) 253-4838'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('B. Owen Williams','10 Dogwood Dr','Napanoch','NY','12458','(914) 479-7221'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('David Center for the American Revolution','104 South Fifth Street','Philadelphia','PA','19106','(215) 440-3400'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('Dr. Marion T. Lane','3821 Nanlyn Farm Circle','Doylestown','PA','18902','(215) 348-1047'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('George Washington''s Mount Vernon','3200 Mount Vernon Memorial Highway','Mount Vernon','VA','22121','(703) 780-2000'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('Landenberger Family Foundation','607 8th Street','Philadelphia','PA','19103','(609) 922-0598'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('Massachusetts Historical Society','1154 Boylston St','Boston','MA','02215','(617) 536-1608'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('McNeil Americana Collection','2600 Benjamin Franklin Pkwy','Philadelphia','PA','19103','(215) 763-8100'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('Museum of the American Revolution','101 S 3rd St','Philadelphia','PA','19106','(215) 253-6731'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('National Society Of The Sons Of The American Revolution','809 West Main Street','Louisville','KY','40202','(502) 589-1776'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('Old Barracks Museum','101 Barrack Street','Trenton','NJ','08608','(609) 396-1776'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('Pennsylvania Society of Sons of the Revolution','121 South Broad Street','Philadelphia','PA','19107','(215) 545-1888'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('Peter H. Tillou','109 Prospect Street','Litchfield','CT','06759','(860) 567-5706'); insert into museum.owner(name,address,CITY,STATE,ZIP,phone) values('Southern Revolutionary War Institute','212 E Jefferson St.','York','SC','29745','(803) 818-6768'); insert into museum.insurer(name,address,address2,CITY,STATE,ZIP,EMAIL,phone) values('AmTrust Financial ','59 Maiden Lane',NULL,'New York','NY','10038','(212) 220-7120',''); insert into museum.insurer(name,address,address2,CITY,STATE,ZIP,EMAIL,phone) values('EMC Insurance Companies','717 Mulberry Street',NULL,'Des Moines','IA','50306','(800) 447-2295',''); insert into museum.insurer(name,address,address2,CITY,STATE,ZIP,EMAIL,phone) values('Gallagher US','2850 Golf Road',NULL,'Rolling Meadows','IL','60008','(630) 773-3800',''); insert into museum.insurer(name,address,address2,CITY,STATE,ZIP,EMAIL,phone) values('Grundy Insurance','400 Horsham Road',NULL,'Horsham','PA','19044','(215) 674-1099',''); insert into museum.insurer(name,address,address2,CITY,STATE,ZIP,EMAIL,phone) values('Huntington T. Block','2001 K Street, NW','Suite 625 North','Washington','DC','20006','(855) 219-3189',''); insert into museum.insurer(name,address,address2,CITY,STATE,ZIP,EMAIL,phone) values('Liberty Mutual Insurance Company','175 Berkeley Street',NULL,'Boston','MA','2116','(617) 357-9500',''); insert into museum.insurer(name,address,address2,CITY,STATE,ZIP,EMAIL,phone) values('Markel Insurance','70 Seaview Avenue',NULL,'Stamford','CT','6902','(800) 622-1840',''); insert into museum.insurer(name,address,address2,CITY,STATE,ZIP,EMAIL,phone) values('Philadelphia Insurance Companies','One Bala Plaza','Ste 100','Bala Cynwyd','PA','19004','(800) 873-4552',''); insert into museum.insurer(name,address,address2,CITY,STATE,ZIP,EMAIL,phone) values('The Travelers Companies','One Tower Square',NULL,'Hartford','CT','6183','(800) 506-3358',''); insert into museum.insurer(name,address,address2,CITY,STATE,ZIP,EMAIL,phone) values('William G. Fleischer','29 Broadway','Suite 1511','New York','NY','10006','(212) 566-1881',''); insert into museum.insurer(name,address,address2,CITY,STATE,ZIP,EMAIL,phone) values('XL Reinsurance America','70 Seaview Avenue',NULL,'Stamford','CT','6902','(800) 622-1840',''); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('93 EMC 370338',13370000,4000,(select insurer_id from museum.insurer where name='EMC Insurance Companies')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('38 EMC 372569',11870000,4000,(select insurer_id from museum.insurer where name='EMC Insurance Companies')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('7FOVX66KN',9630000,6000,(select insurer_id from museum.insurer where name='Markel Insurance')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('233998225 546 1',14920000,4000,(select insurer_id from museum.insurer where name='XL Reinsurance America')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('PIC4853888932',10380000,6000,(select insurer_id from museum.insurer where name='Philadelphia Insurance Companies')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('25055586734',8800000,1000,(select insurer_id from museum.insurer where name='Huntington T. Block')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('PIC4692496695',8940000,5000,(select insurer_id from museum.insurer where name='Philadelphia Insurance Companies')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('PIC7731023400',13900000,0,(select insurer_id from museum.insurer where name='Philadelphia Insurance Companies')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('W671263175',15390000,7000,(select insurer_id from museum.insurer where name='The Travelers Companies')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('28-CNP-9811',15400000,1000,(select insurer_id from museum.insurer where name='Gallagher US')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('27859275800',6600000,1000,(select insurer_id from museum.insurer where name='Huntington T. Block')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('30 EMC 876561',13000000,10000,(select insurer_id from museum.insurer where name='EMC Insurance Companies')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('H847510825',14350000,0,(select insurer_id from museum.insurer where name='The Travelers Companies')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('876393958 122 6',5250000,0,(select insurer_id from museum.insurer where name='XL Reinsurance America')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('PIC1324292938',8500000,7000,(select insurer_id from museum.insurer where name='Philadelphia Insurance Companies')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('5 9803855 71',12840000,7000,(select insurer_id from museum.insurer where name='Liberty Mutual Insurance Company')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('SMW-395-197742-52',11970000,3000,(select insurer_id from museum.insurer where name='William G. Fleischer')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('4 4071961 28',11390000,9000,(select insurer_id from museum.insurer where name='Liberty Mutual Insurance Company')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('78 EMC 860612',8900000,10000,(select insurer_id from museum.insurer where name='EMC Insurance Companies')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('ART 918657511',9010000,4000,(select insurer_id from museum.insurer where name='AmTrust Financial ')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('7159Z 268243',2940000,8000,(select insurer_id from museum.insurer where name='Grundy Insurance')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('5892I 812031',15100000,3000,(select insurer_id from museum.insurer where name='Grundy Insurance')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('503477687 705 7',13660000,4000,(select insurer_id from museum.insurer where name='XL Reinsurance America')); insert into museum.policy( policy_number, limit, deductible, insurer_id)values('46-BJV-8228',5560000,7000,(select insurer_id from museum.insurer where name='Gallagher US')); insert into museum.peril(peril)values('Aircraft'); insert into museum.peril(peril)values('Earthquake'); insert into museum.peril(peril)values('Explosion'); insert into museum.peril(peril)values('Falling objects'); insert into museum.peril(peril)values('Fire'); insert into museum.peril(peril)values('Flood'); insert into museum.peril(peril)values('Hail'); insert into museum.peril(peril)values('lightning'); insert into museum.peril(peril)values('Riot'); insert into museum.peril(peril)values('Smoke'); insert into museum.peril(peril)values('Terrorism'); insert into museum.peril(peril)values('Theft'); insert into museum.peril(peril)values('Transit Accident'); insert into museum.peril(peril)values('Vandalism'); insert into museum.peril(peril)values('Windstorm'); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='93 EMC 370338'),(select peril_id from museum.peril where peril='lightning')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='93 EMC 370338'),(select peril_id from museum.peril where peril='Vandalism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='93 EMC 370338'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='93 EMC 370338'),(select peril_id from museum.peril where peril='Terrorism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='93 EMC 370338'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='93 EMC 370338'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='93 EMC 370338'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='38 EMC 372569'),(select peril_id from museum.peril where peril='Aircraft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='38 EMC 372569'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='38 EMC 372569'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='38 EMC 372569'),(select peril_id from museum.peril where peril='Riot')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='38 EMC 372569'),(select peril_id from museum.peril where peril='lightning')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='38 EMC 372569'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='38 EMC 372569'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='38 EMC 372569'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='38 EMC 372569'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='38 EMC 372569'),(select peril_id from museum.peril where peril='Earthquake')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7FOVX66KN'),(select peril_id from museum.peril where peril='Aircraft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7FOVX66KN'),(select peril_id from museum.peril where peril='Vandalism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7FOVX66KN'),(select peril_id from museum.peril where peril='Transit Accident')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7FOVX66KN'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7FOVX66KN'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7FOVX66KN'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7FOVX66KN'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7FOVX66KN'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7FOVX66KN'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7FOVX66KN'),(select peril_id from museum.peril where peril='Earthquake')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='233998225 546 1'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='233998225 546 1'),(select peril_id from museum.peril where peril='Windstorm')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='233998225 546 1'),(select peril_id from museum.peril where peril='Vandalism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='233998225 546 1'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='233998225 546 1'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='233998225 546 1'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='233998225 546 1'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='233998225 546 1'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='233998225 546 1'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4853888932'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4853888932'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4853888932'),(select peril_id from museum.peril where peril='Terrorism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4853888932'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4853888932'),(select peril_id from museum.peril where peril='lightning')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4853888932'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4853888932'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4853888932'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='25055586734'),(select peril_id from museum.peril where peril='Aircraft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='25055586734'),(select peril_id from museum.peril where peril='Windstorm')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='25055586734'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='25055586734'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='25055586734'),(select peril_id from museum.peril where peril='lightning')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='25055586734'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='25055586734'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='25055586734'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='25055586734'),(select peril_id from museum.peril where peril='Earthquake')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4692496695'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4692496695'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4692496695'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4692496695'),(select peril_id from museum.peril where peril='Riot')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4692496695'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4692496695'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC4692496695'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC7731023400'),(select peril_id from museum.peril where peril='Aircraft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC7731023400'),(select peril_id from museum.peril where peril='Windstorm')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC7731023400'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC7731023400'),(select peril_id from museum.peril where peril='Terrorism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC7731023400'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC7731023400'),(select peril_id from museum.peril where peril='lightning')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC7731023400'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC7731023400'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC7731023400'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='W671263175'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='W671263175'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='W671263175'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='W671263175'),(select peril_id from museum.peril where peril='Riot')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='W671263175'),(select peril_id from museum.peril where peril='lightning')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='W671263175'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='W671263175'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='28-CNP-9811'),(select peril_id from museum.peril where peril='Earthquake')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='28-CNP-9811'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='28-CNP-9811'),(select peril_id from museum.peril where peril='Riot')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='28-CNP-9811'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='28-CNP-9811'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='28-CNP-9811'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='28-CNP-9811'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='27859275800'),(select peril_id from museum.peril where peril='Earthquake')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='27859275800'),(select peril_id from museum.peril where peril='Vandalism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='27859275800'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='27859275800'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='27859275800'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='27859275800'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='27859275800'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='27859275800'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='30 EMC 876561'),(select peril_id from museum.peril where peril='Aircraft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='30 EMC 876561'),(select peril_id from museum.peril where peril='Transit Accident')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='30 EMC 876561'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='30 EMC 876561'),(select peril_id from museum.peril where peril='Riot')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='30 EMC 876561'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='30 EMC 876561'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='30 EMC 876561'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='30 EMC 876561'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='30 EMC 876561'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='H847510825'),(select peril_id from museum.peril where peril='Aircraft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='H847510825'),(select peril_id from museum.peril where peril='Windstorm')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='H847510825'),(select peril_id from museum.peril where peril='Transit Accident')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='H847510825'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='H847510825'),(select peril_id from museum.peril where peril='Terrorism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='H847510825'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='H847510825'),(select peril_id from museum.peril where peril='Riot')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='H847510825'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='H847510825'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='H847510825'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='H847510825'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='H847510825'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='876393958 122 6'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='876393958 122 6'),(select peril_id from museum.peril where peril='Windstorm')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='876393958 122 6'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='876393958 122 6'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='876393958 122 6'),(select peril_id from museum.peril where peril='Riot')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='876393958 122 6'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='876393958 122 6'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='876393958 122 6'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='876393958 122 6'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC1324292938'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC1324292938'),(select peril_id from museum.peril where peril='Vandalism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC1324292938'),(select peril_id from museum.peril where peril='Transit Accident')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC1324292938'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC1324292938'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC1324292938'),(select peril_id from museum.peril where peril='Riot')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC1324292938'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='PIC1324292938'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5 9803855 71'),(select peril_id from museum.peril where peril='Aircraft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5 9803855 71'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5 9803855 71'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5 9803855 71'),(select peril_id from museum.peril where peril='Riot')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5 9803855 71'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5 9803855 71'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5 9803855 71'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5 9803855 71'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5 9803855 71'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5 9803855 71'),(select peril_id from museum.peril where peril='Earthquake')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='SMW-395-197742-52'),(select peril_id from museum.peril where peril='Aircraft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='SMW-395-197742-52'),(select peril_id from museum.peril where peril='Transit Accident')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='SMW-395-197742-52'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='SMW-395-197742-52'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='SMW-395-197742-52'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='SMW-395-197742-52'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='SMW-395-197742-52'),(select peril_id from museum.peril where peril='Earthquake')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='4 4071961 28'),(select peril_id from museum.peril where peril='Aircraft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='4 4071961 28'),(select peril_id from museum.peril where peril='Vandalism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='4 4071961 28'),(select peril_id from museum.peril where peril='Transit Accident')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='4 4071961 28'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='4 4071961 28'),(select peril_id from museum.peril where peril='Terrorism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='4 4071961 28'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='4 4071961 28'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='4 4071961 28'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='4 4071961 28'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='4 4071961 28'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='4 4071961 28'),(select peril_id from museum.peril where peril='Earthquake')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='78 EMC 860612'),(select peril_id from museum.peril where peril='Earthquake')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='78 EMC 860612'),(select peril_id from museum.peril where peril='Windstorm')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='78 EMC 860612'),(select peril_id from museum.peril where peril='Vandalism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='78 EMC 860612'),(select peril_id from museum.peril where peril='Transit Accident')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='78 EMC 860612'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='78 EMC 860612'),(select peril_id from museum.peril where peril='Terrorism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='78 EMC 860612'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='78 EMC 860612'),(select peril_id from museum.peril where peril='Riot')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='78 EMC 860612'),(select peril_id from museum.peril where peril='lightning')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='78 EMC 860612'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='78 EMC 860612'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='78 EMC 860612'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='78 EMC 860612'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='ART 918657511'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='ART 918657511'),(select peril_id from museum.peril where peril='Transit Accident')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='ART 918657511'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='ART 918657511'),(select peril_id from museum.peril where peril='Terrorism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='ART 918657511'),(select peril_id from museum.peril where peril='lightning')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='ART 918657511'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='ART 918657511'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='ART 918657511'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7159Z 268243'),(select peril_id from museum.peril where peril='Aircraft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7159Z 268243'),(select peril_id from museum.peril where peril='Windstorm')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7159Z 268243'),(select peril_id from museum.peril where peril='Transit Accident')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7159Z 268243'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7159Z 268243'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7159Z 268243'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7159Z 268243'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='7159Z 268243'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5892I 812031'),(select peril_id from museum.peril where peril='Aircraft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5892I 812031'),(select peril_id from museum.peril where peril='Transit Accident')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5892I 812031'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5892I 812031'),(select peril_id from museum.peril where peril='Terrorism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5892I 812031'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5892I 812031'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5892I 812031'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5892I 812031'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='5892I 812031'),(select peril_id from museum.peril where peril='Earthquake')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='503477687 705 7'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='503477687 705 7'),(select peril_id from museum.peril where peril='Windstorm')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='503477687 705 7'),(select peril_id from museum.peril where peril='Vandalism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='503477687 705 7'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='503477687 705 7'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='503477687 705 7'),(select peril_id from museum.peril where peril='lightning')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='503477687 705 7'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='503477687 705 7'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='503477687 705 7'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='503477687 705 7'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='46-BJV-8228'),(select peril_id from museum.peril where peril='Explosion')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='46-BJV-8228'),(select peril_id from museum.peril where peril='Theft')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='46-BJV-8228'),(select peril_id from museum.peril where peril='Terrorism')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='46-BJV-8228'),(select peril_id from museum.peril where peril='Smoke')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='46-BJV-8228'),(select peril_id from museum.peril where peril='Hail')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='46-BJV-8228'),(select peril_id from museum.peril where peril='Flood')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='46-BJV-8228'),(select peril_id from museum.peril where peril='Fire')); insert into museum.policy_peril values((select policy_id from museum.policy where policy_number='46-BJV-8228'),(select peril_id from museum.peril where peril='Falling objects')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2013-72-F', to_date('2020-11-13','YYYY-MM-DD'), to_date('2025-5-13','YYYY-MM-DD'),'"Americans Will Always Fight for Liberty" Poster','Artwork','Office of War Information Poster, No. 26','Printed by United States Government Printing Office','Washington','DC','USA','1943','This poster, produced by the United States Office of War Information (OWI) during the Second World War (1939-1945), makes a direct link between the Revolutionary War and the fight against the Axis powers (Germany, Italy, and Japan). In this image, a column of American GIs marches past a ragged line of Continental Army soldiers at Valley Forge, over whom General George Washington''s Headquarters Flag (now in the collection of the Museum of the American Revolution) waves. This stirring image encouraged Americans of the 1940s to see themselves as the latest of many generations who had struggled and sacrificed in the name of Liberty. Artist Bernard Perlin (1918-2014), the son of Russian Jewish immigrants, used American soldiers as models for the painting from which this poster was produced. A larger version of the poster hung in Union Station in Washington, DC, during the Second World War.','https://thegove.github.io/documents/museum/images/06R50KZ.jpg',(select owner_id from museum.owner where name='Southern Revolutionary War Institute'),(select policy_id from museum.policy where policy_number='93 EMC 370338')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2012.00.0001', to_date('2020-1-25','YYYY-MM-DD'), to_date('2025-3-25','YYYY-MM-DD'),'"Arms of Liberty" Punch Bowl','Object','Punch Bowl',NULL,'Jingdezhen','China',NULL,'1770-1775','This porcelain punch bowl was made and decorated in China around 1770 for export to Britain and its American colonies. The design on the exterior of the bowl was intended to poke fun at those who had opposed the English politician John Wilkes (1727-97), a proponent of English civil liberties, parliamentary reform, and American rights. Wilkes was elected to the House of Commons several times, but was repeatedly expelled for attacking King George III and his loyalists. American patriots, including Boston''s Sons of Liberty, rallied to the cry of "Wilkes and Liberty!" and incorporated his name and likeness into broadsides, drinking bowls, cuff links, and other items.','https://thegove.github.io/documents/museum/images/F07F1YZ.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='38 EMC 372569')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('814.54 GOL 1997', to_date('2020-4-24','YYYY-MM-DD'), to_date('2024-8-24','YYYY-MM-DD'),'"Success to Boston" Mug','Object','Mug',NULL,'Staffordshire','England','UK','1774-1776','Inscribed "Success to ye city of Boston, Liberty For Ever" and depicting a fantastical townscape, this English ceramic mug (circa 1770s) evokes the early years of the American Revolution. The mug particularly celebrates the American city of Boston as a guardian of Liberty. It may date to the time of the Coercive Acts of 1774. Part of the British Crown''s punishment for the famous Boston Tea Party of 1773, these acts closed the port of Boston and suspended the Massachusetts governing charter. Rather than quelling the growing discontent, the Coercive Acts only stoked the fires of rebellion and garnered sympathy for Massachusetts in the colonies and among political sympathizers in England.','https://thegove.github.io/documents/museum/images/10Q08YH.jpg',(select owner_id from museum.owner where name='American Revolution Museum at Yorktown'),(select policy_id from museum.policy where policy_number='7FOVX66KN')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('002.09 AGA 2015', to_date('2021-7-15','YYYY-MM-DD'), to_date('2025-1-15','YYYY-MM-DD'),'A New Method of Macarony Making, as practiced at Boston','Artwork','A New Method of Macarony Making, as practised at Boston','Printed by Carrington Bowles','London','England','UK','1774','Published in London in 1774, this print spread news about the growing colonial resistance to British policies in America and helped to sway the British public''s opinion of the Sons of Liberty. The print mocks the Bostonians who tarred and feathered British tax official John Malcolm soon after the Boston Tea Party. Malcolm, who survived the attack, is shown begging for mercy as tea is about to be poured down his throat. The print hoped to encourage sympathy for Malcolm and ridicule for the Americans who assaulted him.','https://thegove.github.io/documents/museum/images/099C0ZZ.jpg',(select owner_id from museum.owner where name='George Washington''s Mount Vernon'),(select policy_id from museum.policy where policy_number='233998225 546 1')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('8755', to_date('2019-4-4','YYYY-MM-DD'), to_date('2025-1-4','YYYY-MM-DD'),'Abel Scott''s Powder Horn','Object','Powder Horn',NULL,'Dorchester','Massachusetts','USA','December 26, 1775','New Englander Abel Scott of Whately, Massachusetts, served in five military campaigns during the Revolutionary War, first marching from home the day after the battles of Lexington and Concord in April 1775. Scott, or a fellow soldier, engraved this detailed view of British-occupied Boston as British and New England forces eyed one another across the fortifications and harbor encircling the town. British troops and Loyalist refugees were forced to evacuate Boston after American troops constructed fortifications and placed artillery on Dorchester Heights on the night of March 4, 1776.','https://thegove.github.io/documents/museum/images/CB129ZZ.jpg',(select owner_id from museum.owner where name='Pennsylvania Society of Sons of the Revolution'),(select policy_id from museum.policy where policy_number='PIC4853888932')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('99-0678373', to_date('2021-10-17','YYYY-MM-DD'), to_date('2024-9-17','YYYY-MM-DD'),'American Military Drum','Object','Drum','Made by Robert Crosman','Taunton','Massachusetts','USA','1740','This rare American-made military drum dates to 1740. The second oldest signed and dated American drum in existence, it is inscribed with the name of its maker, Robert Crosman of Taunton, Massachusetts.','https://thegove.github.io/documents/museum/images/079K00Z.jpg',(select owner_id from museum.owner where name='American Revolution Institute'),(select policy_id from museum.policy where policy_number='25055586734')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('4113-4', to_date('2021-8-20','YYYY-MM-DD'), to_date('2024-7-20','YYYY-MM-DD'),'Astronaut John Glenn''s Revolutionary War Flag','Object','Washington’s Headquarters Flag (reproduction)','Made by Sally Queen and Associates','Arlington','Virginia','USA','1998','Astronaut John Glenn carried this reproduction of General George Washington''s Headquarters Flag — the original of which is in collection of the Museum of the American Revolution — into space as part of the lead up to the 1999 bicentennial commemorations of Washington''s death in 1799. Glenn, who had become the first American to orbit the earth in 1962, returned to space aboard the Space Shuttle Discovery in 1998. At 77, he was the oldest person ever to enter space. He and the other members of the Discovery crew traveled 3.6 million miles and orbited the earth 134 times. This flag accompanied them on the entire journey.','https://thegove.github.io/documents/museum/images/0CLC7ZZ.jpg',(select owner_id from museum.owner where name='Dr. Marion T. Lane'),(select policy_id from museum.policy where policy_number='PIC4692496695')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2013.04.0001', to_date('2020-10-27','YYYY-MM-DD'), to_date('2024-7-27','YYYY-MM-DD'),'Badge of the Blew and Orange','Object','Badge',NULL,NULL,'England','UK','1750-1780','This gold badge belonged to a member of The Loyal and Friendly Society of the Blew and Orange. The society was founded between 1733 and 1736 by officers of the King''s Own Royal Regiment to commemorate the Glorious Revolution of 1688 and the accession of the House of Hanover in 1714. On the eve of the American Revolution, the society included among its members numerous officers in the Boston Garrison, many of whom took part in the battles of Lexington and Concord.','https://thegove.github.io/documents/museum/images/0FCD8ZZ.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='38 EMC 372569')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('4687-6', to_date('2021-8-20','YYYY-MM-DD'), to_date('2024-7-20','YYYY-MM-DD'),'Baron von Steuben''s Regulations','Object','Regulations for the Order and Discipline of the Troops of the United States','Printed by Eleazer Oswald','Philadelphia','Pennsylvania','USA','1786','Prussian officer Friedrich Wilhelm Baron von Steuben developed a simplified system of drill and discipline during the Valley Forge encampment of 1777-1778 that helped to forge the Continental Army into an effective fighting force. First published in 1779, Baron von Steuben''s "Regulations" remained the standard for the United States Army and state militia forces through the War of 1812. The English-born Eleazer Oswald, who issued this edition in Philadelphia in 1786, had served in the Continental Army throughout the Revolutionary War before returning to the printing trade.','https://thegove.github.io/documents/museum/images/0KQD4ZZ.jpg',(select owner_id from museum.owner where name='Dr. Marion T. Lane'),(select policy_id from museum.policy where policy_number='PIC4692496695')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2004-41-U', to_date('2020-11-13','YYYY-MM-DD'), to_date('2025-5-13','YYYY-MM-DD'),'Battle of Germantown','Artwork','Battle of Germantown','Painted by Xavier della Gatta','Naples','Italy','EU','1782','This painting depicts a scene from the Battle of Germantown, fought on October 4, 1777. On the right is a rendering of the Benjamin Chew House, where troops from the British 40th Regiment held off the attacking Continental Army in some of the bloodiest fighting of the battle. British Army light infantry Lieutenant Richard St. George Mansergh St. George, an Irish artist and veteran of the battle, commissioned this painting by Italian artist Xavier della Gatta in 1782. St. George is depicted in the foreground of the painting being carried off the battlefield after suffering a traumatic head wound in the opening moments of the action. He battled the long-term consequences of that wound for the rest of his life.','https://thegove.github.io/documents/museum/images/07C33ZZ.jpg',(select owner_id from museum.owner where name='Southern Revolutionary War Institute'),(select policy_id from museum.policy where policy_number='93 EMC 370338')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('4503/119', to_date('2020-12-7','YYYY-MM-DD'), to_date('2025-2-7','YYYY-MM-DD'),'Battle of Paoli','Artwork','Battle of Paoli','Painted by Xavier della Gatta','Naples','Italy','EU','1782','On the night of September 20-21, 1777, a column of British soldiers launched a surprise attack on Continental Army troops encamped in a field near modern-day Malvern, Pennsylvania. In the ensuing struggle, known as the Battle of Paoli, British light infantrymen and light dragoons inflicted heavy casualties on Pennsylvania Brigadier General Anthony Wayne''s fleeing troops. British Army light infantry Lieutenant Richard St. George Mansergh St. George, an Irish artist and veteran of the battle, commissioned this painting by Italian artist Xavier della Gatta in 1782 to remember the violence and trauma he experienced at Paoli.','https://thegove.github.io/documents/museum/images/05UT4JZ.jpg',(select owner_id from museum.owner where name='David Center for the American Revolution'),(select policy_id from museum.policy where policy_number='PIC7731023400')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('48565', to_date('2020-6-13','YYYY-MM-DD'), to_date('2024-9-13','YYYY-MM-DD'),'Benjamin Lincoln''s Sword','Object','Saber (sword)',NULL,NULL,NULL,'USA','1775-1783','This sword belonged to Major General Benjamin Lincoln, General Washington''s second in command at the Siege of Yorktown. When British General Cornwallis sent his own second in command to surrender in his place at Yorktown on October 19, 1781, Washington had Lincoln accept their surrender.','https://thegove.github.io/documents/museum/images/0RWJ3KZ.jpg',(select owner_id from museum.owner where name='Peter H. Tillou'),(select policy_id from museum.policy where policy_number='W671263175')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('52-171.135', to_date('2021-2-17','YYYY-MM-DD'), to_date('2025-2-17','YYYY-MM-DD'),'British and French Swords','Object','Small Sword','Made by Jacques-T Lecourt','Paris','France','EU','1774-1793','On the left is a rare French presentation sword from the period of the American Revolution that bears the inscription "Ex Dono Regis" (Given by the King) on its gilded blade. The chiseled steel hilt is overlaid in gold with the royal arms of France, the royal monogram, and a silver-gilt medallion portrait of King Louis XVI. The military trophies incorporated into its design suggest that it was awarded for bravery. On the right is a finely decorated English sword, with cast and chased military trophies on the shells of its silver hilt, that bears the motto "Ne me tire pas sans raison, Ne me remette point sans honneur" (Draw me not without reason, Sheath me not without honor) on its blade. It is of a common form widely used by military officers in the British and American armies of 1775-83.','https://thegove.github.io/documents/museum/images/0BPK71Z.jpg',(select owner_id from museum.owner where name='National Society Of The Sons Of The American Revolution'),(select policy_id from museum.policy where policy_number='28-CNP-9811')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('77-64.182', to_date('2021-2-17','YYYY-MM-DD'), to_date('2025-2-17','YYYY-MM-DD'),'British Gorget','Object','Gorget','Made by Thomas Hall','London','England','UK','1775-1776','This silver gorget was made in England in 1775-1776 for an officer of the British Army''s 60th or Royal American Regiment. Originally raised in Pennsylvania and surrounding colonies during the French and Indian War, elements of the 60th Regiment served in many campaigns of the Revolutionary War. The officers in the 60th Regiment wore matching silver gorgets, coat buttons, coat trimmings, and belt buckles as part of their uniforms to show off their rank.','https://thegove.github.io/documents/museum/images/0D158J6.jpg',(select owner_id from museum.owner where name='National Society Of The Sons Of The American Revolution'),(select policy_id from museum.policy where policy_number='28-CNP-9811')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('9063', to_date('2019-4-4','YYYY-MM-DD'), to_date('2025-1-4','YYYY-MM-DD'),'British Musket','Object','Pattern 1756 Long Land Musket',NULL,NULL,'England','UK','1756-1768','This British musket was made following a pattern developed in 1756 and is marked to the 4th Regiment of Foot, also known as the "King''s Own." Most British infantrymen carried muskets like this one at the beginning of the Revolutionary War. This musket''s provenance, or history of ownership, suggests that an American soldier captured it from the "King''s Own" regiment at the Battle of Germantown, near Philadelphia, on October 4, 1777.','https://thegove.github.io/documents/museum/images/02170JT.jpg',(select owner_id from museum.owner where name='Pennsylvania Society of Sons of the Revolution'),(select policy_id from museum.policy where policy_number='PIC4853888932')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('4591-5', to_date('2021-12-10','YYYY-MM-DD'), to_date('2025-5-10','YYYY-MM-DD'),'British Officer''s Hanger','Object','Hanger (sword) and Scabbard','Made by James Cullum','London','England','UK','1776-1777','The stout blades on hangers like this one made them versatile fighting weapons. The shorter blade length made hangers easier for infantry officers to carry than longer-bladed sabers. This hanger''s gilt pommel is shaped like a lion, an ancient symbol of Great Britain.','https://thegove.github.io/documents/museum/images/0U5K0ZZ.jpg',(select owner_id from museum.owner where name='Dr. Marion T. Lane'),(select policy_id from museum.policy where policy_number='PIC4692496695')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('100-247.154', to_date('2021-2-17','YYYY-MM-DD'), to_date('2025-2-17','YYYY-MM-DD'),'British Officer''s Saber','Object','Saber (sword) and Scabbard','Made by Dru Drury','London','England','UK','1778-1779','Made in London, this officer''s saber features a long, single-edged blade used for slashing. Dragoons, elite troops who could fight on either horseback or foot, typically carried sabers. This saber''s pommel is shaped like a lion, an ancient symbol of Great Britain.','https://thegove.github.io/documents/museum/images/09TC4ZZ.jpg',(select owner_id from museum.owner where name='National Society Of The Sons Of The American Revolution'),(select policy_id from museum.policy where policy_number='28-CNP-9811')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('87-1298761', to_date('2021-10-17','YYYY-MM-DD'), to_date('2024-9-17','YYYY-MM-DD'),'Bunker Hill Bible','Object','Bible','Printed by Adrian Watkins','Edinburgh','Scotland','UK','1755','Immediately after surviving the Battle of Bunker Hill, soldier Francis Merrifield of Ipswich, Massachusetts, inscribed the following note inside this Bible: "Cambridge June 17, 1775. I desire to bless God for his Kind aperince [appearance] in delivering me and sparing my life in the late battle fought on Bunker''s Hill. I desire to devote this spared life to His glory and honour. In witness my hand, Francis Merrifield."','https://thegove.github.io/documents/museum/images/B31H110.jpg',(select owner_id from museum.owner where name='American Revolution Institute'),(select policy_id from museum.policy where policy_number='27859275800')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2003.00.0497', to_date('2021-12-3','YYYY-MM-DD'), to_date('2025-5-3','YYYY-MM-DD'),'Bust of George Washington','Artwork','George Washington','Sculpted by William Rush','Philadelphia','Pennsylvania','USA','1817','William Rush, a Philadelphia sculptor, Revolutionary War veteran, and founder of the Pennsylvania Academy of the Fine Arts, modeled this terracotta bust of George Washington for the Academy''s Sixth Annual Exhibition in 1817. The original exhibition label noted: "From the familiarity of the artist with Washington, his opportunities of comparing his work with the original, and his acknowledged talent, it is claimed that this bust is the most perfect likeness existing."','https://thegove.github.io/documents/museum/images/0NQH4ZZ.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='30 EMC 876561')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('do-3423', to_date('2020-6-22','YYYY-MM-DD'), to_date('2025-2-22','YYYY-MM-DD'),'Cash Pallentine''s Continental Army Discharge','Artifact','Discharge',NULL,NULL,NULL,'USA','June 9, 1783','Cash Pallentine (also spelled Palatine) was among hundreds of African Americans who served in Connecticut regiments during the Revolution. He enlisted in 1777, serving until the end of the war. In 1783, with peace on the horizon, General George Washington began issuing discharges. Pallentine''s discharge, signed by Washington, states he served continuously and faithfully for six years, which included the winter at Valley Forge, the Battle of Monmouth, and time in the Hudson Valley.','https://thegove.github.io/documents/museum/images/061M4ZY.jpg',(select owner_id from museum.owner where name='Massachusetts Historical Society'),(select policy_id from museum.policy where policy_number='H847510825')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2003.00.0079', to_date('2020-10-27','YYYY-MM-DD'), to_date('2024-7-27','YYYY-MM-DD'),'Christopher Ludwick''s Cookie Board','Object','Cookie Mold',NULL,'Philadelphia','Pennsylvania','USA','1754-1801','Christopher Ludwick (1720-1801), a native of Hesse-Darmstadt in the German-speaking region of central Europe, established a bakery in Philadelphia in 1754. Ludwick later served as Superintendent of Bakers in the Continental Army during the Revolutionary War. His descendants carefully preserved this carved wooden cookie board or mold as a memento of their ancestor''s role in the founding of the United States.','https://thegove.github.io/documents/museum/images/0QS83DZ.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='38 EMC 372569')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('694.1 BAS 2006', to_date('2020-4-24','YYYY-MM-DD'), to_date('2024-8-24','YYYY-MM-DD'),'Common Sense and Plain Truth','Object','Common Sense and Plain Truth','Printed by John Almon','London','England','UK','June 1776','Philadelphia printers issued works that stoked debate over the American Revolution on both sides of the Atlantic. In the early months of 1776, printer and bookseller Robert Bell published Thomas Paine''s clarion call for independence, Common Sense, and Loyalist James Chalmers'' pointed rebuke, Plain Truth. London publisher John Almon bundled the two works in this June 1776 edition for British readers who wondered "whether Americans are, or are not prepared for a state of independence."','https://thegove.github.io/documents/museum/images/0SBF4ZZ.jpg',(select owner_id from museum.owner where name='American Revolution Museum at Yorktown'),(select policy_id from museum.policy where policy_number='7FOVX66KN')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('722.1 BUR 2009', to_date('2021-7-15','YYYY-MM-DD'), to_date('2025-1-15','YYYY-MM-DD'),'Continental Army Descriptive List','Manuscript','Descriptive List',NULL,'West Point','New York','USA','June 16, 1782','This "descriptive list" for a company of the 7th Massachusetts Regiment was taken at West Point, New York, in 1782. Descriptive lists offer a rare look at the social makeup of the Continental Army. This list records the names, birthplaces, residences, physical descriptions, and enlistment details for the 50 men in the company, including five soldiers of African descent. Many of the New England regiments of the Continental Army were integrated, with soldiers of African and Native American descent serving alongside white soldiers.','https://thegove.github.io/documents/museum/images/0Y9H3ZX.jpg',(select owner_id from museum.owner where name='George Washington''s Mount Vernon'),(select policy_id from museum.policy where policy_number='876393958 122 6')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('cbf1/125', to_date('2020-12-7','YYYY-MM-DD'), to_date('2025-2-7','YYYY-MM-DD'),'Continental Currency (3 Dollars)','Object','Currency','Printed by David Hall and William Sellers','Philadelphia','Pennsylvania','USA','1776','Issued under the authority of the Continental Congress, this example of paper currency from the American Revolution bears the image of an eagle attacking a crane with the Latin motto "EXITUS IN DUBIO EST" (The Outcome is in Doubt). With no authority to tax, the Continental Congress was unable to prevent deep depreciation of its paper currency, and coupled with the widespread circulation of British counterfeit bills, gave rise to the phrase "Not Worth a Continental."','https://thegove.github.io/documents/museum/images/07YM0Z0.jpg',(select owner_id from museum.owner where name='David Center for the American Revolution'),(select policy_id from museum.policy where policy_number='PIC1324292938')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('48556', to_date('2020-6-13','YYYY-MM-DD'), to_date('2024-9-13','YYYY-MM-DD'),'Creamware Punch Bowl','Object','Punch Bowl','Made by Herculaneum Pottery','Liverpool','England','UK','1796-1800','Produced in England in the 1790s, this ceramic punch bowl was made to be purchased by an American. The exterior of the bowl is decorated with a likeness of Benjamin Franklin, the Great Seal of the United States, and a likeness of General George Washington based on Swiss-born artist Pierre Eugène Du Simitière''s 1779 portrait of the general. The exterior also features a short poem, "Health to the Sick / Honour to the Brave: / Success to the Lover: / and Freedom to the / Slave," originally published in England in 1717. Inspired by the American Revolution, debates about combatting both political slavery and racial slavery flourished in both Great Britain and America. It is unknown if the owner of this bowl intended for the poem to be a call for an end to the enslavement of people of African descent or a celebration of the success of the United States in combating British tyranny. However, the bowl is an example of how people used everyday objects to express their opinions and provoke conversation during the American Revolution.','https://thegove.github.io/documents/museum/images/0WWH41Z.jpg',(select owner_id from museum.owner where name='Peter H. Tillou'),(select policy_id from museum.policy where policy_number='W671263175')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('ar-4526', to_date('2020-6-22','YYYY-MM-DD'), to_date('2025-2-22','YYYY-MM-DD'),'Enlisting Foreign Officers','Artwork','Baron de Kalb Introducing Lafayette to Silas Deane','Painted by Alonzo Chappel',NULL,'New York','USA','1857','This 1857 painting by American artist Alonzo Chappel (1828-1887) entitled Baron de Kalb Introducing Lafayette to Silas Deane shows the German-born officer Johann de Kalb introducing American diplomat Silas Deane to the youthful Marquis de Lafayette in Paris in 1776. The Continental Congress had sent Deane as a secret agent to France in order to seek financial and military assistance against the British. Deane enlisted the services of a number of foreign officers. De Kalb and Lafayette, who arrived in Philadelphia in 1777, took leadership roles in the Continental Army.','https://thegove.github.io/documents/museum/images/01B23ZX.jpg',(select owner_id from museum.owner where name='Massachusetts Historical Society'),(select policy_id from museum.policy where policy_number='H847510825')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('49521', to_date('2020-6-13','YYYY-MM-DD'), to_date('2024-9-13','YYYY-MM-DD'),'Ferguson Rifle','Object','Ferguson Rifle','Made by Joseph Hunt','London','England','UK','1775-1780','During the 1775-1776 Siege of Boston, British officers reported the deadly marksmanship of American riflemen. In response, Scottish officer Patrick Ferguson developed a rifled firearm that could be loaded from the breech, or rear of the barrel. This allowed the user to fire up to six rounds a minute, nearly twice the rate of fire of a musket, combined with the accuracy of a rifle. Some British officers purchased these "Ferguson" rifles, like this example, to use on campaign in North America.','https://thegove.github.io/documents/museum/images/0QBG3ZZ.jpg',(select owner_id from museum.owner where name='Peter H. Tillou'),(select policy_id from museum.policy where policy_number='W671263175')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('G393 F965 F876', to_date('2020-3-27','YYYY-MM-DD'), to_date('2025-2-27','YYYY-MM-DD'),'First Newspaper Printing of the Declaration of Independence','Object','Pennsylvania Evening Post','Printed by Benjamin Towne','Philadelphia','Pennsylvania','USA','July 6, 1776','This July 6, 1776 issue of the Pennsylvania Evening Post presented the first newspaper printing of the newly adopted Declaration of Independence. Most Americans read or heard the words of the Declaration of Independence via newspapers and printed broadsides. In Philadelphia, a German language translation appeared in the July 9, 1776 issue of the Pennsylvanischer Staatsbote, a newspaper that served Pennsylvania''s large German-speaking community. By the end of August 1776, the Declaration had been reprinted in at least 29 newspapers and 14 broadsides.','https://thegove.github.io/documents/museum/images/3E0H80M.jpg',(select owner_id from museum.owner where name='American Antiquarian Society'),(select policy_id from museum.policy where policy_number='5 9803855 71')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('rbpe00202000', to_date('2020-9-11','YYYY-MM-DD'), to_date('2024-7-11','YYYY-MM-DD'),'French Gorget','Object','Gorget',NULL,NULL,'France','EU','1767-1789','The silver escutcheon in the center of this brass officer''s gorget, a vestigial piece of armor worn around the neck by European infantry officers as a sign of rank, displays the royal arms of the Bourbon kings of France. French Army officers wore gorgets like this one while serving in America during the Revolutionary War. About 5,000 officers and enlisted men under the command of General Rochambeau, the largest contingent of French troops to come to America during the war, arrived at Newport, Rhode Island, in July 1780.','https://thegove.github.io/documents/museum/images/04CC0ZZ.jpg',(select owner_id from museum.owner where name='B. Owen Williams'),(select policy_id from museum.policy where policy_number='SMW-395-197742-52')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2012.1.3', to_date('2019-1-3','YYYY-MM-DD'), to_date('2025-1-3','YYYY-MM-DD'),'French Musket Marked "UNITED STATES"','Object','Model 1766 Infantry Musket','Made at Charleville Armory','Charleville','France','EU','1766-1774','This musket is one of over 100,000 French arms imported into the United States during the Revolutionary War. In 1777, just before the military alliance between France and the United States became official, 60,000 French arms, mostly muskets, arrived in American ports. This musket is marked "UNITED STATES" on the stock, evidence of its use by a soldier in the Continental Army. On February 24, 1777, the Continental Congress resolved "That all arms or accoutrements, belonging to the united States, shall be stamped or marked with the words UNITED STATES." Congress wanted to combat theft of Continental Army property. Just over a month later, Sergeant Jeremiah Greenman of Rhode Island noted that he and fellow soldiers encamped at Morristown, New Jersey, "were ordered to town to have our guns stamped US."','https://thegove.github.io/documents/museum/images/03R34KZ.jpg',(select owner_id from museum.owner where name='McNeil Americana Collection'),(select policy_id from museum.policy where policy_number='4 4071961 28')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2017.02.01', to_date('2020-10-27','YYYY-MM-DD'), to_date('2024-7-27','YYYY-MM-DD'),'French Naval Cutlass','Object','Cutlass','Made at Klingenthal Factory','Klingenthal','France','EU','1779-1783','American sailors aboard Continental Navy vessels and privateer ships often used French weapons, like this cutlass, as they battled the British Navy. Many ships of the Continental Navy outfitted themselves at the ports along the Atlantic coast of France and sailed north to harass British shipping. A cutlass such as this one could be used for hand-to-hand combat when a ship''s crew boarded an enemy vessel. Cutlers, or blade makers, at France''s royal sword manufactory at Klingenthal made this cutlass. Among the workers at Klingenthal were skilled cutlers recruited from Germany to make swords for the French military. Located in a culturally German region of France, Klingenthal roughly translates from German to the "valley of blades."','https://thegove.github.io/documents/museum/images/02LH3ZZ.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='38 EMC 372569')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2013.4.1', to_date('2019-1-3','YYYY-MM-DD'), to_date('2025-1-3','YYYY-MM-DD'),'George Mason''s Roman History','Object','Titi Livii Historiarum Volumen Septimum','Printed by J. and R. Tonson and J. Watts','London','England','UK','1749','Virginian George Mason, a statesman and American Revolutionary later known as the "Father of the Bill Rights," acquired this volume of ancient Roman history by the author and historian Livy (Titus Livius) in 1769. Mason and other members of America''s founding generation were careful students of history. They looked to the example of ancient Rome for guidance on the structure and operation of republican government. After George Mason died in 1792, his son, Thomson Mason, added his own signature and the year of his father''s passing to the title page. Also visible is the faded ink inscription "Gunston," the name of the Mason home on the banks of the Potomac River south of George Washington''s Mount Vernon.','https://thegove.github.io/documents/museum/images/0N5N0ZZ.jpg',(select owner_id from museum.owner where name='McNeil Americana Collection'),(select policy_id from museum.policy where policy_number='4 4071961 28')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('3673-6', to_date('2021-12-10','YYYY-MM-DD'), to_date('2025-5-10','YYYY-MM-DD'),'George Washington''s Camp Cups','Object','Camp Cups','Made by Edmund Milne','Philadelphia','Pennsylvania','USA','ca. 1775-1783','General George Washington purchased several sets of silver camp cups during the Revolutionary War (1775-1783) for use in his field headquarters. These cups, with later commemorative inscriptions, are part of a set of twelve that descended in the Washington family with a history of having been owned and used by the Commander-in-Chief during the war. They were made by Philadelphia silversmith Edmund Milne, who also made a set of smaller camp cups for the general in August 1777.','https://thegove.github.io/documents/museum/images/04HM43Z.jpg',(select owner_id from museum.owner where name='Dr. Marion T. Lane'),(select policy_id from museum.policy where policy_number='PIC4692496695')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('17-9904459', to_date('2021-10-17','YYYY-MM-DD'), to_date('2024-9-17','YYYY-MM-DD'),'George Wilson''s Sword','Object','Hanger (sword) and Scabbard','Made by James Frazer',NULL,'Kentucky','USA','ca. 1776','Lieutenant Colonel George Wilson of the 8th Pennsylvania Regiment carried this hanger (a short sword) during the Revolutionary War. In December 1776, Wilson and his regiment began a grueling winter march from their post near Pittsburgh to reinforce General George Washington''s dwindling army along the Delaware River. On December 5th, Wilson wrote that his troops were "ill Provided for a March at this season." Some soldiers did not survive the over 300-mile trek. Wilson himself died of a sickness in February 1777, likely caused by the march, soon after the regiment joined up with Washington''s troops.','https://thegove.github.io/documents/museum/images/3E030PZ.jpg',(select owner_id from museum.owner where name='American Revolution Institute'),(select policy_id from museum.policy where policy_number='25055586734')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2009-88-N', to_date('2020-11-13','YYYY-MM-DD'), to_date('2025-5-13','YYYY-MM-DD'),'Hessian Cap Plates','Object','Cap Plates',NULL,NULL,'Germany','EU','1770-1777','These embossed metal pieces once adorned the distinctive military headgear worn by Hessian fusiliers — specialized soldiers who served under British command during the Revolutionary War. Between 1776 and 1783, about 30,000 German-speaking soldiers from the principalities of Hesse-Kassel, Hesse-Hanau, Anhalt-Zerbst, Anspach-Bayreuth, Waldeck, and Brunswick served in America. The largest number of these troops came from Hesse-Kassel, giving rise to the nickname "Hessians." The United States Army Corps of Engineers recovered these fragments in 1915 during dredging operations in the Delaware River near Philadelphia. Recent historical research suggests that they were lost in March 1778, when a British transport ship carrying supplies and reinforcements — including Hessian soldiers — sank after striking obstructions that had been placed in the river by the American Army the previous year.','https://thegove.github.io/documents/museum/images/0M513ZZ.jpg',(select owner_id from museum.owner where name='Southern Revolutionary War Institute'),(select policy_id from museum.policy where policy_number='78 EMC 860612')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('QC9GWL', to_date('2021-8-16','YYYY-MM-DD'), to_date('2025-5-16','YYYY-MM-DD'),'Jacob Latch''s Coat','Object','Coat',NULL,NULL,'Pennsylvania','USA','1810-1820','Revolutionary War veteran Jacob Latch, of Lower Merion, Pennsylvania, wore this coat in the early 1800s, around the time he applied for a pension from the Federal Government for his military service. Latch enlisted in the Continental Army in 1776 at age 17, along with his father and brother. He later served in Captain John Young''s Company of Colonel Jonathan Paschall''s Regiment of Chester County militia, during the Valley Forge encampment of 1777-1778.','https://thegove.github.io/documents/museum/images/04C60ZZ.jpg',(select owner_id from museum.owner where name='Old Barracks Museum'),(select policy_id from museum.policy where policy_number='ART 918657511')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2015.22.0001', to_date('2020-10-27','YYYY-MM-DD'), to_date('2024-7-27','YYYY-MM-DD'),'James Grant''s Campaign Chest','Object','Chest',NULL,NULL,NULL,'USA','1757-1763','British Army Lieutenant James Grant kept his personal belongings in this chest while he served in America during the French and Indian War. Grant could have stored items such as extra clothing, shoes, his papers, writing implements, and tobacco in this chest. A Scotsman, Grant joined the 77th Regiment, a Highland Scottish regiment, as a volunteer in 1757 and received an officer''s commission the following year. The 77th Regiment participated in the successful campaign to capture Fort Duquesne (present-day Pittsburgh) from the French and their American Indian allies in 1758. The regiment later battled Native Americans fighting for their own independence against the British in 1763 in the conflict known as Pontiac''s Rebellion. Grant retired from the British Army in 1763 and settled in Dutchess County, New York. During the Revolutionary War, American Revolutionaries became suspicious of his loyalties as a former British officer. The state of New York put Grant on parole as if he were a prisoner of war to prevent him from subverting the Revolutionaries'' cause.','https://thegove.github.io/documents/museum/images/0U504ZZ.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='38 EMC 372569')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2003.01.282', to_date('2021-12-3','YYYY-MM-DD'), to_date('2025-5-3','YYYY-MM-DD'),'Jeremiah McGowan''s Continental Army Discharge','Object','Discharge',NULL,NULL,NULL,'USA','June 7, 1783','Private Jeremiah McGowan of the 2nd New York Regiment received this discharge, signed by General George Washington, Commander in Chief of the Continental Army, on June 7, 1783. He served for six years, including the Valley Forge Winter of 1777-1778.','https://thegove.github.io/documents/museum/images/0KQ33ZZ.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='38 EMC 372569')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('5-195.112', to_date('2021-2-17','YYYY-MM-DD'), to_date('2025-2-17','YYYY-MM-DD'),'John Chandler''s Sword','Object','Small Sword',NULL,NULL,'Germany','EU','1690-1710','Colonel John Chandler of the 8th Connecticut Regiment carried this small sword during the Revolutionary War as a symbol of his rank. The sword was over 60 years old by the time of the war. Chandler''s command of the 8th Connecticut began on January 1, 1777 but ended during the Valley Forge encampment when he resigned on March 5, 1778. Chandler decided to retire from the Continental Army because he had been suffering from kidney stones. The now famous memoirist of the Revolutionary War, Joseph Plumb Martin, served in Chandler''s regiment.','https://thegove.github.io/documents/museum/images/0M9130Z.jpg',(select owner_id from museum.owner where name='National Society Of The Sons Of The American Revolution'),(select policy_id from museum.policy where policy_number='28-CNP-9811')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('rbpe0010300a', to_date('2020-9-11','YYYY-MM-DD'), to_date('2024-7-11','YYYY-MM-DD'),'Jonathan Pettibone''s Sword','Object','Small Sword','Made by Joseph Copp','New London','Connecticut','USA','ca. 1757','French and Indian War veteran Colonel Jonathan Pettibone carried this small sword, engraved with his name, when he commanded the 18th Connecticut Militia Regiment during the New York campaign of 1776. From their positions in Manhattan, the Connecticut militiamen could hear raging cannon and gun fire as the Battle of Brooklyn Heights began on August 27th. Colonel Pettibone fell ill in September and died in Rye, New York, on his march home. In his will, Pettibone left this sword to his son Jonathan, who also served in the militia.','https://thegove.github.io/documents/museum/images/F0786UZ.jpg',(select owner_id from museum.owner where name='B. Owen Williams'),(select policy_id from museum.policy where policy_number='SMW-395-197742-52')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('E.359', to_date('2019-9-22','YYYY-MM-DD'), to_date('2024-7-22','YYYY-MM-DD'),'Lafayette Parade Banner','Object','Parade Banner','Painted by John Archibald Woodside','Philadelphia','Pennsylvania','USA','1824','Philadelphians celebrated the Marquis de Lafayette''s return to the United States in 1824 with a large parade that passed by Independence Hall. Artist John Archibald Woodside, who was born the same year as the victory at Yorktown, painted this silk banner with a portrait of Lafayette at the center for the parade. The "Victuallers of Philadelphia," the butchers who supplied the residents, taverns, and inns with meat, carried this banner during the procession through the streets of the city. For some reason, Woodside painted over the word "Female," perhaps to correct a mistake. The allegorical figures of fame (left) and liberty (right) hoist a crown of laurels over Lafayette''s head.','https://thegove.github.io/documents/museum/images/0SRS039.jpg',(select owner_id from museum.owner where name='Landenberger Family Foundation'),(select policy_id from museum.policy where policy_number='7159Z 268243')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('CmPfvN', to_date('2021-8-16','YYYY-MM-DD'), to_date('2025-5-16','YYYY-MM-DD'),'Linen Hunting Shirt','Object','Hunting Shirt',NULL,NULL,NULL,'USA','1780-1790','In the summer of 1775, riflemen from Pennsylvania, Maryland, and Virginia joined the New England troops already gathered in Boston to form a Continental Army. Many of these southern soldiers wore fringed linen hunting shirts like this example. A uniquely American garment that originated in the Virginia backcountry, it was thought to evoke the dress of Native Americans. As stories of the riflemen''s marksmanship spread, General Washington saw a psychological advantage in outfitting thousands more of the American soldiers in these distinctive shirts. On July 24, 1776, Washington wrote that he "earnestly encourages the use of hunting shirts," in part because they were "justly supposed to carry no small terror to the enemy, who think every such person a complete marksman."','https://thegove.github.io/documents/museum/images/04HQ03Z.jpg',(select owner_id from museum.owner where name='Old Barracks Museum'),(select policy_id from museum.policy where policy_number='ART 918657511')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('A.732', to_date('2019-9-22','YYYY-MM-DD'), to_date('2024-7-22','YYYY-MM-DD'),'Map of the Siege of Yorktown','Item','Map of the Siege of Yorktown','Drawn by Sebastian Bauman','Philadelphia','Pennsylvania','USA','1782','This map celebrates the triumph of the allied Continental and French forces over the British Army at the Siege of Yorktown in 1781. German-born Continental Artillery officer Sebastian Bauman served at the siege and created this map from his surveys of the battlefield taken three days after the British Army''s surrender. The yellow rectangles plot the positions of the French troops, while the blue rectangles show the positions of the Continental Army during siege. Bauman included the location of General Washington''s headquarters just above the text describing the map. Engraved and published in Philadelphia in 1782, Bauman distributed copies of this map to fellow army officers to show off his skills and celebrate the victory.','https://thegove.github.io/documents/museum/images/03HN4DZ.jpg',(select owner_id from museum.owner where name='Landenberger Family Foundation'),(select policy_id from museum.policy where policy_number='7159Z 268243')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('392.12 HEI 2009', to_date('2021-7-15','YYYY-MM-DD'), to_date('2025-1-15','YYYY-MM-DD'),'March to Valley Forge','Artwork','The March to Valley Forge, December 19, 1777','Painted by William Brooke Thomas Trego','Philadelphia','Pennsylvania','USA','1883','One of the most iconic commemorative works on the American Revolution, William B. T. Trego''s March to Valley Forge was painted in Philadelphia and exhibited at the Pennsylvania Academy of the Fine Arts in 1883. Trego''s inspiration was a passage from Washington Irving''s Life of Washington: "Sad and dreary was the march to Valley Forge, uncheered by the recollection of any recent triumph. . . Hungry and cold were the poor fellows who had so long been keeping the field . . . provisions were scant, clothing was worn out, and so badly were they off for shoes, that the footsteps of many might be tracked in blood." Trego suffered a debilitating illness as a child (possibly polio) that left him unable to move his fingers and hands. He painted this masterful work by gripping a brush between the thumb and forefinger of one hand while moving it with the other.','https://thegove.github.io/documents/museum/images/0NRT0KZ.jpg',(select owner_id from museum.owner where name='George Washington''s Mount Vernon'),(select policy_id from museum.policy where policy_number='233998225 546 1')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('mKqRj9', to_date('2021-8-16','YYYY-MM-DD'), to_date('2025-5-16','YYYY-MM-DD'),'Marquis de Lafayette''s Brazier','Object','Brazier',NULL,NULL,NULL,'USA','ca. 1780','This 18th-century copper and iron brazier was designed to hold hot coals and serve as a portable cooking surface. Such implements were particularly useful for military officers and their servants, who spent much of the campaign season (spring through fall) living in tents and frequently shifting the location of their encampments. This example was acquired by the Valley Forge Historical Society in 1918 with the tradition that it had been brought to America by the Marquis de Lafayette during the Revolutionary War, and that Lafayette had presented it to Henry "Light Horse Harry" Lee, a cavalry commander from Virginia.','https://thegove.github.io/documents/museum/images/0RWE04Z.jpg',(select owner_id from museum.owner where name='Old Barracks Museum'),(select policy_id from museum.policy where policy_number='ART 918657511')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2003.9.2', to_date('2019-1-3','YYYY-MM-DD'), to_date('2025-1-3','YYYY-MM-DD'),'Musket Made at Rappahannock Forge','Object','Musket','Made at Rappahannock Forge','Falmouth','Virginia','USA','1775-1778','A Virginia soldier probably carried this musket during the Revolutionary War. Made at Rappahannock Forge near Fredericksburg, Virginia, this musket is a copy of a British Army musket from the period. Only a few muskets made at Rappahannock Forge are known to survive. All are engraved "I Hunter" on their barrels, referring to James Hunter, a wealthy Virginia merchant who owned Rappahannock Forge (the letter "I" was often used in place of the letter "J" during the 1700s). Enslaved and free workers at Rappahannock Forge made pistols, muskets, swords, and camp equipment for the American Army. James Hunter employed several Pennsylvania gunsmiths, including Joseph Perkin who worked at the forge from 1775-1778. Perkin''s initials are marked on the interior of this musket''s lock plate.','https://thegove.github.io/documents/museum/images/0Y3N4ZZ.jpg',(select owner_id from museum.owner where name='McNeil Americana Collection'),(select policy_id from museum.policy where policy_number='4 4071961 28')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2003.8.2', to_date('2019-1-3','YYYY-MM-DD'), to_date('2025-1-3','YYYY-MM-DD'),'Musket Made by Thomas Palmer','Object','Musket','Made by Thomas Palmer','Philadelphia','Pennsylvania','USA','1775','Philadelphia gunsmith Thomas Palmer made this musket in 1775. It is believed to have been one of the 40 muskets ordered by George Washington in January 1775 for the Prince William County Independent Company in Virginia. The First Continental Congress (September-October 1774) tried to secure the repeal of the "Intolerable Acts" by creating the Continental Association in order to enforce a boycott of British imported goods. Local "committees of safety" were charged with enforcing the boycott, and in many colonies, voluntary military organizations were formed to prepare for possible armed conflict. In Virginia, George Washington played an important role in organizing these military units known as "independent companies." Between December 1774 and May 1775, Washington helped to purchase arms, uniforms, flags, and drill manuals from Philadelphia for several independent companies in Northern Virginia. As one of the most experienced military leaders in the colony, Washington served as commander of these companies, and attended at least six military reviews before departing for Philadelphia in May 1775 to attend the Second Continental Congress. Washington wore the uniform of the Fairfax County Independent Company while attending the Congress and was appointed Commander in Chief of the forces of the United Colonies (later the United States) on June 15, 1775.','https://thegove.github.io/documents/museum/images/0DTE8ZZ.jpg',(select owner_id from museum.owner where name='McNeil Americana Collection'),(select policy_id from museum.policy where policy_number='4 4071961 28')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('7849/125', to_date('2020-12-7','YYYY-MM-DD'), to_date('2025-2-7','YYYY-MM-DD'),'Musket Marked "NEW JERSEY"','Object','Musket','Made by Richard Wilson and Company','London','England','UK','ca. 1757','Richard Wilson''s London gun-making firm produced military arms for the colony of New Jersey during and after the French and Indian War. Many of these arms were retained in the colony''s arsenal after the conflict with France and were later issued to New Jersey forces at the beginning of the Revolutionary War. This well-preserved example is marked "NEW JERSEY" on the butt plate, and "S/3" on the wrist plate, denoting government ownership in the former case, and the individual company letter and weapon number in the latter.','https://thegove.github.io/documents/museum/images/00W642Z.jpg',(select owner_id from museum.owner where name='David Center for the American Revolution'),(select policy_id from museum.policy where policy_number='PIC1324292938')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('rbpe00103220', to_date('2020-9-11','YYYY-MM-DD'), to_date('2024-7-11','YYYY-MM-DD'),'Musket Marked "U.STATES"','Object','Musket',NULL,NULL,NULL,'USA','1777-1783','During the Revolutionary War, American gunsmiths struggled to meet the enormous demand for military firearms to equip the Continental Army, as well as state and militia forces. As a result, they often used foreign and American-made parts in their work. This musket is a typical composite piece of wartime production, incorporating British and American components. The butt of this weapon is boldly marked "U.STATES" to designate public ownership and deter theft of government property. Surviving canteens, cartridge boxes, and other equipment used by the Continental Army bear similar marks.','https://thegove.github.io/documents/museum/images/00QB4ZZ.jpg',(select owner_id from museum.owner where name='B. Owen Williams'),(select policy_id from museum.policy where policy_number='SMW-395-197742-52')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2003-36-B', to_date('2020-11-13','YYYY-MM-DD'), to_date('2025-5-13','YYYY-MM-DD'),'Owen Madden''s Tune Book','Object','Tune Book','Written by Owen Madden',NULL,'New York','USA','ca. 1775','This handwritten tune book includes scores and fingering instructions for music of the Revolutionary era. It was compiled by Owen Madden, a schoolmaster from Ulster County, New York, who served as a fifer in the 3rd New York Regiment in 1775.','https://thegove.github.io/documents/museum/images/0PN30ZZ.jpg',(select owner_id from museum.owner where name='Southern Revolutionary War Institute'),(select policy_id from museum.policy where policy_number='78 EMC 860612')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('E.732', to_date('2019-9-22','YYYY-MM-DD'), to_date('2024-7-22','YYYY-MM-DD'),'Panoramic View of Verplanck''s Point','Artwork','Panoramic View of Verplanck’s Point','Painted by Pierre Charles L’Enfant','Verplanck’s Point','New York','USA','1782','This seven-foot-long panoramic watercolor includes the only known eyewitness depiction of George Washington''s headquarters tent during the Revolutionary War. Continental Army engineer Pierre Charles L''Enfant, the Frenchman who later designed the street plan of Washington, DC, painted this watercolor in the fall of 1782. Washington''s tent is shown on the left side, perched on a hill overlooking the Continental Army''s encampment at Verplanck''s Point, New York, which took place from the end of August to mid-October 1782. A French Army officer who visited the camp recalled, "I noticed on a little hill which overlooked the camp… the quarters of General Washington."','https://thegove.github.io/documents/museum/images/09NN3ZZ.jpg',(select owner_id from museum.owner where name='Landenberger Family Foundation'),(select policy_id from museum.policy where policy_number='5892I 812031')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2003.00.0984', to_date('2021-12-3','YYYY-MM-DD'), to_date('2025-5-3','YYYY-MM-DD'),'Patrick Henry''s Law Books','Object','Modern Reports, Being a Collection of Several Special Cases in the Court of King’s Bench','Printed by Richard and Edward Atkins','London','England','UK','1700','This early 18th-century English law book was listed in Patrick Henry''s 1799 estate inventory and still bear Henry''s printed bookplate. This was previous owners was Bartholomew Dandridge, whose older sister Martha Dandridge (Custis) married George Washington in January 1759.','https://thegove.github.io/documents/museum/images/057P0ZZ.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='38 EMC 372569')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('D.945', to_date('2019-9-22','YYYY-MM-DD'), to_date('2024-7-22','YYYY-MM-DD'),'Peter Muhlenberg''s Pistols','Object','Pistols',NULL,'London','England','UK','1750-1760','German-American Brigadier General John Peter Gabriel Muhlenberg (1746-1807) carried these English holster pistols during the Revolutionary War. Born in Trappe, Pennsylvania, and educated in Philadelphia and Europe as a Lutheran minister, Muhlenberg commanded the 8th Virginia Regiment, a corps composed largely of German-speaking recruits raised in the Shenandoah Valley in 1776.','https://thegove.github.io/documents/museum/images/F14Z2ZZ.jpg',(select owner_id from museum.owner where name='Landenberger Family Foundation'),(select policy_id from museum.policy where policy_number='7159Z 268243')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('94-6093641', to_date('2021-8-19','YYYY-MM-DD'), to_date('2025-3-19','YYYY-MM-DD'),'Peter Perit''s Powder Horn','Object','Powder Horn','Engraved by Jacob Gay','Temple Farm','Massachusetts','USA','December 20, 1775','Captain Peter Perit used this horn at the Siege of Boston in 1775. The decorations on it include the lion and unicorn from the British Royal Coat of Arms. The horn also bears the motto "Success to America" and a pine tree, a symbol of New England. In 1775, Americans fought for their liberty but still considered themselves loyal subjects of the British Crown.','https://thegove.github.io/documents/museum/images/02C23Z6.jpg',(select owner_id from museum.owner where name='American Revolution Institute'),(select policy_id from museum.policy where policy_number='25055586734')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2003.00.0123', to_date('2021-12-3','YYYY-MM-DD'), to_date('2025-5-3','YYYY-MM-DD'),'Philadelphia Powder Horn','Object','Powder Horn',NULL,'Philadelphia','Pennsylvania','USA','ca. 1770','The profuse decoration on this engraved powder horn includes a view of Philadelphia''s busy waterfront on the eve of the American Revolution. During the 1760s and early 1770s, urban populations in places like Boston, New York, and Philadelphia played an important role in protests against British taxation and coercive measures that eventually led to armed revolt.','https://thegove.github.io/documents/museum/images/0M844ZZ.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='38 EMC 372569')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('0962-4', to_date('2021-12-10','YYYY-MM-DD'), to_date('2025-5-10','YYYY-MM-DD'),'Phillis Wheatley''s Poetry','Object','Poems on Various Subjects, Religious and Moral','Written by Phillis Wheatley','London','England','UK','1773','Poems on Various Subjects, Religious and Moral, written by Phillis Wheatley, the first published African-American author, was lauded in both Europe and the American colonies as an example of the artistic and intellectual equality of people of African descent. Wheatley was born in Africa but was captured and brought to America as an enslaved child. This original copy of her work, published in 1773, is autographed by Wheatley.','https://thegove.github.io/documents/museum/images/027G04Z.jpg',(select owner_id from museum.owner where name='Dr. Marion T. Lane'),(select policy_id from museum.policy where policy_number='PIC4692496695')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('54-0066518', to_date('2021-10-17','YYYY-MM-DD'), to_date('2024-9-17','YYYY-MM-DD'),'Photograph of Mehitable Potter','Artwork','Mehitable Potter, 100 years old, April 28, 1863','Photographed by L. F. Hurd','South Adams','Massachusetts','USA','1863','Historians have identified over 150 photographs of people, including this image of Mehitable Potter, who were born before the end of the Revolutionary War in 1783. Potter was born in 1763, the same year that the French and Indian War ended, and passed away in 1864 while the American Civil War raged. This photograph of her, taken in the 100th year of her life, shows one of the last surviving members of the Revolutionary generation. Born in Rhode Island, Potter lived the latter years of her life in the town of Adams in western Massachusetts. When one of Potter''s neighbors, Joseph Hathaway, applied for a veteran''s pension from the Federal Government in 1845, Potter testified in court to help verify Hathaway''s service as a soldier during the Revolutionary War.','https://thegove.github.io/documents/museum/images/0LUQ0KZ.jpg',(select owner_id from museum.owner where name='American Revolution Institute'),(select policy_id from museum.policy where policy_number='25055586734')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('CS5 C592h', to_date('2020-3-27','YYYY-MM-DD'), to_date('2025-2-27','YYYY-MM-DD'),'Plan of the Battle of Brandywine','Object','Plan of the Battle of Brandywine',NULL,NULL,NULL,'USA','ca. 1777','This detailed plan shows British, Hessian, and American troop positions and movements during the Battle of Brandywine, September 11, 1777. The long battle ended with Washington''s army withdrawing east towards Chester, Pennsylvania. The exhausted British Army encamped at Dilworth (visible at the right-center of this plan) and neighboring areas until September 15, when they resumed pursuit of Washington''s forces before capturing Philadelphia on September 26. During the four-day encampment on the battlefield, British engineers surveyed the area and recorded details of the engagement in a series of plans, including this example.','https://thegove.github.io/documents/museum/images/0H9U70Z.jpg',(select owner_id from museum.owner where name='American Antiquarian Society'),(select policy_id from museum.policy where policy_number='5 9803855 71')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2015.05.0001', to_date('2020-10-27','YYYY-MM-DD'), to_date('2024-7-27','YYYY-MM-DD'),'Portrait of Captain William Crosbie','Artwork','Captain William Crosbie','Attributed to Robert Hunter','Dublin','Ireland','UK','ca. 1774','This is a rare portrait of a British officer who fought in the Battle of Lexington and Concord on April 19, 1775. Grenadier Captain William Crosbie of the 38th Regiment of Foot posed for this painting shortly before he sailed to America.','https://thegove.github.io/documents/museum/images/0VW843Z.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='30 EMC 876561')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('ar-9855', to_date('2020-6-22','YYYY-MM-DD'), to_date('2025-2-22','YYYY-MM-DD'),'Portrait of Captain William Leslie','Artwork','Captain William Leslie','Painted by David Martin',NULL,NULL,'UK','1773-1777','Captain William Leslie of the British 17th Regiment of Foot, shown in this portrait with Edinburgh Castle looming in the background, lost his life at the Battle of Princeton, New Jersey, on January 3, 1777. The son of a Scottish nobleman, Leslie purchased an officer''s commission in the 17th Regiment in 1773 and shipped off to America two years later. He fought during the New York campaign of 1776 and wrote home to his mother reflecting upon how the Revolutionary War seemed to be tearing America apart: "the Desolation that this unhappy Country has suffered must distress every feeling heart." At the Battle of Princeton, Leslie led the troops under his command against General George Washington''s attacking army. Leslie was shot twice in the fray and died soon after at the age of 26. After the Continental Army captured the wagon that carried his corpse, the American troops buried Leslie''s body in Pluckemin, New Jersey. Philadelphia''s Dr. Benjamin Rush, a staunch Revolutionary and Leslie''s long-time friend who had studied medicine in Scotland, mourned over the officer''s death and paid for a headstone to be placed on Leslie''s grave after the war.','https://thegove.github.io/documents/museum/images/0RSM05Z.jpg',(select owner_id from museum.owner where name='Massachusetts Historical Society'),(select policy_id from museum.policy where policy_number='H847510825')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('ar-6658', to_date('2019-2-23','YYYY-MM-DD'), to_date('2024-9-23','YYYY-MM-DD'),'Portrait of Jacob Latch','Artwork','Jacob Latch',NULL,NULL,'Pennsylvania','USA','ca. 1840','Revolutionary War veteran Jacob Latch, of Lower Merion, Pennsylvania, posed for this portrait in the early 1840s, around the time he applied for a pension from the Federal Government for his military service. Latch enlisted in the Continental Army in 1776 at age 17, along with his father and brother. He later served in Captain John Young''s Company of Colonel Jonathan Paschall''s Regiment of Chester County militia, during the Valley Forge encampment of 1777-1778. Latch passed away in 1845.','https://thegove.github.io/documents/museum/images/0RPK08Z.jpg',(select owner_id from museum.owner where name='Massachusetts Historical Society'),(select policy_id from museum.policy where policy_number='H847510825')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2017-93-K', to_date('2020-11-13','YYYY-MM-DD'), to_date('2025-5-13','YYYY-MM-DD'),'Portrait of Joachim du Perron, Comte de Revel','Artwork','Joachim du Perron, Comte de Revel','Painted by Laurent-Bruno Francois Jourdain','Besancon','France','EU','July 1786','Joachim du Perron, Comte de Revel shown in this 1786 portrait by Laurent-Bruno Francois Jourdain, was a French Army officer who served in seven naval battles during the Revolutionary War, as well as at the sieges of Yorktown (1781) and Gloucester (1782). Following the announcement of its alliance with the United States in 1778, France provided military support to the Americans throughout the later end of the Revolutionary War. The Franco-American victory at the Siege of Yorktown proved the enormous value of the French alliance.','https://thegove.github.io/documents/museum/images/09NC0ZZ.jpg',(select owner_id from museum.owner where name='Southern Revolutionary War Institute'),(select policy_id from museum.policy where policy_number='93 EMC 370338')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('309.1 DAY 2018', to_date('2021-7-15','YYYY-MM-DD'), to_date('2025-1-15','YYYY-MM-DD'),'Portrait of Lieutenant John Ross','Artwork','Lieutenant John Ross of the 34th Foot','Attributed to David Martin','Edinburgh','Scotland','UK','ca. 1769','Lieutenant John Ross of the 34th Regiment was a distinguished member of the British Army. After the final campaigns of the French and Indian War, he explored and mapped the Mississippi Valley before rotating back to Great Britain with his regiment in the late-1760s. Ross returned to America in 1776 and participated in a number of battles in the North. This circa 1769 portrait, attributed to Scottish-born artist David Martin, depicts Ross after his first American tour of duty.','https://thegove.github.io/documents/museum/images/04UH37Z.jpg',(select owner_id from museum.owner where name='George Washington''s Mount Vernon'),(select policy_id from museum.policy where policy_number='233998225 546 1')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('233.1 HOW 2016', to_date('2021-7-15','YYYY-MM-DD'), to_date('2025-1-15','YYYY-MM-DD'),'Portrait of Thomas McDonogh','Artwork','Thomas McDonogh',NULL,NULL,NULL,'USA','1794','Thomas McDonogh was an Irish immigrant who served as private secretary to John Wentworth, the last royal governor of New Hampshire. McDonogh fled the colony with Wentworth in 1775 and was a loyalist refugee in Nova Scotia. Following the 1783 Peace of Paris, McDonogh was appointed British consul in Boston, a post in which he served until his death in 1805. The Museum owns this 1794 portrait of McDonogh along with two of McDonogh''s diplomatic uniforms closely modeled on the pattern of a British general officer''s uniform.','https://thegove.github.io/documents/museum/images/0TP93KZ.jpg',(select owner_id from museum.owner where name='George Washington''s Mount Vernon'),(select policy_id from museum.policy where policy_number='233998225 546 1')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('A.991', to_date('2019-9-22','YYYY-MM-DD'), to_date('2024-7-22','YYYY-MM-DD'),'Print of General George Washington','Artwork','George Washington','Published by C. Shepherd','London','England','UK','1775','After George Washington took command of the Continental Army, the foreign and domestic market for prints of the newly minted general grew. In 1775, an English printer named "C. Shepherd" published a mezzotint of General Washington on horseback. While the image bears little resemblance to Washington, the print claimed it was "Done from an original drawing from the Life by Alexr. Campbell of Williamsburgh in Virginia." Martha Washington received one of these prints in January 1776. Her husband commented: "Mr. Campbell whom I never saw (to my knowledge) has made a very formidable figure of the Commander in Chief giving him a sufficient portion of Terror in his Countenance." This is one of the earliest prints of General George Washington.','https://thegove.github.io/documents/museum/images/0M9M30Z.jpg',(select owner_id from museum.owner where name='Landenberger Family Foundation'),(select policy_id from museum.policy where policy_number='5892I 812031')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('NHVqet', to_date('2021-8-16','YYYY-MM-DD'), to_date('2025-5-16','YYYY-MM-DD'),'Reverend George Whitefield''s Flagon','Object','Communion Flagon',NULL,NULL,'England','UK','ca. 1730','This communion flagon is engraved for Bristol Tabernacle, an English church established by the Reverend George Whitefield in the 1750s. Whitefield was one of the most influential religious figures in colonial British America. An English Anglican minister, Whitefield traveled widely through Britain and the colonies. He preached charismatic sermons before huge crowds and called for listeners to be "born again" in their Protestant faith. Whitefield was a key figure in the mid-1700s religious revival today called the first "Great Awakening."','https://thegove.github.io/documents/museum/images/0DRV4KZ.jpg',(select owner_id from museum.owner where name='Old Barracks Museum'),(select policy_id from museum.policy where policy_number='ART 918657511')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('742.122 MOD 2008', to_date('2021-7-15','YYYY-MM-DD'), to_date('2025-1-15','YYYY-MM-DD'),'Rifle Made by John Christian Oerter','Object','Rifle','Made by John Christian Oerter','Christian’s Spring','Pennsylvania','USA','1774','Moravian gunsmith John Christian Oerter (also known in German as Johann Christian Oerter) made this rifle at his workshop in Pennsylvania''s Lehigh Valley, about 60 miles north of Philadelphia. Settled by German-speaking immigrants in the 1740s, the Lehigh Valley became a rifle-making center long before the Revolutionary War. Oerter added brass inlay to the stock of this rifle to enhance its decoration. Oerter''s name, an abbreviation of Christian''s Spring, and the year he made the rifle is engraved on the top of the barrel: "C. OERTER. C. SP. 1774." Riflemen from Virginia, Maryland, and Pennsylvania joined the newly-formed Continental Army in 1775 armed with highly-accurate rifles like this one. John Adams described these men as "the most accurate Marksmen in the World."','https://thegove.github.io/documents/museum/images/03Q83ZZ.jpg',(select owner_id from museum.owner where name='George Washington''s Mount Vernon'),(select policy_id from museum.policy where policy_number='503477687 705 7')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2017.2.9', to_date('2019-1-3','YYYY-MM-DD'), to_date('2025-1-3','YYYY-MM-DD'),'Samuel Dudley''s Powder Horn','Object','Powder Horn','Engraved by Jacob Gay','Warwick','Rhode Island','USA','December 26, 1777','This charming powder horn was engraved for Samuel Dudley, a New England soldier serving in Warwick, Rhode Island, in December 1777. The engraved decoration — including a whimsical unicorn, a pair of moose, and two sword-wielding figures with the phrase "Try It Out" — is attributed to Jacob Gay, a prolific powder horn engraver whose surviving work spans 1758-1787. Gay may have been a soldier himself, carving horns to earn extra money or food while serving in the American Army.','https://thegove.github.io/documents/museum/images/08P07JZ.jpg',(select owner_id from museum.owner where name='McNeil Americana Collection'),(select policy_id from museum.policy where policy_number='4 4071961 28')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('179a/44', to_date('2020-12-7','YYYY-MM-DD'), to_date('2025-2-7','YYYY-MM-DD'),'Self-portrait of Richard St. George Mansergh St. George','Artwork','Self-portrait','Drawn by Richard St. George Mansergh',NULL,'England','UK','1780-1799','Richard St. George Mansergh St. George, an Irish veteran of the British Army, sketched this self-portrait as he struggled with the painful effects of a traumatic brain injury that he suffered during the Revolutionary War. St. George survived a fractured skull, likely caused by a musket ball, at the Battle of Germantown in 1777 and lived with a surgically placed silver plate in his head until his death 20 years later. Shown on the left wearing a black silk cap and robe, contemporary observers said that St. George wore this unusual clothing after the war to conceal the scars of his injury. The two demonic figures and the ruins of the building on the right of the self-portrait may reflect what St. George described as the "nightly hallucinations and dreadful visions" that he constantly experienced. St. George signed the back of the sketch, "Richard Mansergh St. George By Himself."','https://thegove.github.io/documents/museum/images/0XQD0ZZ.jpg',(select owner_id from museum.owner where name='David Center for the American Revolution'),(select policy_id from museum.policy where policy_number='PIC7731023400')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('B.124', to_date('2019-9-22','YYYY-MM-DD'), to_date('2024-7-22','YYYY-MM-DD'),'The Siege of Yorktown','Artwork','The Siege of Yorktown','Attributed to Henry LeGrand','Paris','France','EU','1850-1860','This dramatic scene commemorates the October 1781 Siege of Yorktown in Virginia. The original 1836 painting hangs in the Hall of Battles at the Palace of Versailles in France. This full-sized copy is believed to have been painted by French artist Henry LeGrand and exhibited at the Chicago Art Union in 1860. The central figure (gesturing) represents French General Rochambeau. General George Washington and General Lafayette (visible on Washington''s right) stand in front of a striped officer''s tent. They are surrounded by French officers and soldiers who fought alongside Washington''s army. The American Indian figures in the background may represent a delegation of Oneida and other Native Americans who witnessed the surrender of British General Cornwallis and his army. Yorktown was one of the last major military actions of the Revolutionary War.','https://thegove.github.io/documents/museum/images/00U10KZ.jpg',(select owner_id from museum.owner where name='Landenberger Family Foundation'),(select policy_id from museum.policy where policy_number='5892I 812031')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('794.12 NUN 2020', to_date('2020-4-24','YYYY-MM-DD'), to_date('2024-8-24','YYYY-MM-DD'),'Thomas Noyes''s Cocked Hat','Object','Cocked Hat',NULL,NULL,'Massachusetts','USA','1775-1800','Cocked hats (hats with the three sides of the brim turned up) like this one were popular in civilian and military life throughout the 1700s. They later came to be called "tricorns." Old stitching holes reveal that this hat was reshaped from a 1770s style into its current shape. The hat belonged to either Thomas Noyes III (born 1729) or his son, also named Thomas (born 1754), of Essex County, Massachusetts. Both father and son served in the Massachusetts militia during the Revolutionary War. A label inside the crown has the name Luther Noyes written on it and refers to a later owner who may have been a descendant of Thomas Noyes.','https://thegove.github.io/documents/museum/images/04BF3ZZ.jpg',(select owner_id from museum.owner where name='American Revolution Museum at Yorktown'),(select policy_id from museum.policy where policy_number='7FOVX66KN')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2017.29.02', to_date('2021-12-3','YYYY-MM-DD'), to_date('2025-5-3','YYYY-MM-DD'),'Thomas Noyes''s Musket','Object','Musket',NULL,NULL,'Massachusetts','USA','1760s','Many privately-owned American firearms from the 1700s were made from a variety of parts. This musket was probably assembled in Massachusetts using local wood for the stock and a French-made lock and barrel. The musket belonged to either Thomas Noyes III (born 1729) or his son, also named Thomas (born 1754), of Essex County, Massachusetts. The initials "TN" are carved on the lock-side of the firearm near the butt plate. Both father and son served in the Massachusetts militia during the Revolutionary War.','https://thegove.github.io/documents/museum/images/0J9M3ZZ.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='38 EMC 372569')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('75-206.168', to_date('2021-2-17','YYYY-MM-DD'), to_date('2025-2-17','YYYY-MM-DD'),'Thomas Noyes''s Pocketbook','Object','Pocketbook',NULL,NULL,'Massachusetts','USA','1776','Men carried decoratively stitched pocketbooks like this one to keep their money and personal papers organized. "Thomas noyes his book 1776" is stitched onto the pocket flap, indicating its owner and the year it was made for him. This book belonged to either Thomas Noyes III (born 1729) or his son, also named Thomas (born 1754), of Essex County, Massachusetts. Both father and son served in the Massachusetts militia during the Revolutionary War. As a member of the militia, one of the Noyes men may have also carried passes, oaths of allegiance, and mementos from home and loved ones in this pocketbook.','https://thegove.github.io/documents/museum/images/04UR07Z.jpg',(select owner_id from museum.owner where name='National Society Of The Sons Of The American Revolution'),(select policy_id from museum.policy where policy_number='46-BJV-8228')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('ob-905', to_date('2019-2-23','YYYY-MM-DD'), to_date('2024-9-23','YYYY-MM-DD'),'Triphena Punch Bowl','Object','Punch Bowl',NULL,'Liverpool','England','UK','1760-1770','This punch bowl wishes "Success to the Triphena," a merchant ship that made frequent trips between Philadelphia and Liverpool, England, in the 1760s. Americans celebrated the benefits of British trade by drinking and toasting with bowls like this. In 1765, the Triphena carried an appeal from Philadelphia merchants to merchants in Liverpool requesting their help in lobbying the British Parliament to repeal the Stamp Act. Archaeologists found this punch bowl in 2014 on the site of what is now the Museum of the American Revolution.','https://thegove.github.io/documents/museum/images/0QW33KZ.jpg',(select owner_id from museum.owner where name='Massachusetts Historical Society'),(select policy_id from museum.policy where policy_number='H847510825')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2003.00.0508', to_date('2020-1-25','YYYY-MM-DD'), to_date('2025-3-25','YYYY-MM-DD'),'Valley Forge Winter, The Return of the Foraging Party','Artwork','Valley Forge Winter, The Return of the Foraging Party','Painted by Harrington G. Fitzgerald','Philadelphia','Pennsylvania','USA','1880-1900','The 1777-1778 winter encampment at Valley Forge became synonymous with hunger, deprivation, and cold, all feelings expressed in this painting by American artist Harrington G. Fitzgerald (1847-1930). This bleak scene shows a foraging party of Continental Army soldiers returning to camp after searching the countryside for food and other necessities. Fitzgerald spent much of his life working for a family-owned newspaper, but he found relief from the stresses of his professional life in painting. He studied painting under several notable American artists, including Thomas Eakins and John Singer Sargent. Fitzgerald is best known for his works depicting the landscape of Valley Forge.','https://thegove.github.io/documents/museum/images/0TL77DZ.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='30 EMC 876561')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2003.00.0507', to_date('2020-1-25','YYYY-MM-DD'), to_date('2025-3-25','YYYY-MM-DD'),'Washington Crossing the Delaware','Artwork','Washington Crossing the Delaware','Painted by Harrington G. Fitzgerald','Philadelphia','Pennsylvania','USA','1870s-1890s','American artist Harrington G. Fitzgerald (1847-1930) painted this version of General George Washington''s famous 1776 crossing of the Delaware River about 100 years after the Revolutionary War. Instead of showing the actual crossing of the Delaware, Fitzgerald shows the Continental Army soldiers on the New Jersey side of the river as they regroup and prepare to march on Trenton. Fitzgerald spent much of his life working for a family-owned newspaper, but he found relief from the stresses of his professional life in painting. He studied painting under several notable American artists, including Thomas Eakins and John Singer Sargent. Fitzgerald is best known for his works depicting the landscape of Valley Forge.','https://thegove.github.io/documents/museum/images/0VU5XJZ.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='30 EMC 876561')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('5724/21', to_date('2020-12-7','YYYY-MM-DD'), to_date('2025-2-7','YYYY-MM-DD'),'Washington Mantel Clock','Object','Clock','Made by Jacques Nicolas Pierre Francois Dubuc','Paris','France','EU','1805-1815','French artisan Jacques Nicolas Pierre Francois Dubuc produced a small number of elegant mantel clocks for export to the American market following George Washington''s death in December 1799. Featuring a nobly posed Washington derived from John Trumbull''s 1792 painting George Washington Before the Battle of Trenton, this clock includes a tableau representing Washington resigning his commission to return to civilian life. This act recalled the virtuous example of Roman general Cincinnatus, affirming the principle of civilian control of the military. Words from Major General Richard Henry Lee''s famous eulogy of Washington appear below the dial: "first in war, first in peace, and first in the hearts of his countrymen."','https://thegove.github.io/documents/museum/images/0SU74KZ.jpg',(select owner_id from museum.owner where name='David Center for the American Revolution'),(select policy_id from museum.policy where policy_number='PIC1324292938')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('10023', to_date('2019-4-4','YYYY-MM-DD'), to_date('2025-1-4','YYYY-MM-DD'),'Washington''s Headquarters Flag','Object','Standard',NULL,NULL,NULL,'USA','1777-1783','Cousins Fannie B. Lovell and Ellen Lovell Crosby, descendants of Betty Washington Lewis (George Washington''s sister), donated this silk flag to Reverend W. Herbert Burk''s museum of American history at Valley Forge in 1910. Two of Lewis''s sons served as private secretaries for Washington, and a third served as an officer in Washington''s "Life Guard" during the Revolutionary War. According to family tradition, this flag marked the presence of General Washington throughout much of the war. Also known as a standard due to its modest size, it is believed to be the earliest surviving 13-star American flag. Reverend Burk''s Valley Forge Historical Society, the predecessor organization of the Museum of the American Revolution, served as the longtime steward of Washington''s standard.','https://thegove.github.io/documents/museum/images/2W0DX2Z.jpg',(select owner_id from museum.owner where name='Pennsylvania Society of Sons of the Revolution'),(select policy_id from museum.policy where policy_number='PIC4853888932')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('2003.00.0897', to_date('2020-1-25','YYYY-MM-DD'), to_date('2025-3-25','YYYY-MM-DD'),'Washington''s War Tent','Object','Tent',NULL,'Reading','Pennsylvania','USA','1777-1778','General George Washington''s original sleeping and office tent from the Revolutionary War was carefully preserved by generations of the Custis and Lee families following the deaths of George and Martha Washington. In 1909, Reverend W. Herbert Burk of Norristown, Pennsylvania, purchased the tent from Miss Mary Custis Lee, daughter of Confederate General Robert E. Lee. Reverend Burk considered the tent the "supreme relic of Washington" and he made it the centerpiece of an American history museum he established at Valley Forge. Reverend Burk''s Valley Forge Historical Society, the predecessor organization of the Museum of the American Revolution, served as the longtime steward of Washington''s tent.','https://thegove.github.io/documents/museum/images/0QRL4JZ.jpg',(select owner_id from museum.owner where name='Museum of the American Revolution'),(select policy_id from museum.policy where policy_number='38 EMC 372569')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('15-140.127', to_date('2021-2-17','YYYY-MM-DD'), to_date('2025-2-17','YYYY-MM-DD'),'William Waller''s Powder Horn','Object','Powder Horn',NULL,NULL,'Virginia','USA','1775-1776','Virginia rifleman William Waller carried this powder horn during the Revolutionary War. The horn is decorated with several popular slogans of the American Revolution, including "LIBERTY or DEATH" and "APPEAL TO HEAVEN." Waller was captured by British and Hessian forces after the fall of Fort Washington near New York City on November 16, 1776.','https://thegove.github.io/documents/museum/images/0TB43ZZ.jpg',(select owner_id from museum.owner where name='National Society Of The Sons Of The American Revolution'),(select policy_id from museum.policy where policy_number='28-CNP-9811')); insert into museum.item(item_number,borrowed_date, due_date, title, type, name, creator, city, state,state_assoication,date_made,description,image_url,owner_id, policy_id) values('133-125.65', to_date('2021-2-17','YYYY-MM-DD'), to_date('2025-2-17','YYYY-MM-DD'),'Wooden Canteen Marked "USTATES"','Object','Canteen',NULL,NULL,NULL,'USA','ca. 1777','This extremely rare wooden soldier''s canteen is marked "USTATES," indicating Continental Army usage. Alarmed by chronic shortfalls in arms and equipment caused in part by thefts and negligence, the Continental Congress directed in February 1777 that all the arms and accoutrements belonging to the country should be marked to show ownership by the United States.','https://thegove.github.io/documents/museum/images/7W03X8Z.jpg',(select owner_id from museum.owner where name='National Society Of The Sons Of The American Revolution'),(select policy_id from museum.policy where policy_number='28-CNP-9811')); insert into museum.medium(medium, modifier)values('Brass',NULL); insert into museum.medium(medium, modifier)values('Canvas',NULL); insert into museum.medium(medium, modifier)values('Carte-de-visite',NULL); insert into museum.medium(medium, modifier)values('Chalk',NULL); insert into museum.medium(medium, modifier)values('Charcoal',NULL); insert into museum.medium(medium, modifier)values('Copper',NULL); insert into museum.medium(medium, modifier)values('Cow Horn',NULL); insert into museum.medium(medium, modifier)values('Creamware',NULL); insert into museum.medium(medium, modifier)values('Enamel',NULL); insert into museum.medium(medium, modifier)values('Enamels',NULL); insert into museum.medium(medium, modifier)values('Felt',NULL); insert into museum.medium(medium, modifier)values('Gilt Brass',NULL); insert into museum.medium(medium, modifier)values('Glass',NULL); insert into museum.medium(medium, modifier)values('Gold',NULL); insert into museum.medium(medium, modifier)values('Gouache',NULL); insert into museum.medium(medium, modifier)values('Graphite',NULL); insert into museum.medium(medium, modifier)values('Hard-paste Porcelain',NULL); insert into museum.medium(medium, modifier)values('Hemp',NULL); insert into museum.medium(medium, modifier)values('Ink',NULL); insert into museum.medium(medium, modifier)values('Iron',NULL); insert into museum.medium(medium, modifier)values('Leather',NULL); insert into museum.medium(medium, modifier)values('Linen',NULL); insert into museum.medium(medium, modifier)values('Mezzotint',NULL); insert into museum.medium(medium, modifier)values('Oil Paint',NULL); insert into museum.medium(medium, modifier)values('Paint',NULL); insert into museum.medium(medium, modifier)values('Paktong',NULL); insert into museum.medium(medium, modifier)values('Paper',NULL); insert into museum.medium(medium, modifier)values('Pasteboard',NULL); insert into museum.medium(medium, modifier)values('Pewter',NULL); insert into museum.medium(medium, modifier)values('Silk',NULL); insert into museum.medium(medium, modifier)values('Silver',NULL); insert into museum.medium(medium, modifier)values('Steel',NULL); insert into museum.medium(medium, modifier)values('Terracotta',NULL); insert into museum.medium(medium, modifier)values('Tin',NULL); insert into museum.medium(medium, modifier)values('Tin-glazed earthenware',NULL); insert into museum.medium(medium, modifier)values('Watercolor',NULL); insert into museum.medium(medium, modifier)values('Wood',NULL); insert into museum.medium(medium, modifier)values('Wood','cedar'); insert into museum.medium(medium, modifier)values('Wood','maple'); insert into museum.medium(medium, modifier)values('Wood','oak'); insert into museum.medium(medium, modifier)values('Wood','pine'); insert into museum.medium(medium, modifier)values('Wood','walnut'); insert into museum.medium(medium, modifier)values('Wool',NULL); insert into museum.item_medium values((select item_id from museum.item where title='"Americans Will Always Fight for Liberty" Poster'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='"Americans Will Always Fight for Liberty" Poster'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='"Arms of Liberty" Punch Bowl'),(select medium_id from museum.medium where medium='Hard-paste Porcelain' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='"Arms of Liberty" Punch Bowl'),(select medium_id from museum.medium where medium='Enamels' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='"Success to Boston" Mug'),(select medium_id from museum.medium where medium='Creamware' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='A New Method of Macarony Making, as practiced at Boston'),(select medium_id from museum.medium where medium='Mezzotint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Abel Scott''s Powder Horn'),(select medium_id from museum.medium where medium='Cow Horn' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Abel Scott''s Powder Horn'),(select medium_id from museum.medium where medium='Wood' and modifier='pine')); insert into museum.item_medium values((select item_id from museum.item where title='Abel Scott''s Powder Horn'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Abel Scott''s Powder Horn'),(select medium_id from museum.medium where medium='Leather' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='American Military Drum'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='American Military Drum'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='American Military Drum'),(select medium_id from museum.medium where medium='Hemp' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='American Military Drum'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='American Military Drum'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Astronaut John Glenn''s Revolutionary War Flag'),(select medium_id from museum.medium where medium='Silk' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Astronaut John Glenn''s Revolutionary War Flag'),(select medium_id from museum.medium where medium='Linen' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Badge of the Blew and Orange'),(select medium_id from museum.medium where medium='Gold' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Baron von Steuben''s Regulations'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Baron von Steuben''s Regulations'),(select medium_id from museum.medium where medium='Leather' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Baron von Steuben''s Regulations'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Battle of Germantown'),(select medium_id from museum.medium where medium='Gouache' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Battle of Germantown'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Battle of Paoli'),(select medium_id from museum.medium where medium='Gouache' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Battle of Paoli'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Benjamin Lincoln''s Sword'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Benjamin Lincoln''s Sword'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Benjamin Lincoln''s Sword'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Benjamin Lincoln''s Sword'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British and French Swords'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British and French Swords'),(select medium_id from museum.medium where medium='Gold' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British and French Swords'),(select medium_id from museum.medium where medium='Silver' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British and French Swords'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British Gorget'),(select medium_id from museum.medium where medium='Silver' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British Musket'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British Musket'),(select medium_id from museum.medium where medium='Wood' and modifier='walnut')); insert into museum.item_medium values((select item_id from museum.item where title='British Musket'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British Musket'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British Officer''s Hanger'),(select medium_id from museum.medium where medium='Silver' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British Officer''s Hanger'),(select medium_id from museum.medium where medium='Leather' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British Officer''s Hanger'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British Officer''s Hanger'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British Officer''s Hanger'),(select medium_id from museum.medium where medium='Gold' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British Officer''s Saber'),(select medium_id from museum.medium where medium='Leather' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British Officer''s Saber'),(select medium_id from museum.medium where medium='Hemp' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='British Officer''s Saber'),(select medium_id from museum.medium where medium='Silver' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Bunker Hill Bible'),(select medium_id from museum.medium where medium='Leather' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Bunker Hill Bible'),(select medium_id from museum.medium where medium='Silver' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Bunker Hill Bible'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Bunker Hill Bible'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Bust of George Washington'),(select medium_id from museum.medium where medium='Terracotta' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Cash Pallentine''s Continental Army Discharge'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Cash Pallentine''s Continental Army Discharge'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Christopher Ludwick''s Cookie Board'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Common Sense and Plain Truth'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Common Sense and Plain Truth'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Continental Army Descriptive List'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Continental Army Descriptive List'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Continental Currency (3 Dollars)'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Continental Currency (3 Dollars)'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Creamware Punch Bowl'),(select medium_id from museum.medium where medium='Creamware' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Enlisting Foreign Officers'),(select medium_id from museum.medium where medium='Oil Paint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Enlisting Foreign Officers'),(select medium_id from museum.medium where medium='Canvas' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Ferguson Rifle'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Ferguson Rifle'),(select medium_id from museum.medium where medium='Paktong' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Ferguson Rifle'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Ferguson Rifle'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='First Newspaper Printing of the Declaration of Independence'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='First Newspaper Printing of the Declaration of Independence'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='French Gorget'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='French Gorget'),(select medium_id from museum.medium where medium='Silver' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='French Musket Marked "UNITED STATES"'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='French Musket Marked "UNITED STATES"'),(select medium_id from museum.medium where medium='Wood' and modifier='walnut')); insert into museum.item_medium values((select item_id from museum.item where title='French Musket Marked "UNITED STATES"'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='French Musket Marked "UNITED STATES"'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='French Naval Cutlass'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='French Naval Cutlass'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='French Naval Cutlass'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='George Mason''s Roman History'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='George Mason''s Roman History'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='George Mason''s Roman History'),(select medium_id from museum.medium where medium='Leather' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='George Washington''s Camp Cups'),(select medium_id from museum.medium where medium='Silver' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='George Wilson''s Sword'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='George Wilson''s Sword'),(select medium_id from museum.medium where medium='Leather' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='George Wilson''s Sword'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='George Wilson''s Sword'),(select medium_id from museum.medium where medium='Silver' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='George Wilson''s Sword'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Hessian Cap Plates'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Jacob Latch''s Coat'),(select medium_id from museum.medium where medium='Linen' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Jacob Latch''s Coat'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='James Grant''s Campaign Chest'),(select medium_id from museum.medium where medium='Wood' and modifier='pine')); insert into museum.item_medium values((select item_id from museum.item where title='James Grant''s Campaign Chest'),(select medium_id from museum.medium where medium='Paint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='James Grant''s Campaign Chest'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Jeremiah McGowan''s Continental Army Discharge'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Jeremiah McGowan''s Continental Army Discharge'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='John Chandler''s Sword'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='John Chandler''s Sword'),(select medium_id from museum.medium where medium='Wool' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='John Chandler''s Sword'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='John Chandler''s Sword'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='John Chandler''s Sword'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Jonathan Pettibone''s Sword'),(select medium_id from museum.medium where medium='Silver' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Jonathan Pettibone''s Sword'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Jonathan Pettibone''s Sword'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Jonathan Pettibone''s Sword'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Lafayette Parade Banner'),(select medium_id from museum.medium where medium='Silk' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Lafayette Parade Banner'),(select medium_id from museum.medium where medium='Paint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Linen Hunting Shirt'),(select medium_id from museum.medium where medium='Linen' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Linen Hunting Shirt'),(select medium_id from museum.medium where medium='Wool' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Map of the Siege of Yorktown'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Map of the Siege of Yorktown'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='March to Valley Forge'),(select medium_id from museum.medium where medium='Oil Paint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='March to Valley Forge'),(select medium_id from museum.medium where medium='Canvas' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Marquis de Lafayette''s Brazier'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Marquis de Lafayette''s Brazier'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Marquis de Lafayette''s Brazier'),(select medium_id from museum.medium where medium='Copper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Made at Rappahannock Forge'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Made at Rappahannock Forge'),(select medium_id from museum.medium where medium='Wood' and modifier='walnut')); insert into museum.item_medium values((select item_id from museum.item where title='Musket Made at Rappahannock Forge'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Made at Rappahannock Forge'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Made by Thomas Palmer'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Made by Thomas Palmer'),(select medium_id from museum.medium where medium='Wood' and modifier='walnut')); insert into museum.item_medium values((select item_id from museum.item where title='Musket Made by Thomas Palmer'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Made by Thomas Palmer'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Marked "NEW JERSEY"'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Marked "NEW JERSEY"'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Marked "NEW JERSEY"'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Marked "NEW JERSEY"'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Marked "U.STATES"'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Marked "U.STATES"'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Marked "U.STATES"'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Musket Marked "U.STATES"'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Owen Madden''s Tune Book'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Owen Madden''s Tune Book'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Panoramic View of Verplanck''s Point'),(select medium_id from museum.medium where medium='Watercolor' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Panoramic View of Verplanck''s Point'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Panoramic View of Verplanck''s Point'),(select medium_id from museum.medium where medium='Graphite' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Panoramic View of Verplanck''s Point'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Patrick Henry''s Law Books'),(select medium_id from museum.medium where medium='Leather' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Patrick Henry''s Law Books'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Patrick Henry''s Law Books'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Peter Muhlenberg''s Pistols'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Peter Muhlenberg''s Pistols'),(select medium_id from museum.medium where medium='Silver' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Peter Muhlenberg''s Pistols'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Peter Muhlenberg''s Pistols'),(select medium_id from museum.medium where medium='Wood' and modifier='walnut')); insert into museum.item_medium values((select item_id from museum.item where title='Peter Muhlenberg''s Pistols'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Peter Perit''s Powder Horn'),(select medium_id from museum.medium where medium='Cow Horn' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Peter Perit''s Powder Horn'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Peter Perit''s Powder Horn'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Peter Perit''s Powder Horn'),(select medium_id from museum.medium where medium='Wood' and modifier='pine')); insert into museum.item_medium values((select item_id from museum.item where title='Philadelphia Powder Horn'),(select medium_id from museum.medium where medium='Cow Horn' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Philadelphia Powder Horn'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Philadelphia Powder Horn'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Phillis Wheatley''s Poetry'),(select medium_id from museum.medium where medium='Leather' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Phillis Wheatley''s Poetry'),(select medium_id from museum.medium where medium='Linen' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Phillis Wheatley''s Poetry'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Photograph of Mehitable Potter'),(select medium_id from museum.medium where medium='Carte-de-visite' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Plan of the Battle of Brandywine'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Plan of the Battle of Brandywine'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Portrait of Captain William Crosbie'),(select medium_id from museum.medium where medium='Oil Paint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Portrait of Captain William Crosbie'),(select medium_id from museum.medium where medium='Canvas' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Portrait of Captain William Leslie'),(select medium_id from museum.medium where medium='Oil Paint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Portrait of Captain William Leslie'),(select medium_id from museum.medium where medium='Canvas' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Portrait of Jacob Latch'),(select medium_id from museum.medium where medium='Charcoal' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Portrait of Jacob Latch'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Portrait of Jacob Latch'),(select medium_id from museum.medium where medium='Chalk' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Portrait of Joachim du Perron, Comte de Revel'),(select medium_id from museum.medium where medium='Oil Paint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Portrait of Joachim du Perron, Comte de Revel'),(select medium_id from museum.medium where medium='Canvas' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Portrait of Lieutenant John Ross'),(select medium_id from museum.medium where medium='Oil Paint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Portrait of Lieutenant John Ross'),(select medium_id from museum.medium where medium='Canvas' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Portrait of Thomas McDonogh'),(select medium_id from museum.medium where medium='Oil Paint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Portrait of Thomas McDonogh'),(select medium_id from museum.medium where medium='Tin' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Print of General George Washington'),(select medium_id from museum.medium where medium='Mezzotint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Reverend George Whitefield''s Flagon'),(select medium_id from museum.medium where medium='Pewter' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Reverend George Whitefield''s Flagon'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Rifle Made by John Christian Oerter'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Rifle Made by John Christian Oerter'),(select medium_id from museum.medium where medium='Wood' and modifier='maple')); insert into museum.item_medium values((select item_id from museum.item where title='Rifle Made by John Christian Oerter'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Rifle Made by John Christian Oerter'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Samuel Dudley''s Powder Horn'),(select medium_id from museum.medium where medium='Cow Horn' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Samuel Dudley''s Powder Horn'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Self-portrait of Richard St. George Mansergh St. George'),(select medium_id from museum.medium where medium='Watercolor' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Self-portrait of Richard St. George Mansergh St. George'),(select medium_id from museum.medium where medium='Paper' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Self-portrait of Richard St. George Mansergh St. George'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='The Siege of Yorktown'),(select medium_id from museum.medium where medium='Oil Paint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='The Siege of Yorktown'),(select medium_id from museum.medium where medium='Canvas' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Thomas Noyes''s Cocked Hat'),(select medium_id from museum.medium where medium='Felt' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Thomas Noyes''s Cocked Hat'),(select medium_id from museum.medium where medium='Pewter' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Thomas Noyes''s Cocked Hat'),(select medium_id from museum.medium where medium='Linen' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Thomas Noyes''s Musket'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Thomas Noyes''s Musket'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Thomas Noyes''s Musket'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Thomas Noyes''s Musket'),(select medium_id from museum.medium where medium='Steel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Thomas Noyes''s Pocketbook'),(select medium_id from museum.medium where medium='Wool' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Thomas Noyes''s Pocketbook'),(select medium_id from museum.medium where medium='Pasteboard' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Thomas Noyes''s Pocketbook'),(select medium_id from museum.medium where medium='Silk' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Thomas Noyes''s Pocketbook'),(select medium_id from museum.medium where medium='Linen' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Triphena Punch Bowl'),(select medium_id from museum.medium where medium='Tin-glazed earthenware' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Valley Forge Winter, The Return of the Foraging Party'),(select medium_id from museum.medium where medium='Oil Paint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Valley Forge Winter, The Return of the Foraging Party'),(select medium_id from museum.medium where medium='Canvas' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Washington Crossing the Delaware'),(select medium_id from museum.medium where medium='Oil Paint' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Washington Crossing the Delaware'),(select medium_id from museum.medium where medium='Canvas' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Washington Mantel Clock'),(select medium_id from museum.medium where medium='Gilt Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Washington Mantel Clock'),(select medium_id from museum.medium where medium='Glass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Washington Mantel Clock'),(select medium_id from museum.medium where medium='Enamel' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Washington Mantel Clock'),(select medium_id from museum.medium where medium='Iron' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Washington''s Headquarters Flag'),(select medium_id from museum.medium where medium='Silk' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Washington''s Headquarters Flag'),(select medium_id from museum.medium where medium='Linen' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Washington''s War Tent'),(select medium_id from museum.medium where medium='Linen' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Washington''s War Tent'),(select medium_id from museum.medium where medium='Wool' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='William Waller''s Powder Horn'),(select medium_id from museum.medium where medium='Cow Horn' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='William Waller''s Powder Horn'),(select medium_id from museum.medium where medium='Ink' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='William Waller''s Powder Horn'),(select medium_id from museum.medium where medium='Brass' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='William Waller''s Powder Horn'),(select medium_id from museum.medium where medium='Wood' and modifier is NULL)); insert into museum.item_medium values((select item_id from museum.item where title='Wooden Canteen Marked "USTATES"'),(select medium_id from museum.medium where medium='Wood' and modifier='cedar')); insert into museum.item_medium values((select item_id from museum.item where title='Wooden Canteen Marked "USTATES"'),(select medium_id from museum.medium where medium='Wood' and modifier='oak'));