names

74 rows where place_id = 596369

✎ 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
3624462 1875186 1875186 defendant Rosyngdale Richard clerk 596369 596369 Rosyngdale, Richard, of Haselyngfeld, clerk 0
3632257 1904907 1904907 defendant Adcok John miller 596369 596369 Adcok, John, of Haselyngfeld, miller 0
3634239 1905506 1905506 defendant Turpyn John yeoman 596369 596369 Turpyn, John, of Haselyngfeld, yeoman 3
3643502 1908397 1908397 defendant Bugge John husbandman 596369 596369 Bugge, John, of Haselyngfeld, husbandman 1
3652473 1911104 1911104 defendant Tomlynson John husbandman 596369 596369 Tomlynson, John, of Haselyngfeld, husbandman 3
3665492 1915158 1915158 defendant White William husbandman 596369 596369 White, William, of Haselyngfeld, husbandman 1
3665493 1915158 1915158 defendant Austen William husbandman 596369 596369 Austen, William, of Haselyngfeld, husbandman 2
3724886 1934069 1934069 defendant Asshe John tailor 596369 596369 Asshe, John, of Haselyngfeld, tailor 1
3790490 1954848 1954848 defendant Kyng William laborer 596369 596369 Kyng, William, of Haselyngfeld, laborer 3
3794185 1956052 1956052 defendant Crakke John yeoman 596369 596369 Crakke, John, of Haselyngfeld, yeoman 0
3808950 1960681 1960681 defendant Crakke John husbandman 596369 596369 Crakke, John, of Haselyngfeld, husbandman 0
4303964 2131519 2131519 defendant Stedman Robert husbandman 596369 596369 Stedman, Robert, of Haselyngfeld, husbandman 7
4437703 2176549 2176549 plaintiff Yonge Alice   596369 596369 Yonge, Alice, of Haselyngfeld, formerly wife of Walter Yonge, son of William Yonge 0
4437704 2176549 2176549 defendant Hubert Walter   596369 596369 Hubert, Walter, of Haselyngfeld 0
4468382 2190776 2190776 defendant Roun Richard   596369 596369 Roun, Richard, of Haselyngfeld 2
4483021 2195385 2195385 defendant Feltwell Agnes   596369 596369 Feltwell, Agnes, of Haselyngfeld 0
4487766 2196892 2196892 defendant Feltwell Joan   596369 596369 Feltwell, Joan, of Haselyngfeld, formerly wife of Richard Feltwell 0
4487767 2196892 2196892 defendant Ba-- John   596369 596369 Ba--, John, of of Haselyngfeld 1
4563666 2220202 2220202 plaintiff Rolat Thomas   596369 596369 Rolat, Thomas, of Haselyngfeld 0
4602476 2231996 2231996 defendant Fullere Richard   596369 596369 Fullere, Richard, of Haselyngfeld 0
4602478 2231997 2231997 defendant Fullere Richard   596369 596369 Fullere, Richard, of Haselyngfeld 0
4632148 2240934 2240934 defendant Haselwode John   596369 596369 Haselwode, John, of Haselyngfeld 0
4649173 2245808 2245808 defendant Hasilwode John smith 596369 596369 Hasilwode, John, of Haselyngfeld, smith 1
4651355 2246425 2246425 plaintiff Amys Geoffrey   596369 596369 Amys, Geoffrey, of Haselyngfeld 0
4693413 2263440 2263440 defendant Parkere John chapman 596369 596369 Parkere, John, of Haselyngfeld, chapman 0
4749836 2280427 2280427 plaintiff Person William   596369 596369 Person, William, of Haselyngfeld, vicar 0
4772963 2287515 2287515 defendant Parker John chapman 596369 596369 Parker, John, of Haselyngfeld, chapman 0
4798213 2295636 2295636 defendant Parker John chapman 596369 596369 Parker, John, of Haselyngfeld, chapman 0
4834185 2306702 2306702 defendant Outlawe Thomas   596369 596369 Outlawe, Thomas, of Haselyngfeld 1
4851835 2312010 2312010 defendant Spryng John husbandman 596369 596369 Spryng, John, of Haselyngfeld, husbandman 0
4908995 2329357 2329357 defendant Aleyn Robert husbandman 596369 596369 Aleyn, Robert, of Haselyngfeld, husbandman 0
4908996 2329357 2329357 defendant Deyne John laborer 596369 596369 Deyne, John, of Haselyngfeld, laborer 1
4908997 2329357 2329357 defendant Aleyn John thatcher 596369 596369 Aleyn, John, of Haselyngfeld, thatcher 2
4908998 2329357 2329357 defendant Kechyn Richard laborer 596369 596369 Kechyn, Richard, of Haselyngfeld, laborer 3
4920525 2332933 2332933 defendant Baron William   596369 596369 Baron, William, of Haselyngfeld, servant 2
4920526 2332933 2332933 defendant Prisot Jhn gent 596369 596369 with Prisot, Jhn, of Haselyngfeld, gent 3
4920528 2332933 2332933 defendant Aleyn Robert husbandman 596369 596369 Aleyn, Robert, of Haselyngfeld, husbandman 5
4920531 2332934 2332934 defendant Prysot John gent 596369 596369 Prysot, John, of Haselyngfeld, gent 0
4920533 2332934 2332934 defendant Aleyn Robert husbandman 596369 596369 Aleyn, Robert, of Haselyngfeld, husbandman 2
4920536 2332934 2332934 defendant Baron William   596369 596369 Baron, William, of Haselyngfeld, servant 5
4921299 2333172 2333172 defendant By William husbandman 596369 596369 By, William, of Haselyngfeld, husbandman 1
4927898 2335161 2335161 defendant Parker Richard husbandman 596369 596369 Parker, Richard, of Haselyngfeld, husbandman 0
4927901 2335161 2335161 defendant Amys William husbandman 596369 596369 Amys, William, of Haselyngfeld, husbandman 3
4939494 2338737 2338737 defendant Owtelawe Thomas yeoman 596369 596369 Owtelawe, Thomas, of Haselyngfeld, yeoman 0
4941104 2339239 2339239 defendant Outlawe Thomas gent 596369 596369 Outlawe, Thomas, of Haselyngfeld, gent 0
4942993 2339786 2339786 defendant Parker John, senior husbandman 596369 596369 Parker, John, senior, of Haselyngfeld, husbandman 1
4946139 2340777 2340777 defendant Prysot John gent 596369 596369 Prysot, John, of Haselyngfeld, gent 0
4946141 2340777 2340777 defendant Aleyn Robert husbandman 596369 596369 Aleyn, Robert, of Haselyngfeld, husbandman 2
4946144 2340777 2340777 defendant Baron William   596369 596369 Baron, William, of Haselyngfeld, servant 5
4946801 2341002 2341002 defendant Dys William husbandman 596369 596369 Dys, William, of Haselyngfeld, husbandman 1
4954243 2343242 2343242 defendant Outelawe Thomas husbandman 596369 596369 Outelawe, Thomas, of Haselyngfeld, husbandman 0
4961197 2345314 2345314 defendant Brygge John yeoman 596369 596369 Brygge, John, of Haselyngfeld, yeoman 0
4962897 2345818 2345818 defendant Grygge John yeoman 596369 596369 Grygge, John, of Haselyngfeld, yeoman 0
4966256 2346840 2346840 defendant Outelawe Thomas gent 596369 596369 Outelawe, Thomas, of Haselyngfeld, gent 0
4966257 2346840 2346840 defendant Ey Thomas husbandman 596369 596369 Ey, Thomas, of Haselyngfeld, husbandman 1
4966260 2346841 2346841 defendant Outelawe Thomas gent 596369 596369 Outelawe, Thomas, of Haselyngfeld, gent 0
4966261 2346841 2346841 defendant Gy Thomas husbandman 596369 596369 Gy, Thomas, of Haselyngfeld, husbandman 1
4980561 2351127 2351127 defendant Outelawe Thomas gent 596369 596369 Outelawe, Thomas, of Haselyngfeld, gent 0
4991488 2354339 2354339 defendant Bye William   596369 596369 Bye, William, of Haselyngfeld 0
5120366 2392383 2392383 defendant Parcour Richard husbandman 596369 596369 Parcour, Richard, of Haselyngfeld, husbandman 3
5200925 2416037 2416037 defendant By William, sen husbandman 596369 596369 By, William, sen, of Haselyngfeld, husbandman 1
5216240 2420486 2420486 defendant Prysot Richard husbandman 596369 596369 Prysot, Richard, of Haselyngfeld, husbandman 3
5239597 2427167 2427167 defendant By William husbandman 596369 596369 By, William, of Haselyngfeld, husbandman 0
5239598 2427167 2427167 defendant Rawelyn Richard husbandman 596369 596369 Rawelyn, Richard, of Haselyngfeld, husbandman 1
5521776 2511625 2511625 defendant Hatle Richard smith 596369 596369 Hatle, Richard, of Haselyngfeld, smith 1
5557653 2522195 2522195 defendant Alkyn Thomas husbansdman 596369 596369 Alkyn, Thomas, of Haselyngfeld, husbansdman 2
5577508 2528027 2528027 defendant Wyth William husbandman 596369 596369 Wyth, William, of Haselyngfeld, husbandman 0
5577509 2528027 2528027 defendant Hatley Ralph smith 596369 596369 Hatley, Ralph, of Haselyngfeld, smith 1
5577510 2528027 2528027 defendant Borowe Lawrence laborer 596369 596369 Borowe, Lawrence, of Haselyngfeld, laborer 2
5607602 2537274 2537274 defendant Amys John husbandman 596369 596369 Amys, John, of Haselyngfeld, husbandman 1
5609887 2546798 2546798 plaintiff Amys Geoffery   596369 596369 Amys, Geoffery, of Haselyngfeld 0
5609889 2546799 2546799 plaintiff Amys Geoffery   596369 596369 Amys, Geoffery, of Haselyngfeld 0
5609890 2546799 2546799 defendant Thurbern Peter   596369 596369 Thurbern, Peter, of Haselyngfeld 0
5629391 2553175 2553175 defendant Blaston John butcher 596369 596369 Blaston, John, of Haselyngfeld, butcher 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);