names

34 rows where place_id = 710389

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4183248 2089622 2089622 defendant Mullyns John yeoman 710389 710389 Mullyns, John, of Whitchirche, yeoman 2
4190765 2092331 2092331 defendant Boswell Ralph husbandman 710389 710389 Boswell, Ralph, of Whitchirche, husbandman 2
4219863 2102447 2102447 defendant Whittingham Ralph husbandman 710389 710389 Whittingham, Ralph, of Whitchirche, husbandman 1
4316693 2135957 2135957 defendant Colmer Robert yeoman 710389 710389 Colmer, Robert, of Whitchirche, yeoman 0
4342079 2144511 2144511 defendant Whichsted John yeoman 710389 710389 Whichsted, John, of Whitchirche, yeoman 1
4357391 2149813 2149813 defendant Kempster William (legal representative) 710389 710389 Kempster, William, of Whitchirche, dyer, executrix of 3
4357392 2149813 2149813 defendant Kempster Elizabeth widow 710389 710389 Kempster, Elizabeth, of Whitchirche, widow 4
4377823 2157138 2157138 defendant Sympson Anthony tailor 710389 710389 Sympson, Anthony, of Whitchirche, tailor 0
4424966 2172648 2172648 plaintiff Lestraunge John   710389 710389 Lestraunge, John, of Whitchirche 0
4474798 2192789 2192789 plaintiff Dyere John   710389 710389 Dyere, John, of Whitchirche 0
4499082 2200356 2200356 defendant Somerton Thomas   710389 710389 Somerton, Thomas, of Whitchirche 1
4499084 2200357 2200357 defendant Somerton John   710389 710389 Somerton, John, of Whitchirche 0
4499085 2200357 2200357 defendant Somerton Thomas   710389 710389 Somerton, Thomas, of Whitchirche 1
4520127 2206629 2206629 defendant Fryday Robert   710389 710389 Fryday, Robert, of Whitchirche 1
4532211 2210339 2210339 plaintiff Potter John   710389 710389 Potter, John, of Whitchirche, son of Alice, formerly servant of Robert Potter 0
4552168 2216629 2216629 defendant Wolf John   710389 710389 Wolf, John, of Whitchirche 1
4558803 2218712 2218712 defendant Egge John   710389 710389 Egge, John, of Whitchirche 0
4574020 2223396 2223396 defendant Faldeie Nicholas de   710389 710389 Faldeie, Nicholas de, of Whitchirche 3
4711473 2268919 2268919 defendant Groundy Walter husbandman 710389 710389 Groundy, Walter, of Whitchirche, husbandman 1
4715374 2270143 2270143 plaintiff Walshe John   710389 710389 Walshe, John, of Whitchirche 0
4769663 2286487 2286487 defendant Hancok Thomas clerk 710389 710389 (Hancok, Thomas, of Whitchirche, clerk 1
4788583 2292488 2292488 defendant Spencer William butcher 710389 710389 Spencer, William, of Whitchirche, butcher 2
4789237 2292692 2292692 defendant Godewyn Henry carpenter 710389 710389 Godewyn, Henry, of Whitchirche, carpenter 1
4799754 2296109 2296109 defendant Motte John skinner 710389 710389 Motte, John, of Whitchirche, skinner 0
4818233 2301780 2301780 defendant Bodycod William laborer 710389 710389 Bodycod, William, of Whitchirche, laborer 1
4822216 2303029 2303029 defendant Halton John husbandman 710389 710389 Halton, John, of Whitchirche, husbandman 0
4898417 2326159 2326159 defendant North Richard butcher 710389 710389 North, Richard, of Whitchirche, butcher 1
4916882 2331782 2331782 defendant Herford John farrier 710389 710389 Herford, John, of Whitchirche, farrier 2
4989443 2353778 2353778 defendant Wenlok John gent 710389 710389 Wenlok, John, of Whitchirche, gent 0
5137745 2397551 2397551 defendant Gille William yeoman 710389 710389 Gille, William, of Whitchirche, yeoman 3
5150485 2401276 2401276 plaintiff Martyn John   710389 710389 Martyn, John, of Whitchirche 1
5158454 2403593 2403593 defendant Gylle William yeoman 710389 710389 Gylle, William, of Whitchirche, yeoman 3
5174009 2408097 2408097 defendant Gylle William yeoman 710389 710389 Gylle, William, of Whitchirche, yeoman 3
5459783 2492852 2492852 defendant Hill William yeoman 710389 710389 Hill, William, of Whitchirche, 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);