names

56 rows where place_id = 610116

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593900 1865730 1865730 defendant Metcalf Thomas   610116 610116 Metcalf, Thomas, of Baynton, parish clerk 0
3682020 1920483 1920483 defendant Marshe John husbandman 610116 610116 Marshe, John, of Baynton, husbandman 0
3820808 1964400 1964400 plaintiff Rede Maurice (legal representative) 610116 610116 Rede, Maurice, of Baynton, yeoman, executors of 0
3943784 2004936 2004936 defendant Wyttye John laborer 610116 610116 Wyttye, John, of Baynton, laborer 5
4067766 2048783 2048783 defendant Geare Robert yeoman 610116 610116 Geare, Robert, of Baynton, yeoman 0
4070873 2049882 2049882 plaintiff Merywether John (legal representative) 610116 610116 Merywether, John, of Baynton, executor of 0
4095430 2058689 2058689 defendant Thompson Thomas husbandman 610116 610116 Thompson, Thomas, of Baynton, husbandman 0
4132777 2072049 2072049 defendant Kirke Thomas yeoman 610116 610116 Kirke, Thomas, of Baynton, yeoman 0
4154971 2079834 2079834 defendant Nelson alias Wayneman John gent or husbandman 610116 610116 Nelson alias Wayneman, John, of Baynton, gent or husbandman 0
4156693 2080419 2080419 defendant Kyrke Thomas yeoman 610116 610116 Kyrke, Thomas, of Baynton, yeoman 0
4164634 2083140 2083140 defendant Hardy John yeoman 610116 610116 Hardy, John, of Baynton, yeoman 0
4188200 2091377 2091377 defendant Hardye John yeoman 610116 610116 Hardye, John, of Baynton, yeoman 0
4193567 2093318 2093318 defendant Hardye John yeoman 610116 610116 Hardye, John, of Baynton, yeoman 0
4211648 2099625 2099625 defendant Hardye John yeoman 610116 610116 Hardye, John, of Baynton, yeoman 0
4223857 2103830 2103830 defendant Slater William yeoman 610116 610116 Slater, William, of Baynton, yeoman 0
4251449 2113466 2113466 defendant Slater William yeoman 610116 610116 Slater, William, of Baynton, yeoman 0
4254652 2114545 2114545 defendant Sigston Thomas husbandman 610116 610116 Sigston, Thomas, of Baynton, husbandman 0
4254653 2114545 2114545 defendant Sigston Robert husbandman 610116 610116 Sigston, Robert, of Baynton, husbandman 1
4266929 2118582 2118582 defendant Lynsey Robert laborer 610116 610116 Lynsey, Robert, of Baynton, laborer 0
4268597 2119093 2119093 defendant Hardy John   610116 610116 Hardy, John, of Baynton yeoman 0
4314453 2135167 2135167 defendant Baker William husbandman 610116 610116 Baker, William, of Baynton, husbandman 0
4319392 2136888 2136888 defendant Nelson John yeoman 610116 610116 Nelson, John, of Baynton, yeoman 0
4338519 2143225 2143225 defendant Styles Thomas gent 610116 610116 Styles, Thomas, of Baynton, gent 0
4338520 2143225 2143225 defendant Cranwell William yeoman 610116 610116 Cranwell, William, of Baynton, yeoman 1
4338521 2143225 2143225 defendant Doughtye Thomas laborer 610116 610116 Doughtye, Thomas, of Baynton, laborer 2
4446842 2183927 2183927 defendant Clerk John   610116 610116 Clerk, John, of Baynton 0
4468119 2190700 2190700 defendant del Boure Adam   610116 610116 del Boure, Adam, of Baynton 2
4487455 2196791 2196791 plaintiff Smyth John   610116 610116 Smyth, John, of Baynton, on his own account 0
4573621 2223263 2223263 defendant Rygger John   610116 610116 Rygger, John, of Baynton 3
4573626 2223264 2223264 defendant Rynger John   610116 610116 Rynger, John, of Baynton 3
4585494 2226888 2226888 defendant Boure Adam de   610116 610116 Boure, Adam de, of Baynton 0
4602224 2231913 2231913 defendant del Bowr Hugh   610116 610116 del Bowr, Hugh, of Baynton 0
4614386 2235508 2235508 defendant Shalkok John   610116 610116 Shalkok, John, of Baynton 0
4670756 2256531 2256531 plaintiff Burne Cecilia de   610116 610116 Burne, Cecilia de, of Baynton, formerly wife of Thomas 0
4684694 2260814 2260814 defendant Kaa John husbandman 610116 610116 Kaa, John, of Baynton, husbandman 0
4725863 2273376 2273376 defendant Godale Roger   610116 610116 Godale, Roger, of Baynton, parson 1
4725867 2273377 2273377 defendant Godale Roger   610116 610116 Godale, Roger, of Baynton, parson 1
4752666 2281239 2281239 defendant Maltby John husbandman 610116 610116 Maltby, John, of Baynton, husbandman 7
4814441 2300624 2300624 defendant Syggelston William husbandman 610116 610116 Syggelston, William, of Baynton, husbandman 1
4863317 2315492 2315492 defendant Betonson Thomas husbandman 610116 610116 Betonson, Thomas, of Baynton, husbandman 6
4863318 2315492 2315492 defendant Flesshewer Richard husbandman 610116 610116 Flesshewer, Richard, of Baynton, husbandman 7
4867428 2316780 2316780 defendant Idewyn Richard husbandman 610116 610116 Idewyn, Richard, of Baynton, husbandman 1
4878744 2320288 2320288 defendant Garthome Thomas flesshewer or butcher 610116 610116 Garthome, Thomas, of Baynton, flesshewer or butcher 6
4883658 2321803 2321803 defendant Charyndon Adam husbandman 610116 610116 Charyndon, Adam, of Baynton, husbandman 0
4910257 2329722 2329722 defendant Smalle John husbandman 610116 610116 Smalle, John, of Baynton, husbandman 3
4911229 2330019 2330019 defendant atte Marre William husbandman 610116 610116 atte Marre, William, of Baynton, husbandman 8
4911230 2330019 2330019 defendant Betenson William husbandman 610116 610116 Betenson, William, of Baynton, husbandman 9
5088546 2383024 2383024 plaintiff Kynnyowe John (legal representative) 610116 610116 Kynnyowe, John, of Baynton, executor of 0
5139765 2398108 2398108 defendant Burneby John yeoman 610116 610116 Burneby, John, of Baynton,yeoman 1
5234559 2425695 2425695 defendant Jakson Robert   610116 610116 Jakson, Robert,of Baynton, cartwright 1
5360563 2463335 2463335 defendant Thomlynson Thomas yeoman 610116 610116 Thomlynson, Thomas, of Baynton, yeoman 0
5360564 2463335 2463335 defendant Porter John yeoman 610116 610116 Porter, John, of Baynton, yeoman 1
5360565 2463335 2463335 defendant Clerk William   610116 610116 Clerk, William, of Baynton, holy water clerk 2
5360566 2463335 2463335 defendant Londer or Louder John yeoman 610116 610116 Londer or Louder, John, of Baynton, yeoman 3
5360567 2463335 2463335 defendant Tomson Richard yeoman 610116 610116 Tomson, Richard, of Baynton, yeoman 4
5490057 2501909 2501909 defendant Phelippes Robert husbandman 610116 610116 Phelippes, Robert, of Baynton, 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);