names

41 rows where place_id = 598916

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634528 1905601 1905601 defendant Blades John husbandman 598916 598916 Blades, John, of Anderby, husbandman 0
3893081 1987932 1987932 defendant Stonyngton John husbandman 598916 598916 Stonyngton, John, of Anderby, husbandman 1
3937862 2002994 2002994 defendant West George husbandman 598916 598916 West, George, of Anderby, husbandman 0
4086810 2055573 2055573 defendant Lamynge Thomas yeoman 598916 598916 Lamynge, Thomas, of Anderby, yeoman 0
4149691 2078016 2078016 defendant Gybson Thomas husbandman 598916 598916 Gybson, Thomas, of Anderby, husbandman 3
4168206 2084367 2084367 defendant Michell John husbandman 598916 598916 Michell, John, of Anderby, husbandman 0
4239180 2109329 2109329 defendant Markbye Richard yeoman 598916 598916 Markbye, Richard, of Anderby, yeoman 1
4239182 2109329 2109329 defendant Barnes Thomas yeoman 598916 598916 Barnes, Thomas, of Anderby, yeoman 3
4239186 2109331 2109331 defendant Markby Richard yeoman 598916 598916 Markby, Richard, of Anderby, yeoman 0
4247578 2112175 2112175 defendant Martyn Richard yeoman 598916 598916 Martyn, Richard, of Anderby, yeoman 1
4247580 2112175 2112175 defendant Barnes Thomas yeoman 598916 598916 Barnes, Thomas, of Anderby, yeoman 3
4276316 2121659 2121659 defendant Carter John laborer 598916 598916 Carter, John, of Anderby, laborer 1
4423201 2172114 2172114 defendant Dounyng Thomas   598916 598916 Dounyng, Thomas, of Anderby 1
4423202 2172114 2172114 defendant Prevost Roger   598916 598916 Prevost, Roger, of Anderby 2
4423529 2172204 2172204 defendant Dounyng Thomas   598916 598916 Dounyng, Thomas, of Anderby 1
4423530 2172204 2172204 defendant Prevost Roger   598916 598916 Prevost, Roger, of Anderby 2
4636184 2242149 2242149 defendant Dedynsall John   598916 598916 Dedynsall, John, of Anderby 4
4800340 2296285 2296285 defendant Laughton John   598916 598916 Laughton, John, of Anderby 0
4886139 2322524 2322524 defendant West William, senior chapman 598916 598916 West, William, senior, of Anderby, chapman 1
4906643 2328666 2328666 defendant Warre William husbandman 598916 598916 Warre, William, of Anderby, husbandman 2
4931587 2336265 2336265 defendant Tempyr John husbandman 598916 598916 Tempyr, John, of Anderby, husbandman 1
4955620 2343647 2343647 defendant Smyth Thomas yeoman 598916 598916 Smyth, Thomas, of Anderby, yeoman 2
4957551 2344229 2344229 defendant West Agnes widow 598916 598916 West, Agnes, of Anderby, widow 0
5001606 2357363 2357363 defendant Nicoll John husbandman 598916 598916 Nicoll, John, of Anderby, husbandman 0
5018382 2362262 2362262 defendant Smyth Thomas plasterer 598916 598916 Smyth, Thomas, of Anderby, plasterer 5
5043809 2369775 2369775 defendant Wilkyns John husbandman 598916 598916 Wilkyns, John, of Anderby, husbandman 0
5043810 2369775 2369775 defendant Lokkyng Joan widow 598916 598916 Lokkyng, Joan, of Anderby, widow 1
5050234 2371690 2371690 defendant Smyth Walter husbandman 598916 598916 Smyth, Walter, of Anderby, husbandman 0
5050251 2371697 2371697 defendant Smyth Walter, junior husbandman 598916 598916 Smyth, Walter, junior, of Anderby, husbandman 0
5123115 2393193 2393193 defendant Smyth Thomas merchant 598916 598916 Smyth, Thomas, of Anderby, merchant 0
5137761 2397555 2397555 plaintiff Putterell John   598916 598916 Putterell, John, of Anderby 0
5155684 2402821 2402821 defendant Smyth Walter, sen husbandman 598916 598916 Smyth, Walter, sen, of Anderby, husbandman 0
5191425 2413233 2413233 defendant Smyth Walter, sen husbandman 598916 598916 Smyth, Walter, sen, of Anderby, husbandman 0
5199561 2415616 2415616 defendant Tetnay William husbandman 598916 598916 Tetnay, William, of Anderby, husbandman 1
5199562 2415616 2415616 defendant Smyth Walter husbandman 598916 598916 Smyth, Walter, of Anderby, husbandman 2
5434179 2485178 2485178 defendant Bust John shipman 598916 598916 Bust, John, of Anderby, shipman 0
5434180 2485178 2485178 defendant Godard John shipman 598916 598916 Godard, John, of Anderby, shipman 1
5434181 2485178 2485178 defendant Swete John   598916 598916 Swete, John, of Anderby, wright 2
5434182 2485178 2485178 defendant Swete Thomas husbandman 598916 598916 Swete, Thomas, of Anderby, husbandman 3
5439483 2486743 2486743 defendant West William husbandman 598916 598916 West, William, of Anderby, husbandman 1
5439484 2486743 2486743 defendant West Thomas husbandman 598916 598916 West, Thomas, of Anderby, husbandman 2

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