names

24 rows where place_id = 598403

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3632310 1904925 1904925 defendant Dene Thomas kendalman 598403 598403 Dene, Thomas, of Skypton, kendalman 1
3702561 1927070 1927070 defendant Langskar Thomas husbandman 598403 598403 Langskar, Thomas, of Skypton, husbandman 0
3702562 1927070 1927070 defendant Elys John husbandman 598403 598403 Elys, John, of Skypton, husbandman 1
3702563 1927070 1927070 defendant Godion Robert mercer 598403 598403 Godion, Robert, of Skypton, mercer 2
3702564 1927070 1927070 defendant Armytstede John husbandman 598403 598403 Armytstede, John, of Skypton, husbandman 3
3750159 1941966 1941966 defendant Smyth William   598403 598403 Smyth, William, of Skypton, laborer, servant of Armytstede, John 0
3765461 1946863 1946863 defendant Lambart Christopher yeoman 598403 598403 Lambart, Christopher, of Skypton, yeoman 1
3765462 1946863 1946863 defendant Kytchyn Thomas yeoman 598403 598403 Kytchyn, Thomas, of Skypton, yeoman 2
3819308 1963926 1963926 defendant Lambart John   598403 598403 Lambart, John, of Skypton 0
3837708 1969707 1969707 defendant Blakburn William clerk 598403 598403 Blakburn, William, of Skypton, clerk 1
3915399 1995517 1995517 defendant Iveson John yeoman or chapman 598403 598403 Iveson, John, of Skypton, yeoman or chapman 2
3997939 2024021 2024021 defendant Fyssher Richard husbandman 598403 598403 Fyssher, Richard, of Skypton, husbandman 1
4036164 2037618 2037618 plaintiff Houltbye Nicholas   598403 598403 Houltbye, Nicholas, of Skypton 0
4167666 2084186 2084186 defendant Prockter Marmaduke yeoman 598403 598403 Prockter, Marmaduke, of Skypton, yeoman 4
4170386 2085136 2085136 defendant Moyses Brian dyer 598403 598403 Moyses, Brian, of Skypton, dyer 0
4177327 2087542 2087542 defendant Mankenholes John blacksmith 598403 598403 Mankenholes, John, of Skypton, blacksmith 1
4359966 2150728 2150728 defendant Dixon Stephen yeoman 598403 598403 Dixon, Stephen, of Skypton, yeoman 0
4365918 2152849 2152849 defendant Mitchell William shoemaker 598403 598403 Mitchell, William, of Skypton, shoemaker 1
4412012 2168609 2168609 defendant Paley Roger husbandman 598403 598403 Paley, Roger, of Skypton, husbandman 3
4535434 2211355 2211355 defendant Smyth Robert   598403 598403 Smyth, Robert, of Skypton 0
4741431 2277988 2277988 defendant Garth William esq 598403 598403 Garth, William, of Skypton, esq 0
5119215 2392046 2392046 defendant Dunyng Thomas yeoman 598403 598403 Dunyng, Thomas, of Skypton, yeoman 2
5241584 2427739 2427739 defendant Forster Thomas yeoman 598403 598403 Forster, Thomas, of Skypton, yeoman 2
5540803 2517254 2517254 defendant Smyth Alice widow 598403 598403 Smyth, Alice, of Skypton, widow 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);