insert into breed (breed_code, breed_name) values ('DIBK', 'Diamondback');
insert into breed (breed_code, breed_name) values ('AST', 'African Sideneck Turtle');
insert into breed (breed_code, breed_name) values ('EBT', 'Eastern Box Turtle');

insert into location (location_code, location_name, location_latitude, location_longitude) values ('BHAR', 'Baltimore Harbor', 39.2858, 76.6131);
insert into location (location_code, location_name, location_latitude, location_longitude) values ('WAIS', 'Wallops Island', 87, 912);
insert into location (location_code, location_name, location_latitude, location_longitude) values ('DCL', 'Deep Creek Lake', 123, 456);

insert into specimen (specimen_weight, specimen_length, specimen_health, breed_code, location_code) values (12, 5, 'H1', 'AST', 'BHAR');
insert into specimen (specimen_weight, specimen_length, specimen_health, breed_code, location_code) values (10, 6, 'H2', 'EBT', 'BHAR');
insert into specimen (specimen_weight, specimen_length, specimen_health, breed_code, location_code) values (15, 8, 'H1', 'EBT', 'BHAR');
insert into specimen (specimen_weight, specimen_length, specimen_health, breed_code, location_code) values (6, 3, 'H1', 'DIBK', 'DCL');
insert into specimen (specimen_weight, specimen_length, specimen_health, breed_code, location_code) values (10, 6, 'H2', 'EBT', 'WAIS');