names

24 rows where place_id = 763638

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4498995 2200327 2200327 defendant Baret John   763638 763638 Baret, John, of Mynstreworth 0
4510811 2203839 2203839 defendant Shaftesbury Walter   763638 763638 Shaftesbury, Walter, of Mynstreworth 1
4525256 2208238 2208238 defendant Goolde Walter   763638 763638 Goolde, Walter, of Mynstreworth 0
4585890 2227009 2227009 plaintiff Hathewy Richard   763638 763638 Hathewy, Richard, of Mynstreworth 0
4596943 2230286 2230286 plaintiff Saunsom John   763638 763638 Saunsom, John, of Mynstreworth 0
4661145 2249312 2249312 plaintiff Kenelok John   763638 763638 Kenelok, John, of Mynstreworth 1
4704422 2266757 2266757 defendant Sampson John chapman 763638 763638 Sampson, John, of Mynstreworth, chapman 0
4723070 2272526 2272526 defendant Hunteley John husbandman 763638 763638 Hunteley, John, of Mynstreworth, husbandman 0
4724717 2273028 2273028 defendant Storme Edmund husbandman 763638 763638 Storme, Edmund, of Mynstreworth, husbandman 0
4724723 2273029 2273029 defendant Hunteley John husbandman 763638 763638 Hunteley, John, of Mynstreworth, husbandman 3
4751273 2280851 2280851 defendant Silvestre Marcus husbandman 763638 763638 Silvestre, Marcus, of Mynstreworth, husbandman 0
4763755 2284652 2284652 plaintiff Gy John   763638 763638 Gy, John, of Mynstreworth 0
4788556 2292481 2292481 defendant Gosselyn Richard husbandman 763638 763638 Gosselyn, Richard, of Mynstreworth, husbandman 1
4789882 2292906 2292906 defendant Grove John carpenter 763638 763638 Grove, John, of Mynstreworth, carpenter 1
4799974 2296172 2296172 defendant Sturme Richard husbandman 763638 763638 Sturme, Richard, of Mynstreworth, husbandman 0
4927627 2335077 2335077 defendant Boyfeld Richard husbandman 763638 763638 Boyfeld, Richard, of Mynstreworth, husbandman 0
4927628 2335077 2335077 defendant Coke Richard husbandman 763638 763638 Coke, Richard, of Mynstreworth, husbandman 1
4927629 2335077 2335077 defendant Gibbes John husbandman 763638 763638 Gibbes, John, of Mynstreworth, husbandman 2
4943389 2339901 2339901 defendant Baret Richard drover 763638 763638 Baret, Richard, of Mynstreworth, drover 1
5072879 2378374 2378374 defendant Hatheway Thomas gent 763638 763638 Hatheway, Thomas, of Mynstreworth, gent 1
5097840 2385795 2385795 defendant Hathewey Thomas gent 763638 763638 Hathewey, Thomas, of Mynstreworth, gent 1
5244027 2428442 2428442 defendant Hegges Philip clerk 763638 763638 Hegges, Philip, of Mynstreworth, clerk 0
5343404 2458126 2458126 defendant Arnolde Richard husbandman 763638 763638 Arnolde, Richard, of Mynstreworth, husbandman 0
5630474 2553542 2553542 defendant Sampson John husbandman 763638 763638 Sampson, John, of Mynstreworth, husbandman 1

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