names

22 rows where place_id = 631798

✎ 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
3762784 1945998 1945998 defendant Scope William   631798 631798 Scope, William, of Remerston, hurdle maker 2
3802785 1958766 1958766 defendant Hunte alias Tendell Thomas husbandman 631798 631798 Hunte alias Tendell, Thomas, of Remerston, husbandman 3
3831088 1967608 1967608 defendant Hunt Thomas husbandman 631798 631798 Hunt, Thomas, of Remerston, husbandman 0
3853937 1974869 1974869 defendant Dey William husbandman 631798 631798 Dey, William, of Remerston, husbandman 0
3853938 1974869 1974869 defendant Dey Thomas husbandman 631798 631798 Dey, Thomas, of Remerston, husbandman 1
3878164 1982942 1982942 defendant Tungate Thomas husbandman 631798 631798 Tungate, Thomas, of remerston, husbandman 7
4026116 2033985 2033985 defendant Raven Thomas husbandman 631798 631798 Raven, Thomas, of Remerston, husbandman 1
4029865 2035324 2035324 plaintiff Deye Ruben singleman 631798 631798 Deye, Ruben, of Remerston, singleman 0
4029866 2035324 2035324 defendant Wayt Thomas clerk 631798 631798 Wayt, Thomas, of Remerston, clerk 0
4242597 2110516 2110516 defendant Talwyn Walter husbandman 631798 631798 Talwyn, Walter, of Remerston, husbandman 0
4242598 2110516 2110516 defendant Talwyn Thomas singleman 631798 631798 Talwyn, Thomas, of Remerston, husbandman, singleman 1
4267290 2118695 2118695 defendant Moye John yeoman 631798 631798 Moye, John, of Remerston, yeoman 1
4272363 2120329 2120329 defendant Tollewen John husbandman 631798 631798 Tollewen, John, of Remerston, husbandman 0
4272364 2120329 2120329 defendant Tollewen Thomas yeoman 631798 631798 Tollewen, Thomas, of Remerston, yeoman 1
4313061 2134689 2134689 defendant Talwyn John husbandman 631798 631798 Talwyn, John, of Remerston, husbandman 0
4313062 2134689 2134689 defendant Talwyn Walter husbandman 631798 631798 Talwyn, Walter, of Remerston, husbandman 1
4313063 2134689 2134689 defendant Talwyn Thomas singleman 631798 631798 Talwyn, Thomas, of Remerston, yeoman, singleman 2
4390672 2161493 2161493 defendant Talwyn Thomas smith 631798 631798 Talwyn, Thomas, of Remerston, smith 3
4688008 2261820 2261820 defendant Tilly John chaplain 631798 631798 Tilly, John, of Remerston, chaplain 0
5008154 2359268 2359268 defendant Mustall Richard laborer 631798 631798 Mustall, Richard, of Remerston, laborer 2
5551850 2520586 2520586 defendant Savage Robert alias Roger husbandman 631798 631798 Savage, Robert alias Roger, of Remerston, husbandman 0
5595650 2533562 2533562 defendant Wroo John husbandman 631798 631798 Wroo, John, of Remerston, husbandman 3

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