names

73 rows where place_id = 601066

✎ 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
3643732 1908466 1908466 defendant Ilger Robert husbandman 601066 601066 Ilger, Robert, of Depden, husbandman 5
3657614 1912643 1912643 defendant Chekold Peter laborer 601066 601066 Chekold, Peter, of Depden, laborer 6
3657623 1912644 1912644 defendant Chekold Peter laborer 601066 601066 Chekold, Peter, of Depden, laborer 6
3667583 1915804 1915804 defendant Sparowe Richard laborer 601066 601066 Sparowe, Richard, of Depden, laborer 1
3693253 1924099 1924099 defendant Fynks Thomas   601066 601066 Fynks, Thomas, of Depden, brick maker 3
3694501 1924486 1924486 defendant Rutter William husbandman 601066 601066 Rutter, William, of Depden, husbandman 1
3694502 1924486 1924486 defendant Tyler John husbandman 601066 601066 Tyler, John, of Depden, husbandman 2
3708458 1928945 1928945 defendant Tyler John husbandman 601066 601066 Tyler, John, of Depden, husbandman 2
3708461 1928946 1928946 defendant Tyler John husbandman 601066 601066 Tyler, John, of Depden, husbandman 1
3709689 1929342 1929342 defendant Sparowe Henry husbandman 601066 601066 Sparowe, Henry, of Depden, husbandman 0
3716931 1931583 1931583 defendant Cryspe William husbandman 601066 601066 Cryspe, William, of Depden, husbandman 0
3716932 1931583 1931583 defendant Sparowe Robert husbandman 601066 601066 Sparowe, Robert, of Depden, husbandman 1
3717587 1931794 1931794 defendant Cryspe Robert husbandman 601066 601066 Cryspe, Robert, of Depden, husbandman 3
3721278 1932960 1932960 defendant Croydon John smith 601066 601066 Croydon, John, of Depden, smith 4
3733205 1936617 1936617 defendant Jecold Peter husbandman 601066 601066 Jecold, Peter, of Depden, husbandman 2
3756283 1943927 1943927 defendant Gogyn William yeoman 601066 601066 Gogyn, William, of Depden, yeoman 0
3756975 1944159 1944159 defendant Parkyn Robert carpenter 601066 601066 Parkyn, Robert, of Depden, carpenter 1
3772324 1949030 1949030 defendant Gogyn William yeoman 601066 601066 Gogyn, William, of Depden, yeoman 0
3779085 1951185 1951185 defendant Parkyn Thomas collier 601066 601066 Parkyn, Thomas, of Depden, collier 1
3784655 1952987 1952987 defendant Broun John laborer 601066 601066 Broun, John, of Depden, laborer 0
3784657 1952987 1952987 defendant Lylford John husbandman 601066 601066 Lylford, John, of Depden, husbandman 2
3790198 1954752 1954752 defendant Gooday John husbandman 601066 601066 Gooday, John, of Depden, husbandman 3
3891162 1987311 1987311 defendant Overhall Thomas husbandman 601066 601066 Overhall, Thomas, of Depden, husbandman 1
3925270 1998763 1998763 defendant Woode Richard butcher 601066 601066 Woode, Richard, of Depden, butcher 1
3967035 2013096 2013096 plaintiff Browne John yeoman 601066 601066 Browne, John, of Depden, yeoman 0
3967036 2013096 2013096 defendant Colman John yeoman 601066 601066 Colman, John, of Depden, yeoman 0
4010190 2028411 2028411 defendant Hamunde Richard husbandman 601066 601066 Hamunde, Richard, of Depden, husbandman 0
4010191 2028411 2028411 defendant Peperton alias Clarke John husbandman 601066 601066 Peperton alias Clarke, John, of Depden, husbandman 1
4052655 2043375 2043375 defendant Hancock Robert clerk 601066 601066 Hancock, Robert, of Depden, clerk 1
4134318 2072602 2072602 defendant Wright Nicholas husbandman 601066 601066 Wright, Nicholas, of Depden, husbandman 0
4247392 2112106 2112106 defendant Hamond Edmund yeoman 601066 601066 Hamond, Edmund, of Depden, yeoman 0
4401079 2164955 2164955 defendant Hockley George husbandman 601066 601066 Hockley, George, of Depden, husbandman 0
4401080 2164955 2164955 defendant Joslyn Thomas   601066 601066 Joslyn, Thomas, of Depden 1
4648694 2245673 2245673 defendant Sergeant Joan   601066 601066 Sergeant, Joan, of Depden, formerly wife of Robert 0
4658560 2248554 2248554 defendant Smyth John husbandman 601066 601066 Smyth, John, of Depden, husbandman 0
4726139 2273463 2273463 defendant Aylesward William husbandman 601066 601066 Aylesward, William, of Depden, husbandman 1
4754046 2281647 2281647 defendant Fuller Walter yeoman 601066 601066 Fuller, Walter, of Depden, yeoman 0
4814797 2300741 2300741 defendant Knyth John chaplain 601066 601066 Knyth, John, of Depden, chaplain 0
4832805 2306280 2306280 defendant Goodwen John yeoman 601066 601066 Goodwen, John, of Depden, yeoman 0
4832808 2306281 2306281 defendant Goodwen John yeoman 601066 601066 Goodwen, John, of Depden, yeoman 0
4840069 2308444 2308444 defendant Goodwen John yeoman 601066 601066 Goodwen, John, of Depden, yeoman 0
4840071 2308445 2308445 defendant Goodwen John yeoman 601066 601066 Goodwen, John, of Depden, yeoman 0
4871054 2317922 2317922 defendant Osteler Richard husbandman 601066 601066 Osteler, Richard, of Depden, husbandman 3
4873000 2318514 2318514 defendant Antons John laborer 601066 601066 Antons, John, of Depden, laborer 0
4906414 2328593 2328593 defendant Turnour John husbandman 601066 601066 Turnour, John, of Depden, husbandman 3
5054222 2372853 2372853 defendant Sergeant Thomas husbandman 601066 601066 Sergeant, Thomas, of Depden, husbandman 0
5058892 2374226 2374226 defendant Sergeaunt Thomas husbandman 601066 601066 Sergeaunt, Thomas, of Depden, husbandman 0
5222454 2422280 2422280 defendant Walter John clerk 601066 601066 Walter, John, of Depden, clerk 0
5222456 2422281 2422281 defendant Walter John clerk 601066 601066 Walter, John, of Depden, clerk 0
5233659 2425430 2425430 defendant Jolons John husbandman 601066 601066 Jolons, John, of Depden, husbandman 1
5233660 2425430 2425430 defendant Martyn Nicholas husbandman 601066 601066 Martyn, Nicholas, of Depden, husbandman 2
5259321 2433034 2433034 defendant Palmer William husbandman 601066 601066 Palmer, William, of Depden, husbandman 3
5304370 2446305 2446305 defendant Wryght William yeoman 601066 601066 Wryght, William, of Depden, yeoman 0
5305782 2446737 2446737 defendant Duntley Henry clerk 601066 601066 Duntley, Henry, of Depden, clerk 0
5311327 2448417 2448417 defendant Holt Thomas   601066 601066 Holt, Thomas, of Depden, yeoman, son & heir of John, Holt, formerly of Depden 0
5327449 2453281 2453281 defendant Wode John, junior husbandman 601066 601066 Wode, John, junior, of Depden, husbandman 0
5331193 2454404 2454404 defendant Holte Thomas husbandman 601066 601066 Holte, Thomas, of Depden, husbandman 0
5375170 2467822 2467822 defendant Goldwyn Lawrence tailor 601066 601066 Goldwyn, Lawrence, of Depden, tailor 2
5384293 2470592 2470592 defendant Strut Thomas husbandman 601066 601066 Strut, Thomas, of Depden, husbandman 3
5394764 2473570 2473570 plaintiff Wryght William   601066 601066 Wryght, William, of Depden 0
5396092 2473966 2473966 defendant Strices Thomas husbandman 601066 601066 Strices, Thomas, of Depden, husbandman 3
5407994 2477368 2477368 plaintiff Wryght William   601066 601066 Wryght, William, of Depden 0
5407998 2477368 2477368 defendant Martyn Nicholas husbandman 601066 601066 Martyn, Nicholas, of Depden, husbandman 3
5407999 2477369 2477369 plaintiff Wryght William   601066 601066 Wryght, William, of Depden 0
5408003 2477369 2477369 defendant Martyn Nicholas husbandman 601066 601066 Martyn, Nicholas, of Depden, husbandman 3
5408004 2477370 2477370 plaintiff Wryght William   601066 601066 Wryght, William, of Depden 0
5408009 2477370 2477370 defendant Martyn Nicholas husbandman 601066 601066 Martyn, Nicholas, of Depden, husbandman 4
5409388 2477775 2477775 defendant Strut Thomas husbandman 601066 601066 Strut, Thomas, of Depden, husbandman 3
5422908 2481806 2481806 defendant Strut Thomas husbandman 601066 601066 Strut, Thomas, of Depden, husbandman 2
5590106 2531886 2531886 defendant Bener or Bever John   601066 601066 Bener or Bever, John, of Depden 1
5593427 2532926 2532926 defendant Gogyn William husbandman 601066 601066 Gogyn, William, of Depden, husbandman 1
5603024 2535831 2535831 defendant Totenham Roger laborer 601066 601066 Totenham, Roger, of Depden, laborer 0
5607497 2537240 2537240 defendant Sexten John husbandman 601066 601066 Sexten, John, of Depden, husbandman 1

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);