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

Twitter sentiment by suburb (SAL), page 256 of 272
sal_codeTEXT	topicTEXT	stateTEXT	tweet_countINTEGER	score_sumINTEGER	score_minINTEGER	score_maxINTEGER	score_sumsqrINTEGER	avg_scoreREAL
10044	crime	New South Wales	1	7	7	7	49	7
10086	crime	New South Wales	2	16	8	8	128	8
10163	crime	New South Wales	4	10	1	5	36	2.5
10165	crime	New South Wales	1	4	4	4	16	4
10175	crime	New South Wales	1	4	4	4	16	4
10181	crime	New South Wales	1	2	2	2	4	2
10203	crime	New South Wales	1	1	1	1	1	1
10231	crime	New South Wales	63	134	1	9	502	2.13
10253	crime	New South Wales	2	9	3	6	45	4.5
10273	crime	New South Wales	2	13	5	8	89	6.5
10279	crime	New South Wales	4	18	3	7	90	4.5
10319	crime	New South Wales	1	1	1	1	1	1
10321	crime	New South Wales	1	5	5	5	25	5
10392	crime	New South Wales	2	8	3	5	34	4
10423	crime	New South Wales	10	45	1	8	289	4.5
10520	crime	New South Wales	4	17	1	6	87	4.25
10534	crime	New South Wales	17	95	1	9	671	5.59
10544	crime	New South Wales	3	12	2	5	54	4
10589	crime	New South Wales	22	89	1	8	449	4.05
10605	crime	New South Wales	1	2	2	2	4	2
10667	crime	New South Wales	5	9	1	5	29	1.8
10681	crime	New South Wales	1	1	1	1	1	1
10682	crime	New South Wales	1	7	7	7	49	7
10731	crime	New South Wales	1	7	7	7	49	7
10756	crime	New South Wales	55	196	1	9	1,064	3.56