names

51 rows where place_id = 589444

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597666 1866896 1866896 defendant Lee Reginald esq 589444 589444 Lee, Reginald, of Annesley, esq 0
3603841 1868874 1868874 defendant Watson Richard husbandman 589444 589444 Watson, Richard, of Annesley, husbandman 1
3623223 1874789 1874789 defendant Rodes Edmund yeoman 589444 589444 Rodes, Edmund, of Annesley, yeoman 0
3675805 1918466 1918466 defendant Gregge William husbandman 589444 589444 Gregge, William, of Annesley, husbandman 2
3703248 1927287 1927287 defendant Bett Robert husbandman 589444 589444 Bett, Robert, of Annesley, husbandman 1
3703249 1927287 1927287 defendant Taillour William husbandman 589444 589444 Taillour, William, of Annesley, husbandman 2
3703250 1927287 1927287 defendant Taillour John husbandman 589444 589444 Taillour, John, of Annesley, husbandman 3
3710243 1929520 1929520 defendant Annesley John clerk 589444 589444 Annesley, John, of Annesley, clerk 0
3714655 1930881 1930881 defendant Lowe John husbandman 589444 589444 Lowe, John, of Annesley, husbandman 0
3714656 1930881 1930881 defendant Lowe William husbandman 589444 589444 Lowe, William, of Annesley, husbandman 1
3714657 1930881 1930881 defendant Taillour John husbandman 589444 589444 Taillour, John, of Annesley, husbandman 2
3714658 1930881 1930881 defendant Bett Robert husbandman 589444 589444 Bett, Robert, of Annesley, husbandman 3
3714659 1930881 1930881 defendant Astyll Richard husbandman 589444 589444 Astyll, Richard, of Annesley, husbandman 4
3732767 1936478 1936478 defendant Lowe John husbandman 589444 589444 Lowe, John, of Annesley, husbandman 0
3732768 1936478 1936478 defendant Raulynson Ralph husbandman 589444 589444 Raulynson, Ralph, of Annesley, husbandman 1
3742461 1939512 1939512 defendant Samon Richard gent 589444 589444 Samon, Richard, of Annesley, gent 0
3804937 1959488 1959488 defendant Greg William yeoman 589444 589444 Greg, William, of Annesley, yeoman 0
3914714 1995266 1995266 defendant Brokett Thomas yeoman 589444 589444 Brokett, Thomas, of Annesley, yeoman 0
3918719 1996592 1996592 defendant Clerke Roger husbandman 589444 589444 Clerke, Roger, of Annesley, husbandman 1
3918720 1996592 1996592 defendant Clerke Ricard yeoman 589444 589444 Clerke, Ricard, of Annesley, yeoman 2
4748776 2280127 2280127 defendant Clem William laborer 589444 589444 Clem, William, of annesley, laborer 0
4803906 2297401 2297401 defendant Brathwyt John yeoman 589444 589444 Brathwyt, John, of Annesley, yeoman 0
4820853 2302610 2302610 defendant Rolston Richard husbandman 589444 589444 Rolston, Richard, of Annesley, husbandman 7
4820854 2302610 2302610 defendant Wryght Robert husbandman 589444 589444 Wryght, Robert, of Annesley, husbandman 8
4820855 2302610 2302610 defendant Rolston Thomas laborer 589444 589444 Rolston, Thomas, of Annesley, laborer 9
4820862 2302612 2302612 defendant Barlowe Thomas husbandman 589444 589444 Barlowe, Thomas, of Annesley, husbandman 5
4820863 2302612 2302612 defendant Haseles John husbandman 589444 589444 Haseles, John, of Annesley, husbandman 6
4841868 2308990 2308990 defendant Bette John husbandman 589444 589444 Bette, John, of Annesley, husbandman 0
4938310 2338362 2338362 defendant Shryggeley Robert esq 589444 589444 Shryggeley, Robert, of Annesley, esq 0
4938312 2338362 2338362 defendant Allerton John yeoman 589444 589444 Allerton, John, of Annesley, yeoman 2
4938316 2338364 2338364 defendant Wheston William yeoman 589444 589444 Wheston, William, of Annesley, yeoman 0
4938317 2338364 2338364 defendant Allerton John yeoman 589444 589444 Allerton, John, of Annesley, yeoman 1
4938318 2338364 2338364 defendant Shrigge Robert esq 589444 589444 together with Shrigge, Robert, of Annesley, esq 2
4951089 2342303 2342303 defendant Allerton John yeoman 589444 589444 Allerton, John, of Annesley, yeoman 0
4951090 2342303 2342303 defendant Weston William yeoman 589444 589444 Weston, William, of Annesley, yeoman 1
4951091 2342303 2342303 defendant Shriggeley Robert esq 589444 589444 together with Shriggeley, Robert, of Annesley, esq 2
4951095 2342305 2342305 defendant Shryggeley Robert esq 589444 589444 Shryggeley, Robert, of Annesley, esq 0
4951096 2342305 2342305 defendant Allerton John yeoman 589444 589444 together with Allerton, John, of Annesley, yeoman 1
4951097 2342305 2342305 defendant Wheston William yeoman 589444 589444 Wheston, William, of Annesley, yeoman 2
4976366 2349892 2349892 defendant Bette Richard husbandman 589444 589444 Bette, Richard, of Annesley, husbandman 1
4977090 2350102 2350102 defendant Bette Richard husbandman 589444 589444 Bette, Richard, of Annesley, husbandman 1
5030329 2365744 2365744 defendant Page William   589444 589444 Page, William, of Annesley, servant 0
5030509 2365794 2365794 defendant Page William   589444 589444 Page, William, of Annesley, servant 0
5038274 2368084 2368084 defendant Laurens John husbandman 589444 589444 Laurens, John, of Annesley, husbandman 0
5279977 2439214 2439214 defendant Couper John husbandman 589444 589444 Couper, John, of Annesley, husbandman 9
5311269 2448398 2448398 defendant Hawekeyerd James tailor 589444 589444 Hawekeyerd, James, of Annesley, tailor 0
5353931 2461293 2461293 defendant Boney or Bovey Richard chaplain 589444 589444 Boney or Bovey, Richard, of Annesley, chaplain 0
5547385 2519247 2519247 defendant Curtes William husbandman 589444 589444 Curtes, William, of Annesley, husbandman 0
5547386 2519247 2519247 defendant Astyll William husbandman 589444 589444 Astyll, William, of Annesley, husbandman 1
5547387 2519247 2519247 defendant Curteis John husbandman 589444 589444 Curteis, John, of Annesley, husbandman 2
5580904 2529102 2529102 defendant Samon Thomas esq 589444 589444 Samon, Thomas, of Annesley, esq 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);