names

37 rows where place_id = 765675

✎ 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
4519657 2206509 2206509 defendant Carter John   765675 765675 Carter, John, of Great Berdefeld 2
4548454 2215455 2215455 defendant Melkesham John   765675 765675 Melkesham, John, of Great Berdefeld 1
4591862 2228808 2228808 plaintiff Galyoun John   765675 765675 Galyoun, John, of Great Berdefeld 1
4591863 2228808 2228808 defendant Pountfreyd John   765675 765675 Pountfreyd, John, of Great Berdefeld 0
4591865 2228809 2228809 plaintiff Gobyoun John   765675 765675 Gobyoun, John, of Great Berdefeld 1
4591866 2228809 2228809 defendant Pountfreyd John   765675 765675 Pountfreyd, John, of Great Berdefeld 0
4620907 2237520 2237520 defendant Pumfreyt John   765675 765675 Pumfreyt, John, of Great Berdefeld 1
4668334 2255811 2255811 defendant Glovere John husbandman 765675 765675 Glovere, John, of Great Berdefeld, husbandman 0
4679492 2259200 2259200 defendant Glovere John husbandman 765675 765675 Glovere, John, of Great Berdefeld, husbandman 0
4704116 2266666 2266666 defendant Stowe John husbandman 765675 765675 Stowe, John, of Great Berdefeld, husbandman 0
4704992 2266936 2266936 defendant Notyssone Henry husbandman 765675 765675 Notyssone, Henry, of Great Berdefeld, husbandman 0
4704993 2266936 2266936 defendant Pulee Peter husbandman 765675 765675 Pulee, Peter, of Great Berdefeld, husbandman 1
4725892 2273386 2273386 defendant Stubbard Edward shoemaker 765675 765675 Stubbard, Edward, of Great Berdefeld, shoemaker 0
4728703 2274214 2274214 defendant Glovere John husbandman 765675 765675 Glovere, John, of Great Berdefeld, husbandman 2
4747393 2279741 2279741 defendant Blover John husbandman 765675 765675 Blover, John, of Great Berdefeld, husbandman 2
4747448 2279756 2279756 defendant Glover John husbandman 765675 765675 Glover, John, of Great Berdefeld, husbandman 0
4747449 2279756 2279756 defendant Pounde John husbandman 765675 765675 Pounde, John, of Great Berdefeld, husbandman 1
4748056 2279943 2279943 defendant Glovere John   765675 765675 Glovere, John, of Great Berdefeld, bailiff 2
4748057 2279943 2279943 defendant Pound John yeoman 765675 765675 Pound, John, of Great Berdefeld, yeoman 3
4805681 2297985 2297985 defendant Stubbard John husbandman 765675 765675 Stubbard, John, of Great Berdefeld, husbandman 0
4813023 2300189 2300189 defendant Stubbard John fisher 765675 765675 Stubbard, John, of Great Berdefeld, fisher 0
4816343 2301199 2301199 defendant Stubbard John butcher 765675 765675 Stubbard, John, of Great Berdefeld, butcher 2
4818600 2301898 2301898 defendant atte Gate Richard husbandman 765675 765675 atte Gate, Richard, of Great Berdefeld, husbandman 0
4850816 2311705 2311705 defendant Chapman John shoemaker 765675 765675 Chapman, John, of Great Berdefeld, shoemaker 0
4927197 2334941 2334941 defendant Blovere John yeoman 765675 765675 Blovere, John, of Great Berdefeld, yeoman 0
5152007 2401724 2401724 defendant Moryve John chandler 765675 765675 Moryve, John, of Great Berdefeld, chandler 0
5152008 2401724 2401724 defendant Kempe Thomas miller 765675 765675 Kempe, Thomas, of Great Berdefeld, miller 1
5195829 2414525 2414525 defendant Dyer Richard mercer 765675 765675 Dyer, Richard, of Great Berdefeld, mercer 3
5209415 2418488 2418488 defendant Dyer Richard mercer 765675 765675 Dyer, Richard, of Great Berdefeld, mercer 3
5276274 2438131 2438131 defendant Herde John yeoman 765675 765675 Herde, John, of Great Berdefeld, yeoman 0
5428686 2483494 2483494 defendant Bret John   765675 765675 Bret, John, of Great Berdefeld, nail maker 2
5458017 2492300 2492300 defendant Croke John carpenter 765675 765675 Croke, John, of Great Berdefeld, carpenter 0
5458019 2492300 2492300 defendant Write John butcher 765675 765675 Write, John, of Great Berdefeld, butcher 2
5458021 2492301 2492301 defendant Croke John carpenter 765675 765675 Croke, John, of Great Berdefeld, carpenter 0
5458023 2492301 2492301 defendant Write John butcher 765675 765675 Write, John, of Great Berdefeld, butcher 2
5460827 2493184 2493184 defendant Bret John   765675 765675 Bret, John, of Great Berdefeld, nail maker 1
5460832 2493185 2493185 defendant Bret John   765675 765675 Bret, John, of Great Berdefeld, nail maker 1

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