periodic.sql

-- from https://en.wikipedia.org/wiki/List_of_elements
-- sqlite3 periodic.db <periodic.sql

drop table if exists element;
create table element (
    number int primary key,
    symbol text not null,
    name text not null,
    period int not null,
    weight number not null);

drop table if exists property;
create table property (
    property_id int primary key,
    description text not null);

drop table if exists element_property;
create table element_property (
    number references element,
    property_id references property);

drop table if exists element_density;
create table element_density (
    number references element,
    density number not null);

drop table if exists melting;
create table melting (
    number references element,
    melting_point number not null);    -- Kelvins

drop table if exists boiling;
create table boiling (
    number references element,
    boiling_point number not null);    -- Kelvins

drop table if exists element_group;
create table element_group (
    group_id int not null,
    number references element);

-- note: not all elements have a group
drop view if exists by_group;
create view by_group as 
  select g.group_id,g.number,e.symbol,e.name 
  from element e, element_group g 
  where e.number = g.number
  order by g.group_id;

drop view if exists by_property;
create view by_property as 
  select p.description,e.number,e.symbol,e.name 
  from element e, element_property ep, property p
  where e.number = ep.number
  and ep.property_id = p.property_id
  order by p.description;

drop view if exists joined;
create view joined as 
  select e.number,e.symbol,e.name,e.period,g.group_id,bp.description,
    e.weight,d.density,melting_point,boiling_point
  from element e 
  left join element_density d on e.number = d.number
  left join melting m on e.number = m.number
  left join boiling b on e.number = b.number
  left join element_group g on e.number = g.number
  left join by_property bp on e.number = bp.number;


insert into property values (1,'actinide');
insert into property values (2,'alkali metal');
insert into property values (3,'alkaline earth metal');
insert into property values (4,'diatomic nonmetal');
insert into property values (5,'lanthanide');
insert into property values (6,'metalloid');
insert into property values (7,'noble gas');
insert into property values (8,'polyatomic nonmetal');
insert into property values (9,'post-transition metal');
insert into property values (10,'transition metal');
insert into property values (11,'unknown');

