names

19 rows where case_id = 2277449

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4739547 2277449 2277449 plaintiff York   in   York, abbot of the monastery of the BM, in 0
4739548 2277449 2277449 defendant Howeden Thomas husbandman 785336 785336 Howeden, Thomas, of Smethton, husbandman 0
4739549 2277449 2277449 defendant Tomson John husbandman 785336 785336 Tomson, John, of Smethton, husbandman 1
4739550 2277449 2277449 defendant Powes John husbandman 785336 785336 Powes, John, of Smethton, husbandman 2
4739551 2277449 2277449 defendant Warde Thomas husbandman 785336 785336 Warde, Thomas, of Smethton, husbandman 3
4739552 2277449 2277449 defendant Webster Thomas husbandman 785336 785336 Webster, Thomas, of Smethton, husbandman 4
4739553 2277449 2277449 defendant Loweson John jun, of Smethton, husbandman   Loweson, John, jun, of Smethton, husbandman 5
4739554 2277449 2277449 defendant Angrom Thomas husbandman 785336 785336 Angrom, Thomas, of Smethton, husbandman 6
4739555 2277449 2277449 defendant Meyses William   785336 785336 Meyses, William, of Smethton 7
4739556 2277449 2277449 defendant Helmesley Thomas   794152 794152 Helmesley, Thomas, of Smithton 8
4739557 2277449 2277449 defendant Ferrour William   587030 587030 Ferrour, William, of Hornby 9
4739558 2277449 2277449 defendant Boteler John yeoman 587030 587030 Boteler, John, of Hornby, yeoman 10
4739559 2277449 2277449 defendant Williamson John husbandman 587030 587030 Williamson, John, of Hornby, husbandman 11
4739560 2277449 2277449 defendant Osmunderlawe Simon   587030 587030 Osmunderlawe, Simon, of Hornby 12
4739561 2277449 2277449 defendant Payneter Thomas   587030 587030 Payneter, Thomas, of Hornby 13
4739562 2277449 2277449 defendant Lonesdales John   587030 587030 Lonesdales, John, of Hornby 14
4739563 2277449 2277449 defendant Carter John   587030 587030 Carter, John, of Hornby 15
4739564 2277449 2277449 defendant Nethird Nicholas   587030 587030 Nethird, Nicholas, of Hornby 16
4739565 2277449 2277449 defendant Robynson John   794153 794153 Robynson, John, of Hornby, husbandmen 17

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