names

30 rows where place_id = 589577

✎ 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
3598045 1867013 1867013 defendant Cheyne William (legal representative) 589577 589577 Cheyne, William, of Warbelton, esq, executor of 0
3598046 1867013 1867013 defendant Cheyne John gent 589577 589577 Cheyne, John, of Warbelton, gent 1
3814246 1962362 1962362 defendant Underdowne John   589577 589577 Underdowne, John, of Warbelton 1
3914571 1995218 1995218 defendant Couper John husbandman 589577 589577 Couper, John, of Warbelton, husbandman 0
4439794 2181722 2181722 plaintiff Baroun William   589577 589577 Baroun, William, of Warbelton, parson 0
4439796 2181723 2181723 plaintiff Baroun William   589577 589577 Baroun, William, of Warbelton, parson 0
4439798 2181724 2181724 plaintiff Baroun William   589577 589577 Baroun, William, of Warbelton, parson of the church 0
4439800 2181725 2181725 plaintiff Baroun William   589577 589577 Baroun, William, of Warbelton, parson of the church 0
4524934 2208142 2208142 defendant Dyere Thomas   589577 589577 Dyere, Thomas, of Warbelton 0
4595777 2229931 2229931 plaintiff Roberd Walter (legal representative) 589577 589577 Roberd, Walter, of Warbelton, parson & clerk, executors of 0
4649340 2245858 2245858 plaintiff Petyjon Thomas   589577 589577 Petyjon, Thomas, of Warbelton 1
4827012 2304491 2304491 defendant Wodesell John weaver 589577 589577 Wodesell, John, of Warbelton, weaver 0
4827014 2304492 2304492 defendant Wodesell John weaver 589577 589577 Wodesell, John, of Warbelton, weaver 0
4843050 2309360 2309360 defendant Courtevyll Richard husbandman 589577 589577 Courtevyll, Richard, of Warbelton, husbandman 1
4860213 2314554 2314554 defendant Aleyn Robert laborer 589577 589577 Aleyn, Robert, of Warbelton, laborer 0
4894442 2324937 2324937 defendant Cheyne William gent 589577 589577 Cheyne, William, of Warbelton, gent 2
4994340 2355182 2355182 defendant Warbelton William esq 589577 589577 Warbelton, William, of Warbelton, esq 0
5003914 2358033 2358033 defendant Peteiohn William husbandman 589577 589577 Peteiohn, William, of Warbelton, husbandman 0
5064817 2376015 2376015 plaintiff Cheyne William   589577 589577 Cheyne, William, of Warbelton 4
5064824 2376016 2376016 plaintiff Cheyne William   589577 589577 Cheyne, William, of Warbelton 4
5064834 2376017 2376017 plaintiff Cheyne William   589577 589577 Cheyne, William, of Warbelton 4
5064841 2376018 2376018 plaintiff Cheyne William   589577 589577 Cheyne, William, of Warbelton 4
5087730 2382796 2382796 defendant Preston Thomas husbandman 589577 589577 Preston, Thomas, of Warbelton, husbandman 0
5087732 2382797 2382797 defendant Preston Thomas husbandman 589577 589577 Preston, Thomas, of Warbelton, husbandman 0
5089245 2383226 2383226 plaintiff Cheyne William   589577 589577 Cheyne, William, of Warbelton 4
5089253 2383227 2383227 plaintiff Cheyne William   589577 589577 Cheyne, William, of Warbelton 4
5113973 2390477 2390477 plaintiff Cheyne William   589577 589577 Cheyne, William, of Warbelton 4
5217630 2420890 2420890 defendant at Wode Robert husbandman 589577 589577 at Wode, Robert, of Warbelton, husbandman 27
5249952 2430096 2430096 defendant Aleyn Thomas husbandman 589577 589577 Aleyn, Thomas, of Warbelton, husbandman 2
5292113 2442693 2442693 defendant Aleyn Thomas husbandman 589577 589577 Aleyn, Thomas, of Warbelton, husbandman 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);