names

56 rows where place_id = 609683

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3679744 1919734 1919734 defendant Ladde Robert husbandman 609683 609683 Ladde, Robert, of Eccles, husbandman 0
3779787 1951410 1951410 defendant Ladde Robert husbandman 609683 609683 Ladde, Robert, of Eccles, husbandman 2
3831958 1967893 1967893 defendant Punder John   609683 609683 Punder, John, of Eccles, shepherd 0
3870213 1980285 1980285 defendant Saye John clerk 609683 609683 Saye, John, of Eccles, clerk 0
3984662 2019272 2019272 defendant Graty Christopher miller 609683 609683 Graty, Christopher, of Eccles, miller 0
4039517 2038754 2038754 defendant Walker John mariner 609683 609683 Walker, John, of Eccles, mariner 1
4053875 2043763 2043763 defendant Myles John husbandman 609683 609683 Myles, John, of Eccles, husbandman 1
4057440 2045042 2045042 defendant Goslynge William yeoman 609683 609683 Goslynge, William, of Eccles, yeoman 2
4162545 2082460 2082460 defendant Gostling William yeoman 609683 609683 Gostling, William, of Eccles, yeoman 2
4212001 2099746 2099746 defendant Hydes Henry   609683 609683 Hydes, Henry, of Eccles, sailor 0
4212003 2099747 2099747 defendant Hydes Henry   609683 609683 Hydes, Henry, of Eccles, sailor 0
4228120 2105315 2105315 defendant Haytropp Robert husbandman 609683 609683 Haytropp, Robert, of Eccles, husbandman 1
4237707 2108786 2108786 defendant Myles John   609683 609683 Myles, John, of Eccles yeoman 0
4237708 2108786 2108786 defendant Johnson William husbandman 609683 609683 together with Johnson, William, of Eccles, husbandman 1
4237710 2108787 2108787 defendant Johnson William husbandman 609683 609683 Johnson, William, of Eccles, husbandman 0
4241041 2109987 2109987 defendant Smyth John gent 609683 609683 Smyth, John, of Eccles, or of Thirninge, gent 0
4241044 2109988 2109988 defendant Smyth John gent 609683 609683 Smyth, John, of Eccles, or of Thirninge, gent 0
4241740 2110224 2110224 defendant Save Thomas husbandman 609683 609683 Save, Thomas, of Eccles, husbandman 0
4245980 2111636 2111636 defendant Smythe John gent 609683 609683 Smythe, John, of Eccles, gent 0
4251037 2113325 2113325 defendant Larewoode William mariner 609683 609683 Larewoode, William, of Eccles, mariner 0
4251038 2113325 2113325 defendant Cannon William pedder 609683 609683 Cannon, William, of Eccles, pedder 1
4251039 2113325 2113325 defendant Grewer John husbandman 609683 609683 Grewer, John, of Eccles, husbandman 2
4251044 2113326 2113326 defendant Browne Thomas laborer 609683 609683 Browne, Thomas, of Eccles, laborer 3
4254058 2114357 2114357 defendant Hartstonge John yeoman 609683 609683 Hartstonge, John, of Eccles, yeoman 0
4258957 2115965 2115965 defendant Johnson William husbandman 609683 609683 Johnson, William, of Eccles, husbandman 0
4258959 2115966 2115966 defendant Myles John yeoman 609683 609683 Myles, John, of Eccles, yeoman 0
4284011 2124324 2124324 defendant Ladd William mariner 609683 609683 Ladd, William, of Eccles, mariner 1
4289733 2126389 2126389 defendant Miles John yeoman 609683 609683 Miles, John, of Eccles, yeoman 3
4289735 2126390 2126390 defendant Myles John yeoman 609683 609683 Myles, John, of Eccles, yeoman 0
4297868 2129343 2129343 defendant Androwe Thomas tailor 609683 609683 Androwe, Thomas, of Eccles, tailor 1
4311710 2134237 2134237 defendant Hartstonge John yeoman 609683 609683 Hartstonge, John, of Eccles, yeoman 3
4318936 2136736 2136736 defendant Myles John yeoman 609683 609683 Myles, John, of Eccles, yeoman 0
4320694 2137331 2137331 defendant Camman William fishmonger 609683 609683 Camman, William, of Eccles, fishmonger 0
4329469 2140162 2140162 defendant Greene John mariner 609683 609683 Greene, John, of Eccles, mariner 3
4353718 2148521 2148521 defendant Lacy George cooper 609683 609683 Lacy, George, of Eccles, cooper 1
4354834 2148912 2148912 defendant Swyft Leonard miller 609683 609683 Swyft, Leonard, of Eccles, miller 2
4391715 2161849 2161849 defendant Walker William   609683 609683 Walker, William, of Eccles, shepherd 1
4395499 2163077 2163077 defendant Sutton Edmund husbandman 609683 609683 Sutton, Edmund, of Eccles, husbandman 1
4395866 2163194 2163194 defendant Tuddenham Nicholas husbandman 609683 609683 Tuddenham, Nicholas, of Eccles, husbandman 0
4410536 2168115 2168115 defendant Beales John husbandman 609683 609683 Beales, John, of Eccles, husbandman 1
4568735 2221804 2221804 defendant Baxtere Philip   609683 609683 Baxtere, Philip, of Eccles 0
4683685 2260498 2260498 defendant Hoode Thomas baker 609683 609683 Hoode, Thomas, of Eccles, baker 2
4715172 2270073 2270073 defendant Hode Thomas husbandman 609683 609683 Hode, Thomas, of Eccles, husbandman 1
4756749 2282474 2282474 defendant Wekes Thomas husbandman 609683 609683 Wekes, Thomas, of Eccles, husbandman 4
4942602 2339656 2339656 defendant Dawe William shipman 609683 609683 Dawe, William, of Eccles, shipman 0
5410010 2477960 2477960 defendant Ony Robert esq 609683 609683 Ony, Robert, of Eccles, esq 12
5446892 2488964 2488964 defendant Lade Thomas husbandman 609683 609683 Lade, Thomas, of Eccles, husbandman 0
5450857 2490143 2490143 defendant Lade Thomas   609683 609683 Lade, Thomas, of Eccles 0
5455664 2491595 2491595 defendant Ony or Ovy of Oby or Quy Robert husbandman 609683 609683 Ony or Ovy of Oby or Quy, Robert, of Eccles, husbandman 10
5512220 2508686 2508686 defendant Hykelyng Thomas mariner 609683 609683 Hykelyng, Thomas, of Eccles, mariner 0
5594541 2533270 2533270 defendant Cristemas William husbandman 609683 609683 Cristemas, William, of Eccles, husbandman 7
5624403 2551576 2551576 defendant Hode Thomas baker 609683 609683 Hode, Thomas, of Eccles, baker 0
5624405 2551576 2551576 defendant Perys John ploughman 609683 609683 Perys, John, of Eccles, ploughman 2
5624408 2551577 2551577 defendant Hode Thomas baker 609683 609683 Hode, Thomas, of Eccles, baker 0
5624410 2551577 2551577 defendant Perys John ploughman 609683 609683 Perys, John, of Eccles, ploughman 2
5626685 2552319 2552319 defendant Fyshlak Richard laborer 609683 609683 Fyshlak, Richard, of Eccles, laborer 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);