The data model • fmr

library(fmr)
library(tidyverse)

The connection

key <- "your_FM_API_key"

Preamble

This document is just to explore the FM data model, done to prevent any misunderstanding when setting up the downstream code.

The FM API on is made up from three tables (The Data Structured Explained).

Survey table - distinguished by survey_id
Trip table - distinguished by trip_id (survey_item_id)
Catch table - distinguished by .id (survey_item_dtl_id)

The conceptual design (if one is considering catch-sampling on landing sites) is depicted as:

The FM 3 table framework is not specific for sampling from landings, but lets here think about these three tables in that context.

Sampling site table (survey table): For catch-sampling from landings data one could imagine that each record represents information about the sampling from a particular sampling site on a particular sampling date.
Trip table (surveyitem table): In case of catch sampling from landings this table should contain all information related to a single fishing trip except details of catch.
Catch table (surveyitem detail table): In case of catch sampling from landings this table will contain the detailed information about catch by species for each gear used.

Function logic

The {fmr}-package provides a set of functions that are just convenient wrappers for the API

The three survey tables

Let’s start by loading in tables needed, if only because we need information from the downstream tables to make sense of the upstream tables:

survey <- fm_survey(key, trim = FALSE)
trip   <- fm_trip(key, trim = FALSE)
catch  <- fm_catch(key, trim = FALSE)

The landing site-date table (Survey table)

survey |> glimpse()
#> Rows: 3,033
#> Columns: 23
#> $ site              <chr> "Basseterre West", "Sandy Point", "Basseterre East",…
#> $ island            <chr> "Saint Kitts", "Saint Kitts", "Saint Kitts", "Saint …
#> $ status            <chr> "Completed", "Completed", "Completed", "Completed", …
#> $ date              <date> 2023-02-15, 2023-01-11, 2023-01-08, 2023-01-08, 202…
#> $ T1                <dttm> 2023-02-15 05:50:00, 2023-01-11 14:00:00, 2023-01-0…
#> $ T2                <dttm> 2024-02-15 16:00:00, 2023-01-11 23:00:00, 2023-01-0…
#> $ total_boats       <dbl> 1, 1, 4, 4, 4, 12, 4, 4, 1, 1, 1, 6, 1, 6, 10, 10, 1…
#> $ type              <chr> "Landing", "Landing", "Landing", "Landing", "Landing…
#> $ collector         <chr> "Enver Pemberton", "Doret Williams", NA, NA, NA, "Ju…
#> $ survey_id         <dbl> 1475, 1487, 1493, 1494, 1495, 1496, 1498, 1499, 1503…
#> $ comment           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, …
#> $ .cn               <chr> "EnverP", "TracyG", "TracyG", "TracyG", "TracyG", "T…
#> $ .ct               <dttm> 2023-02-15 07:12:23, 2023-02-16 14:27:51, 2023-02-1…
#> $ .un               <chr> "TracyG", "TracyG", "TracyG", "TracyG", "TracyG", "T…
#> $ .ut               <dttm> 2024-05-31 14:35:44, 2023-03-03 14:12:29, 2023-02-2…
#> $ survey_type_id    <dbl> 1817, 1817, 1817, 1817, 1817, 1817, 1817, 1817, 1817…
#> $ fisheries_type_id <dbl> 3167, 3167, 3167, 3167, 3167, 3167, 3167, 3167, 3167…
#> $ survey_status_id  <dbl> 1807, 1807, 1807, 1807, 1807, 1807, 1807, 1807, 1807…
#> $ wf_status_id      <dbl> 22, 22, 22, 22, 22, 22, 22, 20, 22, 22, 22, 22, 22, …
#> $ landing_site_id   <dbl> 10081, 10087, 10080, 10080, 10080, 10080, 10080, 100…
#> $ data_collector_id <dbl> 10109, 10117, 14541, 14541, 14541, 14640, 10093, 100…
#> $ tenant_id         <dbl> 103, 103, 103, 103, 103, 103, 103, 103, 103, 103, 10…
#> $ is_active         <dbl> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0…

Each survey is identified by a unique value stored as survey_id. Intuitively one expects that each survey id constitutes a unique number for each landing site (site) by each sampling day (date). This is however not necessarily the case, as demonstrated below.

What does a single survey_id represent?

Let’s take a look at one month of data from one site:

d <- 
  survey |> 
  # look at one month
  filter(year(date) == 2024, month(date) == 1,
         site == "Basseterre East") |>
  arrange(date) |> 
  group_by(site, date) |> 
  summarise(n = n_distinct(survey_id),
            .groups = "drop")
d |> 
  knitr::kable(caption = "Number of surveys per date")

Number of surveys per date
site	date	n
Basseterre East	2024-01-04	3
Basseterre East	2024-01-05	2
Basseterre East	2024-01-06	2
Basseterre East	2024-01-07	2
Basseterre East	2024-01-08	2
Basseterre East	2024-01-09	1
Basseterre East	2024-01-10	2
Basseterre East	2024-01-11	2
Basseterre East	2024-01-12	2
Basseterre East	2024-01-14	1
Basseterre East	2024-01-16	3
Basseterre East	2024-01-17	3
Basseterre East	2024-01-19	1
Basseterre East	2024-01-22	1
Basseterre East	2024-01-23	1
Basseterre East	2024-01-24	1
Basseterre East	2024-01-26	1
Basseterre East	2024-01-29	1
Basseterre East	2024-01-30	2
Basseterre East	2024-01-31	5

Visually we have:

d |> 
  mutate(survey = TRUE) |> 
  fm_grid_calendar() |> 
  mutate(weekend = ifelse(.wday %in% c("Sa", "Su"),
                          TRUE,
                          FALSE),
         survey = replace_na(survey, FALSE)) |> 
  ggplot(aes(.wday, .week)) +
  theme_bw() +
  geom_tile(aes(fill = survey),
            colour = "black") +
  facet_wrap(~ site) +
  geom_text(aes(label = .day, colour = weekend)) +
  geom_text(aes(label = n), nudge_x = 0.2, nudge_y = -0.2,
            size = 3, colour = "blue") +
  scale_fill_manual(values=c("grey80", "pink")) +
  scale_colour_manual(values = c("black", "red")) +
  scale_y_reverse(NULL, NULL) +
  labs(x = NULL,
       title = "January 2024",
       caption = "colour: reported sampling day") +
  coord_equal() +
  theme(legend.position = "none",
        legend.title=element_blank(), 
        panel.grid=element_blank(), 
        panel.border=element_blank(), 
        axis.ticks=element_blank(), 
        strip.background=element_blank(), 
        #legend.position="top", 
        legend.justification="right", 
        legend.direction="horizontal", 
        legend.key.size=unit(0.3, "cm"), 
        legend.spacing.x=unit(0.2, "cm"))

This is some dummy

Here the pink shade marks days that surveys were conducted and the blue colour represents the number of unique reported surveys. There are two points to observe here:

Having a survey date on a weekend is unexpected because observers do not work on those days.
The number of surveys per day are in many cases more than 1

Let’s look first at the weeend data:

d <- 
  survey |> 
  # look at one month
  filter(year(date) == 2024, month(date) == 1,
         site == "Basseterre East") |> 
  mutate(wday = wday(date, label = TRUE, locale = "en_GB.utf8")) |> 
  filter(wday %in% c("Sat", "Sun")) |> 
  count(survey_id, date, wday) |> 
  arrange(date)
d
#> # A tibble: 5 × 4
#>   survey_id date       wday      n
#>       <dbl> <date>     <ord> <int>
#> 1      5523 2024-01-06 Sat       1
#> 2      5803 2024-01-06 Sat       1
#> 3      5524 2024-01-07 Sun       1
#> 4      5592 2024-01-07 Sun       1
#> 5      5840 2024-01-14 Sun       1

Here we see that we have:

3 survey weekdays

Ad hoc question:

survey |> 
  select(survey_id, date, .cn, .ct) |> 
  filter(year(date) == 2024) |> 
  inner_join(trip |> select(vid, survey_id, trip_id, dep_time, arr_time)) |> 
  inner_join(catch |> select(trip_id, type = measurement_type) |> distinct()) |> 
  select(vid, date, type, dep_time, arr_time, everything()) |> 
  arrange(vid, date, type) |> 
  group_by(vid, date, type) |> 
  mutate(n = n(), .after = type) |> 
  ungroup() |> 
  filter(n > 1) |> 
  knitr::kable()

