Countries

place_id Place Id	place_name Place Name	parent_place_id Parent Place Id	parent_place_name Parent Place Name	variable Variable	date Date	value Value	import_name Import Name	provenance_domain Provenance Domain	datacommons_url Datacommons Url
country/MAR	Morocco	NorthernAfrica	Northern Africa	Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL	1999	100	OneOrg_Debt	one.org	https://datacommons.org/browser/country/MAR?statVar=Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL
country/MAR	Morocco	NorthernAfrica	Northern Africa	Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL	2010	100	OneOrg_Debt	one.org	https://datacommons.org/browser/country/MAR?statVar=Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL
country/MAR	Morocco	NorthernAfrica	Northern Africa	Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL	2004	100	OneOrg_Debt	one.org	https://datacommons.org/browser/country/MAR?statVar=Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL
country/MAR	Morocco	NorthernAfrica	Northern Africa	Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL	2011	100	OneOrg_Debt	one.org	https://datacommons.org/browser/country/MAR?statVar=Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL
country/MAR	Morocco	NorthernAfrica	Northern Africa	Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL	2018	100	OneOrg_Debt	one.org	https://datacommons.org/browser/country/MAR?statVar=Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL
country/MAR	Morocco	NorthernAfrica	Northern Africa	Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL	1985	100	OneOrg_Debt	one.org	https://datacommons.org/browser/country/MAR?statVar=Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL
country/MAR	Morocco	NorthernAfrica	Northern Africa	Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL	2016	100	OneOrg_Debt	one.org	https://datacommons.org/browser/country/MAR?statVar=Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL
country/MAR	Morocco	NorthernAfrica	Northern Africa	Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL	1991	100	OneOrg_Debt	one.org	https://datacommons.org/browser/country/MAR?statVar=Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL
country/MAR	Morocco	NorthernAfrica	Northern Africa	Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL	1970	100	OneOrg_Debt	one.org	https://datacommons.org/browser/country/MAR?statVar=Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL
country/MAR	Morocco	NorthernAfrica	Northern Africa	Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL	2006	100	OneOrg_Debt	one.org	https://datacommons.org/browser/country/MAR?statVar=Amount_Debt_WorldBankOtherCurrency_LenderCountryIRL_AsAFractionOf_Amount_Debt_LenderCountryIRL


CREATE TABLE morocco_country_mar (
  "place_id" VARCHAR,
  "place_name" VARCHAR,
  "parent_place_id" VARCHAR,
  "parent_place_name" VARCHAR,
  "variable" VARCHAR,
  "date" VARCHAR,
  "value" DOUBLE,
  "measurement_method" VARCHAR,
  "observation_period" VARCHAR,
  "import_name" VARCHAR,
  "provenance_domain" VARCHAR,
  "datacommons_url" VARCHAR
);