names

64 rows where place_id = 591419

✎ 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
3604359 1869030 1869030 defendant Rakour William husbandman 591419 591419 Rakour, William, of Brysley, husbandman 0
3626335 1903095 1903095 plaintiff Athowe Christopher singleman 591419 591419 Athowe, Christopher, of Brysley, singleman 0
3631506 1904669 1904669 defendant Athoo John butcher 591419 591419 Athoo, John, of Brysley, butcher 0
3645411 1908973 1908973 defendant Smyth William husbandman 591419 591419 Smyth, William, of Brysley, husbandman 1
3667487 1915772 1915772 defendant Grey Thomas smith 591419 591419 Grey, Thomas, of Brysley, smith 4
3681880 1920438 1920438 defendant Gogney Edmund yeoman 591419 591419 Gogney, Edmund, of Brysley, yeoman 0
3698321 1925694 1925694 defendant Smyth William   591419 591419 Smyth, William, of Brysley, worsted weaver 0
3742706 1939591 1939591 defendant Smyth William   591419 591419 Smyth, William, of Brysley, worsted weaver 1
3742796 1939602 1939602 defendant Smyth William   591419 591419 Smyth, William, of Brysley, worsted weaver 1
3766337 1947125 1947125 defendant Gogney Edmund yeoman 591419 591419 Gogney, Edmund, of Brysley, yeoman 0
3789233 1954451 1954451 plaintiff Taverner John   591419 591419 Taverner, John, of Brysley, of North Elman 0
3794697 1956218 1956218 plaintiff Taverner John   591419 591419 Taverner, John, of Brysley 1
3800907 1958193 1958193 defendant Gogney Edmund yeoman 591419 591419 Gogney, Edmund, of Brysley, yeoman 0
3836153 1969221 1969221 defendant Taverner John innkeeper 591419 591419 Taverner, John, of Brysley, innkeeper 0
3841496 1970920 1970920 defendant Girlyng Christine widow 591419 591419 Girlyng, Christine, of Brysley, widow 2
3910657 1993881 1993881 defendant Gray Henry smith 591419 591419 Gray, Henry, of Brysley, smith 2
3923355 1998119 1998119 defendant Overton Thomas laborer 591419 591419 Overton, Thomas, of Brysley, laborer 0
3923356 1998119 1998119 defendant Athoo Christpher husbandman 591419 591419 Athoo, Christpher, of Brysley, husbandman 1
3923357 1998119 1998119 defendant Patryk John laborer 591419 591419 Patryk, John, of Brysley, laborer 2
3935200 2002082 2002082 defendant Flynt William clerk 591419 591419 Flynt, William, of Brysley, clerk 0
3935201 2002082 2002082 defendant Hempston William laborer 591419 591419 Hempston, William, of Brysley, laborer 1
3935202 2002082 2002082 defendant Flynt Richard laborer 591419 591419 Flynt, Richard, of Brysley, laborer 2
3935203 2002082 2002082 defendant Flynt Margaret single woman 591419 591419 Flynt, Margaret, of Brysley, single woman 3
3935204 2002082 2002082 defendant Ledeate Thomas laborer 591419 591419 Ledeate, Thomas, of Brysley, laborer 4
3944468 2005166 2005166 plaintiff Bartylmew Isabel (legal representative) 591419 591419 Bartylmew, Isabel, of Brysley, executors of 0
3944471 2005166 2005166 defendant Athowe Christopher butcher 591419 591419 Athowe, Christopher, of Brysley, butcher 0
3944475 2005167 2005167 defendant Foxe Nicholas yeoman 591419 591419 Foxe, Nicholas, of Brysley, yeoman 0
3959142 2010284 2010284 defendant Foxe Nicholas husbandman 591419 591419 Foxe, Nicholas, of Brysley, husbandman 0
3964557 2012206 2012206 plaintiff Athowe Christopher   591419 591419 Athowe, Christopher, of Brysley 0
3964559 2012207 2012207 plaintiff Athowe Christopher   591419 591419 Athowe, Christopher, of Brysley 0
3999880 2024725 2024725 defendant Browne Christopher husbandman or singleman 591419 591419 Browne, Christopher, of Brysley, husbandman or singleman 0
4058172 2045306 2045306 defendant Gogney Simon gent 591419 591419 Gogney, Simon, of Brysley, gent 0
4142814 2075662 2075662 defendant Wood William yeoman 591419 591419 Wood, William, of Brysley, yeoman 0
4826280 2304254 2304254 plaintiff Wattes Edmund   591419 591419 Wattes, Edmund, of Brysley 0
4909916 2329623 2329623 defendant Proston Adam yeoman 591419 591419 Proston, Adam, of Brysley, yeoman 0
5023690 2363836 2363836 defendant Holley Robert yeoman 591419 591419 Holley, Robert, of Brysley, yeoman 1
5032764 2366473 2366473 defendant Copeldyk William gent 591419 591419 Copeldyk, William, of Brysley, gent 0
5126175 2394137 2394137 defendant Seyguyour Alice widow 591419 591419 Seyguyour, Alice, of Brysley, formerly wife of William Seyguyour, widow 0
5149037 2400848 2400848 defendant Holley Christine widow 591419 591419 Holley, Christine, of Brysley, widow 0
5149039 2400848 2400848 defendant Grene Thomas yeoman 591419 591419 Grene, Thomas, of Brysley, yeoman 2
5219666 2421483 2421483 defendant Whytefote John yeoman 591419 591419 Whytefote, John, of Brysley, yeoman 6
5319626 2450965 2450965 defendant Shortwode John yeoman 591419 591419 Shortwode, John, of Brysley, yeoman 2
5342521 2457861 2457861 defendant Deynys Thomas carpenter 591419 591419 Deynys, Thomas, of Brysley, carpenter 1
5348226 2459592 2459592 defendant Asshele Richard smith 591419 591419 Asshele, Richard, of Brysley, smith 2
5389012 2471911 2471911 defendant Chylde John husbandman 591419 591419 Chylde, John, of Brysley, husbandman 2
5389013 2471911 2471911 defendant Est John husbandman 591419 591419 Est, John, of Brysley, husbandman 3
5419123 2480647 2480647 defendant Sylvester Thomas husbandman 591419 591419 Sylvester, Thomas, of Brysley, husbandman 0
5515840 2509801 2509801 defendant Sylvester Thomas husbandman 591419 591419 Sylvester, Thomas, of Brysley, husbandman 0
5531042 2514224 2514224 defendant Sylvester Thomas husbandman 591419 591419 Sylvester, Thomas, of Brysley, husbandman 0
5531046 2514224 2514224 defendant Est John husbandman 591419 591419 Est, John, of Brysley, husbandman 4
5531394 2514340 2514340 defendant Sylvester William husbandman 591419 591419 Sylvester, William, of Brysley, husbandman 0
5531439 2514358 2514358 defendant Sylvester Thomas husbandman 591419 591419 Sylvester, Thomas, of Brysley, husbandman 0
5531737 2514464 2514464 defendant Est John husbandman 591419 591419 Est, John, of Brysley, husbandman 2
5554655 2521388 2521388 defendant Sylvester Thomas husbandman 591419 591419 Sylvester, Thomas, of Brysley, husbandman 3
5554662 2521389 2521389 defendant Sylvester Thomas husbandman 591419 591419 Sylvester, Thomas, of Brysley, husbandman 2
5561054 2523202 2523202 defendant Parson Thomas butcher 591419 591419 Parson, Thomas, of Brysley, butcher 0
5563394 2523892 2523892 plaintiff Athoo John   591419 591419 Athoo, John, of Brysley 0
5563396 2523893 2523893 plaintiff Athowe Christopher   591419 591419 Athowe, Christopher, of Brysley, single man 0
5567263 2525002 2525002 defendant Goggeney Edmund yeoman 591419 591419 Goggeney, Edmund, of Brysley, yeoman 0
5567265 2525003 2525003 defendant Gogney Edmund husbandman 591419 591419 Gogney, Edmund, of Brysley, husbandman 0
5568996 2525483 2525483 defendant Sylvester Thomas husbandman 591419 591419 Sylvester, Thomas, of Brysley, husbandman 3
5573978 2526953 2526953 defendant Est John husbandman 591419 591419 (Est, John, of Brysley, husbandman 1
5580483 2528983 2528983 defendant Gogney Edmund yeoman 591419 591419 Gogney, Edmund, of Brysley, yeoman 0
5589111 2531603 2531603 defendant Est John husbandman 591419 591419 Est, John, of Brysley, husbandman 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);