names

30 rows where place_id = 586279

✎ 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
3588346 1864005 1864005 defendant Clerke Thomas tailor 586279 586279 Clerke, Thomas, of Bolton Percy, tailor 0
3717980 1931920 1931920 defendant Tate John husbandman 586279 586279 Tate, John, of Bolton Percy, husbandman 0
3729459 1935461 1935461 defendant Ellesson Percival yeoman 586279 586279 Ellesson, Percival, of Bolton Percy, yeoman 0
3747577 1941158 1941158 defendant Coket Robert yeoman 586279 586279 Coket, Robert, of Bolton Percy, yeoman 0
3747578 1941158 1941158 defendant Webster William laborer 586279 586279 Webster, William, of Bolton Percy, laborer 1
3747579 1941158 1941158 defendant Yonger George laborer 586279 586279 Yonger, George, of Bolton Percy, laborer 2
3774893 1949876 1949876 defendant Coket Robert yeoman 586279 586279 Coket, Robert, of Bolton Percy, yeoman 1
3792551 1955527 1955527 defendant Coket Robert yeoman 586279 586279 Coket, Robert, of Bolton Percy, yeoman 0
3797592 1957143 1957143 defendant Doughte John husbandman 586279 586279 Doughte, John, of Bolton Percy, husbandman 0
3851150 1973950 1973950 defendant Doughty John yeoman 586279 586279 Doughty, John, of Bolton Percy, yeoman 1
4068774 2049123 2049123 plaintiff Laken Thomas (legal representative) 586279 586279 Laken, Thomas, of Bolton Percy, clerk, executors of 0
4068777 2049123 2049123 defendant Jeffrason Guy yeoman 586279 586279 Jeffrason, Guy, of Bolton Percy, yeoman 0
4317432 2136213 2136213 defendant Backhouse Ralph yeoman 586279 586279 Backhouse, Ralph, of Bolton Percy, yeoman 0
4439858 2181745 2181745 plaintiff Barton Henry de   586279 586279 Barton, Henry de, of Bolton Percy, parson 0
4439863 2181746 2181746 plaintiff Barton Henry de   586279 586279 Barton, Henry de, of Bolton Percy, parson 0
4461266 2188608 2188608 defendant Foghler Alexander le   586279 586279 Foghler, Alexander le, of Bolton Percy 1
4639802 2243146 2243146 plaintiff Crosse William   586279 586279 Crosse, William, of Bolton Percy 0
4639804 2243147 2243147 plaintiff Crosse William   586279 586279 Crosse, William, of Bolton Percy, formerly parson of the parish church 0
4639807 2243148 2243148 defendant Acastre John   586279 586279 Acastre, John, of Bolton Percy 0
4725372 2273227 2273227 defendant Warde John husbandman 586279 586279 Warde, John, of Bolton Percy, husbandman 1
5140916 2398462 2398462 defendant Andrewe Thomas yeoman 586279 586279 Andrewe, Thomas, of Bolton Percy, yeoman 0
5319297 2450864 2450864 defendant Bekwyth John yeoman 586279 586279 Bekwyth, John, of Bolton Percy, yeoman 0
5340917 2457356 2457356 defendant Wawen Robert yeoman 586279 586279 Wawen, Robert, of Bolton Percy, yeoman 1
5359946 2463149 2463149 defendant Walker Thomas   586279 586279 Walker, Thomas, of Bolton Percy 0
5394180 2473396 2473396 plaintiff Walker Thomas yeoman 586279 586279 Walker, Thomas, of Bolton Percy, yeoman 0
5420562 2481074 2481074 plaintiff Walker Thomas yeoman 586279 586279 Walker, Thomas, of Bolton Percy, yeoman 0
5420569 2481075 2481075 plaintiff Walker Thomas yeoman 586279 586279 Walker, Thomas, of Bolton Percy, yeoman 0
5599150 2534615 2534615 defendant Clerke alias Smyth Christopher   586279 586279 Clerke alias Smyth, Christopher, of Bolton Percy, parish clerk 0
5610685 2547061 2547061 plaintiff Barton Henry de   586279 586279 Barton, Henry de, of Bolton Percy, parson 0
5610687 2547062 2547062 plaintiff Barton Henry de   586279 586279 Barton, Henry de, of Bolton Percy, parson 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);