Name Information from NameDemo Database

Dataset info

Number of variables	63
Number of observations	5455
Missing cells	153013 (44.5%)
Duplicate rows	0 (0.0%)
Total size in memory	2.5 MiB
Average record size in memory	476.0 B

Variables types

Numeric	3
Categorical	41
Boolean	3
Date	6
URL	0
Text (Unique)	0
Rejected	10
Unsupported	0

Warnings

`BAR_CODE` has a high cardinality: 93 distinct values	Warning
`BAR_CODE` has 5276 (96.7%) missing values	Missing
`BIRTH_DATE` has 1061 (19.5%) missing values	Missing
`BT_ID` has 5445 (99.8%) missing values	Missing
`CATEGORY` has 718 (13.2%) missing values	Missing
`CHAPTER` has 3065 (56.2%) missing values	Missing
`CITY` has a high cardinality: 1708 distinct values	Warning
`CITY` has 204 (3.7%) missing values	Missing
`CO_ID` has 3471 (63.6%) missing values	Missing
`CO_MEMBER_TYPE` has 3471 (63.6%) missing values	Missing
`COMPANY` has a high cardinality: 401 distinct values	Warning
`COMPANY` has 3092 (56.7%) missing values	Missing
`COMPANY_SORT` has a high cardinality: 388 distinct values	Warning
`COMPANY_SORT` has 3092 (56.7%) missing values	Missing
`CONTACT_RANK` has constant value "0"	Rejected
`COUNTRY` has 206 (3.8%) missing values	Missing
`COUNTY` has a high cardinality: 507 distinct values	Warning
`COUNTY` has 3576 (65.6%) missing values	Missing
`CRRT` has constant value "nan"	Rejected
`DESIGNATION` has 5429 (99.5%) missing values	Missing
`DISPLAY_CURRENCY` has constant value "nan"	Rejected
`DUP_MATCH_KEY` has a high cardinality: 5387 distinct values	Warning
`EMAIL` has a high cardinality: 4543 distinct values	Warning
`EMAIL` has 556 (10.2%) missing values	Missing
`EXCLUDE_MAIL` has constant value "False"	Rejected
`FAX` has a high cardinality: 53 distinct values	Warning
`FAX` has 4776 (87.6%) missing values	Missing
`FIRST_NAME` has a high cardinality: 1224 distinct values	Warning
`FIRST_NAME` has 373 (6.8%) missing values	Missing
`FULL_ADDRESS` has a high cardinality: 3229 distinct values	Warning
`FULL_ADDRESS` has 165 (3.0%) missing values	Missing
`FULL_NAME` has a high cardinality: 5213 distinct values	Warning
`FULL_NAME` has 228 (4.2%) missing values	Missing
`FUNCTIONAL_TITLE` has 5441 (99.7%) missing values	Missing
`GENDER` has 1148 (21.0%) missing values	Missing
`HOME_PHONE` has a high cardinality: 112 distinct values	Warning
`HOME_PHONE` has 5328 (97.7%) missing values	Missing
`INFORMAL` has a high cardinality: 1185 distinct values	Warning
`INFORMAL` has 407 (7.5%) missing values	Missing
`INTENT_TO_EDIT` has a high cardinality: 58 distinct values	Warning
`INTENT_TO_EDIT` has 5398 (99.0%) missing values	Missing
`JOIN_DATE` has 843 (15.5%) missing values	Missing
`LAST_FIRST` has a high cardinality: 5198 distinct values	Warning
`LAST_FIRST` has 228 (4.2%) missing values	Missing
`LAST_NAME` has a high cardinality: 3022 distinct values	Warning
`LAST_NAME` has 232 (4.3%) missing values	Missing
`MAIL_CODE` has constant value "nan"	Rejected
`MAJOR_KEY` has 509 (9.3%) missing values	Missing
`MEMBER_STATUS` has 2733 (50.1%) missing values	Missing
`MEMBER_STATUS_DATE` has 2786 (51.1%) missing values	Missing
`MIDDLE_NAME` has a high cardinality: 98 distinct values	Warning
`MIDDLE_NAME` has 2995 (54.9%) missing values	Missing
`MOBILE_PHONE` has 5446 (99.8%) missing values	Missing
`MT_CHANGE_DATE` has 5203 (95.4%) missing values	Missing
`PAID_THRU` has 2963 (54.3%) missing values	Missing
`PartyId` is highly correlated with `BT_ID` (ρ = 1)	Rejected
`PREFIX` has 884 (16.2%) missing values	Missing
`PREVIOUS_MT` has 5203 (95.4%) missing values	Missing
`SIC_CODE` has constant value "nan"	Rejected
`SOURCE_CODE` has a high cardinality: 4946 distinct values	Warning
`SOURCE_CODE` has 510 (9.3%) missing values	Missing
`STATE_HOUSE` has constant value "nan"	Rejected
`STATE_PROVINCE` has a high cardinality: 138 distinct values	Warning
`STATE_PROVINCE` has 508 (9.3%) missing values	Missing
`STATE_SENATE` has constant value "nan"	Rejected
`SUFFIX` has 5436 (99.7%) missing values	Missing
`TITLE` has a high cardinality: 195 distinct values	Warning
`TITLE` has 5107 (93.6%) missing values	Missing
`TOLL_FREE` has 5414 (99.2%) missing values	Missing
`US_CONGRESS` has constant value "nan"	Rejected
`WEBSITE` has a high cardinality: 79 distinct values	Warning
`WEBSITE` has 4977 (91.2%) missing values	Missing
`WORK_PHONE` has a high cardinality: 2775 distinct values	Warning
`WORK_PHONE` has 716 (13.1%) missing values	Missing
`ZIP` has a high cardinality: 3008 distinct values	Warning
`ZIP` has 202 (3.7%) missing values	Missing

BAR_CODE
Categorical

Distinct count	93
Unique (%)	1.7%
Missing (%)	96.7%
Missing (n)	5276

/7520671598/	20
/900146/	15
/787594/	11
Other values (89)	133
(Missing)	5276

Toggle details

Common values
Composition

Value	Count	Frequency (%)
/7520671598/	20	0.4%
/900146/	15	0.3%
/787594/	11	0.2%
/708014/	10	0.2%
/2231415499/	8	0.1%
/1000120097/	4	0.1%
/752439/	4	0.1%
/787279/	3	0.1%
/7520687654/	3	0.1%
/223148/	3	0.1%
Other values (82)	98	1.8%
(Missing)	5276	96.7%

Max length	12
Mean length	3.238130156
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

BIRTH_DATE
Date

Distinct count	3412
Unique (%)	62.5%
Missing (%)	19.5%
Missing (n)	1061
Infinite (%)	0.0%
Infinite (n)	0

Minimum	1941-07-04 00:00:00
Maximum	2001-02-09 00:00:00

Toggle details

Histogram of 'BIRTH_DATE' (bins=N)

BT_ID
Numeric

Distinct count	11
Unique (%)	0.2%
Missing (%)	99.8%
Missing (n)	5445
Infinite (%)	0.0%
Infinite (n)	0

Mean	15870.6
Minimum	243
Maximum	22155
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	243
5-th percentile	251.1
Q1	18013.75
Median	18944.5
Q3	20808.75
95-th percentile	21714.45
Maximum	22155
Range	21912
Interquartile range	2795

Descriptive statistics

Standard deviation	8355.560772
Coef of variation	0.526480459
Kurtosis	1.154088872
Mean	15870.6
MAD	6247.44
Skewness	-1.648537325
Sum	158706
Variance	69815395.82
Memory size	42.7 KiB

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
21176	1	< 0.1%
18101	1	< 0.1%
21143	1	< 0.1%
22155	1	< 0.1%
243	1	< 0.1%
18022	1	< 0.1%
19806	1	< 0.1%
18011	1	< 0.1%
19788	1	< 0.1%
261	1	< 0.1%
(Missing)	5445	99.8%

