• Other
  • 26 columns
  • 200 rows
  • 8 formats

Membership Records

This dataset provides comprehensive records of club or organization members, including personal profiles, membership tiers, renewal and payment history, and detailed engagement activity tracking. It enables organizations to manage memberships, monitor payment compliance, and analyze member engagement for retention and growth strategies.

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

Automated membership renewal and payment tracking

Sample rows

preview · 8 of 200 rows · all 26 columns
member_idstringmembership_tierstringtotal_amount_paidfloatlast_payment_methodstringfirst_namestringlast_namestringemailstringphone_numberstringdate_of_birthdateaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringaddress_countrystringmembership_start_datedatemembership_renewal_datedatemembership_statusstringlast_payment_datedatelast_payment_amountfloattotal_paymentsintegerengagement_scorefloatlast_engagement_datedatejoin_sourcestringcreated_atdatetimeupdated_atdatetimeengagement_notesstring
M0001Basic15Credit CardLéaNguyenlea.nguyen@usclub.org+1-212-555-01812008-04-22127 Maple Grove RdBrooklynNY11201USA2023-06-052024-06-05Active2023-06-051519.22023-11-22Event2023-06-05T10:42:122023-11-22T14:29:41Attended summer camp event.
M0002Gold180blankMateoGarcíamateo.garcia@esclub.es+34-91-555-88761991-12-0324 Calle MayorMadridMadrid28013Spain2021-09-142022-09-14Lapsedblankblank218.7blankWebsite2021-09-14T09:15:212022-09-15T10:30:49No recent event participation.
M0003Platinum2300Bank TransferSvenJohanssonsven.johansson@seclub.se+46-8-555-70181962-07-1818 VasagatanStockholmStockholm11120Sweden2020-05-022023-05-02Active2022-05-02289.5887.42023-04-22Referral2020-05-02T12:01:092023-04-22T16:18:44Volunteered at fundraising gala.
M0004Silver130Credit CardAmélieDuboisamelie.dubois@frclub.fr+33-1-555-96962005-10-1092 Rue LafayetteParisÎle-de-France75010France2022-04-182023-04-18Active2022-04-1865223.22022-09-15Social Media2022-04-18T08:24:352022-09-15T17:22:11Participated in youth outreach.
M0005Gold360PayPalLucasSmithlucas.smith@ukclub.co.uk+44-20-555-33991985-02-2511 Queen's RoadLondonGreater LondonW1B 4DEUK2022-01-232023-01-23Active2022-01-23120382.92022-08-30Website2022-01-23T11:18:222022-08-30T18:05:53Regularly attends networking events.
M0006Platinum1200Credit CardFatimaAlifatima.ali@aeclub.ae+971-4-555-10231976-03-1413 Sheikh Zayed RdDubaiDubai00000UAE2022-09-012024-09-01Active2023-09-01300497.22023-10-10Referral2022-09-01T09:25:122023-10-10T13:19:54Donated to annual fundraiser.
M0007Silver76Credit CardEmilyO'Connoremily.oconnor@ausclub.au+61-2-555-77711988-11-0753 William StSydneyNSW2000Australia2023-02-142024-02-14Active2023-02-1476141.32023-05-05Event2023-02-14T10:08:312023-05-05T16:12:47Helped organize club social.
M0008Gold238Bank TransferJasperLeejasper.lee@sgclub.sg+65-555-88811993-08-1644 Orchard RdSingaporeCentral238863Singapore2023-03-012024-03-01Active2023-03-01119276.52023-09-18Website2023-03-01T08:07:542023-09-18T14:18:36Led volunteer project.

What the 200 rows show

from the 200-row sample

Platinum (membership tier) stands out: mean total_amount_paid is 2,219, against 178.1 for the rest.

  • 170.5median total_amount_paid
  • 3membership statuses
  • 5join sources
  • 44address countries
  • 87.5median last_payment_amount
  • 2median total_payments
Mean total_amount_paid by membership_tier200 rows
02,0004,00013.6Basic41 rows135.3Silver59 rows318.6Gold66 rows2,219Platinum34 rows
total_amount_paid200 rows, in bands of 500
085170161539121001,5003,000total_amount_paid →

Median 170.5, from 9.0 to 3,000.

last_payment_method194 rows with a value · 6 left blank
  1. Credit Card92
  2. Bank Transfer40
  3. Cash36
  4. PayPal26
26 columns by typefrom the column list below
  • string 15
  • integer 1
  • float 3
  • date 5
  • datetime 2

Columns

26 columns in three groups
blueprint · 26 columns
columntypedescriptionexample
Text 15 columns
member_idstringUnique identifier for each club or organization memberuniqueM0001
first_namestringMember's first nameLéa
last_namestringMember's last nameNguyen
emailstringMember's email addressuniquelea.nguyen@usclub.org
phone_numberstringMember's phone numberoptional+1-212-555-0181
address_streetstringMember's street addressoptional127 Maple Grove Rd
address_citystringMember's cityoptionalBrooklyn
address_statestringMember's state or provinceoptionalNY
address_postal_codestringMember's postal or ZIP codeoptional11201
address_countrystringMember's countryoptionalUSA
membership_tierstringTier of membership (e.g., Basic, Silver, Gold, Platinum)Basic · Silver · Gold · PlatinumBasic
membership_statusstringCurrent status of the membership (e.g., Active, Lapsed, Cancelled, Pending)Active · Lapsed · Cancelled · PendingActive
last_payment_methodstringPayment method used for the most recent payment (e.g., Credit Card, PayPal, Bank Transfer, Cash)Credit Card · PayPal · Bank Transfer · Cash · optionalCredit Card
engagement_notesstringFree-text notes about the member's engagement or activitiesoptionalLed volunteer project.
join_sourcestringSource or channel through which the member joined (e.g., Referral, Website, Event, Social Media)Referral · Website · Event · Social Media · Other · optionalEvent
Numbers 4 columns
last_payment_amountfloatAmount of the most recent membership payment0 or more · optional15
total_paymentsintegerTotal number of payments made by the member0 or more · optional1
total_amount_paidfloatTotal amount paid by the member over their membership0 or more · optional15
engagement_scorefloatNumerical score representing the member's engagement based on activity (e.g., event attendance, volunteer hours)0 or more · optional9.2
Dates and times 7 columns
date_of_birthdateMember's date of birthoptional2008-04-22
membership_start_datedateDate when the member's current membership started2023-06-05
membership_renewal_datedateDate when the membership is due for renewal2024-06-05
last_payment_datedateDate of the most recent membership paymentoptional2023-06-05
last_engagement_datedateDate of the member's most recent engagement activityoptional2023-11-22
created_atdatetimeTimestamp when the member record was created2023-06-05T10:42:12
updated_atdatetimeTimestamp when the member record was last updated2023-11-22T14:29:41

Use it for

  • median total a…170.5200 rowsmean total amount pai…13.6Basic135.3Silv…318.6Gold2.2kPlat…

    A dashboard

    Total_amount_paid by membership_tier and a breakdown of last_payment_method. Excel, Power BI or Tableau.

  • Why do the 34 Platinum rows have a mean total_amount_paid of 2,219?

    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 members with first_name, last_name and email to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

blueprint · membership-records

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 26 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
  • Membership number unique per member
  • Join date before current membership expiry
  • Tier level determines benefits and pricing
  • Auto-renewal flag for payment processing
  • Activity score tracks engagement level
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
membership-records

More in Other

Browse all
Also in OtherVolunteer Task Completion TrackerSmall Retailer Sales TransactionsNonprofit Program Impact DashboardAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.