names

29 rows where place_id = 666080

✎ 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
3979549 2017444 2017444 defendant Woodhouse George gent 666080 666080 Woodhouse, George, of Tylney, Norf, gent 0
3986560 2019934 2019934 defendant Woodhouse George gent 666080 666080 Woodhouse, George, of Tylney, Norf, gent 1
4009620 2028210 2028210 defendant Gelde Christopher yeoman 666080 666080 (Gelde, Christopher, of Tylney, Norf, yeoman 1
4009629 2028213 2028213 plaintiff Nicholl Richard esq 666080 666080 Nicholl, Richard, of Tylney, Norf, esq 0
4009874 2028308 2028308 plaintiff Nycholl Richard esq 666080 666080 Nycholl, Richard, of Tylney, Norf, esq 0
4018774 2031446 2031446 defendant Nicholl Richard esq 666080 666080 Nicholl, Richard, of Tylney, Norf, esq 0
4122692 2068410 2068410 defendant Hares William yeoman 666080 666080 Hares, William, of Tylney, Norf, yeoman 0
4173896 2086325 2086325 defendant Radham Richard husbandman 666080 666080 Radham, Richard, of Tylney, Norf, husbandman 3
4197150 2094554 2094554 defendant Haires William yeoman 666080 666080 Haires, William, of Tylney, Norf, yeoman 1
4197210 2094574 2094574 defendant Hares William yeoman 666080 666080 Hares, William, of Tylney, Norf, yeoman 0
4250687 2113209 2113209 defendant Hares Christopher husbandman 666080 666080 Hares, Christopher, of Tylney, Norf, husbandman 0
4998649 2356480 2356480 defendant Leveryche Thomas husbandman 666080 666080 Leveryche, Thomas, of Tylney, Norf, husbandman 1
4998657 2356481 2356481 defendant Lewrych Thomas husbandman 666080 666080 Lewrych, Thomas, of Tylney, Norf, husbandman 0
5008650 2359424 2359424 defendant Blower John yeoman 666080 666080 Blower, John, of Tylney, Norf, yeoman 7
5009618 2359692 2359692 defendant Mane Richard yeoman 666080 666080 (Mane, Richard, of Tylney, Norf, yeoman 1
5010506 2359949 2359949 defendant Bolwere John husbandman 666080 666080 Bolwere, John, of Tylney, Norf, husbandman 3
5137236 2397406 2397406 defendant Curson Thomas gent 666080 666080 Curson, Thomas, of Tylney, Norf, gent 0
5231415 2424774 2424774 defendant Mower Robert husbandman 666080 666080 Mower, Robert, of Tylney, Norf, husbandman 2
5244125 2428473 2428473 defendant Burton John   666080 666080 Burton, John, of Tylney, Norf 0
5294823 2443471 2443471 defendant Bulwer Robert husbandman 666080 666080 Bulwer, Robert, of Tylney, Norf, husbandman 0
5340932 2457361 2457361 defendant Baldyng Robert (legal representative) 666080 666080 Baldyng, Robert, of Tylney, Norf, husbandman, executors of 0
5340939 2457362 2457362 defendant Nutteman Richard husbandman 666080 666080 Nutteman, Richard, of Tylney, Norf, husbandman 3
5365113 2464760 2464760 defendant Curson Stephen gent 666080 666080 Curson, Stephen, of Tylney, Norf, gent 0
5375608 2467959 2467959 defendant Clerke John husbandman 666080 666080 Clerke, John, of Tylney, Norf, husbandman 0
5436463 2485840 2485840 defendant Nutman Richard yeoman 666080 666080 Nutman, Richard, of Tylney, Norf, yeoman 0
5509015 2507676 2507676 defendant Segrave Gilbert gent 666080 666080 Segrave, Gilbert, of Tylney, Norf, gent 0
5532077 2514575 2514575 defendant Potkyn Thomas clerk 666080 666080 Potkyn, Thomas, of Tylney, Norf, clerk 0
5553939 2521192 2521192 defendant Lany Thomas husbandman 666080 666080 Lany, Thomas, of Tylney, Norf, husbandman 2
5565068 2524370 2524370 defendant Baldyng William yeoman 666080 666080 Baldyng, William, of Tylney, Norf, yeoman 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);