Minimum 5 values

Value	Count	Frequency (%)
243	1	< 0.1%
261	1	< 0.1%
18011	1	< 0.1%
18022	1	< 0.1%
18101	1	< 0.1%
19788	1	< 0.1%
19806	1	< 0.1%
21143	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
22155	1	< 0.1%
21176	1	< 0.1%
21143	1	< 0.1%
19806	1	< 0.1%
19788	1	< 0.1%
18101	1	< 0.1%
18022	1	< 0.1%
18011	1	< 0.1%

CATEGORY
Categorical

Distinct count	4
Unique (%)	0.1%
Missing (%)	13.2%
Missing (n)	718

1	4735
2	1
WEB	1
(Missing)	718

Toggle details

Common values
Composition

Value	Count	Frequency (%)
1	4735	86.8%
2	1	< 0.1%
WEB	1	< 0.1%
(Missing)	718	13.2%

Max length	3
Mean length	1.263611366
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

CHAPTER
Categorical

Distinct count	8
Unique (%)	0.1%
Missing (%)	56.2%
Missing (n)	3065

WEST	1204
NORTH	420
SOUTH	406
Other values (4)	360
(Missing)	3065

Toggle details

Common values
Composition

Value	Count	Frequency (%)
WEST	1204	22.1%
NORTH	420	7.7%
SOUTH	406	7.4%
EAST	353	6.5%
TORONTO	4	0.1%
LONDON	2	< 0.1%
TX	1	< 0.1%
(Missing)	3065	56.2%

Max length	7
Mean length	3.592117324
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

CITY
Categorical

Distinct count	1708
Unique (%)	31.3%
Missing (%)	3.7%
Missing (n)	204

London	216
Los Angeles	114
New York	107
Other values (1704)	4814
(Missing)	204

Toggle details

Common values
Composition

Value	Count	Frequency (%)
London	216	4.0%
Los Angeles	114	2.1%
New York	107	2.0%
Toronto	94	1.7%
Victoria	83	1.5%
Austin	81	1.5%
Chicago	77	1.4%
Vancouver	73	1.3%
Chesterfield	72	1.3%
Indianapolis	60	1.1%
Other values (1697)	4274	78.4%
(Missing)	204	3.7%

Max length	28
Mean length	8.401099908
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

CO_ID
Numeric

Distinct count	262
Unique (%)	4.8%
Missing (%)	63.6%
Missing (n)	3471
Infinite (%)	0.0%
Infinite (n)	0

Mean	19045.25958
Minimum	101
Maximum	23126
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	101
5-th percentile	229
Q1	18990
Median	19784
Q3	19831
95-th percentile	23091
Maximum	23126
Range	23025
Interquartile range	841

Descriptive statistics

Standard deviation	4708.155441
Coef of variation	0.247208783
Kurtosis	10.77882073
Mean	19045.25958
MAD	2282.585078
Skewness	-3.308741099
Sum	37785795
Variance	22166727.66
Memory size	42.7 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19808	83	1.5%
19784	72	1.3%
19797	55	1.0%
19806	50	0.9%
19831	49	0.9%
19817	47	0.9%
18065	31	0.6%
19822	30	0.5%
19809	30	0.5%
18013	29	0.5%
Other values (251)	1508	27.6%
(Missing)	3471	63.6%

Minimum 5 values

Value	Count	Frequency (%)
101	5	0.1%
104	3	0.1%
110	3	0.1%
114	2	< 0.1%
118	1	< 0.1%
121	1	< 0.1%
127	1	< 0.1%
130	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
23126	2	< 0.1%
23124	7	0.1%
23123	3	0.1%
23122	5	0.1%
23117	14	0.3%
23111	2	< 0.1%
23110	3	0.1%
23109	3	0.1%

CO_MEMBER_TYPE
Categorical

Distinct count	6
Unique (%)	0.1%
Missing (%)	63.6%
Missing (n)	3471

CM	1408
NMC	532
PC	40
Other values (2)	4
(Missing)	3471

Toggle details

Common values
Composition

Value	Count	Frequency (%)
CM	1408	25.8%
NMC	532	9.8%
PC	40	0.7%
HOTEL	3	0.1%
HH	1	< 0.1%
(Missing)	3471	63.6%

Max length	5
Mean length	2.735472044
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

COMPANY
Categorical

Distinct count	401
Unique (%)	7.4%
Missing (%)	56.7%
Missing (n)	3092

Card Systems	84
Web Academy	73
Accessible Solutions Consulting	56
Other values (397)	2150
(Missing)	3092

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Card Systems	84	1.5%
Web Academy	73	1.3%
Accessible Solutions Consulting	56	1.0%
Acorn Specialties	51	0.9%
Red Banner Ambassadors	50	0.9%
Browning Systems	47	0.9%
Cokeson Partners	31	0.6%
Fountain Design, Inc	31	0.6%
Computer Products	30	0.5%
iMIS International	30	0.5%
Other values (390)	1880	34.5%
(Missing)	3092	56.7%

Max length	71
Mean length	9.875160403
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

COMPANY_RECORD
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

False	5174
True	281

Toggle details

Value	Count	Frequency (%)
False	5174	94.8%
True	281	5.2%

COMPANY_SORT
Categorical

Distinct count	388
Unique (%)	7.1%
Missing (%)	56.7%
Missing (n)	3092

CARD SYSTEMS	84
WEB ACADEMY	73
ACCESSIBLE SOLUTIONS CONSULTIN	57
Other values (384)	2149
(Missing)	3092

Toggle details

Common values
Composition

Value	Count	Frequency (%)
CARD SYSTEMS	84	1.5%
WEB ACADEMY	73	1.3%
ACCESSIBLE SOLUTIONS CONSULTIN	57	1.0%
ACORN SPECIALTIES	51	0.9%
RED BANNER AMBASSADORS	50	0.9%
BROWNING SYSTEMS	47	0.9%
OPUS, INC.	35	0.6%
COKESON PARTNERS	31	0.6%
FOUNTAIN DESIGN, INC	31	0.6%
COMPUTER PRODUCTS	30	0.5%
Other values (377)	1874	34.4%
(Missing)	3092	56.7%

Max length	30
Mean length	9.540054995
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

CONTACT_RANK
Constant

This variable is constant and should be ignored for analysis

Constant value	0

COUNTRY
Categorical

Distinct count	19
Unique (%)	0.3%
Missing (%)	3.8%
Missing (n)	206

United States	2511
United Kingdom	1078
Canada	773
Other values (15)	887

Toggle details

Common values
Composition

Value	Count	Frequency (%)
United States	2511	46.0%
United Kingdom	1078	19.8%
Canada	773	14.2%
Australia	761	14.0%
Singapore	36	0.7%
France	15	0.3%
Peru	12	0.2%
India	11	0.2%
New Zealand	10	0.2%
Malaysia	9	0.2%
Other values (8)	33	0.6%
(Missing)	206	3.8%

Max length	14
Mean length	11.13840513
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

COUNTY
Categorical

Distinct count	507
Unique (%)	9.3%
Missing (%)	65.6%
Missing (n)	3576

Los Angeles	102
Dallas	61
Alexandria City	53
Other values (503)	1663
(Missing)	3576

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Los Angeles	102	1.9%
Dallas	61	1.1%
Alexandria City	53	1.0%
San Diego	46	0.8%
Cook	37	0.7%
Essex	34	0.6%
Harris	28	0.5%
Maricopa	28	0.5%
Travis	26	0.5%
Saginaw	25	0.5%
Other values (496)	1439	26.4%
(Missing)	3576	65.6%

Max length	20
Mean length	4.670210816
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

CRRT
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

DATE_ADDED
Date

Distinct count	156
Unique (%)	2.9%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Minimum	1992-08-10 00:00:00
Maximum	2018-01-13 00:00:00

