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 265 of 272 CSV

Twitter sentiment by suburb (SAL), page 265 of 272
sal_codeTEXT	topicTEXT	stateTEXT	tweet_countINTEGER	score_sumINTEGER	score_minINTEGER	score_maxINTEGER	score_sumsqrINTEGER	avg_scoreREAL
22829	crime	Victoria	2	7	2	5	29	3.5
22873	crime	Victoria	1	1	1	1	1	1
22919	crime	Victoria	21	45	1	5	119	2.14
30021	crime	Queensland	1	2	2	2	4	2
30057	crime	Queensland	1	1	1	1	1	1
30064	crime	Queensland	2	9	3	6	45	4.5
30104	crime	Queensland	4	13	1	6	63	3.25
30157	crime	Queensland	2	14	7	7	98	7
30190	crime	Queensland	12	35	1	8	159	2.92
30205	crime	Queensland	2	10	4	6	52	5
30272	crime	Queensland	1	2	2	2	4	2
30309	crime	Queensland	2	5	2	3	13	2.5
30342	crime	Queensland	1	3	3	3	9	3
30379	crime	Queensland	1,890	6,186	1	9	30,370	3.27
30444	crime	Queensland	2	4	1	3	10	2
30521	crime	Queensland	1	2	2	2	4	2
30571	crime	Queensland	4	17	2	6	81	4.25
30585	crime	Queensland	1	9	9	9	81	9
30602	crime	Queensland	1	1	1	1	1	1
30624	crime	Queensland	1	8	8	8	64	8
30628	crime	Queensland	1	2	2	2	4	2
30705	crime	Queensland	1	1	1	1	1	1
30741	crime	Queensland	2	9	2	7	53	4.5
30756	crime	Queensland	1	2	2	2	4	2
30904	crime	Queensland	1	4	4	4	16	4