User Accounts

This dataset provides comprehensive user account information for web applications, including registration details, authentication credentials, profile attributes, preferences, activity timestamps, and subscription status. It supports robust user management, security auditing, personalized experiences, and subscription analytics for SaaS platforms.

  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

User authentication and access control

Sample rows

preview · 8 of 200 rows · all 25 columns
user_idintegeraccount_statusstringfailed_login_attemptsintegeris_email_verifiedbooleanaddress_countrystringusernamestringemailstringfirst_namestringlast_namestringdate_of_birthdateprofile_image_urlstringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringphone_numberstringregistration_datetimedatetimelast_login_datetimedatetimesubscription_typestringsubscription_start_datedatesubscription_end_datedateis_subscribedbooleanlast_password_change_datetimedatetimepassword_hashstringpreferences_jsonstring
51active0trueUKjamie_walker86jamie.walker86@outlook.co.ukJamieWalker1986-11-12https://img.example.com/u51.jpg14 Queen's RoadManchesterENGM13 9PL+44 161 555 01232023-06-24T14:22:33Z2024-04-22T09:04:18Zpremium2023-06-252024-06-24true2024-04-22T10:15:25Z2f8c5d2e9d3b1a7e5b8c4e2b7d7f9c1e3b5c7a9d2f5e8c5a1d4e6c7f5a2b1c8e{"theme":"dark","language":"en-GB","notifications":true}
52active1trueChinali_hongweihongwei.li88@163.comHongweiLi1988-03-19https://img.example.com/u52.jpg88 Xizang Middle RdShanghaiShanghai200001+86 21 8000 61382022-08-05T08:42:29Z2024-05-07T13:10:45Zfreeblankblankfalse2024-05-07T13:12:10Zb4c7e5d2a9f3e4b8c1d5a7e2b3f6c8d2e9a1c5b7d2f4e8c6a1b5d7e2c4f6a9b8{"theme":"light","language":"zh-CN","currency":"CNY"}
53active0trueUSemily_hughesemily.hughes@protonmail.comEmilyHughes1992-07-23https://img.example.com/u53.jpg45 Elm StreetBostonMA02118+1-617-555-78902024-01-15T12:10:17Z2024-05-04T18:29:11Zpremium2024-01-162025-01-15true2024-05-04T20:44:09Zc5e7b2f9a8d3c1e5b6a2d4f8e9c1b7d5e2a4c6b8f3d1e7c9a5b3d2e4f6a8c7b1{"theme":"dark","language":"en-US","newsletter":true}
54inactive2trueHungaryviktor_nagyviktor.nagy@citromail.huViktorNagy1978-02-12https://img.example.com/u54.jpg12 Szent István térBudapestBudapest1051+36 1 555 21342021-03-14T19:22:44Z2024-04-30T07:20:02Zfreeblankblankfalse2022-09-14T08:11:22Zd2e5c7a9b4f1c6e3a8b2d5f7e1c4a6b8d3f9e2c7a5b1d6e8c4f2a7b3e5c9d1a6{"language":"hu-HU","currency":"HUF","newsletter":false}
55active0trueUSalex_smith91alex.smith91@gmail.comAlexSmith1991-05-07https://img.example.com/u55.jpg90 Main StChicagoIL60611+1-312-555-12002023-12-02T16:01:13Z2024-05-08T13:32:16Zpremium2023-12-032024-12-02true2024-05-08T15:10:00Ze5c9a7f2b3d1e8c4a6b2f7e1c4a6b8d3f9e2c7a5b1d6e8c4f2a7b3e5c9d1a6{"theme":"light","language":"en-US","notifications":false}
56deletedblankfalseblanktestuser_deleteddeleted.user56@dummy.comblankblankblankblankblankblankblankblankblank2022-02-02T02:02:02Zblankblankblankblankfalseblankblankblank
57active0trueUSlinda_robertsroberts.linda@verizon.netLindaRoberts1982-09-15https://img.example.com/u57.png101 Oak AvePhiladelphiaPA19103+1-215-555-39992023-03-10T10:44:57Z2024-05-06T07:54:23Zenterprise2023-03-112024-03-10true2024-05-06T08:01:14Zb3d2e4f6a8c7b1c5e7b2f9a8d3c1e5b6a2d4f8e9c1b7d5e2a4c6b8f3d1e7c9a5{"theme":"dark","language":"en-US","font_size":"large"}
58active0trueRussiaanastasia_ivanovaanastasia.ivanova@mail.ruAnastasiaIvanova1998-12-01https://img.example.com/u58.jpg27 Nevsky ProspektSt PetersburgSaint-Petersburg191025+7 812 555 10242024-04-01T18:17:32Z2024-05-07T17:03:44Zfreeblankblankfalse2024-05-07T19:04:11Za1c4e6b7d2f5e8c5a1d4e6c7f5a2b1c8e2f8c5d2e9d3b1a7e5b8c4e2b7d7f9c1e{"language":"ru-RU","currency":"RUB","theme":"light"}

