names

54 rows where place_id = 610990

✎ 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
3686184 1921841 1921841 defendant Lyngock John yeoman 610990 610990 Lyngock, John, of Terryngton, yeoman 1
3720908 1932834 1932834 defendant Knyght John chaplain 610990 610990 Knyght, John, of Terryngton, chaplain 0
3927680 1999595 1999595 plaintiff Baker Cecilia widow 610990 610990 Baker, Cecilia, of Terryngton, widow 0
3927684 1999597 1999597 plaintiff Baker Cecily widow 610990 610990 Baker, Cecily, of Terryngton, widow 0
3927688 1999598 1999598 defendant Caunaby Richard husbandman 610990 610990 Caunaby, Richard, of Terryngton, husbandman 1
3996062 2023345 2023345 plaintiff Dalahey John yeoman 610990 610990 Dalahey, John, of Terryngton, yeoman 0
4024736 2033530 2033530 defendant Sedeby Henry husbandman 610990 610990 Sedeby, Henry, of Terryngton, husbandman 0
4024737 2033530 2033530 defendant Cannon Robert husbandman 610990 610990 Cannon, Robert, of Terryngton, husbandman 1
4033777 2036730 2036730 defendant Cater William gent 610990 610990 Cater, William, of Terryngton, gent 0
4036179 2037623 2037623 defendant Morres Thomas yeoman 610990 610990 Morres, Thomas, of Terryngton, yeoman 0
4036192 2037626 2037626 defendant Morres Thomas yeoman 610990 610990 Morres, Thomas, of Terryngton, yeoman 0
4038486 2038406 2038406 plaintiff Lawson Roger yeoman 610990 610990 Lawson, Roger, of Terryngton, yeoman 0
4044638 2040531 2040531 defendant Herynne Robert husbandman 610990 610990 Herynne, Robert, of Terryngton, husbandman 0
4044639 2040531 2040531 defendant Marion Vincent husbandman 610990 610990 Marion, Vincent, of Terryngton, husbandman 1
4062672 2046948 2046948 defendant Lynghook William gent 610990 610990 Lynghook, William, of Terryngton, gent 1
4065658 2048005 2048005 defendant Harryson Humphrey husbandman 610990 610990 Harryson, Humphrey, of Terryngton, husbandman 3
4074875 2051315 2051315 defendant Vyncent John husbandman 610990 610990 Vyncent, John, of Terryngton, husbandman 0
4074877 2051316 2051316 defendant Shorte William husbandman 610990 610990 Shorte, William, of Terryngton, husbandman 0
4074878 2051316 2051316 defendant Smyth William husbandman 610990 610990 Smyth, William, of Terryngton, husbandman 1
4076409 2051858 2051858 defendant Hargrave Richard husbandman 610990 610990 (Hargrave, Richard, of Terryngton, husbandman 2
4076412 2051859 2051859 defendant Dommyngton or Dounnyngton Thomas clerk 610990 610990 Dommyngton or Dounnyngton, Thomas, of Terryngton, clerk 1
4076413 2051859 2051859 defendant Hargrave Richard husbandman 610990 610990 Hargrave, Richard, of Terryngton, husbandman 2
4086130 2055313 2055313 defendant Boston William husbandman 610990 610990 Boston, William, of Terryngton, husbandman 0
4096210 2058972 2058972 defendant Lynsey Gilbert laborer 610990 610990 Lynsey, Gilbert, of Terryngton, laborer 1
4109372 2063614 2063614 defendant Wylcocke Richard husbandman 610990 610990 Wylcocke, Richard, of Terryngton, husbandman 0
4111957 2064526 2064526 defendant Saborne John husbandman 610990 610990 Saborne, John, of Terryngton, husbandman 0
4144661 2076291 2076291 defendant Thacker William husbandman 610990 610990 Thacker, William, of Terryngton, husbandman 0
4147625 2077309 2077309 defendant Marrett Thomas husbandman 610990 610990 Marrett, Thomas, of Terryngton, husbandman 1
4172563 2085863 2085863 defendant Hargrave Richard husbandman 610990 610990 Hargrave, Richard, of Terryngton, husbandman 1
4172568 2085865 2085865 defendant Howlett William yeoman 610990 610990 Howlett, William, of Terryngton, yeoman 0
4172577 2085867 2085867 defendant Wiles Marmaduke husbandman 610990 610990 Wiles, Marmaduke, of Terryngton, husbandman 1
4173457 2086173 2086173 defendant Rychars alias Glover Mathew husbandman 610990 610990 Rychars alias Glover, Mathew, of Terryngton, husbandman 0
4173458 2086173 2086173 defendant Fryett Francis husbandman 610990 610990 Fryett, Francis, of Terryngton, husbandman 1
4173459 2086173 2086173 defendant Hewett Humphrey husbandman 610990 610990 Hewett, Humphrey, of Terryngton, husbandman 2
4173460 2086173 2086173 defendant Sey Robert husbandman 610990 610990 Sey, Robert, of Terryngton, husbandman 3
4202843 2096539 2096539 defendant Heydon Christopher husbandman 610990 610990 Heydon, Christopher, of Terryngton, husbandman 2
4202844 2096539 2096539 defendant Harryson Henry husbandman 610990 610990 Harryson, Henry, of Terryngton, husbandman 3
4255803 2114915 2114915 defendant Lawson William yeoman 610990 610990 Lawson, William, of Terryngton, yeoman 0
4255804 2114915 2114915 defendant Rychard Andrew yeoman 610990 610990 Rychard, Andrew, of Terryngton, yeoman 1
4259558 2116174 2116174 defendant Harvyle Robert yeoman 610990 610990 Harvyle, Robert, of Terryngton, yeoman 0
4259559 2116174 2116174 defendant Dalyhaye Ralph gent 610990 610990 Dalyhaye, Ralph, of Terryngton, gent 1
4259997 2116314 2116314 defendant Burton Edward husbandman 610990 610990 Burton, Edward, of Terryngton, husbandman 0
4328172 2139737 2139737 defendant Rytches John yeoman 610990 610990 Rytches, John, of Terryngton, yeoman 3
4345695 2145763 2145763 defendant Ludlam John yeoman 610990 610990 Ludlam, John, of Terryngton, yeoman 0
4393345 2162376 2162376 defendant Pelham John husbandman 610990 610990 Pelham, John, of Terryngton, husbandman 2
4398998 2164247 2164247 defendant Clarke Joan widow 610990 610990 Clarke, Joan, of Terryngton, widow 1
4410760 2168189 2168189 defendant Lawson William husbandman 610990 610990 Lawson, William, of Terryngton, husbandman 0
4410761 2168189 2168189 defendant Rawlyn John husbandman 610990 610990 Rawlyn, John, of Terryngton, husbandman 1
4410762 2168189 2168189 defendant Elger Thomas husbandman 610990 610990 Elger, Thomas, of Terryngton, husbandman 2
4410763 2168189 2168189 defendant Ludlam John husbandman 610990 610990 Ludlam, John, of Terryngton, husbandman 3
4410913 2168240 2168240 defendant Robynson William husbandman 610990 610990 Robynson, William, of Terryngton, husbandman 0
4410914 2168240 2168240 defendant Robynson John husbandman 610990 610990 Robynson, John, of Terryngton, husbandman 1
4411601 2168474 2168474 defendant Boston Michael husbandman 610990 610990 Boston, Michael, of Terryngton, husbandman 1
4412636 2168815 2168815 defendant Delahay Ralph gent 610990 610990 Delahay, Ralph, of Terryngton, gent 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);