names

41 rows where place_id = 643620

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3874923 1981838 1981838 defendant Loksmyth Leonard husbandman 643620 643620 Loksmyth, Leonard, of Felbrigge, husbandman 0
3881798 1984164 1984164 defendant Loksmyth Leonard husbandman 643620 643620 Loksmyth, Leonard, of Felbrigge, husbandman 0
4053755 2043723 2043723 defendant Wyndam Roger esq 643620 643620 Wyndam, Roger, of Felbrigge, esq 0
4053756 2043723 2043723 defendant Brigges Robert   643620 643620 Brigges, Robert, of Felbrigge, shepherd 1
4074648 2051235 2051235 defendant Wyndam Roger esq 643620 643620 Wyndam, Roger, of Felbrigge, esq 0
4118634 2066956 2066956 defendant Wyndam Roger esq 643620 643620 Wyndam, Roger, of Felbrigge, esq 0
4118636 2066957 2066957 defendant Wyndam Roger esq 643620 643620 Wyndam, Roger, of Felbrigge, esq 0
4143600 2075919 2075919 defendant Wyndam Roger esq 643620 643620 Wyndam, Roger, of Felbrigge, esq 0
4143607 2075921 2075921 defendant Wyndam Roger esq 643620 643620 Wyndam, Roger, of Felbrigge, esq 0
4157829 2080815 2080815 defendant Bugdon William husbandman 643620 643620 Bugdon, William, of Felbrigge, husbandman 1
4160928 2081893 2081893 defendant Eastyng William carpenter 643620 643620 Eastyng, William, of Felbrigge, carpenter 1
4172191 2085736 2085736 defendant Jerveis William grocer 643620 643620 Jerveis, William, of Felbrigge, gent, grocer 0
4175228 2086799 2086799 defendant Jarvys William Master of Arts 643620 643620 Jarvys, William, of Felbrigge, gent, Master of Arts 0
4178794 2088061 2088061 defendant Jervice William gent 643620 643620 Jervice, William, of Felbrigge, gent 1
4197358 2094631 2094631 defendant Estowe John husbandman 643620 643620 Estowe, John, of Felbrigge, husbandman 1
4252143 2113702 2113702 defendant Swane William husbandman 643620 643620 Swane, William, of Felbrigge, husbandman 1
4263297 2117390 2117390 defendant Gaye John yeoman 643620 643620 Gaye, John, of Felbrigge, yeoman 0
4271134 2119922 2119922 defendant Wyndam Roger esq 643620 643620 Wyndam, Roger, of Felbrigge, esq 0
4283583 2124166 2124166 defendant Andrewes Thomas husbandman 643620 643620 Andrewes, Thomas, of Felbrigge, husbandman 2
4283584 2124166 2124166 defendant Ryse Nicholas yeoman 643620 643620 Ryse, Nicholas, of Felbrigge, yeoman 3
4291153 2126902 2126902 defendant Jerveys William gent 643620 643620 Jerveys, William, of Felbrigge, gent 0
4305734 2132144 2132144 defendant Wyndam Roger esq 643620 643620 Wyndam, Roger, of Felbrigge, esq 0
4329252 2140096 2140096 defendant Foxe Nicholas husbandman 643620 643620 Foxe, Nicholas, of Felbrigge, husbandman 1
4334684 2141869 2141869 defendant Shortinge John husbandman 643620 643620 Shortinge, John, of Felbrigge, husbandman 3
4334688 2141870 2141870 defendant Laycock John warrener 643620 643620 Laycock, John, of Felbrigge, warrener 2
4334689 2141870 2141870 defendant Bond Thomas yeoman 643620 643620 Bond, Thomas, of Felbrigge, yeoman 3
4335101 2142011 2142011 defendant Wyndham Roger esq 643620 643620 Wyndham, Roger, of Felbrigge, esq 0
4336457 2142486 2142486 defendant Wyndam Roger esq 643620 643620 Wyndam, Roger, of Felbrigge, esq 0
4351347 2147721 2147721 defendant Pynner William husbandman 643620 643620 Pynner, William, of Felbrigge, husbandman 0
4352627 2148153 2148153 defendant Wyndham Roger esq 643620 643620 Wyndham, Roger, of Felbrigge, esq 0
4365473 2152718 2152718 defendant Jervyce William Master of Arts 643620 643620 Jervyce, William, of Felbrigge, gent, Master of Arts 0
4392520 2162119 2162119 defendant Jervyce William Master of Arts 643620 643620 Jervyce, William, of Felbrigge, gent, Master of Arts 0
4566064 2220942 2220942 defendant Brayd John   643620 643620 Brayd, John, of Felbrigge 0
4691490 2262863 2262863 plaintiff Yemme John   643620 643620 Yemme, John, of Felbrigge, parson, on his own acount 0
4744179 2278824 2278824 defendant Reyner Simon yeoman 643620 643620 Reyner, Simon, of Felbrigge, yeoman 2
4797356 2295345 2295345 defendant Donkys or Doukys John yeoman 643620 643620 Donkys or Doukys, John, of Felbrigge, yeoman 4
4809708 2299199 2299199 defendant Aldwyn John yeoman 643620 643620 Aldwyn, John, of Felbrigge, yeoman 0
4855361 2313031 2313031 defendant Felbrigge Roger esq 643620 643620 Felbrigge, Roger, of Felbrigge, esq 1
4879542 2320528 2320528 defendant Felbrigge Roger esq 643620 643620 Felbrigge, Roger, of Felbrigge, esq 1
4883324 2321708 2321708 defendant Felbrigge Simon   643620 643620 Felbrigge, Simon, of Felbrigge, knight 6
4889112 2323384 2323384 defendant Felbrigge Simon   643620 643620 Felbrigge, Simon, of Felbrigge, knight 6

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