names

33 rows where place_id = 595569

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621036 1874137 1874137 defendant Courte John laborer 595569 595569 Courte, John, of Congresbury, laborer 0
3904096 1991612 1991612 defendant Jeve alias Gyve John yeoman 595569 595569 Jeve alias Gyve, John, of Congresbury, yeoman 0
3909279 1993395 1993395 defendant Hunt William husbandman 595569 595569 Hunt, William, of Congresbury, husbandman 0
3985963 2019747 2019747 defendant Bulman   pewterer 595569 595569 Bulman, , of Congresbury , pewterer 0
3985964 2019747 2019747 defendant Daburne Thomas clerk 595569 595569 Daburne, Thomas, of Congresbury, clerk 1
3985966 2019748 2019748 defendant Bulman Cuthbert pewterer 595569 595569 Bulman, Cuthbert, of Congresbury, pewterer 0
3985967 2019748 2019748 defendant Daburne Thomas clerk 595569 595569 Daburne, Thomas, of Congresbury, clerk 1
4369740 2154234 2154234 defendant Adams Richard husbandman 595569 595569 Adams, Richard, of Congresbury, husbandman 0
4378477 2157373 2157373 defendant Kynge William   595569 595569 Kynge, William, of Congresbury, husbandman, his father 1
4378478 2157373 2157373 defendant Kynge William husbandman 595569 595569 Kynge, William, of Congresbury, husbandman 2
4408088 2167276 2167276 defendant Michell John husbandman 595569 595569 Michell, John, of Congresbury, husbandman 1
4578187 2224674 2224674 defendant Vanables John   595569 595569 Vanables, John, of Congresbury 2
4922749 2333529 2333529 defendant Chelyngton Mary widow 595569 595569 Chelyngton, Mary, of Congresbury, widow 1
5025474 2364349 2364349 defendant Noble John husbandman 595569 595569 Noble, John, of Congresbury, husbandman 0
5053848 2372747 2372747 defendant Jene or Jeue or Jeve William husbandman 595569 595569 Jene or Jeue or Jeve, William, of Congresbury, husbandman 0
5053849 2372747 2372747 defendant Bekyng William husbandman 595569 595569 Bekyng, William, of Congresbury, husbandman 1
5053850 2372747 2372747 defendant Mason John, senior husbandman 595569 595569 Mason, John, senior, of Congresbury, husbandman 2
5053851 2372747 2372747 defendant Rugge John   595569 595569 Rugge, John, of Congresbury, groom 3
5240503 2427437 2427437 defendant Chyke Thomas husbandman 595569 595569 Chyke, Thomas, of Congresbury, husbandman 0
5240504 2427437 2427437 defendant Whitte Thomas husbandman 595569 595569 Whitte, Thomas, of Congresbury, husbandman 1
5240505 2427437 2427437 defendant Passelowe William husbandman 595569 595569 Passelowe, William, of Congresbury, husbandman 2
5240506 2427437 2427437 defendant Knyght John husbandman 595569 595569 Knyght, John, of Congresbury, husbandman 3
5240507 2427437 2427437 defendant Gene John husbandman 595569 595569 Gene, John, of Congresbury, husbandman 4
5240508 2427437 2427437 defendant Austyne William husbandman 595569 595569 Austyne, William, of Congresbury, husbandman 5
5279669 2439136 2439136 defendant Spurdde Thomas husbandman 595569 595569 Spurdde, Thomas, of Congresbury, husbandman 0
5493974 2503107 2503107 defendant Toore William carpenter 595569 595569 Toore, William, of Congresbury, carpenter 0
5493975 2503107 2503107 defendant Cade John husbandman 595569 595569 Cade, John, of Congresbury, husbandman 1
5493976 2503107 2503107 defendant Frere William husbandman 595569 595569 Frere, William, of Congresbury, husbandman 2
5493977 2503107 2503107 defendant Cade William husbandman 595569 595569 Cade, William, of Congresbury, husbandman 3
5493978 2503107 2503107 defendant Parker John husbandman 595569 595569 Parker, John, of Congresbury, husbandman 4
5493979 2503107 2503107 defendant Nedys Thomas husbandman 595569 595569 Nedys, Thomas, of Congresbury, husbandman 5
5606506 2536923 2536923 defendant Nedys Thomas (legal representative) 595569 595569 Nedys, Thomas, of Congresbury, tailor, executrix of 1
5606507 2536923 2536923 defendant Nedys Alice widow 595569 595569 Nedys, Alice, of Congresbury, widow 2

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