Public Wi-Fi Usage Logs

This dataset contains detailed logs of public Wi-Fi usage sessions, including session times, device types, data transferred, and user engagement metrics at specific hotspot locations. It enables analysis of usage patterns, repeat visitors, and demographic trends, supporting infrastructure planning, hotspot optimization, and targeted marketing strategies.

  • opened 5 times
  • last updated 21 Aug 2025
  • by GoMask
The brief that made it

Optimizing public Wi-Fi infrastructure based on usage patterns

Sample rows

preview · 8 of 200 rows · all 18 columns
session_idstringdevice_typestringdata_transferred_mbfloatis_repeat_userbooleanhotspot_address_statestringhotspot_idstringhotspot_location_namestringhotspot_address_streetstringhotspot_address_citystringhotspot_address_postal_codestringhotspot_address_countrystringdevice_idstringsession_start_timedatetimesession_end_timedatetimesession_duration_minutesfloataccess_frequency_7dintegeruser_age_groupstringuser_genderstring
A7X9B2LQsmartphone185.4trueNYHS001Central Park Entrance5th Ave & 59th StNew York10022USAdev_8f1a3c272024-05-09T11:24:172024-05-09T11:54:1229.92525_34female
C3Q7M8TJlaptop1962.7trueNYHS002Union Square PlazaBroadway & E 14th StNew York10003USAdev_2d8e9f122024-05-10T13:04:522024-05-10T16:12:18187.43435_44male
Y0Z5W4KPtablet280.3falseCAHS003Metropolitan Library Entrance100 E 5th StLos Angeles90013USAdev_7a4b5d912024-05-09T15:36:412024-05-09T16:22:1845.62245_54female
K2V8G5HUdesktop15847falseILHS004Chicago RiverwalkWacker Dr & N State StChicago60601USAdev_1c9e7b542024-05-08T08:14:372024-05-08T13:36:07321.5165_plusmale
F4L7T9SAlaptop122.8falseILHS005Union Station Main Hall225 S Canal StChicago60606USAdev_77b3c0a12024-05-08T17:45:012024-05-08T18:13:1028.15225_34male
R3E1B6OVsmartphone0.7falseCAHS006Golden Gate Park Cafe501 Stanyan StSan Francisco94117USAdev_5e0d4c922024-05-07T19:12:332024-05-07T19:13:050.531unknownunknown
Q9T2H8PXtablet38.2trueMAHS007Gymnasium West Lobby200 Main StBoston02115USAdev_6d3f9b142024-05-10T17:14:582024-05-10T17:22:477.826under_18female
J1S3U6MCother0falseLondonHS008London Bridge TransitSt Thomas StLondonSE1 9SPUKdev_e4b1c2342024-05-09T09:19:422024-05-09T09:19:570.250unknownother

What the 200 rows show

from the 200-row sample

Desktop (device type) stands out: mean data_transferred_mb is 13,147, against 204.1 for the rest.

  • 49%is_repeat_user = true
  • 75.7median data_transferred_mb
  • 4user genders
  • 8user age groups
  • 10hotspot address countries
  • 41hotspot address cities
Mean data_transferred_mb by device_type200 rows
010k20k45.3smartp…44 rows55.5tablet49 rows615.9laptop48 rows13,147desktop32 rows0.16other27 rows
data_transferred_mb200 rows, in bands of 2,000
0851701680004710533010k20kdata_transferred_mb →

Median 75.7, from 0.0 to 19,845.

hotspot_address_state200 rows · top 10 of 31 values
  1. CA38
  2. NY16
  3. London16
  4. SG14
  5. ON13
  6. NSW13
  7. IL12
  8. MA11
  9. NH9
  10. TX7
18 columns by typefrom the column list below
  • string 12
  • integer 1
  • float 2
  • datetime 2
  • boolean 1

Columns

18 columns in four groups
blueprint · 18 columns
columntypedescriptionexample
Text 12 columns
session_idstringUnique identifier for each Wi-Fi usage sessionuniqueA7X9B2LQ
hotspot_idstringUnique identifier for the public Wi-Fi hotspotHS001
hotspot_location_namestringName or description of the hotspot location (e.g., 'Central Park', 'Library Entrance')Central Park Entrance
hotspot_address_streetstringStreet address of the Wi-Fi hotspotoptional5th Ave & 59th St
hotspot_address_citystringCity where the Wi-Fi hotspot is locatedoptionalNew York
hotspot_address_statestringState or region of the Wi-Fi hotspotoptionalNY
hotspot_address_postal_codestringPostal code of the Wi-Fi hotspot locationoptional10022
hotspot_address_countrystringCountry of the Wi-Fi hotspot10 countries · optionalUSA
device_idstringAnonymized unique identifier for the user's device (e.g., hashed MAC address)dev_8f1a3c27
device_typestringType of device used to access Wi-Fi (e.g., smartphone, tablet, laptop)smartphone · tablet · laptop · desktop · othersmartphone
user_age_groupstringEstimated age group of the user (if available, e.g., from registration or survey)8 values · optional25_34
user_genderstringEstimated gender of the user (if available, e.g., from registration or survey)unknown · male · female · other · optionalfemale
Numbers 3 columns
session_duration_minutesfloatDuration of the Wi-Fi session in minutes0.1 or more29.92
data_transferred_mbfloatAmount of data transferred during the session in megabytes0 or more · optional185.4
access_frequency_7dintegerNumber of times this device accessed this hotspot in the past 7 days0 or more · optional5
Dates and times 2 columns
session_start_timedatetimeTimestamp when the Wi-Fi session started2024-05-09T11:24:17
session_end_timedatetimeTimestamp when the Wi-Fi session ended2024-05-09T11:54:12
True or false 1 column
is_repeat_userbooleanIndicates if the device has connected to this hotspot beforeoptionaltrue

Use it for

  • is repeat user49%98 of 200 rowsmean data transferred…45.3smar…55.5tabl…615.9lapt…13.1kdesk…

    A technology dashboard

    The is_repeat_user rate, data_transferred_mb by device_type and a breakdown of hotspot_address_state. Excel, Power BI or Tableau.

  • Why do the 32 desktop rows have a mean data_transferred_mb of 13,147?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable sessions with hotspot_id, hotspot_location_name and hotspot_address_street to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 18 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows18 columns
Yours1,000 rows18 columnshotspot_location_name: UK only

blueprint · public-wi-fi-usage-logs

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 18 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Hotspot ID and location logged
  • Session start/end timestamps tracked
  • Device type and OS version included
  • Session outcome status present
  • User anonymized ID provided
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
public-wi-fi-usage-logs

More in Technology

Browse all
Also in TechnologySubscription Service Trial ConversionsProject TasksB2B SaaS Usage RetentionAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.