names

20 rows where place_id = 599554

✎ 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
3637251 1906452 1906452 defendant Keynot William laborer 599554 599554 Keynot, William, of Layndon, laborer 2
3682579 1920656 1920656 defendant Blyot John husbandman 599554 599554 Blyot, John, of Layndon, husbandman 2
3777367 1950666 1950666 defendant Love Richard drover 599554 599554 Love, Richard, of Layndon, drover 0
3805051 1959522 1959522 defendant Thressher Richard husbandman 599554 599554 Thressher, Richard, of Layndon, husbandman 0
3819159 1963879 1963879 defendant Havyn William husbandman 599554 599554 Havyn, William, of Layndon, husbandman 0
3819162 1963880 1963880 defendant Thressher Richard husbandman 599554 599554 Thressher, Richard, of Layndon, husbandman 0
3889280 1986652 1986652 defendant Gylmyn John   599554 599554 Gylmyn, John, of Layndon, husbandman, adminstrators of 0
4354722 2148879 2148879 defendant Anger Thomas Essex, chapman 599554 599554 Anger Thomas, of Layndon, Essex, chapman 3
4400828 2164869 2164869 defendant Holden William gent 599554 599554 Holden, William, of Layndon, gent 0
4692505 2263171 2263171 defendant Gobyon William husbandman 599554 599554 Gobyon, William, of Layndon, husbandman 0
4692506 2263171 2263171 defendant Gobyon John laborer 599554 599554 Gobyon, John, of Layndon, laborer 1
4692507 2263171 2263171 defendant Gobyon Thomas   599554 599554 Gobyon, Thomas, of Layndon, servant 2
4708964 2268172 2268172 defendant Machoun John carter 599554 599554 Machoun, John, of Layndon, carter 2
4804061 2297455 2297455 defendant Camp John husbandman 599554 599554 Camp, John, of Layndon, husbandman 0
5251455 2430555 2430555 defendant Kemp John husbandman 599554 599554 Kemp, John, of Layndon, husbandman 0
5456913 2491972 2491972 defendant Weston Thomas husbandman 599554 599554 Weston, Thomas, of Layndon, husbandman 1
5525348 2512519 2512519 plaintiff Buttill Henry   599554 599554 Buttill, Henry, of Layndon 2
5531349 2514326 2514326 defendant Laurence Walter yeoman or farmer 599554 599554 Laurence, Walter, of Layndon, yeoman or farmer 0
5578234 2528263 2528263 defendant Reynold Edward husbandman 599554 599554 Reynold, Edward, of Layndon, husbandman 0
5578237 2528263 2528263 defendant Reynold William husbandman 599554 599554 Reynold, William, of Layndon, husbandman 3

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