Updated 7 months ago
Indexed 2 hours ago

Iowa Pandemic Recovery Reporting: Sub Recipient Awards

This dataset provides information on awards greater than or equal to $25,000 to vendors (i.e., non-state organizations) from State agencies using funds from Federal Awards considered covered funds under Section 15011 of the Coronavirus Aid, Relief, and Economic Security (CARES) Act. Covered funds are federal funds appropriated through one of the following: the CARES Act; the Coronavirus Preparedness and Response Supplemental Appropriations Act, 2020 (Public Law 116–123); the Families First Coronavirus Response Act (Public Law 116–127); or any other Act primarily making appropriations for the Coronavirus response and related activities.


NameSocrata field nameColumn name in sgr mountData typeDescription
Award Amountaward_amountaward_amountNumberThe total amount of the award.
Performance Start Dateperformance_startperformance_startCalendar dateThe date on which effort begins or the award is otherwise effective.
Award Descriptionaward_descriptionaward_descriptionTextA brief description of the purpose of the award.
Award Numberaward_numberaward_numberTextA unique identifier assigned by the state agency to facilitate the tracking of the award.
CitycitycityTextCity where the vendor is physically located.
Secondary Addresssecondary_addresssecondary_addressTextName of building, and unit designator (i.e. FL - floor, STE - suite, RM - room, etc.) where the vendor is physically located.
Primary Addressprimary_addressprimary_addressTextStreet address where the vendor is physically located.
Doing Business Asdoing_business_asdoing_business_asTextName the vendor receiving the award is doing business as if applicable.
Legal Namelegal_namelegal_nameTextLegal name of the vendor receiving the sub award.
Vendor Numbervendor_numbervendor_numberTextUnique eleven character identifier used in the State Accounting System for payments to the vendor receiving the award.
Federal Program Titlefederal_program_titlefederal_program_titleTextName of the Federal program the sub recipient award was funded by.
Federal Award Numberfederal_award_numberfederal_award_numberTextThis shall be the federal award number for the federal award that is funding the sub recipient award.
Record IDrecord_idrecord_idTextUnique identifier for the record; concatenation of state_dept_no, and award_number with a dash (“-”) in between.
LocationlocationlocationPointGeolocation of the vendor’s physical address.
Local Governmentlocal_govlocal_govCheckboxLocal government consists of cities, counties, townships, school districts and special-purpose districts. A yes or true response indicates the sub recipient is a board, commission, agency or office of a local government.
Performance End Dateperformance_endperformance_endCalendar dateThe date on which effort related to the award ends or is completed.
State Departmentstate_departmentstate_departmentTextName of the State Department making the award.
Award Dateaward_dateaward_dateCalendar dateThe date a binding agreement was executed.
ZipzipzipTextUnited States ZIP code (five digits) concatenated with the additional +4 digits where the vendor is physically located.
State Department Numberstate_dept_nostate_dept_noTextThe three digit code used in the State Accounting System of the department making the award.
Vendor DUNSvendor_dunsvendor_dunsTextThe unique 9-digit number assigned to the vendor by Dun and Bradstreet (D&B) referred to as the DUNS®
StatestatestateTextUnited States Postal Service (USPS) two-letter abbreviation for the state where the vendor is physically located.
Rating Areas for Iowa Individual Affordable Care Act Premiums:@computed_region_hhz5_dst4:@computed_region_hhz5_dst4Number
Iowa Regional Zip Codes:@computed_region_g8ff_h7ce:@computed_region_g8ff_h7ceNumber
County Boundaries of Iowa:@computed_region_y683_txed:@computed_region_y683_txedNumber
Upstream Metadata