fix 2 tests out of 3; TODO: test forecasters

diff --git a/data/scripts/build_testdata.R b/data/scripts/build_testdata.R
index e0bc153..4c5978a 100644 (file)
--- a/data/scripts/build_testdata.R
+++ b/data/scripts/build_testdata.R
@@ -3,7 +3,7 @@ dates = seq(as.Date("2007-01-01"),as.Date("2007-07-01"),"days")
 times = strftime( seq(
        from=ISOdatetime(2007,1,1,1,0,0,tz="GMT"),
        to=ISOdatetime(2007,7,2,0,0,0,tz="GMT"),
-       by="hour") )
+       by="hour"), tz="GMT" )
 
 # Only one covariable (so that the "matrix" is always invertible)
 L = length(dates) #182

diff --git a/pkg/R/F_Average.R b/pkg/R/F_Average.R
index dab156a..ba0f003 100644 (file)
--- a/pkg/R/F_Average.R
+++ b/pkg/R/F_Average.R
@@ -13,6 +13,22 @@ AverageForecaster = setRefClass(
                {
                        callSuper(...)
                },
+               predict = function(today, memory, horizon, ...)
+               {
+                       predicted_shape = predictShape(today, memory, horizon, ...)
+                       #Take care of never passing same_day==FALSE (when pjump == Persistence)
+                       predicted_delta =
+                               if (#as.character(substitute(pjump))=="Persistence" && #TODO: doesn't work
+                                       hasArg("same_day") && list(...)$same_day==FALSE)
+                               {
+                                       args = list(...)
+                                       args$same_day = TRUE
+                                       do.call(pjump, append(list("today"=today,"memory"=memory,"horizon"=horizon), args))
+                               }
+                               else
+                                       pjump(data, today, memory, horizon, params, ...)
+                       predicted_shape + tail(data$getSerie(today),1) - predicted_shape[1] + predicted_delta
+               },
                predictShape = function(today, memory, horizon, ...)
                {
                        avg = rep(0., horizon)

diff --git a/pkg/R/getData.R b/pkg/R/getData.R
index 574522b..8d1a6fa 100644 (file)
--- a/pkg/R/getData.R
+++ b/pkg/R/getData.R
@@ -17,11 +17,10 @@
 #'
 #' @return An object of class Data
 #'
-#' @example
-#' ts_data = read.csv(system.file("extdata",ts_data,package="talweg",mustWork=TRUE))
-#' exo_data = read.csv(system.file("extdata",exo_data,package="talweg",mustWork=TRUE))
-#' getData(ts_data, exo_data, ...)
-#'
+#' @examples
+#' ts_data = read.csv(system.file("extdata","pm10_mesures_H_loc.csv",package="talweg"))
+#' exo_data = read.csv(system.file("extdata","meteo_extra_noNAs.csv",package="talweg"))
+#' getData(ts_data, exo_data, input_tz="Europe/Paris", working_tz="Europe/Paris", limit=150)
 #' @export
 getData = function(ts_data, exo_data, input_tz="GMT", date_format="%d/%m/%Y %H:%M",
        working_tz="GMT", predict_at=0, limit=Inf)

diff --git a/pkg/R/getForecast.R b/pkg/R/getForecast.R
index 6e7720e..8efcff8 100644 (file)
--- a/pkg/R/getForecast.R
+++ b/pkg/R/getForecast.R
@@ -24,8 +24,10 @@
 #' @return An object of class Forecast
 #'
 #' @examples
-#' data = getData(ts_data="pm10_mesures_H_loc.csv", exo_data="meteo_extra_noNAs.csv",
-#'   input_tz = "Europe/Paris", working_tz="Europe/Paris", predict_at=7)
+#' ts_data = system.file("extdata","pm10_mesures_H_loc.csv",package="talweg")
+#' exo_data = system.file("extdata","meteo_extra_noNAs.csv",package="talweg")
+#' data = getData(ts_data, exo_data, input_tz = "Europe/Paris",
+#'   working_tz="Europe/Paris", predict_at=7)
 #' pred = getForecast(data, 2200:2230, "Persistence", "Persistence", 500, 12)
 #' \dontrun{#Sketch for real-time mode:
 #' data = new("Data", ...)

diff --git a/pkg/R/utils.R b/pkg/R/utils.R
index 3777f2d..de8e861 100644 (file)
--- a/pkg/R/utils.R
+++ b/pkg/R/utils.R
@@ -15,16 +15,22 @@ dateIndexToInteger = function(index, data)
                return (index)
        if (inherits(index, "Date") || is.character(index))
        {
-               tryCatch(dt <- as.POSIXct(index), error=function(e) stop("Unrecognized index format"))
+               tryCatch(indexAsDate <- as.Date(index), error=function(e) stop("Unrecognized index format"))
                #TODO: tz arg to difftime ?
-               integerIndex <- round( (as.numeric( difftime(dt, data$getTime(1)) ))[1] ) + 1
-               if (integerIndex > 0 && integerIndex <= data$getSize())
+               integerIndex <- round( as.numeric(
+                       difftime(indexAsDate, as.Date(data$getTime(1)[1])) ) ) + 1
+               if (integerIndex >= 1 && integerIndex <= data$getSize())
                {
-                       #WARNING: if series start at date >0h, result must be shifted
-                       date1 = as.POSIXlt(data$getTime(1)[1])
-                       date2 = as.POSIXlt(data$getTime(2)[1])
-                       shift = (date1$year==date2$year && date1$mon==date2$mon && date1$mday==date2$mday)
-                       return (integerIndex + ifelse(shift,1,0))
+                       #WARNING: if index>=2 && series start at date >0h, result must be shifted
+                       #Convention: if first date asked, return first matching index (i.e.: 1)
+                       shift = 0
+                       if (integerIndex >= 2)
+                       {
+                               date1 = as.POSIXlt(data$getTime(1)[1])
+                               date2 = as.POSIXlt(data$getTime(2)[1])
+                               shift = (date1$year==date2$year && date1$mon==date2$mon && date1$mday==date2$mday)
+                       }
+                       return (integerIndex + shift)
                }
                stop("Date outside data range")
        }

diff --git a/pkg/inst/testdata/exo.csv b/pkg/inst/testdata/exo.csv
deleted file mode 100644 (file)
index e69de29..0000000

diff --git a/pkg/inst/testdata/exo_test.csv b/pkg/inst/testdata/exo_test.csv
new file mode 100644 (file)
index 0000000..5da11e2
--- /dev/null
+++ b/pkg/inst/testdata/exo_test.csv
@@ -0,0 +1,183 @@
+"date","var","var_pred"
+2007-01-01,1,1
+2007-01-02,1,1
+2007-01-03,1,1
+2007-01-04,1,1
+2007-01-05,1,1
+2007-01-06,1,1
+2007-01-07,1,1
+2007-01-08,1,1
+2007-01-09,1,1
+2007-01-10,1,1
+2007-01-11,1,1
+2007-01-12,1,1
+2007-01-13,1,1
+2007-01-14,1,1
+2007-01-15,1,1
+2007-01-16,1,1
+2007-01-17,1,1
+2007-01-18,1,1
+2007-01-19,1,1
+2007-01-20,1,1
+2007-01-21,1,1
+2007-01-22,1,1
+2007-01-23,1,1
+2007-01-24,1,1
+2007-01-25,1,1
+2007-01-26,1,1
+2007-01-27,1,1
+2007-01-28,1,1
+2007-01-29,1,1
+2007-01-30,1,1
+2007-01-31,1,1
+2007-02-01,1,1
+2007-02-02,1,1
+2007-02-03,1,1
+2007-02-04,1,1
+2007-02-05,1,1
+2007-02-06,1,1
+2007-02-07,1,1
+2007-02-08,1,1
+2007-02-09,1,1
+2007-02-10,1,1
+2007-02-11,1,1
+2007-02-12,1,1
+2007-02-13,1,1
+2007-02-14,1,1
+2007-02-15,1,1
+2007-02-16,1,1
+2007-02-17,1,1
+2007-02-18,1,1
+2007-02-19,1,1
+2007-02-20,1,1
+2007-02-21,1,1
+2007-02-22,1,1
+2007-02-23,1,1
+2007-02-24,1,1
+2007-02-25,1,1
+2007-02-26,1,1
+2007-02-27,1,1
+2007-02-28,1,1
+2007-03-01,1,1
+2007-03-02,1,1
+2007-03-03,1,1
+2007-03-04,1,1
+2007-03-05,1,1
+2007-03-06,1,1
+2007-03-07,1,1
+2007-03-08,1,1
+2007-03-09,1,1
+2007-03-10,1,1
+2007-03-11,1,1
+2007-03-12,1,1
+2007-03-13,1,1
+2007-03-14,1,1
+2007-03-15,1,1
+2007-03-16,1,1
+2007-03-17,1,1
+2007-03-18,1,1
+2007-03-19,1,1
+2007-03-20,1,1
+2007-03-21,1,1
+2007-03-22,1,1
+2007-03-23,1,1
+2007-03-24,1,1
+2007-03-25,1,1
+2007-03-26,1,1
+2007-03-27,1,1
+2007-03-28,1,1
+2007-03-29,1,1
+2007-03-30,1,1
+2007-03-31,1,1
+2007-04-01,1,1
+2007-04-02,1,1
+2007-04-03,1,1
+2007-04-04,1,1
+2007-04-05,1,1
+2007-04-06,1,1
+2007-04-07,1,1
+2007-04-08,1,1
+2007-04-09,1,1
+2007-04-10,1,1
+2007-04-11,1,1
+2007-04-12,1,1
+2007-04-13,1,1
+2007-04-14,1,1
+2007-04-15,1,1
+2007-04-16,1,1
+2007-04-17,1,1
+2007-04-18,1,1
+2007-04-19,1,1
+2007-04-20,1,1
+2007-04-21,1,1
+2007-04-22,1,1
+2007-04-23,1,1
+2007-04-24,1,1
+2007-04-25,1,1
+2007-04-26,1,1
+2007-04-27,1,1
+2007-04-28,1,1
+2007-04-29,1,1
+2007-04-30,1,1
+2007-05-01,1,1
+2007-05-02,1,1
+2007-05-03,1,1
+2007-05-04,1,1
+2007-05-05,1,1
+2007-05-06,1,1
+2007-05-07,1,1
+2007-05-08,1,1
+2007-05-09,1,1
+2007-05-10,1,1
+2007-05-11,1,1
+2007-05-12,1,1
+2007-05-13,1,1
+2007-05-14,1,1
+2007-05-15,1,1
+2007-05-16,1,1
+2007-05-17,1,1
+2007-05-18,1,1
+2007-05-19,1,1
+2007-05-20,1,1
+2007-05-21,1,1
+2007-05-22,1,1
+2007-05-23,1,1
+2007-05-24,1,1
+2007-05-25,1,1
+2007-05-26,1,1
+2007-05-27,1,1
+2007-05-28,1,1
+2007-05-29,1,1
+2007-05-30,1,1
+2007-05-31,1,1
+2007-06-01,1,1
+2007-06-02,1,1
+2007-06-03,1,1
+2007-06-04,1,1
+2007-06-05,1,1
+2007-06-06,1,1
+2007-06-07,1,1
+2007-06-08,1,1
+2007-06-09,1,1
+2007-06-10,1,1
+2007-06-11,1,1
+2007-06-12,1,1
+2007-06-13,1,1
+2007-06-14,1,1
+2007-06-15,1,1
+2007-06-16,1,1
+2007-06-17,1,1
+2007-06-18,1,1
+2007-06-19,1,1
+2007-06-20,1,1
+2007-06-21,1,1
+2007-06-22,1,1
+2007-06-23,1,1
+2007-06-24,1,1
+2007-06-25,1,1
+2007-06-26,1,1
+2007-06-27,1,1
+2007-06-28,1,1
+2007-06-29,1,1
+2007-06-30,1,1
+2007-07-01,1,1

diff --git a/pkg/inst/testdata/ts.csv b/pkg/inst/testdata/ts.csv
deleted file mode 100644 (file)
index e69de29..0000000

diff --git a/pkg/inst/testdata/ts_test.csv b/pkg/inst/testdata/ts_test.csv
new file mode 100644 (file)
index 0000000..6d5b4c6
--- /dev/null
+++ b/pkg/inst/testdata/ts_test.csv
@@ -0,0 +1,4369 @@
+"time","value"
+"2007-01-01 01:00:00",1
+"2007-01-01 02:00:00",1
+"2007-01-01 03:00:00",1
+"2007-01-01 04:00:00",1
+"2007-01-01 05:00:00",1
+"2007-01-01 06:00:00",1
+"2007-01-01 07:00:00",1
+"2007-01-01 08:00:00",1
+"2007-01-01 09:00:00",1
+"2007-01-01 10:00:00",1
+"2007-01-01 11:00:00",1
+"2007-01-01 12:00:00",1
+"2007-01-01 13:00:00",1
+"2007-01-01 14:00:00",1
+"2007-01-01 15:00:00",1
+"2007-01-01 16:00:00",1
+"2007-01-01 17:00:00",1
+"2007-01-01 18:00:00",1
+"2007-01-01 19:00:00",1
+"2007-01-01 20:00:00",1
+"2007-01-01 21:00:00",1
+"2007-01-01 22:00:00",1
+"2007-01-01 23:00:00",1
+"2007-01-02 00:00:00",1
+"2007-01-02 01:00:00",2
+"2007-01-02 02:00:00",2
+"2007-01-02 03:00:00",2
+"2007-01-02 04:00:00",2
+"2007-01-02 05:00:00",2
+"2007-01-02 06:00:00",2
+"2007-01-02 07:00:00",2
+"2007-01-02 08:00:00",2
+"2007-01-02 09:00:00",2
+"2007-01-02 10:00:00",2
+"2007-01-02 11:00:00",2
+"2007-01-02 12:00:00",2
+"2007-01-02 13:00:00",2
+"2007-01-02 14:00:00",2
+"2007-01-02 15:00:00",2
+"2007-01-02 16:00:00",2
+"2007-01-02 17:00:00",2
+"2007-01-02 18:00:00",2
+"2007-01-02 19:00:00",2
+"2007-01-02 20:00:00",2
+"2007-01-02 21:00:00",2
+"2007-01-02 22:00:00",2
+"2007-01-02 23:00:00",2
+"2007-01-03 00:00:00",2
+"2007-01-03 01:00:00",3
+"2007-01-03 02:00:00",3
+"2007-01-03 03:00:00",3
+"2007-01-03 04:00:00",3
+"2007-01-03 05:00:00",3
+"2007-01-03 06:00:00",3
+"2007-01-03 07:00:00",3
+"2007-01-03 08:00:00",3
+"2007-01-03 09:00:00",3
+"2007-01-03 10:00:00",3
+"2007-01-03 11:00:00",3
+"2007-01-03 12:00:00",3
+"2007-01-03 13:00:00",3
+"2007-01-03 14:00:00",3
+"2007-01-03 15:00:00",3
+"2007-01-03 16:00:00",3
+"2007-01-03 17:00:00",3
+"2007-01-03 18:00:00",3
+"2007-01-03 19:00:00",3
+"2007-01-03 20:00:00",3
+"2007-01-03 21:00:00",3
+"2007-01-03 22:00:00",3
+"2007-01-03 23:00:00",3
+"2007-01-04 00:00:00",3
+"2007-01-04 01:00:00",4
+"2007-01-04 02:00:00",4
+"2007-01-04 03:00:00",4
+"2007-01-04 04:00:00",4
+"2007-01-04 05:00:00",4
+"2007-01-04 06:00:00",4
+"2007-01-04 07:00:00",4
+"2007-01-04 08:00:00",4
+"2007-01-04 09:00:00",4
+"2007-01-04 10:00:00",4
+"2007-01-04 11:00:00",4
+"2007-01-04 12:00:00",4
+"2007-01-04 13:00:00",4
+"2007-01-04 14:00:00",4
+"2007-01-04 15:00:00",4
+"2007-01-04 16:00:00",4
+"2007-01-04 17:00:00",4
+"2007-01-04 18:00:00",4
+"2007-01-04 19:00:00",4
+"2007-01-04 20:00:00",4
+"2007-01-04 21:00:00",4
+"2007-01-04 22:00:00",4
+"2007-01-04 23:00:00",4
+"2007-01-05 00:00:00",4
+"2007-01-05 01:00:00",5
+"2007-01-05 02:00:00",5
+"2007-01-05 03:00:00",5
+"2007-01-05 04:00:00",5
+"2007-01-05 05:00:00",5
+"2007-01-05 06:00:00",5
+"2007-01-05 07:00:00",5
+"2007-01-05 08:00:00",5
+"2007-01-05 09:00:00",5
+"2007-01-05 10:00:00",5
+"2007-01-05 11:00:00",5
+"2007-01-05 12:00:00",5
+"2007-01-05 13:00:00",5
+"2007-01-05 14:00:00",5
+"2007-01-05 15:00:00",5
+"2007-01-05 16:00:00",5
+"2007-01-05 17:00:00",5
+"2007-01-05 18:00:00",5
+"2007-01-05 19:00:00",5
+"2007-01-05 20:00:00",5
+"2007-01-05 21:00:00",5
+"2007-01-05 22:00:00",5
+"2007-01-05 23:00:00",5
+"2007-01-06 00:00:00",5
+"2007-01-06 01:00:00",6
+"2007-01-06 02:00:00",6
+"2007-01-06 03:00:00",6
+"2007-01-06 04:00:00",6
+"2007-01-06 05:00:00",6
+"2007-01-06 06:00:00",6
+"2007-01-06 07:00:00",6
+"2007-01-06 08:00:00",6
+"2007-01-06 09:00:00",6
+"2007-01-06 10:00:00",6
+"2007-01-06 11:00:00",6
+"2007-01-06 12:00:00",6
+"2007-01-06 13:00:00",6
+"2007-01-06 14:00:00",6
+"2007-01-06 15:00:00",6
+"2007-01-06 16:00:00",6
+"2007-01-06 17:00:00",6
+"2007-01-06 18:00:00",6
+"2007-01-06 19:00:00",6
+"2007-01-06 20:00:00",6
+"2007-01-06 21:00:00",6
+"2007-01-06 22:00:00",6
+"2007-01-06 23:00:00",6
+"2007-01-07 00:00:00",6
+"2007-01-07 01:00:00",7
+"2007-01-07 02:00:00",7
+"2007-01-07 03:00:00",7
+"2007-01-07 04:00:00",7
+"2007-01-07 05:00:00",7
+"2007-01-07 06:00:00",7
+"2007-01-07 07:00:00",7
+"2007-01-07 08:00:00",7
+"2007-01-07 09:00:00",7
+"2007-01-07 10:00:00",7
+"2007-01-07 11:00:00",7
+"2007-01-07 12:00:00",7
+"2007-01-07 13:00:00",7
+"2007-01-07 14:00:00",7
+"2007-01-07 15:00:00",7
+"2007-01-07 16:00:00",7
+"2007-01-07 17:00:00",7
+"2007-01-07 18:00:00",7
+"2007-01-07 19:00:00",7
+"2007-01-07 20:00:00",7
+"2007-01-07 21:00:00",7
+"2007-01-07 22:00:00",7
+"2007-01-07 23:00:00",7
+"2007-01-08 00:00:00",7
+"2007-01-08 01:00:00",1
+"2007-01-08 02:00:00",1
+"2007-01-08 03:00:00",1
+"2007-01-08 04:00:00",1
+"2007-01-08 05:00:00",1
+"2007-01-08 06:00:00",1
+"2007-01-08 07:00:00",1
+"2007-01-08 08:00:00",1
+"2007-01-08 09:00:00",1
+"2007-01-08 10:00:00",1
+"2007-01-08 11:00:00",1
+"2007-01-08 12:00:00",1
+"2007-01-08 13:00:00",1
+"2007-01-08 14:00:00",1
+"2007-01-08 15:00:00",1
+"2007-01-08 16:00:00",1
+"2007-01-08 17:00:00",1
+"2007-01-08 18:00:00",1
+"2007-01-08 19:00:00",1
+"2007-01-08 20:00:00",1
+"2007-01-08 21:00:00",1
+"2007-01-08 22:00:00",1
+"2007-01-08 23:00:00",1
+"2007-01-09 00:00:00",1
+"2007-01-09 01:00:00",2
+"2007-01-09 02:00:00",2
+"2007-01-09 03:00:00",2
+"2007-01-09 04:00:00",2
+"2007-01-09 05:00:00",2
+"2007-01-09 06:00:00",2
+"2007-01-09 07:00:00",2
+"2007-01-09 08:00:00",2
+"2007-01-09 09:00:00",2
+"2007-01-09 10:00:00",2
+"2007-01-09 11:00:00",2
+"2007-01-09 12:00:00",2
+"2007-01-09 13:00:00",2
+"2007-01-09 14:00:00",2
+"2007-01-09 15:00:00",2
+"2007-01-09 16:00:00",2
+"2007-01-09 17:00:00",2
+"2007-01-09 18:00:00",2
+"2007-01-09 19:00:00",2
+"2007-01-09 20:00:00",2
+"2007-01-09 21:00:00",2
+"2007-01-09 22:00:00",2
+"2007-01-09 23:00:00",2
+"2007-01-10 00:00:00",2
+"2007-01-10 01:00:00",3
+"2007-01-10 02:00:00",3
+"2007-01-10 03:00:00",3
+"2007-01-10 04:00:00",3
+"2007-01-10 05:00:00",3
+"2007-01-10 06:00:00",3
+"2007-01-10 07:00:00",3
+"2007-01-10 08:00:00",3
+"2007-01-10 09:00:00",3
+"2007-01-10 10:00:00",3
+"2007-01-10 11:00:00",3
+"2007-01-10 12:00:00",3
+"2007-01-10 13:00:00",3
+"2007-01-10 14:00:00",3
+"2007-01-10 15:00:00",3
+"2007-01-10 16:00:00",3
+"2007-01-10 17:00:00",3
+"2007-01-10 18:00:00",3
+"2007-01-10 19:00:00",3
+"2007-01-10 20:00:00",3
+"2007-01-10 21:00:00",3
+"2007-01-10 22:00:00",3
+"2007-01-10 23:00:00",3
+"2007-01-11 00:00:00",3
+"2007-01-11 01:00:00",4
+"2007-01-11 02:00:00",4
+"2007-01-11 03:00:00",4
+"2007-01-11 04:00:00",4
+"2007-01-11 05:00:00",4
+"2007-01-11 06:00:00",4
+"2007-01-11 07:00:00",4
+"2007-01-11 08:00:00",4
+"2007-01-11 09:00:00",4
+"2007-01-11 10:00:00",4
+"2007-01-11 11:00:00",4
+"2007-01-11 12:00:00",4
+"2007-01-11 13:00:00",4
+"2007-01-11 14:00:00",4
+"2007-01-11 15:00:00",4
+"2007-01-11 16:00:00",4
+"2007-01-11 17:00:00",4
+"2007-01-11 18:00:00",4
+"2007-01-11 19:00:00",4
+"2007-01-11 20:00:00",4
+"2007-01-11 21:00:00",4
+"2007-01-11 22:00:00",4
+"2007-01-11 23:00:00",4
+"2007-01-12 00:00:00",4
+"2007-01-12 01:00:00",5
+"2007-01-12 02:00:00",5
+"2007-01-12 03:00:00",5
+"2007-01-12 04:00:00",5
+"2007-01-12 05:00:00",5
+"2007-01-12 06:00:00",5
+"2007-01-12 07:00:00",5
+"2007-01-12 08:00:00",5
+"2007-01-12 09:00:00",5
+"2007-01-12 10:00:00",5
+"2007-01-12 11:00:00",5
+"2007-01-12 12:00:00",5
+"2007-01-12 13:00:00",5
+"2007-01-12 14:00:00",5
+"2007-01-12 15:00:00",5
+"2007-01-12 16:00:00",5
+"2007-01-12 17:00:00",5
+"2007-01-12 18:00:00",5
+"2007-01-12 19:00:00",5
+"2007-01-12 20:00:00",5
+"2007-01-12 21:00:00",5
+"2007-01-12 22:00:00",5
+"2007-01-12 23:00:00",5
+"2007-01-13 00:00:00",5
+"2007-01-13 01:00:00",6
+"2007-01-13 02:00:00",6
+"2007-01-13 03:00:00",6
+"2007-01-13 04:00:00",6
+"2007-01-13 05:00:00",6
+"2007-01-13 06:00:00",6
+"2007-01-13 07:00:00",6
+"2007-01-13 08:00:00",6
+"2007-01-13 09:00:00",6
+"2007-01-13 10:00:00",6
+"2007-01-13 11:00:00",6
+"2007-01-13 12:00:00",6
+"2007-01-13 13:00:00",6
+"2007-01-13 14:00:00",6
+"2007-01-13 15:00:00",6
+"2007-01-13 16:00:00",6
+"2007-01-13 17:00:00",6
+"2007-01-13 18:00:00",6
+"2007-01-13 19:00:00",6
+"2007-01-13 20:00:00",6
+"2007-01-13 21:00:00",6
+"2007-01-13 22:00:00",6
+"2007-01-13 23:00:00",6
+"2007-01-14 00:00:00",6
+"2007-01-14 01:00:00",7
+"2007-01-14 02:00:00",7
+"2007-01-14 03:00:00",7
+"2007-01-14 04:00:00",7
+"2007-01-14 05:00:00",7
+"2007-01-14 06:00:00",7
+"2007-01-14 07:00:00",7
+"2007-01-14 08:00:00",7
+"2007-01-14 09:00:00",7
+"2007-01-14 10:00:00",7
+"2007-01-14 11:00:00",7
+"2007-01-14 12:00:00",7
+"2007-01-14 13:00:00",7
+"2007-01-14 14:00:00",7
+"2007-01-14 15:00:00",7
+"2007-01-14 16:00:00",7
+"2007-01-14 17:00:00",7
+"2007-01-14 18:00:00",7
+"2007-01-14 19:00:00",7
+"2007-01-14 20:00:00",7
+"2007-01-14 21:00:00",7
+"2007-01-14 22:00:00",7
+"2007-01-14 23:00:00",7
+"2007-01-15 00:00:00",7
+"2007-01-15 01:00:00",1
+"2007-01-15 02:00:00",1
+"2007-01-15 03:00:00",1
+"2007-01-15 04:00:00",1
+"2007-01-15 05:00:00",1
+"2007-01-15 06:00:00",1
+"2007-01-15 07:00:00",1
+"2007-01-15 08:00:00",1
+"2007-01-15 09:00:00",1
+"2007-01-15 10:00:00",1
+"2007-01-15 11:00:00",1
+"2007-01-15 12:00:00",1
+"2007-01-15 13:00:00",1
+"2007-01-15 14:00:00",1
+"2007-01-15 15:00:00",1
+"2007-01-15 16:00:00",1
+"2007-01-15 17:00:00",1
+"2007-01-15 18:00:00",1
+"2007-01-15 19:00:00",1
+"2007-01-15 20:00:00",1
+"2007-01-15 21:00:00",1
+"2007-01-15 22:00:00",1
+"2007-01-15 23:00:00",1
+"2007-01-16 00:00:00",1
+"2007-01-16 01:00:00",2
+"2007-01-16 02:00:00",2
+"2007-01-16 03:00:00",2
+"2007-01-16 04:00:00",2
+"2007-01-16 05:00:00",2
+"2007-01-16 06:00:00",2
+"2007-01-16 07:00:00",2
+"2007-01-16 08:00:00",2
+"2007-01-16 09:00:00",2
+"2007-01-16 10:00:00",2
+"2007-01-16 11:00:00",2
+"2007-01-16 12:00:00",2
+"2007-01-16 13:00:00",2
+"2007-01-16 14:00:00",2
+"2007-01-16 15:00:00",2
+"2007-01-16 16:00:00",2
+"2007-01-16 17:00:00",2
+"2007-01-16 18:00:00",2
+"2007-01-16 19:00:00",2
+"2007-01-16 20:00:00",2
+"2007-01-16 21:00:00",2
+"2007-01-16 22:00:00",2
+"2007-01-16 23:00:00",2
+"2007-01-17 00:00:00",2
+"2007-01-17 01:00:00",3
+"2007-01-17 02:00:00",3
+"2007-01-17 03:00:00",3
+"2007-01-17 04:00:00",3
+"2007-01-17 05:00:00",3
+"2007-01-17 06:00:00",3
+"2007-01-17 07:00:00",3
+"2007-01-17 08:00:00",3
+"2007-01-17 09:00:00",3
+"2007-01-17 10:00:00",3
+"2007-01-17 11:00:00",3
+"2007-01-17 12:00:00",3
+"2007-01-17 13:00:00",3
+"2007-01-17 14:00:00",3
+"2007-01-17 15:00:00",3
+"2007-01-17 16:00:00",3
+"2007-01-17 17:00:00",3
+"2007-01-17 18:00:00",3
+"2007-01-17 19:00:00",3
+"2007-01-17 20:00:00",3
+"2007-01-17 21:00:00",3
+"2007-01-17 22:00:00",3
+"2007-01-17 23:00:00",3
+"2007-01-18 00:00:00",3
+"2007-01-18 01:00:00",4
+"2007-01-18 02:00:00",4
+"2007-01-18 03:00:00",4
+"2007-01-18 04:00:00",4
+"2007-01-18 05:00:00",4
+"2007-01-18 06:00:00",4
+"2007-01-18 07:00:00",4
+"2007-01-18 08:00:00",4
+"2007-01-18 09:00:00",4
+"2007-01-18 10:00:00",4
+"2007-01-18 11:00:00",4
+"2007-01-18 12:00:00",4
+"2007-01-18 13:00:00",4
+"2007-01-18 14:00:00",4
+"2007-01-18 15:00:00",4
+"2007-01-18 16:00:00",4
+"2007-01-18 17:00:00",4
+"2007-01-18 18:00:00",4
+"2007-01-18 19:00:00",4
+"2007-01-18 20:00:00",4
+"2007-01-18 21:00:00",4
+"2007-01-18 22:00:00",4
+"2007-01-18 23:00:00",4
+"2007-01-19 00:00:00",4
+"2007-01-19 01:00:00",5
+"2007-01-19 02:00:00",5
+"2007-01-19 03:00:00",5
+"2007-01-19 04:00:00",5
+"2007-01-19 05:00:00",5
+"2007-01-19 06:00:00",5
+"2007-01-19 07:00:00",5
+"2007-01-19 08:00:00",5
+"2007-01-19 09:00:00",5
+"2007-01-19 10:00:00",5
+"2007-01-19 11:00:00",5
+"2007-01-19 12:00:00",5
+"2007-01-19 13:00:00",5
+"2007-01-19 14:00:00",5
+"2007-01-19 15:00:00",5
+"2007-01-19 16:00:00",5
+"2007-01-19 17:00:00",5
+"2007-01-19 18:00:00",5
+"2007-01-19 19:00:00",5
+"2007-01-19 20:00:00",5
+"2007-01-19 21:00:00",5
+"2007-01-19 22:00:00",5
+"2007-01-19 23:00:00",5
+"2007-01-20 00:00:00",5
+"2007-01-20 01:00:00",6
+"2007-01-20 02:00:00",6
+"2007-01-20 03:00:00",6
+"2007-01-20 04:00:00",6
+"2007-01-20 05:00:00",6
+"2007-01-20 06:00:00",6
+"2007-01-20 07:00:00",6
+"2007-01-20 08:00:00",6
+"2007-01-20 09:00:00",6
+"2007-01-20 10:00:00",6
+"2007-01-20 11:00:00",6
+"2007-01-20 12:00:00",6
+"2007-01-20 13:00:00",6
+"2007-01-20 14:00:00",6
+"2007-01-20 15:00:00",6
+"2007-01-20 16:00:00",6
+"2007-01-20 17:00:00",6
+"2007-01-20 18:00:00",6
+"2007-01-20 19:00:00",6
+"2007-01-20 20:00:00",6
+"2007-01-20 21:00:00",6
+"2007-01-20 22:00:00",6
+"2007-01-20 23:00:00",6
+"2007-01-21 00:00:00",6
+"2007-01-21 01:00:00",7
+"2007-01-21 02:00:00",7
+"2007-01-21 03:00:00",7
+"2007-01-21 04:00:00",7
+"2007-01-21 05:00:00",7
+"2007-01-21 06:00:00",7
+"2007-01-21 07:00:00",7
+"2007-01-21 08:00:00",7
+"2007-01-21 09:00:00",7
+"2007-01-21 10:00:00",7
+"2007-01-21 11:00:00",7
+"2007-01-21 12:00:00",7
+"2007-01-21 13:00:00",7
+"2007-01-21 14:00:00",7
+"2007-01-21 15:00:00",7
+"2007-01-21 16:00:00",7
+"2007-01-21 17:00:00",7
+"2007-01-21 18:00:00",7
+"2007-01-21 19:00:00",7
+"2007-01-21 20:00:00",7
+"2007-01-21 21:00:00",7
+"2007-01-21 22:00:00",7
+"2007-01-21 23:00:00",7
+"2007-01-22 00:00:00",7
+"2007-01-22 01:00:00",1
+"2007-01-22 02:00:00",1
+"2007-01-22 03:00:00",1
+"2007-01-22 04:00:00",1
+"2007-01-22 05:00:00",1
+"2007-01-22 06:00:00",1
+"2007-01-22 07:00:00",1
+"2007-01-22 08:00:00",1
+"2007-01-22 09:00:00",1
+"2007-01-22 10:00:00",1
+"2007-01-22 11:00:00",1
+"2007-01-22 12:00:00",1
+"2007-01-22 13:00:00",1
+"2007-01-22 14:00:00",1
+"2007-01-22 15:00:00",1
+"2007-01-22 16:00:00",1
+"2007-01-22 17:00:00",1
+"2007-01-22 18:00:00",1
+"2007-01-22 19:00:00",1
+"2007-01-22 20:00:00",1
+"2007-01-22 21:00:00",1
+"2007-01-22 22:00:00",1
+"2007-01-22 23:00:00",1
+"2007-01-23 00:00:00",1
+"2007-01-23 01:00:00",2
+"2007-01-23 02:00:00",2
+"2007-01-23 03:00:00",2
+"2007-01-23 04:00:00",2
+"2007-01-23 05:00:00",2
+"2007-01-23 06:00:00",2
+"2007-01-23 07:00:00",2
+"2007-01-23 08:00:00",2
+"2007-01-23 09:00:00",2
+"2007-01-23 10:00:00",2
+"2007-01-23 11:00:00",2
+"2007-01-23 12:00:00",2
+"2007-01-23 13:00:00",2
+"2007-01-23 14:00:00",2
+"2007-01-23 15:00:00",2
+"2007-01-23 16:00:00",2
+"2007-01-23 17:00:00",2
+"2007-01-23 18:00:00",2
+"2007-01-23 19:00:00",2
+"2007-01-23 20:00:00",2
+"2007-01-23 21:00:00",2
+"2007-01-23 22:00:00",2
+"2007-01-23 23:00:00",2
+"2007-01-24 00:00:00",2
+"2007-01-24 01:00:00",3
+"2007-01-24 02:00:00",3
+"2007-01-24 03:00:00",3
+"2007-01-24 04:00:00",3
+"2007-01-24 05:00:00",3
+"2007-01-24 06:00:00",3
+"2007-01-24 07:00:00",3
+"2007-01-24 08:00:00",3
+"2007-01-24 09:00:00",3
+"2007-01-24 10:00:00",3
+"2007-01-24 11:00:00",3
+"2007-01-24 12:00:00",3
+"2007-01-24 13:00:00",3
+"2007-01-24 14:00:00",3
+"2007-01-24 15:00:00",3
+"2007-01-24 16:00:00",3
+"2007-01-24 17:00:00",3
+"2007-01-24 18:00:00",3
+"2007-01-24 19:00:00",3
+"2007-01-24 20:00:00",3
+"2007-01-24 21:00:00",3
+"2007-01-24 22:00:00",3
+"2007-01-24 23:00:00",3
+"2007-01-25 00:00:00",3
+"2007-01-25 01:00:00",4
+"2007-01-25 02:00:00",4
+"2007-01-25 03:00:00",4
+"2007-01-25 04:00:00",4
+"2007-01-25 05:00:00",4
+"2007-01-25 06:00:00",4
+"2007-01-25 07:00:00",4
+"2007-01-25 08:00:00",4
+"2007-01-25 09:00:00",4
+"2007-01-25 10:00:00",4
+"2007-01-25 11:00:00",4
+"2007-01-25 12:00:00",4
+"2007-01-25 13:00:00",4
+"2007-01-25 14:00:00",4
+"2007-01-25 15:00:00",4
+"2007-01-25 16:00:00",4
+"2007-01-25 17:00:00",4
+"2007-01-25 18:00:00",4
+"2007-01-25 19:00:00",4
+"2007-01-25 20:00:00",4
+"2007-01-25 21:00:00",4
+"2007-01-25 22:00:00",4
+"2007-01-25 23:00:00",4
+"2007-01-26 00:00:00",4
+"2007-01-26 01:00:00",5
+"2007-01-26 02:00:00",5
+"2007-01-26 03:00:00",5
+"2007-01-26 04:00:00",5
+"2007-01-26 05:00:00",5
+"2007-01-26 06:00:00",5
+"2007-01-26 07:00:00",5
+"2007-01-26 08:00:00",5
+"2007-01-26 09:00:00",5
+"2007-01-26 10:00:00",5
+"2007-01-26 11:00:00",5
+"2007-01-26 12:00:00",5
+"2007-01-26 13:00:00",5
+"2007-01-26 14:00:00",5
+"2007-01-26 15:00:00",5
+"2007-01-26 16:00:00",5
+"2007-01-26 17:00:00",5
+"2007-01-26 18:00:00",5
+"2007-01-26 19:00:00",5
+"2007-01-26 20:00:00",5
+"2007-01-26 21:00:00",5
+"2007-01-26 22:00:00",5
+"2007-01-26 23:00:00",5
+"2007-01-27 00:00:00",5
+"2007-01-27 01:00:00",6
+"2007-01-27 02:00:00",6
+"2007-01-27 03:00:00",6
+"2007-01-27 04:00:00",6
+"2007-01-27 05:00:00",6
+"2007-01-27 06:00:00",6
+"2007-01-27 07:00:00",6
+"2007-01-27 08:00:00",6
+"2007-01-27 09:00:00",6
+"2007-01-27 10:00:00",6
+"2007-01-27 11:00:00",6
+"2007-01-27 12:00:00",6
+"2007-01-27 13:00:00",6
+"2007-01-27 14:00:00",6
+"2007-01-27 15:00:00",6
+"2007-01-27 16:00:00",6
+"2007-01-27 17:00:00",6
+"2007-01-27 18:00:00",6
+"2007-01-27 19:00:00",6
+"2007-01-27 20:00:00",6
+"2007-01-27 21:00:00",6
+"2007-01-27 22:00:00",6
+"2007-01-27 23:00:00",6
+"2007-01-28 00:00:00",6
+"2007-01-28 01:00:00",7
+"2007-01-28 02:00:00",7
+"2007-01-28 03:00:00",7
+"2007-01-28 04:00:00",7
+"2007-01-28 05:00:00",7
+"2007-01-28 06:00:00",7
+"2007-01-28 07:00:00",7
+"2007-01-28 08:00:00",7
+"2007-01-28 09:00:00",7
+"2007-01-28 10:00:00",7
+"2007-01-28 11:00:00",7
+"2007-01-28 12:00:00",7
+"2007-01-28 13:00:00",7
+"2007-01-28 14:00:00",7
+"2007-01-28 15:00:00",7
+"2007-01-28 16:00:00",7
+"2007-01-28 17:00:00",7
+"2007-01-28 18:00:00",7
+"2007-01-28 19:00:00",7
+"2007-01-28 20:00:00",7
+"2007-01-28 21:00:00",7
+"2007-01-28 22:00:00",7
+"2007-01-28 23:00:00",7
+"2007-01-29 00:00:00",7
+"2007-01-29 01:00:00",1
+"2007-01-29 02:00:00",1
+"2007-01-29 03:00:00",1
+"2007-01-29 04:00:00",1
+"2007-01-29 05:00:00",1
+"2007-01-29 06:00:00",1
+"2007-01-29 07:00:00",1
+"2007-01-29 08:00:00",1
+"2007-01-29 09:00:00",1
+"2007-01-29 10:00:00",1
+"2007-01-29 11:00:00",1
+"2007-01-29 12:00:00",1
+"2007-01-29 13:00:00",1
+"2007-01-29 14:00:00",1
+"2007-01-29 15:00:00",1
+"2007-01-29 16:00:00",1
+"2007-01-29 17:00:00",1
+"2007-01-29 18:00:00",1
+"2007-01-29 19:00:00",1
+"2007-01-29 20:00:00",1
+"2007-01-29 21:00:00",1
+"2007-01-29 22:00:00",1
+"2007-01-29 23:00:00",1
+"2007-01-30 00:00:00",1
+"2007-01-30 01:00:00",2
+"2007-01-30 02:00:00",2
+"2007-01-30 03:00:00",2
+"2007-01-30 04:00:00",2
+"2007-01-30 05:00:00",2
+"2007-01-30 06:00:00",2
+"2007-01-30 07:00:00",2
+"2007-01-30 08:00:00",2
+"2007-01-30 09:00:00",2
+"2007-01-30 10:00:00",2
+"2007-01-30 11:00:00",2
+"2007-01-30 12:00:00",2
+"2007-01-30 13:00:00",2
+"2007-01-30 14:00:00",2
+"2007-01-30 15:00:00",2
+"2007-01-30 16:00:00",2
+"2007-01-30 17:00:00",2
+"2007-01-30 18:00:00",2
+"2007-01-30 19:00:00",2
+"2007-01-30 20:00:00",2
+"2007-01-30 21:00:00",2
+"2007-01-30 22:00:00",2
+"2007-01-30 23:00:00",2
+"2007-01-31 00:00:00",2
+"2007-01-31 01:00:00",3
+"2007-01-31 02:00:00",3
+"2007-01-31 03:00:00",3
+"2007-01-31 04:00:00",3
+"2007-01-31 05:00:00",3
+"2007-01-31 06:00:00",3
+"2007-01-31 07:00:00",3
+"2007-01-31 08:00:00",3
+"2007-01-31 09:00:00",3
+"2007-01-31 10:00:00",3
+"2007-01-31 11:00:00",3
+"2007-01-31 12:00:00",3
+"2007-01-31 13:00:00",3
+"2007-01-31 14:00:00",3
+"2007-01-31 15:00:00",3
+"2007-01-31 16:00:00",3
+"2007-01-31 17:00:00",3
+"2007-01-31 18:00:00",3
+"2007-01-31 19:00:00",3
+"2007-01-31 20:00:00",3
+"2007-01-31 21:00:00",3
+"2007-01-31 22:00:00",3
+"2007-01-31 23:00:00",3
+"2007-02-01 00:00:00",3
+"2007-02-01 01:00:00",4
+"2007-02-01 02:00:00",4
+"2007-02-01 03:00:00",4
+"2007-02-01 04:00:00",4
+"2007-02-01 05:00:00",4
+"2007-02-01 06:00:00",4
+"2007-02-01 07:00:00",4
+"2007-02-01 08:00:00",4
+"2007-02-01 09:00:00",4
+"2007-02-01 10:00:00",4
+"2007-02-01 11:00:00",4
+"2007-02-01 12:00:00",4
+"2007-02-01 13:00:00",4
+"2007-02-01 14:00:00",4
+"2007-02-01 15:00:00",4
+"2007-02-01 16:00:00",4
+"2007-02-01 17:00:00",4
+"2007-02-01 18:00:00",4
+"2007-02-01 19:00:00",4
+"2007-02-01 20:00:00",4
+"2007-02-01 21:00:00",4
+"2007-02-01 22:00:00",4
+"2007-02-01 23:00:00",4
+"2007-02-02 00:00:00",4
+"2007-02-02 01:00:00",5
+"2007-02-02 02:00:00",5
+"2007-02-02 03:00:00",5
+"2007-02-02 04:00:00",5
+"2007-02-02 05:00:00",5
+"2007-02-02 06:00:00",5
+"2007-02-02 07:00:00",5
+"2007-02-02 08:00:00",5
+"2007-02-02 09:00:00",5
+"2007-02-02 10:00:00",5
+"2007-02-02 11:00:00",5
+"2007-02-02 12:00:00",5
+"2007-02-02 13:00:00",5
+"2007-02-02 14:00:00",5
+"2007-02-02 15:00:00",5
+"2007-02-02 16:00:00",5
+"2007-02-02 17:00:00",5
+"2007-02-02 18:00:00",5
+"2007-02-02 19:00:00",5
+"2007-02-02 20:00:00",5
+"2007-02-02 21:00:00",5
+"2007-02-02 22:00:00",5
+"2007-02-02 23:00:00",5
+"2007-02-03 00:00:00",5
+"2007-02-03 01:00:00",6
+"2007-02-03 02:00:00",6
+"2007-02-03 03:00:00",6
+"2007-02-03 04:00:00",6
+"2007-02-03 05:00:00",6
+"2007-02-03 06:00:00",6
+"2007-02-03 07:00:00",6
+"2007-02-03 08:00:00",6
+"2007-02-03 09:00:00",6
+"2007-02-03 10:00:00",6
+"2007-02-03 11:00:00",6
+"2007-02-03 12:00:00",6
+"2007-02-03 13:00:00",6
+"2007-02-03 14:00:00",6
+"2007-02-03 15:00:00",6
+"2007-02-03 16:00:00",6
+"2007-02-03 17:00:00",6
+"2007-02-03 18:00:00",6
+"2007-02-03 19:00:00",6
+"2007-02-03 20:00:00",6
+"2007-02-03 21:00:00",6
+"2007-02-03 22:00:00",6
+"2007-02-03 23:00:00",6
+"2007-02-04 00:00:00",6
+"2007-02-04 01:00:00",7
+"2007-02-04 02:00:00",7
+"2007-02-04 03:00:00",7
+"2007-02-04 04:00:00",7
+"2007-02-04 05:00:00",7
+"2007-02-04 06:00:00",7
+"2007-02-04 07:00:00",7
+"2007-02-04 08:00:00",7
+"2007-02-04 09:00:00",7
+"2007-02-04 10:00:00",7
+"2007-02-04 11:00:00",7
+"2007-02-04 12:00:00",7
+"2007-02-04 13:00:00",7
+"2007-02-04 14:00:00",7
+"2007-02-04 15:00:00",7
+"2007-02-04 16:00:00",7
+"2007-02-04 17:00:00",7
+"2007-02-04 18:00:00",7
+"2007-02-04 19:00:00",7
+"2007-02-04 20:00:00",7
+"2007-02-04 21:00:00",7
+"2007-02-04 22:00:00",7
+"2007-02-04 23:00:00",7
+"2007-02-05 00:00:00",7
+"2007-02-05 01:00:00",1
+"2007-02-05 02:00:00",1
+"2007-02-05 03:00:00",1
+"2007-02-05 04:00:00",1
+"2007-02-05 05:00:00",1
+"2007-02-05 06:00:00",1
+"2007-02-05 07:00:00",1
+"2007-02-05 08:00:00",1
+"2007-02-05 09:00:00",1
+"2007-02-05 10:00:00",1
+"2007-02-05 11:00:00",1
+"2007-02-05 12:00:00",1
+"2007-02-05 13:00:00",1
+"2007-02-05 14:00:00",1
+"2007-02-05 15:00:00",1
+"2007-02-05 16:00:00",1
+"2007-02-05 17:00:00",1
+"2007-02-05 18:00:00",1
+"2007-02-05 19:00:00",1
+"2007-02-05 20:00:00",1
+"2007-02-05 21:00:00",1
+"2007-02-05 22:00:00",1
+"2007-02-05 23:00:00",1
+"2007-02-06 00:00:00",1
+"2007-02-06 01:00:00",2
+"2007-02-06 02:00:00",2
+"2007-02-06 03:00:00",2
+"2007-02-06 04:00:00",2
+"2007-02-06 05:00:00",2
+"2007-02-06 06:00:00",2
+"2007-02-06 07:00:00",2
+"2007-02-06 08:00:00",2
+"2007-02-06 09:00:00",2
+"2007-02-06 10:00:00",2
+"2007-02-06 11:00:00",2
+"2007-02-06 12:00:00",2
+"2007-02-06 13:00:00",2
+"2007-02-06 14:00:00",2
+"2007-02-06 15:00:00",2
+"2007-02-06 16:00:00",2
+"2007-02-06 17:00:00",2
+"2007-02-06 18:00:00",2
+"2007-02-06 19:00:00",2
+"2007-02-06 20:00:00",2
+"2007-02-06 21:00:00",2
+"2007-02-06 22:00:00",2
+"2007-02-06 23:00:00",2
+"2007-02-07 00:00:00",2
+"2007-02-07 01:00:00",3
+"2007-02-07 02:00:00",3
+"2007-02-07 03:00:00",3
+"2007-02-07 04:00:00",3
+"2007-02-07 05:00:00",3
+"2007-02-07 06:00:00",3
+"2007-02-07 07:00:00",3
+"2007-02-07 08:00:00",3
+"2007-02-07 09:00:00",3
+"2007-02-07 10:00:00",3
+"2007-02-07 11:00:00",3
+"2007-02-07 12:00:00",3
+"2007-02-07 13:00:00",3
+"2007-02-07 14:00:00",3
+"2007-02-07 15:00:00",3
+"2007-02-07 16:00:00",3
+"2007-02-07 17:00:00",3
+"2007-02-07 18:00:00",3
+"2007-02-07 19:00:00",3
+"2007-02-07 20:00:00",3
+"2007-02-07 21:00:00",3
+"2007-02-07 22:00:00",3
+"2007-02-07 23:00:00",3
+"2007-02-08 00:00:00",3
+"2007-02-08 01:00:00",4
+"2007-02-08 02:00:00",4
+"2007-02-08 03:00:00",4
+"2007-02-08 04:00:00",4
+"2007-02-08 05:00:00",4
+"2007-02-08 06:00:00",4
+"2007-02-08 07:00:00",4
+"2007-02-08 08:00:00",4
+"2007-02-08 09:00:00",4
+"2007-02-08 10:00:00",4
+"2007-02-08 11:00:00",4
+"2007-02-08 12:00:00",4
+"2007-02-08 13:00:00",4
+"2007-02-08 14:00:00",4
+"2007-02-08 15:00:00",4
+"2007-02-08 16:00:00",4
+"2007-02-08 17:00:00",4
+"2007-02-08 18:00:00",4
+"2007-02-08 19:00:00",4
+"2007-02-08 20:00:00",4
+"2007-02-08 21:00:00",4
+"2007-02-08 22:00:00",4
+"2007-02-08 23:00:00",4
+"2007-02-09 00:00:00",4
+"2007-02-09 01:00:00",5
+"2007-02-09 02:00:00",5
+"2007-02-09 03:00:00",5
+"2007-02-09 04:00:00",5
+"2007-02-09 05:00:00",5
+"2007-02-09 06:00:00",5
+"2007-02-09 07:00:00",5
+"2007-02-09 08:00:00",5
+"2007-02-09 09:00:00",5
+"2007-02-09 10:00:00",5
+"2007-02-09 11:00:00",5
+"2007-02-09 12:00:00",5
+"2007-02-09 13:00:00",5
+"2007-02-09 14:00:00",5
+"2007-02-09 15:00:00",5
+"2007-02-09 16:00:00",5
+"2007-02-09 17:00:00",5
+"2007-02-09 18:00:00",5
+"2007-02-09 19:00:00",5
+"2007-02-09 20:00:00",5
+"2007-02-09 21:00:00",5
+"2007-02-09 22:00:00",5
+"2007-02-09 23:00:00",5
+"2007-02-10 00:00:00",5
+"2007-02-10 01:00:00",6
+"2007-02-10 02:00:00",6
+"2007-02-10 03:00:00",6
+"2007-02-10 04:00:00",6
+"2007-02-10 05:00:00",6
+"2007-02-10 06:00:00",6
+"2007-02-10 07:00:00",6
+"2007-02-10 08:00:00",6
+"2007-02-10 09:00:00",6
+"2007-02-10 10:00:00",6
+"2007-02-10 11:00:00",6
+"2007-02-10 12:00:00",6
+"2007-02-10 13:00:00",6
+"2007-02-10 14:00:00",6
+"2007-02-10 15:00:00",6
+"2007-02-10 16:00:00",6
+"2007-02-10 17:00:00",6
+"2007-02-10 18:00:00",6
+"2007-02-10 19:00:00",6
+"2007-02-10 20:00:00",6
+"2007-02-10 21:00:00",6
+"2007-02-10 22:00:00",6
+"2007-02-10 23:00:00",6
+"2007-02-11 00:00:00",6
+"2007-02-11 01:00:00",7
+"2007-02-11 02:00:00",7
+"2007-02-11 03:00:00",7
+"2007-02-11 04:00:00",7
+"2007-02-11 05:00:00",7
+"2007-02-11 06:00:00",7
+"2007-02-11 07:00:00",7
+"2007-02-11 08:00:00",7
+"2007-02-11 09:00:00",7
+"2007-02-11 10:00:00",7
+"2007-02-11 11:00:00",7
+"2007-02-11 12:00:00",7
+"2007-02-11 13:00:00",7
+"2007-02-11 14:00:00",7
+"2007-02-11 15:00:00",7
+"2007-02-11 16:00:00",7
+"2007-02-11 17:00:00",7
+"2007-02-11 18:00:00",7
+"2007-02-11 19:00:00",7
+"2007-02-11 20:00:00",7
+"2007-02-11 21:00:00",7
+"2007-02-11 22:00:00",7
+"2007-02-11 23:00:00",7
+"2007-02-12 00:00:00",7
+"2007-02-12 01:00:00",1
+"2007-02-12 02:00:00",1
+"2007-02-12 03:00:00",1
+"2007-02-12 04:00:00",1
+"2007-02-12 05:00:00",1
+"2007-02-12 06:00:00",1
+"2007-02-12 07:00:00",1
+"2007-02-12 08:00:00",1
+"2007-02-12 09:00:00",1
+"2007-02-12 10:00:00",1
+"2007-02-12 11:00:00",1
+"2007-02-12 12:00:00",1
+"2007-02-12 13:00:00",1
+"2007-02-12 14:00:00",1
+"2007-02-12 15:00:00",1
+"2007-02-12 16:00:00",1
+"2007-02-12 17:00:00",1
+"2007-02-12 18:00:00",1
+"2007-02-12 19:00:00",1
+"2007-02-12 20:00:00",1
+"2007-02-12 21:00:00",1
+"2007-02-12 22:00:00",1
+"2007-02-12 23:00:00",1
+"2007-02-13 00:00:00",1
+"2007-02-13 01:00:00",2
+"2007-02-13 02:00:00",2
+"2007-02-13 03:00:00",2
+"2007-02-13 04:00:00",2
+"2007-02-13 05:00:00",2
+"2007-02-13 06:00:00",2
+"2007-02-13 07:00:00",2
+"2007-02-13 08:00:00",2
+"2007-02-13 09:00:00",2
+"2007-02-13 10:00:00",2
+"2007-02-13 11:00:00",2
+"2007-02-13 12:00:00",2
+"2007-02-13 13:00:00",2
+"2007-02-13 14:00:00",2
+"2007-02-13 15:00:00",2
+"2007-02-13 16:00:00",2
+"2007-02-13 17:00:00",2
+"2007-02-13 18:00:00",2
+"2007-02-13 19:00:00",2
+"2007-02-13 20:00:00",2
+"2007-02-13 21:00:00",2
+"2007-02-13 22:00:00",2
+"2007-02-13 23:00:00",2
+"2007-02-14 00:00:00",2
+"2007-02-14 01:00:00",3
+"2007-02-14 02:00:00",3
+"2007-02-14 03:00:00",3
+"2007-02-14 04:00:00",3
+"2007-02-14 05:00:00",3
+"2007-02-14 06:00:00",3
+"2007-02-14 07:00:00",3
+"2007-02-14 08:00:00",3
+"2007-02-14 09:00:00",3
+"2007-02-14 10:00:00",3
+"2007-02-14 11:00:00",3
+"2007-02-14 12:00:00",3
+"2007-02-14 13:00:00",3
+"2007-02-14 14:00:00",3
+"2007-02-14 15:00:00",3
+"2007-02-14 16:00:00",3
+"2007-02-14 17:00:00",3
+"2007-02-14 18:00:00",3
+"2007-02-14 19:00:00",3
+"2007-02-14 20:00:00",3
+"2007-02-14 21:00:00",3
+"2007-02-14 22:00:00",3
+"2007-02-14 23:00:00",3
+"2007-02-15 00:00:00",3
+"2007-02-15 01:00:00",4
+"2007-02-15 02:00:00",4
+"2007-02-15 03:00:00",4
+"2007-02-15 04:00:00",4
+"2007-02-15 05:00:00",4
+"2007-02-15 06:00:00",4
+"2007-02-15 07:00:00",4
+"2007-02-15 08:00:00",4
+"2007-02-15 09:00:00",4
+"2007-02-15 10:00:00",4
+"2007-02-15 11:00:00",4
+"2007-02-15 12:00:00",4
+"2007-02-15 13:00:00",4
+"2007-02-15 14:00:00",4
+"2007-02-15 15:00:00",4
+"2007-02-15 16:00:00",4
+"2007-02-15 17:00:00",4
+"2007-02-15 18:00:00",4
+"2007-02-15 19:00:00",4
+"2007-02-15 20:00:00",4
+"2007-02-15 21:00:00",4
+"2007-02-15 22:00:00",4
+"2007-02-15 23:00:00",4
+"2007-02-16 00:00:00",4
+"2007-02-16 01:00:00",5
+"2007-02-16 02:00:00",5
+"2007-02-16 03:00:00",5
+"2007-02-16 04:00:00",5
+"2007-02-16 05:00:00",5
+"2007-02-16 06:00:00",5
+"2007-02-16 07:00:00",5
+"2007-02-16 08:00:00",5
+"2007-02-16 09:00:00",5
+"2007-02-16 10:00:00",5
+"2007-02-16 11:00:00",5
+"2007-02-16 12:00:00",5
+"2007-02-16 13:00:00",5
+"2007-02-16 14:00:00",5
+"2007-02-16 15:00:00",5
+"2007-02-16 16:00:00",5
+"2007-02-16 17:00:00",5
+"2007-02-16 18:00:00",5
+"2007-02-16 19:00:00",5
+"2007-02-16 20:00:00",5
+"2007-02-16 21:00:00",5
+"2007-02-16 22:00:00",5
+"2007-02-16 23:00:00",5
+"2007-02-17 00:00:00",5
+"2007-02-17 01:00:00",6
+"2007-02-17 02:00:00",6
+"2007-02-17 03:00:00",6
+"2007-02-17 04:00:00",6
+"2007-02-17 05:00:00",6
+"2007-02-17 06:00:00",6
+"2007-02-17 07:00:00",6
+"2007-02-17 08:00:00",6
+"2007-02-17 09:00:00",6
+"2007-02-17 10:00:00",6
+"2007-02-17 11:00:00",6
+"2007-02-17 12:00:00",6
+"2007-02-17 13:00:00",6
+"2007-02-17 14:00:00",6
+"2007-02-17 15:00:00",6
+"2007-02-17 16:00:00",6
+"2007-02-17 17:00:00",6
+"2007-02-17 18:00:00",6
+"2007-02-17 19:00:00",6
+"2007-02-17 20:00:00",6
+"2007-02-17 21:00:00",6
+"2007-02-17 22:00:00",6
+"2007-02-17 23:00:00",6
+"2007-02-18 00:00:00",6
+"2007-02-18 01:00:00",7
+"2007-02-18 02:00:00",7
+"2007-02-18 03:00:00",7
+"2007-02-18 04:00:00",7
+"2007-02-18 05:00:00",7
+"2007-02-18 06:00:00",7
+"2007-02-18 07:00:00",7
+"2007-02-18 08:00:00",7
+"2007-02-18 09:00:00",7
+"2007-02-18 10:00:00",7
+"2007-02-18 11:00:00",7
+"2007-02-18 12:00:00",7
+"2007-02-18 13:00:00",7
+"2007-02-18 14:00:00",7
+"2007-02-18 15:00:00",7
+"2007-02-18 16:00:00",7
+"2007-02-18 17:00:00",7
+"2007-02-18 18:00:00",7
+"2007-02-18 19:00:00",7
+"2007-02-18 20:00:00",7
+"2007-02-18 21:00:00",7
+"2007-02-18 22:00:00",7
+"2007-02-18 23:00:00",7
+"2007-02-19 00:00:00",7
+"2007-02-19 01:00:00",1
+"2007-02-19 02:00:00",1
+"2007-02-19 03:00:00",1
+"2007-02-19 04:00:00",1
+"2007-02-19 05:00:00",1
+"2007-02-19 06:00:00",1
+"2007-02-19 07:00:00",1
+"2007-02-19 08:00:00",1
+"2007-02-19 09:00:00",1
+"2007-02-19 10:00:00",1
+"2007-02-19 11:00:00",1
+"2007-02-19 12:00:00",1
+"2007-02-19 13:00:00",1
+"2007-02-19 14:00:00",1
+"2007-02-19 15:00:00",1
+"2007-02-19 16:00:00",1
+"2007-02-19 17:00:00",1
+"2007-02-19 18:00:00",1
+"2007-02-19 19:00:00",1
+"2007-02-19 20:00:00",1
+"2007-02-19 21:00:00",1
+"2007-02-19 22:00:00",1
+"2007-02-19 23:00:00",1
+"2007-02-20 00:00:00",1
+"2007-02-20 01:00:00",2
+"2007-02-20 02:00:00",2
+"2007-02-20 03:00:00",2
+"2007-02-20 04:00:00",2
+"2007-02-20 05:00:00",2
+"2007-02-20 06:00:00",2
+"2007-02-20 07:00:00",2
+"2007-02-20 08:00:00",2
+"2007-02-20 09:00:00",2
+"2007-02-20 10:00:00",2
+"2007-02-20 11:00:00",2
+"2007-02-20 12:00:00",2
+"2007-02-20 13:00:00",2
+"2007-02-20 14:00:00",2
+"2007-02-20 15:00:00",2
+"2007-02-20 16:00:00",2
+"2007-02-20 17:00:00",2
+"2007-02-20 18:00:00",2
+"2007-02-20 19:00:00",2
+"2007-02-20 20:00:00",2
+"2007-02-20 21:00:00",2
+"2007-02-20 22:00:00",2
+"2007-02-20 23:00:00",2
+"2007-02-21 00:00:00",2
+"2007-02-21 01:00:00",3
+"2007-02-21 02:00:00",3
+"2007-02-21 03:00:00",3
+"2007-02-21 04:00:00",3
+"2007-02-21 05:00:00",3
+"2007-02-21 06:00:00",3
+"2007-02-21 07:00:00",3
+"2007-02-21 08:00:00",3
+"2007-02-21 09:00:00",3
+"2007-02-21 10:00:00",3
+"2007-02-21 11:00:00",3
+"2007-02-21 12:00:00",3
+"2007-02-21 13:00:00",3
+"2007-02-21 14:00:00",3
+"2007-02-21 15:00:00",3
+"2007-02-21 16:00:00",3
+"2007-02-21 17:00:00",3
+"2007-02-21 18:00:00",3
+"2007-02-21 19:00:00",3
+"2007-02-21 20:00:00",3
+"2007-02-21 21:00:00",3
+"2007-02-21 22:00:00",3
+"2007-02-21 23:00:00",3
+"2007-02-22 00:00:00",3
+"2007-02-22 01:00:00",4
+"2007-02-22 02:00:00",4
+"2007-02-22 03:00:00",4
+"2007-02-22 04:00:00",4
+"2007-02-22 05:00:00",4
+"2007-02-22 06:00:00",4
+"2007-02-22 07:00:00",4
+"2007-02-22 08:00:00",4
+"2007-02-22 09:00:00",4
+"2007-02-22 10:00:00",4
+"2007-02-22 11:00:00",4
+"2007-02-22 12:00:00",4
+"2007-02-22 13:00:00",4
+"2007-02-22 14:00:00",4
+"2007-02-22 15:00:00",4
+"2007-02-22 16:00:00",4
+"2007-02-22 17:00:00",4
+"2007-02-22 18:00:00",4
+"2007-02-22 19:00:00",4
+"2007-02-22 20:00:00",4
+"2007-02-22 21:00:00",4
+"2007-02-22 22:00:00",4
+"2007-02-22 23:00:00",4
+"2007-02-23 00:00:00",4
+"2007-02-23 01:00:00",5
+"2007-02-23 02:00:00",5
+"2007-02-23 03:00:00",5
+"2007-02-23 04:00:00",5
+"2007-02-23 05:00:00",5
+"2007-02-23 06:00:00",5
+"2007-02-23 07:00:00",5
+"2007-02-23 08:00:00",5
+"2007-02-23 09:00:00",5
+"2007-02-23 10:00:00",5
+"2007-02-23 11:00:00",5
+"2007-02-23 12:00:00",5
+"2007-02-23 13:00:00",5
+"2007-02-23 14:00:00",5
+"2007-02-23 15:00:00",5
+"2007-02-23 16:00:00",5
+"2007-02-23 17:00:00",5
+"2007-02-23 18:00:00",5
+"2007-02-23 19:00:00",5
+"2007-02-23 20:00:00",5
+"2007-02-23 21:00:00",5
+"2007-02-23 22:00:00",5
+"2007-02-23 23:00:00",5
+"2007-02-24 00:00:00",5
+"2007-02-24 01:00:00",6
+"2007-02-24 02:00:00",6
+"2007-02-24 03:00:00",6
+"2007-02-24 04:00:00",6
+"2007-02-24 05:00:00",6
+"2007-02-24 06:00:00",6
+"2007-02-24 07:00:00",6
+"2007-02-24 08:00:00",6
+"2007-02-24 09:00:00",6
+"2007-02-24 10:00:00",6
+"2007-02-24 11:00:00",6
+"2007-02-24 12:00:00",6
+"2007-02-24 13:00:00",6
+"2007-02-24 14:00:00",6
+"2007-02-24 15:00:00",6
+"2007-02-24 16:00:00",6
+"2007-02-24 17:00:00",6
+"2007-02-24 18:00:00",6
+"2007-02-24 19:00:00",6
+"2007-02-24 20:00:00",6
+"2007-02-24 21:00:00",6
+"2007-02-24 22:00:00",6
+"2007-02-24 23:00:00",6
+"2007-02-25 00:00:00",6
+"2007-02-25 01:00:00",7
+"2007-02-25 02:00:00",7
+"2007-02-25 03:00:00",7
+"2007-02-25 04:00:00",7
+"2007-02-25 05:00:00",7
+"2007-02-25 06:00:00",7
+"2007-02-25 07:00:00",7
+"2007-02-25 08:00:00",7
+"2007-02-25 09:00:00",7
+"2007-02-25 10:00:00",7
+"2007-02-25 11:00:00",7
+"2007-02-25 12:00:00",7
+"2007-02-25 13:00:00",7
+"2007-02-25 14:00:00",7
+"2007-02-25 15:00:00",7
+"2007-02-25 16:00:00",7
+"2007-02-25 17:00:00",7
+"2007-02-25 18:00:00",7
+"2007-02-25 19:00:00",7
+"2007-02-25 20:00:00",7
+"2007-02-25 21:00:00",7
+"2007-02-25 22:00:00",7
+"2007-02-25 23:00:00",7
+"2007-02-26 00:00:00",7
+"2007-02-26 01:00:00",1
+"2007-02-26 02:00:00",1
+"2007-02-26 03:00:00",1
+"2007-02-26 04:00:00",1
+"2007-02-26 05:00:00",1
+"2007-02-26 06:00:00",1
+"2007-02-26 07:00:00",1
+"2007-02-26 08:00:00",1
+"2007-02-26 09:00:00",1
+"2007-02-26 10:00:00",1
+"2007-02-26 11:00:00",1
+"2007-02-26 12:00:00",1
+"2007-02-26 13:00:00",1
+"2007-02-26 14:00:00",1
+"2007-02-26 15:00:00",1
+"2007-02-26 16:00:00",1
+"2007-02-26 17:00:00",1
+"2007-02-26 18:00:00",1
+"2007-02-26 19:00:00",1
+"2007-02-26 20:00:00",1
+"2007-02-26 21:00:00",1
+"2007-02-26 22:00:00",1
+"2007-02-26 23:00:00",1
+"2007-02-27 00:00:00",1
+"2007-02-27 01:00:00",2
+"2007-02-27 02:00:00",2
+"2007-02-27 03:00:00",2
+"2007-02-27 04:00:00",2
+"2007-02-27 05:00:00",2
+"2007-02-27 06:00:00",2
+"2007-02-27 07:00:00",2
+"2007-02-27 08:00:00",2
+"2007-02-27 09:00:00",2
+"2007-02-27 10:00:00",2
+"2007-02-27 11:00:00",2
+"2007-02-27 12:00:00",2
+"2007-02-27 13:00:00",2
+"2007-02-27 14:00:00",2
+"2007-02-27 15:00:00",2
+"2007-02-27 16:00:00",2
+"2007-02-27 17:00:00",2
+"2007-02-27 18:00:00",2
+"2007-02-27 19:00:00",2
+"2007-02-27 20:00:00",2
+"2007-02-27 21:00:00",2
+"2007-02-27 22:00:00",2
+"2007-02-27 23:00:00",2
+"2007-02-28 00:00:00",2
+"2007-02-28 01:00:00",3
+"2007-02-28 02:00:00",3
+"2007-02-28 03:00:00",3
+"2007-02-28 04:00:00",3
+"2007-02-28 05:00:00",3
+"2007-02-28 06:00:00",3
+"2007-02-28 07:00:00",3
+"2007-02-28 08:00:00",3
+"2007-02-28 09:00:00",3
+"2007-02-28 10:00:00",3
+"2007-02-28 11:00:00",3
+"2007-02-28 12:00:00",3
+"2007-02-28 13:00:00",3
+"2007-02-28 14:00:00",3
+"2007-02-28 15:00:00",3
+"2007-02-28 16:00:00",3
+"2007-02-28 17:00:00",3
+"2007-02-28 18:00:00",3
+"2007-02-28 19:00:00",3
+"2007-02-28 20:00:00",3
+"2007-02-28 21:00:00",3
+"2007-02-28 22:00:00",3
+"2007-02-28 23:00:00",3
+"2007-03-01 00:00:00",3
+"2007-03-01 01:00:00",4
+"2007-03-01 02:00:00",4
+"2007-03-01 03:00:00",4
+"2007-03-01 04:00:00",4
+"2007-03-01 05:00:00",4
+"2007-03-01 06:00:00",4
+"2007-03-01 07:00:00",4
+"2007-03-01 08:00:00",4
+"2007-03-01 09:00:00",4
+"2007-03-01 10:00:00",4
+"2007-03-01 11:00:00",4
+"2007-03-01 12:00:00",4
+"2007-03-01 13:00:00",4
+"2007-03-01 14:00:00",4
+"2007-03-01 15:00:00",4
+"2007-03-01 16:00:00",4
+"2007-03-01 17:00:00",4
+"2007-03-01 18:00:00",4
+"2007-03-01 19:00:00",4
+"2007-03-01 20:00:00",4
+"2007-03-01 21:00:00",4
+"2007-03-01 22:00:00",4
+"2007-03-01 23:00:00",4
+"2007-03-02 00:00:00",4
+"2007-03-02 01:00:00",5
+"2007-03-02 02:00:00",5
+"2007-03-02 03:00:00",5
+"2007-03-02 04:00:00",5
+"2007-03-02 05:00:00",5
+"2007-03-02 06:00:00",5
+"2007-03-02 07:00:00",5
+"2007-03-02 08:00:00",5
+"2007-03-02 09:00:00",5
+"2007-03-02 10:00:00",5
+"2007-03-02 11:00:00",5
+"2007-03-02 12:00:00",5
+"2007-03-02 13:00:00",5
+"2007-03-02 14:00:00",5
+"2007-03-02 15:00:00",5
+"2007-03-02 16:00:00",5
+"2007-03-02 17:00:00",5
+"2007-03-02 18:00:00",5
+"2007-03-02 19:00:00",5
+"2007-03-02 20:00:00",5
+"2007-03-02 21:00:00",5
+"2007-03-02 22:00:00",5
+"2007-03-02 23:00:00",5
+"2007-03-03 00:00:00",5
+"2007-03-03 01:00:00",6
+"2007-03-03 02:00:00",6
+"2007-03-03 03:00:00",6
+"2007-03-03 04:00:00",6
+"2007-03-03 05:00:00",6
+"2007-03-03 06:00:00",6
+"2007-03-03 07:00:00",6
+"2007-03-03 08:00:00",6
+"2007-03-03 09:00:00",6
+"2007-03-03 10:00:00",6
+"2007-03-03 11:00:00",6
+"2007-03-03 12:00:00",6
+"2007-03-03 13:00:00",6
+"2007-03-03 14:00:00",6
+"2007-03-03 15:00:00",6
+"2007-03-03 16:00:00",6
+"2007-03-03 17:00:00",6
+"2007-03-03 18:00:00",6
+"2007-03-03 19:00:00",6
+"2007-03-03 20:00:00",6
+"2007-03-03 21:00:00",6
+"2007-03-03 22:00:00",6
+"2007-03-03 23:00:00",6
+"2007-03-04 00:00:00",6
+"2007-03-04 01:00:00",7
+"2007-03-04 02:00:00",7
+"2007-03-04 03:00:00",7
+"2007-03-04 04:00:00",7
+"2007-03-04 05:00:00",7
+"2007-03-04 06:00:00",7
+"2007-03-04 07:00:00",7
+"2007-03-04 08:00:00",7
+"2007-03-04 09:00:00",7
+"2007-03-04 10:00:00",7
+"2007-03-04 11:00:00",7
+"2007-03-04 12:00:00",7
+"2007-03-04 13:00:00",7
+"2007-03-04 14:00:00",7
+"2007-03-04 15:00:00",7
+"2007-03-04 16:00:00",7
+"2007-03-04 17:00:00",7
+"2007-03-04 18:00:00",7
+"2007-03-04 19:00:00",7
+"2007-03-04 20:00:00",7
+"2007-03-04 21:00:00",7
+"2007-03-04 22:00:00",7
+"2007-03-04 23:00:00",7
+"2007-03-05 00:00:00",7
+"2007-03-05 01:00:00",1
+"2007-03-05 02:00:00",1
+"2007-03-05 03:00:00",1
+"2007-03-05 04:00:00",1
+"2007-03-05 05:00:00",1
+"2007-03-05 06:00:00",1
+"2007-03-05 07:00:00",1
+"2007-03-05 08:00:00",1
+"2007-03-05 09:00:00",1
+"2007-03-05 10:00:00",1
+"2007-03-05 11:00:00",1
+"2007-03-05 12:00:00",1
+"2007-03-05 13:00:00",1
+"2007-03-05 14:00:00",1
+"2007-03-05 15:00:00",1
+"2007-03-05 16:00:00",1
+"2007-03-05 17:00:00",1
+"2007-03-05 18:00:00",1
+"2007-03-05 19:00:00",1
+"2007-03-05 20:00:00",1
+"2007-03-05 21:00:00",1
+"2007-03-05 22:00:00",1
+"2007-03-05 23:00:00",1
+"2007-03-06 00:00:00",1
+"2007-03-06 01:00:00",2
+"2007-03-06 02:00:00",2
+"2007-03-06 03:00:00",2
+"2007-03-06 04:00:00",2
+"2007-03-06 05:00:00",2
+"2007-03-06 06:00:00",2
+"2007-03-06 07:00:00",2
+"2007-03-06 08:00:00",2
+"2007-03-06 09:00:00",2
+"2007-03-06 10:00:00",2
+"2007-03-06 11:00:00",2
+"2007-03-06 12:00:00",2
+"2007-03-06 13:00:00",2
+"2007-03-06 14:00:00",2
+"2007-03-06 15:00:00",2
+"2007-03-06 16:00:00",2
+"2007-03-06 17:00:00",2
+"2007-03-06 18:00:00",2
+"2007-03-06 19:00:00",2
+"2007-03-06 20:00:00",2
+"2007-03-06 21:00:00",2
+"2007-03-06 22:00:00",2
+"2007-03-06 23:00:00",2
+"2007-03-07 00:00:00",2
+"2007-03-07 01:00:00",3
+"2007-03-07 02:00:00",3
+"2007-03-07 03:00:00",3
+"2007-03-07 04:00:00",3
+"2007-03-07 05:00:00",3
+"2007-03-07 06:00:00",3
+"2007-03-07 07:00:00",3
+"2007-03-07 08:00:00",3
+"2007-03-07 09:00:00",3
+"2007-03-07 10:00:00",3
+"2007-03-07 11:00:00",3
+"2007-03-07 12:00:00",3
+"2007-03-07 13:00:00",3
+"2007-03-07 14:00:00",3
+"2007-03-07 15:00:00",3
+"2007-03-07 16:00:00",3
+"2007-03-07 17:00:00",3
+"2007-03-07 18:00:00",3
+"2007-03-07 19:00:00",3
+"2007-03-07 20:00:00",3
+"2007-03-07 21:00:00",3
+"2007-03-07 22:00:00",3
+"2007-03-07 23:00:00",3
+"2007-03-08 00:00:00",3
+"2007-03-08 01:00:00",4
+"2007-03-08 02:00:00",4
+"2007-03-08 03:00:00",4
+"2007-03-08 04:00:00",4
+"2007-03-08 05:00:00",4
+"2007-03-08 06:00:00",4
+"2007-03-08 07:00:00",4
+"2007-03-08 08:00:00",4
+"2007-03-08 09:00:00",4
+"2007-03-08 10:00:00",4
+"2007-03-08 11:00:00",4
+"2007-03-08 12:00:00",4
+"2007-03-08 13:00:00",4
+"2007-03-08 14:00:00",4
+"2007-03-08 15:00:00",4
+"2007-03-08 16:00:00",4
+"2007-03-08 17:00:00",4
+"2007-03-08 18:00:00",4
+"2007-03-08 19:00:00",4
+"2007-03-08 20:00:00",4
+"2007-03-08 21:00:00",4
+"2007-03-08 22:00:00",4
+"2007-03-08 23:00:00",4
+"2007-03-09 00:00:00",4
+"2007-03-09 01:00:00",5
+"2007-03-09 02:00:00",5
+"2007-03-09 03:00:00",5
+"2007-03-09 04:00:00",5
+"2007-03-09 05:00:00",5
+"2007-03-09 06:00:00",5
+"2007-03-09 07:00:00",5
+"2007-03-09 08:00:00",5
+"2007-03-09 09:00:00",5
+"2007-03-09 10:00:00",5
+"2007-03-09 11:00:00",5
+"2007-03-09 12:00:00",5
+"2007-03-09 13:00:00",5
+"2007-03-09 14:00:00",5
+"2007-03-09 15:00:00",5
+"2007-03-09 16:00:00",5
+"2007-03-09 17:00:00",5
+"2007-03-09 18:00:00",5
+"2007-03-09 19:00:00",5
+"2007-03-09 20:00:00",5
+"2007-03-09 21:00:00",5
+"2007-03-09 22:00:00",5
+"2007-03-09 23:00:00",5
+"2007-03-10 00:00:00",5
+"2007-03-10 01:00:00",6
+"2007-03-10 02:00:00",6
+"2007-03-10 03:00:00",6
+"2007-03-10 04:00:00",6
+"2007-03-10 05:00:00",6
+"2007-03-10 06:00:00",6
+"2007-03-10 07:00:00",6
+"2007-03-10 08:00:00",6
+"2007-03-10 09:00:00",6
+"2007-03-10 10:00:00",6
+"2007-03-10 11:00:00",6
+"2007-03-10 12:00:00",6
+"2007-03-10 13:00:00",6
+"2007-03-10 14:00:00",6
+"2007-03-10 15:00:00",6
+"2007-03-10 16:00:00",6
+"2007-03-10 17:00:00",6
+"2007-03-10 18:00:00",6
+"2007-03-10 19:00:00",6
+"2007-03-10 20:00:00",6
+"2007-03-10 21:00:00",6
+"2007-03-10 22:00:00",6
+"2007-03-10 23:00:00",6
+"2007-03-11 00:00:00",6
+"2007-03-11 01:00:00",7
+"2007-03-11 02:00:00",7
+"2007-03-11 03:00:00",7
+"2007-03-11 04:00:00",7
+"2007-03-11 05:00:00",7
+"2007-03-11 06:00:00",7
+"2007-03-11 07:00:00",7
+"2007-03-11 08:00:00",7
+"2007-03-11 09:00:00",7
+"2007-03-11 10:00:00",7
+"2007-03-11 11:00:00",7
+"2007-03-11 12:00:00",7
+"2007-03-11 13:00:00",7
+"2007-03-11 14:00:00",7
+"2007-03-11 15:00:00",7
+"2007-03-11 16:00:00",7
+"2007-03-11 17:00:00",7
+"2007-03-11 18:00:00",7
+"2007-03-11 19:00:00",7
+"2007-03-11 20:00:00",7
+"2007-03-11 21:00:00",7
+"2007-03-11 22:00:00",7
+"2007-03-11 23:00:00",7
+"2007-03-12 00:00:00",7
+"2007-03-12 01:00:00",1
+"2007-03-12 02:00:00",1
+"2007-03-12 03:00:00",1
+"2007-03-12 04:00:00",1
+"2007-03-12 05:00:00",1
+"2007-03-12 06:00:00",1
+"2007-03-12 07:00:00",1
+"2007-03-12 08:00:00",1
+"2007-03-12 09:00:00",1
+"2007-03-12 10:00:00",1
+"2007-03-12 11:00:00",1
+"2007-03-12 12:00:00",1
+"2007-03-12 13:00:00",1
+"2007-03-12 14:00:00",1
+"2007-03-12 15:00:00",1
+"2007-03-12 16:00:00",1
+"2007-03-12 17:00:00",1
+"2007-03-12 18:00:00",1
+"2007-03-12 19:00:00",1
+"2007-03-12 20:00:00",1
+"2007-03-12 21:00:00",1
+"2007-03-12 22:00:00",1
+"2007-03-12 23:00:00",1
+"2007-03-13 00:00:00",1
+"2007-03-13 01:00:00",2
+"2007-03-13 02:00:00",2
+"2007-03-13 03:00:00",2
+"2007-03-13 04:00:00",2
+"2007-03-13 05:00:00",2
+"2007-03-13 06:00:00",2
+"2007-03-13 07:00:00",2
+"2007-03-13 08:00:00",2
+"2007-03-13 09:00:00",2
+"2007-03-13 10:00:00",2
+"2007-03-13 11:00:00",2
+"2007-03-13 12:00:00",2
+"2007-03-13 13:00:00",2
+"2007-03-13 14:00:00",2
+"2007-03-13 15:00:00",2
+"2007-03-13 16:00:00",2
+"2007-03-13 17:00:00",2
+"2007-03-13 18:00:00",2
+"2007-03-13 19:00:00",2
+"2007-03-13 20:00:00",2
+"2007-03-13 21:00:00",2
+"2007-03-13 22:00:00",2
+"2007-03-13 23:00:00",2
+"2007-03-14 00:00:00",2
+"2007-03-14 01:00:00",3
+"2007-03-14 02:00:00",3
+"2007-03-14 03:00:00",3
+"2007-03-14 04:00:00",3
+"2007-03-14 05:00:00",3
+"2007-03-14 06:00:00",3
+"2007-03-14 07:00:00",3
+"2007-03-14 08:00:00",3
+"2007-03-14 09:00:00",3
+"2007-03-14 10:00:00",3
+"2007-03-14 11:00:00",3
+"2007-03-14 12:00:00",3
+"2007-03-14 13:00:00",3
+"2007-03-14 14:00:00",3
+"2007-03-14 15:00:00",3
+"2007-03-14 16:00:00",3
+"2007-03-14 17:00:00",3
+"2007-03-14 18:00:00",3
+"2007-03-14 19:00:00",3
+"2007-03-14 20:00:00",3
+"2007-03-14 21:00:00",3
+"2007-03-14 22:00:00",3
+"2007-03-14 23:00:00",3
+"2007-03-15 00:00:00",3
+"2007-03-15 01:00:00",4
+"2007-03-15 02:00:00",4
+"2007-03-15 03:00:00",4
+"2007-03-15 04:00:00",4
+"2007-03-15 05:00:00",4
+"2007-03-15 06:00:00",4
+"2007-03-15 07:00:00",4
+"2007-03-15 08:00:00",4
+"2007-03-15 09:00:00",4
+"2007-03-15 10:00:00",4
+"2007-03-15 11:00:00",4
+"2007-03-15 12:00:00",4
+"2007-03-15 13:00:00",4
+"2007-03-15 14:00:00",4
+"2007-03-15 15:00:00",4
+"2007-03-15 16:00:00",4
+"2007-03-15 17:00:00",4
+"2007-03-15 18:00:00",4
+"2007-03-15 19:00:00",4
+"2007-03-15 20:00:00",4
+"2007-03-15 21:00:00",4
+"2007-03-15 22:00:00",4
+"2007-03-15 23:00:00",4
+"2007-03-16 00:00:00",4
+"2007-03-16 01:00:00",5
+"2007-03-16 02:00:00",5
+"2007-03-16 03:00:00",5
+"2007-03-16 04:00:00",5
+"2007-03-16 05:00:00",5
+"2007-03-16 06:00:00",5
+"2007-03-16 07:00:00",5
+"2007-03-16 08:00:00",5
+"2007-03-16 09:00:00",5
+"2007-03-16 10:00:00",5
+"2007-03-16 11:00:00",5
+"2007-03-16 12:00:00",5
+"2007-03-16 13:00:00",5
+"2007-03-16 14:00:00",5
+"2007-03-16 15:00:00",5
+"2007-03-16 16:00:00",5
+"2007-03-16 17:00:00",5
+"2007-03-16 18:00:00",5
+"2007-03-16 19:00:00",5
+"2007-03-16 20:00:00",5
+"2007-03-16 21:00:00",5
+"2007-03-16 22:00:00",5
+"2007-03-16 23:00:00",5
+"2007-03-17 00:00:00",5
+"2007-03-17 01:00:00",6
+"2007-03-17 02:00:00",6
+"2007-03-17 03:00:00",6
+"2007-03-17 04:00:00",6
+"2007-03-17 05:00:00",6
+"2007-03-17 06:00:00",6
+"2007-03-17 07:00:00",6
+"2007-03-17 08:00:00",6
+"2007-03-17 09:00:00",6
+"2007-03-17 10:00:00",6
+"2007-03-17 11:00:00",6
+"2007-03-17 12:00:00",6
+"2007-03-17 13:00:00",6
+"2007-03-17 14:00:00",6
+"2007-03-17 15:00:00",6
+"2007-03-17 16:00:00",6
+"2007-03-17 17:00:00",6
+"2007-03-17 18:00:00",6
+"2007-03-17 19:00:00",6
+"2007-03-17 20:00:00",6
+"2007-03-17 21:00:00",6
+"2007-03-17 22:00:00",6
+"2007-03-17 23:00:00",6
+"2007-03-18 00:00:00",6
+"2007-03-18 01:00:00",7
+"2007-03-18 02:00:00",7
+"2007-03-18 03:00:00",7
+"2007-03-18 04:00:00",7
+"2007-03-18 05:00:00",7
+"2007-03-18 06:00:00",7
+"2007-03-18 07:00:00",7
+"2007-03-18 08:00:00",7
+"2007-03-18 09:00:00",7
+"2007-03-18 10:00:00",7
+"2007-03-18 11:00:00",7
+"2007-03-18 12:00:00",7
+"2007-03-18 13:00:00",7
+"2007-03-18 14:00:00",7
+"2007-03-18 15:00:00",7
+"2007-03-18 16:00:00",7
+"2007-03-18 17:00:00",7
+"2007-03-18 18:00:00",7
+"2007-03-18 19:00:00",7
+"2007-03-18 20:00:00",7
+"2007-03-18 21:00:00",7
+"2007-03-18 22:00:00",7
+"2007-03-18 23:00:00",7
+"2007-03-19 00:00:00",7
+"2007-03-19 01:00:00",1
+"2007-03-19 02:00:00",1
+"2007-03-19 03:00:00",1
+"2007-03-19 04:00:00",1
+"2007-03-19 05:00:00",1
+"2007-03-19 06:00:00",1
+"2007-03-19 07:00:00",1
+"2007-03-19 08:00:00",1
+"2007-03-19 09:00:00",1
+"2007-03-19 10:00:00",1
+"2007-03-19 11:00:00",1
+"2007-03-19 12:00:00",1
+"2007-03-19 13:00:00",1
+"2007-03-19 14:00:00",1
+"2007-03-19 15:00:00",1
+"2007-03-19 16:00:00",1
+"2007-03-19 17:00:00",1
+"2007-03-19 18:00:00",1
+"2007-03-19 19:00:00",1
+"2007-03-19 20:00:00",1
+"2007-03-19 21:00:00",1
+"2007-03-19 22:00:00",1
+"2007-03-19 23:00:00",1
+"2007-03-20 00:00:00",1
+"2007-03-20 01:00:00",2
+"2007-03-20 02:00:00",2
+"2007-03-20 03:00:00",2
+"2007-03-20 04:00:00",2
+"2007-03-20 05:00:00",2
+"2007-03-20 06:00:00",2
+"2007-03-20 07:00:00",2
+"2007-03-20 08:00:00",2
+"2007-03-20 09:00:00",2
+"2007-03-20 10:00:00",2
+"2007-03-20 11:00:00",2
+"2007-03-20 12:00:00",2
+"2007-03-20 13:00:00",2
+"2007-03-20 14:00:00",2
+"2007-03-20 15:00:00",2
+"2007-03-20 16:00:00",2
+"2007-03-20 17:00:00",2
+"2007-03-20 18:00:00",2
+"2007-03-20 19:00:00",2
+"2007-03-20 20:00:00",2
+"2007-03-20 21:00:00",2
+"2007-03-20 22:00:00",2
+"2007-03-20 23:00:00",2
+"2007-03-21 00:00:00",2
+"2007-03-21 01:00:00",3
+"2007-03-21 02:00:00",3
+"2007-03-21 03:00:00",3
+"2007-03-21 04:00:00",3
+"2007-03-21 05:00:00",3
+"2007-03-21 06:00:00",3
+"2007-03-21 07:00:00",3
+"2007-03-21 08:00:00",3
+"2007-03-21 09:00:00",3
+"2007-03-21 10:00:00",3
+"2007-03-21 11:00:00",3
+"2007-03-21 12:00:00",3
+"2007-03-21 13:00:00",3
+"2007-03-21 14:00:00",3
+"2007-03-21 15:00:00",3
+"2007-03-21 16:00:00",3
+"2007-03-21 17:00:00",3
+"2007-03-21 18:00:00",3
+"2007-03-21 19:00:00",3
+"2007-03-21 20:00:00",3
+"2007-03-21 21:00:00",3
+"2007-03-21 22:00:00",3
+"2007-03-21 23:00:00",3
+"2007-03-22 00:00:00",3
+"2007-03-22 01:00:00",4
+"2007-03-22 02:00:00",4
+"2007-03-22 03:00:00",4
+"2007-03-22 04:00:00",4
+"2007-03-22 05:00:00",4
+"2007-03-22 06:00:00",4
+"2007-03-22 07:00:00",4
+"2007-03-22 08:00:00",4
+"2007-03-22 09:00:00",4
+"2007-03-22 10:00:00",4
+"2007-03-22 11:00:00",4
+"2007-03-22 12:00:00",4
+"2007-03-22 13:00:00",4
+"2007-03-22 14:00:00",4
+"2007-03-22 15:00:00",4
+"2007-03-22 16:00:00",4
+"2007-03-22 17:00:00",4
+"2007-03-22 18:00:00",4
+"2007-03-22 19:00:00",4
+"2007-03-22 20:00:00",4
+"2007-03-22 21:00:00",4
+"2007-03-22 22:00:00",4
+"2007-03-22 23:00:00",4
+"2007-03-23 00:00:00",4
+"2007-03-23 01:00:00",5
+"2007-03-23 02:00:00",5
+"2007-03-23 03:00:00",5
+"2007-03-23 04:00:00",5
+"2007-03-23 05:00:00",5
+"2007-03-23 06:00:00",5
+"2007-03-23 07:00:00",5
+"2007-03-23 08:00:00",5
+"2007-03-23 09:00:00",5
+"2007-03-23 10:00:00",5
+"2007-03-23 11:00:00",5
+"2007-03-23 12:00:00",5
+"2007-03-23 13:00:00",5
+"2007-03-23 14:00:00",5
+"2007-03-23 15:00:00",5
+"2007-03-23 16:00:00",5
+"2007-03-23 17:00:00",5
+"2007-03-23 18:00:00",5
+"2007-03-23 19:00:00",5
+"2007-03-23 20:00:00",5
+"2007-03-23 21:00:00",5
+"2007-03-23 22:00:00",5
+"2007-03-23 23:00:00",5
+"2007-03-24 00:00:00",5
+"2007-03-24 01:00:00",6
+"2007-03-24 02:00:00",6
+"2007-03-24 03:00:00",6
+"2007-03-24 04:00:00",6
+"2007-03-24 05:00:00",6
+"2007-03-24 06:00:00",6
+"2007-03-24 07:00:00",6
+"2007-03-24 08:00:00",6
+"2007-03-24 09:00:00",6
+"2007-03-24 10:00:00",6
+"2007-03-24 11:00:00",6
+"2007-03-24 12:00:00",6
+"2007-03-24 13:00:00",6
+"2007-03-24 14:00:00",6
+"2007-03-24 15:00:00",6
+"2007-03-24 16:00:00",6
+"2007-03-24 17:00:00",6
+"2007-03-24 18:00:00",6
+"2007-03-24 19:00:00",6
+"2007-03-24 20:00:00",6
+"2007-03-24 21:00:00",6
+"2007-03-24 22:00:00",6
+"2007-03-24 23:00:00",6
+"2007-03-25 00:00:00",6
+"2007-03-25 01:00:00",7
+"2007-03-25 02:00:00",7
+"2007-03-25 03:00:00",7
+"2007-03-25 04:00:00",7
+"2007-03-25 05:00:00",7
+"2007-03-25 06:00:00",7
+"2007-03-25 07:00:00",7
+"2007-03-25 08:00:00",7
+"2007-03-25 09:00:00",7
+"2007-03-25 10:00:00",7
+"2007-03-25 11:00:00",7
+"2007-03-25 12:00:00",7
+"2007-03-25 13:00:00",7
+"2007-03-25 14:00:00",7
+"2007-03-25 15:00:00",7
+"2007-03-25 16:00:00",7
+"2007-03-25 17:00:00",7
+"2007-03-25 18:00:00",7
+"2007-03-25 19:00:00",7
+"2007-03-25 20:00:00",7
+"2007-03-25 21:00:00",7
+"2007-03-25 22:00:00",7
+"2007-03-25 23:00:00",7
+"2007-03-26 00:00:00",7
+"2007-03-26 01:00:00",1
+"2007-03-26 02:00:00",1
+"2007-03-26 03:00:00",1
+"2007-03-26 04:00:00",1
+"2007-03-26 05:00:00",1
+"2007-03-26 06:00:00",1
+"2007-03-26 07:00:00",1
+"2007-03-26 08:00:00",1
+"2007-03-26 09:00:00",1
+"2007-03-26 10:00:00",1
+"2007-03-26 11:00:00",1
+"2007-03-26 12:00:00",1
+"2007-03-26 13:00:00",1
+"2007-03-26 14:00:00",1
+"2007-03-26 15:00:00",1
+"2007-03-26 16:00:00",1
+"2007-03-26 17:00:00",1
+"2007-03-26 18:00:00",1
+"2007-03-26 19:00:00",1
+"2007-03-26 20:00:00",1
+"2007-03-26 21:00:00",1
+"2007-03-26 22:00:00",1
+"2007-03-26 23:00:00",1
+"2007-03-27 00:00:00",1
+"2007-03-27 01:00:00",2
+"2007-03-27 02:00:00",2
+"2007-03-27 03:00:00",2
+"2007-03-27 04:00:00",2
+"2007-03-27 05:00:00",2
+"2007-03-27 06:00:00",2
+"2007-03-27 07:00:00",2
+"2007-03-27 08:00:00",2
+"2007-03-27 09:00:00",2
+"2007-03-27 10:00:00",2
+"2007-03-27 11:00:00",2
+"2007-03-27 12:00:00",2
+"2007-03-27 13:00:00",2
+"2007-03-27 14:00:00",2
+"2007-03-27 15:00:00",2
+"2007-03-27 16:00:00",2
+"2007-03-27 17:00:00",2
+"2007-03-27 18:00:00",2
+"2007-03-27 19:00:00",2
+"2007-03-27 20:00:00",2
+"2007-03-27 21:00:00",2
+"2007-03-27 22:00:00",2
+"2007-03-27 23:00:00",2
+"2007-03-28 00:00:00",2
+"2007-03-28 01:00:00",3
+"2007-03-28 02:00:00",3
+"2007-03-28 03:00:00",3
+"2007-03-28 04:00:00",3
+"2007-03-28 05:00:00",3
+"2007-03-28 06:00:00",3
+"2007-03-28 07:00:00",3
+"2007-03-28 08:00:00",3
+"2007-03-28 09:00:00",3
+"2007-03-28 10:00:00",3
+"2007-03-28 11:00:00",3
+"2007-03-28 12:00:00",3
+"2007-03-28 13:00:00",3
+"2007-03-28 14:00:00",3
+"2007-03-28 15:00:00",3
+"2007-03-28 16:00:00",3
+"2007-03-28 17:00:00",3
+"2007-03-28 18:00:00",3
+"2007-03-28 19:00:00",3
+"2007-03-28 20:00:00",3
+"2007-03-28 21:00:00",3
+"2007-03-28 22:00:00",3
+"2007-03-28 23:00:00",3
+"2007-03-29 00:00:00",3
+"2007-03-29 01:00:00",4
+"2007-03-29 02:00:00",4
+"2007-03-29 03:00:00",4
+"2007-03-29 04:00:00",4
+"2007-03-29 05:00:00",4
+"2007-03-29 06:00:00",4
+"2007-03-29 07:00:00",4
+"2007-03-29 08:00:00",4
+"2007-03-29 09:00:00",4
+"2007-03-29 10:00:00",4
+"2007-03-29 11:00:00",4
+"2007-03-29 12:00:00",4
+"2007-03-29 13:00:00",4
+"2007-03-29 14:00:00",4
+"2007-03-29 15:00:00",4
+"2007-03-29 16:00:00",4
+"2007-03-29 17:00:00",4
+"2007-03-29 18:00:00",4
+"2007-03-29 19:00:00",4
+"2007-03-29 20:00:00",4
+"2007-03-29 21:00:00",4
+"2007-03-29 22:00:00",4
+"2007-03-29 23:00:00",4
+"2007-03-30 00:00:00",4
+"2007-03-30 01:00:00",5
+"2007-03-30 02:00:00",5
+"2007-03-30 03:00:00",5
+"2007-03-30 04:00:00",5
+"2007-03-30 05:00:00",5
+"2007-03-30 06:00:00",5
+"2007-03-30 07:00:00",5
+"2007-03-30 08:00:00",5
+"2007-03-30 09:00:00",5
+"2007-03-30 10:00:00",5
+"2007-03-30 11:00:00",5
+"2007-03-30 12:00:00",5
+"2007-03-30 13:00:00",5
+"2007-03-30 14:00:00",5
+"2007-03-30 15:00:00",5
+"2007-03-30 16:00:00",5
+"2007-03-30 17:00:00",5
+"2007-03-30 18:00:00",5
+"2007-03-30 19:00:00",5
+"2007-03-30 20:00:00",5
+"2007-03-30 21:00:00",5
+"2007-03-30 22:00:00",5
+"2007-03-30 23:00:00",5
+"2007-03-31 00:00:00",5
+"2007-03-31 01:00:00",6
+"2007-03-31 02:00:00",6
+"2007-03-31 03:00:00",6
+"2007-03-31 04:00:00",6
+"2007-03-31 05:00:00",6
+"2007-03-31 06:00:00",6
+"2007-03-31 07:00:00",6
+"2007-03-31 08:00:00",6
+"2007-03-31 09:00:00",6
+"2007-03-31 10:00:00",6
+"2007-03-31 11:00:00",6
+"2007-03-31 12:00:00",6
+"2007-03-31 13:00:00",6
+"2007-03-31 14:00:00",6
+"2007-03-31 15:00:00",6
+"2007-03-31 16:00:00",6
+"2007-03-31 17:00:00",6
+"2007-03-31 18:00:00",6
+"2007-03-31 19:00:00",6
+"2007-03-31 20:00:00",6
+"2007-03-31 21:00:00",6
+"2007-03-31 22:00:00",6
+"2007-03-31 23:00:00",6
+"2007-04-01 00:00:00",6
+"2007-04-01 01:00:00",7
+"2007-04-01 02:00:00",7
+"2007-04-01 03:00:00",7
+"2007-04-01 04:00:00",7
+"2007-04-01 05:00:00",7
+"2007-04-01 06:00:00",7
+"2007-04-01 07:00:00",7
+"2007-04-01 08:00:00",7
+"2007-04-01 09:00:00",7
+"2007-04-01 10:00:00",7
+"2007-04-01 11:00:00",7
+"2007-04-01 12:00:00",7
+"2007-04-01 13:00:00",7
+"2007-04-01 14:00:00",7
+"2007-04-01 15:00:00",7
+"2007-04-01 16:00:00",7
+"2007-04-01 17:00:00",7
+"2007-04-01 18:00:00",7
+"2007-04-01 19:00:00",7
+"2007-04-01 20:00:00",7
+"2007-04-01 21:00:00",7
+"2007-04-01 22:00:00",7
+"2007-04-01 23:00:00",7
+"2007-04-02 00:00:00",7
+"2007-04-02 01:00:00",1
+"2007-04-02 02:00:00",1
+"2007-04-02 03:00:00",1
+"2007-04-02 04:00:00",1
+"2007-04-02 05:00:00",1
+"2007-04-02 06:00:00",1
+"2007-04-02 07:00:00",1
+"2007-04-02 08:00:00",1
+"2007-04-02 09:00:00",1
+"2007-04-02 10:00:00",1
+"2007-04-02 11:00:00",1
+"2007-04-02 12:00:00",1
+"2007-04-02 13:00:00",1
+"2007-04-02 14:00:00",1
+"2007-04-02 15:00:00",1
+"2007-04-02 16:00:00",1
+"2007-04-02 17:00:00",1
+"2007-04-02 18:00:00",1
+"2007-04-02 19:00:00",1
+"2007-04-02 20:00:00",1
+"2007-04-02 21:00:00",1
+"2007-04-02 22:00:00",1
+"2007-04-02 23:00:00",1
+"2007-04-03 00:00:00",1
+"2007-04-03 01:00:00",2
+"2007-04-03 02:00:00",2
+"2007-04-03 03:00:00",2
+"2007-04-03 04:00:00",2
+"2007-04-03 05:00:00",2
+"2007-04-03 06:00:00",2
+"2007-04-03 07:00:00",2
+"2007-04-03 08:00:00",2
+"2007-04-03 09:00:00",2
+"2007-04-03 10:00:00",2
+"2007-04-03 11:00:00",2
+"2007-04-03 12:00:00",2
+"2007-04-03 13:00:00",2
+"2007-04-03 14:00:00",2
+"2007-04-03 15:00:00",2
+"2007-04-03 16:00:00",2
+"2007-04-03 17:00:00",2
+"2007-04-03 18:00:00",2
+"2007-04-03 19:00:00",2
+"2007-04-03 20:00:00",2
+"2007-04-03 21:00:00",2
+"2007-04-03 22:00:00",2
+"2007-04-03 23:00:00",2
+"2007-04-04 00:00:00",2
+"2007-04-04 01:00:00",3
+"2007-04-04 02:00:00",3
+"2007-04-04 03:00:00",3
+"2007-04-04 04:00:00",3
+"2007-04-04 05:00:00",3
+"2007-04-04 06:00:00",3
+"2007-04-04 07:00:00",3
+"2007-04-04 08:00:00",3
+"2007-04-04 09:00:00",3
+"2007-04-04 10:00:00",3
+"2007-04-04 11:00:00",3
+"2007-04-04 12:00:00",3
+"2007-04-04 13:00:00",3
+"2007-04-04 14:00:00",3
+"2007-04-04 15:00:00",3
+"2007-04-04 16:00:00",3
+"2007-04-04 17:00:00",3
+"2007-04-04 18:00:00",3
+"2007-04-04 19:00:00",3
+"2007-04-04 20:00:00",3
+"2007-04-04 21:00:00",3
+"2007-04-04 22:00:00",3
+"2007-04-04 23:00:00",3
+"2007-04-05 00:00:00",3
+"2007-04-05 01:00:00",4
+"2007-04-05 02:00:00",4
+"2007-04-05 03:00:00",4
+"2007-04-05 04:00:00",4
+"2007-04-05 05:00:00",4
+"2007-04-05 06:00:00",4
+"2007-04-05 07:00:00",4
+"2007-04-05 08:00:00",4
+"2007-04-05 09:00:00",4
+"2007-04-05 10:00:00",4
+"2007-04-05 11:00:00",4
+"2007-04-05 12:00:00",4
+"2007-04-05 13:00:00",4
+"2007-04-05 14:00:00",4
+"2007-04-05 15:00:00",4
+"2007-04-05 16:00:00",4
+"2007-04-05 17:00:00",4
+"2007-04-05 18:00:00",4
+"2007-04-05 19:00:00",4
+"2007-04-05 20:00:00",4
+"2007-04-05 21:00:00",4
+"2007-04-05 22:00:00",4
+"2007-04-05 23:00:00",4
+"2007-04-06 00:00:00",4
+"2007-04-06 01:00:00",5
+"2007-04-06 02:00:00",5
+"2007-04-06 03:00:00",5
+"2007-04-06 04:00:00",5
+"2007-04-06 05:00:00",5
+"2007-04-06 06:00:00",5
+"2007-04-06 07:00:00",5
+"2007-04-06 08:00:00",5
+"2007-04-06 09:00:00",5
+"2007-04-06 10:00:00",5
+"2007-04-06 11:00:00",5
+"2007-04-06 12:00:00",5
+"2007-04-06 13:00:00",5
+"2007-04-06 14:00:00",5
+"2007-04-06 15:00:00",5
+"2007-04-06 16:00:00",5
+"2007-04-06 17:00:00",5
+"2007-04-06 18:00:00",5
+"2007-04-06 19:00:00",5
+"2007-04-06 20:00:00",5
+"2007-04-06 21:00:00",5
+"2007-04-06 22:00:00",5
+"2007-04-06 23:00:00",5
+"2007-04-07 00:00:00",5
+"2007-04-07 01:00:00",6
+"2007-04-07 02:00:00",6
+"2007-04-07 03:00:00",6
+"2007-04-07 04:00:00",6
+"2007-04-07 05:00:00",6
+"2007-04-07 06:00:00",6
+"2007-04-07 07:00:00",6
+"2007-04-07 08:00:00",6
+"2007-04-07 09:00:00",6
+"2007-04-07 10:00:00",6
+"2007-04-07 11:00:00",6
+"2007-04-07 12:00:00",6
+"2007-04-07 13:00:00",6
+"2007-04-07 14:00:00",6
+"2007-04-07 15:00:00",6
+"2007-04-07 16:00:00",6
+"2007-04-07 17:00:00",6
+"2007-04-07 18:00:00",6
+"2007-04-07 19:00:00",6
+"2007-04-07 20:00:00",6
+"2007-04-07 21:00:00",6
+"2007-04-07 22:00:00",6
+"2007-04-07 23:00:00",6
+"2007-04-08 00:00:00",6
+"2007-04-08 01:00:00",7
+"2007-04-08 02:00:00",7
+"2007-04-08 03:00:00",7
+"2007-04-08 04:00:00",7
+"2007-04-08 05:00:00",7
+"2007-04-08 06:00:00",7
+"2007-04-08 07:00:00",7
+"2007-04-08 08:00:00",7
+"2007-04-08 09:00:00",7
+"2007-04-08 10:00:00",7
+"2007-04-08 11:00:00",7
+"2007-04-08 12:00:00",7
+"2007-04-08 13:00:00",7
+"2007-04-08 14:00:00",7
+"2007-04-08 15:00:00",7
+"2007-04-08 16:00:00",7
+"2007-04-08 17:00:00",7
+"2007-04-08 18:00:00",7
+"2007-04-08 19:00:00",7
+"2007-04-08 20:00:00",7
+"2007-04-08 21:00:00",7
+"2007-04-08 22:00:00",7
+"2007-04-08 23:00:00",7
+"2007-04-09 00:00:00",7
+"2007-04-09 01:00:00",1
+"2007-04-09 02:00:00",1
+"2007-04-09 03:00:00",1
+"2007-04-09 04:00:00",1
+"2007-04-09 05:00:00",1
+"2007-04-09 06:00:00",1
+"2007-04-09 07:00:00",1
+"2007-04-09 08:00:00",1
+"2007-04-09 09:00:00",1
+"2007-04-09 10:00:00",1
+"2007-04-09 11:00:00",1
+"2007-04-09 12:00:00",1
+"2007-04-09 13:00:00",1
+"2007-04-09 14:00:00",1
+"2007-04-09 15:00:00",1
+"2007-04-09 16:00:00",1
+"2007-04-09 17:00:00",1
+"2007-04-09 18:00:00",1
+"2007-04-09 19:00:00",1
+"2007-04-09 20:00:00",1
+"2007-04-09 21:00:00",1
+"2007-04-09 22:00:00",1
+"2007-04-09 23:00:00",1
+"2007-04-10 00:00:00",1
+"2007-04-10 01:00:00",2
+"2007-04-10 02:00:00",2
+"2007-04-10 03:00:00",2
+"2007-04-10 04:00:00",2
+"2007-04-10 05:00:00",2
+"2007-04-10 06:00:00",2
+"2007-04-10 07:00:00",2
+"2007-04-10 08:00:00",2
+"2007-04-10 09:00:00",2
+"2007-04-10 10:00:00",2
+"2007-04-10 11:00:00",2
+"2007-04-10 12:00:00",2
+"2007-04-10 13:00:00",2
+"2007-04-10 14:00:00",2
+"2007-04-10 15:00:00",2
+"2007-04-10 16:00:00",2
+"2007-04-10 17:00:00",2
+"2007-04-10 18:00:00",2
+"2007-04-10 19:00:00",2
+"2007-04-10 20:00:00",2
+"2007-04-10 21:00:00",2
+"2007-04-10 22:00:00",2
+"2007-04-10 23:00:00",2
+"2007-04-11 00:00:00",2
+"2007-04-11 01:00:00",3
+"2007-04-11 02:00:00",3
+"2007-04-11 03:00:00",3
+"2007-04-11 04:00:00",3
+"2007-04-11 05:00:00",3
+"2007-04-11 06:00:00",3
+"2007-04-11 07:00:00",3
+"2007-04-11 08:00:00",3
+"2007-04-11 09:00:00",3
+"2007-04-11 10:00:00",3
+"2007-04-11 11:00:00",3
+"2007-04-11 12:00:00",3
+"2007-04-11 13:00:00",3
+"2007-04-11 14:00:00",3
+"2007-04-11 15:00:00",3
+"2007-04-11 16:00:00",3
+"2007-04-11 17:00:00",3
+"2007-04-11 18:00:00",3
+"2007-04-11 19:00:00",3
+"2007-04-11 20:00:00",3
+"2007-04-11 21:00:00",3
+"2007-04-11 22:00:00",3
+"2007-04-11 23:00:00",3
+"2007-04-12 00:00:00",3
+"2007-04-12 01:00:00",4
+"2007-04-12 02:00:00",4
+"2007-04-12 03:00:00",4
+"2007-04-12 04:00:00",4
+"2007-04-12 05:00:00",4
+"2007-04-12 06:00:00",4
+"2007-04-12 07:00:00",4
+"2007-04-12 08:00:00",4
+"2007-04-12 09:00:00",4
+"2007-04-12 10:00:00",4
+"2007-04-12 11:00:00",4
+"2007-04-12 12:00:00",4
+"2007-04-12 13:00:00",4
+"2007-04-12 14:00:00",4
+"2007-04-12 15:00:00",4
+"2007-04-12 16:00:00",4
+"2007-04-12 17:00:00",4
+"2007-04-12 18:00:00",4
+"2007-04-12 19:00:00",4
+"2007-04-12 20:00:00",4
+"2007-04-12 21:00:00",4
+"2007-04-12 22:00:00",4
+"2007-04-12 23:00:00",4
+"2007-04-13 00:00:00",4
+"2007-04-13 01:00:00",5
+"2007-04-13 02:00:00",5
+"2007-04-13 03:00:00",5
+"2007-04-13 04:00:00",5
+"2007-04-13 05:00:00",5
+"2007-04-13 06:00:00",5
+"2007-04-13 07:00:00",5
+"2007-04-13 08:00:00",5
+"2007-04-13 09:00:00",5
+"2007-04-13 10:00:00",5
+"2007-04-13 11:00:00",5
+"2007-04-13 12:00:00",5
+"2007-04-13 13:00:00",5
+"2007-04-13 14:00:00",5
+"2007-04-13 15:00:00",5
+"2007-04-13 16:00:00",5
+"2007-04-13 17:00:00",5
+"2007-04-13 18:00:00",5
+"2007-04-13 19:00:00",5
+"2007-04-13 20:00:00",5
+"2007-04-13 21:00:00",5
+"2007-04-13 22:00:00",5
+"2007-04-13 23:00:00",5
+"2007-04-14 00:00:00",5
+"2007-04-14 01:00:00",6
+"2007-04-14 02:00:00",6
+"2007-04-14 03:00:00",6
+"2007-04-14 04:00:00",6
+"2007-04-14 05:00:00",6
+"2007-04-14 06:00:00",6
+"2007-04-14 07:00:00",6
+"2007-04-14 08:00:00",6
+"2007-04-14 09:00:00",6
+"2007-04-14 10:00:00",6
+"2007-04-14 11:00:00",6
+"2007-04-14 12:00:00",6
+"2007-04-14 13:00:00",6
+"2007-04-14 14:00:00",6
+"2007-04-14 15:00:00",6
+"2007-04-14 16:00:00",6
+"2007-04-14 17:00:00",6
+"2007-04-14 18:00:00",6
+"2007-04-14 19:00:00",6
+"2007-04-14 20:00:00",6
+"2007-04-14 21:00:00",6
+"2007-04-14 22:00:00",6
+"2007-04-14 23:00:00",6
+"2007-04-15 00:00:00",6
+"2007-04-15 01:00:00",7
+"2007-04-15 02:00:00",7
+"2007-04-15 03:00:00",7
+"2007-04-15 04:00:00",7
+"2007-04-15 05:00:00",7
+"2007-04-15 06:00:00",7
+"2007-04-15 07:00:00",7
+"2007-04-15 08:00:00",7
+"2007-04-15 09:00:00",7
+"2007-04-15 10:00:00",7
+"2007-04-15 11:00:00",7
+"2007-04-15 12:00:00",7
+"2007-04-15 13:00:00",7
+"2007-04-15 14:00:00",7
+"2007-04-15 15:00:00",7
+"2007-04-15 16:00:00",7
+"2007-04-15 17:00:00",7
+"2007-04-15 18:00:00",7
+"2007-04-15 19:00:00",7
+"2007-04-15 20:00:00",7
+"2007-04-15 21:00:00",7
+"2007-04-15 22:00:00",7
+"2007-04-15 23:00:00",7
+"2007-04-16 00:00:00",7
+"2007-04-16 01:00:00",1
+"2007-04-16 02:00:00",1
+"2007-04-16 03:00:00",1
+"2007-04-16 04:00:00",1
+"2007-04-16 05:00:00",1
+"2007-04-16 06:00:00",1
+"2007-04-16 07:00:00",1
+"2007-04-16 08:00:00",1
+"2007-04-16 09:00:00",1
+"2007-04-16 10:00:00",1
+"2007-04-16 11:00:00",1
+"2007-04-16 12:00:00",1
+"2007-04-16 13:00:00",1
+"2007-04-16 14:00:00",1
+"2007-04-16 15:00:00",1
+"2007-04-16 16:00:00",1
+"2007-04-16 17:00:00",1
+"2007-04-16 18:00:00",1
+"2007-04-16 19:00:00",1
+"2007-04-16 20:00:00",1
+"2007-04-16 21:00:00",1
+"2007-04-16 22:00:00",1
+"2007-04-16 23:00:00",1
+"2007-04-17 00:00:00",1
+"2007-04-17 01:00:00",2
+"2007-04-17 02:00:00",2
+"2007-04-17 03:00:00",2
+"2007-04-17 04:00:00",2
+"2007-04-17 05:00:00",2
+"2007-04-17 06:00:00",2
+"2007-04-17 07:00:00",2
+"2007-04-17 08:00:00",2
+"2007-04-17 09:00:00",2
+"2007-04-17 10:00:00",2
+"2007-04-17 11:00:00",2
+"2007-04-17 12:00:00",2
+"2007-04-17 13:00:00",2
+"2007-04-17 14:00:00",2
+"2007-04-17 15:00:00",2
+"2007-04-17 16:00:00",2
+"2007-04-17 17:00:00",2
+"2007-04-17 18:00:00",2
+"2007-04-17 19:00:00",2
+"2007-04-17 20:00:00",2
+"2007-04-17 21:00:00",2
+"2007-04-17 22:00:00",2
+"2007-04-17 23:00:00",2
+"2007-04-18 00:00:00",2
+"2007-04-18 01:00:00",3
+"2007-04-18 02:00:00",3
+"2007-04-18 03:00:00",3
+"2007-04-18 04:00:00",3
+"2007-04-18 05:00:00",3
+"2007-04-18 06:00:00",3
+"2007-04-18 07:00:00",3
+"2007-04-18 08:00:00",3
+"2007-04-18 09:00:00",3
+"2007-04-18 10:00:00",3
+"2007-04-18 11:00:00",3
+"2007-04-18 12:00:00",3
+"2007-04-18 13:00:00",3
+"2007-04-18 14:00:00",3
+"2007-04-18 15:00:00",3
+"2007-04-18 16:00:00",3
+"2007-04-18 17:00:00",3
+"2007-04-18 18:00:00",3
+"2007-04-18 19:00:00",3
+"2007-04-18 20:00:00",3
+"2007-04-18 21:00:00",3
+"2007-04-18 22:00:00",3
+"2007-04-18 23:00:00",3
+"2007-04-19 00:00:00",3
+"2007-04-19 01:00:00",4
+"2007-04-19 02:00:00",4
+"2007-04-19 03:00:00",4
+"2007-04-19 04:00:00",4
+"2007-04-19 05:00:00",4
+"2007-04-19 06:00:00",4
+"2007-04-19 07:00:00",4
+"2007-04-19 08:00:00",4
+"2007-04-19 09:00:00",4
+"2007-04-19 10:00:00",4
+"2007-04-19 11:00:00",4
+"2007-04-19 12:00:00",4
+"2007-04-19 13:00:00",4
+"2007-04-19 14:00:00",4
+"2007-04-19 15:00:00",4
+"2007-04-19 16:00:00",4
+"2007-04-19 17:00:00",4
+"2007-04-19 18:00:00",4
+"2007-04-19 19:00:00",4
+"2007-04-19 20:00:00",4
+"2007-04-19 21:00:00",4
+"2007-04-19 22:00:00",4
+"2007-04-19 23:00:00",4
+"2007-04-20 00:00:00",4
+"2007-04-20 01:00:00",5
+"2007-04-20 02:00:00",5
+"2007-04-20 03:00:00",5
+"2007-04-20 04:00:00",5
+"2007-04-20 05:00:00",5
+"2007-04-20 06:00:00",5
+"2007-04-20 07:00:00",5
+"2007-04-20 08:00:00",5
+"2007-04-20 09:00:00",5
+"2007-04-20 10:00:00",5
+"2007-04-20 11:00:00",5
+"2007-04-20 12:00:00",5
+"2007-04-20 13:00:00",5
+"2007-04-20 14:00:00",5
+"2007-04-20 15:00:00",5
+"2007-04-20 16:00:00",5
+"2007-04-20 17:00:00",5
+"2007-04-20 18:00:00",5
+"2007-04-20 19:00:00",5
+"2007-04-20 20:00:00",5
+"2007-04-20 21:00:00",5
+"2007-04-20 22:00:00",5
+"2007-04-20 23:00:00",5
+"2007-04-21 00:00:00",5
+"2007-04-21 01:00:00",6
+"2007-04-21 02:00:00",6
+"2007-04-21 03:00:00",6
+"2007-04-21 04:00:00",6
+"2007-04-21 05:00:00",6
+"2007-04-21 06:00:00",6
+"2007-04-21 07:00:00",6
+"2007-04-21 08:00:00",6
+"2007-04-21 09:00:00",6
+"2007-04-21 10:00:00",6
+"2007-04-21 11:00:00",6
+"2007-04-21 12:00:00",6
+"2007-04-21 13:00:00",6
+"2007-04-21 14:00:00",6
+"2007-04-21 15:00:00",6
+"2007-04-21 16:00:00",6
+"2007-04-21 17:00:00",6
+"2007-04-21 18:00:00",6
+"2007-04-21 19:00:00",6
+"2007-04-21 20:00:00",6
+"2007-04-21 21:00:00",6
+"2007-04-21 22:00:00",6
+"2007-04-21 23:00:00",6
+"2007-04-22 00:00:00",6
+"2007-04-22 01:00:00",7
+"2007-04-22 02:00:00",7
+"2007-04-22 03:00:00",7
+"2007-04-22 04:00:00",7
+"2007-04-22 05:00:00",7
+"2007-04-22 06:00:00",7
+"2007-04-22 07:00:00",7
+"2007-04-22 08:00:00",7
+"2007-04-22 09:00:00",7
+"2007-04-22 10:00:00",7
+"2007-04-22 11:00:00",7
+"2007-04-22 12:00:00",7
+"2007-04-22 13:00:00",7
+"2007-04-22 14:00:00",7
+"2007-04-22 15:00:00",7
+"2007-04-22 16:00:00",7
+"2007-04-22 17:00:00",7
+"2007-04-22 18:00:00",7
+"2007-04-22 19:00:00",7
+"2007-04-22 20:00:00",7
+"2007-04-22 21:00:00",7
+"2007-04-22 22:00:00",7
+"2007-04-22 23:00:00",7
+"2007-04-23 00:00:00",7
+"2007-04-23 01:00:00",1
+"2007-04-23 02:00:00",1
+"2007-04-23 03:00:00",1
+"2007-04-23 04:00:00",1
+"2007-04-23 05:00:00",1
+"2007-04-23 06:00:00",1
+"2007-04-23 07:00:00",1
+"2007-04-23 08:00:00",1
+"2007-04-23 09:00:00",1
+"2007-04-23 10:00:00",1
+"2007-04-23 11:00:00",1
+"2007-04-23 12:00:00",1
+"2007-04-23 13:00:00",1
+"2007-04-23 14:00:00",1
+"2007-04-23 15:00:00",1
+"2007-04-23 16:00:00",1
+"2007-04-23 17:00:00",1
+"2007-04-23 18:00:00",1
+"2007-04-23 19:00:00",1
+"2007-04-23 20:00:00",1
+"2007-04-23 21:00:00",1
+"2007-04-23 22:00:00",1
+"2007-04-23 23:00:00",1
+"2007-04-24 00:00:00",1
+"2007-04-24 01:00:00",2
+"2007-04-24 02:00:00",2
+"2007-04-24 03:00:00",2
+"2007-04-24 04:00:00",2
+"2007-04-24 05:00:00",2
+"2007-04-24 06:00:00",2
+"2007-04-24 07:00:00",2
+"2007-04-24 08:00:00",2
+"2007-04-24 09:00:00",2
+"2007-04-24 10:00:00",2
+"2007-04-24 11:00:00",2
+"2007-04-24 12:00:00",2
+"2007-04-24 13:00:00",2
+"2007-04-24 14:00:00",2
+"2007-04-24 15:00:00",2
+"2007-04-24 16:00:00",2
+"2007-04-24 17:00:00",2
+"2007-04-24 18:00:00",2
+"2007-04-24 19:00:00",2
+"2007-04-24 20:00:00",2
+"2007-04-24 21:00:00",2
+"2007-04-24 22:00:00",2
+"2007-04-24 23:00:00",2
+"2007-04-25 00:00:00",2
+"2007-04-25 01:00:00",3
+"2007-04-25 02:00:00",3
+"2007-04-25 03:00:00",3
+"2007-04-25 04:00:00",3
+"2007-04-25 05:00:00",3
+"2007-04-25 06:00:00",3
+"2007-04-25 07:00:00",3
+"2007-04-25 08:00:00",3
+"2007-04-25 09:00:00",3
+"2007-04-25 10:00:00",3
+"2007-04-25 11:00:00",3
+"2007-04-25 12:00:00",3
+"2007-04-25 13:00:00",3
+"2007-04-25 14:00:00",3
+"2007-04-25 15:00:00",3
+"2007-04-25 16:00:00",3
+"2007-04-25 17:00:00",3
+"2007-04-25 18:00:00",3
+"2007-04-25 19:00:00",3
+"2007-04-25 20:00:00",3
+"2007-04-25 21:00:00",3
+"2007-04-25 22:00:00",3
+"2007-04-25 23:00:00",3
+"2007-04-26 00:00:00",3
+"2007-04-26 01:00:00",4
+"2007-04-26 02:00:00",4
+"2007-04-26 03:00:00",4
+"2007-04-26 04:00:00",4
+"2007-04-26 05:00:00",4
+"2007-04-26 06:00:00",4
+"2007-04-26 07:00:00",4
+"2007-04-26 08:00:00",4
+"2007-04-26 09:00:00",4
+"2007-04-26 10:00:00",4
+"2007-04-26 11:00:00",4
+"2007-04-26 12:00:00",4
+"2007-04-26 13:00:00",4
+"2007-04-26 14:00:00",4
+"2007-04-26 15:00:00",4
+"2007-04-26 16:00:00",4
+"2007-04-26 17:00:00",4
+"2007-04-26 18:00:00",4
+"2007-04-26 19:00:00",4
+"2007-04-26 20:00:00",4
+"2007-04-26 21:00:00",4
+"2007-04-26 22:00:00",4
+"2007-04-26 23:00:00",4
+"2007-04-27 00:00:00",4
+"2007-04-27 01:00:00",5
+"2007-04-27 02:00:00",5
+"2007-04-27 03:00:00",5
+"2007-04-27 04:00:00",5
+"2007-04-27 05:00:00",5
+"2007-04-27 06:00:00",5
+"2007-04-27 07:00:00",5
+"2007-04-27 08:00:00",5
+"2007-04-27 09:00:00",5
+"2007-04-27 10:00:00",5
+"2007-04-27 11:00:00",5
+"2007-04-27 12:00:00",5
+"2007-04-27 13:00:00",5
+"2007-04-27 14:00:00",5
+"2007-04-27 15:00:00",5
+"2007-04-27 16:00:00",5
+"2007-04-27 17:00:00",5
+"2007-04-27 18:00:00",5
+"2007-04-27 19:00:00",5
+"2007-04-27 20:00:00",5
+"2007-04-27 21:00:00",5
+"2007-04-27 22:00:00",5
+"2007-04-27 23:00:00",5
+"2007-04-28 00:00:00",5
+"2007-04-28 01:00:00",6
+"2007-04-28 02:00:00",6
+"2007-04-28 03:00:00",6
+"2007-04-28 04:00:00",6
+"2007-04-28 05:00:00",6
+"2007-04-28 06:00:00",6
+"2007-04-28 07:00:00",6
+"2007-04-28 08:00:00",6
+"2007-04-28 09:00:00",6
+"2007-04-28 10:00:00",6
+"2007-04-28 11:00:00",6
+"2007-04-28 12:00:00",6
+"2007-04-28 13:00:00",6
+"2007-04-28 14:00:00",6
+"2007-04-28 15:00:00",6
+"2007-04-28 16:00:00",6
+"2007-04-28 17:00:00",6
+"2007-04-28 18:00:00",6
+"2007-04-28 19:00:00",6
+"2007-04-28 20:00:00",6
+"2007-04-28 21:00:00",6
+"2007-04-28 22:00:00",6
+"2007-04-28 23:00:00",6
+"2007-04-29 00:00:00",6
+"2007-04-29 01:00:00",7
+"2007-04-29 02:00:00",7
+"2007-04-29 03:00:00",7
+"2007-04-29 04:00:00",7
+"2007-04-29 05:00:00",7
+"2007-04-29 06:00:00",7
+"2007-04-29 07:00:00",7
+"2007-04-29 08:00:00",7
+"2007-04-29 09:00:00",7
+"2007-04-29 10:00:00",7
+"2007-04-29 11:00:00",7
+"2007-04-29 12:00:00",7
+"2007-04-29 13:00:00",7
+"2007-04-29 14:00:00",7
+"2007-04-29 15:00:00",7
+"2007-04-29 16:00:00",7
+"2007-04-29 17:00:00",7
+"2007-04-29 18:00:00",7
+"2007-04-29 19:00:00",7
+"2007-04-29 20:00:00",7
+"2007-04-29 21:00:00",7
+"2007-04-29 22:00:00",7
+"2007-04-29 23:00:00",7
+"2007-04-30 00:00:00",7
+"2007-04-30 01:00:00",1
+"2007-04-30 02:00:00",1
+"2007-04-30 03:00:00",1
+"2007-04-30 04:00:00",1
+"2007-04-30 05:00:00",1
+"2007-04-30 06:00:00",1
+"2007-04-30 07:00:00",1
+"2007-04-30 08:00:00",1
+"2007-04-30 09:00:00",1
+"2007-04-30 10:00:00",1
+"2007-04-30 11:00:00",1
+"2007-04-30 12:00:00",1
+"2007-04-30 13:00:00",1
+"2007-04-30 14:00:00",1
+"2007-04-30 15:00:00",1
+"2007-04-30 16:00:00",1
+"2007-04-30 17:00:00",1
+"2007-04-30 18:00:00",1
+"2007-04-30 19:00:00",1
+"2007-04-30 20:00:00",1
+"2007-04-30 21:00:00",1
+"2007-04-30 22:00:00",1
+"2007-04-30 23:00:00",1
+"2007-05-01 00:00:00",1
+"2007-05-01 01:00:00",2
+"2007-05-01 02:00:00",2
+"2007-05-01 03:00:00",2
+"2007-05-01 04:00:00",2
+"2007-05-01 05:00:00",2
+"2007-05-01 06:00:00",2
+"2007-05-01 07:00:00",2
+"2007-05-01 08:00:00",2
+"2007-05-01 09:00:00",2
+"2007-05-01 10:00:00",2
+"2007-05-01 11:00:00",2
+"2007-05-01 12:00:00",2
+"2007-05-01 13:00:00",2
+"2007-05-01 14:00:00",2
+"2007-05-01 15:00:00",2
+"2007-05-01 16:00:00",2
+"2007-05-01 17:00:00",2
+"2007-05-01 18:00:00",2
+"2007-05-01 19:00:00",2
+"2007-05-01 20:00:00",2
+"2007-05-01 21:00:00",2
+"2007-05-01 22:00:00",2
+"2007-05-01 23:00:00",2
+"2007-05-02 00:00:00",2
+"2007-05-02 01:00:00",3
+"2007-05-02 02:00:00",3
+"2007-05-02 03:00:00",3
+"2007-05-02 04:00:00",3
+"2007-05-02 05:00:00",3
+"2007-05-02 06:00:00",3
+"2007-05-02 07:00:00",3
+"2007-05-02 08:00:00",3
+"2007-05-02 09:00:00",3
+"2007-05-02 10:00:00",3
+"2007-05-02 11:00:00",3
+"2007-05-02 12:00:00",3
+"2007-05-02 13:00:00",3
+"2007-05-02 14:00:00",3
+"2007-05-02 15:00:00",3
+"2007-05-02 16:00:00",3
+"2007-05-02 17:00:00",3
+"2007-05-02 18:00:00",3
+"2007-05-02 19:00:00",3
+"2007-05-02 20:00:00",3
+"2007-05-02 21:00:00",3
+"2007-05-02 22:00:00",3
+"2007-05-02 23:00:00",3
+"2007-05-03 00:00:00",3
+"2007-05-03 01:00:00",4
+"2007-05-03 02:00:00",4
+"2007-05-03 03:00:00",4
+"2007-05-03 04:00:00",4
+"2007-05-03 05:00:00",4
+"2007-05-03 06:00:00",4
+"2007-05-03 07:00:00",4
+"2007-05-03 08:00:00",4
+"2007-05-03 09:00:00",4
+"2007-05-03 10:00:00",4
+"2007-05-03 11:00:00",4
+"2007-05-03 12:00:00",4
+"2007-05-03 13:00:00",4
+"2007-05-03 14:00:00",4
+"2007-05-03 15:00:00",4
+"2007-05-03 16:00:00",4
+"2007-05-03 17:00:00",4
+"2007-05-03 18:00:00",4
+"2007-05-03 19:00:00",4
+"2007-05-03 20:00:00",4
+"2007-05-03 21:00:00",4
+"2007-05-03 22:00:00",4
+"2007-05-03 23:00:00",4
+"2007-05-04 00:00:00",4
+"2007-05-04 01:00:00",5
+"2007-05-04 02:00:00",5
+"2007-05-04 03:00:00",5
+"2007-05-04 04:00:00",5
+"2007-05-04 05:00:00",5
+"2007-05-04 06:00:00",5
+"2007-05-04 07:00:00",5
+"2007-05-04 08:00:00",5
+"2007-05-04 09:00:00",5
+"2007-05-04 10:00:00",5
+"2007-05-04 11:00:00",5
+"2007-05-04 12:00:00",5
+"2007-05-04 13:00:00",5
+"2007-05-04 14:00:00",5
+"2007-05-04 15:00:00",5
+"2007-05-04 16:00:00",5
+"2007-05-04 17:00:00",5
+"2007-05-04 18:00:00",5
+"2007-05-04 19:00:00",5
+"2007-05-04 20:00:00",5
+"2007-05-04 21:00:00",5
+"2007-05-04 22:00:00",5
+"2007-05-04 23:00:00",5
+"2007-05-05 00:00:00",5
+"2007-05-05 01:00:00",6
+"2007-05-05 02:00:00",6
+"2007-05-05 03:00:00",6
+"2007-05-05 04:00:00",6
+"2007-05-05 05:00:00",6
+"2007-05-05 06:00:00",6
+"2007-05-05 07:00:00",6
+"2007-05-05 08:00:00",6
+"2007-05-05 09:00:00",6
+"2007-05-05 10:00:00",6
+"2007-05-05 11:00:00",6
+"2007-05-05 12:00:00",6
+"2007-05-05 13:00:00",6
+"2007-05-05 14:00:00",6
+"2007-05-05 15:00:00",6
+"2007-05-05 16:00:00",6
+"2007-05-05 17:00:00",6
+"2007-05-05 18:00:00",6
+"2007-05-05 19:00:00",6
+"2007-05-05 20:00:00",6
+"2007-05-05 21:00:00",6
+"2007-05-05 22:00:00",6
+"2007-05-05 23:00:00",6
+"2007-05-06 00:00:00",6
+"2007-05-06 01:00:00",7
+"2007-05-06 02:00:00",7
+"2007-05-06 03:00:00",7
+"2007-05-06 04:00:00",7
+"2007-05-06 05:00:00",7
+"2007-05-06 06:00:00",7
+"2007-05-06 07:00:00",7
+"2007-05-06 08:00:00",7
+"2007-05-06 09:00:00",7
+"2007-05-06 10:00:00",7
+"2007-05-06 11:00:00",7
+"2007-05-06 12:00:00",7
+"2007-05-06 13:00:00",7
+"2007-05-06 14:00:00",7
+"2007-05-06 15:00:00",7
+"2007-05-06 16:00:00",7
+"2007-05-06 17:00:00",7
+"2007-05-06 18:00:00",7
+"2007-05-06 19:00:00",7
+"2007-05-06 20:00:00",7
+"2007-05-06 21:00:00",7
+"2007-05-06 22:00:00",7
+"2007-05-06 23:00:00",7
+"2007-05-07 00:00:00",7
+"2007-05-07 01:00:00",1
+"2007-05-07 02:00:00",1
+"2007-05-07 03:00:00",1
+"2007-05-07 04:00:00",1
+"2007-05-07 05:00:00",1
+"2007-05-07 06:00:00",1
+"2007-05-07 07:00:00",1
+"2007-05-07 08:00:00",1
+"2007-05-07 09:00:00",1
+"2007-05-07 10:00:00",1
+"2007-05-07 11:00:00",1
+"2007-05-07 12:00:00",1
+"2007-05-07 13:00:00",1
+"2007-05-07 14:00:00",1
+"2007-05-07 15:00:00",1
+"2007-05-07 16:00:00",1
+"2007-05-07 17:00:00",1
+"2007-05-07 18:00:00",1
+"2007-05-07 19:00:00",1
+"2007-05-07 20:00:00",1
+"2007-05-07 21:00:00",1
+"2007-05-07 22:00:00",1
+"2007-05-07 23:00:00",1
+"2007-05-08 00:00:00",1
+"2007-05-08 01:00:00",2
+"2007-05-08 02:00:00",2
+"2007-05-08 03:00:00",2
+"2007-05-08 04:00:00",2
+"2007-05-08 05:00:00",2
+"2007-05-08 06:00:00",2
+"2007-05-08 07:00:00",2
+"2007-05-08 08:00:00",2
+"2007-05-08 09:00:00",2
+"2007-05-08 10:00:00",2
+"2007-05-08 11:00:00",2
+"2007-05-08 12:00:00",2
+"2007-05-08 13:00:00",2
+"2007-05-08 14:00:00",2
+"2007-05-08 15:00:00",2
+"2007-05-08 16:00:00",2
+"2007-05-08 17:00:00",2
+"2007-05-08 18:00:00",2
+"2007-05-08 19:00:00",2
+"2007-05-08 20:00:00",2
+"2007-05-08 21:00:00",2
+"2007-05-08 22:00:00",2
+"2007-05-08 23:00:00",2
+"2007-05-09 00:00:00",2
+"2007-05-09 01:00:00",3
+"2007-05-09 02:00:00",3
+"2007-05-09 03:00:00",3
+"2007-05-09 04:00:00",3
+"2007-05-09 05:00:00",3
+"2007-05-09 06:00:00",3
+"2007-05-09 07:00:00",3
+"2007-05-09 08:00:00",3
+"2007-05-09 09:00:00",3
+"2007-05-09 10:00:00",3
+"2007-05-09 11:00:00",3
+"2007-05-09 12:00:00",3
+"2007-05-09 13:00:00",3
+"2007-05-09 14:00:00",3
+"2007-05-09 15:00:00",3
+"2007-05-09 16:00:00",3
+"2007-05-09 17:00:00",3
+"2007-05-09 18:00:00",3
+"2007-05-09 19:00:00",3
+"2007-05-09 20:00:00",3
+"2007-05-09 21:00:00",3
+"2007-05-09 22:00:00",3
+"2007-05-09 23:00:00",3
+"2007-05-10 00:00:00",3
+"2007-05-10 01:00:00",4
+"2007-05-10 02:00:00",4
+"2007-05-10 03:00:00",4
+"2007-05-10 04:00:00",4
+"2007-05-10 05:00:00",4
+"2007-05-10 06:00:00",4
+"2007-05-10 07:00:00",4
+"2007-05-10 08:00:00",4
+"2007-05-10 09:00:00",4
+"2007-05-10 10:00:00",4
+"2007-05-10 11:00:00",4
+"2007-05-10 12:00:00",4
+"2007-05-10 13:00:00",4
+"2007-05-10 14:00:00",4
+"2007-05-10 15:00:00",4
+"2007-05-10 16:00:00",4
+"2007-05-10 17:00:00",4
+"2007-05-10 18:00:00",4
+"2007-05-10 19:00:00",4
+"2007-05-10 20:00:00",4
+"2007-05-10 21:00:00",4
+"2007-05-10 22:00:00",4
+"2007-05-10 23:00:00",4
+"2007-05-11 00:00:00",4
+"2007-05-11 01:00:00",5
+"2007-05-11 02:00:00",5
+"2007-05-11 03:00:00",5
+"2007-05-11 04:00:00",5
+"2007-05-11 05:00:00",5
+"2007-05-11 06:00:00",5
+"2007-05-11 07:00:00",5
+"2007-05-11 08:00:00",5
+"2007-05-11 09:00:00",5
+"2007-05-11 10:00:00",5
+"2007-05-11 11:00:00",5
+"2007-05-11 12:00:00",5
+"2007-05-11 13:00:00",5
+"2007-05-11 14:00:00",5
+"2007-05-11 15:00:00",5
+"2007-05-11 16:00:00",5
+"2007-05-11 17:00:00",5
+"2007-05-11 18:00:00",5
+"2007-05-11 19:00:00",5
+"2007-05-11 20:00:00",5
+"2007-05-11 21:00:00",5
+"2007-05-11 22:00:00",5
+"2007-05-11 23:00:00",5
+"2007-05-12 00:00:00",5
+"2007-05-12 01:00:00",6
+"2007-05-12 02:00:00",6
+"2007-05-12 03:00:00",6
+"2007-05-12 04:00:00",6
+"2007-05-12 05:00:00",6
+"2007-05-12 06:00:00",6
+"2007-05-12 07:00:00",6
+"2007-05-12 08:00:00",6
+"2007-05-12 09:00:00",6
+"2007-05-12 10:00:00",6
+"2007-05-12 11:00:00",6
+"2007-05-12 12:00:00",6
+"2007-05-12 13:00:00",6
+"2007-05-12 14:00:00",6
+"2007-05-12 15:00:00",6
+"2007-05-12 16:00:00",6
+"2007-05-12 17:00:00",6
+"2007-05-12 18:00:00",6
+"2007-05-12 19:00:00",6
+"2007-05-12 20:00:00",6
+"2007-05-12 21:00:00",6
+"2007-05-12 22:00:00",6
+"2007-05-12 23:00:00",6
+"2007-05-13 00:00:00",6
+"2007-05-13 01:00:00",7
+"2007-05-13 02:00:00",7
+"2007-05-13 03:00:00",7
+"2007-05-13 04:00:00",7
+"2007-05-13 05:00:00",7
+"2007-05-13 06:00:00",7
+"2007-05-13 07:00:00",7
+"2007-05-13 08:00:00",7
+"2007-05-13 09:00:00",7
+"2007-05-13 10:00:00",7
+"2007-05-13 11:00:00",7
+"2007-05-13 12:00:00",7
+"2007-05-13 13:00:00",7
+"2007-05-13 14:00:00",7
+"2007-05-13 15:00:00",7
+"2007-05-13 16:00:00",7
+"2007-05-13 17:00:00",7
+"2007-05-13 18:00:00",7
+"2007-05-13 19:00:00",7
+"2007-05-13 20:00:00",7
+"2007-05-13 21:00:00",7
+"2007-05-13 22:00:00",7
+"2007-05-13 23:00:00",7
+"2007-05-14 00:00:00",7
+"2007-05-14 01:00:00",1
+"2007-05-14 02:00:00",1
+"2007-05-14 03:00:00",1
+"2007-05-14 04:00:00",1
+"2007-05-14 05:00:00",1
+"2007-05-14 06:00:00",1
+"2007-05-14 07:00:00",1
+"2007-05-14 08:00:00",1
+"2007-05-14 09:00:00",1
+"2007-05-14 10:00:00",1
+"2007-05-14 11:00:00",1
+"2007-05-14 12:00:00",1
+"2007-05-14 13:00:00",1
+"2007-05-14 14:00:00",1
+"2007-05-14 15:00:00",1
+"2007-05-14 16:00:00",1
+"2007-05-14 17:00:00",1
+"2007-05-14 18:00:00",1
+"2007-05-14 19:00:00",1
+"2007-05-14 20:00:00",1
+"2007-05-14 21:00:00",1
+"2007-05-14 22:00:00",1
+"2007-05-14 23:00:00",1
+"2007-05-15 00:00:00",1
+"2007-05-15 01:00:00",2
+"2007-05-15 02:00:00",2
+"2007-05-15 03:00:00",2
+"2007-05-15 04:00:00",2
+"2007-05-15 05:00:00",2
+"2007-05-15 06:00:00",2
+"2007-05-15 07:00:00",2
+"2007-05-15 08:00:00",2
+"2007-05-15 09:00:00",2
+"2007-05-15 10:00:00",2
+"2007-05-15 11:00:00",2
+"2007-05-15 12:00:00",2
+"2007-05-15 13:00:00",2
+"2007-05-15 14:00:00",2
+"2007-05-15 15:00:00",2
+"2007-05-15 16:00:00",2
+"2007-05-15 17:00:00",2
+"2007-05-15 18:00:00",2
+"2007-05-15 19:00:00",2
+"2007-05-15 20:00:00",2
+"2007-05-15 21:00:00",2
+"2007-05-15 22:00:00",2
+"2007-05-15 23:00:00",2
+"2007-05-16 00:00:00",2
+"2007-05-16 01:00:00",3
+"2007-05-16 02:00:00",3
+"2007-05-16 03:00:00",3
+"2007-05-16 04:00:00",3
+"2007-05-16 05:00:00",3
+"2007-05-16 06:00:00",3
+"2007-05-16 07:00:00",3
+"2007-05-16 08:00:00",3
+"2007-05-16 09:00:00",3
+"2007-05-16 10:00:00",3
+"2007-05-16 11:00:00",3
+"2007-05-16 12:00:00",3
+"2007-05-16 13:00:00",3
+"2007-05-16 14:00:00",3
+"2007-05-16 15:00:00",3
+"2007-05-16 16:00:00",3
+"2007-05-16 17:00:00",3
+"2007-05-16 18:00:00",3
+"2007-05-16 19:00:00",3
+"2007-05-16 20:00:00",3
+"2007-05-16 21:00:00",3
+"2007-05-16 22:00:00",3
+"2007-05-16 23:00:00",3
+"2007-05-17 00:00:00",3
+"2007-05-17 01:00:00",4
+"2007-05-17 02:00:00",4
+"2007-05-17 03:00:00",4
+"2007-05-17 04:00:00",4
+"2007-05-17 05:00:00",4
+"2007-05-17 06:00:00",4
+"2007-05-17 07:00:00",4
+"2007-05-17 08:00:00",4
+"2007-05-17 09:00:00",4
+"2007-05-17 10:00:00",4
+"2007-05-17 11:00:00",4
+"2007-05-17 12:00:00",4
+"2007-05-17 13:00:00",4
+"2007-05-17 14:00:00",4
+"2007-05-17 15:00:00",4
+"2007-05-17 16:00:00",4
+"2007-05-17 17:00:00",4
+"2007-05-17 18:00:00",4
+"2007-05-17 19:00:00",4
+"2007-05-17 20:00:00",4
+"2007-05-17 21:00:00",4
+"2007-05-17 22:00:00",4
+"2007-05-17 23:00:00",4
+"2007-05-18 00:00:00",4
+"2007-05-18 01:00:00",5
+"2007-05-18 02:00:00",5
+"2007-05-18 03:00:00",5
+"2007-05-18 04:00:00",5
+"2007-05-18 05:00:00",5
+"2007-05-18 06:00:00",5
+"2007-05-18 07:00:00",5
+"2007-05-18 08:00:00",5
+"2007-05-18 09:00:00",5
+"2007-05-18 10:00:00",5
+"2007-05-18 11:00:00",5
+"2007-05-18 12:00:00",5
+"2007-05-18 13:00:00",5
+"2007-05-18 14:00:00",5
+"2007-05-18 15:00:00",5
+"2007-05-18 16:00:00",5
+"2007-05-18 17:00:00",5
+"2007-05-18 18:00:00",5
+"2007-05-18 19:00:00",5
+"2007-05-18 20:00:00",5
+"2007-05-18 21:00:00",5
+"2007-05-18 22:00:00",5
+"2007-05-18 23:00:00",5
+"2007-05-19 00:00:00",5
+"2007-05-19 01:00:00",6
+"2007-05-19 02:00:00",6
+"2007-05-19 03:00:00",6
+"2007-05-19 04:00:00",6
+"2007-05-19 05:00:00",6
+"2007-05-19 06:00:00",6
+"2007-05-19 07:00:00",6
+"2007-05-19 08:00:00",6
+"2007-05-19 09:00:00",6
+"2007-05-19 10:00:00",6
+"2007-05-19 11:00:00",6
+"2007-05-19 12:00:00",6
+"2007-05-19 13:00:00",6
+"2007-05-19 14:00:00",6
+"2007-05-19 15:00:00",6
+"2007-05-19 16:00:00",6
+"2007-05-19 17:00:00",6
+"2007-05-19 18:00:00",6
+"2007-05-19 19:00:00",6
+"2007-05-19 20:00:00",6
+"2007-05-19 21:00:00",6
+"2007-05-19 22:00:00",6
+"2007-05-19 23:00:00",6
+"2007-05-20 00:00:00",6
+"2007-05-20 01:00:00",7
+"2007-05-20 02:00:00",7
+"2007-05-20 03:00:00",7
+"2007-05-20 04:00:00",7
+"2007-05-20 05:00:00",7
+"2007-05-20 06:00:00",7
+"2007-05-20 07:00:00",7
+"2007-05-20 08:00:00",7
+"2007-05-20 09:00:00",7
+"2007-05-20 10:00:00",7
+"2007-05-20 11:00:00",7
+"2007-05-20 12:00:00",7
+"2007-05-20 13:00:00",7
+"2007-05-20 14:00:00",7
+"2007-05-20 15:00:00",7
+"2007-05-20 16:00:00",7
+"2007-05-20 17:00:00",7
+"2007-05-20 18:00:00",7
+"2007-05-20 19:00:00",7
+"2007-05-20 20:00:00",7
+"2007-05-20 21:00:00",7
+"2007-05-20 22:00:00",7
+"2007-05-20 23:00:00",7
+"2007-05-21 00:00:00",7
+"2007-05-21 01:00:00",1
+"2007-05-21 02:00:00",1
+"2007-05-21 03:00:00",1
+"2007-05-21 04:00:00",1
+"2007-05-21 05:00:00",1
+"2007-05-21 06:00:00",1
+"2007-05-21 07:00:00",1
+"2007-05-21 08:00:00",1
+"2007-05-21 09:00:00",1
+"2007-05-21 10:00:00",1
+"2007-05-21 11:00:00",1
+"2007-05-21 12:00:00",1
+"2007-05-21 13:00:00",1
+"2007-05-21 14:00:00",1
+"2007-05-21 15:00:00",1
+"2007-05-21 16:00:00",1
+"2007-05-21 17:00:00",1
+"2007-05-21 18:00:00",1
+"2007-05-21 19:00:00",1
+"2007-05-21 20:00:00",1
+"2007-05-21 21:00:00",1
+"2007-05-21 22:00:00",1
+"2007-05-21 23:00:00",1
+"2007-05-22 00:00:00",1
+"2007-05-22 01:00:00",2
+"2007-05-22 02:00:00",2
+"2007-05-22 03:00:00",2
+"2007-05-22 04:00:00",2
+"2007-05-22 05:00:00",2
+"2007-05-22 06:00:00",2
+"2007-05-22 07:00:00",2
+"2007-05-22 08:00:00",2
+"2007-05-22 09:00:00",2
+"2007-05-22 10:00:00",2
+"2007-05-22 11:00:00",2
+"2007-05-22 12:00:00",2
+"2007-05-22 13:00:00",2
+"2007-05-22 14:00:00",2
+"2007-05-22 15:00:00",2
+"2007-05-22 16:00:00",2
+"2007-05-22 17:00:00",2
+"2007-05-22 18:00:00",2
+"2007-05-22 19:00:00",2
+"2007-05-22 20:00:00",2
+"2007-05-22 21:00:00",2
+"2007-05-22 22:00:00",2
+"2007-05-22 23:00:00",2
+"2007-05-23 00:00:00",2
+"2007-05-23 01:00:00",3
+"2007-05-23 02:00:00",3
+"2007-05-23 03:00:00",3
+"2007-05-23 04:00:00",3
+"2007-05-23 05:00:00",3
+"2007-05-23 06:00:00",3
+"2007-05-23 07:00:00",3
+"2007-05-23 08:00:00",3
+"2007-05-23 09:00:00",3
+"2007-05-23 10:00:00",3
+"2007-05-23 11:00:00",3
+"2007-05-23 12:00:00",3
+"2007-05-23 13:00:00",3
+"2007-05-23 14:00:00",3
+"2007-05-23 15:00:00",3
+"2007-05-23 16:00:00",3
+"2007-05-23 17:00:00",3
+"2007-05-23 18:00:00",3
+"2007-05-23 19:00:00",3
+"2007-05-23 20:00:00",3
+"2007-05-23 21:00:00",3
+"2007-05-23 22:00:00",3
+"2007-05-23 23:00:00",3
+"2007-05-24 00:00:00",3
+"2007-05-24 01:00:00",4
+"2007-05-24 02:00:00",4
+"2007-05-24 03:00:00",4
+"2007-05-24 04:00:00",4
+"2007-05-24 05:00:00",4
+"2007-05-24 06:00:00",4
+"2007-05-24 07:00:00",4
+"2007-05-24 08:00:00",4
+"2007-05-24 09:00:00",4
+"2007-05-24 10:00:00",4
+"2007-05-24 11:00:00",4
+"2007-05-24 12:00:00",4
+"2007-05-24 13:00:00",4
+"2007-05-24 14:00:00",4
+"2007-05-24 15:00:00",4
+"2007-05-24 16:00:00",4
+"2007-05-24 17:00:00",4
+"2007-05-24 18:00:00",4
+"2007-05-24 19:00:00",4
+"2007-05-24 20:00:00",4
+"2007-05-24 21:00:00",4
+"2007-05-24 22:00:00",4
+"2007-05-24 23:00:00",4
+"2007-05-25 00:00:00",4
+"2007-05-25 01:00:00",5
+"2007-05-25 02:00:00",5
+"2007-05-25 03:00:00",5
+"2007-05-25 04:00:00",5
+"2007-05-25 05:00:00",5
+"2007-05-25 06:00:00",5
+"2007-05-25 07:00:00",5
+"2007-05-25 08:00:00",5
+"2007-05-25 09:00:00",5
+"2007-05-25 10:00:00",5
+"2007-05-25 11:00:00",5
+"2007-05-25 12:00:00",5
+"2007-05-25 13:00:00",5
+"2007-05-25 14:00:00",5
+"2007-05-25 15:00:00",5
+"2007-05-25 16:00:00",5
+"2007-05-25 17:00:00",5
+"2007-05-25 18:00:00",5
+"2007-05-25 19:00:00",5
+"2007-05-25 20:00:00",5
+"2007-05-25 21:00:00",5
+"2007-05-25 22:00:00",5
+"2007-05-25 23:00:00",5
+"2007-05-26 00:00:00",5
+"2007-05-26 01:00:00",6
+"2007-05-26 02:00:00",6
+"2007-05-26 03:00:00",6
+"2007-05-26 04:00:00",6
+"2007-05-26 05:00:00",6
+"2007-05-26 06:00:00",6
+"2007-05-26 07:00:00",6
+"2007-05-26 08:00:00",6
+"2007-05-26 09:00:00",6
+"2007-05-26 10:00:00",6
+"2007-05-26 11:00:00",6
+"2007-05-26 12:00:00",6
+"2007-05-26 13:00:00",6
+"2007-05-26 14:00:00",6
+"2007-05-26 15:00:00",6
+"2007-05-26 16:00:00",6
+"2007-05-26 17:00:00",6
+"2007-05-26 18:00:00",6
+"2007-05-26 19:00:00",6
+"2007-05-26 20:00:00",6
+"2007-05-26 21:00:00",6
+"2007-05-26 22:00:00",6
+"2007-05-26 23:00:00",6
+"2007-05-27 00:00:00",6
+"2007-05-27 01:00:00",7
+"2007-05-27 02:00:00",7
+"2007-05-27 03:00:00",7
+"2007-05-27 04:00:00",7
+"2007-05-27 05:00:00",7
+"2007-05-27 06:00:00",7
+"2007-05-27 07:00:00",7
+"2007-05-27 08:00:00",7
+"2007-05-27 09:00:00",7
+"2007-05-27 10:00:00",7
+"2007-05-27 11:00:00",7
+"2007-05-27 12:00:00",7
+"2007-05-27 13:00:00",7
+"2007-05-27 14:00:00",7
+"2007-05-27 15:00:00",7
+"2007-05-27 16:00:00",7
+"2007-05-27 17:00:00",7
+"2007-05-27 18:00:00",7
+"2007-05-27 19:00:00",7
+"2007-05-27 20:00:00",7
+"2007-05-27 21:00:00",7
+"2007-05-27 22:00:00",7
+"2007-05-27 23:00:00",7
+"2007-05-28 00:00:00",7
+"2007-05-28 01:00:00",1
+"2007-05-28 02:00:00",1
+"2007-05-28 03:00:00",1
+"2007-05-28 04:00:00",1
+"2007-05-28 05:00:00",1
+"2007-05-28 06:00:00",1
+"2007-05-28 07:00:00",1
+"2007-05-28 08:00:00",1
+"2007-05-28 09:00:00",1
+"2007-05-28 10:00:00",1
+"2007-05-28 11:00:00",1
+"2007-05-28 12:00:00",1
+"2007-05-28 13:00:00",1
+"2007-05-28 14:00:00",1
+"2007-05-28 15:00:00",1
+"2007-05-28 16:00:00",1
+"2007-05-28 17:00:00",1
+"2007-05-28 18:00:00",1
+"2007-05-28 19:00:00",1
+"2007-05-28 20:00:00",1
+"2007-05-28 21:00:00",1
+"2007-05-28 22:00:00",1
+"2007-05-28 23:00:00",1
+"2007-05-29 00:00:00",1
+"2007-05-29 01:00:00",2
+"2007-05-29 02:00:00",2
+"2007-05-29 03:00:00",2
+"2007-05-29 04:00:00",2
+"2007-05-29 05:00:00",2
+"2007-05-29 06:00:00",2
+"2007-05-29 07:00:00",2
+"2007-05-29 08:00:00",2
+"2007-05-29 09:00:00",2
+"2007-05-29 10:00:00",2
+"2007-05-29 11:00:00",2
+"2007-05-29 12:00:00",2
+"2007-05-29 13:00:00",2
+"2007-05-29 14:00:00",2
+"2007-05-29 15:00:00",2
+"2007-05-29 16:00:00",2
+"2007-05-29 17:00:00",2
+"2007-05-29 18:00:00",2
+"2007-05-29 19:00:00",2
+"2007-05-29 20:00:00",2
+"2007-05-29 21:00:00",2
+"2007-05-29 22:00:00",2
+"2007-05-29 23:00:00",2
+"2007-05-30 00:00:00",2
+"2007-05-30 01:00:00",3
+"2007-05-30 02:00:00",3
+"2007-05-30 03:00:00",3
+"2007-05-30 04:00:00",3
+"2007-05-30 05:00:00",3
+"2007-05-30 06:00:00",3
+"2007-05-30 07:00:00",3
+"2007-05-30 08:00:00",3
+"2007-05-30 09:00:00",3
+"2007-05-30 10:00:00",3
+"2007-05-30 11:00:00",3
+"2007-05-30 12:00:00",3
+"2007-05-30 13:00:00",3
+"2007-05-30 14:00:00",3
+"2007-05-30 15:00:00",3
+"2007-05-30 16:00:00",3
+"2007-05-30 17:00:00",3
+"2007-05-30 18:00:00",3
+"2007-05-30 19:00:00",3
+"2007-05-30 20:00:00",3
+"2007-05-30 21:00:00",3
+"2007-05-30 22:00:00",3
+"2007-05-30 23:00:00",3
+"2007-05-31 00:00:00",3
+"2007-05-31 01:00:00",4
+"2007-05-31 02:00:00",4
+"2007-05-31 03:00:00",4
+"2007-05-31 04:00:00",4
+"2007-05-31 05:00:00",4
+"2007-05-31 06:00:00",4
+"2007-05-31 07:00:00",4
+"2007-05-31 08:00:00",4
+"2007-05-31 09:00:00",4
+"2007-05-31 10:00:00",4
+"2007-05-31 11:00:00",4
+"2007-05-31 12:00:00",4
+"2007-05-31 13:00:00",4
+"2007-05-31 14:00:00",4
+"2007-05-31 15:00:00",4
+"2007-05-31 16:00:00",4
+"2007-05-31 17:00:00",4
+"2007-05-31 18:00:00",4
+"2007-05-31 19:00:00",4
+"2007-05-31 20:00:00",4
+"2007-05-31 21:00:00",4
+"2007-05-31 22:00:00",4
+"2007-05-31 23:00:00",4
+"2007-06-01 00:00:00",4
+"2007-06-01 01:00:00",5
+"2007-06-01 02:00:00",5
+"2007-06-01 03:00:00",5
+"2007-06-01 04:00:00",5
+"2007-06-01 05:00:00",5
+"2007-06-01 06:00:00",5
+"2007-06-01 07:00:00",5
+"2007-06-01 08:00:00",5
+"2007-06-01 09:00:00",5
+"2007-06-01 10:00:00",5
+"2007-06-01 11:00:00",5
+"2007-06-01 12:00:00",5
+"2007-06-01 13:00:00",5
+"2007-06-01 14:00:00",5
+"2007-06-01 15:00:00",5
+"2007-06-01 16:00:00",5
+"2007-06-01 17:00:00",5
+"2007-06-01 18:00:00",5
+"2007-06-01 19:00:00",5
+"2007-06-01 20:00:00",5
+"2007-06-01 21:00:00",5
+"2007-06-01 22:00:00",5
+"2007-06-01 23:00:00",5
+"2007-06-02 00:00:00",5
+"2007-06-02 01:00:00",6
+"2007-06-02 02:00:00",6
+"2007-06-02 03:00:00",6
+"2007-06-02 04:00:00",6
+"2007-06-02 05:00:00",6
+"2007-06-02 06:00:00",6
+"2007-06-02 07:00:00",6
+"2007-06-02 08:00:00",6
+"2007-06-02 09:00:00",6
+"2007-06-02 10:00:00",6
+"2007-06-02 11:00:00",6
+"2007-06-02 12:00:00",6
+"2007-06-02 13:00:00",6
+"2007-06-02 14:00:00",6
+"2007-06-02 15:00:00",6
+"2007-06-02 16:00:00",6
+"2007-06-02 17:00:00",6
+"2007-06-02 18:00:00",6
+"2007-06-02 19:00:00",6
+"2007-06-02 20:00:00",6
+"2007-06-02 21:00:00",6
+"2007-06-02 22:00:00",6
+"2007-06-02 23:00:00",6
+"2007-06-03 00:00:00",6
+"2007-06-03 01:00:00",7
+"2007-06-03 02:00:00",7
+"2007-06-03 03:00:00",7
+"2007-06-03 04:00:00",7
+"2007-06-03 05:00:00",7
+"2007-06-03 06:00:00",7
+"2007-06-03 07:00:00",7
+"2007-06-03 08:00:00",7
+"2007-06-03 09:00:00",7
+"2007-06-03 10:00:00",7
+"2007-06-03 11:00:00",7
+"2007-06-03 12:00:00",7
+"2007-06-03 13:00:00",7
+"2007-06-03 14:00:00",7
+"2007-06-03 15:00:00",7
+"2007-06-03 16:00:00",7
+"2007-06-03 17:00:00",7
+"2007-06-03 18:00:00",7
+"2007-06-03 19:00:00",7
+"2007-06-03 20:00:00",7
+"2007-06-03 21:00:00",7
+"2007-06-03 22:00:00",7
+"2007-06-03 23:00:00",7
+"2007-06-04 00:00:00",7
+"2007-06-04 01:00:00",1
+"2007-06-04 02:00:00",1
+"2007-06-04 03:00:00",1
+"2007-06-04 04:00:00",1
+"2007-06-04 05:00:00",1
+"2007-06-04 06:00:00",1
+"2007-06-04 07:00:00",1
+"2007-06-04 08:00:00",1
+"2007-06-04 09:00:00",1
+"2007-06-04 10:00:00",1
+"2007-06-04 11:00:00",1
+"2007-06-04 12:00:00",1
+"2007-06-04 13:00:00",1
+"2007-06-04 14:00:00",1
+"2007-06-04 15:00:00",1
+"2007-06-04 16:00:00",1
+"2007-06-04 17:00:00",1
+"2007-06-04 18:00:00",1
+"2007-06-04 19:00:00",1
+"2007-06-04 20:00:00",1
+"2007-06-04 21:00:00",1
+"2007-06-04 22:00:00",1
+"2007-06-04 23:00:00",1
+"2007-06-05 00:00:00",1
+"2007-06-05 01:00:00",2
+"2007-06-05 02:00:00",2
+"2007-06-05 03:00:00",2
+"2007-06-05 04:00:00",2
+"2007-06-05 05:00:00",2
+"2007-06-05 06:00:00",2
+"2007-06-05 07:00:00",2
+"2007-06-05 08:00:00",2
+"2007-06-05 09:00:00",2
+"2007-06-05 10:00:00",2
+"2007-06-05 11:00:00",2
+"2007-06-05 12:00:00",2
+"2007-06-05 13:00:00",2
+"2007-06-05 14:00:00",2
+"2007-06-05 15:00:00",2
+"2007-06-05 16:00:00",2
+"2007-06-05 17:00:00",2
+"2007-06-05 18:00:00",2
+"2007-06-05 19:00:00",2
+"2007-06-05 20:00:00",2
+"2007-06-05 21:00:00",2
+"2007-06-05 22:00:00",2
+"2007-06-05 23:00:00",2
+"2007-06-06 00:00:00",2
+"2007-06-06 01:00:00",3
+"2007-06-06 02:00:00",3
+"2007-06-06 03:00:00",3
+"2007-06-06 04:00:00",3
+"2007-06-06 05:00:00",3
+"2007-06-06 06:00:00",3
+"2007-06-06 07:00:00",3
+"2007-06-06 08:00:00",3
+"2007-06-06 09:00:00",3
+"2007-06-06 10:00:00",3
+"2007-06-06 11:00:00",3
+"2007-06-06 12:00:00",3
+"2007-06-06 13:00:00",3
+"2007-06-06 14:00:00",3
+"2007-06-06 15:00:00",3
+"2007-06-06 16:00:00",3
+"2007-06-06 17:00:00",3
+"2007-06-06 18:00:00",3
+"2007-06-06 19:00:00",3
+"2007-06-06 20:00:00",3
+"2007-06-06 21:00:00",3
+"2007-06-06 22:00:00",3
+"2007-06-06 23:00:00",3
+"2007-06-07 00:00:00",3
+"2007-06-07 01:00:00",4
+"2007-06-07 02:00:00",4
+"2007-06-07 03:00:00",4
+"2007-06-07 04:00:00",4
+"2007-06-07 05:00:00",4
+"2007-06-07 06:00:00",4
+"2007-06-07 07:00:00",4
+"2007-06-07 08:00:00",4
+"2007-06-07 09:00:00",4
+"2007-06-07 10:00:00",4
+"2007-06-07 11:00:00",4
+"2007-06-07 12:00:00",4
+"2007-06-07 13:00:00",4
+"2007-06-07 14:00:00",4
+"2007-06-07 15:00:00",4
+"2007-06-07 16:00:00",4
+"2007-06-07 17:00:00",4
+"2007-06-07 18:00:00",4
+"2007-06-07 19:00:00",4
+"2007-06-07 20:00:00",4
+"2007-06-07 21:00:00",4
+"2007-06-07 22:00:00",4
+"2007-06-07 23:00:00",4
+"2007-06-08 00:00:00",4
+"2007-06-08 01:00:00",5
+"2007-06-08 02:00:00",5
+"2007-06-08 03:00:00",5
+"2007-06-08 04:00:00",5
+"2007-06-08 05:00:00",5
+"2007-06-08 06:00:00",5
+"2007-06-08 07:00:00",5
+"2007-06-08 08:00:00",5
+"2007-06-08 09:00:00",5
+"2007-06-08 10:00:00",5
+"2007-06-08 11:00:00",5
+"2007-06-08 12:00:00",5
+"2007-06-08 13:00:00",5
+"2007-06-08 14:00:00",5
+"2007-06-08 15:00:00",5
+"2007-06-08 16:00:00",5
+"2007-06-08 17:00:00",5
+"2007-06-08 18:00:00",5
+"2007-06-08 19:00:00",5
+"2007-06-08 20:00:00",5
+"2007-06-08 21:00:00",5
+"2007-06-08 22:00:00",5
+"2007-06-08 23:00:00",5
+"2007-06-09 00:00:00",5
+"2007-06-09 01:00:00",6
+"2007-06-09 02:00:00",6
+"2007-06-09 03:00:00",6
+"2007-06-09 04:00:00",6
+"2007-06-09 05:00:00",6
+"2007-06-09 06:00:00",6
+"2007-06-09 07:00:00",6
+"2007-06-09 08:00:00",6
+"2007-06-09 09:00:00",6
+"2007-06-09 10:00:00",6
+"2007-06-09 11:00:00",6
+"2007-06-09 12:00:00",6
+"2007-06-09 13:00:00",6
+"2007-06-09 14:00:00",6
+"2007-06-09 15:00:00",6
+"2007-06-09 16:00:00",6
+"2007-06-09 17:00:00",6
+"2007-06-09 18:00:00",6
+"2007-06-09 19:00:00",6
+"2007-06-09 20:00:00",6
+"2007-06-09 21:00:00",6
+"2007-06-09 22:00:00",6
+"2007-06-09 23:00:00",6
+"2007-06-10 00:00:00",6
+"2007-06-10 01:00:00",7
+"2007-06-10 02:00:00",7
+"2007-06-10 03:00:00",7
+"2007-06-10 04:00:00",7
+"2007-06-10 05:00:00",7
+"2007-06-10 06:00:00",7
+"2007-06-10 07:00:00",7
+"2007-06-10 08:00:00",7
+"2007-06-10 09:00:00",7
+"2007-06-10 10:00:00",7
+"2007-06-10 11:00:00",7
+"2007-06-10 12:00:00",7
+"2007-06-10 13:00:00",7
+"2007-06-10 14:00:00",7
+"2007-06-10 15:00:00",7
+"2007-06-10 16:00:00",7
+"2007-06-10 17:00:00",7
+"2007-06-10 18:00:00",7
+"2007-06-10 19:00:00",7
+"2007-06-10 20:00:00",7
+"2007-06-10 21:00:00",7
+"2007-06-10 22:00:00",7
+"2007-06-10 23:00:00",7
+"2007-06-11 00:00:00",7
+"2007-06-11 01:00:00",1
+"2007-06-11 02:00:00",1
+"2007-06-11 03:00:00",1
+"2007-06-11 04:00:00",1
+"2007-06-11 05:00:00",1
+"2007-06-11 06:00:00",1
+"2007-06-11 07:00:00",1
+"2007-06-11 08:00:00",1
+"2007-06-11 09:00:00",1
+"2007-06-11 10:00:00",1
+"2007-06-11 11:00:00",1
+"2007-06-11 12:00:00",1
+"2007-06-11 13:00:00",1
+"2007-06-11 14:00:00",1
+"2007-06-11 15:00:00",1
+"2007-06-11 16:00:00",1
+"2007-06-11 17:00:00",1
+"2007-06-11 18:00:00",1
+"2007-06-11 19:00:00",1
+"2007-06-11 20:00:00",1
+"2007-06-11 21:00:00",1
+"2007-06-11 22:00:00",1
+"2007-06-11 23:00:00",1
+"2007-06-12 00:00:00",1
+"2007-06-12 01:00:00",2
+"2007-06-12 02:00:00",2
+"2007-06-12 03:00:00",2
+"2007-06-12 04:00:00",2
+"2007-06-12 05:00:00",2
+"2007-06-12 06:00:00",2
+"2007-06-12 07:00:00",2
+"2007-06-12 08:00:00",2
+"2007-06-12 09:00:00",2
+"2007-06-12 10:00:00",2
+"2007-06-12 11:00:00",2
+"2007-06-12 12:00:00",2
+"2007-06-12 13:00:00",2
+"2007-06-12 14:00:00",2
+"2007-06-12 15:00:00",2
+"2007-06-12 16:00:00",2
+"2007-06-12 17:00:00",2
+"2007-06-12 18:00:00",2
+"2007-06-12 19:00:00",2
+"2007-06-12 20:00:00",2
+"2007-06-12 21:00:00",2
+"2007-06-12 22:00:00",2
+"2007-06-12 23:00:00",2
+"2007-06-13 00:00:00",2
+"2007-06-13 01:00:00",3
+"2007-06-13 02:00:00",3
+"2007-06-13 03:00:00",3
+"2007-06-13 04:00:00",3
+"2007-06-13 05:00:00",3
+"2007-06-13 06:00:00",3
+"2007-06-13 07:00:00",3
+"2007-06-13 08:00:00",3
+"2007-06-13 09:00:00",3
+"2007-06-13 10:00:00",3
+"2007-06-13 11:00:00",3
+"2007-06-13 12:00:00",3
+"2007-06-13 13:00:00",3
+"2007-06-13 14:00:00",3
+"2007-06-13 15:00:00",3
+"2007-06-13 16:00:00",3
+"2007-06-13 17:00:00",3
+"2007-06-13 18:00:00",3
+"2007-06-13 19:00:00",3
+"2007-06-13 20:00:00",3
+"2007-06-13 21:00:00",3
+"2007-06-13 22:00:00",3
+"2007-06-13 23:00:00",3
+"2007-06-14 00:00:00",3
+"2007-06-14 01:00:00",4
+"2007-06-14 02:00:00",4
+"2007-06-14 03:00:00",4
+"2007-06-14 04:00:00",4
+"2007-06-14 05:00:00",4
+"2007-06-14 06:00:00",4
+"2007-06-14 07:00:00",4
+"2007-06-14 08:00:00",4
+"2007-06-14 09:00:00",4
+"2007-06-14 10:00:00",4
+"2007-06-14 11:00:00",4
+"2007-06-14 12:00:00",4
+"2007-06-14 13:00:00",4
+"2007-06-14 14:00:00",4
+"2007-06-14 15:00:00",4
+"2007-06-14 16:00:00",4
+"2007-06-14 17:00:00",4
+"2007-06-14 18:00:00",4
+"2007-06-14 19:00:00",4
+"2007-06-14 20:00:00",4
+"2007-06-14 21:00:00",4
+"2007-06-14 22:00:00",4
+"2007-06-14 23:00:00",4
+"2007-06-15 00:00:00",4
+"2007-06-15 01:00:00",5
+"2007-06-15 02:00:00",5
+"2007-06-15 03:00:00",5
+"2007-06-15 04:00:00",5
+"2007-06-15 05:00:00",5
+"2007-06-15 06:00:00",5
+"2007-06-15 07:00:00",5
+"2007-06-15 08:00:00",5
+"2007-06-15 09:00:00",5
+"2007-06-15 10:00:00",5
+"2007-06-15 11:00:00",5
+"2007-06-15 12:00:00",5
+"2007-06-15 13:00:00",5
+"2007-06-15 14:00:00",5
+"2007-06-15 15:00:00",5
+"2007-06-15 16:00:00",5
+"2007-06-15 17:00:00",5
+"2007-06-15 18:00:00",5
+"2007-06-15 19:00:00",5
+"2007-06-15 20:00:00",5
+"2007-06-15 21:00:00",5
+"2007-06-15 22:00:00",5
+"2007-06-15 23:00:00",5
+"2007-06-16 00:00:00",5
+"2007-06-16 01:00:00",6
+"2007-06-16 02:00:00",6
+"2007-06-16 03:00:00",6
+"2007-06-16 04:00:00",6
+"2007-06-16 05:00:00",6
+"2007-06-16 06:00:00",6
+"2007-06-16 07:00:00",6
+"2007-06-16 08:00:00",6
+"2007-06-16 09:00:00",6
+"2007-06-16 10:00:00",6
+"2007-06-16 11:00:00",6
+"2007-06-16 12:00:00",6
+"2007-06-16 13:00:00",6
+"2007-06-16 14:00:00",6
+"2007-06-16 15:00:00",6
+"2007-06-16 16:00:00",6
+"2007-06-16 17:00:00",6
+"2007-06-16 18:00:00",6
+"2007-06-16 19:00:00",6
+"2007-06-16 20:00:00",6
+"2007-06-16 21:00:00",6
+"2007-06-16 22:00:00",6
+"2007-06-16 23:00:00",6
+"2007-06-17 00:00:00",6
+"2007-06-17 01:00:00",7
+"2007-06-17 02:00:00",7
+"2007-06-17 03:00:00",7
+"2007-06-17 04:00:00",7
+"2007-06-17 05:00:00",7
+"2007-06-17 06:00:00",7
+"2007-06-17 07:00:00",7
+"2007-06-17 08:00:00",7
+"2007-06-17 09:00:00",7
+"2007-06-17 10:00:00",7
+"2007-06-17 11:00:00",7
+"2007-06-17 12:00:00",7
+"2007-06-17 13:00:00",7
+"2007-06-17 14:00:00",7
+"2007-06-17 15:00:00",7
+"2007-06-17 16:00:00",7
+"2007-06-17 17:00:00",7
+"2007-06-17 18:00:00",7
+"2007-06-17 19:00:00",7
+"2007-06-17 20:00:00",7
+"2007-06-17 21:00:00",7
+"2007-06-17 22:00:00",7
+"2007-06-17 23:00:00",7
+"2007-06-18 00:00:00",7
+"2007-06-18 01:00:00",1
+"2007-06-18 02:00:00",1
+"2007-06-18 03:00:00",1
+"2007-06-18 04:00:00",1
+"2007-06-18 05:00:00",1
+"2007-06-18 06:00:00",1
+"2007-06-18 07:00:00",1
+"2007-06-18 08:00:00",1
+"2007-06-18 09:00:00",1
+"2007-06-18 10:00:00",1
+"2007-06-18 11:00:00",1
+"2007-06-18 12:00:00",1
+"2007-06-18 13:00:00",1
+"2007-06-18 14:00:00",1
+"2007-06-18 15:00:00",1
+"2007-06-18 16:00:00",1
+"2007-06-18 17:00:00",1
+"2007-06-18 18:00:00",1
+"2007-06-18 19:00:00",1
+"2007-06-18 20:00:00",1
+"2007-06-18 21:00:00",1
+"2007-06-18 22:00:00",1
+"2007-06-18 23:00:00",1
+"2007-06-19 00:00:00",1
+"2007-06-19 01:00:00",2
+"2007-06-19 02:00:00",2
+"2007-06-19 03:00:00",2
+"2007-06-19 04:00:00",2
+"2007-06-19 05:00:00",2
+"2007-06-19 06:00:00",2
+"2007-06-19 07:00:00",2
+"2007-06-19 08:00:00",2
+"2007-06-19 09:00:00",2
+"2007-06-19 10:00:00",2
+"2007-06-19 11:00:00",2
+"2007-06-19 12:00:00",2
+"2007-06-19 13:00:00",2
+"2007-06-19 14:00:00",2
+"2007-06-19 15:00:00",2
+"2007-06-19 16:00:00",2
+"2007-06-19 17:00:00",2
+"2007-06-19 18:00:00",2
+"2007-06-19 19:00:00",2
+"2007-06-19 20:00:00",2
+"2007-06-19 21:00:00",2
+"2007-06-19 22:00:00",2
+"2007-06-19 23:00:00",2
+"2007-06-20 00:00:00",2
+"2007-06-20 01:00:00",3
+"2007-06-20 02:00:00",3
+"2007-06-20 03:00:00",3
+"2007-06-20 04:00:00",3
+"2007-06-20 05:00:00",3
+"2007-06-20 06:00:00",3
+"2007-06-20 07:00:00",3
+"2007-06-20 08:00:00",3
+"2007-06-20 09:00:00",3
+"2007-06-20 10:00:00",3
+"2007-06-20 11:00:00",3
+"2007-06-20 12:00:00",3
+"2007-06-20 13:00:00",3
+"2007-06-20 14:00:00",3
+"2007-06-20 15:00:00",3
+"2007-06-20 16:00:00",3
+"2007-06-20 17:00:00",3
+"2007-06-20 18:00:00",3
+"2007-06-20 19:00:00",3
+"2007-06-20 20:00:00",3
+"2007-06-20 21:00:00",3
+"2007-06-20 22:00:00",3
+"2007-06-20 23:00:00",3
+"2007-06-21 00:00:00",3
+"2007-06-21 01:00:00",4
+"2007-06-21 02:00:00",4
+"2007-06-21 03:00:00",4
+"2007-06-21 04:00:00",4
+"2007-06-21 05:00:00",4
+"2007-06-21 06:00:00",4
+"2007-06-21 07:00:00",4
+"2007-06-21 08:00:00",4
+"2007-06-21 09:00:00",4
+"2007-06-21 10:00:00",4
+"2007-06-21 11:00:00",4
+"2007-06-21 12:00:00",4
+"2007-06-21 13:00:00",4
+"2007-06-21 14:00:00",4
+"2007-06-21 15:00:00",4
+"2007-06-21 16:00:00",4
+"2007-06-21 17:00:00",4
+"2007-06-21 18:00:00",4
+"2007-06-21 19:00:00",4
+"2007-06-21 20:00:00",4
+"2007-06-21 21:00:00",4
+"2007-06-21 22:00:00",4
+"2007-06-21 23:00:00",4
+"2007-06-22 00:00:00",4
+"2007-06-22 01:00:00",5
+"2007-06-22 02:00:00",5
+"2007-06-22 03:00:00",5
+"2007-06-22 04:00:00",5
+"2007-06-22 05:00:00",5
+"2007-06-22 06:00:00",5
+"2007-06-22 07:00:00",5
+"2007-06-22 08:00:00",5
+"2007-06-22 09:00:00",5
+"2007-06-22 10:00:00",5
+"2007-06-22 11:00:00",5
+"2007-06-22 12:00:00",5
+"2007-06-22 13:00:00",5
+"2007-06-22 14:00:00",5
+"2007-06-22 15:00:00",5
+"2007-06-22 16:00:00",5
+"2007-06-22 17:00:00",5
+"2007-06-22 18:00:00",5
+"2007-06-22 19:00:00",5
+"2007-06-22 20:00:00",5
+"2007-06-22 21:00:00",5
+"2007-06-22 22:00:00",5
+"2007-06-22 23:00:00",5
+"2007-06-23 00:00:00",5
+"2007-06-23 01:00:00",6
+"2007-06-23 02:00:00",6
+"2007-06-23 03:00:00",6
+"2007-06-23 04:00:00",6
+"2007-06-23 05:00:00",6
+"2007-06-23 06:00:00",6
+"2007-06-23 07:00:00",6
+"2007-06-23 08:00:00",6
+"2007-06-23 09:00:00",6
+"2007-06-23 10:00:00",6
+"2007-06-23 11:00:00",6
+"2007-06-23 12:00:00",6
+"2007-06-23 13:00:00",6
+"2007-06-23 14:00:00",6
+"2007-06-23 15:00:00",6
+"2007-06-23 16:00:00",6
+"2007-06-23 17:00:00",6
+"2007-06-23 18:00:00",6
+"2007-06-23 19:00:00",6
+"2007-06-23 20:00:00",6
+"2007-06-23 21:00:00",6
+"2007-06-23 22:00:00",6
+"2007-06-23 23:00:00",6
+"2007-06-24 00:00:00",6
+"2007-06-24 01:00:00",7
+"2007-06-24 02:00:00",7
+"2007-06-24 03:00:00",7
+"2007-06-24 04:00:00",7
+"2007-06-24 05:00:00",7
+"2007-06-24 06:00:00",7
+"2007-06-24 07:00:00",7
+"2007-06-24 08:00:00",7
+"2007-06-24 09:00:00",7
+"2007-06-24 10:00:00",7
+"2007-06-24 11:00:00",7
+"2007-06-24 12:00:00",7
+"2007-06-24 13:00:00",7
+"2007-06-24 14:00:00",7
+"2007-06-24 15:00:00",7
+"2007-06-24 16:00:00",7
+"2007-06-24 17:00:00",7
+"2007-06-24 18:00:00",7
+"2007-06-24 19:00:00",7
+"2007-06-24 20:00:00",7
+"2007-06-24 21:00:00",7
+"2007-06-24 22:00:00",7
+"2007-06-24 23:00:00",7
+"2007-06-25 00:00:00",7
+"2007-06-25 01:00:00",1
+"2007-06-25 02:00:00",1
+"2007-06-25 03:00:00",1
+"2007-06-25 04:00:00",1
+"2007-06-25 05:00:00",1
+"2007-06-25 06:00:00",1
+"2007-06-25 07:00:00",1
+"2007-06-25 08:00:00",1
+"2007-06-25 09:00:00",1
+"2007-06-25 10:00:00",1
+"2007-06-25 11:00:00",1
+"2007-06-25 12:00:00",1
+"2007-06-25 13:00:00",1
+"2007-06-25 14:00:00",1
+"2007-06-25 15:00:00",1
+"2007-06-25 16:00:00",1
+"2007-06-25 17:00:00",1
+"2007-06-25 18:00:00",1
+"2007-06-25 19:00:00",1
+"2007-06-25 20:00:00",1
+"2007-06-25 21:00:00",1
+"2007-06-25 22:00:00",1
+"2007-06-25 23:00:00",1
+"2007-06-26 00:00:00",1
+"2007-06-26 01:00:00",2
+"2007-06-26 02:00:00",2
+"2007-06-26 03:00:00",2
+"2007-06-26 04:00:00",2
+"2007-06-26 05:00:00",2
+"2007-06-26 06:00:00",2
+"2007-06-26 07:00:00",2
+"2007-06-26 08:00:00",2
+"2007-06-26 09:00:00",2
+"2007-06-26 10:00:00",2
+"2007-06-26 11:00:00",2
+"2007-06-26 12:00:00",2
+"2007-06-26 13:00:00",2
+"2007-06-26 14:00:00",2
+"2007-06-26 15:00:00",2
+"2007-06-26 16:00:00",2
+"2007-06-26 17:00:00",2
+"2007-06-26 18:00:00",2
+"2007-06-26 19:00:00",2
+"2007-06-26 20:00:00",2
+"2007-06-26 21:00:00",2
+"2007-06-26 22:00:00",2
+"2007-06-26 23:00:00",2
+"2007-06-27 00:00:00",2
+"2007-06-27 01:00:00",3
+"2007-06-27 02:00:00",3
+"2007-06-27 03:00:00",3
+"2007-06-27 04:00:00",3
+"2007-06-27 05:00:00",3
+"2007-06-27 06:00:00",3
+"2007-06-27 07:00:00",3
+"2007-06-27 08:00:00",3
+"2007-06-27 09:00:00",3
+"2007-06-27 10:00:00",3
+"2007-06-27 11:00:00",3
+"2007-06-27 12:00:00",3
+"2007-06-27 13:00:00",3
+"2007-06-27 14:00:00",3
+"2007-06-27 15:00:00",3
+"2007-06-27 16:00:00",3
+"2007-06-27 17:00:00",3
+"2007-06-27 18:00:00",3
+"2007-06-27 19:00:00",3
+"2007-06-27 20:00:00",3
+"2007-06-27 21:00:00",3
+"2007-06-27 22:00:00",3
+"2007-06-27 23:00:00",3
+"2007-06-28 00:00:00",3
+"2007-06-28 01:00:00",4
+"2007-06-28 02:00:00",4
+"2007-06-28 03:00:00",4
+"2007-06-28 04:00:00",4
+"2007-06-28 05:00:00",4
+"2007-06-28 06:00:00",4
+"2007-06-28 07:00:00",4
+"2007-06-28 08:00:00",4
+"2007-06-28 09:00:00",4
+"2007-06-28 10:00:00",4
+"2007-06-28 11:00:00",4
+"2007-06-28 12:00:00",4
+"2007-06-28 13:00:00",4
+"2007-06-28 14:00:00",4
+"2007-06-28 15:00:00",4
+"2007-06-28 16:00:00",4
+"2007-06-28 17:00:00",4
+"2007-06-28 18:00:00",4
+"2007-06-28 19:00:00",4
+"2007-06-28 20:00:00",4
+"2007-06-28 21:00:00",4
+"2007-06-28 22:00:00",4
+"2007-06-28 23:00:00",4
+"2007-06-29 00:00:00",4
+"2007-06-29 01:00:00",5
+"2007-06-29 02:00:00",5
+"2007-06-29 03:00:00",5
+"2007-06-29 04:00:00",5
+"2007-06-29 05:00:00",5
+"2007-06-29 06:00:00",5
+"2007-06-29 07:00:00",5
+"2007-06-29 08:00:00",5
+"2007-06-29 09:00:00",5
+"2007-06-29 10:00:00",5
+"2007-06-29 11:00:00",5
+"2007-06-29 12:00:00",5
+"2007-06-29 13:00:00",5
+"2007-06-29 14:00:00",5
+"2007-06-29 15:00:00",5
+"2007-06-29 16:00:00",5
+"2007-06-29 17:00:00",5
+"2007-06-29 18:00:00",5
+"2007-06-29 19:00:00",5
+"2007-06-29 20:00:00",5
+"2007-06-29 21:00:00",5
+"2007-06-29 22:00:00",5
+"2007-06-29 23:00:00",5
+"2007-06-30 00:00:00",5
+"2007-06-30 01:00:00",6
+"2007-06-30 02:00:00",6
+"2007-06-30 03:00:00",6
+"2007-06-30 04:00:00",6
+"2007-06-30 05:00:00",6
+"2007-06-30 06:00:00",6
+"2007-06-30 07:00:00",6
+"2007-06-30 08:00:00",6
+"2007-06-30 09:00:00",6
+"2007-06-30 10:00:00",6
+"2007-06-30 11:00:00",6
+"2007-06-30 12:00:00",6
+"2007-06-30 13:00:00",6
+"2007-06-30 14:00:00",6
+"2007-06-30 15:00:00",6
+"2007-06-30 16:00:00",6
+"2007-06-30 17:00:00",6
+"2007-06-30 18:00:00",6
+"2007-06-30 19:00:00",6
+"2007-06-30 20:00:00",6
+"2007-06-30 21:00:00",6
+"2007-06-30 22:00:00",6
+"2007-06-30 23:00:00",6
+"2007-07-01 00:00:00",6
+"2007-07-01 01:00:00",7
+"2007-07-01 02:00:00",7
+"2007-07-01 03:00:00",7
+"2007-07-01 04:00:00",7
+"2007-07-01 05:00:00",7
+"2007-07-01 06:00:00",7
+"2007-07-01 07:00:00",7
+"2007-07-01 08:00:00",7
+"2007-07-01 09:00:00",7
+"2007-07-01 10:00:00",7
+"2007-07-01 11:00:00",7
+"2007-07-01 12:00:00",7
+"2007-07-01 13:00:00",7
+"2007-07-01 14:00:00",7
+"2007-07-01 15:00:00",7
+"2007-07-01 16:00:00",7
+"2007-07-01 17:00:00",7
+"2007-07-01 18:00:00",7
+"2007-07-01 19:00:00",7
+"2007-07-01 20:00:00",7
+"2007-07-01 21:00:00",7
+"2007-07-01 22:00:00",7
+"2007-07-01 23:00:00",7
+"2007-07-02 00:00:00",7

diff --git a/pkg/tests/testthat/test.Forecaster.R b/pkg/tests/testthat/test.Forecaster.R
index 0986a3d..6387827 100644 (file)
--- a/pkg/tests/testthat/test.Forecaster.R
+++ b/pkg/tests/testthat/test.Forecaster.R
@@ -1,35 +1,90 @@
 context("Check that forecasters behave as expected")
 
-test_that("Average+Zero method behave as expected",
+ts_data = system.file("testdata","ts_test.csv",package="talweg")
+exo_data = system.file("testdata","exo_test.csv",package="talweg")
+data00 <<- getData(ts_data, exo_data, input_tz="GMT", date_format="%Y-%m-%d %H:%M",
+       working_tz="GMT", predict_at=0, limit=Inf)
+data13 <<- getData(ts_data, exo_data, input_tz="GMT", date_format="%Y-%m-%d %H:%M",
+       working_tz="GMT", predict_at=13, limit=Inf)
+#Forecast at sunday to saturday, for monday to sunday
+indices <<- seq(as.Date("2007-04-01"),as.Date("2007-04-07"),"days")
+
+test_that("Average method behave as expected",
 {
-       ts_data = system.file("testdata","ts",package="talweg")
-       exo_data = system.file("testdata","exo",package="talweg")
+       pred00_z = getForecast(data00, indices, "Average", "Zero",        Inf, 24)
+       pred00_p = getForecast(data00, indices, "Average", "Persistence", Inf, 24)
+       for (i in seq_along(indices))
+       {
+               #zero jump: should predict true values minus 1
+               expect_identical(pred00_z$getSerie(i), rep(i,24))
+               #persistence jump == 1: should predict true values
+               expect_identical(pred00_p$getSerie(i), rep(i%%7+1,24))
+       }
+
+       #NOTE: days become
+       #1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 (14h-->0h then 1h-->13h)
+       #No jump between days, thus zero and persistence are equivalent (and wrong)
+       pred13_z = getForecast(data13, indices, "Average", "Zero",        Inf, 24)
+       pred13_p = getForecast(data13, indices, "Average", "Persistence", Inf, 24)
+       prediction = c(rep(-13/24,11),rep(11/24,13))
+       for (i in seq_along(indices))
+       {
+               expect_equal(pred13_z$getSerie(i), prediction )
+               expect_equal(pred13_p$getSerie(i), prediction )
+       }
 
-       data0 = getData(ts_data, exo_data, input_tz="GMT", date_format="%Y-%m-%d %H:%M",
-               working_tz="GMT", predict_at=0, limit=Inf)
-       #TODO: with and without shift at origin (so series values at least forst ones are required)
+       #A few extra checks
+       expect_identical( pred00_sd$getIndexInData(1), dateIndexToInteger("2007-04-01",data00) )
+       expect_identical( pred13_dd$getIndexInData(3), dateIndexToInteger("2007-04-03",data13) )
+       expect_identical( pred00_dd$getIndexInData(5), dateIndexToInteger("2007-04-05",data00) )
+})
+
+test_that("Persistence method behave as expected",
+{
+       #Situation A: +Zero; always wrong
+       pred00_sd = getForecast(data00, indices, "Persistence", "Zero", Inf, 24, same_day=TRUE)
+       pred00_dd = getForecast(data00, indices, "Persistence", "Zero", Inf, 24, same_day=FALSE)
+       for (i in seq_along(indices))
+       {
+               expect_identical(pred00_sd$getSerie(i), rep(i,24))
+               expect_identical(pred00_dd$getSerie(i), rep(i,24))
+       }
 
-       indices = ...
-       pred0 = getForecast(.......)
+       pred13_sd = getForecast(data13, indices, "Persistence", "Zero", Inf, 24, same_day=TRUE)
+       pred13_dd = getForecast(data13, indices, "Persistence", "Zero", Inf, 24, same_day=FALSE)
+       for (i in seq_along(indices))
+       {
+               expect_identical(pred13_sd$getSerie(i), c( rep(i,11), rep(i%%7+1,13) ) )
+               expect_identical(pred13_dd$getSerie(i), c( rep(i,11), rep(i%%7+1,13) ) )
+       }
 
+       #Situation B: +Persistence, correct when predict_at==0
+       pred00_sd = getForecast(data00, indices, "Persistence", "Persistence", Inf, 24, same_day=TRUE)
+       pred00_dd = getForecast(data00, indices, "Persistence", "Persistence", Inf, 24, same_day=FALSE)
        for (i in seq_along(indices))
        {
-               expect_identical(....)
+               expect_identical(pred00_sd$getSerie(i), rep(i%%7+1,24))
+               expect_identical(pred00_dd$getSerie(i), rep(i%%7+1,24))
        }
 
-       data13 = getData(ts_data, exo_data, input_tz="GMT", date_format="%Y-%m-%d %H:%M",
-               working_tz="GMT", predict_at=13, limit=Inf)
-       #Attention: jours deviennent 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 (14h-->0h puis 1h-->13h)
-}
+       pred13_sd = getForecast(data13, indices, "Persistence", "Persistence", Inf, 24, same_day=TRUE)
+       pred13_dd = getForecast(data13, indices, "Persistence", "Persistence", Inf, 24, same_day=FALSE)
+       for (i in seq_along(indices))
+       {
+               expect_identical(pred13_sd$getSerie(i), c( rep(i,11), rep(i%%7+1,13) ) )
+               expect_identical(pred13_dd$getSerie(i), c( rep(i,11), rep(i%%7+1,13) ) )
+       }
 
-test_that("Persistence+Zero method behave as expected",
-{
-}
+       #A few extra checks
+       expect_identical( pred13_sd$getIndexInData(1), dateIndexToInteger("2007-04-01",data12) )
+       expect_identical( pred00_dd$getIndexInData(3), dateIndexToInteger("2007-04-03",data00) )
+       expect_identical( pred13_dd$getIndexInData(5), dateIndexToInteger("2007-04-05",data13) )
+})
 
 test_that("Neighbors+Zero method behave as expected",
 {
-}
+})
 
 test_that("Neighbors+Neighbors method behave as expected",
 {
-}
+})

diff --git a/pkg/tests/testthat/test.computeFilaments.R b/pkg/tests/testthat/test.computeFilaments.R
index e8f8752..15b41b7 100644 (file)
--- a/pkg/tests/testthat/test.computeFilaments.R
+++ b/pkg/tests/testthat/test.computeFilaments.R
@@ -1,5 +1,6 @@
 context("Check that computeFilaments behaves as expected")
 
+#MOCK data; NOTE: could be in inst/testdata as well
 getDataTest = function(n, shift)
 {
        x = seq(0,10,0.1)
@@ -14,9 +15,9 @@ getDataTest = function(n, shift)
        series = list()
        for (i in seq_len(n))
        {
-               index = (i%%3) + 1
+               index = (i-1) %% 3 + 1 #map 1->1, 2->2, 3->3, 4->1, ..., 149->2, 150->3
                level = mean(s[[index]])
-               serie = s[[index]] - level + rnorm(L,sd=0.05)
+               serie = s[[index]] - level + rnorm(L,sd=0.01)
                # 10 series with NAs for index 2
                if (index == 2 && i >= 60 && i<= 90)
                        serie[sample(seq_len(L),1)] = NA
@@ -31,73 +32,81 @@ getDataTest = function(n, shift)
        new("Data", data=series)
 }
 
-test_that("output is as expected on simulated series",
+test_that("output is as expected on simulated series, predict_at == 0",
 {
-       data = getDataTest(150, FALSE)
+       data = getDataTest(150, shift=FALSE)
 
-       # index 142 : serie type 2
-       f = computeFilaments(data, 142, limit=60, plot=FALSE)
-       # Expected output: 22 series of type 3 (closer), then 50-2-10 series of type 2
-       expect_identical(length(f$indices), 60)
-       expect_identical(length(f$colors), 60)
-       for (i in 1:22)
+       # index 143 : serie type 2
+       f = computeFilaments(data, 143, limit=60, plot=FALSE)
+       # Expected output: 23 series of type 3 (closer), then 50-3-10 series of type 2, then index 143
+       expect_identical(length(f$indices), as.integer(61)) #61 because result also contain "today"
+       expect_identical(length(f$colors),  as.integer(61))
+       for (i in 1:23)
        {
-               expect_identical((f$indices[i] %% 3) + 1, 3)
-               expect_match(f2$colors[i], f$colors[1])
+               expect_equal((f$indices[i]-1) %% 3 + 1, 3)
+               expect_match(f$colors[i], f$colors[1])
        }
-       for (i in 23:60)
+       for (i in 24:60)
        {
-               expect_identical((f$indices[i] %% 3) + 1, 2)
-               expect_match(f2$colors[i], f$colors[23])
+               expect_equal((f$indices[i]-1) %% 3 + 1, 2)
+               expect_match(f$colors[i], f$colors[24])
        }
-       expect_match(colors[1], "...")
-       expect_match(colors[23], "...")
+       expect_equal(f$indices[61], 143)
+       expect_match(f$colors[61], "#FF0000") #special color: current day in red
+       expect_match(f$colors[1], "#E*")
+       expect_match(f$colors[24], "#1*")
 })
 
-test_that("output is as expected on simulated series",
+test_that("output is as expected on simulated series, predict_at > 0",
 {
-       data = getDataTest(150, TRUE)
+       data = getDataTest(150, shift=TRUE)
 
-       # index 143 : serie type 3
-       f = computeFilaments(data, 143, limit=70, plot=FALSE)
-       # Expected output: 22 series of type 2 (closer) then 50-2 series of type 3
-       expect_identical(length(f$indices), 70)
-       expect_identical(length(f$colors), 70)
-       for (i in 1:22)
+       # index 142 : serie type 3
+       f = computeFilaments(data, 142, limit=70, plot=FALSE)
+       # Expected output: 24 series of type 2 (closer) then 50-4 series of type 3, then 142
+       expect_identical(length(f$indices), as.integer(71))
+       expect_identical(length(f$colors), as.integer(71))
+       expect_true(all(f$indices >= 2)) #no type-1 neighbors
+       for (i in 1:24)
        {
-               # -1 because of the initial shift
-               expect_identical(( (f$indices[i]-1) %% 3 ) + 1, 2)
+               # -1 + -1 because of the initial shift
+               expect_equal((f$indices[i]-2) %% 3 + 1, 2)
                expect_match(f$colors[i], f$colors[1])
        }
-       for (i in 23:70)
+       for (i in 25:70)
        {
-               expect_identical(( (f$indices[i]-1) %% 3 ) + 1, 3)
-               expect_match(f$colors[i], f$colors[23])
+               expect_equal((f$indices[i]-2) %% 3 + 1, 3)
+               expect_match(f$colors[i], f$colors[25])
        }
-       expect_match(colors[1], "...")
-       expect_match(colors[23], "...")
+       expect_equal(f$indices[71], 142)
+       expect_match(f$colors[71], "#FF0000")
+       expect_match(f$colors[1], "#E*")
+       expect_match(f$colors[25], "#1*")
 })
 
 test_that("output is as expected on simulated series",
 {
-       data = getDataTest(150, TRUE)
+       data = getDataTest(150, shift=TRUE)
 
-       # index 144 : serie type 1
-       f = computeFilaments(data, 144, limit=50, plot=FALSE)
-       # Expected output: 2 series of type 3 (closer), then 50-2 series of type 1
-       expect_identical(length(f$indices), 50)
-       expect_identical(length(f$colors), 50)
-       for (i in 1:2)
+       # index 143 : serie type 1
+       f = computeFilaments(data, 143, limit=60, plot=FALSE)
+       # Expected output: 23 series of type 3 (closer), then 50-10-3 series of type 1, then 143
+       # NOTE: -10 because only past days with no-NAs tomorrow => exclude type 1 in [60,90[
+       expect_identical(length(f$indices), as.integer(61))
+       expect_identical(length(f$colors), as.integer(61))
+       expect_true(all(f$indices >= 2)) #first_day should be 2
+       for (i in 1:23)
        {
-               # -1 because of the initial shift
-               expect_identical(( (f$indices[i]-1) %% 3 ) + 1, 3)
+               expect_equal(( (f$indices[i]-2) %% 3 ) + 1, 3)
                expect_match(f$colors[i], f$colors[1])
        }
-       for (i in 3:50)
+       for (i in 24:60)
        {
-               expect_identical(( (f$indices[i]-1) %% 3 ) + 1, 1)
-               expect_match(f$colors[i], f$colors[3])
+               expect_equal(( (f$indices[i]-2) %% 3 ) + 1, 1)
+               expect_match(f$colors[i], f$colors[24])
        }
-       expect_match(colors[1], "...")
-       expect_match(colors[3], "...")
+       expect_equal(f$indices[61], 143)
+       expect_match(f$colors[61], "#FF0000")
+       expect_match(f$colors[1], "#E*")
+       expect_match(f$colors[24], "#1*")
 })

diff --git a/pkg/tests/testthat/test.dateIndexToInteger.R b/pkg/tests/testthat/test.dateIndexToInteger.R
index b2316dd..1826972 100644 (file)
--- a/pkg/tests/testthat/test.dateIndexToInteger.R
+++ b/pkg/tests/testthat/test.dateIndexToInteger.R
@@ -1,25 +1,84 @@
-context("Check that dateIndexToInteger behaves as expected")
+context("Check that date <--> integer indexes conversions work")
 
-test_that("computed integer index is correct; predict_at == 0",
+ts_data = system.file("testdata","ts_test.csv",package="talweg")
+exo_data = system.file("testdata","exo_test.csv",package="talweg")
+data0 <<- getData(ts_data, exo_data, input_tz="GMT", date_format="%Y-%m-%d %H:%M",
+       working_tz="GMT", predict_at=0, limit=Inf)
+data7 <<- getData(ts_data, exo_data, input_tz="GMT", date_format="%Y-%m-%d %H:%M",
+       working_tz="GMT", predict_at=7, limit=Inf)
+
+test_that("dateIndexToInteger, predict_at == 0",
+{
+       expect_identical( dateIndexToInteger("2007-01-01",data0),   1 )
+       expect_identical( dateIndexToInteger("2007-01-02",data0),   2 )
+       expect_identical( dateIndexToInteger("2007-02-01",data0),  32 )
+       expect_identical( dateIndexToInteger("2007-03-01",data0),  60 )
+       expect_identical( dateIndexToInteger("2007-05-31",data0), 151 )
+})
+
+test_that("dateIndexToInteger, predict_at > 0",
+{
+       expect_identical( dateIndexToInteger("2007-01-01",data7),   1 )
+       expect_identical( dateIndexToInteger("2007-01-02",data7),   3 )
+       expect_identical( dateIndexToInteger("2007-02-01",data7),  33 )
+       expect_identical( dateIndexToInteger("2007-03-01",data7),  61 )
+       expect_identical( dateIndexToInteger("2007-05-31",data7), 152 )
+})
+
+test_that("integerIndexToDate, predict_at == 0",
 {
-       data0 = getData(ts_data="pm10_mesures_H_loc.csv", exo_data="meteo_extra_noNAs.csv",
-               input_tz="Europe/Paris",working_tz="Europe/Paris", predict_at=0, limit=200)
-       expect_identical( dateIndexToInteger("2008-12-10",data), 1 )
-       expect_identical( dateIndexToInteger("2008-12-11",data), 2 )
-       expect_identical( dateIndexToInteger("2008-12-20",data), 11 )
-       expect_identical( dateIndexToInteger("2009-02-01",data), 53 )
-       expect_identical( dateIndexToInteger("2009-03-01",data), 81 )
-       expect_identical( dateIndexToInteger("2009-05-31",data), 172 )
+       expect_identical( integerIndexToDate(  1,data0), as.Date("2007-01-01") )
+       expect_identical( integerIndexToDate(  2,data0), as.Date("2007-01-02") )
+       expect_identical( integerIndexToDate( 32,data0), as.Date("2007-02-01") )
+       expect_identical( integerIndexToDate( 60,data0), as.Date("2007-03-01") )
+       expect_identical( integerIndexToDate(151,data0), as.Date("2007-05-31") )
 })
 
-test_that("computed integer index is correct; predict_at > 0",
+test_that("integerIndexToDate, predict_at > 0",
 {
-       data7 = getData(ts_data="pm10_mesures_H_loc.csv", exo_data="meteo_extra_noNAs.csv",
-               input_tz="Europe/Paris",working_tz="Europe/Paris", predict_at=7, limit=200)
-       expect_identical( dateIndexToInteger("2008-12-10",data), 2 )
-       expect_identical( dateIndexToInteger("2008-12-11",data), 3 )
-       expect_identical( dateIndexToInteger("2008-12-20",data), 12 )
-       expect_identical( dateIndexToInteger("2009-02-01",data), 54 )
-       expect_identical( dateIndexToInteger("2009-03-01",data), 82 )
-       expect_identical( dateIndexToInteger("2009-05-31",data), 173 )
-}
+       expect_identical( integerIndexToDate(  1,data7), as.Date("2007-01-01") )
+       expect_identical( integerIndexToDate(  2,data7), as.Date("2007-01-01") )
+       expect_identical( integerIndexToDate(  3,data7), as.Date("2007-01-02") )
+       expect_identical( integerIndexToDate( 33,data7), as.Date("2007-02-01") )
+       expect_identical( integerIndexToDate( 61,data7), as.Date("2007-03-01") )
+       expect_identical( integerIndexToDate(152,data7), as.Date("2007-05-31") )
+})
+
+test_that("dateIndexToInteger(integerIndexToDate) == Id",
+{
+       #always true except for second cell when predict_at>0: same date
+       expect_identical( dateIndexToInteger(integerIndexToDate(  1,data0),data0),   1 )
+       expect_identical( dateIndexToInteger(integerIndexToDate(  1,data7),data7),   1 )
+       expect_identical( dateIndexToInteger(integerIndexToDate(  2,data0),data0),   2 )
+       expect_identical( dateIndexToInteger(integerIndexToDate(  2,data7),data7),   1 )
+       expect_identical( dateIndexToInteger(integerIndexToDate( 32,data0),data0),  32 )
+       expect_identical( dateIndexToInteger(integerIndexToDate( 32,data7),data7),  32 )
+       expect_identical( dateIndexToInteger(integerIndexToDate( 60,data0),data0),  60 )
+       expect_identical( dateIndexToInteger(integerIndexToDate( 60,data7),data7),  60 )
+       expect_identical( dateIndexToInteger(integerIndexToDate(151,data0),data0), 151 )
+       expect_identical( dateIndexToInteger(integerIndexToDate(151,data7),data7), 151 )
+})
+
+test_that("integerIndexToDate(dateIndexToInteger) == Id",
+{
+       expect_identical(
+               integerIndexToDate(dateIndexToInteger("2007-01-01",data0),data0), as.Date("2007-01-01") )
+       expect_identical(
+               integerIndexToDate(dateIndexToInteger("2007-01-01",data7),data7), as.Date("2007-01-01") )
+       expect_identical(
+               integerIndexToDate(dateIndexToInteger("2007-01-02",data0),data0), as.Date("2007-01-02") )
+       expect_identical(
+               integerIndexToDate(dateIndexToInteger("2007-01-02",data7),data7), as.Date("2007-01-02") )
+       expect_identical(
+               integerIndexToDate(dateIndexToInteger("2007-02-01",data0),data0), as.Date("2007-02-01") )
+       expect_identical(
+               integerIndexToDate(dateIndexToInteger("2007-02-01",data0),data0), as.Date("2007-02-01") )
+       expect_identical(
+               integerIndexToDate(dateIndexToInteger("2007-03-01",data0),data0), as.Date("2007-03-01") )
+       expect_identical(
+               integerIndexToDate(dateIndexToInteger("2007-03-01",data0),data0), as.Date("2007-03-01") )
+       expect_identical(
+               integerIndexToDate(dateIndexToInteger("2007-05-31",data0),data0), as.Date("2007-05-31") )
+       expect_identical(
+               integerIndexToDate(dateIndexToInteger("2007-05-31",data0),data0), as.Date("2007-05-31") )
+})

diff --git a/pkg/tests/testthat/test.integerIndexToDate.R b/pkg/tests/testthat/test.integerIndexToDate.R
deleted file mode 100644 (file)
index 5f3d007..0000000
--- a/pkg/tests/testthat/test.integerIndexToDate.R
+++ /dev/null
@@ -1,25 +0,0 @@
-context("Check that integerIndexToDate behaves as expected")
-
-test_that("computed dates match the input indexes; predict_at == 0",
-{
-       data0 = getData(ts_data="pm10_mesures_H_loc.csv", exo_data="meteo_extra_noNAs.csv",
-               input_tz="Europe/Paris",working_tz="Europe/Paris", predict_at=0, limit=200)
-       expect_identical( integerIndexToDate(1,data), as.Date("2008-12-10") )
-       expect_identical( integerIndexToDate(2,data), as.Date("2008-12-11") )
-       expect_identical( integerIndexToDate(11,data), as.Date("2008-12-20") )
-       expect_identical( integerIndexToDate(53,data), as.Date("2009-02-01") )
-       expect_identical( integerIndexToDate(81,data), as.Date("2009-03-01") )
-       expect_identical( integerIndexToDate(172,data), as.Date("2009-05-31") )
-})
-
-test_that("computed dates match the input indexes; predict_at > 0",
-{
-       data7 = getData(ts_data="pm10_mesures_H_loc.csv", exo_data="meteo_extra_noNAs.csv",
-               input_tz="Europe/Paris",working_tz="Europe/Paris", predict_at=7, limit=200)
-       expect_identical( integerIndexToDate(2,data), as.Date("2008-12-10") )
-       expect_identical( integerIndexToDate(3,data), as.Date("2008-12-11") )
-       expect_identical( integerIndexToDate(12,data), as.Date("2008-12-20") )
-       expect_identical( integerIndexToDate(54,data), as.Date("2009-02-01") )
-       expect_identical( integerIndexToDate(82,data), as.Date("2009-03-01") )
-       expect_identical( integerIndexToDate(173,data), as.Date("2009-05-31") )
-}