names

44 rows where place_id = 593675

✎ 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
3612893 1871681 1871681 defendant Smyth Robert yeoman 593675 593675 Smyth, Robert, of Brayton, yeoman 1
3612894 1871681 1871681 defendant Smyth John yeoman 593675 593675 Smyth, John, of Brayton, yeoman 2
3612895 1871681 1871681 defendant Lampron William husbandman 593675 593675 Lampron, William, of Brayton, husbandman 3
3656003 1912129 1912129 defendant York Richard   593675 593675 York, Richard, of Brayton, knight 0
3659225 1913141 1913141 defendant Lampworth William yeoman 593675 593675 Lampworth, William, of Brayton, yeoman 0
3699501 1926075 1926075 defendant Bally Robert yeoman 593675 593675 Bally, Robert, of Brayton, yeoman 0
3792212 1955418 1955418 defendant Maunsell Thomas clerk 593675 593675 Maunsell, Thomas, of Brayton, clerk 0
3796212 1956680 1956680 defendant Alleyn John gent 593675 593675 Alleyn, John, of Brayton, gent 5
3811219 1961404 1961404 defendant Smyter John husbandman 593675 593675 Smyter, John, of Brayton, husbandman 0
3816915 1963198 1963198 defendant Mansfylde John yeoman 593675 593675 Mansfylde, John, of Brayton, yeoman 1
3850059 1973608 1973608 defendant Goode Thomas husbandman 593675 593675 Goode, Thomas, of Brayton, husbandman 0
3852881 1974514 1974514 defendant Mannell or Manncell Thomas clerk 593675 593675 Mannell or Manncell, Thomas, of Brayton, clerk 0
4018246 2031252 2031252 defendant Allen Thomas gent 593675 593675 Allen, Thomas, of Brayton, gent 0
4053877 2043764 2043764 defendant West Thomas yeoman 593675 593675 West, Thomas, of Brayton, yeoman 0
4109276 2063578 2063578 defendant Nele Thomas husbandman 593675 593675 Nele, Thomas, of Brayton, husbandman 1
4110594 2064048 2064048 defendant Allen Thomas gent 593675 593675 Allen, Thomas, of Brayton, gent 1
4111474 2064351 2064351 defendant Allan Thomas yeoman 593675 593675 Allan, Thomas, of Brayton, yeoman 1
4224805 2104142 2104142 defendant Allen Thomas gent 593675 593675 Allen, Thomas, of Brayton, gent 0
4228966 2105613 2105613 defendant Bayles Edward husbandman 593675 593675 Bayles, Edward, of Brayton, husbandman 0
4265016 2117934 2117934 defendant Allen Thomas gent 593675 593675 Allen, Thomas, of Brayton, gent 0
4289015 2126128 2126128 defendant Harris William husbandman 593675 593675 Harris, William, of Brayton, husbandman 0
4314754 2135272 2135272 defendant Hunt Richard yeoman 593675 593675 Hunt, Richard, of Brayton, yeoman 1
4360431 2150897 2150897 defendant Shillitoo William husbandman 593675 593675 Shillitoo, William, of Brayton, husbandman 0
4360433 2150897 2150897 defendant Warde Henry laborer 593675 593675 Warde, Henry, of Brayton, laborer 2
4377321 2156965 2156965 defendant Dicconson alias Bolton Leonard husbandman 593675 593675 Dicconson alias Bolton, Leonard, of Brayton, husbandman 0
4472390 2192036 2192036 plaintiff Coke Richard   593675 593675 Coke, Richard, of Brayton, on his own account 0
4472391 2192036 2192036 defendant Duffeld John de   593675 593675 Duffeld, John de, of Brayton 0
4609954 2234203 2234203 defendant Emson William   593675 593675 Emson, William, of Brayton 1
4694171 2263678 2263678 defendant Bradmer Hugh chaplain 593675 593675 Bradmer, Hugh, of Brayton, chaplain 1
4780529 2289906 2289906 defendant Bradmer Hugh chaplain 593675 593675 Bradmer, Hugh, of Brayton, chaplain 0
4789220 2292687 2292687 defendant Annotson William chaplain 593675 593675 Annotson, William, of Brayton, chaplain 0
4805385 2297890 2297890 defendant Strensall John chaplain 593675 593675 Strensall, John, of Brayton, chaplain 4
4881940 2321249 2321249 defendant Strensall John clerk 593675 593675 Strensall, John, of Brayton, clerk 1
5085745 2382226 2382226 defendant Tyton John husbandman 593675 593675 Tyton, John, of Brayton, husbandman 1
5085746 2382226 2382226 defendant Brigge William husbandman 593675 593675 Brigge, William, of Brayton, husbandman 2
5163075 2404926 2404926 defendant Stodfolde John clerk 593675 593675 Stodfolde, John, of Brayton, clerk 1
5186987 2411932 2411932 defendant Stodfole John   593675 593675 Stodfole, John, of Brayton, vicar 0
5243737 2428358 2428358 defendant Smyth John husbandman 593675 593675 Smyth, John, of Brayton, husbandman 3
5308508 2447581 2447581 defendant Grove John chaplain 593675 593675 Grove, John, of Brayton, chaplain 0
5345221 2458675 2458675 defendant Stodfold John clerk 593675 593675 Stodfold, John, of Brayton, clerk 0
5345222 2458675 2458675 defendant Stodfold John yeoman 593675 593675 Stodfold, John, of Brayton, yeoman 1
5358816 2462818 2462818 defendant Stodfeld John chaplain 593675 593675 Stodfeld, John, of Brayton, chaplain 2
5571408 2526190 2526190 defendant Mascall John husbandman 593675 593675 Mascall, John, of Brayton, husbandman 2
5597822 2534214 2534214 defendant Chapman John   593675 593675 Chapman, John, of Brayton, wright 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);