names

46 rows where place_id = 608213

✎ 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
3672665 1917453 1917453 defendant Barker Thomas husbandman 608213 608213 Barker, Thomas, of Fenyngham, husbandman 1
3723932 1933764 1933764 defendant Mannyng John husbandman 608213 608213 Mannyng, John, of Fenyngham, husbandman 3
3749052 1941635 1941635 defendant Munnyng Nicholas smith 608213 608213 Munnyng, Nicholas, of Fenyngham, smith 0
3749231 1941686 1941686 defendant Clarke John husbandman 608213 608213 Clarke, John, of Fenyngham, husbandman 0
3749232 1941686 1941686 defendant Golde John laborer 608213 608213 Golde, John, of Fenyngham, laborer 1
3788769 1954293 1954293 defendant Munnyng Nicholas smith 608213 608213 Munnyng, Nicholas, of Fenyngham, smith 1
3795188 1956361 1956361 defendant Symond John husbandman 608213 608213 Symond, John, of Fenyngham, husbandman 4
3820467 1964286 1964286 defendant Huberd Robert, senior husbandman 608213 608213 Huberd, Robert, senior, of Fenyngham, husbandman 0
3820468 1964286 1964286 defendant Huberd Robert, junior husbandman 608213 608213 Huberd, Robert, junior, of Fenyngham, husbandman 1
3820469 1964286 1964286 defendant Hubberd John laborer 608213 608213 Hubberd, John, of Fenyngham, laborer 2
3820470 1964286 1964286 defendant Stonard Geoffrey laborer 608213 608213 Stonard, Geoffrey, of Fenyngham, laborer 3
3820472 1964287 1964287 defendant Hobert Robert yeoman 608213 608213 Hobert, Robert, of Fenyngham, yeoman 0
3904549 1991770 1991770 defendant Clerke Robert husbandman 608213 608213 Clerke, Robert, of Fenyngham, husbandman 0
3920823 1997310 1997310 defendant Robynson John yeoman 608213 608213 Robynson, John, of Fenyngham, yeoman 0
3956608 2009375 2009375 defendant Garland William husbandman 608213 608213 Garland, William, of Fenyngham, husbandman 1
3978276 2016983 2016983 defendant Garlonde William   608213 608213 Garlonde, William, of Fenyngham, husbandman, administrators of 0
4134411 2072636 2072636 defendant Ellys John tailor 608213 608213 Ellys, John, of Fenyngham, tailor 3
4482299 2195167 2195167 defendant Kyng Richard   608213 608213 Kyng, Richard, of Fenyngham 0
4515103 2205136 2205136 defendant Childerhous Walter   608213 608213 Childerhous, Walter, of Fenyngham 0
4822082 2302982 2302982 defendant Wrastkyngworth John clerk 608213 608213 Wrastkyngworth, John, of Fenyngham, clerk 0
4827195 2304553 2304553 defendant Seriaunt John   608213 608213 Seriaunt, John, of Fenyngham, parson 0
4832945 2306324 2306324 defendant Iryon William butcher 608213 608213 Iryon, William, of Fenyngham, butcher 0
4886579 2322667 2322667 defendant Hoberd Robert husbandman 608213 608213 Hoberd, Robert, of Fenyngham, husbandman 0
4886580 2322667 2322667 defendant Lukyn Robert laborer 608213 608213 Lukyn, Robert, of Fenyngham, laborer 1
4886581 2322667 2322667 defendant Hervy John husbandman 608213 608213 Hervy, John, of Fenyngham, husbandman 2
4893693 2324723 2324723 defendant Pope William chaplain 608213 608213 Pope, William, of Fenyngham, chaplain 2
4911709 2330163 2330163 defendant Bowe John   608213 608213 Bowe, John, of Fenyngham, parson 2
4927939 2335171 2335171 defendant Hoberd Robert husbandman 608213 608213 Hoberd, Robert, of Fenyngham, husbandman 0
4927941 2335171 2335171 defendant Hervy John husbandman 608213 608213 Hervy, John, of Fenyngham, husbandman 2
4927942 2335171 2335171 defendant Poykyn John skinner 608213 608213 Poykyn, John, of Fenyngham, skinner 3
4927943 2335171 2335171 defendant Boteler John   608213 608213 Boteler, John, of Fenyngham, parson 4
4940130 2338942 2338942 defendant Maundevyle Roger husbandman 608213 608213 Maundevyle, Roger, of Fenyngham, husbandman 1
5031743 2366156 2366156 defendant Baxstere Thomas husbandman 608213 608213 Baxstere, Thomas, of Fenyngham, husbandman 2
5049183 2371390 2371390 defendant Yunge Philip brewer 608213 608213 Yunge, Philip, of Fenyngham, brewer 3
5091246 2383840 2383840 defendant Yonge Roger butcher 608213 608213 Yonge, Roger, of Fenyngham, butcher 1
5135201 2396793 2396793 defendant Yonge John laborer 608213 608213 Yonge, John, of Fenyngham, laborer 1
5155299 2402700 2402700 defendant Yonge Philip laborer 608213 608213 Yonge, Philip, of Fenyngham, laborer 1
5171989 2407522 2407522 defendant Yonge Philip laborer 608213 608213 Yonge, Philip, of Fenyngham, laborer 1
5303291 2445981 2445981 defendant Dryver John butcher 608213 608213 Dryver, John, of Fenyngham, butcher 2
5321842 2451604 2451604 defendant Baker Robert carpenter 608213 608213 Baker, Robert, of Fenyngham, carpenter 3
5502441 2505682 2505682 defendant Ilyon John   608213 608213 Ilyon, John, of Fenyngham, administrators of 0
5502442 2505682 2505682 defendant Gogh John yeoman 608213 608213 (Gogh, John, of Fenyngham, yeoman 1
5552174 2520679 2520679 defendant Pulham John husbandman 608213 608213 Pulham, John, of Fenyngham, husbandman 0
5593019 2532806 2532806 defendant Clerk John husbandman 608213 608213 Clerk, John, of Fenyngham, husbandman 1
5594211 2533167 2533167 plaintiff Barker Thomas clerk 608213 608213 Barker, Thomas, of Fenyngham, clerk 0
5594212 2533167 2533167 defendant Clerke John husbandman 608213 608213 Clerke, John, of Fenyngham, 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);