names

21 rows where place_id = 596088

✎ 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
3623096 1874747 1874747 plaintiff Priour John   596088 596088 Priour, John, of Kellyng 1
3623098 1874747 1874747 defendant Gylberd John husbandman 596088 596088 Gylberd, John, of Kellyng, husbandman 1
3671338 1917012 1917012 defendant Leche Thomas husbandman 596088 596088 Leche, Thomas, of Kellyng, husbandman 0
3684247 1921205 1921205 defendant Peyntour Thomas husbandman 596088 596088 Peyntour, Thomas, of Kellyng, husbandman 0
3780880 1951754 1951754 defendant Barnard John husbandman 596088 596088 Barnard, John, of Kellyng, husbandman 1
3992676 2022130 2022130 defendant Gilbert Edmund yeoman 596088 596088 Gilbert, Edmund, of Kellyng, yeoman 0
4128248 2070388 2070388 defendant Dyxe John husbandman 596088 596088 Dyxe, John, of Kellyng, husbandman 0
4128250 2070389 2070389 defendant Dyxe John husbandman 596088 596088 Dyxe, John, of Kellyng, husbandman 0
4198502 2095027 2095027 defendant Doughtye Nicholas husbandman 596088 596088 Doughtye Nicholas, of Kellyng, husbandman 2
4252528 2113836 2113836 defendant Gylberd Thomas yeoman 596088 596088 Gylberd, Thomas, of Kellyng, yeoman 2
4388040 2160630 2160630 defendant Whyte Thomas yeoman 596088 596088 Whyte, Thomas, of Kellyng, yeoman 1
4388041 2160630 2160630 defendant Whyte William yeoman 596088 596088 Whyte, William, of Kellyng, yeoman 2
4388632 2160836 2160836 defendant Blackbourne Robert grocer 596088 596088 Blackbourne, Robert, of Kellyng, grocer 0
4411485 2168432 2168432 defendant Girdleston Richard weaver 596088 596088 Girdleston, Richard, of Kellyng, weaver 2
4434197 2175459 2175459 defendant Colevyll John   596088 596088 Colevyll, John, of Kellyng 2
4775710 2288400 2288400 plaintiff Wryght William   596088 596088 Wryght, William, of Kellyng, parson 0
4922791 2333542 2333542 defendant Everard Alan husbandman 596088 596088 Everard, Alan, of Kellyng, husbandman 0
4922792 2333542 2333542 defendant Everard Roger pedder 596088 596088 Everard, Roger, of Kellyng, pedder 1
4954824 2343399 2343399 defendant Mabbys William husbandman 596088 596088 Mabbys, William, of Kellyng, husbandman 0
4954825 2343399 2343399 defendant Williamesservantmabbes Roger laborer 596088 596088 Williamesservantmabbes, Roger, of Kellyng, laborer 1
5410012 2477960 2477960 defendant Wynter John (legal representative) 596088 596088 Wynter, John, of Kellyng, yeoman, executrix of 14

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