{
  "_id": "6ab4e0403d719c1f84096cc7",
  "Package": "datrProfile",
  "Type": "Package",
  "Title": "Column Profile for Tables and Datasets",
  "Version": "0.1.0",
  "Authors@R": "person(\"Arnaldo\", \"Vitaliano\", email = \"vitaliano@gmail.com\",\nrole = c(\"aut\", \"cre\"))",
  "Description": "Profiles datasets (collecting statistics and informative\nsummaries about that data) on data frames and 'ODBC' tables:\nmaximum, minimum, mean, standard deviation, nulls, distinct\nvalues, data patterns, data/format frequencies.",
  "License": "GPL-3 | file LICENSE",
  "URL": "https://github.com/avitaliano/datrProfile",
  "BugReports": "https://github.com/avitaliano/datrProfile/issues",
  "Encoding": "UTF-8",
  "RoxygenNote": "6.1.1",
  "Config/pak/sysreqs": "make unixodbc-dev",
  "Repository": "https://avitaliano.r-universe.dev",
  "Date/Publication": "2019-07-31 12:48:39 UTC",
  "RemoteUrl": "https://github.com/avitaliano/datrprofile",
  "RemoteRef": "HEAD",
  "RemoteSha": "4272a86165353b5de694ff02825e826e5fde89d3",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-09-24 08:29:17 UTC",
    "User": "root"
  },
  "Author": "Arnaldo Vitaliano [aut, cre]",
  "Maintainer": "Arnaldo Vitaliano <vitaliano@gmail.com>",
  "_user": "avitaliano",
  "_type": "src",
  "_file": "datrProfile_0.1.0.tar.gz",
  "_fileid": "https://r2.ropensci.org/cd7fbe38bec737ba751616484333ce7eeb57a0eda04a888b65110de31cdb6d74",
  "_filesize": 126449,
  "_sha256": "cd7fbe38bec737ba751616484333ce7eeb57a0eda04a888b65110de31cdb6d74",
  "_expires": "2027-01-02T08:33:02.000Z",
  "_created": "2026-09-24T08:29:17.000Z",
  "_published": "2026-09-24T08:33:03.900Z",
  "_jobs": [
    {
      "job": 107555084708,
      "time": 114,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "10798370413"
    },
    {
      "job": 107555084690,
      "time": 127,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10797609659"
    },
    {
      "job": 107555084433,
      "time": 167,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "10798400034"
    },
    {
      "job": 107555084513,
      "time": 153,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10798251177"
    },
    {
      "job": 107554136076,
      "time": 176,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10797842584"
    },
    {
      "job": 107555085118,
      "time": 112,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "10798146618"
    },
    {
      "job": 107555084576,
      "time": 65,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "10797967412"
    },
    {
      "job": 107555084536,
      "time": 61,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "10797224108"
    },
    {
      "job": 107555084504,
      "time": 51,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10797019610"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/avitaliano/actions/runs/35975228901",
  "_status": "success",
  "_upstream": "https://github.com/avitaliano/datrprofile",
  "_commit": {
    "id": "4272a86165353b5de694ff02825e826e5fde89d3",
    "author": "Arnaldo Vitaliano <vitaliano@gmail.com>",
    "committer": "Arnaldo Vitaliano <vitaliano@gmail.com>",
    "message": "typo\n",
    "time": 1564577319
  },
  "_maintainer": {
    "name": "Arnaldo Vitaliano",
    "email": "vitaliano@gmail.com",
    "login": "avitaliano",
    "description": "Public servant, data integration architect, and data quality specialist at Banco Central do Brazil.",
    "uuid": 8205602
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "odbc",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "RSQLite",
      "role": "Imports"
    },
    {
      "package": "testthat",
      "role": "Suggests"
    }
  ],
  "_owner": "avitaliano",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [],
  "_tags": [],
  "_stars": 0,
  "_contributors": [
    {
      "user": "avitaliano",
      "count": 62,
      "uuid": 8205602
    }
  ],
  "_userbio": {
    "uuid": 8205602,
    "type": "user",
    "name": "Arnaldo Vitaliano",
    "followers": 4,
    "description": "Public servant, data integration architect, and data quality specialist at Banco Central do Brazil."
  },
  "_downloads": {
    "count": 295,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/datrProfile"
  },
  "_devurl": "https://github.com/avitaliano/datrprofile",
  "_searchresults": 5,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/datrProfile.html",
    "extra/manual.pdf",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_homeurl": "https://github.com/avitaliano/datrprofile",
  "_realowner": "avitaliano",
  "_cranurl": true,
  "_releases": [
    {
      "version": "0.1.0",
      "date": "2019-08-02"
    }
  ],
  "_exports": [
    "closeConnection",
    "connectDB",
    "getTableColumns",
    "prepareConnection",
    "runProfile"
  ],
  "_help": [
    {
      "page": "buildQueryColumnFrequency",
      "title": "buildQueryColumnFrequency",
      "topics": [
        "buildQueryColumnFrequency"
      ]
    },
    {
      "page": "buildQueryColumnMetadata",
      "title": "buildQueryColumnMetadata",
      "topics": [
        "buildQueryColumnMetadata"
      ]
    },
    {
      "page": "buildQueryColumnStats",
      "title": "buildQueryColumnStats",
      "topics": [
        "buildQueryColumnStats"
      ]
    },
    {
      "page": "buildQueryColumnStats.sqlite",
      "title": "buildQueryColumnStats.sqlite",
      "topics": [
        "buildQueryColumnStats.sqlite"
      ]
    },
    {
      "page": "buildQueryCountNull",
      "title": "buildQueryCountNull",
      "topics": [
        "buildQueryCountNull"
      ]
    },
    {
      "page": "buildQueryCountTotal",
      "title": "buildQueryCountTotal",
      "topics": [
        "buildQueryCountTotal"
      ]
    },
    {
      "page": "buildQueryProfileColumnFormatFrequency",
      "title": "buildQueryProfileColumnFormatFrequency",
      "topics": [
        "buildQueryProfileColumnFormatFrequency"
      ]
    },
    {
      "page": "closeConnection",
      "title": "closeConnection",
      "topics": [
        "closeConnection"
      ]
    },
    {
      "page": "connectDB",
      "title": "connectDB",
      "topics": [
        "connectDB"
      ]
    },
    {
      "page": "connectDB.default",
      "title": "connectDB.default",
      "topics": [
        "connectDB.default"
      ]
    },
    {
      "page": "connectDB.sqlite",
      "title": "connectDB.sqlite",
      "topics": [
        "connectDB.sqlite"
      ]
    },
    {
      "page": "getTableColumns",
      "title": "getTableColumns",
      "topics": [
        "getTableColumns"
      ]
    },
    {
      "page": "prepareConnection",
      "title": "Prepares connection to RDBS via ODBC",
      "topics": [
        "prepareConnection"
      ]
    },
    {
      "page": "print.profile",
      "title": "Print method",
      "topics": [
        "print.profile"
      ]
    },
    {
      "page": "profileColumn",
      "title": "profileColumn",
      "topics": [
        "profileColumn"
      ]
    },
    {
      "page": "profileColumnFormat",
      "title": "profileColumnFormat",
      "topics": [
        "profileColumnFormat"
      ]
    },
    {
      "page": "runProfile",
      "title": "Profile all columns from ODBC table or dataframe",
      "topics": [
        "runProfile"
      ]
    },
    {
      "page": "summary.profile",
      "title": "Override summary function",
      "topics": [
        "summary.profile"
      ]
    }
  ],
  "_readme": "https://github.com/avitaliano/datrprofile/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cachem",
    "cli",
    "cpp11",
    "DBI",
    "dplyr",
    "fastmap",
    "generics",
    "glue",
    "hms",
    "lifecycle",
    "magrittr",
    "memoise",
    "odbc",
    "pillar",
    "pkgconfig",
    "R6",
    "Rcpp",
    "rlang",
    "RSQLite",
    "tibble",
    "tidyselect",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_score": 2.6989700043360187,
  "_indexed": true,
  "_nocasepkg": "datrprofile",
  "_universes": [
    "avitaliano"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-09-24T08:31:23.000Z",
      "distro": "resolute",
      "commit": "4272a86165353b5de694ff02825e826e5fde89d3",
      "fileid": "https://r2.ropensci.org/c091833d952a68ac904491393ab4d6e0714771d4ac6149eadc3311280a504b36",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/avitaliano/actions/runs/35975228901"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.0",
      "date": "2026-09-24T08:31:31.000Z",
      "distro": "resolute",
      "commit": "4272a86165353b5de694ff02825e826e5fde89d3",
      "fileid": "https://r2.ropensci.org/7b19af704cd01a2085bc183abb0587fa9148786233298ded955f6e9abbb6f557",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/avitaliano/actions/runs/35975228901"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-09-24T08:31:49.000Z",
      "commit": "4272a86165353b5de694ff02825e826e5fde89d3",
      "fileid": "https://r2.ropensci.org/db4c8a8a968c9c228a4fbee9ab8a2c7d3c4f41957d1c092b7bc2031c130c17d1",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/avitaliano/actions/runs/35975228901"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1.0",
      "date": "2026-09-24T08:31:37.000Z",
      "commit": "4272a86165353b5de694ff02825e826e5fde89d3",
      "fileid": "https://r2.ropensci.org/793d2dfbf556326905f82d30c3a6e84545ac5f8c8eeeb05bc8b74bbed16e4c9b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/avitaliano/actions/runs/35975228901"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.0",
      "date": "2026-09-24T08:31:29.000Z",
      "commit": "4272a86165353b5de694ff02825e826e5fde89d3",
      "fileid": "https://r2.ropensci.org/81cf0573e94f17edc31697138d00370eed7c9d0f9e8cfd5de2386ce343f3af14",
      "status": "success",
      "buildurl": "https://github.com/r-universe/avitaliano/actions/runs/35975228901"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-09-24T08:30:26.000Z",
      "commit": "4272a86165353b5de694ff02825e826e5fde89d3",
      "fileid": "https://r2.ropensci.org/c1050f09c58c3ea35ff1edd59ee0fb75d097383f1701c674389b17bc7babf2d3",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/avitaliano/actions/runs/35975228901"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-09-24T08:30:24.000Z",
      "commit": "4272a86165353b5de694ff02825e826e5fde89d3",
      "fileid": "https://r2.ropensci.org/5675d00e93e9d5ebe4402ff2ccc7fdcf398abe75491a7f491d09faceaa003e8d",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/avitaliano/actions/runs/35975228901"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.0",
      "date": "2026-09-24T08:30:15.000Z",
      "commit": "4272a86165353b5de694ff02825e826e5fde89d3",
      "fileid": "https://r2.ropensci.org/a8381754ff82e18a563f846b3780057425af0e6a1189e5154929b24e5bc1a49c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/avitaliano/actions/runs/35975228901"
    }
  ]
}