Baselight

Socioeconomic Tracker Using Unconventional Data

Joint Research Centre

@ecjrc.f7be47f7_49a2_44e8_9dc8_043735af4139

Web Searches Data
@ecjrc.f7be47f7_49a2_44e8_9dc8_043735af4139.web_searches_data

  • 3.89 MB
  • 197802 rows
  • 7 columns
indicator

Indicator

category_name

Category Name

category

Category

geo

Geo

date

Date

value_cat_sum

Value Cat Sum

value_cat_mean

Value Cat Mean

EconomyTV & Video Equipment229ATJan 20131743459.209359301530059.64154067761
EconomyTV & Video Equipment229ATFeb 20131713546.692297623529543.90848789006
EconomyTV & Video Equipment229ATMar 20131720964.3453857829671.79905837552
EconomyTV & Video Equipment229ATApr 20131688039.976862593629104.13753211368
EconomyTV & Video Equipment229ATMay 20131768306.289890496330488.039480870637
EconomyTV & Video Equipment229ATJun 20131761225.46066724530365.956218400777
EconomyTV & Video Equipment229ATJul 20131753597.350830736630234.43708328856
EconomyTV & Video Equipment229ATAug 20131832546.358166019231595.626864931364
EconomyTV & Video Equipment229ATSep 20131795073.739578396330949.547234110283
EconomyTV & Video Equipment229ATOct 20131696390.977448994329248.120300844734

CREATE TABLE web_searches_data (
  "indicator" VARCHAR,
  "category_name" VARCHAR,
  "category" BIGINT,
  "geo" VARCHAR,
  "date" VARCHAR,
  "value_cat_sum" DOUBLE,
  "value_cat_mean" DOUBLE
);

Share link

Anyone who has the link will be able to view this.