vid	date	type	n	dep_time	arr_time	survey_id	.cn	.ct	trip_id
1857	2024-01-04	WT	10	2024-01-04 05:00:00	2024-01-04 15:30:00	5789	KadeanS	2024-02-01 18:10:08	6933
1857	2024-01-04	WT	10	2023-12-08 05:00:00	2023-12-08 15:30:00	5441	AllistineN	2024-01-04 14:13:22	6513
1857	2024-01-04	WT	10	2023-12-20 05:00:00	2023-12-20 15:30:00	5441	AllistineN	2024-01-04 14:13:22	6507
1857	2024-01-04	WT	10	2023-12-12 05:00:00	2023-12-12 14:30:00	5441	AllistineN	2024-01-04 14:13:22	6511
1857	2024-01-04	WT	10	2023-12-30 05:00:00	2023-12-30 15:30:00	5441	AllistineN	2024-01-04 14:13:22	6520
1857	2024-01-04	WT	10	2023-12-22 05:00:00	2023-12-22 16:00:00	5441	AllistineN	2024-01-04 14:13:22	6506
1857	2024-01-04	WT	10	2023-12-16 05:00:00	2023-12-16 15:30:00	5441	AllistineN	2024-01-04 14:13:22	6509
1857	2024-01-04	WT	10	2023-12-13 05:00:00	2023-12-13 15:30:00	5441	AllistineN	2024-01-04 14:13:22	6510
1857	2024-01-04	WT	10	2023-12-01 05:00:00	2023-12-01 15:30:00	5441	AllistineN	2024-01-04 14:13:22	6518
1857	2024-01-04	WT	10	2023-12-19 05:00:00	2023-12-19 15:30:00	5441	AllistineN	2024-01-04 14:13:22	6508
1857	2024-04-11	WT	2	2024-04-11 08:00:00	2024-04-11 13:35:00	6990	AllistineN	2024-04-15 17:33:08	8684
1857	2024-04-11	WT	2	2024-04-11 11:45:00	2024-04-11 15:40:00	6990	AllistineN	2024-04-15 17:33:08	8681
1857	2024-06-25	NA	2	2024-06-25 07:30:00	2024-06-25 14:30:00	7640	TracyG	2024-06-21 18:05:05	10199
1857	2024-06-25	NA	2	2024-06-25 07:30:00	2024-06-25 15:00:00	7640	TracyG	2024-06-21 18:05:05	10201
1861	2024-01-04	WT	2	2022-12-06 05:00:00	2023-12-06 15:00:00	5441	AllistineN	2024-01-04 14:13:22	6514
1861	2024-01-04	WT	2	2023-12-05 05:00:00	2023-12-05 15:30:00	5441	AllistineN	2024-01-04 14:13:22	6516
1871	2024-01-16	WT	2	2024-01-16 07:30:00	2024-01-16 14:55:00	5632	AllistineN	2024-01-23 15:48:56	6773
1871	2024-01-16	WT	2	2024-01-16 07:30:00	2024-01-16 14:50:00	5822	AllistineN	2024-02-05 14:17:58	6961
1871	2024-01-17	WT	2	2024-01-17 09:00:00	2024-01-17 14:30:00	5631	AllistineN	2024-01-23 15:40:14	6772
1871	2024-01-17	WT	2	2024-01-17 07:30:00	2024-01-17 14:40:00	5823	AllistineN	2024-02-05 14:28:56	6962
1872	2024-06-03	WT	3	2024-06-03 08:00:00	2024-06-03 15:20:00	7261	AndreaB	2024-06-03 15:11:41	9549
1872	2024-06-03	WT	3	2024-06-02 07:50:00	2024-06-02 14:15:00	7261	AndreaB	2024-06-03 15:11:41	9551
1872	2024-06-03	WT	3	2024-06-01 07:30:00	2024-06-01 13:40:00	7261	AndreaB	2024-06-03 15:11:41	9550
1878	2024-01-04	WT	2	2023-12-08 05:00:00	2023-12-08 15:00:00	5441	AllistineN	2024-01-04 14:13:22	6515
1878	2024-01-04	WT	2	2023-12-07 05:00:00	2023-12-07 15:30:00	5441	AllistineN	2024-01-04 14:13:22	6521
1888	2024-07-09	WT	2	2024-07-09 07:35:00	2024-07-09 14:00:00	7826	AshodeF	2024-07-11 14:19:26	10327
1888	2024-07-09	WT	2	2024-07-09 07:40:00	2024-07-09 15:10:00	7826	AshodeF	2024-07-11 14:19:26	10399
1889	2024-07-09	FE	4	2024-06-24 07:00:00	2024-06-24 12:30:00	7834	DoretW	2024-07-11 17:21:36	10339
1889	2024-07-09	FE	4	2024-06-18 07:00:00	2024-06-18 12:00:00	7834	DoretW	2024-07-11 17:21:36	10337
1889	2024-07-09	FE	4	2024-06-17 07:00:00	2024-06-17 12:00:00	7834	DoretW	2024-07-11 17:21:36	10336
1889	2024-07-09	FE	4	2024-06-22 07:00:00	2024-06-22 11:30:00	7834	DoretW	2024-07-11 17:21:36	10338
1894	2024-04-17	WT	10	2024-01-06 02:00:00	2024-03-06 14:15:00	7005	AllistineN	2024-04-18 16:17:59	8731
1894	2024-04-17	WT	10	2024-03-11 02:10:00	2024-03-11 14:25:00	7005	AllistineN	2024-04-18 16:17:59	8733
1894	2024-04-17	WT	10	2024-03-13 02:10:00	2024-03-13 14:25:00	7005	AllistineN	2024-04-18 16:17:59	8734
1894	2024-04-17	WT	10	2024-03-20 02:15:00	2024-03-20 14:30:00	7005	AllistineN	2024-04-18 16:17:59	8739
1894	2024-04-17	WT	10	2024-03-04 02:00:00	2024-03-04 14:15:00	7005	AllistineN	2024-04-18 16:17:59	8730
1894	2024-04-17	WT	10	2024-03-27 02:00:00	2024-03-27 14:15:00	7005	AllistineN	2024-04-18 16:17:59	8729
1894	2024-04-17	WT	10	2024-03-07 02:00:00	2024-03-07 14:15:00	7005	AllistineN	2024-04-18 16:17:59	8732
1894	2024-04-17	WT	10	2024-03-18 02:00:00	2024-03-18 14:00:00	7005	AllistineN	2024-04-18 16:17:59	8736
1894	2024-04-17	WT	10	2024-03-26 02:00:00	2024-03-26 14:15:00	7005	AllistineN	2024-04-18 16:17:59	8728
1894	2024-04-17	WT	10	2024-03-21 02:00:00	2024-03-21 14:30:00	7005	AllistineN	2024-04-18 16:17:59	8740
1894	2024-05-22	WT	13	2024-04-18 02:15:00	2024-04-18 14:15:00	7221	AndreaB	2024-05-28 14:51:12	9376
1894	2024-05-22	WT	13	2024-04-03 02:10:00	2024-04-03 14:30:00	7221	AndreaB	2024-05-28 14:51:12	9354
1894	2024-05-22	WT	13	2024-04-08 02:00:00	2024-04-08 14:20:00	7221	AndreaB	2024-05-28 14:51:12	9358
1894	2024-05-22	WT	13	2024-04-04 02:00:00	2024-04-04 14:20:00	7221	AndreaB	2024-05-28 14:51:12	9356
1894	2024-05-22	WT	13	2024-04-10 02:20:00	2024-04-10 14:15:00	7221	AndreaB	2024-05-28 14:51:12	9363
1894	2024-05-22	WT	13	2024-04-11 02:15:00	2024-04-11 14:30:00	7221	AndreaB	2024-05-28 14:51:12	9366
1894	2024-05-22	WT	13	2024-03-15 02:15:00	2024-04-11 14:30:00	7221	AndreaB	2024-05-28 14:51:12	9371
1894	2024-05-22	WT	13	2024-04-17 02:30:00	2024-04-17 14:15:00	7221	AndreaB	2024-05-28 14:51:12	9375
1894	2024-05-22	WT	13	2024-04-25 02:30:00	2024-04-25 14:20:00	7221	AndreaB	2024-05-28 14:51:12	9379
1894	2024-05-22	WT	13	2022-04-22 02:30:00	2023-04-22 14:50:00	7221	AndreaB	2024-05-28 14:51:12	9404
1894	2024-05-22	WT	13	2024-04-29 02:15:00	2024-04-29 14:10:00	7221	AndreaB	2024-05-28 14:51:12	9497
1894	2024-05-22	WT	13	2024-04-29 02:15:00	2024-04-29 14:10:00	7221	AndreaB	2024-05-28 14:51:12	9500
1894	2024-05-22	WT	13	2023-04-23 02:15:00	2024-04-23 14:40:00	7221	AndreaB	2024-05-28 14:51:12	9481
1894	2024-06-07	WT	15	2024-05-02 02:15:00	2024-05-02 14:25:00	7330	AndreaB	2024-06-10 15:22:56	9650
1894	2024-06-07	WT	15	2024-05-08 02:15:00	2024-05-08 14:25:00	7330	AndreaB	2024-06-10 15:22:56	9654
1894	2024-06-07	WT	15	2024-05-15 02:00:00	2024-05-15 14:25:00	7330	AndreaB	2024-06-10 15:22:56	9657
1894	2024-06-07	WT	15	2024-05-16 02:15:00	2024-05-16 14:15:00	7330	AndreaB	2024-06-10 15:22:56	9659
1894	2024-06-07	WT	15	2024-05-22 02:10:00	2024-05-22 15:30:00	7330	AndreaB	2024-06-10 15:22:56	9663
1894	2024-06-07	WT	15	2024-05-29 02:10:00	2024-05-29 15:15:00	7330	AndreaB	2024-06-10 15:22:56	9675
1894	2024-06-07	WT	15	2024-05-23 02:15:00	2024-05-23 14:30:00	7330	AndreaB	2024-06-10 15:22:56	9664
1894	2024-06-07	WT	15	2024-05-27 14:05:00	2024-05-27 14:30:00	7330	AndreaB	2024-06-10 15:22:56	9667
1894	2024-06-07	WT	15	2024-05-30 02:00:00	2024-05-30 14:20:00	7330	AndreaB	2024-06-10 15:22:56	9679
1894	2024-06-07	WT	15	2024-05-22 02:10:00	2024-06-22 14:30:00	7330	AndreaB	2024-06-10 15:22:56	9783
1894	2024-06-07	WT	15	2024-05-01 02:10:00	2024-05-01 14:30:00	7330	AndreaB	2024-06-10 15:22:56	9643
1894	2024-06-07	WT	15	2023-05-07 02:20:00	2024-05-07 14:35:00	7330	AndreaB	2024-06-10 15:22:56	9653
1894	2024-06-07	WT	15	2024-05-09 02:20:00	2024-05-09 15:30:00	7330	AndreaB	2024-06-10 15:22:56	9655
1894	2024-06-07	WT	15	2024-05-13 02:10:00	2024-05-13 14:20:00	7330	AndreaB	2024-06-10 15:22:56	9656
1894	2024-06-07	WT	15	2024-05-21 02:25:00	2024-06-21 14:15:00	7330	AndreaB	2024-06-10 15:22:56	9662
1894	2024-06-07	NA	2	2024-05-30 02:00:00	2024-05-30 14:20:00	7330	AndreaB	2024-06-10 15:22:56	9679
1894	2024-06-07	NA	2	2024-05-22 02:10:00	2024-06-22 14:30:00	7330	AndreaB	2024-06-10 15:22:56	9783
1927	2024-04-27	WT	20	2023-04-21 06:00:00	2023-04-21 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9265
1927	2024-04-27	WT	20	2023-04-25 06:00:00	2023-04-25 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9267
1927	2024-04-27	WT	20	2023-04-27 06:00:00	2023-04-27 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9268
1927	2024-04-27	WT	20	2023-03-02 04:00:00	2023-03-02 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9432
1927	2024-04-27	WT	20	2023-03-03 06:00:00	2023-03-03 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9435
1927	2024-04-27	WT	20	2023-03-06 06:00:00	2023-03-06 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9437
1927	2024-04-27	WT	20	2023-04-12 06:00:00	2023-04-12 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9260
1927	2024-04-27	WT	20	2023-03-06 06:00:00	2023-03-06 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9468
1927	2024-04-27	WT	20	2023-03-12 06:00:00	2023-03-12 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9469
1927	2024-04-27	WT	20	2023-03-15 06:00:00	2023-03-15 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9470
1927	2024-04-27	WT	20	2023-03-23 06:00:00	2023-03-23 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9471
1927	2024-04-27	WT	20	2023-04-04 06:00:00	2023-04-04 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9257
1927	2024-04-27	WT	20	2023-04-08 06:00:00	2023-04-08 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9258
1927	2024-04-27	WT	20	2023-04-10 06:00:00	2023-04-10 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9259
1927	2024-04-27	WT	20	2023-04-23 06:00:00	2023-04-23 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9266
1927	2024-04-27	WT	20	2023-04-29 06:00:00	2023-04-29 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9269
1927	2024-04-27	WT	20	2023-04-18 06:00:00	2023-04-18 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9264
1927	2024-04-27	WT	20	2023-04-14 06:00:00	2023-04-14 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9262
1927	2024-04-27	WT	20	2023-04-16 06:00:00	2023-04-16 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9263
1927	2024-04-27	WT	20	2023-03-28 06:00:00	2023-03-28 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9472
1931	2024-04-27	WT	12	2024-04-27 05:00:00	2024-04-27 10:20:00	7842	JaresaS	2024-07-15 14:32:56	10365
1931	2024-04-27	WT	12	2023-04-11 06:00:00	2023-04-11 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9249
1931	2024-04-27	WT	12	2023-03-11 06:00:00	2023-03-11 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9340
1931	2024-04-27	WT	12	2023-04-08 06:00:00	2023-04-08 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9242
1931	2024-04-27	WT	12	2023-04-04 06:00:00	2023-04-04 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9226
1931	2024-04-27	WT	12	2023-04-18 06:00:00	2023-04-18 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9254
1931	2024-04-27	WT	12	2023-03-25 06:00:00	2023-03-25 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9319
1931	2024-04-27	WT	12	2023-03-21 06:00:00	2024-05-28 09:28:33	7213	JudikaE	2024-05-27 13:05:52	9313
1931	2024-04-27	WT	12	2023-03-18 06:00:00	2023-03-18 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9316
1931	2024-04-27	WT	12	2023-03-17 06:00:00	2023-03-17 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9335
1931	2024-04-27	WT	12	2024-05-28 12:29:19	2024-05-28 12:29:19	7213	JudikaE	2024-05-27 13:05:52	9355
1931	2024-04-27	WT	12	2023-03-04 06:00:00	2024-05-28 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9347
1933	2024-04-06	WT	2	2024-04-06 06:00:00	2024-04-06 12:00:00	7844	JaresaS	2024-07-15 14:59:12	10367
1933	2024-04-06	WT	2	2024-04-05 09:30:00	2024-04-05 13:00:00	7844	JaresaS	2024-07-15 14:59:12	10368
1933	2024-04-27	WT	3	2023-04-08 06:00:00	2024-04-08 01:00:00	7213	JudikaE	2024-05-27 13:05:52	9234
1933	2024-04-27	WT	3	2023-04-22 06:00:00	2023-04-22 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9250
1933	2024-04-27	WT	3	2023-04-23 06:00:00	2023-04-23 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9231
1935	2024-04-29	FE	2	2024-04-20 07:00:00	2024-04-20 17:00:00	7063	VenrickN	2024-04-29 15:04:24	8911
1935	2024-04-29	FE	2	2024-04-29 07:00:00	2024-04-29 11:15:00	7101	VenrickN	2024-05-03 15:13:07	8986
1937	2024-04-27	WT	4	2023-04-19 06:00:00	2023-04-19 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9294
1937	2024-04-27	WT	4	2023-04-04 06:00:00	2023-04-04 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9224
1937	2024-04-27	WT	4	2023-04-18 06:00:00	2023-04-18 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9230
1937	2024-04-27	WT	4	2023-04-16 06:00:00	2024-05-27 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9295
1942	2024-04-27	WT	11	2024-04-27 05:00:00	2024-04-27 10:00:00	7842	JaresaS	2024-07-15 14:32:56	10364
1942	2024-04-27	WT	11	2023-04-04 06:00:00	2023-04-04 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9239
1942	2024-04-27	WT	11	2023-04-11 06:00:00	2023-04-11 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9251
1942	2024-04-27	WT	11	2023-04-08 06:00:00	2023-04-08 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9244
1942	2024-04-27	WT	11	2023-04-18 06:00:00	2023-04-18 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9255
1942	2024-04-27	WT	11	2023-03-18 06:00:00	2023-03-18 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9317
1942	2024-04-27	WT	11	2023-03-21 06:00:00	2023-03-21 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9314
1942	2024-04-27	WT	11	2023-03-25 06:00:00	2023-03-25 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9322
1942	2024-04-27	WT	11	2023-03-11 06:00:00	2023-03-11 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9344
1942	2024-04-27	WT	11	2023-03-04 06:00:00	2023-03-04 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9352
1942	2024-04-27	WT	11	2023-03-07 06:00:00	2023-03-07 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9337
1944	2024-02-22	WT	4	2024-02-20 20:00:00	2024-02-21 10:00:00	6306	KadeanS	2024-02-22 14:49:30	7740
1944	2024-02-22	WT	4	2024-02-18 04:00:00	2024-02-19 13:30:00	6306	KadeanS	2024-02-22 14:49:30	7741
1944	2024-02-22	WT	4	2024-02-14 04:00:00	2024-02-15 12:30:00	6306	KadeanS	2024-02-22 14:49:30	7742
1944	2024-02-22	WT	4	2024-02-13 04:00:00	2024-02-14 10:00:00	6306	KadeanS	2024-02-22 14:49:30	7743
1951	2024-05-27	FE	2	2023-03-14 06:00:00	2023-03-14 13:00:00	7214	AndreaB	2024-05-27 13:34:53	9462
1951	2024-05-27	FE	2	2023-03-28 06:00:00	2023-03-28 13:00:00	7214	AndreaB	2024-05-27 13:34:53	9465
1953	2024-03-13	WT	2	2024-03-12 18:00:00	2024-03-13 06:40:00	6802	VenrickN	2024-03-27 15:37:54	8387
1953	2024-03-13	WT	2	2024-03-13 06:00:00	2024-03-13 17:00:00	6802	VenrickN	2024-03-27 15:37:54	8391
1954	2024-01-07	WT	2	2024-01-06 17:00:00	2024-01-07 06:00:00	5564	VenrickN	2024-01-16 14:34:04	6668
1954	2024-01-07	WT	2	2024-01-07 08:00:00	2024-01-07 14:00:00	5564	VenrickN	2024-01-16 14:34:04	6669
1954	2024-01-22	WT	2	2024-01-22 08:00:00	2024-01-22 15:00:00	5782	VenrickN	2024-02-01 14:11:39	6927
1954	2024-01-22	WT	2	2024-01-21 17:00:00	2024-01-22 06:00:00	5782	VenrickN	2024-02-01 14:11:39	6924
1954	2024-02-22	WT	2	2024-02-21 17:00:00	2024-02-22 06:40:00	6364	VenrickN	2024-02-27 14:53:46	7810
1954	2024-02-22	WT	2	2024-02-22 16:00:00	2024-02-23 10:00:00	6862	JudikaE	2024-04-03 14:48:21	8442
1954	2024-02-26	WT	2	2024-02-25 17:00:00	2024-02-26 07:00:00	6402	VenrickN	2024-02-29 14:30:44	7845
1954	2024-02-26	WT	2	2024-02-26 04:00:00	2024-02-27 11:00:00	6865	JudikaE	2024-04-03 15:07:33	8445
1954	2024-02-27	WT	2	2024-02-27 16:00:00	2024-02-28 11:30:00	6871	JudikaE	2024-04-03 17:59:37	8451
1954	2024-02-27	WT	2	2024-02-26 17:00:00	2024-02-27 07:15:00	6440	VenrickN	2024-03-04 14:56:00	7880
1954	2024-03-07	WT	2	2024-03-06 17:00:00	2024-03-07 07:50:00	6601	VenrickN	2024-03-14 14:28:01	8069
1954	2024-03-07	WT	2	2024-03-07 10:00:00	2024-03-08 10:30:00	6872	JudikaE	2024-04-03 18:02:24	8452
1954	2024-03-11	WT	2	2024-03-10 17:45:00	2024-03-11 07:00:00	6763	VenrickN	2024-03-25 15:43:57	8314
1954	2024-03-11	WT	2	2024-03-11 05:00:00	2024-03-12 10:00:00	6747	JudikaE	2024-03-21 16:11:32	8264
1954	2024-03-13	WT	2	2024-03-13 10:00:00	2024-03-14 11:00:00	6745	JudikaE	2024-03-21 15:46:29	8261
1954	2024-03-13	WT	2	2024-03-12 18:00:00	2024-03-13 06:40:00	6802	VenrickN	2024-03-27 15:37:54	8386
1954	2024-03-26	WT	2	2024-03-25 16:00:00	2024-03-26 07:00:00	6953	VenrickN	2024-04-09 14:19:56	8568
1954	2024-03-26	WT	2	2024-03-26 09:45:00	2024-03-26 14:00:00	6953	VenrickN	2024-04-09 14:19:56	8572
1954	2024-05-14	WT	2	2024-05-13 18:00:00	2024-05-14 06:00:00	7187	VenrickN	2024-05-22 14:39:50	9169
1954	2024-05-14	WT	2	2024-05-14 07:00:00	2024-05-14 17:15:00	7187	VenrickN	2024-05-22 14:39:50	9175
1956	2024-04-27	WT	3	2023-04-08 06:00:00	2023-04-08 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9247
1956	2024-04-27	WT	3	2023-03-21 01:00:00	2023-03-21 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9331
1956	2024-04-27	WT	3	2023-03-04 06:00:00	2023-03-04 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9353
1962	2024-04-27	WT	7	2023-04-15 06:00:00	2023-05-15 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9369
1962	2024-04-27	WT	7	2023-03-03 06:00:00	2023-03-03 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9357
1962	2024-04-27	WT	7	2023-03-09 06:00:00	2023-03-09 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9361
1962	2024-04-27	WT	7	2023-03-31 06:00:00	2024-03-31 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9364
1962	2024-04-27	WT	7	2023-03-13 06:00:00	2023-03-13 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9368
1962	2024-04-27	WT	7	2023-03-25 06:00:00	2023-03-25 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9373
1962	2024-04-27	WT	7	2023-03-04 06:00:00	2023-03-04 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9359
1968	2024-04-27	WT	13	2023-04-04 06:00:00	2023-04-04 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9272
1968	2024-04-27	WT	13	2023-04-12 06:00:00	2023-04-12 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9275
1968	2024-04-27	WT	13	2023-04-17 06:00:00	2023-04-17 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9277
1968	2024-04-27	WT	13	2023-04-10 06:00:00	2023-04-10 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9274
1968	2024-04-27	WT	13	2023-04-20 06:00:00	2023-04-20 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9305
1968	2024-04-27	WT	13	2023-03-15 06:00:00	2023-03-15 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9498
1968	2024-04-27	WT	13	2023-03-02 04:00:00	2023-03-02 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9490
1968	2024-04-27	WT	13	2023-03-23 06:00:00	2023-03-23 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9499
1968	2024-04-27	WT	13	2023-03-30 06:00:00	2023-03-30 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9502
1968	2024-04-27	WT	13	2023-03-03 06:00:00	2023-03-03 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9491
1968	2024-04-27	WT	13	2023-03-08 08:00:00	2023-03-08 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9494
1968	2024-04-27	WT	13	2023-03-12 06:00:00	2023-03-12 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9496
1968	2024-04-27	WT	13	2023-03-25 06:00:00	2024-03-25 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9501
1986	2024-04-27	WT	4	2023-04-08 06:10:00	2023-04-08 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9232
1986	2024-04-27	WT	4	2023-04-11 06:00:00	2023-04-11 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9241
1986	2024-04-27	WT	4	2023-04-18 06:00:00	2023-05-18 01:00:00	7213	JudikaE	2024-05-27 13:05:52	9245
1986	2024-04-27	WT	4	2023-04-22 06:00:00	2023-04-22 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9248
1989	2024-01-04	WT	2	2023-12-11 04:00:00	2023-12-11 14:30:00	5441	AllistineN	2024-01-04 14:13:22	6512
1989	2024-01-04	WT	2	2023-12-03 04:00:00	2023-12-04 10:00:00	5441	AllistineN	2024-01-04 14:13:22	6517
1996	2024-03-13	FE	3	2024-03-06 06:00:00	2024-03-06 13:00:00	6603	DoretW	2024-03-14 15:10:55	8101
1996	2024-03-13	FE	3	2024-03-13 06:00:00	2024-03-13 14:00:00	6603	DoretW	2024-03-14 15:10:55	8108
1996	2024-03-13	FE	3	2024-03-11 06:00:00	2024-03-11 14:00:00	6603	DoretW	2024-03-14 15:10:55	8109
1996	2024-04-02	WT	4	2024-04-03 06:00:00	2024-04-03 15:30:00	6975	JudikaE	2024-04-11 18:48:13	8641
1996	2024-04-02	WT	4	2024-04-04 06:00:00	2024-04-04 13:00:00	6975	JudikaE	2024-04-11 18:48:13	8642
1996	2024-04-02	WT	4	2024-04-02 06:00:00	2024-04-02 14:00:00	6975	JudikaE	2024-04-11 18:48:13	8640
1996	2024-04-02	WT	4	2024-04-08 06:00:00	2024-04-08 13:00:00	6975	JudikaE	2024-04-11 18:48:13	8643
1996	2024-05-08	FE	7	2024-04-24 06:00:00	2024-04-24 13:00:00	7135	DoretW	2024-05-09 16:22:05	9030
1996	2024-05-08	FE	7	2024-04-30 06:00:00	2024-04-30 13:00:00	7135	DoretW	2024-05-09 16:22:05	9032
1996	2024-05-08	FE	7	2024-05-08 06:00:00	2024-05-08 13:30:00	7135	DoretW	2024-05-09 16:22:05	9034
1996	2024-05-08	FE	7	2024-03-18 06:00:00	2024-03-18 14:00:00	7135	DoretW	2024-05-09 16:22:05	9027
1996	2024-05-08	FE	7	2024-04-17 06:00:00	2024-04-17 12:00:00	7135	DoretW	2024-05-09 16:22:05	9028
1996	2024-05-08	FE	7	2024-04-23 06:00:00	2024-04-23 12:30:00	7135	DoretW	2024-05-09 16:22:05	9029
1996	2024-05-08	FE	7	2024-05-01 06:00:00	2024-05-01 12:00:00	7135	DoretW	2024-05-09 16:22:05	9033
1996	2024-05-23	WT	2	2024-05-22 06:00:00	2024-05-22 14:00:00	7205	AndreaB	2024-05-23 19:10:48	9212
1996	2024-05-23	WT	2	2024-05-09 06:00:00	2024-05-09 14:00:00	7205	AndreaB	2024-05-23 19:10:48	9213
1997	2024-01-17	WT	2	2024-01-17 08:00:00	2024-01-17 13:40:00	5631	AllistineN	2024-01-23 15:40:14	6771
1997	2024-01-17	WT	2	2024-01-17 07:40:00	2024-01-17 14:50:00	5823	AllistineN	2024-02-05 14:28:56	6963
1997	2024-02-23	WT	2	2024-02-15 08:30:00	2024-02-15 14:30:00	6323	JudikaE	2024-02-23 15:01:42	7751
1997	2024-02-23	WT	2	2024-02-19 08:15:00	2024-02-19 14:35:00	6325	JudikaE	2024-02-23 16:00:58	7761
1997	2024-06-06	WT	2	2024-06-06 08:15:00	2024-06-06 15:40:00	7278	AndreaB	2024-06-06 14:44:44	9628
1997	2024-06-06	WT	2	2023-09-18 07:30:00	2023-09-18 13:40:00	7278	AndreaB	2024-06-06 14:44:44	9579
1998	2024-06-19	WT	3	2024-06-17 05:00:00	2024-06-17 14:00:00	7362	TracyG	2024-06-17 14:22:26	10102
1998	2024-06-19	WT	3	2024-06-19 05:00:00	2024-06-19 13:00:00	7362	TracyG	2024-06-17 14:22:26	10105
1998	2024-06-19	WT	3	2024-06-18 05:00:00	2024-06-18 14:00:00	7362	TracyG	2024-06-17 14:22:26	10104
2001	2024-02-23	WT	2	2024-02-15 08:00:00	2024-02-15 13:05:00	6323	JudikaE	2024-02-23 15:01:42	7749
2001	2024-02-23	WT	2	2024-02-19 07:30:00	2024-02-19 14:10:00	6325	JudikaE	2024-02-23 16:00:58	7760
2001	2024-05-31	WT	2	2024-05-31 07:30:00	2024-05-31 13:25:00	7262	AshodeF	2024-06-04 00:05:52	9530
2001	2024-05-31	WT	2	2024-05-31 07:30:00	2024-05-31 13:25:00	7262	AshodeF	2024-06-04 00:05:52	9529
2001	2024-06-06	WT	2	2023-09-14 07:00:00	2023-09-14 14:15:00	7278	AndreaB	2024-06-06 14:44:44	9570
2001	2024-06-06	WT	2	2024-06-06 07:30:00	2024-06-06 12:45:00	7278	AndreaB	2024-06-06 14:44:44	9625
2006	2024-03-13	FE	11	2024-01-31 06:00:00	2024-01-31 12:30:00	6603	DoretW	2024-03-14 15:10:55	8077
2006	2024-03-13	FE	11	2024-02-02 06:00:00	2024-02-02 12:00:00	6603	DoretW	2024-03-14 15:10:55	8078
2006	2024-03-13	FE	11	2024-02-05 06:00:00	2024-02-05 12:30:00	6603	DoretW	2024-03-14 15:10:55	8080
2006	2024-03-13	FE	11	2024-02-13 06:00:00	2024-02-13 12:30:00	6603	DoretW	2024-03-14 15:10:55	8082
2006	2024-03-13	FE	11	2024-02-22 06:00:00	2024-02-22 12:30:00	6603	DoretW	2024-03-14 15:10:55	8091
2006	2024-03-13	FE	11	2024-02-25 06:00:00	2024-02-25 13:00:00	6603	DoretW	2024-03-14 15:10:55	8092
2006	2024-03-13	FE	11	2024-02-27 06:00:00	2024-02-27 13:00:00	6603	DoretW	2024-03-14 15:10:55	8093
2006	2024-03-13	FE	11	2024-02-15 06:00:00	2024-02-15 12:00:00	6603	DoretW	2024-03-14 15:10:55	8084
2006	2024-03-13	FE	11	2024-01-29 06:00:00	2024-01-29 12:00:00	6603	DoretW	2024-03-14 15:10:55	8076
2006	2024-03-13	FE	11	2024-02-19 06:00:00	2024-02-19 12:00:00	6603	DoretW	2024-03-14 15:10:55	8087
2006	2024-03-13	FE	11	2024-02-21 06:00:00	2024-02-21 11:30:00	6603	DoretW	2024-03-14 15:10:55	8089
2006	2024-03-20	FE	5	2024-03-07 06:00:00	2024-03-07 14:30:00	6741	DoretW	2024-03-21 13:20:01	8246
2006	2024-03-20	FE	5	2024-03-13 06:00:00	2024-03-13 13:30:00	6741	DoretW	2024-03-21 13:20:01	8250
2006	2024-03-20	FE	5	2024-03-15 06:00:00	2024-03-15 12:00:00	6741	DoretW	2024-03-21 13:20:01	8252
2006	2024-03-20	FE	5	2024-03-05 06:00:00	2024-03-05 13:00:00	6741	DoretW	2024-03-21 13:20:01	8244
2006	2024-03-20	FE	5	2024-03-11 06:00:00	2024-03-11 13:30:00	6741	DoretW	2024-03-21 13:20:01	8247
2006	2024-04-17	FE	11	2024-03-20 06:00:00	2024-03-20 12:00:00	7006	DoretW	2024-04-18 17:50:11	8738
2006	2024-04-17	FE	11	2024-04-03 06:00:00	2024-04-03 13:30:00	7006	DoretW	2024-04-18 17:50:11	8747
2006	2024-04-17	FE	11	2024-04-08 06:00:00	2024-04-08 13:00:00	7006	DoretW	2024-04-18 17:50:11	8749
2006	2024-04-17	FE	11	2024-03-29 06:00:00	2024-03-29 13:00:00	7006	DoretW	2024-04-18 17:50:11	8744
2006	2024-04-17	FE	11	2024-03-22 06:00:00	2024-03-22 12:30:00	7006	DoretW	2024-04-18 17:50:11	8741
2006	2024-04-17	FE	11	2024-04-15 06:00:00	2024-04-15 13:00:00	7006	DoretW	2024-04-18 17:50:11	8752
2006	2024-04-17	FE	11	2024-03-18 06:00:00	2024-03-18 13:00:00	7006	DoretW	2024-04-18 17:50:11	8737
2006	2024-04-17	FE	11	2024-03-25 06:00:00	2024-03-25 13:00:00	7006	DoretW	2024-04-18 17:50:11	8742
2006	2024-04-17	FE	11	2024-03-27 06:00:00	2024-03-27 13:00:00	7006	DoretW	2024-04-18 17:50:11	8743
2006	2024-04-17	FE	11	2024-04-01 06:00:00	2024-04-01 12:00:00	7006	DoretW	2024-04-18 17:50:11	8745
2006	2024-04-17	FE	11	2024-04-12 06:00:00	2024-04-12 11:30:00	7006	DoretW	2024-04-18 17:50:11	8751
2006	2024-05-14	FE	4	2024-05-05 06:00:00	2024-05-05 12:00:00	7147	DoretW	2024-05-15 15:01:30	9060
2006	2024-05-14	FE	4	2024-05-04 06:00:00	2024-05-04 13:00:00	7147	DoretW	2024-05-15 15:01:30	9059
2006	2024-05-14	FE	4	2024-04-20 06:00:00	2024-04-20 12:30:00	7147	DoretW	2024-05-15 15:01:30	9058
2006	2024-05-14	FE	4	2024-05-10 06:00:00	2024-05-10 12:00:00	7147	DoretW	2024-05-15 15:01:30	9061
2006	2024-06-17	FE	6	2024-05-18 07:00:00	2024-05-18 12:00:00	7373	TracyG	2024-06-17 14:47:27	9752
2006	2024-06-17	FE	6	2024-05-29 07:00:00	2024-05-29 12:00:00	7373	TracyG	2024-06-17 14:47:27	9754
2006	2024-06-17	FE	6	2024-06-03 07:00:00	2024-06-03 12:30:00	7373	TracyG	2024-06-17 14:47:27	9757
2006	2024-06-17	FE	6	2024-06-01 07:00:00	2024-06-01 13:00:00	7373	TracyG	2024-06-17 14:47:27	9755
2006	2024-06-17	FE	6	2024-06-07 07:00:00	2024-06-07 12:00:00	7373	TracyG	2024-06-17 14:47:27	9758
2006	2024-06-17	FE	6	2024-06-15 07:00:00	2024-06-15 13:00:00	7373	TracyG	2024-06-17 14:47:27	9759
2008	2024-03-13	FE	2	2024-03-07 06:00:00	2024-03-07 13:00:00	6603	DoretW	2024-03-14 15:10:55	8102
2008	2024-03-13	FE	2	2024-03-13 06:00:00	2024-03-13 13:00:00	6603	DoretW	2024-03-14 15:10:55	8110
2009	2024-06-24	NA	2	2024-06-24 04:00:00	2024-06-24 12:30:00	7641	TracyG	2024-06-21 18:05:42	10121
2009	2024-06-24	NA	2	2024-06-24 05:00:00	2024-06-24 16:00:00	7704	ThrizenL	2024-06-26 14:48:55	10187
2017	2024-02-22	WT	2	2024-02-19 05:00:00	2024-02-19 16:00:00	6306	KadeanS	2024-02-22 14:49:30	7725
2017	2024-02-22	WT	2	2024-02-19 05:00:00	2024-02-19 13:00:00	6306	KadeanS	2024-02-22 14:49:30	7724
2017	2024-02-23	WT	3	2024-02-23 05:00:00	2024-02-23 15:30:00	6860	JudikaE	2024-04-03 14:38:10	8440
2017	2024-02-23	WT	3	2024-02-15 08:25:00	2024-02-15 14:10:00	6323	JudikaE	2024-02-23 15:01:42	7750
2017	2024-02-23	WT	3	2024-02-21 08:30:00	2024-02-21 14:35:00	6327	JudikaE	2024-02-23 17:49:47	7769
2017	2024-03-12	WT	2	2024-03-12 07:55:00	2024-03-12 14:30:00	6581	AllistineN	2024-03-13 13:34:34	8047
2017	2024-03-12	WT	2	2024-03-12 05:00:00	2024-03-12 15:00:00	6744	JudikaE	2024-03-21 15:42:01	8260
2022	2024-03-08	WT	3	2024-03-22 08:00:00	2024-03-22 14:00:00	6974	JudikaE	2024-04-11 18:17:22	8636
2022	2024-03-08	WT	3	2024-03-25 06:00:00	2024-03-25 15:00:00	6974	JudikaE	2024-04-11 18:17:22	8637
2022	2024-03-08	WT	3	2023-03-20 07:00:00	2024-03-20 15:00:00	6974	JudikaE	2024-04-11 18:17:22	8639
2022	2024-03-13	FE	2	2024-03-07 06:00:00	2024-03-07 15:00:00	6603	DoretW	2024-03-14 15:10:55	8103
2022	2024-03-13	FE	2	2024-03-08 06:00:00	2024-03-08 13:00:00	6603	DoretW	2024-03-14 15:10:55	8104
2022	2024-04-02	WT	2	2024-04-08 06:00:00	2024-04-08 10:00:00	6975	JudikaE	2024-04-11 18:48:13	8644
2022	2024-04-02	WT	2	2024-04-09 06:00:00	2024-04-09 14:00:00	6975	JudikaE	2024-04-11 18:48:13	8645
2025	2024-02-09	FE	2	2024-02-09 09:30:00	2024-02-09 12:50:00	6132	DoretW	2024-02-13 15:51:06	8267
2025	2024-02-09	FE	2	2024-02-09 13:30:00	2024-02-09 16:00:00	6132	DoretW	2024-02-13 15:51:06	8266
2025	2024-03-08	WT	5	2024-03-09 06:00:00	2024-03-09 13:00:00	6974	JudikaE	2024-04-11 18:17:22	8631
2025	2024-03-08	WT	5	2024-03-10 05:00:00	2024-03-10 14:00:00	6974	JudikaE	2024-04-11 18:17:22	8632
2025	2024-03-08	WT	5	2024-03-23 05:00:00	2024-03-23 13:00:00	6974	JudikaE	2024-04-11 18:17:22	8635
2025	2024-03-08	WT	5	2024-03-03 07:00:00	2024-03-03 14:00:00	6974	JudikaE	2024-04-11 18:17:22	8633
2025	2024-03-08	WT	5	2024-03-14 05:00:00	2024-03-14 13:00:00	6974	JudikaE	2024-04-11 18:17:22	8634
2025	2024-06-11	WT	10	2024-06-09 06:00:00	2024-06-09 14:00:00	7307	TracyG	2024-06-07 17:22:50	9660
2025	2024-06-11	WT	10	2024-05-09 06:00:00	2024-05-09 14:00:00	7307	TracyG	2024-06-07 17:22:50	9661
2025	2024-06-11	WT	10	2024-05-13 06:00:00	2024-05-13 14:00:00	7307	TracyG	2024-06-07 17:22:50	9677
2025	2024-06-11	WT	10	2023-05-28 06:00:00	2024-05-28 14:00:00	7307	TracyG	2024-06-07 17:22:50	9678
2025	2024-06-11	WT	10	2024-06-06 06:00:00	2024-06-06 14:00:00	7307	TracyG	2024-06-07 17:22:50	9681
2025	2024-06-11	WT	10	2024-04-07 06:00:00	2024-04-07 14:00:00	7307	TracyG	2024-06-07 17:22:50	9685
2025	2024-06-11	WT	10	2024-04-04 06:00:00	2024-04-04 14:00:00	7307	TracyG	2024-06-07 17:22:50	9684
2025	2024-06-11	WT	10	2024-06-06 06:00:00	2024-06-06 14:00:00	7307	TracyG	2024-06-07 17:22:50	9682
2025	2024-06-11	WT	10	2024-03-03 06:00:00	2024-03-03 14:00:00	7307	TracyG	2024-06-07 17:22:50	9683
2025	2024-06-11	WT	10	2024-06-02 06:00:00	2024-06-02 14:00:00	7307	TracyG	2024-06-07 17:22:50	9680
2025	2024-06-13	WT	3	2024-06-13 06:00:00	2024-06-13 14:00:00	7309	TracyG	2024-06-07 17:23:42	10002
2025	2024-06-13	WT	3	2024-06-14 06:00:00	2024-06-14 14:00:00	7309	TracyG	2024-06-07 17:23:42	10003
2025	2024-06-13	WT	3	2024-06-15 06:00:00	2024-06-15 14:00:00	7309	TracyG	2024-06-07 17:23:42	10005
2029	2024-04-17	WT	2	2024-04-17 06:15:00	2024-04-17 15:00:00	7005	AllistineN	2024-04-18 16:17:59	8748
2029	2024-04-17	WT	2	2024-04-16 06:15:00	2024-04-16 15:00:00	7005	AllistineN	2024-04-18 16:17:59	8746
2029	2024-05-15	FE	7	2024-05-10 05:00:00	2024-05-10 13:30:00	7273	AndreaB	2024-06-06 13:44:24	9646
2029	2024-05-15	FE	7	2024-05-17 05:00:00	2024-05-17 15:00:00	7273	AndreaB	2024-06-06 13:44:24	9648
2029	2024-05-15	FE	7	2024-05-16 05:00:00	2024-05-16 15:00:00	7273	AndreaB	2024-06-06 13:44:24	9649
2029	2024-05-15	FE	7	2024-05-13 05:00:00	2024-05-13 15:00:00	7273	AndreaB	2024-06-06 13:44:24	9651
2029	2024-05-15	FE	7	2024-05-21 05:00:00	2024-05-21 14:15:00	7273	AndreaB	2024-06-06 13:44:24	9645
2029	2024-05-15	FE	7	2024-05-22 05:00:00	2024-05-22 15:00:00	7273	AndreaB	2024-06-06 13:44:24	9652
2029	2024-05-15	FE	7	2024-05-09 05:00:00	2024-05-09 14:00:00	7273	AndreaB	2024-06-06 13:44:24	9647
2029	2024-06-07	WT	3	2024-06-11 05:45:00	2024-06-11 16:05:00	7330	AndreaB	2024-06-10 15:22:56	9690
2029	2024-06-07	WT	3	2024-06-06 05:55:00	2024-06-06 16:05:00	7330	AndreaB	2024-06-10 15:22:56	9688
2029	2024-06-07	WT	3	2024-06-10 06:00:00	2024-06-10 15:45:00	7330	AndreaB	2024-06-10 15:22:56	9689
2029	2024-06-24	WT	2	2024-06-24 05:45:00	2024-06-24 16:15:00	7708	EnverP	2024-06-27 15:07:43	10227
2029	2024-06-24	WT	2	2024-06-20 06:10:00	2024-06-20 15:50:00	7708	EnverP	2024-06-27 15:07:43	10216
2029	2024-06-24	NA	2	2024-06-19 06:00:00	2024-06-19 18:35:00	7708	EnverP	2024-06-27 15:07:43	10212
2029	2024-06-24	NA	2	2024-06-18 06:00:00	2024-06-18 15:50:00	7708	EnverP	2024-06-27 15:07:43	10208
2035	2024-05-15	FE	24	2024-01-30 08:30:00	2024-01-30 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9558
2035	2024-05-15	FE	24	2024-02-17 08:30:00	2024-02-17 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9573
2035	2024-05-15	FE	24	2024-04-03 08:30:00	2024-04-03 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9618
2035	2024-05-15	FE	24	2024-04-26 08:00:00	2024-04-26 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9697
2035	2024-05-15	FE	24	2024-04-27 08:00:00	2024-04-27 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9698
2035	2024-05-15	FE	24	2024-04-28 08:30:00	2024-04-28 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9699
2035	2024-05-15	FE	24	2024-03-02 08:30:00	2024-03-02 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9600
2035	2024-05-15	FE	24	2024-04-08 08:00:00	2024-04-08 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9696
2035	2024-05-15	FE	24	2024-02-03 08:30:00	2024-02-03 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9560
2035	2024-05-15	FE	24	2024-03-19 08:30:00	2024-03-19 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9603
2035	2024-05-15	FE	24	2024-02-27 08:30:00	2024-02-27 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9582
2035	2024-05-15	FE	24	2024-02-04 08:30:00	2024-02-04 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9563
2035	2024-05-15	FE	24	2024-03-01 08:30:00	2024-03-01 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9598
2035	2024-05-15	FE	24	2024-04-06 08:00:00	2024-04-06 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9622
2035	2024-05-15	FE	24	2024-01-28 08:30:00	2024-01-28 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9554
2035	2024-05-15	FE	24	2024-01-29 08:30:00	2024-01-29 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9556
2035	2024-05-15	FE	24	2024-02-05 08:30:00	2024-02-05 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9564
2035	2024-05-15	FE	24	2024-02-15 08:30:00	2024-02-15 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9569
2035	2024-05-15	FE	24	2024-02-18 08:30:00	2024-02-18 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9578
2035	2024-05-15	FE	24	2024-02-24 08:30:00	2024-02-24 16:00:00	7273	AndreaB	2024-06-06 13:44:24	9580
2035	2024-05-15	FE	24	2024-05-03 08:30:00	2024-05-03 16:00:00	7273	AndreaB	2024-06-06 13:44:24	10278
2035	2024-05-15	FE	24	2024-05-14 08:30:00	2024-05-14 16:00:00	7273	AndreaB	2024-06-06 13:44:24	10275
2035	2024-05-15	FE	24	2024-05-09 08:30:00	2024-05-09 16:00:00	7273	AndreaB	2024-06-06 13:44:24	10276
2035	2024-05-15	FE	24	2024-05-04 08:30:00	2024-05-04 16:00:00	7273	AndreaB	2024-06-06 13:44:24	10277
2057	2024-01-26	WT	3	2024-01-26 11:00:00	2024-01-26 14:00:00	6129	JudikaE	2024-02-13 14:46:02	7413
2057	2024-01-26	WT	3	2024-01-11 03:00:00	2024-01-11 16:00:00	6129	JudikaE	2024-02-13 14:46:02	7414
2057	2024-01-26	WT	3	2024-01-04 10:00:00	2024-01-04 15:30:00	6129	JudikaE	2024-02-13 14:46:02	7415
2057	2024-02-04	WT	2	2024-02-04 08:00:00	2024-02-04 16:30:00	6130	JudikaE	2024-02-13 15:01:38	7416
2057	2024-02-04	WT	2	2024-02-03 09:00:00	2024-02-03 17:00:00	6130	JudikaE	2024-02-13 15:01:38	7417
2057	2024-02-12	FE	33	2023-07-19 07:00:00	2023-07-19 15:00:00	6110	AllistineN	2024-02-12 15:58:43	7349
2057	2024-02-12	FE	33	2023-07-22 08:15:00	2023-07-22 16:30:00	6110	AllistineN	2024-02-12 15:58:43	7350
2057	2024-02-12	FE	33	2023-07-23 07:00:00	2023-07-23 17:00:00	6110	AllistineN	2024-02-12 15:58:43	7351
2057	2024-02-12	FE	33	2023-07-30 07:30:00	2023-07-30 16:30:00	6110	AllistineN	2024-02-12 15:58:43	7353
2057	2024-02-12	FE	33	2023-07-05 09:30:00	2023-07-05 17:00:00	6110	AllistineN	2024-02-12 15:58:43	7346
2057	2024-02-12	FE	33	2023-07-08 20:00:00	2024-02-12 16:20:00	6110	AllistineN	2024-02-12 15:58:43	7347
2057	2024-02-12	FE	33	2023-07-26 08:00:00	2023-07-26 15:30:00	6110	AllistineN	2024-02-12 15:58:43	7352
2057	2024-02-12	FE	33	2023-07-12 09:00:00	2024-02-12 16:00:00	6110	AllistineN	2024-02-12 15:58:43	7348
2057	2024-02-12	FE	33	2023-08-02 07:00:00	2023-08-02 19:00:00	6111	AllistineN	2024-02-12 16:31:26	7354
2057	2024-02-12	FE	33	2023-08-10 07:00:00	2023-08-10 16:00:00	6111	AllistineN	2024-02-12 16:31:26	7356
2057	2024-02-12	FE	33	2023-08-21 06:30:00	2023-08-21 16:00:00	6111	AllistineN	2024-02-12 16:31:26	7358
2057	2024-02-12	FE	33	2023-08-23 07:00:00	2023-08-23 13:00:00	6111	AllistineN	2024-02-12 16:31:26	7359
2057	2024-02-12	FE	33	2023-08-26 07:30:00	2023-08-26 14:00:00	6111	AllistineN	2024-02-12 16:31:26	7360
2057	2024-02-12	FE	33	2023-10-07 09:00:00	2023-10-07 13:45:00	6113	AllistineN	2024-02-12 17:28:14	7368
2057	2024-02-12	FE	33	2022-11-03 07:00:00	2023-11-03 16:30:00	6114	AllistineN	2024-02-12 17:34:29	7370
2057	2024-02-12	FE	33	2023-11-06 06:30:00	2023-11-06 15:00:00	6114	AllistineN	2024-02-12 17:34:29	7371
2057	2024-02-12	FE	33	2023-05-01 08:00:00	2023-05-01 17:00:00	6107	AllistineN	2024-02-12 15:02:08	7330
2057	2024-02-12	FE	33	2023-05-03 09:00:00	2023-05-03 16:00:00	6107	AllistineN	2024-02-12 15:02:08	7332
2057	2024-02-12	FE	33	2023-05-04 08:00:00	2023-05-04 16:00:00	6107	AllistineN	2024-02-12 15:02:08	7334
2057	2024-02-12	FE	33	2023-05-10 06:30:00	2023-05-10 16:45:00	6107	AllistineN	2024-02-12 15:02:08	7336
2057	2024-02-12	FE	33	2023-05-13 07:00:00	2023-05-13 16:00:00	6107	AllistineN	2024-02-12 15:02:08	7337
2057	2024-02-12	FE	33	2023-05-18 07:30:00	2023-05-18 15:00:00	6107	AllistineN	2024-02-12 15:02:08	7338
2057	2024-02-12	FE	33	2023-05-20 09:00:00	2023-05-20 17:00:00	6107	AllistineN	2024-02-12 15:02:08	7339
2057	2024-02-12	FE	33	2023-05-05 07:00:00	2023-05-05 17:30:00	6107	AllistineN	2024-02-12 15:02:08	7335
2057	2024-02-12	FE	33	2023-09-15 06:30:00	2023-09-15 15:00:00	6112	AllistineN	2024-02-12 16:59:14	7365
2057	2024-02-12	FE	33	2023-09-30 07:00:00	2024-02-12 13:30:00	6112	AllistineN	2024-02-12 16:59:14	7367
2057	2024-02-12	FE	33	2023-09-21 08:00:00	2023-09-21 12:00:00	6112	AllistineN	2024-02-12 16:59:14	7366
2057	2024-02-12	FE	33	2023-06-14 08:00:00	2023-06-14 16:00:00	6109	AllistineN	2024-02-12 15:35:41	7342
2057	2024-02-12	FE	33	2023-06-21 09:00:00	2023-06-21 15:30:00	6109	AllistineN	2024-02-12 15:35:41	7343
2057	2024-02-12	FE	33	2023-06-02 10:00:00	2023-06-02 15:30:00	6109	AllistineN	2024-02-12 15:35:41	7340
2057	2024-02-12	FE	33	2023-06-07 07:00:00	2023-06-07 17:00:00	6109	AllistineN	2024-02-12 15:35:41	7341
2057	2024-02-12	FE	33	2023-06-30 08:00:00	2023-06-30 16:00:00	6109	AllistineN	2024-02-12 15:35:41	7345
2057	2024-02-12	FE	33	2023-06-28 07:00:00	2023-06-28 17:00:00	6109	AllistineN	2024-02-12 15:35:41	7344
2057	2024-02-12	WT	7	2023-10-15 08:00:00	2023-10-15 15:00:00	6113	AllistineN	2024-02-12 17:28:14	7373
2057	2024-02-12	WT	7	2023-10-26 08:30:00	2023-10-26 11:30:00	6113	AllistineN	2024-02-12 17:28:14	7374
2057	2024-02-12	WT	7	2023-10-16 07:00:00	2023-10-16 14:00:00	6113	AllistineN	2024-02-12 17:28:14	7375
2057	2024-02-12	WT	7	2023-10-14 10:00:00	2023-10-14 17:00:00	6113	AllistineN	2024-02-12 17:28:14	7372
2057	2024-02-12	WT	7	2023-11-22 11:30:00	2023-11-22 15:00:00	6114	AllistineN	2024-02-12 17:34:29	7406
2057	2024-02-12	WT	7	2023-11-24 07:00:00	2023-11-24 11:15:00	6114	AllistineN	2024-02-12 17:34:29	7407
2057	2024-02-12	WT	7	2023-11-24 12:00:00	2023-11-24 16:00:00	6114	AllistineN	2024-02-12 17:34:29	7408
2057	2024-02-12	NA	2	2023-08-08 09:00:00	2023-08-08 12:00:00	6111	AllistineN	2024-02-12 16:31:26	7355
2057	2024-02-12	NA	2	2023-08-16 08:00:00	2023-08-16 17:00:00	6111	AllistineN	2024-02-12 16:31:26	7357
2057	2024-04-20	FE	8	2024-04-20 06:00:00	2024-04-20 15:00:00	7196	ThrizenL	2024-05-23 15:52:33	9196
2057	2024-04-20	FE	8	2024-05-09 06:00:00	2024-05-09 15:00:00	7196	ThrizenL	2024-05-23 15:52:33	9201
2057	2024-04-20	FE	8	2024-05-16 06:00:00	2024-05-16 15:00:00	7196	ThrizenL	2024-05-23 15:52:33	9203
2057	2024-04-20	FE	8	2024-04-27 06:00:00	2024-04-27 14:00:00	7196	ThrizenL	2024-05-23 15:52:33	9197
2057	2024-04-20	FE	8	2024-05-17 06:00:00	2024-05-17 15:00:00	7196	ThrizenL	2024-05-23 15:52:33	9204
2057	2024-04-20	FE	8	2024-04-29 06:00:00	2024-04-29 15:00:00	7196	ThrizenL	2024-05-23 15:52:33	9199
2057	2024-04-20	FE	8	2024-05-20 06:00:00	2024-05-20 15:00:00	7196	ThrizenL	2024-05-23 15:52:33	9206
2057	2024-04-20	FE	8	2024-05-03 06:00:00	2024-05-03 15:00:00	7196	ThrizenL	2024-05-23 15:52:33	9200
2067	2024-02-22	NA	2	2024-02-13 16:00:00	2024-02-14 07:00:00	6306	KadeanS	2024-02-22 14:49:30	7697
2067	2024-02-22	NA	2	2024-01-31 16:00:00	2024-02-01 06:30:00	6306	KadeanS	2024-02-22 14:49:30	7696
2100	2024-01-18	FE	2	2024-01-18 07:00:00	2024-01-18 15:00:00	5701	DoretW	2024-01-26 19:38:52	6841
2100	2024-01-18	FE	2	2023-12-18 06:30:00	2023-12-18 09:30:00	5641	DoretW	2024-01-24 19:18:57	6781
2100	2024-02-16	FE	2	2024-02-16 11:30:00	2024-02-16 12:30:00	6261	DoretW	2024-02-20 18:25:14	8269
2100	2024-02-16	FE	2	2024-02-16 13:00:00	2024-02-16 15:00:00	6261	DoretW	2024-02-20 18:25:14	8270
2100	2024-03-04	FE	8	2024-02-28 07:00:00	2024-02-28 15:30:00	6443	DoretW	2024-03-04 15:46:52	7897
2100	2024-03-04	FE	8	2024-02-23 07:00:00	2024-02-23 15:00:00	6443	DoretW	2024-03-04 15:46:52	7894
2100	2024-03-04	FE	8	2024-02-21 07:00:00	2024-02-21 15:00:00	6443	DoretW	2024-03-04 15:46:52	7892
2100	2024-03-04	FE	8	2024-02-29 07:00:00	2024-02-29 14:45:00	6443	DoretW	2024-03-04 15:46:52	7898
2100	2024-03-04	FE	8	2024-03-01 07:00:00	2024-03-01 14:45:00	6443	DoretW	2024-03-04 15:46:52	7899
2100	2024-03-04	FE	8	2024-02-26 07:00:00	2024-02-26 15:30:00	6443	DoretW	2024-03-04 15:46:52	7895
2100	2024-03-04	FE	8	2024-02-22 07:00:00	2024-02-22 15:00:00	6443	DoretW	2024-03-04 15:46:52	7893
2100	2024-03-04	FE	8	2024-02-27 07:00:00	2024-02-27 15:30:00	6443	DoretW	2024-03-04 15:46:52	7896
2100	2024-05-17	FE	18	2024-04-27 06:30:00	2024-04-27 16:00:00	7157	DoretW	2024-05-17 17:48:33	9088
2100	2024-05-17	FE	18	2024-04-30 06:30:00	2024-04-30 16:00:00	7157	DoretW	2024-05-17 17:48:33	9090
2100	2024-05-17	FE	18	2024-05-04 07:30:00	2024-05-04 15:30:00	7157	DoretW	2024-05-17 17:48:33	9094
2100	2024-05-17	FE	18	2024-05-13 07:30:00	2024-05-13 14:00:00	7157	DoretW	2024-05-17 17:48:33	9100
2100	2024-05-17	FE	18	2024-05-15 06:00:00	2024-05-15 15:30:00	7157	DoretW	2024-05-17 17:48:33	9102
2100	2024-05-17	FE	18	2024-04-26 06:30:00	2024-04-26 16:00:00	7157	DoretW	2024-05-17 17:48:33	9087
2100	2024-05-17	FE	18	2024-04-29 06:30:00	2024-04-29 16:00:00	7157	DoretW	2024-05-17 17:48:33	9089
2100	2024-05-17	FE	18	2024-05-06 07:30:00	2024-05-06 15:30:00	7157	DoretW	2024-05-17 17:48:33	9095
2100	2024-05-17	FE	18	2024-05-08 07:30:00	2024-05-08 14:00:00	7157	DoretW	2024-05-17 17:48:33	9097
2100	2024-05-17	FE	18	2024-05-09 07:30:00	2024-05-09 14:00:00	7157	DoretW	2024-05-17 17:48:33	9098
2100	2024-05-17	FE	18	2024-05-10 07:30:00	2024-05-10 14:00:00	7157	DoretW	2024-05-17 17:48:33	9099
2100	2024-05-17	FE	18	2024-05-16 06:00:00	2024-05-16 15:30:00	7157	DoretW	2024-05-17 17:48:33	9103
2100	2024-05-17	FE	18	2024-05-01 06:30:00	2024-05-01 16:00:00	7157	DoretW	2024-05-17 17:48:33	9091
2100	2024-05-17	FE	18	2024-05-07 07:30:00	2024-05-07 15:30:00	7157	DoretW	2024-05-17 17:48:33	9096
2100	2024-05-17	FE	18	2024-05-14 07:30:00	2024-05-14 14:00:00	7157	DoretW	2024-05-17 17:48:33	9101
2100	2024-05-17	FE	18	2024-05-17 06:00:00	2024-05-17 15:30:00	7157	DoretW	2024-05-17 17:48:33	9104
2100	2024-05-17	FE	18	2024-05-02 07:30:00	2024-05-02 15:30:00	7157	DoretW	2024-05-17 17:48:33	9092
2100	2024-05-17	FE	18	2024-05-03 07:30:00	2024-05-03 15:30:00	7157	DoretW	2024-05-17 17:48:33	9093
2100	2024-06-14	FE	5	2024-06-13 07:00:00	2024-06-13 15:30:00	7320	TracyG	2024-06-07 17:31:32	9731
2100	2024-06-14	FE	5	2024-06-12 07:00:00	2024-06-12 15:30:00	7320	TracyG	2024-06-07 17:31:32	9730
2100	2024-06-14	FE	5	2024-06-14 07:00:00	2024-06-14 15:30:00	7320	TracyG	2024-06-07 17:31:32	9732
2100	2024-06-14	FE	5	2024-06-08 07:00:00	2024-06-08 15:30:00	7320	TracyG	2024-06-07 17:31:32	9725
2100	2024-06-14	FE	5	2024-06-10 07:00:00	2024-06-10 15:30:00	7320	TracyG	2024-06-07 17:31:32	9728
2120	2024-04-29	WT	2	2024-04-29 07:30:00	2024-04-29 14:15:00	7077	AllistineN	2024-04-30 15:15:10	8945
2120	2024-04-29	WT	2	2024-04-29 08:00:00	2024-04-29 12:25:00	7076	AshodeF	2024-04-30 14:55:09	8936
2180	2024-01-03	WT	2	2024-01-03 06:30:00	2024-01-03 17:30:00	5541	VenrickN	2024-01-15 15:02:17	6646
2180	2024-01-03	WT	2	2024-01-02 17:30:00	2024-01-03 06:00:00	5541	VenrickN	2024-01-15 15:02:17	6645
2180	2024-01-12	WT	2	2024-01-11 17:00:00	2024-01-12 05:30:00	5624	VenrickN	2024-01-23 13:57:53	6758
2180	2024-01-12	WT	2	2024-01-12 06:30:00	2024-01-12 15:30:00	5624	VenrickN	2024-01-23 13:57:53	6759
2263	2024-02-23	WT	3	2024-02-23 06:30:00	2024-02-23 14:25:00	6344	AshodeF	2024-02-26 15:56:14	7793
2263	2024-02-23	WT	3	2024-02-15 08:00:00	2024-02-15 15:55:00	6323	JudikaE	2024-02-23 15:01:42	7753
2263	2024-02-23	WT	3	2024-02-21 05:30:00	2024-02-21 15:50:00	6327	JudikaE	2024-02-23 17:49:47	7770
2281	2024-04-06	FE	3	2024-02-24 06:00:00	2024-02-24 15:00:00	6996	TracyG	2024-04-17 13:36:57	8702
2281	2024-04-06	FE	3	2024-02-27 06:00:00	2024-02-27 15:00:00	6996	TracyG	2024-04-17 13:36:57	8703
2281	2024-04-06	FE	3	2024-03-01 06:00:00	2024-03-01 15:00:00	6996	TracyG	2024-04-17 13:36:57	8704
2281	2024-04-07	FE	3	2024-03-08 06:00:00	2024-03-08 15:00:00	6997	TracyG	2024-04-17 14:08:45	8707
2281	2024-04-07	FE	3	2024-04-07 06:00:00	2024-04-07 14:00:00	6997	TracyG	2024-04-17 14:08:45	8705
2281	2024-04-07	FE	3	2024-03-16 15:00:00	2024-03-16 15:00:00	6997	TracyG	2024-04-17 14:08:45	8710
2281	2024-04-09	FE	3	2024-03-20 06:00:00	2024-03-20 16:00:00	7001	TracyG	2024-04-17 15:38:32	8719
2281	2024-04-09	FE	3	2024-03-21 06:00:00	2024-03-21 15:00:00	7001	TracyG	2024-04-17 15:38:32	8720
2281	2024-04-09	FE	3	2024-03-18 06:00:00	2024-03-18 15:00:00	7001	TracyG	2024-04-17 15:38:32	8718
2281	2024-04-10	FE	2	2024-03-25 06:00:00	2024-03-25 15:00:00	7002	TracyG	2024-04-17 15:57:46	8721
2281	2024-04-10	FE	2	2024-03-27 06:00:00	2024-03-27 15:00:00	7002	TracyG	2024-04-17 15:57:46	8722
2300	2024-01-04	FE	2	2024-01-04 05:00:00	2024-01-04 08:30:00	5452	DoretW	2024-01-04 20:42:06	6532
2300	2024-01-04	FE	2	2023-12-28 14:00:00	2023-12-28 17:00:00	5446	DoretW	2024-01-04 19:58:57	6526
2300	2024-02-26	FE	2	2024-02-26 08:00:00	2024-02-26 12:00:00	6380	DoretW	2024-02-28 13:57:59	7821
2300	2024-02-26	FE	2	2024-02-25 06:00:00	2024-02-25 11:00:00	6380	DoretW	2024-02-28 13:57:59	7820
2300	2024-03-05	FE	3	2024-03-03 09:00:00	2024-03-03 12:00:00	6480	DoretW	2024-03-06 16:34:15	7942
2300	2024-03-05	FE	3	2024-03-01 06:00:00	2024-03-01 17:00:00	6480	DoretW	2024-03-06 16:34:15	7940
2300	2024-03-05	FE	3	2024-03-02 10:00:00	2024-03-02 13:00:00	6480	DoretW	2024-03-06 16:34:15	7941
2300	2024-03-13	FE	3	2024-03-09 06:00:00	2024-03-09 11:00:00	6603	DoretW	2024-03-14 15:10:55	8105
2300	2024-03-13	FE	3	2024-03-11 06:00:00	2024-03-11 16:00:00	6603	DoretW	2024-03-14 15:10:55	8107
2300	2024-03-13	FE	3	2024-03-10 06:00:00	2024-03-10 14:00:00	6603	DoretW	2024-03-14 15:10:55	8106
2300	2024-03-15	FE	3	2024-03-14 06:00:00	2024-03-14 12:00:00	6620	DoretW	2024-03-15 16:45:10	8120
2300	2024-03-15	FE	3	2024-03-15 07:00:00	2024-03-15 13:00:00	6640	DoretW	2024-03-18 14:15:51	8140
2300	2024-03-15	FE	3	2024-03-16 06:00:00	2024-03-18 11:00:00	6640	DoretW	2024-03-18 14:15:51	8141
2300	2024-03-25	FE	2	2024-03-24 09:00:00	2024-03-24 12:00:00	6780	DoretW	2024-03-26 13:54:10	8341
2300	2024-03-25	FE	2	2024-03-23 06:00:00	2024-03-23 11:00:00	6780	DoretW	2024-03-26 13:54:10	8340
2300	2024-04-02	FE	3	2024-03-31 06:00:00	2024-03-31 11:00:00	6840	DoretW	2024-04-02 14:41:52	8424
2300	2024-04-02	FE	3	2024-03-30 06:00:00	2024-03-30 10:00:00	6840	DoretW	2024-04-02 14:41:52	8421
2300	2024-04-02	FE	3	2024-03-29 06:00:00	2024-03-29 16:00:00	6840	DoretW	2024-04-02 14:41:52	8420
2300	2024-04-09	FE	3	2024-04-07 06:00:00	2024-04-07 11:00:00	6962	DoretW	2024-04-09 16:48:24	8592
2300	2024-04-09	FE	3	2024-04-06 06:00:00	2024-04-06 10:00:00	6962	DoretW	2024-04-09 16:48:24	8591
2300	2024-04-09	FE	3	2024-04-08 06:00:00	2024-04-08 17:00:00	6962	DoretW	2024-04-09 16:48:24	8594
2300	2024-04-13	FE	4	2024-04-13 06:00:00	2024-04-13 12:00:00	7017	DoretW	2024-04-22 14:57:32	8778
2300	2024-04-13	FE	4	2024-04-14 06:00:00	2024-04-14 13:00:00	7017	DoretW	2024-04-22 14:57:32	8779
2300	2024-04-13	FE	4	2024-04-20 06:00:00	2024-04-20 12:00:00	7017	DoretW	2024-04-22 14:57:32	8780
2300	2024-04-13	FE	4	2024-04-21 05:30:00	2024-04-21 09:00:00	7017	DoretW	2024-04-22 14:57:32	8781
2300	2024-05-10	FE	5	2024-05-04 07:00:00	2024-05-04 17:00:00	7137	DoretW	2024-05-10 15:31:46	9036
2300	2024-05-10	FE	5	2024-05-05 08:00:00	2024-05-05 13:00:00	7137	DoretW	2024-05-10 15:31:46	9037
2300	2024-05-10	FE	5	2024-05-06 08:00:00	2024-05-06 11:00:00	7137	DoretW	2024-05-10 15:31:46	9038
2300	2024-05-10	FE	5	2024-05-07 06:00:00	2024-05-07 10:00:00	7137	DoretW	2024-05-10 15:31:46	9039
2300	2024-05-10	FE	5	2024-05-08 14:00:00	2024-05-08 17:00:00	7137	DoretW	2024-05-10 15:31:46	9040
2300	2024-05-22	FE	3	2024-05-18 06:00:00	2024-05-18 10:00:00	7192	AndreaB	2024-05-23 13:16:20	9184
2300	2024-05-22	FE	3	2024-05-19 08:00:00	2024-05-19 15:00:00	7192	AndreaB	2024-05-23 13:16:20	9185
2300	2024-05-22	FE	3	2024-05-20 07:00:00	2024-05-20 13:00:00	7192	AndreaB	2024-05-23 13:16:20	9186
2300	2024-05-31	FE	2	2024-05-25 08:00:00	2024-05-25 15:00:00	7283	AndreaB	2024-06-07 14:02:26	9602
2300	2024-05-31	FE	2	2024-05-26 08:00:00	2024-05-26 13:00:00	7283	AndreaB	2024-06-07 14:02:26	9604
2300	2024-06-03	FE	2	2024-06-01 07:00:00	2024-06-01 12:00:00	7284	AndreaB	2024-06-07 14:05:48	9623
2300	2024-06-03	FE	2	2024-06-02 08:00:00	2024-06-02 13:00:00	7284	AndreaB	2024-06-07 14:05:48	9624
2300	2024-06-27	FE	3	2024-06-22 06:00:00	2024-06-22 16:00:00	7647	TracyG	2024-06-21 18:09:05	10223
2300	2024-06-27	FE	3	2024-06-23 08:00:00	2024-06-23 12:00:00	7647	TracyG	2024-06-21 18:09:05	10224
2300	2024-06-27	FE	3	2024-06-26 07:00:00	2024-06-26 11:00:00	7647	TracyG	2024-06-21 18:09:05	10226
2320	2024-04-22	WT	41	2023-08-09 07:00:00	2023-08-09 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8774
2320	2024-04-22	WT	41	2023-08-10 07:00:00	2023-08-10 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8775
2320	2024-04-22	WT	41	2023-08-15 07:00:00	2023-08-15 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8819
2320	2024-04-22	WT	41	2023-08-20 07:00:00	2023-08-20 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8821
2320	2024-04-22	WT	41	2023-09-04 07:00:00	2023-09-04 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8823
2320	2024-04-22	WT	41	2023-09-07 07:00:00	2023-09-07 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8824
2320	2024-04-22	WT	41	2023-09-29 07:00:00	2023-09-29 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8827
2320	2024-04-22	WT	41	2023-10-05 07:00:00	2023-10-05 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8828
2320	2024-04-22	WT	41	2023-10-06 07:00:00	2023-10-06 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8829
2320	2024-04-22	WT	41	2023-08-13 07:00:00	2023-08-13 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8818
2320	2024-04-22	WT	41	2023-09-12 07:00:00	2023-09-12 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8825
2320	2024-04-22	WT	41	2023-10-16 07:00:00	2023-10-16 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8830
2320	2024-04-22	WT	41	2023-11-28 08:00:00	2023-11-28 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8863
2320	2024-04-22	WT	41	2023-11-29 08:00:00	2023-11-29 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8864
2320	2024-04-22	WT	41	2023-10-18 07:00:00	2023-10-18 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8831
2320	2024-04-22	WT	41	2023-11-02 08:00:00	2023-11-02 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8849
2320	2024-04-22	WT	41	2023-11-03 08:00:00	2023-11-03 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8850
2320	2024-04-22	WT	41	2023-11-05 08:00:00	2023-11-05 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8852
2320	2024-04-22	WT	41	2023-08-16 07:00:00	2023-08-16 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8820
2320	2024-04-22	WT	41	2023-08-29 07:00:00	2023-08-29 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8822
2320	2024-04-22	WT	41	2023-10-23 07:00:00	2023-10-23 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8833
2320	2024-04-22	WT	41	2023-10-25 07:00:00	2023-10-25 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8834
2320	2024-04-22	WT	41	2023-10-29 07:00:00	2023-10-29 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8838
2320	2024-04-22	WT	41	2023-11-01 08:00:00	2023-11-01 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8847
2320	2024-04-22	WT	41	2023-11-07 08:00:00	2023-11-07 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8853
2320	2024-04-22	WT	41	2023-11-09 08:00:00	2023-11-09 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8856
2320	2024-04-22	WT	41	2023-11-21 08:00:00	2023-11-21 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8861
2320	2024-04-22	WT	41	2023-12-06 08:00:00	2023-12-06 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8866
2320	2024-04-22	WT	41	2023-12-19 08:00:00	2023-12-19 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8874
2320	2024-04-22	WT	41	2023-11-17 08:00:00	2023-11-17 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8859
2320	2024-04-22	WT	41	2023-10-27 07:00:00	2023-10-27 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8837
2320	2024-04-22	WT	41	2023-12-17 08:00:00	2023-12-17 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8869
2320	2024-04-22	WT	41	2023-12-29 08:00:00	2023-12-29 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8877
2320	2024-04-22	WT	41	2023-10-20 07:00:00	2023-10-20 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8832
2320	2024-04-22	WT	41	2023-10-30 07:00:00	2023-10-30 15:00:00	7014	AshodeF	2024-04-22 13:20:57	8840
2320	2024-04-22	WT	41	2023-11-08 08:00:00	2023-11-08 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8855
2320	2024-04-22	WT	41	2023-11-16 08:00:00	2023-11-16 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8858
2320	2024-04-22	WT	41	2023-12-15 08:00:00	2023-12-15 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8867
2320	2024-04-22	WT	41	2023-12-21 08:00:00	2023-12-21 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8875
2320	2024-04-22	WT	41	2023-12-28 08:00:00	2023-12-28 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8876
2320	2024-04-22	WT	41	2024-02-01 08:00:00	2024-02-01 16:00:00	7014	AshodeF	2024-04-22 13:20:57	8878
3485	2024-01-31	WT	2	2024-01-31 04:00:00	2024-01-31 09:00:00	5886	KadeanS	2024-02-08 16:54:49	7070
3485	2024-01-31	WT	2	2024-01-31 04:00:00	2024-01-31 14:00:00	5887	KadeanS	2024-02-08 17:00:56	7072
3485	2024-02-22	WT	5	2024-02-21 04:00:00	2024-02-21 09:00:00	6306	KadeanS	2024-02-22 14:49:30	7727
3485	2024-02-22	WT	5	2024-02-15 04:00:00	2024-02-15 13:30:00	6306	KadeanS	2024-02-22 14:49:30	7703
3485	2024-02-22	WT	5	2024-02-06 04:00:00	2024-02-06 09:00:00	6306	KadeanS	2024-02-22 14:49:30	7722
3485	2024-02-22	WT	5	2024-02-16 03:00:00	2024-02-16 07:00:00	6306	KadeanS	2024-02-22 14:49:30	7723
3485	2024-02-22	WT	5	2024-02-22 04:00:00	2024-02-22 10:00:00	6861	JudikaE	2024-04-03 14:43:51	8441
5480	2024-04-27	WT	4	2023-04-05 06:00:00	2023-04-05 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9227
5480	2024-04-27	WT	4	2023-04-18 06:00:00	2023-04-18 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9228
5480	2024-04-27	WT	4	2023-04-16 06:00:00	2023-04-16 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9297
5480	2024-04-27	WT	4	2023-04-04 06:00:00	2024-05-27 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9225
5480	2024-05-27	FE	7	2023-03-09 06:00:00	2023-03-09 13:00:00	7214	AndreaB	2024-05-27 13:34:53	9455
5480	2024-05-27	FE	7	2023-03-13 06:00:00	2023-03-13 13:00:00	7214	AndreaB	2024-05-27 13:34:53	9460
5480	2024-05-27	FE	7	2023-03-14 06:00:00	2023-03-14 13:00:00	7214	AndreaB	2024-05-27 13:34:53	9461
5480	2024-05-27	FE	7	2023-03-28 06:00:00	2023-03-28 13:00:00	7214	AndreaB	2024-05-27 13:34:53	9464
5480	2024-05-27	FE	7	2023-03-06 06:00:00	2023-03-06 13:00:00	7214	AndreaB	2024-05-27 13:34:53	9233
5480	2024-05-27	FE	7	2023-03-03 06:00:00	2023-03-03 13:00:00	7214	AndreaB	2024-05-27 13:34:53	9235
5480	2024-05-27	FE	7	2023-03-08 06:00:00	2023-03-08 13:00:00	7214	AndreaB	2024-05-27 13:34:53	9237
5540	2024-04-27	WT	25	2023-04-15 06:00:00	2023-04-15 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9282
5540	2024-04-27	WT	25	2023-04-25 06:00:00	2023-04-25 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9303
5540	2024-04-27	WT	25	2023-04-20 06:00:00	2023-04-20 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9306
5540	2024-04-27	WT	25	2023-04-28 06:00:00	2023-04-28 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9308
5540	2024-04-27	WT	25	2023-04-03 06:00:00	2023-04-03 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9278
5540	2024-04-27	WT	25	2023-04-06 06:00:00	2023-04-06 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9279
5540	2024-04-27	WT	25	2023-04-12 06:00:00	2023-04-12 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9281
5540	2024-04-27	WT	25	2023-04-17 06:00:00	2023-04-17 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9283
5540	2024-04-27	WT	25	2023-04-19 06:00:00	2023-04-19 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9284
5540	2024-04-27	WT	25	2023-04-10 06:00:00	2023-04-10 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9280
5540	2024-04-27	WT	25	2023-04-23 06:00:00	2023-04-23 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9301
5540	2024-04-27	WT	25	2023-04-29 06:00:00	2023-04-29 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9304
5540	2024-04-27	WT	25	2023-04-24 06:00:00	2023-04-24 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9307
5540	2024-04-27	WT	25	2023-04-22 06:00:00	2023-04-22 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9285
5540	2024-04-27	WT	25	2023-03-16 06:00:00	2023-03-16 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9482
5540	2024-04-27	WT	25	2023-03-11 06:00:00	2023-06-03 18:00:00	7213	JudikaE	2024-05-27 13:05:52	9479
5540	2024-04-27	WT	25	2023-03-01 06:00:00	2023-03-01 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9473
5540	2024-04-27	WT	25	2023-03-02 06:00:00	2023-03-02 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9474
5540	2024-04-27	WT	25	2023-03-09 06:00:00	2023-03-09 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9477
5540	2024-04-27	WT	25	2023-03-12 06:00:00	2023-03-12 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9480
5540	2024-04-27	WT	25	2023-03-28 06:00:00	2023-03-28 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9486
5540	2024-04-27	WT	25	2023-03-06 06:00:00	2023-03-06 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9475
5540	2024-04-27	WT	25	2023-03-20 06:00:00	2023-03-20 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9483
5540	2024-04-27	WT	25	2023-03-24 06:00:00	2023-03-24 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9485
5540	2024-04-27	WT	25	2023-03-30 06:00:00	2023-03-30 13:00:00	7213	JudikaE	2024-05-27 13:05:52	9488
5597	2024-03-13	FE	3	2024-03-05 06:00:00	2024-03-05 15:00:00	6603	DoretW	2024-03-14 15:10:55	8095
5597	2024-03-13	FE	3	2024-03-07 06:30:00	2024-03-07 15:00:00	6603	DoretW	2024-03-14 15:10:55	8100
5597	2024-03-13	FE	3	2024-03-06 06:30:00	2024-03-06 15:00:00	6603	DoretW	2024-03-14 15:10:55	8099
5597	2024-04-04	FE	14	2024-03-08 07:00:00	2024-03-08 11:00:00	6875	DoretW	2024-04-04 16:12:54	8455
5597	2024-04-04	FE	14	2024-03-09 07:00:00	2024-03-09 11:00:00	6875	DoretW	2024-04-04 16:12:54	8456
5597	2024-04-04	FE	14	2024-03-11 07:00:00	2024-03-11 11:00:00	6875	DoretW	2024-04-04 16:12:54	8457
5597	2024-04-04	FE	14	2024-03-15 07:00:00	2024-03-15 15:30:00	6875	DoretW	2024-04-04 16:12:54	8461
5597	2024-04-04	FE	14	2024-03-12 07:00:00	2024-03-12 11:00:00	6875	DoretW	2024-04-04 16:12:54	8458
5597	2024-04-04	FE	14	2024-03-14 07:00:00	2024-04-04 13:42:07	6875	DoretW	2024-04-04 16:12:54	8460
5597	2024-04-04	FE	14	2024-03-23 07:00:00	2024-03-23 15:00:00	6875	DoretW	2024-04-04 16:12:54	8465
5597	2024-04-04	FE	14	2024-03-25 07:00:00	2024-03-25 15:00:00	6875	DoretW	2024-04-04 16:12:54	8466
5597	2024-04-04	FE	14	2024-03-13 07:00:00	2024-03-13 11:00:00	6875	DoretW	2024-04-04 16:12:54	8459
5597	2024-04-04	FE	14	2024-03-16 07:00:00	2024-03-16 15:30:00	6875	DoretW	2024-04-04 16:12:54	8462
5597	2024-04-04	FE	14	2024-03-27 07:00:00	2024-03-27 15:00:00	6875	DoretW	2024-04-04 16:12:54	8467
5597	2024-04-04	FE	14	2024-03-19 07:00:00	2024-03-19 15:30:00	6875	DoretW	2024-04-04 16:12:54	8463
5597	2024-04-04	FE	14	2024-03-21 07:00:00	2024-03-21 15:30:00	6875	DoretW	2024-04-04 16:12:54	8464
5597	2024-04-04	FE	14	2024-03-28 07:00:00	2024-03-28 15:00:00	6875	DoretW	2024-04-04 16:12:54	8468
5597	2024-04-29	FE	15	2024-04-02 07:00:00	2024-04-02 17:30:00	7075	DoretW	2024-04-30 14:41:42	8937
5597	2024-04-29	FE	15	2024-04-06 06:30:00	2024-04-06 15:00:00	7075	DoretW	2024-04-30 14:41:42	8941
5597	2024-04-29	FE	15	2024-04-10 06:30:00	2024-04-10 15:00:00	7075	DoretW	2024-04-30 14:41:42	8943
5597	2024-04-29	FE	15	2024-04-17 07:00:00	2024-04-17 16:00:00	7075	DoretW	2024-04-30 14:41:42	8948
5597	2024-04-29	FE	15	2024-04-19 07:00:00	2024-04-19 16:00:00	7075	DoretW	2024-04-30 14:41:42	8950
5597	2024-04-29	FE	15	2024-04-23 07:00:00	2024-04-23 16:00:00	7075	DoretW	2024-04-30 14:41:42	8952
5597	2024-04-29	FE	15	2024-04-01 06:30:00	2024-04-01 15:00:00	7075	DoretW	2024-04-30 14:41:42	8935
5597	2024-04-29	FE	15	2024-04-13 06:30:00	2024-04-13 15:00:00	7075	DoretW	2024-04-30 14:41:42	8946
5597	2024-04-29	FE	15	2024-04-14 06:30:00	2024-04-14 15:00:00	7075	DoretW	2024-04-30 14:41:42	8947
5597	2024-04-29	FE	15	2024-04-20 07:00:00	2024-04-20 16:00:00	7075	DoretW	2024-04-30 14:41:42	8951
5597	2024-04-29	FE	15	2024-03-29 06:30:00	2024-03-29 15:00:00	7075	DoretW	2024-04-30 14:41:42	8933
5597	2024-04-29	FE	15	2024-03-31 06:30:00	2024-03-31 15:00:00	7075	DoretW	2024-04-30 14:41:42	8934
5597	2024-04-29	FE	15	2024-04-03 07:00:00	2024-04-03 17:30:00	7075	DoretW	2024-04-30 14:41:42	8939
5597	2024-04-29	FE	15	2024-04-05 06:30:00	2024-04-05 15:00:00	7075	DoretW	2024-04-30 14:41:42	8940
5597	2024-04-29	FE	15	2024-04-18 07:00:00	2024-04-18 16:00:00	7075	DoretW	2024-04-30 14:41:42	8949
5597	2024-05-31	FE	8	2024-05-31 06:30:00	2024-05-31 15:30:00	7282	AndreaB	2024-06-07 13:55:25	9621
5597	2024-05-31	FE	8	2024-05-20 06:00:00	2024-05-20 15:30:00	7282	AndreaB	2024-06-07 13:55:25	9607
5597	2024-05-31	FE	8	2024-05-24 06:00:00	2024-05-24 15:30:00	7282	AndreaB	2024-06-07 13:55:25	9611
5597	2024-05-31	FE	8	2024-05-27 06:00:00	2024-06-27 15:30:00	7282	AndreaB	2024-06-07 13:55:25	9614
5597	2024-05-31	FE	8	2024-05-23 06:00:00	2024-05-23 15:30:00	7282	AndreaB	2024-06-07 13:55:25	9608
5597	2024-05-31	FE	8	2024-05-25 06:00:00	2024-05-25 15:30:00	7282	AndreaB	2024-06-07 13:55:25	9613
5597	2024-05-31	FE	8	2024-05-30 06:30:00	2024-05-30 15:30:00	7282	AndreaB	2024-06-07 13:55:25	9620
5597	2024-05-31	FE	8	2024-05-28 06:00:00	2024-05-28 15:30:00	7282	AndreaB	2024-06-07 13:55:25	9617
5597	2024-06-07	FE	3	2024-06-06 06:30:00	2024-06-06 15:30:00	7326	AndreaB	2024-06-07 18:31:53	9633
5597	2024-06-07	FE	3	2024-06-05 06:30:00	2024-06-05 15:30:00	7326	AndreaB	2024-06-07 18:31:53	9632
5597	2024-06-07	FE	3	2024-06-07 06:30:00	2024-06-07 15:30:00	7326	AndreaB	2024-06-07 18:31:53	9634
5597	2024-06-25	FE	6	2024-06-17 06:30:00	2024-06-17 15:30:00	7643	TracyG	2024-06-21 18:07:45	10193
5597	2024-06-25	FE	6	2024-06-15 06:30:00	2024-06-15 15:30:00	7643	TracyG	2024-06-21 18:07:45	10192
5597	2024-06-25	FE	6	2024-06-20 06:30:00	2024-06-20 15:30:00	7643	TracyG	2024-06-21 18:07:45	10196
5597	2024-06-25	FE	6	2024-06-22 06:30:00	2024-06-22 15:30:00	7643	TracyG	2024-06-21 18:07:45	10197
5597	2024-06-25	FE	6	2024-06-18 06:30:00	2024-06-18 15:30:00	7643	TracyG	2024-06-21 18:07:45	10194
5597	2024-06-25	FE	6	2024-06-19 06:30:00	2024-06-19 15:30:00	7643	TracyG	2024-06-21 18:07:45	10195
5597	2024-07-24	FE	5	2024-07-23 07:00:00	2024-07-23 15:00:00	7896	TracyG	2024-07-19 18:04:56	10510
5597	2024-07-24	FE	5	2024-07-14 07:00:00	2024-07-14 15:00:00	7896	TracyG	2024-07-19 18:04:56	10506
5597	2024-07-24	FE	5	2024-07-15 07:00:00	2024-07-15 15:00:00	7896	TracyG	2024-07-19 18:04:56	10507
5597	2024-07-24	FE	5	2024-07-18 07:00:00	2024-07-18 15:00:00	7896	TracyG	2024-07-19 18:04:56	10508
5597	2024-07-24	FE	5	2024-07-22 07:00:00	2024-07-22 15:00:00	7896	TracyG	2024-07-19 18:04:56	10509

