names

15 rows where case_id = 2394191

✎ 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
5126359 2394191 2394191 plaintiff Boor John clerk   Boor, John, clerk 0
5126360 2394191 2394191 defendant Lesyngham Robert chaplain 586471 586471 Lesyngham, Robert, of Aylesham, chaplain 0
5126361 2394191 2394191 defendant Furbesshoure Robert chaplain 586471 586471 Furbesshoure, Robert, of Aylesham, chaplain 1
5126362 2394191 2394191 defendant Wetyng Simon chaplain 594663 594663 Wetyng, Simon, of Swenyngton, chaplain 2
5126363 2394191 2394191 defendant Sawere Edmund chaplain 586471 586471 Sawere, Edmund, of Aylesham, chaplain 3
5126364 2394191 2394191 defendant Skyppyng John husbandman 586471 586471 Skyppyng, John, of Aylesham, senior, husbandman 4
5126365 2394191 2394191 defendant Portlond Alan husbandman 586471 586471 Portlond, Alan, of Aylesham, husbandman 5
5126366 2394191 2394191 defendant Boderede John smith 586471 586471 Boderede, John, of Aylesham, smith 6
5126367 2394191 2394191 defendant Walterys William husbandman 586471 586471 Walterys, William, of Aylesham, husbandman 7
5126368 2394191 2394191 defendant Herman Ralph husbandman 586471 586471 Herman, Ralph, of Aylesham, husbandman 8
5126369 2394191 2394191 defendant Cook Thomas husbandman 586471 586471 Cook, Thomas, of Aylesham, husbandman 9
5126370 2394191 2394191 defendant Clerk John   586471 586471 Clerk, John, of Aylesham, servant 10
5126371 2394191 2394191 defendant Strope Thomas clerk 586471 586471 with Strope, Thomas, of Aylesham, clerk 11
5126372 2394191 2394191 defendant Skyppyng Thomas husbandman 586471 586471 Skyppyng, Thomas, of Aylesham, husbandman 12
5126373 2394191 2394191 defendant Brynkeley Lawrence husbandman 586471 586471 Brynkeley, Lawrence, of Aylesham, husbandman 13

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