names

64 rows where place_id = 593230

✎ 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
3610992 1871116 1871116 defendant Smyth Simon husbandman 593230 593230 Smyth, Simon, of Houghton Regis, husbandman 0
3628259 1903699 1903699 defendant Hardyng Thomas husbandman 593230 593230 Hardyng, Thomas, of Houghton Regis, husbandman 0
3693435 1924162 1924162 defendant Turnour William husbandman 593230 593230 Turnour, William, of Houghton Regis, husbandman 1
3734028 1936891 1936891 plaintiff Fossey William (legal representative) 593230 593230 Fossey, William, of Houghton Regis, executors of 0
3734032 1936891 1936891 defendant Hayward William husbandman 593230 593230 Hayward, William, of Houghton Regis, husbandman 0
3750697 1942143 1942143 defendant Turnour William maltman 593230 593230 Turnour, William, of Houghton Regis, maltman 0
3761850 1945715 1945715 plaintiff Fossye William   593230 593230 Fossye, William, of Houghton Regis 0
3778896 1951114 1951114 defendant Hardyng Thomas maltman 593230 593230 Hardyng, Thomas, of Houghton Regis, maltman 0
3780021 1951477 1951477 plaintiff Fossey William husbandman or maltman 593230 593230 Fossey, William, of Houghton Regis, husbandman or maltman 0
3786780 1953662 1953662 defendant Hardyng Thomas maltman 593230 593230 Hardyng, Thomas, of Houghton Regis, maltman 2
3791478 1955171 1955171 defendant Fossy William husbandman 593230 593230 Fossy, William, of Houghton Regis, husbandman 0
3792440 1955498 1955498 defendant Fossey William husbandman 593230 593230 Fossey, William, of Houghton Regis, husbandman 0
3796937 1956922 1956922 plaintiff Fossey William husbandman 593230 593230 Fossey, William, of Houghton Regis, husbandman 0
3814187 1962341 1962341 defendant Hayward William husbandman 593230 593230 Hayward, William, of Houghton Regis, husbandman 1
3814196 1962343 1962343 defendant Hardyng Thomas husbandman 593230 593230 Hardyng, Thomas, of Houghton Regis, husbandman 0
3817308 1963324 1963324 defendant Fownten Nicholas husbandman 593230 593230 Fownten, Nicholas, of Houghton Regis, husbandman 0
3817309 1963324 1963324 defendant Mosse Michael husbandman 593230 593230 Mosse, Michael, of Houghton Regis, husbandman 1
3872777 1981109 1981109 defendant Barbour Thomas husbandman 593230 593230 Barbour, Thomas, of Houghton Regis, husbandman 0
3888939 1986543 1986543 defendant Barbour Thomas husbandman 593230 593230 Barbour, Thomas, of Houghton Regis, husbandman 0
3888941 1986544 1986544 defendant Barbour Thomas husbandman 593230 593230 Barbour, Thomas, of Houghton Regis, husbandman 0
3919716 1996932 1996932 defendant Colman John husbandman 593230 593230 Colman, John, of Houghton Regis, husbandman 0
3920676 1997265 1997265 defendant Freman William husbandman 593230 593230 Freman, William, of Houghton Regis, husbandman 2
4016330 2030536 2030536 defendant Caryngton Henry weaver 593230 593230 Caryngton, Henry, of Houghton Regis, weaver 0
4016613 2030649 2030649 defendant Barbar alias Grigg William husbandman 593230 593230 Barbar alias Grigg, William, of Houghton Regis, husbandman 0
4016614 2030649 2030649 defendant Barbor alias Grigg Richard husbandman 593230 593230 Barbor alias Grigg, Richard, of Houghton Regis, husbandman 1
4016615 2030649 2030649 defendant Margery alias Richardson John husbandman 593230 593230 Margery alias Richardson, John, of Houghton Regis, husbandman 2
4016616 2030649 2030649 defendant Brigg William husbandman 593230 593230 Brigg, William, of Houghton Regis, husbandman 3
4051197 2042866 2042866 defendant Caryngton Henry yeoman 593230 593230 Caryngton, Henry, of Houghton Regis, yeoman 0
4066723 2048396 2048396 plaintiff How Henry husbandman 593230 593230 How, Henry, of Houghton Regis, husbandman 0
4303557 2131369 2131369 defendant Fossett William yeoman 593230 593230 Fossett, William, of Houghton Regis, yeoman 0
4571653 2222710 2222710 defendant White Thomas   593230 593230 White, Thomas, of Houghton Regis 2
4571664 2222714 2222714 defendant White Thomas   593230 593230 together with White, Thomas, of Houghton Regis 2
4794582 2294446 2294446 plaintiff Porter Thomas   593230 593230 Porter, Thomas, of Houghton Regis 0
4819887 2302295 2302295 defendant Hambury William husbandman 593230 593230 Hambury, William, of Houghton Regis, husbandman 0
4873908 2318778 2318778 plaintiff Porter Thomas   593230 593230 Porter, Thomas, of Houghton Regis 0
4882720 2321512 2321512 defendant Carter Richard husbandman 593230 593230 Carter, Richard, of Houghton Regis, husbandman 0
4921948 2333271 2333271 defendant Hardyng William husbandman 593230 593230 Hardyng, William, of Houghton Regis, husbandman 0
4988030 2353390 2353390 defendant Hardyng William husbandman 593230 593230 Hardyng, William, of Houghton Regis, husbandman 0
5028643 2365253 2365253 defendant Graunt Ralph maltman 593230 593230 Graunt, Ralph, of Houghton Regis, maltman 0
5059231 2374326 2374326 defendant Walys William husbandman 593230 593230 Walys, William, of Houghton Regis, husbandman 0
5064918 2376039 2376039 defendant Hardyng William husbandman 593230 593230 Hardyng, William, of Houghton Regis, husbandman 0
5113560 2390356 2390356 defendant Whitacre William husbandman 593230 593230 Whitacre, William, of Houghton Regis, husbandman 0
5172053 2407541 2407541 defendant Gobion Richard husbandman 593230 593230 Gobion, Richard, of Houghton Regis, husbandman 1
5276451 2438186 2438186 defendant Bussh Thomas husbandman 593230 593230 Bussh, Thomas, of Houghton Regis, husbandman 1
5313262 2449003 2449003 defendant Davy William husbandman 593230 593230 Davy, William, of Houghton Regis, husbandman 3
5314039 2449220 2449220 defendant Carter Thomas yeoman 593230 593230 Carter, Thomas, of Houghton Regis, yeoman 3
5348616 2459698 2459698 defendant Eme John courser 593230 593230 Eme, John, of Houghton Regis, courser 1
5366383 2465136 2465136 defendant Haukyns John husbandman 593230 593230 Haukyns, John, of Houghton Regis, husbandman 2
5366387 2465137 2465137 defendant Haukyns John husbandman 593230 593230 Haukyns, John, of Houghton Regis, husbandman 2
5410270 2478023 2478023 defendant Cavy William   593230 593230 Cavy, William, of Houghton Regis 1
5415627 2479616 2479616 defendant Blissy John   593230 593230 Blissy, John, of Houghton Regis, husbandman, administrators of 0
5424045 2482144 2482144 defendant Davy William husbandman 593230 593230 Davy, William, of Houghton Regis, husbandman 1
5429271 2483683 2483683 defendant Borought John husbandman 593230 593230 Borought, John, of Houghton Regis, husbandman 0
5429272 2483683 2483683 defendant Baret Alexander husbandman 593230 593230 Baret, Alexander, of Houghton Regis, husbandman 1
5432022 2484545 2484545 defendant Blyffy or Blyssy John   593230 593230 Blyffy or Blyssy, John, of Houghton Regis, husbandman, administrators of 0
5455795 2491634 2491634 defendant Davy William husbandman 593230 593230 Davy, William, of Houghton Regis, husbandman 1
5467652 2495253 2495253 defendant Davy William husbandman 593230 593230 Davy, William, of Houghton Regis, husbandman 1
5467655 2495254 2495254 defendant Davy William husbandman 593230 593230 Davy, William, of Houghton Regis, husbandman 1
5479857 2498986 2498986 defendant Davy William husbandman 593230 593230 Davy, William, of Houghton Regis, husbandman 0
5546925 2519101 2519101 plaintiff Waleys John, senior   593230 593230 Waleys, John, senior, of Houghton Regis 0
5546926 2519101 2519101 plaintiff Haukyn or Hankyn John   593230 593230 Haukyn or Hankyn, John, of Houghton Regis 1
5604113 2536148 2536148 defendant Hardyng William husbandman 593230 593230 Hardyng, William, of Houghton Regis, husbandman 0
5628574 2552906 2552906 plaintiff Ploughwryght William   593230 593230 Ploughwryght, William, of Houghton Regis 0
5628578 2552907 2552907 plaintiff Ploughwryght William   593230 593230 Ploughwryght, William, of Houghton Regis 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);