names

31 rows where place_id = 611830

✎ 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
3690268 1923117 1923117 defendant Ewyn William laborer 611830 611830 Ewyn, William, of Bylney, laborer 0
3755155 1943563 1943563 defendant Glover Richard husbandman 611830 611830 Glover, Richard, of Bylney, husbandman 0
3755156 1943563 1943563 defendant Caly Thomas husbandman 611830 611830 Caly, Thomas, of Bylney, husbandman 1
3786270 1953502 1953502 plaintiff Pern John yeoman 611830 611830 Pern, John, of Bylney, yeoman 0
3786272 1953503 1953503 plaintiff Pern John yeoman 611830 611830 Pern, John, of Bylney, yeoman 0
3845003 1971987 1971987 defendant Draper Thomas husbandman 611830 611830 Draper, Thomas, of Bylney, husbandman 0
3889551 1986737 1986737 defendant Draper Thomas yeoman 611830 611830 Draper, Thomas, of Bylney, yeoman 0
3910671 1993883 1993883 defendant Perne John yeoman 611830 611830 Perne, John, of Bylney, yeoman 0
3932918 2001298 2001298 defendant Barker John yeoman 611830 611830 Barker, John, of Bylney, yeoman 0
4073162 2050692 2050692 defendant Spylman Geoffrey husbandman 611830 611830 Spylman, Geoffrey, of Bylney, husbandman 0
4073163 2050692 2050692 defendant Skyppton William husbandman 611830 611830 Skyppton, William, of Bylney, husbandman 1
4073164 2050692 2050692 defendant Hall John husbandman 611830 611830 Hall, John, of Bylney, husbandman 2
4089064 2056383 2056383 defendant Beales William husbandman 611830 611830 Beales, William, of Bylney, husbandman 1
4125154 2069284 2069284 defendant Bateman Thomas husbandman 611830 611830 Bateman, Thomas, of Bylney, husbandman 0
4125155 2069284 2069284 defendant Hare Bartholomew husbandman 611830 611830 Hare, Bartholomew, of Bylney, husbandman 1
4148310 2077539 2077539 defendant Stonner Edmund husbandman 611830 611830 Stonner, Edmund, of Bylney, husbandman 2
4214448 2100561 2100561 defendant Roy or Roo William   611830 611830 Roy or Roo, William, of Bylney, linen weaver 2
4807761 2298616 2298616 defendant Coke John laborer 611830 611830 Coke, John, of Bylney, laborer 0
4807763 2298617 2298617 defendant Coke John laborer 611830 611830 Coke, John, of Bylney, laborer 0
5224241 2422762 2422762 plaintiff Pomfrey William   611830 611830 Pomfrey, William, of Bylney 0
5384769 2470725 2470725 defendant Trendyll Thomas husbandman 611830 611830 Trendyll, Thomas, of Bylney, husbandman 14
5396786 2474170 2474170 defendant Trendyll Thomas   611830 611830 Trendyll, Thomas, of Bylney 14
5410031 2477962 2477962 defendant Tryndyll Thomas husbandman 611830 611830 Tryndyll, Thomas, of Bylney, husbandman 14
5417307 2480095 2480095 defendant Brouster Thomas husbandman 611830 611830 Brouster, Thomas, of Bylney, husbandman 1
5419125 2480647 2480647 defendant Cook Thomas husbandman 611830 611830 Cook, Thomas, of Bylney, husbandman 2
5434553 2485276 2485276 defendant Brouster Thomas husbandman 611830 611830 Brouster, Thomas, of Bylney, husbandman 1
5437301 2486100 2486100 defendant Cook Thomas husbandman 611830 611830 Cook, Thomas, of Bylney, husbandman 2
5512480 2508764 2508764 defendant Barker alias Feltewell Robert barker 611830 611830 Barker alias Feltewell, Robert, of Bylney, barker 0
5568994 2525483 2525483 defendant Perne John yeoman 611830 611830 (Perne, John, of Bylney, yeoman 1
5569001 2525484 2525484 defendant Barker alias Feltwell Robert (legal representative) 611830 611830 Barker alias Feltwell, Robert, of Bylney, husbandman, executors of 0
5569002 2525484 2525484 defendant Perne John yeoman 611830 611830 (Perne, John, of Bylney, yeoman 1

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);