names

17 rows where place_id = 594088

✎ 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
3614516 1872188 1872188 defendant Sond Richard walker 594088 594088 Sond, Richard, of Bryggenorth, walker 0
3637787 1906636 1906636 defendant Gravenour Roland gent 594088 594088 Gravenour, Roland, of Bryggenorth, gent 0
3681038 1920144 1920144 defendant Walker John butcher 594088 594088 Walker, John, of Bryggenorth, butcher 3
3806322 1959892 1959892 defendant Kemsey Stephen gent 594088 594088 Kemsey, Stephen, of Bryggenorth, gent 0
4554344 2217286 2217286 plaintiff Grene Thomas   594088 594088 Grene, Thomas, of Bryggenorth 0
4554345 2217286 2217286 defendant Taillour George   594088 594088 Taillour, George, of Bryggenorth 0
4635937 2242073 2242073 defendant Palmer John   594088 594088 Palmer, John, of Bryggenorth 0
4829063 2305129 2305129 defendant Erkale Thomas chaplain 594088 594088 Erkale, Thomas, of Bryggenorth, chaplain 0
4839470 2308269 2308269 defendant Tanayle Thomas shoemaker 594088 594088 Tanayle, Thomas, of Bryggenorth, shoemaker 0
4866121 2316376 2316376 defendant Owen William barker 594088 594088 Owen, William, of Bryggenorth, barker 0
4904721 2328083 2328083 defendant Blyke Richard gent 594088 594088 Blyke, Richard, of Bryggenorth, gent 0
4986607 2352924 2352924 defendant Costyn Thomas weaver 594088 594088 Costyn, Thomas, of Bryggenorth, weaver 0
4986609 2352925 2352925 defendant Costyn Thomas weaver 594088 594088 Costyn, Thomas, of Bryggenorth, weaver 0
5188742 2412436 2412436 defendant Bruyn John esq 594088 594088 Bruyn, John, of Bryggenorth, esq 0
5220360 2421651 2421651 defendant Bruyn John esq 594088 594088 Bruyn, John, of Bryggenorth, esq 0
5415704 2479639 2479639 defendant Smyth Walter smith 594088 594088 Smyth, Walter, of Bryggenorth, smith 0
5549334 2519854 2519854 defendant Holyns Richard tiler 594088 594088 Holyns, Richard, of Bryggenorth, tiler 3

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);