names

49 rows where place_id = 614833

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3705769 1928085 1928085 defendant Dowsse Henry husbandman 614833 614833 Dowsse, Henry, of Graystok, husbandman 1
3953228 2008195 2008195 defendant Wynder John husbandman 614833 614833 Wynder, John, of Graystok, Cumber, husbandman 0
4468153 2190713 2190713 plaintiff Barone Ralph   614833 614833 Barone, Ralph, of Graystok 0
4517632 2205903 2205903 defendant Smyth John   614833 614833 Smyth, John, of Graystok 3
4544152 2214085 2214085 plaintiff Bare Ralph   614833 614833 Bare, Ralph, of Graystok 0
4545803 2214617 2214617 defendant Clibburn Thomas de   614833 614833 Clibburn, Thomas de, of Graystok 0
4648805 2245709 2245709 defendant Symondson Thomas   614833 614833 Symondson, Thomas, of Graystok 0
4648808 2245710 2245710 defendant Symondson Thomas   614833 614833 Symondson, Thomas, of Graystok 0
4659227 2248758 2248758 defendant Marsshall William husbandman 614833 614833 Marsshall, William, of Graystok, husbandman 0
4659228 2248758 2248758 defendant Marsshall Nicholas husbandman 614833 614833 Marsshall, Nicholas, of Graystok, husbandman 1
4663707 2250132 2250132 defendant Peper Robert Cumber yeoman 614833 614833 Peper, Robert, of Graystok, Cumber yeoman 0
4663708 2250132 2250132 defendant Ibbotson William Atkynson yeoman 614833 614833 Ibbotson, William Atkynson, of Graystok, yeoman 1
4676119 2258144 2258144 defendant Clibburne Thomas de yeoman 614833 614833 Clibburne, Thomas de, of Graystok, yeoman 1
4678591 2258910 2258910 defendant Kirkeby John de gent 614833 614833 Kirkeby, John de, of Graystok, gent 0
4678592 2258910 2258910 defendant Langhous Walter yeoman 614833 614833 Langhous, Walter, of Graystok, yeoman 1
4693322 2263414 2263414 plaintiff Barom John   614833 614833 Barom, John, of Graystok 0
4705121 2266974 2266974 defendant Clyburn John tailor 614833 614833 Clyburn, John, of Graystok, tailor 0
4724802 2273054 2273054 defendant Symondson Thomas yeoman 614833 614833 Symondson, Thomas, of Graystok, yeoman 0
4739723 2277501 2277501 plaintiff Aglyonby Adam de Master of the College 614833 614833 Aglyonby, Adam de, of Graystok, Master of the College, on his own account 0
4740541 2277747 2277747 plaintiff Baro John   614833 614833 Baro, John, of Graystok 0
4760357 2283593 2283593 defendant Clyburn Thomas yeoman 614833 614833 Clyburn, Thomas, of Graystok, yeoman 0
4760358 2283593 2283593 defendant Penok Richard yeoman 614833 614833 Penok, Richard, of Graystok, yeoman 1
4778324 2289206 2289206 defendant Ogle Robert yeoman 614833 614833 Ogle, Robert, of Graystok, Cumber, yeoman 3
4778325 2289206 2289206 defendant Saumon John yeoman 614833 614833 Saumon, John, of Graystok, yeoman 4
4778332 2289206 2289206 defendant Wilson John Robynson yeoman 614833 614833 Wilson, John Robynson, of Graystok, yeoman 11
4778825 2289351 2289351 defendant Bank Richard yeooman 614833 614833 Bank, Richard, of Graystok, Cumber, yeooman 0
4790578 2293141 2293141 defendant Ogle Robert yeoman 614833 614833 Ogle, Robert, of Graystok, yeoman 3
4790579 2293141 2293141 defendant Saumon John yeoman 614833 614833 Saumon, John, of Graystok, yeoman 4
4790586 2293141 2293141 defendant Wilson John Robynson yeoman 614833 614833 Wilson, John Robynson, of Graystok, yeoman 11
4799074 2295885 2295885 defendant Symondson Thomas mercer 614833 614833 Symondson, Thomas, of Graystok, mercer 2
4799161 2295915 2295915 defendant Hudson William yeoman 614833 614833 Hudson, William, of Graystok, Cumber, yeoman 0
4848671 2311056 2311056 defendant Byggobynk William laborer 614833 614833 Byggobynk, William, of Graystok, laborer 0
4876340 2319561 2319561 defendant Biggebynk William laborer 614833 614833 together with Biggebynk, William, of Graystok, laborer 7
4892280 2324322 2324322 defendant Pennok Roger   614833 614833 Pennok, Roger, of Graystok, mason 0
4965100 2346486 2346486 defendant Nanson John husbandman 614833 614833 Nanson, John, of Graystok, husbandman 1
4973601 2349058 2349058 defendant Hudson William yeoman 614833 614833 Hudson, William, of Graystok, yeoman 0
4980906 2351225 2351225 defendant Hudson William yeoman 614833 614833 Hudson, William, of Graystok, yeoman 3
4981146 2351293 2351293 defendant Hudson William yeoman 614833 614833 Hudson, William, of Graystok, yeoman 0
4981150 2351293 2351293 defendant Chamberlayn William yeoman 614833 614833 together with Chamberlayn, William, of Graystok, yeoman 4
4992748 2354713 2354713 defendant Gilbank Robert yeoman 614833 614833 Gilbank, Robert, of Graystok, yeoman 3
5370483 2466352 2466352 plaintiff Graystok Ralph   614833 614833 Graystok, Ralph, of Graystok, knight 0
5413915 2479091 2479091 plaintiff Graystok Ralph   614833 614833 Graystok, Ralph, of Graystok, knight 0
5455494 2491554 2491554 defendant Graystok Ralph   614833 614833 Graystok, Ralph, of Graystok, knight 0
5455500 2491555 2491555 defendant Graystok Ralph   614833 614833 Graystok, Ralph, of Graystok, knight 0
5455506 2491556 2491556 defendant Graystok Ralph   614833 614833 Graystok, Ralph, of Graystok, knight 0
5455512 2491557 2491557 defendant Graystok Ralph   614833 614833 Graystok, Ralph, of Graystok, knight 0
5509891 2507933 2507933 defendant Moresby James gent 614833 614833 Moresby, James, of Graystok, Cumber, gent 0
5509896 2507934 2507934 defendant Morysby James gent 614833 614833 Morysby, James, of Graystok, Cumber, gent 0
5624772 2551680 2551680 defendant Grenehowe Thomas yeoman 614833 614833 Grenehowe, Thomas, of Graystok, yeoman 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);