names

71 rows where place_id = 588658

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595190 1866129 1866129 defendant Wednall Henry husbandman 588658 588658 Wednall, Henry, of Boresworth, husbandman 1
3606040 1869555 1869555 defendant Grymston Robert tanner 588658 588658 Grymston, Robert, of Boresworth, tanner 0
3610788 1871039 1871039 defendant Palmer John, senior husbandman 588658 588658 Palmer, John, senior, of Boresworth, husbandman 0
3639036 1907030 1907030 defendant Venton John husbandman 588658 588658 Venton, John, of Boresworth, husbandman 1
3696377 1925090 1925090 defendant Wednale John, junior husbandman 588658 588658 Wednale, John, junior, of Boresworth, husbandman 0
3696379 1925091 1925091 defendant Wednale John, junior husbandman 588658 588658 Wednale, John, junior, of Boresworth, husbandman 0
3704876 1927817 1927817 defendant Palle John laborer 588658 588658 Palle, John, of Boresworth, laborer 2
3704884 1927820 1927820 defendant Assheby William, senior yeoman 588658 588658 Assheby, William, senior, of Boresworth, yeoman 0
3725728 1934336 1934336 defendant Wednall John husbandman 588658 588658 Wednall, John, of Boresworth, husbandman 0
3725730 1934337 1934337 defendant Wednall John husbandman 588658 588658 Wednall, John, of Boresworth, husbandman 0
3739847 1938676 1938676 defendant Traselove Richard yeoman 588658 588658 Traselove, Richard, of Boresworth, yeoman 15
3753769 1943122 1943122 defendant Lykerys John husbandman 588658 588658 Lykerys, John, of Boresworth, husbandman 0
3753770 1943122 1943122 defendant Collyn William husbandman 588658 588658 Collyn, William, of Boresworth, husbandman 1
3753771 1943122 1943122 defendant Warde John husbandman 588658 588658 Warde, John, of Boresworth, husbandman 2
3753772 1943122 1943122 defendant Wednall John husbandman 588658 588658 Wednall, John, of Boresworth, husbandman 3
3753773 1943122 1943122 defendant Warde Richard husbandman 588658 588658 Warde, Richard, of Boresworth, husbandman 4
3753774 1943122 1943122 defendant Carter John husbandman 588658 588658 Carter, John, of Boresworth, husbandman 5
3753775 1943122 1943122 defendant Wythe John husbandman 588658 588658 Wythe, John, of Boresworth, husbandman 6
3753776 1943122 1943122 defendant Palley William husbandman 588658 588658 Palley, William, of Boresworth, husbandman 7
3753777 1943122 1943122 defendant Assheby William, junior husbandman 588658 588658 Assheby, William, junior, of Boresworth, husbandman 8
3753778 1943122 1943122 defendant Assheby William, senior husbandman 588658 588658 Assheby, William, senior, of Boresworth, husbandman 9
3756331 1943946 1943946 defendant Wednall John yeoman 588658 588658 Wednall, John, of Boresworth, yeoman 0
3803463 1958986 1958986 defendant Assheby Richard yeoman 588658 588658 Assheby, Richard, of Boresworth, yeoman 1
3804984 1959503 1959503 defendant Asshby William, senior   588658 588658 Asshby, William, senior, of Boresworth, yeoman, administrators of 1
3804985 1959503 1959503 defendant Asshby Robert clerk 588658 588658 (Asshby, Robert, of Boresworth, clerk 2
3804986 1959503 1959503 defendant Asshby William yeoman 588658 588658 Asshby, William, of Boresworth, yeoman 3
3806706 1959996 1959996 defendant Haddon Robert yeoman 588658 588658 Haddon, Robert, of Boresworth, yeoman 1
3871150 1980603 1980603 defendant Mayhoo Gregory husbandman 588658 588658 Mayhoo, Gregory, of Boresworth, husbandman 0
3923809 1998269 1998269 defendant Cotton Robert yeoman 588658 588658 Cotton, Robert, of Boresworth, yeoman 0
3923811 1998270 1998270 defendant Warde Richard husbandman 588658 588658 Warde, Richard, of Boresworth, husbandman 0
4057473 2045049 2045049 defendant Cotton Francis gent 588658 588658 Cotton, Francis, of Boresworth, gent 0
4072502 2050469 2050469 defendant Cotton Francis gent 588658 588658 Cotton, Francis, of Boresworth, gent 0
4072503 2050469 2050469 defendant Cotton John husbandman 588658 588658 Cotton, John, of Boresworth, husbandman 1
4072523 2050478 2050478 defendant Cotton Francis gent 588658 588658 Cotton, Francis, of Boresworth, gent 0
4077404 2052206 2052206 defendant Cotton Francis gent 588658 588658 Cotton, Francis, of Boresworth, gent 0
4416789 2170119 2170119 defendant chapman Adam   588658 588658 chapman, Adam, of Boresworth 2
4429458 2174013 2174013 defendant Chapman Adam   588658 588658 Chapman, Adam, of Boresworth 21
4453719 2186177 2186177 defendant Auncell Mathew   588658 588658 Auncell, Mathew, of Boresworth 0
4661490 2249422 2249422 defendant Webster Henry weaver 588658 588658 Webster, Henry, of Boresworth, weaver 0
4661556 2249446 2249446 defendant Webster Henry weaver 588658 588658 Webster, Henry, of Boresworth, weaver 0
4905587 2328348 2328348 defendant Hardy John husbandman 588658 588658 Hardy, John, of Boresworth, husbandman 0
4991337 2354291 2354291 defendant Aylmer Roger husbandman 588658 588658 Aylmer, Roger, of Boresworth, husbandman 3
4993226 2354854 2354854 defendant Whypp John husbandman 588658 588658 Whypp, John, of Boresworth, husbandman 1
5007502 2359089 2359089 defendant Colyn Richard yeoman 588658 588658 Colyn, Richard, of Boresworth, yeoman 4
5109108 2389087 2389087 defendant Souter Roger husbandman 588658 588658 Souter, Roger, of Boresworth, husbandman 1
5122628 2393051 2393051 defendant Bulter William yeoman 588658 588658 Bulter, William, of Boresworth, yeoman 1
5189894 2412787 2412787 defendant Ince William clerk 588658 588658 Ince, William, of Boresworth, clerk 2
5289500 2441930 2441930 defendant Colyns William husbandman 588658 588658 Colyns, William, of Boresworth, husbandman 0
5323521 2452117 2452117 plaintiff Pakeman John   588658 588658 Pakeman, John, of Boresworth 0
5323525 2452118 2452118 plaintiff Pakeman John   588658 588658 Pakeman, John, of Boresworth 0
5443636 2488016 2488016 defendant Abbot John husbandman 588658 588658 Abbot, John, of Boresworth, husbandman 2
5543533 2518091 2518091 defendant Horton Thomas yeoman 588658 588658 Horton, Thomas, of Boresworth, yeoman 0
5543534 2518091 2518091 defendant Wednalle Henry husbandman 588658 588658 Wednalle, Henry, of Boresworth, husbandman 1
5543535 2518091 2518091 defendant Wednalle Richard husbandman 588658 588658 Wednalle, Richard, of Boresworth, husbandman 2
5543559 2518092 2518092 defendant Wednall Henry husbandman 588658 588658 Wednall, Henry, of Boresworth, husbandman 0
5543560 2518092 2518092 defendant Clerk William husbandman 588658 588658 Clerk, William, of Boresworth, husbandman 1
5543561 2518092 2518092 defendant White Richard husbandman 588658 588658 White, Richard, of Boresworth, husbandman 2
5543562 2518092 2518092 defendant Ward William husbandman 588658 588658 Ward, William, of Boresworth, husbandman 3
5543563 2518092 2518092 defendant Pakeman Ralph husbandman 588658 588658 Pakeman, Ralph, of Boresworth, husbandman 4
5543564 2518092 2518092 defendant Pakeman Richard husbandman 588658 588658 Pakeman, Richard, of Boresworth, husbandman 5
5543565 2518092 2518092 defendant Vyals William husbandman 588658 588658 Vyals, William, of Boresworth, husbandman 6
5543566 2518092 2518092 defendant Colen William husbandman 588658 588658 Colen, William, of Boresworth, husbandman 7
5543567 2518092 2518092 defendant Wednall Richard husbandman 588658 588658 Wednall, Richard, of Boresworth, husbandman 8
5543568 2518092 2518092 defendant Smyth William husbandman 588658 588658 Smyth, William, of Boresworth, husbandman 9
5554457 2521339 2521339 defendant Wednall John, junior husbandman 588658 588658 Wednall, John, junior, of Boresworth, husbandman 0
5557920 2522268 2522268 defendant Wednall Agnes widow 588658 588658 Wednall, Agnes, of Boresworth, widow 0
5557921 2522268 2522268 defendant Wednall John yeoman 588658 588658 Wednall, John, of Boresworth, yeoman 1
5557922 2522268 2522268 defendant Wednall Richard yeoman 588658 588658 Wednall, Richard, of Boresworth, yeoman 2
5599289 2534659 2534659 defendant Pekeman Ellen widow 588658 588658 Pekeman, Ellen, of Boresworth, widow 0
5599290 2534659 2534659 defendant Pekeman Thomas laborer 588658 588658 Pekeman, Thomas, of Boresworth, laborer 1
5613742 2548072 2548072 defendant Colyns John   588658 588658 Colyns, John, of Boresworth 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);