names

25 rows where place_id = 611702

✎ 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
3689713 1922939 1922939 defendant Eyre Margery widow 611702 611702 Eyre, Margery, of Ingmanthorp, widow 1
3694930 1924624 1924624 defendant Rose Robert esq 611702 611702 Rose, Robert, of Ingmanthorp, esq 0
3704245 1927624 1927624 defendant Eyre Margery widow 611702 611702 Eyre, Margery, of Ingmanthorp, widow 1
4427267 2173360 2173360 plaintiff Roos Robert de   611702 611702 Roos, Robert de, of Ingmanthorp 0
4427269 2173361 2173361 plaintiff Roos Robert de   611702 611702 Roos, Robert de, of Ingmanthorp 0
4433599 2175273 2175273 defendant Ros Robert   611702 611702 Ros, Robert, of Ingmanthorp, knight 0
4447778 2184233 2184233 defendant Roos Robert   611702 611702 Roos, Robert, of Ingmanthorp, knight 0
4459114 2187895 2187895 plaintiff Roos Robert de   611702 611702 Roos, Robert de, of Ingmanthorp, knight 0
4459116 2187896 2187896 plaintiff Roos Robert de   611702 611702 Roos, Robert de, of Ingmanthorp, knight 0
4459118 2187897 2187897 plaintiff Roos Robert de   611702 611702 Roos, Robert de, of Ingmanthorp, knight 0
4459120 2187898 2187898 plaintiff Roos Robert de   611702 611702 Roos, Robert de, of Ingmanthorp, knight 0
4459122 2187899 2187899 plaintiff Roos Robert de   611702 611702 Roos, Robert de, of Ingmanthorp, knight, on his own account 0
4459124 2187900 2187900 plaintiff Roos Robert de   611702 611702 Roos, Robert de, of Ingmanthorp, knight, on his own account 0
4459126 2187901 2187901 plaintiff Roos Robert de   611702 611702 Roos, Robert de, of Ingmanthorp, knight, on his own account 0
4471496 2191743 2191743 defendant Roos Robert   611702 611702 Roos, Robert, of Ingmanthorp, son of Robert 0
5005490 2358509 2358509 defendant Roos Robert   611702 611702 Roos, Robert, of Ingmanthorp, knight 0
5005492 2358510 2358510 defendant Roos Robert   611702 611702 Roos, Robert, of Ingmanthorp, knight 0
5308155 2447466 2447466 plaintiff Roos Robert   611702 611702 Roos, Robert, of Ingmanthorp 0
5308157 2447467 2447467 plaintiff Roos Robert   611702 611702 Roos, Robert, of Ingmanthorp 0
5369375 2466019 2466019 defendant Fletcher William husbandman 611702 611702 Fletcher, William, of Ingmanthorp, husbandman 0
5387372 2471459 2471459 defendant Fleccher William husbandman 611702 611702 Fleccher, William, of Ingmanthorp, husbandman 0
5399826 2475043 2475043 defendant Fletcher William husbandman 611702 611702 Fletcher, William, of Ingmanthorp, husbandman 0
5412823 2478784 2478784 defendant Fleccher William husbandman 611702 611702 Fleccher, William, of Ingmanthorp, husbandman 0
5458177 2492352 2492352 defendant Fleccher William husbandman 611702 611702 Fleccher, William, of Ingmanthorp, husbandman 0
5617134 2549173 2549173 defendant Roos Robert   611702 611702 Roos, Robert, of Ingmanthorp, 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);