Prosper Data Export Definition - Details

Version: 1.2.5
Author: Prosper API Services - [email protected]
Date: 2008-10-25

Bid Object
Description: A Bid is created when a Lender wishes to lend money to a Borrower in response to a Listing the Borrower created to solicit Bids. Bids are created by specifying an Amount and a Minimum Rate in which the Lender wishes to receive should the Bid win the auction and become a Loan. The Minimum Rate remains private unless the Bid is Outbid by other Bids offering a lower Minimum Rate.
Name Label Type Description
Amount Amount decimal The amount that was bid.
CreationDate Creation Date datetime The date the bid was created.
Key Key string The primary key identifier for the Bid Object. All Bids have a unique Key.
ListingKey Listing Key string The Key of the Listing the Bid was placed on. See the Listing Object for more information.
ListingStatus Listing Status string The status of the Listing is one of the following values:
Active - The listing is current active in the marketplace
Withdrawn - The listing was withdrawn by customer request
Expired - The listing failed to fund in time
Completed - The listing ran to completion and funded
Cancelled - The listing was canceled by Prosper
Pending Verification - The listing ran to completion but is awaiting additional bank or identity verification
MemberKey Member Key string The Key of the Member who placed this bid. See the Member Object for more information.
MinimumRate Minimum Rate decimal This is the minimum rate that the Lender is willing to accept on their bid. This field is populated only if the bid Status is Outbid, otherwise it is Null. (As is currently exposed on the website).
ParticipationAmount Participation Amount decimal The amount of the Bid Amount that is winning and therefore participating in the bid.
Status Status string The status of the Bid is one of the following values:
Winning
Partially Participating
Outbid
Bid Withdrawn


Category Object
Description: A Category is collection of Groups which share a common interest or affiliation. Categories are created by the Prosper Team. Group Leaders can associate their Group with one or more categories as they relate to their group.
Name Label Type Description
CategoryKey Category Key string The Key of the Parent Category. Categories at the top of the Hierarchy (CategoryLevel = 1) don't have CategoryKeys.
CategoryLevel Category Level integer The level in the hierarchy of this Category. The hierarchy starts at level 1 and currently goes 4 levels deep, but may increase in the future.
Hierarchy Hierarchy string The "full path" or breadcrumb of the Hierarchy to this Category separated by "/". (For Example: Art and Culture/Craft/Candles)
Key Key string The primary key identifier for the Category Object. All Categories have a unique Key.
Name Name string The name of the Category


CreditProfile Object
Description: A CreditProfile is a timestamped set of extended credit information for a Member. Row level display and publication of CreditProfile is explicitly forbidden.
Name Label Type Description
AmountDelinquent Amount Delinquent decimal The monetary amount delinquent at the time the listing was created.
BankcardUtilization Bankcard Utilization decimal The percentage of available revolving credit that is utilized at the time the listing was created.
BorrowerOccupation Borrower Occupation string Occupation of the borrower at the time the listing was created.
CreationDate Creation Date datetime When this credit profile was created.
CreditGrade Credit Grade string Credit Grade of the borrower at the time the listing was created.
CurrentCreditLines Current Credit Lines int Number of current credit lines at the time the listing was created.
CurrentDelinquencies Current Delinquencies int Number of current delinquencies at the time the listing was created.
DatePulled Date Pulled datetime When this credit profile was pulled.
DelinquenciesLast7Years Delinquencies Last 7 Years int Number of delinquencies in the last 7 years at the time the listing was created.
EmploymentStatus Employment Status string Employment status of the borrower at the time the listing was created.
FirstRecordedLineOfCredit First Recorded Line Of Credit datetime Number of public records in the last 10 years at the time the listing was created.
Income Income int The income range of the borrower at the time the lisitng was created is one of the following values:
0 - Not displayed
1 - $0 or unable to verify
2 - $1-24,999
3 - $25,000-49,999
4 - $50,000-74,999
5 - $75,000-99,999
6 - $100,000+
7 - Not Employed
InquiresLast6Months Inquires Last 6 Months int Number of inquires in teh last 6 months at the time the listing was created.
LengthStatusMonths Length Status Months int The length in months of the employment status at the time the listing was created.
ListingKey ListingKey string The key of the Listing to which this CreditProfile belongs. Please refer to the Listing Object.
MemberKey Member Key string The Key of the member to whom this CreditProfile belongs. See the Member Object for more information.
OpenCreditLines Open Credit Lines int Number of open credit lines at the time the listing was created.
OpenRevolvingAccounts Open Revolving Accounts int Number of open revolving accounts at the time the listing was created.
PublicRecordsLast10Years Public Records Last 10 Years int Number of public records in the last 10 years at the time the listing was created.
PublicRecordsLast12Months Public Records Last 12 Months int Number of public records in the last 12 months at the time the listing was created.
RevolvingCreditBalance Revolving Credit Balance decimal The monetary amount of revolving credit balance at the time the listing was created.
StatedMonthlyIncome Stated Monthly Income decimal Stated monthly income at the time the listing was created.
TotalCreditLines Total Credit Lines int Number of total credit lines at the time the listing was created.


