names

24 rows where place_id = 613468

✎ 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
3698516 1925755 1925755 defendant Dun William, senior chapman 613468 613468 Dun, William, senior, of Mere, Wilts, chapman 0
3839029 1970133 1970133 defendant Donne William, senior yeoman 613468 613468 Donne, William, senior, of Mere, Wilts, yeoman 0
3972762 2015046 2015046 defendant Dodyngton John gent 613468 613468 Dodyngton, John, of Mere, Wilts, gent 0
4027053 2034321 2034321 defendant Barnes John smith 613468 613468 Barnes, John, of Mere, Wilts, smith 1
4030318 2035496 2035496 defendant Langford John chapman 613468 613468 Langford, John, of Mere, Wilts, chapman 3
4067194 2048567 2048567 plaintiff Hyll alias Callowhill Richard yeoman 613468 613468 Hyll alias Callowhill, Richard, of Mere, Wilts, yeoman 0
4137123 2073626 2073626 defendant Vovert John merchant 613468 613468 Vovert, John, of Mere, Wilts, or of Southampton, merchant 0
4593883 2229363 2229363 defendant Litle Benedict   613468 613468 Litle, Benedict, of mere, Wilts 0
4694407 2263751 2263751 defendant Peteryche Peter husbandman 613468 613468 Peteryche, Peter, of Mere, Wilts, husbandman 0
4771287 2287001 2287001 defendant Bulford John yeoman 613468 613468 Bulford, John, of Mere, Wilts, yeoman 0
4811681 2299764 2299764 defendant Neweman Roger fuller 613468 613468 Neweman, Roger, of Mere, Wilts, fuller 0
4873165 2318557 2318557 defendant Bondman John dyer 613468 613468 Bondman, John, of Mere, Wilts, dyer 2
4874449 2318951 2318951 defendant Plokenet Walter   613468 613468 Plokenet, Walter, of Mere, Wilts, bell hanger 0
4912457 2330401 2330401 defendant Uwayn William husbandman 613468 613468 Uwayn, William, of Mere, Wilts, husbandman 0
5092864 2384294 2384294 defendant Poton Richard laborer 613468 613468 Poton, Richard, of Mere, Wilts, laborer 3
5159477 2403886 2403886 defendant Elwyn John chapman 613468 613468 Elwyn, John, of Mere, Wilts, chapman 0
5159586 2403919 2403919 defendant Elwyn John chapman 613468 613468 Elwyn, John, of Mere, Wilts, chapman 0
5174595 2408269 2408269 defendant Elwyn John chapman 613468 613468 Elwyn, John, of Mere, Wilts, chapman 0
5195338 2414386 2414386 defendant Ellwyn John chapman 613468 613468 Ellwyn, John, of Mere, Wilts, chapman 0
5272974 2437169 2437169 defendant Chaper Thomas husbandman 613468 613468 Chaper, Thomas, of Mere, Wilts, husbandman 0
5308664 2447626 2447626 defendant Ponton Richard hosteller 613468 613468 Ponton, Richard, of Mere, Wilts, hosteller 1
5448118 2489326 2489326 defendant Weston Roger yeoman 613468 613468 Weston, Roger, of Mere, Wilts, yeoman 0
5596874 2533941 2533941 defendant White John baker 613468 613468 (White, John, of Mere, Wilts, baker 1
5596878 2533942 2533942 defendant White John baker 613468 613468 (White, John, of Mere, Wilts, baker 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);