names

66 rows where place_id = 611154

✎ 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
3687124 1922146 1922146 defendant Parson John weaver 611154 611154 Parson, John, of Shitlyngton, weaver 1
3693114 1924055 1924055 defendant Brateman Simon husbandman 611154 611154 Brateman, Simon, of Shitlyngton, husbandman 0
3743236 1939750 1939750 defendant Person Walter weaver 611154 611154 Person, Walter, of Shitlyngton, weaver 0
3743238 1939750 1939750 defendant Grove John husbandman 611154 611154 Grove, John, of Shitlyngton, husbandman 2
3788968 1954361 1954361 defendant Robyns Thomas husbandman 611154 611154 Robyns, Thomas, of Shitlyngton, husbandman 0
3792767 1955589 1955589 defendant Wright John husbandman 611154 611154 Wright, John, of Shitlyngton, husbandman 2
3794652 1956204 1956204 defendant Dryver Thomas husbandman 611154 611154 Dryver, Thomas, of Shitlyngton, husbandman 1
3797178 1957002 1957002 defendant Bocher John butcher 611154 611154 Bocher, John, of Shitlyngton, butcher 0
3806882 1960063 1960063 plaintiff West Thomas   611154 611154 West, Thomas, of Shitlyngton 0
3806885 1960064 1960064 plaintiff West Thomas   611154 611154 West, Thomas, of Shitlyngton 0
3855708 1975420 1975420 defendant Kechener William husbandman 611154 611154 Kechener, William, of Shitlyngton, husbandman 0
4254240 2114416 2114416 defendant Hall or Hale William husbandman 611154 611154 Hall or Hale, William, of Shitlyngton, husbandman 0
4478586 2193967 2193967 defendant Beeston John   611154 611154 Beeston, John, of Shitlyngton 1
4657442 2248220 2248220 plaintiff Coche William   611154 611154 Coche, William, of Shitlyngton 0
4657443 2248220 2248220 defendant Taillour Lawrence tailor 611154 611154 Taillour, Lawrence, of Shitlyngton, tailor 0
4657444 2248220 2248220 defendant Taillour John tailor 611154 611154 Taillour, John, of Shitlyngton, tailor 1
4657445 2248220 2248220 defendant Beston John husbandman 611154 611154 Beston, John, of Shitlyngton, husbandman 2
4657446 2248220 2248220 defendant Shepherd Richard chaplain 611154 611154 Shepherd, Richard, of Shitlyngton, chaplain 3
4657447 2248220 2248220 defendant Brounham John laborer 611154 611154 Brounham, John, of Shitlyngton, laborer 4
4664190 2250289 2250289 defendant Honto or Houto John husbandman 611154 611154 Honto or Houto, John, of Shitlyngton, husbandman 0
4664192 2250290 2250290 defendant Taylour Lawrence tailor 611154 611154 Taylour, Lawrence, of Shitlyngton, tailor 0
4688165 2261864 2261864 defendant Warde John husbandman 611154 611154 Warde, John, of Shitlyngton, husbandman 0
4733390 2275620 2275620 defendant Warde John husbandman 611154 611154 Warde, John, of Shitlyngton, husbandman 0
4763914 2284707 2284707 defendant Bradesan of Bradefan Thomas husbandman 611154 611154 Bradesan of Bradefan, Thomas, of Shitlyngton, husbandman 0
4763915 2284707 2284707 defendant Bradfan Robert husbandman 611154 611154 Bradfan, Robert, of Shitlyngton, husbandman 1
4766804 2285612 2285612 defendant Mons John husbandman 611154 611154 Mons, John, of Shitlyngton, husbandman 0
4773459 2287668 2287668 defendant Mous John husbandman 611154 611154 Mous, John, of Shitlyngton, husbandman 0
4775006 2288180 2288180 defendant Clerk John husbandman 611154 611154 Clerk, John, of Shitlyngton, husbandman 0
4775007 2288180 2288180 defendant Porter John husbandman 611154 611154 Porter, John, of Shitlyngton, husbandman 1
4775008 2288180 2288180 defendant Flore Richard chaplain 611154 611154 Flore, Richard, of Shitlyngton, chaplain 2
4775010 2288181 2288181 defendant Clerk John husbandman 611154 611154 Clerk, John, of Shitlyngton, husbandman 0
4775011 2288181 2288181 defendant Porter John husbandman 611154 611154 together with Porter, John, of Shitlyngton, husbandman 1
4775012 2288181 2288181 defendant Flore Richard chaplain 611154 611154 Flore, Richard, of Shitlyngton, chaplain 2
4775014 2288182 2288182 defendant Flore Richard chaplain 611154 611154 Flore, Richard, of Shitlyngton, chaplain 0
4775015 2288182 2288182 defendant Clerk John husbandman 611154 611154 together with Clerk, John, of Shitlyngton, husbandman 1
4775016 2288182 2288182 defendant Porter John husbandman 611154 611154 Porter, John, of Shitlyngton, husbandman 2
4789763 2292868 2292868 plaintiff Jacson William   611154 611154 Jacson, William, of Shitlyngton 0
4798747 2295786 2295786 defendant Mons John husbandman 611154 611154 Mons, John, of Shitlyngton, husbandman 0
4798749 2295787 2295787 defendant Mous or Mons John husbandman 611154 611154 Mous or Mons, John, of Shitlyngton, husbandman 0
4804680 2297661 2297661 plaintiff Boteller Thomas   611154 611154 Boteller, Thomas, of Shitlyngton, on his own account 0
4815474 2300945 2300945 plaintiff Lassels William   611154 611154 Lassels, William, of Shitlyngton, parson, on his own account 0
4854613 2312820 2312820 defendant Thomason William husbandman 611154 611154 Thomason, William, of Shitlyngton, husbandman 2
4854614 2312820 2312820 defendant Byngley William husbandman 611154 611154 Byngley, William, of Shitlyngton, husbandman 3
4854615 2312820 2312820 defendant Jacson William husbandman 611154 611154 Jacson, William, of Shitlyngton, husbandman 4
4857720 2313794 2313794 defendant Willyamson Richard nailer 611154 611154 Willyamson, Richard, of Shitlyngton, nailer 3
4857721 2313794 2313794 defendant Willyamson John nailer 611154 611154 Willyamson, John, of Shitlyngton, nailer 4
4858822 2314135 2314135 defendant Warde John husbandman 611154 611154 Warde, John, of Shitlyngton, husbandman 0
4858824 2314136 2314136 defendant Warde John husbandman 611154 611154 Warde, John, of Shitlyngton, husbandman 0
4864156 2315764 2315764 defendant Olyver John husbandman 611154 611154 Olyver, John, of Shitlyngton, husbandman 0
4866075 2316360 2316360 defendant Warde John husbandman 611154 611154 Warde, John, of Shitlyngton, husbandman 0
4866076 2316360 2316360 defendant Coke John husbandman 611154 611154 Coke, John, of Shitlyngton, husbandman 1
4875892 2319418 2319418 defendant Pyper William smith 611154 611154 Pyper, William, of Shitlyngton, smith 4
4876782 2319712 2319712 defendant Warde John husbandman 611154 611154 Warde, John, of Shitlyngton, husbandman 0
4876784 2319712 2319712 defendant Cook John husbandman 611154 611154 Cook, John, of Shitlyngton, husbandman 2
4966733 2346984 2346984 defendant Burgeys John maltman 611154 611154 Burgeys, John, of Shitlyngton, maltman 1
5038943 2368293 2368293 defendant Williamson John nailer 611154 611154 Williamson, John, of Shitlyngton, nailer 0
5231852 2424888 2424888 defendant Aungell William cordwainer 611154 611154 Aungell, William, of Shitlyngton, cordwainer 0
5231854 2424888 2424888 defendant Halle William gent 611154 611154 Halle, William, of Shitlyngton, gent 2
5231855 2424888 2424888 defendant Caryngton William husbandman 611154 611154 Caryngton, William, of Shitlyngton, husbandman 3
5323354 2452062 2452062 defendant Marchall John, senior husbandman 611154 611154 Marchall, John, senior, of Shitlyngton, husbandman 0
5323355 2452062 2452062 defendant Marchall John, junior husbandman 611154 611154 Marchall, John, junior, of Shitlyngton, husbandman 1
5411602 2478426 2478426 defendant Okeley John husbandman 611154 611154 Okeley, John, of Shitlyngton, husbandman 0
5411603 2478426 2478426 defendant Johnson John husbandman 611154 611154 Johnson, John, of Shitlyngton, husbandman 1
5529628 2513766 2513766 defendant Welymote John yeoman 611154 611154 Welymote, John, of Shitlyngton, yeoman 1
5580283 2528920 2528920 defendant Barker Christopher yeoman 611154 611154 Barker, Christopher, of Shitlyngton, yeoman 0
5624659 2551652 2551652 defendant Dyghton John husbandman 611154 611154 Dyghton, John, of Shitlyngton, husbandman 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);