names

21 rows where place_id = 835193

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5013854 2360903 2360903 defendant Sharp John (legal representative) 835193 835193 Sharp, John, of Tofte juxta Boston, executors of 0
5013855 2360903 2360903 defendant Sharp Alice widow 835193 835193 (Sharp, Alice, of Tofte juxta Boston, widow 1
5013856 2360903 2360903 defendant Sharp Thomas husbandman 835193 835193 Sharp, Thomas, of Tofte juxta Boston, husbandman 2
5026296 2364579 2364579 defendant Sipsay William husbandman 835193 835193 Sipsay, William, of Tofte juxta Boston, husbandman 0
5026297 2364579 2364579 defendant Holand John husbandman 835193 835193 Holand, John, of Tofte juxta Boston, husbandman 1
5054053 2372804 2372804 defendant Moldson Stephen husbandman 835193 835193 Moldson, Stephen, of Tofte juxta Boston, husbandman 0
5054054 2372804 2372804 defendant Deynes Richard husbandman 835193 835193 Deynes, Richard, of Tofte juxta Boston, husbandman 1
5054956 2373044 2373044 defendant Walnote John, senior husbandman 835193 835193 Walnote, John, senior, of Tofte juxta Boston, husbandman 0
5054957 2373044 2373044 defendant Sharp William husbandman 835193 835193 Sharp, William, of Tofte juxta Boston, husbandman 1
5101665 2386909 2386909 defendant Sybsay Robert husbandman 835193 835193 Sybsay, Robert, of Tofte juxta Boston, husbandman 3
5101666 2386909 2386909 defendant Sybsay Thomas husbandman 835193 835193 Sybsay, Thomas, of Tofte juxta Boston, husbandman 4
5101667 2386909 2386909 defendant Carter John husbandman 835193 835193 Carter, John, of Tofte juxta Boston, husbandman 5
5102790 2387233 2387233 defendant Braunston John husbandman 835193 835193 together with Braunston, John, of Tofte juxta Boston, husbandman 2
5320852 2451325 2451325 defendant Warner Richard husbandman 835193 835193 Warner, Richard, of Tofte juxta Boston, husbandman 0
5320853 2451325 2451325 defendant Carter John husbandman 835193 835193 Carter, John, of Tofte juxta Boston, husbandman 1
5320854 2451325 2451325 defendant Walnut John husbandman 835193 835193 Walnut, John, of Tofte juxta Boston, husbandman 2
5320855 2451325 2451325 defendant Neweland John husbandman 835193 835193 Neweland, John, of Tofte juxta Boston, husbandman 3
5320856 2451325 2451325 defendant Shavelok John husbandman 835193 835193 Shavelok, John, of Tofte juxta Boston, husbandman 4
5320862 2451325 2451325 defendant Rabdyk John husbandman 835193 835193 Rabdyk, John, of Tofte juxta Boston, husbandman 10
5320863 2451325 2451325 defendant Broun John husbandman 835193 835193 Broun, John, of Tofte juxta Boston, husbandman 11
5320864 2451325 2451325 defendant Coke John husbandman 835193 835193 Coke, John, of Tofte juxta Boston, husbandman 12

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