names

34 rows where place_id = 597646

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3629301 1904024 1904024 defendant Hewet John clothman 597646 597646 Hewet, John, of Stoke Naylond, Suff, clothman 0
3800616 1958103 1958103 defendant Oxley William sawyer 597646 597646 Oxley, William, of Stoke Naylond, Suff, sawyer 1
3813769 1962219 1962219 defendant Lucly Stephen mercer 597646 597646 Lucly, Stephen, of Stoke Naylond, Suff, mercer 0
3837914 1969771 1969771 defendant Frethe Rose widow 597646 597646 Frethe, Rose, of Stoke Naylond, Suff, widow 4
3837920 1969772 1969772 defendant Frethe Rose widow 597646 597646 Frethe, Rose, of Stoke Naylond, Suff, widow 4
3886140 1985616 1985616 defendant Abbys James clothier 597646 597646 Abbys, James, of Stoke Naylond, Suff, clothier 0
3891478 1987416 1987416 defendant Brande Richard yeoman 597646 597646 Brande, Richard, of Stoke Naylond, Suff, yeoman 1
3919703 1996927 1996927 defendant Abbes James, junior clothman 597646 597646 Abbes, James, junior, of Stoke Naylond, Suff, clothman 0
3919718 1996933 1996933 defendant Abbes James, junior clothman 597646 597646 Abbes, James, junior, of Stoke Naylond, Suff, clothman 0
3942737 2004574 2004574 defendant Spyre Lancelotte clothier 597646 597646 Spyre, Lancelotte, of Stoke Naylond, Suff, clothier 0
3978124 2016926 2016926 defendant Spere Lancelot clothier 597646 597646 Spere, Lancelot, of Stoke Naylond, Suff, clothier 1
4179897 2088446 2088446 defendant Mawle John esq 597646 597646 Mawle, John, of Stoke Naylond, Suff, gent, servant to Henry Seckforde, esq 0
4239215 2109341 2109341 defendant Baker Lancelot clothier 597646 597646 Baker, Lancelot, of Stoke Naylond, Suff, clothier 0
4249806 2112918 2112918 defendant Cryssall Thomas clothier 597646 597646 Cryssall, Thomas, of Stoke Naylond, Suff, clothier 0
4261369 2116768 2116768 defendant Baker Lancelot clothier 597646 597646 Baker, Lancelot, of Stoke Naylond, Suff, clothier 0
4268047 2118931 2118931 defendant Baker Lancelot clothier 597646 597646 Baker, Lancelot, of Stoke Naylond, Suff, clothier 0
4268052 2118932 2118932 defendant Baker Lancelot clothier 597646 597646 Baker, Lancelot, of Stoke Naylond, Suff, clothier 0
4274904 2121173 2121173 defendant Ware Anthony yeoman 597646 597646 Ware, Anthony, of Stoke Naylond, Suff, yeoman 0
4275283 2121290 2121290 defendant Abbes Elizabeth widow 597646 597646 Abbes, Elizabeth, of Stoke Naylond, Suff, widow 1
4689082 2262146 2262146 defendant Fen John dyer 597646 597646 Fen, John, of Stoke Naylond, Suff, dyer 0
5239434 2427115 2427115 defendant Boltewode William dyer 597646 597646 Boltewode, William, of Stoke Naylond, Suff, dyer 0
5271971 2436886 2436886 defendant Boltewode William dyer 597646 597646 Boltewode, William, of Stoke Naylond, Suff, dyer 0
5316579 2450044 2450044 defendant Mannok Robert husbandman 597646 597646 Mannok, Robert, of Stoke Naylond, Suff, husbandman 1
5382680 2470107 2470107 defendant Terry Robert tailor 597646 597646 Terry, Robert, of Stoke Naylond, Suff, tailor 0
5395958 2473929 2473929 defendant Mannok Robert husbandman 597646 597646 Mannok, Robert, of Stoke Naylond, Suff, husbandman 0
5400671 2475253 2475253 defendant Boltwaode William dyer 597646 597646 Boltwaode, William, of Stoke Naylond, Suff, dyer 0
5409207 2477720 2477720 defendant Mannok Robert husbandman 597646 597646 Mannok, Robert, of Stoke Naylond, Suff, husbandman 0
5413677 2479013 2479013 defendant Boltwode William dyer 597646 597646 Boltwode, William, of Stoke Naylond, Suff, dyer 0
5446766 2488931 2488931 plaintiff Hamond Joan widow 597646 597646 Hamond, Joan, of Stoke Naylond, Suff, widow 0
5459343 2492705 2492705 plaintiff Hamund Joan widow 597646 597646 Hamund, Joan, of Stoke Naylond, Suff, widow 0
5522848 2511974 2511974 defendant Danyell William fuller 597646 597646 Danyell, William, of Stoke Naylond, Suff, fuller 2
5522852 2511975 2511975 defendant Danyell William fuller or dyer 597646 597646 Danyell, William, of Stoke Naylond, Suff, fuller or dyer 2
5543285 2518017 2518017 defendant Hewet John clothmaker 597646 597646 Hewet, John, of Stoke Naylond, Suff, clothmaker 0
5564115 2524121 2524121 defendant Spyrlyng John husbandman 597646 597646 Spyrlyng, John, of Stoke Naylond, Suff, husbandman 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);