names

32 rows where place_id = 605500

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3661847 1913990 1913990 defendant Oste Robert yeoman 605500 605500 Oste, Robert, of Henlowe, Beds, yeoman 1
3670686 1916795 1916795 defendant Edward John husbandman 605500 605500 Edward, John, of Henlowe, Beds, husbandman 4
3670713 1916799 1916799 defendant Bert Thomas husbandman 605500 605500 Bert, Thomas, of Henlowe, Beds, husbandman 4
3675896 1918497 1918497 defendant Hemmyg Thomas   605500 605500 Hemmyg, Thomas, of Henlowe, Beds, bowstring maker 0
3675899 1918498 1918498 defendant Hemmyng Thomas   605500 605500 Hemmyng, Thomas, of Henlowe, Beds, bowstring maker 0
3683499 1920969 1920969 defendant Lewes Hugh husbandman 605500 605500 Lewes, Hugh, of Henlowe, Beds, husbandman 0
3683501 1920970 1920970 defendant Lewys Hugh husbandman 605500 605500 Lewys, Hugh, of Henlowe, Beds, husbandman 0
3707207 1928545 1928545 defendant Ost Robert yeoman 605500 605500 Ost, Robert, of Henlowe, Beds, yeoman 0
3721324 1932976 1932976 defendant Ost Robert yeoman 605500 605500 Ost, Robert, of Henlowe, Beds, yeoman 0
3735497 1937341 1937341 defendant Burwell George husbandman 605500 605500 Burwell, George, of Henlowe, Beds, husbandman 0
3763760 1946311 1946311 defendant Edward John yeoman 605500 605500 Edward, John, of Henlowe, Beds, yeoman 0
3899316 1989983 1989983 defendant Hurste Henry   605500 605500 Hurste, Henry, of Henlowe, Beds, bowstring maker 0
4366110 2152923 2152923 defendant Hickman Humphrey yeoman 605500 605500 Hickman, Humphrey, of Henlowe, Beds, yeoman 0
4374954 2156101 2156101 defendant Parker Richard clerk 605500 605500 (Parker, Richard, of Henlowe, Beds, clerk 1
4674026 2257488 2257488 defendant Cook Hugh butcher 605500 605500 Cook, Hugh, of Henlowe, Beds, butcher 0
4721749 2272137 2272137 defendant atte Wode William husbandman 605500 605500 atte Wode, William, of Henlowe, Beds, husbandman 2
4840643 2308612 2308612 defendant Wyse William yeoman 605500 605500 Wyse, William, of Henlowe, Beds, yeoman 2
4898276 2326122 2326122 defendant Manby Richard yeoman 605500 605500 Manby, Richard, of Henlowe, Beds, yeoman 1
4917065 2331845 2331845 defendant Fylle John husbandman 605500 605500 Fylle, John, of Henlowe, Beds, husbandman 0
4917070 2331846 2331846 defendant Fylle John husbandman 605500 605500 Fylle, John, of Henlowe, Beds, husbandman 0
4918578 2332327 2332327 defendant Pykerell Henry husbandman 605500 605500 Pykerell, Henry, of Henlowe, Beds, husbandman 0
4923103 2333643 2333643 defendant wyse William smith 605500 605500 wyse, William, of Henlowe, Beds, smith 0
4979881 2350937 2350937 defendant Fylle John husbandman 605500 605500 Fylle, John, of Henlowe, Beds, husbandman 1
5162684 2404806 2404806 defendant Day William husbandman 605500 605500 Day, William, of Henlowe, Beds, husbandman 2
5162693 2404807 2404807 defendant Goold Nicholas husbandman & weaver 605500 605500 Goold, Nicholas, of Henlowe, Beds, husbandman & weaver 3
5260674 2433463 2433463 defendant Broyn Robert husbandman 605500 605500 Broyn, Robert, of Henlowe, Beds, husbandman 2
5271355 2436715 2436715 defendant Taverener William, junior yeoman 605500 605500 Taverener, William, junior, of Henlowe, Beds, yeoman 2
5303405 2446012 2446012 defendant Hochekyn Thomas yeoman 605500 605500 Hochekyn, Thomas, of Henlowe, Beds, yeoman 4
5303701 2446100 2446100 defendant Taverner William yeoman 605500 605500 Taverner, William, of Henlowe, Beds, yeoman 1
5303705 2446101 2446101 defendant Taverner William yeoman 605500 605500 Taverner, William, of Henlowe, Beds, yeoman 1
5358566 2462738 2462738 defendant Grusse John woolman 605500 605500 Grusse, John, of henlowe, beds, woolman 4
5579715 2528736 2528736 defendant Edwardys John husbandman 605500 605500 Edwardys, John, of Henlowe, Beds, husbandman 0

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