names

31 rows where place_id = 701766

✎ 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
3821535 1964632 1964632 defendant Toll Edward husbandman 701766 701766 Toll, Edward, of Est Halton, husbandman 1
3850133 1973632 1973632 defendant Walker Thomas husbandman 701766 701766 Walker, Thomas, of Est Halton juxta Humber, husbandman 0
3850134 1973632 1973632 defendant Wright Robert husbandman 701766 701766 Wright, Robert, of Est Halton juxta Humber, husbandman 1
3974879 2015778 2015778 defendant Odeson John laborer 701766 701766 Odeson, John, of Est Halton, laborer 0
4139932 2074647 2074647 defendant Toole Henry husbandman 701766 701766 Toole, Henry, of East Halton, husbandman 0
4139933 2074647 2074647 defendant Toole Michael husbandman 701766 701766 Toole, Michael, of East Halton, husbandman 1
4172899 2085973 2085973 defendant Dixon George smith 701766 701766 Dixon, George, of East Halton, smith 1
4176937 2087406 2087406 defendant Doughty John   701766 701766 Doughty, John, of East Halton, laborer, son of Thomas Doughty, of East Halton, "toftman" 0
4224459 2104036 2104036 defendant Scupholme Anthony gent 701766 701766 Scupholme, Anthony, of East Halton, gent 3
4226560 2104765 2104765 defendant Thwaytes William gent 701766 701766 Thwaytes, William, of East Halton, gent 1
4226742 2104827 2104827 defendant Somercott Christopher gent 701766 701766 Somercott, Christopher, of East Halton, gent 0
4232639 2106919 2106919 defendant Scupholme Anthony gent 701766 701766 Scupholme, Anthony, of East Halton, gent 3
4234730 2107694 2107694 defendant Pullon William laborer 701766 701766 Pullon, William, of East Halton, laborer 0
4235040 2107807 2107807 defendant Thwaites William gent 701766 701766 Thwaites, William, of East Halton, gent 1
4253679 2114221 2114221 defendant Pullon William laborer 701766 701766 Pullon, William, of East Halton, laborer 0
4276991 2121885 2121885 defendant Smothin or Smotham Thomas yeoman 701766 701766 Smothin or Smotham, Thomas, of East Halton, yeoman 0
4293269 2127654 2127654 defendant Boothe John clerk 701766 701766 Boothe, John, of East Halton, clerk 0
4293432 2127715 2127715 defendant Clarckholme Richard husbandman 701766 701766 Clarckholme, Richard, of East Halton, husbandman 0
4294522 2128127 2128127 defendant Somercotes Christopher gent 701766 701766 Somercotes, Christopher, of East Halton, gent 0
4327100 2139396 2139396 defendant Barker John husbandman 701766 701766 Barker, John, of East Halton, husbandman 0
4341668 2144366 2144366 defendant Baker John yeoman 701766 701766 Baker, John, of East Halton, yeoman 0
4360523 2150930 2150930 defendant Skupholme Anthony gent 701766 701766 Skupholme, Anthony, of East Halton, gent 0
4365330 2152665 2152665 defendant Neale Thomas weaver 701766 701766 Neale, Thomas, of Est Halton, yeoman, weaver 0
4366997 2153251 2153251 defendant Neale Thomas weaver 701766 701766 Neale, Thomas, of Est Halton, yeoman, weaver 0
4366998 2153251 2153251 defendant Baroughe John yeoman or laborer 701766 701766 Baroughe, John, of Est Halton, yeoman or laborer 1
4407759 2167159 2167159 defendant Skupholme Anthony gent 701766 701766 Skupholme, Anthony, of East Halton, gent 0
4480835 2194675 2194675 plaintiff Layceby Simon de   701766 701766 Layceby, Simon de, of East Halton 0
4489369 2197394 2197394 defendant Henryson William   701766 701766 Henryson, William, of East Halton 0
4489371 2197395 2197395 defendant Henryson William   701766 701766 Henryson, William, of East Halton 0
4645706 2244809 2244809 defendant Tolle John   701766 701766 Tolle, John, of East Halton 9
5007029 2358953 2358953 defendant Tomson Richard husbandman 701766 701766 Tomson, Richard, of East Halton, 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);