names

46 rows where place_id = 587322

✎ 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
3591068 1864836 1864836 defendant Playn William yeoman 587322 587322 Playn, William, of Pembrugge, yeoman 0
3640496 1907460 1907460 defendant Philippys John butcher 587322 587322 Philippys, John, of Pembrugge, butcher 1
3640855 1907584 1907584 defendant Trouper Richard husbandman 587322 587322 Trouper, Richard, of Pembrugge, husbandman 3
3640869 1907589 1907589 plaintiff Baker Thomas baker 587322 587322 Baker, Thomas, of Pembrugge, baker 0
3640870 1907589 1907589 defendant Hawkyns William gent 587322 587322 Hawkyns, William, of Pembrugge, gent 0
3640871 1907589 1907589 defendant Moseley John, senior yeoman 587322 587322 Moseley, John, senior, of Pembrugge, yeoman 1
3640872 1907589 1907589 defendant Barton Richard yeoman 587322 587322 Barton, Richard, of Pembrugge, yeoman 2
3657201 1912516 1912516 defendant Holle John husbandman 587322 587322 Holle, John, of Pembrugge, husbandman 0
3666751 1915547 1915547 defendant Philipis John yeoman 587322 587322 Philipis, John, of Pembrugge, yeoman 1
3669187 1916301 1916301 defendant Edwardys John husbandman 587322 587322 Edwardys, John, of Pembrugge, husbandman 0
3693298 1924116 1924116 defendant Oldaker William yeoman 587322 587322 Oldaker, William, of Pembrugge, yeoman 0
3695195 1924719 1924719 defendant Rodde John yeoman 587322 587322 Rodde, John, of Pembrugge, yeoman 2
3707425 1928615 1928615 defendant Hale Walter weaver 587322 587322 Hale, Walter, of Pembrugge, weaver 2
3724504 1933950 1933950 defendant Socur John miller 587322 587322 Socur, John, of Pembrugge, miller 0
3727786 1934959 1934959 defendant Wates John husbandman 587322 587322 Wates, John, of Pembrugge, husbandman 1
3740400 1938858 1938858 defendant Duppa Geoffrey dyer 587322 587322 Duppa, Geoffrey, of Pembrugge, dyer 1
3740952 1939031 1939031 defendant Hopwode Ralph gent 587322 587322 Hopwode, Ralph, of Pembrugge, gent 0
3740953 1939031 1939031 defendant Hopwode John gent 587322 587322 Hopwode, John, of Pembrugge, gent 1
3741914 1939336 1939336 defendant Lyde Hugh husbandman 587322 587322 Lyde, Hugh, of Pembrugge, husbandman 2
3741915 1939336 1939336 defendant Taylour William husbandman 587322 587322 Taylour, William, of Pembrugge, husbandman 3
3741916 1939336 1939336 defendant Rode Walter sherman 587322 587322 Rode, Walter, of Pembrugge, sherman 4
3758322 1944598 1944598 defendant Brace William yeoman 587322 587322 Brace, William, of Pembrugge, yeoman 0
3758323 1944598 1944598 defendant Hale Walter yeoman 587322 587322 Hale, Walter, of Pembrugge, yeoman 1
3860511 1977008 1977008 defendant Perryns Edward corveser 587322 587322 Perryns, Edward, of Pembrugge, corveser 3
3865397 1978640 1978640 defendant Vycaryse Roger yeoman 587322 587322 Vycaryse, Roger, of Pembrugge, yeoman 0
3896156 1988918 1988918 defendant Gylbert Walter chapman 587322 587322 Gylbert, Walter, of Pembrugge, chapman 2
4815755 2301029 2301029 defendant Goolde John shoemaker 587322 587322 Goolde, John, of Pembrugge, shoemaker 1
5067847 2376884 2376884 defendant Burgeys Richard, junior husbandman 587322 587322 Burgeys, Richard, junior, of Pembrugge, or of Herdewyke, husbandman 0
5067848 2376884 2376884 defendant Burgeys Richard, senior husbandman 587322 587322 Burgeys, Richard, senior, of Pembrugge, or of Herdewyke, husbandman 1
5067849 2376884 2376884 defendant Holowey John husbandman 587322 587322 Holowey, John, of Pembrugge, husbandman 2
5067850 2376884 2376884 defendant Boweker Thomas walker 587322 587322 Boweker, Thomas, of Pembrugge, walker 3
5067851 2376884 2376884 defendant Fylcoo John tailor 587322 587322 Fylcoo, John, of Pembrugge, tailor 4
5131064 2395572 2395572 defendant Parker John gent 587322 587322 Parker, John, of Pembrugge, gent 0
5132898 2396113 2396113 defendant Tannar John   587322 587322 Tannar, John, of Pembrugge 2
5146809 2400209 2400209 defendant Seculer Robert husbandman 587322 587322 Seculer, Robert, of Pembrugge, husbandman 2
5166768 2406006 2406006 defendant Seculer Robert husbandman 587322 587322 Seculer, Robert, of Pembrugge, husbandman 2
5169038 2406676 2406676 defendant Parker John gent 587322 587322 Parker, John, of Pembrugge, gent 0
5238505 2426852 2426852 defendant Brace William esq 587322 587322 Brace, William, of Pembrugge, esq 1
5305928 2446759 2446759 defendant Harryes John yeoman 587322 587322 Harryes, John, of Pembrugge, yeoman 0
5338966 2456758 2456758 defendant Tayllour John draper 587322 587322 Tayllour, John, of Pembrugge, draper 0
5563940 2524065 2524065 defendant Crofte Thomas butcher 587322 587322 Crofte, Thomas, of Pembrugge, butcher 1
5564396 2524203 2524203 defendant Berton Richard cordwainer 587322 587322 Berton, Richard, of Pembrugge, cordwainer 1
5576196 2527617 2527617 defendant Hoggys Thomas butcher 587322 587322 Hoggys, Thomas, of Pembrugge, butcher 0
5576199 2527617 2527617 defendant Hale Roland husbandman 587322 587322 Hale, Roland, of Pembrugge, husbandman 3
5594811 2533346 2533346 defendant Taylour Geoffrey cordwainer 587322 587322 Taylour, Geoffrey, of Pembrugge, cordwainer 3
5594812 2533346 2533346 defendant Corveser Griffith cordwainer 587322 587322 Corveser, Griffith, of Pembrugge, cordwainer 4

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