insert into element values (1,'H','Hydrogen',1,1.008);
insert into element values (2,'He','Helium',1,4.002602);
insert into element values (3,'Li','Lithium',2,6.94);
insert into element values (4,'Be','Beryllium',2,9.0121831);
insert into element values (5,'B','Boron',2,10.81);
insert into element values (6,'C','Carbon',2,12.011);
insert into element values (7,'N','Nitrogen',2,14.007);
insert into element values (8,'O','Oxygen',2,15.999);
insert into element values (9,'F','Fluorine',2,18.998403163);
insert into element values (10,'Ne','Neon',2,20.1797);
insert into element values (11,'Na','Sodium',3,22.98976928);
insert into element values (12,'Mg','Magnesium',3,24.305);
insert into element values (13,'Al','Aluminium',3,26.9815385);
insert into element values (14,'Si','Silicon',3,28.085);
insert into element values (15,'P','Phosphorus',3,30.973761998);
insert into element values (16,'S','Sulfur',3,32.06);
insert into element values (17,'Cl','Chlorine',3,35.45);
insert into element values (18,'Ar','Argon',3,39.948);
insert into element values (19,'K','Potassium',4,39.0983);
insert into element values (20,'Ca','Calcium',4,40.078);
insert into element values (21,'Sc','Scandium',4,44.955908);
insert into element values (22,'Ti','Titanium',4,47.867);
insert into element values (23,'V','Vanadium',4,50.9415);
insert into element values (24,'Cr','Chromium',4,51.9961);
insert into element values (25,'Mn','Manganese',4,54.938044);
insert into element values (26,'Fe','Iron',4,55.845);
insert into element values (27,'Co','Cobalt',4,58.933194);
insert into element values (28,'Ni','Nickel',4,58.6934);
insert into element values (29,'Cu','Copper',4,63.546);
insert into element values (30,'Zn','Zinc',4,65.38);
insert into element values (31,'Ga','Gallium',4,69.723);
insert into element values (32,'Ge','Germanium',4,72.630);
insert into element values (33,'As','Arsenic',4,74.921595);
insert into element values (34,'Se','Selenium',4,78.971);
insert into element values (35,'Br','Bromine',4,79.904);
insert into element values (36,'Kr','Krypton',4,83.798);
insert into element values (37,'Rb','Rubidium',5,85.4678);
insert into element values (38,'Sr','Strontium',5,87.62);
insert into element values (39,'Y','Yttrium',5,88.90584);
insert into element values (40,'Zr','Zirconium',5,91.224);
insert into element values (41,'Nb','Niobium',5,92.90637);
insert into element values (42,'Mo','Molybdenum',5,95.95);
insert into element values (43,'Tc','Technetium',5,98);
insert into element values (44,'Ru','Ruthenium',5,101.07);
insert into element values (45,'Rh','Rhodium',5,102.90550);
insert into element values (46,'Pd','Palladium',5,106.42);
insert into element values (47,'Ag','Silver',5,107.8682);
insert into element values (48,'Cd','Cadmium',5,112.414);
insert into element values (49,'In','Indium',5,114.818);
insert into element values (50,'Sn','Tin',5,118.710);
insert into element values (51,'Sb','Antimony',5,121.760);
insert into element values (52,'Te','Tellurium',5,127.60);
insert into element values (53,'I','Iodine',5,126.90447);
insert into element values (54,'Xe','Xenon',5,131.293);
insert into element values (55,'Cs','Caesium',6,132.90545196);
insert into element values (56,'Ba','Barium',6,137.327);
insert into element values (57,'La','Lanthanum',6,138.90547);
insert into element values (58,'Ce','Cerium',6,140.116);
insert into element values (59,'Pr','Praseodymium',6,140.90766);
insert into element values (60,'Nd','Neodymium',6,144.242);
insert into element values (61,'Pm','Promethium',6,145);
insert into element values (62,'Sm','Samarium',6,150.36);
insert into element values (63,'Eu','Europium',6,151.964);
insert into element values (64,'Gd','Gadolinium',6,157.25);
insert into element values (65,'Tb','Terbium',6,158.92535);
insert into element values (66,'Dy','Dysprosium',6,162.500);
insert into element values (67,'Ho','Holmium',6,164.93033);
insert into element values (68,'Er','Erbium',6,167.259);
insert into element values (69,'Tm','Thulium',6,168.93422);
insert into element values (70,'Yb','Ytterbium',6,173.045);
insert into element values (71,'Lu','Lutetium',6,174.9668);
insert into element values (72,'Hf','Hafnium',6,178.49);
insert into element values (73,'Ta','Tantalum',6,180.94788);
insert into element values (74,'W','Tungsten',6,183.84);
insert into element values (75,'Re','Rhenium',6,186.207);
insert into element values (76,'Os','Osmium',6,190.23);
insert into element values (77,'Ir','Iridium',6,192.217);
insert into element values (78,'Pt','Platinum',6,195.084);
insert into element values (79,'Au','Gold',6,196.966569);
insert into element values (80,'Hg','Mercury',6,200.592);
insert into element values (81,'Tl','Thallium',6,204.38);
insert into element values (82,'Pb','Lead',6,207.2);
insert into element values (83,'Bi','Bismuth',6,208.98040);
insert into element values (84,'Po','Polonium',6,209);
insert into element values (85,'At','Astatine',6,210);
insert into element values (86,'Rn','Radon',6,222);
insert into element values (87,'Fr','Francium',7,223);
insert into element values (88,'Ra','Radium',7,226);
insert into element values (89,'Ac','Actinium',7,227);
insert into element values (90,'Th','Thorium',7,232.0377);
insert into element values (91,'Pa','Protactinium',7,231.03588);
insert into element values (92,'U','Uranium',7,238.02891);
insert into element values (93,'Np','Neptunium',7,237);
insert into element values (94,'Pu','Plutonium',7,244);
insert into element values (95,'Am','Americium',7,243);
insert into element values (96,'Cm','Curium',7,247);
insert into element values (97,'Bk','Berkelium',7,247);
insert into element values (98,'Cf','Californium',7,251);
insert into element values (99,'Es','Einsteinium',7,252);
insert into element values (100,'Fm','Fermium',7,257);
insert into element values (101,'Md','Mendelevium',7,258);
insert into element values (102,'No','Nobelium',7,259);
insert into element values (103,'Lr','Lawrencium',7,266);
insert into element values (104,'Rf','Rutherfordium',7,267);
insert into element values (105,'Db','Dubnium',7,268);
insert into element values (106,'Sg','Seaborgium',7,269);
insert into element values (107,'Bh','Bohrium',7,270);
insert into element values (108,'Hs','Hassium',7,269);
insert into element values (109,'Mt','Meitnerium',7,278);
insert into element values (110,'Ds','Darmstadtium',7,281);
insert into element values (111,'Rg','Roentgenium',7,281);
insert into element values (112,'Cn','Copernicium',7,285);
insert into element values (113,'Uut','Ununtrium',7,286);
insert into element values (114,'Fl','Flerovium',7,289);
insert into element values (115,'Uup','Ununpentium',7,289);
insert into element values (116,'Lv','Livermorium',7,293);
insert into element values (117,'Uus','Ununseptium',7,294);
insert into element values (118,'Uuo','Ununoctium',7,294);

