names

34 rows where place_id = 607203

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3668131 1915979 1915979 defendant Amfles Robert merchant 607203 607203 Amfles, Robert, of Bishops Lenn, Norf, merchant 1
3668134 1915980 1915980 defendant Amfles Robert merchant 607203 607203 Amfles, Robert, of Bishops Lenn, Norf, merchant 1
3670289 1916656 1916656 defendant Danyell John, senior merchant 607203 607203 Danyell, John, senior, of Bishops Lenn, Norf, merchant 0
3674116 1917944 1917944 defendant Crosseby alias Crosse John hosier 607203 607203 Crosseby alias Crosse, John, of Bishops Lenn, Norf, hosier 1
3686721 1922001 1922001 defendant Burdy John merchant 607203 607203 Burdy, John, of Bishops Lenn, Norf, merchant 0
3689588 1922901 1922901 defendant Kyrby Thomas merchant 607203 607203 Kyrby, Thomas, of Bishops Lenn, Norf, merchant 0
3691968 1923650 1923650 defendant Kyrby Thomas merchant 607203 607203 Kyrby, Thomas, of Bishops Lenn, Norf, merchant 0
3727823 1934971 1934971 defendant Hallyer John draper 607203 607203 Hallyer, John, of Bishops Lenn, Norf, draper 0
3727825 1934972 1934972 defendant Hallyer John draper 607203 607203 Hallyer, John, of Bishops Lenn, Norf, draper 0
3781500 1951953 1951953 defendant Felix John merchant 607203 607203 Felix, John, of Bishops Lenn, Norf, merchant 1
3784198 1952844 1952844 defendant Kyrby Thomas fletcher 607203 607203 Kyrby, Thomas, of Bishops Lenn, Norf, fletcher 0
3817736 1963452 1963452 defendant Smyth Henry waterman 607203 607203 Smyth, Henry, of Bishops Lenn, Norf, waterman 0
3827443 1966449 1966449 defendant Bramsell Christopher glover 607203 607203 Bramsell, Christopher, of Bishops Lenn, Norf, glover 0
3859055 1976519 1976519 defendant Macanter John merchant 607203 607203 Macanter, John, of Bishops Lenn, Norf, merchant 0
3867671 1979422 1979422 defendant Myller Andrew gent 607203 607203 Myller, Andrew, of Bishops Lenn, Norf, gent 0
4783953 2290990 2290990 defendant Tylney John gent 607203 607203 Tylney, John, of Bishops Lenn, Norf, gent 0
4812485 2300018 2300018 defendant Grene Simon fisher 607203 607203 Grene, Simon, of Bishops Lenn, Norf, fisher 0
4899556 2326501 2326501 defendant Costyn William yeoman 607203 607203 Costyn, William, of Bishops Lenn, Norf, yeoman 0
5027362 2364878 2364878 defendant Kelowe Thomas gent 607203 607203 Kelowe, Thomas, of Bishops Lenn, Norf, gent 0
5061699 2375093 2375093 defendant Breton William merchant 607203 607203 Breton, William, of Bishops Lenn, Norf, merchant 0
5239015 2427003 2427003 defendant Basse John merchant 607203 607203 Basse, John, of Bishops Lenn, Norf, merchant 0
5243562 2428311 2428311 defendant Martyn John skinner 607203 607203 Martyn, John, of Bishops Lenn, Norf, skinner 2
5245626 2428880 2428880 defendant Hunt Robert merchant 607203 607203 Hunt, Robert, of Bishops Lenn, Norf, merchant 0
5261541 2433719 2433719 defendant Patenmaker Henry   607203 607203 Patenmaker, Henry, of Bishops Lenn, Norf, paten maker 0
5398316 2474582 2474582 defendant Waleys John merchant 607203 607203 Waleys, John, of Bishops Lenn, Norf, merchant 0
5402261 2475718 2475718 defendant Thorysby Robert gent 607203 607203 Thorysby, Robert, of Bishops Lenn, Norf, gent 0
5404437 2476337 2476337 defendant Balle Alice widow 607203 607203 Balle, Alice, of Bishops Lenn, Norf, widow 5
5500167 2505002 2505002 defendant Breten John shipman 607203 607203 Breten, John, of Bishops Lenn, Norf, shipman 1
5581917 2529426 2529426 defendant Bowsey Margery widow 607203 607203 Bowsey, Margery, of Bishops Lenn, Norf, widow 0
5582079 2529463 2529463 defendant Castell William mercer 607203 607203 Castell, William, of Bishops Lenn, Norf, mercer 0
5589641 2531756 2531756 defendant Bastard Richard merchant 607203 607203 Bastard, Richard, of Bishops Lenn, Norf, merchant 0
5598049 2534288 2534288 defendant Saunders John butcher 607203 607203 Saunders, John, of Bishops Lenn, Norf, butcher 0
5606007 2536767 2536767 defendant Tanne John merchant 607203 607203 Tanne, John, of Bishops Lenn, Norf, merchant 0
5606011 2536768 2536768 defendant Tanne John merchant 607203 607203 Tanne, John, of Bishops Lenn, Norf, merchant 0

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