{"text_format":"3","workbook":"xlsx","n_sheets":21,"sheets":["Contents","Indicators","A1_OCC","B1a_GEO","B1b_SOC","B2a_HZD","B3_GEO","C1_POP_HZD","C2_POP_GEO","C3_POP_SOC","D1a_MAT_PHY_HZD","D1b_MAT_PHY_GEO","D2a_MAT_SER_HZD","D2b_MAT_SER_GEO","E1a_MAT_MON_HZD","E1b_MAT_MON_GEO","F1_Agr","G1_ENV_HZD","G2_ENV_GEO","DRRE_Activities","DRRE_Transfers"],"not_rendered":{"images":2,"defined_names":17},"read":"whole","date_system":"1900"}

{"sheet":"Contents","index":0,"n_rows":46,"n_cols":3,"rows_kept":46,"merged":[[1,0,1,12],[2,0,2,12],[5,1,5,13],[6,1,6,13],[7,1,7,13],[12,1,12,13],[18,1,18,13],[23,1,23,13],[30,1,30,13],[34,1,34,13],[37,1,37,13],[41,1,41,13],[45,1,45,13]]}
[]
["Draft Disaster Related Statistics Framework (DRSF)"]
["Basic Range Summary Tables (updated) May  2017"]
[]
[null,"General Notes on Tables"]
[null,"Statistical tables are organised into worksheets according to basic components in the DSRF. The\nvariables represent queries from a disaster-related statistics database. The tables are\ncomprehensive of the Basic Range of Disaster-related Statistics and can be used by national\nagencies as a tool for assessing gaps and identifying opportunities to produce new statistics for\ndisaster risk reduction."]
[null,"Geo regions are officially designated geographic regions of relevance to the reporting, such as\nnational (aggregate), regional or province (admin 02), district (admin 03), or other geographic\nregions important to the compilation or analysis, e.g. river catchments."]
[null,"The relevant time period varies by tables and according to the analysis. For most impact statistics,\na time period of at least 3-5 years is the most relevant given randomness and large year-to-year\nfluctuations in disaster occurrences and their impacts. DRRE tables, on the other hand, should be\ncompiled annually, as with other national accounts."]
[]
[null,"Links to Tables"]
[null,"A","Summary tables of disaster occurrences"]
[null,"A1","Summary table of  disaster occurecnces,  by hazards types, scale, and geographic region"]
[null,"A_OCC tables count  numbers of occurrences according to the hazards, scale and geographical classifications.  Disaster occurrences are background statistics, i.e. they are useful for providing context variable for statistics in other tables "]
[null,"B","Selected Background Statistics and Exposure to hazards"]
[null,"B1a","Population Background Statistics and Hazard Exposure  by geographic regions"]
[null,"B1b","Population Exposure by social groups"]
[null,"B2","Exposure of  Land and Infrastructrue by Hazard Type "]
[null,"B3","Coping Capacity Background Statistics"]
[null,"B_BKGRD tables are for  assessing availability of background statistics (sometimes also called \"baseline statistics\") as well as  hazard exposure statistics, which are compiled prior to disaster occurrrences, and updated over time according to the relevant categories (hazard types and geographic zonings). Exposure  statistics serve multiple purposes,  in particular for calculating indicators of risk, as well for assessing impacts."]
[null,"C","Summary tables of human impacts"]
[null,"C1","Summary table of human impacts by hazards types"]
[null,"C2","Summary table of human impacts by  geographic regions"]
[null,"C3","Summary table of human impacts by demographic  and social categories"]
[null,"C_POP tables are for compiling data related to affected populations (direct impacts on humans) according to hazard types, geographic regions (national total, regions/states,  municipalities, or river catchements), and demographic and social categories (age, gender, urban and rural, poor, and disabled) . Selected optional sub-categories of impacts (e.g major or minor injuries) are included in the table for compilation and compilers may wish to insert additional sub-categories according to the data availability and  demand for statistics."]
[null,"D","Summary tables of direct material impacts in physical terms"]
[null,"D1a","Summary table of direct material impacts by hazards types"]
[null,"D1b","Summary table of direct material impacts by hazards types and geographic regions"]
[null,"D1c","Summary of agricultural impacts by haard typse and geographics regions"]
[null,"D2a","Disruption of basic services from a Disaster by hazard type"]
[null,"D2b","Disruption of basic services from a Disaster, by geographic region"]
[null,"The supplemental category of \"critical infrastructure\" are included in the tables as an\ninitial proposal for measuring the critical material impacts of disasters from the disaster risk\nreduction perspective."]
[null,"E","Summary tables of direct material impacts in monetary terms"]
[null,"E1a","Summary table of direct material impacts by hazards types"]
[null,"E1b","Summary table of direct material impacts by hazards types and geographic regions"]
[null,"E_MAT tables mostly replicate the D_MAT tables and are for recording theimpacts in  monetary values, when it is relevant and possible,  in order to calculated the direct economic losses, aligned with the Sendai Framework defition."]
[null,"F","Agriculture"]
[null,"F1","Summary of material impacts to Agricultrue by hazards types "]
[null,"F1_Agr wasdeveloped by FAO in alignment with rerquirements for Senadi Framework monitoring and for presentation in DRSF."]
[null,"G","Summary tables of direct environmental impacts"]
[null,"G1","Summary table of direct environmental impacts by hazards types"]
[null,"G2","Summary table of direct environmental impacts by hazards types and geographic  regions"]
[null,"G_ENV tables extend the compilations on direct material impacts to include impacts to the environment."]
[null,"DRRE","Disaster risk reduction expenditure account"]
[null,"DRRE_Activ.","Production expenditure account (current plus investment) by characteristic activities"]
[null,"DRRE_Trans.","Transfers expenditure account and DRR National Expenditure"]
[null,"DRRE: The DRRE satellite accounting tables are to assess the feasibility for compiling DRR expenditure accounts based on existing data sources (where possible,  asused in the national accounts) or based on reporting from NDMA and othe partner agencies."]

{"sheet":"Indicators","index":1,"n_rows":60,"n_cols":4,"rows_kept":60,"merged":[[0,0,0,2],[0,3,0,6],[2,2,2,3],[10,2,10,3],[17,2,17,3],[25,2,25,3],[31,2,31,3],[37,2,37,3],[41,2,41,3],[53,2,53,3]]}
["Indicators"]
["SDG","-","Sendai Framework"]
["1.5.1",null,"Number of deaths and missing persons attributed to disasters, per 100,000 population."]
[null,null,"A-1 (compound)"]
[null,null,"A-2","Number of deaths attributed to disasters, per 100,000 population."]
[null,null,"A-3","Number of missing persons attributed to disasters, per 100,000 population."]
[]
[]
["1.5.1",null,"Baseline Statistics (Population)"]
[]
["1.5.1",null,"Number of directly affected people attributed to disasters, per 100,000 population."]
[null,null,"B-1 (compound)"]
[null,null,"B-2","Number of injured or ill people attributed to disasters, per 100,000 population."]
[null,null,"B-3","Number of people whose damaged dwellings were attributed to disasters."]
[null,null,"B-4","Number of people whose destroyed dwellings were attributed to disasters."]
[null,null,"B-5","Number of people whose livelihoods were disrupted or destroyed, attributed to disasters."]
[]
["1.5.2",null,"Direct economic loss attributed to disasters in relation to global gross domestic product."]
[null,null,"C-1 (compound)"]
[null,null,"C-2","Direct agricultural loss attributed to disasters."]
[null,null,"C-3","Direct economic loss to all other damaged or destroyed productive assets attributed to disasters."]
[null,null,"C-4","Direct economic loss in the housing sector attributed to disasters."]
[null,null,"C-5","Direct economic loss resulting from damaged or destroyed critical infrastructure attributed to disasters."]
[null,null,"C-6","Direct economic loss to cultural heritage damaged or destroyed attributed to disasters."]
[]
[null,null,"Damage to critical infrastructure attributed to disasters."]
[null,null,"D-1 (compound)"]
[null,null,"D-2","Number of destroyed or damaged health facilities attributed to disasters."]
[null,null,"D-3","Number of destroyed or damaged educational facilities attributed to disasters."]
[null,null,"D-4","Number of other destroyed or damaged critical infrastructure units and facilities attributed to disasters."]
[]
[null,null,"Number of disruptions to basic services attributed to disasters."]
[null,null,"D-5 (compound)"]
[null,null,"D-6","Number of disruptions to educational services attributed to disasters."]
[null,null,"D-7","Number of disruptions to health services attributed to disasters."]
[null,null,"D-8","Number of disruptions to other basic services attributed to disasters."]
[]
[null,null,"Number of countries with national and local disaster risk reduction strategies"]
["1.5.3",null,"E-1","Number of countries that adopt and implement national disaster risk reduction strategies in line with the Sendai Framework for Disaster Risk Reduction 2015-2030."]
["1.5.4",null,"E-2","Percentage of local governments that adopt and implement local disaster risk reduction strategies in line with national strategies."]
[]
["17 (partial overlap)",null,"Substantially enhance international cooperation to developing countries by 3030"]
[null,null,"F-1","Total official international support, (official development assistance (ODA) plus other official flows), for national disaster risk reduction actions."]
[null,null,"F-2","Total official international support (ODA plus other official flows) for national disaster risk reduction actions provided by multilateral agencies."]
[null,null,"F-3","Total official international support (ODA plus other official flows) for national disaster risk reduction actions provided bilaterally."]
[null,null,"F-4","Total official international support (ODA plus other official flows) for the transfer and exchange of disaster risk reduction-related technology."]
[null,null,"F-5","Number of international, regional and bilateral programmes and initiatives for the transfer and exchange of science, technology and innovation in disaster risk reduction for developing countries."]
[null,null,"F-6","Total official international support (ODA plus other official flows) for disaster risk reduction capacity-building."]
[null,null,"F-7","Number of international, regional and bilateral programmes and initiatives for disaster risk reduction-related capacity-building in developing countries."]
[null,null,"F-8","Number of developing countries supported by international, regional and bilateral initiatives to strengthen their disaster risk reduction-related statistical capacity."]
[]
["11.c.1 ",null,null,"Proportion of financial support to the least developed countries that is allocated to the construction and retrofitting of sustainable, resilient and resource-efficient buildings utilizing local materials"]
[]
[null,null,"Number of countries that have multi-hazard early warning systems."]
[null,null,"G-1 (compound G2-G5)"]
[null,null,"G-2","Number of countries that have multi-hazard monitoring and forecasting systems."]
[null,null,"G-3","Number of people per 100,000 that are covered by early warning information through local governments or through national dissemination mechanisms."]
[null,null,"G-4","Percentage of local governments having a plan to act on early warnings. "]
[null,null,"G-5","Number of countries that have accessible, understandable, usable and relevant disaster risk information and assessment available to the people at the national and local levels."]
[null,null,"G-6","Percentage of population exposed to or at risk from disasters protected through pre-emptive evacuation following early warning."]

