names

41 rows where place_id = 614569

✎ 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
3704368 1927668 1927668 defendant Wolden Richard chaplain 614569 614569 Wolden, Richard, of Cave, chaplain 1
3704373 1927669 1927669 defendant Welden Richard chaplain 614569 614569 Welden, Richard, of Cave, chaplain 1
4423973 2172350 2172350 defendant Tothe John   614569 614569 Tothe, John, of Cave 0
4454668 2186476 2186476 defendant smyth John   614569 614569 smyth, John, of Cave 9
4471096 2191620 2191620 defendant Golshill Richard   614569 614569 Golshill, Richard, of Cave 0
4492480 2198335 2198335 defendant Wythondwyk John de   614569 614569 Wythondwyk, John de, of Cave 0
4497960 2200011 2200011 defendant Santon Richard de   614569 614569 Santon, Richard de, of Cave 2
4499555 2200509 2200509 defendant Doubenay Robert   614569 614569 Doubenay, Robert, of Cave 2
4504896 2202070 2202070 defendant Niter Thomas   614569 614569 Niter, Thomas, of Cave 1
4527692 2208940 2208940 defendant Dousyng John   614569 614569 Dousyng, John, of Cave 0
4550148 2215987 2215987 defendant Bradebelt William   614569 614569 Bradebelt, William, of Cave 0
4571238 2222574 2222574 defendant Sydchare Thomas   614569 614569 Sydchare, Thomas, of Cave 2
4574330 2223502 2223502 plaintiff Bentley John   614569 614569 Bentley, John, of Cave 0
4576627 2224201 2224201 defendant Santon Richard   614569 614569 Santon, Richard, of Cave 0
4592381 2228968 2228968 defendant Rout John   614569 614569 Rout, John, of Cave 3
4628291 2239775 2239775 defendant Santon Richard   614569 614569 Santon, Richard, of Cave 1
4628292 2239775 2239775 defendant Santon Robert   614569 614569 Santon, Robert, of Cave 2
4628333 2239789 2239789 defendant fitz Piers John   614569 614569 fitz Piers, John, of Cave 1
4628340 2239791 2239791 plaintiff Santon Richard   614569 614569 Santon, Richard, of Cave 0
4644847 2244561 2244561 defendant Santon Robert   614569 614569 Santon, Robert, of Cave 0
4645864 2244858 2244858 defendant Broun John   614569 614569 Broun, John, of Cave, son of Nicholas 0
4647283 2245259 2245259 defendant Couper Ralph   614569 614569 Couper, Ralph, of Cave 3
4658701 2248595 2248595 plaintiff Crosse Richard   614569 614569 Crosse, Richard, of Cave 0
4658703 2248595 2248595 defendant del Hill Thomas husbandman 614569 614569 del Hill, Thomas, of Cave, husbandman 1
4658704 2248596 2248596 plaintiff Crosse Richard   614569 614569 Crosse, Richard, of Cave 0
4664649 2250421 2250421 defendant Santon Richard gent 614569 614569 Santon, Richard, of Cave, gent 0
4664650 2250421 2250421 defendant Santon Robert gent 614569 614569 Santon, Robert, of Cave, gent 1
4673686 2257399 2257399 plaintiff Daynell John   614569 614569 Daynell, John, of Cave 0
4688563 2261988 2261988 plaintiff Thornton William   614569 614569 Thornton, William, of Cave 0
4688564 2261988 2261988 defendant Bradbelt William husbandman 614569 614569 Bradbelt, William, of Cave, husbandman 0
4688565 2261988 2261988 defendant Stevenson William husbandman 614569 614569 Stevenson, William, of Cave, husbandman 1
4690745 2262648 2262648 defendant Dousynges John husbandman 614569 614569 Dousynges, John, of Cave, husbandman 5
4690754 2262649 2262649 defendant Rente Thomas husbandman 614569 614569 Rente, Thomas, of Cave, husbandman 5
4709460 2268313 2268313 defendant Warton William de smith 614569 614569 Warton, William de, of Cave, smith 1
4726199 2273477 2273477 defendant Webster John spicer 614569 614569 Webster, John, of Cave, spicer 0
4738451 2277115 2277115 defendant Holme Henry yeoman 614569 614569 Holme, Henry, of Cave, yeoman 3
4739449 2277422 2277422 defendant del Hill Thomas husbandman 614569 614569 del Hill, Thomas, of Cave, husbandman 0
4850247 2311536 2311536 defendant Frankys Thomas chaplain 614569 614569 Frankys, Thomas, of Cave, chaplain 0
5575683 2527483 2527483 defendant Jakson Elizabeth widow 614569 614569 Jakson, Elizabeth, of Cave, widow 2
5628048 2552744 2552744 plaintiff Peke John   614569 614569 Peke, John, of Cave 0
5630520 2553557 2553557 plaintiff Santon or Sauton Richard   614569 614569 Santon or Sauton, Richard, of Cave 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);