Air Pollution

It is a combination of World Pollution Data

@kaggle.pavan9065_air_pollution

Table List

4 tables(2.03 MB)

Death Rates From Air Pollution

Death Rates Total Air Pollution

Number Of Deaths By Risk Factor

Share Deaths Air Pollution

Number Of Deaths By Risk Factor

@kaggle.pavan9065_air_pollution.number_of_deaths_by_risk_factor

1.69 MB
6468 rows
32 columns

entity Entity	code Code	year Year	unsafe_water_source Unsafe Water Source	unsafe_sanitation Unsafe Sanitation	no_access_to_handwashing_facility No Access To Handwashing Facility	household_air_pollution_from_solid_fuels Household Air Pollution From Solid Fuels	non_exclusive_breastfeeding Non-exclusive Breastfeeding	discontinued_breastfeeding Discontinued Breastfeeding	child_wasting Child Wasting	child_stunting Child Stunting	low_birth_weight_for_gestation Low Birth Weight For Gestation	secondhand_smoke Secondhand Smoke	alcohol_use Alcohol Use	drug_use Drug Use	diet_low_in_fruits Diet Low In Fruits	diet_low_in_vegetables Diet Low In Vegetables	unsafe_sex Unsafe Sex	low_physical_activity Low Physical Activity	high_fasting_plasma_glucose High Fasting Plasma Glucose	high_total_cholesterol High Total Cholesterol	high_body_mass_index High Body-mass Index	high_systolic_blood_pressure High Systolic Blood Pressure	smoking Smoking	iron_deficiency Iron Deficiency	vitamin_a_deficiency Vitamin A Deficiency	low_bone_mineral_density Low Bone Mineral Density	air_pollution Air Pollution	outdoor_air_pollution Outdoor Air Pollution	diet_high_in_sodium Diet High In Sodium	diet_low_in_whole_grains Diet Low In Whole Grains	diet_low_in_nuts_and_seeds Diet Low In Nuts And Seeds
Afghanistan	AFG	1990	7554.049543424003	5887.7476281818335	5412.314513344937	22388.497232531477	3221.138841514979	156.09755261422964	22778.849249214836	10408.438845894392	12168.564630698867	4234.808094677113	356.5293068611502	208.32542962122108	8538.96413685254	7678.717644361205	387.1675823111953	4221.303182609684	21610.0661598951	9505.53196162	7701.581280327151	28183.98334812665	6393.667372047928	726.4312942038706	9344.131951808064	374.8440560858724	26598.006726612373	4383.83	2737.1979339646896	11381.377345293518	7299.867330176937
Afghanistan	AFG	1991	7359.676749479301	5732.770160322746	5287.891102764385	22128.758205735798	3150.559597411745	151.53985058568273	22292.691113124165	10271.976431206547	12360.635374422409	4219.59732365285	320.5984612315439	217.7696907620416	8642.847150818192	7789.773032609712	394.4482851077947	4252.630379003315	21824.93803880285		7747.774903099835	28435.397513867752	6429.253319926822	739.2457994510022	9330.182377666064	379.8542371626461	26379.5322178894	4426.36	2741.184956231152	11487.83238967528	7386.764303028696
Afghanistan	AFG	1992	7650.437821839379	5954.804986596307	5506.657363304852	22873.768789027687	3331.3490479090237	156.60919370747234	23102.197940078942	10618.879778220236	13459.59371567683	4371.907967568935	293.25701621693463	247.8332512672089	8961.526496322134	8083.234634101427	422.4533017780816	4347.330896961976	22418.69880654124		7991.018970827566	29173.611201483927	6561.0549574689485	873.4853405681067	9769.844532515684	388.1304336695029	27263.127914162946	4568.91	2798.5602454506457	11866.235571661087	7640.628525897436
Afghanistan	AFG	1993	10270.731382794724	7986.736612632727	7104.620351486886	25599.756283955183	4477.006100481312	206.8344513001825	27902.669960222247	12260.093842556938	18458.42913334116	4863.558516757196	278.1297583262949	285.03618118144675	9377.118485074365	8452.242404620447	448.3283171920544	4465.137669550944	23140.51117471855		8281.564408281778	30074.76091021691	6731.9725604209225	1040.0474218205957	11433.769490629658	405.5779314072537	30495.561499140586	5080.29	2853.301678908393	12335.961681526836	7968.311853307048
Afghanistan	AFG	1994	11409.177112111378	8863.010064566104	8051.515953227572	28013.167199595147	5102.62205432069	233.9305709354781	32929.00593186218	14197.947962678383	19958.388544721514	5292.379854455759	250.69156908015935	306.64679560893	9688.448553968276	8755.372045095422	464.5063549701882	4566.650503539348	23725.07008399633		8472.29778002948	30809.49116867075	6889.328117982458	1101.7646445503187	12936.955863372934	415.34919520979247	33323.1614011769	5499.23	2880.025765495776	12672.950190895192	8244.368430231254
Afghanistan	AFG	1995	12676.647423734914	9840.848679656398	8770.686293793005	29062.618787331183	5402.66037915114	262.79333981670976	35631.99702805811	15243.02091276848	20444.70940025656	5491.017509511727	220.1990676977278	324.6102724661674	9876.716706998286	8908.99072614712	476.4244983101021	4613.790132344799	23993.94063367773	14674.8043862	8538.88381147959	31152.18129408037	6946.955865839312	1140.2461648049064	13696.757131293198	422.8541787539084	34511.845284416086	5641.29	2892.22169201266	12854.592678891502	8375.861882572628
Afghanistan	AFG	1996	12154.942315113902	9426.89644508786	8610.686857470055	29407.321601020903	5263.644457670791	253.6681808455588	36114.59323269192	16009.918435655773	21072.04331198152	5595.9513677470495	197.92837614641164	342.8511535646563	10102.415201108855	9087.022484330697	486.552493375778	4668.633488289635	24326.44893768979		8614.898052348686	31554.00026459532	7040.420959076776	1182.515060109843	14563.56309816793	428.7465555163356	34952.10158266379	5739.07	2905.798224859665	13089.157280373483	8537.651676359617
Afghanistan	AFG	1997	12329.13171025662	9553.555998278503	8722.943079268734	29674.39831492364	5271.771800108397	258.13414593681654	36749.11745335686	16473.897912214044	21262.692532885914	5701.811908123222	181.67413023834345	361.9349284089687	10330.181376279768	9258.226836799566	497.5519906680073	4720.934069814653	24653.392755399145		8661.86318941513	31957.26138335197	7155.470206616933	1225.451978656367	15089.52617080788	424.039893918884	35306.56659481802	5828.94	2919.6838941563974	13326.500377349788	8694.523033882633
Afghanistan	AFG	1998	12133.60954142679	9390.04202950123	8621.884918344313	29807.45321369544	5165.923779364217	254.70807795108396	36569.46557328026	16665.712673586248	21214.163931252337	5762.014504530437	203.5203151200577	379.1053194073993	10522.663503346212	9390.134086471966	506.9434717872206	4759.5211167519765	24905.211451985848		8675.35527107321	32267.85275352625	7266.191855486902	1260.312276536464	15385.663083887615	420.41124049132736	35360.16886655094	5751.54	2925.3912352470875	13516.547570792429	8818.249272184126
Afghanistan	AFG	1999	11990.396327982286	9268.489611265044	8502.729989856196	29484.612215407396	5044.307572864003	251.8988239712364	36124.04655678359	16729.538963138824	20972.044013063794	5774.819639231222	170.00588447910553	388.7336028352664	10639.182669886695	9442.087329103511	513.467829197766	4793.342763308378	25043.20522393153		8659.272511976447	32476.06208303684	7356.558353281624	1231.417776353806	15646.04186308615	411.5796425017184	35040.34950635383	5756.43	2936.213763523847	13584.23943180373	8867.61944403382