{"sheet":"A1_OCC","index":2,"n_rows":20,"n_cols":26,"rows_kept":20,"merged":[[6,1,7,1],[6,2,6,5],[6,6,6,9],[6,10,6,13],[6,14,6,17],[6,18,6,21],[6,22,6,25],[17,1,17,25],[18,1,18,25]]}
[]
[]
["A","Summary of disaster occurrences"]
["A1","Summary table of  disaster occurecnces,  by hazards types, scale, and geographic region"]
[null,"Measurement units: counts of occurrences"]
[]
[null,null,"Geo Region 1",{"$nulls":3},"Geo Region 2",{"$nulls":3},"Geo Region 3",{"$nulls":3},"…",{"$nulls":3},"Adjustment for multiple counting of events by regions/states (-)",{"$nulls":3},"Adj. National total"]
[null,null,"Large","Medium","Small (Local scale)","Total","Large","Medium","Small (local scale)","Total","Large","Medium","Small (Local scale)","Total","Large","Medium","Small (Local scale)","Total ","Large","Medium","Small (Local scale)","Total","Very large events","National scale medium to large events","Small (Local scale)","Total"]
[null,"Geo-physical"]
[null,"Hydrological"]
[null,"Meteorological & Climatalogical"]
[null,"Biological"]
[null,"Other"]
[null,"Total"]
[]
[]
[null,"Data source: NDMA, national register of disaster occurrences, according to official  national designation"]
[null,"International defintion for a disaster: \"A serious disruption of the functioning of a community or a society at any scale due to hazardous events interacting with conditions of exposure, vulnerability and capacity, leading to one or more of the following: human, material, economic and environmental losses and impacts.” (UNGA, 2015)"]
[null,"Suggested variable for  classifying scale of disasters: geographic scope of  emergency (e.g. local scale, province-level, or national  emergency). Generally, Large disasters  are prone to extensive individual reporting while other events are reported on a statistical basis. The difference  between calls for emergency  at national and other scales will depend on the national context. "]
[null,"Adjusted National Total  columns refers to the national total for number of disaster events, by scale and hazard type, adjusting for multiple counts across geographic regions. "]

{"sheet":"B1a_GEO","index":3,"n_rows":38,"n_cols":9,"rows_kept":38,"merged":[[5,1,6,2],[5,3,5,7],[37,2,38,7]]}
[]
["B","Selected Background Statistics and Exposure to hazards"]
["B1a","Population Background Statistics and Hazard Exposure  by geographic regions"]
[null,"Measurement units: see column at right"]
[]
[{"$nulls":3},"Region"]
[{"$nulls":3},"Geo. Region 1","Geo. Region 2","Geo. Region 3","…","NATIONAL TOTAL","Measurement Unit"]
[null,1,"Population","SDG 1.5.1, Sendai A1,B1","SDG 1.5.1, Sendai A1,B1","SDG 1.5.1, Sendai A1,B1","SDG 1.5.1, Sendai A1,B1","SDG 1.5.1, Sendai A1,B1","No. of people"]
[null,1.1,"Children under 5 years",{"$nulls":5},"No. of people"]
[null,1.2,"Persons over 60 years",{"$nulls":5},"No. of people"]
[null,1.4,"Persons with disabilities"]
[null,2,"Households",{"$nulls":5},"No. of households"]
[null,3,"Median Households disposable income",{"$nulls":5},"currency"]
[null,3.1,"Local currency (NAME...)",{"$nulls":5},"currency"]
[null,3.2,"US$ PPP",{"$nulls":5},"US$ PPP"]
[null,4,"GDP","SDG 1.5.2","SDG 1.5.2","SDG 1.5.2","SDG 1.5.2","SDG 1.5.2","currency"]
[null,4.1,"Local currency (NAME...)",{"$nulls":5},"currency"]
[null,4.2,"US$ PPP",{"$nulls":5},"US$ PPP"]
[null,5,"Population in Hazard Area",{"$nulls":5},"No. of people"]
[null,5.1,"Geophysical"]
[null,"5.1.1","High exposure",{"$nulls":5},"No. of people"]
[null,"5.1.2","Moderate exposure",{"$nulls":5},"No. of people"]
[null,"5.1.3","Low exposure",{"$nulls":5},"No. of people"]
[null,5.2,"Hydrological"]
[null,"5.2.1","High exposure",{"$nulls":5},"No. of people"]
[null,"5.2.2","Moderate exposure",{"$nulls":5},"No. of people"]
[null,"5.2.3","Low exposure",{"$nulls":5},"No. of people"]
[null,5.3,"Meteorological & Climatological"]
[null,"5.3.1","High exposure",{"$nulls":5},"No. of people"]
[null,"5.3.2","Moderate exposure",{"$nulls":5},"No. of people"]
[null,"5.3.3","Low exposure",{"$nulls":5},"No. of people"]
[null,5.4,"Other [specify]"]
[null,"5.4.1","High exposure",{"$nulls":5},"No. of people"]
[null,"5.4.2","Moderate exposure",{"$nulls":5},"No. of people"]
[null,"5.4.3","Low exposure",{"$nulls":5},"No. of people"]
[]
[null,null,"Data sources: Joint work of NSO and NDMA, background statsitics derived from NSO and from  national acccounts;  exposure to hazards calculated by NDMA"]
[null,null,"Exposure is measured according to hazard area maps, produced using a variety of physical data inputs (see Chapter 2). Hazard maps are overlayed with social and economic statistics to estimate exposure. The ranking (high, moderate, low) refer to hazard propabilities - for example flood hazards are usually higher closer to the sources and depending on the slope and features of the terrain. The hazard may exist at lower probabilities, farther away."]

{"sheet":"B1b_SOC","index":4,"n_rows":35,"n_cols":20,"rows_kept":35,"merged":[[6,1,7,2],[6,3,6,6],[6,7,7,7],[6,9,6,10],[6,11,7,11],[6,13,6,14],[6,15,7,15],[6,17,6,18],[6,19,7,19],[33,2,33,8],[34,2,34,12]]}
[]
[]
["B","Selected Background Statistics and Exposure to hazards"]
["B1b","Population Exposure  by social groups"]
[null,"Measurement units: Number of people"]
[]
[{"$nulls":3},"C2a1 - Age groups",{"$nulls":3},"TOTAL",null,"C2a2 - Sex",null,"TOTAL",null,"C2a3 - Urban/Rural population ",null,"TOTAL",null,"C2a4 - Specific vulnerability groups",null,"NO TOTAL"]
[{"$nulls":3},"0-5","0-15","16-64","65+",null,null,"Male","Female",null,null,"Urban","Rural",null,null,"Disabled","Poor"]
[null,1,"Population",null,"SDG 1.5.1, Sendai A1,B1","SDG 1.5.1, Sendai A1,B1","SDG 1.5.1, Sendai A1,B1","SDG 1.5.1, Sendai A1,B1",null,"SDG 1.5.1, Sendai A1,B1","SDG 1.5.1, Sendai A1,B1","SDG 1.5.1, Sendai A1,B1",null,"SDG 1.5.1, Sendai A1,B1","SDG 1.5.1, Sendai A1,B1","SDG 1.5.1, Sendai A1,B1",null,"SDG 1.5.1, Sendai A1,B1","SDG 1.5.1, Sendai A1,B1"]
[null,2,"Population in Hazard Areas"]
[null,2.1,"Geophysical"]
[null,"2.1.1","High exposure"]
[null,"2.1.2","Moderate exposure"]
[null,"2.1.3","Low exposure"]
[null,2.2,"Hydrological"]
[null,"2.2.1","High exposure"]
[null,"2.2.2","Moderate exposure"]
[null,"2.2.3","Low exposure"]
[null,"2.3","Biological"]
[null,"2.3.1","High exposure"]
[null,"2.3.2","Moderate exposure"]
[null,"2.3.3","Low exposure"]
[null,"2.4","Meteorological & Climatalogical"]
[null,"2.4.1","High exposure"]
[null,"2.4.2","Moderate exposure"]
[null,"2.4.3","Low exposure"]
[null,"2.5","Other [specify]"]
[null,"2.5.1","High exposure"]
[null,"2.5.2","Moderate exposure"]
[null,"2.5.3","Low exposure"]
[]
[]
[null,null,"Data sources: joint work of NSO and NDMA, background statsitics derived from population and housing census;  maps of hazards calculated by NDMA"]
[null,null,"Links to gloabal indicators: Number of deaths attributed to disasters, per 100,000 population\nThe denominator population could be calculated at different geographic scale (starting from national level), depending on the analysis, including the population in the affected area."]
[null,null,"Exposure is measured according to hazard area maps, produced using a variety of physical data inputs (see Chapter 2). Hazard maps are overlayed with social and economic statistics to estimate exposure."]

