Freddie Mac's Dataset (pre-processed)

Optimized Mortgage Data: Freddie Mac's Pre-Processed Datase

@kaggle.nikunjhemani_freddie_macs_dataset_pre_processed

Table List

1 table(2.51 MB)

Prepared Dataset

@kaggle.nikunjhemani_freddie_macs_dataset_pre_processed.prepared_dataset

2.51 MB
148938 rows
36 columns

unnamed_0 Unnamed: 0	creditscore CreditScore	firsttimehomebuyer FirstTimeHomebuyer	msa MSA	mip MIP	units Units	occupancy Occupancy	ocltv OCLTV	dti DTI	origupb OrigUPB	ltv LTV	originterestrate OrigInterestRate	channel Channel	propertystate PropertyState	propertytype PropertyType	loanpurpose LoanPurpose	origloanterm OrigLoanTerm	numborrowers NumBorrowers	sellername SellerName	servicername ServicerName	everdelinquent EverDelinquent	monthsdelinquent MonthsDelinquent	monthsinrepayment MonthsInRepayment	firstpayment_year FirstPayment Year	firstpayment_month FirstPayment Month	parsed_firstpaymentdate Parsed FirstPaymentDate	maturity_year Maturity Year	maturity_month Maturity Month	parsed_maturitydate Parsed MaturityDate	ltv_range LTV Range	credit_range Credit Range	yearsinrepayment YearsInRepayment	repay_range Repay Range	isfirsttimehomebuyer IsFirstTimeHomebuyer	duration Duration
	670.5336708312466		16974	25	1	O	89	27	117000	89	6.75	T	Midwest	SF	P	360	2	FL	Major Banks			52	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)	High	Good	4.333333333333333	2	No	30
1	670.5336708312466		19740		1	O	73	17	109000	73	6.5	R	Others	SF	N	360	1	FT	Non-Bank Servicers			144	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)	High	Good	12	4	No	30
2	670.5336708312466		29940		1	O	75	16	88000	75	6.875	T	Others	SF	N	360	2	FL	Major Banks			67	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)	High	Good	5.583333333333333	2	No	30
3	670.5336708312466		31084		1	O	76	14	160000	76	6.875	R	West Coast	SF	N	360	2	GM	Major Banks			35	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)	High	Good	2.9166666666666665	1	No	30
4	670.5336708312466		35644		1	O	78	18	109000	78	7.125	R	Northeast	SF	N	360	2	GM	Major Banks			54	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)	High	Good	4.5	2	No	30
5	670.5336708312466		30660	25	1	O	89	40	207000	89	7.125	T	Others	SF	N	360	2	Ot	Other Servicers			42	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)	High	Good	3.5	1	No	30
6	670.5336708312466		30660	25	1	O	90	21	111000	90	6.875	T	Midwest	SF	P	360	1	RE	Other Servicers			44	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)	High	Good	3.6666666666666665	1	No	30
7	670.5336708312466		36740		1	O	72	20	97000	72	6.75	R	South	SF	N	360	1	NO	Major Banks	1	3	145	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)	High	Good	12.083333333333334	4	No	30
8	670.5336708312466	1	25540	30	1	O	95	38	55000	95	7	R	Northeast	SF	P	345	1	Ot	Other Servicers			64	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2027	10	Fri Oct 01 2027 00:00:00 GMT+0000 (Coordinated Universal Time)	High	Good	5.333333333333333	2	Yes	28
9	670.5336708312466	1	48620	30	1	O	95	27	35000	95	7.125	T	Others	SF	P	360	1	Ot	Major Banks	1	104	212	1999	1999-	Mon Feb 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	2029	1	Mon Jan 01 2029 00:00:00 GMT+0000 (Coordinated Universal Time)	High	Good	17.666666666666668	5	Yes	30


CREATE TABLE prepared_dataset (
  "unnamed_0" BIGINT,
  "creditscore" DOUBLE,
  "firsttimehomebuyer" BIGINT,
  "msa" BIGINT,
  "mip" BIGINT,
  "units" BIGINT,
  "occupancy" VARCHAR,
  "ocltv" BIGINT,
  "dti" DOUBLE,
  "origupb" BIGINT,
  "ltv" DOUBLE,
  "originterestrate" DOUBLE,
  "channel" VARCHAR,
  "ppm" BIGINT,
  "propertystate" VARCHAR,
  "propertytype" VARCHAR,
  "loanpurpose" VARCHAR,
  "origloanterm" DOUBLE,
  "numborrowers" BIGINT,
  "sellername" VARCHAR,
  "servicername" VARCHAR,
  "everdelinquent" DOUBLE,
  "monthsdelinquent" DOUBLE,
  "monthsinrepayment" DOUBLE,
  "firstpayment_year" BIGINT,
  "firstpayment_month" VARCHAR,
  "parsed_firstpaymentdate" TIMESTAMP,
  "maturity_year" BIGINT,
  "maturity_month" BIGINT,
  "parsed_maturitydate" TIMESTAMP,
  "ltv_range" VARCHAR,
  "credit_range" VARCHAR,
  "yearsinrepayment" DOUBLE,
  "repay_range" BIGINT,
  "isfirsttimehomebuyer" VARCHAR,
  "duration" BIGINT
);