names

33 rows where place_id = 590278

✎ 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
3600462 1867791 1867791 defendant Holdernes John fuller 590278 590278 Holdernes, John, of Wysbyche, fuller 0
3649438 1910215 1910215 defendant Smyth Margaret innholder 590278 590278 Smyth, Margaret, of Wysbyche, innholder 0
3649441 1910216 1910216 defendant Smyth Nicholas (legal representative) 590278 590278 Smyth, Nicholas, of Wysbyche, innholder, executor of 0
3649444 1910217 1910217 defendant Smyth Nicholas (legal representative) 590278 590278 Smyth, Nicholas, of Wysbyche, innholder, executor of 0
3691354 1923456 1923456 defendant Octarby George   590278 590278 Octarby, George, of Wysbyche 1
3709743 1929360 1929360 defendant Sele Robert tailor 590278 590278 Sele, Robert, of Wysbyche, tailor 1
3709744 1929360 1929360 defendant Trewe Thomas husbandman 590278 590278 Trewe, Thomas, of Wysbyche, husbandman 2
3709745 1929360 1929360 defendant Wright William laborer 590278 590278 Wright, William, of Wysbyche, laborer 3
3717920 1931906 1931906 defendant Tythe alias Wythe Thomas (legal representative) 590278 590278 Tythe alias Wythe, Thomas, of Wysbyche, gent, executor of 0
3743882 1939971 1939971 plaintiff Wythe Thomas (legal representative) 590278 590278 Wythe, Thomas, of Wysbyche, gent, executor of 0
3864852 1978445 1978445 defendant Odam William butcher 590278 590278 Odam, William, of Wysbyche, butcher 0
3873844 1981471 1981471 plaintiff Clerve Thomas draper 590278 590278 Clerve, Thomas, of Wysbyche, draper 0
3908438 1993117 1993117 defendant Clark Richard yeoman 590278 590278 Clark, Richard, of Wysbyche, yeoman 0
3920061 1997046 1997046 defendant Johnson Henry yeoman 590278 590278 Johnson, Henry, of Wysbyche, yeoman 1
3921021 1997378 1997378 defendant Sadleyr William husbandman 590278 590278 Sadleyr, William, of Wysbyche, husbandman 0
3958171 2009929 2009929 defendant Hawkyns John gent 590278 590278 (Hawkyns, John, of Wysbyche, gent 1
3972204 2014837 2014837 defendant Wesenham Edmund   590278 590278 Wesenham, Edmund, of Wysbyche, oatmeal maker 4
3972205 2014837 2014837 defendant Blossom John   590278 590278 Blossom, John, of Wysbyche 5
3995499 2023137 2023137 plaintiff Coxson William mercer 590278 590278 Coxson, William, of Wysbyche, mercer 0
4006327 2027042 2027042 plaintiff Dodson Edward yeoman 590278 590278 Dodson, Edward, of Wysbyche, yeoman 1
4021312 2032348 2032348 defendant Shrede Robert husbandman 590278 590278 Shrede, Robert, of Wysbyche, husbandman 0
4083241 2054296 2054296 defendant Leveredge Robert tailor 590278 590278 Leveredge, Robert, of Wysbyche, tailor 0
4096576 2059103 2059103 defendant Thetforde John glover 590278 590278 Thetforde, John, of Wysbyche, glover 2
4169878 2084961 2084961 defendant Fosse Simon yeoman 590278 590278 Fosse, Simon, of Wysbyche, yeoman 1
4240895 2109941 2109941 defendant Saylbancke James   590278 590278 Saylbancke, James, of Wysbyche, "oyler" 1
4382703 2158921 2158921 defendant Ladd John   590278 590278 Ladd, John, of Wysbyche yeoman 1
5205597 2417381 2417381 defendant Clement Andrew tanner 590278 590278 Clement, Andrew, of Wysbyche, tanner 6
5373982 2467460 2467460 defendant Fyssher John   590278 590278 Fyssher, John, of Wysbyche, 1
5438873 2486548 2486548 defendant Drake John yeoman 590278 590278 Drake, John, of Wysbyche, yeoman 1
5438879 2486550 2486550 defendant Drake John yeoman 590278 590278 Drake, John, of Wysbyche, yeoman 1
5565324 2524446 2524446 defendant Bukworth Thomas yeoman 590278 590278 Bukworth, Thomas, of Wysbyche, yeoman 3
5578045 2528202 2528202 plaintiff Wythe Thomas   590278 590278 Wythe, Thomas, of Wysbyche 0
5596774 2533910 2533910 defendant Orell Elizabeth widow 590278 590278 Orell, Elizabeth, of Wysbyche, widow 1

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);