One could implement a unique id within the R-function, named e.g. .sid. We can test that via:

survey <- 
  survey |> 
  # just so we can get the original order back
  mutate(.rowid = 1:n()) |> 
  arrange(site, date, T1) |> 
  mutate(.sid = dplyr::consecutive_id(site, date)) |> 
  arrange(.rowid) |> 
  select(-.rowid)
survey |> 
  summarise(n_sid = n_distinct(.sid),
            n_surveyid = n_distinct(survey_id),
            .groups = "drop")
#> # A tibble: 1 × 2
#>   n_sid n_surveyid
#>   <int>      <int>
#> 1  2106       3033

One would use this table e.g. to get an overview of the reported sampled dates:

fm_survey(key, trim = FALSE) %>% 
  filter(year(date) == 2024,
         month(date) == 1) |> 
  select(site, date) |> 
  distinct() |> 
  mutate(survey = TRUE) |> 
  fm_grid_calendar() |> 
  mutate(weekend = ifelse(.wday %in% c("Sa", "Su"),
                          TRUE,
                          FALSE)) %>% 
  #filter(site == "Charlestown") |> 
  ggplot(aes(.wday, .week)) +
  theme_bw() +
  geom_tile(aes(fill = survey)) +
  facet_wrap(~ site) +
  geom_text(aes(label = .day, colour = weekend)) +
  scale_fill_manual(values=c("grey80", "pink")) +
  scale_colour_manual(values = c("black", "red")) +
  scale_y_reverse(NULL, NULL) +
  labs(x = NULL,
       title = "January 2024",
       caption = "colour: reported sampling day") +
  coord_equal() +
  theme(legend.position = "none",
        legend.title=element_blank(), 
        panel.grid=element_blank(), 
        panel.border=element_blank(), 
        axis.ticks=element_blank(), 
        strip.background=element_blank(), 
        #legend.position="top", 
        legend.justification="right", 
        legend.direction="horizontal", 
        legend.key.size=unit(0.3, "cm"), 
        legend.spacing.x=unit(0.2, "cm"))

