names

39 rows where place_id = 759098

✎ 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
4414461 2169425 2169425 defendant Roos Margery de sister & another heiress of Giles 759098 759098 Roos, Margery de, of Hamelak, formerly wife of William, sister & another heiress of Giles 4
4414469 2169426 2169426 defendant Roos Margery de sister & another heiress of Giles 759098 759098 Roos, Margery de, of Hamelak, formerly wife of William, sister & another heiress of Giles 4
4427265 2173359 2173359 plaintiff Roos Margaret de   759098 759098 Roos, Margaret de, of Hamelak, formerly wife of William 0
4427275 2173364 2173364 plaintiff Ros Thomas de   759098 759098 Ros, Thomas de, of Hamelak, son of William 0
4431274 2174541 2174541 defendant Roos Thomas de   759098 759098 Roos, Thomas de, of Hamelak, son of William 0
4433416 2175212 2175212 defendant Roos Thomas de   759098 759098 Roos, Thomas de, of Hamelak, son of William 0
4453240 2186021 2186021 defendant Roos Thomas   759098 759098 Roos, Thomas, of Hamelak 0
4459128 2187902 2187902 plaintiff Roos Thomas de   759098 759098 Roos, Thomas de, of Hamelak 0
4459141 2187905 2187905 plaintiff Roos Thomas   759098 759098 Roos, Thomas, of Hamelak, knight 0
4459146 2187906 2187906 plaintiff Roos Thomas   759098 759098 Roos, Thomas, of Hamelak, knight 0
4459148 2187907 2187907 plaintiff Roos Thomas   759098 759098 Roos, Thomas, of Hamelak, knight 0
4472806 2192166 2192166 defendant Roos William de   759098 759098 Roos, William de, of Hamelak, knight 0
4486064 2196346 2196346 plaintiff Roos de Beatrice   759098 759098 Roos de, Beatrice, of Hamelak, formerly wife of Thomas de Roos, knight 0
4486067 2196347 2196347 plaintiff Roos Beatrice de   759098 759098 Roos, Beatrice de, of Hamelak, formerly wife of Thomas de Roos, knight 0
4486069 2196348 2196348 plaintiff Roos Beatrice de   759098 759098 Roos, Beatrice de, of Hamelak, formerly wife of Thomas de Roos, knight 0
4486106 2196353 2196353 plaintiff Roos Beatrice   759098 759098 Roos, Beatrice, of Hamelak, formerly wife of Thomas de Roos, knight 0
4486112 2196356 2196356 plaintiff Roos Beatrix   759098 759098 Roos, Beatrix, of Hamelak, formerly wife of Thomas de Roos, knight 0
4486119 2196358 2196358 plaintiff Roos William de   759098 759098 Roos, William de, of Hamelak, knight 0
4486121 2196359 2196359 plaintiff Roos William de   759098 759098 Roos, William de, of Hamelak, knight 0
4486123 2196360 2196360 plaintiff Roos William de   759098 759098 Roos, William de, of Hamelak, knight 0
4504406 2201932 2201932 plaintiff Roos William de   759098 759098 Roos, William de, of Hamelak, knight, on his own account 0
4504408 2201933 2201933 plaintiff Roos William de   759098 759098 Roos, William de, of Hamelak, knight, on his own account 0
4504412 2201934 2201934 plaintiff Roos William de   759098 759098 Roos, William de, of Hamelak, knight, on his own account 0
4533677 2210802 2210802 plaintiff Roos Beatrice   759098 759098 Roos, Beatrice, of Hamelak, formerly wife of Thomas de Roos, knight 0
4549197 2215688 2215688 defendant Roos William de   759098 759098 Roos, William de, of Hamelak, knight 0
4563730 2220227 2220227 plaintiff Roos William de   759098 759098 Roos, William de, of Hamelak, knight 0
4563732 2220228 2220228 plaintiff Roos William de   759098 759098 Roos, William de, of Hamelak, knight 0
4563734 2220229 2220229 plaintiff Roos William de   759098 759098 Roos, William de, of Hamelak, knight 0
4563742 2220230 2220230 plaintiff Roos William de   759098 759098 Roos, William de, of Hamelak, knight 0
4627603 2239566 2239566 plaintiff Roos Beatrice   759098 759098 Roos, Beatrice, of Hamelak, formerly wife of Thomas de Roos, knight 0
4627606 2239567 2239567 plaintiff Roos Beatrice   759098 759098 Roos, Beatrice, of Hamelak, formerly wife of Thomas de Roos, knight 0
4627631 2239574 2239574 plaintiff Roos William   759098 759098 Roos, William, of Hamelak, knight 0
4627635 2239575 2239575 plaintiff Roos William   759098 759098 Roos, William, of Hamelak, knight 0
4627638 2239576 2239576 plaintiff Roos William   759098 759098 Roos, William, of Hamelak, knight 0
4646927 2245166 2245166 plaintiff Roos William   759098 759098 Roos, William, of Hamelak 0
4646929 2245167 2245167 plaintiff Roos William   759098 759098 Roos, William, of Hamelak, knight 0
4711089 2268822 2268822 plaintiff Roos William de (legal representative) 759098 759098 Roos, William de, of Hamelak, knight, executors of 0
5620185 2550174 2550174 plaintiff Roos Thomas de   759098 759098 Roos, Thomas de, of Hamelak, knight 0
5620198 2550176 2550176 plaintiff Roos Thomas   759098 759098 Roos, Thomas, of Hamelak, knight 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);