
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;

CREATE TABLE apod (
    title text,
    body text,
    sdate date,
    keywords text,
    id integer
);

INSERT INTO apod VALUES ('A Wolf-Rayet Star Bubble', 'What''s a Wolf-Rayet star, and how did it create that spherical bubble and sweeping arc? A Wolf-Rayet star is a star that originated with a mass over 40 times that of our Sun. An extremely hot, luminous star, it has since expelled shells of material through its strong stellar wind which could account for the bubble shaped nebula that surrounds it. But astronomers are unsure how the central Wolf-Rayet created both the bubble and the arc seen above, and even whether it acted alone in doing so. Together, this bubble and the arc are known as NGC 2359.', '1996-08-26', 'Wolf-Rayet star, star', 32);
INSERT INTO apod VALUES ('The Pulsar Powered Crab', 'In the Summer of 1054 A.D. Chinese astronomers reported that a star in the constellation of Taurus suddenly became as bright as the full Moon. Fading slowly, it remained visible for over a year. It is now understood that a spectacular supernova explosion - the detonation of a massive star whose remains are now visible as the Crab Nebula - was responsible for the apparition. The core of the star collapsed to form a rotating neutron star or pulsar, one of the most exotic objects known to 20th century astronomy. Like a cosmic lighthouse, the rotating Crab pulsar generates beams of radio, visible, x-ray and gamma-ray energy which, as the name suggests, produce pulses as they sweep across our view. Using a stunning series of visible light images taken with the Hubble Space Telescope (HST), astronomers have recently discovered spectacular pulsar powered motions within the Crab nebula. Highlights of this HST Crab "movie" show wisps of material moving away from the pulsar at half the speed of light, a scintillating halo, and an intense knot of emission dancing, sprite-like, above the pulsar''s pole. Only 6 miles wide but more massive than the sun, the pulsar''s energy drives the dynamics and emission of the nebula itself which is more than 10 lightyears across. In the HST image above, the pulsar is the left most of the two bright central stars.', '1996-05-31', 'pulsar', 57);
INSERT INTO apod VALUES ('Aurora: Curtains in the Sky', 'Looking out over Lake Superior at dusk you see Venus (lower left) and... curtains? Like an ant looking up at window curtains, aurora frequently appear as huge flowing light displays. These colorful, often spectacular phenomena are most frequently visible from locations near the Earth''s poles. Aurora are caused by electrons from the solar wind funneling to Earth along magnetic field lines, and striking atoms and molecules in our atmosphere. Auroral color is determined by which atmospheric ions are struck and recombine to form neutral atoms. Hourly updates of auroral sightings are posted to the WWW. It is still controversial whether aurora make any sound audible from the ground. If you think you have "heard an aurora," please report it !', '1996-06-19', 'sky', 82);
INSERT INTO apod VALUES ('An Extreme UltraViolet View of the Comet', 'As the Sun floods Comet Hyakutake with ultraviolet light gases in the coma scatter the radiation and fluoresce making the comet a bright source in the ultraviolet sky. The above image made using data from NASA''s Extreme UltraViolet Explorer (EUVE) satellite, represents the intensity of the comet in this invisible high energy band in false color. The image is about 3/4 of a degree high and 2 degress wide and offers insights to the composition of this visitor from the distant solar system that can be obtained from the highest energy bands of the ultraviolet spectrum. The International Ultraviolet Explorer (IUE) satellite has also examined ultraviolet light from the comet and now reports the detection of many bands of molecular emission particularly those due to molecular carbon (C2), carbon monoxide (CO) and caron dioxide (C02) ions as well as indications of a rapid increase in the production of water (H20). Latest Comet Hyakutake images: JPL, Fayetteville Observer-Times, NASA''s Night of the Comet, ICSTARS, Crni Vrh Obs., Cent. Mich U.', '1996-03-30', 'comet, euve, ultraviolet', 93);
INSERT INTO apod VALUES ('The Pipe Dark Nebula', 'The dark nebula predominant at the lower left of the above photograph is known as the Pipe Nebula. The dark clouds, suggestively shaped like smoke rising from a pipe, are caused by absorption of background starlight by dust. These dust clouds can be traced all the way to the Rho Ophiuchi nebular clouds on the right. The brightest star in the field is Antares. Many types of nebula are highlighted here: the red are emission nebula, the blue are reflection nebula, and the dark are absorption nebula. This picture has been digitally enhanced.', '1996-05-28', 'nebula, dark nebula, dark', 108);

