names

15 rows where place_id = 611854

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3690366 1923149 1923149 defendant Tayllour Thomas husbandman 611854 611854 Tayllour, Thomas, of Shustoke, husbandman 4
3691690 1923560 1923560 defendant Tayllour Thomas husbandman 611854 611854 Tayllour, Thomas, of Shustoke, husbandman 0
3705371 1927968 1927968 defendant Sutton Henry clerk 611854 611854 Sutton, Henry, of Shustoke, clerk 0
3806012 1959811 1959811 defendant Sutton Henry clerk 611854 611854 (Sutton, Henry, of Shustoke, clerk 2
3852877 1974512 1974512 defendant Persett Richard husbandman 611854 611854 Persett, Richard, of Shustoke, husbandman 0
4489705 2197496 2197496 plaintiff Tredeven William   611854 611854 Tredeven, William, of Shustoke 0
4513640 2204694 2204694 defendant Abell Ivan   611854 611854 Abell, Ivan, of Shustoke 0
4595579 2229879 2229879 defendant atte Forge Henry   611854 611854 atte Forge, Henry, of Shustoke 0
4672336 2256996 2256996 defendant More William husbandman 611854 611854 More, William, of Shustoke, husbandman 2
4694607 2263810 2263810 defendant More William de husbandman 611854 611854 More, William de, of Shustoke, husbandman 0
4839625 2308308 2308308 defendant Irelond Alexander husbandman 611854 611854 Irelond, Alexander, of Shustoke, husbandman 7
4938713 2338493 2338493 defendant Irelond Alexander husbandman 611854 611854 Irelond, Alexander, of Shustoke, husbandman 0
5411304 2478339 2478339 defendant Lubley Gilbert tailor 611854 611854 Lubley, Gilbert, of Shustoke, tailor 1
5622677 2551024 2551024 plaintiff Ferour Alexander   611854 611854 Ferour, Alexander, of Shustoke 2
5623061 2551150 2551150 defendant Ferour Alexander   611854 611854 Ferour, Alexander, of Shustoke 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);