names

44 rows where place_id = 621982

✎ 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
3744552 1940198 1940198 plaintiff Barlowe Thomas husbandman 621982 621982 Barlowe, Thomas, of Alspath, husbandman 0
3745046 1940358 1940358 defendant Corbet John yeoman 621982 621982 Corbet, John, of Alspath, yeoman 0
4480949 2194715 2194715 defendant Botiller Richard   621982 621982 Botiller, Richard, of Alspath, vicar 0
4480952 2194716 2194716 defendant Botiller Richard   621982 621982 Botiller, Richard, of Alspath, vicar 0
4732008 2275189 2275189 defendant Murynden Ralph yeoman 621982 621982 Murynden, Ralph, of Alspath, yeoman 0
4814663 2300701 2300701 plaintiff Jordan Richard (legal representative) 621982 621982 Jordan, Richard, of Alspath, executors of: (Jordan, Joan, formerly wife of Testator 0
4825898 2304132 2304132 defendant Chetwyn John   621982 621982 Chetwyn, John, of Alspath 0
4838772 2308054 2308054 defendant Merbrook Richard esq 621982 621982 Merbrook, Richard, of Alspath, esq 0
4865938 2316319 2316319 defendant Merbrook Richard esq 621982 621982 Merbrook, Richard, of Alspath, esq 0
4921988 2333286 2333286 plaintiff le Gyre alias Hille Helen   621982 621982 le Gyre alias Hille, Helen, of Alspath, formerly wife of John le Gyre 0
4947463 2341204 2341204 defendant Boteler John gent 621982 621982 Boteler, John, of Alspath, gent 0
4947473 2341205 2341205 defendant Boteler John yeoman 621982 621982 Boteler, John, of Alspath, yeoman 8
4992875 2354749 2354749 defendant Chetwyn John gent 621982 621982 Chetwyn, John, of Alspath, gent 0
4996580 2355831 2355831 defendant Boterler John gent 621982 621982 Boterler, John, of Alspath, gent 0
4996648 2355851 2355851 defendant Boteler John gent 621982 621982 Boteler, John, of Alspath, gent 0
4999800 2356819 2356819 defendant Boteler John gent 621982 621982 Boteler, John, of Alspath, gent 0
4999801 2356819 2356819 defendant Whytte Richard smith 621982 621982 Whytte, Richard, of Alspath, smith 1
5073970 2378700 2378700 defendant Smyth Robert smith 621982 621982 Smyth, Robert, of Alspath, smith 0
5103368 2387414 2387414 defendant Boteler John gent 621982 621982 Boteler, John, of Alspath, gent 1
5119568 2392154 2392154 defendant Warde Robert chaplain 621982 621982 Warde, Robert, of Alspath, chaplain 0
5119569 2392154 2392154 defendant Falk Margaret widow 621982 621982 Falk, Margaret, of Alspath, widow 1
5124516 2393632 2393632 plaintiff Boteler John   621982 621982 Boteler, John, of Alspath 1
5156213 2402980 2402980 defendant Boteler John gent 621982 621982 Boteler, John, of Alspath, gent 2
5156281 2402991 2402991 defendant Boteler John gent 621982 621982 Boteler, John, of Alspath, gent 0
5172486 2407680 2407680 defendant Boteler John gent 621982 621982 Boteler, John, of Alspath, gent 0
5211755 2419182 2419182 defendant Shirwode John esq 621982 621982 Shirwode, John, of Alspath, esq 0
5215219 2420177 2420177 defendant Boteler John gent 621982 621982 Boteler, John, of Alspath, gent 0
5233618 2425422 2425422 defendant Boteler John gent 621982 621982 Boteler, John, of Alspath, gent 0
5246852 2429245 2429245 defendant Warde Robert chaplain 621982 621982 Warde, Robert, of Alspath, chaplain 0
5246853 2429245 2429245 defendant Brynk Robert, junior husbandman 621982 621982 Brynk, Robert, junior, of Alspath, husbandman 1
5246854 2429245 2429245 defendant Welles Robert laborer 621982 621982 Welles, Robert, of Alspath, laborer 2
5246855 2429245 2429245 defendant Judde Richard chapman 621982 621982 Judde, Richard, of Alspath, chapman 3
5246856 2429245 2429245 defendant Shetwengdon John laborer 621982 621982 Shetwengdon, John, of Alspath, laborer 4
5246857 2429245 2429245 defendant Umfrey William husbandman 621982 621982 Umfrey, William, of Alspath, husbandman 5
5249913 2430087 2430087 defendant Clapham Richard gent 621982 621982 Clapham, Richard, of Alspath, gent 0
5249919 2430088 2430088 defendant Clapham Richard gent 621982 621982 Clapham, Richard, of Alspath, gent 0
5253415 2431170 2431170 defendant Shirwode John merchant 621982 621982 Shirwode, John, of Alspath, merchant 0
5330859 2454302 2454302 defendant Waleys Richard gent 621982 621982 Waleys, Richard, of Alspath, gent 0
5330860 2454302 2454302 defendant Brinknell John husbandman 621982 621982 Brinknell, John, of Alspath, husbandman 1
5415683 2479634 2479634 defendant Grene John clerk 621982 621982 Grene, John, of Alspath, clerk 1
5432117 2484574 2484574 defendant Grene John clerk 621982 621982 Grene, John, of Alspath, clerk 1
5448328 2489395 2489395 defendant Grene John clerk 621982 621982 Grene, John, of Alspath, clerk 0
5460674 2493137 2493137 defendant Grene John clerk 621982 621982 Grene, John, of Alspath, clerk 0
5622691 2551028 2551028 defendant Fox Robert   621982 621982 Fox, Robert, of Alspath 1

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