Overview
- Total Records: 200,000 users
- File Format: CSV without headers
- Primary Key: ID
- Purpose: Master user directory for the social network
Schema Definition
Unique sequential identifier for each user.
- Range: 1 to 200,000
- Constraint: Must be unique
- Usage: Referenced by Follows (ID1, ID2) and ActivityLog (ByWho, WhatPage)
User’s display name on the platform.
- Length: 10-20 characters
- Format: Realistic nickname (no commas)
- Examples: “CoolSurfer99”, “TechGuru2023”, “NatureLover”
User’s professional occupation.
- Length: 10-20 characters
- Format: Realistic job title (no commas)
- Examples: “Software Engineer”, “Marketing Manager”, “Data Scientist”
Geographic region identifier for the user.
- Range: 1 to 50
- Purpose: Enables regional analysis and location-based queries
- Note: Used for finding users in the same geographic area
User’s primary hobby or interest.
- Length: 5-30 characters
- Format: Realistic hobby description (no commas)
- Examples: “Photography”, “Mountain Climbing”, “Playing Guitar”, “Reading Sci-Fi”
Example Records
The file does not include column headers. The order of values corresponds to: ID, NickName, JobTitle, RegionCode, FavoriteHobby.
Data Characteristics
Uniqueness
- Each ID is unique across all 200,000 records
- NickNames should be unique but this is not strictly enforced
String Constraints
Realistic Data
The dataset generator should create:- NickNames: Creative but plausible usernames
- JobTitles: Common professional roles
- FavoriteHobbies: Real-world activities and interests
Relationships
CircleNetPage is the central dataset referenced by:- Follows Dataset: Both ID1 and ID2 must exist in CircleNetPage
- ActivityLog Dataset: Both ByWho and WhatPage must be valid CircleNetPage IDs
This dataset serves as the master reference for all user-related operations. Always validate that IDs exist in CircleNetPage before creating relationships or activity records.
Analytics Use Cases
This dataset enables:- Hobby-based user segmentation and matching
- Regional network analysis
- Professional network identification
- User demographic profiling
- Interest-based recommendations
Next Steps
Follows Dataset
Learn about relationship tracking
Generate Datasets
Create the CircleNetPage dataset