{
  "_id": "6af6e7ebf58eaab79920d1b8",
  "Package": "drillingdata",
  "Title": "Borehole Drilling and Construction Data – Malawi, 2018 - 2024",
  "Version": "1.0.1",
  "Authors@R": "c(\nperson(\"Emmanuel\", \"Mhango\", , \"emmanuellmhango@gmail.com\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0003-3197-6244\")),\nperson(\"Jamie\", \"Rattray\", role = \"aut\"),\nperson(\"Shaun\", \"MacLeod\", role = \"aut\"),\nperson(\"Feston\", \"Bwanyula\", role = \"aut\")\n)",
  "Description": "This dataset captures detailed information on borehole\ndrilling and construction activities conducted across selected\nsites in Malawi in 2018. Data were collected using the mWater\ndigital platform, documenting each stage of groundwater\ndevelopment, from site selection and hydrogeological studies to\ndrilling operations, borehole design, and post-construction\nassessments.",
  "License": "CC BY 4.0",
  "Encoding": "UTF-8",
  "Roxygen": "list(markdown = TRUE)",
  "LazyData": "true",
  "Language": "en-GB",
  "Config/Needs/website": "rmarkdown, brand.yml",
  "Date": "2026-09-18",
  "URL": "https://github.com/openwashdata/drillingdata",
  "BugReports": "https://github.com/openwashdata/drillingdata/issues",
  "Config/roxygen2/version": "8.0.0",
  "Config/washr/funding": "This project was funded by the [Open Research\nData Program of the ETH\nBoard](https://ethrat.ch/en/eth-domain/open-research-data/).",
  "Config/washr/analytics-domain": "openwashdata.github.io",
  "Config/washr/doi-provider": "zenodo",
  "Config/washr/zenodo-community": "openwashdata",
  "Config/washr/brand-source": "openwashdata/brand",
  "Config/washr/publisher": "Published by\n[openwashdata](https://openwashdata.org), a project of [Global\nHealth Engineering](https://ghe.ethz.ch/) at ETH Zurich.",
  "Config/washr/home": "https://openwashdata.org",
  "Config/washr/catalog": "https://openwashdata.org/pages/gallery/data/",
  "Config/washr/community": "This package is part of\n[openwashdata](https://openwashdata.org). Browse the [data\ncatalogue](https://openwashdata.org/pages/gallery/data/) or get\nthe [newsletter](https://openwashdata.org/pages/newsletter/).",
  "Config/washr/version": "1.2.2",
  "Config/washr/brand": "v1.1.0",
  "Repository": "https://openwashdata.r-universe.dev",
  "Date/Publication": "2026-11-01 08:36:11 UTC",
  "RemoteUrl": "https://github.com/openwashdata/drillingdata",
  "RemoteRef": "HEAD",
  "RemoteSha": "a67fa968f31a56e071183ae39dce1fe71b0c1f4e",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-11-13 10:01:22 UTC",
    "User": "root"
  },
  "Author": "Emmanuel Mhango [aut, cre] (ORCID:\n<https://orcid.org/0000-0003-3197-6244>),\nJamie Rattray [aut],\nShaun MacLeod [aut],\nFeston Bwanyula [aut]",
  "Maintainer": "Emmanuel Mhango <emmanuellmhango@gmail.com>",
  "_user": "openwashdata",
  "_type": "src",
  "_file": "drillingdata_1.0.1.tar.gz",
  "_fileid": "https://r2.ropensci.org/3e1b570d674582be62909e862082ebc0fcdec56176eeed914d9ef5230c4ea565",
  "_filesize": 356725,
  "_sha256": "3e1b570d674582be62909e862082ebc0fcdec56176eeed914d9ef5230c4ea565",
  "_expires": "2027-02-21T10:35:22.000Z",
  "_created": "2026-11-13T10:01:22.000Z",
  "_published": "2026-11-13T10:35:23.985Z",
  "_upstream": "https://github.com/openwashdata/drillingdata",
  "_status": "success",
  "_maintainer": {
    "name": "Emmanuel Mhango",
    "email": "emmanuellmhango@gmail.com",
    "login": "emmanuellmhango",
    "linkedin": "in/emmanuellmhango",
    "orcid": "0000-0003-3197-6244",
    "description": "Building Generative AI-powered digital public infrastructure for Health, WASH & Open Data | Data Steward @ BASEflow | Power BI Certified",
    "uuid": 40168702
  },
  "_jobs": [
    {
      "job": 131820098653,
      "time": 88,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "14027925500"
    },
    {
      "job": 131820098739,
      "time": 82,
      "config": "linux-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14027301924"
    },
    {
      "job": 131820098791,
      "time": 92,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "14029675857"
    },
    {
      "job": 131820098689,
      "time": 99,
      "config": "macos-release-arm64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14028219547"
    },
    {
      "job": 131819143522,
      "time": 130,
      "config": "source",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14027511223"
    },
    {
      "job": 131820098697,
      "time": 70,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "14026832876"
    },
    {
      "job": 131820098872,
      "time": 131,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "14026684180"
    },
    {
      "job": 131820098775,
      "time": 158,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "14028055210"
    },
    {
      "job": 131820098788,
      "time": 134,
      "config": "windows-release-x86_64",
      "r": "4.6.2",
      "check": "OK",
      "artifact": "14027401531"
    }
  ],
  "_buildurl": "https://github.com/r-universe/openwashdata/actions/runs/43405582034",
  "_commit": {
    "id": "a67fa968f31a56e071183ae39dce1fe71b0c1f4e",
    "author": "larnsce <lars@lse.de>",
    "committer": "larnsce <lars@lse.de>",
    "message": "chore: the brand logo and the publisher line, washr 1.2.2\n\nThe openwashdata logo in the package logo slot of the site and at the\ntitle of the README, the publisher named under Citation with the website\nwritten out, the brand installed for the site (openwashdata/washr#148),\nand the footer naming washr 1.2.2. Date is kept as it was.\n\nAssisted-by: Claude claude-fable-5-1\nClaude-Session: https://claude.ai/code/session_0154SimKL2w6hTuq4FaTKNCK\n",
    "time": 1793522171
  },
  "_distro": "resolute",
  "_host": "GitHub-Actions",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.5",
      "role": "Depends"
    }
  ],
  "_owner": "openwashdata",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-39",
      "n": 1
    },
    {
      "week": "2026-44",
      "n": 2
    }
  ],
  "_tags": [
    {
      "name": "v1.0.1",
      "date": "2026-09-23"
    }
  ],
  "_topics": [
    "open data",
    "washdata",
    "boreholes",
    "drilling",
    "groundwater",
    "water supply",
    "malawi",
    "borehole",
    "sanitation",
    "wash"
  ],
  "_stars": 0,
  "_contributors": [
    {
      "user": "emmanuellmhango",
      "count": 18,
      "uuid": 40168702
    },
    {
      "user": "larnsce",
      "count": 9,
      "uuid": 18212549
    }
  ],
  "_userbio": {
    "uuid": 103032459,
    "type": "organization",
    "name": "openwashdata",
    "followers": 18
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/drillingdata"
  },
  "_devurl": "https://github.com/openwashdata/drillingdata",
  "_searchresults": 2,
  "_rbuild": "4.6.2",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/drillingdata.html",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md"
  ],
  "_cranurl": false,
  "_exports": [],
  "_datasets": [
    {
      "name": "drillingdata",
      "title": "Borehole Drilling and Construction Data – Malawi, 2018 - 2024",
      "object": "drillingdata",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "date_of_drilling",
        "water_point_created",
        "latitude",
        "longtude",
        "use_of_waterpoint",
        "other_useage",
        "funding_source",
        "wrb1a_form_completed",
        "contract_signed",
        "community_agreement",
        "gov_supervisor_available",
        "drilling_contractor",
        "driller_licensed",
        "staff_experienced",
        "drilling_rig_model",
        "compressor_specs",
        "equipment_condition",
        "safety_features_condition",
        "equipment_capability",
        "equipment_capability_specs",
        "ppe_available",
        "drilling_equipment_image",
        "location_selection_methodology",
        "hydrogeological_study_done",
        "geophysical_survey_done",
        "min_distance_50m_from_contamination",
        "distance_from_contamination",
        "location_accessible",
        "location_suitable_for_drilling",
        "distance_from_water_bodies",
        "location_photo",
        "perimeter_fence",
        "staff_protected",
        "parking_area",
        "emergency_access",
        "suitable_distance_from_power_lines",
        "distance",
        "materials_stored_safely",
        "chemicals_stored_safely",
        "first_aid_kit",
        "fire_extinguisher",
        "adquate_welfare_facilities",
        "welfare_facilities_distance",
        "site_setup_preliminaries_completed",
        "rig_setup_properly",
        "reference_point",
        "reference_point_height",
        "rig_level_method",
        "rig_setup_problems",
        "setup_problems",
        "drill_rod_length",
        "min_diameter_177mm",
        "min_diameter",
        "casing_stored_properly",
        "where_stored",
        "why_not_properly_stored",
        "index_1",
        "rod_number",
        "depth_from_1",
        "depth_to_1",
        "circulation_method",
        "drill_bit_type",
        "drilling_diameter_mm",
        "time_taken_in_minutes",
        "drilling_comments",
        "water_strike_in_miters",
        "index_2",
        "depth_from_2",
        "depth_to_2",
        "temp_casing_material",
        "temp_casing_diameter",
        "index_3",
        "depth_from_3",
        "depth_to_3",
        "rock_or_soil_type",
        "colour",
        "weathering",
        "grain_size_description",
        "sorting",
        "additional_description",
        "formation_name",
        "index_4",
        "hole_depth_1",
        "discharge_rate_1",
        "discharge_measurement_method",
        "ec_ms_cm_1",
        "tds_mgl_1",
        "ph_1",
        "temp_celcius_1",
        "comments_1",
        "borehole_depth_miters",
        "water_level",
        "measurement_date",
        "borehole_suitable_further_use",
        "installation_design_available",
        "design_agreed_by_driller",
        "date_casing_installation",
        "materials_meet_standards",
        "materials_pre_inspected",
        "Index (8)",
        "inner_diameter",
        "outer_diameter",
        "material_1",
        "slot_aperture",
        "end_cap_fitted",
        "centralisers_fitted",
        "casing_connection_type",
        "index_9",
        "depth_from_4",
        "depth_to_4",
        "casing_inner_diameter",
        "casing_material",
        "casing_material_strength",
        "slotted",
        "gravel_pack_clean",
        "gravel_pack_quality",
        "index_10",
        "depth_from_5",
        "depth_to_5",
        "gravel_min_grain_size",
        "gravel_max_grain_size",
        "gravel_pack_final_level",
        "static_water_level_pre_dev",
        "index_11",
        "duration",
        "method",
        "index_12",
        "time",
        "lift_depth",
        "discharge_rate",
        "ec_ms_cm_3",
        "tds_mg_l_2",
        "ph_3",
        "temp_c_2",
        "turbidity_ntu",
        "sediment",
        "static_water_level_post_dev",
        "final_borehole_design_summary"
      ],
      "rows": 152,
      "table": true,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "drillingdata",
      "title": "Borehole Drilling and Construction Data – Malawi, 2018 - 2024",
      "topics": [
        "drillingdata"
      ]
    }
  ],
  "_pkglogo": "https://raw.githubusercontent.com/openwashdata/brand/v1.1.0/assets/social-preview.png",
  "_readme": "https://github.com/openwashdata/drillingdata/raw/HEAD/README.md",
  "_rundeps": [],
  "_score": 2,
  "_indexed": true,
  "_nocasepkg": "drillingdata",
  "_universes": [
    "openwashdata",
    "emmanuellmhango"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "1.0.1",
      "date": "2026-11-13T10:02:55.000Z",
      "distro": "resolute",
      "commit": "a67fa968f31a56e071183ae39dce1fe71b0c1f4e",
      "fileid": "https://r2.ropensci.org/cf5d44b8342a86d2e62e23b3e74027c5b99623fb65f9872c6ef074ddcfbbba30",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/openwashdata/actions/runs/43405582034"
    },
    {
      "r": "4.6.2",
      "os": "linux",
      "version": "1.0.1",
      "date": "2026-11-13T10:02:50.000Z",
      "distro": "resolute",
      "commit": "a67fa968f31a56e071183ae39dce1fe71b0c1f4e",
      "fileid": "https://r2.ropensci.org/e9e3a83fd8837996c0d3efa042ece59475ab886cc548d465698a9eae385e2291",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/openwashdata/actions/runs/43405582034"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "1.0.1",
      "date": "2026-11-13T10:34:57.000Z",
      "commit": "a67fa968f31a56e071183ae39dce1fe71b0c1f4e",
      "fileid": "https://r2.ropensci.org/0f8e7adbf9d4512d199e44dd1f9d76e58c28d61f1a6cdbbd0e2c70a11ff4a51e",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/openwashdata/actions/runs/43405582034"
    },
    {
      "r": "4.6.2",
      "os": "mac",
      "version": "1.0.1",
      "date": "2026-11-13T10:31:06.000Z",
      "commit": "a67fa968f31a56e071183ae39dce1fe71b0c1f4e",
      "fileid": "https://r2.ropensci.org/a76009a647bd551b667fe48f60a469d19645c951d82880870a3cc0accda34712",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/openwashdata/actions/runs/43405582034"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "1.0.1",
      "date": "2026-11-13T10:02:47.000Z",
      "commit": "a67fa968f31a56e071183ae39dce1fe71b0c1f4e",
      "fileid": "https://r2.ropensci.org/59e586c9702733c300f1da6ab17fdbb01163eb26d6a98d492d954d64edcfec7b",
      "status": "success",
      "buildurl": "https://github.com/r-universe/openwashdata/actions/runs/43405582034"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "1.0.1",
      "date": "2026-11-13T10:03:02.000Z",
      "commit": "a67fa968f31a56e071183ae39dce1fe71b0c1f4e",
      "fileid": "https://r2.ropensci.org/eacbf9d141f98a8e372e2f96a81208c4c531a3eea06f5da60e240518659ab7dc",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/openwashdata/actions/runs/43405582034"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "1.0.1",
      "date": "2026-11-13T10:03:13.000Z",
      "commit": "a67fa968f31a56e071183ae39dce1fe71b0c1f4e",
      "fileid": "https://r2.ropensci.org/383836f2f1f69103cab7cba43ce39e6031551bcdddc6f6022e51160c37de5d15",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/openwashdata/actions/runs/43405582034"
    },
    {
      "r": "4.6.2",
      "os": "win",
      "version": "1.0.1",
      "date": "2026-11-13T10:03:04.000Z",
      "commit": "a67fa968f31a56e071183ae39dce1fe71b0c1f4e",
      "fileid": "https://r2.ropensci.org/3e7ccad4e4e209a39dab31f81f1ee3cfc8fad1c68749f1004b11c41584cdfd05",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/openwashdata/actions/runs/43405582034"
    }
  ]
}