names

31 rows where place_id = 618029

✎ 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
3596300 1866472 1866472 defendant Swyft Robert   618029 618029 Swyft, Robert, of Byrmyngeham, Warks, scythe maker 1
3599632 1867528 1867528 defendant Swyft Robert   618029 618029 Swyft, Robert, of Byrmyngeham, Warks, scythe maker 0
3722506 1933299 1933299 defendant Byrmyngeham William gent 618029 618029 Byrmyngeham, William, of Byrmyngeham, Warks, gent 0
3731054 1935940 1935940 defendant Wykstede John yeoman 618029 618029 Wykstede, John, of Byrmyngeham, Warks, yeoman 1
3758370 1944613 1944613 defendant Byrmyngeham Edward esq 618029 618029 Byrmyngeham, Edward, of Byrmyngeham, Warks, esq 0
3769215 1948024 1948024 defendant Cowper Henry mercer 618029 618029 Cowper, Henry, of Byrmyngeham, Warks, mercer 0
3838024 1969804 1969804 defendant Preston Robert shoemaker 618029 618029 Preston, Robert, of Byrmyngeham, Warks, shoemaker 0
3855173 1975251 1975251 defendant Crosse Henry upholsterer 618029 618029 Crosse, Henry, of Byrmyngeham, Warks, upholsterer 2
3855178 1975252 1975252 defendant Crosse Henry upholsterer 618029 618029 Crosse, Henry, of Byrmyngeham, Warks, upholsterer 2
3880539 1983748 1983748 defendant Shelton alias Chapmon John chapman 618029 618029 Shelton alias Chapmon, John, of Byrmyngeham, Warks, chapman 0
3925751 1998928 1998928 plaintiff Wylleys John yeoman or ironmonger 618029 618029 Wylleys, John, of Byrmyngeham, Warks, yeoman or ironmonger 0
4903349 2327656 2327656 defendant Lyndon William skinner 618029 618029 Lyndon, William, of Byrmyngeham, Warks, skinner 2
5023138 2363669 2363669 defendant Byrmyngeham William esq 618029 618029 Byrmyngeham, William, of Byrmyngeham, Warks, esq 0
5023141 2363670 2363670 defendant Byrmyngeham William esq 618029 618029 Byrmyngeham, William, of Byrmyngeham, Warks, esq 0
5088885 2383126 2383126 defendant Waterfall Roger butcher 618029 618029 Waterfall, Roger, of Byrmyngeham, Warks, butcher 1
5102150 2387055 2387055 defendant Shyngler John chaplain 618029 618029 Shyngler, John, of Byrmyngeham, Warks, chaplain 0
5109770 2389286 2389286 defendant Arblaster Richard yeoman 618029 618029 Arblaster, Richard, of Byrmyngeham, Warks, yeoman 0
5110237 2389402 2389402 defendant Birmyngeham William   618029 618029 Birmyngeham, William, of Byrmyngeham, Warks, knight 0
5257158 2432374 2432374 defendant Byrmyngeham William   618029 618029 Byrmyngeham, William, of Byrmyngeham, Warks, knight 0
5258536 2432785 2432785 defendant Byrmyngeham William   618029 618029 Byrmyngeham, William, of Byrmyngeham, Warks, knight 0
5260734 2433479 2433479 defendant Brommeley Richard yeoman 618029 618029 Brommeley, Richard, of Byrmyngeham, Warks, yeoman 0
5265024 2434822 2434822 defendant Byrmyngeham William   618029 618029 Byrmyngeham, William, of Byrmyngeham, Warks, knight 0
5265435 2434948 2434948 defendant Byrmyngeham William   618029 618029 Byrmyngeham, William, of Byrmyngeham, Warks, knight 0
5280257 2439303 2439303 defendant Phelippes William yeoman 618029 618029 Phelippes, William, of Byrmyngeham, Warks, yeoman 1
5317847 2450424 2450424 defendant Jenkyns Thomas yeoman 618029 618029 Jenkyns, Thomas, of Byrmyngeham, Warks, yeoman 0
5317849 2450425 2450425 defendant Jenkyns Thomas yeoman 618029 618029 Jenkyns, Thomas, of Byrmyngeham, Warks, yeoman 0
5327921 2453420 2453420 defendant Byrmyngeham William   618029 618029 (Byrmyngeham, William, of Byrmyngeham, Warks, knight 1
5340073 2457104 2457104 defendant Hichecokkys Eustace grasier 618029 618029 Hichecokkys, Eustace, of Byrmyngeham, Warks, grasier 0
5517052 2510166 2510166 defendant Lloid Lewis yeoman 618029 618029 Lloid, Lewis, of Byrmyngeham, Warks, yeoman 0
5530022 2513898 2513898 defendant Joce John gent 618029 618029 Joce, John, of Byrmyngeham, Warks, gent 0
5572575 2526523 2526523 defendant Symondys Humphrey gent 618029 618029 Symondys, Humphrey, of Byrmyngeham, Warks, gent 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);