Tag: linguistics

foo=`sqlite3 door_wordlist.db "SELECT ratings_1.q3 FROM articles LEFT JOIN ratings_1 ON articles.id = ratings_1.id where articles.date_utc > date('2007-11-11 03:30:00') ORDER BY articles.date;"`; python _test-sparkline.py $foo > r7.gif

and 10 days of aggregated sentiment
foo=`sqlite3 door_wordlist.db 'select r1q3 from scores order by date desc limit 240;'`; python _test-sparkline.py $foo > agg13.gif

Fearful spark from the last week. Simple sparklines.

sqlite> SELECT ratings_1.q3 FROM articles LEFT JOIN ratings_1 ON articles.id = ratings_1.id WHERE date(articles.date) > "2007-10-21" ORDER BY articles.date;

[spark] [type line] [size 30,330] [series 0.144403792499,0.0738422091162,0.204887587994,0.0,0.0,0.257322806016,0.170458339935,0.186673693907,0.103929163868,0.113549465655,0.222691506218,0.190330239872,0.0,0.169294870468,0.0881183138969,0.170869077271,0.219570823594,0.0629105073619,0.0,0.187879411561,0.154360207598,0.0955314706589,0.118257977181,0.0269139996558,0.22956545669,0.242917155542,0.184570256009,0.0,0.166541138141,0.204739216492,0.395745509549,0.272438688431,0.300362929308,0.171071168897,0.168410757751,0.197797123779,0.206781926938,0.0,0.204114691277,0.458221956257,0.306912528889,0.156173343527,0.179199213931,0.128763036576,0.188048344797,0.263415832583,0.0667314353696,0.0928106708179,0.0489320370692,0.28285154363,0.102676967004,0.205410857796,0.180058510657,0.0,0.302150946612,0.200117673982,0.205120331381,0.0903359797936,0.0,0.0,0.0407977380077,0.343606310847,0.245301066909,0.0685350862472,0.197186872409,0.0,0.108442533404,0.222020599414,0.163188714723,0.211963827224,0.0,0.203691354004,0.20492592301,0.0,0.0,0.0751663103793,0.201152891167,0.0,0.115092050817,0.132877350819,0.20462455334,0.0,0.249949356504,0.191826745571,0.371606310847,0.200400427149,0.0435705335247,0.154841241486,0.231762577446,0.181983698832,0.11557728227,0.182564572313,0.106533709448,0.21189290552,0.34263669809,0.216213577576,0.352227549616,0.288323719879,0.284514807808,0.194713933813,0.0405019674178,0.325460826646,0.221896493737,0.191199857295,0.218096885842,0.185490853464,0.263556089428,0.0,0.267499360342,0.20033162965,0.221394595371,0.120537915134,0.187392106198,0.232570076397,0.299523228975,0.0628330680692,0.0867815157469,0.0,0.353321728998,0.250918751953,0.231747498782,0.338297663081,0.118941138141,0.157017883254,0.18608078757,0.20205730704,0.111995034835,0.230058028785,0.0,0.208501063974,0.251435203527,0.281913617197,0.341707888559,0.337264184755,0.0,0.0862635081424,0.158564599959,0.218699545774,0.277658374705,0.21823719041,0.0738239713951,0.174927722476,0.12694195838,0.0,0.0,0.222375084737,0.194365479852,0.225386522303,0.217465810455,0.205099545774,0.302687613369,0.0424289528377,0.331825025118,0.116068810202,0.211098203545,0.0,0.210390084556,0.472840252389,0.181962918787,0.24107188739,0.250008279537,0.535895343884,0.0,0.0,0.0636864753507,0.208855016275,0.192705183095,0.357856294526,0.308615997979,0.0,0.336940107289,0.406977270392,0.271181135937,0.0,0.237618105788,0.181561563461,0.49806841757,0.424735770734,0.285979740021,0.0417627417663,0.0,0.32777858925,0.200781481218,0.0,0.211982118829,0.0,0.0632048333594,0.177920720934,0.443702185723,0.0,0.117188357238,0.160588111842,0.0462361902277,0.207105926186,0.249367818181,0.201683007792,0.200811066894,0.0414516009273,0.307566796638,0.0,0.183638815662,0.424071870935,0.216353995754,0.051064495111,0.1724479168,0.206680761243,0.247149406973,0.191324576819,0.114541138141,0.23423497128,0.251761771001,0.222247048798,0.221091506218,0.299991807628,0.176782986976,0.196657047389,0.376979940325,0.217360341508,0.279394381713,0.202435772029,0.474450413016,0.0,0.204511512726,0.193654468484,0.215752959267,0.194278377085,0.0888815771572,0.1559476333,0.20183315059,0.392370416352,0.0608409842369,0.182307704863,0.0329599027012,0.0,0.214114130146,0.215096080957,0.168403829196,0.283489770201,0.207045788109,0.301012015935,0.32795851523,0.237511589244,0.205240454253,0.193643199734,0.156967047706,0.185087096817,0.216484921118,0.312799810605,0.168591122788,0.198567164056,0.215549033362,0.150963355476,0.185751339661,0.0,0.195498410118,0.0312706857907,0.187555820087,0.185474894518,0.0,0.0,0.3740636416,0.194347431728,0.193435033196,0.0645271103961,0.20063315059,0.289826245232,0.207268444311,0.078007186525,0.295005050968,0.0,0.107187809607,0.0331265075438,0.195473369476,0.172245422966,0.245070243113,0.0,0.203156855076,0.201949913623,0.217881466369,0.338552043072,0.407901863475,0.210908152562,0.110941138141,0.0772859202065,0.1975476333,0.188466661189,0.282346917148,0.0416259425731,0.210762929308,0.336431847616,0.291833525923,0.117375189626,0.0,0.0,0.0,0.296813098853,0.246786153582,0.0,0.0588706857907,0.211198367215,0.30424185602,0.0,0.145807180706,0.336697663081,0.229914741242,0.176913786532,0.0461943389957,0.0,0.0,0.355080026745,0.182101700019,0.0,0.331484385893,0.0980488087154,0.293961805403,0.19527677214,0.160459011477,0.218960214723,0.163399479521,0.0,0.252685045914,0.214732803369,0.319345722737,0.16399565138,0.0,0.20089827829,0.083727209182,0.188773634208,0.155460945343,0.176683891179][dot 7,50,5,green][/spark]