names

19 rows where place_id = 810828

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4413562 2169132 2169132 defendant Marchal John le   810828 810828 Marchal, John le, of Little Quielter 0
4633522 2241338 2241338 defendant Broun William   810828 810828 Broun, William, of Little Kayver 3
4679672 2259258 2259258 defendant Verdesans Richard husbandman 810828 810828 Verdesans, Richard, of Little Chester, husbandman 0
4683963 2260597 2260597 defendant del Hall Thomas husbandman 810828 810828 del Hall, Thomas, of Little Chester, husbandman 0
4771931 2287194 2287194 defendant Coteler John husbandman 810828 810828 Coteler, John, of Little Levermer, husbandman 1
4840080 2308447 2308447 defendant Cotes William gent 810828 810828 Cotes, William, of Little Stanmer, gent 1
5012627 2360531 2360531 defendant Tracher Richard husbandman 810828 810828 Tracher, Richard, of Little Wendover, husbandman 1
5042360 2369321 2369321 defendant Milner Thomas husbandman 810828 810828 Milner, Thomas, of Little Over, husbandman 4
5042361 2369321 2369321 defendant Wilson William husbandman 810828 810828 Wilson, William, of Little Over, husbandman 5
5128530 2394819 2394819 defendant Clerk Thomas   810828 810828 Clerk, Thomas, of Little Levermer, shepherd 1
5187000 2411937 2411937 plaintiff Hamond Richard husbandman 810828 810828 Hamond, Richard, of Little Stanmer, husbandman 0
5187006 2411938 2411938 plaintiff Hamond Richard husbandman 810828 810828 Hamond, Richard, of Little Stanmer, husbandman 0
5199384 2415570 2415570 defendant Faune John skinner 810828 810828 Faune, John, of Little Laver, skinner 1
5205451 2417347 2417347 plaintiff Hamond Richard husbandman 810828 810828 Hamond, Richard, of Little Stanmer, husbandman 0
5268165 2435813 2435813 defendant Chirch William husbandman 810828 810828 Chirch, William, of Little Lanser, husbandman 0
5371372 2466626 2466626 defendant Goldhand John husbandman 810828 810828 Goldhand, John, of Little Laver, husbandman 0
5383228 2470278 2470278 defendant Parys Geoffrey   810828 810828 Parys, Geoffrey, of Little 2
5394268 2473424 2473424 defendant Warner William, senior   810828 810828 Warner, William, senior, of Little Stanmer 0
5473951 2497182 2497182 defendant (illegible) William husbandman 810828 810828 _, William, of Little Levermer, husbandman 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);