names

18 rows where place_id = 687903

✎ 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
4073245 2050722 2050722 defendant Vyn Christopher husbandman 687903 687903 Vyn, Christopher, of Swardeston, husbandman 2
4073246 2050722 2050722 defendant Chapman John husbandman 687903 687903 Chapman, John, of Swardeston, husbandman 3
4116215 2066089 2066089 defendant Pulham John husbandman 687903 687903 Pulham, John, of Swardeston, husbandman 3
4146388 2076888 2076888 defendant Hawnd William blacksmith 687903 687903 Hawnd, William, of Swardeston, blacksmith 0
4164472 2083092 2083092 defendant Chambers John gent 687903 687903 Chambers, John, of Swardeston, gent 1
4221117 2102881 2102881 defendant Vine or Ume Richard yeoman 687903 687903 Vine or Ume, Richard, of Swardeston, yeoman 0
4221986 2103182 2103182 defendant Chambers John clerk 687903 687903 Chambers, John, of Swardeston, clerk 1
4230479 2106156 2106156 defendant Chambers John clerk 687903 687903 Chambers, John, of Swardeston, clerk 1
4271020 2119881 2119881 defendant Ashfyld Timothy husbandman 687903 687903 Ashfyld, Timothy, of Swardeston, husbandman 3
4291766 2127132 2127132 defendant Hunt or Hunter John   687903 687903 Hunt or Hunter ,John, of Swardeston, shepherd 2
4328875 2139970 2139970 defendant Vynne Richard husbandman 687903 687903 Vynne, Richard, of Swardeston, husbandman 2
4345242 2145613 2145613 defendant Browne Bartholomew yeoman 687903 687903 Browne, Bartholomew, of Swardeston, yeoman 2
4355786 2149244 2149244 defendant Kensey John yeoman 687903 687903 Kensey, John, of Swardeston, yeoman 0
4386890 2160284 2160284 defendant Breuster Edward clerk 687903 687903 Breuster, Edward, of Swardeston, clerk 0
4401605 2165134 2165134 defendant Browne Bartholomew   687903 687903 Browne, Bartholomew, of Swardeston, mason 0
4404587 2166105 2166105 defendant Chapman John yeoman 687903 687903 Chapman, John, of Swardeston, yeoman 0
5154708 2402531 2402531 defendant Pryce William gent 687903 687903 Pryce, William, of Swardeston, gent 3
5337790 2456381 2456381 defendant Wellys John laborer 687903 687903 Wellys, John, of Swardeston, laborer 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);