Sample data for JSON databases


For sample data for the json databases


Movies data


{ "create": { "_index": "movies", "_type": "movie", "_id": "tt0468569" }}
{"title":"The Dark Knight","year":2008,"rated":["PG-13"],"released":"2008-07-18","runtimeMinutes":152,"genres":["Action","Crime","Drama"],"directors":["Christopher Nolan"],"writers":["Jonathan Nolan","Christopher Nolan","David S. Goyer","Bob Kane"],"actors":["Christian Bale","Heath Ledger","Aaron Eckhart","Michael Caine"],"plot":"When Batman, Gordon and Harvey Dent launch an assault on the mob, they let the clown out of the box, the Joker, bent on turning Gotham on itself and bringing any heroes down to his level.","languages":["English","Mandarin"],"countries":["USA","UK"],"awards":"Won 2 Oscars. Another 94 wins & 69 nominations.","poster":"https://s3-eu-west-1.amazonaws.com/imdbimages/images/MV5BMTMxNTMwODM0NF5BMl5BanBnXkFtZTcwODAyMTk2Mw@@._V1_SX300.jpg","metaScore":82,"imdbRating":9,"imdbVotes":1133701,"imdbId":"tt0468569","type":"Movie","suggest":{"input":["The","Dark","Knight"],"output":"The Dark Knight","payload":{"id":"tt0468569"}},"genres_raw":["Action","Crime","Drama"],"directors_raw":["Christopher Nolan"],"writers_raw":["Jonathan Nolan","Christopher Nolan","David S. Goyer","Bob Kane"],"actors_raw":["Christian Bale","Heath Ledger","Aaron Eckhart","Michael Caine"],"countries_raw":["USA","UK"]}

 https://drive.google.com/open?id=0B57oIg74K5ykUlRXY0ZGMDItTWc


Alameda Crime data


{ "index" : { "_index" : "alameda", "_type" : "crime"} }
{"zip":"94541","crimedescription":"VANDALISM ($400 OR MORE)","agencyid":"ACSO","location":{"lon":-122.11298,"lat":37.677055},"state":"CA","crimeid":"12000048","block":"18900 TIMES AV","datetime":"2012-01-01T00:01:00","crimecode":"290","city":"SAN LORENZO"}


https://drive.google.com/open?id=0B57oIg74K5ykVHExMTFlUlJMMzQ



https://drive.google.com/open?id=0B57oIg74K5ykcFhPNHNJNTdZRnM






https://drive.google.com/open?id=0B57oIg74K5ykaHJLOTl2aXF2UUU











Accounts Json






{"index":{"_id":"1"}}
{"account_number":1,"balance":39225,"firstname":"Amber","lastname":"Duke","age":32,"gender":"M","address":"880 Holmes Lane","employer":"Pyrami","email":"amberduke@pyrami.com","city":"Brogan","state":"IL"}
{"index":{"_id":"6"}}
{"account_number":6,"balance":5686,"firstname":"Hattie","lastname":"Bond","age":36,"gender":"M","address":"671 Bristol Street","employer":"Netagy","email":"hattiebond@netagy.com","city":"Dante","state":"TN"}
{"index":{"_id":"13"}}








https://drive.google.com/open?id=0B57oIg74K5ykcWxjdmxPbE1YYkk




































Comments











Post a Comment



















Popular posts from this blog









Proxy setting in java





















  3 properties can set in http,https and ftp proxy handler   Http proxy in java   1. http.proxyHost: the host name of the proxy server  2. http.proxyPort: the port number, the default value being 80.  3. http.nonProxyHosts:a list of hosts that should be reached directly, bypassing the proxy.   Add http proxy when run main class   1. $ java -Dhttp.proxyHost=webcache.example.com GetURL  2. $ java -Dhttp.proxyHost=webcache.example.com -Dhttp.proxyPort=8080 -Dhttp.nonProxyHosts=”localhost|host.example.com” GetURL   Add https proxy when run main class  1. $ java -Dhttps.proxyHost=webcache.example.com GetURL  2. $ java -Dhttps.proxyHost=webcache.example.com -Dhttps.proxyPort=8080 -Dhttp.nonProxyHosts=”localhost|host.example.com” GetURL   Add http proxy in java code   //Set the http proxy to webcache.example.com:808 0   System.setProperty("http.proxyHost", "webcache.example.com");  System.setProperty("http.proxyPort", "8080");  System.setProperty("...








Read more










Using logstash to import csv json files into elasticsearch





















  Using logstash to import csv files into elasticsearch    test.csv file contains these data's  01/01/2012 12:01:00 AM,18900 TIMES AV,SAN LORENZO,CA,94541,290,VANDALISM ($400 OR MORE),ACSO,12000048,"(37.67705445, -122.11298064)"  01/01/2012 12:01:00 AM,21000 SHERMAN DR,CASTRO VALLEY,CA,94552,250,FORGERY,ACSO,13006643,"(37.71437982, -122.02231781)"  01/01/2012 12:03:00 AM,A ST / MISSION BL,HAYWARD,CA,94541,999,REPORT NUMBER WAS CANCELLED,ACSO,11021284,"(37.66655037, -122.10000611)"  01/01/2012 12:03:00 AM,A ST / MISSION BL,HAYWARD,CA,94541,999,REPORT NUMBER WAS CANCELLED,ACSO,12000010,"(37.66655037, -122.10000611)"  01/01/2012 12:03:00 AM,A ST / MISSION BL,HAYWARD,CA,94541,90D,DUI ALCOHOL/DRUGS,ACSO,11021283,"(37.66655037, -122.10000611)"   Logstash conf file   input{   file {     path => "/home/ubuntu/test.csv"     start_position => beginning   }  }   filter {      csv {      separator => ","     ...








Read more










Kibana 4 Installation and Run as a service in ubuntu





















      Download and install kibana4   To download kibana 4   wget https://download.elasticsearch.org/kibana/kibana/kibana-4.0.1-linux-x64.tar.gz     Extract and Rename kibana   tar -xvzf kibana-4.0.1-linux-x64.tar.gz   sudo mv  kibana-4.0.1-linux-x64  kibna-4     To run kibana   *Run bin/kibana on unix, or bin\kibana.bat on Windows.    *Visit http://localhost:5601   To set kibana 4 as a service       1. Create  a file in /etc/init.d/kibana   2. Add kibana.txt  contents into  file   3 .          Give permissions to       sudo chmod 755 /etc/init.d/kibana   4. Update kibna in update-rc.d       sudo update-rc.d kibana   5. To start kibana as a service      sudo service kibana start               6. Disable autostart for a tomcat service         update-rc.d kibana disable      Kibana.txt    #!/bin/sh  #Change kibana path as per your config  KIBANA_EXEC="/opt/kibana/bin/kibana"  LOG_FILE="/var/log/kibana/log"  PID_FILE="/var/run...








Read more