DC crime data source gallery

{
    "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"
}