names

17 rows where place_id = 770635

✎ 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
4569748 2222122 2222122 defendant Walker (illegible)   770635 770635 Walker, _, of Little Cotes 2
4588089 2227673 2227673 plaintiff Keleby John   770635 770635 Keleby, John, of Little Cotes, vicar 0
4613701 2235297 2235297 plaintiff del See John   770635 770635 del See, John, of Little Cotes 0
4685994 2261206 2261206 plaintiff See Brian de   770635 770635 See, Brian de, of Little Cotes 0
4685996 2261207 2261207 plaintiff See Brian de   770635 770635 See, Brian de, of Little Cotes 0
4719273 2271376 2271376 plaintiff See Brian de   770635 770635 See, Brian de, of Little Cotes 1
4723401 2272629 2272629 plaintiff del See Brian   770635 770635 del See, Brian, of Little Cotes 0
4725647 2273306 2273306 defendant Cotes John esq 770635 770635 Cotes, John, of Little Cotes, esq 3
4743928 2278751 2278751 plaintiff del See Brain   770635 770635 del See, Brain, of Little Cotes 0
4743930 2278752 2278752 plaintiff del See Brian   770635 770635 del See, Brian, of Little Cotes 0
4751481 2280915 2280915 defendant Cotes Robert gent 770635 770635 Cotes, Robert, of Little Cotes, gent 1
4774605 2288044 2288044 defendant Thornton Robert   770635 770635 Thornton, Robert, of Little Cotes, gent, formerly burgess of Grymesby 0
5153470 2402169 2402169 defendant Mistirton John clerk & vicar 770635 770635 Mistirton, John, of Little Cotes, clerk & vicar 0
5177990 2409269 2409269 defendant Mistirton John clerk 770635 770635 Mistirton, John, of Little Cotes, clerk 0
5184453 2411191 2411191 defendant Betnefe Thomas husbandman 770635 770635 Betnefe, Thomas, of Little Cotes, husbandman 1
5196322 2414675 2414675 defendant See Stephen de le gent 770635 770635 See, Stephen de le, of Little Cotes, gent 0
5209587 2418545 2418545 defendant See Stephen de le gent 770635 770635 See, Stephen de le, of Little Cotes, gent 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);