names

61 rows where place_id = 590972

✎ 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
3602866 1868564 1868564 defendant Saverey Thomas laborer 590972 590972 Saverey, Thomas, of Tyllyngham, laborer 2
3621428 1874241 1874241 defendant Causton Thomas yeoman 590972 590972 Causton, Thomas, of Tyllyngham, yeoman 0
3621429 1874241 1874241 defendant Maunche Robert yeoman 590972 590972 Maunche, Robert, of Tyllyngham, yeoman 1
3644356 1908652 1908652 defendant Atwode Henry yeoman 590972 590972 Atwode, Henry, of Tyllyngham, yeoman 1
3681718 1920379 1920379 defendant Dote Thomas butcher 590972 590972 Dote, Thomas, of Tyllyngham, butcher 2
3763506 1946220 1946220 defendant Causton Thomas yeoman 590972 590972 Causton, Thomas, of Tyllyngham, yeoman 0
3763593 1946248 1946248 defendant Causton Thomas yeoman 590972 590972 Causton, Thomas, of Tyllyngham, yeoman 0
3788230 1954116 1954116 defendant Cawston Thomas husbandman 590972 590972 Cawston, Thomas, of Tyllyngham, husbandman 0
3792567 1955533 1955533 defendant Cawston Thomas yeoman 590972 590972 Cawston, Thomas, of Tyllyngham, yeoman 0
3832700 1968154 1968154 defendant Lambe Thomas husbandman 590972 590972 Lambe, Thomas, of Tyllyngham, husbandman 0
3836485 1969317 1969317 defendant Thymbyll Gregory yeoman 590972 590972 Thymbyll, Gregory, of Tyllyngham, yeoman 1
3836486 1969317 1969317 defendant Woodland Edward yeoman 590972 590972 Woodland, Edward, of Tyllyngham, yeoman 2
3848434 1973088 1973088 defendant Lambe Thomas husbandman 590972 590972 Lambe, Thomas, of Tyllyngham, husbandman 0
3851858 1974174 1974174 defendant Wyatt Margery widow 590972 590972 Wyatt, Margery, of Tyllyngham, widow 0
3851859 1974174 1974174 defendant Isaak Edward esq 590972 590972 Isaak, Edward, of Tyllyngham, esq 1
3851860 1974174 1974174 defendant Bode or Bole John husbandman 590972 590972 Bode or Bole, John, of Tyllyngham, husbandman 2
3851861 1974174 1974174 defendant Thymbyll Gregory yeoman 590972 590972 Thymbyll, Gregory, of Tyllyngham, yeoman 3
3861219 1977228 1977228 defendant Issak Edward esq 590972 590972 Issak, Edward, of Tyllyngham, esq 0
3861220 1977228 1977228 defendant Bood John husbandman 590972 590972 Bood, John, of Tyllyngham, husbandman 1
3861221 1977228 1977228 defendant Nevell John husbandman 590972 590972 Nevell, John, of Tyllyngham, husbandman 2
3861222 1977228 1977228 defendant Battell Richard husbandman 590972 590972 Battell, Richard, of Tyllyngham, husbandman 3
3861223 1977228 1977228 defendant Slyng Robert yeoman 590972 590972 Slyng, Robert, of Tyllyngham, yeoman 4
3861224 1977228 1977228 defendant Cokyll John yeoman 590972 590972 Cokyll, John, of Tyllyngham, yeoman 5
3861225 1977228 1977228 defendant Roo Robert butcher 590972 590972 Roo, Robert, of Tyllyngham, butcher 6
3866355 1978982 1978982 defendant Wyat Margery widow 590972 590972 Wyat, Margery, of Tyllyngham, widow 0
3866356 1978982 1978982 defendant Isaak Edward esq 590972 590972 Isaak, Edward, of Tyllyngham, esq 1
3866357 1978982 1978982 defendant Bode John husbandman 590972 590972 Bode, John, of Tyllyngham, husbandman 2
3866358 1978982 1978982 defendant Thymbyll Gregory yeoman 590972 590972 Thymbyll, Gregory, of Tyllyngham, yeoman 3
3866359 1978982 1978982 defendant Hawkys Thomas yeoman 590972 590972 Hawkys, Thomas, of Tyllyngham, yeoman 4
3877788 1982811 1982811 defendant Lambe Thomas husbandman 590972 590972 Lambe, Thomas, of Tyllyngham, husbandman 0
3893654 1988105 1988105 defendant Stevyn John, senior husbandman 590972 590972 Stevyn, John, senior, of Tyllyngham, husbandman 0
3896120 1988906 1988906 defendant Stevens John husbandman 590972 590972 Stevens, John, of Tyllyngham, husbandman 1
4275053 2121226 2121226 defendant Gaywood John yeoman 590972 590972 Gaywood, John, of Tyllyngham, yeoman 0
4504653 2201998 2201998 defendant Kamsyd Richard   590972 590972 Kamsyd, Richard, of Tyllyngham 1
4553967 2217160 2217160 defendant Bakere John (legal representative) 590972 590972 Bakere, John, of Tyllyngham, executors of 1
4630019 2240307 2240307 defendant Sawekyn John   590972 590972 Sawekyn, John, of Tyllyngham 3
4630022 2240308 2240308 defendant Stephene John   590972 590972 Stephene, John, of Tyllyngham, son of John 1
4630024 2240308 2240308 defendant Sawekyn John tailor 590972 590972 Sawekyn, John, of Tyllyngham, tailor 3
4943595 2339964 2339964 defendant Payn John laborer 590972 590972 Payn, John, of Tyllyngham, laborer 0
4986972 2353045 2353045 defendant Midlyng Ralph husbandman 590972 590972 Midlyng, Ralph, of Tyllyngham, husbandman 0
5014067 2360969 2360969 defendant Catour Richard husbandman 590972 590972 Catour, Richard, of Tyllyngham, husbandman 1
5023557 2363799 2363799 defendant Mynton Thomas husbandman 590972 590972 Mynton, Thomas, of Tyllyngham, husbandman 1
5055151 2373115 2373115 defendant Chapman John husbandman 590972 590972 Chapman, John, of Tyllyngham, husbandman 1
5056406 2373490 2373490 defendant Smyth Robert chapman 590972 590972 Smyth, Robert, of Tyllyngham, chapman 0
5100286 2386528 2386528 defendant Lambe Thomas clerk 590972 590972 Lambe, Thomas, of Tyllyngham, clerk 0
5100288 2386528 2386528 defendant Wotte John husbandman 590972 590972 Wotte, John, of Tyllyngham, husbandman 2
5213928 2419805 2419805 defendant Bregge Richard (legal representative) 590972 590972 Bregge, Richard, of Tyllyngham, husbandman, executors of 0
5213930 2419805 2419805 defendant Bregge Thomas husbandman 590972 590972 Bregge, Thomas, of Tyllyngham, husbandman 2
5213931 2419805 2419805 defendant Bregge Reginald husbandman 590972 590972 Bregge, Reginald, of Tyllyngham, husbandman 3
5232501 2425085 2425085 defendant Poort William husbandman 590972 590972 Poort, William, of Tyllyngham, husbandman 0
5362225 2463851 2463851 defendant Poort William yeoman 590972 590972 Poort, William, of Tyllyngham, yeoman 0
5381059 2469636 2469636 defendant Tayler Richard husbandman 590972 590972 Tayler, Richard, of Tyllyngham, husbandman 2
5381064 2469637 2469637 defendant Tayler Richard husbandman 590972 590972 Tayler, Richard, of Tyllyngham, husbandman 2
5387508 2471494 2471494 defendant Tayler Richard husbandman 590972 590972 Tayler, Richard, of Tyllyngham, husbandman 0
5405806 2476731 2476731 defendant Kynge John husbandman 590972 590972 Kynge, John, of Tyllyngham, husbandman 0
5431730 2484457 2484457 defendant Canston Thomas husbandman 590972 590972 Canston, Thomas, of Tyllyngham, husbandman 0
5448065 2489309 2489309 defendant Canston Thomas husbandman 590972 590972 Canston, Thomas, of Tyllyngham, husbandman 0
5496585 2503893 2503893 defendant Causton or Canston John yeoman 590972 590972 Causton or Canston, John, of Tyllyngham, yeoman 1
5515228 2509609 2509609 defendant Chapman John laborer 590972 590972 Chapman, John, of Tyllyngham, laborer 0
5568886 2525452 2525452 defendant Causton John yeoman 590972 590972 Causton, John, of Tyllyngham, yeoman 0
5592771 2532738 2532738 defendant Stephen John husbandman 590972 590972 Stephen, John, of Tyllyngham, husbandman 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);