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

Twitter sentiment by suburb (SAL), page 269 of 272
sal_codeTEXT	topicTEXT	stateTEXT	tweet_countINTEGER	score_sumINTEGER	score_minINTEGER	score_maxINTEGER	score_sumsqrINTEGER	avg_scoreREAL
41058	crime	South Australia	4	23	4	7	139	5.75
41135	crime	South Australia	1	2	2	2	4	2
41137	crime	South Australia	2	7	2	5	29	3.5
41143	crime	South Australia	2	10	3	7	58	5
41201	crime	South Australia	7	23	2	5	85	3.29
41211	crime	South Australia	29	78	1	6	282	2.69
41218	crime	South Australia	2	9	1	8	65	4.5
41281	crime	South Australia	9	42	1	9	284	4.67
41282	crime	South Australia	1	8	8	8	64	8
41349	crime	South Australia	2	4	1	3	10	2
41396	crime	South Australia	1	3	3	3	9	3
41502	crime	South Australia	2	10	4	6	52	5
41518	crime	South Australia	7	22	1	7	104	3.14
41585	crime	South Australia	6	21	1	7	95	3.5
41610	crime	South Australia	1	7	7	7	49	7
50006	crime	Western Australia	17	50	1	7	212	2.94
50038	crime	Western Australia	2	9	2	7	53	4.5
50049	crime	Western Australia	1	4	4	4	16	4
50177	crime	Western Australia	1	4	4	4	16	4
50190	crime	Western Australia	5	12	1	5	40	2.4
50192	crime	Western Australia	28	73	1	6	281	2.61
50210	crime	Western Australia	19	68	1	7	326	3.58
50213	crime	Western Australia	1	2	2	2	4	2
50228	crime	Western Australia	20	93	1	8	553	4.65
50267	crime	Western Australia	1	2	2	2	4	2