NNX15AI88G.db is an Sqlite3 database which contains electron plasma moments computed from data provided by CLUSTER PEACE and magnetic specta information from magnetic spectra computed from a combination of CLUSTER STAFF wideband and FGM full resolution vector data. The database covers every time period in which the Cluster spacecraft were both upstream of the bowshock and returning data in burstmode telemetry between 2001 and 2012 inclusively. There are about 180+ such periods currently in the database. The following abbreviations are used in the database. ABBREVIATIONS REGIONS: FS (Foreshock), SW (Solar Wind), MS (Magnetosheath), IM (INNER MAGNETOSPHERE), NS (Not Sure) QUALITY: 5 (Excellent) 4 (Very Good), 3 (Good), 2 (Fair), 1 (Poor) 0 (Not Present) SC: 1 (C1) 2 (C2), 3 (C3), 4 (C4) SINFO SVL (STAFF VERY LINEAR) SPL (STAFF PRETTY LINEAR), SNL (STAFF NON-LINEAR), SSP (STAFF SINGLE PEAK), SMP (STAFF MULTIPLE PEAKS) POP FULL (ALL POPULATIONS), STRAHL (STRAHL), CFULL (ALL POPULATIONS where data is not complete. This would include C2 moments from late 2011 on where one the elevation sensors had died. Each time period is represented by a parent (EventData) table with three dependent children tables (IModeData, PlasmaData, and SpectraData). These are described below. ------------------------------------------------------------------------- General Event Information EventSata EventID (INTEGER) Event Entry ID number BegDate (TEXT) Beginning date of event (Yr-Mo-Dy) BegTm (TEXT) Beginning time of event (Hr:Mn:Sc) BegDOY (INTEGER) Day Of Year EndDate (TEXT) Ending date of event (Yr-Mo-Dy) EndTm (TEXT) Ending time of event (Hr:Mn:Sc) EndDOY (INTEGER) DayOfYear Regions (TEXT) Regions Covered DiffusionQ (INTEGER) Diffusion Quality (0 if no diffusion) StrahlQ (INTEGER) Strahl Quality (0 if no strahl) RB (TEXT) Ring-beams (Y = yes, N = no, U = not looked for) ACE-N (REAL) ACE Solar wind Denisty (/cc) ACE-S (REAL) ACE Solar wind Speed (km/s) Notes: DiffusionQ and StrahhQ are subjective determinations. ACE-N and ACE-S are averages over the entire time period of the event. ------------------------------------------------------------------------- Information on the PEACE instruemtn mode used during the event. There can be a total of 8 (a HEEA and LEEA information set for each of the 4 Cluster spacecraft). The database will include generally only 1 set of information. That will be for the spacecraft and head used in the analysis. Instrument Mode IMdoeID: (INTEGE) Instrument Mode Entry ID number ParID: (INTEGE) Parent (EventID) ID number Name (TEXT) Instrument Mode (ex CPXP1H) SC (INTEGER) Spacecraft (1, 2, 3, or 4) StartE (REAL) Starting (Higest) Energy (eV) StopE (REAL) Stopping (Lowest) Energy (eV) NumE (INTEGER) Number of Energy Steps Returned NumA (INTEGER) Number of Azimuth Bins Returned NumElev (INTEGER) Number of Elevation Bins Returned ------------------------------------------------------------------------- Information on the plasma moments computed over the event time period. There can be multiple tables associated with an event if moments from multiple heads and/or multiple spacecraft and/fo multiple populations have been computed for the event. Plasma Parameters PlasID: (INTEGE) Plasma Information Entry ID number ParID: (INTEGE) Parent (EventID) ID number POP: (TEXT) Population Used (FULL, STRAHL, CFULL) HEAD (TEXT) Instrument Head Used (LEEA or HEEA) SC (INTEGER) Spacecraft (1, 2, 3, or 4) DEN (REAL) Population Density (/cc) SPD (REAL) Population Speed (km/s) TEMP (REAL) Population Total Temperature (eV) TA (REAL) Population Temperature Anisptropy (Tperp/Tpara) Notes: All moments are averages over the entire time period of the event when the spacecraft is in the upstream. ------------------------------------------------------------------------- Information on the spectracomputed over partial time periods within the total event time. Spectra Parameters SpecID: (INTEGE) Spectra Information Entry ID number ParID: (INTEGE) Parent (EventID) ID number REGION (TEXT) Region of Spectra (FS, SW or NS) DIFFUSION (TEXT) Diffusion present in region (YES, NO, NS) BegDate (TEXT) Beginning data of spectra (Yr-Mo-Dy) BegTm (TEXT) Beginning time of spectra (Hr:Mn:Sc) EndDate (TEXT) Beginning data of spectra (Yr-Mo-Dy) EndTm (TEXT) Beginning time of spectra (Hr:Mn:Sc) FGMRate (INTEGER) FGM vectors/second STAFFRate (INTEGER) STAFF vectors/second FGMSI (REAL) Spectral index of the FGM portion of the spectrum STAFFSI (REAL) Spectral index of the STAFF portion of the spectrum SINFO (TEXT) Spectra Info