mediacloud_python_api_test



In [1]:
import cPickle
import os.path

api_key = cPickle.load( file( os.path.expanduser( '~/mediacloud_api_key.pickle' ), 'r' ) )

In [2]:
import cPickle
import os.path

cPickle.dump( api_key, file( os.path.expanduser( '~/mediacloud_api_key.pickle' ), 'wb' ) )

In [3]:
import mediacloud, json
mc = mediacloud.api.MediaCloud(api_key)

In [4]:
all_media = []

last_media_id = 0

while True:
    media = mc.mediaList( last_media_id=last_media_id, rows=1000)
    print last_media_id, len( media ), len( all_media )

    if len(media) == 0:
        break
        
    last_media_id = media[-1]['media_id']
    last_media_id
    

        
    all_media.extend(media)
    
    if len( all_media ) > 200:
        break

len(all_media)


0 1000 0
Out[4]:
1000

In [27]:
def fetch_1000_stories_id_from_query( solr_query ):  
    q = "+sentence_number:0 AND {} ".format( solr_query )
    d = mc.sentenceList( solr_query=q, 
                        sort=mc.SORT_RANDOM, rows=1000 )
    ret = [ s['stories_id'] for s in d['response']['docs'] ]
    return ret

fetch_1000_stories_id_from_query( '+publish_date:[2014-05-10T00:00:00Z TO 2014-05-21T00:00:00Z} AND media_id:1 ' )


