names

27 rows where place_id = 608232

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3672760 1917488 1917488 defendant Alen John yeoman 608232 608232 Alen, John, of Hornechurch, yeoman 0
3672761 1917488 1917488 defendant Harnold John yeoman 608232 608232 Harnold, John, of Hornechurch, yeoman 1
3672763 1917488 1917488 defendant Gehyn Griffith chaplain 608232 608232 Gehyn, Griffith, of Hornechurch, chaplain 3
3672764 1917488 1917488 defendant Busshe William husbandman 608232 608232 Busshe, William, of Hornechurch, husbandman 4
3672765 1917488 1917488 defendant Tuke Thomas laborer 608232 608232 Tuke, Thomas, of Hornechurch, laborer 5
3672766 1917488 1917488 defendant Fowler Thomas gent 608232 608232 Fowler, Thomas, of Hornechurch, gent 6
3672769 1917489 1917489 defendant Fowler Thomas gent 608232 608232 Fowler, Thomas, of Hornechurch, gent 0
3688764 1922648 1922648 defendant Fowler Thomas gent 608232 608232 Fowler, Thomas, of Hornechurch, gent 0
3688765 1922648 1922648 defendant Alen John yeoman 608232 608232 Alen, John, of Hornechurch, yeoman 1
3688766 1922648 1922648 defendant Arnolde John yeoman 608232 608232 Arnolde, John, of Hornechurch, yeoman 2
3688772 1922648 1922648 defendant Woodhowse alias Bulle John yeoman 608232 608232 Woodhowse alias Bulle, John, of Hornechurch, yeoman 8
3688773 1922648 1922648 defendant Penyffather John husbandman 608232 608232 Penyffather, John, of Hornechurch, husbandman 9
3688774 1922648 1922648 defendant Stevyn Thomas husbandman 608232 608232 Stevyn, Thomas, of Hornechurch, husbandman 10
3688775 1922648 1922648 defendant Luffyn John husbandman 608232 608232 Luffyn, John, of Hornechurch, husbandman 11
3688776 1922648 1922648 defendant Knyght alias Fyssher Christopher husbandman 608232 608232 Knyght alias Fyssher, Christopher, of Hornechurch, husbandman 12
3688777 1922648 1922648 defendant Watt George laborer 608232 608232 Watt, George, of Hornechurch, laborer 13
3688778 1922648 1922648 defendant Watt William laborer 608232 608232 Watt, William, of Hornechurch, laborer 14
3688780 1922649 1922649 defendant Fowler Thomas gent 608232 608232 Fowler, Thomas, of Hornechurch, gent 0
3688781 1922649 1922649 defendant Aleyn John yeoman 608232 608232 Aleyn, John, of Hornechurch, yeoman 1
3688782 1922649 1922649 defendant Arnolde John yeoman 608232 608232 Arnolde, John, of Hornechurch, yeoman 2
3688788 1922649 1922649 defendant Stevyn Thomas husbandman 608232 608232 Stevyn, Thomas, of Hornechurch, husbandman 8
3688789 1922649 1922649 defendant Luffyn John husbandman 608232 608232 Luffyn, John, of Hornechurch, husbandman 9
3688790 1922649 1922649 defendant Knyght alias Fyssher Christopher husbandman 608232 608232 Knyght alias Fyssher, Christopher, of Hornechurch, husbandman 10
3688791 1922649 1922649 defendant Wattys George laborer 608232 608232 Wattys, George, of Hornechurch, laborer 11
3688792 1922649 1922649 defendant Watt William laborer 608232 608232 Watt, William, of Hornechurch, laborer 12
4222467 2103350 2103350 defendant Barnard Richard singleman 608232 608232 Barnard, Richard, of Hornechurch, yeoman, singleman 1
4559052 2218791 2218791 defendant Glovere Richard   608232 608232 Glovere, Richard, of Hornechurch 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);