names

64 rows where place_id = 606087

✎ 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
3604299 1869008 1869008 defendant Broun Robert   606087 606087 Broun, Robert, of Suffeld, worsted weaver 1
3663968 1914673 1914673 defendant Tyler Henry husbandman 606087 606087 Tyler, Henry, of Suffeld, husbandman 0
3666703 1915533 1915533 defendant Simond Robert yeoman 606087 606087 Simond, Robert, of suffeld, yeoman 1
3666726 1915536 1915536 defendant symond John chaplain 606087 606087 symond, John, of Suffeld, chaplain 3
3728528 1935173 1935173 defendant Flyght William clothier 606087 606087 Flyght, William, of Suffeld, clothier 2
3728529 1935173 1935173 defendant Herward John gent 606087 606087 Herward, John, of Suffeld, gent 3
3746832 1940929 1940929 defendant Symondys Robert yeoman 606087 606087 Symondys, Robert, of Suffeld, yeoman 0
3756394 1943970 1943970 defendant Oldelek William chaplain 606087 606087 Oldelek, William, of Suffeld, chaplain 4
3782460 1952256 1952256 defendant Flyte James   606087 606087 Flyte, James, of Suffeld, worsted weaver 0
3798292 1957363 1957363 defendant Tiler Henry   606087 606087 Tiler, Henry, of Suffeld, ploughwright 0
3813919 1962262 1962262 defendant Symondys Robert husbandman 606087 606087 Symondys, Robert, of Suffeld, husbandman 0
3814115 1962318 1962318 defendant Symondys Robert husbandman 606087 606087 Symondys, Robert, of Suffeld, husbandman 0
3816085 1962933 1962933 defendant Carre Richard fletcher 606087 606087 Carre, Richard, of Suffeld, fletcher 0
3816086 1962933 1962933 defendant Doraunt John   606087 606087 Doraunt, John, of Suffeld, worsted weaver 1
3816087 1962933 1962933 defendant Polle George butcher 606087 606087 Polle, George, of Suffeld, butcher 2
3816108 1962938 1962938 defendant Carre Richard fletcher 606087 606087 Carre, Richard, of Suffeld, fletcher 0
3816110 1962939 1962939 defendant Carre Richard fletcher 606087 606087 Carre, Richard, of Suffeld, fletcher 0
3832273 1968008 1968008 defendant Newland George laborer 606087 606087 Newland, George, of Suffeld, laborer 0
3838076 1969824 1969824 plaintiff Symonde Robert   606087 606087 Symonde, Robert, of Suffeld 0
3841085 1970785 1970785 defendant Coke Richard husbandman 606087 606087 Coke, Richard, of Suffeld, husbandman 1
3885812 1985507 1985507 defendant Rysyng John bonesetter 606087 606087 Rysyng, John, of Suffeld, bonesetter 0
3899625 1990093 1990093 defendant Rysyng Richard bonesetter 606087 606087 Rysyng, Richard, of Suffeld, bonesetter 0
3910725 1993904 1993904 defendant Carre Richard fletcher 606087 606087 Carre, Richard, of Suffeld, fletcher 0
3910727 1993905 1993905 defendant Symondes Robert   606087 606087 Symondes, Robert, of Suffeld, worsted weaver 0
3943231 2004756 2004756 defendant Gryme Thomas gent 606087 606087 Gryme, Thomas, of Suffeld, gent 0
3953500 2008295 2008295 defendant Botyvaunt John yeoman 606087 606087 Botyvaunt, John, of Suffeld, yeoman 0
3979097 2017273 2017273 defendant Botyvaunte John yeoman 606087 606087 Botyvaunte, John, of Suffeld, yeoman 0
3994430 2022762 2022762 defendant Tyler Thomas husbandman 606087 606087 Tyler, Thomas, of Suffeld, husbandman 1
4109421 2063631 2063631 defendant Buttyvante Roger yeoman 606087 606087 Buttyvante, Roger, of Suffeld, yeoman 1
4177161 2087484 2087484 defendant Buttesant or Buttefant John husbandman 606087 606087 Buttesant or Buttefant, John, of Suffeld, husbandman 3
4178560 2087980 2087980 defendant Buttysant or Buttyfant John yeoman 606087 606087 Buttysant or Buttyfant, John, of Suffeld, yeoman 0
4200318 2095665 2095665 defendant Buttefaunt John husbandman 606087 606087 Buttefaunt, John, of Suffeld, husbandman 3
4226712 2104814 2104814 plaintiff Gryme Richard gent 606087 606087 Gryme, Richard, of Suffeld, gent 0
4717987 2270965 2270965 defendant Reed Thomas butcher 606087 606087 Reed, Thomas, of Suffeld, butcher 3
4724159 2272849 2272849 defendant Rede Thomas butcher 606087 606087 Rede, Thomas, of Suffeld, butcher 0
4840466 2308557 2308557 defendant Reed William yeoman 606087 606087 Reed, William, of Suffeld, yeoman 1
4921933 2333265 2333265 defendant Fox William laborer 606087 606087 Fox, William, of Suffeld, laborer 1
4997959 2356250 2356250 defendant Splytfote Thomas husbandman 606087 606087 Splytfote, Thomas, of suffeld, husbandman 1
5035204 2367160 2367160 defendant Pertryk Robert tailor 606087 606087 Pertryk, Robert, of Suffeld, tailor 0
5079409 2380337 2380337 defendant Russell William husbandman 606087 606087 Russell, William, of Suffeld, husbandman 3
5089986 2383447 2383447 defendant Rede Thomas butcher 606087 606087 Rede, Thomas, of Suffeld, butcher 1
5161775 2404549 2404549 defendant Bettys William husbandman 606087 606087 Bettys, William, of Suffeld, husbandman 0
5161776 2404549 2404549 defendant Belys John   606087 606087 Belys, John, of Suffeld, shipwright 1
5223069 2422460 2422460 defendant Wyrme John husbandman 606087 606087 Wyrme, John, of Suffeld, husbandman 4
5223080 2422461 2422461 defendant Wyrme John husbandman 606087 606087 Wyrme, John, of Suffeld, husbandman 3
5251734 2430648 2430648 defendant Tebald Robert husbandman 606087 606087 Tebald, Robert, of Suffeld, husbandman 2
5285040 2440648 2440648 defendant Tebald Robert yeoman 606087 606087 Tebald, Robert, of Suffeld, yeoman 1
5296901 2444085 2444085 defendant Worm John yeoman 606087 606087 Worm, John, of Suffeld, yeoman 0
5296902 2444085 2444085 defendant Belys William husbandman 606087 606087 Belys, William, of Suffeld, husbandman 1
5296903 2444085 2444085 defendant Rysyng Richard husbandman 606087 606087 Rysyng, Richard, of Suffeld, husbandman 2
5363690 2464296 2464296 defendant Wynter William husbandman 606087 606087 Wynter, William, of Suffeld, husbandman 2
5391322 2472598 2472598 defendant Roode Thomas butcher 606087 606087 Roode, Thomas, of Suffeld, butcher 5
5404272 2476298 2476298 defendant Reede Thomas butcher 606087 606087 Reede, Thomas, of Suffeld, butcher 4
5479240 2498808 2498808 defendant Wygnale John   606087 606087 Wygnale, John, of Suffeld, wright 3
5505952 2506783 2506783 defendant Brown Thomas husbandman 606087 606087 Brown, Thomas, of Suffeld, husbandman 3
5517462 2510302 2510302 defendant Browne John   606087 606087 Browne, John, of Suffeld, worsted weaver 0
5546985 2519123 2519123 defendant Lyon John husbandman 606087 606087 Lyon, John, of Suffeld, husbandman 0
5549453 2519893 2519893 defendant Symondes John   606087 606087 Symondes, John, of Suffeld, worsted weaver 0
5560846 2523144 2523144 defendant Symmys Thomas husbandman 606087 606087 Symmys, Thomas, of Suffeld, husbandman 1
5574336 2527062 2527062 defendant Symondys Robert   606087 606087 Symondys, Robert, of Suffeld, worsted weaver 0
5578969 2528492 2528492 defendant Larwode John husbandman 606087 606087 Larwode, John, of Suffeld, husbandman 2
5585966 2530662 2530662 defendant Symond Robert husbandman 606087 606087 Symond, Robert, of Suffeld, husbandman 7
5590803 2532095 2532095 defendant Flyte William butcher 606087 606087 Flyte, William, of Suffeld, butcher 0
5590805 2532096 2532096 defendant Tolwyn John   606087 606087 Tolwyn, John, of Suffeld, thick wool weaver 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);