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

Twitter sentiment by suburb (SAL), page 259 of 272
sal_codeTEXT	topicTEXT	stateTEXT	tweet_countINTEGER	score_sumINTEGER	score_minINTEGER	score_maxINTEGER	score_sumsqrINTEGER	avg_scoreREAL
12839	crime	New South Wales	2	5	2	3	13	2.5
12877	crime	New South Wales	4	13	1	9	87	3.25
12879	crime	New South Wales	3	9	2	5	33	3
12898	crime	New South Wales	1	7	7	7	49	7
12909	crime	New South Wales	1	7	7	7	49	7
12958	crime	New South Wales	166	509	1	9	2,325	3.07
12986	crime	New South Wales	1	8	8	8	64	8
12992	crime	New South Wales	3	12	2	8	72	4
13039	crime	New South Wales	2	2	1	1	2	1
13060	crime	New South Wales	1	7	7	7	49	7
13081	crime	New South Wales	2	3	1	2	5	1.5
13103	crime	New South Wales	16	59	1	7	285	3.69
13162	crime	New South Wales	3	10	2	5	38	3.33
13195	crime	New South Wales	1	8	8	8	64	8
13262	crime	New South Wales	5	23	1	8	143	4.6
13269	crime	New South Wales	1	3	3	3	9	3
13297	crime	New South Wales	1	2	2	2	4	2
13304	crime	New South Wales	5	8	1	2	14	1.6
13340	crime	New South Wales	12	40	1	8	202	3.33
13518	crime	New South Wales	1	3	3	3	9	3
13616	crime	New South Wales	2	5	2	3	13	2.5
13639	crime	New South Wales	215	818	1	9	4,262	3.8
13648	crime	New South Wales	9	22	1	5	72	2.44
13651	crime	New South Wales	63	241	1	9	1,253	3.83
13699	crime	New South Wales	2	4	1	3	10	2