CREATE TABLE "playstore"
(
    App              TEXT,
    Category         TEXT,
    Rating           REAL,
    Reviews          INTEGER,
    Size             TEXT,
    Installs         TEXT,
    Type             TEXT,
    Price            TEXT,
    "Content Rating" TEXT,
    Genres           TEXT
);
playstore
CREATE TABLE "user_reviews"
(
    App                    TEXT
        references "playstore" (App),
    Translated_Review      TEXT,
    Sentiment              TEXT,
    Sentiment_Polarity     TEXT,
    Sentiment_Subjectivity TEXT
);
user_reviews
original_column_name,column_name,column_description,data_format,value_description
App,,Application name,text,
Category,,Category the app belongs to,text,"FAMILY 18%
GAME 11%
Other (7725) 71%"
Rating,,Overall user rating of the app (as when scraped),real,
Reviews,,Number of user reviews for the app (as when scraped),integer,
Size,,Size of the app (as when scraped),text,"Varies with device 16%
11M 2%
Other (8948) 83%"
Installs,,Number of user downloads/installs for the app (as when scraped),text,"1,000,000+ 15%
10,000,000+ 12%
Other (8010) 74%"
Type,,Paid or Free,text,"Only has 'Paid' and 'Free'
Free 93%
Paid 7%"
Price,,Price of the app (as when scraped),text,"0 93%
$0.99 1%
Other (653) 6%

commonsense evidence:
Free means the price is 0."
Content Rating,,Age group the app is targeted at - Children / Mature 21+ / Adult,text,"Everyone 80%
Teen 11%
Other (919) 8%

commonsense evidence:
According to Wikipedia, the different age groups are defined as:
Children: age<12~13
Teen: 13~19
Adult/Mature: 21+
"
Genres,,An app can belong to multiple genres (apart from its main category).,text,"Tools 8%
Entertainment 6%
Other (9376) 86%"
googleplaystore
original_column_name,column_name,column_description,data_format,value_description
App,,Name of app,text,
Translated_Review,,User review (Preprocessed and translated to English),text,"nan 42%
Good 0%
Other (37185) 58%"
Sentiment,,Overall user rating of the app (as when scraped),text,"commonsense evidence:
Positive: user holds positive attitude towards this app
Negative: user holds positive attitude / critizes on this app
Neural: user holds neural attitude
nan: user doesn't comment on this app."
Sentiment_Polarity,Sentiment Polarity,Sentiment polarity score,text,"commonsense evidence:
• score >= 0.5 it means pretty positive or pretty like this app.
• 0 <= score < 0.5: it means user mildly likes this app.
• -0.5 <= score < 0: it means this user mildly dislikes this app or slightly negative attitude
• score <-0.5: it means this user dislikes this app pretty much."
Sentiment_Subjectivity,Sentiment Subjectivity,Sentiment subjectivity score,text,"commonsense evidence:
more subjectivity refers to less objectivity, vice versa."
googleplaystore_user_reviews