names

18 rows where place_id = 594302

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3615501 1872490 1872490 defendant Anne or Aune William esq 594302 594302 Anne or Aune, William, of North Aston, Oxon, esq 0
3639111 1907054 1907054 defendant Anne or Aime John esq 594302 594302 Anne or Aime, John, of North Aston, Oxon, esq 0
3639113 1907055 1907055 defendant Anne John   594302 594302 Anne, John, of North Aston, Oxon 0
3733107 1936581 1936581 defendant Lovet Thomas (legal representative) 594302 594302 Lovet, Thomas, of North Aston, Oxon, esq, administrator of 0
3847608 1972821 1972821 defendant Aune John esq 594302 594302 Aune, John, of North Aston, Oxon, esq 0
3979012 2017249 2017249 defendant Kendall William gent 594302 594302 Kendall, William, of North Aston, Oxon, gent 1
4005139 2026620 2026620 plaintiff Kendall William (legal representative) 594302 594302 Kendall, William, of North Aston, Oxon, yeoman, executors of 0
4005144 2026621 2026621 plaintiff Kendall William (legal representative) 594302 594302 Kendall, William, of North Aston, Oxon, yeoman, executors of 0
4343360 2144950 2144950 defendant Lee Edward gent 594302 594302 Lee, Edward, of North Aston, Oxon, gent 0
4367067 2153276 2153276 defendant Lee Edward gent 594302 594302 Lee, Edward, of North Aston, Oxon, gent 0
4787456 2292147 2292147 defendant Colles John husbandman 594302 594302 Colles, John, of North Aston, Oxon, husbandman 0
4883021 2321613 2321613 defendant Bye Richard husbandman 594302 594302 Bye, Richard, of North Aston, Oxon, husbandman 2
5065742 2376277 2376277 defendant Somerton William esq 594302 594302 Somerton, William, of North Aston, Oxon, esq 0
5147058 2400278 2400278 defendant Collys Thomas husbandman 594302 594302 Collys, Thomas, of North Aston, Oxon, husbandman 0
5211983 2419242 2419242 defendant Somerton Thomas gent 594302 594302 Somerton, Thomas, of North Aston, Oxon, gent 1
5211986 2419243 2419243 defendant Somerton Thomas gent 594302 594302 Somerton, Thomas, of North Aston, Oxon, gent 1
5226070 2423295 2423295 defendant Anne or Aime Joh gent 594302 594302 Anne or Aime, Joh, of North Aston, Oxon, gent 0
5554223 2521276 2521276 defendant Anne William esq 594302 594302 Anne, William, of North Aston, Oxon, esq 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);