names

22 rows where place_id = 598839

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634278 1905519 1905519 defendant Metham George gent 598839 598839 Metham, George, of Cadeby, gent 0
3640289 1907397 1907397 defendant Metham George gent 598839 598839 Metham, George, of Cadeby, gent 0
4014161 2029793 2029793 defendant Metham or Pretham Alexander gent 598839 598839 Metham or Pretham, Alexander, of Cadeby, gent 0
4062235 2046783 2046783 defendant Metham or Mecham William gent 598839 598839 Metham or Mecham, William, of Cadeby, gent 3
4257219 2115391 2115391 defendant Bursey Thomas yeoman 598839 598839 Bursey, Thomas, of Cadeby, yeoman 3
4685771 2261139 2261139 defendant Thorp William husbandman 598839 598839 Thorp, William, of Cadeby, husbandman 0
4898086 2326068 2326068 defendant Olivere John   598839 598839 Olivere, John,of Cadeby 3
4930858 2336052 2336052 defendant Olyver John gent 598839 598839 Olyver, John, of Cadeby, gent 0
5025375 2364317 2364317 defendant Dalyson William husbandman 598839 598839 Dalyson, William, of Cadeby, husbandman 2
5053533 2372660 2372660 defendant Asshebourne John miller 598839 598839 Asshebourne, John, of Cadeby, miller 0
5061466 2375020 2375020 defendant Lynton John husbandman 598839 598839 Lynton, John, of Cadeby, husbandman 0
5117877 2391655 2391655 defendant Kele Robert husbandman 598839 598839 Kele, Robert, of Cadeby, husbandman 0
5277356 2438455 2438455 defendant Phelypson William husbandman 598839 598839 Phelypson, William, of Cadeby, husbandman 0
5277357 2438455 2438455 defendant Byrsall John laborer 598839 598839 Byrsall, John, of Cadeby, laborer 1
5277358 2438455 2438455 defendant Gray William laborer 598839 598839 Gray, William, of Cadeby, laborer 2
5277359 2438455 2438455 defendant Scot Margaret   598839 598839 Scot, Margaret, of Cadeby, servant 3
5333561 2455109 2455109 defendant Fentonman John husbandman 598839 598839 Fentonman, John, of Cadeby, husbandman 3
5334601 2455417 2455417 defendant Hetham William gent 598839 598839 Hetham, William, of Cadeby, gent 0
5373637 2467354 2467354 defendant Elys John husbandman 598839 598839 Elys, John, of Cadeby, husbandman 0
5508343 2507482 2507482 defendant Birde William husbandman 598839 598839 Birde, William, of Cadeby, husbandman 22
5602281 2535606 2535606 defendant Metham George gent 598839 598839 Metham, George, of Cadeby, gent 0
5602528 2535684 2535684 defendant Philipson William husbandman 598839 598839 Philipson, William, of Cadeby, 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);