names

21 rows where place_id = 656475

✎ 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
3940397 2003806 2003806 defendant Cantrell Anne widow 656475 656475 Cantrell, Anne, of Thorp by Norwich, widow 0
4603092 2232178 2232178 defendant Lynes Andrew   656475 656475 Lynes, Andrew, of Thorp by Norwich 1
4726763 2273640 2273640 defendant Tryppe Lawrecne yeoman 656475 656475 Tryppe, Lawrecne, of Thorp by Norwich, yeoman 1
4727905 2273970 2273970 defendant Lynes Andrew weaver 656475 656475 Lynes, Andrew, of Thorp by Norwich, weaver 0
4727906 2273970 2273970 defendant Hawys John husbandman 656475 656475 Hawys, John, of Thorp by Norwich, husbandman 1
4818360 2301823 2301823 defendant Ussher John husbandman 656475 656475 Ussher, John, of Thorp by Norwich, husbandman 0
4844881 2309920 2309920 defendant Ussher John husbandman 656475 656475 Ussher, John, of Thorp by Norwich, husbandman 6
5364927 2464701 2464701 defendant Chamberleyn John husbandman 656475 656475 Chamberleyn, John, of Thorp by Norwich, husbandman 0
5387458 2471485 2471485 defendant Bernard Stephen gent 656475 656475 Bernard, Stephen, of Thorp by Norwich, gent 0
5387459 2471485 2471485 defendant Foo Richard clerk 656475 656475 Foo, Richard, of Thorp by Norwich, clerk 1
5399934 2475072 2475072 defendant Bernard Stephen gent 656475 656475 Bernard, Stephen, of Thorp by Norwich, gent 0
5399935 2475072 2475072 defendant Foo Richard clerk 656475 656475 Foo, Richard, of Thorp by Norwich, clerk 1
5427877 2483292 2483292 defendant Barnard Stephen gent 656475 656475 Barnard, Stephen, of Thorp by Norwich, gent 0
5427878 2483292 2483292 defendant Foo Richard clerk 656475 656475 Foo, Richard, of Thorp by Norwich, clerk 1
5427954 2483314 2483314 defendant Barnard Stephen gent 656475 656475 Barnard, Stephen, of Thorp by Norwich, gent 0
5427955 2483314 2483314 defendant Foo Richard clerk 656475 656475 Foo, Richard, of Thorp by Norwich, clerk 1
5442492 2487668 2487668 plaintiff Bernard John (legal representative) 656475 656475 Bernard, John, of Thorp by Norwich, executrix of 0
5455200 2491477 2491477 plaintiff Bernard John (legal representative) 656475 656475 Bernard, John, of Thorp by Norwich, executrix of 0
5455207 2491478 2491478 plaintiff Bernard John (legal representative) 656475 656475 Bernard, John, of Thorp by Norwich, executrix of 0
5461771 2493463 2493463 defendant Mouse John husbandman 656475 656475 Mouse, John, of Thorp by Norwich, husbandman 0
5467029 2495088 2495088 plaintiff Bernard John (legal representative) 656475 656475 Bernard, John, of Thorp by Norwich, executrix of 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);