login as: root
SSHDroid
Use 'root' as username
Default password is 'admin'
root@192.168.0.XX's password:
COLUMNS=153;LINES=33;export COLUMNS LINES;
root@mako:/data/data/berserker.android.apps.sshdroid/home # sqlite3  /data/data/com.android.providers.contacts/databases/contacts2.db
SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .headers on
sqlite> .schema Calls
CREATE TABLE calls (_id INTEGER PRIMARY KEY AUTOINCREMENT,number TEXT,presentation INTEGER NOT NULL DEFAULT 1,date INTEGER,duration INTEGER,type INTEGER,new INTEGER,name TEXT,numbertype INTEGER,numberlabel TEXT,countryiso TEXT,voicemail_uri TEXT,is_read INTEGER,geocoded_location TEXT,lookup_uri TEXT,matched_number TEXT,normalized_number TEXT,photo_id INTEGER NOT NULL DEFAULT 0,formatted_number TEXT,_data TEXT,has_content INTEGER,mime_type TEXT,source_data TEXT,source_package TEXT,state INTEGER,subscription INTEGER NOT NULL DEFAULT 0, duration_type INTEGER NOT NULL DEFAULT 0);
sqlite> select _id,number,date,datetime(date/1000, 'unixepoch', 'localtime') date_time, duration, countryiso from Calls  where date between 1454917599000 and 1455003999000;
_id|number|date|date_time|duration|countryiso
15232|+919962100640|1454939577624|2016-02-08 07:52:57|0|US
15233|+919952699352|1454939617811|2016-02-08 07:53:37|38|US
15234|+919952699352|1454940014819|2016-02-08 08:00:14|22|US
15235|2019127445|1454940167901|2016-02-08 08:02:47|0|US
15236|+919962187300|1454940843707|2016-02-08 08:14:03|193|US
15237|+919677284622|1454943928030|2016-02-08 09:05:28|0|US
15238|+919840395210|1454943986831|2016-02-08 09:06:26|467|US
15239|8775610984|1454946205017|2016-02-08 09:43:25|534|US
15240|17138773570|1454947593526|2016-02-08 10:06:33|46|US
15241|+919942188577|1454947341705|2016-02-08 10:02:21|290|US
15242|+919942188577|1454947774715|2016-02-08 10:09:34|0|US
15243|17138773570|1454947810664|2016-02-08 10:10:10|582|US
15244|7134862980|1454953518040|2016-02-08 11:45:18|518|US
15245|18003523407|1454978753976|2016-02-08 18:45:53|5|US
15246|+919962100640|1454981871982|2016-02-08 19:37:51|0|US
15247|+919962100640|1454982301609|2016-02-08 19:45:01|118|US
15248|+919952699352|1454982441150|2016-02-08 19:47:21|208|US
15249|+914461606161|1454993176994|2016-02-08 22:46:16|50|US
15250|+914461606161|1454993234188|2016-02-08 22:47:14|135|US
15251|+914461606161|1454993380279|2016-02-08 22:49:40|164|US
15252|+914424620875|1454993687210|2016-02-08 22:54:47|0|US
15253|+919380492750|1454994241918|2016-02-08 23:04:01|343|US
15254|+919380492750|1454994690637|2016-02-08 23:11:30|168|US
15255|+919677284622|1454995036524|2016-02-08 23:17:16|128|US
sqlite>