names

38 rows where place_id = 609578

✎ 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
3679171 1919553 1919553 defendant Glover Walter clothmaker 609578 609578 Glover, Walter, of Gylford, Surrey, clothmaker 0
3684334 1921234 1921234 defendant Barre William chapman 609578 609578 Barre, William, of Gylford, Surrey, chapman 1
3684338 1921235 1921235 defendant Barre William chapman 609578 609578 Barre, William, of Gylford, Surrey, chapman 1
3689482 1922868 1922868 defendant Walles Anthony gent 609578 609578 Walles, Anthony, of Gylford, Surrey, gent 1
3689486 1922869 1922869 defendant Walles alias Walman Anthony gent 609578 609578 Walles alias Walman, Anthony, of Gylford, Surrey, gent 1
3706410 1928292 1928292 defendant Mower John yeoman 609578 609578 Mower, John, of Gylford, Surrey, yeoman 2
3718035 1931935 1931935 defendant Walles alias Walseman Anthony gent 609578 609578 Walles alias Walseman, Anthony, of Gylford, Surrey, gent 0
3762246 1945837 1945837 defendant Catryk Robert chapman 609578 609578 Catryk, Robert, of Gylford, Surrey, chapman 3
3762252 1945838 1945838 defendant Catryk Robert chapman 609578 609578 Catryk, Robert, of Gylford, Surrey, chapman 3
3768209 1947696 1947696 defendant Godstone John innholder 609578 609578 Godstone, John, of Gylford, Surrey, innholder 2
3768215 1947697 1947697 defendant Godstone John innholder 609578 609578 Godstone, John, of Gylford, Surrey, innholder 2
3802019 1958529 1958529 defendant Heyward Thomas buthcer 609578 609578 Heyward, Thomas, of Gylford, Surrey, buthcer 0
3808193 1960447 1960447 defendant Hatelyne Richard yeoman 609578 609578 Hatelyne, Richard, of Gylford, Surrey, yeoman 0
3814164 1962333 1962333 defendant Barre William mercer 609578 609578 Barre, William, of Gylford, Surrey, mercer 3
3819836 1964085 1964085 defendant Godstone John innholder 609578 609578 Godstone, John, of Gylford, Surrey, innholder 1
3873577 1981384 1981384 defendant Penrose James yeoman 609578 609578 Penrose, James, of Gylford, Surrey, yeoman 1
3875294 1981978 1981978 defendant Smalpys Thomas clothier 609578 609578 Smalpys, Thomas, of Gylford, Surrey, clothier 0
3880759 1983829 1983829 defendant Smalpece Thomas clothmaker 609578 609578 Smalpece, Thomas, of Gylford, Surrey, clothmaker 1
3887996 1986235 1986235 defendant Whetley Thomas chapman 609578 609578 Whetley, Thomas, of Gylford, Surrey, chapman 4
3943724 2004918 2004918 defendant Tornor John chapman 609578 609578 Tornor, John, of Gylford, Surrey, chapman 0
3946401 2005812 2005812 defendant Grene Robert chapman 609578 609578 Grene, Robert, of Gylford, Surrey, chapman 2
4000937 2025105 2025105 defendant Semans Thomas clothier 609578 609578 Semans, Thomas, of Gylford, Surrey, clothier 0
4017778 2031069 2031069 defendant Hamon William esq 609578 609578 Hamon, William, of Gylford, Surrey, esq 0
4073070 2050663 2050663 defendant Thompson John chapman 609578 609578 Thompson, John, of Gylford, Surrey, chapman 0
4208255 2098437 2098437 defendant Bedell James chapman 609578 609578 Bedell, James, of Gylford, Surrey, chapman 2
4343410 2144970 2144970 defendant Myllett John chapman 609578 609578 Myllett, John, of Gylford, Surrey, chapman 2
4355128 2149011 2149011 defendant Snellinge Henry clothier 609578 609578 Snellinge, Henry, of Gylford, Surrey, clothier 0
5216366 2420526 2420526 defendant Baret Thomas mercer 609578 609578 Baret, Thomas, of Gylford, Surrey, mercer 2
5218423 2421120 2421120 defendant Baret Thomas mercer 609578 609578 Baret, Thomas, of Gylford, Surrey, mercer 0
5249243 2429898 2429898 defendant Couper William yeoman 609578 609578 Couper, William, of Gylford, Surrey, yeoman 0
5252893 2431017 2431017 defendant Daulyng or Danlyng Robert esq 609578 609578 Daulyng or Danlyng, Robert, of Gylford, Surrey, esq 2
5289355 2441889 2441889 defendant Counsell Nicholas gent 609578 609578 Counsell, Nicholas, of Gylford, Surrey, gent 1
5290375 2442188 2442188 defendant Gromer James chapman 609578 609578 Gromer, James, of Gylford, Surrey, chapman 3
5357856 2462525 2462525 defendant Grover James chapman 609578 609578 Grover, James, of Gylford, Surrey, chapman 1
5494221 2503176 2503176 defendant Russell William gent 609578 609578 Russell, William, of Gylford, Surrey, gent 0
5494226 2503177 2503177 defendant Russell William gent 609578 609578 Russell, William, of Gylford, Surrey, gent 0
5564007 2524089 2524089 defendant Tanner Thomas fuller 609578 609578 Tanner, Thomas, of Gylford, Surrey, fuller 2
5580515 2528996 2528996 defendant Sounde Geoffrey dyer 609578 609578 Sounde, Geoffrey, of Gylford, Surrey, dyer 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);