- Academic
- AdaptiveDB
- Admin
- All
- Bailey
- CanMys
- Cascade
- CGtW
- ColDesp
- Depts
- DHSI
- FrancoToile
- HOPOL
- HumsSites
- IMT
- Lansdowne
- LondonMap
- Maint
- Mariage
- MoM
- Moses
- MyNDIR
- Pro-D
- Projects
- Properties
- RenMedics
- ScanCan
- Times-Col
- Transformer
- Vac/Hours
- Vesalius
- viHistory
delete unwanted entries created by Importer
16/01/12
delete unwanted entries created by Importer
In testing my modifications to the importer code, I created records which I had to delete. The importer typically adds records to these tables:
criminals
outcomes
respites
trials
crimes
trial_files
and may add records to these tables:
aliases
judge_respites
outcome_durations
execution_specials
mercy_appeals
When deleting spurious test records, to avoid foreign-key violation errors, I started with these tables:
crimes
trial_files
criminals
Pingbacks:
No Pingbacks for this post yet...
Capital Trials at the Old Bailey
Simon Devereaux has approximately 10,000 records of people convicted in potentially capital cases between 1710 and 1840 in London heard at the Old Bailey court. This project will create a web-based database which will allow interested researchers and members of the public to compose queries on that data (e.g. women charged with robbery 1710-1720). It must be able to support a range of queries and produce output allowing researchers to identify trends in judicial practice over that time.
Actions
Reports
Categories
- All
- Activity Log (93)
- Announcements (1)
- Notes (24)
- Tasks (6)
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| << < | > >> | |||||
| 1 | 2 | 3 | 4 | |||
| 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 26 | 27 | 28 | 29 | 30 | 31 | |
XML Feeds