names

41 rows where place_id = 589242

✎ 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
3596985 1866683 1866683 defendant Webster John husbandman 589242 589242 Webster, John, of Welyngham, husbandman 1
3781177 1951850 1951850 defendant Dorant Robert thatcher 589242 589242 Dorant, Robert, of Welyngham, thatcher 0
3882267 1984327 1984327 defendant Harvy Robert husbandman 589242 589242 Harvy, Robert, of Welyngham, husbandman 0
3882271 1984328 1984328 defendant Buntyng Thomas husbandman 589242 589242 Buntyng, Thomas, of Welyngham, husbandman 2
3882273 1984329 1984329 defendant Harvy Robert husbandman 589242 589242 Harvy, Robert, of Welyngham, husbandman 0
3920849 1997317 1997317 defendant Bele John husbandman 589242 589242 Bele, John, of Welyngham, husbandman 3
4475064 2192871 2192871 defendant Prykke William chaplain 589242 589242 Prykke, William, of Welyngham, chaplain 0
4499846 2200584 2200584 defendant Cobbe Robert   589242 589242 Cobbe, Robert, of Welyngham 0
4517739 2205938 2205938 defendant Gyssylham William   589242 589242 Gyssylham, William, of Welyngham, wright 0
4548752 2215549 2215549 plaintiff Woderove John   589242 589242 Woderove, John, of Welyngham 4
4548762 2215550 2215550 plaintiff Woderove John   589242 589242 Woderove, John, of Welyngham, parson 4
4560833 2219345 2219345 defendant Beneyt Walter   589242 589242 Beneyt, Walter, of Welyngham 0
4574000 2223389 2223389 defendant Maddy Robert   589242 589242 Maddy, Robert, of Welyngham 0
4575125 2223742 2223742 defendant Prest Thomas   589242 589242 Prest, Thomas, of Welyngham 0
4654875 2247405 2247405 defendant Parker Robert husbandman 589242 589242 Parker, Robert, of Welyngham, husbandman 0
4736889 2276665 2276665 defendant Basse William husbandman 589242 589242 Basse, William, of Welyngham, husbandman 2
4780408 2289870 2289870 defendant Andrewe John yeoman 589242 589242 Andrewe, John, of Welyngham, yeoman 0
4781164 2290119 2290119 defendant Webbe William laborer 589242 589242 Webbe, William, of Welyngham, laborer 2
4856210 2313316 2313316 defendant Mannyng John husbandman 589242 589242 Mannyng, John, of Welyngham, husbandman 2
4868906 2317251 2317251 defendant Bolle Andrew yeoman 589242 589242 Bolle, Andrew, of Welyngham, yeoman 0
4879916 2320632 2320632 defendant atte Touneshende John husbandman 589242 589242 atte Touneshende, John, of Welyngham, husbandman 2
4883725 2321821 2321821 defendant Taylour Thomas husbandman 589242 589242 Taylour, Thomas, of Welyngham, husbandman 0
4883726 2321821 2321821 defendant Ravenesholt John husbandman 589242 589242 Ravenesholt, John, of Welyngham, husbandman 1
4888851 2323302 2323302 defendant Colyere William husbandman 589242 589242 Colyere, William, of Welyngham, husbandman 0
4968483 2347541 2347541 defendant Wode William yeoman 589242 589242 Wode, William, of Welyngham, yeoman 0
4976868 2350031 2350031 defendant atte Wode William   589242 589242 atte Wode, William, of Welyngham 0
5018306 2362239 2362239 defendant More John clerk 589242 589242 More, John, of Welyngham, clerk 0
5018307 2362239 2362239 defendant Rowe Joan   589242 589242 Rowe, Joan, of Welyngham, servant 1
5072564 2378281 2378281 defendant Cryspe William husbandman 589242 589242 Cryspe, William, of Welyngham, husbandman 0
5101924 2386985 2386985 defendant Cryspe Robert laborer 589242 589242 Cryspe, Robert, of Welyngham, laborer 2
5205756 2417425 2417425 plaintiff Heynes Thomas (legal representative) 589242 589242 Heynes, Thomas, of Welyngham, drover, executors of 0
5205762 2417426 2417426 plaintiff Heynes Thomas (legal representative) 589242 589242 Heynes, Thomas, of Welyngham, executors of 0
5239343 2427093 2427093 plaintiff Heynes Thomas (legal representative) 589242 589242 Heynes, Thomas, of Welyngham, drover, executors of 0
5290863 2442335 2442335 defendant Kerspe George husbandman 589242 589242 Kerspe, George, of Welyngham, husbandman 1
5290864 2442335 2442335 defendant Lyton John husbandman 589242 589242 Lyton, John, of Welyngham, husbandman 2
5290865 2442335 2442335 defendant Gates John husbandman 589242 589242 Gates, John, of Welyngham, husbandman 3
5311820 2448562 2448562 defendant Bolle Andrew husbandman 589242 589242 Bolle, Andrew, of Welyngham, husbandman 0
5311822 2448562 2448562 defendant Pye Thomas husbandman 589242 589242 Pye, Thomas, of Welyngham, husbandman 2
5454835 2491364 2491364 defendant Bumpsted John gent 589242 589242 Bumpsted, John, of Welyngham, gent 0
5628710 2552949 2552949 plaintiff Pope John   589242 589242 Pope, John, of Welyngham 0
5628711 2552949 2552949 defendant Richard son of John Webbe husbandman 589242 589242 Richard, son of John Webbe, of Welyngham, 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);