names

18 rows where place_id = 617436

✎ 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
3719557 1932381 1932381 defendant Bell Peter merchant 617436 617436 Bell, Peter, of Magna Grymsby, merchant 4
3780664 1951680 1951680 defendant Mason Michael mercer 617436 617436 Mason, Michael, of Magna Grymsby, mercer 0
3823218 1965175 1965175 defendant Lord Christopher yeoman 617436 617436 (Lord, Christopher, of Magna Grymsby, yeoman 1
3823219 1965175 1965175 defendant Chalender William yeoman 617436 617436 Chalender, William, of Magna Grymsby, yeoman 2
3863191 1977892 1977892 defendant Kyngeston John mercer 617436 617436 Kyngeston, John, of Magna Grymsby, mercer 0
3948987 2006712 2006712 defendant Holtby Richard tanner 617436 617436 Holtby, Richard, of Magna Grymsby, tanner 0
4047302 2041493 2041493 defendant Ayscoughe Richard gent 617436 617436 Ayscoughe, Richard, of Magna Grymsby, gent 0
4056914 2044856 2044856 plaintiff Browne Hugh yeoman 617436 617436 Browne, Hugh, of Magna Grymsby, yeoman 0
4056916 2044857 2044857 plaintiff Browne Hugh yeoman 617436 617436 Browne, Hugh, of Magna Grymsby, yeoman 0
4081413 2053661 2053661 defendant Empryngham Michael alderman 617436 617436 Empryngham, Michael, of Magna Grymsby, gent, alderman 0
4112111 2064588 2064588 defendant Lyndsey Geoffrey chapman 617436 617436 Lyndsey, Geoffrey, of Magna Grymsby, chapman 1
4122865 2068473 2068473 defendant Broxholme Richard gent 617436 617436 Broxholme, Richard, of Magna Grymsby, gent 0
4126566 2069785 2069785 defendant Northe Thomas gent 617436 617436 Northe, Thomas, of Magna Grymsby, gent 2
4160456 2081732 2081732 defendant Kyrton William yeoman 617436 617436 Kyrton, William, of Magna Grymsby, or of Hawthorne, Lincs, yeoman 0
4207728 2098265 2098265 defendant Kyrton William yeoman 617436 617436 Kyrton, William, of Magna Grymsby, or of Hackthorn, Lincs, yeoman 0
4241846 2110264 2110264 defendant Howe John gent 617436 617436 Howe, John, of Magna Grymsby, gent 0
5058330 2374036 2374036 defendant Dunston Robert cordwainer 617436 617436 Dunston, Robert, of Magna Grymsby, cordwainer 0
5074925 2379006 2379006 defendant More Richard merchant 617436 617436 More, Richard, of Magna Grymsby, merchant 0

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