names

25 rows where place_id = 604028

✎ 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
3656611 1912321 1912321 defendant Downyng John butcher 604028 604028 Downyng, John, of Acle, Norf, butcher 2
3665367 1915121 1915121 defendant Clere Thomas gent 604028 604028 Clere, Thomas, of Acle, Norf, gent 1
3680247 1919893 1919893 defendant Sendelle George   604028 604028 Sendelle, George, of Acle, Norf, worsted weaver 2
3720095 1932561 1932561 defendant Clere Thomas esq 604028 604028 Clere, Thomas, of Acle, Norf, esq 0
3720098 1932562 1932562 defendant Clere Thomas esq 604028 604028 Clere, Thomas, of Acle, Norf, esq 0
3822781 1965030 1965030 plaintiff Swan John   604028 604028 Swan, John, of Acle, Norf 0
3848058 1972968 1972968 defendant Jermyn Edward gent 604028 604028 Jermyn, Edward, of Acle, Norf, gent 0
3871515 1980717 1980717 defendant Clere Thomas esq 604028 604028 Clere, Thomas, of Acle, Norf, esq 1
3879026 1983236 1983236 defendant Hexham Christopher tailor 604028 604028 Hexham, Christopher, of Acle, Norf, tailor 1
4102981 2061356 2061356 defendant Darlett John yeoman 604028 604028 Darlett, John, of Acle, Norf, yeoman 0
4140088 2074701 2074701 defendant Duffeild John clerk 604028 604028 Duffeild, John, of Acle, Norf, clerk 0
4252559 2113846 2113846 defendant Burrell Henry husbandman 604028 604028 (Burrell, Henry, of Acle, Norf, husbandman 2
4252563 2113847 2113847 defendant Burrell Henry husbandman 604028 604028 (Burrell, Henry, of Acle, Norf, husbandman 2
4263416 2117425 2117425 defendant Spanton Miles yeoman 604028 604028 Spanton, Miles, of Acle, Norf, yeoman 1
4274000 2120849 2120849 defendant Spanton Miles yeoman 604028 604028 Spanton, Miles, of Acle, Norf, yeoman 1
4282088 2123636 2123636 defendant Spanton Miles yeoman 604028 604028 Spanton, Miles, of Acle, Norf, yeoman 0
5046070 2370451 2370451 defendant Gylys John sadler 604028 604028 Gylys, John, of Acle, Norf, sadler 0
5099154 2386177 2386177 defendant atte Wode Thomas clerk 604028 604028 atte Wode, Thomas, of Acle, Norf, clerk 0
5355069 2461654 2461654 defendant Hendy William husbandman 604028 604028 Hendy, William, of Acle, Norf, husbandman 0
5369083 2465927 2465927 defendant Palmer Robert husbandman 604028 604028 Palmer, Robert, of Acle, Norf, husbandman 3
5376692 2468306 2468306 plaintiff Goodewyn John, junior husbandman 604028 604028 Goodewyn, John, junior, of Acle, Norf, husbandman 1
5377787 2468636 2468636 plaintiff Goodwyn John, junior husbandman 604028 604028 Goodwyn, John, junior, of Acle, Norf, husbandman 1
5386304 2471147 2471147 defendant Hyndy John smith 604028 604028 Hyndy, John, of Acle, Norf, smith 0
5443456 2487955 2487955 defendant (illegible) Henry husbandman 604028 604028 _, Henry, of Acle, Norf, husbandman 6
5581922 2529428 2529428 defendant Fulcher John butcher 604028 604028 Fulcher, John, of Acle, Norf, butcher 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);