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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 ESOI returned 317 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 ESOI_ori WHERE start_date_time >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 TSMB returned no results
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(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 ATHN_ori o LEFT JOIN ATHN_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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 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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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 PTFM returned no results
Query for CALM returned no results
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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 329 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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 326 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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 HRMS returned no results
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 >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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(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 JUNG1_ori WHERE start_date_time >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 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 >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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 300 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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 DRBS returned no results
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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 MOSC 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 MOSC_ori WHERE start_date_time >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 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 >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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 KIEL 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 KIEL_ori WHERE start_date_time >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 KIEL2 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 KIEL2_ori WHERE start_date_time >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 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 KERG_ori WHERE start_date_time >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 NRLK 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 NRLK_ori WHERE start_date_time >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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 >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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 JBGO returned no results
The following query for MCMU 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 MCMU_ori o LEFT JOIN MCMU_rev r ON o.start_date_time = r.start_date_time WHERE o.start_date_time >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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 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 >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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 >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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 >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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
Query for MWSN returned no results
Query for NEU3 returned no results
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 >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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 >= '2012-05-16 23:00:00' AND o.start_date_time < '2012-05-17 10: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 MRNY 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 MRNY_ori WHERE start_date_time >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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 DOMB returned no results
Query for DOMC returned no results
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 >='2012-05-16 23:00:00' AND start_date_time < '2012-05-17 10: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:
Emilio Segre Obs. Israel (Tel Aviv University and Israel Space Agency, Israel and University Roma Tre with IFSI-CNR, Italy), 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), 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, Irkutsk 3 and Norilsk (Institute of Solar-Terrestrial Physics, ISFZ, Russian Academy of Sciences, Irkutsk, Russia), Mobile Cosmic Ray Laboratory, Moscow and Mirny (Pushkov Institute of Terrestrial Magnetism, Ionosphere and radio wave propagation IZMIRAN, Troitsk, Russia), Newark, Fort Smith, Inuvik, Mc Murdo, Nain, Peawanuck and Thule (University of Delaware Department of Physics and Astronomy and the Bartol Research Institute, USA), Kiel and KielRT (Institut fur Experimentelle und Angewandte Physik, Christian-Albrechts-Universitat zu Kiel, Germany), 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 (Sodankyla Geophysical Observatory of the University of Oulu, Finland), Apatity (Polar Geophysical Institute, Apatity, Murmansk Region, Russia), 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.
Data has been averaged to 2 min
see the log file