names

54 rows where place_id = 595782

✎ 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
3621864 1874380 1874380 defendant Broket John smith 595782 595782 Broket, John, of Dorkyng, Surrey, smith 0
3621866 1874381 1874381 defendant Broket John smith 595782 595782 Broket, John, of Dorkyng, Surrey, smith 0
3631661 1904715 1904715 defendant Elyott William yeoman 595782 595782 Elyott, William, of Dorkyng, Surrey, yeoman 1
3648958 1910061 1910061 defendant Gye William weaver 595782 595782 Gye, William, of Dorkyng, Surrey, weaver 2
3718450 1932050 1932050 defendant Warde Robert yeoman 595782 595782 Warde, Robert, of Dorkyng, Surrey, yeoman 0
3758947 1944790 1944790 defendant Wonham Robert husbandman 595782 595782 Wonham, Robert, of Dorkyng, Surrey, husbandman 0
3841162 1970814 1970814 defendant Dalton Christopher yeoman 595782 595782 Dalton, Christopher, of Dorkyng, Surrey, yeoman 1
3873718 1981427 1981427 defendant Dalton Christopher yeoman 595782 595782 Dalton, Christopher, of Dorkyng, Surrey, yeoman 0
3923669 1998229 1998229 defendant Staplehurst John husbandman 595782 595782 Staplehurst, John, of Dorkyng, Surrey, husbandman 0
3969494 2013938 2013938 defendant Constabill Thomas yeoman 595782 595782 Constabill, Thomas, of Dorkyng, Surrey, yeoman 0
3987973 2020446 2020446 defendant Butt William gent 595782 595782 Butt, William, of Dorkyng, Surrey, gent 0
4232564 2106892 2106892 defendant Gaynsford Eleanor widow 595782 595782 Gaynsford, Eleanor, of Dorkyng, Surrey, widow 0
4719812 2271542 2271542 defendant Moigne Henry esq 595782 595782 Moigne, Henry, of Dorkyng, Surrey, esq 0
4775870 2288454 2288454 defendant Bole William tailor 595782 595782 Bole, William, of Dorkyng, Surrey, tailor 0
4848111 2310879 2310879 defendant Becche Thomas yeoman 595782 595782 Becche, Thomas, of Dorkyng, Surrey, yeoman 0
4866863 2316600 2316600 defendant Swan David gent 595782 595782 Swan, David, of Dorkyng, Surrey, gent 0
4866867 2316601 2316601 defendant Swan David gent 595782 595782 Swan, David, of Dorkyng, Surrey, gent 0
4872969 2318503 2318503 defendant Hiller Robert laborer 595782 595782 Hiller, Robert, of Dorkyng, Surrey, laborer 1
4880736 2320885 2320885 defendant Bole William tailor 595782 595782 Bole, William, of Dorkyng, Surrey, tailor 0
4933578 2336882 2336882 defendant Asshe William gent 595782 595782 Asshe, William, of Dorkyng, Surrey, gent 1
4944514 2340264 2340264 defendant Sonde Edward gent 595782 595782 Sonde, Edward, of Dorkyng, Surrey, gent 0
4944516 2340265 2340265 defendant Sonde Edward gent 595782 595782 Sonde, Edward, of Dorkyng, Surrey, gent 0
4973280 2348945 2348945 defendant Assherst Thomas gent 595782 595782 Assherst, Thomas, of Dorkyng, Surrey, gent 0
4983366 2351931 2351931 defendant Tanner John husbandman 595782 595782 Tanner, John, of Dorkyng, Surrey, husbandman 0
4995907 2355624 2355624 defendant Turnour William chapman 595782 595782 Turnour, William, of Dorkyng, Surrey, chapman 0
4996802 2355900 2355900 defendant Compton Nicholas smith 595782 595782 Compton, Nicholas, of Dorkyng, Surrey, smith 2
4996807 2355901 2355901 defendant Compton Nicholas smith 595782 595782 Compton, Nicholas, of Dorkyng, Surrey, smith 2
5025276 2364287 2364287 defendant Tanner John husbandman 595782 595782 Tanner, John, of Dorkyng, Surrey, husbandman 1
5025285 2364289 2364289 defendant Tanner John husbandman 595782 595782 Tanner, John, of Dorkyng, Surrey, husbandman 1
5055607 2373252 2373252 defendant Redford William husbandman 595782 595782 Redford, William, of Dorkyng, Surrey, husbandman 2
5055614 2373253 2373253 defendant Redford William husbandman 595782 595782 Redford, William, of Dorkyng, Surrey, husbandman 2
5058368 2374048 2374048 defendant atte Dene Avice widow 595782 595782 atte Dene, Avice, of Dorkyng, Surrey, widow 3
5090778 2383693 2383693 defendant Godenowe alias Turnour William chapman 595782 595782 Godenowe alias Turnour, William, of Dorkyng, Surrey, chapman 0
5105073 2387918 2387918 defendant Sonde Henry gent 595782 595782 Sonde, Henry, of Dorkyng, Surrey, gent 0
5105889 2388163 2388163 defendant Broket Richard smith 595782 595782 Broket, Richard, of Dorkyng, Surrey, smith 0
5105920 2388171 2388171 defendant Stapeler Richard husbandman 595782 595782 Stapeler, Richard, of Dorkyng, Surrey, husbandman 1
5184548 2411225 2411225 defendant Usward Richard husbandman 595782 595782 Usward, Richard, of Dorkyng, Surrey, husbandman 0
5246952 2429274 2429274 defendant Lyncon Robert (legal representative) 595782 595782 Lyncon, Robert, of Dorkyng, Surrey, yeoman, executors of 0
5260755 2433485 2433485 defendant Bryggys Richard yeoman 595782 595782 Bryggys, Richard, of Dorkyng, Surrey, yeoman 0
5260757 2433486 2433486 defendant Bryggys Richard yeoman 595782 595782 Bryggys, Richard, of Dorkyng, Surrey, yeoman 0
5282734 2440009 2440009 defendant Warde John chapman 595782 595782 Warde, John, of Dorkyng, Surrey, chapman 3
5283565 2440246 2440246 defendant Godman John yeoman 595782 595782 Godman, John, of Dorkyng, Surrey, yeoman 3
5331600 2454531 2454531 defendant Carpenter Henry yeoman 595782 595782 Carpenter, Henry, of Dorkyng, Surrey, yeoman 0
5331604 2454532 2454532 defendant Carpenter Henry yeoman 595782 595782 Carpenter, Henry, of Dorkyng, Surrey, yeoman 2
5332893 2454904 2454904 defendant Brokette Richard smith 595782 595782 Brokette, Richard, of Dorkyng, Surrey, smith 1
5332899 2454905 2454905 defendant Brokette Richard smith 595782 595782 Brokette, Richard, of Dorkyng, Surrey, smith 1
5343050 2458013 2458013 defendant Carre or Cane Peter chapman 595782 595782 Carre or Cane, Peter, of Dorkyng, Surrey, chapman 0
5344764 2458530 2458530 defendant Carpynter Henry yeoman 595782 595782 Carpynter, Henry, of Dorkyng, Surrey, yeoman 0
5501651 2505448 2505448 defendant Burnell John yeoman 595782 595782 Burnell, John, of Dorkyng, Surrey, yeoman 1
5509613 2507839 2507839 defendant Mannyng Thomas chapman 595782 595782 Mannyng, Thomas, of Dorkyng, Surrey, chapman 3
5536936 2516040 2516040 defendant Elyot William chapman 595782 595782 Elyot, William, of Dorkyng, Surrey, chapman 2
5563349 2523876 2523876 defendant Elyott William yeoman 595782 595782 Elyott, William, of Dorkyng, Surrey, yeoman 3
5583200 2529822 2529822 defendant North William husbandman 595782 595782 North, William, of Dorkyng, Surrey, husbandman 0
5583203 2529823 2529823 defendant North William husbandman 595782 595782 North, William, of Dorkyng, Surrey, husbandman 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);