names

22 rows where place_id = 602928

✎ 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
3652340 1911067 1911067 defendant Trubshawe Roger yeoman 602928 602928 Trubshawe, Roger, of Wyverton, yeoman 3
3703552 1927386 1927386 defendant Deryk John smith 602928 602928 Deryk, John, of Wyverton, smith 2
3792258 1955432 1955432 defendant Chaworth John esq 602928 602928 Chaworth, John, of Wyverton, esq 0
3808889 1960659 1960659 defendant Chaworth John esq 602928 602928 Chaworth, John, of Wyverton, esq 0
3828189 1966684 1966684 defendant Tylney William husbandman 602928 602928 Tylney, William, of Wyverton, husbandman 0
3902657 1991120 1991120 defendant Chaworthe John   602928 602928 Chaworthe, John, of Wyverton, knight 0
3924635 1998553 1998553 defendant Hales John raffman 602928 602928 Hales, John, of Wyverton, raffman 0
4072013 2050288 2050288 defendant Bryant Richard joiner 602928 602928 Bryant, Richard, of Wyverton, joiner 1
4244808 2111251 2111251 defendant Sherwood Robert shipmaster 602928 602928 Sherwood, Robert, of Wyverton, shipmaster 1
4441019 2182113 2182113 defendant Burgeys John   602928 602928 Burgeys, John, of Wyverton 0
4732664 2275395 2275395 defendant Chaworth Thomas   602928 602928 Chaworth, Thomas, of Wyverton, knight 0
5061548 2375044 2375044 defendant Chaworth Thomas   602928 602928 Chaworth, Thomas, of Wyverton, knight 0
5061550 2375045 2375045 defendant Chaworth Thomas   602928 602928 Chaworth, Thomas, of Wyverton, knight 0
5090267 2383525 2383525 defendant Crosland William husbandman 602928 602928 Crosland, William, of Wyverton, husbandman 1
5229754 2424323 2424323 plaintiff Andrewys James   602928 602928 Andrewys, James, of Wyverton 0
5583541 2529925 2529925 plaintiff Fyssher John (legal representative) 602928 602928 Fyssher, John, of Wyverton, yeoman, executors of 0
5583544 2529925 2529925 defendant Jakson Simon (legal representative) 602928 602928 Jakson, Simon, of Wyverton, yeoman, executors of 0
5583546 2529925 2529925 defendant Turbok Thomas yeoman 602928 602928 Turbok, Thomas, of Wyverton, yeoman 2
5589399 2531684 2531684 defendant Mosse William (legal representative) 602928 602928 Mosse, William, of Wyverton, administrator of 0
5589400 2531684 2531684 defendant Mosse Robert husbandman 602928 602928 Mosse, Robert, of Wyverton, husbandman 1
5619889 2550081 2550081 defendant Bret John   602928 602928 Bret, John, of Wyverton 0
5621273 2550540 2550540 defendant Wret John   602928 602928 Wret, John, of Wyverton 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);