names

49 rows where place_id = 623985

✎ 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
3755476 1943665 1943665 defendant Kennye Adrian gent 623985 623985 Kennye, Adrian, of Felmersham, gent 0
3962245 2011377 2011377 defendant Roo John clothier 623985 623985 Roo, John, of Felmersham, or of Stratford, Suff, clothier 0
4109516 2063666 2063666 defendant Amore Robert husbandman 623985 623985 Amore, Robert, of Felmersham, husbandman 0
4109518 2063666 2063666 defendant Otwey Robert husbandman 623985 623985 Otwey, Robert, of Felmersham, husbandman 2
4116123 2066060 2066060 defendant Leache Richard husbandman 623985 623985 Leache, Richard, of Felmersham, husbandman 1
4138479 2074128 2074128 defendant Leache Richard husbandman 623985 623985 Leache, Richard, of Felmersham, husbandman 0
4151516 2078652 2078652 defendant Rotam Robert yeoman 623985 623985 Rotam, Robert, of Felmersham, yeoman 2
4163028 2082605 2082605 defendant Leache Richard   623985 623985 Leache, Richard, of Felmersham, husbandman, in Fleete Prison 0
4163440 2082737 2082737 defendant Rotham Robert yeoman 623985 623985 Rotham, Robert, of Felmersham, yeoman 0
4336746 2142581 2142581 defendant Wooddam Thomas yeoman 623985 623985 Wooddam, Thomas, of Felmersham, yeoman 0
4336747 2142581 2142581 defendant Hemyng Richard yeoman 623985 623985 Hemyng, Richard, of Felmersham, yeoman 1
4336748 2142581 2142581 defendant Leache Richard yeoman 623985 623985 Leache, Richard, of Felmersham, yeoman 2
4451866 2185562 2185562 defendant Smyth Robert   623985 623985 Smyth, Robert, of Felmersham 5
4586311 2227133 2227133 defendant Thynden William   623985 623985 Thynden, William, of Felmersham 1
4613817 2235336 2235336 defendant Melton Thomas   623985 623985 Melton, Thomas, of Felmersham 0
4645080 2244631 2244631 defendant Gosefoot Agnes   623985 623985 Gosefoot, Agnes, of Felmersham 1
4652285 2246665 2246665 defendant Bartelot John   623985 623985 Bartelot, John, of Felmersham 0
4661979 2249587 2249587 defendant Bere John ploughman 623985 623985 Bere, John, of Felmersham, ploughman 0
4674844 2257742 2257742 defendant Melton Thomas wooolman 623985 623985 Melton, Thomas, of Felmersham, wooolman 0
4674846 2257742 2257742 defendant Aroundell William laborer 623985 623985 Aroundell, William, of Felmersham, laborer 2
4674847 2257742 2257742 defendant Bere John laborer 623985 623985 Bere, John, of Felmersham, laborer 3
4700173 2265475 2265475 defendant Milton Thomas woolman 623985 623985 Milton, Thomas, of Felmersham, woolman 0
4700175 2265475 2265475 defendant Bere John laborer 623985 623985 Bere, John, of Felmersham, laborer 2
4700176 2265475 2265475 defendant Arundell William laborer 623985 623985 together with Arundell, William, of Felmersham, laborer 3
4714864 2269983 2269983 defendant Skynner William skinner 623985 623985 Skynner, William, of Felmersham, skinner 1
4744745 2278978 2278978 defendant Stokes John   623985 623985 Stokes, John, of Felmersham, vicar 1
4769673 2286490 2286490 defendant Melton Thomas gent 623985 623985 Melton, Thomas, of Felmersham, gent 0
4785012 2291326 2291326 defendant Kyng Richard husbandman 623985 623985 Kyng, Richard, of Felmersham, husbandman 0
4794188 2294321 2294321 defendant Melton Thomas gent 623985 623985 Melton, Thomas, of Felmersham, gent 0
4810136 2299322 2299322 defendant Melton Thomas gent 623985 623985 Melton, Thomas, of Felmersham, gent 0
4811401 2299675 2299675 defendant Shelley William tailor 623985 623985 Shelley, William, of Felmersham, tailor 0
4817381 2301521 2301521 defendant Broy William carpenter 623985 623985 Broy, William, of Felmersham, carpenter 1
4817382 2301521 2301521 defendant More John laborer 623985 623985 More, John, of Felmersham, laborer 2
4817383 2301521 2301521 defendant More John husbandman 623985 623985 More, John, of Felmersham, husbandman 3
4826998 2304486 2304486 defendant Melton Thomas gent 623985 623985 Melton, Thomas, of Felmersham, gent 0
4831615 2305921 2305921 defendant Fyssher Henry husbandman 623985 623985 Fyssher, Henry, of Felmersham, husbandman 0
4836531 2307398 2307398 defendant Milton Thomas   623985 623985 Milton, Thomas, of Felmersham 0
4836532 2307398 2307398 defendant (illegible) John   623985 623985 _, John, of Felmersham 1
4861499 2314966 2314966 defendant Fyssher Henry husbandman 623985 623985 Fyssher, Henry, of Felmersham, husbandman 0
4876537 2319627 2319627 defendant atte Welle Joan widow 623985 623985 atte Welle, Joan, of Felmersham, widow 0
4894036 2324835 2324835 defendant Attemoor John husbandman 623985 623985 Attemoor, John, of Felmersham, husbandman 1
4905244 2328237 2328237 defendant Kynge Richard (legal representative) 623985 623985 Kynge, Richard, of Felmersham, executors of 0
4905246 2328237 2328237 defendant Gardyner Thomas husbandman 623985 623985 Gardyner, Thomas, of Felmersham, husbandman 2
4927332 2334978 2334978 defendant Habraham Willam husbandman 623985 623985 Habraham, Willam, of Felmersham, husbandman 1
4953321 2342957 2342957 defendant Fyssher Henry husbandman 623985 623985 Fyssher, Henry, of Felmersham, husbandman 1
5104414 2387717 2387717 defendant Fynden John husbandman 623985 623985 Fynden, John, of Felmersham, husbandman 0
5569578 2525668 2525668 defendant Cosyn Edmund husbandman 623985 623985 Cosyn, Edmund, of Felmersham, husbandman 0
5569579 2525668 2525668 defendant Cosyn Richard husbandman 623985 623985 Cosyn, Richard, of Felmersham, husbandman 1
5569580 2525668 2525668 defendant At Well John laborer 623985 623985 At Well, John, of Felmersham, laborer 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);