names

39 rows where place_id = 589003

✎ 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
3596235 1866449 1866449 defendant Rede John mariner 589003 589003 Rede, John, of Beeston juxta Mare, mariner 0
3680436 1919963 1919963 defendant Alden William mariner 589003 589003 Alden, William, of Beeston juxta Mare, mariner 2
3777312 1950647 1950647 defendant Gybbon John miller 589003 589003 Gybbon, John, of Beeston juxta Mare, miller 3
3918299 1996457 1996457 plaintiff Hoke Edmund   589003 589003 Hoke, Edmund, of Beeston juxta Mare 0
3918450 1996500 1996500 plaintiff Hooke Edmund   589003 589003 Hooke, Edmund, of Beeston juxta Mare 0
3999486 2024580 2024580 defendant Abbes Simon yeoman 589003 589003 Abbes, Simon, of Beeston juxta Mare, yeoman 2
4023795 2033215 2033215 plaintiff Beales William yeoman 589003 589003 Beales, William, of Beeston juxta Mare, yeoman 0
4023828 2033229 2033229 plaintiff Beccles William   589003 589003 Beccles, William, of Beeston juxta Mare 0
4032139 2036161 2036161 defendant Abbes Simon yeoman 589003 589003 Abbes, Simon, of Beeston juxta Mare, yeoman 2
4132151 2071812 2071812 defendant Fezar James mariner 589003 589003 Fezar, James, of Beeston juxta Mare, mariner 0
4132152 2071812 2071812 defendant Mycheson Simon mariner 589003 589003 Mycheson, Simon, of Beeston juxta Mare, mariner 1
4132153 2071812 2071812 defendant Wolover William mariner 589003 589003 Wolover, William, of Beeston juxta Mare, mariner 2
4132159 2071813 2071813 defendant Buckshowe John   589003 589003 Buckshowe, John, of Beeston juxta Mare, shipwright 0
4132160 2071813 2071813 defendant Baylye Thomas mariner 589003 589003 Baylye, Thomas, of Beeston juxta Mare, mariner 1
4134658 2072725 2072725 defendant Spansby Simon mariner 589003 589003 Spansby, Simon, of Beeston juxta Mare, mariner 2
4148282 2077530 2077530 defendant Spansby Simon mariner 589003 589003 Spansby, Simon, of Beeston juxta Mare, mariner 0
4153135 2079194 2079194 defendant Kendall John mariner 589003 589003 Kendall, John, of Beeston juxta Mare, mariner 1
4153137 2079194 2079194 defendant Wollover William mariner 589003 589003 Wollover, William, of Beeston juxta Mare, mariner 3
4160786 2081850 2081850 defendant Woolover William   589003 589003 Woolover, William, of Beeston juxta Mare, sailor 0
4162008 2082269 2082269 defendant Springold Robert mariner 589003 589003 Springold, Robert, of Beeston juxta Mare, mariner 1
4162018 2082272 2082272 defendant Wolover William   589003 589003 Wolover, William, of Beeston juxta Mare, ship master 0
4163084 2082622 2082622 defendant Wollover William mariner 589003 589003 Wollover, William, of Beeston juxta Mare, mariner 1
4184381 2090038 2090038 defendant Monyman Henry mariner 589003 589003 Monyman, Henry, of Beeston juxta Mare, mariner 2
4189189 2091711 2091711 defendant Springold William mariner 589003 589003 Springold, William, of Beeston juxta Mare, mariner 1
4226037 2104576 2104576 defendant Michelson Simon   589003 589003 Michelson, Simon, of Beeston juxta Mare, sailor 3
4259887 2116277 2116277 defendant Springold Thomas husbandman 589003 589003 Springold, Thomas, of Beeston juxta Mare, husbandman 2
4352206 2148006 2148006 defendant Fuller John blacksmith 589003 589003 Fuller, John, of Beeston juxta Mare, blacksmith 3
4888118 2323089 2323089 defendant Smyth Thomas mariner 589003 589003 Smyth, Thomas, of Beeston juxta Mare, mariner 0
4905183 2328219 2328219 defendant Smyth Thomas mariner 589003 589003 Smyth, Thomas, of Beeston juxta Mare, mariner 0
5032208 2366300 2366300 defendant Stephens Thomas miller 589003 589003 Stephens, Thomas, of Beeston juxta Mare, miller 0
5120994 2392572 2392572 defendant Hunston Simon yeoman 589003 589003 Hunston, Simon, of Beeston juxta Mare, yeoman 1
5279370 2439054 2439054 defendant Cokefeld John clerk 589003 589003 Cokefeld, John, of Beeston juxta Mare, clerk 1
5296003 2443820 2443820 defendant Thurkeld Henry husbandman 589003 589003 Thurkeld, Henry, of Beeston juxta Mare, husbandman 1
5354758 2461568 2461568 defendant Beelys John husbandman 589003 589003 Beelys, John, of Beeston juxta Mare, husbandman 0
5354759 2461568 2461568 defendant Heyles John mariner 589003 589003 Heyles, John, of Beeston juxta Mare, mariner 1
5354760 2461568 2461568 defendant Spryngolff Simon mariner 589003 589003 Spryngolff, Simon, of Beeston juxta Mare, mariner 2
5354761 2461568 2461568 defendant Tayllour John mariner 589003 589003 Tayllour, John, of Beeston juxta Mare, mariner 3
5498812 2504584 2504584 defendant Rede John mariner 589003 589003 Rede, John, of Beeston juxta Mare, mariner 0
5540659 2517207 2517207 defendant Chylde John mariner 589003 589003 Chylde, John, of Beeston juxta Mare, mariner 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);