names

15 rows where case_id = 2399699

✎ 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
5145069 2399699 2399699 plaintiff Boor John clerk   Boor, John, clerk 0
5145070 2399699 2399699 defendant Strop Thomas clerk 586471 586471 Strop, Thomas, of Aylesham, clerk 0
5145071 2399699 2399699 defendant Skyppyng Thomas husbandman 586471 586471 Skyppyng, Thomas, of Aylesham, husbandman 1
5145072 2399699 2399699 defendant Brynkeley Lawrence husbandman 586471 586471 Brynkeley, Lawrence, of Aylesham, husbandman 2
5145073 2399699 2399699 defendant Lesyngham Robert chaplain 586471 586471 with Lesyngham, Robert, of Aylesham, chaplain 3
5145074 2399699 2399699 defendant Furbesshorne Robert chaplain 586471 586471 Furbesshorne, Robert, of Aylesham, chaplain 4
5145075 2399699 2399699 defendant Wetyng Simon chaplain 594663 594663 Wetyng, Simon, of Swenyngton, chaplain 5
5145076 2399699 2399699 defendant Sawere Edmund chaplain 586471 586471 Sawere, Edmund, of Aylesham, chaplain 6
5145077 2399699 2399699 defendant Skyppyng John, sen husbandman 586471 586471 Skyppyng, John, sen, of Aylesham, husbandman 7
5145078 2399699 2399699 defendant Portlond Alan husbandman 586471 586471 Portlond, Alan, of Aylesham, husbandman 8
5145079 2399699 2399699 defendant Goderede John smith 586471 586471 Goderede, John, of Aylesham, smith 9
5145080 2399699 2399699 defendant Walterys William husbandman 586471 586471 Walterys, William, of Aylesham, husbandman 10
5145081 2399699 2399699 defendant Herman Ralph husbandman 586471 586471 Herman, Ralph, of Aylesham, husbandman 11
5145082 2399699 2399699 defendant Cook Thomas husbandman 586471 586471 Cook, Thomas, of Aylesham, husbandman 12
5145083 2399699 2399699 defendant Clerk John   586471 586471 Clerk, John, of Aylesham, servant 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);