Query Multiple Serialised Data Objects

We have to change the way we retrieve our data - currently it comes from a SQL server, but there is now a 'golden source' available where the data is broken down into relevant objects, i.e. Country, Worker, Worker Account and Active Directory. This is a sample of the JSON for Country:

{
"@odata.context": "https://this.company.url/WebAPI/v2/$metadata#Country",
"value": [
    {
        "CountryId": 100002,
        "CountryAlpha2Code": "AD",
        "CountryAlpha3Code": "AND",
        "CountryNumericCode": "020",
        "CountryName": "Andorra",
        "CountryStartDate": null,
        "CountryEndDate": null,
        "RetiredCountryCode": null,
        "CountryShortName": "Andorra",
        "IsDeleted": false,
        "LastUpdateTime": "2017-08-05T09:58:53.44Z",
        "LastUpdateBy": "USERID",
        "ETLUpdatedDate": "2018-08-18T04:58:31Z"
    },
    {
        "CountryId": 100003,
        "CountryAlpha2Code": "AE",
        "CountryAlpha3Code": "ARE",
        "CountryNumericCode": "784",
        "CountryName": "United Arab Emirates (the)",
        "CountryStartDate": null,
        "CountryEndDate": null,
        "RetiredCountryCode": null,
        "CountryShortName": "United Arab Emirates",
        "IsDeleted": false,
        "LastUpdateTime": "2017-08-05T09:58:53.44Z",
        "LastUpdateBy": "USERID",
        "ETLUpdatedDate": "2018-08-18T04:58:31Z"
    },
    {...

If I then copy the JSON as classes, I get

public class Rootobject
{
    public string odatacontext { get; set; }
    public Value[] value { get; set; }
}

public class Value
{
    public int CountryId { get; set; }
    public string CountryAlpha2Code { get; set; }
    public string CountryAlpha3Code { get; set; }
    public string CountryNumericCode { get; set; }
...
    public string LastUpdateBy { get; set; }
    public DateTime ETLUpdatedDate { get; set; }
}

I've found an example but having five different objects, which all have the same rootobject and value classes, am struggling to implement this. I have no control over the structure of the JSON metadata as I'm not the only person using it, so I'm trying to figure out how I can read each class, keeping them distinct.
FYI this is the query I'm wanting to replicate (though one of the classes isn't available yet - FinancialGeographyAddress, but there is enough work to keep me busy whilst that is being made available).

SELECT 
UPPER(AD.[AccountName])
,TRIM('.' FROM AD.[LastName]) AS [LastName]
,TRIM('.' FROM AD.[GivenName]) AS [GivenName]
,TRIM('.' FROM AD.[Initials]) AS [Initials]
,LOWER(AD.[EmailAddress])
,C.[CountryAlpha2Code]
,AD.[DisplayName]
,AD.[Enabled]
,CASE
    -- Swap display name to be 'lastname, firstname' when 'firstname lastname'
    WHEN AD.[DisplayName] IS NULL OR AD.[GivenName] = LEFT(AD.[DisplayName], LEN(AD.[GivenName])) THEN
        [LastName] + ', ' + [GivenName]
    -- Remove the bracketed suffix and/or any trailing periods
    WHEN CHARINDEX('(', AD.[DisplayName]) > 0 THEN
        TRIM('.' FROM LEFT(AD.[DisplayName], CHARINDEX('(', AD.[DisplayName]) - 2))
    ELSE
        TRIM('.' FROM AD.[DisplayName])
    END  
FROM [wrk].[vwWorker] AS W
INNER JOIN [rpt].[vwFinancialGeographyAddress] AS FGA 
    ON W.[FinancialGeographyId] = FGA.[FinancialGeographyId] AND FGA.[IsDeleted] = 0
INNER JOIN [rpt].[vwCountry] AS C ON C.[CountryId] = FGA.[CountryId] AND C.[IsDeleted] = 0
INNER JOIN [wrk].[vwWorkerAccount] AS WA ON WA.[WorkerId] = W.[WorkerId] AND WA.[IsDeleted] = 0
INNER JOIN [rpt].[vwActiveDirectory] AS AD ON AD.[ActiveDirectoryId] = WA.[ActiveDirectoryID] 
                                                AND AD.[IsDeleted] = 0 AND AD.[Enabled] = 'True' 
WHERE 
-- Only interested in UK, Guernsey and Ireland
C.[CountryAlpha2Code] IN ('GB', 'GG', 'IE')