names

33 rows where place_id = 661756

✎ 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
3962195 2011361 2011361 plaintiff Watkyns William merchant 661756 661756 Watkyns, William, of Swansey, Glamorgan, merchant 0
3964244 2012101 2012101 defendant Harbert William esq 661756 661756 Harbert, William, of Swansey, Glamorgan, esq 0
3971429 2014565 2014565 defendant Harvert William esq 661756 661756 Harvert, William, of Swansey, Glamorgan, esq 0
3973468 2015289 2015289 defendant Harbart William esq 661756 661756 Harbart, William, of Swansey, Glamorgan, esq 0
3996581 2023536 2023536 defendant Powell Walter gent 661756 661756 Powell, Walter, of Swansey, Glamorgan, gent 0
4011270 2028805 2028805 defendant Owen Mathew chapman or merchant 661756 661756 Owen, Mathew, of Swansey, Glamorgan, chapman or merchant 1
4030760 2035664 2035664 defendant Havard John gent 661756 661756 Havard, John, of Swansey, Glamorgan, gent 1
4030764 2035665 2035665 defendant Havard John gent 661756 661756 Havard, John, of Swansey, Glamorgan, gent 1
4075283 2051465 2051465 defendant Francklyn Henry gent 661756 661756 Francklyn, Henry, of Swansey, Glamorgan, gent 0
4077210 2052134 2052134 defendant Harrys David yeoman 661756 661756 Harrys, David, of Swansey, Glamorgan, yeoman 0
4082884 2054178 2054178 defendant Franklen or Francken Jenkin gent 661756 661756 Franklen or Francken, Jenkin, of Swansey, Glamorgan, gent 2
4110514 2064020 2064020 defendant Laurence Christopher gent 661756 661756 Laurence, Christopher, of Swansey, Glamorgan, gent 2
4116147 2066068 2066068 defendant Sadler Richard   661756 661756 Sadler, Richard, of Swansey, Glamorgan 0
4123575 2068733 2068733 defendant Flemynge William chapman 661756 661756 Flemynge, William, of Swansey, Glamorgan, chapman 0
4155484 2080004 2080004 defendant Flemynge William chapman 661756 661756 Flemynge, William, of Swansey, Glamorgan, chapman 0
4192488 2092933 2092933 defendant Herbert William   661756 661756 Herbert, William, of Swansey, Glamorgan, knight 2
4223693 2103772 2103772 defendant Watkyns Henry vintner 661756 661756 Watkyns, Henry, of Swansey, Glamorgan, vintner 1
4231703 2106586 2106586 defendant Watkyns Henry vintner 661756 661756 Watkyns, Henry, of Swansey, Glamorgan, vintner 1
4240644 2109852 2109852 defendant Ychan John David yeoman 661756 661756 Ychan, John David, of Swansey, Glamorgan, yeoman 1
4245094 2111344 2111344 defendant Herbert William   661756 661756 Herbert, William, of Swansey, Glamorgan, knight 0
4256973 2115302 2115302 defendant Cullyn John chapman 661756 661756 Cullyn, John, of Swansey, Glamorgan, chapman 0
4265768 2118190 2118190 defendant Smythe John mercer 661756 661756 Smythe, John, of Swansey, Glamorgan, mercer 1
4265772 2118191 2118191 defendant Smythe John mercer 661756 661756 Smythe, John, of Swansey, Glamorgan, mercer 1
4269236 2119303 2119303 defendant Herbert William   661756 661756 Herbert, William, of Swansey, Glamorgan, knight 0
4269250 2119308 2119308 defendant Cullyn John chapman 661756 661756 Cullyn, John, of Swansey, Glamorgan, chapman 0
4285432 2124838 2124838 defendant Richard Howell gent 661756 661756 Richard, Howell, of Swansey, Glamorgan, gent 0
4298359 2129512 2129512 defendant Watkyns Henry gent 661756 661756 Watkyns, Henry, of Swansey, Glamorgan, gent 0
4331527 2140840 2140840 defendant Watkyns Henry gent 661756 661756 Watkyns, Henry, of Swansey, Glamorgan, gent 0
4335999 2142325 2142325 defendant Watkyns Henry gent 661756 661756 Watkyns, Henry, of Swansey, Glamorgan, gent 0
4336001 2142326 2142326 defendant Sadler Richard merchant 661756 661756 Sadler, Richard, of Swansey, Glamorgan, merchant 0
4363130 2151877 2151877 defendant Richard Owen John shoemaker 661756 661756 Richard, Owen John, of Swansey, Glamorgan, shoemaker 2
4370253 2154421 2154421 defendant Francklin Jenkin esq 661756 661756 Francklin, Jenkin, of Swansey, Glamorgan, esq 0
4394196 2162660 2162660 defendant Franckline Jenkin esq 661756 661756 Franckline, Jenkin, of Swansey, Glamorgan, esq 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);