names

34 rows where place_id = 628607

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3780840 1951744 1951744 plaintiff Grayn Robert clerk 628607 628607 Grayn, Robert, of Temple Brewer, clerk 0
3780841 1951744 1951744 plaintiff Babyngton John gent 628607 628607 Babyngton, John, of Temple Brewer, gent 1
3783322 1952534 1952534 defendant Temple Richard husbandman 628607 628607 Temple, Richard, of Temple, husbandman 0
3854724 1975126 1975126 defendant Garland John husbandman 628607 628607 Garland, John, of Temple, husbandman 0
3964829 2012308 2012308 defendant Combe John husbandman 628607 628607 Combe, John, of Temple, husbandman 0
3965575 2012572 2012572 defendant Sturterydge George husbandman 628607 628607 Sturterydge, George, of Temple, husbandman 2
4235973 2108155 2108155 defendant Parke Robert gent 628607 628607 (Parke, Robert, of Temple Bruer, gent 3
4244571 2111167 2111167 defendant Parke Robert gent 628607 628607 (Parke, Robert, of Temple Bruer, gent 2
4244575 2111168 2111168 defendant Parke Robert gent 628607 628607 (Parke, Robert, of Temple Bruer, gent 2
4286496 2125211 2125211 defendant Veren Thomas husbandman 628607 628607 Veren, Thomas, of Temple, husbandman 0
4288963 2126108 2126108 defendant Parke Robert gent 628607 628607 (Parke, Robert, of Temple Brewer, gent 1
4289178 2126184 2126184 defendant Cappe Elizabeth widow 628607 628607 Cappe, Elizabeth, of Temple Brewer, widow 1
4318288 2136504 2136504 defendant Parke Robert gent 628607 628607 Parke, Robert, of Temple Brewer, gent 0
4357655 2149910 2149910 defendant Whalley Thomas yeoman 628607 628607 Whalley, Thomas, of Temple, yeoman 1
4398538 2164091 2164091 defendant George William husbandman 628607 628607 George, William, of Temple, husbandman 0
4406808 2166843 2166843 defendant Hitchcocke Robert husbandman 628607 628607 Hitchcocke, Robert, of Temple, husbandman 2
4445636 2183591 2183591 defendant Thresshere William   628607 628607 Thresshere, William, of Temple 0
4534926 2211203 2211203 plaintiff Wryght William chaplain 628607 628607 Wryght, William, of Temple Brewer, chaplain 1
4549469 2215780 2215780 defendant Blantop Ralph   628607 628607 Blantop, Ralph, of Temple 3
4549470 2215780 2215780 defendant Smythislond William   628607 628607 Smythislond, William, of Temple 4
4549471 2215780 2215780 defendant Hervy Roger   628607 628607 Hervy, Roger, of Temple 5
4569027 2221900 2221900 plaintiff Warner Richard   628607 628607 Warner, Richard, of Temple 0
4627413 2239509 2239509 defendant Blake William   628607 628607 Blake, William, of Temple 8
4627414 2239509 2239509 defendant Barbour John   628607 628607 Barbour, John, of Temple 9
4627415 2239509 2239509 defendant Welles John   628607 628607 together with Welles, John, of Temple 10
4813164 2300233 2300233 defendant Seleby William husbandman 628607 628607 Seleby, William, of Temple, husbandman 1
4840257 2308500 2308500 defendant Cloude Robert yeoman 628607 628607 Cloude, Robert, of Temple, yeoman 0
4905553 2328335 2328335 defendant Cotes John clerk 628607 628607 Cotes, John, of Temple Breuer, clerk 0
4908088 2329089 2329089 defendant Sybeley Richard tinner 628607 628607 Sybeley, Richard, of Temple, tinner 2
4908094 2329090 2329090 defendant Sybeley Richard tinner 628607 628607 Sybeley, Richard, of Temple, tinner 2
4973054 2348874 2348874 defendant Meryfeld William   628607 628607 Meryfeld, William, of Temple, franklin 0
5219044 2421299 2421299 defendant Meryfeld William gent 628607 628607 Meryfeld, William, of Temple, gent 1
5235223 2425880 2425880 defendant Cloude Nicholas husbandman 628607 628607 Cloude, Nicholas, of Temple, husbandman 0
5289562 2441948 2441948 defendant Smyth John yeoman 628607 628607 Smyth, John, of Temple, 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);