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

Twitter sentiment by suburb (SAL), page 16 of 272
sal_codeTEXT	topicTEXT	stateTEXT	tweet_countINTEGER	score_sumINTEGER	score_minINTEGER	score_maxINTEGER	score_sumsqrINTEGER	avg_scoreREAL
11129	all	New South Wales	3	17	5	7	99	5.67
11131	all	New South Wales	2	10	5	5	50	5
11141	all	New South Wales	4	22	2	8	142	5.5
11144	all	New South Wales	20	95	1	8	501	4.75
11146	all	New South Wales	2	10	5	5	50	5
11148	all	New South Wales	2	7	2	5	29	3.5
11155	all	New South Wales	18	111	2	9	745	6.17
11159	all	New South Wales	1	4	4	4	16	4
11160	all	New South Wales	1	5	5	5	25	5
11161	all	New South Wales	1	5	5	5	25	5
11170	all	New South Wales	1	5	5	5	25	5
11175	all	New South Wales	1	6	6	6	36	6
11177	all	New South Wales	502	2,590	1	9	15,066	5.16
11178	all	New South Wales	1	5	5	5	25	5
11183	all	New South Wales	1	4	4	4	16	4
11186	all	New South Wales	1	5	5	5	25	5
11191	all	New South Wales	1	5	5	5	25	5
11192	all	New South Wales	15	82	3	7	468	5.47
11195	all	New South Wales	2	13	4	9	97	6.5
11200	all	New South Wales	10	57	3	8	351	5.7
11201	all	New South Wales	1	8	8	8	64	8
11203	all	New South Wales	4	22	4	8	130	5.5
11207	all	New South Wales	2	12	5	7	74	6
11213	all	New South Wales	117	658	1	9	4,002	5.62
11216	all	New South Wales	77	401	2	8	2,223	5.21