names

40 rows where place_id = 598900

✎ 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
3634478 1905583 1905583 defendant Colman John yeoman 598900 598900 Colman, John, of Holden, yeoman 2
3673309 1917667 1917667 defendant Akland Thomas husbandman 598900 598900 Akland, Thomas, of Holden, husbandman 0
3673310 1917667 1917667 defendant Garbytt William husbandman 598900 598900 Garbytt, William, of Holden, husbandman 1
3767147 1947373 1947373 defendant Holden Gilbert gent 598900 598900 Holden, Gilbert, of Holden, gent 1
3789332 1954484 1954484 defendant Tyler Henry (legal representative) 598900 598900 Tyler, Henry, of Holden, clerk, executor of 0
3838275 1969887 1969887 defendant Hopkyn John husbandman 598900 598900 Hopkyn, John, of Holden, husbandman 3
3871137 1980598 1980598 defendant Barker John gent 598900 598900 Barker, John, of Holden, gent 0
3876377 1982345 1982345 defendant Spens William yeoman 598900 598900 Spens, William, of Holden, yeoman 0
3880266 1983653 1983653 defendant Greves William gent 598900 598900 Greves, William, of Holden, gent 0
3924300 1998434 1998434 defendant Preston Thomas laborer 598900 598900 Preston, Thomas, of Holden, laborer 2
3924301 1998434 1998434 defendant Person Thomas butcher 598900 598900 Person, Thomas, of Holden, butcher 3
3924302 1998434 1998434 defendant Lawson William husbandman 598900 598900 Lawson, William, of Holden, husbandman 4
3969791 2014040 2014040 defendant Preston Thomas   598900 598900 Preston, Thomas, of Holden, surgeon 0
3998933 2024376 2024376 defendant Walbanke Henry yeoman 598900 598900 Walbanke, Henry, of Holden, yeoman 1
3998934 2024376 2024376 defendant Cantley John yeoman 598900 598900 Cantley, John, of Holden, yeoman 2
4006031 2026931 2026931 defendant Crocke Oliver yeoman 598900 598900 Crocke, Oliver, of Holden, yeoman 3
4006041 2026932 2026932 defendant Crocke Oliver yeoman 598900 598900 Crocke, Oliver, of Holden, yeoman 3
4040393 2039063 2039063 defendant Walbanke Henry yeoman 598900 598900 Walbanke, Henry, of Holden, yeoman 6
4040406 2039064 2039064 defendant Walbanke Henry yeoman 598900 598900 Walbanke, Henry, of Holden, yeoman 6
4042605 2039825 2039825 defendant Preston Thomas yeoman 598900 598900 Preston, Thomas, of Holden, yeoman 1
4046092 2041041 2041041 plaintiff Kyrkby Thomas tailor 598900 598900 Kyrkby, Thomas, of Holden, tailor 2
4206905 2097958 2097958 defendant Palmer Thomas yeoman 598900 598900 Palmer, Thomas, of Holden, or of Houeden or Hoveden, Yorks, yeoman 0
4208921 2098669 2098669 plaintiff Kyrkby Thomas tailor 598900 598900 Kyrkby, Thomas, of Holden, tailor 2
4213913 2100387 2100387 defendant Heathe Roger yeoman 598900 598900 Heathe, Roger, of Holden, yeoman 1
4270561 2119734 2119734 plaintiff Pearson Edward   598900 598900 Pearson, Edward, of Holden 0
4294510 2128122 2128122 defendant Barker William   598900 598900 Barker, William, of Holden, Yorks innholder 0
4353720 2148522 2148522 defendant Hynchbald Edward mercer 598900 598900 Hynchbald, Edward, of Holden, mercer 0
4376056 2156499 2156499 defendant Davie Simon butcher 598900 598900 Davie, Simon, of Holden, butcher 1
4407230 2166982 2166982 defendant Hynchbalde Edward mercer 598900 598900 Hynchbalde, Edward, of Holden, mercer 0
4412827 2168885 2168885 defendant Kydd William husbandman 598900 598900 Kydd, William, of Holden, husbandman 0
4474965 2192838 2192838 defendant Tipynden Thomas   598900 598900 Tipynden, Thomas, of Holden 0
4921048 2333094 2333094 defendant Lucas John   598900 598900 Lucas, John, of Holden 1
4921051 2333095 2333095 defendant Hope Richard weaver 598900 598900 Hope, Richard, of Holden, weaver 0
5061043 2374877 2374877 defendant Amekotes William cordwainer 598900 598900 Amekotes, William, of Holden, cordwainer 0
5061045 2374877 2374877 defendant Walbanke John saddler 598900 598900 Walbanke, John, of Holden, saddler 2
5184400 2411177 2411177 defendant Bacon John husbandman 598900 598900 Bacon, John, of Holden, husbandman 0
5184416 2411180 2411180 defendant Bacon John husbandman 598900 598900 Bacon, John, of Holden, husbandman 0
5204309 2417014 2417014 defendant Baton John husbandman 598900 598900 Baton, John, of Holden, husbandman 0
5471054 2496282 2496282 defendant at Hale John husbandman 598900 598900 at Hale, John, of Holden, husbandman 0
5605074 2536457 2536457 defendant Spert William yeoman 598900 598900 Spert, William, of Holden, yeoman 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);