names

73 rows where place_id = 594989

✎ 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
3618387 1873383 1873383 defendant Kyng Robert gent 594989 594989 Kyng, Robert, of Tyberton, gent 0
3618389 1873384 1873384 defendant Kyng Robert gent 594989 594989 Kyng, Robert, of Tyberton, gent 0
3650135 1910412 1910412 defendant Hathewey Richard gent 594989 594989 Hathewey, Richard, of Tyberton, gent 0
3653769 1911438 1911438 defendant Meredyth Hugh smith 594989 594989 Meredyth, Hugh, of Tyberton, smith 1
3653773 1911439 1911439 defendant Grene Richard tanner 594989 594989 Grene, Richard, of Tyberton, tanner 1
3653774 1911439 1911439 defendant Grene William husbandman 594989 594989 Grene, William, of Tyberton, husbandman 2
3781805 1952056 1952056 plaintiff Hemmyng James (legal representative) 594989 594989 Hemmyng, James, of Tyberton, executrix of 0
3802962 1958824 1958824 defendant Chylcott John miller 594989 594989 Chylcott, John, of Tyberton, miller 0
3845141 1972041 1972041 defendant Clerke John husbandman 594989 594989 Clerke, John, of Tyberton, husbandman 1
3890842 1987205 1987205 plaintiff Jakeson James yeoman 594989 594989 Jakeson, James, of Tyberton, yeoman 0
3897274 1989306 1989306 defendant Wheler John weaver 594989 594989 Wheler, John, of Tyberton, weaver 0
3898427 1989686 1989686 defendant Meryck Richard yeoman 594989 594989 Meryck, Richard, of Tyberton, yeoman 0
3971458 2014576 2014576 defendant Meyrick Thomas gent 594989 594989 Meyrick, Thomas, of Tyberton, gent 0
3984142 2019093 2019093 defendant Brooke George husbandman 594989 594989 Brooke, George, of Tyberton, husbandman 0
4021160 2032287 2032287 defendant Ellys Robert yeoman 594989 594989 Ellys, Robert, of Tyberton, yeoman 2
4079058 2052810 2052810 defendant Meyrycke Thomas gent 594989 594989 Meyrycke, Thomas, of Tyberton, gent 0
4079059 2052810 2052810 defendant Brater Thomas husbandman 594989 594989 Brater, Thomas, of Tyberton, husbandman 1
4087973 2055994 2055994 defendant Meyricke Thomas yeoman 594989 594989 Meyricke, Thomas, of Tyberton, yeoman 0
4127374 2070081 2070081 defendant Meyricke Thomas gent 594989 594989 Meyricke, Thomas, of Tyberton, gent 0
4128189 2070370 2070370 defendant Dalabere John esq 594989 594989 Dalabere, John, of Tyberton, esq 0
4128231 2070382 2070382 defendant Robert Maud spinster 594989 594989 Robert, Maud, of Tyberton, spinster 0
4128232 2070382 2070382 defendant Robert Margery spinster 594989 594989 Robert, Margery, of Tyberton, spinster 1
4151595 2078676 2078676 defendant Dalabere John esq 594989 594989 together with Dalabere, John, of Tyberton, esq 3
4151609 2078677 2078677 defendant Dalabere John esq 594989 594989 together with Dalabere, John, of Tyberton, esq 6
4163771 2082856 2082856 defendant Meyricke Thomas gent 594989 594989 Meyricke, Thomas, of Tyberton, gent 1
4173185 2086078 2086078 defendant Whythe Philip yeoman 594989 594989 Whythe, Philip, of Tyberton, yeoman 1
4176703 2087322 2087322 defendant Williams alias Baker John clerk 594989 594989 Williams alias Baker, John, of Tyberton, clerk 0
4201360 2096029 2096029 defendant Dalabere Thomas gent 594989 594989 Dalabere, Thomas, of Tyberton, gent 0
4201361 2096029 2096029 defendant Dalabere Kenard, junior gent 594989 594989 Dalabere, Kenard, junior, of Tyberton, gent 1
4201362 2096029 2096029 defendant Dalabere Jane spinster 594989 594989 Dalabere, Jane, of Tyberton, spinster 2
4215125 2100790 2100790 defendant Mathewes George yeoman 594989 594989 Mathewes, George, of Tyberton, yeoman 0
4217083 2101469 2101469 defendant Meyrick Thomas gent 594989 594989 Meyrick, Thomas, of Tyberton, gent 2
4218378 2101927 2101927 defendant Whitfield Edmund victualer 594989 594989 Whitfield, Edmund, of Tyberton, victualer 0
4292713 2127456 2127456 defendant Handman Thomas yeoman 594989 594989 together with Handman, Thomas, of Tyberton, yeoman 1
4294010 2127934 2127934 defendant Davyes Edward gent 594989 594989 Davyes, Edward, of Tyberton, gent 0
4295401 2128441 2128441 defendant Meyrick Thomas gent 594989 594989 Meyrick, Thomas, of Tyberton, gent 0
4301471 2130631 2130631 defendant Handman Thomas yeoman 594989 594989 Handman, Thomas, of Tyberton, yeoman 1
4314104 2135041 2135041 defendant Meyrycke Thomas gent 594989 594989 Meyrycke, Thomas, of Tyberton, gent 0
4394313 2162696 2162696 defendant Eynon Trianor, junior yeoman 594989 594989 Eynon, Trianor, junior, of Tyberton, yeoman 1
4412058 2168624 2168624 defendant ap Evan alias Bengoughe Henry husbandman 594989 594989 ap Evan alias Bengoughe, Henry, of of Tyberton, husbandman 1
4552248 2216658 2216658 defendant Thommes William   594989 594989 Thommes, William, of Tyberton 0
4828458 2304943 2304943 defendant Hugyns William husbandman 594989 594989 Hugyns, William, of Tyberton, husbandman 6
4828459 2304943 2304943 defendant Duke Walter yeoman 594989 594989 Duke, Walter, of Tyberton, yeoman 7
4855736 2313168 2313168 defendant Dale John husbandman 594989 594989 Dale, John, of Tyberton, husbandman 0
4862296 2315218 2315218 defendant Smyth William yeoman 594989 594989 Smyth, William, of Tyberton, yeoman 0
4927037 2334885 2334885 defendant Smyth William yeoman 594989 594989 Smyth, William, of Tyberton, yeoman 0
4927038 2334885 2334885 defendant Smyth David yeoman 594989 594989 Smyth, David, of Tyberton, yeoman 1
4952265 2342645 2342645 defendant Smyth William yeoman 594989 594989 Smyth, William, of Tyberton, yeoman 0
4952266 2342645 2342645 defendant Smyth David yeoman 594989 594989 Smyth, David, of Tyberton, yeoman 1
4952269 2342646 2342646 defendant Smyth William yeoman 594989 594989 Smyth, William, of Tyberton, yeoman 0
4952270 2342646 2342646 defendant Smyth David yeoman 594989 594989 Smyth, David, of Tyberton, yeoman 1
4967757 2347301 2347301 defendant Smyth David husbandman 594989 594989 Smyth, David, of Tyberton, husbandman 2
4967758 2347301 2347301 defendant Smyth John yeoman 594989 594989 Smyth, John, of Tyberton, yeoman 3
5006561 2358819 2358819 defendant Smyth William yeoman 594989 594989 Smyth, William, of Tyberton, yeoman 0
5011485 2360225 2360225 defendant Cappes Robert esq 594989 594989 Cappes, Robert, of Tyberton, esq 0
5036494 2367535 2367535 defendant Smyth David smith 594989 594989 Smyth, David, of Tyberton, smith 0
5107373 2388586 2388586 defendant Smyth William yeoman 594989 594989 Smyth, William, of Tyberton, yeoman 0
5151468 2401577 2401577 defendant Smythe William husbandman 594989 594989 Smythe, William, of Tyberton, husbandman 2
5164733 2405418 2405418 defendant Smythe William husbandman 594989 594989 Smythe, William, of Tyberton, husbandman 2
5164734 2405418 2405418 defendant Smyth Richard   594989 594989 Smyth, Richard, of Tyberton yeoman 3
5249769 2430052 2430052 defendant Floure Thomas cooper 594989 594989 Floure, Thomas, of Tyberton, cooper 2
5251807 2430673 2430673 defendant Smyth William yeoman 594989 594989 Smyth, William, of Tyberton, yeoman 2
5251808 2430673 2430673 defendant Smyth Richard yeoman 594989 594989 Smyth, Richard, of Tyberton, yeoman 3
5304701 2446402 2446402 defendant Hyll John yeoman 594989 594989 Hyll, John, of Tyberton, yeoman 0
5306714 2446999 2446999 defendant Grove Richard clerk 594989 594989 Grove, Richard, of Tyberton, clerk 0
5379762 2469251 2469251 defendant Houle John husbandman 594989 594989 Houle, John, of Tyberton, husbandman 2
5490028 2501902 2501902 defendant Traveys Walter husbandman 594989 594989 Traveys, Walter, of Tyberton, husbandman 1
5492445 2502657 2502657 defendant Farthyng John yeoman 594989 594989 Farthyng, John, of Tyberton, yeoman 2
5492449 2502658 2502658 defendant Farthyng John yeoman 594989 594989 Farthyng, John, of Tyberton, yeoman 2
5562908 2523742 2523742 defendant Houghton John husbandman 594989 594989 Houghton, John, of Tyberton, husbandman 3
5562918 2523744 2523744 defendant Houghton John husbandman 594989 594989 Houghton, John, of Tyberton, husbandman 3
5578341 2528295 2528295 defendant Hyndy Thomas husbandman 594989 594989 Hyndy, Thomas, of Tyberton, husbandman 1
5596803 2533918 2533918 defendant Lylly Richard husbandman 594989 594989 (Lylly, Richard, of Tyberton, husbandman 5

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