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

Twitter sentiment by suburb (SAL), page 25 of 272
sal_codeTEXT	topicTEXT	stateTEXT	tweet_countINTEGER	score_sumINTEGER	score_minINTEGER	score_maxINTEGER	score_sumsqrINTEGER	avg_scoreREAL
11897	all	New South Wales	116	652	1	9	4,036	5.62
11898	all	New South Wales	37	229	4	9	1,485	6.19
11901	all	New South Wales	2	10	5	5	50	5
11904	all	New South Wales	1	5	5	5	25	5
11907	all	New South Wales	13	71	5	7	397	5.46
11912	all	New South Wales	5	31	5	8	197	6.2
11917	all	New South Wales	2,996	16,196	1	9	97,150	5.41
11919	all	New South Wales	22	127	4	8	767	5.77
11923	all	New South Wales	1	5	5	5	25	5
11925	all	New South Wales	1	5	5	5	25	5
11927	all	New South Wales	68	347	1	9	2,045	5.1
11928	all	New South Wales	2	12	4	8	80	6
11932	all	New South Wales	2	10	4	6	52	5
11933	all	New South Wales	16	83	4	8	441	5.19
11934	all	New South Wales	1	5	5	5	25	5
11935	all	New South Wales	1	5	5	5	25	5
11943	all	New South Wales	19	111	4	9	685	5.84
11946	all	New South Wales	2	10	3	7	58	5
11948	all	New South Wales	1	5	5	5	25	5
11952	all	New South Wales	1	5	5	5	25	5
11957	all	New South Wales	11	59	3	7	331	5.36
11961	all	New South Wales	1	6	6	6	36	6
11968	all	New South Wales	1	5	5	5	25	5
11970	all	New South Wales	5	25	5	5	125	5
11971	all	New South Wales	44	237	3	8	1,321	5.39