names

19 rows where place_id = 757870

✎ 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
4427472 2173429 2173429 plaintiff Salteby William de   757870 757870 Salteby, William de, of Bliclyng, parson 0
4427474 2173430 2173430 plaintiff Salteby William de   757870 757870 Salteby, William de, of Bliclyng, parson 0
4449287 2184724 2184724 defendant Kenyng John   757870 757870 Kenyng, John, of Bliclyng 0
4452239 2185684 2185684 defendant Beverach Reginald   757870 757870 Beverach, Reginald, of Bliclyng 0
4454007 2186268 2186268 defendant Brayd John   757870 757870 Brayd, John, of Bliclyng 4
4887240 2322848 2322848 plaintiff Walour Richard   757870 757870 Walour, Richard, of Bliclyng 0
4905016 2328175 2328175 defendant Multon John miller 757870 757870 Multon, John, of Bliclyng, miller 0
5002863 2357741 2357741 plaintiff Osmond John   757870 757870 Osmond, John, of Bliclyng 0
5044402 2369956 2369956 defendant Porter John yeoman 757870 757870 Porter, John, of Bliclyng, yeoman 4
5073577 2378581 2378581 plaintiff Walour Richard draper 757870 757870 Walour, Richard, of Bliclyng, draper 0
5119262 2392062 2392062 plaintiff Philipp Robert   757870 757870 Philipp, Robert, of Bliclyng 4
5119268 2392063 2392063 plaintiff Philipp Robert   757870 757870 Philipp, Robert, of Bliclyng 4
5119274 2392064 2392064 plaintiff Philipp Robert   757870 757870 Philipp, Robert, of Bliclyng 4
5119284 2392065 2392065 plaintiff Philipp Robert   757870 757870 Philipp, Robert, of Bliclyng 4
5119293 2392066 2392066 plaintiff Philipp Robert   757870 757870 Philipp, Robert, of Bliclyng 4
5119299 2392067 2392067 plaintiff Philipp Robert   757870 757870 Philipp, Robert, of Bliclyng 4
5329909 2454017 2454017 plaintiff Barker Thomas   757870 757870 Barker, Thomas, of Bliclyng 0
5329910 2454017 2454017 plaintiff Aleyns Robert   757870 757870 Aleyns, Robert, of Bliclyng 1
5623740 2551362 2551362 defendant de Multon William miller 757870 757870 de Multon, William, of Bliclyng, miller 1

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