The Collection, Synthesis, and Quality Assessment of Data Describing The Response to Human Needs Following The 1999 Turkey Earthquakes

Database:

Below are the data tables in Excel spreadsheet form that were constructed from various sources for the use of interested researchers. Each data table has only one worksheet. Please click on the data table you wish to download.

 

  • Building (residential and business units) and Human Impact (dead and injured) Statistics 

Building and human impact statistics for both Kocaeli and Düzce Earthquakes (Provincial, district and sub-district level) (Source: TR Ministry of Housing and Resettlement, General Directorate of Disaster Affairs)

KOCAELI (MARMARA) EARTHQUAKE:

  1. MARMARA_provincial_human_impact.xls

  2. MARMARA_provincial_building_impact.xls

  3. MARMARA_district_baseline.xls (pre earthquake statistics)

  4. MARMARA_district_human_impact.xls

  5. MARMARA_district_housing_impact.xls

  6. MARMARA_subdistrict_building_impact.xls

DUZCE EARTHQUAKE:

  1. DUZCE_provincial_human_impact.xls

  2. DUZCE_provincial_building_impact.xls

  3. DUZCE_district_baseline.xls (pre earthquake statistics)

  4. DUZCE_district_human_impact.xls

  5. DUZCE_district_building_impact.xls

  6. DUZCE_subdistrict_building_impact.xls

  • Displaced Population Statistics  for
    KOCAELI (MARMARA) EARTHQUAKE: 

District level displaced population statistics relating the post-earthquake residency type (in tent city or outside tent city) of the displaced population to the damage state of the residences (collapsed/heavy damage, moderate damage, slight damage and no damage), and household size based on the survey results conducted between Sept.11-19 1999 and published by the State Institute for Statistics (Source: TR State Institute for Statistics)

  1. MARMARA_displacedpop_Sept.11-19_surveyscope.xls

  2. MARMARA_displacedpop_Sept.11-19_ownershipdata.xls

  3. MARMARA_displacedpop_Sept.11-19_data.xls

District level displaced population statistics relating the pre-earthquake home ownership type (own, rent/lease, employer provided or jointly owned) to the household size and damage state of the residences (collapsed/heavy damage, moderate damage, slight damage and no damage) based on the survey results conducted and published by the State Institute for Statistics on Oct.28 1999. (Source: TR State Institute for Statistics)

  1. MARMARA_displacedpop_Oct.28_surveyscope.xls

  2. MARMARA_displacedpop_Oct.28_data.xls

  • Data tables describing the daily progress of :

Building and human impact statistics and statistics on the government response (search and rescue, sheltering, medical, feeding and other mass care activities) based on the daily press releases posted by the Prime Minister’s Crisis Management Center (from Aug.20 to Oct.19 1999 and from Nov.13 to Dec.20 1999)  

  1. MARMARA_Timeline_dead.xls

  2. MARMARA_Timeline_injured.xls

  3. MARMARA_Timeline_tents.xls

  4. DUZCE_Timeline_dead.xls

  5. DUZCE_Timeline_injured.xls

  6. DUZCE_Timeline_S&R.xls

  7. DUZCE_Timeline_medical_personnel.xls

  8. DUZCE_Timeline_tents.xls

  9. DUZCE_Timeline_distribution.xls

 Feeding tracking data (number of meals served per day) obtained from the Turkish Red Crescent (from Aug.17 1999 to Aug.31 2000)  

  1. MARMARA_Timeline_meals.xls

  2. MARMARA_Timeline_personsfed.xls

  3. MARMARA_DUZCEcombined_meals.xls

  4. MARMARA_DUZCEcombined_Timeline_personsfed.xls

RELATIONAL DATABASE

The following two databases are in Access 2002 form.

The following were constructed using the excel spreadsheet data listed above and relates the information in two different ways: a) according to impact location, and b) according to time (days)

  1. Marmara.mdb
  2. Duzce.mdb