Toggle details

Histogram of 'DATE_ADDED' (bins=N)

DESIGNATION
Categorical

Distinct count	12
Unique (%)	0.2%
Missing (%)	99.5%
Missing (n)	5429

CPA	12
PhD	2
MBA	2
Other values (8)	10
(Missing)	5429

Toggle details

Common values
Composition

Value	Count	Frequency (%)
CPA	12	0.2%
PhD	2	< 0.1%
MBA	2	< 0.1%
M.D.	2	< 0.1%
MD	2	< 0.1%
LLB	1	< 0.1%
MD, PhD	1	< 0.1%
LLM	1	< 0.1%
PhD.	1	< 0.1%
CAPAE	1	< 0.1%
(Missing)	5429	99.5%

Max length	7
Mean length	3.001283226
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

DISPLAY_CURRENCY
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

DUP_MATCH_KEY
Categorical

Distinct count	5387
Unique (%)	98.8%
Missing (%)	0.1%
Missing (n)	3

60601GUENJ	10
DAVI	5
MICH	5
Other values (5383)	5432

Toggle details

Common values
Composition

Value	Count	Frequency (%)
60601GUENJ	10	0.2%
DAVI	5	0.1%
MICH	5	0.1%
MAHEJ	4	0.1%
ANDR	4	0.1%
MARK	4	0.1%
KEIT	3	0.1%
ROBE	3	0.1%
KATH	3	0.1%
KRIS	3	0.1%
Other values (5376)	5408	99.1%

Max length	10
Mean length	9.598533456
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

EMAIL
Categorical

Distinct count	4543
Unique (%)	83.3%
Missing (%)	10.2%
Missing (n)	556

moreinfo@imisdemo.com	8
info@imisdemo.com	7
custserv@imisdemo.com	7
Other values (4539)	4877
(Missing)	556

Toggle details

Common values
Composition

Value	Count	Frequency (%)
moreinfo@imisdemo.com	8	0.1%
info@imisdemo.com	7	0.1%
custserv@imisdemo.com	7	0.1%
jrguenther@bscichicago.com	7	0.1%
orders@imisdemo.com	7	0.1%
member@imisdemo.com	6	0.1%
help@imisdemo.com	6	0.1%
jbrown@imisdemo.com	6	0.1%
jjones@imisdemo.com	5	0.1%
tsmith@imisdemo.com	5	0.1%
Other values (4532)	4835	88.6%
(Missing)	556	10.2%

Max length	40
Mean length	19.03208066
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

EXCLUDE_DIRECTORY
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

False	5454
True	1

Toggle details

Value	Count	Frequency (%)
False	5454	> 99.9%
True	1	< 0.1%

EXCLUDE_MAIL
Constant

This variable is constant and should be ignored for analysis

Constant value	False

FAX
Categorical

Distinct count	53
Unique (%)	1.0%
Missing (%)	87.6%
Missing (n)	4776

(212) 556-3526	85
(512) 344-9807	77
(203) 984-8768	52
Other values (49)	465
(Missing)	4776

Toggle details

Common values
Composition

Value	Count	Frequency (%)
(212) 556-3526	85	1.6%
(512) 344-9807	77	1.4%
(203) 984-8768	52	1.0%
(713) 897-3459	51	0.9%
(301) 526-3645	32	0.6%
(317) 432-5565	31	0.6%
(612) 657-4426	28	0.5%
(214) 370-3447	27	0.5%
(213) 624-5000	26	0.5%
(201) 553-8999	24	0.4%
Other values (42)	246	4.5%
(Missing)	4776	87.6%

Max length	14
Mean length	4.345004583
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

FIRST_NAME
Categorical

Distinct count	1224
Unique (%)	22.4%
Missing (%)	6.8%
Missing (n)	373

James	73
John	64
David	59
Other values (1220)	4886
(Missing)	373

Toggle details

Common values
Composition

Value	Count	Frequency (%)
James	73	1.3%
John	64	1.2%
David	59	1.1%
William	53	1.0%
Michael	45	0.8%
Charles	44	0.8%
Mary	43	0.8%
Robert	39	0.7%
Thomas	32	0.6%
Richard	31	0.6%
Other values (1213)	4599	84.3%
(Missing)	373	6.8%

Max length	14
Mean length	5.386617782
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

FULL_ADDRESS
Categorical

Distinct count	3229
Unique (%)	59.2%
Missing (%)	3.0%
Missing (n)	165

459 7th Ave-New York, NY 10001-2009-UNITED STATES	84
1322C Central Parkway-Los Angeles, CA 92138-UNITED STATES	67
2050 California Dr-Ripley, WV 25271-UNITED STATES	56
Other values (3225)	5083
(Missing)	165

Toggle details

Common values
Composition

Value	Count	Frequency (%)
459 7th Ave-New York, NY 10001-2009-UNITED STATES	84	1.5%
1322C Central Parkway-Los Angeles, CA 92138-UNITED STATES	67	1.2%
2050 California Dr-Ripley, WV 25271-UNITED STATES	56	1.0%
PO Box 9357-Indianapolis, IN 46202-UNITED STATES	50	0.9%
10 High Street Laughton-567-SHEFFIELD-S25 1YF-UNITED KINGDOM	50	0.9%
Telford Crescent -Speedwell Industrial Estate-CHESTERFIELD-S43 3PF-UNITED KINGDOM	41	0.8%
8439 Wisconsin Ave-Bethesda, MD 20814-3105-UNITED STATES	31	0.6%
8910 Sylvan Rdg-Eden Prairie, MN 55347-3336-UNITED STATES	30	0.5%
Unit 23 Braden Industrial Estate-Worthing Road-SEVENOAKS-TN15 8DG-UNITED KINGDOM	30	0.5%
4633 State Road 930-Fort Wayne, IN 46803-1613-UNITED STATES	29	0.5%
Other values (3218)	4822	88.4%
(Missing)	165	3.0%

Max length	95
Mean length	51.4731439
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

FULL_NAME
Categorical

Distinct count	5213
Unique (%)	95.6%
Missing (%)	4.2%
Missing (n)	228

Jon Guenther	12
Joseph Maher	3
Timothy Alexander	2
Other values (5209)	5210
(Missing)	228

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Jon Guenther	12	0.2%
Joseph Maher	3	0.1%
Timothy Alexander	2	< 0.1%
Mrs. Ebony O. Salvaire	2	< 0.1%
Mrs. Caroline I. Bennett	1	< 0.1%
Mr. Scott Yarbrough	1	< 0.1%
Mr. Doug Bradford	1	< 0.1%
Mr. Nicholas Graves	1	< 0.1%
Mrs. Brittany Hammond	1	< 0.1%
Ms. Ursula Eskola	1	< 0.1%
Other values (5202)	5202	95.4%
(Missing)	228	4.2%

Max length	34
Mean length	17.50430797
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

FUNCTIONAL_TITLE
Categorical

Distinct count	9
Unique (%)	0.2%
Missing (%)	99.7%
Missing (n)	5441

VP	3
CIO	3
CEO	2
Other values (5)	6
(Missing)	5441

Toggle details

Common values
Composition

Value	Count	Frequency (%)
VP	3	0.1%
CIO	3	0.1%
CEO	2	< 0.1%
DPM	2	< 0.1%
CFO	1	< 0.1%
CTO	1	< 0.1%
MGRDIR	1	< 0.1%
Executive Director	1	< 0.1%
(Missing)	5441	99.7%

Max length	18
Mean length	3.002749771
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

GENDER
Categorical

Distinct count	3
Unique (%)	0.1%
Missing (%)	21.0%
Missing (n)	1148

F	2295
M	2012
(Missing)	1148

Toggle details

Common values
Composition

Value	Count	Frequency (%)
F	2295	42.1%
M	2012	36.9%
(Missing)	1148	21.0%

