names

27 rows where place_id = 598440

✎ 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
3632515 1904988 1904988 defendant Shakrys Richard husbandman 598440 598440 Shakrys, Richard, of Lalleford, husbandman 2
3632520 1904989 1904989 defendant Shakrys Richard husbandman 598440 598440 Shakrys, Richard, of Lalleford, husbandman 2
3632526 1904990 1904990 defendant Shakrys Richard husbandman 598440 598440 Shakrys, Richard, of Lalleford, husbandman 3
4559841 2219029 2219029 defendant Gulle John   598440 598440 Gulle, John, of Lalleford 1
4571586 2222692 2222692 defendant Killere Thomas   598440 598440 Killere, Thomas, of Lalleford 0
4577265 2224409 2224409 defendant Cranefen James   598440 598440 Cranefen, James, of Lalleford 0
4594376 2229498 2229498 defendant Hamond John   598440 598440 Hamond, John, of Lalleford 0
4625244 2238861 2238861 defendant Bentlee Thomas (legal representative) 598440 598440 Bentlee, Thomas, of Lalleford, smith, executors of 0
4625245 2238861 2238861 defendant North John weaver 598440 598440 (North, John, of Lalleford, weaver 1
4625246 2238861 2238861 defendant Fadyn William   598440 598440 Fadyn, William, of Lalleford 2
4635676 2242005 2242005 defendant Matheu Robert   598440 598440 Matheu, Robert, of Lalleford 0
4704018 2266636 2266636 defendant Sharp John laborer 598440 598440 Sharp, John, of Lalleford, laborer 0
4716704 2270545 2270545 plaintiff Doget Thomas   598440 598440 Doget, Thomas, of Lalleford, parson 4
4753182 2281380 2281380 defendant Morice John husbandman 598440 598440 Morice, John, of Lalleford, husbandman 0
4760114 2283508 2283508 defendant atte Hall Thomas husbandman 598440 598440 atte Hall, Thomas, of Lalleford, husbandman 0
4760115 2283508 2283508 defendant atte Hall Richard husbandman 598440 598440 atte Hall, Richard, of Lalleford, husbandman 1
4837740 2307737 2307737 defendant Moreys John husbandman 598440 598440 Moreys, John, of Lalleford, husbandman 0
4837741 2307737 2307737 defendant Dale John husbandman 598440 598440 Dale, John, of Lalleford, husbandman 1
4837745 2307738 2307738 defendant Moreys John husbandman 598440 598440 Moreys, John, of Lalleford, husbandman 0
4837746 2307738 2307738 defendant Dale John husbandman 598440 598440 Dale, John, of Lalleford, husbandman 1
4933294 2336804 2336804 defendant Boode Thomas husbandman 598440 598440 Boode, Thomas, of Lalleford, husbandman 0
4934906 2337319 2337319 plaintiff Barkere John   598440 598440 Barkere, John, of Lalleford 0
4957840 2344316 2344316 defendant Reve John courser 598440 598440 Reve, John, of Lalleford, courser 1
5017154 2361917 2361917 defendant Mant or Maut Thomas husbandman 598440 598440 Mant or Maut, Thomas, of Lalleford, husbandman 1
5367001 2465327 2465327 defendant Hayll Edmund husbandman 598440 598440 Hayll, Edmund, of Lalleford, husbandman 0
5397636 2474393 2474393 defendant Hayle Edmund husbandman 598440 598440 Hayle. Edmund, of Lalleford, husbandman 0
5410764 2478167 2478167 defendant Hayll Edmund husbandman 598440 598440 Hayll, Edmund, of Lalleford, 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);