Prosper dataset

Description of the dataset of Prosper

= File .xsd Data Schema =

































<xsd:element name="MemberKey" type="xsd:string" />

<xsd:element name="MinimumRate" type="xsd:decimal" />

<xsd:element name="ParticipationAmount" type="xsd:decimal" />

<xsd:element name="Status" type="xsd:string" />

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:element name="Categories" minOccurs="0" maxOccurs="1" sql:is-constant="1">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Category" minOccurs="0" maxOccurs="unbounded" sql:relation="[Category]">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CategoryKey" type="xsd:string" />

<xsd:element name="CategoryLevel" type="xsd:integer" />

<xsd:element name="Hierarchy" type="xsd:string" />

<xsd:element name="Key" type="xsd:string" />

<xsd:element name="Name" type="xsd:string" />

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:element name="Groups" minOccurs="0" maxOccurs="1" sql:is-constant="1">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Group" minOccurs="0" maxOccurs="unbounded" sql:relation="[Group]">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="ApprovalDate" type="xsd:dateTime" sql:datatype="dateTime" />

<xsd:element name="CategoryKeys" type="xsd:string" />

<xsd:element name="City" type="xsd:string" />

<xsd:element name="CreationDate" type="xsd:dateTime" sql:datatype="dateTime" />

<xsd:element name="Description" type="xsd:string" />

<xsd:element name="GroupLeaderRewardPercentageOfBase" type="xsd:decimal" />

<xsd:element name="GroupRating" type="xsd:string" />

<xsd:element name="Images" type="xsd:string" />

<xsd:element name="IsAcceptingNewMembers" type="xsd:boolean" />

<xsd:element name="Key" type="xsd:string" />

<xsd:element name="Links" type="xsd:string" />

<xsd:element name="ListingReviewRequirement" type="xsd:string" />

<xsd:element name="MemberKey" type="xsd:string" />

<xsd:element name="Name" type="xsd:string" />

<xsd:element name="ShortDescription" type="xsd:string" />

<xsd:element name="ShortName" type="xsd:string" />

<xsd:element name="State" type="xsd:string" />

<xsd:element name="Status" type="xsd:string" />

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:element name="Listings" minOccurs="0" maxOccurs="1" sql:is-constant="1">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Listing" minOccurs="0" maxOccurs="unbounded" sql:relation="[Listing]">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="AmountFunded" type="xsd:decimal" />

<xsd:element name="AmountRemaining" type="xsd:decimal" />

<xsd:element name="AmountRequested" type="xsd:decimal" />

<xsd:element name="BankDraftFeeAnnualRate" type="xsd:decimal" />

<xsd:element name="BidCount" type="xsd:integer" />

<xsd:element name="BidMaximumRate" type="xsd:decimal" />

<xsd:element name="BorrowerCity" type="xsd:string" />

<xsd:element name="BorrowerMaximumRate" type="xsd:decimal" />

<xsd:element name="BorrowerRate" type="xsd:decimal" />

<xsd:element name="BorrowerState" type="xsd:string" />

<xsd:element name="CreationDate" type="xsd:dateTime" sql:datatype="dateTime" />

<xsd:element name="CreditGrade" type="xsd:string" />

<xsd:element name="DebtToIncomeRatio" type="xsd:decimal" />

<xsd:element name="Description" type="xsd:string" />

<xsd:element name="Duration" type="xsd:integer" />

<xsd:element name="EndDate" type="xsd:dateTime" sql:datatype="dateTime" />

<xsd:element name="FundingOption" type="xsd:string" />

<xsd:element name="GroupKey" type="xsd:string" />

<xsd:element name="GroupLeaderRewardRate" type="xsd:decimal" />

<xsd:element name="HasVerifiedBankAccount" type="xsd:boolean" />

<xsd:element name="Images" type="xsd:string" />

<xsd:element name="IsBorrowerHomeowner" type="xsd:boolean" />

<xsd:element name="Key" type="xsd:string" />

<xsd:element name="LenderRate" type="xsd:decimal" />

<xsd:element name="ListingNumber" type="xsd:integer" />

<xsd:element name="MemberKey" type="xsd:string" />

<xsd:element name="PercentFunded" type="xsd:decimal" />

<xsd:element name="StartDate" type="xsd:dateTime" sql:datatype="dateTime" />

<xsd:element name="Status" type="xsd:string" />

<xsd:element name="Title" type="xsd:string" />

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:element name="Loans" minOccurs="0" maxOccurs="1" sql:is-constant="1">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Loan" minOccurs="0" maxOccurs="unbounded" sql:relation="[Loan]">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="AgeInMonths" type="xsd:integer" />