What the 200 rows show

from the 200-row sample

Active (account status) stands out: 153 of its 153 rows have is_email_verified = true, against 5 of 47 for the rest.

  • 79%is_email_verified = true
  • 0median failed_login_attempts
  • 3subscription types
Is email verified rate by account_statusis_email_verified = true
0%50%100%100%active153 of 15317%inactive5 of 290%deleted0 of 18

Active (account status)'s mean failed_login_attempts is 0.31, against 8.3 for inactive and 669.3 for deleted.

failed_login_attempts188 rows, in bands of 100
09519018400000000405001,000failed_login_attempts →

Median 0, from 0 to 999.

address_country193 rows with a value · 7 left blank
  1. US36
  2. UK28
  3. Spain13
  4. USA13
  5. Germany11
  6. Sweden11
  7. Testland11
  8. Russia8
  9. France8
  10. Italy8
25 columns by typefrom the column list below
  • string 15
  • integer 2
  • date 3
  • datetime 3
  • boolean 2

Columns

25 columns in four groups
blueprint · 25 columns
columntypedescriptionexample
Text 15 columns
usernamestringUser's chosen display name for authentication and profileunique · 3 to 32jamie_walker86
emailstringUser's email address for login and notificationsuniquehongwei.li88@163.com
password_hashstringHashed password for secure authentication2f8c5d2e9d3b1a7e5b8c4e2b7…
first_namestringUser's first nameup to 64 · optionalJamie
last_namestringUser's last nameup to 64 · optionalWalker
profile_image_urlstringURL to user's profile imageoptionalhttps://img.example.com/u…
address_streetstringUser's street addressoptional14 Queen's Road
address_citystringUser's cityoptionalManchester
address_statestringUser's state or provinceoptionalENG
address_postal_codestringUser's postal or ZIP codeoptionalM13 9PL
address_countrystringUser's country of residenceoptionalUK
phone_numberstringUser's contact phone numberoptional+44 161 555 0123
preferences_jsonstringUser's application preferences and settings in JSON formatoptional{"test_mode":true}
account_statusstringCurrent status of the user accountactive · inactive · suspended · deletedactive
subscription_typestringType of subscription the user hasfree · premium · enterprise · optionalpremium
Numbers 2 columns
user_idintegerUnique identifier for each user accountunique · 1 or more51
failed_login_attemptsintegerNumber of consecutive failed login attempts0 or more · optional0
Dates and times 6 columns
date_of_birthdateUser's date of birthoptional1986-11-12
registration_datetimedatetimeTimestamp when the user registered2023-06-24T14:22:33Z
last_login_datetimedatetimeTimestamp of user's last loginoptional2024-04-22T09:04:18Z
subscription_start_datedateDate when the user's subscription startedoptional2023-06-25
subscription_end_datedateDate when the user's subscription ends or endedoptional2024-06-24
last_password_change_datetimedatetimeTimestamp of the user's last password changeoptional2024-04-22T10:15:25Z
True or false 2 columns
is_email_verifiedbooleanIndicates if the user's email has been verifiedtrue
is_subscribedbooleanIndicates if the user currently has an active subscriptiontrue

Use it for

  • is email verif…79%158 of 200 rowsmean failed login att…0.31active8.3inacti…669.3deleted

    A technology dashboard

    The is_email_verified rate, failed_login_attempts by account_status and a breakdown of address_country. Excel, Power BI or Tableau.

  • Why do 158 of 200 rows have is_email_verified = true?

    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 rows with username, email and password_hash to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 25 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 rows25 columns
Yours1,000 rows25 columnsaddress_street: UK only

blueprint · user-accounts

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 25 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
  • Unique username and email per user
  • Registration date before last login date
  • Password last changed within last 90 days
  • Account status affects login permissions
  • Email verified status determines feature access
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
user-accounts

More in Technology

Browse all
Also in TechnologySoftware Feature Usage FrequenciesConsumer Mobile App Usage StatsProject TasksAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.