names

33 rows where place_id = 589177

✎ 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
3596811 1866637 1866637 defendant Aleyn Hugh husbandman 589177 589177 Aleyn, Hugh, of Sutton at Hone, husbandman 0
3596816 1866638 1866638 defendant Aleyn Hugh husbandman 589177 589177 Aleyn, Hugh, of Sutton at Hone, husbandman 0
3617461 1873081 1873081 defendant Landys John yeoman 589177 589177 Landys, John, of Sutton at Hone, yeoman 2
3640434 1907440 1907440 plaintiff Alen Alice (legal representative) 589177 589177 Alen, Alice, of Sutton at Hone, widow, executors of 0
3644887 1908812 1908812 defendant Forner Thomas smith 589177 589177 Forner, Thomas, of Sutton at Hone, smith 1
3644888 1908812 1908812 defendant Kendelman Richard husbandman 589177 589177 Kendelman, Richard, of Sutton at Hone, husbandman 2
3644889 1908812 1908812 defendant Eton John laborer 589177 589177 Eton, John, of Sutton at Hone, laborer 3
3658919 1913050 1913050 defendant Probert William yeoman 589177 589177 Probert, William, of Sutton at Hone, yeoman 1
3706499 1928316 1928316 defendant Stafford Henry esq 589177 589177 Stafford, Henry, of Sutton at Hone, esq 0
3738525 1938259 1938259 defendant Pulter John gent 589177 589177 Pulter, John, of Sutton at Hone, gent 0
3738527 1938260 1938260 defendant Pulter John gent 589177 589177 Pulter, John, of Sutton at Hone, gent 0
3738530 1938260 1938260 defendant Scudder Richard husbandman 589177 589177 Scudder, Richard, of Sutton at Hone, husbandman 3
3738531 1938260 1938260 defendant Brow William laborer 589177 589177 Brow, William, of Sutton at Hone, laborer 4
3761464 1945598 1945598 defendant Fynche Robert butcher 589177 589177 Fynche, Robert, of Sutton at Hone, butcher 2
3792129 1955391 1955391 defendant Ketyswell Robert husbandman 589177 589177 Ketyswell, Robert, of Sutton at Hone, husbandman 1
3801688 1958423 1958423 defendant Comport John   589177 589177 Comport, John, of Sutton at Hone 0
3808128 1960436 1960436 defendant Roger William yeoman 589177 589177 Roger, William, of Sutton at Hone, yeoman 1
3820492 1964292 1964292 plaintiff Provest William   589177 589177 Provest, William, of Sutton at Hone 0
3820493 1964292 1964292 defendant Fynche Robert butcher 589177 589177 Fynche, Robert, of Sutton at Hone, butcher 0
3820494 1964292 1964292 defendant Fynche William laborer 589177 589177 Fynche, William, of Sutton at Hone, laborer 1
4062132 2046742 2046742 defendant Lawrens Roger husbandman 589177 589177 Lawrens, Roger, of Sutton at Hone, husbandman 0
4100902 2060637 2060637 defendant Jesopp Robert yeoman 589177 589177 Jesopp, Robert, of Sutton at Hone, yeoman 0
4414082 2169308 2169308 plaintiff Cleyndon John   589177 589177 Cleyndon, John, of Sutton at Hone 0
4795247 2294661 2294661 defendant Payn John husbandman 589177 589177 Payn, John, of Sutton at Hone, husbandman 1
5068620 2377109 2377109 defendant Howeles John butcher 589177 589177 Howeles, John, of Sutton at Hone, butcher 1
5176492 2408812 2408812 defendant Couper John   589177 589177 Couper, John, of Sutton at Hone husbandman 0
5330796 2454283 2454283 defendant Hyder William laborer 589177 589177 Hyder, William, of Sutton at Hone, laborer 0
5449209 2489648 2489648 defendant at Frith William husbandman 589177 589177 at Frith, William, of Sutton at Hone, husbandman 2
5502680 2505754 2505754 defendant Layfkon Richard husbandman 589177 589177 Layfkon, Richard, of Sutton at Hone, husbandman 0
5532804 2514809 2514809 defendant Leyston Thomas husbandman 589177 589177 Leyston, Thomas, of Sutton at Hone, husbandman 0
5532805 2514809 2514809 defendant Raynold John husbandman 589177 589177 Raynold, John, of Sutton at Hone, husbandman 1
5591075 2532187 2532187 defendant Hamlyn John laborer 589177 589177 Hamlyn, John, of Sutton at Hone, laborer 0
5591076 2532187 2532187 defendant Notte Nicholas laborer 589177 589177 Notte, Nicholas, of Sutton at Hone, laborer 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);