names

13 rows where case_id = 2330670

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4913335 2330670 2330670 plaintiff Clerbek Thomas     Clerbek, Thomas 0
4913336 2330670 2330670 defendant Waryn John, junior fuller 586912 586912 Waryn, John, junior, of Melford, fuller 0
4913337 2330670 2330670 defendant Tame Thomas mercer 586953 586953 Tame, Thomas, of Sudbury, mercer 1
4913338 2330670 2330670 defendant Pedder Andrew pedder 817859 817859 Pedder, Andrew, of Henye, Essex, pedder 2
4913339 2330670 2330670 defendant Geleloun Robert husbandman 793417 793417 Geleloun, Robert, of Aketon, Suff, husbandman 3
4913340 2330670 2330670 defendant Fen Geoffrey husbandman 586953 586953 Fen, Geoffrey, of Sudbury, husbandman 4
4913341 2330670 2330670 defendant Pellican John husbandman 586953 586953 Pellican, John, of Sudbury, husbandman 5
4913342 2330670 2330670 defendant Colier John baker 821100 821100 Colier, John, of St Mary Buris, baker 6
4913343 2330670 2330670 defendant Barbour William barber 586953 586953 Barbour, William, of Sudbury, barber 7
4913344 2330670 2330670 defendant Deye Robert butcher 586641 586641 Deye, Robert, of Aketon, butcher 8
4913345 2330670 2330670 defendant Watir John yeoman 586953 586953 Watir, John, of Sudbury, yeoman 9
4913346 2330670 2330670 defendant Pynchebek Thomas tailor 586912 586912 Pynchebek, Thomas, of Melford, tailor 10
4913347 2330670 2330670 defendant Drynkwater John yeoman 586953 586953 Drynkwater, John, of Sudbury, yeoman 11

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