{"sheet":"B2a_HZD","index":5,"n_rows":36,"n_cols":10,"rows_kept":36,"merged":[[34,1,34,9]]}
[]
["B","Selected Background Statistics and Exposure to hazards"]
["B2a","Exposure of  Land and Infrastruftrue by Hazard Type "]
[null,"Measurement units: see below table"]
[]
[]
[null,null,"Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","NATIONAL TOTAL",null,"Measuremen Units"]
[1,"Critical infrastructures in Hazard Area"]
[1.1,"Hospitals, health facilities",{"$nulls":7},"buildings, by type"]
[1.2,"Education facilities",{"$nulls":7},"buildings, by type"]
[1.3,"Other critical public administration buildings",{"$nulls":7},"sq m."]
[1.4,"Public Monuments",{"$nulls":7},"sq m."]
["1.4.1","Religious buildings"]
[1.5,"Roads",{"$nulls":7},"km"]
[1.6,"Bridges",{"$nulls":7},"m"]
[1.7,"Airports",{"$nulls":7},"buildings, by type"]
[1.8,"Piers",{"$nulls":7},"facilities, by type"]
[1.9,"Rail Stations",{"$nulls":7},"facilities, by type"]
[{"v":1.1,"d":"1.10"},"Transport equipments",{"$nulls":7},"facilities, by type"]
[1.11,"Electricity generation facilities",{"$nulls":7},"facilities, by type"]
[1.12,"Electricity grids ",{"$nulls":7},"facilities, by type"]
[1.13,"ICT Equipments",{"$nulls":7},"facilities, by type"]
[1.14,"Dams",{"$nulls":7},"facilities, by type"]
[1.15,"Water supply infrastructure",{"$nulls":7},"facilities, by type"]
[1.16,"Water sewage & treatment systems",{"$nulls":7},"facilities, by type"]
[1.17,"Other critical infrastructures"]
[2,"Land"]
[2.1,"Land",{"$nulls":7},"sq km"]
[2.2,"Agricultural land",{"$nulls":7},"sq km"]
[2.3,"Forest Areas",{"$nulls":7},"sq km"]
[2.4,"Built-up areas",{"$nulls":7},"sq km"]
[]
[null,"Data source: Joint work of NDMA and official data source of land cover, land use, and infrastructure maps"]
[null,"Definitions for Critical Infrastructure: See DRSF Classification of Material Impacts (Chapter 8)"]
[null,"Land  defined according to defintion in SEEA Central Framework: \"the space in which economic activities and environmental processes take place and within which environmental assets and economic assets are located.\" Definitions for Agricultural land, forest areas, and built-up areas, see: DRSF Chapter 8."]
[null,"Measurement units:  Chapter 5"]

{"sheet":"B3_GEO","index":6,"n_rows":38,"n_cols":10,"rows_kept":38,"merged":[[13,1,13,2],[17,1,17,2],[22,1,22,2],[26,1,26,2],[33,1,33,2],[36,1,36,9],[37,1,37,9],[38,1,38,6]]}
[]
["B","Disaster Risk Reduction Expenditure Account"]
["B3","Coping Capacity Background Statistics"]
[]
[]
[{"$nulls":3},"Geo Region 1","Geo Region 2","Geo Region 3","…","National",null,"Measurement Units"]
[null,1,"GDP","SDG 1.5.2","SDG 1.5.2","SDG 1.5.2","SDG 1.5.2","SDG 1.5.2",null,"Currency"]
[null,2,"GDP per capita",{"$nulls":6},"Currency"]
[null,3,"Median Households disposable income",{"$nulls":6},"Currency"]
[null,3.1,"Local currency (NAME...)",{"$nulls":6},"Currency"]
[null,3.2,"US$ PPP",{"$nulls":6},"US$ PPP"]
[null,4,"Number of dwellings with slum designation",{"$nulls":6},"no. of units"]
[null,5,"Population living in areas with slum designation",{"$nulls":6},"no. of people"]
[null,"6 Early Warning Systems",{"$nulls":7},"No. of systems"]
[null,6.1,"Population covered","Sendai G-3","Sendai G-3","Sendai G-3","Sendai G-3","Sendai G-3",null,"%"]
[null,6.2,"Share of population in exposure areas covered",{"$nulls":6},"%"]
[null,6.3,"InvestmentExpenditure (also DRRE_A, 3.2)",{"$nulls":6},"Currency"]
[null,"7 Household Preparedness"]
[null,7.1,"Share of households with emergency plan",{"$nulls":6},"%"]
[null,7.2,"Share of households with backup storage of food and water",{"$nulls":6},"%"]
[null,7.3,"Share of households with improved access to water and sanitation ",{"$nulls":6},"%"]
[null,7.4,"Other Preparedness (houehold level)",{"$nulls":6},"%"]
[null,"8 Environmental Resilience"]
[null,8.1,"Forest area",{"$nulls":6},"sq km"]
[null,8.2,"Share of water bodies in good condition",{"$nulls":6},"%"]
[null,8.3,"Other ecosystem condition measures"]
[null,"9 Risk Reduction Activity",{"$nulls":7},"Currency"]
[null,9.1,"Disaster risk reduction characteristic transfers received",{"$nulls":6},"Currency"]
[null,9.2,"Disaster Risk Prevention",{"$nulls":6},"Currency"]
[null,9.3,"Disaster Risk Mitigation",{"$nulls":6},"Currency"]
[null,9.4,"Disaster Management",{"$nulls":6},"Currency"]
[null,9.5,"Disaster Recovery ",{"$nulls":6},"Currency"]
[null,9.6,"General Government, Research & Development, Education Expenditure",{"$nulls":6},"Currency"]
[null,"10 DRRCA Transfers fom Central to local government",{"$nulls":7},"Currency"]
[]
[]
[null,"Data Sources: Household Preparedness from Population and Housing Census and/or household surveys\nForest Area: national land cover statistics\nWater and ecosystem assetments from  national water enviroment protection authorities\nRisk Reduction Activity: Finance Ministry and National Accounts"]
[null,"Definition of Slums: UN-HABITAT (2016) "]

{"sheet":"C1_POP_HZD","index":7,"n_rows":39,"n_cols":9,"rows_kept":39,"merged":[[1,1,1,2],[3,1,3,7],[5,1,6,2],[5,3,5,7],[38,1,38,8]]}
[]
["C","Summary of Human Impacts"]
["C1","Summary table of human impacts by hazards types"]
[null,"Measurement units: Number of people, except 1.5.3, which is number of days"]
[]
[{"$nulls":3},"Hazards"]
[{"$nulls":3},"Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","NATIONAL TOTAL"]
[null,"1 - Summary of Human Impacts"]
[null,null,"Human, affected population"]
[null,1.1,"Deaths or missing","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1"]
[null,"1.1.1","Deaths","Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2"]
[null,"1.1.2","Missing","Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3"]
[null,1.2,"Injured or ill","Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2"]
[null,"1.2.1","   Major injuries"]
[null,"1.2.2","   Minor injuries"]
[null,"1.2.3","Ilnesses"]
[null,1.3,"Displaced"]
[null,"1.3.1","Permanent relocations due to destroyed dwelling","Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4"]
[null,"1.3.2","Other Displaced"]
[null,1.4,"Dwellings Damaged"]
[null,"1.4.1","Number of people whose houses were damaged due to hazardous events","Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3"]
[null,1.5,"Loss of Jobs/occupations"]
[null,"1.5.1","Direct losses of jobs/occupations in industry and services","Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5"]
[null,"1.5.2","Direct losses of jobs/occupations in agriculture"]
[null,"1.5.3","Losses of days of activity"]
[null,"1.5.3.1","Direct losses of days of activity in agriculture"]
[null,"1.5.3.2","Direct losses of days of activity in industry and services"]
[null,1.6,"Number of people  evacuated or receiving aid"]
[null,"1.6.1","Number of people who receieved aid. Including food and non-food aid during  a disaster"]
[null,"1.6.2","Supported with evacuation"]
[null,"1.6.3","Non-supported evacuations"]
[null,"1.6.4","Number of people who receieved aid  after  a disaster"]
[null,1.7,"Otherwise affected"]
[null,1.8,"Total Affected Population (no of impacts)","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1"]
[null,1.9,"Multiple counts, individuals (minus)"]
[null,{"v":1.1,"d":"1.10"},"Total Human Impacts (no of people)"]
[]
[null,"Variables 1.4 an 1.3.3 based on measurement of damage and destruction to dwellings (material impacts tables)"]
[null,"Multiple counts is an  adjustment for aggregation in terms of numbe of people (instead of number of impacts), see Chapter 6 for further explanation."]