Max length	3
Mean length	1.420898258
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

HOME_PHONE
Categorical

Distinct count	112
Unique (%)	2.1%
Missing (%)	97.7%
Missing (n)	5328

(512) 565-9944	4
(201) 786-5432	3
(512) 875-6475	2
Other values (108)	118
(Missing)	5328

Toggle details

Common values
Composition

Value	Count	Frequency (%)
(512) 565-9944	4	0.1%
(201) 786-5432	3	0.1%
(512) 875-6475	2	< 0.1%
(312) 553-6700	2	< 0.1%
(214) 659-7763	2	< 0.1%
(214) 675-8988	2	< 0.1%
(512) 098-7654	2	< 0.1%
(214) 233-7676	2	< 0.1%
(214) 678-9563	2	< 0.1%
(609) 456-7213	2	< 0.1%
Other values (101)	104	1.9%
(Missing)	5328	97.7%

Max length	14
Mean length	3.253895509
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

INFORMAL
Categorical

Distinct count	1185
Unique (%)	21.7%
Missing (%)	7.5%
Missing (n)	407

James	65
John	63
David	57
Other values (1181)	4863
(Missing)	407

Toggle details

Common values
Composition

Value	Count	Frequency (%)
James	65	1.2%
John	63	1.2%
David	57	1.0%
William	52	1.0%
Mary	43	0.8%
Michael	42	0.8%
Charles	38	0.7%
Robert	35	0.6%
Mark	30	0.5%
Karen	29	0.5%
Other values (1174)	4594	84.2%
(Missing)	407	7.5%

Max length	14
Mean length	5.275160403
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

INTENT_TO_EDIT
Categorical

Distinct count	58
Unique (%)	1.1%
Missing (%)	99.0%
Missing (n)	5398

11239917:24:38.00	1
11239916:09:46.00	1
11239916:13:17.00	1
Other values (54)	54
(Missing)	5398

Toggle details

Common values
Composition

Value	Count	Frequency (%)
11239917:24:38.00	1	< 0.1%
11239916:09:46.00	1	< 0.1%
11239916:13:17.00	1	< 0.1%
10290110:22:46.00	1	< 0.1%
11239916:33:38.00	1	< 0.1%
11239916:18:35.00	1	< 0.1%
11239917:17:42.00	1	< 0.1%
11239917:23:41.00	1	< 0.1%
11239917:15:17.00	1	< 0.1%
11239916:16:03.00	1	< 0.1%
Other values (47)	47	0.9%
(Missing)	5398	99.0%

Max length	17
Mean length	3.146287809
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

JOIN_DATE
Date

Distinct count	1860
Unique (%)	34.1%
Missing (%)	15.5%
Missing (n)	843
Infinite (%)	0.0%
Infinite (n)	0

Minimum	1965-05-02 00:00:00
Maximum	2016-08-11 00:00:00

Toggle details

Histogram of 'JOIN_DATE' (bins=N)

LAST_FIRST
Categorical

Distinct count	5198
Unique (%)	95.3%
Missing (%)	4.2%
Missing (n)	228

GUENTHER, JON	12
MAHER, JOSEPH	3
WILLIAMS, JOAN	2
Other values (5194)	5210
(Missing)	228

Toggle details

Common values
Composition

Value	Count	Frequency (%)
GUENTHER, JON	12	0.2%
MAHER, JOSEPH	3	0.1%
WILLIAMS, JOAN	2	< 0.1%
JONES, KAREN	2	< 0.1%
SMITH, WILLIAM	2	< 0.1%
MANLEY, TERRENCE	2	< 0.1%
GILBERT, KELLY	2	< 0.1%
TIMOTHY ALEXANDER	2	< 0.1%
JACKSON, DAVID	2	< 0.1%
WILLIAMS, BRUCE	2	< 0.1%
Other values (5187)	5196	95.3%
(Missing)	228	4.2%

Max length	26
Mean length	13.50797434
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

LAST_NAME
Categorical

Distinct count	3022
Unique (%)	55.4%
Missing (%)	4.3%
Missing (n)	232

Smith	54
Johnson	45
Williams	40
Other values (3018)	5084
(Missing)	232

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Smith	54	1.0%
Johnson	45	0.8%
Williams	40	0.7%
Brown	37	0.7%
Jones	29	0.5%
Taylor	20	0.4%
Miller	18	0.3%
White	17	0.3%
Davis	17	0.3%
Green	16	0.3%
Other values (3011)	4930	90.4%
(Missing)	232	4.3%

Max length	24
Mean length	6.467277727
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

LAST_UPDATED
Date

Distinct count	3970
Unique (%)	72.8%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Minimum	2001-02-19 14:04:00
Maximum	2018-01-13 18:13:03.927000

Toggle details

Histogram of 'LAST_UPDATED' (bins=N)

MAIL_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

MAJOR_KEY
Numeric

Distinct count	4944
Unique (%)	90.6%
Missing (%)	9.3%
Missing (n)	509
Infinite (%)	0.0%
Infinite (n)	0

Mean	13136.75455
Minimum	101
Maximum	123456
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	101
5-th percentile	10195.25
Q1	11186.25
Median	12423.5
Q3	15224.25
95-th percentile	17609
Maximum	123456
Range	123355
Interquartile range	4038

Descriptive statistics

Standard deviation	3285.360453
Coef of variation	0.2500892013
Kurtosis	264.7622493
Mean	13136.75455
MAD	2272.356082
Skewness	7.431161471
Sum	64974388
Variance	10793593.3
Memory size	42.7 KiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17966	2	< 0.1%
10009	2	< 0.1%
12428	2	< 0.1%
12047	1	< 0.1%
10067	1	< 0.1%
17547	1	< 0.1%
15298	1	< 0.1%
11029	1	< 0.1%
11446	1	< 0.1%
12954	1	< 0.1%
Other values (4933)	4933	90.4%
(Missing)	509	9.3%

Minimum 5 values

Value	Count	Frequency (%)
101	1	< 0.1%
104	1	< 0.1%
105	1	< 0.1%
107	1	< 0.1%
108	1	< 0.1%
109	1	< 0.1%
110	1	< 0.1%
111	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
123456	1	< 0.1%
56634	1	< 0.1%
17992	1	< 0.1%
17986	1	< 0.1%
17985	1	< 0.1%
17981	1	< 0.1%
17980	1	< 0.1%
17979	1	< 0.1%

MEMBER_RECORD
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

False	2743
True	2712

Toggle details

Value	Count	Frequency (%)
False	2743	50.3%
True	2712	49.7%

MEMBER_STATUS
Categorical

Distinct count	6
Unique (%)	0.1%
Missing (%)	50.1%
Missing (n)	2733

R	2089
N	536
D	43
Other values (2)	54
(Missing)	2733

Toggle details

Common values
Composition

Value	Count	Frequency (%)
R	2089	38.3%
N	536	9.8%
D	43	0.8%
I	41	0.8%
S	13	0.2%
(Missing)	2733	50.1%

Max length	3
Mean length	2.002016499
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

MEMBER_STATUS_DATE
Date

Distinct count	360
Unique (%)	6.6%
Missing (%)	51.1%
Missing (n)	2786
Infinite (%)	0.0%
Infinite (n)	0

Minimum	1901-04-08 00:00:00
Maximum	2017-08-01 00:00:00

Toggle details

Histogram of 'MEMBER_STATUS_DATE' (bins=N)

MEMBER_TYPE
Categorical

Distinct count	19
Unique (%)	0.3%
Missing (%)	0.0%
Missing (n)	0

M	2403
NM	1780
D	427
Other values (16)	845

Toggle details

Common values
Composition

Value	Count	Frequency (%)
M	2403	44.1%
NM	1780	32.6%
D	427	7.8%
P	292	5.4%
CM	185	3.4%
NMC	85	1.6%
ASI	73	1.3%
PART	72	1.3%
STF	58	1.1%
A	27	0.5%
Other values (9)	53	1.0%

