As a trial, the FSA is making the Open Data Files available in JSON format.
To download files in JSON format, simply replace the .xml file extension in Urls with .json. For example, for the Babergh Local Authority:
https://ratings.food.gov.uk/OpenDataFiles/FHRS297en-GB.xml
...becomes...
https://ratings.food.gov.uk/OpenDataFiles/FHRS297en-GB.json
The data types of the fields in the JSON are as below, please note that some fields may show null when there is no data and others will not be present.
Field name |
Data type |
FHRSID |
Integer |
LocalAuthorityBusinessID |
String |
BusinessName |
String |
BusinessType |
String |
BusinessTypeID |
Integer |
AddressLine1 |
String |
AddressLine2 |
String |
AddressLine3 |
String |
AddressLine4 |
String |
PostCode |
String |
RatingValue |
String |
RatingKey |
String |
RatingDate |
String (yyyy-MM-dd) |
RightToReply |
String |
LocalAuthorityCode |
String |
LocalAuthorityName |
String |
LocalAuthorityEmailAddress |
String |
LocalAuthorityWebSite |
String |
Scores - Hygiene |
Integer |
Scores - Structural |
Integer |
Scores - ConfidenceInManagement |
Integer |
SchemeType |
String |
NewRatingPending |
Boolean |
Geocode - Longitude |
String |
Geocode - Latitude |
String |