Connected to:read.nmdb.eu
 back&reset  back  log prev stepzoom leftzoom centerzoom rightzoomoutnext step
 see the log file the MySQL query http linkacknowledgements & disclaimer
 Data has been averaged to 2 min
 No data available for PSNM, AHMD, HUAN, DJON, ESOI, ARNM, AATA, ZUGS, UFSZ, CLMX, NVBK, MOSC, KIEL, KIEL2, KGSN, CALG, SANB, SNAE, NRLK, MCMU, MWSB, MRNY, for this time period


Query for PSNM returned no results

Query for AHMD returned no results

Query for HUAN returned no results

The following query for DJON returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM DJON_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

Query for ESOI returned no results

The following query for TSMB returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM TSMB_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for ATHN returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM ATHN_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for MXCO returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM MXCO_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

Query for ARNM returned no results

The following query for NANM returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 NANM_ori o LEFT JOIN NANM_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

The following query for PTFM returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM PTFM_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for CALM returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM CALM_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for ROME returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM ROME_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

Query for AATA returned no results

The following query for AATB returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM AATB_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for BKSN returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM BKSN_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for HRMS returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM HRMS_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for JUNG returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 JUNG_ori o LEFT JOIN JUNG_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

The following query for JUNG1 returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

Query for ZUGS returned no results

Query for UFSZ returned no results

The following query for LMKS returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 LMKS_ori o LEFT JOIN LMKS_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

The following query for IRK2 returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM IRK2_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for IRK3 returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM IRK3_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for IRKT returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM IRKT_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for DRBS returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM DRBS_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

Query for CLMX returned no results

Query for NVBK returned no results

The following query for MCRL returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM MCRL_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

Query for MOSC returned no results

The following query for NEWK returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 NEWK_ori o LEFT JOIN NEWK_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

Query for KIEL returned no results

Query for KIEL2 returned no results

The following query for MGDN returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM MGDN_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

Query for KGSN returned no results

The following query for YKTK returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM YKTK_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for KERG returned 327 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM KERG_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

Query for CALG returned no results

The following query for OULU returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 OULU_ori o LEFT JOIN OULU_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

Query for SANB returned no results

Query for SNAE returned no results

The following query for APTY returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM APTY_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

Query for NRLK returned no results

The following query for TXBY returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM TXBY_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for FSMT returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 FSMT_ori o LEFT JOIN FSMT_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

The following query for INVK returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 INVK_ori o LEFT JOIN INVK_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

The following query for JBGO returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 JBGO_ori o LEFT JOIN JBGO_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

Query for MCMU returned no results

The following query for NAIN returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 NAIN_ori o LEFT JOIN NAIN_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

The following query for PWNK returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 PWNK_ori o LEFT JOIN PWNK_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

The following query for THUL returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 THUL_ori o LEFT JOIN THUL_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

Query for MWSB returned no results

The following query for MWSN returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM MWSN_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for NEU3 returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM NEU3_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) ORDER BY start_date_time ASC

The following query for SOPB returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 SOPB_ori o LEFT JOIN SOPB_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

The following query for SOPO returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 SOPO_ori o LEFT JOIN SOPO_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

Query for MRNY returned no results

The following query for DOMB returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 DOMB_ori o LEFT JOIN DOMB_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

The following query for DOMC returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(subq.start_date_time))+86400*(TO_DAYS(subq.start_date_time)-1))/(60*2)) 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 DOMC_ori o LEFT JOIN DOMC_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2017-09-10 14:00:00' AND o.start_date_time < '2017-09-11 01:00: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*2)) ORDER BY start_date_time ASC

The following query for TERA returned 330 rows
SELECT DATE_ADD('0000-01-01 00:00:00', INTERVAL 60*2*FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*(TO_DAYS(start_date_time)-1))/(60*2)) SECOND) AS start_date_time, AVG(measured_corr_for_efficiency) AS corr_for_efficiency FROM TERA_ori WHERE start_date_time >='2017-09-10 14:00:00' AND start_date_time < '2017-09-11 01:00:00' GROUP BY FLOOR((TIME_TO_SEC(TIME(start_date_time))+86400*TO_DAYS(start_date_time))/(60*2)) 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: Tsumeb (see tsmb), Athens (Physics Department of the National and Kapodistrian University of Athens, Greece), Mexico (Cosmic Ray Group, Geophysical Institute, National Autonomous University of Mexico, UNAM, Mexico), Nor-Amberd (Cosmic Ray Division, CRD, of A.I. Alikhanyan National Science Laboratory, Yerevan, Armenia), Potchefstroom and Hermanus (Centre for Space Research, North-West University, Potchefstroom, South Africa), NM de Castilla la Mancha (Space Research Group SRG-UAH, University of Alcala, Spain), Rome (SVIRCO Observatory, INAF IFSI-UNIRomaTre, Italy), Alma-Ata B (Institute of Ionosphere, Almaty, Kazakhstan), Baksan (Institute of Nuclear Physics, Russian Academy of Sciences, Russia), IGY Jungfraujoch and NM64 Jungfraujoch (Physikalisches Institut, University of Bern, Switzerland), Lomnicky Stit (IEP SAS Kosice, Slovakia), Irkustk 2, Irkustk and Irkutsk 3 (Institute of Solar-Terrestrial Physics, ISFZ, Russian Academy of Sciences, Irkutsk, Russia), Dourbes (Royal Meteorological Institute of Belgium, Brussels, Belgium), Mobile Cosmic Ray Laboratory (Pushkov Institute of Terrestrial Magnetism, Ionosphere and radio wave propagation IZMIRAN, Troitsk, Russia), Newark, Fort Smith, Inuvik, Nain, Peawanuck and Thule (University of Delaware Department of Physics and Astronomy and the Bartol Research Institute, USA), Magadan (Institute of Cosmological Research and Radio Wave Propagation, Russian Academy of Sciences, Russia), Yakutsk and Tixie Bay (Institute Of Cosmophysical Research And Aeronomy Russian Academy Of Sciences, Yakutsk, Yakutia, Russia), Kerguelen and Terre Adelie (Observatoire de Paris and the French Polar Institute IPEV, France), Oulu, Dome C mini NM (bare) and Dome C mini NM (Sodankyla Geophysical Observatory of the University of Oulu, Finland), Apatity (Polar Geophysical Institute, Apatity, Murmansk Region, Russia), JangBogo (Chonnam National University, Department of Earth Science Education, South Korea), Mawson (Mahidol University, Bangkok, THAILAND), Neumayer III mini neutron monitor (see neu3), South Pole Bare and South Pole (University of Wisconsin, River Falls, USA)"

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:5.833 sec (4.551 sec for mysql query)