Name: PPP_Statstics_ALL

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ID (type: esriFieldTypeInteger, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Zipcode (type: esriFieldTypeString, alias: Zipcode, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CD (type: esriFieldTypeString, alias: CD, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NAICS_Codes_Count_Total (type: esriFieldTypeInteger, alias: NAICS_Codes_Count_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Employees_99_or_less (type: esriFieldTypeString, alias: Employees_99_or_less, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Employees_100_to_999 (type: esriFieldTypeString, alias: Employees_100_to_999, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Loans_in_April_Total (type: esriFieldTypeInteger, alias: Loans_in_April_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Loans_in_May_Total (type: esriFieldTypeInteger, alias: Loans_in_May_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Loans_in_June_Total (type: esriFieldTypeInteger, alias: Loans_in_June_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Loans_in_July_Total (type: esriFieldTypeInteger, alias: Loans_in_July_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Loans_in_August_Total (type: esriFieldTypeInteger, alias: Loans_in_August_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Loans_Total (type: esriFieldTypeInteger, alias: Loans_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Loan_Aggregate_Low (type: esriFieldTypeInteger, alias: Loan_Aggregate_Low, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Loan_Aggregate_High (type: esriFieldTypeInteger, alias: Loan_Aggregate_High, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Loan_Aggregate_Average (type: esriFieldTypeInteger, alias: Loan_Aggregate_Average, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Top_Lender (type: esriFieldTypeString, alias: Top_Lender, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Top_Lender_Loans_Issued (type: esriFieldTypeInteger, alias: Top_Lender_Loans_Issued, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Jobs_Reported_Total (type: esriFieldTypeInteger, alias: Jobs_Reported_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cooperative (type: esriFieldTypeInteger, alias: Cooperative, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Corporation (type: esriFieldTypeInteger, alias: Corporation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Employee_Stock_Ownership_Plan_E (type: esriFieldTypeInteger, alias: Employee_Stock_Ownership_Plan(ESOP), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Independent_Contractors (type: esriFieldTypeInteger, alias: Independent_Contractors, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Limited__Liability_Company_LLC_ (type: esriFieldTypeInteger, alias: Limited _Liability_Company(LLC), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Limited_Liability_Partnership (type: esriFieldTypeInteger, alias: Limited_Liability_Partnership, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Non_Profit_Childcare_Center (type: esriFieldTypeInteger, alias: Non_Profit_Childcare_Center, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Non_Profit_Organization (type: esriFieldTypeInteger, alias: Non_Profit_Organization, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Loans_To_Non_Profits_Total (type: esriFieldTypeInteger, alias: Loans_To_Non_Profits_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Partnership (type: esriFieldTypeInteger, alias: Partnership, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Professional_Association (type: esriFieldTypeInteger, alias: Professional_Association, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Self_Employed_Individuals (type: esriFieldTypeInteger, alias: Self_Employed_Individuals, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sole_Proprietorship (type: esriFieldTypeInteger, alias: Sole_Proprietorship, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Subchapter_S_Corporation (type: esriFieldTypeInteger, alias: Subchapter_S_Corporation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Trust (type: esriFieldTypeInteger, alias: Trust, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Tenant_in_Common (type: esriFieldTypeInteger, alias: Tenant_in_Common, SQL Type: sqlTypeOther, nullable: true, editable: true)
• American_Indian_or_Alaska_Nativ (type: esriFieldTypeString, alias: American_Indian_or_Alaska_Native, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Asian_Female_Owned (type: esriFieldTypeInteger, alias: Asian_Female_Owned, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Asian_Male_Owned (type: esriFieldTypeInteger, alias: Asian_Male_Owned, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Asian_Unanswered (type: esriFieldTypeInteger, alias: Asian_Unanswered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Black_or_African_American_Femal (type: esriFieldTypeInteger, alias: Black_or_African_American_Female_Owned, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Black_or_African_American_Male_ (type: esriFieldTypeInteger, alias: Black_or_African_American_Male_Owned, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Black_or_African_American_Unans (type: esriFieldTypeInteger, alias: Black_or_African_American_Unanswered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hispanic_Female_Owned (type: esriFieldTypeInteger, alias: Hispanic_Female_Owned, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hispanic_Male_Owned (type: esriFieldTypeInteger, alias: Hispanic_Male_Owned, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hispanic_Unanswered (type: esriFieldTypeInteger, alias: Hispanic_Unanswered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• White_Female_Owned (type: esriFieldTypeInteger, alias: White_Female_Owned, SQL Type: sqlTypeOther, nullable: true, editable: true)
• White_Male_Owned (type: esriFieldTypeInteger, alias: White_Male_Owned, SQL Type: sqlTypeOther, nullable: true, editable: true)
• White_Unanswered (type: esriFieldTypeInteger, alias: White_Unanswered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• American_Indian_or_Alaska_Nat_1 (type: esriFieldTypeString, alias: American_Indian_or_Alaska_Native_Total, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Asian_Total (type: esriFieldTypeInteger, alias: Asian_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hispanic_Total (type: esriFieldTypeInteger, alias: Hispanic_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• White_Total (type: esriFieldTypeInteger, alias: White_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Black_or_African_American_Total (type: esriFieldTypeInteger, alias: Black_or_African_American_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Female_Owned (type: esriFieldTypeInteger, alias: Female_Owned, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Male_Owned (type: esriFieldTypeInteger, alias: Male_Owned, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Gender_Unanswered (type: esriFieldTypeInteger, alias: Gender_Unanswered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Gender_Only_Total (type: esriFieldTypeInteger, alias: Gender_Only_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Race_and_Gender_Total (type: esriFieldTypeInteger, alias: Race_and_Gender_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Veteran (type: esriFieldTypeInteger, alias: Veteran, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Non_Veteran (type: esriFieldTypeInteger, alias: Non_Veteran, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Veteran_Status_Unanswered (type: esriFieldTypeInteger, alias: Veteran_Status_Unanswered, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Veteran_Status_Only_Total (type: esriFieldTypeInteger, alias: Veteran_Status_Only_Total, SQL Type: sqlTypeOther, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/8/2020 11:49:01 PM

Schema Last Edit Date: 9/8/2020 11:49:01 PM

Data Last Edit Date: 9/8/2020 11:49:01 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat