names

43 rows where place_id = 633805

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3814893 1962574 1962574 defendant Pykeryng John yeoman 633805 633805 Pykeryng, John, of Barwell, yeoman 0
3814894 1962574 1962574 defendant Jakson Henry husbandman 633805 633805 Jakson, Henry, of Barwell, husbandman 1
3845502 1972147 1972147 defendant Sympson John yeoman 633805 633805 Sympson, John, of Barwell, yeoman 4
4004533 2026394 2026394 defendant Bradshawe John husbandman 633805 633805 Bradshawe, John, of Barwell, husbandman 3
4364591 2152393 2152393 defendant Onebye John yeoman 633805 633805 Onebye, John, of Barwell, yeoman 0
4372050 2155067 2155067 defendant Foster Robert husbandman 633805 633805 Foster, Robert, of Barwell, husbandman 1
4532120 2210311 2210311 defendant Freman William   633805 633805 Freman, William, of Barwell 1
4733569 2275676 2275676 defendant Taillour John tailor 633805 633805 Taillour, John, of Barwell, tailor 1
4773504 2287683 2287683 defendant Totnale John husbandman 633805 633805 Totnale, John, of Barwell, husbandman 1
4784157 2291045 2291045 defendant George Richard yeoman 633805 633805 George, Richard, of Barwell, Leicester, yeoman 0
4825609 2304051 2304051 defendant Buggeprest Thomas chaplain 633805 633805 Buggeprest, Thomas, of Barwell, chaplain 5
4825622 2304053 2304053 defendant Preest Thomas chaplain 633805 633805 Preest, Thomas, of Barwell, chaplain 3
4828085 2304828 2304828 defendant Edward John husbandman 633805 633805 Edward, John, of Barwell, husbandman 0
4828969 2305104 2305104 defendant Edward John husbandman 633805 633805 Edward, John, of Barwell, husbandman 0
4840766 2308649 2308649 defendant Totenhale John yeoman 633805 633805 Totenhale, John, of Barwell, yeoman 0
4855494 2313079 2313079 defendant Totnale John husbandman 633805 633805 Totnale, John, of Barwell, husbandman 1
4918195 2332211 2332211 defendant Helde John   633805 633805 Helde, John, of Barwell 3
4976493 2349934 2349934 defendant Jonson Thomas husbandman 633805 633805 Jonson, Thomas, of Barwell, husbandman 0
4976494 2349934 2349934 defendant Bray Thomas husbandman 633805 633805 Bray, Thomas, of Barwell, husbandman 1
4976495 2349934 2349934 defendant Grene Hugh   633805 633805 Grene, Hugh, of Barwell 2
4976496 2349934 2349934 defendant Randyll William husbandman 633805 633805 Randyll, William, of Barwell, husbandman 3
4976497 2349934 2349934 defendant Smyth John husbandman 633805 633805 Smyth, John, of Barwell, husbandman 4
4976498 2349934 2349934 defendant Smyth Thomas husbandman 633805 633805 Smyth, Thomas, of Barwell, husbandman 5
4976499 2349934 2349934 defendant atte Asshe John husbandman 633805 633805 atte Asshe, John, of Barwell, husbandman 6
4976500 2349934 2349934 defendant Bradley John husbandman 633805 633805 Bradley, John, of Barwell, husbandman 7
4976501 2349934 2349934 defendant Barleston Henry husbandman 633805 633805 Barleston, Henry, of Barwell, husbandman 8
4976502 2349934 2349934 defendant Boyer Roger husbandman 633805 633805 Boyer, Roger, of Barwell, husbandman 9
4976503 2349934 2349934 defendant Colleston John yeoman 633805 633805 Colleston, John, of Barwell, yeoman 10
4976504 2349934 2349934 defendant Gegge John husbandman 633805 633805 Gegge, John, of Barwell, husbandman 11
4991335 2354291 2354291 defendant Howes John gent 633805 633805 Howes, John, of Barwell, gent 1
4991336 2354291 2354291 defendant Maynard John husbandman 633805 633805 Maynard, John, of Barwell, husbandman 2
5092515 2384190 2384190 defendant Johnson Robert husbandman 633805 633805 Johnson, Robert, of Barwell, husbandman 3
5116734 2391328 2391328 defendant Curteys Richard husbandman 633805 633805 Curteys, Richard, of Barwell, husbandman 0
5295627 2443711 2443711 defendant Hyndeman Robert husbandman 633805 633805 Hyndeman, Robert, of Barwell, husbandman 3
5359707 2463074 2463074 defendant Eyre Robert husbandman 633805 633805 Eyre, Robert, of Barwell, husbandman 0
5360302 2463258 2463258 defendant Kysse Richard husbandman 633805 633805 Kysse, Richard, of Barwell, husbandman 0
5367555 2465500 2465500 defendant Eyre Robert husbandman 633805 633805 Eyre, Robert, of Barwell, husbandman 0
5367556 2465500 2465500 defendant Denet John husbandman 633805 633805 Denet, John, of Barwell, husbandman 1
5367557 2465500 2465500 defendant Bray Henry husbandman 633805 633805 Bray, Henry, of Barwell, husbandman 2
5367558 2465500 2465500 defendant Hille Robert hsubandman 633805 633805 Hille, Robert, of Barwell, hsubandman 3
5367559 2465500 2465500 defendant Dale Thomas miller 633805 633805 Dale, Thomas, of Barwell, miller 4
5600061 2534903 2534903 defendant Wryght Roger husbandman 633805 633805 Wryght, Roger, of Barwell, husbandman 0
5616707 2549028 2549028 defendant Othel William butcher 633805 633805 Othel, William, of Barwell, butcher 1

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