names

26 rows where place_id = 593224

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610972 1871108 1871108 defendant Pepir William husbandman 593224 593224 Pepir, William, of Croule, husbandman 1
3624006 1875041 1875041 defendant Thornton Peter laborer 593224 593224 Thornton, Peter, of Croule, laborer 0
3624008 1875042 1875042 defendant Thornton Peter laborer 593224 593224 Thornton, Peter, of Croule, laborer 0
4233329 2107170 2107170 defendant Bennett John yeoman 593224 593224 Bennett, John, of Croule, yeoman 2
4241934 2110294 2110294 defendant Bennett John yeoman 593224 593224 Bennett, John, of Croule, yeoman 2
4418500 2170663 2170663 defendant Doverdale William de   593224 593224 Doverdale, William de, of Croule 0
4430115 2174200 2174200 defendant Ody John   593224 593224 Ody, John, of Croule 0
4464268 2189489 2189489 defendant Bailly Roger   593224 593224 Bailly, Roger, of Croule 2
4464269 2189489 2189489 defendant Simonde Thomas   593224 593224 Simonde, Thomas, of Croule 3
4538266 2212256 2212256 defendant Cook John chaplain 593224 593224 Cook, John, of Croule, chaplain 0
4704445 2266766 2266766 defendant Erre John (legal representative) 593224 593224 Erre, John, of Croule, formerly vicar, executors of 0
4704448 2266766 2266766 defendant Vicaryes William husbandman 593224 593224 Vicaryes, William, of Croule, husbandman 3
4704449 2266766 2266766 defendant O_r_golde John   593224 593224 O_r_golde, John, of Croule, plough man 4
4774183 2287908 2287908 defendant Lyndesey Robert chapman 593224 593224 Lyndesey, Robert, of Croule, chapman 0
4903059 2327572 2327572 defendant Tynkeler Robert husbandman 593224 593224 Tynkeler, Robert, of Croule, husbandman 0
5043534 2369687 2369687 defendant Baker John husbandman 593224 593224 Baker, John, of Croule, husbandman 0
5043535 2369687 2369687 defendant Doverdale John husbandman 593224 593224 Doverdale, John, of Croule, husbandman 1
5043536 2369687 2369687 defendant Doverdale Richard husbandman 593224 593224 Doverdale, Richard, of Croule, husbandman 2
5043537 2369687 2369687 defendant Garner Richard husbandman 593224 593224 Garner, Richard, of Croule, husbandman 3
5043540 2369688 2369688 defendant Baker John husbandman 593224 593224 Baker, John, of Croule, husbandman 0
5043541 2369688 2369688 defendant Denersdale John husbandman 593224 593224 Denersdale, John, of Croule, husbandman 1
5043543 2369688 2369688 defendant Garner Richard husbandman 593224 593224 with Garner, Richard, of Croule, husbandman 3
5047645 2370914 2370914 defendant Donerdale John husbandman 593224 593224 Donerdale, John, of Croule, husbandman 0
5356402 2462069 2462069 defendant Glover George husbandman 593224 593224 Glover, George, of Croule, husbandman 0
5494608 2503275 2503275 defendant Dykonson John yeoman 593224 593224 Dykonson, John, of Croule, yeoman 0
5509647 2507852 2507852 defendant Dykonson John yeoman 593224 593224 Dykonson, John, of Croule, yeoman 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);