insert into element_property values (1,8);
insert into element_property values (2,7);
insert into element_property values (3,2);
insert into element_property values (4,3);
insert into element_property values (5,6);
insert into element_property values (6,8);
insert into element_property values (7,4);
insert into element_property values (8,4);
insert into element_property values (9,4);
insert into element_property values (10,7);
insert into element_property values (11,2);
insert into element_property values (12,3);
insert into element_property values (13,9);
insert into element_property values (14,6);
insert into element_property values (15,8);
insert into element_property values (16,8);
insert into element_property values (17,4);
insert into element_property values (18,7);
insert into element_property values (19,2);
insert into element_property values (20,3);
insert into element_property values (21,10);
insert into element_property values (22,10);
insert into element_property values (23,10);
insert into element_property values (24,10);
insert into element_property values (25,10);
insert into element_property values (26,10);
insert into element_property values (27,10);
insert into element_property values (28,10);
insert into element_property values (29,10);
insert into element_property values (30,10);
insert into element_property values (31,9);
insert into element_property values (32,6);
insert into element_property values (33,6);
insert into element_property values (34,8);
insert into element_property values (35,4);
insert into element_property values (36,7);
insert into element_property values (37,2);
insert into element_property values (38,3);
insert into element_property values (39,10);
insert into element_property values (40,10);
insert into element_property values (41,10);
insert into element_property values (42,10);
insert into element_property values (43,10);
insert into element_property values (44,10);
insert into element_property values (45,10);
insert into element_property values (46,10);
insert into element_property values (47,10);
insert into element_property values (48,10);
insert into element_property values (49,9);
insert into element_property values (50,9);
insert into element_property values (51,6);
insert into element_property values (52,6);
insert into element_property values (53,4);
insert into element_property values (54,7);
insert into element_property values (55,2);
insert into element_property values (56,3);
insert into element_property values (57,5);
insert into element_property values (58,5);
insert into element_property values (59,5);
insert into element_property values (60,5);
insert into element_property values (61,5);
insert into element_property values (62,5);
insert into element_property values (63,5);
insert into element_property values (64,5);
insert into element_property values (65,5);
insert into element_property values (66,5);
insert into element_property values (67,5);
insert into element_property values (68,5);
insert into element_property values (69,5);
insert into element_property values (70,5);
insert into element_property values (71,5);
insert into element_property values (72,10);
insert into element_property values (73,10);
insert into element_property values (74,10);
insert into element_property values (75,10);
insert into element_property values (76,10);
insert into element_property values (77,10);
insert into element_property values (78,10);
insert into element_property values (79,10);
insert into element_property values (80,10);
insert into element_property values (81,9);
insert into element_property values (82,9);
insert into element_property values (83,9);
insert into element_property values (84,9);
insert into element_property values (85,6);
insert into element_property values (86,7);
insert into element_property values (87,2);
insert into element_property values (88,3);
insert into element_property values (89,1);
insert into element_property values (90,1);
insert into element_property values (91,1);
insert into element_property values (92,1);
insert into element_property values (93,1);
insert into element_property values (94,1);
insert into element_property values (95,1);
insert into element_property values (96,1);
insert into element_property values (97,1);
insert into element_property values (98,1);
insert into element_property values (99,1);
insert into element_property values (100,1);
insert into element_property values (101,1);
insert into element_property values (102,1);
insert into element_property values (103,1);
insert into element_property values (104,10);
insert into element_property values (105,10);
insert into element_property values (106,10);
insert into element_property values (107,10);
insert into element_property values (108,10);
insert into element_property values (112,10);

