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

Twitter sentiment by suburb (SAL), page 35 of 272
sal_codeTEXT	topicTEXT	stateTEXT	tweet_countINTEGER	score_sumINTEGER	score_minINTEGER	score_maxINTEGER	score_sumsqrINTEGER	avg_scoreREAL
12649	all	New South Wales	8	57	5	8	413	7.12
12650	all	New South Wales	1	9	9	9	81	9
12651	all	New South Wales	2	10	5	5	50	5
12655	all	New South Wales	1	6	6	6	36	6
12662	all	New South Wales	1	5	5	5	25	5
12664	all	New South Wales	9	45	5	5	225	5
12665	all	New South Wales	143	901	2	9	6,075	6.3
12667	all	New South Wales	1	5	5	5	25	5
12674	all	New South Wales	1	5	5	5	25	5
12680	all	New South Wales	31	193	4	9	1,247	6.23
12682	all	New South Wales	10	51	3	7	269	5.1
12683	all	New South Wales	9	53	5	9	329	5.89
12691	all	New South Wales	1	5	5	5	25	5
12693	all	New South Wales	1	5	5	5	25	5
12695	all	New South Wales	2	10	5	5	50	5
12697	all	New South Wales	1	7	7	7	49	7
12698	all	New South Wales	1	5	5	5	25	5
12699	all	New South Wales	2	10	5	5	50	5
12707	all	New South Wales	1	7	7	7	49	7
12709	all	New South Wales	4	21	5	6	111	5.25
12710	all	New South Wales	2	10	5	5	50	5
12713	all	New South Wales	87	531	2	9	3,461	6.1
12716	all	New South Wales	37	207	2	9	1,255	5.59
12719	all	New South Wales	1	5	5	5	25	5
12723	all	New South Wales	6	31	5	6	161	5.17