Category Archives: Disaster Data

【Disaster Research】ADRC: Kobe’s Legacy in Asian Disaster Risk Reduction

From Tragedy to Leadership: The Birth of ADRC

The Asian Disaster Reduction Center (ADRC) was established in 1998 following the devastating Great Hanshin-Awaji Earthquake (commonly known as the Kobe Earthquake) that struck Japan in 1995. This catastrophic event became a catalyst for change, transforming how Japan—and later Asia—approached disaster management and resilience.

Kobe’s Remarkable Recovery Journey

Kobe’s recovery story stands as a powerful testament to resilience and strategic rebuilding. Within just 9 years after the earthquake, Kobe’s population returned to pre-disaster levels—an extraordinary achievement considering the scale of destruction. This recovery wasn’t merely about rebuilding structures but reimagining the city’s future role.

HAT Kobe: A Hub for Disaster Reduction Excellence

Today, Kobe has reinvented itself as a global center for disaster reduction policies and activities. The area known as HAT Kobe hosts numerous disaster-related organizations, including ADRC. The name “HAT” carries dual significance:

  • It stands for “Happy and Active Town”
  • In Japanese, “hatto” (ハッと) means “surprised” or “sudden realization”

This wordplay perfectly captures Kobe’s transformation from a disaster-struck city to a knowledge hub that helps others prepare for and respond to unexpected disasters.

Learning From Kobe: A Model for Disaster Recovery

Kobe’s recovery process offers valuable lessons for communities worldwide facing similar challenges. The city demonstrates how effective post-disaster planning can transform tragedy into opportunity, creating not just infrastructure but institutional knowledge that benefits others.

ADRC’s Mission Across Asia

ADRC plays a vital role in sharing disaster reduction expertise with its member countries throughout Asia. The organization:

  • Contributes to disaster reduction policy development
  • Supports member countries in implementing effective disaster management systems
  • Facilitates knowledge sharing through detailed country reports
  • Monitors and reports on ongoing disaster situations

Resources for Disaster Management Professionals

ADRC maintains comprehensive resources that disaster management professionals can access:

These resources provide valuable insights into regional disaster management systems, country-specific approaches, and up-to-date information on current disaster situations across Asia.

Building Regional Resilience Together

Through organizations like ADRC and the example set by Kobe, Asian countries are developing stronger collaborative approaches to disaster risk reduction. By learning from past experiences and sharing knowledge, communities across the region are better prepared to face future challenges with resilience and determination.

【Disaster Research:Excel】Pivot Tables for Disaster Research: A Step-by-Step Guide

Today, I gonna explain how to use a pivot table to conduct disaster research using dummy data.

What is a Pivot Table?

Imagine you have a big pile of data, and you want to see summaries or patterns quickly. A pivot table lets you rearrange (or “pivot”) that data to show different views, like totals, averages, or counts, without changing the original data.

Sample Disaster Research Dataset:

dummy dataset

Step-by-Step Pivot Table Analysis for Disaster Research

  1. Select Data & Insert Pivot Table
  • Select all the data (Ctrl+A or Cmd+A)
  • Go to “Insert” → “PivotTable” → “OK” (for a new worksheet or you can choose the location in the same sheet)
  1. Total Aid Provided by Disaster Type

The sum of Aid by Disaster Type

  • Drag “Disaster Type” to the “Rows” box
  • Drag “Aid Provided (USD)” to the “Values” box (automatically shows sum of aid)
  • Interpretation: Quickly identify which disaster types received the most total aid
  1. Aid Provided by Organization
  • Remove “Disaster Type” from rows and add “Organization” instead
  • Keep “Aid Provided (USD)” in the “Values” box
  • Interpretation: Visualize which organizations have contributed the most aid overall
  1. Aid Provided by Year
  • Replace “Organization” with “Year” in the “Rows” box
  • Keep “Aid Provided (USD)” in the “Values” box
  • Interpretation: Track annual patterns in aid disbursement over time
  1. Aid Provided by Disaster Type and Year
  • Add “Disaster Type” to the “Rows” box
  • Place “Year” in the “Columns” box
  • Keep “Aid Provided (USD)” in the “Values” box
  • Interpretation: Create a cross-tabulation showing aid distribution across disaster types and years
  1. Average Aid Provided
  • Click on “Sum of Aid Provided (USD)” in the “Values” box
  • Select “Value Field Settings” → “Average” → “OK”
  • Interpretation: Compare the average aid amounts across categories
  1. Filtering by Location
  • Add “Location” to the “Filters” box
  • Use the dropdown to select a specific location (e.g., Nepal)
  • Interpretation: Focus your analysis on specific geographic regions
  1. Counting Disaster Occurrences

Sorted Table

  • Remove “Aid Provided (USD)” from values
  • Add “Disaster Type” to the values box
  • Change the value field setting from sum to count
  • Interpretation: Track the frequency of different disaster types in your dataset

Key Insights from Disaster Research Pivot Tables

  • Aid Distribution Analysis: Identify which disaster types or locations receive the most financial support
  • Organizational Impact Assessment: Understand which relief organizations are most active in different scenarios
  • Temporal Trend Identification: Analyze how aid distribution patterns change over months, quarters, or years
  • Comparative Regional Analysis: Compare aid efforts across different geographic areas and disaster contexts

By experimenting with different field combinations, you can uncover valuable insights from your disaster research data. Pivot tables transform complex datasets into actionable intelligence for disaster management, policy development, and resource allocation.

Content Gap Opportunities

  • A section on advanced pivot table features specifically useful for disaster research
  • Guidance on data visualization options after creating pivot tables
  • Information on combining pivot tables with other analytical tools for comprehensive disaster analysis
  • Tips for presenting pivot table findings to non-technical stakeholders