names

73 rows where place_id = 597828

✎ 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
3630017 1904239 1904239 plaintiff Castell John   597828 597828 Castell, John, of Glatton 4
3720979 1932858 1932858 defendant Arnold Robert courser 597828 597828 Arnold, Robert, of Glatton, courser 0
3757394 1944294 1944294 defendant Crosse Robert courser 597828 597828 Crosse, Robert, of Glatton, courser 0
3798739 1957520 1957520 defendant Crosse Robert husbandman 597828 597828 Crosse, Robert, of Glatton, husbandman 0
3811109 1961372 1961372 defendant Crosse Robert husbandman 597828 597828 Crosse, Robert, of Glatton, husbandman 0
3839097 1970149 1970149 defendant Brown John husbandman 597828 597828 Brown, John, of Glatton, husbandman 0
3839099 1970150 1970150 defendant Browne John husbandman 597828 597828 Browne, John, of Glatton, husbandman 0
3867663 1979420 1979420 defendant Leche William yeoman 597828 597828 Leche, William, of Glatton, yeoman 0
3870302 1980318 1980318 defendant Pulter Francis gent 597828 597828 Pulter, Francis, of Glatton, gent 0
3873522 1981360 1981360 defendant Hyrdson William clerk 597828 597828 Hyrdson, William, of Glatton, clerk 0
3935923 2002330 2002330 defendant Horwood Robert chapman 597828 597828 Horwood, Robert, of Glatton, chapman 2
4131275 2071506 2071506 defendant Browne William yeoman 597828 597828 Browne, William, of Glatton, yeoman 0
4131277 2071507 2071507 defendant Browne William yeoman 597828 597828 Browne, William, of Glatton, yeoman 0
4131280 2071508 2071508 defendant Goodall Thomas husbandman 597828 597828 Goodall, Thomas, of Glatton, husbandman 0
4170996 2085338 2085338 defendant Abbott Gilbert husbandman 597828 597828 Abbott, Gilbert, of Glatton, husbandman 0
4170997 2085338 2085338 defendant Lacke William husbandman 597828 597828 Lacke, William, of Glatton, husbandman 1
4194290 2093551 2093551 defendant Abbott Gilbert husbandman 597828 597828 Abbott, Gilbert, of Glatton, husbandman 0
4194291 2093551 2093551 defendant Lacke William husbandman 597828 597828 Lacke, William, of Glatton, husbandman 1
4250067 2113005 2113005 defendant Browne Oliver husbandman 597828 597828 Browne, Oliver, of Glatton, husbandman 0
4250068 2113005 2113005 defendant Browne William husbandman 597828 597828 Browne, William, of Glatton, husbandman 1
4256126 2115030 2115030 defendant Godale Thomas yeoman 597828 597828 Godale, Thomas, of Glatton, yeoman 0
4264401 2117736 2117736 defendant Browne Oliver husbandman 597828 597828 Browne, Oliver, of Glatton, husbandman 0
4264402 2117736 2117736 defendant Browne William husbandman 597828 597828 Browne, William, of Glatton, husbandman 1
4298870 2129691 2129691 defendant Kaye Robert gent 597828 597828 Kaye, Robert, of Glatton, gent 0
4298871 2129691 2129691 defendant Castell John gent 597828 597828 Castell, John, of Glatton, gent 1
4298872 2129691 2129691 defendant Cowper Thomas yeoman 597828 597828 Cowper, Thomas, of Glatton, yeoman 2
4310569 2133845 2133845 defendant Browne William yeoman 597828 597828 Browne, William, of Glatton, yeoman 1
4312049 2134354 2134354 defendant Kyng Edward gent 597828 597828 Kyng, Edward, of Glatton, gent 0
4312050 2134354 2134354 defendant Kyng Elizabeth widow 597828 597828 Elizabeth his wife, formerly Elizabeth Colly, of Glatton, widow 1
4319767 2137025 2137025 defendant Browne William husbandman 597828 597828 Browne, William, of Glatton, husbandman 2
4332087 2141030 2141030 defendant Key Robert gent 597828 597828 Key, Robert, of Glatton, gent 0
4332088 2141030 2141030 defendant Castell John gent 597828 597828 Castell, John, of Glatton, gent 1
4332089 2141030 2141030 defendant Cowper Thomas yeoman 597828 597828 Cowper, Thomas, of Glatton, yeoman 2
4341109 2144162 2144162 defendant Wyseman John gent 597828 597828 Wyseman, John, of Glatton, gent 1
4341484 2144299 2144299 defendant Dover Thomas yeoman 597828 597828 Dover, Thomas, of Glatton, yeoman 0
4341772 2144397 2144397 defendant Castle William gent 597828 597828 Castle, William, of Glatton, gent 0
4348341 2146673 2146673 defendant Browne William husbandman 597828 597828 Browne, William, of Glatton, husbandman 0
4349971 2147249 2147249 defendant Kay Robert gent 597828 597828 Kay, Robert, of Glatton, or of Kings Lynn, gent 1
4364623 2152405 2152405 defendant Abbott Gilbert husbandman 597828 597828 Abbott, Gilbert, of Glatton, husbandman 0
4364625 2152405 2152405 defendant Castle William gent 597828 597828 Castle, William, of Glatton, gent 2
4384889 2159635 2159635 defendant Fakener Barnard yeoman 597828 597828 Fakener, Barnard, of Glatton, yeoman 0
4449463 2184778 2184778 defendant Berkfford Lawrnece   597828 597828 Berkfford, Lawrnece, of Glatton 0
4449467 2184780 2184780 defendant Berkford Lawrence   597828 597828 Berkford, Lawrence, of Glatton 0
4449520 2184797 2184797 defendant Berkford Lawrence   597828 597828 Berkford, Lawrence, of Glatton 0
4501883 2201189 2201189 defendant Tailour Richard   597828 597828 Tailour, Richard, of Glatton 0
4537032 2211852 2211852 plaintiff Stucle William   597828 597828 Stucle, William, of Glatton, parson 0
4588952 2227918 2227918 defendant Aleyn John   597828 597828 Aleyn, John, of Glatton 6
4588953 2227918 2227918 defendant Aleyn William   597828 597828 Aleyn, William, of Glatton 7
4647134 2245215 2245215 defendant Holod William   597828 597828 Holod, William, of Glatton 0
4653523 2247036 2247036 defendant Holand William husbandman 597828 597828 Holand, William, of Glatton, husbandman 0
4653524 2247036 2247036 defendant Palfreyman William laborer 597828 597828 Palfreyman, William, of Glatton, laborer 1
4685904 2261182 2261182 defendant Shepherd William   597828 597828 Shepherd, William, of Glatton, shepherd 0
4711850 2269036 2269036 defendant Shepherd William   597828 597828 Shepherd, William, of Glatton, shepherd 0
4733371 2275613 2275613 defendant Brayton Richard   597828 597828 Brayton, Richard, of Glatton, parson 0
4778743 2289326 2289326 defendant Richard Robert smith 597828 597828 Richard, Robert, of Glatton, smith 2
4874980 2319121 2319121 defendant Henby John husbandman 597828 597828 Henby, John, of Glatton, or of Broughton, husbandman 0
4874981 2319121 2319121 defendant Vanse or Vause John husbandman 597828 597828 Vanse or Vause, John, of Glatton, husbandman 1
4991090 2354225 2354225 defendant Russell William fuller 597828 597828 Russell, William, of Glatton, fuller 1
5043299 2369621 2369621 plaintiff Folkes John, senior husbandman 597828 597828 Folkes, John, senior, of Glatton, husbandman 0
5077966 2379893 2379893 defendant Gyll Thomas husbandman 597828 597828 Gyll, Thomas, of Glatton, husbandman 0
5077969 2379893 2379893 defendant Torold John husbandman 597828 597828 Torold, John, of Glatton, husbandman 3
5112847 2390155 2390155 plaintiff Julyan alias Gylle Thomas   597828 597828 Julyan alias Gylle, Thomas, of Glatton 0
5112848 2390155 2390155 defendant Waren William husbandman 597828 597828 Waren, William, of Glatton, husbandman 0
5332296 2454723 2454723 defendant Manner Thomas husbandman 597828 597828 Manner, Thomas, of Glatton, husbandman 1
5333017 2454942 2454942 defendant Colchestre Robert yeoman 597828 597828 Colchestre, Robert, of Glatton, yeoman 2
5382861 2470165 2470165 defendant Colchester Robert yeoman 597828 597828 Colchester, Robert, of Glatton, yeoman 3
5453182 2490834 2490834 defendant Arnold William corser 597828 597828 Arnold, William, of Glatton, corser 1
5453183 2490834 2490834 defendant Bages Stephen husbandman 597828 597828 Bages, Stephen, of Glatton, husbandman 2
5453185 2490834 2490834 defendant Castell John gent 597828 597828 Castell, John, of Glatton, gent 4
5465122 2494474 2494474 defendant Arnold William corser or horse dealer 597828 597828 Arnold, William, of Glatton, corser or horse dealer 1
5465123 2494474 2494474 defendant Bayas Stephen husbandman 597828 597828 Bayas, Stephen, of Glatton, husbandman 2
5465125 2494474 2494474 defendant Castell John gent 597828 597828 Castell, John, of Glatton, gent 4
5627386 2552534 2552534 defendant Brayton John laborer 597828 597828 Brayton, John, of Glatton, laborer 1

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