insert into element_group values (1,1);
insert into element_group values (18,2);
insert into element_group values (1,3);
insert into element_group values (2,4);
insert into element_group values (13,5);
insert into element_group values (14,6);
insert into element_group values (15,7);
insert into element_group values (16,8);
insert into element_group values (17,9);
insert into element_group values (18,10);
insert into element_group values (1,11);
insert into element_group values (2,12);
insert into element_group values (13,13);
insert into element_group values (14,14);
insert into element_group values (15,15);
insert into element_group values (16,16);
insert into element_group values (17,17);
insert into element_group values (18,18);
insert into element_group values (1,19);
insert into element_group values (2,20);
insert into element_group values (3,21);
insert into element_group values (4,22);
insert into element_group values (5,23);
insert into element_group values (6,24);
insert into element_group values (7,25);
insert into element_group values (8,26);
insert into element_group values (9,27);
insert into element_group values (10,28);
insert into element_group values (11,29);
insert into element_group values (12,30);
insert into element_group values (13,31);
insert into element_group values (14,32);
insert into element_group values (15,33);
insert into element_group values (16,34);
insert into element_group values (17,35);
insert into element_group values (18,36);
insert into element_group values (1,37);
insert into element_group values (2,38);
insert into element_group values (3,39);
insert into element_group values (4,40);
insert into element_group values (5,41);
insert into element_group values (6,42);
insert into element_group values (7,43);
insert into element_group values (8,44);
insert into element_group values (9,45);
insert into element_group values (10,46);
insert into element_group values (11,47);
insert into element_group values (12,48);
insert into element_group values (13,49);
insert into element_group values (14,50);
insert into element_group values (15,51);
insert into element_group values (16,52);
insert into element_group values (17,53);
insert into element_group values (18,54);
insert into element_group values (1,55);
insert into element_group values (2,56);
insert into element_group values (3,71);
insert into element_group values (4,72);
insert into element_group values (5,73);
insert into element_group values (6,74);
insert into element_group values (7,75);
insert into element_group values (8,76);
insert into element_group values (9,77);
insert into element_group values (10,78);
insert into element_group values (11,79);
insert into element_group values (12,80);
insert into element_group values (13,81);
insert into element_group values (14,82);
insert into element_group values (15,83);
insert into element_group values (16,84);
insert into element_group values (17,85);
insert into element_group values (18,86);
insert into element_group values (1,87);
insert into element_group values (2,88);
insert into element_group values (3,103);
insert into element_group values (4,104);
insert into element_group values (5,105);
insert into element_group values (6,106);
insert into element_group values (7,107);
insert into element_group values (8,108);
insert into element_group values (9,109);
insert into element_group values (10,110);
insert into element_group values (11,111);
insert into element_group values (12,112);
insert into element_group values (13,113);
insert into element_group values (14,114);
insert into element_group values (15,115);
insert into element_group values (16,116);
insert into element_group values (17,117);
insert into element_group values (18,118);