{"sheet":"C2_POP_GEO","index":8,"n_rows":79,"n_cols":39,"rows_kept":79,"merged":[[3,1,3,7],[5,1,6,2],[5,3,5,9],[5,10,5,16],[5,17,5,23],[5,24,5,30],[5,31,5,38],[36,8,36,14],[38,1,38,17],[41,2,43,12],[44,2,47,12]]}
[]
["C","Summary of Human Impacts"]
["C2","Summary of human impacts by hazard type and geographic regions"]
[null,"Measurement units: Number of people, except 1.5.3, which is number of days"]
[]
[{"$nulls":3},"Geo Region 1",{"$nulls":6},"Geo Region 2",{"$nulls":6},"Geo Region 3",{"$nulls":6},"Geo Region …",{"$nulls":6},"Hazard types/ National Total"]
[{"$nulls":3},"Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","Adjustment for multiple counting of occurneces by types","TOTAL Region  1","Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","Adjustment for multiple counting of events by types","TOTAL Region  2","Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","Adjustment for multiple counting of events by types","TOTAL Region  3","Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","Adjustment for multiple counting of events by types","TOTAL Region  ...","Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","Adjustment for multiple counting of events by types","TOTAL adjustment for multiple counting of events by Regions/States (-)","NATIONAL TOTAL"]
[null,"1 - Summary of Human Impacts"]
[null,1.1,"Deaths or missing","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1",null,"SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1",null,"SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1",null,"SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1",null,"SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1",null,null,"SDG 1.5.1/Sendai A-1"]
[null,"1.1.1","Deaths","Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2",null,"Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2",null,"Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2",null,"Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2",null,"Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2",null,null,"Sendai A-2"]
[null,"1.1.2","Missing","Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3",null,"Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3",null,"Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3",null,"Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3",null,"Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3",null,null,"Sendai A-3"]
[null,1.2,"Injured or ill","Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2",null,"Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2",null,"Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2",null,"Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2",null,"Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2",null,null,"Sendai B-2"]
[null,"1.2.1","   Major injuries"]
[null,"1.2.2","   Minor injuries"]
[null,"1.2.3","Ilnesses"]
[null,1.3,"Displaced"]
[null,"1.3.1","Permanent relocations due to destroyed dwelling","Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4",null,"Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4",null,"Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4",null,"Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4",null,"Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4","Sendai B-4",null,null,"Sendai B-4"]
[null,"1.3.2","Other Displaced"]
[null,1.4,"Dwellings Damaged"]
[null,"1.4.1","Number of people whose houses were damaged due to hazardous events","Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3",null,"Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3",null,"Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3",null,"Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3",null,"Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3","Sendai B-3",null,null,"Sendai B-3"]
[null,1.5,"Loss of Jobs/occupations"]
[null,"1.5.1","Direct losses of jobs/occupations in industry and services","Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5",null,"Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5",null,"Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5",null,"Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5",null,"Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5","Sendai B-5",null,null,"Sendai B-5"]
[null,"1.5.2","Direct losses of jobs/occupations in agriculture"]
[null,"1.5.3","Losses of days of activity"]
[null,"1.5.3.1","Direct losses of days of activity in agriculture"]
[null,"1.5.3.2","Direct losses of days of activity in industry and services"]
[null,1.6,"Number of people  evacuated or receiving aid"]
[null,"1.6.1","Number of people who receieved aid. Including food and non-food aid during  a disaster"]
[null,"1.6.2","Supported with evacuation"]
[null,"1.6.3","Non-supported evacuations"]
[null,"1.6.4","Number of people who receieved aid  after  a disaster"]
[null,1.7,"Otherwise affected"]
[null,1.8,"Affected Population (no of impacts)","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1",null,"SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1",null,"SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1",null,"SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1",null,"SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1",null,null,"SDG 1.5.1/Sendai B-1"]
[null,1.9,"Multiple counts, individuals (minus)"]
[null,{"v":1.1,"d":"1.10"},"Total Human Impactas (no of people)"]
[]
[]
[null,"Variables 1.4 an 1.3.3 based on measurement of damage and destruction to dwellings (material impacts tables)"]
[null,"Multiple counts is an  adjustment for aggregation in terms of numbe of people (instead of number of impacts), see Chapter 6 for further explanation."]
{"$rows_empty":37}
["D1a"]
[]
["D1a"]

{"sheet":"C3_POP_SOC","index":9,"n_rows":40,"n_cols":20,"rows_kept":40,"merged":[[1,1,1,2],[5,1,6,2],[5,3,5,6],[5,7,6,7],[5,9,5,10],[5,11,6,11],[5,13,5,14],[5,15,6,15],[5,17,5,18],[5,19,6,19],[39,1,39,18]]}
[]
["C","Summary of Human Impacts"]
["C3","Summary table of affected population by demogaphic and social categories"]
[null,"Measurement units:  Number of people, except 1.5.3, which is number of days"]
[]
[{"$nulls":3},"C3a1 - Age groups",{"$nulls":3},"TOTAL",null,"C3a2 - Sex",null,"TOTAL",null,"C3a3 - Urban/Rural population ",null,"TOTAL",null,"C3a4 - Specific vulnerability groups",null,"NO TOTAL"]
[{"$nulls":3},"0-5","0-15","15-64","65+",null,null,"Male","Female",null,null,"Urban","Rural",null,null,"Disabled","Poor"]
[null,"1 -Summary of Human Impacts"]
[null,null,"Human, affected population"]
[null,1.1,"Deaths or missing",null,"SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1",null,"SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1",null,"SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1",null,"SDG 1.5.1/Sendai A-1","SDG 1.5.1/Sendai A-1"]
[null,"1.1.1","Deaths",null,"Sendai A-2","Sendai A-2","Sendai A-2","Sendai A-2",null,"Sendai A-2","Sendai A-2","Sendai A-2",null,"Sendai A-2","Sendai A-2","Sendai A-2",null,"Sendai A-2","Sendai A-2"]
[null,"1.1.2","Missing",null,"Sendai A-3","Sendai A-3","Sendai A-3","Sendai A-3",null,"Sendai A-3","Sendai A-3","Sendai A-3",null,"Sendai A-3","Sendai A-3","Sendai A-3",null,"Sendai A-3","Sendai A-3"]
[null,1.2,"Injured or ill",null,"Sendai B-2","Sendai B-2","Sendai B-2","Sendai B-2",null,"Sendai B-2","Sendai B-2","Sendai B-2",null,"Sendai B-2","Sendai B-2","Sendai B-2",null,"Sendai B-2","Sendai B-2"]
[null,"1.2.1","   Major injuries"]
[null,"1.2.2","   Minor injuries"]
[null,"1.2.3","Ilnesses"]
[null,1.3,"Displaced"]
[null,"1.3.1","Permanent relocations due to destroyed dwelling","Sendai B-4",null,null,"Sendai B-4","Sendai B-4",null,"Sendai B-4","Sendai B-4","Sendai B-4",null,"Sendai B-4","Sendai B-4","Sendai B-4",null,"Sendai B-4","Sendai B-4"]
[null,"1.3.2","Other Displaced"]
[null,1.4,"Dwellings Damaged"]
[null,"1.4.1","Number of people whose houses were damaged due to hazardous events","Sendai B-3",null,null,"Sendai B-3","Sendai B-3",null,"Sendai B-3","Sendai B-3","Sendai B-3",null,"Sendai B-3","Sendai B-3","Sendai B-3",null,"Sendai B-3","Sendai B-3"]
[null,1.5,"Loss of Jobs/occupations"]
[null,"1.5.1","Direct losses of jobs/occupations in industry and services","Sendai B-5",null,null,"Sendai B-5","Sendai B-5",null,"Sendai B-5","Sendai B-5","Sendai B-5",null,"Sendai B-5","Sendai B-5","Sendai B-5",null,"Sendai B-5","Sendai B-5"]
[null,"1.5.2","Direct losses of jobs/occupations in agriculture"]
[null,"1.5.3","Losses of days of activity"]
[null,"1.5.3.1","Direct losses of days of activity in agriculture"]
[null,"1.5.3.2","Direct losses of days of activity in industry and services"]
[null,1.6,"Number of people  evacuated or receiving aid"]
[null,"1.6.1","Number of people who receieved aid. Including food and non-food aid during  a disaster"]
[null,"1.6.2","Supported with evacuation"]
[null,"1.6.3","Non-supported evacuations"]
[null,"1.6.4","Number of people who receieved aid  after  a disaster"]
[null,1.7,"Otherwise affected"]
[null,1.8,"Affected Population (no of impacts)","SDG 1.5.1/Sendai B-1",null,null,"SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1",null,"SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1",null,"SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1",null,"SDG 1.5.1/Sendai B-1","SDG 1.5.1/Sendai B-1"]
[null,1.9,"Multiple counts, individuals (minus)"]
[null,{"v":1.1,"d":"1.10"},"Total Human Impactas (no of people)"]
[]
[null,"Urban and rural designations according to national definitions"]
[null,"Designation for 'poor'  according to national poverty line (or, if unavailable, World Bank global absolute poverty line)"]
[null,"Multiple counts is an  adjustment for aggregation in terms of numbe of people (instead of number of impacts), see Chapter 6 for further explanation."]

{"sheet":"D1a_MAT_PHY_HZD","index":10,"n_rows":66,"n_cols":11,"rows_kept":66,"merged":[[5,1,6,2],[5,3,5,8],[65,1,65,10]]}
[]
["D","Summary tables of direct material impacts"]
["D1a","Summary table of direct material impacts by hazards types"]
[null,"Measurement unit: see column at right"]
[]
[{"$nulls":3},"Hazard types"]
[{"$nulls":3},"Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","TOTAL",null,"Measurement unit"]
[null," Direct economic material impacts"]
[null,"1-Direct impacts on fixed assets or consumer durables"]
[null,1.1,"Dwellings (number)",{"$nulls":7},"no. of units"]
[null,"1.1.1","Dwellings destroyed (number)",{"$nulls":7},"no. of units"]
[null,"1.1.2","Dwellings damaged (number)",{"$nulls":7},"no. of units"]
[null,1.2,"Buildings and structures",{"$nulls":7},"sq. km"]
[null,"1.2.1","Critical buildings & structures ","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4",null,"sq. m"]
[null,"1.2.2","Other buildings and structures",{"$nulls":7},"sq. m"]
[null,1.3,"Machinery and equipment"]
[null,"1.3.1","Critical machinery and equipment","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4",null,"no. of units"]
[null,"1.3.2","Other machinery and equipment",{"$nulls":7},"no. of units"]
[null,"1.4","Consumer Durables",{"$nulls":7},"no. of units"]
[null,"2-Direct impacts on valuables (SNA asset definition)"]
[null,2.1,"Art objects, music instruments",{"$nulls":7},"no. of units"]
[null,2.2,"Other valuables",{"$nulls":7},"no. of units"]
[null,"3-Natural resources"]
[null,3.1,"Land, incl. soil",{"$nulls":7},"sq. km"]
[null,3.2,"Agriculture land",{"$nulls":7},"sq. km"]
[null,3.3,"Primary forests",{"$nulls":7},"sq. km"]
[null,3.4,"Livestock",{"$nulls":7},"no. of units"]
[null,3.5,"Fish stocks",{"$nulls":7},"sq. km"]
[null,3.6,"Freshwater",{"$nulls":7},"sq. km"]
[null,3.7,"Other natural resources",{"$nulls":7},"sq. km"]
[null,"4-Critical goods & services"]
[null,4.1,"Inventories (SNA asset definition)"]
[null,"4.1.1","Agriculture (incl. immature crops)",{"$nulls":7},"tons"]
[null,"4.1.2","Inventories/ other products",{"$nulls":7},"tons"]
[null,"5-Critical infrastructures [1.2.1]"]
[null,5.1,"Hospitals, health facilities","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2",null,"no. of units"]
[null,5.2,"Education facilities","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3",null,"no. of units"]
[null,5.3,"Other critical public administration buildings","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4",null,"no. of units"]
[null,5.4,"Public monuments",{"$nulls":7},"no. of units"]
[null,"5.4.1","Religious buildings",{"$nulls":7},"no. of buildings"]
[null,5.5,"Roads",{"$nulls":7},"km"]
[null,5.6,"Bridges",{"$nulls":7},"no. of units"]
[null,5.7,"Railway (includes stations)",{"$nulls":7},"km"]
[null,5.8,"Airports",{"$nulls":7},"no. of units"]
[null,5.9,"Piers ",{"$nulls":7},"no. of units"]
[null,"5.10","Transport equipments",{"$nulls":7},"no. of units"]
[null,5.11,"Electricity generation facilities",{"$nulls":7},"no. of units"]
[null,5.12,"Electricity grids ",{"$nulls":7},"no. of people"]
[null,5.13,"ICT Equipments",{"$nulls":7},"no. of units"]
[null,5.14,"Dams",{"$nulls":7},"no. of units"]
[null,"5.15","Water supply infrastructure",{"$nulls":7},"no. of units"]
[null,"5.16","Water sewage & treatment systems",{"$nulls":7},"no. of units"]
[null,"5.17","Other critical infrastructures (specify)",{"$nulls":7},"no. of units"]
[null,"6 Direct impact on cultural heritage"]
[null,6.1,"Direct impact on cultural heritage zones",{"$nulls":7},"sq. km"]
[null,"6.1.1","UNESCO cultural heritage sites",{"$nulls":7},"sq. km"]
[null,"6.1.2","National cultural heritage designations",{"$nulls":7},"sq. km"]
[null,"6.1.3","Urban heritage",{"$nulls":7},"sq. km"]
[null,"6.1.4","Other heritage designations",{"$nulls":7},"sq. km"]
[null,6.2,"Direct impact on cultural heritage objects"]
[null,"6.2.1","Buildings and monuments",{"$nulls":7},"no. of units"]
[null,"6.2.2","Cultural heritage valuables [2]"]
[null,"6.2.3","Other cultura heritage (please specify)",{"$nulls":7},"no. of units"]
[]
[null,"For definitions see Material Impacts Classification in Chapter 8"]
[null,"Distinguishing between damaged or destroyed is feasible for all variables and may be reported depending on demand.  For the case of dwellings, destroyed dwellings results in displacement wherase a damaged dwelling might be repaired without displacement."]

