names

19 rows where case_id = 1870632

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
3609493 1870632 1870632 defendant Bagshawe Nicholas yeoman 592944 592944 Bagshawe, Nicholas, of Magna Huklowe, yeoman 0
3609494 1870632 1870632 defendant Alen Thomas yeoman 592944 592944 Alen, Thomas, of Magna Huklowe, yeoman 1
3609495 1870632 1870632 defendant Marshall Bartholomew husbandman 592944 592944 Marshall, Bartholomew, of Magna Huklowe, husbandman 2
3609496 1870632 1870632 defendant Shalcrosse John husbandman 592945 592945 Shalcrosse, John, of Grenlowe Graunge, husbandman 3
3609497 1870632 1870632 defendant Furnes Elias husbandman 592946 592946 Furnes, Elias, of Parva Huklowe, husbandman 4
3609498 1870632 1870632 defendant Lowe Roger husbandman 592946 592946 Lowe, Roger, of Parva Huklowe, husbandman 5
3609499 1870632 1870632 defendant Smyth John husbandman 592946 592946 Smyth, John, of Parva Huklowe, husbandman 6
3609500 1870632 1870632 defendant Depclogh Robert husbandman 592944 592944 Depclogh, Robert, of Magna Huklowe, husbandman 7
3609501 1870632 1870632 defendant Bagshawe Philip husbandman 592947 592947 Bagshawe, Philip, of Abney, husbandman 8
3609502 1870632 1870632 defendant Hall Thurstan husbandman 592947 592947 Hall, Thurstan, of Abney, husbandman 9
3609503 1870632 1870632 defendant Bagshawe Robert husbandman 592948 592948 Bagshawe, Robert, of Abney Grange, husbandman 10
3609504 1870632 1870632 defendant Barker Robert husbandman 592948 592948 Barker, Robert, of Abney Grange, husbandman 11
3609505 1870632 1870632 defendant Middilton John husbandman 592730 592730 Middilton, John, of Bradwell, husbandman 12
3609506 1870632 1870632 defendant Elot William husbandman 592730 592730 Elot, William, of Bradwell, husbandman 13
3609507 1870632 1870632 defendant Cokke Christopher husbandman 592730 592730 Cokke, Christopher, of Bradwell, husbandman 14
3609508 1870632 1870632 defendant Eyre Brian laborer 592730 592730 Eyre, Brian, of Bradwell, laborer 15
3609509 1870632 1870632 defendant Slak Richard husbandman 586784 586784 Slak, Richard, of Burgh, husbandman 16
3609510 1870632 1870632 defendant Marshall Nicholas husbandman 586784 586784 Marshall, Nicholas, of Burgh, husbandman 17
3609511 1870632 1870632 defendant Toftes Robert miller 586784 586784 Toftes, Robert, of Burgh, miller 18

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