Prosper dataset

From TrustLet, a free, collaborative project for collecting and analyzing information about trust metrics.

Jump to: navigation, search

Description of the dataset of Prosper

[edit] File .xsd Data Schema 


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

<!-- Prosper Data Export - Schema - Version: 1.0 - Generated: 2007-06-22T02:34:00 -->

<!-- Subject to the Prosper API Services Terms of Use Agreement located at http://www.prosper.com/tools/APITermsOfUse.aspx -->

<!-- Note: The sql namespace (urn:schemas-microsoft-com:xml-sql) is optional and can be removed along with its references (sql:*) -->

<xsd:schema id="ProsperDataExportSchema" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema">

  <xsd:element name="ProsperDataExport" sql:is-constant="1">

    <xsd:complexType>

      <xsd:sequence>

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

          <xsd:complexType>

            <xsd:sequence>

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

                <xsd:complexType>

                  <xsd:sequence>

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

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

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

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

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

                    <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>




[edit] First lines of XML file 



<?xml version="1.0" encoding="utf-8"?>
<!-- Prosper Data Export - Data - Version: 1.0 - Generated: 2007-06-22T02:34:00 -->
<!-- Subject to the Prosper API Services Terms of Use Agreement located at http://www.prosper.com/tools/APITermsOfUse.aspx -->
<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)

Retrieved from "http://www.trustlet.org/wiki/Prosper_dataset"
Personal tools