names

40 rows where place_id = 601651

✎ 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
3644807 1908783 1908783 plaintiff Foster Robert (legal representative) 601651 601651 Foster, Robert, of Marleborough, executor of 0
3646369 1909257 1909257 defendant Parson Richard glover 601651 601651 Parson, Richard, of Marleborough, glover 0
3650838 1910627 1910627 defendant Burdeslay Nicholas fletcher 601651 601651 Burdeslay, Nicholas, of Marleborough, fletcher 0
3650839 1910627 1910627 defendant Griffith Agnes widow 601651 601651 Griffith, Agnes, of Marleborough, widow 1
3650840 1910627 1910627 defendant Ade William shoemaker 601651 601651 Ade, William, of Marleborough, shoemaker 2
3653172 1911327 1911327 defendant Lancastyr Robert mercer 601651 601651 Lancastyr, Robert, of Marleborough, mercer 0
3684231 1921202 1921202 defendant Quynteyn Walter gent 601651 601651 Quynteyn, Walter, of Marleborough, gent 2
3746068 1940675 1940675 defendant Smyth Robert tucker 601651 601651 Smyth, Robert, of Marleborough, tucker 0
3759207 1944867 1944867 defendant Smyth Robert tucker 601651 601651 Smyth, Robert, of Marleborough, tucker 0
3813635 1962180 1962180 defendant Cursey Richard bowyer 601651 601651 Cursey, Richard, of Marleborough, bowyer 0
3859347 1976619 1976619 defendant Bagot Henry yeoman or innholder 601651 601651 Bagot, Henry, of Marleborough, yeoman or innholder 1
3887899 1986201 1986201 defendant Pole John baker 601651 601651 Pole, John, of Marleborough, baker 0
3896963 1989200 1989200 defendant Cole Richard mercer 601651 601651 Cole, Richard, of Marleborough, mercer 0
3901863 1990846 1990846 defendant Yong John gent 601651 601651 Yong, John, of Marleborough, gent 0
3917054 1996061 1996061 defendant Collyns William capper 601651 601651 Collyns, William, of Marleborough, capper 0
3946645 2005891 2005891 defendant Smythe alias Barbar Robert innkeeper 601651 601651 Smythe alias Barbar, Robert, of Marleborough, innkeeper 1
3973502 2015302 2015302 defendant Mydwynter alias Kyng William butcher 601651 601651 Mydwynter alias Kyng, William, of Marleborough, butcher 0
3978658 2017113 2017113 defendant Mydwynter alias Kynge William glover 601651 601651 Mydwynter alias Kynge, William, of Marleborough, glover 0
3999895 2024731 2024731 defendant Gaynesford Edward chapman 601651 601651 Gaynesford, Edward, of Marleborough, chapman 0
4000851 2025074 2025074 defendant Tuggye William innholder 601651 601651 Tuggye, William, of Marleborough, yeoman, innholder 0
4052962 2043495 2043495 plaintiff Allen John mercer 601651 601651 Allen, John, of Marleborough, mercer 0
4052964 2043496 2043496 plaintiff Allen John mercer 601651 601651 Allen, John, of Marleborough, mercer 0
4065557 2047972 2047972 plaintiff Hearst Richard yeoman 601651 601651 Hearst, Richard, of Marleborough, yeoman 0
4070875 2049882 2049882 defendant Bayly John mercer 601651 601651 Bayly, John, of Marleborough, mercer 0
4077243 2052146 2052146 defendant Pierce John butcher 601651 601651 Pierce, John, of Marleborough, butcher 0
4096192 2058965 2058965 defendant Bull Richard innholder 601651 601651 Bull, Richard, of Marleborough, innholder 2
4102764 2061289 2061289 defendant Pagett William husbandman 601651 601651 Pagett, William, of Marleborough, husbandman 0
4102766 2061289 2061289 defendant Coltman Thomas shoemaker 601651 601651 Coltman, Thomas, of Marleborough, shoemaker 2
4102767 2061289 2061289 defendant Cheyney Richard   601651 601651 Cheyney, Richard, of Marleborough, woollen draper 3
4147822 2077379 2077379 defendant Moore John gent 601651 601651 Moore, John, of Marleborough, or of London, gent 0
4147823 2077379 2077379 defendant Walton Alexander gent 601651 601651 Walton, Alexander, of Marleborough, or of Weston, Berks, gent 1
4147825 2077379 2077379 defendant Cheyney Thomas gent 601651 601651 Cheyney, Thomas, of Marleborough, or of Hampsted Marshall, Berks, gent 3
4169977 2084993 2084993 defendant Diston or Discon Anthony chandler 601651 601651 Diston or Discon, Anthony, of Marleborough, chandler 0
4213903 2100383 2100383 defendant Pettie John clerk 601651 601651 Pettie, John, of Marleborough, or of Lydyard Treygoose, clerk 0
5320924 2451346 2451346 plaintiff Lang Nicholas fishmonger 601651 601651 Lang, Nicholas, of Marleborough, fishmonger 0
5387779 2471567 2471567 defendant Butler John hosier 601651 601651 Butler, John, of Marleborough, hosier 0
5403367 2476038 2476038 plaintiff Mermyn John mercer 601651 601651 Mermyn, John, of Marleborough, mercer 0
5558387 2522404 2522404 plaintiff Pengryff Henry   601651 601651 Pengryff, Henry, of Marleborough 0
5595257 2533467 2533467 plaintiff Bower John yeoman 601651 601651 Bower, John, of Marleborough, yeoman 0
5595258 2533467 2533467 defendant Trapnell alias Slaughterman Thomas yeoman or butcher 601651 601651 Trapnell alias Slaughterman, Thomas, of Marleborough, yeoman or butcher 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);