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

Twitter sentiment by suburb (SAL), page 249 of 272
sal_codeTEXT	topicTEXT	stateTEXT	tweet_countINTEGER	score_sumINTEGER	score_minINTEGER	score_maxINTEGER	score_sumsqrINTEGER	avg_scoreREAL
50899	income	Western Australia	2	12	6	6	72	6
50915	income	Western Australia	1	7	7	7	49	7
50916	income	Western Australia	4	30	5	9	236	7.5
50921	income	Western Australia	1	8	8	8	64	8
50926	income	Western Australia	1	5	5	5	25	5
50938	income	Western Australia	3	17	4	8	105	5.67
50977	income	Western Australia	1	5	5	5	25	5
50988	income	Western Australia	1	9	9	9	81	9
51004	income	Western Australia	37	241	1	9	1,717	6.51
51033	income	Western Australia	1	5	5	5	25	5
51035	income	Western Australia	1	9	9	9	81	9
51048	income	Western Australia	1	9	9	9	81	9
51056	income	Western Australia	3	16	2	9	110	5.33
51083	income	Western Australia	3	22	7	8	162	7.33
51086	income	Western Australia	1	7	7	7	49	7
51093	income	Western Australia	3	19	2	9	149	6.33
51095	income	Western Australia	1	5	5	5	25	5
51111	income	Western Australia	40	207	1	9	1,323	5.18
51153	income	Western Australia	1	7	7	7	49	7
51157	income	Western Australia	24	138	2	9	884	5.75
51158	income	Western Australia	2	7	3	4	25	3.5
51180	income	Western Australia	1	6	6	6	36	6
51200	income	Western Australia	1	2	2	2	4	2
51201	income	Western Australia	1	6	6	6	36	6
51227	income	Western Australia	2	17	8	9	145	8.5