names

39 rows where place_id = 597014

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626947 1903281 1903281 defendant Splotte John, junior laborer 597014 597014 Splotte, John, junior, of Bokerell, laborer 0
3728496 1935160 1935160 defendant Salter William husbandman 597014 597014 Salter, William, of Bokerell, husbandman 0
3743756 1939930 1939930 defendant Strete John husbandman 597014 597014 Strete, John, of Bokerell, husbandman 1
3810426 1961152 1961152 defendant Salter William husbandman 597014 597014 Salter, William, of Bokerell, husbandman 0
3819958 1964123 1964123 defendant Alford John husbandman 597014 597014 Alford, John, of Bokerell, husbandman 0
3828729 1966863 1966863 defendant Salter William husbandman 597014 597014 Salter, William, of Bokerell, husbandman 0
3828730 1966863 1966863 defendant Salter Henry   597014 597014 Salter, Henry, of Bokerell 1
3828731 1966863 1966863 defendant Heggelond Henry laborer 597014 597014 Heggelond, Henry, of Bokerell, laborer 2
3853853 1974837 1974837 defendant Cooke William husbandman 597014 597014 Cooke, William, of Bokerell, husbandman 1
3891281 1987351 1987351 defendant Salter William husbandman 597014 597014 Salter, William, of Bokerell, husbandman 0
3914089 1995057 1995057 defendant Appryce William painter 597014 597014 Appryce, William, of Bokerell, painter 0
4806634 2298284 2298284 defendant Taillour Thomas husbandman 597014 597014 Taillour, Thomas, of Bokerell, husbandman 0
4806635 2298284 2298284 defendant Taillour William laborer 597014 597014 Taillour, William, of Bokerell, laborer 1
4840781 2308654 2308654 defendant Paulyn William husbandman 597014 597014 Paulyn, William, of Bokerell, husbandman 0
4873107 2318542 2318542 defendant Caulyn John husbandman 597014 597014 Caulyn, John, of Bokerell, husbandman 1
4887520 2322934 2322934 defendant Hoy John   597014 597014 Hoy, John, of Bokerell, bailiff 3
4922693 2333510 2333510 defendant Aysshebury John butcher 597014 597014 Aysshebury, John, of Bokerell, butcher 0
4929767 2335724 2335724 defendant Hoye John yeoman 597014 597014 Hoye, John, of Bokerell, yeoman 3
4936239 2337733 2337733 defendant Hoye John   597014 597014 Hoye, John, of Bokerell, bailiff 1
4963004 2345846 2345846 defendant Hoy or Hercy John   597014 597014 Hoy or Hercy, John, of Bokerell, bailiff 3
4985220 2352509 2352509 defendant Hoye John   597014 597014 Hoye, John, of Bokerell, bailiff 4
4990735 2354137 2354137 defendant Hoy John   597014 597014 Hoy, John, of Bokerell, bailiff 4
5016058 2361578 2361578 defendant Hoy John   597014 597014 Hoy, John, of Bokerell, bailiff 4
5021508 2363193 2363193 defendant Hoye John   597014 597014 Hoye, John, of Bokerell, bailiff 1
5021525 2363196 2363196 defendant Hoy John   597014 597014 Hoy, John, of Bokerell, bailiff 2
5022476 2363474 2363474 defendant Asshebury John husbandman 597014 597014 Asshebury, John, of Bokerell, husbandman 5
5041102 2368963 2368963 defendant Hoye John   597014 597014 Hoye, John, of Bokerell, bailiff 4
5042484 2369357 2369357 defendant Domet John husbandman 597014 597014 Domet, John, of Bokerell, husbandman 1
5042486 2369357 2369357 defendant Pollard John laborer 597014 597014 Pollard, John, of Bokerell, laborer 3
5087406 2382696 2382696 defendant Jesse William   597014 597014 Jesse, William, of Bokerell, bailiff 6
5093272 2384430 2384430 defendant Jesse William   597014 597014 Jesse, William, of Bokerell, bailiff 0
5108279 2388855 2388855 defendant Chesse Richard husbandman 597014 597014 Chesse, Richard, of Bokerell, husbandman 0
5109517 2389213 2389213 defendant Paulyn John husbandman 597014 597014 Paulyn, John, of Bokerell, husbandman 0
5109518 2389213 2389213 defendant Chesse Richard husbandman 597014 597014 Chesse, Richard, of Bokerell, husbandman 1
5120959 2392562 2392562 defendant Jesse William husbandman 597014 597014 Jesse, William, of Bokerell, husbandman 0
5149912 2401107 2401107 defendant Geffrey Roger husbandman 597014 597014 Geffrey, Roger, of Bokerell, husbandman 1
5204454 2417053 2417053 defendant Geffrey Roger husbandman 597014 597014 Geffrey, Roger, of Bokerell, husbandman 1
5250381 2430233 2430233 defendant Jesse William husbandman 597014 597014 Jesse, William, of Bokerell, husbandman 0
5566666 2524847 2524847 defendant Hert William husbandman 597014 597014 Hert, William, of Bokerell, 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);