tests/testthat/soc_metadata/soda.demo.socrata.com/api/views/2646-ez2p.R

structure(list(method = "GET", url = "https://soda.demo.socrata.com/api/views/2646-ez2p", 
    status_code = 200L, headers = structure(list(Server = "nginx", 
        Date = "Tue, 22 Jul 2025 20:42:01 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` = "e38cead9cfa0af7a8fad711af56fed7e"), class = "httr2_headers"), 
    body = charToRaw("{\n  \"id\" : \"2646-ez2p\",\n  \"name\" : \"Datasites for APIs.JSON\",\n  \"assetType\" : \"dataset\",\n  \"averageRating\" : 0,\n  \"createdAt\" : 1420244028,\n  \"diciBackend\" : false,\n  \"displayType\" : \"table\",\n  \"downloadCount\" : 58,\n  \"hideFromCatalog\" : false,\n  \"hideFromDataJson\" : false,\n  \"indexUpdatedAt\" : 1420246613,\n  \"locked\" : false,\n  \"newBackend\" : true,\n  \"numberOfComments\" : 0,\n  \"oid\" : 9815461,\n  \"provenance\" : \"official\",\n  \"publicationAppendEnabled\" : false,\n  \"publicationDate\" : 1420246587,\n  \"publicationGroup\" : 2055249,\n  \"publicationStage\" : \"published\",\n  \"rowIdentifierColumnId\" : 182920865,\n  \"rowsUpdatedAt\" : 1420246585,\n  \"tableId\" : 2055375,\n  \"totalTimesRated\" : 0,\n  \"viewCount\" : 285,\n  \"viewLastModified\" : 1420246587,\n  \"viewType\" : \"tabular\",\n  \"approvals\" : [ {\n    \"reviewedAt\" : 1420246587,\n    \"reviewedAutomatically\" : true,\n    \"state\" : \"approved\",\n    \"submissionId\" : 509403,\n    \"submissionObject\" : \"public_audience_request\",\n    \"submissionOutcome\" : \"change_audience\",\n    \"submittedAt\" : 1420246587,\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\" : 182920865,\n    \"name\" : \"Domain\",\n    \"dataTypeName\" : \"text\",\n    \"fieldName\" : \"domain\",\n    \"position\" : 1,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 23717132,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"2\",\n      \"largest\" : \"data.sfgov.org\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"data.sfgov.org\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"data.seattle.gov\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"data.seattle.gov\",\n      \"count\" : \"2\",\n      \"cardinality\" : \"2\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 182920866,\n    \"name\" : \"Name\",\n    \"dataTypeName\" : \"text\",\n    \"fieldName\" : \"name\",\n    \"position\" : 2,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 23717194,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"2\",\n      \"largest\" : \"City of Seattle\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"City of San Francisco\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"City of Seattle\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"City of San Francisco\",\n      \"count\" : \"2\",\n      \"cardinality\" : \"2\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 182920867,\n    \"name\" : \"Logo\",\n    \"dataTypeName\" : \"text\",\n    \"fieldName\" : \"logo\",\n    \"position\" : 3,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 23717542,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"0\",\n      \"null\" : \"2\",\n      \"count\" : \"2\",\n      \"cardinality\" : \"0\"\n    },\n    \"format\" : {\n      \"align\" : \"left\"\n    }\n  }, {\n    \"id\" : 182920893,\n    \"name\" : \"Tags\",\n    \"dataTypeName\" : \"text\",\n    \"fieldName\" : \"tags\",\n    \"position\" : 4,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 23717893,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"2\",\n      \"largest\" : \"seattle, open data, washington, open government\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"seattle, open data, washington, open government\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"san francisco, california, open data\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"san francisco, california, open data\",\n      \"count\" : \"2\",\n      \"cardinality\" : \"2\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 182920894,\n    \"name\" : \"Email\",\n    \"dataTypeName\" : \"text\",\n    \"fieldName\" : \"email\",\n    \"position\" : 5,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 23717894,\n    \"width\" : 100,\n    \"cachedContents\" : {\n      \"non_null\" : \"2\",\n      \"largest\" : \"open-data@sfgov.org\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"open-data@seattle.gov\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"open-data@sfgov.org\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"open-data@seattle.gov\",\n      \"count\" : \"2\",\n      \"cardinality\" : \"2\"\n    },\n    \"format\" : { }\n  } ],\n  \"grants\" : [ {\n    \"inherited\" : false,\n    \"type\" : \"viewer\",\n    \"flags\" : [ \"public\" ]\n  } ],\n  \"metadata\" : {\n    \"rdfSubject\" : \"0\",\n    \"rowIdentifier\" : 182920865,\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 = 0.014723, connect = 0.041201, 
    pretransfer = 0.107422, starttransfer = 0.199167, total = 0.199336
    ), cache = new.env(parent = emptyenv())), class = "httr2_response")

Try the socratadata package in your browser

Any scripts or data that you put into this service are public.

socratadata documentation built on Aug. 8, 2025, 6:08 p.m.