Group Object
Description: A Group is a collection of Members who share a common interest or affiliation. Groups are managed by Group Leaders who bring borrowers to Prosper, maintain the group's presence on the site, and collect and/or share Group Rewards. Borrowers who are members of a group often get better interest rates because Lenders tend to have more confidence in Borrowers that belong to trusted Groups.
Name Label Type Description
ApprovalDate Approval Date datetime The date the group was approved.
CategoryKeys Category Keys string The comma separated string of Category Keys to which this Group is associated.
City City string The city of the location of the group.
CreationDate Creation Date datetime The date the group was created.
Description Description string The description that the group leader provides about this group.
GroupLeaderRewardPercentageOfBase Group Leader Reward Percentage Of Base decimal The percentage of the base reward which is kept by the Group Leader.
GroupRating Group Rating string The Group Rating of a Group following values:
Not yet Rated
1 Star
2 Stars
3 Stars
4 Stars
5 Stars
Images Images xml These are the captions and URLs to the images that Group Leader has uploaded to describe the Group. These are stored as Name/Value Pairs in XML.
IsAcceptingNewMembers Is Accepting New Members boolean Specifies whether or not the group is accepting new members to join the group.
Key Key string The primary key identifier for the Group Object. All Groups have a unique Key.
Links Links xml These are the Names and URLs that the Group Leader has linked with this group. These are stored as Name/Value Pairs in XML
ListingReviewRequirement Listing Review Requirement string The Listing Review Requirement of the Group is one of the following values:
Required - A listing is subject to review by the Group Leader before going live.
Not Required - A listing is not subject to review by the Group Leader before going live.
MemberKey Member Key string The Key of the member who is the Group Leader of this Group. See the Member Object for more information.
Name Name string The name of the group.
ShortDescription Short Description string The short description that the group leader provides about this group.
ShortName Short Name string The short name of the group.
State State string The two letter abbreviation of the state (in the United States, or military state) of the address of the location of the group.
Status Status string The status of the Group is one of the following values:
Pending Approval
Approved
Denied
On Hold


