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

Twitter sentiment by suburb (SAL), page 31 of 272
sal_codeTEXT	topicTEXT	stateTEXT	tweet_countINTEGER	score_sumINTEGER	score_minINTEGER	score_maxINTEGER	score_sumsqrINTEGER	avg_scoreREAL
12340	all	New South Wales	1	5	5	5	25	5
12342	all	New South Wales	1	5	5	5	25	5
12344	all	New South Wales	2	10	5	5	50	5
12346	all	New South Wales	1	5	5	5	25	5
12348	all	New South Wales	3	20	5	8	138	6.67
12352	all	New South Wales	1	5	5	5	25	5
12356	all	New South Wales	1,460	5,748	1	9	30,778	3.94
12358	all	New South Wales	5	27	2	8	167	5.4
12361	all	New South Wales	1	5	5	5	25	5
12362	all	New South Wales	1	5	5	5	25	5
12367	all	New South Wales	1	5	5	5	25	5
12370	all	New South Wales	86	467	1	9	2,877	5.43
12373	all	New South Wales	1	6	6	6	36	6
12374	all	New South Wales	4	23	4	7	139	5.75
12377	all	New South Wales	13	66	2	7	352	5.08
12378	all	New South Wales	17	101	4	8	635	5.94
12380	all	New South Wales	1	1	1	1	1	1
12385	all	New South Wales	34	186	2	8	1,080	5.47
12387	all	New South Wales	9	45	2	7	239	5
12393	all	New South Wales	1	8	8	8	64	8
12396	all	New South Wales	54	292	1	9	1,750	5.41
12398	all	New South Wales	1	9	9	9	81	9
12401	all	New South Wales	1	5	5	5	25	5
12403	all	New South Wales	5	27	5	7	149	5.4
12405	all	New South Wales	16	88	3	9	514	5.5