names

59 rows where place_id = 588872

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595853 1866342 1866342 defendant Toyes James husbandman 588872 588872 Toyes, James, of Parva Walsyngham, Norf, husbandman 0
3607929 1870129 1870129 defendant Terell Thomas chapman 588872 588872 Terell, Thomas, of Parva Walsyngham, Norf, chapman 1
3624475 1875190 1875190 defendant Drye Ralph yeoman of the crown 588872 588872 Drye, Ralph, of Parva Walsyngham, Norf, yeoman of the crown 0
3670535 1916747 1916747 defendant Shyrwyn Alan   588872 588872 Shyrwyn, Alan, of Parva Walsyngham, Norf, minstrel 0
3693666 1924213 1924213 defendant Matsale Thomas, junior chapman 588872 588872 Matsale, Thomas, junior, of Parva Walsyngham, Norf, chapman 0
3693672 1924214 1924214 defendant Matsale Thomas, junior chapman 588872 588872 (Matsale, Thomas, junior, of Parva Walsyngham, Norf, chapman 1
3696895 1925250 1925250 defendant Trewbrigge Richard yeoman 588872 588872 Trewbrigge, Richard, of Parva Walsyngham, Norf, yeoman 1
3707856 1928755 1928755 defendant Claman John baker 588872 588872 Claman, John, of Parva Walsyngham, Norf, baker 2
3707860 1928756 1928756 defendant Claman John baker 588872 588872 Claman, John, of Parva Walsyngham, Norf, baker 2
3727772 1934956 1934956 defendant Harte John innholder 588872 588872 Harte, John, of Parva Walsyngham, Norf, innholder 0
3738174 1938154 1938154 defendant Oldman John baker 588872 588872 Oldman, John, of Parva Walsyngham, Norf, baker 0
3743085 1939689 1939689 defendant Oldman John baker 588872 588872 Oldman, John, of Parva Walsyngham, Norf, baker 0
3743087 1939690 1939690 defendant Oldman John baker 588872 588872 Oldman, John, of Parva Walsyngham, Norf, baker 0
3755296 1943612 1943612 defendant Pepys John yeoman 588872 588872 Pepys, John, of Parva Walsyngham, Norf, yeoman 0
3756171 1943890 1943890 defendant Marley George husbandman 588872 588872 Marley, George, of Parva Walsyngham, Norf, husbandman 0
3770817 1948563 1948563 defendant None Robert innholder 588872 588872 (None, Robert, of Parva Walsyngham, Norf, innholder 1
3808329 1960478 1960478 defendant Gottes William mercer 588872 588872 Gottes, William, of Parva Walsyngham, Norf, mercer 0
3845855 1972258 1972258 defendant Grene Robert butcher 588872 588872 Grene, Robert, of Parva Walsyngham, Norf, butcher 0
3852032 1974226 1974226 defendant Chapman William mercer 588872 588872 Chapman, William, of Parva Walsyngham, Norf, mercer 0
3852035 1974227 1974227 defendant Chapman William mercer 588872 588872 Chapman, William, of Parva Walsyngham, Norf, mercer 0
3852038 1974228 1974228 defendant Chapman William mercer 588872 588872 Chapman, William, of Parva Walsyngham, Norf, mercer 0
3859194 1976569 1976569 defendant Walpole Edward yeoman 588872 588872 Walpole, Edward, of Parva Walsyngham, Norf, yeoman 0
3861603 1977340 1977340 defendant Ramage alias Whetlye Thomas baker 588872 588872 Ramage alias Whetlye, Thomas, of Parva Walsyngham, Norf, baker 0
3872736 1981095 1981095 defendant Folde George stainer 588872 588872 Folde, George, of Parva Walsyngham, Norf, stainer 3
3945307 2005439 2005439 defendant Gunner Roger gent 588872 588872 Gunner, Roger, of Parva Walsyngham, Norf, gent 3
3979184 2017304 2017304 defendant Fuller John husbandman 588872 588872 Fuller, John, of Parva Walsyngham, Norf, husbandman 4
3983188 2018759 2018759 defendant Mynne Nicholas gent 588872 588872 Mynne, Nicholas, of Parva Walsyngham, Norf, gent 1
4012719 2029272 2029272 defendant Mynne Nicholas esq 588872 588872 Mynne, Nicholas, of Parva Walsyngham, Norf, esq 0
4026991 2034304 2034304 defendant Mynne Nicholas esq 588872 588872 Mynne, Nicholas, of Parva Walsyngham, Norf, esq 0
4027554 2034501 2034501 defendant Fuller John poulter 588872 588872 Fuller, John, of Parva Walsyngham, Norf, poulter 0
4094672 2058432 2058432 defendant Mynne Nicholas esq 588872 588872 Mynne, Nicholas, of Parva Walsyngham, Norf, esq 0
4146731 2077009 2077009 defendant Mynne Nicholas esq 588872 588872 Mynne, Nicholas, of Parva Walsyngham, Norf, esq 0
4658741 2248608 2248608 defendant Lavender Thomas woolman 588872 588872 Lavender, Thomas, of Parva Walsyngham, Norf, woolman 0
5014108 2360978 2360978 defendant Denham Geoffrey yeoman 588872 588872 Denham, Geoffrey, of Parva Walsyngham, Norf, yeoman 0
5073012 2378414 2378414 defendant Caunceler James yeoman 588872 588872 Caunceler, James, of Parva Walsyngham, Norf, yeoman 1
5091938 2384022 2384022 defendant Denham Thomas mercer 588872 588872 Denham, Thomas, of Parva Walsyngham, Norf, mercer 2
5095116 2384988 2384988 defendant Denham Geoffrey chapman 588872 588872 Denham, Geoffrey, of Parva Walsyngham, Norf, chapman 3
5220436 2421673 2421673 defendant Gylys John chapman 588872 588872 Gylys, John, of Parva Walsyngham, Norf, chapman 2
5242108 2427892 2427892 defendant Gylys Thomas chapman 588872 588872 Gylys, Thomas, of Parva Walsyngham, Norf, chapman 0
5242118 2427896 2427896 defendant Gylys Thomas chapman 588872 588872 Gylys, Thomas, of Parva Walsyngham, Norf, chapman 0
5286744 2441130 2441130 defendant Oxclyf Thomas gent 588872 588872 (Oxclyf, Thomas, of Parva Walsyngham, Norf, gent 1
5313062 2448939 2448939 defendant Osbern John gent 588872 588872 Osbern, John, of Parva Walsyngham, Norf, gent 1
5313065 2448940 2448940 defendant Osbern John gent 588872 588872 Osbern, John, of Parva Walsyngham, Norf, gent 1
5321784 2451589 2451589 defendant Dene Robert clerk 588872 588872 Dene, Robert, of Parva Walsyngham, Norf, clerk 0
5325992 2452865 2452865 defendant Seveyer John yeoman 588872 588872 Seveyer, John, of Parva Walsyngham, Norf, yeoman 0
5359549 2463022 2463022 defendant Gyles John chapman 588872 588872 Gyles, John, of Parva Walsyngham, Norf, chapman 0
5483958 2500138 2500138 defendant Fuller William yeoman 588872 588872 Fuller, William, of Parva Walsyngham, Norf, yeoman 0
5486874 2500973 2500973 defendant Grene Richard yeoman 588872 588872 Grene, Richard, of Parva Walsyngham, Norf, yeoman 1
5518982 2510779 2510779 defendant Gresham William gent 588872 588872 Gresham, William, of Parva Walsyngham, Norf, gent 0
5520402 2511202 2511202 defendant Copynger Richard innholder 588872 588872 Copynger, Richard, of Parva Walsyngham, Norf, innholder 0
5531353 2514328 2514328 defendant Copynger Richard innholder 588872 588872 Copynger, Richard, of Parva Walsyngham, Norf, innholder 0
5534499 2515337 2515337 defendant Gresham William gent 588872 588872 Gresham, William, of Parva Walsyngham, Norf, gent 0
5534501 2515338 2515338 defendant Gresham William gent 588872 588872 Gresham, William, of Parva Walsyngham, Norf, gent 0
5534514 2515342 2515342 defendant Gresham William gent 588872 588872 Gresham, William, of Parva Walsyngham, Norf, gent 0
5537626 2516257 2516257 defendant Gresham William gent 588872 588872 Gresham, William, of Parva Walsyngham, Norf, gent 0
5545438 2518655 2518655 defendant Longe Simon glover 588872 588872 Longe, Simon, of Parva Walsyngham, Norf, glover 1
5550931 2520306 2520306 defendant Gresham William yeoman 588872 588872 Gresham, William, of Parva Walsyngham, Norf, yeoman 0
5567146 2524970 2524970 defendant Gresham William gent 588872 588872 Gresham, William, of Parva Walsyngham, Norf, gent 4
5567151 2524971 2524971 defendant Gresham William gent 588872 588872 Gresham, William, of Parva Walsyngham, Norf, gent 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);