Which department is this example from?

Other department, agency or public body not named above

Please provide a brief outline of the example

What document elements are included in your example?

Which coding languages were used in this example?

Has the output from your example been published?

Is the code available openly?

Please provide a web address for the code

Department for Education

Production of Official Statistics for the School Census

Plots, Interactive elements, Descriptive text, Open data

https://www.gov.uk/government/collections/statistics-pupil-absence

No, the repository is private

International Civil Service Effectiveness (InCiSE)

Tables, Plots, Interactive elements

https://www.bsg.ox.ac.uk/about/partnerships/international-civil-service-effectiveness-index and https://incise-project.github.io/incise-app/incise-app.html

No, the repository is private

https://incise-project.github.io/

Department for Work & Pensions

Analysis of data from annual People Survey

Plots, Interactive elements

Yes (please provide a link below)

https://github.com/ukgovdatascience/orgsurveyr

Department for Education

Secondary Analysis Internal and External

Tables, Plots, Interactive elements, Descriptive text

https://www.gov.uk/government/statistics/teachers-analysis-compendium-4

No, the repository is private

http://github.com/dfe-analytical-services

Department for International Development

Using RMarkdown to create a data analysis pipeline to take data from the database, manipulate it and model project complexity vs financial performance

Tables, Plots, Descriptive text

Department for Education

Exclusion statistics for pupils in England

https://www.gov.uk/government/statistics/permanent-and-fixed-period-exclusions-in-england-2016-to-2017

No, the repository is private

Other (please record in the box below)

Ofqual analytics - an interactive visualisation website

Tables, Plots, Interactive elements

Department for Digital, Culture, Media and Sport

Tables, Plots, Interactive elements, Descriptive text

Yes (please provide a link below)

https://www.github.com/dcmsstats

Yes (please provide a link below)

https://github.com/racedisparityaudit/rd_cms

Monthly publication of economic forecasts

Tables, Plots, Descriptive text

Department for Work & Pensions

Statistical bulletin on national insurance numbers with graphs, commentary and tables included. Bulletin in html. Formatting in HTML and CSS to replicate publication style. Numbers automated using Markdown text, as well as up/down observations

Tables, Plots, Descriptive text

Department for Environment, Food and Rural Affairs

Moving a Stats Release from Genstat and Excel fully into R

Tables, Plots, Descriptive text

Other (please record in the box below)

Office for National Statistics

bumblebee: a text mining functions / pipelines package

Yes (please provide a link below)

http://github.com/mamonu/bumblebee

Other (please record in the box below)

Local authority-specific health "at a glance" documents

Tables, Plots, Descriptive text

https://fingertips.phe.org.uk/static-reports/public-health-outcomes-framework/at-a-glance/e09000002.html

No, the repository is private

Other (please record in the box below)

Published R packages to help R community to develop RAPs

Yes (please provide a link below)

https://github.com/ropensci/fingertipsR

Department for Transport

https://www.gov.uk/government/statistics/search-and-rescue-helicopter-statistics-year-ending-march-2018

No, the repository is private

https://github.com/departmentfortransport/ames-sarh-rap

Department of Health & Social Care

Descriptive summary table of whole genome sequencing clusters of gastrointestinal pathogens - produced weekly and distributed in a formatted Microsoft Excel workbook to national and regional teams. The list has been incorporated into national and regional workflows for cluster assessments.

No, the repository is private

Other (please record in the box below)

Information Service Division, NHS Scotland

National Statistics Publication (Acute Hospital Activity & NHS Beds Information)

Tables, Plots, Interactive elements

https://www.isdscotland.org/Health-Topics/Hospital-Care/Publications/2018-12-18/Acute-Hospital-Publication/data-explorer/

Yes (please provide a link below)

https://github.com/Health-SocialCare-Scotland/Hospital-Acute-Activity/tree/master/Data-Explorer

Other (please record in the box below)

Information Services Division, NHS Scotland

National Statistics Publication - Psychiatric Inpatient Activity

Tables, Plots, Interactive elements

https://www.isdscotland.org/Health-Topics/Mental-Health/Publications/2018-09-25/psychiatric-inpatient-activity/data-explorer/

Yes (please provide a link below)

https://github.com/Health-SocialCare-Scotland/Psychiatric-Inpatient-Activity

HM Revenue & Customs

Annual Employment Allowance take-up National Statistics

Tables, Plots, Interactive elements, Descriptive text

https://kai-data-exploitation.github.io/ns-employment-allowance/empall_spine.html

Yes (please provide a link below)

https://github.com/KAI-Data-Exploitation/ns-employment-allowance

HM Revenue & Customs

Monthly UK Property Transaction Statistics (trial)

Tables, Plots, Interactive elements, Descriptive text

https://kai-data-exploitation.github.io/monthly-stamp-duty-ns-output/msdlt_spine.html

Yes (please provide a link below)

https://github.com/KAI-Data-Exploitation/monthly-stamp-duty-ns-output

Statistical tools to help analyse A/B tests of processed BigQuery user journey data.

Tables, Plots, Descriptive text

Yes (please provide a link below)

https://github.com/ukgovdatascience/govuk_ab_analysis

Other (please record in the box below)

NHS National Services Scotland

An R package to automate the entirety of the Quarterly Hospital Standardised Mortality Ratios (HSMR) national statistics publication

Tables, Plots, Descriptive text

https://www.isdscotland.org/Health-Topics/Quality-Indicators/HSMR/

Yes (please provide a link below)

https://github.com/NHS-NSS-transforming-publications/hsmr/tree/master/R

Other (please record in the box below)

NHS National Services Scotland

National Statistics Publication (Scottish Bowel Screening Programme)

Tables, Plots, Descriptive text

https://www.isdscotland.org/Health-Topics/Cancer/Publications/index.asp?#2463

No, the repository is private

R package calculates cost of reoffending

https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/814650/economic-social-costs-reoffending.pdf

No, the repository is private

https://moj-analytical-services.github.io/costs_of_reoffending/

Production of index of price changes for rail fares

No, the repository is private

Webscraping of Prices data from the Network Rail public website

Tables, Raw data to be analysed by economists

No, the repository is private

Extraction of Rail Station Information via an API from a URL

No, the repository is private

Our team deploys databases created from data extracted from other systems (databases, excel sheets, APIs, etc) and hosts them on our analytical platform for our analysts. Our databases allow users to query the data back in time (what my data looked like yday, last week, etc). We also create automated dashboards/reports that just report on the latest update, trends and anything that may flag as errors in the data.

Yes (please provide a link below)

https://github.com/moj-analytical-services

Automation of the RAF short term forecast and dashboard. Old method used a complex Excel workflow and simplistic output. New process to be built in R, with a Shiny dashboard as output and data properly hosted in an SQL database.

Tables, Plots, Interactive elements

Ministry of Housing, Communities & Local Government

Official Statistics: Rough sleeping snapshot in England

Tables, Plots, Interactive elements

https://www.gov.uk/government/statistics/rough-sleeping-snapshot-in-england-autumn-2019

No, the repository is private