<xsd:element name="AmountBorrowed" type="xsd:decimal" />

<xsd:element name="BorrowerRate" type="xsd:decimal" />

<xsd:element name="CreationDate" type="xsd:dateTime" sql:datatype="dateTime" />

<xsd:element name="CreditGrade" type="xsd:string" />

<xsd:element name="DebtToIncomeRatio" type="xsd:decimal" />

<xsd:element name="GroupKey" type="xsd:string" />

<xsd:element name="Key" type="xsd:string" />

<xsd:element name="LenderRate" type="xsd:decimal" />

<xsd:element name="OriginationDate" type="xsd:dateTime" sql:datatype="dateTime" />

<xsd:element name="Status" type="xsd:string" />

<xsd:element name="Term" type="xsd:integer" />

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:element name="Marketplaces" minOccurs="0" maxOccurs="1" sql:is-constant="1">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Marketplace" minOccurs="0" maxOccurs="unbounded" sql:relation="[Marketplace]">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="CreationDate" type="xsd:dateTime" sql:datatype="dateTime" />

<xsd:element name="GroupsCountToDate" type="xsd:integer" />

<xsd:element name="HistoricalInterestRatesTable" type="xsd:string" />

<xsd:element name="LoansClosedCountToDate" type="xsd:integer" />

<xsd:element name="MemberBorrowersCountToDate" type="xsd:integer" />

<xsd:element name="MemberGroupLeadersCountToDate" type="xsd:integer" />

<xsd:element name="MemberLendersCountToDate" type="xsd:integer" />

<xsd:element name="MemberRegistrationsCountToDate" type="xsd:integer" />

<xsd:element name="PrincipalClosedAmountToDate" type="xsd:decimal" />

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

<xsd:element name="Members" minOccurs="0" maxOccurs="1" sql:is-constant="1">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="Member" minOccurs="0" maxOccurs="unbounded" sql:relation="[Member]">

<xsd:complexType>

<xsd:sequence>

<xsd:element name="City" type="xsd:string" />

<xsd:element name="CreationDate" type="xsd:dateTime" sql:datatype="dateTime" />

<xsd:element name="Description" type="xsd:string" />

<xsd:element name="Endorsements" type="xsd:string" />

<xsd:element name="FriendMemberKeys" type="xsd:string" />

<xsd:element name="GroupKey" type="xsd:string" />

<xsd:element name="Images" type="xsd:string" />

<xsd:element name="Key" type="xsd:string" />

<xsd:element name="Roles" type="xsd:string" />

<xsd:element name="ScreenName" type="xsd:string" />

<xsd:element name="State" type="xsd:string" />

<xsd:element name="SupportedGroupKeys" type="xsd:string" />

<xsd:element name="WatchListingKeys" type="xsd:string" />

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:schema>

= First lines of XML file =

<?xml version="1.0" encoding="utf-8"?>

<ProsperDataExport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="ProsperDataExport.xsd"> <Bids> <Bid> <Amount>50.00</Amount> <CreationDate>2007-04-25T16:56:54</CreationDate> <Key>632D349207412431579C726</Key> <ListingKey>AA433388055457628526980</ListingKey> <ListingStatus>Withdrawn</ListingStatus> <MemberKey>D6B4336535479263558503C</MemberKey> <MinimumRate /> <ParticipationAmount>50.00</ParticipationAmount> <Status>Winning</Status> </Bid> <Bid> <Amount>100.00</Amount> <CreationDate>2007-04-25T17:00:45</CreationDate> <Key>4FDB3490611350636B515A3</Key> <ListingKey>AA433388055457628526980</ListingKey> <ListingStatus>Withdrawn</ListingStatus> <MemberKey>1EC63375371192792A25CAA</MemberKey> <MinimumRate /> <ParticipationAmount>100.00</ParticipationAmount> <Status>Winning</Status> </Bid> <Bid> <Amount>50.00</Amount> <CreationDate>2007-04-25T19:44:35</CreationDate> <Key>A4CD3490985033366AB260C</Key> <ListingKey>AA433388055457628526980</ListingKey> <ListingStatus>Withdrawn</ListingStatus> <MemberKey>1447338541991671634F78A</MemberKey> <MinimumRate /> <ParticipationAmount>50.00</ParticipationAmount> <Status>Winning</Status> </Bid> <Bid> (...) </Bid>

But probably the most interesting parts in the XML file are the Listings, the Loans, the MarketPlaces. However I was not able to arrive there because the text file is around 400 Megabytes, can you? --PaoloMassa 03:21, 16 July 2007 (PDT)