names

53 rows where place_id = 603820

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3655889 1912094 1912094 defendant Godfrey Thomas   603820 603820 Godfrey, Thomas, of Heth 3
3765008 1946722 1946722 defendant Roo John husbandman 603820 603820 Roo, John, of Heth, husbandman 0
3769130 1947999 1947999 defendant Pyx Hugh yeoman 603820 603820 Pyx, Hugh, of Heth, yeoman 0
3792239 1955426 1955426 defendant Hardewyk John husbandman 603820 603820 Hardewyk, John, of Heth, husbandman 0
3792240 1955426 1955426 defendant Dobbys John husbandman 603820 603820 Dobbys, John, of Heth, husbandman 1
3795107 1956332 1956332 defendant Fryston John gent 603820 603820 Fryston, John, of Heth, gent 1
3814059 1962300 1962300 defendant Fryston John gent 603820 603820 Fryston, John, of Heth, gent 1
3830005 1967279 1967279 defendant Doxsey Richard husbandman 603820 603820 Doxsey, Richard, of Heth, husbandman 1
4315758 2135622 2135622 defendant Parshmydge Thomas tailor 603820 603820 (Parshmydge, Thomas, of Heth, tailor 1
4384912 2159645 2159645 defendant Everyng Reginald chapman 603820 603820 Everyng, Reginald, of Heth, chapman 0
4384914 2159646 2159646 defendant Everyng Reginald mercer 603820 603820 Everyng, Reginald, of Heth, mercer 0
4393276 2162355 2162355 defendant Hicke John merchant 603820 603820 Hicke, John, of Heth, merchant 0
4393277 2162355 2162355 defendant Milles Peter merchant 603820 603820 Milles, Peter, of Heth, merchant 1
4393278 2162355 2162355 defendant Strowde or Strode Peter merchant 603820 603820 Strowde or Strode, Peter, of Heth, merchant 2
4474659 2192737 2192737 defendant Clerk John   603820 603820 Clerk, John, of Heth 0
4614872 2235657 2235657 defendant atte Wode John   603820 603820 atte Wode, John, of Heth 1
4614874 2235657 2235657 defendant Sherewent John spicer 603820 603820 Sherewent, John, of Heth, spicer 3
4628016 2239684 2239684 defendant Savage John   603820 603820 Savage, John, of Heth 3
4640852 2243424 2243424 defendant atte Wode John spicer 603820 603820 atte Wode, John, of Heth, spicer 1
4700833 2265660 2265660 defendant Savage John collier 603820 603820 Savage, John, of Heth, collier 0
4713685 2269603 2269603 defendant Frankys John gent 603820 603820 Frankys, John, of Heth, gent 0
4750937 2280758 2280758 defendant Carter John collier 603820 603820 Carter, John, of Heth, collier 0
4786767 2291916 2291916 defendant Wales John husbandman 603820 603820 Wales, John, of Heth, husbandman 0
4786768 2291916 2291916 defendant Chastre John, junior husbandman 603820 603820 Chastre, John, junior, of Heth, husbandman 1
4786769 2291916 2291916 defendant de Helay John husbandman 603820 603820 de Helay, John, of Heth, husbandman 2
4816909 2301391 2301391 defendant Baker Henry husbandman 603820 603820 Baker, Henry, of Heth, husbandman 0
5091628 2383941 2383941 defendant Savage John collier 603820 603820 Savage, John, of Heth, collier 0
5091629 2383941 2383941 defendant Aston Robert collier 603820 603820 Aston, Robert, of Heth, collier 1
5091630 2383941 2383941 defendant Staury John collier 603820 603820 Staury, John, of Heth, collier 2
5091631 2383941 2383941 defendant Pykeryng Richard smith 603820 603820 Pykeryng, Richard, of Heth, smith 3
5135702 2396953 2396953 defendant Boweker William husbandman 603820 603820 Boweker, William, of Heth, husbandman 0
5135703 2396953 2396953 defendant Huetson Roger husbandman 603820 603820 Huetson, Roger, of Heth, husbandman 1
5135704 2396953 2396953 defendant Boweker John husbandman 603820 603820 Boweker, John, of Heth, husbandman 2
5135705 2396953 2396953 defendant Robert Peter husbandman 603820 603820 Robert, Peter, of Heth, husbandman 3
5156551 2403069 2403069 defendant Boweker William husbandman 603820 603820 Boweker, William, of Heth, husbandman 0
5156552 2403069 2403069 defendant Huetson Roger husbandman 603820 603820 Huetson, Roger, of Heth, husbandman 1
5156553 2403069 2403069 defendant Boweker John husbandman 603820 603820 Boweker, John, of Heth, husbandman 2
5156554 2403069 2403069 defendant Robert Peter husbandman 603820 603820 Robert, Peter, of Heth, husbandman 3
5179505 2409741 2409741 defendant Chestre Christopher husbandman 603820 603820 Chestre, Christopher, of Heth, husbandman 0
5179506 2409741 2409741 defendant Wales Alexander yeoman 603820 603820 Wales, Alexander, of Heth, yeoman 1
5192452 2413529 2413529 defendant Boweker William husbandman 603820 603820 Boweker, William, of Heth, husbandman 0
5192453 2413529 2413529 defendant Huetson Roger husbandman 603820 603820 Huetson, Roger, of Heth, husbandman 1
5192454 2413529 2413529 defendant Boweker John husbandman 603820 603820 Boweker, John, of Heth, husbandman 2
5192455 2413529 2413529 defendant Robert Peter husbandman 603820 603820 Robert, Peter, of Heth, husbandman 3
5234400 2425650 2425650 defendant Symond John husbandman 603820 603820 Symond, John, of Heth, husbandman 2
5327576 2453321 2453321 defendant Sysson John yeoman 603820 603820 Sysson, John, of Heth, yeoman 0
5333983 2455235 2455235 defendant Tyler Roger husbandman 603820 603820 Tyler, Roger, of Heth, husbandman 0
5513746 2509153 2509153 defendant Malmayn John yeoman 603820 603820 Malmayn, John, of Heth, yeoman 1
5531257 2514292 2514292 defendant Arkell Thomas   603820 603820 Arkell, Thomas, of Heth, wain man 1
5531260 2514293 2514293 defendant Arkett or Arkell Thomas wainman 603820 603820 Arkett or Arkell, Thomas, of Heth, wainman 1
5549143 2519792 2519792 defendant Smolte John husbandman 603820 603820 Smolte, John, of Heth, husbandman 3
5549144 2519792 2519792 defendant Assheton William husbandman 603820 603820 Assheton, William, of Heth, husbandman 4
5549145 2519792 2519792 defendant Barker Robert husbandman 603820 603820 Barker, Robert, of Heth, 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);