names

33 rows where place_id = 595561

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620997 1874125 1874125 defendant Wyth Richard yeoman 595561 595561 Wyth, Richard, of Droytwiche, yeoman 0
3648557 1909941 1909941 defendant Harryes John husbandman 595561 595561 Harryes, John, of Droytwiche, husbandman 0
3810939 1961323 1961323 plaintiff Butler John gent 595561 595561 Butler, John, of Droytwiche, gent 0
3900372 1990360 1990360 defendant Allen John laborer 595561 595561 Allen, John, of Droytwiche, laborer 0
3942500 2004500 2004500 defendant Peynter George smith 595561 595561 Peynter, George, of Droytwiche, smith 1
4008930 2027958 2027958 plaintiff Mowle John yeoman 595561 595561 Mowle, John, of Droytwiche, yeoman 0
4008931 2027958 2027958 defendant Barnard Randolph yeoman 595561 595561 Barnard, Randolph, of Droytwiche, yeoman 0
4008935 2027959 2027959 plaintiff Mowle John yeoman 595561 595561 Mowle, John, of Droytwiche, yeoman 0
4060572 2046183 2046183 defendant Byddell George yeoman 595561 595561 Byddell, George, of Droytwiche, yeoman 2
4071437 2050086 2050086 plaintiff Mowle John yeoman 595561 595561 Mowle, John, of Droytwiche, yeoman 0
4071438 2050086 2050086 plaintiff Baylis John yeoman 595561 595561 Baylis, John, of Droytwiche, yeoman 1
4105399 2062211 2062211 defendant Newport George (legal representative) 595561 595561 Newport, George, of Droytwiche, Worcs esq, administratrix of 0
4105402 2062211 2062211 defendant Howle Thomas yeoman 595561 595561 Howle, Thomas, of Droytwiche, yeoman 3
4151636 2078686 2078686 defendant Daniell John chapman 595561 595561 Daniell, John, of Droytwiche, chapman 1
4161705 2082160 2082160 defendant Costyn Christopher yeoman 595561 595561 Costyn, Christopher, of Droytwiche, yeoman 0
4161706 2082160 2082160 defendant Jaunsey Anthony yeoman 595561 595561 Jaunsey, Anthony, of Droytwiche, yeoman 1
4236503 2108340 2108340 defendant Barrett Robert gent 595561 595561 Barrett, Robert, of Droytwiche, gent 0
4238440 2109059 2109059 defendant Alexander Thomas gent 595561 595561 Alexander, Thomas, of Droytwiche, gent 0
4238443 2109060 2109060 defendant Barrett Thomas (legal representative) 595561 595561 Barrett, Thomas, of Droytwiche, gent, administrator of 0
4238444 2109060 2109060 defendant Barrett Robert gent 595561 595561 Barrett, Robert, of Droytwiche, gent 1
4245045 2111327 2111327 defendant Barrett Robert gent 595561 595561 Barrett, Robert, of Droytwiche, gent 0
4247036 2111983 2111983 defendant Connard George gent 595561 595561 Connard, George, of Droytwiche, gent 1
4373177 2155474 2155474 defendant Howll John gent 595561 595561 Howll, John, of Droytwiche, gent 0
4383704 2159260 2159260 defendant Hewster Richard laborer 595561 595561 Hewster, Richard, of Droytwiche, laborer 0
4383705 2159260 2159260 defendant Hobbs Robert laborer 595561 595561 Hobbs, Robert, of Droytwiche, laborer 1
4383706 2159260 2159260 defendant Bourne John laborer 595561 595561 Bourne, John, of Droytwiche, laborer 2
4383707 2159260 2159260 defendant Hill George laborer 595561 595561 Hill, George, of Droytwiche, laborer 3
4390506 2161446 2161446 defendant Lenche Philip gent 595561 595561 Lenche, Philip, of Droytwiche, gent 0
4390709 2161502 2161502 defendant Crossewell William yeoman 595561 595561 Crossewell, William, of Droytwiche, yeoman 0
4390718 2161505 2161505 defendant Davys John yeoman 595561 595561 Davys, John, of Droytwiche, yeoman 0
4390720 2161506 2161506 defendant Davys John yeoman 595561 595561 Davys, John, of Droytwiche, yeoman 0
4401324 2165039 2165039 defendant Barrett Edward, senior yeoman 595561 595561 Barrett, Edward, senior, of Droytwiche, yeoman 0
4412686 2168835 2168835 defendant Alexander Thomas gent 595561 595561 Alexander, Thomas, of Droytwiche, gent 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);