Max length	5
Mean length	1.503024748
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

MIDDLE_NAME
Categorical

Distinct count	98
Unique (%)	1.8%
Missing (%)	54.9%
Missing (n)	2995

L.	121
K.	121
E.	120
Other values (94)	2098
(Missing)	2995

Toggle details

Common values
Composition

Value	Count	Frequency (%)
L.	121	2.2%
K.	121	2.2%
E.	120	2.2%
F.	118	2.2%
N.	117	2.1%
G.	115	2.1%
J.	110	2.0%
H.	110	2.0%
A.	105	1.9%
P.	100	1.8%
Other values (87)	1323	24.3%
(Missing)	2995	54.9%

Max length	9
Mean length	2.606232814
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	True

MOBILE_PHONE
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing (%)	99.8%
Missing (n)	5446

(312) 498-3885	9
(Missing)	5446

Toggle details

Common values
Composition

Value	Count	Frequency (%)
(312) 498-3885	9	0.2%
(Missing)	5446	99.8%

Max length	14
Mean length	3.018148488
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

MT_CHANGE_DATE
Date

Distinct count	186
Unique (%)	3.4%
Missing (%)	95.4%
Missing (n)	5203
Infinite (%)	0.0%
Infinite (n)	0

Minimum	1994-12-04 00:00:00
Maximum	2017-06-12 14:26:36

Toggle details

Histogram of 'MT_CHANGE_DATE' (bins=N)

ORG_CODE
Categorical

Distinct count	6
Unique (%)	0.1%
Missing (%)	0.1%
Missing (n)	4

DEMO	5415
ORG1	33
NAE	1
Other values (2)	2
(Missing)	4

Toggle details

Common values
Composition

Value	Count	Frequency (%)
DEMO	5415	99.3%
ORG1	33	0.6%
NAE	1	< 0.1%
GEO	1	< 0.1%
GSTIN	1	< 0.1%
(Missing)	4	0.1%

Max length	5
Mean length	3.99908341
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

PAID_THRU
Categorical

Distinct count	48
Unique (%)	0.9%
Missing (%)	54.3%
Missing (n)	2963

2011-12-30	1148
2012-03-30	340
2017-12-31	258
Other values (44)	746
(Missing)	2963

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2011-12-30	1148	21.0%
2012-03-30	340	6.2%
2017-12-31	258	4.7%
2010-12-30	225	4.1%
2011-03-30	108	2.0%
2012-06-30	100	1.8%
2012-02-28	53	1.0%
2011-11-28	38	0.7%
2001-03-30	28	0.5%
2011-09-30	23	0.4%
Other values (37)	171	3.1%
(Missing)	2963	54.3%

Max length	19
Mean length	6.656095325
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

PartyId
Highly correlated

This variable is highly correlated with BT_ID and should be ignored for analysis

Correlation	1

PREFIX
Categorical

Distinct count	14
Unique (%)	0.3%
Missing (%)	16.2%
Missing (n)	884

Mr.	2063
Ms.	1680
Mrs.	661
Other values (10)	167
(Missing)	884

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Mr.	2063	37.8%
Ms.	1680	30.8%
Mrs.	661	12.1%
Miss	65	1.2%
Dr.	44	0.8%
Rev.	21	0.4%
Hon.	14	0.3%
Pastor	12	0.2%
Lieutenant Colonel	4	0.1%
Ms	3	0.1%
Other values (3)	4	0.1%
(Missing)	884	16.2%

Max length	18
Mean length	3.157286893
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

PREVIOUS_MT
Categorical

Distinct count	14
Unique (%)	0.3%
Missing (%)	95.4%
Missing (n)	5203

NM	84
STF	68
M	44
Other values (10)	56
(Missing)	5203

Toggle details

Common values
Composition

Value	Count	Frequency (%)
NM	84	1.5%
STF	68	1.2%
M	44	0.8%
NMC	16	0.3%
CM	13	0.2%
A	10	0.2%
D	5	0.1%
P	5	0.1%
APPL	3	0.1%
RET	1	< 0.1%
Other values (3)	3	0.1%
(Missing)	5203	95.4%

Max length	4
Mean length	2.959486709
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

SIC_CODE
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

SOURCE_CODE
Categorical

Distinct count	4946
Unique (%)	90.7%
Missing (%)	9.3%
Missing (n)	510

uk_final_export_14803	1
usa_final_export_10058	1
usa_final_export_10167	1
Other values (4942)	4942
(Missing)	510

Toggle details

Common values
Composition

Value	Count	Frequency (%)
uk_final_export_14803	1	< 0.1%
usa_final_export_10058	1	< 0.1%
usa_final_export_10167	1	< 0.1%
aus_final_export_17328	1	< 0.1%
canada_final_Export_13607	1	< 0.1%
usa_final_export_10774	1	< 0.1%
usa_final_export_10568	1	< 0.1%
canada_final_Export_14540	1	< 0.1%
uk_final_export_14921	1	< 0.1%
usa_final_export_11192	1	< 0.1%
Other values (4935)	4935	90.5%
(Missing)	510	9.3%

Max length	25
Mean length	20.44601283
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

STATE_HOUSE
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

STATE_PROVINCE
Categorical

Distinct count	138
Unique (%)	2.5%
Missing (%)	9.3%
Missing (n)	508

ON	332
CA	314
TX	292
Other values (134)	4009
(Missing)	508

Toggle details

Common values
Composition

Value	Count	Frequency (%)
ON	332	6.1%
CA	314	5.8%
TX	292	5.4%
WA	175	3.2%
NY	170	3.1%
VIC	164	3.0%
BC	156	2.9%
PA	127	2.3%
QLD	127	2.3%
SA	121	2.2%
Other values (127)	2969	54.4%
(Missing)	508	9.3%

Max length	15
Mean length	3.362053162
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

STATE_SENATE
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

STATUS
Categorical

Distinct count	3
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0

A	5446
D	7
I	2

Toggle details

Common values
Composition

Value	Count	Frequency (%)
A	5446	99.8%
D	7	0.1%
I	2	< 0.1%

Max length	1
Mean length	1
Min length	1
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

SUFFIX
Categorical

Distinct count	4
Unique (%)	0.1%
Missing (%)	99.7%
Missing (n)	5436

Jr.	12
III	4
Sr.	3
(Missing)	5436

Toggle details

Common values
Composition

Value	Count	Frequency (%)
Jr.	12	0.2%
III	4	0.1%
Sr.	3	0.1%
(Missing)	5436	99.7%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	True

TITLE
Categorical

Distinct count	195
Unique (%)	3.6%
Missing (%)	93.6%
Missing (n)	5107

President	30
Vice President	15
Sales Manager	11
Other values (191)	292
(Missing)	5107

Toggle details

Common values
Composition

Value	Count	Frequency (%)
President	30	0.5%
Vice President	15	0.3%
Sales Manager	11	0.2%
Branch Manager	10	0.2%
CEO	7	0.1%
Office Manager	6	0.1%
Director	6	0.1%
Accountant	6	0.1%
Team Lead	6	0.1%
Controller	6	0.1%
Other values (184)	245	4.5%
(Missing)	5107	93.6%

Max length	38
Mean length	3.777818515
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	True
Contains non-words	True

TOLL_FREE
Categorical

Distinct count	6
Unique (%)	0.1%
Missing (%)	99.2%
Missing (n)	5414

(800) 433-8900	27
(800) 9HILTON	8
(800) 984-0000	3
Other values (2)	3
(Missing)	5414

Toggle details

Common values
Composition

Value	Count	Frequency (%)
(800) 433-8900	27	0.5%
(800) 9HILTON	8	0.1%
(800) 984-0000	3	0.1%
(800) 123-4567	2	< 0.1%
(180) 043-3890	1	< 0.1%
(Missing)	5414	99.2%

