names

56 rows where place_id = 593219

✎ 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
3610959 1871102 1871102 defendant Braunche William butcher 593219 593219 Braunche, William, of Okeley, butcher 0
3614722 1872252 1872252 defendant Haliok John husbandman 593219 593219 Haliok, John, of Okeley, husbandman 0
3659973 1913379 1913379 defendant Stokys William husbandman 593219 593219 Stokys, William, of Okeley, husbandman 0
3669449 1916383 1916383 defendant Shepperd John yeoman 593219 593219 Shepperd, John, of Okeley, yeoman 1
3673438 1917713 1917713 defendant Stokys William, junior husbandman 593219 593219 Stokys, William, junior, of Okeley, husbandman 2
3696821 1925229 1925229 defendant Stokys William, junior husbandman 593219 593219 Stokys, William, junior, of Okeley, husbandman 2
3729061 1935339 1935339 defendant Cave William husbandman 593219 593219 Cave, William, of Okeley, husbandman 0
3741669 1939262 1939262 plaintiff Stokys William husbandman 593219 593219 Stokys, William, of Okeley, husbandman 0
3744140 1940066 1940066 defendant Cave William husbandman 593219 593219 Cave, William, of Okeley, husbandman 0
3745744 1940570 1940570 defendant Adams Thomas husbandman 593219 593219 Adams, Thomas, of Okeley, husbandman 0
3758049 1944503 1944503 defendant Cavys William husbandman 593219 593219 Cavys, William, of Okeley, husbandman 0
3758051 1944503 1944503 defendant Clerk William husbandman 593219 593219 Clerk, William, of Okeley, husbandman 2
3758052 1944503 1944503 defendant Tayllour Richard husbandman 593219 593219 Tayllour, Richard, of Okeley, husbandman 3
3772253 1949008 1949008 defendant Coope William husbandman 593219 593219 Coope, William, of Okeley, husbandman 0
3772254 1949008 1949008 defendant Norwood William husbandman 593219 593219 Norwood, William, of Okeley, husbandman 1
3772256 1949009 1949009 defendant Cope William husbandman 593219 593219 Cope, William, of Okeley, husbandman 0
3772257 1949009 1949009 defendant Norwode William husbandman 593219 593219 Norwode, William, of Okeley, husbandman 1
3798201 1957334 1957334 defendant Mondye Thomas husbandman 593219 593219 Mondye, Thomas, of Okeley, husbandman 0
3816738 1963141 1963141 defendant Longhurst John husbandman 593219 593219 Longhurst, John, of Okeley, husbandman 0
3830750 1967501 1967501 defendant Norman John husbandman 593219 593219 Norman, John, of Okeley, husbandman 1
3833058 1968263 1968263 defendant Knyghtley John butcher 593219 593219 Knyghtley, John, of Okeley, butcher 1
3891251 1987340 1987340 defendant Morgan Christopher gent 593219 593219 Morgan, Christopher, of Okeley, gent 0
3932676 2001225 2001225 defendant Chitwud Robert gent 593219 593219 Chitwud, Robert, of Okeley, gent 0
3955936 2009145 2009145 defendant Stokes Thomas husbandman 593219 593219 Stokes, Thomas, of Okeley, husbandman 0
4021985 2032591 2032591 plaintiff Alnott Leonard yeoman 593219 593219 Alnott, Leonard, of Okeley, yeoman 0
4138118 2073998 2073998 defendant Tego John husbandman 593219 593219 Tego, John, of Okeley, husbandman 0
4168042 2084307 2084307 defendant Quyntyne William carpenter 593219 593219 Quyntyne, William, of Okeley, carpenter 0
4307612 2132800 2132800 defendant Prichard John clerk 593219 593219 Prichard, John, of Okeley, clerk 0
4327030 2139370 2139370 defendant Browne William husbandman 593219 593219 Browne, William, of Okeley, husbandman 0
4647251 2245251 2245251 defendant Legge John   593219 593219 Legge, John, of Okeley 0
4655413 2247586 2247586 defendant Hert Henry yeoman 593219 593219 Hert, Henry, of Okeley, yeoman 1
4659212 2248753 2248753 defendant Oxenden John ploughman 593219 593219 Oxenden, John, of Okeley, ploughman 0
4659213 2248753 2248753 defendant Abbot William tailor 593219 593219 Abbot, William, of Okeley, tailor 1
4894010 2324828 2324828 defendant Mason Alexander husbandman 593219 593219 Mason, Alexander, of Okeley, husbandman 0
4936154 2337707 2337707 defendant Wheler Robert carpenter 593219 593219 Wheler, Robert, of Okeley, carpenter 0
5099604 2386321 2386321 defendant Pydyngton Richard schoolmaster 593219 593219 Pydyngton, Richard, of Okeley, schoolmaster 0
5137888 2397593 2397593 defendant Petygrewe Nicholas yeoman 593219 593219 Petygrewe, Nicholas, of Okeley, yeoman 1
5244640 2428613 2428613 defendant Bole William husbandman 593219 593219 Bole, William, of Okeley, husbandman 10
5260630 2433453 2433453 defendant Longehurst Richard laborer 593219 593219 Longehurst, Richard, of Okeley, laborer 4
5260631 2433453 2433453 defendant Brygaunt William laborer 593219 593219 Brygaunt, William, of Okeley, laborer 5
5260632 2433453 2433453 defendant Whyte JOhn laborer 593219 593219 Whyte, JOhn, of Okeley, laborer 6
5260633 2433453 2433453 defendant Nye William, junior laborer 593219 593219 Nye, William, junior, of Okeley, laborer 7
5260634 2433453 2433453 defendant Nye Simon husbandman 593219 593219 Nye, Simon, of Okeley, husbandman 8
5260637 2433453 2433453 defendant Bourer Thomas wheeler 593219 593219 Bourer, Thomas, of Okeley, wheeler 11
5265521 2434979 2434979 defendant Wyttenstall Thomas   593219 593219 Wyttenstall, Thomas, of Okeley, yeoman, son of Wyttenstall, Thomas, of Bedulf 0
5269793 2436275 2436275 defendant Trynmyll John gent 593219 593219 Trynmyll, John, of Okeley, gent 0
5312803 2448857 2448857 defendant Hynwode Thomas husbandman 593219 593219 Hynwode, Thomas, of Okeley, husbandman 4
5353073 2461044 2461044 defendant Bayes John smith 593219 593219 Bayes, John, of Okeley, smith 2
5353079 2461045 2461045 defendant Bayes John smith 593219 593219 Bayes, John, of Okeley, smith 2
5491185 2502261 2502261 defendant Heth John husbandman 593219 593219 Heth, John, of Okeley, husbandman 2
5525056 2512427 2512427 defendant Wylcokke Thomas gent 593219 593219 Wylcokke, Thomas, of Okeley, gent 0
5534722 2515402 2515402 defendant Shepard William (legal representative) 593219 593219 Shepard, William, of Okeley, executors of 1
5534724 2515402 2515402 defendant Shepard John yeoman 593219 593219 Shepard, John, of Okeley, yeoman 3
5534725 2515402 2515402 defendant Shepard Hugh yeoman 593219 593219 Shepard, Hugh, of Okeley, yeoman 4
5534726 2515402 2515402 defendant Shepard Richard yeoman 593219 593219 Shepard, Richard, of Okeley, yeoman 5
5537988 2516371 2516371 defendant Fulcher Thomas husbandman 593219 593219 Fulcher, Thomas, of Okeley, 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);