names

51 rows where place_id = 594908

✎ 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
3618076 1873278 1873278 defendant Olyver Christopher husbandman 594908 594908 Olyver, Christopher, of Ovyngton, husbandman 0
3663695 1914581 1914581 plaintiff (not given) Robert rector of Plumbe 594908 594908 Plumbe, Robert, of Ovyngton, Rector of the church 0
3669119 1916277 1916277 plaintiff Base Brian   594908 594908 Base, Brian, of Ovyngton 0
3704142 1927590 1927590 defendant Plome Robert clerk 594908 594908 Plome, Robert, of Ovyngton, clerk 0
3732207 1936310 1936310 defendant Plume Robert clerk 594908 594908 Plume, Robert, of Ovyngton, clerk 0
3746548 1940833 1940833 defendant Plumbe Robert clerk 594908 594908 Plumbe, Robert, of Ovyngton, clerk 0
3749763 1941836 1941836 defendant Plumbe Robert clerk 594908 594908 Plumbe, Robert, of Ovyngton, clerk 0
3750017 1941922 1941922 defendant Plomme Robert chaplain 594908 594908 Plomme, Robert, of Ovyngton, chaplain 0
3762958 1946046 1946046 defendant Plumbe Robert clerk 594908 594908 Plumbe, Robert, of Ovyngton, clerk 2
3768702 1947858 1947858 defendant Forthe Robert husbandman 594908 594908 Forthe, Robert, of Ovyngton, husbandman 0
3771041 1948631 1948631 defendant Plumbe Robert clerk 594908 594908 Plumbe, Robert, of Ovyngton, clerk 1
3780672 1951684 1951684 defendant Wyghtman Robert   594908 594908 Wyghtman, Robert, of Ovyngton, parish clerk 0
3815119 1962648 1962648 defendant Plumbe Robert clerk 594908 594908 Plumbe, Robert, of Ovyngton, clerk 2
3817966 1963540 1963540 plaintiff Lovell Richard clerk 594908 594908 Lovell, Richard, of Ovyngton, clerk 0
3827716 1966534 1966534 defendant Wyghtman Robert, senior husbandman 594908 594908 Wyghtman, Robert, senior, of Ovyngton, husbandman 0
3827785 1966557 1966557 defendant Wightman Robert husbandman 594908 594908 Wightman, Robert, of Ovyngton, husbandman 0
3837691 1969700 1969700 defendant Wastell Thomas husbandman 594908 594908 Wastell, Thomas, of Ovyngton, husbandman 0
3848615 1973150 1973150 defendant Leyer John husbandman 594908 594908 Leyer, John, of Ovyngton, husbandman 1
3852639 1974432 1974432 plaintiff Robynson William   594908 594908 Robynson, William, of Ovyngton 0
3863889 1978096 1978096 defendant Leyer Thomas husbandman 594908 594908 Leyer, Thomas, of Ovyngton, husbandman 1
3887245 1986001 1986001 defendant Hungate John clerk 594908 594908 Hungate, John, of Ovyngton, clerk 0
3887248 1986002 1986002 defendant Hungate John clerk 594908 594908 Hungate, John, of Ovyngton, clerk 0
3896616 1989077 1989077 defendant Leyre Thomas yeoman 594908 594908 Leyre, Thomas, of Ovyngton, yeoman 0
3907953 1992950 1992950 defendant Isak John husbandman 594908 594908 Isak, John, of Ovyngton, husbandman 4
3907961 1992954 1992954 defendant Leyar John husbandman 594908 594908 Leyar, John, of Ovyngton, husbandman 0
3924748 1998594 1998594 defendant Leyre Thomas yeoman 594908 594908 Leyre, Thomas, of Ovyngton, yeoman 0
3976502 2016357 2016357 defendant More Thomas (legal representative) 594908 594908 More, Thomas, of Ovyngton, husbandman, executors of 2
3976503 2016357 2016357 defendant Whytman Richard husbandman 594908 594908 (Whytman, Richard, of Ovyngton, husbandman 3
3984131 2019089 2019089 defendant Robbynson Richard currier 594908 594908 Robbynson, Richard, of Ovyngton, currier 0
4561396 2219513 2219513 plaintiff Paule Richard   594908 594908 Paule, Richard, of Ovyngton 0
4561398 2219513 2219513 defendant Short Hugh   594908 594908 Short, Hugh, of Ovyngton 1
4606321 2233092 2233092 plaintiff Badecok John   594908 594908 Badecok, John, of Ovyngton 0
4606322 2233092 2233092 defendant Caldewell John   594908 594908 Caldewell, John, of Ovyngton 0
4691134 2262746 2262746 defendant Scras Richard yeoman 594908 594908 Scras, Richard, of Ovyngton, yeoman 2
5013292 2360723 2360723 defendant Fegon Adam chapman 594908 594908 Fegon, Adam, of Ovyngton, chapman 0
5026389 2364604 2364604 defendant Elyson William husbandman 594908 594908 Elyson, William, of Ovyngton, husbandman 10
5036022 2367391 2367391 defendant Woller Richard laborer 594908 594908 Woller, Richard, of Ovyngton, laborer 1
5082761 2381346 2381346 defendant Raynold John husbandman 594908 594908 Raynold, John, of Ovyngton, husbandman 4
5107757 2388700 2388700 defendant Reynold John husbandman 594908 594908 Reynold, John, of Ovyngton, husbandman 0
5155074 2402635 2402635 defendant Petyclerk Thomas clerk & parson 594908 594908 Petyclerk, Thomas, of Ovyngton, clerk & parson 3
5171859 2407484 2407484 defendant Petyclerk Thomas clerk & parson 594908 594908 Petyclerk, Thomas, of Ovyngton, clerk & parson 3
5207033 2417793 2417793 defendant Petyclerk Thomas clerk & parson 594908 594908 Petyclerk, Thomas, of Ovyngton, clerk & parson 3
5255032 2431690 2431690 defendant Hunt John yeoman 594908 594908 Hunt, John, of Ovyngton, yeoman 0
5286675 2441113 2441113 defendant Davy Alexander husbandman 594908 594908 Davy, Alexander, of Ovyngton, husbandman 1
5288489 2441649 2441649 defendant Davy Alexander husbandman 594908 594908 Davy, Alexander, of Ovyngton, husbandman 3
5350540 2460288 2460288 defendant Corbrygge Henry weaver 594908 594908 Corbrygge, Henry, of Ovyngton, weaver 2
5439592 2486779 2486779 defendant Lemman Thomas   594908 594908 Lemman, Thomas, of Ovyngton, pedlar 3
5495114 2503436 2503436 defendant Hethe John yeoman 594908 594908 (Hethe, John, of Ovyngton, Brodwater, yeoman 1
5506156 2506844 2506844 defendant Huet John yeoman 594908 594908 Huet, John, of Ovyngton, yeoman 1
5525059 2512427 2512427 defendant Ryse Thomas husbandman 594908 594908 Ryse, Thomas, of Ovyngton, husbandman 3
5526331 2512813 2512813 defendant Wyghtman William   594908 594908 Wyghtman, William, of Ovyngton, wheelwright 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);