names

39 rows where place_id = 613875

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3700747 1926486 1926486 defendant Oxenhed Thomas husbandman 613875 613875 Oxenhed, Thomas, of Staleham, husbandman 1
3700748 1926486 1926486 defendant Hartte John   613875 613875 Hartte, John, of Staleham, worsted weaver 2
3700890 1926524 1926524 defendant Wulff William husbandman 613875 613875 Wulff, William, of Staleham, husbandman 0
3700893 1926524 1926524 defendant Oxenhede Thomas husbandman 613875 613875 Oxenhede, Thomas, of Staleham, husbandman 3
3704644 1927739 1927739 defendant Smallewod Adam husbandman 613875 613875 Smallewod, Adam, of Staleham, husbandman 0
3708355 1928907 1928907 defendant Beamount John husbandman 613875 613875 Beamount, John, of Staleham, husbandman 1
3714461 1930817 1930817 defendant Appulby John yeoman 613875 613875 Appulby, John, of Staleham, yeoman 0
3729791 1935575 1935575 defendant Oxenhed William husbandman 613875 613875 Oxenhed, William, of Staleham, husbandman 0
3754576 1943390 1943390 defendant Hart John   613875 613875 Hart, John, of Staleham, worsted weaver 0
3754577 1943390 1943390 defendant Oxnede Thomas husbandman 613875 613875 Oxnede, Thomas, of Staleham, husbandman 1
3795161 1956352 1956352 defendant Frebon alias Sadeler William   613875 613875 Frebon alias Sadeler, William, of Staleham, worsted weaver 0
3827458 1966455 1966455 defendant Hoggys John   613875 613875 Hoggys, John, of Staleham, "raffeman" 1
3860020 1976849 1976849 defendant Hert John husbandman 613875 613875 Hert, John, of Staleham, husbandman 3
3925595 1998873 1998873 defendant Kewe Richard smith 613875 613875 Kewe, Richard, of Staleham, smith 3
4042825 2039909 2039909 defendant Smyth Andrew yeoman 613875 613875 Smyth, Andrew, of Staleham, yeoman 0
4708500 2268026 2268026 defendant Morfyle William   613875 613875 Morfyle, William, of Staleham, holy water clerk 3
4829763 2305355 2305355 defendant Leget Thomas (legal representative) 613875 613875 Leget, Thomas, of Staleham, executors of 0
4830171 2305479 2305479 defendant Fuller John husbandman 613875 613875 Fuller, John, of Staleham, husbandman 2
4886157 2322531 2322531 defendant Fuller John yeoman 613875 613875 together with Fuller, John, of Staleham, yeoman 1
4970359 2348082 2348082 defendant Neker John husbandman 613875 613875 Neker, John, of Staleham, husbandman 5
5022064 2363346 2363346 defendant Gayre William saddler 613875 613875 Gayre, William, of Staleham, saddler 2
5233004 2425234 2425234 defendant Wylde Robert yeoman 613875 613875 Wylde, Robert, of Staleham, yeoman 4
5531341 2514323 2514323 defendant Mannyng William husbandman 613875 613875 Mannyng, William, of Staleham, husbandman 1
5550432 2520146 2520146 defendant Ade John yeoman 613875 613875 Ade, John, of Staleham, yeoman 0
5550433 2520146 2520146 defendant Steyngate John yeoman 613875 613875 Steyngate, John, of Staleham, yeoman 1
5550887 2520291 2520291 defendant Skynner John mercer 613875 613875 Skynner, John, of Staleham, mercer 4
5552042 2520637 2520637 defendant Gardener Thomas husbandman 613875 613875 Gardener, Thomas, of Staleham, husbandman 4
5556115 2521784 2521784 defendant Gardener Thomas (legal representative) 613875 613875 Gardener, Thomas, of Staleham, yeoman, executors of 0
5556121 2521785 2521785 defendant Gardener Thomas (legal representative) 613875 613875 Gardener, Thomas, of Staleham, yeoman, executors of 0
5556122 2521785 2521785 defendant Wulff John husbandman 613875 613875 (Wulff, John, of Staleham, husbandman 1
5557376 2522120 2522120 defendant Ade John yeoman 613875 613875 Ade, John, of Staleham, yeoman 0
5557377 2522120 2522120 defendant Steyngate John husbandman 613875 613875 Steyngate, John, of Staleham, husbandman 1
5565814 2524597 2524597 defendant Garner Thomas (legal representative) 613875 613875 Garner, Thomas, of Staleham, executors of 2
5565816 2524597 2524597 defendant Wulff John husbandman 613875 613875 Wulff, John, of Staleham, husbandman 4
5572867 2526616 2526616 defendant Wolffe William husbandman 613875 613875 Wolffe, William, of Staleham, husbandman 2
5572868 2526616 2526616 defendant Aylemer William butcher 613875 613875 Aylemer, William, of Staleham, butcher 3
5572869 2526616 2526616 defendant Steyngate John butcher 613875 613875 Steyngate, John, of Staleham, butcher 4
5575374 2527388 2527388 defendant Byrde Robert husbandman 613875 613875 Byrde, Robert, of Staleham, husbandman 0
5614368 2548285 2548285 defendant atte Brigge John   613875 613875 atte Brigge, John, of Staleham 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);