names

25 rows where place_id = 596676

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3625715 1875580 1875580 defendant Ryngolff Richard husbandman 596676 596676 Ryngolff, Richard, of Halvergate, husbandman 2
3688881 1922680 1922680 defendant Stelehowe Nicholas husbandman 596676 596676 Stelehowe, Nicholas, of Halvergate, husbandman 2
3809652 1960908 1960908 defendant Cubyte Oliver husbandman 596676 596676 Cubyte, Oliver, of Halvergate, husbandman 0
3850801 1973845 1973845 defendant Wylbergh Thomas husbandman 596676 596676 Wylbergh, Thomas, of Halvergate, husbandman 0
4018408 2031316 2031316 defendant Pyle Thomas yeoman 596676 596676 Pyle, Thomas, of Halvergate, yeoman 1
4063272 2047160 2047160 defendant Curman Robert tailor 596676 596676 Curman, Robert, of Halvergate, tailor 0
4087713 2055897 2055897 defendant Kydball Simon yeoman 596676 596676 Kydball, Simon, of Halvergate, yeoman 1
4207534 2098196 2098196 defendant Sayer John yeoman 596676 596676 Sayer, John, of Halvergate, yeoman 0
4212457 2099904 2099904 defendant Atkyns Robert yeoman 596676 596676 Atkyns, Robert, of Halvergate, yeoman 3
4215659 2100975 2100975 defendant Kydball Simon yeoman 596676 596676 Kydball, Simon, of Halvergate, yeoman 0
4224202 2103952 2103952 defendant Pynchbeck John tailor 596676 596676 Pynchbeck, John, of Halvergate, tailor 0
4250001 2112979 2112979 defendant Pynchbeck John tailor 596676 596676 Pynchbeck, John, of Halvergate, tailor 0
4590654 2228436 2228436 defendant But Thomas   596676 596676 But, Thomas, of Halvergate 0
5002787 2357721 2357721 defendant Tynthwyte Edmund husbandman 596676 596676 Tynthwyte, Edmund, of Halvergate, husbandman 4
5029189 2365415 2365415 defendant Pratte Richard husbandman 596676 596676 Pratte, Richard, of Halvergate, husbandman 1
5029191 2365415 2365415 defendant Hoberd John husbandman 596676 596676 Hoberd, John, of Halvergate, husbandman 3
5337152 2456184 2456184 defendant Tynwryght Edmund husbandman 596676 596676 Tynwryght, Edmund, of Halvergate, husbandman 10
5389160 2471950 2471950 defendant Smyth Robert husbandman 596676 596676 Smyth, Robert, of Halvergate, husbandman 6
5395135 2473675 2473675 defendant Smyth Robert husbandman 596676 596676 Smyth, Robert, of Halvergate, husbandman 6
5401871 2475600 2475600 defendant Smyth Robert husbandman 596676 596676 Smyth, Robert, of Halvergate, husbandman 6
5414805 2479364 2479364 defendant Smyth Robert husbandman 596676 596676 Smyth, Robert, of Halvergate, husbandman 5
5419797 2480835 2480835 defendant Trymman Richard husbandman 596676 596676 Trymman, Richard, of Halvergate, husbandman 5
5492379 2502637 2502637 defendant Smyth Robert yeoman 596676 596676 Smyth, Robert, of Halvergate, yeoman 2
5627997 2552727 2552727 defendant Deyman Simon   596676 596676 Deyman, Simon, of Halvergate, shepherd 1
5628000 2552728 2552728 defendant Deyman Simon   596676 596676 Deyman, Simon, of Halvergate, shepherd 1

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