About this Dataset

PC And Laptop Logins

This dataset shows all PC and laptop logins for Leeds City Council staff at all its main locations broken down hourly. For Information --------------- * AP indicates Access Point, which is usually a wireless connection * Wireless client indicates the way the IP address connects. Please note ----------- * The number of logins are for the hour in the heading until the next hour. * The dataset includes all logins on the site within the given hour, including temporary logins * Moving between subnets (different connections in the same building) will not result in different logins, however moving networks (different buildings), will * Multiple logins for the same account may occur when: * a device swaps between networks (e.g. for meetings) falling in separate hours * Logging in again after a period of time off the network Automated update ---------------- * This dataset is automatically updated on a nightly basis.
Publisher name: Leeds City Council
Last updated: 2024-09-14T10:05:30Z

Tables

01/01/2016 - 31/12/2016

@ukgov.pc_and_laptop_logins.n_01_01_2016_31_12_2016

676.33 kB
70,766 rows
26 columns

CREATE TABLE n_01_01_2016_31_12_2016 (
  "site" VARCHAR,
  "date" VARCHAR,
  "n_00_00" BIGINT  -- 00:00,
  "n_01_00" BIGINT  -- 01:00,
  "n_02_00" BIGINT  -- 02:00,
  "n_03_00" BIGINT  -- 03:00,
  "n_04_00" BIGINT  -- 04:00,
  "n_05_00" BIGINT  -- 05:00,
  "n_06_00" BIGINT  -- 06:00,
  "n_07_00" BIGINT  -- 07:00,
  "n_08_00" BIGINT  -- 08:00,
  "n_09_00" BIGINT  -- 09:00,
  "n_10_00" BIGINT  -- 10:00,
  "n_11_00" BIGINT  -- 11:00,
  "n_12_00" BIGINT  -- 12:00,
  "n_13_00" BIGINT  -- 13:00,
  "n_14_00" BIGINT  -- 14:00,
  "n_15_00" BIGINT  -- 15:00,
  "n_16_00" BIGINT  -- 16:00,
  "n_17_00" BIGINT  -- 17:00,
  "n_18_00" BIGINT  -- 18:00,
  "n_19_00" BIGINT  -- 19:00,
  "n_20_00" BIGINT  -- 20:00,
  "n_21_00" BIGINT  -- 21:00,
  "n_22_00" BIGINT  -- 22:00,
  "n_23_00" BIGINT  -- 23:00
);