names

48 rows where place_id = 603876

✎ 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
3656061 1912149 1912149 defendant Clerk Richard husbandman 603876 603876 Clerk, Richard, of Helgay, husbandman 0
3703649 1927421 1927421 defendant Clerk Richard laborer 603876 603876 Clerk, Richard, of Helgay, laborer 3
3705155 1927901 1927901 defendant Gardener Richard husbandman 603876 603876 Gardener, Richard, of Helgay, husbandman 2
3838379 1969924 1969924 defendant Spycer John (legal representative) 603876 603876 Spycer, John, of Helgay, yeoman, executrix of 0
3838380 1969924 1969924 defendant Karre Marion widow 603876 603876 Karre, Marion, of Helgay, widow 1
3844564 1971840 1971840 defendant Tompson William husbandman 603876 603876 Tompson, William, of Helgay, husbandman 0
3844565 1971840 1971840 defendant Byrde William husbandman 603876 603876 Byrde, William, of Helgay, husbandman 1
3844566 1971840 1971840 defendant Abowth John husbandman 603876 603876 Abowth, John, of Helgay, husbandman 2
3844567 1971840 1971840 defendant Asshewell Richard husbandman 603876 603876 Asshewell, Richard, of Helgay, husbandman 3
3844568 1971840 1971840 defendant Gardyner alias Lytster Richard husbandman 603876 603876 Gardyner alias Lytster, Richard, of Helgay, husbandman 4
3844857 1971935 1971935 defendant Barnarde William laborer 603876 603876 Barnarde, William, of Helgay, laborer 0
3844858 1971935 1971935 defendant Byrde John husbandman 603876 603876 Byrde, John, of Helgay, husbandman 1
3844859 1971935 1971935 defendant None William husbandman 603876 603876 None, William, of Helgay, husbandman 2
3844860 1971935 1971935 defendant Heynon Thomas husbandman 603876 603876 Heynon, Thomas, of Helgay, husbandman 3
3846144 1972349 1972349 defendant Herwell Jasper husbandman 603876 603876 Herwell, Jasper, of Helgay, husbandman 0
3846146 1972349 1972349 defendant Tomson William husbandman 603876 603876 Tomson, William, of Helgay, husbandman 2
3849895 1973552 1973552 defendant Dobbys John smith 603876 603876 Dobbys, John, of Helgay, smith 1
3849896 1973552 1973552 defendant Hawkys Richard husbandman 603876 603876 Hawkys, Richard, of Helgay, husbandman 2
3850935 1973885 1973885 defendant Huddelston William laborer 603876 603876 Huddelston, William, of Helgay, laborer 0
3862957 1977806 1977806 defendant Skipwyth William gent 603876 603876 Skipwyth, William, of Helgay, gent 1
3888135 1986288 1986288 defendant Gybson Stephen tailor 603876 603876 Gybson, Stephen, of Helgay, tailor 1
3888136 1986288 1986288 defendant Tomson William husbandman 603876 603876 Tomson, William, of Helgay, husbandman 2
3922860 1997948 1997948 defendant Halyett Thomas butcher 603876 603876 Halyett, Thomas, of Helgay, butcher 0
3934596 2001864 2001864 plaintiff Holliar William   603876 603876 Holliar, William, of Helgay, Rector 0
3936497 2002531 2002531 defendant Heynene William hubandman 603876 603876 Heynene, William, of Helgay, hubandman 1
3936498 2002531 2002531 defendant Glyse William husbandman 603876 603876 Glyse, William, of Helgay, husbandman 2
3939805 2003614 2003614 defendant Love William husbandman 603876 603876 Love, William, of Helgay, husbandman 0
3957523 2009698 2009698 plaintiff Portler William   603876 603876 Portler, William, of Helgay 0
3996022 2023332 2023332 defendant Cooke Cuthbert husbandman 603876 603876 Cooke, Cuthbert, of Helgay, husbandman 0
3996031 2023334 2023334 defendant Cocke Cuthbert husbandman 603876 603876 Cocke, Cuthbert, of Helgay, husbandman 0
3996068 2023346 2023346 defendant Suterbye Christopher husbandman 603876 603876 Suterbye, Christopher, of Helgay, husbandman 2
4030966 2035743 2035743 defendant Waller Clement husbandman 603876 603876 Waller, Clement, of Helgay, husbandman 3
4039448 2038735 2038735 defendant Clemens Richard husbandman 603876 603876 Clemens, Richard, of Helgay, husbandman 2
4039449 2038735 2038735 defendant Redhead John husbandman 603876 603876 Redhead, John, of Helgay, husbandman 3
4039757 2038832 2038832 defendant Marsham Thomas yeoman 603876 603876 Marsham, Thomas, of Helgay, yeoman 2
4078369 2052558 2052558 defendant Farnelay John gent 603876 603876 Farnelay, John, of Helgay, gent 0
4106535 2062626 2062626 defendant Sandyver William husbandman 603876 603876 Sandyver, William, of Helgay, husbandman 2
4226826 2104854 2104854 defendant Cowke Cuthbert husbandman 603876 603876 Cowke, Cuthbert, of Helgay, husbandman 3
4274547 2121041 2121041 defendant Robynson Edward yeoman 603876 603876 Robynson, Edward, of Helgay, or of Stockferye, yeoman 2
4282092 2123637 2123637 defendant Herke William husbandman 603876 603876 (Herke, William, of Helgay, husbandman 2
4326074 2139091 2139091 defendant Reason William shoemaker 603876 603876 Reason, William, of Helgay, shoemaker 0
4339275 2143502 2143502 defendant Wood Richard waterman 603876 603876 Wood, Richard, of Helgay, waterman 0
4387824 2160563 2160563 defendant Stutley John husbandman 603876 603876 Stutley, John, of Helgay, husbandman 1
4410829 2168211 2168211 defendant Wood Richard waterman 603876 603876 Wood, Richard, of Helgay, waterman 3
5228574 2423963 2423963 defendant Bekke John husbandman 603876 603876 Bekke, John, of Helgay, husbandman 0
5308852 2447689 2447689 defendant Hawkyn Edmund yeoman 603876 603876 Hawkyn, Edmund, of Helgay, yeoman 0
5428572 2483467 2483467 defendant Gauge Thomas (legal representative) 603876 603876 Gauge, Thomas, of Helgay, husbandman, administrator of 10
5520749 2511311 2511311 defendant Alen George laborer 603876 603876 Alen, George, of Helgay, laborer 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);