{"metadata": {"skip":0,"select":null,"rundate":"2026-06-09T11:10:10.079Z","top":1000,"filter":"openFemaDataSet eq 'PublicAssistanceFundedProjectsDetails' and datasetVersion eq 2","format":"json","metadata":true,"orderby":"","entityname":"OpenFemaDataSetFields","version":"v1","url":"/api/open/v1/OpenFemaDataSetFields?%24filter=openFemaDataSet+eq+%27PublicAssistanceFundedProjectsDetails%27+and+datasetVersion+eq+2","count":0}, "OpenFemaDataSetFields": [{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"disasterNumber","title":"Disaster Number","description":"Sequentially assigned number used to designate an event or incident declared as a disaster. For more information on the disaster process visit https://www.fema.gov/disasters/how-declared","type":"smallint","sortOrder":1,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"781da830-055a-4867-8cd6-9b552082758b","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"ac9d24e3dbcc1413d27dc0d3301b382207dc110f","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"declarationDate","title":"Declaration Date","description":"Date the disaster was declared","type":"date","sortOrder":2,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"b2f516d4-19c6-4e63-a398-2594f174c45b","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"f9ab12942d09ed98f01a0eae22d5a816298cac21","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"incidentType","title":"Incident Type","description":"Type of incident such as fire or flood. The incident type will affect the types of assistance available. For more information on incident types, please visit: https://www.fema.gov","type":"text","sortOrder":3,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"12602567-2fd1-48e7-a953-bdbd183354ce","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"830345afd56fe2766c4ff7785d01948178ccdeb0","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"pwNumber","title":"Project Worksheet Number","description":"Sequentially assigned number used to identify a unique project","type":"integer","sortOrder":4,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"921eda16-8552-412a-8549-5c3e93e73fb3","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"892ae942a8895d80ab39ea3e8f06799576a0ecf1","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"applicationTitle","title":"Application Title","description":"Standard, non-unique (free form text) application title","type":"text","sortOrder":5,"isSearchable":true,"isNestedObject":false,"isNullable":true,"primaryKey":false,"id":"f08393fe-06eb-4f71-84ba-39b2eb82de82","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"097a994e2b12170701630ad9d3ed7ce3d6037d49","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"applicantId","title":"Applicant ID","description":"Unique Public Assistance applicant identification number","type":"text","sortOrder":6,"isSearchable":true,"isNestedObject":false,"isNullable":true,"primaryKey":false,"id":"c675c63a-2efb-4d09-947d-234c439167b4","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"87148e6c30f6528c194e75785a68f707099e77d1","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"damageCategoryCode","title":"Damage Category Code","description":"Code representing the type of work eligible for reimbursement through a Public Assistance grant; for a full listing of each category please go to https://www.fema.gov/assistance/public/program-overview","type":"text","sortOrder":7,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"7d2eb9a1-937a-49c1-b717-3c72170a86b5","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"bd89e9e1847fb93427db03b8f36c5ad0d29eed30","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"damageCategoryDescrip","title":"Damage Category Description","description":"Damage category code related to the Damage Category Description","type":"text","sortOrder":8,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"e4046957-5322-43e0-b110-72f5d7432739","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"f3f5359d0ff03e907b3508434f87db93d8069cf5","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"projectStatus","title":"Project Status","description":"An active or inactive status of the project","type":"text","sortOrder":9,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"e3945ef3-02c3-4a11-8e05-cc8e80f841c5","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"3bfaa4f459c96e6a891ea6bca02e9147879d8f4b","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"projectProcessStep","title":"Project Process Step","description":"The current process location of a project from formulation through closeout including pending stages, discontinuation and obligation.","type":"text","sortOrder":10,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"7eff81a8-9cb1-44b4-8e1a-5390b1bf693e","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"e7fc4bf469202e13558c3c1003f448ef5eb5783b","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"projectSize","title":"Project Size","description":"Projects are designated as Large or Small, which can affect a number of variables in case management (processing). Project size is determined by the eligible amount as set in the damage survey","type":"text","sortOrder":11,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"43d45cf5-c640-447c-9e1a-eed0cfa26aae","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"e61f9f92e80b7be63ddaddd47cf73e87af620600","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"county","title":"County","description":"The name of a U.S. county, parish, borough, independent city or other political subdivision specifying the applicant location. Counties may not be available for tribal, territories or applicants lacking specified headquarter locations.","type":"text","sortOrder":12,"isSearchable":true,"isNestedObject":false,"isNullable":true,"primaryKey":false,"id":"db0eb2a7-4c3a-425d-affc-f82a3990a166","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"a99dbde3f5feb85215f2a5b6e25479abf6541912","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"countyCode","title":"County Code","description":"Unique identifier for a U.S. county; typically, this identifier makes up the last three digits of a five digit Federal Information Processing Standard (FIPS) Code","type":"text","sortOrder":13,"isSearchable":true,"isNestedObject":false,"isNullable":true,"primaryKey":false,"id":"6b152001-7540-4f0a-9302-4352dedf65e3","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"abc993bdb9b3465a4fd8e3e24a19b190d893e1d4","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"stateAbbreviation","title":"State Abbreviation","description":"Two-character unique identifier for a U.S. state or territory","type":"text","sortOrder":14,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"ae0c84ea-4b7c-448f-b1f8-fc33aaf447a0","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"472858279b36f19c4107f3a85907c06293a1d4a2","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"stateNumberCode","title":"State Number Code","description":"Unique identifier for a U.S. state or territory; this identifier makes up the first two digits of a five digit Federal Information Processing Standard (FIPS) Code","type":"text","sortOrder":15,"isSearchable":true,"isNestedObject":false,"isNullable":true,"primaryKey":false,"id":"e4dc4aaf-15fc-4654-b750-021bcead4cce","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"67c069b4a222959291543a9c341c04fb6c47aa99","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"projectAmount","title":"Project Amount","description":"The estimated total cost of the Public Assistance grant project in dollars, without administrative costs. This amount is based on the damage survey.","type":"decimal(13,2)","sortOrder":16,"isSearchable":true,"isNestedObject":false,"isNullable":true,"primaryKey":false,"id":"f8921e74-5e4b-42eb-be47-7c57677f2b94","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"307c38c7a302a7ab3eb407a3ac25652d11f544fe","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"federalShareObligated","title":"Federal Share Obligated","description":"The Public Assistance grant funding available to the grantee (State) in dollars, for sub-grantee's approved Project Worksheets","type":"decimal(13,2)","sortOrder":17,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"0f79209f-5c93-421a-8908-5c1c05a904fc","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"4bc66ceb09edc6182a8a8cb31c8ec887ea0412a5","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"totalObligated","title":"Total Obligated","description":"The federal share of the Public Assistance grant eligible project amount in dollars, plus grantee (State) and sub-grantee (applicant) administrative costs. The federal share is typically 75% of the total cost of the project","type":"decimal(13,2)","sortOrder":18,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"a75f537c-dca8-4f33-a33e-6225bec3151f","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"cc21bf0c25cfe2f1e9f14225c0e6c68940f01cee","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"mitigationAmount","title":"Mitigation Amount","description":"Public Assistance proposed amount that applies to 406 mitigation. Note: does not capture some HMP proposals in the cost lines. Some negative values may exist and are due to adjustments between mitigation costs and project costs, deobligations within versions, and incorrectly categorized mitigation cost lines.","type":"decimal(13,2)","sortOrder":21,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"54e5bb9d-a142-4cb5-af77-8f73929bd6ff","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"db03e0b4bdb3aae88f12f26d95d5c694b7376328","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"lastRefresh","title":"Last Refresh","description":"Date the record was last updated in the API data store","type":"datetimez","sortOrder":24,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"d1e62c84-adac-4d57-b22f-d3fe6c16d2e2","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"d25c464a32e4f1442d7671e10cc20c1e554e1dd8","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"hash","title":"Hash","description":"MD5 Hash of the fields and values of the record","type":"text","sortOrder":25,"isSearchable":false,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"c4e06972-b5b8-40f0-a6b5-54edf393a134","lastRefresh":"2025-07-08T16:21:00.451Z","hash":"0555a40b2d554d2b8e4f6a05a9500f26a68dd6ec","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"lastObligationDate","title":"Last Obligation Date","description":"Date the grant was last obligated","type":"datetime","sortOrder":19,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"0d4dc73a-c1bb-4f74-a91f-a14395f495cd","lastRefresh":"2025-07-09T19:20:56.511Z","hash":"97820e6f4ff34291975572de50bdc1ac26c13df3","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"firstObligationDate","title":"First Obligation Date","description":"Date the grant was initially obligated","type":"datetime","sortOrder":20,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"1fd64caf-ef66-4d19-8ab6-8d1e7b4c9a65","lastRefresh":"2025-07-09T19:20:56.511Z","hash":"b51356e99f3b06ce5d0f3c4436ddc8972e365b27","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"gmProjectId","title":"GM Project Identifier","description":"The numeric project identification number used in GM for individual projects.","type":"bigint","sortOrder":22,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":true,"id":"ff3393a7-4ac6-42d4-b295-770566453e82","lastRefresh":"2025-07-09T19:20:56.511Z","hash":"35adafeda2374e52ac2b2547098c9cbfb1251608","srid":null},{"datasetId":"openfema-89","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":2,"name":"gmApplicantId","title":"GM Applicant Identifier","description":"The numeric applicant identification number used in GM that represents an applicant in a declaration.","type":"bigint","sortOrder":23,"isSearchable":true,"isNestedObject":false,"isNullable":true,"primaryKey":false,"id":"bb7f07f6-36e5-4f5a-ac05-9eb3734b9da1","lastRefresh":"2025-07-09T19:20:56.511Z","hash":"79c6e40a0d12ff45cd4bb1f006a2218004ade46f","srid":null}]}