{"metadata": {"skip":0,"select":null,"rundate":"2026-04-12T11:10:07.526Z","top":1000,"filter":"openFemaDataSet eq 'PublicAssistanceFundedProjectsDetails' and datasetVersion eq 1","format":"json","metadata":true,"orderby":"","entityname":"OpenFemaDataSetFields","version":"v1","url":"/api/open/v1/OpenFemaDataSetFields?%24filter=openFemaDataSet+eq+%27PublicAssistanceFundedProjectsDetails%27+and+datasetVersion+eq+1","count":0}, "OpenFemaDataSetFields": [{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"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":"2feda1ff-6d18-4b6f-a702-e3b4edc71a7f","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"85bb614bb7e98d35e3ed004b983517f28aa98a7c","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"incidentType","title":"Incident Type","description":"Short description of the disaster cause or hazard identified in the Major Disaster event declaration or Emergency declaration such as fire or flood.","type":"text","sortOrder":3,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"3cd094d3-fbc7-421b-ada0-b0817bea57de","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"cc18c4aabd563794f0849c2da77493d81d2c4168","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"pwNumber","title":"Project Worksheet Number","description":"Sequentially assigned number used to identify a unique project","type":"smallint","sortOrder":4,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"2525e6de-c73d-40e8-90fc-856393f6516a","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"e57cefd3eb55470b643c6d92fdf5c0215aa09f68","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"applicantId","title":"Applicant ID","description":"Unique Public Assistance applicant identification number","type":"text","sortOrder":6,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"c741ed4f-762b-4f38-a0f7-4a4cf570ae90","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"e8664f220fc6d880043c1334ab8df03bafba8ae6","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"damageCategoryCode","title":"Damage Category Code","description":"Description of 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":"d28bb0ed-0996-4877-8acd-88ec789f0e88","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"40bc5ff024f949e94d5b2f6bbf5d871754e4717f","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"projectSize","title":"Project Size","description":"FEMA categorizes projects as small or large, based on an evaluation of the project cost and a yearly adjusted threshold value. Project size can affect a number of variables in case management (processing). Threshold values can be found here: https://www.fema.gov/assistance/public/tools-resources/per-capita-impact-indicator","type":"text","sortOrder":8,"isSearchable":true,"isNestedObject":false,"isNullable":true,"primaryKey":false,"id":"9de17c13-c0bc-4659-a035-8661e3e841ce","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"e019b42fc8c832d647ca2f03bed999d42fef1ef0","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"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":9,"isSearchable":true,"isNestedObject":false,"isNullable":true,"primaryKey":false,"id":"6834da49-ae12-40c0-b551-797273b97f1e","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"f6d45604430c82464c8fd03d8d6974e3e3a51e3e","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"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":14,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"662e67b9-39a2-43ea-a61f-396181e10ae9","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"6bb72506f6dc6f9ce71e005d7282c5cd205d5988","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"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":15,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"6cea5821-82f8-4427-9159-6c3b71c991bd","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"a2adc7f866127685f6d3620af0dd60f3c737d0e3","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"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":16,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"4e1f7cf7-8f12-41a4-bca6-7bf3a1d53245","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"069d7d88be8c197eb460752ce7b1f5540f9c30bd","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"mitigationAmount","title":"Mitigation Amount","description":"Public Assistance proposed amount (this amount is before any cost share reduction) 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":18,"isSearchable":true,"isNestedObject":false,"isNullable":true,"primaryKey":false,"id":"5a266fea-5368-43f5-9054-54a5d17af90d","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"fcd90a24285ea82da8fe6418774be849c77b5ecf","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"dcc","title":"Damage Category Code","description":"Damage category code related to the Damage Category Description","type":"text","sortOrder":19,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"1e13112f-8819-4937-b80e-4f8301377657","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"b824b64eac7e0fa368ef53512a41f264c8a22cd1","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"damageCategory","title":"Damage Category Description","description":"Description of 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":20,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"2c74c9c1-1c92-409e-85bc-3a17a29aa17d","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"a67a9458ee57961316530a3dddea5af718443f8f","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"lastRefresh","title":"Last Refresh","description":"Date the record was last updated in the API data store","type":"datetimez","sortOrder":21,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"1a172eaa-15a1-47d7-87cc-bf8761a59b72","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"d2a922ac2d9d52c494790734eb08b57700c136d0","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"hash","title":"Hash","description":"MD5 Hash of the fields and values of the record","type":"text","sortOrder":22,"isSearchable":false,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"378ac4b2-7613-46c3-9298-9bc3d34713a9","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"4d2ee54bd719d9bcdf2410929e1d2026b23d46b1","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"id","title":"ID","description":"Unique ID assigned to the record","type":"uuid","sortOrder":23,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"b8257f28-c342-485a-9e4c-38252b6b010a","lastRefresh":"2025-03-05T19:40:42.525Z","hash":"d3eb69ee1242133c785b484c513fa28ff16d136d","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"declarationDate","title":"Declaration Date","description":"Date the disaster was declared","type":"date","sortOrder":2,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"3e88be41-6615-490a-a9dc-a6e08b0727c6","lastRefresh":"2024-08-27T19:21:04.454Z","hash":"931d47a1dc89718026a3a2f4673e994c450fb99d","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"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":"d1ffa2fb-8ec0-4a6d-96c8-8854aa1bd81e","lastRefresh":"2024-08-27T19:21:04.454Z","hash":"18f3e9fefd99dc893a1ea812901d9941cdd09b01","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"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":10,"isSearchable":true,"isNestedObject":false,"isNullable":true,"primaryKey":false,"id":"c5b3e786-eced-4883-b638-7aeea5c06045","lastRefresh":"2024-08-27T19:21:04.454Z","hash":"c90bf4a1084a483bad90f13465e29440042b91e3","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"state","title":"State","description":"The name of a U.S. state or territory","type":"text","sortOrder":11,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"720948d5-441e-4b1b-bde2-a298a9336d13","lastRefresh":"2024-08-27T19:21:04.454Z","hash":"0895041358c915be3154d423f70eca68760265e6","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"stateCode","title":"State Code","description":"Two-character unique identifier for a U.S. state or territory","type":"text","sortOrder":12,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"adf3a010-e774-4a63-82ef-2423d10f9d2c","lastRefresh":"2024-08-27T19:21:04.454Z","hash":"fff2c6c05420ead183eb83b3cb736e7f83a2c02b","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"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":13,"isSearchable":true,"isNestedObject":false,"isNullable":false,"primaryKey":false,"id":"1c6d3327-eede-4aa8-96b9-5dfed30fba77","lastRefresh":"2024-08-27T19:21:04.454Z","hash":"2bd4cb7fd5f9687b879ddf36c78b0eceb7ba3e83","srid":null},{"datasetId":"openfema-2","openFemaDataSet":"PublicAssistanceFundedProjectsDetails","datasetVersion":1,"name":"obligatedDate","title":"Latest Obligation Date","description":"Most recent date the grant had an obligation","type":"date","sortOrder":17,"isSearchable":true,"isNestedObject":false,"isNullable":true,"primaryKey":false,"id":"7ea86dac-62fb-4f53-a8a3-b07077ecc32c","lastRefresh":"2025-04-01T20:00:48.996Z","hash":"781c53baed27ce9794ee1f11de6c5fef3c0e380e","srid":null}]}