names

28 rows where place_id = 588282

✎ 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
3593975 1865755 1865755 defendant Cotman Warren mariner 588282 588282 Cotman, Warren, of Kyrkeley, mariner 1
3611926 1871390 1871390 defendant Wodeherd Thomas butcher 588282 588282 Wodeherd, Thomas, of Kyrkeley, butcher 2
3622721 1874634 1874634 defendant Den Ralph tailor 588282 588282 Den, Ralph, of Kyrkeley, tailor 1
3625472 1875506 1875506 plaintiff Wodarde Thomas butcher 588282 588282 Wodarde, Thomas, of Kyrkeley, butcher 0
3635839 1906009 1906009 defendant Bosse or Boffe William yeoman 588282 588282 Bosse or Boffe, William, of Kyrkeley, yeoman 0
3635841 1906009 1906009 defendant West Thomas husbandman 588282 588282 West, Thomas, of Kyrkeley, husbandman 2
3644615 1908727 1908727 defendant Buff William yeoman 588282 588282 Buff, William, of Kyrkeley, yeoman 0
3798230 1957344 1957344 defendant Yongys Robert butcher 588282 588282 Yongys, Robert, of Kyrkeley, butcher 0
3911401 1994127 1994127 defendant Browne Thomas mariner 588282 588282 Browne, Thomas, of Kyrkeley, mariner 2
3943410 2004811 2004811 defendant Browne Miles mariner 588282 588282 Browne, Miles, of Kyrkeley, mariner 0
4241981 2110309 2110309 defendant Foster alias Andrewes Elizabeth spinster 588282 588282 Foster alias Andrewes, Elizabeth, of Kyrkeley, spinster 0
5087597 2382755 2382755 defendant Tubbyng John butcher 588282 588282 Tubbyng, John, of Kyrkeley, butcher 0
5294954 2443515 2443515 defendant Kempster John (legal representative) 588282 588282 Kempster, John, of Kyrkeley, executors of 1
5294955 2443515 2443515 defendant Bonde Waren yeoman 588282 588282 (Bonde, Waren, of Kyrkeley, yeoman 2
5401816 2475581 2475581 defendant Sewale Thomas mariner 588282 588282 Sewale, Thomas, of Kyrkeley, mariner 0
5401818 2475582 2475582 defendant Sewale Thomas mariner 588282 588282 Sewale, Thomas, of Kyrkeley, mariner 0
5414764 2479352 2479352 defendant Sewale Thomas mariner 588282 588282 Sewale, Thomas, of Kyrkeley, mariner 0
5503739 2506085 2506085 defendant Sutton John yeoman 588282 588282 Sutton, John, of Kyrkeley, yeoman 0
5512397 2508738 2508738 defendant Sutton John yeoman 588282 588282 Sutton, John, of Kyrkeley, yeoman 1
5543612 2518107 2518107 defendant Denne Ralph yeoman 588282 588282 Denne, Ralph, of Kyrkeley, yeoman 2
5543616 2518108 2518108 defendant Boof William yeoman 588282 588282 Boof, William, of Kyrkeley, yeoman 0
5546035 2518835 2518835 plaintiff Sutton John (legal representative) 588282 588282 Sutton, John, of Kyrkeley, gent, executors of 0
5559107 2522625 2522625 defendant Goneld John mariner 588282 588282 Goneld, John, of Kyrkeley, mariner 0
5559108 2522625 2522625 defendant Broun Thomas mariner 588282 588282 Broun, Thomas, of Kyrkeley, mariner 1
5563892 2524052 2524052 defendant Wodeherd Thomas butcher 588282 588282 Wodeherd, Thomas, of Kyrkeley, butcher 0
5574188 2527015 2527015 defendant Sewale Thomas mariner 588282 588282 Sewale, Thomas, of Kyrkeley, mariner 0
5585680 2530591 2530591 defendant Wodeherd Thomas butcher 588282 588282 Wodeherd, Thomas, of Kyrkeley, butcher 3
5585681 2530591 2530591 defendant Payn Nicholas glover 588282 588282 Payn, Nicholas, of Kyrkeley, glover 4

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