names

18 rows where place_id = 611527

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3688767 1922648 1922648 defendant Parker Edmund yeoman 611527 611527 Parker, Edmund, of Hornchurch, yeoman 3
3688768 1922648 1922648 defendant Gyttyn Griffin clerk 611527 611527 Gyttyn, Griffin, of Hornchurch, clerk 4
3688769 1922648 1922648 defendant Bussh William husbandman 611527 611527 Bussh, William, of Hornchurch, husbandman 5
3688770 1922648 1922648 defendant Turke Thomas laborer 611527 611527 Turke, Thomas, of Hornchurch, laborer 6
3688771 1922648 1922648 defendant Borne John yeoman 611527 611527 Borne, John, of Hornchurch, yeoman 7
3688783 1922649 1922649 defendant Parker Edmund yeoman 611527 611527 Parker, Edmund, of Hornchurch, yeoman 3
3688784 1922649 1922649 defendant Gyttyn Griffin clerk 611527 611527 Gyttyn, Griffin, of Hornchurch, clerk 4
3688785 1922649 1922649 defendant Bussh William husbandman 611527 611527 Bussh, William, of Hornchurch, husbandman 5
3688786 1922649 1922649 defendant Turke Thomas laborer 611527 611527 Turke, Thomas, of Hornchurch, laborer 6
4757007 2282562 2282562 defendant Bocher Alan butcher 611527 611527 Bocher, Alan, of Hornchurch, butcher 0
5175274 2408460 2408460 defendant Stace Richard yeoman 611527 611527 Stace, Richard, of Hornchurch, yeoman 2
5208695 2418266 2418266 plaintiff Here William   611527 611527 Here, William, of Hornchurch 3
5215116 2420144 2420144 defendant Weston Richard chaplain 611527 611527 Weston, Richard, of Hornchurch, chaplain 4
5233471 2425381 2425381 defendant Wylot Stephen husbandman 611527 611527 Wylot, Stephen, of Hornchurch, husbandman 1
5367110 2465360 2465360 defendant Parson Richard (legal representative) 611527 611527 Parson, Richard, of Hornchurch, husbandman, executrix of 2
5387039 2471360 2471360 defendant Couper Stephen husbandman 611527 611527 Couper, Stephen, of Hornchurch, husbandman 0
5390045 2472213 2472213 defendant Wattes John yeoman 611527 611527 Wattes, John, of Hornchurch, yeoman 2
5422787 2481768 2481768 defendant Angyr John husbandman 611527 611527 Angyr, John, of Hornchurch, husbandman 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);