names

48 rows where place_id = 614731

✎ 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
3705220 1927917 1927917 defendant Medlond Elias husbandman 614731 614731 Medlond, Elias, of Parkham, husbandman 0
3705221 1927917 1927917 defendant Horne Jencia husbandman 614731 614731 Horne, Jencia, of Parkham, husbandman 1
3705222 1927917 1927917 defendant Seller John husbandman 614731 614731 Seller, John, of Parkham, husbandman 2
3720254 1932611 1932611 defendant Morcombe Richard husbandman 614731 614731 Morcombe, Richard, of Parkham, husbandman 0
3720255 1932611 1932611 defendant Sheperd John husbandman 614731 614731 Sheperd, John, of Parkham, husbandman 1
3735032 1937194 1937194 defendant Medlon James husbandman 614731 614731 Medlon, James, of Parkham, husbandman 0
3984068 2019070 2019070 plaintiff Strowde Robert (legal representative) 614731 614731 Strowde, Robert, of Parkham, esq, executor of 0
3987122 2020140 2020140 plaintiff Wright William (legal representative) 614731 614731 Wright, William, of Parkham, executrix of 0
4046921 2041352 2041352 defendant Medland Robert husbandman 614731 614731 Medland, Robert, of Parkham, husbandman 0
4046923 2041353 2041353 defendant Pawe John husbandman 614731 614731 Pawe, John, of Parkham, husbandman 0
4046925 2041354 2041354 defendant Symon John husbandman 614731 614731 Symon, John, of Parkham, husbandman 0
4080990 2053517 2053517 defendant Gay Alice widow 614731 614731 Gay, Alice, of Parkham, or of Goldworthie, widow 0
4219374 2102275 2102275 defendant Chinge John smith 614731 614731 Chinge, John, of Parkham, smith 0
4390691 2161498 2161498 defendant Weekes Richard gent 614731 614731 Weekes, Richard, of Parkham, gent 0
4450495 2185119 2185119 defendant Frenssh William   614731 614731 Frenssh, William, of Parkham 3
4550717 2216168 2216168 defendant Taillour John   614731 614731 Taillour, John, of Parkham 0
4596343 2230109 2230109 defendant Fouke John (legal representative) 614731 614731 Fouke, John, of Parkham, parson, executors of 0
4844276 2309717 2309717 defendant Toker Baldwin toker 614731 614731 Toker, Baldwin, of Parkham, toker 1
4848824 2311096 2311096 defendant Lange Baldwin husbandman 614731 614731 Lange, Baldwin, of Parkham, husbandman 0
4974005 2349188 2349188 defendant Lowede John chaplain 614731 614731 Lowede, John, of Parkham, chaplain 0
4987175 2353111 2353111 defendant Gyffard Thomas gent 614731 614731 Gyffard, Thomas, of parkham, gent 0
4987492 2353215 2353215 defendant Hollegh Baldwin husbandman 614731 614731 Hollegh, Baldwin, of Parkham, husbandman 0
4996129 2355700 2355700 defendant Joce John husbandman 614731 614731 Joce, John, of Parkham, husbandman 0
5014311 2361041 2361041 defendant Gyffard Thomas gent 614731 614731 Gyffard, Thomas, of Parkham, gent 0
5025798 2364444 2364444 defendant Seller Thomas carpenter 614731 614731 Seller, Thomas, of Parkham, carpenter 0
5039229 2368375 2368375 defendant Gyffard Thomas (legal representative) 614731 614731 Gyffard, Thomas, of Parkham, executrix of 0
5039230 2368375 2368375 defendant Gyffard Willelmina   614731 614731 Gyffard, Willelmina, of Parkham, widow, formerly wife of Testator 1
5040960 2368919 2368919 defendant Gyffard Thomas (legal representative) 614731 614731 Gyffard, Thomas, of Parkham, executors of 0
5040961 2368919 2368919 defendant Knyght John clerk 614731 614731 (Knyght, John, of Parkham, clerk 1
5040962 2368919 2368919 defendant Gyffard Willelmina   614731 614731 Gyffard, Willelmina, of Parkham, widow, formerly wife of Testator 2
5109458 2389197 2389197 defendant Lyghtfote Stephen   614731 614731 Lyghtfote, Stephen, of Parkham, mason 8
5297083 2444143 2444143 defendant Howe John husbandman 614731 614731 Howe, John, of Parkham, husbandman 2
5297347 2444223 2444223 defendant Sellere Roger husbandman 614731 614731 Sellere, Roger, of Parkham, husbandman 0
5297348 2444223 2444223 defendant Vagescombe Baldwin husbandman 614731 614731 Vagescombe, Baldwin, of Parkham, husbandman 1
5297349 2444223 2444223 defendant Howe John husbandman 614731 614731 Howe, John, of Parkham, husbandman 2
5301669 2445453 2445453 defendant Sellere Roger husbandman 614731 614731 Sellere, Roger, of Parkham, husbandman 0
5301670 2445453 2445453 defendant Vaggescombe Baldwin husbandman 614731 614731 Vaggescombe, Baldwin, of Parkham, husbandman 1
5301671 2445453 2445453 defendant How John husbandman 614731 614731 How, John, of Parkham, husbandman 2
5360879 2463432 2463432 defendant Gyffard John esq 614731 614731 Gyffard, John, of Parkham, esq 0
5376121 2468122 2468122 defendant John John husbandman 614731 614731 John, John, of Parkham, husbandman 0
5376122 2468122 2468122 defendant (illegible) (illegible) husbandman 614731 614731 -----, -----, of Parkham, husbandman 1
5458818 2492529 2492529 defendant Belle John clerk 614731 614731 Belle, John, of Parkham, clerk 0
5470409 2496070 2496070 defendant Belle John clerk 614731 614731 Belle, John, of Parkham, clerk 0
5522690 2511923 2511923 defendant Lynche Baldwin butcher 614731 614731 Lynche, Baldwin, of Parkham, butcher 0
5613129 2547885 2547885 plaintiff Cook Martin   614731 614731 Cook, Martin, of Parkham 0
5613507 2548014 2548014 plaintiff Vaggescombe Robert   614731 614731 (Vaggescombe, Robert, of Parkham, parson 1
5613520 2548015 2548015 plaintiff Vaggescombe Robert   614731 614731 (Vaggescombe, Robert, of Parkham, parson 1
5613533 2548016 2548016 plaintiff Vaggescombe Robert   614731 614731 (Vaggescombe, Robert, of Parkham, parson 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);