names

35 rows where place_id = 603356

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654280 1911597 1911597 defendant Fratsam John carpenter 603356 603356 Fratsam, John, of Pykworth, carpenter 0
4428477 2173723 2173723 plaintiff Strubby William   603356 603356 Strubby, William, of Pykworth, parson 0
4428479 2173724 2173724 plaintiff Strubby William   603356 603356 Strubby, William, of Pykworth, parson 0
4495901 2199397 2199397 defendant Hervy William   603356 603356 Hervy, William, of Pykworth 0
4567610 2221436 2221436 defendant Thorp John   603356 603356 Thorp, John, of Pykworth 0
4629252 2240085 2240085 plaintiff Smyth Robert   603356 603356 Smyth, Robert, of Pykworth 0
4631827 2240837 2240837 defendant Brounyng Walter   603356 603356 Brounyng, Walter, of Pykworth 0
4631829 2240838 2240838 defendant Shepton John   603356 603356 Shepton, John, of Pykworth 0
4631830 2240838 2240838 defendant Brounyng Walter   603356 603356 Brounyng, Walter, of Pykworth 1
4650845 2246266 2246266 defendant Smyth William   603356 603356 Smyth, William, of Pykworth 3
4682512 2260157 2260157 defendant Stepyng John husbandman 603356 603356 Stepyng, John, of Pykworth, husbandman 2
4682513 2260157 2260157 defendant Shupton John husbandman 603356 603356 Shupton, John, of Pykworth, husbandman 3
4693546 2263482 2263482 defendant Gardon John husbandman 603356 603356 Gardon, John, of Pykworth, husbandman 0
4705453 2267073 2267073 defendant Deye Nicholas husbandman 603356 603356 Deye, Nicholas, of Pykworth, husbandman 1
4737545 2276855 2276855 defendant Brounyng Walter husbandman 603356 603356 Brounyng, Walter, of Pykworth, husbandman 0
4769422 2286411 2286411 defendant Geffrey Thomas husbandman 603356 603356 Geffrey, Thomas, of Pykworth, husbandman 1
4809603 2299167 2299167 defendant shupton John yeoman 603356 603356 shupton, John, of Pykworth, yeoman 2
4814396 2300612 2300612 defendant Cloke Henry clerk 603356 603356 Cloke, Henry, of Pykworth, clerk 2
4820511 2302485 2302485 defendant Geffray Thomas husbandman 603356 603356 Geffray, Thomas, of Pykworth, husbandman 5
4820512 2302485 2302485 defendant Shipton John yeoman 603356 603356 Shipton, John, of Pykworth, yeoman 6
4820513 2302485 2302485 defendant Stepyng John husbandman 603356 603356 Stepyng, John, of Pykworth, husbandman 7
4820628 2302524 2302524 defendant Shipton John husbandman 603356 603356 Shipton, John, of Pykworth, husbandman 2
4829716 2305339 2305339 defendant Geffrey Thomas husbandman 603356 603356 Geffrey, Thomas, of Pykworth, husbandman 2
4829717 2305339 2305339 defendant Stokton Thomas husbandman 603356 603356 Stokton, Thomas, of Pykworth, husbandman 3
4829718 2305339 2305339 defendant Stokton John husbandman 603356 603356 Stokton, John, of Pykworth, husbandman 4
4829719 2305339 2305339 defendant Wylymot Thomas yeoman 603356 603356 Wylymot, Thomas, of Pykworth, yeoman 5
4869592 2317449 2317449 defendant Shipton John husbandman 603356 603356 Shipton, John, of Pykworth, husbandman 0
4869594 2317450 2317450 defendant Shipton John husbandman 603356 603356 Shipton, John, of Pykworth, husbandman 0
4882071 2321288 2321288 defendant Shipton John yeoman 603356 603356 Shipton, John, of Pykworth, yeoman 0
4892761 2324461 2324461 defendant Cissetson John husbandman 603356 603356 Cissetson, John, of Pykworth, husbandman 0
4916976 2331814 2331814 defendant Harrsyon Thomas husbandman 603356 603356 Harrsyon, Thomas, of Pykworth, husbandman 0
5069029 2377236 2377236 defendant Bawedwyn Thomas   603356 603356 Bawedwyn, Thomas, of Pykworth, administrators of 0
5522448 2511840 2511840 defendant Jercok Richard chaplain 603356 603356 Jercok, Richard, of Pykworth, chaplain 0
5593688 2533013 2533013 defendant Fissher William husbandman 603356 603356 Fissher, William, of Pykworth, husbandman 0
5593690 2533014 2533014 defendant Wodeforth Richard yeoman 603356 603356 Wodeforth, Richard, of Pykworth, 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);