names

22 rows where place_id = 594239

✎ 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
3615222 1872407 1872407 defendant ap Howell Clement gent 594239 594239 ap Howell, Clement, of Okynton, gent 0
3797539 1957124 1957124 defendant Stubbe William husbandman 594239 594239 Stubbe, William, of Okynton, husbandman 0
3797541 1957124 1957124 defendant Docull Richard husbandman 594239 594239 Docull, Richard, of Okynton, husbandman 2
3797542 1957124 1957124 defendant Strode Richard husbandman 594239 594239 Strode, Richard, of Okynton, husbandman 3
4535821 2211479 2211479 defendant Bocher John   594239 594239 Bocher, John, of Okynton 0
4554656 2217383 2217383 defendant Lok William   594239 594239 Lok, William, of Okynton 0
4569384 2222014 2222014 defendant Bocher John   594239 594239 Bocher, John, of Okynton 4
4618338 2236744 2236744 defendant Seward Richard   594239 594239 Seward, Richard, of Okynton 0
4695235 2263989 2263989 defendant Gabbe William   594239 594239 Gabbe, William, of Okynton, plough man 0
4702155 2266083 2266083 defendant Hynton John husbandman 594239 594239 Hynton, John, of Okynton, husbandman 2
4737732 2276904 2276904 defendant Gabbe William husbandman 594239 594239 Gabbe, William, of Okynton, husbandman 2
4745537 2279206 2279206 defendant Neweman John husbandman 594239 594239 Neweman, John, of Okynton, husbandman 2
4751382 2280882 2280882 defendant Gabbe William husbandman 594239 594239 Gabbe, William, of Okynton, husbandman 0
4776113 2288525 2288525 plaintiff Yonge Margaret   594239 594239 Yonge, Margaret, of Okynton, gentle woman 0
4781236 2290144 2290144 defendant Syward Richard husbandman 594239 594239 Syward, Richard, of Okynton, husbandman 2
4915027 2331205 2331205 defendant Wytyebrygge Thomas husbandman 594239 594239 Wytyebrygge, Thomas, of Okynton, husbandman 3
5029842 2365602 2365602 defendant Wethebrygge Thomas husbandman 594239 594239 Wethebrygge, Thomas, of Okynton, husbandman 1
5199415 2415579 2415579 defendant Frenssh Nicholas husbandman 594239 594239 Frenssh, Nicholas, of Okynton, husbandman 3
5211115 2418977 2418977 defendant Frenssh Nicholas husbandman 594239 594239 Frenssh, Nicholas, of Okynton, husbandman 3
5288057 2441523 2441523 defendant Withybrigge John butcher 594239 594239 Withybrigge, John, of Okynton, butcher 2
5348846 2459767 2459767 defendant Launder Thomas husbandman 594239 594239 Launder, Thomas, of Okynton, husbandman 0
5627245 2552488 2552488 defendant Neylysthorp Richard husbandman 594239 594239 Neylysthorp, Richard, of Okynton, husbandman 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);