names

33 rows where place_id = 599200

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3635710 1905969 1905969 defendant Banke Richard gent 599200 599200 Banke, Richard, of Lekynfeld, gent 0
3643068 1908274 1908274 defendant Cray William husbandman 599200 599200 Cray, William, of Lekynfeld, husbandman 1
3663614 1914550 1914550 defendant Tenaunt Robert yeoman 599200 599200 Tenaunt, Robert, of Lekynfeld, yeoman 0
3663616 1914551 1914551 defendant Tenaunt Robert yeoman 599200 599200 Tenaunt, Robert, of Lekynfeld, yeoman 0
3694465 1924475 1924475 defendant Swynburn Ralph gent 599200 599200 Swynburn, Ralph, of Lekynfeld, gent 0
3694466 1924475 1924475 defendant Bell Thomas husbandman 599200 599200 Bell, Thomas, of Lekynfeld, husbandman 1
3694467 1924475 1924475 defendant Williamson Richard husbandman 599200 599200 Williamson, Richard, of Lekynfeld, husbandman 2
3694468 1924475 1924475 defendant Stephynson John husbandman 599200 599200 Stephynson, John, of Lekynfeld, husbandman 3
3694470 1924476 1924476 defendant Swynburn Ralph gent 599200 599200 Swynburn, Ralph, of Lekynfeld, gent 0
3694471 1924476 1924476 defendant Bell Thomas husbandman 599200 599200 Bell, Thomas, of Lekynfeld, husbandman 1
3694472 1924476 1924476 defendant Williamson Richard husbandman 599200 599200 Williamson, Richard, of Lekynfeld, husbandman 2
3694473 1924476 1924476 defendant Stephynson John husbandman 599200 599200 Stephynson, John, of Lekynfeld, husbandman 3
3767825 1947574 1947574 defendant Swynborn Ralph gent 599200 599200 Swynborn, Ralph, of Lekynfeld, gent 0
3785525 1953262 1953262 defendant Swynborn Ralph gent 599200 599200 Swynborn, Ralph, of Lekynfeld, gent 1
3785527 1953263 1953263 defendant Swynborn Ralph gent 599200 599200 Swynborn, Ralph, of Lekynfeld, gent 0
3824845 1965650 1965650 defendant Typpyllyng Roger yeoman 599200 599200 Typpyllyng, Roger, of Lekynfeld, yeoman 0
4735575 2276279 2276279 plaintiff Starky William   599200 599200 Starky, William, of Lekynfeld 0
4891045 2323940 2323940 defendant Lokyngton William laborer 599200 599200 Lokyngton, William, of Lekynfeld, laborer 0
4926065 2334581 2334581 defendant Thweyng John yeoman 599200 599200 Thweyng, John, of Lekynfeld, yeoman 0
5011448 2360213 2360213 defendant Walker Thomas walker 599200 599200 Walker, Thomas, of Lekynfeld, walker 2
5085958 2382286 2382286 defendant Johnson Ricard yeoman 599200 599200 Johnson, Ricard, of Lekynfeld, yeoman 1
5097575 2385722 2385722 defendant Dewethorp Richard yeoman 599200 599200 Dewethorp, Richard, of Lekynfeld, yeoman 0
5138624 2397792 2397792 defendant Dun Alan   599200 599200 Dun, Alan, of Lekynfeld 0
5213161 2419580 2419580 defendant Eware William merchant 599200 599200 Eware, William, of Lekynfeld, merchant 1
5291103 2442401 2442401 defendant Whitehede William yeoman 599200 599200 Whitehede, William, of Lekynfeld, yeoman 0
5291104 2442401 2442401 defendant Dauson or Danson Robert husbandman 599200 599200 Dauson or Danson, Robert, of Lekynfeld, husbandman 1
5312203 2448684 2448684 defendant Tempest Lawrence gent 599200 599200 Tempest, Lawrence, of Lekynfeld, gent 1
5312204 2448684 2448684 defendant Tempest Henry gent 599200 599200 Tempest, Henry, of Lekynfeld, gent 2
5312208 2448685 2448685 defendant Tempest Lawrence gent 599200 599200 Tempest, Lawrence, of Lekynfeld, gent 1
5312209 2448685 2448685 defendant Tempest Henry gent 599200 599200 Tempest, Henry, of Lekynfeld, gent 2
5365047 2464738 2464738 defendant Don John yeoman 599200 599200 Don, John, of Lekynfeld, yeoman 1
5570364 2525901 2525901 defendant Smyth Henry miller 599200 599200 Smyth, Henry, of Lekynfeld, miller 1
5630922 2553683 2553683 defendant Smyth John   599200 599200 Smyth, John, of Lekynfeld, "theker" or thatcher 6

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