import requests
import pandas as pd
pd.set_option('display.max_columns', 30)
url = 'http://api.crisis.net/item/?placeName=syria'
headers = {'Authorization': 'Bearer ' + '532d8dc4ed3329652f114b73'}
r = requests.get(url, headers=headers)
df = pd.DataFrame(r.json())
df = df['data'].apply(pd.Series)
print(len(df))
25
df.head(25)
author | content | createdAt | geo | id | image | language | license | lifespan | publishedAt | remoteID | source | updatedAt | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | {'username': 'dovenews', 'remoteID': '25451033... | @dovenews تصحيح عصر يوم الجمعة. Correction: Fr... | 2014-05-31T15:39:43.226137 | {'locationIdentifiers': {'authorTimeZone': 'Am... | 1WCjSHZ-RK6TecxwBM41_A | NaN | {'code': 'ar'} | unknown | temporary | 2014-05-31T15:38:26+00:00 | 472764043577819136 | 2014-05-31T15:39:43.226146 | |
1 | {'username': 'dovenews', 'remoteID': '25451033... | @dovenews Today was the burial of the Libyan j... | 2014-05-31T15:39:43.273016 | {'locationIdentifiers': {'authorTimeZone': 'Am... | yHobP7sgRGqAXZyUbNPOqg | NaN | {'code': 'en'} | unknown | temporary | 2014-05-31T15:09:40+00:00 | 472756806390132736 | 2014-05-31T15:39:43.273025 | |
2 | {'username': 'dovenews', 'remoteID': '25451033... | @dovenews \nتم عصر اليوم دفن الاعلامية نصيب كر... | 2014-05-31T15:39:43.320717 | {'locationIdentifiers': {'authorTimeZone': 'Am... | ZREgmVQfTca1t8WcAtS0iA | http://pbs.twimg.com/media/Bo-Rj4dIQAAjvSd.jpg | {'code': 'ar'} | unknown | temporary | 2014-05-31T15:08:35+00:00 | 472756533278040064 | 2014-05-31T15:39:43.320727 | |
3 | {'username': 'dovenews', 'remoteID': '25451033... | @dovenews بتفجير سيارته بواسطة عبوة ناسفة علي ... | 2014-05-31T15:39:43.368698 | {'locationIdentifiers': {'authorTimeZone': 'Am... | 5zOfg-cgTwWKeGg2PJPDZg | NaN | {'code': 'ar'} | unknown | temporary | 2014-05-31T15:01:52+00:00 | 472754842809954304 | 2014-05-31T15:39:43.368707 | |
4 | {'username': 'dovenews', 'remoteID': '25451033... | توتر بين المجموعات المسلحة المسيطرة علي مدينة ... | 2014-05-31T15:39:43.414710 | {'locationIdentifiers': {'authorTimeZone': 'Am... | CYOBNgt6Tt2zYlrumIJYwA | http://pbs.twimg.com/media/Bo-P6rTCcAEwWxU.jpg | {'code': 'ar'} | unknown | temporary | 2014-05-31T15:01:25+00:00 | 472754727948939266 | 2014-05-31T15:39:43.414720 | |
5 | {'username': 'dovenews', 'remoteID': '25451033... | عبدالله القماطي عضو المؤتمر الوطني:ماحدث هو ان... | 2014-05-31T15:39:43.468762 | {'locationIdentifiers': {'authorTimeZone': 'Am... | 6D-YvWa8RreeCRDCt5fnfA | NaN | {'code': 'ar'} | unknown | temporary | 2014-05-31T14:58:57+00:00 | 472754109763026944 | 2014-05-31T15:39:43.468770 | |
6 | {'username': 'dovenews', 'remoteID': '25451033... | عبدالله القماطي عضو المؤتمر الوطني: انا تجاوزت... | 2014-05-31T14:39:40.093467 | {'locationIdentifiers': {'authorTimeZone': 'Am... | Y0rCjNUTTKS-8s9TR6yvZw | NaN | {'code': 'ar'} | unknown | temporary | 2014-05-31T14:29:14+00:00 | 472746629175738369 | 2014-05-31T14:39:40.093477 | |
7 | {'username': 'dovenews', 'remoteID': '25451033... | عبدالله القماطي عضو المؤتمر: المؤتمر مستولي عل... | 2014-05-31T14:39:40.139808 | {'locationIdentifiers': {'authorTimeZone': 'Am... | GigoX4WNRRijPaIDFyAQew | NaN | {'code': 'ar'} | unknown | temporary | 2014-05-31T14:22:06+00:00 | 472744835116728321 | 2014-05-31T14:39:40.139817 | |
8 | {'username': 'dovenews', 'remoteID': '25451033... | Philippine labor officials on Friday announced... | 2014-05-31T14:39:40.186957 | {'locationIdentifiers': {'authorTimeZone': 'Am... | kMCX2aywTyi6T7MAOclPEw | NaN | {'code': 'en'} | unknown | temporary | 2014-05-31T14:12:33+00:00 | 472742431495315456 | 2014-05-31T14:39:40.186965 | |
9 | {'username': 'dovenews', 'remoteID': '25451033... | https://t.co/WK493xMUQr @dovenews فيديو. video | 2014-05-31T14:39:40.237805 | {'locationIdentifiers': {'authorTimeZone': 'Am... | dVE6URYHTjGi4Ot07o_Wjg | NaN | {'code': 'ar'} | unknown | temporary | 2014-05-31T14:04:51+00:00 | 472740493923999744 | 2014-05-31T14:39:40.237814 | |
10 | {'username': 'dovenews', 'remoteID': '25451033... | @dovenews Video,فيديو https://t.co/u9h1WysrOY | 2014-05-31T14:39:40.283439 | {'locationIdentifiers': {'authorTimeZone': 'Am... | _g_9Ta47RZ2BUbczghHJyQ | NaN | {'code': 'ar'} | unknown | temporary | 2014-05-31T14:02:47+00:00 | 472739972559405056 | 2014-05-31T14:39:40.283448 | |
11 | {'username': 'MaryFitzger', 'remoteID': '10952... | Dangerous days for journalists in Libya. The k... | 2014-05-31T14:39:40.330053 | {'locationIdentifiers': {'authorTimeZone': 'Ca... | JmWR2-_8RRGjOTsMgupZ0g | NaN | {'code': 'en'} | unknown | temporary | 2014-05-31T13:59:13+00:00 | 472739075602931712 | 2014-05-31T14:39:40.330062 | |
12 | {'username': 'dovenews', 'remoteID': '25451033... | عربي و بسلاح روسي وزي افغاني و سيارة كورية بال... | 2014-05-31T14:39:40.375616 | {'locationIdentifiers': {'authorTimeZone': 'Am... | gNpX7SU6QO6qVi1yl1iGUw | http://pbs.twimg.com/media/Bo-AWslCIAAzH1X.jpg | {'code': 'ar'} | unknown | temporary | 2014-05-31T13:53:25+00:00 | 472737614957912064 | 2014-05-31T14:39:40.375626 | |
13 | {'username': 'GihanTadreft', 'remoteID': '2943... | “@youm7: #اليوم_السابع | قيادى بتنظيم #القاعدة... | 2014-05-31T13:39:37.548246 | {'locationIdentifiers': {'authorTimeZone': 'Lo... | jgCZF1EcSxGu9UmCDMvMVA | http://pbs.twimg.com/media/Bo9yUPzIUAE_YvX.jpg | {'code': 'ar'} | unknown | temporary | 2014-05-31T13:06:53+00:00 | 472725907455897600 | 2014-05-31T13:39:37.548258 | |
14 | {'username': 'dovenews', 'remoteID': '25451033... | بعيداً عن السياسة ولو لحين. #pt | 2014-05-31T12:39:34.179098 | {'locationIdentifiers': {'authorTimeZone': 'Am... | pgjAsd7CQ6mCtuMTFTddZA | NaN | {'code': 'ar'} | unknown | temporary | 2014-05-31T11:57:58+00:00 | 472708560556945410 | 2014-05-31T12:39:34.179114 | |
15 | {'username': 'dovenews', 'remoteID': '25451033... | وجدت 'دعسوقة' تتدعسق. البعض يسميها 'حويوا'، وا... | 2014-05-31T12:39:34.225268 | {'locationIdentifiers': {'authorTimeZone': 'Am... | GwGRVo3-R_asUlIFw5eNvQ | http://pbs.twimg.com/media/Bo9lPYnCcAEUeu3.jpg | {'code': 'ar'} | unknown | temporary | 2014-05-31T11:54:58+00:00 | 472707806718869504 | 2014-05-31T12:39:34.225278 | |
16 | {'username': 'dovenews', 'remoteID': '25451033... | Libyan national football team in important qua... | 2014-05-31T11:39:30.666346 | {'locationIdentifiers': {'authorTimeZone': 'Am... | viZPI03vRhqTzQIX9wnu_Q | NaN | {'code': 'en'} | unknown | temporary | 2014-05-31T11:33:04+00:00 | 472702296087076864 | 2014-05-31T11:39:30.666355 | |
17 | {'username': 'dovenews', 'remoteID': '25451033... | Russia supports the gov of PM AlThani. This wa... | 2014-05-31T11:39:30.713377 | {'locationIdentifiers': {'authorTimeZone': 'Am... | 4cHfmMxnTKKVQc4Xhb4XLw | http://pbs.twimg.com/media/Bo9feiJIEAA82vc.jpg | {'code': 'en'} | unknown | temporary | 2014-05-31T11:29:46+00:00 | 472701465681997824 | 2014-05-31T11:39:30.713387 | |
18 | {'username': 'dovenews', 'remoteID': '25451033... | No smoking day. http://t.co/yiuddWvh1U | 2014-05-31T11:39:30.760116 | {'locationIdentifiers': {'authorTimeZone': 'Am... | BUnpEfYxSmusYIX8pSQj0Q | http://pbs.twimg.com/media/Bo9cDPrIIAEO4Ft.jpg | {'code': 'en'} | unknown | temporary | 2014-05-31T11:14:48+00:00 | 472697698324594689 | 2014-05-31T11:39:30.760125 | |
19 | {'username': 'dovenews', 'remoteID': '25451033... | @dovenews كما اضاف: قد خلف الحريق أضرار كبيره.... | 2014-05-31T11:39:30.806938 | {'locationIdentifiers': {'authorTimeZone': 'Am... | XW0ACWqRRNmXsKOJM-ImPw | NaN | {'code': 'ar'} | unknown | temporary | 2014-05-31T11:10:35+00:00 | 472696638642081793 | 2014-05-31T11:39:30.806947 | |
20 | {'username': 'dovenews', 'remoteID': '25451033... | المستشار الإعلامي بوزارة المواصلات عادل المحجو... | 2014-05-31T11:39:30.853129 | {'locationIdentifiers': {'authorTimeZone': 'Am... | mynLb1IjQAyJf1EfalZdeQ | http://pbs.twimg.com/media/Bo9ZcyHIMAA8Tt3.jpg | {'code': 'ar'} | unknown | temporary | 2014-05-31T11:03:26+00:00 | 472694840065810432 | 2014-05-31T11:39:30.853139 | |
21 | {'username': 'dovenews', 'remoteID': '25451033... | @dovenews المزيد من الشباب المسلح من مناطق مخت... | 2014-05-31T11:39:30.899533 | {'locationIdentifiers': {'authorTimeZone': 'Am... | 2czOr1WbRaW1U3kC-5kxnA | NaN | {'code': 'ar'} | unknown | temporary | 2014-05-31T10:54:48+00:00 | 472692668343275520 | 2014-05-31T11:39:30.899541 | |
22 | {'username': 'A_Addarrat', 'remoteID': '227034... | RT @El_Asmar: @A_Addarrat let's wait and see. ... | 2014-05-31T11:39:30.948399 | {'locationIdentifiers': {'authorTimeZone': 'Qu... | kuwj06KZRE2dh0WVraU_MQ | NaN | {'code': 'en'} | unknown | temporary | 2014-05-31T10:51:35+00:00 | 472691855638159360 | 2014-05-31T11:39:30.948408 | |
23 | {'username': 'dovenews', 'remoteID': '25451033... | More armd groups from diffrnt prts of Benghazi... | 2014-05-31T11:39:30.996663 | {'locationIdentifiers': {'authorTimeZone': 'Am... | Usg-JYF2TgyQuFvwBmJoRQ | http://pbs.twimg.com/media/Bo9WqrJIQAAptSB.jpg | {'code': 'en'} | unknown | temporary | 2014-05-31T10:51:17+00:00 | 472691780472020992 | 2014-05-31T11:39:30.996673 | |
24 | {'username': 'A_Addarrat', 'remoteID': '227034... | Govt handover to Maitig proceeding (slowly) bu... | 2014-05-31T10:39:27.071166 | {'locationIdentifiers': {'authorTimeZone': 'Qu... | cLYMdfe_RPem--EbXXfTvw | NaN | {'code': 'en'} | unknown | temporary | 2014-05-31T10:19:45+00:00 | 472683843536031744 | 2014-05-31T10:39:27.071175 |
25 rows × 13 columns