names

32 rows where place_id = 593344

✎ 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
3611416 1871247 1871247 defendant Duffyn John, senior gent 593344 593344 Duffyn, John, senior, of Islep, gent 0
3611417 1871247 1871247 defendant Duffyn John, junior gent 593344 593344 Duffyn, John, junior, of Islep, gent 1
3640488 1907457 1907457 plaintiff Andrewes Thomas   593344 593344 Andrewes, Thomas, of Islep 0
3699345 1926012 1926012 defendant Venton Robert smith 593344 593344 Venton, Robert, of Islep, smith 0
4416055 2169907 2169907 defendant all 5 being cousins & heirs of Ralph de Tychemersh; Robert le Masoun   593344 593344 all 5 being cousins & heirs of Ralph de Tychemersh;, Robert le Masoun, of Islep, chaplain, who vouched to warrant Geoffrey de Beaumeys, who defaulted 5
4433949 2175379 2175379 plaintiff Hemmyngburgh Robert de   593344 593344 Hemmyngburgh, Robert de, of Islep, parson 0
4451567 2185460 2185460 defendant Gerveys John   593344 593344 Gerveys, John, of Islep 0
4498853 2200275 2200275 defendant Curteys William   593344 593344 Curteys, William, of Islep 0
4511882 2204164 2204164 defendant Curteys William   593344 593344 Curteys, William, of Islep 1
4516545 2205582 2205582 defendant Herdewyk John   593344 593344 Herdewyk, John, of Islep 3
4561071 2219416 2219416 defendant Hurne Wilia   593344 593344 Hurne, Wilia, of Islep 1
4572111 2222830 2222830 defendant Duffyn John   593344 593344 Duffyn, John, of Islep 9
4580081 2225258 2225258 defendant Duffyn John   593344 593344 Duffyn, John, of Islep 0
4584576 2226593 2226593 defendant Duffyn John   593344 593344 Duffyn, John, of Islep 0
4584919 2226715 2226715 defendant Dancastre John shoemaker 593344 593344 Dancastre, John, of Islep, shoemaker 0
4587400 2227467 2227467 defendant Curteys William   593344 593344 Curteys, William, of Islep 3
4865752 2316254 2316254 plaintiff Gorge William   593344 593344 Gorge, William, of Islep 0
4891944 2324218 2324218 defendant Whitlyng Richard husbandman 593344 593344 Whitlyng, Richard, of Islep, husbandman 1
4982327 2351630 2351630 defendant Gurdon Thomas, junior husbandman 593344 593344 Gurdon, Thomas, junior, of Islep, husbandman 0
4985163 2352491 2352491 defendant Duffyn John gent 593344 593344 Duffyn, John, of Islep, gent 0
4993886 2355040 2355040 defendant Wery William husbandman 593344 593344 Wery, William, of Islep, husbandman 0
5045385 2370249 2370249 defendant Nicoll John husbandman 593344 593344 Nicoll, John, of Islep, husbandman 1
5068443 2377061 2377061 defendant Wery William husbandman 593344 593344 Wery, William, of Islep, husbandman 2
5093293 2384435 2384435 defendant Veyse John husbandman 593344 593344 Veyse, John, of Islep, husbandman 0
5222258 2422217 2422217 defendant Tewe Robert husbandman 593344 593344 Tewe, Robert, of Islep, husbandman 1
5228061 2423813 2423813 defendant Elisson Henry miller 593344 593344 Elisson, Henry, of Islep, miller 3
5368324 2465709 2465709 defendant Sparke Henry butcher 593344 593344 Sparke, Henry, of Islep, butcher 0
5391154 2472546 2472546 defendant Sparke Henry butcher 593344 593344 Sparke, Henry, of Islep, butcher 0
5489200 2501652 2501652 defendant Duffyn John gent 593344 593344 Duffyn, John, of Islep, gent 0
5491352 2502301 2502301 defendant Broun John husbandman 593344 593344 Broun, John, of Islep, husbandman 1
5572362 2526468 2526468 defendant Achirche William husbandman 593344 593344 Achirche, William, of Islep, husbandman 4
5596581 2533849 2533849 defendant Byrt John yeoman 593344 593344 Byrt, John, of Islep, yeoman 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);