names

19 rows where place_id = 605572

✎ 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
3657895 1912718 1912718 defendant Smyth John   605572 605572 Smyth, John, of Little Walsyngham, Norf, tallow chandler 1
3657905 1912722 1912722 defendant Smyth John   605572 605572 Smyth, John, of Little Walsyngham, Norf, tallow chandler 1
3662184 1914088 1914088 defendant Matsale Thomas, junior mercer 605572 605572 Matsale, Thomas, junior, of Little Walsyngham, Norf, mercer 3
4808613 2298859 2298859 defendant Walsyngham alias Draper Nicholalas gent 605572 605572 Walsyngham alias Draper, Nicholalas, of Little Walsyngham, Norf, gent 0
4822175 2303013 2303013 defendant Poret Thomas yeoman 605572 605572 Poret, Thomas, of Little Walsyngham, Norf, yeoman 3
5002056 2357503 2357503 defendant Spycer Nicholas spicer 605572 605572 Spycer, Nicholas, of Little Walsyngham, Norf, spicer 2
5038581 2368184 2368184 defendant Banyard Richard husbandman 605572 605572 (Banyard, Richard, of Little Walsyngham, Norf, husbandman 1
5177194 2409023 2409023 defendant Lovell Thomas yeoman 605572 605572 Lovell, Thomas, of Little Walsyngham, Norf, yeoman 3
5199953 2415739 2415739 defendant Lovell Thomas yeoman 605572 605572 Lovell, Thomas, of Little Walsyngham, Norf, yeoman 3
5297878 2444386 2444386 defendant Goddyng Godfrey yeoman 605572 605572 Goddyng, Godfrey, of Little Walsyngham, Norf, yeoman 0
5377062 2468416 2468416 defendant Grene Richard ostler 605572 605572 Grene, Richard, of Little Walsyngham, Norf, ostler 0
5418272 2480392 2480392 defendant Gylys Nicholas mercer 605572 605572 Gylys, Nicholas, of Little Walsyngham, Norf, mercer 0
5419273 2480691 2480691 defendant Warner Robert clerk 605572 605572 Warner, Robert, of Little Walsyngham, Norf, clerk 2
5430274 2483993 2483993 defendant Caudeler Nicholas yeoman 605572 605572 Caudeler, Nicholas, of Little Walsyngham, Norf, yeoman 0
5437512 2486159 2486159 defendant Warner Richard clerk 605572 605572 Warner, Richard, of Little Walsyngham, Norf, clerk 2
5437518 2486160 2486160 defendant Warner Robert clerk 605572 605572 Warner, Robert, of Little Walsyngham, Norf, clerk 2
5437611 2486185 2486185 defendant Skryven Henry husbandman 605572 605572 Skryven, Henry, of Little Walsyngham, Norf, husbandman 0
5437626 2486189 2486189 defendant Skryven Henry husbandman 605572 605572 Skryven, Henry, of Little Walsyngham, Norf, husbandman 1
5459523 2492760 2492760 defendant Caudeler Nicholas yeoman 605572 605572 Caudeler, Nicholas, of Little Walsyngham, Norf, 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);