names

37 rows where place_id = 596273

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3623968 1875027 1875027 defendant Lawraunce Thomas husbandman 596273 596273 Lawraunce, Thomas, of Arlesey, husbandman 0
3662973 1914331 1914331 defendant Pathe Thomas husbandman 596273 596273 Pathe, Thomas, of Arlesey, husbandman 1
3678618 1919372 1919372 defendant Pache alias Carver Thomas husbandman 596273 596273 Pache alias Carver, Thomas, of Arlesey, husbandman 0
3678980 1919496 1919496 defendant Bulbek John butcher 596273 596273 Bulbek, John, of Arlesey, butcher 0
3678983 1919496 1919496 defendant Cokman John butcher 596273 596273 Cokman, John, of Arlesey, butcher 3
3678986 1919497 1919497 defendant Hemmyng William husbandman 596273 596273 Hemmyng, William, of Arlesey, husbandman 0
3742106 1939400 1939400 defendant Tayler William baker 596273 596273 Tayler, William, of Arlesey, baker 0
3845315 1972096 1972096 defendant Busby Nicholas smith 596273 596273 Busby, Nicholas, of Arlesey, smith 0
3845316 1972096 1972096 defendant Baldok William husbandman 596273 596273 Baldok, William, of Arlesey, husbandman 1
3921243 1997458 1997458 plaintiff Parson Thomas   596273 596273 Parson, Thomas, of Arlesey 0
4051058 2042816 2042816 defendant Smythe Jasper yeoman 596273 596273 Smythe, Jasper, of Arlesey, yeoman 0
4063876 2047363 2047363 defendant Page John gent 596273 596273 Page, John, of Arlesey, gent 0
4095704 2058795 2058795 defendant Coke John yeoman 596273 596273 Coke, John, of Arlesey, yeoman 0
4580791 2225474 2225474 defendant Boch William   596273 596273 Boch, William, of Arlesey 0
4811081 2299574 2299574 defendant Est John chapman 596273 596273 Est, John, of Arlesey, chapman 0
4828052 2304817 2304817 defendant Est John husbandman 596273 596273 Est, John, of Arlesey, husbandman 0
4840243 2308496 2308496 defendant Waryn William butcher 596273 596273 Waryn, William, of Arlesey, butcher 0
4840631 2308608 2308608 defendant Kirtelyng John clerk 596273 596273 Kirtelyng, John, of Arlesey, clerk 0
4840632 2308608 2308608 defendant Darell Nicholas yeoman 596273 596273 Darell, Nicholas, of Arlesey, yeoman 1
4882718 2321511 2321511 defendant Waryn William butcher 596273 596273 Waryn, William, of Arlesey, butcher 0
4914310 2330990 2330990 defendant Warwyke Henery husbandman 596273 596273 Warwyke, Henery, of Arlesey, husbandman 0
4914311 2330990 2330990 defendant Hamond John fisher 596273 596273 Hamond, John, of Arlesey, fisher 1
5110129 2389374 2389374 defendant Smyth John carpenter 596273 596273 Smyth, John, of Arlesey, carpenter 0
5269184 2436091 2436091 defendant Warwik Roger stringer of bows 596273 596273 Warwik, Roger, of Arlesey, stringer of bows 0
5271356 2436715 2436715 defendant Hamond William tailor 596273 596273 Hamond, William, of Arlesey, tailor 3
5344084 2458328 2458328 defendant Smyth John carpenter 596273 596273 Smyth, John, of Arlesey, carpenter 1
5411605 2478426 2478426 defendant Reyner John husbandman 596273 596273 Reyner, John, of Arlesey, husbandman 3
5411606 2478426 2478426 defendant Clyfton William husbandman 596273 596273 Clyfton, William, of Arlesey, husbandman 4
5509223 2507743 2507743 defendant Styners or Styners John butcher 596273 596273 Styners or Styners, John, of Arlesey, butcher 1
5509225 2507743 2507743 defendant Laurens Thomas husbandman 596273 596273 Laurens, Thomas, of Arlesey, husbandman 3
5541830 2517558 2517558 defendant Hamond Thomas (legal representative) 596273 596273 Hamond, Thomas, of Arlesey, yeoman, executors of 0
5541831 2517558 2517558 defendant Hamond William husbandman 596273 596273 (Hamond, William, of Arlesey, husbandman 1
5541832 2517558 2517558 defendant Hamond Agnes widow 596273 596273 Hamond, Agnes, of Arlesey, widow 2
5553884 2521175 2521175 defendant Hemyng John butcher 596273 596273 Hemyng, John, of Arlesey, butcher 1
5586571 2530836 2530836 defendant Wylkes John laborer 596273 596273 Wylkes, John, of Arlesey, laborer 0
5586572 2530836 2530836 defendant Cokman John butcher 596273 596273 Cokman, John, of Arlesey, butcher 1
5586573 2530836 2530836 defendant Broun Richard stringer 596273 596273 Broun, Richard, of Arlesey, stringer 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);