names

24 rows where place_id = 588922

✎ 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
3596006 1866379 1866379 defendant Hygham John gent 588922 588922 Hygham, John, of Batell, Sussex, gent 5
3791832 1955291 1955291 defendant Arnold William clerk 588922 588922 Arnold, William, of Batell, Sussex, clerk 3
3796455 1956763 1956763 defendant Swan Robert yeoman 588922 588922 Swan, Robert, of Batell, Sussex, yeoman 0
3837453 1969621 1969621 defendant Swayne Robert yeoman 588922 588922 Swayne, Robert, of Batell, Sussex, yeoman 1
3873782 1981452 1981452 defendant Love John yeoman 588922 588922 Love, John, of Batell, Sussex, yeoman 0
3896502 1989036 1989036 defendant Inold William clerk 588922 588922 Inold, William, of Batell, Sussex, clerk 0
4021152 2032285 2032285 defendant Morrys John merchant 588922 588922 Morrys, John, of Batell, Sussex, merchant 0
4403446 2165723 2165723 defendant Browne George   588922 588922 Browne, George, of Batell, Sussex, knight 0
4682000 2259987 2259987 defendant Gateman Stephen yeoman 588922 588922 Gateman, Stephen, of Batell, Sussex, yeoman 0
4929345 2335598 2335598 defendant Burton John (legal representative) 588922 588922 Burton, John, of Batell, Sussex, gent, executors of 0
4929349 2335599 2335599 defendant Burton John (legal representative) 588922 588922 Burton, John, of Batell, Sussex, gent, executors of 0
4950644 2342166 2342166 defendant Hobell John merchant 588922 588922 Hobell, John, of Batell, Sussex, merchant 1
5078748 2380133 2380133 defendant Ferthyng William weaver 588922 588922 Ferthyng, William, of Batell, Sussex, weaver 0
5172533 2407692 2407692 defendant Colman Richard yeoman 588922 588922 Colman, Richard, of Batell, Sussex, yeoman 1
5312781 2448854 2448854 defendant Wynchynden Stephen tailor 588922 588922 Wynchynden, Stephen, of Batell, Sussex, tailor 3
5329158 2453798 2453798 defendant Bestynden Ralph gent 588922 588922 Bestynden, Ralph, of Batell, Sussex, gent 0
5363556 2464255 2464255 defendant Vestynden Ralph gent 588922 588922 Vestynden, Ralph, of Batell, Sussex, gent 0
5437395 2486129 2486129 defendant Boyste Richard husbandman 588922 588922 Boyste, Richard, of Batell, Sussex, husbandman 1
5451790 2490412 2490412 defendant Boyste Richard husbandman 588922 588922 Boyste, Richard, of Batell, Sussex, husbandman 1
5508589 2507549 2507549 defendant Stapeley Thomas yeoman 588922 588922 Stapeley, Thomas, of Batell, Sussex, yeoman 3
5512319 2508711 2508711 defendant Barrette John esq 588922 588922 Barrette, John, of Batell, Sussex, esq 1
5545023 2518548 2518548 defendant Pleysted Ralph gent 588922 588922 Pleysted, Ralph, of Batell, Sussex, gent 4
5554176 2521263 2521263 defendant Smalwod John yeoman 588922 588922 Smalwod, John, of Batell, Sussex, yeoman 0
5554178 2521264 2521264 defendant Smalwod John yeoman 588922 588922 Smalwod, John, of Batell, Sussex, 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);