tests/testthat/soc_query/soda.demo.socrata.com/api/views/4tka-6guv.R

In socratadata: Explore Socrata Data with Ease

structure(list(method = "GET", url = "https://soda.demo.socrata.com/api/views/4tka-6guv", 
    status_code = 200L, headers = structure(list(Server = "nginx", 
        Date = "Tue, 22 Jul 2025 20:42:08 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` = "e23100cbdda7f2e0b4111b04d9a76cbb"), class = "httr2_headers"), 
    body = charToRaw("{\n  \"id\" : \"4tka-6guv\",\n  \"name\" : \"My super awesome Earthquakes dataset\",\n  \"assetType\" : \"dataset\",\n  \"averageRating\" : 0,\n  \"createdAt\" : 1347663573,\n  \"description\" : \"Real-time, worldwide earthquake list for the past 7 days (not actually real-time)\",\n  \"diciBackend\" : false,\n  \"displayType\" : \"table\",\n  \"downloadCount\" : 4142,\n  \"hideFromCatalog\" : false,\n  \"hideFromDataJson\" : false,\n  \"indexUpdatedAt\" : 1472854428,\n  \"locked\" : false,\n  \"newBackend\" : true,\n  \"numberOfComments\" : 0,\n  \"oid\" : 20616098,\n  \"provenance\" : \"official\",\n  \"publicationAppendEnabled\" : false,\n  \"publicationDate\" : 1462209542,\n  \"publicationGroup\" : 426539,\n  \"publicationStage\" : \"published\",\n  \"resourceName\" : \"earthquakes\",\n  \"rowIdentifierColumnId\" : 253201044,\n  \"rowsUpdatedAt\" : 1462209510,\n  \"tableId\" : 10487210,\n  \"totalTimesRated\" : 0,\n  \"viewCount\" : 7993,\n  \"viewLastModified\" : 1472854412,\n  \"viewType\" : \"tabular\",\n  \"approvals\" : [ {\n    \"reviewedAt\" : 1462209542,\n    \"reviewedAutomatically\" : true,\n    \"state\" : \"approved\",\n    \"submissionId\" : 509426,\n    \"submissionObject\" : \"public_audience_request\",\n    \"submissionOutcome\" : \"change_audience\",\n    \"submittedAt\" : 1462209542,\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\" : 253201043,\n    \"name\" : \"Source\",\n    \"dataTypeName\" : \"text\",\n    \"fieldName\" : \"source\",\n    \"position\" : 1,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 4152736,\n    \"width\" : 172,\n    \"cachedContents\" : {\n      \"largest\" : \"uw\",\n      \"non_null\" : \"10821\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"ak\",\n        \"count\" : \"3576\"\n      }, {\n        \"item\" : \"nc\",\n        \"count\" : \"2601\"\n      }, {\n        \"item\" : \"ci\",\n        \"count\" : \"1632\"\n      }, {\n        \"item\" : \"us\",\n        \"count\" : \"888\"\n      }, {\n        \"item\" : \"nn\",\n        \"count\" : \"511\"\n      }, {\n        \"item\" : \"pr\",\n        \"count\" : \"405\"\n      }, {\n        \"item\" : \"hv\",\n        \"count\" : \"363\"\n      }, {\n        \"item\" : \"uu\",\n        \"count\" : \"359\"\n      }, {\n        \"item\" : \"uw\",\n        \"count\" : \"359\"\n      }, {\n        \"item\" : \"mb\",\n        \"count\" : \"73\"\n      }, {\n        \"item\" : \"nm\",\n        \"count\" : \"44\"\n      }, {\n        \"item\" : \"ld\",\n        \"count\" : \"3\"\n      }, {\n        \"item\" : \"se\",\n        \"count\" : \"3\"\n      }, {\n        \"item\" : \"socrata\",\n        \"count\" : \"2\"\n      }, {\n        \"item\" : \"at\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"Source\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"ak\",\n      \"not_null\" : \"10821\",\n      \"count\" : \"10821\",\n      \"cardinality\" : \"16\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 253201044,\n    \"name\" : \"Earthquake ID\",\n    \"dataTypeName\" : \"text\",\n    \"fieldName\" : \"earthquake_id\",\n    \"position\" : 2,\n    \"rdfProperties\" : \"http://purl.org/dc/terms/identifier\",\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 4152737,\n    \"width\" : 256,\n    \"cachedContents\" : {\n      \"largest\" : \"uw60801261\",\n      \"non_null\" : \"10821\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"c000cj9f\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"71839665\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"nc72230956\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"ak11255778\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"12257006\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"10557116\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"ak11238680\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"ak11254273\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"ak11251149\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"usb000pz4t\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"nc72215911\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"nc72214306\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"nc72224021\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"nc72215396\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"ak11263342\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"15215105\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"ak11239014\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"nc72216130\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"ak11244767\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"hv60706481\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"00388123\",\n      \"not_null\" : \"10821\",\n      \"count\" : \"10821\",\n      \"cardinality\" : \"10821\"\n    },\n    \"format\" : {\n      \"rdf\" : \"http://purl.org/dc/terms/identifier\",\n      \"align\" : \"left\"\n    }\n  }, {\n    \"id\" : 253201045,\n    \"name\" : \"Version\",\n    \"dataTypeName\" : \"text\",\n    \"fieldName\" : \"version\",\n    \"position\" : 3,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 4152738,\n    \"width\" : 184,\n    \"cachedContents\" : {\n      \"largest\" : \"Version\",\n      \"non_null\" : \"1005\",\n      \"null\" : \"9816\",\n      \"top\" : [ {\n        \"item\" : \"2\",\n        \"count\" : \"465\"\n      }, {\n        \"item\" : \"1\",\n        \"count\" : \"148\"\n      }, {\n        \"item\" : \"0\",\n        \"count\" : \"118\"\n      }, {\n        \"item\" : \"3\",\n        \"count\" : \"75\"\n      }, {\n        \"item\" : \"4\",\n        \"count\" : \"41\"\n      }, {\n        \"item\" : \"5\",\n        \"count\" : \"33\"\n      }, {\n        \"item\" : \"9\",\n        \"count\" : \"31\"\n      }, {\n        \"item\" : \"6\",\n        \"count\" : \"25\"\n      }, {\n        \"item\" : \"7\",\n        \"count\" : \"24\"\n      }, {\n        \"item\" : \"8\",\n        \"count\" : \"21\"\n      }, {\n        \"item\" : \"A\",\n        \"count\" : \"17\"\n      }, {\n        \"item\" : \"B\",\n        \"count\" : \"2\"\n      }, {\n        \"item\" : \"C\",\n        \"count\" : \"2\"\n      }, {\n        \"item\" : \"D\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"E\",\n        \"count\" : \"1\"\n      }, {\n        \"item\" : \"Version\",\n        \"count\" : \"1\"\n      } ],\n      \"smallest\" : \"0\",\n      \"not_null\" : \"1005\",\n      \"count\" : \"10821\",\n      \"cardinality\" : \"16\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 253201047,\n    \"name\" : \"Magnitude\",\n    \"dataTypeName\" : \"number\",\n    \"fieldName\" : \"magnitude\",\n    \"position\" : 5,\n    \"renderTypeName\" : \"number\",\n    \"tableColumnId\" : 4152740,\n    \"width\" : 208,\n    \"cachedContents\" : {\n      \"largest\" : \"6.6\",\n      \"non_null\" : \"10820\",\n      \"average\" : \"1.551068391866913\",\n      \"null\" : \"1\",\n      \"top\" : [ {\n        \"item\" : \"1.1\",\n        \"count\" : \"537\"\n      }, {\n        \"item\" : \"1.2\",\n        \"count\" : \"492\"\n      }, {\n        \"item\" : \"1\",\n        \"count\" : \"485\"\n      }, {\n        \"item\" : \"1.3\",\n        \"count\" : \"467\"\n      }, {\n        \"item\" : \"1.4\",\n        \"count\" : \"422\"\n      }, {\n        \"item\" : \"0.9\",\n        \"count\" : \"405\"\n      }, {\n        \"item\" : \"1.5\",\n        \"count\" : \"354\"\n      }, {\n        \"item\" : \"1.7\",\n        \"count\" : \"323\"\n      }, {\n        \"item\" : \"0.6\",\n        \"count\" : \"318\"\n      }, {\n        \"item\" : \"1.6\",\n        \"count\" : \"318\"\n      }, {\n        \"item\" : \"0.8\",\n        \"count\" : \"317\"\n      }, {\n        \"item\" : \"1.8\",\n        \"count\" : \"276\"\n      }, {\n        \"item\" : \"0.7\",\n        \"count\" : \"259\"\n      }, {\n        \"item\" : \"0.5\",\n        \"count\" : \"252\"\n      }, {\n        \"item\" : \"0.4\",\n        \"count\" : \"250\"\n      }, {\n        \"item\" : \"1.9\",\n        \"count\" : \"249\"\n      }, {\n        \"item\" : \"2\",\n        \"count\" : \"200\"\n      }, {\n        \"item\" : \"0.3\",\n        \"count\" : \"185\"\n      }, {\n        \"item\" : \"2.1\",\n        \"count\" : \"185\"\n      }, {\n        \"item\" : \"2.2\",\n        \"count\" : \"171\"\n      } ],\n      \"smallest\" : \"-0.5\",\n      \"not_null\" : \"10820\",\n      \"count\" : \"10821\",\n      \"sum\" : \"167825.60\",\n      \"cardinality\" : \"336\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 253201048,\n    \"name\" : \"Depth\",\n    \"dataTypeName\" : \"number\",\n    \"fieldName\" : \"depth\",\n    \"position\" : 6,\n    \"renderTypeName\" : \"number\",\n    \"tableColumnId\" : 4152741,\n    \"width\" : 160,\n    \"cachedContents\" : {\n      \"largest\" : \"635.78\",\n      \"non_null\" : \"10820\",\n      \"average\" : \"22.41530325323475\",\n      \"null\" : \"1\",\n      \"top\" : [ {\n        \"item\" : \"0\",\n        \"count\" : \"491\"\n      }, {\n        \"item\" : \"10\",\n        \"count\" : \"178\"\n      }, {\n        \"item\" : \"5\",\n        \"count\" : \"109\"\n      }, {\n        \"item\" : \"2.4\",\n        \"count\" : \"95\"\n      }, {\n        \"item\" : \"2.6\",\n        \"count\" : \"94\"\n      }, {\n        \"item\" : \"2.5\",\n        \"count\" : \"94\"\n      }, {\n        \"item\" : \"2.7\",\n        \"count\" : \"86\"\n      }, {\n        \"item\" : \"100\",\n        \"count\" : \"78\"\n      }, {\n        \"item\" : \"3.1\",\n        \"count\" : \"75\"\n      }, {\n        \"item\" : \"2.8\",\n        \"count\" : \"73\"\n      }, {\n        \"item\" : \"2.3\",\n        \"count\" : \"70\"\n      }, {\n        \"item\" : \"2.9\",\n        \"count\" : \"70\"\n      }, {\n        \"item\" : \"0.1\",\n        \"count\" : \"70\"\n      }, {\n        \"item\" : \"7.2\",\n        \"count\" : \"66\"\n      }, {\n        \"item\" : \"3.3\",\n        \"count\" : \"65\"\n      }, {\n        \"item\" : \"7.4\",\n        \"count\" : \"65\"\n      }, {\n        \"item\" : \"3.5\",\n        \"count\" : \"59\"\n      }, {\n        \"item\" : \"7\",\n        \"count\" : \"59\"\n      }, {\n        \"item\" : \"3.2\",\n        \"count\" : \"59\"\n      }, {\n        \"item\" : \"0.01\",\n        \"count\" : \"58\"\n      } ],\n      \"smallest\" : \"-5.5\",\n      \"not_null\" : \"10820\",\n      \"count\" : \"10821\",\n      \"sum\" : \"2425335.8120\",\n      \"cardinality\" : \"2971\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 253201049,\n    \"name\" : \"Number of Stations\",\n    \"dataTypeName\" : \"number\",\n    \"fieldName\" : \"number_of_stations\",\n    \"position\" : 7,\n    \"renderTypeName\" : \"number\",\n    \"tableColumnId\" : 4152742,\n    \"width\" : 316,\n    \"cachedContents\" : {\n      \"largest\" : \"647\",\n      \"non_null\" : \"7278\",\n      \"average\" : \"19.78496839791151\",\n      \"null\" : \"3543\",\n      \"top\" : [ {\n        \"item\" : \"8\",\n        \"count\" : \"492\"\n      }, {\n        \"item\" : \"7\",\n        \"count\" : \"428\"\n      }, {\n        \"item\" : \"9\",\n        \"count\" : \"409\"\n      }, {\n        \"item\" : \"11\",\n        \"count\" : \"363\"\n      }, {\n        \"item\" : \"12\",\n        \"count\" : \"332\"\n      }, {\n        \"item\" : \"10\",\n        \"count\" : \"332\"\n      }, {\n        \"item\" : \"5\",\n        \"count\" : \"319\"\n      }, {\n        \"item\" : \"6\",\n        \"count\" : \"306\"\n      }, {\n        \"item\" : \"14\",\n        \"count\" : \"297\"\n      }, {\n        \"item\" : \"15\",\n        \"count\" : \"265\"\n      }, {\n        \"item\" : \"13\",\n        \"count\" : \"262\"\n      }, {\n        \"item\" : \"16\",\n        \"count\" : \"250\"\n      }, {\n        \"item\" : \"17\",\n        \"count\" : \"232\"\n      }, {\n        \"item\" : \"19\",\n        \"count\" : \"226\"\n      }, {\n        \"item\" : \"18\",\n        \"count\" : \"223\"\n      }, {\n        \"item\" : \"20\",\n        \"count\" : \"177\"\n      }, {\n        \"item\" : \"4\",\n        \"count\" : \"147\"\n      }, {\n        \"item\" : \"22\",\n        \"count\" : \"146\"\n      }, {\n        \"item\" : \"21\",\n        \"count\" : \"146\"\n      }, {\n        \"item\" : \"23\",\n        \"count\" : \"132\"\n      } ],\n      \"smallest\" : \"0\",\n      \"not_null\" : \"7278\",\n      \"count\" : \"10821\",\n      \"sum\" : \"1439950\",\n      \"cardinality\" : \"154\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 253201050,\n    \"name\" : \"Region\",\n    \"dataTypeName\" : \"text\",\n    \"fieldName\" : \"region\",\n    \"position\" : 8,\n    \"renderTypeName\" : \"text\",\n    \"tableColumnId\" : 4152743,\n    \"width\" : 172,\n    \"cachedContents\" : {\n      \"largest\" : \"Yunnan, China\",\n      \"non_null\" : \"10821\",\n      \"null\" : \"0\",\n      \"top\" : [ {\n        \"item\" : \"2km ESE of Mammoth Lakes, California\",\n        \"count\" : \"208\"\n      }, {\n        \"item\" : \"Southern California\",\n        \"count\" : \"143\"\n      }, {\n        \"item\" : \"6km NW of The Geysers, California\",\n        \"count\" : \"126\"\n      }, {\n        \"item\" : \"Northern California\",\n        \"count\" : \"119\"\n      }, {\n        \"item\" : \"Southern Alaska\",\n        \"count\" : \"103\"\n      }, {\n        \"item\" : \"Central California\",\n        \"count\" : \"91\"\n      }, {\n        \"item\" : \"16km ENE of Hawthorne, Nevada\",\n        \"count\" : \"82\"\n      }, {\n        \"item\" : \"1km ESE of Mammoth Lakes, California\",\n        \"count\" : \"78\"\n      }, {\n        \"item\" : \"Central Alaska\",\n        \"count\" : \"77\"\n      }, {\n        \"item\" : \"9km WNW of Cobb, California\",\n        \"count\" : \"69\"\n      }, {\n        \"item\" : \"7km W of Anza, California\",\n        \"count\" : \"67\"\n      }, {\n        \"item\" : \"7km WNW of Cobb, California\",\n        \"count\" : \"62\"\n      }, {\n        \"item\" : \"17km ENE of Hawthorne, Nevada\",\n        \"count\" : \"58\"\n      }, {\n        \"item\" : \"6km WNW of The Geysers, California\",\n        \"count\" : \"51\"\n      }, {\n        \"item\" : \"6km W of Cobb, California\",\n        \"count\" : \"50\"\n      }, {\n        \"item\" : \"8km W of Anza, California\",\n        \"count\" : \"47\"\n      }, {\n        \"item\" : \"5km NW of The Geysers, California\",\n        \"count\" : \"46\"\n      }, {\n        \"item\" : \"7km NW of The Geysers, California\",\n        \"count\" : \"46\"\n      }, {\n        \"item\" : \"Fox Islands, Aleutian Islands, Alaska\",\n        \"count\" : \"44\"\n      }, {\n        \"item\" : \"Virgin Islands region\",\n        \"count\" : \"38\"\n      } ],\n      \"smallest\" : \"0km ENE of Chico, Washington\",\n      \"not_null\" : \"10821\",\n      \"count\" : \"10821\",\n      \"cardinality\" : \"5861\"\n    },\n    \"format\" : { }\n  }, {\n    \"id\" : 253201051,\n    \"name\" : \"Location\",\n    \"dataTypeName\" : \"location\",\n    \"fieldName\" : \"location\",\n    \"position\" : 9,\n    \"renderTypeName\" : \"location\",\n    \"tableColumnId\" : 4152744,\n    \"width\" : 196,\n    \"format\" : { }\n  }, {\n    \"id\" : 426783717,\n    \"name\" : \"Zip Codes\",\n    \"dataTypeName\" : \"number\",\n    \"fieldName\" : \":@computed_region_k83t_ady5\",\n    \"position\" : 14,\n    \"renderTypeName\" : \"number\",\n    \"tableColumnId\" : 86976752,\n    \"computationStrategy\" : {\n      \"source_columns\" : [ \"location\" ],\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    \"custom_fields\" : {\n      \"Test Metadata\" : {\n        \"Field 1\" : \"Foobar\",\n        \"Field 2\" : \"Quoquux\"\n      }\n    },\n    \"rowIdentifier\" : 253201044,\n    \"rowLabel\" : \"Row\",\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 = 2e-05, connect = 0, 
    pretransfer = 7.3e-05, starttransfer = 0.072409, total = 0.072633
    ), cache = new.env(parent = emptyenv())), class = "httr2_response")