INSERT INTO apod VALUES ('A Lucky Lunar Eclipse', 'Tonight''s full moon would normally washout the spectacle of Comet Hyakutake''s lovely tail, even for those far from light polluted skies. Except that tonight comet observers are in luck - the dance of the planets calls for a total lunar eclipse ! Lunar eclipses are caused when the Moon passes through the Earth''s shadow. Although dimmed, the eclipsed Moon may not appear completely dark. Sunlight scattered into the Earth''s shadow after passing around the planet''s edge and through its dusty atmosphere can make the Moon take on dramatic shades of red during totality as demonstrated in the above photo of the November 1993 lunar eclipse. Tonight, totality begins at 6:26 p.m. EST and lasts about an hour and a half. Weather permitting, the eclipse will be visible for all those comet and moon watchers lucky enough to be on the Earth''s nightside. Latest Comet Hyakutake images: APOD Hyakutake Archive, JPL, Fayetteville Observer-Times, NASA''s Night of the Comet, ICSTARS, Jerry Lodriguss, ScienceWeb, Crni Vrh Obs., Cent. Mich. U.', '1996-04-03', 'eclipse, lunar eclipse', 128);
INSERT INTO apod VALUES ('A MACHO View of Galactic Dark Matter', 'What is our Galaxy made of? Stellar motions indicate there is much more mass than just stars and gas. Photographs like the two shown above may be yielding a clue about the dark matter, however. Pictured is the first recorded instance of a dim star in our Galaxy moving in front of a bright background star, shown by the arrow, deflecting light around it, and causing the background star to appear much brighter (right frame). Were our Galaxy made predominantly of MAssive Compact Halo Objects (MACHOs), many similar such gravitational lensing events would be expected when photographing the Large Magellanic Clouds (LMC) - hence indicating the presence of MACHO lenses in our Galaxy. A research team led by Charles Alcock this month claimed enough LMC gravitational lensing events to indicate at least half of the dark matter in our Galaxy is composed of MACHOs. This spectacular claim may well be correct - but awaits crucial testing with future observations and modeling.', '1996-02-02', 'dark matter, dark', 152);
INSERT INTO apod VALUES ('Beneath Jupiter''s Clouds', 'This near-infrared image of Jupiter was made using instrumentation at NASA''s Infrared Telescope Facility, located on the summit of Mauna Kea, Hawaii, in support of the Galileo mission to Jupiter. The brightest spots indicated by the false red shading are relatively clear areas and represent glimpses beneath the outer layer of Jupiter''s obscuring cloud tops. On December 7, 1995 a probe from the Galileo spacecraft parachuted through these clouds for 57 minutes before melting, all the while providing the first direct sampling of the conditions there. In a recent press release of the probe''s findings scientists announced some surprising results. Discoveries based on probe data included a new radiation belt 31,000 miles above the cloud tops, relatively constant high velocity winds (up to 330 mph), no obvious water clouds, low abundances of Helium and Neon, lightning occurring only 1/10th as much as on Earth, and unexpectedly high temperatures. The Galileo orbiter continues its two-year mission to explore the Jovian system.', '1996-01-23', 'Jupiter, clouds', 209);
INSERT INTO apod VALUES ('NGC 7027: A Dying Star''s Nebula', 'This pseudo-color composite of two recent Hubble Space Telescope images is a picture of a Sun-like star nearing the end of its lifetime. The exquisite details visible in this planetary nebula indicate that when the star passed through its Red Giant phase it initially shrugged off its outer atmosphere gently and evenly producing the outer faint spherical shells. As the process continued, material was apparently ejected in dense clumps producing dust clouds in the bright inner regions. The whole ejection process was amazingly rapid, taking only a few thousand years compared to a 10 billion year lifetime typical for Solar type stars. In the end the hot stellar core, now a white dwarf star, was left - seen here as a white dot at the center of the nebula. Our middle-aged Sun will experience a similar fate... in about 5 billion years!', '1996-01-17', 'nebula, star, NGC 7027', 217);
INSERT INTO apod VALUES ('Mercury''s Faults', 'The surface of the planet Mercury is not without fault. In this case, however, "fault" refers to unusual surface features that are the topic of much speculation. The above fault line is called Santa Maria Rupes, and runs through many prominent craters. The meandering feature is thought to be the result of huge forces of compression on Mercury''s surface. Such rupes probably originate from large impacts and a general shrinking of Mercury''s crust, which in turn causes parts of the crust to push above other parts.', '1996-01-21', 'Mercury', 223);

