names

20 rows where place_id = 852566

✎ 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
4533024 2210596 2210596 plaintiff Raulyn John   852566 852566 (Raulyn, John, of Chipping Barnet, son of John 1
5143469 2399223 2399223 defendant Hurre Richard butcher 852566 852566 Hurre, Richard, of Chipping Barnet, butcher 0
5162651 2404797 2404797 defendant Smyth Thomas smith 852566 852566 Smyth, Thomas, of Chipping Barnet, smith 1
5164680 2405405 2405405 defendant Hurre Richard butcher 852566 852566 Hurre, Richard, of Chipping Barnet, butcher 0
5168036 2406362 2406362 defendant Hardewyn William (legal representative) 852566 852566 Hardewyn, William, of Chipping Barnet, maltman, executors of 0
5182708 2410700 2410700 defendant Hardwyn Elizabeth   852566 852566 Hardwyn, Elizabeth, of Chipping Barnet, widow, formerly wife of William Hardwyn 0
5183104 2410800 2410800 defendant Burford Maud   852566 852566 Burford, Maud, of Chipping Barnet, widow, formerly wife of William 1
5186079 2411679 2411679 defendant Martyn Richard husbandman 852566 852566 Martyn, Richard, of Chipping Barnet, husbandman 0
5186088 2411682 2411682 defendant Martyn Robert husbandman 852566 852566 Martyn, Robert, of Chipping Barnet, husbandman 0
5190672 2413019 2413019 defendant Coplnd Robert tailor 852566 852566 Coplnd, Robert, of Chipping Barnet, tailor 0
5190673 2413019 2413019 defendant Godyng Alice widow 852566 852566 Godyng, Alice, of Chipping Barnet, widow 1
5190675 2413019 2413019 defendant Priour John yeoman 852566 852566 Priour, John, of Chipping Barnet, yeoman 3
5195535 2414444 2414444 defendant Forster John hosteler 852566 852566 Forster, John, of Chipping Barnet, hosteler 0
5203542 2416788 2416788 defendant Hardwyn Elizabeth   852566 852566 Hardwyn, Elizabeth, of Chipping Barnet, widow, formerly wife of William 0
5205065 2417239 2417239 defendant Martyn Richard husbandman 852566 852566 Martyn, Richard, of Chipping Barnet, husbandman 0
5205071 2417241 2417241 defendant Martyn Richard husbandman 852566 852566 Martyn, Richard, of Chipping Barnet, husbandman 0
5209312 2418457 2418457 defendant Forster John hosteller 852566 852566 Forster, John, of Chipping Barnet, hosteller 0
5299357 2444785 2444785 defendant Benet Richard   852566 852566 Benet, Richard, of Chipping Barnet 0
5449741 2489811 2489811 defendant Heron William (legal representative) 852566 852566 Heron, William, of Chipping Barnet, administratrix of 2
5449742 2489811 2489811 defendant Heron Alice widow 852566 852566 Heron, Alice, of Chipping Barnet, widow 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);