Name: Assistance Prime Award Summaries

Display Field: awarding_agency_name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• assistance_award_unique_key ( type: esriFieldTypeString, alias: assistance_award_unique_key, length: 8000 )
• award_id_fain ( type: esriFieldTypeString, alias: award_id_fain, length: 8000 )
• award_id_uri ( type: esriFieldTypeString, alias: award_id_uri, length: 8000 )
• sai_number ( type: esriFieldTypeString, alias: sai_number, length: 8000 )
• disaster_emergency_fund_codes ( type: esriFieldTypeString, alias: disaster_emergency_fund_codes, length: 8000 )
• award_latest_action_date ( type: esriFieldTypeDate, alias: award_latest_action_date, length: 8 )
• award_latest_action_date_fiscal_year ( type: esriFieldTypeInteger, alias: award_latest_action_date_fiscal_year )
• total_obligated_amount ( type: esriFieldTypeDouble, alias: total_obligated_amount )
• total_non_federal_funding_amount ( type: esriFieldTypeDouble, alias: total_non_federal_funding_amount )
• total_funding_amount ( type: esriFieldTypeDouble, alias: total_funding_amount )
• total_face_value_of_loan ( type: esriFieldTypeDouble, alias: total_face_value_of_loan )
• total_loan_subsidy_cost ( type: esriFieldTypeDouble, alias: total_loan_subsidy_cost )
• award_base_action_date ( type: esriFieldTypeDate, alias: award_base_action_date, length: 8 )
• award_base_action_date_fiscal_year ( type: esriFieldTypeInteger, alias: award_base_action_date_fiscal_year )
• period_of_performance_start_date ( type: esriFieldTypeDate, alias: period_of_performance_start_date, length: 8 )
• period_of_performance_current_end_date ( type: esriFieldTypeDate, alias: period_of_performance_current_end_date, length: 8 )
• awarding_agency_code ( type: esriFieldTypeInteger, alias: awarding_agency_code )
• awarding_agency_name ( type: esriFieldTypeString, alias: awarding_agency_name, length: 8000 )
• awarding_sub_agency_code ( type: esriFieldTypeString, alias: awarding_sub_agency_code, length: 8000 )
• awarding_sub_agency_code_X ( type: esriFieldTypeDouble, alias: awarding_sub_agency_code_X )
• awarding_sub_agency_code_Y ( type: esriFieldTypeDouble, alias: awarding_sub_agency_code_Y )
• awarding_sub_agency_name ( type: esriFieldTypeString, alias: awarding_sub_agency_name, length: 8000 )
• awarding_office_code ( type: esriFieldTypeString, alias: awarding_office_code, length: 8000 )
• awarding_office_name ( type: esriFieldTypeString, alias: awarding_office_name, length: 8000 )
• funding_agency_code ( type: esriFieldTypeInteger, alias: funding_agency_code )
• funding_agency_name ( type: esriFieldTypeString, alias: funding_agency_name, length: 8000 )
• funding_sub_agency_code ( type: esriFieldTypeString, alias: funding_sub_agency_code, length: 8000 )
• funding_sub_agency_code_X ( type: esriFieldTypeDouble, alias: funding_sub_agency_code_X )
• funding_sub_agency_code_Y ( type: esriFieldTypeDouble, alias: funding_sub_agency_code_Y )
• funding_sub_agency_name ( type: esriFieldTypeString, alias: funding_sub_agency_name, length: 8000 )
• funding_office_code ( type: esriFieldTypeString, alias: funding_office_code, length: 8000 )
• funding_office_name ( type: esriFieldTypeString, alias: funding_office_name, length: 8000 )
• treasury_accounts_funding_this_award ( type: esriFieldTypeString, alias: treasury_accounts_funding_this_award, length: 8000 )
• federal_accounts_funding_this_award ( type: esriFieldTypeString, alias: federal_accounts_funding_this_award, length: 8000 )
• object_classes_funding_this_award ( type: esriFieldTypeString, alias: object_classes_funding_this_award, length: 8000 )
• program_activities_funding_this_award ( type: esriFieldTypeString, alias: program_activities_funding_this_award, length: 8000 )
• recipient_uei ( type: esriFieldTypeString, alias: recipient_uei, length: 8000 )
• recipient_duns ( type: esriFieldTypeInteger, alias: recipient_duns )
• recipient_name ( type: esriFieldTypeString, alias: recipient_name, length: 8000 )
• recipient_parent_uei ( type: esriFieldTypeString, alias: recipient_parent_uei, length: 8000 )
• recipient_parent_duns ( type: esriFieldTypeInteger, alias: recipient_parent_duns )
• recipient_parent_name ( type: esriFieldTypeString, alias: recipient_parent_name, length: 8000 )
• recipient_country_code ( type: esriFieldTypeString, alias: recipient_country_code, length: 8000 )
• recipient_country_name ( type: esriFieldTypeString, alias: recipient_country_name, length: 8000 )
• recipient_address_line_1 ( type: esriFieldTypeString, alias: recipient_address_line_1, length: 8000 )
• recipient_address_line_2 ( type: esriFieldTypeString, alias: recipient_address_line_2, length: 8000 )
• recipient_city_code ( type: esriFieldTypeInteger, alias: recipient_city_code )
• recipient_city_name ( type: esriFieldTypeString, alias: recipient_city_name, length: 8000 )
• recipient_county_name ( type: esriFieldTypeString, alias: recipient_county_name, length: 8000 )
• recipient_state_code ( type: esriFieldTypeString, alias: recipient_state_code, length: 8000 )
• recipient_state_name ( type: esriFieldTypeString, alias: recipient_state_name, length: 8000 )
• recipient_zip_code ( type: esriFieldTypeInteger, alias: recipient_zip_code )
• recipient_zip_last_4_code ( type: esriFieldTypeInteger, alias: recipient_zip_last_4_code )
• recipient_foreign_city_name ( type: esriFieldTypeString, alias: recipient_foreign_city_name, length: 8000 )
• recipient_foreign_province_name ( type: esriFieldTypeString, alias: recipient_foreign_province_name, length: 8000 )
• recipient_foreign_postal_code ( type: esriFieldTypeString, alias: recipient_foreign_postal_code, length: 8000 )
• primary_place_of_performance_scope ( type: esriFieldTypeString, alias: primary_place_of_performance_scope, length: 8000 )
• primary_place_of_performance_country_code ( type: esriFieldTypeString, alias: primary_place_of_performance_country_code, length: 8000 )
• primary_place_of_performance_country_name ( type: esriFieldTypeString, alias: primary_place_of_performance_country_name, length: 8000 )
• primary_place_of_performance_code ( type: esriFieldTypeString, alias: primary_place_of_performance_code, length: 8000 )
• primary_place_of_performance_city_name ( type: esriFieldTypeString, alias: primary_place_of_performance_city_name, length: 8000 )
• primary_place_of_performance_county_name ( type: esriFieldTypeString, alias: primary_place_of_performance_county_name, length: 8000 )
• primary_place_of_performance_state_name ( type: esriFieldTypeString, alias: primary_place_of_performance_state_name, length: 8000 )
• primary_place_of_performance_zip_4 ( type: esriFieldTypeString, alias: primary_place_of_performance_zip_4, length: 8000 )
• primary_place_of_performance_foreign_location ( type: esriFieldTypeString, alias: primary_place_of_performance_foreign_location, length: 8000 )
• cfda_numbers_and_titles ( type: esriFieldTypeString, alias: cfda_numbers_and_titles, length: 8000 )
• assistance_type_code ( type: esriFieldTypeInteger, alias: assistance_type_code )
• assistance_type_description ( type: esriFieldTypeString, alias: assistance_type_description, length: 8000 )
• business_funds_indicator_code ( type: esriFieldTypeString, alias: business_funds_indicator_code, length: 8000 )
• business_funds_indicator_description ( type: esriFieldTypeString, alias: business_funds_indicator_description, length: 8000 )
• business_types_code ( type: esriFieldTypeString, alias: business_types_code, length: 8000 )
• business_types_description ( type: esriFieldTypeString, alias: business_types_description, length: 8000 )
• record_type_code ( type: esriFieldTypeInteger, alias: record_type_code )
• record_type_description ( type: esriFieldTypeString, alias: record_type_description, length: 8000 )
• highly_compensated_officer_1_name ( type: esriFieldTypeString, alias: highly_compensated_officer_1_name, length: 8000 )
• highly_compensated_officer_1_amount ( type: esriFieldTypeDouble, alias: highly_compensated_officer_1_amount )
• highly_compensated_officer_2_name ( type: esriFieldTypeString, alias: highly_compensated_officer_2_name, length: 8000 )
• highly_compensated_officer_2_amount ( type: esriFieldTypeDouble, alias: highly_compensated_officer_2_amount )
• highly_compensated_officer_3_name ( type: esriFieldTypeString, alias: highly_compensated_officer_3_name, length: 8000 )
• highly_compensated_officer_3_amount ( type: esriFieldTypeDouble, alias: highly_compensated_officer_3_amount )
• highly_compensated_officer_4_name ( type: esriFieldTypeString, alias: highly_compensated_officer_4_name, length: 8000 )
• highly_compensated_officer_4_amount ( type: esriFieldTypeDouble, alias: highly_compensated_officer_4_amount )
• highly_compensated_officer_5_name ( type: esriFieldTypeString, alias: highly_compensated_officer_5_name, length: 8000 )
• highly_compensated_officer_5_amount ( type: esriFieldTypeDouble, alias: highly_compensated_officer_5_amount )
• usaspending_permalink ( type: esriFieldTypeString, alias: usaspending_permalink, length: 8000 )
• last_modified_date ( type: esriFieldTypeDate, alias: last_modified_date, length: 8 )
• indirect_cost_federal_share_amount ( type: esriFieldTypeString, alias: indirect_cost_federal_share_amount, length: 8000 )
• funding_opportunity_number ( type: esriFieldTypeString, alias: funding_opportunity_number, length: 8000 )
• funding_opportunity_goals_text ( type: esriFieldTypeString, alias: funding_opportunity_goals_text, length: 8000 )
• prime_award_base_transaction_description ( type: esriFieldTypeString, alias: prime_award_base_transaction_description, length: 8000 )
• outlayed_amount_from_COVID_19_supplementals ( type: esriFieldTypeString, alias: outlayed_amount_from_COVID-19_supplementals, length: 8000 )
• obligated_amount_from_COVID_19_supplementals ( type: esriFieldTypeString, alias: obligated_amount_from_COVID-19_supplementals, length: 8000 )
• outlayed_amount_from_IIJA_supplemental ( type: esriFieldTypeString, alias: outlayed_amount_from_IIJA_supplemental, length: 8000 )
• obligated_amount_from_IIJA_supplemental ( type: esriFieldTypeString, alias: obligated_amount_from_IIJA_supplemental, length: 8000 )
• total_outlayed_amount ( type: esriFieldTypeDouble, alias: total_outlayed_amount )
• recipient_name_raw ( type: esriFieldTypeString, alias: recipient_name_raw, length: 8000 )
• prime_award_summary_recipient_county_fips_code ( type: esriFieldTypeInteger, alias: prime_award_summary_recipient_county_fips_code )
• prime_award_summary_recipient_state_fips_code ( type: esriFieldTypeInteger, alias: prime_award_summary_recipient_state_fips_code )
• prime_award_summary_place_of_performance_county_fips_code ( type: esriFieldTypeInteger, alias: prime_award_summary_place_of_performance_county_fips_code )
• prime_award_summary_place_of_performance_state_fips_code ( type: esriFieldTypeInteger, alias: prime_award_summary_place_of_performance_state_fips_code )
• prime_award_summary_recipient_cd_original ( type: esriFieldTypeString, alias: prime_award_summary_recipient_cd_original, length: 8000 )
• prime_award_summary_recipient_cd_current ( type: esriFieldTypeString, alias: prime_award_summary_recipient_cd_current, length: 8000 )
• prime_award_summary_place_of_performance_cd_original ( type: esriFieldTypeString, alias: prime_award_summary_place_of_performance_cd_original, length: 8000 )
• prime_award_summary_place_of_performance_cd_current ( type: esriFieldTypeString, alias: prime_award_summary_place_of_performance_cd_current, length: 8000 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata