names

65 rows where place_id = 611454

✎ 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
3688482 1922552 1922552 defendant Dawen Thomas husbandman 611454 611454 Dawen, Thomas, of Terrington, husbandman 2
4038487 2038406 2038406 defendant Rychars alias Glover John yeoman 611454 611454 Rychars alias Glover, John, of Terrington, yeoman 0
4084878 2054870 2054870 defendant Boston William yeoman 611454 611454 Boston, William, of Terrington, yeoman 0
4084879 2054870 2054870 defendant Rythers alias Glover Mathew yeoman 611454 611454 Rythers alias Glover, Mathew, of Terrington, yeoman 1
4111958 2064526 2064526 defendant Bovye Vincent husbandman 611454 611454 Bovye, Vincent, of Terrington, husbandman 1
4111959 2064526 2064526 defendant Taylor John husbandman 611454 611454 Taylor, John, of Terrington, husbandman 2
4111960 2064526 2064526 defendant Lawson Richard yeoman 611454 611454 Lawson, Richard, of Terrington, yeoman 3
4112945 2064897 2064897 defendant Richars alias Glover John yeoman 611454 611454 Richars alias Glover, John, of Terrington, yeoman 0
4125844 2069528 2069528 defendant Lawson Richard, senior yeoman 611454 611454 Lawson, Richard, senior, of Terrington, yeoman 0
4128720 2070567 2070567 defendant Cole John husbandman 611454 611454 Cole, John, of Terrington, husbandman 2
4139684 2074555 2074555 defendant Boston William husbandman 611454 611454 Boston, William, of Terrington, husbandman 2
4144492 2076236 2076236 defendant Harvye Robert yeoman 611454 611454 Harvye, Robert, of Terrington, yeoman 0
4144493 2076236 2076236 defendant Heasell Hugh husbandman 611454 611454 Heasell, Hugh, of Terrington, husbandman 1
4149044 2077786 2077786 defendant Lawson Richard, senior yeoman 611454 611454 Lawson, Richard, senior, of Terrington, yeoman 0
4155203 2079913 2079913 defendant Elgar Thomas husbandman 611454 611454 Elgar, Thomas, of Terrington, husbandman 0
4159118 2081260 2081260 defendant Boston William husbandman 611454 611454 Boston, William, of Terrington, husbandman 0
4162304 2082376 2082376 defendant Boston William husbandman 611454 611454 Boston, William, of Terrington, husbandman 1
4169375 2084792 2084792 defendant Durrant Geoffrey husbandman 611454 611454 Durrant, Geoffrey, of Terrington, husbandman 2
4169376 2084792 2084792 defendant Elgar Richard husbandman 611454 611454 Elgar, Richard, of Terrington, husbandman 3
4186240 2090673 2090673 defendant Lawson Richard, senior yeoman 611454 611454 Lawson, Richard, senior, of Terrington, yeoman 0
4194694 2093701 2093701 defendant Harrison Roger husbandman 611454 611454 Harrison, Roger, of Terrington, husbandman 1
4194695 2093701 2093701 defendant Heddon John husbandman 611454 611454 Heddon, John, of Terrington, husbandman 2
4194696 2093701 2093701 defendant Wilcocke Richard (legal representative) 611454 611454 Wilcocke, Richard, of Terrington, tailor, executrix of 3
4194697 2093701 2093701 defendant Wilcocke Alice widow 611454 611454 Wilcocke, Alice, of Terrington, widow 4
4195758 2094070 2094070 defendant Hargrave Richard husbandman 611454 611454 Hargrave, Richard, of Terrington, husbandman 1
4195763 2094072 2094072 defendant Howlett William yeoman 611454 611454 Howlett, William, of Terrington, yeoman 0
4195869 2094110 2094110 defendant Walbutt Thomas yeoman 611454 611454 Walbutt, Thomas, of Terrington, yeoman 0
4201106 2095937 2095937 defendant Elgar Thomas husbandman 611454 611454 Elgar, Thomas, of Terrington, husbandman 3
4203484 2096772 2096772 defendant Heasell Hugh husbandman 611454 611454 Heasell, Hugh, of Terrington, husbandman 0
4203485 2096772 2096772 defendant Harvye William husbandman 611454 611454 Harvye, William, of Terrington, husbandman 1
4203486 2096772 2096772 defendant Rychers Mathew husbandman 611454 611454 Rychers, Mathew, of Terrington, husbandman 2
4203487 2096772 2096772 defendant Heddon John husbandman 611454 611454 Heddon, John, of Terrington, husbandman 3
4207097 2098026 2098026 defendant Boston Humphrey husbandman 611454 611454 Boston, Humphrey, of Terrington, husbandman 0
4209948 2099042 2099042 defendant Lawson Richard, senior yeoman 611454 611454 Lawson, Richard, senior, of Terrington, yeoman 1
4211520 2099584 2099584 defendant Boston William husbandman 611454 611454 Boston, William, of Terrington, husbandman 0
4217549 2101631 2101631 defendant Lawson Richard yeoman 611454 611454 Lawson, Richard, of Terrington, yeoman 0
4220776 2102763 2102763 defendant Delahaye Ralph yeoman 611454 611454 Delahaye, Ralph, of Terrington, yeoman 0
4229523 2105813 2105813 defendant Delahaye Ralph yeoman 611454 611454 Delahaye, Ralph, of Terrington, yeoman 0
4247812 2112253 2112253 defendant Nicolson Robert yeoman 611454 611454 Nicolson, Robert, of Terrington, yeoman 1
4247815 2112254 2112254 defendant Nicolson Robert yeoman 611454 611454 Nicolson, Robert, of Terrington, yeoman 1
4252358 2113782 2113782 defendant Richers John yeoman 611454 611454 Richers, John, of Terrington, yeoman 0
4252359 2113782 2113782 defendant Lawson Richard yeoman 611454 611454 Lawson, Richard, of Terrington, yeoman 1
4252360 2113782 2113782 defendant Heddon John yeoman 611454 611454 Heddon, John, of Terrington, yeoman 2
4259495 2116152 2116152 defendant Richers John yeoman 611454 611454 Richers, John, of Terrington, yeoman 0
4259555 2116173 2116173 defendant Delahaye Robert gent 611454 611454 Delahaye, Robert, of Terrington, gent 0
4278150 2122293 2122293 defendant Richers alias Glover John yeoman 611454 611454 Richers alias Glover, John, of Terrington, yeoman 0
4278152 2122294 2122294 defendant Wardall Robert yeoman 611454 611454 Wardall, Robert, of Terrington, yeoman 0
4290140 2126542 2126542 defendant Fyske George yeoman 611454 611454 Fyske, George, of Terrington, yeoman 0
4290141 2126542 2126542 defendant Wardell Robert yeoman 611454 611454 Wardell, Robert, of Terrington, yeoman 1
4290143 2126542 2126542 defendant Webster Philip thatcher 611454 611454 Webster, Philip, of Terrington, thatcher 3
4310800 2133920 2133920 defendant Pull William husbandman 611454 611454 Pull, William, of Terrington, husbandman 3
4380474 2158128 2158128 defendant Harvy Robert yeoman 611454 611454 Harvy, Robert, of Terrington, yeoman 0
4383732 2159269 2159269 defendant Delahaye Ralph gent 611454 611454 Delahaye, Ralph, of Terrington, gent 0
4383733 2159269 2159269 defendant Whereas or Wheriwas Robert yeoman 611454 611454 Whereas or Wheriwas, Robert, of Terrington, yeoman 1
4388622 2160833 2160833 defendant Delahaye Ralph gent 611454 611454 Delahaye, Ralph, of Terrington, gent 0
4393343 2162376 2162376 defendant Bamford Nicholas husbandman 611454 611454 Bamford, Nicholas, of Terrington, husbandman 0
4393344 2162376 2162376 defendant Elgar Thomas husbandman 611454 611454 Elgar, Thomas, of Terrington, husbandman 1
4395033 2162923 2162923 defendant Person Reginald husbandman 611454 611454 Person, Reginald, of Terrington, husbandman 0
4395034 2162923 2162923 defendant Hawdon Christopher husbandman 611454 611454 Hawdon, Christopher, of Terrington, husbandman 1
4398699 2164144 2164144 defendant Lawson Richard yeoman 611454 611454 Lawson, Richard, of Terrington, yeoman 0
4406403 2166707 2166707 defendant Wherewas Robert yeoman 611454 611454 Wherewas, Robert, of Terrington, yeoman 2
4406404 2166707 2166707 defendant Rockbye John yeoman 611454 611454 Rockbye, John, of Terrington, yeoman 3
4410047 2167967 2167967 defendant Lallam Brice husbandman 611454 611454 Lallam, Brice, of Terrington, husbandman 0
4410062 2167970 2167970 defendant Bamford of Banford Nicholas husbandman 611454 611454 Bamford of Banford, Nicholas, of Terrington, husbandman 3
4410834 2168213 2168213 defendant Richer alias Glover John yeoman 611454 611454 Richer alias Glover, John, of Terrington, yeoman 1

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