This is some dummy

Some issues

Do not expect that one can create a survey without a survey date:

survey |> 
  filter(is.na(date)) |> 
  select(survey_id, site, date, status, T1, T2, n_boats = total_boats, comment,
         collector,
         .cn:.ut) |> 
  arrange(survey_id) |> 
  glimpse()
#> Rows: 103
#> Columns: 13
#> $ survey_id <dbl> 1446, 1447, 1451, 1455, 1463, 1476, 2127, 2202, 2203, 2282, …
#> $ site      <chr> "Basseterre West", "Basseterre West", "Basseterre West", "Ol…
#> $ date      <date> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
#> $ status    <chr> "In progress", "In progress", "In progress", "In progress", …
#> $ T1        <dttm> NA, NA, NA, NA, NA, NA, 2023-05-16 10:48:40, 2023-05-19 10:…
#> $ T2        <dttm> 2023-02-06 10:57:38, 2023-01-13 10:00:00, 2023-02-09 10:16:…
#> $ n_boats   <dbl> 2, 1, 1, 2, 1, NA, NA, NA, NA, NA, NA, NA, NA, 4, NA, NA, NA…
#> $ comment   <chr> NA, NA, "Feb 1 : Date not changing from 9", NA, NA, "11.30-6…
#> $ collector <chr> "Kenroy Tobias", "Enver Pemberton", "Enver Pemberton", NA, "…
#> $ .cn       <chr> "KenroyT", "DoretW", "EnverP", "DevonW", "AndreaB", "EnverP"…
#> $ .ct       <dttm> 2023-02-06 14:58:11, 2023-02-07 13:28:10, 2023-02-09 14:27:…
#> $ .un       <chr> "KenroyT", "DoretW", "EnverP", "DevonW", "sknadmin", "DevonW…
#> $ .ut       <dttm> 2023-02-06 14:58:11, 2023-02-07 13:28:10, 2023-02-09 14:27:…

