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

Twitter sentiment by suburb (SAL), page 46 of 272
sal_codeTEXT	topicTEXT	stateTEXT	tweet_countINTEGER	score_sumINTEGER	score_minINTEGER	score_maxINTEGER	score_sumsqrINTEGER	avg_scoreREAL
13557	all	New South Wales	1	8	8	8	64	8
13560	all	New South Wales	7	32	3	6	154	4.57
13565	all	New South Wales	1	7	7	7	49	7
13566	all	New South Wales	4	22	4	7	130	5.5
13569	all	New South Wales	14	78	3	9	464	5.57
13571	all	New South Wales	4	19	4	5	91	4.75
13574	all	New South Wales	2	10	5	5	50	5
13579	all	New South Wales	8	48	4	8	302	6
13580	all	New South Wales	88	539	1	9	3,547	6.12
13585	all	New South Wales	8	42	5	7	224	5.25
13586	all	New South Wales	1	7	7	7	49	7
13587	all	New South Wales	16	78	3	5	384	4.88
13591	all	New South Wales	212	1,311	3	9	8,319	6.18
13596	all	New South Wales	28	150	2	8	854	5.36
13597	all	New South Wales	5	32	4	9	222	6.4
13605	all	New South Wales	2	15	6	9	117	7.5
13616	all	New South Wales	235	1,300	1	9	7,968	5.53
13620	all	New South Wales	4	24	5	7	146	6
13621	all	New South Wales	3	20	5	8	138	6.67
13623	all	New South Wales	7	38	4	7	216	5.43
13624	all	New South Wales	1	8	8	8	64	8
13635	all	New South Wales	3	15	5	5	75	5
13637	all	New South Wales	1	5	5	5	25	5
13639	all	New South Wales	29,128	161,676	1	9	983,422	5.55
13641	all	New South Wales	15	77	5	7	399	5.13