names

45 rows where place_id = 592593

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608199 1870221 1870221 defendant Wychehalse Robert mercer 592593 592593 Wychehalse, Robert, of Chudlegh, mercer 0
3628647 1903834 1903834 defendant Mayn William, junior husbandman 592593 592593 Mayn, William, junior, of Chudlegh, husbandman 0
3790011 1954697 1954697 defendant Trygge John, senior husbandman 592593 592593 Trygge, John, senior, of Chudlegh, husbandman 0
3790012 1954697 1954697 defendant Trygge John laborer 592593 592593 Trygge, John, of Chudlegh, laborer 1
3790013 1954697 1954697 defendant Trygge John weaver 592593 592593 Trygge, John, of Chudlegh, weaver 2
3844977 1971978 1971978 defendant herne Nicholas yeoman 592593 592593 herne, Nicholas, of Chudlegh, yeoman 5
3890241 1986981 1986981 plaintiff Hert John (legal representative) 592593 592593 Hert, John, of Chudlegh, executor of 0
3895440 1988684 1988684 defendant Ball Nicholas husbandman 592593 592593 Ball, Nicholas, of Chudlegh, husbandman 1
3895441 1988684 1988684 defendant Crammer John husbandman 592593 592593 Crammer, John, of Chudlegh, husbandman 2
3900417 1990372 1990372 defendant Kenycke Thomas weaver 592593 592593 Kenycke, Thomas, of Chudlegh, weaver 0
4846236 2310326 2310326 defendant Lyne John   592593 592593 Lyne, John, of Chudlegh, bailiff 1
5044116 2369867 2369867 defendant Riggewaye Roger butcher 592593 592593 Riggewaye, Roger, of Chudlegh, butcher 0
5045862 2370397 2370397 defendant Melbury Nicholas   592593 592593 Melbury, Nicholas, of Chudlegh, milward 1
5052942 2372471 2372471 defendant Comyng Geoffrey husbandman 592593 592593 Comyng, Geoffrey, of Chudlegh, husbandman 2
5052943 2372471 2372471 defendant Badford John husbandman 592593 592593 Badford, John, of Chudlegh, husbandman 3
5052944 2372471 2372471 defendant Pery Edmund husbandman 592593 592593 Pery, Edmund, of Chudlegh, husbandman 4
5065804 2376293 2376293 defendant Drake John husbandman 592593 592593 Drake, John, of Chudlegh, husbandman 0
5090331 2383555 2383555 defendant Drake John husbandman 592593 592593 Drake, John, of Chudlegh, husbandman 0
5090705 2383666 2383666 defendant Drake John husbandman 592593 592593 Drake, John, of Chudlegh, husbandman 0
5197296 2414946 2414946 defendant Clyf Hamond smith 592593 592593 Clyf, Hamond, of Chudlegh, smith 0
5197298 2414947 2414947 defendant Clyf Hamond smith 592593 592593 Clyf, Hamond, of Chudlegh, smith 0
5197300 2414948 2414948 defendant Clyf Hamond smith 592593 592593 Clyf, Hamond, of Chudlegh, smith 0
5254957 2431664 2431664 defendant Vantort John barber 592593 592593 Vantort, John, of Chudlegh, barber 0
5315782 2449793 2449793 defendant Peverell Andrew gent 592593 592593 Peverell, Andrew, of Chudlegh, gent 0
5326002 2452869 2452869 defendant Peverell Andrew gent 592593 592593 Peverell, Andrew, of Chudlegh, gent 0
5362394 2463894 2463894 defendant Cleve Philip yeoman 592593 592593 Cleve, Philip, of Chudlegh, yeoman 2
5362395 2463894 2463894 defendant Herne William husbandman 592593 592593 Herne, William, of Chudlegh, husbandman 3
5365022 2464731 2464731 defendant Drale Thomas husbandman 592593 592593 Drale, Thomas, of Chudlegh, husbandman 1
5365023 2464731 2464731 defendant Torre John husbandman 592593 592593 Torre, John, of Chudlegh, husbandman 2
5365024 2464731 2464731 defendant Cowelyng Stephen clerk 592593 592593 Cowelyng, Stephen, of Chudlegh, clerk 3
5383988 2470508 2470508 defendant Drake Thomas husbandman 592593 592593 Drake, Thomas, of Chudlegh, husbandman 1
5383989 2470508 2470508 defendant Cowelyng Stephen clerk 592593 592593 Cowelyng, Stephen, of Chudlegh, clerk 2
5395797 2473883 2473883 defendant Crake Thomas husbandman 592593 592593 Crake, Thomas, of Chudlegh, husbandman 1
5409080 2477682 2477682 defendant Drake Thomas husbandman 592593 592593 Drake, Thomas, of Chudlegh, husbandman 1
5409083 2477683 2477683 defendant Drake Thomas husbandman 592593 592593 Drake, Thomas, of Chudlegh, husbandman 1
5409091 2477685 2477685 defendant Drake Thomas husbandman 592593 592593 Drake, Thomas, of Chudlegh, husbandman 1
5413259 2478891 2478891 defendant Drake Thomas husbandman 592593 592593 Drake, Thomas, of Chudlegh, husbandman 0
5428318 2483395 2483395 defendant Drake Thomas husbandman 592593 592593 Drake, Thomas, of Chudlegh, husbandman 0
5428401 2483419 2483419 defendant Drake Thomas husbandman 592593 592593 Drake, Thomas, of Chudlegh, husbandman 0
5428403 2483420 2483420 defendant Drake Thomas husbandman 592593 592593 Drake, Thomas, of Chudlegh, husbandman 0
5428405 2483421 2483421 defendant Drake Thomas husbandman 592593 592593 Drake, Thomas, of Chudlegh, husbandman 0
5446655 2488893 2488893 defendant Eston Richard mercer 592593 592593 Eston, Richard, of Chudlegh, mercer 0
5458498 2492434 2492434 defendant Drake Thomas husbandman 592593 592593 Drake, Thomas, of Chudlegh, husbandman 0
5470917 2496234 2496234 defendant Eston Richard   592593 592593 Eston, Richard, of Chudlegh 0
5608167 2537458 2537458 defendant Counkeyswill John butcher 592593 592593 Counkeyswill, John, of Chudlegh, butcher 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);