names

21 rows where case_id = 2322124

✎ 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
4884689 2322124 2322124 plaintiff Upton William     Upton, William 0
4884690 2322124 2322124 defendant Colvyle John gent 589912 589912 Colvyle, John, of Leveryngton, Cams, gent 0
4884691 2322124 2322124 defendant Mereman John chapman 586286 586286 Mereman, John, of Boston, chapman 1
4884692 2322124 2322124 defendant Everard William gent 596437 596437 Everard, William, of Soterton, gent 2
4884693 2322124 2322124 defendant Pulvertoft John, senior gent 817176 817176 Pulvertoft, John, senior, of Fossedyk, Algarkirk, gent 3
4884694 2322124 2322124 defendant Hunnyng John husbandman 817176 817176 Hunnyng, John, of Fossedyk, Algarkirk, husbandman 4
4884695 2322124 2322124 defendant Ogeham John merchant 586286 586286 Ogeham, John, of Boston, merchant 5
4884696 2322124 2322124 defendant Burnam John gent 758127 758127 Burnam, John, of Algarkirk, gent 6
4884697 2322124 2322124 defendant Asshe John widow 589460 589460 Asshe, John, of Spaldyng, widow 7
4884698 2322124 2322124 defendant Asshe John gent 587432 587432 Asshe, John, of Spillesby, gent 8
4884699 2322124 2322124 defendant Busshe Agnes widow 594426 594426 Busshe, Agnes, of Benyngton, widow 9
4884700 2322124 2322124 defendant Rybold Alice   589460 589460 Rybold, Alice, of Spaldyng, widow of Rybold, Richard 10
4884701 2322124 2322124 defendant Hunnyng Richard of Soterton husbandman   Hunnyng, Richard of Soterton, husbandman 11
4884702 2322124 2322124 defendant Tolle William husbandman 601262 601262 Tolle, William, of Rydde, husbandman 12
4884703 2322124 2322124 defendant Spyan William chapman 586286 586286 Spyan, William, of Boston, chapman 13
4884704 2322124 2322124 defendant Webstere William husbandman 586504 586504 Webstere, William, of Frampton, husbandman 14
4884705 2322124 2322124 defendant Wryght John husbandman 606762 606762 Wryght, John, of Baston, husbandman 15
4884706 2322124 2322124 defendant Howet John husbandman 756923 756923 Howet, John, of Billesfeld, husbandman 16
4884707 2322124 2322124 defendant Lock Roger   756733 756733 Lock, Roger, of Kirketon in Holand, mason 17
4884708 2322124 2322124 defendant Copuldyk Roger (legal representative)   Copuldyk, Roger, administratrix of 18
4884709 2322124 2322124 defendant Copuldyk Elizabeth widow 586504 586504 Copuldyk, Elizabeth, of Frampton, widow 19

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