The surveyitem table

This is effectively the trip table.

QC: Expect only one trip per vessel per day

trip |> 
  mutate(d1 = as_date(dep_time),
         d2 = as_date(arr_time)) |> 
  count(vid, d1) |> 
  count(n) |> 
  rename('Trips per day' = n, 
         'Number of records' = nn) |> 
  knitr::kable(caption = "Number of trips by vessels per day")

Number of trips by vessels per day
Trips per day	Number of records
1	4972
2	332
3	32
4	5
6	2

trip |> 
  mutate(d1 = as_date(dep_time))
#> # A tibble: 5,764 × 30
#>      vid vessel     regno owner operator dep_time            arr_time           
#>    <dbl> <chr>      <chr> <chr> <chr>    <dttm>              <dttm>             
#>  1  1892 God's Ble… V4-6… Keit… Valet P… 2023-01-05 05:00:00 2023-01-05 15:00:00
#>  2  1893 Togethern… V4-4… NA    NA       2023-01-12 09:15:00 2023-01-12 16:30:00
#>  3  1892 God's Ble… V4-6… Keit… Valet P… 2023-01-12 07:00:00 2023-01-12 16:00:00
#>  4  2029 Diver      V4-5… Alla… Allan T… 2023-01-12 04:00:00 2023-01-12 15:00:00
#>  5  1872 First Time V4-0… Stuy… Stuyesa… 2023-01-08 07:00:00 2023-01-08 15:00:00
#>  6  1997 Nizariah   V4-5… NA    NA       2023-02-16 06:00:00 2023-02-16 13:50:00
#>  7  1872 First Time V4-0… Stuy… Stuyesa… 2022-01-11 07:00:00 2023-01-11 12:50:00
#>  8  1994 Yes Lord   V4-4… Calv… Calvin … 2023-01-11 07:15:00 2023-01-11 13:30:00
#>  9  1996 Survival 2 V4-0… NA    NA       2023-01-11 03:05:00 2023-01-11 16:30:00
#> 10  2004 De Jungle  V4-4… Ray … Ray Lid… 2023-01-14 06:00:00 2023-01-14 11:00:00
#> # ℹ 5,754 more rows
#> # ℹ 23 more variables: fuel <dbl>, site1 <chr>, site2 <chr>, trip_id <dbl>,
#> #   survey_id <dbl>, comment <chr>, .cn <chr>, .ct <dttm>, .un <chr>,
#> #   .ut <dttm>, survey_item_type_id <dbl>, survey_item_status_id <dbl>,
#> #   hid1 <dbl>, dep_status_id <dbl>, hid2 <dbl>, arr_status_id <dbl>,
#> #   vessel_version <int>, secondary_vessel_id <dbl>,
#> #   secondary_vessel_version <int>, total_crew <int>, tenant_id <dbl>, …

