names

44 rows where place_id = 613229

✎ 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
3697241 1925359 1925359 defendant Cawston William yeoman 613229 613229 Cawston, William, of Keston, yeoman 0
3718061 1931943 1931943 defendant Bennett John husbandman 613229 613229 Bennett, John, of Keston, husbandman 0
3758971 1944796 1944796 defendant Brewster Thurstan tailor 613229 613229 Brewster, Thurstan, of Keston, tailor 0
3776367 1950360 1950360 defendant Busshop John, junior husbandman 613229 613229 Busshop, John, junior, of Keston, husbandman 0
3794383 1956122 1956122 defendant Brewster Thurstan tailor 613229 613229 Brewster, Thurstan, of Keston, tailor 0
3843865 1971621 1971621 defendant Bulkyn John yeoman 613229 613229 Bulkyn, John, of Keston, yeoman 0
3859912 1976820 1976820 defendant Bulkyn John yeoman 613229 613229 Bulkyn, John, of Keston, yeoman 0
3900616 1990435 1990435 defendant Capell James gent 613229 613229 Capell, James, of Keston, gent 2
4235051 2107812 2107812 defendant Feremeddowes John yeoman 613229 613229 Feremeddowes, John, of Keston, yeoman 0
4313269 2134749 2134749 defendant Steven Thomas yeoman 613229 613229 (Steven, Thomas, of Keston, yeoman 1
4431555 2174637 2174637 plaintiff Brampton Thomas de   613229 613229 Brampton, Thomas de, of Keston 0
4533014 2210594 2210594 defendant Marchall Thomas   613229 613229 Marchall, Thomas, of Keston 1
4599418 2231033 2231033 defendant Basyngham William   613229 613229 Basyngham, William, of Keston 3
4621623 2237750 2237750 defendant Kyng John   613229 613229 Kyng, John, of Keston 1
4629442 2240136 2240136 defendant Kyng John   613229 613229 Kyng, John, of Keston 1
4629476 2240147 2240147 defendant Kyng John   613229 613229 Kyng, John, of Keston 1
4629480 2240148 2240148 defendant Kyng John   613229 613229 Kyng, John, of Keston 1
4707923 2267848 2267848 defendant Lutton Thomas husbandman 613229 613229 Lutton, Thomas, of Keston, husbandman 1
4748936 2280176 2280176 defendant Dycon John husbandman 613229 613229 Dycon, John, of Keston, husbandman 0
4748937 2280176 2280176 defendant Lutton Thomas husbandman 613229 613229 Lutton, Thomas, of Keston, husbandman 1
4773078 2287551 2287551 defendant Barlowe John gent 613229 613229 Barlowe, John, of Keston, gent 0
4773079 2287551 2287551 defendant Dycon John husbandman 613229 613229 Dycon, John, of Keston, husbandman 1
4965152 2346502 2346502 defendant Bullok John husbandman 613229 613229 Bullok, John, of Keston, husbandman 0
4981180 2351301 2351301 defendant Wardale John clerk 613229 613229 Wardale, John, of Keston, clerk 0
4981187 2351303 2351303 defendant Wardale John clerk 613229 613229 Wardale, John, of Keston, clerk 0
4983295 2351909 2351909 defendant Bullok John, senior husbandman 613229 613229 Bullok, John, senior, of Keston, husbandman 0
4993201 2354846 2354846 defendant Barlowe Agnes widow & formerly wife of John Barlowe 613229 613229 Barlowe, Agnes, of Keston, widow & formerly wife of John Barlowe 0
5034563 2366968 2366968 defendant Brawnton or Crawnton Richard chaplain 613229 613229 Brawnton or Crawnton, Richard, of Keston, chaplain 1
5073705 2378621 2378621 defendant Craunton Richard clerk 613229 613229 Craunton, Richard, of Keston, clerk 1
5073706 2378621 2378621 defendant Smyth John yeoman 613229 613229 Smyth, John, of Keston, yeoman 2
5073709 2378622 2378622 defendant Craunton Richard clerk 613229 613229 Craunton, Richard, of Keston, clerk 1
5073710 2378622 2378622 defendant Smyth John yeoman 613229 613229 Smyth, John, of Keston, yeoman 2
5114778 2390735 2390735 defendant Farley John clerk 613229 613229 Farley, John, of Keston, clerk 2
5196997 2414865 2414865 defendant Bisshop Richard husbandman 613229 613229 Bisshop, Richard, of Keston, husbandman 2
5196999 2414865 2414865 defendant Andrewe John husbandman 613229 613229 Andrewe, John, of Keston, husbandman 4
5209894 2418626 2418626 defendant Bisshop Richard husbandman 613229 613229 Bisshop, Richard, of Keston, husbandman 2
5209896 2418626 2418626 defendant Andrewe John husbandman 613229 613229 Andrewe, John, of Keston, husbandman 4
5233582 2425415 2425415 defendant Smyth John yeoman 613229 613229 Smyth, John, of Keston, yeoman 0
5434868 2485361 2485361 defendant Justice John (legal representative) 613229 613229 Justice, John, of Keston, clerk & rector, administrator of 0
5450117 2489923 2489923 defendant Justice John   613229 613229 Justice, John, of Keston, of clerk, formerly rector 0
5496504 2503864 2503864 defendant Gore Thomas farmer of Keston rectory 613229 613229 Gore, Thomas, of Keston, husbandman, farmer of Keston rectory 0
5496505 2503864 2503864 defendant Asteley Oliver tailor 613229 613229 Asteley, Oliver, of Keston, tailor 1
5549048 2519760 2519760 defendant Aynescombe John husbandman 613229 613229 Aynescombe, John, of Keston, husbandman 0
5614158 2548211 2548211 plaintiff Dunnok Henry   613229 613229 Dunnok, Henry, of Keston 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);