names

13 rows where case_id = 1930644

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3713887 1930644 1930644 plaintiff Aylesbury John     Aylesbury, John 0
3713888 1930644 1930644 defendant Somervile Joan widow 616329 616329 Somervile, Joan, of kyngton, Worcs, widow 0
3713889 1930644 1930644 defendant Somervile Ronert esq 616330 616330 Somervile, Ronert, of Edriston, esq 1
3713890 1930644 1930644 defendant Slye Roger gent 607947 607947 Slye, Roger, of Lapworth, gent 2
3713891 1930644 1930644 defendant Hay John yeoman 616331 616331 Hay, John, of Lepworth, yeoman 3
3713892 1930644 1930644 defendant Mounteford John yeoman 616331 616331 Mounteford, John, of Lepworth, yeoman 4
3713893 1930644 1930644 defendant Gybbons John husbandman 616335 616335 Gybbons, John, of Bentleyheth, husbandman 5
3713894 1930644 1930644 defendant Buller Richard husbandman 605476 605476 Buller, Richard, of Halford, husbandman 6
3713895 1930644 1930644 defendant Archer William husbandman 592497 592497 Archer, William, of Marston Butler, husbandman 7
3713896 1930644 1930644 defendant Andrewe John yeoman 616336 616336 Andrewe, John, of Wewenswotton, yeoman 8
3713897 1930644 1930644 defendant Kensale Thomas yeoman 616336 616336 Kensale, Thomas, of Wewenswotton, yeoman 9
3713898 1930644 1930644 defendant Pyper John husbandman 616330 616330 Pyper, John, of Edriston, husbandman 10
3713899 1930644 1930644 defendant Grene William husbandman 616330 616330 Grene, William, of Edriston, husbandman 11

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