names

28 rows where place_id = 656884

✎ 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
3942132 2004386 2004386 defendant Cresweller John gent 656884 656884 Cresweller, John, of Hertyng, Sussex, gent 3
4666863 2255364 2255364 defendant Husee Henry   656884 656884 Husee, Henry, of Hertyng, Sussex, knight 0
4674888 2257754 2257754 defendant Husse Henry   656884 656884 Husse, Henry, of Hertyng, Sussex, knight 0
4750292 2280562 2280562 defendant Whyte John butcher 656884 656884 Whyte, John, of Hertyng, Sussex, butcher 3
4754986 2281942 2281942 defendant Husee Henry   656884 656884 Husee, Henry, of Hertyng, Sussex, knight 1
4755886 2282224 2282224 defendant Husie Henry   656884 656884 Husie, Henry, of Hertyng, Sussex, knight 2
4761466 2283930 2283930 defendant Fote John carpenter 656884 656884 Fote, John, of Hertyng, Sussex, carpenter 1
4775249 2288252 2288252 defendant Husee Henry   656884 656884 Husee, Henry, of Hertyng, Sussex, knight 1
4812827 2300128 2300128 defendant Husee Henry   656884 656884 Husee, Henry, of Hertyng, Sussex, knight 2
4818061 2301725 2301725 defendant Pylven Henry weaver 656884 656884 Pylven, Henry, of Hertyng, Sussex, weaver 0
4918175 2332205 2332205 defendant Husee Henry   656884 656884 Husee, Henry, of Hertyng, Sussex, knight 0
4931602 2336270 2336270 defendant Holt John yeoman 656884 656884 Holt, John, of Hertyng, Sussex, yeoman 0
4961773 2345485 2345485 defendant Holte John husbandman 656884 656884 Holte, John, of Hertyng, Sussex, husbandman 0
4971706 2348465 2348465 defendant Husee Henry   656884 656884 Husee, Henry, of Hertyng, Sussex, knight 0
4975994 2349785 2349785 defendant Huse Henry   656884 656884 Huse, Henry, of Hertyng, Sussex 0
5064982 2376058 2376058 defendant Puttok John gent 656884 656884 Puttok, John, of Hertyng, Sussex, gent 3
5064985 2376059 2376059 defendant Puttok John gent 656884 656884 Puttok, John, of Hertyng, Sussex, gent 1
5117253 2391479 2391479 defendant Husey Nicholas esq 656884 656884 Husey, Nicholas, of Hertyng, Sussex, esq 1
5246756 2429213 2429213 defendant Huse Nicholas esq 656884 656884 Huse, Nicholas, of Hertyng, Sussex, esq 2
5250858 2430381 2430381 defendant Hus- Nicholas esq 656884 656884 Hus-, Nicholas, of Hertyng, Sussex, esq 0
5250907 2430392 2430392 defendant Huse Nicholas esq 656884 656884 Huse, Nicholas, of Hertyng, Sussex, esq 1
5260752 2433484 2433484 defendant Huse Nicholas esq 656884 656884 Huse, Nicholas, of Hertyng, Sussex, esq 2
5309157 2447777 2447777 defendant Maryng John gent 656884 656884 Maryng, John, of Hertyng, Sussex, gent 1
5315317 2449637 2449637 defendant Bodeman alias Sperke John husbandman 656884 656884 Bodeman alias Sperke, John, of Hertyng, Sussex, husbandman 0
5321294 2451464 2451464 defendant Maryng John gent 656884 656884 Maryng, John, of Hertyng, Sussex, gent 1
5326387 2452977 2452977 defendant atte Halle Richard husbandman 656884 656884 atte Halle, Richard, of Hertyng, Sussex, husbandman 0
5501722 2505471 2505471 plaintiff Stempe John husbandman 656884 656884 Stempe, John, of Hertyng, , Sussex, husbandman 0
5545017 2518547 2518547 defendant Couper John yeoman 656884 656884 Couper, John, of Hertyng, Sussex, yeoman 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);