names

23 rows where place_id = 614280

✎ 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
3702841 1927161 1927161 defendant Skypwith Thomas gent 614280 614280 Skypwith, Thomas, of Utterby, gent 0
3940040 2003686 2003686 defendant Barton John gent 614280 614280 Barton, John, of Utterby, gent 0
3976701 2016418 2016418 defendant Skipwyth John (legal representative) 614280 614280 Skipwyth, John, of Utterby, esq, executrix of 15
3978579 2017085 2017085 defendant Skypwith Eleanor widow 614280 614280 Skypwith, Eleanor, of Utterby, widow 1
4096632 2059122 2059122 defendant Berrye Richard gent 614280 614280 Berrye, Richard, of Utterby, gent 2
4186628 2090807 2090807 defendant Kelke William yeoman 614280 614280 Kelke, William, of Utterby, yeoman 3
4238775 2109180 2109180 defendant Skipwith Samuel gent 614280 614280 Skipwith, Samuel, of Utterby, gent 0
4360294 2150851 2150851 defendant Berye Richard gent 614280 614280 Berye, Richard, of Utterby, gent 0
4407069 2166923 2166923 plaintiff Skipwith Samuel gent 614280 614280 Skipwith, Samuel, of Utterby, gent 0
4864527 2315878 2315878 plaintiff Forman Robert   614280 614280 Forman, Robert, of Utterby 0
4871540 2318068 2318068 defendant Smyth William smith 614280 614280 Smyth, William, of Utterby, smith 0
4942311 2339584 2339584 defendant Kelstern John husbandman 614280 614280 Kelstern, John, of Utterby, husbandman 8
4967963 2347359 2347359 plaintiff Forman Robert   614280 614280 Forman, Robert, of Utterby 0
4967966 2347360 2347360 plaintiff Forman Robert   614280 614280 Forman, Robert, of Utterby 0
4967970 2347361 2347361 plaintiff Forman Robert   614280 614280 Forman, Robert, of Utterby 0
5112510 2390041 2390041 defendant Eman Richard yeoman 614280 614280 Eman, Richard, of Utterby, yeoman 9
5230569 2424554 2424554 defendant Ason John husbandman 614280 614280 Ason, John, of Utterby, husbandman 0
5246966 2429279 2429279 plaintiff Skypwyth Patrick   614280 614280 Skypwyth, Patrick, of Utterby, administrators of 0
5348778 2459743 2459743 defendant Sixhyll William husbandman 614280 614280 Sixhyll, William, of Utterby, husbandman 2
5348782 2459744 2459744 defendant Sixhyll William husbandman 614280 614280 Sixhyll, William, of Utterby, husbandman 2
5575078 2527291 2527291 defendant Rede Thomas husbandman 614280 614280 Rede, Thomas, of Utterby, husbandman 0
5590546 2532011 2532011 defendant Lokkyng William husbandman 614280 614280 Lokkyng, William, of Utterby, husbandman 0
5590547 2532011 2532011 defendant Bewham Richard husbandman 614280 614280 Bewham, Richard, of Utterby, husbandman 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);