names

28 rows where place_id = 607795

✎ 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
3670803 1916832 1916832 defendant Tomson William husbandman 607795 607795 Tomson, William, of Morley Swanton, husbandman 0
3670804 1916832 1916832 defendant Tryndyll Thomas husbandman 607795 607795 Tryndyll, Thomas, of Morley Swanton, husbandman 1
3710005 1929437 1929437 defendant Passon John husbandman 607795 607795 Passon, John, of Morley Swanton, husbandman 1
3781742 1952036 1952036 defendant Warde Robert thatcher 607795 607795 Warde, Robert, of Morley Swanton, thatcher 3
3874974 1981853 1981853 plaintiff Doraunt Thomas   607795 607795 Doraunt, Thomas, of Morley Swanton 0
3874999 1981864 1981864 plaintiff Dorrant Thomas   607795 607795 Dorrant, Thomas, of Morley Swanton 0
3875001 1981865 1981865 plaintiff Dorrant Thomas   607795 607795 Dorrant, Thomas, of Morley Swanton 0
3888150 1986292 1986292 plaintiff Doraunt John   607795 607795 Doraunt, John, of Morley Swanton 0
3889651 1986771 1986771 defendant Dey Richard yeoman 607795 607795 Dey, Richard, of Morley Swanton, yeoman 0
3902362 1991023 1991023 plaintiff Durrant John   607795 607795 Durrant, John, of Morley Swanton 0
3919762 1996949 1996949 defendant Vaghan John yeoman 607795 607795 Vaghan, John, of Morley Swanton, yeoman 0
3919763 1996949 1996949 defendant Vaghan Thomas yeoman 607795 607795 Vaghan, Thomas, of Morley Swanton, yeoman 1
3950850 2007361 2007361 defendant Gaston Simon husbandman 607795 607795 Gaston, Simon, of Morley Swanton, husbandman 0
3950916 2007386 2007386 defendant Walton Simon husbandman 607795 607795 Walton, Simon, of Morley Swanton, husbandman 0
3956825 2009458 2009458 defendant Byllye John yeoman 607795 607795 Byllye, John, of Morley Swanton, yeoman 0
4053003 2043505 2043505 defendant Chyld Thomas   607795 607795 Chyld, Thomas, of Morley Swanton, worsted weaver 8
4053004 2043505 2043505 defendant Palmer William husbandman 607795 607795 Palmer, William, of Morley Swanton, husbandman 9
4067681 2048753 2048753 defendant Steward Robert laborer 607795 607795 Steward, Robert, of Morley Swanton, laborer 3
4089180 2056418 2056418 defendant Thurston William   607795 607795 Thurston, William, of Morley Swanton, "boller" 0
4136564 2073421 2073421 defendant Davy Robert weaver 607795 607795 Davy, Robert, of Morley Swanton, weaver 0
4208192 2098418 2098418 defendant Davye Robert weaver 607795 607795 Davye, Robert, of Morley Swanton, weaver 0
4242411 2110458 2110458 defendant Haunde Thomas   607795 607795 Haunde, Thomas, of Morley Swanton smith 3
4242416 2110459 2110459 defendant Haunde Thomas smith 607795 607795 Haunde, Thomas, of Morley Swanton, smith 3
5124495 2393626 2393626 defendant Gery William yeoman 607795 607795 Gery, William, of Morley Swanton, yeoman 0
5145623 2399861 2399861 defendant Davy John husbandman 607795 607795 Davy, John, of Morley Swanton, husbandman 3
5521064 2511414 2511414 defendant Tompson William husbandman 607795 607795 Tompson, William, of Morley Swanton, husbandman 0
5536970 2516049 2516049 defendant Estwyk alias Meller William miller or husbandman 607795 607795 Estwyk alias Meller, William, of Morley Swanton, miller or husbandman 0
5603532 2535985 2535985 defendant Parnell Richard yeoman 607795 607795 Parnell, Richard, of Morley Swanton, yeoman 1

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