names

44 rows where place_id = 627089

✎ 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
3774119 1949619 1949619 defendant Wakeman Richard yeoman 627089 627089 Wakeman, Richard, of Teukesbury, Glos, yeoman 2
3860942 1977148 1977148 defendant Oselook Richard saddler 627089 627089 Oselook, Richard, of Teukesbury, Glos, saddler 1
3870442 1980359 1980359 defendant Hawkyns Richard   627089 627089 Hawkyns, Richard, of Teukesbury, Glos, horse courser 0
4864918 2316002 2316002 defendant Bradwey Walter ironmonger 627089 627089 Bradwey, Walter, of Teukesbury, Glos, ironmonger 1
4874346 2318920 2318920 defendant Monnyng John bowyer 627089 627089 Monnyng, John, of Teukesbury, Glos, bowyer 0
4886401 2322607 2322607 defendant Horsley Thomas chapman 627089 627089 Horsley, Thomas, of Teukesbury, Glos, chapman 2
4889002 2323351 2323351 defendant Horsley Thomas chapman 627089 627089 Horsley, Thomas, of Teukesbury, Glos, chapman 2
4903699 2327774 2327774 defendant Roket Robert husbandman 627089 627089 Roket, Robert, of Teukesbury, Glos, husbandman 0
4934685 2337241 2337241 defendant Draper Edmund merchant 627089 627089 Draper, Edmund, of Teukesbury, Glos, merchant 0
4940972 2339201 2339201 defendant Kene John chapman 627089 627089 Kene, John, of Teukesbury, Glos, chapman 1
4945898 2340701 2340701 defendant Barbour Thomas merchant 627089 627089 Barbour, Thomas, of Teukesbury, Glos, merchant 0
4945900 2340702 2340702 defendant Barbour Thomas merchant 627089 627089 Barbour, Thomas, of Teukesbury, Glos, merchant 0
4962755 2345769 2345769 defendant Tommes Richard gent 627089 627089 Tommes, Richard, of Teukesbury, Glos, gent 1
4964093 2346172 2346172 defendant Lewys Thomas merchant 627089 627089 Lewys, Thomas, of Teukesbury, Glos, merchant 0
4970884 2348236 2348236 defendant Burneham John hosier 627089 627089 Burneham, John, of Teukesbury, Glos, hosier 0
4982143 2351577 2351577 defendant Bettys John, junior gent 627089 627089 Bettys, John, junior, of Teukesbury, Glos, gent 2
5014259 2361024 2361024 defendant Horsley Thomas chapman 627089 627089 Horsley, Thomas, of Teukesbury, Glos, chapman 0
5029470 2365491 2365491 defendant Bette John gent 627089 627089 Bette, John, of Teukesbury, Glos, gent 3
5030604 2365822 2365822 defendant Neell John merchant 627089 627089 Neell, John, of Teukesbury, Glos, merchant 0
5053627 2372687 2372687 defendant West John dyer 627089 627089 West, John, of Teukesbury, Glos, dyer 0
5078264 2379987 2379987 defendant Adkyns John dyer 627089 627089 Adkyns, John, of Teukesbury, Glos, dyer 0
5078352 2380019 2380019 defendant Weston Richard chapman 627089 627089 Weston, Richard, of Teukesbury, Glos, chapman 0
5084161 2381768 2381768 defendant Tollyng John yeoman 627089 627089 Tollyng, John, of Teukesbury, Glos, yeoman 1
5084170 2381770 2381770 defendant Tollyng John yeoman 627089 627089 Tollyng, John, of Teukesbury, Glos, yeoman 1
5110807 2389560 2389560 defendant Browderer Richard embroiderer 627089 627089 Browderer, Richard, of Teukesbury, Glos, embroiderer 0
5115608 2390993 2390993 defendant Wye John   627089 627089 Wye, John, of Teukesbury, Glos, bell maker 0
5226337 2423370 2423370 defendant Elyot Nicholas wheeler 627089 627089 Elyot, Nicholas, of Teukesbury, Glos, wheeler 0
5226954 2423540 2423540 defendant Freman Richard mercer 627089 627089 Freman, Richard, of Teukesbury, Glos, mercer 1
5229804 2424338 2424338 defendant Whitfader John mercer 627089 627089 Whitfader, John, of Teukesbury, Glos, mercer 1
5230233 2424462 2424462 defendant Weston Richard chapman 627089 627089 Weston, Richard, of Teukesbury, Glos, chapman 1
5230239 2424463 2424463 defendant Weston Richard chapman 627089 627089 Weston, Richard, of Teukesbury, Glos, chapman 1
5285443 2440764 2440764 defendant Mongomery Edward butcher 627089 627089 Mongomery, Edward, of Teukesbury, Glos, butcher 2
5288440 2441638 2441638 defendant Sever Richard chapman 627089 627089 Sever, Richard, of Teukesbury, Glos, chapman 0
5294307 2443309 2443309 defendant Booges William chapman 627089 627089 Booges, William, of Teukesbury, Glos, chapman 0
5313007 2448921 2448921 defendant Huchens Robert yeoman 627089 627089 Huchens, Robert, of Teukesbury, Glos, yeoman 0
5327938 2453425 2453425 defendant Hygons Thomas hosier 627089 627089 Hygons, Thomas, of Teukesbury, Glos, hosier 1
5360318 2463263 2463263 defendant Comyn Henry yeoman 627089 627089 Comyn, Henry, of Teukesbury, Glos, yeoman 0
5362330 2463874 2463874 defendant Burgeys Richard mercer 627089 627089 Burgeys, Richard, of Teukesbury, Glos, mercer 1
5496217 2503769 2503769 defendant Bevysse or Benysse Thomas mercer 627089 627089 Bevysse or Benysse, Thomas, of Teukesbury, Glos, mercer 0
5501966 2505539 2505539 defendant Walter Roger gent 627089 627089 Walter, Roger, of Teukesbury, Glos, gent 0
5502891 2505817 2505817 defendant Boyce William mercer 627089 627089 Boyce, William, of Teukesbury, Glos, mercer 1
5511168 2508331 2508331 defendant Bevysse or Benysse Thomas mercer 627089 627089 Bevysse or Benysse, Thomas, of Teukesbury, Glos, mercer 0
5534257 2515247 2515247 defendant Samson Thomas carrier 627089 627089 Samson, Thomas, of Teukesbury, Glos, carrier 0
5630583 2553574 2553574 defendant Aleyne Thomas   627089 627089 Aleyne, Thomas, of Teukesbury, Glos, linen draper 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);