tests/testthat/soc_read/soda.demo.socrata.com/api/views/2asz-g9qq.R

In socratadata: Explore Socrata Data with Ease

structure(list(method = "GET", url = "https://soda.demo.socrata.com/api/views/2asz-g9qq", 
    status_code = 200L, headers = structure(list(Server = "nginx", 
        Date = "Tue, 22 Jul 2025 20:42:19 GMT", `Content-Type` = "application/json; charset=utf-8", 
        `Transfer-Encoding` = "chunked", Connection = "keep-alive", 
        `Access-Control-Allow-Origin` = "*", Vary = "Accept-Encoding", 
        `Content-Encoding` = "gzip", Age = "0", `X-Socrata-Region` = "aws-us-east-1-fedramp-prod", 
        `Strict-Transport-Security` = "max-age=31536000; includeSubDomains", 
        `X-Socrata-RequestId` = "e513543e28d816663eb916f916385355"), class = "httr2_headers"), 
    body = charToRaw("{\n  \"id\" : \"2asz-g9qq\",\n  \"name\" : \"All OBE Column Types\",\n  \"assetType\" : \"dataset\",\n  \"averageRating\" : 0,\n  \"createdAt\" : 1413228415,\n  \"diciBackend\" : false,\n  \"displayType\" : \"table\",\n  \"downloadCount\" : 256,\n  \"hideFromCatalog\" : false,\n  \"hideFromDataJson\" : false,\n  \"indexUpdatedAt\" : 1414646354,\n  \"locked\" : false,\n  \"newBackend\" : true,\n  \"numberOfComments\" : 0,\n  \"oid\" : 9110954,\n  \"provenance\" : \"official\",\n  \"publicationAppendEnabled\" : false,\n  \"publicationDate\" : 1413229908,\n  \"publicationGroup\" : 1792523,\n  \"publicationStage\" : \"published\",\n  \"rowClass\" : \"\",\n  \"rowsUpdatedAt\" : 1413229802,\n  \"tableId\" : 1792523,\n  \"totalTimesRated\" : 0,\n  \"viewCount\" : 366,\n  \"viewLastModified\" : 1413229908,\n  \"viewType\" : \"tabular\",\n  \"approvals\" : [ {\n    \"reviewedAt\" : 1413229908,\n    \"reviewedAutomatically\" : true,\n    \"state\" : \"approved\",\n    \"submissionId\" : 509398,\n    \"submissionObject\" : \"public_audience_request\",\n    \"submissionOutcome\" : \"change_audience\",\n    \"submittedAt\" : 1413229908,\n    \"targetAudience\" : \"public\",\n    \"workflowId\" : 1674,\n    \"submissionDetails\" : {\n      \"permissionType\" : \"READ\"\n    },\n    \"submissionOutcomeApplication\" : {\n      \"failureCount\" : 0,\n      \"status\" : \"success\"\n    },\n    \"submitter\" : {\n      \"id\" : \"8wwb-4vf2\",\n      \"displayName\" : \"Chris Metcalf (Developer Experience)\"\n    }\n  } ],\n  \"clientContext\" : {\n    \"clientContextVariables\" : [ ],\n    \"inheritedVariables\" : { }\n  },\n  \"columns\" : [ {\n    \"id\" : 171040277,\n    \"name\" : \"Plain Text Column\",\n    \"dataTypeName\" : \"text\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"plain_text_column\",\n    \"position\" : 1,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 22383382,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"1\",\n      \"largest\" : \"Sample Text\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"Sample Text\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"Sample Text\",\n      \"not_null\" : \"1\",\n      \"count\" : \"1\",\n      \"cardinality\" : \"1\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 171040571,\n    \"name\" : \"Formatted Text Column\",\n    \"dataTypeName\" : \"text\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"formatted_text_column\",\n    \"position\" : 2,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 22383486,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"1\",\n      \"largest\" : \"<p>Sample <strong>Rich Text</strong></p>\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"<p>Sample <strong>Rich Text</strong></p>\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"<p>Sample <strong>Rich Text</strong></p>\",\n      \"not_null\" : \"1\",\n      \"count\" : \"1\",\n      \"cardinality\" : \"1\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 171040572,\n    \"name\" : \"Number Column\",\n    \"dataTypeName\" : \"number\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"number_column\",\n    \"position\" : 3,\n    \"renderTypeName\" : \"number\",\n    \"tableColumnId\" : 22383487,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"1\",\n      \"average\" : \"42\",\n      \"largest\" : \"42\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"42\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"42\",\n      \"not_null\" : \"1\",\n      \"count\" : \"1\",\n      \"sum\" : \"42\",\n      \"cardinality\" : \"1\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 171040882,\n    \"name\" : \"Money Column\",\n    \"dataTypeName\" : \"number\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"money_column\",\n    \"position\" : 4,\n    \"renderTypeName\" : \"number\",\n    \"tableColumnId\" : 22383503,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"1\",\n      \"average\" : \"1000000\",\n      \"largest\" : \"1000000\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"1000000\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"1000000\",\n      \"not_null\" : \"1\",\n      \"count\" : \"1\",\n      \"sum\" : \"1000000\",\n      \"cardinality\" : \"1\"\n    },\n    \"format\" : {\n      \"precisionStyle\" : \"currency\",\n      \"currencyStyle\" : \"USD\",\n      \"precision\" : \"2\"\n    }\n  }, {\n    \"id\" : 171040890,\n    \"name\" : \"Percent Column\",\n    \"dataTypeName\" : \"number\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"percent_column\",\n    \"position\" : 5,\n    \"renderTypeName\" : \"number\",\n    \"tableColumnId\" : 22383511,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"1\",\n      \"average\" : \"66\",\n      \"largest\" : \"66\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"66\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"66\",\n      \"not_null\" : \"1\",\n      \"count\" : \"1\",\n      \"sum\" : \"66\",\n      \"cardinality\" : \"1\"\n    },\n    \"format\" : {\n      \"precisionStyle\" : \"percentage\",\n      \"percentScale\" : \"100\",\n      \"view\" : \"percent_bar_and_text\"\n    }\n  }, {\n    \"id\" : 171040938,\n    \"name\" : \"Date & Time Column\",\n    \"dataTypeName\" : \"calendar_date\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"date_time_column\",\n    \"position\" : 6,\n    \"renderTypeName\" : \"calendar_date\",\n    \"tableColumnId\" : 22383535,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"1\",\n      \"largest\" : \"2014-10-13T00:00:00.000\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"2014-10-13T00:00:00.000\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"2014-10-13T00:00:00.000\",\n      \"not_null\" : \"1\",\n      \"count\" : \"1\",\n      \"cardinality\" : \"1\"\n    },\n    \"format\" : {\n      \"view\" : \"date_time\",\n      \"align\" : \"left\"\n    }\n  }, {\n    \"id\" : 171040939,\n    \"name\" : \"Date & Time with Timezone Column\",\n    \"dataTypeName\" : \"date\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"date_time_with_timezone_column\",\n    \"position\" : 7,\n    \"renderTypeName\" : \"date\",\n    \"tableColumnId\" : 22383536,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"1\",\n      \"largest\" : \"2014-10-14T07:00:00.000Z\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"2014-10-14T07:00:00.000Z\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"2014-10-14T07:00:00.000Z\",\n      \"not_null\" : \"1\",\n      \"count\" : \"1\",\n      \"cardinality\" : \"1\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 171040940,\n    \"name\" : \"Location Column\",\n    \"dataTypeName\" : \"location\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"location_column\",\n    \"position\" : 8,\n    \"renderTypeName\" : \"location\",\n    \"tableColumnId\" : 22383537,\n    \"width\" : 100,\n    \"format\" : { }\n  }, {\n    \"id\" : 171040941,\n    \"name\" : \"Website URL Column\",\n    \"dataTypeName\" : \"url\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"website_url_column\",\n    \"position\" : 13,\n    \"renderTypeName\" : \"url\",\n    \"tableColumnId\" : 22383538,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : 1,\n      \"largest\" : {\n        \"description\" : \"Socrata\",\n        \"url\" : \"http://www.socrata.com\"\n      },\n      \"null\" : 0,\n      \"top\" : [ {\n        \"item\" : {\n          \"description\" : \"Socrata\",\n          \"url\" : \"http://www.socrata.com\"\n        },\n        \"count\" : 20\n      } ],\n      \"smallest\" : {\n        \"description\" : \"Socrata\",\n        \"url\" : \"http://www.socrata.com\"\n      }\n    },\n    \"format\" : { },\n    \"subColumnTypes\" : [ \"url\", \"description\" ]\n  }, {\n    \"id\" : 171040942,\n    \"name\" : \"Email Column\",\n    \"dataTypeName\" : \"text\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"email_column\",\n    \"position\" : 14,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 22383539,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"1\",\n      \"largest\" : \"support@socrata.com\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"support@socrata.com\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"support@socrata.com\",\n      \"not_null\" : \"1\",\n      \"count\" : \"1\",\n      \"cardinality\" : \"1\"\n    },\n    \"format\" : {\n      \"displayStyle\" : \"email\"\n    }\n  }, {\n    \"id\" : 171040943,\n    \"name\" : \"Checkbox Column\",\n    \"dataTypeName\" : \"checkbox\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"checkbox_column\",\n    \"position\" : 15,\n    \"renderTypeName\" : \"checkbox\",\n    \"tableColumnId\" : 22383540,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"1\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : true,\n        \"count\" : \"1\"\n      } ],\n      \"not_null\" : \"1\",\n      \"count\" : \"1\",\n      \"cardinality\" : \"1\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 171040944,\n    \"name\" : \"Flag Column\",\n    \"dataTypeName\" : \"text\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"flag_column\",\n    \"position\" : 16,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 22383541,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"1\",\n      \"largest\" : \"green\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"green\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"green\",\n      \"not_null\" : \"1\",\n      \"count\" : \"1\",\n      \"cardinality\" : \"1\"\n    },\n    \"format\" : {\n      \"displayStyle\" : \"flag\"\n    }\n  }, {\n    \"id\" : 171040996,\n    \"name\" : \"Star Column\",\n    \"dataTypeName\" : \"number\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"star_column\",\n    \"position\" : 17,\n    \"renderTypeName\" : \"number\",\n    \"tableColumnId\" : 22383581,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"1\",\n      \"average\" : \"3\",\n      \"largest\" : \"3\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"3\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"3\",\n      \"not_null\" : \"1\",\n      \"count\" : \"1\",\n      \"sum\" : \"3\",\n      \"cardinality\" : \"1\"\n    },\n    \"format\" : {\n      \"displayStyle\" : \"stars\"\n    }\n  }, {\n    \"id\" : 171041037,\n    \"name\" : \"Phone Column\",\n    \"dataTypeName\" : \"text\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"phone_column\",\n    \"position\" : 18,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 22383622,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"1\",\n      \"largest\" : \"206-555-1212\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"206-555-1212\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"206-555-1212\",\n      \"not_null\" : \"1\",\n      \"count\" : \"1\",\n      \"cardinality\" : \"1\"\n    },\n    \"format\" : {\n      \"displayStyle\" : \"phone\"\n    }\n  }, {\n    \"id\" : 171041080,\n    \"name\" : \"Multiple Choice\",\n    \"dataTypeName\" : \"text\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"multiple_choice\",\n    \"position\" : 19,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 22383627,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"1\",\n      \"largest\" : \"Maybe\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"Maybe\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"Maybe\",\n      \"not_null\" : \"1\",\n      \"count\" : \"1\",\n      \"cardinality\" : \"1\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 171041087,\n    \"name\" : \"Photo Column\",\n    \"dataTypeName\" : \"photo\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"photo_column\",\n    \"position\" : 20,\n    \"renderTypeName\" : \"photo\",\n    \"tableColumnId\" : 22383634,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : 1,\n      \"null\" : 0\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 171041183,\n    \"name\" : \"Document\",\n    \"dataTypeName\" : \"document\",\n    \"description\" : \"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque dictum augue ac lorem malesuada at rhoncus turpis condimentum. Maecenas commodo sem ac magna posuere ultrices. Proin ut felis ac odio consectetur rutrum vel quis sem.\",\n    \"fieldName\" : \"document\",\n    \"position\" : 21,\n    \"renderTypeName\" : \"document\",\n    \"tableColumnId\" : 22383650,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : 1,\n      \"null\" : 0\n    },\n    \"format\" : { },\n    \"subColumnTypes\" : [ \"content_type\", \"file_id\", \"filename\", \"size\" ]\n  }, {\n    \"id\" : 428593239,\n    \"name\" : \"Zip Codes\",\n    \"dataTypeName\" : \"number\",\n    \"description\" : \"This column was automatically created in order to record in what polygon from the dataset 'Zip Codes' (k83t-ady5) the point in column 'location_column' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.\",\n    \"fieldName\" : \":@computed_region_k83t_ady5\",\n    \"position\" : 22,\n    \"renderTypeName\" : \"number\",\n    \"tableColumnId\" : 87609313,\n    \"computationStrategy\" : {\n      \"source_columns\" : [ \"location_column\" ],\n      \"type\" : \"georegion_match_on_point\",\n      \"parameters\" : {\n        \"region\" : \"_k83t-ady5\",\n        \"primary_key\" : \"_feature_id\"\n      }\n    },\n    \"format\" : { }\n  } ],\n  \"grants\" : [ {\n    \"inherited\" : false,\n    \"type\" : \"viewer\",\n    \"flags\" : [ \"public\" ]\n  } ],\n  \"metadata\" : {\n    \"rdfSubject\" : \"0\",\n    \"rdfClass\" : \"\",\n    \"rowIdentifier\" : \"0\",\n    \"availableDisplayTypes\" : [ \"table\", \"fatrow\", \"page\" ],\n    \"renderTypeConfig\" : {\n      \"visible\" : {\n        \"table\" : true\n      }\n    }\n  },\n  \"owner\" : {\n    \"id\" : \"8wwb-4vf2\",\n    \"displayName\" : \"Chris Metcalf (Developer Experience)\",\n    \"screenName\" : \"Chris Metcalf (Developer Experience)\",\n    \"type\" : \"interactive\"\n  },\n  \"query\" : { },\n  \"rights\" : [ \"read\" ],\n  \"tableAuthor\" : {\n    \"id\" : \"8wwb-4vf2\",\n    \"displayName\" : \"Chris Metcalf (Developer Experience)\",\n    \"screenName\" : \"Chris Metcalf (Developer Experience)\",\n    \"type\" : \"interactive\"\n  },\n  \"flags\" : [ \"default\", \"ownerMayBeContacted\", \"restorable\", \"restorePossibleForType\" ]\n}\n"), 
    timing = c(redirect = 0, namelookup = 1e-05, connect = 0, 
    pretransfer = 3.9e-05, starttransfer = 0.071903, total = 0.0722
    ), cache = new.env(parent = emptyenv())), class = "httr2_response")