Listing Object
Description: A Listing is created by a Borrower to solicit bids by describing themselves and the reason they are looking to borrow money. If the Listing receives enough bids by Lenders to reach the Amount Requested then after the Listing period ends it will become a Loan. A Borrower may only have one active listing at a particular moment in time.
Name Label Type Description
ActiveProsperLoans Active Prosper Loans integer Total number of active Prosper loans at the time of listing creation.
AmountFunded Amount Funded decimal The monetary amount of the listing which has been funded.
AmountRemaining Amount Remaining decimal The monetary amount of the listing which still remains to be funded.
AmountRequested Amount Requested decimal The amount that the member requested to borrow in the listing.
AvailableBankcardCredit Available Bankcard Credit decimal Total available credit via bank card.
BankDraftFeeAnnualRate Bank Draft Fee Annual Rate decimal The rate charged by the Bank when they Payment Option selected is not Electronic Funds Transfer
BidCount Bid Count integer The total number of Bids on this listing.
BidMaximumRate Maximum Rate To Bid decimal The Maximum Rate in which a bidder will be able to lend money in order to create a winning bid. This rate is less than or equal to Current Rate based on market conditions.
BorrowerCity Borrower City string The city of the address of the borrower at the time the listing was created.
BorrowerMaximumRate Maximum Rate decimal The Maximum interest rate the borrower is willing to pay when the listing was created.
BorrowerRate Borrower Rate decimal The is the rate the borrower pays if the loan were to close at this point in time. The rate is computed as the LenderRate + GroupLeaderRewardRate (if applicable) + BankDraftFeeAnnualRate (if applicable).
BorrowerState Borrower State string The two letter abbreviation of the state (in the United States, or military state) of the address of the borrower at the time the Listing was created.
Category Category integer The Category of this Listing. The Category is one of the following numerical values:
0 Not available
1 Debt consolidation
2 Home improvement
3 Business
4 Personal loan
5 Student use
6 Auto
7 Other
8 Baby & Adoption Loans
9 Boat
10 Cosmetic Procedures
11 Engagement Ring Financing
12 Green Loans
13 Household Expenses
14 Large Purchases
15 Medical/Dental
16 Motorcycle
17 RV
18 Taxes
19 Vacation
20 Wedding Loans
CreationDate Creation Date datetime The date the listing was created.
CreditGrade Credit Grade string Credit Grade of the borrower at the time the listing was created.
CreditScoreRangeLower Credit Score Range Lower Bound integer The lower value representing the range of the borrower’s credit score as provided by a consumer credit rating agency in a recent credit inquiry.
CreditScoreRangeUpper Credit Score Range Upper Bound integer The upper value representing the range of the borrower’s credit score as provided by a consumer credit rating agency in a recent credit inquiry.
DebtToIncomeRatio Debt to Income Ratio decimal The debt to income ratio of the borrower at the time the listing was created. This value is null if the debt to income ratio is not available. This value is capped at 10.01 (so any actual debt to income ratio larger than 1000% will be returned as 1001%).
Description Description string The description about the Listing that the Member writes when creating the Listing.
Duration Duration integer The number of days in which the listing is valid for.
EffectiveYield Effective Yield decimal Effective yield is equal to the borrower interest rate: (i) minus the servicing fee rate, (ii) minus estimated uncollected interest on charge-offs, (iii) plus estimated collected late fees.
EndDate End Date datetime The date when the listing ends
EstimatedLoss Estimated Loss decimal Estimated annualized loss rate on the loan.
EstimatedReturn Estimated Return decimal Estimated annualized return on the loan.
FundingOption Funding Option string The Funding Options is one of the following values:
Open For Duration - The listing is open for it's duration.
Close When Funded - The listing will close as soon as it is funded 100%.
GroupKey Group Key string The Key of the Group in which the member is a member of. See the Group Object for more details.
GroupLeaderRewardRate Group Leader Reward Rate decimal The portion of the Borrower Rate which will be paid to the Group Leader.
HasVerifiedBankAccount Has Verified Bank Account boolean Specifies whether or not the member has a verified Bank Account at the time the listing was created. DEPRECATED -- this field may be removed in the future and always has the value true in the current release.
Images Images xml These are the captions and URLs to the images that Member has uploaded to describe the listing. These are stored as Name/Value Pairs in XML.
IsBorrowerHomeowner Is Borrower a Homeowner boolean Specifies whether or not the member has is a verified Homeowner at the time the listing was created.
Key Key string The primary key identifier for the Listing Object. All Listings have a unique Key.
LenderRate Lender Rate decimal The rate that lenders would receive on the listing if the loan were to close at this point in time.
LenderYield Lender Yield decimal The interest rate the lender receives on the loan.
ListingNumber Listing Number integer The number that uniquely identifies the listing to the public as displayed on the website.
MemberKey Member Key string The Key of the member who creating the Listing. See the Member Object for more information.
MonthlyLoanPayment Monthly Loan Payment decimal The monthly payment made by the borrower.
OnTimeProsperPayments Ontime Prosper Payments integer Number of Prosper payments paid on time.
PercentFunded Percent Funded decimal The percentage amount of the loan which has been funded. This can also be calculated as (Remaining / Amount)
ProsperPaymentsLessThanOneMonthLate Payments <31 days late integer Number of Prosper payments less than 31 days late.
ProsperPaymentsOneMonthPlusLate Prosper Payments One Month Plus Late integer Number of Prosper payments 31+ days late.
ProsperPrincipalBorrowed Prosper Principal Borrowed decimal Total principal borrowed from Prosper prior to listing creation.
ProsperPrincipalOutstanding Prosper Principal Outstanding decimal Prosper principal balance outstanding at the time of listing creation.
ProsperScore Prosper Score integer A custom risk score built using historical Prosper data. The score ranges from 1-10, with 10 being the best, or lowest risk score.
StartDate Start Date datetime The starting time of the Listing.
Status Status string The status of the Listing is one of the following values:
Active - The listing is current active in the marketplace
Withdrawn - The listing was withdrawn by customer request
Expired - The listing failed to fund in time
Completed - The listing ran to completion and funded
Cancelled - The listing was canceled by Prosper
Pending Verification - The listing ran to completion but is awaiting additional bank or identity verification
Term Term integer The length of the loan in months.
Title Title string The title of the Listing. The member assigns this text when creating the listing.
TotalInquiries Total Inquiries integer Total number of inquiries made.
TotalProsperLoans Total Prosper Loans integer Total number of Prosper loans prior to listing creation.
TotalProsperPaymentsBilled Total Prosper Payments Billed integer Total Prosper payments billed prior to listing creation.
TradesOpenedLast6Months Trades Opened Last 6 Months integer Total number of trades opened in the last 6 months.
TradesOpenedLast6Months Trades Opened Last 6 Months integer Total number of trades opened in the last 6 months.
TradesOpenedLast6Months Trades Opened Last 6 Months integer Total number of trades opened in the last 6 months.
VerificationStage VerificationStage integer A three-stage indicator of the process on the Prosper loan, based on Prosper’s verification of the borrower’s information and documents submitted that are key to evaluating the loan. The further along in verification, the higher the Verification Stage and the more likely the loan will originate.


