names

21 rows where place_id = 591310

✎ 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
3604025 1868924 1868924 defendant Atkynson Henry husbandman 591310 591310 Atkynson, Henry, of Houden, husbandman 1
3604026 1868924 1868924 defendant Payn John husbandman 591310 591310 Payn, John, of Houden, husbandman 2
4447760 2184228 2184228 defendant Waterton John de cutler 591310 591310 Waterton, John de, of Houden, cutler 0
4447761 2184228 2184228 defendant Wresitt John butcher 591310 591310 Wresitt, John, of Houden, butcher 1
4507524 2202813 2202813 defendant Oxenford Alexander   591310 591310 Oxenford, Alexander, of Houden 0
4535436 2211356 2211356 defendant Home John   591310 591310 Home, John, of Houden 0
4580555 2225405 2225405 defendant Santon John   591310 591310 Santon, John, of Houden 4
4580556 2225405 2225405 defendant Holme John de   591310 591310 Holme, John de, of Houden 5
4581531 2225673 2225673 defendant Santon John   591310 591310 Santon, John, of Houden 4
4581532 2225673 2225673 defendant Barkere John   591310 591310 Barkere, John, of Houden 5
4586850 2227286 2227286 defendant Marshall Joan   591310 591310 Marshall, Joan, of Houden 2
4612671 2235027 2235027 defendant Mode William   591310 591310 Mode, William, of Houden 0
4697990 2264863 2264863 defendant Burne Thoams husbandman 591310 591310 Burne, Thoams, of Houden, husbandman 1
5050859 2371874 2371874 defendant Fraunkeley John butcher 591310 591310 Fraunkeley, John, of Houden, butcher 4
5164462 2405337 2405337 defendant Laton William gent 591310 591310 Laton, William, of Houden, gent 3
5177683 2409166 2409166 defendant Laton William gent 591310 591310 Laton, William, of Houden, gent 3
5191547 2413269 2413269 defendant Wilkenson Robert   591310 591310 Wilkenson, Robert, of Houden, shoe maker 2
5201026 2416055 2416055 defendant Laton William gent 591310 591310 Laton, William, of Houden, gent 3
5564212 2524141 2524141 defendant Mounketon Robert (legal representative) 591310 591310 Mounketon, Robert, of Houden, gent, executrix of 0
5630043 2553397 2553397 defendant Dryby John weaver 591310 591310 Dryby, John, of Houden, weaver 2
5630044 2553397 2553397 defendant Mody William fisher 591310 591310 Mody, William, of Houden, fisher 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);