names

42 rows where place_id = 624187

✎ 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
3756608 1944049 1944049 defendant Kynge Richard husbandman 624187 624187 Kynge, Richard, of Meryden, husbandman 0
3756609 1944049 1944049 defendant Kyng Adam husbandman 624187 624187 Kyng, Adam, of Meryden, husbandman 1
3792563 1955532 1955532 plaintiff Barlowe Thomas   624187 624187 Barlowe, Thomas, of Meryden 0
3867982 1979526 1979526 plaintiff Grey Thomas gent 624187 624187 (Grey, Thomas, of Meryden, gent 1
3867984 1979526 1979526 defendant Corbett John (legal representative) 624187 624187 Corbett, John, of Meryden, executors of 0
3872856 1981136 1981136 defendant Walker Richard husbandman 624187 624187 Walker, Richard, of Meryden, husbandman 0
3872858 1981137 1981137 defendant Walkar Richard husbandman 624187 624187 Walkar, Richard, of Meryden, husbandman 0
3908148 1993023 1993023 defendant Crowe Robert yeoman 624187 624187 Crowe, Robert, of Meryden, yeoman 0
3908149 1993023 1993023 defendant Crowe William innholder 624187 624187 Crowe, William, of Meryden, innholder 1
3908150 1993023 1993023 defendant Grey Thomas gent 624187 624187 Grey, Thomas, of Meryden, gent 2
3908151 1993023 1993023 defendant Howe Richard gent 624187 624187 Howe, Richard, of Meryden, gent 3
3911049 1994023 1994023 defendant Tyller William husbandman 624187 624187 Tyller, William, of Meryden, husbandman 0
3945728 2005581 2005581 defendant Crowe John husbandman 624187 624187 Crowe, John, of Meryden, husbandman 0
3945729 2005581 2005581 defendant Bennet Nicholas husbandman 624187 624187 Bennet, Nicholas, of Meryden, husbandman 1
3945730 2005581 2005581 defendant Barnet Thomas laborer 624187 624187 Barnet, Thomas, of Meryden, laborer 2
3945731 2005581 2005581 defendant Quyons Nicholas husbandman 624187 624187 Quyons, Nicholas, of Meryden, husbandman 3
4034800 2037125 2037125 defendant Peate Francis husbandman 624187 624187 Peate, Francis, of Meryden, husbandman 3
4034802 2037125 2037125 defendant Heynes John husbandman 624187 624187 Heynes, John, of Meryden, husbandman 5
4058609 2045470 2045470 defendant Peate Francis husbandman 624187 624187 Peate, Francis, of Meryden, husbandman 3
4101743 2060933 2060933 defendant Crowe Mark yeoman or innholder 624187 624187 Crowe, Mark, of Meryden, yeoman or innholder 0
4144221 2076138 2076138 defendant Wedgwoode John yeoman 624187 624187 Wedgwoode, John, of Meryden, yeoman 0
4148632 2077646 2077646 defendant Peate Francis yeoman 624187 624187 Peate, Francis, of Meryden, yeoman 2
4160434 2081726 2081726 defendant Peate Francis husbandman 624187 624187 Peate, Francis, of Meryden, husbandman 2
4196816 2094434 2094434 defendant Peate Francis yeoman 624187 624187 Peate, Francis, of Meryden, yeoman 0
4312324 2134446 2134446 defendant Colbox William yeoman 624187 624187 Colbox, William, of Meryden, yeoman 0
4607496 2233456 2233456 defendant Walsheman John   624187 624187 Walsheman, John, of Meryden, pole maker 0
4813333 2300285 2300285 defendant Aynes Joan widow 624187 624187 Aynes, Joan, of Meryden, widow 1
4851823 2312007 2312007 defendant Dene William   624187 624187 Dene, William, of Meryden, arrow maker 0
4945078 2340445 2340445 defendant Broune Thomas butcher 624187 624187 Broune, Thomas, of Meryden, butcher 0
4946283 2340824 2340824 defendant Smyth Robert smith 624187 624187 Smyth, Robert, of Meryden, smith 0
4963202 2345900 2345900 defendant Smyth Robert smith 624187 624187 Smyth, Robert, of Meryden, smith 3
5004484 2358210 2358210 defendant Broun Thomas butcher 624187 624187 Broun, Thomas, of Meryden, butcher 0
5041994 2369209 2369209 defendant Botiler John gent 624187 624187 Botiler, John, of Meryden, gent 0
5042969 2369513 2369513 defendant Botiller John gent 624187 624187 Botiller, John, of Meryden, gent 0
5064047 2375781 2375781 defendant Boteler John gent 624187 624187 Boteler, John, of Meryden, gent 0
5112817 2390143 2390143 defendant Marten John husbandman 624187 624187 Marten, John, of Meryden, husbandman 0
5487003 2501008 2501008 defendant Draper John yeoman 624187 624187 Draper, John, of Meryden, yeoman 0
5494296 2503198 2503198 defendant Welles Thomas laborer 624187 624187 Welles, Thomas, of Meryden, laborer 0
5494297 2503198 2503198 defendant Osbon Nicholas laborer 624187 624187 Osbon, Nicholas, of Meryden, laborer 1
5494298 2503198 2503198 defendant Swanne Richard tailor 624187 624187 Swanne, Richard, of Meryden, tailor 2
5502211 2505617 2505617 defendant Wodeshawe Richard yeoman 624187 624187 Wodeshawe, Richard, of Meryden, yeoman 0
5518769 2510705 2510705 defendant Wellys Thomas yeoman 624187 624187 Wellys, Thomas, of Meryden, yeoman 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);