{"sheet":"D1b_MAT_PHY_GEO","index":11,"n_rows":66,"n_cols":36,"rows_kept":66,"merged":[[1,1,1,2],[5,1,6,2],[5,3,5,8],[5,9,5,14],[5,15,5,20],[5,21,5,26],[5,27,5,33],[64,1,64,10],[65,1,65,10],[66,1,66,10]]}
[]
["D","Summary tables of direct material impacts"]
["D1b","Summary table of direct material impacts by hazards types and geographic regions"]
[null,"Measurement unit: see column at right"]
[]
[{"$nulls":3},"Geo Region 1",{"$nulls":5},"Geo Region 2",{"$nulls":5},"Geo Region 3",{"$nulls":5},"...",{"$nulls":5},"National Total"]
[{"$nulls":3},"Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","TOTAL Geo Region 1","Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","TOTAL Geo  Region 2","Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","TOTAL Geo  Region  3","Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","…","Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","TOTAL adjustment for multiple counting of events by Regions/States (-)","NATIONAL TOTAL",null,"Measurement unit"]
[null," Direct economic material impacts"]
[null,"1-Direct impacts on fixed assets  or consumer durables"]
[null,1.1,"Dwellings (number)",{"$nulls":32},"no. of units"]
[null,"1.1.1","Dwellings destroyed (number)",{"$nulls":32},"no. of units"]
[null,"1.1.2","Dwellings damaged (number)",{"$nulls":32},"no. of units"]
[null,1.2,"Buildings and structures",{"$nulls":32},"sq. km"]
[null,"1.2.1","Critical buildings & structures ","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4",null,"Sendai D-4",null,"sq. m"]
[null,"1.2.2","Other buildings and structures",{"$nulls":32},"sq. m"]
[null,1.3,"Machinery and equipment"]
[null,"1.3.1","Critical machinery and equipment","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4",null,"Sendai D-4",null,"no. of units"]
[null,"1.3.2","Other machinery and equipment",{"$nulls":32},"no. of units"]
[null,"1.4","Consumer Durables",{"$nulls":32},"no. of units"]
[null,"2-Direct impacts on valuables (SNA asset definition)"]
[null,2.1,"Art objects, music instruments",{"$nulls":32},"no. of units"]
[null,2.2,"Other valuables",{"$nulls":32},"no. of units"]
[null,"3-Natural resources"]
[null,3.1,"Land, incl. soil",{"$nulls":32},"sq. km"]
[null,3.2,"Agriculture land",{"$nulls":32},"sq. km"]
[null,3.3,"Primary forests",{"$nulls":32},"sq. km"]
[null,3.4,"Livestock",{"$nulls":32},"no. of units"]
[null,3.5,"Fish stocks",{"$nulls":32},"sq. km"]
[null,3.6,"Freshwater",{"$nulls":32},"sq. km"]
[null,3.7,"Other natural resources",{"$nulls":32},"sq. km"]
[null,"4-Critical goods & services"]
[null,4.1,"Inventories (SNA asset definition)"]
[null,"4.1.1","Agriculture (incl. immature crops)",{"$nulls":32},"tons"]
[null,"4.1.2","Inventories/ other products",{"$nulls":32},"tons"]
[null,"5 Critical infrastructures [1.2], [1.3]"]
[null,5.1,"Hospitals, health facilities","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2","Sendai D-2",null,"Sendai D-2",null,"no. of units"]
[null,5.2,"Education facilities","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3","Sendai D-3",null,"Sendai D-3",null,"no. of units"]
[null,5.3,"Other critical public administration buildings","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4","Sendai D-4",null,"Sendai D-4",null,"no. of units"]
[null,5.4,"Public monuments",{"$nulls":32},"no. of units"]
[null,"5.4.1","Religious buildings",{"$nulls":32},"no. of buildings"]
[null,5.5,"Roads",{"$nulls":32},"km"]
[null,5.6,"Bridges",{"$nulls":32},"no. of units"]
[null,5.7,"Railway (includes stations)",{"$nulls":32},"km"]
[null,5.8,"Airports",{"$nulls":32},"no. of units"]
[null,5.9,"Piers ",{"$nulls":32},"no. of units"]
[null,"5.10","Transport equipments",{"$nulls":32},"no. of units"]
[null,5.11,"Electricity generation facilities",{"$nulls":32},"no. of units"]
[null,5.12,"Electricity grids ",{"$nulls":32},"no. of people"]
[null,5.13,"ICT Equipments",{"$nulls":32},"no. of units"]
[null,5.14,"Dams",{"$nulls":32},"no. of units"]
[null,"5.15","Water supply infrastructure",{"$nulls":32},"no. of units"]
[null,"5.16","Water sewage & treatment systems",{"$nulls":32},"no. of units"]
[null,"5.17","Other critical infrastructures",{"$nulls":32},"no. of units"]
[null,"6 Direct impact on cultural heritage"]
[null,6.1,"Direct impact on cultural heritage zones",{"$nulls":32},"sq. km"]
[null,"6.1.1","UNESCO cultural heritage sites",{"$nulls":32},"sq. km"]
[null,"6.1.2","National cultural heritage designations",{"$nulls":32},"sq. km"]
[null,"6.1.3","Urban heritage",{"$nulls":32},"sq. km"]
[null,"6.1.4","Other heritage designations",{"$nulls":32},"sq. km"]
[null,6.2,"Direct impact on cultural heritage objects"]
[null,"6.2.1","Buildings and monuments",{"$nulls":32},"no. of units"]
[null,"6.2.2","Cultural heritage valuables [2]"]
[null,"6.2.3","Other components",{"$nulls":32},"no. of units"]
[]
[null,"For definitions see Material Impacts Classification in Chapter 8"]
[null,"Distinguishing between damaged or destroyed is feasible for all variables and may be reported depending on demand.  For the case of dwellings, destroyed dwellings results in displacement wherase a damaged dwelling might be repaired without displacement."]

{"sheet":"D2a_MAT_SER_HZD","index":12,"n_rows":35,"n_cols":9,"rows_kept":35,"merged":[[5,1,6,2],[5,3,5,8]]}
[]
["D","Summary tables of direct material impacts"]
["D2a","Disruption of basic services from a Disaster by hazard type"]
[null,"Measurement unit: number of people and period of time"]
[]
[{"$nulls":3},"Hazard types"]
[{"$nulls":3},"Geo-physical","Hydrological","Meteorological & Climatalogical","Biological","Other","TOTAL"]
[null,"Disruptions to Basic services from a Disaster"]
[null,1,"Health services","Sendai D-7","Sendai D-7","Sendai D-7","Sendai D-7","Sendai D-7","Sendai D-7"]
[null,1.1,"No. of people"]
[null,1.2,"Length of time"]
[null,2,"Educational services","Sendai D-6","Sendai D-6","Sendai D-6","Sendai D-6","Sendai D-6","Sendai D-6"]
[null,2.1,"No. of people"]
[null,2.2,"Length of time"]
[null,3,"Public administration services","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8"]
[null,3.1,"No. of people"]
[null,3.2,"Length of time"]
[null,4,"Transport services","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8"]
[null,4.1,"No. of people"]
[null,4.2,"Length of time"]
[null,5,"Electricity and energy services","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8"]
[null,5.1,"No. of people"]
[null,5.2,"Length of time"]
[null,6,"Water services","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8"]
[null,6.1,"No. of people"]
[null,6.2,"Length of time"]
[null,7,"ICT services","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8"]
[null,7.1,"No. of people"]
[null,7.2,"Length of time"]
[null,8,"Other basic services","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8"]
[null,8.1,"No. of people"]
[null,8.2,"Length of time"]
[null,9,"Total disruptions","Sendai D-5","Sendai D-5","Sendai D-5","Sendai D-5","Sendai D-5","Sendai D-5"]
[]
[null,"Definitions of Services: see UNISDR Technical Guidelines for Sendai Framework Indicators or DRSF Chapter 4"]

