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

Twitter sentiment by suburb (SAL), page 182 of 272
sal_codeTEXT	topicTEXT	stateTEXT	tweet_countINTEGER	score_sumINTEGER	score_minINTEGER	score_maxINTEGER	score_sumsqrINTEGER	avg_scoreREAL
51190	all	Western Australia	2	10	5	5	50	5
51198	all	Western Australia	7	43	5	8	277	6.14
51200	all	Western Australia	10	54	2	9	324	5.4
51201	all	Western Australia	35	183	3	8	983	5.23
51215	all	Western Australia	1	5	5	5	25	5
51217	all	Western Australia	1	5	5	5	25	5
51218	all	Western Australia	6	33	4	8	191	5.5
51223	all	Western Australia	2	10	5	5	50	5
51224	all	Western Australia	31	149	1	9	779	4.81
51227	all	Western Australia	11	68	5	9	448	6.18
51228	all	Western Australia	2	13	5	8	89	6.5
51229	all	Western Australia	3	14	2	7	78	4.67
51230	all	Western Australia	170,497	937,984	1	9	5,664,386	5.5
51237	all	Western Australia	1	5	5	5	25	5
51242	all	Western Australia	1	5	5	5	25	5
51243	all	Western Australia	2	10	5	5	50	5
51244	all	Western Australia	3	19	5	7	123	6.33
51245	all	Western Australia	1	9	9	9	81	9
51247	all	Western Australia	85	528	3	9	3,480	6.21
51248	all	Western Australia	6	38	5	9	262	6.33
51253	all	Western Australia	5	25	5	5	125	5
51255	all	Western Australia	2	10	5	5	50	5
51256	all	Western Australia	1	5	5	5	25	5
51259	all	Western Australia	1,046	6,075	1	9	38,303	5.81
51262	all	Western Australia	3	18	5	8	114	6