names

24 rows where place_id = 601378

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3645091 1908873 1908873 defendant Stele Robert gent 601378 601378 Stele, Robert, of Ouston, gent 0
3711306 1929841 1929841 defendant Shircliff Thomas yeoman 601378 601378 Shircliff, Thomas, of Ouston, yeoman 0
3736703 1937732 1937732 defendant Shircliff Thomas, senior gent 601378 601378 Shircliff, Thomas, senior, of Ouston, gent 0
3838045 1969811 1969811 defendant Ardyngton John husbandman 601378 601378 Ardyngton, John, of Ouston, husbandman 0
4172122 2085711 2085711 defendant Adam Philip yeoman 601378 601378 Adam, Philip, of Ouston, yeoman 0
4503143 2201553 2201553 plaintiff Outhorp Richard de (legal representative) 601378 601378 Outhorp, Richard de, of Ouston, parson, executor of 0
4551323 2216351 2216351 defendant Skelbrok John   601378 601378 Skelbrok, John, of Ouston 2
4574110 2223425 2223425 defendant Thornhill William   601378 601378 Thornhill, William, of Ouston 4
4621845 2237815 2237815 defendant atte Style Robert   601378 601378 atte Style, Robert, of Ouston 3
4643910 2244318 2244318 defendant atte Stele Robert   601378 601378 atte Stele, Robert, of Ouston 3
4675414 2257919 2257919 defendant atte Stile Robert gent 601378 601378 atte Stile, Robert, of Ouston, gent 3
4728464 2274134 2274134 defendant Wrote John laborer 601378 601378 Wrote, John, of Ouston, laborer 0
4829983 2305422 2305422 defendant Galle John   601378 601378 Galle, John, of Ouston, vicar 0
4851901 2312029 2312029 defendant Dereman John husbandman 601378 601378 Dereman, John, of Ouston, husbandman 1
4854457 2312787 2312787 defendant Holme William gent 601378 601378 Holme, William, of Ouston, gent 0
4999352 2356676 2356676 defendant Haytfeld John gent 601378 601378 Haytfeld, John, of Ouston, gent 1
5026319 2364588 2364588 defendant Haytfeld John gent 601378 601378 Haytfeld, John, of Ouston, gent 1
5042349 2369318 2369318 defendant Bullok William   601378 601378 Bullok, William, of Ouston, gent;Fisshe, John, of Whityngton, wright 0
5185208 2411419 2411419 defendant Pary John laborer 601378 601378 Pary, John, of Ouston, laborer 2
5239257 2427071 2427071 defendant Crudde Robert laborer 601378 601378 Crudde, Robert, of Ouston, laborer 1
5239266 2427072 2427072 defendant Crudde Robert laborer 601378 601378 Crudde, Robert, of Ouston, laborer 1
5354429 2461453 2461453 defendant Barnby Nicholas gent 601378 601378 Barnby, Nicholas, of Ouston, gent 0
5370574 2466384 2466384 defendant Bulloke Richard yeoman 601378 601378 Bulloke, Richard, of Ouston, yeoman 1
5428316 2483394 2483394 defendant bulloke Richard yeoman 601378 601378 bulloke, Richard, of Ouston, yeoman 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);