projects
/
covid19.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Small updates
[covid19.git]
/
uk_deaths_import.md
diff --git
a/uk_deaths_import.md
b/uk_deaths_import.md
index 612783c9d629b396cdf8d7372c009d0cd503b70f..baa5ae6647cd89cafbd6388149c1e8920e9cf400 100644
(file)
--- 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)
```
engine = create_engine(connection_string)
```
+```python
+!ls uk-deaths-data/publishedweek*2021*xlsx
+```
+
```python Collapsed="false"
```python Collapsed="false"
-england_wales_filename = 'uk-deaths-data/publishedweek0
5
2021.xlsx'
+england_wales_filename = 'uk-deaths-data/publishedweek0
8
2021.xlsx'
```
```python Collapsed="false"
```
```python Collapsed="false"
-scotland_filename = 'uk-deaths-data/Scottish Government COVID-19 data (1
5 February
2021).xlsx'
+scotland_filename = 'uk-deaths-data/Scottish Government COVID-19 data (1
0 March
2021).xlsx'
```
```python
```
```python
-n_ireland_filename = 'uk-deaths-data/Weekly_Deaths
_0
.xlsx'
+n_ireland_filename = 'uk-deaths-data/Weekly_Deaths.xlsx'
```
```python Collapsed="false"
```
```python Collapsed="false"
@@
-136,7
+140,7
@@
rd.to_sql(
```
```python
```
```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
```
```python