names

27 rows where place_id = 650511

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3912560 1994531 1994531 defendant Curtes Thomas yeoman 650511 650511 Curtes, Thomas, of Hamerton, Hunts, yeoman 0
3912842 1994625 1994625 defendant Curtes Thomas yeoman 650511 650511 Curtes, Thomas, of Hamerton, Hunts, yeoman 0
3944735 2005259 2005259 plaintiff Bedell John gent 650511 650511 Bedell, John, of Hamerton, Hunts, gent 0
4343194 2144892 2144892 plaintiff Manton John yeoman 650511 650511 Manton, John, of Hamerton, Hunts,yeoman 1
4734460 2275945 2275945 defendant Thayne John butcher 650511 650511 Thayne, John, of Hamerton, Hunts, butcher 1
4818422 2301843 2301843 defendant Bocher Walter butcher 650511 650511 Bocher, Walter, of Hamerton, Hunts, butcher 0
4845922 2310231 2310231 defendant Taillour John husbandman 650511 650511 Taillour, John, of Hamerton, Hunts, husbandman 1
4895788 2325359 2325359 defendant Taillour John husbandman 650511 650511 Taillour, John, of Hamerton, Hunts, husbandman 1
4908892 2329329 2329329 defendant Lokyere John smith 650511 650511 Lokyere, John, of Hamerton, Hunts, smith 4
4908899 2329330 2329330 defendant Lokyere John smith 650511 650511 Lokyere, John, of Hamerton, Hunts, smith 4
4999343 2356673 2356673 defendant Elveden John   650511 650511 Elveden, John, of Hamerton, Hunts, notary 2
5035344 2367195 2367195 defendant Taylour John (legal representative) 650511 650511 Taylour, John, of Hamerton, Hunts, executors of 3
5054233 2372855 2372855 defendant Taillour William husbandman 650511 650511 Taillour, William, of Hamerton, Hunts, husbandman 5
5062917 2375441 2375441 defendant Hendesson John husbandman 650511 650511 Hendesson, John, of Hamerton, Hunts, husbandman 10
5065585 2376241 2376241 defendant Taillour William husbandman 650511 650511 Taillour, William, of Hamerton, Hunts, husbandman 1
5067088 2376678 2376678 defendant Elveden John   650511 650511 Elveden, John, of Hamerton, Hunts, notary 1
5067097 2376679 2376679 defendant Elveden John   650511 650511 Elveden, John, of Hamerton, Hunts, notary 1
5095259 2385031 2385031 defendant Knyvet John esq 650511 650511 Knyvet, John, of Hamerton, Hunts, esq 0
5101135 2386745 2386745 defendant Barbour John smith 650511 650511 Barbour, John, of Hamerton, Hunts, smith 1
5130808 2395494 2395494 plaintiff Fitz John Thomas (legal representative) 650511 650511 Fitz John, Thomas, of Hamerton, Hunts, executors of 0
5150225 2401201 2401201 plaintiff fitz John Thomas (legal representative) 650511 650511 fitz John, Thomas, of Hamerton, Hunts, executors of 0
5150231 2401202 2401202 plaintiff fitz John Thomas (legal representative) 650511 650511 fitz John, Thomas, of Hamerton, Hunts, executors of 0
5153481 2402172 2402172 defendant Knyvet William esq 650511 650511 Knyvet, William, of Hamerton, Hunts, esq 2
5295528 2443683 2443683 defendant FitzJohn Henry husbandman 650511 650511 FitzJohn, Henry, of Hamerton, Hunts, husbandman 0
5295530 2443684 2443684 defendant FitzJohn Henry husbandman 650511 650511 FitzJohn, Henry, of Hamerton, Hunts, husbandman 0
5333107 2454973 2454973 defendant Marchall John husbandman 650511 650511 Marchall, John, of Hamerton, Hunts, husbandman 1
5500986 2505243 2505243 defendant Hoggeson Richard husbandman 650511 650511 Hoggeson, Richard, of Hamerton, Hunts, husbandman 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);