names

48 rows where place_id = 596622

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3625533 1875525 1875525 plaintiff Woode John gent 596622 596622 Woode, John, of Fulburne, gent 0
3625535 1875525 1875525 defendant Stede Nicholas husbandman 596622 596622 Stede, Nicholas, of Fulburne, husbandman 1
3656256 1912202 1912202 defendant Dryver William   596622 596622 Dryver, William, of Fulburne, husbandman, son of John 1
3860795 1977102 1977102 defendant Hogeskyn Thomas laborer 596622 596622 Hogeskyn, Thomas, of Fulburne, laborer 0
4468885 2190948 2190948 defendant Dylly Roger   596622 596622 Dylly, Roger, of Fulburne 0
4481911 2195051 2195051 defendant Shene John   596622 596622 Shene, John, of Fulburne 1
4528350 2209139 2209139 defendant Salman Rober   596622 596622 Salman, Rober, of Fulburne 0
4545178 2214414 2214414 defendant Petyt John chaplain 596622 596622 Petyt, John, of Fulburne, chaplain 0
4612420 2234953 2234953 defendant Weston Thomas   596622 596622 Weston, Thomas, of Fulburne 0
4652918 2246844 2246844 defendant Salman John husbandman 596622 596622 Salman, John, of Fulburne, husbandman 3
4708302 2267970 2267970 plaintiff Neweport William esq 596622 596622 Neweport, William, of Fulburne, esq 0
4708303 2267970 2267970 plaintiff Culpy John   596622 596622 Culpy, John, of Fulburne 1
4715834 2270266 2270266 defendant Whytyng Thomas husbandman 596622 596622 Whytyng, Thomas, of Fulburne, husbandman 4
4715835 2270266 2270266 defendant Salaman Roger husbandman 596622 596622 Salaman, Roger, of Fulburne, husbandman 5
4715838 2270267 2270267 defendant Culpe John husbandman 596622 596622 Culpe, John, of Fulburne, husbandman 1
4724407 2272929 2272929 defendant Asschby Robert butcher 596622 596622 Asschby, Robert, of Fulburne, butcher 0
4755410 2282075 2282075 defendant Jote Robert   596622 596622 Jote, Robert, of Fulburne, shepherd 0
4755411 2282075 2282075 defendant Whytyng Thomas husbandman 596622 596622 Whytyng, Thomas, of Fulburne, husbandman 1
4755412 2282075 2282075 defendant Treve or Trene Henry husbandman 596622 596622 Treve or Trene, Henry, of Fulburne, husbandman 2
4755413 2282075 2282075 defendant Clement John tailor 596622 596622 Clement, John, of Fulburne, tailor 3
4755414 2282075 2282075 defendant Whiteby John laborer 596622 596622 Whiteby, John, of Fulburne, laborer 4
4763837 2284683 2284683 defendant Clement John tailor 596622 596622 Clement, John, of Fulburne, tailor 0
4768585 2286155 2286155 plaintiff Culpy John   596622 596622 Culpy, John, of Fulburne 1
4772370 2287323 2287323 plaintiff Careawey John   596622 596622 Careawey, John, of Fulburne, parson 5
4779274 2289496 2289496 defendant Whytyng Thomas husbandman 596622 596622 Whytyng, Thomas, of Fulburne, husbandman 1
4779275 2289496 2289496 defendant Burgeys Roger husbandman 596622 596622 Burgeys, Roger, of Fulburne, husbandman 2
4791038 2293290 2293290 defendant Jekell John husbandman 596622 596622 Jekell, John, of Fulburne, husbandman 0
4793216 2293973 2293973 plaintiff Newport William esq 596622 596622 Newport, William, of Fulburne, esq 0
4800582 2296364 2296364 defendant Joce Robert husbandman 596622 596622 Joce, Robert, of Fulburne, husbandman 1
4890763 2323861 2323861 defendant Salman Roger husbandman 596622 596622 Salman, Roger, of Fulburne, husbandman 0
4890767 2323861 2323861 defendant Jekell John husbandman 596622 596622 Jekell, John, of Fulburne, husbandman 4
4901768 2327159 2327159 defendant Jote Robert   596622 596622 (Jote, Robert, of Fulburne 2
4939069 2338604 2338604 defendant Russell Thomas yeoman 596622 596622 Russell, Thomas, of Fulburne, yeoman 3
4957968 2344352 2344352 plaintiff Wode William   596622 596622 Wode, William, of Fulburne 0
4958240 2344434 2344434 plaintiff Wryght Richard   596622 596622 Wryght, Richard, of Fulburne 0
5122771 2393095 2393095 defendant Bolossome William husbandman 596622 596622 Bolossome, William, of Fulburne, husbandman 0
5122772 2393095 2393095 defendant Gate John husbandman 596622 596622 Gate, John, of Fulburne, husbandman 1
5122773 2393095 2393095 defendant Gynne Roger husbandman 596622 596622 Gynne, Roger, of Fulburne, husbandman 2
5122774 2393095 2393095 defendant Whityng William husbandman 596622 596622 Whityng, William, of Fulburne, husbandman 3
5289419 2441907 2441907 defendant Whityng William yeoman 596622 596622 Whityng, William, of Fulburne, yeoman 3
5364508 2464557 2464557 defendant Stede Nicholas husbandman 596622 596622 Stede, Nicholas, of Fulburne, husbandman 0
5364509 2464557 2464557 defendant Stede Henry husbandman 596622 596622 Stede, Henry, of Fulburne, husbandman 1
5364510 2464557 2464557 defendant Avenaunt William husbandman 596622 596622 Avenaunt, William, of Fulburne, husbandman 2
5523521 2512186 2512186 defendant Woode John gent 596622 596622 Woode, John, of Fulburne, gent 0
5630183 2553446 2553446 defendant Treve Henry yeoman 596622 596622 Treve, Henry, of Fulburne, yeoman 0
5630187 2553447 2553447 defendant Treve Henry yeoman 596622 596622 Treve, Henry, of Fulburne, yeoman 0
5630425 2553527 2553527 defendant Grenevyll John husbandman 596622 596622 Grenevyll, John, of Fulburne, husbandman 0
5635247 2554992 2554992 defendant Assby Robert butcher 596622 596622 Assby, Robert, of Fulburne, 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);