names

30 rows where place_id = 599154

✎ 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
3635539 1905916 1905916 defendant Newman William yeoman 599154 599154 Newman, William, of Bolyngton, yeoman 1
4442445 2182583 2182583 plaintiff Buchel Thomas   599154 599154 Buchel, Thomas, of Bolyngton 0
4442447 2182583 2182583 defendant Rason Roger de   599154 599154 Rason, Roger de, of Bolyngton 1
4498257 2200111 2200111 defendant Wedoson John   599154 599154 Wedoson, John, of Bolyngton 0
4556830 2218072 2218072 defendant Gladewye John   599154 599154 Gladewye, John, of Bolyngton 0
4575740 2223923 2223923 plaintiff Brampton Robert   599154 599154 Brampton, Robert, of Bolyngton, prior 0
4669445 2256149 2256149 defendant Gray William tanner 599154 599154 Gray, William, of Bolyngton, tanner 0
4692072 2263051 2263051 defendant Refham John yeoman 599154 599154 Refham, John, of Bolyngton, yeoman 7
4692877 2263278 2263278 defendant Resham John yeoman 599154 599154 Resham, John, of Bolyngton, yeoman 7
4721633 2272097 2272097 defendant atte Vicares John yeoman 599154 599154 atte Vicares, John, of Bolyngton, yeoman 1
4721634 2272097 2272097 defendant Stabull William of the yeoman 599154 599154 Stabull, William of the, of Bolyngton, yeoman 2
4723891 2272773 2272773 defendant Tonford Robert thatcher 599154 599154 Tonford, Robert, of Bolyngton, thatcher 6
4736583 2276571 2276571 defendant Vykerman John husbandman 599154 599154 together with Vykerman, John, of Bolyngton, husbandman 3
4736584 2276571 2276571 defendant Dyker Richard husbandman 599154 599154 Dyker, Richard, of Bolyngton, husbandman 4
4736586 2276572 2276572 defendant Vykerman John husbandman 599154 599154 Vykerman, John, of Bolyngton, husbandman 0
4775169 2288228 2288228 defendant Bourton John tailor 599154 599154 Bourton, John, of Bolyngton, tailor 0
4800940 2296483 2296483 defendant Bourton John tailor 599154 599154 Bourton, John, of Bolyngton, tailor 0
5091565 2383922 2383922 defendant Barker Nicholas barker 599154 599154 Barker, Nicholas, of Bolyngton, barker 3
5202104 2416383 2416383 defendant Wellys William   599154 599154 Wellys, William, of Bolyngton, servant 0
5376029 2468096 2468096 plaintiff Ruston Henry   599154 599154 Ruston, Henry, of Bolyngton 0
5392219 2472863 2472863 plaintiff (not given) Henry prior of Ruston 599154 599154 Ruston, Henry, of Bolyngton, prior of the house of the BM 0
5394131 2473382 2473382 defendant Lee Leonard yeoman 599154 599154 Lee, Leonard, of Bolyngton, yeoman 0
5402405 2475759 2475759 defendant (illegible) John tanner 599154 599154 ----, John, of Bolyngton, tanner 4
5407254 2477137 2477137 defendant Lee Leonard yeoman 599154 599154 Lee, Leonard, of Bolyngton, yeoman 0
5408421 2477490 2477490 defendant Lee Leonard yeoman 599154 599154 Lee, Leonard, of Bolyngton, yeoman 0
5415342 2479523 2479523 defendant Douse John tanner 599154 599154 Douse, John, of Bolyngton, tanner 4
5418332 2480408 2480408 plaintiff (not given) Henry prior of Ruston 599154 599154 Ruston, Henry, of Bolyngton, prior of the house of the BM 0
5431504 2484379 2484379 defendant Douse John tanner 599154 599154 Douse, John, of Bolyngton, tanner 0
5439324 2486691 2486691 defendant Lee Leonard yeoman 599154 599154 together with Lee, Leonard, of Bolyngton, yeoman 1
5630638 2553587 2553587 defendant de Stable William   599154 599154 de Stable, William, of Bolyngton 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);