Loan Object
Description: A Loan is created when a Borrower has received enough Bids to meet the full amount of money that the Borrower requested in their Listing. The Borrower must then make payments on the Loan to keep it's status current.
Name Label Type Description
AgeInMonths Age In Months integer The number of whole months since the origination date, starting with 0.
AmountBorrowed Amount Borrowed decimal The amount that was borrowed.
BorrowerRate Borrower Rate decimal The borrower rate for this loan.
CreationDate Creation Date datetime The date the Listing became a loan.
CreditGrade Credit Grade string Credit Grade of the borrower at the time the listing for this loan was created.
DebtToIncomeRatio Debt to Income Ratio decimal The debt to income ratio of the borrower at the time the listing for this loan was created. This value is null if the debt to income ratio is not available. This value is capped at 10.01 (so any actual debt to income ratio larger than 1000% will be returned as 1001%).
GroupKey Group Key string The Key of the Group to which this Loan belongs. Please refer to the Group Object.
Key Key string The primary key identifier for the Loan Object. All Loans have a unique Key.
LenderRate Lender Rate decimal The lender rate for this loan.
ListingKey ListingKey string The key of the Listing to which this Loan belongs. Please refer to the Listing Object.
OriginationDate Origination Date datetime The date that Borrower receives funds and amortization begins.
Status Status string The status of the Loan is one of the following values:
Origination delayed
Current
Late
1 month late
2 months late
3 months late
4+ months late
Payoff in progress
Paid
Charge-off
Defaulted (Delinquency)
Defaulted (Bankruptcy)
Defaulted (Deceased)
Repurchased
Cancelled
Term Term integer The length of the loan in months.


