names

42 rows where place_id = 611613

✎ 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
3682679 1920687 1920687 plaintiff Thwaites Henry (legal representative) 611613 611613 Thwaites, Henry, of Lund, knight, executrix of 0
3682683 1920688 1920688 plaintiff Thwaites Henry (legal representative) 611613 611613 Thwaites, Henry, of Lund, knight, executrix of 0
3682687 1920689 1920689 plaintiff Thwaites Henry (legal representative) 611613 611613 Thwaites, Henry, of Lund, knight, executrix of 0
3682690 1920690 1920690 plaintiff Thwaites Henry (legal representative) 611613 611613 Thwaites, Henry, of Lund, knight, executrix of 0
3682693 1920691 1920691 plaintiff Thwaites Henry (legal representative) 611613 611613 Thwaites, Henry, of Lund, knight, executrix of 0
3682697 1920692 1920692 plaintiff Thwaites Henry (legal representative) 611613 611613 Thwaites, Henry, of Lund, knight, executrix of 0
3682701 1920693 1920693 plaintiff Thwaites Henry (legal representative) 611613 611613 Thwaites, Henry, of Lund, knight, executrix of 0
3682705 1920694 1920694 plaintiff Thwaites Henry (legal representative) 611613 611613 Thwaites, Henry, of Lund, knight, executrix of 0
3689196 1922786 1922786 defendant Carter Roger clerk 611613 611613 Carter, Roger, of Lund, clerk 0
4500092 2200675 2200675 defendant Alman John   611613 611613 Alman, John, of Lund 0
4500105 2200676 2200676 defendant Seton Robert   611613 611613 Seton, Robert, of Lund, junior 0
4506209 2202447 2202447 defendant Seton Robert de, junior   611613 611613 Seton, Robert de, junior, of Lund 0
4506210 2202447 2202447 defendant Harpham Robert   611613 611613 Harpham, Robert, of Lund 1
4506211 2202447 2202447 defendant Bard John   611613 611613 Bard, John, of Lund 2
4506213 2202447 2202447 defendant Milner Roger   611613 611613 Milner, Roger, of Lund 4
4506218 2202448 2202448 defendant Seton Robert, junior   611613 611613 Seton, Robert, junior, of Lund 0
4506219 2202448 2202448 defendant Harpham R--   611613 611613 Harpham, R--, of Lund 1
4506220 2202448 2202448 defendant Bard John   611613 611613 Bard, John, of Lund 2
4506222 2202448 2202448 defendant Milner Roger   611613 611613 Milner, Roger, of Lund 4
4506223 2202448 2202448 defendant (illegible) Thomas   611613 611613 ---, Thomas, of Lund 5
4525868 2208388 2208388 defendant Alaynson John   611613 611613 Alaynson, John, of Lund 0
4556947 2218102 2218102 defendant Shephird Thomas   611613 611613 Shephird, Thomas, of Lund 0
4677919 2258711 2258711 defendant Teryngton John husbandman 611613 611613 Teryngton, John, of Lund, husbandman 0
4720220 2271668 2271668 defendant Alanson John husbandman 611613 611613 Alanson, John, of Lund, husbandman 2
4744414 2278889 2278889 defendant Ake William husbandman 611613 611613 Ake, William, of Lund, husbandman 0
4744415 2278889 2278889 defendant Kaa William husbandman 611613 611613 Kaa, William, of Lund, husbandman 1
4744416 2278889 2278889 defendant Wathe William husbandman 611613 611613 Wathe, William, of Lund, husbandman 2
4744418 2278889 2278889 defendant Alan William husbandman 611613 611613 Alan, William, of Lund, husbandman 4
4744419 2278889 2278889 defendant Alan John husbandman 611613 611613 Alan, John, of Lund, husbandman 5
4744420 2278889 2278889 defendant Fraeman William husbandman 611613 611613 Fraeman, William, of Lund, husbandman 6
4744421 2278889 2278889 defendant Noroton John husbandman 611613 611613 Noroton, John, of Lund, husbandman 7
4744422 2278889 2278889 defendant Stare William husbandman 611613 611613 Stare, William, of Lund, husbandman 8
4744423 2278889 2278889 defendant Serle William husbandman 611613 611613 Serle, William, of Lund, husbandman 9
4744424 2278889 2278889 defendant Seton William husbandman 611613 611613 Seton, William, of Lund, husbandman 10
4744425 2278889 2278889 defendant Wryght Matilda widow & formerly wife of William Wryght 611613 611613 Wryght, Matilda, of Lund, widow & formerly wife of William Wryght 11
4744426 2278889 2278889 defendant Norton Matilda widow 611613 611613 Norton, Matilda, of Lund, widow 12
4772236 2287289 2287289 defendant Flesshewer Richard husbandman 611613 611613 Flesshewer, Richard, of Lund, husbandman 0
4848720 2311067 2311067 defendant Canton Robert husbandman 611613 611613 Canton, Robert, of Lund, husbandman 1
4878741 2320288 2320288 defendant Sywardby Richard husbandman 611613 611613 Sywardby, Richard, of Lund, husbandman 3
4900472 2326791 2326791 defendant Calton Richard husbandman 611613 611613 Calton, Richard, of Lund, husbandman 1
5029674 2365548 2365548 defendant Bate John husbandman 611613 611613 Bate, John, of Lund, husbandman 0
5045826 2370386 2370386 defendant Selebarn John husbandman 611613 611613 Selebarn, John, of Lund, husbandman 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);