Table 10 Variables in datasets
From: Intensity of crop and livestock insurance adoption: lessons from Mexico
Variable | Data Type | Description |
|---|---|---|
Concentrado SAC 2003-2014 dataset | ||
Anio | Numeric | Policy year |
Esquema | Categorical | State obtains insurance either directly through Federalizado or indirectly via Centralizado |
Sector | Categorical | Agriculture or livestock |
Tipo | Categorical | Traditional or parametric insurance product based on sector |
Aseguradora | Categorical | Insurer name |
Estado | Categorical | State name |
Clave_edo | Numeric | State code |
Municipio | Categorical | Municipality name |
Clave_mpio | Numeric | Municipality code |
Marginacion | Categorical | Marginality or poverty level |
Beneficiario | Categorical | Entity that receive insurance benefits can either be State or SAGARPA |
Ini_vig | Numeric | Start date of validity under the parametric scheme |
Fin_vig | Numeric | End date of validity under the parametric scheme |
Ini_vig_s1 | Numeric | First stage, start date of validity (parametric) drought |
Fin_vig_s1 | Numeric | First stage, end date of validity (parametric) drought |
Ini_vig_s2 | Numeric | Second stage, start date of validity (parametric) drought |
Fin_vig_s2 | Numeric | Second stage, end date of validity (parametric) drought |
Ini_vig_s3 | Numeric | Third stage, start date of validity (parametric) drought |
Fin_vig_s3 | Numeric | Third stage, end date of validity (parametric) drought |
Ini_vig_h2 | Numeric | Second stage, start date of validity (parametric) excess moisture |
Fin_vig_h2 | Numeric | Second stage, end date of validity (parametric) excess moisture |
Ini_vig_h3 | Numeric | Third stage, start date of validity (parametric) excess moisture |
Fin_vig_h3 | Numeric | Third stage, end date of validity (parametric) excess moisture |
Ini_vig_he1 | Numeric | First stage, start date of validity (parametric) freeze |
Fin_vig_he1 | Numeric | First stage, end date of validity (parametric) freeze |
Ini_vig_he2 | Numeric | Second stage, start date of validity (parametric) freeze |
Fin_vig_he2 | Numeric | Second stage, end date of validity (parametric) freeze |
Ini_vig_he3 | Numeric | Third stage, start date of validity (parametric) freeze |
Fin_vig_he3 | Numeric | Third stage, end date of validity (parametric) freeze |
Ini_vig_he4 | Numeric | Fourth stage, start date of validity (parametric) low temperature |
Fin_vig_he4 | Numeric | Fourth stage, end date of validity (parametric) low temperature |
Mm_s1 | Numeric | First stage, trigger in mm for (parametric) drought |
Mm_s2 | Numeric | Second stage, trigger in mm for (parametric) drought |
Mm_s3 | Numeric | Third stage, trigger in mm for (parametric) drought |
Mm_h2 | Numeric | Second stage, trigger in mm for (parametric) excess moisture |
Mm_h3 | Numeric | Third stage, trigger in mm for (parametric) excess moisture |
Gc_he1 | Numeric | First stage, the trigger for (parametric)freeze |
Gc_he2 | Numeric | Second stage, the trigger for (parametric) freeze |
Gc_he3 | Numeric | Third stage, the trigger for (parametric) freeze |
Gc_he4 | Numeric | Fourth stage, the trigger for (parametric) low temperature |
Ciclo | Categorical | Sowing and harvesting cycle |
Cultivo | Categorical | Name of the insured crop |
Modalidad | Categorical | Farming type of insured crop |
Sup_aseg_fed | Numeric | Total insured area (Federal) |
Sup_aseg_est | Numeric | Total insured area (State) |
Sup_aseg_total | Numeric | Total insured area |
Rendimiento | Numeric | Yield per hectare |
Especie | Categorical | Insured animal species |
Ua_fed | Numeric | Insured animal units (Federal) |
Ua_est | Numeric | Insured animal units (State) |
Ua_tot | Numeric | Total insured animal units |
Prima_porc | Numeric | Premium coverage for each dollar |
Prima_fed | Numeric | Federal premium in pesos |
Prima_est | Numeric | State premium in pesos |
Prima_productor | Numeric | Producer premium in pesos |
Prima_tot | Numeric | Total premium in pesos |
Suma_aseg_fed | Numeric | Sum insured (Federal) |
Suma_aseg_est | Numeric | Sum insured(State) |
Suma_aseg_productor | Numeric | Sum insured (Producer) |
Suma_aseg_total | Numeric | Total sum insured |
Suma_aseg_ha | Numeric | Sum insured per hectare |
Suma_aseg_ua | Numeric | Sum insured per animal unit |
Fenomenos | Numeric | Hazards covered per policy |
Indemnizacionesproc dataset | ||
Estado_indem | Categorical | State name benefiting from payout |
Clave_edo | Numeric | State code |
Municipio_indem | Categorical | Municipality name benefiting from payout |
Clave_mpio | Numeric | Municipality code |
Cod_geografico | Numeric | State and municipal code |
Anio | Numeric | Policy year |
Aseguradora | Categorical | Insurer name |
Tipo_seguro | Categorical | Traditional or parametric insurance product (crop or livestock) |
Beneficiario | Categorical | Entity that receive insurance benefits can either be State or SAGARPA |
Activo_asegurado | Categorical | Type of insured crop or livestock |
Indem_has | Numeric | Hectares for which payout was effected |
Monto_indem_has | Numeric | Amount in current pesos for hectares with a payout |
Indem_ua | Numeric | Number of animal units for which payout was effected |
Monto_indem_ua | Numeric | Amount in current pesos for animal units with a payout |
Monto_indem_total | Numeric | Total amount of payout in pesos |
Monto_indem_has_p09 | Numeric | Amount of payout for hectares affected in constant 2009 pesos |
Monto_indem_ua_p09 | Numeric | Animal units payout in constant 2009 pesos |
Monto_indem_total_p09 | Numeric | Total amount of payout in constant 2009 pesos |
Clave | Numeric | State and municipal code |
Codigo_sac_indemnizaciones | Numeric | Payout code |
Bases Apoyos Directos 2003 a 2014 dataset | ||
x | Numeric | Support number |
Cve_mpo | Numeric | Municipality code |
Folio | Numeric | Municipality code |
Estado | Categorical | State name receiving support |
Municipio | Categorical | Municipality name benefiting from support |
Anio | Numeric | Contribution year |
Anio_solicitud | Numeric | Application year |
Anio_radicacion | Numeric | Establishment year |
Evento | Categorical | Disaster event |
Evento_comp | Categorical | Name of disaster event supported |
Jornales_no | Numeric | Number of days of labour |
Apoyojornal$_jor | Numeric | Support per each day of labour |
Jornales$ | Numeric | Total support for labour days |
Embarcaciones_no | Numeric | Number of fishing vessels |
Apoyoemb$_emb | Numeric | Support for each fishing vessel |
JEmbarcaciones$ | Numeric | Total support for fishing vessels |
Acuicolas_has | Numeric | Number of hectares devoted to aquaculture |
Apoyoacui$_ha | Numeric | Support for each hectare devoted to aquaculture |
Acuicolas$ | Numeric | Total support for aquaculture |
Has_agricolas | Numeric | Number of hectares devoted to agriculture |
Apoyo_has_agricolas | Numeric | Support for each hectare devoted to agriculture |
Agricolas | Numeric | Total support for agriculture |
Ua | Numeric | Number of animal units |
Apoyo_por_ua | Numeric | Support for animal unit |
Apoyo_UA | Numeric | Total support for animal units |
Federal | Numeric | Federal contribution to support |
Estatal | Numeric | State contribution to support |
Total_apoyo | Numeric | Total support |
Municipio population 1990-2030 dataset | ||
Code | Numeric | State and municipal code |
Sex | Categorical | Gender |
Year | Numeric | Year |
Population | Numeric | Population |