names

33 rows where place_id = 622389

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3746752 1940899 1940899 plaintiff Crane Robert gent 622389 622389 Crane, Robert, of Shilton, gent 0
3968889 2013745 2013745 defendant Watkyn John husbandman 622389 622389 Watkyn, John, of Shilton, husbandman 1
4284131 2124370 2124370 defendant Warde John husbandman 622389 622389 Warde, John, of Shilton, yeoman, son of Robert Warde, of Shilton, husbandman 0
4606367 2233107 2233107 defendant Tokes John   622389 622389 Tokes, John, of Shilton 1
4673393 2257316 2257316 defendant Whyte Richard husbandman 622389 622389 Whyte, Richard, of Shilton, husbandman 3
4771525 2287075 2287075 defendant atte Brygge John husbandman 622389 622389 atte Brygge, John, of Shilton, husbandman 6
4771526 2287075 2287075 defendant Crafte John husbandman 622389 622389 Crafte, John, of Shilton, husbandman 7
4771527 2287075 2287075 defendant atte Lane Richard husbandman 622389 622389 atte Lane, Richard, of Shilton, husbandman 8
4771528 2287075 2287075 defendant Taillour John husbandman 622389 622389 Taillour, John, of Shilton, husbandman 9
4771539 2287076 2287076 defendant Veysy Robert husbandman 622389 622389 Veysy, Robert, of Shilton, husbandman 9
4771540 2287076 2287076 defendant Taillour William husbandman 622389 622389 Taillour, William, of Shilton, husbandman 10
4779965 2289734 2289734 defendant Warde Adam weaver 622389 622389 Warde, Adam, of Shilton, weaver 0
4796584 2295083 2295083 defendant atte Brigge John   622389 622389 atte Brigge, John, of Shilton 6
4796585 2295083 2295083 defendant Crafte John husbandman 622389 622389 Crafte, John, of Shilton, husbandman 7
4796586 2295083 2295083 defendant atte Lane Richard husbandman 622389 622389 atte Lane, Richard, of Shilton, husbandman 8
4796587 2295083 2295083 defendant Taillour John husbandman 622389 622389 Taillour, John, of Shilton, husbandman 9
4813490 2300330 2300330 plaintiff Hille Robert   622389 622389 Hille, Robert, of Shilton, on his own account 0
4813496 2300331 2300331 plaintiff Hille Robert   622389 622389 Hille, Robert, of Shilton, on his own account 0
4813502 2300332 2300332 plaintiff Hille Robert   622389 622389 Hille, Robert, of Shilton, on his own account 0
4835024 2306956 2306956 defendant Gardyner William husbandman 622389 622389 Gardyner, William, of Shilton, husbandman 0
4835025 2306956 2306956 defendant Brygges John husbandman 622389 622389 Brygges, John, of Shilton, husbandman 1
4854822 2312858 2312858 defendant Paas Henry husbandman 622389 622389 Paas, Henry, of Shilton, husbandman 1
4919483 2332597 2332597 plaintiff Hille Robert esq 622389 622389 Hille, Robert, of Shilton, esq 0
4975247 2349551 2349551 defendant Sclater William miller 622389 622389 Sclater, William, of Shilton, miller 0
5001842 2357438 2357438 defendant Mylner William milner 622389 622389 Mylner, William, of Shilton, milner 0
5063168 2375519 2375519 defendant Southfolk William, senior husbandman 622389 622389 Southfolk, William, senior, of Shilton, husbandman 0
5063174 2375520 2375520 defendant Southfolk William, senior husbandman 622389 622389 Southfolk, William, senior, of Shilton, husbandman 0
5256434 2432135 2432135 defendant Pomerey John husbandman 622389 622389 Pomerey, John, of Shilton, husbandman 0
5256435 2432135 2432135 defendant Bradname Richard husbandman 622389 622389 Bradname, Richard, of Shilton, husbandman 1
5256436 2432135 2432135 defendant Short John, junior husbandman 622389 622389 Short, John, junior, of Shilton, husbandman 2
5256437 2432135 2432135 defendant Short Thomas husbandman 622389 622389 Short, Thomas, of Shilton, husbandman 3
5263066 2434190 2434190 defendant Brednan John husbandman 622389 622389 Brednan, John, of Shilton, husbandman 0
5339002 2456769 2456769 defendant Aleyn Thomas husbandman 622389 622389 Aleyn, Thomas, of Shilton, 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);