names

63 rows where place_id = 599508

✎ 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
3637073 1906395 1906395 defendant Saule or Sanle John yeoman 599508 599508 Saule or Sanle, John, of Repynghale, yeoman 0
3779937 1951452 1951452 defendant Dykson Thomas clerk 599508 599508 Dykson, Thomas, of Repynghale, clerk 4
3779938 1951452 1951452 defendant Lyghton Robert clerk 599508 599508 Lyghton, Robert, of Repynghale, clerk 5
3779939 1951452 1951452 defendant Barwyke Thomas husbandman 599508 599508 Barwyke, Thomas, of Repynghale, husbandman 6
3796865 1956898 1956898 defendant Dykson Thomas clerk 599508 599508 Dykson, Thomas, of Repynghale, clerk 4
3796866 1956898 1956898 defendant Leighton Robert clerk 599508 599508 Leighton, Robert, of Repynghale, clerk 5
3796867 1956898 1956898 defendant Barwyk Thomas husbandman 599508 599508 Barwyk, Thomas, of Repynghale, husbandman 6
4414501 2169437 2169437 defendant Gauge John, junior   599508 599508 Gauge, John, junior, of Repynghale 0
4416886 2170152 2170152 plaintiff Thorp John de   599508 599508 Thorp, John de, of Repynghale 1
4419173 2170867 2170867 defendant Gore Nicholas   599508 599508 Gore, Nicholas, of Repynghale 0
4427614 2173473 2173473 defendant Gauge John, senior   599508 599508 Gauge, John, senior, of Repynghale 0
4428910 2173844 2173844 plaintiff Thorp John de   599508 599508 Thorp, John de, of Repynghale 0
4443704 2182999 2182999 defendant Loughton Thomas de   599508 599508 Loughton, Thomas de, of Repynghale 0
4445168 2183459 2183459 plaintiff Couper Alice   599508 599508 Couper, Alice, of Repynghale, formerly wife of John 0
4449472 2184783 2184783 plaintiff Goderith John   599508 599508 Goderith, John, of Repynghale, on his own account 0
4462819 2189069 2189069 plaintiff Thorp John de (legal representative) 599508 599508 Thorp, John de, of Repynghale, executors of 0
4462820 2189069 2189069 plaintiff Thorp John   599508 599508 (Thorp, John, of Repynghale, son of John 1
4513654 2204700 2204700 plaintiff Brun or Brim John   599508 599508 Brun or Brim, John, of Repynghale, parson of 2 parts of the church 0
4513656 2204701 2204701 plaintiff Brun John   599508 599508 Brun, John, of Repynghale, parson of 2 parts of the church 0
4577865 2224583 2224583 plaintiff Chapman John   599508 599508 Chapman, John, of Repynghale 0
4577867 2224584 2224584 plaintiff Chapman John   599508 599508 Chapman, John, of Repynghale, son of Thomas 0
4727038 2273720 2273720 defendant Drapour William husbandman 599508 599508 Drapour, William, of Repynghale, husbandman 2
4733564 2275674 2275674 defendant Rose John miller 599508 599508 Rose, John, of Repynghale, miller 0
4750703 2280692 2280692 defendant Draper William husbandman 599508 599508 Draper, William, of Repynghale, husbandman 3
4767481 2285808 2285808 defendant Draper William husbandman 599508 599508 Draper, William, of Repynghale, husbandman 2
4845536 2310115 2310115 defendant Draper William husbandman 599508 599508 Draper, William, of Repynghale, husbandman 2
4870457 2317731 2317731 defendant Spynk John yeoman 599508 599508 Spynk, John, of Repynghale, yeoman 1
4878134 2320113 2320113 defendant Andrewe John husbandman 599508 599508 Andrewe, John, of Repynghale, husbandman 0
4886113 2322515 2322515 defendant Damet John, junior laborer 599508 599508 Damet, John, junior, of Repynghale, laborer 0
4886177 2322537 2322537 defendant Damet John husbandman 599508 599508 Damet, John, of Repynghale, husbandman 0
4886178 2322537 2322537 defendant Damet Robert husbandman 599508 599508 Damet, Robert, of Repynghale, husbandman 1
4948515 2341514 2341514 defendant Garnon William   599508 599508 Garnon, William, of Repynghale, servant 0
4948517 2341515 2341515 defendant Hykson Thomas tailor 599508 599508 Hykson, Thomas, of Repynghale, tailor 0
4948518 2341515 2341515 defendant Steward Richard tailor 599508 599508 Steward, Richard, of Repynghale, tailor 1
4948520 2341516 2341516 defendant Bowet Nicholas   599508 599508 Bowet, Nicholas, of Repynghale, knight 0
4948521 2341516 2341516 defendant Faukoner William yeoman 599508 599508 Faukoner, William, of Repynghale, yeoman 1
4948522 2341516 2341516 defendant Frebowe John yeoman 599508 599508 Frebowe, John, of Repynghale, yeoman 2
4948523 2341516 2341516 defendant Baringer Richard yeoman 599508 599508 Baringer, Richard, of Repynghale, yeoman 3
4948524 2341516 2341516 defendant Assheley Richard   599508 599508 Assheley, Richard, of Repynghale, servant 4
4948525 2341516 2341516 defendant Randolf Robert   599508 599508 Randolf, Robert, of Repynghale, servant 5
4948526 2341516 2341516 defendant Hykson Thomas tailor 599508 599508 Hykson, Thomas, of Repynghale, tailor 6
4948527 2341516 2341516 defendant Robynson Robert clerk 599508 599508 Robynson, Robert, of Repynghale, clerk 7
4948530 2341517 2341517 defendant Bowet Nicholas   599508 599508 Bowet, Nicholas, of Repynghale, knight 0
4948534 2341518 2341518 defendant Hicson Thomas husbandman 599508 599508 Hicson, Thomas, of Repynghale, husbandman 1
5005084 2358387 2358387 defendant Claws Henry husbandman 599508 599508 Claws, Henry, of Repynghale, husbandman 0
5019915 2362704 2362704 defendant Ellys William husbandman 599508 599508 Ellys, William, of Repynghale, husbandman 0
5058415 2374065 2374065 defendant Bowes Nicholas   599508 599508 Bowes, Nicholas, of Repynghale, knight 0
5104109 2387625 2387625 defendant Bowet Nicholas   599508 599508 Bowet, Nicholas, of Repynghale, knight 0
5118057 2391711 2391711 defendant Bowet Nicholas   599508 599508 Bowet, Nicholas, of Repynghale, knight 0
5121400 2392691 2392691 defendant Bermyngham Richard yeoman 599508 599508 Bermyngham, Richard, of Repynghale, yeoman 0
5177759 2409199 2409199 defendant Bowet Nicholas   599508 599508 Bowet, Nicholas, of Repynghale, knight 0
5177761 2409199 2409199 defendant Bowet William esq 599508 599508 Bowet, William, of Repynghale, esq 2
5177764 2409199 2409199 defendant Barmyngham Richard yeoman 599508 599508 Barmyngham, Richard, of Repynghale, yeoman 5
5186400 2411778 2411778 defendant Bowet Nicholas   599508 599508 Bowet, Nicholas, of Repynghale, knight 0
5186402 2411778 2411778 defendant Bowet William esq 599508 599508 Bowet, William, of Repynghale, esq 2
5192938 2413660 2413660 defendant Bowet Nicholas   599508 599508 Bowet, Nicholas, of Repynghale, knight 0
5207234 2417855 2417855 defendant Dowthty William husbandman 599508 599508 Dowthty, William, of Repynghale, husbandman 0
5227660 2423712 2423712 defendant Repynghale Robert gent 599508 599508 Repynghale, Robert, of Repynghale, gent 0
5245967 2428981 2428981 defendant Loughton William husbandman 599508 599508 Loughton, William, of Repynghale, husbandman 1
5283935 2440331 2440331 defendant Bermyngham Richard yeoman 599508 599508 Bermyngham, Richard, of Repynghale, yeoman 5
5621935 2550771 2550771 plaintiff Thorp John de   599508 599508 Thorp, John de, of Repynghale 0
5621937 2550772 2550772 plaintiff Thorp John de   599508 599508 Thorp, John de, of Repynghale, on his own account 0
5633674 2554532 2554532 plaintiff Thorp Thomas   599508 599508 Thorp, Thomas, of Repynghale 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);