names

37 rows where place_id = 604247

✎ 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
3657354 1912560 1912560 defendant Durrant William husbandman 604247 604247 Durrant, William, of Redburne, husbandman 1
3657355 1912560 1912560 defendant Robynson Richard tailor 604247 604247 Robynson, Richard, of Redburne, tailor 2
3657356 1912560 1912560 defendant Robynson John tailor 604247 604247 Robynson, John, of Redburne, tailor 3
3657357 1912560 1912560 defendant Barnes Hugh laborer 604247 604247 Barnes, Hugh, of Redburne, laborer 4
3680356 1919934 1919934 defendant Stokkys John husbandman 604247 604247 Stokkys, John, of Redburne, husbandman 0
3816439 1963052 1963052 defendant Cranewell Richard yeoman 604247 604247 Cranewell, Richard, of Redburne, yeoman 2
4134416 2072638 2072638 defendant Dallyson Thomas gent 604247 604247 Dallyson, Thomas, of Redburne, gent 0
4134417 2072638 2072638 defendant Waterhouse Gerard husbandman 604247 604247 Waterhouse, Gerard, of Redburne, husbandman 1
4364175 2152243 2152243 defendant Gotheram Thomas yeoman 604247 604247 Gotheram, Thomas, of Redburne, yeoman 0
4364178 2152244 2152244 defendant Gotheram Thomas yeoman 604247 604247 Gotheram, Thomas, of Redburne, yeoman 0
4376502 2156665 2156665 defendant Gotherham Thomas yeoman 604247 604247 Gotherham, Thomas, of Redburne, yeoman 0
4512366 2204310 2204310 plaintiff Boteler Thomas   604247 604247 Boteler, Thomas, of Redburne 0
4512367 2204310 2204310 defendant Clerk John   604247 604247 Clerk, John, of Redburne 0
4523590 2207702 2207702 defendant Tudde William   604247 604247 Tudde, William, of Redburne 1
4700913 2265689 2265689 defendant Couper John husbandman 604247 604247 Couper, John, of Redburne, husbandman 1
4734653 2275995 2275995 defendant Smyth Henry smith 604247 604247 Smyth, Henry, of Redburne, smith 0
4812912 2300150 2300150 defendant Valdaunce John   604247 604247 Valdaunce, John, of Redburne, land holder 1
4812915 2300151 2300151 defendant Palmere John yeoman 604247 604247 Palmere, John, of Redburne, yeoman 0
4812916 2300151 2300151 defendant Valaunce John   604247 604247 Valaunce, John, of Redburne, land holder 1
4815788 2301041 2301041 defendant Palmere John husbandman 604247 604247 Palmere, John, of Redburne, husbandman 1
4815791 2301042 2301042 defendant Palmere John husbandman 604247 604247 Palmere, John, of Redburne, husbandman 1
4816453 2301236 2301236 defendant Palmer John husbandman 604247 604247 Palmer, John, of Redburne, husbandman 0
4821849 2302908 2302908 defendant Felse John husbandman 604247 604247 Felse, John, of Redburne, husbandman 0
4821853 2302909 2302909 defendant Felse John husbandman 604247 604247 Felse, John, of Redburne, husbandman 0
4821854 2302909 2302909 defendant Streven John husbandman 604247 604247 Streven, John, of Redburne, husbandman 1
4842986 2309349 2309349 defendant Palmer Lawrence husbandman 604247 604247 Palmer, Lawrence, of Redburne, husbandman 0
4849381 2311285 2311285 defendant Sumpter William yeoman 604247 604247 Sumpter, William, of Redburne, yeoman 2
4849386 2311286 2311286 defendant Sumpter William yeoman 604247 604247 Sumpter, William, of Redburne, yeoman 1
4851986 2312055 2312055 defendant Sumpter William yeoman 604247 604247 Sumpter, William, of Redburne, yeoman 0
4852786 2312289 2312289 defendant Palmer John husbandman 604247 604247 Palmer, John, of Redburne, husbandman 0
4852787 2312289 2312289 defendant Palmer Lawrence husbandman 604247 604247 Palmer, Lawrence, of Redburne, husbandman 1
4852790 2312290 2312290 defendant Palmer John husbandman 604247 604247 Palmer, John, of Redburne, husbandman 0
4852791 2312290 2312290 defendant Palmer Lawrence husbandman 604247 604247 Palmer, Lawrence, of Redburne, husbandman 1
4898645 2326222 2326222 defendant Palmer John husbandman 604247 604247 Palmer, John, of Redburne, husbandman 1
5341701 2457596 2457596 defendant Brownlas Richard husbandman 604247 604247 Brownlas, Richard, of Redburne, husbandman 8
5525753 2512643 2512643 defendant Grubbe Thomas husbandman 604247 604247 Grubbe, Thomas, of Redburne, husbandman 1
5558997 2522586 2522586 defendant Wystowe William gent 604247 604247 Wystowe, William, of Redburne, 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);