gravatar

davehawkins

David Hawkins

Recently Published

BRWA
© National Grid & NPG
© National Grid & NPG
Dorset EHV/HV
Misallocated Sites
Kemble
ONS TABLE 8 data England: deaths occurring between 1 January 2021 and 31 January 2022
ONS all cause deaths published 16-March-2022 at https://www.ons.gov.uk/file?uri=%2fpeoplepopulationandcommunity%2fbirthsdeathsandmarriages%2fdeaths%2fdatasets%2fdeathsbyvaccinationstatusengland%2fdeathsoccurringbetween1january2021and31january2022/referencetable20220316accessible.xlsx
ONS data England: deaths occurring between 1 January 2021 and 31 January 2022
Published by ONS on 16-March-2022 https://www.ons.gov.uk/file?uri=%2fpeoplepopulationandcommunity%2fbirthsdeathsandmarriages%2fdeaths%2fdatasets%2fdeathsbyvaccinationstatusengland%2fdeathsoccurringbetween1january2021and31january2022/referencetable20220316accessible.xlsx
SoA #cases and 3V%
LTLA Pearson V2
Pearson LTLA
Medway Jabs
jabs ROT
Tidier still
ONS T5 deaths by status / age
map trial
West Mids - new cases by age
London case rates by age
WPD open data plus NG
WPD plus NG open data
WPD and NG open data
WPD open data plus NG
Cases, Admissions & Deaths
Admissions are not age-related (curve is the same on each graph)
Gov data DEATHS by AGE
Gov data
Cases & deaths by age
England - Hospitalisations by age
From https://api.coronavirus.data.gov.uk/v2/data?areaType=nhsRegion&metric=cumAdmissionsByAge&format=csv
ONS Vaccination Populations
Table 4 https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/datasets/deathsbyvaccinationstatusengland
ONS ASMR by each Vaccine status, by age
Table 4 https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/datasets/deathsbyvaccinationstatusengland
ONS Deaths by vaccination status
Table 4 https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/datasets/deathsbyvaccinationstatusengland
ONS ASMR
Table 4 data - https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/datasets/deathsbyvaccinationstatusengland
ONS Table 4 number of deaths
Osney ALL
Osney ALL
Oxford HV
England Hospitalisation data
NHS Hospitalisations by age
Sankey #1
E hospitalisations by age
Not a pandemic?
Country Generation
JPN Generation #2
JPN Generation
Hospitalisations by Age
ASMR delta
ASMR delta
England hospitalisations
Hospital Admissions - gov.uk
hospital Admissions - gov.uk
hospital Admissions - gov.uk
Hospital Admissions - gov.uk
Hospital Admissions - gov.uk
hospital Admissions - gov.uk
hospital Admissions - gov.uk
hospital Admissions - gov.uk
hospital Admissions - gov.uk
hospital Admissions - gov.uk
hospital Admissions - gov.uk
Hospital Admissions - gov.uk
MV beds occupied per Test
BwD Cases by age
New deaths - England regions
log Hospital Admissions
New admissions - Hospitals
from gov.uk
Hospital Admissions - gov.uk
ONS Variants to 2-June TRENDS
ONS Variant Fig 12 to 19-May
ONS Variant Fig 12 to 19-May
"Weekly number of common exposure events among sequenced cases, by setting and variant of cases (bars), and proportion of weekly common exposure events among sequenced cases associated with Delta" Limited to data before 20-May-2021
ONS Fig.12
"Figure 12. Weekly number of common exposure events among sequenced cases, by setting and variant of cases (bars), and proportion of weekly common exposure events among sequenced cases associated with Delta" I haven't (yet) added a geom_smooth for Delta
HTML
OWID graphs
.gov New Admissions
Vaccine progress
log deaths
more PV
solarPV
solarPV
Chancellors AHU
AHU 1
NHS region cases
NHS region New Cases
LTLA chart #5
Corby
More zeros
Frequency plot @ 18
MGC sub-second
two plots
Rel Humidity
BoJo #3
BoJo #2
BoJo threshold
Synth Data
ASMR DELTA
join the dots
A lot of numbers
Volts
Crude Mortality Forecast
Future ASMR
I see the future
ONS deaths each year
ONS ASMR line
ONS ASMR
ONS Mortality Rates
ONS-01
ONS-15
ONS-45
ONS-75
ONS-85
CPUC 115kV and <110kV ccts
yet more volts
some voltages
Facets of CV
NV vs O
Volts
some Voltages
meter reading samples
map trial
Second Wave?
Data from EU
Two waves - EU/NHS data
NHS hospital admissions
ONS Death Data 2010-2020
Case data by age
South West Hospitals
SE Hospitals
NE & Y Hospitals
Midlands Hospitals
EE Hospitals
London Hosp
NHS 5x things
ONS RESPIRATORY DEATHS 2010-2020 (inc CV19)
Source: https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/datasets/weeklyprovisionalfiguresondeathsregisteredinenglandandwales
ONS RESPIRATORY DEATHS 2010-2020 (inc CV19)
Source: https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/deaths/datasets/weeklyprovisionalfiguresondeathsregisteredinenglandandwales
1-second Site Demand
1-second POC
1-second SOLAR
1-second wind
1-second demand
NHS EU data
NHS data to 13-Oct
Reduced dataset
Full dataset
some kWh points
Some Voltages
NHS 5x things
EU/NHS data 1-Mar to 9-Oct
NHS data to 8-Oct
some numbers
NHS data 7-Oct
2.6MW export limit
kW Perturbations
Site total demand ~ 8-17 MW
More NHS data
GBR data from EU
UK GOV data
Germany New Wave
FRA New Wave
with trend lines & 95% CI
EU data since 1-Sep
Lagged EU Data
I brought forward death dates by 6 days-- A WORK IN PROGRESS!
EU Deaths Data to 23-Sep
What Spike?
NHS data from https://api.coronavirus.data.gov.uk
NHS P1, P2 data
NHS Data
NHS P1, P2, new Admissions
NHS data from their API
Rough Prophet curve
WARNING: experimental software!
OWID Death Rate
OWID Positive Test Rate
Our World In Data https://ourworldindata.org/coronavirus/
3D
Facebook CV19 data
Unverified!
Grid Export kWh
NHS data 3-Sep
Source: https://www.england.nhs.uk/statistics/wp-content/uploads/sites/2/2020/09/Covid-Publication-10-09-2020.xlsx
ONS Death Data 2015-2020
Unverified data!
ONS death Data 2015-2020
Unverified data! Treat with caution
late-Aug volts
Volts
Frequency Measurements
Scatterplot #2
New deaths are 'lagged' by 21 days because that is the typical duration from test-positive to death CAUTION: unverified data
Map1
map1
DarwinPV
some Vbr substation voltages
SS13 volts
some 33kV OHL
ENW generation
Map of assets
some frequency data
Non-zero LTLAs trend
Non-zero LTLAs cumplot
Typical primary s/s load - region with mains gas
X-axis = Day of year (1 - 365) Y-axis = Hour of day (0 - 24) Z-axis = Demand (11kV amps) - divide by 52.5 for MW
Typical primary s/s load - region without mains gas
X-axis = Day of year (1 - 365) Y-axis = Hour of day (0 - 24) Z-axis = Demand (11kV amps) - divide by 52.5 for MW
ridge plot yellow Volts
Site P2 Volts
Site Phase 2 Volts
UKPN ss11 errors
UKPN 11kV ss latitude errors
UKPN 11kV SS longitude errors
UKPN 33 & 132
HTML
Dec-2017 Hz
20-June-2019
Hz 30-Mar-2019
9-May-2019
Apr-Aug 2019
9Aug
HTML
temps
POSTCODES with LV
Assets and postcodes
Quick and dirty first view
Sampler Dataview
Stoke EHV assets
Stoke 33kV assets
Grid square cable summary
Monday Nights Locations
Plot
Plot of 33kV overhead line GIS data where conductor size is colour-coded. Similar approach could be taken with a complex conductor attribute to reflect losses on each circuit, and at each voltage level. Results can also be summarised in tables where GIS interface is sub-optimal
BEIS FiT database 2016 Technology Timeline
Finally got Googlevis working in R
BEIS FiT database 2016
BEIS FiT database 2016
Clustered summary of number of installations on each postcode (outbound postcode only)
BEIS FiT database 2016
BEIS Feed In Tariff Data 2016
Extracted from BEIS Feed In Tariff .csv files