insert into element_density values (1,0.00008988);
insert into element_density values (2,0.0001785);
insert into element_density values (3,0.534);
insert into element_density values (4,1.85);
insert into element_density values (5,2.34);
insert into element_density values (6,2.267);
insert into element_density values (7,0.0012506);
insert into element_density values (8,0.001429);
insert into element_density values (9,0.001696);
insert into element_density values (10,0.0008999);
insert into element_density values (11,0.971);
insert into element_density values (12,1.738);
insert into element_density values (13,2.698);
insert into element_density values (14,2.3296);
insert into element_density values (15,1.82);
insert into element_density values (16,2.067);
insert into element_density values (17,0.003214);
insert into element_density values (18,0.0017837);
insert into element_density values (19,0.862);
insert into element_density values (20,1.54);
insert into element_density values (21,2.989);
insert into element_density values (22,4.54);
insert into element_density values (23,6.11);
insert into element_density values (24,7.15);
insert into element_density values (25,7.44);
insert into element_density values (26,7.874);
insert into element_density values (27,8.86);
insert into element_density values (28,8.912);
insert into element_density values (29,8.96);
insert into element_density values (30,7.134);
insert into element_density values (31,5.907);
insert into element_density values (32,5.323);
insert into element_density values (33,5.776);
insert into element_density values (34,4.809);
insert into element_density values (35,3.122);
insert into element_density values (36,0.003733);
insert into element_density values (37,1.532);
insert into element_density values (38,2.64);
insert into element_density values (39,4.469);
insert into element_density values (40,6.506);
insert into element_density values (41,8.57);
insert into element_density values (42,10.22);
insert into element_density values (43,11.5);
insert into element_density values (44,12.37);
insert into element_density values (45,12.41);
insert into element_density values (46,12.02);
insert into element_density values (47,10.501);
insert into element_density values (48,8.69);
insert into element_density values (49,7.31);
insert into element_density values (50,7.287);
insert into element_density values (51,6.685);
insert into element_density values (52,6.232);
insert into element_density values (53,4.93);
insert into element_density values (54,0.005887);
insert into element_density values (55,1.873);
insert into element_density values (56,3.594);
insert into element_density values (57,6.145);
insert into element_density values (58,6.77);
insert into element_density values (59,6.773);
insert into element_density values (60,7.007);
insert into element_density values (61,7.26);
insert into element_density values (62,7.52);
insert into element_density values (63,5.243);
insert into element_density values (64,7.895);
insert into element_density values (65,8.229);
insert into element_density values (66,8.55);
insert into element_density values (67,8.795);
insert into element_density values (68,9.066);
insert into element_density values (69,9.321);
insert into element_density values (70,6.965);
insert into element_density values (71,9.84);
insert into element_density values (72,13.31);
insert into element_density values (73,16.654);
insert into element_density values (74,19.25);
insert into element_density values (75,21.02);
insert into element_density values (76,22.61);
insert into element_density values (77,22.56);
insert into element_density values (78,21.46);
insert into element_density values (79,19.282);
insert into element_density values (80,13.5336);
insert into element_density values (81,11.85);
insert into element_density values (82,11.342);
insert into element_density values (83,9.807);
insert into element_density values (84,9.32);
insert into element_density values (85,7);
insert into element_density values (86,0.00973);
insert into element_density values (87,1.87);
insert into element_density values (88,5.5);
insert into element_density values (89,10.07);
insert into element_density values (90,11.72);
insert into element_density values (91,15.37);
insert into element_density values (92,18.95);
insert into element_density values (93,20.45);
insert into element_density values (94,19.84);
insert into element_density values (95,13.69);
insert into element_density values (96,13.51);
insert into element_density values (97,14.79);
insert into element_density values (98,15.1);
insert into element_density values (99,8.84);
insert into element_density values (104,23.2);
insert into element_density values (105,29.3);
insert into element_density values (106,35.0);
insert into element_density values (107,37.1);
insert into element_density values (108,40.7);
insert into element_density values (109,37.4);
insert into element_density values (110,34.8);
insert into element_density values (111,28.7);
insert into element_density values (112,23.7);
insert into element_density values (113,16);
insert into element_density values (114,14);
insert into element_density values (115,13.5);
insert into element_density values (116,12.9);
insert into element_density values (117,7.2);
insert into element_density values (118,5.0);

