CREATE TABLE "Country"
(
    CountryCode                                TEXT not null
        primary key,
    ShortName                                  TEXT,
    TableName                                  TEXT,
    LongName                                   TEXT,
    Alpha2Code                                 TEXT,
    CurrencyUnit                               TEXT,
    SpecialNotes                               TEXT,
    Region                                     TEXT,
    IncomeGroup                                TEXT,
    Wb2Code                                    TEXT,
    NationalAccountsBaseYear                   TEXT,
    NationalAccountsReferenceYear              TEXT,
    SnaPriceValuation                          TEXT,
    LendingCategory                            TEXT,
    OtherGroups                                TEXT,
    SystemOfNationalAccounts                   TEXT,
    AlternativeConversionFactor                TEXT,
    PppSurveyYear                              TEXT,
    BalanceOfPaymentsManualInUse               TEXT,
    ExternalDebtReportingStatus                TEXT,
    SystemOfTrade                              TEXT,
    GovernmentAccountingConcept                TEXT,
    ImfDataDisseminationStandard               TEXT,
    LatestPopulationCensus                     TEXT,
    LatestHouseholdSurvey                      TEXT,
    SourceOfMostRecentIncomeAndExpenditureData TEXT,
    VitalRegistrationComplete                  TEXT,
    LatestAgriculturalCensus                   TEXT,
    LatestIndustrialData                       INTEGER,
    LatestTradeData                            INTEGER,
    LatestWaterWithdrawalData                  INTEGER
);
Country
CREATE TABLE "Series"
(
    SeriesCode                       TEXT not null
        primary key,
    Topic                            TEXT,
    IndicatorName                    TEXT,
    ShortDefinition                  TEXT,
    LongDefinition                   TEXT,
    UnitOfMeasure                    TEXT,
    Periodicity                      TEXT,
    BasePeriod                       TEXT,
    OtherNotes                       INTEGER,
    AggregationMethod                TEXT,
    LimitationsAndExceptions         TEXT,
    NotesFromOriginalSource          TEXT,
    GeneralComments                  TEXT,
    Source                           TEXT,
    StatisticalConceptAndMethodology TEXT,
    DevelopmentRelevance             TEXT,
    RelatedSourceLinks               TEXT,
    OtherWebLinks                    INTEGER,
    RelatedIndicators                INTEGER,
    LicenseType                      TEXT
);
Series
CREATE TABLE CountryNotes
(
    Countrycode TEXT NOT NULL ,
    Seriescode  TEXT NOT NULL ,
    Description TEXT,
    primary key (Countrycode, Seriescode),
    FOREIGN KEY (Seriescode) REFERENCES Series(SeriesCode),
    FOREIGN KEY (Countrycode) REFERENCES Country(CountryCode)
);
CountryNotes
CREATE TABLE Footnotes
(
    Countrycode TEXT NOT NULL ,
    Seriescode  TEXT NOT NULL ,
    Year        TEXT,
    Description TEXT,
    primary key (Countrycode, Seriescode, Year),
    FOREIGN KEY (Seriescode) REFERENCES Series(SeriesCode),
    FOREIGN KEY (Countrycode) REFERENCES Country(CountryCode)
);
Footnotes
CREATE TABLE Indicators
(
    CountryName   TEXT,
    CountryCode   TEXT NOT NULL ,
    IndicatorName TEXT,
    IndicatorCode TEXT NOT NULL ,
    Year          INTEGER NOT NULL ,
    Value         INTEGER,
    primary key (CountryCode, IndicatorCode, Year),
    FOREIGN KEY (CountryCode) REFERENCES Country(CountryCode)
);
Indicators
CREATE TABLE SeriesNotes
(
    Seriescode  TEXT not null ,
    Year        TEXT not null ,
    Description TEXT,
    primary key (Seriescode, Year),
    foreign key (Seriescode) references Series(SeriesCode)
);
SeriesNotes
original_column_name,column_name,column_description,data_format,value_description
Countrycode,Country code,code identifying unique countries,text,
Seriescode,Series code,Series code of countries,text,
Year,,Year,text,
Description,,Description of country footnotes,text,
FootNotes
original_column_name,column_name,column_description,data_format,value_description
Seriescode,Series code,code identifying the series,text,
Year,,year,text,
Description,,Description of series,text,
SeriesNotes
original_column_name,column_name,column_description,data_format,value_description
CountryCode,Country Code,unique code identifying countries,text,
ShortName,Short Name,Short names of countries ,text,
TableName,Table Name,table names of countries,text,
LongName,Long Name,long or full name of countries,text,
Alpha2Code,Alpha to Code,2 digit code of countries ,text,
CurrencyUnit,Currency Unit,Currency Unit used in this country,text,
SpecialNotes,Special Notes,Special Notes,text,
Region,Region,region that country belongs to ,text,
IncomeGroup,Income Group,income level of countries ,text,
Wb2Code,world bank to code,world bank to code,text,
NationalAccountsBaseYear,National Accounts Base Year,the year used as the base period for constant price calculations in the country's national accounts,text,
NationalAccountsReferenceYear,National Accounts Reference Year,National Accounts Reference Year,text,
SnaPriceValuation,SNA Price Valuation,SNA Price Valuation,text,
LendingCategory,Lending Category,Lending category,text,"• IDA: International Development Associations: (IDA) is the part of the World Bank that helps the world's poorest countries.
• IBRD: The International Bank for Reconstruction and Development (IBRD) is a global development cooperative owned by 189 member countries.
• Blend: Blend is the cloud banking infrastructure powering billions of dollars in financial transactions every day."
OtherGroups,Other groups,other groups,text,"• HIPC: Heavily Indebted Poor Countries
• Euro Area: The euro area consists of those Member States of the European Union that have adopted the euro as their currency."
SystemOfNationalAccounts,System Of National Accounts,System Of National Accounts,text,
AlternativeConversionFactor,Alternative Conversion Factor,Alternative conversion factor is the underlying annual exchange rate used for the World Bank Atlas method,text,
PppSurveyYear,purchasing power parity survey year,purchasing power parity survey year,text,
BalanceOfPaymentsManualInUse,Balance Of Payments Manual In Use,Balance Of Payments Manual In Use,text,
ExternalDebtReportingStatus,External Debt Reporting Status,External Debt Reporting Status,text,"• Actual
• Preliminary
• Estimate
commonsense reasoning:
If ExternalDebtReportingStatus='Actual', it means this external debt reporting is real and actual, and finished
if 'Estimate', it means external debt reporting is finished by estimation.
if 'preliminary', it means this external debt reporting is not finished"
SystemOfTrade,System Of Trade,System Of Trade,text,
GovernmentAccountingConcept,Government Accounting Concept,Government Accounting Concept,text,
ImfDataDisseminationStandard,International Monetory Fund Data Dissemination Standard,IMF Standards for Data Dissemination,text,
LatestPopulationCensus,Latest Population Census,Latest Population Census,text,
LatestHouseholdSurvey,Latest Household Survey,,text,
SourceOfMostRecentIncomeAndExpenditureData,Source Of Most Recent Income And Expenditure Data,Source Of Most Recent Income And Expenditure Data,text,
VitalRegistrationComplete,Vital Registration Complete,Vital Registration Complete,text,
LatestAgriculturalCensus,Latest Agricultural Census,Latest Agricultural Census,text,
LatestIndustrialData,Latest Industrial Data,Latest Industrial Data,integer,
LatestTradeData,Latest Trade Data,Latest Trade Data,integer,
LatestWaterWithdrawalData,Latest Water Withdrawal Data,Latest Water Withdrawal Data,integer,
Country
original_column_name,column_name,column_description,data_format,value_description
Countrycode,Country code,code identifying unique countries,text,
Seriescode,Series code,Series code of countries,text,
Description,,description,text,
CountryNotes
original_column_name,column_name,column_description,data_format,value_description
CountryName,Country code,code identifying unique countries,text,
CountryCode,Series code,Series code of countries,text,
IndicatorName,Indicator Name,indicator name,text,
IndicatorCode,Indicator Code,indicator code,text,
Year,,year,integer,
Value,,value,integer,
Indicators
original_column_name,column_name,column_description,data_format,value_description
SeriesCode,Series Code,unique code identifying series,text,
Topic,,topic of series,text,
IndicatorName,Indicator Name,Indicator Name,text,
ShortDefinition,Short Definition,Short Definition of series,text,
LongDefinition,Long Definition,Long Definition of series ,text,
UnitOfMeasure,Unit Of Measure,Unit Of Measure,text,
Periodicity,Periodicity,Periodicity,text,
BasePeriod,Base Period,"a period of business or economic activity used as a basis or reference point especially for indexing, calculating, estimating, or adjudicating prices, taxes, compensation, income, and production",text,
OtherNotes,Other Notes,Other Notes,integer,
AggregationMethod,Aggregation Method,Aggregation Method,text,
LimitationsAndExceptions,Limitations And Exceptions,Limitations And Exceptions,text,
NotesFromOriginalSource,Notes From Original Source,Notes From Original Source,text,
GeneralComments,General Comments,General Comments,text,
Source,Source,source of this data,text,
StatisticalConceptAndMethodology,Statistical Concept And Methodology,Statistical Concept And Methodology,text,
DevelopmentRelevance,Development Relevance,Development Relevance,text,
RelatedSourceLinks,Related Source Links,Related Source Links,text,
OtherWebLinks,Other Web Links,Other Web Links,integer,
RelatedIndicators,Related Indicators,Related Indicators,integer,
LicenseType,License Type,License Type,text,
Series