names

34 rows where place_id = 598009

✎ 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
3630729 1904435 1904435 defendant (not given) Brian husbandman 598009 598009 -, Brian, of Lynby, husbandman 2
3668595 1916129 1916129 defendant Meryng Edward gent 598009 598009 Meryng, Edward, of Lynby, gent 0
3668645 1916137 1916137 defendant Foxe John husbandman 598009 598009 Foxe, John,of Lynby, husbandman 0
3738203 1938162 1938162 plaintiff Styrley Nicholas esq 598009 598009 Styrley, Nicholas, of Lynby, esq 1
3789021 1954379 1954379 plaintiff Styrley Nicholas esq 598009 598009 Styrley, Nicholas, of Lynby, esq 0
3801107 1958265 1958265 defendant Styrley Nicholas esq 598009 598009 Styrley, Nicholas, of Lynby, esq 1
3837928 1969775 1969775 plaintiff Styrley Nicholas   598009 598009 Styrley, Nicholas, of Lynby, knight 0
4541546 2213251 2213251 defendant Maryot Thomas   598009 598009 Maryot, Thomas, of Lynby 0
4567342 2221342 2221342 defendant Maryot Thomas   598009 598009 Maryot, Thomas, of Lynby 2
4633554 2241349 2241349 defendant Lynby Thomas   598009 598009 Lynby, Thomas, of Lynby 0
4640919 2243443 2243443 defendant Wryght William   598009 598009 Wryght, William, of Lynby 0
4712025 2269072 2269072 defendant Blithworth John husbandman 598009 598009 Blithworth, John, of Lynby, husbandman 1
4849971 2311462 2311462 defendant Barbour William husbandman 598009 598009 Barbour, William, of Lynby, husbandman 2
4869327 2317373 2317373 defendant Hunte Robert husbandman 598009 598009 Hunte, Robert, of Lynby, husbandman 3
4894172 2324870 2324870 defendant Turnour Thomas laborer 598009 598009 Turnour, Thomas, of Lynby, laborer 4
4905364 2328268 2328268 defendant Hykelyng John esq 598009 598009 Hykelyng, John, of Lynby, esq 0
4954904 2343423 2343423 defendant Smyth John smith 598009 598009 Smyth, John, of Lynby, smith 0
4968702 2347605 2347605 defendant Milner John miller 598009 598009 Milner, John, of Lynby, miller 3
5007659 2359139 2359139 defendant Grene Henry yeoman 598009 598009 Grene, Henry, of Lynby, yeoman 2
5014963 2361255 2361255 defendant Grene Henry yeoman 598009 598009 Grene, Henry, of Lynby, yeoman 1
5080867 2380769 2380769 defendant Strelley John esq 598009 598009 Strelley, John, of Lynby, esq 0
5125344 2393895 2393895 defendant Ball William husbandman 598009 598009 Ball, William, of Lynby, husbandman 0
5135708 2396954 2396954 defendant Dowesbury John husbandman 598009 598009 Dowesbury, John, of Lynby, husbandman 1
5144107 2399427 2399427 defendant Ball William husbandman 598009 598009 Ball, William, of Lynby, husbandman 0
5144769 2399624 2399624 defendant Strelley John esq 598009 598009 Strelley, John, of Lynby, esq 0
5156543 2403067 2403067 defendant Dowesbury John husbandman 598009 598009 Dowesbury, John, of Lynby, husbandman 0
5164962 2405489 2405489 defendant Ball William husbandman 598009 598009 Ball, William, of Lynby, husbandman 0
5165476 2405647 2405647 defendant Strelley John esq 598009 598009 Strelley, John, of Lynby, esq 0
5226783 2423498 2423498 plaintiff Strelley John esq 598009 598009 Strelley, John, of Lynby, esq 0
5254392 2431502 2431502 defendant Strelley John esq 598009 598009 Strelley, John, of Lynby, esq 1
5307158 2447141 2447141 plaintiff Padley William (legal representative) 598009 598009 Padley, William, of Lynby, executors of 0
5326828 2453097 2453097 defendant Strelley John esq 598009 598009 Strelley, John, of Lynby, esq 0
5355766 2461879 2461879 defendant Bulde Henry yeoman 598009 598009 Bulde, Henry, of Lynby, yeoman 1
5605871 2536728 2536728 plaintiff Strelley Nicholas   598009 598009 Strelley, Nicholas, of Lynby 0

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