names

51 rows where place_id = 592300

✎ 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
3607261 1869935 1869935 defendant Flouredewe John husbandman 592300 592300 Flouredewe, John, of Hetherset, husbandman 1
3629940 1904221 1904221 defendant Rede Richard husbandman 592300 592300 Rede, Richard, of Hetherset, husbandman 0
3633436 1905270 1905270 defendant Marchaunt John yeoman 592300 592300 Marchaunt, John, of Hetherset, yeoman 0
3633437 1905270 1905270 defendant Balles Cornelius laborer 592300 592300 Balles, Cornelius, of Hetherset, laborer 1
3633440 1905271 1905271 defendant Pytman Stephen husbandman 592300 592300 Pytman, Stephen, of Hetherset, husbandman 0
3654578 1911695 1911695 plaintiff Bakon Robert yeoman 592300 592300 Bakon, Robert, of Hetherset, yeoman 1
3655773 1912066 1912066 defendant Fowler John husbandman 592300 592300 Fowler, John, of Hetherset, husbandman 0
3657965 1912743 1912743 defendant Fowler John husbandman 592300 592300 Fowler, John, of Hetherset, husbandman 0
3668357 1916049 1916049 defendant Starys Thomas husbandman 592300 592300 Starys, Thomas, of Hetherset, husbandman 6
3684186 1921190 1921190 defendant Wylkenson John husbandman 592300 592300 Wylkenson, John, of Hetherset, husbandman 4
3736023 1937508 1937508 defendant Hale George chaplain 592300 592300 Hale, George, of Hetherset, chaplain 0
3749000 1941618 1941618 defendant Frosdyk William husbandman 592300 592300 Frosdyk, William, of Hetherset, husbandman 2
3758161 1944539 1944539 defendant Cusshyn Emma widow 592300 592300 Cusshyn, Emma, of Hetherset, widow 2
3781816 1952057 1952057 defendant Sarys Thomas husbandman 592300 592300 Sarys, Thomas, of Hetherset, husbandman 4
3781905 1952088 1952088 defendant Sarys Thomas husbandman 592300 592300 Sarys, Thomas, of Hetherset, husbandman 0
3781906 1952088 1952088 defendant Rede William husbandman 592300 592300 Rede, William, of Hetherset, husbandman 1
3781907 1952088 1952088 defendant Thomson Gerard husbandman 592300 592300 Thomson, Gerard, of Hetherset, husbandman 2
3781908 1952088 1952088 defendant Frosdyke William husbandman 592300 592300 Frosdyke, William, of Hetherset, husbandman 3
3789833 1954649 1954649 defendant Eventrell Robert husbandman 592300 592300 Eventrell, Robert, of Hetherset, husbandman 0
3789834 1954649 1954649 defendant Rede John husbandman 592300 592300 Rede, John, of Hetherset, husbandman 1
3808902 1960663 1960663 defendant Walker William tailor 592300 592300 Walker, William, of Hetherset, tailor 1
3817645 1963420 1963420 defendant Goldlyn Thomas husbandman 592300 592300 Goldlyn, Thomas, of Hetherset, husbandman 2
3822462 1964925 1964925 defendant Goldespynk Thomas husbandman 592300 592300 Goldespynk, Thomas, of Hetherset, husbandman 1
3823599 1965279 1965279 defendant Reede William husbandman 592300 592300 Reede, William, of Hetherset, husbandman 0
3835331 1968989 1968989 defendant Seman Edward husbandman 592300 592300 Seman, Edward, of Hetherset, husbandman 2
3853082 1974582 1974582 defendant Lowes Thomas brickmaker 592300 592300 Lowes, Thomas, of Hetherset, brickmaker 1
3853084 1974582 1974582 defendant Brygtyff or Brygtyss John husbandman 592300 592300 Brygtyff or Brygtyss, John, of Hetherset, husbandman 3
3853085 1974582 1974582 defendant Rowlond Christopher   592300 592300 Rowlond, Christopher, of Hetherset, brick maker 4
3858575 1976353 1976353 defendant Deynes William husbandman 592300 592300 Deynes, William, of Hetherset, husbandman 0
3870701 1980445 1980445 defendant Leves Thomas brickmaker 592300 592300 Leves, Thomas, of Hetherset, brickmaker 0
3870702 1980445 1980445 defendant Leves Robert brickmaker 592300 592300 Leves, Robert, of Hetherset, brickmaker 1
3879786 1983493 1983493 defendant Rowland Christopher brickburner 592300 592300 Rowland, Christopher, of Hetherset, brickburner 4
3969076 2013799 2013799 defendant Flowewe Christopher gent 592300 592300 Flowewe, Christopher, of Hetherset, gent 4
3998603 2024238 2024238 plaintiff Flowerdewe Christopher gent 592300 592300 Flowerdewe, Christopher, of Hetherset, gent 0
5328699 2453664 2453664 defendant Scot William husbandman 592300 592300 Scot, William, of Hetherset, husbandman 0
5417424 2480130 2480130 defendant Goldspynk John husbandman 592300 592300 Goldspynk, John, of Hetherset, husbandman 11
5434783 2485340 2485340 defendant Goldspynk John husbandman 592300 592300 Goldspynk, John, of Hetherset, husbandman 10
5450082 2489911 2489911 defendant Goldspynk John husbandman 592300 592300 Goldspynk, John, of Hetherset, husbandman 7
5518743 2510698 2510698 defendant Smetherst Oliver yeoman 592300 592300 Smetherst, Oliver, of Hetherset, yeoman 0
5518744 2510698 2510698 defendant Lyngar Nicholas yeoman 592300 592300 Lyngar, Nicholas, of Hetherset, yeoman 1
5518746 2510699 2510699 defendant Smethurst Oliver yeoman 592300 592300 Smethurst, Oliver, of Hetherset, yeoman 0
5518747 2510699 2510699 defendant Lyngar Nicholas yeoman 592300 592300 Lyngar, Nicholas, of Hetherset, yeoman 1
5530177 2513944 2513944 defendant Smethurst Robert clerk 592300 592300 Smethurst, Robert, of Hetherset, clerk 0
5548501 2519599 2519599 defendant Bettys William smith 592300 592300 Bettys, William, of Hetherset, smith 0
5559051 2522607 2522607 defendant Bett William smith 592300 592300 Bett, William, of Hetherset, smith 0
5559057 2522609 2522609 defendant Bettys William smith 592300 592300 Bettys, William, of Hetherset, smith 2
5573158 2526700 2526700 defendant Cartar James clerk 592300 592300 Cartar, James, of Hetherset, clerk 4
5573160 2526700 2526700 defendant Smythurst James clerk 592300 592300 (Smythurst, James, of Hetherset, clerk 6
5573161 2526700 2526700 defendant Randolff Humphrey yeoman 592300 592300 Randolff, Humphrey, of Hetherset, yeoman 7
5581075 2529154 2529154 defendant Bett William smith 592300 592300 Bett, William, of Hetherset, smith 1
5588136 2531297 2531297 defendant Randolff Humphrey yeoman 592300 592300 Randolff, Humphrey, of Hetherset, yeoman 6

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