NI Direct Browser Information 2016 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_browser_information_2016_q3_q4

644.62 kB
99,093 rows
8 columns

CREATE TABLE ni_direct_browser_information_2016_q3_q4 (
  "date" BIGINT,
  "browser" VARCHAR,
  "browser_version" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Browser Information 2017 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_browser_information_2017_q1_q2

647.43 kB
98,775 rows
8 columns

CREATE TABLE ni_direct_browser_information_2017_q1_q2 (
  "date" BIGINT,
  "browser" VARCHAR,
  "browser_version" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Browser Information 2017 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_browser_information_2017_q3_q4

612.72 kB
100,552 rows
8 columns

CREATE TABLE ni_direct_browser_information_2017_q3_q4 (
  "date" BIGINT,
  "browser" VARCHAR,
  "browser_version" VARCHAR,
  "sessions" DOUBLE,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" DOUBLE,
  "new_users" DOUBLE
);

NI Direct Browser Information 2018 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_browser_information_2018_q1_q2

673.72 kB
100,120 rows
8 columns

CREATE TABLE ni_direct_browser_information_2018_q1_q2 (
  "date" BIGINT,
  "browser" VARCHAR,
  "browser_version" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Browser Information 2018 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_browser_information_2018_q3_q4

703.71 kB
102,750 rows
8 columns

CREATE TABLE ni_direct_browser_information_2018_q3_q4 (
  "date" BIGINT,
  "browser" VARCHAR,
  "browser_version" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Browser Information 2019 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_browser_information_2019_q1_q2

715.48 kB
103,992 rows
8 columns

CREATE TABLE ni_direct_browser_information_2019_q1_q2 (
  "date" BIGINT,
  "browser" VARCHAR,
  "browser_version" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Browser Information 2019 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_browser_information_2019_q3_q4

702.49 kB
102,201 rows
8 columns

CREATE TABLE ni_direct_browser_information_2019_q3_q4 (
  "date" BIGINT,
  "browser" VARCHAR,
  "browser_version" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Browser Information 2020 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_browser_information_2020_q1_q2

758.68 kB
107,170 rows
8 columns

CREATE TABLE ni_direct_browser_information_2020_q1_q2 (
  "date" BIGINT,
  "browser" VARCHAR,
  "browser_version" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Browser Information 2020 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_browser_information_2020_q3_q4

851.59 kB
119,906 rows
8 columns

CREATE TABLE ni_direct_browser_information_2020_q3_q4 (
  "date" BIGINT,
  "browser" VARCHAR,
  "browser_version" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Browser Information 2021 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_browser_information_2021_q1_q2

931.83 kB
129,464 rows
8 columns

CREATE TABLE ni_direct_browser_information_2021_q1_q2 (
  "date" BIGINT,
  "browser" VARCHAR,
  "browser_version" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Browser Information 2021 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_browser_information_2021_q3_q4

805.35 kB
106,950 rows
8 columns

CREATE TABLE ni_direct_browser_information_2021_q3_q4 (
  "date" DOUBLE,
  "browser" VARCHAR,
  "browser_version" VARCHAR,
  "sessions" VARCHAR,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" VARCHAR,
  "new_users" VARCHAR
);

NI Direct Browser Information 2022 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_browser_information_2022_q1_q2

731.58 kB
102,281 rows
8 columns

CREATE TABLE ni_direct_browser_information_2022_q1_q2 (
  "date" BIGINT,
  "browser" VARCHAR,
  "browser_version" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Pageviews 2016 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_pageviews_2016_q3_q4

4.21 MB
608,475 rows
6 columns

CREATE TABLE ni_direct_pageviews_2016_q3_q4 (
  "date" BIGINT,
  "page_title" VARCHAR,
  "unique_pageviews" BIGINT,
  "pageviews" BIGINT,
  "avg_time_on_page" VARCHAR  -- Avg. Time On Page,
  "bounces" BIGINT
);

NI Direct Pageviews 2017 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_pageviews_2017_q1_q2

4.32 MB
636,548 rows
6 columns

CREATE TABLE ni_direct_pageviews_2017_q1_q2 (
  "date" BIGINT,
  "page_title" VARCHAR,
  "unique_pageviews" BIGINT,
  "pageviews" BIGINT,
  "avg_time_on_page" VARCHAR  -- Avg. Time On Page,
  "bounces" BIGINT
);

NI Direct Pageviews 2017 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_pageviews_2017_q3_q4

3.83 MB
659,917 rows
8 columns

CREATE TABLE ni_direct_pageviews_2017_q3_q4 (
  "date" BIGINT,
  "page_title" VARCHAR,
  "unique_pageviews" DOUBLE,
  "pageviews" DOUBLE,
  "avg_time_on_page" VARCHAR  -- Avg. Time On Page,
  "bounces" DOUBLE,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7
);

NI Direct Pageviews 2018 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_pageviews_2018_q1_q2

4.78 MB
703,459 rows
6 columns

CREATE TABLE ni_direct_pageviews_2018_q1_q2 (
  "date" BIGINT,
  "page_title" VARCHAR,
  "unique_pageviews" BIGINT,
  "pageviews" BIGINT,
  "avg_time_on_page" VARCHAR  -- Avg. Time On Page,
  "bounces" BIGINT
);

NI Direct Pageviews 2018 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_pageviews_2018_q3_q4

5.03 MB
743,992 rows
6 columns

CREATE TABLE ni_direct_pageviews_2018_q3_q4 (
  "date" BIGINT,
  "page_title" VARCHAR,
  "unique_pageviews" BIGINT,
  "pageviews" BIGINT,
  "avg_time_on_page" VARCHAR  -- Avg. Time On Page,
  "bounces" BIGINT
);

NI Direct Pageviews 2019 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_pageviews_2019_q1_q2

5.37 MB
787,570 rows
6 columns

CREATE TABLE ni_direct_pageviews_2019_q1_q2 (
  "date" BIGINT,
  "page_title" VARCHAR,
  "unique_pageviews" DOUBLE,
  "pageviews" DOUBLE,
  "avg_time_on_page" VARCHAR  -- Avg. Time On Page,
  "bounces" DOUBLE
);

NI Direct Pageviews 2019 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_pageviews_2019_q3_q4

5.32 MB
786,594 rows
6 columns

CREATE TABLE ni_direct_pageviews_2019_q3_q4 (
  "date" BIGINT,
  "page_title" VARCHAR,
  "unique_pageviews" DOUBLE,
  "pageviews" DOUBLE,
  "avg_time_on_page" VARCHAR  -- Avg. Time On Page,
  "bounces" DOUBLE
);

NI Direct Pageviews 2020 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_pageviews_2020_q1_q2

5.41 MB
794,441 rows
6 columns

CREATE TABLE ni_direct_pageviews_2020_q1_q2 (
  "date" BIGINT,
  "page_title" VARCHAR,
  "unique_pageviews" BIGINT,
  "pageviews" BIGINT,
  "avg_time_on_page" VARCHAR  -- Avg. Time On Page,
  "bounces" BIGINT
);

NI Direct Pageviews 2020 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_pageviews_2020_q3_q4

5.7 MB
820,684 rows
6 columns

CREATE TABLE ni_direct_pageviews_2020_q3_q4 (
  "date" BIGINT,
  "page_title" VARCHAR,
  "unique_pageviews" BIGINT,
  "pageviews" BIGINT,
  "avg_time_on_page" VARCHAR  -- Avg. Time On Page,
  "bounces" BIGINT
);

NI Direct Pageviews 2021 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_pageviews_2021_q1_q2

6.01 MB
856,110 rows
6 columns

CREATE TABLE ni_direct_pageviews_2021_q1_q2 (
  "date" BIGINT,
  "page_title" VARCHAR,
  "unique_pageviews" BIGINT,
  "pageviews" BIGINT,
  "avg_time_on_page" VARCHAR  -- Avg. Time On Page,
  "bounces" BIGINT
);

NI Direct Pageviews 2021 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_pageviews_2021_q3_q4

5.35 MB
800,134 rows
6 columns

CREATE TABLE ni_direct_pageviews_2021_q3_q4 (
  "date" BIGINT,
  "page_title" VARCHAR,
  "unique_pageviews" BIGINT,
  "pageviews" BIGINT,
  "avg_time_on_page" VARCHAR  -- Avg. Time On Page,
  "bounces" BIGINT
);

NI Direct Pageviews 2022 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_pageviews_2022_q1_q2

5.09 MB
801,718 rows
6 columns

CREATE TABLE ni_direct_pageviews_2022_q1_q2 (
  "date" BIGINT,
  "page_title" VARCHAR,
  "unique_pageviews" BIGINT,
  "pageviews" BIGINT,
  "avg_time_on_page" VARCHAR  -- Avg. Time On Page,
  "bounces" BIGINT
);

NI Direct Search Terms 2016 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_search_terms_2016_q3_q4

87.96 kB
239,217 rows
8 columns

CREATE TABLE ni_direct_search_terms_2016_q3_q4 (
  "month_of_year" DOUBLE,
  "search_term" VARCHAR,
  "total_unique_searches" DOUBLE,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "average_search_depth" DOUBLE
);

NI Direct Search Terms 2017 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_search_terms_2017_q1_q2

88.23 kB
6,231 rows
8 columns

CREATE TABLE ni_direct_search_terms_2017_q1_q2 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2017 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_search_terms_2017_q3_q4

80.23 kB
5,530 rows
8 columns

CREATE TABLE ni_direct_search_terms_2017_q3_q4 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2018 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_search_terms_2018_q1_q2

92.61 kB
6,694 rows
8 columns

CREATE TABLE ni_direct_search_terms_2018_q1_q2 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2018 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_search_terms_2018_q3_q4

79.13 kB
6,689 rows
8 columns

CREATE TABLE ni_direct_search_terms_2018_q3_q4 (
  "month_of_year" DOUBLE,
  "search_term" VARCHAR,
  "total_unique_searches" DOUBLE,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2019 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_search_terms_2019_q1_q2

87.42 kB
6,364 rows
8 columns

CREATE TABLE ni_direct_search_terms_2019_q1_q2 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2019 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_search_terms_2019_q3_q4

79.64 kB
5,722 rows
8 columns

CREATE TABLE ni_direct_search_terms_2019_q3_q4 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2020 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_search_terms_2020_q1_q2

105.23 kB
7,540 rows
8 columns

CREATE TABLE ni_direct_search_terms_2020_q1_q2 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2020 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_search_terms_2020_q3_q4

132.42 kB
10,112 rows
8 columns

CREATE TABLE ni_direct_search_terms_2020_q3_q4 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2021 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_search_terms_2021_q1_q2

144.44 kB
11,042 rows
8 columns

CREATE TABLE ni_direct_search_terms_2021_q1_q2 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2021 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_search_terms_2021_q3_q4

194.16 kB
14,157 rows
8 columns

CREATE TABLE ni_direct_search_terms_2021_q3_q4 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Search Terms 2022 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_search_terms_2022_q1_q2

121.6 kB
9,243 rows
8 columns

CREATE TABLE ni_direct_search_terms_2022_q1_q2 (
  "month_of_year" BIGINT,
  "search_term" VARCHAR,
  "total_unique_searches" BIGINT,
  "results_pageviews_search" DOUBLE  -- Results Pageviews / Search,
  "n__search_exits" VARCHAR  -- % Search Exits,
  "n__search_refinements" VARCHAR  -- % Search Refinements,
  "time_after_search" VARCHAR,
  "avg_search_depth" DOUBLE  -- Avg. Search Depth
);

NI Direct Sources 2016 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_sources_2016_q3_q4

577.07 kB
87,249 rows
7 columns

CREATE TABLE ni_direct_sources_2016_q3_q4 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2017 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_sources_2017_q1_q2

581.61 kB
88,069 rows
7 columns

CREATE TABLE ni_direct_sources_2017_q1_q2 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2017 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_sources_2017_q3_q4

567.19 kB
84,215 rows
7 columns

CREATE TABLE ni_direct_sources_2017_q3_q4 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2018 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_sources_2018_q1_q2

598.97 kB
89,147 rows
7 columns

CREATE TABLE ni_direct_sources_2018_q1_q2 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2018 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_sources_2018_q3_q4

567.64 kB
93,832 rows
7 columns

CREATE TABLE ni_direct_sources_2018_q3_q4 (
  "date" DOUBLE,
  "source" VARCHAR,
  "sessions" DOUBLE,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" DOUBLE,
  "new_users" DOUBLE
);

NI Direct Sources 2019 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_sources_2019_q1_q2

1.03 MB
133,067 rows
7 columns

CREATE TABLE ni_direct_sources_2019_q1_q2 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2019 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_sources_2019_q3_q4

556.77 kB
81,314 rows
7 columns

CREATE TABLE ni_direct_sources_2019_q3_q4 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2020 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_sources_2020_q1_q2

626.69 kB
90,811 rows
7 columns

CREATE TABLE ni_direct_sources_2020_q1_q2 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2020 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_sources_2020_q3_q4

871.28 kB
121,466 rows
7 columns

CREATE TABLE ni_direct_sources_2020_q3_q4 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2021 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_sources_2021_q1_q2

1.06 MB
142,304 rows
7 columns

CREATE TABLE ni_direct_sources_2021_q1_q2 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2021 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_sources_2021_q3_q4

581.92 kB
93,019 rows
7 columns

CREATE TABLE ni_direct_sources_2021_q3_q4 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct Sources 2022 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_sources_2022_q1_q2

463.6 kB
72,332 rows
7 columns

CREATE TABLE ni_direct_sources_2022_q1_q2 (
  "date" BIGINT,
  "source" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct User Device Categories 2016 Q3 & Q4

@ukgov.ni_direct_website_data.ni_direct_user_device_categories_2016_q3_q4

19.35 kB
552 rows
7 columns

CREATE TABLE ni_direct_user_device_categories_2016_q3_q4 (
  "date" BIGINT,
  "device_category" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

NI Direct User Device Categories 2017 Q1 & Q2

@ukgov.ni_direct_website_data.ni_direct_user_device_categories_2017_q1_q2

19.11 kB
543 rows
7 columns

CREATE TABLE ni_direct_user_device_categories_2017_q1_q2 (
  "date" BIGINT,
  "device_category" VARCHAR,
  "sessions" BIGINT,
  "avg_session_duration" VARCHAR  -- Avg. Session Duration,
  "bounce_rate" VARCHAR,
  "users" BIGINT,
  "new_users" BIGINT
);

Tables