names

26 rows where place_id = 605828

✎ 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
3663022 1914348 1914348 defendant Baldwyn John yeoman 605828 605828 Baldwyn, John, of Halse, yeoman 1
3663023 1914348 1914348 defendant Halle William, senior yeoman 605828 605828 Halle, William, senior, of Halse, yeoman 2
3663024 1914348 1914348 defendant Dycons John yeoman 605828 605828 Dycons, John, of Halse, yeoman 3
3671528 1917077 1917077 defendant Lamperey William husbandman 605828 605828 Lamperey, William, of Halse, husbandman 2
3748692 1941520 1941520 defendant Pery Robert yeoman 605828 605828 Pery, Robert, of Halse, yeoman 0
3748694 1941520 1941520 defendant Perse John laborer 605828 605828 Perse, John, of Halse, laborer 2
4108187 2063194 2063194 defendant Martyn John   605828 605828 Martyn, John, of Halse, North Tawton husbandman 2
4135725 2073105 2073105 defendant Slowcocke Joan widow 605828 605828 Slowcocke, Joan, of Halse, widow 0
4145410 2076552 2076552 defendant Wynter Thomas husbandman 605828 605828 Wynter, Thomas, of Halse, husbandman 0
4145411 2076552 2076552 defendant Hancocke John weaver 605828 605828 Hancocke, John, of Halse, weaver 1
4168495 2084467 2084467 defendant Wynter Thomas husbandman 605828 605828 Wynter, Thomas, of Halse, husbandman 0
4225788 2104484 2104484 defendant Hancocke John clothier 605828 605828 Hancocke, John, of Halse, clothier 1
4289847 2126430 2126430 defendant Baker John (legal representative) 605828 605828 Baker, John, of Halse, husbandman, executor of 0
4289848 2126430 2126430 defendant Baker Anthony husbandman 605828 605828 Baker, Anthony, of Halse, husbandman 1
4389221 2161024 2161024 defendant Nott William tailor 605828 605828 Nott, William, of Halse, tailor 1
4399328 2164363 2164363 defendant Webber Thomas husbandman 605828 605828 Webber, Thomas, of Halse, husbandman 1
4400312 2164696 2164696 defendant Pirry John gent 605828 605828 Pirry, John, of Halse, gent 0
4441366 2182237 2182237 defendant Body Robert   605828 605828 Body, Robert, of Halse, vicar 0
4512015 2204198 2204198 defendant atte Mulle John   605828 605828 atte Mulle, John, of Halse 0
4755623 2282141 2282141 plaintiff Baker Peter   605828 605828 Baker, Peter, of Halse 0
5001078 2357193 2357193 defendant Seman William   605828 605828 Seman, William, of Halse, mill ward 0
5027697 2364976 2364976 defendant Seman William   605828 605828 Seman, William, of Halse, millward 0
5238490 2426847 2426847 defendant Southbroke Thomas, junior husbandman 605828 605828 Southbroke, Thomas, junior, of Halse, husbandman 0
5413545 2478974 2478974 defendant Bolham Peter husbandman 605828 605828 Bolham, Peter, of Halse, husbandman 1
5611145 2547212 2547212 defendant atte Wille Ivan   605828 605828 atte Wille, Ivan, of Halse 0
5622747 2551043 2551043 defendant Man John   605828 605828 Man, John, of Halse 3

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