insert into melting values (1,14.01);
insert into melting values (2,0.95);
insert into melting values (3,453.69);
insert into melting values (4,1560);
insert into melting values (5,2349);
insert into melting values (6,3800);
insert into melting values (7,63.15);
insert into melting values (8,54.36);
insert into melting values (9,53.53);
insert into melting values (10,24.56);
insert into melting values (11,370.87);
insert into melting values (12,923);
insert into melting values (13,933.47);
insert into melting values (14,1687);
insert into melting values (15,317.30);
insert into melting values (16,388.36);
insert into melting values (17,171.6);
insert into melting values (18,83.80);
insert into melting values (19,336.53);
insert into melting values (20,1115);
insert into melting values (21,1814);
insert into melting values (22,1941);
insert into melting values (23,2183);
insert into melting values (24,2180);
insert into melting values (25,1519);
insert into melting values (26,1811);
insert into melting values (27,1768);
insert into melting values (28,1728);
insert into melting values (29,1357.77);
insert into melting values (30,692.88);
insert into melting values (31,302.9146);
insert into melting values (32,1211.40);
insert into melting values (33,1090);
insert into melting values (34,453);
insert into melting values (35,265.8);
insert into melting values (36,115.79);
insert into melting values (37,312.46);
insert into melting values (38,1050);
insert into melting values (39,1799);
insert into melting values (40,2128);
insert into melting values (41,2750);
insert into melting values (42,2896);
insert into melting values (43,2430);
insert into melting values (44,2607);
insert into melting values (45,2237);
insert into melting values (46,1828.05);
insert into melting values (47,1234.93);
insert into melting values (48,594.22);
insert into melting values (49,429.75);
insert into melting values (50,505.08);
insert into melting values (51,903.78);
insert into melting values (52,722.66);
insert into melting values (53,386.85);
insert into melting values (54,161.4);
insert into melting values (55,301.59);
insert into melting values (56,1000);
insert into melting values (57,1193);
insert into melting values (58,1068);
insert into melting values (59,1208);
insert into melting values (60,1297);
insert into melting values (61,1315);
insert into melting values (62,1345);
insert into melting values (63,1099);
insert into melting values (64,1585);
insert into melting values (65,1629);
insert into melting values (66,1680);
insert into melting values (67,1734);
insert into melting values (68,1802);
insert into melting values (69,1818);
insert into melting values (70,1097);
insert into melting values (71,1925);
insert into melting values (72,2506);
insert into melting values (73,3290);
insert into melting values (74,3695);
insert into melting values (75,3459);
insert into melting values (76,3306);
insert into melting values (77,2719);
insert into melting values (78,2041.4);
insert into melting values (79,1337.33);
insert into melting values (80,234.43);
insert into melting values (81,577);
insert into melting values (82,600.61);
insert into melting values (83,544.7);
insert into melting values (84,527);
insert into melting values (85,575);
insert into melting values (86,202);
insert into melting values (87,300);
insert into melting values (88,973);
insert into melting values (89,1323);
insert into melting values (90,2115);
insert into melting values (91,1841);
insert into melting values (92,1405.3);
insert into melting values (93,917);
insert into melting values (94,912.5);
insert into melting values (95,1449);
insert into melting values (96,1613);
insert into melting values (97,1259);
insert into melting values (98,1173);
insert into melting values (99,1133);
insert into melting values (100,1125);
insert into melting values (101,1100);
insert into melting values (102,1100);
insert into melting values (103,1900);
insert into melting values (104,2400);
insert into melting values (113,700);
insert into melting values (114,340);
insert into melting values (115,700);
insert into melting values (116,708.5);
insert into melting values (117,673);
insert into melting values (118,258);

