names

24 rows where place_id = 594467

✎ 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
3616231 1872717 1872717 defendant Relia Ciprian   594467 594467 Relia, Ciprian, of Oxford, scholar 1
3735522 1937348 1937348 defendant Frost Walter   594467 594467 Frost, Walter, of Oxford, scholar 1
3735527 1937348 1937348 defendant Fenton Peter   594467 594467 Fenton, Peter, of Oxford, scholar 6
3978591 2017089 2017089 plaintiff Michell Thomas gent 594467 594467 Michell, Thomas, of Oxford, scholar, or of Mylborne St Andrew, Dorset, gent 0
4788796 2292552 2292552 defendant Waryn William   594467 594467 Waryn, William, of Oxford, scholar 0
4912093 2330285 2330285 defendant Crakynthorp Thomas   594467 594467 Crakynthorp, Thomas, of Oxford, scholar 0
4916497 2331664 2331664 defendant Holes William   594467 594467 Holes, William, of Oxford, scholar 0
4944804 2340363 2340363 defendant Clithe Richard   594467 594467 Clithe, Richard, of Oxford, scholar 1
4971097 2348298 2348298 defendant Necton Roger clerk 594467 594467 Necton, Roger, of Oxford, scholar, clerk 0
5134936 2396719 2396719 defendant Makanam Baoidmot   594467 594467 Makanam, Baoidmot, of Oxford, scholar 3
5157905 2403438 2403438 plaintiff Berne Richard kinsman of John Petresfeld 594467 594467 (Berne, Richard, of Oxford, scholar, kinsman of John Petresfeld 1
5157913 2403439 2403439 plaintiff Berne Richard kinsman of John Petresfeld 594467 594467 (Berne, Richard, of Oxford, scholar, kinsman of John Petresfeld 1
5173655 2407994 2407994 plaintiff Berne Richard kinsman of John Petresfeld 594467 594467 (Berne, Richard, of Oxford, scholar, kinsman of John Petresfeld 1
5173663 2407995 2407995 plaintiff Berne Richard kinsman of John Petresfeld 594467 594467 (Berne, Richard, of Oxford, scholar, kinsman of John Petresfeld 1
5173673 2407996 2407996 plaintiff Berne Richard kinsman of John Petresfeld 594467 594467 (Berne, Richard, of Oxford, scholar, kinsman of John Petresfeld 1
5193718 2413892 2413892 plaintiff Berne Richard kinsman of John Petresfeld 594467 594467 (Berne, Richard, of Oxford, scholar, kinsman of John Petresfeld 1
5193724 2413893 2413893 plaintiff Berne Richard kinsman of John Petresfeld 594467 594467 (Berne, Richard, of Oxford, scholar, kinsman of John Petresfeld 1
5193730 2413894 2413894 plaintiff Berne Richard kinsman of John Petresfeld 594467 594467 (Berne, Richard, of Oxford, scholar, kinsman of John Petresfeld 1
5193736 2413895 2413895 plaintiff Berne Richard kinsman of John Petresfeld 594467 594467 (Berne, Richard, of Oxford, scholar, kinsman of John Petresfeld 1
5193743 2413896 2413896 plaintiff Berne Richard kinsman of John Petresfeld 594467 594467 (Berne, Richard, of Oxford, scholar, kinsman of John Petresfeld 1
5208321 2418163 2418163 plaintiff Berne Richard kinsman of John Petresfeld 594467 594467 (Berne, Richard, of Oxford, scholar, kinsman of John Petresfeld 1
5208327 2418164 2418164 plaintiff Berne Richard kinsman of John 594467 594467 (Berne, Richard, of Oxford, scholar, kinsman of John 1
5257339 2432418 2432418 defendant Attewell John   594467 594467 Attewell, John, of Oxford, scholar 0
5329257 2453829 2453829 defendant Druffeld Thomas   594467 594467 Druffeld, Thomas, of Oxford, scholar 2

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