Sentiment

Twitter sentiment by suburb (SAL)

CouchDB MapReduce _stats per suburb and topic (all tweets, income keywords, crime keywords), Feb-Jul 2022, every Australian state. Rows are keyed by SAL code: join regions_sal for names.

All tablestwitter_sal_sentiment6,799 rows

page 270 of 272 CSV

Twitter sentiment by suburb (SAL), page 270 of 272
sal_codeTEXT	topicTEXT	stateTEXT	tweet_countINTEGER	score_sumINTEGER	score_minINTEGER	score_maxINTEGER	score_sumsqrINTEGER	avg_scoreREAL
50347	crime	Western Australia	1	5	5	5	25	5
50352	crime	Western Australia	1	8	8	8	64	8
50378	crime	Western Australia	1	5	5	5	25	5
50404	crime	Western Australia	2	13	5	8	89	6.5
50474	crime	Western Australia	1	8	8	8	64	8
50482	crime	Western Australia	3	3	1	1	3	1
50484	crime	Western Australia	1	2	2	2	4	2
50508	crime	Western Australia	2	16	7	9	130	8
50522	crime	Western Australia	1	8	8	8	64	8
50569	crime	Western Australia	3	15	5	5	75	5
50712	crime	Western Australia	1	2	2	2	4	2
50737	crime	Western Australia	3	10	1	5	42	3.33
50742	crime	Western Australia	3	10	1	8	66	3.33
50749	crime	Western Australia	3	6	2	2	12	2
50799	crime	Western Australia	3	12	1	7	66	4
50891	crime	Western Australia	2	10	2	8	68	5
51004	crime	Western Australia	1	8	8	8	64	8
51093	crime	Western Australia	2	10	4	6	52	5
51111	crime	Western Australia	26	90	1	8	420	3.46
51157	crime	Western Australia	6	19	1	5	71	3.17
51230	crime	Western Australia	1,271	4,326	1	9	21,316	3.4
51259	crime	Western Australia	5	20	1	5	92	4
51268	crime	Western Australia	1	7	7	7	49	7
51378	crime	Western Australia	1	8	8	8	64	8
51400	crime	Western Australia	4	18	2	6	90	4.5