CREATE TABLE number_of_deaths_by_risk_factor (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "unsafe_water_source" DOUBLE,
  "unsafe_sanitation" DOUBLE,
  "no_access_to_handwashing_facility" DOUBLE,
  "household_air_pollution_from_solid_fuels" DOUBLE,
  "non_exclusive_breastfeeding" DOUBLE,
  "discontinued_breastfeeding" DOUBLE,
  "child_wasting" DOUBLE,
  "child_stunting" DOUBLE,
  "low_birth_weight_for_gestation" DOUBLE,
  "secondhand_smoke" DOUBLE,
  "alcohol_use" DOUBLE,
  "drug_use" DOUBLE,
  "diet_low_in_fruits" DOUBLE,
  "diet_low_in_vegetables" DOUBLE,
  "unsafe_sex" DOUBLE,
  "low_physical_activity" DOUBLE,
  "high_fasting_plasma_glucose" DOUBLE,
  "high_total_cholesterol" DOUBLE,
  "high_body_mass_index" DOUBLE,
  "high_systolic_blood_pressure" DOUBLE,
  "smoking" DOUBLE,
  "iron_deficiency" DOUBLE,
  "vitamin_a_deficiency" DOUBLE,
  "low_bone_mineral_density" DOUBLE,
  "air_pollution" DOUBLE,
  "outdoor_air_pollution" DOUBLE,
  "diet_high_in_sodium" DOUBLE,
  "diet_low_in_whole_grains" DOUBLE,
  "diet_low_in_nuts_and_seeds" DOUBLE
);