Sample document
TODO
Source
{ "authentication": { "password": "PASSWORD", "username": "USERNAME" }, "database": { "databaseName": "washingtondc", "databaseType": "mysql", "deleteQuery": "", "deltaQuery": "SELECT * FROM IncidentReport WHERE REPORTDATETIME >= (SELECT ADDDATE(CURDATE(),-7))", "hostname": "ec2-184-72-206-97.compute-1.amazonaws.com", "port": "3306", "primaryKey": "NID", "publishedDate": "REPORTDATETIME", "query": "SELECT * FROM IncidentReport", "snippet": "OFFENSE", "title": "CCN" }, "description": "Incident reports from the Washington, D.C. MPD", "extractType": "Database", "harvest": { "doccount": 9314, "harvest_message": "Error when harvesting DB: Cannot establish connection to the database : jdbc:mysql://ec2-184-72-206-97.compute-1.amazonaws.com:3306/washingtondc", "harvest_status": "error", "harvested": "Nov 2, 2012 11:26:25 AM", "synced": "Nov 2, 2012 11:24:30 AM" }, "isApproved": true, "isPublic": true, "mediaType": "Record", "structuredAnalysis": { "associations": [{ "entity1": "$metadata.offense,$metadata.method", "geotag": {}, "time_start": "$metadata.reportdatetime", "verb": "reported", "verb_category": "crime" }], "description": "$metadata.reportdatetime: $metadata.offense,$metadata.method was reported at: $metadata.blocksiteaddress", "docGeo": { "lat": "$metadata.latitude", "lon": "$metadata.longitude" }, "entities": [ { "dimension": "What", "disambiguated_name": "$metadata.offense,$metadata.method", "type": "CriminalActivity" }, { "dimension": "Where", "disambiguated_name": "$metadata.blocksiteaddress,$metadata.city,$metadata.state", "geotag": {}, "type": "Place" }, { "dimension": "Where", "disambiguated_name": "$metadata.ward,$metadata.city,$metadata.state", "type": "Place" }, { "dimension": "Where", "disambiguated_name": "$metadata.district,$metadata.city,$metadata.state", "type": "Place" } ] }, "tags": [ "crime report", "MPD", "Washington, D.C." ], "title": "data.dc.gov - Crime Incidents (ASP)", "url": "jdbc:mysql://ec2-184-72-206-97.compute-1.amazonaws.com/washingtondc/IncidentReport", "useExtractor": "none" }
Sample output
TODO