names

17 rows where case_id = 2452503

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5324820 2452503 2452503 plaintiff Roberdson Hugh (legal representative)   Roberdson, Hugh, administratrix of 0
5324821 2452503 2452503 plaintiff Roberdson Alice widow   Roberdson, Alice, widow 1
5324822 2452503 2452503 defendant Garard Stephen husbandman 589593 589593 Garard, Stephen, of Swyneshed, husbandman 0
5324823 2452503 2452503 defendant Rate John husbandman 587435 587435 Rate, John, of Conyngesby, husbandman 1
5324824 2452503 2452503 defendant More John brewer 586286 586286 More, John, of Boston, brewer 2
5324825 2452503 2452503 defendant Webster William husbandman 589593 589593 Webster, William, of Swyneshed, husbandman 3
5324826 2452503 2452503 defendant Tomson John husbandman 589593 589593 Tomson, John, of Swyneshed, husbandman 4
5324827 2452503 2452503 defendant Laurenson William yeoman 589593 589593 Laurenson, William, of Swyneshed, yeoman 5
5324828 2452503 2452503 defendant Thyrkels Henry husbandman 589593 589593 Thyrkels, Henry, of Swyneshed, husbandman 6
5324829 2452503 2452503 defendant Glover Roger glover 586286 586286 Glover, Roger, of Boston, glover 7
5324830 2452503 2452503 defendant Fryston John glover 586981 586981 Fryston, John, of Louth, glover 8
5324831 2452503 2452503 defendant Wilby John clerk 595229 595229 Wilby, John, of Pynchebeke, clerk 9
5324832 2452503 2452503 defendant Roper Simon husbandman 586286 586286 Roper, Simon, of Boston, husbandman 10
5324833 2452503 2452503 defendant Bardney Thomas (legal representative) 589593 589593 Bardney, Thomas, of Swyneshed, husbandman, executors of 11
5324834 2452503 2452503 defendant Bardney Stephen husbandman 589593 589593 (Bardney, Stephen, of Swyneshed, husbandman 12
5324835 2452503 2452503 defendant Bardney Henry husbandman 589593 589593 Bardney, Henry, of Swyneshed, husbandman 13
5324836 2452503 2452503 defendant Bardney Nicholas mercer 589593 589593 Bardney, Nicholas, of Swyneshed, mercer 14

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