names

49 rows where place_id = 614243

✎ 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
3702675 1927106 1927106 defendant Lee Robert husbandman 614243 614243 Lee, Robert, of Boynton, husbandman 0
3763514 1946223 1946223 defendant Lee Robert husbandman 614243 614243 Lee, Robert, of Boynton, husbandman 0
3855077 1975217 1975217 defendant Sutton John, senior tailor 614243 614243 Sutton, John, senior, of Boynton, tailor 0
3996054 2023341 2023341 defendant Stryckland William esq 614243 614243 Stryckland, William, of Boynton, esq 0
4027349 2034428 2034428 defendant Eres Thomas yeoman 614243 614243 Eres, Thomas, of Boynton, yeoman 0
4163733 2082840 2082840 defendant Strickland William esq 614243 614243 Strickland, William, of Boynton, esq 0
4169144 2084709 2084709 defendant Kyng Anthony clerk 614243 614243 Kyng, Anthony, of Boynton, clerk 0
4175798 2087010 2087010 defendant Barneby William husbandman 614243 614243 Barneby, William, of Boynton, husbandman 1
4348160 2146603 2146603 defendant Strickland William gent 614243 614243 Strickland, William, of Boynton, gent 0
4354534 2148821 2148821 defendant Mylner John husbandman 614243 614243 Mylner, John, of Boynton, husbandman 0
4354535 2148821 2148821 defendant Baynby Henry laborer 614243 614243 Baynby, Henry, of Boynton, laborer 1
4354536 2148821 2148821 defendant Wiske Robert husbandman 614243 614243 Wiske, Robert, of Boynton, husbandman 2
4354537 2148821 2148821 defendant Haggett Stephen husbandman 614243 614243 Haggett, Stephen, of Boynton, husbandman 3
4354549 2148825 2148825 defendant Fairfax George gent 614243 614243 Fairfax, George, of Boynton, gent 0
4385538 2159847 2159847 defendant Gybbon Melchior yeoman 614243 614243 Gybbon, Melchior, of Boynton, yeoman 0
4385539 2159847 2159847 defendant Ruston Nicholas yeoman 614243 614243 Ruston, Nicholas, of Boynton, yeoman 1
4388197 2160682 2160682 defendant Strickland William esq 614243 614243 Strickland, William, of Boynton, esq 0
4392272 2162041 2162041 defendant Wilkinson John yeoman 614243 614243 Wilkinson, John, of Boynton, yeoman 0
4392273 2162041 2162041 defendant Hodgson George laborer 614243 614243 Hodgson, George, of Boynton, laborer 1
4392274 2162041 2162041 defendant Yates John husbandman 614243 614243 Yates, John, of Boynton, husbandman 2
4482870 2195346 2195346 defendant Elynson John   614243 614243 Elynson, John, of Boynton 0
4512567 2204370 2204370 defendant Mounceux Robert   614243 614243 Mounceux, Robert, of Boynton 0
4512571 2204371 2204371 defendant Mounceux Robert   614243 614243 Mounceux, Robert, of Boynton 0
4542483 2213535 2213535 defendant Boynton John de   614243 614243 Boynton, John de, of Boynton 0
4586602 2227218 2227218 defendant Boynton John de   614243 614243 Boynton, John de, of Boynton 0
4592198 2228912 2228912 defendant Boynton John de   614243 614243 Boynton, John de, of Boynton 0
4635367 2241896 2241896 defendant Mounceux Robert   614243 614243 Mounceux, Robert, of Boynton 2
4663760 2250151 2250151 defendant Threman Thomas   614243 614243 Threman, Thomas, of Boynton, parish clerk 0
4674344 2257583 2257583 defendant Meke John husbandman 614243 614243 Meke, John, of Boynton, husbandman 0
4674345 2257583 2257583 defendant Meke Robert husbandman 614243 614243 Meke, Robert, of Boynton, husbandman 1
4676760 2258354 2258354 defendant Gibson Robert husbandman 614243 614243 Gibson, Robert, of Boynton, husbandman 0
4690031 2262433 2262433 defendant Mounsewes John gent 614243 614243 Mounsewes, John, of Boynton, gent 1
4690034 2262434 2262434 defendant Mounsewes Robert gent 614243 614243 Mounsewes, Robert, of Boynton, gent 1
4690038 2262435 2262435 defendant Pokethorp William gent 614243 614243 Pokethorp, William, of Boynton, gent 1
4715781 2270254 2270254 defendant Mounsewes Robert gent 614243 614243 Mounsewes, Robert, of Boynton, gent 1
4715784 2270255 2270255 defendant Mounsewes Robert gent 614243 614243 Mounsewes, Robert, of Boynton, gent 1
4715804 2270259 2270259 defendant Pokethorp William gent 614243 614243 Pokethorp, William, of Boynton, gent 0
4733797 2275750 2275750 defendant Mounceux John gent 614243 614243 Mounceux, John, of Boynton, gent 4
4747781 2279857 2279857 defendant Baynton Robert laborer 614243 614243 Baynton, Robert, of Boynton, laborer 9
4750610 2280665 2280665 defendant Mounceaux Robert gent 614243 614243 Mounceaux, Robert, of Boynton, gent 0
4789529 2292796 2292796 defendant Mounceux Robert gent 614243 614243 (Mounceux, Robert, of Boynton, gent 1
4790189 2293015 2293015 plaintiff Ketyll John   614243 614243 Ketyll, John, of Boynton 0
4790190 2293015 2293015 defendant Lounde Thomas yeoman 614243 614243 Lounde, Thomas, of Boynton, yeoman 0
4858227 2313944 2313944 defendant Clerk Thomas husbandman 614243 614243 Clerk, Thomas, of Boynton, husbandman 1
4861579 2314992 2314992 defendant Myre Nicholas   614243 614243 Myre, Nicholas, of Boynton, parish clerk 0
4949607 2341872 2341872 defendant Powethorp William yeoman 614243 614243 Powethorp, William, of Boynton, yeoman 0
5002268 2357567 2357567 defendant Boynton William yeoman 614243 614243 Boynton, William, of Boynton, yeoman 0
5002270 2357568 2357568 defendant Powethorp William yeoman 614243 614243 Powethorp, William, of Boynton, yeoman 0
5091474 2383895 2383895 plaintiff Neuport John   614243 614243 Neuport, John, of Boynton 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);