names

48 rows where place_id = 589110

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596574 1866562 1866562 defendant Symond John husbandman 589110 589110 Symond, John, of Westley, husbandman 1
3628672 1903842 1903842 defendant Dullyngham Thomas husbandman 589110 589110 Dullyngham, Thomas, of Westley, husbandman 1
3678975 1919494 1919494 plaintiff Page John   589110 589110 Page, John, of Westley 0
3678977 1919495 1919495 plaintiff Page John   589110 589110 Page, John, of Westley 0
3708645 1929002 1929002 plaintiff Page John   589110 589110 Page, John, of Westley 0
3708647 1929003 1929003 plaintiff Page John gent 589110 589110 Page, John, of Westley, gent 0
3708649 1929004 1929004 plaintiff Page John gent 589110 589110 Page, John, of Westley, gent 0
3723230 1933536 1933536 plaintiff Page John   589110 589110 Page, John, of Westley 0
3739058 1938423 1938423 plaintiff Page John   589110 589110 Page, John, of Westley 0
3786149 1953460 1953460 defendant Fox Martin husbandman 589110 589110 Fox, Martin, of Westley, husbandman 1
3844700 1971883 1971883 defendant Hatton Robert yeoman 589110 589110 Hatton, Robert, of Westley, yeoman 1
3844704 1971884 1971884 defendant Hatton Robert yeoman 589110 589110 Hatton, Robert, of Westley, yeoman 1
3892086 1987605 1987605 defendant Page John gent 589110 589110 Page, John, of Westley, gent 0
3924903 1998648 1998648 defendant Adams Henry husbandman 589110 589110 Adams, Henry, of Westley, husbandman 0
3959911 2010562 2010562 plaintiff Sowthworth John gent 589110 589110 Sowthworth, John, of Westley, gent 0
4053034 2043516 2043516 plaintiff Allyngton Richard gent 589110 589110 Allyngton, Richard, of Westley, gent 0
4053037 2043517 2043517 plaintiff Allyngton Richard gent 589110 589110 Allyngton, Richard, of Westley, gent 0
4057571 2045087 2045087 defendant Hawsted William   589110 589110 Hawsted, William, of Westley, shepherd, 0
4063473 2047227 2047227 defendant Magnoll Gilbert clerk 589110 589110 Magnoll, Gilbert, of Westley, clerk 0
4099620 2060190 2060190 defendant Burges Richard cooper 589110 589110 Burges, Richard, of Westley, cooper 1
4220318 2102614 2102614 defendant Rabon Geoffrey yeoman 589110 589110 Rabon, Geoffrey, of Westley, yeoman 1
4228689 2105519 2105519 defendant Glover Richard yeoman 589110 589110 Glover, Richard, of Westley, yeoman 2
4237195 2108595 2108595 defendant Glover Richard yeoman 589110 589110 Glover, Richard, of Westley, yeoman 2
4309408 2133450 2133450 defendant Folkes William (legal representative) 589110 589110 Folkes, William, of Westley, administrator of 0
4309409 2133450 2133450 defendant Folkes Simon yeoman 589110 589110 Folkes, Simon, of Westley, yeoman 1
4330451 2140482 2140482 defendant Clerke Edward yeoman 589110 589110 Clerke, Edward, of Westley, yeoman 1
4334112 2141687 2141687 defendant ap Robert John yeoman 589110 589110 ap Robert, John, of Westley, yeoman 2
4336818 2142605 2142605 defendant Burges John cooper 589110 589110 Burges, John, of Westley, cooper 3
4360079 2150768 2150768 defendant Burges John cooper 589110 589110 Burges, John, of Westley, cooper 2
4411258 2168352 2168352 defendant Clarke alias Turner Edward yeoman 589110 589110 Clarke alias Turner, Edward, of Westley, yeoman 0
4774448 2287992 2287992 defendant Snode Richard   589110 589110 Snode, Richard, of Westley, plough man 0
4842475 2309182 2309182 defendant Bate John gent 589110 589110 Bate, John, of Westley, gent 0
4855759 2313176 2313176 defendant Bate John gent 589110 589110 Bate, John, of Westley, gent 0
4982748 2351750 2351750 defendant Fyssher Hugh baker 589110 589110 Fyssher, Hugh, of Westley, baker 0
5293133 2442973 2442973 defendant Asplon John yeoman 589110 589110 Asplon, John, of Westley, yeoman 2
5310736 2448246 2448246 defendant Cok Richard husbandman 589110 589110 Cok, Richard, of Westley, husbandman 0
5328114 2453478 2453478 defendant Levyrton Thomas husbandman 589110 589110 Levyrton, Thomas, of Westley, husbandman 2
5382874 2470168 2470168 defendant Cok John, senior yeoman 589110 589110 Cok, John, senior, of Westley, yeoman 4
5382875 2470168 2470168 defendant Mouer Thomas husbandman 589110 589110 Mouer, Thomas, of Westley, husbandman 5
5393597 2473230 2473230 defendant Cok John, senior yeoman 589110 589110 Cok, John, senior, of Westley, yeoman 4
5393598 2473230 2473230 defendant Miller Thomas husbandman 589110 589110 Miller, Thomas, of Westley, husbandman 5
5406766 2477000 2477000 defendant Bok John yeoman 589110 589110 Bok, John, of Westley, yeoman 4
5406767 2477000 2477000 defendant Meller Thomas husbandman 589110 589110 Meller, Thomas, of Westley, husbandman 5
5422431 2481656 2481656 defendant Stanton Richard husbandman 589110 589110 Stanton, Richard, of Westley, husbandman 4
5530733 2514130 2514130 defendant Smyth William, senior husbandman 589110 589110 Smyth, William, senior, of Westley, husbandman 0
5530734 2514130 2514130 defendant Smyth William, junior husbandman 589110 589110 Smyth, William, junior, of Westley, husbandman 1
5530735 2514130 2514130 defendant Smyth Thomas tailor 589110 589110 Smyth, Thomas, of Westley, tailor 2
5565137 2524389 2524389 defendant Maltewade Stephen husbandman 589110 589110 Maltewade, Stephen, of Westley, husbandman 3

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);