LoanPerformance Object
Description: A LoanPerformance is an event in a Loan History that causes a change in loan value. This table can be used to calculate roll rates. Row level display and publication of LoanPerformance is explicitly forbidden.
Name Label Type Description
CycleNumber Cycle Number int The payment cycle during which this event occured.
DPD Days Past Due int The days past due at the time of this event.
LoanKey Loan Key string The Key of the Loan.
NetDefaults NetDefaults decimal The net amount defaulted. Principal balance minus (loan sale proceeds and forfited group rewards)
ObservationDate Observation Date datetime The observation date3 of this event.
PrincipalBalance Principal Balance decimal The pricipal balance of the loan at teh time of the event.
Status Status string The loan status at the time of this event.


Marketplace Object
Description: The Marketplace is a collection of metrics and statistics about the Prosper Marketplace. These metrics are calculated daily. Historical metrics are provided as well.
Name Label Type Description
CreationDate Creation Date datetime The date that this Marketplace information was created.
GroupsCountToDate Groups Count To Date integer The total number of Groups to date.
HistoricalInterestRatesTable Historical Interest Rates Table xml This returns an xml table with the average interest rates by loan amount, credit grade, and group membership on loans already funded on Prosper.
LoansClosedCountToDate Loans Closed Count To Date integer The total number of loans closed to date.
MemberBorrowersCountToDate Member Borrowers Count To Date integer The total number of members registered as a Borrower to date.
MemberGroupLeadersCountToDate Member Group Leaders Count To Date integer The total number of members registered as a Group Leader to date.
MemberLendersCountToDate Member Lenders Count To Date integer The total number of members registered as a Lender to date.
MemberRegistrationsCountToDate Member Registrations Count To Date integer The total number of member registrations to date.
PrincipalClosedAmountToDate Principal Closed Amount To Date decimal The total amount of principal closed to date.


Member Object
Description: A Member is a registered user of the Prosper Marketplace site. A Member may have one or multiple roles which determines which actions the Member is allowed to perform on the site.
Name Label Type Description
City City string The city of the address of the Member. Note: if the Member has decided not to make this information public than it will be null.
CreationDate Creation Date datetime The date in which the Member registered on the system.
Description Description string The description that the Member provides about themselves.
Endorsements Endorsements xml These are the Testimonial, MemberKey and CreationDate of the various Endorsements given to the member. These are stored in XML format.
FriendMemberKeys Friend MemberKeys string The comma separated string of MemberKeys to which this member is a Friend.
GroupKey Group Key string The Key of the Group to which this Member belongs. You can get more details on this Group by referencing the Group Object.
Images Images xml These are the captions and URLs to the images that Member has uploaded to describe themselves. These are stored as Name/Value Pairs in XML.
Key Key string The primary key identifier for the Member Object. All Members have a unique Key.
Roles Roles string This is a comma separated string detailing the roles of the member. They may be none, some or all of the following:
Borrower
Lender
Group Leader
ScreenName Screen Name string The name in which the Member uses to identify themselves on the public website.
State State string The two letter abbreviation of the state (in the United States, or military state) of the address of the borrower at the time the Listing was created.
SupportedGroupKeys Supported Group Keys string The comma separated string of GroupKeys to which this member supports.
WatchListingKeys Watch ListingKeys string The comma separated string of ListingKeys to which this member is watching.