X-Git-Url: https://git.njae.me.uk/?p=covid19.git;a=blobdiff_plain;f=uk_deaths_import.md;h=baa5ae6647cd89cafbd6388149c1e8920e9cf400;hp=612783c9d629b396cdf8d7372c009d0cd503b70f;hb=4104f54bfd2a8f5094704f1f78f8abf44dae0534;hpb=56d432e0c16154f702bafe32e42286784bf3c578

diff --git a/uk_deaths_import.md b/uk_deaths_import.md
index 612783c..baa5ae6 100644
--- a/uk_deaths_import.md
+++ b/uk_deaths_import.md
@@ -52,16 +52,20 @@ connection_string = 'postgresql://covid:3NbjJTkT63@localhost/covid'
 engine = create_engine(connection_string)
 ```
 
+```python
+!ls uk-deaths-data/publishedweek*2021*xlsx
+```
+
 ```python Collapsed="false"
-england_wales_filename = 'uk-deaths-data/publishedweek052021.xlsx'
+england_wales_filename = 'uk-deaths-data/publishedweek082021.xlsx'
 ```
 
 ```python Collapsed="false"
-scotland_filename = 'uk-deaths-data/Scottish Government COVID-19 data (15 February 2021).xlsx'
+scotland_filename = 'uk-deaths-data/Scottish Government COVID-19 data (10 March 2021).xlsx'
 ```
 
 ```python
-n_ireland_filename = 'uk-deaths-data/Weekly_Deaths_0.xlsx'
+n_ireland_filename = 'uk-deaths-data/Weekly_Deaths.xlsx'
 ```
 
 ```python Collapsed="false"
@@ -136,7 +140,7 @@ rd.to_sql(
 ```
 
 ```python
-%sql select * from all_causes_deaths where year = 2021 limit 10
+%sql select * from all_causes_deaths where year = 2021 order by date_up_to desc limit 10
 ```
 
 ```python