names

15 rows where place_id = 597580

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3629087 1903973 1903973 defendant Smyth Hugh husbandman 597580 597580 Smyth, Hugh, of Ilford, husbandman 2
3707086 1928504 1928504 defendant Eden John yeoman 597580 597580 Eden, John, of Ilford, yeoman 0
3719954 1932509 1932509 defendant Eden John yeoman 597580 597580 Eden, John, of Ilford, yeoman 2
3864635 1978369 1978369 defendant Lukyn Thomas yeoman 597580 597580 Lukyn, Thomas, of Ilford, yeoman 0
3864637 1978370 1978370 defendant Lukyn Thomas yeoman 597580 597580 Lukyn, Thomas, of Ilford, yeoman 0
3878742 1983140 1983140 defendant Lukynge Thomas yeoman 597580 597580 Lukynge, Thomas, of Ilford,yeoman 0
4628760 2239923 2239923 defendant Poyntyngdon John   597580 597580 Poyntyngdon, John, of Ilford 0
4628762 2239924 2239924 defendant Poyntyngton John   597580 597580 Poyntyngton, John, of Ilford 0
4897390 2325842 2325842 defendant Serle Thomas husbandman 597580 597580 Serle, Thomas, of Ilford, husbandman 0
5077286 2379708 2379708 defendant Martyn John barber 597580 597580 Martyn, John, of Ilford, barber 0
5084897 2381990 2381990 defendant Lytilworth John, junior laborer 597580 597580 Lytilworth, John, junior, of Ilford, laborer 1
5139648 2398071 2398071 defendant Andrewe William laborer 597580 597580 Andrewe, William, of Ilford, laborer 1
5179888 2409855 2409855 defendant Bonauntur Gilbert laborer 597580 597580 Bonauntur, Gilbert, of Ilford, laborer 0
5353059 2461041 2461041 defendant Stonard Thomas smith 597580 597580 Stonard, Thomas, of Ilford, smith 2
5353063 2461042 2461042 defendant Stonard Thomas smith 597580 597580 Stonard, Thomas, of Ilford, smith 2

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