insert into boiling values (1,20.28);
insert into boiling values (2,4.22);
insert into boiling values (3,1560);
insert into boiling values (4,2742);
insert into boiling values (5,4200);
insert into boiling values (6,4300);
insert into boiling values (7,77.36);
insert into boiling values (8,90.20);
insert into boiling values (9,85.03);
insert into boiling values (10,27.07);
insert into boiling values (11,1156);
insert into boiling values (12,1363);
insert into boiling values (13,2792);
insert into boiling values (14,3538);
insert into boiling values (15,550);
insert into boiling values (16,717.87);
insert into boiling values (17,239.11);
insert into boiling values (18,87.30);
insert into boiling values (19,1032);
insert into boiling values (20,1757);
insert into boiling values (21,3109);
insert into boiling values (22,3560);
insert into boiling values (23,3680);
insert into boiling values (24,2944);
insert into boiling values (25,2334);
insert into boiling values (26,3134);
insert into boiling values (27,3200);
insert into boiling values (28,3186);
insert into boiling values (29,2835);
insert into boiling values (30,1180);
insert into boiling values (31,2477);
insert into boiling values (32,3106);
insert into boiling values (33,887);
insert into boiling values (34,958);
insert into boiling values (35,332.0);
insert into boiling values (36,119.93);
insert into boiling values (37,961);
insert into boiling values (38,1655);
insert into boiling values (39,3609);
insert into boiling values (40,4682);
insert into boiling values (41,5017);
insert into boiling values (42,4912);
insert into boiling values (43,4538);
insert into boiling values (44,4423);
insert into boiling values (45,3968);
insert into boiling values (46,3236);
insert into boiling values (47,2435);
insert into boiling values (48,1040);
insert into boiling values (49,2345);
insert into boiling values (50,2875);
insert into boiling values (51,1860);
insert into boiling values (52,1261);
insert into boiling values (53,457.4);
insert into boiling values (54,165.03);
insert into boiling values (55,944);
insert into boiling values (56,2170);
insert into boiling values (57,3737);
insert into boiling values (58,3716);
insert into boiling values (59,3793);
insert into boiling values (60,3347);
insert into boiling values (61,3273);
insert into boiling values (62,2067);
insert into boiling values (63,1802);
insert into boiling values (64,3546);
insert into boiling values (65,3503);
insert into boiling values (66,2840);
insert into boiling values (67,2993);
insert into boiling values (68,3141);
insert into boiling values (69,2223);
insert into boiling values (70,1469);
insert into boiling values (71,3675);
insert into boiling values (72,4876);
insert into boiling values (73,5731);
insert into boiling values (74,5828);
insert into boiling values (75,5869);
insert into boiling values (76,5285);
insert into boiling values (77,4701);
insert into boiling values (78,4098);
insert into boiling values (79,3129);
insert into boiling values (80,629.88);
insert into boiling values (81,1746);
insert into boiling values (82,2022);
insert into boiling values (83,1837);
insert into boiling values (84,1235);
insert into boiling values (85,610);
insert into boiling values (86,211.3);
insert into boiling values (87,950);
insert into boiling values (88,2010);
insert into boiling values (89,3471);
insert into boiling values (90,5061);
insert into boiling values (91,4300);
insert into boiling values (92,4404);
insert into boiling values (93,4273);
insert into boiling values (94,3501);
insert into boiling values (95,2880);
insert into boiling values (96,3383);
insert into boiling values (97,2900);
insert into boiling values (98,1743);
insert into boiling values (99,1269);
insert into boiling values (104,5800);
insert into boiling values (112,357);
insert into boiling values (113,1400);
insert into boiling values (114,420);
insert into boiling values (115,1400);
insert into boiling values (116,1085);
insert into boiling values (117,823);
insert into boiling values (118,263);