Max length	14
Mean length	3.081209899
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

UPDATED_BY
Categorical

Distinct count	48
Unique (%)	0.9%
Missing (%)	0.0%
Missing (n)	0

BRIANP	3336
BRIANM	1272
BSCHRADER	432
Other values (45)	415

Toggle details

Common values
Composition

Value	Count	Frequency (%)
BRIANP	3336	61.2%
BRIANM	1272	23.3%
BSCHRADER	432	7.9%
MANAGER	186	3.4%
FADMIN	78	1.4%
CHARLOTTE	36	0.7%
BMURPHY	26	0.5%
217	12	0.2%
CROBERTSON	11	0.2%
18106	9	0.2%
Other values (38)	57	1.0%

Max length	27
Mean length	6.337121907
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

US_CONGRESS
Constant

This variable is constant and should be ignored for analysis

Constant value	nan

WEBSITE
Categorical

Distinct count	79
Unique (%)	1.4%
Missing (%)	91.2%
Missing (n)	4977

versaton.imisdemo.com	30
www.prodigy.com	23
www.bachmanfloral.com	20
Other values (75)	405
(Missing)	4977

Toggle details

Common values
Composition

Value	Count	Frequency (%)
versaton.imisdemo.com	30	0.5%
www.prodigy.com	23	0.4%
www.bachmanfloral.com	20	0.4%
www.imisdemo.com	20	0.4%
www.century21.ca/vancouver	18	0.3%
www.couturier.com.ca	16	0.3%
www.nhq.org	16	0.3%
www.regina.com.ca	15	0.3%
www.lakeviewtravel.com.ca	15	0.3%
www.opusisus.com	14	0.3%
Other values (68)	291	5.3%
(Missing)	4977	91.2%

Max length	48
Mean length	4.560953254
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

WORK_PHONE
Categorical

Distinct count	2775
Unique (%)	50.9%
Missing (%)	13.1%
Missing (n)	716

08704887700	110
(212) 556-7489	85
(512) 344-5687	76
Other values (2771)	4468
(Missing)	716

Toggle details

Common values
Composition

Value	Count	Frequency (%)
08704887700	110	2.0%
(212) 556-7489	85	1.6%
(512) 344-5687	76	1.4%
(214) 987-8765	62	1.1%
020 8243 0564	57	1.0%
(516) 987-2222	43	0.8%
(301) 526-8795	32	0.6%
(317) 432-5560	31	0.6%
08207887700	30	0.5%
(312) 333-4450	28	0.5%
Other values (2764)	4185	76.7%
(Missing)	716	13.1%

Max length	24
Mean length	12.53418882
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

ZIP
Categorical

Distinct count	3008
Unique (%)	55.1%
Missing (%)	3.7%
Missing (n)	202

10001-2009	85
92138	67
25271	56
Other values (3004)	5045
(Missing)	202

Toggle details

Common values
Composition

Value	Count	Frequency (%)
10001-2009	85	1.6%
92138	67	1.2%
25271	56	1.0%
S25 1YF	50	0.9%
46202	50	0.9%
S43 3PF	48	0.9%
5000	47	0.9%
7000	38	0.7%
78759	34	0.6%
55347-3336	31	0.6%
Other values (2997)	4747	87.0%
(Missing)	202	3.7%

Max length	10
Mean length	7.367736022
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	True
Contains non-words	True

First rows

	BAR_CODE	BIRTH_DATE	BT_ID	CATEGORY	CHAPTER	CITY	CO_ID	CO_MEMBER_TYPE	COMPANY	COMPANY_RECORD	COMPANY_SORT	COUNTRY	COUNTY	CRRT	DATE_ADDED	DESIGNATION	DISPLAY_CURRENCY	DUP_MATCH_KEY	EMAIL	EXCLUDE_DIRECTORY	EXCLUDE_MAIL	FAX	FIRST_NAME	FULL_ADDRESS	FULL_NAME	FUNCTIONAL_TITLE	GENDER	HOME_PHONE	INFORMAL	INTENT_TO_EDIT	JOIN_DATE	LAST_FIRST	LAST_NAME	LAST_UPDATED	MAIL_CODE	MAJOR_KEY	MEMBER_RECORD	MEMBER_STATUS	MEMBER_STATUS_DATE	MEMBER_TYPE	MIDDLE_NAME	MOBILE_PHONE	MT_CHANGE_DATE	ORG_CODE	PAID_THRU	PartyId	PREFIX	PREVIOUS_MT	SIC_CODE	SOURCE_CODE	STATE_HOUSE	STATE_PROVINCE	STATE_SENATE	STATUS	SUFFIX	TITLE	TOLL_FREE	UPDATED_BY	US_CONGRESS	WEBSITE	WORK_PHONE	ZIP