{"sheet":"D2b_MAT_SER_GEO","index":13,"n_rows":35,"n_cols":9,"rows_kept":35,"merged":[[5,1,6,2],[5,3,5,8]]}
[]
["D","Summary tables of direct material impacts"]
["D2b","Disruption of basic services from a Disaster, by geographic region"]
[null,"Measurement units: number of people and period of time"]
[]
[{"$nulls":3},"Region"]
[{"$nulls":3},"Geo. Region 1","Geo. Region 2","Geo. Region 3","…","Adjustment for multiple counting of events by regions","ADJ NATIONAL TOTAL"]
[null,"Disruptions to Basic services from a Disaster (Sendai D-5)"]
[null,1,"Health services","Sendai D-7","Sendai D-7","Sendai D-7","Sendai D-7",null,"Sendai D-7"]
[null,1.1,"No. of people"]
[null,1.2,"Length of time"]
[null,2,"Educational services","Sendai D-6","Sendai D-6","Sendai D-6","Sendai D-6",null,"Sendai D-6"]
[null,2.1,"No. of people"]
[null,2.2,"Length of time"]
[null,3,"Public administration services","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8",null,"Sendai D-8"]
[null,3.1,"No. of people"]
[null,3.2,"Length of time"]
[null,4,"Transport services","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8",null,"Sendai D-8"]
[null,4.1,"No. of people"]
[null,4.2,"Length of time"]
[null,5,"Electricity and energy services","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8",null,"Sendai D-8"]
[null,5.1,"No. of people"]
[null,5.2,"Length of time"]
[null,6,"Water services","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8",null,"Sendai D-8"]
[null,6.1,"No. of people"]
[null,6.2,"Length of time"]
[null,7,"ICT services","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8",null,"Sendai D-8"]
[null,7.1,"No. of people"]
[null,7.2,"Length of time"]
[null,8,"Other basic services","Sendai D-8","Sendai D-8","Sendai D-8","Sendai D-8",null,"Sendai D-8"]
[null,8.1,"No. of people"]
[null,8.2,"Length of time"]
[null,9,"Total disruptions","Sendai D-5","Sendai D-5","Sendai D-5","Sendai D-5",null,"Sendai D-5"]
[]
[null,"Definitions of Services: see UNISDR Technical Guidelines for Sendai Framework Indicators or DRSF Chapter 4"]

{"sheet":"E1a_MAT_MON_HZD","index":14,"n_rows":93,"n_cols":10,"rows_kept":93,"merged":[[5,1,5,2],[49,1,49,2],[52,1,52,6],[53,1,53,8]]}
[]
["E","Summary tables of direct material impacts in monetary terms"]
["E1a","Direct material impacts by hazards types "]
[null,"Measurement units: national currency (estimated costs for recovery of damages)"]
[]
[{"$nulls":3},"Geo-physical","Hydrological","Meteorological & Climatological","Biological","Other","TOTAL"]
[null,"1-Direct impacts on fixed assets or consumer durables"]
[null,1.1,"Dwellings (number)","Sendai C-4","Sendai C-4","Sendai C-4","Sendai C-4","Sendai C-4","Sendai C-4"]
[null,"1.1.1","Dwellings destroyed (number)"]
[null,"1.1.2","Dwellings damaged (number)"]
[null,1.2,"Buildings and structures"]
[null,"1.2.1","Critical buildings & structures ","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5"]
[null,"1.2.2","Other buildings and structures","Sendai C-3","Sendai C-3","Sendai C-3","Sendai C-3","Sendai C-3","Sendai C-3"]
[null,1.3,"Machinery and equipment"]
[null,"1.3.1","Critical machinery and equipment","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5"]
[null,"1.3.2","Other machinery and equipment"]
[null,"1.4","Consumer Durables"]
[null,"2-Direct impacts on valuables (SNA asset definition)"]
[null,2.1,"Art objects, music instruments"]
[null,2.2,"Other valuables"]
[null,"3-Natural resources"]
[null,3.1,"Land, incl. soil"]
[null,3.2,"Agriculture land (ref F1)","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2"]
[null,3.3,"Restoartion Costs for Primary forests"]
[null,3.4,"Livestock (ref. F1)"]
[null,3.5,"Fish stocks (ref F1)"]
[null,3.6,"Restoration Costs for Freshwater"]
[null,3.7,"Other natural resources"]
[null,"4 Critical infrastructures [1.2], [1.3]"]
[null,4.1,"Hospitals, health facilities","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5"]
[null,"4.1.1","Medical  services during the emergency for people injured or ill "]
[null,4.2,"Education facilities"]
[null,4.3,"Other critical public administration buildings"]
[null,4.4,"Public monuments"]
[null,"4.4.1","Religious buildings"]
[null,4.5,"Roads"]
[null,4.6,"Bridges"]
[null,4.7,"Railway (includes stations)"]
[null,4.8,"Airports"]
[null,4.9,"Ports"]
[null,"4.10","Transport equipments"]
[null,4.11,"Electricity generation facilities"]
[null,4.12,"Electricity grids "]
[null,4.13,"ICT Equipments"]
[null,4.14,"Dams"]
[null,"4.15","Water supply infrastructure"]
[null,"4.16","Water sewage & treatment systems"]
[null,"4.17","Other critical infrastructures"]
[null,"5 Restoration costs for Direct impact on cultural heritage",null,"Sendai C-6","Sendai C-6","Sendai C-6","Sendai C-6","Sendai C-6","Sendai C-6"]
[null,"6 Other direct costs associated with disaster  recovery (e.g. emergency medical services)"]
[null,"7 Total Direct Economic Loss [1.1-1.3 + 2 + 3 + 4]",null,"SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1"]
[]
[null,"Monetary valuation for costs of material impacts normally requires a combination of data sources, particulraly:  assessments for cost of reconstruction,  insurance claims assessments orthe recorded  values of assets prior to a disaster (where available), records of actual transactions for recovery of damages, i.e.  expenditure on post-disaster reconstruction."]
[null,"For definitions, refer to DRSF, Chapter 8 and current interniatonal standards, such as the System of National Accounts (SNA, 2018) "]
{"$rows_empty":38}
[{"$nulls":9},"Sendai C-6"]

