names

23 rows where place_id = 665935

✎ 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
3667250 1915692 1915692 plaintiff Wilford Edmund (legal representative) 665935 665935 Wilford, Edmund, of Oxford University, clerk, executors of 0
3978919 2017212 2017212 plaintiff Morrysse Humphrey yeoman 665935 665935 Morrysse, Humphrey, of Oxford University, yeoman 0
4005291 2026672 2026672 plaintiff Key Thomas   665935 665935 Key, Thomas, of Oxford University 0
4064274 2047498 2047498 plaintiff Grigge John gent 665935 665935 Grigge, John, of Oxford University, gent 0
4086073 2055290 2055290 defendant Garth William Master of Arts 665935 665935 Garth, William, of Oxford University, clerk, Master of Arts 0
4086077 2055292 2055292 defendant Garth William Master of Arts 665935 665935 Garth, William, of Oxford University, clerk, Master of Arts 0
4187185 2091010 2091010 defendant Gibbons Moranus or Morgan gent 665935 665935 Gibbons, Moranus or Morgan, of Oxford University, gent 1
4187186 2091010 2091010 defendant Hewes James gent 665935 665935 Hewes, James, of Oxford University, gent 2
4187187 2091010 2091010 defendant Prouting or Pronting Thomas gent 665935 665935 Prouting or Pronting, Thomas, of Oxford University, gent 3
4187190 2091011 2091011 defendant Pryce Edward gent 665935 665935 Pryce, Edward, of Oxford University, gent 1
4187191 2091011 2091011 defendant Gyles Morgan clerk 665935 665935 Gyles, Morgan, of Oxford University, clerk 2
4187192 2091011 2091011 defendant Davies Walter clerk 665935 665935 Davies, Walter, of Oxford University, clerk 3
4223012 2103539 2103539 defendant Vaughan David Master of Arts 665935 665935 Vaughan, David, of Oxford University, Master of Arts 1
4258102 2115680 2115680 defendant Pudsey John Master of Arts 665935 665935 Pudsey, John, of Oxford University, Master of Arts 2
4270170 2119608 2119608 defendant Pudsey Richard Master of Arts 665935 665935 Pudsey, Richard, of Oxford University, Master of Arts 3
4295960 2128654 2128654 defendant Manwaringe Randolph gent 665935 665935 Manwaringe, Randolph, of Oxford University, gent 0
4295961 2128654 2128654 defendant Frogge John yeoman 665935 665935 Frogge, John, of Oxford University, yeoman 1
4349236 2146994 2146994 defendant Estmonde John   665935 665935 Estmonde, John, of Oxford University, Doctor of Law 0
4373367 2155542 2155542 defendant Estmonde John   665935 665935 Estmonde, John, of Oxford University, Doctor of Law 0
4377744 2157112 2157112 defendant Leeche William gent 665935 665935 Leeche, William, of Oxford University, gent 1
4403848 2165856 2165856 defendant Greteakers alias Ratle Thomas gent 665935 665935 Greteakers alias Ratle, Thomas, of Oxford University, gent 0
4520033 2206595 2206595 defendant Melton Geoffrey clerk 665935 665935 Melton, Geoffrey, of Oxford University, clerk 0
5369248 2465981 2465981 defendant Chipnam John gent 665935 665935 Chipnam, John, of Oxford University, gent 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);