0	NaN	1950-04-21	NaN	NaN	NaN	Newark	NaN	NaN	Prodigy Makers International	True	PRODIGY MAKERS INTERNATIONAL	United States	NaN	NaN	1994-11-27 00:00:00.000	NaN	NaN	07107HUNTD	jrguenther@bscichicago.com	False	False	(201) 898-4255	Douglas	P.O. Box 4564-Newark, NJ 07107-2564-UNITED ST...	Mr. Douglas A. Hunt, Jr.	NaN	M	(201) 346-9989	Doug	03060017:56:10.00	1965-05-02	HUNT, DOUGLAS	Hunt	2016-06-17 11:09:11.000	NaN	NaN	True	R	2016-08-09 00:00:00	CM	A.	NaN	NaT	ORG1	2017-03-31T00:00:00	101	Mr.	NaN	NaN	NaN	NaN	NJ	NaN	A	Jr.	President	NaN	MANAGER	NaN	NaN	(201) 898-9000	07107-2564
1	NaN	NaT	NaN	NaN	NaN	NaN	NaN	NaN	NaN	False	NaN	NaN	NaN	NaN	2008-05-27 10:38:51.000	NaN	NaN	NaN	NaN	False	False	NaN	NUNIT1	NaN	NUNIT1	NaN	NaN	NaN	NaN	NaN	NaT	NUNIT1	NaN	2008-05-27 10:38:51.000	NaN	NaN	False	NaN	NaT	NM	NaN	NaN	NaT	NaN	NaN	103	NaN	NaN	NaN	NaN	NaN	NaN	NaN	A	NaN	NaN	NaN	BSCHRADER	NaN	NaN	NaN	NaN
2	NaN	1950-05-03	NaN	1	NaN	Somerville	NaN	NaN	Foundation Support Systems	True	FOUNDATION SUPPORT SYSTEMS	United States	NaN	NaN	1992-08-10 00:00:00.000	PhD.	NaN	88760CORWC	NaN	False	False	(201) 543-6785	Charles	150 Highway 202-Somerville, NJ 88760-UNITED S...	Dr. Charles R. Corwin, PhD.	NaN	NaN	(201) 456-8903	Chuck	11239917:13:29.00	1970-05-03	CORWIN, CHARLES	Corwin	2014-07-15 16:35:05.490	NaN	NaN	True	R	1998-03-04 00:00:00	CM	R.	NaN	1994-12-04 00:00:00.000	ORG1	2001-03-30	104	Dr.	NM	NaN	NaN	NaN	NJ	NaN	A	NaN	President	NaN	BRIANM	NaN	NaN	(201) 245-6754	88760
3	/0887612459/	NaT	NaN	NaN	WEST	Somerville	104.0	CM	Foundation Support Systems	False	FOUNDATION SUPPORT SYSTEMS	NaN	NaN	NaN	1992-08-10 00:00:00.000	NaN	NaN	08876HAMIC	carolhamilton@imisdemo.com	False	False	(201) 543-6785	Carol	P.O. Box 472665-Somerville, NJ 08876-1245	Ms. Carol A. Hamilton	NaN	F	(201) 786-5432	Carol	11239916:39:15.00	1990-05-03	HAMILTON, CAROL	Hamilton	2014-10-17 15:55:47.027	NaN	NaN	True	R	1998-01-04 00:00:00	M	A.	NaN	NaT	ORG1	2001-03-30	105	Ms.	NaN	NaN	NaN	NaN	NJ	NaN	A	NaN	Administrative Assistant	NaN	BRIANM	NaN	NaN	(201) 245-6754	08876-1245
4	/2584014042/	NaT	NaN	NaN	WEST	Fayetteville	19751.0	PC	Berry Ltd.	False	BERRY LTD.	United States	Fayette	NaN	2007-10-17 18:12:30.730	NaN	NaN	25840PANDJ	jpandit@imisdemo.com	False	False	NaN	Jai	184 Allen St-Fayetteville, WV 25840-1404-UNIT...	Jai Pandit	NaN	NaN	NaN	Jai	NaN	NaT	PANDIT, JAI	Pandit	2014-04-16 16:59:53.000	NaN	NaN	True	N	2007-10-17 18:12:31	M	NaN	NaN	NaT	DEMO	2017-12-31	106	NaN	NaN	NaN	NaN	NaN	WV	NaN	A	NaN	NaN	NaN	BSCHRADER	NaN	NaN	(304) 555-1602	25840-1404
5	NaN	NaT	NaN	1	NaN	Dallas	159.0	CM	Acme, Inc.	False	ACME, INC.	United States	NaN	NaN	1992-08-22 00:00:00.000	CPA	NaN	75201CALLP	paulacaller@imisdemo.com	False	False	NaN	Paula	1700 Atlantic Avenue-Dallas, TX 75201-4620-UN...	Ms. Paula D. Caller, CPA	NaN	F	(214) 749-9849	Paula	08210011:24:47.00	1990-04-01	CALLER, PAULA	Caller	2014-07-15 16:35:05.490	NaN	NaN	True	R	1998-02-04 00:00:00	M	D.	NaN	1994-12-04 00:00:00.000	ORG1	2001-03-30	107	Ms.	M	NaN	NaN	NaN	TX	NaN	A	NaN	Controller	NaN	BRIANM	NaN	NaN	(214) 987-8765	75201-4620
6	NaN	NaT	NaN	1	NaN	Dallas	159.0	CM	Acme, Inc.	False	ACME, INC.	United States	NaN	NaN	1992-08-10 00:00:00.000	NaN	NaN	75201COOKD	NaN	False	False	NaN	David	1700 Atlantic Avenue-Dallas, TX 75201-4620-UN...	Mr. David F. Cooke, Jr.	NaN	M	(214) 659-7763	Dave	11239916:04:36.00	1990-06-01	COOKE, DAVID	Cooke	2014-07-15 16:35:05.490	NaN	NaN	True	R	1998-04-01 00:00:00	M	F.	NaN	1994-12-04 00:00:00.000	ORG1	2001-05-28	108	Mr.	NM	NaN	NaN	NaN	TX	NaN	A	Jr.	Vice President	NaN	BRIANM	NaN	NaN	(214) 987-8765	75201-4620
7	NaN	NaT	NaN	1	NaN	Deakin	NaN	NaN	Office Supplies, Inc.	True	OFFICE SUPPLIES, INC.	Australia	NaN	NaN	1992-08-10 00:00:00.000	NaN	NaN	2600TREEJ	NaN	False	False	NaN	John	61 Napier Close-Deakin, ACT 2600-AUSTRALIA	Mr. John G. Tree, Sr.	NaN	M	(214) 727-5523	John	11239916:16:21.00	1983-05-01	TREE, JOHN	Tree	2014-07-15 16:35:05.490	NaN	NaN	True	R	1998-04-20 00:00:00	CM	G.	NaN	2014-10-15 16:35:05.490	ORG1	2001-04-30	109	Mr.	A	NaN	NaN	NaN	ACT	NaN	A	Sr.	Sales Manager	NaN	BRIANM	NaN	NaN	(028) 893-2326	2600
8	NaN	1941-07-04	NaN	1	NaN	Dallas	NaN	NaN	Sailing Dreams, Inc.	True	SAILING DREAMS, INC.	United States	NaN	NaN	1992-08-15 00:00:00.000	NaN	NaN	75208COURW	NaN	False	False	(214) 222-1115	Wayne	205 W. Commerce-Dallas, TX 75208-UNITED STATES	Mr. Wayne Courtland	NaN	M	(214) 675-8988	Wayne	11239917:14:06.00	1974-08-15	COURTLAND, WAYNE	Courtland	2014-07-15 16:35:05.490	NaN	NaN	True	R	1998-03-01 00:00:00	CM	NaN	NaN	NaT	ORG1	2001-03-30	110	Mr.	NaN	NaN	NaN	NaN	TX	NaN	A	NaN	President	NaN	BRIANM	NaN	NaN	(214) 445-6734	75208
9	/7520687654/	NaT	NaN	NaN	NaN	Dallas	110.0	CM	Sailing Dreams, Inc.	False	SAILING DREAMS, INC.	NaN	NaN	NaN	1992-08-10 00:00:00.000	NaN	NaN	75206HARRR	NaN	False	False	(214) 222-1115	Richard	P.O. Box 8765-Dallas, TX 75206-8765	Mr. Richard B. Harris	NaN	M	(214) 233-7676	Dick	11239916:09:22.00	1990-07-01	HARRIS, RICHARD	Harris	2001-02-23 16:09:00.000	NaN	NaN	True	R	1998-07-15 00:00:00	M	B.	NaN	1994-12-04 00:00:00.000	ORG1	2001-12-30	111	Mr.	NM	NaN	NaN	NaN	TX	NaN	A	NaN	Administrative Manager	NaN	MANAGER	NaN	NaN	(214) 445-6734, Ext. 20	75206-8765

Last rows

	BAR_CODE	BIRTH_DATE	BT_ID	CATEGORY	CHAPTER	CITY	CO_ID	CO_MEMBER_TYPE	COMPANY	COMPANY_RECORD	COMPANY_SORT	COUNTRY	COUNTY	CRRT	DATE_ADDED	DESIGNATION	DISPLAY_CURRENCY	DUP_MATCH_KEY	EMAIL	EXCLUDE_DIRECTORY	EXCLUDE_MAIL	FAX	FIRST_NAME	FULL_ADDRESS	FULL_NAME	FUNCTIONAL_TITLE	GENDER	HOME_PHONE	INFORMAL	INTENT_TO_EDIT	JOIN_DATE	LAST_FIRST	LAST_NAME	LAST_UPDATED	MAIL_CODE	MAJOR_KEY	MEMBER_RECORD	MEMBER_STATUS	MEMBER_STATUS_DATE	MEMBER_TYPE	MIDDLE_NAME	MOBILE_PHONE	MT_CHANGE_DATE	ORG_CODE	PAID_THRU	PartyId	PREFIX	PREVIOUS_MT	SIC_CODE	SOURCE_CODE	STATE_HOUSE	STATE_PROVINCE	STATE_SENATE	STATUS	SUFFIX	TITLE	TOLL_FREE	UPDATED_BY	US_CONGRESS	WEBSITE	WORK_PHONE	ZIP
