names

42 rows where place_id = 663902

✎ 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
3970670 2014330 2014330 plaintiff Deynes Thomas mariner 663902 663902 Deynes, Thomas, of Cromer alias Shipden, mariner 0
3987217 2020174 2020174 defendant Donne or Doune William blacksmith 663902 663902 Donne or Doune, William, of Cromer alias Shipden, blacksmith 0
3987219 2020175 2020175 defendant Donne William blacksmith 663902 663902 Donne, William, of Cromer alias Shipden, blacksmith 0
3989932 2021155 2021155 defendant Blowfeld John gent 663902 663902 Blowfeld, John, of Cromer alias Shipden, gent 0
3998366 2024154 2024154 defendant Comfort Clement gent 663902 663902 Comfort, Clement, of Cromer alias Shipden, gent 0
4054117 2043859 2043859 defendant Thompson Roger mariner 663902 663902 Thompson, Roger, of Cromer alias Shipden, mariner 0
4054118 2043859 2043859 defendant Steward John laborer 663902 663902 Steward, John, of Cromer alias Shipden, laborer 1
4054119 2043859 2043859 defendant Wenman Nicholas laborer 663902 663902 Wenman, Nicholas, of Cromer alias Shipden, laborer 2
4063249 2047150 2047150 defendant Sendall Thomas yeoman 663902 663902 Sendall, Thomas, of Cromer alias Shipden, yeoman 0
4065057 2047788 2047788 defendant Warde William mariner 663902 663902 Warde, William, of Cromer alias Shipden, mariner 3
4077272 2052153 2052153 defendant Dennys John husbandman 663902 663902 Dennys, John, of Cromer alias Shipden, husbandman 0
4082452 2054031 2054031 defendant Arnold William gent 663902 663902 Arnold, William, of Cromer alias Shipden, gent 0
4094892 2058504 2058504 defendant Comforte Clement gent 663902 663902 Comforte, Clement, of Cromer alias Shipden, gent 1
4094910 2058510 2058510 defendant Comforte Clement gent 663902 663902 Comforte, Clement, of Cromer alias Shipden, gent 1
4110802 2064120 2064120 defendant Arnold Richard gent 663902 663902 Arnold, Richard, of Cromer alias Shipden, gent 0
4110803 2064120 2064120 defendant Comfort Clement gent 663902 663902 Comfort, Clement, of Cromer alias Shipden, gent 1
4110805 2064121 2064121 defendant Arnold Richard gent 663902 663902 Arnold, Richard, of Cromer alias Shipden, gent 0
4110806 2064121 2064121 defendant Comforte Clement gent 663902 663902 Comforte, Clement, of Cromer alias Shipden, gent 1
4112994 2064916 2064916 defendant Fysheman Clement   663902 663902 Fysheman, Clement, of Cromer alias Shipden 1
4127480 2070122 2070122 defendant Coper or Cowper John butcher 663902 663902 Coper or Cowper, John, of Cromer alias Shipden, butcher 0
4150757 2078404 2078404 defendant Shancke John gent 663902 663902 Shancke, John, of Cromer alias Shipden, gent 0
4150809 2078416 2078416 defendant Baxter William yeoman 663902 663902 Baxter, William, of Cromer alias Shipden, yeoman 3
4150824 2078420 2078420 defendant Strene or Streve Thomas gent 663902 663902 Strene or Streve, Thomas, of Cromer alias Shipden, gent 1
4158209 2080940 2080940 defendant Harrison Peter   663902 663902 Harrison, Peter, of Cromer alias Shipden, mason 2
4160417 2081719 2081719 defendant Comforte Clement gent 663902 663902 Comforte, Clement, of Cromer alias Shipden, gent 0
4161822 2082204 2082204 defendant Comforte Clement gent 663902 663902 Comforte, Clement, of Cromer alias Shipden, gent 0
4175455 2086887 2086887 defendant Richerd Stephen clerk 663902 663902 Richerd, Stephen, of Cromer alias Shipden, clerk 0
4175456 2086887 2086887 defendant Smyth William   663902 663902 Smyth, William, of Cromer alias Shipden, wool chapman 1
4209476 2098862 2098862 defendant Sahworth Thomas yeoman 663902 663902 Sahworth, Thomas, of Cromer alias Shipden, yeoman 2
4242320 2110427 2110427 defendant Warde William mariner 663902 663902 Warde, William, of Cromer alias Shipden, mariner 0
4243505 2110819 2110819 defendant Harper Thomas tailor 663902 663902 Harper, Thomas, of Cromer alias Shipden, tailor 1
4244656 2111198 2111198 defendant Blowfild John gent 663902 663902 Blowfild, John, of Cromer alias Shipden, gent 0
4260029 2116323 2116323 defendant Sterne John gent 663902 663902 Sterne, John, of Cromer alias Shipden, gent 1
4281490 2123429 2123429 defendant Buntinge Henry husbandman 663902 663902 Buntinge, Henry, of Cromer alias Shipden, husbandman 0
4288222 2125831 2125831 defendant Baxter Thomas gent 663902 663902 Baxter, Thomas, of Cromer alias Shipden, gent 2
4289447 2126283 2126283 defendant Blowfyld John gent 663902 663902 Blowfyld, John, of Cromer alias Shipden, gent 0
4300829 2130395 2130395 defendant Baxter Thomas gent 663902 663902 Baxter, Thomas, of Cromer alias Shipden, gent 0
4323013 2138110 2138110 defendant Baxter Thomas gent 663902 663902 Baxter, Thomas, of Cromer alias Shipden, gent 0
4329417 2140148 2140148 defendant Baxter Thomas gent 663902 663902 Baxter, Thomas, of Cromer alias Shipden, gent 1
4388154 2160665 2160665 defendant Rye William butcher 663902 663902 Rye, William, of Cromer alias Shipden, butcher 0
4392601 2162146 2162146 defendant Harmer Thomas butcher 663902 663902 Harmer, Thomas, of Cromer alias Shipden, butcher 0
4408204 2167315 2167315 defendant Stearne John gent 663902 663902 Stearne, John, of Cromer alias Shipden, gent 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);