names

34 rows where place_id = 619836

✎ 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
3732170 1936298 1936298 defendant Colman William husbandman 619836 619836 Colman, William, of Sutton in Holdernes, husbandman 0
3732171 1936298 1936298 defendant Peryson John husbandman 619836 619836 Peryson, John, of Sutton in Holdernes, husbandman 1
4053804 2043738 2043738 defendant Harpor John husbandman 619836 619836 Harpor, John, of Sutton in Holdernes, husbandman 1
4131852 2071705 2071705 defendant Cowlinge John yeoman 619836 619836 Cowlinge, John, of Sutton in Holdernes, yeoman 0
4131854 2071706 2071706 defendant Cowlynge John yeoman 619836 619836 Cowlynge, John, of Sutton in Holdernes, yeoman 0
4165621 2083477 2083477 defendant Harper John yeoman 619836 619836 Harper, John, of Sutton in Holdernes, yeoman 2
4166382 2083737 2083737 defendant Wawne William yeoman 619836 619836 Wawne, William, of Sutton in Holdernes, yeoman 0
4175275 2086819 2086819 defendant Cowlinge John yeoman 619836 619836 Cowlinge, John, of Sutton in Holdernes, yeoman 1
4183102 2089573 2089573 defendant Cowlinge John yeoman 619836 619836 Cowlinge, John, of Sutton in Holdernes, yeoman 2
4183106 2089574 2089574 defendant Collinge John yeoman 619836 619836 Collinge, John, of Sutton in Holdernes, yeoman 2
4221434 2102989 2102989 defendant Harrison Joseph yeoman 619836 619836 Harrison, Joseph, of Sutton in Holdernes, yeoman 3
4221435 2102989 2102989 defendant Harrison Thomas yeoman 619836 619836 Harrison, Thomas, of Sutton in Holdernes, yeoman 4
4225257 2104301 2104301 defendant Watkingson William husbandman 619836 619836 Watkingson, William, of Sutton in Holdernes, husbandman 0
4225258 2104301 2104301 defendant Waghen William husbandman 619836 619836 Waghen, William, of Sutton in Holdernes, husbandman 1
4264382 2117729 2117729 defendant Chester John gent 619836 619836 Chester, John, of Sutton in Holdernes, gent 3
4265549 2118117 2118117 defendant Waghen or Wayhen William husbandman 619836 619836 Waghen or Wayhen, William, of Sutton in Holdernes, husbandman 0
4320838 2137379 2137379 defendant Browne George husbandman 619836 619836 Browne, George, of Sutton in Holdernes, husbandman 1
4625816 2239026 2239026 plaintiff Person John   619836 619836 Person, John, of Sutton in Holdernes 0
4748625 2280094 2280094 plaintiff Merflete Robert   619836 619836 Merflete, Robert, of Sutton in Holdernes, parson 1
4784233 2291067 2291067 defendant Docheman James tailor 619836 619836 Docheman, James, of Sutton in Holdernes, tailor 2
4817046 2301429 2301429 defendant Wetwang Thomas husbandman 619836 619836 Wetwang, Thomas, of Sutton in Holdernes, husbandman 2
5216488 2420552 2420552 defendant Swaledale John husbandman 619836 619836 Swaledale, John, of Sutton in Holdernes, husbandman 0
5216494 2420553 2420553 defendant Swaledall John yeoman 619836 619836 Swaledall, John, of Sutton in Holdernes, yeoman 0
5228569 2423961 2423961 defendant Swaldale John merchant 619836 619836 Swaldale, John, of Sutton in Holdernes, merchant 2
5290098 2442110 2442110 defendant Bek William husbandman 619836 619836 Bek, William, of Sutton in Holdernes, husbandman 0
5369169 2465959 2465959 defendant Swaldall John yeoman 619836 619836 Swaldall, John, of Sutton in Holdernes, yeoman 0
5378038 2468709 2468709 defendant Thomlynson John yeoman 619836 619836 Thomlynson, John, of Sutton in Holdernes, yeoman 0
5378042 2468710 2468710 defendant Thomlynson John yeoman 619836 619836 Thomlynson, John, of Sutton in Holdernes, yeoman 0
5492791 2502762 2502762 defendant Lopholme William husbandman 619836 619836 Lopholme, William, of Sutton in Holdernes, husbandman 1
5492792 2502762 2502762 defendant Hogge Stephen husbandman 619836 619836 Hogge, Stephen, of Sutton in Holdernes, husbandman 2
5492793 2502762 2502762 defendant Kyrke William husbandman 619836 619836 Kyrke, William, of Sutton in Holdernes, husbandman 3
5492794 2502762 2502762 defendant Cadeby William chaplain 619836 619836 Cadeby, William, of Sutton in Holdernes, chaplain 4
5508755 2507591 2507591 defendant Thomlynson John yeoman 619836 619836 Thomlynson, John, of Sutton in Holdernes, yeoman 0
5515958 2509837 2509837 defendant Lophome William yeoman 619836 619836 Lophome, William, of Sutton in Holdernes, yeoman 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);