5445	NaN	NaT	NaN	NaN	SOUTH	Southampton	18149.0	CM	Glover International	False	GLOVER INTERNATIONAL	United Kingdom	NaN	NaN	2009-11-25 00:00:00.000	NaN	NaN	SO30 STAFT	NaN	False	False	NaN	Tessa	Botley Mills-Botley-SOUTHAMPTON-SO30 2GB-UNITE...	Tessa Stafford	NaN	NaN	NaN	Tessa	NaN	NaT	STAFFORD, TESSA	Stafford	2014-07-25 15:22:20.720	NaN	NaN	True	N	2009-11-25	M	NaN	NaN	NaT	DEMO	2017-12-31	254	NaN	NaN	NaN	NaN	NaN	NaN	NaN	A	NaN	NaN	NaN	BRIANM	NaN	NaN	44-1489-885 000	SO30 2GB
5446	NaN	NaT	NaN	NaN	WEST	Paris	18077.0	CM	Opus Europe	False	OPUS EUROPE	France	NaN	NaN	2010-01-10 00:00:00.000	NaN	NaN	3499COWLD	NaN	False	False	NaN	David	1322 Champs lys es-3499 PARIS-FRANCE	David Cowlings	NaN	NaN	NaN	Dave	NaN	NaT	COWLINGS, DAVID	Cowlings	2014-07-25 15:22:20.720	NaN	NaN	True	N	2010-01-10	M	NaN	NaN	NaT	DEMO	2017-12-31	255	NaN	NaN	NaN	NaN	NaN	NaN	NaN	A	NaN	NaN	NaN	BRIANM	NaN	NaN	011.33.49.22.22.22	3499
5447	NaN	NaT	NaN	NaN	NaN	Ripley	19797.0	CM	Accessible Solutions Consulting	False	ACCESSIBLE SOLUTIONS CONSULTIN	United States	NaN	NaN	2010-02-10 00:00:00.000	NaN	NaN	ROMAJ	jromansen@imisdemo.com	False	False	NaN	John	2050 California Dr-Ripley, WV 25271-UNITED ST...	John Romansen	NaN	NaN	NaN	John	NaN	NaT	ROMANSEN, JOHN	Romansen	2014-07-25 15:22:20.720	NaN	NaN	True	N	2010-02-10	M	NaN	NaN	NaT	DEMO	2017-12-31	256	NaN	NaN	NaN	NaN	NaN	WV	NaN	A	NaN	NaN	NaN	BRIANM	NaN	NaN	(214) 987-8765	25271
5448	NaN	NaT	NaN	NaN	NaN	Austin	229.0	CM	Creative Distractions	False	CREATIVE DISTRACTIONS	United States	NaN	NaN	2010-03-09 00:00:00.000	NaN	NaN	78759ACEVF	francisacevedo@imisdemo.com	False	False	NaN	Francis	11044 Research Blvd.-Building B, Suite 300-Aus...	Francis Acevedo	NaN	NaN	NaN	Francis	NaN	NaT	ACEVEDO, FRANCIS	Acevedo	2014-11-03 15:17:24.343	NaN	NaN	True	N	2010-03-09	M	NaN	NaN	NaT	DEMO	2017-12-31	257	NaN	NaN	NaN	NaN	NaN	TX	NaN	A	NaN	Sr, Supervisor	NaN	BRIANM	NaN	NaN	NaN	78759
5449	NaN	NaT	NaN	NaN	NaN	Austin	229.0	CM	Creative Distractions	False	CREATIVE DISTRACTIONS	United States	NaN	NaN	2010-03-09 00:00:00.000	NaN	NaN	78759MARTM	mmoreno@imisdemo.com	False	False	NaN	Mario	11044 Research Blvd.-Building B, Suite 300-Aus...	Mario Martinez	NaN	NaN	NaN	Mario	NaN	NaT	MARTINEZ, MARIO	Martinez	2014-01-29 09:57:07.547	NaN	NaN	True	N	2010-03-09	M	NaN	NaN	NaT	DEMO	2017-12-31	258	NaN	NaN	NaN	NaN	NaN	TX	NaN	A	NaN	NaN	NaN	BRIANM	NaN	NaN	NaN	78759
5450	NaN	NaT	NaN	NaN	NaN	Austin	229.0	CM	Creative Distractions	False	CREATIVE DISTRACTIONS	United States	NaN	NaN	2010-03-09 00:00:00.000	NaN	NaN	78759BENAJ	jbianchi@imisdemo.com	False	False	NaN	Juan	11044 Research Blvd.-Building B, Suite 300-Aus...	Juan Benavides	NaN	NaN	NaN	Juan	NaN	NaT	BENAVIDES, JUAN	Benavides	2014-01-29 09:57:07.547	NaN	NaN	True	N	2010-03-09	M	NaN	NaN	NaT	DEMO	2017-12-31	259	NaN	NaN	NaN	NaN	NaN	TX	NaN	A	NaN	NaN	NaN	BRIANM	NaN	NaN	NaN	78759
5451	NaN	NaT	NaN	NaN	NaN	Hobart	18996.0	NMC	YHA Industries	False	YHA INDUSTRIES	Australia	NaN	NaN	2010-10-24 00:00:00.000	NaN	NaN	7000BAUGJ	NaN	False	False	NaN	Jerry	51 Macquarie Street-Hobart, TAS 7000-AUSTRALIA	Jerry Baugh	NaN	NaN	NaN	Jerry	NaN	NaT	BAUGH, JERRY	Baugh	2014-07-25 15:22:20.720	NaN	NaN	True	D	2014-12-17	M	NaN	NaN	NaT	DEMO	2017-12-31	260	NaN	NaN	NaN	NaN	NaN	TAS	NaN	D	NaN	NaN	NaN	BRIANM	NaN	NaN	(038) 664-0921	7000
5452	NaN	NaT	261.0	NaN	SOUTH	Brussels	18147.0	CM	Hardwick & Connolly	False	HARDWICK & CONNOLLY	Belgium	NaN	NaN	2011-01-13 13:27:27.107	NaN	NaN	13 11GANTL	lgorman@imisdemo.com	False	False	NaN	Leisal	333 First St-Building C-13 1140 BRUSSELS-BELGIUM	Leisal Gant, III	NaN	NaN	5551212	Leisal	NaN	NaT	GANT, LEISAL	Gant	2013-12-17 16:27:15.000	NaN	123456.0	True	N	2011-06-17	M	NaN	NaN	2011-06-17 10:00:39.593	DEMO	2017-12-31	261	NaN	NM	NaN	NaN	NaN	NaN	NaN	A	III	NaN	NaN	BSCHRADER	NaN	NaN	NaN	13 1140
5453	NaN	NaT	NaN	NaN	NaN	Eden Prairie	18013.0	CM	iMIS International	False	IMIS INTERNATIONAL	United States	NaN	NaN	2011-04-08 05:36:11.790	NaN	NaN	55347BOURB	bbrett@imisdemo.com	False	False	NaN	Bernard	8910 Sylvan Rdg-Eden Prairie, MN 55347-3336-U...	Bernard Bourdain	NaN	NaN	NaN	Bernard	NaN	NaT	BOURDAIN, BERNARD	Bourdain	2014-02-16 14:20:51.423	NaN	NaN	True	N	2011-04-08	M	NaN	NaN	NaT	DEMO	2017-12-31	262	NaN	NaN	NaN	NaN	NaN	MN	NaN	A	NaN	NaN	NaN	BSCHRADER	NaN	NaN	(516) 987-2222	55347-3336
5454	NaN	NaT	NaN	NaN	NaN	Eden Prairie	18013.0	CM	iMIS International	False	IMIS INTERNATIONAL	United States	NaN	NaN	2011-04-08 05:44:02.290	NaN	NaN	55347BESIP	pbelenkin@imisdemo.com	False	False	NaN	Phil	8910 Sylvan Rdg-Eden Prairie, MN 55347-3336-U...	Phil Besinger	NaN	NaN	NaN	NaN	NaN	NaT	BESINGER, PHIL	Besinger	2014-02-16 14:20:51.423	NaN	NaN	True	N	2011-04-08	M	NaN	NaN	NaT	DEMO	2017-12-31	263	NaN	NaN	NaN	NaN	NaN	MN	NaN	A	NaN	NaN	NaN	BSCHRADER	NaN	NaN	(516) 987-2222	55347-3336

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows