names

28 rows where place_id = 588806

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595650 1866265 1866265 defendant Baylly Thomas husbandman 588806 588806 Baylly, Thomas, of Saxilby, husbandman 0
3642835 1908207 1908207 defendant Verdon William laborer 588806 588806 Verdon, William, of Saxilby, laborer 0
3915770 1995652 1995652 defendant Wytton John (legal representative) 588806 588806 Wytton, John, of Saxilby, yeoman, executors of 0
3915771 1995652 1995652 defendant Wytton Agnes widow 588806 588806 (Wytton, Agnes, of Saxilby, widow 1
3915772 1995652 1995652 defendant Wytton Richard husbandman 588806 588806 Wytton, Richard, of Saxilby, husbandman 2
4489327 2197379 2197379 defendant Noire Adam   588806 588806 Noire, Adam, of Saxilby 0
4489329 2197379 2197379 defendant Bate Thomas   588806 588806 Bate, Thomas, of Saxilby 2
4617705 2236538 2236538 plaintiff Smyth William   588806 588806 Smyth, William, of Saxilby 2
4628456 2239822 2239822 plaintiff Smyth William   588806 588806 Smyth, William, of Saxilby 2
4642074 2243790 2243790 defendant Gayte William   588806 588806 Gayte, William, of Saxilby 0
4677685 2258637 2258637 defendant Wyghton William de laborer & son of John 588806 588806 Wyghton, William de, of Saxilby, laborer & son of John 0
4677702 2258642 2258642 defendant Palmer Walter husbandman 588806 588806 Palmer, Walter, of Saxilby, husbandman 1
4715767 2270250 2270250 defendant Norton John   588806 588806 Norton, John, of Saxilby, vicar 0
4715768 2270250 2270250 defendant Hobman Henry husbandman 588806 588806 Hobman, Henry, of Saxilby, husbandman 1
4715769 2270250 2270250 defendant Horwode John yeoman 588806 588806 Horwode, John, of Saxilby, yeoman 2
4728807 2274248 2274248 defendant Norton John   588806 588806 Norton, John, of Saxilby, vicar 0
4738007 2276991 2276991 defendant Norton John   588806 588806 Norton, John, of Saxilby, vicar 0
4815096 2300833 2300833 defendant Jakson Peter husbandman 588806 588806 Jakson, Peter, of Saxilby, husbandman 1
4863239 2315476 2315476 defendant Saunderson Robert yeoman 588806 588806 Saunderson, Robert, of Saxilby, yeoman 6
4884325 2322003 2322003 defendant Jakson Peter husbandman 588806 588806 (Jakson, Peter, of Saxilby, husbandman 1
4995388 2355462 2355462 plaintiff Hardy Thomas   588806 588806 (Hardy, Thomas, of Saxilby, parson 1
5020320 2362830 2362830 defendant Wrangyll Robert husbandman 588806 588806 Wrangyll, Robert, of Saxilby, husbandman 7
5020321 2362830 2362830 defendant Wrangill John husbandman 588806 588806 Wrangill, John, of Saxilby, husbandman 8
5037778 2367926 2367926 defendant Holman John husbandman 588806 588806 Holman, John, of Saxilby, husbandman 0
5087561 2382742 2382742 defendant Yoman John butcher 588806 588806 Yoman, John, of Saxilby, butcher 3
5247882 2429518 2429518 defendant Wyneld Richard husbandman 588806 588806 Wyneld, Richard, of Saxilby, husbandman 2
5361834 2463729 2463729 defendant Pawmer Robert clerk 588806 588806 Pawmer, Robert, of Saxilby, clerk 0
5630641 2553588 2553588 plaintiff Smyth William   588806 588806 Smyth, William, of Saxilby 2

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