Inquiry
When I download this dataset via export-csv button (...sv7x-dduq/rows.csv?accessType=DOWNLOAD)
there is a problem with a line of the file for document_id=2016050400438019 where some json data is getting injected into the file somehow. The record looks correct on the portal, but the error is present in api queries as well (https://data.cityofnewyork.us/resource/sv7x-dduq.json?$query=select%20*%20where%20document_id=%272016050400438019%27).
This is what the line looks line in the downlaoded csv. I contacted Socrata and also looked back at the portal, and confirmed that this is a problem that occurred during the upload of the data rather than the processing, and so Socrata said that I should ask you about it again. On the portal if you filter for the record by document_id and expand the "CRFM" column you'll see that the same extra text is there. All they could say is that this extra information must have been included as a text string durring the upload, but didn't have any other advice on how to resolve it. Hopefully you all will be able to re-upload it and fix the issue. In case it's helpful, I downloaded the file only about a week ago and didn't have this problem then and this record is not a new one, so maybe just re-trying it will work?
2016050400438019,A,"2016000165599""object_class_type""}},rdfSubject"":""0,filterCondition"":{""value"":""AND,children"":[{""value"":""OR,type"":""operator,metadata"":{""includeAuto"":7,tableColumnId"":{""1880873"":22868931},operator"":""EQUALS""}},{""value"":""OR,type"":""operator,metadata"":{""tableColumnId"":{""1880873"":22868933},operator"":""CONTAINS""}},{""value"":""OR,type"":""operator,metadata"":{""tableColumnId"":{""1880873"":22868935},operator"":""CONTAINS""}},{""value"":""OR,type"":""operator,metadata"":{""includeAuto"":7,tableColumnId"":{""1880873"":22868947},operator"":""EQUALS""}},{""value"":""OR,type"":""operator,metadata"":{""includeAuto"":5,tableColumnId"":{""1880873"":22868953},operator"":""EQUALS""}}],type"":""operator,metadata"":{""unifiedVersion"":2,advanced"":true}}},privateMetadata"":{""custom_fields"":{""Dataset Creation Steps"":{""Data Export Steps"":"",Confidential Data Redaction Steps"":"",Quality Assurance Process"":""}},contactEmail"":""},query"":{""orderBys"":[{""expression"":{""columnId"":250625423,type"":""column""},ascending"":true}],filterCondition"":{""metadata"":{""unifiedVersion"":2},type"":""operator,value"":""EQUALS,children"":[{""type"":""column,columnFieldName"":""object_class_type""},{""type"":""literal,value"":""Receipts""}]}},tags"":[""financial,budget,resources,appropriations,receipts""],flags"":[""default""],originalViewId"":""ai8x-sahe,displayFormat"":{}}",1,FL,776306.76,05/13/2016,,210644516,12/14/2015,0,05/13/2016,0,0,0,,05/31/2016