Food Prices For Nutrition
Data on food prices and nutrition
@worldbank.food_prices_for_nutrition
Data on food prices and nutrition
@worldbank.food_prices_for_nutrition
CREATE TABLE coca (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE coca_fexp (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE coca_headcount (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE coca_pov (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE coca_unafford_n (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" DOUBLE,
"yr2019" DOUBLE,
"yr2020" DOUBLE,
"yr2021" DOUBLE,
"yr2022" DOUBLE
);
CREATE TABLE cohd_asf (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_asf_prop (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_asf_ss (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_coca (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_f (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_f_prop (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_f_ss (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_fexp (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_headcount (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" DOUBLE,
"yr2019" DOUBLE,
"yr2020" DOUBLE,
"yr2021" DOUBLE,
"yr2022" DOUBLE
);
CREATE TABLE cohd_lns (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_lns_prop (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_lns_ss (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_of (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_of_prop (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_of_ss (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_pov (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" DOUBLE,
"yr2019" DOUBLE,
"yr2020" DOUBLE,
"yr2021" DOUBLE,
"yr2022" DOUBLE
);
CREATE TABLE cohd_ss (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_ss_prop (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_unafford_n (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" DOUBLE,
"yr2019" DOUBLE,
"yr2020" DOUBLE,
"yr2021" DOUBLE,
"yr2022" DOUBLE
);
CREATE TABLE cohd_v (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_v_prop (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cohd_v_ss (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cona (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cona_fexp (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cona_headcount (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cona_pov (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE cona_unafford_n (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" VARCHAR,
"yr2019" VARCHAR,
"yr2020" VARCHAR,
"yr2021" DOUBLE,
"yr2022" VARCHAR
);
CREATE TABLE pop (
"classification" VARCHAR,
"economy" VARCHAR,
"yr2017" DOUBLE,
"yr2018" DOUBLE,
"yr2019" DOUBLE,
"yr2020" DOUBLE,
"yr2021" DOUBLE,
"yr2022" DOUBLE
);
Anyone who has the link will be able to view this.