Out[27]:
[231964249,
 232594030,
 231182766,
 231555274,
 232305211,
 231585778,
 233102128,
 231268906,
 231983727,
 233314065,
 233949045,
 232390854,
 231905341,
 232784129,
 231535745,
 230782223,
 232403748,
 233650883,
 232784130,
 232022879,
 230737819,
 231921013,
 230792041,
 231348518,
 230515203,
 232432655,
 231208778,
 232362049,
 233345311,
 233968306,
 232380754,
 231161006,
 232745333,
 231655836,
 231168298,
 233102133,
 232440811,
 231744712,
 233242426,
 233016993,
 233422000,
 233650566,
 231012227,
 233971077,
 232941925,
 232356621,
 232688893,
 230544202,
 232006292,
 232950361,
 233221923,
 232043804,
 232707550,
 231163628,
 232571320,
 232290032,
 232012174,
 230832167,
 231142514,
 232325238,
 232408655,
 233102119,
 233603523,
 230540781,
 231921016,
 231628711,
 233569827,
 232010739,
 230999864,
 230536140,
 232753502,
 232726549,
 231893437,
 233281604,
 233102138,
 232320197,
 233650870,
 233577587,
 233442235,
 232336788,
 232286625,
 232676115,
 231180392,
 232354919,
 232343449,
 233795522,
 233194296,
 231163640,
 231165765,
 233919904,
 231595505,
 233793406,
 232440052,
 232275710,
 231212798,
 233317422,
 230832434,
 233617044,
 233470812,
 231857769,
 231973209,
 233791699,
 232287401,
 234281847,
 232102205,
 231988291,
 233245365,
 231600215,
 233422115,
 231574678,
 231003611,
 233853799,
 233995205,
 230796889,
 231276248,
 231369486,
 230556890,
 231635336,
 233650566,
 233797128,
 232689954,
 231153434,
 230762253,
 230736780,
 230575074,
 232715593,
 232002127,
 231369483,
 231208006,
 230556869,
 232320520,
 230515855,
 233934300,
 232038971,
 232954550,
 232680895,
 231498157,
 232676102,
 232994740,
 233242428,
 231277588,
 233929971,
 231182764,
 233102139,
 234803936,
 233564784,
 233876534,
 232347565,
 232688685,
 232582174,
 230736933,
 231185978,
 232360919,
 233781718,
 230556888,
 232384088,
 231165779,
 231966936,
 232717628,
 233934102,
 231153408,
 233442242,
 232749297,
 276219736,
 231916731,
 232209791,
 233637842,
 231583280,
 233604716,
 233245364,
 232878395,
 232689046,
 233643036,
 230540795,
 232347569,
 231023548,
 231558775,
 233795522,
 231134039,
 230709772,
 231180395,
 233948959,
 233873810,
 233280586,
 232689624,
 232437121,
 233649803,
 233938297,
 234509244,
 233314063,
 232990509,
 231540050,
 230792043,
 231743217,
 232638248,
 231165774,
 231616947,
 233234066,
 231523191,
 232810118,
 232738056,
 232403196,
 233248232,
 232747009,
 233232358,
 232390799,
 230536126,
 231554849,
 231978686,
 230769285,
 231208775,
 233571641,
 230720089,
 232394805,
 230755051,
 230491867,
 232364476,
 231744712,
 232765755,
 231446731,
 231506267,
 232379182,
 231498160,
 232985756,
 231853552,
 232517875,
 232001986,
 232981509,
 233776416,
 232289255,
 232305212,
 231966933,
 231277588,
 233569827,
 231244120,
 231966936,
 233039857,
 232037798,
 230809108,
 232529734,
 232403749,
 232290031,
 230536115,
 233938293,
 232704789,
 231554290,
 232288631,
 230491869,
 233621974,
 232765683,
 233102140,
 232289821,
 233102113,
 232393235,
 231959531,
 230536120,
 232595419,
 232289249,
 233995198,
 231593015,
 232689075,
 231231184,
 232017103,
 233611338,
 231436703,
 232364481,
 231192318,
 233938292,
 232394795,
 231244038,
 232688123,
 230720082,
 232801384,
 231277503,
 231614449,
 231624340,
 230736776,
 231212801,
 233223746,
 233867327,
 232287201,
 231208763,
 231703209,
 233497851,
 230542552,
 233649714,
 232765683,
 232320524,
 233495366,
 233621970,
 232187225,
 232753519,
 231276941,
 233910550,
 233797128,
 233102130,
 230736777,
 232406266,
 232919584,
 233260690,
 233584728,
 231661794,
 233642783,
 233571596,
 232362051,
 233242674,
 231262297,
 233648672,
 233948962,
 232747009,
 232002127,
 231180389,
 231570932,
 233911986,
 231000872,
 233933067,
 230769290,
 232394801,
 231212796,
 231009548,
 233517874,
 233637954,
 232432660,
 230556886,
 231992942,
 231628049,
 233922986,
 232990206,
 233910549,
 233468786,
 233321236,
 232988315,
 232108274,
 232573684,
 233954287,
 233696806,
 231988288,
 233102139,
 231182773,
 231153429,
 233245417,
 232676117,
 232747013,
 232994746,
 232689050,
 231576880,
 232709330,
 231023546,
 232017105,
 231161007,
 233276865,
 233247451,
 231185995,
 232287200,
 231278098,
 233321281,
 233849244,
 232290033,
 231635344,
 232692282,
 232406266,
 232289737,
 231964249,
 230720087,
 233571599,
 232717448,
 232878403,
 232595419,
 231237440,
 230832179,
 233260097,
 233612146,
 232406263,
 231165762,
 232517874,
 232729966,
 231595459,
 231148548,
 231208768,
 232638250,
 233388299,
 231545932,
 233623365,
 232399398,
 231595464,
 231655834,
 232390798,
 231103564,
 231978985,
 231916733,
 230521938,
 233791440,
 231148545,
 231103281,
 231717215,
 232038983,
 232020940,
 231148552,
 231161003,
 233102144,
 233264268,
 232740511,
 233263601,
 230536137,
 231185995,
 233627305,
 233003733,
 232636671,
 232945073,
 230793561,
 233242424,
 233258945,
 231703211,
 230832175,
 231161012,
 231528690,
 232596992,
 232754232,
 232744479,
 233642779,
 231703213,
 230514868,
 232437846,
 231134050,
 230542843,
 233053166,
 231134034,
 232394498,
 230712392,
 231185811,
 231187744,
 231220778,
 233533830,
 233344272,
 232944973,
 233271801,
 231277414,
 231446744,
 231278097,
 231343625,
 230540793,
 232379180,
 232393237,
 233565422,
 232689065,
 231603907,
 231978979,
 230832162,
 233564645,
 231212801,
 231978683,
 232784131,
 230720191,
 231595510,
 231999874,
 231785342,
 230536115,
 232915974,
 232006563,
 232370416,
 233666257,
 231635346,
 231635351,
 232396914,
 232689088,
 232230944,
 231535745,
 231161015,
 232731776,
 231161013,
 232661968,
 231744722,
 231012231,
 233422109,
 232681772,
 231616947,
 233650372,
 233039855,
 230832432,
 231744695,
 232290289,
 233586491,
 232020927,
 232729966,
 233229991,
 231811239,
 231210133,
 231300952,
 231571527,
 231917674,
 232589269,
 232347563,
 233649157,
 230809961,
 234066875,
 232784127,
 231516091,
 231192320,
 231180393,
 230869540,
 232116733,
 230518877,
 233555144,
 232432657,
 232384091,
 231628942,
 233649709,
 231148548,
 232360921,
 230736928,
 233260029,
 231281306,
 232467097,
 231543380,
 231943984,
 232038976,
 232006573,
 231523996,
 230832180,
 231276938,
 230770519,
 232384093,
 231853355,
 233013971,
 232689418,
 232676107,
 231153411,
 231999874,
 232344050,
 233577587,
 231663164,
 232599489,
 231763966,
 232735138,
 233313509,
 230809932,
 231153409,
 230792107,
 233621966,
 230970000,
 231967527,
 232715595,
 232275710,
 230788386,
 231576879,
 233216245,
 231599840,
 232435276,
 230832165,
 233215356,
 232967293,
 231522876,
 233563169,
 233170450,
 231446744,
 230736932,
 231185982,
 231853355,
 233225402,
 233258926,
 231142530,
 230705572,
 233215353,
 231231182,
 233200863,
 233242426,
 233630051,
 231210131,
 231192322,
 233943810,
 232467086,
 232765756,
 231801121,
 231142537,
 231703211,
 232676649,
 232248190,
 233442228,
 233922991,
 232715576,
 239660632,
 232735154,
 231746938,
 233776400,
 233521051,
 233867387,
 232995980,
 230769286,
 233102143,
 231187739,
 233911704,
 231989512,
 232012177,
 233648866,
 231353079,
 230676264,
 281606914,
 233345311,
 233776417,
 232747008,
 232343693,
 232724487,
 231628717,
 233233699,
 239667103,
 231635337,
 234509246,
 232006563,
 230574003,
 230523026,
 231922715,
 231192319,
 230778331,
 233261076,
 231628054,
 232990509,
 232271093,
 231335933,
 232916878,
 232037797,
 232010317,
 231917674,
 231634657,
 232037800,
 232356025,
 231277088,
 230765568,
 231907287,
 231632948,
 232381172,
 231281303,
 231522518,
 234260846,
 232990206,
 230812858,
 231210134,
 231967527,
 233017006,
 230774266,
 281765000,
 231540047,
 230515203,
 233922982,
 232943906,
 231163636,
 232343411,
 231703204,
 231281572,
 231241284,
 233948965,
 232920883,
 233157537,
 232042833,
 230518533,
 233276422,
 231225814,
 231276937,
 231936703,
 233648675,
 231276932,
 231234107,
 232406263,
 230528000,
 233464257,
 230740563,
 232395438,
 230720081,
 230515855,
 232754231,
 232721018,
 231660183,
 233569442,
 233238123,
 232118562,
 232689037,
 232769773,
 233577556,
 233571598,
 230832169,
 232753498,
 231300036,
 232753515,
 232878398,
 233570207,
 232767241,
 231192319,
 232676099,
 232037813,
 231226523,
 232330166,
 231268903,
 232042830,
 231148544,
 233779968,
 232393235,
 232726490,
 232715591,
 231153426,
 231523240,
 232689069,
 233520667,
 233858751,
 231012228,
 231801121,
 233258938,
 232375795,
 233936527,
 231970633,
 232000743,
 230545576,
 232440050,
 233102125,
 231595464,
 231628060,
 230536122,
 232816176,
 232384085,
 230556866,
 232007161,
 231993019,
 231185979,
 233512889,
 232949157,
 231595123,
 232726488,
 232112822,
 231595462,
 231608143,
 232676099,
 231208769,
 233909689,
 232676106,
 231614628,
 231165775,
 231148542,
 230546836,
 232038969,
 232944967,
 230514868,
 232556841,
 232661968,
 233613840,
 232020951,
 233018991,
 230809953,
 234803942,
 232854037,
 231187773,
 233229986,
 231901908,
 231277502,
 233474464,
 233291690,
 231978684,
 231180310,
 231437253,
 233229991,
 231628060,
 233569444,
 233650104,
 230532305,
 232375798,
 231916737,
 232632782,
 231916735,
 233567906,
 232010742,
 232002555,
 232741549,
 231277416,
 231280474,
 232020946,
 232017720,
 231185973,
 232403200,
 232689072,
 231206463,
 232765690,
 231304208,
 231992739,
 231983744,
 232248564,
 233776416,
 233216246,
 233450727,
 234803946,
 233393055,
 231163635,
 231276935,
 232734452,
 231943441,
 232289738,
 233242423,
 231208010,
 231165769,
 231964244,
 232754068,
 233234066,
 231161010,
 230519221,
 232304924,
 232038976,
 232754231,
 230774267,
 231539310,
 233274575,
 232903869,
 233258926,
 232248190,
 231180302,
 231595506,
 232278370,
 230846159,
 233344898,
 230793559,
 233102135,
 234803944,
 233776404,
 233648674,
 232743464,
 230944448,
 233638052,
 231703221,
 232960320,
 231185978,
 233016991,
 231852011,
 231593124,
 231581026,
 231001166,
 232401434,
 230736935,
 232562251,
 232393233,
 232394812,
 232816178,
 230542390,
 230832000,
 233270399,
 231192306,
 230970000,
 233911704,
 233779966,
 232681770,
 231703216,
 232749302,
 239660530,
 233000795,
 233195814,
 230799692,
 231983719,
 232000745,
 230899540,
 232678610,
 232002507,
 233934299,
 231208766,
 231268906,
 232390854,
 232010742,
 233948961,
 232719903,
 230832162,
 230944448,
 232364471,
 230809956,
 231959531,
 232206178,
 231348529,
 231103272,
 232271094,
 231627432,
 233237935,
 233229993,
 232375801,
 233971077,
 233194300,
 230832157,
 233638050,
 231682603,
 232337065,
 231744718,
 231922851,
 232271094,
 232010760,
 232289821,
 232325238,
 232719907,
 233650369,
 232394498,
 231300957,
 233873810,
 231015534,
 232408660,
 231498161,
 232784129,
 233564647,
 233260687,
 230540785,
 233224618,
 232964855,
 233563681,
 230719900,
 231219198,
 231614597,
 232968116,
 233003734,
 233650568,
 231588711,
 233801054,
 232632782,
 232325159,
 231180313,
 230520967,
 231522514,
 232379178,
 233569444,
 231185987,
 231523997,
 230832176,
 232698644,
 231536362,
 232403189,
 233932437,
 231268900,
 231624350,
 230540793,
 230705571,
 232002134,
 233569859,
 231978977,
 233563168,
 232102080,
 231922639,
 233285550,
 231989514,
 233909492,
 233005006,
 233264268,
 234260846,
 231577204,
 230556883,
 231103568,
 233334803,
 231630863,
 232343449,
 230758956,
 233779964,
 232020570,
 233968306,
 231770250,
 232941924,
 233260016,
 233919903,
 230515078,
 233919904,
 232394504,
 233611338,
 230832167,
 232356465,
 233650373,
 231763966,
 233642775,
 232557048,
 231300952,
 232043804,
 232304922,
 233222376,
 233586473,
 233345316,
 231276920,
 231978803,
 233014018,
 230809957,
 232745324,
 232726551,
 231599630,
 230736936,
 232408659,
 233000793,
 230762966,
 232724481,
 232967293,
 232738460,
 231999838,
 233934096,
 231522333,
 231999700,
 233264264,
 231522512,
 231522927,
 231369490,
 232747007,
 230557186,
 230869540,
 232496810,
 233955733,
 231153432,
 232248564,
 232002558]

