New database structure admin: Difference between revisions
(Created page with "The following pages have been added to the new database structure - what improvements could be made? <div class="row"> <div class="large-4 columns"> ==Cases== {{#cargo_query:...") |
m (Jonathan moved page New database structure 2019 to New database structure admin) |
||
(12 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
The following pages have been added to the new database structure | ==Progress== | ||
{|class="wikitable" | |||
!What !! Done !! Still to do !! Comments | |||
|- | |||
! Cases | |||
| {{Count pages in database table|Cases}} | |||
| {{Count pages in category|category=Transcript¦No transcript|notcategory=Cases}} | |||
| Total is {{Count pages in category|category=Transcript¦No transcript¦Cases}}. Use [[Mental health case law admin]] to add new cases. | |||
|- | |||
! Resources | |||
| {{Count pages in database table|Resources}} | |||
| ? | |||
| The database includes [[Books]] and [[Consultations]]. Impossible to know how many items are still to go, as most were just external links on pages. | |||
|- | |||
! Legislation | |||
| {{Count pages in database table|Legislation}} | |||
| {{Count pages in category|category=Mental Health Act 2007 commencement orders¦Mental Health Act 2007 secondary legislation - England¦Mental Health Act 2007 secondary legislation - England and Wales¦Mental Health Act 2007 secondary legislation - Scotland¦Mental Health Act 2007 secondary legislation - Wales¦Legislation amending MHA 1983¦Mental Health Regulations¦Tribunal legislation¦Tribunal resources¦Mental Capacity Act 2005 commencement orders¦Mental Capacity Act 2005 secondary legislation - DOLS¦Mental Capacity Act 2005 secondary legislation - IMCA¦Mental Capacity Act 2005 secondary legislation - Other¦Mental Capacity Act 2005 secondary legislation - Public Guardian and Court of Protection¦Mental Capacity Act 2005 secondary legislation - Research¦Legal Aid legislation¦Other useful legislation¦Miscellaneous legislation|notcategory=Legislation}} | |||
| Use [[Legislation to add to new database structure]] to add new legislation. | |||
|- | |||
! Information | |||
| {{Count pages in category|category=Coronavirus¦CPD¦General information pages¦Legal Aid¦Nearest relative¦Legal Aid archive¦Legal Aid eligibility¦Main types of funding ¦Changing the nearest relative¦Nearest relative powers¦Northern Ireland¦Scotland ¦Southern Ireland¦Wales¦Statistics ¦The Law Society}} | |||
| {{Count pages in category|category=Changes made by MHA 2007¦Mental Capacity Act 2005 provisions ¦Miscellaneous articles ¦Organisations ¦Other resources ¦Routes to discharge ¦Types of detention ¦Types of discharge ¦Types of patient}} | |||
| The new information pages are better structured, but are ''not'' in the database. | |||
|- | |||
! Jobs | |||
| {{Count pages in database table|Jobs}} | |||
| 0 | |||
| | |||
|- | |||
! Events | |||
| {{Count pages in database table|Events}} | |||
| 0 | |||
| | |||
|- | |||
! Contacts | |||
| {{Count pages in database table|Contact}} | |||
| 0 | |||
| | |||
|} | |||
==Database== | |||
The following pages have been added to the new database structure. | |||
<div class="row"> | <div class="row"> | ||
<div class="large-4 columns"> | <div class="large-4 columns"> | ||
{{database header|CASES}} | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=Cases | tables=Cases | ||
|format=ul | |format=ul | ||
|limit=20 | |||
}} | }} | ||
</div> | </div> | ||
<div class="large-4 columns"> | <div class="large-4 columns"> | ||
{{database header|LEGISLATION}} | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=Legislation | tables=Legislation | ||
|format=ul | |format=ul | ||
|limit=20 | |||
}} | }} | ||
</div> | </div> | ||
<div class="large-4 columns"> | <div class="large-4 columns"> | ||
{{database header|RESOURCES}} | |||
{{#cargo_query: | {{#cargo_query: | ||
tables= | tables=Resources | ||
|format=ul | |format=ul | ||
|limit=20 | |||
}} | }} | ||
</div> | </div> |
Latest revision as of 13:11, 13 November 2020
Progress
What | Done | Still to do | Comments |
---|---|---|---|
Cases | 843 | 1,649 | Total is 2,487. Use Mental health case law admin to add new cases. |
Resources | 1,140 | ? | The database includes Books and Consultations. Impossible to know how many items are still to go, as most were just external links on pages. |
Legislation | 393 | 345 | Use Legislation to add to new database structure to add new legislation. |
Information | 98 | 94 | The new information pages are better structured, but are not in the database. |
Jobs | 92 | 0 | |
Events | 522 | 0 | |
Contacts | 329 | 0 |
Database
The following pages have been added to the new database structure.
- A Borough Council v E [2021] EWHC 183 (Fam)
- A CCG v AD [2021] EWCOP 47
- A CCG v DC [2022] EWCOP 2
- A CCG v DC [2022] EWCOP 20
- A City Council v LS [2019] EWHC 1384 (Fam)
- A Clinical Commissioning Group v FZ [2022] EWCOP 21
- A Clinical Commissioning Group v P [2019] EWCOP 18
- A County Council v A [2022] EWHC 3572 (Fam)
- A Healthcare and B NHS Trust v CC [2020] EWHC 574 (Fam)
- A Hospital NHS Foundation Trust v KL [2023] EWCOP 59
- A Local Authority v A [2020] EWCOP 76
- A Local Authority v AT and FE [2017] EWHC 2458 (Fam)
- A Local Authority v B [2020] EWHC 2741 (Fam)
- A Local Authority v BF [2018] EWCA Civ 2962
- A Local Authority v C [2021] EWCOP 25
- A Local Authority v C [2021] EWCOP 26
- A Local Authority v H [2023] EWCOP 4
- A Local Authority v JB [2019] EWCOP 39
- A Local Authority v JB [2020] EWCA Civ 735
- A Local Authority v JB [2021] UKSC 52
- Access to Health Records Act 1990
- Access to Justice Act 1999
- Access to Justice Act 1999 (Destination of Appeals) Order 2000
- Act of Sederunt (Transfer of Judicial Review Applications from the Court of Session) 2008
- Administration of Justice Act 1960
- Administration of Justice Act 1969
- Adoption and Children Act 2002
- Adult Support and Protection (Scotland) Act 2007
- Adults with Incapacity (Scotland) Act 2000
- Anti-social Behaviour, Crime and Policing Act 2014
- Anti-Terrorism, Crime and Security Act 2001
- Appeals from the Upper Tribunal to the Court of Appeal Order 2008
- Arbitration Act 1996
- Armed Forces Act 1996
- Armed Forces Act 2006
- Assaults on Emergency Workers (Offences) Act 2018
- Assaults on Emergency Workers (Offences) Act 2018
- Care Act 2014
- Care Act 2014 and Children and Families Act 2014 (Consequential Amendments) Order 2015
- Care and Support (Disputes between Local Authorities) Regulations 2014
- [2017] IJMHCL pages 84-149
- [2018] IJMHCL pages 1-77
- 1 Crown Office Row, 'Alasdair Henderson secures award of damages for false imprisonment in a hospital setting' (30/1/19)
- 39 Essex Chambers, 'Best interests proceedings - an update' (April 2010)
- 39 Essex Chambers, 'MCA update - all the capacity news that’s fit to print for July 2021' (23/7/21)
- 39 Essex Chambers, 'MCA update - all the capacity news that’s fit to print for July 2021' (23/7/21)
- 39 Essex Chambers, 'Mental Capacity Case Reports' (issue 1, April 2023)
- 39 Essex Chambers, 'Mental Capacity Case Reports' (issue 2, July 2023)
- 39 Essex Chambers, 'Mental Capacity Case Reports' (issue 3, October 2023)
- 39 Essex Chambers, 'Mental Capacity Law Newsletter' (issue 41, January 2014)
- 39 Essex Chambers, 'Mental Capacity Law Newsletter' (issue 42, February 2014)
- 39 Essex Chambers, 'Mental Capacity Law Newsletter' (issue 43, March 2014)
- 39 Essex Chambers, 'Mental Capacity Law Newsletter' (issue 45, April 2014)
- 39 Essex Chambers, 'Mental Capacity Law Newsletter' (issue 46, May 2014)
- 39 Essex Chambers, 'Mental Capacity Law Newsletter' (issue 47, June 2014)
- 39 Essex Chambers, 'Mental Capacity Law Newsletter' (issue 48, July 2014)
- 39 Essex Chambers, 'Mental Capacity Law Newsletter' (issue 49, August 2014)
- 39 Essex Chambers, 'Mental Capacity Law Newsletter' (issue 50, October 2014)
- 39 Essex Chambers, 'Mental Capacity Law Newsletter' (issue 51, November 2014)
- 39 Essex Chambers, 'Mental Capacity Law Newsletter' (issue 52, December 2014)