names

40 rows where place_id = 590668

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601942 1868263 1868263 defendant Hungyr John clerk 590668 590668 Hungyr, John, of Pyrleston, clerk 0
3607074 1869877 1869877 defendant Wryghte Robert yeoman 590668 590668 Wryghte, Robert, of Pyrleston, yeoman 2
3658074 1912780 1912780 defendant Heron William husbandman 590668 590668 Heron, William, of Pyrleston, husbandman 1
3658077 1912780 1912780 defendant Balson John clerk 590668 590668 Balson, John, of Pyrleston, clerk 4
3658630 1912954 1912954 defendant Feltwell Robert husbandman 590668 590668 Feltwell, Robert, of Pyrleston, husbandman 0
3658631 1912954 1912954 defendant Heron William husbandman 590668 590668 Heron, William, of Pyrleston, husbandman 1
3658632 1912954 1912954 defendant Feltwell John husbandman 590668 590668 Feltwell, John, of Pyrleston, husbandman 2
3658633 1912954 1912954 defendant Feltwell John, junior husbandman 590668 590668 Feltwell, John, junior, of Pyrleston, husbandman 3
3705162 1927903 1927903 defendant Aldam Richard husbandman 590668 590668 Aldam, Richard, of Pyrleston, husbandman 0
3705163 1927903 1927903 defendant Feltwell Robert pewterer 590668 590668 Feltwell, Robert, of Pyrleston, pewterer 1
3757318 1944268 1944268 defendant Fesaunte William husbandman 590668 590668 Fesaunte, William, of Pyrleston, husbandman 0
3761491 1945605 1945605 defendant Ingham John husbandman 590668 590668 Ingham, John, of Pyrleston, husbandman 0
3780259 1951555 1951555 defendant Ingham John laborer 590668 590668 Ingham, John, of Pyrleston, laborer 1
3788112 1954075 1954075 defendant Ingham John laborer 590668 590668 Ingham, John, of Pyrleston, laborer 0
3789298 1954472 1954472 defendant Feltwell John pewterer 590668 590668 Feltwell, John, of Pyrleston, pewterer 0
3801605 1958401 1958401 defendant Feltwell John pewterer 590668 590668 Feltwell, John, of Pyrleston, pewterer 0
3804254 1959263 1959263 defendant Ingham John laborer 590668 590668 Ingham, John, of Pyrleston, laborer 0
3814873 1962568 1962568 defendant Fylby Nicholas   590668 590668 Fylby, Nicholas, of Pyrleston, wheel wright 2
3836982 1969476 1969476 defendant Weere Nicholas husbandman 590668 590668 Weere, Nicholas, of Pyrleston, husbandman 0
3859261 1976590 1976590 defendant Fytte Joan widow 590668 590668 Fytte, Joan, of Pyrleston, widow 3
3933505 2001491 2001491 defendant Quyntey Walter husbandman 590668 590668 Quyntey, Walter, of Pyrleston, husbandman 0
3933509 2001492 2001492 defendant Quynteyne Walter husbandman 590668 590668 Quynteyne, Walter, of Pyrleston, husbandman 0
5021424 2363173 2363173 defendant Rose Nicholas butcher 590668 590668 Rose, Nicholas, of Pyrleston, butcher 1
5021425 2363173 2363173 defendant Rose Robert butcher 590668 590668 Rose, Robert, of Pyrleston, butcher 2
5133165 2396178 2396178 defendant Thursto- Robert husbandman 590668 590668 Thursto-, Robert, of Pyrleston, husbandman 2
5351491 2460562 2460562 defendant Thurston Robert yeoman 590668 590668 Thurston, Robert, of Pyrleston, yeoman 0
5351492 2460562 2460562 defendant Sexteyn John pewterer 590668 590668 Sexteyn, John, of Pyrleston, pewterer 1
5351493 2460562 2460562 defendant Smyth alias Bailly Thomas pewterer 590668 590668 Smyth alias Bailly, Thomas, of Pyrleston, pewterer 2
5462240 2493608 2493608 defendant Clyfton Richard husbandman 590668 590668 Clyfton, Richard, of Pyrleston, husbandman 3
5534114 2515208 2515208 plaintiff Aldeham Thomas (legal representative) 590668 590668 Aldeham, Thomas, of Pyrleston, yeoman, executors of 0
5534118 2515209 2515209 plaintiff Aldeham Thomas (legal representative) 590668 590668 Aldeham, Thomas, of Pyrleston, yeoman, executors of 0
5534123 2515210 2515210 plaintiff Aldeham Thomas (legal representative) 590668 590668 Aldeham, Thomas, of Pyrleston, yeoman, executors of 0
5534130 2515212 2515212 plaintiff Aldham Thomas (legal representative) 590668 590668 Aldham, Thomas, of Pyrleston, executors of 0
5534139 2515213 2515213 plaintiff Aldham Thomas (legal representative) 590668 590668 Aldham, Thomas, of Pyrleston, executors of 0
5534144 2515214 2515214 plaintiff Aldham Thomas (legal representative) 590668 590668 Aldham, Thomas, of Pyrleston, executors of 0
5544881 2518505 2518505 defendant Feltwell Robert husbandman 590668 590668 Feltwell, Robert, of Pyrleston, husbandman 0
5550652 2520215 2520215 defendant Smyth Thomas brasier 590668 590668 Smyth, Thomas, of Pyrleston, brasier 0
5553731 2521126 2521126 defendant Beston William husbandman 590668 590668 Beston, William, of Pyrleston, husbandman 1
5572814 2526598 2526598 defendant Heron William yeoman 590668 590668 Heron, William, of Pyrleston, yeoman 1
5593500 2532953 2532953 plaintiff Aldham Thomas (legal representative) 590668 590668 Aldham, Thomas, of Pyrleston, executors of 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);