In [26]:
len([ (s['stories_id'], s['publish_date']) for s in d['response']['docs'] ])


Out[26]:
1000

In [11]:
mc.story( 243384113 )


Out[11]:
{u'collect_date': u'2014-06-04 06:31:52',
 u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
 u'description': u'<img src="http://i.radikal.com.tr/393x210/2014/05/10/fft83_mf2164015.Jpeg" align="left" width="178" />Erdo\u011fan ve G\xfcl, AK Parti\'nin \xe7at\u0131 aday\u0131 asl\u0131nda. Peki CHP, MHP ve BDP\'nin kendi \xe7at\u0131 aday\u0131 kim?',
 u'full_text_rss': 0,
 u'guid': u'http://www.radikal.com.tr/yazarlar/eyup_can/cati_mi_dediniz-1191333',
 u'is_fully_extracted': 1,
 u'language': u'tr',
 u'media_id': 38924,
 u'publish_date': u'2014-05-10 00:00:00',
 u'stories_id': u'243384113',
 u'story_sentences': [{u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Ne yalan s\xf6yleyeyim ben hi\xe7 heyecanlanmad\xc4\xb1m.',
   u'sentence_number': 0,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792578',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'\xc7\xfcnk\xfc k\xe2\xc4\x9f\xc4\xb1t \xfcst\xfcnde iyi duran bu \xf6nerinin ger\xe7ek hayatta Tayyip Erdo\xc4\x9fan kar\xc5\x9f\xc4\xb1tl\xc4\xb1\xc4\x9f\xc4\xb1 ortak paydas\xc4\xb1 d\xc4\xb1\xc5\x9f\xc4\xb1nda hi\xe7bir kar\xc5\x9f\xc4\xb1l\xc4\xb1\xc4\x9f\xc4\xb1 yok!',
   u'sentence_number': 1,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792579',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Biliyorum baz\xc4\xb1lar\xc4\xb1 i\xe7in AK Parti ya da Erdo\xc4\x9fan kar\xc5\x9f\xc4\xb1tl\xc4\xb1\xc4\x9f\xc4\xb1 tek ba\xc5\x9f\xc4\xb1na bir varolu\xc5\x9f nedeni.',
   u'sentence_number': 2,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792580',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Ama onlar i\xe7in bile \xe7at\xc4\xb1 aday form\xfcl\xfcn\xfcn \xe7al\xc4\xb1\xc5\x9faca\xc4\x9f\xc4\xb1 \xc5\x9f\xfcpheli.',
   u'sentence_number': 3,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792581',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Bir kere Bah\xe7eli\u2019nin milliyet\xe7i muhafazak\xe2r ve maneviyat\xe7\xc4\xb1 aday profiline uygun birini bulmak ve bunu CHP se\xe7menine de kabul ettirmek o kadar kolay de\xc4\x9fil.',
   u'sentence_number': 4,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792582',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u"Diyelim Meral Ak\xc5\x9fener ya da Murat Ba\xc5\x9feskio\xc4\x9flu gibi bir aday \xf6nerdi MHP, CHP y\xf6netimi evet dese bile siyasi kimli\xc4\x9fi \xe7ok belirgin olan bu isimlerin t\xfcm CHP'den oy alabilece\xc4\x9fi \xc5\x9f\xfcpheli.",
   u'sentence_number': 5,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792583',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Siyasi kimli\xc4\x9fi belirgin aday \xe7at\xc4\xb1 form\xfcl\xfcn\xfcn en zay\xc4\xb1f halkas\xc4\xb1.',
   u'sentence_number': 6,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792584',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u"Ayn\xc4\xb1 durum CHP'nin \xf6nerece\xc4\x9fi siyasi kimli\xc4\x9fi olan kucaklay\xc4\xb1c\xc4\xb1 adaylar i\xe7in de s\xf6z konusu.",
   u'sentence_number': 7,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792585',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Gelelim siyasi kimli\xc4\x9fi \xf6ne \xe7\xc4\xb1kmayan Ha\xc5\x9fim K\xc4\xb1l\xc4\xb1\xe7, Ekmeleddin \xc4\xb0hsano\xc4\x9flu gibi adaylara.',
   u'sentence_number': 8,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792586',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u"E\xc4\x9fer cumhurba\xc5\x9fkanl\xc4\xb1\xc4\x9f\xc4\xb1 se\xe7imi eskisi gibi Meclis'te olsa bu tarz adaylar\xc4\xb1n \xc5\x9fans\xc4\xb1 olabilirdi ama ge\xe7mi\xc5\x9f olsun sistem de\xc4\x9fi\xc5\x9fti.",
   u'sentence_number': 9,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792587',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Her ne kadar cumhurba\xc5\x9fkanl\xc4\xb1\xc4\x9f\xc4\xb1 tarafs\xc4\xb1z ve devleti temsil eden sembolik bir makam olarak tarif edilmi\xc5\x9f olsa da adaylar basbaya\xc4\x9f\xc4\xb1 siyasi kampanya y\xfcr\xfctmek zorunda.',
   u'sentence_number': 10,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792588',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Aktif siyaset yapmam\xc4\xb1\xc5\x9f isimler kendi alanlar\xc4\xb1nda t\xfcm sayg\xc4\xb1nl\xc4\xb1klar\xc4\xb1na ra\xc4\x9fmen siyaset sahnesinde acemi olmaktan kurtulamazlar, bu birinci handikap.',
   u'sentence_number': 11,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792589',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Siyaset d\xc4\xb1\xc5\x9f\xc4\xb1 adaylar i\xe7in hi\xe7bir partinin te\xc5\x9fkilat\xc4\xb1 canla ba\xc5\x9fla \xe7al\xc4\xb1\xc5\x9fmaz bu da ikinci sorun.',
   u'sentence_number': 12,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792590',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u"CHP ile MHP'nin hatta BDP\u2019nin gayri resmi bir temas i\xe7inde olduklar\xc4\xb1 Ankara'da herkesin bildi\xc4\x9fi bir s\xc4\xb1r.",
   u'sentence_number': 13,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792591',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Bu temaslarda \xc5\x9fimdiye kadar \xf6ne \xe7\xc4\xb1kan isimler az \xf6nce zikrettiklerim.',
   u'sentence_number': 14,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792592',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Ve hen\xfcz isim konusunda da profil konusunda da bir uzla\xc5\x9fma yok.',
   u'sentence_number': 15,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792593',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Bence olmas\xc4\xb1 da zor.',
   u'sentence_number': 16,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792594',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'\xc7ok zorlan\xc4\xb1rsa belki bir aday \xfczerinde anla\xc5\x9fabilirler ama hem zorlama oldu\xc4\x9fu i\xe7in hem de yukarda sayd\xc4\xb1\xc4\x9f\xc4\xb1m gerek\xe7elerle Erdo\xc4\x9fan kar\xc5\x9f\xc4\xb1s\xc4\xb1nda bu adaylar\xc4\xb1n maalesef \xc5\x9fans\xc4\xb1 yok.',
   u'sentence_number': 17,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792595',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Benim \xc5\x9fahsi kanaatim zorlama ve k\xe2\xc4\x9f\xc4\xb1t \xfczeri form\xfcller yerine her partinin ilk turda \xe7at\xc4\xb1 aday\xc4\xb1 \xe7\xc4\xb1kar\xc4\xb1yor gibi en kucaklay\xc4\xb1c\xc4\xb1 adayla \xe7\xc4\xb1kmas\xc4\xb1.',
   u'sentence_number': 18,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792596',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Sonu\xe7ta se\xe7im iki turlu, kimin aday\xc4\xb1 ilk ikiye kal\xc4\xb1rsa o ikinci turda do\xc4\x9fal \xe7at\xc4\xb1 aday\xc4\xb1 olur.',
   u'sentence_number': 19,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792597',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Bunun d\xc4\xb1\xc5\x9f\xc4\xb1ndaki form\xfcller k\xe2\xc4\x9f\xc4\xb1t \xfczerinde kal\xc4\xb1r.',
   u'sentence_number': 20,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792598',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'\xc7at\xc4\xb1 form\xfcl\xfc ikinci turda \xe7al\xc4\xb1\xc5\x9f\xc4\xb1r ama birinci turda \xe7ok zor!',
   u'sentence_number': 21,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792599',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Erdo\xc4\x9fan ilk turda kazanmas\xc4\xb1n diye yap\xc4\xb1lan bu giri\xc5\x9fimler aksine ilk turda Erdo\xc4\x9fan etraf\xc4\xb1nda kenetlenmeye bile yol a\xe7abilir.',
   u'sentence_number': 22,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792600',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u"Erdo\xc4\x9fan ve G\xfcl, AK Parti'nin \xe7at\xc4\xb1 aday\xc4\xb1 asl\xc4\xb1nda.",
   u'sentence_number': 23,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792601',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Peki CHP, MHP ve BDP\u2019nin kendi \xe7at\xc4\xb1 aday\xc4\xb1 kim?',
   u'sentence_number': 24,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792602',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Muhalefet partilerinin esas sormas\xc4\xb1 gereken soru bu...',
   u'sentence_number': 25,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792603',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': None,
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'vancetti',
   u'sentence_number': 26,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792604',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Say\xc4\xb1n Can baz\xc4\xb1lar\xc4\xb1 i\xc3\xa7in varolu\xc5\x9f nedeni AKP kar\xc5\x9f\xc4\xb1tl\xc4\xb1\xc4\x9f\xc4\xb1 diyor.',
   u'sentence_number': 27,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792605',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Oysa beni y\xc3\xb6netecek siyasal hareket hakk\xc4\xb1nda h\xc4\xb1rs\xc4\xb1zl\xc4\xb1k ve ars\xc4\xb1zl\xc4\xb1k iddialar\xc4\xb1 yoksa, \xc3\x9clkemin siyasal sistemi ile oynam\xc4\xb1yorsa, beni Arapla\xc5\x9ft\xc4\xb1rmak \xc3\xa7abas\xc4\xb1 i\xc3\xa7inde de\xc4\x9filse, onlar ve biz demiyorsa, d\xc4\xb1\xc5\x9f politikay\xc4\xb1 y\xc3\xbcz\xc3\xbcne g\xc3\xb6z\xc3\xbcne bula\xc5\x9ft\xc4\xb1rmam\xc4\xb1\xc5\x9fsa, d\xc3\xbcnya ile entegrasyona \xc3\xb6nem veriyorsa ad\xc4\xb1 AKP olur, CHP yahut MHP, HDP olur ba\xc5\x9f\xc4\xb1m g\xc3\xb6z\xc3\xbcm \xc3\xbcst\xc3\xbcnde yeri var.',
   u'sentence_number': 28,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792606',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'tr',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'Benim varolu\xc5\x9f nedenim mutlu ya\xc5\x9famd\xc4\xb1r ve mutlulu\xc4\x9fu toplumun di\xc4\x9fer katmanlar\xc4\xb1 ile payla\xc5\x9fmakt\xc4\xb1r.',
   u'sentence_number': 29,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792607',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': None,
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u'0 3',
   u'sentence_number': 30,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792608',
   u'tags': []},
  {u'db_row_last_updated': u'2014-07-12 18:00:46.49647-04',
   u'language': u'en',
   u'media_id': 38924,
   u'publish_date': u'2014-05-10 00:00:00',
   u'sentence': u"H\xc3\xbclya Ko\xc3\xa7yi\xc4\x9fit \xc3\xb6d\xc3\xbcl\xc3\xbcn\xc3\xbc Engin Altan D\xc3\xbczyatan'dan ald\xc4\xb1",
   u'sentence_number': 31,
   u'stories_id': u'243384113',
   u'story_sentences_id': u'2944792609',
   u'tags': []}],
 u'story_tags': [],
 u'story_text': u" Ne yalan s\xf6yleyeyim ben hi\xe7 heyecanlanmad\xc4\xb1m.   \xc7\xfcnk\xfc k\xe2\xc4\x9f\xc4\xb1t \xfcst\xfcnde iyi duran bu \xf6nerinin ger\xe7ek hayatta Tayyip Erdo\xc4\x9fan kar\xc5\x9f\xc4\xb1tl\xc4\xb1\xc4\x9f\xc4\xb1 ortak paydas\xc4\xb1 d\xc4\xb1\xc5\x9f\xc4\xb1nda hi\xe7bir kar\xc5\x9f\xc4\xb1l\xc4\xb1\xc4\x9f\xc4\xb1 yok!   Biliyorum baz\xc4\xb1lar\xc4\xb1 i\xe7in AK Parti ya da Erdo\xc4\x9fan kar\xc5\x9f\xc4\xb1tl\xc4\xb1\xc4\x9f\xc4\xb1 tek ba\xc5\x9f\xc4\xb1na bir varolu\xc5\x9f nedeni.   Ama onlar i\xe7in bile \xe7at\xc4\xb1 aday form\xfcl\xfcn\xfcn \xe7al\xc4\xb1\xc5\x9faca\xc4\x9f\xc4\xb1 \xc5\x9f\xfcpheli.   Bir kere Bah\xe7eli\u2019nin milliyet\xe7i muhafazak\xe2r ve maneviyat\xe7\xc4\xb1 aday profiline uygun birini bulmak ve bunu CHP se\xe7menine de kabul ettirmek o kadar kolay de\xc4\x9fil.   Diyelim Meral Ak\xc5\x9fener ya da Murat Ba\xc5\x9feskio\xc4\x9flu gibi bir aday \xf6nerdi MHP, CHP y\xf6netimi evet dese bile siyasi kimli\xc4\x9fi \xe7ok belirgin olan bu isimlerin t\xfcm CHP'den oy alabilece\xc4\x9fi \xc5\x9f\xfcpheli.   Siyasi kimli\xc4\x9fi belirgin aday \xe7at\xc4\xb1 form\xfcl\xfcn\xfcn en zay\xc4\xb1f halkas\xc4\xb1.   Ayn\xc4\xb1 durum CHP'nin \xf6nerece\xc4\x9fi siyasi kimli\xc4\x9fi olan kucaklay\xc4\xb1c\xc4\xb1 adaylar i\xe7in de s\xf6z konusu. Hikmet \xc7etin, Altan \xd6ymen gibi aktif siyaset i\xe7inde olmayanlar i\xe7in bile.   Gelelim siyasi kimli\xc4\x9fi \xf6ne \xe7\xc4\xb1kmayan Ha\xc5\x9fim K\xc4\xb1l\xc4\xb1\xe7, Ekmeleddin \xc4\xb0hsano\xc4\x9flu gibi adaylara. E\xc4\x9fer cumhurba\xc5\x9fkanl\xc4\xb1\xc4\x9f\xc4\xb1 se\xe7imi eskisi gibi Meclis'te olsa bu tarz adaylar\xc4\xb1n \xc5\x9fans\xc4\xb1 olabilirdi ama ge\xe7mi\xc5\x9f olsun sistem de\xc4\x9fi\xc5\x9fti. Her ne kadar cumhurba\xc5\x9fkanl\xc4\xb1\xc4\x9f\xc4\xb1 tarafs\xc4\xb1z ve devleti temsil eden sembolik bir makam olarak tarif edilmi\xc5\x9f olsa da adaylar basbaya\xc4\x9f\xc4\xb1 siyasi kampanya y\xfcr\xfctmek zorunda. Aktif siyaset yapmam\xc4\xb1\xc5\x9f isimler kendi alanlar\xc4\xb1nda t\xfcm sayg\xc4\xb1nl\xc4\xb1klar\xc4\xb1na ra\xc4\x9fmen siyaset sahnesinde acemi olmaktan kurtulamazlar, bu birinci handikap. Siyaset d\xc4\xb1\xc5\x9f\xc4\xb1 adaylar i\xe7in hi\xe7bir partinin te\xc5\x9fkilat\xc4\xb1 canla ba\xc5\x9fla \xe7al\xc4\xb1\xc5\x9fmaz bu da ikinci sorun.   CHP ile MHP'nin hatta BDP\u2019nin gayri resmi bir temas i\xe7inde olduklar\xc4\xb1 Ankara'da herkesin bildi\xc4\x9fi bir s\xc4\xb1r. Bu temaslarda \xc5\x9fimdiye kadar \xf6ne \xe7\xc4\xb1kan isimler az \xf6nce zikrettiklerim. Ve hen\xfcz isim konusunda da profil konusunda da bir uzla\xc5\x9fma yok. Bence olmas\xc4\xb1 da zor.   \xc7ok zorlan\xc4\xb1rsa belki bir aday \xfczerinde anla\xc5\x9fabilirler ama hem zorlama oldu\xc4\x9fu i\xe7in hem de yukarda sayd\xc4\xb1\xc4\x9f\xc4\xb1m gerek\xe7elerle Erdo\xc4\x9fan kar\xc5\x9f\xc4\xb1s\xc4\xb1nda bu adaylar\xc4\xb1n maalesef \xc5\x9fans\xc4\xb1 yok.   Benim \xc5\x9fahsi kanaatim zorlama ve k\xe2\xc4\x9f\xc4\xb1t \xfczeri form\xfcller yerine her partinin ilk turda \xe7at\xc4\xb1 aday\xc4\xb1 \xe7\xc4\xb1kar\xc4\xb1yor gibi en kucaklay\xc4\xb1c\xc4\xb1 adayla \xe7\xc4\xb1kmas\xc4\xb1. Sonu\xe7ta se\xe7im iki turlu, kimin aday\xc4\xb1 ilk ikiye kal\xc4\xb1rsa o ikinci turda do\xc4\x9fal \xe7at\xc4\xb1 aday\xc4\xb1 olur. Bunun d\xc4\xb1\xc5\x9f\xc4\xb1ndaki form\xfcller k\xe2\xc4\x9f\xc4\xb1t \xfczerinde kal\xc4\xb1r.   \xc7at\xc4\xb1 form\xfcl\xfc ikinci turda \xe7al\xc4\xb1\xc5\x9f\xc4\xb1r ama birinci turda \xe7ok zor!   Erdo\xc4\x9fan ilk turda kazanmas\xc4\xb1n diye yap\xc4\xb1lan bu giri\xc5\x9fimler aksine ilk turda Erdo\xc4\x9fan etraf\xc4\xb1nda kenetlenmeye bile yol a\xe7abilir. Erdo\xc4\x9fan ve G\xfcl, AK Parti'nin \xe7at\xc4\xb1 aday\xc4\xb1 asl\xc4\xb1nda. Peki CHP, MHP ve BDP\u2019nin kendi \xe7at\xc4\xb1 aday\xc4\xb1 kim? Muhalefet partilerinin esas sormas\xc4\xb1 gereken soru bu...  \n\n 14 ya\xc5\x9f\xc4\xb1nda k\xc4\xb1z\xc4\xb1n\xc4\xb1z da\xc4\x9fa \xc3\xa7\xc4\xb1ksa ne yapars\xc4\xb1n\xc4\xb1z?\n\n                    vancetti  \n\n\n\n Say\xc4\xb1n Can baz\xc4\xb1lar\xc4\xb1 i\xc3\xa7in varolu\xc5\x9f nedeni AKP kar\xc5\x9f\xc4\xb1tl\xc4\xb1\xc4\x9f\xc4\xb1 diyor. Oysa beni y\xc3\xb6netecek siyasal hareket hakk\xc4\xb1nda h\xc4\xb1rs\xc4\xb1zl\xc4\xb1k ve ars\xc4\xb1zl\xc4\xb1k iddialar\xc4\xb1 yoksa, \xc3\x9clkemin siyasal sistemi ile oynam\xc4\xb1yorsa, beni Arapla\xc5\x9ft\xc4\xb1rmak \xc3\xa7abas\xc4\xb1 i\xc3\xa7inde de\xc4\x9filse, onlar ve biz demiyorsa, d\xc4\xb1\xc5\x9f politikay\xc4\xb1 y\xc3\xbcz\xc3\xbcne g\xc3\xb6z\xc3\xbcne bula\xc5\x9ft\xc4\xb1rmam\xc4\xb1\xc5\x9fsa, d\xc3\xbcnya ile entegrasyona \xc3\xb6nem veriyorsa ad\xc4\xb1 AKP olur, CHP yahut MHP, HDP olur ba\xc5\x9f\xc4\xb1m g\xc3\xb6z\xc3\xbcm \xc3\xbcst\xc3\xbcnde yeri var. Benim varolu\xc5\x9f nedenim mutlu ya\xc5\x9famd\xc4\xb1r ve mutlulu\xc4\x9fu toplumun di\xc4\x9fer katmanlar\xc4\xb1 ile payla\xc5\x9fmakt\xc4\xb1r. \n\n\n\n \n\n   \n\n\n\n  \n\n 0  3  \n\n \n\n \n\n \n\n \n\n\n\n H\xc3\xbclya Ko\xc3\xa7yi\xc4\x9fit \xc3\xb6d\xc3\xbcl\xc3\xbcn\xc3\xbc Engin Altan D\xc3\xbczyatan'dan ald\xc4\xb1 \n\n",
 u'title': u'\xc7at\u0131 m\u0131 dediniz!',
 u'url': u'http://www.radikal.com.tr/yazarlar/eyup_can/cati_mi_dediniz-1191333'}