{"sheet":"E1b_MAT_MON_GEO","index":15,"n_rows":55,"n_cols":34,"rows_kept":55,"merged":[[5,1,6,2],[5,3,5,8],[5,9,5,14],[5,15,5,20],[5,21,5,26],[5,27,5,33],[50,1,50,2],[54,1,54,6]]}
[]
["E","Summary tables of direct material impacts in monetary terms"]
["E1b","Summary table of direct material impacts by hazards types and geographic regions"]
[null,"Measurement units: national currency (estimated cost of damages)"]
[]
[{"$nulls":3},"Geo Region 1",{"$nulls":5},"Geo Region 2",{"$nulls":5},"Geo Region 3",{"$nulls":5},"Geo Region ...",{"$nulls":5},"Hazard types/ National Total"]
[{"$nulls":3},"Geo-physical","Hydrological","Meteorological & Climatological","Biological","Adjustment for multiple counting of events by types","TOTAL Region/State 1","Geo-physical","Hydrological","Meteorological & Climatological","Biological","Adjustment for multiple counting of events by types","TOTAL Region/State 2","Geo-physical","Hydrological","Meteorological & Climatological","Biological","Adjustment for multiple counting of events by types","TOTAL Region/State 3","Geo-physical","Hydrological","Meteorological & Climatological","Biological","Adjustment for multiple counting of events by types","TOTAL Region/State ...","Geo-physical","Hydrological","Meteorological & Climatological","Biological","Adjustment for multiple counting of events by types","TOTAL adjustment for multiple counting of events by Regions/States (-)","NATIONAL TOTAL"]
[null,"1-Direct impacts on fixed assets  or consumer durables"]
[null,1.1,"Dwellings (number)","Sendai C-4","Sendai C-4","Sendai C-4","Sendai C-4",null,"Sendai C-4","Sendai C-4","Sendai C-4","Sendai C-4","Sendai C-4",null,"Sendai C-4","Sendai C-4","Sendai C-4","Sendai C-4","Sendai C-4",null,"Sendai C-4","Sendai C-4","Sendai C-4","Sendai C-4","Sendai C-4",null,"Sendai C-4","Sendai C-4","Sendai C-4","Sendai C-4","Sendai C-4",null,null,"Sendai C-4"]
[null,"1.1.1","Dwellings destroyed (number)"]
[null,"1.1.2","Dwellings damaged (number)"]
[null,1.2,"Buildings and structures"]
[null,"1.2.1","Critical buildings & structures ","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,null,"Sendai C-5"]
[null,"1.2.2","Other buildings and structures","Sendai C-3","Sendai C-3","Sendai C-3","Sendai C-3",{"$nulls":7},"Sendai C-3","Sendai C-3","Sendai C-3","Sendai C-3","Sendai C-3",null,"Sendai C-3","Sendai C-3","Sendai C-3","Sendai C-3","Sendai C-3",null,"Sendai C-3","Sendai C-3","Sendai C-3","Sendai C-3","Sendai C-3",null,null,"Sendai C-3"]
[null,1.3,"Machinery and equipment"]
[null,"1.3.1","Critical machinery and equipment","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,null,"Sendai C-5"]
[null,"1.3.2","Other machinery and equipment"]
[null,"1.4","Consumer Durables"]
[null,"2-Direct impacts on valuables (SNA asset definition)"]
[null,2.1,"Art objects, music instruments"]
[null,2.2,"Other valuables"]
[null,"3-Natural resources "]
[null,3.1,"Land, incl. soil"]
[null,3.2,"Agriculture land","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,null,"Sendai C-2"]
[null,3.3,"Primary forests"]
[null,3.4,"Livestock"]
[null,3.5,"Fish stocks"]
[null,3.6,"Freshwater"]
[null,3.7,"Other natural resources"]
[null,"4-Critical infrastructures [1.2] & [1.3]"]
[null,4.1,"Hospitals, health facilities","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,null,"Sendai C-5"]
[null,"4.1.1","Medical  services during the emergency for people injured or ill "]
[null,4.2,"Education facilities"]
[null,4.3,"Other critical public administration buildings"]
[null,4.4,"Public monuments"]
[null,"4.4.1","Religious buildings"]
[null,4.5,"Roads"]
[null,4.6,"Bridges"]
[null,4.7,"Railway (includes stations)"]
[null,4.8,"Airports"]
[null,4.9,"Ports"]
[null,"4.10","Transport equipments"]
[null,4.11,"Electricity generation facilities"]
[null,4.12,"Electricity grids "]
[null,4.13,"ICT Equipments"]
[null,4.14,"Dams"]
[null,"4.15","Water supply infrastructure"]
[null,"4.16","Water sewage & treatment systems"]
[null,"4.17","Other critical infrastructures","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,"Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5","Sendai C-5",null,null,"Sendai C-5"]
[null,"5 Restoration costs for Direct impact on cultural heritage",null,"Sendai C-6","Sendai C-6","Sendai C-6","Sendai C-6",null,"Sendai C-6","Sendai C-6","Sendai C-6","Sendai C-6","Sendai C-6",null,"Sendai C-6","Sendai C-6","Sendai C-6","Sendai C-6","Sendai C-6",null,"Sendai C-6","Sendai C-6","Sendai C-6","Sendai C-6","Sendai C-6",null,"Sendai C-6","Sendai C-6","Sendai C-6","Sendai C-6","Sendai C-6",null,null,"Sendai C-6"]
[null,"6 Other direct costs associated with disaster  recovery (e.g. emergency medical services)"]
[null,"7 Total Direct Economic Loss [1.1-1.3 + 2 + 3 + 4]",null,"SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1",null,"SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1",null,"SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1",null,"SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1",null,"SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1","SDG 1.5.2, Sendai C-1",null,null,"SDG 1.5.2, Sendai C-1"]
[]
[null,"Measurement units: national currency (estimated cost of damages)"]
[null,"Monetary valuation for costs of material impacts normally requires a combination of data sources, particulraly: insurance claims assessments or assessments for cost of reconstruction, the recorded  values of assets prior to a disaster (where available), records of actual transactions for recovery of damages, i.e.  expenditure on post-disaster reconstruction, and average costs of crops or other exposed assets for estimating costs of damages based on average per unit values."]

{"sheet":"F1_Agr","index":16,"n_rows":69,"n_cols":11,"rows_kept":69,"merged":[[5,1,6,2],[5,3,5,8],[7,1,7,2],[14,1,14,2],[29,1,29,2],[36,1,36,10]]}
[]
["F","Material impacts to Agriculture"]
["F1","Summary of material impacts to Agricultrue by hazards types "]
[null,"Measurement units: see column at right"]
[]
[{"$nulls":3},"Hazard types"]
[{"$nulls":3},"Geo-physical","Hydrological","Meteorological & Climatological","Biological","Other","TOTAL",null,"Meaurement \nunits"]
[null,"1-Crops"]
[null,1.1,"Area affected by crop type ","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2",null,"hectares"]
[null,"1.2","Stored  produce destroyed","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"tonnes"]
[null,"1.3","Strored inputs destroyed","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"tonnes"]
[null,1.4,"Equipment/machinery destroyed","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"units"]
[null,"1.5","Discounted yield value of perrenial trees until replanting",{"$nulls":7},"currency"]
[null,"1.6","Post-diaster short-run maintenance costs",{"$nulls":7},"currency"]
[null,"2-Livestock",null,"SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2"]
[null,2.1,"Number of animals killed ","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"animals"]
[null,2.2,"Strored products, feed and fodder destroyed","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"tonnes"]
[null,2.3,"Equipment/machinery destroyed","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"units"]
[null,2.4,"Discounted value of livestock products from dead animals until full recovery",{"$nulls":7},"currency"]
[null,2.5,"Post-diaster short-run maintenance costs",{"$nulls":7},"currency"]
[null,"3-Forestry",null,"SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2"]
[null,3.1,"Area damaged or destroyed","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"hectares"]
[null,3.2,"Stored wood volume destroyed","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"tonnes"]
[null,"4-Aquaculture",null,"SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2"]
[null,4.1,"Production from land-based ponds","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"tonnes"]
[null,"4.2","Production from  water based cages and pends","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"tonnes"]
[null,"4.3","Stored production lost","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"tonnes"]
[null,"4.4","Facilities destroyed",{"$nulls":7},"units"]
[null,4.5,"Post-diaster short-run maintenance costs","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"currency"]
[null,"5 - Fisheries",null,"SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2","SDG 1.5.2, Sendai C-2",null,"currency"]
[null,5.1,"Small scale production loss","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"tonnes"]
[null,5.2,"Coastal production loss","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"units"]
[null,5.3,"Industrial (large-scale) production lost","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"tonnes"]
[null,5.4,"Facilities destroyed (fishing gear, engines, vessels, storage, etc.)","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2","Sendai C-2",null,"units"]
[]
[null,"This table was prepared for use in DRSF by FAO Statitics Directorate,  for more information or technical guidance, please contact FAO Statistics, Rome"]
[null,"Definitions according to national pracgtices for agricultgrue statitsics, and current interniatonal standards, such as the System of National Accounts (SNA, 2018) and current standards from FAO: "]
[null,"http://www.fao.org/statistics/standards/en/"]
{"$rows_empty":30}
[{"$nulls":9},"Sendai C-6"]

{"sheet":"G1_ENV_HZD","index":17,"n_rows":42,"n_cols":12,"rows_kept":42,"merged":[[1,1,1,2],[5,1,6,2],[5,3,5,9],[41,1,41,11]]}
[]
["G","Summary tables of direct environmental impacts"]
["G1","Summary table of direct environmental impacts by hazards types at country level"]
[null,"Measurement units: see column at right"]
[]
[{"$nulls":3},"Hazard types"]
[{"$nulls":3},"Geo-physical","Hydrological","Meteorological & Climatological","Biological","Other","Adjustment for multiple counting of events by types","TOTAL",null,"Measurement unit"]
[null,"Direct environmental impact"]
[null,1,"Direct impacts on ecosystems by land cover types"]
[null,1.1,"01 Urban and associated developed areas",{"$nulls":8},"hectares"]
[null,1.2,"02 Homogeneous herbaceous cropland",{"$nulls":8},"hectares"]
[null,1.3,"03 Agriculture plantations, permanent crops",{"$nulls":8},"hectares"]
[null,1.4,"04 Agriculture associations and mosaics",{"$nulls":8},"hectares"]
[null,1.5,"05 Pastures and natural grassland",{"$nulls":8},"hectares"]
[null,1.6,"06 Forest tree cover",{"$nulls":8},"hectares"]
[null,1.7,"07 Shrubland, bushland, heathland",{"$nulls":8},"hectares"]
[null,1.8,"08 Sparsely vegetated areas",{"$nulls":8},"hectares"]
[null,1.9,"09 Natural vegetation associations and mosaics",{"$nulls":8},"hectares"]
[null,"1.10","10 Barren land",{"$nulls":8},"hectares"]
[null,"1.11","11 Permanent snow and glaciers",{"$nulls":8},"hectares"]
[null,1.12,"12 Open wetlands",{"$nulls":8},"hectares"]
[null,1.13,"13 Inland water bodies",{"$nulls":8},"hectares"]
[null,1.14,"14 Coastal water bodies and inter-tidal areas",{"$nulls":8},"hectares"]
[null,2,"Loss of critical ecosystems"]
[null,2.1,"Man And Biosphere and other biological reserves (UNESCO, UNEP)",{"$nulls":8},"hectares"]
[null,2.2,"Other designated ecosystems/habitats",{"$nulls":8},"hectares"]
[null,2.3,"Ecosystems hosting threatened species (IUCN Red List)",{"$nulls":8},"hectares"]
[null,2.4,"Other critical ecosystems",{"$nulls":8},"hectares"]
[null,3,"Losses of natural water resource (quantitative/qualitative)"]
[null,3.1,"Losses due to pollution of natural surface water",{"$nulls":8},"no. of water bodies"]
[null,3.2,"Losses due to pollution of groundwater",{"$nulls":8},"no. of water bodies"]
[null,3.3,"Losses due to destruction of natural surface water reserves",{"$nulls":8},"no. of water bodies"]
[null,3.4,"Losses due to destruction of groundwater reserves",{"$nulls":8},"no. of water bodies"]
[null,4,"Direct impacts to the atmosphere or  climate change"]
[null,4.1,"Emissions of GHGs",{"$nulls":8},"tonnes"]
[null,4.2,"Loss of carbon sequestration capacity",{"$nulls":8},"tonnes"]
[null,4.3,"Other direct impact on global warming"]
[null,4.4,"Emissions of So2",{"$nulls":8},"tonnes"]
[null,4.5,"Emission  of other (non-GHG) air pollutants (specify)",{"$nulls":8},"tonnes"]
[]
[]
[null,"Data sources: Collaboration between national monitoring authorities for land cover, water resources,  and atmospheric conditions with initial impacts assessments of NDMAs after a disaster"]

{"sheet":"G2_ENV_GEO","index":18,"n_rows":41,"n_cols":36,"rows_kept":41,"merged":[[1,1,1,2],[5,1,6,2],[5,3,5,8],[5,9,5,14],[5,15,5,20],[5,21,5,26],[5,27,5,33],[40,1,40,11]]}
[]
["G","Summary tables of direct environmental impacts"]
["G2","Summary table of direct environmental impacts by hazards types and geographic  regions"]
[null,"Measurement units: see column at right"]
[]
[{"$nulls":3},"Geo Region 1",{"$nulls":5},"Geo Region 2",{"$nulls":5},"Geo Region 3",{"$nulls":5},"…",{"$nulls":5}," National Total"]
[{"$nulls":3},"Geo-physical","Hydrological","Meteorological & Climatological","Biological","Other","TOTAL Geo Region  1","Geo-physical","Hydrological","Meteorological & Climatological","Biological","Other","TOTAL Geo Region 2","Geo-physical","Hydrological","Meteorological & Climatological","Biological","Other","TOTAL Geo Region 3","Geo-physical","Hydrological","Meteorological & Climatological","Biological","Other","TOTAL Geo Region...","Geo-physical","Hydrological","Meteorological & Climatological","Biological","Other","TOTAL adjustment for multiple counting of events by Regions/States (-)","ADJ NATIONAL TOTAL",null,"Measurement units"]
[null,"Direct environmental impact"]
[null,1,"Direct impacts on ecosystems by land cover types"]
[null,1.1,"Urban and associated developed areas",{"$nulls":32},"hectares"]
[null,1.2,"Homogeneous herbaceous cropland",{"$nulls":32},"hectares"]
[null,1.3,"Agriculture plantations, permanent crops",{"$nulls":32},"hectares"]
[null,1.4,"Agriculture associations and mosaics",{"$nulls":32},"hectares"]
[null,1.5,"Pastures and natural grassland",{"$nulls":32},"hectares"]
[null,1.6,"Forest tree cover",{"$nulls":32},"hectares"]
[null,1.7,"Shrubland, bushland, heathland",{"$nulls":32},"hectares"]
[null,1.8,"Sparsely vegetated areas",{"$nulls":32},"hectares"]
[null,1.9,"Natural vegetation associations and mosaics",{"$nulls":32},"hectares"]
[null,"1.10","Barren land",{"$nulls":32},"hectares"]
[null,1.11,"Permanent snow and glaciers",{"$nulls":32},"hectares"]
[null,1.12,"Open wetlands",{"$nulls":32},"hectares"]
[null,1.13,"Inland water bodies",{"$nulls":32},"hectares"]
[null,1.14,"Coastal water bodies and inter-tidal areas",{"$nulls":32},"hectares"]
[null,2,"Loss of critical ecosystems"]
[null,2.1,"Man And Biosphere and other biological reserves (UNESCO, UNEP)",{"$nulls":32},"hectares"]
[null,2.2,"Other designated ecosystems/habitats",{"$nulls":32},"hectares"]
[null,2.3,"Ecosystems hosting threatened species (IUCN Red List)",{"$nulls":32},"hectares"]
[null,2.4,"Other critical ecosystems",{"$nulls":32},"hectares"]
[null,3,"Losses of natural water resource (quantitative/qualitative)"]
[null,3.1,"Losses due to pollution of natural surface water",{"$nulls":32},"no. of water bodies"]
[null,3.2,"Losses due to pollution of groundwater",{"$nulls":32},"no. of water bodies"]
[null,3.3,"Losses due to destruction of natural surface water reserves",{"$nulls":32},"no. of water bodies"]
[null,3.4,"Losses due to destruction of groundwater reserves",{"$nulls":32},"no. of water bodies"]
[null,4,"Direct impacts to the atmosphere or  climate change"]
[null,4.1,"Emissions of GHGs",{"$nulls":32},"tonnes"]
[null,4.2,"Loss of carbon sequestration capacity",{"$nulls":32},"tonnes"]
[null,4.3,"Other direct impact on global warming"]
[null,4.4,"Emissions of So2",{"$nulls":32},"tonnes"]
[null,4.5,"Emission  of other (non-GHG) air pollutants (specify)",{"$nulls":32},"tonnes"]
[]
[null,"Data sources: Collaboration between national monitoring authorities for land cover, water resources,  and atmospheric conditions with initial impacts assessments of NDMAs after a disaster"]

{"sheet":"DRRE_Activities","index":19,"n_rows":58,"n_cols":15,"rows_kept":58,"merged":[[5,1,7,2],[5,3,5,13],[5,14,7,14],[6,3,7,3],[6,4,7,4],[6,5,6,8],[6,9,6,11],[6,12,7,12],[6,13,7,13],[57,1,57,2]]}
[]
["DRRE","Disaster Risk Reduction Expenditure Account"]
["DRRE_A","Production expenditure account (current plus investment) by characteristic activities"]
[null,"Measurement units: Local currency"]
[null,"US$ PPP"]
[{"$nulls":3},"Providers of disaster risk reduction services (SNA institutionnal sectors)",{"$nulls":10},"Rest of the World (RoW)"]
[{"$nulls":3},"Non-financial corporations","Financial corporations","General government (incl. non-profit institutions controlled by governments and social security)",{"$nulls":3},"Households",null,null,"Non-profit institutions serving households (NPISHs)","TOTAL Resident sectors (units with at least 1 year of activity) "]
[{"$nulls":5},"Central government","State government","Local government","Subtotal General government","Households owners of unincorporated enterprises","Employees and recipients of property and transfer incomes.","Subtotal Households"]
[null,"Activity expenditure account (current plus investment)"]
[null,"1","Disaster Risk Prevention"]
[null,"1.1","Risk prevention in advance of hazardous event"]
[null,"1.2","Risk prevention in or after hazardous event"]
[null,"2","Disaster Risk Mitigation"]
[null,"2.1","Structural measures",{"$nulls":11},"SDG 11.c.1"]
[null,"2.2","Non-structural measures"]
[null,"2.3","Land-use planning"]
[null,"2.4","Early warning systems management"]
[null,"3","Disaster Management"]
[null,"3.1","Preparedness"]
[null,"3.2","Emergency management"]
[null,"3.3","Other disaster responses"]
[null,"3.4","Emergency supply of commodities"]
[null,"4","Disaster Recovery "]
[null,"4.1","Relocation"]
[null,"4.2","Rehabilitation"]
[null,"4.3","Reconstruction"]
[null,"5","General Government, Research & Development, Education Expenditure"]
[null,"5.1","General government expenditure for Disaster Risk Reduction"]
[null,"5.2","Research & Development, risk assessment, and information"]
[null,"5.3","Education to Disaster Risk Reduction"]
[null,"A","Subtotal current production expenditure (SUM 1 to 5)"]
[null,"1","Disaster Risk Prevention"]
[null,"1.1","Risk prevention in advance of hazardous event"]
[null,"1.2","Risk prevention in or after hazardous event"]
[null,"2","Disaster Risk Mitigation"]
[null,"2.1","Structural measures"]
[null,"2.2","Non-structural measures"]
[null,"2.3","Land-use planning"]
[null,"2.4","Early warning systems management"]
[null,"3","Disaster Management"]
[null,"3.1","Preparedness"]
[null,"3.2","Emergency management"]
[null,"3.3","Other disaster responses"]
[null,"3.4","Emergency supply of commodities"]
[null,"4","Disaster Recovery "]
[null,"4.1","Relocation"]
[null,"4.2","Rehabilitation"]
[null,"4.3","Reconstruction"]
[null,"5","General Government, Research & Development, Education Expenditure"]
[null,"5.1","General government expenditure for Disaster Risk Reduction"]
[null,"5.2","Research & Development, risk assessment, and information"]
[null,"5.3","Education to Disaster Risk Reduction"]
[null,"B","Subtotal Gross formation of fixed capital (SUM 1 to 5)"]
[null,"6","Acquisition less disposals of land and other non produced non-financial assets"]
[null,"6.1","Acquisition less disposals of land"]
[null,"6.2","Acquisition less disposals of non produced non-financial assets"]
[null,"C","Investment production expenditure"]
[null,"Total DRR Production Expenditure (current plus investment)"]

{"sheet":"DRRE_Transfers","index":20,"n_rows":34,"n_cols":15,"rows_kept":34,"merged":[[5,1,7,2],[5,3,5,13],[5,14,7,14],[6,3,7,3],[6,4,7,4],[6,5,6,8],[6,9,6,11],[6,12,7,12],[6,13,7,13],[9,1,9,2],[17,1,17,2],[25,1,25,2],[27,1,27,2],[29,1,29,2],[31,1,31,2],[32,1,32,2],[33,1,33,2]]}
[]
["DRRE","Disaster Risk Reduction Expenditure Account"]
["DRRE_B","Transfers expenditure account & DRR National Expenditure"]
[null,"Measurement units: Local currency"]
[null,"US$ PPP",{"$nulls":11},"US$ PPP"]
[{"$nulls":3},"Institutionnal sectors",{"$nulls":10},"Rest of the World (RoW)"]
[{"$nulls":3},"Non-financial corporations","Financial corporations","General government (incl. non-profit institutions controlled by governments and social security)",{"$nulls":3},"Households",null,null,"Non-profit institutions serving households (NPISHs)","TOTAL Resident sectors (units with >1 year of activity) "]
[{"$nulls":5},"Central government","State government","Local government","Subtotal General government","Households owners of unincorporated enterprises","Employees and recipients of property and transfer incomes.","Subtotal Households"]
[null,"Transfers expenditure account"]
[null,"Total  Transfers Paid (6.1)"]
[null,"6.1","Disaster risk reduction characteristic transfers paid"]
[null,"6.1.1","Internal transfers between public government services (current or in capital)"]
[null,"6.1.2","Risk transfers, insurance premiums and indemnities "]
[null,"6.1.3","Disaster related international transfers (current or in capital)"]
[null,"6.1.4","Public transfers to private (subsidies, transfers in capital...)"]
[null,"6.1.5","Private transfers (taxes, voluntary...)"]
[null,"6.1.6","Other transfers "]
[null,"Total Transfers Received (6.2)",{"$nulls":12},"SDG 17, Sendai F1"]
[null,"6.2","Disaster risk reduction characteristic transfers received"]
[null,"6.2.1","Internal transfers between public government services (current or in capital)"]
[null,"6.2.2","Risk transfers, insurance premiums and indemnities "]
[null,"6.2.3","Disaster related international transfers (current or in capital)"]
[null,"6.2.4","Public transfers to private (subsidies, transfers in capital...)"]
[null,"6.2.5","Private transfers (taxes, voluntary...)"]
[null,"6.2.6","Other transfers "]
[null,"DRRE Net transfers (6.1 minus 6.2)"]
[]
[null,{"$f":"DRRE_Activities!B58","v":"Total DRR Production Expenditure (current plus investment)"},{"$f":"DRRE_Activities!#REF!","v":{"$error":"#REF!"}}]
[]
[null,"DRR National Expenditure = Total Production Expenditure plus Net Transfers"]
[]
[null,"Benefits of the DRR National expenditure (by beneficiaries)"]
[null,"Beneficiaries of the Total Production Expenditure"]
[null,"Beneficiaries of Total Transfers Received"]