names

11 rows where place_id = 607658

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3670238 1916637 1916637 defendant Standen Edmund husbandman 607658 607658 Standen, Edmund, of Haukherst, Kent, husbandman 0
4664512 2250380 2250380 defendant Elys Thomas husbandman 607658 607658 Elys, Thomas, of Haukherst, Kent, husbandman 0
4676296 2258198 2258198 defendant Fylpot Thomas draper 607658 607658 Fylpot, Thomas, of Haukherst, Kent, draper 1
4748378 2280031 2280031 defendant Eldynden Richard husbandman 607658 607658 Eldynden, Richard, of Haukherst, Kent, husbandman 2
4904511 2328019 2328019 defendant Lyllesden Simon weaver 607658 607658 Lyllesden, Simon, of Haukherst, Kent, weaver 1
5102532 2387143 2387143 defendant Jordan William husbandman 607658 607658 Jordan, William, of Haukherst, Kent, husbandman 0
5323483 2452101 2452101 defendant Leghe Richard yeoman 607658 607658 Leghe, Richard, of Haukherst, Kent, yeoman 2
5449462 2489727 2489727 defendant Mercer John   607658 607658 Mercer, John, of Haukherst, Kent, inland fish sellter 3
5488345 2501408 2501408 defendant Congherst Thomas gent 607658 607658 Congherst, Thomas, of Haukherst, Kent, gent 2
5488351 2501409 2501409 defendant Goutherst Thomas gent 607658 607658 Goutherst, Thomas, of Haukherst, Kent, gent 2
5557988 2522292 2522292 defendant Holt Joseph   607658 607658 Holt, Joseph, of Haukherst, Kent, "repyer" 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);