names

42 rows where place_id = 668991

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3991353 2021662 2021662 defendant Maye William butcher 668991 668991 Maye, William, of Thirske, butcher 0
3991362 2021665 2021665 defendant Maye William butcher 668991 668991 Maye, William, of Thirske, butcher 0
3993488 2022414 2022414 defendant Barton Henry gent 668991 668991 Barton, Henry, of Thirske, gent 0
3993490 2022415 2022415 defendant Barton Henry gent 668991 668991 Barton, Henry, of Thirske, gent 0
4001861 2025440 2025440 defendant Jeffraye Richard laborer 668991 668991 Jeffraye, Richard, of Thirske, laborer 0
4001862 2025440 2025440 defendant Jeffraye Henry weaver 668991 668991 Jeffraye, Henry, of Thirske, weaver 1
4014739 2029981 2029981 defendant Barton Henry gent 668991 668991 Barton, Henry, of Thirske, gent 0
4014741 2029982 2029982 defendant Barton Henry gent 668991 668991 Barton, Henry, of Thirske, gent 0
4033419 2036608 2036608 defendant Wylson Thomas yeoman 668991 668991 Wylson, Thomas, of Thirske, yeoman 0
4033420 2036608 2036608 defendant Wood John yeoman 668991 668991 Wood, John, of Thirske, yeoman 1
4084815 2054845 2054845 defendant Tayller Giles husbandman 668991 668991 Tayller, Giles, of Thirske, husbandman 0
4084816 2054845 2054845 defendant Warde George smith 668991 668991 Warde, George, of Thirske, smith 1
4117873 2066683 2066683 defendant Jackson Christopher shoemaker 668991 668991 Jackson, Christopher, of Thirske, shoemaker 0
4141967 2075357 2075357 defendant Smyth Oswald yeoman 668991 668991 Smyth, Oswald, of Thirske, yeoman 1
4218491 2101966 2101966 defendant Burton Thomas yeoman 668991 668991 Burton, Thomas, of Thirske, yeoman 0
4223817 2103817 2103817 defendant Burton Thomas yeoman 668991 668991 Burton, Thomas, of Thirske, yeoman 0
4229790 2105902 2105902 defendant Jackson Christopher yeoman 668991 668991 Jackson, Christopher, of Thirske, yeoman 0
4252678 2113883 2113883 defendant Goolthwaite Robert chapman 668991 668991 Goolthwaite, Robert, of Thirske, chapman 0
4254153 2114384 2114384 defendant Procter Giles clerk 668991 668991 Procter, Giles, of Thirske, clerk 1
4269328 2119332 2119332 defendant Burton Thomas yeoman 668991 668991 Burton, Thomas, of Thirske, yeoman 0
4275867 2121508 2121508 defendant Burton Thomas yeoman 668991 668991 Burton, Thomas, of Thirske, yeoman 0
4282188 2123671 2123671 defendant Gainesbye William tanner 668991 668991 Gainesbye, William, of Thirske, weaver, together with, Williamson, John, of Thirske, tanner 0
4282189 2123671 2123671 defendant Skotson John tailor 668991 668991 Skotson, John, of Thirske, tailor 1
4315283 2135458 2135458 defendant Glothwayt or Gowthwat Robert merchant 668991 668991 Glothwayt or Gowthwat, Robert, of Thirske, merchant 3
4318751 2136670 2136670 defendant Cawton Anthony tanner 668991 668991 Cawton, Anthony, of Thirske, tanner 0
4321072 2137465 2137465 defendant Vertie John yeoman 668991 668991 Vertie, John, of Thirske, yeoman 0
4344790 2145457 2145457 defendant Cawton Francis tanner 668991 668991 Cawton, Francis, of Thirske, tanner 0
4411089 2168295 2168295 defendant Williamson John tanner 668991 668991 Williamson, John, of Thirske, tanner 0
4411090 2168295 2168295 defendant Sharpe John tanner 668991 668991 Sharpe, John, of Thirske, tanner 1
4411931 2168586 2168586 defendant Carter John yeoman 668991 668991 Carter, John, of Thirske, yeoman 0
4411932 2168586 2168586 defendant Carter Robert husbandman 668991 668991 Carter, Robert, of Thirske, husbandman 1
4411933 2168586 2168586 defendant Carter Nicholas husbandman 668991 668991 Carter, Nicholas, of Thirske, husbandman 2
4411934 2168586 2168586 defendant Carter William roper 668991 668991 Carter, William, of Thirske, roper 3
4411935 2168586 2168586 defendant Yeates Edward weaver 668991 668991 Yeates, Edward, of Thirske, weaver 4
4674783 2257727 2257727 defendant Flesshewer John butcher 668991 668991 Flesshewer, John, of Thirske, butcher 1
5002394 2357610 2357610 defendant Beston John yeoman 668991 668991 Beston, John, of Thirske, yeoman 1
5318590 2450654 2450654 defendant Graybarn John (legal representative) 668991 668991 Graybarn, John, of Thirske, baker, executor of Graybarn, Robert, of Thirske, husbandman, executors of 0
5318593 2450654 2450654 defendant Busse Robert shoemaker 668991 668991 Busse, Robert, of Thirske, shoemaker 3
5593923 2533089 2533089 defendant Butterworth Ralph chaplain 668991 668991 Butterworth, Ralph, of Thirske, chaplain 0
5600950 2535183 2535183 defendant Marshall William gent 668991 668991 Marshall, William, of Thirske, gent 1
5600953 2535184 2535184 defendant Marshall William gent 668991 668991 Marshall, William, of Thirske, gent 1
5600956 2535185 2535185 defendant Marshall William gent 668991 668991 Marshall, William, of Thirske, gent 1

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