The surveyitemdtl table

catch <- fmr::fm_catch(key)
catch |> glimpse()
#> Rows: 19,335
#> Columns: 17
#> $ gear             <chr> "Spear Gun", "Spear Gun", "Spear Gun", "Spear Gun", "…
#> $ gear_size        <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
#> $ no_of_sets       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
#> $ soak_time        <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
#> $ depth_min        <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
#> $ depth_max        <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
#> $ no_of_gears      <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 2, 2, 2, 2, 2,…
#> $ fz               <chr> "E6", "E6", "E6", "E6", "E6", "E6", "E6", "E6", "E6",…
#> $ lon              <dbl> -62.64, -62.64, -62.64, -62.64, -62.64, -62.64, -62.6…
#> $ lat              <dbl> 17.22, 17.22, 17.22, 17.22, 17.22, 17.22, 17.22, 17.2…
#> $ measurement_type <chr> "WT", "WT", "WT", "WT", "WT", "WT", "WT", "WT", "WT",…
#> $ species_id       <dbl> 2254, 2174, 2291, 2407, 2458, 2303, 2126, 2237, 2174,…
#> $ species          <chr> "Butter hamlet", "Squirrelfish", "Yellowtail snapper"…
#> $ weight           <dbl> 5, 12, 25, 40, 100, 12, 2, 5, 8, 3, 4, 150, 24, 6, 4,…
#> $ price            <dbl> 12, 12, 12, 20, 10, 14, 12, 12, 12, 12, 12, 10, 10, 1…
#> $ trip_id          <dbl> 1517, 1523, 1523, 1523, 1529, 1532, 1532, 1532, 1532,…
#> $ .s3              <dbl> 1691, 1703, 1706, 1707, 1718, 1724, 1725, 1727, 1728,…

