names

31 rows where place_id = 592515

✎ 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
3607938 1870131 1870131 defendant Gater Richard huasbandman 592515 592515 Gater, Richard, of Crawele, huasbandman 0
4491178 2197927 2197927 defendant Jay John   592515 592515 Jay, John, of Crawele 0
4549145 2215670 2215670 defendant Furby William   592515 592515 Furby, William, of Crawele 0
4667200 2255473 2255473 defendant Blast William gent 592515 592515 Blast, William, of Crawele, gent 2
4667202 2255473 2255473 defendant Burstowe Thomas chandler 592515 592515 Burstowe, Thomas, of Crawele, chandler 4
4724934 2273091 2273091 defendant Welle John de   592515 592515 Welle, John de, of Crawele, friary clerk 0
4738160 2277035 2277035 defendant Fleccher John   592515 592515 Fleccher, John, of Crawele, arrow maker 0
4748175 2279975 2279975 defendant Pakyn William yeoman 592515 592515 Pakyn, William, of Crawele, yeoman 0
4779449 2289550 2289550 defendant Wetherhille John laborer 592515 592515 Wetherhille, John, of Crawele, laborer 1
4944198 2340155 2340155 defendant Colyer Thomas rypyer or fishmonger 592515 592515 Colyer, Thomas, of Crawele, rypyer or fishmonger 2
4944199 2340155 2340155 defendant Colyer John husbandman 592515 592515 Colyer, John, of Crawele, husbandman 3
4944200 2340155 2340155 defendant Tye Henry laborer 592515 592515 Tye, Henry, of Crawele, laborer 4
4968364 2347502 2347502 defendant Pynder William chaplain 592515 592515 Pynder, William, of Crawele, chaplain 2
4998488 2356427 2356427 defendant Herman Nicholas baker 592515 592515 Herman, Nicholas, of Crawele, baker 2
5037626 2367880 2367880 defendant Lecheford Henry gent 592515 592515 Lecheford, Henry, of Crawele, gent 0
5180434 2410019 2410019 defendant Mathewe Richard chapman 592515 592515 Mathewe, Richard, of Crawele, chapman 0
5180438 2410021 2410021 defendant Mathewe Richard chapman 592515 592515 Mathewe, Richard, of Crawele, chapman 0
5202418 2416470 2416470 defendant Mathewe Richard chapman 592515 592515 Mathewe, Richard, of Crawele, chapman 0
5206756 2417713 2417713 defendant Thwaytes Alice widow 592515 592515 Thwaytes, Alice, of Crawele, widow 0
5228982 2424081 2424081 defendant Trekereg Walter tanner 592515 592515 Trekereg, Walter, of Crawele, tanner 0
5253881 2431328 2431328 defendant Staff Thomas yeoman 592515 592515 Staff, Thomas, of Crawele, yeoman 0
5270862 2436575 2436575 defendant Pylcher John yeoman 592515 592515 Pylcher, John, of Crawele, yeoman 0
5296689 2444019 2444019 defendant Geffray John butcher 592515 592515 Geffray, John, of Crawele, butcher 1
5316319 2449965 2449965 defendant Parker Richard yeoman 592515 592515 Parker, Richard, of Crawele, yeoman 2
5316323 2449966 2449966 defendant Parker Richard yeoman 592515 592515 Parker, Richard, of Crawele, yeoman 2
5323999 2452263 2452263 defendant Parker Richard yeoman 592515 592515 Parker, Richard, of Crawele, yeoman 1
5332148 2454692 2454692 defendant Tye Thomas husbandman 592515 592515 Tye, Thomas, of Crawele, husbandman 0
5333329 2455039 2455039 defendant Wody John   592515 592515 together with Wody, John, of Crawele 1
5423395 2481957 2481957 defendant atte Felde John yeoman 592515 592515 atte Felde, John, of Crawele, yeoman 0
5426246 2482803 2482803 defendant atte Water Robert yeoman 592515 592515 atte Water, Robert, of Crawele, yeoman 1
5613441 2547995 2547995 defendant K Nicholas   592515 592515 K, Nicholas, of Crawele, parson 2

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