names

29 rows where place_id = 626888

✎ 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
3772854 1949204 1949204 defendant Cokke Richard ferryman 626888 626888 Cokke, Richard, of West Lenn, ferryman 0
3782970 1952421 1952421 defendant Palmer Thomas merchant 626888 626888 Palmer, Thomas, of West Lenn St Peter, merchant 0
3782973 1952422 1952422 defendant Palmer Thomas merchant 626888 626888 Palmer, Thomas, of West Lenn St Peter, merchant 0
3802261 1958603 1958603 plaintiff Palmer Thomas   626888 626888 Palmer, Thomas, of West Lenn 0
3817648 1963421 1963421 defendant Bellamy John brewer 626888 626888 Bellamy, John, of West Lenn, brewer 0
3831393 1967709 1967709 plaintiff Guybon Thomas (legal representative) 626888 626888 Guybon, Thomas, of West Lenn, esq, son of Guybon, Gregory, of West Lenn, esq, executors of 0
3831399 1967710 1967710 plaintiff Guybon Thomas (legal representative) 626888 626888 Guybon, Thomas, of West Lenn, esq, son of Guybon, Gregory, of West Lenn, esq, executors of 0
3846801 1972551 1972551 plaintiff Guybon Thomas (legal representative) 626888 626888 Guybon, Thomas, of West Lenn, esq, son of Guybon, Gregory, of West Lenn, esq, executor of 0
4484963 2195996 2195996 defendant Sa--- Alan   626888 626888 Sa---, Alan, of West Lenn 0
4578480 2224758 2224758 defendant Garnette John mariner 626888 626888 Garnette, John, of West Lenn, mariner 0
4583352 2226213 2226213 defendant Betanye John merchant 626888 626888 Betanye, John, of West Lenn, merchant 1
4583356 2226214 2226214 defendant Betanye John merchant 626888 626888 Betanye, John, of West Lenn, merchant 1
4586362 2227149 2227149 defendant Mate Thomas   626888 626888 Mate, Thomas, of West Lenn 0
4637366 2242484 2242484 defendant Outlawe Robert mariner 626888 626888 Outlawe, Robert, of West Lenn, mariner 1
4666822 2255349 2255349 defendant Welle Richard yeoman 626888 626888 Welle, Richard, of West Lenn, yeoman 3
4707119 2267610 2267610 defendant Walsyngham William husbandman 626888 626888 Walsyngham, William, of West Lenn, husbandman 2
4730688 2274796 2274796 defendant Leper Robert yeoman 626888 626888 Leper, Robert, of West Lenn, yeoman 0
4733214 2275569 2275569 defendant Daddy William husbandman 626888 626888 Daddy, William, of West Lenn, husbandman 1
4740898 2277851 2277851 defendant Shepherd Peter fisher 626888 626888 Shepherd, Peter, of West Lenn, fisher 4
4740915 2277852 2277852 defendant Shepherd Peter fisher 626888 626888 Shepherd, Peter, of West Lenn, fisher 4
4816897 2301388 2301388 defendant Knout Peter chaplain 626888 626888 Knout, Peter, of West Lenn, chaplain 2
4819314 2302117 2302117 defendant Gebon John husbandman 626888 626888 Gebon, John, of West Lenn, husbandman 0
4881444 2321097 2321097 defendant Flete John gent 626888 626888 Flete, John, of West Lenn, gent 0
4963350 2345946 2345946 defendant Herman William merchant 626888 626888 Herman, William, of West Lenn, merchant 0
5013404 2360755 2360755 defendant Gybon John (legal representative) 626888 626888 Gybon, John, of West Lenn, gent, executors of 0
5258444 2432757 2432757 plaintiff Guybon Gregory gent 626888 626888 Guybon, Gregory, of West Lenn, gent 0
5262856 2434124 2434124 defendant Owtelawe Richard mariner 626888 626888 Owtelawe, Richard, of West Lenn, mariner 1
5262859 2434125 2434125 defendant Owtelawe Richard mariner 626888 626888 Owtelawe, Richard, of West Lenn, mariner 1
5495156 2503448 2503448 plaintiff Gybon Gregory (legal representative) 626888 626888 Gybon, Gregory, of West Lenn, gent, executors of 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);