names

56 rows where place_id = 600015

✎ 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
3639347 1907115 1907115 defendant Cutloke John husbandman 600015 600015 Cutloke, John, of North Reppes, husbandman 0
3641204 1907700 1907700 defendant Gumfrey John clerk 600015 600015 Gumfrey, John, of North Reppes, clerk 0
3705784 1928090 1928090 defendant Toly John husbandman 600015 600015 Toly, John, of North Reppes, husbandman 0
3705785 1928090 1928090 defendant Payn John husbandman 600015 600015 Payn, John, of North Reppes, husbandman 1
3705786 1928090 1928090 defendant Rugge Nicholas widower 600015 600015 Rugge, Nicholas, of North Reppes, husbandman, widower 2
3709154 1929160 1929160 plaintiff Playford John, senior (legal representative) 600015 600015 Playford, John, senior, of North Reppes, executor of 0
3740695 1938952 1938952 defendant Wursted William husbandman 600015 600015 Wursted, William, of North Reppes, husbandman 0
3770537 1948468 1948468 defendant Rugge Nicholas husbandman 600015 600015 Rugge, Nicholas, of North Reppes, husbandman 0
3922882 1997956 1997956 plaintiff Sawtre Robert   600015 600015 Sawtre, Robert, of North Reppes 0
3975598 2016030 2016030 defendant Andrews Edward husbandman 600015 600015 Andrews, Edward, of North Reppes, husbandman 0
3989422 2020956 2020956 defendant Fayer Robert, senior husbandman 600015 600015 Fayer, Robert, senior, of North Reppes, husbandman 0
3989423 2020956 2020956 defendant Faier Robert, junior husbandman 600015 600015 Faier, Robert, junior, of North Reppes, husbandman 1
3998362 2024153 2024153 defendant Barker Richard yeoman 600015 600015 Barker, Richard, of North Reppes, yeoman 0
3998364 2024153 2024153 defendant Hovell or Houell William husbandman 600015 600015 Hovell or Houell, William, of North Reppes, husbandman 2
4023255 2033024 2033024 defendant Faier Robert, senior husbandman 600015 600015 Faier, Robert, senior, of North Reppes, husbandman 0
4023256 2033024 2033024 defendant Faier Robert, junior husbandman 600015 600015 Faier, Robert, junior, of North Reppes, husbandman 1
4031262 2035853 2035853 defendant Barker Richard yeoman 600015 600015 Barker, Richard, of North Reppes, yeoman 0
4031264 2035853 2035853 defendant Hovell William husbandman 600015 600015 Hovell, William, of North Reppes, husbandman 2
4052986 2043504 2043504 plaintiff Alleyn Thomas   600015 600015 Alleyn, Thomas, of North Reppes, gent, attorney of the bench 0
4054551 2044016 2044016 defendant Fayer Robert yeoman 600015 600015 Fayer, Robert, of North Reppes, yeoman 0
4104303 2061818 2061818 defendant Neave Robert husbandman 600015 600015 Neave, Robert, of North Reppes, husbandman 0
4111171 2064248 2064248 defendant Pleyfford Henry gent 600015 600015 Pleyfford, Henry, of North Reppes, gent 0
4124652 2069112 2069112 defendant Worsted William husbandman 600015 600015 Worsted, William, of North Reppes, husbandman 2
4139573 2074515 2074515 defendant Allen Thomas gent 600015 600015 Allen, Thomas, of North Reppes, gent 0
4144909 2076379 2076379 defendant Thompson Nicholas husbandman 600015 600015 Thompson, Nicholas, of North Reppes, husbandman 0
4147180 2077152 2077152 defendant Alleyn Thomas gent 600015 600015 Alleyn, Thomas, of North Reppes, gent 0
4176001 2087085 2087085 defendant Alman Lambert clerk 600015 600015 Alman, Lambert, of North Reppes, clerk 2
4191341 2092535 2092535 defendant Tompson Nicholas husbandman 600015 600015 Tompson, Nicholas, of North Reppes, husbandman 0
4197964 2094837 2094837 defendant Alman Liberty clerk 600015 600015 Alman, Liberty, of North Reppes, clerk 0
4199361 2095329 2095329 defendant Alman Libertus clerk 600015 600015 Alman, Libertus, of North Reppes, clerk 0
4223789 2103806 2103806 defendant Colbye Thomas husbandman 600015 600015 Colbye, Thomas, of North Reppes, husbandman 0
4223790 2103806 2103806 defendant Payne Richard butcher 600015 600015 Payne, Richard, of North Reppes, butcher 1
4252144 2113702 2113702 defendant Worstead Thomas husbandman 600015 600015 Worstead, Thomas, of North Reppes, husbandman 2
4258925 2115957 2115957 defendant Comforte William gent 600015 600015 Comforte, William, of North Reppes, gent 1
4263304 2117391 2117391 defendant Payne Richard butcher 600015 600015 Payne, Richard, of North Reppes, butcher 3
4265469 2118089 2118089 defendant Archer William senior yeoman 600015 600015 Archer, William senior, of North Reppes, yeoman 0
4265470 2118089 2118089 defendant Archer William, junior husbandman 600015 600015 Archer, William, junior, of North Reppes, husbandman 1
4265471 2118089 2118089 defendant Archer Thomas carpenter 600015 600015 Archer, Thomas, of North Reppes, carpenter 2
4280650 2123136 2123136 defendant Marche Roger yeoman 600015 600015 Marche, Roger, of North Reppes, yeoman 0
4319086 2136792 2136792 defendant Grey Robert husbandman 600015 600015 Grey, Robert, of North Reppes, husbandman 0
4326225 2139137 2139137 defendant Rice Robert yeoman 600015 600015 Rice, Robert, of North Reppes, yeoman 0
4326226 2139137 2139137 defendant Graye William husbandman 600015 600015 Graye, William, of North Reppes, husbandman 1
4331578 2140858 2140858 defendant Ryce Clement laborer 600015 600015 Ryce, Clement, of North Reppes, laborer 0
4331579 2140858 2140858 defendant Key William tailor 600015 600015 Key, William, of North Reppes, tailor 1
4333437 2141462 2141462 defendant Colbye John yeoman 600015 600015 Colbye, John, of North Reppes, yeoman 3
4353882 2148582 2148582 defendant Tompson Nicholas yeoman 600015 600015 Tompson, Nicholas, of North Reppes, yeoman 0
4556851 2218077 2218077 defendant Colby John   600015 600015 Colby, John, of North Reppes 0
4669108 2256045 2256045 defendant Williamesson Adam yeoman 600015 600015 (Williamesson, Adam, of North Reppes, yeoman 2
4875388 2319259 2319259 defendant Calke Reginald butcher 600015 600015 Calke, Reginald, of North Reppes, butcher 0
4967396 2347190 2347190 defendant Groute Roger husbandman 600015 600015 Groute, Roger, of North Reppes, husbandman 1
4990716 2354133 2354133 defendant Blofed Thomas husbandman 600015 600015 Blofed, Thomas, of North Reppes, husbandman 3
5263752 2434416 2434416 defendant Sterlyng William husbandman 600015 600015 Sterlyng, William, of North Reppes, husbandman 0
5276882 2438320 2438320 defendant Potter Geoffrey husbandman 600015 600015 Potter, Geoffrey, of North Reppes, husbandman 1
5299098 2444717 2444717 defendant Freere John husbandman 600015 600015 Freere, John, of North Reppes, husbandman 4
5381483 2469765 2469765 defendant Toly Robert yeoman 600015 600015 Toly, Robert, of North Reppes, yeoman 0
5389010 2471911 2471911 defendant Toly Robert yeoman 600015 600015 Toly, Robert, of North Reppes, 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);