text: DROP TABLE IF EXISTS gdelt_2020_test;
  CREATE TABLE gdelt_2020_test (
    GLOBALEVENTID TEXT,
    SQLDATE TEXT,
    MonthYear TEXT,
    Year  TEXT,
    FractionDate  TEXT,
    Actor1Code  TEXT,
    Actor1Name  TEXT,
    Actor1CountryCode TEXT,
    Actor1KnownGroupCode  TEXT,
    Actor1EthnicCode  TEXT,
    Actor1Religion1Code TEXT,
    Actor1Religion2Code TEXT,
    Actor1Type1Code TEXT,
    Actor1Type2Code TEXT,
    Actor1Type3Code TEXT,
    Actor2Code  TEXT,
    Actor2Name  TEXT,
    Actor2CountryCode TEXT,
    Actor2KnownGroupCode  TEXT,
    Actor2EthnicCode  TEXT,
    Actor2Religion1Code TEXT,
    Actor2Religion2Code TEXT,
    Actor2Type1Code TEXT,
    Actor2Type2Code TEXT,
    Actor2Type3Code TEXT,
    IsRootEvent TEXT,
    EventCode TEXT,
    EventBaseCode TEXT,
    EventRootCode TEXT,
    QuadClass TEXT,
    GoldsteinScale  TEXT,
    NumMentions TEXT,
    NumSources  TEXT,
    NumArticles TEXT,
    AvgTone TEXT,
    Actor1Geo_Type  TEXT,
    Actor1Geo_FullName  TEXT,
    Actor1Geo_CountryCode TEXT,
    Actor1Geo_ADM1Code  TEXT,
    Actor1Geo_Lat TEXT,
    Actor1Geo_Long  TEXT,
    Actor1Geo_FeatureID TEXT,
    Actor2Geo_Type  TEXT,
    Actor2Geo_FullName  TEXT,
    Actor2Geo_CountryCode TEXT,
    Actor2Geo_ADM1Code  TEXT,
    Actor2Geo_Lat TEXT,
    Actor2Geo_Long  TEXT,
    Actor2Geo_FeatureID TEXT,
    ActionGeo_Type  TEXT,
    ActionGeo_FullName  TEXT,
    ActionGeo_CountryCode TEXT,
    ActionGeo_ADM1Code  TEXT,
    ActionGeo_Lat TEXT,
    ActionGeo_Long  TEXT,
    ActionGeo_FeatureID TEXT,
    DATEADDED TEXT,
    SOURCEURL TEXT
  );
  
  \COPY gdelt_2020_test FROM 'processed_data/2020.csv' DELIMITER ',' CSV HEADER;
  