names

37 rows where place_id = 591252

✎ 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
3603846 1868876 1868876 defendant Grey William husbandman 591252 591252 Grey, William, of Sybton, husbandman 0
3606105 1869578 1869578 defendant Grey William husbandman 591252 591252 Grey, William, of Sybton, husbandman 0
3606110 1869579 1869579 defendant Grey William husbandman 591252 591252 Grey, William, of Sybton, husbandman 0
3608763 1870405 1870405 defendant Hawes Robert   591252 591252 Hawes, Robert, of Sybton, sieve maker 1
3676877 1918807 1918807 defendant Snellyng John husbandman 591252 591252 Snellyng, John, of Sybton, husbandman 0
3725029 1934112 1934112 defendant Barker John clerk 591252 591252 Barker, John, of Sybton, clerk 0
3725031 1934112 1934112 defendant Palgrave Edmund laborer 591252 591252 Palgrave, Edmund, of Sybton, laborer 2
3765190 1946777 1946777 defendant Churche John husbandman 591252 591252 Churche, John, of Sybton, husbandman 0
3829463 1967098 1967098 defendant Guybon Thomas carpenter 591252 591252 Guybon, Thomas, of Sybton, carpenter 0
3864077 1978169 1978169 defendant Snellyng Ralph laborer 591252 591252 Snellyng, Ralph, of Sybton, laborer 1
3864078 1978169 1978169 defendant Johnson William husbandman 591252 591252 Johnson, William, of Sybton, husbandman 2
3873281 1981281 1981281 defendant Snellyng John husbandman 591252 591252 Snellyng, John, of Sybton, husbandman 0
3873282 1981281 1981281 defendant Snellyng Ralph husbandman 591252 591252 Snellyng, Ralph, of Sybton, husbandman 1
3880619 1983781 1983781 defendant Snellyng John husbandman 591252 591252 Snellyng, John, of Sybton, husbandman 0
3880620 1983781 1983781 defendant Snellyng Ralph husbandman 591252 591252 Snellyng, Ralph, of Sybton, husbandman 1
3881059 1983936 1983936 plaintiff Rous Edmund   591252 591252 Rous, Edmund, of Sybton 1
3891438 1987404 1987404 plaintiff Lawghter geoffrey   591252 591252 Lawghter, geoffrey, of Sybton 0
3893494 1988051 1988051 defendant Corbett Hugh gent 591252 591252 Corbett, Hugh, of Sybton, gent 0
3965655 2012602 2012602 defendant Cloughe Thomas yeoman 591252 591252 Cloughe, Thomas, of Sybton, yeoman 1
3965658 2012603 2012603 defendant Clowghe Thomas yeoman 591252 591252 Clowghe, Thomas, of Sybton, yeoman 1
3967059 2013105 2013105 defendant Aldred John yeoman 591252 591252 Aldred, John, of Sybton, yeoman 0
3982587 2018543 2018543 defendant Scoldyng Robert merchant 591252 591252 Scoldyng, Robert, of Sybton, merchant 7
3996722 2023591 2023591 defendant Danford Ralph husbandman 591252 591252 Danford, Ralph, of Sybton, husbandman 1
4041476 2039442 2039442 plaintiff Newporte Edmund gent 591252 591252 Newporte, Edmund, of Sybton, gent 0
4074798 2051286 2051286 defendant ap Howell Rice carpenter 591252 591252 ap Howell, Rice, of Sybton, carpenter 0
4592337 2228951 2228951 defendant Curteys Thomas   591252 591252 Curteys, Thomas, of Sybton 0
4840369 2308532 2308532 defendant Baker John butcher 591252 591252 Baker, John, of Sybton, butcher 1
4878387 2320188 2320188 defendant Ufford John   591252 591252 Ufford, John, of Sybton, parchment maker 1
4937075 2337966 2337966 defendant Butte John yeoman 591252 591252 Butte, John, of Sybton, yeoman 0
5110382 2389439 2389439 defendant Hose Richard carpenter 591252 591252 Hose, Richard, of Sybton, carpenter 0
5252352 2430846 2430846 plaintiff Banyard Robert gent 591252 591252 Banyard, Robert, of Sybton, gent 0
5319593 2450953 2450953 defendant Godwyn William husbandman 591252 591252 Godwyn, William, of Sybton, husbandman 0
5320573 2451242 2451242 defendant Butte John shoemaker 591252 591252 Butte, John, of Sybton, shoemaker 3
5537453 2516209 2516209 defendant Snellyng John husbandman 591252 591252 Snellyng, John, of Sybton, husbandman 0
5541452 2517440 2517440 defendant Snellyng John laborer 591252 591252 Snellyng, John, of Sybton, laborer 0
5569086 2525507 2525507 defendant Barker Robert yeoman 591252 591252 Barker, Robert, of Sybton, yeoman 1
5601153 2535251 2535251 defendant Alcote John tailor 591252 591252 (Alcote, John, of Sybton, tailor 4

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