INSERT INTO apod VALUES ('Water World', 'Water (Dihydrogen Oxide, H2O) is a truly remarkable chemical compound and is fundamental to life on Earth. Earth is the only planet in the Solar System where the surface temperature and pressure allow the three forms of water, solid (ice), liquid (ocean), and gas (water vapor condensing in clouds) to exist simultaneously on its surface. Water in one of these forms accounts for everything visible in this view of Earth from space looking north at the Bering Sea and the coast of Alaska, USA, around Bristol Bay.', '1995-11-18', 'water', 253);
INSERT INTO apod VALUES ('At the Core of M15', 'Densely packed stars in the core of the globular cluster M15 are shown in this Hubble Space Telescope (HST) image taken in April of 1994. The stars revealed are contained in an area 1.6 light years across and their colors roughly indicate their temperatures - hot stars appear blue, cooler stars look reddish-orange. M15 has long been recognized as one of the densest cluster of stars in our galaxy outside of the galactic center itself. Even the unprecedented resolving power of the HST cameras could not separate the individual stars in its innermost regions. However, this HST image reveals that the density of stars continues to rise toward the cluster''s core, suggesting that a sudden, runaway collapse due to the gravitational attraction of many closely packed stars or a single central massive object, perhaps a black hole, could account for the core''s extreme density.', '1995-11-20', 'M15', 260);
INSERT INTO apod VALUES ('A Halloween Invasion from Mars', 'Orson Welles became an instant legend on Halloween in 1938 for his radio dramatization of H.G. Wells'' "War of the Worlds". Some listeners who did not realize it was a theatrical production were driven to near panic by this fictional account of invaders from Mars. In the story, as in the above Hubble Space Telescope image, Mars was at "opposition", its point of closest approach to the Earth, a distance of some 65 million miles. For the Martians, it was imagined that this was a good time to invade. For astronomers, opposition is a good time to study the red planet and this HST image, represents the clearest view of Mars ever for an Earth telescope. The icy north polar cap is visible at the top of the picture as well as a veil of white clouds along the planet''s left edge. The dark markings represent areas where the reddish tinged dust characteristic of the surface has been blown away by the Martian winds.', '1995-10-31', 'Mars', 273);
INSERT INTO apod VALUES ('Phobos: Doomed Moon of Mars', 'Mars, the red planet named for the Roman god of war, has two tiny moons, Phobos and Deimos, whose names are derived from the Greek for Fear and Panic. These Martian moons may well be captured asteroids originating in the asteroid belt between Mars and Jupiter or perhaps from even more distant reaches of the Solar System. In this 1977 Viking orbiter image, the largest moon, Phobos, is seen to be a heavily cratered asteroid-like object. It is about 17 miles across and zips through the Martian sky completing an orbit in less than 8 hours. Phobos is doomed. It orbits so close to Mars, (about 3,600 miles above the surface compared to 250,000 miles for our Moon ) that gravitational tidal forces are dragging it down. In 100 million years or so it could crash into the surface or be shattered by stress caused by the relentless tidal forces, the debris forming a ring around Mars.', '1995-10-02', 'Moon, Mars, Phobos', 288);
INSERT INTO apod VALUES ('Uranus: The Tilted Planet', 'This picture was snapped by the Voyager 2 spacecraft in 1986 - the only spacecraft ever to visit Uranus. Uranus is the third largest planet after Jupiter and Saturn. Uranus has many moons and a ring system. Uranus is composed mostly of liquid water, methane and ammonia, surrounded by a thick gas atmosphere of mostly hydrogen and helium. Uranus is peculiar in that its rotation axis is greatly tilted and sometimes points near the sun. It remains an astronomical mystery why Uranus'' axis is so tilted. Uranus and Neptune are very similar.', '1995-08-16', 'planet, Uranus', 336);

