names

44 rows where place_id = 597097

✎ 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
3627279 1903378 1903378 defendant Hobley John tanner 597097 597097 Hobley, John, of Stonley, tanner 0
3632552 1904999 1904999 plaintiff Hogges Thomas yeoman 597097 597097 Hogges, Thomas, of Stonley, yeoman 0
3632553 1904999 1904999 plaintiff Androwes Robert fuller 597097 597097 Androwes, Robert, of Stonley, fuller 1
3649755 1910287 1910287 plaintiff Raves John (legal representative) 597097 597097 Raves, John, of Stonley, executors of 0
3785266 1953177 1953177 defendant Jakson Robert   597097 597097 Jakson, Robert, of Stonley, wire drawer 0
3882181 1984297 1984297 defendant Bradford John yeoman 597097 597097 Bradford, John, of Stonley, yeoman 1
3911086 1994034 1994034 defendant Slough William   597097 597097 Slough, William, of Stonley, wheelwright 0
3917353 1996162 1996162 defendant Slough William   597097 597097 Slough, William, of Stonley, wheel wright 2
3917397 1996176 1996176 defendant Lewys Henry husbandman 597097 597097 Lewys, Henry, of Stonley, husbandman 5
4070157 2049616 2049616 defendant Melodye Richard husbandman 597097 597097 Melodye, Richard, of Stonley, husbandman 3
4225661 2104441 2104441 defendant Goslowe Oliver husbandman 597097 597097 Goslowe, Oliver, of Stonley, husbandman 0
4225662 2104441 2104441 defendant Morton Richard husbandman 597097 597097 Morton, Richard, of Stonley, husbandman 1
4225663 2104441 2104441 defendant Bull Henry husbandman 597097 597097 Bull, Henry, of Stonley, husbandman 2
4225664 2104441 2104441 defendant Willowes Gamalias husbandman 597097 597097 Willowes, Gamalias, of Stonley, husbandman 3
4225665 2104441 2104441 defendant Lyleford Henry husbandman 597097 597097 Lyleford, Henry, of Stonley, husbandman 4
4368667 2153843 2153843 defendant Gregorye John gent 597097 597097 Gregorye, John, of Stonley, gent 1
4462299 2188906 2188906 defendant Pype Thomas   597097 597097 Pype, Thomas, of Stonley, abbot 0
4490984 2197874 2197874 defendant Clere John   597097 597097 Clere, John, of Stonley 0
4543858 2213978 2213978 defendant Clerk Richard   597097 597097 Clerk, Richard, of Stonley 0
4545790 2214612 2214612 defendant Hathewey Geoffrey   597097 597097 Hathewey, Geoffrey, of Stonley 0
4647405 2245298 2245298 defendant Undrewode John   597097 597097 Undrewode, John, of Stonley 3
4711616 2268961 2268961 defendant Gody Thomas barber 597097 597097 Gody, Thomas, of Stonley, barber 1
4804892 2297734 2297734 defendant Freman Richard husbandman 597097 597097 Freman, Richard, of Stonley, husbandman 0
4954778 2343385 2343385 plaintiff Stokton John   597097 597097 Stokton, John, of Stonley 0
4972246 2348643 2348643 defendant Baxter John, junior husbandman 597097 597097 Baxter, John, junior, of Stonley, husbandman 3
5045226 2370200 2370200 defendant Gosse Henry   597097 597097 Gosse, Henry, of Stonley, Hunts, prior 0
5048051 2371040 2371040 defendant Gosse Henry   597097 597097 Gosse, Henry, of Stonley, Hunts, prior 0
5062247 2375268 2375268 defendant Payn Richard yeoman 597097 597097 Payn, Richard, of Stonley, yeoman 0
5087356 2382684 2382684 defendant Hall Henry husbandman 597097 597097 Hall, Henry, of Stonley, husbandman 0
5087357 2382684 2382684 defendant Hall William husbandman 597097 597097 Hall, William, of Stonley, husbandman 1
5239836 2427226 2427226 defendant Stratton Thomas gent 597097 597097 Stratton, Thomas, of Stonley, gent 4
5258781 2432865 2432865 defendant Payn Richard husbandman 597097 597097 Payn, Richard, of Stonley, husbandman 0
5274700 2437677 2437677 defendant Stokton John husbandman 597097 597097 Stokton, John, of Stonley, husbandman 0
5274703 2437678 2437678 defendant Stokton John husbandman 597097 597097 Stokton, John, of Stonley, husbandman 0
5292241 2442730 2442730 defendant Stokton John husbandman 597097 597097 Stokton, John, of Stonley, husbandman 0
5292243 2442731 2442731 defendant Stokton John husbandman 597097 597097 Stokton, John, of Stonley, or of Chesterton, husbandman 0
5327605 2453332 2453332 defendant Horlle or Hortle William yeoman 597097 597097 Horlle or Hortle, William, of Stonley, yeoman 0
5336993 2456136 2456136 defendant Stokton John husbandman 597097 597097 Stokton, John, of Stonley, husbandman 3
5370393 2466326 2466326 defendant Barker Thomas smith 597097 597097 Barker, Thomas, of Stonley, smith 1
5389594 2472085 2472085 defendant Hobbeley John   597097 597097 Hobbeley, John, of Stonley 0
5592119 2532526 2532526 defendant Tomson John barker 597097 597097 Tomson, John, of Stonley, fuller, Tomson, Richard, of Asshewe, barker 0
5592121 2532526 2532526 defendant Aclet Richard fuller 597097 597097 Aclet, Richard, of Stonley, fuller 2
5592122 2532526 2532526 defendant Robynson John fuller 597097 597097 Robynson, John, of Stonley, fuller 3
5599069 2534590 2534590 defendant Hobbeley John tanner 597097 597097 Hobbeley, John, of Stonley, tanner 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);