names

28 rows where place_id = 617630

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3720474 1932686 1932686 defendant Stokes William husbandman 617630 617630 Stokes, William, of Welland, husbandman 3
3744615 1940211 1940211 defendant Hyll John husbandman 617630 617630 Hyll, John, of Welland, husbandman 0
3757017 1944174 1944174 defendant Hyll John husbandman 617630 617630 Hyll, John, of Welland, husbandman 0
3928932 2000013 2000013 defendant Patye John laborer 617630 617630 Patye, John, of Welland, laborer 3
3933284 2001427 2001427 defendant Hodges Elizabeth widow 617630 617630 Hodges, Elizabeth, of Welland, widow 2
3933285 2001427 2001427 defendant Hodges Thomas husbandman 617630 617630 Hodges, Thomas, of Welland, husbandman 3
3967133 2013131 2013131 defendant Badger John yeoman 617630 617630 Badger, John, of Welland, yeoman 0
4028788 2034945 2034945 defendant Stokes John yeoman 617630 617630 Stokes, John, of Welland, yeoman 0
4056413 2044679 2044679 defendant Olde Richard husbandman 617630 617630 Olde, Richard, of Welland, husbandman 0
4056414 2044679 2044679 defendant Olde William husbandman 617630 617630 Olde, William, of Welland, husbandman 1
4106657 2062671 2062671 defendant Smythe Edward husbandman 617630 617630 Smythe, Edward, of Welland, husbandman 3
4134971 2072827 2072827 defendant Smythe Edward   617630 617630 Smythe, Edward, of Welland tailor 1
4136531 2073408 2073408 defendant Wilson Richard yeoman 617630 617630 Wilson, Richard, of Welland, yeoman 0
4147700 2077338 2077338 defendant Wilson Richard yeoman 617630 617630 Wilson, Richard, of Welland, yeoman 0
4168487 2084464 2084464 defendant Russell John gent 617630 617630 Russell, John, of Welland, gent 0
4216029 2101101 2101101 defendant Brovyter Thomas clerk 617630 617630 Brovyter, Thomas, of Welland, clerk 0
4289843 2126429 2126429 defendant Allen William yeoman 617630 617630 Allen, William, of Welland, yeoman 1
4289844 2126429 2126429 defendant Warmaston Joan widow 617630 617630 Warmaston, Joan, of Welland, widow 2
4289872 2126438 2126438 defendant Allen William yeoman 617630 617630 Allen, William, of Welland, yeoman 1
4289873 2126438 2126438 defendant Warmaston Joan widow 617630 617630 Warmaston, Joan, of Welland, widow 2
4301639 2130690 2130690 defendant Saunders William husbandman 617630 617630 Saunders, William, of Welland, husbandman 1
4338524 2143226 2143226 defendant Coxe Richaard yeoman 617630 617630 Coxe, Richaard, of Welland, yeoman 1
4369497 2154151 2154151 defendant Greene alias Trovell Richard husbandman 617630 617630 together with Greene alias Trovell, Richard, of Welland, husbandman 2
4369498 2154151 2154151 defendant Weaver alias Stephens John husbandman 617630 617630 Weaver alias Stephens, John, of Welland, husbandman 3
4398631 2164122 2164122 defendant Turner William yeoman 617630 617630 Turner, William, of Welland, yeoman 3
5409474 2477799 2477799 defendant Hanley Thomas gent 617630 617630 Hanley, Thomas, of Welland, gent 0
5409479 2477800 2477800 defendant Hanley Thomas gent 617630 617630 Hanley, Thomas, of Welland, gent 0
5585349 2530485 2530485 defendant Wold John husbandman 617630 617630 Wold, John, of Welland, husbandman 2

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