-- to find 'comet & tail'
INSERT INTO apod VALUES ('Comet Hyakutake Passes the Sun', 'On May 1, Comet Hyakutake made its closest approach to the Sun. During this time it was not possible to view the comet with most astronomical instruments because of the brightness of the nearby Sun. But the orbiting Solar and Heliospheric Observatory (SOHO) spacecraft contains telescopes meant to look directly at the Sun and so were able to track the comet during this crucial time. This picture, taken May 2, shows the tails of Comet Hyakutake pointing away from the Sun, as expected. During its closest approach, Comet Hyakutake passed inside the orbit of Mercury. Comet Hyakutake will not return to the inner Solar System for another 14,000 years.', '1996-05-16', 'comet, Sun, comet Hyakutake', 84);
INSERT INTO apod VALUES ('The Milky Way Near the Northern Cross', 'This beautiful image of the sky near the bright star Deneb (just above center) reveals the stars, nebulae, and dark clouds along the plane of our Milky Way Galaxy as seen from the northern hemisphere (near Columbia Missouri, USA). Just below Deneb lies the suggestively shaped North American emission nebula. Deneb is the brightest star in the constellation Cygnus, located in the tail of this celestial swan. Cygnus contains the asterism known as the Northern Cross and marks one side of the "Great Rift" in the Milky Way, a series of dark obscuring dust clouds which stretches on through the constellation Sagittarius. Deneb defines the top of the Northern Cross while the body of the cross extends past the upper right corner of the picture. Cygnus also harbors the most famous candidate for a black hole in our galaxy, Cygnus X-1.', '1996-05-15', 'Milky Way', 87);
INSERT INTO apod VALUES ('Comet Hyakutake''s Closest Approach', 'The above true color image of Comet Hyakutake was taken the night of March 21/22. Tonight, Comet Hyakutake will make its nearest approach to Earth, closing to a mere 10 million miles as it passes over the planet''s Northern Hemisphere. From dark sky areas, it''s tail may be seen to cover about 20 degrees on the sky (40 times the apparent diameter of the full moon) corresponding to well over 3 million miles. at the distance of the comet. The word comet, referring to the tail, derives from the Greek "aster kometes", meaning long-haired star - and the hair of comet Hyakutake continues to grow as it nears the Sun! The tail grows as the sun heats and sublimates (changes directly from solid to gas) the material on the icy surface of the comet nucleus, sending jets of gas and dust into space. The material is swept back by the solar wind, so comet tails usually point away from the sun rather than simply trailing along behind in the comets'' orbit. Some predict the tail will grow over the next few days to nearly 50 degrees. For the rest of March and most of April Comet Hyakutake will be visible to Northern viewers (weather permitting). The tail will be most visible from dark sky areas. Moonlit skies will tend to washout the comet as the April 3rd full moon approaches - however, on April 3rd, there will be a lunar eclipse ! Latest Comet Hyakutake images: Crni Vrh Observatory, Slovenia, Fayetteville Observer-Times', '1996-03-24', 'comet, comet Hyakutake', 97);

-- to 'neutrino|(dark & matter)'
INSERT INTO apod VALUES ('Jupiter''s Colorful Clouds', 'What makes the colors in Jupiter''s clouds ? With a mean temperature of 120 degrees Kelvin (-153 degrees Celsius) and a composition dominated by Hydrogen (about 90%), and Helium (about 10%) with a smattering of hydrogen compounds like methane and ammonia, astronomers have been hard pressed to explain the blue, orange and brown cloud bands and the salmon colored "red" spot. Trouble is -- at the cool cloud temperatures Jupiter''s atmospheric constituents should be colorless! Some suggest that more colorful hydrogen compounds well up from warmer regions in the atmosphere, tinting the cloud tops. Alternatively, compounds of trace elements like sulfur may color the clouds. The colors do indicate the clouds'' altitudes, blue is lowest through red as highest. The dark colored bands are called belts and the light colored ones zones. In addition to the belts and zones, the Voyager missions revealed the presence of intricate vortices visible, for example, in this 1979 image from the Voyager I flyby. Centuries of visual observations of Jupiter have revealed that the colors of its clouds are ever changing.', '1996-08-03', 'Jupiter, clouds', 22);
INSERT INTO apod VALUES ('Giant Cluster Bends, Breaks Galaxy Images', 'What are those strange blue objects? Many are images of a single, unusual, beaded, blue, ring-like galaxy which just happens to line-up behind a giant cluster of galaxies. Cluster galaxies here appear yellow and -- together with the cluster''s dark matter -- act as a gravitational lens. A gravitational lens can create several images of background galaxies, analogous to the many points of light one would see while looking through a wine glass at a distant street light. The distinctive shape of this background galaxy -- which is probably just forming -- has allowed astronomers to deduce that it has separate images at 4, 8, 9 and 10 o''clock, from the center of the cluster. Possibly even the blue smudge just left of center is yet another image! This spectacular photo from HST was taken in October 1994. The first cluster lens was found unexpectedly by Roger Lynds ( NOAO ) and Vahe Petrosian ( Stanford ) in 1986 while testing a new type of imaging device. Lensed arcs around this cluster, CL0024+1654, were first discovered from the ground by David Koo ( UCO Lick ) in 1988. Congratulations: Hubble Space Telescope is six years old today!', '1996-04-24', 'cluster', 148);

