names

28 rows where place_id = 615386

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3708590 1928986 1928986 defendant Hurte Robert fishmonger 615386 615386 Hurte, Robert, of Loughborowe, Leics, fishmonger 1
3743361 1939797 1939797 defendant Hurt Robert fishmonger 615386 615386 Hurt, Robert, of Loughborowe, Leics, fishmonger 0
3886175 1985625 1985625 defendant Hurte Robert fishmonger 615386 615386 Hurte, Robert, of Loughborowe, Leics, fishmonger 0
3951984 2007757 2007757 defendant Shephard Richard yeoman 615386 615386 Shephard, Richard, of Loughborowe, Leics, yeoman 0
3970032 2014114 2014114 defendant Wright William ironmonger 615386 615386 Wright, William, of Loughborowe, Leics, ironmonger 2
3992928 2022226 2022226 plaintiff Caldwell George husbandman 615386 615386 Caldwell, George, of Loughborowe, Leics, husbandman 0
4005913 2026886 2026886 defendant Wyse Robert yeoman 615386 615386 Wyse, Robert, of Loughborowe, Leics, yeoman 0
4007514 2027471 2027471 defendant Nycholson John carrier 615386 615386 Nycholson, John, of Loughborowe, Leics, carrier 1
4011500 2028871 2028871 defendant Sneyth Clement yeoman 615386 615386 Sneyth, Clement, of Loughborowe, Leics, yeoman 6
4011510 2028872 2028872 defendant Sneyth Clement yeoman 615386 615386 Sneyth, Clement, of Loughborowe, Leics, yeoman 5
4058685 2045498 2045498 defendant Gibson Henry mercer 615386 615386 Gibson, Henry, of Loughborowe, Leics, mercer 0
4089345 2056475 2056475 defendant Smythe Thomas yeoman 615386 615386 Smythe, Thomas, of Loughborowe, Leics, yeoman 0
4089349 2056476 2056476 defendant Smythe Thomas yeoman 615386 615386 Smythe, Thomas, of Loughborowe, Leics, yeoman 0
4115058 2065673 2065673 defendant Wyllocke Edmund clerk 615386 615386 Wyllocke, Edmund, of Loughborowe, Leics, clerk 1
4203697 2096851 2096851 defendant Goodwyne William chapman 615386 615386 Goodwyne, William, of Loughborowe, Leics, chapman 1
4278433 2122392 2122392 defendant Parker Roland woolworker 615386 615386 Parker, Roland, of Loughborowe, Leics, woolworker 0
4311828 2134274 2134274 defendant Warde George laborer 615386 615386 Warde, George, of Loughborowe, Leics, laborer 1
4327306 2139457 2139457 defendant Brokesby William gent 615386 615386 Brokesby, William, of Loughborowe, Leics, gent 2
5230089 2424418 2424418 defendant Dygyll William chapman 615386 615386 Dygyll, William, of Loughborowe, Leics, chapman 2
5230100 2424420 2424420 defendant Dygyll William chapman 615386 615386 Dygyll, William, of Loughborowe, Leics, chapman 2
5353182 2461071 2461071 defendant Colas William butcher 615386 615386 (Colas, William, of Loughborowe, Leics, butcher 1
5484064 2500170 2500170 defendant Hortope John baker 615386 615386 Hortope, John, of Loughborowe, Leics, baker 0
5512377 2508733 2508733 defendant Hortope John chapman 615386 615386 Hortope, John, of Loughborowe, Leics, chapman 1
5555043 2521481 2521481 defendant Calcrofte Thomas merchant 615386 615386 Calcrofte, Thomas, of Loughborowe, Leics, merchant 2
5555242 2521537 2521537 defendant Marshall Thomas (legal representative) 615386 615386 Marshall, Thomas, of Loughborowe, Leics, merchant, executor of 0
5570288 2525875 2525875 defendant Calcrofte Thomas gent 615386 615386 (Calcrofte, Thomas, of Loughborowe, Leics, gent 1
5570403 2525912 2525912 defendant Calcroft Thomas gent 615386 615386 Calcroft, Thomas, of Loughborowe, Leics, gent 2
5581599 2529322 2529322 defendant Ley John yeoman 615386 615386 Ley, John, of Loughborowe, Leics, yeoman 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);