names

11 rows where place_id = 764913

✎ 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
4511107 2203925 2203925 defendant atte Cros John mercer 764913 764913 atte Cros, John, of Fakynham, mercer 1
5068764 2377153 2377153 defendant Clerke Thomas tailor 764913 764913 Clerke, Thomas, of Fakynham, tailor 1
5068765 2377153 2377153 defendant Broune John butcher 764913 764913 Broune, John, of Fakynham, butcher 2
5068768 2377154 2377154 defendant Clerke Thomas tailor 764913 764913 Clerke, Thomas, of Fakynham, tailor 1
5068769 2377154 2377154 defendant Broune John butcher 764913 764913 Broune, John, of Fakynham, butcher 2
5313843 2449165 2449165 defendant Hare William husbandman 764913 764913 Hare, William, of Fakynham, husbandman 10
5313844 2449165 2449165 defendant Harpour William husbandman 764913 764913 Harpour, William, of Fakynham, husbandman 11
5384757 2470725 2470725 defendant Stacy Robert husbandman 764913 764913 Stacy, Robert, of Fakynham, husbandman 2
5396774 2474170 2474170 defendant Stacy Robert   764913 764913 Stacy, Robert, of Fakynham 2
5410019 2477962 2477962 defendant Stacy Robert husbandman 764913 764913 Stacy, Robert, of Fakynham, husbandman 2
5568389 2525301 2525301 defendant Harwyn John mercer 764913 764913 Harwyn, John, of Fakynham, mercer 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);