names

43 rows where place_id = 621409

✎ 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
3741198 1939105 1939105 defendant Woodcok Hugh clerk 621409 621409 Woodcok, Hugh, of Tuddenham, clerk 3
3787906 1954008 1954008 defendant Hergrey Thomas husbandman 621409 621409 Hergrey, Thomas, of Tuddenham, husbandman 0
3800498 1958078 1958078 defendant White Thomas warrener 621409 621409 White, Thomas, of Tuddenham, warrener 1
3834437 1968718 1968718 plaintiff Mynter Robert husbandman 621409 621409 Mynter, Robert, of Tuddenham, husbandman 0
3841218 1970832 1970832 defendant Peke John husbandman 621409 621409 Peke, John, of Tuddenham, husbandman 1
3866362 1978983 1978983 defendant Smyth Richard husbandman 621409 621409 Smyth, Richard, of Tuddenham, husbandman 1
3877896 1982849 1982849 defendant Largeaunt Robert husbandman 621409 621409 Largeaunt, Robert, of Tuddenham, husbandman 3
3937111 2002748 2002748 plaintiff Myner Robert yeoman 621409 621409 Myner, Robert, of Tuddenham, yeoman 0
3937156 2002759 2002759 plaintiff Mynter Robert   621409 621409 Mynter, Robert, of Tuddenham, 0
3956265 2009254 2009254 plaintiff Mynter Robert yeoman 621409 621409 Mynter, Robert, of Tuddenham, yeoman 0
3956268 2009255 2009255 plaintiff Mynter Robert yeoman 621409 621409 Mynter, Robert, of Tuddenham, yeoman 0
3961583 2011149 2011149 plaintiff Tylney Robert yeoman 621409 621409 Tylney, Robert, of Tuddenham, yeoman 0
4025833 2033890 2033890 defendant Folk John warrener 621409 621409 Folk, John, of Tuddenham, warrener 1
4028049 2034683 2034683 defendant Bryante Peter husbandman 621409 621409 Bryante, Peter, of Tuddenham, husbandman 0
4060575 2046184 2046184 defendant Stevens William husbandman 621409 621409 Stevens, William, of Tuddenham, husbandman 0
4175826 2087022 2087022 defendant Androwes John   621409 621409 Androwes, John, of Tuddenham, linen weaver 0
4175827 2087022 2087022 defendant Lawser alias Laweswell Abraham   621409 621409 Lawser alias Laweswell, Abraham, of Tuddenham, linen weaver 1
4175828 2087022 2087022 defendant Barker Richard husbandman 621409 621409 Barker, Richard, of Tuddenham, husbandman 2
4175829 2087022 2087022 defendant Jage or Gage John husbandman 621409 621409 Jage or Gage, John, of Tuddenham, husbandman 3
4213053 2100091 2100091 defendant Vincent Godfrey yeoman 621409 621409 Vincent, Godfrey, of Tuddenham, yeoman 0
4213054 2100091 2100091 defendant Barber Richard yeoman 621409 621409 Barber, Richard, of Tuddenham, yeoman 1
4214095 2100447 2100447 defendant Byell Edmund yeoman 621409 621409 Byell, Edmund, of Tuddenham, yeoman 2
4233618 2107281 2107281 defendant Byall Edmund yeoman 621409 621409 Byall, Edmund, of Tuddenham, yeoman 2
4233623 2107282 2107282 defendant Byall Edmund yeoman 621409 621409 Byall, Edmund, of Tuddenham, yeoman 0
4246424 2111781 2111781 defendant Fynche George yeoman 621409 621409 Fynche, George, of Tuddenham, yeoman 2
4247939 2112296 2112296 defendant Webb William yeoman 621409 621409 Webb, William, of Tuddenham, yeoman 0
4250313 2113085 2113085 defendant Webbe William husbandman 621409 621409 Webbe, William, of Tuddenham, husbandman 0
4285983 2125041 2125041 defendant Vincent Godfrey yeoman 621409 621409 Vincent, Godfrey, of Tuddenham, yeoman 1
4303584 2131380 2131380 defendant Webb William yeoman 621409 621409 Webb, William, of Tuddenham, yeoman 0
4315285 2135459 2135459 defendant Harries John yeoman 621409 621409 Harries, John, of Tuddenham, yeoman 0
4315286 2135459 2135459 defendant Cooper William husbandman 621409 621409 Cooper, William, of Tuddenham, husbandman 1
4324281 2138520 2138520 defendant Waler Robert clerk 621409 621409 Waler, Robert, of Tuddenham, clerk 3
4327487 2139514 2139514 defendant Button Richard miller 621409 621409 Button, Richard, of Tuddenham, miller 2
4343525 2145012 2145012 defendant Yonges Robert yeoman 621409 621409 Yonges, Robert, of Tuddenham, yeoman 2
4344624 2145399 2145399 defendant Grave John husbandman 621409 621409 Grave, John, of Tuddenham, husbandman 0
4390399 2161411 2161411 defendant Pen Henry carpenter 621409 621409 Pen, Henry, of Tuddenham, carpenter 2
4399949 2164573 2164573 defendant Fynche John yeoman 621409 621409 Fynche, John, of Tuddenham, yeoman 0
4399951 2164573 2164573 defendant Younges Robert yeoman 621409 621409 Younges, Robert, of Tuddenham, yeoman 2
4410253 2168028 2168028 defendant Tayler Edward husbandman 621409 621409 Tayler, Edward, of Tuddenham, husbandman 0
4411132 2168311 2168311 defendant Strutton William yeoman 621409 621409 Strutton, William, of Tuddenham, yeoman 1
5141164 2398538 2398538 defendant Boys William yeoman 621409 621409 Boys, William, of Tuddenham, yeoman 0
5520789 2511322 2511322 defendant Hardgrey William husbandman 621409 621409 Hardgrey, William, of Tuddenham, husbandman 4
5541374 2517419 2517419 defendant Smyth Robert husbandman 621409 621409 Smyth, Robert, of Tuddenham, 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);