Connected to:read.nmdb.eu
 back&reset  back  log prev stepzoom leftzoom centerzoom rightzoomoutnext step
the MySQL query http linkacknowledgements & disclaimer
 NO LOG
The following query for JUNG returned 288 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*5*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*5)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM JUNG_ori WHERE start_date_time >='2024-04-26 00:10:00' AND start_date_time < '2024-04-27 00:10:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*5)) ORDER BY start_date_time ASC

The following query for JUNG1 returned 288 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*5*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*5)) SECOND) AS start_date_time, AVG(subq.corr_for_efficiency) AS corr_for_efficiency FROM (SELECT o.start_date_time, CASE WHEN r.start_date_time IS NULL THEN o.measured_corr_for_efficiency ELSE r.revised_corr_for_efficiency END AS corr_for_efficiency FROM JUNG1_ori o LEFT JOIN JUNG1_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2024-04-26 00:10:00' AND o.start_date_time < '2024-04-27 00:10:00' ORDER BY start_date_time ASC) AS subq GROUP BY FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*TO_DAYS(subq.start_date_time))/(60*5)) ORDER BY start_date_time ASC

Proprietary rights and acknowledgements:

NMDB distributes official data provided by the PIs of the neutron monitor stations. Data of different origin may not have been validated or authorised by the respective PI, and any deviation with respect to the authorised data is not his/her responsibility.

Data retrieved via NMDB are the property of the individual data providers. These data are free for non commercial use within the restrictions imposed by the providers. If you use such data for your research or applications, please acknowledge the origin by a sentence like "We acknowledge the NMDB database (www.nmdb.eu), founded under the European Union's FP7 programme (contract no. 213007) for providing data, and the PIs of individual neutron monitors at: IGY Jungfraujoch and NM64 Jungfraujoch (Physikalisches Institut, University of Bern, Switzerland)"

Acknowledgement of other data sources where relevant

Smoothed Sunspot Numbers and Monthly Sunspot Numbers are provided by the Solar Influences Data Analysis Center (SIDC), Royal Observatory of Belgium.

Kp 3-hourly index is provided by the Deutsches GeoForschungsZentrum Postdam (GFZ) in cooperation with the International Association of Geomagnetism and Aeronomy (IAGA) and the International Service of Geomagnetic Indices (ISGI). DOI of the Kp dataset

GOES proton flux data is provided by the United States NOAA/National Geophysical Data Center (NGDC)

"original" and "revised" data in NMDB:

Neutron monitor count rates are available through NMDB in various versions. Data called "original" are the count rates of a given monitor as provided by this monitor's registration system. Depending on the neutron monitor station these data may have been modified by real-time quality checking procedures, which correct obvious short-lived instrumental effects such as spikes or data gaps produced by hardware and software disturbances, as well as erroneous atmospheric pressure measurements. These corrections are made under the responsibility of the data provider who also archives the raw data. "Revised" data contain further corrections made during subsequent analyses.
More information on the NMDB format can be found here.



Total Execution Time:2.152 sec (1.026 sec for mysql query)