names

73 rows where place_id = 591190

✎ 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
3603651 1868810 1868810 defendant Herward Thomas husbandman 591190 591190 Herward, Thomas, of South Creyk, husbandman 0
3606538 1869717 1869717 plaintiff Norton Richard, senior   591190 591190 Norton, Richard, senior, of South Creyk 0
3608562 1870334 1870334 defendant Felypp Richard husbandman 591190 591190 Felypp, Richard, of South Creyk, husbandman 3
3616678 1872846 1872846 defendant Herward Thomas butcher 591190 591190 Herward, Thomas, of South Creyk, butcher 0
3780970 1951781 1951781 defendant Norton Richard husbandman 591190 591190 Norton, Richard, of South Creyk, husbandman 0
4419009 2170810 2170810 plaintiff Athelwale John   591190 591190 Athelwale, John, of South Creyk 0
4534260 2210981 2210981 defendant Cayly Geoffrey   591190 591190 Cayly, Geoffrey, of South Creyk 0
4586655 2227238 2227238 defendant Swyngeldere John   591190 591190 Swyngeldere, John, of South Creyk 0
4606127 2233028 2233028 plaintiff Atthelwald Richard   591190 591190 Atthelwald, Richard, of South Creyk 0
4606128 2233028 2233028 defendant Hokere William   591190 591190 Hokere, William, of South Creyk 0
4606129 2233028 2233028 defendant Bakere John   591190 591190 Bakere, John, of South Creyk 1
4664430 2250355 2250355 plaintiff Harde Thomas   591190 591190 Harde, Thomas, of South Creyk 0
4699406 2265274 2265274 defendant Hard_ Thomas husbandman 591190 591190 Hard_, Thomas, of South Creyk, husbandman 0
4699407 2265274 2265274 defendant Auncell John husbandman 591190 591190 Auncell, John, of South Creyk, husbandman 1
4719289 2271380 2271380 defendant Norton Edmund husbandman 591190 591190 Norton, Edmund, of South Creyk, husbandman 1
4723821 2272754 2272754 defendant Hard Thomas husbandman 591190 591190 Hard, Thomas, of South Creyk, husbandman 0
4723822 2272754 2272754 defendant Auncell John husbandman 591190 591190 Auncell, John, of South Creyk, husbandman 1
4743705 2278688 2278688 defendant Craksheld James hoker or hocker 591190 591190 Craksheld, James, of South Creyk, hoker or hocker 0
4765743 2285281 2285281 defendant Pakke Henry reeder 591190 591190 Pakke, Henry, of South Creyk, reeder 1
4813963 2300477 2300477 defendant Brimston William husbandman 591190 591190 Brimston, William, of South Creyk, husbandman 5
4820182 2302384 2302384 defendant Hoker James yeoman 591190 591190 Hoker, James, of South Creyk, yeoman 1
4854999 2312917 2312917 defendant Lesse John husbandman 591190 591190 Lesse, John, of South Creyk, husbandman 0
4912816 2330505 2330505 plaintiff Leg John   591190 591190 Leg, John, of South Creyk 2
4928982 2335491 2335491 defendant Harde William yeoman 591190 591190 Harde, William, of South Creyk, yeoman 0
4933938 2336992 2336992 defendant Andrewe John yeoman 591190 591190 (Andrewe, John, of South Creyk, yeoman 1
4947250 2341129 2341129 plaintiff Leg John   591190 591190 Leg, John, of South Creyk 0
4960585 2345132 2345132 defendant Congham Reginald husbandman 591190 591190 Congham, Reginald, of South Creyk, husbandman 0
4968673 2347598 2347598 defendant Legge John gent 591190 591190 Legge, John, of South Creyk, gent 0
4988984 2353642 2353642 defendant Harde William husbandman 591190 591190 Harde, William, of South Creyk, husbandman 6
4996170 2355710 2355710 defendant Cok John baker 591190 591190 Cok, John, of South Creyk, baker 0
4998277 2356354 2356354 defendant Harde William yeoman 591190 591190 Harde, William, of South Creyk, yeoman 1
5000634 2357055 2357055 defendant Cok John husbandman 591190 591190 Cok, John, of South Creyk, husbandman 0
5045671 2370340 2370340 plaintiff Legge John   591190 591190 Legge, John, of South Creyk 0
5089203 2383212 2383212 defendant Harde Bartholomew woolman 591190 591190 Harde, Bartholomew, of South Creyk, woolman 0
5129424 2395092 2395092 defendant Sheryngham Richard smith 591190 591190 Sheryngham, Richard, of South Creyk, smith 1
5148712 2400746 2400746 defendant Sheryngham Richard smith 591190 591190 Sheryngham, Richard, of South Creyk, smith 1
5151978 2401714 2401714 plaintiff Hard John gent 591190 591190 Hard, John, of South Creyk, gent 0
5151979 2401714 2401714 defendant Hard Bartholomew yeoman 591190 591190 Hard, Bartholomew, of South Creyk, yeoman 0
5163819 2405154 2405154 defendant Leg John gent 591190 591190 Leg, John, of South Creyk, gent 0
5167920 2406328 2406328 defendant Sheryngham Richard smith 591190 591190 Sheryngham, Richard, of South Creyk, smith 1
5169946 2406940 2406940 defendant Herman Henry husbandman 591190 591190 Herman, Henry, of South Creyk, husbandman 0
5178460 2409408 2409408 plaintiff Auntell John   591190 591190 Auntell, John, of South Creyk 0
5178461 2409408 2409408 defendant Lyne John husbandman 591190 591190 Lyne, John, of South Creyk, husbandman 0
5183623 2410944 2410944 defendant Sheryngham Richard smith 591190 591190 Sheryngham, Richard, of South Creyk, smith 1
5193136 2413723 2413723 defendant Harde Bartholomew yeoman 591190 591190 Harde, Bartholomew, of South Creyk, yeoman 0
5230438 2424519 2424519 defendant Harde William yeoman 591190 591190 Harde, William, of South Creyk, yeoman 0
5230439 2424519 2424519 defendant Sheryngham Richard smith 591190 591190 Sheryngham, Richard, of South Creyk, smith 1
5252573 2430919 2430919 defendant Batayll Margery widow 591190 591190 Batayll, Margery, of South Creyk, widow 0
5252575 2430920 2430920 defendant Batayll Margery widow 591190 591190 Batayll, Margery, of South Creyk,widow 0
5252577 2430921 2430921 defendant Batayll Margery widow 591190 591190 Batayll, Margery, of South Creyk, widow 0
5256960 2432308 2432308 defendant Hard Bartholomew   591190 591190 Hard, Bartholomew, of South Creyk, wool chapman 0
5258675 2432835 2432835 defendant Crane John husbandman 591190 591190 Crane, John, of South Creyk, husbandman 0
5265802 2435055 2435055 defendant Sheryngham Richard smith 591190 591190 Sheryngham, Richard, of South Creyk, smith 1
5299575 2444847 2444847 defendant Smyth Richard husbandman 591190 591190 Smyth, Richard, of South Creyk, husbandman 4
5301123 2445292 2445292 defendant Boled Richard yeoman 591190 591190 Boled, Richard, of South Creyk, yeoman 0
5301124 2445292 2445292 defendant Bolter William clerk 591190 591190 Bolter, William, of South Creyk, clerk 1
5301125 2445292 2445292 defendant Bolter William   591190 591190 Bolter, William, of South Creyk, son of Richard 2
5307442 2447236 2447236 defendant Hakforth Thomas yeoman 591190 591190 Hakforth, Thomas, of South Creyk, yeoman 0
5337768 2456372 2456372 defendant Cok John   591190 591190 Cok, John, of South Creyk, shepherd 0
5344046 2458316 2458316 defendant Sheryngham Richard smith 591190 591190 Sheryngham, Richard, of South Creyk, smith 0
5422843 2481786 2481786 defendant Crane William clerk 591190 591190 Crane, William, of South Creyk, clerk 0
5422846 2481787 2481787 defendant Shyryngham Richard husbandman 591190 591190 Shyryngham, Richard, of South Creyk, husbandman 0
5474946 2497489 2497489 defendant Brenetour John smith 591190 591190 Brenetour, John, of South Creyk, smith 1
5491539 2502354 2502354 defendant Denys Edmund husbandman 591190 591190 Denys, Edmund, of South Creyk, husbandman 0
5491541 2502355 2502355 defendant Fysk Robert husbandman 591190 591190 Fysk, Robert, of South Creyk, husbandman 0
5499916 2504930 2504930 defendant Fyske Robert husbandman 591190 591190 Fyske, Robert, of South Creyk, husbandman 0
5513266 2508998 2508998 plaintiff Norton John   591190 591190 Norton, John, of South Creyk 0
5513268 2508999 2508999 plaintiff Norton John   591190 591190 Norton, John, of South Creyk 0
5576577 2527723 2527723 defendant Norton John (legal representative) 591190 591190 Norton, John, of South Creyk, executors of 0
5576578 2527723 2527723 defendant Norton John clerk 591190 591190 (Norton, John, of South Creyk, clerk 1
5576579 2527723 2527723 defendant Wase John chaplain 591190 591190 Wase, John, of South Creyk, chaplain 2
5627321 2552512 2552512 plaintiff Athelwald Richard   591190 591190 Athelwald, Richard, of South Creyk 1
5627326 2552512 2552512 defendant Barkere John yeoman 591190 591190 Barkere, John, of South Creyk, yeoman 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);