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

Twitter sentiment by suburb (SAL), page 205 of 272
sal_codeTEXT	topicTEXT	stateTEXT	tweet_countINTEGER	score_sumINTEGER	score_minINTEGER	score_maxINTEGER	score_sumsqrINTEGER	avg_scoreREAL
80022	all	Australian Capital Territory	3	21	5	8	153	7
80024	all	Australian Capital Territory	9	52	2	9	338	5.78
80025	all	Australian Capital Territory	1	3	3	3	9	3
80026	all	Australian Capital Territory	7	41	2	9	277	5.86
80027	all	Australian Capital Territory	63	370	1	9	2,384	5.87
80030	all	Australian Capital Territory	97	593	1	9	3,957	6.11
80033	all	Australian Capital Territory	17	95	4	8	557	5.59
80034	all	Australian Capital Territory	1	6	6	6	36	6
80035	all	Australian Capital Territory	2	11	3	8	73	5.5
80038	all	Australian Capital Territory	3,136	17,364	1	9	102,502	5.54
80040	all	Australian Capital Territory	18	113	5	9	751	6.28
80041	all	Australian Capital Territory	1	3	3	3	9	3
80042	all	Australian Capital Territory	2	9	4	5	41	4.5
80043	all	Australian Capital Territory	15	78	2	7	428	5.2
80044	all	Australian Capital Territory	72	465	2	9	3,197	6.46
80046	all	Australian Capital Territory	9	54	5	8	336	6
80048	all	Australian Capital Territory	3	21	5	9	155	7
80051	all	Australian Capital Territory	1	3	3	3	9	3
80059	all	Australian Capital Territory	32	179	2	8	1,071	5.59
80060	all	Australian Capital Territory	1	5	5	5	25	5
80063	all	Australian Capital Territory	2	10	5	5	50	5
80066	all	Australian Capital Territory	8	41	3	9	235	5.12
80068	all	Australian Capital Territory	11	56	4	8	296	5.09
80069	all	Australian Capital Territory	1	3	3	3	9	3
80070	all	Australian Capital Territory	200	1,227	1	9	8,197	6.14