The catch table (Survey item table)

pending further coding …

The wide tables

Combining these three data tables into a single wide-table is very common delivery approach when the downstream analysis is based on some kind of a spreadsheet software. The problem here though is that each measurements in the trip table gets repeated by the number of species recorded in the catch table and then the records associated with the sampling site get repeated by the number of trips. E.g. if on one sampling site within one day one samples 10 trips and for each of those 10 trips we measure 5 species we have 50 (10 trips x 5 species) repeated records of the variables associated with the sampling site table.

Wide-tables where one has repeated records of the same measure create a bit of a problem in statistical analysis, in particular when there are a lot of variables (columns) in such a wide-table. In order that any code generated is delivering what is intended the person using the wide-table has to have a full knowledge of the data-model in the first place. Which defies hence the logic of providing a wide table.

Of course on can access the wide tables provided by FM via {fmr} as shown below. Although wide tables are often used when using spreadsheet software, it is not recommended to use them for downstream analysis in R:

landing F

fm_landingF(key) |> glimpse()
#> Rows: 19,474
#> Columns: 37
#> $ id                    <int> 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 1…
#> $ survey_id             <int> 1478, 1484, 1484, 1484, 1489, 1492, 1492, 1492, …
#> $ survey_item_id        <int> 1517, 1523, 1523, 1523, 1529, 1532, 1532, 1532, …
#> $ survey_item_dtl_id    <int> 1691, 1703, 1706, 1707, 1718, 1724, 1725, 1727, …
#> $ survey_status_id      <int> 1807, 1807, 1807, 1807, 1807, 1807, 1807, 1807, …
#> $ survey_item_status_id <int> 1867, 1867, 1867, 1867, 1867, 1867, 1867, 1867, …
#> $ survey_item_type_id   <int> 1871, 1871, 1871, 1871, 1871, 1871, 1871, 1871, …
#> $ landing_date          <chr> "2023-01-05T10:00:00.000+00:00", "2023-01-09T10:…
#> $ landing_site_id       <int> 10081, 10081, 10081, 10081, 10081, 10080, 10080,…
#> $ vessel_id             <int> 2029, 2029, 2029, 2029, 1893, 1994, 1994, 1994, …
#> $ species_id            <int> 2254, 2174, 2291, 2407, 2458, 2303, 2126, 2237, …
#> $ weight                <dbl> 5, 12, 25, 40, 100, 12, 2, 5, 8, 3, 4, 150, 24, …
#> $ price                 <dbl> 12, 12, 12, 20, 10, 14, 12, 12, 12, 12, 12, 10, …
#> $ fuel_used             <dbl> NA, 500, 500, 500, 500, NA, NA, NA, NA, NA, NA, …
#> $ total                 <dbl> 60, 144, 300, 800, 1000, 168, 24, 60, 96, 36, 48…
#> $ gear_id               <int> 1081, 1081, 1081, 1081, 1080, 1081, 1081, 1081, …
#> $ fishing_zone_id       <int> 1085, 1085, 1085, 1085, 1085, 1085, 1085, 1085, …
#> $ condition_id          <int> 1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877, …
#> $ infraction_type_id    <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, …
#> $ infraction_desc       <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, …
#> $ measurement_type_id   <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, …
#> $ disposition_id        <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, …
#> $ is_by_catch           <int> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, …
#> $ is_targetted          <int> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, …
#> $ storage_id            <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, …
#> $ dep_status_id         <int> 1861, 1861, 1861, 1861, 1861, 1861, 1861, 1861, …
#> $ dep_location_id       <int> 10081, 10081, 10081, 10081, 10081, 10080, 10080,…
#> $ dep_time              <chr> "2023-01-05T04:00:00.000+00:00", "2023-01-09T04:…
#> $ arr_location_id       <int> 10081, 10081, 10081, 10081, 10081, 10080, 10080,…
#> $ arr_status_id         <int> 1856, 1856, 1856, 1856, 1856, 1856, 1856, 1856, …
#> $ arr_time              <chr> "2023-01-05T16:00:00.000+00:00", "2023-01-09T16:…
#> $ secondary_gear_id     <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, …
#> $ secondary_vessel_id   <int> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, …
#> $ tenant_id             <int> 103, 103, 103, 103, 103, 103, 103, 103, 103, 103…
#> $ is_active             <int> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, …
#> $ created_by            <chr> "TracyG", "TracyG", "TracyG", "TracyG", "TracyG"…
#> $ created_date          <chr> "2023-02-15T16:26:01.467+00:00", "2023-02-16T01:…

