names

39 rows where place_id = 614807

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3705637 1928044 1928044 defendant Fulke Edmund husbandman 614807 614807 Fulke, Edmund, of Skottowe, husbandman 2
3737299 1937901 1937901 defendant Fulke Edmund husbandman 614807 614807 Fulke, Edmund, of Skottowe, husbandman 4
3750309 1942013 1942013 plaintiff Lely Edward (legal representative) 614807 614807 Lely, Edward, of Skottowe, executors of 0
3750311 1942013 1942013 plaintiff Lely Thomas   614807 614807 Lely, Thomas, of Skottowe 2
3761421 1945585 1945585 defendant Fulke Edmund tailor 614807 614807 Fulke, Edmund, of Skottowe, tailor 2
3797451 1957090 1957090 defendant Gunne or Ginne or Gumme Robert   614807 614807 Gunne or Ginne or Gumme, Robert, of Skottowe, worsted weaver 0
3823301 1965201 1965201 defendant Gunne Robert   614807 614807 Gunne, Robert, of Skottowe, worsted weaver 0
3839541 1970292 1970292 defendant Thorne Thomas, junior   614807 614807 Thorne, Thomas, junior, of Skottowe, worsted weaver 2
3894482 1988361 1988361 defendant Bekker John butcher 614807 614807 Bekker, John, of Skottowe, butcher 0
3895654 1988751 1988751 defendant Halle Henry   614807 614807 Halle, Henry, of Skottowe, worsted weaver 0
3895655 1988751 1988751 defendant Jeppys Thomas   614807 614807 Jeppys, Thomas, of Skottowe, worsted weaver 1
3954438 2008621 2008621 plaintiff Larke John husbandman 614807 614807 Larke, John, of Skottowe, husbandman 0
3954439 2008621 2008621 defendant Barker Thomas   614807 614807 Barker, Thomas, of Skottowe, worsted weaver 0
3954441 2008621 2008621 defendant Hyll John tailor 614807 614807 (Hyll, John, of Skottowe, tailor 2
3980267 2017709 2017709 plaintiff Pecke Walter   614807 614807 Pecke, Walter, of Skottowe 0
3980720 2017867 2017867 plaintiff Pollarde William husbandman 614807 614807 Pollarde, William, of Skottowe, husbandman 0
3980722 2017868 2017868 plaintiff Pollarde William husbandman 614807 614807 Pollarde, William, of Skottowe, husbandman 0
3983842 2018991 2018991 defendant Stubberd William husbandman 614807 614807 Stubberd, William, of Skottowe, husbandman 4
3985283 2019495 2019495 defendant Stubberd William husbandman 614807 614807 Stubberd, William, of Skottowe, husbandman 1
3999971 2024755 2024755 defendant Stanley John gent 614807 614807 Stanley, John, of Skottowe, gent 0
4009075 2028012 2028012 defendant Edriche John yeoman 614807 614807 Edriche, John, of Skottowe, yeoman 0
4009076 2028012 2028012 defendant Edriche William yeoman 614807 614807 Edriche, William, of Skottowe, yeoman 1
4033901 2036776 2036776 defendant Mowrton Edmund   614807 614807 Mowrton, Edmund, of Skottowe, worsted weaver 0
4145954 2076739 2076739 defendant Marham Robert husbandman 614807 614807 Marham, Robert, of Skottowe, husbandman 1
4166371 2083733 2083733 defendant Suffyld Edmund husbandman 614807 614807 Suffyld, Edmund, of Skottowe, husbandman 0
4172746 2085926 2085926 defendant Abbon Godfrey husbandman 614807 614807 Abbon, Godfrey, of Skottowe, husbandman 1
4200027 2095560 2095560 defendant Blacke Thomas husbandman 614807 614807 Blacke, Thomas, of Skottowe, husbandman 2
4209475 2098862 2098862 defendant Marham Robert husbandman 614807 614807 Marham, Robert, of Skottowe, husbandman 1
4226843 2104860 2104860 defendant Browne Richard gent 614807 614807 Browne, Richard, of Skottowe, gent 0
4251747 2113574 2113574 defendant Bettes Thomas cordwainer 614807 614807 Bettes, Thomas, of Skottowe, cordwainer 0
4283734 2124222 2124222 defendant Larke Robert   614807 614807 Larke, Robert, of Skottowe, worsted weaver 0
4312170 2134396 2134396 defendant Suffield Richard yeoman 614807 614807 Suffield, Richard, of Skottowe, yeoman 0
4329537 2140181 2140181 defendant Rante Mathew yeoman 614807 614807 Rante, Mathew, of Skottowe, yeoman 2
4338935 2143372 2143372 defendant Goodknopp Thomas   614807 614807 Goodknopp, Thomas, of Skottowe, worsted weaver 1
4346927 2146177 2146177 defendant Marrowe John   614807 614807 Marrowe, John, of Skottowe, worsted weaver 1
4394846 2162863 2162863 defendant Lysted William Weaver 614807 614807 Lysted, William, of Skottowe, Weaver 0
4394847 2162863 2162863 defendant Lynsted Nicholas weaver 614807 614807 Lynsted, Nicholas, of Skottowe, weaver 1
4407288 2166999 2166999 defendant Larke Robert   614807 614807 Larke, Robert, of Skottowe, worsted weaver 2
5565830 2524602 2524602 defendant Colyns Robert   614807 614807 Colyns, Robert, of Skottowe, worsted weaver 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);