names

15 rows where place_id = 620702

✎ 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
3737150 1937853 1937853 plaintiff Lapworth Edward husbandman 620702 620702 Lapworth, Edward, of Ethorp, husbandman 0
3737151 1937853 1937853 plaintiff Lapworth Thomas husbandman 620702 620702 Lapworth, Thomas, of Ethorp, husbandman 1
4413280 2169028 2169028 plaintiff Baillif Thomas le   620702 620702 Baillif, Thomas le, of Ethorp 0
4413281 2169028 2169028 defendant Peyte Simon de   620702 620702 Peyte, Simon de, of Ethorp 0
4419213 2170885 2170885 plaintiff Baillif Thomas le   620702 620702 Baillif, Thomas le, of Ethorp 0
4419214 2170885 2170885 defendant Peyto Simon de   620702 620702 Peyto, Simon de, of Ethorp 0
4535418 2211349 2211349 defendant Stokton Richard   620702 620702 Stokton, Richard, of Ethorp 0
4583387 2226226 2226226 defendant Gobell Thomas   620702 620702 Gobell, Thomas, of Ethorp 1
4705311 2267032 2267032 defendant Gopill Thomas husbandman 620702 620702 Gopill, Thomas, of Ethorp, husbandman 2
4708591 2268060 2268060 defendant Cays John husbandman 620702 620702 Cays, John, of Ethorp, husbandman 0
4732135 2275234 2275234 defendant Mulward Henry miller 620702 620702 Mulward, Henry, of Ethorp, miller 1
4974472 2349327 2349327 defendant Burdet William husbandman 620702 620702 Burdet, William, of Ethorp, husbandman 0
5011866 2360322 2360322 defendant Russell Thomas milner 620702 620702 Russell, Thomas, of Ethorp, milner 0
5614636 2548374 2548374 defendant Berford Thomas   620702 620702 Berford, Thomas, of Ethorp 0
5632138 2554076 2554076 defendant Lappeworth Henry miller 620702 620702 Lappeworth, Henry, of Ethorp, miller 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);