{"data":{"id":"dd33b547e50c4e59b6ae88a98f1bd5a4_0","type":"dataset","attributes":{"errors":[],"access":"public","additionalResources":[],"advancedQueryCapabilities":{"supportsSqlExpression":true,"supportsQueryWithResultType":true,"supportsQueryRelatedPagination":true,"supportedOperationsWithCacheHint":["query","queryTopFilter","queryAnalytics","queryAttachments","queryRelated","queryBins","queryPivot"],"supportsQueryWithCacheHint":true,"supportsQueryWithDatumTransformation":true,"supportsCurrentUserQueries":true,"supportsOutFieldSQLExpression":true,"supportsDefaultSR":true,"supportsQueryBins":true,"supportsQueryWithLodSR":false,"supportsPaginationOnAggregatedQueries":true,"supportsPagination":true,"supportsMaxRecordCountFactor":true,"supportsStatistics":true,"supportsOrderBy":true,"supportsFullTextSearch":true,"supportsQueryWithDistance":true,"supportsLod":true,"supportsSpatialAggregationStatistics":true,"supportsCountDistinct":true,"supportedLodTypes":["geohash"],"supportsAdvancedQueryRelated":true,"supportsQueryAttachmentsCountOnly":true,"supportsReturningQueryExtent":false,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":true,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsHavingClause":true,"supportsFullTextStopWords":true,"supportsApproxPercentileStatistics":true,"supportsFullTextAccentSensitivity":true,"supportsTimeRelation":true,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsTranslations":false,"supportsAggIds":true,"supportsQueryWithCollation":true,"supportsQueryPivot":true,"supportsISODOW":true,"supportsISOWeek":true},"collection":["Dataset"],"categories":["Metro Government"],"commentsEnabled":true,"composeStatus":{"retries":0,"pass":true,"lastRetriedAt":1789790036807,"lastSuccessAt":1789790036807},"composedAt":1789790036806,"content":"Feature Service","contentSecurityPolicy":null,"created":1680011585000,"currentVersion":12,"description":"The dataset is a summary of the federal grant awards for all Metro departments. The detail is provided annually by each department in an excel format and then reviewed and summarized by the Finance Department. The excel file is provided to Metro’s external auditors and is the source of Metro’s Single Audit report which is published annually and available on Metro’s website in a pdf format.
The detail included in this dataset includes fiscal year, program title, federal CFDA number, contract number, grant period, program award, (accrued) deferred grant revenue balance at the beginning of the fiscal year, amount of federal grant money received, revenue adjustments made if any, expenditures/distributions made, expenditure/payment adjustments made if any, (accrued) deferred grant revenue balance at the end of the fiscal year, amounts given to subrecipients, grantor name, pass through grantor name, department code, and department full name.

Metadata Document: Schedule of Federal Grant Awards 2015-Present Metadata.pdf
Contact Data Owner: opendata@nashville.gov

","displayField":"","downloadable":true,"enrichCoverage":"unknown","enrichQuality":85,"extent":null,"fieldNames":["OBJECTID","Fiscal_Year","Fiscal Year","Program_Title","Program Title","Federal_CFDA_Number","Federal CFDA Number","Contract_Number_Pass_Through_En","Contract Number/Pass Through Entity Identifying Number","Grant_Period","Grant Period","Expenditures_Distributions","Expenditures/Distributions","Amounts_Passed_Through_to_Subre","Amounts Passed Through to Subrecipients","Grantor","Department_Code","Department Code","Department_Name","Department Name"],"fields":[{"sqlType":"sqlTypeOther","nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"OBJECTID","alias":"OBJECTID","type":"esriFieldTypeOID"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Fiscal_Year","length":8000,"alias":"Fiscal Year","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Program_Title","length":8000,"alias":"Program Title","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Federal_CFDA_Number","alias":"Federal CFDA Number","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Contract_Number_Pass_Through_En","length":8000,"alias":"Contract Number/Pass Through Entity Identifying Number","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Grant_Period","length":8000,"alias":"Grant Period","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Expenditures_Distributions","alias":"Expenditures/Distributions","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Amounts_Passed_Through_to_Subre","length":8000,"alias":"Amounts Passed Through to Subrecipients","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Grantor","length":8000,"alias":"Grantor","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Code","length":8000,"alias":"Department Code","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Name","length":8000,"alias":"Department Name","type":"esriFieldTypeString"}],"groupIds":["8c9c6d0ef3434041b84116fdff861259"],"hasApi":true,"hubType":"Table","id":"dd33b547e50c4e59b6ae88a98f1bd5a4_0","itemId":"dd33b547e50c4e59b6ae88a98f1bd5a4","itemModified":1715011530000,"itemExtent":[],"layer":{"supportedContingentValuesFormats":"JSON, PBF","supportsApplyEditsWithGlobalIds":false,"maxRecordCount":2000,"infoInEstimates":["count"],"type":"Table","hasStaticData":true,"editingInfo":{"lastEditDate":1772640019017,"schemaLastEditDate":1772640019017,"dataLastEditDate":1772640019017},"supportsAttachmentsByUploadId":true,"relationships":[],"supportsAttachmentsResizing":true,"id":0,"supportsStatistics":true,"supportedExportFormats":"csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet","standardMaxRecordCount":32000,"isDataVersioned":false,"templates":[],"supportsAdvancedQueries":true,"supportsTilesAndBasicQueriesMode":true,"currentVersion":12,"hasZ":false,"advancedEditingCapabilities":{"supportsAsyncApplyEdits":true,"supportsApplyEditsbyUploadID":true,"supportsReturnEditResults":true,"supportedSqlFormatsInCalculate":["standard"],"supportedApplyEditsUploadIDFormats":"JSON,PBF","supportsTranslation":false,"supportsMaxTranslations":10},"supportsQuantizationEditMode":true,"objectIdField":"OBJECTID","hasContingentValuesDefinition":false,"viewSourceHasAttachments":false,"name":"Schedule_of_Federal_Grant_Awards_2015_Present_tbl","displayField":"","supportsCalculate":true,"fields":[{"sqlType":"sqlTypeOther","nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"OBJECTID","alias":"OBJECTID","type":"esriFieldTypeOID"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Fiscal_Year","length":8000,"alias":"Fiscal Year","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Program_Title","length":8000,"alias":"Program Title","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Federal_CFDA_Number","alias":"Federal CFDA Number","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Contract_Number_Pass_Through_En","length":8000,"alias":"Contract Number/Pass Through Entity Identifying Number","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Grant_Period","length":8000,"alias":"Grant Period","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Expenditures_Distributions","alias":"Expenditures/Distributions","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Amounts_Passed_Through_to_Subre","length":8000,"alias":"Amounts Passed Through to Subrecipients","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Grantor","length":8000,"alias":"Grantor","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Code","length":8000,"alias":"Department Code","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Name","length":8000,"alias":"Department Name","type":"esriFieldTypeString"}],"maxRecordCountFactor":1,"dateFieldsTimeReference":{"respectsDaylightSaving":false,"timeZone":"UTC","timeZoneIANA":"Etc/UTC"},"supportsFieldDescriptionProperty":true,"hasM":false,"allowGeometryUpdates":true,"preferredTimeReference":null,"isView":true,"useStandardizedQueries":true,"globalIdField":"","description":"","isUpdatableView":true,"supportsRollbackOnFailureParameter":true,"supportsTruncate":false,"indexes":[{"indexType":"Attribute","name":"PK__SCHEDULE__F4B70D85713A6401","isUnique":true,"description":"clustered, unique, primary key","fields":"OBJECTID","isAscending":true}],"supportedAppendSourceFilterFormats":"sqlite,geoPackage,shapefile,filegdb,featureService","htmlPopupType":"esriServerHTMLPopupTypeNone","hasAttachments":false,"queryBinsCapabilities":{"supportsAsync":true,"supportedStatisticTypes":["COUNT","SUM","AVG","VAR","STDDEV","MIN","MAX","PERCENTILE_CONT","PERCENTILE_DISC","APPROX_PERCENTILE_CONT","APPROX_PERCENTILE_DISC","CentroidAggregate","EnvelopeAggregate","ConvexHullAggregate"],"supportsFixedIntervalBin":true,"supportsAutoIntervalBin":true,"supportsFixedBoundariesBin":true,"supportsDateBin":true,"supportedNormalizationTypes":["boxCox","field","inverse","log","naturalLog","percentOfTotal","squareRoot"],"supportsNormalization":true,"supportsSnapToData":true,"supportsStackBy":true,"supportsSplitBy":true,"supportsReturnFullIntervalBin":true,"supportsFirstDayOfWeek":true,"supportsReturnStackValueRange":true,"supportsClassificationBin":true},"advancedQueryCapabilities":{"supportsSqlExpression":true,"supportsQueryWithResultType":true,"supportsQueryRelatedPagination":true,"supportedOperationsWithCacheHint":["query","queryTopFilter","queryAnalytics","queryAttachments","queryRelated","queryBins","queryPivot"],"supportsQueryWithCacheHint":true,"supportsQueryWithDatumTransformation":true,"supportsCurrentUserQueries":true,"supportsOutFieldSQLExpression":true,"supportsDefaultSR":true,"supportsQueryBins":true,"supportsQueryWithLodSR":false,"supportsPaginationOnAggregatedQueries":true,"supportsPagination":true,"supportsMaxRecordCountFactor":true,"supportsStatistics":true,"supportsOrderBy":true,"supportsFullTextSearch":true,"supportsQueryWithDistance":true,"supportsLod":true,"supportsSpatialAggregationStatistics":true,"supportsCountDistinct":true,"supportedLodTypes":["geohash"],"supportsAdvancedQueryRelated":true,"supportsQueryAttachmentsCountOnly":true,"supportsReturningQueryExtent":false,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":true,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsHavingClause":true,"supportsFullTextStopWords":true,"supportsApproxPercentileStatistics":true,"supportsFullTextAccentSensitivity":true,"supportsTimeRelation":true,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsTranslations":false,"supportsAggIds":true,"supportsQueryWithCollation":true,"supportsQueryPivot":true,"supportsISODOW":true,"supportsISOWeek":true},"serviceItemId":"dd33b547e50c4e59b6ae88a98f1bd5a4","supportsValidateSql":true,"cacheMaxAge":30,"supportsCoordinatesQuantization":true,"types":[],"capabilities":"Query,Extract","supportsAppend":true,"supportsExceedsLimitStatistics":true,"supportedSyncDataOptions":260,"sourceSchemaChangesAllowed":true,"defaultVisibility":true,"advancedQueryAnalyticCapabilities":{"supportsAsync":true,"supportsLinearRegression":true,"supportsPercentileAnalytic":true,"supportsTrendlineRegression":true},"hasMetadata":true,"supportedAppendFormats":"sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf","uniqueIdField":{"isSystemMaintained":true,"name":"OBJECTID"},"tileMaxRecordCount":8000,"typeIdField":"","supportsASyncCalculate":true,"supportedQueryFormats":"JSON, geoJSON, PBF","copyrightText":"","supportsLayerOverrides":true,"supportedConvertContentFormats":"LayerEditCollection,FeatureCollection","supportedConvertFileFormats":"JSON,PBF,Parquet","collation":{"caseSensitive":false,"accentSensitive":true,"locale":"neutral"},"supportsColumnStoreIndex":true,"guidFormat":"","supportedOperationsWithCollation":"query,addField,updateField","supportsContingentValues":true,"supportsFieldGroups":true,"supportsEditingContingentValues":true,"maxIdsCount":1000000},"layers":[{"supportedContingentValuesFormats":"JSON, PBF","guidFormat":"","supportsApplyEditsWithGlobalIds":false,"maxRecordCount":2000,"infoInEstimates":["count"],"type":"Table","hasStaticData":true,"editingInfo":{"lastEditDate":1772640019017,"schemaLastEditDate":1772640019017,"dataLastEditDate":1772640019017},"supportsAttachmentsByUploadId":true,"relationships":[],"supportsEditingContingentValues":true,"supportsAttachmentsResizing":true,"id":0,"collation":{"caseSensitive":false,"accentSensitive":true,"locale":"neutral"},"supportsStatistics":true,"supportedExportFormats":"csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet","standardMaxRecordCount":32000,"isDataVersioned":false,"templates":[],"supportsAdvancedQueries":true,"supportsTilesAndBasicQueriesMode":true,"currentVersion":12,"hasZ":false,"advancedEditingCapabilities":{"supportsAsyncApplyEdits":true,"supportsApplyEditsbyUploadID":true,"supportsTranslation":false,"supportsReturnEditResults":true,"supportsMaxTranslations":10,"supportedSqlFormatsInCalculate":["standard"],"supportedApplyEditsUploadIDFormats":"JSON,PBF"},"supportsQuantizationEditMode":true,"objectIdField":"OBJECTID","hasContingentValuesDefinition":false,"maxIdsCount":1000000,"viewSourceHasAttachments":false,"name":"Schedule_of_Federal_Grant_Awards_2015_Present_tbl","displayField":"","supportsCalculate":true,"fields":[{"sqlType":"sqlTypeOther","nullable":false,"editable":false,"defaultValue":null,"domain":null,"name":"OBJECTID","alias":"OBJECTID","type":"esriFieldTypeOID"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Fiscal_Year","length":8000,"alias":"Fiscal Year","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Program_Title","length":8000,"alias":"Program Title","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Federal_CFDA_Number","alias":"Federal CFDA Number","type":"esriFieldTypeDouble"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Contract_Number_Pass_Through_En","length":8000,"alias":"Contract Number/Pass Through Entity Identifying Number","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Grant_Period","length":8000,"alias":"Grant Period","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Expenditures_Distributions","alias":"Expenditures/Distributions","type":"esriFieldTypeInteger"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Amounts_Passed_Through_to_Subre","length":8000,"alias":"Amounts Passed Through to Subrecipients","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Grantor","length":8000,"alias":"Grantor","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Code","length":8000,"alias":"Department Code","type":"esriFieldTypeString"},{"sqlType":"sqlTypeOther","nullable":true,"editable":true,"defaultValue":null,"domain":null,"name":"Department_Name","length":8000,"alias":"Department Name","type":"esriFieldTypeString"}],"maxRecordCountFactor":1,"dateFieldsTimeReference":{"timeZoneIANA":"Etc/UTC","respectsDaylightSaving":false,"timeZone":"UTC"},"supportsFieldDescriptionProperty":true,"hasM":false,"allowGeometryUpdates":true,"preferredTimeReference":null,"isView":true,"useStandardizedQueries":true,"globalIdField":"","supportedConvertContentFormats":"LayerEditCollection,FeatureCollection","description":"","isUpdatableView":true,"supportedOperationsWithCollation":"query,addField,updateField","supportsRollbackOnFailureParameter":true,"supportsTruncate":false,"indexes":[{"indexType":"Attribute","name":"PK__SCHEDULE__F4B70D85713A6401","isUnique":true,"description":"clustered, unique, primary key","fields":"OBJECTID","isAscending":true}],"supportedAppendSourceFilterFormats":"sqlite,geoPackage,shapefile,filegdb,featureService","htmlPopupType":"esriServerHTMLPopupTypeNone","hasAttachments":false,"queryBinsCapabilities":{"supportsReturnStackValueRange":true,"supportedNormalizationTypes":["boxCox","field","inverse","log","naturalLog","percentOfTotal","squareRoot"],"supportsNormalization":true,"supportsSnapToData":true,"supportsFixedIntervalBin":true,"supportsStackBy":true,"supportsDateBin":true,"supportsSplitBy":true,"supportsClassificationBin":true,"supportsReturnFullIntervalBin":true,"supportsAsync":true,"supportsFirstDayOfWeek":true,"supportedStatisticTypes":["COUNT","SUM","AVG","VAR","STDDEV","MIN","MAX","PERCENTILE_CONT","PERCENTILE_DISC","APPROX_PERCENTILE_CONT","APPROX_PERCENTILE_DISC","CentroidAggregate","EnvelopeAggregate","ConvexHullAggregate"],"supportsAutoIntervalBin":true,"supportsFixedBoundariesBin":true},"supportedConvertFileFormats":"JSON,PBF,Parquet","advancedQueryCapabilities":{"supportsSqlExpression":true,"supportsQueryWithResultType":true,"supportsTranslations":false,"supportsQueryRelatedPagination":true,"supportedOperationsWithCacheHint":["query","queryTopFilter","queryAnalytics","queryAttachments","queryRelated","queryBins","queryPivot"],"supportsQueryWithCacheHint":true,"supportsQueryWithDatumTransformation":true,"supportsCurrentUserQueries":true,"supportsAggIds":true,"supportsOutFieldSQLExpression":true,"supportsDefaultSR":true,"fullTextSearchCapabilities":{"supportsStopWords":true,"supportsOperator":true,"supportsSearchOperator":true,"supportsAccentSensitivity":true},"supportsQueryBins":true,"supportsQueryWithCollation":true,"supportsQueryPivot":true,"supportsApproxPercentileStatistics":true,"supportsQueryWithLodSR":false,"supportsPaginationOnAggregatedQueries":true,"supportsPagination":true,"supportsMaxRecordCountFactor":true,"supportsStatistics":true,"supportsOrderBy":true,"supportsFullTextSearch":true,"supportsQueryWithDistance":true,"supportsLod":true,"supportsSpatialAggregationStatistics":true,"supportsCountDistinct":true,"supportedLodTypes":["geohash"],"supportsAdvancedQueryRelated":true,"supportsReturningQueryExtent":false,"supportsISODOW":true,"supportsTopFeaturesQuery":true,"supportsReturningGeometryEnvelope":true,"supportsDistinct":true,"supportsReturningGeometryCentroid":false,"supportsTimeRelation":true,"supportsQueryAnalytic":true,"supportsPercentileStatistics":true,"supportedSpatialAggregationStatistics":["EnvelopeAggregate","CentroidAggregate","ConvexHullAggregate"],"supportsISOWeek":true,"supportsHavingClause":true},"serviceItemId":"dd33b547e50c4e59b6ae88a98f1bd5a4","supportsValidateSql":true,"cacheMaxAge":30,"supportsCoordinatesQuantization":true,"types":[],"capabilities":"Query,Extract","supportsAppend":true,"supportsExceedsLimitStatistics":true,"supportedSyncDataOptions":260,"sourceSchemaChangesAllowed":true,"supportsContingentValues":true,"defaultVisibility":true,"advancedQueryAnalyticCapabilities":{"supportsAsync":true,"supportsLinearRegression":true,"supportsTrendlineRegression":true,"supportsPercentileAnalytic":true},"hasMetadata":true,"supportedAppendFormats":"sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf","uniqueIdField":{"isSystemMaintained":true,"name":"OBJECTID"},"tileMaxRecordCount":8000,"supportsFieldGroups":true,"typeIdField":"","supportsASyncCalculate":true,"supportedQueryFormats":"JSON, geoJSON, PBF","copyrightText":"","supportsColumnStoreIndex":true,"supportsLayerOverrides":true}],"licenseInfo":null,"maxRecordCount":1000,"metadata":null,"modified":1772640019017,"modifiedProvenance":"layer.editingInfo.lastEditDate","name":"Schedule of Federal Grant Awards 2015-Present","objectIdField":"OBJECTID","openData":false,"orgId":"HdTo6HJqh92wn4D8","orgName":"Nashville GIS","organization":"Nashville GIS","orgExtent":{"ymin":4295228.852216443,"xmin":-9698309.88519694,"ymax":4357295.044720508,"xmax":-9623402.999842146,"spatialReference":{"wkid":102100}},"orgContactEmail":"mailto: gisdatateam@nashville.gov","owner":"NashvilleOpenData","recordCount":1964,"region":"US","searchDescription":"The dataset is a summary of the federal grant awards for all Metro departments. The detail is provided annually by each department in an excel format and then reviewed and summarized by the Finance Department. The excel file is provided to Metro’s external auditors and is the source of Metro’s Single Audit report which is published annually and available on Metro’s website in a pdf format.The detail included in this dataset includes fiscal year, program title, federal CFDA number, contract number, grant period, program award, (accrued) deferred grant revenue balance at the beginning of the fiscal year, amount of federal grant money received, revenue adjustments made if any, expenditures/distributions made, expenditure/payment adjustments made if any, (accrued) deferred grant revenue balance at the end of the fiscal year, amounts given to subrecipients, grantor name, pass through grantor name, department code, and department full name. Metadata Document: Schedule of Federal Grant Awards 2015-Present Metadata.pdf Contact Data Owner: opendata@nashville.gov ","sector":"Local and State Government","server":{"supportedContingentValuesFormats":"JSON, PBF","allowGeometryUpdates":true,"supportsQueryContingentValues":true,"isView":true,"supportsApplyEditsWithGlobalIds":false,"maxRecordCount":1000,"description":"","units":"esriMeters","isUpdatableView":true,"supportsSharedDomains":true,"hasStaticData":true,"syncEnabled":false,"tables":[{"subLayerIds":null,"maxScale":0,"name":"Schedule_of_Federal_Grant_Awards_2015_Present_tbl","defaultVisibility":true,"id":0,"minScale":0,"parentLayerId":-1}],"hasVersionedData":false,"layerOverridesEnabled":true,"layers":[],"serviceItemId":"dd33b547e50c4e59b6ae88a98f1bd5a4","fullExtent":null,"supportedExportFormats":"csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel","capabilities":"Query,Extract","supportsAppend":true,"xssPreventionInfo":{"xssInputRule":"rejectInvalid","xssPreventionRule":"InputOnly","xssPreventionEnabled":true},"supportsDisconnectedEditing":false,"sourceSchemaChangesAllowed":true,"supportsContingentValuesJson":2,"supportsTilesAndBasicQueriesMode":true,"preserveLayerIds":true,"supportsReturnDeleteResults":true,"currentVersion":12,"hasSharedDomains":false,"supportsWebHooks":true,"supportsVCSProjection":false,"advancedEditingCapabilities":{"supportsAsyncApplyEdits":true,"supportsApplyEditsbyUploadID":true,"supportsSplit":false,"supportsReturnEditResults":true,"supportsReturnServiceEditsInSourceSR":false,"supportedApplyEditsUploadIDFormats":"JSON,PBF"},"supportedQueryFormats":"JSON","initialExtent":null,"supportsTemporalLayers":true,"serviceDescription":"","copyrightText":"","supportsLayerOverrides":true,"supportedConvertContentFormats":"LayerEditCollection","onlyAllowTrueCurveUpdatesByTrueCurveClients":false,"supportedConvertFileFormats":"JSON,PBF","supportsTrueCurve":true,"supportedCurveTypes":["esriGeometryCircularArc"],"allowTrueCurvesUpdates":true,"supportedFullTextLocales":["neutral","ar-SA","bg-BG","bn-IN","ca-ES","cs-CZ","da-DK","de-DE","el-GR","en-GB","en-US","es-ES","fr-FR","gu-IN","he-IL","hi-IN","hr-HR","id-ID","is-IS","it-IT","ja-JP","kn-IN","ko-KR","lt-LT","lv-LV","ml-IN","mr-IN","ms-MY","nb-NO","nl-NL","pa-IN","pl-PL","pt-BR","pt-PT","ro-RO","ru-RU","sk-SK","sl-SI","sr-Cyrl-CS","sr-Latn-CS","sv-SE","ta-IN","te-IN","th-TH","tr-TR","uk-UA","ur-PK","vi-VN","zh-CN","zh-HK","zh-MO","zh-SG","zh-TW"],"supportsSharedTemplates":true,"hasSharedTemplates":true,"supportedAppendCapabilities":"Features","supportedTrueCurvePbfFeatureEncodings":["esriCompressedShapeBuffer","esriDefault"],"trueCurveSupportMode":"OGC","maxIdsCount":1000000},"serverCapabilities":"Query,Extract","size":0,"slug":"Nashville::schedule-of-federal-grant-awards-2015-present","source":"Nashville GIS","sourceProvenance":"org.name","statistics":{"objectid":{"objectid":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":476.38796400000865,"values":{"avg":982.5,"min":1,"max":1964,"count":1964,"sum":1929630}}}},"string":{"amounts_passed_through_to_subre":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":252.3618270000443,"values":[{"count":1915,"value":"0"},{"count":1,"value":" 0"},{"count":1,"value":"100006.63"},{"count":1,"value":"1233087"},{"count":1,"value":"1266432.02"},{"count":1,"value":"14833.32"},{"count":1,"value":"154327.01"},{"count":1,"value":"154656"},{"count":1,"value":"1564686"},{"count":1,"value":"169007"},{"count":1,"value":"171848"},{"count":1,"value":"180994.1"},{"count":1,"value":"18717210"},{"count":1,"value":"193551.87"},{"count":1,"value":"2090376"},{"count":1,"value":"223477"},{"count":1,"value":"234518"},{"count":1,"value":"2398782"},{"count":1,"value":"249856"},{"count":1,"value":"252204"},{"count":1,"value":"254627.22"},{"count":1,"value":"2576"},{"count":1,"value":"2651064"},{"count":1,"value":"266460"},{"count":1,"value":"280"},{"count":1,"value":"280206.83"},{"count":1,"value":"2828641.88"},{"count":1,"value":"31119"},{"count":1,"value":"321179"},{"count":1,"value":"330527"},{"count":1,"value":"3308591"},{"count":1,"value":"37042"},{"count":1,"value":"393750.16"},{"count":1,"value":"39832.53"},{"count":1,"value":"402484.55"},{"count":1,"value":"4124765.17"},{"count":1,"value":"41548.53"},{"count":1,"value":"419532"},{"count":1,"value":"426404"},{"count":1,"value":"44969"},{"count":1,"value":"470351"},{"count":1,"value":"49530"},{"count":1,"value":"525269"},{"count":1,"value":"55763"},{"count":1,"value":"577909"},{"count":1,"value":"60524.69"},{"count":1,"value":"61053"},{"count":1,"value":"74554"},{"count":1,"value":"95295.52"}],"count":1963,"uniqueCount":49}},"department_code":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":314.88548399996944,"values":[{"count":586,"value":"MNPS"},{"count":407,"value":"HEA"},{"count":132,"value":"MAC"},{"count":105,"value":"POL"},{"count":81,"value":"NCAC"},{"count":73,"value":"SOC"},{"count":61,"value":"1080"},{"count":59,"value":"PW"},{"count":52,"value":"OEM"},{"count":42,"value":"1038"},{"count":34,"value":"OFS"},{"count":32,"value":"WS"},{"count":30,"value":"PLA"},{"count":29,"value":"JUV"},{"count":26,"value":"FIN"},{"count":19,"value":"ART"},{"count":19,"value":"STC"},{"count":17,"value":"HIS"},{"count":16,"value":"LIB"},{"count":15,"value":"1075"},{"count":14,"value":"DA"},{"count":12,"value":"1031"},{"count":8,"value":"GSC"},{"count":8,"value":"PAR"},{"count":8,"value":"SHE"},{"count":6,"value":"1015"},{"count":6,"value":"MUN"},{"count":5,"value":"1042"},{"count":5,"value":"NDOT"},{"count":4,"value":"1011"},{"count":4,"value":"1053"},{"count":4,"value":"1065"},{"count":4,"value":"W&S"},{"count":3,"value":"1026"},{"count":3,"value":"1027"},{"count":3,"value":"1030"},{"count":3,"value":"1049"},{"count":3,"value":"ELE"},{"count":3,"value":"OHS"},{"count":3,"value":"PDF/SHE"},{"count":3,"value":"POL/OFS"},{"count":2,"value":"1028"},{"count":2,"value":"1037"},{"count":2,"value":"1051"},{"count":2,"value":"MAY"},{"count":2,"value":"NFD"},{"count":1,"value":"1010"},{"count":1,"value":"1014"},{"count":1,"value":"1019"},{"count":1,"value":"1039"}],"count":1964,"uniqueCount":53}},"fiscal_year":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":165.0270470000105,"values":[{"count":226,"value":"FY 17"},{"count":224,"value":"FY 19"},{"count":217,"value":"FY 18"},{"count":213,"value":"FY 16"},{"count":204,"value":"FY 20"},{"count":180,"value":"FY 23"},{"count":178,"value":"FY 24"},{"count":176,"value":"FY 25"},{"count":174,"value":"FY 22"},{"count":172,"value":"FY 21"}],"count":1964,"uniqueCount":10}},"department_name":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":313.17260599997826,"values":[{"count":391,"value":"Metro Nashville Public Schools"},{"count":298,"value":"Health"},{"count":251,"value":"Metro Nashville Public School"},{"count":151,"value":"Health Department"},{"count":81,"value":"Nashville Career Advancement Center"},{"count":79,"value":"Metro Action Commission"},{"count":75,"value":"Social Services"},{"count":68,"value":"Metro Action"},{"count":66,"value":"Public Works"},{"count":63,"value":"Police"},{"count":53,"value":"POLICE DEPARTMENT"},{"count":36,"value":"Office of Emergency Management"},{"count":36,"value":"Office of Family Safety"},{"count":30,"value":"JUVENILE COURT"},{"count":30,"value":"Planning Commission"},{"count":22,"value":"FINANCE DEPARTMENT"},{"count":22,"value":"Water Services"},{"count":21,"value":"HISTORICAL COMMISSION"},{"count":21,"value":"State Trial Courts"},{"count":20,"value":"OFFICE OF EMERG. MGMT."},{"count":19,"value":"ARTS COMMISSION"},{"count":18,"value":"Water & Sewer"},{"count":15,"value":"DISTRICT ATTORNEY"},{"count":15,"value":"Library"},{"count":10,"value":"Finance"},{"count":8,"value":"GENERAL SESSIONS CT."},{"count":7,"value":"Parks"},{"count":7,"value":"SHERIFF"},{"count":6,"value":"Municipal Aud."},{"count":5,"value":"MNPS DEPARTMENT"},{"count":5,"value":"PUBLIC LIBRARY"},{"count":4,"value":"OFFICE OF HOMELESS SERVICES"},{"count":4,"value":"Sherriff"},{"count":3,"value":"Elections Commission"},{"count":3,"value":"General Sessions Court"},{"count":3,"value":"OFFICE OF HOMELESS"},{"count":3,"value":"Police/Office of Family Safety"},{"count":2,"value":"GENERAL SERVICES"},{"count":2,"value":"JUVENILE COURTS"},{"count":2,"value":"Mayor's Office"},{"count":2,"value":"Parks & Recreation"},{"count":2,"value":"Public Defender/Sherriff"},{"count":1,"value":"Finance & Multiple Departments"},{"count":1,"value":"FIRE DEPARTMENT"},{"count":1,"value":"INFORMATION TECHNOLOGY SERVICES"},{"count":1,"value":"NASHVILLE FIRE DEPARTMENT"},{"count":1,"value":"Public Defender/Sheriff"}],"count":1964,"uniqueCount":47}},"contract_number_pass_through_en":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":222.42666900000768,"values":[{"count":297,"value":"N/A"},{"count":37,"value":"18-01"},{"count":30,"value":"16-01"},{"count":30,"value":"17-01"},{"count":30,"value":"19-01"},{"count":20,"value":"20-01"},{"count":20,"value":"SFA 190"},{"count":18,"value":"Part of 34353-14215"},{"count":15,"value":"00049"},{"count":12,"value":"Part of 34360-31718"},{"count":12,"value":"S425D210047"},{"count":12,"value":"Sponsor ID #00049"},{"count":11,"value":"15-01"},{"count":11,"value":"18-190000"},{"count":10,"value":"S377A120043/S37A140043"},{"count":9,"value":"26758"},{"count":9,"value":"33901"},{"count":9,"value":"36306 Amendment 3"},{"count":8,"value":"170129"},{"count":8,"value":"34349-00422"},{"count":8,"value":"E-24547"},{"count":8,"value":"Part of 34349-47416"},{"count":8,"value":"Part of 34349-47417"},{"count":8,"value":"Part of 34349-47418"},{"count":8,"value":"Part of 34349-47419"},{"count":8,"value":"Part of 34349-47420"},{"count":8,"value":"Part of 34360-31717"},{"count":8,"value":"U-165A170061"},{"count":8,"value":"U-411B170021"},{"count":7,"value":"13-01"},{"count":7,"value":"21-01"},{"count":7,"value":"S287C220043"},{"count":7,"value":"S425U210047"},{"count":7,"value":"U-351C170073"},{"count":6,"value":"1909 DR TN"},{"count":6,"value":"2016-39"},{"count":6,"value":"2017-39"},{"count":6,"value":"2018-39"},{"count":6,"value":"2019-39"},{"count":6,"value":"26639"},{"count":6,"value":"34353-14219"},{"count":6,"value":"E-34101"},{"count":6,"value":"Part of 34360-31716"},{"count":6,"value":"S010A200042"},{"count":6,"value":"S010A220042"},{"count":6,"value":"S184M140107"},{"count":6,"value":"S425W210044"},{"count":6,"value":"U411C150082"},{"count":5,"value":"150028"},{"count":5,"value":"150109"}],"count":1964,"uniqueCount":681}},"program_title":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":326.54557399998885,"values":[{"count":24,"value":"Justice Assistance Grant"},{"count":16,"value":"Community Services Block Grant"},{"count":16,"value":"Title II Part A"},{"count":16,"value":"Title III Emergency Immigrant Education Program"},{"count":15,"value":"Comprehensive STD Prevention System"},{"count":14,"value":"Program Improvement - Carl Perkins Federal Grant"},{"count":13,"value":"Fresh Fruits and Vegetables Program - Metro Public Schools"},{"count":13,"value":"Title I Non-Enhanced Option"},{"count":12,"value":"Child Adult Care Food Program - Metro Action Commission"},{"count":12,"value":"Governor's Highway Safety Program - Police"},{"count":12,"value":"Head Start"},{"count":12,"value":"HIV - Emergency Relief Grant - Minority AIDS Initiative"},{"count":12,"value":"HIV - Emergency Relief Grant - Part A"},{"count":12,"value":"HIV/AIDS Prevention"},{"count":12,"value":"HIV/AIDS Surveillance"},{"count":12,"value":"Homeless Children Education Program"},{"count":11,"value":"Governor's Highway Safety Program - State Trial Courts Drug Court"},{"count":11,"value":"Low Income Energy Assistance Program"},{"count":11,"value":"Major Cultural Institutions (Federal portion)"},{"count":11,"value":"National School Breakfast Program - Metro Public Schools"},{"count":11,"value":"Summer Food Service Program - Metro Action Commission"},{"count":11,"value":"TB Outreach and Control (Federal Portion)"},{"count":11,"value":"VOCA Hispanic, Child and Family - District Attorney"},{"count":10,"value":"Child Support Enforcement, Title IV-D - Juvenile Court"},{"count":10,"value":"Health Promotion"},{"count":10,"value":"Nutrition Services Incentive Program"},{"count":10,"value":"Rapid HIV Testing Services"},{"count":10,"value":"Section 103 Ambient Air Monitoring Network Installation"},{"count":10,"value":"Title III Part B Transportation"},{"count":10,"value":"Title III Part C Nutrition Program"},{"count":10,"value":"Tobacco Prevention"},{"count":10,"value":"Workforce Innovation and Opportunity Act Dislocated Worker"},{"count":9,"value":"CDBG Homeless Assistance Program - Metro Social Services"},{"count":9,"value":"Children's Special Services/Care Coordination (Federal Portion)"},{"count":9,"value":"GROW STEM"},{"count":9,"value":"Healthcare Preparedness (HPP)"},{"count":9,"value":"Immunization Services for Children (Federal Portion)"},{"count":9,"value":"National School Lunch Program - Lunch, Metro Public Schools"},{"count":9,"value":"Public Health Emergency Preparedness (PHEP)"},{"count":9,"value":"Public Health Emergency Preparedness Cities Readiness Initiative (CRI)"},{"count":9,"value":"Workforce Innovation and Opportunity Act Youth Programs"},{"count":9,"value":"Wyman's Teen Outreach Program - Juvenile Court"},{"count":8,"value":"21st Century CCLC Cohort"},{"count":8,"value":"Air Pollution Control Program"},{"count":8,"value":"Army R.O.T.C."},{"count":8,"value":"Before and After Care - Metro Action Commission"},{"count":8,"value":"EIR Pyramid Model"},{"count":8,"value":"National School Lunch and Breakfast Program - Food Distribution - Metro Public Schools"},{"count":8,"value":"National School Lunch Program - Snacks, Metro Public Schools"},{"count":8,"value":"Port Security"}],"count":1964,"uniqueCount":774}},"grantor":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":371.31455599999754,"values":[{"count":356,"value":"U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES:"},{"count":298,"value":"U.S. DEPARTMENT OF EDUCATION:"},{"count":147,"value":"U.S. DEPARTMENT OF EDUCATION"},{"count":115,"value":"U.S. DEPARTMENT OF AGRICULTURE:"},{"count":110,"value":"U.S. DEPARTMENT OF TRANSPORTATION:"},{"count":107,"value":"U.S. DEPARTMENT OF JUSTICE:"},{"count":73,"value":"U.S. DEPARTMENT OF LABOR:"},{"count":64,"value":"U.S. DEPARTMENT OF HOMELAND SECURITY:"},{"count":60,"value":"U.S. DEPARTMENT OF DEFENSE"},{"count":60,"value":"U.S. DEPARTMENT OF JUSTICE"},{"count":59,"value":"U.S. DEPARTMENT OF AGRICULTURE"},{"count":54,"value":"U.S DEPARTMENT OF EDUCATION"},{"count":42,"value":"U.S. DEPARTMENT OF HEALTH & HUMAN SERVICES"},{"count":34,"value":"U.S DEPARTMENT OF HEALTH & HUMAN SERVICES"},{"count":26,"value":"U.S. CENTER FOR DISEASE CONTROL (CDC)"},{"count":25,"value":"U.S. DEPARTMENT OF TRANSPORTATION"},{"count":24,"value":"NATIONAL ENDOWMENT FOR THE ARTS:"},{"count":24,"value":"U.S. DEPARTMENT OF DEFENSE:"},{"count":24,"value":"U.S. DEPARTMENT OF HOMELAND SECURITY"},{"count":22,"value":"U. S DEPARTMENT OF JUSTICE"},{"count":19,"value":"U.S. ENVIRONMENTAL PROTECTION AGENCY"},{"count":18,"value":"ENVIRONMENTAL PROTECTION AGENCY:"},{"count":16,"value":"U.S. DEPARTMENT OF HOUSING AND DEVELOPMENT:"},{"count":14,"value":"U.S. DEPARTMENT OF TREASURY"},{"count":12,"value":"INSTITUTE OF MUSEUM AND LIBRARY SERVICES:"},{"count":11,"value":"U.S DEPARTMENT OF HOMELAND SECURITY"},{"count":11,"value":"U.S. DEPARTMENT OF HOUSING & URBAN DEVELOPMENT"},{"count":9,"value":"U.S DEPARTMENT OF TRANSPORTATION"},{"count":9,"value":"U.S. DEPARTMENT OF INTERIOR:"},{"count":8,"value":"U.S. DEPARTMENT OF HEALTH RESOURCES & SERVICES ADMINSTRATION"},{"count":7,"value":"U.S. DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT:"},{"count":7,"value":"U.S. DEPARTMENT OF TREASURY:"},{"count":6,"value":"U.S. DEPARTMENT OF INTERIOR"},{"count":5,"value":"CENTER FOR DISEASE CONTROL"},{"count":5,"value":"U.S DEPARTMENT OF HOUSING & URBAN DEV."},{"count":5,"value":"U.S DEPARTMENT OF TREASURY"},{"count":4,"value":"NATIONAL ENDOWMENT FOR THE ARTS"},{"count":4,"value":"TENNESSEE HOUSING AND DEVELOPMENT AGENCY"},{"count":4,"value":"U.S ENVIRONMENTAL PROTECTION AGENCY"},{"count":4,"value":"U.S. DEPARTMENT OF LABOR"},{"count":3,"value":"HHS ADMINISTRATION FOR CHILDREN & FAMILIES"},{"count":3,"value":"INSTITUTE OF MUSEUM AND LIBRARY SERVICES"},{"count":3,"value":"U.S NATIONAL PARK SERVICES"},{"count":3,"value":"U.S. DEPARTMENT OF HOUSING & URBAN DEV."},{"count":3,"value":"U.S. NATIONAL HIGHWAY TRAFFIC SAFETY ADMINISTRATION"},{"count":3,"value":"U.S. OFFICE OF NATIONAL DRUG CONTROL POLICY"},{"count":2,"value":"ADMINISTRATION FOR CHILDREN & FAMILIES"},{"count":2,"value":"CENTER FOR DISEASE CONTROL AND PREVENTION"},{"count":2,"value":"DEPARTMENT OF JUSTICE"},{"count":2,"value":"STATE JUSTICE INSTITUTE:"}],"count":1964,"uniqueCount":76}},"grant_period":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":188.57601700001396,"values":[{"count":85,"value":"07-01-2021 to 06-30-2022"},{"count":76,"value":"07-01-16 to 06-30-17"},{"count":72,"value":"07-01-15 to 06-30-16"},{"count":56,"value":"07-01-17 to 06-30-18"},{"count":50,"value":"07-01-19 to 06-30-20"},{"count":43,"value":"07-01-18 to 06-30-19"},{"count":33,"value":"07-01-14 to 06-30-15"},{"count":28,"value":"07-01-17 to 09-30-18"},{"count":28,"value":"07-01-18 to 09-30-19"},{"count":27,"value":"07-01-16 to 09-30-17"},{"count":22,"value":"07-01-2023 to 06-30-2024"},{"count":21,"value":"07-01-15 to 09-30-16"},{"count":20,"value":"07-01-2024 to 06-30-2025"},{"count":19,"value":"07-01-20 to 06-30-21"},{"count":19,"value":"07-01-2022 to 06-30-2023"},{"count":19,"value":"10-01-15 to 09-30-16"},{"count":19,"value":"10-01-18 to 09-30-19"},{"count":17,"value":"07-01-19 to 09-30-20"},{"count":16,"value":"07-01-17 to 06-30-22"},{"count":15,"value":"10-01-17 to 09-30-18"},{"count":14,"value":"07-01-14 to 09-30-15"},{"count":14,"value":"10-01-2021 to 09-30-2022"},{"count":13,"value":"07-01-2021 to 06-30-2023"},{"count":13,"value":"07-01-2021 to 06-30-2024"},{"count":13,"value":"10-01-16 to 09-30-17"},{"count":13,"value":"10-01-2021 to 09-30-2024"},{"count":12,"value":"01-01-16 to 12-31-16"},{"count":12,"value":"01-01-18 to 12-31-18"},{"count":12,"value":"01-01-19 to 12-31-19"},{"count":12,"value":"07-01-2022 to 06-30-2027"},{"count":12,"value":"10-01-2022 to 09-30-2023"},{"count":12,"value":"10-01-2023 to 09-30-2024"},{"count":10,"value":"07/01/2024 to 06-30-2025"},{"count":10,"value":"07-01-17 to 09-30-19"},{"count":10,"value":"10-01-14 to 09-30-15"},{"count":10,"value":"10-01-14 to 09-30-18"},{"count":9,"value":"07-01-16 to 06-30-18"},{"count":9,"value":"07-01-2020 to 06-30-2023"},{"count":9,"value":"10-01-19 to 09-30-20"},{"count":9,"value":"10-01-2022 to 09-30-2024"},{"count":9,"value":"10-01-2024 to 09-30-2025"},{"count":8,"value":"01-01-17 to 12-31-17"},{"count":8,"value":"01-01-20 to 12-31-20"},{"count":8,"value":"01-01-2022 to 12-31-2022"},{"count":8,"value":"03-31-15 to 03-31-20"},{"count":8,"value":"05-06-15 to 05-30-20"},{"count":8,"value":"05-20-2020 to 04-19-2040"},{"count":8,"value":"07-01-2021 to 06-30-2025"},{"count":8,"value":"10-01-15 to 09-30-18"},{"count":8,"value":"10-01-17 to 09-30-22"}],"count":1964,"uniqueCount":535}}},"numeric":{"federal_cfda_number":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":195.99954000000434,"values":{"avg":56.594628309572094,"min":0,"max":97.067,"var":1424.2619802581546,"count":1964,"sum":111151.8499999996,"stddev":37.73939560006433}}},"expenditures_distributions":{"meta":{"pass":true,"missingStats":[],"error":null},"statistics":{"duration":195.99954000000434,"values":{"avg":1486764.2097759675,"min":-2156651,"max":183522872,"var":50623661060788.58,"count":1964,"sum":2920004908,"stddev":7115030.643699897}}}}},"structuredLicense":{"type":"none"},"license":"none","supportedQueryFormats":"JSON, geoJSON, PBF","supportsAdvancedQueries":true,"tags":["grants","awards","assistance","federal","single audit"],"thumbnail":"thumbnail/thumbnail1680018179131.png","thumbnailUrl":"thumbnail/thumbnail1680018179131.png","type":"Table","typeCategories":["Dataset"],"typeKeywords":["ArcGIS Server","Data","Feature Access","Feature Service","Service","Singlelayer","Table","Hosted Service","View Service"],"url":"https://services2.arcgis.com/HdTo6HJqh92wn4D8/arcgis/rest/services/Schedule_of_Federal_Grant_Awards_2015_Present_view/FeatureServer/0","useStandardizedQueries":true,"validExtent":true,"xFrameOptions":null,"boundary":null,"snippet":"Schedule of Federal Grant Awards, 2015-Present","culture":""},"links":{"self":"https://hub.arcgis.com/api/v3/datasets/dd33b547e50c4e59b6ae88a98f1bd5a4_0","rawEs":"https://hub.arcgis.com/api/es/datasets/dd33b547e50c4e59b6ae88a98f1bd5a4_0","itemPage":"https://www.arcgis.com/home/item.html?id=dd33b547e50c4e59b6ae88a98f1bd5a4","esriRest":"https://www.arcgis.com/sharing/content/items/dd33b547e50c4e59b6ae88a98f1bd5a4?f=json"},"meta":{"highlights":{},"matchedFields":[]}},"meta":{"apiRoot":"https://hub.arcgis.com/api/v3/","resourceRoot":"https://hub.arcgis.com/api/v3/datasets","request":"https://hub.arcgis.com/api/v3/datasets/dd33b547e50c4e59b6ae88a98f1bd5a4_0"}}