landingV

fm_landingV(key) |> glimpse()
#> Rows: 19,474
#> Columns: 27
#> $ id                    <int> 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 1…
#> $ survey_id             <int> 7992, 7992, 7992, 7992, 7992, 7992, 7992, 7992, …
#> $ landing_date          <dttm> 2024-07-26 08:00:00, 2024-07-26 08:00:00, 2024-…
#> $ landing_date_time_str <dttm> 2024-07-26 08:07:00, 2024-07-26 08:07:00, 2024-…
#> $ landing_site_id       <int> 10080, 10080, 10080, 10080, 10080, 10080, 10080,…
#> $ landing_site          <chr> "Basseterre East", "Basseterre East", "Basseterr…
#> $ vessel_id             <int> 2260, 2260, 1881, 2260, 2260, 2263, 1881, 2260, …
#> $ vessel                <chr> "Nicholas", "Nicholas", "Lion Fish", "Nicholas",…
#> $ vessel_regno          <chr> "629BE", "629BE", "V4-542-BE", "629BE", "629BE",…
#> $ vessel_class_id       <int> 1041, 1041, 1029, 1041, 1041, 1041, 1029, 1041, …
#> $ vessel_class          <chr> "Vessels supporting fishing related activities",…
#> $ fishing_zone_id       <int> 1052, 1052, 1084, 1052, 1052, 1063, 1084, 1052, …
#> $ fishing_zone          <chr> "B3", "B3", "E5", "B3", "B3", "C4", "E5", "B3", …
#> $ location_id           <int> 1052, 1052, 1084, 1052, 1052, 1063, 1084, 1052, …
#> $ gear_id               <int> NA, 1081, 1081, 1081, 1081, NA, NA, 1081, 1081, …
#> $ gear                  <chr> NA, "Spear Gun", "Spear Gun", "Spear Gun", "Spea…
#> $ species_id            <int> 2421, 2314, 2290, 2174, 2336, 2421, 2421, 2515, …
#> $ specie                <chr> "Caribbean spiny lobster", "Grouper Red Hind", "…
#> $ weight                <dbl> 30, 30, 4, 5, 10, 72, 60, 3, 2, 270, 150, 8, 2, …
#> $ price                 <dbl> 20, 12, 12, 12, 12, 20, 20, 12, 12, 10, 10, 12, …
#> $ fuel_used             <dbl> 200, 200, 350, 200, 200, 500, 350, 200, 200, 250…
#> $ total                 <dbl> 600, 360, 48, 60, 120, 1440, 1200, 36, 24, 2700,…
#> $ condition_id          <int> 1875, 1877, 1877, 1877, 1877, 1875, 1875, 1877, …
#> $ tenant_id             <int> 103, 103, 103, 103, 103, 103, 103, 103, 103, 103…
#> $ is_active             <int> 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, …
#> $ created_by            <chr> "AshodeF", "AshodeF", "AshodeF", "AshodeF", "Ash…
#> $ created_date_time_str <dttm> 2024-07-30 12:07:00, 2024-07-30 12:07:00, 2024-…

What is in common with all fisheries and fisheries science data-collection

Top-down thinking

H1 - survey

We go on a trip:

This could be a trip to a landing site
This could be a scientific survey (“a cruise”/“leiðangur”)
This could be a commercial fishing trip

We normally would record at minimum time and space at different degree of resolution
  time: quarter, month, date, time, start, end, ...
  space: fao area, eez, area, statistical rectangle, geograhical name, lon, lat, ...

If a landing survey, the start and end space would normally be the same.

If a scientific cruise or a fishing trip, the start/end space elements may differ. Therein, we may actually have a visit to port, with or without any landing event.

H2 - item

During a trip we take some itemized samples

If a landing “survey”, we sample boats (read: trips).
- The landing survey could be a subsample of trips or a full census (read: all trips).
  - If subsample of trips, we would still need info on the total effort (in a day-boat system, some estimated of the number of boats that go out. I.e. anything that allows us to raise the sample to a total estimate).
  - If full census we have the total effort (at least in terms of the number of trips).
  - Here the sampling space is the same (a landing site) but we may still get more detailed information on time and space. If so that recorded at the next node downstream (see below).
If a scientific survey we take samples at a station (space and time)
If a commerical fishing trip we take “samples” at a **station”* (space and time - think captain logbooks)

Whatever the case at level H2, we would at minimum record time and space

For a landing survey we would record the start and end time of the trip

For logbooks we would record time and space of the tow (whatever resolution)

For a scientific survey we would record time and space of any action on "a station"

H3 - item details

We may do different things at “a station”:

Measure of fish weight/number by species (or species group)
- If landings (sample or census): trip weights/numbers by species, possibly split to type (whole, gutted, fillets, breadcrumbs, …), preservation (none, iced, “krapi”, frozen, dried, …) and estimation type (visual, weighted, …)
- If commercial logbooks - by time and space of fishing
- If scientic curse - by time an sace of fishing
  - If a scientific cruise we may actually not record total number or total weight by species. But that number will/should always be derivable

H4 - measurements details

Think from the bottom up - the base is the station

Most likely a scientific survey is the most “complicated” thing when it comes to data structure/parameters collected Lets first start from thinking about resource survey, like the icelandic gillnet survey.

Station here is considered to be a physical entity associated with time, space and/or potentially other physical parameter.

We may have:

Station parameters that includes things like:
- t1 & t2: time start and end time at station
- lon1, lat1, lon2, lat2: coordinates, start and end
- z1 & z2: depth, start and end
- bt1 & bt2: bottom temperature, start and end (rarely both)
- st1 & st2: surface temperature, start and end (rarely both)
- additional oceanographic informations (wind, sky, ocean condition, ice, air-pressure, currents, secci depth, …)

At each station we may deploy different gear (not limited to fishing gear) - each of the gear is identified by a unique key (lets call it sample_id). A separate sample is created for each gear. In the case of e.g. of a gill-net survey where we have multiple mesh sizes, each synis_id constitutes a different mesh size. In the case of a gear selectivity survey, one synis_id may be for the sample collected in the cod-end of the main trawl, while the other synis_id is reserved for the fish that are collected in the retaining bag (i.e. fish that pass though the mesh of the main gear, but retained by the “backend” gear).